InfoLists.php 2.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | likeshop开源商城系统
  4. // +----------------------------------------------------------------------
  5. // | 欢迎阅读学习系统程序代码,建议反馈是我们前进的动力
  6. // | gitee下载:https://gitee.com/likeshop_gitee
  7. // | github下载:https://github.com/likeshop-github
  8. // | 访问官网:https://www.likeshop.cn
  9. // | 访问社区:https://home.likeshop.cn
  10. // | 访问手册:http://doc.likeshop.cn
  11. // | 微信公众号:likeshop技术社区
  12. // | likeshop系列产品在gitee、github等公开渠道开源版本可免费商用,未经许可不能去除前后端官方版权标识
  13. // | likeshop系列产品收费版本务必购买商业授权,购买去版权授权后,方可去除前后端官方版权标识
  14. // | 禁止对系统程序代码以任何目的,任何形式的再发布
  15. // | likeshop团队版权所有并拥有最终解释权
  16. // +----------------------------------------------------------------------
  17. // | author: likeshop.cn.team
  18. // +----------------------------------------------------------------------
  19. namespace app\adminapi\lists\info;
  20. use app\adminapi\lists\BaseAdminDataLists;
  21. use app\common\model\Banner;
  22. use app\common\model\Info;
  23. use app\common\model\InfoCategory;
  24. class InfoLists extends BaseAdminDataLists
  25. {
  26. /**
  27. * @notes 搜索条件
  28. * @return array
  29. * @author ljj
  30. * @date 2022/3/30 5:12 下午
  31. */
  32. public function setSearch(): array
  33. {
  34. $where = [];
  35. $params = $this->params;
  36. if (isset($params['type']) && $params['type'] != '') {
  37. $where[] = ['type', '=', $params['type']];
  38. }
  39. if (isset($params['name']) && $params['name'] != '') {
  40. $where[] = ['neme', '%like%', $params['name']];
  41. }
  42. return $where;
  43. }
  44. /**
  45. * @notes 信息列表
  46. * @return array
  47. * @throws \think\db\exception\DataNotFoundException
  48. * @throws \think\db\exception\DbException
  49. * @throws \think\db\exception\ModelNotFoundException
  50. * @author ljj
  51. * @date 2022/3/30 5:40 下午
  52. */
  53. public function lists(): array
  54. {
  55. $lists = Info::where($this->setSearch())
  56. ->field('id,type,cid,title,synopsis,image,address,phone,latitude,longitude,sort,is_show,create_time,update_time')
  57. ->limit($this->limitOffset, $this->limitLength)
  58. ->append(['is_show_desc','type_desc','category'])
  59. ->order('sort desc,id desc')
  60. ->select()
  61. ->toArray();
  62. return $lists;
  63. }
  64. /**
  65. * @notes 信息数量
  66. * @return int
  67. * @author ljj
  68. * @date 2022/3/30 5:40 下午
  69. */
  70. public function count(): int
  71. {
  72. return Info::where($this->setSearch())->count();
  73. }
  74. }