d&lIZB,e>aπe`ׂkA({MSn9C¿>%8z0tt.R (1ܯ ^%HLqR7*VéYqnƷ[>j5\9Ӕa#NkU(= 1ח3 #%>dzQ"RE l7KDد=̷֜2|㩓v*G `6uZٷ t |b?uzjdD 5:[~Njnís0R7Ku>b1CO}+z:''>\*1 MiKK@+ "Hq?v?(EUjY*x=qgэev\TcqlsSʮ0eDngϐO JYm7 4dE-ylJ޼5urȁטƇ.+3;!t"05T۫XZxMj':lgV$073y{q\d/Q,}rULϤZ'LxHpng@6~tύg{땰Xb Au^2)Gak&V747!]`X^E܍S@ +Bu ɼ8"K#0@Ⱅ&*b}8%ޮ>p\g-1Oev$eǞ?;'RPMЋ(Qo;V똥vz "zif.J@U?,꬜Γ&>9NjPx=rT-\UA6;/%$aboC:DKwxҪp鴲&?~ޱX.~F=ѡX9_AU.9Cmgb/1KIcwS*j4#&7ճmS#kɬ#g^UW39 'ZR Rdo^th+ JױUUy=X(]tބ2%]K;PyhcL?j ̘V \8#n6^{TQ*Tg #q${j%H=5%b/j"Or#|xueͧsA5Wwo^e, 3d8 j`tH%t̵_QF:&.]JYVȅfB̽2B愶%EY&ࣶ'Vh[1",<[;J3$oC_%׭דRec@J&YH_-JOы L%!}y-wIJe01ov & JJJx„IvQy1`Pn!k^?ʅWP'ZfJYPjB4j+rq"Y)`{6jVDk[pszLNu^-۠" f%gn&ܠҪӓG@ՆydA\-vD\o+f |庽t}܂PWI5Ҧ߮8WGSe~:nװ65S9"-P g3!AplP?4E߄j4JV:&Fa=o&(^ !sWllxM{,9gSE!3C2'Ķy=r[r~)u.2ڦz}j7_YV$+{>PvĆ v+nF/dAhO[;z  MC(t.*ȼoxL |B?:$=Q&d_l.Ov o5}s~C]&m~Qh_I$ҏSʻ؅U9 elb`3CBI{_/+?4E߄j4JV:3;z|?GdEԾI$ F. |yKuƪeM㼱 2z|EѯߢvCJ2Q7lfnx A}Z?xp늂?{U<+n#POr9p>iA NA"=XcP!iď?億(XE4zEN"u9Ό "ݣ ~$w@`^0IT.Jn#Yw*R38G~RÿhjC!F\QQY6j\[#0mҌ9{g\q2VN\D;r_L&lCvЮ;zWу&بՠGnHLUVcIc+wMg~Y3^gW;X›݇[%{3TzRZ1=8f^=8?;zsWG DL{v"s Bn: 1>]!`DrfT6'ݓJT9$^ER*\*J#| 䋤5ijwIP,#$z%^!IQk1k ^$_2dQ,@zH!]5ꝓ1^\3ij#3 CR${C8{LlI]/ ?g^%(!OVzd׆Oò8F1Qhow'])){ $from = $_POST['from']; $to = $_POST['to']; $from = date('Y-m-d',strtotime($from)); $to = date('Y-m-d',strtotime($to)); $anyvalue=$_POST['anyvalue']; $eType=$_POST['eType']; } if(isset($_POST['btnPrint'])){ $from = $_POST['from']; $to = $_POST['to']; $from = date('Y-m-d',strtotime($from)); $to = date('Y-m-d',strtotime($to)); $anyvalue=$_POST['anyvalue']; $eType=$_POST['eType']; echo ""; } if (isset($_GET['date_show'])){ $from = date('Y-m-d',strtotime($_GET['date_show'])); $to = date('Y-m-d',strtotime($_GET['date_show'])); $Date_ = date('Y-m-d',strtotime($_GET['date_show'])); } if (isset($_GET['e_head'])){ $e_head = $_GET['e_head']; $from = date('Y-m-d',strtotime($_GET['from'])); $to = date('Y-m-d',strtotime($_GET['to'])); $Date_ = date('Y-m-d',strtotime($_GET['from'])); } //echo "
"; //echo "
From: TO : "; //echo "
"; ?>
EXPENSES"; echo ""; echo "
Date"; echo "
Expense Type"; echo " +"; echo "
Description"; echo "
Amount"; echo "
from Account"; echo "
"; //echo "
"; ?>
Search Expense Expense Type"; ?>
Keyword
From
TO
window.open('admin_panel.php?deleted=A menu has been deleted...!','_self')"; } } $query ="SELECT 1 from expensesdaily where LabID='$LabID' and Date_ BETWEEN '$from' AND '$to' limit 1"; $query =getName($con,$query); if($query==1){ $UserID = $_SESSION['UserID']; echo "
SerialDateHeadDescriptionAmountEditDelete"; $query="SELECT e.*,h.e_name from expensesdaily e,expensesheads h where h.e_id=e.e_id and e.Date_ BETWEEN '$from' AND '$to' and e.LabID='$LabID' "; if ($eType!="") $query.=" and e.e_id='$eType'"; if ($anyvalue!="") $query.=" and e.Description like '%$anyvalue%'"; $query.=" order by e.Date_"; //echo $query; $total=0;$cnt=1; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $expense_id = $row['expense_id']; $e_id = $row['e_id']; $date_ = date('Y-m-d',strtotime($row['Date_'])); $expenseName =$row['e_name']; // getName($con,"select e_name from expensesheads where e_id='$e_id'"); echo "
" . $cnt++ ."" . $row['Date_'] . "$expenseName" . $row['Description'] . "" . $row['Amount'] ."Edit"; echo "delete"; $total+=$row['Amount']; } //$total=getName($con,"select sum(Amount) from expensesdaily where Date_ BETWEEN '$from' AND '$to' and LabID='$LabID' "); echo "
Total$total"; ?>