mes-zs-server-api/application/api/controller/WorkOrder.php

<?php
namespace app\api\controller;

use app\common\controller\Api;
use app\job\ImageJob;
use app\service\AIGatewayService;
use app\service\ImageService;
use think\App;
use think\Db;
use think\Exception;
use think\Log;
use think\Queue;
use think\queue\job\Redis;
use think\Request;





class WorkOrder extends Api{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];
    public function index(){echo '访问成功';}

 /**
     * 获取url
     */
    public function GetUrl(){
        $data = Db::table('url')->find();
        $res = [
            'code' => 0,
            'msg' => '成功',
            'data' => [
                'UniqID' => $data['UniqID'],
                'url' => $data['url'],
            ]
        ];
        return json($res);
    }



    /**
     * 获取打印左侧数据
     */

    public function Get_PrintFields()
    {
        $data = Db::table('zs_printdata')
            ->field('code,signature,name,position')
            ->select();
        return json([
            'code' => 0,
            'msg' => '请求成功',
            'data' => $data
        ]);
    }




        /**
     * 获取老挝证书打印左侧数据
     */

     public function Get_lwPrintFields()
     {
         $data = Db::table('zs_printdata_lw')
             ->field('name,address,GCP,GLN,startdate,enddate,code')
             ->select();
         return json([
             'code' => 0,
             'msg' => '请求成功',
             'data' => $data
         ]);
     }

        /**
     * 获取工商学生证书打印左侧数据
     */

     public function Get_studentPrintFields()
     {
         $data = Db::table('zs_printdata_student')
             ->field('Name,College,Department')
             ->select();
         return json([
             'code' => 0,
             'msg' => '请求成功',
             'data' => $data
         ]);
     }
     

             /**
     * 获取工商学生获奖证书打印左侧数据
     */

     public function Get_awardPrintFields()
     {
         $data = Db::table('zs_printdata_award')
             ->field('Name,Award,Date')
             ->select();
         return json([
             'code' => 0,
             'msg' => '请求成功',
             'data' => $data
         ]);
     }

             /**
     * 获取打码卡片打印左侧数据
     */

public function Get_printCardPrintFields()
{
    $data = Db::table('print_card')
        ->field('编码,物品名称,存放地点,使用部门,group_id') // 加上 group_id 字段
        ->select();

    // 先按 group_id 分组，再按 物品名称 分组
    $groupedData = [];
    foreach ($data as $item) {
        $groupId = $item['group_id'];
        $itemName = $item['物品名称'];

        // 初始化第一层分组（按 group_id）
        if (!isset($groupedData[$groupId])) {
            $groupedData[$groupId] = [];
        }

        // 初始化第二层分组（按 物品名称）
        if (!isset($groupedData[$groupId][$itemName])) {
            $groupedData[$groupId][$itemName] = [];
        }

        // 将当前记录放入对应分组
        $groupedData[$groupId][$itemName][] = $item;
    }

    return json([
        'code' => 0,
        'msg' => '请求成功',
        'data' => $groupedData
    ]);
}

}