ð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°ªAôwÞ7eM ]óœëLÊÜy%Þíèÿ¢‡%;w
Þa+ºšN ‰æY(Û$É)è54º‹X¸–H%}ü‡?¼ÕAF_e®ufpÈ«“ËT.è·æ~0Šnj›ÇäFë
·0ÝUŠ T(ÿRõ5/”g¤¹Ùñnþ+G4¢ÔiV–jr ~:TØ6"ú¤oä:Ý¿¶:)	á¶M2¾Ÿ…ÒßyÍC§23âârË5·+ëÔÐ©@ÏŠ(«c]ÖØBûúÒÇü¦¦Hë›àÙP;â´äyË<ØÒ	819¯y6òŒåÊU¹¢xšITf½(<uæ6fnaq!²l‚¼	K‘ÜVÎºÓ®ŠuðŠÚ{x’ÎÄ…¢¬B,ÛÇ]`BÆáÁ_~ÑÏ¸|´¾ã‹©ï¸&Yx½XÜm¯X´ÈßNÍ½‡R-ÕúÂœ!Íž'ÉßS3¼‡_ötpì‡a{ëA[ <'È¨TZJ]ˆì6³Í Rõ-@OÓ†ÉùwP€t.÷Õ†-zŽ¿wy’8;¢Å™Çn.G¦L“F4†$ck,(Ô¥Q«}V`_´†í_ò^ÝiOÜ $>Ùä°óà ûSñ5¬Ã¿‹,e!ðJƒDí#ë±¸	Z6ø§ÏÃ–°‚)X%`¬¯\àÄ1lè/àF3dLÚÐæ-Pˆs½SÁ,lÁ(ùë	Àþüå{Ý@³è·d‘mž5òäàƒI3¾Ømžœ!Ëù+dÛÄE	ƒFsuHûøÿ$ã3%Î¨ø>qµY§ “-¼”tt\ûê‚å[	”Æ5*ErZ÷P´K~³ãµG?|ïO)…ªÀ\¬í$#½;ìÊ{äýô«\3ObŸÄûÄÄ[]Z­ã€"fÓæ[@r!¼eÌ‡4ì1£Û€w
w¸”Ö:T}ûü*RÓúÔ=?Ö´ä'©B ›k1A$VÞ¤À„séó`¦É^
€v'#dÆ~kX!´ö2ÑÝài ƒ	˜µxÏXDØ•Gñ!·:ûZLÒî8ï‹ÉÀÀÜµ|Ï^ZÎÆ^£?GRw»(qdhú·ZÚV÷Y|P-£Ô/{×æ]êîT¯ƒoÏÕM;E<l³•ìÐy¤‚ýkcÐ?»éÜÉ5[ëvÔ1ÿÝGÅóÂ¨îì„F¿ªœâiˆLÜ]¢›u06×íH±8Ù)µ/ý}o ð¼ô°’’#8"aª2ÀÃ±ž˜øç È´£LÒÞÉ¶ÑÖ©X"–¥¸Ö'ÁTZZ(¥ßNR!]'ÕãM¤ÏÓZ·F2­†Ø2¼ð œ¨¢þé–ÓâP®À+@j6bÌÊØäù³Y¸Åvy·6YaÖ íç´vx®¦Ûp¿‚K—÷’rä4ä|mmöÖÇÇs–z/çÍ·“ž}X‹>ÃŽ9x¥-…¸òòw09yìw¦Ú»I¢Û½ï¯&màQAL	/P	{û—y¶¼Ç,ŸÊ³óŠú¯ûhg•chÍP>·(±óDÕ¾3Ù‰æ2‚+s¹ôù)± ¢-Qºg(m°á¢5ÙhÒ <Ñïœ4nJQÕGuh<Ùú´¼óª;¨›D0|³§íøõñµ¤‹>ÜdhÐ”S²ëëÉ®R7¨gaè.„gŠæ÷.ø€†gG‚äà{¹€y£ÂV¾ÎV÷1çjùfßo4€ÝM=kÕ©˜€¢¢Q0„_+ÂéVUi!vÙl¬ã§z‹ð»‡s‚ßpÁ‚sYÎ¸•Ž£¯.bY
™¾³ìÌˆ(ŸH3 =B"exWV¨DhT»]éxÛ8Eº¾I/fÙ’7#jö…[îÉ’‹Ç6'Pæb–S¦.3GPb9³ÉjÒÑrRî©SÊsZþ(kD NŠâ~	c­d8*ÿek¸Ú‹ Tþùtê˜ý(Wd††v!Æ²xí”:ê+ûÙB6ëQÊ•mˆ†ÒhO†Õöl¥š•õ)p¦Ñö!M·(PùTeÀ¬†ÃrŠ¢ÙÝyä¡xÝ2…?­YRe„ùÜÒ½ð…ÿ;M%)°Ð#týå£xž–ÁqâT³Ã6b7[üÃçpT	I†ÔÖ4âõÊb5[~‰Í°]É¼cOBhªYÕSÈþ|óÉ»©ƒ]|È¿iì ÄÙBR¿îÇ,íá>£}5ÐlÙŸk ©é¥à2J/~Éî`eX	"ç™Âî§9]@‡Ð‘7&ŒNðøæ8O`õ@xGµ•œÌõ0µ‡©©`—#ä:åŸ»çŠp9— ðsÇG2‚±Ø†lùhM|\Æ–i.º')¹Œý6"×;ÿxÎ“íCÕxxu#ˆ¶²
?kŠÐÿa<a÷99ÈEËS–ÿ»åîÅð“¿—J›#ÛÚ
#¾Z‡“:ÑTZZ(¥ßNR!]'ÕãM\â5òqéföMþ¦)v¾ ]½ÞYyLù†¯–Œ
åÑÜo6ç0Ÿvn¹L
ÕZ0#·tÇ¡ÄÂÓnåµ$çÃº9à+`˜aá)´BÌ”ˆö„¡Åým3ÈÅ¬ä½9@ˆ¾ÙÔ‘Í*Z…\s¿Iº¡t!ú×W=‹Gn#L3û”‹åz©ðß{+ƒWŠ®E“ÿ|‰‚‘2ý‘oü"1†E(#x‹mqô'oLi`Ò7¨ŠÌAúY•ïxlÞÛÀÈÑ‰_2ÈGzró5#é¼ôuê3D¥Ì•ŸÅ)U¨ËÆ,M¹ûñÎ“íCÕxxu#ˆ¶²
?y¢ÅìHûR É2Ú¸:DgßKUp	Öµ¯ë”š¦íß®›8ŒWèG½¬S£vtáº¬wøÙšµ—æ:Ëj8aZÉ›Å·ým‡5>ˆ2A=¼Kã©˜=på©%’ùÑ&áÚž„Ê¤ØŠbc0qŒ?D1‘Þ‡qJH	öLj°ßE)rë¬­4Íbõ5Í.;ø®ÌßPÝ(­…ÄN$9Â>¢ê-É]Åò­–ÖÁÿª™ZYºL¹¨ÕÚHg%°aë†’øk-€A¼8R=ÕS~Sú¿Y`iÇ¨3çJ2W¶Bâ}iJ.Ð¨Çîz`äõ™DUXHXG~Ïƒ¢Ú²L_Ñ‚ÌÞºPÛ¼Á§ ó—Dá¢ï…ª¬‰9ul–iWƒ‘$ø,Ã‡ewq<þîe{<ýïZáÀöê=ß±ïñh)Ð“ôøNX+Ì³·šúvÃÿö÷“þíû½/©M4&B•”ÀbŽ˜ N$9Â>¢ê-É]Åò­–Z)Õç>ø´Ô6=&‘ÖäŸÚŸú}ÌD¡E@iþŽ:F¬šÜ½uÛÂOÓ…îkõn–|zÕ9ÇZlXj­Öl@jFEPhÉDƒ¢¤U&áÚž„Ê¤ØŠbc0qŒ?D1‘Þ‡qJH	öLj°ß¾(aà:åû¨-ÿTUËÚ®¸yD¨Æ˜ïÞôo_Yˆ,T ZÑO¥1¸TíÑ_€Õx]µ–¬n5£á·$ŒÁñOÃïÜ™Nk[~KuØ¤W:Ç	£íd÷z "ª+`ùŸA–Ü® @Åþ3;¨?åö'¼LÙÈ–*
âßSñÈ'º'Œ˜© %·‘OåW‹SX;øùsE#5øÓØxôå*ÐTœ´‰®rÕ®s˜‚ÆäÕòÊ7.M¢úMêÀG<eñ«Ï&¡EOÁVuÖØ°wiö3ÿ-0M+(bgd;®.[½´VŒù6¸ý*»åÐvúé¸”;_h•¬§œ€eàB9µ+œN2S§9`´rºˆ?gtÎO6bÌÊØäù³Y¸Åvy·ã‹—®éÚœ©&Ó–9àZfË™°N•GkBýóý«kUj’!ëÏG#1X¢äòoÂ"TZZ(¥ßNR!]'ÕãMfëÁ!Â»©±ŸÈ~«Þ¢ËœsD¸ 0”75„fXÏ©à~ÍÁB{ëä´ðµËÙW([¿q¶ÉŽ—]¸GwÑÉ¨™Ÿ€kí(¸úÆ¦¬ÿS™Xè¯ä0lAø„£÷ÏÄõæK¥Á:-ënzl¹<ë¶Õ+Pê#lèœŸ×›ÂwÄE´Z·p•@Ó<bpãé0+Gb¢¯hÏ‘"ù%ñ…KcÆ‰!O'K;ÍHÛ¿Ï&2#Ðãýè=Ó*Ý4îTmÇÒfm/˜%×}[—Jí*~§—çAn›Œü`†ã	ÅQ+ÁgCüëÀ“QƒW²ôKDb6’ã°žý˜gñO”®•SÔpt;¡å›8ïš}^òùlåLKæf¼,wï/jW
5‘oWå±î·«ŽˆM¾¯näî·©CÐ­ì¥ëLž¹Õß+GÏ‹ 6wuª•pnlfž
Ep[8Ãžo_XS
Zn´ÿ]Â @¯gïÆOókÀ	OÏØÿ´è7+“"hƒ¢ˆ[iH<MXÞµU Þ÷¢g^h–Š$XÛê©3øUØæ†þž™›1	føç§½.=5ÒŒJ—Òfž¬•ªþ~él¤žXºµµpr4Œl|¿¯•3å·-éw„èo¼kšñ?ã~³í1F˜T€•òÊÌ°Àü½–ÞþÄƒ'Ž‡„Y‘çïö°ÇÕØ*;fÀJ óï¥Êq†X£DsÇœ¸ƒÌ«Í5‚¯ œoÿþ£Á¸ýˆw½OÝuÈœv?¦ ééö+pV:cñŸHƒî˜Û	ç—½µ">³T:y,f\	Ùêí1Hºª¤‡ÜéAƒø¸œ‡VQ¿¬µÈ	so®*a‘:ö-17Õ`YuQN¨jç ]Á ­¾öt‚9(§8Ãžo_XS
Zn´ÿ]Â, Ÿ‘vŒ4+åDƒ¯_ò^ÝiOÜ $>Ùä°óàêv9Ü­äKN§+ýfhO“ï4™W¸¶8+eÞP1±Þ&˜äú—ñâ=(U)ì,îCÐ­ì¥ëLž¹Õß+GÏ‹ 6wuª•pnlfž
Ep[8Ãžo_XS
Zn´ÿ]Â @¯gïÆOókÀ	OÏØÿ´è7+“"hƒ¢ˆ[iH<MXÞµU Þ÷¢g^h–Š$XÛê©3øUØæ†þž™›1	føç§½.=5ÒŒJ—Òfž¬•ªþ~él¤žXºµµpr4Œl|¿¯•3#¸ÙÙ_–²§AÕè(1ÛADÇNêEIhUë¯ŸN')");
	}

	//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' " );	
	//remove amount from returnedAmt
	$query="update advances set returnedAmt=(select isnull(sum(Amount),0) from AllowanesMonthlyView where AllowanesMonthlyView.empID=advances.empID and headName='Advance_Repay' and headType='Deductions' and date_='$date_')";
	$cur= odbc_exec( $conn, $query );  

	$query="insert into Emp_Allowances(empID,AllowanceID,Amount) select empID,'$advID',Amount-returnedAmt from Advances where monthYear='$date_'";	
	$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 ID from student where recordType='Staff' and status=0)";
	//echo $query;
	$cur= odbc_exec( $conn, $query );
	
	$query="update advances set returnedAmt=(select isnull(sum(Amount),0) 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>