agg_admin/app/admin/controller/Api.php

<?php

namespace app\admin\controller;

use app\BaseController;
use app\common\model\jucai\RecruitAppointInfoModel;
use app\common\model\jucai\RecruitModel;
use app\common\model\jucai\RecruitPostModel;
use app\common\model\odd_job\BrokerModel;
use app\common\model\odd_job\JobModel;
use app\common\model\odd_job\RensheCodeModel;
use app\common\model\odd_job\UserModel;
use app\common\model\odd_job\WorkerModel;
use app\common\model\SettingModel;

class Api extends BaseController
{
    public function talent()
    {
        $system = SettingModel::getConfigValue(SettingModel::TALENT);
        $res    = [
            'talent_level'     => [
                ['name' => '第一层次', 'count' => $system['talent_level_1']],
                ['name' => '第二层次', 'count' => $system['talent_level_2']],
                ['name' => '第三层次', 'count' => $system['talent_level_3']],
                ['name' => '第四层次', 'count' => $system['talent_level_4']],
                ['name' => '第五层次', 'count' => $system['talent_level_5']],
                ['name' => '第六层次', 'count' => $system['talent_level_6']],
                ['name' => '第七层次', 'count' => $system['talent_level_7']],
            ],
            'talent_industry'  => [
                ['name' => '贸易/进出口', 'count' => $system['talent_industry_trade']],
                ['name' => '消费品(食/饮/烟酒)', 'count' => $system['talent_industry_goods']],
                ['name' => '服装/纺织/皮革', 'count' => $system['talent_industry_clothing']],
                ['name' => '制药/生物工程', 'count' => $system['talent_industry_drug']],
                ['name' => '医疗设备/器械', 'count' => $system['talent_industry_medical']],
                ['name' => '酒店/旅游', 'count' => $system['talent_industry_hotel']],
                ['name' => '交通/运输/物流', 'count' => $system['talent_industry_traffic']],
                ['name' => '其他', 'count' => $system['talent_industry_other']],
            ],
            'talent_age'       => [
                ['name' => '30岁以下', 'count' => $system['talent_age_1']],
                ['name' => '30-39岁', 'count' => $system['talent_age_2']],
                ['name' => '40-49岁', 'count' => $system['talent_age_3']],
                ['name' => '50岁以上', 'count' => $system['talent_age_4']],
            ],
            'talent_education' => [
                ['name' => '硕士', 'count' => $system['talent_education_1']],
                ['name' => '博士', 'count' => $system['talent_education_2']],
                ['name' => '博士后', 'count' => $system['talent_education_3']],
            ],
            'total_count'      => [
                ['name' => '硕博人才数', 'count' => $system['talent_total']],
            ],
        ];

        return json($res);
    }

    public function odd_job()
    {
        $res = [];

        //街道数据
        $comjobs_community = JobModel::field("count(community),community")->group('community')->column('count(community)', 'community');
        $community         = RensheCodeModel::getList('community')->toArray();
        $broker_town       = BrokerModel::field("count(town),town")->group('town')->column('count(town)', 'town');
        foreach ($community as &$v) {
            if (!empty($comjobs_community[$v['code']])) {
                $v['count'] = $comjobs_community[$v['code']];
            } else {
                $v['count'] = 0;
            }
            if (!empty($broker_town[$v['name']])) {
                $v['broker_count'] = $broker_town[$v['name']];
            } else {
                $v['broker_count'] = 0;
            }
            unset($v);
        }
        $community[]      = [
            'id'           => 0,
            'name'         => '其他',
            'code'         => '',
            'count'        => $comjobs_community[''] ?? 0,
            'broker_count' => $broker_town[''] ?? 0,
        ];
        $res['community'] = $community;

        //数量统计
        $comjobs_map          = [];
        $comjobs_map[]        = ['createtime', '<=', time()];
        $comjobs_map[]        = ['status', 'in', '3,4'];
        $res['company_total'] = WorkerModel::where('status', 'in', '4,5')->count();
        $res['comjobs_total'] = JobModel::where($comjobs_map)->count();
        $res['user_total']    = UserModel::count();

        return json($res);
    }

    public function recruit()
    {
        $data = [];

        //招考数据
        $data['recruit_count'] = RecruitModel::count();
        $data['recruit_post']  = RecruitPostModel::count();
        $data['recruit_apply'] = RecruitAppointInfoModel::count();

        //学历和年龄
        $recruit_apply_data = RecruitAppointInfoModel::field(['birthday', 'education'])->select();
        $recruit_education  = [
            '专科' => ['name' => '专科', 'count' => 0],
            '本科' => ['name' => '本科', 'count' => 0],
            '硕士' => ['name' => '硕士', 'count' => 0],
            '博士' => ['name' => '博士', 'count' => 0],
            '其他' => ['name' => '其他', 'count' => 0],
        ];
        $recruit_age        = [
            '30岁及以下' => ['name' => '30岁及以下', 'count' => 0],
            '30到35岁' => ['name' => '30到35岁', 'count' => 0],
            '35到40岁' => ['name' => '35到40岁', 'count' => 0],
            '40岁以上'  => ['name' => '40岁以上', 'count' => 0],
        ];
        $year               = date('Y');
        foreach ($recruit_apply_data as $v) {
            if (!empty($recruit_education[$v['education']])) {
                $recruit_education[$v['education']]['count']++;
            } else {
                $recruit_education['其他']['count']++;
            }

            $birth = mb_substr($v['birthday'], 0, 4);
            if ($birth >= ($year - 30)) {
                $recruit_age['30岁及以下']['count']++;
            } elseif ($birth >= ($year - 35) && $birth < ($year - 30)) {
                $recruit_age['30到35岁']['count']++;
            } elseif ($birth >= ($year - 40) && $birth < ($year - 35)) {
                $recruit_age['35到40岁']['count']++;
            } else {
                $recruit_age['40岁以上']['count']++;
            }
        }

        $data['recruit_education'] = array_values($recruit_education);
        $data['recruit_age']       = array_values($recruit_age);

        return json($data);
    }
}