ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢¦š¸b
‹(	ƒ®˜˜ÊÃAfiJ!#T¨Ç©)×ðwIMßo—<E9C=ÐÆÖÛÚ‰!CÆpQŒŒöª=–ö±áôÂ¤Wé Ú°v¹ÉÕ¦”ðPéÏJR*ôxów‚}tËrOI´ÌQÇ>1ÄãÚýõ›¤,¬‹Rü¤ó"¹ÿrë*õIN¿’‰ÕÀÎÕNª\™ë(µ6ÿQÝýã?Ù­ É\.cmã!÷€_`·Ml~FöŸõqø`{‚`¾Dó%T;¶p¶”'N‚zv“øË¥>À´§Ý›öšÓ¼ˆ‡¤F/¨ß$¡Ç­l÷ëPÁ³Ø'&Al^‘c
±Ô²3OHy>ÛJäù¢t¬šýØm¢°h*Bá„àç	6!P!»ŽÈÈzåýþ!1K>HîÉM†›«é^PáÔH½pƒç›y^˜[ /d@Œ€”®<\»˜@Xú1>ƒÂSbþ6û1ù¢t¬šýØm¢°h*Báp¼•" _ãÒ¾ç¬À[,tvÛáXI&«k€¿IzâÚ§Æ‚ÆêtòJÞâdïx2¸¢“œ…?ý$@ÍiYñ÷Ì¦J#‘ÇKþIYÂÇžÛ‹uúÀ–Ã)¼¬0l-´sq8­ë ½XPXº‡è;9-:Ø9'F¬ñ½4‚(S´'#.sFðEDê:lË—*vÑ?9o_ð>ØŠKôñÐM`-¸õzº=« >‘9TbòFèäw¹õó9Ú/Å©h~&†r¬/§aµÂº‡({~Yû¹2¢˜îÎ³z"º£6tè	DjÏ\Áç‡[ô#»0¹mÒŒ6-€n‹<WFCøÑEK(ûQ¿-í'ó46O2­ºÑ8¯õ‘ÅP«çþÖä)Nª\™ë(µ6ÿQÝýãÜíb§Ù¸°\“øP§¦Df,òÁ›VbùK¶¥	|ÕÙ­Bÿ1§ï‘&:…ã[9È¹‰¦”ðPéÏJR*ôxów‚}tËrOI´ÌQÇ>1Äsyí×’’õDžvÙàÏP¢ÝBK‘¿©C³«¯L”‘«bbÚ²f~ùºz‡€Âë U¦ô§ibÅù•ó—¹¢Ä‚Ìñ
Ñ°D^Û ð0wI«bbÚ²f~ùºz‡€Âë U¦ô§ibÅù•ó—¹+Óå³7U»qWñ¢
'‹º²Î%Ÿþ¼ÓÀÇ+V~ç>V Pï±hÂ1¼Û‡©Àå·Wg×/Ô*ëÌ5×ÐÀUû M½Er0“u:7ÿS HÂ¿çž`µ¯Ã(5êç}û%š®!À0
´6
¶éÖªrEéxa –C7Ma—Á&YŒO†*¥óñ\†¾•’D`s±ZeužhûÀëuÄIêÿU¢hZÇt z(àM >ë.¼åèZXôK·³„Îx¢Žkœ;ßËúËŽó/(aÁß*¥/N>ù'ÔÀ·,ÚïèÆãüäÁ~afêyÝ!úªOïF“ÈÓyyª|þü5¤%Š­’ÐoÃ_ùnÝ#]ðpÇ’È3Ø²{Jþß$Äù-¦Ö÷C`þæÅoTfNÜÃÒ¤Rg0cÇb
rï&úV8”ŒP™Ñ?:þ20ÄQÍØôšŒ¤;n‡ç™'·‘j½#£µSù_!G7’üH×¤H€»Ÿ¤é½>ØF„ánÖ;¨(ù$ö•ý›ÔOÌÉZàbÞ‡ä~OYýCÈCÇyyr³h}?tØ…7ëDXm>½ø !WAá¸úøTxÕYº?u`ú€VÇ'0”…ê&†¦ƒo”èƒÝ:ÒÏb_SPIîòQwOƒÃMÄW”ýèmÒK;ñGè®¼ƒv†W'¯ì6Ôg’Öñ4¶${kÐbiª¡o­èìŸaé$mY8‚³AÖ3Ã5öÊdCŸ?y0.Ö1 ö óîBIÁ«,¤ìv0QyøHe@|ÈŠ§™Ñ[r#2?õˆ¡²bzÕå/™_˜Dâ›1nÌèø]0$ _¡èÈƒä7«tïí[xÞtðßÙ»ôeiA×æ3á"ŸÛŠi9D÷®2ŽÆ§DxPrUWçÎ£@²ª3i9º¹éN¨‚êÁRkÇ`7…ÀXÜB Ö£€‚'jó ŸXT˜q¤ƒF¯°x´_áLÎR6«dDÀ½MÙÎ¼’¤D~–apèÆ_7REê<Ä,3Ñ;wÃoB<Q‘ZçZ¢Ò~…çCÉæœZ†
Òüäúk{Ï žJ~'-)V ³®÷3e¸1yFö·$‚^`êZ	\•´QÖ^%
Õô"”;ŸØ’£n7î¿™t)[q|ØmaEgÄ†8Ì ù^m}Ã¿ùóàºˆÖNXR:E¼†Ó÷Õzç§µáq#ù¿+zphbµÙ>Õ+˜{Œ›ú8V3‘22¿†2É„8Ì ù^m}Ã¿ùóàºˆÖNXR:E¼†Ó÷Õzç§µáq#0;õ´Zs’¬á¸D’0 Ç€Äk%¸5¾I2›©þ6ÿAëÑçÚÎYõM6‰âÚw+““²\c„Â”øØz·}ƒ…o-¿ýÙ‰†ÌP}RzÑøb¦‰ŠT£Æ»NÆ(¥
î-Pä³kÈ©~“-.O–[ãFÙ$N<ò=éE¥²lýRª\O}ô/j%ƒ*†ñ¾i3%Zþ½ÀKª¬“³gIC_?Aô`Þºõ™
œ¯‰Ùßg²¼·Js«û,‰¯²žƒlê±¾ð±JâbÅ>¢Œ§ÕÛË/Eí›èVa›7l#ëM>¨Ç"„¨3,°YyÏÍÄ&\£¦+“Øè0ýPbRÒør:ßR9ÞÐôŸßC³nÑ¥Øôù_VÏvJsiVô>Ê_ò!ßf/ÉTD×á¼b¥!Ô+Åáß^Q)‚.ÚÆbÜ{U):]ÅfÀK¶êã-hQ äl\u‡’ùàt”I”YñJûõëMÞø›%½× ¿±á=jDý÷ òÞ,#õ¶€yÞ$¡N—8Ì ù^m}Ã¿ùóàºˆÖNXR:E¼†Ó÷Õzç§µáq#º¢4|7Cã}î“ž‹Â`ï†å”Æ<ZåÔ–ë.Mct7 î.A€HQ“úÕU13FŒÚ¢…—s¦ÕÊõ£®ÿ·!í6EZ%ëÆì´œmù!ªŒd­¯iºž-dOjdÎÏ­áß]$„áW·pæˆf9¬ñ·‚rÚÄ²g@a@ûÏd‡c³ma¤ðœþvwƒÙœÃŠæBcJÖŠ=È¡èÃà“žErº„µÒ%ÒµGæcN¦R;%Êª¼o¢NXæÔiu®ÏÿÈ‚ˆNÉÍû?=ÙÆ• £ôŸŽ§odyÛÌvçÝ©˜–„&Øm>wÒN õùtÄ©ø«ªÿõ—´R;Ñpªç[’M²MÒsá²ˆÅ.éK­&ž^-ã÷ÙÂªóE¼XAN@ývÉÅ\’O.¿	Â8g7èÌÚa\zVQæ9¿=¨5L™é š&w-!+Ï¡¡½Ñ·4tÕF
ž¢ƒºRUˆËt&°n÷ÃáÂ9sø¥>âž?ý#a¡¼?T1^W{d®zr?fî´(”R>ø”GÍ`˜Eƒþ¤²réÄ‡âÈÏ§Â:X|%|»¢`FÝ›Na TkÆµÌ±ßÐï8îËÝX&Ãô]æ0ØC»RhðÌÛqjtak,ÒHCpUK”TÆsM3§/©¬“•ž÷åÝâ}BréÄ‡âÈÏ§Â:X|%|»¢`FÝ›Na TkÆµÌ±ßÐrWÐîKQv'÷	®ŽZ–ÚÂ0ØC»RhðÌÛqjt¯QÁ!˜<ÄæÆ¡HLÍùH˜°Óü Ša~`2îLÅx<ÿÍ¥K–æ–.\g64Þïíú‰6-Ä¢ef"FÌËG§õˆÊø6ø'Ã d*öÖøÁFWõÖI/pr8òFT›ÜµWÿÇé)4JÓ»Îéî3CŒøœgüÓë‚JÓ˜³9zÎ-.ñ5]É¸:ÐdŸû÷tÇ“Ó}YHNåŽ˜Da*zïå5H™»>OnxGìðcü››‡#ÀúsQsd“uéÁ5±ú°tõRJíÞYNOïè?ríDXÍsÀµÈm¿æm÷eÃÔÎF%Õ¤sŒ^m~yÒÛó${ GýŸ¸ÎÚ•ÃSÙ:‡&mJsiVô>Ê_ò!ßf/ÉTDJþ\ß‰Â–‘‰ßH[,­$®‡ÁÐ¡4Äøg}~Ú6ð(Ó(Z5òZ¦Ç.ÍÏ>uÚ™Zº°ƒjMÉ5¨÷Ù?‹õ­Œê(:4+Þ½þë	"2%,#}@ØdfŠyòÃ‚ÎU¼2»Ž„™²S Q#5JwÌƒhÃt3«í[³i£©¢ý¾\¾(G-UÝf¥óXPû,‡î&^[þí}ƒ¤#…Hâ\ Rð8Ãžo_XS
Zn´ÿ]Â¹vVíËÕùÆiv¼ÊÐ: $$ß¸…/[Á×“ènTŠóÉæÂÇ¯Š*#Cññ¤üáÏéX´ ÐC+·d—~´^“qw>Š—:F«Éy‹€Š`™`*âîj\º|á«ûø×¨/Z¤…ûïž8ÂñÎŽ¥
î-Pä³kÈ©~“-.O–[ãFÙ$N<ò=éE¥Œ$§|F®Fzâõ«K`!ëõ¦Xû9™iW±¬eEaÝámÿöÑêFÈâ!¢Åª²¶w±È›´´²÷ßùg>{J?"X PÕ	’ x|ß.âéwÄ	ë¿+˜IÇ¢E%z$×u-6*„]åB¥`šŸÒ[šQy6*õÝÿœH°>h|ãIƒ”£»jÇ¬<;nÊË¡­’ºïO¦;™ÛéfM¸`•«ö¸1ûOuL÷Mœf3Ž¸ô—Òš|ù*…K¯(nò œÈ:ÖBÙóìo¡=ÏK…ÝŠÊ/­›yÿµ?}§3M-`u7‚ùæáÀh¾<ðZ¢ø‚I<Óæ]óîÄÖ¬áW­]“¹Ùúx×=BýaÇ¥oÆ=)¯öé"N¦åm¯eº¯5ç†Ð¿Î”öÁ˜ú:][äA6ƒL›~ƒ>6Dˆn÷xX§dÇk-LŒC‹x™®ø;Â;»MFL-`èG 0/XaÊÆ&çL½'S(‹]Ùv)X‹ë;%â	s Å)&liîôÜ¯Ìh"ipé"(€ø¸F·9$T•€Ð«Àˆn½4““ê—™$‹¾€ñÀÏ.mÌBç‰1ÿ—´'>ªuòyà«ê‰ŸšsØ†šFQŒ3ÌfQRÚÚgQþNk—Áxåú„ÎIáZzB"RhÖ}[7„me type
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['staffListXls'])){
	$monthYear = date_01(date('Y-m-d',strtotime( $_GET['staffListXls'])));
	$month = date('M',strtotime( $_GET['staffListXls']))."-".date('Y',strtotime( $_GET['staffListXls']));

	$filename="Staff_List_KICH_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	
	$rowCount   =   1;
	$col='A'; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Serial');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Month');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'ID');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'NIC');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Name');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'F/Name');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Designation');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Birth');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Hiring');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Address');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Bank');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'AccountNo');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Branch');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'Grade');
	$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,'BF');
	
	
	$rowCount   =   2;
	$total=0;
	$query = "select * from employee_personal_information where salary='YES' order by grade desc";			
	//$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' and grade<15 order by branch desc,employeeid";			
	$cur= odbc_exec( $conn, $query );   
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table
		$col='A'; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, $rowCount-1);
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, $month);
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "employeeid" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "nicno" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "employeename" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "employeefathername" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "job_description" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "Date_of_birth" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "Date_of_joining" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "address" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "Bank" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "account_no" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "branch" ));
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount, odbc_result( $cur, "grade" ));
		//$salary=getName($conn,"select sum(amount) from monthlyemployeeallowances where date2='2023-12-01' and  employeeid='".odbc_result($cur,"employeeid")."' ");
		$BenovelenFund=getName($conn,"select sum(dAmount) from monthlyemployeedeductions where d_head in('381',481) and  date2<='2024-02-01' and  employeeid='".odbc_result($cur,"employeeid")."' ");
		$col++; 	$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$rowCount,$BenovelenFund);
		
		
		
		$rowCount++;
		
	}
	$rowCount++;
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['proforma24'])){
	$monthYear = "2023-12-01";// date_01(date('Y-m-d',strtotime( $_GET['List3'])));
	$month = date('M',strtotime( $monthYear))."-".date('Y',strtotime($monthYear));
	$filename="proforma_24_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1','Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1','Category');
	$col='C'; $i=0;

	$cur1= odbc_exec( $conn,"select distinct session_ from monthlyemployeeallowances where session_>='2021' order by session_");  
	while( odbc_fetch_row( $cur1 ) ) {
		$year_=odbc_result($cur1,'session_')-1;
		$session2[$i++]=odbc_result($cur1,'session_');
		$session=$year_."-".substr(odbc_result($cur1,'session_'),2,2);
		$objPHPExcel->getActiveSheet()->SetCellValue($col.'1',$session);			
		//$colTotal[$i++]=0;			
		$col++;
	}

	//$ids="select employeeid from employee_personal_information where job_status='FIXED' ";	
	$row=1;
	$ids="select employeeid from employee_personal_information where grade>=18 and job_description not in ('DIRECTOR ADMIN/FINANCE') and job_status<>'FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){		
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'Doctors');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}
	
	//faiz and umair
	$ids="select employeeid from employee_personal_information where job_description in('DIRECTOR ADMIN/FINANCE','SENIOR AUDITOR') and job_status<>'FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'Accounts');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}

	//paramadics
	$ids="select employeeid from employee_personal_information where  job_description in('CLINICAL TECH (PATHOLOGY)','JR CLINICAL TECH (PATHOLOGY)') and job_status<>'FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'paramadics');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}

	//10-17
	$ids="select employeeid from employee_personal_information where (grade between 10 and 17) and job_description not in('DIRECTOR ADMIN/FINANCE','SENIOR AUDITOR','CLINICAL TECH (PATHOLOGY)','JR CLINICAL TECH (PATHOLOGY)') and job_status<>'FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'Manpower 10-17');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}

	//1-9
	$ids="select employeeid from employee_personal_information where grade<10 and job_status<>'FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'below 10');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}
	
	//FIXED
	$ids="select employeeid from employee_personal_information where job_status='FIXED' ";		
	$col='C'; $row++;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'Fixed');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}

	//All
	$ids="select employeeid from employee_personal_information where 1=1 ";		
	$col='C'; $row+=4;
	for($i=0;$i<count($session2);$i++){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$row,$row-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$row,'All_salary');
		$basic=getName($conn,"select sum(amount) as amt from monthlyemployeeallowances where session_='".$session2[$i]."' and employeeid in($ids) ");			
		$objPHPExcel->getActiveSheet()->SetCellValue($col.''.$row,$basic);
		$col++;
	}

	
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['List3'])){
	$monthYear = "2023-12-01";// date_01(date('Y-m-d',strtotime( $_GET['List3'])));
	$month = date('M',strtotime( $monthYear))."-".date('Y',strtotime($monthYear));
	$filename="Quarter3rdSalary_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1','Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1','Month');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1','Designation');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1','Salary');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1','Quarterly');
	$objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getFont()->setBold(true); // give bold style to cell

	$rowCount=2;$total=0;
	$ids="select employeeid from employee_personal_information where job_status='FIXED' ";
	$basic=getName($conn,"select sum(allownces) as salary from monthlySalary where date2='$monthYear' and grade>16 and employeeid not in($ids) ");
	if($basic>0){
			$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
			$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
			$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,"17 to 22");
			$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$basic); // for monthly
			//$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,3*$basic); // for quarter			
			$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,'=D'.$rowCount."*3"); // for quarter			
			$total+=(4*$basic);// odbc_result($cur,"Salary");
			$rowCount++;
	}

	$basic=getName($conn,"select sum(allownces) as salary from monthlySalary where date2='$monthYear' and (grade between 11 and 16)  and employeeid not in($ids) ");
	if($basic>0){
			$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
			$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
			$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,"11 to 16");
			$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$basic); // for monthly
			//$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,3*$basic); // for quarter			
			$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,'=D'.$rowCount."*3"); // for quarter			
			$total+=(4*$basic);// odbc_result($cur,"Salary");
			$rowCount++;
	}

	$basic=getName($conn,"select sum(allownces) as salary from monthlySalary where date2='$monthYear' and (grade between 3 and 10)  and employeeid not in($ids) ");
	if($basic>0){
			$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
			$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
			$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,"3 to 10");
			$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$basic); // for monthly
			//$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,3*$basic); // for quarter			
			$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,'=D'.$rowCount."*3"); // for quarter			
			$total+=(4*$basic);// odbc_result($cur,"Salary");
			$rowCount++;
	}

	$basic=getName($conn,"select sum(allownces) as salary from monthlySalary where date2='$monthYear' and employeeid in($ids) ");
	if($basic>0){
			$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
			$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
			$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,"FIXED");
			$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$basic); // for monthly
			//$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,3*$basic); // for quarter			
			$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,'=D'.$rowCount."*3"); // for quarter			
			$total+=(4*$basic);// odbc_result($cur,"Salary");
			$rowCount++;
	}
	
	$rowCount++;
	//$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,$total);
	$range="E2:E100";
	$objPHPExcel->getActiveSheet()->getStyle($range)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['List2'])){ // 
	$monthYear = date_01(date('Y-m-d',strtotime( $_GET['List2'])));
	$month = date('M',strtotime( $_GET['List2']))."-".date('Y',strtotime( $_GET['List2']));
	//$year = date('Y',strtotime( $_GET['bankList']));
	$filename="Salary_List_KICH_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Month');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Employee ID');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Employee Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Branch');
	$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Account No');
	$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Salary');
	//$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'BenovelenFund');
	$objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getFont()->setBold(true); // give bold style to cell

	$rowCount=2;$total=0;

	//$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' and grade<15 order by branch desc,employeeid";			
	$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='2023-12-01' and grade<15 order by branch desc,employeeid";			
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table

		$basic=getName($conn,"select isnull(sum(damount),0) from monthlyemployeedeductions where d_head in('368','370') and (date2 between '2023-09-01' and '2024-01-01') and employeeid='".odbc_result($cur,"ID")."'");
		
		if($basic>0){
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "ID" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"Employee"));		
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, odbc_result($cur,"Branch"));
		$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, odbc_result($cur,"AccountNo"));
		//$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, odbc_result($cur,"Salary"));
		
		//$basic=getName($conn,"select min_ from BasicPayChart where year_='2017' and Grade='".odbc_result($cur,"AccountNo")."'");
		//Gp Fund=385
		
		$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,$basic); // for 4 months Sep-Dec 2023
		
		$total+=($basic);// odbc_result($cur,"Salary");
		//$objPHPExcel->getActiveSheet()->getStyle('E'.$rowCount)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
		
		$rowCount++;
		}
		
	}
	$rowCount++;
	$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,$total);
	
	$range="E2:E100";
	$objPHPExcel->getActiveSheet()->getStyle($range)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['btnShowXls'])){ //BroadSheet to XLS for FBR

	$from =  date_01(date('Y-m-d',strtotime($_GET['from'])));
	$to =  date_01(date('Y-m-d',strtotime($_GET['to'])));
	$anyvalue= $_GET['anyvalue'];
	$d_head=$_GET['d_head'];
	$isActiveOnly=isset($_GET['isActiveOnly'])?1:0;
	$filename="BroadSheet".$from;

	$isActiveOnly=true;
	if(isset($_GET['isActiveOnly'])) $isActiveOnly=$_GET['isActiveOnly'];
	$f_ =  (date('Y',strtotime($_GET['from'])));
	$t_ =  (date('m',strtotime($_GET['from'])));
	if($t_<7){
		$to =  date_01(date('Y-m-d',strtotime("01-June-$f_")));
		$f_-=1;
		$from =  date_01(date('Y-m-d',strtotime("01-July-$f_")));
	}else{
		$from =  date_01(date('Y-m-d',strtotime("01-July-$f_")));
		$f_+=1;
		$to =  date_01(date('Y-m-d',strtotime("01-June-$f_")));		
	}	
	$f_ =  date_01(date('M-Y',strtotime($from)));
	$t_ =  date_01(date('M-Y',strtotime($to)));
	

	$cur= odbc_exec( $conn, "update monthlyemployeeallowances set date2=date_ where date2 is null" );  
	$cur= odbc_exec( $conn, "update monthlyemployeedeductions set date2=date_ where date2 is null" );  
	$d_head=$_GET['d_head'];
	$d_head2=$d_head+100;	

	$query = "select employeeid,employeename,nicno,GP_fund_no from employee_personal_information where  ";			
	$query.=" employeeid in (select distinct employeeid from monthlyemployeedeductions where (date2 between '$from' and '$to') and  d_head in('$d_head','$d_head2') and dAmount>0 ) ";			
	if($isActiveOnly==true) $query.=" and salary='YES' ";			
	if(isset($_GET['anyvalue']) and $_GET['anyvalue']!="") $query.=" and employeename like'%".$_GET['anyvalue']."%' ";			
	$query.= " order by employeename";		

//exit();

	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 

	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'PersonalNo');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'nicno');

	$x='E';$cnt=1;
	for ($i=$from; $i<=$to; $i = date_01(date ("Y-m-d", strtotime("+31 days", strtotime($i))))){
		$montName =  date('M',strtotime($i));
		$objPHPExcel->getActiveSheet()->SetCellValue($x.'1',$montName.'_Gross');
		$x++;
		$objPHPExcel->getActiveSheet()->SetCellValue($x.'1',$montName.'_Tax');
		$x++;
	}
	
	
	$rowCount   =   2;
	//$query = "select employeeid,employeename,Grade from monthlySalary where date2='$from' order by grade desc";			
	//exit();
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table
		$empID=odbc_result( $cur, 'employeeid' );
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, odbc_result($cur,"employeeid"));
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "employeename" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"nicno"));		

		$x = 'E';$cnt=1;
		for ($i=$from; $i<=$to; $i = date_01(date ("Y-m-d", strtotime("+31 days", strtotime($i))))){
			$i =  date_01(date('Y-m-d',strtotime($i)));

			$amt=getName($conn,"select sum(amount) from monthlyemployeeallowances where employeeid='$empID' and date2='$i' and adescription not like'Adj.%'  " );  
			$objPHPExcel->getActiveSheet()->SetCellValue($x.''.$rowCount,$amt);
			$x++;

			if($d_head=="385") // GP-Advacne 1,2,3,4
				$amt=getName($conn,"select sum(damount) from monthlyemployeedeductions where d_head in('$d_head','$d_head2','368','370','372','374') and employeeid='$empID' and date2='$i'  " );  
			else
				$amt=getName($conn,"select sum(damount) from monthlyemployeedeductions where d_head in('$d_head','$d_head2') and employeeid='$empID' and date2='$i'  " );  

			$objPHPExcel->getActiveSheet()->SetCellValue($x.''.$rowCount,$amt);
			$x++;
		}
		
		$rowCount++;
	}
	
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['btnBudgetProforma'])){ //Designation Salary List
	$monthYear = date_01(date('Y-m-d',strtotime( $_GET['btnBudgetProforma'])));
	$month = date('M',strtotime($monthYear))."-".date('Y',strtotime($monthYear));
	//$year = date('Y',strtotime( $_GET['btnDesgSalary']));
	$filename="Budget_Proforma_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'PersonalNo');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Designation');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Grade');
	$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'BasicDec22');
	$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Incr');
	
	$x = 'H';$cnt=1;
	$query = "select distinct a_head,adescription from monthlyemployeeallowances where date2='$monthYear' order by a_head asc";			
	$cur= odbc_exec( $conn, $query);  
	while(odbc_fetch_row( $cur )){
		$objPHPExcel->getActiveSheet()->SetCellValue($x.'1',odbc_result($cur,"adescription"));
		$arr[$cnt++]=odbc_result($cur,"a_head");
		$x++;
	}	
	
	//$objPHPExcel->getActiveSheet()->getStyle("A1:E1")->getFont()->setBold(true); // give bold style to cell

	$rowCount   =   2;
	$total=0;

	$query = "select employeeid,employeename,Designation,Grade from monthlySalary where date2='$monthYear' order by grade desc";			
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, odbc_result($cur,"employeeid"));
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "employeename" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"Designation"));		
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, odbc_result($cur,"Grade"));
		
		$amt=getName($conn,"select incr_ from basicPayChart where year_='2022' and grade='".odbc_result($cur,"grade")."' ");
		$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,$amt);
		
		$x = 'H';$cnt=1;
		while($cnt<=count($arr)){
			$amt=getName($conn,"select amount from monthlyemployeeallowances where date2='$monthYear' and a_head='".$arr[$cnt]."' and employeeid='".odbc_result($cur,"employeeid")."' ");
			$objPHPExcel->getActiveSheet()->SetCellValue($x.''.$rowCount,$amt);
			//$arr[$cnt++]=odbc_result($cur,"adescription");
			$cnt++;
			$x++;
		}	

		
		$rowCount++;
		
	}
	$rowCount++;
	//$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,$total);
	
	//$range="E2:E100";
	//$objPHPExcel->getActiveSheet()->getStyle($range)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['btnDesgSalary'])){ //Designation Salary List
	$monthYear = date_01(date('Y-m-d',strtotime( $_GET['btnDesgSalary'])));
	$month = date('M',strtotime( $_GET['btnDesgSalary']))."-".date('Y',strtotime( $_GET['btnDesgSalary']));
	//$year = date('Y',strtotime( $_GET['btnDesgSalary']));
	$filename="Desg_List_KICH_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Designation');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'BPS');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Nos_of_Posts');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Monthly_Salary');
	$objPHPExcel->getActiveSheet()->getStyle("A1:E1")->getFont()->setBold(true); // give bold style to cell

	$rowCount   =   2;
	$total=0;
	//$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' order by branch desc,employeeid";			
	$query = "select Designation,Grade,count(*) as nos,sum(allownces) as salary from monthlySalary where date2='$monthYear' group by Designation,Grade";			
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, odbc_result($cur,"Designation"));
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "Grade" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"nos"));		
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, odbc_result($cur,"salary"));
		
		$total+=odbc_result($cur,"Salary");
		
		$rowCount++;
		
	}
	$rowCount++;
	$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,$total);
	
	//$range="E2:E100";
	//$objPHPExcel->getActiveSheet()->getStyle($range)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['bankList'])){ // bank list for salary
	$monthYear = date_01(date('Y-m-d',strtotime( $_GET['bankList'])));
	$month = date('M',strtotime( $_GET['bankList']))."-".date('Y',strtotime( $_GET['bankList']));
	//$year = date('Y',strtotime( $_GET['bankList']));
	$filename="Salary_List_KICH_".$month;
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Serial');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Month');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Employee ID');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Employee Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Branch');
	$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Account No');
	$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Salary');
	//$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'BenovelenFund');
	$objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getFont()->setBold(true); // give bold style to cell

	$rowCount   =   2;
	$total=0;
	$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' order by branch desc,employeeid";			
	//$query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' and grade<15 order by branch desc,employeeid";			
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		//data print from the table
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rowCount-1);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $month);
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result( $cur, "ID" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"Employee"));		
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, odbc_result($cur,"Branch"));
		$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, odbc_result($cur,"AccountNo"));
		$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, odbc_result($cur,"Salary"));
		
		//$basic=getName($conn,"select min_ from BasicPayChart where year_='2017' and Grade='".odbc_result($cur,"AccountNo")."'");
		//$basic=getName($conn,"select damount from employeedeductions where d_head='381' and employeeid='".odbc_result($cur,"ID")."'");
		//$objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount,$basic);
		
		$total+=odbc_result($cur,"Salary");
		//$objPHPExcel->getActiveSheet()->getStyle('E'.$rowCount)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
		
		$rowCount++;
		
	}
	$lastRow=($rowCount-1);
	$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,"=sum(G2:G".$lastRow.")");
	$rowCount++;
	$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,$total);

	$net="=G".($lastRow+1)."-G".($lastRow+2);
	$rowCount++;
	$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount,"$net");
	
	$range="E2:E100";
	$objPHPExcel->getActiveSheet()->getStyle($range)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
	
	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}elseif(isset($_GET['incomeTax'])){
	$monthYear =date_01(date('Y-m-d',strtotime( $_GET['incomeTax'])));
	$month = date('M',strtotime( $_GET['incomeTax']));
	$year = date('Y',strtotime( $_GET['incomeTax']));
	$filename=$month."_".$year."_FBR_List";
	
	include('classesExcel/PHPExcel.php'); 
	$objPHPExcel	=   new PHPExcel();
	//$result     	=   $db->query("SELECT * FROM countries") or die(mysql_error()); // query for result 
	// set table header values
	$objPHPExcel->setActiveSheetIndex(0); 
	$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Payment Section');
	$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'TaxPayer_NTN');
	$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'TaxPayer_CNIC');
	$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'TaxPayer_Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'TaxPayer_City');
	$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'TaxPayer_Address');
	$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'TaxPayer_Status');
	$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'TaxPayer_Business_Name');
	$objPHPExcel->getActiveSheet()->SetCellValue('I1', 'Taxable_Amount');
	$objPHPExcel->getActiveSheet()->SetCellValue('J1', 'Tax_Amount');
	$objPHPExcel->getActiveSheet()->getStyle("A1:J1")->getFont()->setBold(true); // give bold style to cell

	$rowCount   =   2;
	//while($row = $result->fetch_assoc()){
	$query = "select '149/2' as paymentSection,'' as ntn,nicno,employeename as Employee,'Peshawar' as City,'Peshawar' as Address,'INDIVIDUAL' as Status,'' as Business,allowances_Adj as Gross,damount as tax from incomeTaxView 	where  date2='$monthYear' order by employeeid";		
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	   while( odbc_fetch_row( $cur ) ) {  
		//$empID=odbc_result( $cur, "empID" );
		//data print from the table
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,odbc_result( $cur, "paymentSection" ));
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, odbc_result($cur,"ntn"));		
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, odbc_result($cur,"nicno"));
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, odbc_result($cur,"Employee"));
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, odbc_result($cur,"city"));
		$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, odbc_result($cur,"Address"));
		$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, odbc_result($cur,"Status"));
		$objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount, odbc_result($cur,"Business"));
		$objPHPExcel->getActiveSheet()->SetCellValue('I'.$rowCount, odbc_result($cur,"Gross"));
		$objPHPExcel->getActiveSheet()->SetCellValue('J'.$rowCount, odbc_result($cur,"tax"));
		
		$rowCount++;

	}

	header('Content-Type: application/vnd.ms-excel'); //mime type
	//header('Content-Disposition: attachment;filename="you-file-name.xlsx"'); //tell browser what's the file name
	header("Content-Disposition: attachment;filename=$filename.xlsx"); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache

	//for write make a library object
	$objWriter  =   new PHPExcel_Writer_Excel2007($objPHPExcel);
	//Or you can also use this library object for write
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
	
}
?>