<?php get_header(); ?>

        <br class="breakline"/>
		<?PHP echo do_shortcode('[displayimageslider slidername="main-page-image-slider" slidercategory="image-slider" header="" caption=""]'); ?>        
        
	</div><!-- header -->
    
    <div id="content">
            
        <div class="mainholder01">
        
			<div class="contentholder txtcenter txtclrwhite">
            	<?php
					/* Post Title: Bringing you Nature’s Legacy */
                	$post = get_post(10);
					echo '<h2>'. $post->post_title .'</h2><p>&nbsp; </p>';
					echo '<p>'. $post->post_content .'</p>';
				?>
            </div><!-- contentholder -->
            
            <div class="contentholder txtcenter txtclrblack bgwhite">
            	<?php
					/* Our Solutions */
					echo '<h2>Our Solutions</h2><p>&nbsp; </p>';

						$querystr = "SELECT DISTINCT wposts.*, wpostmeta.*
							FROM  $wpdb->posts wposts, 
								$wpdb->postmeta wpostmeta 
							WHERE wposts.ID = wpostmeta.post_id 
								AND wpostmeta.meta_key = 'product_solutions'
								AND wpostmeta.meta_value <> ''
								AND wposts.post_type = 'product'   
								GROUP BY wpostmeta.meta_value 
								ORDER BY wpostmeta.meta_value";
						$pageposts = $wpdb->get_results($querystr, OBJECT);
							
						if ($pageposts):
							$result = array();
							$array1 = array();
							$array2 = array(); 
							global $post;
							foreach ($pageposts as $post): 
								setup_postdata($post);
								$array1 = $array2;
								$array2 = array_merge($array1, get_field('product_solutions')); 
							endforeach;
						endif;

						wp_reset_postdata();
		
						$result = array_unique($array2);
						asort($result);
						foreach ($result as $value) {

							$solpost = new WP_Query(array('meta_key'=>'product_solutions', 'meta_value'=>$value, 'meta_compare'=>'LIKE', 'meta_key'=>'featured', 'meta_value'=>'1', 'meta_compare'=>'=','post_type' => 'product', 'post_status' => 'publish', 'orderby' => 'date', 'order' => 'DESC', 'posts_per_page' => 1));
							if( $solpost->have_posts() ) : while( $solpost->have_posts() ) : $solpost->the_post();
								$postId = get_the_ID();
								$postLink = get_permalink();
							endwhile; endif; 	
							wp_reset_postdata();	
								
							echo '<div class="solutionsholder"><a href="'.$postLink.'"><div class="solutions">
								<div class="solmain"><img src="http://dermoviva.com/me/wp-content/themes/dermoviva-en/images/solutions001.jpg" width="217" height="217"></div>
								<div class="solprod">';
								echo get_the_post_thumbnail($postId);
							echo '</div></div><p>'.$value.'</p></a></div>';						
							
						}

				?>
                <br class="breakline">
            </div><!-- contentholder -->
            
            <div class="contentholder txtcenter txtclrwhite">
            	<?php
					/* Post Title: Join DermoViva Family */
                	$post = get_post(15);
					echo '<h2>'. $post->post_title .'</h2><p>&nbsp; </p>';
					echo '<p>'. $post->post_content .'</p>';
				?>
            </div><!-- contentholder -->
            
            <br class="breakline"/>
            
            <div class="contentcol01">
            	<a href="<?php echo getLinkByTitle('Video Gallery'); ?>" class="bttn002 objaligncentral">Video Gallery</a>
                <img src="<?php the_field('main_image',51); ?>" />
            </div><!-- contentcol01 -->
            
            <div class="contentcol01">
            	<a href="<?php echo getLinkByTitle('Photo Gallery'); ?>" class="bttn002 objaligncentral">Photo Gallery</a>
                <img src="<?php the_field('main_image',53); ?>" />
            </div><!-- contentcol01 -->
            
             <br class="breakline"/>
        
        </div><!-- mainholder01 -->
        
    </div><!-- content -->       

<?php get_footer(); ?>
<!-- HOME -->