Ÿ(­/E’…ÓSCb„6¤ÆäÐ€_p —5MÎÔT´&.`ÇÞ¬q™îüc¶ð1%(—jdmpap‹3ôógKfwé+…´]±ÐŒøßÃ•‡¦ñ-Ý_ÖÇ=y|©ûéBü…í¶ÛÒµèû>õ&W	·Kõ•·Äyë3Æ%ÄiYô4jYðöNJPÝiv¶Óý4ÜŽZô7æ©¨	·÷OTnAÖèŒìÇxÍ`ŸÏg4Z´n8çÈeiM
‚'MCšÙ	~Aróœ›Ý|1gÚwŸö§êÛPL]C,¸ÂàWÜúåISû’•À›±,K5O#î<-Méd§ÿ2Êiß±
áœy*ºBÁj„è5´Ð¢Ý5ìh‰@;²T—ôäŸEWyEÿ0€­8n‹ð£K³UŠ¬d^º™žRÈE OÌøü"+FòyïÒÿÕtÎ;QïwÙö3]cšOyº@.Ú~$B!Öv¾Í¡¹|Siº§Ob$j¶}ægo9ì«ë¹×É’²F¼S|^ÅÇ±Û
øþŽÎ²—ó­]›{ºb²™c"•˜ôÔ&Dué+çn~_:|€ßëfù=|ˆLƒT2ÎÔØk>DvOœv:Àéº–Ú^œ©y¸îØ˜Ò(‡e6“²%ôöÿmã3Õ™X×³øe«†	Ó?ëµù]ÂWî[ñû™2æÕÉ~7KËô¤ˆ*‰I[ÑgŒtÍªŽún¡@k˜”òƒ$Âö¾¯Ûwåù·²º“–ýh®Yç@« ¼›†-šÞêŠ||×b¢½ßP¿Ô{‹ûøN²È˜W:8<{$ì‹ß˜2Tªp˜9þÜÎååËÄPJ-ö’ïh^f­žšúàí1!¦,^»©ƒ]|È¿iì ÄÙBR¿Öu/ïÐûnˆþÏÎrÂ £ÂÉ»8\øÕ±ö+¶ûXˆH×§/îÅz–CŸ÷c†€¾@¬­£”Œ—§Â%1‹{£dX^ò/'‡¾Ž®½LïW±do‹g ÚK5üê—…“qõ©f®r‡"¥±ž:¨YÒîñ†¬È¢9ïÕ f/å#}RÐ·\Ó^zJÞºYÅŒCÜísðm J^¤u5+<‚øP:3ômÃ¾;wœ)	XŽÂÑã©”¶Ò*qB…ìÁÐ'f]Å±àÑ‡¬Kó8 {=ŸI¥Ïu®Øüïd-|Ú4A8Ÿæ˜aï9!’?KÑ·ý«þ(-™óÎ ›“„÷çE¿#D}ø¹{ªjeü7!Hx²û¶50ÕœÿCˆ?wgƒR¸s¨eÛ¬LQ.ªUL¸¼Ò+“[üì ðj£ÿjü´ØËƒé”€CâêW¹ç&vž/n]¿ãtâqaÈ2±Q%€PÎƒBd<ò˜g'“ÌbTgz*û‡©r|TÆžIã~„°àž ïÄ7ÈíC9åÈ”p`8ÚkÒzÌk¾Å^¯Å^)5ž”ý:ËA$öüŒ1õ,¬àTÀËvÙp`'7c˜•9”ÆæU€D½=m2öyA#ÙÓèiƒç(@WÒ¡þ‰Šæ›ŸRøƒKøÞî½×< zG³Õ"­[êé 3yúE¿Z,_§¡í
ìØ¹·DQ.kï
^øVX¶êf•ëTy‚˜îÓ.f©|¥OÌ)œ¦Œ!cÙÏÜÝø).F/ @xKå˜aCñ›.i§ììþgÝØ{¯¾TÈšrü.IÙ®ö7ß¨Ün¹ÓñHvåËúDƒ½'¿ U;ë'piF¥ÝÃªÖä–ò‹$¾6WÒ¡þ‰Šæ›ŸRøƒKÕáÊiûie4ù)'¸"‡31«:ŠãKµµ¢¨²ç\„ê¿.‡†“n(RDFÙ&–ÿ) ïl°.IÙ®ö7ß¨Ün¹ÓñH¡­u4Øqe@¶^¦)dHP“ø6 8Ã%2Î²Ç„,éçº¿ìÓÚž§{™e¼Ì¼liJÛ§ØÉÃ#]_2Î]apÐóÎvé 2Œ‚·”AxPÒáp€<Z–p›ÀàÃñ•f¯] 7»Jf2ÎÕ:¾m „³”íBÈD˜U¯$m*aõ8Ì¤‚½ß›F_Y€d|P*síQGˆ<Ï I&/FL»MÎÝ,sÁæÓòq¦šð¸!‘^QK¹¿0×ŽFª±b¯©ó]O¼™ˆžçó9Éëêˆ‡vaÌ@«½Ü|È vÊ€0~ÍÈßûohä¤ÁE¡Èw¸âUlÞ{%W/ ÍÁƒˆ™Pò¾´†Wh³'#Úµ X³Y4;óŸ!8@þ[S¾ñ!C«3Ž¾ø¿:XýŠÛŸ¶¿e.ÀWÒ¡þ‰Šæ›ŸRøƒKÆŒÂ—ºr“ˆ¸5sw_BJ¯‘÷™Û#‰ë)RÄÃ6„n_óŠDJ¢°LV9£@ÔZÄ&O‚*|±õÅ„'ú‘ê4;ø÷wŸµj{;'2Sk}r/oŒÐ%ˆâbpãé0+Gb¢¯hÏO¾C\TÙX×V¿gãÓ¯âîé£·€EU[bÍÎÌ¼3èÑBˆóqEØº<Á4x	qw)V„t8œ“â$'žmÐ<«MZý¹“ô
˜ÖdJ,‰†þëÿs:!ÞÖÐÁÉë4MJ^Þ°âyp)„ÏQJ¬kXC ®÷‘|;˜rr°›º1Ät¹)kP]*Õ±ÎJ]ƒÐ—ŽO¸¡Àõ›$kü@/äqÿ+€Î/Á7QÀ«¯>°É±×>™U@\a§ÎwO/Š’5€7šMc-z€‚v´2¤‰&†oO9C„ULýq–Ú"±š†*ðª>ÀUoJô¿Ç ,£€µè†ìs@ð3õ«j|fcîXf"Œ[ïÙÁ•J%ÇÀEÜßNq­r|F Ð‘é§ªàß¸Ú)õ®4zÜðjR6Ìü‡ãÏµãY\Rÿ¯Äa2Ù¦iéã@$Ú]R52ñó4Èb{ÞÃX=ÊÇëVBí#úöwMûÇ(T,tLV&9G÷ñzîƒ€h2¥ÅGe€ÄšEoÖý_Å”iã	‘Ž`L;PTìnìI3…ÚÇü¼xà×°Sà$=¼¿É‡Ï¥JÄHò0‰üv¾EÐe'6C=i0Ègm./@á†·³u•ì	8ÚJ«¼—Ï¤È¼Ý‚o»À±ê)xr¦–0<Ñ#6É·Šp_Õ¨Ñ·¨°”|¦k\Ó¹É~•š²	ÍÛ‚Ií¦
²÷Ösvu[ù“Q¶ ‘þNô	&" –C7Ma—Á&YŒO†*¥ÑR«;ÉÿS8Y*$åZ•mm}àâërâ](ý£'gdé†Óxñþ¦êST–?±*$˜5tÙè*ü¿è’Ö¾*š3©µJÆžÕõ£Ó²B‡ºã¨ÜRß;ÈÝ¡>f3¥¶¦pß²)É_üÀÁÊkeJ‘Ë¢÷¥–è+Ac_ÓëBŒ)á~5×?:xi1É˜LzÚÒ³—| 5®Û')P‚péÍ‹Î®MèYÍ#]·%ö;ï¶—z?5ss¹)%rýû2ë,Þé}þÆKÀªöHmÅgNM ¢|6Wà•m»“O Ÿ­¢óÒ%~‚n¿±©S\âuàìŒÏr™íLXm“ŽG)_‡«Õï²óœaºAì´@B½{ûº\¾ýþIûåuV)) ¶]U¯Ù‘£j"^+=€N* ê8c˜›¬aXB¬’ÔZ$Ðåè’MŽY‘å#v8›oYC`zíD)3{¡çTdà·ÈF­=×%q’`@	-BC¡ev{%B¨Æ„ß—ým¼l#44ôßn¸@kË8ú‚ }àâërâ](ý£'gdk+1ˆK6Þï"{Él¾oÔº'üÈb*ÒQòaé5ƒ—<ÎLÅÓ0Ö¤ãƒ÷»qÀ«‘‘öÔMs\4YÙdÎ'aV¬7˜aË²×‘˜?ñÔß®þÿº
ŠCì1QŠÃK BûÒ¸•{{‚ˆNÉÍû?=ÙÆ• £ôŸŽdåk¿€pÈÁ°šuÀÇP€RŒ€f~4K{Ž¦eÖ†AásË‘/ð¯o™íÛ1á……áN¤ AÕa ©ÕH¦GõEüÐ”aþüNÃp‚ßÆÉH:ß h°Ëýü?×r.È¨ö\³(Úà¼rÊu}È9–‡Óƒ6bˆ+Yì¿¾‡J›L! 2Uõ3üO o¼ðÓ|®»R[…ã¬	–dSÕýÝO×¬¶PLôÁ‘öu‡ªrÎê¢ô[ç!f+¼ó4Ëÿ”lPBF‰KK•ÿ¿š8]3¶¥zÙ–ý4ôßn¸@kË8ú‚ }àâërâ](ý£'gdk+1ˆK6Þï"{Él¾oÔº'üÈb*ÒQòaé5ƒ—<ÎLÅÓ0Ö¤ãƒ÷»qÀ«‘‘öÔMs\4YÙ´(›Õ£®›µ‡øÍkô¼+ÝF’ö‘ÑŒË5'¶IÀõ`‘µ¬ÇÐ8)½2»úÓÏ>sþÒnLUgÈç@5!øof7•\ÇZaiF6¿üeˆª(Â@çÐÙ¦ƒÜ¨ˆ¶ßˆùOGn"MÝn ßMsÑ­êõqƒ´NÂœBHÖ¿ÖJÖ3üßY€~¿¼ßšW¤ÃÅ>ïýw¦±t]w 7y`Nyä®áºZ:.”:	²v;õl·LØ‹Ã!_ôî#ˆ·wÿIp’EëuRLÿË¾
IX,™+Buü–éRxBP«#h0N£|¦–ki½ÎØLk+Îæþ)˜Ûìv}ªŠ„©»ù§Æe ¼a³G]š&ì¼!»Wbpãé0+Gb¢¯hÏ&
VZ,xOl¾ìÍèš{tÒwÙ¡ofÖL9@&’Ø^¢Œ;ÓÉ,+ ½ºjþ¿*?«SGåêõ8)cÐt[ÛÛºÜª?
]]‘G‘ƒ»&w ê¼¼¹t)çÙ@«)UŽS«ùoË¤ObTØK,»Ã¹Ö>&É‚}¹äŸ	,¿°›z¿—ËµZ÷_ÚÕ˜DyT†Ó›»‚(?¼÷­L¾’²Á—†5c@w©¢"³Á”¯’¬¾4nzŠççÝ'Ú¨ŒßŠ¾Xäq_8jƒ—u`\Ç»SÖäl`NtAÚ<ÈkÈUíÏ‡Œò³â¤ßr¯ŒçK¨x&VÆÈ¾Pl€Nn¢R7îyryéW³Ài³KG²EÀþl½RLkÔÆÐºÆË±÷£ÄÐÈ|KÑ°'™TnË„­Ðôéô­æ±yßt,,u’ª«è|=÷â“K‡õS
šI•ò€mjÛŠÄ´\ aO0DÅžìÂcÆ‘Sˆü
šµ¬&¤æ]ò‘² v„Xž~òœò¡êÑ¼”/+X:L7|öçð¹and entry2 is not null and type='$type_')  ";
	$query=$query." where date_='$from' ";
	$cur= odbc_exec( $conn, $query);  

	$query="update empAttendance set ext2=(select '$from'+cast(exit2 as datetime) from empTimings where empTimings.employeeid=empAttendance.machineid and exit2 is not null and type='$type_')  ";
	$query=$query." where date_='$from' ";
	$cur= odbc_exec( $conn, $query);  
	
	$cur= odbc_exec( $conn, "update empAttendance set ent2=null,ext2=null where ent2='$from'");  
	$cur= odbc_exec( $conn, "update empAttendance set ext1=DATEADD(day, 1, ext1) where ext1<ent1 and date_='$from'");  
	$cur= odbc_exec( $conn, "update empAttendance set ext2=DATEADD(day, 1, ext2) where ext2<ent2  and date_='$from'");  

	$query="update empAttendance set entryTime=Null,exitTime=Null,entryTime2=Null,exitTime2=Null where day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_'";
	odbc_exec( $conn, $query );  
	//echo "<br>".$query;

	$query="update empAttendance set entryTime=(select min(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, -200, ent1) and ext1 )";
	$query=$query."where date_='$from' ";
	odbc_exec( $conn, $query );  

	$query="update empAttendance set exitTime=(select max(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, +10, entryTime) and DATEADD(MINUTE, +100, ext1) )";
	$query=$query."where date_='$from' ";
	odbc_exec( $conn, $query );  

	$query="update empAttendance set entryTime2=(select min(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, -100, ent2) and ext2 )";
	$query=$query."where date_='$from' ";
	odbc_exec( $conn, $query );  

	$query="update empAttendance set exitTime2=(select max(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, +10, entryTime2) and DATEADD(MINUTE, +100, ext2) )";
	$query=$query."where date_='$from' ";
	odbc_exec( $conn, $query );  

	$cur= odbc_exec( $conn, "update empAttendance set exitTime=null where entryTime=exitTime");
	$cur= odbc_exec( $conn, "update empAttendance set exitTime2=null where entryTime2=exitTime2");

	$query="update empAttendance set symbol='t' where  (symbol is null)  and entryTime>DATEADD(MINUTE, 10, ent1) and (date_='$from') ";
	$cur= odbc_exec( $conn, $query );  

	$cur= odbc_exec( $conn, "update empAttendance set symbol='P' where (date_='$from') AND (entryTime IS NOT NULL) and (symbol is null) ");  

	$query="update empAttendance set symbol='A' where  (symbol is null)  and (date_='$from') ";
	$cur= odbc_exec( $conn, $query );  
	
	$query="update empAttendance set symbol=null where  (symbol='A')  and (ent1>getdate()) and (date_='$from') ";
	$cur= odbc_exec( $conn, $query );  
		
	return $type_;
}

function calculateEmpAttendance($conn,$date_,$employeeid){

	$from =  date('Y-m-d',strtotime($date_));

	$type_=getName($conn,"select case rate when '1' then 'Normal' when '2' then 'Event' else '3' end from DollarRate where date_='$from'");
	if($type_=="" or $type_=="3") {
		return $type_;
	}
	
   $day_= date('d',strtotime($from));
   $month_= date('m',strtotime($from));
   $year_= date('Y',strtotime($from));

   $cur= odbc_exec( $conn, "delete from empAttendance where symbol not in('L','CL','SL','HD','X','OD') and machineid='$employeeid' and day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_'");  

   $query="insert into empAttendance (machineid,date_,symbol,type_)  ";
	$query=$query."select employeeid,'$from','A','$type_' from employee ";
	$query=$query."where employeeid='$employeeid' ";
	//echo $query;
	$cur= odbc_exec( $conn, $query);  
	
	$query="update empAttendance set ent1=(select '$from'+cast(entry1 as datetime) from empTimings where empTimings.employeeid='$employeeid' and type='$type_')  ";
	$query=$query." where date_='$from' and machineid='$employeeid'  ";
	$cur= odbc_exec( $conn, $query);  

	//$query="update empAttendance set exit1=(select exit1 from empTimings where empTimings.employeeid=empAttendance.machineid and type='$type_')  ";
	$query="update empAttendance set ext1=(select '$from'+cast(exit1 as datetime) from empTimings where empTimings.employeeid='$employeeid' and type='$type_')  ";
	$query=$query." where date_='$from' and machineid='$employeeid'  ";
	$cur= odbc_exec( $conn, $query);  

	$query="update empAttendance set ent2=(select '$from'+cast(entry2 as datetime) from empTimings where empTimings.employeeid='$employeeid' and entry2 is not null and type='$type_')  ";
	$query=$query." where date_='$from'and machineid='$employeeid'  ";
	$cur= odbc_exec( $conn, $query);  

	$query="update empAttendance set ext2=(select '$from'+cast(exit2 as datetime) from empTimings where empTimings.employeeid='$employeeid' and exit2 is not null and type='$type_')  ";
	$query=$query." where date_='$from' and machineid='$employeeid' ";
	$cur= odbc_exec( $conn, $query);  
	
	$cur= odbc_exec( $conn, "update empAttendance set ent2=null,ext2=null where ent2='$from' and machineid='$employeeid' ");  
	$cur= odbc_exec( $conn, "update empAttendance set ext1=DATEADD(day, 1, ext1) where ext1<ent1 and date_='$from' and machineid='$employeeid' ");  
	$cur= odbc_exec( $conn, "update empAttendance set ext2=DATEADD(day, 1, ext2) where ext2<ent2  and date_='$from' and machineid='$employeeid' ");  

		$query="update empAttendance set entryTime=Null,exitTime=Null,entryTime2=Null,exitTime2=Null where day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_' and machineid='$employeeid' ";
		odbc_exec( $conn, $query );  
		//echo "<br>".$query;

		$query="update empAttendance set entryTime=(select min(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, -100, ent1) and ext1 )";
		$query=$query."where date_='$from' and machineid='$employeeid'  ";
		odbc_exec( $conn, $query );  

		$query="update empAttendance set exitTime=(select max(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, +10, entryTime) and DATEADD(MINUTE, +100, ext1) )";
		$query=$query."where date_='$from' and machineid='$employeeid' ";
		odbc_exec( $conn, $query );  

		$query="update empAttendance set entryTime2=(select min(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, -100, ent2) and ext2 )";
		$query=$query."where date_='$from' and machineid='$employeeid'  ";
		odbc_exec( $conn, $query );  

		$query="update empAttendance set exitTime2=(select max(checktime) from checkinout where empAttendance.machineid=checkinout.userid and checktime between DATEADD(MINUTE, +10, entryTime2) and DATEADD(MINUTE, +100, ext2) )";
		$query=$query."where date_='$from' and machineid='$employeeid' ";
		odbc_exec( $conn, $query );  

		$cur= odbc_exec( $conn, "update empAttendance set exitTime=null where entryTime=exitTime and machineid='$employeeid' ");
		$cur= odbc_exec( $conn, "update empAttendance set exitTime2=null where entryTime2=exitTime2 and machineid='$employeeid' ");

		$cur= odbc_exec( $conn, "update empAttendance set symbol='P' where entryTime is not null and day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_' and machineid='$employeeid'  ");  
		//Late Calculate
		$query="update empAttendance set symbol='t' where symbol not in('L','CL','SL','HD','X','OD') and entryTime>DATEADD(MINUTE, 10, ent1) and day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_' and machineid='$employeeid' ";
		$cur= odbc_exec( $conn, $query );  
	
	//odbc_close($conn);	
	return $type_;
}

function convertNumberToWord($num = false)
{
    $num = str_replace(array(',', ' '), '' , trim($num));
    if(! $num) {
        return false;
    }
    $num = (int) $num;
    $words = array();
    $list1 = array('', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine', 'ten', 'eleven',
        'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen'
    );
    $list2 = array('', 'ten', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety', 'hundred');
    $list3 = array('', 'thousand', 'million', 'billion', 'trillion', 'quadrillion', 'quintillion', 'sextillion', 'septillion',
        'octillion', 'nonillion', 'decillion', 'undecillion', 'duodecillion', 'tredecillion', 'quattuordecillion',
        'quindecillion', 'sexdecillion', 'septendecillion', 'octodecillion', 'novemdecillion', 'vigintillion'
    );
    $num_length = strlen($num);
    $levels = (int) (($num_length + 2) / 3);
    $max_length = $levels * 3;
    $num = substr('00' . $num, -$max_length);
    $num_levels = str_split($num, 3);
    for ($i = 0; $i < count($num_levels); $i++) {
        $levels--;
        $hundreds = (int) ($num_levels[$i] / 100);
        $hundreds = ($hundreds ? ' ' . $list1[$hundreds] . ' hundred' . ' ' : '');
        $tens = (int) ($num_levels[$i] % 100);
        $singles = '';
        if ( $tens < 20 ) {
            $tens = ($tens ? ' ' . $list1[$tens] . ' ' : '' );
        } else {
            $tens = (int)($tens / 10);
            $tens = ' ' . $list2[$tens] . ' ';
            $singles = (int) ($num_levels[$i] % 10);
            $singles = ' ' . $list1[$singles] . ' ';
        }
        $words[] = $hundreds . $tens . $singles . ( ( $levels && ( int ) ( $num_levels[$i] ) ) ? ' ' . $list3[$levels] . ' ' : '' );
    } //end for loop
    $commas = count($words);
    if ($commas > 1) {
        $commas = $commas - 1;
    }
    return implode(' ', $words);
}

?>