<?php
/**
 * @remark :
 * @name   :CountProject.php
 * @author :lyh
 * @method :post
 * @time   :2024/9/26 14:19
 */

namespace App\Console\Commands\Project;

use App\Helper\Common;
use App\Models\Domain\DomainInfo;
use App\Models\Product\Category;
use App\Models\Product\CategoryRelated;
use App\Models\Product\Detail;
use App\Models\Product\Product;
use App\Models\RouteMap\RouteMap;
use App\Services\ProjectServer;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class DownloadProject extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'downloads_products';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '导出项目数据';

    public function handle(){
        ProjectServer::useProject(1225);
        $data = $this->downloadProduct();
        DB::disconnect('custom_mysql');
        echo date('Y-m-d H:i:s') . 'end' . PHP_EOL;
        return $this->exportData($data);
    }

    public function downloadProduct()
    {
        $product = new Product();
        $filed = ['id', 'project_id', 'title' ,'thumb' , 'route' ,'intro','content',
            'category_id', 'status'];
        $this->order = 'sort';
        $lists = $product->list(['status'=>1],'id',$filed);
        if(!empty($lists)){
            $cate_data = $this->getCategoryList();//分类
            foreach ($lists as $k => $v){
                $v['url'] = 'https://www.autsikinta.com/' . getRouteMap(RouteMap::SOURCE_PRODUCT,$v['id']);
                $v['category_id_text'] = $this->categoryName($v['id'],$cate_data);
                //ToDo::处理图片及文件
                if(!empty($v['thumb']) && !empty($v['thumb']['url'])){
                    $v['images'] = getImageUrl($v['thumb']['url']);
                }else{
                    $v['images'] = '';
                }
                $lists[$k] = $v;
            }
        }
        echo date('Y-m-d H:i:s') . '数据详情$v:'. json_encode($lists) . PHP_EOL;
        return $lists;
    }
    public function categoryName($product_id,$data){
        $cateRelatedModel = new CategoryRelated();
        $category_id = $cateRelatedModel->where('product_id',$product_id)->pluck('cate_id')->toArray();
        $category_name = '';
        if(!empty($category_id) && !empty($data)){
            foreach ($category_id as $v){
                if(isset($data[$v])){
                    $category_name .= $data[$v].',';
                }
            }
            $category_name = trim($category_name,',');
        }
        return $category_name;
    }
    /**
     * @remark :获取所有分类
     * @name   :getCategoryList
     * @author :lyh
     * @method :post
     * @time   :2023/9/14 13:56
     */
    public function getCategoryList(){
        $data = Common::get_user_cache('product_category',1225);
        if(empty($data)){
            $categoryModel = new Category();
            $data = [];
            $cateList = $categoryModel->list(['project_id'=>1225],['id','title']);
            if(!empty($cateList)){
                foreach ($cateList as $value){
                    $data[$value['id']] = $value['title'];
                }
            }
            Common::set_user_cache($data,'product_category',1225);
        }
        return $data;
    }
    public function exportData($data){
        // 创建一个新的 Excel 电子表格实例
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        // 添加表头
        $sheet->setCellValue('A1', '产品名称');
        $sheet->setCellValue('B1', '产品短描述');
        $sheet->setCellValue('C1', '产品内容');
        $sheet->setCellValue('D1', '产品路由');
        $sheet->setCellValue('E1', '产品分类');
        $sheet->setCellValue('F1', '产品状态');
        $sheet->setCellValue('G1', '产品主图');
        $rowCount = 2;
        foreach ($data as $v) {
            $sheet->setCellValue('A' . $rowCount, $v['title']);
            $sheet->setCellValue('B' . $rowCount, $v['intro']);
            $sheet->setCellValue('C' . $rowCount, $v['content']);
            $sheet->setCellValue('D' . $rowCount, $v['url']);
            $sheet->setCellValue('E' . $rowCount, $v['category_id_text']);
            $sheet->setCellValue('F' . $rowCount, '发布中');
            $sheet->setCellValue('G' . $rowCount, $v['images']);
            $rowCount++;
        }
        // 创建一个新的 Excel Writer 对象
        $writer = new Xlsx($spreadsheet);
        $filename = time().'.xlsx';
        // 设置导出文件的保存路径和文件名
        $filePath = public_path('upload/excel/'.$filename);
        // 导出 Excel 文件
        $writer->save($filePath);
        echo date('Y-m-d H:i:s') . 'file_link:'.url('upload/excel/'.$filename) . PHP_EOL;
        // 返回导出文件的响应
        return ['file_link'=>url('upload/excel/'.$filename)];
    }
}