mes-sdai-server-api/application/api/controller/PieceWorkSchedule.php

<?php

namespace app\api\controller;

use app\common\controller\Api;

/**
 * 计件工计时单维护接口
 */
class PieceWorkSchedule extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        $this->success('请求成功');
    }

    /**
     * 获取计件工计时单侧边栏
     * @ApiMethod (GET)
     */
    public function getTab()
    {
        //get请求
        if(!$this->request->isGet()){
            $this->error('请求方式错误');
        }
        $rows = db()->table('db_wgjs')
            ->field('LEFT(wgjs_rq, 7) as date')
            ->group('date')
            ->order('UniqId desc')
            ->limit(15)
            ->select();
        foreach($rows as $key=>$value){
            $rows[$key]['date'] = str_replace('-', '', $rows[$key]['date']);
        }
        $this->success('成功',$rows);
    }

    /**
     * 获取计件工计时单列表
     * @ApiMethod (GET)
     * @param string $date 时间
     * @param string $Sczl_bh1 员工编号
     */
    public function getList()
    {
        //get请求
        if(!$this->request->isGet()){
            $this->error('请求方式错误');
        }
        $req = $this->request->param();

        $page = 1;
        $limit = 15;
        if (isset($req['page']) && !empty($req['page'])) $page = $req['page'];
        if (isset($req['limit']) && !empty($req['limit'])) $limit = $req['limit'];

        $where = [];
        if (isset($req['date']) && !empty($req['date'])){
            $where['wgjs_rq'] = ['LIKE',$req['date'].'%'];
        }else{
            $this->error('参数错误');
        }

        $rows = db()->table('db_wgjs')
            ->field('LEFT(wgjs_rq, 10) as wgjs_rq, 
            wgjs_bh1, CAST(wgjs_js1 AS SIGNED) as wgjs_js1, rtrim(wgjs_yy1) as wgjs_yy1, 
            wgjs_bh2, CAST(wgjs_js2 AS SIGNED) as wgjs_js2, rtrim(wgjs_yy2) as wgjs_yy2, 
            wgjs_bh3, CAST(wgjs_js3 AS SIGNED) as wgjs_js3, rtrim(wgjs_yy3) as wgjs_yy3, 
            wgjs_bh4, CAST(wgjs_js4 AS SIGNED) as wgjs_js4, rtrim(wgjs_yy4) as wgjs_yy4, 
            wgjs_bh5, CAST(wgjs_js5 AS SIGNED) as wgjs_js5, rtrim(wgjs_yy5) as wgjs_yy5, 
            wgjs_bh6, CAST(wgjs_js6 AS SIGNED) as wgjs_js6, rtrim(wgjs_yy6) as wgjs_yy6')
            ->where($where)
            ->order('wgjs_rq desc, UniqId asc')
            ->page($page,$limit)
            ->select();

        $rs = db()->table('人事_基本资料')->column('员工编号, 员工姓名, 所在部门');

        foreach ($rows as $key=>$value){
            $rows[$key]['wgjs_js1'] = $value['wgjs_js1'] == 0 ? '' : $value['wgjs_js1'];
            //存在该员工编号
            if (array_key_exists($value['wgjs_bh1'],$rs)){
                $rows[$key]['department'] = trim($rs[$value['wgjs_bh1']]['所在部门']);
                $rows[$key]['name1'] = trim($rs[$value['wgjs_bh1']]['员工姓名']);
                for ($i=2;$i<=6;$i++){
                    $rows[$key]['wgjs_js'.$i] = $value['wgjs_js'.$i] == '0.0' ? '' : $value['wgjs_js'.$i];
                    if ($value['wgjs_bh'.$i]){
                        if ($value['wgjs_bh'.$i]==$value['wgjs_bh1']){
                            $rows[$key]['name'.$i] = $rows[$key]['name1'];
                        }else{
                            $rows[$key]['name'.$i] = trim($rs[$value['wgjs_bh'.$i]]['员工姓名']);
                        }
                    }
                }
            }else{
                $rows[$key]['department'] = '';
                $rows[$key]['name1'] = '';
                for ($i=2;$i<=6;$i++){
                    $rows[$key]['wgjs_js'.$i] = $value['wgjs_js'.$i] == '0.0' ? '' : $value['wgjs_js'.$i];
                    if ($value['wgjs_bh'.$i]){
                        $rows[$key]['name'.$i] = '';
                    }
                }
            }
        }

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

    /**
     * 获取计件工计时单信息
     * @ApiMethod (GET)
     * @param string $UniqId UniqId
     */
    public function getInfo()
    {
        //get请求
        if(!$this->request->isGet()){
            $this->error('请求方式错误');
        }
        $req = $this->request->param();
        if (isset($req['UniqId']) && !empty($req['UniqId'])){
            $UniqId = $req['UniqId'];
        }else{
            $this->error('参数错误');
        }

        $rows = db()->table('db_wgjs')->alias('d')
            ->field('d.*, ')
            ->join('工单_基本资料 g', 'd.')
            ->where('d.UniqId',$UniqId)
            ->select();


        $this->success('成功',$rows);
    }
}