<?php
/*
Template Name: Home Page
*/

get_header();

$pubs = get_posts(array(
    'order' => 'DESC',
    'posts_per_page' => 4,
    'category' => 3
));

$news = get_posts(array(
    'order' => 'DESC',
    'posts_per_page' => 4,
    'category' => 4
));

global $wpdb;
$db = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST);
$banners = $db->get_results("SELECT * FROM bim_conference_banners WHERE banner_id=1", ARRAY_A);
$b = $banners[0];

?>

    <div id="home-splash">
        <h1>Insightful Analysis of<br/>Pancreatic Cysts</h1>
    </div>
    <div class="bg-spacing bg-gray" style="background-color: #EBEEF1;">

        <div class="container-fluid">
            <div class="row">
                <div class="col-12 col-md-4 col-lg-6">
	                <img src="/wp-content/themes/pancreaseq/assets/img/PancreaSeq-Animation-4.gif" style="display:block;max-width:100%;border-radius: 12px;margin-right:25px;margin-bottom:30px;" />
                </div>
                <div class="col-12 col-md-8 col-lg-6">
                    <?php
                    the_content();
                    ?>
                </div>
            </div>
        </div>
    </div>

    <div class="bg-spacing bg-dna">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <h1 class="blocky-head">Latest News</h1>
                    <div class="home-posts">
                        <?php foreach ($news as $post): ?>
                            <?php
                            $meta = get_post_meta($post->ID);
                            $isYouTube = !!strstr($post->post_content, 'youtube.com/watch');
                            $linkOut = !empty($meta['_links_to_target'][0]) ? $meta['_links_to_target'][0] === '_blank' : false;
                            ?>
                            <div class="home-post">
                                <div class="home-post-inner">
                                    <div class="home-post-title">
                                        <a href="/<?=$post->post_name?>" <?=($linkOut ? 'target="_blank"' : '')?>><?=$post->post_title?></a>
                                    </div>
                                    <div class="home-post-body">
										<?=apply_filters('the_content', $post->post_content)?>
	                                    </div>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    </div>
                </div>
            </div>
            <br/><br/>
            <br/><br/>
            <div class="row">
                <div class="col-12">
                    <h1 class="blocky-head">Latest Publications</h1>
                    <div class="home-posts">
                    <?php foreach ($pubs as $post): ?>
					<?php 
						$meta = get_post_meta($post->ID);
						$linkOut = $meta['_links_to_target'][0] === '_blank';
					?>
                        <div class="home-post">
                        <div class="home-post-inner">
                            <div class="home-post-title">
                            <a href="/<?=$post->post_name?>" <?=($linkOut ? 'target="_blank"' : '')?>><?=$post->post_title?></a>
                            </div>
                            <div class="home-post-body"><?=$post->post_excerpt?></div>
                        </div>
                        </div>
                    <?php endforeach; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php if ($b['active']==1): ?>
    <div class="bg-spacing-sm bg-red">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="show-banner">
                        <div>
                            <h1><?=$b['headline']?></h1>
                            <p><?=bim_format_conference_date($b['date_start'], $b['date_end'])?>
                                <?=(!empty($b['city']) ? ' - '.$b['city'] : '')?>
                                <?=(!empty($b['booth']) ? ' - Booth '.$b['city'] : '')?>
                            </p>
                            <?=(!empty($b['more_info']) ? '<p>'.$b['more_info'].'</p>' : '')?>
                        </div>
                        <div class="banner-button">
                            <a class="btn btn-primary" href="<?=$b['link']?>" target="_blank">More&nbsp;Info</a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php endif; ?>
    <?php
get_footer();