File: //www/exchange0old/exchange/custom_actions/support_79.php
<?php
include('../../include/vars.php');
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
mysql_query('SET FOREIGN_KEY_CHECKS=0;');
$organisation_reference_id='11307000043';
$data=mysql_fetch_assoc(mysql_query('SELECT user_login.*
FROM user_login
LEFT JOIN organisation_details ON organisation_details.user_id = user_login.user_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data['user_id']=NULL;
$data['username']='timmartin01';
mysql_query('INSERT INTO user_login VALUES("'.implode('","',$data).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$user_id=mysql_insert_id();
$data=mysql_fetch_assoc(mysql_query('SELECT *
FROM organisation_details
WHERE organisation_reference_id='.$organisation_reference_id));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data['organisation_id']=NULL;
$data['user_id']=$user_id;
mysql_query('INSERT INTO organisation_details VALUES("'.implode('","',$data).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$organisation_id=mysql_insert_id();
mysql_query('UPDATE organisation_details
SET organisation_reference_id=(CONCAT("1",DATE_FORMAT(modified_at,"%y%m"), "000000") + organisation_id)
WHERE organisation_id='.$organisation_id);
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data=mysql_fetch_assoc(mysql_query('SELECT temp_registration.*
FROM temp_registration
LEFT JOIN organisation_details ON temp_registration.user_id = organisation_details.user_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data['temp_reg_id']=NULL;
$data['username']='timmartin01';
$data['user_id']=$user_id;
mysql_query('INSERT INTO temp_registration VALUES("'.implode('","',$data).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$temp_reg_id=mysql_insert_id();
mysql_query('UPDATE temp_registration
SET ref_id=(CONCAT("1",DATE_FORMAT(modified_at,"%y%m"), "000000") + temp_reg_id)
WHERE temp_reg_id='.$temp_reg_id);
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data=mysql_fetch_assoc(mysql_query('SELECT organisation_documents.*
FROM organisation_documents
LEFT JOIN organisation_details ON organisation_details.organisation_id = organisation_documents.organisation_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data['loss_report_path']='';
$data['organization_document_id']=NULL;
$data['identification_path']='documents/org/'.$organisation_id.'_'.$user_id;
$data['organisation_id']=$organisation_id;
mysql_query('INSERT INTO organisation_documents VALUES("'.implode('","',$data).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data=mysql_fetch_assoc(mysql_query('SELECT organisation_process_relation.*
FROM organisation_process_relation
LEFT JOIN organisation_details ON organisation_details.user_id = organisation_process_relation.user_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data['relation_id']=NULL;
$data['user_id']=$user_id;
mysql_query('INSERT INTO organisation_process_relation VALUES("'.implode('","',$data).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data=mysql_query('SELECT *
FROM (
SELECT organisation_currency.*
FROM organisation_currency
LEFT JOIN organisation_details ON organisation_details.organisation_id = organisation_currency.organisation_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id.'
UNION
SELECT NULL,organisation_bank_details.organisation_id,NULL,NULL,NULL,organisation_bank_id,NULL
FROM organisation_bank_details
LEFT JOIN organisation_details ON organisation_details.organisation_id = organisation_bank_details.organisation_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id.'
) AS T
GROUP BY T.currency_bank_id');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$used_organisation_bank_ids=array();
while($item=mysql_fetch_assoc($data))
{
$used_organisation_bank_ids[]=$item['currency_bank_id'];
$organisation_bank_details=mysql_fetch_assoc(mysql_query('SELECT * FROM organisation_bank_details WHERE organisation_bank_id='.$item['currency_bank_id']));
$address=mysql_fetch_assoc(mysql_query('SELECT * FROM address_details WHERE address_id='.$organisation_bank_details['address_id']));
$address['address_id']=NULL;
mysql_query('INSERT INTO address_details VALUES("'.implode('","',$address).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$address_id=mysql_insert_id();
$bank_details=mysql_fetch_assoc(mysql_query('SELECT * FROM bank_details WHERE bank_id='.$organisation_bank_details['bank_id']));
$bank_details['bank_id']=NULL;
mysql_query('INSERT INTO bank_details VALUES("'.implode('","',$bank_details).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$bank_id=mysql_insert_id();
$contact_details=mysql_fetch_assoc(mysql_query('SELECT * FROM contact_details WHERE contact_id='.$organisation_bank_details['contact_id']));
$contact_details['contact_id']=NULL;
foreach(array('home_address_id','hq_address_id','work_address_id') as $contact_address_id)
{
$contact_address=mysql_fetch_assoc(mysql_query('SELECT * FROM address_details WHERE address_id='.$contact_details[$contact_address_id]));
$contact_address['address_id']=NULL;
mysql_query('INSERT INTO address_details VALUES("'.implode('","',$contact_address).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$contact_details[$contact_address_id]=mysql_insert_id();
}
$contact_details['organisation_id']=$organisation_id;
mysql_query('INSERT INTO contact_details VALUES("'.implode('","',$contact_details).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$contact_id=mysql_insert_id();
$organisation_bank_account_details=mysql_fetch_assoc(mysql_query('SELECT * FROM organisation_bank_account_details WHERE organisation_bank_id='.$organisation_bank_details['organisation_bank_id']));
$organisation_bank_account_details['account_id']=NULL;
$organisation_bank_account_details['organisation_id']=$organisation_id;
$organisation_bank_details['organisation_bank_id']=NULL;
$organisation_bank_details['organisation_id']=$organisation_id;
$organisation_bank_details['address_id']=$address_id;
$organisation_bank_details['bank_id']=$bank_id;
$organisation_bank_details['contact_id']=$contact_id;
mysql_query('INSERT INTO organisation_bank_details VALUES ("'.implode('","',$organisation_bank_details).'");');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$currency_bank_id=mysql_insert_id();
if (!is_null($item['org_currency_id']))
{
$item['org_currency_id']=NULL;
$item['organisation_id']=$organisation_id;
$item['currency_bank_id']=$currency_bank_id;
mysql_query('INSERT INTO organisation_currency VALUES("'.implode('","',$item).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
$organisation_bank_account_details['organisation_bank_id']=$currency_bank_id;
mysql_query('INSERT INTO organisation_bank_account_details VALUES("'.implode('","',$organisation_bank_account_details).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
$data=mysql_fetch_assoc(mysql_query('SELECT *
FROM organisation_bank_details
WHERE organisation_id=43 AND organisation_bank_id NOT IN ('.implode(',',$used_organisation_bank_ids).')'));
$data=mysql_query('SELECT debtors_detail.*
FROM organisation_details
LEFT JOIN debtor_relation ON debtor_relation.trader_id = organisation_details.user_id
LEFT JOIN debtors_detail ON debtors_detail.debtor_id = debtor_relation.debtor_id
WHERE organisation_reference_id='.$organisation_reference_id);
$creditors=array();
$is_150=FALSE;
while($debtor=mysql_fetch_assoc($data))
{
if ($debtor['type']=='creditor')
{
$invoices=mysql_query('SELECT * FROM invoice_master WHERE debtor_id='.$debtor['debtor_id']);
$transactions=mysql_query('SELECT * FROM manual_transactions WHERE debtor_id='.$debtor['debtor_id']);
}
if ($debtor['type']=='debtor' AND $debtor['debtor_id']=='150')
{
$is_150=TRUE;
//$invoice_5071=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_master WHERE invoice_id=19966'));
}
$relation=mysql_fetch_assoc(mysql_query('SELECT * FROM debtor_relation WHERE debtor_id='.$debtor['debtor_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$debtor_bank_details=mysql_fetch_assoc(mysql_query('SELECT * FROM debtor_bank_details WHERE debtor_id='.$debtor['debtor_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$debtor_history_report=mysql_query('SELECT * FROM debtor_history_report WHERE debtor_id='.$debtor['debtor_id']);
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$debtor['debtor_id']=NULL;
foreach(array('address_id','billing_address_id','contact_address_id') as $debtor_address_id)
{
$debtor_address=mysql_fetch_assoc(mysql_query('SELECT * FROM address_details WHERE address_id='.$debtor[$debtor_address_id]));
if ($debtor_address)
{
$debtor_address['address_id']=NULL;
mysql_query('INSERT INTO address_details VALUES("'.implode('","',$debtor_address).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$debtor[$debtor_address_id]=mysql_insert_id();
}
}
mysql_query('INSERT INTO debtors_detail VALUES("'.implode('","',$debtor).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$debtor_id = mysql_insert_id();
mysql_query('UPDATE `debtors_detail`
SET `debtor_reference_id` = (CONCAT(DATE_FORMAT(created,"%Y%m%d"),"000000") + debtor_id)
WHERE debtor_id='.$debtor_id.'
LIMIT 1');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
if ($is_150)
{
/*$invoice_documents=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_documents WHERE invoice_id='.$invoice_5071['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_closed=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_closed WHERE invoice_id='.$invoice_5071['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_closed_attributes=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_closed_attributes WHERE invoice_id='.$invoice_5071['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_5071['debtor_id']=$debtor_id;
$invoice_5071['user_id']=$user_id;
$invoice_5071['invoice_id']=NULL;
mysql_query('INSERT INTO invoice_master VALUES("'.str_replace(array('"{"','"}}"'),array('\'{"','"}}\''),implode('","',$invoice_5071)).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_id = mysql_insert_id();
mysql_query('UPDATE `invoice_master` SET
`trade_reference_id`=(CONCAT(DATE_FORMAT(created_at,"%y%m%d"),"000000") + invoice_id),
reserve = NULL
WHERE `invoice_id` ='.$invoice_id.'
LIMIT 1');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
if ($invoice_documents)
{
$invoice_documents['invoice_id']=$invoice_id;
$invoice_documents['invoice_document_id']=NULL;
mysql_query('INSERT INTO invoice_documents VALUES("'.implode('","',$invoice_documents).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
$invoice_closed['invoice_id']=$invoice_id;
$invoice_closed['close_id']=NULL;
mysql_query('INSERT INTO invoice_closed VALUES("'.implode('","',$invoice_closed).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$close_id=mysql_insert_id();
$invoice_closed_attributes['invoice_id']=$invoice_id;
$invoice_closed_attributes['attribute_id']=NULL;
$invoice_closed_attributes['invoice_closed_id']=$close_id;
mysql_query('INSERT INTO invoice_closed_attributes VALUES("'.implode('","',$invoice_closed_attributes).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}*/
mysql_query('UPDATE invoice_master SET
debtor_id= '.$debtor_id.',
user_id = '.$user_id.'
WHERE invoice_id=19966');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$is_150=FALSE;
}
$relation['debtor_id']=$debtor_id;
$relation['trader_id']=$user_id;
$relation['organisation_id']=$organisation_id;
$relation['relation_id']=NULL;
mysql_query('INSERT INTO debtor_relation VALUES("'.implode('","',$relation).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
if ($debtor_bank_details)
{
$debtor_bank_details['debtor_bank_id']=NULL;
$debtor_bank_details['debtor_id']=$debtor_id;
mysql_query('INSERT INTO debtor_bank_details VALUES("'.implode('","',$debtor_bank_details).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
while($debtor_history_item=mysql_fetch_assoc($debtor_history_report))
{
$debtor_history_item['debtor_history_report_id']=NULL;
$debtor_history_item['debtor_id']=$debtor_id;
mysql_query('INSERT INTO debtor_history_report VALUES("'.implode('","',$debtor_history_item).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
if ($debtor['type']=='creditor')
{
while($invoice=mysql_fetch_assoc($invoices))
{
$invoice_documents=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_documents WHERE invoice_id='.$invoice['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_closed=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_closed WHERE invoice_id='.$invoice['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_closed_attributes=mysql_fetch_assoc(mysql_query('SELECT * FROM invoice_closed_attributes WHERE invoice_id='.$invoice['invoice_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice['invoice_id']=NULL;
$invoice['debtor_id']=$debtor_id;
$invoice['user_id']=$user_id;
mysql_query('INSERT INTO invoice_master VALUES("'.str_replace(array('"{"','"}}"'),array('\'{"','"}}\''),implode('","',$invoice)).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$invoice_id = mysql_insert_id();
mysql_query('UPDATE `invoice_master` SET
`trade_reference_id`=(CONCAT(DATE_FORMAT(created_at,"%y%m%d"),"000000") + invoice_id)
WHERE `invoice_id` ='.$invoice_id.'
LIMIT 1');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
if ($invoice_documents)
{
$invoice_documents['invoice_id']=$invoice_id;
$invoice_documents['invoice_document_id']=NULL;
mysql_query('INSERT INTO invoice_documents VALUES("'.implode('","',$invoice_documents).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
if ($invoice_closed)
{
$invoice_closed['invoice_id']=$invoice_id;
$invoice_closed['close_id']=NULL;
mysql_query('INSERT INTO invoice_closed VALUES("'.implode('","',$invoice_closed).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$close_id=mysql_insert_id();
$invoice_closed_attributes['invoice_id']=$invoice_id;
$invoice_closed_attributes['attribute_id']=NULL;
$invoice_closed_attributes['invoice_closed_id']=$close_id;
mysql_query('INSERT INTO invoice_closed_attributes VALUES("'.implode('","',$invoice_closed_attributes).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
}
while($transaction=mysql_fetch_assoc($transactions))
{
$transaction['debtor_id']=$debtor_id;
$transaction['originator_id']=$user_id;
$transaction['manual_transaction_id']=NULL;
mysql_query('INSERT INTO manual_transactions VALUES("'.implode('","',$transaction).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
}
}
$OPA_trans=mysql_query('SELECT manual_transactions.*
FROM manual_transactions
LEFT JOIN organisation_details ON organisation_details.user_id = manual_transactions.originator_id
WHERE organisation_details.organisation_reference_id='. $organisation_reference_id.' AND transaction_type=7');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
while($transaction=mysql_fetch_assoc($OPA_trans))
{
$transaction['originator_id']=$user_id;
$transaction['manual_transaction_id']=NULL;
mysql_query('INSERT INTO manual_transactions VALUES("'.implode('","',$transaction).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
mysql_query('INSERT INTO activity_logs (activity_id,title,link,log_element_id,admin_user_id,user_id,debtor_id,organisation_id,invoice_id,created_at)
SELECT NULL,title,link,log_element_id,admin_user_id,'.$user_id.',debtor_id,'.$organisation_id.',invoice_id,activity_logs.created_at
FROM activity_logs
LEFT JOIN organisation_details ON organisation_details.organisation_id = activity_logs.organisation_id
WHERE organisation_details.organisation_reference_id='.$organisation_reference_id);
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$data=mysql_query('SELECT contact_details.*
FROM contact_details
LEFT JOIN organisation_details ON organisation_details.organisation_id = contact_details.organisation_id
WHERE organisation_reference_id='.$organisation_reference_id.' AND position = 2
UNION
SELECT c.*
FROM temp_registration as t , organisation_details as org, contact_details as c
WHERE org.organisation_reference_id = '.$organisation_reference_id.' && t.user_id = org.user_id && c.temp_reg_id = t.temp_reg_id');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
while($contact_details=mysql_fetch_assoc($data))
{
$contact_details['contact_id']=NULL;
foreach(array('home_address_id','hq_address_id','work_address_id') as $contact_address_id)
{
$contact_address=mysql_fetch_assoc(mysql_query('SELECT * FROM address_details WHERE address_id='.$contact_details[$contact_address_id]));
$contact_address['address_id']=NULL;
mysql_query('INSERT INTO address_details VALUES("'.implode('","',$contact_address).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$contact_details[$contact_address_id]=mysql_insert_id();
}
if (!is_null($contact_details['organisation_id']))
{
$contact_details['organisation_id']=$organisation_id;
}
else
{
$contact_details['temp_reg_id']=$temp_reg_id;
}
mysql_query('INSERT INTO contact_details VALUES("'.implode('","',$contact_details).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
$data=mysql_query('SELECT risk_credit.*
FROM risk_credit
LEFT JOIN organisation_details ON organisation_details.organisation_id = risk_credit.organisation_id
WHERE organisation_reference_id='.$organisation_reference_id);
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
while($item=mysql_fetch_assoc($data))
{
$risk_credit_document=mysql_fetch_assoc(mysql_query('SELECT * FROM risk_credit_document WHERE risk_credit_id='.$item['risk_credit_id']));
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$logs=mysql_query("SELECT *
FROM activity_logs
WHERE log_element_id=".$item['risk_credit_id']." AND title IN ('UPDATE_RISK_SELLRATE','ADD_RISK_SELLRATE','UPDATE_PURCHASE_PRICE','ADD_PURCHASE_PRICE','UPDATE_NO_TRADE_START_PRICE','ADD_NO_TRADE_START_PRICE','ORIGINATOR_RISK_UPDATE','ORIGINATOR_RISK_ADD')");
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$item['risk_credit_id']=NULL;
$item['organisation_id']=$organisation_id;
mysql_query('INSERT INTO risk_credit VALUES("'.implode('","',$item).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
$risk_credit_id=mysql_insert_id();
$risk_credit_document['risk_credit_document_id']=NULL;
$risk_credit_document['risk_credit_id']=$risk_credit_id;
mysql_query('INSERT INTO risk_credit_document VALUES("'.implode('","',$risk_credit_document).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
while($log=mysql_fetch_assoc($logs))
{
$log['activity_id']=NULL;
$log['log_element_id']=$risk_credit_id;
$log['organisation_id']=$organisation_id;
mysql_query('INSERT INTO activity_logs VALUES("'.implode('","',$log).'")');
if (mysql_errno()>0)
{
var_dump(mysql_error().' >'.__LINE__);
}
}
}
?>