<!-----------------------------------------------------------------
'********************************************************************************************
'* This function is used for autonumber in the file.				                      	*
'* subroutine	:		autonumber															*
'* Parameters	:-	(are as follows)														*
'*  1. $sql					: Query to fetch data from database								*
'*  2. $auto_fieldname		: Autonumber field name from database							*
'********************************************************************************************
----------------------------------------------------------------------->


<!---------------------------------------------------------------
'********************************************************************************************
'* This function is used to display a combobox with database values.                      	*
'* subroutine	:		showselect															*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in combobox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
--------------------------------------------------------------------->

<!-----------------------------------------------------
'********************************************************************************************
'* This function is used to display a combobox with database values.                      	*
'* subroutine	:		showselect															*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in combobox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
------------------------------------------------------->
<!-------------------------Added --19/3/10----------------------------------------
'********************************************************************************************
'* This function is used to display date values.										 	*
'* subroutine	:		showdate															*
'* Parameters	:-	(are as follows)														*
'*  1. $format			: Format of date													*
'********************************************************************************************
---------------------------End  19/3/10-------------------------------------------->
<!-------------------------Added --23/2/10----------------------------------------
'********************************************************************************************
'* This function is used to display a listbox with database values.                      	*
'* subroutine	:		showlist															*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or Listbox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in Listbox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  23/2/10-------------------------------------------->


<!--------------------------------------------------
'********************************************************************************************
'* This function is used to display list box.												*
'********************************************************************************************
---------------------------------------------------->
<!-------------------------Added--23/2/10----------------------------------------
'********************************************************************************************
'* This function is used to display a listbox with all selected database values.           	*
'* subroutine	:		show_fill_list														*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or Listbox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in Listbox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  23/2/10-------------------------------------------->

<!--'********************************************************************************************
---------------------------End  23/2/10-------------------------------------------->

<!-------------------------Added --19/3/10----------------------------------------
'********************************************************************************************
'* This function is used when there is no record in database.				            	*
'* subroutine	:		show_zero_result													*
'* Parameters	:-	(are as follows)														*
'*  1. $result			: variable for storing sql query result								*
'*  2. $colspan			: Colspan value of table											*
'********************************************************************************************
---------------------------End 19/3/10-------------------------------------------->
<!-------------------------Added --15/3/10----------------------------------------
'********************************************************************************************
'* This function is used to insert values in state_change_log table.                      	*
'* subroutine	:		state_change_log													*
'* Parameters	:-	(are as follows)														*
'*  1. $m_work_schema_id	: Work flow schema ID											*
'*  2. $m_leave_id			: Leave ID whose state changed									*
'*  3. $m_leave_status		: Leave status whose state changed								*
'*  4. $m_remark			: Remark for state changed										*
'*  5. $m_date				: Date when state changed										*
'********************************************************************************************
---------------------------End  15/3/10-------------------------------------------->
<!-------------------------Added ---------------------------------------
'********************************************************************************************
'* This function is used to  values in state_change_log table.                      	    *
'* Author					:Poonam Rajvar													*
'*  subroutine          	: update_balance_day											*
'*  Parameters	            :(are as follows)												*
'*  1. $m_empid	            : Employee Id											        *
'*  2. $m_ltid			    : Leave ID 														*
'*  3. $m_day				: Days  										                *
'********************************************************************************************
---------------------------End ------------------------------------------->
<!-------------------------Added --2/3/10----------------------------------------
'********************************************************************************************
'* This function is used to move the file.							                      	*
'* subroutine	:		move_file															*
'* Parameters	:-	(are as follows)														*
'*  1. $filename: name of file which we have to move										*
'********************************************************************************************
---------------------------End  2/3/10-------------------------------------------->


<!-------------------------Added --2/3/10----------------------------------------
'********************************************************************************************
'* This function is used to encrypt the file.							                   	*
'* subroutine	:		move_file															*
'* Parameters	:-	(are as follows)														*
'*  1. $filename: name of file which we have to encode										*
'********************************************************************************************
---------------------------End  2/3/10-------------------------------------------->
<!-------------------------Added --2/3/10----------------------------------------
'********************************************************************************************
'* This function is used to decrypt the file.						                      	*
'* subroutine	:		move_file															*
'* Parameters	:-	(are as follows)														*
'*  1. $filename: name of file which we have to decode										*
'********************************************************************************************
---------------------------End  2/3/10-------------------------------------------->
<!-------------------------Added by Poonam--2/3/10----------------------------------------
'********************************************************************************************
'* This function is used to show record of outdoor details.						            *
'* Parameters	:-	(are as follows)														*
'*  1. $sql     :      sql statement 										                *
'********************************************************************************************
---------------------------End of Poonam 2/3/10-------------------------------------------->
<head>
<script language="JavaScript">
function show_msg(m_id)
   {
    win=open("display.php?id="+m_id,"win","height=300,width=300,left=0,top=0");
    win.focus();
   }
</script>
</head>
<!-------------------------Added by Poonam--31/3/10----------------------------------------
'********************************************************************************************
'* This function is used to show difference between dates in days.						    *
'* Parameters	:-	(are as follows)														*
'*  1. $m_sdate     :  Start date                                                           *    
'*  2. $m_sdate     :  End  date													        * 
'********************************************************************************************
---------------------------End of Poonam 31/3/10-------------------------------------------->
<!-------------------------Added --2/4/10-----------------------------------------
'********************************************************************************************
'* This function is used draw horizontal line in the table.					            	*
'* subroutine	:		show_hr																*
'* Parameters	:-	(are as follows)														*
'*  1. $colspan			: Colspan value of table											*
'********************************************************************************************
---------------------------End  2/4/10-------------------------------------------->
<!-------------------------Added --2/4/10----------------------------------------
'********************************************************************************************
'* This function is used to display header along with image.				            	*
'* subroutine	:		add_new_table														*
'* Parameters	:-	(are as follows)														*
'*  1. $heading_name		: Heading Name of table											*
'*  2. $link_name			: Name of Link to add new										*
'*  3. $img_src				: Image src for add new											*
'*  4. $tip					: Tooltip for Image												*
'********************************************************************************************
---------------------------End  2/4/10-------------------------------------------->
<!-------------------------Added --5/4/10----------------------------------------
'********************************************************************************************
'* This function is used to display a combobox with joint values.				        	*
'* subroutine	:		showcombo															*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval1				: name of field1 which we have to show in combobox				*
'*  5. $selval2				: name of field2 which we have to show in combobox				*
'*  6. $selectedval			: value of option that has to be selected						*
'*  7. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  5/4/10-------------------------------------------->

<!-------------------------Added--5/4/10----------------------------------------
'********************************************************************************************
'* This function is used to check the data is available in table or not.	               	*
'* subroutine	:		chk_available														*
'* Parameters	:-	(are as follows)														*
'*  1. $tablename		: Name of table to check											*
'*  2. $chk_field		: Field name to be checked											*
'*  3. $user_value		: Value to be checked												*
'********************************************************************************************
---------------------------End 5/4/10-------------------------------------------->
<!-------------------------Added--6/4/10----------------------------------------
'********************************************************************************************
'* This function is used to display a combobox with database values from MS-Access.       	*
'* subroutine	:		show_access_select													*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in combobox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  6/4/10-------------------------------------------->
<!-------------------------Added --7/4/10----------------------------------------
'********************************************************************************************
'* This function is used to get value from database.				                      	*
'* subroutine	:		get_val																*
'* Parameters	:-	(are as follows)														*
'*  1. $str				: Query to fetch data from database									*
'*  2. $column_name		:  Field name from database											*
'********************************************************************************************
---------------------------End  7/4/10-------------------------------------------->
<!-------------------------Added--7/4/10----------------------------------------
'********************************************************************************************
'* This function is used to display supreme images.									       	*
'* subroutine	:		show_images															*
'********************************************************************************************
---------------------------End 7/4/10-------------------------------------------->

<!-------------------------Added--21/4/10----------------------------------------
'********************************************************************************************
'* This function is used to get multiple values from database.		                      	*
'* subroutine	:		get_multival														*
'* Parameters	:-	(are as follows)														*
'*  1. $str				: Query to fetch data from database									*
'*  2. $column_name1	:  Field name from database											*
'*  3. $column_name2	:  Field name from database											*
'********************************************************************************************
---------------------------End  21/4/10-------------------------------------------->
<!-------------------------Added--21/4/10----------------------------------------
'********************************************************************************************
'* This function is used for sending an e-mail.						                      	*
'* subroutine	:		send_mail															*
'* Parameters	:-	(are as follows)														*
'*  1. $to					: Recipient of email											*
'*  2. $subject				: Subject of email												*
'*  3. $mail_body			: Body of email													*
'*  4. $mail_header			: Header of email												*
'********************************************************************************************
---------------------------End  21/4/10-------------------------------------------->
<!-------------------------Added --10/5/10----------------------------------------
'********************************************************************************************
'* This function is used to display a combobox of months except current month.             	*
'* subroutine	:		showmonth															*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in combobox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  10/5/10-------------------------------------------->
<!-------------------------Added --24/5/10----------------------------------------
'********************************************************************************************
'* This function is used to display a message and redirected page.			             	*
'* subroutine	:		call_msg															*
'* Parameters	:-	(are as follows)														*
'*  1. $msg_ame				: name of message												*
'*  2. $link				: link for redirected page										*
'********************************************************************************************
---------------------------End  24/5/10-------------------------------------------->
<!-------------------------Added--27/5/10-----------------------------------------
'********************************************************************************************
'* This function is used to display alternate color in the page.			             	*
'* subroutine	:		alternate_color														*
'* Parameters	:-	(are as follows)														*
'*  1. $m_color				: name of color													*
'********************************************************************************************
---------------------------End  27/5/10-------------------------------------------->
<!-------------------------Added by Poonam--27/5/10-----------------------------------------
'********************************************************************************************
'* This function is used to check date of confirmation.						             	*
'* Author		:		Poonam Rajvar														*
'* subroutine	:		chk_doc																*
'* Parameters	:-	(are as follows)														*
'*  1. $sql		: sql query																	*
'********************************************************************************************
---------------------------End of Poonam 27/5/10-------------------------------------------->
<!-------------------------Added --4/6/10-----------------------------------------
'********************************************************************************************
'* This function is used to display search textbox in the page.				             	*
'* subroutine	:		show_search															*
'* Parameters	:-	(are as follows)														*
'*  1. $search_caption		: Caption for search											*
'*  2. $var					: name for textbox												*
'*  3. $m_var				: memory name for textbox										*
'********************************************************************************************
---------------------------End  4/6/10-------------------------------------------->


<!-------------------------Added --01/07/10-----------------------------------------
'********************************************************************************************
'* This function is used to display performace kra detail in the page.						*
'* subroutine	:		show_perform_detail													*
'********************************************************************************************
---------------------------End  01/07/10-------------------------------------------->
<!-------------------------Added --01/07/10-----------------------------------------
'********************************************************************************************
'* This function is used to display behavioral kra detail in the page.						*
'* subroutine	:		show_behave_detail													*
'********************************************************************************************
---------------------------End  01/07/10-------------------------------------------->
<!-------------------------Added --01/07/10-----------------------------------------
'********************************************************************************************
'* This function is used to display overall kra detail in the page.							*
'* subroutine	:		show_overall_detail													*
'********************************************************************************************
---------------------------End  01/07/10-------------------------------------------->
<!-------------------------Added --9/7/10-----------------------------------------
'********************************************************************************************
'* This function is used to show print option on the page.					             	*
'* subroutine	:		call_print															*
'********************************************************************************************
---------------------------End  9/7/10-------------------------------------------->
<!-------------------------Added --9/7/10-----------------------------------------
'********************************************************************************************
'* This function is used to show print option with back link on the page.	             	*
'* subroutine	:		show_print															*
'* Parameters	:-	(are as follows)														*
'*  1. $m_back_link		: back link page name												*
'********************************************************************************************
---------------------------End  9/7/10-------------------------------------------->
<!-------------------------Added --12/7/10----------------------------------------
'********************************************************************************************
'* This function is used to display a combobox for all or particular values.             	*
'* subroutine	:		showcombobox														*
'* Parameters	:-	(are as follows)														*
'*  1. $selectName			: name of select or combobox name								*
'*  2. $sql					: query to fetch data from database								*
'*  3. $optval				: name of field to store in option value						*
'*  4. $selval				: name of field which we have to show in combobox				*
'*  5. $selectedval			: value of option that has to be selected						*
'*  6. $refresh				: if "1" then page will be refreshed							*
'********************************************************************************************
---------------------------End  12/7/10-------------------------------------------->

<!-------------------------Added --12/7/10----------------------------------------
'********************************************************************************************
'* This function is used for checking rating validation in the form.		            	*
'* subroutine	:		chk_rating															*
'* Parameters	:-	(are as follows)														*
'*  1. $m_start_no		: Number for initializing for loop									*
'*  2. $m_end_no		: Number for ending for loop										*
'*  3. $m_frm_name		: Form Name															*
'*  4. $m_field			: Field Name of form for checking validation						*
'*  5. $m_action		: Action for form submission										*
'********************************************************************************************
---------------------------End  12/7/10-------------------------------------------->

<!-------------------------Added--13/7/10----------------------------------------
'********************************************************************************************
'* This function is used for calculating total and storing total in field of form.         	*
'* subroutine	:		show_total															*
'* Parameters	:-	(are as follows)														*
'*  1. $m_start_no		: Number for initializing for loop									*
'*  2. $m_end_no		: Number for ending for loop										*
'*  3. $m_frm_name		: Form Name															*
'*  4. $m_field1		: Field Name of form for storing weightage							*
'*  5. $m_field2		: Field Name of form for storing superior rating					*
'*  6. $m_field3		: Field Name of form for storing calculated total					*
'********************************************************************************************
---------------------------End 13/7/10-------------------------------------------->

<!-------------------------Added--14/7/10----------------------------------------
'********************************************************************************************
'* This function is used for checking weightage percentage.						         	*
'* subroutine	:		chk_weightage														*
'* Parameters	:-	(are as follows)														*
'*  1. $m_start_no		: Number for initializing for loop									*
'*  2. $m_end_no		: Number for ending for loop										*
'*  3. $m_frm_name		: Form Name															*
'*  4. $m_kra_value		: Maximum KRA percentage											*
'*  5. $m_field			: Field Name of form for storing percentage value					*
'*  6. $m_action		: Action for form submission										*
'********************************************************************************************
---------------------------End14/7/10-------------------------------------------->
<!-------------------------Added --9/8/10----------------------------------------
'********************************************************************************************
'* This function is used for checking duplicate values.							         	*
'* subroutine	:		chk_weightage														*
'* Parameters	:-	(are as follows)														*
'*  1. $sql					: query to fetch data from database								*
'********************************************************************************************
---------------------------End  9/8/10-------------------------------------------->

<!-------------------------Added --25/11/10----------------------------------------
'********************************************************************************************
'* This function is used for checking confirmation letter pending details.		         	*
'* subroutine	:		chk_doc_letter														*
'* Parameters	:-	(are as follows)														*
'*  1. $sql					: Query to fetch data from database								*
'********************************************************************************************
---------------------------End  25/11/10-------------------------------------------->


<!---------------------------------------------------------------------------------------------- -->
<!------------------------------------------------------------------------------------------------- -->


<!------------------------------- 
Below function is used for saving default menus at the time of saveuser
-->
<!-- ------------------------------------------------------------------------------------------------- -->


<!-- <style type="text/css">
	div{
		background-color:#e7e6d8;
	}
</style> -->
<table width=100%>
	<td align=left bgcolor=white><br>
		&nbsp;&nbsp;&nbsp;&nbsp;<a href="index.php"><img src=dexterlogo.jpg></a></td><td align=right><br>
			 
	</td>
</table><br>
	<script language="javascript">
		alert("Session Timeout")
		window.location="login.php";
	</script>
<html>
<head>
	<script type="text/javascript" src="jquery.min.js"></script>
	<script type="text/javascript" src="jqueryslidemenu.js"></script>
	<link rel="stylesheet" type="text/css" href="jqueryslidemenu.css" />
	<script>
	/*$(document).ready(function() {
	   $(window).scroll(function () { 
		  console.log($(window).scrollTop())
		if ($(window).scrollTop() > 1) {
		  $('#nav_bar').addClass('navbar-fixed');
		}
		if ($(window).scrollTop() < 1) {
		  $('#nav_bar').removeClass('navbar-fixed');
		}
	  });
	});*/

	$(document).ready(function(){
		$("li.shw").each(function() {
			$(this).parent().parent().append('<img class="rightarrowclass" style="border:0;" src="right.gif"></img>');
		});
		$("a.menuhd").each(function() {
			$(this).append('<img class="downarrowclass" style="border:0;" src="down.gif"></img>');
			$(this).css("padding-right" ,"23px");
		});
	});
	</script>
</head>
<body>
<div style="padding-top:0%;background:#3E3B3B;z-index:101;">
<nav id='nav_bar'>
	<div id="myslidemenu" class="jqueryslidemenu" style="background:#3E3B3B;max-width:99.4%;right: 0.3%;">
		<ul>
			<li>
				<ul>
					<li><a href="#">Sub Item 1.1</a></li>
					<li><a href="#">Sub Item 1.2</a></li>
					<li><a href="#">Sub Item 1.3</a></li>
					<li><a href="#">Sub Item 1.4</a></li>
				</ul>
			</li>
			<li><a href='index.php'>Home</a>
				</div>
</div>
</body>
</html><head>
  <!-- Bootstrap -->
	<link rel="stylesheet" media="screen" href="css_inner/bootstrap.min.css">
	<link rel="stylesheet" media="screen" href="css_inner/bootstrap-theme.min.css">
	<!-- Bootstrap Admin Theme -->
	<link rel="stylesheet" media="screen" href="css_inner/bootstrap-admin-theme.css">
	<link rel="stylesheet" media="screen" href="css_inner/bootstrap-admin-theme-change-size.css">
	<!-- Datatables -->
	<link rel="stylesheet" media="screen" href="css_inner/DT_bootstrap.css">
	<!-- javascripts -->
	<script type="text/javascript" src="js/jquery.min.js"></script>
	<script type="text/javascript" src="js_inner/bootstrap.min.js"></script>
	<script type="text/javascript" src="js_inner/twitter-bootstrap-hover-dropdown.min.js"></script>
	<script type="text/javascript" src="js_inner/bootstrap-admin-theme-change-size.js"></script>
	<script type="text/javascript" src="vendors/datatables/js/jquery.dataTables.min.js"></script>
	<script type="text/javascript" src="js_inner/DT_bootstrap.js"></script>	
	<script>
	$(document).ready(function () {
		$('#example1').dataTable();		
		$('#example2').dataTable();		
	});
</script> 
</head><br><br>

<div class="row">
  <div class="col-lg-12 col-sm-12">
    <div class="panel panel-default" style="margin-left:20px;margin-right:20px;">
	   <div class="panel-heading">
		  <div class="text-muted bootstrap-admin-box-title" ><font color="navy">Tax Invoices</font></div>
	   </div>
       <div class="bootstrap-admin-panel-content">
	   <font size=2>
	   <table class="table table-striped table-bordered" id="example" >
	     <thead>
		    <tr>
				<th><font size=2>No</th>
				<th><font size=2 width=10%>Date</th>
				<th width=30%><font size=2>Client</th>
				<th width=20%><font size=2>Prepared By</th>
				<th width=15% align=right><font size=2>Total</th>
				<th width=10%><font size=2>PDF</th>
				<th><font size=2>Invoice</th>
				<th><font size=2>Payment</th>
		    </tr>
	     </thead>
	      <tbody>
			  <tr bgcolor=#FFFF99><td colspan=10 align=center class=smaller>There is No Record</td></tr>		
		    </tbody>
	     </table>
       </div>
    </div>
  </div>
</div>