public function get_hot_job($id)
{
$sql = "select * from stj_job where stj_job.employ>(select count(*) from stj_record where stj_record.j_id = stj_job.id and audstart=6) and checkinfo='true' and endtime>unix_timestamp(now()) and is_deleted=0 and cpid={$id} order by orderid ASC,checktime DESC, starttime DESC";
$return_data = $this->table('stj_job job')->query($sql);
//得到岗位名称信息
foreach ($return_data as $k => $v) {
$com_sql = "select com.cpname,com.id cpid from stj_company com where com.id=" . $v['cpid'];
//关联公司信息
$cas_sql = "select cas.cascname from stj_casclist cas where cas.id=" . $v['jobplace'];
//关联casclist
$return_data_com = $this->table('stj_company com')->query($com_sql);
//echo"<pre>";var_dump($return_data_com);echo"</pre>";
$return_data_cas = $this->table('stj_casclist cas')->query($cas_sql);
//echo"<pre>";var_dump($return_data_cas);echo"</pre>";
foreach ($return_data_com[0] as $k1 => $v1) {
$return_data[$k][$k1] = $v1;
}
foreach ($return_data_cas[0] as $k1 => $v1) {
$return_data[$k][$k1] = $v1;
}
//发布时间
$return_data[$k]['starttime'] = $return_data[$k]['checktime'] != 0 ? date('Y-m-d', $return_data[$k]['checktime']) : date('Y-m-d', $return_data[$k]['starttime']);
//得到 职位名称 数据
if (empty($return_data[$k]['title'])) {
$return_data[$k]['title'] = getCascList($return_data[$k]['Jobcate'], "信息不明");
}
//招聘资费处理
if ($return_data[$k]['Tariff'] > 10) {
$return_data[$k]['Tariff'] = floor($return_data[$k]['Tariff'] * 0.8 / 100) * 100;
} else {
$return_data[$k]['Tariff'] = floor($return_data[$k]['treatment'] * $return_data[$k]['Tariff'] * 12 * 0.8 / 100) * 100;
}
//得到 薪资待遇 数据
$treatmentdata = getCascData('treatment', $return_data[$k]['treatment'], "信息不明");
$arTreatmentdata = explode("-", str_replace("元", "", $treatmentdata));
if (count($arTreatmentdata) == 1) {
$return_data[$k]['treatmentdata'] = "80K以上";
} else {
$return_data[$k]['treatmentdata'] = $arTreatmentdata[0] / 1000 . "K-" . $arTreatmentdata[1] / 1000 . "K";
}
//$return_data[$k]['treatmentdata'] = ($arTreatmentdata[0] / 1000) . "K-" . ($arTreatmentdata[1] / 1000) . "K";
//得到 工作经验 数据
$experiencedata = getCascData('experience', $return_data[$k]['experience'], "信息不明");
$return_data[$k]['experiencedata'] = $experiencedata;
//得到 学历要求 数据
$educationdata = getCascData('education', $return_data[$k]['education'], "无要求");
$return_data[$k]['educationdata'] = $educationdata;
//得到推荐人数
$recommended_sql = "select count(*) as num from stj_record where stj_record.j_id = {$v['id']}";
$recommendedArr = $this->table('stj_record')->query($recommended_sql);
$return_data[$k]['recommendednum'] = $recommendedArr[0]['num'];
//echo "<pre>";var_dump($return_data);echo"</pre>";
}
return $return_data;
}
public function recommend_list($uid, $limit)
{
$return_data = $this->table("stj_resume res")->field("res.username,res.keyword,res.id,res.state,res.job_id,res.keyid,res.mobile,res.sex")->where("t_id=" . $uid . " and isshow=1")->order("id desc")->limit($limit)->select();
//echo "<pre>";var_dump($return_data);echo"</pre>";
//得到岗位名称信息
foreach ($return_data as $k => $v) {
//得到 公司阶段 数据
$statedata = getCascData('zzstart', $return_data[$k]['state'], "信息不明");
$return_data[$k]['statedata'] = $statedata;
}
return $return_data;
}
public function resume_list($uid, $limit, $jobid)
{
$return_data = $this->table("stj_resume res")->field("res.username,res.id,res.state,res.job_id,res.keyid,res.mobile")->where("t_id=" . $uid)->order("id desc")->limit($limit)->select();
//echo "<pre>";var_dump($return_data);echo"</pre>";
//得到岗位名称信息
foreach ($return_data as $k => $v) {
//得到 公司阶段 数据
$statedata = getCascData('zzstart', $return_data[$k]['state'], "信息不明");
$return_data[$k]['statedata'] = $statedata;
//判断某个简历是否已经被推荐到这个职位
$recordOb = M('record');
// $recordArr = $recordOb->where("bt_id=" . $return_data[$k]['id'] . " and t_id=" . $uid . " and j_id=" . $jobid." and (audstart=1 or audstart=3 or audstart=5 or audstart=6) and status !=1")->find();
$recordArr = $recordOb->where("bt_id=" . $return_data[$k]['id'] . " and t_id=" . $uid . " and j_id=" . $jobid)->find();
//echo $recordOb -> getLastSql();
if (!empty($recordArr)) {
$return_data[$k]['deadline'] = 1;
//已经推荐过得状态
} else {
$return_data[$k]['deadline'] = 0;
//已经推荐过得状态
}
}
return $return_data;
}
public function getRecommendJob($type = 1, $limit, $uid)
{
if ($type == 1) {
$sql = "select *,rec.id recordid from stj_job job join stj_record rec on job.id=rec.j_id and job.employ>(select count(*) from stj_record rec where rec.j_id = job.id and audstart=6) and checkinfo='true' and endtime>unix_timestamp(now()) and is_deleted=0 and rec.t_id={$uid} order by orderid asc, starttime desc limit {$limit}";
} else {
$sql = "select *,rec.id recordid from stj_job job join stj_record rec on job.id=rec.j_id and rec.t_id={$uid} and checkinfo='true' and (job.employ<(select count(*) from stj_record rec where rec.j_id = job.id and audstart=6) or is_deleted=1 or endtime < unix_timestamp(now())) order by orderid asc, starttime desc limit {$limit}";
//echo $sql;
}
$return_data = $this->table('stj_job')->query($sql);
foreach ($return_data as $k => $v) {
//通过简历id bt_id 得到被推荐人姓名
$resumeOb = M("resume");
$resumeArr = $resumeOb->where("id=" . $return_data[$k]["bt_id"])->find();
$return_data[$k]['username'] = $resumeArr['username'];
//通过公司id cpid 得到公司名字
$comOb = M("company");
$comArr = $comOb->field('cpname')->where("id=" . $return_data[$k]["cpid"])->find();
$return_data[$k]['cpname'] = $comArr['cpname'];
//得到岗位名称信息
if (empty($return_data[$k]['title'])) {
$return_data[$k]['title'] = getCascList($return_data[$k]['Jobcate'], "信息不明");
}
//通过工作地点的信息
$cascOb = M("casclist");
$cascArr = $cascOb->field('cascname')->where("id=" . $return_data[$k]['jobplace'])->find();
$return_data[$k]['cascname'] = $cascArr['cascname'];
//得到 薪资待遇 数据
$treatmentdata = getCascData('treatment', $return_data[$k]['treatment'], "信息不明");
$arTreatmentdata = explode("-", str_replace("元", "", $treatmentdata));
if (count($arTreatmentdata) == 1) {
$return_data[$k]['treatmentdata'] = "80K以上";
} else {
$return_data[$k]['treatmentdata'] = $arTreatmentdata[0] / 1000 . "K-" . $arTreatmentdata[1] / 1000 . "K";
}
//$return_data[$k]['treatmentdata'] = ($arTreatmentdata[0] / 1000) . "K-" . ($arTreatmentdata[1] / 1000) . "K";
//招聘资费处理
if ($return_data[$k]['Tariff'] > 10) {
$return_data[$k]['Tariff'] = floor($return_data[$k]['Tariff'] * 0.8 / 100) * 100;
} else {
$return_data[$k]['Tariff'] = floor($return_data[$k]['treatment'] * $return_data[$k]['Tariff'] * 12 * 0.8 / 100) * 100;
}
//得到 面试状态 信息
$audstartdata = getCascData('audstart', $return_data[$k]['audstart'], "信息不明");
$return_data[$k]['audstartdata'] = $audstartdata;
//已推荐的人数
$recommended_sql = "select count(*) as num from stj_record where stj_record.j_id = {$v['id']}";
$recommendedArr = $this->table('stj_record')->query($recommended_sql);
$return_data[$k]['recommendnum'] = $recommendedArr[0]['num'];
}
return $return_data;
}
public function updateUserStatus()
{
$reasonid = $_POST['reasonid'];
$data['audstart'] = $_POST['statused'];
if (!empty($_POST['content'])) {
$data['audreason'] = $_POST['content'];
}
if (!empty($_POST['candidate_time'])) {
$data['real_audstart_time'] = $_POST['candidate_time'];
}
$data['audstarttime'] = time();
$status = M("record")->where("id='{$reasonid}'")->save($data);
$status = $_POST['statused'];
$statusValue = getCascData("audstart", $status, "信息不明");
//推荐info
$recordinfo = M("record")->where("id='{$reasonid}'")->find();
/* * *********************【推荐人/企业】【修改面试状态】操作日志 begin*********************************** */
$resumeInfo = M("resume")->where("id=" . $recordinfo['bt_id'])->find();
$arJobInfo = M("job")->where("id=" . $recordinfo['j_id'])->find();
$arCompanyInfo = M("company")->where("id=" . $arJobInfo['cpid'])->find();
if (!$arJobInfo['title']) {
$arJobInfo['title'] = M("casclist")->where("id='{$arJobInfo['Jobcate']}'")->getField("cascname");
}
if ($data['audreason']) {
$arTNoticeInfo = getTNoticeInfo(9, $resumeInfo['username'], $arCompanyInfo['cpname'], $arJobInfo['title'], "", $statusValue, $data['audreason']);
$arCNoticeInfo = getCNoticeInfo(9, $arJobInfo['title'], $resumeInfo['username'], $statusValue, $data['audreason']);
} else {
$arTNoticeInfo = getTNoticeInfo(7, $resumeInfo['username'], $arCompanyInfo['cpname'], $arJobInfo['title'], "", $statusValue);
$arCNoticeInfo = getCNoticeInfo(7, $arJobInfo['title'], $resumeInfo['username'], $statusValue);
}
$sLogtitle = $arTNoticeInfo[0];
$sLogContent = $arTNoticeInfo[1];
addNoticeLog($arCompanyInfo['id'], $arCompanyInfo['username'], $recordinfo['bt_id'], $recordinfo['j_id'], $sLogtitle, $sLogContent);
$sLogtitle = $arCNoticeInfo[0];
$sLogContent = $arCNoticeInfo[1];
addNoticeLog($arCompanyInfo['id'], $arCompanyInfo['username'], $recordinfo['bt_id'], $recordinfo['j_id'], $sLogtitle, $sLogContent, 1, 2);
/* * *********************【推荐人/企业】【修改面试状态】操作日志 end*********************************** */
//////////////////////////分享职位送大礼/////////////////////////////////
if (C("SHARE_JON_OPEN") === true) {
// $id = $_POST['rid'] = 499;
//如果是活动1并且是已入职状态则查看是否已经为推荐人的来源用户赠送过
$activiteID = C("SHARE_JOB_ID");
if ($status == 6 && $activiteID == 2) {
$activeInfo = M("active")->where("id='{$activiteID}' and status=1 and endtime>'" . date("Y-m-d H:i:s") . "'")->find();
if ($activeInfo) {
$memberId = $recordinfo['t_id'];
$userInfo = M("member")->where("id=" . $memberId . " AND fromwhere='share'")->find();
if ($userInfo) {
//如果存在还没有赠送过并且有来源的username，则赠送给分享人金额
$userinfo = M("userinfo")->where("username='******' and fromusername !=''")->find();
if ($userinfo) {
$Recorduserinfo = M("userinfo")->where("username='******'")->find();
$accArr = M("account")->where("uid='{$Recorduserinfo['userid']}'")->find();
//查找推荐人之前的账户信息
$time = time();
if (empty($accArr)) {
//插入一条信息账户信息到account表中
$sql = "insert into stj_account(uid,username,account,created_at,updated_at) values({$Recorduserinfo['userid']},'{$Recorduserinfo['username']}'," . C('SHARE_JOB_RECORD_SUCCESS') . ",'{$time}','{$time}')";
M("account")->query($sql);
$newAccount = C('SHARE_JOB_RECORD_SUCCESS');
$account = 0;
} else {
//插入一条日志记录到account_balance中
$newAccount = $accArr['account'] + C('SHARE_JOB_RECORD_SUCCESS');
//更新账户表中的金额和更新时间
$sql = "update stj_account set account='{$newAccount}',updated_at='{$time}' where id ={$accArr['id']}";
M("account")->query($sql);
$account = $accArr['account'];
}
$sql = "insert into stj_account_blance(uid,username,last_account,account,incr,operat,`from`,comment,created_at,updated_at) values({$Recorduserinfo[userid]},'{$Recorduserinfo[username]}',{$account},{$newAccount}," . C('SHARE_JOB_RECORD_SUCCESS') . ",'','shareMoney','分享职位成功入职。','{$time}','{$time}')";
M("account_blance")->query($sql);
//首次推荐修改状态
$sql = "update stj_share set num=`num`+1 where decrypturl ='{$userinfo['fromwhere']}'";
M("share")->query($sql);
}
}
}
}
//如果是活动1并且是已入职状态并且此人是通过分享而来则赠送分享人奖励
$activiteID = C("SHARE_JOB_ID");
if ($status == 6 && $activiteID == 2) {
$activeInfo = M("active")->where("id='{$activiteID}' and status=1 and endtime>'" . date("Y-m-d H:i:s") . "'")->find();
if ($activeInfo) {
$jobInfo = M("job")->where("id='{$recordinfo['j_id']}'")->find();
$memberId = $jobInfo['cpid'];
$userInfo = M("company")->where("id=" . $memberId . " AND fromwhere='share'")->find();
if ($userInfo) {
//如果存在还没有赠送过并且有来源的username，则赠送给分享人金额
$userinfo = M("userinfo")->where("username='******' and fromusername !=''")->find();
if ($userinfo) {
$Recorduserinfo = M("userinfo")->where("username='******'")->find();
$accArr = M("account")->where("uid='{$Recorduserinfo['userid']}'")->find();
//查找推荐人之前的账户信息
$time = time();
if (empty($accArr)) {
//插入一条信息账户信息到account表中
$sql = "insert into stj_account(uid,username,account,created_at,updated_at) values({$Recorduserinfo['userid']},'{$Recorduserinfo['username']}'," . C('SHARE_JOB_COMPANY_SUCCESS') . ",'{$time}','{$time}')";
M("account")->query($sql);
$newAccount = C('SHARE_JOB_COMPANY_SUCCESS');
$account = 0;
} else {
//插入一条日志记录到account_balance中
$newAccount = $accArr['account'] + C('SHARE_JOB_COMPANY_SUCCESS');
//更新账户表中的金额和更新时间
$sql = "update stj_account set account='{$newAccount}',updated_at='{$time}' where id ={$accArr['id']}";
M("account")->query($sql);
$account = $accArr['account'];
}
$sql = "insert into stj_account_blance(uid,username,last_account,account,incr,operat,`from`,comment,created_at,updated_at) values({$Recorduserinfo[userid]},'{$Recorduserinfo[username]}',{$account},{$newAccount}," . C('SHARE_JOB_COMPANY_SUCCESS') . ",'','shareMoney','分享职位企业成功入职。','{$time}','{$time}')";
M("account_blance")->query($sql);
//首次推荐修改状态
$sql = "update stj_share set num=`num`+1 where decrypturl ='{$userinfo['fromwhere']}'";
M("share")->query($sql);
}
}
}
}
}
////////////////////////////////推广奖利送大礼////////////////////////////////////////////////////////
if (C("SHARE_RECOMMENDSHARE_OPEN") === true && $status == 6) {
$activiteID = C("SHARE_RECOMMENDSHARE_ID");
if ($status == 6 && $activiteID == 4) {
$activeInfo = M("active")->where("id='{$activiteID}' and status=1 and endtime>'" . date("Y-m-d H:i:s") . "'")->find();
if ($activeInfo) {
$memberId = $recordinfo['t_id'];
$userInfo = M("member")->where("id=" . $memberId . " AND fromwhere='recommentshare'")->find();
if ($userInfo) {
//如果存在还没有赠送过并且有来源的username，则赠送给分享人金额
$userinfo = M("userinfo")->where("username='******' and fromusername !=''")->find();
if ($userinfo) {
$Recorduserinfo = M("userinfo")->where("username='******'")->find();
$accArr = M("account")->where("uid='{$Recorduserinfo['userid']}'")->find();
//查找推荐人之前的账户信息
$time = time();
if (empty($accArr)) {
//插入一条信息账户信息到account表中
$sql = "insert into stj_account(uid,username,account,created_at,updated_at) values({$Recorduserinfo['userid']},'{$Recorduserinfo['username']}'," . C('SHARE_RECOMMENDSHARE_RECORD_SUCCESS') . ",'{$time}','{$time}')";
M("account")->query($sql);
$newAccount = C('SHARE_RECOMMENDSHARE_RECORD_SUCCESS');
$account = 0;
} else {
//插入一条日志记录到account_balance中
$newAccount = $accArr['account'] + C('SHARE_RECOMMENDSHARE_RECORD_SUCCESS');
//更新账户表中的金额和更新时间
$sql = "update stj_account set account='{$newAccount}',updated_at='{$time}' where id ={$accArr['id']}";
M("account")->query($sql);
$account = $accArr['account'];
}
$sql = "insert into stj_account_blance(uid,username,last_account,account,incr,operat,`from`,comment,created_at,updated_at) values({$Recorduserinfo[userid]},'{$Recorduserinfo[username]}',{$account},{$newAccount}," . C('SHARE_RECOMMENDSHARE_RECORD_SUCCESS') . ",'','recommendShare ','推广分享奖励。 。','{$time}','{$time}')";
M("account_blance")->query($sql);
//首次推荐修改状态
$sql = "update stj_share set num=`num`+1 where decrypturl ='{$userinfo['fromwhere']}'";
M("share")->query($sql);
}
}
}
}
$activiteID = C("SHARE_RECOMMENDSHARE_ID");
if ($status == 6 && $activiteID == 4) {
$activeInfo = M("active")->where("id='{$activiteID}' and status=1 and endtime>'" . date("Y-m-d H:i:s") . "'")->find();
if ($activeInfo) {
$jobInfo = M("job")->where("id='{$recordinfo['j_id']}'")->find();
$memberId = $jobInfo['cpid'];
$userInfo = M("company")->where("id=" . $memberId . " AND fromwhere='recommentshare'")->find();
if ($userInfo) {
//如果存在还没有赠送过并且有来源的username，则赠送给分享人金额
$userinfo = M("userinfo")->where("username='******' and fromusername !=''")->find();
if ($userinfo) {
$Recorduserinfo = M("userinfo")->where("username='******'")->find();
$accArr = M("account")->where("uid='{$Recorduserinfo['userid']}'")->find();
//查找推荐人之前的账户信息
$time = time();
if (empty($accArr)) {
//插入一条信息账户信息到account表中
$sql = "insert into stj_account(uid,username,account,created_at,updated_at) values({$Recorduserinfo['userid']},'{$Recorduserinfo['username']}'," . C('SHARE_RECOMMENDSHARE_COMPANY_SUCCESS') . ",'{$time}','{$time}')";
M("account")->query($sql);
$newAccount = C('SHARE_RECOMMENDSHARE_COMPANY_SUCCESS');
$account = 0;
} else {
//插入一条日志记录到account_balance中
$newAccount = $accArr['account'] + C('SHARE_RECOMMENDSHARE_COMPANY_SUCCESS');
//更新账户表中的金额和更新时间
$sql = "update stj_account set account='{$newAccount}',updated_at='{$time}' where id ={$accArr['id']}";
M("account")->query($sql);
$account = $accArr['account'];
}
$sql = "insert into stj_account_blance(uid,username,last_account,account,incr,operat,`from`,comment,created_at,updated_at) values({$Recorduserinfo[userid]},'{$Recorduserinfo[username]}',{$account},{$newAccount}," . C('SHARE_RECOMMENDSHARE_COMPANY_SUCCESS') . ",'','recommendShare ','推广分享奖励。','{$time}','{$time}')";
M("account_blance")->query($sql);
//首次推荐修改状态
$sql = "update stj_share set num=`num`+1 where decrypturl ='{$userinfo['fromwhere']}'";
M("share")->query($sql);
}
}
}
}
}
// $recordInfo = M("record")->where("id='$reasonid'")->find();
// echo M("record")->getLastSql();
echo json_encode("ok");
}
public function getJobInfo($page, $job_id = 0, $num = 10)
{
$id = $job_id;
$start = ($page - 1) * $num;
$checkUserPavi = $this->checkUserPaviliong();
$checkUserPavi['telephone'] = $checkUserPavi['mobile'] ? $checkUserPavi['mobile'] : $checkUserPavi['telephone'];
if ($checkUserPavi === false) {
return false;
}
$jobInfoTmp = array();
//获取职位信息
if ($id) {
$jobInfoTmp = M("job")->where("id='{$id}'")->find();
//职位名称
if (!$jobInfoTmp['title']) {
$jobInfoTmp['title'] = M("casclist")->where("id='{$jobInfoTmp['Jobcate']}'")->getField("cascname");
}
}
$arJobList = M("job")->where("cpid=" . $checkUserPavi['id'] . " and is_deleted=0 and checkinfo='true' and endtime>" . time())->order("id desc")->select();
$checked = $checkUserPavi['checkinfo'];
if ($checked == "true") {
$arJobIDTmp = array();
if ($arJobList) {
if ($id) {
$where = " and j_id='{$id}'";
} else {
foreach ($arJobList as &$jobInfo) {
if (!$jobInfo['title']) {
$jobInfo['title'] = M("casclist")->where("id='{$jobInfo['Jobcate']}'")->getField("cascname");
}
array_push($arJobIDTmp, $jobInfo['id']);
}
$sJobIDTmp = implode(",", $arJobIDTmp);
$where = " and j_id in (" . $sJobIDTmp . ")";
}
$count = M("record")->where("status=2 " . $where)->count();
$arRecordList = M("record")->where("status=2 " . $where)->order("j_id desc,id desc")->limit($start, $num)->select();
if ($arRecordList) {
foreach ($arRecordList as $key => &$record) {
$Resume = M("resume")->where("id=" . $record['bt_id'])->find();
$record['bt_username'] = $Resume['username'];
$job = M("job")->where("id='{$record['j_id']}'")->find();
//职位名称
if (!$job['title']) {
$record['title'] = M("casclist")->where("id='{$job['Jobcate']}'")->getField("cascname");
} else {
$record['title'] = $job['title'];
}
$record['t_username'] = M("member")->where("id='{$Resume['t_id']}'")->getField("username");
$record['state'] = getCascData('zzstart', $Resume['state']);
$record['mobile'] = $Resume['mobile'];
$record['sink'] = $record['sink'] == 1 ? "未打款" : "已打款";
$Resume['posttime'] = $record['posttime'] != 0 ? date("Y-m-d", $record['posttime']) : "";
$record['audstart_status'] = $record[audstart];
$record['audstart'] = M("cascadedata")->where("datavalue='{$record['audstart']}' and datagroup='audstart'")->getField("dataname");
$record['audstartdate'] = $record['audstartdate'] ? $record['audstartdate'] : "电话沟通";
}
}
} else {
$arRecordList = false;
}
}
$arAudreasonList = M("cascadedata")->where("datagroup='audstart'")->order("orderid asc")->select();
return array("company" => $checkUserPavi, "arAudreasonList" => $arAudreasonList, "checked" => $checked, "arRecordList" => $arRecordList, "arJobList" => $arJobList, "jobInfoTmp" => $jobInfoTmp, "id" => $id);
}