base-event.inc.php

Go to the documentation of this file.

<?
class BaseEvent extends MyObject
{
    public $guests = null;
    public $guestTable = null;
    
    public function __construct($data = null, $table = 'events', $guestTable = 'event_guests')
    {
        $this->useLatLng = true;
        $this->commentsEnabled = true;

        $this->guestTable = $guestTable;
        
        parent::__construct($data, $table);
        
        $this->fullTextFields[] = 'name';
        $this->fullTextFields[] = 'description';
        $this->fullTextFields[] = 'location';
    }
    
    public function getPagesXml()
    { 
        $xml = parent::getPagesXml();
        $xml .= <<<XML
            <page name="invite">
                <param name="id" required="1" type="int"/>
            </page>
            <page name="uninvite">
                <param name="id" required="1" type="int"/>
                <param name="guest_id" required="1" type="int"/>
            </page>
            <page name="rsvp">
                <param name="id" required="1" type="int"/>
            </page>
            <page name="attend">
                <param name="id" required="1" type="int"/>
            </page>
            <page name="leave">
                <param name="id" required="1" type="int"/>
            </page>
XML;
        return $xml;
    }

    public function getEditPageParamXml()
    {
        $xml = '<param name="date" regex="/^\d{4}-\d{1,2}-\d{1,2}$/"/>';

        return $xml;
    }
    
    public function delete()
    {
        dbExecute("
            DELETE FROM {$this->guestTable}
            WHERE event_id = '$this->id'
        ");
        
        parent::delete();
    }

    public function initAttendPage()
    {
        $this->assertLogin();

        $this->id = $this->params('id');

        if (!$this->canAttend())
            throw new PageError('You do not have access to attend this event.');

        $this->pageTitle = "I'm there!";
    }

    public function drawAttendPage()
    {
        global $me;
        
        $form = $this->createAttendForm();
        if ($form->isSubmitted())
        {
            $form->validate();

            if (!$form->hasError())
            {
                $this->addGuest($me->id);
                $this->rsvp($me->id, 'yes', $form->getData('guests'));
                Util::redirect($this->getUrl(".view?id=$this->id"));
            }
        }
        else
            $form->setData(array('guests' => 0));

        if ($form->needsDrawn())
            $form->drawAll();
    }
    
    public function createAttendForm()
    {
        $form = new Form();
        $form->action = $this->getUrl(".attend?id=$this->id");

        $form->add('TextField', 'guests', array(
            'title' => 'How many guests are you bringing?',
            'required' => true,
            'size' => 10
        ));
        $form->addSubmit("I'm There");

        return $form;
    }

    public function initLeavePage()
    {
        $this->assertLogin();
        
        $this->id = $this->params('id');

        if (!$this->canLeave())
            throw new PageError('You do not have access to leave this event.');

        $this->pageTitle = 'Remove Me From Guests';
    }
    
    public function drawLeavePage()
    {
        global $me;
        
        $form = $this->createLeaveForm();
        if ($form->isSubmitted())
        {
            $this->removeGuest($me->id);
            Util::redirect($this->getUrl(".view?id=$this->id"));
        }
        else
            $form->drawAll();
    }

    public function createLeaveForm()
    {
        $form = new Form();
        $form->action = $this->getUrl(".leave?id=$this->id");

        $form->add('StaticField', 'info', array(
            'text' => 'Are you sure you want to remove yourself from the list of guests?'
        ));
        $form->addSubmit("Remove me from list");

        return $form;
    }

    public function initRSVPPage()
    {
        global $me;
    
        $this->assertLogin();

        $this->id = $this->params('id');

        if (!$this->isGuest($me->id))
            throw new PageError('You must be a guest to RSVP.');

        $this->pageTitle = 'RSVP to ' . $this->getName();
    }

    public function drawRSVPPage()
    {
        global $me;
        
        $form = $this->createRSVPForm();

        if ($form->isSubmitted())
        {
            $form->validate();

            if (!$form->hasError())
            {
                $this->rsvp($me->id, $form->getData('commitment'), $form->getData('guests'));

                Util::redirect($this->getUrl(".view?id=$this->id"));
            }
        }
        else
            $form->setData($this->getGuest($me->id));

        if ($form->needsDrawn())
            $form->drawAll();
    }

    public function createRSVPForm()
    {
        $form = new Form();
        $form->action = $this->getUrl(".rsvp?id=$this->id");

        $form->add('SelectField', 'commitment', array(
            'title' => 'Are you attending this event?',
            'options' => array(
                'yes' => 'Yes',
                'no' => 'No',
                'maybe' => 'Maybe'
            ),
            'required' => true
        ));
        $form->add('TextField', 'guests', array(
            'title' => 'How many guests are you bringing?',
            'size' => 10
        ));
        $form->addSubmit("RSVP");

        return $form;
    }
    
    public function initUnInvitePage()
    {
        $this->assertLogin();

        $this->id = $this->params('id');

        $this->pageTitle = 'Uninvite Guests';

        if (!$this->canUnInvite())
            throw new PageError('You do not have access to uninvite people to this event.');
    }

    public function drawUnInvitePage()
    {
        //this is who we're uninviting
        $user = new User($this->params('guest_id'));
        
        //get our form
        $form = $this->createUnInviteForm($user);

        //did we submit?
        if ($form->isSubmitted())
        {
            $form->validate();

            //no problems... do it
            if (!$form->hasError())
            {
                $this->removeGuest($user->id);
                Util::redirect($this->getUrl(".view?id=$this->id"));
            }
        }

        //draw it.
        if ($form->needsDrawn())
            $form->drawAll();
    }

    public function createUnInviteForm($user)
    {
        $form = new Form();
        $form->action = $this->getUrl(".uninvite?id=$this->id&guest_id=$user->id");

        $form->add("StaticField", "guest", array(
            'text' => 'Are you sure you want to uninvite ' . $user->getName(true) . '?'
        ));
        $form->addSubmit('Uninvite Guest');

        return $form;
    }

    public function canInvite()
    {
        return $this->canEdit();
    }

    public function canUnInvite()
    {
        return $this->canDelete();
    }

    public function canAttend()
    {
        global $me;

        return ((bool)$this->allow_attendees && !$this->invite_only && $this->canView() && !$this->isGuest($me->id));
    }

    public function canLeave()
    {
        global $me;
        
        return (bool)$this->isGuest($me->id);
    }
    
    public function initInvitePage()
    {
        $this->assertLogin();

        $this->id = $this->params('id');

        $this->pageTitle = 'Invite Guests';

        if (!$this->canInvite())
            throw new PageError('You do not have access to invite people to this event.');
    }

    public function drawInvitePage()
    {
        $form = $this->createInviteForm();

        //did we get it?
        if ($form->isSubmitted())
        {
            $form->validate();

            if (!$form->hasError())
            {
                $guests = explode(',', $form->getData('guests'));
                if (count($guests))
                    foreach ($guests AS $id)
                        $this->inviteGuest($id);

                Util::redirect($this->getUrl(".view?id=$this->id"));
            }
        }
        //draw it.
        if ($form->needsDrawn())
            $form->drawAll();
    }
    
    public function createInviteForm()
    {
        global $me;
        
        $form = new Form();
        $form->action = $this->getUrl(".invite?id=$this->id");
        
        //add it in
        $form->add('MultiSelectField', 'guests', array(
            'multiple' => true,
            'size' => 10,
            'options' => $this->getPotentialGuestList(),
            'title' => 'Select the people you want to invite.<br/>
            We will email the people you select <br/>and let them know they
            have been invited.',
        ));

        $form->addSubmit('Invite Guests');
    
        return $form;
    }

    protected function getPotentialGuestList()
    {
        global $me;

        //create our guestlist
        $items = array();
        $friends = $me->getFriends();
        foreach ($friends AS $member)
            if (!$this->isGuest($member->id))
                $items[$member->id] = $member->getName();

        return $items;
    }

    public function isGuest($userId)
    {
        $guests = $this->getGuests();

        return is_array($guests[$userId]);
    }

    public function getGuest($userId)
    {
        $guests = $this->getGuests();
        return $guests[$userId];
    }
    
    public function getGuests($all = true, $force = false)
    {
        if ($this->guests === null || $force)
        {
            $ret = array();
            //make sure we have an id...
            if ($this->id)
            {
                $where = '';
                if ($all)
                    $where = "AND commitment = '$yes'";
                    
                //query...
                $guestRs = dbQuery("
                    SELECT *
                    FROM {$this->guestTable}
                    WHERE event_id = '$this->id'
                ");
            
                while ($guestAr = dbFetchAssoc($guestRs))
                    $ret[$guestAr['user_id']] = $guestAr;
            }
            $this->guests = $ret;
        }

        return $this->guests;
    }

    public function getGuestCount($all = true)
    {
        return count($this->getGuests($all));
    }

    public function initEditPage()
    {
        parent::initEditPage();

        if (!$this->id)
            $this->pageTitle = 'Create New Event';
        else
            $this->pageTitle = 'Update Event';

        $this->needsJs('lib/js/event.js');
    }
    
    public function editFormAddFields($form)
    {
        global $me;
        
        $this->addContentFields($form);
        $this->addLocationFields($form);
        $this->addPrivacyFields($form);
        
        if (!$this->id)
            $form->addSubmit('Add Event');
        else
            $form->addSubmit('Save Event');
    }
    
    public function addContentFields($form)
    {
        $form->add('TextField', 'name', array(
            "required" => true,
            "width" => "100%"
        ));

        $form->add('DateField', 'start_date', array(
            'required' => true,
            'format' => 12
        ));
        
        $form->add('DateField', 'end_date', array(
            "definition" => "Leave blank for 1 day events.",
            'format' => 12
        ));
        
        $form->add('EditorField', 'description', array(
            "width" => '100%',
            "height" => '300px',
        ));

        return $form;
    }

    public function addLocationFields($form)
    {
        $form->add('TextField', 'location', array(
            "title" => "Location<br/>",
            "definition" => "My House, Bob's Place, Library, etc.",
            "size" => 50
        ));
        
        $form->add('TextField', 'street', array(
            'size' => 45,
            'maxlength' => 255,
            'title' => 'Street Address'
        ));
        $form->add('CityStateZipField', 'citystzip', array(
            'title' => 'City / State / Zip'
        ));

        return $form;
    }

    public function addPrivacyFields($form)
    {
        $form->add('CheckboxField', 'allow_attendees', array(
            'value' => 1,
            'title' => 'Attendees',
            'label' => 'Allow people to add themselves to the list of attendees.'
        ));
        
        $form->add('CheckboxField', 'invite_only', array(
            'title' => '',
            'label' => 'Only allow people who are on the list of guests to view the event.<br/>You can add guests once you create the event. (They still have to be family or friend.)',
            'id' => 'inviteOnly',
            'onclick' => 'doPrivacyCheck(this.checked)'
        ));
    
        return $form;
    }
    
    public function editFormLoad($form)
    {
        parent::editFormLoad($form);

        if (!$this->id)
        {
            if ($this->params('date'))
                $form->setData(array(
                    'start_date' => $this->params('date'),
                    'end_date' => $this->params('date')
                ));
            else
                $form->setData(array(
                    'start_date' => date('Y-m-d H:i:s'),
                    'end_date' => date('Y-m-d H:i:s')
                ));
        }
    }

    protected function editPagePostSuccess($form)
    {
        global $me;
        
        if (!$this->isGuest($me->id))
            $this->addGuest($me->id, 'yes');
    
        parent::editPagePostSuccess($form);
    }
    
    public function addGuest($id, $commitment = 'yes')
    {
        dbExecute("
            INSERT INTO {$this->guestTable}
                (user_id, event_id, commitment)
            VALUES
                ('$id', '$this->id', '$commitment')
        ");

        $this->guests[$id] = array();
    }

    public function inviteGuest($id)
    {
        //is it valid?
        if ($id)
        {
            $this->addGuest($id, 'maybe');

            $user = new User($id);
            $this->emailInvite($user);
        }
    }
    
    public function removeGuest($id)
    {
        dbExecute("
            DELETE FROM {$this->guestTable}
            WHERE user_id = '$id'
                AND event_id = '$this->id'
        ");

        unset($this->guests[$id]);
    }

    public function rsvp($id, $commitment, $guests)
    {
        //we want an integer
        $guests = (int)$guests;

        //no's mean 0 guests.
        if ($commitment == 'no')
            $guests = 0;

        dbExecute("
            UPDATE {$this->guestTable} SET
                commitment = '$commitment',
                guests = '$guests'
            WHERE user_id = '$id'
                AND event_id = '$this->id'
        ");
    }

    protected function emailInvite($user)
    {
        global $me;
        
        if ($user->email_invites)
        {
            $subject = $me->getName() . " has invited you to an event.";
            $body = $me->getName() . " has recently invited you to an event on " . Config::get('site_name') . ".\n\n";
            $body .= "You can view the event, and RSVP with the link below:\n\n";
            $html .= $user->getTicket(strtolower(get_class($this)) . ".rsvp?id=$this->id") . "\n\n";
            $body .= "Thank you,\nThe Happy " . Config::get('site_name') . " Event Invitation Robot";
            $body .= "\n\nPS. You can turn these emails off at: " . $user->getUrl('.emailprefs', null, true);
            
            //html
            $html = $me->getName() . " has recently invited you to an event on " . Config::get('site_name') . ".<br/><br/>";
            $html .= "You can view the event, and RSVP ";
            $html .= $user->getTicket(strtolower(get_class($this)) . ".rsvp?id=$this->id", 'here.') . "<br/><br/>";
            $html .= "Thank you,<br/>The Happy " . Config::get('site_name') . " Event Invitation Robot";
            $html .= "<br/><br/>PS. You can turn these emails off " . $user->getLink(array('page' => 'emailprefs'), 'here.', null, true);
            $user->mail($subject, $body, $html);
        }
    }

    public function initViewPage()
    {
        global $me;

        //get our id..
        $this->id = $this->params('id');

        //init our page.
        parent::initViewPage();

        //title!
        $this->pageTitle = $this->getName();

        //guests only?
        if ($this->invite_only && !$this->isGuest($me->id))
            throw new PageError('Only guests are allowed to view this event.');
    }
    
    public function addInfoBox()
    {
        global $me;

        //get our info. 
        $s = "<p><b>Date:</b> " . $me->formatDate($this->start_date) . "</p>";
        if ($this->lat || $this->lon)
        {
            $s .= "<p><b>Location:</b>";
            
            //map link?
            if ($this->lat || $this->lon)
            {
                $s .= " (<a href=\"http://maps.google.com/maps?oi=map&q=";
                $s .= urlencode("$this->street, $this->city, $this->state $this->zip") . "\">map</a>)";
            }
            
            $s .= "<br/>";
            if ($this->location)
                $s .= "$this->location<br/>";
            if ($this->street)
                $s .= "$this->street<br/>";
            if ($this->city)
                $s .= "$this->city, $this->state, $this->zip";
            $s .= "</p>";
        } 
        $this->addBox(new BaseBox('Info', $s));
    }

    public function addGuestBox()
    {
        $s = '';
        $yesCount = 0;
        $maybeCount = 0;
        if (count($this->guests))
        {
            $s .= "<table width=\"100%\">";
            $s .= "<tr><th>Name</th><th>RSVP</th><th>Guests</th></tr>";
            foreach ($this->guests AS $key => $val)
            {
                $guest = new User($key);
                $s .= "<tr><td>";
                $s .= $guest->getName(true);
                
                if ($this->canUnInvite())
                    $s .= " " . $this->getLink(".uninvite?id=$this->id&guest_id=$guest->id", "x");
                
                $s .= "</td>";

                if ($val['commitment'] == '')
                    $commit = '???';
                else
                    $commit = $val['commitment'];

                if ($commit == 'yes')
                {
                    $yesCount += $val['guests'];
                    $yesCount++;
                }
                else if ($commit == 'maybe')
                {
                    $maybeCount += $val['guests'];
                    $maybeCount++;
                }
                
                $s .= "<td>$commit</td>";

                $s .= "<td align=\"center\">$val[guests]</td>";
                $s .= "</tr>";
            }

            $totalCount = $yesCount + $maybeCount;
            $s .= "</table>";
            
            $s .= "<p><b>$totalCount</b> total guests.<br/><b>$yesCount</b> yes and <b>$maybeCount</b> maybe.</p>";
        }
        else
            $s .= "No guests yet.<br/>";
        
        $s .= "<p>";
        if ($this->canInvite())
            $nav[] = $this->getLink(".invite?id=$this->id", "Invite more guests.");
        if ($this->canAttend())
            $nav[] = $this->getLink(".attend?id=$this->id", "Add me to the guests.");
        if ($this->isGuest($me->id))
            $nav[] = $this->getLink(".rsvp?id=$this->id", "Update my RSVP.");
        if ($this->canLeave())
            $nav[] = $this->getLink(".leave?id=$this->id", "Remove me from the guests.");
        $s .= implode("<br/>", $nav);
        $s .= "</p>";
        $this->addBox(new BaseBox('Guests', $s));
    }

    public function drawLine()
    {
        global $me;
        
        echo $this->getLink(".view?id=$this->id", $this->name) . " on " . $me->formatDate($this->start_date) . ". ";
        echo "Added by " . $this->creator->getName(true) . ".";
    }

    public function drawLocation($map = false)
    {
        if ($map)
            echo 'map';
        else
            echo $this->location;
    }

    public function getRssItem()
    {
        global $me;
        
        $rss = parent::getRssItem();

        $rss->title = $this->name . " (" . $me->formatDate($this->start_date) . ")";
        $rss->description = $this->description;

        return $rss;
    }
    
    public function getPublicData()
    {
        global $me;
        
        $data = parent::getPublicData();

        $data['name'] = $this->getName();
        $data['description'] = $this->description;
        $data['start_date'] = $me->formatDate($this->start_date);
        $data['end_date'] = $me->formatDate($this->end_date);
        $data['location'] = $this->location;
        $data['street'] = $this->street;
        $data['city'] = $this->city;
        $data['state'] = $this->state;
        $data['zip'] = $this->zip;
        $data['guests'] = $this->getGuestCount();
        
        return $data;
    }

    public function getName($link = false)
    {
        if ($link)
            return $this->getLink(".view?id=$this->id", $this->name);
        return $this->name;
    }

    public function getCreateFieldsArray()
    {
        $fields = parent::getCreateFieldsArray();

        $fields['name'] = "name varchar(255) default '' not null";
        $fields['description'] = "description text default '' not null";
        $fields['location'] = "location varchar(255) default '' not null";
        $fields['start_date'] = "start_date date default '' not null";
        $fields['end_date'] = "end_date date default '' not null";
        $fields['allow_attendees'] = "allow_attendees tinyint(2) default '' not null";
    
        return $fields;
    }

    public function getCreateIndexesArray()
    {
        $fields = parent::getCreateIndexesArray();

        $fields['start_date'] = "key(start_date)";
        $fields['end_date'] = "key(end_date)";

        return $fields;
    }
}
?>

---