public function getFailedMessagesCount($start = false, $end = false)
{
$record = new Postmaster_TransportResponseRecord();
$query = craft()->db->createCommand()->select('count(id) count')->from($record->getTableName())->andWhere('success = 0');
if ($start) {
$query->andWhere('dateCreated >= :date', array('date' => $start));
}
if ($end) {
$query->andWhere('dateCreated <= :date', array('date' => $end));
}
$data = $query->queryRow();
return (int) $data['count'];
}
public function delete($id)
{
if ($record = Postmaster_TransportResponseRecord::model()->findById($id)) {
return $record->delete();
}
return false;
}
public function safeUp()
{
$table = new Postmaster_TransportResponseRecord();
$this->addColumnAfter($table->getTableName(), 'code', ColumnType::Text, 'success');
foreach (Postmaster_TransportResponseRecord::model()->findAll() as $row) {
if (!isset($row->model['service']['__class__'])) {
$obj = craft()->postmaster->getRegisteredService($row->model['service']['id']);
$model = $row->model;
$service = $model['service'];
$service['__class__'] = $obj->__class__;
$model['service'] = $service;
$row->model = $model;
$row->save();
}
}
return true;
}