| |
//print $imagename;
//print $a_row['comp_clientnumber'];
// if(file_exists("logos/$imagename")){
if($a_row['cap_logoname'] != ''){
$imagename = substr_replace($a_row['cap_logoname'],".gif",-4,4);
?>
|
} ?>
=strtoupper($a_row['comp_company']);?>
if($a_row['comp_motto'] != '') { ?>=$a_row['comp_motto']; ?> } ?>
if($a_row['comp_abn'] != '') { ?>ABN: =$a_row['comp_abn']; ?> } ?>
if($a_row['comp_acn'] != '') { ?>ACN: =$a_row['comp_acn']; ?> } ?>
|
if($a_row['comp_address1'] != '' || $a_row['comp_address2'] != ''): ?>
Address: =$a_row['comp_address1']; ?>
if($a_row['comp_address2']!=""){
//print " ".$a_row['comp_address2'];
}
?>
|
endif; ?>
if($a_row['comp_poaddress'] != ''): ?>
|
Postal Address: =$a_row['comp_poaddress'];?>
|
endif; ?>
if($a_row['comp_tel'] != ''): ?>
| |
| Phone:
=$a_row['comp_tel'];?>
Fax:
=$a_row['comp_fax'];?> |
endif; ?>
if($a_row['comp_internet'] != '') { ?>Website (click to visit):
=$a_row['comp_internet'];?>
} ?>
if($a_row['comp_email'] != '') { ?>Email: =$a_row['comp_email'];?> } ?> |
if($a_row['comp_mobile'] != '' || $a_row['tollfree'] != '') { ?>
| |
|
if($a_row['comp_mobile'] != '') { ?>Mobile: =$a_row['comp_mobile'];?> } ?>
if($a_row['comp_tollfree'] != '') { ?>
Tollfree:
=$a_row['comp_tollfree'];?>
} ?> |
} ?>
/** fetch contacts for listing */
$client_num = $a_row['comp_id'];
$contact_sql = "SELECT * FROM contacts WHERE cont_origid = ".$client_num;
if(isset($_REQUEST['cap_id']))
$cap_id = $_REQUEST['cap_id'];
else
$cap_id = $a_row['cap_id'];
if($cap_id != '')
$contact_sql .= " AND cap_id = ".$cap_id;
//echo 'cap_id:'.$a_row['cap_id'];
//echo "SELECT * FROM contacts WHERE cont_origid = ".$client_num." AND cap_id = ".$a_row['cap_id'];
$contacts_q = mysql_query($contact_sql) or die(mysql_error());
if($contacts_q && mysql_num_rows($contacts_q) != 0) {
// $test_contact = mysql_fetch_array($contacts_q);
?>
$y = 0;
while($contact = mysql_fetch_array($contacts_q)) {
if($contact['cont_name'] != '') { ?>
if($y == 0) { ?>
| |
Contacts:
} ?>
=$contact['cont_name']; ?>
if($contact['cont_title'] != '') { ?>
-
=$contact['cont_title']; ?>
} ?>
if($contact['cont_tel'] != '' || $contact['cont_fax'] != '' || $contact['cont_email'] != '') { ?>
} ?>
if($contact['cont_tel'] != '') { ?>
Ph:
=$contact['cont_tel']; ?>,
} ?>
if($contact['cont_fax'] != '') { ?>
Fax:
=$contact['cont_fax']; ?>,
} ?>
if($contact['cont_mobile'] != '') { ?>
Mob: =$contact['cont_mobile']; ?>,
} ?>
if($contact['cont_email'] != '') { ?>
Email:
=$contact['cont_email']; ?>
} ?>
} // contact name set ?>
$y++; } // while ?>
if($contact['cont_name'] != '') { ?> |
} ?>
} // if contacts_q ?>
/** branches **/
$branches_q = mysql_query("SELECT * FROM branches WHERE comp_id = ".$client_num);
if($branches_q && mysql_num_rows($branches_q) != 0) {
?>
| Branches: |
while($this_branch = mysql_fetch_array($branches_q)) { ?>
=$this_branch['branch_name']; ?>
if($this_branch['street_addr'] != '') { ?>
Address: =$this_branch['street_addr']; ?>
} ?>
if($this_branch['poaddr'] != '') { ?>
Postal Address: =$this_branch['poaddr']; ?>
} ?>
if($this_branch['tel'] != '') { ?>
Phone: =$this_branch['tel']; ?>
} ?>
if($this_branch['fax'] != '') { ?>
Fax: =$this_branch['fax']; ?>
} ?>
if($this_branch['email'] != '') { ?>
=$this_branch['email']; ?>
} ?>
if($this_branch['contact_name'] != '') { ?>
Contact: =$this_branch['contact_name']; ?>
- =$this_branch['contact_title']; ?>
if($this_branch['contact_tel'] != '') { ?>Ph: =$this_branch['contact_tel']; ?> } ?>
if($this_branch['contact_fax'] != '') { ?>Fax: =$this_branch['contact_fax']; ?> } ?>
if($this_branch['contact_mob'] != '') { ?>Mob: =$this_branch['contact_mob']; ?> } ?>
if($this_branch['contact_email'] != '') { ?> Email: =$this_branch['contact_email']; ?> } ?>
} ?>
|
} } // while,if branches ?>
| |
/** get correct category from cap_id **/
if($_REQUEST['cap_id'] != '') {
$cap_id = $_REQUEST['cap_id'];
$capq = mysql_query("SELECT * FROM capabilities WHERE cap_id = ".mysql_real_escape_string($cap_id));
$this_cap = mysql_fetch_array($capq);
$category = $this_cap['cap_category'];
}
else {
$category = $a_row['cap_category'];
}
if($category != '') {
?>
| Category: =$category; ?> |
} // end if category ?>
| |
Capabilities:
$cap = $a_row['cap_capabilities'];
//$cap = str_replace("*", "", $cap);
print nl2br($cap);
//print $a_row['cap_capabilities']);
/*print "
\n\n";
print "
\n\n";
$newcap = ereg_replace('\*([^\*]{1,})', '\1', $cap);
print $newcap;
print "
\n\n";
$newcap = ereg_replace('(^)\.', '\1', $newcap);
print $newcap;
print "
\n\n";*/
?> |
if($a_row['cap_qarating']!=""){ ?>
| |
| QA Ratings: =$a_row['cap_qarating'];?> |
if($a_row['cap_status'] != '') { ?>
| |
| Status:
=$a_row['cap_status'];?> |
} ?>
if($a_row['cap_mc'] != '') { ?>
| |
| MC:
=$a_row['cap_mc'];?> |
} ?>
} ?>
| |
/** fetch extra web information */
$ew_q = mysql_query("SELECT * FROM company_webonly WHERE comp_id = ".$client_num);
if($ew_q && mysql_num_rows($ew_q) != 0) {
$extra_info = mysql_fetch_array($ew_q);
if($extra_info['Web_YearEstab'] != '' || $extra_info['Web_NoEmps'] != ''
|| $extra_info['Web_Parent'] != '' || $extra_info['Web_AreasBusiness'] != ''
|| $extra_info['Web_AreasRD'] != '' || $extra_info['Web_SME'] != '') {
?>
| Additional Company Information |
if($extra_info['Web_YearEstab'] != '') { ?>
Year Established: =$extra_info['Web_YearEstab']; ?>
} ?>
if($extra_info['Web_NoEmps'] != '') { ?>
Num Employees: =$extra_info['Web_NoEmps']; ?>
} ?>
if($extra_info['Web_Parent'] != '') { ?>
Parent Company: =$extra_info['Web_Parent']; ?>
} ?>
if($extra_info['Web_AreasBusiness'] != '') { ?>
Key Areas: =$extra_info['Web_AreasBusiness']; ?>
} ?>
if($extra_info['Web_AreasRD'] != '') { ?>
Key Areas R&D: =$extra_info['Web_AreasRD']; ?>
} ?>
if($extra_info['Web_SME'] != '') { ?>
SME Status: =$extra_info['Web_SME']; ?>
} ?>
|
} // extra info is set ?>
} // extra web info ?>
} // if ?>
//print $a_row['comp_member'];"Membership3", "Membership5", "Membership6", "Membership7", "Membership8", "Membership9",
$member_array = array("Membership1", "Membership2", "Membership4", "Membership10");
//if($a_row['m_member']=="TRUE"){print " | ";}
if (in_array($a_row['comp_member'], $member_array)) {
$image_file = "logos/".$a_row['m_image'];
if((file_exists($image_file))&&($image_file!="logos/")){
print " | ";
}
}
/*if($a_row['comp_aidnlogo']=="TRUE"){print " | ";}
if($a_row['comp_idlogo']=="TRUE"){print " | ";}
if($a_row['comp_nzjaglogo']=="TRUE"){print " | ";}
if($a_row['comp_aeroteam']=="TRUE"){print " | ";}*/
?>
|
} // i<1
$other_cat_query = "select cap.cap_category, cap.cap_id ";
$other_cat_query .= "from company comp, capabilities cap";
$other_cat_query .= " where comp.comp_idaccess=cap_idaccess";
$other_cat_query .= " and comp.comp_clientnumber='".$_REQUEST['f_clientnumber']."'";
$other_cat_query .= " ORDER BY cap.cap_category";
//print $other_cat_query;
$other_cat_result = mysql_query($other_cat_query);
$other_cat_count = mysql_num_rows($other_cat_result);
//print $other_cat_count;
//$i=0;
if($other_cat_count>0 && $listall_count != 0){
print " This company also offers the following services: ";
print " | ";
}
$i++;
?>
|
| |