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(){
}
}