Viewing file: clsrg_ExternalPlace.php (1.38 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class rg_ExternalPlace--------------------------
include_once "clsbase_rg_ExternalPlace.php";
class rg_ExternalPlace extends base_rg_ExternalPlace{
function RSrg_ExternalPlaceGroupMepId(){
$this->SetQuery("select etpMepId from rg_ExternalPlace group by etpMepId");
}
function RSrg_ExternalPlaceGroupSepId(){
$this->SetQuery("select etpSepId from rg_ExternalPlace group by etpSepId");
}
function RSrg_ExternalPlaceOrderMepNameSepNameLimit($start, $pageSize){
$this->SetQuery("select e.* from rg_ExternalPlace e, rg_MainExternalPlace m, rg_SubExternalPlace s
where e.etpMepId=m.mepId and e.etpSepId=s.sepId
order by mepName, sepName limit $start, $pageSize");
}
function RSrg_ExternalPlaceByMepIdOrSepId($mepId, $sepId){
$this->SetQuery("select * from rg_ExternalPlace where etpMepId='$mepId' or etpSepId='$sepId'");
}
function RSrg_ExternalPlaceByMepIdOrSepIdOrderMepNameSepNameLimit($mepId, $sepId, $start, $pageSize){
$this->SetQuery("select e.* from rg_ExternalPlace e, rg_MainExternalPlace m, rg_SubExternalPlace s
where (etpMepId='$mepId' or etpSepId='$sepId') and e.etpMepId=m.mepId and e.etpSepId=s.sepId
order by mepName, sepName limit $start, $pageSize");
}
function RSrg_ExternalPlaceByMepId($mepId){
$this->SetQuery("select * from rg_ExternalPlace where etpMepId='$mepId'");
}
} //--End class rg_ExternalPlace--
?>
|