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