You are here

class BotchaRecipebookModel in BOTCHA Spam Prevention 7.3

Same name and namespace in other branches
  1. 6.2 model/botcha_recipebook.model.inc \BotchaRecipebookModel
  2. 6.3 model/recipebook/botcha.recipebook.model.inc \BotchaRecipebookModel
  3. 7.2 model/botcha_recipebook.model.inc \BotchaRecipebookModel

Hierarchy

Expanded class hierarchy of BotchaRecipebookModel

File

model/recipebook/botcha.recipebook.model.inc, line 17
Contains BotchaRecipebookModel class.

View source
class BotchaRecipebookModel extends Model implements IBotchaRecipebookModel {
  protected $rtlns = array(
    BotchaModel::RELATION_FORM_RECIPEBOOK,
    BotchaModel::RELATION_RECIPE_RECIPEBOOK,
  );
  public function getRecipebooks($parameters = array()) {
    $recipebooks = db_select('botcha_recipebook', 'brb')
      ->fields('brb');
    if (!empty($parameters['recipebooks'])) {
      foreach ((array) $parameters['recipebooks'] as $rbid) {
        $recipebooks
          ->condition('id', $rbid, 'IN');
      }
    }

    // Catching of PDOException helps to avoid WSOD during update use case. The
    // reason is in that form_alter is called before performing an update.
    // @see http://drupal.org/node/1828710
    try {
      $result = $recipebooks
        ->execute()
        ->fetchAllAssoc('id');
    } catch (Exception $e) {
      if ($e instanceof PDOException) {
        watchdog_exception('BOTCHA', $e, 'Please perform an update via update.php or reinstall the BOTCHA module to fix the reason of this warning! %type: !message in %function (line %line of %file).', array(), WATCHDOG_WARNING);
        $result = array();
      }
    }
    return $result;
  }
  public function getRecipebook($id = 'default') {
    $recipebooks = $this
      ->getRecipebooks();
    return !empty($recipebooks[$id]) ? $recipebooks[$id] : NULL;
  }

  /**
   * Save recipe book to the database.
   * @param BotchaRecipebook $recipebook
   */
  public function save($recipebook) {

    // Catching of PDOException helps to avoid WSOD during update use case. The
    // reason is in that form_alter is called before performing an update.
    // @see http://drupal.org/node/1828710
    try {
      db_delete('botcha_recipebook_recipe')
        ->condition('rbid', $recipebook->id)
        ->execute();
      db_delete('botcha_recipebook_form')
        ->condition('rbid', $recipebook->id)
        ->execute();
      if (!$recipebook instanceof BotchaRecipebookNone) {
        db_merge('botcha_recipebook')
          ->key(array(
          'id' => $recipebook->id,
        ))
          ->fields(array(
          'title' => $recipebook->title,
          'description' => $recipebook->description,
        ))
          ->execute();

        // Save relationships between recipe book and recipes to DB.
        $recipe_ids = $recipebook
          ->getRecipes();
        foreach ($recipe_ids as $recipe_id) {
          db_insert('botcha_recipebook_recipe')
            ->fields(array(
            'rbid' => $recipebook->id,
            'recipe_id' => $recipe_id,
          ))
            ->execute();
        }

        // Save relationships between recipe book and forms to DB.
        $form_ids = $recipebook
          ->getForms();
        foreach ($form_ids as $form_id) {
          $brf = db_select('botcha_recipebook_form', 'brf')
            ->fields('brf', array(
            'rbid',
          ))
            ->condition('form_id', $form_id)
            ->execute()
            ->fetchCol();
          if (count($brf)) {
            $query = db_update('botcha_recipebook_form')
              ->condition('form_id', $form_id)
              ->fields(array(
              'rbid' => $recipebook->id,
            ));
          }
          else {
            $query = db_insert('botcha_recipebook_form')
              ->fields(array(
              'form_id' => $form_id,
              'rbid' => $recipebook->id,
            ));
          }
          $query
            ->execute();

          // Strange but true: db_merge does not work here, fails with integrity constraint violation.

          /*
                    $query->key(array('form_id', 'rbid'), array($form->id, $recipebook->id))
           ->execute();
          *
          */
        }
      }
    } catch (Exception $e) {
      if ($e instanceof PDOException) {
        watchdog_exception('BOTCHA', $e, 'Please perform an update via update.php or reinstall the BOTCHA module to fix the reason of this warning! %type: !message in %function (line %line of %file).', array(), WATCHDOG_WARNING);
      }
    }
  }

  /**
   * Delete recipe book from the database.
   * @param BotchaRecipebook $recipebook
   */
  public function delete($recipebook) {

    // Catching of PDOException helps to avoid WSOD during update use case. The
    // reason is in that form_alter is called before performing an update.
    // @see http://drupal.org/node/1828710
    try {
      db_delete('botcha_recipebook_recipe')
        ->condition('rbid', $recipebook->id)
        ->execute();
      db_delete('botcha_recipebook_form')
        ->condition('rbid', $recipebook->id)
        ->execute();
      db_delete('botcha_recipebook')
        ->condition('id', $recipebook->id)
        ->execute();
    } catch (Exception $e) {
      if ($e instanceof PDOException) {
        watchdog_exception('BOTCHA', $e, 'Please perform an update via update.php or reinstall the BOTCHA module to fix the reason of this warning! %type: !message in %function (line %line of %file).', array(), WATCHDOG_WARNING);
      }
    }
  }

}

Members