tool/application/api/controller/Index.php

<?php

namespace app\api\controller;

use app\common\controller\Api;

use think\Db;
use Think\Exception;
/**
 * 首页接口
 */
class Index extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        $this->success('请求111');
    }
    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;
        $where['gd_statu'] = '2-生产中';
        //分页的页面显示数
        if($data['pagesize']){
            $pagesize = $data['pagesize'];
        }
        //当前分页的页数
        if($data['page']){
            $startpage = ($data['page']-1)*$pagesize;
        }

        //有分页
        if(isset($startpage) && $startpage >= 0){

            $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);
            $info =   Db::connect('db2')->table('工单_基本资料')->where($where)->order('gd_gdbh desc')->limit($startpage,$pagesize)->select();
            $result['data'] =  $info ;
        }else{
            $info = Db::connect('db2')->table('工单_基本资料')->where($where)->order('gd_gdbh desc')->limit($startpage,$pagesize)->select();
            $total = count($info);
            $result['data'] =  $info  ;
        }
        $this->success('请求成功',$info);
    }
    //获取工单详情
    public function getorderdetail(){
        $result =  [
            'code' => 0,
            'message' => '请求成功',
            'data'   => '',
        ];

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