MemberDetail.php 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\model\api;
  4. use library\basic\BaseModel;
  5. use think\db\exception\DbException;
  6. use think\facade\Db;
  7. use think\Model;
  8. /**
  9. * @mixin \think\Model
  10. */
  11. class MemberDetail extends BaseModel
  12. {
  13. private $config = [
  14. 'consumption' => array("code" => "消费余额", "content" => "你在{name}进行余额支付,订单号:{order_id},订单总金额:{allmoney}元,消耗:{money}"),
  15. 'recharge' => array("code" => "在线充值", "content" => "你在{time}进行充值操作,充值金额:{money}元。"),
  16. 'refund' => array("code" => "退款操作", "content" => "订单{order_id}进行退款,订单单数:{count}笔,共{money}元"),
  17. 'income' => array('code' => "推广佣金", "content" => "推广{user}用户采购礼品,订单号:{order_id},订单单数:{count},可获取佣金{money}数"),
  18. 'admin_add' => array('code' => "后台转账", "content" => "在{time},后台向你转账{money}元,其他说明:{mono}。"),
  19. 'admin_jdd' => array('code' => "后台扣款", "content" => "在{time},后台向你扣款{money}元,其他说明:{mono}。"),
  20. ];
  21. /**
  22. * 消费余额
  23. * @param $money
  24. * @param $uid
  25. * @param $param
  26. * @param $sassid 平台ID
  27. */
  28. public function consumption($money,$uid,$param,$sassid){
  29. try {
  30. self::beginTrans();
  31. $content = $this->TplParam($this->config['consumption']['content'], $param);
  32. $post['uid'] = $uid;
  33. $post['v'] = $money;
  34. $post['code'] = 'consumption';
  35. $post['title'] = $this->config['consumption']['code'];
  36. $post['content'] = $content;
  37. $post['type'] = 2;
  38. $post['sassid'] = $sassid;
  39. $post['time'] = time();
  40. $post['money'] = (new Member)->where('uid', $uid)->value('money') - $money;
  41. $this->insert($post);
  42. $bool = Db::name("member")->where('uid',$uid)->dec('money',floatval($money))->update();
  43. self::commitTrans();
  44. if($bool > 0) {
  45. return true;
  46. } else {
  47. return false;
  48. }
  49. }catch (DbException $db){
  50. // var_dump($db->getMessage());
  51. self::rollbackTrans();
  52. return false;
  53. }
  54. }
  55. /**
  56. * 充值余额
  57. * @param $money
  58. * @param $contentId
  59. * @param $uid
  60. * @param $param
  61. */
  62. public function recharge($money,$uid,$param = [],$sassid){
  63. try {
  64. self::beginTrans();
  65. $param['time'] = date('Y-m-d H:i:s');
  66. $param['money'] = $money;
  67. $content = $this->TplParam($this->config['recharge']['content'], $param);
  68. $post['uid'] = $uid;
  69. $post['v'] = $money;
  70. $post['code'] = 'recharge';
  71. $post['title'] = $this->config['recharge']['code'];
  72. $post['content'] = $content;
  73. $post['type'] = 1;
  74. $post['sassid'] = $sassid;
  75. $post['time'] = time();
  76. $post['money'] = (new Member)->where('uid', $uid)->value('money') + $money;
  77. $this->insert($post);
  78. $bool = Db::name("member")->where('uid',$uid)->inc('money',floatval($money))->update();
  79. self::commitTrans();
  80. if($bool > 0) {
  81. return true;
  82. } else {
  83. return false;
  84. }
  85. }catch (DbException $db){
  86. // var_dump($db->getMessage());
  87. self::rollbackTrans();
  88. return false;
  89. }
  90. }
  91. /**
  92. * 退款金额
  93. * @param $money
  94. * @param $contentId
  95. * @param $uid
  96. * @param $param
  97. */
  98. public function refund($money,$uid,$param = [],$sassid){
  99. try {
  100. self::beginTrans();
  101. $param['time'] = date('Y-m-d H:i:s');
  102. $param['money'] = $money;
  103. $content = $this->TplParam($this->config['refund']['content'], $param);
  104. $post['uid'] = $uid;
  105. $post['v'] = $money;
  106. $post['code'] = 'refund';
  107. $post['title'] = $this->config['refund']['code'];
  108. $post['content'] = $content;
  109. $post['type'] = 1;
  110. $post['sassid'] = $sassid;
  111. $post['time'] = time();
  112. $post['money'] = (new Member)->where('uid', $uid)->value('money') + $money;
  113. $this->insert($post);
  114. $bool = Db::name("member")->where('uid',$uid)->inc('money',floatval($money))->update();
  115. self::commitTrans();
  116. if($bool > 0) {
  117. return true;
  118. } else {
  119. return false;
  120. }
  121. }catch (DbException $db){
  122. self::rollbackTrans();
  123. return false;
  124. }
  125. }
  126. /**
  127. * 收入-[包含推广 | 退款]
  128. * @param $money
  129. * @param $contentId
  130. * @param $uid
  131. * @param $param
  132. */
  133. public function income($money,$uid,$param,$sassid){
  134. try {
  135. self::beginTrans();
  136. $param['time'] = date('Y-m-d H:i:s');
  137. $param['money'] = $money;
  138. $content = $this->TplParam($this->config['income']['content'], $param);
  139. $post['uid'] = $uid;
  140. $post['v'] = $money;
  141. $post['code'] = 'income';
  142. $post['title'] = $this->config['income']['code'];
  143. $post['content'] = $content;
  144. $post['type'] = 1;
  145. $post['sassid'] = $sassid;
  146. $post['time'] = time();
  147. $post['money'] = (new Member)->where('uid', $uid)->value('tx_money') + $money;
  148. $this->insert($post);
  149. $bool = Db::name("member")->where('uid',$uid)->inc('tx_money',floatval($money))->update();
  150. self::commitTrans();
  151. if($bool > 0) {
  152. return true;
  153. } else {
  154. return false;
  155. }
  156. }catch (DbException $db){
  157. self::rollbackTrans();
  158. return false;
  159. }
  160. }
  161. /**
  162. * 减少数据
  163. * @param $money
  164. * @param $uid
  165. * @param $type
  166. * @param $param
  167. * @param $sassid
  168. * @return bool
  169. */
  170. public function adminInc($money,$uid,$param,$sassid,$type){
  171. try {
  172. self::beginTrans();
  173. $param['time'] = date('Y-m-d H:i:s');
  174. $param['money'] = $money;
  175. $content = $this->TplParam($this->config[$type == 'add' ? 'admin_add' : 'admin_jdd']['content'], $param);
  176. $post['uid'] = $uid;
  177. $post['v'] = $money;
  178. $post['code'] = 'admin_tz';
  179. $post['title'] = $this->config[ $type == 'add' ? 'admin_add' : 'admin_jdd' ]['code'];
  180. $post['content'] = $content;
  181. $post['type'] = $type == 'add' ? 1 : 2;
  182. $post['sassid'] = $sassid;
  183. $post['time'] = time();
  184. if($type == 'add')
  185. $post['money'] = (new Member)->where('uid', $uid)->value('money') + $money;
  186. else
  187. $post['money'] = (new Member)->where('uid', $uid)->value('money') - $money;
  188. $this->insert($post);
  189. if($type == 'add')
  190. $bool = Db::name("member")->where('uid',$uid)->inc('money',floatval($money))->update();
  191. else
  192. $bool = Db::name("member")->where('uid',$uid)->dec('money',floatval($money))->update();
  193. self::commitTrans();
  194. if($bool > 0) {
  195. return true;
  196. } else {
  197. return false;
  198. }
  199. }catch (DbException $db){
  200. self::rollbackTrans();
  201. return false;
  202. }
  203. }
  204. /**
  205. * 转义的模板信息
  206. */
  207. private function TplParam($content) {
  208. $data = func_get_args();
  209. foreach ($data[1] as $k => $v) {
  210. $content = str_replace('{' . $k . '}', $v, $content);
  211. }
  212. return $content;
  213. }
  214. }