$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";
