Viewing file:  clsUmMenuR.php (1.88 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include_once("clsUmMenu.php");
class ummenur extends ummenu {
function GetRecord(){
$ret = parent::GetRecord();
$this->Mseq = $this->result['Mseq'];
$this->MmnID = $this->result['MmnID'];
$this->MmnNameT = $this->result['MmnNameT'];
$this->SMseq = $this->result['SMseq'];
$this->SMmnID = $this->result['SMmnID'];
$this->SMmnNameT = $this->result['SMmnNameT'];
$this->sMnID = $this->result['sMnID'];
$this->sMnSeq = $this->result['sMnSeq'];
$this->sMnNameT = $this->result['sMnNameT'];
$this->sMnLevel = $this->result['sMnLevel'];
$this->pMnID = $this->result['pMnID'];
$this->pMnSeq = $this->result['pMnSeq'];
$this->pMnNameT = $this->result['pMnNameT'];
$this->pMnLevel = $this->result['pMnLevel'];
return $ret;
}
function RsMainMenuList($StID=""){
if ($StID<>""){
$cond="and MnStID=$StID" ;
}
$sql=" select *
from ummenu
where MnParentMnID=0 $cond
order by MnStID, MnSeq ";
$this->SetQuery($sql);
}
function RsMenuList($PrMnID){
$cond="and MnParentMnID=$PrMnID ";
$sql="SELECT *
FROM ummenu m INNER JOIN ummenu sm ON sm.MnParentMnID = m.MnID
WHERE 1=1 $cond
ORDER BY MnParentMnID, m.MnSeq";
$this->SetQuery($sql);
}
function RsMenuList1($PrMnID){
$cond="and s.MnParentMnID=$PrMnID ";
$sql="SELECT s.MnID as sMnID, s.MnSeq as sMnSeq, s.MnNameT as sMnNameT, s.MnLevel as sMnLevel,
p.MnID as pMnID, p.MnSeq as pMnSeq, p.MnNameT as pMnNameT, p.MnLevel as pMnLevel
FROM ummenu s INNER JOIN ummenu p ON s.MnParentMnID = p.MnID
WHERE 1=1 $cond
ORDER BY sMnSeq";
$this->SetQuery($sql);
}
function RsMainMenuByUsGrp($UsID, $GpID){
$cond="and UgUsID=$UsID and UgGpID=$GpID ";
$sql="SELECT *
FROM ummenu INNER JOIN umsystem ON MnStID=StID
INNER JOIN umgroup ON StID=GpStID
INNER JOIN umusergroup ON GpID=UgGpID
WHERE 1=1 and MnLevel=0 $cond
ORDER BY MnParentMnID, MnSeq";
$this->SetQuery($sql);
}
}
?>
|