Viewing file:  clscheckpersonperday.php (3.47 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class Checkpersonperday--------------------------
//--PK of Checkpersonperday ::
// 1. seqId
// 2. personId
include_once "clsDB.php";
class Checkpersonperday extends db{
var $result;
var $seqId;
var $startDate;
var $endDate;
var $assignpersonId;
var $personId;
var $flag;
function Checkpersonperday(&$c){
$this->c=$c;
}
function Save(){
if ($this->status==1){
//uncomment a line below if your table use ID as running number
//$this->Array=$this->GetNextCode();
$sql = "insert into Checkpersonperday values(
'$this->seqId',
'$this->startDate',
'$this->endDate',
'$this->assignpersonId',
'$this->personId',
'$this->flag'
)";
}else {
$sql = "update Checkpersonperday set
startDate='$this->startDate',
endDate='$this->endDate',
assignpersonId='$this->assignpersonId',
flag='$this->flag'
where seqId='$this->seqId' and personId='$this->personId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from Checkpersonperday where seqId='$this->seqId' and personId='$this->personId'");
}
function GetNextCode(){
$this->SetQuery("select max(seqId) as num from Checkpersonperday");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSCheckpersonperday(){
$this->SetQuery("select * from Checkpersonperday");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->seqId = $this->result['seqId'];
$this->startDate = $this->result['startDate'];
$this->endDate = $this->result['endDate'];
$this->assignpersonId = $this->result['assignpersonId'];
$this->personId = $this->result['personId'];
$this->flag = $this->result['flag'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey1, $xKey2){
if ($this->SetQuery("select * from Checkpersonperday where seqId='$xKey1' and personId='$xKey2'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function SearchByflag($xKey1, $xKey2){
if ($this->SetQuery("select * from Checkpersonperday where personId='$xKey1' and flag='$xKey2'")){
return 1;
}else {
return 0;
}
}
function Delrec($xKey1, $xKey2){
return $this->Dml("delete from Checkpersonperday where personId='$xKey1' and flag='$xKey2'");
}
function DelrecBydate($xKey1, $xKey2, $xKey3){
//echo "delete from Checkpersonperday where personId='$xKey1' and startDate ='$xKey2' and endDate = '$xKey3'";
return $this->Dml("delete from Checkpersonperday where personId='$xKey1' and startDate ='$xKey2' and endDate = '$xKey3'");
}
function SearchBypsdate($xKey1, $xKey2, $xKey3){
if ($this->SetQuery("select * from Checkpersonperday where personId='$xKey1' and startDate <='$xKey2' and endDate >= '$xKey3'")){
return 1;
}else {
return 0;
}
}
function SearchBypsdate2($xKey1, $xKey2, $xKey3){
if ($this->SetQuery("select * from Checkpersonperday where personId='$xKey1' and startDate ='$xKey2' and endDate = '$xKey3'")){
return 1;
}else {
return 0;
}
}
// ---------- Start Esupport ----------
function RSCheckpersonperdayByPsIdAndBetweenDate($psId, $date){
$this->SetQuery("select * from Checkpersonperday
where personId='$psId' and '$date' between startDate and endDate");
}
function RSCheckpersonperdayByPsIdAndAssignPsIdAndBetweenDate($psId, $aPsId, $date){
$this->SetQuery("select * from Checkpersonperday
where personId='$psId' and assignpersonId='$aPsId' and '$date' between startDate and endDate");
}
// ---------- End Esupport ----------
} //--End class Checkpersonperday--
?>
|