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