erp/core/CoreApp/controllers/Beihuogl.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Beihuogl extends Start_Controller {
	public function __construct(){
		parent::__construct();
        $this->load->library('session');
        $this->load->_model('Model_bhsq','bhsq');
        $this->load->_model("Model_shop","shop");
        $this->load->_model("Model_typeclass","typeclass");
        $this->load->_model("Model_bhccwl","bhccwl");
        $this->load->_model("Model_logic_u9tools","logic_u9tools");
        $this->load->_model("Model_whlabel","whlabel");
        $this->load->_model("Model_goods","goods");
        $this->load->_model("Model_settingtest","settingtest");
        $this->load->_model("Model_bhdcd","bhdcd");
        $this->load->_model("Model_whlabellabel","whlabellabel");
        $this->load->_model("Model_warehouse","warehouse");
    }

    //定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
        if(!isset($_SESSION['api'])){
            header('Location: /');exit;
        }

		if($arg == 'dyapply')//
        {
             $this->_dyapply();
        }
        elseif($arg == 'dyapplyadd')//
        {
            $this->_dyapplyadd();
        }
        elseif($arg == 'dyapplyedit')//
        {
            $this->_dyapplyedit($arg_array);
        }
        elseif($arg == 'dyapplygxzt')//
        {
            $this->_dyapplygxzt();
        }
        elseif($arg == 'dyapplyexcel'){
            $this->_dyapplyexcel();
        }
        elseif($arg == 'ccwlshlist'){
            $this->_ccwlshlist();
        }
        elseif($arg == 'ccwlbhindex'){
            $this->_ccwlbhindex();
        }elseif($arg == 'dyapplysave'){
            $this->_dyapplysave();
        }elseif($arg == 'ccwlbhmake'){
            $this->_ccwlbhmake();
        }elseif($arg == 'ccwlbhedit'){
            $this->_ccwlbhedit($arg_array);
        }elseif($arg == 'ccwleditxzbh'){
            $this->_ccwleditxzbh();
        }elseif($arg == 'ccwlbhsavexzbh'){
            $this->_ccwlbhsavexzbh();
        }elseif($arg == 'ccwldelitem'){
            $this->_ccwldelitem();
        }elseif($arg == 'ccwlbhsave'){
            $this->_ccwlbhsave();
        }elseif($arg == 'ccwlbhzhcheck'){
            $this->_ccwlbhzhcheck();
        }elseif($arg == 'ckbhindex'){
            $this->_ckbhindex();
        }elseif($arg == 'ckbhedit'){
            $this->_ckbhedit($arg_array);
        }elseif($arg == 'makeu9scd'){
            $this->_makeu9scd($arg_array);
        }elseif($arg == 'showckbh'){
            $this->_showckbh($arg_array);
        }elseif($arg == 'ddscscd'){
            $this->_ddscscd();
        }elseif($arg == 'ckdcd'){
            $this->_ckdcd();
        }elseif($arg == 'ckbherprk'){
            $this->_ckbherprk($arg_array);
        }elseif($arg == 'bhdcdsave'){
            $this->_bhdcdsave();
        }elseif($arg == 'u9scdexcel')
        {
            $this->_u9scdexcel($arg_array);
        }elseif($arg == 'ccwlskucheck'){
            $this->_ccwlskucheck();
        }elseif($arg == 'printlabel'){
            $this->_printlabel();
        }elseif($arg == 'deldyapply'){
            $this->_deldyapply();
        }elseif($arg == 'dcdjzrk'){
            $this->_dcdjzrk();
        }elseif($arg == 'dyapplyyjsh'){
            $this->_dyapplyyjsh();
        }elseif($arg == 'ccwlbhdownload'){
            $this->_ccwlbhdownload();
        }elseif($arg == 'ckexcel'){
           $this->_ckexcel($arg_array);
        }elseif($arg == 'checkdcdsku'){
            $this->_checkdcdsku($arg_array);
        }elseif($arg == 'dcdkwyz'){
            $this->_dcdkwyz();
        }
		else
		{
			 $this->_index();
		}
    }
    
    private function _index(){
        exit('No direct script access allowed 1');
    }
    //备货申请单的列表
    private function _dyapply(){
        if($this->input->method() === 'post'){
            $vip_id = $this->input->post('vip_id',true);
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
            $sqr = $this->input->post('sqr',true);
            $sqr = trim($sqr);
            $sq_status = $this->input->post('sq_status',true);
            $shop_id = $this->input->post('shop_id',true);
            $plat_id = $this->input->post('plat_id',true);
            $shop_ids = $this->input->post('shop_ids',true);
            $ktime = $this->input->post('ktime',true);
            $jtime = $this->input->post('jtime',true);
            $ktime = strtotime($ktime);
            $jtime = strtotime($jtime);

            $where = "add_time >= ".$ktime."  and add_time  < ".$jtime." ";

            if(!empty($sqr)){
                $where .= " and sqr = '".$sqr."' ";
            }
            if($shop_id > -1){
                $where .= " and shop_id = ".$shop_id." ";
            }else{
                if($vip_id == 1){

                }else{
                    $where .= " and shop_id in (".$shop_ids.") ";
                }
                
            }
            if($sq_status > -1){
               $where .= " and sq_status = ".$sq_status." ";
            }
            
            if($plat_id > -1){
               $where .= " and plat_id = ".$plat_id." ";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $list = $this->bhsq->find_all($where,"id,shop_id,plat_id,title,sku,sqr,sq_num,sq_status,add_time,update_time",$order_str,$start,$perpage);

            if(empty($list)){
                $rows = array('total'=>0,'over'=>1,'pagenum'=>0,'rows'=>([]));
                echo json_encode($rows);exit;
            }
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            $plat_list = $this->typeclass->find_all("classid = 32","id,title");
            $plat_list = array_column($plat_list,'title','id');
            $status_list = $this->bhsq->getSqStatus();
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"无";
                $list[$k]['plat_id'] = isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"无";
                $list[$k]['sq_status'] = isset($status_list[$v['sq_status']])?$status_list[$v['sq_status']]:"";
                $list[$k]['add_time'] = date("Y-m-d",$v['add_time']);
                $str = "";
                if($v['sq_status'] == 1 || $v['sq_status'] == 3){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)'class='window' data-h='/beihuogl/dyapplyedit/".$v['id']."' data-t='修改' style='margin-right:4px;color: #fff;background-color:#228B22;padding:4px 10px;border-radius:5px;font-size:15px'>编辑</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#4169E1;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='2' onclick='update_status(this)'>发布</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #444;background-color: #ddd;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='0' onclick='update_status(this)'>取消</a>";
                    $str .=  "</div>";

                }
                if($v['sq_status'] == 0){
                   $str .=  "<div style='text-align:center;'>";
                   $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color: #DC143C;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='0' onclick='del_bhsq(this)'>删除</a>";
                   $str .=  "</div>";
                }
                $list[$k]['update_time'] = $str;
            }


            $total = $this->bhsq->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
            $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($list));
		    echo json_encode($rows);exit;

        
        
        }else{
            $user = $this->user->get_api($_SESSION['api']);
            $usersp = explode('|',trim($user['shop'],'|'));
            $this->data['usersp'] = implode(",",$usersp);
            $vip_id = 0;
            if(in_array($user['id'],[10,28])){
                $vip_id = 1;
            }
            $status_list = $this->bhsq->getSqStatus();
            $this->data['status_list'] = $status_list;
            $this->data['vip_id'] = $vip_id;
            $this->_Template('beihuogl_dyapply',$this->data);
        }
    }
    //备货申请单的添加
    private function _dyapplyadd(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            $time = strtotime(date("Y-m-d"),time());
            $info = $this->bhsq->find("real_time >= ".$time,"*",'id desc');
            if(empty($info)){
                $num = 1;
            }else{
                $arr = explode('-',$info['sb_no']);
                $num = (int)$arr[2]+1;
            }
            $num = str_pad($num, 3, '0', STR_PAD_LEFT);
            $sb_no = "SQ-".date("ymd")."-".$num;
            $insert_arr = [];

            $time = time();
            foreach($data['title'] as $k=>$v){
                $insert_arr[] = [
                    'sb_no'=>$sb_no,
                    'sku'=>$data['sku'][$k],
                    'title'=>$data['title'][$k],
                    'shop_id'=>$data['shop_id'],
                    'plat_id'=>$data['plat_id'],
                    'sqr'=>$data['sqr'],
                    'sq_num'=>$data['sq_num'][$k],
                    'ccwl_num'=>$data['sq_num'][$k],
                    'ck_num'=>$data['sq_num'][$k],
                    'sq_status'=>1,
                    'remark'=>$data['remark'],
                    'add_time'=>$time,
                    'real_time'=>$time,
                    'update_time'=>$time,
                ];
            }
            $r =$this->db->insert_batch('bhsq',$insert_arr);
            if($r){
                echo json_encode(['code'=>1,'msg'=>'添加成功']);
            }else{
                echo json_encode(['code'=>-1,'msg'=>'添加失败']);
            }
            exit;

        }else{
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $this->data['plat_list'] = $plat_list;
            $this->_Template('beihuogl_dyapplyadd',$this->data);
        }
    }
    //备货申请单的 修改
    private function _dyapplyedit($arg_array){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            $id = $data['id'];
            $update_arr = [
                'shop_id'=>$data['shop_id'],
                'plat_id'=>$data['plat_id'],
                'sqr'=>$data['sqr'],
                'sq_num'=>$data['sq_num'],
                'ccwl_num'=>$data['sq_num'],
                'ck_num'=>$data['sq_num'],
                'sku'=>$data['sku'],
                'remark'=>$data['remark'],
            ];
            $r = $this->bhsq->save($update_arr,$id);
            if($r){
                echo json_encode(['msg'=>'添加成功','success'=>true]);
            }else{
                echo json_encode(['msg'=>'添加失败','success'=>false]);
            }
            exit;
        }else{
            $id = $arg_array[0];
            $info = $this->bhsq->find("id = ".$id);
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $this->data['plat_list'] = $plat_list;
            $this->data['info'] = $info;
            $this->_Template('beihuogl_dyapplyedit',$this->data);
        }
    }
    //备货申请单的 状态申请 如 发布 或者取消
    private function _dyapplygxzt(){
        if($this->input->method() === 'post'){
           $data = $this->input->post();
           $id = (int)$data['id'];
           $type = (int)$data['status'];
           $update_arr = [];
           $update_arr['sq_status'] = $type;
           if($type == 2){
                $update_arr['public_time'] = time();
           }
           if($type == 3){
                $update_arr['ccwl_status'] = 0;
                $update_arr['ck_status'] = 0;
                $update_arr['features'] = '';
                $update_arr['jm'] = '';
                $update_arr['public_time']  = 0;
                $update_arr['erp_zh'] = '';
                $update_arr['bh_no'] = '';
                $update_arr['u9sc_no'] = '';
           }
           $r = $this->bhsq->save($update_arr,$id);
            if($r){
                echo json_encode(['msg'=>'修改成功','success'=>true]);
            }else{
                echo json_encode(['msg'=>'修改失败','success'=>false]);
            }
            exit;
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
        }
    }
    private function _deldyapply(){
        if($this->input->method() === 'post'){
          $data = $this->input->post();
          $id = $data['id'];
          $info = $this->bhsq->read($id);
          if($info['sq_status'] != 0){
            echo json_encode(['msg'=>'此条记录不符合删除条件','success'=>false]);
            exit;
          }
          $r = $this->bhsq->remove($id);
          if($r){
              echo json_encode(['msg'=>'删除成功','success'=>true]);
          }else{
              echo json_encode(['msg'=>'删除失败','success'=>false]);
          }
          exit;
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
        }
    }
    //备货申请单的 
    private function _dyapplysave(){
        if($this->input->method() === 'post'){
           $data = $this->input->post();
           $id = (int)$data['id'];
           $val = $this->input->post('val',true);
           $column = $data['column'];
           if($column == 'ccwl_num'){
             $update_arr = [
                'ccwl_num'=>(int)$val,
                'ck_num'=>(int)$val,
             ];
           }elseif($column == 'sku'){
            $update_arr = [
                'sku'=>$val,
            ];
           }elseif($column == 'ck_num'){
            $update_arr = [
                'ck_num'=>(int)$val,
            ];
           }elseif($column == 'drck'){
            $update_arr = [
                'drck'=>(int)$val,
            ];
           }else{
                echo json_encode(['msg'=>'修改信息不合规','success'=>false]);
                exit;
           }
           $r = $this->bhsq->save($update_arr,$id);
            if($r){
                echo json_encode(['msg'=>'修改成功','success'=>true]);
            }else{
                echo json_encode(['msg'=>'修改失败','success'=>false]);
            }
            exit;
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
        }
    }

    private function _dyapplyexcel(){
        if($this->input->method() === 'post'){
            $data = $this->input->post('list',true);
            if(empty($data)){
                $json_data  = $this->input->raw_input_stream;
                $tmp_data = json_decode($json_data,true);
                $data = $tmp_data['list'];
                if(empty($data)){
                    echo json_encode(['success'=>false,'msg'=>'未获取要保存的数据']);
                    exit;
                }
               
            }
           
            $shop_list = $this->shop->find_all("1=1","id,shortname,type");
            $shop_list = array_column($shop_list,null,'shortname');
            
            $time = strtotime(date("Y-m-d"),time());
            $info = $this->bhsq->find("real_time >= ".$time,"*",'id desc');
            if(empty($info)){
                $num = 1;
            }else{
                $arr = explode('-',$info['sb_no']);
                $num = (int)$arr[2]+1;
            }
            $time = time();
            $num = str_pad($num, 3, '0', STR_PAD_LEFT);
            $sb_no = "SQ-".date("ymd")."-".$num;
            $insert_arr = [];
            $error_list= [];
            foreach($data as $k=>$v){
                $shopshortname = trim($v[4]);
                if($shopshortname == '无'){
                   $shop_info = [
                        'id'=>0,
                        'type'=>0,
                   ];
                }else{
                    $shop_info = isset($shop_list[$shopshortname])?$shop_list[$shopshortname]:[];
                    if(empty($shop_info)){
                        $error_list[] = [
                            'msg'=>"第".($k+1).'行店铺不存在,请核对表格信息'.$shopshortname,
                        ];
                        continue;
                    }
                }
                
                $num = (int)$v[3];
                if(empty($num)){
                    $error_list[] = [
                        'msg'=>"第".($k+1).'行数量不能为空,请核对表格信息',
                    ];
                    continue;
                }
                $tmp_time = trim($v[0]);
                if (preg_match('/^\d{4}-\d{2}-\d{2}$/', $tmp_time)) {
                    $add_time = strtotime($tmp_time);
                }else{
                    $error_list[] = [
                        'msg'=>"第".($k+1).'行日期格式不正确,请核对表格信息',
                    ];
                    continue;
                }
                if(empty($v[5])){
                    $error_list[] = [
                        'msg'=>"第".($k+1).'行申请人信息不能为空,请核对表格信息',
                    ];
                    continue;
                }
                if(empty($v[1])){
                    $error_list[] = [
                        'msg'=>"第".($k+1).'行产品信息不能为空,请核对表格信息',
                    ];
                    continue;
                }
                $insert_arr[] = [
                    'sb_no'=>$sb_no,
                    'sku'=>trim($v[2]),
                    'title'=>trim($v[1]),
                    'shop_id'=>$shop_info['id'],
                    'plat_id'=>$shop_info['type'],
                    'sqr'=>trim($v[5]),
                    'sq_num'=>$num,
                    'ccwl_num'=>$num,
                    'ck_num'=>$num,
                    'sq_status'=>1,
                    'remark'=>$v[6],
                    'add_time'=>$add_time,
                    'real_time'=>$time,
                    'update_time'=>$time,
                ];
            }
            $r =$this->db->insert_batch('bhsq',$insert_arr);
            if($r){
                if(empty($error_list)){
                    echo json_encode(['success'=>true,'msg'=>'添加成功']);
                }else{
                    echo json_encode(['success'=>true,'msg'=>'添加成功','error_list'=>$error_list]);
                }
               
            }else{
                echo json_encode(['success'=>false,'msg'=>'添加失败','error_list'=>$error_list]);
            }
            exit;
        }else{
            echo json_encode(['success'=>true,'msg'=>'请求失败']);
            exit;
        }
    }
    //仓储物流部的备货申请单的列表
    private function _ccwlshlist(){
        if($this->input->method() === 'post'){
            $vip_id = $this->input->post('vip_id',true);
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
            $sqr = $this->input->post('sqr',true);
            $sqr = trim($sqr);
            $shop_id = $this->input->post('shop_id',true);
            $plat_id = $this->input->post('plat_id',true);
            $shop_ids = $this->input->post('shop_ids',true);
            $ktime = $this->input->post('ktime',true);
            $jtime = $this->input->post('jtime',true);
            $ktime = strtotime($ktime);
            $jtime = strtotime($jtime);

            $where = "sq_status = 2 and ccwl_status = 0 ";
            $where .= " and add_time >= ".$ktime."  and add_time  < ".$jtime." ";

            if(!empty($sqr)){
                $where .= " and sqr = '".$sqr."' ";
            }
            if(!empty($shop_id)){
                $where .= " and shop_id = ".$shop_id." ";
            }else{
                if($vip_id == 1){

                }else{
                    $where .= " and shop_id in (".$shop_ids.") ";
                }
                
            }
            if(!empty($plat_id)){
                $where .= " and plat_id = ".$plat_id." ";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $list = $this->bhsq->find_all($where,"id,shop_id,plat_id,title,sku,sqr,sq_num,ccwl_num,add_time,update_time,erp_check",$order_str,$start,$perpage);

            if(empty($list)){
                $rows = array('total'=>0,'over'=>1,'pagenum'=>0,'rows'=>([]));
                echo json_encode($rows);exit;
            }
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            $plat_list = $this->typeclass->find_all("classid = 32","id,title");
            $plat_list = array_column($plat_list,'title','id');
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"无";
                $list[$k]['plat_id'] = isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"无";
                $list[$k]['add_time'] = date("Y-m-d",$v['add_time']);
                if($v['erp_check'] == 1){
                      $list[$k]['sku'] = "<a style='color:red' href='javascript:void(0)' onclick='addnewgoods(this)' id='edit_sku_".$v['id']."'  data-id='".$v['id']."'>".$v['sku']."</a>  <i class='fa fa-edit' data-id='".$v['id']."' data-sku='".$v['sku']."' onclick='edit_sku(this)'></i>";
                }else{
                    $list[$k]['sku'] = $v['sku']."  <i class='fa fa-edit' data-id='".$v['id']."' data-sku='".$v['sku']."' onclick='edit_sku(this)'></i>";
                }
                
                $list[$k]['ccwl_num'] = $v['ccwl_num']."  <i class='fa fa-edit' data-id='".$v['id']."' data-num='".$v['ccwl_num']."' onclick='edit_ccwl(this)'></i>";
                $list[$k]['update_time'] = "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#4169E1;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='3' onclick='update_status(this)'>驳回</a>";
                unset($list[$k]['erp_check']);
            }


            $total = $this->bhsq->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
            $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($list));
		    echo json_encode($rows);exit;
        }else{
            $user = $this->user->get_api($_SESSION['api']);
            $usersp = explode('|',trim($user['shop'],'|'));
            $this->data['usersp'] = implode(",",$usersp);
             $vip_id = 0;
            if(in_array($user['id'],[10,28])){
                $vip_id = 1;
            }
            $this->data['vip_id'] = $vip_id;
            $this->_Template('beihuogl_ccwlshlist',$this->data);
        }
    }
    //一键校验选中SKU
    private function _ccwlskucheck(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            if(empty($data['arr_id'])){
                echo json_encode(['success'=>false,'msg'=>'至少选一个呀！！！']);
                exit;
            }
            $list = $this->bhsq->find_all('id in ('.implode(',',$data['arr_id']).')');
            $error_list = [];
            $success_ids = [];
            $errors_ids = [];
            foreach($list as $k=>$v){
                if(empty($v['sku'])){
                    $error_list[] = [
                        'msg'=>$v['value'].'请录入SKU',
                    ];
                    $errors_ids[] = $v['id'];
                    continue;
                }
                $num = $this->goods->find_count("sku = '".$v['sku']."'");
                if(!empty($num)){
                    $success_ids[] = $v['id'];
                    continue;
                }
                $whlabel_info = $this->whlabel->find("sku = '".$v['sku']."'",'sku,features','id desc');
                if(empty($whlabel_info)){
                    $error_list[] = [
                        'msg'=>$v['sku'].'未在进销存浏览那找到对应信息',
                    ];
                    $errors_ids[] = $v['id'];
                }
            }
            if(!empty($error_list)){
                $this->db->where_in('id', $errors_ids);
                $this->db->update('bhsq', ['erp_check'=>1]);
            }
            if(!empty($success_ids)){
                $this->db->where_in('id', $success_ids);
                $this->db->update('bhsq', ['erp_check'=>0]);
            }

           
            if(empty($error_list)){
                echo json_encode(['success'=>true,'msg'=>'校验成功,没有异常信息']);
                exit;
            }else{
                echo json_encode(['success'=>true,'msg'=>'校验失败,请核对填写信息','error_list'=>$error_list]);
                exit;
            }
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
            exit;
        }
    }
    private function _ccwlbhzhcheck(){
        if($this->input->method() === 'post'){
            exit("请求方式不对");
        }else{
            $bh_no = $this->input->get('bh_no',true);
            if(empty($bh_no)){
                exit("不符合下载要求");
            }
            $info = $this->bhccwl->find("bh_no = '".$bh_no."'");
            if(empty($info)){
                exit("备货单料品信息为空");
            }
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."'");

            $final_list= [];
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $plat_list = $this->typeclass->find_all("classid = 32","id,title");
            $shop_list = array_column($shop_list,'shopname','id');
            $plat_list = array_column($plat_list,'title','id');
            $final_list= [];
            foreach($list as $k=>$v){
                $final_list[] = [
                    'bh_no'=>$v['bh_no'],
                    'shop'=>isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"无",
                    'plat'=>isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"无",
                    'zh'=>$v['title'],
                    'erp_zh'=>$v['erp_zh'],
                    'jm'=>$v['jm'],
                    'sqr'=>$v['sqr'],
                    'sq_num'=>$v['ccwl_num'],
                    'public_time'=>date("Y-m-d",$v['public_time']),
                    'remark'=>$v['remark'],
                ];
            }
        

            $filename = $bh_no."中文品名核对.xls";
            $str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
            <head>
            <!--[if gte mso 9]><xml>
            <x:ExcelWorkbook>
            <x:ExcelWorksheets>
            <x:ExcelWorksheet>
            <x:Name>EXCEL</x:Name>
            <x:WorksheetOptions>
            <x:Print>
            <x:ValidPrinterInfo />
            </x:Print>
            </x:WorksheetOptions>
            </x:ExcelWorksheet>
            </x:ExcelWorksheets>
            </x:ExcelWorkbook>
            </xml>
            <![endif]-->
            </head><body>";
            $str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
            $str .= "<tr><td>备货单号</td><td>店铺</td><td>平台</td><td>中文名称</td><td>ERP仓库品名</td><td>u9料号</td><td>申请人</td><td>申报数量<td>申请时间</td><td>备注</td></tr>";
            foreach ($final_list as $key=>$value) 
            { 
                if($value['erp_zh'] != $value['zh']){
                   $str .= "<tr style='background-color: red;'>";
                }else{
                    $str .= "<tr>";
                }
                
                $str .= "<td>". $value['bh_no']. "</td>";	
                $str .= "<td>". $value['shop']. "</td>";
                $str .= "<td>". $value['plat']. "</td>";	
                $str .= "<td>". $value['zh']. "</td>";	
                $str .= "<td>". $value['erp_zh']. "</td>";
                $str .= "<td>". $value['jm']. "</td>";
                $str .= "<td>". $value['sqr']. "</td>";
                $str .= "<td>". $value['sq_num']. "</td>";
                $str .= "<td>". $value['public_time']. "</td>";
                $str .= "<td>". $value['remark']. "</td>";
                $str .= "</tr>";
            }
            $str .= "</table></body></html>"; 
            header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
            header( "Content-type: application/octet-stream" ); 
            header( "Content-Disposition: attachment; filename=".$filename ); 
            header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
            header( "Pragma: no-cache" ); 
            header( "Expires: 0" ); 
            exit($str); 
            
            
        }
    }

    private function _ccwlbhdownload(){
        if($this->input->method() === 'get'){
            $query = $this->input->get(null,true);
            if(empty($query['excel'])){
                exit("不符合下载要求");
            }
            if($query['excel'] != 'erp'){
                exit("不符合下载要求");
            }
            $ids = $this->input->get('ids',true);
            if(empty($ids)){
                exit("请选择要下载的备货单");
            }
            $arr_id = [];
            if(stripos($ids,'|') !== false){
                $arr_id = explode('|', $ids);   
            }else{
                $arr_id[] = $ids;
            }
            if(empty($arr_id)){
                exit("请选择要下载的备货单-1");
            }
            $list = $this->bhccwl->find_all('id in ('.implode(',',$arr_id).')');
            $batch_nos = array_column($list,'bh_no');
            $batch_no_str = '';
            foreach($batch_nos as $k=>$v){
                $batch_no_str .= "'".$v."',";
            }
            $batch_no_str = trim($batch_no_str,',');
            $bh_list = $this->bhsq->find_all("bh_no in (".$batch_no_str.")");
            if(empty($bh_list)){
                exit("备货单料品信息为空");
            }
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $plat_list = $this->typeclass->find_all("classid = 32","id,title");
            $shop_list = array_column($shop_list,'shopname','id');
            $plat_list = array_column($plat_list,'title','id');
            $final_list= [];
            foreach($bh_list as $k=>$v){
                $final_list[] = [
                    'bh_no'=>$v['bh_no'],
                    'shop'=>isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"无",
                    'plat'=>isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"无",
                    'zh'=>$v['title'],
                    'jm'=>$v['jm'],
                    'sqr'=>$v['sqr'],
                    'sq_num'=>$v['ccwl_num'],
                    'public_time'=>date("Y-m-d",$v['public_time']),
                    'remark'=>$v['remark'],
                ];
            }

            $filename = "备货生产单.xls";
            $str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
            <head>
            <!--[if gte mso 9]><xml>
            <x:ExcelWorkbook>
            <x:ExcelWorksheets>
            <x:ExcelWorksheet>
            <x:Name>EXCEL</x:Name>
            <x:WorksheetOptions>
            <x:Print>
            <x:ValidPrinterInfo />
            </x:Print>
            </x:WorksheetOptions>
            </x:ExcelWorksheet>
            </x:ExcelWorksheets>
            </x:ExcelWorkbook>
            </xml>
            <![endif]-->
            </head><body>";
            $str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
            $str .= "<tr><td>备货单号</td><td>店铺</td><td>平台</td><td>中文名称</td><td>u9料号</td><td>申请人</td><td>申报数量<td>申请时间</td><td>备注</td></tr>";
            foreach ($final_list as $key=>$value) 
            { 
                $str .= "<tr>";
                $str .= "<td>". $value['bh_no']. "</td>";	
                $str .= "<td>". $value['shop']. "</td>";
                $str .= "<td>". $value['plat']. "</td>";	
                $str .= "<td>". $value['zh']. "</td>";	
                $str .= "<td>". $value['jm']. "</td>";
                $str .= "<td>". $value['sqr']. "</td>";
                $str .= "<td>". $value['sq_num']. "</td>";
                $str .= "<td>". $value['public_time']. "</td>";
                $str .= "<td>". $value['remark']. "</td>";
                $str .= "</tr>";
            }
            $str .= "</table></body></html>"; 
            header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
            header( "Content-type: application/octet-stream" ); 
            header( "Content-Disposition: attachment; filename=".$filename ); 
            header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
            header( "Pragma: no-cache" ); 
            header( "Expires: 0" ); 
            exit($str); 
            
        }
    }
    //仓储物流合成备货单
    private function _ccwlbhmake(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            if(empty($data['arr_id'])){
               echo json_encode(['success'=>false,'msg'=>'至少选一个呀！！！']);
                exit;
            }
            $bh_no = $data['bh_no'];
            $select_id = $data['arr_id'];
            if(empty($select_id)){
                echo json_encode(['success'=>false,'msg'=>'至少选一个呀！！！']);
                exit;
            }
            if(empty($bh_no)){
                $tmp_time = strtotime(date("Y-m-d"),time());
                $num = $this->bhccwl->find_count("create_time >= ".$tmp_time);
                $num = $num+1;
                $num = str_pad($num, 3, '0', STR_PAD_LEFT);
                $bh_no = "BH-".date("ymd")."-".$num;
            }else{
                $info = $this->bhccwl->find("bh_no = '".$bh_no."'");
                if(!empty($info)){
                    echo json_encode(['success'=>false,'msg'=>'生成的备货单编号已经存在']);
                    exit;
                }
            }

            $list = $this->bhsq->find_all('id in ('.implode(',',$select_id).')');

            foreach($list as $k=>$v){
                if(empty($v['sku'])){
                    echo json_encode(['success'=>false,'msg'=>'提交的数据中有的sku为空,请核对填写信息']);
                    exit;
                }
            }
            $classid = $this->logic_u9tools->getClass();
            $typeclass  = $this->logic_u9tools->getTypeClass();

            foreach($list as $k=>$v){
                $whlabel_info = $this->goods->find("sku = '".$v['sku']."'",'sku,features,jm,zh','id desc');
                if(empty($whlabel_info)){
                    $whlabel_info = $this->whlabel->find("sku = '".$v['sku']."'",'sku,features','id desc');
                    if(empty($whlabel_info)){
                        echo json_encode(['success'=>false,'msg'=>$v['sku'].'未在进销存浏览那找到对应信息']);
                        exit;
                    }
    
                    $r = $this->logic_u9tools->getOneU9bmHasGift($whlabel_info['features'],$classid,$typeclass);
    
                    $this->bhsq->save([
                        'jm'=>$r['jm'],
                        'drck'=>$this->getU9Drck($whlabel_info['features']),
                        'features'=>$whlabel_info['features'],
                        'erp_zh'=>$r['zh'],
                    ],$v['id']);
                }else{
                    $this->bhsq->save([
                        'jm'=>$whlabel_info['jm'],
                        'drck'=>$this->getU9Drck($whlabel_info['features']),
                        'features'=>$whlabel_info['features'],
                        'erp_zh'=>$whlabel_info['zh'],
                    ],$v['id']);
                }
                
            }

            $this->db->trans_start();
                $this->db->where_in('id',$select_id);
                $this->db->update('bhsq',[
                    'bh_no'=>$bh_no,
                    'sq_status'=>4,
                    'ccwl_status'=>1,
                ]);
                $this->db->select('SUM(ccwl_num) as total_ccwl_num');
                $this->db->where_in('id',$select_id);
                $query = $this->db->get('bhsq');
                $result = $query->row();
                $total_ccwl_num = $result->total_ccwl_num? $result->total_ccwl_num:0;
                $time = time();
                $this->bhccwl->insert([
                    'bh_no'=>$bh_no,
                    'status'=>0,
                    'num'=>$total_ccwl_num,
                    'create_time'=>$time,
                    'update_time'=>$time,
                ]);

            if($this->db->trans_status() === FALSE){
                $this->db->trans_rollback();
                echo json_encode(['success'=>false,'msg'=>'生成备货单失败']);
                exit;
            }else{
                $this->db->trans_commit();
                echo json_encode(['success'=>true,'msg'=>'生成备货单成功']);
                exit;
            }

        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
            exit;
        }
    }
    private function getU9Drck($features){
        if(stripos($features,'-126-') !== false)
        {
            $drck = '12003';//进入发条库
        }
        else if(stripos($features,'-127-') !== false)
        {
            $drck = '12004';//进入发块库
        }
        else
        {
            $drck = '12006';//其它进入完成库
        }
        return $drck;
    }
    //仓储物流部的备货单列表
    private function _ccwlbhindex(){
        if($this->input->method() === 'post'){
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
            $bh_no = $this->input->post('bh_no',true);
            $status =  $this->input->post('status',true);
            $ktime = $this->input->post('ktime',true);
            $jtime = $this->input->post('jtime',true);
            $ktime = strtotime($ktime);
            $jtime = strtotime($jtime);

            $where = "create_time >= ".$ktime."  and create_time  < ".$jtime." ";
            if(!empty($bh_no)){
                $where .= " and bh_no = '".$bh_no."' ";
            }

            if($status > -1){
                $where .= " and status = ".$status." ";
            }
           
           
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $list = $this->bhccwl->find_all($where,"id,bh_no,status,create_time,public_time,update_time,ck_status",$order_str,$start,$perpage);

            if(empty($list)){
                $rows = array('total'=>0,'over'=>1,'pagenum'=>0,'rows'=>([]));
                echo json_encode($rows);exit;
            }
            $status_list = $this->bhccwl->getStatus();
            foreach($list as $k=>$v){
                $list[$k]['bh_no'] = "<h9 class='window' data-h='/beihuogl/showckbh/".$v['id']."' data-t='订单号：".$v['bh_no']."'><p>".$v['bh_no']."</p></h9>";
                $list[$k]['status'] = isset($status_list[$v['status']])?$status_list[$v['status']]:"";
                $list[$k]['create_time'] = date("Y-m-d",$v['create_time']);
                $list[$k]['public_time'] = empty($v['public_time'])?"":date("Y-m-d",$v['public_time']);
                
                $str = "";
                if($v['status'] == 0){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)'class='window' data-h='/beihuogl/ccwlbhedit/".$v['id']."' data-t='修改' style='margin-right:4px;color: #fff;background-color:#228B22;padding:4px 10px;border-radius:5px;font-size:15px'>编辑</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#4169E1;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='1' onclick='update_status(this)'>发布</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#CD5C5C;padding:4px 10px;border-radius:5px;font-size:15px' data-bh_no='".$v['bh_no']."'  onclick='checkdownload(this)'>品名校验</a>";
                    $str .=  "</div>";

                }
                if($v['status'] == 1 && $v['ck_status'] == 0){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#4169E1;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='2' onclick='update_status(this)'>撤回</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#CD5C5C;padding:4px 10px;border-radius:5px;font-size:15px' data-bh_no='".$v['bh_no']."'  onclick='checkdownload(this)'>品名校验</a>";
                    $str .=  "</div>";
                }

                if($v['status'] == 2 && $v['ck_status'] == 0){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)'class='window' data-h='/beihuogl/ccwlbhedit/".$v['id']."' data-t='修改' style='margin-right:4px;color: #fff;background-color:#228B22;padding:4px 10px;border-radius:5px;font-size:15px'>编辑</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#4169E1;padding:4px 10px;border-radius:5px;font-size:15px' data-id='".$v['id']."' data-type='1' onclick='update_status(this)'>发布</a>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#CD5C5C;padding:4px 10px;border-radius:5px;font-size:15px' data-bh_no='".$v['bh_no']."'  onclick='checkdownload(this)'>品名校验</a>";
                    $str .=  "</div>";
                }
                if($v['status'] == 4){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)' style='margin-right:4px;color: #fff;background-color:#CD5C5C;padding:4px 10px;border-radius:5px;font-size:15px' data-bh_no='".$v['bh_no']."'  onclick='checkdownload(this)'>品名校验</a>";
                    $str .=  "</div>";
                }
                $list[$k]['update_time'] = $str;
                unset($list[$k]['ck_status']);
            }


            $total = $this->bhccwl->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
            $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($list));
		    echo json_encode($rows);exit;
        }else{
            $this->_Template('beihuogl_ccwlbhindex',$this->data);
        }
    }
    //仓储物流部备货 在编辑页面添加数据
    private function _ccwlbhsavexzbh(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            $select_id = $data['select_id'];
            $id = $data['id'];
            $bh_no = $data['bh_no'];
            if(empty($select_id)){
                echo json_encode(['success'=>false,'msg'=>'至少选一个呀！！！']);
                exit;
            }
            $info = $this->bhccwl->read($id);
            if(empty($info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);
                exit;
            }
            if($info['bh_no'] != $bh_no){
                echo json_encode(['success'=>false,'msg'=>'数据信息异常联系技术处理']);
                exit;
            }
            $bh_no = $info['bh_no'];
            $list = $this->bhsq->find_all('id in ('.implode(',',$select_id).') ' );
            foreach($list as $k=>$v){
                if(empty($v['sku'])){
                    echo json_encode(['success'=>false,'msg'=>'提交的数据中有的sku为空,请核对填写信息']);
                    exit;
                }
                if(!empty($v['bh_no'])){
                    echo json_encode(['success'=>false,'msg'=>'提交的数据中有的已经被调用,请联系技术核对']);
                    exit;
                }
            }
            $classid = $this->logic_u9tools->getClass();
            $typeclass  = $this->logic_u9tools->getTypeClass();
            foreach($list as $k=>$v){
                $whlabel_info = $this->goods->find("sku = '".$v['sku']."'",'sku,features,jm,zh','id desc');
                if(empty($whlabel_info)){
                    $whlabel_info = $this->whlabel->find("sku = '".$v['sku']."'",'sku,features','id desc');
                    if(empty($whlabel_info)){
                        echo json_encode(['success'=>false,'msg'=>$v['sku'].'未在进销存浏览那找到对应信息']);
                        exit;
                    }
                    if(empty($v['jm'])){
                        $r = $this->logic_u9tools->getOneU9bmHasGift($whlabel_info['features'],$classid,$typeclass);
                        $this->bhsq->save([
                            'jm'=>$r['jm'],
                            'drck'=>$this->getU9Drck($whlabel_info['features']),
                            'features'=>$whlabel_info['features'],
                            'erp_zh'=>$r['zh'],
                        ],$v['id']);
                    }
                    $list[$k]['jm'] = $r['jm'];
                }else{
                    $this->bhsq->save([
                        'jm'=>$whlabel_info['jm'],
                        'drck'=>$this->getU9Drck($whlabel_info['features']),
                        'features'=>$whlabel_info['features'],
                        'erp_zh'=>$whlabel_info['zh'],
                    ],$v['id']);
                    $list[$k]['jm'] = $whlabel_info['jm'];
                }
            }

            $status_list = $this->bhccwl->getStatus();
            $info['status_show'] = isset($status_list[$info['status']])?$status_list[$info['status']]:"";
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $plat_list = array_column($plat_list,'title','id');
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
                $list[$k]['plat_id'] = isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"";
                $list[$k]['public_time'] = date("Y-m-d",$v['public_time']);
                $list[$k]['bh_no'] = $info['bh_no'];
            }
            echo json_encode(['success'=>true,'msg'=>'编辑成功','data'=>$list]);exit;
            
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);
            exit;
        }
    }

    private function _ccwlbhedit($arg_array){
        if($this->input->method() === 'post'){
            $select_id = $this->input->post('arr_id',true);
            if(empty($select_id)){
                echo json_encode(['success'=>false,'msg'=>'至少选一个呀！！！']);
                exit;
            }
            $id = $this->input->post('id',true);
            $info = $this->bhccwl->read($id);
            $bh_no = $info['bh_no'];

            $this->db->where_in('id',$select_id);
            $this->db->update('bhsq',[
                'bh_no'=>$bh_no,
                'sq_status'=>4,
                'ccwl_status'=>1,
            ]);
            $this->db->select('SUM(ccwl_num) as total_ccwl_num');
            $this->db->where_in('id',$select_id);
            $query = $this->db->get('bhsq');
            $result = $query->row();
            $total_ccwl_num = $result->total_ccwl_num? $result->total_ccwl_num:0;
            $time = time();
            $this->bhccwl->save([
                'num'=>$total_ccwl_num,
                'update_time'=>$time,
            ],$info['id']);
            echo json_encode(['success'=>true,'msg'=>'修改成功']);exit;
        }else{
            $id = $arg_array[0];
            $info = $this->bhccwl->find("id = ".$id);
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' and sq_status = 4 and ccwl_status = 1");
            
            $status_list = $this->bhccwl->getStatus();
            $info['status_show'] = isset($status_list[$info['status']])?$status_list[$info['status']]:"";
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $plat_list = array_column($plat_list,'title','id');
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
                $list[$k]['plat_id'] = isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"";
                $list[$k]['public_time'] = date("Y-m-d",$v['public_time']);
            }
            // $this->data['info'] = $info;
            $this->data['list'] = $list;
            $this->data['info'] = $info;
            $this->_Template('beihuogl_ccwlbhedit',$this->data);
        }
    }
    private function _ccwldelitem(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            $id = $data['id'];
            $bh_no = $data['bh_no'];
            $info = $this->bhsq->read($id);
            $ccwl_num = $info['ccwl_num'];
            
            

            if(empty($info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);exit;
            }
            if(empty($info['bh_no'])){
                if($info['sq_status'] == 2 && $info['ccwl_status'] == 0){
                    echo json_encode(['success'=>true,'msg'=>'删除成功']);exit;
                }else{
                    echo json_encode(['success'=>false,'msg'=>'数据信息异常联系技术处理']);exit;
                }
            }
            if($info['bh_no'] != $bh_no){
                echo json_encode(['success'=>false,'msg'=>'数据信息异常联系技术处理']);exit;
            }
            $ccwl_info = $this->bhccwl->find("bh_no = '".$info['bh_no']."'");
            $ccwl_info['num'] = $ccwl_info['num'] - $ccwl_num;
          
            $this->db->trans_start();
            $this->bhccwl->save([
                'num'=>$ccwl_info['num'],
            ],$ccwl_info['id']);
            $this->bhsq->save([
                'sq_status'=>2,
                'ccwl_status'=>0,
                'bh_no'=>''
            ],$id);
            if($this->db->trans_status() === FALSE){
                $this->db->trans_rollback();
                echo json_encode(['success'=>false,'msg'=>'删除失败']);exit;
            }else{
                $this->db->trans_commit();
                echo json_encode(['success'=>true,'msg'=>'删除成功']);exit;
            }
            
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);exit;
        }
    }
    private function _ccwleditxzbh(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            //超过三月没审核的 就不展示了
            $time = time() - 60*24*3600;
            $where = "sq_status = 2 and ccwl_status = 0  and public_time > ".$time." ";
            if(!empty($data['sqr'])){
                $where .= " and sqr = '".$data['sqr']."' ";
            }
            if(!empty($data['shop_id'])){
                $where .= " and shop_id = ".$data['shop_id']." ";
            }
            if(!empty($data['plat_id'])){
                $where .= " and plat_id = ".$data['plat_id']." ";
            }
            if(!empty($data['sku'])){
                $where .= " and sku = '".$data['sku']."' ";
            }
            $order_str = "id desc";
            $list = $this->bhsq->find_all($where,"*",$order_str,0,20);
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $plat_list = array_column($plat_list,'title','id');
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
                $list[$k]['plat_id'] = isset($plat_list[$v['plat_id']])?$plat_list[$v['plat_id']]:"";
                $list[$k]['public_time'] = date("Y-m-d",$v['public_time']);
            }
            if(empty($list)){
                echo json_encode(['success'=>false,'msg'=>'查询失败']);exit;
            }else{
                echo json_encode(['success'=>true,'msg'=>'查询成功','data'=>$list]);exit;
            }
        }else{
            $data = $this->input->get();
            $this->data['id'] = $data['id'];
            $this->data['bh_no'] = $data['bh_no'];
            $plat_list = $this->typeclass->find_all("classid = 32 and id != 2297","id,title");
            $this->data['plat_list'] = $plat_list;
            $this->_Template('beihuogl_ccwleditxzbh',$this->data);
        }

    }

    private function _ccwlbhsave(){
        if($this->input->method() === 'post'){
            $data = $this->input->post();
            $id = $data['id'];
            $val = $data['val'];
            $column = $data['column'];
            $update_arr = [];
            if($column == 'status'){
                $update_arr = [
                    'status'=>(int)$val,
                    'update_time'=>time(),
                    'public_time'=>time(),
                ];
                if($val == 2){
                    $info = $this->bhccwl->read($id);
                    if($info['status'] == 1 && $info['ck_status'] == 0){

                    }else{
                        echo json_encode(['success'=>false,'msg'=>'状态不对，不可撤回']);exit;
                    }
                }
            }else{
                echo json_encode(['success'=>false,'msg'=>'请求参数未设置']);exit;
            }
            $r = $this->bhccwl->save($update_arr,$id);
            if($r){
                echo json_encode(['success'=>true,'msg'=>'修改成功']);exit;
            }else{
                echo json_encode(['success'=>false,'msg'=>'修改失败']);exit;
            }
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求失败']);exit;
        }
    }
    //仓库的备货单列表
    private function _ckbhindex(){
        if($this->input->method() === 'post'){
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
            $bh_no = $this->input->post('bh_no',true);
            $status =  $this->input->post('status',true);
            $ktime = $this->input->post('ktime',true);
            $jtime = $this->input->post('jtime',true);
            $ktime = strtotime($ktime);
            $jtime = strtotime($jtime);

            $where = "public_time >= ".$ktime."  and public_time  < ".$jtime." and status = 1 ";
            if(!empty($bh_no)){
                $where .= " and bh_no = '".$bh_no."' ";
            }

            if($status > -1){
                $where .= " and status = ".$status." ";
            }
           
           
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $list = $this->bhccwl->find_all($where,"id,bh_no,ck_status,public_time,ckpublic_time",$order_str,$start,$perpage);

            if(empty($list)){
                $rows = array('total'=>0,'over'=>1,'pagenum'=>0,'rows'=>([]));
                echo json_encode($rows);exit;
            }
            $status_list = $this->bhccwl->getCkStatus();
            foreach($list as $k=>$v){

                $list[$k]['bh_no'] = "<h9 class='window' data-h='/beihuogl/showckbh/".$v['id']."' data-t='订单号：".$v['bh_no']."'><p>".$v['bh_no']."</p></h9>";



                $list[$k]['ck_status'] = isset($status_list[$v['ck_status']])?$status_list[$v['ck_status']]:"";
                $list[$k]['public_time'] = empty($v['public_time'])?"":date("Y-m-d",$v['public_time']);
                $list[$k]['ckpublic_time'] = empty($v['ckpublic_time'])?"":date("Y-m-d",$v['ckpublic_time']);
                $str = "";
                if($v['ck_status'] == 0){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)'class='window' data-h='/beihuogl/ckbhedit/".$v['id']."' data-t='修改' style='margin-right:4px;color: #fff;background-color:#228B22;padding:4px 10px;border-radius:5px;font-size:15px'>审核</a>";
                    $str .= "<a href='/beihuogl/ckexcel/".$v['id']."' style='margin-right:4px;color: #fff;background-color:#5F9EA0;padding:4px 10px;border-radius:5px;font-size:15px'>下载</a>";
                    $str .=  "</div>";

                }
                if($v['ck_status'] == 1 || $v['ck_status'] == 2){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='javascript:void(0)' class='window' data-h='/beihuogl/makeu9scd/".$v['id']."' data-t='修改'  style='margin-right:4px;color: #fff;background-color:#0099FF;padding:4px 10px;border-radius:5px;font-size:15px' >生成u9生产单</a>";
                    $str .=  "</div>";
                }
                if($v['ck_status'] > 2){
                    $str .=  "<div style='text-align:center;'>";
                    $str .= "<a href='/beihuogl/u9scdexcel/".$v['id']."'  data-t='修改'  style='margin-right:4px;color: #fff;background-color:#D2691E;padding:4px 10px;border-radius:5px;font-size:15px' >生产单EXCEL下载</a>";
                    $str .=  "</div>";
                }
                
                $list[$k]['update_time'] = $str;
            }


            $total = $this->bhccwl->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
            $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($list));
		    echo json_encode($rows);exit;
        }else{
            $this->_Template('beihuogl_ckbhindex',$this->data);
        }
    }

    private function _ckbhedit($arg_array){
        if($this->input->method() === 'post'){
            $id = $this->input->post('id',true);
            $bh_no = $this->input->post('bh_no',true);
            $info = $this->bhccwl->read($id);
            if(empty($info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);exit;
            }
            if($info['ck_status'] == 0 && $info['status'] == 1){

            }else{
                echo json_encode(['success'=>false,'msg'=>'状态不对，不可审核']);exit;
            }
            if($info['bh_no'] != $bh_no){
                echo json_encode(['success'=>false,'msg'=>'数据信息异常联系技术处理']);exit;
            }

            $num = 0;
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' ");
            foreach($list as $k=>$v){
                $num += $v['ck_num'];
            }

            $r = $this->bhccwl->save([
                'ck_status'=>1,
                'ck_num'=>$num,
                'update_time'=>time(),
                'ckpublic_time'=>time(),
            ],$id);
            if($r){
                echo json_encode(['success'=>true,'msg'=>'审核成功']);exit;
            }else{
                echo json_encode(['success'=>false,'msg'=>'审核失败']);exit;
            }
        }else{
            $id = $arg_array[0];
            $info = $this->bhccwl->find("id = ".$id);
            $status_list = $this->bhccwl->getCkStatus();
            $info['ck_status_show'] = isset($status_list[$info['ck_status']])?$status_list[$info['ck_status']]:"";
            
            $drck_list = $this->bhccwl->getDrck();
            $this->data['drck_list'] = $drck_list;
            $this->data['drck_json'] = json_encode($drck_list);
            $this->data['info'] = $info;
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."'");
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
                $list[$k]['drck_show'] = isset($drck_list[$v['drck']])?$drck_list[$v['drck']]:"";
            }
            $this->data['list'] = $list;
            $this->_Template('beihuogl_ckbhedit',$this->data);
        }
    }

    private function _makeu9scd($arg_array){
        if($this->input->method() === 'post'){
            $data = $this->input->post(null,true);
            $info = $this->bhccwl->read($data['id']);
            if(empty($info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);exit;
            }
            if($info['ck_status'] == 1 && $info['status'] == 1){
            }else{
                echo json_encode(['success'=>false,'msg'=>'状态不对，不可生成u9生产单']);
                exit;
            }
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' and  is_u9sc = 0 ");

            $params = [
                'org_code'=>"120",//组织代码 龙盈工厂
                'djhlx'=>'2000',//单号类型 备货生产单
                'scbm_code'=>"12008",//龙盈生产部门
                "time"=>time(),
                'owner_org_code'=>"120",
                'title'=>$info['bh_no'],
                'shipremarks'=>$info['bh_no'],
            ];
            $final_list = [];
            foreach($list as $k=>$v){
                $final_list[] =[
                    'do_id'=>$v['id'],
                    'drck'=>$v['drck'],
					'jm'=>$v['jm'],
					'sl'=>$v['ck_num'],
                ];
            }

            $params['list'] = $final_list;
            $token = $this->settingtest->get_yytoken_120();
            $res = $this->apiyyv1->scdCreate($params,$token);
            if(empty($res[0]['Data'])){
                $this->logic_ding->sendToDing("生成u9生产单失败，错误信息：".json_encode($res,JSON_UNESCAPED_UNICODE));
                echo json_encode(['success'=>false,'msg'=>'生成u9生产单失败']);exit;
            }
            $this->logic_ding->sendToDing("生成u9生产单成功,进行记录：".json_encode($res,JSON_UNESCAPED_UNICODE));
            $r_s_list = $res[0]['Data'];
            foreach($list as $k=>$v){
                $list[$k]['u9_data'] = $r_s_list[$k];
            }
            //m_isSucess
            $flag_status = 0;//判断是否有创建失败的
            $u9sc_status = 0;//判断是否有创建成功的
            foreach($list as $k=>$v){
                if($v['u9_data']['m_isSucess']== 1){
                    $u9sc_status += 1;
                    $this->bhsq->save([
                        'is_u9sc'=>1,
                        'u9sc_no'=>$v['u9_data']['m_code'],
                    ],$v['id']);
                }else{
                    if($v['ck_num'] > 0){
                        $flag_status += 0;
                        $this->bhsq->save([
                            'u9sc_remark'=>$v['u9_data']['m_errorMsg'],
                        ],$v['id']);
                    }else{
                         $u9sc_status += 1;
                    }

                   
                }
            }
            $len = count($list);
            //都创建失败了 就直接gg
            if($u9sc_status == 0){
                echo json_encode(['success'=>false,'msg'=>'生成u9生产单失败']);exit;
            }
            if(($u9sc_status < $len) && ( $flag_status< $len) ){
                $this->bhccwl->save([
                    'ck_status'=>2,
                ],$info['id']);
                echo json_encode(['success'=>true,'msg'=>'生成u9生产单部分成功']);exit;
            }
            if($u9sc_status == $len){
                $this->bhccwl->save([
                    'ck_status'=>3,
                ],$info['id']);
                echo json_encode(['success'=>true,'msg'=>'生成u9生产单成功']);exit;
            }
            echo json_encode(['success'=>false,'msg'=>'代码异常']);exit;
            
        }else{
            $id = $arg_array[0];
            $info = $this->bhccwl->read($id);
            $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' ");
            $shop_list = $this->shop->find_all("1=1","id,shopname");
            $shop_list = array_column($shop_list,'shopname','id');
            $drck_list = $this->bhccwl->getDrck();
            $status_list = $this->bhccwl->getCkStatus();
            $info['ck_status_show'] = isset($status_list[$info['ck_status']])?$status_list[$info['ck_status']]:"";
            foreach($list as $k=>$v){
                $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
                $list[$k]['drck_show'] = isset($drck_list[$v['drck']])?$drck_list[$v['drck']]:"";
            }
            $this->data['list'] = $list;
            $this->data['info'] = $info;
            $this->_Template('beihuogl_makeu9scd',$this->data);
        }
    }

    private function _ddscscd(){
        if($this->input->method() === 'post'){
            $id = $this->input->post('id',true);
            $bh_no = $this->input->post('bh_no',true);
            $bhsq_info = $this->bhsq->read($id);
            $bhccwl_info = $this->bhccwl->find("bh_no = '".$bhsq_info['bh_no']."' ");
            if(empty($bhccwl_info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);exit;
            }
            // if($bhccwl_info['ck_status'] != 1){
            //     echo json_encode(['success'=>false,'msg'=>'状态不对，不可生成u9生产单']);
            //     exit;
            // }
            if(!in_array($bhccwl_info['ck_status'],[1,2])){
                echo json_encode(['success'=>false,'msg'=>'状态不对，不可生成u9生产单']);
                exit;
            }
            if(!empty($bhsq_info['u9sc_no'])){
                echo json_encode(['success'=>false,'msg'=>'状态不允许生成生产单,有疑问联系技术处理']);
                exit;
            }
            $params = [
                'org_code'=>"120",//组织代码 龙盈工厂
                'djhlx'=>'2000',//单号类型 备货生产单
                'scbm_code'=>"12008",//龙盈生产部门
                "time"=>time(),
                'owner_org_code'=>"120",
                'title'=>$bhccwl_info['bh_no'],
                'shipremarks'=>$bhccwl_info['bh_no'],
            ];
            $list[] = [
                'do_id'=>$bhsq_info['id'],
                'drck'=>$bhsq_info['drck'],
                'jm'=>$bhsq_info['jm'],
                'sl'=>$bhsq_info['ck_num'],
            ]; 
            $params['list'] = $list;

            $token = $this->settingtest->get_yytoken_120();
            $res = $this->apiyyv1->scdCreate($params,$token);
            if(empty($res[0]['Data'])){
                echo json_encode(['success'=>false,'msg'=>'生成u9生产单失败']);exit;
            }
            if($res[0]['Data'][0]['m_isSucess']== 1){
                $this->bhsq->save([
                    'is_u9sc'=>1,
                    'u9sc_no'=>$res[0]['Data'][0]['m_code'],
                ],$bhsq_info['id']);
                $tmp_list = $this->bhsq->find_all("bh_no = '".$bh_no."' and  is_u9sc = 0 ");
                if(empty($tmp_list)){
                    $tmp_status = 3;
                }else{
                    $tmp_status = 2;
                }
                $this->bhccwl->save([
                    'ck_status'=>$tmp_status,
                ],$bhccwl_info['id']);
                echo json_encode(['success'=>true,'msg'=>'生成u9生产单成功']);exit;
            }else{
                $this->bhsq->save([
                    'u9sc_remark'=>$res[0]['Data'][0]['m_errorMsg'],
                ],$bhsq_info['id']);
                echo json_encode(['success'=>false,'msg'=>$res[0]['Data'][0]["m_errorMsg"]]);exit;
            }
            
            

        }else{
            exit('No direct script access allowed');
        }
    }

    private function _showckbh($arg_array){
        if($this->input->method() === 'post'){
            exit('No direct script access allowed');
        }
        $id = $arg_array[0];
        $drck_list = $this->bhccwl->getDrck();
        $shop_list = $this->shop->find_all("1=1","id,shopname");
        $shop_list = array_column($shop_list,'shopname','id');
        $info = $this->bhccwl->read($id);
        $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' ");
        $list_dcd = $this->bhdcd->find_all("bh_no = '".$info['bh_no']."' ");
        foreach($list as $k=>$v){
            $list[$k]['shop_id'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:"";
            $list[$k]['drck_show'] = isset($drck_list[$v['drck']])?$drck_list[$v['drck']]:"";
        }
        $this->data['info'] = $info;
        $this->data['list'] = $list;
        $this->data['list_dcd'] = $list_dcd;
        $this->_Template('beihuogl_showckbh',$this->data);
    }
    //仓库录入调出单
    private function _ckdcd(){
        if($this->input->method() === 'post'){
            $lrdcd = $this->input->post('lrdcd',true);
            if(empty($lrdcd)){
                //列表展示
                $page = $this->input->post('page',true);
                $perpage = $this->input->post('perpage',true);
                $bh_no = $this->input->post('bh_no',true);
                $dcd_no =  $this->input->post('dcd_no',true);
                $status =  $this->input->post('status',true);
                $ktime = $this->input->post('ktime',true);
                $jtime = $this->input->post('jtime',true);
                $ktime = strtotime($ktime);
                $jtime = strtotime($jtime);
    
                $where = "create_time >= ".$ktime."  and create_time  < ".$jtime." ";
                if(!empty($bh_no)){
                    $where .= " and bh_no = '".$bh_no."' ";
                }
                if($status > -1){
                    $where .= " and status = ".$status." ";

                }
    
                if(!empty($dcd_no)){
                    $where .= " and dcd_no = '".$dcd_no."' ";
                }
               
               
                //数据排序
                $order_str = "id desc";
                if(empty($page))
                {
                    $start = 0;
                    $perpage = 1;
                }
                else
                {
                    $start = ($page - 1)*$perpage;
                }
    
                $list = $this->bhdcd->find_all($where,"id,bh_no,dcd_no,drd_no,status,jm,num,kw,create_time,rk_time,is_rk,szkw",$order_str,$start,$perpage);
    
                if(empty($list)){
                    $rows = array('total'=>0,'over'=>1,'pagenum'=>0,'rows'=>([]));
                    echo json_encode($rows);exit;
                }
                $status_list = $this->bhdcd->getStatus();
                foreach($list as $k=>$v){
                    $list[$k]['dcd_no'] = "<h9 class='window' data-h='/beihuogl/ckbherprk/".$v['dcd_no']."' data-t='订单号：".$v['dcd_no']."'><p>".$v['dcd_no']."</p></h9>";
                    $list[$k]['status'] = isset($status_list[$v['status']])?$status_list[$v['status']]:"";
                    $list[$k]['drd_no'] = empty($v['drd_no'])?"":$v['drd_no'];
                    $list[$k]['kw'] = empty($v['kw'])?"":$v['kw'];
                    $list[$k]['create_time'] = empty($v['create_time'])?"":date("Y-m-d",$v['create_time']);

                    $str = "";
                   
                   
                    if(!empty($v['rk_time'])){
                        $str .= "<a href='javascript:void(0)'  style='margin-right:4px;color: #fff;background-color:#D2691E;padding:4px 8px;border-radius:5px;font-size:13px' onclick='dybq(this)'  data-id='".$v['id']."' >打印标签</a>";
                    }else{
                        if($v['is_rk'] == 0){
                            $str .= "<a href='javascript:void(0)'  style='margin-right:4px;color: #fff;background-color:#DC143C;padding:4px 8px;border-radius:5px;font-size:13px' onclick='dcdrk(this)' data-type='1'  data-id='".$v['id']."' data-num='".$v['num']."'>禁止入库</a>";
                        }else{
                            $str .= "<a href='javascript:void(0)'  style='margin-right:4px;color: #fff;background-color:#778899;padding:4px 8px;border-radius:5px;font-size:13px' onclick='dcdrk(this)' data-type='2'    data-id='".$v['id']."' data-num='".$v['num']."'>允许入库</a>";
                        }

                        if(empty($v['szkw'])){
                            $str .= "<a href='javascript:void(0)'  style='margin-right:4px;color: #fff;background-color:#9932CC;padding:4px 8px;border-radius:5px;font-size:13px' onclick='dcdyz(this)' data-type='1'    data-id='".$v['id']."' data-num='".$v['num']."'>禁止验证</a>";
                        }else{
                            $str .= "<a href='javascript:void(0)'  style='margin-right:4px;color: #fff;background-color:#00CED1;padding:4px 8px;border-radius:5px;font-size:13px' onclick='dcdyz(this)' data-type='2'    data-id='".$v['id']."' data-num='".$v['num']."'>允许验证</a>";   

                        }

                    }
                    $list[$k]['rk_time'] = $str;
                    unset($list[$k]['is_rk']);
                    unset($list[$k]['szkw']);
                }
    
    
                $total = $this->bhdcd->find_count($where);
                $pagenum = ceil($total/$perpage);
                $over = $total-($start+$perpage);
                $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($list));
                echo json_encode($rows);exit;
            }else{
                if(empty($lrdcd)){
                    echo json_encode(['success'=>false,'msg'=>'调出单号不可以为空']);exit;
                }
                $num = $this->bhdcd->find("dcd_no = '".$lrdcd."'");
                if(!empty($num)){
                    echo json_encode(['success'=>false,'msg'=>'调出单号已录入，不可重复录入']);exit;
                }
                //查询录入执行的调出单
                $token = $this->settingtest->get_yytoken_120();
                $res = $this->apiyyv1->cxDcdAboutErp($lrdcd,$token);
                if(empty($res[0]['Data'])){
                    echo json_encode(['success'=>false,'msg'=>'请检查调出单号，未在u9获取相关信息']);exit;
                }
                $time = time();
                $final_list = [];
                foreach($res[0]['Data'] as $k=>$v){
                    $good_info = $this->goods->find("jm = '".$v['iteminfo_itemcode']."' ");
                    $tmp_sku = '';
                    $tmp_title = '';
                    $tmp_features = '';
                    $tmp_number='';
                    if(!empty($good_info)){
                        $tmp_sku = $good_info['sku'];
                        $tmp_title = $good_info['title'];
                        $tmp_features = $good_info['features'];
                        $tmp_number = str_replace("-","", $good_info['features']);
                    }
                    $final_list[] = [
                        'sku'=>$tmp_sku,
                        'dcd_no'=>$v['docno'],
                        'jm'=>$v['iteminfo_itemcode'],
                        'zh'=>$v['iteminfo_itemname'],
                        'num'=>$v['costuomqty'],
                        'real_num'=>$v['costuomqty'],
                        'bh_no'=>$v['erp_no'],
                        'create_time'=>$time,
                        'title'=>$tmp_title,
                        'features'=>$tmp_features,
                        'number'=>$tmp_number,
                    ];
                }
                $r =$this->db->insert_batch('bhdcd',$final_list);
                if($r){
                    echo json_encode(['success'=>true,'msg'=>'录入成功']);
                }else{
                    echo json_encode(['success'=>false,'msg'=>'录入失败']);
                }
                exit;
            }

        }else{
            $status_list = $this->bhdcd->getStatus();
            $this->data['status_list'] = $status_list;
            $this->_Template('beihuogl_ckdcd',$this->data);
        }
    }

    private function _checkdcdsku($arg_array){
        $dcd_no = $arg_array[0];
        $list = $this->bhdcd->find_all("dcd_no = '".$dcd_no."' ");
        echo "<pre>";
        foreach($list as $k=>$v){
            if(empty($v['sku'])){
                $goods_info = $this->goods->find("jm = '".$v['jm']."' ");
                if(!empty($goods_info)){
                    $update_arr = [
                        'sku'=>$goods_info['sku'],
                        'title'=>$goods_info['title'],
                        'number'=>trim(str_replace("-","",$goods_info['features'])),
                        'features'=>$goods_info['features'],
                    ];
                    var_dump($update_arr);
                    $this->bhdcd->save($update_arr,$v['id']);
                }else{
                    var_dump($v['jm'].'的sku不存在');
                }
            }
        }
    }

    private function _ckbherprk($arg_array){
        if($this->input->method() === 'post'){
            $data = $this->input->post(null,true);
            $dcd_no = $data['dcd_no'];
            $drd_no = $data['drd_no'];
            $list = $this->bhdcd->find_all("dcd_no = '".$dcd_no."' and is_rk = 0");
            $spec_arr = $whlabel_arr = [];
            $time = time();
            $err_list= [];
            foreach($list as $k=>$v){
                if(empty($v['sku'])){
                    $err_list[] = $v['jm']."不存在";
                    continue;
                }
                //仓库不是特殊仓 且 设置了要校验库位
                if(($v['erp_warehouse'] != 12) && empty($v['szkw'])){
                    $tmp_info = $this->whlabel->find("warehouse = '".$v['erp_warehouse']."' and sku = '".$v['sku']."' and details != 'DZ001'  ","*","id desc");
                    if(!empty($tmp_info)){
                        if(!empty($tmp_info['details'])){
                           if($tmp_info['details'] != $v['kw']){
                                $err_list[] = $v['jm']."的库位信息";
                                continue;
                           }
                        }
                    }
                }
                if($v['erp_warehouse'] == '12'){
                    //特殊仓处理方案
                    for($i=0;$i<$v['num'];$i++){
                        $spec_arr[] = [
                            'purchase'=>1,
                            'sku'=>$v['sku'],
                            'number'=>$v['number'],
                            'features'=>$v['features'],
                            'featurespp'=>'',
                            'label'=>'',
                            'title'=>$v['title'],
                           // 'zh'=>$v['zh'],
                            'warehouse'=>$v['erp_warehouse'],
                            'enter'=>$time,
                            'state'=>0,
                            'retreatwarehouse'=>$v['erp_warehouse'],
                            'time'=>$time,
                            'details'=>$v['kw'],
                            'bs'=>1,
                            'rktype'=>9,
                        ];
                    }
                }else{
                    for($i=0;$i<$v['num'];$i++){
                        $whlabel_arr[] = [
                            'purchase'=>1,
                            'sku'=>$v['sku'],
                            'number'=>$v['number'],
                            'features'=>$v['features'],
                            'title'=>$v['title'],
                            'zh'=>$v['zh'],
                            'warehouse'=>$v['erp_warehouse'],
                            'enter'=>$time,
                            'state'=>0,
                            'retreatwarehouse'=>$v['erp_warehouse'],
                            'time'=>$time,
                            'details'=>$v['kw'],
                            'bs'=>1,
                            'rktype'=>9,
                        ];
                    }
                }
                
                
             }
             if(!empty($err_list)){
                echo json_encode(['success'=>false,'msg'=>implode('<br/>', $err_list)]);exit;
             }
             $this->db->trans_start();
             if(!empty($whlabel_arr)){
               $this->db->insert_batch('whlabel',$whlabel_arr);
             }
             if(!empty($spec_arr)){
                $this->db->insert_batch('specialstock',$spec_arr);
             }
            
             $this->db->where('dcd_no',$dcd_no);
             //$this->db->where('drd_no',$drd_no);
             $this->db->update('bhdcd',['status'=>3,'rk_time'=>$time,'is_rk'=>1]);

             if($this->db->trans_status() === FALSE){
                $this->db->trans_rollback();
                echo json_encode(['success'=>false,'msg'=>'录入失败']);exit;
             }else{
                $this->db->trans_commit();
                echo json_encode(['success'=>true,'msg'=>'录入成功']);
             }
        }else{
            $dcd_no = $arg_array[0];
            $list = $this->bhdcd->find_all("dcd_no = '".$dcd_no."'");
            $jm_list = array_column($list,'jm');
            
            $status_list = $this->bhdcd->getStatus();

            $in_where = "( ";
            foreach($jm_list as $k=>$v){
                $in_where .= "'".$v."',";
            }
            $in_where = rtrim($in_where,",");
            $in_where .= " )";
            $warehouse_list =  [
                12=>'特殊仓',
                13=>'许昌仓',
                16=>'定制头套仓'
            ];
            foreach($list as $k=>$v){
                $list[$k]['status_show'] = isset($status_list[$v['status']])?$status_list[$v['status']]:"";
                $list[$k]['drd_no'] = empty($v['drd_no'])?"":$v['drd_no'];
                $list[$k]['warehouse_show'] = isset($warehouse_list[$v['erp_warehouse']])?$warehouse_list[$v['erp_warehouse']]:"";
                if(!empty($v['kw'])){
                    $list[$k]['kw'] = $v['kw'];
                }else{
                    if(!empty($list[$k]['sku'])){
                        $whlabel_info = $this->whlabel->find(" warehouse = '13'  and (sku = '".$list[$k]['sku']."') and ( details != '' and details IS NOT NULL )","*","id desc");
                        if(!empty($whlabel_info)){
                            if(!empty($whlabel_info['details'])){
                                $list[$k]['kw'] = $whlabel_info['details'];
                                $this->bhdcd->save([
                                    'kw'=>$whlabel_info['details'],
                                ],$v['id']);
                            }else{
                                $list[$k]['kw'] = ""; 
                            }
                        }else{
                            $list[$k]['kw'] = "";
                        }
                    }else{
                        $list[$k]['kw'] = "";
                    }
                    
                }
                
                $list[$k]['create_time'] = empty($v['create_time'])?"":date("Y-m-d H:i:s",$v['create_time']);
            }
            $this->data['list'] = $list;
            $this->_Template('beihuogl_ckbherprk',$this->data);
        }
    }

    private function _bhdcdsave(){
       if($this->input->method() === 'post'){
          $id = $this->input->post('id',true);
          $val = $this->input->post('val',true);
          $column = $this->input->post('column',true);
          $info = $this->bhdcd->read($id);
          $update_arr = [];
          if($column == 'real_num'){
            if($val > $info['num']){
                echo json_encode(['success'=>false,'msg'=>'录入数量不能大于原数量']);exit;
            }
            $update_arr = [
                'real_num'=>(int)$val,
            ];
          }elseif($column == 'kw'){
            if($info['erp_warehouse'] == '12'){
                echo json_encode(['success'=>false,'msg'=>'特殊仓不设置库位']);exit;    
            }else{
                $winfo = $this->whlabel->find("warehouse = '13' and sku = '".$info['sku']."' ","*","id desc");
                if(!empty($winfo)){
                    $winfo = $this->whlabel->find("warehouse = '13' and sku = '".$info['sku']."' and details = '".$val."'","*","id desc");
                    if(empty($winfo)){
                        echo json_encode(['success'=>false,'msg'=>'请仔细核查该库位信息']);exit;
                    }
                }
                
                $update_arr = [
                    'kw'=>trim($val),
                ];
            }
            
          }elseif($column == 'ck'){
            $update_arr = [
                'erp_warehouse'=>trim($val),
            ];
          }else{
            echo json_encode(['success'=>false,'msg'=>'请求参数未设置']);exit;
          }
          $r = $this->bhdcd->save($update_arr,$id);
          if($r){
            echo json_encode(['success'=>true,'msg'=>'保存成功']);
          }else{
            echo json_encode(['success'=>false,'msg'=>'保存失败']);
          }
       }else{
         echo json_encode(['success'=>false,'msg'=>'请求方式错误']);exit;
       }
    }

    private function _u9scdexcel($arg_array){
        $id = $arg_array[0];
        $info = $this->bhccwl->read($id);
        $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' ");
        $shop_list = $this->shop->find_all("id > 0");
        $shop_list = array_column($shop_list,'shopname','id');
        foreach($list as $k=>$v){
            $list[$k]['shop_show'] = isset($shop_list[$v['shop_id']])?$shop_list[$v['shop_id']]:'';
        }
      
        	//生成excel
		$filename = $info['bh_no']."备货生产单.xls";
		$str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
		<head>
		<!--[if gte mso 9]><xml>
		<x:ExcelWorkbook>
		<x:ExcelWorksheets>
		<x:ExcelWorksheet>
		<x:Name>EXCEL</x:Name>
		<x:WorksheetOptions>
		<x:Print>
		<x:ValidPrinterInfo />
		</x:Print>
		</x:WorksheetOptions>
		</x:ExcelWorksheet>
		</x:ExcelWorksheets>
		</x:ExcelWorkbook>
		</xml>
		<![endif]-->
		</head><body>";
		$str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
		$str .= "<tr><td>备货单号</td><td>中文品名</td><td>u9料号</td><td>生产数量</td><td>u9生产单号</td><td>申请人</td><td>店铺</td><td>备注</td></tr>";
		foreach ($list as $key=>$value) 
		{ 
			
			$str .= "<tr>";
			$str .= "<td>". $value['bh_no']. "</td>";	
			$str .= "<td>". $value['title']. "</td>";	
			$str .= "<td>". $value['jm']. "</td>";
			$str .= "<td>". $value['ck_num']. "</td>";
			$str .= "<td>". $value['u9sc_no']. "</td>";
            $str .= "<td>". $value['sqr']. "</td>";
            $str .= "<td>". $value['shop_show']. "</td>";
            $str .= "<td>". $value['remark']. "</td>";

			$str .= "</tr>";
		}
		$str .= "</table></body></html>"; 
		header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
		header( "Content-type: application/octet-stream" ); 
		header( "Content-Disposition: attachment; filename=".$filename ); 
		header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
		header( "Pragma: no-cache" ); 
		header( "Expires: 0" ); 
		exit($str); 
		
    }
    //打印标签
    private function _printlabel(){
        if($this->input->method() === 'post'){
            $id = $this->input->post('id',true);
            $xbqnum = $this->input->post('num',true);
            $info = $this->bhdcd->read($id);
            if(empty($info)){
                echo json_encode(['success'=>false,'msg'=>'数据不存在']);exit;
            }

            $featurespp = str_replace(array('-163-', '-164-', '-165-', '-166-'), '-', $info['features']);
            $featurespp = explode('-', trim($featurespp, '-'));
            if (isset($featurespp[5])) {
                $tmp_featurespp = $featurespp[0] . '-' . $featurespp[3] . '-' . $featurespp[4] . '-' . $featurespp[5];
            } else {
                $tmp_featurespp = $featurespp[0] . '-' . $featurespp[3] . '-' . $featurespp[4];
            }
            $label = '';
            $cpid = $this->whlabellabel->find_count();
			$cpid = $cpid + 1;
            $time = time();
            $label = time().rand(10,99);
            $label = substr($label,1);
            $insert_arr = [
                'purchase'=>1,
                'shop'=>'',
                'sku'=>$info['sku'],
                'number'=>$info['number'],
                'features'=>$info['features'],
                'featurespp'=>$tmp_featurespp,
                'title'=>$info['title'],
                'label'=>$label,
                'warehouse'=>$info['erp_warehouse'],
                'time'=>$time,
                'details'=>empty($info['kw'])?'':$info['kw'],
                'cpid'=>$cpid,
                'jm'=>$info['jm'],
                'cpbz'=>''
            ];
            $warehouse_info = $this->warehouse->read($info['erp_warehouse']);
            if(empty($warehouse_info)){
                $warehouse_name = "仓库异常";
            }else{
                $warehouse_name = $warehouse_info['title'];
            }
            $this->db->trans_begin();
            $this->whlabellabel->insert($insert_arr);
            if ($this->db->trans_status() === TRUE) {
                $this->db->trans_commit();
            } else {
                $this->db->trans_rollback();
                echo json_encode(array('msg' => '错误，请重试！', 'success' => false));
                exit;
            }
            if(empty($info['kw'])){
                $details = '<font style="font-size: 18px;">' . $cpid . '</font>' ;
            }else{
                $details = '位置：(' . $info['kw'] . ') <font style="font-size: 18px;">' . $cpid . '</font>' ;
            }
            
			$details = ' <b style="font-size: 18px;">'.$warehouse_name."</b>  ".$details;
            $purchase = "龙盈工厂";
            echo json_encode(array('title' => $info['title'], 'num' => $label, 'bqsku' => $info['sku'], 'xbqnum' => $xbqnum, 'zh' => str_replace('自然色 ', '', rtrim($info['zh'], ' ')), 'details' => $details, 'purchase' => $purchase, 'cpbz' => "", 'usa' => 0, 'success' => true));
            exit; //特殊仓目前不需要仓库选项
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求方式错误']);exit;
        }
    }

    private function _dcdjzrk(){
        if($this->input->method() === 'post'){
            $id = $this->input->post('id',true);
            $type = $this->input->post('type',true);
            $is_rk = 0;
            if($type == 1){
                $is_rk = 1;
            }else{
                $is_rk = 0;
            }


            $info = $this->bhdcd->read($id);

            if($info['is_rk'] != $is_rk){
                $this->bhdcd->save(['is_rk'=>$is_rk],$id);
                echo json_encode(['success'=>true,'msg'=>'修改成功']);exit;
            }else{
                if($type ==1){
                   echo json_encode(['success'=>false,'msg'=>'此条信息已禁止入库']);exit;
                }else{
                   echo json_encode(['success'=>false,'msg'=>'此条信息已允许入库']);exit;
                }
            }
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求方式错误']);exit;
        }

    }

    private function _dyapplyyjsh(){
        if($this->input->method() === 'post'){
            $arr_id = $this->input->post('arr_id',true);
            $this->db->where_in('id',$arr_id);
            $this->db->where('sq_status',1);
            $this->db->update('bhsq',['sq_status'=>2]);
            echo json_encode(['success'=>true,'msg'=>'审核通过']);exit;
        }else{
            echo json_encode(['success'=>false,'msg'=>'请求方式错误']);exit;
        }
    }

    private function _dcdkwyz(){
        if($this->input->method() === 'post'){
            $id = $this->input->post('id',true);
            $type = $this->input->post('type',true);
            $szkw = 0;
            if($type == 1){
                $szkw = 1;
            }else{
                $szkw = 0;
            }
            $info = $this->bhdcd->read($id);
            if($info['szkw'] != $szkw){
                $this->bhdcd->save(['szkw'=>$szkw],$id);
                echo json_encode(['success'=>true,'msg'=>'修改成功']);exit;
            }else{
                if($type ==1){
                  echo json_encode(['success'=>false,'msg'=>'此条信息已禁止验证库位']);exit;
                }else{  
                 echo json_encode(['success'=>false,'msg'=>'此条信息已允许验证库位']);exit;
                }
            }

        }else{
            echo json_encode(['success'=>false,'msg'=>'请求方式错误']);exit;
        }
    }

    private function _ckexcel($arg_array){
        $id = $arg_array[0];
        $info = $this->bhccwl->read($id);
        $list = $this->bhsq->find_all("bh_no = '".$info['bh_no']."' ");
      
        	//生成excel
		$filename = $info['bh_no']."备货生产单.xls";
		$str = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">
		<head>
		<!--[if gte mso 9]><xml>
		<x:ExcelWorkbook>
		<x:ExcelWorksheets>
		<x:ExcelWorksheet>
		<x:Name>EXCEL</x:Name>
		<x:WorksheetOptions>
		<x:Print>
		<x:ValidPrinterInfo />
		</x:Print>
		</x:WorksheetOptions>
		</x:ExcelWorksheet>
		</x:ExcelWorksheets>
		</x:ExcelWorkbook>
		</xml>
		<![endif]-->
		</head><body>";
		$str .= "<table border=1 style='font-family: Microsoft Yahei;font-size: 13px;'>"; 
		$str .= "<tr><td>备货单号</td><td>中文品名</td><td>u9料号</td><td>生产数量</td></tr>";
		foreach ($list as $key=>$value) 
		{ 
			
			$str .= "<tr>";
			$str .= "<td>". $value['bh_no']. "</td>";	
			$str .= "<td>". $value['title']. "</td>";	
			$str .= "<td>". $value['jm']. "</td>";
			$str .= "<td>". $value['ck_num']. "</td>";
			$str .= "</tr>";
		}
		$str .= "</table></body></html>"; 
		header( "Content-Type: application/vnd.ms-excel; name='excel'" ); 
		header( "Content-type: application/octet-stream" ); 
		header( "Content-Disposition: attachment; filename=".$filename ); 
		header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); 
		header( "Pragma: no-cache" ); 
		header( "Expires: 0" ); 
		exit($str); 
    }
}