<?php
namespace admin\action;

class sysAction extends \action
{
	public function __construct()
    {
        ;
	}
    //保存Grid布局
    public function test()
    {
        $img = new \lib\image();
        $dir = \mvc::$cfg['dir']['cache'].'\\';
        $img->Watermark($dir.'src.png',$dir.'dest.png',$dir.'water.png','tile');
    }
	
    //保存Grid布局
    public function saveGridConfig($uuid,$jsonStr)
    {
		make(\model\sys::class)->saveGridConfig($uuid,$jsonStr);
		$this->successJson();
    }
	
    //获取Grid布局
    public function getGridConfig($uuid)
    {
		$data = make(\model\sys::class)->getGridConfig($uuid);
		$this->successJson(['json'=>$data]);
    }
	
    //重置Grid布局
    public function resetGridConfig($uuid)
    {
		make(\model\sys::class)->resetGridConfig($uuid);
		$this->successJson();
    }
	
	public function mysqlInfo(){
	    echo 'KILL:<form action="'.HOST.'/sys/mysqlInfo" method="post"><input type="text" name="killid"><button type="submit">Submit</button></form>';
        $rows = make(\model\sys::class)->mysqlInfo();
        dd($rows);
	}
	
	
    //检测是否有PNG图
	public function checkPNG(){
        make(\model\sys::class)->checkPNG();
	}
	
    //恢复文件
    public function recoveryFiles()
    {
        set_time_limit(\mvc::$cfg['upload']['time_limit']);
		ignore_user_abort(true);
		make(\model\sys::class)->recoveryFiles();
		$this->successJson();
    }

	//格式化品牌标签的关联表
	public function formatTagBrand()
	{
		make(\model\sys::class)->formatTagBrand();
		$this->successJson(['ok'=>1]);
	}
	
	//初始化零件库和商品库的品牌标签
	public function initTagBrandLink()
	{
		set_time_limit(0);
		make(\model\pro\pro::class)->initTagBrand([]);
		make(\model\oe::class)->initTagBrand([]);
		echo '初始化完成';
		//$this->successJson(['ok'=>1]);
	}

	//初始化零件库适用国家
	public function initCountryLink()
	{
		make(\model\oe::class)->initCountryLink([]);
		$this->successJson(['ok'=>1]);
	}
	
	//初始化历史数据
	public function initOldData()
	{
		$initOldData = new \model\initOldData();
		//基础表
		$res = $initOldData->initBase();
		dump($res);
	}
	
	//增加语言
	public function addLang(){
		$sqlArr = make(\model\sys::class)->formatLangField('al');
		echo  implode("<br>", $sqlArr);
	}
	
	
	/*
	* 初始化商品数据（含数据单）
	* cd /home/wwwroot/catalog_frey/pdc/admin
    * 命令 php index.php sys/initProByExcel?file=20250329141114.xlsx
	*/
	public function initProByExcel(){
		$req = \mvc::$req;
		$filename  = $req['file'];
		set_time_limit(0);
		set_time_limit(\mvc::$cfg['bigtable_memory_limit']);
		$file = \mvc::$cfg['dir']['files'].'/'.$filename;
		$res = make(\model\initOldData::class)->initProByExcel($file);
		dd($res);
	}

	//php index.php  sys/initProToDB
	public function initProToDB(){
		$req = \mvc::$req;
		set_time_limit(0);
		set_time_limit(\mvc::$cfg['bigtable_memory_limit']);
		$res = make(\model\initOldData::class)->initProToDB($req['count']);
		dd($res);
	}
	 
	//初始化图片 php index.php  sys/initProPic
	// public function initProPic()
	// {
	// 	$req = \mvc::$req;
	// 	set_time_limit(0);
	// 	//set_time_limit(\mvc::$cfg['bigtable_memory_limit']);
	// 	$res = make(\model\initOldData::class)->initProPic($req['count']);
	// 	dd($res);
	// }

	//初始化零件图到商品图 php index.php  sys/syncOePicToPro
	/*public function syncOePicToPro()
	{
		set_time_limit(0);
		set_time_limit(\mvc::$cfg['bigtable_memory_limit']);
		$res = make(\model\initOldData::class)->syncOePicToPro();
		dd($res);
	}*/

	// public function initCompanyPic()
	// {
	// 	$req = \mvc::$req;
	// 	set_time_limit(0);
	// 	//set_time_limit(\mvc::$cfg['bigtable_memory_limit']);
	// 	$res = make(\model\initOldData::class)->initCompanyPic($req['count']);
	// 	dd($res);
	// }
	
	//初始化OE的汽车品牌
	public function initOeNumBrand()
	{
		$res = make(\model\initOldData::class)->initOeNumBrand();
		dd($res);
	}

	//删除不存在的图片记录 php index.php  sys/clearNotExistsPic
	public function clearNotExistsPic()
	{
		$req = \mvc::$req;
		set_time_limit(0);
		$res = make(\model\initOldData::class)->clearNotExistsPic();
		dd($res);
	}

}