<?php 
namespace model\import;

use model\smart\preview;
use model\smart\smart;
/**
 * 
 */
class report  extends smart
{
	 /**
     * 标题 (用于消息提醒)
     */
	public $title = '自定义型号清单'; //固定
	public $import = null;    //固定
	public $rules = null;    //规则
	public $demoData = null;  //样例数据
	public $demoremark = null;  //样例说明
	private $dataUpdate='';
	private $dataTitle = '';
	public function __construct()
	{
		parent::__construct(); //执行父类
		$this->import = new \lib\import();
		$this->rules = [
			['key' => 'smt_report_pid', 'caption' => lg('GSP型号'), 'formatCell' => 'pc_id', 'must' => true],
			['key' => 'smt_report_cid', 'caption' => lg('客户名称'), 'formatCell' => 'getCid'],
			['key' => 'smt_report_area', 'caption' => lg('区域'), 'formatCell' => 'getArea','must' => true],
		];

		$this->demoData = [
			
		];

		$this->demoremark = '';
        $this->dataUpdate = strtotime(urldecode(\mvc::$req['time']));
		if(empty($this->dataUpdate) && !empty(\mvc::$req['params'])){
            $params =json_decode(\mvc::$req['params'],true);
            $this->dataUpdate =strtotime(urldecode($params['time']));
        }
		//标题
		$this->dataTitle = urldecode(\mvc::$req['title']);
		if (empty($this->dataTitle) && !empty(\mvc::$req['params'])) {
			$params = json_decode(\mvc::$req['params'], true);
			$this->dataTitle = urldecode($params['title']);
		}
	}
	


	/**处理导入
     * @param array|string $src 数组或者文件名
     * @param isInit 是否是初始化
     * @return 可返回任意值(string|array|bool)，都会到前端
     */
    public function import($src,$isInit=false) //固定
    {
		$state = $this->import->execute($src, $this->rules);
		
		//数据重复验证 - 自己
		if($state && !empty($this->import->data))
		{
			
		}
		
		//数据重复验证
		if($state && !empty($this->import->data))
		{
			
		}
		//入库
		if($state && !empty($this->import->data))
		{
			$this->db->Begin();
			if(!$this->dataTitle){
			    return;
			}
			$sr_id = $this->db->get('smt_rules','sr_id',['sr_title'=>$this->dataTitle]);
			if(!$sr_id){
				 $this->db->insert('smt_rules',[
					'sr_title' => $this->dataTitle,    
					'opuser' => getOpUser(),
					'sr_cols'=>json_encode(["smt_report_id","pro_rule","NewSAPCode","AccountNumber","Name","smt_p_state_main","pro_bigcate","pro_cate","smt_p_outnum","smt_p_innum","smt_ctime","modelText","smt_year_from","pro_sales_qty","pro_vio","total_quantity_vehicles","opuser","update_time"])
				]);
				$sr_id = $sclh_id = $this->db->id();
			}
			
            $preview = new preview();
			$areaData = array_column($this->import->data,'smt_report_area');
			$areaArr = [];
			foreach ($areaData as  $val) {
				$areaArr = array_merge($val,$areaArr);
			}
			$areaArr = array_unique($areaArr);
			foreach ($areaArr as $value) {
				$areaDataArr[$value] = $preview->newVer();
			}
			foreach($this->import->data as $k=>$mv)
			{
				$set = [
					'smt_report_pid'=>$mv['smt_report_pid'],
					'smt_report_time'=>$this->dataUpdate?date('Y-m-d H:i:s',$this->dataUpdate):getNowTime(),
					'smt_report_user'=>getOpUser(),
					'smt_report_sr_id'=>$sr_id
				];
				if(is_array($mv['smt_report_area']))
				{
					if(is_array($mv['smt_report_cid']))
					{
						foreach ($mv['smt_report_area'] as $area) {
							
							foreach ($mv['smt_report_cid'] as $cid) {
								$set['smt_report_area'] = $area;
								$set['smt_report_ver'] = $areaDataArr[$area];
								$set['smt_report_cid'] = $cid;
								$this->db->insert('smt_report', $set);
							}
							
						}
					}

					
				}
			}
			$this->db->End();
		}
        return $this->import->output(); //生成处理结果
	}

}