Source for file deletedbookings.php

Documentation is available at deletedbookings.php

  1. <?php
  2. /**
  3. * View a list of deleted bookings for an instrument over a given time period
  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$
  9. * @package    Bumblebee
  10. * @subpackage Actions
  11. *
  12. *  path (bumblebee root)/inc/actions/deletedbookings.php
  13. */
  14.  
  15. /** Load ancillary functions */
  16. require_once 'inc/typeinfo.php';
  17. checkValidInclude();
  18.  
  19. /** list of choices */
  20. require_once 'inc/formslib/anchortablelist.php';
  21. /** date manipulation routines */
  22. require_once 'inc/date.php';
  23. /** DateRange object */
  24. require_once 'inc/bb/daterange.php';
  25. /** parent object */
  26. require_once 'inc/actions/actionaction.php';
  27.  
  28. /**
  29. * View a list of deleted bookings for an instrument over a given time period
  30. * @package    Bumblebee
  31. * @subpackage Actions
  32. */
  33. class ActionDeletedBookings extends ActionAction {
  34.  
  35.   /**
  36.   * Initialising the class
  37.   *
  38.   * @param  BumblebeeAuth $auth  Authorisation object
  39.   * @param  array $pdata   extra state data from the call path
  40.   * @return void nothing
  41.   */
  42.   function ActionDeletedBookings($auth, $PDATA) {
  43.     parent::ActionAction($auth, $PDATA);
  44.     $this->mungeInputData();
  45.   }
  46.  
  47.   function go() {
  48.     if (! isset($this->PD['instrid'])
  49.           || $this->PD['instrid'] < 1
  50.           || $this->PD['instrid'] == '') {
  51.       $this->selectInstrument();
  52.       return;
  53.     }
  54.     $daterange = new DateRange('daterange', T_('Select date range'),
  55.                       T_('Enter the dates over which you want to report deleted bookings'));
  56.     $daterange->update($this->PD);
  57.     $daterange->checkValid();
  58.     if ($daterange->newObject) {
  59.       $daterange->setDefaults(DR_PREVIOUS, DR_MONTH);
  60.       echo $daterange->display($this->PD);
  61.       echo "<br /><br /><a href='".makeURL('deletedbookings')."'>"
  62.                   .T_('Return to instrument list')."</a>";
  63.     } else {
  64.       $this->showDeleted($daterange);
  65.       echo "<br /><br /><a href='".makeURL('deletedbookings', array('instrid'=>$this->PD['instrid']))."'>".T_('Choose different dates')."</a>";
  66.     }
  67.   }
  68.  
  69. /*  function mungeInputData() {
  70.     $this->PD = array();
  71.     foreach ($_POST as $k => $v) {
  72.       $this->PD[$k] = $v;
  73.     }
  74.     if (isset($this->PDATA[1]) && $this->PDATA[1] !== '') {
  75.       $this->PD['instrid'] = $this->PDATA[1];
  76.     }
  77.     echoData($this->PD, 0);
  78.   }
  79.   */
  80.   /**
  81.   * Select which instrument the listing should be generated for
  82.   */
  83.   function selectInstrument() {
  84.     $instrselect = new AnchorTableList(T_('Instrument'), T_('Select which instrument to view'));
  85.     $instrselect->connectDB('instruments',
  86.                             array('id', 'name', 'longname')
  87.                             );
  88.     $instrselect->hrefbase = makeURL('deletedbookings', array('instrid'=>'__id__'));;
  89.     $instrselect->setFormat('id', '%s', array('name'), ' %50.50s', array('longname'));
  90.     echo $instrselect->display();
  91.   }
  92.  
  93.   /**
  94.   * Display the deleted bookings
  95.   */
  96.   function showDeleted($daterange) {
  97.     $start = $daterange->getStart();
  98.     $stop  = $daterange->getStop();
  99.     $stop->addDays(1);
  100.     $instrument = $this->PD['instrid'];
  101.     $bookings = new AnchorTableList(T_('Bookings'), T_('Select deleted bookings'));
  102.     $bookings->setTableHeadings(array(T_('Date'), T_('Duration'), T_('User'), T_('Log Entry')));
  103.     $bookings->numcols = 4;
  104.     $bookings->deleted = true;
  105.     $bookings->connectDB('bookings',
  106.                             array('bookings.id', 'username', 'bookwhen', 'duration','log'),
  107.                                     'bookwhen >= '.qw($start->dateTimeString())
  108.                               .' AND bookwhen < ' .qw($stop->dateTimeString())
  109.                               .' AND instrument = '.qw($instrument),
  110.                             'bookwhen',
  111.                             'bookings.id',
  112.                             NULL,
  113.                             array('users'=>'userid=users.id'));
  114.     $bookings->hrefbase = makeURL('view', array('bookid'=>'__id__', 'instrid'=>$instrument));
  115.     $bookings->setFormat('id', '%s', array('bookwhen'),
  116.                                '%s', array('duration'),
  117.                                '%s', array('username'),
  118.                                '%s', array('log'));
  119.     echo $bookings->display();
  120.   }
  121.  
  122. } // class ActionDeletedBookings
  123. ?>

Documentation generated on Tue, 06 Mar 2007 10:01:22 +0000 by phpDocumentor 1.3.0