Adv.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和使用。
  9. * 任何企业和个人不允许对程序代码以任何形式任何目的再发布。
  10. * =========================================================
  11. */
  12. namespace addon\pc\shop\controller;
  13. use app\model\web\Adv as AdvModel;
  14. use app\model\web\AdvPosition;
  15. use addon\pc\model\Pc as PcModel;
  16. use app\shop\controller\BaseShop;
  17. /**
  18. * 广告管理
  19. */
  20. class Adv extends BaseShop
  21. {
  22. /**
  23. * 广告位管理
  24. * @return mixed
  25. */
  26. public function index()
  27. {
  28. $adv_position = new AdvPosition();
  29. if (request()->isAjax()) {
  30. $page = input('page', 1);
  31. $page_size = input('page_size', PAGE_LIST_ROWS);
  32. $search_text = input('search_text', '');
  33. $type = input('type', '');//位置类型 1 电脑端 2 手机端
  34. $condition = [
  35. [ 'site_id', '=', $this->site_id ],
  36. [ 'type', '=', 1 ]
  37. ];
  38. if (!empty($search_text)) {
  39. $condition[] = [ 'ap_name', 'like', '%' . $search_text . '%' ];
  40. }
  41. if ($type !== '') {
  42. $condition[] = [ 'type', '=', $type ];
  43. }
  44. return $adv_position->getAdvPositionPageList($condition, $page, $page_size);
  45. } else {
  46. $this->forthMenu();
  47. return $this->fetch("adv/index");
  48. }
  49. }
  50. /**
  51. * 添加广告位
  52. */
  53. public function addPosition()
  54. {
  55. $adv_position = new AdvPosition();
  56. if (request()->isAjax()) {
  57. $data = [
  58. 'ap_name' => input('ap_name', ''),
  59. 'keyword' => input('keyword', ''),
  60. 'ap_intro' => input('ap_intro', ''),
  61. 'ap_height' => input('ap_height', 0),
  62. 'ap_width' => input('ap_width', 0),
  63. 'default_content' => input('default_content', ''),
  64. 'ap_background_color' => input('ap_background_color', ''),
  65. 'type' => input('type', 1),
  66. 'site_id' => $this->site_id,
  67. 'state' => input('state', 0),
  68. ];
  69. return $adv_position->addAdvPosition($data);
  70. } else {
  71. return $this->fetch("adv/add_position");
  72. }
  73. }
  74. /**
  75. * 编辑广告位
  76. */
  77. public function editPosition()
  78. {
  79. $adv_position = new AdvPosition();
  80. $ap_id = input('ap_id', 0);
  81. if (request()->isAjax()) {
  82. $data = [
  83. 'ap_name' => input('ap_name', ''),
  84. 'keyword' => input('keyword', ''),
  85. 'ap_intro' => input('ap_intro', ''),
  86. 'ap_height' => input('ap_height', 0),
  87. 'ap_width' => input('ap_width', 0),
  88. 'default_content' => input('default_content', ''),
  89. 'ap_background_color' => input('ap_background_color', ''),
  90. 'state' => input('state', 0),
  91. ];
  92. return $adv_position->editAdvPosition($data, [ [ 'ap_id', '=', $ap_id ], [ 'site_id', '=', $this->site_id ] ]);
  93. } else {
  94. $ap_info = $adv_position->getAdvPositionInfo([ [ 'ap_id', '=', $ap_id ], [ 'site_id', '=', $this->site_id ] ]);
  95. $this->assign('info', $ap_info[ 'data' ]);
  96. return $this->fetch("adv/edit_position");
  97. }
  98. }
  99. /**
  100. * 修改广告位字段
  101. */
  102. public function editPositionField()
  103. {
  104. if (request()->isAjax()) {
  105. $adv_position = new AdvPosition();
  106. $type = input('type', '');
  107. $value = input('value', 0);
  108. $ap_id = input('ap_id', 0);
  109. $data = [
  110. $type => $value
  111. ];
  112. return $adv_position->editAdvPosition($data, [ [ 'ap_id', '=', $ap_id ] ]);
  113. }
  114. }
  115. /**
  116. * 删除广告位
  117. */
  118. public function deletePosition()
  119. {
  120. if (request()->isAjax()) {
  121. $ap_ids = input('ap_ids', 0);
  122. $adv_position = new AdvPosition();
  123. return $adv_position->deleteAdvPosition([ [ 'ap_id', 'in', $ap_ids ], [ 'site_id', '=', $this->site_id ] ], $ap_ids);
  124. }
  125. }
  126. /**
  127. * 广告列表
  128. */
  129. public function lists()
  130. {
  131. $adv = new AdvModel();
  132. $adv_position = new AdvPosition();
  133. $ap_id = input('ap_id', '');
  134. if (request()->isAjax()) {
  135. $page = input('page', 1);
  136. $page_size = input('page_size', PAGE_LIST_ROWS);
  137. $search_text = input('search_text', '');
  138. $ap_id = input('ap_id', '');
  139. //查询所有手机端广告位
  140. $conditions[] = [ 'type', '=', 1 ];
  141. $positions = $adv_position->getAdvPositionList($conditions);
  142. $positions_ids = array_column($positions[ 'data' ], 'ap_id');
  143. $condition = [
  144. [ 'a.site_id', '=', $this->site_id ],
  145. [ 'a.ap_id', 'in', $positions_ids ]
  146. ];
  147. if (!empty($search_text)) {
  148. $condition[] = [ 'a.adv_title', 'like', '%' . $search_text . '%' ];
  149. }
  150. if ($ap_id !== '') {
  151. $condition[] = [ 'a.ap_id', '=', $ap_id ];
  152. }
  153. //排序
  154. $order = input('order', 'slide_sort');
  155. $sort = input('sort', 'desc');
  156. if ($order == 'slide_sort') {
  157. $order_by = 'a.' . $order . ' ' . $sort;
  158. } else {
  159. $order_by = 'a.' . $order . ' ' . $sort . ',a.slide_sort desc';
  160. }
  161. return $adv->getAdvPageList($condition, $page, $page_size, $order_by);
  162. } else {
  163. $this->assign('ap_id', $ap_id);
  164. $this->forthMenu();
  165. $adv_position = new AdvPosition();
  166. $adv_position_list = $adv_position->getAdvPositionList([ [ 'site_id', '=', $this->site_id ], [ 'type', '=', 1 ] ], 'ap_id,ap_name');
  167. $this->assign('adv_position', $adv_position_list[ 'data' ]);
  168. return $this->fetch("adv/lists");
  169. }
  170. }
  171. /**
  172. * 添加广告
  173. */
  174. public function addAdv()
  175. {
  176. $adv = new AdvModel();
  177. if (request()->isAjax()) {
  178. $data = [
  179. 'ap_id' => input('ap_id', 0),
  180. 'adv_title' => input('adv_title', ''),
  181. 'adv_url' => input('adv_url', ''),
  182. 'adv_image' => input('adv_image', ''),
  183. 'slide_sort' => input('slide_sort', 0),
  184. 'price' => input('price', 0),
  185. 'background' => input('background', ''),
  186. 'state' => input('state', 0),
  187. 'site_id' => $this->site_id
  188. ];
  189. return $adv->addAdv($data);
  190. } else {
  191. $pc_model = new PcModel();
  192. $pc_link = $pc_model->getLink();
  193. $this->assign("pc_link", $pc_link);
  194. $adv_position = new AdvPosition();
  195. $adv_position_list = $adv_position->getAdvPositionList([
  196. [ 'site_id', '=', $this->site_id ],
  197. [ 'type', '=', 1 ],
  198. ]);
  199. $this->assign('adv_position_list', $adv_position_list[ 'data' ]);
  200. $ap_id = input('ap_id', 0);
  201. $this->assign('ap_id', $ap_id);
  202. return $this->fetch("adv/add_adv");
  203. }
  204. }
  205. /**
  206. * 编辑广告
  207. */
  208. public function editAdv()
  209. {
  210. $adv_id = input('adv_id', '');
  211. $adv = new AdvModel();
  212. if (request()->isAjax()) {
  213. $data = [
  214. 'ap_id' => input('ap_id', 0),
  215. 'adv_title' => input('adv_title', ''),
  216. 'adv_url' => input('adv_url', ''),
  217. 'adv_image' => input('adv_image', ''),
  218. 'slide_sort' => input('slide_sort', 0),
  219. 'price' => input('price', 0),
  220. 'background' => input('background', ''),
  221. 'state' => input('state', 0),
  222. ];
  223. return $adv->editAdv($data, [ [ 'adv_id', '=', $adv_id ], [ 'site_id', '=', $this->site_id ] ]);
  224. } else {
  225. $pc_model = new PcModel();
  226. $pc_link = $pc_model->getLink();
  227. $this->assign("pc_link", $pc_link);
  228. $adv_position = new AdvPosition();
  229. $adv_position_list = $adv_position->getAdvPositionList([
  230. [ 'site_id', '=', $this->site_id ],
  231. [ 'type', '=', 1 ],
  232. ]);
  233. $this->assign('adv_position_list', $adv_position_list[ 'data' ]);
  234. $adv_info = $adv->getAdvInfo($adv_id);
  235. //得出推荐宽高
  236. foreach ($adv_position_list[ 'data' ] as $k => $v) {
  237. if ($v[ 'ap_id' ] == $adv_info[ 'data' ][ 'ap_id' ]) {
  238. $adv_info[ 'data' ][ 'ap_width' ] = $v[ 'ap_width' ];
  239. $adv_info[ 'data' ][ 'ap_height' ] = $v[ 'ap_height' ];
  240. }
  241. }
  242. $this->assign('adv_info', $adv_info[ 'data' ]);
  243. // 得到当前广告图类型
  244. $type = 2;// 1 pc、2 wap
  245. foreach ($adv_position_list[ 'data' ] as $k => $v) {
  246. if ($v[ 'ap_id' ] == $adv_info[ 'data' ][ 'ap_id' ]) {
  247. $type = $v[ 'type' ];
  248. break;
  249. }
  250. }
  251. $this->assign("type", $type);
  252. $ap_id = input('ap_id', 0);
  253. $this->assign('ap_id', $ap_id);
  254. return $this->fetch("adv/edit_adv");
  255. }
  256. }
  257. /**
  258. * 修改广告字段
  259. */
  260. public function editAdvField()
  261. {
  262. if (request()->isAjax()) {
  263. $adv = new AdvModel();
  264. $type = input('type', '');
  265. $value = input('value', '');
  266. $adv_id = input('adv_id', '');
  267. $data = [
  268. $type => $value
  269. ];
  270. return $adv->editAdv($data, [ [ 'adv_id', '=', $adv_id ] ]);
  271. }
  272. }
  273. /**
  274. * 删除广告
  275. */
  276. public function deleteAdv()
  277. {
  278. if (request()->isAjax()) {
  279. $adv_ids = input('adv_ids', 0);
  280. $adv = new AdvModel();
  281. return $adv->deleteAdv([ [ 'adv_id', 'in', $adv_ids ], [ 'site_id', '=', $this->site_id ] ]);
  282. }
  283. }
  284. /**
  285. * 修改广告位状态
  286. * @return array
  287. */
  288. public function alterAdvPositionState()
  289. {
  290. if (request()->isAjax()) {
  291. $ap_id = input('ap_id', 0);
  292. $state = input('state', 0);
  293. $ap_model = new AdvPosition();
  294. return $ap_model->editAdvPosition([ 'state' => $state ], [ [ 'ap_id', '=', $ap_id ], [ 'site_id', '=', $this->site_id ] ]);
  295. }
  296. }
  297. /**
  298. * 修改广告状态
  299. * @return array
  300. */
  301. public function alterAdvState()
  302. {
  303. if (request()->isAjax()) {
  304. $adv_id = input('adv_id', 0);
  305. $state = input('state', 0);
  306. $ap_model = new AdvModel();
  307. return $ap_model->editAdv([ 'state' => $state ], [ [ 'adv_id', '=', $adv_id ], [ 'site_id', '=', $this->site_id ] ]);
  308. }
  309. }
  310. }