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();

        $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['b.wgjs_rq'] = ['LIKE',$req['date'].'%'];
        }else{
            $this->error('参数错误');
        }

        $rows = db()->table('db_wgjs')->alias('b')
            ->field('b.wgjs_rq, b.wgjs_bh1, rtrim(r.员工姓名) as name1, rtrim(r.所在部门) as department, 
            b.wgjs_js1, rtrim(b.wgjs_yy1) as wgjs_yy1, 
            b.wgjs_bh2, b.wgjs_js2, rtrim(b.wgjs_yy2) as wgjs_yy2, 
            b.wgjs_bh3, b.wgjs_js3, rtrim(b.wgjs_yy3) as wgjs_yy3, 
            b.wgjs_bh4, b.wgjs_js4, rtrim(b.wgjs_yy4) as wgjs_yy4, 
            b.wgjs_bh5, b.wgjs_js5, rtrim(b.wgjs_yy5) as wgjs_yy5, 
            b.wgjs_bh6, b.wgjs_js6, rtrim(b.wgjs_yy6) as wgjs_yy6')
            ->where($where)
            ->join(['人事_基本资料'=>'r'],'b.wgjs_bh1 = r.员工编号')
            ->order('b.wgjs_rq desc, b.UniqId asc')
            ->page($page,$limit)
            ->select();

        foreach ($rows as $key=>$row){
            if ($row['wgjs_bh2']){
                if ($row['wgjs_bh2']==$row['wgjs_bh1']){
                    $rows[$key]['name2'] = $row['name1'];
                }else{
                    $rows[$key]['name2'] = trim(db()->table('人事_基本资料')->field('员工姓名')->where('员工编号',$row['wgjs_bh2'])->find()['员工姓名']);
                }
            }
            if ($row['wgjs_bh3']){
                if ($row['wgjs_bh3']==$row['wgjs_bh1']){
                    $rows[$key]['name3'] = $row['name1'];
                }else{
                    $rows[$key]['name3'] = trim(db()->table('人事_基本资料')->field('员工姓名')->where('员工编号',$row['wgjs_bh3'])->find()['员工姓名']);
                }
            }
            if ($row['wgjs_bh4']){
                if ($row['wgjs_bh4']==$row['wgjs_bh1']){
                    $rows[$key]['name4'] = $row['name1'];
                }else{
                    $rows[$key]['name4'] = trim(db()->table('人事_基本资料')->field('员工姓名')->where('员工编号',$row['wgjs_bh4'])->find()['员工姓名']);
                }
            }
            if ($row['wgjs_bh5']){
                if ($row['wgjs_bh5']==$row['wgjs_bh1']){
                    $rows[$key]['name5'] = $row['name1'];
                }else{
                    $rows[$key]['name5'] = trim(db()->table('人事_基本资料')->field('员工姓名')->where('员工编号',$row['wgjs_bh5'])->find()['员工姓名']);
                }
            }
            if ($row['wgjs_bh6']){
                if ($row['wgjs_bh6']==$row['wgjs_bh1']){
                    $rows[$key]['name6'] = $row['name1'];
                }else{
                    $rows[$key]['name6'] = trim(db()->table('人事_基本资料')->field('员工姓名')->where('员工编号',$row['wgjs_bh6'])->find()['员工姓名']);
                }
            }
        }

        $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);
    }
}