unccd_event_map.install

<?php

use Drupal\Core\Database\Database;

/**
 * @file
 * Install, update and uninstall functions for the unccd_event_map module.
 */

/**
 * Implements hook_install().
 *
 * Creates a default entry on this module custom table.
 *
 * @ingroup unccd_event_map
 */
function unccd_event_map_install() {
    $database = \Drupal::database();
    // Add a default entry.
    $fields = [
      'title' => 'Celebration of the World Day to Combat Desertification',
      'organisation' => 'Desert Research Center',
      'email' => 'vmetelitsa@unccd.int',
      'url' => '',
      'city' => 'Mataria',
      'country' => 'Egypt',
      'date' => '2018-06-17',
      'description' => 'Desert Research Center plans to celebrate the World Day at the end of June after the feast of Aid El-Fitr. The details of the observance activities are being finalized.',
      'latitude' => 30.1312,
      'longitude' => 31.3103,
      'approved' => 1,
    ];
    $database
      ->insert('unccd_event_map')
      ->fields($fields)
      ->execute();
}

/**
 * Implements hook_schema().
 *
 * Defines the database tables used by this module.
 *
 * @see hook_schema()
 *
 * @ingroup unccd_event_map
 */
function unccd_event_map_schema() {
    $schema['unccd_event_map'] = [
        'description' => 'Stores events for the event map',
        'fields' => [
            'id' => [
                'type' => 'serial',
                'not null' => TRUE,
                'description' => 'Primary Key: Unique event ID.',
            ],
            'title' => [
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'default' => '',
                'description' => 'Title of the event',
            ],
            'organisation' => [
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'default' => '',
                'description' => 'Organisation running the event',
            ],
            'organisation_url' => [
                'type' => 'varchar',
                'length' => 255,
                'description' => 'URL of the event organizer(s)',
            ],
            'url' => [
                'type' => 'varchar',
                'length' => 255,
                'default' => '',
                'description' => 'URL of the event on an external website',
            ],
            'email' => [
                'type' => 'varchar',
                'length' => 255,
                'default' => '',
                'description' => 'Email of the contact person',
            ],
            'city' => [
                'type' => 'varchar',
                'length' => 255,
                'description' => 'City where the event takes place.',
            ],
            'country' => [
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'description' => 'Country where the event takes place.',
            ],
            'date' => [
                'type' => 'datetime',
                'mysql_type' => 'datetime',
                'pgsql_type' => 'timestamp without time zone',
                'sqlite_type' => 'varchar',
                'sqlsrv_type' => 'smalldatetime',
                'not null' => TRUE,
                'description' => 'Date the event takes place on.',
            ],
            'description' => [
                'type' => 'text',
                'not null' => TRUE,
                'description' => 'Description of the event',
            ],
            'latitude' => [
                'type' => 'float',
                'not_null' => TRUE,
                'description' => 'The latitude of the location of the event (for map display)'
            ],
            'longitude' => [
                'type' => 'float',
                'not_null' => TRUE,
                'description' => 'The longitude of the location of the event (for map display)'
            ],
            'approved' => [
                'type' => 'int',
                'size' => 'tiny',
                'not_null' => TRUE,
                'default' => 0,
                'description' => 'Has the event been approved'
            ],
            'image_id' => [
                'type' => 'int',
                'description' => 'The drupal file id for the uploaded image (needed to delete image when event is deleted)'
            ],
            'image' => [
                'type' => 'varchar',
                'length' => 255,
                'description' => 'Image for the event'
            ],
            'attachment_type' => [
                'type' => 'varchar',
                'length' => 255,
                'default' => 'Event Flyer',
                'description' => 'The type of PDF attached (report, flyer, etc)'
            ],
            'pdf_id' => [
                'type' => 'int',
                'description' => 'The drupal file id for the uploaded PDF (needed to delete PDF when event is deleted)'
            ],
            'pdf' => [
                'type' => 'varchar',
                'length' => 255,
                'description' => 'PDF for the event'
            ],
        ],
        'primary key' => ['id'],
        'indexes' => [
            'title' => ['title'],
            'country' => ['country'],
        ],
  ];

  return $schema;
}

/**
 * Adds the column for PDF upload and organisation url
 */
function unccd_event_map_update_8001(&$sandbox) {
    $pdf_id_spec = [
        'type' => 'int',
        'description' => 'The drupal file id for the uploaded PDF (needed to delete PDF when event is deleted)'
    ];
    $pdf_spec = [
        'type' => 'varchar',
        'length' => 255,
        'description' => 'PDF for the event'
    ];
    $organisation_url_spec = [
        'type' => 'varchar',
        'length' => 255,
        'description' => 'URL of the event organizer(s)',
    ];

    $schema = Database::getConnection()->schema();
    $schema->addField('unccd_event_map', 'pdf_id', $pdf_id_spec);
    $schema->addField('unccd_event_map', 'pdf', $pdf_spec);
    $schema->addField('unccd_event_map', 'organisation_url', $organisation_url_spec);
}

/**
 * Adds the column for attachment types
 */
function unccd_event_map_update_8002(&$sandbox) {
    $attachment_type_spec = [
        'type' => 'varchar',
        'length' => 255,
        'default' => 'Event Flyer',
        'description' => 'The type of PDF attached (report, flyer, etc)'
    ];

    $schema = Database::getConnection()->schema();
    $schema->addField('unccd_event_map', 'attachment_type', $attachment_type_spec);
}