Ÿ(­/E’…ÓSCb„6¤ÆäÐ€_p —5MÎÔT´&.`lßN÷'¢ìS¤àºœ_úQð7½é¯¾‰I5á$âÞÓ<ö^Û@Enï¾Å9lÂØ[4®Å“ÆÌ,UUB;GæÚ1ú­2³Æið£v¥8ù¥›X¿|ãŒ x·C€Ä®»«å¡‹¸À¦Çß—â°à1*¥;| *QvØ§ÝèN%SwÏŠð\Š³Ý»a•LñÊ•û#1•mþÿ1}ÒÖ¬"ñô	¿9ª’:ã¼±šÆôv8Þ?­6è’NÔ¿UcaÁ¨ÎÙõÝ¸þ¢ÕG¶¬tÃGæ’a*è˜9lçìà`²Ön®Ÿ¡gypÁŽËè¹„ »Rã×€Mö0VøHq]"ëîÅ1SŸ-˜¡Ùñ-Œ»ö(®ŸçQ]—¶:×€Yƒ‚b,;±ÃÉì½‡Ù,äëw¼ØL´É‰Ø¶Gé%ÜÓ.ÁÙ|4ºj‹/öê®šöƒ›8<:›„x²¶q"©#É@²×AÞZfŠ•ù¡ì-8¹abÃI ÓŠ™»2Ùï7; ðO\yã3œGðöÇÕ¼vÂ@‹d3À›`Ð@YÆ
â:)Åk÷¢ïŒFúÎÅùƒoûáC^uÏ¸¢ŒÁ·!å[nœYŽáN¾œ2á™=ùO¡¹¼£Â)Vìgß·¦ž¨_ì¸óq|Qÿ0†ù§†‘ §=Ã 8Ò¤Û…Ê;Ö€®Æ•O·ÆîPífx€2é»Àÿ,Àfºü7Wþ}×?¹b:„Ìïà}-Ž…Ç¹·Ñ•DVù
¸cò:BEõ‡ó3Ÿ\q™<œH}þ¬G‡ä=©.õ‡ÓýÂ¼Ñ–¦ùÂ*bv<MH|¸Wý·Ä	ÂÿŸJ¾´ÓØ$F³ýÄcááôÝrpxÆ@uÐ®† É#<ÔKÞ«ð;ÿàxtïÃÿö°‹Êäd[X@dÝº._aÒQ¾_‡h7
VˆãQêÎ‰šûÄX!ß3	1ÌÝ‰ÒÜ.#:\ŸO©ÛÚ¢O€,•²îê¯(»§€³qÚnî#éQä8‰ |}„mpEöÜ=ÈÄeä¼,’ÌÔV¼ç3à7¨äŸ[rËÂZçÕµ>½ÅKK%-zÃ¤a #Ã	¦0†ÐïhÆ=”ÊDcèê^FÓõE²%PTé}Åj}ðÑË»`ÀHß¹iš:ékORãp™:¬JPxKLÀ5:r¦ösb?îóüØÛ,[ÔÝþíÐ´gÓl i:ªx‚nøC¢÷ã´Ò«ÕH&PNEõNw]²‚}¨Í_÷Š£ˆÏ>¼t
>×F!ýn·úÖ#‡ÖŸ™‚53Jƒå±
<ÄW¹XÌp"â÷×£)%áAÍaÕ€y|@Ô6›ÅÛ18;Ü3·pçØz
wŸGNO­‘ÖÑà/3í…ÛrÄœ§Û¹¤óécyZjhÒ3Œà3 èÆb1kÏa	Ñ-¨²¹í÷Ç!BÒ› žhZÑ«\´ëì¹T‹û¥0/pªÝD,\«±hÓC¬^éè­D]Ë8dðx“UÚSwSlÛ¬žÿw‹K@²ë1gJvQÙÖ™Ž±Ó´k©¿ÉN'Jùìe«l¸ð²bO×öujDWg3ÍúüÙòÿúûFÏû4Û0 Ñ?ÖùQBŽ-±„ º˜èÿþ6Œ‹Ú(Úå´ß¯{’›"öOÒÜÀ£(’åÇˆw#åÉ£µ¶L×Zœ“/ÃpÉ0œu¾ª¥a
öÝ;´SV@Éve1U´Ê«‘±û/äÄwš‡2ª“µÝ—Ûì³ƒ­ÌÔiÞxçà£ˆn1©îðUWfýôZ÷N4yàú¦
j=F%&^~„ %Ã7gî–F¡tž•¥7–ó
ŠrC¸Í|üÌÍ×tþe:²8Ï=”í%:~Á,{ƒ…±&Š$Roår4àn'0U`ñvÿGvÂ§~n³ë³"eèÿéÉÚÇ³y¾ÂÍÃ/pa@óäòüUA·n¨¼¯r8ƒÁò×Ž¹‚ ©ÐÀÙÁ®×^ÚÍ}s¯3)!î!€Á}SyB*{ËÖºGÉ[îlŽl*A=—Zewo„iwë®ñûBzl¦ƒZ-ž	VÇ‹ÝqÈ¥3wXvŒk¨ï¼¥Ëu¯®þ±—+5¢‘$ËŸ •*qçB:ÿÁË;$ì­ØNÏñV-l=ü¯ÏââÔ¥õ0^S5Ç¬Ó¤O#:Pa;°ý¸ä¾}è)ƒžS¿º¹ïLnÄàC#’.a{›£QÝMúYIÍÕtÔ¢tŠ„!šl!’¾ž`(¶U‚kKº³+4ú´m¼ÞPîv¼{Á,"žSoÁ›^Ö·ž7`Øf§1ó§+ìqmz—eò3žäey«³JÓÊý:sd,D6™1„~þ å{ê¦×&°1Ä˜aþ¼Ü?Ì;Ñä.º»W(«ãi—×íHÎ]ƒæƒ*¨X3·–1(,‰÷cìz…8sD;	 ~‚ˆNÉÍû?=ÙÆ• £ôŸŽÊ&ØSªàSgjÂ€˜¦îVåtñæ‰Î	yh›ðCäóD©"Ô $uéê)—>‰È$Zc"Jm¾Ü’Ã†Q? X‘òêüãF8Ü
”¤.°H›»m’' ÇsêÖ‘¯¦¿ÃNÏ/Uã¬iõHp{%´[îZ}¢Vr>¦²âÆ¼Ü–6Ç¶ƒŸ î³k\CäàIWÐáÒ ?~F~ñL4^v­wnÙ@´*.{í'C´¾ÏEÒ¢)ÈÇ”à¾ö(tË¶£úÕúÏ§ÀÀò<¡° D·Q—Âó1¼^(\PX¨ZaF(²âÆ¼Ü–6Ç¶ƒŸ î³k\CäàIWÐáÒ ?~Féùešü¦Ñš®ÏÈ˜u\†njsOeAÅýÆtÄ·<KPQ²·¡ž¨±É‰µWŠVV³.×ÞMmêäŒD™Ö6	®˜“d£NÑ:Ñ ±ë˜*ß÷,æû¡:(Gÿ]Ôøèÿ¸RdcaN{Aˆ'†iÛîÙKþ‚Æ¨-RÓ™ _”Š‚§)æ"À:Î‡xØèÿéÉÚÇ³y¾ÂÍÃ/þ¸ç#0E£5‘C¬YÕyÿÄè F«áª;5>B÷ô8HÍ5ÆóÆƒáàwÖóÜ)Ào	QbÚxüp)ðƒ]÷Ú¶ Òê	ÏV»V)î»Šý‹Äé2€šZR=%ÂàRt¨ V3ØD))?¹#*|{

’ts3<Ô¼î"Ô“Ùè‡ÿ¤¶GÁß_Æ:R F˜(à6e37öy‡)ñQr×D?„hô&Q}Mßú5Ú´z¨Hˆ]‡YÑÜBó7Ä…LdiõìïûÍÐ’h.Î¯|–‡Nr'(c!øÝ½ÎD¾Ï³,¨¹O¥¼£†Ò@9%GÁ™*$ïzM=°¹0:ÜjtÓ#XUó"RB.cÞŸ™ìé.¸¾Ž;¼öVÞè‡¸_¤É¼)Ò¥;:CpYö¡~bÃÈµ¼ù;©ƒ¥Â°2ªÃ_oÒŠ”JñÙèús»ßËX(öR€i†*Ê.	S=Ntz 	«öóÜ{",`}Ù°`&u×‚E^ÀŒ¶T‰Á7§ABp8ëð,¢„û[jXˆ×KbúŸ|oÂÏ!—Æ?ùM¹Ø—|íF6„ÞÙ!UqU“ô:-,)º¡ÈbÌ}ˆ5æÏè±’-“ÚÏ²Ñ.3Övel7µG¹1·YDyF…åËF°Ò˜ñÉyÍ  ö€,ÁOD0=F\ê aš)ÂƒV“¸9&%Óª‡º­`÷‰èÝó¸‡m
óBa&uÑí KJ${Ê L×Ó„Ë‰t¨¸aÛæ²‘’÷}Ö Í¨DÝàŸÿ3Ãael"^çØt
0ÒÊ5´§ä£»èÀ=öâÊ>–8Líj[—d=©]r™h¤@ÑÍÄÇš.ß´xiŽúk¨ï¼¥Ëu¯®þ±—+5¢‘¦æ³“7à=~ø³°Õô—¤^ð°¨$Ù¸{QI¿‰ÓrÌòžò)b$ò]ó_^dcšýÔìGe}"	°"çbÅ'i[‘6EN¼(ƒ³Yl[—<‡³ýÜØÔÅî³pLâ´ †LTJÝÃÈ"ó¾ÓAÝôTøß#ã=
Èl¬˜‰·‘=CÊ=À´­Zðî‘ü6›òtZÁRQßïï®k%¦¦øšä·ðl¥„+ÄÝ(„ea³¿6r©³S|[êÖ“÷ß®ÓzU=j(ªñ!fCC„‚DÕÊœãíŽ8`y_Òú;fÏm^æwËkÜÍœfÏ*±³{vÂÃFò`ð&w™#›Ã¢b+Ê÷‰íí{Ž¢?cç´±
µ»³Üx·&6–ó;¥˜¥}}aýCM}0M¯56AbeMÛ­œY·:Ÿ\%¡Fª5sêCºæÏá³S_nm½%VÑÏe¢ûQ Ï$s$÷.ýžhþüõëÄåÙÖ–äþFXÜøÃ ]Õ¯WI?T©*×	)–±Óé†'ðEè©­®àv~&èÄCá@ž7›…R©5ìÁ~ûM‚ŽKv]Sgwü7Ü°½ai_âm´Äº%%=ç¿Dígç' (œé[IŽ²§ë{	ÂR>E †pwµpÓ•iàf/àéh6©Á‹53ûDø—ÝüGxu^C_Ë®¥«4@[¸Bãõ?‚OÞ™võ]¨y‘Ø-`Mh±TpE¶´X}“[#¥™ô¾ZC’À2«“ÞaÓ†9Ê	»žðu¾2>\Á 3âÀ$½Úµ¶‰ÎÙ@¤k…u.ÿ;	L°ù  ÷ö§àdR±”ýû%HORÄñK³”®ˆqôNž.±–„6õl,'^&ÙGUMÌqiü+‡VâÎW‡ÈRÅ^yRï&Š°N§Ö¾mh·ÜnŸó*ñ›cñ¡ýx=?U8on'»ÐŸaOôi‹Žr ÿJ‹}FWuºƒ´=qÓ?¦‹÷g$X†êsDŠb-¾åƒ˜WàÌÀ¥®Ñ5ì“²¤}6ÙV ÈP”â0Ú®q…šözPZ^õo¦Ï£Ùí³®³!KÃO5”ÖµÍ\>2(¢pnæêöXxÈIÉðí+í0$Ýwˆ­¢YæZ;È]<nžšn9Ü W"Þè=;’¡¡Qg?ü%"R œå^êƒGú½.¼u6Â¡­œÇxNÿ¼ÔJ9h»˜S/Öó’(«³YŒUT¯¹ŠÇ‘d*Â¢ÙèsÈBÅWäµÇäÔãd°³‰WHóˆZF~~›µÓUPÌ3|¾I˜º´H1HŠ”çÿqÒ•¢ß°b‹6xŸ»6üÆld_name($cur, $j);
			 if($field_name=='Phone 1 - Value' or  $field_name=='ntn' or $field_name=='Branch' or $field_name=='AccountNo')
				$ar[$field_name] ='="' . odbc_result($cur, $field_name) . '"';
			else
				$ar[$field_name] =odbc_result($cur, $field_name);
        }
        
        $array[$i] = $ar;
        $i++;
	}		
	foreach ($array as $fields) {
		fputcsv($fp, $fields);
	}
	fclose($fp);
	return ($fileName);
}
function addHead($conn,$headName)
{
	if(""==getName($conn,"select 1 from AccountHeads where isHead=1 and headType='$headName'") ){
		$maxID=getName($conn,"select max(ID)+1 from AccountHeads");
		$query="insert into AccountHeads (isHead,headID,ID,headName,headType) ";
		$query.=" values(1,0,'$maxID','$headName','$headName')";
		//$query.=" values(1,0,(select max(ID)+1 from AccountHeads),'$headName','$headName')  ";
		odbc_exec( $conn, $query );
	}
}
function addHeadValue($conn,$headType,$value)
{
	$maxID=getName($conn,"select ID from AccountHeads where headType='$headType'");
	if(""==$maxID ){
		$maxID=getName($conn,"select max(ID)+1 from AccountHeads");
		$query="insert into AccountHeads (isHead,headID,ID,headName,headType) ";
		$query.=" values(1,0,'$maxID','$value','$headType')";
		//$query.=" values(1,0,(select max(ID)+1 from AccountHeads),'$headName','$headName')  ";
		odbc_exec( $conn, $query );
	}else{
		$query="update AccountHeads set headName='$value' where ID='$maxID'";
		odbc_exec( $conn, $query );
	}
}
function calculateBalance($conn,$accountID)
{
	
	if($accountID=="0"){
		//$query="update student set balance=(select sum(monthly)-sum(amtReceived) from studentFee where studentFee.stdID=student.stdID and date_=(select max(date_) from studentFee) group by stdID)  ";
		$query="update student set Balance=admFee+(select isnull(sum(debit-credit),0)  from ledger where ledger.accountID=student.ID and student.recordType='Account')   ";	
	}else{
		$query="update student set balance=admFee+(select isnull(sum(debit-credit),0) from ledger where accountID='$accountID') where ID='$accountID' and recordType='Account'  ";	
	}
	odbc_exec( $conn, $query );
}

function date_01($date_)
{
	$x =  date('d',strtotime($date_));
	if($x>1){
		$y=$x-1;
		//$date_= $date_+y;
		$date_=date('Y-m-d', strtotime($date_. "- $y day"));
	}
	return ($date_);
}

function fillCMB($conn,$idSelected,$qry)
{
	//$query = "select max($fieldname) from  $tablename ";
	$opt="";
	$cur2= odbc_exec( $conn, $qry);
	while( odbc_fetch_row( $cur2 ) ) {  
		$id= odbc_result( $cur2, 1 );
		$name= odbc_result( $cur2, 2 );
		if($id==$idSelected)
			$opt.="<option value='$id' selected>$name</option>";
		else
			$opt.="<option value='$id'>$name</option>";
	}
	
	//odbc_close($conn);
	return ($opt);
	
}
function fillList($conn,$qry)
{
	$opt= "";
	$cur2= odbc_exec( $conn, $qry);
	while( odbc_fetch_row( $cur2 ) ) {  
		$opt.="<option value='".odbc_result( $cur2, 1 )."'>";
	}
	//return $opt."</datalist>";
	return $opt;
}

function protect($strg){
	//$strg = mysql_real_escape_string(trim(strip_tags(addslashes($strg))));
	 $strg = str_replace('=','',$strg);
	 $strg = str_replace('>','',$strg);
	 $strg = str_replace('<','',$strg);
	 $strg = str_replace('<=','',$strg);
	 $strg = str_replace('>=','',$strg);
	 $strg = str_replace('!=','',$strg);
	 $strg = str_replace('drop database','',$strg);
	 $strg = str_replace('drop table','',$strg);
	 $strg = str_replace('delete from','',$strg);	
	 $strg = str_replace('truncate table','',$strg);	
	 $strg = str_replace(';','',$strg);
	 $strg = str_replace('limit','',$strg);	
	 $strg = str_replace("'","''",$strg);		 
	 $strg = str_replace("insert into","''",$strg);		 
	 $strg = str_replace('--','',$strg);		  
	return $strg;
}


function getName($conn,$qry){
	//echo $qry;
	$cur2= odbc_exec( $conn, $qry);
	$getName="";
	while( odbc_fetch_row( $cur2 ) ) {  
		$getName= odbc_result( $cur2, 1 );
	}
	//odbc_close($conn);
	return ($getName);
}

  function calculateAttendanceNew($conn,$date_){
	//$lateMints=60;// getName($conn,"select openingBalance from AccountHeads where headType='lateMints' ")
	
	$from =  date('Y-m-d',strtotime($date_));	
	$day_= date('d',strtotime($from));
	$month_= date('m',strtotime($from));
	$year_= date('Y',strtotime($from));
	//$schoolID=$_SESSION['schoolID'];
/*	
	$cur=addColumn($conn,"Employee","machineid","int");
	$cur=addColumn($conn,"zkteco.dbo.checkinout","machineid","int");
	$cur=addColumn($conn,"empAttendance","machineid","int");
	$cur=addColumn($conn,"empAttendance","entryTime","datetime");
	$cur=addColumn($conn,"empAttendance","exitTime","datetime");
	$cur=addColumn($conn,"empAttendance","entry1","varchar(30)");
	$cur=addColumn($conn,"empAttendance","exit1","varchar(30)");
	$cur=addColumn($conn,"empAttendance","ent1","datetime");
	$cur=addColumn($conn,"empAttendance","ext1","datetime");
	$cur=addColumn($conn,"empAttendance","remarks","varchar(50)");
	$cur=addColumn($conn,"empAttendance","symbol","varchar(10)");
*/
	
	//alter table zkteco.dbo.checkinout add machineid int
	$cur= odbc_exec( $conn, "update zkteco.dbo.checkinout set machineid=(select CAST(BADGENUMBER AS int) from zkteco.dbo.userinfo where zkteco.dbo.userinfo.userID=zkteco.dbo.checkinout.userID) where machineid is null ");  
	
	//echo "delete from empAttendance where (date_='$from') ";
	$cur= odbc_exec( $conn, "delete from empAttendance where (date_='$from') ");  
	
	$query="insert into empAttendance (machineid,date_,symbol)  ";
	$query=$query."select distinct machineid,'$from','P' from zkteco.dbo.checkinout ";
	$query=$query." where day(CHECKTIME)='$day_' and month(CHECKTIME)='$month_' and year(CHECKTIME)='$year_'  ";
	$query=$query." and userid not in(select machineid from empAttendance where day(date_)='$day_' and month(date_)='$month_' and year(date_)='$year_') ";
	
	//echo "<br>".$query;
	$cur= odbc_exec( $conn, $query);  

	//Student set Absent All remains Code=1
    $query="insert into empAttendance (machineid,date_,symbol)  ";
	$query.="select machineid,'$from','A' from student ";
	$query=$query."where machineid>0 and  Status=0 and machineid not in (select machineid from empAttendance where date_='$from') ";
	//echo $query;
	$cur= odbc_exec( $conn, $query);  

	//Employee : set Absent All remains Code=1
    $query="insert into empAttendance (machineid,date_,symbol)  ";
	$query.="select machineid,'$from','A' from Employee ";
	$query=$query."where  machineid>0 and  (Status=1 or Status=4) and machineid not in (select machineid from empAttendance where date_='$from') ";
	//echo $query;
	$cur= odbc_exec( $conn, $query);  
	
	//$query="update empAttendance set ent1=(select '$from'+cast(entry1 as datetime) from empTimings where empTimings.machineid=empAttendance.machineid)  ";
	$query="update empAttendance set ent1=(select '$from'+cast(entryTime as datetime) from employeeShiftsView where employeeShiftsView.dayID=DATEPART(WEEKDAY,'$from') and  employeeShiftsView.machineid=empAttendance.machineid)  ";
	$query.=" where date_='$from' ";
	//echo $query;
	
	$cur= odbc_exec( $conn, $query);  

	//$query="update empAttendance set ext1=(select '$from'+cast(exitTime as datetime) from employeeShiftsView where employeeShiftsView.machineid=empAttendance.machineid )  ";
	$query="update empAttendance set ext1=(select '$from'+cast(exitTime as datetime) from employeeShiftsView where employeeShiftsView.dayID=DATEPART(WEEKDAY,'$from') and  employeeShiftsView.machineid=empAttendance.machineid)  ";
	$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 where date_='$from'";
	odbc_exec( $conn, $query );  
	//echo "<br>".$query;

	$query="update empAttendance set entryTime=(select min(checktime) from zkteco.dbo.checkinout where empAttendance.machineid=zkteco.dbo.checkinout.machineid and (checktime between DATEADD(MINUTE, -300, ent1) and ext1) )";
	$query=$query." where date_='$from' ";
	odbc_exec( $conn, $query );  

	$query="update empAttendance set exitTime=(select max(checktime) from zkteco.dbo.checkinout where empAttendance.machineid=zkteco.dbo.checkinout.machineid and checktime between DATEADD(MINUTE, +10, entryTime) and DATEADD(MINUTE, +300, ext1) )";
	$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");
	
	//Late  Code=2 
	//$query="update empAttendance set symbol='t' where  (symbol is null)  and entryTime>DATEADD(MINUTE, 60, ent1) and (date_='$from') ";
	$query=" select headDescription from accountHeads where headType='Leaves' and headDescription not in('P')";

	//$query=" select Description from FeeHeads where headType='Leaves' and Description not in('P')";
	//$query="update empAttendance set symbol='t' where  symbol not in(".$query.")  and entryTime>DATEADD(MINUTE, $lateMints, ent1) and (date_='$from') ";

	//late symbol
	$lateMints="select lateIn from employeeShiftsView where employeeShiftsView.machineid=empAttendance.machineid and employeeShiftsView.dayID=DATEPART(WEEKDAY,'$from')";
	$query="update empAttendance set symbol='p' where  symbol not in(".$query.")  and entryTime>DATEADD(MINUTE,($lateMints), ent1) and (date_='$from') ";
	$cur= odbc_exec( $conn, $query );  

	$cur= odbc_exec( $conn, "update empAttendance set symbol='A' where (date_='$from') AND (entryTime IS NOT NULL) and (symbol is null) ");  

	//$query="update empAttendance set symbol='1' 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 );  
	
	//Leaves/Holidays Calculation 
	//$query="update empAttendance set symbol=(select symbol from LeavesView2 where LeavesView2.machineid=empAttendance.machineid and date_='$from') where  date_='$from' and machineid in(select machineid from Leaves where date_='$from') ";
	$query="update empAttendance set symbol=(select symbol from empLeaveView where empLeaveView.machineid=empAttendance.machineid and date_='$from') where date_='$from' and machineid in(select machineid from Leaves where date_='$from') ";
	$cur= odbc_exec( $conn, $query );  
	
	//staffAttendance
	//$query="update staffAttendance set Status=(select symbol from empLeaveView where empLeaveView.machineid=empAttendance.machineid and date_='$from') where date_='$from' and machineid in(select machineid from Leaves where date_='$from') ";
	//$cur= odbc_exec( $conn, $query );  

	//Student Leave 
	$query="update empAttendance set symbol=(select symbol from stdLeaveView where stdLeaveView.machineid=empAttendance.machineid and date_='$from') where  date_='$from' and machineid in(select machineid from Leaves where date_='$from') and machineid not in(select machineid from employee where status=0) ";
	//$cur= odbc_exec( $conn, $query );  

	// for Sunday
	//if(date('D',strtotime($from))=='Sun'){ 
	//	$cur= odbc_exec( $conn, "update empAttendance set symbol='Su' where symbol='A' and date_='$from' " );  
	//}
	$cur= odbc_exec( $conn, "update empAttendance set symbol='OF' where symbol='A' and date_='$from' and ent1=ext1 " );  
	
	
	return 0;
}


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);
}

/*
delete from student where ID>1
update student set email='m@',password='m@' where empid=1

delete from student where stdid>1
delete from userRights where empid>1

delete from patientTab
delete from patientDrugs
delete from patientTests
delete from patientVisits

delete from ledger
delete from investigation

delete from itemTable 
delete from itemInOut
delete from itemInOutSummary

delete from expenses
delete from services
delete from AccountHeads

*/
?>