erp/core/CoreApp/controllers/Zzququeu9.php

<?php 
defined('BASEPATH') OR exit('No direct script access allowed');
class Zzququeu9 extends Start_Controller {
    public function __construct(){
        parent::__construct();
        $this->load->library('session');
        $this->load->_model('Model_zzquque_u9','zzquque_u9');
        $this->load->_model("Model_logic_order","logic_order");
        $this->load->_model("Model_logic_u9xgsd","logic_u9xgsd");
        $this->load->_model('Model_zzququeu9_logs','zzququeu9_logs');
    }
    public function _remap($arg,$arg_array)
    {
		if($arg == 'dc')//调出单
          {
               $this->_dc($arg_array);
          }
          elseif($arg == 'cg')//采购
          {
               $this->_cg($arg_array);
          }
          elseif($arg == 'xs')//销售单
          {
               $this->_xs($arg_array);
          }
          elseif($arg == 'bzch')//标准出货
          {
               $this->_bzch($arg_array);
          }
          elseif($arg == 'bzsh')//标准收货
          {
               $this->_bzsh($arg_array);
          }
          elseif($arg == 'dr')//调入单
          {
               $this->_dr($arg_array);
          }
          elseif($arg == 'xs_two')//调入单
          {
               $this->_xs_two($arg_array);
          }
          elseif($arg == 'add'){
               $this->_add();
          }
          elseif($arg == 'excel'){
               $this->_excel();
          }
          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);
			
			$timetk = $this->input->post('timetk',true);//订单开始时间
			$timetj = $this->input->post('timetj',true);//订单结束时间
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);

               $status = $this->input->post('status',true);

			$order_no = $this->input->post('order_no',true);
               $where='type = 10 ';
			if($order_no){
			    $where .= " and order_no = '".$order_no."' ";
			}
               if($timetk && $timetj){
                   $where .= " and create_time  > ".$timetk." and create_time  < ".$timetj." ";
               }
               if($status){
                    if($status = 1){
                         $where .= " and dc_status < 0 ";
                    }elseif($status = 2){
                         $where .= " and cg_status < 0 ";
                    }elseif($status = 3){
                         $where .= " and xs_status < 0 ";
                    }elseif($status = 4){
                         $where .= " and dr_status < 0 ";
                    }elseif($status = 5){
                         $where .= " and xs_two_status < 0 ";
                    }elseif($status = 6){
                         $where .= " and bzsh_status <0 ";
                    }
               }
			if(empty($page))
               {
                    $start = 0;
                    $perpage = 1;
               }
               else
               {
                    $start = ($page - 1)*$perpage;
               }
			
               $info_list = $this->zzquque_u9->find_all($where,'*','id desc',$start,$perpage);
               $type_list = $this->zzquque_u9->getType();
               $list = [];
               foreach($info_list as $k=>$v){
                    $dc_no = "";
                    if($v['dc_status'] == 0){
                         $dc_no = "<span  data-action='dc' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建调出单</span>";
                    }elseif($v['dc_status'] == -1){
                         $error = $this->zzququeu9_logs->find_all("oid = ".$v['id']." and one_type = 1 and two_type = 1 ","*",'id desc',0,1);
                         if($error[0]['apply_api']=='lpck'){
                             $ret_data = json_decode($error[0]['ret_data'],true);
                             if(isset($ret_data[0]["ResMsg"])){
                                   $tmp_str = $ret_data[0]["ResMsg"];
                             }else{
                                   $tmp_str = "料品同步失败";
                             }
                         }else{
                             $tmp_str = "创建调出单失败";
                         }
                         $dc_no = "<span data-action='dc' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建调出单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="'.$tmp_str.'"></i><p>';
                    }
                    if(!empty($v['dc_no'])){
                         $dc_no = $v['dc_no']."<br/>".$dc_no;
                    }
                    $cg_no = "";
                    if($v['cg_status'] == 0){
                         $cg_no .= "<span  data-action='cg' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建采购单</span>";
                    }elseif($v['cg_status'] == 1){
                         $cg_no .= "<span data-action='cg' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交采购单</span>";
                    }elseif($v['cg_status'] == -1){
                         $cg_no .= "<span data-action='cg' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建采购单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="采购单创建失败"></i><p>';
                    }elseif($v['cg_status'] == 2){
                         $cg_no .= "<span data-action='cg' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核采购单</span>";
                    }elseif($v['cg_status'] == -2){
                         $cg_no .= "<span data-action='cg' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交采购单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="采购单提交失败"></i><p>';
                    }elseif($v['cg_status'] == -3){
                         $cg_no .= "<span data-action='cg' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核采购单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="采购单审核失败"></i><p>';
                    }
                    if(!empty($v['cg_no'])){
                         $cg_no = $v['cg_no']."<br/>".$cg_no;
                    }
                    $xs_no = "";
                    if($v['xs_status'] == 0){
                         $xs_no .= "<span  data-action='xs' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建销售单</span>";
                    }elseif($v['xs_status'] == 1){
                         $xs_no .= "<span data-action='xs' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交销售单</span>";
                    }elseif($v['xs_status'] == -1){
                         $xs_no .= "<span data-action='xs' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="销售单创建失败"></i><p>';
                    }elseif($v['xs_status'] == 2){
                         $xs_no .= "<span data-action='xs' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核销售单</span>";
                    }elseif($v['xs_status'] == -2){
                         $xs_no .= "<span data-action='xs' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="销售单提交失败"></i><p>';
                    }elseif($v['xs_status'] == -3){
                         $xs_no .= "<span data-action='xs' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="销售单审核失败"></i><p>';
                    }
                    if(!empty($v['xs_no'])){
                         $xs_no = $v['xs_no']."<br/>".$xs_no;
                    }
                    $xs_two_no ='';
                    if($v['xs_two_status'] == 0){
                         $xs_two_no .= "<span  data-action='xs_two' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建销售单</span>";
                    }elseif($v['xs_two_status'] == 1){
                         $xs_two_no .= "<span data-action='xs_two' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交销售单</span>";
                    }elseif($v['xs_two_status'] == -1){
                         $xs_two_no .= "<span data-action='xs_two' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['xs_two_status'] == 2){
                         $xs_two_no .= "<span data-action='xs_two' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核销售单</span>";
                    }elseif($v['xs_two_status'] == -2){
                         $xs_two_no .= "<span data-action='xs_two' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['xs_two_status'] == -3){
                         $xs_two_no  .= "<span data-action='xs_two' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核销售单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }
                    if(!empty($v['xs_two_no'])){
                         $xs_two_no = $v['xs_two_no']."<br/>".$xs_two_no;
                    }
                    
                    $bzch_no ="";
                    if($v['bzch_status'] == 0){
                         $bzch_no  .= "<span  data-action='bzch' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建出货单</span>";
                    }elseif($v['bzch_status'] == 1){
                         $bzch_no .= "<span data-action='bzch' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交出货单</span>";
                    }elseif($v['bzch_status'] == -1){
                         $bzch_no .= "<span data-action='bzch' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建出货单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['bzch_status'] == 2){
                         $bzch_no .= "<span data-action='bzch' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核出货单</span>";
                    }elseif($v['bzch_status'] == -2){
                         $bzch_no .= "<span data-action='bzch' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交出货单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['bzch_status'] == -3){
                         $bzch_no .= "<span data-action='bzch' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核出货单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }
                    //$bzsh_no =empty($v['bzsh_no'])?"":$v['bzsh_no'];
                    if(!empty($v['bzch_no'])){
                         $bzch_no = $v['bzch_no']."<br/>".$bzch_no;
                    }

                    $dr_no = "";
                    if($v['dr_status'] == 0){
                         $dr_no .= "<span  data-action='dr' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建调入单</span>";
                    }elseif($v['dr_status'] == 1){
                         $dr_no .= "<span data-action='dr' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交调入单</span>";
                    }elseif($v['dr_status'] == -1){
                         $dr_no .= "<span data-action='dr' data-process='1' data-id='".$v['id']."' onclick='doAction(this)'>创建调入单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['dr_status'] == 2){
                         $dr_no .= "<span data-action='dr' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核调入单</span>";
                    }elseif($v['dr_status'] == -2){
                         $dr_no .= "<span data-action='dr' data-process='2' data-id='".$v['id']."' onclick='doAction(this)'>提交调入单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }elseif($v['dr_status'] == -3){
                         $dr_no .= "<span data-action='dr' data-process='3' data-id='".$v['id']."' onclick='doAction(this)'>审核调入单</span>".'<p style="color:blue"><i  class="method fa fa-exclamation-circle" data-t="123"></i><p>';
                    }
                    if(!empty($v['dr_no'])){
                         $dr_no = $v['dr_no']."<br/>".$dr_no;
                    }

                    $list[] = [
                         'id'=>$v['id'],
                         'order_no'=>$v['order_no'],
                         'type'=>isset($type_list[$v['type']])?$type_list[$v['type']]:"异常",
                         'dc_no'=> $dc_no,
                         'cg_no'=>$cg_no,
                         'xs_no'=>$xs_no,
                         'dr_no'=>$dr_no,
                         'xs_two_no'=>$xs_two_no,
                         'bzch_no'=>$bzch_no,
                         //'bzsh_no'=>$bzsh_no,
                        
                         'create_time'=>date("Y-m-d H:i:s",$v['create_time']),
                         'update_time'=>date("Y-m-d H:i:s",$v['update_time'])
                    ];
               }

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

			
		}

		$this->_Template('zzququeu9',$this->data);
    }
    public function _dc($arg_array){
      $process= $arg_array[0];
      $id = $arg_array[1];
      $info = $this->zzquque_u9->read($id);
     
      if($process == 1){
          if(!in_array($info['dc_status'],[0,-1])){
               echo json_encode(array('msg'=>'当前状态不符合创建调出单的条件','success'=>false));
               exit;
          }
          $r = $this->logic_u9xgsd->createDc($info);
          if($r['code'] == 1){
               echo json_encode(array('msg'=>'创建调出单成功','success'=>true));
               exit;
          }else{
               echo json_encode(array('msg'=>$r['msg'],'success'=>false));
               exit;
          }
      }else if($process == 2){
          if(!in_array($info['dc_status'],[1,-2])){
               echo json_encode(array('msg'=>'当前状态不符合提交调出单的条件','success'=>false));
               exit;
          }
          $r = $this->logic_u9xgsd->subDc($info);
          if($r['code'] == 1){
               echo json_encode(array('msg'=>'提交调出单成功','success'=>true));
               exit;
          }else{
               echo json_encode(array('msg'=>$r['msg'],'success'=>false));
               exit;
          }
      }else if($process == 3){
          if(!in_array($info['dc_status'],[2,-3])){
               echo json_encode(array('msg'=>'当前状态不符合审核调出单的条件','success'=>false));
               exit;
          }
          $r = $this->logic_u9xgsd->shDc($info);
          if($r['code'] == 1){
               echo json_encode(array('msg'=>'审核调出单成功','success'=>true));
               exit;
          }else{
               echo json_encode(array('msg'=>$r['msg'],'success'=>false));
               exit;
          }
      }else{
          echo json_encode(array('msg'=>'当前状态不符合创建调出单的条件','success'=>false));
          exit;
      }
     
    }
    public function _cg($arg_array){
     $process= $arg_array[0];
     $id = $arg_array[1];
     $info = $this->zzquque_u9->read($id);
     if($info['dc_status'] != 3){
          echo json_encode(array('msg'=>'调出单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($process == 1){
         if(!in_array($info['cg_status'],[0,-1])){
              echo json_encode(array('msg'=>'当前状态不符合创建采购单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->createCg($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'创建采购单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 2){
         if(!in_array($info['cg_status'],[1,-2])){
              echo json_encode(array('msg'=>'当前状态不符合提交采购单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->subCg($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'提交采购单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 3){
         if(!in_array($info['cg_status'],[2,-3])){
              echo json_encode(array('msg'=>'当前状态不符合审核采购单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->shCg($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'审核采购单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else{
         echo json_encode(array('msg'=>'当前状态不符合创建采购单的条件','success'=>false));
         exit;
     }
    }
    public function _xs($arg_array){
     $process= $arg_array[0];
     $id = $arg_array[1];
     $info = $this->zzquque_u9->read($id);
     if($info['dc_status'] != 3){
          echo json_encode(array('msg'=>'调出单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($process == 1){
         if(!in_array($info['xs_status'],[0,-1])){
              echo json_encode(array('msg'=>'当前状态不符合创建销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->createXs($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'创建销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 2){
         if(!in_array($info['xs_status'],[1,-2])){
              echo json_encode(array('msg'=>'当前状态不符合提交销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->subXs($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'提交销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 3){
         if(!in_array($info['xs_status'],[2,-3])){
              echo json_encode(array('msg'=>'当前状态不符合审核销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->shXs($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'审核销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else{
         echo json_encode(array('msg'=>'当前状态不符合创建销售单的条件','success'=>false));
         exit;
     }    
    }
   

    public function _dr($arg_array){
     $process= $arg_array[0];
     $id = $arg_array[1];
     $info = $this->zzquque_u9->read($id);
     if($info['dc_status'] != 3){
          echo json_encode(array('msg'=>'调出单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($process == 1){
         if(!in_array($info['dr_status'],[0,-1])){
              echo json_encode(array('msg'=>'当前状态不符合查询调入单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->createDr($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'查询调入单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 2){
         if(!in_array($info['dr_status'],[1,-2])){
              echo json_encode(array('msg'=>'当前状态不符合提交调入单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->subDr($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'提交调入单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 3){
         if(!in_array($info['dr_status'],[2,-3])){
              echo json_encode(array('msg'=>'当前状态不符合审核调入单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->shDr($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'审核调入单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else{
         echo json_encode(array('msg'=>'当前状态不符合创建调入单的条件','success'=>false));
         exit;
     }    
    }

    public function _xs_two($arg_array){
     $process= $arg_array[0];
     $id = $arg_array[1];
     $info = $this->zzquque_u9->read($id);
     if($info['dc_status'] != 3){
          echo json_encode(array('msg'=>'调出单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($process == 1){
         if(!in_array($info['xs_two_status'],[0,-1])){
              echo json_encode(array('msg'=>'当前状态不符合查询香港销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->createXsTwo($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'创建香港销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 2){
         if(!in_array($info['xs_two_status'],[1,-2])){
              echo json_encode(array('msg'=>'当前状态不符合提交香港销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->subXsTwo($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'提交香港销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 3){
         if(!in_array($info['xs_two_status'],[2,-3])){
              echo json_encode(array('msg'=>'当前状态不符合审核香港销售单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->shXsTwo($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'审核香港销售单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else{
         echo json_encode(array('msg'=>'当前状态不符合创建香港销售单的条件','success'=>false));
         exit;
     }  
    }

    public function _bzch($arg_array){
     $process= $arg_array[0];
     $id = $arg_array[1];
     $info = $this->zzquque_u9->read($id);
     if($info['dc_status'] != 3){
          echo json_encode(array('msg'=>'调出单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($info['xs_two_status'] != 3){
          echo json_encode(array('msg'=>'香港销售单未审核不能执行后续操作','success'=>false));
          exit;
     }
     if($process == 1){
         if(!in_array($info['bzsh_status'],[0,-1])){
              echo json_encode(array('msg'=>'当前状态不符合创建标准收货单的条件','success'=>false));
              exit;
         }
         $r = $this->logic_u9xgsd->createCh($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'创建标准收货单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else if($process == 2){
         
         $r = $this->logic_u9xgsd->subAndShCh($info);
         if($r['code'] == 1){
              echo json_encode(array('msg'=>'审核标准收货单成功','success'=>true));
              exit;
         }else{
              echo json_encode(array('msg'=>$r['msg'],'success'=>false));
              exit;
         }
     }else{
         echo json_encode(array('msg'=>'当前状态不符合创建标准收货单的条件','success'=>false));
         exit;
     }    
    }
    public function _bzsh($arg_array){
    
    }
    public function  _add(){
       $order_no  = $this->input->post('order_no',true);
       if(empty($order_no)){
          echo json_encode(['msg'=>'请输入要添加的订单编码!','success'=>false]);exit;   
       }
        $info = $this->logic_order->getInfo("number = '" .$order_no."'");
        if(empty($info)){
           echo json_encode(['msg'=>'订单不存在!请仔细核对单号','success'=>false]);exit; 
        }
        $num = $this->zzquque_u9->find_all("order_no = '".$info['number']."'");
        if(empty($num)){
             $this->zzquque_u9->insert([
                'platform'=>$info['lv_platform'],
                'warehouse'=>$info['type'],
                'type'=>10,
                'order_no'=>$info['number'],
                'create_time'=>time(),
                'update_time'=>time(),
            ]);
            echo json_encode(['msg'=>'添加成功','success'=>true]);exit; 
        }else{
            echo json_encode(['msg'=>'订单不允许重复添加','success'=>false]);exit; 
        }
       
        
    }


    public function _excel(){
        $params = $this->input->get();
        $where = "1 = 1";
        if(!empty($params['order_no'])){
          $where .= " order_no =  '".$params['order_no']."' ";
        } 
        if(!empty($params['timetk'])){
          $where .= " create_time >  ".strtotime($params['timetk'])." ";
        }       
        if(!empty($params['timetj'])){
          $where .= " create_time <  ".strtotime($params['timetj'])." ";
        }    
        if(!empty($params['status'])){
          $where .= " status = ".$params['status'];
        }
        var_dump($where);

    }
}