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

<?php

namespace app\admin\controller;

use app\admin\model\QcodeCompany;
use app\admin\model\QcodeProduct;
use app\admin\model\QcodeGsmc;
use app\admin\model\QcodeLarge;
use app\common\controller\Backend;
use \think\Session;

/**
 * 
 *
 * @icon fa fa-circle-o
 */
class QcodeBach extends Backend
{

    /**
     * Product模型对象
     * @var \app\admin\model\QcodeBach
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\QcodeBach();
    }



    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */


    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        return $this->view->fetch();
    }

    /**
     * 查看
     */
    public function table1()
    {
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            $where = [
                'delete_time'=> ''
            ];

            $req = input();
            $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
            $order = $req['order'];
            $offset = $req['offset'];
            $limit = $req['limit'];

            // 构造模糊查询条件
//            $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
//            $filter = ['field' => $regex];

            $filter = json_decode($req['filter'], true);
            foreach ($filter as $k => $v){
                $where[$k] = new \MongoDB\BSON\Regex($v);
            }

            $userInfo = Session::get('admin');
            $company_id = (int)$userInfo['company'];
            $total = $this->model->name($company_id.'_'."qcode_bach")->where($where)
                ->order($sort,$order)
                ->skip($offset)
                ->select();
            $list = $this->model->name($company_id.'_'."qcode_bach")->where($where)
                ->order($sort,$order)
                ->limit($limit)
                ->skip($offset)
                ->select();
            foreach ($list as $k=>$v) {
                $oid = $v['_id']->jsonSerialize();
                $list[$k]['id'] = $oid['$oid'];
            }

            $result = array("total" => count($total), "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }

    /**
     * 查看
     */
    public function table2()
    {
        //当前是否为关联查询
        $this->relationSearch = false;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            $userInfo = Session::get('admin');
            $company_id = (int)$userInfo['company'];
            $where = [
//                'company_id'=>(int)$userInfo['company'],
                'delete_time'=> ''
            ];

            $req = input();
            $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
            $order = $req['order'];
            $offset = $req['offset'];
            $limit = $req['limit'];

            // 构造模糊查询条件
//            $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
//            $filter = ['field' => $regex];

            $filter = json_decode($req['filter'], true);
            foreach ($filter as $k => $v){
                $where[$k] = new \MongoDB\BSON\Regex($v);
            }

            $db = new QcodeLarge();
            $rows = $db->name($company_id.'_'."qcode_large")
                ->where('delete_time','')
                ->column('product_id');
            $rows = array_values($rows);

            $total = $this->model->where($where)
                ->where('_id','in',$rows)
                ->order($sort,$order)
                ->skip($offset)
                ->select();

            $list = $this->model->where($where)
                ->where('_id','in',$rows)
                ->order($sort,$order)
                ->limit($limit)
                ->skip($offset)
                ->select();
            foreach ($list as $k=>$v) {
                $oid = $v['_id']->jsonSerialize();
                $list[$k]['id'] = $oid['$oid'];
            }

            $result = array("total" => count($total), "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }
    public function vo2()
    {
        $num1 = 0;
        $num2 = 5;
        if($num2<=$num1){
            $this->error('同步num1到num2之间的数据, 要求num2大于num1');
        }
        $qcodeGsmc = new QcodeGsmc();

        // 连接到其他数据库
        $config = [
            'type'     => 'mysql',
            'hostname' => '127.0.0.1',
            'database' => 'dm_7in6_com',
            'username' => 'root',
            'password' => 'root',
            'charset'  => 'utf8mb4',
            'prefix'   => 'qr_',
        ];
        $db = Db::connect($config);

        //查询主表记录
        $rows1 = $db->name('qcode_gsmc')
            ->limit($num1,$num2-$num1)
            ->select();

        foreach($rows1 as $v){
            //1. 查询mongodb中是否存在该条记录
            $bool = $qcodeGsmc->where('oid_id',$v['id'])->find();
            if ($bool) continue;

            //2. 获取设置主表数据
            $row = $v;
            unset($row['id']);
            $row = array_merge(['oid_id'=>$v['id']],$row);

            //3. 插入主表记录到mongodb中
            $qcodeGsmc = new QcodeGsmc();
            $qcodeGsmc->save($row);
        }

        $this->success('成功');

    }
    /**
     * 新增
     */
    public function add()
    {
        if ($this->request->isAjax()){
            $req = $this->request->post();
            if(!isset($req['row']['product_code']) || empty($req['row']['product_code'])){
                $this->error('请填写编号');
            }else{
                $data = [
                    'product_code'=>$req['row']['product_code'],
                    'delete_time'=>'',
                ];
                if ($this->model->where($data)->find()){
                    $this->error('编号已存在');
                }
            }
            if(!isset($req['row']['product_name']) || empty($req['row']['product_name'])){
                $this->error('请填写名称');
            }else{
                $data = [
                    'product_name'=>$req['row']['product_name'],
                    'delete_time'=>'',
                ];
                if ($this->model->where($data)->find()){
                    $this->error('名称已存在');
                }
            }
            if(!isset($req['row']['temple']) || empty($req['row']['temple'])){
                $this->error('请填写辅料代号');
            }
            if(!isset($req['row']['main_unit'])){
                $this->error('请填写主计量单位');
            }
            if(!isset($req['row']['sec_unit'])){
                $this->error('请填写辅计量单位');
            }
            if(!isset($req['row']['proportion'])){
                $this->error('请填写换算关系');
            }
            $data = [
                'product_code'      =>$req['row']['product_code'],
                'product_name'      =>$req['row']['product_name'],
                'temple'            =>$req['row']['temple'],
                'main_unit'         =>$req['row']['main_unit'],
                'sec_unit'          =>$req['row']['sec_unit'],
                'proportion'        =>$req['row']['proportion'],
                'create_time'        =>date('Y-m-d H:i:s'),
            ];
            //插入数据
            $re = $this->model->save($data);
            if($re){
                $this->success('成功');
            }else{
                $this->error('失败');
            }
        }
        return $this->view->fetch();

    }

    /**
     * 编辑
     */
    public function edit($ids = NULL)
    {
        if ($this->request->isAjax()){

            $req = $this->request->post();
            if(!isset($req['row']['product_code']) || empty($req['row']['product_code'])){
                $this->error('请填写编号');
            }else{
                $data = [
                    'product_code'=>$req['row']['product_code'],
                    'delete_time'=>'',
                ];
                if ($this->model->where($data)->where('_id','neq',$ids)->find()){
                    $this->error('编号已存在');
                }
            }
            if(!isset($req['row']['product_name']) || empty($req['row']['product_name'])){
                $this->error('请填写名称');
            }else{
                $data = [
                    'product_name'=>$req['row']['product_name'],
                    'delete_time'=>'',
                ];
                if ($this->model->where($data)->where('_id','neq',$ids)->find()){
                    $this->error('名称已存在');
                }
            }
            if(!isset($req['row']['temple']) || empty($req['row']['temple'])){
                $this->error('请填写辅料代号');
            }
            if(!isset($req['row']['main_unit'])){
                $this->error('请填写主计量单位');
            }
            if(!isset($req['row']['sec_unit'])){
                $this->error('请填写辅计量单位');
            }
            if(!isset($req['row']['proportion'])){
                $this->error('请填写换算关系');
            }
            $data = [
                'product_code'      =>$req['row']['product_code'],
                'product_name'      =>$req['row']['product_name'],
                'temple'            =>$req['row']['temple'],
                'main_unit'         =>$req['row']['main_unit'],
                'sec_unit'          =>$req['row']['sec_unit'],
                'proportion'        =>$req['row']['proportion'],
                'update_time'       =>date('Y-m-d H:i:s'),
            ];

            //修改数据
            $department = \app\admin\model\QcodeProduct::get(['_id' => new \MongoDB\BSON\ObjectID($ids)]);
            $re = $department->save($data);
            if($re){
                $this->success('修改成功');
            }else{
                $this->error('修改失败');
            }
        }
        $row = $this->model->where('_id',$ids)->find();

        $this->view->assign('row',$row);
        return $this->view->fetch();

    }

    /**
     * 删除
     */
    public function del($ids = NULL)
    {
        $department = \app\admin\model\QcodeProduct::get(['_id' => new \MongoDB\BSON\ObjectID($ids)]);

        $department->delete_time = date('Y-m-d H:i:s');
        $re = $department->save();
        if($re){
            $this->success('删除成功');
        }else{
            $this->error('删除失败');
        }
    }

    /**
     * 绑定
     */
    public function bind($ids = NULL)
    {
        $userInfo = Session::get('admin');
        $company_id = (int)$userInfo['company'];
        $db = new QcodeCompany();
        //查询是否已经添加
        $row = $db->name($company_id.'_'."qcode_company")
            ->where(['delete_time'=>'','product_id'=>$ids])
            ->find();
        if($row) $this->success('已添加');

        $data = [
            'product_id'=>$ids,
            'create_time'=>date('Y-m-d H:i:s'),
        ];

        //插入qcode_company数据
        $bool = $db->save($data);
        if($bool){
            $this->success('添加成功');
        }else{
            $this->error('添加失败');
        }
    }

    /**
     * 解绑
     */
    public function unbind($ids = NULL)
    {
        $userInfo = Session::get('admin');
        $company_id = (int)$userInfo['company'];
        $db = new QcodeCompany();
        //查询是否已经添加
        $bool = $db->name($company_id.'_'."qcode_company")
            ->where(['delete_time'=>'','product_id'=>$ids])
            ->update(['delete_time'=>date('Y-m-d H:i:s')]);

        if($bool){
            $this->success('删除成功');
        }else{
            $this->error('删除失败');
        }
    }

    /**
     * 补打标签
     */
    public function reprint()
    {
        if ($this->request->isAjax()) {
            $data = $this->request->param();
            parse_str($data['data'],$req);

            if(!isset($req['row']['nickname']) || empty($req['row']['nickname'])){
                $this->error('请填写公司名称');
            }
            if((!isset($req['row']['product_name']) || empty($req['row']['product_name'])) && (!isset($req['row']['product_code']) || empty($req['row']['product_code']))){
                $this->error('请填写辅料名称或辅料编号');
            }
            if(!isset($req['row']['sqrcd']) || empty($req['row']['sqrcd'])){
                $this->error('请填写配盘数');
            }
            if(!isset($req['row']['num']) || empty($req['row']['num'])){
                $this->error('请填写数量');
            }

            //查询公司信息
            $qcodeGsmc = new QcodeGsmc();
            $print_code = $qcodeGsmc
                ->field('id, nickname, print_code')
                ->where('nickname',$req['row']['nickname'])
                ->find();
            if (!$print_code) $this->error('未查到公司信息');
            $print_code = json_decode($print_code,true);

            //查询产品信息
            $qcodeProduct = new QcodeProduct();
            if(!empty($req['row']['product_code'])){
                $sel = $qcodeProduct
                    ->field('id, product_name, product_code, temple')
                    ->where('product_code',$req['row']['product_code'])
                    ->find();
            }else{
                $sel = $qcodeProduct
                    ->field('id, product_name, product_code, temple')
                    ->where('product_name',$req['row']['product_name'])
                    ->find();
            }
            if (!$sel) $this->error('未查到辅料信息');
            $sel = json_decode($sel,true);

            $data = [
                'company_name'=>$req['row']['nickname'],
                'product_name'=>$sel['product_name'],
                'sqrcd'=>$req['row']['sqrcd'],
                'num'=>$req['row']['num'],
                'main_unit'=>'盘',
                'sec_unit'=>'万米',
                'date'=>date('Y-m-d'),
                'batch'=>substr(date('Ymd'),2,6),
                'l_flow'=>1,
            ];

            $num = str_pad($req['row']['num'], 3, '0', STR_PAD_LEFT);
            $qrcode = 'AB'.'92'.$sel['temple'].'0'.$print_code['print_code'].('000'.$sel['product_code']).$data['batch'].$num.$data['batch'].'000001'.'000000'.'2'.'0000'.$data['batch'].'0000000000';

            $data['pCode'] = $this->qrcode($qrcode);
            $data['qrcode'] = $qrcode;
            $this->success('成功','',$data);

        }
        return $this->view->fetch();
    }

    //公司搜索
    public function sel_n()
    {
        $name = $this->request->param()['q_word'][0];

        $where = [
            'nickname'=>new \MongoDB\BSON\Regex($name),
            'delete_time'=>'',
        ];

        $qcodeGsmc = new QcodeGsmc();
        $sel = $qcodeGsmc
            ->field('nickname')
            ->where($where)
            ->limit(0,10)
            ->select();

        return json(['list' => $sel, 'total' => count($sel)]);

    }

    //辅料名称搜索
    public function sel_p()
    {
        $name = $this->request->param()['q_word'][0];

        $where = [
            'product_name'=>new \MongoDB\BSON\Regex($name),
            'delete_time'=>'',
        ];

        $qcodeProduct = new QcodeProduct();
        $sel = $qcodeProduct
            ->field('product_name, product_code')
            ->where($where)
            ->limit(0,10)
            ->select();
        foreach ($sel as $k=>$v) {
            $oid = $v['_id']->jsonSerialize();
            $sel[$k]['id'] = $oid['$oid'];
        }
        return json(['list' => $sel, 'total' => count($sel)]);

    }
    //辅料编码搜索
    public function sel_c()
    {
        $name = $this->request->param()['q_word'][0];

        $where = [
            'product_code'=>new \MongoDB\BSON\Regex($name),
            'delete_time'=>'',
        ];

        $qcodeProduct = new QcodeProduct();
        $sel = $qcodeProduct
            ->field('id, product_name, product_code')
            ->where($where)
            ->limit(0,10)
            ->select();
        foreach ($sel as $k=>$v) {
            $oid = $v['_id']->jsonSerialize();
            $sel[$k]['id'] = $oid['$oid'];
        }
        return json(['list' => $sel, 'total' => count($sel)]);

    }

    /**
     * 二维码生成类
     */
    public function qrcode($url)//二维码生成类
    {
        $url=$url;
        $level=3;
        $size=6;
        Vendor('phpqrcode.phpqrcode');//加载生成二维码的核心类
        $errorCorrectionLevel =intval($level) ;//容错级别
        $matrixPointSize = intval($size);//生成图片大小
        //生成二维码图片
        $object = new \QRcode();
        //打开缓冲区
        ob_start();
        $object->png($url, false, $errorCorrectionLevel, $matrixPointSize, 2);
        //这里就是把生成的图片流从缓冲区保存到内存对象上，使用base64_encode变成编码字符串，通过json返回给页面。
        $imageString = base64_encode(ob_get_contents());
        //关闭缓冲区
        ob_end_clean();
        //把生成的base64字符串返回给前端
//        $data = array(
//            'labelcode'=>$url,
//            'code'=>200,
//            'data'=>$imageString,
//            'product_code'=>$url
//        );
        return 'data:image/png;base64,'.$imageString;
    }

}