<?php
namespace model;
/**
 * Class user
 * @package model
 */
class sys extends \model
{
	public function __construct()
    {
		parent::__construct();
	}
	
	public function test(){
	    
	}
	

	public function mysqlInfo(){;
	    if(isset(\mvc::$req['killid']) && is_numeric(\mvc::$req['killid'])){
	        $this->db->query('KILL '.\mvc::$req['killid']);
            echo 'KILL '.\mvc::$req['killid']."<br>";
	    }
        $data=[];
        $st = $this->db->query('SHOW PROCESSLIST;');
        $rows = $st->fetchAll();
        foreach($rows as $k=>$row){
            $data[$k] = $row;
        }
        
        $st = $this->db->query('SHOW GLOBAL VARIABLES');
        $rows = $st->fetchAll();
        foreach($rows as $row){
            $data[$row['Variable_name']] = $row['Value'];
        }
        return $data;
	}
	
    //保存Grid布局
    public function saveGridConfig($uuid,$jsonStr)
    {
		return $this->db->replace('grid_cfg',['gc_config'=>$jsonStr,'gc_uuid'=>$uuid,'gc_user'=>getOpuser()],['gc_uuid','gc_user']);
    }
	
    //获取Grid布局
    public function getGridConfig($uuid)
    {
		$jsonStr = $this->db->get('grid_cfg','gc_config',['gc_uuid'=>$uuid,'gc_user'=>getOpuser()]);
		if(empty($jsonStr)){
    		$jsonStr = $this->db->get('grid_cfg','gc_config',['gc_uuid'=>$uuid,'gc_user'=>'grid']);
		}
		return $jsonStr;
    }
	
    //重置Grid布局
    public function resetGridConfig($uuid)
    {
		return $this->db->delete('grid_cfg',['gc_uuid'=>$uuid,'gc_user'=>getOpuser()]);
    }


	/*格式化品牌标签的关联表
	*/
	function formatTagBrand(){
		return [];
		//停用
		$tags = $this->db->select('tag_brand', '*');
		$this->db->Begin();
		foreach($tags as $tag){
			foreach(explode(',', $tag['tb_words']) as $word){
				if(!empty($word)){
					$sql = sprintf("INSERT INTO tag_brand_make (tbm_tb_id, tbm_mk_id) SELECT %d, mk_id FROM m_make WHERE 
					(mk_cn_name LIKE '%s' or mk_en_name LIKE '%s' or mk_py_name LIKE '%s') 
					AND mk_id NOT IN (
						SELECT tbm_mk_id FROM tag_brand_make WHERE tbm_tb_id = %d
					) GROUP BY mk_id", $tag['tb_id'], $word, $word, $word, $tag['tb_id']);
					$this->db->query($sql);
				}
			}

			foreach(explode(',', $tag['tb_words']) as $word){
				if(!empty($word)){
					$sql = sprintf("INSERT INTO tag_brand_cnbrand (tbm_tb_id, tbm_brand_id) SELECT %d, brand_id FROM m_cn_model WHERE brand_name LIKE '%s' AND brand_id NOT IN (
					SELECT tbm_brand_id FROM tag_brand_cnbrand WHERE tbm_tb_id = %d
					) GROUP BY brand_id", $tag['tb_id'], $word, $tag['tb_id']);
					$this->db->query($sql);
				}
			}
		}
		$this->db->end();
		return [];
	}

	//增加语言
	function formatLangField($lang){
		$lastcode = '';
		foreach(\mvc::$cfg['LANGS'] as $lk=>$lv){
			if($lang == $lk) break;
			$lastcode = $lk;
		}
		$new = \mvc::$cfg['LANGS'][$lang]; 
		$last = \mvc::$cfg['LANGS'][$lastcode]; 
		$sqlArr = [
			"ALTER TABLE `object` ADD COLUMN `{$new['field']}` VARCHAR (255)  DEFAULT ''  COMMENT '{$new['name']}' AFTER `{$last['field']}`;",
			
			"ALTER TABLE `oe_item` ADD COLUMN `oe_{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '产品{$new['name']}名' AFTER `oe_{$last['field']}`;",
			"ALTER TABLE `oe_item` ADD COLUMN `oe_model_{$new['field']}` VARCHAR (200)  DEFAULT ''  COMMENT '车型{$new['name']}名' AFTER `oe_model_{$last['field']}`;",
			"ALTER TABLE `oe_item` ADD COLUMN `oe_des_{$new['field']}` VARCHAR (200)  DEFAULT ''  COMMENT '描述{$new['name']}名' AFTER `oe_des_{$last['field']}`;",
			
			"ALTER TABLE `part_param` ADD COLUMN `{$new['field']}` VARCHAR (50)  DEFAULT ''  COMMENT '{$new['name']}名' AFTER `{$last['field']}`;",
			"ALTER TABLE `part_param_sche` ADD COLUMN `{$new['field']}` VARCHAR (50)  DEFAULT ''  COMMENT '{$new['name']}' AFTER `{$last['field']}`;",

			"ALTER TABLE `pro` ADD COLUMN `p_{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '产品{$new['name']}名' AFTER `p_{$last['field']}`;",
			"ALTER TABLE `pro` ADD COLUMN `p_model_{$new['field']}` VARCHAR (200)  DEFAULT ''  COMMENT '车型{$new['name']}名' AFTER `p_model_{$last['field']}`;",
			"ALTER TABLE `pro` ADD COLUMN `p_des_{$new['field']}` VARCHAR (200)  DEFAULT ''  COMMENT '描述{$new['name']}名' AFTER `p_des_{$last['field']}`;",

			"ALTER TABLE `pro_brand` ADD COLUMN `pb_{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT 'SKU品牌{$new['name']}名' AFTER `pb_{$last['field']}`;",
			"ALTER TABLE `pro_cate` ADD COLUMN `{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '{$new['name']}小类' AFTER `{$last['field']}`;",
			"ALTER TABLE `pro_param_strenval` ADD COLUMN `ppsl_{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '翻译{$new['name']}' AFTER `ppsl_{$last['field']}`;",
			"ALTER TABLE `tag_brand` ADD COLUMN `tb_{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '汽车品牌{$new['name']}' AFTER `tb_{$last['field']}`;",
			"ALTER TABLE `tags` ADD COLUMN `{$new['field']}` VARCHAR (100)  DEFAULT ''  COMMENT '标签{$new['name']}' AFTER `{$last['field']}`;",
			
			"ALTER TABLE `cd_make` ADD COLUMN `cm_{$new['field']}` VARCHAR (250)  DEFAULT ''  COMMENT '{$new['name']}' AFTER `cm_{$last['field']}`;",
		];
		return $sqlArr;
	}
}