ExternalPlatformGoodsLists.php 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | likeadmin快速开发前后端分离管理后台(PHP版)
  4. // +----------------------------------------------------------------------
  5. // | 欢迎阅读学习系统程序代码,建议反馈是我们前进的动力
  6. // | 开源版本可自由商用,可去除界面版权logo
  7. // | gitee下载:https://gitee.com/likeshop_gitee/likeadmin
  8. // | github下载:https://github.com/likeshop-github/likeadmin
  9. // | 访问官网:https://www.likeadmin.cn
  10. // | likeadmin团队 版权所有 拥有最终解释权
  11. // +----------------------------------------------------------------------
  12. // | author: likeadminTeam
  13. // +----------------------------------------------------------------------
  14. namespace app\adminapi\lists\external;
  15. use app\adminapi\lists\BaseAdminDataLists;
  16. use app\common\model\external\ExternalPlatformGoods;
  17. use app\common\lists\ListsSearchInterface;
  18. use app\common\model\goods_category\GoodsCategory;
  19. use app\common\service\FileService;
  20. /**
  21. * ExternalPlatformGoods列表
  22. * Class ExternalPlatformGoodsLists
  23. * @package app\adminapi\lists
  24. */
  25. class ExternalPlatformGoodsLists extends BaseAdminDataLists implements ListsSearchInterface
  26. {
  27. /**
  28. * @notes 设置搜索条件
  29. * @return \string[][]
  30. * @author likeadmin
  31. * @date 2025/03/21 19:09
  32. */
  33. public function setSearch(): array
  34. {
  35. return [
  36. '=' => ['service_fee', 'goods_status', 'goods_id', 'external_goods_sn', 'external_platform_id'],
  37. ];
  38. }
  39. /**
  40. * @notes 获取列表
  41. * @return array
  42. * @throws \think\db\exception\DataNotFoundException
  43. * @throws \think\db\exception\DbException
  44. * @throws \think\db\exception\ModelNotFoundException
  45. * @author likeadmin
  46. * @date 2025/03/21 19:09
  47. */
  48. public function lists(): array
  49. {
  50. $lists = ExternalPlatformGoods::with(['goods','externalPlatform'])->where($this->searchWhere)
  51. ->field(['id', 'service_fee', 'goods_status', 'goods_id', 'external_goods_sn', 'external_platform_id'])
  52. ->limit($this->limitOffset, $this->limitLength)
  53. ->order(['id' => 'desc'])
  54. ->select()
  55. ->toArray();
  56. $goodsCategoryObj = GoodsCategory::where(['status'=>1])->order(['pid' => 'asc','weigh' => 'desc', 'id' => 'desc'])->select();
  57. foreach ($lists as &$item) {
  58. $item['goods']['goods_category_ids'] = array_map("intval",$item['goods']['goods_category_ids']);
  59. $item['goods']['goods_category_ids_str'] = implode(' / ',$goodsCategoryObj->whereIn('id', $item['goods']['goods_category_ids'])->column('name'));
  60. $item['goods']['goods_image'] = $item['goods']['goods_image'] ? FileService::getFileUrl($item['goods']['goods_image']):null;
  61. $item['goods']['goods_video'] = $item['goods']['goods_video'] ? FileService::getFileUrl($item['goods']['goods_video']):null;
  62. }
  63. return $lists;
  64. }
  65. /**
  66. * @notes 获取数量
  67. * @return int
  68. * @author likeadmin
  69. * @date 2025/03/21 19:09
  70. */
  71. public function count(): int
  72. {
  73. return ExternalPlatformGoods::where($this->searchWhere)->count();
  74. }
  75. }