dm-v3.7in6.com/application/admin/controller/QcodeAdd.php

<?php

namespace app\admin\controller;

use app\admin\model\QcodeCompany;
use app\admin\model\QcodeProduct;
use app\common\controller\Backend;
use app\admin\model\ResetFlow;
use app\admin\model\QcodeLarge;
use app\admin\model\QcodeBach;
use app\admin\model\QcodeSmall;
use app\admin\model\QcodeLiushui;
use fast\Arr;
use think\Session;

class QcodeAdd extends Backend
{
    /**
     * 首页展示
     * @return string|\think\response\Json
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function index()
    {
        $company = new QcodeCompany();
        $product = new QcodeProduct();
        $userinfo = Session::get('admin');
        $data = [
            'nickname' => $userinfo['nickname'],
            'postcode' => $userinfo['postcode'],
            'mobile' => $userinfo['mobile'],
            'company_address' => $userinfo['company_address']
        ];
        $product_id = $company->name((int)$userinfo['company'].'_'.'qcode_company')->where('delete_time','')->column('product_id');
        $product_name = [];
        foreach ($product_id as $v){
            $list = $product->where('_id',$v)->where('delete_time','')->find();
            $product_name[$list['product_code']] =  $list['product_name'];
        }
        $this->view->assign('row',$data);
        $this->view->assign('product',$product_name);
        return $this->view->fetch();
    }

    /**
     * 获取产品信息
     * @return \think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function product(){
        $QcodeProduct = new QcodeProduct();
        $ResetFlow = new ResetFlow();
        if ($this->request->isAjax() === false){
            $this->error('请求错误');
        }
        $product_code = input('product_code');
        if (empty($product_code)){
            $this->error('参数错误');
        }
        $product = $QcodeProduct->where('product_code',$product_code)->find();
        if (empty($product)){
            $this->error('未找到该产品信息');
        }
        $flow = $ResetFlow->name((int)Session::get('admin')['company'].'_'."reset_flow")->where('product_id',substr(json_encode($product['_id']),9,-2))->find();
        $row = [
            'temple' => $product['temple'],
            'flow' => '',
            'bach' => '',
        ];
        if (!empty($flow)){
            $row['flow'] = $flow['l_flow']+1;
            $row['bach'] = $flow['bach_num']+1;
        }

        return json(['code'=>1,'data'=>$row]);
    }

    /**
     * 增加新批次
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function add()
    {
        $product = new QcodeProduct();
        $bach = new QcodeBach();
        $large = new QcodeLarge();
        $small = new QcodeSmall();
        $liushui = new QcodeLiushui();
        if ($this->request->isAjax() === false){
            $this->error('请求错误');
        }
        $rows = input('row');
        if (empty($rows)){
            $this->error('参数错误');
        }
        $rows = json_decode($rows);
        $data = [];
        foreach ($rows as $value){
           foreach ($value as $k=>$v){
               $data[$k] = $v;
           }
        }
        if ($data['danwei'] == 1){
            $num = $data['number'];
            $tray_num = $data['tray_num'];
            $box_number = $data['box_number'];
        }else{
            $num = 0;
            $tray_num = 0;
            $box_number = 0;
        }
        //插入批次信息
        $userinfo = Session::get('admin');//获取用户信息
        $productList = $product->where('product_code',$data['product_code'])->find();//获取材料信息
        if (empty($productList)){
            $this->error('未找到该产品数据');
        }
        $batchList = [
            'supplier_name' => $data['company_name'],
            'supplier_code' => '',
            'supplier_id' => $userinfo['id'],
            'matter_name' => $productList['product_name'],
            'matter_no' => $productList['product_code'],
            'matter_id' => substr(json_encode($productList['_id']),9,-2),
            'matter_type' => $productList['temple'],
            'num' => $num,
            'larger_num' => $data['box_num'],
            'small_num' => $data['small_num'],
            'manufacture_date' => (int)date('ymd',strtotime($data['manufacture_date'])),
            'print_date' => (int)date('ymd',strtotime($data['print_date'])),
            'box_num' => $box_number,
            'tray_num' => $tray_num,
            'l_reservation' => '',
            'l_flow' => $data['big_liushui'],
            'l_weight' => $data['big_weight'],
            's_flow' => $data['small_start_liushui'],
            's_weight' => $data['small_weight'],
            'bach_status' => 0,
            'userid' => $userinfo['id'],
            'bach_num' => $data['batch'],
            'large_endnum' => $data['big_liushui'] + $data['box_num'] -1,
        ];
        $res = $bach->save($batchList);
        $last_id = $bach->getLastInsID();
        if ($res === false){
            $this->error('添加失败');
        }
        //插入大小二维码数据
        //二维码数据不变区域
        $fixed_code = '';
        $fixed_code.=$this->intTochar($batchList['matter_type'],2);//2位  辅料种类编码
        $fixed_code.=$this->intTochar($batchList['supplier_code'],12);//12位  供应商编码
        $fixed_code.=$this->intTochar($batchList['matter_no'],20);//20位  辅料编码
        $fixed_code.=$batchList['manufacture_date'];//6位  生产日期

        $print_code=$batchList['print_date'];//6位  打码日期
        $small_liushui = [
            'onlycode' => 'AB92'.$fixed_code.$print_code,
            'last_num' => 0,
            'user_id' => $userinfo['id'],
            'stype' => 2,
            'dateTime' => date('Y-m-d H:i:s',time()),
        ];
        $whereSmall = [
            'onlycode' => $small_liushui['onlycode'],
            'user_id' => $userinfo['id'],
        ];
        if ($liushui->name($userinfo['id'].'_'.'qcode_liushui')->where($whereSmall)->find()){
            //小件二维码存在，更新小件二维码最后流水号
            $lastNum = $liushui->name($userinfo['id'].'_'.'qcode_liushui')->where($whereSmall)->find();
        }else{
            //小件二维码不存在，新增记录
            $liushui->save($small_liushui);
        }
        var_dump($lastNum);
        //循环插入大件二维码数据
        for ($i=0;$i<$batchList['box_num'];$i++){
            $l_flow = $this->intTochar($batchList['l_flow']+$i,6);
            $l_weight = $this->intTochar($batchList['l_weight']*100,6);
            $l_reservation = $this->intTochar($batchList['bach_num'],10);
            $l_reservation = $l_reservation.'0000000000';
            $remainder = $batchList['small_num'] - $batchList['tray_num'] * $i;//最后一托盘小件数量
            if ($remainder < $batchList['tray_num']){
                $small_n = $this->intTochar($remainder,3);//3位小件数量，不足补0
            }else{
                $small_n = $this->intTochar($batchList['tray_num'],3);
            }
            $l_num = 0;
            if ($data['danwei'] == 1){
                //以箱为单位时
                $l_num = $small_n * $batchList['box_num'];
            }
            //大件二维码数据
            $code_data = $this->CodeData('AB92',$fixed_code,$small_n,$print_code,$l_flow,$l_weight,'2',$l_reservation);
            //大码数据信息
            $l_data = [
                'bach_id' => $last_id,
                'code' => $code_data['code'],
                'code_cp1' => $code_data['code_cp1'],
                'code_cp2' => $code_data['code_cp2'],
                'print_date' => $print_code,
                'create_time' => date('Y-m-d H:i:s',time()),
                'p_nums' => 0,
                'userid' =>$userinfo['id'],
                'l_weight' =>$l_weight,
                'l_num' =>$l_num,
            ];
            $l_res = $large->save($l_data);
            $large_id = $large->getLastInsID();
            if ($l_res === false){
                $this->error('大件码插入失败');
            }
            //小件码循环插入
            for ($j=0;$j<$tray_num and ($j+$i*$tray_num)<$batchList['small_num'];$j++){
                $s_flow = $this->intTochar($batchList['s_flow']+$j+$i*$batchList['tray_num']+$lastNum['last_num'],6);//小件码序号从1开始
                $s_weight = $this->intTochar($batchList['s_weight'],6);
                $small_sign = '000';
                $s_reservation = $this->intTochar($batchList['bach_num'],10);
                $s_reservation = $s_reservation . '0000000000';
                //生成小件码
                $small_code_data = $this->CodeData('AB92',$fixed_code,$small_sign,$print_code,$s_flow,$s_weight,'1',$s_reservation);
                //小码数据
                $s_data = [
                    'large_id'=>$large_id,
                    'bach_id'=>$last_id,
                    'code'=>$small_code_data['code'],
                    'code_cp1'=>$small_code_data['code_cp1'],
                    'code_cp2'=>$small_code_data['code_cp2'],
                    'l_flow'=>$j+1,
                    'print_date'=>$print_code,
                    'create_time'=>date('Y-m-d H:i:s',time()),
                    'p_nums'=>0,
                    'userid'=>$userinfo['id'],//小码绑定用户id
                    's_weight'=>$s_weight//单个小件重量
                ];
                $s_res = $small->save($s_data);
                if ($s_res === false){
                    $this->error('小件码插入失败');
                }
            }
        }
        $liushui_res = $liushui->name($userinfo['id'].'_'.'qcode_liushui')->where($whereSmall)->update(['last_num'=>$batchList['small_num']]);
        if ($liushui_res === false){
            $this->error('添加失败');
        }
        $this->success('添加成功');
    }

    /**
     * 编码补位
     * @param $num
     * @param $len
     * @return string
     */
    function intTochar($num=0,$len){
        //规定的不足的时候自动补足零
        $code=(string)$num;
        $buwei='';
        if(strlen($code)<$len){
            for($i=strlen($code);$i<$len;$i++){
                $buwei.='0';
            }
        }
        return $buwei.$code;
    }

    /**
     * 二维码编码生成
     * @param $sign
     * @param $fixed_code
     * @param $small_num
     * @param $print_date
     * @param $flow
     * @param $weight
     * @param $large_sign
     * @param $reservation
     * @return array
     */
     function CodeData($sign,$fixed_code,$small_num,$print_date,$flow,$weight,$large_sign,$reservation){
         $code=$sign;//4 位固定标志位
         $code.=$fixed_code; // 固定字符串
         $code.=$small_num;//3位 小件数量
         $code.=$print_date;//6 位 日期
         $code.=$flow;//6位打印流水号
         $code.=$weight;//6位辅料重量
         $code.=$large_sign;//大小件标示位

         $code.=$reservation;//20 位 预留号

         //大码数据信息
         $data=[
             'code'=>str_replace(" ","",$code),
             'code_cp1'=>$print_date.$flow,
             'code_cp2'=>$weight.$reservation,//20位补充
             'print_date'=>time(),
             'p_nums'=>0,
         ];
         return $data;
     }
}