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