<?php namespace App\Http\Services; //后台用户相关信息服务 use App\Model\SkuUploadItem; use App\Model\SupplierChannelModel; use App\Model\UserInfoModel; use Illuminate\Support\Facades\DB; class SkuUploadItemService { //获取sku审核信息 public function getSkuAuditData($goodsIds = []) { $uploadItemModel = new SkuUploadItem(); $auditData = $uploadItemModel->whereIn('sku_id', array_values($goodsIds))->select([ 'sku_id', 'audit_user', 'audit_time', ])->where('audit_user', '!=', 0)->get(); $auditData = $auditData ? $auditData->toArray() : []; $data = $userIds = []; foreach ($auditData as $key => $value) { $data[$value['sku_id']] = $value; $userIds[] = $value['audit_user']; } $userModel = new UserInfoModel(); $userIds = array_unique($userIds); $users = $userModel->whereIn('userId', $userIds)->pluck('name', 'userId'); $users = $users ? $users->toArray() : []; $data = array_map(function ($value)use ($users) { $value['audit_name'] = array_get($users, $value['audit_user']); return $value; }, $data); return $data; } }