public static function get_list()
{
$select_list = Staff::$HEADER;
$dbResult = DB::select_array($select_list)->from(Staff::$TABLE)->execute();
$dbData = $dbResult->as_array();
return $dbData;
}
public static function get_list()
{
$select_list = Lecturer::$HEADER;
$dbResult = DB::select_array($select_list)->from(Lecturer::$TABLE)->join(Lecturer::$TABLE_DETAILS)->on('Staff.ID', '=', 'Staff_Lecturer.StaffID')->execute();
$dbData = $dbResult->as_array();
return $dbData;
}
public static function in_pages($type, $page, $sort)
{
$queryBuilder = DB::select_array(self::$DB_FIELD)->from(self::$TABLE)->where('Type', $type)->and_where('pages', $page);
if (isset($sort)) {
$queryBuilder = $queryBuilder->and_where('Sort', $sort);
}
$dbResult = $queryBuilder->execute();
$dbData = $dbResult->as_array();
return $dbData;
}
public static function get_list()
{
$fieldList = array('ID', 'Name', 'Email', 'Phone', 'Sex', 'Major', 'DoB', 'PoB', 'PoO', 'Address');
try {
/** @var Database_Query $dbObj */
$dbObj = DB::select_array($fieldList)->from(self::$TABLE);
$dbResult = $dbObj->execute();
return count($dbResult) > 0 ? $dbResult->as_array() : [];
} catch (\Exception $e) {
Log::debug($e);
return [];
}
$dbResult = DB::select_array($fieldList)->from(Staff::$TABLE)->execute();
$dbData = $dbResult->as_array();
return $dbData;
}
public function getListStory($sectionID)
{
$fieldList = ['ID', 'Author', 'Title', 'Description', 'DateCreate', 'Type', 'Tag', 'Views'];
try {
$dbObj = DB::select_array($fieldList)->from($this->TABLE)->order_by('DateCreate', 'dsc');
if ($sectionID != -1) {
$dbObj->where('Type', $sectionID);
}
$dbResult = $dbObj->execute();
return $dbResult->as_array();
} catch (\Exception $e) {
print_r($e);
exit;
CError::dbLog($e);
return null;
}
}
public function loadData($id)
{
try {
$dbObj = DB::select_array($this->fields)->from($this->TABLE)->where('ID', $id);
//$dbResult = $dbObj->compile();
$dbResult = $dbObj->execute();
if (count($dbResult) > 0) {
// Map object
$this->isValid = true;
$this->map($this, $dbResult->as_array()[0]);
} else {
$this->isValid = false;
}
} catch (\Exception $e) {
CError::dbLog($e);
$this->isValid = false;
return null;
}
}
public function getListBaseType()
{
// Make query field
$field_list = array('ID', 'PostBy', 'Title', 'Description', 'DateCreate', 'Type', 'Tag', 'Views');
try {
$dbObj = DB::select_array($field_list)->from('News');
if ($this->_type != 0) {
$dbObj->where('Type', $this->_type);
}
$dbObj->order_by('DateCreate', 'dsc');
// ->limit($this->_size)
// ->offset(($this->_page - 1) * 10)
$dbResult = $dbObj->execute();
return $dbResult->as_array();
} catch (\Exception $e) {
ErrorMsg::_log($e);
return null;
}
}
/**
* find for pagination
*
* @param mixed $params array - like model find param
* Database_Query_Builder_Select instance - you can use raw DB model
* boolean $need_count
* @return array
* |-- list (array)
* `-- count (int)
*/
public function find($params, $need_count = true)
{
if ($params instanceof \Fuel\Core\Database_Query_Builder_Select) {
$query_cnt = clone $params;
$query_cnt->select_array(array(\Fuel\Core\DB::expr('COUNT(*) as cnt')), true);
$query_list = $params;
$query_list->limit($this->per_page)->offset($this->get_offset());
} else {
$default = array('select' => array('*'), 'where' => array(), 'limit' => $this->per_page, 'offset' => $this->get_offset(), 'order_by' => array(array('id', 'ASC')));
$params = array_merge($default, $params);
if (!isset($params['from'])) {
throw new \Fuel\Core\Database_Exception('Query "from" not found!');
}
$query_list = \Fuel\Core\DB::select_array($params['select'])->from($params['from'])->limit($params['limit'])->offset($params['offset']);
$query_cnt = \Fuel\Core\DB::select(\Fuel\Core\DB::expr('COUNT(*) as cnt'))->from($params['from']);
foreach ($params['where'] as $w) {
if (count($w) > 1) {
call_user_func_array(array($query_list, 'where'), $w);
call_user_func_array(array($query_cnt, 'where'), $w);
} else {
$query_list->where($w);
$query_cnt->where($w);
}
}
foreach ($params['order_by'] as $order) {
call_user_func_array(array($query_list, 'order_by'), $order);
}
if (isset($params['group_by'])) {
if (is_string($params['group_by'])) {
$params['group_by'] = array($params['group_by']);
}
call_user_func_array(array($query_list, 'group_by'), $params['group_by']);
call_user_func_array(array($query_cnt, 'group_by'), $params['group_by']);
}
}
$list = $query_list->execute()->as_array();
$cnt = 0;
if ($need_count) {
$cnt = $query_cnt->execute()->as_array();
if (count($cnt) > 1) {
$cnt = count($cnt);
} else {
$cnt = \Arr::get(\Arr::get($cnt, 0, array()), 'cnt', 0);
}
}
// set items automatically
$this->item_list = $list;
$this->total_items = $cnt;
return array('list' => $list, 'count' => $cnt);
}
public static function get($id)
{
$dbResult = DB::select_array(self::$FIELD)->from(self::$TABLE)->where('ID', $id)->execute();
$dbData = $dbResult->as_array();
return $dbData[0];
}
public static function get_list_child($id)
{
$dbResult = DB::select_array(self::$FIELD)->from(self::$TABLE)->where('ParentID', $id)->execute();
$dbData = $dbResult->as_array();
return $dbData;
}
