Esempio n. 1
0
    $data['type'] = 'Payout';
    $data['date_entered'] = $invoiceInfo['mi_paydate'];
    $data['description'] = $invoiceInfo['mi_title'];
    $data['en_ID'] = $invoiceInfo['en_ID'];
    $transfer = array();
    $transfer['amount'] = floatval($invoiceInfo['mi_balance']);
    $transfer['from_entity'] = $invoiceInfo['en_ID'];
    $transfer['to_entity'] = 2;
    $transfer['date_effective'] = $invoiceInfo['mi_paydate'];
    $transfer['transfer_type'] = 'Payout';
    if ($invoiceInfo['mi_notes']) {
        $data['information']['Notes'] = $invoiceInfo['mi_notes'];
    }
    $data['transfers'][] = $transfer;
    $RF = new rates_fees();
    $pa_ID = $RF->commit_transfer($data, true);
    $sql = "\r\n\t\tUpdate \r\n\t\t\tcs_profit_action\r\n\t\tSet\r\n\t\t\tpa_status = 'pa_status'\r\n\t\tWhere\r\n\t\t\tpa_ID = '{$pa_ID}'\r\n\t\t";
    sql_query_write($sql) or dieLog(mysql_error() . " ~ {$sql}");
}
/*
delete
FROM `cs_profit`
WHERE `pt_type` = 'Payout';

delete
FROM `cs_profit_action`
WHERE pa_type = 'Payout'
*/
die;
$sql = "Select \r\n*\r\n from cs_companydetails\r\n ";
$result = sql_query_read($sql) or dieLog($sql);