~bentokitdevs/retromod/playout

« back to all changes in this revision

Viewing changes to src/private/components/playout/scripts/playout/Client/Novation.pm

  • Committer: ken
  • Date: 2011-09-19 07:15:07 UTC
  • Revision ID: svn-v4:8010c1e9-5c09-0410-80af-c3f6856d18d6:branches/playout:2164
Widened range for SEQ files for 7 days in the past, so that backlog files can be viewed in the studio. 

Show diffs side-by-side

added added

removed removed

Lines of Context:
254
254
                        `$self->{trafficStore}->{table_traffic_contract}` O,
255
255
                        `$self->{trafficStore}->{table_traffic_campaign}` M
256
256
                )
257
 
                WHERE (S.$self->{trafficStore}->{field_spot_dateTime} >= TIMESTAMP(NOW() - INTERVAL 2 HOUR)
 
257
                WHERE (S.$self->{trafficStore}->{field_spot_dateTime} >= TIMESTAMP(NOW() - INTERVAL 168 HOUR)
258
258
                        && S.$self->{trafficStore}->{field_spot_dateTime} < TIMESTAMP(NOW() + INTERVAL 4 DAY)
259
259
                )
260
260
                AND (O.$self->{trafficStore}->{field_contract_contractStatus} = 'Approved'