Source for file bookinglist.php

Documentation is available at bookinglist.php

  1. <?php
  2. /**
  3. * View a list of bookings for a given user or instrument in tabular format
  4. *
  5. * @author     Stuart Prescott
  6. * @copyright  Copyright Stuart Prescott
  7. * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  8. * @version    $Id: bookinglist.php,v 1.3 2006/12/12 23:30:42 themill Exp $
  9. * @package    Bumblebee
  10. * @subpackage Actions
  11. *
  12. *  path (bumblebee root)/inc/actions/bookinglist.php
  13. */
  14.  
  15. /** Load ancillary functions */
  16. require_once 'inc/typeinfo.php';
  17. checkValidInclude();
  18.  
  19. /** list of choices object */
  20. require_once 'inc/formslib/anchortablelist.php';
  21. /** parent object */
  22. require_once 'inc/actions/viewbase.php';
  23.  
  24. /**
  25. * View a list of bookings for a given user or instrument in tabular format
  26. * @package    Bumblebee
  27. * @subpackage Actions
  28. */
  29. class ActionBookingList extends ActionViewBase {
  30.  
  31.   var $restrictions = array();
  32.   var $startListing;
  33.   var $stopListing;
  34.  
  35.   //restrictions that might be placed on the listing
  36.     var $instrument;
  37.   var $user;
  38.   var $groups;
  39.   var $projects;
  40.  
  41.   var $showUser = true;
  42.  
  43.   var $tableCaption = '';
  44.   var $noneFoundNotice = '%s - %s';
  45.  
  46.   /**
  47.   * Initialising the class
  48.   *
  49.   * @param  BumblebeeAuth $auth  Authorisation object
  50.   * @param  array $pdata   extra state data from the call path
  51.   * @return void nothing
  52.   */
  53.   function ActionBookingList($auth, $PDATA) {
  54.     parent::ActionViewBase($auth, $PDATA);
  55.     $this->mungeInputData();
  56.   }
  57.  
  58.   function go() {
  59.     $this->selectInstrument();
  60.   }
  61.  
  62.   function setDefaultRestrictions($window) {
  63.     $this->startListing = new SimpleDate(time());
  64.     $this->startListing->dayRound();
  65.     $this->stopListing = clone($this->startListing);
  66.     $this->stopListing->addDays($window);
  67.   }
  68.  
  69.  
  70.   function _makeRestrictions() {
  71.     $this->restrictions[] = 'bookwhen >= '.qw($this->startListing->dateTimeString());
  72.     $this->restrictions[] = 'bookwhen <= '.qw($this->stopListing->dateTimeString());
  73.  
  74.     if (isset($this->user) && ! empty($this->user)) {
  75.       $this->restrictions[] = 'userid='.qw($this->user);
  76.       $this->showUser = false;
  77.     }
  78.  
  79.     if (isset($this->instrument) && ! empty($this->instrument)) {
  80.       $this->restrictions[] = 'instrument='.qw($this->instrument);
  81.     }
  82.  
  83. /*    if (is_array($this->groups)) {
  84.       if (count($this->groups) > 0) {
  85.         $this->restrictions[] = 'groupid in ('.join(',', array_qw($this->groups)).')';
  86.       } else {
  87.         $this->restrictions[] = '0';
  88.       }
  89.     }*/
  90.  
  91.     if (is_array($this->projects)) {
  92.       if (count($this->projects) > 0) {
  93.         $this->restrictions[] = 'projectid in ('.join(',', array_qw($this->projects)).')';
  94.       } else {
  95.         $this->restrictions[] = '0';
  96.       }
  97.     }
  98.   }
  99.  
  100.   /**
  101.   *
  102.   */
  103.   function showBookings() {
  104.  
  105.     $this-> _makeRestrictions();
  106.     $restriction = join($this->restrictions, ' AND ');
  107.  
  108.     $blist = new AnchorTableList('Bookings', T_('Upcoming bookings'), 4);
  109.     $blist->hrefbase = makeURL('book', array('bookid'=>'__id__'));
  110.  
  111.     $blist->connectDB('bookings',
  112.                           array('bookings.id', 'bookwhen', 'duration',
  113.                                 'instruments.name AS instrumentname', 'username', 'users.name'),
  114.                           $restriction,
  115.                           'bookwhen',
  116.                           array('bookings.id', 'bookid'),
  117.                           NULL,
  118.                           array('users'       => 'userid=users.id',
  119.                                 'instruments' => 'instrument=instruments.id'));
  120.  
  121.     $headings = array(T_('Date &amp; Time'),
  122.                       T_('Duration'),
  123.                       T_('Instrument')
  124.                       );
  125.  
  126.     if ($this->showUser) {
  127.       $blist->setFormat('id',
  128.                         '%s', array('bookwhen'),
  129.                         '%s', array('duration'),
  130.                         '%s', array('instrumentname'),
  131.                         '%s (%s)', array('name', 'username'));
  132.       $headings[] = T_('User');
  133.     } else {
  134.       $blist->setFormat('id',
  135.                         '%s', array('bookwhen'),
  136.                         '%s', array('duration'),
  137.                         '%s', array('instrumentname')
  138.                         );
  139.       $blist->numcols--;
  140.     }
  141.     $blist->setTableHeadings($headings);
  142.  
  143.     echo $this->tableCaption;
  144.  
  145.     if ($blist->list->length <=0) {
  146.       printf($this->noneFoundNotice,
  147.                     $this->startListing->dateString(),
  148.                     $this->stopListing->dateString());
  149.     } else {
  150.       echo $blist->display();
  151.     }
  152.   }
  153.  
  154. } // class ActionView
  155.  
  156. ?>

Documentation generated on Tue, 06 Mar 2007 10:00:55 +0000 by phpDocumentor 1.3.0