<?php
session_start();
include("lib/conn.php");
include ("includes/libmail.php");
include ("functions.php");

$staff_id = $_REQUEST['staff_id_hid'];

$sql_select = mysql_fetch_array(mysql_query("SELECT * FROM sat_staff WHERE staff_id = '".$staff_id."'"));

$pre_firstname = $sql_select['firstname'];
$pre_lastname = $sql_select['lastname'];
$pre_work_phone_no = $sql_select['work_phone_no'];
$pre_cphone = $sql_select['cphone'];
$pre_hphone = $sql_select['hphone'];
$pre_work_email = $sql_select['work_email'];
$pre_pemail = $sql_select['pemail'];
$pre_worksite_street = $sql_select['worksite_street'];

/********************************************************/
$firstname = $_REQUEST['firstname'];
$lastname = $_REQUEST['lastname'];
$work_phone_no = $_REQUEST['work_phone_no1']."".$_REQUEST['work_phone_no2']."".$_REQUEST['work_phone_no3'];
$cphone = $_REQUEST['cphone1']."".$_REQUEST['cphone2']."".$_REQUEST['cphone3'];
$hphone = $_REQUEST['hphone1']."".$_REQUEST['hphone2']."".$_REQUEST['hphone3'];
$work_email = $_REQUEST['work_email'];
$pemail = $_REQUEST['pemail'];
$worksite_street = $_REQUEST['worksite_street'];


$sql_update_staff = mysql_query("UPDATE sat_staff SET firstname = '".$firstname."' , lastname = '".$lastname."' , work_phone_no = '".$work_phone_no."' , cphone = '".$cphone."' , hphone = '".$hphone."' , work_email = '".$work_email."' , pemail = '".$pemail."' , worksite_street = '".$worksite_street."' WHERE staff_id = '".$staff_id."'");

if($sql_update_staff){
	if($pre_firstname!=$firstname || $pre_lastname!=$lastname || $pre_work_phone_no!=$work_phone_no || $pre_cphone!=$cphone || $pre_hphone!=$hphone || $pre_work_email!=$work_email || $pre_pemail!=$pemail || $pre_worksite_street!=$worksite_street){
		
		
		$person_name = $firstname." ".$lastname;
		
		$getTemplate = check_null_value('body','sat_email_template','id','1');
		$getSubject = check_null_value('subject','sat_email_template','id','1');
		$templete_body = emailTempalte($getSubject,$getTemplate);
		
		$templete_body = str_replace("%%person_name%%",$person_name,$templete_body);
		
		if($pre_firstname!=$firstname){
			$details = 'Firstname : '.$firstname."<br>";
		}
		if($pre_lastname!=$lastname){
			$details.= 'Lastname : '.$lastname."<br>";
		}
		if($pre_work_phone_no!=$work_phone_no){
			$details.= 'Phone (Work) : '.$work_phone_no."<br>";
		}
		if($pre_cphone!=$cphone){
			$details.= 'Phone (Cell) : '.$cphone."<br>";
		}
		if($pre_hphone!=$hphone){
			$details.= 'Phone (Other) : '.$hphone."<br>";
		}
		if($pre_work_email!=$work_email){
			$details.= 'Email (Work) : '.$work_email."<br>";
		}
		if($pre_pemail!=$pemail){
			$details.= 'Email (Personal) : '.$pemail."<br>";
		}
		if($pre_worksite_street!=$worksite_street){
			$details.= 'Work Location Address : '.$worksite_street."<br>";
		}	
		
		$templete_body = str_replace("%%details%%",$details,$templete_body);
		
		$to_email = getNameTable("sat_email_master","email_address","title","Support Email Address");//"priya@infosolz.com";
		
		$replyto = $pemail;//"sourav.de@infosolz.com";
		
		$from = "itteam@absi-usa.com";
		$to = $to_email;
		$sts = new Mail();
		$sts->From($from);
		$sts->Subject($getSubject);
		$sts->Body($templete_body);
		
		$sts->To($to);
		$sts->ReplyTo($replyto);
		$send = $sts->Send();
		
		if($send){
			echo "Staff Details Updated Successfully.";
		}
		
	}
	
	
}







?>