public function fragFeedbackSchool() { $p = I("get.p", 1); $this->assign("curtpage", $p); $limit = I("get.limit", 10); $db = M(); $list = $db->table("user_school as school, feedback")->field("school.id, school.schoolname, school.area, school.phone")->where("feedback.uid = school.id AND feedback.utype = 'school'")->group("feedback.uid")->order("date desc")->page($p, $limit)->select(); $this->assign("list", $list); $count = $db->table("user_school as school, feedback")->field("school.id, school.schoolname, school.area, school.phone")->where("feedback.uid = school.id AND feedback.utype = 'school'")->group("feedback.uid")->count(); $pagelist = gtPage($count, $limit, $p); $this->assign("pagelist", $pagelist); $this->display(); }
public function pageJobsLists() { $nowCity = I("get.nowCity"); if (empty($nowCity)) { $nowCity = session('nowCity'); $this->assign('nowCity', $nowCity); } else { session('nowCity', $nowCity); $this->assign('nowCity', $nowCity); } //查询区县信息 $jobs = D('Jobs'); $countyList = $jobs->getCountyList($nowCity); $this->assign("countyList", $countyList); // 查询分类信息 $l1 = D('jobs')->getJoblevel1(); $this->assign("job_level1", $l1); // 随机查询6个职业分类作为热门搜索内容 $sql = "SELECT * FROM job_level2 ORDER BY RAND() LIMIT 6"; $levelRandom = M()->query($sql); $this->assign("level2RandomList", $levelRandom); $p = I('get.p', 1); //分页,页数 $limit = I('get.limit', 12); //个数 //构造查询的条件 $level2 = I('get.l2'); //职业 $level1 = I('get.l1'); //行业 $time = I('get.time'); switch ($time) { case 'day': $startTime = date("Y-m-d"); $endTime = date("Y-m-d"); break; case 'week': $startTime = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y"))); $endTime = date("Y-m-d", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y"))); break; case 'month': $startTime = date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y"))); $endTime = date("Y-m-d", mktime(23, 59, 59, date("m"), date("t"), date("Y"))); break; case 'year': $startTime = date("Y") . '-01-01'; $endTime = date("Y") . '-12-31'; break; default: break; } $keyword = I('get.keyword'); //关键词,搜索 $county = I('get.county'); //地区 $host = I('get.host'); $where['jobs.state'] = array('neq', 3); $where['jobs.area|jobs.city'] = array('LIKE', "%" . $nowCity . "%"); //根据城市查询 if (!empty($level1)) { $where['jobs.level1'] = $level1; } if (!empty($level2)) { $where['jobs.level2'] = $level2; } if (!empty($keyword)) { $where['jobs.title'] = array('LIKE', "%" . $keyword . "%"); } if (!empty($county)) { $where['jobs.area|jobs.county'] = array('LIKE', "%" . $county . "%"); } if (!empty($time)) { $where['jobs.date'] = array('BETWEEN', array($startTime, $endTime)); } $jobs = D('Jobs'); if (!empty($host)) { $commonJobLists = $jobs->getCommonJobsList($limit, $p, "jobs.view desc", $where); } else { $commonJobLists = $jobs->getCommonJobsList($limit, $p, "jobs.date desc,jobs.id desc", $where); } $count = $jobs->getCount($where); $this->assign('count', $count); $page = gtPage($count, $limit, $p); $this->assign("pagelist", $page); $this->assign("curtpage", $p); $this->assign('commonJobLists', $commonJobLists); $this->assign("jobsList", true); //确定当前导航样式 $this->display(); }
public function assignPage($table, $where = "", $variateName = "list", $order = "") { $db = M($table); $p = I("get.p", 1); $this->assign("curtpage", $p); $limit = I("get.limit", 10); $list = $db->where($where)->order($order)->page($p, $limit)->select(); $this->assign($variateName, $list); $count = $db->where($where)->count(); $pagelist = gtPage($count, $limit, $p); $this->assign("pagelist", $pagelist); $this->display(); }
public function setPage($count) { $page = gtPage($count, $this->limit, $this->p); $this->assign("pagelist", $page); $this->assign("curtpage", $this->p); }
public function pageRegionCounty() { //获取省份 $db = M("province"); $re = $db->select(); $this->assign("provinceList", $re); //筛选 $db = M("county"); $p = I("get.p", 1); $keyword = I('get.keyword'); $pid = I('get.pid'); $cid = I('get.cid'); $where = array(); if (!empty($keyword)) { $where['county.name|county.spell'] = array('LIKE', "%" . $keyword . "%"); } if (!empty($pid)) { $where['county.pid'] = $pid; } if (!empty($cid)) { $where['county.cid'] = $cid; } $this->assign("curtpage", $p); $limit = I("get.limit", 10); $list = M()->table("county, city, province")->field("county.name, county.id, province.name as pname, city.name as cname")->where("county.pid = province.id AND county.cid = city.id")->where($where)->page($p, $limit)->select(); $this->assign("countyList", $list); $count = $db->where($where)->count(); $pagelist = gtPage($count, $limit, $p); $this->assign("pagelist", $pagelist); $this->display(); }
public function fragSchoolRecruit() { $p = I("get.p", 1); $this->assign("curtpage", $p); $limit = I("get.limit", 10); $db = M(); $uid = I("post.id"); $name = I("post.name"); $list = $db->table("jobs_apply as apply, jobs")->field("jobs.level2, jobs.date, jobs.price, jobs.number")->where("jobs.uid = {$uid} AND jobs.name = '{$name}' AND jobs.id = apply.jobid AND apply.state = 1")->group("apply.jobid")->order("jobs.date desc")->page($p, $limit)->select(); $this->assign("list", $list); $count = $db->table("jobs_apply as apply, jobs")->where("jobs.uid = {$uid} AND jobs.name = '{$name}' AND jobs.id = apply.jobid AND apply.state = 1")->field("count(distinct apply.jobid) as count")->find(); $count = $count['count']; $pagelist = gtPage($count, $limit, $p); $this->assign("pagelist", $pagelist); $this->display(); }