';
}
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 = " type = 10 ";
if(!empty($params['order_no'])){
$where .= " and order_no = '".$params['order_no']."' ";
}
if(!empty($params['timetk'])){
$where .= " and create_time > ".strtotime($params['timetk'])." ";
}
if(!empty($params['timetj'])){
$where .= "and create_time < ".strtotime($params['timetj'])." ";
}
if(!empty($params['status'])){
$status = $params['status'];
if($status == 1){
$where .= " and dc_status = 0 ";
}elseif($status == 2){
$where .= " and dc_status = -1 ";
}elseif($status == 3){
$where .= " and dc_status = -2 ";
}elseif($status == 4){
$where .= " and dc_status = -3 ";
}elseif($status == 5){
$where .= " and dc_status < 3 ";
}
}
$info_list = $this->zzquque_u9->find_all($where,'*','id desc');
$type_list = $this->zzquque_u9->getType();
$list = [];
foreach($info_list as $k=>$v){
$dc_no = $v['dc_no'];
$error_str = "";
$error_json ="";
if($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);
$error_json = $error[0]['ret_data'];
if($error[0]['apply_api']=='lpck'){
$ret_data = json_decode($error[0]['ret_data'],true);
$apply_data = json_decode($error[0]['apply_data'],true);
if(isset($ret_data["ResMsg"])){
if(empty($apply_data['0'])){
$error_str = $ret_data["ResMsg"];
}else{
$error_str = $ret_data["ResMsg"]."【". $apply_data[0]['EntityCode']."】";
}
}else{
$error_str = "料品同步失败";
}
}else{
$ret_data = json_decode($error[0]['ret_data'],true);
if(isset($ret_data[0]["ResMsg"])){
$error_str = $ret_data[0]["ResMsg"];
}elseif(isset($ret_data['msg'])){
$error_str = $ret_data['msg'];
}else{
$error_str = "料品同步失败";
}
}
}
$list[] = [
'id'=>$v['id'],
'order_no'=>$v['order_no'],
'type'=>isset($type_list[$v['type']])?$type_list[$v['type']]:"异常",
'dc_no'=> $dc_no,
'error'=>$error_str,
'error_json'=>$error_json,
//'bzsh_no'=>$bzsh_no,
'create_time'=>date("Y-m-d H:i:s",$v['create_time']),
];
}
$filename = date("Y-m-d")."u9小单导出.xls";
$str = "
| id | 订单号 | 类型 | 调出单号 | 创建时间 | 错误信息 | 错误json |
| ". $value['id']. " | "; $str .= "". $value['order_no']. " | "; $str .= "". $value['type']. " | "; $str .= "". $value['dc_no']. " | "; $str .= "". $value['create_time']. " | "; $str .= "". $value['error']. " | "; $str .= "". $value['error_json']. " | "; $str .= "
';
}
if(!empty($v['dc_no'])){
if($v['type'] == 1){
$dc_no = $v['dc_no']."【销售组织】"."
".$dc_no;
}else{
$dc_no = $v['dc_no']."【香港组织】"."
".$dc_no;
}
}
$cg_no = "";
if($v['type'] == 1){
if($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['type'] == 1){
if($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;
}
}
$dr_no = "";
if($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;
}
$type = "";
if(isset($type_list[$v['type']])){
if($v['type'] == 2){
$type = "".$type_list[$v['type']]."";
}else{
$type = "".$type_list[$v['type']]."";
}
}else{
$type = "异常";
}
$list[] = [
'id'=>$v['id'],
'order_no'=>$v['order_no'],
'type'=>$type,
'dc_no'=> $dc_no,
'cg_no'=>$cg_no,
'xs_no'=>$xs_no,
'dr_no'=>$dr_no,
// 'xs_two_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('zzququeu9zt',$this->data);
}
public function _dczt($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_u9ztsd->createdDc($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;
}
}
}