EventRegistration.php 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\admin\model\ump;
  12. use traits\ModelTrait;
  13. use basic\ModelBasic;
  14. use app\admin\model\merchant\Merchant;
  15. use service\WechatTemplateService;
  16. use app\wap\model\routine\RoutineTemplate;
  17. use app\admin\model\wechat\WechatUser;
  18. use service\SystemConfigService;
  19. use think\Db;
  20. class EventRegistration extends ModelBasic
  21. {
  22. use ModelTrait;
  23. public static function systemPage($where = array())
  24. {
  25. $model = self::setWherePage(self::setWhere($where));
  26. $model = $model->order('add_time DESC');
  27. $list = $model->page((int)$where['page'], (int)$where['limit'])->select();
  28. foreach ($list as $key => &$item) {
  29. $item['address'] = $item['province'] . $item['city'] . $item['district'] . $item['detail'];
  30. if ($item['mer_id']) {
  31. $item['mer_name'] = Merchant::where('id', $item['mer_id'])->value('mer_name');
  32. } else {
  33. $item['mer_name'] = '总平台';
  34. }
  35. if (bcsub($item['signup_start_time'], time(), 0) > 0) {
  36. $statu = 0;//报名尚未开始
  37. } elseif (bcsub($item['signup_start_time'], time(), 0) <= 0 && bcsub($item['signup_end_time'], time(), 0) > 0) {
  38. $statu = 1;//报名开始
  39. } elseif (bcsub($item['signup_end_time'], time(), 0) <= 0 && bcsub($item['start_time'], time(), 0) > 0) {
  40. $statu = 2;//报名结束 活动尚未开始
  41. } elseif (bcsub($item['start_time'], time(), 0) <= 0 && bcsub($item['end_time'], time(), 0) > 0) {
  42. $statu = 3;//活动中
  43. } elseif (bcsub($item['end_time'], time(), 0) < 0) {
  44. $statu = 4;//活动结束
  45. } else {
  46. $statu = -1;
  47. }
  48. if ($item['statu'] != $statu) {
  49. $item['statu'] = $statu;
  50. self::where('id', $item['id'])->update(['statu' => $statu]);
  51. }
  52. }
  53. $count = self::setWherePage(self::setWhere($where))->count();
  54. return ['count' => $count, 'data' => $list];
  55. }
  56. /**
  57. * 设置搜索条件
  58. *
  59. */
  60. public static function setWhere($where)
  61. {
  62. $model = new self;
  63. if ($where['title'] != '') {
  64. $model = $model->where('title', 'like', "%$where[title]%");
  65. }
  66. if (isset($where['mer_id']) && $where['mer_id'] != '') {
  67. $model = $model->where('mer_id', $where['mer_id']);
  68. }
  69. if (isset($where['status']) && $where['status'] != '') {
  70. $model = $model->where('status', $where['status']);
  71. } else {
  72. $model = $model->where('status', 'in', [-1, 0]);
  73. }
  74. if (isset($where['is_show']) && $where['is_show'] !== '') $model = $model->where('is_show', $where['is_show']);
  75. $model = $model->where('is_del', 0);
  76. return $model;
  77. }
  78. /**删除
  79. * @param $id
  80. * @return bool
  81. */
  82. public static function delArticleCategory($id)
  83. {
  84. $data['is_del'] = 1;
  85. return self::edit($data, $id);
  86. }
  87. /**获取活动
  88. * @param $id
  89. */
  90. public static function eventRegistrationOne($id)
  91. {
  92. $event = self::where('id', $id)->find();
  93. if (!$event) return [];
  94. $event['signup_start_time'] = date('Y-m-d H:i:s', $event['signup_start_time']);
  95. $event['signup_end_time'] = date('Y-m-d H:i:s', $event['signup_end_time']);
  96. $event['start_time'] = date('Y-m-d H:i:s', $event['start_time']);
  97. $event['end_time'] = date('Y-m-d H:i:s', $event['end_time']);
  98. $event['activity_rules'] = htmlspecialchars_decode($event['activity_rules']);
  99. $event['content'] = htmlspecialchars_decode($event['content']);
  100. return $event;
  101. }
  102. public static function eventExamineList($where = array())
  103. {
  104. $model = self::setWherePage(self::setWhere($where));
  105. $model = $model->order('add_time DESC');
  106. $list = $model->page((int)$where['page'], (int)$where['limit'])->select()->each(function ($item) {
  107. $item['fail_time'] = date('Y-m-d H:i:s', $item['fail_time']);
  108. $item['address'] = $item['province'] . $item['city'] . $item['district'] . $item['detail'];
  109. if ($item['mer_id']) {
  110. $item['mer_name'] = Merchant::where('id', $item['mer_id'])->value('mer_name');
  111. } else {
  112. $item['mer_name'] = '总平台';
  113. }
  114. });
  115. $count = self::setWherePage(self::setWhere($where))->count();
  116. return ['count' => $count, 'data' => $list];
  117. }
  118. /**审核失败
  119. * @param $id
  120. * @param $fail_msg
  121. * @return bool
  122. * @throws \think\exception\DbException
  123. */
  124. public static function changeFail($id, $mer_id, $fail_message)
  125. {
  126. $fail_time = time();
  127. $status = -1;
  128. $uid = Merchant::where('id', $mer_id)->value('uid');
  129. try {
  130. $wechat_notification_message = SystemConfigService::get('wechat_notification_message');
  131. if ($wechat_notification_message == 1) {
  132. WechatTemplateService::sendTemplate(WechatUser::uidToOpenid($uid), WechatTemplateService::EXAMINE_RESULT, [
  133. 'first' => '尊敬的讲师,您添加的活动审核结果已出。',
  134. 'keyword1' => '审核失败',
  135. 'keyword2' => date('Y-m-d H:i:s', time()),
  136. 'remark' => '失败原因:' . $fail_message
  137. ], '');
  138. } else {
  139. $dat['phrase5']['value'] = '活动审核失败';
  140. $dat['time24']['value'] = date('Y-m-d H:i:s', time());
  141. $dat['thing4']['value'] = '活动失败原因:' . $fail_message;
  142. RoutineTemplate::sendExamineResult($dat, $uid, '');
  143. }
  144. } catch (\Exception $e) {
  145. }
  146. return self::edit(compact('fail_time', 'fail_message', 'status'), $id);
  147. }
  148. /**审核成功
  149. * @param $id
  150. * @return bool
  151. */
  152. public static function changeSuccess($id, $mer_id)
  153. {
  154. $success_time = time();
  155. $status = 1;
  156. $uid = Merchant::where('id', $mer_id)->value('uid');
  157. try {
  158. $wechat_notification_message = SystemConfigService::get('wechat_notification_message');
  159. if ($wechat_notification_message == 1) {
  160. WechatTemplateService::sendTemplate(WechatUser::uidToOpenid($uid), WechatTemplateService::EXAMINE_RESULT, [
  161. 'first' => '尊敬的讲师,您添加的活动审核结果已出。',
  162. 'keyword1' => '审核成功',
  163. 'keyword2' => date('Y-m-d H:i:s', time()),
  164. 'remark' => '感恩您的努力付出,谢谢!'
  165. ], '');
  166. } else {
  167. $dat['phrase5']['value'] = '活动审核成功';
  168. $dat['time24']['value'] = date('Y-m-d H:i:s', time());
  169. $dat['thing4']['value'] = '您添加的活动审核结果已出!';
  170. RoutineTemplate::sendExamineResult($dat, $uid, '');
  171. }
  172. } catch (\Exception $e) {
  173. }
  174. return self::edit(compact('status', 'success_time'), $id);
  175. }
  176. }