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'); }