erp/core/CoreApp/controllers/Systembound.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
header("Access-Control-Allow-Origin: *");
class Systembound extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
		$this->load->_model('Model_outbound','outbound');
		$this->load->_model('Model_excel','excel');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_fullorder','fullorder');
		$this->load->_model('Model_fullordertt','fullordertt');
		$this->load->_model('Model_fullorderamz','fullorderamz');
		$this->load->_model('Model_fullordersmt','fullordersmt');
		$this->load->_model('Model_fullorderxw','fullorderxw');
		$this->load->_model('Model_logic_order','logic_order');
		$this->load->_model("Model_logic_express","logic_express");
	}
	//定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
		if($arg == 'data')
        {
             $this->_data();
        }
		else if($arg == 'out')
        {
             $this->_out();
        }
		else if($arg == 'del')
        {
             $this->_del();
        }
		else if($arg == 'add')
        {
             $this->_add();
        }
		else if($arg == 'excel')
        {
             $this->_excel();
        }
		else if($arg == 'excelhc')
        {
			//一件导出惠城和GES的全部快递
             $this->_excelhc();
        }else if($arg == 'zxdpdexcel'){
			$this->_zxdpdexcel();
		}
		else if($arg == 'dcall'){
			$this->_dcall();
		}
		else
		{
			 $this->_index();
		}
    }
	
	public function _index()
	{
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $fgshop = "";$sid = "";$wid="";$wtype="";
		    $usersp = explode('|',trim($user['shop'],'|'));
			$userwh = explode('|',trim($user['warehouse'],'|'));
			foreach ($usersp as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
			foreach ($userwh as $value) 
		    {
				$wid .= " id = ".$value." or";
				$wtype .= " type = ".$value." or";
			}
		}
		if(isset($_SESSION['api']))
		{
			$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
			$warehouse = $this->warehouse->find_all('1=1 and '.rtrim($wid,'or'),"*","px asc");
		    $this->data['wlshop'] = $wlshop;
		    $this->data['warehouse'] = $warehouse;
			$this->data['vip'] = $user['vip'];
		}
		$this->_Template('systembound',$this->data);
	}
	public function _data()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$number = $this->input->post('number',true);
			$waybill = $this->input->post('waybill',true);
			$express = $this->input->post('express',true);
			$type = $this->input->post('type',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "type != 0";
			if(isset($_SESSION['api']))
			{
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
			}
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($express)
            {
				$where  .= " and express = '$express'";
            }
            //数据排序
            $order_str = "time desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->outbound->find_all($where,'id,type,express,number,waybill,time',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value)
		    {
				if($value['waybill'] == '0')
				{
					$info_list[$key]['waybill'] = "无";
				}
				if($value['express'] == '0')
				{
					$info_list[$key]['express'] = "无";
				}
				else
				{
				    $express = $this->express->read($value['express']);
				    $info_list[$key]['express'] = $express['servicename'];
				}
				$warehouse = $this->warehouse->read($value['type']);
				$info_list[$key]['type'] = $warehouse['title'];
				$info_list[$key]['time'] = '<em class="t">'.date('Y-m-d H:i:s',$value['time']).'</em>';
            }
			$ex = array();
			$ed = $this->outbound->find_all($where,'express');
			foreach ($ed as $key=>$value)
		    {
				if(isset($ex[$value['express']]))
				{
				    $ex[$value['express']] += 1;
				}
				else
				{
					$ex[$value['express']] = 1;
				}
			}
			$exdata = '';
			foreach ($ex as $k=>$v)
		    {
				$e = $this->express->read($k);
				$exdata .= "<li>".$e['servicename'].":".$v."单</li>";
			}
			$datacount = $this->outbound->find_count($where." and gtime = '".date('Ymd',time())."'");
		    $total = $this->outbound->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'datacount'=>$datacount,'exdata'=>$exdata);
		    echo json_encode($rows);exit;
		}
	}
		
	private function _zxdpdexcel(){
		if(isset($_GET['fexcel']))  
		{
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$library = $this->input->get('library',true);
			$type = $this->input->get('type',true);
			$number = $this->input->get('number',true);
			$waybill = $this->input->get('waybill',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$select_express = $this->input->get('select_express',true);
			
			$typename = "正鑫DPD";
			$cx_arr = [78,79];

			$ex_list = $this->express->find_all("id in (".implode(',',$cx_arr).")","id,servicename");
			
			$where = "type != 0 and express in (".implode(',',$cx_arr).")";
			
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if(isset($_SESSION['api']))
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			else
			{
				echo json_encode(array('msg'=>'导出失败，请重新登陆！','success'=>false));exit;
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			
			$data = array();
			$datafy = array();
			$j = 0;
			$info_list = $this->outbound->find_all($where,'number,waybill,express','time asc');

			$final_list= [

			];
			foreach($cx_arr as $v){
				$final_list[$v] = [];
			}
			foreach ($info_list as $key=>$value)
		    {
				if(isset($final_list[$value['express']])){
					$orderinfo = $this->logic_order->getInfo('number = "'.$value['number'].'"');
					$weight = 0;
					if(!empty($orderinfo)){
						$weight = $orderinfo['weight'];
					}
					$weight = str_replace('kgkg','kg',$weight);
					$final_list[$value['express']][] = [
						$value['number'],
						$value['waybill'],
						$weight
					];
				}
				
			}
			$data[] = $datafy;
			 //格式化数据
			$i = 0;$cpexcel = array();

            $title = date('Ymd',time()).$typename."发货统计信息"; $td = '';
			$td = "";
			$count = 0;
			foreach($ex_list as $v){
			    $num = count($final_list[$v['id']]);
			    if($num > $count){
			        $count = $num;
			    }
				$td .= "<td>".$v['servicename']."</td><td>总数（".$num.")</td><td>重量</td>";
			}
			foreach($final_list as $k=>$v){
			    for($i=0;$i < $count ;$i++){
			        if(!isset($final_list[$k][$i])){
			            $final_list[$k][$i] = [
			                    " "," ",""
			                ];
			        }
			    }
			}
            $titlename = "<table border=1>
            <tr>
            ".$td."
            </tr>
            </table>"; 
            $filename = $title.".xls";
            $this->excel->get_fz7($final_list,$titlename,$filename);
	    }
	}
	
	public function _excel()
	{
		if(isset($_GET['fexcel']))  
		{
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$library = $this->input->get('library',true);
			$type = $this->input->get('type',true);
			$number = $this->input->get('number',true);
			$waybill = $this->input->get('waybill',true);
			$express = $this->input->get('express',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "type != 0";
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if(isset($_SESSION['api']))
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			else
			{
				echo json_encode(array('msg'=>'导出失败，请重新登陆！','success'=>false));exit;
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($express)
            {
				$where  .= " and express = '$express'";
            }
			$data = array();
			$datafy = array();
			$j = 0;
			$info_list = $this->outbound->find_all($where,'number,waybill','time asc');
			foreach ($info_list as $key=>$value)
		    {
				$datafy[] = array($value['number'],$value['waybill']);
				if($j == $library-1)
				{
					$data[] = $datafy;
					$j = 0;$datafy = array();
				}
				else
				{
					$j++;
				}
			}
			$data[] = $datafy;
			 //格式化数据
			$i = 0;$cpexcel = array();
            $title = date('Ymd',time())."发货统计信息"; $td = '';
			for($i=0;$i<ceil(count($info_list)/$library);$i++)
			{
				$td .= "<td>组".($i+1)."</td><td></td>";
			}
            $titlename = "<table border=1>
            <tr>
            ".$td."
            </tr>
            </table>"; 
            $filename = $title.".xls";
            $this->excel->get_fz6($data,$titlename,$filename);
	    }
	}
	
	//一件导出惠城的全部快递
	public function _excelhc()
	{
		if(isset($_GET['fexcel']))  
		{
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$library = $this->input->get('library',true);
			$type = $this->input->get('type',true);
			$number = $this->input->get('number',true);
			$waybill = $this->input->get('waybill',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$select_express = $this->input->get('select_express',true);
			if($select_express == 'ozyt'){
				//云途(欧洲)   云途(欧洲)-带保险
				$cx_arr = [66,67,82];//需要的查询数据
				$typename = "云途";
			}else{
				//GES  7     惠城联邦  50 惠城GES  51  惠城安迈世  51  惠城DHL 69 惠城usps  73
				$cx_arr = [7,50,51,52,69,73,88];//需要的查询数据
				$typename = "惠程";
			}
			

			$ex_list = $this->express->find_all("id in (".implode(',',$cx_arr).")","id,servicename");
			
			$where = "type != 0 and express in (".implode(',',$cx_arr).")";
			
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if(isset($_SESSION['api']))
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			else
			{
				echo json_encode(array('msg'=>'导出失败，请重新登陆！','success'=>false));exit;
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			
			$data = array();
			$datafy = array();
			$j = 0;
			$info_list = $this->outbound->find_all($where,'number,waybill,express','time asc');

			$final_list= [

			];
			foreach($cx_arr as $v){
				$final_list[$v] = [];
			}
			foreach ($info_list as $key=>$value)
		    {
				if(isset($final_list[$value['express']])){
					$final_list[$value['express']][] = [
						$value['number'],
						$value['waybill'],
					];
				}
				
			}
			$data[] = $datafy;
			 //格式化数据
			$i = 0;$cpexcel = array();

            $title = date('Ymd',time()).$typename."发货统计信息"; $td = '';
			$td = "";
			$count = 0;
			foreach($ex_list as $v){
			    $num = count($final_list[$v['id']]);
			    if($num > $count){
			        $count = $num;
			    }
				$td .= "<td>".$v['servicename']."</td><td>".$num."</td>";
			}
			foreach($final_list as $k=>$v){
			    for($i=0;$i < $count ;$i++){
			        if(!isset($final_list[$k][$i])){
			            $final_list[$k][$i] = [
			                    " "," "
			                ];
			        }
			    }
			}
            $titlename = "<table border=1>
            <tr>
            ".$td."
            </tr>
            </table>"; 
            $filename = $title.".xls";
            $this->excel->get_fz6($final_list,$titlename,$filename);
	    }
	}


	public function _add()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['number']))
		{
			$where = "gtime = '".date('Ymd',time())."'";
			$number = $this->input->post('number',true);
			//$waybill = $this->input->post('waybill',true);
			$id = $this->input->post('id',true);
			$type = $this->input->post('type',true);
			$express = $this->input->post('express',true);
			$time = $this->input->post('time',true);
			if($time)
			{
			    $time = strtotime($time);
			}
			else
			{
				$time = time();
			}
			if($id)
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($id);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			/**
			if(!$number)
			{
				echo json_encode(array('msg'=>'编号不能为空！','success'=>false));exit;
			}
			if(!$waybill)
			{
				//echo json_encode(array('msg'=>'运单号不能为空！','success'=>false));exit;
			}
			if(!$type)
			{
				echo json_encode(array('msg'=>'请选择需要录入数据的仓库！','success'=>false));exit;
			}
			if(!$express)
			{
				echo json_encode(array('msg'=>'请选择需要录入的快递！','success'=>false));exit;
			}
			$nu = $this->outbound->get_number($number);
			if($nu)
			{
				echo json_encode(array('msg'=>'错误！此编号'.date('Ymd',$nu['time']).'已录入！','success'=>false));exit;
			}
			if($waybill)
			{
			    $wa = $this->outbound->get_waybill($waybill);
			    if($wa)
			    {
				    echo json_encode(array('msg'=>'错误！此运单号'.date('Ymd',$wa['time']).'已录入！','success'=>false));exit;
			    }
				$sex = $this->express->read($express);
				$ex = array('DHL'=>10,'FEDEX'=>12,'FEDEXGF'=>12,'UPS'=>18,'GES'=>17,'TNT'=>9,'ARAMEX'=>11,'EMS_ZX_ZX_US'=>13);
				if(isset($ex[$sex['printcode']]))
				{
					if(strlen($waybill) != $ex[$sex['printcode']])
					{
						echo json_encode(array('msg'=>'运单号错误，此单请重新录入运单号！','success'=>false));exit;
					}
				}
			}
			**/
			if(!$number)
			{
				echo json_encode(array('msg'=>'未扫入数据！','success'=>false));exit;
			}
			if(!$type)
			{
				echo json_encode(array('msg'=>'请选择需要录入数据的仓库！','success'=>false));exit;
			}
			if(!$express)
			{
				echo json_encode(array('msg'=>'请选择需要录入的快递！','success'=>false));exit;
			}
			$sex = $this->express->read($express);
			if(stripos($number,'-') === false)
			{
				if(substr($number,0,3) == '788' && substr($number,-4,4) == '0430')//Fedex联邦
				{
					$number = substr($number,0,12);
				}
				if(strlen($number) == '34')//联邦杭州超长运单截取
				{
					$str  = substr($number, 0,3);
					if($str == "420"){
						$number = substr($number,12);
					}else{
						$number = substr($number,22,12);
					}
				}
				
				/**
				$ex = array('DHL'=>10,'FEDEX'=>12,'FEDEXGF'=>12,'UPS'=>18,'GES'=>17,'TNT'=>9,'ARAMEX'=>11,'EMS_ZX_ZX_US'=>13);
				if(isset($ex[$sex['printcode']]))
				{
					if(strlen($number) != $ex[$sex['printcode']])
					{
						echo json_encode(array('msg'=>'运单号错误，此单请重新录入运单号！','success'=>false));exit;
					}
				}
				**/


				if(strlen($number) == 12 && $sex['printcode'] != 'FEDEX' && $sex['printcode'] != 'FEDEXGF' && $sex['printcode'] != 'HUALEI-MLXY' && $sex['printcode'] != 'FEDEX_G' && $sex['printcode'] != 'HUALEIXW-USPS' && $sex['printcode'] != 'FedEx_GD' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX' && $sex['printcode'] != 'HUALEI-FEDEX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！F','success'=>false));exit;
				}
				if(strlen($number) == 10 && $sex['printcode'] != 'DHL' && $sex['printcode'] != 'DHLUSA' && $sex['printcode'] != 'HUALEI-DHL' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！D','success'=>false));exit;
				}
				if(strlen($number) == 18 && $sex['printcode'] != 'UPS' && $sex['printcode'] != 'YunExpress' && $sex['printcode'] != 'YunExpress_BaoXian' && $sex['printcode'] != 'USKD01' && $sex['printcode']!= 'YunExpress_JFPHTKR' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！U'.$sex['printcode'],'success'=>false));exit;
				}
				if(strlen($number) == 16 && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX' && $sex['printcode'] != 'TTUK' && $sex['printcode'] != 'TTUS' && $sex['printcode'] != 'TTSP' && $sex['printcode'] != 'TTSP-Fedex' && $sex['printcode'] != 'HUALEI-XB-CA')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！PE'.$sex['printcode'],'success'=>false));exit;
				}

				
				$tmp_waybill = $number;
				$yd = $this->fullorder->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
				if(isset($yd[0]['number']))
				{
					$number = $yd[0]['number'];
					if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
					{
						echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
					}
				}
				else
				{
					$yd = $this->fullordersmt->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
					if(isset($yd[0]['number']))
				    {
					    $number = $yd[0]['number'];
						if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
						{
							echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
						}
						if($yd[0]['express'] != 24 && $yd[0]['express'] == 31)
						{
							echo json_encode(array('msg'=>'请选择杭州联邦快递方式录入','success'=>false));exit;
						}
				    }
					else
					{
						$yd = $this->fullordertt->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
						if(isset($yd[0]['number']))
				    	{
					   	 $number = $yd[0]['number'];
							if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
							{
								echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
							}
							if($yd[0]['express'] != 24 && $yd[0]['express'] == 31)
							{
								echo json_encode(array('msg'=>'请选择杭州联邦快递方式录入','success'=>false));exit;
							}
				    	}
						else
						{
						    $yd = $this->fullorderamz->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
    						if(isset($yd[0]['number']))
    				    	{
    					   	 $number = $yd[0]['number'];
    							if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
    							{
    								echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
    							}
    							if($yd[0]['express'] != 24 && $yd[0]['express'] == 31)
    							{
    								echo json_encode(array('msg'=>'请选择杭州联邦快递方式录入','success'=>false));exit;
    							}
    				    	}
    						else
    						{
    						    	$yd = $this->fullorderxw->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
        							if(isset($yd[0]['number']))
        				    		{
        					   		 $number = $yd[0]['number'];
        								if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
        								{
        									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
        								}
        								if($yd[0]['express'] != 24 && $yd[0]['express'] == 31)
        								{
        									echo json_encode(array('msg'=>'请选择杭州联邦快递方式录入','success'=>false));exit;
        								}
        				    		}
        							else
        							{
        								echo json_encode(array('msg'=>'系统中未查到此运单，请确认！'.$number,'success'=>false));exit;
        							}
    						}
						    
						    
						
						}
					}
				}
				/**
				if($yd[0]['printtype'] != 1)
				{
					echo json_encode(array('msg'=>'请扫描正确的运单号！','success'=>false));exit;
				}
				**/
				$nu = $this->outbound->get_number($number);
			    if($nu)
			    {
				    echo json_encode(array('msg'=>'错误！此编号'.date('Ymd',$nu['time']).'已录入！','success'=>false));exit;
			    }
				if($this->outbound->insert(array('type'=>$type,'number'=>$number,'waybill'=>$tmp_waybill,'express'=>$express,'gtime'=>date('Ymd',time()),'time'=>$time)))
					{
						$data = $this->outbound->find_count($where);
						echo json_encode(array('msg'=>'提交成功，数量：'.$data,'music'=>'1','success'=>true));exit;
					}
				else
				{
					echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
				}
			}
			else
			{
				$dd = $this->fullorder->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
				if(isset($dd[0]['number']))
				{
					if($dd[0]['express'] != $express)
					{
						echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
					}
				}
				else
				{
					$dd = $this->fullordersmt->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
					if(isset($dd[0]['number']))
				    {
					    $number = $dd[0]['number'];
						if($dd[0]['express'] != $express)
						{
							echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
						}
				    }
					else
					{
						$dd = $this->fullordertt->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
						if(isset($dd[0]['number']))
				    	{
					    	$number = $dd[0]['number'];
							if($dd[0]['express'] != $express)
							{
								echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
							}
				    	}
						else
						{
							$dd = $this->fullorderamz->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
							if(isset($dd[0]['number']))
				    		{
					    		$number = $dd[0]['number'];
								if($dd[0]['express'] != $express)
								{
									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
								}
				    		}
							else
							{
									$dd = $this->fullorderxw->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
        							if(isset($dd[0]['number']))
        				    		{
        					    		$number = $dd[0]['number'];
        								if($dd[0]['express'] != $express)
        								{
        									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
        								}
        				    		}
        							else
        							{
        								echo json_encode(array('msg'=>'系统中未查到此编号，请确认！','success'=>false));exit;
        							}
							}
						}
					}
				}
				$tmp_waybill = "";
				if(isset($dd[0]['waybill'])){
				    $tmp_waybill= $dd[0]['waybill'];
				}
				if(($dd[0]['printtype'] != 2) && (!in_array($dd[0]['express'],[50,51,52,69,73,75,91])))
				{
					echo json_encode(array('msg'=>'请扫描正确的条码！','success'=>false));exit;
				}
				$nu = $this->outbound->get_number($number);
			    if($nu)
			    {
				    echo json_encode(array('msg'=>'错误！此编号'.date('Ymd',$nu['time']).'已录入！','success'=>false));exit;
			    }
				if($this->outbound->insert(array('type'=>$type,'number'=>$number,'waybill'=>$tmp_waybill,'express'=>$express,'gtime'=>date('Ymd',time()),'time'=>$time)))
				{
					$data = $this->outbound->find_count($where);
					echo json_encode(array('msg'=>'添加成功！','success'=>true));exit;
				}
				else
				{
					echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
				}
			}
			/**
			if($this->outbound->insert(array('type'=>$type,'number'=>$number,'waybill'=>$waybill,'express'=>$express,'gtime'=>date('Ymd',$time),'time'=>$time+1)))
			{
				echo json_encode(array('msg'=>'添加成功！','success'=>true));exit;
			}
			**/
			
		}
	}
	
	public function _del()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['delarr']))  
		{
            $id_arr = $this->input->post('delarr');
            $id_arr =  explode(',',rtrim($id_arr,','));
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'未选择需要删除的内容！','success'=>false));exit;
            }
            //循环删除记录
			$a=0;
            foreach ($id_arr as $v) 
		    {
				if($this->outbound->remove($v))
				{
					$a++;
				}
				
            }
			if($a == count($id_arr))
			{
				$data = $this->outbound->find_count("gtime = '".date('Ymd',time())."'");
                echo json_encode(array('del'=>$id_arr,'data'=>$data,'msg'=>'删除成功！','success'=>true));
			}
			else
			{
				echo json_encode(array('del'=>$id_arr,'msg'=>'部分记录删除失败，请查询确认！','success'=>true));
			}
		}
	}
	public function _ex()
	{
		
	}
	public function _out()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['number']))
		{
			$where = "gtime = '".date('Ymd',time())."'";
			$number = $this->input->post('number',true);
			$type = $this->input->post('type',true);
			$express = $this->input->post('express',true);
			if($_SESSION['api'])
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			if(!$number)
			{
				echo json_encode(array('msg'=>'未扫入数据！','success'=>false));exit;
			}
			if(!$type)
			{
				echo json_encode(array('msg'=>'请选择需要录入数据的仓库！','success'=>false));exit;
			}
			if(!$express)
			{
				echo json_encode(array('msg'=>'请选择需要录入的快递！','success'=>false));exit;
			}
			$sex = $this->express->read($express);
			if(stripos($number,'-') === false)
			{
				if(substr($number,0,3) == '788' && substr($number,-4,4) == '0430')//Fedex联邦
				{
					$number = substr($number,0,12);
				}
				if(strlen($number) == '34')//联邦杭州超长运单截取
				{
					//$number = substr($number,22,12);
					    $str  = substr($number, 0,3);
        			    if($str == "420"){
        			        $number = substr($number,12);
        			    }else{
        			        $number = substr($number,22,12);
        			    }
				}
				
				/**
				$ex = array('DHL'=>10,'FEDEX'=>12,'FEDEXGF'=>12,'UPS'=>18,'GES'=>17,'TNT'=>9,'ARAMEX'=>11,'EMS_ZX_ZX_US'=>13);
				if(isset($ex[$sex['printcode']]))
				{
					if(strlen($number) != $ex[$sex['printcode']])
					{
						echo json_encode(array('msg'=>'运单号错误，此单请重新录入运单号！','success'=>false));exit;
					}
				}
				**/

				if(strlen($number) == 12 && $sex['printcode'] != 'FEDEX' && $sex['printcode'] != 'FEDEXGF' && $sex['printcode'] != 'HUALEI-MLXY' && $sex['printcode'] != 'FEDEX_G' && $sex['printcode'] != 'HUALEIXW-USPS' && $sex['printcode'] != 'FedEx_GD' && $sex['printcode']   != 'HUALEI-GES-EU' && $sex['printcode']   !=  'ZXDPD_UK' && $sex['printcode']   !=  'ZXDPD_EU' && $sex['printcode'] != 'TTUS' && $sex['printcode'] != 'TTSP' && $sex['printcode'] != 'TTSP-Fedex' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX' && $sex['printcode'] != 'HUALEI-FEDEX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！F','success'=>false));exit;
				}
				if(strlen($number) == 10 && $sex['printcode'] != 'DHL'&& $sex['printcode'] != 'DHL-9' && $sex['printcode'] != 'DHLUSA' && $sex['printcode'] != 'HUALEI-DHL' && $sex['printcode']   !=  'ZXDPD_UK'  && $sex['printcode']   !=  'ZXDPD_EU' && $sex['printcode'] != 'TTUS' && $sex['printcode'] != 'TTSP' && $sex['printcode'] != 'TTSP-Fedex' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！D','success'=>false));exit;
				}
				if(strlen($number) == 18 && $sex['printcode'] != 'UPS' && $sex['printcode'] != 'YunExpress' && $sex['printcode'] != 'YunExpress_BaoXian' && $sex['printcode'] != 'USKD01'&& $sex['printcode'] != 'YunExpress_JFPHTKR' && $sex['printcode'] != 'TTUS' && $sex['printcode'] != 'TTSP' && $sex['printcode'] != 'TTSP-Fedex' && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！U'.$sex['printcode'],'success'=>false));exit;
				}
				if(strlen($number) == 16 && $sex['printcode'] != '3PE_XB'  && $sex['printcode'] != '3PE_NONBOX' && $sex['printcode'] != 'TTUK' && $sex['printcode'] != 'TTUS' && $sex['printcode'] != 'TTSP' && $sex['printcode'] != 'TTSP-Fedex' && $sex['printcode'] != 'HUALEI-XB-CA')
				{
					echo json_encode(array('msg'=>'运单号和快递类型不符！PE'.$sex['printcode'],'success'=>false));exit;
				}

				// $r = $this->logic_express->ydCheckByPrintcode($number,$sex['printcode']);
				// if(!$r){
				// 	echo json_encode(array('msg'=>'运单号和快递类型不符-'.$sex['printcode'],'success'=>false));exit;
				// }



				$yd = $this->fullorder->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
				if(isset($yd[0]['number']))
				{
					$number = $yd[0]['number'];
					if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
					{
						echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
					}
				}
				else
				{
					$yd = $this->fullordersmt->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
					if(isset($yd[0]['number']))
				    {
					    $number = $yd[0]['number'];
						if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
						{
							echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
						}
				    }
					else
					{
						$yd = $this->fullordertt->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
						if(isset($yd[0]['number']))
				    	{
					    	$number = $yd[0]['number'];
							if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
							{
								echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
							}
				    	}
						else
						{
							$yd = $this->fullorderamz->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
							if(isset($yd[0]['number']))
				    		{
					    		$number = $yd[0]['number'];
								if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
								{
									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
								}
				    		}
							else
							{
								$yd = $this->fullorderxw->find_all("waybill = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
    							if(isset($yd[0]['number']))
    				    		{
    					    		$number = $yd[0]['number'];
    								if($yd[0]['express'] != $express && $yd[0]['express'] != 31)
    								{
    									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
    								}
    				    		}
    							else
    							{
    								echo json_encode(array('msg'=>'系统中未查到此运单，请确认！'.$number,'success'=>false));exit;
    							}
							}
						}
					}
				}
				/**
				if($yd[0]['printtype'] != 1)
				{
					echo json_encode(array('msg'=>'请扫描正确的运单号！','success'=>false));exit;
				}
				
				**/


				//再次判断下杭州不报关的类别是否满足条件  如果有影响可以删除
				if($yd[0]['express'] != $express){
					echo json_encode(array('msg'=>'录入信息和选择快递不一致！2','success'=>false));exit;
				}

				$nu = $this->outbound->get_number($number);
			    if($nu)
			    {
				    echo json_encode(array('msg'=>'错误！此编号'.date('Ymd',$nu['time']).'已录入！','success'=>false));exit;
			    }
				if($this->outbound->insert(array('type'=>$type,'number'=>$number,'waybill'=>$yd[0]['waybill'],'express'=>$yd[0]['express'],'gtime'=>date('Ymd',time()),'time'=>time())))
					{
						$data = $this->outbound->find_count($where);
						echo json_encode(array('msg'=>$data,'music'=>'1','success'=>true));exit;
					}
				else
				{
					echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
				}
			}
			else
			{
				$dd = $this->fullorder->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
				if(isset($dd[0]['number']))
				{
					if($dd[0]['express'] != $express)
					{
						echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
					}
				}
				else
				{
					$dd = $this->fullordersmt->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
					if(isset($dd[0]['number']))
				    {
					    $number = $dd[0]['number'];
						if($dd[0]['express'] != $express)
						{
							echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
						}
				    }
					else
					{
						$dd = $this->fullordertt->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
						if(isset($dd[0]['number']))
				    	{
					    	$number = $dd[0]['number'];
							if($dd[0]['express'] != $express)
							{
								echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
							}
				    	}
						else
						{
							$dd = $this->fullorderamz->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
							if(isset($dd[0]['number']))
				    		{
					    		$number = $dd[0]['number'];
								if($dd[0]['express'] != $express)
								{
									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
								}
				    		}
							else
							{
								$dd = $this->fullorderxw->find_all("number = '$number' and library = '2' and librarytime > '".(time()-30*24*3600)."'");
    							if(isset($dd[0]['number']))
    				    		{
    					    		$number = $dd[0]['number'];
    								if($dd[0]['express'] != $express)
    								{
    									echo json_encode(array('msg'=>'录入信息和选择快递不一致！','success'=>false));exit;
    								}
    				    		}
    							else
    							{
    								echo json_encode(array('msg'=>'系统中未查到此编号，请确认！','success'=>false));exit;
    							}
							}
						}
					}
				}
				//惠程-美国USPS  惠程-联邦  惠程-安迈世  惠程-DHL  惠程-GES(欧盟)
				if(($dd[0]['printtype'] != 2) && (!in_array($dd[0]['express'],[50,51,52,69,73,75,91])))
				{
					echo json_encode(array('msg'=>'请扫描正确的条码！','success'=>false));exit;
				}
				//判断该订单的快递单号是否存在 如果不存在提示 补齐快递单号 在进行扫描
				// if(empty($dd[0]['waybill'])){
				// 	echo json_encode(array('msg'=>'该订单未检索到快递信息，请补齐快递单号！','success'=>false));exit;
				// }

				$nu = $this->outbound->get_number($number);
			    if($nu)
			    {
				    echo json_encode(array('msg'=>'错误！此编号'.date('Ymd',$nu['time']).'已录入！','success'=>false));exit;
			    }
				if($this->outbound->insert(array('type'=>$type,'number'=>$number,'waybill'=>$dd[0]['waybill'],'express'=>$dd[0]['express'],'gtime'=>date('Ymd',time()),'time'=>time())))
				{
					$data = $this->outbound->find_count($where);
					echo json_encode(array('msg'=>$data,'music'=>'1','success'=>true));exit;
				}
				else
				{
					echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
				}
			}
			
		}
	}


	public function _dcall(){
		if(isset($_GET['fexcel']))  
		{
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$library = $this->input->get('library',true);
			$type = $this->input->get('type',true);
			$number = $this->input->get('number',true);
			$waybill = $this->input->get('waybill',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			
			$typename = "订单计数";
			// $cx_arr = [78,79];

			// $ex_list = $this->express->find_all("id in (".implode(',',$cx_arr).")","id,servicename");
			
			// $where = "type != 0 and express in (".implode(',',$cx_arr).")";
			$where = " type != 0 ";
			
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if(isset($_SESSION['api']))
            {
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				else
				{
					$uw = '';
				    $u = $this->user->get_api($_SESSION['api']);
				    $u['warehouse'] =  explode('|',trim($u['warehouse'],'|'));
				    foreach ($u['warehouse'] as $v) 
		            {
					    $uw  .= " type = '$v' or";
                    }
				    $uw = rtrim($uw,'or');
					$uw = " and (".ltrim($uw,' ').")";
					$where  .= $uw;
				}
            }
			else
			{
				echo json_encode(array('msg'=>'导出失败，请重新登陆！','success'=>false));exit;
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			
			$data = array();
			$datafy = array();
			$j = 0;
			$info_list = $this->outbound->find_all($where,'number,waybill,express','time asc');
			
			$express_ids = array_unique(array_column($info_list,'express'));
			$express_ids = array_values($express_ids);
		
			
			$ex_list = $this->express->find_all("id in (".implode(',',$express_ids).")","id,servicename",'id asc');
			
			$final_list= [

			];
			foreach($ex_list as $v){
				$final_list[$v['id']] = [];
			}
			
			foreach ($info_list as $key=>$value)
		    {
				if(isset($final_list[$value['express']])){
					$orderinfo = $this->logic_order->getInfo('number = "'.$value['number'].'"');
					$weight = 0;
					if(!empty($orderinfo)){
						$weight = $orderinfo['weight'];
					}
					$weight = str_replace('kgkg','kg',$weight);
					$final_list[$value['express']][] = [
						$value['number'],
						$value['waybill'],
						$weight
					];
				}
				
			}
			$data[] = $datafy;
			 //格式化数据
			$i = 0;$cpexcel = array();

            $title = date('Ymd',time()).$typename."发货统计信息"; $td = '';
			$td = "";
			$count = 0;
			foreach($ex_list as $v){
			    $num = count($final_list[$v['id']]);
			    if($num > $count){
			        $count = $num;
			    }
				$td .= "<td>".$v['servicename']."</td><td>总数（".$num.")</td><td>重量</td>";
			}
			foreach($final_list as $k=>$v){
			    for($i=0;$i < $count ;$i++){
			        if(!isset($final_list[$k][$i])){
			            $final_list[$k][$i] = [
			                    " "," ",""
			                ];
			        }
			    }
			}
            $titlename = "<table border=1>
            <tr>
            ".$td."
            </tr>
            </table>"; 
            $filename = $title.".xls";
            $this->excel->get_fz7($final_list,$titlename,$filename);
	    }
	}
}