public static function get_users($params = array()) { $sql = "SELECT \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`user_id` \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`users`\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`user_id` > 0\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t"; if (isset($params['orders'])) { $subsql = ""; foreach ($params['orders'] as $order_key => $order_value) { switch ($order_key) { case 'user_signin_datetime': $subsql .= $subsql == "" ? "" : ", "; $subsql .= "`user_signin_datetime` " . $order_value . " "; break; } } $sql .= "ORDER BY " . $subsql; } if (isset($params['limit']) && isset($params['page'])) { $start_index = ($params['page'] - 1) * $params['limit']; $sql .= "LIMIT " . $start_index . ", " . database_essence::prepare($params['limit'], 'number'); } if ($data = database_essence::get_all($sql)) { if (is_array($data)) { foreach ($data as $key => $value) { $data[$key] = new user_object($value); } return $data; } } return array(); }
public static function get_files($params = array()) { $sql = "SELECT \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`file_id` \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`files`\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t`file_id` > 0\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t"; if (isset($params['filters'])) { foreach ($params['filters'] as $filter_key => $filter_value) { switch ($filter_key) { case 'user_id': $sql .= "AND `user_id` = " . database_essence::prepare($filter_value) . " "; break; } } } if (isset($params['orders'])) { $subsql = ""; foreach ($params['orders'] as $order_key => $order_value) { $order_value = $order_value == 'desc' ? 'desc' : 'asc'; switch ($order_key) { case 'file_add_datetime': $subsql .= $subsql == "" ? "" : ", "; $subsql .= "`file_add_datetime` " . $order_value . " "; break; case 'file_origin_name': $subsql .= $subsql == "" ? "" : ", "; $subsql .= "`file_origin_name` " . $order_value . " "; break; } } if ($subsql) { $sql .= "ORDER BY " . $subsql; } } if (isset($params['limit']) && isset($params['page'])) { $start_index = ($params['page'] - 1) * $params['limit']; $sql .= "LIMIT " . $start_index . ", " . database_essence::prepare($params['limit'], 'number'); } if ($data = database_essence::get_all($sql)) { if (is_array($data)) { foreach ($data as $key => $value) { $data[$key] = new file_object($value); } return $data; } } return array(); }