<?php
namespace model\import;
use \model;
use \model\check;
use model\pro\pro;

/**
 * 
 */
class prosupplier  extends model
{
	public $title = '供应商参数'; //固定
	public $import = null;    //固定
	public $rules = null;    //规则
	public $demoData = null;  //样例数据
	public $demoremark = null;  //样例说明

	public $pid = null;
	
	public function __construct()
	{
		parent::__construct(); //执行父类
		$this->import = new \lib\import();
		$this->rules = [
            ['key'=>'psu_sup_id','caption'=>lg('供应商编码'),'must'=>true],
            ['key'=>'psu_gczbq','caption'=>lg('工厂质保期')],
            ['key'=>'psu_gckz','caption'=>lg('是否工厂刻字')],
            ['key'=>'psu_zjm','caption'=>lg('助记码')],
            ['key'=>'psu_zjm_bx','caption'=>lg('助记码(备选)')],

            ['key'=>'psu_jhjq','caption'=>lg('计划交期(天)')],
            ['key'=>'psu_kpmc1','caption'=>lg('开票名称1')],
            ['key'=>'psu_kpmc2','caption'=>lg('开票名称2')],
            ['key'=>'psu_gdhyd','caption'=>lg('固定货源地')],
            ['key'=>'psu_hsbm','caption'=>lg('HS编码')],
            ['key'=>'psu_ktsl','caption'=>lg('可退税率')],
            ['key'=>'psu_bgdw','caption'=>lg('报关单位'),'formatCell'=>'coll2'],
            ['key'=>'psu_tz','caption'=>lg('图纸')],
		];
		$temp =[['key'=>'psu_p_id','caption'=>lg('物料编码'),'must'=>true,'formatCell'=>[\model\pro\pro::class,[],'getPidByNumber',['@'],null]],];

		$this->pid = \mvc::$req['p_id'];
		if(empty($this->pid) && !empty(\mvc::$req['params'])){
			$params =json_decode(\mvc::$req['params'],true);
			$this->pid =$params['p_id'];
		}
		if(!$this->pid){
			array_unshift($this->rules,$temp);
		}

		$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([
			  ['psu_p_id','psu_sup_id']
		    ]);
		}
		
		//数据重复验证
		if($state && !empty($this->import->data))
		{
			$check = new check();
			
			foreach($this->import->data as &$dv)
			{       
                if(!$dv['psu_gckz']||$dv['psu_gckz']=='无刻字'||$dv['psu_gckz']=='N'){
                    $dv['psu_gckz'] = 0; 
                }else{
                    $dv['psu_gckz'] = 1; 
                }
                $supplier = $this->db->get('supplier','sup_id',['sup_code'=>$dv['psu_sup_id']]);
                if(empty($supplier)){
                    $state = false;
					$dv['excelInfo']['error'] = '供应商不存在，请核实编码是否正确';
					$this->import->lineNum = $dv['excelInfo']['line'];
					$this->import->lastError = $dv['excelInfo']['error'];
					continue;  
                }else{
                    $dv['psu_sup_id'] = $supplier;
                }

				if($this->pid && !$dv['psu_p_id']){
					$dv['psu_p_id'] = $this->pid;	
				}

				$exist = $check->checkExist('pro_supplier', $dv);
				if(!empty($exist))
				{
					$state = false;
					$dv['excelInfo']['error'] = '记录已存在';
					$this->import->lineNum = $dv['excelInfo']['line'];
					$this->import->lastError = $dv['excelInfo']['error'];
					continue;
				}
			}
			
		}
		//入库
		if($state && !empty($this->import->data))
		{	
			$opuser = getOpuser();
			$datetime = getNowTime();

			$this->db->Begin();
			foreach($this->import->data as $k=>$mv)
			{
				if($k > 0 && $k%1000 === 0) errorLog(__CLASS__.$this->title.':'.$k, 'import');
				$add = [
					'psu_opuser'=>$opuser,
					'psu_create_time'=>$datetime,
					'psu_update_time'=>$datetime
				];
				foreach($mv as $mtk=>$mtv)
				{
					if(stripos($mtk, 'psu_') === 0) 
					{
						$add[$mtk] = $mtv;
					}
				}
				
				$this->db->insert('pro_supplier', $add);
			}
			$this->db->End();
		}
        return $this->import->output(); //生成处理结果
	}
}