StoreProductReply.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  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\merchant\model\store;
  12. use traits\ModelTrait;
  13. use basic\ModelBasic;
  14. use app\merchant\model\user\User;
  15. /**
  16. * 评论管理 model
  17. * Class StoreProductReply
  18. * @package app\merchant\model\store
  19. */
  20. class StoreProductReply extends ModelBasic
  21. {
  22. use ModelTrait;
  23. public static function setWhere($where)
  24. {
  25. $model = new self;
  26. $model = $model->alias('r');
  27. if (isset($where['comment']) && $where['comment'] != '') $model = $model->where('r.comment', 'LIKE', "%$where[comment]%");
  28. if (isset($where['is_reply']) && $where['is_reply'] != '') {
  29. if ($where['is_reply'] >= 0) {
  30. $model = $model->where('r.is_reply', $where['is_reply']);
  31. } else {
  32. $model = $model->where('r.is_reply', 'GT', 0);
  33. }
  34. }
  35. if (isset($where['product_id']) && $where['product_id'] > 0) $model = $model->where('r.product_id', $where['product_id']);
  36. if (isset($where['mer_id']) && $where['mer_id'] > 0) $model = $model->where('p.mer_id', $where['mer_id'])->where('p.status', 1);
  37. if (isset($where['title']) && $where['title']) {
  38. $model = $model->join('User u', 'u.uid=r.uid');
  39. $model = $model->where('r.uid|u.nickname', 'LIKE', "%$where[title]%");
  40. }
  41. if (isset($where['store_name']) && $where['store_name']) $model = $model->where('p.store_name', 'LIKE', "%$where[store_name]%");
  42. $model = $model->join('__STORE_PRODUCT__ p', 'p.id=r.product_id');
  43. $model = $model->where('r.is_del', 0)->order('r.add_time DESC');
  44. return $model;
  45. }
  46. /**评论列表
  47. * @param $where
  48. * @return array
  49. */
  50. public static function storeProductReplyList($where)
  51. {
  52. $data = self::setWhere($where)->page((int)$where['page'], (int)$where['limit'])->field('r.*,p.store_name,p.mer_id,p.status')->select();
  53. $data = count($data) > 0 ? $data->toArray() : [];
  54. foreach ($data as $key => &$value) {
  55. $score = bcadd(bcadd($value['product_score'], $value['service_score'], 2), $value['delivery_score'], 2);
  56. $value['score'] = bcdiv($score, 3, 2);
  57. $value['add_time'] = date('Y-m-d H:i:s', $value['add_time']);
  58. $value['pics'] = json_decode($value['pics']);
  59. if ($value['uid']) {
  60. $nickname = User::where('uid', $value['uid'])->value('nickname');
  61. } else {
  62. $nickname = self::getDb('reply_false')->where('reply_id', $value['id'])->value('nickname');
  63. }
  64. $value['nickname'] = $nickname . '/' . $value['uid'];
  65. }
  66. $count = self::setWhere($where)->count();
  67. return compact('count', 'data');
  68. }
  69. public static function helpeFalse($data, $banner)
  70. {
  71. self::beginTrans();
  72. try {
  73. $type = $data['type'];
  74. $nickname = $data['nickname'];
  75. $avatar = $data['avatar'];
  76. $data = [
  77. 'uid' => 0,
  78. 'oid' => 0,
  79. 'unique' => md5(time()),
  80. 'product_id' => $data['product_id'],
  81. 'product_score' => $data['product_score'],
  82. 'service_score' => $data['service_score'],
  83. 'delivery_score' => $data['delivery_score'],
  84. 'comment' => $data['comment'],
  85. 'pics' => json_encode($banner),
  86. 'add_time' => time()
  87. ];
  88. $false = self::set($data);
  89. if (!$false) return self::setErrorInfo('写入虚拟评论失败', true);
  90. $res = self::getDb('reply_false')->insert(['reply_id' => $false['id'], 'type' => $type, 'nickname' => $nickname, 'avatar' => $avatar, 'add_time' => time()]);
  91. if (!$res) return self::setErrorInfo('写入虚拟评论用户失败', true);
  92. self::commitTrans();
  93. return true;
  94. } catch (\Exception $e) {
  95. self::rollbackTrans();
  96. return self::setErrorInfo($e->getMessage());
  97. }
  98. }
  99. }