dm-v2.com/Application/Admin/Controller/ApplyBatchController.class.php 9.20

<?php
/**
 * author Gentle
 * intro 申请批次
 */

namespace Admin\Controller;

use Think\Page;

class ApplyBatchController extends AdminController
{
    /**
     * author Gentle
     * intro 类初始化方法
     * param
     * return
     */
    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
        $this->uid = session('user_auth.uid');
    }

    /**
     * author Gentle
     * intro 获取用户组
     * param
     */
    public function GetGroups()
    {
        $uid = $this->uid;
        $admin_access_model = D(Admin_access);
        $groups = $admin_access_model->where('uid=' . $uid)->getField('group');//1 超级管理 2 印刷厂 3 中烟
        return $groups;
    }

    /**
     * author Gentle
     * intro 申请批次首页
     * param
     */
    public function Index()
    {
        /**
         * @author Gentle
         * @tro 遍历展示产品名称、盒型
         * @time 2017年9月11日09:35:58
         */
        $printer_list = M(Admin_access)
            ->join('__ADMIN_USER__ ON __ADMIN_USER__.id = __ADMIN_ACCESS__.uid')
            ->field('QR_ADMIN_USER.id printer_id,QR_ADMIN_USER.nickname printer_name')
            ->where('QR_ADMIN_ACCESS.group=2')->order('QR_ADMIN_USER.id asc')->select();
        foreach ($printer_list as $val) {
            $printer[] = $val;
        }

        $factory_model = D(Factory);
        $list2 = $factory_model->field('id,name')->where('id>0')->order('id asc')->select();
        foreach ($list2 as $val) {
            $factory_result[] = $val;
            $factory_id[] = $val['id'];
        }
        $product_model = D(Product);
        $list = $product_model->field('id,name')->where('factory_id IN (' . implode(',', $factory_id) . ')')->order('id asc')->select();
        foreach ($list as $val) {
            $product_result[] = $val;
            $product_id[] = $val['id'];
        }

        //暂时不使用
        $list2 = M(Product_box_type)
            ->join('__BOX_TYPE__ ON __BOX_TYPE__.id = __PRODUCT_BOX_TYPE__.box_type_id')
            ->field('QR_BOX_TYPE.id type_id,QR_BOX_TYPE.name box_type_name')
            ->where('QR_PRODUCT_BOX_TYPE.product_id>0')->order('QR_PRODUCT_BOX_TYPE.id asc')->select();
        foreach ($list2 as $val) {
            $box_type_result[] = $val['type_id'];
        }

        $this->assign('printer', $printer);
        $this->assign('product_result', $product_result);
        $this->assign('factory_result', $factory_result);
        $this->assign('meta_title', '申请批次');
        $this->display();
    }

    /**
     * author Gentle
     * intro 申请批次列表页面
     * param
     */
    public function ApplyList()
    {
        /**
         * @author Gentle
         * @tro 遍历展示申请批次列表
         * @time 2017年9月12日14:17:17
         */
        //分页
        $bach = M(Bach);
        $owner_id = $this->uid;
        $page = new Page(
            $bach->where('owner_id=' . $owner_id)->count(),
            C('ADMIN_PAGE_ROWS')
        );
        $show = $page->show();
        $groups = $this->GetGroups();
        if ($groups = '3') {
            $where = 'QR_BACH.owner_id';
        } else if ($groups = '2') {
            $where = 'QR_BACH.printer_id';
        } else {
            $where = 'QR_BACH.id > 0';
        }

        $bach_list = M(Bach)
            ->join('__ADMIN_USER__ ON __ADMIN_USER__.id = __BACH__.printer_id')
            ->field('QR_BACH.id bach_id,QR_BACH.name bach_name,QR_BACH.add_time,QR_ADMIN_USER.nickname printer_name')
            ->limit($page->firstRow . ',' . $page->listRows)
            ->where($where)->order('QR_BACH.id desc')->select();

        $this->assign('bach_page', $show);
        $this->assign('bach_list', $bach_list);
        $this->assign('meta_title', '批次列表');
        $this->display();
    }

    /**
     * author Gentle
     * intro 任务列表页面
     * param
     */
    public function TaskList()
    {
        /**
         * @author Gentle
         * @tro 遍历展示申请批次列表
         * @time 2017年9月15日13:17:17
         */
        $bach_id = $_GET['bach_id'];
        //分页
        $task = M(Task);
        $page = new Page(
            $task->where('bach_id=' . $bach_id)->count(),
            C('ADMIN_PAGE_ROWS')
        );
        $show = $page->show();

        $task_ids = $task->field('id,bach_id,product_id')->where('bach_id=' . $bach_id)->order('id desc')->select();
        foreach ($task_ids as $val) {
            $task_list[] = M(Task)
                ->join('__FACTORY__ ON __FACTORY__.id=__TASK__.factory_id ')
                ->join('__ADMIN_USER__ ON __ADMIN_USER__.id = __TASK__.printer_id')
                ->join('__PRODUCT_BOX_TYPE__ ON __PRODUCT_BOX_TYPE__.id=__TASK__.product_id')
                ->join('__PRODUCT__ ON __PRODUCT__.id=__PRODUCT_BOX_TYPE__.product_id')
                ->join('__BOX_TYPE__ ON __BOX_TYPE__.id=__PRODUCT_BOX_TYPE__.box_type_id')
                ->field('QR_PRODUCT_BOX_TYPE.product_id,QR_ADMIN_USER.nickname printer_name,QR_TASK.id task_id,QR_TASK.name task_name,QR_TASK.quality,QR_TASK.add_time,QR_TASK.is_verif,QR_TASK.bach_id,QR_TASK.status,QR_FACTORY.name factory_name,QR_PRODUCT.name product_name,QR_BOX_TYPE.name box_type_name')
                ->where('QR_TASK.id= ' . $val['id'])->select();
        }
        foreach ($task_list as $val) {
            foreach ($val as $v) {
                $v['filename'] = $v['bach_id'] . '_' . $v['task_id'] . '_' . $v['product_id'];
                $task_list2[] = $v;

            }
        }
        $this->assign('task_page', $show);
        $this->assign('task_list', $task_list2);
        $this->assign('meta_title', '批次列表');
        $this->display();
    }

    /**
     * author Gentle
     * intro 任务详情页面
     * param 2017年9月15日15:31:22
     */
    public function TaskDetail()
    {
        /**
         * @author Gentle
         * @tro 批次详情页面展示
         * @time 2017年9月13日19:27:28
         */
        $task_id = $_GET['task_id'];
        $task_detail = M(Task)
            ->join('__FACTORY__ ON __FACTORY__.id=__TASK__.factory_id ')
            ->join('__PRODUCT_BOX_TYPE__ ON __PRODUCT_BOX_TYPE__.id=__TASK__.product_id')
            ->join('__PRODUCT__ ON __PRODUCT__.id=__PRODUCT_BOX_TYPE__.product_id')
            ->join('__BOX_TYPE__ ON __BOX_TYPE__.id=__PRODUCT_BOX_TYPE__.box_type_id')
            ->field('QR_TASK.id task_id,QR_TASK.name task_name,QR_TASK.quality,QR_TASK.redundancy,QR_TASK.add_time,QR_TASK.is_verif,QR_TASK.bach_id,QR_TASK.status,QR_FACTORY.name factory_name,QR_PRODUCT.name product_name,QR_BOX_TYPE.name box_type_name')
            ->where('QR_TASK.id=' . $task_id)->order('QR_TASK.id asc')->select();

        $this->assign('task_detail', $task_detail);
        $this->assign('meta_title', '批次详情');
        $this->display();
    }

    /**
     * author Gentle
     * intro 申请批次方法
     * param
     * return  bool
     */
    public function ApplyForm()
    {
        if (IS_POST) {
            $bach_object = D("Bach");
            $bach_product_object = D("Bach_product");
            $task_object = D("Task");
            //校验$_POST数据
            if (empty($_POST['product_id'])) {
                alert(array('info' => '产品不能为空', 'status' => 2));
                exit;
            }
            if (empty($_POST['factory_id'])) {
                alert(array('info' => '工厂名称不能为空', 'status' => 3));
                exit;
            }
            if (empty($_POST['printer_id'])) {
                alert(array('info' => '印刷厂名称不能为空', 'status' => 4));
                exit;
            }
            if (empty($_POST['code_num1']) and empty($_POST['code_num2'])) {
                alert(array('info' => '条盒、小包数量必须有一个大于0', 'status' => 5));
                exit;
            }

            $product_id = $_POST['product_id'];
            $factory_id = $_POST['factory_id'];
            $printer_id = $_POST['printer_id'];
            $is_verif = $_POST['is_verif'];
            $remark = $_POST['remark'];
            $code_num = [
                'code_num1' => $_POST['code_num1'],
                'code_num2' => $_POST['code_num2']
            ];
            //查找产品、类别关联表
            $product_box_type_ids = M(Product_box_type)
                ->field('id')
                ->where('product_id=' . $product_id)->order('box_type_id asc')->select();
            foreach ($product_box_type_ids as $val) {
                $product_box_type_id[] = $val['id'];
            }

            $data = [];
            $data['name'] = 'MNYH_' . date("Ymdhi", time());
            $data['add_time'] = time();
            $data['remark'] = $remark;
            $data['printer_id'] = $printer_id;
            $data['owner_id'] = $this->uid;

            $param = [];
            $param['product_id'] = $product_id;
            $param['is_verif'] = $is_verif;
            $param['add_time'] = time();
            $param['remark'] = $remark;
            $param1 = $param;
            $param2 = $param;
            $param1['num'] = $code_num['code_num1'];
            $param1['product_id'] = $product_box_type_id[0];
            $param2['num'] = $code_num['code_num2'];
            $param2['product_id'] = $product_box_type_id[1];

            $add_param = [
                $param1,
                $param2
            ];

            $params = [];
            $params['name'] = $data['name'];
            $params['factory_id'] = $factory_id;
            $redundancy_s = 0.1;//冗码率
            $params['is_verif'] = $is_verif;
            $params['add_time'] = time();
            $params['remark'] = $remark;
            $params['status'] = '0';
            $params['printer_id'] = $printer_id;
            $params['owner_id'] = $this->uid;
            $params1 = $params;
            $params2 = $params;

            $params1['quality'] = $code_num['code_num1'];
            $params1['redundancy'] = $code_num['code_num1'] * $redundancy_s;
            $params1['product_id'] = $product_box_type_id[0];
            $params2['quality'] = $code_num['code_num2'];
            $params2['redundancy'] = $code_num['code_num2'] * $redundancy_s;
            $params2['product_id'] = $product_box_type_id[1];

            if ($data && $add_param) {
                $bach_id = $bach_object->add($data);
                $param1['bach_id'] = $bach_id;
                $param2['bach_id'] = $bach_id;
                $add_param = [
                    $param1,
                    $param2
                ];
                $bach_product_id = $bach_product_object->addAll($add_param);
                if ($bach_id && $bach_product_id) {
                    $params1['bach_id'] = $bach_id;
                    $params2['bach_id'] = $bach_id;
                    $add_params = [
                        $params1,
                        $params2
                    ];
                    $task_id = $task_object->addAll($add_params);
                    if ($task_id) {
                        alert(array('info' => '申请成功', 'url' => "index.php?s=/Admin/ApplyBatch/applylist.html", 'status' => 1));
                    } else {
                        alert(array('info' => '申请失败', 'url' => "__SELF__", 'status' => 0));
                    }
                } else {
                    $this->error($bach_object->getError());
                }
            } else {
                $this->error($bach_object->getError());
            }
        } else {
            // 跳转到申请批次页面
            header("Location: {:U('ApplyBatch/applylist')}");

        }
    }

    /**
     * author Gentle
     * intro 调用下载函数
     * param
     */
    public function DownloadZip()
    {
        $bach_id = $_GET['bach_id'];
        if (!downZip($bach_id)) {
            if (session('user_auth.uid') == 1) {
                $this->error('暂不支持管理员操作');
            } else {
                $this->error('文件不存在，请联系管理员');
            }
        }

    }

}