Viewing file:  m_umgpermission.php (1.54 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("da_umgpermission.php");
class M_Umgpermission extends Da_umgpermission {
//=== 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 umgpermission $orderBy";
$query = $this->db->query($sql);
return $query ;
}
function RSByGpIDX($gpid,$x){
$sql = "SELECT gpMnID
FROM umgpermission
WHERE gpGpID = ?
AND gpX = ?";
$result = $this->db->query($sql, array($gpid,$x));
return $result;
}
function SearchByKey($gpid, $mnid){
$sql = "SELECT *
FROM umgpermission
WHERE gpGpID = ?
AND gpMnID = ?";
$result = $this->db->query($sql, array($gpid, $mnid));
if($result->num_rows()<>0){
return $result->row_array();
}else{
return false;
}
}
/*
* Delete umgpermission by GpID
* @author beeroma
* @Create Date 2554-10-27
*/
function deleteByGpID($gpGpID){
$sql = "DELETE FROM umgpermission WHERE gpGpID = ? ";
$this->db->query($sql, array($gpGpID));
}
/*
* Insert umgpermission
* @author beeroma
* @Create Date 2554-10-27
*/
function insertPermission(){
$sql = "INSERT INTO umgpermission (gpGpID, gpMnID, gpSeq, gpX, gpC, gpR, gpU, gpD)
VALUES(?, ?, ?, ?, ?, ?, ?, ?)";
$this->db->query($sql, array($this->gpGpID, $this->gpMnID, $this->gpSeq, $this->gpX, $this->gpC, $this->gpR, $this->gpU, $this->gpD));
}
} //=== end class Umgpermission
?>
|