public function get_list($userid, $keyword = '', $start = 0, $pagesize = 10) { $DB = $this->get_read_pdo(); $keyword_sql = $keyword ? " AND (`ad_name` LIKE :keyword OR `channel` LIKE :keyword)" : ''; $sql = "SELECT a.`id`, `adid`, `set_status`, `set_job_num`, `set_rmb`,\n `set_ad_url`, `set_quote_rmb`, a.`create_time`, `handler`,\n `handle_time`, `send_msg`, `reply_msg`, a.`status`, `ad_name`,\n `channel`, `cid`\n FROM `" . self::$TABLE . "` a LEFT JOIN `t_adinfo` i ON a.`adid`=i.`id`\n LEFT JOIN `t_ad_source` c ON a.`adid`=c.`id`\n WHERE `userid`='{$userid}' AND a.`status`<" . self::WITHDRAWN . " {$keyword_sql}\n ORDER BY `create_time` DESC\n LIMIT {$start}, {$pagesize}"; if ($keyword) { $state = $DB->prepare($sql); $state->execute(array(':keyword' => '%' . $keyword . '%')); return $state->fetchAll(PDO::FETCH_ASSOC); } $result = $DB->query($sql)->fetchAll(PDO::FETCH_ASSOC); $ad = new AD(); $result = $ad->get_ad_channels($result); return $result; }