<?php

	/* Template Name: Selecta Archives */

	global $wpdb, $is_archive;

	$is_archive = "1";

	if(file_exists("../../../wp-blog-header.php")) :

		require_once("../../../wp-blog-header.php");

	endif;

	if($_GET["month"]) :

		$use_date = StrToDate("15/".$_GET["month"]."/".$_GET["year"]);

		echo $use_date;

	endif;

	//DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts  

	$fetch_archive = $wpdb->get_results("SELECT * FROM " . $wpdb->posts . " WHERE post_status='publish' AND post_type = 'post' GROUP BY $wpdb->posts.ID ORDER BY post_date DESC");

	$last_month = date("m Y", strtotime($fetch_archive[0]->post_date));

	get_header(); 

?>

<div id="content-container">

    <div id="archive-detail-1">

		<h2 class="post-section-title"><?php echo date("M Y", strtotime($fetch_archive[0]->post_date)); ?></h2>

        <div class="post-slider clearfix">

            <ul>

                <?php

                    $count = 0;

                    $month_count = 1;

                    $last_month = date("m Y", strtotime($fetch_archive[0]->post_date));

                    foreach($fetch_archive as $archive_data) :                    	

                        $get_post_video = get_post_meta($post->ID, "main_video", true);

                        $get_thumbnail = get_post_meta($archive_data->ID, "other_media", true);

                        $get_video_thumbnail = get_post_meta($archive_data->ID, "video_thumbnail", true);

                        $post_image = "";

                        if($get_thumbnail == "") :

                            $post_image =  fetch_post_image($archive_data->ID, "300", "2000");

                        endif;

                        $category_id = get_the_category($archive_data->ID);

                        $this_category = get_category($category_id[0]->term_id);

                        $this_category_link = get_category_link($category_id[0]->term_id);

                        $link = get_permalink($archive_data->ID);

                        if(date("m Y", strtotime($archive_data->post_date)) !== $last_month) :

                            $count = 1;

							$month_count++;

                        ?>

                                    </ul>

                                </div>

                            </div>

                            <div id="archive-detail-<?php echo $month_count; ?>" style="display: none;">

                            	<h2 class="post-section-title"><?php echo date("M Y", strtotime($archive_data->post_date)); ?></h2>

                                <div class="post-slider clearfix">

                                    <ul>

                        <?php elseif($count == 4) :

                            $count = 1;

                        ?>

                                </ul>

                            </div>

                            <div class="post-slider clearfix">

                                <ul>

                        <?php

                        else :	

                            $count++;

                        endif;

                        ?>

                        <li class="clearfix"<?php if($count == 4) : echo " class=\"last\""; endif; ?>>

                            <div class="container-header-light-normal"><span></span></div>

							<div class="container-light">

								<div class="thumbnail">

									<?php if ($get_video_thumbnail !== "") : ?>

										<img src="<?php bloginfo('template_directory'); ?>/functions/timthumb.php?src=<?php echo $get_video_thumbnail ?>&amp;h=&amp;w=300&amp;zc=1" alt="<?php echo $archive_data->post_title; ?>" />

									<?php elseif($get_thumbnail !== "") : ?>

										<img src="<?php echo bloginfo('template_directory'); ?>/functions/timthumb.php?src=<?php echo $get_thumbnail ?>&amp;w=300&amp;h=&amp;zc=1" alt="<?php echo $archive_data->post_title; ?>" />

									<?php  elseif ($post_image !== "") :

										echo $post_image; 

									elseif($get_post_video !== "") :

										$get_post_video = preg_replace("/(width\s*=\s*[\"\'])[0-9]+([\"\'])/i", "$1 190 $2", $get_post_video);

										$get_post_video = preg_replace("/(height\s*=\s*[\"\'])[0-9]+([\"\'])/i", "$1 137 $2", $get_post_video);

											echo $get_post_video;

									else : ?>

										<img src="<?php bloginfo('template_directory'); ?>/images/slider-test-vid.png" alt="<?php echo $archive_data->post_title; ?>" />

									<?php endif; ?>

								</div>

							</div>

                            <div class="container-footer-light-normal"><span></span></div>

                            <h3><a href="<?php echo get_permalink($archive_data->ID); ?>"><?php echo substr($archive_data->post_title, 0, 45); ?></a></h3>

                        </li>

                    <?php

                        $last_month = date("m Y", strtotime($archive_data->post_date));

                    endforeach;

                ?>

            </ul>

		</div>

	</div>

</div>

<?php get_footer(); ?>