load->_model("Model_whlabel_bh_transfer",'whlabel_bh_transfer'); $this->load->_model("Model_whlabel_bh_scan",'whlabel_bh_scan'); $this->load->_model("Model_logic_u9tools","logic_u9tools"); $this->load->_model("Model_whlabellabel","whlabellabel"); $this->load->_model('Model_purchase', 'purchase'); } //定义方法的调用规则 获取URI第二段值 public function _remap($arg, $arg_array) { if ($arg == 'scam_mgxx') // { $this->_scanMgxx(); } else if($arg =='scam_mgxx_post') { $this->_scanMgxxPost(); }else if($arg == 'mgxxindex'){ $this->_mgxxindex(); } else if($arg == 'get_scan_info'){ $this->_getScanInfo(); } else if($arg =='typedy'){ $this->_typedy(); } else { $this->_index(); } } private function _index(){ die('No direct script access allowed'); } private function _mgxxindex(){ $post = $this->input->post(); if(!empty($post)){ $rows = array('total'=>0,'over'=>1,'pagenum'=>1,'rows'=>([])); echo json_encode($rows);exit; } $this->_Template('whlabelfz1_mgxxindex', $this->data); } //美国销售 扫描出库的 private function _scanMgxx(){ $post = $this->input->post(); if(!empty($post)){ $type = $this->input->post('type',true); $orderinfo = $this->input->post('orderinfo',true); $page = $this->input->post('page',true); $perpage = $this->input->post('perpage',true); $where = " type = ".$type." and orderinfo = '".(string)$orderinfo."' "; if(empty($page)) { $start = 0; $perpage = 1; } else { $start = ($page - 1)*$perpage; } $order_str = 'id desc'; $info_list = $this->whlabel_bh_scan->find_all($where,'id,orderinfo,pm,label,sl,scantime',$order_str,$start,$perpage); $total = $this->whlabel_bh_scan->find_count($where); $pagenum = ceil($total/$perpage); $over = $total-($start+$perpage); foreach($info_list as $k=>$v){ $info_list[$k]['scantime'] = date('Y-m-d H:i:s',$v['scantime']); } $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list)); echo json_encode($rows);exit; }else{ $orderinfo = $this->input->get('orderinfo',true); $type = $this->input->get('type',true); $this->data['orderinfo'] = $orderinfo; $this->data['type'] = $type; $this->_Template('whlabelfz1_scammgxx', $this->data); } } private function _getScanInfo(){ $post = $this->input->post(); $label = $post['label']; if(empty($label)){ die(json_encode(['code'=>-1,'msg'=>'请输入标签号','data'=>[]])); } $info = $this->whlabel_bh_transfer->find("label ='".$label."'"); if(empty($info)){ die(json_encode(['code'=>-1,'msg'=>'标签号不存在','data'=>[]])); } echo "
";
print_r($info);
die;
}
//接收美店销售的post提交
private function _scanMgxxPost(){
$post = $this->input->post();
$type = $post['type'];
$orderinfo = $post['orderinfo'];
$label = $post['scanlabel'];
$num = (int)$post['num'];
if(empty($type)){
exit(json_encode(['code'=>-1,'msg'=>'数据类型异常,请联系技术','data'=>[]],JSON_UNESCAPED_UNICODE));
}
if(empty($orderinfo)){
exit(json_encode(['code'=>-1,'msg'=>'美国销售单号未输入','data'=>[]],JSON_UNESCAPED_UNICODE));
}
if(empty($label)){
exit(json_encode(['code'=>-1,'msg'=>'标签号不能为空','data'=>[]],JSON_UNESCAPED_UNICODE));
}
if(!in_array($type,[1,2])){
exit(json_encode(['code'=>-1,'msg'=>'数据类型异常,请联系技术','data'=>[],JSON_UNESCAPED_UNICODE]));
}
if($type == 1){
$num = 1;
}
if($type == 2){
if($num > 200){
exit(json_encode(['code'=>-1,'msg'=>'扫描数量不能大于200','data'=>[],JSON_UNESCAPED_UNICODE]));
}
}
$info = $this->whlabel_bh_scan->find("label ='".$label."'");
if(!empty($info)){
exit(json_encode(['code'=>-1,'msg'=>'该标签已被扫描','data'=>[],JSON_UNESCAPED_UNICODE]));
}
if($type == 1){
$res = $this->_bbscan($orderinfo,$label);
}elseif($type == 2){
$res = $this->_bqscan($orderinfo,$label,$num);
}
exit(json_encode($res));
}
//生产布标扫描
private function _bbscan($orderinfo,$label){
$info = $this->whlabel_bh_transfer->find("label ='".$label."'");
if(empty($info)){
return ['code'=>-1,'msg'=>'标签号不存在','data'=>[]];
}
if($info['label'] != $label){
return ['code'=>-1,'msg'=>'条码对应的美国销售单号不一致','data'=>[]];
}
$arr = [
'orderinfo'=>(string)$orderinfo,
'type'=>1,
'label'=>(string)$label,
'features'=>(string)$info['features'],
'fid'=>$info['id'],
'jm'=>$info['jm'],
'pm'=>$info['pm'],
'sl'=>1,
'scantime'=>time(),
'status'=>0,
];
$this->whlabel_bh_scan->insert($arr);
return ['code'=>1,'msg'=>'标签扫描成功','data'=>[]];
}
//标签扫描
private function _bqscan($orderinfo,$label,$num){
$info = $this->whlabellabel->find("label ='".$label."'");
if(empty($info)){
return ['code'=>-1,'msg'=>'标签号不存在','data'=>[]];
}
$list = [
[
'sku2'=>$info['features'],
]
];
$res = $this->logic_u9tools->getU9bm($list,'sku2');
if(empty($res[0])){
return ['code'=>-1,'msg'=>'u9条码编辑错误-1','data'=>[]];
}
if(empty($res[0]['jm'])){
return ['code'=>-1,'msg'=>'u9条码编辑异常-2','data'=>[]];
}
$arr = [
'orderinfo'=>(string)$orderinfo,
'type'=>1,
'label'=>(string)$label,
'features'=>(string)$info['features'],
'fid'=>$info['id'],
'jm'=>$res[0]['jm'],
'pm'=>$res[0]['zh'],
'sl'=>$num,
'scantime'=>time(),
'status'=>0,
];
$this->whlabel_bh_scan->insert($arr);
return ['code'=>1,'msg'=>'标签扫描成功','data'=>[]];
}
// 可以排序的仓库数量
private function _typedy(){
$prc = array();
$purchase = $this->purchase->find_all();
foreach ($purchase as $k => $v) {
$prc[$v['id']] = $v['title'];
}
$post = $this->input->post(NULL, TRUE);
if (isset($post['page'])) {
$page = $this->input->post('page', true);
$perpage = $this->input->post('perpage', true);
$category = $this->input->post('category', true);
$size = $this->input->post('size', true);
$grade = $this->input->post('grade', true);
$color = $this->input->post('color', true);
$lowe = $this->input->post('lowe', true);
$sku = $this->input->post('sku');
$title = $this->input->post('title');
$warehouse = $this->input->post('warehouse', true);
$usa = $this->input->post('usa', true);
$purchase = $this->input->post('purchase', true);
$lacetype = $this->input->post('lacetype', true);
$haircap = $this->input->post('haircap', true);
$density = $this->input->post('density', true);
$details = $this->input->post('details', true);
$state = $this->input->post('state', true);
$lacecolor = $this->input->post('lacecolor', true);
$hairnumber = $this->input->post('hairnumber', true);
$cklx = $this->input->post('cklx', true);
$ktime = $this->input->post('ktime', true);
$jtime = $this->input->post('jtime', true);
$sm = $this->input->post('sm', true);
$cpbz = $this->input->post('cpbz', true);
$type = $this->input->post('type', true);
$ktime = strtotime($ktime);
$jtime = strtotime($jtime);
$where = "1=1";
if ($usa) {
if (!$warehouse) {
$where .= " and (warehouse = '5' or warehouse = '8')";
}
}
if ($warehouse) {
$where .= " and warehouse = '$warehouse'";
}
if ($details) {
$where .= " and details = '$details'";
}
if ($purchase) {
$where .= " and purchase = '$purchase'";
}
if (isset($state)) {
if($state >-1){
$where .= " and state = '$state'";
}
}
if ($lacetype) {
$where .= " and features like '%-$lacetype-%'";
}
if ($category) {
$where .= " and features like '%-$category-%'";
}
if ($size) {
$where .= " and features like '%-$size-%'";
}
if ($grade) {
$where .= " and features like '%-$grade-%'";
}
if ($color) {
$where .= " and features like '%-$color-%'";
}
if ($lowe) {
$where .= " and features like '%-$lowe-%'";
}
if ($haircap) {
$where .= " and features like '%-$haircap-%'";
}
if ($density) {
$where .= " and features like '%-$density-%'";
}
if ($lacecolor) {
$where .= " and features like '%-$lacecolor-%'";
}
if($sm){
$where .= " and sm like '%".$sm."%'";
}
if($cpbz){
$where .= " and cpbz like '%".$cpbz."%'";
}
if($type){
$where .= " and type = ".$type."";
}
if (!empty($hairnumber)) {
$where .= " and features like '%-128-%' ";
if ($hairnumber < 0) {
$class_list = $this->typeclass->find_all('classid = 43');
foreach ($class_list as $v) {
$where .= " and features not like '%-" . $v['id'] . "-%'";
}
} else {
$where .= " and features like '%-$hairnumber-%'";
}
}
$where_add = '';
if ($cklx) {
$shop = $this->shop->read($cklx);
$where_add .= " and zd like '" . $shop['shortname'] . "%' and state = 0";
}
//数据排序
$order_str = "id desc";
if (empty($page)) {
$start = 0;
$perpage = 1;
} else {
$start = ($page - 1) * $perpage;
}
//这里为了对应前端界面的字段 新添加了label字段 后续代码会替换为sm字段
if ($sku) {
$sku = trim($sku, ' ');
$sku = trim($sku, ' ');
$where .= " and sku like '%$sku%'";
$info_list = $this->whlabel->find_pc($where . $where_add, 'sku,features,warehouse', 'id,warehouse,purchase,sku,title,details,shop,cpbz,label,features,number,sm', $order_str, $start, $perpage);
} else if ($title) {
$title = trim($title, ' ');
$title = trim($title, ' ');
$where .= " and title like '%$title%'";
$info_list = $this->whlabel->find_pc($where . $where_add, 'sku,features,warehouse', 'id,warehouse,purchase,sku,title,details,shop,cpbz,label,features,number,sm', $order_str, $start, $perpage);
} else {
//$where .= " and time > '$ktime' and time < '$jtime'";
$info_list = $this->whlabel->find_pc($where . $where_add, 'sku,features,warehouse', 'id,warehouse,purchase,sku,title,details,shop,cpbz,label,features,number,sm', $order_str, $start, $perpage);
}
//$this->logic_ding->sendToDing("仓库查询:".$where . $where_add);
$info_list = $this->logic_whlabel->dataTran($info_list, ['pm']);
foreach ($info_list as $k => $v) {
$info_list[$k]['title'] = $v['title'] . "
" . $v['pm'];
unset($info_list[$k]['pm']);
unset($info_list[$k]['jm']);
unset($info_list[$k]['bm']);
}
//取得信息列表
$rows = array();
$list = array();
foreach ($info_list as $key => $value) {
$warehouse = $this->warehouse->read($value['warehouse']);
$info_list[$key]['purchase'] = (isset($prc[$value['purchase']])) ? $prc[$value['purchase']] : '未知';
$c = $this->whlabel->find_all($where . ' and sku = "' . $value['sku'] . '" and state = 0 and warehouse = "' . $value['warehouse'] . '" and features = "' . $value['features'] . '"', 'details,cpid');
$z = $this->whlabel->find_all($where . ' and sku = "' . $value['sku'] . '" and zd != "" and state = 0 and warehouse = "' . $value['warehouse'] . '" and features = "' . $value['features'] . '"');
$info_list[$key]['cpbz'] = $value['cpbz'] ;
$info_list[$key]['label'] = $value['sm'];
$number = $value['number'];
$ftime = time() - 15 * 24 * 3600;
$info_list[$key]['warehouse'] = $warehouse['title'];
$info_list[$key]['features'] = count($c);
$z = count($z); //查看订单号
$zt = $this->whlabeltransport->find_all('sku = "' . $value['sku'] . '" and warehouse = "' . $value['warehouse'] . '" and features = "' . $value['features'] . '" and cz = "0"');
$ztdata = '';
if (count($zt) > 0) {
foreach ($zt as $vv) {
$ztdata .= '' . $vv['num'] . ' - ' . date('Y-m-d', $vv['stime']) . '
';
}
}
$info_list[$key]['number'] = $ztdata;
$info_list[$key]['sm'] = $z;
$details = array();
$cpid = array();
foreach ($c as $k => $v) {
$details[$v['details']] = $v['details'];
if ($v['cpid'] != 0) {
$cpid[$v['cpid']] = $v['cpid'];
}
}
$info_list[$key]['details'] = ($cpid) ? implode(" ", $details) . '' . implode(" ", $cpid) . '
' : implode(" ", $details);
if ($value['shop'] != '') {
$shop = explode(',', trim($value['shop'], ','));
$shop = $this->shop->read($shop[0]);
$info_list[$key]['shop'] = $shop['shopname'];
}
}
$total = count($this->whlabel->find_pc($where . $where_add, 'sku,features,warehouse', 'id,warehouse,sku,title,features,number'));
$pagenum = ceil($total / $perpage);
$over = $total - ($start + $perpage);
$rows = array('total' => $total, 'over' => $over, 'pagenum' => $pagenum, 'rows' => ($info_list), 'CS' => $warehouse);
echo json_encode($rows);
exit;
}
$this->data['warehouse'] = (isset($arg_array[0])) ? $arg_array[0] : 5;
$this->_Template('whlabelfz1_typedy', $this->data);
}
}