/**
* Loads the datagrid with the unsent mailings
*/
private function loadDataGridSentMailings()
{
// set query & parameters
$query = BackendMailmotorModel::QRY_DATAGRID_BROWSE_SENT;
$parameters = array('sent');
// campaign is set
if (!empty($this->campaign)) {
// reset query, add to parameters
$query = BackendMailmotorModel::QRY_DATAGRID_BROWSE_SENT_FOR_CAMPAIGN;
$parameters[] = $this->campaign['id'];
}
// create datagrid
$this->dgSentMailings = new BackendDataGridDB($query, $parameters);
$this->dgSentMailings->setColumnsHidden(array('campaign_id', 'status'));
// if a campaign is set, hide the campaign name in the datagrid
if (!empty($this->campaign)) {
$this->dgSentMailings->setColumnHidden('campaign_name');
}
// sorting columns
$this->dgSentMailings->setSortingColumns(array('name', 'campaign_name', 'sent', 'language'), 'sent');
$this->dgSentMailings->setSortParameter('desc');
// add the multicheckbox column
$this->dgSentMailings->addColumn('checkbox', '<span class="checkboxHolder"><input type="checkbox" name="toggleChecks" value="toggleChecks" /></span>', '<span><input type="checkbox" name="id[]" value="[id]" class="inputCheckbox" /></span>');
$this->dgSentMailings->setColumnsSequence('checkbox');
// add mass action dropdown
$ddmMassAction = new \SpoonFormDropdown('action', array('delete' => BL::lbl('Delete')), 'delete');
$this->dgSentMailings->setMassAction($ddmMassAction);
// set column functions
$this->dgSentMailings->setColumnFunction(array(__CLASS__, 'setCampaignLink'), array('[campaign_id]', '[campaign_name]'), 'campaign_name', true);
$this->dgSentMailings->setColumnFunction(array(new BackendDataGridFunctions(), 'getTimeAgo'), array('[sent]'), 'sent', true);
// check if this action is allowed
if (BackendAuthentication::isAllowedAction('Copy')) {
$this->dgSentMailings->addColumnAction('copy', null, BL::lbl('Copy'), BackendModel::createURLForAction('Copy') . '&id=[id]', BL::lbl('Copy'), array('class' => 'button icon iconMailAdd linkButton'));
}
// check if this action is allowed
if (BackendAuthentication::isAllowedAction('EditMailingCampaign')) {
$this->dgSentMailings->addColumnAction('edit_mailing_campaign', null, BL::lbl('Edit'), BackendModel::createURLForAction('EditMailingCampaign') . '&id=[id]', BL::lbl('EditMailingCampaign'), array('class' => 'button icon iconFolderEdit linkButton'));
}
// check if this action is allowed
if (BackendAuthentication::isAllowedAction('Statistics')) {
$this->dgSentMailings->addColumnAction('statistics', null, BL::lbl('Statistics'), BackendModel::createURLForAction('Statistics') . '&id=[id]', BL::lbl('Statistics'), array('class' => 'button icon iconStats linkButton'));
}
// add styles
$this->dgUnsentMailings->setColumnAttributes('name', array('class' => 'title'));
// set paging limit
$this->dgSentMailings->setPagingLimit(self::SENT_MAILINGS_PAGING_LIMIT);
}
