EnshrineService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | Laravel框架 [ Laravel ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 Laravel研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: wesmiler <12345678@qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services;
  12. use App\Models\DynamicNoticeModel;
  13. use App\Models\EnshrineActionModel;
  14. use App\Models\EnshrineOrdersModel;
  15. use App\Models\EnshrineRecordModel;
  16. use App\Models\FoxiangModel;
  17. use App\Models\MemberModel;
  18. use App\Models\OfferingsModel;
  19. use App\Models\TradeModel;
  20. /**
  21. * 供奉管理-服务类
  22. * @author wesmiler
  23. * @since 2020/11/11
  24. * Class EnshrineService
  25. * @package App\Services
  26. */
  27. class EnshrineService extends BaseService
  28. {
  29. protected static $instance = null;
  30. /**
  31. * 构造函数
  32. * @author wesmiler
  33. * @since 2020/11/11
  34. * EnshrineOrdersService constructor.
  35. */
  36. public function __construct()
  37. {
  38. $this->model = new EnshrineRecordModel();
  39. }
  40. /**
  41. * 静态入口
  42. * @return EnshrineOrdersService|null
  43. */
  44. public static function make()
  45. {
  46. if (!self::$instance) {
  47. self::$instance = new EnshrineOrdersService();
  48. }
  49. return self::$instance;
  50. }
  51. /**
  52. * 供奉记录
  53. * @return array
  54. */
  55. public function getDataList($userId)
  56. {
  57. $params = request()->all();
  58. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  59. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  60. $showType = isset($params['show_type']) ? intval($params['show_type']) : 1;
  61. $size = ConfigService::make()->getConfigByCode('qifu_limit');
  62. $pageSize = $size ? $size : $pageSize;
  63. $dataList = $this->model::from('enshrine_records as a')
  64. ->leftJoin('foxiang as f', 'f.id', '=', 'a.fo_id')
  65. ->leftJoin('foxiang_cates as c', 'c.id', '=', 'f.cate_id')
  66. ->where(['a.user_id' => $userId])
  67. ->where(function ($query) use ($params) {
  68. $query->where(['a.mark' => 1, 'a.status' => 1]);
  69. $type = isset($params['type']) ? $params['type'] : 0;
  70. if ($type) {
  71. $query->where('a.type', $type);
  72. }
  73. })
  74. ->select(['a.*', 'f.name', 'f.thumb', 'f.image', 'f.file_url', 'c.name as cate_name'])
  75. ->orderBy('a.create_time', 'desc')
  76. ->paginate($pageSize);
  77. $dataList = $dataList ? $dataList->toArray() : [];
  78. if ($dataList) {
  79. foreach ($dataList['data'] as &$item) {
  80. $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : '';
  81. $item['image'] = $item['image'] ? get_image_url($item['image']) : '';
  82. $item['file_url'] = $item['file_url'] ? get_image_url($item['file_url']) : '';
  83. $item['bg_music_url'] = get_image_url('/file/music/bg_' . $item['type'] . '.mp3');
  84. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
  85. $item['time'] = $item['create_time'] ? format_time(strtotime($item['create_time'])) : '';
  86. $item['time_close'] = 0;
  87. if ($item['create_time'] <= date('Y-m-d H:i:s', time() - 24 * 3600)) {
  88. $item['time_close'] = 1;
  89. }
  90. if ($showType == 1) {
  91. $guibai = EnshrineActionModel::where(['source_id' => $item['id'], 'user_id' => $userId, 'type' => 1, 'mark' => 1, 'status' => 1])
  92. ->where('create_time', '>=', time() - 3600)
  93. ->value('id');
  94. $item['guibai'] = 0;
  95. $item['guibai_check'] = $guibai ? $guibai : 0;
  96. $wash = EnshrineActionModel::where(['source_id' => $item['id'], 'user_id' => $userId, 'type' => 2, 'mark' => 1, 'status' => 1])
  97. ->where('create_time', '>=', time() - 3600)
  98. ->value('id');
  99. $item['wash'] = 0;
  100. $item['guibai_check'] = $wash ? $wash : 0;
  101. // 花
  102. $item['hua'] = ['id' => 0, 'icon' => '', 'icon_real' => ''];
  103. $hua = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 2);
  104. if ($hua) {
  105. $item['hua'] = $hua;
  106. }
  107. // 水果
  108. $item['guo'] = ['id' => 0, 'icon' => '', 'icon_real' => ''];
  109. $guo = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 3);
  110. if ($guo) {
  111. $item['guo'] = $guo;
  112. }
  113. // 香烛
  114. $item['xiang'] = ['id' => 0, 'icon' => '', 'icon_real' => ''];
  115. $xiang = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 4);
  116. if ($xiang) {
  117. $item['xiang'] = $xiang;
  118. }
  119. }
  120. }
  121. unset($item);
  122. }
  123. return [
  124. 'code' => 0,
  125. 'success' => true,
  126. 'msg' => '操作成功',
  127. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  128. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  129. ];
  130. }
  131. /**
  132. * 获取已经购买供奉物品信息
  133. * @param $sid
  134. * @param $userId
  135. * @param $type
  136. * @param $goodsType
  137. * @return array|mixed
  138. */
  139. public function getOrderGoodsInfo($sid, $userId, $type, $goodsType)
  140. {
  141. $cacheKey = "caches:enshrine:orders_goods:u{$userId}_s{$sid}_{$type}_{$goodsType}";
  142. $info = RedisService::get($cacheKey);
  143. if ($info) {
  144. return $info;
  145. }
  146. $expireTime = ConfigService::make()->getConfigByCode("enshrine_expire_time_{$type}");
  147. $expireTime = $expireTime ? $expireTime : 0;
  148. $info = EnshrineOrdersModel::from('enshrine_orders as eo')
  149. ->leftJoin('offerings as g', 'g.id', '=', 'eo.goods_id')
  150. ->where(['eo.source_id' => $sid, 'eo.user_id' => $userId, 'eo.type' => $type, 'g.goods_type' => $goodsType])
  151. ->where(function ($query) use ($expireTime) {
  152. if ($expireTime > 0) {
  153. $query->where('eo.create_time', '>=', time() - $expireTime * 3600);
  154. }
  155. })
  156. ->select(['g.id', 'g.name', 'g.goods_type', 'g.code', 'g.icon', 'g.icon_real', 'eo.source_id', 'eo.status', 'eo.create_time'])
  157. ->orderBy('eo.create_time', 'desc')
  158. ->first();
  159. $info = $info ? $info->toArray() : [];
  160. if ($info) {
  161. $info['icon'] = $info['icon'] ? get_image_url($info['icon']) : '';
  162. $info['create_time_text'] = $info['create_time'] ? datetime($info['create_time'], 'Y-m-d H:i:s') : '';
  163. $info['create_time'] = $info['create_time'] ? strtotime(datetime($info['create_time'], 'Y-m-d H:i:s')) : time();
  164. $info['icon_real'] = $info['icon_real'] ? get_image_url($info['icon_real']) : '';
  165. RedisService::set($cacheKey, $info, rand(3, 5));
  166. }
  167. return $info;
  168. }
  169. /**
  170. * 物品
  171. * @return array
  172. */
  173. public function goods()
  174. {
  175. $params = request()->all();
  176. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  177. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  178. $dataList = $this->model::from('offerings as a')
  179. ->where(function ($query) use ($params) {
  180. $query->where(['a.mark' => 1, 'a.status' => 1]);
  181. $type = isset($params['type']) ? $params['type'] : 0;
  182. if ($type) {
  183. $query->where('a.type', $type);
  184. }
  185. $goodsType = isset($params['goods_type']) ? $params['goods_type'] : 0;
  186. if ($goodsType) {
  187. $query->where('a.goods_type', $goodsType);
  188. }
  189. })
  190. ->select(['a.*'])
  191. ->orderBy('a.sort', 'asc')
  192. ->orderBy('a.create_time', 'desc')
  193. ->paginate($pageSize);
  194. $dataList = $dataList ? $dataList->toArray() : [];
  195. if ($dataList) {
  196. foreach ($dataList['data'] as &$item) {
  197. $item['icon'] = $item['icon'] ? get_image_url($item['icon']) : '';
  198. $item['icon_real'] = $item['icon_real'] ? get_image_url($item['icon_real']) : '';
  199. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
  200. }
  201. unset($item);
  202. }
  203. return [
  204. 'code' => 0,
  205. 'success' => true,
  206. 'msg' => '操作成功',
  207. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  208. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  209. ];
  210. }
  211. /**
  212. * 请佛
  213. * @param $userId
  214. * @return array
  215. */
  216. public function select($userId)
  217. {
  218. $id = request()->get('id', 0);
  219. if ($id <= 0) {
  220. return message('参数错误', false);
  221. }
  222. $foInfo = FoxiangModel::where(['id' => $id, 'mark' => 1, 'status' => 1])
  223. ->select(['id', 'name'])
  224. ->first();
  225. if (!$foInfo) {
  226. return message('佛像不存在,请选择其他佛像', false);
  227. }
  228. $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1])
  229. ->select(['id', 'nickname'])
  230. ->first();
  231. if (!$memberInfo) {
  232. return message('您的账号不可操作或已冻结,请联系客服', false);
  233. }
  234. // 验证是否正在供奉该佛像
  235. $type = request()->get('type', 1);
  236. $params = request()->all();
  237. switch ($type) {
  238. case 1: // 祈福
  239. $limitNum = ConfigService::make()->getConfigByCode('qifu_limit');
  240. if ($limitNum) {
  241. $num = $this->model::where(['user_id' => $userId, 'type' => 1, 'mark' => 1, 'status' => 1])
  242. ->count('id');
  243. if ($num >= $limitNum) {
  244. return message("最多只能同时供奉{$limitNum}尊佛像,请送圣后再操作", false);
  245. }
  246. }
  247. $record = $this->model::where(['fo_id' => $id, 'user_id' => $userId, 'mark' => 1, 'status' => 1])
  248. ->select(['id', 'fo_id', 'user_id'])
  249. ->first();
  250. if ($record) {
  251. return message('抱歉该佛像您正在供奉中,请24小时后再继续供奉或选择其他佛像', false);
  252. }
  253. break;
  254. case 2: // 超度
  255. break;
  256. case 3: // 放生
  257. break;
  258. }
  259. $data = [
  260. 'fo_id' => $id,
  261. 'type' => $type,
  262. 'user_id' => $userId,
  263. 'used_name' => isset($params['used_name']) ? trim($params['used_name']) : '',
  264. 'user_name' => isset($params['user_name']) ? trim($params['user_name']) : '',
  265. 'relation' => isset($params['relation']) ? trim($params['relation']) : '',
  266. 'description' => isset($params['description']) ? trim($params['description']) : '',
  267. 'image' => isset($params['image']) ? trim($params['image']) : '',
  268. 'create_time' => time(),
  269. 'update_time' => time(),
  270. 'mark' => 1,
  271. 'status' => 1,
  272. ];
  273. if ($this->model::insertGetId($data)) {
  274. return message('请佛成功', true);
  275. } else {
  276. return message('请佛失败', true);
  277. }
  278. }
  279. /**
  280. * 送圣
  281. * @param $userId
  282. * @return array
  283. */
  284. public function packoff($userId)
  285. {
  286. $id = request()->get('id', 0);
  287. $type = request()->get('type', 0);
  288. if (!$id || !$type) {
  289. return message('参数错误', false);
  290. }
  291. $enshrine = $this->model::where(['fo_id' => $id, 'user_id' => $userId, 'type' => $type, 'mark' => 1, 'status' => 1])
  292. ->select(['id', 'fo_id', 'user_id', 'status'])
  293. ->first();
  294. if (!$enshrine) {
  295. return message('佛像信息不存在', false);
  296. }
  297. $enshrine->status = 2;
  298. if ($enshrine->save()) {
  299. return message('送圣成功', true);
  300. } else {
  301. return message('送圣失败', false);
  302. }
  303. }
  304. /**
  305. * 新增牌位
  306. * @param $userId
  307. * @return array
  308. */
  309. public function chaodu($userId)
  310. {
  311. $params = request()->all();
  312. $id = isset($params['id']) ? $params['id'] : 0;
  313. if (!$id) {
  314. return message('请选择佛像', false);
  315. }
  316. $foInfo = FoxiangModel::where(['id' => $id, 'mark' => 1, 'status' => 1])
  317. ->select(['id', 'name'])
  318. ->first();
  319. if (!$foInfo) {
  320. return message('佛像不存在,请选择其他佛像', false);
  321. }
  322. $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1])
  323. ->select(['id', 'nickname'])
  324. ->first();
  325. if (!$memberInfo) {
  326. return message('您的账号不可操作或已冻结,请联系客服', false);
  327. }
  328. // 验证是否正在供奉该佛像
  329. $limitNum = ConfigService::make()->getConfigByCode('chaodu_limit');
  330. if ($limitNum) {
  331. $num = $this->model::where(['user_id' => $userId, 'type' => 2, 'mark' => 1, 'status' => 1])
  332. ->count('id');
  333. if ($num >= $limitNum) {
  334. return message("最多只能同时超度{$limitNum}个牌位,请到期后再操作", false);
  335. }
  336. }
  337. $data = [
  338. 'fo_id' => $id,
  339. 'type' => 2,
  340. 'user_id' => $userId,
  341. 'used_name' => isset($params['used_name']) ? trim($params['used_name']) : '',
  342. 'user_name' => isset($params['user_name']) ? trim($params['user_name']) : '',
  343. 'relation' => isset($params['relation']) ? trim($params['relation']) : '',
  344. 'description' => isset($params['description']) ? trim($params['description']) : '',
  345. 'image' => isset($params['image']) ? trim($params['image']) : '',
  346. 'create_time' => time(),
  347. 'update_time' => time(),
  348. 'mark' => 1,
  349. 'status' => 1,
  350. ];
  351. if ($this->model::insertGetId($data)) {
  352. return message('超度成功', true);
  353. } else {
  354. return message('超度失败', true);
  355. }
  356. }
  357. /**
  358. * 供奉操作记录
  359. * @param $userId
  360. * @return array
  361. */
  362. public function actionRecord($userId)
  363. {
  364. $params = request()->all();
  365. $id = isset($params['id']) ? $params['id'] : 0;
  366. $type = isset($params['type']) ? $params['type'] : 0;
  367. if ($id <= 0 || $type <= 0) {
  368. return message('参数错误', false);
  369. }
  370. $enshrine = $this->model::where(['id' => $id, 'user_id' => $userId, 'mark' => 1, 'status' => 1])
  371. ->select(['id', 'fo_id', 'user_id'])
  372. ->first();
  373. if (!$enshrine) {
  374. return message('供奉记录信息不存在,无法操作', false);
  375. }
  376. $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1])
  377. ->select(['id', 'nickname', 'merits_num'])
  378. ->first();
  379. if (!$memberInfo) {
  380. return message('您的账号不可操作或已冻结,请联系客服', false);
  381. }
  382. \DB::beginTransaction();
  383. $data = [
  384. 'source_id' => $id,
  385. 'user_id' => $userId,
  386. 'type' => $type,
  387. 'description' => isset($params['description']) ? $params['description'] : '',
  388. 'create_time' => time(),
  389. 'update_time' => time(),
  390. 'status' => 1
  391. ];
  392. if (!EnshrineActionModel::insertGetId($data)) {
  393. \DB::rollBack();
  394. return message('操作失败', false);
  395. }
  396. $giveGd = 0;
  397. $fields = ['1' => 'qifu_guibai_give_gd', '2' => 'qifu_wash_give_gd', '3' => 'qifu_xuyuan_give_gd'];
  398. $field = isset($fields[$type]) ? $fields[$type] : '';
  399. if ($field) {
  400. $giveGd = ConfigService::make()->getConfigByCode($field);
  401. }
  402. // 功德值
  403. if ($giveGd > 0) {
  404. if (!MemberModel::where(['id' => $userId, 'mark' => 1])->increment('merits_num', $giveGd)) {
  405. \DB::rollBack();
  406. return message("更新功德账户失败", false);
  407. }
  408. $data = [
  409. 'user_id' => $userId,
  410. 'source_uid' => 0,
  411. 'type' => 3,
  412. 'coin_type' => 4,
  413. 'pay_type' => 4,
  414. 'money' => $giveGd,
  415. 'change_type' => 1,
  416. 'balance' => $memberInfo->merits_num,
  417. 'create_time' => time(),
  418. 'remark' => $type == 1 ? "跪拜祈福" : '洗手祈福',
  419. 'status' => 1,
  420. ];
  421. if (!TradeModel::insertGetId($data)) {
  422. \DB::rollBack();
  423. return message("处理功德奖励失败", false);
  424. }
  425. \DB::commit();
  426. return message("获得功德值{$giveGd}", true);
  427. }
  428. \DB::commit();
  429. return message("操作成功", true);
  430. }
  431. /**
  432. * 购买物品
  433. * @param $userId
  434. * @return array
  435. */
  436. public function buy($userId)
  437. {
  438. $params = request()->all();
  439. $id = isset($params['id']) ? $params['id'] : 0;
  440. $enshrineId = isset($params['enshrine_id']) ? $params['enshrine_id'] : 0;
  441. $type = isset($params['type']) ? $params['type'] : 0;
  442. $num = isset($params['num']) ? $params['num'] : 0;
  443. if ($id <= 0 || $type <= 0 || ($enshrineId <= 0 && $type!=3) || $num <= 0) {
  444. return message('参数错误', false);
  445. }
  446. if($type != 3){
  447. $enshrine = $this->model::where(['id' => $enshrineId, 'user_id' => $userId, 'mark' => 1, 'status' => 1])
  448. ->select(['id', 'fo_id', 'user_id'])
  449. ->first();
  450. if (!$enshrine) {
  451. return message('供奉记录信息不存在,无法操作', false);
  452. }
  453. }
  454. $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1])
  455. ->select(['id', 'nickname', 'merits_num', 'coupon'])
  456. ->first();
  457. if (!$memberInfo) {
  458. return message('您的账号不可操作或已冻结,请联系客服', false);
  459. }
  460. // 物品
  461. $goodsInfo = OfferingsModel::where(['id' => $id, 'mark' => 1, 'status' => 1])
  462. ->select(['id', 'type', 'goods_type', 'name', 'price'])
  463. ->first();
  464. if (!$goodsInfo) {
  465. return message('物品不存在或已下架,请刷新重试', false);
  466. }
  467. // 是否未到期
  468. $expireTime = ConfigService::make()->getConfigByCode("enshrine_expire_time_{$type}");
  469. $expireTime = $expireTime ? $expireTime : 0;
  470. $info = $this->getOrderGoodsInfo($enshrineId, $userId, $type, $goodsInfo->goods_type);
  471. if ($info) {
  472. $createTime = isset($info['create_time']) ? intval($info['create_time']) : time();
  473. $enshrineTime = time() - $createTime;
  474. $hour = intval($enshrineTime / 3600);
  475. $minute = ceil(($enshrineTime % 3600) / 60);
  476. $enshrineTime1 = ($createTime + $expireTime * 3600 - time());
  477. $enshrineTime1 = $enshrineTime1>0? $enshrineTime1 : 0;
  478. $hour1 = intval($enshrineTime1 / 3600);
  479. $minute1 = intval(($enshrineTime1 % 3600) / 60);
  480. $time = date('H点i分', $createTime + $expireTime * 3600);
  481. $msg = "您已经恭请{$goodsInfo->name}供佛{$hour}小时{$minute}分,还有{$hour1}小时{$minute1}分($time)到期,每天更换贡品代表恭敬佛菩萨,阿弥陀佛";
  482. return message($msg, false, ['show' => true, 'time' => $enshrineTime, 'hour' => $hour, 'minute' => $minute]);
  483. }
  484. $total = intval($goodsInfo->price * $num);
  485. \DB::beginTransaction();
  486. $data = [
  487. 'source_id' => $enshrineId,
  488. 'goods_id' => $id,
  489. 'user_id' => $userId,
  490. 'type' => $type,
  491. 'order_sn' => get_order_num('F'),
  492. 'num' => $num,
  493. 'price' => $goodsInfo->price,
  494. 'total' => $total,
  495. 'gd_name' => isset($params['gd_name']) ? $params['gd_name'] : '',
  496. 'pay_at' => date('Y-m-d H:i:s'),
  497. 'remark' => isset($params['remark']) ? $params['remark'] : '',
  498. 'create_time' => time(),
  499. 'update_time' => time(),
  500. 'status' => 2
  501. ];
  502. if (!EnshrineOrdersModel::insertGetId($data)) {
  503. \DB::rollBack();
  504. return message('供奉物品失败', false);
  505. }
  506. // 扣款奖励处理
  507. if ($total > 0) {
  508. if ($memberInfo->coupon < $total) {
  509. return message("账户花灯券不足,请先充值", false, [], 10003);
  510. }
  511. if (!MemberModel::where(['id' => $userId, 'mark' => 1])->decrement('coupon', $total)) {
  512. \DB::rollBack();
  513. return message("更新花灯券账户失败", false);
  514. }
  515. $data = [
  516. 'user_id' => $userId,
  517. 'source_uid' => 0,
  518. 'type' => 1,
  519. 'coin_type' => 1,
  520. 'pay_type' => 1,
  521. 'money' => $total,
  522. 'change_type' => 2,
  523. 'balance' => $memberInfo->coupon,
  524. 'create_time' => time(),
  525. 'remark' => $type == 1 ? "祈福供奉{$goodsInfo->name}" : ($type == 3 ? "放生{$goodsInfo->name}" : "超度供奉{{$goodsInfo->name}}"),
  526. 'status' => 1,
  527. ];
  528. if (!TradeModel::insertGetId($data)) {
  529. \DB::rollBack();
  530. return message("处理账户明细失败", false);
  531. }
  532. }
  533. // 奖励
  534. $giveGd = ConfigService::make()->getConfigByCode('enshrine_give_gd');
  535. $giveGd = $giveGd ? $giveGd : 0;
  536. $totalGd = $giveGd * $num;
  537. if ($totalGd > 0) {
  538. if (!MemberModel::where(['id' => $userId, 'mark' => 1])->increment('merits_num', $totalGd)) {
  539. \DB::rollBack();
  540. return message("更新功德账户失败", false);
  541. }
  542. $data = [
  543. 'user_id' => $userId,
  544. 'source_uid' => 0,
  545. 'type' => 3,
  546. 'coin_type' => 4,
  547. 'pay_type' => 4,
  548. 'money' => $totalGd,
  549. 'change_type' => 1,
  550. 'balance' => $memberInfo->merits_num,
  551. 'create_time' => time(),
  552. 'remark' => $type == 1 ? "祈福供奉{$goodsInfo->name}" : ($type == 3 ? "放生{$goodsInfo->name}" : "超度供奉{{$goodsInfo->name}}"),
  553. 'status' => 1,
  554. ];
  555. if (!TradeModel::insertGetId($data)) {
  556. \DB::rollBack();
  557. return message("处理功德奖励失败", false);
  558. }
  559. }
  560. \DB::commit();
  561. // 动态
  562. $data = [
  563. 'type' => $type + 1,
  564. 'user_id' => $userId,
  565. 'remark' => $type == 1 ? "供奉{$goodsInfo->name}" : ($type == 3 ? "放生{$goodsInfo->name}" : '超度普渡众生'),
  566. 'update_time' => time(),
  567. 'create_time' => time(),
  568. 'status' => 1
  569. ];
  570. DynamicNoticeModel::insertGetId($data);
  571. if ($totalGd > 0) {
  572. return message("获得功德值{$totalGd}", true, ['num' => $totalGd]);
  573. } else {
  574. return message("操作成功", true);
  575. }
  576. }
  577. /**
  578. * 心愿记录
  579. * @param $userId
  580. * @return array
  581. */
  582. public function actionList($userId)
  583. {
  584. $params = request()->all();
  585. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  586. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  587. $dataList = $this->model::from('enshrine_actions as a')
  588. ->where(['a.type' => 3, 'a.mark' => 1, 'a.user_id' => $userId])
  589. ->whereIn('a.status', [1, 2])
  590. ->select(['a.*'])
  591. ->orderBy('a.create_time', 'desc')
  592. ->paginate($pageSize);
  593. $dataList = $dataList ? $dataList->toArray() : [];
  594. if ($dataList) {
  595. foreach ($dataList['data'] as &$item) {
  596. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
  597. $item['description'] = $item['description'] ? str_replace("\n", '<br>', $item['description']) : '';
  598. }
  599. unset($item);
  600. }
  601. return [
  602. 'code' => 0,
  603. 'success' => true,
  604. 'msg' => '操作成功',
  605. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  606. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  607. ];
  608. }
  609. /**
  610. * 购买记录
  611. * @param $userId
  612. * @return array
  613. */
  614. public function orderList($uid)
  615. {
  616. $params = request()->all();
  617. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  618. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  619. $type = isset($params['type']) ? intval($params['type']) : 0;
  620. $where = ['a.mark' => 1,'a.status'=> 2];
  621. if($type){
  622. $where['a.type'] = $type;
  623. }
  624. $dataList = $this->model::from('enshrine_orders as a')
  625. ->leftJoin('member as m', 'm.id', '=', 'a.user_id')
  626. ->leftJoin('offerings as g', 'g.id', '=', 'a.goods_id')
  627. ->where($where)
  628. ->select(['a.*','m.avatar','m.nickname','g.name as goods_name','g.spec','g.icon'])
  629. ->orderBy('a.create_time', 'desc')
  630. ->paginate($pageSize);
  631. $dataList = $dataList ? $dataList->toArray() : [];
  632. if ($dataList) {
  633. foreach ($dataList['data'] as &$item) {
  634. $item['avatar'] = $item['avatar']? get_image_url($item['avatar']) : '';
  635. $item['icon'] = $item['icon']? get_image_url($item['icon']) : '';
  636. $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
  637. $item['time'] = $item['create_time'] ? format_time(strtotime($item['create_time'])) : '';
  638. $item['remark'] = $item['remark'] ? str_replace("\n", '<br>', $item['remark']) : '';
  639. $item['total'] = moneyFormat($item['total'], 0);
  640. }
  641. unset($item);
  642. }
  643. return [
  644. 'code' => 0,
  645. 'success' => true,
  646. 'msg' => '操作成功',
  647. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  648. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  649. ];
  650. }
  651. /**
  652. * 许愿记录处理
  653. * @param $userId
  654. * @return array
  655. */
  656. public function catchXuyuan($userId)
  657. {
  658. $params = request()->all();
  659. $id = isset($params['id']) ? $params['id'] : 0;
  660. $type = isset($params['type']) ? $params['type'] : 1;
  661. if ($id <= 0 || $id <= 0) {
  662. return message('参数错误', false);
  663. }
  664. $info = EnshrineActionModel::where(['id' => $id, 'user_id' => $userId, 'type' => 3, 'mark' => 1, 'status' => 1])
  665. ->select(['id', 'user_id', 'status'])
  666. ->first();
  667. if (!$info) {
  668. return message('许愿信息不存在或已处理', false);
  669. }
  670. $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1])
  671. ->select(['id', 'nickname', 'merits_num', 'coupon'])
  672. ->first();
  673. if (!$memberInfo) {
  674. return message('您的账号不可操作或已冻结,请联系客服', false);
  675. }
  676. if ($type == 2) {
  677. if (EnshrineActionModel::where(['id' => $id, 'user_id' => $userId, 'type' => 3, 'mark' => 1, 'status' => 1])->delete()) {
  678. return message('删除成功', true);
  679. } else {
  680. return message('删除失败', false);
  681. }
  682. } else {
  683. $info->status = 2;
  684. if ($info->save()) {
  685. return message('操作成功', true);
  686. } else {
  687. return message('操作失败', false);
  688. }
  689. }
  690. }
  691. }