protected function execute($arguments = array(), $options = array())
{
// initialize the database connection
$databaseManager = new sfDatabaseManager($this->configuration);
$connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection();
echo "Running sfReviewStatsTask ... \n";
$query = "SELECT r.entity_id, r.sf_review_type_id, r.value, SUM(r.value) sum " . "FROM %s r " . "INNER JOIN %s s ON s.id = r.sf_review_status_id " . "WHERE r.is_active = 1 " . "AND r.sf_review_type_id is not null " . "group by entity_id, sf_review_type_id, value ";
$query = sprintf($query, SfReviewPeer::TABLE_NAME, SfReviewStatusPeer::TABLE_NAME);
$connection = Propel::getConnection();
$statement = $connection->prepare($query);
//$statement->bindValue(1, 0);
$statement->execute();
while ($row = $statement->fetch()) {
$isNew = false;
$yesterday = strtotime("yesterday");
$sfReviewTypeEntity = SfReviewTypeEntityPeer::retrieveByPK($row['sf_review_type_id'], $row['entity_id'], $yesterday, $row['value']);
if (!$sfReviewTypeEntity) {
$isNew = true;
$sfReviewTypeEntity = new SfReviewTypeEntity();
$sfReviewTypeEntity->setSfReviewTypeId($row['sf_review_type_id']);
$sfReviewTypeEntity->setEntityId($row['entity_id']);
$sfReviewTypeEntity->setValue($row['value']);
$sfReviewTypeEntity->setDate($yesterday);
$sfReviewTypeEntity->setSum($row['sum']);
SfReviewTypeEntityPeer::doInsert($sfReviewTypeEntity);
}
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aSfReviewType !== null) {
if ($this->aSfReviewType->isModified() || $this->aSfReviewType->isNew()) {
$affectedRows += $this->aSfReviewType->save($con);
}
$this->setSfReviewType($this->aSfReviewType);
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = SfReviewTypeEntityPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setNew(false);
} else {
$affectedRows += SfReviewTypeEntityPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
