<?php
// $Id: eticket.module,v 1.1.1.1 2007/01/31 16:40:20 drazzig Exp $

/********************************************************************
 * Drupal Hooks
 ********************************************************************/

/**
 * Implementation of hook_help()
 */
function eticket_help($section = 'admin/help#eticket') {
  switch ($section) {
    case 'admin/modules#description':
      return t('<b>EC:</b> Creates an E-ticket product. Dependencies: product.module/cart.module');
    case 'node/add/product#eticket':
      return t('Sell E-tickets on site. When user checks out, details for each are entered and saved to database');
  }
}

/**
 * Implementation of hook_perm().
 */
function eticket_perm() {
  return array('create E-ticket products', 'edit own E-ticket products');
}

/**
 * Implementation of hook_access().
 */
function eticket_access($op, $node) {
  global $user;

  if ($op == 'create') {
    return user_access('create E-ticket products');
  }

  if ($op == 'update' || $op == 'delete') {
    if (user_access('edit own E-ticket products') && ($user->uid == $node->uid)) {
      return TRUE;
    }
  }
}

/**
 * implementation of hook_settings()
 */
function eticket_ec_settings() {
  
  $form['eticket'] = array('#value' => '<p><a href="?q=guestlist">View Guestlist</a></p>');     
  
  return $form;
}


/**
 * Implementation of menu_hook()
 */
function eticket_menu($may_cache) {
  
  $items = array();
    
  $items[] = array('path' => 'guestlist',
                   'title' => t('Guestlist'),
                   'callback' => '_eticket_guestlist_page',
                   'access' => user_access('administer users'),
                   'type' => MENU_CALLBACK);
    
  return $items;
}

/**
 * Implementation of productapi_hook()
 */

function eticket_productapi(&$node, $op, $a3 = null, $a4 = null) {
  
  switch ($op) {
  
      case 'fields':
        return array('stock' => $node->stock, 'manage_stock' => $node->manage_stock, 'availability' => $node->availability);
      
      case 'validate':
        if (isset($node->stock) && !$node->stock) {
          if (!$node->stock) {
            $node->stock = 0;
          }
          if (!is_numeric($node->stock)) {
            form_set_error('stock', t('Please enter a numeric value for stock.'));
          }
        }
        break;
  
      case 'wizard_select':
        return array('eticket' => t('E-ticket product'));
  
      case 'attributes':
        $attributes = array();
        if (($node->manage_stock && $node->stock > 0) || !$node->manage_stock) {
          $attributes[] = 'in_stock';
        }
        return $attributes;
        break;
  
      case 'cart add item':
        if ($node->manage_stock && $node->stock <= 0) {
          drupal_set_message(t('Tickets are sold out.'), 'error');
          return FALSE;
        }
        break;
  
      case 'on payment completion':
        if ($node->manage_stock) {
          db_query('UPDATE {ec_product_tangible} SET stock = %d WHERE nid = %d', $node->stock - $node->qty, $node->nid);
        }
          
        break;
  
      case 'form':
        $form['inventory'] = array(
          '#type' => 'fieldset',
          '#title' => t("Ticket availablitiy control"),
        );
        $form['inventory']['manage_stock'] = array(
          '#type' => 'radios',
          '#title' => t('Ticket availablitity management for this item'),
          '#default_value' => (($node->manage_stock == 0) ? $node->manage_stock : 1),
          '#options' => array(t('Disabled'), t('Enabled')),
          '#description' => t("When enabled, only a certain number of tickets are available. When tickets sell out, the 'Add to cart' will be replaced with 'Sold out'."),
        );
        $form['inventory']["stock"] = array(
          '#type' => 'textfield',
          '#title' => t("Number of tickets"),
          '#default_value' => (($node->stock != '') ? $node->stock : 0),
          '#size' => 25,
          '#maxlength' => 50,
          '#description' => t("Total number of tickets for sale."),
        );
        
        return $form;
  
      case 'load':
        return db_fetch_object(db_query('SELECT * FROM {ec_product_tangible} WHERE vid = %d', $node->vid));
  
      case 'insert':
        return db_query("INSERT INTO {ec_product_tangible} (nid, vid, stock, manage_stock, availability) VALUES ('%d', '%d', '%d', '%d', '%s')", $node->nid, $node->vid, $node->stock, $node->manage_stock, $node->availability);
  
      case 'update':
        return db_query("UPDATE {ec_product_tangible} SET stock = '%d', manage_stock = '%d', availability = '%s' WHERE vid = '%d'", $node->stock, $node->manage_stock, $node->availability, $node->vid);
  
      case 'delete':
      return db_query('DELETE FROM {ec_product_tangible} WHERE nid = %d', $node->nid);
  }
}

/**
 * Implementation of hook_checkoutapi().
 */
 
function eticket_checkoutapi(&$txn, $op, $post_op = NULL, $arg4 = NULL) {
  
  switch ($op) {
    
    case 'form':
      
      foreach ((array)$txn->items as $product) {
                
                $node = node_load($product->nid);
                
                if ($node->ptype == 'eticket') {
                
                  for ($i = 1; $i <= $product->qty; $i++) {
                    
                    $form['eticket'.$i] = array(
		        '#type' => 'fieldset',
		        '#title' => t('Ticket Details '. $i),
		        '#tree' => TRUE);
                    
                    if ($i == 1) {
                     
                      $form['eticket1']['info1'] = array('#value' => '<b><font color="red">These details will be used as the main ticket holder. Confirmation details will be sent to this person</font></b>');     
                    }
                    
                    $form['eticket'.$i]['firstname'.$i] = array(
		        '#type' => 'textfield', 
		    	'#title' => t('Firstname'), 
		    	'#default_value' => '', 
		    	'#size' => 30, 
		    	'#maxlength' => 64, 
		    	'#required' => true,
		        '#description' => t('Please enter the first name of the ticket holder'));
                    
                    $form['eticket'.$i]['surname'.$i] = array(
		        '#type' => 'textfield', 
		       	'#title' => t('Surname'), 
		       	'#default_value' => '', 
		       	'#size' => 30, 
		       	'#maxlength' => 64, 
		       	'#required' => true,
		        '#description' => t('Please enter the surname of the ticket holder. <b>This will be used on guestlist at door to get into party. ID may be required!</b>'));
                    
                    $form['eticket'.$i]['email'.$i] = array(
		        '#type' => 'textfield', 
		        '#title' => t('E-mail address'), 
		        '#default_value' => '', 
		        '#size' => 30, 
		        '#maxlength' => 64,
		        '#required' => true,
		        '#description' => t('Please enter the e-mail address of the ticket holder. <b>Double-check to make sure the email address is correct!!</b><br>The e-mail address will be added automatically to a mailing list to update on news for event. If you do not have ticket holders e-mail address, please supply your own. You will not continue to receive e-mails after the event.'));  
		        
		    $form['eticket'.$i]['gender'.$i] = array('#type' => 'radios',
		        '#title' => t('Pimp or Hoe?'),
		        '#required' => true,
		        '#options' => array('Pimp'=>t('Pimp'),'Hoe'=>t('Hoe')),
		        '#description' => t('Is the ticket holder a Pimp or a Hoe?'));
                  }
                }
        
        }
     
      //drupal_set_title(t('Enter Ticket Details'));
      $form[] = array('#type' => 'submit', '#default_value' => t('Continue')); 
      return $form;
      break;
      
    case 'validate' :
      
      foreach ((array)$txn->items as $product) {
                      
                $node = node_load($product->nid);
                      
                if ($node->ptype == 'eticket') {
                      
                  for ($i = 1; $i <= $product->qty; $i++) {
                    
                    $eticketkey = 'eticket'.$i;
                    $emailkey = 'email'.$i;
                    $datakey = '$email = $txn->' . $eticketkey .'["' . $emailkey . '"];'; 
                    eval($datakey);
                    
                    if (!valid_email_address($email)) {
                      form_set_error($emailkey, t($email . ' is not a valid e-mail address for ticket holder ' . $i . '. Please check the e-mail and try again.'));
                    }
                  }
                }
      }
      
      break;

    case 'save':
      
      $txn->mail = $txn->eticket1['email1'];
      
      $txn->screen++;
      break;

    case 'review':
      
      $form['eticketreview'] = array( '#value' => '<h2 class="title">' . t('E-ticket Details') . '</h2>', 
                                      '#prefix' => '<div class="box">',
                                      '#suffix' => '</tbody></table></div>');
      
      $form['eticketreview']['table'] = array('#value' => '<table><thead><tr><th>Firstname</th><th>Surname</th><th>E-mail</th><th>Gender</th></tr></thead><tbody>' );      
      
      foreach ((array)$txn->items as $product) {
                                  
                      $node = node_load($product->nid);
                                  
                      if ($node->ptype == 'eticket') {
                                  
                        for ($i = 1; $i <= $product->qty; $i++) {
                                
                          $eticketkey = 'eticket'.$i;
                          $emailkey = 'email'.$i;
                          
                          // Save firstname
      		          $datakey = '$firstname = $txn->' . $eticketkey .'["firstname' . $i . '"];'; 
      		          eval($datakey);
                          // Save surname
      		          $datakey = '$surname = $txn->' . $eticketkey .'["surname' . $i . '"];'; 
      		          eval($datakey);
      		          // Save e-mail
                          $datakey = '$email = $txn->' . $eticketkey .'["email' . $i . '"];'; 
                          eval($datakey);
                          // Save gender
      		          $datakey = '$gender = $txn->' . $eticketkey .'["gender' . $i . '"];'; 
      		          eval($datakey);
                          
                          // Print Details
                          
                          $form['eticketreview'][rowbegin.$i] = array( '#value' => '<tr>' );
                          $form['eticketreview'][firstname.$i] = array( '#value' => '<td>' . $firstname . '</td>' );
                          $form['eticketreview'][surname.$i] = array( '#value' => '<td>' . $surname . '</td>' );
                          $form['eticketreview'][email.$i] = array( '#value' => '<td>' . $email . '</td>' );
                          $form['eticketreview'][gender.$i] = array( '#value' => '<td>' . $gender . '</td>' );
                          $form['eticketreview'][rowend.$i] = array( '#value' => '</tr>' );
                        }
                      }
      }
      
      
      return $form;
      break;
  } 
}

/**
 * Implementation of hook_ec_transactionapi()
 */
function eticket_ec_transactionapi(&$txn, $op, $arg3 = null, $arg4 = null) {
  switch ($op) {
    case 'load':
      
      $result = db_query('SELECT * FROM {ec_eticket_details} WHERE txnid = %d', $txn->txnid);
      
      while ($data = db_fetch_array($result)) {
        $extra['eticket'][] = $data;
      }
      
      if ($extra) {
        return $extra;
      }      
      
      break;
    case 'insert':
      
       foreach ((array)$txn->items as $product) {
                                        
                      $node = node_load($product->nid);
                                        
                      if ($node->ptype == 'eticket') {
                                        
                        for ($i = 1; $i <= $product->qty; $i++) {
                                      
                          $eticketkey = 'eticket'.$i;
                          $emailkey = 'email'.$i;
                                
                          // Save firstname
            		  $datakey = '$firstname = $txn->' . $eticketkey .'["firstname' . $i . '"];'; 
            		  eval($datakey);
                          // Save surname
            		  $datakey = '$surname = $txn->' . $eticketkey .'["surname' . $i . '"];'; 
            		  eval($datakey);
            		  // Save e-mail
                          $datakey = '$email = $txn->' . $eticketkey .'["email' . $i . '"];'; 
                          eval($datakey);
                          // Save gender
            	          $datakey = '$gender = $txn->' . $eticketkey .'["gender' . $i . '"];'; 
            		  eval($datakey);
                                
                          // Save e-ticket Details
                          
                          db_query("INSERT INTO {ec_eticket_details} (nid, txnid, firstname, lastname, email, gender) VALUES ('%d', '%d', '%s', '%s', '%s', '%s')", $product->nid, $txn->txnid, $firstname, $surname, $email, $gender);
                        }
                      }
        }
        
        _eticket_send_email($txn->mail, $txn->txnid);
        
      break;
    case 'delete':
      
      db_query('DELETE FROM {ec_eticket_details} WHERE txnid = %d', $txn->txnid);
    break;
  }
}

/**
 * Module Functions
 */
 
/**
 * Render a guestlist page for printing out
 */
 
 function _eticket_guestlist_page() {
   
   $output = '<p><b>Pre-paid Guestlist</b></p>';
   
   $hoes = db_fetch_object(db_query("select COUNT(*) as hoes from {ec_eticket_details} details, {ec_transaction} transaction where (details.txnid = transaction.txnid) and (transaction.payment_status = 2) and (details.gender='Hoe')"));
   $pimps = db_fetch_object(db_query("select COUNT(*) as pimps from {ec_eticket_details} details, {ec_transaction} transaction where (details.txnid = transaction.txnid) and (transaction.payment_status = 2) and (details.gender='Pimp')"));
   
   $output .= '<p><b>Pimps:</b> ' . $pimps->pimps  . ' <b>Hoes:</b> ' . $hoes->hoes . ' <b>Total:</b> ' . ($pimps->pimps + $hoes->hoes) . '</p>';
   
   $sortby = $_GET['sortby'];
   
   if (!$sortby) {
     $sortby = 'lastname';
   }   
   
   $result = db_query("select * from {ec_eticket_details} details, {ec_transaction} transaction where (details.txnid = transaction.txnid) and (transaction.payment_status = 2) order by details.".$sortby);
   
   $output .= '<table><thead><tr><th>' . l('Eticket #', 'guestlist', null, 'sortby=etid') . '</th><th>' . l('Surname', 'guestlist', null, 'sortby=lastname') . '</th><th>' . l('Firstname', 'guestlist', null, 'sortby=firstname') . '</th><th>' . l('Gender', 'guestlist', null, 'sortby=gender') . '</th><th>' . l('E-mail', 'guestlist', null, 'sortby=email') . '</th></tr></thead><tbody>';
   
   while ($eticket = db_fetch_object($result)) {
   
       $output .= '<tr><td>' . $eticket->etid . '</td><td><b>' . $eticket->lastname . '</b></td><td>' . $eticket->firstname . '</td><td>' .$eticket->gender . '</td><td>' . $eticket->email . '</td></tr>';
     
       $emails[] = $eticket->email;     
     }

   $output .= '</tbody></table><p><p><p><b>E-mail List:</b></p>';
   
   if($emails) {
   
     foreach($emails as $email) {
       
       $output .= $email . '; ';
     }   
   }
   
   return $output;
 }
 
 /**
  * Send confirmation e-mail to user
  */

function _eticket_send_email($txnemail, $txnid) {
 
 $result = db_query("select * from {ec_eticket_details} where txnid = '%d' order by lastname", $txnid);
 
 $msg = "Thankyou for purchasing your tickets for the Pimps & Hoes Bling Bling Party on Saturday, 10th February\n";
 $msg .= "This e-mail is confirmation of your ticket details:\n\n";
 $msg .= "   TICKET #   SURNAME       FIRSTNAME        GENDER   E-MAIL\n";
 
 while ($eticket = db_fetch_object($result)) {
        
   $msg .= "   " . $eticket->etid  . "   " . $eticket->lastname . "        " . $eticket->firstname . "        " . $eticket->gender . "   " . $eticket->email . "\n";
 }

 $msg .= "\nPlease reply to us on this address (admin@pimpsandhoessociety.org.uk) If there are any problems with these details asap.";
 $mail['from'] = '';
 $mail['to'] = $txnemail;
 $mail['subject'] = 'ETicket Confirmation';
 $mail['body'] = $msg;
 $mail['type'] = 'txt';
 ec_mail_send_mail($mail);
 //store_email_send('admin@pimpsandhoessociety.org.uk', $txnemail, 'P&H Bling Bling Party Ticket Confirmation', $msg);
}

?>