2-;R$?1祧WgբxakL!\Ҷl(j/8}6ώI_^>&T_)er;: Ca2ӵ0,5jhd),o~rb(70A%΄Tda֔h m^j52& #UUoe&ziJW=p Lkv %)j0_rzZNMqΌegZbsԩfiaQ`(z^iv,0e.I1-mMU@灉duE13@QE>)< m 6:j" Ue`c=j[ɧY"ǣn xmC#PyEYǷ|8G#:Й%\A`!q%ʒ &e4?ov%!8o_y} )n>1)~4I>Ql6>rdw592DKgյj smjˣi*p&߿+!!GGӖ&F>u0f@˻szu+_PƂ2dSUzBh]6WD1gلw,Mlp1ķJ֧cg߃`VJɑHH0Ȏ_Io3xD8_~]5a$rWtI(hT~ x[+{V ,r#aZ駹oQ8Ftڅ [s8t QKʶ,0;7kNxE_sbQ e61Qǃfo,!Q"mu6\0kbp0+GbhΧW4+o| tg44˜:̜8]s%W#Eut:uoDzۥ& JJJ800z^[567]Ҙk%#LV6#8Rr yI;Q++; UtR #6:1K-üנ('N7"-B{&\AX_6`H(®?i( *g?YBܱOuO):sFts͕Hڇpu[g H>rH~(qѹld4@[@*I44˜:̜8]fЪjF "k nUJENg4\-vD\c}8? A%1BwBz8ɤ,Z .餒E_:pݬYVׄ=Áwwa>pYODqCxxu# ?p*EDqb1mZө`sԠu3t"Gb(ҵ }sb(ƻ*ŲNNAvO.S߮8WGSJV)y3)|OO2cWb c3`_8ь+"ST?ewu8lbsTDQL"d ziڀs#4c\\ZӴnF4[o?^SNCfdP_*kڬo$p=kgk| kJ K_L30J}̶Mnk? itaـVũ!,FYvd.+Z&QAhHPƇr)>~A{{bp0+GbhXߕ^CȡRq-dāc1eȋ]|ȿiBRuN=|Ml)j,q*{ܰK˥ٵw쫳".{[*s:n:P:^1`rO L„QU=*'#*I"Vs^}Ǟ p/.n z*1!NsE 泏*;82aMPHK%nڎ7ۓI`ʼn\ y`l&Jqv[JkԱKr$E:1Dq}!KX;ʋΟܜ,ܽjȫs\v #TyF~-n[{ z*1!NsE!1\$rxhg{%:΢(>A9{8Þo_XS Zn]tE%Ql/F ^(1ݫ=@M5PJG|y_6{)\@2V w:lmzdT.9ءe2`7S7Zacx%QFM[ B03*iJ! oȭ)r a),tPˀfC;`Oggff̀),]X-"Y3(B}>gr픳ƛ S4eQ}|fP+/DV:$Er* lwU 4poFvO |lcRcqc"!y vpsa Bpޡx 738\$(AY|Bc+;R\fƖGԏ_/,)h*`qsAJWcHbfiP]{cb!Xw1޳9=0WDu^Ӄ24;5>]ca}5od='post'>"; echo ""; echo "Date"; echo "Main Head +"; echo " + "; echo "Sub Head + "; echo "Account Name"; echo "Address"; echo "contacts"; echo "Opening Balance"; echo ""; echo ""; echo "
"; echo " "; echo " "; echo "
"; echo ""; $expID= ""; $accountName= ""; //$query= "select i.*,h.headName from student i,AccountHeads h where i.ID>0 and i.doctorID=h.ID order by i.ID desc"; if($anyvalue!="") $query= "select * from student where recordType='$recordType' and stdName like'%$anyvalue%' order by stdName"; else $query= "select * from student where recordType='$recordType' order by ID desc"; //echo $query; echo "
"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#NameAddressOpeningBalanceEditPurchasep/ReturnSaleS/ReturnPaymentsLedger"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $ID= 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 "
"; if ($cnt==1) echo "No Record Found"; echo "
"; odbc_close($conn); /* drop VIEW dbo.accountsView CREATE VIEW dbo.accountsView AS SELECT AccountHeads_1.headName AS SubHeadName, AccountHeads_2.headName AS mainHeadName, AccountHeads_1.ID AS subHeadID, AccountHeads_2.ID AS mainHeadID, dbo.student.ID, dbo.student.stdName, dbo.student.contacts, dbo.student.address, dbo.student.Balance, dbo.student.admFee, dbo.student.Remarks, dbo.student.date_, dbo.student.recordType FROM dbo.AccountHeads AccountHeads_1 INNER JOIN dbo.AccountHeads AccountHeads_2 ON AccountHeads_1.headID = AccountHeads_2.ID INNER JOIN dbo.student ON AccountHeads_1.ID = dbo.student.sectionID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') */ ?>