RT6456

From TipperWiki

Jump to: navigation, search

Trying to document our scenarios for Rainmaker / Revenue Management / IT discussion. --Jhannah 19:24, 2 September 2008 (UTC)

Contents

Scenarios

Normal reservation

Booked on Dec. 1 for Dec. 12 arrival, 1 night. 

<res ... id="1" st="F"
     time="20081202020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime=""
      los=1
    inlos="" 
/>

<res ... id="1" st="I"
     time="20081213020000"
   bktime="20081201120000" 
   intime="20081212120000"
  outtime=""
   xltime=""
      los=1
    inlos=1 
/>

<res ... id="1" st="O"
     time="20081214020000"
   bktime="20081201120000" 
   intime="20081212120000"
  outtime="20081213120000"
   xltime=""
      los=1
    inlos=1 
/>

Normal cancellation

Booked on Dec. 1 for Dec. 12 arrival, 1 night. Cancelled on Dec. 10. 

<res ... id="2" st="F"
     time="20081202020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime=""
      los=1
    inlos="" 
/>

<res ... id="2" st="X"
     time="20081211020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime="20081210120000" 
      los=1
    inlos="" 
/>

Normal no-show

Booked on Dec. 1 for Dec. 12 arrival, 1 night. No-show. 

<res ... id="3" st="F"
     time="20081202020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime=""
      los=1
    inlos="" 
/>

<res ... id="3" st="X"
     time="20081213020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime="20081213020000"
      los=1
    inlos="" 
/>

Instant Check In (ICI) no-show

Booked on Dec. 1 for Dec. 12 arrival, 1 night. ICI. No-show. 

<res ... id="4" st="F"
     time="20081202020000"
   bktime="20081201120000" 
   intime=""
  outtime=""
   xltime=""
      los=1
    inlos="" 
/>

<res ... id="4" st="X"
     time="20081213020000"
   bktime="20081201120000" 
   intime=""                # NOT "20081212140000" per Bob Wolfson, 20080910
  outtime=""
   xltime="20081213020000"
      los=1
    inlos=""                # NOT "1" per Bob Wolfson, 20080910
/>

Goals

  • Tom Walker wants to make sure that Revolution 1.5 counts all no-shows as cancels on the day of arrival. Since the cancellation actually occurs around 2am the morning after DOA, how do we want to handle this? Do we want my software to lie about when the cancel happened (like it is doing today)? Or do we want Revolution 1.5 to receive the real xltime and count it as happening on DOA? --Jhannah 19:47, 2 September 2008 (UTC)

Code notes

Here's the code tree I'm auditing. --Jhannah 00:24, 7 October 2008 (UTC) 

add_yesterdays_reservations()
   my @reservation_ids = $self->reservation_list_from_PMS();
   $self->_crs_res_to_xml($reservation_id);
      select * from resfile*
      my %times  = $self->_get_times_from_PMS($cro_resno, $st, $doa, $stay_nights, $resv_status);
         select from activity_log
         $self->apply_default_times(\%ret, $st, $doa, $stay_nights, $resv_status);

add_historical_reservations()
   select * from guest
   $self->apply_default_times(\%times, $st, $doa, $nights);

QA run 2008-10-06

Historical Normal reservation (2011237954 12 IOR) - looks good! 

<res ... id="2011237954" st="O" 
     time="20081006184832"
   bktime="20080902145609" 
   intime="20080905191900"
  outtime="20080906103100" 
   xltime=""
      los="1"
    inlos="1" 
/>

Historical Normal cancellation (15300332928 13 R) 

<res ... id="15300332928" st="X"  
     time="20081006184832"
   bktime="20080912094130"
   intime=""
  outtime=""
   xltime="20080915135741"
      los="1"
    inlos="1"                 # SHOULD BE BLANK
/>                            # But change not necessary?
                              #    Bob: "Therefore the InLOS makes no sense; we'll ignore it."

Historical Normal no-show (2010964873 126 NR) 

<res ... id="2010964873" st="X" 
     time="20081006184832" 
   bktime="20080708163852"
   intime=""
  outtime=""
   xltime="20080914120000"
      los="4"
    inlos="4"                 # SHOULD BE BLANK
/>                            # But change not necessary?
                              #    Bob: "Therefore the InLOS makes no sense; we'll ignore it."

Historical ICI no-show (15300331975 126 INR) 

<res ... id="15300331975" st="X" 
     time="20081006184832"
   bktime="20080822145015"
   intime=""
  outtime=""
   xltime="20080902120000"
      los="2"
    inlos="2"                 # SHOULD BE BLANK
/>                            # But change not necessary?
                              #    Bob: "Therefore the InLOS makes no sense; we'll ignore it."

QA run 2008-10-10

Daily Normal reservation (15300333562 12 IOR) 

<res ... id="15300333562" st="O"
     time="20081009113117"
   bktime="20081002171359"
   intime="20081008094751"
  outtime="20081009103030"
   xltime=""
      los="1"
    inlos="1"
/>

Daily Normal cancellation (15300333008 13 R) 

<res ... id="15300333008" st="X"
     time="20081008125652"
   bktime="20080915151930"
   intime=""
  outtime=""
   xltime="20080930105625"
      los="2"
    inlos="2"
/>

Daily Normal no-show (2011334020 126 NR) 

<res ... id="2011334020" st="X"
     time="20081008125652"
   bktime="20080919164842"
   intime=""
  outtime=""
   xltime="20081006120000"
      los="3"
    inlos="3"
/>

Daily ICI no-show (2011336527 126 INR) 

<res ... id="2011336527" st="X"
     time="20081008125652"
   bktime="20080921103050"
   intime=""
  outtime=""
   xltime="20080929120000"
      los="2"
    inlos="2"
/>

Finding scenarios

unload to j1.unl
select unique cro_resno, resv_status, hotel_status
from resfile_master_Ar
where prop = 'DENILK'
and depart_date >= '09/01/2008'
and depart_date <  '10/01/2008';

use strict;

my $s = {};
while (<>) {
   my ($cro, $crs, $pms) = split /\|/;
   $s->{$cro}->{crs}->{$crs} = 1;
   $s->{$cro}->{pms}->{$pms} = 1;
}

foreach my $cro (keys %$s) {
   print "$cro ";
   print join "", sort keys %{$s->{$cro}->{crs}};
   print " ";
   print join "", sort keys %{$s->{$cro}->{pms}};
   print "\n";
}
Retrieved from "http://jays.net/wiki/RT6456"
Personal tools