tool/application/admin/controller/Jar.php

<?php

namespace app\admin\controller;

use app\common\controller\Backend;
use think\Db;
use Think\Exception;

/**
 * 油墨罐配置
 *
 * @icon fa fa-circle-o
 */
class Jar extends Backend
{
    protected $noNeedLogin = ['*'];
    /**
     * Jar模型对象
     * @var \app\admin\model\Jar
     */
    protected $model = null;

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

    }
    
    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */
    public function getOrder(){
        $where = [];
        $pagesize   = 10;
        $page  = 0;
        // $result = [
        //     'code'    => '0',
        //     'message' => '请求成功',
        //     'data'    =>  ''
        // ];
        $data = input('');
        if($data['gd_gdbh'] !== '-1'){
            $where['Gd_gdbh'] = $data['gd_gdbh'];
        }
//        $where['行号'] = 1;
        //分页的页面显示数
        if($data['pagesize']){
            $pagesize = $data['pagesize'];
        }
        //当前分页的页数
        if($data['page']){
            $startpage = ($data['page']-1)*$pagesize;
        }
        
        //有分页
        if(isset($startpage) && $startpage >= 0){
            // print_r(1111);
            if($data['gd_gdbh'] == '-1'){
                $res = Db::name('formula')->column('product_number');
                $res = array_values(array_unique($res));
                $list = array();
                foreach ($res as $key=>$value){
                    $value = explode(',',$value);
                    foreach($value as $k=>$v){
                        array_push($list,$v);
                    }
                }
                $list = array_filter($list);
                $where['Gd_cpdh'] = array('in',$list);
                $where['gd_statu'] = '2-生产中';
            }
            
            $total =  Db::connect('db2')->table('工单_基本资料')->where($where)->order('gd_gdbh desc')->select();
            $info =   Db::connect('db2')->table('工单_基本资料')->field('Gd_gdbh as gd_gdbh,Gd_cpmc as gd_cpmc,gd_statu,订单数量,计量单位,接单日期')->where($where)->order('gd_gdbh desc')->limit($startpage,$pagesize)->select();
            
            $result['data'] =  $info ;
            $result['total'] = count($total) ;
        }else{
            $info = Db::connect('db2')->table('工单_基本资料')->where($where)->order('gd_gdbh desc')->limit($startpage,$pagesize)->select();
            $total = count($info);
            $result['data'] =  $info  ;
        }
        return json(array('data'=>$info,'total'=>$result['total']));
    }
    //获取工单详情
    public function getorderdetail(){
        $result =  [
            'code' => 0,
            'message' => '请求成功',
            'data'   => '',
        ];

        $data = $_REQUEST?$_REQUEST:'';
        if(!isset($data['Gd_gdbh'])){
            $result =  [
                'code' => 1,
                'message' => '工单编号不能为空',
                'data'   => '',
            ];
            return json($result);
        }
        $where['Gd_gdbh'] = $data['Gd_gdbh'];
//        $where['行号']    = 1;
        $field = "Gd_gdbh as gd_gdbh,订单数量,计量单位,成品名称,成品代号,Gd_cpdh as gd_cpdh";
        $info = Db::connect('db2')->table('工单_基本资料')->field($field)->where($where)->find();
        if($info){
            $result['data'] = $info;
        }else{
            $result =  [
                'code' => 2,
                'message' => '该工单不存在',
                'data'   => '',
            ];
        }
        return json($result);
    }

}