<?php
/**
 * Created by PhpStorm.
 * User: TangKe
 * Date: 2019/6/9
 * Time: 10:17
 */

namespace App\Console\Commands\Transfer;
use App\Models\Feature;
use App\Models\FeatureSort;
use App\Models\Innovator;
use App\Models\InnovatorCategory;
use App\Models\Policy;
use App\Models\PolicyCategory;
use App\Models\PolicyProperty;
use App\Models\Treat;
use App\Transfer\CompanyProfile;
use Illuminate\Console\Command;
use App\Transfer\Ad;
use App\Transfer\AdCategory;
use App\Models\SubsiteAd;
use App\Models\Ad as newAd;
use App\Models\AdCategory as newAdCate;

class CZRTransfer extends Command
{
    protected $signature = 'aix:transfer-crz';

    protected $description = 'add the transfer-crz data';

    /**
     * ArticleCommand constructor.
     */
    public function __construct()
    {
        parent::__construct();
    }


    public function handle() {
//        qs_policy_category    政策分类
//        qs_policy_property    政策层级
//        qs_aix_treat              待遇
//        qs_policy                 政策
//        qs_innovator_category    创业帮手分类
//        qs_innovator                   创业帮手
//        qs_feature               人才展示
//        qs_feature_sort        人才排序
        //强制删除相关数据
        PolicyCategory::truncate();
        PolicyProperty::truncate();
        Treat::truncate();
        Policy::truncate();
        InnovatorCategory::truncate();
        Innovator::truncate();
        Feature::truncate();
        FeatureSort::truncate();
//--------------------------------------------------------------------------------------------------------------------------------------------------------
        $this->info("开始转移 政策分类 数据...");
        $total = \App\Transfer\PolicyCategory::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\PolicyCategory::chunk(10, function ($categorys) use ($bar) {
            $categorysData = [];
            foreach ($categorys as $key => $val) {
                $categorysData[$key]['id'] = $val->id;
                $categorysData[$key]['parent_id'] = $val->parentid;
                $categorysData[$key]['categoryname'] = $val->categoryname;
                $categorysData[$key]['category_order'] = $val->category_order;
                $categorysData[$key]['title'] = $val->title;
                $categorysData[$key]['description'] = $val->description;
                $categorysData[$key]['keywords'] = $val->keywords;
                $categorysData[$key]['admin_set'] = $val->admin_set;
                $categorysData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $categorysData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($categorysData) {
                PolicyCategory::insert($categorysData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移 政策分类 数据成功.");

 //----------------------------------------------------------------------------------------------------------------------------------------------
        $this->info("开始转移 政策层次 数据...");
        $total = \App\Transfer\PolicyProperty::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\PolicyProperty::chunk(10, function ($propertys) use ($bar) {
            $propertysData = [];
            foreach ($propertys as $key => $val) {
                $propertysData[$key]['id'] = $val->id;
                $propertysData[$key]['categoryname'] = $val->categoryname;
                $propertysData[$key]['category_order'] = $val->category_order;
                $propertysData[$key]['admin_set'] = $val->admin_set;
                $propertysData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $propertysData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($propertysData) {
                PolicyProperty::insert($propertysData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移 政策层次 数据成功.");

//-------------------------------------------------------------------------------------------------------------------------------------------------
        $this->info("开始转移  待遇 数据...");
        $total = \App\Transfer\Treat::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\Treat::chunk(10, function ($treats) use ($bar) {
            $treatsData = [];
            foreach ($treats as $key => $val) {
                $treatsData[$key]['id'] = $val->id;
                $treatsData[$key]['property_id'] = $val->property_id;
                $treatsData[$key]['c_id'] = $val->c_id;
                $treatsData[$key]['title'] = $val->title;
                $treatsData[$key]['pic'] = $val->pic;
                $treatsData[$key]['intro'] = $val->intro;
                $treatsData[$key]['content'] = htmlspecialchars_decode($val->content);
                $treatsData[$key]['sort'] = $val->sort;
                $treatsData[$key]['addtime'] = $val->addtime;
                $treatsData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $treatsData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($treatsData) {
                Treat::insert($treatsData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移  待遇 数据成功.");


//-------------------------------------------------------------------------------------------------------------------------------------------------


        $this->info("开始转移  政策 数据...");
        $total = \App\Transfer\Policy::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\Policy::chunk(10, function ($policys) use ($bar) {
            $policysData = [];
            foreach ($policys as $key => $val) {
                $is_url = $val->is_url;
                if ($val->is_url == 'http://') {
                    $is_url = '';
                }
                $policysData[$key]['id'] = $val->id;
                $policysData[$key]['type_id'] = $val->type_id;
                $policysData[$key]['parentid'] = $val->parentid;
                $policysData[$key]['title'] = $val->title;
                $content = htmlspecialchars_decode($val->content);
                $match_str = '/data/upload';
                if (strpos($content, $match_str) >= 0) {
                    $content = str_replace($match_str, '/storage/old', $content);
                }
                $policysData[$key]['content']=$content;
                $policysData[$key]['tit_color'] = $val->tit_color ?  $val->tit_color : '#000000';
                $policysData[$key]['tit_b'] = $val->tit_b;
                $policysData[$key]['small_img'] =!empty( $val->Small_img) ? 'old/images/' .  $val->Small_img : '';
                $policysData[$key]['author'] = $val->author;
                $policysData[$key]['source'] = $val->source;
                $policysData[$key]['focos'] = $val->focos;
                $policysData[$key]['is_display'] = $val->is_display;
                $policysData[$key]['is_url'] = $is_url;
                $policysData[$key]['seo_keywords'] = $val->seo_keywords;
                $policysData[$key]['seo_description'] = $val->seo_description;
                $policysData[$key]['click'] = $val->click;
                $policysData[$key]['addtime'] = $val->addtime;
                $policysData[$key]['article_order'] = $val->article_order;
                $policysData[$key]['level_id'] = $val->level_id;
                $policysData[$key]['level_name'] = $val->level_name;
                $policysData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $policysData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($policysData) {
                Policy::insert($policysData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移  政策 数据成功.");


//-------------------------------------------------------------------------------------------------------------------------------------------------

        $this->info("开始转移 创业帮手分类 数据...");
        $total = \App\Transfer\InnovatorCategory::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\InnovatorCategory::chunk(10, function ($innovatorCategorys) use ($bar) {
            $innovatorCategorysData = [];
            foreach ($innovatorCategorys as $key => $val) {
                $innovatorCategorysData[$key]['id'] = $val->id;
                $innovatorCategorysData[$key]['parentid'] = $val->parentid;
                $innovatorCategorysData[$key]['categoryname'] = $val->categoryname;
                $innovatorCategorysData[$key]['category_order'] = $val->category_order;
                $innovatorCategorysData[$key]['title'] = $val->title;
                $innovatorCategorysData[$key]['description'] = $val->description;
                $innovatorCategorysData[$key]['keywords'] = $val->keywords;
                $innovatorCategorysData[$key]['admin_set'] = $val->admin_set;
                $innovatorCategorysData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $innovatorCategorysData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($innovatorCategorysData) {
                InnovatorCategory::insert($innovatorCategorysData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移 创业帮手分类 数据成功.");

//-------------------------------------------------------------------------------------------------------------------------------------------------


        $this->info("开始转移  创业帮手 数据...");
        $total = \App\Transfer\Innovator::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\Innovator::chunk(10, function ($innovators) use ($bar) {
            $innovatorsData = [];
            foreach ($innovators as $key => $val) {
                $is_url = $val->is_url;
                if ($val->is_url == 'http://') {
                    $is_url = '';
                }
                $innovatorsData[$key]['id'] = $val->id;
                $innovatorsData[$key]['parentid'] = $val->parentid;
                $innovatorsData[$key]['type_id'] = $val->type_id;
                $innovatorsData[$key]['type_name'] = $val->type_name;
                $innovatorsData[$key]['name'] = $val->name;
                $innovatorsData[$key]['photo_img'] = !empty($val->photo_img) ? 'old/innovator/' . $val->photo_img : '' ;
                $innovatorsData[$key]['company_name'] = $val->company_name;
                $innovatorsData[$key]['duty_name'] = $val->duty_name;
                $innovatorsData[$key]['trade_id'] = $val->trade_id;
                $innovatorsData[$key]['trade_cn'] = $val->trade_cn;
                $innovatorsData[$key]['points'] = $val->points;
                $innovatorsData[$key]['points'] = $val->points;
                $innovatorsData[$key]['content'] = htmlspecialchars_decode($val->content);
                $innovatorsData[$key]['display_order'] = $val->display_order;
                $innovatorsData[$key]['mobile'] = $val->mobile;
                $innovatorsData[$key]['mobile_display'] = $val->mobile_display;
                $innovatorsData[$key]['email'] = $val->email;
                $innovatorsData[$key]['email_display'] = $val->email_display;
                $innovatorsData[$key]['is_display'] = $val->is_display;
                $innovatorsData[$key]['is_url'] = $is_url;
                $innovatorsData[$key]['addtime'] = $val->addtime;
                $innovatorsData[$key]['keywords'] = $val->keywords;
                $innovatorsData[$key]['description'] = $val->description;
                $innovatorsData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $innovatorsData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($innovatorsData) {
                Innovator::insert($innovatorsData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移  创业帮手 数据成功.");


//-------------------------------------------------------------------------------------------------------------------------------------------------

        $this->info("开始转移 人才排序 数据...");
        $total = \App\Transfer\FeatureSort::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\FeatureSort::chunk(10, function ($featureSorts) use ($bar) {
            $featureSortsData = [];
            foreach ($featureSorts as $key => $val) {
                $featureSortsData[$key]['id'] = $val->id;
                $featureSortsData[$key]['parent_id'] = $val->parentid;
                $featureSortsData[$key]['categoryname'] = $val->categoryname;
                $featureSortsData[$key]['category_order'] = $val->category_order;
                $featureSortsData[$key]['title'] = $val->title;
                $featureSortsData[$key]['description'] = $val->description;
                $featureSortsData[$key]['keywords'] = $val->keywords;
                $featureSortsData[$key]['admin_set'] = $val->admin_set;
                $featureSortsData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $featureSortsData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($featureSortsData) {
                FeatureSort::insert($featureSortsData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移 人才排序 数据成功.");

//-------------------------------------------------------------------------------------------------------------------------------------------------


        $this->info("开始转移  人才展示 数据...");
        $total = \App\Transfer\Feature::count();
        $bar=$this->output->createProgressBar($total);
        \App\Transfer\Feature::chunk(10, function ($features) use ($bar) {
            $featuresData = [];
            foreach ($features as $key => $val) {
                $is_url = $val->is_url;
                if ($val->is_url == 'http://') {
                    $is_url = '';
                }
                $featuresData[$key]['id'] = $val->id;
                $featuresData[$key]['parentid'] = $val->parentid;
                $featuresData[$key]['name'] = $val->name;
                $featuresData[$key]['district'] = $val->district;
                $featuresData[$key]['personal'] = $val->personal;

                $content = htmlspecialchars_decode($val->content);
                $match_str = '/data/upload';
                if (strpos($content, $match_str) >= 0) {
                    $content = str_replace($match_str, '/storage/old', $content);
                }
                $featuresData[$key]['content']=$content;

                $featuresData[$key]['title'] = $val->title;
                $featuresData[$key]['photo'] = !empty($val->photo) ? 'old/photo/' . $val->photo : '' ;
                $featuresData[$key]['occupation'] = $val->occupation;
                $featuresData[$key]['summary'] = $val->summary;
                $featuresData[$key]['addtime'] = $val->addtime;
                $featuresData[$key]['read'] = $val->read;
                $featuresData[$key]['is_url'] = $is_url;
                $featuresData[$key]['is_display'] = $val->is_display;
                $featuresData[$key]['seo_keywords'] = $val->seo_keywords;
                $featuresData[$key]['seo_description'] = $val->seo_description;
                $featuresData[$key]['article_order'] = $val->article_order;
                $featuresData[$key]['type_id'] =$val-> type_id;
                $featuresData[$key]['rc_show'] = $val->rc_show;
                $featuresData[$key]['created_at'] = date('Y-m-d H:i:s', time());
                $featuresData[$key]['updated_at'] = date('Y-m-d H:i:s', time());
            }
            if ($featuresData) {
                Feature::insert($featuresData);
            }
            $bar->advance(10);
        });
        $bar->finish();
        $this->line("  完成!");
        $this->info("转移  人才展示 数据成功.");


    }
}