/** * 获取所有理财产品 */ public function api_seek_all_data() { $data = $this->field('id,name,content,create_time')->where(array('status' => 0))->select(); if (!empty($data)) { $reg = "'([\\s])[\\s]+'"; //匹配换号符号 foreach ($data as $key => $val) { $data[$key]['content'] = preg_replace($reg, "|", $val['content']); } } parent::set_all_time($data, array('create_time')); return $data; }
/** * 获取当前用户下用户浏览产品的日志 * @param String $account 用户账号 */ public function seek_user_record($account) { $data = $this->field('p.name,bl.time')->table($this->prefix . 'browse_log AS bl')->join($this->prefix . 'product AS p ON bl.product_id = p.id')->join($this->prefix . 'users AS u ON bl.users_id = u.id')->where(array('u.account' => $account))->order('bl.id DESC')->select(); parent::set_all_time($data, array('time')); return $data; }
public function seek_one_data($id) { $data = $this->field('id,name,content,create_time')->where(array('status' => 0, 'id' => $id))->find(); $data ? parent::set_all_time($data, array('create_time')) : $data; return $data; }
/** * 获取广告数据 */ public function seek_all_data() { $data = $this->field('a.id AS aid,p.id,f.file_address,p.name,a.time')->table($this->prefix . 'advertisement AS a')->join($this->prefix . 'product AS p ON a.product_id = p.id')->join($this->prefix . 'file AS f ON a.file_id = f.id')->where(array('a.status' => 0))->select(); parent::set_all_time($data, array('time')); return $data; }