PHP Banner::select方法代码示例

 public function listBanner()
 {
     if (!Request::ajax()) {
         return App::abort(404);
     }
     $start = Input::has('start') ? (int) Input::get('start') : 0;
     $length = Input::has('length') ? Input::get('length') : 10;
     $search = Input::has('search') ? Input::get('search') : [];
     $banners = Banner::select('id', 'name', 'order_no', 'image', 'active');
     if (!empty($search)) {
         foreach ($search as $key => $value) {
             if (empty($value)) {
                 continue;
             }
             if ($key == 'active') {
                 if ($value == 'yes') {
                     $value = 1;
                 } else {
                     $value = 0;
                 }
                 $banners->where($key, $value);
             } else {
                 $value = ltrim(rtrim($value));
                 $banners->where($key, 'like', '%' . $value . '%');
             }
         }
     }
     $order = Input::has('order') ? Input::get('order') : [];
     if (!empty($order)) {
         $columns = Input::has('columns') ? Input::get('columns') : [];
         foreach ($order as $value) {
             $column = $value['column'];
             if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) {
                 continue;
             }
             $banners->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc');
         }
     }
     $count = $banners->count();
     if ($length > 0) {
         $banners = $banners->skip($start)->take($length);
     }
     $arrBanners = $banners->get()->toArray();
     $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Banner::count(), 'recordsFiltered' => $count, 'data' => []];
     if (!empty($arrBanners)) {
         foreach ($arrBanners as $banner) {
             $arrReturn['data'][] = array(++$start, $banner['id'], $banner['name'], $banner['image'], $banner['order_no'], $banner['active']);
         }
     }
     $response = Response::json($arrReturn);
     $response->header('Content-Type', 'application/json');
     return $response;
 }

 public function begin()
 {
     /** @var Html $document */
     $groupId = $this->getParams('banner_group_id');
     if ($groupId) {
         $this->banners = Banner::select()->where('`status`=:status AND `term_id`=:term_id')->setParameters([':status' => 'ACTIVE', ':term_id' => $groupId])->orderBy('ordering')->execute();
     }
 }

 public static function getBanners()
 {
     $arrData = [];
     if (Cache::has('banners')) {
         $arrData = Cache::get('banners');
     } else {
         $banners = Banner::select('image')->where('active', 1)->orderBy('order_no', 'asc')->get();
         foreach ($banners as $banner) {
             $arrData[] = URL . '/' . $banner->image;
         }
         Cache::forever('banners', $arrData);
     }
     $rand = rand(0, count($arrData) - 1);
     return ['main' => isset($arrData[$rand]) ? $arrData[$rand] : ''];
 }

 /**
  *
  * @access public
  */
 function update_ads()
 {
     $id = get_post_value('id');
     $field = array('banner_id', 'img_path', 'created', 'title', 'start_time', 'end_time', 'orders', 'language');
     $m = new Banner();
     $m->clear();
     $m->setField($field);
     $m->setTable('vcb_index_banner2');
     $m->setWhere('banner_id', '=', $id);
     $m->setWhere('status', '!=', '60000');
     $data = $m->select();
     //print_r($data);
     $this->assign('data', $data);
 }

 function Index()
 {
     //echo "session=";
     // print_r($_SESSION);
     // echo "<br>cookie=";
     // print_r($_COOKIE);
     if (isset($_SESSION['username']) && !empty($_SESSION['username'])) {
         //检测session
         $this->assign('username', $_SESSION['username']);
     } else {
         if (!empty($_COOKIE["username"])) {
             //检测cookie
             $userCookie = $_COOKIE["username"];
             $this->assign('username', $userCookie);
         } else {
             //游客登陆
             $tourists_id = Login::getTouristsId();
             if ($tourists_id == null) {
                 Login::setTouristsId();
             }
             //
         }
     }
     //else结束
     //
     $c = new Category();
     $category_1 = $c->getCategory_1_id();
     $this->assign('category_1', $category_1);
     $f = new Floor();
     $floor_1 = $f->getFloor_1_id();
     $this->assign('floor_1', $floor_1);
     //
     $m = new Category();
     $num = count($m->getCategory_1_id()) * 10000;
     $category_2_all = $this->get_category_2();
     $this->assign('category_2_all', $category_2_all);
     //var_dump($category_2_all);
     //echo $num1."<br>";
     $category_3_all = $this->get_category_3();
     //echo "oh:".$num2."<br>";
     //$this->assign('category_3_'.$i."_".$j.$k, $category_3_1[$k]);
     //var_dump($category_3_all);
     $this->assign('category_3_all', $category_3_all);
     //$a=new Banner();
     $floor_2_all = $this->get_floor_2();
     $floor_3_all = $this->get_floor_3();
     $this->assign('floor_2_all', $floor_2_all);
     $this->assign('floor_3_all', $floor_3_all);
     //********************************
     $type = get_post_value('type');
     $language = get_post_value('language');
     $key = get_post_value('key');
     $field = array('category_id', 'type', 'title', 'created', 'start_time', 'end_time', 'status', 'language');
     $m = new Banner();
     $m->clear();
     $m->setField($field);
     $m->setTable('vcb_banner_categor');
     //$m->setWhere('status', '!=', '60000');//暂不设置
     if ($type != '') {
         $m->setWhere('type', '=', $type);
     }
     if ($language != '') {
         $m->setWhere('language', '=', $language);
     }
     if ($key != '') {
         $m->setWhere('title', 'LIKE', '%' . $key . '%');
     }
     $m->setOrderBy('type');
     $data = $m->select();
     //状态标题    在每一条数据后加上4个数据
     $count = count($data);
     for ($i = 0; $i < $count; $i++) {
         $data[$i]['status_cn'] = $m->getStatus('cn', $data[$i]['status']);
         $data[$i]['status_th'] = $m->getStatus('th', $data[$i]['status']);
         //$data[$i]['type'] = $m->getTypeCaption($data[$i]['type']);//返回位置对应描述
         $data[$i]['dataInformation'] = $m->getImage($data[$i]['category_id']);
     }
     //print_r($data);
     $this->assign('dataOfBanner', $data);
 }

 /**
  * 返回更新国家信息
  * @access public
  */
 function update()
 {
     $id = get_post_value('id');
     $field = array('category_id', 'type', 'title', 'created', 'start_time', 'end_time', 'status', 'language');
     $m = new Banner();
     $m->clear();
     $m->setField($field);
     $m->setTable('vcb_banner_categor');
     $m->setWhere('category_id', '=', $id);
     $m->setWhere('status', '!=', '60000');
     $data = $m->select();
     $this->assign('data', $data);
     //修改原记录
     //图像
     $field = array('image_path', 'orders', 'image_id');
     $m->clear();
     $m->setField($field);
     $m->setTable('vcb_banner_images');
     $m->setWhere('category_id', '=', $id);
     $m->setWhere('status', '=', '10000');
     $m->setOrderBy('orders');
     $data = $m->select();
     $this->assign('images', $data);
 }