package BookPub::DB::Item::AggSaleLog;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::Assert;
use Common::Log;
use Common::RSApp;

use Common::DB::Item;
use base 'Common::DB::Item';

use constant kTable => 'agg_sale_log';
use constant kDB    => Common::DB::Item::kClientDB;

sub GetLastDates {
    my ($class) = @_;

    my $sql = "SELECT MAX(date_finished) AS last_checked,
                      MAX(CASE WHEN tables_rebuilt = 1 THEN date_finished END) AS last_refreshed
               FROM " . kTable;

    Common::Log::Debug("QUERY: $sql");

    my $dbo = Common::RSApp::GetClientDB();
    my $sth = $dbo->DBH()->prepare($sql);
    $sth->execute();

    my $row = $sth->fetchrow_hashref();
    return {
        last_checked   => $row->{last_checked}   || '',
        last_refreshed => $row->{last_refreshed} || '',
    };
}

1;