AdService.php 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 LARAVEL研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: laravel开发员 <laravel.qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services\Common;
  12. use App\Models\AdModel;
  13. use App\Services\BaseService;
  14. use App\Services\RedisService;
  15. /**
  16. * 广告管理-服务类
  17. * @author laravel开发员
  18. * @since 2020/11/11
  19. * Class AdService
  20. * @package App\Services\Common
  21. */
  22. class AdService extends BaseService
  23. {
  24. protected static $instance = null;
  25. /**
  26. * 构造函数
  27. * @author laravel开发员
  28. * @since 2020/11/11
  29. * AdService constructor.
  30. */
  31. public function __construct()
  32. {
  33. $this->model = new AdModel();
  34. }
  35. /**
  36. * 静态入口
  37. * @return static|null
  38. */
  39. public static function make()
  40. {
  41. if (!self::$instance) {
  42. self::$instance = (new static());
  43. }
  44. return self::$instance;
  45. }
  46. /**
  47. * 按广告位获取缓存列表
  48. * @param $position
  49. * @param int $num
  50. * @return array|mixed
  51. */
  52. public function getListByPosition($position, $num=0)
  53. {
  54. $cacheKey = "caches:banners:{$position}";
  55. $datas = RedisService::get($cacheKey);
  56. if($datas){
  57. return $datas;
  58. }
  59. $showNum = \App\Services\ConfigService::make()->getConfigByCode('show_banner_num', 6);
  60. $num = $num? $num : $showNum;
  61. $datas = $this->model->where(['position'=> $position,'status'=> 1,'mark'=>1])
  62. ->select(['id','cover','title','link_type','url','mp_appid','description'])
  63. ->limit($num)
  64. ->get()
  65. ->each(function($item, $k){
  66. $item['cover'] = $item['cover']? get_image_url($item['cover']) : '';
  67. });
  68. $datas = $datas? $datas->toArray() : [];
  69. if($datas){
  70. RedisService::set($cacheKey, $datas, rand(5, 10));
  71. }
  72. return $datas;
  73. }
  74. /**
  75. * 添加或编辑
  76. * @return array
  77. * @since 2020/11/11
  78. * @author laravel开发员
  79. */
  80. public function edit()
  81. {
  82. $data = request()->all();
  83. // 图片处理
  84. if(isset($data['cover'])){
  85. $data['cover'] = get_image_path($data['cover']);
  86. }
  87. // 开始时间处理
  88. if (isset($data['start_time']) && $data['start_time']) {
  89. $data['start_time'] = strtotime($data['start_time']);
  90. }
  91. // 结束时间处理
  92. if (isset($data['end_time']) && $data['end_time']) {
  93. $data['end_time'] = strtotime($data['end_time']);
  94. } else {
  95. $data['end_time'] = 0; // 0 表示长期有效
  96. }
  97. // 如果是默认链接类型,清空小程序相关字段
  98. if (isset($data['link_type']) && $data['link_type'] == 1) {
  99. $data['mp_appid'] = '';
  100. }
  101. return parent::edit($data);
  102. }
  103. /**
  104. * 修改状态
  105. */
  106. public function status()
  107. {
  108. $params = request()->all();
  109. $id = isset($params['id']) ? intval($params['id']) : 0;
  110. $status = isset($params['status']) ? intval($params['status']) : 0;
  111. if (!$id) {
  112. return ['code' => 1, 'msg' => 'ID不能为空'];
  113. }
  114. if (!$status || ($status != 1 && $status != 2)) {
  115. return ['code' => 1, 'msg' => '状态参数错误'];
  116. }
  117. $result = $this->model->where('id', $id)->update([
  118. 'status' => $status,
  119. 'update_time' => time()
  120. ]);
  121. if ($result !== false) {
  122. return ['code' => 0, 'msg' => '状态修改成功'];
  123. }
  124. return ['code' => 1, 'msg' => '状态修改失败'];
  125. }
  126. /**
  127. * 获取数据列表(重写以支持更多字段)
  128. */
  129. public function getDataList($params, $pageSize = 15)
  130. {
  131. $query = $this->model->where('mark', 1);
  132. // 标题搜索
  133. if (isset($params['title']) && $params['title']) {
  134. $query->where('title', 'like', '%' . $params['title'] . '%');
  135. }
  136. // 位置筛选
  137. if (isset($params['position']) && $params['position'] > 0) {
  138. $query->where('position', $params['position']);
  139. }
  140. // 状态筛选
  141. if (isset($params['status']) && $params['status'] > 0) {
  142. $query->where('status', $params['status']);
  143. }
  144. $list = $query->orderBy('sort', 'desc')
  145. ->orderBy('id', 'desc')
  146. ->paginate($pageSize);
  147. $list = $list ? $list->toArray() : [];
  148. // 格式化数据
  149. if ($list && isset($list['data'])) {
  150. foreach ($list['data'] as &$item) {
  151. // 处理图片
  152. if (isset($item['cover']) && $item['cover']) {
  153. $item['cover'] = get_image_url($item['cover']);
  154. }
  155. // 处理时间
  156. $item['create_time'] = $item['create_time'] ? date('Y-m-d H:i:s', $item['create_time']) : '';
  157. $item['update_time'] = $item['update_time'] ? date('Y-m-d H:i:s', $item['update_time']) : '';
  158. $item['start_time'] = $item['start_time'] ? date('Y-m-d H:i:s', $item['start_time']) : '';
  159. $item['end_time'] = $item['end_time'] ? date('Y-m-d H:i:s', $item['end_time']) : '';
  160. }
  161. }
  162. return [
  163. 'msg' => '操作成功',
  164. 'code' => 0,
  165. 'data' => $list['data'] ?? [],
  166. 'count' => $list['total'] ?? 0,
  167. ];
  168. }
  169. }