<?php
|
/*
|
* $Author ：PHPYUN开发团队
|
*
|
* 官网: http://www.phpyun.com
|
*
|
* 版权所有 2009-2021 宿迁鑫潮信息技术有限公司，并保留所有权利。
|
*
|
* 软件声明：未经授权前提下，不得用于商业运营、二次开发以及任何形式的再次发布。
|
*/
|
|
class tongji_model extends model{
|
|
public function tjtotal($table,$whereData = array(), $data = array()){
|
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this -> select_all($table, $whereData, $data['field']);
|
|
return $List;
|
|
}
|
|
public function tjtonce($table, $whereData = array(),$data = array()){
|
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this -> select_once($table, $whereData, $data['field']);
|
|
return $List;
|
|
}
|
|
|
function getTj($Tablename,$Get,$Field,$Where=array(),$CountField='count(*) as count'){
|
|
$TimeDate = $this->TimeDate($Field,$CountField);
|
|
$Stats =$this->select_all($Tablename,array_merge($Where,$TimeDate['FieldWhere']),$TimeDate['FieldFormat']);
|
|
return $this->TjInfo($Stats,$TimeDate);
|
}
|
|
|
function TjInfo($Stats,$TimeDate){
|
|
if(is_array($Stats))
|
{
|
$AllNum = 0;$Date=array();
|
foreach($Stats as $key=>$value)
|
{
|
$AllNum +=$value['count'];
|
|
$Date[$value['tjtime']] = $value['count'];
|
}
|
foreach($TimeDate['DateList'] as $key=>$value){
|
if($Date[$value['onday']]<1){
|
$Date[$value['onday']] = 0;
|
}
|
$List[$value['onday']] = array('tjtime'=>$value['tjtime'],'count'=>$Date[$value['onday']],'date'=>$value['date']);
|
}
|
}
|
ksort($List);
|
return array('allnum'=>$AllNum,'list'=>$List,'timedate'=>$TimeDate);
|
}
|
|
|
//时间线获取
|
function TimeDate($field, $countfield = 'count(*) as count')
|
{
|
if (! $_GET['days'] && ! $_GET['date']) {
|
|
$_GET['days'] = 1;
|
}
|
|
$DateList = $DateWhere = $FieldWhere = array();
|
|
if ($_GET['days'] == '-1') { // 昨天 以24小时计算
|
|
$days = 24;
|
$sdate = strtotime('-1 days');
|
$edate = strtotime(date('Y-m-d'));
|
|
$FieldFormat = "FROM_UNIXTIME(`$field`,'%k') as tjtime,$countfield";
|
|
for ($i = 0; $i <= $days; $i ++) {
|
|
$DateList[$i]['tjtime'] = $i;
|
$DateList[$i]['date'] = $i.":00";
|
$DateList[$i]['onday'] = $i;
|
}
|
} elseif ($_GET['days'] == '1') { // 今天 以24小时计算
|
|
$days = 24;
|
$sdate = strtotime(date('Y-m-d'));
|
$edate = time();
|
|
$FieldFormat = "FROM_UNIXTIME(`$field`,'%k') as tjtime,$countfield";
|
|
for ($i = 0; $i <= $days; $i ++) {
|
|
$DateList[$i]['tjtime'] = $i;
|
$DateList[$i]['date'] = $i.":00";
|
$DateList[$i]['onday'] = $i;
|
}
|
|
} elseif ((int) $_GET['days'] > 1) { // 多日期 以具体日期数计算
|
|
$days = (int) $_GET['days'];
|
$sdate = strtotime(date('Y-m-d', (time() - $days * 86400)));
|
$edate = time();
|
|
$FieldFormat = "FROM_UNIXTIME(`$field`,'%Y%m%d') as tjtime,$countfield";
|
|
for ($i = 0; $i <= $days; $i ++) {
|
|
$onday = date("Ymd", strtotime(' -' . $i . 'day'));
|
$tjtime = date('m-d', strtotime(' -' . $i . 'day'));
|
$date = date('Y-m-d', strtotime(' -' . $i . 'day'));
|
|
$DateList[$i]['tjtime'] = $tjtime;
|
$DateList[$i]['date'] = $date;
|
$DateList[$i]['onday'] = $onday;
|
}
|
|
} elseif ($_GET['date']) {
|
|
$dates = @explode('~', $_GET['date']);
|
|
$edate = strtotime($dates[1]."23:59:59");
|
$sdate = strtotime($dates[0]."00:00:00");
|
|
$days = ceil(abs($edate - $sdate) / 86400);
|
|
$FieldFormat = "FROM_UNIXTIME(`$field`,'%Y%m%d') as tjtime,$countfield";
|
|
for ($i = 0; $i <= $days; $i ++) {
|
|
$t = $edate - $i * 86400;
|
$onday = date("Ymd", $t);
|
$tjtime = date('m-d', $t);
|
$date = date('Y-m-d', $t);
|
|
$DateList[$t]['tjtime'] = $tjtime;
|
$DateList[$t]['date'] = $date;
|
$DateList[$t]['onday'] = $onday;
|
}
|
}
|
|
$DateWhere[$field][] = array('>=', $sdate);
|
$DateWhere[$field][] = array('<=', $edate);
|
|
$FieldWhere['groupby'] = 'tjtime';
|
$FieldWhere['orderby'] = 'tjtime,desc';
|
|
return array(
|
'days' => $days,
|
'FieldWhere' => array_merge($DateWhere, $FieldWhere),
|
'FieldFormat' => $FieldFormat,
|
'DateList' => $DateList,
|
'DateWhere' => $DateWhere
|
);
|
}
|
|
|
//统计 前十排行
|
function TopTen($Tablename,$Where,$Field,$Type,$Limit='10',$CountField="count(*) AS count"){
|
|
$topwhere['groupby'] = $Field;
|
|
$topwhere['orderby'] = array('count,desc');
|
|
$topwhere['limit'] = $Limit;
|
|
$List = $this->select_all($Tablename,array_merge($Where,$topwhere),$CountField.",".$Field);
|
|
foreach($List as $key=>$value){
|
|
$Fields[] = $value[$Field];
|
$Count[$value[$Field]] = $value['count'];
|
}
|
|
if($Type=='job'){//统计职位信息
|
|
$jobwhere['id']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("company_job",$jobwhere,"`id`,`uid`,`name`");
|
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['id']];
|
$NewList[$value['id']] = $value;
|
}
|
|
foreach($List as $key=>$value){
|
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
}elseif($Type=='company'){
|
|
$comwhere['uid']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("company",$comwhere,"`uid`,`name`");
|
|
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['uid']];
|
$NewList[$value['uid']] = $value;
|
}
|
|
foreach($List as $key=>$value){
|
if(!empty($NewList[$value[$Field]])){
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
|
}
|
}elseif($Type=='expect'){
|
|
include PLUS_PATH.'city.cache.php';
|
include PLUS_PATH.'job.cache.php';
|
include PLUS_PATH.'user.cache.php';
|
|
$ewhere['id']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("resume_expect",$ewhere,"`id`,`uid`,`uname`,`job_classid`,`city_classid`,`exp`,`edu`");
|
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['id']];
|
$value['eduname'] = $userclass_name[$value['edu']];
|
$value['expname'] = $userclass_name[$value['exp']];
|
if($value['job_classid']){
|
$jobclassname=array();
|
$jobclassid = @explode(',',$value['job_classid']);
|
foreach($jobclassid as $k=>$v){
|
if($v){
|
$jobclassname[] = $job_name[$v];
|
}
|
}
|
$value['jobclassname'] = implode(',',$jobclassname);
|
}
|
if($value['city_classid']){
|
$cityclassname=array();
|
$cityclassid = @explode(',',$value['city_classid']);
|
foreach($cityclassid as $k=>$v){
|
if($v){
|
$cityclassname[] = $city_name[$v];
|
}
|
}
|
$value['cityclassname'] = implode(',',$cityclassname);
|
}
|
$NewList[$value['id']] = $value;
|
}
|
|
foreach($List as $key=>$value){
|
if(!empty($NewList[$value[$Field]])){
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
|
}
|
}elseif($Type=='resume'){
|
|
$rwhere['uid']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("resume",$rwhere,"`uid`,`name`,`sex`,`exp`,`edu`");
|
|
$ExpectList = $this->select_all("resume_expect",$rwhere,"`id`,`uid`,`defaults`");
|
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['uid']];
|
$NewList[$value['uid']] = $value;
|
}
|
foreach($List as $key=>$value){
|
if(!empty($NewList[$value[$Field]])){
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
foreach($ExpectList as $val){
|
if($val['uid']==$value['uid']&&$val['defaults']==1){
|
$TopList[$key]['eid']=$val['id'];
|
}
|
}
|
}
|
}elseif($Type=='order'){
|
|
$mwhere['uid']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("member",$mwhere,"`uid`,`username`,`usertype`");
|
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['uid']];
|
$NewList[$value['uid']] = $value;
|
}
|
|
foreach($List as $key=>$value){
|
if(!empty($NewList[$value[$Field]])){
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
|
}
|
}if($Type=='ad'){//统计广告点击量
|
|
$adclickwhere['aid']=array('in',pylode(',',$Fields));
|
|
$FieldList = $this->select_all("adclick",$adclickwhere,"`aid`");
|
|
$adwhere['id']=array('in',pylode(',',$Fields));
|
|
$adList = $this->select_all("ad",$adwhere);
|
foreach($adList as $value){
|
$adLists[$value['id']] = $value['ad_name'];
|
}
|
foreach($FieldList as $key=>$value){
|
|
$value['count'] = $Count[$value['aid']];
|
$value['name'] = $adLists[$value['aid']];
|
$NewList[$value['aid']] = $value;
|
}
|
|
foreach($List as $key=>$value){
|
|
$TopList[$key] = $NewList[$value[$Field]];
|
}
|
}
|
return $TopList;
|
}
|
//完整数据分析，获取行业、薪资区间、区域等数据进行统一分析
|
function DataTj($Type,$Where,$Tablename,$Field){
|
|
include PLUS_PATH.'city.cache.php';
|
include PLUS_PATH.'industry.cache.php';
|
include PLUS_PATH.'job.cache.php';
|
include PLUS_PATH.'com.cache.php';
|
include PLUS_PATH.'user.cache.php';
|
include CONFIG_PATH.'db.data.php';
|
|
include_once ('cache.model.php');
|
|
$cacheM = new cache_model($this->db, $this->def);
|
|
$cache = $cacheM -> GetCache('com');
|
|
|
$List = $this->select_all($Tablename,$Where,$Field);
|
|
if(is_array($List)){
|
|
$Count = array();
|
|
foreach($List as $key=>$value){
|
|
$Fields[] = $value[$Field];
|
}
|
if($Type=='resume_expect'){
|
|
//查询职位信息
|
$ewhere['id'] = array('in',pylode(',',$Fields));
|
|
$citywhere['eid'] = array('in',pylode(',',$Fields));
|
|
$ResumeList = $this->select_all("resume_expect",$ewhere,"`id`,`sex`,`edu`,`exp`,`job_classid`,`maxsalary`,`minsalary`");
|
|
$ResumeCityList = $this->select_all("resume_cityclass",$citywhere,"`eid`,`provinceid`,`cityid`,`three_cityid`");
|
$jobClassEnd = array();
|
foreach($job_index as $val){
|
|
if(is_array($job_type[$val])){
|
$jobClassAll[$val][] = $val;
|
foreach($job_type[$val] as $v){
|
|
$jobClassAll[$val] = array_merge($jobClassAll[$val], $job_type[$val]);
|
|
if(is_array($job_type[$v])){
|
|
$jobClassAll[$val] = array_merge($jobClassAll[$val], $job_type[$v]);
|
|
}
|
}
|
}
|
}
|
foreach($jobClassAll as $key=>$value){
|
if(is_array($value)){
|
foreach($value as $v){
|
$jobClassEnd[$v] = $key;
|
}
|
}
|
}
|
|
foreach($ResumeList as $key=>$value){
|
|
$Count['sex'][$value['sex']]['count']++;
|
$Count['sex'][$value['sex']]['name'] =$cache['com_sex'][$value['sex']];
|
|
$Count['edu'][$value['edu']]['count']++;
|
$Count['edu'][$value['edu']]['name'] = $userclass_name[$value['edu']];
|
|
$Count['exp'][$value['exp']]['count']++;
|
$Count['exp'][$value['exp']]['name'] = $userclass_name[$value['exp']];
|
if($value['job_classid']){
|
$jobclassid = @explode(',',$value['job_classid']);
|
foreach($jobclassid as $k=>$v){
|
$classid = $jobClassEnd[$v];
|
if($classid){
|
$Count['job1'][$classid]['count']++;
|
$Count['job1'][$classid]['name'] = $job_name[$classid];
|
}
|
}
|
}
|
|
foreach($ResumeCityList as $val){
|
if($val['eid']==$value['id']){
|
$Count['provinceid'][$val['provinceid']]['count']++;
|
$Count['provinceid'][$val['provinceid']]['name'] = $city_name[$val['provinceid']];
|
|
$Count['cityid'][$val['cityid']]['count']++;
|
$Count['cityid'][$val['cityid']]['name'] = $city_name[$val['cityid']];
|
|
$Count['three_cityid'][$val['three_cityid']]['count']++;
|
$Count['three_cityid'][$val['three_cityid']]['name'] = $city_name[$val['three_cityid']];
|
}
|
}
|
|
if($value['maxsalary']>0){
|
if($value['maxsalary']<=2000){
|
$Count['salary']['2000以下']['count']++;
|
$Count['salary']['2000以下']['name'] = '2000以下';
|
}
|
if($value['maxsalary']>2000&&$value['maxsalary']<=4000){
|
$Count['salary']['2000-4000']['count']++;
|
$Count['salary']['2000-4000']['name'] = '2000-4000';
|
}
|
if($value['maxsalary']>4000&&$value['maxsalary']<=6000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['maxsalary']>6000&&$value['maxsalary']<=8000){
|
$Count['salary']['6000-8000']['count']++;
|
$Count['salary']['6000-8000']['name'] = '6000-8000';
|
}
|
if($value['maxsalary']>8000&&$value['maxsalary']<=10000){
|
$Count['salary']['8000-10000']['count']++;
|
$Count['salary']['8000-10000']['name'] = '8000-10000';
|
}
|
if($value['maxsalary']>10000){
|
$Count['salary']['10000以上']['count']++;
|
$Count['salary']['10000以上']['name'] = '10000以上';
|
}
|
}else{
|
if($value['minsalary']<=2000){
|
$Count['salary']['2000以下']['count']++;
|
$Count['salary']['2000以下']['name'] = '2000以下';
|
}
|
if($value['minsalary']>2000&&$value['minsalary']<=4000){
|
$Count['salary']['2000-4000']['count']++;
|
$Count['salary']['2000-4000']['name'] = '2000-4000';
|
}
|
if($value['minsalary']>4000&&$value['minsalary']<=6000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['minsalary']>6000&&$value['minsalary']<=8000){
|
$Count['salary']['6000-8000']['count']++;
|
$Count['salary']['6000-8000']['name'] = '6000-8000';
|
}
|
if($value['minsalary']>8000&&$value['minsalary']<=10000){
|
$Count['salary']['8000-10000']['count']++;
|
$Count['salary']['8000-10000']['name'] = '8000-10000';
|
}
|
if($value['minsalary']>10000){
|
$Count['salary']['10000以上']['count']++;
|
$Count['salary']['10000以上']['name'] = '10000以上';
|
}
|
|
}
|
}
|
|
}elseif($Type=='job'){
|
|
//查询职位信息
|
$jobwhere['id']=array('in',pylode(',',$Fields));
|
|
$JobList = $this->select_all("company_job",$jobwhere,"`edu`,`exp`,`job1`,`job1_son`,`job_post`,`provinceid`,`cityid`,`three_cityid`,`minsalary`,`maxsalary`");
|
|
foreach($JobList as $key=>$value){
|
|
$Count['edu'][$value['edu']]['count']++;
|
$Count['edu'][$value['edu']]['name'] = $comclass_name[$value['edu']];
|
|
$Count['exp'][$value['exp']]['count']++;
|
$Count['exp'][$value['exp']]['name'] = $comclass_name[$value['exp']];
|
|
$Count['job1'][$value['job1']]['count']++;
|
$Count['job1'][$value['job1']]['name'] = $job_name[$value['job1']];
|
|
$Count['job1_son'][$value['job1_son']]['count']++;
|
$Count['job1_son'][$value['job1_son']]['name'] = $job_name[$value['job1_son']];
|
|
$Count['job_post'][$value['job_post']]['count']++;
|
$Count['job_post'][$value['job_post']]['name'] = $job_name[$value['job_post']];
|
|
$Count['provinceid'][$value['provinceid']]['count']++;
|
$Count['provinceid'][$value['provinceid']]['name'] = $city_name[$value['provinceid']];
|
|
$Count['cityid'][$value['cityid']]['count']++;
|
$Count['cityid'][$value['cityid']]['name'] = $city_name[$value['cityid']];
|
|
$Count['three_cityid'][$value['three_cityid']]['count']++;
|
$Count['three_cityid'][$value['three_cityid']]['name'] = $city_name[$value['three_cityid']];
|
|
if($value['maxsalary']>0){
|
if($value['maxsalary']<=2000){
|
$Count['salary']['2000以下']['count']++;
|
$Count['salary']['2000以下']['name'] = '2000以下';
|
}
|
if($value['maxsalary']>2000&&$value['maxsalary']<=4000){
|
$Count['salary']['2000-4000']['count']++;
|
$Count['salary']['2000-4000']['name'] = '2000-4000';
|
}
|
if($value['maxsalary']>4000&&$value['maxsalary']<=6000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['maxsalary']>6000&&$value['maxsalary']<=8000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['maxsalary']>8000&&$value['maxsalary']<=10000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['maxsalary']>10000){
|
$Count['salary']['10000以上']['count']++;
|
$Count['salary']['10000以上']['name'] = '10000以上';
|
}
|
}else{
|
if($value['minsalary']<=2000){
|
$Count['salary']['2000以下']['count']++;
|
$Count['salary']['2000以下']['name'] = '2000以下';
|
}
|
if($value['minsalary']>2000&&$value['minsalary']<=4000){
|
$Count['salary']['2000-4000']['count']++;
|
$Count['salary']['2000-4000']['name'] = '2000-4000';
|
}
|
if($value['minsalary']>4000&&$value['minsalary']<=6000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['minsalary']>6000&&$value['minsalary']<=8000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['minsalary']>8000&&$value['minsalary']<=10000){
|
$Count['salary']['4000-6000']['count']++;
|
$Count['salary']['4000-6000']['name'] = '4000-6000';
|
}
|
if($value['minsalary']>10000){
|
$Count['salary']['10000以上']['count']++;
|
$Count['salary']['10000以上']['name'] = '10000以上';
|
}
|
|
}
|
|
}
|
}elseif($Type=='reg'){
|
|
|
|
//查询注册信息
|
$mwhere['uid'] = array('in',pylode(',',$Fields));
|
|
$mwhere['groupby'] = 'source';
|
|
$RegList = $this->select_all("member",$mwhere,"count(*) as count,source");
|
|
foreach($RegList as $key=>$value){
|
|
$Count['source'][$value['source']]['count'] = $value['count'];
|
$Count['source'][$value['source']]['name'] = $arr_data['source'][$value['source']];
|
}
|
}elseif($Type=='order'){
|
|
//查询职位信息
|
$owhere['id']=array('in',pylode(',',$Fields));
|
|
$OrderList = $this->select_all("company_order",$owhere,"`id`,`order_type`,`type`");
|
|
$TypeName = array(0 => '其他',1 => '会员充值（购买会员）',2 => $this->config['integral_pricename'].'充值',3 => '银行转帐',4 => '金额充值',5 => '购买增值包',6=>"课程订购",7 => '购买小程序',8 => '分享红包推广',9 => '悬赏红包',10 => '职位置顶',11 => '职位紧急',12 => '职位推荐',13 => '自动刷新',14 => '简历置顶',15 => '委托简历',16 => '刷新职位',17 => '刷新兼职',18 => '刷新猎头职位',19 => '下载简历',20 => '发布职位',21 => '发布兼职',22 => '发布猎头职位',23 => '面试邀请',24 => '兼职推荐',25 => '店铺招聘',26 => '购买广告位');
|
|
$OrderTypeName = array('adminpay'=>'管理员充值','admincut'=>'管理员扣款','alipay'=>'支付宝','wapalipay'=>'手机支付宝','wxpay'=>'微信支付','bank'=>'银行汇款','tenpay'=>'财付通','0'=>'其他');
|
|
foreach($OrderList as $key=>$value){
|
if(!$value['order_type']){
|
$value['order_type'] = 0;
|
}
|
$Count['ordertype'][$value['order_type']]['count']++;
|
$Count['ordertype'][$value['order_type']]['name'] = $OrderTypeName[$value['order_type']];
|
|
if(!$value['type']){
|
$value['type'] = 0;
|
}
|
$Count['type'][$value['type']]['count']++;
|
$Count['type'][$value['type']]['name'] = $TypeName[$value['type']];
|
}
|
}elseif($Type=='company'){
|
$rating = $this->select_all('company_rating',array(),'`id`,`name`');
|
foreach($rating as $value){
|
$ratingList[$value['id']] = $value['name'];
|
}
|
|
//查询企业资料
|
$comwhere['uid']=array('in',pylode(',',$Fields));
|
|
$CompanyList = $this->select_all("company",$comwhere,"`uid`,`hy`,`provinceid`,`jobtime`");
|
|
$CompanyRating = $this->select_all("company_statis",$comwhere,"`uid`,`rating`");
|
foreach($CompanyRating as $value){
|
|
$Count['rating'][$value['rating']]['count']++;
|
$Count['rating'][$value['rating']]['name'] = $ratingList[$value['rating']];
|
|
}
|
|
foreach($CompanyList as $key=>$value){
|
if(!$value['hy']){
|
$Count['hy'][0]['count']++;
|
$Count['hy'][0]['name'] = '其他';
|
$Count['is'][0]['count']++;//完善企业资料数量
|
}else{
|
$Count['is'][1]['count']++;//完善企业资料数量
|
$Count['hy'][$value['hy']]['count']++;
|
$Count['hy'][$value['hy']]['name'] = $industry_name[$value['hy']];
|
}
|
|
|
$Count['is'][0]['name']='信息不全';
|
|
$Count['is'][1]['name']='信息完善';
|
|
}
|
|
}elseif($Type=='ad'){
|
|
|
//查询企业资料
|
$comwhere['uid']=array('in',pylode(',',$Fields));
|
|
$CompanyList = $this->select_all("company",$comwhere,"`uid`,`hy`,`provinceid`,`jobtime`");
|
|
|
$CompanyRating = $this->select_all("company_statis",$comwhere,"`uid`,`rating`");
|
foreach($CompanyRating as $value){
|
|
$Count['rating'][$value['rating']]['count']++;
|
$Count['rating'][$value['rating']]['name'] = $ratingList[$value['rating']];
|
|
}
|
|
foreach($CompanyList as $key=>$value){
|
if(!$value['hy']){
|
$Count['hy'][0]['count']++;
|
$Count['hy'][0]['name'] = '其他';
|
$Count['is'][0]['count']++;//完善企业资料数量
|
}else{
|
$Count['is'][1]['count']++;//完善企业资料数量
|
$Count['hy'][$value['hy']]['count']++;
|
$Count['hy'][$value['hy']]['name'] = $industry_name[$value['hy']];
|
}
|
|
|
$Count['is'][0]['name']='信息不全';
|
|
$Count['is'][1]['name']='信息完善';
|
|
}
|
|
}
|
}
|
return $Count;
|
}
|
}
|
?>
|
