Viewing file:  clsrg_WeekDate.php (1.35 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class rg_WeekDate--------------------------
include_once "clsbase_rg_WeekDate.php";
class rg_WeekDate extends base_rg_WeekDate{
function RSrg_WeekDateGroupAcYOrderAcY(){
$this->SetQuery("select wdAcY from rg_WeekDate group by wdAcY order by wdAcY desc");
}
function RSrg_WeekDateGroupAcYOrderAcYLimit($start, $pageSize){
$this->SetQuery("select wdAcY from rg_WeekDate group by wdAcY order by wdAcY desc limit $start, $pageSize");
}
function RSrg_WeekDateByAcY($acY){
$this->SetQuery("select * from rg_WeekDate where wdAcY='$acY' order by wdAcYWeekNo");
}
function GetMinFrDateByAcYAndTmId($acY, $tmId){
$this->SetQuery("select min(wdFrDate) as num from rg_WeekDate where wdAcY='$acY' and wdTmId='$tmId'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSrg_WeekDateByDate($date){
$this->SetQuery("select * from rg_WeekDate where '$date' between wdFrDate and wdToDate");
}
function GetMinAcYWeekNoByAcY($acY){
$this->SetQuery("select min(wdAcYWeekNo) as num from rg_WeekDate where wdAcY='$acY'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxAcYWeekNoByAcY($acY){
$this->SetQuery("select max(wdAcYWeekNo) as num from rg_WeekDate where wdAcY='$acY'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
} //--End class rg_WeekDate--
?>
|