File: /www/exchange0old/exchange/classes/Model/MIntermediaryInvOrg.php
<?php
include_once('admin/classes/Model/base_actions.php');
class Model_MIntermediaryInvOrg extends Base_actions
{
function orgType($cboname,$curid,$tablename)
{
$output .='<select name='.trim($cboname).' class=cmb_bx1 id='.trim($cboname).' tabindex="3">';
$output .= '<option value="0">Select</option>';
$optSql ="select * from $tablename WHERE label_type='1'";
$optResult =mysql_query($optSql);
while($optRow=mysql_fetch_array($optResult)) {
if($optRow[0]==$curid)
$output .= '<option value='.$optRow[0].' selected>'.$optRow[2].'</option>';
else
$output .= '<option value='.$optRow[0].'>'.$optRow[2].'</option>';
}
$output .= '</select>';
return $output;
}
function CreateOptionBusinessentitytype($cboname,$curid,$tablename) {
$output .= '<select name='.trim($cboname).' class=cmb_bx1 id='.trim($cboname).' tabindex="10">';
$output .= '<option value="0">Select</option>';
$optSql = "select * from $tablename WHERE label_type='2'";
$optResult = mysql_query($optSql);
while($optRow=mysql_fetch_array($optResult)) {
if($optRow[0]==$curid)
$output .= '<option value='.$optRow[0].' selected>'.$optRow[2].'</option>';
else
$output .= '<option value='.$optRow[0].'>'.$optRow[2].'</option>';
}
$output .= '</select>';
return $output;
}
function addBranch($record,$errmsg,$errval)
{
$k=0;
for($i=0;$i<$record;$i++)
{
$k =$i+1;
$output .='<tr>
<td align="left" valign="top" class="inves_top"><b>Branch Office Address #'.$k.'</b></td>
</tr><tr class="very_lite_gray">
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="left" valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Address Line 1 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="orgb_addr1[]" id="orgb_addr1'.$i.'" value="'.$errval['orgb_addr1'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['orgb_addr1'.$i.''].'</span></td>
<td width="10%" align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">Address Line 2 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="orgb_addr2[]" id="orgb_addr2'.$i.'" value="'.$errval['orgb_addr2'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['orgb_addr2'.$i.''].'</span></td>
<td align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">City :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="orgb_city[]" id="orgb_city'.$i.'" value="'.$errval['orgb_city'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['orgb_city'.$i.''].'</AJDF:output></span></td>
<td align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">State :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="orgb_state[]" id="orgb_state'.$i.'" value="'.$errval['orgb_state'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['orgb_state'.$i.''].'</span></td>
<td align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Country :</td>
<td width="53%" align="left" valign="middle">';
$output.= '<select name="orgb_country[]" class=cmb_bx1 id="orgb_country'.$i.'" >
<option value="0">Select</option>';
$optSql ="select * from country_mas";
$optResult =mysql_query($optSql);
while($optRow=mysql_fetch_array($optResult)) {
if($optRow[0]==$errval['orgb_country'][$i])
$output .= '<option value='.$optRow[0].' selected>'.$optRow[1].'</option>';
else
$output .= '<option value='.$optRow[0].'>'.$optRow[1].'</option>';
}
$output.= '</select>';
$output.= '<br/><span style="color:#FF0000">'.$errmsg['orgb_country'.$i.''].'</span><br/></td>
<td align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
</table></td>
<td align="center" valign="middle" class="gray_1"></td>
<td width="50%" align="center" valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="2">
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle"> Post code :</td>
<td width="53%" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="57%" align="left" valign="top"><input type="text" value="'.$errval['orgb_pc'][$i].'" name="orgb_pc[]" id="orgb_pc'.$i.'" size="8" maxlength="8" class="text_b"/></td>
<td width="43%" align="left" valign="top"> </td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['orgb_pc'.$i.''].'</span></td>
<td align="right" valign="middle"><a href="#" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="top">Phone Number :</td>
<td width="53%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['orgb_pn_country'][$i].'" name="orgb_pn_country[]" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['orgb_pn_area'][$i].'" name="orgb_pn_area[]" id="orgb_pn_area'.$i.'" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['orgb_pn_pn'][$i].'" name="orgb_pn_pn[]" id="orgb_pn_pn'.$i.'" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['orgb_pn_pn'.$i.''].'</span></td>
<td align="right" valign="top"><span id="b7"><a title="'.$arr[91].'" class="under">(?)</a></span></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="top">Fax Number :</td>
<td width="53%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['orgb_fn_country'][$i].'" name="orgb_fn_country[]" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['orgb_fn_area'][$i].'" name="orgb_fn_area[]" id="orgb_fn_area'.$i.'" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['orgb_fn_pn'][$i].'" name="orgb_fn_pn[]" id="orgb_fn_pn'.$i.'" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['orgb_fn_pn'.$i.''].'</span></td>
<td align="right" valign="top"><span id="b8"><a title="'.$arr[92].'" class="under">(?)</a></span></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Email Address :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="orgb_email[]" id="orgb_email'.$i.'" value="'.$errval['orgb_email'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'. $errmsg['orgb_email'.$i.''].'</span></td>
<td align="right" valign="middle"><span id="b9"><a title="'.$arr[93].'" class="under">(?)</a></span></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>';
}
return $output;
}
function getAddressDropDown($select){
$output .='<select name="address_select" id="address_select" class="cmb_bx1" tabindex="30" onchange="choseaddress(this.value, false);showSelectedRegaddr();"><option value="">Select</option>';
$output .='<option value="1" ';
if($select == 1) $output .='selected="selected"';
$output .=' >Registered Office Address</option>';
$output .='<option value="0"';
if($select == "0") $output .='selected="selected"';
$output .=' >Other</option></select>';
return $output;
}
function insertInvestorCurrencyOne()
{
$org_field_sql ="INSERT INTO address_details(address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax) values('".trim($_POST['orgc_ph_country'])."','".trim($_POST['orgc_ph_area'])."','".trim($_POST['orgc_ph_pn'])."','".trim($_POST['orgc_fn_country'])."','".trim($_POST['orgc_fn_area'])."','".trim($_POST['orgc_fn_pn'])."')";
if($org_user_result=mysql_query($org_field_sql))
{
$orgaddr_addressid =mysql_insert_id();
}
$insert_field_sql ="INSERT INTO address_details(address_line_one,address_line_two,address_country,address_zipcode,address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax,address_email,address_state,address_city) values('".trim($_POST['orgcaddr1'])."','".trim($_POST['orgc_addr2'])."','".trim($_POST['orgc_country'])."','".trim($_POST['orgc_pc'])."','".trim($_POST['orgc_ph_country'])."','".trim($_POST['orgc_ph_area'])."','".trim($_POST['orgc_ph_pn'])."','".trim($_POST['orgc_fn_country'])."','".trim($_POST['orgc_fn_area'])."','".trim($_POST['orgc_fn_pn'])."','".trim($_POST['orgc_email'])."','".trim($_POST['orgc_state'])."','".trim($_POST['orgc_city'])."')";
if($insert_user_result=mysql_query($insert_field_sql))
{
// $contact_address_id = mysql_insert_id;
$_SESSION['reg_id'] =$regoff_addressid=mysql_insert_id();
}
$insert_field_sql1 ="INSERT INTO address_details(address_line_one,address_line_two,address_country,address_zipcode,address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax,address_email,address_state,address_city) values('".trim($_POST['orgp_add1'])."','".trim($_POST['orgp_add2'])."','".trim($_POST['orgp_country'])."','".trim($_POST['orgp_pc'])."','".trim($_POST['orgp_pn_country'])."','".trim($_POST['orgp_pn_area'])."','".trim($_POST['orgp_pn_pn'])."','".trim($_POST['orgp_fx_country'])."','".trim($_POST['orgp_fx_area'])."','".trim($_POST['orgp_fx_pn'])."','".trim($_POST['orgp_email'])."','".trim($_POST['orgp_state'])."','".trim($_POST['orgp_city'])."')";
if($insert_user_result1=mysql_query($insert_field_sql1))
{
$_SESSION['primary_id'] = $pritrad_addressid1=mysql_insert_id();
}
for($i=0;$i<count($_POST['orgb_addr1']);$i++)
{
$insert_field_sql2 ="INSERT INTO address_details(address_line_one,address_line_two,address_country,address_zipcode,address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax,address_email,address_state,address_city) values('".trim($_POST['orgb_addr1'][$i])."','".trim($_POST['orgb_addr2'][$i])."','".trim($_POST['orgb_country'][$i])."','".trim($_POST['orgb_pc'][$i])."','".trim($_POST['orgb_pn_country'][$i])."','".trim($_POST['orgb_pn_area'][$i])."','".trim($_POST['orgb_pn_pn'][$i])."','".trim($_POST['orgb_fn_country'][$i])."','".trim($_POST['orgb_fn_area'][$i])."','".trim($_POST['orgb_fn_pn'][$i])."','".trim($_POST['orgb_email'][$i])."','".trim($_POST['orgb_state'][$i])."','".trim($_POST['orgb_city'][$i])."')";
if($insert_user_result2=mysql_query($insert_field_sql2))
{
$branch_addressid =mysql_insert_id();
$br_det_sql2 ="INSERT INTO organisation_branch_details(organisation_id,address_id) values('".trim($org_id)."','".trim($branch_addressid)."')";
$br_det_result2 =mysql_query($br_det_sql2);
}
$_SESSION['branch_id'][] = $branch_addressid;
}
$query = new Bin_Query();
$sql = "SELECT * FROM `organisation_branch_details` where `organisation_id` ='".$_SESSION['organisation_id']."'";
$query->executeQuery($sql);
$branch = $query->records;
$sub_date=$_POST['sub_year'].'-'.$_POST['sub_month'].'-'.$_POST['sub_date'];
if(count($branch) > 0)
{
$query = new Bin_Query();
$insert_field_org ="UPDATE organisation_details SET user_id='".$_SESSION['user']['invuserid']."',organisation_name='".addslashes(trim($_POST['org_organisationname']))."',organisation_trade_name='".addslashes(trim($_POST['org_organizationtradename']))."',organisation_type='".trim($_POST['org_orgtype'])."',organisation_overview='".trim($_POST['org_orgoverview'])."',business_entity_type='".trim($_POST['org_bentitytype'])."',organisation_jurisdiction='".trim($_POST['org_jurorg'])."',parent_company_name='".trim($_POST['org_pcdetail'])."',formation_year='".trim($_POST['org_form_year'])."',website='".trim($_POST['org_website'])."',tax_number='".trim($_POST['org_ctn'])."',vat_number='".trim($_POST['org_vat'])."',organisation_address_id='".trim($orgaddr_addressid)."',organisation_regoffice_id='".trim($regoff_addressid)."',mail_address_id='".trim($pritrad_addressid1)."',billing_address_id='".trim($branch_addressid)."',submitter_firstname='".trim($_POST['sub_fname'])."',submitter_lastname='".trim($_POST['sub_lname'])."',submitted_date='".trim($sub_date)."',submitter_legally_approved='".trim($_POST['sub_approvel'])."',application_status='0',application_step='1',modified_at='".date('Y-m-d h:i:s')."' WHERE organisation_id='".$_SESSION['organisation_id']."'";
$query->updateQuery($insert_field_org);
$org_id =$_SESSION['organisation_id'];
}
else
{
$query = new Bin_Query();
$insert_field_org ="INSERT INTO organisation_details(user_id,organisation_name,organisation_trade_name, organisation_type,organisation_overview,business_entity_type,organisation_jurisdiction,parent_company_name,formation_year,website,tax_number,vat_number,organisation_address_id,organisation_regoffice_id,mail_address_id,billing_address_id,submitter_firstname,submitter_lastname,submitted_date,submitter_legally_approved,application_status,application_step,modified_at,created_at,created_by)
VALUES('".$_SESSION['user']['invuserid']."','".addslashes(trim($_POST['org_organisationname']))."','".addslashes(trim($_POST['org_organizationtradename']))."','".trim($_POST['org_orgtype'])."','".trim($_POST['org_orgoverview'])."','".trim($_POST['org_bentitytype'])."','".trim($_POST['org_jurorg'])."','".trim($_POST['org_pcdetail'])."','".trim($_POST['org_form_year'])."','".trim($_POST['org_website'])."','".trim($_POST['org_ctn'])."','".trim($_POST['org_vat'])."','".trim($orgaddr_addressid)."','".trim($regoff_addressid)."','".trim($pritrad_addressid1)."','".trim($branch_addressid)."','".trim($_POST['sub_fname'])."','".trim($_POST['sub_lname'])."','".trim($sub_date)."','".trim($_POST['sub_approvel'])."','0','1','".date('Y-m-d h:i:s')."',NOW(),'".$_SESSION['user']['invuserid']."')";
$query->updateQuery($insert_field_org);
$_SESSION['organisation_id'] =$org_id=$query->insertid;
}
self::setOrganisationReferenceId($org_id,'intermediary');
if(count($branch) > 0){
$qry = new Bin_Query();
$sql ="UPDATE `contact_details` SET `first_name`='".$_POST['bank_c_fname']."',`last_name`='".$_POST['bank_c_lname']."',`work_address_id`='".$regoff_addressid."',`position`='1' WHERE organisation_id='".$org_id."' ";
$qry->updateQuery($sql);
$qry = new Bin_Query();
$sql = "SELECT * FROM contact_details WHERE organisation_id='".$org_id."' limit 1";
$qry->executeQuery($sql);
$contact_id = $qry->records[0]['contact_id'];
}
else
{
$qry = new Bin_Query();
$qry->updateQuery("INSERT INTO `contact_details` (`organisation_id` ,`bank_id`,`first_name`,`last_name`,`work_address_id`,`home_address_id`,`hq_address_id`,`position`)
VALUES ('".$org_id."','".$_POST['bank_name']."','".$_POST['bank_c_fname']."','".$_POST['bank_c_lname']."','".$regoff_addressid."','".self::addEmptyAddress()."','".self::addEmptyAddress()."','1')");
$contact_id = $qry->insertid;
}
$qry =new Bin_Query();
$index_sql ="INSERT INTO `organisation_bank_details` (`organisation_id` ,`address_id` ,`bank_id`,`contact_id`,currency_id )VALUES ('".$org_id."', '','".$_POST['bank_name']."','".$contact_id."','".$_POST['currency_id']."')";
$qry->updateQuery($index_sql);
$_POST['organisation_bank_id'] = $qry->insertid;
$sort = explode("-",$_POST['sort_code']);
$sort_code = $sort[0].$sort[1].$sort[2];
$qry = new Bin_Query();
$sql = "INSERT INTO `organisation_bank_account_details` (`account_name`,`account_no`,`sort_code`,`iban_code`,`swift_code`,`organisation_id`,`organisation_bank_id`,`created`) VALUES ('".$_POST['account_name']."','".$_POST['account_no']."','".$sort_code."','".$_POST['iban_code']."','".$_POST['swift_code']."','".$org_id."','".$_POST['organisation_bank_id']."',NOW())";
$qry->updateQuery($sql);
header('Location:?do=intrminvapplication2&id='.$org_id);
}
function getAddressDropDownForm2($address, $select){
if(count($address[0]) >0 || count($address[1]) >0){
$output .='<select name="address_select" id="address_select" class="cmb_bx1" tabindex="24" onchange="choseaddress(this.value, false,this.selectedIndex);"><option value="">Select</option>';
foreach($address[0] as $key){
$output .='<option value="'.$key['mail_address_id'].'" ';
if($select == $key['mail_address_id']) $output .='selected="selected"';
$output .=' >Primary Trading Address</option>';
$output .='<option value="'.$key['organisation_regoffice_id'].'" ';
if($select == $key['organisation_regoffice_id']) $output .='selected="selected"';
$output .=' >Registered Office Address</option>';
}
$j=1;
if(count($address[1]) >0){
foreach($address[1] as $keys){
$output .='<option value="'.$keys['address_id'].'" ';
if($select == $keys['address_id']) $output .='selected="selected"';
$output .=' >Branch Address #'.$j++.'</option>';
}
}
$output .='<option value="0"';
if($select == "0") $output .='selected="selected"';
$output .=' >Other</option></select>';
}
return $output;
}
function getOrgDetails($id){
$user_id = $_SESSION['user']['invuserid'];
$query =new Bin_Query();
$sql = "SELECT * FROM `organisation_details` where `organisation_id` = ".$id." && user_id = ".$user_id." limit 1";
$query->executeQuery($sql);
$org = $query->records;
return $org;
}
function selectRegid()
{
$query =new Bin_Query();
$sql = "SELECT * FROM address_details where address_id='".$_SESSION['reg_id']."'";
$query->executeQuery($sql);
$regid = $query->records[0];
return $regid;
}
function selectPrimary()
{
$query =new Bin_Query();
$sql = "SELECT * FROM address_details where address_id='".$_SESSION['primary_id']."'";
$query->executeQuery($sql);
$primary = $query->records[0];
return $primary;
}
function selectBranch()
{
$orgid = $_SESSION['organisation_id'];
$qry = new Bin_Query();
$sql = "SELECT * FROM organisation_branch_details WHERE organisation_id='".$orgid."' ORDER BY organisation_branch_id ASC";
$qry->executeQuery($sql);
$branch = $qry->records;
$new=array();
for($i=0;$i<count($branch);$i++)
{
$query =new Bin_Query();
$sql = "SELECT * FROM address_details where address_id='".$branch[$i]['address_id']."'";
$query->executeQuery($sql);
$new[] = $query->records[0];
}
return $new;
}
function validateInvestorCurrencyTwo()
{
for($i=0;$i<count($_POST['cp_fname']);$i++)
{
$insert_field_sql3 ="INSERT INTO address_details(address_line_one,address_line_two,address_country,address_zipcode,address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax ,address_email,address_state, address_city) values('".trim($_POST['cp_ha_addr1'][$i])."','".trim($_POST['cp_ha_addr2'][$i])."','".trim($_POST['cp_ha_country'][$i])."','".trim($_POST['cp_ha_pcode'][$i])."','".trim($_POST['cp_ha_ph_country'][$i])."','".trim($_POST['cp_ha_ph_area'][$i])."','".trim($_POST['cp_ha_ph_pn'][$i])."','".trim($_POST['cp_ha_fn_country'][$i])."','".trim($_POST['cp_ha_fn_area'][$i])."','".trim($_POST['cp_ha_fn_pn'][$i])."','".trim($_POST['cp_ha_email'][$i])."','".trim($_POST['cp_ha_state'][$i] )."','".trim($_POST['cp_ha_city'][$i] )."')";
if($insert_user_result3=mysql_query($insert_field_sql3))
{
$home_addressid =mysql_insert_id();
}
$insert_field_sql5 ="INSERT INTO address_details(address_line_one,address_line_two,address_country,address_zipcode,address_phone_country,address_phone_code,address_phone,address_fax_country,address_fax_code,address_fax ,address_email,address_state, address_city) values('".trim($_POST['cp_wa_addr1'])."','".trim($_POST['cp_wa_addr2'])."','".trim($_POST['cp_wa_country'])."','".trim($_POST['cp_wa_pcode'])."','".trim($_POST['cp_wa_ph_country'])."','".trim($_POST['cp_wa_ph_area'])."','".trim($_POST['cp_wa_ph_pn'])."','".trim($_POST['cp_wa_fn_country'])."','".trim($_POST['cp_wa_fn_area'])."','".trim($_POST['cp_wa_fn_pn'])."','".trim($_POST['cp_wa_email'])."','".trim($_POST['cp_wa_state'])."','".trim($_POST['cp_wa_city'])."')";
if($insert_user_result5=mysql_query($insert_field_sql5))
{
$work_addressid = mysql_insert_id();
}
if($_POST['cp_os_type'][0] !='' && $_POST['cp_os_type'][1] !=''){
$owner = 3;
}else if($_POST['cp_os_type'][0] !=''){
$owner = $_POST['cp_os_type'][0];
}else{
$owner = 0;
}
$dob=$_POST['cp_dob_year'][$i].'-'.$_POST['cp_dob_mon'][$i] .'-'.$_POST['cp_dob_date'][$i];
$insert_user_result6 =mysql_query("INSERT INTO contact_details(organisation_id,first_name,last_name, job_title,birth_date,percent_owned,active_participation,home_address_id,work_address_id,hq_address_id,ownership)
values('".$_SESSION['organisation_id']."','".trim($_POST['cp_fname'][$i])."','".trim($_POST['cp_lname'][$i])."','".trim($_POST['cp_jtitle'][$i])."','".trim($dob)."','".trim($_POST['cp_per'][$i])."','".trim($_POST['cp_act_part'][$i])."','".trim($home_addressid)."','".trim($work_addressid)."','".self::addEmptyAddress()."','".$owner."')");
$sub_date=$_POST['sub_year'].'-'.$_POST['sub_month'].'-'.$_POST['sub_date'];
$insert_field_sql7 ="UPDATE organisation_details SET submitter_firstname='".trim($_POST['sub_fname'])."',submitter_lastname='".trim($_POST['sub_lname'])."',submitted_date='".trim($sub_date)."',submitter_legally_approved='".trim($_POST['sub_approvel'])."',application_status='1',application_step='2' WHERE organisation_id='".$_SESSION['organisation_id']."'";
mysql_query($insert_field_sql7);
}
unset($_SESSION['organisation_id']);
unset($_SESSION['reg_id']);
unset($_SESSION['primary_id']);
unset($_SESSION['branch_id']);
header('Location:?do=success');
}
function addContact($record,$errmsg,$errval)
{
$j=1;
for($i=1;$i<$record;$i++)
{
$j=$j+1;
$output.= '<tr>
<td align="left" valign="top" class="inves_top1"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" align="left" valign="top" class="inves_top1">Contact #'.$j.'</td>
<td width="50%" align="left" valign="top" class="inves_top1"> </td>
</tr>
</table></td>
</tr>
<tr class="very_lite_gray">
<td align="center" valign="top"><table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td width="50%" align="center" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="3">
<tr>
<td width="4%" align="center" valign="top" class="txt_11_red"> * </td>
<td width="35%" align="left" valign="top">First Name :</td>
<td width="53%" align="left" valign="top"><input type="text" name="cp_fname[]" value="'.$errval['cp_fname'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_fname'.$i.''].'</span></td>
<td width="8%" align="right" valign="top"><a title="'.$arr[94].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="35%" align="left" valign="top">Last Name :</td>
<td width="53%" align="left" valign="top"><input type="text" name="cp_lname[]" value="'.$errval['cp_lname'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_lname'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[95].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="35%" align="left" valign="top">Job title :</td>
<td width="53%" align="left" valign="top"><input type="text" name="cp_jtitle[]" value="'.$errval['cp_jtitle'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_jtitle'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[96].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="35%" align="left" valign="top">Date of Birth :</td>
<td width="53%" align="left" valign="top"><table width="46%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="29%" align="center" valign="top"><div class="text_dd_code">
<input type="text" value="'.$errval['cp_dob_date'][$i].'" name="cp_dob_date[]" size="2" maxlength="2"/>
</div></td>
<td width="30%" align="center" valign="top"><div class="text_dd_code">
<input type="text" value="'.$errval['cp_dob_mon'][$i].'" name="cp_dob_mon[]" size="2" maxlength="2"/>
</div></td>
<td width="41%" align="center" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['cp_dob_year'][$i].'" name="cp_dob_year[]" size="4" maxlength="4"/>
</div></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_cute">DD</td>
<td align="center" valign="top" class="txt_11_cute">MM</td>
<td align="center" valign="top" class="txt_11_cute">YYYY</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_dob_year'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[97].'" class="under">(?)</a></td>
</tr>
</table></td>
<td align="center" valign="top" class="gray_1"></td>
<td width="50%" align="center" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="3">
<tr>
<td width="4%" align="center" valign="top" class="txt_11_red"> * </td>
<td width="34%" align="left" valign="top">Ownership </td>
<td width="53%" align="left" valign="top"><input type="radio" name="cp_os_type[]" value="0"/>
Owner
<input type="radio" name="cp_os_type[]" value="1"/>
Shareholder<br/><span style="color:#FF0000">'.$errmsg['cp_os_type'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[98].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="34%" align="left" valign="top">( % ) Percent Owned :</td>
<td width="53%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['cp_per'][$i].'" name="cp_per[]" size="3" maxlength="3"/>
</div><span'.$errmsg['cp_per'.$i.''].'</span><br/><span style="color:#FF0000">'.$errmsg['cp_per'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[99].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="34%" align="left" valign="top">Active Participation :</td>
<td width="53%" align="left" valign="top"><span>
<input type="radio" name="cp_act_part[]" value="0" />
Yes</span> <span>
<input type="radio" name="cp_act_part[]" value="1"/>
No</span><br/><span style="color:#FF0000">'.$errmsg['cp_act_part'.$i.''].'</span></td>
<td width="9%" align="right" valign="top"><a title="'.$arr[100].'" class="under">(?)</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top" class="inves_top1"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" align="left" valign="top" class="inves_top1">Home Address </td>
<td width="50%" align="left" valign="top" class="inves_top1">Work Address<a href="javascript:void(0);" onclick="showSuccessMsg(\'contact\','.$i.');"><span style="color:#0000FF">SELECT</span></a></td>
</tr>
</table></td>
</tr>
<tr class="very_lite_gray">
<td align="center" valign="top"><table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td width="50%" align="center" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="3">
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Home Address Line 1 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_ha_addr1[]" id="cp_ha_addr1[]" value="'.$errval['cp_ha_addr1'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_ha_addr1'.$i.''].'</span></td>
<td width="10%" align="right" valign="middle"><a title="'.$arr[101].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">Home Address Line 2 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_ha_addr2[]" value="'.$errval['cp_ha_addr2'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_ha_addr2'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[102].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">City :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_ha_city[]" value="'.$errval['cp_ha_city'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_ha_city'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[103].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">State :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_ha_state[]" value="'.$errval['cp_ha_state'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_ha_state'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[104].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Country :</td>
<td width="53%" align="left" valign="middle"> ';
$output.= '<select name="cp_ha_country[]" class=cmb_bx1 >
<option value="0">Select</option>';
$optSql ="select * from country_mas";
$optResult =mysql_query($optSql);
while($optRow=mysql_fetch_array($optResult)) {
if($optRow[0]==$errval['cp_ha_country'][$i])
$output .= '<option value='.$optRow[0].' selected>'.$optRow[1].'</option>';
else
$output .= '<option value='.$optRow[0].'>'.$optRow[1].'</option>';
}
$output.='</select>';
$output.= '<br/><span style="color:#FF0000">'.$errmsg['cp_ha_country'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[105].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle"> Post code :</td>
<td width="54%" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="56%" align="left" valign="top"><div class="text_b">
<input type="text" value="'.$errval['cp_ha_pcode'][$i].'" name="cp_ha_pcode[]" size="8" maxlength="8"/>
</div></td>
<td width="44%" align="left" valign="top"> </td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_ha_pcode'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[106].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="top">Phone Number :</td>
<td width="54%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['cp_ha_ph_country'][$i].'" name="cp_ha_ph_country[]" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['cp_ha_ph_area'][$i].'" name="cp_ha_ph_area[]" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['cp_ha_ph_pn'][$i].'" name="cp_ha_ph_pn[]" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_ha_ph_pn'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[107].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="top">Fax Number :</td>
<td width="54%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['cp_ha_fn_country'][$i].'" name="cp_ha_fn_country[]" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['cp_ha_fn_area'][$i].'" name="cp_ha_fn_area[]" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['cp_ha_fn_pn'][$i].'" name="cp_ha_fn_pn[]" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_ha_fn_pn'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[108].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Email Address :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_ha_email[]" value="'.$errval['cp_ha_email'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_ha_email'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[109].'" class="under">(?)</a></td>
</tr>
</table></td>
<td align="center" valign="middle" class="gray_1"></td>
<td width="50%" align="center" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="3">
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Work Address Line 1 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_wa_addr1[]" id="cp_wa_addr1'.$i.'" value="'.$errval['cp_wa_addr1'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_wa_addr1'.$i.''].'</span></td>
<td width="10%" align="right" valign="middle"><a title="'.$arr[110].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">Work Address Line 2 :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_wa_addr2[]" id="cp_wa_addr2'.$i.'" value="'.$errval['cp_wa_addr2'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_wa_addr2'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[111].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">City :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_wa_city[]" id="cp_wa_city'.$i.'" value="'.$errval['cp_wa_city'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_wa_city'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[112].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle">State :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_wa_state[]" id="cp_wa_state'.$i.'" value="'.$errval['cp_wa_state'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_wa_state'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[113].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Country :</td>
<td width="53%" align="left" valign="middle"> ';
$output .= '<select name="cp_wa_country[]" class=cmb_bx1 id="cp_wa_country'.$i.'" >
<option value="0">Select</option>';
$optSql ="select * from country_mas";
$optResult =mysql_query($optSql);
while($optRow=mysql_fetch_array($optResult)) {
if($optRow[0]==$errval['cp_wa_country'][$i])
$output .= '<option value='.$optRow[0].' selected>'.$optRow[1].'</option>';
else
$output .= '<option value='.$optRow[0].'>'.$optRow[1].'</option>';
}
$output .= '</select>';
$output .= '<br/><span style="color:#FF0000">'.$errmsg['cp_wa_country'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[114].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="middle"> Post code :</td>
<td width="53%" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="57%" align="left" valign="top"><div class="text_b">
<input type="text" value="'.$errval['cp_wa_pcode'][$i].'" name="cp_wa_pcode[]" id="cp_wa_pcode'.$i.'" size="8" maxlength="8"/>
</div></td>
<td width="43%" align="left" valign="top"> </td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_wa_pcode'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[115].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="top">Phone Number :</td>
<td width="53%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['cp_wa_ph_country'][$i].'" name="cp_wa_ph_country[]" id="cp_wa_ph_country'.$i.'" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['cp_wa_ph_area'][$i].'" name="cp_wa_ph_area[]" id="cp_wa_ph_area'.$i.'" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['cp_wa_ph_pn'][$i].'" name="cp_wa_ph_pn[]" id="cp_wa_ph_pn'.$i.'" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_wa_ph_pn'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[116].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> </td>
<td width="37%" align="left" valign="top">Fax Number :</td>
<td width="53%" align="left" valign="top"><table width="80%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td width="12%" align="left" valign="top"><div class="text_c_code">
<input type="text" value="'.$errval['cp_wa_fn_country'][$i].'" name="cp_wa_fn_country[]" id="cp_wa_fn_country'.$i.'" size="5" maxlength="5"/>
</div></td>
<td width="9%" align="left" valign="top"><div class="text_area_code">
<input type="text" value="'.$errval['cp_wa_fn_area'][$i].'" name="cp_wa_fn_area[]" id="cp_wa_fn_area'.$i.'" size="3" maxlength="3"/>
</div></td>
<td width="79%" align="left" valign="top"><div class="text_ph_code">
<input type="text" value="'.$errval['cp_wa_fn_pn'][$i].'" name="cp_wa_fn_pn[]" id="cp_wa_fn_pn'.$i.'" size="8" maxlength="8"/>
</div></td>
</tr>
<tr>
<td align="left" valign="top" class="txt_11_cute">Country</td>
<td align="left" valign="top" class="txt_11_cute">Area</td>
<td align="left" valign="top" class="txt_11_cute">Phone Number</td>
</tr>
</table><span style="color:#FF0000">'.$errmsg['cp_wa_fn_pn'.$i.''].'</span></td>
<td align="right" valign="top"><a title="'.$arr[117].'" class="under">(?)</a></td>
</tr>
<tr>
<td align="center" valign="top" class="txt_11_red"> * </td>
<td width="37%" align="left" valign="middle">Email Address :</td>
<td width="53%" align="left" valign="middle"><input type="text" name="cp_wa_email[]" id="cp_wa_email'.$i.'" value="'.$errval['cp_wa_email'][$i].'" class="text_b"/><br/><span style="color:#FF0000">'.$errmsg['cp_wa_email'.$i.''].'</span></td>
<td align="right" valign="middle"><a title="'.$arr[118].'" class="under">(?)</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr> ';
}
return $output;
}
function showIntrmInvCurrency()
{
$query = new Bin_Query();
$sql="SELECT * FROM organisation_details WHERE organisation_id='".intval($_GET['aid'])."' ";
if($query->executeQuery($sql))
$recordSet=$query->records[0];
return Display_DIntermediaryInvOrg::showIntrmInvCurrency($recordSet);
}
function inCompleteForm($id =''){
$user_id = $_SESSION['user']['invuserid'];
$where ='';
if($id !='' && is_Numeric($id)) $where = " && organisation_id = '".$id."' ";
$query =new Bin_Query();
$sql = "SELECT application_step, organisation_id FROM `organisation_details` where user_id = '".$user_id."' $where ORDER BY organisation_id DESC limit 1";
$query->executeQuery($sql);
$form = $query->records;
if($form[0]['application_status'] == '1' || $form[0]['application_step'] == '2'){
header('location: index.php?do=showinvestorcurrency');
exit;
}
if(count($form) >0){
$branch = Model_MTradeApplication::getbranchAddress();
if($form[0]['application_step'] !=2){
$_SESSION['organisation_id'] = $form[0]['organisation_id'];
}
}
}
function orgStepRedirect($org_id, $step){
// return true;
$user_id = $_SESSION['user']['invuserid'];
$query = new Bin_Query();
$sql = "SELECT application_step, organisation_id FROM `organisation_details` where `organisation_id` ='$org_id' && user_id = '".$user_id."' limit 1";
$query->executeQuery($sql);
$redirect = $query->records;
if(count($redirect) > 0 ){
if($step <= $redirect[0]['application_step']){
$org_notify ='<tr><td class="red_11" align="center">You cannot add a new organisation, until you have one complete set of information for at least one organisation.<br> You have been redirected here to complete this process for your first organisation<br><br></td></tr>';
}
else
{
$org_notify ='<tr><td class="red_11" align="center"></td></tr>';
}
if($step == 1 || $step < $redirect[0]['application_step']){
$_SESSION['org_notify'] = $org_notify;
$_SESSION['notify_flag'] = 1;
}
switch ($redirect[0]['application_step']) {
case 1:
if($step != 2){
header('location: index.php?do=intrminvapplication2&id='.$redirect[0]['organisation_id']);
exit; }
break;
case 2:
$_SESSION['organisation_id'] ='';
header('location: index.php?do=showinvestorcurrency');
exit;
break;
}
}else{
if($step != 1){
header('location: index.php?do=intrminvapplication2&id='.$redirect[0]['organisation_id']);
exit;
}
}
}
}
?>