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 '访问成功';}

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

    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_printCardPrintFields()
{
    $data = Db::table('print_card')
        ->field('编码,物品名称,存放地点,使用部门')
        ->select();
    
    // 根据物品名称进行分组
    $groupedData = [];
    foreach ($data as $item) {
        $itemName = $item['物品名称'];
        if (!isset($groupedData[$itemName])) {
            $groupedData[$itemName] = [];
        }
        $groupedData[$itemName][] = $item;
    }
    
    return json([
        'code' => 0,
        'msg' => '请求成功',
        'data' => $groupedData
    ]);
}

}