<?php

$ContactPool = array ('DBUsername'=>"asterisk", 'DBPassword'=>"foxtrot1", 'DBName'=>"mail");

$ContactPool['Details'] = array( "owner" => array('Desc' =>"XXX", 'Class' => ''),
 		   "nickname" => array( 'Desc' => "XXX", 'Class' => ''),
		   "Title" => array( 'Desc' => "Title", 'Start' => "1", 'Class' => 'Group_S'),
		   "firstname" => array( 'Desc' => "First name", 'Class' => 'Group'),
		   "lastname" => array( 'Desc' => "Last name", 'End' => "1", 'Class' => 'Group_E'),
                   "email" => array( 'Desc' => "E-mail", 'Start' => "1", 'Class' => 'Group_S'),
                   "W_email" => array( 'Desc' => "Work E-mail", 'Class' => 'Group'),
		   "O_email" => array( 'Desc' => "Alternate E-mail", 'End' => "1", 'Class' => 'Group_E'),
		   "H_Phone" => array( 'Desc' => "Home Phone", 'Start' => "1", 'End' => "1", 'Class' => 'Phone'),
                   "W_Phone" => array( 'Desc' => "Work Phone No.", 'Start' => "1", 'End' => "1", 'Class' => 'Phone'),
		   "M_Phone" => array( 'Desc' => "Mobile Phone No.", 'Start' => "1", 'End' => "1", 'Class' => 'Phone'),
                   "H_Office" => array( 'Desc' => "House", 'Start' => "1", 'Class' => 'Group_S'),
		   "H_Street" => array( 'Desc' => "Home Address", 'Class' => 'Group'),
                   "H_Locality" => array( 'Desc' => "Town", 'Class' => 'Group'),
		   "H_Region" => array( 'Desc' => "County", 'Class' => 'Group'),
		   "H_PostCode" => array( 'Desc' => "Post Code", 'Class' => 'Group'),
		   "H_Country" => array( 'Desc' => "Country", 'End' => "1", 'Class' => 'Group_E'),
		   "Organisation" => array( 'Desc' => "Organisation", 'Start' => "1", 'Class' => 'Group_S'),
		   "W_Office" => array( 'Desc' => "Office", 'Class' => 'Group'),
                   "W_Street" => array( 'Desc' => "Work Address", 'Class' => 'Group'),
		   "W_Locality" => array( 'Desc' => "Town", 'Class' => 'Group'),
		   "W_Region" => array( 'Desc' => "County", 'Class' => 'Group'),
		   "W_PostCode" => array( 'Desc' => "Post Code", 'Class' => 'Group'),
		   "W_Country" => array( 'Desc' => "Country", 'End' => "1", 'Class' => 'Group_E'),
		   "Birthday" => array( 'Desc' => "Birthday", 'Class' => ''),
		   "Anniversary" => array( 'Desc' => "Anniversary", 'Class' => ''),
                   "URL" => array( 'Desc' => "Website", 'Start' => "1", 'End' => "1", 'Class' => 'Link'),
		   "W_URL" => array( 'Desc' => "Work Website", 'Start' => "1", 'End' => "1", 'Class' => 'Link'),
		   "label" => array( 'Desc' => "Notes", 'Class' => '')
		   );


//$Name = $_GET['search'];
//$error = ProcessContactAction($Action, $_GET)
function ProcessContactAction($Action, $Args) {
   global $ContactPool;
   $Name = $Args['search'];
   $Nickname = $Args['nickname'];
   if ($Action == "Update") {
      if ($Name != $Nickname) {
         $error="Can't change nickname ".$Name. $Nickname;
         /* TODO: Do search for uniqueness then update */
      } else {

         $query="UPDATE address SET ";
         $sep="";
         foreach ($ContactPool['Details'] as $key => $Data) {
            $query .= $sep."`$key` = '$Args[$key]' ";
            $sep=",";
          }
          $query .= " WHERE owner='salts' AND nickname='". $Name ."';";
          mysql_connect(localhost,$ContactPool['DBUsername'],$ContactPool['DBPassword']) or die($ContactPool['DBUsername'].$ContactPool['DBPassword']."Unable to Connect to Mysql");
          @mysql_select_db($ContactPool['DBName']) or die( "Unable to select database");
          mysql_query($query) or die(mysql_error());
      }
   }

   if ($Action == "Add") {
      $query = "SELECT nickname FROM address WHERE nickname = '".$Name."'";
      mysql_connect(localhost,$ContactPool['DBUsername'],$ContactPool['DBPassword']) or die($ContactPool['DBUsername'].$ContactPool['DBPassword']."Unable to Connect to Mysql");
      @mysql_select_db($ContactPool['DBName']) or die( "Unable to select database");
      $result = mysql_query($query) or die(mysql_error());
      if (mysql_num_rows($result) != 0) {
          $error = "Nickname is not Unique";
      } else {
         $Args['nickname'] = $Name;
         $Args['owner'] = "salts";
         $query = "INSERT address (";
         $data = "";
         $sep="";
         foreach ($ContactPool['Details'] as $key => $Data) {
            $query .= $sep."`$key`";
            $data .= $sep."'$Args[$key]' ";
            $sep=",";
          }
          $query .= ") VALUES (". $data . ");";
          mysql_query($query) or die(mysql_error());
       }
   }

   if ($Action == "Delete") {
      if ($Name != $Nickname) {
         $error="Can't change nickname";
         /* TODO: Do search for uniqueness then update */
      } else {
         $query = "DELETE FROM `address` WHERE `owner` = 'salts' AND `nickname` = '". $Name ."' LIMIT 1";
         mysql_connect(localhost,$ContactPool['DBUsername'],$ContactPool['DBPassword']) or die("Unable to Connect to Mysql");
         @mysql_select_db($ContactPool['DBName']) or die( "Unable to select database");
         $result = mysql_query($query) or die(mysql_error());
      }
   }
   return $error;
}

//$Call[] = SearchForContact[$Call['Number']);
function SearchForContact($PhoneNumber) {
   global $ContactPool;
 
   $Call = array();
   mysql_connect(localhost,$ContactPool['DBUsername'],$ContactPool['DBPassword']) or die("Unable to Connect to Mysql");
   @mysql_select_db($ContactPool['DBName']) or die( "1Unable to select database");

   $query="SELECT nickname,firstname,lastname,H_Phone,W_Phone,M_Phone FROM address WHERE owner='salts'";
   $Addresses=mysql_query($query);
   $Contacts = array();
   while(($Contacts[] = mysql_fetch_assoc($Addresses)) || array_pop($Contacts));

   if ($PhoneNumber != '') {
      foreach ($Contacts as $Contact) {
         if (preg_match("/".$PhoneNumber. "/", trim(ereg_replace( ' *', '', $Contact['H_Phone'])))) {
            $Call['Contact'][] = $Contact['firstname'] . " " . $Contact['lastname'] . " (Home)";
            $Call['Nickname'][] = $Contact['nickname'];
         }
         if (preg_match("/".$PhoneNumber. "/", trim(ereg_replace( ' *', '', $Contact['W_Phone'])))) {
            $Call['Contact'][] = $Contact['firstname'] . " " . $Contact['lastname'] . " (Work)";
            $Call['Nickname'][] = $Contact['nickname'];
         }
         if (preg_match("/".$PhoneNumber. "/", trim(ereg_replace( ' *', '', $Contact['M_Phone'])))) {
            $Call['Contact'][] = $Contact['firstname'] . " " . $Contact['lastname'] . " (Mobile)";
            $Call['Nickname'][] = $Contact['nickname'];
         }
      }
   }
   return $Call;
}

//    DisplayContact($Name, $Number);

function DisplayContact($Name, $Number) {
   global $ContactPool;
   if ($Name != "") {
      mysql_connect(localhost,$ContactPool['DBUsername'],$ContactPool['DBPassword']) or die("Unable to Connect to Mysql");
      @mysql_select_db($ContactPool['DBName']) or die( "1Unable to select database");
      $query="SELECT * FROM address WHERE owner='salts' AND nickname='". $Name ."'";
      $Addresses=mysql_query($query);
      $Contacts = array();
      while(($Contacts[] = mysql_fetch_assoc($Addresses)) || array_pop($Contacts));

      if( count($Contacts) == 1) {
         foreach($ContactPool['Details'] as $key => $Data) {
            $Value = $Contacts[0][$key];
            if ($Data['Desc'] != "XXX") {
               echo "<tr>";
               echo "<td Class='".$Data['Class']."'>";
               echo $Data['Desc'].":";
	       echo "</td>";
               echo "<td Class='".$Data['Class']."'>";
               echo '<input class="input" name="'.$key.'" id="Ed-'.$key.'" type="input" size="40" Value="'.($Value).'" >';
               echo "</td>";
               echo "</tr>";
            } else {
               echo '<input type="hidden" name="'.$key.'" Value="'.($Value).'" >';
            }
         }
      }
      echo "<TR><TD>";
      echo "<input class='button' name='Action' type=\"submit\" value=\"Update\" />";
      echo "<input class='button' name='Action' type=\"submit\" value=\"Delete\" />";
      echo "</td></tr>";
   }
   if ($Number != "") {
      foreach($ContactPool['Details'] as $key => $Data) {
         if ($Data['Desc'] != "XXX") {
            echo "<tr>";
            echo "<td Class='".$Data['Class']."'>";
            echo $Data['Desc'].":";
            echo "</td>";
            echo "<td Class='".$Data['Class']."'>";
            if ( $key == "H_Phone") {
               echo "<input class='input' name='$key' id='Ed-".$key."' type='input' size='40' value='$Number' >";
            } else {
               echo "<input class='input' name='$key' id='Ed-".$key."' type='input' size='40' value='' >";
            }
            echo "</td>";
            echo "</tr>";
         }
      }
      echo "<TR><TD>";
      echo "<input class='button' name='Action' type=\"submit\" value=\"Add\" />";
      echo "</td></tr>";
   }
}
?>