function getEntity($id = "") { if (empty($id)) { $qry = "select * from GROUPE"; return $this->getEmptyEnt($qry); } $qry = "select * from GROUPE where GROUPE_DELETED='0'and GROUPE_NAME='{$id}'"; return BaseContainer::getEntity($qry); }
function getEntity($id = "") { if (empty($id)) { $qry = "select * from COMPANY, CONTACT"; return $this->getEmptyEnt($qry); } $qry = "select * from COMPANY cont where COMPANY_ID='{$id}'"; return BaseContainer::getEntity($qry); }
function getEntity($id = "") { if (empty($id)) { $qry = "select * from LOG"; return $this->getEmptyEnt($qry); } $qry = "select * from LOG where LOG_ID='{$id}'"; return BaseContainer::getEntity($qry); }
function loginUser($userName, $isAdmin = false) { if ($isAdmin) { $qry = "select * from USER where USER_LOGIN_NAME='{$userName}' and GROUPE_NAME='admin' and USER_DELETED='0'"; } else { $qry = "select * from USER where USER_LOGIN_NAME='{$userName}' and USER_DELETED='0'"; } return BaseContainer::getEntity($qry); }
function getItemEnt($id = "") { if (empty($id)) { $qry = "select * from ITEM"; return $this->getEmptyEnt($qry); } $qry = "select * from ITEM where ITEM_DELETED='0' and ITEM_NAME='{$id}'"; return BaseContainer::getEntity($qry); }
function getEntity($id = "") { if (empty($id)) { $qry = "select * from USER"; return $this->getEmptyEnt($qry); } $qry = "select * from USER where USER_DELETED='0' and USER_LOGIN_NAME='{$id}'"; return BaseContainer::getEntity($qry); }
function getDefaultCss($css_name) { $qry = "select * from LAYOUT inner join CSS using(CSS_NAME) where CSS.CSS_NAME='{$css_name}'"; return BaseContainer::getEntity($qry); }