Ubercart

/**
* @file
* Defines a checkout pane that lets customers specify how they heard about
* your site (and so functions as a very basic lead tracker).
*
* This is a demo module showing people a simple way to add a checkout pane,
* save and load the data collected to orders, and display the collected data
* on the order view screen.  Presentation on the order screen is very basic,
* and there is currently no way to modify the data in this module.
*
* When you install this module, you should go to the Checkout panes settings
* page and add lead options to appear during checkout.
*
* Development sponsored by the Ubercart project: ">http://www.ubercart.org
*/

/*******************************************************************************
* Hook Functions (Ubercart)
******************************************************************************/

/**
* Implementation of hook_checkout_pane().
*/
function uc_deliveryspecs_checkout_pane() {
  $panes[] = array(
    'id' => 'deliveryspecs',
    'callback' => 'uc_checkout_pane_deliveryspecs',
    'title' => t('Delivery Specifics'),
    'desc' => t('Allows the customer to add delivery specifics.'),
    'weight' => 5,
  );

  return $panes;
}

/**
* Implementation of hook_order().
*/
function uc_deliveryspecs_order($op, &$arg1, $arg2) {
  switch ($op) {
    // Save the delivery data to the database.
    case 'save':
        db_query("UPDATE {uc_deliveryspecs} SET deliveryspecs_date = '%s', deliveryspecs_location = '%s', deliveryspecs_occasion = '%s', deliveryspecs_message = '%s'"
    ."WHERE order_id = %d", $arg1->deliveryspecs['date'], $arg1->deliveryspecs['location'], $arg1->deliveryspecs['occasion'], $arg1->deliveryspecs['message'], $arg1->order_id);
      if (db_affected_rows() == 0) {
      db_query("INSERT INTO {uc_deliveryspecs} (order_id, deliveryspecs_date, deliveryspecs_location, deliveryspecs_occasion, deliveryspecs_message) VALUES ( %d, '%s', '%s', '%s', '%s')", $arg1->order_id, $arg1->deliveryspecs['date'], $arg1->deliveryspecs['location'], $arg1->deliveryspecs['occasion'], $arg1->deliveryspecs['message']);
        }
      break;

    // Load the delivery data from the database.
    case 'load':
      $result = db_query("SELECT * FROM {uc_deliveryspecs} WHERE order_id = %d", $arg1->order_id);
      if ($data = db_fetch_object($result)) {
        $arg1->deliveryspecs['date'] = $data->deliveryspecs_date;
        $arg1->deliveryspecs['location'] = $data->deliveryspecs_location;
        $arg1->deliveryspecs['occasion'] = $data->deliveryspecs_occasion;
        $arg1->deliveryspecs['message'] = $data->deliveryspecs_message;
      }
      break;

    // Delete the delivery data from the database.
    case 'delete':
      db_query("DELETE FROM {uc_deliveryspecs} WHERE order_id = %d", $arg1->order_id);
      break;
  }
}

/**
* Implementation of hook_order_pane().
*/
function uc_deliveryspecs_order_pane() {
  $panes[] = array(
    'id' => 'deliveryspecs',
    'callback' => 'uc_order_pane_deliveryspecs',
    'title' => t('Delivery Specifics'),
    'desc' => t('Information about the customers delivery requests'),
    'class' => 'abs-left',
    'weight' => 4,
    'show' => array('view'),
  );

  return $panes;
}

/*******************************************************************************
* Callback Functions, Forms, and Tables
******************************************************************************/

function uc_checkout_pane_deliveryspecs($op, &$arg1, $arg2) {
  switch ($op) {
    case 'view':
      $description = t('Please fill out the information below to help us deliver your products.');
                            
      $contents['deliveryspecs_date'] = array(
        '#type' => 'textfield',
        '#title' => t('Delivery Date'),
        '#description' => t('Enter the date you would like the flowers delivered.'),
        '#required' => true,
      );
      $contents['deliveryspecs_location'] = array(
        '#type' => 'textfield',
        '#title' => t('Delivery Location'),
        '#description' => t('Please state the company name or location, such as Hospital, School, Hotel, Funeral Home, Church, etc.'),
      );
      $contents['deliveryspecs_occasion'] = array(
        '#type' => 'textfield',
        '#title' => t('Occasion'),
        '#description' => t('Please provide us with the occasion such as Anniversary, Christmas, Mothers day, Thank you, etc'),
      );
      $contents['deliveryspecs_message'] = array(
        '#type' => 'textarea',
        '#title' => t('Message'),
        '#description' => t('What message would you like RP Floral Design to relay with you flowers?'),
      );  
      return array('description' => $description, 'contents' => $contents);

      case 'process':
        $arg1->deliveryspecs['date'] = $arg2->deliveryspecs_date;
        $arg1->deliveryspecs['location'] = $arg2->deliveryspecs_location;
        $arg1->deliveryspecs['occasion'] = $arg2->deliveryspecs_occasion;
        $arg1->deliveryspecs['message'] = $arg2->deliveryspecs_message;
     return TRUE;

      case 'review':
        $review[] = array('title' => t('Delivery Date'), 'data' => $arg1->deliveryspecs['date']);
$review[] = array('title' => t('Delivery Location'), 'data' => $arg1->deliveryspecs['location']);
$review[] = array('title' => t('Occasion'), 'data' => $arg1->deliveryspecs['occasion']);
$review[] = array('title' => t('Message'), 'data' => $arg1->deliveryspecs['message']);  
      return $review;
  }
}

function uc_order_pane_deliveryspecs($op, $arg1) {
  switch ($op) {
    case 'view':
    $output =
'<table width="100%" cellpadding="5px" cellspacing="0">'.
'<tr><td>Delivery Date</td><td>'.$arg1->deliveryspecs['date'].'</td></tr>'.
'<tr><td>Delivery Location</td><td>'.$arg1->deliveryspecs['location'].'</td></tr>'.
'<tr><td>Occasion</td><td>'.$arg1->deliveryspecs['occasion'].'</td></tr>'.
'<tr><td>Message</td><td>'.$arg1->deliveryspecs['message'].'</td>'.
'</tr></table>';
      return $output;
  }
}

/**
* @file
* The theme system, which controls the output of Drupal.
*
* The theme system allows for nearly all output of the Drupal system to be
* customized by user themes.
*/

/**
* Implementation of hook_install().
*/
function uc_deliveryspecs_install() {
  // Create tables.
  drupal_install_schema('uc_deliveryspecs');
}
function uc_deliveryspecs_schema() {
  $schema['uc_deliveryspecs'] = array(
    'fields' => array(
      'deliveryspecs_id'    => array('type' => 'serial', 'size' => 'medium'),
      'order_id'    => array('type' => 'int', 'size' => 'medium', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
      'deliveryspecs_date' => array('type' => 'varchar', 'length' => 512, 'not null' => TRUE, 'default' => '0'),
      'deliveryspecs_location' => array('type' => 'varchar', 'length' => 512, 'not null' => TRUE, 'default' => '0'),
      'deliveryspecs_occasion' => array('type' => 'varchar', 'length' => 512, 'not null' => TRUE, 'default' => '0'),
      'deliveryspecs_message' => array('type' => 'varchar', 'length' => 2048, 'not null' => TRUE, 'default' => '0'),
    ),
    'indexes' => array(
      'order_id'    => array('order_id')
    ),
    'primary key' => array('deliveryspecs_id')
  );

  return $schema;
}

function uc_deliveryspecs_uninstall() {
  // Remove tables.
  drupal_uninstall_schema('uc_deliveryspecs');
  variable_del('uc_pane_deliveryspecs_enabled');
  variable_del('uc_pane_deliveryspecs_weight');
  variable_del('uc_order_pane_deliveryspecs_show_view');
  variable_del('uc_order_pane_deliveryspecs_weight_view');
}