public function getExchange($condition = '', $fiedls = '*')
{
$conditionString = sql_build_query_condition($condition);
$sql = 'SELECT ' . $fiedls . ' FROM ' . TBL_EXCHANGEAPPLY . 'WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . ' LIMIT 1';
$query = $this->db->query($sql);
return $query->row_array();
}
public function getUsercollectListTotal($condition = '')
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT COUNT(1) AS total FROM ' . TBL_USERCOLLECT . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . ' AND to_days(`createtime`) = to_days(now()) ');
$result = $query->row_array();
return $result['total'];
}
public function getUserreportListTotal($condition = array())
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT COUNT(1) as total FROM ' . TBL_USERREPORT . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : ''));
$result = $query->row_array();
return $result['total'];
}
/**
* 获取用户头像详情
* @param string $condition
* @param string $fiedls
*/
public function getUserAttachment($condition = '', $fiedls = '*')
{
$conditionString = sql_build_query_condition($condition);
$sql = 'SELECT ' . $fiedls . ' FROM ' . TBL_USERATTACHMENT . 'WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . ' LIMIT 1';
$query = $this->db->query($sql);
return $query->row_array();
}
public function getActivityListTotal($condition = array())
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT COUNT(1) AS total FROM ' . TBL_ACTIVITY . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : ''));
$result = $query->row_array();
return $result['total'];
}
public function getHotwordList($condition = '', $fiedls = '*', $orderby = ' ORDER BY `SORT` DESC ')
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT ' . $fiedls . ' FROM ' . TBL_HOTWORD . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . $orderby);
return $query->result_array();
}
public function getBroadcastList($condition = '', $fiedls = '*', $orderby = ' ORDER BY `createtime` DESC ')
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT ' . $fiedls . ' FROM ' . TBL_BROADCAST . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . $orderby);
return $query->result_array();
}
public function getTodayScoreList($condition)
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT * FROM ' . TBL_USERSCORELOG . 'WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . ' AND date(updatetime) = curdate()');
return $query->result_array();
}
public function getCityList($condition = '', $fiedls = '*')
{
$conditionString = sql_build_query_condition($condition);
$query = $this->db->query('SELECT ' . $fiedls . ' FROM ' . TBL_CITY . ' WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : ''));
return $query->result_array();
}
public function getinventrel($condition = '', $fiedls = '*')
{
$conditionString = sql_build_query_condition($condition);
$sql = 'SELECT ' . $fiedls . ' FROM ' . TBL_INVENTREL . 'WHERE 1 = 1 ' . (false == empty($conditionString) ? ' AND (' . $conditionString . ')' : '') . ' ORDER BY createtime desc LIMIT 1';
$query = $this->db->query($sql);
return $query->row_array();
}
