<?php
include('common_veriable.php');
include(ROOTPATH.ROOTPATH . 'settings/db_ini'.EXT);
		require ROOTPATH . ROOTPATH . 'class/database.inc' . EXT;	
		$DB = new Database;	 
		require ROOTPATH .ROOTPATH .  'class/function.inc' . EXT;
		$FN = new Functions;			
		  $FN->disable_error();
		  $FN->session_enable();
          $FN->set_timezone();	
		  
		 echo $Quer_correction_1 = "SELECT leave_date,employee_id from tbl_request_leave where id='" . $_REQUEST["id"]."' ";
$name_correction_1=$DB->query($Quer_correction_1);
$row123_correction_1 = mysql_fetch_array($name_correction_1);


 $d=$row123_correction_1['leave_date'];
 $em=$row123_correction_1['employee_id'];


  $Query_12 = "delete from  tbl_attendance where date='" . $d."' and emp_id='" . $em."' ";

$DB->query($Query_12);


   $Query = "delete from " . $_REQUEST["tablename"] . " where id='" . $_REQUEST["id"]."'";

$DB->query($Query);


if (isset($_REQUEST["view_id"]) && !empty($_REQUEST["view_id"])) {
echo $FN->page_redirect( ROOTPATH. DATAPATH . 'index.php?page_id='.$_REQUEST["page_id"].'&msg=' .SUCCESS . '&view_id=' . $_REQUEST["view_id"]);

}else{
	echo $FN->page_redirect(  ROOTPATH .DATAPATH . 'index.php'.$_REQUEST["returnpage"].'&msg=' .SUCCESS);
	
}

?>