本项的修复可以说是走了不少的弯路,以前把问题想复杂了,经过修改后,任务完成会自动给分享鱼塘的商家返佣金
// 给鱼塘主人返奖金
$orderDetail = Db::name('隐藏')->where('id', 'eq', $orderId)->find();
$taskInfo=Db::name('task')->where('id', 'eq', $taskId)->find();//根据任务号获取任务详情
$businessId = $pdo->query('select businessId from 隐藏 where `id`=' . $taskInfo['fish_id'])->fetch();
if(隐藏){
$businessCommission = $share_fish_percent * $fish_pay_money / 100;
$fish_score = $businessCommission;
// 记录资金变动明细
$business_info = $pdo->query('select * from 隐藏 where `id`=' . $businessId['businessId'])->fetch();
Db::name('business_account_detail')->insert([
'business_id' => $businessId['businessId'],
'balance' => $business_info['balance'],
'commission' => $business_info['commission'],
'change_balance' => $fish_score,
'change_commission' => 0,
'business_balance' => $business_info['balance']+$fish_score,
'business_commission' => $business_info['commission'],
'content' => '分享鱼塘收益',
'type' => 7,
'created_at' => time()
]);
$pdo->exec('update 隐藏 set balance=' . $fish_score . ' where `id`=' . $businessId['businessId']);
}