Viewing file:  clsrg_HrPerUnit.php (1.39 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class rg_HrPerUnit--------------------------
include_once "clsbase_rg_HrPerUnit.php";
class rg_HrPerUnit extends base_rg_HrPerUnit{
function RSrg_HrPerUnitOrderAcYDescTmIdDescSstId(){
$this->SetQuery("select * from rg_UnitConfig h, rg_LoadType l
where h.ucLtId=l.ltId order by ucAcY desc, ucTmId desc, ltStId");
}
function RSrg_HrPerUnitOrderAcYDescTmIdDescSstIdLimit($start, $pageSize){
$this->SetQuery("select * from rg_UnitConfig h, rg_LoadType l
where h.ucLtId=l.ltId order by ucAcY desc, ucTmId desc, ltStId
limit $start, $pageSize");
}
function RSrg_HrPerUnitByAcYAndTmId($acY, $tmId){
$this->SetQuery("select * from rg_UnitConfig where ucAcY='$acY' and ucTmId='$tmId'");
}
function RSrg_HrPerUnitByAcYAndTmIdAndDefaultIsYAndSstId($acY, $tmId, $stId){
$this->SetQuery("select * from rg_UnitConfig h, rg_LoadType l
where ucAcY='$acY' and ucTmId='$tmId' and ucDefault='Y'
and h.ucLtId=l.ltId and ltStId='$stId'");
}
function RSrg_HrPerUnitByAcYAndTmIdAndNotLtIdAndSstId($acY, $tmId, $ltId, $stId){
$this->SetQuery("select * from rg_UnitConfig h, rg_LoadType l
where ucAcY='$acY' and ucTmId='$tmId' and ucLtId!='$ltId'
and h.ucLtId=l.ltId and ltStId='$stId'");
}
function RSrg_HrPerUnitByLtId($ltId){
$this->SetQuery("select * from rg_UnitConfig where ucLtId='$ltId'");
}
} //--End class rg_HrPerUnit--
?>
|