Index.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use app\common\model\ProductOrder;
  5. use fast\Asset;
  6. use app\common\model\LedgerTeacChangeModel;
  7. use app\common\model\LedgerWalletModel;
  8. use app\common\model\UserPledge;
  9. use fast\Random;
  10. /**
  11. * 首页接口
  12. */
  13. class Index extends Api
  14. {
  15. protected array $noNeedLogin = ['*'];
  16. private $loaded = false;
  17. private $data;
  18. //测试脚本
  19. public function task(UserPledge $userPledge, ProductOrder $productOrder, LedgerWalletModel $ledgerWalletModel) {
  20. //$rows = UserPledge::where('status', '=', 1)->select();
  21. $list = $userPledge::alias('a')
  22. ->join('product_pledge b', 'a.pledge_id = b.id', 'left')
  23. ->where('a.status', '>', 0)
  24. ->field('a.*,b.day_num')
  25. ->select();
  26. $i = 0;
  27. $time= time();
  28. $day = 86400;
  29. foreach ($list as $item) {
  30. if($item->status == 2) {
  31. //解除收益
  32. $total = $item->total_self;
  33. }else{
  34. //未接触收益
  35. $reta = bcdiv($item->day_num, $day, 6); //天数
  36. $inter = ($item->last_time == 0) ? $time - $item->create_time: $time - $item->last_time; //最后收取时间
  37. $total_inco = bcmul($reta, $inter, 6) * $item->num; //累计收益
  38. $item->last_time = $time; //收取时间
  39. $item->total_self= bcadd($total_inco, $item->total_self, 2); //累计收益
  40. $total = $total_inco; //累计收益
  41. }
  42. //更新用户资产
  43. $ledgerWalletModel->changeWalletAccount($item->user_id, Asset::TEAC, $total, LedgerTeacChangeModel::Pledge, 0);
  44. //修改详情订单状态
  45. $detail = json_decode($item['details'], true);
  46. $productOrder::where('status', 6)->whereIn('id', array_column($detail, 'id'))->setField('status', ProductOrder::Paid);
  47. //更新存储订单状态
  48. $item->last_time = $time;
  49. $item->status = 0; //关闭
  50. $item->save();
  51. $i++;
  52. }
  53. $this->success('ok:'. $i);
  54. }
  55. }