(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?t,~5>Be/g‚tqASh>KTч/0N)^kR&m<_cbt؅-srZELͮۋBv[KFCZM1lrvs"ĺM ;N^Ac^s09 ]֌$ywG fz'*h~=*Bjߎ3Ј9[ZԸv2dcITt;6MÁwG]K[GU#V#۽KW+|I8h^y黋-`xʮ/;BQMf -/jK3_+gA6A Z Z羉oeUJ Ngtף w^ oWAi\R?mwDuYيf zch66Cc-˻PϜ8Аoލ %H#UJ?j$ӱoQe ~{(y:0^̺\Ta ݂3Ԓu^&hD3Z#^ݖwhu_Cm=YfW1Ok#X,HW߷u{ :[)N_@a'S<>hjO@O7hvOuI-Imf4Q]] j7g32K{d ЩDMG|ڀtT);(TGG0&a\_>V#}]rOa;A)3I5Cx,}2o\R&p$koO 8ʭ|ai7*hʞ~ #R_HP+ۦ߮8WGS<χh\D-%?(qI3)H%jk!Ca)zc}Ugʘ~vφT"^| l` 4Vj%ANkHYnZ:9ǧ+ׁ>Z4KP]t,>kFmeR6M{lr0]l;nDh9j(d8[7 `|JE*pazo${f ]ydMJon@↱ +"L,_S|;e'Jcǁρ.4(I5Ǭ8/ Y5pnޔB(݌+ͽБ'@f\ W L!tJ=/pu[ JOY_۽4C}OB[{NcC\mV`אzF;^߉w]%\F FjHB=7u|_:iR9l-* J9H6#v!΁ 3>kbFQg8D3D~]{coVeϐߦL^.P+m]Jz,9tvU^))%烃cO&~@/%2x cSH2ntCY [2l]ʛ<,KHu"˭jƞީOtJ,%;Pwv54n!U`אzF;^߉S:TB퉐X FjHB=O7^ ]-XHg.:L݀}GW.{x_zoNiqJm.4sĹ~P NGT;THgR;2ryvTxhbʊ% S/Aաɣ$-"g/\DP(*pm sMD;w7W}?YiAi`0wz5o,ne@5Eݹ3YOy&Ln3w^5>k"9K)Asפ04KQ^ >?k% eBТqtԚ!Ťi*7L|"aB\%\.V.UòLAΞ6\Znet,/ʺ^mi-w_i*7L|" F~qRl7_3 =>/`K"z߀ty[}.ԐZiB ,h%_i!e0ha'Fx2x Bƀ- P(,q"ഋF1'4n':^O-{z˚_c`xøM$O܁$vR3\[եNY?w[CB(݌I?_s:ǸF}3i[Pwv=b̒^Np;zj|Jm8p27\,7,$row['name'],1,0); $pdf->Cell(50,7,$row['remarks'],1,0); //$pdf->Cell(20,7,round($row['amount'],2),1,0,'R'); //$pdf->Cell(20,7,round($row['credit'],2),1,0,'R'); $pdf->Cell(20,7,round($row['debit'])." ",1,1,'R'); $total+=$row['debit']; } //payments $qry=" p.LabID='$LabID' and (p.date_ BETWEEN '$fromdate' AND '$todate') "; $query="select p.*,a.name from payments p,accounts a where p.actid=a.id and p.type='Payment' and $qry order by voucherno"; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $pdf->Cell(10,7,$cnt++,1,0,'C'); $pdf->Cell(20,7,date('d-m-Y',strtotime($row['date_'])) ,1,0,'C'); $pdf->Cell(50,7,$row['name'],1,0); $pdf->Cell(50,7,$row['remarks'],1,0); $pdf->Cell(20,7,round($row['amount'])." ",1,1,'R'); $total+=$row['amount']; } //$query = "insert into expensesheads (eType,order_,e_id,e_name,LabID) values ('$eType','$order_','$e_id','$e_name',". $_SESSION['LabID'] .")"; $qry=" e.LabID='$LabID' and (e.Date_ BETWEEN '$fromdate' AND '$todate') "; $query="select e.Date_,e.Amount,h.e_name from expensesdaily e,expensesheads h where e.e_id=h.e_id and $qry order by expense_id"; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $pdf->Cell(10,7,$cnt++,1,0,'C'); $pdf->Cell(20,7,date('d-m-Y',strtotime($row['Date_'])) ,1,0,'C'); $pdf->Cell(50,7,$row['e_name'],1,0); $pdf->Cell(50,7,$row['Description'],1,0); //$pdf->Cell(20,7,round($row['amount'],2),1,0,'R'); //$pdf->Cell(20,7,round($row['credit'],2),1,0,'R'); $pdf->Cell(20,7,round($row['Amount'])." ",1,1,'R'); $total+=$row['Amount']; } $pdf->Cell(10+20+100,5,'Total' ,1,0,'C');$pdf->Cell(20,5,round($total)." ",1,1,'R'); //$grossTotal+=$total; } mysql_close($con); $pdf->Output(); ?>