           a 	                                Z4;  ;>ky@                   $   эh^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                2  PG1(m`JB,UL;+                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       12345678
 testset12345678
 summary12345678stime12345678
 startdatewindow12345678
 start1212345678
 testset12345678
 summary12345678stime12345678
 startdatewindow12345678
 startdateplanned123456781i    startdateactual12345678sortKeys12345678         
$22A031CA-D033-11F0-8E2D-2A8CE3AF2D5F
$22A1828C-D033-11F0-8E2D-2A8CE3AF2D5F   pat   atm_idselectors12345678
pauserunmode12345678      passresultCounters12345678    resList12345678    reqSelectors12345678reordered12345678numUntested12345678notified123456781i    mtime12345678locked12345678
1lastTest12345678isActive12345678    disabled12345678
)WFAST_Copy-Print/ FS_24.000_Banner_Sheetsdescription12345678    dbdata12345678currTest123456780i    ctimebπ   	  TEST_1                    zh_MA/"                    эh^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            112345678
      	   isDefault
	Test_Case   value   testing_type   
D8.7_Canyon/Mystic   value	   isDefault   bra12345678
      	   isDefault
	Test_Case   value   testing_type   
D8.7_Canyon/Mystic   value	   isDefault   branch_to_test   	   isDefault
Wired   value   network   	   isDefault

Canyon_MFP   value   program   

Copy&Print   value	   isDefault   team   
Isolated_Network   value	   isDefault   network_tested   	   isDefault
Test_Change   value   drp_pass   
Ipv4   value	   isDefault   network_interface   

Windows_XP   value	   isDefault   os   	   isDefault
Chrome   value   browservariables12345678
r73R77LMuser12345678tpno12345678    runSelectors12345678refreshable12345678numtests12345678
 enddatewindow12345678
 enddateplanned123456781i    enddateactual12345678
 assignedtobπ   	  TEST_0                   	 12345678   
1   exectimestaff
 
   atm_prlink
123.xxx.005.33000   dvc_ver
 
   driver_ver   
    atm_step_results
isolated_network   network_tested
IWFAST_Copy-Print.dir/Testcases.dir/FS_24.000_Banner_Sheets.dir/168453.bts   id

windows_xp   os
pass   results
    atm_prid   
    atm_step_notes

canyon_mfp   product
<span class='result' user='r73R77LM' when='1764856831' clocktime='' stafftime='1' result='pass'>checked with supported medias with selected media loaded in trays</span>   notes         
Isolated Network   content
isolated_network   raw
Network Tested   label   network_tested   
Print Driver Version   label
    raw
    content
   driver_ver   
Achecked with supported medias with selected media loaded in trays   raw
Latest Execution Note   label
Achecked with supported medias with selected media loaded in trays   content   notetext   
Wired   content
wired   raw
What network connection?   label   network   
*<div class='text'>123.xxx.005.33000</div>
   content
Device Software Version   label
123.xxx.005.33000   raw   dvc_ver   
    content
    raw
Problem Report Links   label
   atm_prlink   
1m   content
1   raw
Actual Staff Time   label   exectimestaff   
Product Name   label

canyon_mfp   raw

Canyon MFP   content   product   
IE 5   content
ie_5   raw
What Browser?   label   browser   
    content
Problem Report IDs   label
    raw   atm_prid   
pass   raw
Result   label
!<font color='#64bd1b'>pass</font>   content   results   Dec 4, 2025, 7:30:31 PM IST   content
Last Execution Time   label1i       raw   when   
r73R77LM   raw
Run By   label
Aluru Kirankumar (External)   content   user   
Ipv4   content
ipv4   raw
Network Interface   label   network_interface   

Windows XP   content
What Operating System   label

windows_xp   raw   os
   1764856831   atm_rundatahistory
wired   network
ipv4   network_interface
<span class='result' user='r73R77LM' when='1764856831' clocktime='' stafftime='1' result='pass'>checked with supported medias with selected media loaded in trays</span>   note1i       when
r73R77LM   user
$22A031CA-D033-11F0-8E2D-2A8CE3AF2D5F   atm_id
ie_5   browsered NYU  f               xYU  g               fYU  h               XYU  i                                            L      P      Z      k      t                         8      @      J      M      ~                                                                                                  F      H      N      P      X      Y      Z      [      \      ]      ^      _      ~                                                                                                                                            ?       A       T       U       q       r                                                 !      !      !      !      
!      !      !      !      !      !      $!      %!      &!      '!      (!      )!      *!      .!      /!      :!      <!      @!      E!      J!      N!      O!      `!      !      $      $       ,      /,      0,      _,      `,      ,      ,      ,       -      &-      '-      (-      --      .-      0-      h-      o-      p-      -      -      -      -      -      -      -      -      -      -      -      -      -      -      -      -      -      -      -       .      /.      0.      0      0      !0      00      10      60      80      =0      A0      0      0      0      0      0      0      0      0       1      1      .1      11      1      1      1      1       2       4      M       N      ֟                   Ф                               ,      @      s      t      ~                               "                                          (      @      t                               	 12345678   
 
   atm_prlink
1   exectimestaff
isolated_network   network_tested   
    atm_step_results
 
   driver_ver
123.xxx.005.33000   dvc_ver
pass   results

windows_xp   os
IWFAST_Copy-Print.dir/Testcases.dir/FS_24.000_Banner_Sheets.dir/168454.bts   id

canyon_mfp   product   
    atm_step_notes
    atm_prid         
Network Tested   label
isolated_network   raw
Isolated Network   content   network_tested   
*<div class='text'>123.xxx.005.33000</div>
   content
123.xxx.005.33000   raw
Device Software Version   label   dvc_ver   
Print Driver Version   label
    raw
    content
   driver_ver   
wired   raw
What network connection?   label
Wired   content   network   
Latest Execution Note   label
Achecked with supported medias with selected media loaded in trays   raw
Achecked with supported medias with selected media loaded in trays   content   notetext   
    raw
Problem Report Links   label
    content
   atm_prlink   
1m   content
1   raw
Actual Staff Time   label   exectimestaff   
IE 5   content
What Browser?   label
ie_5   raw   browser   

Canyon MFP   content

canyon_mfp   raw
Product Name   label   product   
Problem Report IDs   label
    raw
    content   atm_prid   1i       raw
Last Execution Time   labelDec 4, 2025, 7:30:31 PM IST   content   when   
Run By   label
r73R77LM   raw
Aluru Kirankumar (External)   content   user   
Result   label
pass   raw
!<font color='#64bd1b'>pass</font>   content   results   

Windows XP   content
What Operating System   label

windows_xp   raw   os   
Ipv4   content
ipv4   raw
Network Interface   label   network_interface
   1764856831   atm_rundatahistory
<span class='result' user='r73R77LM' when='1764856831' clocktime='' stafftime='1' result='pass'>checked with supported medias with selected media loaded in trays</span>   notes
wired   network
$22A1828C-D033-11F0-8E2D-2A8CE3AF2D5F   atm_id
r73R77LM   user1i       when
<span class='result' user='r73R77LM' when='1764856831' clocktime='' stafftime='1' result='pass'>checked with supported medias with selected media loaded in trays</span>   note
ipv4   network_interface
ie_5   browsered aYU  f               qYU  g               paYU  h               `YU  i       ay =~ /^last(\w\w\w)$/ ) {
        my $dow = $DAYS{$1};

        my $last_day = DateTime->last_day_of_month(
            year      => $year,
            month     => $month,
            time_zone => 'floating',
        );

        my $dt = DateTime->new(
            year      => $year,
            month     => $month,
            day       => $last_day->day,
            time_zone => 'floating',
        );

        while ( $dt->day_of_week != $dow ) {
            $dt -= $PLUS_ONE_DAY_DUR;
        }

        return ( $dt->month, $dt->day );
    }
    elsif ( $day =~ /^(\w\w\w)([><])=(\d\d?)$/ ) {
        my $dow = $DAYS{$1};

        my $dt = DateTime->new(
            year      => $year,
            month     => $month,
            day       => $3,
            time_zone => 'floating',
        );

        my $dur = $2 eq '<' ? $MINUS_ONE_DAY_DUR : $PLUS_ONE_DAY_DUR;

        while ( $dt->day_of_week != $dow ) {
            $dt += $dur;
        }

        return ( $dt->month, $dt->day );
    }
    else {
        die "Invalid on spec for rule: $day\n";
    }
}

sub utc_datetime_for_time_spec {
    my %p = @_;

    # 'w'all - ignore it, because that's the default
    $p{spec} =~ s/w$//;

    # 'g'reenwich, 'u'tc, or 'z'ulu
    my $is_utc = $p{spec} =~ s/[guz]$//;

    # 's'tandard time - ignore DS offset
    my $is_std = $p{spec} =~ s/s$//;

    ## no critic (NamingConventions::ProhibitAmbiguousNames)
    my ( $hour, $minute, $second ) = split /:/, $p{spec};
    $minute = 0 unless defined $minute;
    $second = 0 unless defined $second;

    my $add_day = 0;
    if ( $hour >= 24 ) {
        $hour    = $hour - 24;
        $add_day = 1;
    }
