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