Viewing file: m_ummenu.php (3.68 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include_once("da_ummenu.php"); class M_Ummenu extends Da_ummenu { //=== add your functions below
function getAll($aOrderBy=""){ $orderBy = ""; if (is_array($aOrderBy)) { $orderBy.="ORDER BY "; foreach ($aOrderBy as $key => $value) { $orderBy.= "$key $value, "; } $orderBy = substr($orderBy, 0, strlen($orderBy)-2); } $sql = "SELECT * FROM ummenu $orderBy"; $query = $this->db->query($sql); return $query ; }
function RSByStIDPrIDLv($stid,$mnid,$lv){ $sql = "SELECT * FROM ummenu WHERE MnStID = ? AND MnParentMnID LIKE ? AND MnLevel = ? ORDER BY MnID"; $result = $this->db->query($sql, array($stid,$mnid,$lv)); // echo $this->db->last_query(); return $result; }
function RSByStIDGpIDUsIDPrIDLv($stid,$gpid,$usid,$mnid,$lv){ $sql = "SELECT * FROM ummenu JOIN umsystem ON MnStID = StID WHERE MnStID = ? AND (MnParentMnID = ? OR MnParentMnID IS NULL) AND MnLevel = ? AND MnID NOT IN ( SELECT distinct gp.gpMnID FROM umgpermission gp join ummenu mn ON gp.gpMnID = mn.MnID WHERE gp.gpGpID = ? AND mn.MnLevel = ? AND gp.gpX = 0 ) AND MnID NOT IN ( SELECT distinct pm.pmMnID FROM umpermission pm JOIN ummenu mn ON pm.pmMnID = mn.MnID WHERE pm.pmUsID = ? AND mn.MnLevel = ? AND pm.pmX = 0 ) ORDER BY MnSeq"; $result = $this->db->query($sql, array($stid,$mnid,$lv,$gpid,$lv,$usid,$lv)); return $result; }
function SearchByMnID($mnid){ $sql = "SELECT * FROM ummenu JOIN umsystem ON MnStID = StID WHERE MnID LIKE ? "; $result = $this->db->query($sql, array($mnid)); // echo $this->db->last_query(); if($result->num_rows()<>0){ return $result->row_array(); }else{ return false; } }
function RSByParentMn($MnID,$MnStID=-1){ $condition = "MnParentMnID = $MnID"; if($MnID==0){ $condition = "(MnParentMnID = $MnID OR MnParentMnID IS NULL)"; } if($MnStID>=0){ $condition .= " AND MnStID = $MnStID"; } $sql = "select * from ummenu where $condition order by MnSeq ASC"; $result = $this->db->query($sql); return $result; } function updateMenu(){ $sql = "UPDATE ummenu SET MnNameT = ?, MnNameE = ?, MnURL = ?, MnDesc = ? WHERE MnID = ? "; $this->db->query($sql, array($this->MnNameT, $this->MnNameE, $this->MnURL, $this->MnDesc, $this->MnID)); } function lastMnID(){ $sql = "SELECT * FROM ummenu WHERE MnStID = ? ORDER BY MnID DESC"; $query = $this->db->query($sql,array($this->MnStID)); if($query->num_rows()==0){ return 0; } else { return $query->row()->MnID; } } function deleteMenu() { $sql = "DELETE FROM ummenu WHERE MnID = ? OR MnParentMnID = ? "; $this->db->query($sql,array($this->MnID,$this->MnID)); } function deleteSystem() { $sql = "DELETE FROM ummenu WHERE MnStID = ?"; $this->db->query($sql,array($this->MnStID)); } function SaveSeq(){ $sql = "UPDATE ummenu SET MnSeq = ? WHERE MnID = ? "; $this->db->query($sql,array($this->MnSeq,$this->MnID)); } /* * get menu for permission group * @author beeroma * @use group/umGroupPermissionRe * @return query * @Create Date 2554-10-27 */ function RSByParentMnPermissionGroup($MnID,$MnStID=-1,$GpID){ $condition = "MnParentMnID = $MnID"; if($MnID==0){ $condition = "(MnParentMnID = $MnID OR MnParentMnID IS NULL)"; } if($MnStID>=0){ $condition .= " AND MnStID = $MnStID"; } $sql = "SELECT * FROM ummenu LEFT JOIN umgpermission ON ummenu.MnID = umgpermission.gpMnID AND umgpermission.gpGpID = {$GpID} WHERE $condition ORDER BY MnIcon,MnSeq ASC"; $result = $this->db->query($sql); return $result; } } //=== end class Ummenu
|