           a 	                                rH  ab 
&0                   $   эh^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                2 
 WN8/tgQI3$~xf^LD
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 12345678
WD8.5/WFAST_Discovery_Regression_Copy_Print_EWS/Testcase_RC3/FS_25.000_Copy_Sides_Imagedtestset12345678
 su1212345678
WD8.5/WFAST_Discovery_Regression_Copy_Print_EWS/Testcase_RC3/FS_25.000_Copy_Sides_Imagedtestset12345678
 summary12345678stime12345678
 startdatewindow12345678
 startdateplanned12345678<'mh    startdateactual12345678sortKeys12345678         isRE   isCS
   matchBlank   isEmpty   
 
manual
po_signoff_pending
automation_inprogress
testchange_inprogress
request_for_automation   pat
   isNotEmpty	   test_type      isRE   isCS
   matchBlank   isEmpty   
wfast   pat
   isNotEmpty   test_covered_by      isRE   isCS
   matchBlank   isEmpty
BWFAST_Copy-Print.dir/Testcases.dir/FS_25.000_Copy_Sides_Imaged.dir   pat
   isNotEmpty   idselectors12345678
pauserunmode12345678      passresultCounters12345678    resList12345678    reqSelectors12345678reordered12345678numUntested12345678notified12345678<'mh    mtime12345678locked12345678
0lastTest12345678isActive12345678    disabled12345678
"FS_25.000_Copy_Sides_Imaged_[IPv6]description12345678    dbdata12345678currTest12345678TZh    ctimel2     TEST_1                    zh_MA/"                    эh^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         12345678
      	   isDefault

Canyon_MFP   value   program   
	Test_Case   value	   isDefault   testing_type   12345678
      	   isDefault

Canyon_MFP   value   program   
	Test_Case   value	   isDefault   testing_type   	   isDefault

Windows_XP   value   os   	   isDefault
D8.5.1_Platform   value   branch_to_test   

Copy&Print   value	   isDefault   team   
IPv6-Validation_Test   value	   isDefault   drp_pass   
Wired   value	   isDefault   network   	   isDefault
Ipv6   value   network_interface   
Chrome   value	   isDefault   browser   
Isolated_Network   value	   isDefault   network_testedvariables12345678
r7F7QV3Juser12345678tpno12345678    runSelectors12345678refreshable12345678numtests12345678
 enddatewindow12345678
 enddateplanned12345678<'mh    enddateactual12345678
 assignedtol2     TEST_0                    12345678   
r7F7QV3J   user
122.039.025.18310   dvc_ver
k<span class='result' user='r7F7QV3J' when='1751983932' clocktime='' stafftime='1' result='pass'>pass</span>   note
pass   results   
pass   atm_step_results
 
   driver_ver
isolated_network   network_tested
k<span class='result' user='r7F7QV3J' when='1751983932' clocktime='' stafftime='1' result='pass'>pass</span>   notes
corrib   product
    atm_prid

windows_xp   os<'mh       when
MWFAST_Copy-Print.dir/Testcases.dir/FS_25.000_Copy_Sides_Imaged.dir/136944.bts   id
wired   network
ie_5   browser
1   exectimestaff
 
   atm_prlink   
    atm_step_notes
ipv6   network_interface         
122.039.025.18310   raw
Device Software Version   label
*<div class='text'>122.039.025.18310</div>
   content   dvc_ver   
r7F7QV3J   raw
Thagaram Sathwika (External)   content
Run By   label   user   
!<font color='#64bd1b'>pass</font>   content
Result   label
pass   raw   results   
pass   content
Latest Execution Note   label
pass   raw   notetext   
1   raw
1m   content
Actual Staff Time   label   exectimestaff   
ie_5   raw
What Browser?   label
IE 5   content   browser   
wired   raw
Wired   content
What network connection?   label   network   
    raw
Problem Report Links   label
    content
   atm_prlink   
isolated_network   raw
Isolated Network   content
Network Tested   label   network_tested   
    raw
Print Driver Version   label
    content
   driver_ver   
corrib   raw
Corrib   content
Product Name   label   product   Jul 8, 2025, 7:42:12 PM IST   content
Last Execution Time   label<'mh       raw   when   
    raw
Problem Report IDs   label
    content   atm_prid   
ipv6   raw
Ipv6   content
Network Interface   label   network_interface   

windows_xp   raw

Windows XP   content
What Operating System   label   os
   1751983932   atm_rundatahistory
$FB1E343A-19C3-11EE-A1BE-1661CF8F79AB   atm_ider      
008250
009360
005551   sessions   refreshabled       ctimef       mtime-?h       lastSessionUpdate
2<p><span>FS_18.050_Job_Based_Accounting</span></p>   description-?h       lastChangeTimeZ         numtests   group
    summary   lockedSET_D8.0/WFAST_Discovery_Regression_Accounting/Testcases/FS_18.050_Job_Based_Accounting/FS_18.050_Job_Based_Accounting12345678      refreshable&hc       ctime   
000707   sessions
<<p><span>FS_44.003_On-Box_Accounting_Login_Backup</span></p>   description@-?h       lastChangeTime   numtests@-?h       lastSessionUpdateUhc       mtime
    summary   locked   groupSET_D7.7/WFAST_Discovery_Regression_Accounting/Testcases/FS_44.003_On-Box_Accounting_Login_Backup/FS_44.003_On-Box_Accounting_Login_Backup12345678   
 
   assignedto
r85WBTDR   user
      
Chrome   value	   isDefault   browser   	   isDefault

Windows_XP   value   os   	   isDefault
D8.5_Platform   value   branch_to_test   	   isDefault
Use_Case   value   testing_type   
RC-5   value	   isDefault   drp_pass   
Wireless   value	   isDefault   network   
Ipv4   value	   isDefault   network_interface   	   isDefault

Canyon_MFP   value   program   	   isDefault
Isolated_Network   value   network_tested   

Copy&P12345678   
    summaryf       ctimev2?h       lastChangeTime4(g       mtime   numtestsv2?h       lastSessionUpdate   refreshable   group   
014256
013067   sessions
    description   lockedSET_D8.5/WFAST_System_DiagnosticGRS_General_Testing/Vendor_Diagnostic_dc330_Component_Control_Scan__Engine12345678
      locked
    description       sessions   refreshable   grouplf       mtime         numtests
    summaryu2?h       lastChangeTimef       ctimeSET_D8.5/WFAST_System_DiagnosticGRS_General_Testing/I18N_FT-29661_Translation_CWIS_Melody                    12345678   
MWFAST_Copy-Print.dir/Testcases.dir/FS_25.000_Copy_Sides_Imaged.dir/136943.bts   id
wired   network
1   exectimestaff
ie_5   browser   
    atm_step_notes
 
   atm_prlink
ipv6   network_interface         
    content
Problem Report Links   label
    raw
   atm_prlink   
Isolated Network   content
Network Tested   label
isolated_network   raw   network_tested   
    content
Print Driver Version   label
    raw
   driver_ver   
Product Name   label
Corrib   content
corrib   raw   product   <'mh       raw
Last Execution Time   labelJul 8, 2025, 7:42:12 PM IST   content   when   
Ipv6   content
Network Interface   label
ipv6   raw   network_interface   
What Operating System   label

Windows XP   content

windows_xp   raw   os   
    content
Problem Report IDs   label
    raw   atm_prid   
*<div class='text'>122.039.025.18310</div>
   content
Device Software Version   label
122.039.025.18310   raw   dvc_ver   
r7F7QV3J   raw
Run By   label
Thagaram Sathwika (External)   content   user   
Result   label
!<font color='#64bd1b'>pass</font>   content
pass   raw   results   
pass   raw
pass   content
Latest Execution Note   label   notetext   
1   raw
Actual Staff Time   label
1m   content   exectimestaff   
ie_5   raw
IE 5   content
What Browser?   label   browser   
wired   raw
Wired   content
What network connection?   label   network
   1751983932   atm_rundatahistory
$FB1D25A4-19C3-11EE-A1BE-1661CF8F79AB   atm_id
pass   results
r7F7QV3J   user
122.039.025.18310   dvc_ver
k<span class='result' user='r7F7QV3J' when='1751983932' clocktime='' stafftime='1' result='pass'>pass</span>   note   
pass   atm_step_results
k<span class='result' user='r7F7QV3J' when='1751983932' clocktime='' stafftime='1' result='pass'>pass</span>   notes
corrib   product
 
   driver_ver
isolated_network   network_tested

windows_xp   os
    atm_prid<'mh       when          `Ca2MV  \               a2MV  ]               b2MV  ^               pa2MV  _               Ba2MV  `               q2MV  a               q2MV  b               aq2MV  c                fq2MV  d               Fq2MV  e               dq2MV  f               @gq2MV  g               fq2MV  h               a2MV  i       ow ) {
            $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;
    }

    my $utc;
    if ($is_utc) {
        $utc = DateTime->new(
            year      => $p{year},
            month     => $p{month},
            day       => $p{day},
            hour      => $hour,
            minute    => $minute,
            second    => $second,
            time_zone => 'floating',
        );
    }
    else {
        my $local = DateTime->new(
            year      => $p{year},
            month     => $p{month},
         