You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
71 lines
3.2 KiB
71 lines
3.2 KiB
<?php
|
|
defined('IN_IA') or exit('Access Denied');
|
|
|
|
|
|
/**
|
|
* Comment: 求职招聘订单管理
|
|
* Author: zzw
|
|
* Date: 2021/1/13 10:02
|
|
* Class RecruitOrder_WeliamController
|
|
*/
|
|
class RecruitOrder_WeliamController{
|
|
/**
|
|
* Comment: 求职订单列表
|
|
* Author: zzw
|
|
* Date: 2021/1/13 11:19
|
|
*/
|
|
public function index(){
|
|
global $_W,$_GPC;
|
|
//参数信息获取
|
|
$page = $_GPC['page'] ? : 1;
|
|
$pageIndex = $_GPC['page_index'] ? : 10;
|
|
$startPage = $page * $pageIndex - $pageIndex;
|
|
$title = $_GPC['title'] ? : '';//名称
|
|
$industryPid = $_GPC['industry_pid'] ? : 0;//上级行业id
|
|
$industryId = $_GPC['industry_id'] ? : 0;//子行业id
|
|
$positionId = $_GPC['position_id'] ? : 0;//职位id
|
|
$recruitmentType = $_GPC['recruitment_type'] ? : 0;//招聘类型:1=个人招聘,2=企业招聘
|
|
//条件删除
|
|
$where = " WHERE a.uniacid = {$_W['uniacid']} AND a.aid = {$_W['aid']} AND a.plugin = 'recruit' ";
|
|
if($title) $where .= " AND b.title LIKE '%{$title}%' ";
|
|
if($industryPid > 0) $where .= " AND b.industry_pid = {$industryPid} ";
|
|
if($industryId > 0) $where .= " AND b.industry_id = {$industryId} ";
|
|
if($positionId > 0) $where .= " AND b.position_id = {$positionId} ";
|
|
if($recruitmentType > 0) $where .= " AND b.recruitment_type = {$recruitmentType} ";
|
|
//sql语句生成
|
|
$field = "a.id,a.orderno,a.status,a.paytype,a.paytime,a.price,a.fightstatus,b.title,b.recruitment_type,b.release_mid,b.release_sid";
|
|
$sql = "SELECT {$field} FROM ".tablename(PDO_NAME."order")
|
|
." as a RIGHT JOIN ".tablename(PDO_NAME."recruit_recruit")
|
|
." as b ON a.fkid = b.id ";
|
|
$order = " ORDER BY a.createtime DESC,a.id DESC ";
|
|
$limit = " LIMIT {$startPage},{$pageIndex} ";
|
|
//获取并且处理信息
|
|
$list = pdo_fetchall($sql.$where.$order.$limit);
|
|
foreach($list as $index => &$item){
|
|
//判断发布方 招聘类型:1=个人招聘,2=企业招聘
|
|
if($item['recruitment_type'] == 1){
|
|
$release = pdo_get(PDO_NAME."member",['id'=>$item['release_mid']],['nickname','avatar']);
|
|
$item['release_name'] = $release['nickname'];
|
|
$item['release_logo'] = tomedia($release['avatar']);
|
|
}else{
|
|
$release = pdo_get(PDO_NAME."merchantdata",['id'=>$item['release_sid']],['storename','logo']);
|
|
$item['release_name'] = $release['storename'];
|
|
$item['release_logo'] = tomedia($release['logo']);
|
|
}
|
|
}
|
|
//分页操作
|
|
$totalSql = str_replace($field,'count(*)',$sql);
|
|
$total = pdo_fetchcolumn($totalSql.$where);
|
|
$pager = wl_pagination($total, $page, $pageIndex);
|
|
//获取行业职位信息
|
|
$industry = Recruit::getIndustryList(['pid'=>0],['id','title']);//上级行业列表
|
|
if ($industryPid) $subIndustry = Recruit::getIndustryList(['pid'=>$industryPid],['id','title']);//子行业列表
|
|
if ($industryId) $position = Recruit::getPositionList(['industry_id'=>$industryId],['id','title']);//子行业列表
|
|
|
|
|
|
|
|
include wl_template('order/index');
|
|
}
|
|
|
|
|
|
}
|