You are here

class StorageHelper in Menus attribute 8

Helper Class for database interaction.

Hierarchy

Expanded class hierarchy of StorageHelper

2 files declare their use of StorageHelper
menus_attribute.module in ./menus_attribute.module
Provides alters for menus_attribute.
TwigExtension.php in src/Template/TwigExtension.php

File

src/StorageHelper.php, line 10

Namespace

Drupal\menus_attribute
View source
class StorageHelper {
  public $db;

  /**
   * Function to create object of storage helper class.
   */
  public static function instance() {
    static $inst = NULL;
    if ($inst === NULL) {
      $inst = new StorageHelper();
    }
    return $inst;
  }

  /**
   * Constructor of storage helper class.
   */
  public function __construct() {
    $this->db = Database::getConnection();
  }

  /**
   * Function to getData.
   */
  public function getData($plugin_id) {
    $data = $this->db
      ->select('menus_attribute', 'ma')
      ->fields('ma')
      ->condition('plugin_id', $plugin_id, '=')
      ->execute()
      ->fetchObject();
    return $data;
  }

  /**
   * Function to check existence of a menu in our table.
   */
  public function exists($plugin_id) {
    $data = $this->db
      ->select('menus_attribute', 'ma')
      ->fields('ma')
      ->condition('plugin_id', $plugin_id, '=')
      ->execute()
      ->fetchField();
    return (bool) $data;
  }

  /**
   * Function to add data.
   */
  public function add(&$arr, $plugin_id) {
    $query = $this->db
      ->insert('menus_attribute');
    $query
      ->fields([
      'plugin_id' => $plugin_id,
      'link_id' => $arr['menu_link_id'],
      'link_name' => $arr['menu_link_name'],
      'link_title' => $arr['menu_link_title'],
      'link_rel' => $arr['menu_link_rel'],
      'link_classes' => $arr['menu_link_class'],
      'link_style' => $arr['menu_link_style'],
      'link_target' => $arr['menu_link_target'],
      'link_accesskey' => $arr['menu_link_access_key'],
      'item_id' => $arr['menu_item_id'],
      'item_classes' => $arr['menu_item_class'],
      'item_style' => $arr['menu_item_style'],
    ])
      ->execute();
  }

  /**
   * Function to update data.
   */
  public function update(&$arr, $plugin_id) {
    $query = $this->db
      ->update('menus_attribute');
    $query
      ->fields([
      'plugin_id' => $plugin_id,
      'link_id' => $arr['menu_link_id'],
      'link_name' => $arr['menu_link_name'],
      'link_title' => $arr['menu_link_title'],
      'link_rel' => $arr['menu_link_rel'],
      'link_classes' => $arr['menu_link_class'],
      'link_style' => $arr['menu_link_style'],
      'link_target' => $arr['menu_link_target'],
      'link_accesskey' => $arr['menu_link_access_key'],
      'item_id' => $arr['menu_item_id'],
      'item_classes' => $arr['menu_item_class'],
      'item_style' => $arr['menu_item_style'],
    ]);
    $query
      ->condition('plugin_id', $plugin_id);
    $query
      ->execute();
  }

}

Members

Namesort descending Modifiers Type Description Overrides
StorageHelper::$db public property
StorageHelper::add public function Function to add data.
StorageHelper::exists public function Function to check existence of a menu in our table.
StorageHelper::getData public function Function to getData.
StorageHelper::instance public static function Function to create object of storage helper class.
StorageHelper::update public function Function to update data.
StorageHelper::__construct public function Constructor of storage helper class.