(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݿbZI>ub}r]oP0̰Mc{8:1:a%G>Tצ{2q&p] Z4 g +|b'հbR%h.eڔLfe#<$Ϲ4M;an ةMo#y!W7&߿+!!GGi[A0O4k3.1@_XG28"~ r~QGi]t`pSmkj| 9H E]>_4.~lTl1r+ q:ZSP߮:D$w|ѹb:HI(fsٕnI})ejXڟX k5[ȗAXzI|r.gtͺܪ„\(ކP82Iz&/g~:)W VvvAk0mTm0[i|/Nk[S|[~ׂk fUlSn(dJ}tyEX>lHOI✐T`cFf+sþ#$3E;ws^}Yng؋x r⺼UåbkRNF u.hMG @'Y 9XG$<<)2r~ q[WY\&,R~+U`V=-k:z;,zp?3F$4Y:Y\&,R~0^N8k[N280^B+*XJ1]Ou>?n9|нb$09V*,yBR{*>eĔy*g: 8ĵaCO3hsz/BH,9ԙlzƗJeܻ/ 24 ,(5kpG?F5PN.5Na a43lmMvONQ@FKTݦewGT*i4F * $N[DL{v"s 3GB̥a""'̦6[-l9 h ΡU/sv7+ɳtC0!.g˽K^)%Jj\+d#쨟(v@C'̢= 䑒<=5Yʯ*Q|9(d8^1Vm6n,N{jp?mC[&Jk:hIs9znڝ}kUƑxh)-oOK1jN-NaRQF9)va8W()/f%q4s}%nCOiwWWk4V}o}tPS M Ar|gub }J~c 0&,h+(N?Y(~6t6($|HUA꠯eU8t_)pVuWz=,t^.|nd+ r 3[BoLC2ǖ|W-zg.vH'FhO3ZA3QSk׷V|N`86Yh Gve@W!BAAa Vlud̚]ɐg4KEYɖgnZtƊomySa~ ]1f1!^IK渌0I/GSQ߬U(Sk!g`{|o!Leϙx V ,VY4f ܖ>58)|Lf)̯Q4K1iBӂBǴӺއ`l QqrTJe ۷BMч:q|KlC-g+d]M*;_&ٲfJ:Wt2bo O>a"cYi;vke<]"a6J3T(K\WO">?bZȘT28dpZV{Io !ɬr#Lc?<1]G>p.aP+ uZ=jriWG]6F_TsL2&ky孙ز.?V`niSfqu`0 g.5%MʉObPHT$6 Q4{AI+[Km21D_NeU|8!Z%)X 9jPJw`i|,#W/i<&eɖYUI=S,Sw|A"xb(l/ն݅ymb?B$kM6Z8 SdFhSAly C1`.fX=w/FG0\lU|{I1k@;@g vc\A,ܙ28kd-?*`WϺ3JgJxRV]S~?rl:փ%):#/QlL$cnt$date_$invno$actname$name$qty".$row['qty']*$row['uprice']."".$row['qty']*$row['pprice']."$profit$unit"; //$cnt+=1; } if($cnt>0) echo "Summary$saleAmt$purchaseAmt$profitAll"; //echo "SerialDateHeadDescriptionAmountEdit";//Delete"; $query = "SELECT e.*,h.e_name from expensesdaily e,expensesheads h where h.e_id=e.e_id and (h.e_name like '%$anyvalue%' or e.Description like '%$anyvalue%') and e.Date_ BETWEEN '$from' AND '$to' and e.LabID='$LabID' order by e.Date_"; $total=getName("SELECT sum(e.Amount) from expensesdaily e,expensesheads h where h.e_id=e.e_id and (h.e_name like '%$anyvalue%' or e.Description like '%$anyvalue%') and e.Date_ BETWEEN '$from' AND '$to' and e.LabID='$LabID' order by e.Date_"); if (isset($_GET['e_head'])){ $query = "SELECT e.*,h.e_name from expensesdaily e,expensesheads h where h.e_id=e.e_id and (h.e_id='".$_GET['e_head']."') and e.Date_ BETWEEN '$from' AND '$to' and e.LabID='$LabID' order by e.Date_"; $total=getName("SELECT sum(e.Amount) from expensesdaily e,expensesheads h where h.e_id=e.e_id and (h.e_id='".$_GET['e_head']."') and e.Date_ BETWEEN '$from' AND '$to' and e.LabID='$LabID' order by e.Date_"); } $cnt=0; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ if($cnt++==0) echo "SerialDateHeadDescriptionAmountEdit"; $expense_id = $row['expense_id']; $e_id = $row['e_id']; $date_ = date('Y-m-d',strtotime($row['Date_'])); $expenseName =getName("select e_name from expensesheads where e_id='$e_id'"); echo "" . $cnt++ ."" . $row['Date_'] . "$expenseName" . $row['Description'] . "" . $row['Amount'] ."Edit"; } if($cnt>0) echo "Total$total"; $cnt=0; $run = mysql_query("select * from ledger where LabID=". $_SESSION['LabID'] ." and (date_ BETWEEN '$from' AND '$to') "); while ($row=mysql_fetch_array($run)){ if($cnt++==0) echo "SerialDateHeadDescriptionAmountEdit"; $expense_id = $row['expense_id']; $e_id = $row['e_id']; $date_ = date('Y-m-d',strtotime($row['Date_'])); $expenseName =getName("select e_name from expensesheads where e_id='$e_id'"); echo "" . $cnt++ ."" . $row['Date_'] . "$expenseName" . $row['Description'] . "" . $row['Amount'] ."Edit"; } if($cnt>0) echo "Total$total"; ?>