protected function execute($arguments = array(), $options = array())
{
// initialize the database connection
$databaseManager = new sfDatabaseManager($this->configuration);
if ($options['all']) {
CommonTable::calculateTotals(true);
} else {
CommonTable::calculateTotals();
}
$this->logSection('siwapp', 'Calculated totals invoices');
}
/**
* Instanciate a TablePearRepo to manage pearrepo table
*
* @param object $db PDO instance of the DB connection
*/
function __construct($db)
{
parent::__construct($db, 'repo');
}
/**
* this checks if recalculation of totals and status is needed
* of the opened invoices
*
* @return void
**/
private function checkIfUpdateTotals()
{
// if the property is not set, we set it here
if (!PropertyTable::get('last_calculation_date')) {
PropertyTable::set('last_calculation_date', '1970-01-01');
}
$last = new sfDate(PropertyTable::get('last_calculation_date'));
$today = new sfDate();
if ($today->diff($last, sfTime::DAY) > 0) {
CommonTable::calculateTotals();
PropertyTable::set('last_calculation_date', $today->format('Y-m-d'));
}
}
