loginAdmin(); if(!loggedAdmin()) header('location: index.php'); $transaction = new TransactionCollection(); $clients = ClientCollection::getClients(); $isins = IsinCollection::getIsins(); $collection = new SecurityCollection(); $isinCollection = new IsinCollection; $accounts = CustodyCollection::getAccountsForClientByTransactionId(mysql_real_escape_string($_GET['id'])); if(exist($_POST['button'])) { $result = TransactionCollection::updateTransaction(); } else { TransactionCollection::loadTransaction(); $result = array(); } include("$templates/menu.php"); $clients = ClientCollection::getClients(); $isins = IsinCollection::getIsins(); include("$templates/transaction_edit.php"); include("$templates/footer.php"); ?>
<?php include('config.php'); include('functions.php'); include('classes/client.class.php'); include('classes/security.class.php'); include('classes/securitycollection.class.php'); include('classes/isin.class.php'); include('classes/isincollection.class.php'); include('classes/transactioncollection.class.php'); //check, if client is already logged in. login(); if(!logged()) { include('login_header.php'); } //process data $transaction = new TransactionCollection(); $collection = new SecurityCollection(); $isinCollection = new IsinCollection; $client = new Client; $isins = $isinCollection->getIsins(); $accounts = getAccounts(); include($templates.'menu.html'); echo strtoupper('THANK YOU!<br/><br/>YOUR ORDER HAS BEEN SUCCESSFULLY PROCESSED!'); include($templates.'welcome.html'); include($templates.'footer.html'); ?>
<?php include('../config.php'); include('../functions.php'); include('../classes/isincollection.class.php'); include('../classes/currencycollection.class.php'); include('../classes/clientcollection.class.php'); include('../classes/anytable.class.php'); loginAdmin(); if(!loggedAdmin()) header('location: index.php'); include("$templates/menu.php"); $total = count(IsinCollection::getHistory())-1; $instance = IsinCollection::getHistoryInstance(); include("$templates/isins_history.php"); include("$templates/footer.php"); ?>
<?php include('../config.php'); include('../functions.php'); include('../classes/anytable.class.php'); include('../classes/isincollection.class.php'); include('../classes/currencycollection.class.php'); loginAdmin(); if(!loggedAdmin()) header('location: index.php'); if(exist($_POST['add'])) { $result = IsinCollection::addIsin(); if(!count($result)) header("location: isins_created.php"); } include("$templates/menu.php"); $currencies = CurrencyCollection::getCurrencies(); include("$templates/isins_add.php"); include("$templates/footer.php"); ?>
<?php include('../config.php'); include('../functions.php'); include('../classes/isincollection.class.php'); include('../classes/currencycollection.class.php'); include('../classes/clientcollection.class.php'); include('../classes/anytable.class.php'); loginAdmin(); if(!loggedAdmin()) header('location: index.php'); if(exist($_POST['add'])) { $result = IsinCollection::AddIsin(true); if(!count($result)) header('location: isins_updated.php'); } else IsinCollection::loadIsin(); include("$templates/menu.php"); $currencies = CurrencyCollection::getCurrencies(); include("$templates/isins_edit.php"); include("$templates/footer.php"); ?>
static public function addIsin($update = false) { //1. verify values IsinCollection::verifyFields(); //2. add values. extract($_POST); /* if admin created new records into transfer_agent,custodian, fund_advisor and fund_auditor tables */ if(!$transfer_agent_id) { $query = "INSERT INTO `transfer_agent` (`id` ,`transfer_agent` ,`postal_address` , `postal_address_I` ,`phone_number` ,`account_number` ,`key_contact_persons` ,`email_address` , `fax_no` ,`additional_information` ,`zip` ) VALUES (NULL , '$transfer_agent', '$postal_address', '$postal_address_I' ,'$phone_number' , '$account_number' ,'$key_contact_persons' ,'$email_address' ,'$fax_no' ,'$additional_information' , '$zip' );"; mysql_query($query) or die('failed to execute query '.$query); $transfer_agent_id = mysql_insert_id(); } elseif($update&&$transfer_agent_id) { //update record in transfer_agent table $query = "UPDATE `transfer_agent` SET `transfer_agent` = '$transfer_agent', `postal_address` = '$postal_address', `postal_address_I` = '$postal_address_I', `phone_number` = '$phone_number', `account_number` = '$account_number', `key_contact_persons` = '$key_contact_persons', `email_address` = '$email_address', `fax_no` = '$fax_no', `additional_information` = '$additional_information', `zip` = '$zip' WHERE `transfer_agent`.`id` = '$transfer_agent_id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } if(!trim($custodian_id)) { //add record to table; $query="INSERT INTO `custodian` (`id` ,`custodian` ,`postal_address_a` , `postal_address_b` ,`zip_city` ,`key_contact_person_a_cu` ,`email_address_a` , `key_contact_person_b` ,`email_address_b` ,`phone_number_cu` ,`fax_number` , `settlement_details_a` ,`settlement_details_b` ,`settlement_details_c` ,`account_number_cu` ) VALUES (NULL , '$custodian' ,'$postal_address_a' ,'$postal_address_b' ,'$zip_city' , '$key_contact_person_a_cu' ,'$email_address_a' ,'$key_contact_person_b' ,'$email_address_b' , '$phone_number_cu' ,'$fax_number' ,'$settlement_details_a' ,'$settlement_details_b' , '$settlement_details_c' ,'$account_number_cu' );"; //get insert id. mysql_query($query) or die('failed to execute query '.$query); $custodian_id = mysql_insert_id(); } elseif($update&&trim($custodian_id)) { //update record in custodian table $query="UPDATE `custodian` SET `custodian` = '$custodian', `postal_address_a` = '$postal_address_a', `postal_address_b` = '$postal_address_b', `zip_city` = '$zip_city', `key_contact_person_a_cu` = '$key_contact_person_a_cu', `email_address_a` = '$email_address_a', `key_contact_person_b` = '$key_contact_person_b', `email_address_b` = '$email_address_b', `phone_number_cu` = '$phone_number_cu', `fax_number` = '$fax_number', `settlement_details_a` = '$settlement_details_a', `settlement_details_b` = '$settlement_details_b', `settlement_details_c` = '$settlement_details_c', `account_number_cu` = '$account_number_cu' WHERE `custodian`.`id` = '$custodian_id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } if(!trim($fund_advisor_id)) { //add record to table; $query="INSERT INTO `fund_advisor` (`id` ,`fund_advisor` ,`postal_address_adv` , `postal_address_adv_I` ,`phone_number_adv` ,`email_address_adv` ,`fax_number_adv` , `additional_information_adv` ,`zip_city_adv` ) VALUES (NULL , '$fund_advisor' ,'$postal_address_adv' ,'$postal_address_adv_I' , '$phone_number_adv' ,'$email_address_adv' ,'$fax_number_adv' ,'$additional_information_adv' , '$zip_city_adv' );"; //get insert id. mysql_query($query) or die('failed to execute query '.$query); $fund_advisor_id = mysql_insert_id(); // $_POST['transfer_agent_id'] = insert id } elseif($update&&trim($fund_advisor_id)) { //update record in fund_advisor table $query="UPDATE `fund_advisor` SET `fund_advisor` = '$fund_advisor', `postal_address_adv` = '$ostal_address_adv', `postal_address_adv_I` = '$ostal_address_adv_I', `phone_number_adv` = '$phone_number_adv', `email_address_adv` = '$email_address_adv', `fax_number_adv` = '$fax_number_adv', `additional_information_adv` = '$additional_information_adv', `zip_city_adv` = '$zip_city_adv' WHERE `fund_advisor`.`id` ='$fund_advisor_id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } if(!trim($fund_auditor_id)) { //add record to table; $query="INSERT INTO `fund_auditor` (`id` ,`fund_auditor` ,`postal_address_fau` , `postal_address_fau_I` ,`phone_number_fau` ,`email_address_fau` ,`fax_number_fau` , `additional_information_fau` ,`zip_city_fau` ) VALUES (NULL , '$fund_auditor' ,'$postal_address_fau' ,'$postal_address_fau_I' , '$phone_number_fau' ,'$email_address_fau' ,'$fax_number_fau' ,'$additional_information_fau' , '$zip_city_fau' );"; mysql_query($query) or die('failed to execute query '.$query); $fund_auditor_id = mysql_insert_id(); } elseif($update&&trim($fund_auditor_id)) { //update record in fund_auditor table $query=" UPDATE `fund_auditor` SET `fund_auditor` = '$fund_auditor', `postal_address_fau` = '$postal_address_fau', `postal_address_fau_I` = '$postal_address_fau_I', `phone_number_fau` = '$phone_number_fau', `email_address_fau` = '$email_address_fau', `fax_number_fau` = '$fax_number_fau', `additional_information_fau` = '$additional_information_fau', `zip_city_fau` = '$zip_city_fau' WHERE `fund_auditor`.`id` = '$fund_auditor_id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } //echo 'EVERYTHINGS FINE!!!'; //insert record (together with $_POST[][][][]) to funds table //up to are we updating field, or inserting new, evaluate $funds_id if($update) $unique_id = $_POST['unique_id']; else $unique_id = IsinCollection::generateUniqueId();//generate new /*if updating field, get old funds_id if inserting field, generate new unique funds_id*/ $query ="INSERT INTO `fund` (`id` ,`ISIN` ,`currency` ,`fund_name` ,`fund_company` , `fund_category` ,`fund_status` ,`domicile` ,`nav_value` ,`nav_date` ,`fund_strategy` , `primary_strategy` ,`secondary_strategy` ,`investment_objectives_a` ,`investment_objectives_b` , `investment_objectives_c` ,`unique_feature_a` ,`unique_feature_b` ,`inception_date` , `current_assets` ,`benchmark` ,`risk_appetite` ,`geographical_exposure` ,`last_audit` , `add_info_a` ,`add_info_b` ,`transfer_agent_id` ,`custodian_id` ,`fund_advisor_id` , `fund_auditor_id` ,`created_at`,`unique_id`) VALUES (NULL ,'$ISIN' ,'$currency' ,'$fund_name' ,'$fund_company' ,'$fund_category' , '$fund_status' ,'$domicile' ,'$nav_value' ,'$nav_date' ,'$fund_strategy' ,'$primary_strategy' , '$secondary_strategy' ,'$investment_objectives_a' ,'$investment_objectives_b' , '$investment_objectives_c' ,'$unique_feature_a' ,'$unique_feature_b' ,'$inception_date' , '$current_assets' ,'$benchmark' ,'$risk_appetite' ,'$geographical_exposure', '$last_audit','$add_info_a','$add_info_b','$transfer_agent_id' ,'$custodian_id' , '$fund_advisor_id' ,'$fund_auditor_id' ,NOW(), $unique_id);"; mysql_query($query) or die('failed to execute query '.$query); $new_id = mysql_insert_id(); //new insert id if(!$update) { $query="INSERT INTO `investment_details` ( `id` ,`initial_minimum_investment` ,`minimum_investment` ,`minimum_units_investment` , `lockup_period` ,`notice_period_i` ,`trading_frequency_i` ,`trading_date_i` , `cut_off_time` ,`settlement_cycle_i` ,`administration_fee` ,`accepted_investor_types` , `performance_since_start` ,`performance_ytd` ,`high_water_mark` ,`hurdle_rate` , `add_info_a` ,`add_info_b` ,`funds_id` ) VALUES (NULL ,'$initial_minimum_investment' ,'$minimum_investment' ,'$minimum_units_investment' , '$lockup_period' ,'$notice_period_i' ,'$trading_frequency_i' ,'$trading_date_i' , '$cut_off_time' ,'$settlement_cycle_i' ,'$administration_fee' ,'$accepted_investor_types' , '$performance_since_start' ,'$performance_ytd' ,'$high_water_mark' ,'$hurdle_rate' , '$add_info_a' ,'$add_info_b' ,'$new_id' );"; mysql_query($query) or die('failed to execute query '.$query); //insert records to investment_details, subscription_fees, redemption_fees, $query="INSERT INTO `subscription_fee` ( `id` ,`funds_id` ,`minimum_front_end_fee` ,`maximum_front_end_fee` ,`management_fee` , `additional_information` ) VALUES (NULL ,'$new_id' ,'$minimum_front_end_fee' ,'$maximum_front_end_fee' , '$management_fee' ,'$additional_information' );"; mysql_query($query) or die('failed to execute query '.$query); $query="INSERT INTO `redemption_details` (`id` ,`funds_id` ,`minimum_amount` , `notice_period` ,`trading_date` ,`settlement_cycle` ,`minimum_units` ,`trading_frequency` , `cut_of_tiime` ,`additional_information` ) VALUES (NULL ,'$new_id' ,'$minimum_amount' ,'$notice_period' ,'$trading_date' , '$settlement_cycle' ,'$minimum_units' ,'$trading_frequency','$cut_of_tiime' , '$additional_information' );"; mysql_query($query) or die('failed to execute query '.$query); $redemption_details_id = mysql_insert_id(); //redemption_details tables (together with insert id) $query="INSERT INTO `redemption_fees` (`id` ,`redemption_details_id` ,`minimum_back_end_fee` , `early_withdrawal_fee` ,`maximum_back_end_fee` ,`additional_information` ) VALUES (NULL ,'$redemption_details_id' ,'$minimum_back_end_fee' ,'$early_withdrawal_fee' , '$maximum_back_end_fee' ,'$additional_information' );"; mysql_query($query) or die('failed to execute query '.$query); // insert data to isins table, for synchronizing. $query="INSERT INTO `isin` ( `id` ,`code` ,`name` ,`id_currency` ,`limit1` ,`limit2` ,`limit3` ,`name_fund` , `nav` ,`date_nav`,`unique_id` ) VALUES (NULL ,'$ISIN' ,'$fund_name' ,'$currency' ,'' ,'' ,'' ,'' ,'$nav_value' ,'$nav_date' ,'$unique_id' );"; mysql_query($query) or die('failed to execute query '.$query); } else { /*1. find ids of investment_details, subscription_fees, redemption_fees, redemption_details tables 2. update these tables */ $investment_detail = mysql_query("SELECT * FROM investment_details WHERE funds_id='$id'"); if ( mysql_error() ) echo mysql_error(); $investment_detail = mysql_fetch_object($investment_detail); $query = "UPDATE `investment_details` SET `initial_minimum_investment` = '$initial_minimum_investment', `minimum_investment` = '$minimum_investment',`minimum_units_investment` = '$minimum_units_investment', `lockup_period` = '$lockup_period',`notice_period_i` = '$notice_period_i', `trading_frequency_i` = '$trading_frequency_i',`trading_date_i` = '$trading_date_i', `cut_off_time` = '$cut_off_time',`settlement_cycle_i` = '$settlement_cycle_i', `administration_fee` = '$administration_fee',`accepted_investor_types` = '$accepted_investor_types', `performance_since_start` = '$performance_since_start',`performance_ytd` = '$performance_ytd', `high_water_mark` = '$high_water_mark',`hurdle_rate` = '$hurdle_rate', `add_info_a` = '$add_info_a',`add_info_b` = '$add_info_b', `funds_id` = '$new_id' WHERE `investment_details`.`id` = '$investment_detail->id' LIMIT 1 ; "; mysql_query($query) or die('failed to execute query '.$query); $subscription_fee = mysql_query("SELECT * FROM subscription_fee WHERE funds_id='$id'"); if ( mysql_error() ) echo mysql_error(); $subscription_fee = mysql_fetch_object($subscription_fee); if ( mysql_error() ) echo mysql_error(); $query = "UPDATE `subscription_fee` SET `funds_id` = '$new_id',`minimum_front_end_fee` = '$minimum_front_end_fee', `maximum_front_end_fee` = '$maximum_front_end_fee',`management_fee` = '$management_fee', `additional_information` = '$additional_information' WHERE `subscription_fee`.`id` = '$subscription_fee->id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); $redemption_details = mysql_query("SELECT * FROM redemption_details WHERE funds_id='$id'"); if ( mysql_error() ) echo mysql_error(); $redemption_details = mysql_fetch_object($redemption_details); if ( mysql_error() ) echo mysql_error(); $query= "UPDATE `redemption_details` SET `funds_id` = '$new_id', `minimum_amount` = '$minimum_amount',`notice_period` = '$notice_period',`trading_date` = '$trading_date', `settlement_cycle` = '$settlement_cycle',`minimum_units` = '$minimum_units',`trading_frequency` = '$trading_frequency', `cut_of_tiime` = '$cut_of_tiime',`additional_information` = '$additional_information' WHERE `redemption_details`.`id` ='$redemption_details->id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); if ( $redemption_details ) { $redemption_fees = mysql_query("SELECT * FROM redemption_fees WHERE redemption_details_id='$redemption_details->redemption_details_id'"); if ( mysql_error() ) echo mysql_error(); $redemption_fees = mysql_fetch_object($redemption_fees); if ( mysql_error() ) echo mysql_error(); $query="UPDATE `redemption_fees` SET `minimum_back_end_fee` = '$minimum_back_end_fee', `early_withdrawal_fee` = '$early_withdrawal_fee',`maximum_back_end_fee` = '$maximum_back_end_fee', `additional_information` = '$additional_information' WHERE `redemption_fees`.`id` = '$redemption_fees->id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } //update isin table, for synchronizing: $query="UPDATE `isin` SET `code` = '$ISIN',`name` = '$fund_name',`id_currency` = '$currency', `nav` = '$nav_value',`date_nav` = '$nav_date' WHERE `unique_id` = '$unique_id' LIMIT 1 ;"; mysql_query($query) or die('failed to execute query '.$query); } }