Wduw{Aó*19xa5Xj}z 1bjid7ؕ1tzqaTԈ98whJBS-~yd|[ D9o0?S FJ*{P7Yĺ}Ia?p;xm<%G<6)ZGf>WDeSSKZ=x?M'*,zd^VdQ1D躀R0Ct{_Ҷp, ږ]S:uk4@S;f_Pbm`¯Q!BTq8 %6(Z}9 zzտYd)K-ÏNEJYz08n>鸈~\Z8 =n>&vM q,Z8‚(EQ;SӬzqႀ*aA#U#>#w@N&@6<ZqTLDv$Ƅ/\"h? kNp> 4 ~۪y5V$GZ9.PЄu8|Cy}5 <#% +V~7!UwO ݸYuk>\vKI[PMIvsjkV> ; ёnH- ho+0ʖQo0Tட0XTeнS?``  K2"w{~rҟoqm;tJ{tm$XP2&Wzd2vaiAê/y ,ES.YU1DmFvn886\[.a3z6nݺ/<2Egw%`y|Kt-}+ ĕ]4B%*~FD|D@{qa\G]wx:W &#~(qѹld4@[@*I i LX3O]\ݲF聼HPY k%-'_3yMQ(fAL5b:fO [.S0K.9%e }!MmeuHZTq5p̋F'=?2lxl\pDnWDBi8,~y6!HnIxG>6s5".7PT G4UD31RJ /Da,YqE % rhDKƨ-Rә_ksJZ0Im:Wp+>c͓ȱbYæAX Է'ez)5"S8'蠛+h@nDcfA}KDt j|dBRR(Tba4՝y?W9R}-p4־a/\2yv@ OL,˜(]U^DŸek2zFSc8y4v=T=,&ڍl#|-"\棶R1r`F7.ٖzųG*)kRM̓FvC$ais#y0un| ]UnNGJnѐ8I8EySN粻K/\ڙE-"{ G9 /Kf(/f%g*Q٧h ;vv1Ī̻[w .Bu0s蘵=nO !(сQfS[4y# 61RK;4X(k5F}`S/LnnM/K)(MtGˎsk].\'JZ猹VE˼=h!X v6I{43x_"kZ[ Bz\/Dr*q2@A /*K}Z@i{п=m?ęg堋C~Vd>?/*N$O8Xejez&d٨E1Iq,D [Pp2im4ԯ[{⻎a} @1H$Ed@0~D#I+lg*G%XYW= dmt "õ>,8^Sl 6uI`E4DFwsH7"Z \W4vIT UJJR|ssr4 v2SPE<\$O/ʺ%|,eF° G: {¶JІg ,vX6ir--Lɼz5,R&){pNR>2v_HX֌CqI \ȐHVCTqX[qwr\Y]Ǔ]QrM&WgNrrtL±x#ܰųGVJɣ&u?f r~VV''y[qpL-ZwI䎝?LR2$7O EJZأiK.} KO9Uw28uс!;F4s2E)GJAvh\iEpL-Ch[o]U tbicbL/opAzB{r7f$D›0p.G8(\ ,) !y3:vCW3$1kKrFް젥rZ6t.8nt0/MՋg6wc3hcW,'$contact1','".$_SESSION['userID']."','$recordType','$partyDate','$guests','$autoid','$eventType','$date_','$hostname','$partyType','$section_','$male')"; if(canSave($conn,"booking")=="0"){ $cur= odbc_exec($conn,$query); $_SESSION['preRecord']=$curRecord; $isUpdate=true; } } }else{ if(canUpdate($conn,"booking")=="0"){ $query="update bookingtbl set partyStatus='$partyStatus',date_='$date_' where autoid='$autoid'"; $cur= odbc_exec($conn,$query); $query="update bookingtbl set djCharges='$djCharges',remarks='$remarks',nationality='$nationality',menuType='$menuType',menu='$menu',tax='$tax',hallCharges='$hallCharges',serviceCharges='$serviceCharges',functionType='$functionType',paymenttype='$paymenttype',advance='$advance',contact2='$contact2',hallids='$hallids',female='$female',contact1='$contact1',userID='".$_SESSION['userID']."',recordType='$recordType',partyDate='$partyDate',guests='$guests',eventType='$eventType',hostname='$hostname',partyType='$partyType',section_='$section_',male='$male' where autoid='$autoid'"; $cur= odbc_exec($conn,$query); $isUpdate=true; } } /* $query="delete from cashintbl where partyNo='$autoid' and Particulars='145' and labid='".$_SESSION['labid']."' "; //Delete Advance $cur= odbc_exec($conn,$query); $autoidCash= getName( $conn, "select isnull(max(autoid),0)+1 from cashintbl" ); $fields="labid,partyNo,userID,recordType,partyDate,amount,autoid,paymenttype,date_,hostname,partyType,section_,Particulars"; $query="insert into cashintbl($fields) select labid,autoid,userID,'CASH_IN',partyDate,advance,'$autoidCash',paymenttype,date_,hostname,partyType,section_,145 from bookingtbl where autoid='$autoid' and labid='".$_SESSION['labid']."' "; $cur= odbc_exec($conn,$query); */ //echo "





".$query; //exit(); if($isUpdate==true and $paymenttype>0 and $advance>0){ $cur= odbc_exec($conn,"delete from ledger where partyNo='$autoid' and labid='".$_SESSION['labid']."' and recordType='$recordType' "); //Booking Ledger IN //if($section_==0) $actID=614; elseif($section_==1) $actID=615; else $actID=616; $actID=getName($conn,"select top 1 ID from student where sectionID in(select ID from AccountHeads where headName='Booking' and headType='Accounts' and labid='".$_SESSION['labid']."' ) "); $query="insert into ledger(tillDate,recordType,accountID,remarks,credit,partyNo,date_,userID,labid) values('$partyDate','$recordType','$actID','Booking Advance','$advance','$autoid','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")"; $cur= odbc_exec( $conn, $query ); $cur=calculateBalance($conn,$actID); //Cash Debited $query="insert into ledger(tillDate,recordType,accountID,remarks,debit,partyNo,date_,userID,labid) values('$partyDate','$recordType','$paymenttype','Booking Advance','$advance','$autoid','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")"; $cur= odbc_exec( $conn, $query ); $cur=calculateBalance($conn,$paymenttype); } //echo "



".$query; echo ""; exit2($conn,$conn3); } if(isset($_GET['editID'])){ $autoid=$_GET['editID']; $query = "select * from bookingtbl where autoid='$autoid'"; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $date_= date("Y-m-d", strtotime(odbc_result( $cur,"date_"))); $partyDate= date("Y-m-d", strtotime(odbc_result( $cur,"partyDate"))); $section_= odbc_result( $cur, "section_" ); $male= odbc_result( $cur, 'male' ); $hostname= odbc_result( $cur, 'hostname' ); $guests= odbc_result( $cur, 'guests' ); $eventType= odbc_result( $cur, 'eventType' ); $partyType= odbc_result( $cur, 'partyType' ); $contact1= odbc_result( $cur, 'contact1' ); $contact2= odbc_result( $cur, 'contact2' ); $male= odbc_result( $cur, 'male' ); $female= odbc_result( $cur, 'female' ); $advance= odbc_result( $cur, 'advance' ); $paymenttype= odbc_result( $cur, 'paymenttype' ); $functionType= odbc_result( $cur, 'functionType' ); $hallCharges= odbc_result( $cur, 'hallCharges' ); $serviceCharges= odbc_result( $cur, 'serviceCharges' ); $remarks= odbc_result( $cur, 'remarks' ); $tax= odbc_result( $cur, 'tax' ); $menu= odbc_result( $cur, 'menu' ); $menuType= odbc_result( $cur, 'menuType' ); $nationality= odbc_result( $cur, 'nationality' ); $partyStatus= odbc_result( $cur, 'partyStatus' ); $djCharges= odbc_result( $cur, 'djCharges' ); $hallids= odbc_result( $cur, 'hallids' ); $arrhall=explode(',',$hallids); } } ?> HOME

Booking

Booking Date
Party Date
Branch
Time
Hall
Host Name
Contact 1
Contact 2
Event Type
Guests
Menu Type
Menu/Rate
Male
Female
Hall CHarges
Service Charges
DJ Charges
Tax
Advance
Payement Type
Function Type
Nationality
Remarks
Status

='$date_' and recordType='BOOKING' order by partyDate asc "; $cur= odbc_exec( $conn, $query ); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { $partyDate=(date('d.m.y',strtotime(odbc_result($cur,'partyDate')))); $date_=(date('d.m.y',strtotime(odbc_result($cur,'date_')))); if ($cnt==1) echo ""; echo "
#DatepDateBranchTimeHallGuestHostContactBillsFoodBalance"; if(odbc_result($cur,'partyStatus')==1) $color='yellow'; else $color=""; echo "
". $cnt++ ; echo "".$date_; 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 "Bills"; echo "Food"; $partyNo=odbc_result($cur,'autoid'); $exp=getName($conn,"select isnull((guests*menu),0)+isnull(serviceCharges,0)+isnull(hallCharges,0)+isnull(stageCharges,0)+isnull(soundSystem,0)+isnull(sofaSets,0)+isnull(mirrorDiningTable,0)+isnull(djCharges,0)+isnull((isnull(roastedLamb,0)*isnull(roastedLambNos,0)),0) from bookingtbl where autoid='$partyNo' "); $exp+=getName($conn,"select isnull(sum(amount),0) from partyExpensestbl where amount>0 and partyNo='$partyNo' and recordType='partyExp' "); $taxamt=round(($exp*odbc_result($cur,'tax'))/100); $remarks=getName($conn,"select isnull(remarks,0) from bookingtbl where autoid='$partyNo' "); $cost=$exp+$taxamt; $cost-=$remarks; $paid=getName($conn,"select isnull((advance),0)+isnull(received,0) from bookingtbl where autoid='$partyNo' "); $bal=$cost-$paid; if(odbc_result($cur,'partyStatus')==2){ $badge="badge bg-warning"; $status='Tentative'; }elseif($bal>0){ $badge="badge bg-danger"; $status='New'; }else{ $badge="badge bg-success";$status='Progress'; } echo "".round(($bal)).""; echo ""; echo ""; //echo ""; echo ""; echo ""; $total+=odbc_result($cur,'guests'); } //echo "
Total".$total; echo "
"; ?>