<?php
class agm_upcoming_by_sel_cats_widget extends WP_Widget {
	
	public function __construct() {
		parent::__construct(
	 		'agm_upcoming_by_sel_cats_widget',
			'- Next Parish Council Meeting Info for Selected Categories -',
			array( 'description' => __( 'Custom agenda &amp; minutes upcoming widget for selected categories.', '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'];
			$this->upcoming_agenda_minutes_by_cats( $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'] = $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'] );
		$instance['wid_number_of_meetings'] = absint($new_instance['wid_number_of_meetings']);
		return $instance;
	}
	
	public function get_agenda_category_selected( $sel_array = array() ){
		$ret = '';
		$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 ) {
				$checked = "";
				if(is_array($sel_array) and in_array($term->term_id, $sel_array)){
					$checked = "checked='checked'";
				}
				$ret .= '<label><input type="checkbox" class="checkbox" id="'.$this->get_field_id('wid_display_category').'" name="'.$this->get_field_name('wid_display_category[]').'" value="'.$term->term_id.'" '.$checked.'/>'.$term->name.'</label><br />';
			}
		}		
		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 = $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>
			<?php echo $this->get_agenda_category_selected( $wid_display_category );?>
		</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>
		<p>
		    <label for="<?php echo $this->get_field_id('wid_number_of_meetings'); ?>">
		        <?php _e('Number of upcoming meetings to show', 'custom-post-type-pdf-attachment'); ?>
		    </label>
		    <input class="tiny-text" type="number" min="1" max="100" step="1"
		        name="<?php echo $this->get_field_name('wid_number_of_meetings'); ?>"
		        id="<?php echo $this->get_field_id('wid_number_of_meetings'); ?>"
		        value="<?php echo !empty($instance['wid_number_of_meetings']) ? esc_attr($instance['wid_number_of_meetings']) : 1; ?>" />
		</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( !empty( $instance['wid_display_category'] ) ){
			$args['tax_query'] = array(
				array(
					'taxonomy' => 'agendas_minutes_category',
					'field'    => 'term_id',
					'terms'    =>  $instance['wid_display_category'],
					'operator' => 'IN',
				),
			);
		}
		
		$agenda_minutes_query = new WP_Query($args);
		return $agenda_minutes_query->found_posts;
	}

	public function upcoming_agenda_minutes_by_cats( $instance ){
		$max_meetings = isset($instance['wid_number_of_meetings']) ? absint($instance['wid_number_of_meetings']) : 1;
		$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, 'include' => $instance['wid_display_category'] ) );
		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() && $count < $max_meetings) {
   				$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;
				}

				// Retrieve the value of cpta_default_event_start_time from WordPress options
				$cpta_default_event_start_time = get_option('cpta_default_event_start_time');
				
				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("D j<\s\u\p>S</\s\u\p> 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">';
				    
				    // Remove any existing <br> tags and decode HTML entities
				    $cleaned_content = html_entity_decode(stripslashes($agenda_minutes_meeting_description));
				    $cleaned_content = str_replace(['<br>', '<br/>', '<br />'], "\n", $cleaned_content);
				    
				    // Split the content into paragraphs
				    $paragraphs = preg_split('/\R{2,}/', $cleaned_content, -1, PREG_SPLIT_NO_EMPTY);
				    
				    // Wrap each non-empty paragraph in <p> tags
				    $formatted_paragraphs = array_map(function($paragraph) {
				        $trimmed = trim($paragraph);
				        return !empty($trimmed) ? '<p>' . $trimmed . '</p>' : '';
				    }, $paragraphs);
				    
				    // Join the paragraphs and echo
				    echo implode("\n", array_filter($formatted_paragraphs));
				    
				    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>';
		}
	}
} 
add_action( 'widgets_init', function(){
	register_widget( "agm_upcoming_by_sel_cats_widget" );
} );