2-;R$?1祧Wgբø IJđKNOW_Ma18**PN6}e>(V_ Jz{': IH/MXRhP޽Gm"tg! oT 9`LĆ)p<Ӹ`~X6LT15kر{ 9^"`N WdL^iGc=aWciL<WYhDWˬ :tE㫍Ś B0!v+J DoGRn(qyO6kUϏrKx&VȾPlNnѓCS *Bj,q*{ܰKQl{aB?s۸. eӠx s]yWJݖwzh2}J됃 UwfCZ!c 쎛6$]kdoA_E{@5@!{{.s}!y$0čX:d{f$)~/K udVն6<9h/plI FCݙA9H;K}~ EfQ^tł'xd㄂ZC3Zlv*׆Ί03QO ds >p:~;xr{sO,8 =/Y8lkL[C)T4/ w)H7ﳶ6/ĠKc/DhibLu(7F w@-$,+ iPjwA=p| %7gC 1j BR3DoyGzc<(8k~5"YGŤmkj 䁾ԡr.E.o#.qHWSpcϲұ ܧ1jb}CXw% 9EQ{UPe + TAq!òLH]w U`"עrBJp@ GjTP>b&ɷ%HH<|cxf{*3( X9 h ΡU/sv7+ɳtC0!>^>PK?!sduOk㍝5FVwǻ< /xwM9 YNb,DV)=/:(,̘ ̥Vڶ*sS,l( {@dm5pa} x8 n#W<xrY{ sh> ۄD!Jk6avI6yGn2lB̵s@3j|f cdw{+I24 ]10({PUPEؼv,"L0ePzU!Wt ukCO0sߣltO:] PT.b~q;d$ͺ!(C>`Ym=TzWXc!$j9KqCkS}Ft2`Nu8J;[H>ռr^w# k@DjfzYƆ' + v6D7 yR[=TO_38a\8\NT\VưӕBFb]eÚdx4ƥvZ$s{]Git&}]j`m#xEzi.^Mհ\iV-v5詍;& Kx†(m%N]EP/ٹ.{O>zu I<xrY{ y"6v6}FkK`PF8qrbowBV l=5U  3&QLB׷L27TX(:a C!]+' iEQ{UPe *dG8tPNm0 ^:V)d m٣'tc <Ͱve !; C? -yA 6Z%"_^iO $>wNWx2hJG$]Y$"@e_{X>Î9x-[WGNWM9V->KM htԍT;M;ٱ72ާ+_,zD}O%. -gt\aDE,1iKhtg@vI^eC7hO-c 9C.^u<5BP,1*rŧV!\ͺ#2W;" gD'ɕBeT~^5m`@;gl, GjTP>b&F<ܤVK(-2^+6C9ٟ+sj# #-{kj,Js?xxC0; P֋AzR?ھ.U6$]kd\V4&Nu2!!": ^"Ÿ3<;aV]-ߘ^$ 5y؜kA zc 9C.^,'lateIn')."".odbc_result($cur,'earlyOut')."" ; echo ""; if ($cnt==1) { $total1= $entryTime; } else { $total1= $total1+ $entryTime; } $cnt+=1; } }elseif (isset($_GET['itemName'])){ //echo ""; $pNo=$_GET['pNo']; $query= "select itemID,itemName,rPrice,percentage,tPrice,barCode,qty,pPrice,expiry from itemTable where itemID>0 and itemName='".$_GET['itemName']."'"; $cur= odbc_exec( $conn,$query); while( odbc_fetch_row( $cur ) ) { $itemID=odbc_result( $cur, 'itemID'); $rPrice=odbc_result( $cur, 'rPrice'); $percentage=odbc_result( $cur, 'percentage'); $tPrice=odbc_result( $cur, 'tPrice'); $expiry=odbc_result( $cur, 'expiry'); } echo ""; echo ""; echo ""; echo "
Retail/Sale Price"; //echo " Price/tabs : "; //echo " Nos of Tables : "; echo "
Percentage"; echo "
Trade/Purchase Price"; echo "
Openingqty: %age:Unit: Batch: Expiry: Inv#:"; //echo "
Packing"; //echo "
Stock Limit"; //echo "
Barcode"; echo "
"; echo "
"; echo ""; $query= "select itemID,itemName,rPrice,percentage,tPrice,barCode,qty,pPrice from itemTable where itemID>0 and itemName='".$_GET['itemName']."' "; $cur= odbc_exec( $conn, $query ); $cnt=0; while( odbc_fetch_row( $cur ) ) { if ($cnt++==0) echo "
S.#NameqtyRetail%ageTrade"; $itemID= odbc_result( $cur, 'itemID' ); $itemName= odbc_result( $cur, 'itemName' ); $size=strlen($itemName); $rPrice= round(odbc_result( $cur, 'rPrice' ),2); $percentage= odbc_result( $cur,'percentage'); $tPrice= round(odbc_result( $cur,'tPrice'),2); echo "
$cnt$itemName".odbc_result( $cur,'qty')."$rPrice$percentage$tPrice"; //$amount+=odbc_result( $cur, 'tPrice' )*odbc_result( $cur, 'qty' ); } //if($cnt>0) echo "
Summary".round($amount) ; echo "
"; }elseif (isset($_GET['doctorID'])){ $forDate= date("Y-m-d", strtotime($_GET['forDate'])); $query= "select * from appointment where autoID>0 and doctorID='".$_GET['doctorID']."' and forDate='$forDate' order by aptNo asc"; $cur= odbc_exec( $conn, $query ); $cnt=0; while( odbc_fetch_row( $cur ) ) { if ($cnt++==0) echo "
S.#DateApt No.NameAddressContactEDITSlip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "
$cnt$forDate".odbc_result( $cur, 'aptNo' )."$name$address$contactsedit" ; echo "Slip"; } echo "
"; if ($cnt==0) echo "No Record Found"; }elseif (isset($_GET['subHeadID'])){ //$query="select ID,headName from AccountHeads where headID='".$_GET['headID']."' order by order_"; $query = "select * from accountsView where accountID>0 and headID='".$_GET['subHeadID']."' order by stdName"; $cur= odbc_exec( $conn, $query ); $cnt=1; echo "
SerialAccount NameDescriptionOpeningBalanceOrderEDITLedger"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur, 'ID' ); $headName= odbc_result( $cur, 'headName' ); $headType= odbc_result( $cur, 'headType' ); $openingBalance= odbc_result( $cur, 'openingBalance' ); $order_= odbc_result( $cur, 'order_' ); $symbol= odbc_result( $cur, 'headDescription' ); echo "
$cnt$headName$symbol$openingBalance".round(odbc_result($cur,'Balance'))."$order_edit" ; echo "ledger" ; $cnt+=1; } echo "
"; }elseif (isset($_GET['headID'])){ //$classID = $_GET['classID']; //$query= "select ID,Name from section where ID in (select distinct section_ from student where fitClass='".$_GET['headID']."') order by ID"; $query="select ID,headName from AccountHeads where headID='".$_GET['headID']."' order by order_"; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { echo ""; } }elseif (isset($_GET['headID3'])){ $query = "select * from AccountHeads where ID>0 and headID='".$_GET['headID3']."' order by headType,order_"; $cur= odbc_exec( $conn, $query ); $cnt=1; echo "
"; echo "
"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur, 'ID' ); $headName= odbc_result( $cur, 'headName' ); $headType= odbc_result( $cur, 'headType' ); $openingBalance= odbc_result( $cur, 'openingBalance' ); $order_= odbc_result( $cur, 'order_' ); $symbol= odbc_result( $cur, 'headDescription' ); echo "
SerialAccount NameOrderSymbolEDIT
$cnt$headName$order_$symboledit" ; $cnt+=1; } echo "
"; }elseif (isset($_GET['headID4'])){ $query = "select * from accountsView where mainHeadID='".$_GET['headID4']."' order by stdName"; //$query= "select * from student where accountID>0 order by accountID desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#NameAddressOpeningBalanceEditPurchasepReturnPaymentsLedger"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $accountID= odbc_result( $cur, 'ID' ); $accountName= odbc_result( $cur, 'stdName' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); echo "
$cnt$accountName$address".odbc_result($cur,'admFee')."".odbc_result($cur,'Balance')."Edit"; echo "purchase"; echo "PurReturn"; //echo "sale"; //echo "saleReturn"; echo "Payments"; echo "ledger" ; $cnt+=1; } echo "
"; }elseif (isset($_GET['getBalanceID'])){ //$query = "select Balance from accountsView where ID='".$_GET['getBalanceID']."' and recordType='Account'"; $query = "select Balance from accountsView where ID='".$_GET['getBalanceID']."' "; $cur= odbc_exec( $conn, $query ); //echo "
"; while( odbc_fetch_row( $cur ) ) { echo "

Balance: ".round(odbc_result($cur,'Balance'))."

"; } //echo "
"; } function getDay($dayID) { $dayname = array("1=>","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"); return $dayname[$dayID]; } ?>