erp/core/CoreApp/controllers/Whlabelfz1.php

<?php defined('BASEPATH') or exit('No direct script access allowed');
/**
 * 由于whlabel类下的代码太长了，决定以后非必要代码都放在whlabelfz类中，以便于管理。
 */
class Whlabelfz1 extends Start_Controller
{
	public function __construct()
	{
        parent::__construct();
		$this->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 "<pre>";
		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'] . "<br/>" . $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 .= '<p>' . $vv['num'] . ' - ' . date('Y-m-d', $vv['stime']) . '</p>';
					}
				}
				$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) . '<p>' . implode(" ", $cpid) . '</p>' : 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);
	}
}