<?php
|
/*
|
* $Author ：PHPYUN开发团队
|
*
|
* 官网: http://www.phpyun.com
|
*
|
* 版权所有 2009-2021 宿迁鑫潮信息技术有限公司，并保留所有权利。
|
*
|
* 软件声明：未经授权前提下，不得用于商业运营、二次开发以及任何形式的再次发布。
|
*/
|
class rating_model extends model{
|
|
/**
|
* @desc 企业会员等级新增 5.1
|
* @param int $id
|
* @param int $uid
|
* @param int $add 后台充值：开通套餐 $add | 1-累加，2-不累加
|
* @return array $value
|
*/
|
public function ratingInfo($id = 0, $uid = 0, $add = 0)
|
{
|
|
$id = intval($id) == 0 ? $this -> config['com_rating'] : intval($id);
|
$uid = intval($uid);
|
$value = array();
|
|
//获取企业账户套餐信息
|
$statis = $this -> select_once('company_statis', array('uid' => $uid));
|
|
if ((int)$add > 0){
|
|
$acc = $add;
|
}else{
|
|
$ratingAdd = explode(',', $this->config['rating_add']);
|
$acc = in_array($statis['rating'], $ratingAdd) ? 1 : 2;
|
}
|
|
//获取会员等级
|
$row = $this -> getInfo(array('id' => $id, 'category' => 1));
|
|
if($statis['rating_type'] == $row['type'] && $row['type'] == 1 && $acc== 1){ // 套餐会员累加：后台选择当前会员累加 && 同为套餐会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
|
$time = 0;
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
/*套餐数据累加*/
|
if(isVip($statis['vip_etime'])){
|
$value['job_num'] = array('+', (int)$row['job_num']);
|
$value['breakjob_num'] = array('+', (int)$row['breakjob_num']);
|
$value['down_resume'] = array('+', (int)$row['resume']);
|
$value['invite_resume'] = array('+', (int)$row['interview']);
|
$value['zph_num'] = array('+', (int)$row['zph_num']);
|
$value['urgent_num'] = array('+', (int)$row['urgent_num']);
|
$value['rec_num'] = array('+', (int)$row['rec_num']);
|
$value['top_num'] = array('+', (int)$row['top_num']);
|
$value['integral'] = array('+', (int)$row['integral_buy']);
|
$value['sons_num'] = array('+', (int)$row['sons_num']);
|
$value['chat_num'] = array('+', (int)$row['chat_num']);
|
$value['spview_num'] = array('+', (int)$row['spview_num']);
|
}else{
|
$value['job_num'] = array('=', (int)$row['job_num']);
|
$value['breakjob_num'] = array('=', (int)$row['breakjob_num']);
|
$value['down_resume'] = array('=', (int)$row['resume']);
|
$value['invite_resume'] = array('=', (int)$row['interview']);
|
$value['zph_num'] = array('=', (int)$row['zph_num']);
|
$value['top_num'] = array('=', (int)$row['top_num']);
|
$value['urgent_num'] = array('=', (int)$row['urgent_num']);
|
$value['rec_num'] = array('=', (int)$row['rec_num']);
|
$value['sons_num'] = array('=', (int)$row['sons_num']);
|
$value['chat_num'] = array('=', (int)$row['chat_num']);
|
$value['spview_num'] = array('=', (int)$row['spview_num']);
|
}
|
/*累加数据End*/
|
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
|
}else if($statis['rating_type'] == $row['type'] && $row['type'] == 2 && $acc== 1){ // 时间会员期限累加：后台选择当前身份会员累加 && 同为时间会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
|
}else{
|
|
$time = time() + 86400 * $row['service_time'];
|
|
}
|
}else{ // 永久套餐
|
|
$time = 0;
|
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
$value['job_num'] = array('=', (int)$row['job_num']);
|
$value['breakjob_num'] = array('=', (int)$row['breakjob_num']);
|
$value['down_resume'] = array('=', (int)$row['resume']);
|
$value['invite_resume'] = array('=', (int)$row['interview']);
|
$value['zph_num'] = array('=', (int)$row['zph_num']);
|
$value['top_num'] = array('=', (int)$row['top_num']);
|
$value['urgent_num'] = array('=', (int)$row['urgent_num']);
|
$value['rec_num'] = array('=', (int)$row['rec_num']);
|
$value['sons_num'] = array('=', (int)$row['sons_num']);
|
$value['chat_num'] = array('=', (int)$row['chat_num']);
|
$value['spview_num'] = array('=', (int)$row['spview_num']);
|
$value['integral'] = array('+', (int)$row['integral_buy']);
|
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
|
|
}else if($statis['rating_type'] != $row['type'] || $acc!= 1){ // 直接覆盖: 时间类型和套餐类型相互转换 || 后台未选择当前身份会员累加
|
|
if($row['service_time'] > 0){
|
|
$time = time() + 86400 * $row['service_time'];
|
|
}else{
|
|
$time = 0;
|
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
$value['job_num'] = array('=', (int)$row['job_num']);
|
$value['breakjob_num'] = array('=', (int)$row['breakjob_num']);
|
$value['down_resume'] = array('=', (int)$row['resume']);
|
$value['invite_resume'] = array('=', (int)$row['interview']);
|
$value['zph_num'] = array('=', (int)$row['zph_num']);
|
$value['top_num'] = array('=', (int)$row['top_num']);
|
$value['urgent_num'] = array('=', (int)$row['urgent_num']);
|
$value['rec_num'] = array('=', (int)$row['rec_num']);
|
$value['sons_num'] = array('=', (int)$row['sons_num']);
|
$value['chat_num'] = array('=', (int)$row['chat_num']);
|
$value['spview_num'] = array('=', (int)$row['spview_num']);
|
$value['integral'] = array('+', (int)$row['integral_buy']);
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
$value['oldrating_name'] = $row['name'];
|
|
|
}
|
|
//赠送优惠券
|
if($row['coupon'] > 0 && $row['time_start'] < time() && $row['time_end'] > time()){
|
$coupon = $this -> select_once("coupon", array('id' => array('=', $row['coupon'])));
|
$data = array();
|
$data['uid'] = $uid;
|
$data['number'] = time();
|
$data['ctime'] = time();
|
$data['coupon_id'] = $coupon['id'];
|
$data['coupon_name'] = $coupon['name'];
|
$data['validity'] = time() + $coupon['time']*86400;
|
$data['coupon_amount'] = $coupon['amount'];
|
$data['coupon_scope'] = $coupon['scope'];
|
$this -> insert_into('coupon_list', $data);
|
}
|
|
return $value;
|
|
}
|
|
/**
|
* @desc 猎头会员等级信息
|
* @param int $id
|
* @param int $uid
|
* @return array
|
*/
|
public function ltratingInfo($id = 0, $uid = 0){
|
|
$id = intval($id) == 0 ? $this->config['lt_rating'] : intval($id);
|
$uid = intval($uid);
|
|
$value = array();
|
|
//获取猎头统计信息
|
$statis = $this -> select_once('lt_statis', array('uid' => $uid));
|
|
$ltRatingAdd= explode(',', $this->config['lt_rating_add']);
|
$acc = in_array($statis['rating'], $ltRatingAdd) ? 1 : 2;
|
|
//获取猎头会员等级
|
$row = $this -> getInfo(array('id' => $id, 'category' => 2));
|
|
if($statis['rating_type'] == $row['type'] && $row['type'] == 1 && $acc== 1){ // 套餐会员累加：后台选择当前身份会员累加 && 同为套餐会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
/*套餐数据累加*/
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
}else{
|
$value['lt_job_num'] = $statis['lt_job_num'] + $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $statis['lt_breakjob_num'] + $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $statis['lt_down_resume'] + $row['lt_resume'];
|
$value['chat_num'] = $statis['chat_num'] + $row['chat_num'];
|
}
|
/*累加数据End*/
|
$value['vip_etime'] = $time;
|
|
}else if($statis['rating_type'] == $row['type'] && $row['type'] == 2 && $acc== 1){ // 时间会员期限累加：后台选择当前身份会员累加 && 同为时间会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
$value['vip_etime'] = $time;
|
}else if($statis['rating_type'] != $row['type'] || $acc!=1){ // 直接覆盖: 时间类型和套餐类型相互转换 || 后台未选择当前身份会员累加
|
|
if($row['service_time'] > 0){
|
$time = time() + 86400 * $row['service_time'];
|
}else{
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
$value['vip_etime'] = $time;
|
}
|
|
//赠送优惠券
|
if($row['coupon'] > 0 && $row['time_start'] < time() && $row['time_end'] > time()){
|
$coupon = $this -> select_once("coupon", array('id' => array('=', $row['coupon'])));
|
$data = array();
|
$data['uid'] = $uid;
|
$data['number'] = time();
|
$data['ctime'] = time();
|
$data['coupon_id'] = $coupon['id'];
|
$data['coupon_name'] = $coupon['name'];
|
$data['validity'] = time() + $coupon['time']*86400;
|
$data['coupon_amount'] = $coupon['amount'];
|
$data['coupon_scope'] = $coupon['scope'];
|
$this -> insert_into("coupon_list", $data);
|
}
|
return $value;
|
}
|
|
/**
|
* @desc 获取会员等级列表
|
*
|
* @param $whereData 查询条件
|
* @param array $data 自定义处理数组 coupon:获取套餐赠送的优惠券数据
|
* @return array|bool|false|string|void
|
*/
|
public function getList($whereData, $data = array())
|
{
|
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
$ListRating = $this->select_all('company_rating', $whereData, $data['field']);
|
|
if ($data['coupon'] == 1) {
|
foreach ($ListRating as $v) {
|
$couponid[] = $v['coupon'];
|
}
|
if (!empty($couponid)) {
|
require_once('coupon.model.php');
|
$couponM = new coupon_model($this->db, $this->def);
|
$coupon = $couponM->getList(array('id' => array('in', pylode(",", $couponid))), array('field' => 'id,name'));
|
}
|
if (is_array($coupon)) {
|
foreach ($ListRating as $k => $v) {
|
foreach ($coupon as $val) {
|
if ($v['coupon'] == $val['id']) {
|
$ListRating[$k]['couponname'] = $val['name'];
|
$ListRating[$k]['coupon'] = $val['name'];
|
}
|
}
|
}
|
}
|
}
|
if ($data['utype'] == 'lietou') {
|
foreach ($ListRating as $k => $v) {
|
$rname = array();
|
if ($v['lt_job_num'] > 0) {
|
$rname[] = '猎头发布职位数:' . $v['lt_job_num'] . '份';
|
}
|
if ($v['lt_breakjob_num'] > 0) {
|
$rname[] = '猎头刷新职位数:' . $v['lt_breakjob_num'] . '份';
|
}
|
if ($v['lt_resume'] > 0) {
|
$rname[] = '猎头下载简历数:' . $v['lt_resume'] . '份';
|
}
|
if ($this->config['sy_chat_open'] == 1 && $v['chat_num'] > 0) {
|
$rname[] = '猎头' . $this->config['sy_chat_name'] . '数:' . $v['chat_num'] . '份';
|
}
|
$ListRating[$k]['rname'] = @implode('+', $rname);
|
}
|
}
|
|
foreach ($ListRating as $k => $v){
|
if ($v['type'] == 1){
|
$ListRating[$k]['type_n'] = '套餐会员';
|
}else if ($v['type'] == 2){
|
$ListRating[$k]['type_n'] = '时间会员';
|
}
|
}
|
|
return $ListRating;
|
|
}
|
|
/**
|
* @desc 获取会员等级详情
|
* @param $whereData 查询条件
|
* @param array $data 自定义处理数组
|
* @return array|bool|false|string|void
|
*/
|
public function getInfo($whereData, $data = array())
|
{
|
|
$InfoRating = array();
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
$InfoRating = $this->select_once('company_rating', $whereData, $data['field']);
|
|
if (!empty($InfoRating) && is_array($InfoRating)) {
|
/* 处理会员图标图片 */
|
if (!empty($InfoRating['com_pic'])) {
|
if (trim($InfoRating['com_pic']) != '') {
|
$InfoRating['com_pic'] = checkpic($InfoRating['com_pic']);
|
} else {
|
unset($InfoRating['com_pic']);
|
}
|
}
|
}
|
return $InfoRating;
|
|
}
|
|
/**
|
* @desc 添加company_rating 详情
|
*
|
* @param $addData 添加数据
|
* @return array
|
*/
|
public function addRating($addData){
|
|
$return = array(
|
'id' => 0,
|
'errcode' => 8,
|
'layertype' => 0,
|
'msg' => ''
|
);
|
|
if (isset($addData['category']) && $addData['category']=='1') {
|
|
if ($addData['youhui']) {
|
|
if ($addData['time']=='') {
|
$return['errcode'] = 8;
|
$return['msg'] = '请选择优惠日期！';
|
|
return $return;
|
}
|
|
if ($addData['yh_price'] == '' || $addData['yh_price'] > $addData['service_price']) {
|
$return['errcode'] = 8;
|
$return['msg'] = '优惠价格不得大于初始售价！';
|
|
return $return;
|
}
|
|
$times = @explode('~', $addData['time']);
|
$addData['time_start'] = strtotime($times[0].' 00:00:00');
|
$addData['time_end'] = strtotime($times[1].' 23:59:59');
|
|
}else {
|
|
$addData['yh_price'] = 0;
|
$addData['time_start'] = 0;
|
$addData['time_end'] = 0;
|
|
}
|
|
unset($addData['youhui']);
|
unset($addData['id']);
|
|
}elseif (isset($addData['category']) && $addData['category']=='2'){
|
|
if($addData['time']){
|
|
$times = @explode('~', $addData['time']);
|
$addData['time_start'] = strtotime($times[0]);
|
$addData['time_end'] = strtotime($times[1].' 23:59:59');
|
|
}
|
|
unset($addData['id']);
|
unset($addData['time']);
|
|
}
|
if ($addData['file']['tmp_name']){
|
|
$upArr = array(
|
'file' => $_POST['file'],
|
'dir' => 'compic'
|
);
|
require_once ('upload.model.php');
|
$uploadM = new upload_model($this->db, $this->def);
|
$pic = $uploadM->newUpload($upArr);
|
if (!empty($pic['msg'])){
|
|
$return['errcode'] = 8;
|
$return['msg'] = $pic['msg'];
|
return $return;
|
|
}elseif (!empty($pic['picurl'])){
|
|
$addData['com_pic'] = $pic['picurl'];
|
}
|
}
|
unset($addData['file']);
|
if (!empty($addData)){
|
|
$return['id'] = $this -> insert_into('company_rating', $addData);
|
|
}
|
|
$typeStr = $this -> categoryMap($addData['category']);
|
|
$typeStr .= '（ID：'.$return['id'].'）添加';
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
$return['msg'] = $return['id'] ? $typeStr.'成功！' : $typeStr.'失败！';
|
|
return $return;
|
|
}
|
|
/**
|
* @desc 修改company_rating 详情
|
* $id 修改条件ID数据
|
* $upData 修改的数据
|
* $data 自定义处理数组
|
*/
|
public function upRating($id = null, $upData = array()){
|
|
$return = array(
|
'id' => 0,
|
'errcode' => 8,
|
'layertype' => 0,
|
'msg' => ''
|
);
|
|
if (isset($upData['category']) && $upData['category']=='1') {
|
if ($upData['youhui']) {
|
|
if ($upData['time']=='') {
|
$return['errcode'] = 8;
|
$return['msg'] = '请选择优惠日期！';
|
|
return $return;
|
}
|
|
if ($upData['yh_price'] == '' || $upData['yh_price'] > $upData['service_price']) {
|
$return['errcode'] = 8;
|
$return['msg'] = '优惠价格不得大于初始售价！';
|
|
return $return;
|
}
|
|
$times = @explode('~', $upData['time']);
|
$upData['time_start'] = strtotime($times[0].' 00:00:00');
|
$upData['time_end'] = strtotime($times[1].' 23:59:59');
|
|
}else {
|
|
$upData['yh_price'] = 0;
|
$upData['time_start'] = 0;
|
$upData['time_end'] = 0;
|
|
}
|
|
unset($upData['youhui']);
|
unset($upData['useradd']);
|
unset($upData['id']);
|
|
}elseif (isset($upData['category']) && $upData['category']=='2'){
|
|
if($upData['time']){
|
$times = @explode('~', $upData['time']);
|
$upData['time_start'] = strtotime($times[0]);
|
$upData['time_end'] = strtotime($times[1].' 23:59:59');
|
}
|
|
unset($upData['useradd']);
|
unset($upData['id']);
|
unset($upData['time']);
|
}
|
|
if ($upData['file']['tmp_name']){
|
|
$upArr = array(
|
'file' => $upData['file'],
|
'dir' => 'compic'
|
);
|
require_once ('upload.model.php');
|
$uploadM = new upload_model($this->db, $this->def);
|
$pic = $uploadM->newUpload($upArr);
|
if (!empty($pic['msg'])){
|
|
$return['errcode'] = 8;
|
$return['msg'] = $pic['msg'];
|
return $return;
|
|
}elseif (!empty($pic['picurl'])){
|
|
$upData['com_pic'] = $pic['picurl'];
|
}
|
}
|
unset($upData['file']);
|
if (!empty($upData) && !empty($id)){
|
|
$return['id'] = $this -> update_once('company_rating', $upData, array('id'=>intval($id)));
|
|
}
|
|
$typeStr = $this -> categoryMap($upData['category']);
|
|
$typeStr .= '（ID：'.$id.'）更新';
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
|
$return['msg'] = $return['id'] ? $typeStr.'成功！' : $typeStr.'失败！';
|
|
return $return;
|
}
|
|
/**
|
* @desc 删除company_rating 详情
|
* $whereData 删除条件数据
|
* $data 自定义处理数组
|
*/
|
public function delRating($id = null, $data = array()){
|
|
$return = array(
|
'id' => 0,
|
'errcode' => 8,
|
'layertype' => 0,
|
'msg' => ''
|
);
|
|
if (is_array($id)) {
|
|
$ids = $id;
|
|
$return['layertype'] = 1;
|
|
}else{
|
|
$ids = @explode(',', $id);
|
|
$return['layertype'] = 0;
|
}
|
|
$typeStr = $this -> categoryMap($data['category']);
|
|
if (!empty($ids)){
|
|
$return['id'] = $this -> delete_all('company_rating', array('id'=>array('in', pylode(',', $ids))), '');
|
|
}
|
|
$typeStr .= '（ID：'.$id.'）删除';
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
$return['msg'] = $return['id'] ? $typeStr.'成功！' : $typeStr.'失败！';
|
|
return $return;
|
}
|
|
/**
|
* company_rating category 类型
|
*/
|
private function categoryMap($cId){
|
|
$categoryMap = array(
|
1 => '企业会员等级',
|
2 => '猎头会员等级',
|
3 => '企业增值包',
|
4 => '猎头增值包'
|
);
|
return isset($categoryMap[$cId]) ? $categoryMap[$cId] : '';
|
}
|
|
/**
|
* @desc 查询 company_service表数据，单条查询
|
*/
|
function getComServiceInfo($where = array(), $data = array()) {
|
|
$field = $data['field'] ? $data['field'] : '*';
|
|
$info = $this -> select_once('company_service', $where, $field);
|
|
return $info;
|
|
}
|
|
/**
|
* @desc 查询 company_service表数据，多条查询
|
*/
|
function getComServiceList($whereData = array(), $data = array()) {
|
|
$field = $data['field'] ? $data['field'] : '*';
|
|
$List = $this -> select_all('company_service', $whereData, $field);
|
|
if (isset($data['detail']) && $data['detail'] == 'yes') {
|
|
$detailList = $this->getComSerDetailList(array('orderby' => 'sort,desc'));
|
|
if (!empty($detailList) && is_array($detailList)) {
|
|
foreach ($List as $key => $value) {
|
|
foreach ($detailList as $val){
|
|
if ($value['id'] == $val['type']) {
|
|
$List[$key]['detail'][] = $val;
|
}
|
}
|
}
|
}
|
|
}
|
|
return $List;
|
|
}
|
|
/**
|
* @desc 查询 company_service表数据，统计数量
|
* @return number
|
*/
|
function getComServiceNum($whereData = array()) {
|
|
return $this -> select_num('company_service', $whereData);
|
|
}
|
|
/**
|
* @desc 新增 / 修改 企业增值类型
|
*/
|
function upComService($postData = array()) {
|
|
if (isset($postData)) {
|
|
$return = array();
|
|
$id = intval($postData['id']);
|
$name = trim($postData['name']);
|
$sort = intval($postData['sort']);
|
$display = intval($postData['display']);
|
|
$value = array(
|
'name' => $name,
|
'display' => $display,
|
'sort' => $sort
|
);
|
|
if (!empty($id)) {
|
|
$service = $this -> getComServiceList(array('name'=>$name,'id'=>array('<>',$id)));
|
|
if (!empty($service)) {
|
|
$return['errcode'] = 8;
|
$return['msg'] = '增值类型名称已存在！';
|
|
return $return;
|
|
}else{
|
|
$return['id'] = $this -> update_once('company_service', $value, array('id' => $id));
|
|
$msg = '企业增值服务类型（ID：'.$id.'）修改';
|
|
$return['msg'] = $return['id'] ? $msg.'成功！' : $msg.'失败！' ;
|
|
$return['errcode'] = $return['id'] ? 9 : 8 ;
|
|
$return['url'] = $return['id'] ? 'index.php?m=admin_comrating&c=server&id='.$id : '' ;
|
|
}
|
|
}else{
|
|
$service = $this -> getComServiceList(array('name'=>$name));
|
|
if (!empty($service)) {
|
|
$return['errcode'] = 8;
|
$return['msg'] = '增值类型名称已存在！';
|
|
return $return;
|
|
}else{
|
|
$return['id'] = $this -> insert_into('company_service', $value);
|
|
$msg = '企业增值服务类型（ID：'.$return['id'].'）添加';
|
|
$return['msg'] = $return['id'] ? $msg.'成功！' : $msg.'失败！' ;
|
|
$return['errcode'] = $return['id'] ? 9 : 8 ;
|
|
$return['url'] = $return['id'] ? 'index.php?m=admin_comrating&c=edittc&id='.$return['id'] : '' ;
|
|
}
|
|
}
|
|
return $return;
|
|
}
|
|
}
|
|
/**
|
* @desc 更新 修改类型名称、设置增值服务状态
|
*/
|
function setComService($data=array(),$where=array()) {
|
$nid = $this -> update_once('company_service', $data, $where);
|
return $nid;
|
}
|
|
/**
|
* @desc 删除增值包 company_service 信息
|
*/
|
function delComService($id = null, $data = array()) {
|
|
$return = array(
|
'id' => 0,
|
'errcode' => 8,
|
'layertype' => 0,
|
'msg' => ''
|
);
|
|
if (is_array($id)) {
|
|
$ids = $id;
|
|
$return['layertype'] = 1;
|
|
}else{
|
|
$ids = @explode(',', $id);
|
|
$return['layertype'] = 0;
|
}
|
|
$typeStr = $this -> categoryMap($data['category']);
|
|
if (!empty($ids)){
|
|
$return['id'] = $this -> delete_all('company_service', array('id'=>array('in', pylode(',', $ids))), '');
|
|
if ($return['id']) {
|
|
$this -> delete_all('company_service_detail', array('type'=>array('in', pylode(',', $ids))), '');
|
|
}
|
|
}
|
|
|
$typeStr .= '（ID：'.$id.'）删除';
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
$return['msg'] = $return['id'] ? $typeStr.'成功！' : $typeStr.'失败！';
|
|
return $return;
|
}
|
|
|
/**
|
* @desc 查询 company_service_detail表数据，单条查询
|
* @param null $id
|
* @param array $data
|
* @return array|bool|false|string|void
|
*/
|
function getComSerDetailInfo($id = null, $data = array()) {
|
|
$field = $data['field'] ? $data['field'] : '*';
|
|
return $this -> select_once('company_service_detail', array('id'=>intval($id)), $field);
|
|
}
|
|
/**
|
* @desc 查询 company_service_detail表数据，多条查询
|
*/
|
function getComSerDetailList($whereData = array(), $data = array()) {
|
|
$field = $data['field'] ? $data['field'] : '*';
|
|
$List = $this -> select_all('company_service_detail', $whereData, $field);
|
|
foreach($List as $k=>$v){
|
|
foreach($v as $key=>$val){
|
$v[$key] = $val ? $val : 0;
|
}
|
$List[$k] = $v ? $v : 0;
|
}
|
|
if ($data['pack'] == '1') {
|
$List = $this -> subComSerDetailList($List);
|
}
|
|
return $List;
|
|
}
|
|
/**
|
* @desc 购买服务弹出框，增值服务包详情添加名称
|
* @param array $List
|
*/
|
private function subComSerDetailList($List)
|
{
|
$packList = $this->getComServiceList(array('orderby' => 'sort'), array('field'=> '`id`,`name`,`display`'));
|
|
foreach ($List as $k => $v){
|
|
foreach ($packList as $pv){
|
if ($pv['id'] == $v['type']) {
|
// 处理后台未启用的增值包类别
|
if ($pv['display'] != 1){
|
unset($List[$k]);
|
}else{
|
$List[$k]['name'] = $pv['name'];
|
}
|
}
|
}
|
}
|
|
return $List;
|
}
|
|
/**
|
* @desc 查询 company_service_detaile表数据，统计数量
|
* @return number
|
*/
|
function getComSerDetaileNum($whereData = array()) {
|
|
return $this -> select_num('company_service_detail', $whereData);
|
|
}
|
|
/**
|
* @desc 新增 / 修改 企业增值套餐详情
|
*/
|
function upComSerDetail($postData = array()) {
|
|
if (isset($postData)) {
|
|
$return = array();
|
|
$id = intval($postData['tid']);
|
|
$service_price = floatval($postData['service_price']);
|
$job_num = intval($postData['job_num']);
|
$resume = intval($postData['resume']);
|
$interview = intval($postData['interview']);
|
$breakjob_num = intval($postData['breakjob_num']);
|
$zph_num = intval($postData['zph_num']);
|
$top_num = intval($postData['top_num']);
|
$rec_num = intval($postData['rec_num']);
|
$urgent_num = intval($postData['urgent_num']);
|
$type = intval($postData['type']);
|
$sort = intval($postData['sort']);
|
$chat_num = intval($postData['chat_num']);
|
$spview_num = intval($postData['spview_num']);
|
|
$value = array(
|
|
'service_price' => $service_price,
|
'job_num' => $job_num,
|
'resume' => $resume,
|
'interview' => $interview,
|
'breakjob_num' => $breakjob_num,
|
'zph_num' => $zph_num,
|
'top_num' => $top_num,
|
'rec_num' => $rec_num,
|
'urgent_num' => $urgent_num,
|
'chat_num' => $chat_num,
|
'spview_num' => $spview_num,
|
'type' => $type,
|
'sort' => $sort
|
);
|
|
if (!empty($id)) {
|
|
$return['id'] = $this -> update_once('company_service_detail', $value, array('id' => $id));
|
|
$msg = '企业增值服务套餐（ID：'.$id.'）详情修改';
|
|
$return['msg'] = $return['id'] ? $msg.'成功！' : $msg.'失败！' ;
|
|
$return['errcode'] = $return['id'] ? 9 : 8 ;
|
|
$return['url'] = $return['id'] ? 'index.php?m=admin_comrating&c=list&id='.$type : '' ;
|
|
|
}else{
|
|
$return['id'] = $this -> insert_into('company_service_detail', $value);
|
|
$msg = '企业增值服务套餐（ID：'.$return['id'].'）详情添加';
|
|
$return['msg'] = $return['id'] ? $msg.'成功！' : $msg.'失败！' ;
|
|
$return['errcode'] = $return['id'] ? 9 : 8 ;
|
|
$return['url'] = $return['id'] ? 'index.php?m=admin_comrating&c=list&id='.$type : '' ;
|
|
|
}
|
|
return $return;
|
}
|
}
|
|
|
/**
|
* @desc 删除增值包详情 company_service_detail 信息
|
*/
|
function delComSerDetail($id = null)
|
{
|
|
$return = array(
|
|
'id' => 0,
|
'errcode' => 8,
|
'layertype' => 0,
|
'msg' => ''
|
);
|
|
if (is_array($id)) {
|
|
$ids = $id;
|
$return['layertype'] = 1;
|
|
}else{
|
|
$ids = @explode(',', $id);
|
$return['layertype'] = 0;
|
}
|
|
if (!empty($ids)){
|
|
$return['id'] = $this -> delete_all('company_service_detail', array('id'=>array('in', pylode(',', $ids))), '');
|
}
|
|
$msg = '套餐（ID：'.$id.'）删除';
|
|
$return['errcode'] = $return['id'] ? 9 : 8;
|
|
$return['msg'] = $return['id'] ? $msg.'成功！' : $msg.'失败！';
|
|
return $return;
|
}
|
|
function fetchRatingInfo($fetData=array())
|
{
|
if((int)$fetData['id']<1){
|
$id = $this->config['com_rating'];
|
}else{
|
$id = (int)$fetData['id'];
|
}
|
$row = $this->getInfo(array('id'=>$id));
|
|
|
$data['rating'] = $id;
|
$data['rating_name'] = $row['name'];
|
$data['rating_type'] = $row['type'];
|
|
$data['job_num'] = $row['job_num'];
|
$data['down_resume'] = $row['resume'];
|
$data['breakjob_num'] = $row['breakjob_num'];
|
$data['invite_resume'] = $row['interview'];
|
$data['part_num'] = $row['part_num'];
|
$data['breakpart_num'] = $row['breakpart_num'];
|
$data['zph_num'] = $row['zph_num'];
|
$data['top_num'] = $row['top_num'];
|
$data['urgent_num'] = $row['urgent_num'];
|
$data['rec_num'] = $row['rec_num'];
|
$data['sons_num'] = $row['sons_num'];
|
$data['chat_num'] = $row['chat_num'];
|
$data['spview_num'] = $row['spview_num'];
|
$data['lt_job_num'] = $row['lt_job_num'];
|
$data['lt_down_resume'] = $row['lt_resume'];
|
$data['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
|
if($row['service_time']){
|
$time = time()+86400*$row['service_time'];
|
$data['vip_etime'] = $time;
|
}else{
|
$data['vip_etime'] = 0;
|
}
|
|
$data['integral'] = $row['integral_buy'];
|
$data['vip_stime'] = time();
|
|
if($row['coupon']>0 && $fetData['uid']){
|
$coupon = $this->select_once("coupon",array('id'=>$row['coupon']));
|
$val = array();
|
$val['uid'] = $fetData['uid'];
|
$val['number'] = time();
|
$val['ctime'] = time();
|
$val['coupon_id'] = $coupon['id'];
|
$val['coupon_name'] = $coupon['name'];
|
$validity = time()+$coupon['time']*86400;
|
$val['validity'] = $validity;
|
$val['coupon_amount'] = $coupon['amount'];
|
$val['coupon_scope'] = $coupon['scope'];
|
$this->insert_into("coupon_list",$val);
|
}
|
return $data;
|
}
|
|
public function changeRatingInfo($id = 0, $uid = 0)
|
{
|
$id = intval($id) == 0 ? $this -> config['com_rating'] : intval($id);
|
$uid = intval($uid);
|
|
$value = array();
|
|
//获取企业账户套餐信息
|
$statis = $this -> select_once('company_statis', array('uid' => $uid));
|
|
$ratingAdd = explode(',', $this->config['rating_add']);
|
$acc = in_array($statis['rating'], $ratingAdd) ? 1: 2;
|
|
//获取会员等级
|
$row = $this -> getInfo(array('id' => $id, 'category' => 1));
|
|
if($statis['rating_type'] == $row['type'] && $row['type'] == 1 && $acc== 1){ // 套餐会员累加：后台选择当前身份会员累加 && 同为套餐会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
|
$time = 0;
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
/*套餐数据累加*/
|
if(isVip($statis['vip_etime'])){
|
$value['job_num'] = $statis['job_num'] + (int)$row['job_num'];
|
$value['breakjob_num'] = $statis['breakjob_num'] + (int)$row['breakjob_num'];
|
$value['down_resume'] = $statis['down_resume'] + (int)$row['resume'];
|
$value['invite_resume'] = $statis['invite_resume'] + (int)$row['interview'];
|
$value['zph_num'] = $statis['zph_num'] + (int)$row['zph_num'];
|
$value['urgent_num'] = $statis['urgent_num'] + (int)$row['urgent_num'];
|
$value['rec_num'] = $statis['rec_num'] + (int)$row['rec_num'];
|
$value['top_num'] = $statis['top_num'] + (int)$row['top_num'];
|
$value['integral'] = $statis['integral'] + (int)$row['integral_buy'];
|
$value['sons_num'] = $statis['sons_num'] + (int)$row['sons_num'];
|
$value['chat_num'] = $statis['chat_num'] + (int)$row['chat_num'];
|
$value['spview_num'] = $statis['spview_num'] + (int)$row['spview_num'];
|
}else{
|
$value['job_num'] = (int)$row['job_num'];
|
$value['breakjob_num'] = (int)$row['breakjob_num'];
|
$value['down_resume'] = (int)$row['resume'];
|
$value['invite_resume'] = (int)$row['interview'];
|
$value['zph_num'] = (int)$row['zph_num'];
|
$value['top_num'] = (int)$row['top_num'];
|
$value['urgent_num'] = (int)$row['urgent_num'];
|
$value['rec_num'] = (int)$row['rec_num'];
|
$value['sons_num'] = (int)$row['sons_num'];
|
$value['chat_num'] = (int)$row['chat_num'];
|
$value['spview_num'] = (int)$row['spview_num'];
|
}
|
/*累加数据End*/
|
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
|
}else if($statis['rating_type'] == $row['type'] && $row['type'] == 2 && $acc== 1){ // 时间会员期限累加：后台选择当前身份会员累加 && 同为时间会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){ // 当前会员时间剩余累加
|
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
|
$time = 0;
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
$value['job_num'] = (int)$row['job_num'];
|
$value['breakjob_num'] = (int)$row['breakjob_num'];
|
$value['down_resume'] = (int)$row['resume'];
|
$value['invite_resume'] = (int)$row['interview'];
|
$value['zph_num'] = (int)$row['zph_num'];
|
$value['top_num'] = (int)$row['top_num'];
|
$value['urgent_num'] = (int)$row['urgent_num'];
|
$value['rec_num'] = (int)$row['rec_num'];
|
$value['sons_num'] = (int)$row['sons_num'];
|
$value['chat_num'] = (int)$row['chat_num'];
|
$value['spview_num'] = (int)$row['spview_num'];
|
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
|
|
}else if($statis['rating_type'] != $row['type'] || $acc==2){ // 直接覆盖: 时间类型和套餐类型相互转换 || 后台未选择当身份会员累加累加
|
|
if($row['service_time'] > 0){
|
|
$time = time() + 86400 * $row['service_time'];
|
}else{
|
|
$time = 0;
|
}
|
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
$value['job_num'] = (int)$row['job_num'];
|
$value['breakjob_num'] = (int)$row['breakjob_num'];
|
$value['down_resume'] = (int)$row['resume'];
|
$value['invite_resume'] = (int)$row['interview'];
|
$value['zph_num'] = (int)$row['zph_num'];
|
$value['top_num'] = (int)$row['top_num'];
|
$value['urgent_num'] = (int)$row['urgent_num'];
|
$value['rec_num'] = (int)$row['rec_num'];
|
$value['sons_num'] = (int)$row['sons_num'];
|
$value['chat_num'] = (int)$row['chat_num'];
|
$value['spview_num'] = (int)$row['spview_num'];
|
$value['vip_etime'] = $time;
|
$value['vip_stime'] = time();
|
$value['oldrating_name'] = $row['name'];
|
}
|
|
return $value;
|
|
}
|
|
public function changeltratingInfo($id = 0, $uid = 0){
|
|
$id = intval($id) == 0 ? $this->config['lt_rating'] : intval($id);
|
$uid = intval($uid);
|
$value = array();
|
|
//获取猎头统计信息
|
$statis = $this -> select_once('lt_statis', array('uid' => $uid));
|
|
$ltRatingAdd= explode(',', $this->config['lt_rating_add']);
|
$acc = in_array($statis['rating'], $ltRatingAdd) ? 1 : 2;
|
|
//获取猎头会员等级
|
$row = $this -> getInfo(array('id' => $id, 'category' => 2));
|
|
if($statis['rating_type'] == $row['type'] && $row['type'] == 1 && $acc== 1){ // 套餐会员累加： 后台选择当前身份会员累加 && 同为套餐会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){//当前会员时间剩余累加
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
|
/*套餐数据累加*/
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){
|
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
}else{
|
|
$value['lt_job_num'] = $statis['lt_job_num'] + $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $statis['lt_breakjob_num'] + $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $statis['lt_down_resume'] + $row['lt_resume'];
|
$value['chat_num'] = $statis['chat_num'] + $row['chat_num'];
|
}
|
/*累加数据End*/
|
$value['vip_etime'] = $time;
|
}else if($statis['rating_type'] == $row['type'] && $row['type'] == 2 && $acc== 1){ // 时间会员期限累加：后台选择当前身份会员累加 && 同为时间会员
|
|
if($row['service_time'] > 0){ // 有期限的套餐
|
|
if($statis['vip_etime'] && isVip($statis['vip_etime'])){//当前会员时间剩余累加
|
$time = $statis['vip_etime'] + 86400 * $row['service_time'];
|
}else{
|
$time = time() + 86400 * $row['service_time'];
|
}
|
}else{ // 永久套餐
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
$value['vip_etime'] = $time;
|
}else if($statis['rating_type'] != $row['type'] || $acc==2){ // 直接覆盖: 时间类型和套餐类型相互转换 || 后台未选择当前身份会员累加
|
|
if($row['service_time'] > 0){
|
$time = time() + 86400 * $row['service_time'];
|
}else{
|
$time = 0;
|
}
|
$value['rating'] = $id;
|
$value['rating_name'] = $row['name'];
|
$value['rating_type'] = $row['type'];
|
$value['lt_job_num'] = $row['lt_job_num'];
|
$value['lt_breakjob_num'] = $row['lt_breakjob_num'];
|
$value['lt_down_resume'] = $row['lt_resume'];
|
$value['chat_num'] = $row['chat_num'];
|
$value['vip_etime'] = $time;
|
}
|
|
return $value;
|
}
|
}
|
?>
|
