o_kb.php
fun_ajax.php
Print Acknowledge Bill kotbotprt.php
Print Invoice o_kot_botbill.php
dashboard_kb.php


PRINT ACK BILL (NEW)
-------------------
o_tbl_sts_ack.php
fun_ajax.php  displays the screen
  if($_POST["prgnam"]=='tblbillinq') 
  {
   $te_tblsno = $_POST['gettblsno'];
   $te_watsno = $_POST['getwatsno'];
   show_acknowledgement_bill($te_tblsno,$te_watsno);
  }
  //***********
  goto show_acknowledgement_bill  in this program (fun_ajax)
  
  //************
  onclick Print submit Button goes to o_tbl_sts_ack.php
  if(isset($_POST['printinv']))
  {
   $te_tblsno = $_POST['gettblsno'];
   $te_watsno = $_POST['getwatsno'];
   
   $te_fbhcatsno=44;
   $te_fbmdno = load_fbmdno($te_fbmtypsno,$te_fbhcatsno);
   $te_fbmsno = next_auto_increment('o_fbmmast');
   
   prt_ackbill($te_fbhorbsno,$te_watsno,$te_tblsno,$te_fbmdno,$te_fbmsno,$te_fbmtypsno,$te_fbhcatsno,$te_frddty);
   
  }
  // prt_ackbill is in kotbotprt.php (require file)
  
PRINT INVOICE (NEW)
-------------------
o_kot_botinv.php  [prt_kotbot_inv($te_fbmsno,$te_fbmtypsno  ...]

require o_kotbotinv.php  (INSERT INTO o_fbmmast)


fun_ajax notes
==============
Pass watsno kot category display screen
o_kb:
-----
$(document).on("click", ".open-AddKot", function () {
     var watsno = $("#getwatsno").val();
     var prgnam='kotmenuload';
fun_ajax:
---------
if($_POST["prgnam"]=='kotmenuload') 
{
 $te_watsno = $_POST['kotwatsno'];
 $sql_wat= "SELECT watfunbiteyn FROM o_watmast
            where  watsno = '$te_watsno'";
 //echo "$sql_wat<br>";           
 $rec_wat=mysql_query($sql_wat) or die ("SQL error wat:<br>".mysql_error());
 $fields_wat= mysql_fetch_array($rec_wat);
 $te_watfunbiteyn = $fields_wat['watfunbiteyn'];
 
 if($te_watfunbiteyn=='Y')
 {
  $sql_kotcat= "SELECT kbcsno,kbckbc,kbccolor FROM o_kbcmast
                where  kbccatsno = '42' 
                ORDER BY kbckbc";
 }
 else
 {
  $sql_kotcat= "SELECT kbcsno,kbckbc,kbccolor FROM o_kbcmast
                where  kbccatsno = '42' and kbcsno != '40' and kbcsno != '46'
                ORDER BY kbckbc";
 }     
     
     



view bill
s=========
o_kb.php
onclick goes to o_viewbills.php
go to fun_ajax.php 



ROOMS
-----
1. ROOM SERVICE
2. PURCHASES 
   2a. PAY THEN AND THERE
   2b. POST TO ROOM
  
   


truncate table o_fbhtran;
truncate table o_fbltran;