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