/home/mip/public_html_/old-website/brokerxxx/edit_configuration.php
<?
session_start();
require_once("func_all.php");

do_html_header("Configuration"); 

$formname="thisonly";
$inputname= array("agency_name");
$displayname= array("Agency Name");
JS_CheckRequired($formname,$inputname,$displayname,"","");

$company = getdata_one("*","company",1,1);
$officers = getdata("select * from company_officers order by name");
$num_officers = count($officers);
?>
<form method=post action='sqlupdate.php?what=company' name="<?=$formname?>" onsubmit="return CheckRequired()" enctype="multipart/form-data">

<tr><td height="100%" align=center valign="top">
<table align=center cellpadding='2' cellspacing='2' border=0>
 	 <tr><td valign="top"><br>
					<table border=0 cellpadding='0' cellspacing='0' width="100%">
					<tr><td valign="top"><img src="img/addleft.gif" border="0"></td>
					<td background="img/addtile.gif" width="100%"><b>Configuration</td>					
					<td valign="top"><img src="img/addright.gif" border="0"></td></tr>
					</table>
    </td></tr>
		<tr><td colspan=2><?if($company[agency_logo]){ echo resize_pic(750,50,$company["agency_logo"],"Agency Logo",""); }?></td>
		</tr>
		<tr><td>
	 		<table border="0" cellpadding="0" cellspacing="0" width=100%>
			<tr><td><img src="img/topleft-login.gif" border="0"></td>
			    <td background="img/toptile-login.gif"><img src="img/toptile-login.gif" border="0"></td>
					<td><img src="img/topright-login.gif" border="0"></td></tr>
		  <tr><td background="img/midleft-login.gif"><img src="img/midleft-login.gif" border="0"></td>
		  <td width="100%" align="center" bgcolor="#dbdee3">
				<table width="100%" cellpadding='3' cellspacing='3'>
   			<tr><td class="box" width=21%><b>Agency Logo</b><br><font color=636563 face='Arial' size=1>max width=750px<br>max height=50px</td>
     				<td valign=top class="box"><?if($company[agency_logo]){ echo $company['agency_logo'];?> [<a href="sqldelete.php?what=agency_logo&agency_logo=<?=$company['agency_logo']?>" onclick="return confirm('Are you sure you want to remove this logo?')"><font color=red>Remove Logo</font></a>] <?}else{?><input type=file name="agency_logo" size=30><?}?><br> <font color=636563 face='Arial'>This logo would appear on the applicant's resume (Employer Version).</td></tr>						
   			<tr><td class="box"><b>Agency Name</b></td>
     				<td valign=top class="box"><input type=text name="agency_name" size=50 value="<?=$company['agency_name']?>"></td></tr>
				<tr><td class="box"><b>Address</b></td>
     				<td valign=top class="box"><input type=text name="agency_address" size=50 value="<?=$company['agency_address']?>"></td></tr>	 										 
   			<tr><td class="box"><b>Tel No.</b></td>
     				<td valign=top class="box"><input type=text name="agency_tel" size=50 value="<?=$company['agency_tel']?>"></td></tr>
				<tr><td class="box"><b>Fax No.</b></td>
     				<td valign=top class="box"><input type=text name="agency_fax" size=50 value="<?=$company['agency_fax']?>"></td></tr>
				<tr><td class="box"><b>Email</b></td>
     				<td valign=top class="box"><input type=text name="agency_email" size=50 value="<?=$company['agency_email']?>"></td></tr>
				<tr><td class="box"><b>President</b></td>
     				<td valign=top class="box"><input type=text name="president" size=50 value="<?=$company['president']?>"></td></tr>																								
				<tr><td class="box" colspan=2><b>Signatories for the ff. forms :</b></td></tr>				
				<tr><td class="box"><b>RFP</b></td>
				    <td>
						  <table>							
							<tr><td>Requesting Party</b></td><td><select name="rfp_requestparty"><option value=''>--<?selectcode($officers,$company['rfp_requestparty'],"officer_id","name")?></select></td></tr>
							<tr><td>Submitted By</b></td><td><select name="rfp_submittedby"><option value=''>--<?selectcode($officers,$company['rfp_submittedby'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>
				<tr><td class="box"><b>RFP Direct Hire</b></td>
				    <td>
						  <table>							
							<tr><td>Requesting Party</b></td><td><select name="rfpdirect_requestparty"><option value=''>--<?selectcode($officers,$company['rfpdirect_requestparty'],"officer_id","name")?></select></td></tr>
							<tr><td>Submitted By</b></td><td><select name="rfpdirect_submittedby"><option value=''>--<?selectcode($officers,$company['rfpdirect_submittedby'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>							
				<tr><td class="box"><b>POEA Job Order</b></td>
				    <td>
						  <table>							
							<tr><td>Requesting Party</b></td><td><select name="poeajo_requestparty"><option value=''>--<?selectcode($officers,$company['poeajo_requestparty'],"officer_id","name")?></select></td></tr>
							<tr><td>Submitted By</b></td><td><select name="poeajo_submittedby"><option value=''>--<?selectcode($officers,$company['poeajo_submittedby'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>			
				<tr><td class="box"><b>Issuance of Visa Certificate</b></td>
				    <td>
						  <table>							
							<tr><td></b></td><td><select name="visa_certificate"><option value=''>--<?selectcode($officers,$company['visa_certificate'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>
				<tr><td class="box"><b>Visa Stamping</b></td>
				    <td>
						  <table>							
							<tr><td></b></td><td><select name="visa_stamping"><option value=''>--<?selectcode($officers,$company['visa_stamping'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>							
				<tr><td class="box"><b>OFW Information Sheet</b></td>
				    <td>
						  <table>							
							<tr><td></b></td><td><select name="ofw_infosheet"><option value=''>--<?selectcode($officers,$company['ofw_infosheet'],"officer_id","name")?></select></td></tr>
							</table>
						</td>
				</tr>
				<tr><td class="box" align=center colspan=2><input type=submit value="  Save  " name="user" class="button"></td></tr>
			</table>
		</td>
		<td background="img/midright-login.gif"><img src="img/midright-login.gif" border="0"></td></tr>
		<tr><td><img src="img/botleft-login.gif" border="0"></td>
		<td background="img/bottile-login.gif"><img src="img/bottile-login.gif" border="0"></td>
		<td><img src="img/botright-login.gif" border="0"></td></tr>
		</table>
		</td>
		</form>			
		<td valign=top width=40% align=center>
		 <table border=0>
		   <tr><td><b>OFFICERS</b></td></tr>
			 <?if($officer_id){
			 $officer1 = getdata_one("*","company_officers","officer_id",$officer_id);
			 ?>
			 <form method="post" action="sqlupdate.php?what=officers">
			 <input type="hidden" name="officer_id" value="<?=$officer_id?>">
			 <?}else{?>
			 <form method="post" action="sqladd.php?what=officers">
			 <?}			 
			 ?>
			 <tr><td><table>
			 <tr>
			   <td>Name</td><td><input type="text" name="name" value="<?=$officer1['name']?>"></td>
			 </tr>
			 <tr>
			   <td>Designation</td><td><input type="text" name="designation" value="<?=$officer1['designation']?>"> <input type="submit" value=" Save "></td>
			 </tr>
			 </table></td></tr>
			 <?if($num_officers){?>
			 <tr><td><table width=100%>
			    <tr><td><u>Name</td><td><u>Designation</td></tr>
					<?for($i=1;$i<=$num_officers;$i++){
					 print "<tr><td><a href='$PHP_SELF?officer_id=".$officers[$i]['officer_id']."'>".$officers[$i]['name']."</a></td><td>".$officers[$i]['designation']."</td><td>[<a href='sqldelete.php?what=officers&officer_id=".$officers[$i]['officer_id']."' onclick=\"return confirm('Are you sure you want to delete this officer?')\"><font color=maroon>delete</font></a>]</td></tr>";
					}
					?>
			 </table></td></tr>
			 <?}?>
			 </form>
			 
		 </table>
		</td>
		</tr>
 </table>
 </td></tr>
 </form>
<?
 do_html_footer();
 if($msg) echo "<script>alert('$msg')</script>";
?>
Path: home/mip/public_html_/old-website/brokerxxx