function uninstall()
{
$query = new DB_Table_Delete(Newsletter::getTables());
}
function initQuery($params)
{
$tables = Newsletter::getTables();
$nl = $tables['newsletter_letters']['columns'];
$this->deleteMultiLangField($nl['letter_subject'], $nl['letter_id'], 'Newsletter');
$this->deleteMultiLangField($nl['letter_from_name'], $nl['letter_id'], 'Newsletter');
$this->deleteMultiLangField($nl['letter_from_email'], $nl['letter_id'], 'Newsletter');
$this->deleteMultiLangField($nl['letter_html'], $nl['letter_id'], 'Newsletter');
// $this -> deleteMultiLangField($nl['letter_text'], $nl['letter_id'], 'Newsletter');
$this->Where($nl['letter_id'], DB_IN, $this->arrayToIn($params['ids']));
}
function initQuery($params)
{
$tables = Subscriptions::getTables();
$ntables = Newsletter::getTables();
$tcolumns = $tables['subscription_topic']['columns'];
$ecolumns = $tables['subscription_email']['columns'];
$lcolumns = $ntables['newsletter_topics']['columns'];
$this->addSelectField($lcolumns['letter_id']);
$this->addSelectField($lcolumns['topic_id']);
$this->addInnerJoin('subscription_topic', $lcolumns['topic_id'], DB_EQ, $tcolumns['topic_id']);
$this->setMultiLangAlias('_ml_name', 'subscription_topic', $tcolumns['topic_name'], $tcolumns['topic_id'], 'Subscriptions');
$this->addSelectValue($this->getMultiLangAlias('_ml_name'), 'topic_name');
$this->addSelectField($this->fCount($ecolumns['email_id']), 'topic_emails');
$this->addLeftJoin('subscription_email', $ecolumns['topic_id'], DB_EQ, $tcolumns['topic_id']);
$this->Where($lcolumns['letter_id'], DB_IN, $this->arrayToIn($params['letters_ids']));
$this->SelectGroup($tcolumns['topic_id']);
$this->SelectOrder($tcolumns['sort_order'], 'ASC');
}
