<div class="row blog-page blog-item">
    <!-- Left Sidebar -->
    <div class="col-md-9 md-margin-bottom-60">
        <!--Blog Post-->
        <?php if($model->activo == 1){?>
            <?php

            class baseDeDatos{
                public function connectDBBDD(){
                    $servername = "localhost";
                    $username = "root";
                    $password = "PkJXPQFykKLmS3cWhqmZKNYE";
                    $dbname =   "PPD";
                    $conn = new mysqli($servername, $username, $password, $dbname);
                    $conn->set_charset("utf8");
                    if ($conn->connect_error) {
                        die("Connection failed: " . $conn->connect_error);
                    }
                    return $conn;
                    return 2;
                }
                public function readtableDB5($tbl,$id,$tb2){
                    $conn = $this->connectDBBDD();
                    $str = "";
                    $res = mysqli_query($conn,"SELECT colaboradores FROM ".$tbl." WHERE id_documento = ".$id.";");
                    $txt = mysqli_fetch_array($res)[0];
                    $ids = explode(",",$txt);
                    unset($ids[0]);
                    //return "<pre>".$txt."\n<br>".print_r($ids)."</pre>";
                    foreach($ids as $id){
                        $res = mysqli_query($conn,"SELECT nombre_completo FROM ".$tb2." WHERE id_colaborador = ".$id."");
                        //echo "<!--ASD\n";print_r(mysqli_fetch_array($res)[0]);echo "-->";
                        $str .= '<a href="'.Yii::app()->request->baseUrl.'/index.php/site/colaborador/id/'.$id.'.html">'.mysqli_fetch_array($res)[0].'</a>, ';
                        //$str .= '<a href="'.$this->createUrl('colaborador',array('id'=>$id)).'">'.mysqli_fetch_array($res)[0].'</a>, ';
                    }
                    $conn->close();
                    return $str;
                }
            }
            $baseDeDatos = new baseDeDatos();
            ?>
            <?php if(!empty($model->descripcion_tw)){} ?>
            <?php $sitio_url = urlencode("http://politicadedrogas.org".$_SERVER["REQUEST_URI"]); ?>
            <meta name="twitter:card" content="summary"></meta>
            <meta name="twitter:site" content="<?php echo urlencode("http://politicadedrogas.org"); ?>"></meta>
            <meta name="twitter:card" content="summary"></meta>
            <meta property="og:title" content="<?php echo  strip_tags($model->titulo); ?>"/>
            <meta property="og:type" content="article"/>
            <meta property="og:url" content="<?php echo  strip_tags($sitio_url); ?>"/>
            <!--<meta property="og:image" content=""/>-->
            <meta property="og:site_name" content="PPD"/>
            <meta property="og:description" content="<?php echo strip_tags($model->descripcion); ?>"/>
            <div class="blog margin-bottom-40">
                <h2><a href="javascript:void(0);"><?php echo $model->titulo; ?></a></h2>
                <div class="blog-post-tags">
                    <ul class="list-unstyled list-inline blog-info">
                        <!--li><i class="fa fa-calendar"></i> February 02, 2013</li-->
                        <li><i class="fa fa-pencil"></i> <?php echo $baseDeDatos -> readtableDB5("tbl_documentos",$model->id_documento,"tbl_colaboladores"); ?><?php echo $model->autor; ?></li>
                        <li><i class="fa fa-eye"></i> <a href="#"><?php echo $model->vistas?> </a></li>
                        <ul class="social-icons pull-right">
                            <li><a class="rounded-x social_twitter" target="_blank" href="https://twitter.com/intent/tweet?url=<?php echo $sitio_url; ?>&text=<?php echo $model->titulo; ?>&via=cideppd&related=cideppd,PPD,PoliticaDeDrogas"></a></li>
                            <li><a  class="rounded-x social_facebook" target="_blank" href="https://www.facebook.com/sharer/sharer.php?kid_directed_site=0&sdk=joey&u=<?php echo $sitio_url; ?>&display=popup&ref=plugin&src=share_button"></a></li>
                            <!--li><a href="#" data-original-title="Google Plus" class="rounded-x social_googleplus"></a></li>
                            <li><a href="#" data-original-title="Linkedin" class="rounded-x social_linkedin"></a></li-->
                        </ul>
                    </ul>
                    <ul class="list-unstyled list-inline blog-tags">
                        <li><i class="fa fa-tags"></i> <a href="/RIR/index.php/site/documentos/id/<?php echo $model->id_tipo; ?>.html"> <?php echo $model->idTipo->nombre; ?> </a></li>
                        <?php if(!empty($model->serie)){ ?><li><i class="fa fa-bookmark"></i> Serie: <?php echo $model->serie; ?></li><?php } ?>
                    </ul>
                </div>
                <?php if(!empty($model->url_issuu)){ ?>
                    <div class="blog-img"><center><?php echo $model->url_issuu?></center></div>
                    <div style="margin:20px;"></div>
                <?php } ?>
                <?php echo $model->descripcion; ?>
            </div>
            <?php if(!empty($model->url_youtube)) { ?><center><?php echo $model->url_youtube?></center><?php } ?>
            <?php if(!empty($model->archivo)) { ?><p style="font-size:15px;"><i class="fa fa-download"></i> Descarga el archivo <a href="<?php echo Yii::app()->request->baseUrl?>/documentos/<?php echo $model->archivo?>" target="_blank" onclick="downloaded(<?php echo $model->id_documento;?>)">aqu&iacute;</a></p><?php } ?>

        <?php }else{ ?>
            El documento no se encuentra disponible.
        <?php } ?>
        <!--End Blog Post-->
        <hr>
    </div>
    <!-- End Left Sidebar -->
    <!-- Right Sidebar -->
    <div class="col-md-3 magazine-page">
        <!-- Posts -->
        <div class="posts margin-bottom-40">
            <?php
            if(!empty($modelVisitas)){
                echo '<div class="headline headline-md"><h2>M&aacute;s Vistos</h2></div> <ul class="list-unstyled">';
                foreach ($modelVisitas as $item){
                    echo '<li><i class="fa fa-caret-right" style="color: #e74c3c; margin-right: 8px;"></i><a href="'.$this->createUrl('documento',array('id'=>$item->id_documento)).'" title="'.$item->titulo.'">'.Yii::app()->funciones->cortarString($item->titulo,80).'</a></li>';

                } //end foreach
                echo '</ul>';
            }
            ?>
        </div><!--/posts-->
        <!-- End Posts -->
        <!-- Posts -->
        <div class="posts margin-bottom-40">
            <?php
            if(!empty($modelRecientes)){
                echo '<div class="headline headline-md"><h2>M&aacute;s Recientes</h2></div><ul class="list-unstyled">';
                foreach ($modelRecientes as $item) {
                    echo '<li><i class="fa fa-caret-right" style="color: #e74c3c; margin-right: 8px;"></i><a href="'.$this->createUrl('documento',array('id'=>$item->id_documento)).'" title="'.$item->titulo.'">'.Yii::app()->funciones->cortarString($item->titulo,80).'</a></li>';
                } //end foreach
                echo '</ul>';
            }
            ?>
        </div><!--/posts-->
        <!-- End Posts -->
    </div>
    <!-- End Right Sidebar -->
</div>