Airhost
=======    
https://www.youtube.com/watch?v=zHZOJcOMHq4

Steps
1. DELETE FROM `airhostroombook`
INSERT INTO `creative_dbblanc`.`airhostroombook` (
`arbaname`,
`arbacheckin`,
`arbacheckout`, 
`arbaroom`, 
`arbadateadd`,
`arbaroomtypeid`,
`arbaagentreference`,
`arbanodays`
			) VALUES
inn.com.sg/airhost_importstep2.php
	What in Airhost, Not in BI => program insert new bookings, manual edit BI bookings
	What in BI, Not in Airhost => a/manual cancel boookings. b/special case, edit BI Guest names
4. inn.com.sg/airhost_importstep3.php  (write Airhost allocation into BI, check Airhost any room overlap situation)
4. inn.com.sg/airhost_importstep4.php  (Update Airhost allocation into BI)
=======
CREATE TABLE `creative_dbblanc`.`airhostroombook` (
`arbaid` INT NOT NULL AUTO_INCREMENT ,
`arbaname` VARCHAR( 30 )  NOT NULL  ,
`arbacheckin`  VARCHAR( 8 )  NOT NULL     ,
`arbacheckout`  VARCHAR( 8 )  NOT NULL , 
`arbaroom`  VARCHAR( 3 )  DEFAULT '0', 
`arbadateadd`  VARCHAR( 8 )      ,
`arbaroomtypeid`  VARCHAR( 3 )      ,
`arbaagentreference`  VARCHAR( 50 )      ,  
`arbanodays`  INT ,  
`arbaprsid` INT ,
`arbaprsroomtypeid`  VARCHAR( 3 ) ,
`arbaroom_actual`  VARCHAR( 3 )  DEFAULT '0',
PRIMARY KEY ( `arbaid` ) ,
INDEX ( `arbadateadd`)
) ENGINE = MYISAM ;

=======
INSERT INTO `creative_dbblanc`.`airhostroombook` (
`arbaname`,
`arbacheckin`,
`arbacheckout`, 
`arbaroom`, 
`arbadateadd`,
`arbaroomtypeid`,
`arbaagentreference`,
`arbanodays`
			) VALUES
('Timothy Hanser','20221110','20221201','6','20221106','P1','2241520085','21'),



SELECT `drbrmno`,`drbdatemonth`, count(`drbbed1`) FROM `dateroombook` WHERE `drbdateyear` = '2023' and `drbdatemonth` < '05' 
and `drbbed1` != '0'
and `drbrmno` in ('001','002') group by `drbrmno`,`drbdatemonth` order by `drbrmno`,`drbdatemonth`

SELECT `drbrmno`, count(`drbbed1`) FROM `dateroombook` WHERE `drbdateyear` = '2023' and `drbdatemonth` < '05' 
and `drbbed1` != '0'
group by `drbrmno` order by `drbrmno`

	Fill Rate
P1	77%
Q2	66%
P3	49%
Q4	49%