erp/core/CoreApp/controllers/Whlabel_bh.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Whlabel_bh extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
		$this->load->_model('Model_whlabel_bh','whlabel_bh');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_purchase','purchase');
		$this->load->_model('Model_excel','excel');
		$this->load->_model('Model_fullorder','fullorder');
		$this->load->_model('Model_fullordertt','fullordertt');
		$this->load->_model('Model_fullorder_smt','fullorder_smt');
		$this->load->_model('Model_fullordersmt','fullordersmt');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_typeclass','typeclass');
		$this->load->_model('Model_country','country');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_kdniao','kdniao');
		$this->load->_model('Model_notice','notice');
		$this->load->_model('Model_dhl','dhl');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_fullorderexcel','fullorderexcel');
		$this->load->_model('Model_ljg','ljg');
		$this->load->_model('Model_usps','usps');
		$this->load->_model('Model_specialstock','specialstock');
		$this->load->_model('Model_whlabellabel','whlabellabel');
		$this->load->_model('Model_whlabelwz','whlabelwz');
		$this->load->_model('Model_whlabelbarcode','whlabelbarcode');
		$this->load->_model('Model_whlabeltransport','whlabeltransport');
		$this->load->_model('Model_orderurl','orderurl');
		$this->load->_model('Model_brand','brand');
		$this->load->_model('Model_classid','classid');
		$this->load->_model('Model_apiyy','apiyy');
		$this->load->_model('Model_whlabel_bh_list','whlabel_bh_list');
		$this->load->_model('Model_whlabel','whlabel');
		$this->load->_model('Model_whlabel_bh_transfer','whlabel_bh_transfer');
		$this->load->_model('Model_transfer','transfer');
		$this->load->_model("Model_logic_u9tools","logic_u9tools");
		$this->load->_model("Model_logic_ding","logic_ding");
		$this->load->_model("Model_apiyyv1","apiyyv1");
		$this->load->_model('Model_settingtest','settingtest');
		$this->load->_model("Model_whlabel_bh_transfer_cr","whlabel_bh_transfer_cr");
		$this->load->_model("Model_zzquque_u9","zzquque_u9");
	}
	//定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
		if($arg == 'add')
        {
             $this->_add();
        }
		else if($arg == 'edit')
        {
             $this->_edit($arg_array);
        }
		else if($arg == 'del')//删除
        {
             $this->_del();
        }
		else if($arg == 'deltransfer')//删除
        {
             $this->_deltransfer();
        }
		else if($arg == 'cz')//删除
        {
             $this->_cz();
        }
		else if($arg == 'db')//删除
        {
             $this->_db();
        }
		else if($arg == 'kc')//删除
        {
             $this->_kc();
        }
		else if($arg == 'excel')//删除
        {
             $this->_excel();
        }
		else if($arg == 'xxpl')//删除
        {
             $this->_xxpl();
        }
		else if($arg == 'bbprint')//删除
        {
             $this->_bbprint();
        }
		else if($arg == 'operate')
        {
             $this->_operate();
        }
		else if($arg == 'out')
        {
             $this->_out();
        }
		else if($arg == 'bdbb')
        {
             $this->_bdbb();
        }
		else if($arg == 'rk')
        {
             $this->_rk();
        }
		else if($arg == 'ck')
        {
             $this->_ck();
        }
		else if($arg == 'ck')
        {
             $this->_ck();
        }
		else if($arg == 'transfer_log'){
			 $this->_transfer_log();
		}
		else if($arg == 'transfer_detail'){
			$this->_transfer_detail($arg_array);
		}
		else if($arg == 'cj_transfer_log'){
			$this->_cj_transfer_log();
		}
		else if($arg == 'cj_transfer_detail'){
			$this->_cj_transfer_detail($arg_array);
		}
		else if($arg == 'cj_transfer_log_count'){
			$this->_cj_transfer_log_count();
		}
		else if($arg == 'excelwchz'){
			$this->_excelwchz();
		}
		else
		{
			 $this->_index();
		}
    }

	//管理
	public function _index()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$jm = $this->input->post('jm',true);
			$title = $this->input->post('title',true);
			$pm = $this->input->post('pm',true);
			$category = $this->input->post('category',true);
			$size = $this->input->post('size',true);
			$grade = $this->input->post('grade',true);
			$color = $this->input->post('color',true);
			$lowe = $this->input->post('lowe',true);
			$type = $this->input->post('type',true);
			$shipremarks = $this->input->post('shipremarks',true);
			$type = $this->input->post('type',true);
			$state = $this->input->post('state',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 ";
			if($timetk && $timetj)
            {
                $where .= " and time > '$timetk' and time < '$timetj'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo like '%$orderinfo%'";
            }
			if($type != '')
            {
                $where  .= " and type = '$type'";
            }
			if($jm)
            {
                $where  .= " and jm like '%$jm%'";
            }
			if($title)
            {
                $where  .= " and title like '%$title%'";
            }
			if($pm)
            {
                $where  .= " and pm like '%$pm%'";
            }
			if($category)
            {
                $where  .= " and shipremarks like '%-$category-%'";
            }
			if($size)
            {
                $where  .= " and shipremarks like '%-$size-%'";
            }
			if($grade)
            {
                $where  .= " and shipremarks like '%-$grade-%'";
            }
			if($color)
            {
                $where  .= " and shipremarks like '%-$color-%'";
            }
			if($lowe)
            {
                $where  .= " and shipremarks like '%-$lowe-%'";
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($state)
            {
                $where  .= " and state = '$state'";
            }
			if($shipremarks)
            {
                $where  .= " and shipremarks like '%$shipremarks%'";
            }
            //数据排序
            $order_str = "time desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			$warehouse = $this->warehouse->find_all();
			$ck = array();
			foreach ($warehouse as $v) 
		    {
				$ck[$v['id']] = $v['title'];
			}
            //取得信息列表
            $info_list = $this->whlabel_bh->find_all($where,'id,orderinfo,title,shipremarks,bhnum,printnum,num,time,extra_type',$order_str,$start,$perpage);
			foreach ($info_list as $key=>$value) 
		    {
				$d = $this->whlabel_bh->read($value['id']);
				$info_list[$key]['title'] =  "<font data-id='".$value['id']."' data-cz='0' class='whlabel_bh_cz'>".$d['jm'].'</font><br><strong style="color:#fc5454;font-weight: bold;">'.$d['pm'].'</strong><br>'.$value['title'];
				$printnum = $this->whlabel_bh_transfer->find_all("number = '".$d['number']."'");
				$printnum = array_sum(array_column($printnum,'ts'));
				$info_list[$key]['printnum'] = $printnum;
				$info_list[$key]['num'] = $value['bhnum']-$printnum;
				$info_list[$key]['time'] = date('Y-m-d',$value['time']).'<br>'.date('H:i:s',$value['time']);
				if($value['extra_type'] == 1){
					$info_list[$key]['extra_type'] =  "<span data-id='".$value['id']."' data-num='".$value['bhnum']."' class='whlabel_bh_print'>打印布标</span>";
				}else{
					$info_list[$key]['extra_type'] = "";
				}
				
		    }
		    $total = $this->whlabel_bh->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
			
			/**
			$info_list = $this->whlabel_bh->find_all($where,'id,orderinfo,title,shipremarks,bhnum,kcnum,num,rknum,dbnum,state,time,scapi,dbapi',$order_str,$start,$perpage);
			foreach ($info_list as $key=>$value) 
		    {
				$d = $this->whlabel_bh->read($value['id']);
				if($d['print'] == 0)
				{
					$print = "<p style='margin-top:15px;'><span data-id='".$value['id']."' data-num='".$value['num']."' class='whlabel_bh_print' style='background: #2ca8a1;'>未打印</span></p>";
				}
				else
				{
					$print = "<p style='margin-top:15px;'><span data-id='".$value['id']."' data-num='".$value['num']."' class='whlabel_bh_print' style='background: #999;'>已打印</span></p>";
				}
				if($value['state'] == 0)
				{
					$info_list[$key]['state'] = "<p>待生产/外购</p><p><span data-id='".$value['id']."' data-cz='0' class='whlabel_bh_cz'>传输料号</span></p>";//开 始
				}
				else if($value['state'] == 1)
				{
					$info_list[$key]['state'] = "<p>生产/外购中</p><p><span data-id='".$value['id']."' data-cz='1' class='whlabel_bh_ks'>完成入库</span></p>".$print;
				}
				else if($value['state'] == 2)
				{
					$info_list[$key]['state'] = "<p>已完成</p><p>已全部入库</p>";
				}
				$info_list[$key]['time'] = date('Y-m-d',$value['time']).'<br>'.date('H:i:s',$value['time']);
				$info_list[$key]['title'] =  $d['jm'].'<br><strong style="color:#fc5454;font-weight: bold;">'.$d['pm'].'</strong><br>'.$value['title'];
				$zd = $this->whlabel_bh_list->find_all("uid = '".$value['id']."'");
				$zc = '';
				foreach ($zd as $v) 
		    	{
					$zc .= $ck[$v['warehouse']].'转入 - '.$v['num'].'<br>';
				}
				$info_list[$key]['scapi'] =  $zc;
				$info_list[$key]['dbapi'] =  "<span data-id='".$value['id']."' class='whlabel_bh_db'>调拨出库</span>";
				$info_list[$key]['dbnum'] =  array_sum(array_column($zd,'num'));
		    }
			**/
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
		}
		else
		{
			header('Location: /');exit;
		}
		$w = $this->shop->find_all("yyid != ''");
		$this->data['yyck'] = $w;
		if($user['userid'] == 'ch')
		{
			$user['vip'] = 1;
		}
		$this->data['vip'] = $user['vip'];
		$this->_Template('whlabel_bh',$this->data);
	}
	
	//入库操作
	public function _add()
	{
		$tc = $this->typeclass->find_all();
		$typeclass = array();
		foreach ($tc as $v)
		{
			$tcjm[$v['id']] = array($v['jm'],$v['classid']);
			$typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm'],'bqsku'=>$v['bqsku']);
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['num']))
		{
			$list = array();
			$sku = $this->input->post('sku',true);
			$category = $this->input->post('category',true);
			$list['category'] = $category;
			$list['hairtype'] = $this->input->post('hairtype',true);
			$list['grade'] = $this->input->post('grade',true);
			$size = $this->input->post('size',true);
			$xzsku = $this->input->post('xzsku',true);
			$list['size'] = rtrim($size,',');
			$list['hairnumber'] = $this->input->post('hairnumber',true);
			$list['extension'] = $this->input->post('extension',true);
			if($category == 1297)
			{
				$list['sywignumber'] = $this->input->post('sywignumber',true);
			}
			if($category == 1702)
			{
				$list['syhairnumber'] = $this->input->post('syhairnumber',true);
				$list['syother'] = $this->input->post('syother',true);
			}
			if($category == 133)
			{
				$list['fittype'] = $this->input->post('fittype',true);
				$list['acother'] = $this->input->post('acother',true);
			}
			$list['color'] = $this->input->post('color',true);
			$list['lowe'] = $this->input->post('lowe',true);
			if($category == 127)
			{
				$list['type'] = $this->input->post('type',true);
				$list['headroad'] = $this->input->post('headroad',true);
				$list['density'] = $this->input->post('density',true);
				if($list['type'] == 195 || $list['type'] == 197 || $list['type'] == 199)
				{
					$list['lacesize'] = $this->input->post('lacesize',true);
				}
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
			}
			if($category == 128)
			{
				$list['lacetype'] = $this->input->post('lacetype',true);
				$list['haircap'] = $this->input->post('haircap',true);
				$list['density'] = $this->input->post('density',true);
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
				$list['wigother'] = $this->input->post('wigother',true);
				$list['wigother1'] = $this->input->post('wigother1',true);
				$list['wigother2'] = $this->input->post('wigother2',true);
			}
			if($category == 129)
			{
				$list['wide'] = $this->input->post('wide',true);
			}
			
			if($category == 131)
				{
					$list['gifttype'] = $this->input->post('gifttype',true);
					$list['giftother'] = $this->input->post('giftother',true);
				}
			
			if($category == 134)
			{
				$list['pieceweight'] = $this->input->post('pieceweight',true);
			}
			if($category == 1297)
			{
				$list['synthetictype'] = $this->input->post('synthetictype',true);
				$list['sywigother'] = $this->input->post('sywigother',true);
			}
			if($category == 130 || $category == 133 || $category == 1702)
			{
				$list['items'] = $this->input->post('items',true);
				$list['weight'] = $this->input->post('weight',true);
			}
			if($category == 1702)
			{
				$list['syhairther'] = $this->input->post('syhairther',true);
			}
			$classid = $this->classid->sku();
			$pm = $classid;
		    $jm = $classid;
			$sku = $sku;
			$title = '';$features = '';$cs = array();
			$bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
			foreach($list as $k=>$v)
			{
				if(isset($typeclass[$v]) && isset($bmpx[$typeclass[$v]['classid']]))
				{
					if($typeclass[$v]['bm'] != '')
					{
						$bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
					}
				}
				if($v != 0)
				{
					if($k != 'size')
					{
			            $title .= $typeclass[$v]['title']." ";
					}
					$features .=$v.'-';
					$sku[$typeclass[$v]['classid']] = $typeclass[$v]['bqsku'];
					if(isset($pm[$typeclass[$v]['classid']]))
					{
						if($typeclass[$v]['title'] == '9A')
						{
							$pm[$typeclass[$v]['classid']] = '9A';
						}
						else if($typeclass[$v]['title'] == '10A')
						{
							$pm[$typeclass[$v]['classid']] = '10A';
						}
						else
						{
							$clzh = $typeclass[$v]['zh'];
							if(stripos($typeclass[$v]['zh'],'|') !== false)
							{
								$clzh = explode('|',rtrim($typeclass[$v]['zh'],'|'));
								$clzh = $clzh[0];
							}
							$pm[$typeclass[$v]['classid']] = $clzh;
						}
					}
					if(isset($jm[$typeclass[$v]['classid']]))
					{
						if($typeclass[$v]['jm'])
						{
						    $jm[$typeclass[$v]['classid']] = $typeclass[$v]['jm'];
						}
					}
				}
			}
			$jm = array_filter($jm);//去除空值
			$jm = implode("-",$jm);
			$sku = array_filter($sku);//去除空值
			$sku = implode("-",$sku);
			$pm = array_filter($pm);//去除空值
			$pm = implode(" ",$pm);
			$pm = preg_replace("/\r\n|\r|\n/",'',trim($pm,' '));
			if($list['size'])
			{
			    $typeclass = $this->typeclass->read($list['size']);
			    $title .= $typeclass['title'];
			}
			$title = trim($title,' ');
			
			$post['num'] = $this->input->post('num',true);
			$ztime = $this->input->post('ztime',true);
			$post['ztime'] = strtotime($ztime);
			$post['bm'] = '03'.implode("",$bmpx);
			$post['jm'] = $jm;
			$post['sku'] = $sku;
			$post['pm'] = $pm;
			$post['title'] = $title;
			$post['features'] = '-'.$features;
			$post['number'] = date('YmdHis',time()).rand(1000,9999);
			if(!$post['num'])
			{
			    $post['number'] = date("YmdHis").rand(1000,9999);
			}
			$time = time();
			$post['time'] = $time;//操作时间
			$post['printnum'] = $time;
			$post['type'] = 0;
			$post['extra_type'] = (int)trim($post['extra_type'],',');
			
			//传输料号开始
			$lc = 0;
			$lh = $this->apiyy->get_cjlp(array('jm'=>$post['jm'],'title'=>$post['title'],'zh'=>$post['pm'],'bm'=>$post['bm']));
			if(isset($lh['Data'][0]))
			{
				if($lh['Data'][0]['m_isSucess'] != 1)
				{
					if($lh['Data'][0]['m_errorMsg'] != '料号 已存在，请重新输入！')
					{
						echo json_encode(array('msg'=>$lh['Data'][0]['m_errorMsg'],'bm'=>$post['bm'],'jm'=>$post['jm'],'success'=>false));exit;
					}
				}
			}
			else
			{
				echo json_encode(array('msg'=>'料号错误','cs'=>$lh,'success'=>false));exit;
				
			}
			
			if($this->whlabel_bh->insert($post))
			{
			    echo json_encode(array('msg'=>'添加成功','cs'=>$cs,'success'=>true));exit;
			}
			else
			{
				echo json_encode(array('msg'=>'添加失败，请重试','success'=>false));exit;
			}
		}
		$w = $this->shop->find_all("yyid != ''");
		$this->data['yyck'] = $w;
		$purchase = $this->purchase->find_all("yyid != ''");
		$this->data['purchase'] = $purchase;
		$this->data['data'] = (isset($_GET['data']))?$_GET['data']:'';
		$this->_Template('whlabel_bh_add',$this->data);
	}
	
	
	public function get_cjlp($data)//创建料品
	{
		$list["0"]["Code"] = $data['jm'];//料号，SKU
		$list["0"]["Code1"] = '';
        $list["0"]["Name"] = $data['zh'];//产品名称
        $list["0"]["MainItemCategory"]["Code"] = $data['bm'];
        $list["0"]["Org"]["Code"] = 001;
        $list["0"]["OtherID"] = 1;
		$list["0"]["PurchaseInfo"]["BudgetControlType"] = -1;
        $list["0"]["PurchaseInfo"]["PriceSource"] = 2;
        $list["0"]["PurchaseInfo"]["InquireRule"] = -1;
        $list["0"]["PurchaseInfo"]["InquireFixedPeriod"] = 0;
        $list["0"]["PurchaseInfo"]["StatisticPeriod"] = -1;
        $list["0"]["PurchaseInfo"]["IsPUTradePathModify"] = true;
        $list["0"]["PurchaseInfo"]["IsPURtnTradePathModify"] = true;
        $list["0"]["InventoryUOM"]["Code"] = '条';
        $list["0"]["InventorySecondUOM"]["Code"] = '';
        $list["0"]["IsDualUOM"] = false;
        $list["0"]["InventoryInfo"]["InventoryPlanningMethod"] = 4;
        $list["0"]["InventoryInfo"]["InventoryPlanTime"] = -1;
        $list["0"]["InventoryInfo"]["TurnOverRate"] = 1;
        $list["0"]["InventoryInfo"]["ReserveMode"] = -1;
        $list["0"]["InventoryInfo"]["SupplyMethod"] = -1;
        $list["0"]["DescFlexField"]["PrivateDescSeg1"] = 01;
        $list["0"]["DescFlexField"]["PubDescSeg5"] = 01;
        $list["0"]["Description"] = $data['title'];
        $list["0"]["ItemForm"] = 2001;
        $list["0"]["ItemFormAttribute"] = 10;
        $list["0"]["IsInventoryEnable"] = true;
        $list["0"]["IsPurchaseEnable"] = true;
        $list["0"]["IsSalesEnable"] = true;
        $list["0"]["IsBuildEnable"] = true;
        $list["0"]["IsOutsideOperationEnable"] = true;
        $list["0"]["IsMRPEnable"] = true;
        $list["0"]["IsBOMEnable"] = true;
        $list["0"]["IsCostCalByGrade"] = false;
        $list["0"]["IsCostCalByPotency"] = false;
        $list["0"]["IsGradeControl"] = false;
        $list["0"]["StandardGrade"] = -1;
        $list["0"]["StartGrade"] = -1;
        $list["0"]["EndGrade"] = -1;
        $list["0"]["IsPotencyControl"] = false;
        $list["0"]["StandardPotency"] = -1;
        $list["0"]["StartPotency"] = -1;
        $list["0"]["EndPotency"] = -1;
		$asd = $list;
		$list = json_encode($list);
		$token = $this->setting->get_yytoken_130();
		$url = 'http://172.31.105.167/U9C/webapi/ItemMaster/Create';
		$header[] = "Content-Type: application/json";
        $header[] = "Token: ".$token;
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
		curl_setopt($ch, CURLINFO_HEADER_OUT, TRUE);
		curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $list);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
        $res = curl_exec($ch);
		$res = json_decode($res,true);

		return $asd;
	}
	
	
	//修改产品
	public function _edit($arg_array)
	{
		$tc = $this->typeclass->find_all();
		$typeclass = array();
		foreach ($tc as $v)
		{
			$tcjm[$v['id']] = array($v['jm'],$v['classid']);
			$typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm'],'bqsku'=>$v['bqsku']);
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))
		{
			$id = $this->input->post('id',true);
			$list = array();
			$sku = $this->input->post('sku',true);
			$category = $this->input->post('category',true);
			$list['category'] = $category;
			$list['hairtype'] = $this->input->post('hairtype',true);
			$list['grade'] = $this->input->post('grade',true);
			$size = $this->input->post('size',true);
			$xzsku = $this->input->post('xzsku',true);
			$list['size'] = rtrim($size,',');
			$list['hairnumber'] = $this->input->post('hairnumber',true);
			$list['extension'] = $this->input->post('extension',true);
			if($category == 1297)
			{
				$list['sywignumber'] = $this->input->post('sywignumber',true);
			}
			if($category == 1702)
			{
				$list['syhairnumber'] = $this->input->post('syhairnumber',true);
				$list['syother'] = $this->input->post('syother',true);
			}
			if($category == 133)
			{
				$list['fittype'] = $this->input->post('fittype',true);
				$list['acother'] = $this->input->post('acother',true);
			}
			$list['color'] = $this->input->post('color',true);
			$list['lowe'] = $this->input->post('lowe',true);
			if($category == 127)
			{
				$list['type'] = $this->input->post('type',true);
				$list['headroad'] = $this->input->post('headroad',true);
				$list['density'] = $this->input->post('density',true);
				if($list['type'] == 195 || $list['type'] == 197 || $list['type'] == 199)
				{
					$list['lacesize'] = $this->input->post('lacesize',true);
				}
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
			}
			if($category == 128)
			{
				$list['lacetype'] = $this->input->post('lacetype',true);
				$list['haircap'] = $this->input->post('haircap',true);
				$list['density'] = $this->input->post('density',true);
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
				$list['wigother'] = $this->input->post('wigother',true);
				$list['wigother1'] = $this->input->post('wigother1',true);
				$list['wigother2'] = $this->input->post('wigother2',true);
			}
			if($category == 129)
			{
				$list['wide'] = $this->input->post('wide',true);
			}
			
			if($category == 131)
				{
					$list['gifttype'] = $this->input->post('gifttype',true);
					$list['giftother'] = $this->input->post('giftother',true);
				}
			
			if($category == 134)
			{
				$list['pieceweight'] = $this->input->post('pieceweight',true);
			}
			if($category == 1297)
			{
				$list['synthetictype'] = $this->input->post('synthetictype',true);
				$list['sywigother'] = $this->input->post('sywigother',true);
			}
			if($category == 130 || $category == 133 || $category == 1702)
			{
				$list['items'] = $this->input->post('items',true);
				$list['weight'] = $this->input->post('weight',true);
			}
			if($category == 1702)
			{
				$list['syhairther'] = $this->input->post('syhairther',true);
			}
			$classid = $this->classid->sku();
			$pm = $classid;
		    $jm = $classid;
			$sku = $sku;
			$title = '';$features = '';$cs = array();
			$bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
			foreach($list as $k=>$v)
			{
				if(isset($typeclass[$v]) && isset($bmpx[$typeclass[$v]['classid']]))
				{
					if($typeclass[$v]['bm'] != '')
					{
						$bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
					}
				}
				if($v != 0)
				{
					if($k != 'size')
					{
			            $title .= $typeclass[$v]['title']." ";
					}
					$features .=$v.'-';
					$sku[$typeclass[$v]['classid']] = $typeclass[$v]['bqsku'];
					if(isset($pm[$typeclass[$v]['classid']]))
					{
						if($typeclass[$v]['title'] == '9A')
						{
							$pm[$typeclass[$v]['classid']] = '9A';
						}
						else if($typeclass[$v]['title'] == '10A')
						{
							$pm[$typeclass[$v]['classid']] = '10A';
						}
						else
						{
							$clzh = $typeclass[$v]['zh'];
							if(stripos($typeclass[$v]['zh'],'|') !== false)
							{
								$clzh = explode('|',rtrim($typeclass[$v]['zh'],'|'));
								$clzh = $clzh[0];
							}
							$pm[$typeclass[$v]['classid']] = $clzh;
						}
					}
					if(isset($jm[$typeclass[$v]['classid']]))
					{
						if($typeclass[$v]['jm'])
						{
						    $jm[$typeclass[$v]['classid']] = $typeclass[$v]['jm'];
						}
					}
				}
			}
			$jm = array_filter($jm);//去除空值
			$jm = implode("-",$jm);
			$sku = array_filter($sku);//去除空值
			$sku = implode("-",$sku);
			$pm = array_filter($pm);//去除空值
			$pm = implode(" ",$pm);
			$pm = preg_replace("/\r\n|\r|\n/",'',trim($pm,' '));
			if($list['size'])
			{
			    $typeclass = $this->typeclass->read($list['size']);
			    $title .= $typeclass['title'];
			}
			$title = trim($title,' ');
			
			$post['num'] = $this->input->post('num',true);
			$ztime = $this->input->post('ztime',true);
			$post['ztime'] = strtotime($ztime);
			$post['bm'] = '03'.implode("",$bmpx);
			$post['jm'] = $jm;
			$post['sku'] = $sku;
			$post['pm'] = $pm;
			$post['title'] = $title;
			$post['features'] = '-'.$features;
		
			$ztime = $this->input->post('ztime',true);
			if($ztime)
			{
			    $post['ztime'] = strtotime($ztime);
			}
			
			if($this->whlabel_bh->save($post,$id))
			{
			    echo json_encode(array('msg'=>'修改成功','id'=>$id,'success'=>true));exit;
			}
			else
			{
				echo json_encode(array('msg'=>'修改失败，请重试','success'=>false));exit;
			}
		}
		$w = $this->shop->find_all("yyid != ''");
		$this->data['yyck'] = $w;
		$whlabel_bh = $this->whlabel_bh->read($arg_array[0]);
		$this->data['whlabel_bh'] = $whlabel_bh ;
		$purchase = $this->purchase->find_all("yyid != ''");
		$this->data['purchase'] = $purchase;
		$this->_Template('whlabel_bh_edit',$this->data);
	}
	
	public function _cz()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))  
		{
		    $id = $this->input->post('id',true);
		    $cz = $this->input->post('cz',true);
		    $num = $this->input->post('num',true);
			$cz = $cz+1;
            $w = $this->whlabel_bh->read($id);
			if(!$w)
			{
				echo json_encode(array('msg'=>'操作的信息不存在！','success'=>false));exit;
			}
			
			//传输料号开始
			$lc = 0;
			$lh = $this->apiyy->get_cjlp(array('jm'=>$w['jm'],'title'=>$w['title'],'zh'=>$w['pm'],'bm'=>$w['bm']));
			if(isset($lh['Data'][0]))
			{
				if($lh['Data'][0]['m_isSucess'] != 1)
				{
					if($lh['Data'][0]['m_errorMsg'] != '料号 已存在，请重新输入！')
					{
						echo json_encode(array('msg'=>$lh['Data'][0]['m_errorMsg'],'bm'=>$w['bm'],'jm'=>$w['jm'],'success'=>false));exit;
					}
				}
			}
			else
			{
				echo json_encode(array('msg'=>'料号错误','cs'=>json_encode($lh),'success'=>false));exit;
				
			}
			echo json_encode(array('msg'=>'操作成功！'.$lh['Data'][0]['m_isSucess'],'id'=>$id,'typetext'=>'传输料号','text'=>'','num'=>0,'cs'=>$lh,'bm'=>$w['bm'],'success'=>true));
			/** 投产
			
			
			if($w['scapi'] != 99)
			{
			    if($w['state'] == $cz)
			    {
				    echo json_encode(array('msg'=>'请刷新页面后再进行操作！','success'=>false));exit;
			    }
				if($w['type'] == '0')
				{
					$type = '生产';
					$bhlx = 0;
				}
				else
				{
					$type = '外购';
					$bhlx = 1;
				}
				$yy = $this->apiyy->_peihuo($w,$w['kh'],$w['orderinfo'],$w['num'],2000);
			    if($yy['c'] == 0)
			    {
					if($this->whlabel_bh->save(array('state'=>$cz,'scapi'=>99,'scid'=>$yy['scid'],'sctime'=>time()),$id))
				    {
					    echo json_encode(array('msg'=>'操作成功！','id'=>$id,'typetext'=>'已操作','text'=>$type.'中','success'=>true));
				    }
				    else
				    {
					    echo json_encode(array('msg'=>'写入数据失败，请联系技术人员 ID：'.$w['id'].' - C：'.$cz,'success'=>false));
				    }
			    }
			    else
			    {
				    echo json_encode(array('msg'=>$yy['error'],'a'=>1,'success'=>false));exit;
			    }
			}
			else if($w['dbapi'] != 99 && $w['type'] == '0')
			{
				$cz = 1;
				if(!is_numeric($num))
				{
					echo json_encode(array('msg'=>'数量填写错误！','success'=>false));exit;
				}
				if($num > $w['num']-$w['rknum'])
				{
					echo json_encode(array('msg'=>'完成数量大于生产总数量！','success'=>false));exit;
				}
				if($w['rknum']+$num == $w['num'])
				{
					$dbapi = 99;
					$cz = 2;
				}
				else
				{
					$dbapi = 0;
				}
				$w['ts'] = $num;
			    $rk = $this->apiyy->_newrk($w);
				if($rk['c'] == 0)
				{
					if($this->whlabel_bh->save(array('state'=>$cz,'rknum'=>$w['rknum']+$num,'dbapi'=>$dbapi,'scid'=>$rk['scid']),$id))
				    {
						if($dbapi == 99)
						{
					        echo json_encode(array('msg'=>'操作成功！','id'=>$id,'typetext'=>'已全部入库','text'=>'已完成','num'=>$w['rknum']+$num,'success'=>true));
						}
						else
						{
							echo json_encode(array('msg'=>'操作成功！','id'=>$id,'typetext'=>'入库'.$num.'成功','text'=>'生产中','num'=>$w['rknum']+$num,'success'=>true));
						}
				    }
				    else
				    {
					    echo json_encode(array('msg'=>'写入数据失败，请联系技术人员 ID：'.$w['id'].' - C：'.$cz,'success'=>false));
				    }
				}
				else
				{
					$this->whlabel_bh->save(array('dbapi'=>$rk['dbapi'],'scid'=>$rk['scid']),$id);
					echo json_encode(array('msg'=>$rk['error'],'success'=>false));exit;
				}
			}
			else if($w['dbapi'] != 99 && $w['type'] == '1')
			{
				$cz = 1;
				if(!is_numeric($num))
				{
					echo json_encode(array('msg'=>'数量填写错误！','success'=>false));exit;
				}
				if($num > $w['num']-$w['rknum'])
				{
					echo json_encode(array('msg'=>'完成数量大于外购总数量！','success'=>false));exit;
				}
				if($w['rknum']+$num == $w['num'])
				{
					$dbapi = 99;
					$cz = 2;
				}
				else
				{
					$dbapi = 0;
				}
				$scid = explode('~',$w['scid']);
				$rkdata = array('od'=>$scid[1],'ts'=>$num,'title'=>$w['title']);
				if($this->whlabel_bh->save(array('state'=>$cz,'rknum'=>$w['rknum']+$num,'dbapi'=>99),$id))
				 	    {
							if($dbapi == 99)
							{
					        	echo json_encode(array('msg'=>'操作成功！','id'=>$id,'typetext'=>'已全部入库','text'=>'已完成','num'=>$w['rknum']+$num,'success'=>true));
							}
							else
							{
								echo json_encode(array('msg'=>'操作成功！','id'=>$id,'typetext'=>'入库'.$num.'成功','text'=>'生产中','num'=>$w['rknum']+$num,'success'=>true));
							}
						}
						else
			 	  	    {
							echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
			 	  	    }
			}
			**/
			
			
		}
	}
	
	
	public function _db()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))  
		{
		    $id = $this->input->post('id',true);
			$num = $this->input->post('num',true);
		    $warehouse = $this->input->post('warehouse',true);
			$w = $this->warehouse->read($warehouse);
			$data = $this->whlabel_bh->read($id);
			if(!$data)
			{
				echo json_encode(array('msg'=>'此备货信息已被删除','success'=>false));exit;
			}
			$d = $this->whlabel_bh_list->find_all("uid = '".$id."'");
			$ydbnum = sprintf("%01.2f",array_sum(array_column($d,'num')));
			if($num > $data['rknum']-$ydbnum)
			{
				echo json_encode(array('msg'=>'调拨数量不允许大于(备货入库数量-已调拨数量）','success'=>false));exit;
			}
			$data['dccbm'] = 13001;//默认从许昌仓调出
			$data['ts'] = $num;
			$data['drcbm'] = $w['yybm'];
			$dc = $this->apiyy->get_cpdc($data);
				if(isset($dc['Data'][0]))
		    	{
					if($dc['Data'][0]['IsSucess'] != 1)
					{
						echo json_encode(array('msg'=>$dc['Data'][0]['ErrorMsg'].'-1','success'=>false));exit;
					}
					else
					{
						$sh = $this->apiyy->get_order_sh($data,'SO/Submit','SO/Approve',130);
						if(isset($sh['Data'][0]))
						{
							$code = $sh['Data'][0]['Code'];
							echo json_encode(array('msg'=>$sh['Data'][0]['ErrorMsg'].'-2','success'=>false));
						}
						else
						{
							$code = '';
							echo json_encode(array('msg'=>'调出成功！','success'=>true));
						}
						$p['uid'] = $id;
							$p['bm'] = $data['bm'];
							$p['sku'] = $data['jm'];
							$p['shipremarks'] = $data['shipremarks'];
							$p['title'] = $data['title'];
							$p['zh'] = $data['pm'];
							$p['fpdata'] = $data['features'];
							$p['num'] = $num;
							$p['warehouse'] = 13;//默认从许昌仓调出
							$p['rwarehouse'] = $warehouse;
							$p['time'] = time();//操作时间
							$p['code'] = $code;
							$this->whlabel_bh_list->insert($p);
					}
				}
				else
				{
					echo json_encode(array('msg'=>json_encode($dc),'success'=>false));exit;
				}
		}
	}
	
	
	
	public function _del()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',trim($id_arr,','));
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
            }
            //循环删除记录
            foreach ($id_arr as $v) 
		    {
				$w = $this->whlabel_bh->read($v);
				if($w['state'] > 0)
				{
					// echo json_encode(array('msg'=>'有已投产产品，无法删除！','success'=>true));exit;
				}
            }
			foreach ($id_arr as $v) 
		    {
				$this->whlabel_bh->remove($v);
			}
            echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));
		}
    }
	
	public function _deltransfer()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',trim($id_arr,','));
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
            }
			if(count($id_arr) > 1)
            {
                echo json_encode(array('msg'=>'为防止删错，每次只可删除一条数据！请检查','success'=>false));exit;
            }
			foreach ($id_arr as $v) 
		    {
				$this->whlabel_bh_transfer->remove($v);
			}
            echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));
		}
    }
	
	public function _kc()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['category']))  
		{
		    $list = array();
			$sku = $this->input->post('sku',true);
			$features = $this->input->post('features',true);
			$category = $this->input->post('category',true);
			$list['category'] = $category;
			$list['hairtype'] = $this->input->post('hairtype',true);
			$list['grade'] = $this->input->post('grade',true);
			$size = $this->input->post('size',true);
			$xzsku = $this->input->post('xzsku',true);
			$list['size'] = rtrim($size,',');
			$list['hairnumber'] = $this->input->post('hairnumber',true);
			$list['extension'] = $this->input->post('extension',true);
			if($category == 1297)
			{
				$list['sywignumber'] = $this->input->post('sywignumber',true);
			}
			if($category == 1702)
			{
				$list['syhairnumber'] = $this->input->post('syhairnumber',true);
				$list['syother'] = $this->input->post('syother',true);
			}
			if($category == 133)
			{
				$list['fittype'] = $this->input->post('fittype',true);
				$list['acother'] = $this->input->post('acother',true);
			}
			$list['color'] = $this->input->post('color',true);
			$list['lowe'] = $this->input->post('lowe',true);
			if($category == 127)
			{
				$list['type'] = $this->input->post('type',true);
				$list['headroad'] = $this->input->post('headroad',true);
				$list['density'] = $this->input->post('density',true);
				if($list['type'] == 195 || $list['type'] == 197 || $list['type'] == 199)
				{
					$list['lacesize'] = $this->input->post('lacesize',true);
				}
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
			}
			if($category == 128)
			{
				$list['lacetype'] = $this->input->post('lacetype',true);
				$list['haircap'] = $this->input->post('haircap',true);
				$list['density'] = $this->input->post('density',true);
				$list['lacecolor'] = $this->input->post('lacecolor',true);
				$list['lacetypes'] = $this->input->post('lacetypes',true);
				$list['wigother'] = $this->input->post('wigother',true);
				$list['wigother1'] = $this->input->post('wigother1',true);
				$list['wigother2'] = $this->input->post('wigother2',true);
			}
			if($category == 129)
			{
				$list['wide'] = $this->input->post('wide',true);
			}
			
			if($category == 131)
				{
					$list['gifttype'] = $this->input->post('gifttype',true);
					$list['giftother'] = $this->input->post('giftother',true);
				}
			
			if($category == 134)
			{
				$list['pieceweight'] = $this->input->post('pieceweight',true);
			}
			if($category == 1297)
			{
				$list['synthetictype'] = $this->input->post('synthetictype',true);
				$list['sywigother'] = $this->input->post('sywigother',true);
			}
			if($category == 130 || $category == 133 || $category == 1702)
			{
				$list['items'] = $this->input->post('items',true);
				$list['weight'] = $this->input->post('weight',true);
			}
			if($category == 1702)
			{
				$list['syhairther'] = $this->input->post('syhairther',true);
			}
			$shipremarks = '';
			$bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
			foreach($list as $k=>$v)
			{
				if($v != 0)
				{
					$shipremarks .=$v.'-';
				}
			}
			$shipremarks = '-'.$shipremarks;
			if($features)
			{
				$shipremarks = $features;
			}
		    $w = $this->whlabel->find_count("features = '$shipremarks' and state = '0' and zd = '' and warehouse = '13'");//默认许昌仓
			if($w > 0)
			{
			    echo json_encode(array('msg'=>$w,'success'=>true));exit;
			}
			else
			{
				 echo json_encode(array('msg'=>'没有可用库存','cs'=>$shipremarks,'success'=>false));
			}
		}
	}
	
	
	
	public function _excel()
	{
		$classid = $this->classid->sku();
		$pm = $classid;
		$typeclass = array();
		$tc = $this->typeclass->find_all();
		foreach ($tc as $v)
		{
			$typeclass[$v['id']] = $v;
		}
		$prc = array();
		$purchase = $this->purchase->find_all();
		foreach($purchase as $k=>$v)
		{
			$prc[$v['id']] = $v['title'];
		}
		if(isset($_GET['excel']))  
		{
			$number = $this->input->post('number',true);
			$sku = $this->input->post('sku',true);
			$title = $this->input->post('title',true);
			$pm = $this->input->post('pm',true);
			$category = $this->input->post('category',true);
			$size = $this->input->post('size',true);
			$grade = $this->input->post('grade',true);
			$color = $this->input->post('color',true);
			$lowe = $this->input->post('lowe',true);
			$state = $this->input->post('state',true);
			$shipremarks = $this->input->post('shipremarks',true);
			$type = $this->input->post('type',true);
			$sid = $this->input->get('sid',true);
			$ktime = $this->input->get('ktime',true);
			$jtime = $this->input->get('jtime',true);
			$ktime = strtotime($ktime);
			$jtime = strtotime($jtime);
			$where = "1=1";$gj = "";$ck = "";
			if($number)
            {
                $where  .= " and number like '%$number%'";
            }
			if($type != '')
            {
                $where  .= " and type = '$type'";
            }
			if($sku)
            {
                $where  .= " and sku like '%$sku%'";
            }
			if($title)
            {
                $where  .= " and title like '%$title%'";
            }
			if($pm)
            {
                $where  .= " and pm like '%$pm%'";
            }
			if($category)
            {
                $where  .= " and shipremarks like '%-$category-%'";
            }
			if($size)
            {
                $where  .= " and shipremarks like '%-$size-%'";
            }
			if($grade)
            {
                $where  .= " and shipremarks like '%-$grade-%'";
            }
			if($color)
            {
                $where  .= " and shipremarks like '%-$color-%'";
            }
			if($lowe)
            {
                $where  .= " and shipremarks like '%-$lowe-%'";
            }
			if($state)
            {
                $where  .= " and state = '$state'";
            }
			if($shipremarks)
            {
                $where  .= " and shipremarks like '%$shipremarks%'";
            }
			$sidwhere = '';
			if($sid)
            {
				$sd = "";
				$s = explode(',',trim($sid,','));
				foreach ($s as $value) 
		    	{
					$sd .= " id = ".$value." or";
				}
                $sidwhere  = " and (".rtrim($sd,'or').")";
            }
            //数据排序
            $order_str = "time desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
			
				/**
				$info_list = $this->whlabel->find_all($where.$sidwhere,'*');
				$rows = array();$list = array();
				foreach ($info_list as $key=>$value) 
		    	{
					$rows[strtolower($value['sku']).'warehouse'.$value['warehouse']] = $value;//所有数据sku
		    	}
				**/
				$warehouse = $this->warehouse->find_all();
			$ck = array();
			foreach ($warehouse as $v) 
		    {
				$ck[$v['id']] = $v['title'];
			}
				$list = array();
				$rows = $this->whlabel_bh->find_all($where.$sidwhere,'state,orderinfo,number,jm,title,pm,shipremarks,bhnum,kcnum,num,rknum,dbnum,id,sctime,time');
				foreach ($rows as $key=>$value) 
		    	{
					if($value['state'] == 0)
					{
						$rows[$key]['state'] = "待生产/外购";
					}
					else if($value['state'] == 1)
					{
						$rows[$key]['state'] = "生产/外购中";
					}
					else if($value['state'] == 2)
					{
						$rows[$key]['state'] = "已完成";
					}
					$zd = $this->whlabel_bh_list->find_all("uid = '".$value['id']."'");
					$zc = '';
					foreach ($zd as $v) 
		    		{
						$zc .= $ck[$v['warehouse']].'转入 - '.$v['num'].'<br>';
					}
					$rows[$key]['id'] =  $zc;
					$rows[$key]['dbnum'] =  array_sum(array_column($zd,'num'));
					$rows[$key]['sctime'] =  ($value['sctime']>0)?date('Y-m-d',$value['sctime']):'未记录';
					$rows[$key]['time'] =  date('Y-m-d H:i:s',$value['time']);
		    	}
            	$title = '备货详情'; 
            	$titlename = "<table border=1>
            	<tr align='center'>
				<td>状态</td>
				<td>标题</td>
				<td>流水码</td>
				<td>简码</td>
				<td>英文</td>
			    <td>中文</td>
				<td>备注</td>
            	<td>备货数量</td>
				<td>库存数量</td>
				<td>生产/外购数量</td>
				<td>入库数量</td>
            	<td>调拨数量</td>
            	<td>调拨详情</td>>
				<td>生产时间</td>>
				<td>操作时间</td>>
            	</tr>
            	</table>"; 
            	$filename = $title.".xls";
				$tail = "";
            	$this->excel->get_fz2($rows,$titlename,$filename,$tail);
			}
	    
	}
	
	
	public function _xxpl()
	{
		/*  订单加入键值-j  */
		$dir = '/data/excel/'.date('Ymd',time()).'/';
		$config['upload_path'] = '.'.$dir ;
		$config['file_name'] = date('Ymd_His_',time()).rand(1000,9999);
        $config['allowed_types'] = 'xls|xlsx|csv';
        $config['max_size'] = 10240;
		$this->load->library('upload', $config);
		$this->upload->initialize($config);
        if ($this->upload->do_upload('userfile'))
        {
			$full_path = $dir.$this->upload->data('file_name');
			$fileName = '.' . $full_path;
            if (!file_exists($fileName)) 
			{
				echo json_encode(array('msg'=>"上传失败，请重试",'success'=>false));exit;
            }
			else
			{
				require_once "./data/excel/PHPExcel/IOFactory.php";
				@$phpExcel = PHPExcel_IOFactory::load($fileName);// 载入当前文件
				@$phpExcel->setActiveSheetIndex(0);// 设置为默认表
				$sheetCount = $phpExcel->getSheetCount();// 获取表格数量
				$row = $phpExcel->getActiveSheet()->getHighestRow();// 获取行数
				$column = $phpExcel->getActiveSheet()->getHighestColumn();// 获取列数
				++$column;//如果列数大于26行
				$list = array();
				for ($i = 2; $i <= $row; $i++) // 行数循环
				{
					$data = array();
                    for ($c = 'A'; $c != $column; $c++)  // 列数循环
	                {
						$data[] = $phpExcel->getActiveSheet()->getCell($c . $i)->getValue();
                    }
					$list[] = $data;
                }
			}
			$tc = $this->typeclass->find_all();
			$typeclass = array();
			foreach ($tc as $v)
			{
				$typeclass[$v['jm']] = array('id'=>$v['id'],'zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm'],'bqsku'=>$v['bqsku']);
			}
			$i = 0;$j = 0;$ed = array();
			$classid = $this->classid->sku();
			$typeclassid = [];
			foreach($tc as $v){
				$typeclassid[$v['id']] = array('id'=>$v['id'],'zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm'],'bqsku'=>$v['bqsku']);
			}
			$i = 0;$j = 0;$ed = [];
			$ck = [
				"成品仓"=>'99001',
				"美国仓"=>'02031',
				"AP"=>'0103001',
				"WK"=>'0103002',
				"QV"=>'0103003',
				"AS"=>'0103004',
				"H"=>"0103005",
				"AP英"=>"0103006",
				"YMS"=>"0103007",
				"AP新"=>"0103008",
				"WK新"=>"0103009",
				"H新"=>"0103010",
				"Bilisar"=>"0103011",
				"Estilar"=>"0103012",
				"QM"=>"0103013",
				"Afola"=>"0103014",
				"拼多多-Finsa"=>"0106002",
				"拼多多-艾彩"=>"0105001",
				"拼多多-Estilar"=>"0106001",
				"拼多多-QM"=>"0106003",
			];
			foreach($list as $k=>$v){
				
				$res = $this->logic_u9tools->getGoodInfoByErpSku($v[0],$v[1],$typeclass,$typeclassid,$classid);
				if($res['code']==1){
					//传输料号开始
					$post = $res['data'];
					$post['number'] = $post['number'].$k;
					$post['orderinfo'] = $v[2];
					$post['num'] = $v[5];
					$post['state'] = ($v[3] == '生产')?0:1;
					$post['purchase'] = "";//供货商
					$post['shipremarks'] = empty($v[6])?" ":$v[6];//
					$post['rknum'] = 0;
					$post['scapi'] = 0;
					$post['dbapi'] = 0;
					$post['bhnum'] = $v[5];
					$post['extra_type'] = (strpos($v[2],"美国销售-") !== false)?1:0;
					if(isset($ck[$v[4]])){
						$post['kh'] = $ck[$v[4]];
					}else{
						$j++;
						$ed[] = array('添加失败，请重试',$post['jm'],$post['bm']);
						continue;
					}
					

					$lh = $this->apiyy->get_cjlp(array('jm'=>$post['jm'],'title'=>$post['title'],'zh'=>$post['pm'],'bm'=>$post['bm']));
					$this->logic_ding->sendToDing("备货批量导入出现的错误信息".json_encode($lh,JSON_UNESCAPED_UNICODE));
					if(isset($lh['Data'][0]))
					{
						if($lh['Data'][0]['m_isSucess'] != 1)
						{
							if($lh['Data'][0]['m_errorMsg'] != '料号 已存在，请重新输入！')
							{
								$j++;
								$ed[] = array($lh['Data'][0]['m_errorMsg'],$post['jm'],$post['bm']);
							}
						}
					}
					else
					{
						$j++;
						$ed[] = array('料号错误',$post['jm'],$post['bm']);
					}

					if($this->whlabel_bh->insert($post))
					{
						$i++;
					}
					else
					{
						$j++;
						$ed[] = array('添加失败，请重试',$post['jm'],$post['bm']);
					}
				}else{
					$j++;
					$ed[] = array($res['msg'],$v[1],"");	
				}
			}
			if($j > 0)
			{
				$time = date('Ymd',time());
				$title = '错误信息-'.$time;
        		$titlename = "<table border=1><tr><td>错误详情</td></tr></table>";
				$tail = "\n";
        		$filename = $title.".xls";
        		@$ecl = $this->excel->get_fz3($ed,$titlename,$filename,$tail);
				$dir = '/data/excel/'.$time.'/';
				$file_name = 'error_'.$time.rand(1000,9999);
				if(!is_dir('.'.$dir))mkdir('.'.$dir,0777);
				$myfile = fopen(".".$dir.$file_name.".xls", "w") or die();
				fwrite($myfile,$ecl);
				fclose($myfile);
				$error = $dir.$file_name.'.xls';
				echo json_encode(array('msg'=>$j.'条异常，','error'=>$error,'success'=>true));exit;
			}
			else
			{
				echo json_encode(array('msg'=>'添加成功!'.$i,'error'=>1,'success'=>true));exit;
			}
        }
		else
		{
			echo json_encode(array('msg'=>'上传失败！','t'=>$this->upload->display_errors(),'success'=>false));exit;
		}
    }
	
	
	public function _cslh($jm,$title,$pm,$bm)
	{
			$lh = $this->apiyy->get_cjlp(array('jm'=>$jm,'title'=>$title,'zh'=>$pm,'bm'=>$bm));
			if(isset($lh['Data'][0]))
			{
				if($lh['Data'][0]['m_isSucess'] != 1)
				{
					if($lh['Data'][0]['m_errorMsg'] != '料号 已存在，请重新输入！')
					{
						return array('msg'=>$lh['Data'][0]['m_errorMsg'],'x'=>1);exit;
					}
				}
			}
			else
			{
				return array('msg'=>'料号错误','x'=>1);exit;
				
			}
			return array('x'=>2);exit;
		
	}
	
	
	public function _bbprint()
	{
		$time = time();
		$post = $this->input->post(NULL);
			if(isset($post['d']))
			{
				$order = 0;$time = time();
				$d = $this->input->post('d',true);
				$n = $this->input->post('n',true);//打印数量
				$data = $this->whlabel_bh->read($d);
				if(!$data)
				{
					echo json_encode(array('msg'=>'未找到此备货信息，请刷新页面重试','success'=>false));exit;
				}
				$printnum = $this->whlabel_bh_transfer->find_all("number = '".$data['number']."'");
				$printnum = array_sum(array_column($printnum,'ts'));
				if(($data['bhnum'] + 1)-$printnum-$n < 0)
				{
					echo json_encode(array('msg'=>'打印数量不可超出备货数量！','success'=>false));exit;
				}
				$post['number'] = $data['number'];
				$post['orderinfo'] = $data['orderinfo'];
				$post['type'] = 0;//0生产 1外购
		        $post['features'] = $data['features'];
				$post['jm'] = $data['jm'];
				$post['bm'] = $data['bm'];
				$post['pm'] = $data['pm'];
				$post['sku'] = $data['sku'];
				$post['features'] = $data['features'];
				$post['number'] = $data['number'];
				$post['title'] = $data['title'];
				$post['printtime'] = $time;
				$post['ts'] = 1;
				// $post['rk'] = "";//默认订单中心 打印后直接入库
				// $post['rktime'] = "";
				// $post['ctime15'] = $time;
				$post['time'] = $time;
				$post['gtime'] = date('Yms',$time);
				$post['wbid'] = $data['id'];
				$rows = array();
				$label = date("ymdHis").rand(1000,9999);
				$post['label'] = $label;
				

				// if($this->whlabel_bh_transfer->insert($post))
				// {
				// 	echo json_encode(array('rows'=>($rows),'id'=>$d,'success'=>true));exit;
			    // }
			    // else
			    // {
				// 	$this->db->trans_rollback();
				//     echo json_encode(array('msg'=>'错误，请重试！','success'=>false));exit;
			    // }


				if(stripos($post['features'],'-126-') !== false)
				{
					$drck = '12003';//进入发条库
				}
				else if(stripos($post['features'],'-127-') !== false)
				{
					$drck = '12004';//进入发块库
				}
				else
				{
					$drck = '12006';//其它进入完成库
				}
				//创建u9的生产单
				$token = $this->settingtest->get_yytoken_120();
				$params = [
					'org_code'=>"120",
					'djhlx'=>'2000',
					'scbm_code'=>"12008",
					"time"=>time(),
					'owner_org_code'=>"120",
					'title'=>$post['orderinfo'],
					'shipremarks'=>$data['shipremarks'],
					'list'=>[
						[
							'drck'=>$drck,
							'jm'=>$post['jm'],
							'sl'=>$n,
							'drck'=>$drck,
						]
					]
				];
				
				$res = $this->apiyyv1->scdCreate($params,$token);
				$this->logic_ding->sendToDing("【".$post['orderinfo']."-".$data['id']."】生产备货同步u9||".json_encode($res,JSON_UNESCAPED_UNICODE));
				if(!isset($res[0]['Data'])){
					echo json_encode(array('msg'=>'u9同步返回异常，请重试！','success'=>false));exit;
				}
				if(!$res[0]['Data'][0]['m_isSucess']){
					echo json_encode(array('msg'=>'u9同步失败，请重试！','success'=>false));exit;
				}
				$scid = $res[0]['Data'][0]['m_iD']."~".$res[0]['Data'][0]['m_code']."~".$drck;
				$post['scid'] = $scid;
				$post['scapi'] = 1;
				$post['dbapi'] = 0;
				$this->db->trans_begin();
				$post['shipremarks'] = $data['shipremarks'];
				for($i = 0;$i < $n;$i++){
					$post['label'] = $label.$i;
					$rows[] = array('num'=>$post['label'],'title'=>$data['orderinfo'],'jm'=>$data['pm'],'n'=>1);
					$this->whlabel_bh_transfer->insert($post);
				}
				
				if ($this->db->trans_status() === TRUE)
				{
					$this->db->trans_commit();
					echo json_encode(array('rows'=>($rows),'id'=>$d,'success'=>true));exit;
				}else{
					$this->db->trans_rollback();
					echo json_encode(array('msg'=>'错误，请重试！','success'=>false));exit;
				}

				


				
			}
	}

	
	public function _bdbb()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',trim($id_arr,','));
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>$v.' - 未查询到需要补打信息！','success'=>false));exit;
            }
            //循环删除记录
            foreach ($id_arr as $v) 
		    {
                $t = $this->whlabel_bh_transfer->read($v);
				if(!isset($t['number']))
				{
					echo json_encode(array('msg'=>$v.' - 补打信息已被删除！','success'=>false));exit;
				}
				$rows[] = array('num'=>$t['label'],'title'=>'补：'.$t['orderinfo'],'jm'=>$t['jm'],'n'=>1);
            }
            echo json_encode(array('rows'=>($rows),'success'=>true));exit;
		}
    }
	public function _out()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['label']))
		{
			$time = time();
			$label = $this->input->post('label',true);
			$cz = $this->input->post('cz',true);
			$transfer = $this->input->post('transfer',true);
			if(!$label)
			{
				echo json_encode(array('msg'=>'未扫入数据！','success'=>false));exit;
			}
			if(!$transfer)
			{
				echo json_encode(array('msg'=>'请选择需对应的部门！','success'=>false));exit;
			}
			$lb = $this->whlabel_bh_transfer->get_label($label);
			if(!$lb)
			{
				echo json_encode(array('msg'=>'错误！未找到此条码','success'=>false));exit;
			}
			$lbrk = array_reverse(explode('|',trim($lb['rk'],'|')));
			$lbck = array_reverse(explode('|',trim($lb['ck'],'|')));
			$tdata = $this->transfer->find_all();
			$t = array();
			foreach ($tdata as $v)
		    {
				$t[$v['id']] = $v['title'];
			}
			if($cz == 1)
			{
				if($lb['rk'] != $lb['ck'])//判断是否没走完流程就拿到下一步奏
				{
					echo json_encode(array('msg'=>$t[$lbrk[0]].'还未出库，无法入库！','success'=>false));exit;
				}
			}
			if($cz == 2 && $lbrk[0] != $transfer)//判断是否没走完流程就拿到下一步奏
			{
				echo json_encode(array('msg'=>$t[$transfer].'还未入库，无法出库！','success'=>false));exit;
			}
			if($cz == 1)
			{
				$lb['rk'] .= $transfer.'|';
				$lb['rktime'] .= $time.'|';
				if($lbrk[0] == $transfer)
				{
					echo json_encode(array('msg'=>'已有入库记录，不可连续重复录入！','success'=>false));exit;
				}
				//必须走配货
				if(($transfer != 1) && (strpos($lb['rk'],'|1|') === false) ){
					echo json_encode(array('msg'=>'请先到配货！','success'=>false));exit;
				}
			}
			else if($cz == 2)
			{
				$lb['ck'] .= $transfer.'|';
				$lb['cktime'] .= $time.'|';
				if($lbck[0] == $transfer)
				{
					echo json_encode(array('msg'=>'已有出库记录，不可连续重复录入！','success'=>false));exit;
				}
			}

			$cztime = 'ctime'.$transfer;
			//如果是完成扫出 这样会通知erp生成一个调出单  
			//中转库如果扫出的话 应该是马尾  其它的没有
			if(($transfer == 3 || $transfer == 13) && $cz == 2 && $lb['dbapi'] < 99){

				$this->db->trans_begin();
				$this->whlabel_bh_transfer->save(array('rk'=>$lb['rk'],'rktime'=>$lb['rktime'],'ck'=>$lb['ck'],'cktime'=>$lb['cktime'],'time'=>$time,'gtime'=>date('YmdH',$time),$cztime=>$time,'status'=>2,'dbapi'=>99),$lb['id']);
				$this->whlabel_bh_transfer_cr->insert(['fid'=>$lb['id'],'lx'=>$transfer,'type'=>$cz,'time'=>time(),'is_over'=>1,'number'=>$lb['number']]);
				$ct_info = $this->whlabel_bh_transfer_cr->find("fid = ".$lb['id']." and lx = ".$transfer." and type = 1 and is_over = 0","*",'id desc');
				if($ct_info){
					$this->whlabel_bh_transfer_cr->save(['is_over'=>1],$ct_info['id']);
				}
				$this->zzquque_u9->insert([
					'platform'=>'',
					'warehouse'=>0,
					'type'=>21,     
					'order_no'=>$lb['orderinfo'],
					'child_order_no'=>$lb['id'],
					'status'=>0,
					'create_time'=>time(),
					'update_time'=>time(),
				]);
				if ($this->db->trans_status() === TRUE){
					$this->db->trans_commit();
					echo json_encode(array('music'=>'1','success'=>true));exit;
				}else{
					$this->db->trans_rollback();
					echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
				}
				
			}

			
			//if(($transfer == 3 && $lb['dbapi'] < 99 && $cz == 2) || ($transfer == 13 && $lb['dbapi'] < 99 && $cz == 1))//出入库用这个
			if($transfer == 11 && stripos($lb['rk'],'|8|') === false && stripos($lb['ck'],'|3|') === false &&  stripos($lb['rk'],'|13|') === false)//改出入库 需要调整8为3 由完成出库检测
			{
				echo json_encode(array('msg'=>'工厂未出库，请退回工厂！','success'=>false));exit;
			}
			$save_data = [
				'rk'=>$lb['rk'],'rktime'=>$lb['rktime'],'ck'=>$lb['ck'],'cktime'=>$lb['cktime'],'time'=>$time,'gtime'=>date('YmdH',$time),$cztime=>$time
			];
			//配货入库需更新一下配货状态
			if($transfer == 1 && $cz == 2 && $lb['status'] == 0){
				$save_data['status'] = 1;
			}
			$this->db->trans_begin();
			$this->whlabel_bh_transfer->save($save_data,$lb['id']);
			if($cz == 2){
				$this->whlabel_bh_transfer_cr->insert(['fid'=>$lb['id'],'lx'=>$transfer,'type'=>$cz,'time'=>time(),'is_over'=>1,'number'=>$lb['number']]);
				$ct_info = $this->whlabel_bh_transfer_cr->find("fid = ".$lb['id']." and lx = ".$transfer." and type = 1 and is_over = 0","*",'id desc');
				if($ct_info){
					$this->whlabel_bh_transfer_cr->save(['is_over'=>1],$ct_info['id']);
				}
			}else{
				$this->whlabel_bh_transfer_cr->insert(['fid'=>$lb['id'],'lx'=>$transfer,'type'=>$cz,'time'=>time(),'is_over'=>0,'number'=>$lb['number']]);
			}
			
			if ($this->db->trans_status() === TRUE){
				$this->db->trans_commit();
				echo json_encode(array('music'=>'1','success'=>true));exit;
			}else{
				$this->db->trans_rollback();
				echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
			}
		}
	}
	protected function getOperateList(){
		    $api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$orderinfo = $this->input->post('number',true);
			$color = $this->input->post('color',true);
			$pm = $this->input->post('pm',true);
			$purchase = $this->input->post('purchase',true);
			$transfer = $this->input->post('transfer',true);
			$lx = $this->input->post('lx',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1";
			if($transfer)
			{
				$ctime = 'ctime'.$transfer;
			    $where  .= " and $ctime > '$timetk' and $ctime < '$timetj'";
			}
			else
			{
				$where  .= " and time > '$timetk' and time < '$timetj'";
			}
			if($orderinfo)
            {
                $where  .= " and orderinfo like '%$orderinfo%'";
            }
			if($transfer)
            {
                $where  .= " and rk like '%|".$transfer."|%'";
            }
			if($purchase)
            {
                $where  .= " and purchase = '$purchase'";
            }
			if($pm)
            {
                $where  .= " and pm like '%$pm%'";
            }
			if($color)
            {
                $where  .= " and fpdata like '%-".$color."-%'";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->whlabel_bh_transfer->find_all($where,'id,orderinfo,pm,shipremarks,ts,printtime,time',$order_str,$start,$perpage);
			$transfer = $this->transfer->find_all();
			$t = array();$ot = array();
			foreach ($transfer as $v)
		    {
				$t[$v['id']] = $v['title'];
				$ot[$v['id']] = ($v['orvertime']>0)?$v['orvertime']*24*3600:0;
			}
			 //格式化数据
            foreach ($info_list as $key=>$value)
		    {
				$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
				$log_list= $this->whlabel_bh_transfer_cr->find_all("fid = ".$value['id']);
				$tmp_operate_str = "";
				foreach($log_list as $k=>$v){
					$tmp_operate_str.= $t[$v['lx']]."".($v['type']==1?'入库':'出库')."：".date('Y-m-d H:i:s',$v['time'])."<br>";
				}

				$info_list[$key]['time'] = trim($tmp_operate_str,'<br>');
            }
		    $total = $this->whlabel_bh_transfer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'where'=>$where);
		    return $rows;
	}
	
	public function _operate()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$rows = $this->getOperateList();
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$kx = '';$zjtab = '';
		$warehouse = $this->warehouse->find_all('1=1 and '.rtrim($wid,'or'),"*","px asc");
		$this->data['warehouse'] = $warehouse;
		$purchase = $this->purchase->find_all("yyid != ''");
		$this->data['purchase'] = $purchase;
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		$this->data['transfer'] = $transfer;
		$ids = array_column($transfer,'id');
		$end_time = strtotime(date('Y-m-d')) + 24 * 60 * 60;
		$start_time = $end_time - 14 * 24 * 60 * 60;

		//$count  =  $this->whlabel_bh_transfer_cr->find_count("type = 1 and is_over = 0 and lx in (".implode(",",$ids).") and time >= ".$start_time." and time <= ".$end_time );
		//$this->data['count'] = $count;
		$this->data['vip'] = $user['vip'];
		$this->_Template('whlabel_bh_operate',$this->data);
	}
	


	public function _rk()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$res = $this->getOperateList();
		    $rows = array('total'=>$res['total'],'over'=>$res['over'],'pagenum'=>$res['pagenum'],'rows'=>($res['rows']),'cs'=>$res['where']);
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		$this->data['transfer'] = $transfer;
		$this->_Template('whlabel_bh_rk',$this->data);
	}
	
	
	public function _ck()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$res = $this->getOperateList();
		    $rows = array('total'=>$res['total'],'over'=>$res['over'],'pagenum'=>$res['pagenum'],'rows'=>($res['rows']),'cs'=>$res['where']);
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		$this->data['transfer'] = $transfer;
		$this->_Template('whlabel_bh_ck',$this->data);
	}
	//备货流转记录表
	public function _transfer_log(){
		$post = $this->input->post(NULL, TRUE);
		if($post){
			$page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$where = " extra_type = 1 ";
			$orderinfo = $this->input->post('orderinfo',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			if($timetk && $timetj)
            {
                $where .= " and time > '$timetk' and time < '$timetj'";
            }
			if($orderinfo){
				$where.= " and orderinfo like '%$orderinfo%' ";
			}
			if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			$list = $this->whlabel_bh->find_pc($where,'orderinfo',"id,orderinfo",'id desc',$start,$perpage);
	

			$rows = [];
			foreach($list as $k=>$v){
				$tmp_order_info = $this->whlabel_bh->find_all(" orderinfo = '".$v['orderinfo']."'","id,orderinfo,bhnum");
				$tmp_ids = [];
				$tmp_bhnum = 0;
				foreach($tmp_order_info as $vv){
					$tmp_ids[] = $vv['id'];
					$tmp_bhnum += $vv['bhnum'];
				}

				$ydysl = $wdysl = $yphsl = $yjgsj = $wwgsl = 0;
				if(!empty($tmp_ids)){
					$list = $this->whlabel_bh_transfer->find_all(" wbid in (".implode(",",$tmp_ids).")");
					foreach($list as $vv){
						$ydysl += 1;
						if($vv['status'] == 1){
							$yphsl += 1;
						}
						if($vv['status'] == 2){
							$yjgsj += 1;
						}
					}
				}

				
				
				
				$rows[$k]['id'] = $v['id'];
				$rows[$k]['orderinfo'] = "<h9 class='window' data-h='/whlabel_bh/transfer_detail/".$v['id']."' data-t='备货单号：".$v['orderinfo']."'><p>".$v['orderinfo']."</p></h9>" ;
				$rows[$k]['ddsl'] = $tmp_bhnum;   //订单数量
				$rows[$k]['ydysl'] = $ydysl;	 //已打印数量
				$rows[$k]['wdysl'] = $tmp_bhnum - $ydysl;  //未打印数量
				$rows[$k]['yphsl'] = $yphsl;  //已配货数量
				$rows[$k]['yjgsj'] = $yjgsj;  //已完工数量
				$rows[$k]['wwgsl'] = $tmp_bhnum - $yjgsj;  //未完工数量
			}

			$total = $this->whlabel_bh->find_count($where);
			$pagenum = ceil($total/$perpage);
			$over = $total-($start+$perpage);
			$rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($rows));
			echo json_encode($rows);exit;
		}
		$start_time = strtotime(date('Y-m-d')) -  14* 24 * 60 * 60;
		$end_time = strtotime(date('Y-m-d')) + 24 * 60 * 60;
		$all_list = $this->whlabel_bh->find_all("extra_type = 1 and time >= ".$start_time." and time <= ".$end_time);
		$orderinfo_list =[];
		$total_num = 0;
		foreach($all_list as $k=>$v){
			$orderinfo_list[$v['id']] = $v['id'];
			$total_num += $v['bhnum'];
		}
		$wbids = array_values($orderinfo_list);
		if(empty($wbids)){
			$over_num = 0;
		}else{
			$over_num = $this->whlabel_bh_transfer->find_count(" status = 2 and wbid in (".implode(",",$wbids).")");
		}
		

		$this->data['total_num'] = $total_num;
		$this->data['wwcsl'] = $total_num - $over_num;

		$this->_Template('whlabel_bh_transfer_log',$this->data);
	}

	public function _transfer_detail($arg_array){
		$id = $arg_array[0];
		$transfer_list = $this->transfer->find_all();
		$t_list = array_column($transfer_list,'title','id');
		$info = $this->whlabel_bh->read($id);
		$list = $this->whlabel_bh_transfer->find_all(" orderinfo= '".$info['orderinfo']."'");
		$ids = array_column($list,'id');
		$final_list = [];
		if(!empty($ids)){
			$log_list = $this->whlabel_bh_transfer_cr->find_all( " type = 1 and  fid in (".implode(",",$ids).")","*","id asc");
			$collect_list = [];
			foreach($log_list as $k=>$v){
				$collect_list[$v['lx']][$v['fid']] = $v;
			}
			
			foreach($collect_list as $k=>$v){
				$js_num = $zk_num = $wc_num = 0;
				foreach($v as $kk=>$vv){
					$js_num += 1;
					if($vv['is_over'] == 0){
						$zk_num += 1;
					}
					if($vv['is_over'] == 1){
						$wc_num += 1;
					}
				}
				$final_list[$k] = [
					'cj' => $t_list[$k],
					'js_num' => $js_num,
					'zk_num' => $zk_num,
					'wc_num' => $wc_num,
					'list' => $v,
				];
			}
		}
		
		// echo "<pre>";
		// print_r($final_list);
		// die;
		$this->data['final_list'] = $final_list;
		$this->_Template('whlabel_bh_transfer_detail',$this->data);
	}


	public function _cj_transfer_log(){
		$post = $this->input->post(NULL, TRUE);
		if(!empty($post)){
			$orderinfo = $this->input->post('orderinfo',true);
			$pm = $this->input->post('pm',true);
			$tid = $this->input->post('tid',true);
			$page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = " rk like '%|".$tid."|%' ";
			if($timetk && $timetj)
            {
                $where .= " and time > '$timetk' and time < '$timetj'";
            }
			
			if($pm){
				if(empty($orderinfo)){
					$rows = array('total'=>0,'over'=>1,'pagenum'=>1,'rows'=>([]),'cwxx'=>"请先输入订单号");
					echo json_encode($rows);exit;
				}else{
					$number_list  = $this->whlabel_bh->find_all(" orderinfo = '$orderinfo' and pm like '%".$pm."%' " ,"orderinfo,number");
					$numbers = array_column($number_list,'number');
					if(empty($numbers)){
						$rows = array('total'=>0,'over'=>1,'pagenum'=>1,'rows'=>([]));
						echo json_encode($rows);exit;
					}
					$where.= " and number in (".implode(",",$numbers).") ";
				}
			}else{
				if($orderinfo){
					$number_list  = $this->whlabel_bh->find_all(" orderinfo = '$orderinfo'","orderinfo,number");
					$numbers = array_column($number_list,'number');
					if(empty($numbers)){
						$rows = array('total'=>0,'over'=>1,'pagenum'=>1,'rows'=>([]));
						echo json_encode($rows);exit;
					}
					$where.= " and number in (".implode(",",$numbers).") ";
				}
			}
			if(empty($page))
		    {
                $start = 0;
		    	$perpage = 20;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			
			
			$list = $this->whlabel_bh_transfer->find_pc($where,'number',"id,number,orderinfo,pm",'id desc',$start,$perpage);
			

			$count = $this->whlabel_bh_transfer->find_all($where,'COUNT(DISTINCT number) as total');
			$total = $count[0]['total'];
			$pagenum = ceil($total/$perpage);
			$over = $total-($start+$perpage);

			$final_list = [];
			foreach($list as $k=>$v){
				$yjs_arr =[];//避免多次扫入的重复计算
				$yjs = $wck= $yck = 0;
				$log_list = $this->whlabel_bh_transfer_cr->find_all("lx = ".$tid." and type = 1 and  number = ".$v['number'],"*",'id desc');
				
				foreach($log_list as $kk=>$vv){
					if(!isset($yjs_arr[$vv['fid']])){
						$yjs += 1;
						if($vv['is_over'] == 0){
							$wck += 1;
						}
						if($vv['is_over'] == 1){
							$yck += 1;
						}
						$yjs_arr[$vv['fid']] = 1;
					}
					
				}
				$whlabel_bh_info = $this->whlabel_bh->find("number = ".$v['number']);
				$final_list[$k]['id'] = $v['id'];
				$final_list[$k]['orderinfo'] = $v['orderinfo'] ;
				$final_list[$k]['number'] ="<h9 class='window' data-h='/whlabel_bh/cj_transfer_detail/".$v['number']."/".$tid."' data-t='备货单号：".$v['number']."'><p>".$v['number']."</p></h9>";
				$final_list[$k]['pm'] = $v['pm'];
				$final_list[$k]['ddsl'] = empty($whlabel_bh_info)?0:$whlabel_bh_info['bhnum'];
				$final_list[$k]['yjs'] = $yjs;
				$final_list[$k]['wck'] = $wck;
				$final_list[$k]['yck'] = $yck;

			}


			$rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($final_list));
			echo json_encode($rows);exit;
		}

		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
			
			
			$transfer = explode('|',trim($user['transfer'],'|'));
			$stid = "";
			foreach ($transfer as $value) 
		    {
				$stid .= " id = ".$value." or";
			}
			if(empty($transfer)){
				exit("您的账号没有赋予车间权限");
			}
			// if(count($transfer) > 1){
			// 	exit("您的账号只能分配一个车间,多车间系统无法处理");
			// }
			$tid = $transfer[0];
			
		}
		else
		{
			header('Location: /');exit;
		}
		$transfer = $this->transfer->read($tid);
		$this->data['transfer'] = $transfer;
		$transfer_list  = $this->transfer->find_all( trim($stid,'or'));


		$start_time = strtotime(date('Y-m-d')) -  14* 24 * 60 * 60;
		$end_time = strtotime(date('Y-m-d')) + 24 * 60 * 60;
		
	
		$log_list = $this->whlabel_bh_transfer_cr->find_all(" lx = ".$tid." and type = 1  and time >= ".$start_time." and time <= ".$end_time,"*","id desc");
	
		$wwcsl = $jszs = $wgzs = 0;
		$tmp_list = [];
		foreach($log_list as $k=>$v){
			if(!isset($tmp_list[$v['fid']])){
				$tmp_list[$v['fid']] = $v;
				$jszs += 1;
				if($v['is_over'] == 1){
					$wgzs += 1;
				}else{
					$wwcsl += 1;
				}
			}
		}
		 
		$this->data['wwcsl'] = $wwcsl;
		$this->data['jszs'] = $jszs;
		$this->data['wgzs'] = $wgzs;
		$this->data['transfer_list'] = $transfer_list;

		$this->_Template('whlabel_bh_cj_transfer_log',$this->data);

	}

	//针对车间的变动筛选条件的
	public function _cj_transfer_log_count(){
		$orderinfo = $this->input->post('orderinfo',true);
		$tid = $this->input->post('tid',true);
		$timetk = $this->input->post('timetk',true);
		$timetj = $this->input->post('timetj',true);
		$pm = $this->input->post('pm',true);
		$start_time = strtotime($timetk);
		$end_time = strtotime($timetj);
		$where = " lx = ".$tid." and type = 1  and time >= ".$start_time." and time <= ".$end_time;
		// if($orderinfo){
		// 	$number_list  = $this->whlabel_bh->find_all(" orderinfo = '$orderinfo'","orderinfo,number");
		// 	$numbers = array_column($number_list,'number');
		// 	$where.= " and number in (".implode(",",$numbers).") ";
		// }
		

		if($pm){
			if(empty($orderinfo)){
				exit(json_encode(['code'=>1,'msg'=>'ok', 'data'=>['wwcsl' => 0,'jszs'=>0,'wgzs'=>0]]));
			}else{
				$number_list  = $this->whlabel_bh->find_all(" orderinfo = '$orderinfo' and pm like '%".$pm."%' " ,"orderinfo,number");
				$numbers = array_column($number_list,'number');
				if(empty($numbers)){
					exit(json_encode(['code'=>1,'msg'=>'ok', 'data'=>['wwcsl' => 0,'jszs'=>0,'wgzs'=>0]]));
				}
				$where.= " and number in (".implode(",",$numbers).") ";
			}
		}else{
			if($orderinfo){
				$number_list  = $this->whlabel_bh->find_all(" orderinfo = '$orderinfo'","orderinfo,number");
				$numbers = array_column($number_list,'number');
				if(empty($numbers)){
					exit(json_encode(['code'=>1,'msg'=>'ok', 'data'=>['wwcsl' => 0,'jszs'=>0,'wgzs'=>0]]));
				}
				$where.= " and number in (".implode(",",$numbers).") ";
			}
		}
		$log_list = $this->whlabel_bh_transfer_cr->find_all($where);
		$wwcsl = $jszs = $wgzs = 0;
		$tmp_list = [];
		foreach($log_list as $k=>$v){
			if(!isset($tmp_list[$v['fid']])){
				$tmp_list[$v['fid']] = $v;
				$jszs += 1;
				if($v['is_over'] == 1){
					$wgzs += 1;
				}else{
					$wwcsl += 1;
				}
			}
		}
		 

		exit(json_encode(['code'=>1,'msg'=>'ok', 'data'=>['wwcsl' => $wwcsl,'jszs'=>$jszs,'wgzs'=>$wgzs]]));
	}

	public function _cj_transfer_detail($arg_array){
		$number = $arg_array[0];
		$tid = $arg_array[1];
		$transfer_info = $this->transfer->read($tid);
		$whlabel_bh_info = $this->whlabel_bh->find(" number = ".$number);
		$final_list = [];
		
		$log_list = $this->whlabel_bh_transfer_cr->find_all( " number = ".$number." and lx = ".$tid,"*","id asc");

		$collect_list = [];
		foreach($log_list as $k=>$v){
			if(isset($final_list[$v['fid']])){
				if($v['type'] == 1){
					$final_list[$v['fid']]['sr_time'] = date('Y-m-d H:i:s',$v['time']);
				}else{
					$final_list[$v['fid']]['sc_time'] = date('Y-m-d H:i:s',$v['time']);
				}
			}else{
				if($v['type'] == 1){
					$final_list[$v['fid']]['sr_time'] = date('Y-m-d H:i:s',$v['time']);
				}else{
					$final_list[$v['fid']]['sc_time'] = date('Y-m-d H:i:s',$v['time']);
				}
			}
			
		}
		
		$this->data['whlabel_bh_info'] = $whlabel_bh_info;
		$this->data['transfer_info'] = $transfer_info;
		$this->data['final_list'] = $final_list;
		$this->_Template('whlabel_bh_cj_transfer_detail',$this->data);
	}

	public function _excelwchz(){
		$classid = $this->classid->sku();
		$pm = $classid;
		$typeclass = array();
		$tc = $this->typeclass->find_all();
		foreach ($tc as $v)
		{
			$typeclass[$v['id']] = $v;
		}
		$prc = array();
		$purchase = $this->purchase->find_all();
		foreach($purchase as $k=>$v)
		{
			$prc[$v['id']] = $v['title'];
		}
		if(isset($_GET['fexcel']))  
		{
    			$number = $this->input->get('number',true);
    			$pm = $this->input->get('pm',true);
    			$color = $this->input->get('color',true);
    			$transfer = $this->input->get('transfer',true);
    			$ktime = $this->input->get('timetk',true);
    			$jtime = $this->input->get('timetj',true);
    			$ktime = strtotime($ktime);
    			$jtime = strtotime($jtime);
    			$where = " time >= ".$ktime." and time <= ".$jtime." ";$gj = "";$ck = "";
    
    			$where .=" and status = 2 and ck like '%|".$transfer."|' ";
    			if($number)
                {
                    $where  .= " and number like '%$number%'";
                }
    			
    			if($pm)
                {
                    $where  .= " and pm like '%$pm%'";
                }
    			
    			if($color)
                {
                    $where  .= " and features like '%-$color-%'";
                }
			
			
          
				$list = array();
				$rows = $this->whlabel_bh_transfer->find_all($where,'id,wbid,orderinfo,jm,pm,time,label');
				
            	foreach($rows as $k=>$v){
            	    if(isset($list[$v['wbid']])){
            	        $list[$v['wbid']]['sl'] =  $list[$v['wbid']]['sl'] + 1;
            	        $list[$v['wbid']]['time'][] = date("Y-m-d H:i:s",$v['time']);
            	        $list[$v['wbid']]['label'][] = $v['label'];
            	    }else{
            	        $list[$v['wbid']] = [
            	            'wbid'=>$v['wbid'],
            	            'orderinfo'=>$v['orderinfo'],
            	            'jm'=>$v['jm'],
            	            'pm'=>$v['pm'],
            	            'sl'=>1,
            	            'time'=>[
            	                date("Y-m-d H:i:s",$v['time'])
            	             ],
            	             'label'=>[
            	                $v['label'],     
            	            ]
            	       ];
            	    }
            	}

				$filename = date("Y-m-d")."工厂备货完成汇总.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>ID</td><td>编号</td><td>简码</td><td>品名</td><td>数量</td><td>扫描时间</td><td>扫描条码</td></tr>";
				foreach ($list as $key=>$value) 
				{ 
					$str .= "<tr>";
					$str .= "<td>". $value['wbid']. "</td>";
					$str .= "<td>". $value['orderinfo']. "</td>";	
					$str .= "<td>". $value['jm']. "</td>";	
					$str .= "<td>". $value['pm']. "</td>";	
					$str .= "<td>". $value['sl']. "</td>";
					$str .="<td>";
					$tmp = "";
					foreach($value['time'] as $kk=>$vv){
					  $tmp .=$vv."<br/>";
					}
					$str .= trim($tmp,"<br/>");
					$str .="</td>";
					$str .="<td>";
					$tmp_l = "";
					foreach($value['label'] as $kk=>$vv){
					    $tmp_l .= "`".$vv."<br/>";
					}
					$str .= trim($tmp_l,"<br/>");
					$str .="</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); 
		}
	}
}