/home/mip/public_html_/old-website/employerxxx/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>";
?>