<?php
class custom_agendas_minutes_upcoming_widget extends WP_Widget {
	
	public function __construct() {
		parent::__construct(
	 		'agendas_minutes_widget_upcoming',
			'- Next Parish Council Meeting Info -',
			array( 'description' => __( 'Custom agenda &amp; minutes upcoming widget', 'custom-post-type-pdf-attachment' ), )
		);
	 }
	public function widget( $args, $instance ) {
		if( $this->is_there_upcoming_events( $instance ) == 0 ){
			return;
		}
		extract( $args );
		$wid_title = apply_filters( 'widget_title', $instance['wid_title'] );
		echo $args['before_widget'];
		if ( ! empty( $wid_title ) )
			echo $args['before_title'] . $wid_title . $args['after_title'];
			if($instance[ 'wid_display_category' ] == 'all'){
				//$this->upcoming_agenda_minutes_all( $instance );
				$this->upcoming_agenda_minutes_any_category( $instance );
			} else {
				$this->upcoming_agenda_minutes( $instance );
			}
			
		echo $args['after_widget'];
	}
	public function update( $new_instance, $old_instance ) {
		$instance = array();
		$instance['wid_title'] = sanitize_text_field( $new_instance['wid_title'] );
		$instance['wid_display_post_title'] = sanitize_text_field( $new_instance['wid_display_post_title'] );
		$instance['wid_display_first_doc'] = sanitize_text_field( $new_instance['wid_display_first_doc'] );
		$instance['wid_display_third_docs'] = sanitize_text_field( $new_instance['wid_display_third_docs'] );
		$instance['wid_display_category'] = sanitize_text_field( $new_instance['wid_display_category'] );
		$instance['wid_display_calendar_button_link'] = sanitize_text_field( $new_instance['wid_display_calendar_button_link'] );
		$instance['wid_display_meeting_description_override'] = sanitize_text_field( $new_instance['wid_display_meeting_description_override'] );
		$instance['wid_display_hide_headline'] = sanitize_text_field( $new_instance['wid_display_hide_headline'] );
		return $instance;
	}
	
	public function get_agenda_category_selected( $sel = '' ){
		$ret = '';
		$agenda_terms = get_terms( array( 'taxonomy' => 'agendas_minutes_category', 'hide_empty' => false ) );
		if ( ! empty( $agenda_terms ) && ! is_wp_error( $agenda_terms ) ){
			$ret .= '<option value="">-</option>';
			$ret .= '<option value="all" '.($sel=='all'?'selected':'').'>All</option>';
			foreach ( $agenda_terms as $term ) {
				if( $sel == $term->term_id ){
					$ret .= '<option value="'.$term->term_id.'" selected>'.$term->name.'</option>';
				} else {
					$ret .= '<option value="'.$term->term_id.'">'.$term->name.'</option>';
				}
			}
		}		
		return $ret;	
	}
	
	public function form( $instance ) {
		$wid_title = '';
		if(!empty($instance[ 'wid_title' ])){
			$wid_title = esc_html($instance[ 'wid_title' ]);
		}
		if(!empty($instance[ 'wid_display_post_title' ])){
			$wid_display_post_title = esc_html($instance[ 'wid_display_post_title' ]);
		}
		if(!empty($instance[ 'wid_display_first_doc' ])){
			$wid_display_first_doc = esc_html($instance[ 'wid_display_first_doc' ]);
		}
		if(!empty($instance[ 'wid_display_third_docs' ])){
			$wid_display_third_docs = esc_html($instance[ 'wid_display_third_docs' ]);
		}
		if(!empty($instance[ 'wid_display_category' ])){
			$wid_display_category = sanitize_text_field($instance[ 'wid_display_category' ]);
		}
		if(!empty($instance[ 'wid_display_calendar_button_link' ])){
			$wid_display_calendar_button_link = sanitize_text_field($instance[ 'wid_display_calendar_button_link' ]);
		}
		if(!empty($instance[ 'wid_display_meeting_description_override' ])){
			$wid_display_meeting_description_override = sanitize_text_field($instance[ 'wid_display_meeting_description_override' ]);
		}
		if(!empty($instance[ 'wid_display_hide_headline' ])){
			$wid_display_hide_headline = sanitize_text_field($instance[ 'wid_display_hide_headline' ]);
		}
		?>
		<p>
			<label for="<?php echo $this->get_field_id('wid_title'); ?>"><?php _e('Title','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="text" name="<?php echo $this->get_field_name('wid_title');?>" id="<?php echo $this->get_field_id('wid_title');?>" value="<?php echo $wid_title;?>" class="widefat">
		</p>
        <p>
			<label for="<?php echo $this->get_field_id('wid_display_post_title'); ?>"><?php _e('Display meeting title','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="checkbox" name="<?php echo $this->get_field_name('wid_display_post_title');?>" id="<?php echo $this->get_field_id('wid_display_post_title');?>" value="Yes" <?php echo @$wid_display_post_title == 'Yes'?'checked="checked"':'';?>>
		</p>
        <p>
			<label for="<?php echo $this->get_field_id('wid_display_first_doc'); ?>"><?php _e('Check to display the meeting agenda','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="checkbox" name="<?php echo $this->get_field_name('wid_display_first_doc');?>" id="<?php echo $this->get_field_id('wid_display_first_doc');?>" value="Yes" <?php echo @$wid_display_first_doc == 'Yes'?'checked="checked"':'';?>>
		</p>
        <p>
			<label for="<?php echo $this->get_field_id('wid_display_third_docs'); ?>"><?php _e('Check to display the third column contents if they exist','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="checkbox" name="<?php echo $this->get_field_name('wid_display_third_docs');?>" id="<?php echo $this->get_field_id('wid_display_third_docs');?>" value="Yes" <?php echo @$wid_display_third_docs == 'Yes'?'checked="checked"':'';?>>
		</p>
        <p>
			<label for="<?php echo $this->get_field_id('wid_display_category'); ?>"><?php _e('Category','custom-post-type-pdf-attachment'); ?> </label>
        	<select type="select" name="<?php echo $this->get_field_name('wid_display_category');?>" id="<?php echo $this->get_field_id('wid_display_category');?>">
            	<?php echo $this->get_agenda_category_selected( $wid_display_category );?>
            </select>
		</p>
		<p>
			<label for="<?php echo $this->get_field_id('wid_display_hide_headline'); ?>"><?php _e('Hide headline','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="checkbox" name="<?php echo $this->get_field_name('wid_display_hide_headline');?>" id="<?php echo $this->get_field_id('wid_display_hide_headline');?>" value="Yes" <?php echo @$wid_display_hide_headline == 'Yes'?'checked="checked"':'';?>>
		</p>
		<p>
			<label for="<?php echo $this->get_field_id('wid_display_meeting_description_override'); ?>"><?php _e('Override meeting description','custom-post-type-pdf-attachment'); ?> </label>
			
			<textarea name="<?php echo $this->get_field_name('wid_display_meeting_description_override');?>" id="<?php echo $this->get_field_id('wid_display_meeting_description_override');?>" class="widefat"><?php echo @$wid_display_meeting_description_override;?></textarea>
		</p>
		<p>
			<label for="<?php echo $this->get_field_id('wid_display_calendar_button_link'); ?>"><?php _e('Calendar button link','custom-post-type-pdf-attachment'); ?> </label>
        	<input type="text" name="<?php echo $this->get_field_name('wid_display_calendar_button_link');?>" id="<?php echo $this->get_field_id('wid_display_calendar_button_link');?>" value="<?php echo @$wid_display_calendar_button_link;?>" class="widefat">
		</p>
		<?php 
	}
	
	public function is_there_upcoming_events( $instance ){
		
		$args = array( 
			'post_type' => 'agendas_minutes',
			'posts_per_page' => 1,
			'orderby' => 'meta_value',
			'meta_key' => 'agenda_minutes_date',
			'meta_type' => 'DATE',
			'order' => 'ASC',
			'meta_query' => array(
			'relation' => 'AND',
				array(
					'key'     => 'agenda_minutes_date',
					'value'   =>  date( 'Y-m-d' ),
					'type'    => 'DATE',
					'compare' => '>=',
				),
			),
		);

		if($instance[ 'wid_display_category' ] != 'all'){
			if( !empty( $instance['wid_display_category'] ) ){
				$args['tax_query'] = array(
					array(
						'taxonomy' => 'agendas_minutes_category',
						'field'    => 'term_id',
						'terms'    => array( $instance['wid_display_category'] ),
						'operator' => 'IN',
					),
				);
			}
		}
		
		$agenda_minutes_query = new WP_Query($args);
		return $agenda_minutes_query->found_posts;
	}
	
	public function upcoming_agenda_minutes( $instance ){
		$wid_display_first_doc = $instance['wid_display_first_doc'];
		$wid_display_third_docs = $instance['wid_display_third_docs'];
		$wid_display_calendar_button_link = $instance['wid_display_calendar_button_link'];
		$wid_display_meeting_description_override = $instance['wid_display_meeting_description_override'];
		$wid_display_hide_headline = $instance['wid_display_hide_headline'];
		
		$cpta_hide_first_column = get_option('cpta_hide_first_column');
		
		if( $instance['wid_display_category'] ){
			$cpta_default_event_desc = get_option('cpta_agendas_minutes_event_desc_'.$instance['wid_display_category']);
			$cpta_default_event_start_time = get_option('cpta_agendas_minutes_event_start_time_'.$instance['wid_display_category']);
		} else {
			$cpta_default_event_desc = get_option('cpta_default_event_desc');
			$cpta_default_event_start_time = get_option('cpta_default_event_start_time');
		}
		
		$args = array( 
			'post_type' => 'agendas_minutes',
			'posts_per_page' => 1,
			'orderby' => 'meta_value',
			'meta_key' => 'agenda_minutes_date',
			'meta_type' => 'DATE',
			'order' => 'ASC',
			'meta_query' => array(
			'relation' => 'AND',
				array(
					'key'     => 'agenda_minutes_date',
					'value'   =>  date( 'Y-m-d' ),
					'type'    => 'DATE',
					'compare' => '>=',
				),
			),
		);
		
		if( !empty( $instance['wid_display_category'] ) ){
			$args['tax_query'] = array(
				array(
					'taxonomy' => 'agendas_minutes_category',
					'field'    => 'term_id',
					'terms'    => array( $instance['wid_display_category'] ),
					'operator' => 'IN',
				),
			);
		}
		
		$agenda_minutes_query = new WP_Query($args);
		
		if ($agenda_minutes_query->have_posts() ) {
			while ($agenda_minutes_query->have_posts() ) {
				  $agenda_minutes_query->the_post();
				  $agenda_minutes_date = get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_date',true);
				  $agenda_minutes_meeting_description = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_meeting_description',true));
				  $agenda_minutes_time = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_time',true));
				  
				  if( $agenda_minutes_meeting_description == '' ){
				  	$agenda_minutes_meeting_description = $cpta_default_event_desc;
				  }

				  if($wid_display_meeting_description_override != ''){
					$agenda_minutes_meeting_description = $wid_display_meeting_description_override;
				  }
				  
				  if( $agenda_minutes_time == '' ){
				  	$agenda_minutes_time = $cpta_default_event_start_time;
				  }
				  
				  if( !empty( $instance[ 'wid_display_post_title' ] ) && $instance[ 'wid_display_post_title' ] == 'Yes' ){
				  	echo '<div class="document-wid-row">';
					echo '<strong>'.get_the_title().agm_get_note($agenda_minutes_query->post->ID).'</strong>';
					echo '</div>';
				  }
		
				  if( $agenda_minutes_date != '' and $wid_display_hide_headline != 'Yes'){
				  	echo '<div class="document-wid-row">';
					  	
						echo '<strong itemprop="headline">';
						echo 'The next '.get_the_title().' will be held on ' . date("l j<\s\up>S</\s\up> F, Y",strtotime($agenda_minutes_date));
						if( $agenda_minutes_time != '' ){
							echo ' at '.$agenda_minutes_time;
						}
						echo '</strong>';

					echo '</div>';
				  }
				  if( $agenda_minutes_meeting_description != '' ){
				  	echo '<div class="document-wid-row">';
					echo '<p>'.nl2br(stripslashes($agenda_minutes_meeting_description)).'</p>';
				  	echo '</div>';
				  }
				  
				  if( $wid_display_first_doc == 'Yes' ){

					  if( download_agendas_minutes_link($agenda_minutes_query->post->ID,1) ){
						$type = type_of_agendas_minutes($agenda_minutes_query->post->ID,1);
						if($type == 'file'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Download the agenda for this meeting: <span class="download-agenda">' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1,"Download the agenda for this meeting, held on " . date("l jS F, Y",strtotime($agenda_minutes_date))) . '</span></span>';
							echo '</div>';
						} else if($type == 'text'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span><strong>Note</strong>: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						} else if($type == 'link'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Link: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						}


						
					 }
				  }
				  
				  if( $wid_display_third_docs == 'Yes' ){
					  
					  if( download_agendas_minutes_link($agenda_minutes_query->post->ID,3) ){
						echo '<div class="document-wid-row download-agenda">';
						echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,3) . '</span>';
						echo '</div>';
					 }
					  
					  $more_files = get_post_meta($agenda_minutes_query->post->ID, 'cpt_pdf_agendas_minutes_additional_files3', true );
					  if( is_array( $more_files ) ){
							foreach( $more_files as $key2 => $value2 ){
								echo '<div class="document-wid-row download-agenda">';
								echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_more_file_link($agenda_minutes_query->post->ID,3,$key2) . '</span>';
								echo '</div>';
							}
						}		
				  }
				  
			}	
		} else {
			echo '<div class="document-wid-row">';
			echo '<p>'.__('No meetings scheduled','custom-post-type-pdf-attachment').'</p>';
			echo '</div>';
		}




		if($wid_display_calendar_button_link){
			echo '<div class="calendar-link-wrap">';
			echo '<a title="View the meeting calendar" href="'.$wid_display_calendar_button_link.'" class="calendar-link">'.__('Meeting calendar','custom-post-type-pdf-attachment').'</a>';
			echo '</div>';
		}
	}

	public function upcoming_agenda_minutes_any_category( $instance ){
		$wid_display_first_doc = $instance['wid_display_first_doc'];
		$wid_display_third_docs = $instance['wid_display_third_docs'];
		$wid_display_calendar_button_link = $instance['wid_display_calendar_button_link'];
		$wid_display_meeting_description_override = $instance['wid_display_meeting_description_override'];
		$wid_display_hide_headline = $instance['wid_display_hide_headline'];
		
		$cpta_hide_first_column = get_option('cpta_hide_first_column');
		$cpta_default_event_desc = get_option('cpta_default_event_desc');
		$cpta_default_event_start_time = get_option('cpta_default_event_start_time');

		$args = array( 
			'post_type' => 'agendas_minutes',
			'posts_per_page' => 1,
			'orderby' => 'meta_value',
			'meta_key' => 'agenda_minutes_date',
			'meta_type' => 'DATE',
			'order' => 'ASC',
			'meta_query' => array(
			'relation' => 'AND',
				array(
					'key'     => 'agenda_minutes_date',
					'value'   =>  date( 'Y-m-d' ),
					'type'    => 'DATE',
					'compare' => '>=',
				),
			),
		);
		
		$agenda_minutes_query = new WP_Query($args);
		
		if ($agenda_minutes_query->have_posts() ) {
			while ($agenda_minutes_query->have_posts() ) {
				  $agenda_minutes_query->the_post();
				  $agenda_minutes_date = get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_date',true);
				  $agenda_minutes_meeting_description = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_meeting_description',true));
				  $agenda_minutes_time = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_time',true));
				  
				  if( $agenda_minutes_meeting_description == '' ){
				  	$agenda_minutes_meeting_description = $cpta_default_event_desc;
				  }

				  if($wid_display_meeting_description_override != ''){
					$agenda_minutes_meeting_description = $wid_display_meeting_description_override;
				  }
				  
				  if( $agenda_minutes_time == '' ){
				  	$agenda_minutes_time = $cpta_default_event_start_time;
				  }
				  
				  if( !empty( $instance[ 'wid_display_post_title' ] ) && $instance[ 'wid_display_post_title' ] == 'Yes' ){
				  	echo '<div class="document-wid-row">';
					echo '<strong>'.get_the_title().agm_get_note($agenda_minutes_query->post->ID).'</strong>';
					echo '</div>';
				  }
		
				  if( $agenda_minutes_date != '' and $wid_display_hide_headline != 'Yes'){
				  	echo '<div class="document-wid-row">';
					  	
						echo '<strong itemprop="headline">';
						echo 'The next '.get_the_title().' will be held on ' . date("l j<\s\up>S</\s\up> F, Y",strtotime($agenda_minutes_date));
						if( $agenda_minutes_time != '' ){
							echo ' at '.$agenda_minutes_time;
						}
						echo '</strong>';

					echo '</div>';
				  }
				  if( $agenda_minutes_meeting_description != '' ){
				  	echo '<div class="document-wid-row">';
					echo '<p>'.nl2br(stripslashes($agenda_minutes_meeting_description)).'</p>';
				  	echo '</div>';
				  }
				  
				  if( $wid_display_first_doc == 'Yes' ){

					  if( download_agendas_minutes_link($agenda_minutes_query->post->ID,1) ){
						$type = type_of_agendas_minutes($agenda_minutes_query->post->ID,1);
						if($type == 'file'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Download the agenda for this meeting: <span class="download-agenda">' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1,"Download the agenda for this meeting, held on " . date("l jS F, Y",strtotime($agenda_minutes_date))) . '</span></span>';
							echo '</div>';
						} else if($type == 'text'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span><strong>Note</strong>: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						} else if($type == 'link'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Link: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						}


						
					 }
				  }
				  
				  if( $wid_display_third_docs == 'Yes' ){
					  
					  if( download_agendas_minutes_link($agenda_minutes_query->post->ID,3) ){
						echo '<div class="document-wid-row download-agenda">';
						echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,3) . '</span>';
						echo '</div>';
					 }
					  
					  $more_files = get_post_meta($agenda_minutes_query->post->ID, 'cpt_pdf_agendas_minutes_additional_files3', true );
					  if( is_array( $more_files ) ){
							foreach( $more_files as $key2 => $value2 ){
								echo '<div class="document-wid-row download-agenda">';
								echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_more_file_link($agenda_minutes_query->post->ID,3,$key2) . '</span>';
								echo '</div>';
							}
						}		
				  }
				  
			}	
		} else {
			echo '<div class="document-wid-row">';
			echo '<p>'.__('No meetings scheduled','custom-post-type-pdf-attachment').'</p>';
			echo '</div>';
		}

		if($wid_display_calendar_button_link){
			echo '<div class="calendar-link-wrap">';
			echo '<a title="View the meeting calendar" href="'.$wid_display_calendar_button_link.'" class="calendar-link">'.__('Meeting calendar','custom-post-type-pdf-attachment').'</a>';
			echo '</div>';
		}
	}

	public function upcoming_agenda_minutes_all( $instance ){
		$wid_display_first_doc = $instance['wid_display_first_doc'];
		$wid_display_third_docs = $instance['wid_display_third_docs'];
		$wid_display_calendar_button_link = $instance['wid_display_calendar_button_link'];
		$wid_display_meeting_description_override = $instance['wid_display_meeting_description_override'];
		$wid_display_hide_headline = $instance['wid_display_hide_headline'];
		
		$cpta_hide_first_column = get_option('cpta_hide_first_column');

		$agm_ids = array();
		$agenda_terms = get_terms( array( 'taxonomy' => 'agendas_minutes_category', 'hide_empty' => false ) );
		if ( ! empty( $agenda_terms ) && ! is_wp_error( $agenda_terms ) ){
			foreach ( $agenda_terms as $term ) {
										
				$args = array( 
					'post_type' => 'agendas_minutes',
					'posts_per_page' => 1,
					'orderby' => 'meta_value',
					'meta_key' => 'agenda_minutes_date',
					'meta_type' => 'DATE',
					'order' => 'ASC',
					'meta_query' => array(
					'relation' => 'AND',
						array(
							'key'     => 'agenda_minutes_date',
							'value'   =>  date( 'Y-m-d' ),
							'type'    => 'DATE',
							'compare' => '>=',
						),
					),
				);
				
				$args['tax_query'] = array(
					array(
						'taxonomy' => 'agendas_minutes_category',
						'field'    => 'term_id',
						'terms'    => array( $term->term_id ),
						'operator' => 'IN',
					),
				);

				$agenda_minutes_query = new WP_Query($args);
				
				if ($agenda_minutes_query->have_posts() ) {
					while ($agenda_minutes_query->have_posts() ) {
						$agenda_minutes_query->the_post();
						$agm_ids[] = $agenda_minutes_query->post->ID;
					}	
				}
				wp_reset_postdata();
			}
		}		


		
		$cpta_default_event_desc = get_option('cpta_default_event_desc');
			
		// new loop //
		$count = 0;

		$args = array( 
			'post_type' => 'agendas_minutes',
			'post__in' => $agm_ids,
			'orderby' => 'meta_value',
			'meta_key' => 'agenda_minutes_date',
			'meta_type' => 'DATE',
			'order' => 'ASC',
			'meta_query' => array(
			'relation' => 'AND',
				array(
					'key'     => 'agenda_minutes_date',
					'value'   =>  date( 'Y-m-d' ),
					'type'    => 'DATE',
					'compare' => '>=',
				),
			),
		);
		
		$agenda_minutes_query = new WP_Query($args);
		
		if ($agenda_minutes_query->have_posts() ) {
			while ($agenda_minutes_query->have_posts() ) {
				$agenda_minutes_query->the_post();
				
				$count++;

				// default meeting desc //
				$agm_categories = get_the_terms($agenda_minutes_query->post->ID, 'agendas_minutes_category');
				$this_agm_term = $agm_categories[0]->term_id;
				$cpta_default_event_desc = get_option('cpta_agendas_minutes_event_desc_'.$this_agm_term);
				// default meeting desc //

				$agenda_minutes_date = get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_date',true);
				$agenda_minutes_meeting_description = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_meeting_description',true));
				$agenda_minutes_time = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_time',true));
				
				if( $agenda_minutes_meeting_description == '' ){
					$agenda_minutes_meeting_description = $cpta_default_event_desc;
				}

				if($wid_display_meeting_description_override != ''){
					$agenda_minutes_meeting_description = $wid_display_meeting_description_override;
				}
				
				if( $agenda_minutes_time == '' ){
					$agenda_minutes_time = $cpta_default_event_start_time;
				}
				
				if( !empty( $instance[ 'wid_display_post_title' ] ) && $instance[ 'wid_display_post_title' ] == 'Yes' ){
					echo '<div class="document-wid-row">';
					echo '<strong>'.get_the_title().agm_get_note($agenda_minutes_query->post->ID).'</strong>';
					echo '</div>';
				}

				if( $agenda_minutes_date != '' and $wid_display_hide_headline != 'Yes'){
					echo '<div class="document-wid-row">';
						
						echo '<strong itemprop="headline">';
						echo 'The next '.get_the_title().' will be held on ' . date("l j<\s\up>S</\s\up> F, Y",strtotime($agenda_minutes_date));
						if( $agenda_minutes_time != '' ){
							echo ' at '.$agenda_minutes_time;
						}
						echo '</strong>';

					echo '</div>';
				}
				if( $agenda_minutes_meeting_description != '' ){
					echo '<div class="document-wid-row">';
					echo '<p>'.nl2br(stripslashes($agenda_minutes_meeting_description)).'</p>';
					echo '</div>';
				}
				
				if( $wid_display_first_doc == 'Yes' ){

					if( download_agendas_minutes_link($agenda_minutes_query->post->ID,1) ){
						$type = type_of_agendas_minutes($agenda_minutes_query->post->ID,1);
						if($type == 'file'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Download the agenda for this meeting: <span class="download-agenda">' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1,"Download the agenda for this meeting, held on " . date("l jS F, Y",strtotime($agenda_minutes_date))) . '</span></span>';
							echo '</div>';
						} else if($type == 'text'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span><strong>Note</strong>: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						} else if($type == 'link'){
							echo '<div class="document-wid-row download-agenda">';
							echo '<span>Link: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,1) . '</span>';
							echo '</div>';
						}


						
					}
				}
				
				if( $wid_display_third_docs == 'Yes' ){
					
					if( download_agendas_minutes_link($agenda_minutes_query->post->ID,3) ){
						echo '<div class="document-wid-row download-agenda">';
						echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_link($agenda_minutes_query->post->ID,3) . '</span>';
						echo '</div>';
					}
					
					$more_files = get_post_meta($agenda_minutes_query->post->ID, 'cpt_pdf_agendas_minutes_additional_files3', true );
					if( is_array( $more_files ) ){
							foreach( $more_files as $key2 => $value2 ){
								echo '<div class="document-wid-row download-agenda">';
								echo '<span>Download the supporting documents for this meeting: ' . download_agendas_minutes_more_file_link($agenda_minutes_query->post->ID,3,$key2) . '</span>';
								echo '</div>';
							}
						}		
				}


			}	
		}
		wp_reset_postdata();
		// new loop //

		if($count == 0){
			echo '<div class="document-wid-row">';
			echo '<p>'.__('No meetings scheduled','custom-post-type-pdf-attachment').'</p>';
			echo '</div>';
		}
		

		if($wid_display_calendar_button_link){
			echo '<div class="calendar-link-wrap">';
			echo '<a title="View the meeting calendar" href="'.$wid_display_calendar_button_link.'" class="calendar-link">'.__('Meeting calendar','custom-post-type-pdf-attachment').'</a>';
			echo '</div>';
		}
	}

	private function get_agenda_query($attr) {
	    $args = array( 
	        'post_type'      => 'agendas_minutes',
	        'posts_per_page' => 1,
	        'orderby'        => 'meta_value',
	        'meta_key'       => 'agenda_minutes_date',
	        'meta_type'      => 'DATE',
	        'order'          => 'ASC',
	        'meta_query'     => array(
	            'relation' => 'AND',
	            array(
	                'key'     => 'agenda_minutes_date',
	                'value'   => date('Y-m-d'),
	                'type'    => 'DATE',
	                'compare' => '>=',
	            ),
	        ),
	    );
	
	    if ($attr['cat']) {
	        $args['tax_query'][] = array(
	            'taxonomy' => 'agendas_minutes_category',
	            'field'    => 'term_id',
	            'terms'    => array($attr['cat']),
	            'operator' => 'IN',
	        );
	    }
	
	    if ($attr['excat']) {
	        $args['tax_query'][] = array(
	            'taxonomy' => 'agendas_minutes_category',
	            'field'    => 'term_id',
	            'terms'    => array($attr['excat']),
	            'operator' => 'NOT IN',
	        );
	    }
	
	    return new WP_Query($args);
	}
	
	public function upcoming_agenda_next_meeting_sc($attr) {
	    $agenda_minutes_query = $this->get_agenda_query($attr);
	
	    $cpta_default_event_start_time = '7:00pm';
	
	    if ($agenda_minutes_query->have_posts()) {
	        while ($agenda_minutes_query->have_posts()) {
	            $agenda_minutes_query->the_post();
	
				$agenda_minutes_date = get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_date',true);
				$agenda_minutes_meeting_description = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_meeting_description',true));
				$agenda_minutes_time = html_entity_decode(get_post_meta($agenda_minutes_query->post->ID,'agenda_minutes_time',true));
				$cpta_default_event_start_time = get_option('cpta_default_event_start_time');
				
				if( $agenda_minutes_meeting_description == '' ){
					$agenda_minutes_meeting_description = $cpta_default_event_desc;
				}

				if($wid_display_meeting_description_override != ''){
					$agenda_minutes_meeting_description = $wid_display_meeting_description_override;
				}
				
				if( $agenda_minutes_time == '' ){
					$agenda_minutes_time = $cpta_default_event_start_time;
				}

				echo '<div class="meeting-cntanier">';

					if($attr['url']){
						echo '<a href="'.$attr['url'].'"><span class="nc">Our next council meeting:</span><span class="mdeet">' . get_the_title() . '</span> on ' .  date("l j<\s\up>S</\s\up> F, Y",strtotime($agenda_minutes_date)) . ' at ' . $agenda_minutes_time. '</a>';
					} else {
						echo 'Our next council meeting is on: ' . get_the_title() . ' - ' .  date("l j<\s\up>S</\s\up> F, Y",strtotime($agenda_minutes_date));
					}
					
					echo '<div class="meeting-nfo"><span>'.nl2br(stripslashes($agenda_minutes_meeting_description)).'</span>';
					echo '<a href="/events">Meeting Calendar</a>';
					echo '</div>';

				echo '</div>';
	        }    
	    }
	    wp_reset_postdata();
	}
	
	public function agenda_button_sc($attr) {
	    $agenda_minutes_query = $this->get_agenda_query($attr);
	
	    if ($agenda_minutes_query->have_posts()) {
	        while ($agenda_minutes_query->have_posts()) {
	            $agenda_minutes_query->the_post();
	
	            $agenda_minutes_date = get_post_meta(get_the_ID(), 'agenda_minutes_date', true);
	            $download_url = file_agendas_minutes_download(get_the_ID(), 1);
	
	            // Output the link to download the agenda and the date only if download URL is not empty
	            if ($download_url) {
	                echo '<span class="agendadl"><a href="' . esc_url($download_url) . '" target="_blank">View the agenda for ' . get_the_title() . ', ' . date("l jS F, Y", strtotime($agenda_minutes_date)) . '</a></span>';
	            }
	        }    
	    }
	    wp_reset_postdata();
	}
} 
add_action( 'widgets_init', function(){
	register_widget( "custom_agendas_minutes_upcoming_widget" );
} );