<?php

namespace App\Console\Commands\Transfer;

use App\Models\CompanyFavorite;
use App\Models\CompanyImg;
use App\Models\Jobfair\JobfairJobsContact;
use App\Models\Jobs;
use App\Models\JobsContact;
use App\Models\MembersPoint;
use App\Models\MembersSetmeal;
use App\Models\Promotion;
use App\Models\QueueAutoRefresh;
use App\Models\SubsiteJob;
use App\Transfer\Company;
use App\Transfer\CompanyDownResume;
use App\Transfer\CompanyFavorites;
use App\Transfer\CompanyInterview;
use App\Transfer\CompanyStatistics;
use App\Transfer\MembersChargeLog;
use App\Transfer\MembersHandsel;
use App\Transfer\MembersSetmealLog;
use App\Transfer\Setmeal;
use App\Transfer\SetmealIncrement;
use App\Transfer\Task;
use App\Transfer\TaskLog;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class TransferCompany extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'aix:transfer-company';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '转移旧系统企业数据';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $uid = Company::where(['utype' => 1])->get()->pluck('uid')->toArray();
        $this->info("清除企业数据表:companys");
        DB::table('companys')->delete();
        $this->info("清除企业风采数据表:companyImg");
        DB::table('companyImg')->delete();
        $this->info("清除企业套餐数据表:membersSetmeal");
        DB::table('members_setmeals')->delete();
        $this->info('清除企业套餐记录数据表：membersSetmealLogs');
        DB::table('members_setmeal_logs')->delete();
        $this->info('清除企业职位数据表：jobs');
        DB::table('jobs')->delete();
        $this->info('清除企业职位联系人数据表：jobsContact');
        DB::table('jobs_contacts')->delete();
        $this->info('清除企业职位分站关系数据表subsiteJobs');
        DB::table('subsite_jobs')->delete();
        $this->info('清除企业下载简历数据表companyDownResume');
        DB::table('company_down_resumes')->delete();
        $this->info('清除企业收藏数据表companyFavorites');
        DB::table('company_favorites')->delete();
        $this->info('清除企业邀请面试数据表companyInterview');
        DB::table('company_interviews')->delete();
        $this->info('清除企业统计数据表companyStatistics');
        DB::table('company_statistics')->delete();
        $this->info('清除招聘会职位库数据表jobfairJob');
        DB::table('jobfair_jobs')->delete();
        $this->info('清除招聘会职位库联系人数据表jobfairJobContact');
        DB::table('jobfair_jobs_contacts')->delete();
        $this->info('清除MembersChargeLogs数据表');
        DB::table('members_charge_logs')->delete();
        $this->info('清除MembersHandsels数据表');
        DB::table('members_handsels')->delete();
        $this->info('清除企业职位推广数据表：promotions');
        DB::table('promotions')->delete();
        $this->info('清除企业职位智能刷新数据表：queueAutoRefresh');
        DB::table('queue_auto_refreshs')->delete();
        $this->info('清除企业刷新数据表：refreshLog');
        DB::table('refresh_logs')->delete();
        $this->info('清除任务数据表：task');
        DB::table('tasks')->delete();
        $this->info('清除任务记录数据表：taskLog');
        DB::table('task_logs')->delete();
        $this->info('清除增值服务数据表：setmeal_increments');
        DB::table('setmeal_increments')->delete();
        $this->info('清除数据表：members_charge_logs');
        DB::table('members_charge_logs')->delete();
        $this->info('清除数据表：members_setmeal_logs');
        DB::table('members_setmeal_logs')->delete();


        $this->info("开始转移数据...");
        $setmealInfo = Setmeal::where('id', 1)->first();
        $total = Company::where(['utype' => 1])->count();
        $bar = $this->output->createProgressBar($total);
        Company::where(['utype' => 1])->orderBy('uid', 'asc')->chunk(10, function ($companys) use ($bar, $setmealInfo) {
            $company_array = [];
            $company_job_array = [];
            $company_img_array = [];
            $company_setmeal_array = [];
            $company_points_array = [];
            $jobs_contact_arr = [];
            $subsite_job_array = [];
            $job_promotion_arr = [];
            $job_auto_refresh_arr = [];
            /** @var Company $company */
            foreach ($companys as $company) {
                //处理企业表
                $this->handleCompany($company, $company_array);
                //处理企业风采表
                $this->handleCompanyImg($company, $company->companyImg, $company_img_array);
                //处理企业会员套餐
                $this->handleMemberSetmeal($company, $company->membersSetmeal, $setmealInfo, $company_setmeal_array);
                //处理企业会员积分
                $this->handleMemberPoints($company, $company->membersPoints, $company_points_array);
                //处理职位、职位联系人、职位分站关系、职位推广、职位智能刷新
                //
                $this->handleCompanyJob($company, $company->jobs, $company_job_array, $jobs_contact_arr, $subsite_job_array, $job_promotion_arr, $job_auto_refresh_arr);
                //处理套餐

                //处理企业图片...
            }
            //批量插入数据;
            if ($company_array) {
                \App\Models\Company::insert($company_array);
            }
            if ($company_img_array) {
                CompanyImg::insert($company_img_array);

            }
            if ($company_points_array) {
                MembersPoint::insert($company_points_array);

            }
            if ($company_setmeal_array) {
                MembersSetmeal::insert($company_setmeal_array);

            }
            if ($company_job_array) {
                Jobs::insert($company_job_array);

            }
            if ($jobs_contact_arr) {
                JobsContact::insert($jobs_contact_arr);

            }
            if ($subsite_job_array) {
                SubsiteJob::insert($subsite_job_array);

            }
            if ($job_promotion_arr) {
                Promotion::insert($job_promotion_arr);
            }
            if ($job_auto_refresh_arr) {
                QueueAutoRefresh::insert($job_auto_refresh_arr);
            }


            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移企业数据成功.");

        //转移任务分类
        $this->info("开始转移数据...");
        $total = Task::count();
        $bar = $this->output->createProgressBar($total);
        Task::orderBy('id', 'asc')->chunk(10, function ($tasks) use ($bar) {
            $task_arr = [];
            $this->handleTask($tasks, $task_arr);

            if ($task_arr) {
                \App\Models\Task::insert($task_arr);
            }

            $bar->advance(10);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移任务数据成功.");

        //转移任务记录分类
        $this->info("开始转移数据...");
        $total = TaskLog::count();
        $bar = $this->output->createProgressBar($total);
        TaskLog::orderBy('id', 'asc')->chunk(500, function ($tasklogs) use ($bar, $uid) {
            $task_log_arr = [];
            $this->handleTaskLog($tasklogs, $uid, $task_log_arr);

            if ($task_log_arr) {
                \App\Models\TaskLog::insert($task_log_arr);

            }

            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移任务记录数据成功.");

        //转移增值分类
        $this->info("开始转移数据...");
        $total = SetmealIncrement::count();
        $bar = $this->output->createProgressBar($total);
        SetmealIncrement::orderBy('id', 'asc')->chunk(500, function ($setmealIncrements) use ($bar) {
            $setmeal_increment_arr = [];
            $this->handleSetmealIncrement($setmealIncrements, $setmeal_increment_arr);

            if ($setmeal_increment_arr) {
                \App\Models\SetmealIncrement::insert($setmeal_increment_arr);

            }

            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移增值分类数据成功.");

        //转移MembersChargeLog数据
        $this->info("开始转移数据...");
        $total = MembersChargeLog::count();
        $bar = $this->output->createProgressBar($total);
        MembersChargeLog::orderBy('log_id', 'asc')->chunk(500, function ($membersChargeLogs) use ($bar) {
            $members_charge_log_arr = [];
            $this->handleMemChargeLog($membersChargeLogs, $members_charge_log_arr);

            if ($members_charge_log_arr) {
                \App\Models\MembersChargeLog::insert($members_charge_log_arr);

            }

            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移MembersChargeLog数据成功.");

        //转移MembersHandsel数据
        $this->info("开始转移数据...");
        $total = MembersHandsel::count();
        $bar = $this->output->createProgressBar($total);
        MembersHandsel::orderBy('id', 'asc')->chunk(500, function ($membersHandsels) use ($bar, $uid) {
            $members_handsel_arr = [];
            $this->handleMemHandsel($membersHandsels, $uid, $members_handsel_arr);

            if ($members_handsel_arr) {
                \App\Models\MembersHandsel::insert($members_handsel_arr);

            }

            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移MembersHandsel数据成功.");


        //转移MembersSetmealLog数据
        $this->info("开始转移数据...");
        $total = MembersSetmealLog::count();
        $bar = $this->output->createProgressBar($total);
        MembersSetmealLog::orderBy('log_id', 'asc')->chunk(500, function ($membersSetmealLogs) use ($bar) {
            $members_setmeal_log_arr = [];
            $this->handleMemSetmealLog($membersSetmealLogs, $members_setmeal_log_arr);

            if ($members_setmeal_log_arr) {
                \App\Models\MembersSetmealLog::insert($members_setmeal_log_arr);

            }

            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移转移MembersSetmealLog数据数据成功.");

        //转移下载简历库数据
        $this->info("开始转移数据...");
        $total = CompanyDownResume::count();
        $bar = $this->output->createProgressBar($total);
        CompanyDownResume::orderBy('did', 'asc')->chunk(500, function ($companyDownresumes) use ($bar) {
            $down_resume_arr = [];
            $this->handleDownResume($companyDownresumes, $down_resume_arr);

            if ($down_resume_arr) {
                \App\Models\CompanyDownResume::insert($down_resume_arr);

            }
            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移下载简历数据成功.");

        //转移收藏简历数据
        $this->info("开始转移数据...");
        $total = CompanyFavorites::count();
        $bar = $this->output->createProgressBar($total);
        CompanyFavorites::orderBy('did', 'asc')->chunk(500, function ($companyFavorites) use ($bar) {
            $favorites_arr = [];
            $this->handleFavorites($companyFavorites, $favorites_arr);

            if ($favorites_arr) {
                CompanyFavorite::insert($favorites_arr);

            }
            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移收藏简历数据成功.");

        //转移面试邀请数据
        $this->info("开始转移数据...");
        $total = CompanyInterview::count();
        $bar = $this->output->createProgressBar($total);
        CompanyInterview::orderBy('did', 'asc')->chunk(500, function ($companyInterviews) use ($bar) {
            $interview_arr = [];
            $this->handleInterview($companyInterviews, $interview_arr);

            if ($interview_arr) {
                \App\Models\CompanyInterView::insert($interview_arr);

            }
            $bar->advance(500);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移面试数据成功.");

        //转移company_statistics数据
        $this->info("开始转移数据...");
        $total = CompanyStatistics::count();
        $bar = $this->output->createProgressBar($total);
        CompanyStatistics::with('companyProfile')->orderBy('id', 'asc')->chunk(3000, function ($companyStatistics) use ($bar) {
            $statistics_arr = [];
            $this->handleStatistics($companyStatistics, $statistics_arr);

            if ($statistics_arr) {
                \App\Models\CompanyStatistics::insert($statistics_arr);
            }
            $bar->advance(3000);
        });

        $bar->finish();
        $this->line("  完成!");
        $this->info("转移company_statistics数据成功.");
    }

    public function handleStatistics($companyStatistics, &$statistics_arr)
    {
        $statisticsData = [];
        foreach ($companyStatistics as $key => $val) {
            if ($val->companyProfile) {
                $statisticsData['id'] = $val->id;
                if ($val->comid) {
                    $statisticsData['company_id'] = $val->companyProfile->uid;
                } else {
                    $statisticsData['company_id'] = $val->comid;
                };
                $statisticsData['uid'] = $val->uid;
                if ($val->uid) {
                    if ($val->companys) {
                        $statisticsData['utype'] = 1;
                    } else {
                        $statisticsData['utype'] = 2;
                    }
                } else {
                    $statisticsData['utype'] = 0;
                }
                $statisticsData['job_id'] = $val->jobid;
                $statisticsData['source'] = $val->source;
                $statisticsData['apply'] = $val->apply;
                $statisticsData['created_at'] = date('Y-m-d H:i:s', $val->addtime);
                $statisticsData['updated_at'] = date('Y-m-d H:i:s', $val->addtime);
                $statistics_arr[] = $statisticsData;
            }
        }
    }

    public function handleInterview($companyInterviews, &$interview_arr)
    {
        $interviewData = [];
        foreach ($companyInterviews as $key => $val) {
            $interviewData['id'] = $val->did;
            $interviewData['resume_id'] = $val->resume_id;
            $interviewData['resume_name'] = $val->resume_name;
            $interviewData['resume_addtime'] = $val->resume_addtime;
            $interviewData['resume_uid'] = $val->resume_uid;
            $interviewData['jobs_id'] = $val->jobs_id;
            $interviewData['jobs_name'] = $val->jobs_name;
            $interviewData['jobs_addtime'] = $val->jobs_addtime;
            $interviewData['company_id'] = $val->company_uid;
            $interviewData['company_name'] = $val->company_name;
            $interviewData['company_addtime'] = $val->company_addtime;
            $interviewData['interview_addtime'] = $val->interview_addtime;
            $interviewData['notes'] = $val->notes;
            $interviewData['explan'] = '';
            $interviewData['personal_look'] = $val->personal_look;
            $interviewData['result'] = 0;
            $interviewData['interview_time'] = intval($val->interview_time);
            $interviewData['address'] = $val->address;
            $interviewData['contact'] = $val->contact;
            $interviewData['telephone'] = $val->telephone;
            $interviewData['created_at'] = date('Y-m-d H:i:s', $val->interview_addtime);
            $interviewData['updated_at'] = date('Y-m-d H:i:s', $val->interview_addtime);

            $interview_arr[] = $interviewData;
        }
    }

    public function handleFavorites($companyFavorites, &$favorites_arr)
    {
        $FavoritesData = [];
        foreach ($companyFavorites as $key => $val) {
            $FavoritesData['id'] = $val->did;
            $FavoritesData['resume_id'] = $val->resume_id;
            $FavoritesData['company_id'] = $val->company_uid;
            $FavoritesData['created_at'] = date('Y-m-d H:i:s', $val->favorites_addtime);
            $FavoritesData['updated_at'] = date('Y-m-d H:i:s', $val->favorites_addtime);
            $favorites_arr[] = $FavoritesData;
        }
    }

    public function handleDownResume($companyDownresumes, &$down_resume_arr)
    {
        $companyDownResumeData = [];

        foreach ($companyDownresumes as $key => $val) {
            $companyDownResumeData['id'] = $val->did;
            $companyDownResumeData['resume_id'] = $val->resume_id;
            $companyDownResumeData['resume_name'] = $val->resume_name;
            $companyDownResumeData['resume_uid'] = $val->resume_uid;
            $companyDownResumeData['company_uid'] = $val->company_uid;
            $companyDownResumeData['company_name'] = $val->company_name;
            $companyDownResumeData['down_addtime'] = $val->down_addtime;
            $companyDownResumeData['is_reply'] = $val->is_reply;
            $companyDownResumeData['created_at'] = date('Y-m-d H:i:s', $val->down_addtime);
            $companyDownResumeData['updated_at'] = date('Y-m-d H:i:s', $val->down_addtime);
            $down_resume_arr[] = $companyDownResumeData;
        }

    }

    public function handleJobfairJob($jobfairjobs, &$jobfair_job_arr, &$jobfair_job_contact_arr)
    {
        $jobfairJobData = [];
        $jobfairJobContactData = [];
        foreach ($jobfairjobs as $key => $val) {
            $jobfairJobData['id'] = $val->id;
            $jobfairJobData['jobs_name'] = $val->jobs_name;
            $jobfairJobData['company_id'] = $val->companyprofile->uid;
            $jobfairJobData['company_name'] = $val->companyname;
            $jobfairJobData['company_addtime'] = $val->companyprofile->addtime;
            $jobfairJobData['company_audit'] = $val->companyprofile->audit;
            $jobfairJobData['nature'] = $val->nature;
            $jobfairJobData['nature_cn'] = $val->nature_cn;
            $jobfairJobData['stick'] = 0;
            $jobfairJobData['sex'] = $val->sex;
            $jobfairJobData['sex_cn'] = $val->sex_cn;
            $jobfairJobData['age'] = $val->age;
            $jobfairJobData['amount'] = $val->amount;
            $jobfairJobData['topclass'] = $val->topclass;
            $jobfairJobData['category'] = $val->category;
            $jobfairJobData['subclass'] = $val->subclass;
            $jobfairJobData['category_cn'] = $val->category_cn;
            $jobfairJobData['trade'] = $val->trade;
            $jobfairJobData['trade_cn'] = $val->trade_cn;
            $jobfairJobData['scale'] = $val->companyprofile->scale;
            $jobfairJobData['scale_cn'] = $val->companyprofile->scale_cn;
//            $jobfairJobData['district'] = $val->district.'.'.$val->sdistrict.'.'.$val->tdistrict;
            //--转类型（已完成）2019/7/1
            switch ($val->sdistrict) {
                case 0:
                    // $companyArr['district']="10.111.0";
                    $jobfairJobData['district'] = "0";
                    break;
                default:
                    $jobfairJobData['district'] = $val->district . '.' . $val->sdistrict . '.' . $val->tdistrict;
                    break;
            }


            $jobfairJobData['district_cn'] = $val->district_cn;
            $jobfairJobData['tag'] = $val->tag == "请选择" ? "" : $val->tag;
            $jobfairJobData['tag_cn'] = $val->tag_cn;
            $jobfairJobData['education'] = $val->education;
            $jobfairJobData['education_cn'] = $val->education_cn;
            $jobfairJobData['experience'] = $val->experience;
            $jobfairJobData['experience_cn'] = $val->experience_cn;


            //--转类型（待修改）2019/7/1
            $jobfairJobData['wage'] = 0;
            if ($val->negotiable == 1) {
                $jobfairJobData['wage'] = -1;
                $jobfairJobData['wage_min'] = 0;
                $jobfairJobData['wage_max'] = 0;
                $jobfairJobData['wage_cn'] = '';
            } else {
                if ($val->maxwage == 2000 && $val->minwage == 1500) {
                    $jobfairJobData['wage'] = 57;
                    $jobfairJobData['wage_min'] = 1500;
                    $jobfairJobData['wage_max'] = 2000;
                    $jobfairJobData['wage_cn'] = '1800~2000/月';
                } elseif ($val->maxwage == 3000 && $val->minwage == 2000) {
                    $jobfairJobData['wage'] = 58;
                    $jobfairJobData['wage_min'] = 2000;
                    $jobfairJobData['wage_max'] = 3000;
                    $jobfairJobData['wage_cn'] = '2000~3000/月';
                } elseif ($val->maxwage == 5000 && $val->minwage == 3000) {
                    $jobfairJobData['wage'] = 59;
                    $jobfairJobData['wage_min'] = 3000;
                    $jobfairJobData['wage_max'] = 5000;
                    $jobfairJobData['wage_cn'] = '3000~5000/月';
                } elseif ($val->maxwage == 10000 && $val->minwage == 5000) {
                    $jobfairJobData['wage'] = 60;
                    $jobfairJobData['wage_min'] = 5000;
                    $jobfairJobData['wage_max'] = 10000;
                    $jobfairJobData['wage_cn'] = '5000~10000/月';
                } else {
                    $jobfairJobData['wage'] = 0;
                    $jobfairJobData['wage_min'] = $val->minwage;
                    $jobfairJobData['wage_max'] = $val->maxwage;
                    $jobfairJobData['wage_cn'] = intval($val->minwage) . '~' . intval($val->maxwage) . '/月';
                }
            }
            $jobfairJobData['jobs_content'] = $val->contents;
            $jobfairJobData['major'] = 0;
            $jobfairJobData['major_cn'] = '';
            $jobfairJobData['audit'] = $val->audit;
            $jobfairJobData['click'] = 0;
            $jobfairJobData['display'] = 1;
            $jobfairJobData['robot'] = 0;
            $jobfairJobData['map_x'] = $val->companyprofile->map_x;
            $jobfairJobData['map_y'] = $val->companyprofile->map_y;
            $jobfairJobData['is_entrust'] = 0;
            $jobfairJobData['map_zoom'] = $val->companyprofile->map_zoom;
            $jobfairJobData['add_mode'] = 1;
            $jobfairJobData['zcid'] = 0;
            $jobfairJobData['zc_cn'] = '';
            $jobfairJobData['zc_name'] = '';

            $jobfairJobData['type'] = 1;
            $jobfairJobData['created_at'] = date('Y-m-d H:i:s', $val->addtime);
            $jobfairJobData['updated_at'] = date('Y-m-d H:i:s', $val->addtime);
            $jobfair_job_arr[] = $jobfairJobData;
            if ($val->jobfairContact) {
                $jobfairJobContactData['id'] = $val->jobfairContact->id;
                $jobfairJobContactData['pid'] = $val->jobfairContact->pid;
                $jobfairJobContactData['contact'] = $val->jobfairContact->contact;
                $jobfairJobContactData['qq'] = $val->jobfairContact->qq == 0 ? '' : $val->jobfairContact->qq;
                $jobfairJobContactData['mobile'] = $val->jobfairContact->telephone;
                $jobfairJobContactData['landline_tel'] = $val->jobfairContact->landline_tel;
                $jobfairJobContactData['email'] = $val->jobfairContact->email;
                $jobfairJobContactData['address'] = $val->jobfairContact->address;
                $jobfairJobContactData['notify'] = $val->jobfairContact->notify;
                $jobfairJobContactData['notify_mobile'] = $val->jobfairContact->notify_mobile;
                $jobfairJobContactData['contact_show'] = $val->jobfairContact->contact_show;
                $jobfairJobContactData['telephone_show'] = $val->jobfairContact->telephone_show;
                $jobfairJobContactData['email_show'] = $val->jobfairContact->email_show;
                $jobfairJobContactData['landline_tel_show'] = $val->jobfairContact->landline_tel_show;
                $jobfairJobContactData['created_at'] = date('Y-m-d H:i:s', $val->jobfairContact->addtime);
                $jobfairJobContactData['updated_at'] = date('Y-m-d H:i:s', $val->jobfairContact->addtime);
                $jobfair_job_contact_arr[] = $jobfairJobContactData;

            }
        }
    }

    public function handleMemSetmealLog($membersSetmealLogs, &$members_setmeal_log_arr)
    {
        $memberSetmealLogData = [];
        foreach ($membersSetmealLogs as $key => $val) {
            $memberSetmealLogData['id'] = $val->log_id;
            $memberSetmealLogData['log_uid'] = $val->log_uid;
            $memberSetmealLogData['log_utype'] = $val->log_utype;
            $memberSetmealLogData['log_username'] = $val->log_username;
            $memberSetmealLogData['log_value'] = $val->log_value;
            $memberSetmealLogData['log_ip'] = $val->log_ip;
            $memberSetmealLogData['log_address'] = $val->log_address;
            $memberSetmealLogData['log_leave'] = $val->log_leave;
            $memberSetmealLogData['log_source'] = $val->log_source;
            $memberSetmealLogData['created_at'] = date('Y-m-d H:i:s', $val->log_addtime);
            $memberSetmealLogData['updated_at'] = date('Y-m-d H:i:s', $val->log_addtime);
            $members_setmeal_log_arr[] = $memberSetmealLogData;
        }
    }

    public function handleMemHandsel($membersHandsels, $uid, &$members_handsel_arr)
    {
        $memberHandselData = [];

        foreach ($membersHandsels as $key => $val) {
            $memberHandselData['id'] = $val->id;
            $memberHandselData['uid'] = $val->uid;
            $memberHandselData['utype'] = 2;
            if (in_array($val['uid'], $uid)) {
                $memberHandselData['utype'] = 1;
            }
            $memberHandselData['htype'] = $val->htype;
            $memberHandselData['operate'] = $val->operate;
            $memberHandselData['points'] = $val->points;
            $memberHandselData['htype_cn'] = $val->htype_cn;
            $memberHandselData['created_at'] = date('Y-m-d H:i:s', $val->addtime);
            $memberHandselData['updated_at'] = date('Y-m-d H:i:s', $val->addtime);
            $members_handsel_arr[] = $memberHandselData;
        }
    }

    public function handleMemChargeLog($membersChargeLogs, &$members_charge_log_arr)
    {
        $memChargeLogData = [];
        foreach ($membersChargeLogs as $key => $val) {
            $memChargeLogData['id'] = $val->log_id;
            $memChargeLogData['log_uid'] = $val->log_uid;
            $memChargeLogData['log_utype'] = $val->log_utype;
            $memChargeLogData['log_username'] = $val->log_username;
            $memChargeLogData['log_value'] = $val->log_value;
            $memChargeLogData['log_amount'] = $val->log_amount;
            $memChargeLogData['log_ismoney'] = $val->log_ismoney;
            $memChargeLogData['log_type'] = $val->log_type;
            $memChargeLogData['log_mode'] = $val->log_mode;
            $memChargeLogData['created_at'] = date('Y-m-d H:i:s', $val->log_addtime);
            $memChargeLogData['updated_at'] = date('Y-m-d H:i:s', $val->log_addtime);
            $members_charge_log_arr[] = $memChargeLogData;
        }
    }

    public function handleSetmealIncrement($setmealIncrement, &$setmeal_increment_arr)
    {
        $setmealIncrementData = [];
        foreach ($setmealIncrement as $key => $val) {
            $setmealIncrementData['id'] = $val->id;
            $setmealIncrementData['cat'] = $val->cat;
            $setmealIncrementData['name'] = $val->name;
            $setmealIncrementData['value'] = $val->value;
            $setmealIncrementData['price'] = $val->price;
            $setmealIncrementData['sort'] = $val->sort;
            $setmealIncrementData['created_at'] = date('Y-m-d H:i:s', time());
            $setmealIncrementData['updated_at'] = date('Y-m-d H:i:s', time());
            $setmeal_increment_arr[] = $setmealIncrementData;

        }
    }

    public function handleTaskLog($tasklog, $uid, &$task_log_arr)
    {
        $taskLogData = [];
        foreach ($tasklog as $key => $val) {
            $taskLogData['id'] = $val->id;
            $taskLogData['uid'] = $val->uid;
            $taskLogData['utype'] = 2;
            if (in_array($val['uid'], $uid)) {
                $taskLogData['utype'] = 1;
            }
            $taskLogData['task_id'] = $val->taskid;
            $taskLogData['points'] = $val->points;
            $taskLogData['once'] = $val->once;
            $taskLogData['created_at'] = date('Y-m-d H:i:s', $val->addtime);
            $taskLogData['updated_at'] = date('Y-m-d H:i:s', $val->addtime);
            $task_log_arr[] = $taskLogData;
        }

    }

    public function handleTask($task, &$task_arr)
    {
        $taskData = [];
        foreach ($task as $key => $val) {
            $taskData['id'] = $val->id;
            $taskData['title'] = $val->title;
            $taskData['t_alias'] = $val->t_alias;
            $taskData['points'] = $val->points;
            $taskData['once'] = $val->once;
            $taskData['becount'] = $val->becount;
            $taskData['times'] = $val->times;
            $taskData['utype'] = $val->utype;
            $taskData['dayly'] = $val->dayly;
            $taskData['status'] = $val->status;
            $taskData['created_at'] = date('Y-m-d H:i:s', time());
            $taskData['updated_at'] = date('Y-m-d H:i:s', time());
            $task_arr[] = $taskData;
        }
    }

    public function handleCompany($company, &$result_array)
    {
        $companyArr = [];
        $companyArr['id'] = $company->uid;
        $companyArr['username'] = $company->username;
        if ($company->mobile) {
            $companyArr['mobile'] = $company->mobile;
        } else {
            $companyArr['mobile'] = null;
        }
        $companyArr['tpl'] = "default";
        $companyArr['mobile_audit'] = $company->mobile_audit;
        $companyArr['email'] = $company->email;
        $companyArr['email_audit'] = $company->email_audit;
        $companyArr['reg_time'] = $company->reg_time;
        $companyArr['reg_ip'] = ip2long($company->reg_ip);
        $companyArr['last_login_time'] = $company->last_login_time;
        $companyArr['last_login_ip'] = ip2long($company->last_login_ip);
        $companyArr['reg_address'] = $company->reg_address;
        $companyArr['remind_email_time'] = $company->remind_email_time;
        $companyArr['remind_email_ex_time'] = $company->remind_email_ex_time;
        $companyArr['reg_type'] = $company->reg_type;
        $companyArr['old_password'] = $company->password;
        $companyArr['companyname'] = $company->username;

        //新增字段
        $companyArr['laiyuan'] = $company->laiyuan;
        $companyArr['qx_id'] = $company->qx_id;
        $companyArr['invitation_code'] = $company->invitation_code;
        $companyArr['pwd_hash'] = $company->pwd_hash;

        $companyArr['nature'] = 0;
        $companyArr['trade'] = 0;
        $companyArr['district'] = "0";

        $companyArr['district_cn'] = '0';
        $companyArr['scale'] = 0;
        $companyArr['registered'] = 0;
        $companyArr['currency'] = '万人民币';
        $companyArr['address'] = '';
        $companyArr['contact'] = '';
        $companyArr['landline_tel'] = '';
        $companyArr['website'] = '';
        $companyArr['sms_num'] = 0;
        $companyArr['certificate_img'] = ''; //营业执照
        $companyArr['logo'] = '';
        $companyArr['certificate_img_audit'] = 0;
        $companyArr['organization_code'] = '';
        $companyArr['contents'] = '';
        $companyArr['setmeal_id'] = 0;
        $companyArr['setmeal_name'] = '';
        $companyArr['audit'] = 0;
        $companyArr['subsite_id'] = 0;
        $companyArr['map_open'] = 1;
        $companyArr['map_x'] = 0.000000;
        $companyArr['map_y'] = 0.000000;
        $companyArr['map_zoom'] = 18;
        $companyArr['refresh_time'] = 0;
        $companyArr['click'] = 0;
        $companyArr['user_status'] = 1;
        $companyArr['contact_show'] = 1;
        $companyArr['telephone_show'] = 1;
        $companyArr['email_show'] = 1;
        $companyArr['landline_tel_show'] = 1;
        $companyArr['robot'] = 0;
        $companyArr['comment'] = '';
        $companyArr['resume_processing'] = 0;
        $companyArr['tag'] = '';
        $companyArr['wzp_tpl'] = 0;
        $companyArr['jobs'] = 0;
        $companyArr['replys'] = 0;
        $companyArr['qq'] = '';
        $companyArr['short_name'] = '';
        //单位性质、产业类别、经济类型
        $companyArr['unit_character'] = 0;
        $companyArr['unit_character_cn'] = '';
        $companyArr['industry'] = 0;
        $companyArr['industry_cn'] = '';
        $companyArr['economy'] = 0;
        $companyArr['economy_cn'] = '';
        $companyArr['legal'] = '';
        $companyArr['legal_idcard'] = '';


        //--转类型（已完成）2019/7/1
        if ($company->companyProfile) {
            $companyArr['tpl'] = empty($company->companyProfile->tpl) ? 'default' : $company->companyProfile->tpl;
            $companyArr['companyname'] = $company->companyProfile->companyname;
            $companyArr['nature'] = $company->companyProfile->nature;
            $companyArr['trade'] = $company->companyProfile->trade;
            switch ($company->companyProfile->sdistrict) {
                case 0:
                    $companyArr['district'] = "0";
                    break;
                default:
                    $sdistrict = $company->companyProfile->sdistrict == '568' ? 0 : $company->companyProfile->sdistrict;
                    $companyArr['district'] = $company->companyProfile->district . '.' . $sdistrict . '.' . $company->companyProfile->tdistrict;
                    break;
            }
            $companyArr['district_cn'] = $company->companyProfile->district_cn;
            $companyArr['scale'] = $company->companyProfile->scale;
            $companyArr['registered'] = $company->companyProfile->registered ? intval($company->companyProfile->registered) : 0;
            $companyArr['currency'] = $company->companyProfile->currency ? $company->companyProfile->currency : '万人民币';
            $companyArr['address'] = $company->companyProfile->address;
            $companyArr['contact'] = $company->companyProfile->contact;
            $companyArr['landline_tel'] = $company->companyProfile->landline_tel;
            $companyArr['website'] = $company->companyProfile->website;
            $companyArr['sms_num'] = $company->sms_num;
            $companyArr['certificate_img'] = $company->companyProfile->certificate_img ? 'old/certificate_img/' . $company->companyProfile->certificate_img : ''; //营业执照


            $companyArr['logo'] = $company->companyProfile->logo ? 'old/company_logo/' . $company->companyProfile->logo : '';
            if ($company->companyProfile->certificate_img && $company->companyProfile->audit == 1) {
                $companyArr['certificate_img_audit'] = 1;
            } elseif ($company->companyProfile->certificate_img && $company->companyProfile->audit == 3) {
                $companyArr['certificate_img_audit'] = 3;
            } else {
                $companyArr['certificate_img_audit'] = 2;
            }

            $companyArr['organization_code'] = $company->companyProfile->company_code;
            $companyArr['contents'] = $company->companyProfile->contents;
            if ($company->membersSetmeal) {
                $companyArr['setmeal_id'] = $company->membersSetmeal->setmeal_id;
                $companyArr['setmeal_name'] = $company->membersSetmeal->setmeal_name;
            }
            $companyArr['audit'] = $company->companyProfile->audit;
            $companyArr['subsite_id'] = $company->subsite_id;
            $companyArr['map_open'] = $company->companyProfile->map_open;
            $companyArr['map_x'] = $company->companyProfile->map_x;
            $companyArr['map_y'] = $company->companyProfile->map_y;
            $companyArr['map_zoom'] = $company->companyProfile->map_zoom;
            $companyArr['refresh_time'] = $company->companyProfile->refreshtime;
            $companyArr['click'] = $company->companyProfile->click;
            $companyArr['user_status'] = $company->companyProfile->user_status;
            $companyArr['contact_show'] = $company->companyProfile->contact_show;
            $companyArr['telephone_show'] = $company->companyProfile->telephone_show;
            $companyArr['email_show'] = $company->companyProfile->email_show;
            $companyArr['landline_tel_show'] = $company->companyProfile->landline_tel_show;
            $companyArr['robot'] = $company->companyProfile->robot;
            $companyArr['comment'] = $company->companyProfile->comment;
            $companyArr['resume_processing'] = $company->companyProfile->resume_processing;
            $tag = explode(',', $company->companyProfile->tag);
            $tagArr = [];
            foreach ($tag as $te => $va) {
                $tagArr[] = explode('|', $va)[0];
            }
            $companyArr['tag'] = implode(',', $tagArr);
            $companyArr['wzp_tpl'] = $company->companyProfile->wzp_tpl;
            $companyArr['jobs'] = $company->companyProfile->jobs;
            $companyArr['replys'] = $company->companyProfile->replys;
            $companyArr['qq'] = $company->companyProfile->qq == 0 ? '' : $company->companyProfile->qq;
            $companyArr['legal'] = $company->companyProfile->legal_person;
            $companyArr['short_name'] = \Illuminate\Support\Str::substr($company->companyProfile->companyname, 0, 25);
        }
        $companyArr['created_at'] = date('Y-m-d H:i:s', $company->reg_time);
        $companyArr['updated_at'] = date('Y-m-d H:i:s', $company->reg_time);

        $result_array[] = $companyArr;
    }

    public function handleCompanyImg($company, $img, &$company_img_array)
    {
        if (!$img->isEmpty()) {
            foreach ($img as $key => $val) {
                $companyImgArr['id'] = $val->id;
                $companyImgArr['company_id'] = $company->uid;
                $companyImgArr['title'] = $val->title;
                $companyImgArr['image'] = 'old/company_img/' . $val->img;
                $companyImgArr['audit'] = $val->audit;
                $companyImgArr['subsite_id'] = $company->subsite_id;
                $companyImgArr['created_at'] = date('Y-m-d H:i:s', $val->addtime);
                $companyImgArr['updated_at'] = date('Y-m-d H:i:s', $val->addtime);
                $company_img_array[] = $companyImgArr;
            }

        }
    }

    public function handleMemberSetmeal($company, $memberSetmeal, $setmealInfo, &$company_setmeal_array)
    {
        $membersSetmealArr = [];
        if ($memberSetmeal) {
            $membersSetmealArr['uid'] = $company->uid;
            $membersSetmealArr['expire'] = $memberSetmeal->expire;
            $membersSetmealArr['utype'] = 1;
            $membersSetmealArr['setmeal_id'] = $memberSetmeal->setmeal_id;
            $membersSetmealArr['setmeal_name'] = $memberSetmeal->setmeal_name;
            $membersSetmealArr['days'] = $memberSetmeal->days;
            $membersSetmealArr['expense'] = $memberSetmeal->expense;
            $membersSetmealArr['jobs_meanwhile'] = $memberSetmeal->jobs_meanwhile;
            $membersSetmealArr['refresh_jobs_free'] = $memberSetmeal->refresh_jobs_free;
            $membersSetmealArr['download_resume'] = $memberSetmeal->download_resume;
            $membersSetmealArr['download_resume_max'] = $memberSetmeal->download_resume_max;
            $membersSetmealArr['added'] = $memberSetmeal->added;
            $membersSetmealArr['starttime'] = $memberSetmeal->starttime;
            $membersSetmealArr['endtime'] = $memberSetmeal->endtime;
            $membersSetmealArr['setmeal_img'] = $memberSetmeal->setmeal_img;
            $membersSetmealArr['show_apply_contact'] = $setmealInfo->show_apply_contact;
            $membersSetmealArr['is_free'] = $memberSetmeal->is_free;
            $membersSetmealArr['discount_download_resume'] = $memberSetmeal->discount_download_resume;
            $membersSetmealArr['discount_sms'] = $memberSetmeal->discount_sms;
            $membersSetmealArr['discount_stick'] = $memberSetmeal->discount_stick;
            $membersSetmealArr['discount_emergency'] = $memberSetmeal->discount_emergency;
            $membersSetmealArr['discount_tpl'] = $memberSetmeal->discount_tpl;
            $membersSetmealArr['discount_auto_refresh_jobs'] = $memberSetmeal->discount_auto_refresh_jobs;
            $membersSetmealArr['show_contact_direct'] = $memberSetmeal->show_contact_direct;
            $membersSetmealArr['created_at'] = date('Y-m-d H:i:s', $memberSetmeal->starttime);
            $membersSetmealArr['updated_at'] = date('Y-m-d H:i:s', $memberSetmeal->starttime);
        } else {
            $membersSetmealArr['uid'] = $company->uid;
            $membersSetmealArr['expire'] = 0;
            $membersSetmealArr['utype'] = 1;
            $membersSetmealArr['setmeal_id'] = $setmealInfo->id;
            $membersSetmealArr['setmeal_name'] = $setmealInfo->setmeal_name;
            $membersSetmealArr['days'] = $setmealInfo->days;
            $membersSetmealArr['expense'] = $setmealInfo->expense;
            $membersSetmealArr['jobs_meanwhile'] = $setmealInfo->jobs_meanwhile;
            $membersSetmealArr['refresh_jobs_free'] = $setmealInfo->refresh_jobs_free;
            $membersSetmealArr['download_resume'] = $setmealInfo->download_resume;
            $membersSetmealArr['download_resume_max'] = $setmealInfo->download_resume_max;
            $membersSetmealArr['added'] = $setmealInfo->added;
            $membersSetmealArr['starttime'] = $company->reg_time;
            $membersSetmealArr['endtime'] = 0;
            $membersSetmealArr['setmeal_img'] = $setmealInfo->setmeal_img;
            $membersSetmealArr['show_apply_contact'] = $setmealInfo->show_apply_contact;
            $membersSetmealArr['is_free'] = $setmealInfo->is_free;
            $membersSetmealArr['discount_download_resume'] = $setmealInfo->discount_download_resume;
            $membersSetmealArr['discount_sms'] = $setmealInfo->discount_sms;
            $membersSetmealArr['discount_stick'] = $setmealInfo->discount_stick;
            $membersSetmealArr['discount_emergency'] = $setmealInfo->discount_emergency;
            $membersSetmealArr['discount_tpl'] = $setmealInfo->discount_tpl;
            $membersSetmealArr['discount_auto_refresh_jobs'] = $setmealInfo->discount_auto_refresh_jobs;
            $membersSetmealArr['show_contact_direct'] = $setmealInfo->show_contact_direct;
            $membersSetmealArr['created_at'] = date('Y-m-d H:i:s', time());
            $membersSetmealArr['updated_at'] = date('Y-m-d H:i:s', time());
        }
        $company_setmeal_array[] = $membersSetmealArr;
    }

    public function handleMemberPoints($company, $memberPoints, &$company_points_array)
    {
        $membersPointsArr = [];
        if ($memberPoints) {
            $membersPointsArr['uid'] = $company->uid;
            $membersPointsArr['utype'] = 1;
            $membersPointsArr['points'] = $memberPoints->points;
        } else {
            $membersPointsArr['uid'] = $company->uid;
            $membersPointsArr['utype'] = 1;
            $membersPointsArr['points'] = 0;
        }
        $company_points_array[] = $membersPointsArr;
    }

    public function handleCompanyJob($company, $jobs, &$result_array, &$jobs_contact_arr, &$subsite_job_array, &$job_promotion_arr, &$job_auto_refresh_arr)
    {
        $jobsArr = [];
        $subsiteData = [];
        $jobsContactArr = [];
        $jobPromotionArr = [];
        $jobAutoRefreshArr = [];
        foreach ($jobs as $key => $val) {
            $jobsArr['id'] = $val->id;
            $jobsArr['jobs_name'] = $val->jobs_name;
            $jobsArr['valid'] = 1;
            $jobsArr['company_id'] = $val->uid;
            $jobsArr['company_name'] = $val->companyname;
            $jobsArr['company_addtime'] = $val->company_addtime;
            $jobsArr['company_audit'] = $val->company_audit;
            $jobsArr['emergency'] = $val->emergency;
            $jobsArr['stick'] = $val->stick;
            $jobsArr['nature'] = $val->nature;
            $jobsArr['sex'] = $val->sex;
            if ($val->age == '0-0') {
                $jobsArr['age'] = '-';
            } else {
                $jobsArr['age'] = $val->age;
            }
            $jobsArr['amount'] = $val->amount;
            $jobsArr['topclass'] = $val->topclass;
            $jobsArr['category'] = $val->category;
            $jobsArr['subclass'] = $val->subclass;
            $jobsArr['trade'] = $val->trade;
            $jobsArr['scale'] = $val->scale;

            //职位新增字段
            $jobsArr['is_entrust'] = $val->is_entrust;
            $jobsArr['famous'] = $val->famous;
            $jobsArr['gaoji_jobs'] = $val->gaoji_jobs;
            $jobsArr['laiyuan'] = $val->laiyuan;
            $jobsArr['qx_id'] = $val->qx_id;


            //--转类型（已完成）2019/7/1
            switch ($val->sdistrict) {
                case 0:
                    // $companyArr['district']="10.111.0";
                    $jobsArr['district'] = "0";
                    break;
                default:
                    $jobsArr['district'] = $val->district . '.' . $val->sdistrict . '.' . $val->tdistrict;
                    break;
            }

            if ($val->tag == '请选择') {
                $jobsArr['tag'] = '';
            } else {
                $jobsArr['tag'] = $val->tag;
            }
            $jobsArr['education'] = $val->education;
            $jobsArr['experience'] = $val->experience;


            //--转类型（待修改）2019/7/1
            $jobsArr['wage'] = 0;
            if ($val->negotiable == 1) {
                $jobsArr['wage'] = -1;
                $jobsArr['wage_min'] = 0;
                $jobsArr['wage_max'] = 0;
            } else {
                if ($val->maxwage == 2000 && $val->minwage == 1500) {
                    $jobsArr['wage'] = 57;
                    $jobsArr['wage_min'] = 1500;
                    $jobsArr['wage_max'] = 2000;
                } elseif ($val->maxwage == 3000 && $val->minwage == 2000) {
                    $jobsArr['wage'] = 58;
                    $jobsArr['wage_min'] = 2000;
                    $jobsArr['wage_max'] = 3000;
                } elseif ($val->maxwage == 5000 && $val->minwage == 3000) {
                    $jobsArr['wage'] = 59;
                    $jobsArr['wage_min'] = 3000;
                    $jobsArr['wage_max'] = 5000;
                } elseif ($val->maxwage == 10000 && $val->minwage == 5000) {
                    $jobsArr['wage'] = 60;
                    $jobsArr['wage_min'] = 5000;
                    $jobsArr['wage_max'] = 10000;
                } else {
                    $jobsArr['wage'] = 0;
                    $jobsArr['wage_min'] = $val->minwage;
                    $jobsArr['wage_max'] = $val->maxwage;
                }
            }

            $jobsArr['jobs_content'] = $val->contents;
            $jobsArr['deadline'] = $val->deadline;
            $jobsArr['refresh_time'] = $val->refreshtime;
            $jobsArr['stime'] = $val->stime;
            $jobsArr['setmeal_deadline'] = $val->setmeal_deadline;
            $jobsArr['setmeal_id'] = $val->setmeal_id;
            $jobsArr['setmeal_name'] = $val->setmeal_name;
            $jobsArr['audit'] = $val->audit;
            $jobsArr['click'] = $val->click;

            if ($val->deadline < time() && $val->deadline != 0) {
                $jobsArr['display'] = 2;
            } else {
                $jobsArr['display'] = $val->display;
            }
            $jobsArr['robot'] = $val->robot;
            $jobsArr['map_x'] = $val->map_x;
            $jobsArr['map_y'] = $val->map_y;
            $jobsArr['map_zoom'] = $val->map_zoom;
            $jobsArr['add_mode'] = $val->add_mode;
            $jobsArr['department'] = $val->department;
            $jobsArr['subsite_id'] = $company->subsite_id;

            $jobsArr['created_at'] = date('Y-m-d H:i:s', $val->addtime);
            $jobsArr['updated_at'] = date('Y-m-d H:i:s', $val->addtime);

            $subsiteData['jobs_id'] = $val->id;
            $subsiteData['subsite_id'] = $company->subsite_id;
            $subsiteData['created_at'] = date('Y-m-d H:i:s', time());
            $subsiteData['updated_at'] = date('Y-m-d H:i:s', time());
            $subsite_job_array[] = $subsiteData;


            if ($val->jobsContact) {
                $jobsContactArr['id'] = $val->jobsContact->id;
                $jobsContactArr['job_id'] = $val->jobsContact->pid;
                $jobsContactArr['contact'] = $val->jobsContact->contact;
                $jobsContactArr['qq'] = $val->jobsContact->qq;
                $jobsContactArr['telephone'] = $val->jobsContact->telephone;
                $jobsContactArr['notify'] = $val->jobsContact->notify;
                $jobsContactArr['landline_tel'] = $val->jobsContact->landline_tel ? $val->jobsContact->landline_tel : "--";
                $jobsContactArr['email'] = $val->jobsContact->email;
                $jobsContactArr['address'] = $val->jobsContact->address;
                $jobsContactArr['notify_mobile'] = $val->jobsContact->notify_mobile;
                $jobsContactArr['contact_show'] = $val->jobsContact->contact_show;
                $jobsContactArr['telephone_show'] = $val->jobsContact->telephone_show;
                $jobsContactArr['email_show'] = $val->jobsContact->email_show;
                $jobsContactArr['landline_tel_show'] = $val->jobsContact->landline_tel_show;
                $jobsContactArr['created_at'] = date('Y-m-d H:i:s', time());
                $jobsContactArr['updated_at'] = date('Y-m-d H:i:s', time());
                $jobs_contact_arr[] = $jobsContactArr;
            }

            if (!$val->promotions->isEmpty()) {
                foreach ($val->promotions as $k => $v) {
                    $jobPromotionArr['id'] = $v['cp_id'];
                    $jobPromotionArr['companyid'] = $v['cp_uid'];
                    $jobPromotionArr['ptype'] = $v['cp_ptype'] == "stick" ? 1 : 2;
                    $jobPromotionArr['jobid'] = $v['cp_jobid'];
                    $jobPromotionArr['days'] = $v['cp_days'];
                    $jobPromotionArr['starttime'] = $v['cp_starttime'];
                    $jobPromotionArr['endtime'] = $v['cp_endtime'];
                    $jobPromotionArr['created_at'] = date('Y-m-d H:i:s', $v['cp_starttime']);
                    $jobPromotionArr['updated_at'] = date('Y-m-d H:i:s', $v['cp_starttime']);
                    if ($v['cp_ptype'] == 'stick') {
                        $jobsArr['stick'] = 1;
                        $jobsArr['stime'] = $v['cp_starttime'];
                    }
                    if ($v['cp_ptype'] == 'emergency') {
                        $jobsArr['emergency'] = 1;
                    }
                    $job_promotion_arr[] = $jobPromotionArr;
                }

            } else {
                $jobsArr['stick'] = 0;
                $jobsArr['stime'] = 0;
                $jobsArr['emergency'] = 0;
            }
            if ($val->autoRefresh) {
                foreach ($val->autoRefresh as $k => $v) {
                    $jobAutoRefreshArr['pid'] = $v['pid'];
                    $jobAutoRefreshArr['type'] = $v['type'];
                    $jobAutoRefreshArr['uid'] = $v['uid'];
                    $jobAutoRefreshArr['utype'] = 1;
                    $jobAutoRefreshArr['refreshtime'] = $v['refreshtime'];
                    $jobAutoRefreshArr['created_at'] = date('Y-m-d H:i:s', $v['refreshtime']);
                    $jobAutoRefreshArr['updated_at'] = date('Y-m-d H:i:s', $v['refreshtime']);
                    $job_auto_refresh_arr[] = $jobAutoRefreshArr;
                }

            }

            $result_array[] = $jobsArr;
        }
    }

}