<?php 
defined('C5_EXECUTE') or die(_("Access Denied."));
 
 
class BookingSelectAttendeesController extends Controller {
 
   public function on_start(){
      Loader::model('attribute/categories/proforms_item','proforms');
      Loader::model('proforms_item_list','proforms');
      Loader::model('proforms_item','proforms');
      Loader::model('attendees','attendees');
      Loader::model('attendees_list','attendees');
      Loader::model('attribute/categories/attendees','attendees');
 
      Loader::model('tickets_list','tickets');
      Loader::model('attribute/categories/tickets','tickets');
 
      $this->set('fm',Loader::helper('form'));
 
      $html = Loader::helper('html');
      $this->addHeaderItem($html->css('catalyst_special.css', 'catalyst'));
      //$this->addHeaderItem($html->css('ccm.app.css'));
      $this->addHeaderItem($html->css('jquery.ui.css'));
 
      $this->addFooterItem($html->javascript('jquery.ui.js'));
      $this->addFooterItem($html->javascript('jquery.form.js'));
      $this->addFooterItem($html->javascript('jquery.postmessage.js'));
      $this->addFooterItem($html->javascript('ccm.app.js'));
      $this->addHeaderItem($html->javascript('jquery.h5validate.js','catalyst'));
 
 
      $this->error = Loader::helper('validation/error');
 
      $u = new User();
      $uID = $u->uID;
 
      if($u->isLoggedIn()){
 
         $app = new ProformsItemList();
         $app->filter(false,"ak_associated_user = $uID");
 
         $as = AttributeSet::getByHandle('catalyst_orders');
         $asID = $as->getAttributeSetID();
 
         $app->filterByAttributeSet($asID);
 
         $application = $app->get();
 
         $catalyst= $application[0];
         $catalystID = $catalyst->getProformsItemID();
         $this->set('catalyst',$catalyst);
 
         $al = new TicketsList();
         $tickets = $al->get();
         $this->set('tickets',$tickets);
 
         $al = new AttendeesList();
         $al->filter(false,"ak_catalyst_form = $catalystID");
         $attendees = $al->get();
         $this->set('attendees',$attendees);
      }
 
   }
 
   public function remove_attendee(){
      $valt = Loader::helper('validation/token');
      if (!$valt->validate('remove_attendee', $this->post('token'))) {
         throw new Exception($valt->getErrorMessage());
      }
 
      if($this->post('attendeeID')){
         $db = Loader::db();
         $db->execute("DELETE FROM atAttendeesBooked WHERE attendeesID = ?",array($this->post('attendeeID')));
         $ao = Attendees::getByID($this->post('attendeeID'));
         $ao->delete();
 
         $date = date('Y-m-d');
          $u = new User();
 
          $data = array(
              'ProformsItemID'=> $this->post('catalystID'),
              'action'=> 'Attendee Removed',
              'amount'=>'0.00',
              'description'=> 'Attendee Removed',
              'uID'=> $u->uID,
              'date' => $date
          );
 
          Loader::model('order_history','catalyst');
          $oh = new OrderHistory();
          $oh->addOrderHistoryItem($data);
 
         $this->redirect('/booking/select_attendees/attendee_removed/');
      }
   }
 
   public function add_attendee(){
 
      $valt = Loader::helper('validation/token');
      if (!$valt->validate('add_attendee', $this->post('token'))) {
         throw new Exception($valt->getErrorMessage());
      }
 
 
      if($this->post('catalystID')){
 
         $teaksKey = AttendeesAttributeKey::getByHandle('associated_team');
         if($_REQUEST['akID'][$teaksKey->getAttributeKeyID()]['value']){
            Loader::model('teams','teams');
            $team = Teams::getByID($_REQUEST['akID'][$teaksKey->getAttributeKeyID()]['value']);
            $dbs = $team->getAttribute('dbs_required');
            if($dbs){
               $dbs_date = AttendeesAttributeKey::getByHandle('dbs_date');
               $dbs_number = AttendeesAttributeKey::getByHandle('dbs_number');
 
               $dbs_date_post = $_REQUEST['akID'][$dbs_date->getAttributeKeyID()]['value'];
               $dbs_number_post = $_REQUEST['akID'][$dbs_number->getAttributeKeyID()]['value'];
               if(!$dbs_date_post || !$dbs_number_post){
                  $this->set('error',t('<p>The Selected Team Requires both DBS Document Number and DBS Approval Date!</p><p>Your Attendee was <b><u>NOT</u></b> added. Please try again when you have this information!!!</p>'));
                  $this->is_error = true;
               }
 
               //26-05-2012
               $ndate = date('Ymd',strtotime($dbs_date_post));
               if($ndate < '20120526'){
                  $this->set('error',t('<p>The Selected DBS Date provided is not valid for this event as it is older than 3 years!</p><p>Your Attendee was <b><u>NOT</u></b> added!</p> <p>Please double check your DBS date, or perhaps volunteer for a different team!!!</p>'));
                  $this->is_error = true;
               }
            }
         }
 
         //first we add the attendee to the system
         if(!$this->is_error){
 
             $day_attendee_objs = array();
 
            if($this->post('attendeeID')){
               $day_attendee_objs[] = Attendees::getByID($this->post('attendeeID'));
            }else{
                //set up array if more than one date is provided
                if($this->request('mdpID')){
                    foreach($this->request('mdpID') as $di){
                        $ao = Attendees::add();
                        $day_attendee_objs[] = $ao;
                    }
                }
            }
 
            Loader::model('tickets','tickets');
            $ticket = Tickets::getByID($this->post('ticketID'));
 
            foreach($day_attendee_objs as $key=>$ao){
 
                $_REQUEST['attendee'] = $ao;
 
                $pkg = Package::getByHandle('attendees');
                $asIDs = AttributeSet::getListByPackage($pkg);
                $as = $asIDs[0];
 
                $edit_attendees_atts = array('first_name','last_name', 'gender','attendee_email','team_code','accessibility_requirements','translation_equipment','please_explain');
 
                $atts = $as->getAttributeKeys();
 
                foreach ($atts as $ak) {
                   $key_handle = $ak->getAttributeKeyHandle();
                    if($key_handle != 'multidate_price_id' ){
                       if(in_array($key_handle, $edit_attendees_atts)) {
                          $ak->saveAttributeForm($ao);
                       }
 
                        }
                }
 
                //next we get already added attendees to this catalystID
                //we also need to associate the Catalyst form item and the ticket type.
                $ak = AttendeesAttributeKey::getByHandle('catalyst_form');
                $ao->setAttribute($ak,array('value'=>$this->post('catalystID')));
 
                if($this->post('dayTicket')){
                   $ak = AttendeesAttributeKey::getByHandle('day_ticket');
                   $ao->setAttribute($ak,array('value'=>$this->post('dayTicket')));
                }
 
                //we need to check/set this attendees ticket date for this year
                //if not set, set it to now.
                $pkg = Package::getByHandle('catalyst');
                   $conference_year = $pkg->config('CONFERENCE_YEAR');
                   $year = date('Y',strtotime($conference_year));
                   $ticket_purchase_date = $ao->getAttribute($year.'_ticket_date');
                   if(!$ticket_purchase_date){
                       $ak = AttendeesAttributeKey::getByHandle($year.'_ticket_date');
                       $ao->setAttribute($ak,date('Y-m-d'));
                   }
 
                //confirm this attendee always
                $ak = AttendeesAttributeKey::getByHandle('attendee_confirmed');
                $ao->setAttribute($ak,array('value'=>1));
 
                if($_REQUEST['mdpID'][$key]){
 
                    $dateID = $_REQUEST['mdpID'][$key];
 
                   $dateInfo = Loader::db()->getRow("SELECT * FROM atMultiDatePriceDates WHERE mdpID = ?",array($dateID));
 
 
                   $mealplan = $ao->getAttribute('attendee_mealplan');
 
                   if($mealplan && $mealplan != ''){
                      switch($mealplan){
                          case 'Three Meal Plan {{3}}':
                              $mealplan = $ticket->getAttribute('mealplan_three_price');
                              break;
                                case 'Two Meal Plan {{2}}':
                                    $mealplan = $ticket->getAttribute('mealplan_two_price');
                                    break;
                                case 'Three Meal Full Price {{3D}}':
                            $mealplan = $ticket->getAttribute('mealplan_three_full_price');
                            break;
                            case 'Two Meal Full Price {{2D}}':
                                 $mealplan = $ticket->getAttribute('mealplan_two_full_price');
                                 break;
                      }
                   }else{
                       $mealplan = 0;
                   }
 
                   $total = money_format('%(#4n',$dateInfo['price']*1) + money_format('%(#4n',$mealplan*1);
                   $total = money_format('%(#4n',$total*1);
 
                   $vals = array(
                      'date'=> $dateInfo['date'],
                      'price'=> $total,
                      'mdpID'=> $dateID,
                      'ticketsID'=> $this->post('ticketID')
                   );
 
                   $ak = AttendeesAttributeKey::getByHandle('associated_ticket');
                   $ao->setAttribute($ak,$vals);
 
                }
 
                $ao->reindex();
 
                //next we update the attendee list
                //yes, this is redundent.  on purpose.
 
                $catalyst = ProformsItem::GetByID($this->post('catalystID'));
 
                $data = array(
                   'attendeesID'=>$ao->getAttendeesID(),
                   'ticketID'=>$this->post('ticketID')
                );
                //update the attending user list
                $ak = ProformsItemAttributeKey::getByHandle('selected_attendees');
                $catalyst->setAttribute($ak,array('attendees'=>$data));
 
                $catalyst->reindex();
                }
 
                $date = date('Y-m-d');
              $u = new User();
 
              $data = array(
                  'ProformsItemID'=> $this->post('catalystID'),
                  'action'=> 'Attendee Added',
                  'amount'=>'0.00',
                  'description'=> 'Attendee Added',
                  'uID'=> $u->uID,
                  'date' => $date
              );
 
              Loader::model('order_history','catalyst');
              $oh = new OrderHistory();
              $oh->addOrderHistoryItem($data);
 
            $this->redirect('/booking/select_attendees/attendee_added/');
         }
      }
   }
 
   public function attendee_added(){
      $this->set('message',t('Success!  Continue adding attendees as desired and click "continue to next step" when you are done!'));
   }
 
   public function attendee_removed(){
      $this->set('message',t('Attendee Removed!  Continue adding attendees as desired and click "continue to next step" when you are done!'));
   }
}