$log .= " Updating Transaction Profit for '" . $cs_profit_action['pa_trans_id'] . "'.\n"; $r = $RF->update_transaction_profit($cs_profit_action['pa_trans_id']); $log .= " Result: " . $r['msg'] . "\n"; } } //toLog('misc','system', $log); $sql = "SELECT * FROM `cs_profit_action` WHERE `pa_status` = 'pending' and `pa_type` = 'Payout' order by pa_ID desc LIMIT 1000"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (mysql_num_rows($result) == 0) { $log .= "No Payout Updates\n"; } else { $log .= "\n Updating Pending Payout Actions.\n"; while ($cs_profit_action = mysql_fetch_assoc($result)) { $log .= " Updating Payout Profit for Entity '" . $cs_profit_action['pa_en_ID'] . "'.\n"; $r = $RF->commit_payout($cs_profit_action['pa_en_ID'], array('date_entered' => $cs_profit_action['pa_date'])); $log .= " Result: " . $r['msg'] . "\n"; } } $sql = "SELECT * FROM `cs_profit_action` WHERE `pa_status` = 'delete' order by pa_ID desc LIMIT 1000"; $result = sql_query_read($sql) or dieLog(mysql_error() . " ~ {$sql}"); if (mysql_num_rows($result) == 0) { $log .= "\nNo Voided Entries\n"; } else { $log .= "\n Updating Void Actions.\n"; while ($cs_profit_action = mysql_fetch_assoc($result)) { $log .= " Updating Void Action '" . $cs_profit_action['pa_ID'] . "'.\n"; $r = $RF->undo_transfer($cs_profit_action['pa_ID']); $log .= " Result: " . $r['msg'] . "\n"; } } echo nl2br($log);
$data['type'] = 'Withheld'; $data['date_entered'] = $dateEntered; $data['description'] = "Withheld by Bank"; $data['en_ID'] = $profitInfo['en_ID']; $data['bank_ID'] = $bankID; $transfer = array(); $transfer['amount'] = $profitInfo['amt'] * $rate; $transfer['from_entity'] = $profitInfo['en_ID']; $transfer['to_entity'] = $profitInfo['bank_en_ID']; $transfer['date_effective'] = $dateEntered; $transfer['transfer_type'] = 'Bank Withheld'; $data['transfers'][] = $transfer; if ($transfer['amount'] > 10) { if ($old_pa_ID) { echo "<BR>Undoing {$old_pa_ID}<BR>"; print_r($RF->undo_transfer($old_pa_ID)); $data['pa_ID'] = $old_pa_ID; } $pa_ID = $RF->commit_transfer($data, true); print_r($profitInfo); print_r($data); echo "<BR><BR>"; } else { echo "Skipped<BR>"; } } } die; // Add wire fees! $RF = new rates_fees(); $sql = " select * from cs_profit_action\r\n\tleft join cs_profit on pa_ID = pt_action_ID and pt_type = 'Funds Transfer Fee'\r\nwhere pa_type='Payout' and pt_ID is null \r\n";