<?php
namespace model\import;
use \model;
use \model\check;

/**
 * 
 */
class tousu  extends model
{
	public $title = '投诉记录'; //固定
	public $import = null;    //固定
	public $rules = null;    //规则
	public $demoData = null;  //样例数据
	public $demoremark = null;  //样例说明
	
	public function __construct()
	{
		parent::__construct(); //执行父类
		$this->import = new \lib\import();
		$this->rules = [
            ['caption'=>lg('产品线')],
            ['caption'=>lg('品名')],
            ['key'=>'pt_p_id','caption'=>lg('内部编码'),'must'=>true,'formatCell'=>'p_idInnum'],
            ['key'=>'pt_xiangci','caption'=>lg('项次'),'must'=>true],
            ['key'=>'pt_yuanyin','caption'=>lg('原因'),'must'=>false],
            ['key'=>'pt_area','caption'=>lg('区域'),'must'=>false,'formatCell'=>'coll3'],
            ['key'=>'pt_time','caption'=>lg('时间'),'must'=>false,'type'=>'datetime'],
		];

		$this->demoData = [
		];

		$this->demoremark = '';
	}
	
	 /**处理导入
     * @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))
		{
			$state = !$this->import->checkRepeat([
			    ['pt_p_id', 'pt_xiangci']
		    ]);
		}
		//数据重复验证
		if($state && !empty($this->import->data))
		{
			$check = new check();
			$this->db->Begin();
			foreach($this->import->data as $k =>$dv)
			{	
				if($k > 0 && $k%1000 === 0) errorLog(__CLASS__.$this->title.':'.$k, 'import');
				$arr = [];
				$updateData = [];
				$add  = [];
				foreach($dv as $dvk=>$dvv)
				{
					if(stripos($dvk, 'pt_') === 0) 
					{
						$arr[$dvk] = $dvv;
					}
				}
				$exist = $check->checkExist('pro_tousu', $arr);
				$arr['opuser'] = getOpuser();
				//重复更新
				if(!empty($exist))
				{	
					$where = ['pt_id'=>$exist];
					$updateData = $arr;
					$updateData['update_time'] = getNowTime();
					$this->db->update('pro_tousu',$updateData,$where);
				}
				else
				{	
					$add = $arr;
					$add['create_time'] = getNowTime();
					$add['update_time'] = getNowTime();
					$this->db->insert('pro_tousu', $add);
				}
			}
			$this->db->End();
		}
        return $this->import->output(); //生成处理结果
	}
}