Alltools.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335
  1. <?php
  2. namespace App\Common\Library;
  3. use Illuminate\Support\Facades\DB;
  4. class Alltools {
  5. //四大收益,视频,音频,私聊,礼物
  6. public function shouyi($user_id,$gold,$table,$table_id){
  7. //精确小数点
  8. bcscale(2);
  9. //枚举
  10. $table_enum = [
  11. 'user_match_audio_log' => [
  12. 'prefix'=>'audio',
  13. 'remark' =>'语音',
  14. ],
  15. 'user_match_typing_log' => [
  16. 'prefix'=>'typing',
  17. 'remark' =>'私聊',
  18. ],
  19. 'user_match_video_log' => [
  20. 'prefix'=>'video',
  21. 'remark' =>'视频',
  22. ],
  23. 'gift_user_typing' => [
  24. 'prefix'=>'gift',
  25. 'remark' =>'收礼',
  26. ],
  27. ];
  28. //变量前缀,钱包备注
  29. $prefix = $table_enum[$table]['prefix'];
  30. $remark = $table_enum[$table]['remark'];
  31. //收益者本人
  32. $userinfo = DB::table('mt_user')->select(['id','username','group_id','intro_uid','invite_uid','gender'])->where('id',$user_id)->first();
  33. //没有推荐人,自己等级最高
  34. if(empty($userinfo->intro_uid) || $userinfo->group_id == 3){
  35. return true;
  36. }
  37. //充值者上级
  38. $intro_userinfo = DB::table('mt_user')->select(['id','username','group_id','intro_uid','gender'])->where('id',$userinfo->intro_uid)->first();
  39. if(empty($intro_userinfo)){return true;}
  40. //配置
  41. $config_site = DB::table('mt_config')->whereIn('name',['shouyi_b2a_rate','shouyi_c2a_rate'])->pluck('value','name');
  42. //上级是一级邀请A,本人为B普、B1(二级邀请人),贡献给A
  43. if($intro_userinfo->group_id == 3){
  44. $shouyi_b2a_rate = $config_site['shouyi_b2a_rate'];//b2a 与 b02a相等
  45. $jewelA = bcdiv(bcmul($gold,$shouyi_b2a_rate),100);
  46. $result = $this->lockChangeAccountRemain($intro_userinfo->id,'agentjewel',$jewelA,52, $userinfo->username.$remark,$table,$table_id);
  47. if($result['status']===false)
  48. {
  49. //Db::rollback();
  50. return false;
  51. }
  52. return true;//结束了
  53. }
  54. //上级是二级邀请B1,本人C1,贡献给B和A(表面上说B的钱在A那里,但是有记录,有总额,不能提现即可)
  55. if($intro_userinfo->group_id == 2 && $intro_userinfo->group_id > $userinfo->group_id){
  56. //充值者上上级,也就是A
  57. $intro_intro_userinfo = DB::table('mt_user')->select(['id','username','group_id','intro_uid','gender'])->where('id',$intro_userinfo->intro_uid)->first();
  58. if(empty($intro_intro_userinfo)){return true;}
  59. if($intro_intro_userinfo->group_id == 3){
  60. $shouyi_c2a_rate = $config_site['shouyi_c2a_rate'];
  61. $jewelA = bcdiv(bcmul($gold,$shouyi_c2a_rate),100);
  62. $result = $this->lockChangeAccountRemain($intro_intro_userinfo->id,'agentjewel',$jewelA,52, $userinfo->username.$remark,$table,$table_id);
  63. if($result['status']===false)
  64. {
  65. //Db::rollback();
  66. return false;
  67. }
  68. }
  69. return true;
  70. }
  71. return true;
  72. }
  73. //充值后奖金
  74. public function recharge($user_id,$gold,$table,$payorder_id){
  75. //充值者本人
  76. $userinfo = Db::name('user')->field('id,username,group_id,intro_uid,invite_uid,gender')->where('id',$user_id)->find();
  77. //个人直推邀请充值
  78. if(!empty($userinfo['invite_uid']) && $userinfo['gender'] == 1 && empty($userinfo['intro_uid'])){
  79. $recharge_invite_rate = config('site.invite_recharge_rate');
  80. $jewel = bcdiv(bcmul($gold,$recharge_invite_rate,1),100,1);
  81. $result = model('Wallet')->lockChangeAccountRemain($userinfo['invite_uid'],'jewel',$jewel,41, $userinfo['username'].'充值','pay_order',$payorder_id);
  82. if($result['status']===false)
  83. {
  84. Db::rollback();
  85. return false;
  86. }
  87. }
  88. //没有推荐人,自己等级最高,女性充值不返
  89. if(empty($userinfo['intro_uid']) || $userinfo['group_id'] == 3 || $userinfo['gender'] == 0){
  90. return true;
  91. }
  92. //充值者上级
  93. $intro_userinfo = Db::name('user')->field('id,username,group_id,intro_uid,gender')->where('id',$userinfo['intro_uid'])->find();
  94. if(empty($intro_userinfo)){return true;}
  95. //精确小数点
  96. bcscale(2);
  97. //上级是一级邀请A,本人为B普、B1(二级邀请人),贡献给A
  98. if($intro_userinfo['group_id'] == 3){
  99. $recharge_b2a_rate = config('site.recharge_b2a_rate');//b2a 与 b02a相等
  100. $jewelA = bcdiv(bcmul($gold,$recharge_b2a_rate),100);
  101. $result = model('Wallet')->lockChangeAccountRemain($intro_userinfo['id'],'agentjewel',$jewelA,51, $userinfo['username'].'充值','pay_order',$payorder_id);
  102. if($result['status']===false)
  103. {
  104. Db::rollback();
  105. return false;
  106. }
  107. return true;//结束了
  108. }
  109. //上级是二级邀请B1,本人C1,贡献给B和A(表面上说B的钱在A那里,但是有记录,有总额,不能提现即可)
  110. if($intro_userinfo['group_id'] == 2 && $intro_userinfo['group_id'] > $userinfo['group_id']){
  111. //充值者上上级,也就是A
  112. $intro_intro_userinfo = Db::name('user')->field('id,username,group_id,intro_uid,gender')->where('id',$intro_userinfo['intro_uid'])->find();
  113. if(empty($intro_intro_userinfo)){return true;}
  114. if($intro_intro_userinfo['group_id'] == 3){
  115. $recharge_c2a_rate = config('site.recharge_c2a_rate');
  116. $jewelA = bcdiv(bcmul($gold,$recharge_c2a_rate),100);
  117. $result = model('Wallet')->lockChangeAccountRemain($intro_intro_userinfo['id'],'agentjewel',$jewelA,51, $userinfo['username'].'充值','pay_order',$payorder_id);
  118. if($result['status']===false)
  119. {
  120. Db::rollback();
  121. return false;
  122. }
  123. }
  124. return true;
  125. }
  126. //上级是普通用户,那自己肯定也是普通,则上级可能是D1、C1,找到上上级,如果也是普通C1,停止。如果上上级是B1,则一直追到A1
  127. //上级是普通,自己可能是B1,这种不考虑,因为上级只能用普通网,自己相当于独立于超推网里的新分支,是后台新升级来的
  128. if($intro_userinfo['group_id'] == 1 && $userinfo['group_id'] == 1){
  129. //先给上级普通用户返
  130. $recharge_d2c_rate = config('site.recharge_d2c_rate');//d2c 或 e2d
  131. $jewelC = bcdiv(bcmul($gold,$recharge_d2c_rate),100);
  132. $result = model('Wallet')->lockChangeAccountRemain($intro_userinfo['id'],'agentjewel',$jewelC,51, $userinfo['username'].'充值','pay_order',$payorder_id);
  133. if($result['status']===false)
  134. {
  135. Db::rollback();
  136. return false;
  137. }
  138. //充值者上上级
  139. $intro_intro_userinfo = Db::name('user')->field('id,username,group_id,intro_uid,gender')->where('id',$intro_userinfo['intro_uid'])->find();
  140. if(empty($intro_intro_userinfo)){return true;}
  141. //上上级也是普通C1,说明自己在E1,上级是D1,停止
  142. if($intro_intro_userinfo['group_id'] == 1){
  143. return true;
  144. }
  145. //上上级是B1,上级是C1,自己是D1,
  146. if($intro_intro_userinfo['group_id'] == 2){
  147. //充值者上上级,也就是A
  148. $intro_intro_intro_userinfo = Db::name('user')->field('id,username,group_id,intro_uid,gender')->where('id',$intro_intro_userinfo['intro_uid'])->find();
  149. if(empty($intro_intro_intro_userinfo)){return true;}
  150. if($intro_intro_intro_userinfo['group_id'] == 3){
  151. $recharge_c2a_rate = config('site.recharge_c2a_rate');
  152. $jewelA = bcdiv(bcmul($jewelC,$recharge_c2a_rate),100);
  153. $result = model('Wallet')->lockChangeAccountRemain($intro_intro_intro_userinfo['id'],'agentjewel',$jewelA,51, $userinfo['username'].'充值','pay_order',$payorder_id);
  154. if($result['status']===false)
  155. {
  156. Db::rollback();
  157. return false;
  158. }
  159. }
  160. }
  161. return true;
  162. }
  163. return true;
  164. }
  165. /**
  166. *
  167. * @param floatval $number 金额(正数进账,负数出账)
  168. * @param $accountType 货币类型,money,score
  169. * @param $logtype 日志的类型
  170. * @param $remark 备注
  171. * @param $user_id 用户id
  172. * @param $table 来源表
  173. * @param $data_id 表id
  174. * @param $isAdmin 是否是管理员处理
  175. * @return array
  176. * @return array[status]
  177. * @return array[msg]
  178. * @return array[log_table]
  179. * @return array[log_id]
  180. */
  181. public function lockChangeAccountRemain($user_id,$accountType='gold',$number,$logtype='',$remark='',$table='',$table_id=0,$isAdmin=false)
  182. {
  183. //初始化
  184. $result = array(
  185. 'status'=>false,
  186. 'msg'=>'',
  187. 'log_table' => '',
  188. 'log_id' => '',
  189. );
  190. //获取小数点
  191. $point = 1;
  192. if($accountType == 'agentjewel'){
  193. $point = 2;
  194. }
  195. bcscale($point);
  196. //检测0
  197. $number = floatval( $number );
  198. if( $number == 0 )
  199. {
  200. $result['status'] = true;
  201. $result['msg'] = '交易金额:0';
  202. return $result;
  203. }
  204. if(0 === bccomp($number, 0)){
  205. $result['status'] = true;
  206. $result['msg'] = '交易金额:0';
  207. return $result;
  208. }
  209. //查询余额
  210. $wallet = DB::table('mt_user_wallet')->where('user_id',$user_id)->lockForUpdate()->first();
  211. if(empty($wallet))
  212. {
  213. $result['msg'] = '不存在的用户';
  214. return $result;
  215. }
  216. //扣除金币单独方法
  217. //gold的增加,jewel的增、减
  218. //之前的余额
  219. $wallet_before = $wallet->$accountType;
  220. //正常方法
  221. if(bccomp(bcadd($wallet_before, $number), 0) === -1)
  222. {
  223. $result['msg'] = '余额不足!';
  224. return $result;
  225. }
  226. //钱币操作
  227. $data = array();
  228. $data['user_id'] = $user_id;
  229. $data['log_type'] = $logtype;
  230. $data['money_type'] = $accountType;
  231. $data['before'] = $wallet_before;
  232. $data['change_value'] = $number;
  233. $data['remain'] = bcadd($wallet_before, $number);
  234. $data['table'] = $table;
  235. $data['table_id'] = $table_id;
  236. $data['remark'] = $remark;
  237. $data['createtime'] = time();
  238. $data['updatetime'] = time();
  239. $log_table = 'mt_user_gold_log';
  240. if($accountType == 'agentjewel'){
  241. $log_table = 'mt_user_agentjewel_log';
  242. }
  243. $rs2_id = DB::table($log_table)->insertGetId($data);
  244. //修改金额
  245. $rs1 = DB::table('mt_user_wallet')->where('user_id',$user_id)->update([$accountType => $data['remain']]);
  246. //操作数据库失败
  247. if($rs1 === false || $rs2_id === false){
  248. $result['msg'] = '更新财务记录失败!';
  249. return $result;
  250. }
  251. //默认成功
  252. $result['status'] = true;
  253. $result['msg'] = '账户余额已更新!';
  254. $result['log_table'] = $log_table;
  255. $result['log_id'] = $rs2_id;
  256. return $result;
  257. }
  258. }