PHP get_visa_field Examples

Example #1

File: VisaController.class.php Project: lampge/youweihui

 public function index()
 {
     $catid = I('get.catid', '');
     $zone = I('get.zone', '');
     $sub_id = I('get.sub_id', '');
     $pageNum = 6;
     $nowPage = I('get.p', 1);
     $firstRow = ($nowPage - 1) * $pageNum;
     $map = array();
     $map['visa_catid'] = $catid;
     $map['zone'] = $zone;
     $map['sub_id'] = $sub_id;
     $map['_logic'] = 'OR';
     $where['_complex'] = $map;
     $where['status'] = 1;
     $Visa = M('Visa');
     $visa_lists = $Visa->where($where)->order('sort asc,update_time desc')->limit($firstRow, $pageNum)->select();
     foreach ($visa_lists as $k => $val) {
         $visa_lists[$k]['is_yaoqing'] = $val['is_yaoqing'] ? '需要' : '不需要';
         $visa_lists[$k]['is_mianshi'] = $val['is_mianshi'] ? '需要' : '不需要';
         $visa_lists[$k]['url'] = U('Visa/show', array('id' => $val['visa_id']));
         $visa_lists[$k]['image'] = get_cover($val['cover_id'], 'path');
         $visa_lists[$k]['zone'] = get_visa_field($val['zone'], 'title');
     }
     $count = $Visa->where($where)->count();
     $page = article_pages($count, $pageNum);
     $sub_ids = C(QZ_TYPE);
     $this->assign('sub_ids', $sub_ids);
     $this->assign('visa_lists', $visa_lists);
     $this->assign('_page', $page);
     $this->display();
 }

Example #2

File: VisaController.class.php Project: bjjfsd/youweihui

 public function index()
 {
     $catid = I('get.catid', '');
     $zone = I('get.zone', '');
     $sub_id = I('get.sub_id', '');
     $keyword = I('get.keyword', '');
     $pageNum = 6;
     $nowPage = I('get.p', 1);
     $firstRow = ($nowPage - 1) * $pageNum;
     $map = array('status' => 1);
     if (!empty($catid)) {
         $map['visa_catid'] = $catid;
     }
     if (!empty($zone)) {
         $map['zone'] = $zone;
     }
     if (!empty($sub_id)) {
         $map['sub_id'] = $sub_id;
     }
     if (!empty($keyword)) {
         $map['title'] = array('like', '%' . $keyword . '%');
     }
     $Visa = M('Visa');
     $visa_lists = $Visa->where($map)->order('sort desc,update_time desc')->limit($firstRow, $pageNum)->select();
     // echo $Visa->_sql();
     foreach ($visa_lists as $k => $val) {
         $visa_lists[$k]['is_yaoqing'] = $val['is_yaoqing'] ? '需要' : '不需要';
         $visa_lists[$k]['is_mianshi'] = $val['is_mianshi'] ? '需要' : '不需要';
         $visa_lists[$k]['url'] = U('Visa/show', array('id' => $val['visa_id']));
         $visa_lists[$k]['image'] = get_cover($val['cover_id'], 'path');
         $visa_lists[$k]['zone'] = get_visa_field($val['zone'], 'title');
     }
     $count = $Visa->where($map)->count();
     $page = article_pages($count, $pageNum);
     $sub_ids = C(QZ_TYPE);
     $this->assign('sub_ids', $sub_ids);
     $this->assign('visa_lists', $visa_lists);
     $this->assign('_page', $page);
     $this->display();
 }