UserPartake.php 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. <<<<<<< HEAD
  2. <?php
  3. namespace app\models\user;
  4. use app\admin\model\order\StoreOrder;
  5. use app\admin\model\user\User;
  6. use think\Model;
  7. class UserPartake extends Model
  8. {
  9. protected $name = 'user_partake';
  10. protected $autoWriteTimestamp = true;
  11. /**
  12. * 参与累计金额
  13. * @param $order
  14. * @return void
  15. */
  16. public static function cumulative()
  17. {
  18. $user = User::select();
  19. foreach ($user as $item){
  20. $partake = UserPartake::where('uid', $item['uid'])->where('status', 0)->find();
  21. if ($partake){
  22. $uids = User::where('spread_uid', $item['uid'])->column('uid');
  23. $money = StoreOrder::where('uid', 'in', $uids)
  24. ->where('paid', 1)
  25. ->where('is_participate', 0)
  26. ->sum('pay_price');
  27. $out = Out::where('id', $partake['out_id'])->find();
  28. if ($money >= $out['number']){
  29. User::where('uid', $item['uid'])->dec('pay_price', $money)->update();
  30. User::where('uid', $item['uid'])->inc('use_price', $money)->update();
  31. $partake['status'] = 1;
  32. $partake['money'] = $money;
  33. $partake->save();
  34. StoreOrder::where('uid', 'in', $uids)->where('paid', 1)->where('is_participate', 0)->update(['is_participate' => 1]);
  35. }
  36. }
  37. }
  38. }
  39. =======
  40. <?php
  41. namespace app\models\user;
  42. use app\admin\model\order\StoreOrder;
  43. use app\admin\model\user\User;
  44. use think\Model;
  45. class UserPartake extends Model
  46. {
  47. protected $name = 'user_partake';
  48. protected $autoWriteTimestamp = true;
  49. /**
  50. * 参与累计金额
  51. * @param $order
  52. * @return void
  53. */
  54. public static function cumulative()
  55. {
  56. $user = User::select();
  57. foreach ($user as $item){
  58. $partake = UserPartake::where('uid', $item['uid'])->where('status', 0)->find();
  59. if ($partake){
  60. $uids = User::where('spread_uid', $item['uid'])->column('uid');
  61. $money = StoreOrder::where('uid', 'in', $uids)
  62. ->where('paid', 1)
  63. ->where('is_participate', 0)
  64. ->sum('pay_price');
  65. $out = Out::where('id', $partake['out_id'])->find();
  66. if ($money >= $out['number']){
  67. User::where('uid', $item['uid'])->dec('pay_price', $money)->update();
  68. User::where('uid', $item['uid'])->inc('use_price', $money)->update();
  69. $partake['status'] = 1;
  70. $partake['money'] = $money;
  71. $partake->save();
  72. StoreOrder::where('uid', 'in', $uids)->where('paid', 1)->where('is_participate', 0)->update(['is_participate' => 1]);
  73. }
  74. }
  75. }
  76. }
  77. >>>>>>> 386b37d33e5ba817cba00df29efaefbd692e4dd1
  78. }