";
//        print_r($qcode_bach_list);
//        echo "
";

        $mongo = \think\Db::connect('mongodb');


        $where = [
            'gdbh' => $qcode_bach_list['matter_no'],
            'order_ddbh' => $qcode_bach_list['order_ddbh'],
            'cpbm' => $qcode_bach_list['cpbm'],
            'cpmc' => $qcode_bach_list['matter_name'],
        ];
        $inventory_summary = $mongo->name('inventory_summary')
            ->where($where)
            ->find();
        $updateResult = $mongo->name('inventory_summary')
            ->where($where)
            ->update([
                'total_ru_quantity' => $inventory_summary['total_ru_quantity'] - $qcode_bach_list['num'],
                'total_chu_quantity' => $inventory_summary['total_chu_quantity'] - $qcode_bach_list['num'],
                'remaining_quantity' => $inventory_summary['remaining_quantity'] + $qcode_bach_list['num'],
                'updated_at'       => date('Y-m-d H:i:s'),
            ]);

        $where = [
            'gdbh' => $qcode_bach_list['matter_no'],
            'order_ddbh' => $qcode_bach_list['order_ddbh'],
            'cpbm' => $qcode_bach_list['cpbm'],
            'cpmc' => $qcode_bach_list['matter_name'],
            'total_chu_quantity' => $qcode_bach_list['num'],
        ];
        $inventory_records_updateResult = $mongo->name('inventory_records')
            ->where($where)
            ->update([
                'mod_rq' => date('Y-m-d H:i:s')
            ]);

        $data = [
            'delete_time'=>time(),
        ];
        $bool1 = $this->model->name($company_id.'_'."qcode_bach")->where('_id',$ids)->update($data);
        $bool2 = $qcodeLarge->name($company_id.'_'."qcode_large")->where('bach_id',$ids)->update($data);
        $bool3 = $qcodeSmall->name($company_id.'_'."qcode_small")->where('bach_id',$ids)->update($data);

        if($bool1!==false && $bool2!==false && $bool3!==false){
            $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;
    }

}