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);
}
