Untitled

<!DOCTYPE html>
<html>
  <?php require_once("header.php"); ?>
  <body>
    <?php require_once("navbar.php"); ?>


    <div class="home-banner">
      <div class="container home-banner__container">
          <h1>Inefici&ecirc;ncia &eacute; coisa do passado</h1>
          <p class="text-white middle-area">Descubra como nossas solu&ccedil;&otilde;es em monitoramento inteligente geram valor para os neg&oacute;cios.</p>
      </div>
    </div>

    <div class="monitor-top">
      <div class="container monitor-top__container">
          <h2 class="text-gray">Monitoramento de<br>Gera&ccedil;&atilde;o Distribu&iacute;da / Energia Solar</h2>
      </div>
    </div>


    <div class="product-area">
      <div class="container product-area__container">
        <img src="assets/images/product-new.png" class="product-img">
        <p class="text-white product-area__container__p">
          Funciona com qualquer modelo de Inversor, incluindo microinversores! Nossa solu&ccedil;&atilde;o opera de forma independente do inversor, medindo diretamente a energia injetada e consumida da rede el&eacute;trica.
        </p>
        <p class="text-white product-area__container__p">
            Monitore todas as suas usinas, de maneira simples e intuitiva em uma &uacute;nica tela! Identifique problemas antes de seus clientes, fidelize e capture novas oportunidades de neg&oacute;cio.
        </p>
        <p class="text-white product-area__container__p">
            <a href="monitoramento" class="btn btn--border-white">Saiba mais</a>
            <a href="contato"  class="btn btn--primary pull-right">Adquira a Solu&ccedil;&atilde;o</a>
        </p>
      </div>
    </div>


    <div class="customize-area">
        <div class="container customize-area__container">
          <h2 class="text-white">Precisa de uma solu&ccedil;&atilde;o customizada para sua aplica&ccedil;&atilde;o?</h2>
          <p class="text-white customize-area__container__p">
              Podemos ajudar desde uma adapta&ccedil;&atilde;o de nosso produto, at&eacute; um desenvolvimento completo novo.
          </p>
          <p class="text-white customize-area__container__p">
              <a href="servicos" class="btn btn--border-white">Veja nossa experi&ecirc;ncia</a>
              <a href="contato" class="btn btn--border-white customize-area__container__button">Entre em contato</a>
          </p>
        </div>
    </div>


    <div class="posts">
      <?php
        $user = "gridyaco_blog";
        $password = "*Yvl[jWLEVO]";
        $host = "localhost";
        $db = "gridyaco_blog";

        // $user = "root";
        // $password = "";
        // $host = "localhost";
        // $db = "gridya";

        $con = new PDO("mysql:host=".$host.";dbname=".$db, $user, $password);

        $query = "SELECT wp_posts.id, wp_posts.post_date, files_ups.guid as main_image, wp_posts.post_excerpt, wp_posts.post_name, wp_posts.post_title, wp_posts.post_status, wp_posts.post_type FROM wp_posts LEFT JOIN (SELECT guid, post_type, post_parent FROM wp_posts WHERE post_type = 'attachment' GROUP BY post_parent) files_ups ON files_ups.post_parent = wp_posts.id WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC LIMIT 3";

        $creation = $con->prepare($query);
        $creation->execute();
      ?>
      <div class="container posts__container">
        <h2 class="text-white">Novidades</h2>
        <ul class="post-item-list">
          <?php foreach ($creation as $row) { ?>
            <li class="post-item-list__item">
              <span class="date-co"><?php echo date("d-m-Y H:i", strtotime($row["post_date"])); ?></span>
              <img src="<?php echo (($row['main_image'] != '') ?  $row['main_image'] : 'assets/images/gridya-post-main.jpg') ; ?>" class="post-item-list__image">
              <p class="text-title"><strong><?php echo utf8_encode($row["post_title"]); ?></strong></p>
              <p class="text-excerpt"><?php echo utf8_encode($row["post_excerpt"]); ?></p>
              <a class="btn btn--primary btn-xs" href="blog/<?php echo utf8_encode($row['post_name']); ?>">Ver +</a>
            </li>
          <?php }; ?>
        </ul>

        <a href="blog" class="btn btn--border-white">Ir para Blog</a>
      </div>
    </div>

    <?php require_once("footer.php"); ?>

    </div>
  </body>
</html>