<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/4/8
 * Time: 14:04
 */

namespace App\Console\Commands\Transfer;

use App\Models\CategoryDistrict;
use App\Models\CategoryGroups;
use App\Models\CategoryJobs;
use App\Models\MembersPoint;
use App\Models\PersonalServiceStick;
use App\Models\PersonalServiceTag;
use App\Models\ResumeCredent;
use App\Models\ResumeLanguage;
use App\Models\ResumeTrain;
use App\Models\ResumeWork;
use App\Models\SubsiteResume;
use App\Transfer\Category;
use App\Transfer\CategoryGroup;
use App\Transfer\CategoryMajor;
use Illuminate\Console\Command;
use App\Transfer\Member;
use App\Models\Member as mem;
use App\Models\MemberInfo;
use App\Models\Resume;
use App\Models\ResumeEducation;

class UpdateMemberCommand extends Command
{
    protected $signature = 'aix:transfer-update-member';
    protected $description = 'add the transfer-update-member data';

    public function __construct()
    {
        parent::__construct();
    }

    public function handle()
    {
        $TransferMember = Member::where(['utype'=>2])->orderBy('uid', 'asc')->get();
        $count = 0;
        foreach ($TransferMember as $k=>$v) {
            $result = Member::where('uid', $v->uid)->first();
            $resultM = $result->getAllMemberInfo();
            /**
             * 个人用户账号。
             */
            $memberDate= [];
            $memberDate['id'] = $resultM->uid;
            $memberDate['utype'] = $resultM->utype;
            $memberDate['username'] = $resultM->username;
            $memberDate['email'] = $resultM->email;
            $memberDate['email_audit'] = $resultM->email_audit;
            $memberDate['mobile'] = $resultM->mobile;
            $memberDate['mobile_audit'] = $resultM->mobile_audit;
            $memberDate['old_password'] = $resultM->password;
            $memberDate['reg_time'] = $resultM->reg_time;
            $memberDate['reg_ip'] = ip2long($resultM->reg_ip);
            $memberDate['reg_address'] = $resultM->reg_address;
            $memberDate['last_login_time'] = $resultM->last_login_time;
            $memberDate['last_login_ip'] = ip2long($resultM->last_login_ip);
            $memberDate['status'] = $resultM->status;
            if (strpos($resultM->avatars,'http')!== false) {
                $avatars = $resultM->avatars;
            } else {
                if ($resultM->avatars) {
                    $avatars = 'avatar/'.$resultM->avatars;
                } else {
                    $avatars = $resultM->avatars;
                }
            }
            $memberDate['avatars'] = $avatars;
            $memberDate['robot'] = $resultM->robot;
            $memberDate['remind_email_time'] = $resultM->remind_email_time;
            $memberDate['sms_num'] = $resultM->sms_num;
            $memberDate['reg_type'] = $resultM->reg_type;
            $memberDate['remind_email_ex_time'] = $resultM->remind_email_ex_time;
            $memberDate['subsite_id'] = $resultM->subsite_id;
            $memberDate['created_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
            $memberDate['updated_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
            if ($memberDate) {
                $mem = mem::create($memberDate);
                if ($mem) {
                    /**
                     * 个人用户信息。
                     */
                    $memberInfoData=[];
                    if ($resultM->memberInfos) {
                        $memberInfoData['id'] = $resultM->memberInfos->id;
                        $memberInfoData['uid'] = $resultM->memberInfos->uid;
                        $memberInfoData['realname'] = $resultM->memberInfos->realname;
                        $memberInfoData['display_name'] = $resultM->memberInfos->display_name;
                        $memberInfoData['sex'] = $resultM->memberInfos->sex;
                        $memberInfoData['sex_cn'] = $resultM->memberInfos->sex_cn;
                        $memberInfoData['birthday'] = $resultM->memberInfos->birthday;
                        $memberInfoData['card_t_cn'] = 306;
                        $memberInfoData['id_card'] = $resultM->memberInfos->zs_idcode;
                        $memberInfoData['residence'] = '11.129.0';
                        $memberInfoData['residence_cn'] = $resultM->memberInfos->residence;
                        $memberInfoData['education'] = $resultM->memberInfos->education;
                        $memberInfoData['education_cn'] = $resultM->memberInfos->education_cn;
                        $memberInfoData['major'] = $resultM->memberInfos->major;
                        $memberInfoData['major_cn'] = $resultM->memberInfos->major_cn;
                        $memberInfoData['experience'] = $resultM->memberInfos->experience;
                        $memberInfoData['experience_cn'] = $resultM->memberInfos->experience_cn;
                        $memberInfoData['phone'] = $resultM->memberInfos->phone;
                        $memberInfoData['email'] = $resultM->memberInfos->email;
                        $memberInfoData['height'] = $resultM->memberInfos->height ? $resultM->memberInfos->height : '';
                        $memberInfoData['householdaddress'] = '11.129.0';
                        $memberInfoData['householdaddress_cn'] = $resultM->memberInfos->householdaddress;
                        $memberInfoData['qq'] = $resultM->memberInfos->qq;
                        $memberInfoData['weixin'] = $resultM->memberInfos->weixin;
                        $memberInfoData['marriage'] = $resultM->memberInfos->marriage;
                        $memberInfoData['marriage_cn'] = $resultM->memberInfos->marriage_cn;
                        $memberInfoData['images'] = $avatars;
                        $memberInfoData['display_images'] = 1;
                        $memberInfoData['created_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
                        $memberInfoData['updated_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
                    }else{
                        $memberInfoData['uid'] = $resultM->uid;
                        $memberInfoData['realname'] = $resultM->username;
                        $memberInfoData['display_name'] = 1;
                        $memberInfoData['sex'] = 1;
                        $memberInfoData['sex_cn'] = '男';
                        $memberInfoData['birthday'] = '1990';
                        $memberInfoData['card_t_cn'] = 307;
                        $memberInfoData['id_card'] = '1234567890';
                        $memberInfoData['residence'] = '11.129.0';
                        $memberInfoData['residence_cn'] = '浙江舟山';
                        $memberInfoData['education'] = 67;
                        $memberInfoData['education_cn'] = '中技';
                        $memberInfoData['experience'] = 74;
                        $memberInfoData['experience_cn'] = '无经验';
                        $memberInfoData['phone'] = $resultM->mobile;
                        $memberInfoData['email'] = $resultM->email;
                        $memberInfoData['householdaddress'] = '11.129.0';
                        $memberInfoData['householdaddress_cn'] = '浙江舟山';
                        $memberInfoData['created_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
                        $memberInfoData['updated_at'] = date('Y-m-d H:i:s', $resultM->reg_time);
                    }
                    if ($memberInfoData) {
                        MemberInfo::create($memberInfoData);
                    }
                }
            }
            $count++;
            $this->info('已完成'.$count.'个');
        }
    }

}