Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (sizeof($fcv_array) > 0)
- {
- var_dump(sizeof($fcv_array));
- $this->pog_query .= " where ";
- //$this->pog_query .= " es_finance_masterid='".$_SESSION['eschools']['es_finance_masterid']."'";
- for ($i=0, $c=sizeof($fcv_array); $i<$c; $i++)
- {
- if (sizeof($fcv_array[$i]) == 1)
- {
- $this->pog_query .= " ".$fcv_array[$i][0]." ";
- continue;
- }
- else
- {
- if ($i > 0 && sizeof($fcv_array[$i-1]) != 1)
- {
- $this->pog_query .= " AND ";
- }
- if (isset($this->pog_attribute_type[$fcv_array[$i][0]]['db_attributes']) && $this->pog_attribute_type[$fcv_array[$i][0]]['db_attributes'][0] != 'NUMERIC' && $this->pog_attribute_type[$fcv_array[$i][0]]['db_attributes'][0] != 'SET')
- {
- if ($GLOBALS['configuration']['db_encoding'] == 1)
- {
- $value = POG_Base::IsColumn($fcv_array[$i][2]) ? "BASE64_DECODE(".$fcv_array[$i][2].")" : "'".$fcv_array[$i][2]."'";
- $this->pog_query .= "BASE64_DECODE(`".$fcv_array[$i][0]."`) ".$fcv_array[$i][1]." ".$value;
- }
- else
- {
- $value = POG_Base::IsColumn($fcv_array[$i][2]) ? $fcv_array[$i][2] : "'".$this->Escape($fcv_array[$i][2])."'";
- $this->pog_query .= "`".$fcv_array[$i][0]."` ".$fcv_array[$i][1]." ".$value;
- }
- }
- else
- {
- $value = POG_Base::IsColumn($fcv_array[$i][2]) ? $fcv_array[$i][2] : "'".$fcv_array[$i][2]."'";
- $this->pog_query .= "`".$fcv_array[$i][0]."` ".$fcv_array[$i][1]." ".$value;
- }
- }
- }
- }
- if ($sortBy != '')
- {
- if (isset($this->pog_attribute_type[$sortBy]['db_attributes']) && $this->pog_attribute_type[$sortBy]['db_attributes'][0] != 'NUMERIC' && $this->pog_attribute_type[$sortBy]['db_attributes'][0] != 'SET')
- {
- if ($GLOBALS['configuration']['db_encoding'] == 1)
- {
- $sortBy = "BASE64_DECODE($sortBy) ";
- }
- else
- {
- $sortBy = "$sortBy ";
- }
- }
- else
- {
- $sortBy = "$sortBy ";
- }
- }
- else
- {
- $sortBy = "es_adminsid";
- }
- $this->pog_query .= " order by ".$sortBy." ".($ascending ? "asc" : "desc")." $sqlLimit";
- $thisObjectName = get_class($this);
- $cursor = Database::Reader($this->pog_query, $connection);
- while ($row = Database::Read($cursor))
- {
- $es_admins = new $thisObjectName();
- //$es_admins->es_finance_masterid = $row['es_finance_masterid'];
- $es_admins->es_adminsId = $row['es_adminsid'];
- $es_admins->admin_username = $this->Unescape($row['admin_username']);
- $es_admins->admin_password = $this->Unescape($row['admin_password']);
- $es_admins->admin_fname = $this->Unescape($row['admin_fname']);
- $es_admins->user_type = $row['user_type'];
- $es_admins->user_theme = $this->Unescape($row['user_theme']);
- $es_admins->admin_lname = $this->Unescape($row['admin_lname']);
- $es_admins->admin_email = $this->Unescape($row['admin_email']);
- $es_admins->admin_phoneno = $this->Unescape($row['admin_phoneno']);
- $es_admins->admin_more = $this->Unescape($row['admin_more']);
- $es_admins->admin_permissions = $this->Unescape($row['admin_permissions']);
- $es_adminsList[] = $es_admins;
- }
- return $es_adminsList;
- }
Add Comment
Please, Sign In to add comment