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 = "创建调出单"; }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{ $ret_data = json_decode($error[0]['ret_data'],true); if(isset($ret_data[0]["ResMsg"])){ $tmp_str = $ret_data[0]["ResMsg"]; }elseif(isset($ret_data['msg'])){ $tmp_str = $ret_data['msg']; }else{ $tmp_str = "料品同步失败"; } } $dc_no = "创建调出单".'

'; } if(!empty($v['dc_no'])){ $dc_no = $v['dc_no']."
".$dc_no; } $cg_no = ""; if($v['cg_status'] == 0){ $cg_no .= "创建采购单"; }elseif($v['cg_status'] == 1){ $cg_no .= "提交采购单"; }elseif($v['cg_status'] == -1){ $cg_no .= "创建采购单".'

'; }elseif($v['cg_status'] == 2){ $cg_no .= "审核采购单"; }elseif($v['cg_status'] == -2){ $cg_no .= "提交采购单".'

'; }elseif($v['cg_status'] == -3){ $cg_no .= "审核采购单".'

'; } if(!empty($v['cg_no'])){ $cg_no = $v['cg_no']."
".$cg_no; } $xs_no = ""; if($v['xs_status'] == 0){ $xs_no .= "创建销售单"; }elseif($v['xs_status'] == 1){ $xs_no .= "提交销售单"; }elseif($v['xs_status'] == -1){ $xs_no .= "创建销售单".'

'; }elseif($v['xs_status'] == 2){ $xs_no .= "审核销售单"; }elseif($v['xs_status'] == -2){ $xs_no .= "提交销售单".'

'; }elseif($v['xs_status'] == -3){ $xs_no .= "审核销售单".'

'; } if(!empty($v['xs_no'])){ $xs_no = $v['xs_no']."
".$xs_no; } $xs_two_no =''; if($v['xs_two_status'] == 0){ $xs_two_no .= "创建销售单"; }elseif($v['xs_two_status'] == 1){ $xs_two_no .= "提交销售单"; }elseif($v['xs_two_status'] == -1){ $xs_two_no .= "创建销售单".'

'; }elseif($v['xs_two_status'] == 2){ $xs_two_no .= "审核销售单"; }elseif($v['xs_two_status'] == -2){ $xs_two_no .= "提交销售单".'

'; }elseif($v['xs_two_status'] == -3){ $xs_two_no .= "审核销售单".'

'; } if(!empty($v['xs_two_no'])){ $xs_two_no = $v['xs_two_no']."
".$xs_two_no; } $bzch_no =""; if($v['bzch_status'] == 0){ $bzch_no .= "创建出货单"; }elseif($v['bzch_status'] == 1){ $bzch_no .= "提交出货单"; }elseif($v['bzch_status'] == -1){ $bzch_no .= "创建出货单".'

'; }elseif($v['bzch_status'] == 2){ $bzch_no .= "审核出货单"; }elseif($v['bzch_status'] == -2){ $bzch_no .= "提交出货单".'

'; }elseif($v['bzch_status'] == -3){ $bzch_no .= "审核出货单".'

'; } //$bzsh_no =empty($v['bzsh_no'])?"":$v['bzsh_no']; if(!empty($v['bzch_no'])){ $bzch_no = $v['bzch_no']."
".$bzch_no; } $dr_no = ""; if($v['dr_status'] == 0){ $dr_no .= "创建调入单"; }elseif($v['dr_status'] == 1){ $dr_no .= "提交调入单"; }elseif($v['dr_status'] == -1){ $dr_no .= "创建调入单".'

'; }elseif($v['dr_status'] == 2){ $dr_no .= "审核调入单"; }elseif($v['dr_status'] == -2){ $dr_no .= "提交调入单".'

'; }elseif($v['dr_status'] == -3){ $dr_no .= "审核调入单".'

'; } if(!empty($v['dr_no'])){ $dr_no = $v['dr_no']."
".$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); } public function mcindex(){ } }