Upcoming widget modification

<?php
if (!class_exists('Event_Espresso_Widget')) {

    class Event_Espresso_Widget extends WP_Widget {

        function Event_Espresso_Widget() {

            /* Widget settings. */

            $widget_options = array('classname' => 'events', 'description' => __('A widget to display your upcoming events.', 'event_espresso'));
            /* Widget control settings. */

            $control_options = array('width' => 300, 'height' => 350, 'id_base' => 'events-widget');
            /* Create the widget. */

            $this->WP_Widget('events-widget', __('Event Espresso Upcoming Events Widget', 'event_espresso'), $widget_options, $control_options);
        }

        function widget($args, $instance) {

            extract($args);

            global $wpdb, $org_options;
            /* Our variables from the widget settings. */

            $title = apply_filters('widget_title', $instance['title']);

            /* Before widget (defined by themes). */
            echo $before_widget;

            /* Display the widget title if one was input (before and after defined by themes). */
            if ($title)
                echo $before_title . $title . $after_title;

            if ($instance['category_name'] != '') {
                $type = 'category';
            }

            $event_page_id = $org_options['event_page_id'];

            $show_expired = $instance['show_expired'] == 'false' ? " AND (e.start_date >= '" . date('Y-m-d') . "' OR e.event_status = 'O' OR e.registration_end >= '" . date('Y-m-d') . "') " : '';
            $show_secondary = $instance['show_secondary'] == 'false' ? " AND e.event_status != 'S' " : '';
            $show_deleted = $instance['show_deleted'] == 'false' ? " AND e.event_status != 'D' " : '';
            $show_recurrence = $instance['show_recurrence'] == 'false' ? " AND e.recurrence_id = '0' " : '';
            $limit = $instance['limit'] > 0 ? " LIMIT 0," . $instance['limit'] . " " : ' LIMIT 0,5 ';
            //$order_by = $order_by != 'NULL'? " ORDER BY ". $order_by ." ASC " : " ORDER BY date(start_date), id ASC ";










            $order_by = " ORDER BY date(start_date), id ASC ";

            if (isset($type) && $type == 'category') {
                $sql = "SELECT e.*, c.category_name, c.category_name, c.category_desc, ese.start_time FROM " . EVENTS_CATEGORY_TABLE . " c ";
                $sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.cat_id = c.id ";
                $sql .= " JOIN " . EVENTS_DETAIL_TABLE . " e ON e.id = r.event_id ";
                $sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
                $sql .= " WHERE c.id = '" . $instance['category_name'] . "' ";
                $sql .= " AND e.is_active = 'Y' ";
            } else {
                $sql = "SELECT e.*, ese.start_time FROM " . EVENTS_DETAIL_TABLE . " e ";
                $sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
                $sql .= " WHERE e.is_active = 'Y' ";
            }
            $sql .= $show_expired;
            $sql .= $show_secondary;
            $sql .= $show_deleted;
            $sql .= $show_recurrence;
            $sql .= " GROUP BY e.id ";
            $sql .= $order_by;
            $sql .= $limit;











					/* Events */
		//Get number of total events
		$wpdb->query("SELECT id FROM ". EVENTS_DETAIL_TABLE ." WHERE event_status != 'D'");
		$total_events =    $wpdb->num_rows;

		//Get total events today
		$wpdb->query("SELECT id FROM ". EVENTS_DETAIL_TABLE ." WHERE event_status != 'D' AND start_date = '" . $curdate . "' ");
		$total_events_today =	$wpdb->num_rows;

        if ($total_events > 0) {

			$curdate = date("Y-m-d");
			/*$pieces = explode('-',$curdate, 3);
			$this_year_r = $pieces[0];
			$this_month_r = $pieces[1];
			//echo $this_year_r;
			$days_this_month = date('t', strtotime($curdate));*/

            $days_in_dasboard = $org_options['events_in_dasboard'] == ''? '30':stripslashes_deep($org_options['events_in_dasboard']);

		    $sql = "SELECT e.id event_id, e.event_name, e.event_identifier, e.reg_limit, e.registration_start, ";
            $sql .= " e.start_date, e.is_active, e.recurrence_id, e.registration_startT FROM ". EVENTS_DETAIL_TABLE ." e ";
            $sql .= " WHERE event_status != 'D' ";
           if ($total_events_today >0){
                $sql .= " AND start_date = '" . $curdate ."' ";
				global $how_many_events;
				$how_many_events = __('todays\' events', 'event_espresso');
            }else{
				$sql .= " AND ADDDATE('".date ( 'Y-m-d' )."', INTERVAL " . $days_in_dasboard . " DAY) >= start_date AND start_date >= '".date('Y-m-d', strtotime($curdate))."' ";
				global $how_many_events;
				$how_many_events = __("the next $days_in_dasboard days of events", 'event_espresso');
			}
				//$sql .= " WHERE event_status != 'D' AND start_date BETWEEN '".date('Y-m-d', strtotime($this_year_r. '-' .$this_month_r . '-01'))."' AND '".date('Y-m-d', strtotime($this_year_r . '-' .$this_month_r. '-' . $days_this_month))."' ";

		}








            $events = $wpdb->get_results($sql);

            //print_r($events);
            //event_espresso_get_event_details($sql);
            foreach ($events as $event) {
                $event->id = $event->id;
                $event->event_name = isset($event->event_name) ? $event->event_name : '';
                $event->start_date = isset($event->start_date) ? $event->start_date : '';
                $event->category_name = isset($event->category_name) ? $event->category_name : '';
                $event->category_desc = isset($event->category_desc) ? $event->category_desc : '';
                $event->externalURL = isset($event->externalURL) ? $event->externalURL : '';
                $registration_url = $event->externalURL != '' ? $event->externalURL : espresso_reg_url($event->id);

                $all_meta = array(
                    'is_active' => $event->is_active,
                    'event_status' => $event->event_status,
                    'event_address' => $event->address,
                    'event_address2' => $event->address2,
                    'registration_startT' => $event->registration_startT,
                    'registration_start' => $event->registration_start,
                    'registration_endT' => $event->registration_endT,
                    'registration_end' => $event->registration_end,
                    'start_date' => event_date_display($event->start_date, get_option('date_format')),
                    'start_time' => event_date_display($event->start_time, get_option('time_format')),
                    'end_date' => event_date_display($event->end_date, get_option('date_format')),
                );

                //Here we can create messages based on the event status

                $status = event_espresso_get_is_active($event->id, $all_meta);
                //Print out the array of event status options
                //print_r (event_espresso_get_is_active($event->id));

                $status_display = ' - ' . $status['display_custom'];
                $status_display_ongoing = $status['status'] == 'ONGOING' ? ' - ' . $status['display_custom'] : '';
                $status_display_deleted = $status['status'] == 'DELETED' ? ' - ' . $status['display_custom'] : '';
                $status_display_secondary = $status['status'] == 'SECONDARY' ? ' - ' . $status['display_custom'] : ''; //Waitlist event
                $status_display_reg_closed = $status['status'] == 'REGISTRATION_CLOSED' ? ' - ' . $status['display_custom'] : '';
                $status_display_not_open = $status['status'] == 'REGISTRATION_NOT_OPEN' ? ' - ' . $status['display_custom'] : '';
                $status_display_open = $status['status'] == 'REGISTRATION_OPEN' ? ' - ' . $status['display_custom'] : '';

                //You can also display a custom message. For example, this is a custom registration not open message:
                $status_display_custom_closed = $status['status'] == 'REGISTRATION_CLOSED' ? ' - <span class="espresso_closed">' . __('Regsitration is closed', 'event_espresso') . '</span>' : '';

                //End

                if (!is_user_logged_in() && defined('EVENTS_MEMBER_REL_TABLE') && !empty($member_only) && $member_only == 'Y') {
                    //Display a message if the user is not logged in.
                    //_e('Member Only Event. Please ','event_espresso') . event_espresso_user_login_link() . '.';
                } else {
                    //Serve up the event list
                    //As of version 3.0.17 the event list details have been moved to event_list_display.php
                    switch ($status['status']) {
                        case 'NOT_ACTIVE':
                            //Don't show the event if any of the above are true
                            break;

                        default:
                            ?>
                            <p><a href="<?php echo $registration_url; ?>"><?php echo stripslashes_deep($event->event_name) ?> - <?php echo event_date_display($event->start_date) ?></a>
                            <?php /* These are custom messages that can be displayed based on the event status. Just comment the one you want to use. */ ?>
                                <?php //echo $status_display; //Turn this on to display the overall status of the event.  ?>
                                <?php //echo $status_display_ongoing; //Turn this on to display the ongoing message. ?>
                                <?php //echo $status_display_deleted; //Turn this on to display the deleted message. ?>
                                <?php //echo $status_display_secondary; //Turn this on to display the waitlist message. ?>
                                <?php //echo $status_display_reg_closed; //Turn this on to display the secondary message. ?>
                                <?php //echo $status_display_not_open; //Turn this on to display the secondary message. ?>
                                <?php //echo $status_display_open; //Turn this on to display the secondary message. ?>
                                <?php //echo $status_display_custom_closed; //Turn this on to display the secondary message. ?>
                            </p>
                                <?php
                                break;
                        }
                    }
                }
                /* After widget (defined by themes). */
                echo $after_widget;
            }

            /* Update the widget settings. */

            function update($new_instance, $old_instance) {
                $instance = $old_instance;

                /* Strip tags for title and name to remove HTML (important for text inputs). */
                $instance['title'] = strip_tags($new_instance['title']);
                $instance['category_name'] = $new_instance['category_name'];
                $instance['show_expired'] = $new_instance['show_expired'];
                $instance['show_secondary'] = $new_instance['show_secondary'];
                $instance['show_deleted'] = $new_instance['show_deleted'];
                $instance['show_recurrence'] = $new_instance['show_recurrence'];
                $instance['limit'] = $new_instance['limit'];

                return $instance;
            }

            /**
             * Displays the widget settings controls on the widget panel.
             * Make use of the get_field_id() and get_field_name() function
             * when creating your form elements. This handles the confusing stuff.
             * */
            function form($instance) {

                /* Set up some default widget settings. */

                $defaults = array('title' => __('Upcoming Events', 'event_espresso'), 'category_name' => '', 'show_expired' => 'false', 'show_secondary' => 'false', 'show_deleted' => 'false', 'show_recurrence' => 'false');

                $instance = wp_parse_args((array) $instance, $defaults);

                $values = array(
                    array('id' => 'false', 'text' => __('No', 'event_espresso')),
                    array('id' => 'true', 'text' => __('Yes', 'event_espresso')));
                //select_input('allow_multiple', $values, $allow_multiple);
                ?>

            <!-- Widget Title: Text Input -->

            <p>
                <label for="<?php echo $this->get_field_id('title'); ?>">
            <?php _e('Title:', 'event_espresso'); ?>
                </label>
                <input id="<?php echo $this->get_field_id('title'); ?>" name="<?php echo $this->get_field_name('title'); ?>" value="<?php echo $instance['title']; ?>" size="20" type="text" />
            </p>
            <p> <label for="<?php echo $this->get_field_id('category_name'); ?>">
            <?php _e('Event Category:', 'event_espresso'); ?>
                </label><br />
                    <?php echo espresso_db_dropdown('id', 'category_name', EVENTS_CATEGORY_TABLE, 'id', $instance['category_name'], $strMethod = "desc", $this->get_field_name('category_name')) ?></p>
            <p>
                <label for="<?php echo $this->get_field_id('limit'); ?>">
                <?php _e('Limit:', 'event_espresso'); ?>
                </label>
                <input id="<?php echo $this->get_field_id('limit'); ?>" name="<?php echo $this->get_field_name('limit'); ?>" value="<?php echo $instance['limit']; ?>" size="3" type="text" />
            </p>
            <p><strong><?php _e('Optional Settings:', 'event_espresso'); ?></strong></p>
            <p><?php _e('Show Expired Events?', 'event_espresso'); ?> <?php echo select_input($this->get_field_name('show_expired'), $values, $instance['show_expired']); ?></p>
            <p><?php _e('Show Waitlist Events?', 'event_espresso'); ?> <?php echo select_input($this->get_field_name('show_secondary'), $values, $instance['show_secondary']); ?></p>
            <p><?php _e('Show Deleted Events?', 'event_espresso'); ?> <?php echo select_input($this->get_field_name('show_deleted'), $values, $instance['show_deleted']); ?></p>
            <p><?php _e('Show Recurring Events?', 'event_espresso'); ?> <?php echo select_input($this->get_field_name('show_recurrence'), $values, $instance['show_recurrence']); ?></p>

            <?php
        }

    }

}