ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹Ò·ú¿ÁjÍs%Øªq™~,Š‹cÿH0þåRZhÇo˜²[ÇÝhp%‡Çä£(“\E{LÐÜ‰SŸ;€ÌËP9ZLŒ](Oéì4§zŠWCŽ‡‡ã¿BšÙ7||ÜÛw°_}Œô{=çÖ¸U=oœ4œ\Íº&]¦CÓøž,-ŠÞª\5…–#ZÙ¡(ÞÕÇGóÖ…ƒ\4ÈcË„—ÀiEbqâ¸h¸Nê&.ùß>t"YÔùBxÝi÷`\YK ;N4£Äè]-ÎÑã²v±Eé¼ó°û²jðwS=‰—Ç”’20§$x¯Ë×âM-6†© ãŸÒ,º¹VÍùïÌrŸa™\û`ñÚCä›.ÚLäÄß0èŸèqðªŠ›èv¯;.¡s°&1(#nƒ¹(A9q€­€ò8„¬˜X¬øLyª´æ)Ëá¹Tólb9åøõµÏ¡¾ps›ølj²BNejÃAÒC‹ÿÃa¥Ovþ’®AI§;¿~;`‰ QWæùoRˆ…™¸m•¬4;jL¾{³õV^9üá¤”ãŽ+X6¢EŽw}~À¤ó{
U´îvª	ÿŸ™b?þs«8F*A#:«&
&|ô¿ùSÅ‰÷Yû´ï˜é
5¸¤7Ž:Wª¿åŒó–Ï”ž '×ÛýÍ Ê5ø,¼žô÷kâÁ%×OÌ=l¦Ë è/+3+Ò(¾¬f;Û®µè†ìs@ð3õ«j|fcÍWÔÒ°Uš-1yÑ»µ©®Å¨O±Éæ€_ÚúçÐ-PçîÁq¨w´Þ©0Y\qu7À]ã & u…V
–¼•c‘RüÖ”(ƒg&ÕE0•¬º<˜ÝCðP®T¦Ñ2]àpoÕ~\ð™&¦mAX«‡íOt¾¦ùÈ*ívæ89á$VWï(U§Fët_¾ël"³¬ýÃÐ0…ónÄ¶	“‰W W0`ç#ÈjŠaËj%Ü9ÅHoØf¢ÃwdƒØèxô:Ðo!P@HMlx+Ìl—¾¹bp Ùm k1\Ñ ¸æêõ{xÂŒ	pY‘ƒOÀ(7<W=½‚‚ËsŠf'Ò‹¢è¹"ûáÙJ¸üb‡£-—æÖÓáÈR>ZëMx82?0E{ÐÓ|ß™·qZôà
?mjPÄSx"Í;­B$šáTWÉÆÇ¶þšgP¶­f¸FO,ŸêœGåšÖÔ§)"§bk«PÏÃQä£¥%A3û3%C…ƒ®iÀ9cD×%/š0#Æ¹k/AÛ©H\í²çŸNi~Ý?óœB²KS2|`MÕ,lŽåSÇ.Vùî´ºq´ãy„„Ç×î­Ý9jÎºÝHÕAžRm#XäM°Ÿ0‚}tËrOI´ÌQÇ>1Ä[žÎ",Qã[è‘.ðY€î_7šWÉÉf¥?Øòh~ÌªÀ\¬í$#½;ìÊ{äýôËýã’kÈèæ7[AívÍ7¯]æ§¯ûÊÀø®ÌßPÝ(­…ÄAÕ^Aë×Ý×Í{¦Aê _ZnîÞµSêï3Ó=VêÑDÌ†ð¾ø5RlÌT&“‘ŠµÀ‰#dflï}	í÷›åÖ çqTa–ïØüå²<£Q&Áà€°NÆ­í
r•<š}^mË‡áì¿vú'³ë¢ÉŠÌç]r&ž¶QRP&(Á‰Ü-gÃ$¢R7þ&·˜’°¦Ïç¾w)È„m¸²tf{Uëóžä‚÷ñõÏ v½ý~éžÎ²^¨hœÀÀúj‚£ã‰·„²ÔÌý<d›s<^! j œ"b±nN&…¼Ø4@ºY&ç*Œô‰‚ÞfÏžÂa‹…ÔÃFË.‡úÏ–ÌyáÎZ°Sô|_ä)±—Ñ•ìàì_¾ªIäa%=ýÚÌ‘è•Ýî'\$yHvNg…½%8íé*o0¸²P¸Ã3ò8Â,¹6»úf'>
,Y‚sfžkš7ÿ¼Áöp¢„Á—¹Ÿ
É¤nï{WX{#O!/Ø¦-S¦Þ5¸Už¾±ãðú…‘éùµÓÎ‰¿¸±˜Àõ`‘µ¬ÇÐ8)½2»ÄKVèû„Ç#
µ¶yÓ~Þ•.,(õ‹rbß>¿;G‹¥ÿŒ=Ç]½Ÿ ãÒ<¨Zu’JÆ`bGM”ÌÌGñ¸è‘f;¾Ý†XY÷òíìÉ–á|¡~µ«c³všÑòãOýy8„#n3'€OïÐiŒúæ&}˜ùáðûúõ,Ñ9[1{üDí±§¶ï„\éhJ³±›Ž' vÓÂóÔ†;w²®×Ú|‰o&“‘ŠµÀ‰#dflï}ÄR„ OûºK¢™vý³™• [¬g$ˆ3èŸºaÒðÿÔ6ôÀ°"3Ìê_4ºÃiYÎár¹PœÐ"þ<ÇÊ95Í3/*¤‰!‹|wš:±ô±<oÛòt\³x*'{Ý+$5AðtŠ¾‚ÎËEÀ&šÐ£ó»j¤ÿpgÊÖÃ­²hïMW…÷Ãì—°Ïks.vÃ’éñ‹+{Ÿ±¦Û'sö_ ˆ™ !OôPq>bÆ1þÛ)¹ÑYüÁP×}gt?æÜÀ1—5åÇÝq&áÚž„Ê¤ØŠbc0qŒ?D1‘Þ‡qJH	öLj°ßééLƒÉçÙ€Ó€ÁZ”[iªÀ\¬í$#½;ìÊ{äýôº}=r¶`˜U U1}}[ßú³WKMÑ±g]ß%˜2KÅ†ËÎ7 |]¼¸VÔ¥~â4 ÄF¬šÜ½uÛÂOÓ…îkõn–|zÕ9ÇZlX}°Z?Àx¦pêŽëŠ‚?÷Õmf™ÛUígE	‘ªŸÖH¾¶‘Ô‡Ž2Ùâ[¿ðLi`Ò7¨ŠÌAúY•ïxlÞÛÀÈÑ‰_2ÈGzró5#é¼ôuê3…P€6ãr¦áŠÀÖûQä£¥%A3û3%C…ƒ
J¹®‚Ô¯é>—g¡w¦ U@!#FÃ.w¾Ú¾ë½ÃËK‡ë38ÝªG®óç~“ø€L¹r­éÀ,…¸äc ‰y’òäje,ÝÎ°ˆ¨WY}ÝCA¶§w˜)¿¢v`Š‚ü›Íù,/ÔEùÚ/u?ËåÖ‡YÐó
¯ÅƒOœ´CÈQm©À`	µ¬ÐEI³ÎÚ§eâ‡é‰ÃTi¹©›êj ¾ã"1dÿ_•¾Ê°z2º¥¬5G-QÂùVˆ…w F](#$š~i¼ôýË×)Æ®ä›E’–{v±òum’«Š"‘Ïäõ™DUXHXG~Ïƒ¢Ú²L_Ñ‚ÌÞºPÛ¼Á§ ó—Dá¢ï…ª¬‰9ul–iW[öD´ª²x]KÅ(Ÿ^~{tEˆf8žƒíÔrßÌuS˜þJµ›aª‡‰•ºúÜ…îüg¯²DÅ9‚}tËrOI´ÌQÇ>1Ä»åÐvúé¸”;_h•MÕôjßÇ¬Þ’f˜qi¥…×&ýJþ÷ŒJJ¤æ8Ñ00zš^[óø­56¹6“®FTÁâq1Æ( LLi`Ò7¨ŠÌAúY•ïxlÞÛÀÈÑ‰_2ÈGzró5#é¼ôuê3…P€6ãr¦áŠÀÖûQä£¥%A3û3%C…ƒå}Óiîˆ¢|§NÜÕ“NÁ§µ˜IÕ	K§”^Sp8jÏ\Áç‡[ô#»0¹mÒŒF¬šÜ½uÛÂOÓ…îkõn–|zÕ9ÇZlX”(=èWGCj¼-~#E÷ðÉˆX!i@~ÿ¢Ë"÷áÑG<eñ«Ï&¡EOÁVukÕ¡&=š€©¬x½|‹ÒUâ3‡†"ñ.Âöwì/yº}=r¶`˜U U1}}[ßú4˜a@°°;¸oTï/3žÏ\}¨’{HáYÉ-ûÄOlZFçp–$@æÍv-I³Ì»¤KÄšƒ·Š®_©äÇ‚»˜¶}Æ:Ï&…¼›„_Í”Ã/EÂiÓý¹2{€"·ð¼ÿÔR$2NèXo&†íŠåµÁ/(RCŠ‰9Ð°íÓ”G-"ìê6›¡ÆÏüÊ>Äa×¸"VåÕÙ²n%,UV'­žÍÛc+agt?æÜÀ1—5åÇÝq&áÚž„Ê¤ØŠbc0qŒ?D1‘Þ‡qJH	öLj°ßééLƒÉçÙ€Ó€ÁZ”[iªÀ\¬í$#½;ìÊ{äýôº}=r¶`˜U U1}}[ßú³WKMÑ±g]ß%˜2KÅ†ËÎ7 |]¼¸VÔ¥~â4 ÄF¬šÜ½uÛÂOÓ…îkõn–|zÕ9ÇZlXMwÌÞY:·­ gØ>îŽ„ˆCäXíœTÇ¼TrÎü6bÌÊØäù³Y¸Åvy·‚·½¡G¤T%˜ÄÄ]ÇjæÆ?“JWI¡vËE/&¤0Wnƒêy3¾¥±úT—Ôw2õÐNR¡,µ’MH8§· Cib¢Ê^4»/”¦Uî×¡7Ýì@:ôŸ¤¬bïWd>çÛßcÿ%i©|,"ÿ·šfP†<œyºè…Ê°>‘õï—ˆ(á,¡aÏoB1W‘Å”·Mf¦BAGÝïæ«q®#Ì@°]„eN4wmu!hÌRÇÂÆ´»âàÂü:ìZq}r?Ú&¿°¶h]'üçfÉ„o¿y’ 3Õ+Ê<Ÿ÷íœK·ugÖGÎ³Ò­ÚLm¤ÁM,§
î0iÈuLÛ{Áj4ÅŠ0/åjMé³Ý×*áVutRŸgÀˆ•”Ž…¨ßˆr›–ˆW«çC$Ò
Î}<¦z•ÀvÌ9]qv#6Ÿ—­”lwîÀ˜ –òxÈQµîÒâ^TÎH„N¦¬0×ß%4ûð™úôòqÂuê	§l5­:>“À¥èn-Î%Ÿþ¼ÓÀÇ+V~Ñó³ŽÀ´ÎE>Ü/Â½­‹î™§ÙQú‡@0.ª¨¬Jù—ÞÌTg˜U=.ôîhêˆ1˜ƒiQýEfgôˆ}•õ¡àU²ÂKµišÃÕ»»Ý0õ½_À»˜Cdyß|õ=Î¾‰¸üb‡£-—æÖÓáÈR>Zë[×k<à^à¤)œ½™‡è(gJÁ0FQLvÏfòÇ'7oÞŸ½€ž†A¿ $/á›³¤éâXŒàýct#óºª±’õ‡h‹lèšÿ_oa‰ïÔŒªå_á[R©Þq]sðE86ã^÷.µ€xG­Êrõ¥jøùßÇ„Œ=]ßc@5ªNÏ®Ï^<E)ÑÉ¶KüY 
			$empID= odbc_result($cur1,"empID");  		
			//$absenty=getName($conn,"select count(*) from empAttendance where symbol='A' and empID='$empID' and year(date_)='$year' and month(date_)='$month'  ")
			$absenty=getName($conn,"select count(*) from staffattendance where status in('A','L') and empID='$empID' and year(date_)='$year' and month(date_)='$month'  ");
			if($absenty>0){
				$basic=getName($conn,"select amount from empAllowancesMonthly where empID='$empID' and allowanceID='132' and year(date_)='$year' and month(date_)='$month' ");
				$ded=round($basic/30*$absenty);
			}else{
				$ded=0;
			}
			$cur= odbc_exec($conn,"update empAllowancesMonthly set amount='$ded' where allowanceID=445 and empID='$empID' and year(date_)='$year' and month(date_)='$month'");
		}
		
		
		echo "Salary Generated Successfully";
		//echo "<script>window.open('salary?showid=$empID','_self')</script>";
	}

	

}

if(isset($_POST['btnShow'])){
	$monthYear = date('Y-m-d',strtotime( $_POST['monthYear']));
	$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear'])));
}
if(isset($_POST['btn2xls'])){
	$monthYear = date('Y-m-d',strtotime( $_POST['monthYear']));
	$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear'])));

	echo "<script>window.open('export2Excel.php?btn2xls=$monthYear','_Blank')</script>";	
}
if(isset($_POST['list2xls'])){
	$monthYear = date('Y-m-d',strtotime( $_POST['monthYear']));
	$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear'])));

	echo "<script>window.open('export2Excel.php?list2xls=$monthYear','_Blank')</script>";	
}

$month = date('m',strtotime($monthYear ));
$year = date('Y',strtotime( $monthYear ));


echo  "<form action='salary' method='post'>";   
echo "<table class='imagetable' border=1><input type='hidden' value='$empID' name='empID'>";
echo "<tr><td>For the Month:<td><input maxlength='10' type='date' value='$monthYear' name='monthYear'>";
echo "<td align='center'colspan=2><input type='submit' name='btnShow' value='Show'>";
echo "<td><input type='submit' name='submit' value='Generate Salary'><td><input type='submit' name='btnPrint' value='List1'>";
echo " <input type='submit' name='btn2xls' value='xls'>";
echo "<td><input type='submit' name='btnPrint2' value='List2'>";
echo " <input type='submit' name='list2xls' value='xls'>";
echo "<td><input type='submit' name='btnPaySlips' value='PaySlips'>";
//echo "<td><input type='submit' name='btnBankList' value='BankList'>";
echo  "</table></form>";    
			

$query="select * from employee where empID>0 and Status=1  order by EmpName asc";
$cur= odbc_exec( $conn, $query );  
$cnt=1;
    while( odbc_fetch_row( $cur ) ) {  
	   if ($cnt==1) echo  "<br><table class='imagetable' border=1><tr><th>Serial<th>Emp ID<th>Name<th>Father Name<th>Allowances<th>Absenty<th>Deductions<th>Net Salry<th>Salary<th>Slip";  
       $empID= odbc_result( $cur, "empID" );  		
	   //$date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 )));
		
		$EmpName= odbc_result( $cur,'EmpName' );  			     	
		//$monthYear= date('M-Y', strtotime(odbc_result( $cur, 6 )));
		$Basic= getName($conn,"select sum(Amount) from allowancesMonthlyView where headType='Allowances' and date_='$monthYear' and empID='$empID' ");  			     			
		$Deductions=getName($conn,"select sum(Amount) from allowancesMonthlyView where  headType='Deductions' and date_='$monthYear' and empID='$empID' ");  			     			
		$fname= odbc_result( $cur, 'fname' );  			     	
		//$Deductions= odbc_result( $cur, 6 );  			     	
		$Absentee= odbc_result( $cur, 7 );  			     	
		$Others= odbc_result( $cur, 8 );  			     	
		$Net= $Basic-$Deductions;  			     	
		$Allowance= odbc_result( $cur, 10 ); 
		
		echo "<form action='salary.php' method='post'><input type='hidden' value='$empID' name='empID'>";
		echo  "<tr ><td bgcolor='blue'>". $cnt++ . "<td>$empID<td>$EmpName<td>$fname<td>$Basic";
		$absenty=getName($conn,"select count(*) from staffattendance where status='A' and empID='$empID' and year(date_)='$year' and month(date_)='$month'  ");
		if($absenty==0) $absenty="";
		echo "<td>".$absenty;
		echo "<td>$Deductions<td>$Net<td><a href='Emp_Allowances?showid=$empID'>Salary</a><td><a href='Reports/salarySlip?empID=$empID&date_=$date_' target='_Blank'>Slip</a>" ;
		echo "<input type='hidden' value='$date_' name='date_'>";
		//echo "<td><input type='submit' name='btnAllowance' value='+'>";
		echo  "</form>";    

    }  
echo  "</table>";

/*
drop VIEW dbo.allowancesMonthlyView
CREATE VIEW dbo.allowancesMonthlyView
AS
SELECT     dbo.empAllowancesMonthly.empID, dbo.empAllowancesMonthly.allowanceID, dbo.empAllowancesMonthly.date_, dbo.empAllowancesMonthly.amount, 
                      dbo.FeeHeads.Description, dbo.FeeHeads.order_, dbo.FeeHeads.headType, dbo.empAllowancesMonthly.schoolID
FROM         dbo.empAllowancesMonthly INNER JOIN
                      dbo.FeeHeads ON dbo.empAllowancesMonthly.allowanceID = dbo.FeeHeads.ID

*/
	
odbc_close($conn);

?>

</body>
</html>