Wduw{Aó*19 *ذ11]yiᬲ.ؕ1tzqaTMI8  ݕh.46tT5{KC8s@3j|f ct.;FLm i,Ǖ}%YS* ʢ 3\^P}/%ȉh]KyJD g<;e›وģ)p+$LͲnqi6BH9*&1,wL_~Ы8X'u9{g\q2cDF:cG~%8dGɶX>f=Cl*QMBxށ2J=*O pTO{ؐ3E9QKt*#ZO;K7kR-vd_`aB"ƶP\ tMhF .OgM@*hװGa%2_ ZfAd5\OA2@{ϴ@> Ėj{(^~|j 3\Uv*G `6uZٷ t |b?upɭql7IXi,bC5V8}q}6ۯsOr|iiˈĺjKo,KKFʣca"oVJ#7OqT(lT N#/eDEc7X1sv${H?MYnW5SQentkHv]!Q*T%MO#:e_╃%07pZEÁrT`#:7mey{ ϸkK/ۧzOXpoO7H-hQRJs מ4KSVuxaN}AU JzT"G7H3V#|lT5@tj_:0UӄX %zގsl~[3]RZx&H2|; "dtMUŤs '_&B5dzWS?&İ ݼL7ŷ*%>pcE20B±a* ,[<8Bu:I=mĭ9$bQa+۱!It ՆKThi .Ʀ=!y@܎+iڔ x$1. fS&A_)f<"7g%#oQEe<}qpRJKdrI=XOwe2HQiVTu' ;HB)ܒ3@;^tzRejJﻟTyp;ﻟTyp;c (;I&=UԌ5A"Z[ZUA-\ܹ#8vzNqpD;I~G\Dɧ}af2G!2jHn=Oʅ{1v c.k7Ud(s](wذkۓ+ŧdqcWѼJ.jbSitKljYך!ehgm:ѥXĆ%ﻟTyp;ﻟTyp;ﻟTyp;"\_H>jiL7d.mF)6~u@X̳Pщ{7a̞#$hUQIܞ9;IWNmGr  ˽ZA)7ӿdD6l5qivh 5LR3>ɺ.x1`l{!VS_倃OۿWNI,`DZ]-N7j dx]: )]oI N肼_w7pgRuDu&ͶSp} i75姃8A^#"=` R<ԘC(𫐇JZ3%uDu&Ͷ/3TlXd_BaT5l[Pb.j 3RbEd]ؔన֮&"cؽ[80s'⌤Qy \7GvI?[YaBfk=|G36WmMej<>W(D\O2r6V0Hb;(AwEIVjSI@n?,n{qrԀ('f_Ժcr,kaGb1@^ G f_Ժcr,kap3/A\YS=&pyf괊=?P]$6n =WK4*w,-)#=O|T,As˰v$գ`ǣFdNgFTFʕ4&l?u6-+'~#X( yaF^9uڦ% s6U-WǛEB2"+bFo D}1Kb|@yǤoV^qvw+j9i>DGW7ƳK,GcU#O'$,~Ы8X'um4l'>aU(#[()3pwm9Z] 9=W,<Bjb,R(拝z(5(ɿTH뢉:zXHm-(Wj|*{<!mA9"g(0^<\4k_M Eg9 uԱl {җ ~?%ι:"*#k./6{vH"=Ic ib$:UdZcyRxX!]; Slڧ6L$expQR:{#:vEL9L(k6d*w?$A)Ovՙǘ~|KWH")t/L(bn(Z~d/.΂)0{6{:qlxqL:[zܐWq"M IoGB/<èE'ƙW(`΂΄.jJ喦'y9*q _Z@jBNץ~>|G#F.՚c$gZҺs"t/wQ |ry3#BN]JNjgD[/{S=e*loz0B&=t9\ej"U"XDDǤ|N3QX]R D<̔vνY`n'EyUMڳlk.ٹ]month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); $lunch=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and section_='$section_' and partyType='8321' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); //echo "select count(*) from bookingtbl where section_='$section_' and partyType='8322' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "; $dinner=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and section_='$section_' and partyType='8322' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); $total=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and section_='$section_' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); }else{ $lunch=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and partyType='8321' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); $dinner=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and partyType='8322' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); $total=getName($conn,"select count(*) from bookingtbl where (partyStatus=0 or partyStatus is null) and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); } echo "".date('F-Y',strtotime($from))."Lunch : $lunchDinner : $dinner Total: ".($total).""; echo "SunMonTueWedThuFriSat"; for ($i=$from; $i<$to; $i = date ("Y-m-d", strtotime("+1 days", strtotime($i)))){ //$pdf->MultiAlignCell(9,4.5,date('d', strtotime($i))."\n".substr(date('D', strtotime($i)),0,3) ,1,0,'C'); $dayno=date ("w", strtotime($i)); if($dayno==0 or $cnt==1) echo ""; if($cnt==1 and $dayno>0){ for ($j=0; $j<$dayno; $j++) { //echo ""; } echo ""; } if($today==date("Y-m-d", strtotime($i))){ echo "".date ("d", strtotime($i)).""; }else{ echo "".date ("d", strtotime($i)).""; } //$isParty=getName($conn,"select 1 from bookingtbl where partyDate='".date ("Y-m-d", strtotime($i))."' "); $isParty=getName($conn,"select partyStatus from bookingtbl where (partyStatus=2 or partyStatus=0 or partyStatus is null) and partyDate='".date ("Y-m-d", strtotime($i))."' "); $k=1; if($isParty!="1"){ $query="select hallids,partyType,autoid,hostname,section_ from bookingtbl where partyDate='".date ("Y-m-d", strtotime($i))."' and recordTYpe='BOOKING' "; if($section_>=0) $query.=" and section_='$section_' "; $query.=" order by partyType,date_ desc "; $cur=odbc_exec($conn,$query ); while(odbc_fetch_row($cur)) { //if(odbc_result($cur,'partyType')=='8321') $color='red'; else $color='blue'; $title=getHalls($conn,odbc_result($cur,'hallids'));//odbc_result($cur,'hostname'); //if(odbc_result($cur,'section_')==0) $branch="SA"; elseif(odbc_result($cur,'section_')==1) $branch="SG"; else $branch="CH"; //$branch=""; if($isParty==2){ $badge="badge bg-success";$color='yellow'; $size='14px'; }elseif(odbc_result($cur,'partyType')=='8321'){ $badge="badge bg-warning";$color='black'; $size='14px'; }else{ $badge="badge bg-secondary";$color='white';$size='14px'; } //echo "
".getHalls($conn,odbc_result($cur,'hallids')).""; echo "
".odbc_result($cur,'hostname').""; $k++; } //$=getName($conn,"select top 1 hallids,partyType from bookingtbl where partyDate='".date ("Y-m-d", strtotime($i))."' "); } while($k<=3){ echo "
"; $k++; } $cnt++; } if($dayno>=0){ for ($j=$dayno; $j<6; $j++) { echo ""; } //echo ""; } //$lunch=getName($conn,"select count(*) from bookingtbl where partyType='8321' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); //$dinner=getName($conn,"select count(*) from bookingtbl where partyType='8322' and month(partyDate)='".date ("m", strtotime($from))."' and year(partyDate)='".date ("Y", strtotime($from))."' "); //echo "Lunch : $lunchDinner : $dinner Total: ".(($lunch)+($dinner)).""; echo ""; //$from=date_01(date ("Y-m-d", strtotime("-1 days", strtotime($from)))); //echo " Back Next"; $query="select * from bookingtbl where 1=2 and userID='".$_SESSION['userID']."' and recordTYpe='BOOKING' order by date_ desc "; $cur= odbc_exec( $conn, $query ); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { $partyDate=(date('d.m.y',strtotime(odbc_result($cur,'partyDate')))); if ($cnt==1) echo "
#Party_DateBranchTimeHallGuestsHostContactPayments"; echo "
". $cnt++ ; echo "".$partyDate; echo "".getBranch(odbc_result($cur,'section_')); echo "".getName($conn,"select headName from AccountHeads where ID='".odbc_result($cur,'partyType')."' "); echo "".getHalls($conn,odbc_result($cur,'hallids')); echo "".(odbc_result($cur,'guests')); echo "".(odbc_result($cur,'hostname')); echo "".(odbc_result($cur,'contact1')); echo "Payments"; echo ""; echo ""; $total+=odbc_result($cur,'guests'); } //echo "
Total".$total; echo "
"; ?>
Postponed Parties =0) $query.=" and section_='$section_' "; $query.=" order by partyType,date_ desc "; $cur=odbc_exec($conn,$query ); while(odbc_fetch_row($cur)) { $title=getHalls($conn,odbc_result($cur,'hallids'));//odbc_result($cur,'hostname'); echo "
".date('d.m-Y',strtotime(odbc_result($cur,'partyDate')))."\t".odbc_result($cur,'hostname'); } ?>