Drupal: SCORM & HTML 5 course link on node page

Drupal7

This Drupal 7 CodeLet creates a link to the SCORM or HTML 5 course from the uploaded zip file. This associates an SCORM or HTML course to a node in Drupal.

CodeLet

<?php
/**
 * @file
 * Add a link to node page after a SCORM or HTML5 course has been uploaded
 *
 * @author DrupalD &lt;https://twitter.com/DrupalD>
*/

function course_link_menu() {
 $items = array();
 $items['admin/config/content/course-link'] = array(
 'type' => MENU_NORMAL_ITEM,
 'title' => t('Course Link'),
 'description' => t('Configure file upload fields for Course Link'),
 'page callback' => 'drupal_get_form',
 'page arguments' => array('course_link_admin_form'),
 'access arguments' => array('administer site configuration '),
 'file' => 'course_link_admin.inc',
 'file path' => drupal_get_path('module', 'course_link'),
 );
 
 return $items;
}

/**
* Implementation of hook_node_insert
*
* @param object $node
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function course_link_node_insert($node) {
 $file_upload_fields = array();
 $file_field = array();
 $file_upload_fields = variable_get('course_link_field');
 //Default public directory path to extract zip files to
 $destination = _file_directory_path();
 if (!empty($file_upload_fields)) {
 foreach($file_upload_fields as $key => $value) {
 $file_field_info = field_info_field_by_id($value);
 $file_field = array($file_field_info['field_name'] => $file_field_info['field_name']);
 }
 }

 if (!empty($file_field)) {
 foreach ($file_field as $key => $value) {
 //Get the correct field that is associated with existing node and exit the loop
 if (array_key_exists($key, (array) $node)) {
 $node_file_field = $key;
 break;
 }
 }
 // Check if the node has one of those file fields. If it does, get the URI of the uploaded file.
 $file_uri = _file_get_location($node->$node_file_field['und'][0]['fid']);
 if (!empty($file_uri)) {
 // Insert data in course_link_node_file to retrieve it on node page
 $data = array(
 'nid' => $node->nid,
 'fid' => $node->$node_file_field['und'][0]['fid'],
 );
 drupal_write_record('course_link_node_file', $data);
 
 //Unzip the file
 $zip = new ZipArchive();
 if ($zip->open($destination . basename($file_uri['uri'], '.zip') . '.zip') === TRUE) {
 $zip->extractTo($destination . basename($file_uri['uri'], '.zip'));
 $zip->close();
 }
 else {
 drupal_set_message(t('Unable to open zip file'), 'error');
 }
 }
 }
}

/**
* Implemenation of hook_node_view
*
* @param object $node
* @param string $view_mode
* @param string $langcode
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function course_link_node_view($node, $view_mode, $langcode) {
 $file_fid = array();
 $file_filename = array();

 //Get the fid from course_link_node_file table
 $file_fid = db_select('course_link_node_file', 'cl')
 ->fields('cl', array('fid'))
 ->condition('nid', $node->nid, '=')
 ->execute()
 ->fetchAssoc();

 //Get the filename using the FID
 $file_filename = _file_get_location($file_fid['fid']);
 $course_directory = basename($file_filename['uri'], '.zip');
 $file_directory = _file_directory_path();
 $course_link_index_directory = scandir($file_directory . $course_directory);
 $course_link_index_file = array_search('index.html', $course_link_index_directory) ? '/index.html' : '/res/index.html';
 //Add the link to node page
 $course_link = l(t('Course Link'), $file_directory . $course_directory . $course_link_index_file, array('attributes' => array('target' => '_blank')));
 $node->content['course_link'] = array(
 '#markup' => $course_link,
 );
}

/**
* _file_get_location
* Get the location of the uploaded zip file
*
* @param int $fid: Id of the file
* @param bool $uri: Whether to fetch uri or not
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function _file_get_location($fid) {
 //Get the URI of the uploaded file using the FID
 $result = db_select('file_managed', 'fm')
 ->fields('fm', array('uri'))
 ->condition('fid', $fid, '=')
 ->execute()
 ->fetchAssoc();
 return $result;
}

/**
* _file_directory_path
*
* Path to files directory
*
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function _file_directory_path() {
 return variable_get('file_public_path', conf_path() . '/files/');
}
?>

course_link_admin.inc

<?php
/**
* @file
* 
* Admin configuration form for course link
* 
* @author DrupalD &lt;https://twitter.com/DrupalD>
*
*/

/**
* course_link_admin_form
*
* Admin configuration for course link
*
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function course_link_admin_form() {
 $form= array();
 $course_link_field = array();
 $course_link_field =variable_get('course_link_field');
 $course_field_values = _course_link_get_upload_field();
 
 $form['course_link_field'] = array(
 '#type' => 'select',
 '#title' => t('File upload fields'),
 '#description' => t('Select one or more file upload field to be processed by Course Link'),
 '#multiple' => TRUE,
 '#size' => 5,
 '#options' => $course_field_values,
 '#default_value' => $course_link_field,
 );
 return system_settings_form($form);
}


/**
* _course_link_get_upload_field
*
* Helper function to get a list of all the file field which allows zip upload
*
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function _course_link_get_upload_field() {
 $file_upload_fields = array();
 $file_field = array();
 $file_upload = array();
 $file_upload_fields = field_info_fields();
 foreach ($file_upload_fields as $file_field) {
 if ($file_field['type'] == 'file') {
 $file_upload['Course fields'] = array($file_field['id'] => $file_field['field_name']);
 }
 }
 return $file_upload;
}
?>

Info file details

name = Course Link
description = Add a course link to node after a SCORM or HTML5 course has been uploaded. Developed by &lt;a href="http://jos.cx/jcs" target='_blank'&gt;JCS&lt;/a&gt;
dependencies[] = file
configure = admin/config/content/course-link
core = 7.x
package = Course

Install file details

<?php
>

/**
 *
 * @file
 *
 * Schema for storing node and file association details
 *
 * @author DrupalD &lt;https://twitter.com/DrupalD>
 *
*/

/**
* Implementation of hook_schema
*
* @author DrupalD &lt;https://twitter.com/DrupalD>
*/
function course_link_schema() {
 $schema = array();
 $schema['course_link_node_file'] = array(
 'description' => t('Store node and uploaded zip file association details'),
 'fields' => array(
 'id' => array(
 'type' => 'serial',
 'length' => 11,
 'not null' => TRUE,
 ),
 
 'nid' => array(
 'type' => 'int',
 'length' => 11,
 'not null' => TRUE,
 ),
 
 'fid' => array(
 'type' => 'int',
 'length' => 11,
 'not null' => TRUE,
 ),
 ),
 'primary key' => array('id'),
 );
 return $schema;
}
?>

Drupal

Drupal 7