Exemplo n.º 1
0
 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;
 }