public function delete()
{
$db = Database::connection();
$params = array($this->bID);
$query = "DELETE FROM btTextListEntries WHERE bID = ?";
$db->query($query, $params);
parent::delete();
}
public function delete()
{
$arLayout = $this->getAreaLayoutObject();
if (is_object($arLayout)) {
$arLayout->delete();
}
parent::delete();
}
public function delete()
{
$db = Database::connection();
$v = array($this->bID);
$q = "DELETE FROM btSurveyOptions WHERE bID = ?";
$db->query($q, $v);
$q = "DELETE FROM btSurveyResults WHERE bID = ?";
$db->query($q, $v);
parent::delete();
}
function delete()
{
$db = Loader::db();
$v = array($this->bID);
$q = "DELETE FROM btSurveyOptions WHERE bID = ?";
$db->query($q, $v);
$q = "DELETE FROM btSurveyResults WHERE bID = ?";
$db->query($q, $v);
return parent::delete();
}
public function delete()
{
parent::delete();
$entity = $this->getFormEntity()->getEntity();
$entityManager = \Core::make('database/orm')->entityManager();
// Important – are other blocks in the system using this form? If so, we don't want to delete it!
$db = $entityManager->getConnection();
$r = $db->fetchColumn('select count(bID) from btExpressForm where bID <> ? and exFormID = ?', [$this->bID, $this->exFormID]);
if ($r == 0) {
$entityManager->remove($entity);
$entityManager->flush();
}
}
public function delete()
{
$db = Loader::db();
$db->delete('btImageSliderEntries', array('bID' => $this->bID));
parent::delete();
}
public function delete()
{
parent::delete();
if ($this->gaID) {
$gathering = Gathering::getByID($this->gaID);
if (is_object($gathering)) {
$gathering->delete();
}
}
}
public function delete()
{
$db = Database::connection();
$db->execute('DELETE from btFaqEntries WHERE bID = ?', array($this->bID));
parent::delete();
}
/**
* Make sure to delete all files associated w/ the block record in secondary table.
* @return void
*/
public function delete()
{
Loader::db()->Execute("DELETE FROM {$this->btTableSecondary} WHERE bID = ?", array($this->bID));
return parent::delete();
}
public function delete()
{
$db = Database::connection();
$deleteData['questionsIDs'] = [];
$deleteData['strandedAnswerSetIDs'] = [];
$miniSurvey = new MiniSurvey();
$info = $miniSurvey->getMiniSurveyBlockInfo($this->bID);
//get all answer sets
$q = "SELECT asID FROM {$this->btAnswerSetTablename} WHERE questionSetId = " . intval($info['questionSetId']);
$answerSetsRS = $db->query($q);
//delete the questions
$deleteData['questionsIDs'] = $db->getAll("SELECT qID FROM {$this->btQuestionsTablename} WHERE questionSetId = " . intval($info['questionSetId']) . ' AND bID=' . intval($this->bID));
foreach ($deleteData['questionsIDs'] as $questionData) {
$db->query("DELETE FROM {$this->btQuestionsTablename} WHERE qID=" . intval($questionData['qID']));
}
//delete left over answers
$strandedAnswerIDs = $db->getAll('SELECT fa.aID FROM `btFormAnswers` AS fa LEFT JOIN btFormQuestions as fq ON fq.msqID=fa.msqID WHERE fq.msqID IS NULL');
foreach ($strandedAnswerIDs as $strandedAnswer) {
$db->query('DELETE FROM `btFormAnswers` WHERE aID=' . intval($strandedAnswer['aID']));
}
//delete the left over answer sets
$deleteData['strandedAnswerSetIDs'] = $db->getAll('SELECT aset.asID FROM btFormAnswerSet AS aset LEFT JOIN btFormAnswers AS fa ON aset.asID=fa.asID WHERE fa.asID IS NULL');
foreach ($deleteData['strandedAnswerSetIDs'] as $strandedAnswerSetIDs) {
$db->query('DELETE FROM btFormAnswerSet WHERE asID=' . intval($strandedAnswerSetIDs['asID']));
}
//delete the form block
$q = "delete from {$this->btTable} where bID = '{$this->bID}'";
$r = $db->query($q);
parent::delete();
return $deleteData;
}
public function delete()
{
$db = Loader::db();
$db->delete('btFundamentalSlickSlide', array('bID' => $this->bID));
parent::delete();
}
public function delete()
{
Application::getFacadeApplication()->make('statistics/tracker')->forget($this);
parent::delete();
}
public function delete()
{
$db = Loader::db();
$db->execute('DELETE from btFaqEntriesWHERE bID = ?', array($this->bID));
parent::delete();
}
public function delete()
{
$db = Loader::db();
$db->delete('btVividCarouselItem', array('bID' => $this->bID));
parent::delete();
}
/**
* On delete update the tracker.
*/
public function delete()
{
$this->tracker->forget($this);
parent::delete();
}
public function delete()
{
$db = Database::getActiveConnection();
$db->delete('btManualNavEntries', array('bID' => $this->bID));
parent::delete();
}
public function delete()
{
$db = Database::get();
$db->delete('btImageSliderEntries', array('bID' => $this->bID));
parent::delete();
$this->tracker->forget($this);
}
public function delete()
{
$db = Loader::db();
$db->delete('btVividSimpleAccordionItem', array('bID' => $this->bID));
parent::delete();
}