<?php
session_start();

include("_functions.php");
dbconnect();

$rowjava = TRUE;
$is_logged = is_logged();

$page_title = "External Directory";
$GLOBALS["ext_page"] = $page_title;  // SET FAUX PAGE NAME
$_GET["p"] = 1;			 // SET FAUX PARENT ID

$lnav_mods = get_layout($_GET["p"],1);
$rnav_mods = get_layout($_GET["p"],3);

include("_pagestart.php");
echo "<div class=\"headline\">".$page_title."</div>\n";

// ADD CONTACT TO MY CONTACTS
if (isset($_GET["add"]) && $is_logged) {
	$added = quickUPDATE("INSERT INTO tbl_extdir_list (username,dir_id) VALUES ('".$_SESSION["auth_user"]."',".$_GET["add"].")");
	if ($added !== FALSE) $message = notice("Directory entry successfully added to 'My Contacts'");
	else $message = error("An error occurred while attempting to add the contact to your list.");
}

// GET USER'S CONTACT LIST\
$entries = array();
if ($is_logged) {
	$sql = "SELECT dir_id FROM tbl_extdir_list WHERE username='".$_SESSION["auth_user"]."'";
	$res = mysql_query($sql);
	for ($i=0; $row = mysql_fetch_array($res); $i++) $entries[$i] = $row["dir_id"];
}

$sql = "SELECT * FROM tbl_extdir WHERE is_public=1 ORDER BY dir_name ASC";
$res = mysql_query($sql);

echo "<div class=\"pagebody\">\n";
echo "<br>The <b>Vocollect External Directory</b> is a collection of all contacts entered into each individual <i>My Contacts</i> address book by Vocollect employees and designated as a public contact.\n";
echo "<br><br><input type=\"button\" class=\"btn\" value=\" Add a New Contact \" onClick=\"location.href='contact_details.php?r=ed&act=add'\">\n";
echo "</div>\n";

echo "<center>\n";
if ($message) echo "<P>".$message;
echo "<P><table border=0 cellspacing=1 cellpadding=5 width=95% bgcolor=\"#CCCCCC\">\n";
echo "<tr class=\"header\"><td><b>Contact Name</b></td>\n";
echo "<td><b>Business</b></td>\n";
echo "<td><b>Primary Phone</b></td>\n";
echo "<td><b>Mobile Phone</b></td>\n";
echo "<td><b>Category</b></td>\n";
echo "<td align=\"center\" width=20><b>Email</b></td>\n";
echo "<td align=\"center\" width=20><b>&nbsp;Web&nbsp;</b></td>\n";
echo "<td align=\"center\" width=20><b>&nbsp;Add&nbsp;</b></td></tr>\n";

if (mysql_num_rows($res) < 1) {
	echo "<tr><td bgcolor=\"FFFFFF\" colspan=8><b>You have yet to enter any contacts.</b></td></tr>\n";
} else for ($i=0; $row = mysql_fetch_array($res); $i++) {
	extract($row);
	$bg = ($i%2==0?"FFFFFF":"F0F0F0");
	echo "<tr onmouseover=\"setPointer(this,".($i).",'over','#".$bg."','#FEF3A9','#D5EFFF');\" onmouseout=\"setPointer(this,".($i).",'out','#".$bg."','#FEF3A9','#D5EFFF');\" onmousedown=\"setPointer(this,".($i).",'click','#".$bg."','#FEF3A9','#D5EFFF');\">\n";
	echo "<td bgcolor=\"#".$bg."\"><a href=\"/contact_details.php?r=ed&id=".$dir_id."\">".$dir_name."</a></td>";
	echo "<td bgcolor=\"#".$bg."\">".(!zero($dir_business)?$dir_business:"")."</td>";
	echo "<td bgcolor=\"#".$bg."\">".(!zero($dir_primary)?phone10($dir_primary):"")."</td>";
	echo "<td bgcolor=\"#".$bg."\">".(!zero($dir_mobile)?$dir_mobile:"")."</td>";
		echo "<td bgcolor=\"#".$bg."\">".(!zero($dir_type)?$dir_type:"")."</td>";
	echo "<td bgcolor=\"#".$bg."\" align=\"center\">".(!zero($dir_email)?"<a href=\"mailto:".$dir_email."\"><img src=\"/gui/icons/email.gif\" border=0></a>":"")."</td>";
	echo "<td bgcolor=\"#".$bg."\" align=\"center\">".(!zero($dir_url)?"<a href=\"".$dir_url."\" target=\"ext\"><img src=\"/gui/icons/web.gif\" border=0></a>":"")."</td>";
	if (in_array($dir_id,$entries)) echo "<td bgcolor=\"#".$bg."\" align=\"center\"><img src=\"/gui/icons/contact_off.gif\" border=0 alt=\"This contact is already in your list.\"></td></tr>";
	else if ($is_logged) echo "<td bgcolor=\"#".$bg."\" align=\"center\"><a href=\"javascript:AddContact(".$dir_id.")\"><img src=\"/gui/icons/contact_add.gif\" border=0 alt=\"Add to My Contacts\"></a></td></tr>";
	else echo "<td bgcolor=\"#".$bg."\" align=\"center\"><img src=\"/gui/icons/contact_off.gif\" border=0 alt=\"Disabled. Please Login.\"></td></tr>";
}

echo "</table>\n</center>";

echo "<br><div class=\"pagebody\">\n";
echo "<input type=\"button\" class=\"btn\" value=\" Add a New Contact \" onClick=\"location.href='contact_details.php?r=ed&act=add'\">\n";
echo "</div>\n";

include("_pageend.php");
?>