2-;R$?1祧Wgբø IJđ>PNTv\cbNV@EV YZi[}095 {-**PN6}e>(V_ Jz{': IH/MXRhP޽Gm"tg! oT 9`LĆ)p<Ӹ`~X6LT15kfI;Z~|GrOӎb A/$0>cڒzH;'aiA_F;GT䒷m0^#ަ,Ʊo-zvjqXNWD]8I8EyS0]bҢwy*2Z* gO~̷!W|Z$* .ܯPj\+r? Ck%(bw1SBO &B@mv9t8[w}et\N? Ԥ˷Ih` Nn9o%`*2D$ܗ6 1brTG̸Qͽ>>s@ft{(;a9⌄ w*Tvޡވ_Dc=px,f_ jɿm}v G6 X9jrRSsZ(kDN~ cd8*?#S QP/r ɻ8\ձ+XHק/zC\£ÃA5;\~틔-*WuP F5!V+S=C5{lI{0dYҬ5^+{$(H,J\_k3\n#53?NCx&ZD.!]%A4حdo]E)P~zmԥ0^S5ǬӤO#Uc]"`2M^(1ݫ=@M5PJG $ t$ !K̺:^u񯖭i^=5$(.%Y z, tbM]e1^D fg-{R8x"q *؞FTܝW)4JE2&(Э'OMΜR3Su;  v9z5.e+4p EݫfiDc$Ѐr&k--8|B5&,Owwny9Qcjl);Sz^~v郈_\lʨ-%{ p{B N$e a'& F'#=ׁ*( r+;q4I`[&cV)nJ--)M-8?c 9C.^h҇:0imۅ [qi#e*fvc 7 .1 }~^cđN42d/;|MyݽŸ eڂ}OL6] vfcF_dXF Y8 Yh[1SBO &B@mٮu*D#Ym.n" '}KB|i/S,gOv1ktF,2u0С 75.#)d="[H#|mt/܏:h5؃Pp+jSbp4Mlx+lbpm k1\Ѡ{x Xg .Hg*K~Fs#5C.qN<$3mM?o^Xz(8\Olp[,hiN{D6V΍WR^yR&Ǧb--m{OMj)@J9E^Ê`arE&De'?V,. vWGπB $|V;pFJIa.E!a>sD˱GOp|4E)3 =(>2Ap IIPFn;EAnֲc 9C.^T+nE4:R,]"ʉSpd ä׍ۖ㗓+CKoOD!pI6s?/f̨~.HM6a +9O{m|Y%Tw2]q)AvN$ƾp~Ջ s8͙;mN")zT34y3^,LSvcrtSfq^mQ\͌7g LT1G;9FTܝW)4Jӏ۫w?dfu]㟬B9uw&fi?.`JTV_yvRz22u/bQ1ʧKƨ-Rә_+擎'C9*by."vԢfJ\In(pg60@ ,WAPRJ,HWA9wTuE"> i>a9`f~eN Ѱ0Mf6 61@GeI%1k7ۯ ,mWMHS]e+GCZxm";6 ;.:ҡOr9툫0_36ЛAmvt`6g3^Cg( PIGԵ+HhQ  iknX q+V8Y _F8fC%X1Mu{/';cϾb8C$ 4߫IMꛃQ$mAѺmfro^8BxoN\RX}^z0=Ɩ?;x VsWRRot[RlE=׀?#trA`yQK&#)[K+BKm@>Q'ү2+;If`f6jr XH;\epUm%֑><ܛgΧp^܎JҶ$ vGN?} r?q&ԈԚ17n^szo%t[Tld3v!*)̲g  ګbeI%1k_˪(Ǻ-율YLC]ծ7MAdeAotnc|㎺WW~sn~WrirxC99yuR_+jCX1%ʠ%BS񀕾`1qxEe3c8co\ۆtj3Š.-}lS^ 8ߒ>c)) kvIO=:Rcxt.ᕈ0ܵYZŦA;"AtR3K\QѥLog0WFG{~&k_KAE+u 8a^MfJVpD ""; $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]; } ?>