/**
* get user pages
*
* This function will be used to get the user pages
*
* @param $qry_options
*
*
*/
public function getUserPages($qry_options = '')
{
$result = array();
$qry = "SELECT pages.*\n\t\t\t\tFROM " . APP_PAGES . " pages\n\t\t\t\tJOIN " . APP_USER_ROLES . " roles ON pages.userRoleID = roles.userRoleID\n\t\t\t\tWHERE pages.active=1 {$qry_options}\n\t\t\t\tORDER BY pages.sortOrder";
$res = $this->CR->db->query($qry);
$result = parse_db_result($res);
$res->free_result();
if ($result->result) {
return $result->result;
} else {
return false;
}
return $result;
}
function update_dynamic_translation($DB, $text_orig, $text_locale, $text_trans, $error_detected)
{
$l10n_table = PREFIX_DB . "l10n";
$quoted_text_orig = $DB->qstr($text_orig, get_magic_quotes_gpc());
$quoted_locale = $DB->qstr($text_locale, get_magic_quotes_gpc());
$quoted_text_trans = $DB->qstr($text_trans, get_magic_quotes_gpc());
$query = "UPDATE {$l10n_table}\n\t\t SET text_trans={$quoted_text_trans}\n\t\t WHERE text_orig={$quoted_text_orig} AND text_locale={$quoted_locale}";
$result = parse_db_result($DB, $DB->Execute($query), $error_detected, $query);
if ($result) {
$result->Close();
}
}
/**
* get cloud images
*
* This function will be used to get images
*
* @params referenceID,photoType
*
* @tables
*
* @author ikram
*/
public function getCloudImages($referenceID, $photoType)
{
$result_rt = array();
$qry = "SELECT * FROM " . NG_PHOTOS . " where referenceID={$referenceID} and photoType='{$photoType}' ";
$res = $this->db->query($qry);
$result = parse_db_result($res);
$res->free_result();
if ($result->result) {
return $result->result;
} else {
return false;
}
}
function db_get_all($DB, $query, $error_detected)
{
return parse_db_result($DB, $DB->GetAll($query), $error_detected, $query);
}
/**
* Author Biswajit
* @return multitype:unknown |boolean
*/
public function getProjectList()
{
$result = array();
// $this->db->where("userLevel >= ".$this->userLevel);
$res = $this->db->get(PASLD_PROJECT);
$result_ar = parse_db_result($res);
$res->free_result();
if ($result_ar->result) {
foreach ($result_ar->result as $arr) {
$result[$arr['projectID']] = $arr;
}
return $result;
} else {
return false;
}
}
/**
* get all users
*
* This function will be used to get all users as per qry options
*
* @params qry_options
*
* @tables $this->model_table
*
*
*/
public function getAllUsers($qry_options = '')
{
$result = array();
$qry_options = empty($qry_options) ? "WHERE active = '1'" : $qry_options;
$qry = "SELECT * FROM " . $this->model_table . " {$qry_options}";
$res = $this->db->query($qry);
$result_ar = parse_db_result($res);
$res->free_result();
if ($result_ar->result) {
foreach ($result_ar->result as $arr) {
$result[$arr['userID']] = $arr;
}
return $result;
} else {
return false;
}
}
