File: /home/barbeatleanalyti/public_html/mbaris.beatleanalytics.com/assets/survey/assets/add-company.php
<?php /*
* Plugin Name: Add Company
* Description: Find Your Company Name for Registration
*/
$plugin_dir_path = plugin_dir_path( __FILE__ );
include( $plugin_dir_path . 'client.php');
global $wp_session;
session_start();
function comp()
{
global $wpdb;
$table_name = $wpdb->prefix . "company_type";
$MSQL = "show tables like '$table_name'";
if($wpdb->get_var($MSQL) != $table_name)
{
$sql = "CREATE TABLE IF NOT EXISTS $table_name ( ctid mediumint(9) NOT NULL AUTO_INCREMENT, type text NOT NULL, add_date datetime NULL, add_ip text NULL,
add_by text NULL, update_date datetime NULL, update_ip text NULL, update_by text NULL, PRIMARY KEY ctid (ctid) ) ";
require_once(ABSPATH . "wp-admin/includes/upgrade.php");
dbDelta($sql);
}
$table_name = $wpdb->prefix . "company_packages";
$MSQL = "show tables like '$table_name'";
if($wpdb->get_var($MSQL) != $table_name)
{
$sql = "CREATE TABLE IF NOT EXISTS $table_name (
pid mediumint(9) NOT NULL AUTO_INCREMENT,
type text NOT NULL,
name text NOT NULL,
description text NULL,
price text NOT NULL,
add_date datetime NULL,
add_ip text NULL,
add_by text NULL,
update_date datetime NULL,
update_ip text NULL,
update_by text NULL,
PRIMARY KEY pid (pid)
) ";
require_once(ABSPATH . "wp-admin/includes/upgrade.php");
dbDelta($sql);
}
$table_name = $wpdb->prefix . "company_packages_services";
$MSQL = "show tables like '$table_name'";
if($wpdb->get_var($MSQL) != $table_name)
{
$sql = "CREATE TABLE IF NOT EXISTS $table_name (
sid mediumint(9) NOT NULL AUTO_INCREMENT,
pid text NOT NULL,
name text NOT NULL,
add_date datetime NULL,
add_ip text NULL,
add_by text NULL,
update_date datetime NULL,
update_ip text NULL,
update_by text NULL,
PRIMARY KEY sid (sid)
) ";
require_once(ABSPATH . "wp-admin/includes/upgrade.php");
dbDelta($sql);
}
$table_name = $wpdb->prefix . "package_payment";
$MSQL = "show tables like '$table_name'";
if($wpdb->get_var($MSQL) != $table_name)
{
$sql = " CREATE TABLE IF NOT EXISTS $table_name (
'ppid' int NOT NULL AUTO_INCREMENT,
'pid' mediumint(9) NOT NULL,
'uid' int NULL,
'email' text NOT NULL,
'sic' text NOT NULL,
'siccode' text NOT NULL,
'comapnyname' text NOT NULL,
'companytype' text NOT NULL,
'register_services' text NULL,
'register_services_price' text NULL,
'mail_service' text NULL,
'mail_service_price' text NULL,
'direct_service' text NULL,
'direct_service_price' text NULL,
'extra_service' text NULL,
'transactionid' text NOT NULL,
'status' text NOT NULL,
'totalamount' text NOT NULL,
'date' datetime NOT NULL,
PRIMARY KEY ppid (ppid)
)";
require_once(ABSPATH . "wp-admin/includes/upgrade.php");
dbDelta($sql);
}
}
/* Hook Plugin */
register_activation_hook(__FILE__,'comp');
function custom_menu()
{
/* Adding menus */
add_menu_page(__('Company'),'Company Type', 8,'company_type', 'company_type');
add_submenu_page('company_type', 'Add Packages', 'Add Packages', 9, 'add_company_package', 'add_company_package');
add_submenu_page('company_type', 'Add Package Service', 'Add Package Service', 9, 'add_company_package_service', 'add_company_package_service');
add_submenu_page('company_type', 'Registered Address Services', 'Registered Address Services', 9, 'add_address_services', 'add_address_services');
add_submenu_page('company_type', 'Optional Extras', 'Optional Extras', 9, 'optionalextra', 'optionalextra');
}
add_action('admin_menu', 'custom_menu');
function optionalextra()
{
require_once plugin_dir_path( __FILE__ ) . 'optionalextra.php';
}
function company_type()
{
require_once plugin_dir_path( __FILE__ ) . 'add_company_type.php';
}
function add_company_package_service()
{
require_once plugin_dir_path( __FILE__ ) . 'add_company_package_service.php';
}
function add_company_package()
{
require_once plugin_dir_path( __FILE__ ) . 'add_company_package.php';
}
function add_address_services()
{
require_once plugin_dir_path( __FILE__ ) . 'add_address_services.php';
}
add_action('wp_enqueue_script', 'register_script');
function register_script()
{
wp_enqueue_script('jquery');
wp_enqueue_script( 'my-ajax', plugins_url('/js/ajax.js', __FILE__), array('jquery') );
wp_localize_script('my-ajax','my_ajax_url', array(
'ajax_url'=>admin_url('admin-ajax.php')
));
}
function _isCurl(){
return function_exists('curl_version');
}
function success(){
require_once plugin_dir_path( __FILE__ ) . 'select_package.php';
}
function register_service(){
require_once plugin_dir_path( __FILE__ ) . 'register_service.php';
}
function checkout(){
require_once plugin_dir_path( __FILE__ ) . 'checkout.php';
}
function comapnyinformation(){
require_once plugin_dir_path( __FILE__ ) . 'comapnydetail.php';
}
function display_form()
{
wp_enqueue_style( 'style', plugins_url('/css/next.css',__FILE__), 'all');
global $wpdb;
if(isset($_GET['add_c_sh'])){
require_once plugin_dir_path( __FILE__ ) . 'add_corporate_shareholder.php';
}
elseif(isset($_GET['add_c_sub'])){
require_once plugin_dir_path( __FILE__ ) . 'add_corporate_subscriber.php';
}
elseif(isset($_GET['add_sh'])){
require_once plugin_dir_path( __FILE__ ) . 'add_shareholder.php';
}
elseif(isset($_GET['add_sub'])){
require_once plugin_dir_path( __FILE__ ) . 'add_subscriber.php';
}
elseif(isset($_GET['registered_office'])){
require_once plugin_dir_path( __FILE__ ) . 'register_office.php';
}
elseif(isset($_GET['company_type'])){
require_once plugin_dir_path( __FILE__ ) . 'company_type.php';
}
elseif(isset($_GET['what_next'])){
require_once plugin_dir_path( __FILE__ ) . 'what_next.php';
}
elseif(isset($_GET['company_package'])){
require_once plugin_dir_path( __FILE__ ) . 'company_package.php';
}
elseif(isset($_GET['vvv'])){
require_once plugin_dir_path( __FILE__ ) . 'vvv.php';
}
elseif(isset($_GET['optional_extra'])){
require_once plugin_dir_path( __FILE__ ) . 'optional_extra.php';
}
elseif(isset($_GET['add_c_partner'])){
require_once plugin_dir_path( __FILE__ ) . 'add_corporate_partner.php';
}
elseif(isset($_GET['add_partner'])){
require_once plugin_dir_path( __FILE__ ) . 'add_partner.php';
}
elseif(isset($_GET['add_contact'])){
// Check if paypal request or response
if (isset($_POST["txn_id"])){
global $wpdb;
$result = $wpdb->update('cf_company_package_details', array('cp_tran_id' => $_POST['txn_id'],'cp_status'=>$_POST['payment_status']),array('cp_id' => $_POST['item_number'] ));
if($result > 0){
//echo "Successfully Updated";
}
}
if (isset($_POST["stripeToken"])){
global $wpdb;
$result = $wpdb->update('cf_company_package_details', array('cp_tran_id' => $_POST['stripeToken'],'cp_status'=>'PANDING','cp_payer_email'=>$_POST['stripeEmail']),array('cp_id' => $_POST['item_number'] ));
if($result > 0){
//echo "Successfully Updated";
}
}
require_once plugin_dir_path( __FILE__ ) . 'add_contact_details.php';
}
elseif(isset($_GET['add_c_sec'])){
require_once plugin_dir_path( __FILE__ ) . 'add_corporate_secretary.php';
}
elseif(isset($_GET['addpsec'])){
require_once plugin_dir_path( __FILE__ ) . 'addsecretary.php';
}
elseif(isset($_GET['add_c_dir'])){
require_once plugin_dir_path( __FILE__ ) . 'add_corporate_director.php';
}
elseif(isset($_GET['addsirector'])){
require_once plugin_dir_path( __FILE__ ) . 'seconddirector.php';
}
elseif(isset($_GET['step4'])){
require_once plugin_dir_path( __FILE__ ) . 'step4detail.php';
}
elseif(isset($_GET['sid'])){
require_once plugin_dir_path( __FILE__ ) . 'pscdetail.php';
}
elseif(isset($_GET['add_sec'])){
require_once plugin_dir_path( __FILE__ ) . 'add_secretary.php';
}
elseif(isset($_GET['add_dir'])){
require_once plugin_dir_path( __FILE__ ) . 'add_director.php';
}
elseif(isset($_GET['add_psc'])){
require_once plugin_dir_path( __FILE__ ) . 'psc.php';
}
elseif(isset($_GET['add_sic'])){
require_once plugin_dir_path( __FILE__ ) . 'add_sic.php';
}
elseif(isset($_GET['add_aoa'])){
require_once plugin_dir_path( __FILE__ ) . 'aoa.php';
}
elseif(isset($_GET['company_review'])){
require_once plugin_dir_path( __FILE__ ) . 'review.php';
}
elseif(isset($_GET['ryb'])){
require_once plugin_dir_path( __FILE__ ) . 'run_your_business.php';
}
elseif(isset($_GET['message']) && $_GET['message'] == 'success' && isset($_GET['rid'])){
//print_r($_POST);
comapnyinformation();
}
elseif(isset($_GET['message']) && $_GET['message'] == 'fail' && isset($_GET['rid'])){
//print_r($_POST);
echo '<p>Payment Fail </p>';
}
elseif(isset($_GET['type'])){
if($_SESSION['comefromback'] == true){
if($_GET['type'] == 'Basic' || $_GET['type'] == 'Starter'){
//register_service();
checkout();
}else{
checkout();
//echo "<script>window.location='".get_the_permalink(777)."?step=checkout';</script>";
}
unset($_SESSION['comefromback']);
}
else{ echo "<script>window.location='".get_the_permalink(777)."';</script>"; }
}
elseif($_GET['step']=='checkout'){
if($_POST){
checkout(); }else{ echo "<script>window.location='".get_the_permalink(777)."';</script>"; }
}
elseif(isset($_GET['select_package']) && $_GET['select_package'] == 'true'){
success();
}else{
?>
<script type="text/javascript">
jQuery(document).ready(function()
{
jQuery("#check_company").on('click', function()
{
var company_name = jQuery('#company_name').val();
if(company_name != ''){
jQuery.ajax({
type: "post",
url: "<?php echo admin_url('admin-ajax.php'); ?>",
data: ({'action':'my_ajax_function', 'company_name':company_name}),
dataType: "json",
success: function(response)
{
if(response.SUCCESS)
{
jQuery("#success_msg").text('Congratulations, the '+company_name+' is available!');
jQuery("#success_message").show();
jQuery("#fail_message").hide();
//jQuery("#company_name").prop('disabled', true);
jQuery("#company_name").val("");
jQuery("#check_company").text("Check Again");
}
else
{
jQuery("#fail_message").show();
jQuery("#success_message").hide();
}
}
});
}
});
jQuery('input[name="package_type"]').on('click', function(){
var package_val = jQuery('input[name="package_type"]:checked').val();
var package_amount = jQuery('input[name="package_type"]:checked').attr('amount')
if(package_val != '' && package_amount != ''){
jQuery('input[name="item_name"]').val(package_val);
jQuery('input[name="amount"]').val(package_amount);
}
});
});
</script>
<?php if(!is_front_page()){?>
<link href="<?php echo plugins_url('company/css/company_package.css', dirname(__FILE__)); ?>" rel="stylesheet" />
<div class="col-sm-12 registerf">
<div class="col-sm-2 step"> <i class="glyphicon glyphicon-search active"></i> <span class="active">1. Name Check</span> </div>
<!--<div class="col-sm-2"> <i class="glyphicon glyphicon-registration-mark"></i> <span >2. Enter E-mail & SIC Code</span> </div> -->
<div class="col-sm-2 step"> <i class="glyphicon glyphicon-list-alt"></i> <span >2. Select Package</span> </div>
<!--<div class="col-sm-2"> <i class="glyphicon glyphicon-envelope"></i> <span>3. Address Services</span> </div> -->
<div id="bc-checkout" class="col-sm-2 step"> <i class="glyphicon glyphicon-shopping-cart"></i> <span>3. Checkout</span> </div>
<div class="col-sm-2 step"> <i class="glyphicon glyphicon-file"></i> <span>4.Enter Company Details</span> </div>
</div>
<?php } ?>
<form onSubmit="return false;" method="post" name="company_check" id="company_check">
</h4> </h4>
<div class="form" style="float:left; width:100%; margin-bottom:30px; padding-left:16px;">
<div class="col-sm-2"></div><div class="col-sm-10">
<div class="part-input-left" >
<h3 class="ih-title no-link">Company Name</h3>
<input class="zan-dc-input" type="text" id="company_name" name="q" placeholder="Enter your new company name" style="color: #333333; height:35px;" >
</div>
<div class="part-input-right" >
<h3 class="ih-title no-link"> </h3>
<a href="javascript:void(0);" name="check_company" class="ih-price-btn btn check has-link hover-effect-crossing " id="check_company">Check</a>
<a href="<?php echo 'http://91.109.13.44/~companyformation/wp-login.php';?>" name="login" class="ih-price-btn btn check has-link hover-effect-crossing " id="check_company">Log in</a>
</div>
<div>
<div id="success_message" style="display:none; color:green">
<div id="success_msg">Congratulations, Company name is available!</div>
<br><br>
<a href="<?php echo get_the_permalink(777); ?>?company_type=true" class="btn btn-success" >Save & Continue </a>
</div>
<div id="fail_message" style="display:none; color:red">Company already registered. Please choose another name.</div>
</div> <div class="viewpack"> <a href="<?php echo get_the_permalink(898); ?>" style=" padding: 1px 6px;" class="link bg-primary">View All Packages</a> </div>
</div>
</form>
</div>
<?php if(is_front_page()){?>
</h3> </h3>
<div class="text-center">
<h3 class="ih-title no-link"> Limited company formation packages</h3>
</div>
<div class="flex-container">
<div class="flex-item">
<ul class="package">
<li class="header highlight"><br>Limited by Shares</li>
<li class="gray">From £14.99</li>
<li class="highlight2"><br>UK Registration, for most Business Types</li>
<li>Same-day Registration available</li>
<li>All documents Printed, PDF & Disc</li>
<li>Registered Office London, Manchester & Liverpool</li>
<li>Director Address</li>
<li>VAT Registration</li>
<li>Domain Name</li>
<li>Bank Account</li>
<li>Business Telephone Number</li>
<li class="gray">
<button class="package_button">More Info</button>
</li>
</ul>
</div>
<div class="flex-item">
<ul class="package">
<li class="header highlight"><br>Limited by Guarantee</li>
<li class="gray">From £14.99</li>
<li class="highlight2"><br>UK Registration, for Charitable Services</li>
<li>Same-day Registration available</li>
<li>All documents Printed, PDF & Disc</li>
<li>Registered Office London, Manchester & Liverpool</li>
<li>Director Address</li>
<li>VAT Registration</li>
<li>Domain Name</li>
<li>Bank Account</li>
<li>Business Telephone Number</li>
<li class="gray">
<button class="package_button">More Info</button>
</li>
</ul>
</div>
<div class="flex-item">
<ul class="package">
<li class="header highlight">Limited Liability Partnership (LLP)</li>
<li class="gray">From £19.99</li>
<li class="highlight2"><br>UK Registration, for Solicitors, Surveyors etc.</li>
<li>Same-day Registration available</li>
<li>All documents Printed, PDF & Disc</li>
<li>Registered Office London, Manchester & Liverpool</li>
<li>Director Address</li>
<li>VAT Registration</li>
<li>Domain Name</li>
<li>Bank Account</li>
<li>Business Telephone Number</li>
<li class="gray">
<button class="package_button">More Info</button>
</li>
</ul>
</div>
<div class="flex-item">
<ul class="package">
<li class="header highlight"><br>Non-UK Residents</li>
<li class="gray">From £69.99</li>
<li class="highlight2"><br>UK Registration, for most Business Types</li>
<li>Same-day Registration available</li>
<li>All documents Printed, PDF & Disc</li>
<li>Registered Office London, Manchester & Liverpool</li>
<li>Director Address</li>
<li>VAT Registration</li>
<li>Domain Name</li>
<li>---</li>
<li><br>---</li>
<li class="gray">
<button class="package_button">More Info</button>
</li>
</ul>
</div>
<div class="flex-item">
<ul class="package">
<li class="header highlight">Scottish & Northern Ireland Company</li>
<li class="gray">From £14.99</li>
<li class="highlight2">Scottish & Northern Ireland Registration, for most Business Types</li>
<li>Same-day Registration available</li>
<li>All documents Printed, PDF & Disc</li>
<li>Registered Office Glasgow, Edinburg, Belfast</li>
<li>Director Address</li>
<li>VAT Registration</li>
<li>Domain Name</li>
<li>Bank Account</li>
<li>Business Telephone Number</li>
<li class="gray">
<button class="package_button">More Info</button>
</li>
</ul>
</div>
</div>
<?php } ?>
<?php
}
}
add_shortcode('company', 'display_form');
function display_package(){}
add_shortcode('company_package', 'display_package');
function my_ajax_function()
{
//return '1';
$company_name = strtoupper($_POST['company_name']);
//$comp_user_email = $_POST['company_usr_email'];
//$query = "SELECT * FROM wp_comp_users where =".$comp_user_email;
//$comp_user_array = $wpdb->get_row($query, ARRAY_A);
//print_r($comp_user_array);exit;
//$username = 'ste@nwdesignstudios.co.uk';
//$password = 'N6070wds1!';
$api_key = 'eG7bkh7U8Ah6CIVkjpnHQeWZb0l5SrccSWbZYSug';
//$api_key = 'YOUR_API_KEY_FOLLOWED_BY_A_COLON';
$api = new companiesHouseApi($api_key);
$response = $api->send('/search/companies', array('q' => $company_name)); // Process API request
$title_array = array();
foreach($response['items'] as $items_info)
{
$title_array[] = $items_info['title'];
};
$response_array = array();
if(in_array($company_name. ' LIMITED', $title_array)){
$response_array = array('FAILED' => 'Company is already register.');
}else if(in_array($company_name. ' LTD', $title_array)){
$response_array = array('FAILED' => 'Company is already register.');
}else if(in_array($company_name, $title_array)){
$response_array = array('FAILED' => 'Company is already register.');
}else{
$response_array = array('SUCCESS' => 'Company name is aviailble');
$wp_session['companyname'] = $company_name;
//$wp_session['companytype'] = $_POST['type'];
$_SESSION['companyname'] = $company_name;
//$_SESSION['companytype'] = $_POST['type'];
}
return die(json_encode($response_array));
}
function my_ajax_company_type(){
$wp_session['companytype'] = $_POST['company_type'];
$_SESSION['companytype'] = $_POST['company_type'];
return die(json_encode(array('SUCCESS' => 'OK')));
}
use Zend\Http\Client;
function cf_testsendrequest(){
global $wpdb;
$cid = $_POST['company_id'];
if($cid != ''){
$get_company=$wpdb->get_results("select * from cf_company_details where company_id ='".$cid."' order by company_id limit 1");
if(!empty($get_company)){
foreach($get_company as $row){
$ctype = $row->company_type;
$cname = $row->company_name;
$section_id = $row->company_section_id;
$sic = $row->company_sic;
$uid = $row->company_user_id;
$c_date = $row->company_created_date;
if($row->company_type == 'Limited By Shares'){
$created_date = date('Y-m-d');
$dir_count = 1;
$dir = '';
$cid = 47;
//company
$get_company_data=$wpdb->get_row("select * from cf_company_details where company_id ='".$cid."' order by company_id limit 1");
//register office
$package = $wpdb->get_row("SELECT * FROM cf_company_package_details where cp_company_id='".$cid."'");
$add = $wpdb->get_row("SELECT * FROM cf_registered_office_address where reg_id='".$package->cp_reg_office_id."'");
//share detail
$shares = '';
$pdetail = "SELECT * FROM cf_person_details where person_company_id='".$cid."' and person_is_director='Y'";
$cdarray = $wpdb->get_results($pdetail,ARRAY_A);
foreach($cdarray as $shareholder){
$share_query = "SELECT * FROM cf_share_details where share_id='".$shareholder['person_share_detail_id']."'";
$share_array = $wpdb->get_results($share_query, ARRAY_A);
foreach($share_array as $share){
$shares = `echo '
<StatementOfCapital>
<Capital>
<TotalAmountUnpaid>0</TotalAmountUnpaid>
<TotalNumberOfIssuedShares>1</TotalNumberOfIssuedShares>
<ShareCurrency>{$share['share_currency']}</ShareCurrency>
<TotalAggregateNominalValue>1</TotalAggregateNominalValue>
<Shares>
<ShareClass>Ordinary</ShareClass>
<PrescribedParticulars>None</PrescribedParticulars>
<NumShares>{$share['share_allot']}</NumShares>
<AggregateNominalValue>1</AggregateNominalValue>
</Shares>
</Capital>
</StatementOfCapital>'`;
}
}
//psc detail
$psc_count = 1;
$isPSCexists = false;
$psc = '';
$psc_query = "SELECT * FROM cf_psc_details where psc_company_id='".$cid."'";
$psc_array = $wpdb->get_results($psc_query, ARRAY_A);
foreach($psc_array as $psc){
$isPSCexists = true;
$noc = $wpdb->get_row("SELECT * FROM cf_nature_of_control where noc_id='".$psc['psc_noc_id']."'");
$psc = $psc.`echo '
<PSCs>
<PSC>
<PSCNotification>
<Individual>
<Forename>{$psc['psc_fname']}</Forename>
<Surname>{$psc['psc_surname']}</Surname>
<ServiceAddress>
<Address>
<Premise>{$psc['psc_add_l1']}</Premise>
<Street>{$psc['psc_add_l2']}</Street>
<PostTown>{$psc['psc_add_town']}</PostTown>
<Country>{$psc['psc_add_country']}</Country>
<Postcode>{$psc['psc_add_postcode']}</Postcode>
</Address>
</ServiceAddress>
<DOB>{$psc['psc_dob']}</DOB>
<Nationality>{$psc['psc_nationality']}</Nationality>
<CountryOfResidence></CountryOfResidence>
<ResidentialAddress>
<Address>
<Premise></Premise>
<Street></Street>
<PostTown></PostTown>
<Country></Country>
<Postcode></Postcode>
</Address>
</ResidentialAddress>
<ConsentStatement>true</ConsentStatement>
</Individual>
<NatureOfControls>
<NatureOfControl>{$noc->noc_name}</NatureOfControl>
</NatureOfControls>
</PSCNotification>
</PSC>
'`;
}
//director
$cdquery = "SELECT * FROM cf_person_details where person_company_id='".$cid."' and person_is_director='Y'";
$cdarray = $wpdb->get_results($cdquery,ARRAY_A);
foreach($cdarray as $director){
//$add_query = "SELECT * FROM cf_address_details where address_id='".$director['person_address_id']."'";
//$add_array = $wpdb->get_results($add_query, ARRAY_A);
//foreach($add_array as $add){
echo '<b>'.$director['person_name_fname'].'</b>';
$dir = $dir. `echo '
<Appointment>
<ConsentToAct>true</ConsentToAct>
<Director>
<Person>
<Forename>{$director['person_name_title']}</Forename>
<Surname>{$director['person_name_fname']}</Surname>
<ServiceAddress>
<SameAsRegisteredOffice>true</SameAsRegisteredOffice>
</ServiceAddress>
<DOB>{$director['person_dob']}</DOB>
<Nationality>British</Nationality>
<Occupation>Director</Occupation>
<CountryOfResidence>UK</CountryOfResidence>
<ResidentialAddress>
<Address>
<Premise> llll</Premise>
<Street>Meon Road</Street>
<Thoroughfare>Titchfield</Thoroughfare>
<PostTown>Fareham</PostTown>
<County>Hants</County>
<Country>GBR</Country>
<Postcode>PO14 4HW</Postcode>
</Address>
</ResidentialAddress>
</Person>
</Director>
</Appointment>'`;
//}
$dir_count = $dir_count + 1;
}
//subscriber details
$sub = '';
$subdetail = "SELECT * FROM cf_person_details where person_company_id='".$cid."' and person_is_subscriber='Y'";
$subarray = $wpdb->get_results($subdetail, ARRAY_A);
foreach($subarray as $subscriber){
$get_sub_address=$wpdb->get_row("select * from cf_address_details where address_id='".$subscriber['person_address_id']."'");
$subshare =$wpdb->get_row("SELECT * FROM cf_share_details where share_id='".$subscriber['person_share_detail_id']."'");
$sub = $sub.`echo '
<Subscribers>
<Person>
<Forename>{$subscriber['person_name_fname']}</Forename>
<Surname>{$subscriber['person_name_surname']}</Surname>
</Person>
<Address>
<Premise>{$get_sub_address->address_line1}</Premise>
<Street>{$get_sub_address->address_line2}</Street>
<PostTown>{$get_sub_address->address_town}</PostTown>
<Country>{$get_sub_address->address_country}</Country>
<Postcode>{$get_sub_address->address_postcode}</Postcode>
</Address>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Shares>
<ShareClass>Ordinary</ShareClass>
<NumShares>{$subshare->share_allot}</NumShares>
<AmountPaidDuePerShare>1</AmountPaidDuePerShare>
<AmountUnpaidPerShare>0</AmountUnpaidPerShare>
<ShareCurrency>{$subshare->share_currency}</ShareCurrency>
<ShareValue>{$subshare->share_value}</ShareValue>
</Shares>
</Subscribers>
'`;
}
//sic code
$sic_code = '';
$c2query = "SELECT * FROM cf_company_details where company_id='".$_GET['cid']."'";
$c2array = $wpdb->get_results($c2query, ARRAY_A);
foreach($c2array as $c2){
$c4query = "SELECT * FROM wp_sic_code where sic_code='".$c2['company_sic']."'";
$c4array = $wpdb->get_results($c4query, ARRAY_A);
foreach($c4array as $c4){
$sic_code = `echo'
<SICCodes>
<SICCode>{$c4['sic_code']}</SICCode>
</SICCodes>
'`;
}
}
//SubmissionNumber generator
$sno1 = generate_token1(6);
$sno = `echo '
<SubmissionNumber>{$sno1}</SubmissionNumber>
'`;
$str = <<<EOF
<?xml version="1.0"?>
<GovTalkMessage xmlns="http://www.govtalk.gov.uk/CM/envelope" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:gt="http://www.govtalk.gov.uk/schemas/govtalk/core" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.govtalk.gov.uk/CM/envelope http://xmlgw.companieshouse.gov.uk/v2-1/schema/Egov_ch-v2-0.xsd">
<EnvelopeVersion>1.0</EnvelopeVersion>
<Header>
<MessageDetails>
<Class>CompanyIncorporation</Class>
<Qualifier>request</Qualifier>
<TransactionID>345</TransactionID>
<GatewayTest>1</GatewayTest>
</MessageDetails>
<SenderDetails>
<IDAuthentication>
<SenderID>34a376ae2739227963efcafbcfde6910</SenderID>
<Authentication>
<Method>clear</Method>
<Value>342a177306fda14e346d533b967dff3d</Value>
</Authentication>
</IDAuthentication>
<EmailAddress>contact.unityinfoway@gmail.com</EmailAddress>
</SenderDetails>
</Header>
<GovTalkDetails>
<Keys />
</GovTalkDetails>
<Body>
<FormSubmission xmlns="http://xmlgw.companieshouse.gov.uk/Header" xmlns:bs="http://xmlgw.companieshouse.gov.uk" xsi:schemaLocation="http://xmlgw.companieshouse.gov.uk/Header http://xmlgw.companieshouse.gov.uk/v1-0/schema/forms/FormSubmission-v2-9.xsd">
<FormHeader>
<CompanyName>{$get_company_data->company_name}</CompanyName>
<PackageReference>1828</PackageReference>
<FormIdentifier>CompanyIncorporation</FormIdentifier>
$sno
</FormHeader>
<DateSigned>$created_date</DateSigned>
<Form>
<CompanyIncorporation xmlns="http://xmlgw.companieshouse.gov.uk" xsi:schemaLocation="http://xmlgw.companieshouse.gov.uk http://xmlgw.companieshouse.gov.uk/v1-0/schema/forms/CompanyIncorporation-v3-1.xsd">
<CompanyType>BYSHR</CompanyType>
<CountryOfIncorporation>EW</CountryOfIncorporation>
<RegisteredOfficeAddress>
<Premise>{$add->reg_line1}</Premise>
<Street>{$add->reg_line2}</Street>
<PostTown>{$add->reg_town}</PostTown>
<Country>{$add->reg_country}</Country>
<Postcode>{$add->reg_postcode}</Postcode>
</RegisteredOfficeAddress>
<Articles>BYSHRMODEL</Articles>
$dir
$psc
$shares
$sub
<Authoriser>
<Agent>
<Person>
<Forename>Harry</Forename>
<Surname>Smith</Surname>
</Person>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Address>
<Premise>The Dolphins</Premise>
<Street>Meon Road</Street>
<Thoroughfare>Titchfield</Thoroughfare>
<PostTown>Fareham</PostTown>
<County>Hants</County>
<Country>GBR</Country>
<Postcode>PO14 4HW</Postcode>
</Address>
</Agent>
</Authoriser>
<SameDay>false</SameDay>
<NameAuthorisation>false</NameAuthorisation>
$sic_code
</CompanyIncorporation>
</Form>
<Document>
<Data>
JVBERi0xLjQKMSAwIG9iago8PAovVGl0bGUgKP7/KQovQ3JlYXRvciAo/v8AdwBrAGgAdABtAGwAdABvAHAAZABmACAAMAAuADEAMgAuADMpCi9Qcm9kdWNlciAo/v8AUQB0ACAANAAuADgALgA3KQovQ3JlYXRpb25EYXRlIChEOjIwMTgwMjIyMDgyMDIyKzAxJzAwJykKPj4KZW5kb2JqCjMgMCBvYmoKPDwKL1R5cGUgL0V4dEdTdGF0ZQovU0EgdHJ1ZQovU00gMC4wMgovY2EgMS4wCi9DQSAxLjAKL0FJUyBmYWxzZQovU01hc2sgL05vbmU+PgplbmRvYmoKNCAwIG9iagpbL1BhdHRlcm4gL0RldmljZVJHQl0KZW5kb2JqCjcgMCBvYmoKPDwKL1R5cGUgL0NhdGFsb2cKL1BhZ2VzIDIgMCBSCj4+CmVuZG9iago1IDAgb2JqCjw8Ci9UeXBlIC9QYWdlCi9QYXJlbnQgMiAwIFIKL0NvbnRlbnRzIDggMCBSCi9SZXNvdXJjZXMgMTAgMCBSCi9Bbm5vdHMgMTEgMCBSCi9NZWRpYUJveCBbMCAwIDU5NSA4NDJdCj4+CmVuZG9iagoxMCAwIG9iago8PAovQ29sb3JTcGFjZSA8PAovUENTcCA0IDAgUgovQ1NwIC9EZXZpY2VSR0IKL0NTcGcgL0RldmljZUdyYXkKPj4KL0V4dEdTdGF0ZSA8PAovR1NhIDMgMCBSCj4+Ci9QYXR0ZXJuIDw8Cj4+Ci9Gb250IDw8Ci9GNiA2IDAgUgo+PgovWE9iamVjdCA8PAo+Pgo+PgplbmRvYmoKMTEgMCBvYmoKWyBdCmVuZG9iago4IDAgb2JqCjw8Ci9MZW5ndGggOSAwIFIKL0ZpbHRlciAvRmxhdGVEZWNvZGUKPj4Kc3RyZWFtCnic7Vpba9swFH73r9DzoI51sS4wBmnaDvYwCAnsYexhtHSjNGWhD/v7kyO3Vs5nWU7qlLE1hTr+kM75zkXnSCKzj6vv7Mcjmy1Wv9h1+1ysiqqsdBU+rPk7iwGuSh5emHGuVLvv7HpTbNm2WBZL/795bguud5Pbhx/wpCYIfbx+KGaBQBGQ1eKz//abCfbJv92xr9/846aV2QzYFE5JVzrndCP0Pn7lQnNd1rXkHq/oazP4Z/HlHXtoiInSVlZbKQPB/deXEN12U0tdSSd4rW3yeyyYV1qWXFRGeIe5qjRKi8bgGDeV9BYp67wxVmpVVqYSNcWNLq2xTsVy7hPyG6fcRpydbD/J7/ucTV064VQVcyCcfRSklrUh3JJ4ZEu/fMr5BH6OuKU4xPip/dwf680+fqCfY26pXJrIz4J78VobRXJDcGNKZTQ3+xwI/sw5knOfkD9ZPkccCGfvN2GV1ZRbCo9s6Zf/Cn6OuKU47OEn9nN/rDf7+KF+jrilcqnhvJy6/ouu/m8HJp6vi9mV71KWrW8ZD101PNY+WM75N8PWN+y9b6b8A1vfFbyh0yIiIKpDZEB0h6iAVB1SwywNkk1ARIfYHVJ3gINJKHgOY853iB7SvQAxoBs1wZALsHsM4Uuw+yogfEAVBgYFYxioJ3gFukEMD6ou1z5hX5xzui/nrGRnhpN0igiElLMdIKl/eDDVdUBNHMZDzE0HGApYqsbREaC3jYsaIDKnyQdTgNl5FgAtC8r9Iqvlko6AKaCFumwS84E6yMBwX9E52eiKikxBIpAQIBSJiAnXhkytDd/49isDGK6pOyPDeX8EusrBoSo4AgjRn5EDatsFCOklB4QCQGUgdUhi1R/mgSngIGAK1qLQVGYMJg/lij6D6BoKWKqGxi5ZtOQAkTltNzAFmEFGAABaIGfA8aAlUbSGbKEuA1uEpAUnmwCYM9kVMknu0riMSKER4adexhEQKdCbqtFQTgeSua3R0F8iIpDd+QUxQVXJhxtktBs0d2KXYaomEvHULUo879/q/r3JwM4DV6SiTazOArRZjyhZ2dzJyxAmuwDzbe4UpWJEdz1mUWfzfkQxOaZXTrJZOKLNTVAJ/p7iOcUCmGDDhYvIHu7U7M4AV4TLlsr8piarJb//GGFcfrsBTLNlR8wn7APJYzyvn6+O2ksWQUmPOE8NndKOOGHC/QEQoWfQ1uFDJ104k9PbAgFqYQocfeHWgp7JUSgAVAZQfwPegH8KOGFNU35fGxe1GioWXBImtgywdYEWcdDdHJSOV7nfg/Iz4lrtf6y+p+6yTj15Bm/L8/V/DkkMqUGdBSFpL02G2jsq5lQxrg1IDghsforpYvD0I5DpfgCyHY7rki2LPzsOchIKZW5kc3RyZWFtCmVuZG9iago5IDAgb2JqCjEwMzMKZW5kb2JqCjEyIDAgb2JqCjw8IC9UeXBlIC9Gb250RGVzY3JpcHRvcgovRm9udE5hbWUgL1FNQUFBQStUaW1lc05ld1JvbWFuUFNNVAovRmxhZ3MgNCAKL0ZvbnRCQm94IFstNTY4LjM1OTM3NSAtMzA2LjY0MDYyNSAyMDAwIDEwMDYuODM1OTMgXQovSXRhbGljQW5nbGUgMCAKL0FzY2VudCA4OTEuMTEzMjgxIAovRGVzY2VudCAtMjE2LjMwODU5MyAKL0NhcEhlaWdodCA4OTEuMTEzMjgxIAovU3RlbVYgNDguODI4MTI1MCAKL0ZvbnRGaWxlMiAxMyAwIFIKPj4KZW5kb2JqCjEzIDAgb2JqCjw8Ci9MZW5ndGgxIDk5NjAgCi9MZW5ndGggMTYgMCBSCi9GaWx0ZXIgL0ZsYXRlRGVjb2RlCj4+CnN0cmVhbQp4nJ15B3wb15nnPAwKCyrR+6AMWACSICq72ItIkZRIkWq2BAEgCYkkSBCURFnV9lpy71rHXq8dZ+WLJMdylDi2EzuOleIkLufb3ThO8W+di2vs5C7eZEtEDu+bNwMIkpW7+y3wm5nvlXnv//XvAQQiCKKIOEaQBDE8Whv4wBd6A3rugGt8amZ50m5a+CnQ7xOE8eB0MpZI/q7vTYIw7YK+yDR0yC7J7oT2Q9B2T89mDzyfKToM7Reh/dRMOh676c5buwjCPA3tLbOxA/NELbEH2t+DNjUXm01u+lz9GrTfI4jSIgKRYXQPISKKRA+LggSBaO5JPk5MCsqQSCAQkyKhSEAKCeLgiWME/hSxt7ENnRTRRlBrK6I7mB4UlDjQd9oItLa2hucIkIUgRBYRLEVICMKhcqhouCGLkFihyO+ttImISwQlBFCI6F97T6QQ7SWqoaFyeco9LrEEvlqNXqfXBQPRSFQPTZew3BP2QCMSDOh1UR1QwvcUrYvZx0/MzrWsa2o8sO+hm5OJg/bJk7d+m3n6+dvQjm1ffuyl+++uKjNrjFLRXib45o7tqLP71Kl/eeGWE319DdEzmm+NjqFL31756bkzO6/r0yOkMfsBO9ELiA4AIgVhB0xCvU6llIgdAEAliEb0TolYJQAIgEwlKPcIfo+KLr7y/e8znzIfvfQyeve7//Hc7K3o7tlvfPfIIXQyLdqLXv0J88/Ma6+/jn78I9SCOt74ev+JrzIvMt+4cCt68AHUgXacO8nKwUkQ4s9Fg0QdyAupgPtgUOsIB4HTsAqkAnIJOxByaF0AQK8SXzGOyJ7VP5npET9T4d9M65BaTpdvQsfQZ+h9dKx2wg28WemR2tXv+SdcutU/C5dW9h22V9E0CtsXyX1bKy1aNX3pV0KaDlGZldsuD9126XaQByATegGZiwixOspvzepGFQJogCzAakurAUWJoYPXXDiEcTsl6B9g/6HQ6neCmz1qZK4YDKI/Prsn1dc3m341UN/YFqqqsE1tGHC7OzrGQsOCG5ilY3YfTdfbs+TMUcqLaLp8y7bl/zY1jYokvaVC0cbh4xMbBjy0GtApwdKeAW3ZWZzIAcJhLQfwga1EURCxWKDFwSHhc2b1X3e4kM0SZzaPmYKt6F0XeqehtmZ09ZONVkvF3IefoR+9PeKhdAYJTSsM/vuFOy49eLKisrxcr3f4diG5wL36azD1D9Z+JzoLUqkAIweFAasukAOvHte1NWhG82SLxTNci97xj4NW3Cs3cloDHemabFSjrVE0uCIh5YeoKqyMS7cKu1ZeuqyQ8116raYYrEUNXJ+B3VmNwKbYZSToarPI2Q2HSgxmEAlzfeRb6Bcmc12worKZeQGUM+oD4wDTYe7o1Bn7tbSgy1ZbXolQKzKjkmYkU5jNEdEgDdL0+natrjJP5TGhdkF93GR0ldA0DLqvZwbQE9fVmvVauRRwugDno4Czl8Wp4uwBA+KcnAV8BWTHF3q+8A46LdgnK7X7av2CLr/f6yiRInkx5a3zr77o31RuXL0NyUsor79u9Tv+MY9BVmrz+f2C7jq/lyqVCn6Obp5yGssMgF2nsjsSKw9OUyYV2wzYb0CPMvGCJrn3iqnATdnab0RPAzespWmxxF2cjMsBnjgn4ijfJXq6j45UMOU0IyxXmlyeFkHVTrMVoVq0FbXVIGSxdoukIFQ5FUhcOiK8d5vGXqYU03SJTu8O7Fn5gFQt1lgsRikS0LA3xGXBAdgbYhJ9LeHkwgIIT3DgKt7HaBPipELzrM1MOTBrdY7llQcwz2wM6gP+zoIvNUNDjWMxlY/Eupy35w0KtAf+TkFgDuUCMx+xhZ8AprGDLzErtywMDBxcPra+t6ddAULcJJAZhy2abHrhJLP/9S+NT1548PX+lpZ0VFMmlyGI0mOPb1x64+k/XHz8y/0DSFPmQScnKbtK6fGEPDNMbJ3FuvLif1w4/f3UhFRWoS1TsuZPHF17TygC1P25DAJfFh4WBo5LgLPcycciscSlCur0V4Qo7svmF3YEZxfyHF1W4988sT3V2YV8Lb97qbfbQ6N9y99pClG74kaTTAHhwVjt3bFt5tD6PrO1ofzpp/sHaA9amP/a3oNRg7FMUQr8eE+MDPtr0Lr2kdbg4KHJSH3/+o2PzC2gYqHDrlDWoP9xX9/6Wn9Hx7a6UNBn272rqaG3Z+zevSkUAo2pFLVsPmJ9aBo0X83qxeFAThf7vSIOh6+Iw3oNa5osgQLBANZICPMummZOMeGQXS5XKMHpN4RxRNZa2ID8h59PT/b1oI2jZ5FhV3d3eqVFLZeVvJKIoeGNNzbtFiwz+4/brgjKdmpsPHtk+3U0c8MJr08quH9s9KajI8NqVidVkDO+CZgbWJ04WITBnGocKs6gsEVFokGSTyVgXrwx8zNd6CnkWyoPVdAKmbqicjPzdpFEq274MBMO+Vs6KpYufeqv9dllJQgZ3WN+ocWuNZrrKhMiwerHrposU7Hb6tSqEdO+Ta2FGKFS1rYcYZ6i9UrKniAXjtsqaObneyortAoWbw/g/SrgdVy2IZfrqhjOR1mXSvhVW6maCoRHXzazWfUVNnB+ZWdF2O0R20SDzMUxd4PVfOlP+RAplCKZJhzdjlphp0rY6TnYiYad9ORV6tOy9pnz4ygnFuEpR/bShzk9CSZnvD6lCoyj1GS8Kf5361rDQbRfwtwDilki93LZUquzU8srXxu1a0tKkV7X3AhWNLD2PjlKPkMYCTdBqMWFtRW4RpStrVhXoR2hnAP9AiUTJ7Z2dVTbdYnJvz29tB+hgwe+9XA8vnoCnVaa6gKRsfZOQdMbi9lA3QHNrfMLx4/+8tObb0QoMXWmcYs76rCjtnbgWAWVjZ88TySB4wiOFKxp5iMGnwSiuZKCkwYWtkTL2UqUS+B8BMJDfKjLDeRCoVNSTgfRSKLMFw4FN69r0U319gz2N0SdOoh/ZlMr06xudOpKheby8XA4PCgoLbFae5m6QaulVIgcvuFoaLQayUtNhgGmqdVkkMuKi+RKo9WjQBqv4LOEgtZpUV3w+gMemvZsbrqB2Tdh18tVyO3WK13Kjei2dG0bMpr7Sr3MwE6dXsGOlJW5laMwEmhDFl+U0W4zm2Vyt1sus1nG0fV/66PkUoV7HjTUtfZb8gWQkxrbBisjbHBs5IriCKt35irjKB+6BMRbR/Yg1Ng0NX30reVptK5lanI0Eoo4HCNDN8XWrUv1kefRoyfO33DkSFs7On37144cPtTc2Ganhkdu+PG996GR4R/86Y5doCMZBJrnYO8aNrNFogEuaLKWcZW0dXk1YCMpp9Fg5mDU7UZGk9vl9WnLtNV+pJE5HK2Mt9tlAKmKi5RqI+UpQVry/JtvIIfLW242u5xIXXk907/BYwb5uBEnvvhjlA3yACsOkEf/2mfkrYCpieiDnMdLgss10TAX0MTaXGzPBW/WnjibYZFqcT0aVmFB6lmj1wl673RHWna2tNoqphK/9/o2tbk9SGegPXo92rrlseXhRmuZSCgrUSql2uaFyTqr9SHviMOFkM9bP3DznNKE2tv2dgQ6W5rH3SdDQafL21hrMCGTsWZzfx+qoNp9NzM/udliA89DRbLm+lPI5XgAXddshFTc0F/jRyBtKdSM/445Yz0iUIA6WOAFnISv7L/Szgcev38gEqF08hKToYNpUreZWIHbnYP795XKsA1ruk0GSZFClTPh37+C6PLNzYeY5Qm7iTVDjdojH0H7DzVG0Y2M9Tqdle10O5No7LTbJZdxltm59lvIsHcRHiJ6WRNRTuLhAkCq3KFNL3Llal5nXvCvdq1r7z81v4DQ4UPfPzAiKVKq9CavDKmqiyQqhd5cXcr87xqxzVYXrNnatQOBNma2TfVaKXTk0I9+cPoraPDMoywkpWv+0rtPOGmZXOVa+Al6p7MharMMp159bc8MK1sBxLlV8gE49xLoCjy8PQPw/HlKxbsSF1bCZBwDsZfLmT9U729p7R6KNkAORTK52dqL2qu9bVX1kQGLdRv5wOrPHucRXDzmcPh8vd3H0UNtJqNcRq8+cqyiEplNGwRFQ2aLh80uw6Dvg6I7rnF+YtNKOMgXULrLXpcvVsDCg1r0JGTr1tHVdysrHBAuLlzwQd2xML21EbzOpjeaaI+NomvtDpn8M3Jw9cljTh+rWJdzt2BbX/PJXdc3N6LOmqjdaFYp6sMatcEUCP+so49Fllh7X/AzsMTGfN5z8icorozgIwBXMhUWTCzkYK4uFNzjKG9s2d5b5UOUfed9P0XX71wam3Fo9RAHzCPDu7t9Xn/gnvt81UODhyIbgiplcbGUPM/8+P5wCNEeX31FZU1v/InDgxtsJciIeu/s6a2saOiurenvbWqYmN8wiHQKOPkZ2DwN2l0PeOHUhXhR5ZBoNQWi4+MkRkeu9+ydvfHRxezxo8+emJgwmLxNtjKhxOluSTZv3Dh8W2w4EkY7vrVr9003vvfOiROop3+wXGfwaJsaKRvqjz9++tAR1FV9EPwA6i+BBPxAQXgvR+gcBvVVQbLQVVFllc0CFb+tqspms1mO4hTTznR26nUKPsWUy5FGdFduCnu3MM5VatxiYz0SQbqwjqPYA9V2Ll2ALDRrfxQ0C1/hapag1pW35mDeiFjrwik3ita//bbJUElBNV3uamvvrIVYrb030tRQrasSvsL8U8/q01vtFNKqK3fXBUxGf01CMO3QhUN99CQwvfafzHry2yD3aqINbJkOanPpW8OX1gVhSnc5fLGKEOW9EB8+WasWIJOnp79n5LYd8+jkwpn1kco6aYnNMsBQxmi5urQESYqVZTYDjULFsvrIaKJ1I9rePlFXQ5MNmbcPBPwzf/NPf3j4GNIqqplPdhpMCgUNGaTEpE+Su7cYDVIot44yZ+edTV7f0OQL/7gwZChj5SVlusk/QWSAmlTNn2A0erUaF8fcqYY/Rou5nzFwSgnwRhTlD3pSdE5brdM7/uUNJYtS5UVVHrXGUGxkbo9MbB1phhOA1ex3NJSX2txOup15TuEwKfRB8gFarbWUdzMB9JeKyrLikiI46IlKpQ75upW5W+CI4XL6qkxGsHPKvvUxwTdstU6ZUkpwmZn8V7C5DlbLBUXTF9IF55g4W+eLpi8a4oZ0e1vHUH3UopaXGPTtTKt2HSQNUqFyuGoDoUg/FETmXqaxxaWWSXHi0NXIUZnortXdy26n17e9/Qzz4ha7kU8dyiHUdaq2xqiDGtw0zFhyNQ/SFFst42RLLmCDBV0Cz30B+DBh3+FKjJzHFiY1lYqPKrkUj5pufuTOVOqJO86ObBrbjLOGtVKO1NWB+kjDtpGhoZF4JFQp+Lfn0YGDb/35gWNWSxP57N/xG69WrP46YDRBJfvy+V3XmzVYomvvi77JZQg11jk2g4Jj/GWz4IwCuUj+oC9Dx8JKleoHPwwZyvVN6Jt9Nk3RW6+okVrTgBxbKpg3Kz9g/kwzv7RarE2gcpFcYaG8q39EXzvZrJeh8nKkUzk1WuhYiVBqhcJDy6dXPhX0rz5HCvqh2mTR+UDf50TTuAaE4wHBh1x8cC1wOolA4uBKYvLczpX30K577xkemU0ObYRT6fTUI6fTs8i//sm/tKDdMz6vy2lGIuYSjTpef+3s8dFNqLF5/vlEfM/eu6cnn3iW+V/RIonJUM3VXB+Rz8HuavacosY/uLKaUmPPYJ0iquQdIpJXGoysR7092W27Hjn8MEKdXam9sYvH537Y3bAQbmq01fjdDZWN3aF+o0nw9x9/9cnRNvTYD5nzn51+Eo74H77y78xHzzyIAv7MOdT48SOLfkfL6IVvAJKJtY/JrwMSO/vLB+JdUyzBAsgZDg8QolvhrxR8FiNP/c2msY2joYj77vtun5ycOvzaHbteRmh93623HD60d/X1MrezN7B+orsTIHcf8nh9omla7qkc2RhPnozPL5w/d/vZHReQ7dnTXzl21OdFq10nN+2aX+ioRaObHjp3+BBSqgiSaGF6yF9BXOwmxolpwMn/jAAyC+Z/egCsLpwpIFCK+eyqi17+xfRyVevhKn2Uy158vnWRYu7njHyHGIXHqqvRdPLLN8YuVhVJSDESkpIi7/4oQrHdp7t7fOCGKqXfvPBG63X10T2P/uXizQOlyohkZ1ijhwCFdAN1ga7QyECgrjs0/HytwYCaEi99c3xzMPyl36ChioH+rSd3x1AbQqS4RGcqEZFk3/yx7TuQpsJi1aqUKokIFcvr6zctxu+fqIsaDHRHcdxm0lNOf43gJJjX8t9PdDQ0HHxsW8fK8ZDXR/vdre1t/WG9DhHciVAohVjQysY0zHnocgCWqHUFZz5gF/2Vs56YjWfDn/TLJEhZRqO7RsP1bZ9+GnP53cZWppNWyCqYj5BcqtcNMTU9Lm2pAsczbZUKKUV3rcy/3amWSsEJHQ4o/xt/yfz8BodfVgrBq7RYowuhaea/b7VYS6Vut6rE4NhIdjzmdipkiA1mwEELOIsCODDzFd1fy/s3AACTsY9Zt06vk8skRXIoeStANaK7LrWPW6xQX/OpnWx7mHZysRIR9669j9LERagzCPqqKgMRNXCuRnZHDdR7DvvFPFUL/ex/L4i79ry78O5ORfOf+T9srvisfcB0iz8H9IgQ5zvhHYmD6SYmlMTaXWsW8ed4pcKPV9yALKJxYr3oVaJPYiWcwkXCCbRS9OraB/BUC2ASPF1wlQnOEkF2Hsw5Bu+4hL8lquDqgauSvJMYFDcQKiFBdMM8GbT7gZbC1QWXAPqGSSuRgP4eQQPRDJdGSKz9Jz9HBvQlWBuehA+u9XBtgasFLhXMbQEc9wIULXE98SXiQxRGC+gZgRC+ewVnBL8iI+STQkK4RXin8Ccisehh0Ttip/hu8UeSFskJyT8X+Yr2Fl0o+rh4ffHpkuKSoZJHS35d6ijNShXSeelj0pewVLxEiv3/jpf21Z9GwXcJgh/fg+8knmnDLZYWEHKUo0kig+p5WlgwR0QY0FmeFhNOdJGnJcSb+TlFhJ94mqeLiVvQ+zwtEzws2JPHFhYJeRoRClEDTwsIiegFniaJBtHjPC0smCMipKJf8LSYUIk+4GkJMZWfU0QYRNt5upjoFP0bT8vQBtAxSUBggr2kklswLWL/sZGcwrQY9z+JaQnuv4DpIkxfxHQxL0OO5mTI0ZwMOZqTIUcLC+ZwMuRoToYczcmQozkZcjQnQ47mZMjSJQX4SzG2f8S0tKBfjun/iWkli03yOabZf6jKijj8moL5WrwOR+sK+o3su0VlmDbjOdya1oI59gLajedTmK7CdA2mqzHdzNJFBfiLCvaSFvRLc7ycISgiABLxExGgxiCnJeG5gUgTc3BliWViHvd0QisDNHuPQX8Kz6iBkXZiBr4UsQn6puD9LLGIW0l4JmH2PrgnYOYYjM/iXooYgud+PCsNfTFYiYJRdiQGVxbvkYA57FiG2At9aWLyv4CPXXUOr8i9txlaKWixiChiFKgYbnE7z0FvLV6BwmtPY/wUEYfWEoyyuFJ4ds0XEDT+P/ljJTIF68xgnhqhfmBXX8wjDcKqfiIMVAWsnoJdMzCyiDnPQnV27fmRgn25XS/vOQIcboDxL0prLE91YXntx3KagvYw7DaJd2dHq/NSmgPcSXiLk30Ga4td1Qc943h+lpfcIOaP1R4rMYqog/NXEGxsK5YihbGx6yxh++B0w+l+Eq+Yxbpg2/OY41mssZzOduN3c/rsBo0OggVy72YKRuax9BKwSxyvyNnBfrxXHO7X3pdrs3PjwO8S5iKB56bhnsDj81iDy3mL4fZK8SvE+bU47ln/oL7AeRpLcxlrOgWapbCl787vdS1cc19Y+/9fSpdXT+T1nMEWw1l0PO8v1+b+sg9diaupQAYsJxwvWbxfzhPZ9TleE9CzH3Oext59bU45SceukGqS98ir/ZKVahbmLeE3WbT78pbLrcPOnIEZ/1cdnaECfn+EGptOUhvSc+ns8nyS6kxn5tOZWDaVnquh2mdmqE2pqensIrUpuZjM7EsmasZSs8lFaii5n9qUno3NUalFKkZlM7FEcjaW2UulJ//qelRqjsrC2Oa5VDaZoEazsSysFJtL1KYzVBpGMlQ8vTSXzaSSizW5BRqv3m9TcmppJpZpHE9mFtlFgzX+MFWxIRXPpBfTk9nKgv4IfhdexW+OjG4Yy8MaY29dmdj+1NwUNTw5mYonqWoW0txMchnQZ1KL6TkfNZ6KZwHcYCyTSM5lqbqGYGBreomajS1TS4tJ4Aa4n0zDSGyRmk9mZlNZlrPdy5jP7s2D7TCawY35TDqxFM+yMtg/nYpPF7wLz9RcfGYpAa9m01QitTg/AxuAYOCtFEyIwyzYvoaicpun52aWqYpUJZWc3c2+dXmtudzsa0LC0xMsz5nkIgg6zuqlYHusIX6tJoygIgW7ZJOzrBIzKdg1kd4/N5OOFW4KoGMcVFBhXpfppez8UpZKJPexwoU508mZ+as4gsidxj4cA2udA29Jsx6MZGChe6D9CY7eufFcPE5wcZZ8mPw6+RL5MlwvkN8mnypYi52dyrd/g9dOXrFX8orV8HpCm7BOOCDsFbbAvQFmx8CrWH/lMsg0egZ9GUpONoq0w/wMnxlj/wei8wLHCmVuZHN0cmVhbQplbmRvYmoKMTYgMCBvYmoKNjQ3NQplbmRvYmoKMTQgMCBvYmoKPDwgL1R5cGUgL0ZvbnQKL1N1YnR5cGUgL0NJREZvbnRUeXBlMgovQmFzZUZvbnQgL1RpbWVzTmV3Um9tYW5QU01UCi9DSURTeXN0ZW1JbmZvIDw8IC9SZWdpc3RyeSAoQWRvYmUpIC9PcmRlcmluZyAoSWRlbnRpdHkpIC9TdXBwbGVtZW50IDAgPj4KL0ZvbnREZXNjcmlwdG9yIDEyIDAgUgovQ0lEVG9HSURNYXAgL0lkZW50aXR5Ci9XIFswIFs3NzIgNjYyIDcxNiA4ODIgNTUyIDcxNiA3MTYgNzE2IDI0OCA3MTYgNzE2IDMzMCA3MTYgNTUyIDY2MiA2MDYgNjA2IDYwNiA0NDAgNzcyIDQ5NiAzMzAgNDQwIDQ5NiA0OTYgNDk2IDMzMCAzODYgNDQwIDI3NiAyNzYgNDk2IDQ5NiA0OTYgNDk2IDcxNiA0OTYgNDk2IDQ5NiA0OTYgNDk2IDI3NiAyNDggXQpdCj4+CmVuZG9iagoxNSAwIG9iago8PCAvTGVuZ3RoIDY1OCA+PgpzdHJlYW0KL0NJREluaXQgL1Byb2NTZXQgZmluZHJlc291cmNlIGJlZ2luCjEyIGRpY3QgYmVnaW4KYmVnaW5jbWFwCi9DSURTeXN0ZW1JbmZvIDw8IC9SZWdpc3RyeSAoQWRvYmUpIC9PcmRlcmluZyAoVUNTKSAvU3VwcGxlbWVudCAwID4+IGRlZgovQ01hcE5hbWUgL0Fkb2JlLUlkZW50aXR5LVVDUyBkZWYKL0NNYXBUeXBlIDIgZGVmCjEgYmVnaW5jb2Rlc3BhY2VyYW5nZQo8MDAwMD4gPEZGRkY+CmVuZGNvZGVzcGFjZXJhbmdlCjIgYmVnaW5iZnJhbmdlCjwwMDAwPiA8MDAwMD4gPDAwMDA+CjwwMDAxPiA8MDAyQT4gWzwwMDQzPiA8MDA0Rj4gPDAwNEQ+IDwwMDUwPiA8MDA0MT4gPDAwNEU+IDwwMDU5PiA8MDAyMD4gPDAwNDg+IDwwMDU2PiA8MDA0OT4gPDAwNDc+IDwwMDUzPiA8MDA1Mj4gPDAwNDU+IDwwMDU0PiA8MDA0Qz4gPDAwNjU+IDwwMDZEPiA8MDA2Rj4gPDAwNzI+IDwwMDYxPiA8MDA2RT4gPDAwNjQ+IDwwMDc1PiA8MDA2Nj4gPDAwNzM+IDwwMDYzPiA8MDA2OT4gPDAwNzQ+IDwwMDcwPiA8MDA3OT4gPDAwNjg+IDwwMDYyPiA8MDA3Nz4gPDAwMzI+IDwwMDMwPiA8MDAzNj4gPDAwNjc+IDwwMDZCPiA8MDA2Qz4gPDAwMkU+IF0KZW5kYmZyYW5nZQplbmRjbWFwCkNNYXBOYW1lIGN1cnJlbnRkaWN0IC9DTWFwIGRlZmluZXJlc291cmNlIHBvcAplbmQKZW5kCgplbmRzdHJlYW0KZW5kb2JqCjYgMCBvYmoKPDwgL1R5cGUgL0ZvbnQKL1N1YnR5cGUgL1R5cGUwCi9CYXNlRm9udCAvVGltZXNOZXdSb21hblBTTVQKL0VuY29kaW5nIC9JZGVudGl0eS1ICi9EZXNjZW5kYW50Rm9udHMgWzE0IDAgUl0KL1RvVW5pY29kZSAxNSAwIFI+PgplbmRvYmoKMiAwIG9iago8PAovVHlwZSAvUGFnZXMKL0tpZHMgClsKNSAwIFIKXQovQ291bnQgMQovUHJvY1NldCBbL1BERiAvVGV4dCAvSW1hZ2VCIC9JbWFnZUNdCj4+CmVuZG9iagp4cmVmCjAgMTcKMDAwMDAwMDAwMCA2NTUzNSBmIAowMDAwMDAwMDA5IDAwMDAwIG4gCjAwMDAwMDk4NjcgMDAwMDAgbiAKMDAwMDAwMDE2MyAwMDAwMCBuIAowMDAwMDAwMjU4IDAwMDAwIG4gCjAwMDAwMDAzNDQgMDAwMDAgbiAKMDAwMDAwOTcyNCAwMDAwMCBuIAowMDAwMDAwMjk1IDAwMDAwIG4gCjAwMDAwMDA2NTAgMDAwMDAgbiAKMDAwMDAwMTc1NyAwMDAwMCBuIAowMDAwMDAwNDY0IDAwMDAwIG4gCjAwMDAwMDA2MzAgMDAwMDAgbiAKMDAwMDAwMTc3NyAwMDAwMCBuIAowMDAwMDAyMDM4IDAwMDAwIG4gCjAwMDAwMDg2MjUgMDAwMDAgbiAKMDAwMDAwOTAxNCAwMDAwMCBuIAowMDAwMDA4NjA0IDAwMDAwIG4gCnRyYWlsZXIKPDwKL1NpemUgMTcKL0luZm8gMSAwIFIKL1Jvb3QgNyAwIFIKPj4Kc3RhcnR4cmVmCjk5NjUKJSVFT0YKJUJlZ2luRXhpZlRvb2xVcGRhdGUKMSAwIG9iago8PAovVGl0bGUgKP7/KQovQ3JlYXRvciAocGhwdG9QREYuY29tKQovUHJvZHVjZXIgKHBocHRvUERGLmNvbSkKL0NyZWF0aW9uRGF0ZSAoRDoyMDE4MDIyMjA4MjAyMiswMScwMCcpCj4+CmVuZG9iagoxNyAwIG9iago8PAovVHlwZSAvTWV0YWRhdGEKL1N1YnR5cGUgL1hNTAovTGVuZ3RoIDI5ODYKPj4Kc3RyZWFtDQo8P3hwYWNrZXQgYmVnaW49J++7vycgaWQ9J1c1TTBNcENlaGlIenJlU3pOVGN6a2M5ZCc/Pgo8eDp4bXBtZXRhIHhtbG5zOng9J2Fkb2JlOm5zOm1ldGEvJyB4OnhtcHRrPSdJbWFnZTo6RXhpZlRvb2wgOS45OCc+CjxyZGY6UkRGIHhtbG5zOnJkZj0naHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyc+CgogPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9JycKICB4bWxuczpkYz0naHR0cDovL3B1cmwub3JnL2RjL2VsZW1lbnRzLzEuMS8nPgogIDxkYzpjcmVhdG9yPgogICA8cmRmOlNlcT4KICAgIDxyZGY6bGk+cGhwdG9QREYuY29tPC9yZGY6bGk+CiAgIDwvcmRmOlNlcT4KICA8L2RjOmNyZWF0b3I+CiA8L3JkZjpEZXNjcmlwdGlvbj4KCiA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0nJwogIHhtbG5zOnBkZj0naHR0cDovL25zLmFkb2JlLmNvbS9wZGYvMS4zLyc+CiAgPHBkZjpQcm9kdWNlcj5waHB0b1BERi5jb208L3BkZjpQcm9kdWNlcj4KIDwvcmRmOkRlc2NyaXB0aW9uPgo8L3JkZjpSREY+CjwveDp4bXBtZXRhPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAo8P3hwYWNrZXQgZW5kPSd3Jz8+CmVuZHN0cmVhbQplbmRvYmoKNyAwIG9iago8PAovVHlwZSAvQ2F0YWxvZwovUGFnZXMgMiAwIFIKL01ldGFkYXRhIDE3IDAgUgo+PgplbmRvYmoKeHJlZgowIDIKMDAwMDAwMDAwMCA2NTUzNSBmIAowMDAwMDEwNDA0IDAwMDAwIG4gCjcgMQowMDAwMDEzNTk2IDAwMDAwIG4gCjE3IDEKMDAwMDAxMDUyNiAwMDAwMCBuIAp0cmFpbGVyCjw8Ci9TaXplIDE4Ci9JbmZvIDEgMCBSCi9Sb290IDcgMCBSCi9QcmV2IDk5NjUKPj4KJUVuZEV4aWZUb29sVXBkYXRlIDEwMzgzCnN0YXJ0eHJlZgoxMzY2MgolJUVPRgo=
</Data>
<Date>$created_date</Date>
<Filename>html_01_2.pdf</Filename>
<ContentType>application/vnd.hp-pcl</ContentType>
<Category>MEMARTS</Category>
</Document>
</FormSubmission>
</Body>
</GovTalkMessage>
EOF;
set_include_path('.;' . realpath(dirname(__FILE__) . '/Zend'));
require_once 'Zend/Loader.php';
require_once('Zend/Loader/Autoloader.php');
$autoloader = Zend_Loader_Autoloader::getInstance();
//require_once 'Zend/Application.php';
$config = array(
'adapter' => 'Zend_Http_Client_Adapter_Curl',
'curloptions' => array(CURLOPT_FOLLOWLOCATION => true ,
CURLOPT_HTTPHEADER => array('Content-Type:text/xml'),
CURLOPT_POST => true,
CURLOPT_RETURNTRANSFER => true,
),
'method'=> 'POST'
);
$api_key='eG7bkh7U8Ah6CIVkjpnHQeWZb0l5SrccSWbZYSug';
$url='https://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway';
//use Zend\Http\Client;
$config2 = array(
'adapter' => 'Zend_Http_Client_Adapter_Curl',
'curloptions' => array(CURLOPT_FOLLOWLOCATION => true),
);
$client = new Zend_Http_Client($url, $config2);
$client->setRawData($str, 'text/xml');
$client->setAuth('eG7bkh7U8Ah6CIVkjpnHQeWZb0l5SrccSWbZYSug', '');
$response = $client->request('POST');
//echo $response;
/*
echo "<br>Http status -".$response->getStatus();
echo "<br>Message -".$response->getMessage();
echo "<br>Body -".$response->getBody();
echo "<br>RawBody -".$response->getRawBody();
echo "<br>Header -".$response->getHeaders();
*/
//store data in database here
$response_company_array = array('SUCCESS' => 'Success','status' => $response->getStatus(),'message' => $response->getMessage(),'Header' => $response->getHeaders(),'sno' =>$sno1);
return die(json_encode($response_company_array));
}else if ($row->company_type == 'LLP'){
$response_company_array = array('SUCCESS' => 'Success','sno' =>$sno1);
return die(json_encode($response_company_array));
}else if ($row->company_type == 'Limited By Guarantee'){
$response_company_array = array('SUCCESS' => 'Success','ctype' =>$row->company_type);
return die(json_encode($response_company_array));
}
}
}
}
}
//Submission Number for xml
function generate_token($length){
//edit the token allowed characters
$key = '';
$keys = array_merge(range(0,9), range('a','z'));
for ($i=0; $i < $length; $i++) {
$key .=$keys[array_rand($keys)];
}
return $key;
}
function my_ajax_director_function()
{/*
$prent_id = "66664004000";
$md5_present_id = md5($prent_id);
$auth_val = "DWJ7CL674CV";
$md5_authi_val = md5($auth_val);
$xml = <<<XML
<?xml version='1.0'?>
<GovTalkMessage xmlns="http://www.govtalk.gov.uk/CM/envelope" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:gt="http://www.govtalk.gov.uk/schemas/govtalk/core" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway">
<EnvelopeVersion>1.0</EnvelopeVersion>
<Header>
<MessageDetails>
<Class>CompanyIncorporation</Class>
<Qualifier>request</Qualifier>
<TransactionID>123456</TransactionID>
<GatewayTest>0012</GatewayTest>
</MessageDetails>
<SenderDetails>
<IDAuthentication>
<SenderID>$md5_present_id</SenderID>
<Authentication>
<Method>clear</Method>
<Value>$md5_present_id</Value>
</Authentication>
</IDAuthentication>
</SenderDetails>
</Header>
<Body>
<FormSubmission xmlns="http://xmlgw.companieshouse.gov.uk/Header" xmlns:bs="http://xmlgw.companieshouse.gov.uk" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://xmlgw.companieshouse.gov.uk/v1-0/xmlgw/Gateway">
<FormHeader>
<CompanyName>iUnity</CompanyName>
<FormIdentifier>CompanyIncorporation</FormIdentifier>
<SubmissionNumber>INCb05</SubmissionNumber>
</FormHeader>
<DateSigned>2016-02-12</DateSigned>
<Form>
<CompanyIncorporation xmlns="http://xmlgw.companieshouse.gov.uk" xsi:schemaLocation="http://xmlgw.companieshouse.gov.uk http://xmlgw.companieshouse.gov.uk/v1-0/schema/forms/CompanyIncorporation-v3-1.xsd">
<CompanyType>BYSHR</CompanyType>
<RegistersHeldOnPublicRecord>
<Directors>true</Directors>
<DirectorsURA>false</DirectorsURA>
<Secretaries>true</Secretaries>
<PSC>
<StateNoObjection>true</StateNoObjection>
</PSC>
</RegistersHeldOnPublicRecord>
<CountryOfIncorporation>EW</CountryOfIncorporation>
<RegisteredOfficeAddress>
<Premise>The Dolphins</Premise>
<Street>Meon Road</Street>
<Thoroughfare>Titchfield</Thoroughfare>
<PostTown>Fareham</PostTown>
<County>Hants</County>
<Country>GBR</Country>
<Postcode>PO14 4HW</Postcode>
</RegisteredOfficeAddress>
<Articles>BYSHRMODEL</Articles>
<Appointment>
<ConsentToAct>true</ConsentToAct>
<Director>
<Person>
<Forename>Fred</Forename>
<Surname>Jones</Surname>
<ServiceAddress>
<SameAsRegisteredOffice>true</SameAsRegisteredOffice>
</ServiceAddress>
<DOB>1992-01-01</DOB>
<Nationality>British</Nationality>
<Occupation>Director</Occupation>
<CountryOfResidence>UK</CountryOfResidence>
<ResidentialAddress>
<Address>
<Premise>1</Premise>
<Street>High Street</Street>
<PostTown>Anywhere</PostTown>
<Country>GB-WLS</Country>
<Postcode>AB1 1XY</Postcode>
</Address>
</ResidentialAddress>
</Person>
</Director>
</Appointment>
<Appointment>
<ConsentToAct>true</ConsentToAct>
<Director>
<Corporate>
<CorporateName>Rapture Ltd</CorporateName>
<Address>
<Premise>1</Premise>
<Street>High Street</Street>
<PostTown>Anywhere</PostTown>
<Country>GB-WLS</Country>
<Postcode>AB1 1XY</Postcode>
</Address>
<CompanyIdentification>
<EEA>
<PlaceRegistered>GBR</PlaceRegistered>
<RegistrationNumber>12345678</RegistrationNumber>
</EEA>
</CompanyIdentification>
</Corporate>
</Director>
</Appointment>
<Appointment>
<ConsentToAct>true</ConsentToAct>
<Secretary>
<Person>
<Forename>Harry</Forename>
<Surname>Smith</Surname>
<ServiceAddress>
<Address>
<Premise>1</Premise>
<Street>No Street</Street>
<PostTown>Nowhere</PostTown>
<Country>CAN</Country>
</Address>
</ServiceAddress>
</Person>
</Secretary>
</Appointment>
<PSCs>
<PSC>
<PSCNotification>
<Individual>
<Forename>Eric</Forename>
<Surname>Simpson</Surname>
<ServiceAddress>
<SameAsRegisteredOffice>true</SameAsRegisteredOffice>
</ServiceAddress>
<DOB>1900-01-01</DOB>
<Nationality>British</Nationality>
<CountryOfResidence>UK</CountryOfResidence>
<ResidentialAddress>
<Address>
<Premise>742</Premise>
<Street>Long Street</Street>
<PostTown>Springfield</PostTown>
<Country>GB-WLS</Country>
<Postcode>QP12 0NN</Postcode>
</Address>
</ResidentialAddress>
<ConsentStatement>true</ConsentStatement>
</Individual>
<NatureOfControls>
<NatureOfControl>OWNERSHIPOFSHARES_25TO50PERCENT</NatureOfControl>
</NatureOfControls>
</PSCNotification>
</PSC>
<PSC>
<PSCNotification>
<Individual>
<Forename>John</Forename>
<Surname>Flanders</Surname>
<ServiceAddress>
<SameAsRegisteredOffice>true</SameAsRegisteredOffice>
</ServiceAddress>
<DOB>1985-01-02</DOB>
<Nationality>British</Nationality>
<CountryOfResidence>UK</CountryOfResidence>
<ResidentialAddress>
<Address>
<Premise>744</Premise>
<Street>Long Street</Street>
<PostTown>Springfield</PostTown>
<Country>GB-ENG</Country>
<Postcode>QP12 0NN</Postcode>
</Address>
</ResidentialAddress>
<ConsentStatement>true</ConsentStatement>
</Individual>
<NatureOfControls>
<NatureOfControl>OWNERSHIPOFSHARES_50TO75PERCENT</NatureOfControl>
</NatureOfControls>
</PSCNotification>
</PSC>
</PSCs>
<StatementOfCapital>
<Capital>
<TotalAmountUnpaid>10</TotalAmountUnpaid>
<TotalNumberOfIssuedShares>100</TotalNumberOfIssuedShares>
<ShareCurrency>GBP</ShareCurrency>
<TotalAggregateNominalValue>100</TotalAggregateNominalValue>
<Shares>
<ShareClass>Ordinary</ShareClass>
<PrescribedParticulars>None</PrescribedParticulars>
<NumShares>100</NumShares>
<AggregateNominalValue>100</AggregateNominalValue>
</Shares>
</Capital>
</StatementOfCapital>
<Subscribers>
<Person>
<Forename>Fred</Forename>
<Surname>Jones</Surname>
</Person>
<Address>
<Premise>1</Premise>
<Street>Fred Street</Street>
<PostTown>Fred Town</PostTown>
<Country>GBR</Country>
<Postcode>AB12 0NN</Postcode>
</Address>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>SCO</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>TEL</PersonalAttribute>
<PersonalData>012</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>MUM</PersonalAttribute>
<PersonalData>IVY</PersonalData>
</Authentication>
<Shares>
<ShareClass>Ordinary</ShareClass>
<NumShares>100</NumShares>
<AmountPaidDuePerShare>0.99</AmountPaidDuePerShare>
<AmountUnpaidPerShare>0.01</AmountUnpaidPerShare>
<ShareCurrency>GBP</ShareCurrency>
<ShareValue>1</ShareValue>
</Shares>
</Subscribers>
<Authoriser>
<Agent>
<Corporate>
<Forename>Fred</Forename>
<Surname>Jones</Surname>
<CorporateName>Jones and Co</CorporateName>
</Corporate>
<Authentication>
<PersonalAttribute>BIRTOWN</PersonalAttribute>
<PersonalData>CAR</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>TEL</PersonalAttribute>
<PersonalData>012</PersonalData>
</Authentication>
<Authentication>
<PersonalAttribute>PASSNO</PersonalAttribute>
<PersonalData>321</PersonalData>
</Authentication>
<Address>
<Premise>1</Premise>
<Street>MOO STREET</Street>
<PostTown>Cardiff</PostTown>
<Country>GB-WLS</Country>
</Address>
</Agent>
</Authoriser>
<SameDay>false</SameDay>
<RejectReference>XYZ12345</RejectReference>
<SICCodes>
<SICCode>71129</SICCode>
</SICCodes>
</CompanyIncorporation>
</Form>
</FormSubmission>
</Body>
</GovTalkMessage>
XML;
Header('Content-type: text/xml');
$api_key = 'eG7bkh7U8Ah6CIVkjpnHQeWZb0l5SrccSWbZYSug';
$url = 'https://api.companieshouse.gov.uk';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_USERPWD, $api_key . ':');
curl_setopt($ch, CURLOPT_POSTFIELDS,$xml);
$result = curl_exec($ch);
curl_close($ch);
$array_data = json_decode(json_encode(simplexml_load_string($result)), true);
print_r('<pre>');
print_r($array_data);
print_r('</pre>');
exit;
if(!session_id())
{
session_start();
$com_detail_array = array_filter($_POST);
$_SESSION['company_info_sess'][] = $com_detail_array;
print_r($_SESSION);exit;
}
*/}
function my_ajax_email_submit_function()
{
global $wpdb;
$comp_user_email = $_POST['user_email'];
$comp_company_name = $_POST['comp_name'];
$created_date = date('Y-m-d H:i:s');
if($_POST['typetoaction'] == 'insertintopayment'){
$direct=str_replace('undefined|undefined','',$_POST['direct_service']);
$directprice=str_replace('undefined|undefined','',$_POST['direct_service_price']);
$comp_user_array = array(
'pid' => $_POST['pid'],
'email' => $comp_user_email,
'sic' =>$_POST['sic'],
'siccode' =>$_POST['sic_code'],
'comapnyname' => $comp_company_name,
'companytype'=>trim($_POST['company_type']),
'register_services' =>$_POST['register_services'],
'register_services_price' => $_POST['register_services_price'],
'mail_service' =>$_POST['mail_service'],
'mail_service_price' => $_POST['mail_service_price'],
'direct_service' =>$direct,
'direct_service_price' => $directprice,
'extra_service'=>$_POST['extra'],
'status'=>'pending',
'totalamount'=>$_POST['totalamt'],
'date' => $created_date
);
//for change table
$wpdb->insert($wpdb->prefix.'package_payment', $comp_user_array);
$id=$wpdb->insert_id;
$response_email_array = array('SUCCESS' => 'Success','id'=>$id);
}else{
//$query = "SELECT * FROM wp_comp_users where comp_user_email = '".$comp_user_email."'";
if(get_current_user_id() > 0){
$user_info = get_userdata(get_current_user_id());
if ( $user_info->user_email == $comp_user_email) {
$response_email_array = array('SUCCESS' => 'Success');
}else{
if ( email_exists($comp_user_email) == false ) {
$response_email_array = array('SUCCESS' => 'Success');
}else{
$response_email_array = array('FAIL' => 'Fail');
}
}
}else{
if ( email_exists($comp_user_email) == false ) {
$response_email_array = array('SUCCESS' => 'Success');
}else{
$response_email_array = array('FAIL' => 'Fail');
}
}
$_SESSION['useremail']=$_POST['user_email'];
$_SESSION['c_sic']=$_POST['sic'];
$_SESSION['sic_code']=$_POST['sic_code'];
}
return die(json_encode($response_email_array));
}
function my_ajax_sic_code()
{
global $wpdb;
$sic_text = $_POST['sic_val'];
if($sic_text != ''){
$sic_query = "SELECT * FROM wp_sic_code where sid ='".$sic_text."'";
$sic_code_array = $wpdb->get_results($sic_query, ARRAY_A);
//$comp_user_array = $wpdb->get_row($sic_query, ARRAY_N);
return die(json_encode($sic_code_array));
//echo json_encode($sic_code_array);
//print_r($sic_code_array);exit;
}
}
//new code
function cf_address_select(){
global $wpdb;
$company_id = $_POST['company_id'];
$address_type = $_POST['address_type'];
$address = array('country' => '0');
$get_company_data=$wpdb->get_row("select * from cf_company_details where company_id ='".$company_id."' order by company_id limit 1");
if($address_type == 'contact'){
//$cdquery = "SELECT * FROM cf_person_details where person_company_id='".$company_id."' and person_is_contact='Y'";
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$company_id."' and person_is_contact='Y' order by person_company_id limit 1");
$add =$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_address_id."'");
$address = array('line1' =>$add->address_line1,
'line2' => $add->address_line2,
'town' => $add->address_town,
'city' => $add->address_city,
'postcode' => $add->address_postcode,
'country' => $add->address_country,
'price' => 0
);
}else if($address_type == 'service'){
$get_package_detail = $wpdb->get_row("select * from cf_company_package_details where cp_company_id ='".$company_id."' order by cp_company_id limit 1");
$get_reg_add=$wpdb->get_row("select * from cf_registered_office_address where reg_id ='".$get_package_detail->cp_reg_office_id."' order by reg_id limit 1");
$address = array('line1' =>$get_reg_add->reg_line1,
'line2' => $get_reg_add->reg_line2,
'town' => $get_reg_add->reg_town,
'city' => $get_reg_add->reg_city,
'postcode' => $get_reg_add->reg_postcode,
'country' => $get_reg_add->reg_country,
'price' => $get_reg_add->reg_price
);
}else{
$address2 =$wpdb->get_row("select * from cf_registered_office_details where reg_address_id = '".$address_type."'");
$company =$wpdb->get_row("SELECT * FROM cf_company_details where company_id=".$company_id);
$mf =$wpdb->get_row("select * from cf_mail_forwarding where mf_id = '".$address_type."'");
$address = array('line1' =>$get_company_data->company_name.' '.$get_company_data->company_end,
'line2' => $address2->reg_address_line2,
'town' => $address2->reg_address_town,
'city' => $address2->reg_address_city,
'postcode' => $address2->reg_address_postcode,
'country' => $address2->reg_address_country,
'price' => $address2->reg_address_price,
'mf_id'=>$md->mf_id,
'mf_name'=>$mf->mf_name,
'mf_price'=>$mf->mf_price,
'mf_item_price'=>$mf->mf_item_price,
'mf_postage_retainer_price'=>$mf->mf_postage_retainer_price
);
}
//$address = array('data' => 'Success');
return die(json_encode($address));
}
function cf_add_sic_to_company(){
global $wpdb;
$company_id = $_POST['company_id'];
$section_id = $_POST['section_id'];
$sic_code = $_POST['sic_code'];
$response_array = array('SUCCESS' => 'Success');
$result = $wpdb->update('cf_company_details', array('company_section_id' => $section_id,'company_sic'=>$sic_code),array('company_id' => $company_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
$response_array = array('SUCCESS' => 'Success');
}else{
$response_array = array('SUCCESS' => 'Fail');
}
return die(json_encode($response_array));
}
function cf_add_optional_extra(){
global $wpdb;
$optional_extra = array(
'company_id'=>$_POST['company_id'],
'opt1'=>$_POST['opt1'],
'opt2'=>$_POST['opt2'],
'opt3'=>$_POST['opt3'],
'opt4'=>$_POST['opt4'],
'opt5'=>$_POST['opt5'],
'opt6'=>$_POST['opt6'],
'opt7'=>$_POST['opt7'],
'opt8'=>$_POST['opt8'],
'opt9'=>$_POST['opt9'],
'opt10'=>$_POST['opt10'],
'opt11'=>$_POST['opt11'],
'opt12'=>$_POST['opt12'],
'opt13'=>$_POST['opt13'],
'opt14'=>$_POST['opt14'],
'opt15'=>$_POST['opt15'],
'opt16'=>$_POST['opt16'],
'opt17'=>$_POST['opt17'],
'opt18'=>$_POST['opt18']
);
$wpdb->insert('cf_optional_extra_details', $optional_extra);
$opt_id=$wpdb->insert_id;
$update_package_result = $wpdb->update('cf_company_package_details', array('cp_optional_extra_id'=>$opt_id,'cp_final_total_price'=>$_POST['total']),array('cp_company_id' => $_POST['company_id'] ));
if($update_package_result > 0){
//echo "Successfully Updated";
}
$response_company_array = array('SUCCESS' => 'Success','opt_id' => $opt_id);
return die(json_encode($response_company_array));
}
function cf_add_nominee(){
global $wpdb;
$created_date = date('Y-m-d H:i:s');
$payment_details_array = array(
'cname' =>'',
'title' => '',
'fname' => '',
'mname' => '',
'sname' => '',
'add1' => '',
'add2' => '',
'town' => '',
'pcode' => 0,
'country' => '',
'telephone' => 0,
'email' => '',
'option' => (int)$_POST['option'],
'package_name' => $_POST['optionc'],
'account_services' =>'',
'totalamount' => (int)$_POST['totalamt'],
'created_date' => $created_date,
'tokenid' => $_POST['tokenid']
);
$tokenid = $_POST['tokenid'];
$result = $wpdb->insert('cf_nominee', $payment_details_array);
$cpid = $wpdb->insert_id;
if($result){
$msg = "Inserted..!";
}else{
//echo "Something wrong..!";
$msg = $wpdb->last_result;
}
$response_company_array = array('SUCCESS' => 'Success','tokenid' => $tokenid,'cpid' => $cpid,'error' => $msg);
return die(json_encode($response_company_array));
}
function cf_stripe_charge(){
global $wpdb;
$stotal = explode('.',$_POST['amount']);
if(isset($stotal[1])){
$ftotal = $stotal[0].$stotal[1];
} else{
$ftotal = $stotal[0].'00';
}
require_once(get_template_directory().'/stripe-php/config.php');
try{
$charge = \Stripe\Charge::create(array(
'source' => $_POST['token'],
'amount' => (int)$ftotal,
'currency' => 'gbp',
'description'=>'Company registration package payment'
));
$retch = array('id'=>$charge->id, 'status'=>$charge->status, 'paid'=>$charge->paid);
return die(json_encode($retch));
} catch(\Stripe\Error\Card $e) {
// Since it's a decline, \Stripe\Error\Card will be caught
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (\Stripe\Error\RateLimit $e) {
// Too many requests made to the API too quickly
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (\Stripe\Error\InvalidRequest $e) {
// Invalid parameters were supplied to Stripe's API
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (\Stripe\Error\Authentication $e) {
// Authentication with Stripe's API failed
// (maybe you changed API keys recently)
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (\Stripe\Error\ApiConnection $e) {
// Network communication with Stripe failed
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (\Stripe\Error\Base $e) {
// Display a very generic error to the user, and maybe send
// yourself an email
$body = $e->getJsonBody();
$err = $body['error'];
$msg = $err;
} catch (Exception $e) {
// Something else happened, completely unrelated to Stripe
$msg = $e->getMessage;
}
$ara = array('msg'=>$msg);
return die(json_encode($ara));
}
function cf_add_company(){
global $wpdb;
//$company_user_email = $_POST['user_email'];
$created_date = date('Y-m-d H:i:s');
$user_id = get_current_user_id();
$msg = "inserted";
$current_user = wp_get_current_user();
$user_data = array(
'user_pass' => '123456',
'user_login' => $_POST['comp_name']
);
if ( 0 == $current_user->ID ) {
// Not logged in.
$user_id = wp_insert_user( $user_data );
if(!is_wp_error($user_id)){
wp_set_current_user($user_id); // set the current wp user
wp_set_auth_cookie($user_id); // start the cookie for the current registered user
}
}
/*
if (email_exists($company_user_email) == false ) {
$random_password=wp_generate_password( $length = 12, $include_standard_special_chars = false );
$user_id = wp_create_user($get->email,$random_password, $get->email );
$headers = 'From: Get Quote <GetQoute@mydomain.com>' . "\r\n";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=UTF-8' . "\r\n";
$msg='Dear Customer,<br> Thank you For Register your username and password are below.<br> Username :'.$get->email.'<br> Password :'.$random_password.'<br> <br> thank you';
mail($get->email, 'Company Formation',$msg, $headers);
//add user data into cf_user_details
$wpdb->insert('cf_user_details', array(
'user_id' => $user_id,
'user_email' => $company_user_email,
'user_password' => $random_password
));
}else{
$user = get_user_by('email', $company_user_email);
$user_id = $user->ID;
}
*/
//$get_cid = $wpdb->get_row("SHOW TABLE STATUS LIKE 'cf_company_details'");
//$last_cid = $get_cid->Auto_increment;
//$next_cid = $last_cid + 1;
//$get_cid=$wpdb->get_row("SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'cf_company_details' AND table_schema = DATABASE( )");
//$next_cid = $get_cid -> AUTO_INCREMENT;
$company_details_array = array(
//'company_id' => $next_cid,
'company_type' => trim($_POST['company_type']),
'company_name' => $_POST['comp_name'],
//'company_section_id' => (int) $_POST['sic'],
//'company_sic' => (int) $_POST['sic_code'],
'company_user_id' =>(int) $user_id,
'company_created_date'=> $created_date,
'company_status' =>'INCOMPLETE'
);
/*
$company_details_array = array(
//'company_id' => $next_cid,
'company_type' => 'LLP',
'company_name' => 'DEMO',
'company_section_id' => 1,
'company_sic' => 1110,
'company_user_id' => 1,
'company_created_date'=> $created_date
);
*/
//echo "<script>alert('".$company_details_array."')";
$wpdb->insert('cf_company_details', $company_details_array);
$cid=$wpdb->insert_id;
//$get_cpid = $wpdb->get_row("SHOW TABLE STATUS LIKE 'cf_company_package_details'");
//$last_cpid = $get_cpid->Auto_increment;
//$next_cpid = $last_cpid + 1;
//$get_cpid=$wpdb->get_row("SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'cf_company_package_details' AND table_schema = DATABASE( )");
//$next_cpid = $get_cpid-> AUTO_INCREMENT;
$package_details_array = array(
//'cp_id' => (int) $next_cpid,
'cp_company_id' => $cid,
'cp_user_id' => $user_id,
'cp_package_id' => $_POST['pid'],
'cp_date' => $created_date,
'cp_status' => 'PANDING',
'cp_total_price' => $_POST['totalamt']
);
//echo $package_details_array;
//echo "<script>alert(".$package_details_array")</script>";
$cp_result = $wpdb->insert('cf_company_package_details', $package_details_array);
$cpid = $wpdb->insert_id;
if($cp_result){
$msg = "Inserted..!";
}else{
//echo "Something wrong..!";
$msg = $wpdb->last_result;
}
$wp_session['cid'] = $cid;
$_SESSION['cid'] = $cid;
$wp_session['cpid'] = $cpid;
$_SESSION['cpid'] = $cpid;
$response_company_array = array('SUCCESS' => 'Success','cid' => $cid,'cpid' => $cpid,'error' => $msg);
return die(json_encode($response_company_array));
}
function cf_add_registered_office(){
global $wpdb;
$reg_add_details_array = array('SUCCESS'=>'FAIL');
$address_type = $_POST['reg_type'];
$get_company_data=$wpdb->get_row("select * from cf_company_details where company_id ='".$_POST['company_id']."' order by company_id limit 1");
if($address_type == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$add =$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_address_id."'");
$reg_add_details_array = array(
'reg_company_id' => $_POST['company_id'],
'reg_type'=>$address_type,
'reg_line1' =>$add->address_line1,
'reg_line2' => $add->address_line2,
'reg_town' => $add->address_town,
'reg_city' => $add->address_city,
'reg_postcode' => $add->address_postcode,
'reg_country' => $add->address_country,
'reg_price' => 0
);
}else if($address_type == 'other'){
$reg_add_details_array = array(
'reg_company_id' => $_POST['company_id'],
'reg_type'=>$address_type,
'reg_line1' => $_POST['line1'],
'reg_line2' => $_POST['line2'],
'reg_town' => $_POST['town'],
'reg_city' => $_POST['city'],
'reg_postcode' => $_POST['postcode'],
'reg_country' => $_POST['country'],
'reg_price' => 0
);
}else{
$address2 =$wpdb->get_row("select * from cf_registered_office_details where reg_address_id = '".$address_type."'");
$reg_add_details_array = array(
'reg_company_id' => $_POST['company_id'],
'reg_type'=>$address_type,
'reg_line1' => $get_company_data->company_name.' '.$get_company_data->company_end,
'reg_line2' => $address2->reg_address_line2,
'reg_town' =>$address2->reg_address_town,
'reg_city' => $address2->reg_address_city,
'reg_postcode' => $address2->reg_address_postcode,
'reg_country' => $address2->reg_address_country,
'reg_price' => $address2->reg_address_price
);
}
$add_result = $wpdb->insert('cf_registered_office_address', $reg_add_details_array);
$reg_add_id = $wpdb->insert_id;
$update_package_result = $wpdb->update('cf_company_package_details', array('cp_reg_office_id' => $reg_add_id,'cp_mail_forwarding_id'=>$_POST['mf_id']),array('cp_company_id' => $_POST['company_id'] ));
if($update_package_result > 0){
//echo "Successfully Updated";
}
$response_array = array('SUCCESS' => 'Success','reg_id'=>$reg_add_id);
return die(json_encode($response_array));
}
function cf_add_company_contact(){
global $wpdb;
$msg = "inserted";
$current_user = wp_get_current_user();
$user_id = get_current_user_id();
$company_user_email = $_POST['contact_email'];
$wp_session['c_end'] = $_POST['type'];
$_SESSION['c_end'] = $_POST['type'];
$user_info = get_userdata($user_id);
$end_result = $wpdb->update('cf_company_details', array('company_end' => $_POST['type']),array('company_id' => $_POST['company_id'] ),array('%s'));
if($end_result > 0){
//echo "Successfully Updated";
}
if($_POST['reg_select'] == 'YES'){
$reg_result = $wpdb->update('cf_company_package_details', array('cp_reg_fees' => 'Y'),array('cp_company_id' => $_POST['company_id'] ),array('%s'));
if($reg_result > 0){
//echo "Successfully Updated";
}
}
if($user_info->user_login == $_SESSION['companyname']){
$random_password=wp_generate_password( $length = 12, $include_standard_special_chars = false );
wp_update_user( array(
'ID' => $user_id,
'user_pass' => $random_password,
'user_login' => $company_user_email,
'user_nicename' => $_POST['contact_fname'],
'user_email' => $company_user_email,
'display_name' => $_POST['contact_fname'].' '.$_POST['contact_surname']
) );
$wpdb->update($wpdb->users, array('user_login' => $company_user_email), array('ID' => $user_id));
$headers = 'From: Get Quote <GetQoute@mydomain.com>' . "\r\n";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=UTF-8' . "\r\n";
$msg2='Dear Customer,<br> Thank you For Register your username and password are below.<br> Username :'.$company_user_email.'<br> Password :'.$random_password.'<br> <br> thank you';
mail($company_user_email, 'Company Formation',$msg2, $headers);
}
/*
if(username_exists($_SESSION['companyname']) == true){
$user = get_user_by('login', $_SESSION['companyname']);
$u_id = $user->ID;
if($u_id == $user_id){
$random_password=wp_generate_password( $length = 12, $include_standard_special_chars = false );
wp_update_user( array(
'ID' => $user_id,
'user_pass' => $random_password,
'user_login' => $company_user_email,
'user_nicename' => $_POST['contact_fname'],
'user_email' => $company_user_email,
'display_name' => $_POST['contact_fname'].' '.$_POST['contact_surname'],
'nickname' => $_POST['contact_fname'],
'first_name' => $_POST['contact_fname'],
'last_name' => $_POST['contact_surname']
) );
$headers = 'From: Get Quote <GetQoute@mydomain.com>' . "\r\n";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=UTF-8' . "\r\n";
$msg2='Dear Customer,<br> Thank you For Register your username and password are below.<br> Username :'.$company_user_email.'<br> Password :'.$random_password.'<br> <br> thank you';
mail($company_user_email, 'Company Formation',$msg2, $headers);
}
}
*/
$contact_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['contact_add_l1'],
'address_line2' =>$_POST['contact_add_l2'],
'address_town' =>$_POST['contact_add_town'],
'address_city' => $_POST['contact_add_town'],
'address_postcode' => $_POST['contact_add_postcode'],
'address_country' => $_POST['contact_add_country'],
'address_type'=>'contact'
);
$add_result = $wpdb->insert('cf_address_details', $contact_add_details_array);
$contact_add_id = $wpdb->insert_id;
$contact_details_array = array(
'person_company_id' => $_POST['company_id'],
//'person_name_title' => $_POST['contact_title'],
'person_name_fname' =>$_POST['contact_fname'],
//'person_name_mname' =>$_POST['contact_mname'],
//'person_name_surname' => $_POST['contact_surname'],
//'person_dob' => $_POST['contact_dob'],
//'person_nationality' => $_POST['contact_nationality'],
'person_email' => $_POST['contact_email'],
'person_phone' => $_POST['contact_phone'],
'person_address_id' => $contact_add_id,
'person_is_contact' => 'Y',
'person_is_subscriber' => 'N',
'person_is_director' => 'N',
'person_is_partner' => 'N',
'person_is_secretary' => 'N',
'person_is_shareholder' => 'N'
);
$result = $wpdb->insert('cf_person_details', $contact_details_array);
$person_id = $wpdb->insert_id;
if($add_result){
$msg = "Inserted..!";
}else{
//echo "Something wrong..!";
$msg = $wpdb->last_result;
}
$response_contact_array = array('SUCCESS' => 'Success','pid'=>$person_id,'add_id'=> $contact_add_id,'result'=>$msg);
return die(json_encode($response_contact_array));
}
function cf_add_company_director(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$dir_is_sec = 'N';
$dir_is_sh = 'N';
$dir_is_sub = 'N';
if( isset($_POST['dir_is_sec']) )
{
$dir_is_sec = $_POST['dir_is_sec'];
}
if( isset($_POST['dir_is_sh']) )
{
$dir_is_sh = $_POST['dir_is_sh'];
}
if( isset($_POST['dir_is_sub']) )
{
$dir_is_sub = $_POST['dir_is_sub'];
}
$director_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_add_l1'],
'address_line2' =>$_POST['dir_add_l2'],
'address_town' =>$_POST['dir_add_town'],
'address_city' => $_POST['dir_add_city'],
'address_postcode' => $_POST['dir_add_postcode'],
'address_country' => $_POST['dir_add_country'],
'address_type' => 'personal'
);
if($_POST['isEdit'] == 'Y'){
$person=$wpdb->get_row("select * from cf_person_details where person_company_id='".$_POST['company_id']."' and person_id='".$_POST['pid']."' order by person_id limit 1");
//address update
$result = $wpdb->update('cf_address_details', $director_add_details_array ,array('address_id' => $person->person_address_id ));
$dir_add_id = $person->person_address_id;
//service address
$saddress=$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_service_address_id."'");
//same saddress...
if($saddress->address_type == $_POST['sa'] || ($saddress->address_type == 'own' && $_POST['sa'] == '0')){
if($saddress->address_type == 'service' || $saddress->address_type == 'own'){
$dir_sadd_id = $person->person_service_address_id;
$director_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_sadd_l1'],
'address_line2' =>$_POST['dir_sadd_l2'],
'address_town' =>$_POST['dir_sadd_town'],
'address_city' => $_POST['dir_sadd_city'],
'address_postcode' => $_POST['dir_sadd_postcode'],
'address_country' => $_POST['dir_sadd_country'],
'address_type'=> $saddress->address_type
);
$result = $wpdb->update('cf_address_details', $director_sadd_details_array ,array('address_id' => $person->person_service_address_id ));
}
}else{
//different saddress...
if(($saddress->address_type == 'contact' || $saddress->address_type == 'personal') && ($_POST['sa'] == 'service' || $_POST['sa'] == '0')){
//add new
if($_POST['sa'] == 'service'){
$director_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_sadd_l1'],
'address_line2' =>$_POST['dir_sadd_l2'],
'address_town' =>$_POST['dir_sadd_town'],
'address_city' => $_POST['dir_sadd_city'],
'address_postcode' => $_POST['dir_sadd_postcode'],
'address_country' => $_POST['dir_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $director_sadd_details_array);
$dir_sadd_id =$wpdb->insert_id;
}else{
$director_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_sadd_l1'],
'address_line2' =>$_POST['dir_sadd_l2'],
'address_town' =>$_POST['dir_sadd_town'],
'address_city' => $_POST['dir_sadd_city'],
'address_postcode' => $_POST['dir_sadd_postcode'],
'address_country' => $_POST['dir_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $director_sadd_details_array);
$dir_sadd_id =$wpdb->insert_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $dir_sadd_id),array('person_id' => $person->person_id ),array('%d'));
}else if (($saddress->address_type == 'service' || $saddress->address_type == 'own') && ($_POST['sa'] == 'personal' || $_POST['sa'] == 'contact')){
//delete old
// Using where formatting.
$wpdb->delete( 'cf_address_details', array( 'address_id' => $person->person_service_address_id ), array( '%d' ) );
if($_POST['sa'] == 'personal'){
$dir_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'contact'){
$person2 = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$dir_sadd_id = $person2->person_address_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $dir_sadd_id),array('person_id' => $person->person_id ));
}
}
//personal id
$director_pi_details_array = array(
'que1' => $_POST['dir_pi_q1'],
'que2' => $_POST['dir_pi_q2'],
'que3' =>$_POST['dir_pi_q3'],
'ans1' =>$_POST['dir_pi_a1'],
'ans2' => $_POST['dir_pi_a2'],
'ans3' => $_POST['dir_pi_a3']
);
$result = $wpdb->update('cf_personal_id_details', $director_pi_details_array ,array('personal_id' => $person->person_personal_id ));
//share details
if($person->person_is_shareholder == 'Y' && $dir_is_sh == 'N'){
$wpdb->delete( 'cf_share_details', array( 'share_id' => $person->person_share_detail_id ), array( '%d' ) );
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => 0),array('person_id' => $person->person_id ),array('%d'));
}else if($person->person_is_shareholder == 'N' && $dir_is_sh == 'Y'){
$director_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person->person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $director_share_details_array);
$dir_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $dir_share_detail_id),array('person_id' => $person->person_id ));
}
//personal details
$director_details_array = array(
'person_name_title' => $_POST['dir_title'],
'person_name_fname' =>$_POST['dir_fname'],
'person_name_mname' =>$_POST['dir_mname'],
'person_name_surname' => $_POST['dir_surname'],
'person_dob' => $_POST['dir_dob'],
'person_nationality' => $_POST['dir_nationality'],
'person_is_contact' => 'N',
'person_is_director' => 'Y',
'person_is_partner' => 'N',
'person_is_subscriber' => $dir_is_sub,
'person_is_secretary' => $dir_is_sec,
'person_is_shareholder' => $dir_is_sh,
'person_amount_guaranteed'=>$_POST['g_amount']
);
$result = $wpdb->update('cf_person_details', $director_details_array,array('person_id' => $person->person_id ));
$person_id = $person->person_id;
$dir_pi_id = $person->peron_personal_id;
}else{
//new director
$wpdb->insert('cf_address_details', $director_add_details_array);
$dir_add_id =$wpdb->insert_id;
if($_POST['sa'] == 'personal'){
$dir_sadd_id = $dir_add_id;
}else if($_POST['sa'] == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$dir_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'service'){
//$dir_sadd_id = 0;
$director_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_sadd_l1'],
'address_line2' =>$_POST['dir_sadd_l2'],
'address_town' =>$_POST['dir_sadd_town'],
'address_city' => $_POST['dir_sadd_city'],
'address_postcode' => $_POST['dir_sadd_postcode'],
'address_country' => $_POST['dir_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $director_sadd_details_array);
$dir_sadd_id =$wpdb->insert_id;
}else{
$director_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['dir_sadd_l1'],
'address_line2' =>$_POST['dir_sadd_l2'],
'address_town' =>$_POST['dir_sadd_town'],
'address_city' => $_POST['dir_sadd_city'],
'address_postcode' => $_POST['dir_sadd_postcode'],
'address_country' => $_POST['dir_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $director_sadd_details_array);
$dir_sadd_id =$wpdb->insert_id;
}
$director_pi_details_array = array(
'que1' => $_POST['dir_pi_q1'],
'que2' => $_POST['dir_pi_q2'],
'que3' =>$_POST['dir_pi_q3'],
'ans1' =>$_POST['dir_pi_a1'],
'ans2' => $_POST['dir_pi_a2'],
'ans3' => $_POST['dir_pi_a3']
);
$wpdb->insert('cf_personal_id_details', $director_pi_details_array);
$dir_pi_id =$wpdb->insert_id;
$director_details_array = array(
'person_company_id' => $_POST['company_id'],
'person_name_title' => $_POST['dir_title'],
'person_name_fname' =>$_POST['dir_fname'],
'person_name_mname' =>$_POST['dir_mname'],
'person_name_surname' => $_POST['dir_surname'],
'person_dob' => $_POST['dir_dob'],
'person_nationality' => $_POST['dir_nationality'],
'person_email' => $_POST['dir_email'],
'person_phone' => $_POST['dir_phone'],
'person_address_id' => $dir_add_id,
'person_service_address_id' => $dir_sadd_id,
'person_is_contact' => 'N',
'person_is_director' => 'Y',
'person_is_partner' => 'N',
'person_is_subscriber' => $dir_is_sub,
'person_is_secretary' => $dir_is_sec,
'person_is_shareholder' => $dir_is_sh,
'person_personal_id'=> $dir_pi_id,
'person_amount_guaranteed'=>$_POST['g_amount']
);
$wpdb->insert('cf_person_details', $director_details_array);
$person_id = $wpdb->insert_id;
if($dir_is_sh == "Y"){
$director_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $director_share_details_array);
$dir_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $dir_share_detail_id),array('person_id' => $person_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
}
}
$response_dir_array = array('SUCCESS' => 'Success','pid' => $person_id , 'add_id' => $dir_add_id,'sadd_id' => $dir_sadd_id,'pi_id' => $dir_pi_id);
return die(json_encode($response_dir_array));
}
function cf_add_company_corporate_director(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$dir_is_sec = $_POST['dir_is_sec'];
$dir_is_sh = $_POST['dir_is_sh'];
$dir_is_sub = $_POST['dir_is_sub'];
//$dir_is_sec = 'N';
//$dir_is_sh = 'N';
//$dir_is_sub = 'N';
/*
if( isset($_POST['dir_is_sec']) )
{
$dir_is_sec = $_POST['dir_is_sec'];
}
if( isset($_POST['dir_is_sh']) )
{
$dir_is_sh = $_POST['dir_is_sh'];
}
if( isset($_POST['dir_is_sub']) )
{
$dir_is_sub = $_POST['dir_is_sub'];
}
*/
$director_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['add_l1'],
'address_line2' =>$_POST['add_l2'],
'address_town' =>$_POST['add_town'],
'address_city' => $_POST['add_city'],
'address_postcode' => $_POST['add_postcode'],
'address_country' => $_POST['add_country']
);
$wpdb->insert('cf_address_details', $director_add_details_array,$add_format);
$dir_add_id =$wpdb->insert_id;
$director_pi_details_array = array(
'que1' => $_POST['pi_q1'],
'que2' => $_POST['pi_q2'],
'que3' =>$_POST['pi_q3'],
'ans1' =>$_POST['pi_a1'],
'ans2' => $_POST['pi_a2'],
'ans3' => $_POST['pi_a3']
);
$wpdb->insert('cf_personal_id_details', $director_pi_details_array);
$dir_pi_id =$wpdb->insert_id;
$director_details_array = array(
'corporate_company_id' => $_POST['company_id'],
'corporate_name' => $_POST['corporate_name'],
'corporate_reg_num' =>$_POST['corporate_reg_num'],
'corporate_type' =>$_POST['corporate_type'],
'corporate_reg_country' => $_POST['corporate_reg_country'],
'corporate_address_id' => $dir_add_id,
'corporate_gov_country' => $_POST['corporate_gov_country'],
'corporate_rp_name' => $_POST['corporate_rp_name'],
'corporate_personal_id' => $dir_pi_id,
'corporate_is_director' => 'Y',
'corporate_is_secretary' => $dir_is_sec,
'corporate_is_shareholder' => $dir_is_sh,
'corporate_is_subscriber' => $dir_is_sub
);
$wpdb->insert('cf_corporate_details', $director_details_array);
$corporate_id = $wpdb->insert_id;
if($dir_is_sh == "Y"){
$director_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $corporate_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $director_share_details_array);
$dir_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_corporate_details', array('corporate_share_detail_id' => $dir_share_detail_id),array('corporate_id' => $corporate_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
}
$response_dir_array = array('SUCCESS' => 'Success','corporate_id' => $corporate_id , 'add_id' => $dir_add_id,'pi_id' => $dir_pi_id);
return die(json_encode($response_dir_array));
}
function cf_add_company_corporate_partner(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$p_is_dp = 'N';
if( isset($_POST['p_is_dp']) )
{
$p_is_dp = $_POST['p_is_dp'];
}
$partner_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['add_l1'],
'address_line2' =>$_POST['add_l2'],
'address_town' =>$_POST['add_town'],
'address_city' => $_POST['add_city'],
'address_postcode' => $_POST['add_postcode'],
'address_country' => $_POST['add_country']
);
$wpdb->insert('cf_address_details', $partner_add_details_array,$add_format);
$partner_add_id =$wpdb->insert_id;
$partner_pi_details_array = array(
'que1' => $_POST['pi_q1'],
'que2' => $_POST['pi_q2'],
'que3' =>$_POST['pi_q3'],
'ans1' =>$_POST['pi_a1'],
'ans2' => $_POST['pi_a2'],
'ans3' => $_POST['pi_a3']
);
$wpdb->insert('cf_personal_id_details', $partner_pi_details_array);
$partner_pi_id =$wpdb->insert_id;
$partner_details_array = array(
'corporate_company_id' => $_POST['company_id'],
'corporate_name' => $_POST['corporate_name'],
'corporate_reg_num' =>$_POST['corporate_reg_num'],
'corporate_type' =>$_POST['corporate_type'],
'corporate_reg_country' => $_POST['corporate_reg_country'],
'corporate_address_id' => $partner_add_id,
'corporate_gov_country' => $_POST['corporate_gov_country'],
'corporate_rp_name' => $_POST['corporate_rp_name'],
'corporate_personal_id' => $partner_pi_id,
'corporate_is_partner' => 'Y',
'corporate_is_dpartner' => $p_is_dp,
);
$wpdb->insert('cf_corporate_details', $partner_details_array);
$corporate_id = $wpdb->insert_id;
$response_array = array('SUCCESS' => 'Success','corporate_id' => $corporate_id , 'add_id' => $partner_add_id,'pi_id' => $partner_pi_id);
return die(json_encode($response_array));
}
function cf_add_company_corporate_secretary(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$sec_is_sh = 'N';
$sec_is_sub = 'N';
if( isset($_POST['sec_is_sec']) )
{
$sec_is_sh = $_POST['sec_is_sh'];
}
if( isset($_POST['sec_is_sub']) )
{
$sec_is_sub = $_POST['sec_is_sub'];
}
$sec_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['add_l1'],
'address_line2' =>$_POST['add_l2'],
'address_town' =>$_POST['add_town'],
'address_city' => $_POST['add_city'],
'address_postcode' => $_POST['add_postcode'],
'address_country' => $_POST['add_country']
);
$wpdb->insert('cf_address_details', $sec_add_details_array,$add_format);
$sec_add_id =$wpdb->insert_id;
$sec_pi_details_array = array(
'que1' => $_POST['pi_q1'],
'que2' => $_POST['pi_q2'],
'que3' =>$_POST['pi_q3'],
'ans1' =>$_POST['pi_a1'],
'ans2' => $_POST['pi_a2'],
'ans3' => $_POST['pi_a3']
);
$wpdb->insert('cf_personal_id_details', $sec_pi_details_array);
$sec_pi_id =$wpdb->insert_id;
$sec_details_array = array(
'corporate_company_id' => $_POST['company_id'],
'corporate_name' => $_POST['corporate_name'],
'corporate_reg_num' =>$_POST['corporate_reg_num'],
'corporate_type' =>$_POST['corporate_type'],
'corporate_reg_country' => $_POST['corporate_reg_country'],
'corporate_address_id' => $sec_add_id,
'corporate_gov_country' => $_POST['corporate_gov_country'],
'corporate_rp_name' => $_POST['corporate_rp_name'],
'corporate_personal_id' => $sec_pi_id,
'corporate_is_secretary' => 'Y',
'corporate_is_shareholder' => $sec_is_sh,
'corporate_is_subscriber' => $sec_is_sub
);
$wpdb->insert('cf_corporate_details', $sec_details_array);
$corporate_id = $wpdb->insert_id;
if($sec_is_sh == "Y"){
$sec_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $corporate_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sec_share_details_array);
$sec_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_corporate_details', array('corporate_share_detail_id' => $sec_share_detail_id),array('corporate_id' => $corporate_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
}
$response_array = array('SUCCESS' => 'Success','corporate_id' => $corporate_id , 'add_id' => $sec_add_id,'pi_id' => $sec_pi_id);
return die(json_encode($response_array));
}
function cf_add_company_corporate_shareholder(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$sh_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['add_l1'],
'address_line2' =>$_POST['add_l2'],
'address_town' =>$_POST['add_town'],
'address_city' => $_POST['add_city'],
'address_postcode' => $_POST['add_postcode'],
'address_country' => $_POST['add_country']
);
$wpdb->insert('cf_address_details', $sh_add_details_array,$add_format);
$sh_add_id =$wpdb->insert_id;
$sh_pi_details_array = array(
'que1' => $_POST['pi_q1'],
'que2' => $_POST['pi_q2'],
'que3' =>$_POST['pi_q3'],
'ans1' =>$_POST['pi_a1'],
'ans2' => $_POST['pi_a2'],
'ans3' => $_POST['pi_a3']
);
$wpdb->insert('cf_personal_id_details', $sh_pi_details_array);
$sh_pi_id =$wpdb->insert_id;
$sh_details_array = array(
'corporate_company_id' => $_POST['company_id'],
'corporate_name' => $_POST['corporate_name'],
'corporate_reg_num' =>$_POST['corporate_reg_num'],
'corporate_type' =>$_POST['corporate_type'],
'corporate_reg_country' => $_POST['corporate_reg_country'],
'corporate_address_id' => $sh_add_id,
'corporate_gov_country' => $_POST['corporate_gov_country'],
'corporate_rp_name' => $_POST['corporate_rp_name'],
'corporate_personal_id' => $sh_pi_id,
'corporate_is_shareholder' => 'Y',
);
$wpdb->insert('cf_corporate_details', $sh_details_array);
$corporate_id = $wpdb->insert_id;
$sh_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $corporate_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sh_share_details_array);
$sh_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_corporate_details', array('corporate_share_detail_id' => $sh_share_detail_id),array('corporate_id' => $corporate_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
$response_array = array('SUCCESS' => 'Success','corporate_id' => $corporate_id , 'add_id' => $sh_add_id,'pi_id' => $sh_pi_id);
return die(json_encode($response_array));
}
function cf_add_company_corporate_subscriber(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$isedit = $_POST['isEdit'];
$person=$wpdb->get_row("select * from cf_corporate_details where corporate_id='".$_POST['pid']."' limit 1");
$sub_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['add_l1'],
'address_line2' =>$_POST['add_l2'],
'address_town' =>$_POST['add_town'],
'address_city' => $_POST['add_city'],
'address_postcode' => $_POST['add_postcode'],
'address_country' => $_POST['add_country']
);
if($isedit == 'Y'){
$wpdb->update('cf_address_details', $sub_add_details_array,array('address_id'=>$person->corporate_address_id));
$sub_add_id =$person->corporate_address_id;
} else{
$wpdb->insert('cf_address_details', $sub_add_details_array,$add_format);
$sub_add_id =$wpdb->insert_id;
}
$sub_pi_details_array = array(
'que1' => $_POST['pi_q1'],
'que2' => $_POST['pi_q2'],
'que3' =>$_POST['pi_q3'],
'ans1' =>$_POST['pi_a1'],
'ans2' => $_POST['pi_a2'],
'ans3' => $_POST['pi_a3']
);
if($isedit == 'Y'){
$wpdb->update('cf_personal_id_details', $sub_pi_details_array, array('personal_id'=>$person->corporate_personal_id));
$sub_pi_id = $person->corporate_personal_id;
} else{
$wpdb->insert('cf_personal_id_details', $sub_pi_details_array);
$sub_pi_id =$wpdb->insert_id;
}
$sub_details_array = array(
'corporate_company_id' => $_POST['company_id'],
'corporate_name' => $_POST['corporate_name'],
'corporate_reg_num' =>$_POST['corporate_reg_num'],
'corporate_type' =>$_POST['corporate_type'],
'corporate_reg_country' => $_POST['corporate_reg_country'],
'corporate_address_id' => $sub_add_id,
'corporate_gov_country' => $_POST['corporate_gov_country'],
'corporate_rp_name' => $_POST['corporate_rp_name'],
'corporate_personal_id' => $sub_pi_id,
'corporate_is_subscriber' => 'Y',
'corporate_amount_guarnteed' => $_POST['g_amount']
);
if($isedit == 'Y'){
$wpdb->update('cf_corporate_details', $sub_details_array, array('corporate_id'=>$_POST['pid']));
$corporate_id = $_POST['pid'];
} else{
$wpdb->insert('cf_corporate_details', $sub_details_array);
$corporate_id = $wpdb->insert_id;
}
$response_array = array('SUCCESS' => 'Success','corporate_id' => $corporate_id , 'add_id' => $sub_add_id,'pi_id' => $sub_pi_id);
return die(json_encode($response_array));
}
function cf_nominee_corporate_director(){
global $wpdb;
alert("step 1");
$add_format = array(
//data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%d',
'%s',
'%d',
'%s',
'%d');
if($_POST['option'] == '7'){
alert("step 3");
$n_details_array = array(
'cname' => $_POST['cname'],
'title' => $_POST['title'],
'fname' =>$_POST['fname'],
'mname' =>$_POST['mname'],
'sname' => $_POST['sname'],
'add1' => $_POST['add1'],
'add2' => $_POST['add1'],
'town' => $_POST['town'],
'pcode' => $_POST['pcode'],
'country' => $_POST['country'],
'telephone' => $_POST['telephone'],
'email' => $_POST['email'],
'option'=> 7
);
if($wpdb->insert('cf_nominee_corporate_director', $n_details_array,$add_format) == false){
echo "Error";
}else{
echo "Nominee '".$_POST['fname']. "' successfully added, row ID is ".$wpdb->insert_id;
}
}else{
echo "error is occured";
}
$response_p_array = array('SUCCESS' => 'Success');
return die(json_encode($response_p_array));
}
function cf_add_company_partner(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$p_is_dp = 'N';
if( isset($_POST['p_is_dp']) )
{
$p_is_dp = $_POST['p_is_dp'];
}
$p_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_add_l1'],
'address_line2' =>$_POST['p_add_l2'],
'address_town' =>$_POST['p_add_town'],
'address_city' => $_POST['p_add_city'],
'address_postcode' => $_POST['p_add_postcode'],
'address_country' => $_POST['p_add_country'],
'address_type'=>'personal'
);
if($_POST['isEdit'] == 'Y'){
$person=$wpdb->get_row("select * from cf_person_details where person_company_id='".$_POST['company_id']."' and person_id='".$_POST['pid']."' order by person_id limit 1");
//address update
$result = $wpdb->update('cf_address_details', $p_add_details_array ,array('address_id' => $person->person_address_id ));
$p_add_id = $person->person_address_id;
//service address
$saddress=$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_service_address_id."'");
//same saddress...
if($saddress->address_type == $_POST['sa'] || ($saddress->address_type == 'own' && $_POST['sa'] == '0')){
if($saddress->address_type == 'service' || $saddress->address_type == 'own'){
$p_sadd_id = $person->person_service_address_id;
$p_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_sadd_l1'],
'address_line2' =>$_POST['p_sadd_l2'],
'address_town' =>$_POST['p_sadd_town'],
'address_city' => $_POST['p_sadd_city'],
'address_postcode' => $_POST['p_sadd_postcode'],
'address_country' => $_POST['p_sadd_country'],
'address_type'=> $saddress->address_type
);
$result = $wpdb->update('cf_address_details', $p_sadd_details_array ,array('address_id' => $person->person_service_address_id ));
}
}else{
//different saddress...
if(($saddress->address_type == 'contact' || $saddress->address_type == 'personal') && ($_POST['sa'] == 'service' || $_POST['sa'] == '0')){
//add new
if($_POST['sa'] == 'service'){
$p_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_sadd_l1'],
'address_line2' =>$_POST['p_sadd_l2'],
'address_town' =>$_POST['p_sadd_town'],
'address_city' => $_POST['p_sadd_city'],
'address_postcode' => $_POST['p_sadd_postcode'],
'address_country' => $_POST['p_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $p_sadd_details_array);
$p_sadd_id =$wpdb->insert_id;
}else{
$p_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_sadd_l1'],
'address_line2' =>$_POST['p_sadd_l2'],
'address_town' =>$_POST['p_sadd_town'],
'address_city' => $_POST['p_sadd_city'],
'address_postcode' => $_POST['p_sadd_postcode'],
'address_country' => $_POST['p_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $p_sadd_details_array);
$p_sadd_id =$wpdb->insert_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $p_sadd_id),array('person_id' => $person->person_id ),array('%d'));
}else if (($saddress->address_type == 'service' || $saddress->address_type == 'own') && ($_POST['sa'] == 'personal' || $_POST['sa'] == 'contact')){
//delete old
// Using where formatting.
$wpdb->delete( 'cf_address_details', array( 'address_id' => $person->person_service_address_id ), array( '%d' ) );
if($_POST['sa'] == 'personal'){
$p_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'contact'){
$person2 = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$p_sadd_id = $person2->person_address_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $p_sadd_id),array('person_id' => $person->person_id ));
}
}
//personal id
$p_pi_details_array = array(
'que1' => $_POST['p_pi_q1'],
'que2' => $_POST['p_pi_q2'],
'que3' =>$_POST['p_pi_q3'],
'ans1' =>$_POST['p_pi_a1'],
'ans2' => $_POST['p_pi_a2'],
'ans3' => $_POST['p_pi_a3']
);
$result = $wpdb->update('cf_personal_id_details', $p_pi_details_array ,array('personal_id' => $person->person_personal_id ));
//personal details
$p_details_array = array(
'person_name_title' => $_POST['p_title'],
'person_name_fname' =>$_POST['p_fname'],
'person_name_mname' =>$_POST['p_mname'],
'person_name_surname' => $_POST['p_surname'],
'person_dob' => $_POST['p_dob'],
'person_nationality' => $_POST['p_nationality'],
'person_is_partner' => 'Y',
'person_is_dpartner' => $p_is_dp
);
$result = $wpdb->update('cf_person_details', $p_details_array,array('person_id' => $person->person_id ));
$person_id = $person->person_id;
$p_pi_id = $person->peron_personal_id;
}else{
$wpdb->insert('cf_address_details', $p_add_details_array,$add_format);
$p_add_id =$wpdb->insert_id;
if($_POST['sa'] == 'personal'){
$p_sadd_id = $p_add_id;
}else if($_POST['sa'] == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$p_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'service'){
$p_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_sadd_l1'],
'address_line2' =>$_POST['p_sadd_l2'],
'address_town' =>$_POST['p_sadd_town'],
'address_city' => $_POST['p_sadd_city'],
'address_postcode' => $_POST['p_sadd_postcode'],
'address_country' => $_POST['p_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $p_sadd_details_array,$add_format);
$p_sadd_id =$wpdb->insert_id;
}else{
$p_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['p_sadd_l1'],
'address_line2' =>$_POST['p_sadd_l2'],
'address_town' =>$_POST['p_sadd_town'],
'address_city' => $_POST['p_sadd_city'],
'address_postcode' => $_POST['p_sadd_postcode'],
'address_country' => $_POST['p_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $p_sadd_details_array,$add_format);
$p_sadd_id =$wpdb->insert_id;
}
$p_pi_details_array = array(
'que1' => $_POST['p_pi_q1'],
'que2' => $_POST['p_pi_q2'],
'que3' =>$_POST['p_pi_q3'],
'ans1' =>$_POST['p_pi_a1'],
'ans2' => $_POST['p_pi_a2'],
'ans3' => $_POST['p_pi_a3']
);
$wpdb->insert('cf_personal_id_details', $p_pi_details_array);
$p_pi_id =$wpdb->insert_id;
$p_details_array = array(
'person_company_id' => $_POST['company_id'],
'person_name_title' => $_POST['p_title'],
'person_name_fname' =>$_POST['p_fname'],
'person_name_mname' =>$_POST['p_mname'],
'person_name_surname' => $_POST['p_surname'],
'person_dob' => $_POST['p_dob'],
'person_nationality' => $_POST['p_nationality'],
'person_email' => $_POST['p_email'],
'person_phone' => $_POST['p_phone'],
'person_address_id' => $p_add_id,
'person_service_address_id' => $p_sadd_id,
'person_is_partner' => 'Y',
'person_is_dpartner' => $p_is_dp,
'person_personal_id'=> $p_pi_id
);
$wpdb->insert('cf_person_details', $p_details_array);
$person_id = $wpdb->insert_id;
}
$response_p_array = array('SUCCESS' => 'Success','pid' => $person_id , 'add_id' => $p_add_id,'sadd_id' => $p_sadd_id,'pi_id' => $p_pi_id);
return die(json_encode($response_p_array));
}
function cf_add_company_secretary(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
//$sec_is_sh = $_POST['sec_is_sh'];
$sec_is_sh = 'N';
$sec_is_sub = 'N';
if( isset($_POST['sec_is_sh']) )
{
$sec_is_sh = $_POST['sec_is_sh'];
}
if( isset($_POST['sec_is_sub']) )
{
$sec_is_sub = $_POST['sec_is_sub'];
}
$sec_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_add_l1'],
'address_line2' =>$_POST['sec_add_l2'],
'address_town' =>$_POST['sec_add_town'],
'address_city' => $_POST['sec_add_city'],
'address_postcode' => $_POST['sec_add_postcode'],
'address_country' => $_POST['sec_add_country'],
'address_type'=>'personal'
);
if($_POST['isEdit'] == 'Y'){
$person=$wpdb->get_row("select * from cf_person_details where person_company_id='".$_POST['company_id']."' and person_id='".$_POST['pid']."' order by person_id limit 1");
//address update
$result = $wpdb->update('cf_address_details', $sec_add_details_array ,array('address_id' => $person->person_address_id ));
$sec_add_id = $person->person_address_id;
//service address
$saddress=$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_service_address_id."'");
//same saddress...
if($saddress->address_type == $_POST['sa'] || ($saddress->address_type == 'own' && $_POST['sa'] == '0')){
if($saddress->address_type == 'service' || $saddress->address_type == 'own'){
$sec_sadd_id = $person->person_service_address_id;
$sec_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_sadd_l1'],
'address_line2' =>$_POST['sec_sadd_l2'],
'address_town' =>$_POST['sec_sadd_town'],
'address_city' => $_POST['sec_sadd_city'],
'address_postcode' => $_POST['sec_sadd_postcode'],
'address_country' => $_POST['sec_sadd_country'],
'address_type'=> $saddress->address_type
);
$result = $wpdb->update('cf_address_details', $sec_sadd_details_array ,array('address_id' => $person->person_service_address_id ));
}
}else{
//different saddress...
if(($saddress->address_type == 'contact' || $saddress->address_type == 'personal') && ($_POST['sa'] == 'service' || $_POST['sa'] == '0')){
//add new
if($_POST['sa'] == 'service'){
$sec_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_sadd_l1'],
'address_line2' =>$_POST['sec_sadd_l2'],
'address_town' =>$_POST['sec_sadd_town'],
'address_city' => $_POST['sec_sadd_city'],
'address_postcode' => $_POST['sec_sadd_postcode'],
'address_country' => $_POST['sec_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sec_sadd_details_array);
$sec_sadd_id =$wpdb->insert_id;
}else{
$sec_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_sadd_l1'],
'address_line2' =>$_POST['sec_sadd_l2'],
'address_town' =>$_POST['sec_sadd_town'],
'address_city' => $_POST['sec_sadd_city'],
'address_postcode' => $_POST['sec_sadd_postcode'],
'address_country' => $_POST['sec_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sec_sadd_details_array);
$sec_sadd_id =$wpdb->insert_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sec_sadd_id),array('person_id' => $person->person_id ),array('%d'));
}else if (($saddress->address_type == 'service' || $saddress->address_type == 'own') && ($_POST['sa'] == 'personal' || $_POST['sa'] == 'contact')){
//delete old
// Using where formatting.
$wpdb->delete( 'cf_address_details', array( 'address_id' => $person->person_service_address_id ), array( '%d' ) );
if($_POST['sa'] == 'personal'){
$sec_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'contact'){
$person2 = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sec_sadd_id = $person2->person_address_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sec_sadd_id),array('person_id' => $person->person_id ));
}
}
//personal id
$sec_pi_details_array = array(
'que1' => $_POST['sec_pi_q1'],
'que2' => $_POST['sec_pi_q2'],
'que3' =>$_POST['sec_pi_q3'],
'ans1' =>$_POST['sec_pi_a1'],
'ans2' => $_POST['sec_pi_a2'],
'ans3' => $_POST['sec_pi_a3']
);
$result = $wpdb->update('cf_personal_id_details', $sec_pi_details_array ,array('personal_id' => $person->person_personal_id ));
//share details
if($person->person_is_shareholder == 'Y' && $sec_is_sh == 'N'){
$wpdb->delete( 'cf_share_details', array( 'share_id' => $person->person_share_detail_id ), array( '%d' ) );
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => 0),array('person_id' => $person->person_id ),array('%d'));
}else if($person->person_is_shareholder == 'N' && $sec_is_sh == 'Y'){
$sec_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person->person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sec_share_details_array);
$sec_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $sec_share_detail_id),array('person_id' => $person->person_id ));
}
//personal details
$sec_details_array = array(
'person_name_title' => $_POST['sec_title'],
'person_name_fname' =>$_POST['sec_fname'],
'person_name_mname' =>$_POST['sec_mname'],
'person_name_surname' => $_POST['sec_surname'],
'person_dob' => $_POST['sec_dob'],
'person_nationality' => $_POST['sec_nationality'],
'person_is_subscriber' => $sec_is_sub,
'person_is_secretary' => 'Y',
'person_is_shareholder' => $sec_is_sh
);
$result = $wpdb->update('cf_person_details', $sec_details_array,array('person_id' => $person->person_id ));
$person_id = $person->person_id;
$sec_pi_id = $person->peron_personal_id;
}else{
$wpdb->insert('cf_address_details', $sec_add_details_array,$add_format);
$sec_add_id =$wpdb->insert_id;
if($_POST['sa'] == 'personal'){
$sec_sadd_id = $sec_add_id;
}else if($_POST['sa'] == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sec_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'service'){
$sec_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_sadd_l1'],
'address_line2' =>$_POST['sec_sadd_l2'],
'address_town' =>$_POST['sec_sadd_town'],
'address_city' => $_POST['sec_sadd_city'],
'address_postcode' => $_POST['sec_sadd_postcode'],
'address_country' => $_POST['sec_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sec_sadd_details_array,$add_format);
$sec_sadd_id =$wpdb->insert_id;
}else{
$sec_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sec_sadd_l1'],
'address_line2' =>$_POST['sec_sadd_l2'],
'address_town' =>$_POST['sec_sadd_town'],
'address_city' => $_POST['sec_sadd_city'],
'address_postcode' => $_POST['sec_sadd_postcode'],
'address_country' => $_POST['sec_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sec_sadd_details_array,$add_format);
$sec_sadd_id =$wpdb->insert_id;
}
$sec_pi_details_array = array(
'que1' => $_POST['sec_pi_q1'],
'que2' => $_POST['sec_pi_q2'],
'que3' =>$_POST['sec_pi_q3'],
'ans1' =>$_POST['sec_pi_a1'],
'ans2' => $_POST['sec_pi_a2'],
'ans3' => $_POST['sec_pi_a3']
);
$wpdb->insert('cf_personal_id_details', $sec_pi_details_array);
$sec_pi_id =$wpdb->insert_id;
$sec_details_array = array(
'person_company_id' => $_POST['company_id'],
'person_name_title' => $_POST['sec_title'],
'person_name_fname' =>$_POST['sec_fname'],
'person_name_mname' =>$_POST['sec_mname'],
'person_name_surname' => $_POST['sec_surname'],
'person_dob' => $_POST['sec_dob'],
'person_nationality' => $_POST['sec_nationality'],
'person_email' => $_POST['sec_email'],
'person_phone' => $_POST['sec_phone'],
'person_address_id' => $sec_add_id,
'person_service_address_id' => $sec_sadd_id,
'person_is_contact' => 'N',
'person_is_director' => 'N',
'person_is_partner' => 'N',
'person_is_secretary' => 'Y',
'person_is_shareholder' => $sec_is_sh,
'person_is_subscriber' => $sec_is_sub,
'person_personal_id'=> $sec_pi_id
);
$wpdb->insert('cf_person_details', $sec_details_array);
$person_id = $wpdb->insert_id;
if($sec_is_sh == 'Y'){
$sec_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sec_share_details_array);
$sec_share_detail_id =$wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $sec_share_detail_id),array('person_id' => $person_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
}
}
$response_sec_array = array('SUCCESS' => 'Success','pid'=>$person_id,'add_id' => $sec_add_id,'sadd_id' => $sec_sadd_id,'pi_id' => $sec_pi_id);
return die(json_encode($response_sec_array));
}
function cf_add_company_shareholder(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$sh_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_add_l1'],
'address_line2' =>$_POST['sh_add_l2'],
'address_town' =>$_POST['sh_add_town'],
'address_city' => $_POST['sh_add_city'],
'address_postcode' => $_POST['sh_add_postcode'],
'address_country' => $_POST['sh_add_country'],
'address_type'=>'personal'
);
if($_POST['isEdit'] == 'Y'){
$person=$wpdb->get_row("select * from cf_person_details where person_company_id='".$_POST['company_id']."' and person_id='".$_POST['pid']."' order by person_id limit 1");
//address update
$result = $wpdb->update('cf_address_details', $sh_add_details_array ,array('address_id' => $person->person_address_id ));
$sh_add_id = $person->person_address_id;
//service address
$saddress=$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_service_address_id."'");
//same saddress...
if($saddress->address_type == $_POST['sa'] || ($saddress->address_type == 'own' && $_POST['sa'] == '0')){
if($saddress->address_type == 'service' || $saddress->address_type == 'own'){
$sh_sadd_id = $person->person_service_address_id;
$sh_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_sadd_l1'],
'address_line2' =>$_POST['sh_sadd_l2'],
'address_town' =>$_POST['sh_sadd_town'],
'address_city' => $_POST['sh_sadd_city'],
'address_postcode' => $_POST['sh_sadd_postcode'],
'address_country' => $_POST['sh_sadd_country'],
'address_type'=> $saddress->address_type
);
$result = $wpdb->update('cf_address_details', $sh_sadd_details_array ,array('address_id' => $person->person_service_address_id ));
}
}else{
//different saddress...
if(($saddress->address_type == 'contact' || $saddress->address_type == 'personal') && ($_POST['sa'] == 'service' || $_POST['sa'] == '0')){
//add new
if($_POST['sa'] == 'service'){
$sh_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_sadd_l1'],
'address_line2' =>$_POST['sh_sadd_l2'],
'address_town' =>$_POST['sh_sadd_town'],
'address_city' => $_POST['sh_sadd_city'],
'address_postcode' => $_POST['sh_sadd_postcode'],
'address_country' => $_POST['sh_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sh_sadd_details_array);
$sh_sadd_id =$wpdb->insert_id;
}else{
$sh_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_sadd_l1'],
'address_line2' =>$_POST['sh_sadd_l2'],
'address_town' =>$_POST['sh_sadd_town'],
'address_city' => $_POST['sh_sadd_city'],
'address_postcode' => $_POST['sh_sadd_postcode'],
'address_country' => $_POST['sh_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sh_sadd_details_array);
$sh_sadd_id =$wpdb->insert_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sh_sadd_id),array('person_id' => $person->person_id ),array('%d'));
}else if (($saddress->address_type == 'service' || $saddress->address_type == 'own') && ($_POST['sa'] == 'personal' || $_POST['sa'] == 'contact')){
//delete old
// Using where formatting.
$wpdb->delete( 'cf_address_details', array( 'address_id' => $person->person_service_address_id ), array( '%d' ) );
if($_POST['sa'] == 'personal'){
$sh_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'contact'){
$person2 = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sh_sadd_id = $person2->person_address_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sh_sadd_id),array('person_id' => $person->person_id ));
}
}
//personal id
$sh_pi_details_array = array(
'que1' => $_POST['sh_pi_q1'],
'que2' => $_POST['sh_pi_q2'],
'que3' =>$_POST['sh_pi_q3'],
'ans1' =>$_POST['sh_pi_a1'],
'ans2' => $_POST['sh_pi_a2'],
'ans3' => $_POST['sh_pi_a3']
);
$result = $wpdb->update('cf_personal_id_details', $sh_pi_details_array ,array('personal_id' => $person->person_personal_id ));
//share details
if($person->person_is_shareholder == 'Y' ){
$wpdb->delete( 'cf_share_details', array( 'share_id' => $person->person_share_detail_id ), array( '%d' ) );
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => 0),array('person_id' => $person->person_id ),array('%d'));
}else if($person->person_is_shareholder == 'N' && $sh_is_sh == 'Y'){
$sh_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person->person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sh_share_details_array);
$sh_share_detail_id = $wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $sh_share_detail_id),array('person_id' => $person->person_id ));
}
//personal details
$sh_details_array = array(
'person_name_title' => $_POST['sh_title'],
'person_name_fname' =>$_POST['sh_fname'],
'person_name_mname' =>$_POST['sh_mname'],
'person_name_surname' => $_POST['sh_surname'],
'person_dob' => $_POST['sh_dob'],
'person_nationality' => $_POST['sh_nationality'],
'person_is_shareholder' => 'Y'
);
$result = $wpdb->update('cf_person_details', $sh_details_array,array('person_id' => $person->person_id ));
$person_id = $person->person_id;
$sh_pi_id = $person->peron_personal_id;
}else{
$wpdb->insert('cf_address_details', $sh_add_details_array,$add_format);
$sh_add_id =$wpdb->insert_id;
if($_POST['sa'] == 'personal'){
$sh_sadd_id = $sh_add_id;
}else if($_POST['sa'] == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sh_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'service'){
$sh_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_sadd_l1'],
'address_line2' =>$_POST['sh_sadd_l2'],
'address_town' =>$_POST['sh_sadd_town'],
'address_city' => $_POST['sh_sadd_city'],
'address_postcode' => $_POST['sh_sadd_postcode'],
'address_country' => $_POST['sh_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sh_sadd_details_array,$add_format);
$sh_sadd_id =$wpdb->insert_id;
}else{
$sh_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sh_sadd_l1'],
'address_line2' =>$_POST['sh_sadd_l2'],
'address_town' =>$_POST['sh_sadd_town'],
'address_city' => $_POST['sh_sadd_city'],
'address_postcode' => $_POST['sh_sadd_postcode'],
'address_country' => $_POST['sh_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sh_sadd_details_array,$add_format);
$sh_sadd_id =$wpdb->insert_id;
}
$sh_pi_details_array = array(
'que1' => $_POST['sh_pi_q1'],
'que2' => $_POST['sh_pi_q2'],
'que3' =>$_POST['sh_pi_q3'],
'ans1' =>$_POST['sh_pi_a1'],
'ans2' => $_POST['sh_pi_a2'],
'ans3' => $_POST['sh_pi_a3']
);
$wpdb->insert('cf_personal_id_details', $sh_pi_details_array);
$sh_pi_id =$wpdb->insert_id;
$sh_details_array = array(
'person_company_id' => $_POST['company_id'],
'person_name_title' => $_POST['sh_title'],
'person_name_fname' =>$_POST['sh_fname'],
'person_name_mname' =>$_POST['sh_mname'],
'person_name_surname' => $_POST['sh_surname'],
'person_dob' => $_POST['sh_dob'],
'person_nationality' => $_POST['sh_nationality'],
'person_email' => $_POST['sh_email'],
'person_phone' => $_POST['sh_phone'],
'person_address_id' => $sh_add_id,
'person_service_address_id' => $sh_sadd_id,
'person_is_contact' => 'N',
'person_is_director' => 'N',
'person_is_partner' => 'N',
'person_is_secretary' => 'N',
'person_is_subscriber' => 'N',
'person_is_shareholder' => 'Y',
'person_personal_id'=> $sh_pi_id
);
$wpdb->insert('cf_person_details', $sh_details_array);
$person_id = $wpdb->insert_id;
$sh_share_details_array = array(
'share_company_id' => $_POST['company_id'],
'share_person_id' => $person_id,
'share_allot' =>$_POST['share_allot'],
'share_currency' =>$_POST['share_currency'],
'share_value' => $_POST['share_value']
);
$wpdb->insert('cf_share_details', $sh_share_details_array);
$sh_share_detail_id =$wpdb->insert_id;
$result = $wpdb->update('cf_person_details', array('person_share_detail_id' => $sh_share_detail_id),array('person_id' => $person_id ),array('%d'));
if($result > 0){
//echo "Successfully Updated";
}
}
$response_sh_array = array('SUCCESS' => 'Success','pid'=>$person_id,'add_id' => $sh_add_id,'sadd_id' => $sh_sadd_id,'pi_id' => $sh_pi_id);
return die(json_encode($response_sh_array));
}
function cf_add_company_subscriber(){
global $wpdb;
$add_format = array(
'%d', //data type is string
'%s',
'%s',
'%s',
'%s',
'%s',
'%s',
'%s');
$sub_add_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_add_l1'],
'address_line2' =>$_POST['sub_add_l2'],
'address_town' =>$_POST['sub_add_town'],
'address_city' => $_POST['sub_add_city'],
'address_postcode' => $_POST['sub_add_postcode'],
'address_country' => $_POST['sub_add_country'],
'address_type'=>'personal'
);
if($_POST['isEdit'] == 'Y'){
$person=$wpdb->get_row("select * from cf_person_details where person_company_id='".$_POST['company_id']."' and person_id='".$_POST['pid']."' order by person_id limit 1");
//address update
$result = $wpdb->update('cf_address_details', $sub_add_details_array ,array('address_id' => $person->person_address_id ));
$sub_add_id = $person->person_address_id;
//service address
$saddress=$wpdb->get_row("SELECT * FROM cf_address_details where address_id='".$person->person_service_address_id."'");
//same saddress...
if($saddress->address_type == $_POST['sa'] || ($saddress->address_type == 'own' && $_POST['sa'] == '0')){
if($saddress->address_type == 'service' || $saddress->address_type == 'own'){
$sub_sadd_id = $person->person_service_address_id;
$sub_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_sadd_l1'],
'address_line2' =>$_POST['sub_sadd_l2'],
'address_town' =>$_POST['sub_sadd_town'],
'address_city' => $_POST['sub_sadd_city'],
'address_postcode' => $_POST['sub_sadd_postcode'],
'address_country' => $_POST['sub_sadd_country'],
'address_type'=> $saddress->address_type
);
$result = $wpdb->update('cf_address_details', $sub_sadd_details_array ,array('address_id' => $person->person_service_address_id ));
}
}else{
//different saddress...
if(($saddress->address_type == 'contact' || $saddress->address_type == 'personal') && ($_POST['sa'] == 'service' || $_POST['sa'] == '0')){
//add new
if($_POST['sa'] == 'service'){
$sub_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_sadd_l1'],
'address_line2' =>$_POST['sub_sadd_l2'],
'address_town' =>$_POST['sub_sadd_town'],
'address_city' => $_POST['sub_sadd_city'],
'address_postcode' => $_POST['sub_sadd_postcode'],
'address_country' => $_POST['sub_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sub_sadd_details_array);
$sub_sadd_id =$wpdb->insert_id;
}else{
$sub_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_sadd_l1'],
'address_line2' =>$_POST['sub_sadd_l2'],
'address_town' =>$_POST['sub_sadd_town'],
'address_city' => $_POST['sub_sadd_city'],
'address_postcode' => $_POST['sub_sadd_postcode'],
'address_country' => $_POST['sub_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sub_sadd_details_array);
$sub_sadd_id =$wpdb->insert_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sub_sadd_id),array('person_id' => $person->person_id ),array('%d'));
}else if (($saddress->address_type == 'service' || $saddress->address_type == 'own') && ($_POST['sa'] == 'personal' || $_POST['sa'] == 'contact')){
//delete old
// Using where formatting.
$wpdb->delete( 'cf_address_details', array( 'address_id' => $person->person_service_address_id ), array( '%d' ) );
if($_POST['sa'] == 'personal'){
$sub_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'contact'){
$person2 = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sub_sadd_id = $person2->person_address_id;
}
$result = $wpdb->update('cf_person_details', array('person_service_address_id' => $sub_sadd_id),array('person_id' => $person->person_id ));
}
}
//personal id
$sub_pi_details_array = array(
'que1' => $_POST['sub_pi_q1'],
'que2' => $_POST['sub_pi_q2'],
'que3' =>$_POST['sub_pi_q3'],
'ans1' =>$_POST['sub_pi_a1'],
'ans2' => $_POST['sub_pi_a2'],
'ans3' => $_POST['sub_pi_a3']
);
$result = $wpdb->update('cf_personal_id_details', $sub_pi_details_array ,array('personal_id' => $person->person_personal_id ));
//personal details
$sub_details_array = array('person_name_title' => $_POST['sub_title'],
'person_name_fname' =>$_POST['sub_fname'], 'person_name_mname' =>$_POST['sub_mname'], 'person_name_surname' => $_POST['sub_surname'], 'person_dob' => $_POST['sub_dob'], 'person_nationality' => $_POST['sub_nationality'], 'person_is_subscriber' => 'Y', 'person_amount_guaranteed' => $_POST['g_amount']);
$result = $wpdb->update('cf_person_details', $sub_details_array,array('person_id' => $person->person_id ));
$person_id = $person->person_id;
$sub_pi_id = $person->peron_personal_id;
}else{
$wpdb->insert('cf_address_details', $sub_add_details_array,$add_format);
$sub_add_id =$wpdb->insert_id;
if($_POST['sa'] == 'personal'){
$sub_sadd_id = $sub_add_id;
}else if($_POST['sa'] == 'contact'){
$person = $wpdb->get_row("SELECT * FROM cf_person_details where person_company_id='".$_POST['company_id']."' and person_is_contact='Y' order by person_company_id limit 1");
$sub_sadd_id = $person->person_address_id;
}else if($_POST['sa'] == 'service'){
$sub_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_sadd_l1'],
'address_line2' =>$_POST['sub_sadd_l2'],
'address_town' =>$_POST['sub_sadd_town'],
'address_city' => $_POST['sub_sadd_city'],
'address_postcode' => $_POST['sub_sadd_postcode'],
'address_country' => $_POST['sub_sadd_country'],
'address_type'=>'service'
);
$wpdb->insert('cf_address_details', $sub_sadd_details_array,$add_format);
$sub_sadd_id =$wpdb->insert_id;
}else{
$sub_sadd_details_array = array(
'address_company_id' => $_POST['company_id'],
'address_line1' => $_POST['sub_sadd_l1'],
'address_line2' =>$_POST['sub_sadd_l2'],
'address_town' =>$_POST['sub_sadd_town'],
'address_city' => $_POST['sub_sadd_city'],
'address_postcode' => $_POST['sub_sadd_postcode'],
'address_country' => $_POST['sub_sadd_country'],
'address_type'=>'own'
);
$wpdb->insert('cf_address_details', $sub_sadd_details_array,$add_format);
$sub_sadd_id =$wpdb->insert_id;
}
$sub_pi_details_array = array(
'que1' => $_POST['sub_pi_q1'],
'que2' => $_POST['sub_pi_q2'],
'que3' =>$_POST['sub_pi_q3'],
'ans1' =>$_POST['sub_pi_a1'],
'ans2' => $_POST['sub_pi_a2'],
'ans3' => $_POST['sub_pi_a3']
);
$wpdb->insert('cf_personal_id_details', $sub_pi_details_array);
$sub_pi_id =$wpdb->insert_id;
$sub_details_array = array(
'person_company_id' => $_POST['company_id'],
'person_name_title' => $_POST['sub_title'],
'person_name_fname' =>$_POST['sub_fname'],
'person_name_mname' =>$_POST['sub_mname'],
'person_name_surname' => $_POST['sub_surname'],
'person_dob' => $_POST['sub_dob'],
'person_nationality' => $_POST['sub_nationality'],
'person_address_id' => $sub_add_id,
'person_service_address_id' => $sub_sadd_id,
//'person_is_contact' => 'N',
//'person_is_director' => 'N',
//'person_is_partner' => 'N',
//'person_is_secretary' => 'N',
//'person_is_shareholder' => 'N',
'person_is_subscriber' => 'Y',
'person_personal_id'=> $sub_pi_id,
'person_amount_guaranteed'=>$_POST['g_amount']
);
$wpdb->insert('cf_person_details', $sub_details_array);
$person_id = $wpdb->insert_id;
}
$response_sub_array = array('SUCCESS' => 'Success','pid'=>$person_id,'add_id' => $sub_add_id,'sadd_id' => $sub_sadd_id,'pi_id' => $sub_pi_id);
return die(json_encode($response_sub_array));
}
function cf_get_person_details(){
global $wpdb;
$person_id = $_POST['person_id'];
$cid = $_POST['company_id'];
if($person_id != '' && $cid != ''){
$person_query = "SELECT * FROM cf_person_details where person_company_id='".$cid."' and person_id='".$person_id."'";
$person_array = $wpdb->get_results($person_query, ARRAY_A);
return die(json_encode($person_array));
}
}
function cf_get_address_details(){
global $wpdb;
$address_id = $_POST['address_id'];
$cid = $_POST['company_id'];
if($address_id != '' && $cid != ''){
$address_query = "SELECT * FROM cf_address_details where address_company_id='".$cid."' and address_id='".$address_id."'";
$address_array = $wpdb->get_results($address_query, ARRAY_A);
return die(json_encode($address_array));
}
}
function cf_add_psc_details(){
global $wpdb;
$psc_details_array = array(
'psc_person_id' => $_POST['psc_person_id'],
'psc_company_id' => $_POST['psc_company_id'],
'psc_noc_id' =>$_POST['psc_noc_id'],
'psc_name_title' =>$_POST['title'],
'psc_fname' =>$_POST['fname'],
'psc_mname' =>$_POST['mname'],
'psc_surname' =>$_POST['sname'],
'psc_dob'=>$_POST['dob'],
'psc_nationality'=>$_POST['nationality'],
'psc_add_l1'=>$_POST['add_l1'],
'psc_add_l2'=>$_POST['add_l2'],
'psc_add_town'=>$_POST['add_town'],
'psc_add_city'=>$_POST['add_city'],
'psc_add_postcode'=>$_POST['add_postcode'],
'psc_add_country'=>$_POST['add_country'],
'psc_corr_add'=>$_POST['ca']
);
$wpdb->insert('cf_psc_details', $psc_details_array);
$psc_id = $wpdb->insert_id;
$response_psc_array = array('SUCCESS' => 'Success','psc_id'=>$psc_id);
return die(json_encode($response_psc_array));
}
function cf_add_aoa_details(){
global $wpdb;
$aoa_details_array = array(
'aoa_company_id' => $_POST['aoa_company_id'],
'aoa_objective' =>$_POST['aoa_objective'],
'aoa_is_file_upload' => $_POST['aoa_is_file_upload'],
'aoa_file_name' => $_POST['aoa_file_name'],
'aoa_file_base64' =>$_POST['aoa_file_base64']
);
$wpdb->insert('cf_aoa_details', $aoa_details_array,array(
'%d',
'%s',
'%s',
'%s',
'%s'
));
$aoa_id = $wpdb->insert_id;
$response_aoa_array = array('SUCCESS' => 'Success','aoa_id'=>$aoa_id);
return die(json_encode($response_aoa_array));
}
function cf_add_ryb_details(){
$response_aoa_array = array('SUCCESS' => 'Success','aoa_id'=>$aoa_id);
return die(json_encode($response_aoa_array));
}
add_action( 'wp_ajax_cf_add_ryb_details', 'cf_add_ryb_details');
add_action( 'wp_ajax_cf_stripe_charge', 'cf_stripe_charge');
add_action( 'wp_ajax_nopriv_cf_stripe_charge', 'cf_stripe_charge');
add_action( 'wp_ajax_cf_add_company', 'cf_add_company');
add_action( 'wp_ajax_cf_add_optional_extra', 'cf_add_optional_extra');
add_action( 'wp_ajax_cf_add_sic_to_company', 'cf_add_sic_to_company');
add_action( 'wp_ajax_cf_address_select', 'cf_address_select');
add_action( 'wp_ajax_cf_add_registered_office', 'cf_add_registered_office');
add_action( 'wp_ajax_cf_add_company_contact', 'cf_add_company_contact' );
add_action( 'wp_ajax_cf_add_company_director', 'cf_add_company_director' );
add_action( 'wp_ajax_cf_add_company_partner', 'cf_add_company_partner' );
add_action( 'wp_ajax_cf_add_company_corporate_director', 'cf_add_company_corporate_director' );
add_action( 'wp_ajax_cf_add_company_corporate_partner', 'cf_add_company_corporate_partner' );
add_action( 'wp_ajax_cf_add_company_corporate_secretary', 'cf_add_company_corporate_secretary' );
add_action( 'wp_ajax_cf_add_company_corporate_shareholder', 'cf_add_company_corporate_shareholder' );
add_action( 'wp_ajax_cf_add_company_corporate_subscriber', 'cf_add_company_corporate_subscriber' );
add_action( 'wp_ajax_cf_add_company_secretary', 'cf_add_company_secretary' );
add_action( 'wp_ajax_cf_add_company_shareholder', 'cf_add_company_shareholder' );
add_action( 'wp_ajax_cf_add_company_subscriber', 'cf_add_company_subscriber' );
add_action( 'wp_ajax_cf_get_person_details', 'cf_get_person_details');
add_action( 'wp_ajax_cf_get_address_details', 'cf_get_address_details');
add_action( 'wp_ajax_cf_add_psc_details', 'cf_add_psc_details');
add_action( 'wp_ajax_cf_add_aoa_details', 'cf_add_aoa_details');
add_action( 'wp_ajax_nopriv_cf_add_company', 'cf_add_company');
add_action( 'wp_ajax_nopriv_cf_add_optional_extra', 'cf_add_optional_extra');
add_action( 'wp_ajax_nopriv_cf_add_sic_to_company', 'cf_add_sic_to_company');
add_action( 'wp_ajax_nopriv_cf_add_registered_office', 'cf_add_registered_office');
add_action( 'wp_ajax_nopriv_cf_address_select', 'cf_address_select');
add_action( 'wp_ajax_nopriv_cf_add_company_contact', 'cf_add_company_contact' );
add_action( 'wp_ajax_nopriv_cf_add_company_director', 'cf_add_company_director' );
add_action( 'wp_ajax_nopriv_cf_add_company_partner', 'cf_add_company_partner' );
add_action( 'wp_ajax_nopriv_cf_add_company_corporate_director', 'cf_add_company_corporate_director' );
add_action( 'wp_ajax_nopriv_cf_add_company_corporate_partner', 'cf_add_company_corporate_partner' );
add_action( 'wp_ajax_nopriv_cf_add_company_corporate_secretary', 'cf_add_company_corporate_secretary' );
add_action( 'wp_ajax_nopriv_cf_add_company_corporate_shareholder', 'cf_add_company_corporate_shareholder' );
add_action( 'wp_ajax_nopriv_cf_add_company_corporate_subscriber', 'cf_add_company_corporate_subscriber' );
add_action( 'wp_ajax_nopriv_cf_add_company_secretary', 'cf_add_company_secretary' );
add_action( 'wp_ajax_nopriv_cf_add_company_shareholder', 'cf_add_company_shareholder' );
add_action( 'wp_ajax_nopriv_cf_add_company_subscriber', 'cf_add_company_subscriber' );
add_action( 'wp_ajax_nopriv_cf_get_person_details', 'cf_get_person_details');
add_action( 'wp_ajax_nopriv_cf_get_address_details', 'cf_get_address_details');
add_action( 'wp_ajax_nopriv_cf_add_psc_details', 'cf_add_psc_details');
add_action( 'wp_ajax_nopriv_cf_add_aoa_details', 'cf_add_aoa_details');
add_action( 'wp_ajax_nopriv_cf_add_ryb_details', 'cf_add_ryb_details');
add_action('wp_ajax_my_ajax_function', 'my_ajax_function');
add_action('wp_ajax_my_ajax_company_type', 'my_ajax_company_type');
add_action('wp_ajax_nopriv_my_ajax_company_type', 'my_ajax_company_type');
add_action('wp_ajax_nopriv_my_ajax_function', 'my_ajax_function');
add_action('wp_ajax_my_ajax_director_function', 'my_ajax_director_function');
add_action('wp_ajax_nopriv_my_ajax_director_function', 'my_ajax_director_function');
add_action('wp_ajax_my_ajax_email_submit_function', 'my_ajax_email_submit_function');
add_action('wp_ajax_nopriv_my_ajax_email_submit_function', 'my_ajax_email_submit_function');
add_action('wp_ajax_my_ajax_sic_code', 'my_ajax_sic_code');
add_action('wp_ajax_nopriv_my_ajax_sic_code', 'my_ajax_sic_code');
add_action( 'wp_ajax_cf_sendrequest', 'cf_sendrequest' );
add_action( 'wp_ajax_nopriv_cf_sendrequest', 'cf_sendrequest' );
add_action( 'wp_ajax_cf_add_nominee', 'cf_add_nominee' );
add_action( 'wp_ajax_nopriv_cf_add_nominee', 'cf_add_nominee' );
add_action( 'wp_ajax_cf_testsendrequest', 'cf_testsendrequest' );
add_action( 'wp_ajax_nopriv_cf_testsendrequest', 'cf_testsendrequest' );
?>