odd_job/app/admin/controller/Test.php

<?php
namespace app\admin\controller;

use app\admin\BaseController;
use app\common\model\UserPart;
use app\common\service\FulianService;
use app\common\service\IntegralService;
use think\facade\Db;

class Test extends BaseController
{
    public function t1(){
        $integralService = new IntegralService();
        $integralService->add(6,IntegralService::REGISTER);
    }

    public function t2() {
        $service = new FulianService();
        \app\common\model\Comjobs::with('worker')->where('sex','<>',1)->chunk(10, function($list) use($service) {
            $service->setData($list);
            $service->jobInfos();
        });
        return 'success';
    }
/*
    public function t2()
    {
        $xlsData = Db::table('un_person')->select();
        $xlsCell = [
            ['id', '主键(必填)'],
            ['uid', '微信uid'],
            ['username', '登陆用户名(必填)'],
            ['name', '姓名(必填)'],
            ['sex', '性别(必填)'],
            ['idCard', '证件号码(必填)'],
            ['phone', '电话号码(必填)'],
            ['address', '联系地址(必填)'],
            ['email', '邮箱(必填)'],
        ];
        export_excel("人员信息", $xlsCell, $xlsData);
    }

    public function t3()
    {
        $xlsData = Db::table('un_enterprise')->select();
        $xlsCell = [
            ['id', '主键(必填)'],
            ['uid', '微信uid'],
            ['name', '单位名称(必填)'],
            ['idCard', '社会信用代码(必填)'],
            ['street', '所属街道(必填)'],
            ['address', '单位地址(必填)'],
            ['legal', '法人代表(必填)'],
            ['ephone', '单位电话(必填)'],
            ['agentName', '经办人(必填)'],
            ['agentPhone', '经办人电话(必填)'],
            ['agentEmail', '经办人邮箱(必填)'],
            ['imgurl', '证件链接(必填)'],
        ];
        export_excel("企业信息", $xlsCell, $xlsData);
    }

    public function t4()
    {
        set_time_limit(0);
        ini_set('memory_limit',-1);
        $xlsData = Db::table('un_talent_info')->select();
        $xlsCell = [
            ['id', '主键(必填)'],
            ['enterpriseId', '企业Id'],
            ['year', '申报年度'],
            ['type', '人才类型'],
            ['source', '来源'],
            ['ourCitySource', '是否我市'],
            ['talentType', '申报人才类型'],
            ['cardType', '证件类型'],
            ['idCard', '证件号码'],
            ['name', '姓名'],
            ['photo', '头像'],
            ['sex', '性别'],
            ['nation', '民族'],
            ['nationality', '国籍'],
            ['provinceName', '籍贯省名称'],
            ['cityName', '籍贯市名称'],
            ['countyName', '籍贯县名称'],
            ['birthday', '出生日期'],
            ['address', '现居地址'],
            ['politics', '政治面貌'],
            ['highEducation', '最高学历'],
            ['graduateSchool', '毕业学校'],
            ['major', '专业'],
            ['post', '职务'],
            ['phone', '手机号码'],
            ['email', '电子邮箱'],
            ['bank', '开户银行'],
            ['bankNetwork', '开户银行网点'],
            ['bankAccount', '银行账号'],
            ['bankNumber', '银行行号'],
            ['entryTime', '入职时间'],
            ['startTime', '工作合同开始时间'],
            ['endTime', '工作合同结束时间'],
            ['talentArrange', '人才层次'],
            ['identifyCondition', '认定条件'],
            ['identifyGetTime', '认定条件获得时间'],
            ['identifyConditionName', '认定条件名称'],
            ['identifyMonth', '认定月份'],
            ['certificateNO', '证书编号'],
            ['letterTime', '行政介绍信时间'],
            ['gygb', '是否为我市本级国有股比超过50%'],
            ['certificateStartTime', '人才证书开始时间'],
            ['qzgccrcActiveTime', '人才证书的有效期'],
            ['mainHonours', '主要业绩及取得的荣誉'],
            ['educationAndResume', '教育背景及工作简历'],
            ['firstInJJTime', '首次来晋工作时间'],
            ['isIntroduction', '是否引进'],
            ['introductionMode', '引进方式'],
            ['industryField', '行业领域'],
            ['title', '职称'],
            ['professionalQualifications', '国家职业资格'],
            ['studyAbroad', '是否有留学经历'],
            ['studyAbroadCountry', '留学国家'],
            ['fromCity', '来源县市'],
            ['qzBatch', '入选泉州高层次人才批次'],
            ['breakFaith', '曾被相关部门列为失信人员'],
        ];
        export_excel("人才信息", $xlsCell, $xlsData);
    }*/
}