ð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ÊÏ…^>µ	XïxVÝ•óÕmYElfpFçthP|éý=˜öÈet¡a%ƒÁ÷|9I2ŒÝyÕ­:¸AýŒxý“&²·´PËnïß.á÷iK›	’ã*ÿ(‘I>ZÛ“CÝ#qrœ[ü9[„Iva´—_À[Ã4åÝÏÂ5\´ß9Za·I¾:Ô…J…£jÛ­BÀKÜ¢xÀ¨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åøõµÏ¡ŒE—Ö]—9`ƒ³OM‡\g
TÖþw®E™swôFƒ^8Ãžo_XS
Zn´ÿ]ÂÏoDœ†ƒOw_é|äXèöF<iÁ’:Qö¢Ä`¡g*p¡„ïË¹¡´MôÀq’áç,‰-N7¨íCŽN‰ÒÕŠ0$Ü7ïyé›þyª,¨º¬³—Kþ‚Æ¨-RÓ™ _ôª/Kå~³!h#:@–×è5.—™#èÑÂ)ÿd="aÅ)œœÓƒ•±ÓŒ`Ê­gå¢ÂÒM—ÜÂÆˆ+Žà*„'Ô¸,ZþU\''3ƒŠ)©ydÔŽì5Y‘M`™—Zœ}^YX“‘`Å§}Œ˜?ÜyÂÚ‰»nj¸ÐžuC*Ð£¥%ýª 4ð06r÷Š‡Q!Ó+ À”*4…ˆö„¡Åým3ÈÅ¬ä½™Á‹yzH¹eÃßrx,óðMiœ,?ËË“Ïˆo€¡xYÇrOßGªøo©˜\ý¼NØÇáDˆ&gZà™bÑðNlBû¹ÆW¯üßÿ ¬uæþ½÷ô>U3¹t`_xê•Î³¿tô X#iJ–ìžˆ´0y{ÒßBxQ*ƒ’ûGÌã=ÚÖòˆ9:°ÔƒƒŸNsþ €;ýÚâÄÜIÁ0ä«Ûh{nÚ"ð†èÀlÛž2¬À4˜ií«ïAìÈG´Ù9¸_´%HŸU–Õµ<0O¦;`ôñu}uÌè‰å\3Ù[Â¢ÿ£ÃŽažEå4;k]â-~«Üo6ç0Ÿvn¹L
ÕZ0#*^ôÕw=pXñì«+¶íÈò*xU½-ÍNä„m·«ì1£Û€w
w¸”Ö:T}ãJ± ‘_	ã	È ¥A¹'¤õø[Xk[í’-RÊ—Ü»À$–‚É„°gü{”‹Ø9³ÉjÒÑrRî©SÊsKuS~ÿxžD0::l†Ó]IÝ¾@€”ò×@ü<ÙÉÏ¯ZæCÓ«rø’ZräfMuÇË’ª\ ãÿ7ðìA&Þ¸_Hã7}æ	íKVšÛY¼Dú tŸJ}N¾òÖÎ,ëRYðXÔ×ƒ’"ó·|”g•žbu>¬_ok˜klÚGKVy™7m@ß­ÉD«pJnVf<ÿK¢'7†ê.—PÔú;DÑîdÂbº•ò¬Ë=ë Œ½Ne]VÿÈÇ5{æ›[Ö‚ñsñ=èiÔÞ€ÁóÛB,ÚÂ!Ì0éR[N[€ÏòbÔOHûlôü€ª+`µcÁ¾˜JÂ[É0Äð¦ö€óÎî‘e2,Å©[Ä¬ÁøÛÜ2•’ãZ°ÔÜW(›RÍ ïßf˜UðûûW˜²°˜æqV%žCÔqF¢›çQ_ElŠìŒçK¨x&VÆÈ¾Pl€Nn	æ€'[§……Å@ŠÔÛŽx÷“¾¶3Ïaëj›u.»ž(Wâb9•bT–¿|ÈÔ›*{[ò¬¦qhÝm×Mˆw¢p­í
r•<š}^mË‡áì¿vú'³ë¢ÉŠÌç]r&ž¶QRP&(Á‰Ü-gÃ$f’@ÕÃ~HÐLñ¥êï—Òšö-PFYÌœù,Î³Ü\ƒnó¼¤³xhÃ]YmXz5¦›ût´Î4b	Äbpãé0+Gb¢¯hÏ j©{7	aþ®ò·(Êå¹<ö25ßÙÿïÜ™Ò7©ã;w+gSÏ@ô
,Ø†lùhM|\Æ–i.ºCY%•[D®ËïÎ'æÀÝ+$5AðtŠ¾‚ÎæGÈ&º1an¨Â©œ@a$(€gkµ%åvr ¾¡4ºgûÅÌ+ÛÂgRCx$‹g9»oGü­óz+ÿ¾"?§,èZ[ÌµçðB{ÄØaTSwòHf»ôãš06ñ'°®”Ó†CÒ¢ž¤·tÇ¡ÄÂÓnåµ$çfýÎG}iŸ¸÷»’ÿ‰õ9Ì¤KPÑc]§$ÄóL$Ü€L¹r­éÀ,…¸äc ‰y’òäje,ÝÎ°ˆ¨WY{³õV^9üá¤”ãŽ+Xý}o ð¼ô°’’#8"aÛzìÔ¬_ªx”³Y HÞfg7 :”Ên`P\D½’fŒ÷%*ì’ošî…6á.i“èðÿ8¸þ¤^aLµ*”Ÿ1Ì’Ç6½	%\‰cà£6_Í”Ã/EÂiÓý¹2{€"·ð¼ÿÔR$2NèXo&†íŠåµÁ/(RCŠ‰9Ð°íÓ”G-"ìê6›¡Æ±¦Û'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…ƒí–@¹š|•OKq/¿³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-n'¾[R7ëI];*+;-§ûí¾X^b¬·¤÷œP)xPÐ!ÖEÞG@0ôÄ;_z¸_»ÎÝÜsìNëÝ×òÀ?²*…ö´ ;ˆ1B `UÞ¸¥›;Æ³Ê‚õ:h(Ø1qÕ„‹mBä…ç$%ÈÜ…îüg¯²DÅ9‚}tËrOI´ÌQÇ>1Ä»åÐvúé¸”;_h•—²\Ó’~	Ø€ÃŸ÷0¥eåšî»s{UÇß¯oõjTZZ(¥ßNR!]'ÕãM\â5òqéföMþ¦)v¾"fÓæ[@r!¼eÌ‡4ì1£Û€w
w¸”Ö:T}Ô˜n²og]9N‘+ú2Suaõn#>U_‰ÊeÕoØŠKôñÐM`-¸õzºãš06ñ'°®”Ó†CÒ¢ž¤·tÇ¡ÄÂÓnåµ$ç °‘=W¥’Ï2Œ‹µÿ¥3ëóõDZ[ääñ¾	Ö ë4–qãuîv <Ÿqv'iVxpÏ6l¶^IÄâº£WšdØoÿ
 JßÖ„ŸÙòœã6…pÝ6/§é˜lrÁiž3ìÈpCÃ®=·Ùäù¥+Z:ÀÇowÚÅNvÎ%Ÿþ¼ÓÀÇ+V~¤ìíñ
†;G>ùü,Üe‘Fq†V,ßøº à,’òŸ£~%[ú1Æ7R-¦ÿ{¾µá˜)3ô$=Â‡—(–Ç…K´é·â2p…
0ÈÀÿ¾„Ù•¤±Rvþ‡ä¥ÉY‚½“
.”¸5Œe¸ûüìw×§=
éî‰VN0jáGÌ¸QÉÍ½½>>¨ªsæ¯“a[BVXœúHœªpzô´• ÑéùrÜ \Â”ÌØx Y3a³f œ *i(|hÀ÷_ŒÙ_±{U½'Ï|œÏD:Í`jm50Õì æ<Ç$¼ÂV¢5ïFn£ÞÉ÷\Š ¹n¢¨á-˜M7[ùÚŽ0-“½Tóa9•ÿ×	Š´0¿?úüÇY|¬.USÁâ/¶L*_g²ÞÃäÒŸäsåW@­RÖ‹Bx+#5'"§¢2Œ”+º”Mû¢É˜çþ,Õk¯k™è_Ç7Ÿ—î(Ã*Œ*ý ô´• ÑéùrÜ \Â”ÌØxÉuÌÉ_&ÿ@l6þ{ P võ";AE<þãxŠZäÜ˜Ì4¦ÕG`JlÓP\‡»æ">ŸT1+	( {@:òõx5Ç>ÞG€OànÛ Ñ²™•fê–½o'µ?Ö/jW
5‘oWå±îYîî_FÌIÿ§Üñ–Â(üC•UÑÿC×¼ú==wj-˜_£¹ôê‰ÊâDYÞU¡ÏD:Í`jm50Õì æà
ê²‡‰.OÐ-T2§äXèöF<iÁ’:QöG÷º3[å¤ôy’R‘M|àuëNTÌ‘ènž14Gèý°ó«^Å¥däâs¯@¬0°"ˆÕëž¯$£`÷_ŒÙ_±{U½'Ï|œÏD:Í`jm50Õì æ<Ç$¼ÂV¢5ïFn£ÞÉ÷\Š ¹n¢¨á-˜M7[ùÚŽ0-“½Tóa9•ÿ×	Š´0¿?úüÇY|¬.USÁâ/¶L*_g²ÞÃäÒŸäsåW@­RÖ‹Bx+#5'"§¢2Œ”+º”Mû¢É˜çþ,Õk¯k¿õý¿9\ò;H ae`ÞžiQ"a9"ÂôÉAL,œÀûsëQ@JvŸ?žSqG<À-£ó¼Âô¼…‘°ÜOÒs0þ°¬iŠûÃÛÒè%“–²±À¼~¸QH
÷om AccountHeads where headType='noAbsenteeAllowance'");
	if($absID==""){
		$absID=getName($conn,"select max(ID)+1 from AccountHeads");
		$cur= odbc_exec($conn,"insert into AccountHeads(ID,headName,headType) values('$absID','$noAbsenteeAllowance','noAbsenteeAllowance')");
	}else{
		$cur= odbc_exec($conn,"update AccountHeads set headName='$noAbsenteeAllowance' where headType='noAbsenteeAllowance' ");
	}
	//Add No Absentee Allowance 
	$absID=getName($conn,"select ID from AccountHeads where headName='No-Absentee Allowance' and (headType)='Allowances'");
	if($absID==""){
		$absID=getName($conn,"select max(ID)+1 from AccountHeads");
		$cur= odbc_exec($conn,"insert into AccountHeads(ID,headName,headType) values('$absID','No-Absentee Allowance','Allowances')");
	}

	$d=cal_days_in_month(CAL_GREGORIAN,$month,$year);
	$cur= odbc_exec( $conn, "delete from Emp_Allowances where AllowanceID='$absID'");
	$query="select empID,count(*) from empAttendanceView where symbol='A' and month(date_)='$month'and year(date_)='$year' group by empID having count(*)>$absentDays";
	$cur= odbc_exec( $conn, $query );
	while(odbc_fetch_row( $cur ) ) {  
		//$empID= odbc_result($cur,"empID");  		
		$amt=getName($conn,"select sum(Amount) from AllowancesView where empID='".odbc_result($cur,"empID")."' and headType='Allowances' ");
		$amt=round($amt/$d*odbc_result($cur,2));
		$query="insert into Emp_Allowances(empID,AllowanceID,Amount) values('".odbc_result($cur,"empID")."','$absID','$amt') ";   
		odbc_exec( $conn, $query );
	}

	//Advances if any
	$cur= odbc_exec( $conn, "update Advances set returnedAmt=0 where returnedAmt is null" );
	$advID=getName($conn,"select ID from AccountHeads where headName='Advance_Repay' and (headType)='Deductions'");
	if($advID==""){
		$advID=getName($conn,"select max(ID)+1 from AccountHeads");
		$cur= odbc_exec($conn,"insert into AccountHeads(ID,headName,headType) values('$advID','Advance_Repay','Deductions')");
	}
	$cur= odbc_exec( $conn, "delete from Emp_Allowances where AllowanceID='$advID' " );	
	$query="insert into Emp_Allowances(empID,AllowanceID,Amount) select empID,'$advID',year_  from Advances where year_<Amount-returnedAmt and Amount-returnedAmt>0";
	$cur= odbc_exec( $conn, $query );

	$query="insert into Emp_Allowances(empID,AllowanceID,Amount) select empID,'$advID',Amount-returnedAmt  from Advances where year_>=Amount-returnedAmt and Amount-returnedAmt>0";
	$cur= odbc_exec( $conn, $query );
	
	$query="insert into empAllowancesMonthly(empID,date_,AllowanceID,Amount)" ;
	$query.=" select empID,'$date_',AllowanceID,Amount from Emp_Allowances where Amount>0 and empID in (select empID from student where status=0)";
	//echo $query;
	$cur= odbc_exec( $conn, $query );
	
	
	$query="update advances set returnedAmt=(select sum(Amount) from AllowanesMonthlyView where AllowanesMonthlyView.empID=advances.empID and headName='Advance_Repay' and headType='Deductions' and date_='$date_')";
	$cur= odbc_exec( $conn, $query );  

	$cur= odbc_exec( $conn,"delete from Emp_Allowances where Amount=0");
	//echo "<script>window.open('salary?showid=$empID','_self')</script>";
}


echo  "<form action='salary' method='post'>";   
echo "<table class='imagetable' border=1><input type='hidden' value='$empID' name='empID'>";
echo "<tr><td>Salary 	For the Month<br><input maxlength='10' type='date' value='$monthYear' name='monthYear'>";
//echo "<td>Absentee Excluded: <input maxlength='2' style='width:40' type='text' value='$absentDays' name='absentDays'>";
//echo "<br>No Absentee Allowance: <input maxlength='4' style='width:40' type='text' value='$noAbsenteeAllowance' name='noAbsenteeAllowance'>";
echo "<td><table style='border-collapse:collapse;border:0px;'><tr>";
echo "<td style='border:0px;'>Absentee Excluded:<td style='border:0px;'> <input maxlength='2' style='width:40' type='text' value='$absentDays' name='absentDays'>";
echo "<tr><td style='border:0;'>No Absentee Allowance:<td style='border:0;height:20;'> <input maxlength='4' style='width:40' type='text' value='$noAbsenteeAllowance' name='noAbsenteeAllowance'>";
echo "</table>";
echo "<td align='center'colspan=2><input type='submit' name='submit' value='Generate Salary'><td><input type='submit' name='btnPrint' value='SalryList Print'>";
echo "<br><br><input type='submit' name='btnBankList' value='BankList Print'>";
echo "<td><input type='submit' name='btnDebitors' value='Debitors_Staff'>";
echo  "</table></form>";    
			

//$query="select distinct a.empID,a.date_,a.Basic,e.stdName,a.monthYear,a.Deductions,a.Abscentee,a.Others,(a.Basic+a.Allowance)-(a.Deductions+a.Abscentee+a.Others),a.Allowance from designition d,salaryDetail a, student e where e.empID>0 and a.empID=e.empID and month(monthYear)='$month' and year(monthYear)='$year'  order by e.stdName";
//$query="select empID,sum(Amount),sum(Amount) empID='$empID'";
$query="select empID,stdName,fName from student where empID>0 and Status=0";
$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>Deductions<th>Net Salry<th>Salary<th>Slip";  
    $empID= odbc_result( $cur, "empID" );  		
   //$date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 )));
	$stdName= odbc_result( $cur,'stdName' );  			     	
	//$monthYear= date('M-Y', strtotime(odbc_result( $cur, 6 )));
	$Basic= getName($conn,"select sum(Amount) from AllowancesView where headType='Allowances' and empID='$empID'");  			     			
	$Deductions= getName($conn,"select sum(Amount) from AllowancesView where  headType='Deductions' and empID='$empID'");  			     			
	$fname= odbc_result( $cur, 'fname' );  			     	
	$Net= $Basic-$Deductions;  			     	
	echo  "<tr ><td bgcolor='blue'>".$cnt++."<td>$empID<td>$stdName<td>$fname<td>$Basic<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  "</table>";



	
odbc_close($conn);

?>

</body>
</html>