<?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 readtableDB4($tbl){
        $conn = $this->connectDBBDD();
        $res = mysqli_query($conn,"SELECT * FROM ".$tbl." WHERE activo = 1;");
        while($cRow = mysqli_fetch_array($res)){
            $info[$cRow[0]] = $cRow[2];
        }
        $conn->close();
        //echo "<!--ASD\n";print_r($info);echo "-->";
        return $info;
    }
    public function readtableDB7($id,$tb1){
        $conn = $this->connectDBBDD();
        $a = 1;
        $str = "";
        $res = mysqli_query($conn,"SELECT * FROM ".$tb1." WHERE activo = 1 AND colaboradores LIKE '%,".$id."%';");
        while($cRow = mysqli_fetch_array($res)){
            $info[$a][1] = $cRow[0];
            $info[$a][2] = $cRow[2];
            $a++;
        }
        //$info[0][0] = $a;
        $conn->close();
        //$str = $str."<pre>".print_r($info)."</pre>";
        for($b = 1;$b < $a;$b++){
            $str = $str.'<tr><td><a href="/RIR/index.php/site/documento/id/'.$info[$b][1].'.html"><i class="fa fa-file-text-o" style="font-size: px; line-height:middle;"></i> '.$info[$b][2]."</a></td></tr>\n";
        }
        return $str;
    }
}
if(isset($colaboradores) && !empty($colaboradores)){
    /*foreach ($colaboradores as $key => $value) {
        echo '<li><i class="fa fa-caret-right" style="color: var(--main-cdmx); margin-right: 8px;"></i><a href="'.$this->createUrl('colaborador',array('id'=>$key)).'">'.$value.'</a></li>';
    }*/
    $colaboradores = Yii::app()->funciones->listaColaboradores();
    $tipocolaboradores = Yii::app()->funciones->readtableDB2("tbl_tipo_colaboladores");
    $tipocolaborador = Yii::app()->funciones->readtableDB3();
}
?>
<?php $baseDeDatos = new baseDeDatos(); ?>
<div class="row">
    <?php if($model->activo == 1){?>
        <div class="col-xs-12 col-sm-12 col-md-8 col-xl-8">
            <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12 margin-bottom-20 about-me" id="cName">
                <div class="pull-left"><h2><?php echo $model->nombre_completo?></h2><?php echo (isset($model->puesto) && !empty($model->puesto))? '<span>'.$model->puesto.'</span>' : ''; ?></div>
                <ul class="social-icons pull-right">
                    <?php
                    if(!empty($model->facebook)){
                        $face_url= preg_replace("/((http|https|www)[^\s]+)/", '<li><a href="$1" target="_blank" data-original-title="Facebook" class="rounded-x social_facebook"></a></li>', $model->facebook);
                        $face_url= preg_replace("/href=\"www/", 'href="http://www', $face_url);
                        echo $face_url;
                    }
                    if(!empty($model->twitter)){
                        $twitt_url= preg_replace("/((http|https|www)[^\s]+)/", '<li><a href="$1" target="_blank" data-original-title="Twitter" class="rounded-x social_twitter"></a></li>', $model->twitter);
                        $twitt_url= preg_replace("/href=\"www/", 'href="http://www', $twitt_url);
                        echo $twitt_url;
                    }
                    ?>
                </ul>
            </div>
            <div class="row about-me margin-bottom-40">
                <div class="col-md-4 md-margin-bottom-20">
                    <div class="box-shadow shadow-effect-2" style="/*width: 335px;height: 279px;*/"><center><img id="cImg" alt="" src="<?php echo Yii::app()->request->baseUrl?>/images/colaboradores/<?php echo $model->imagen ?>" class="img-responsive" style="border-radius:15px !important;"></center></div>
                    <br>
                    <?php echo (isset($model->tipo) && !empty($model->tipo))? '<h5>Secci&oacute;n:</h5><i class="fa fa-list-alt" style="color:var(--main-cdmx); margin-right: 8px;"></i>'.$tipocolaboradores[$model->tipo].'<br>' : '' ; ?>
                    <h5>Contacto:</h5>
                    <?php echo (isset($model->perfil_academico) && !empty($model->perfil_academico))? '<i class="fa fa-graduation-cap" style="color:var(--main-cdmx); margin-right: 8px;"></i><a href="'.$model->perfil_academico.'" target="_blank">Perfil académico</a><br>' : '' ; ?>
                    <?php echo (isset($model->correo) && !empty($model->correo))? '<i class="fa fa-envelope" style="color:var(--main-cdmx); margin-right: 8px;"></i><a href="mailto:'.$model->correo.'" >'.$model->correo.'</a><br>' : '' ; ?>
                    <?php /** /echo (isset($model->website) && !empty($model->website))? '<i class="fa fa-globe" style="color:var(--main-cdmx); margin-right: 8px;"></i><a href="'.$model->website.'" target="_blank">'.$model->website.'</a><br>' : '' ;/**/ ?>
                    <?php echo (isset($model->website) && !empty($model->website))? '<i class="fa fa-globe" style="color:var(--main-cdmx); margin-right: 8px;"></i><a href="//'.$model->website.'" target="_blank">'.$model->website.'</a><br>' : '' ; ?>
                    <?php echo (isset($model->otro) && !empty($model->otro))? '<i class="fa fa-at" style="color:var(--main-cdmx); margin-right: 8px;"></i><a href="'.$model->otro.'" target="_blank">'.$model->otro.'</a><br>' : '' ; ?>
                </div>
                <div class="col-md-8">
                    <?php echo $model->descripcion;?>
                </div>
            </div>
            <?php echo (isset($model->idyt) && !empty($model->idyt))? "<h5>Presentaci&oacute;n:</h5><center>".$model->idyt."</center>" : '' ; ?>
            <div class="post-image">
                <div class="post-heading"><h3></h3></div>
                <div><img src="" alt="" class="img-responsive" style="border-radius:15%; float:left; margin-right:20px; margin-bottom: 10px !important; width:215px" /></div>
                <div><br></div>
            </div>
        </div>
    <?php }else{ ?>
        <div class="col-xs-12 col-sm-12 col-md-8 col-xl-8"><div class="margin-20 about-me"><div class="pull-left"><h2>El perfil no se encuentra disponible.<br><br></h2></div></div></div>
    <?php } ?>
    <div class="col-xs-12 col-sm-4 col-md-4 col-xl-3">
        <div id="accordion-1" class="panel-group acc-v1">
            <div class="panel panel-default">
                <div class="panel-heading"><h4 class="panel-title"><a href="#collapse-One" data-parent="#accordion-1" data-toggle="collapse" class="accordion-toggle">Colaboradores</a></h4></div>
                <div class="panel-collapse collapse in" id="collapse-One">
                    <div class="panel-body">
                        <ul class="list-unstyled">
                            <?php
                            if(isset($colaboradores) && !empty($colaboradores)){
                                /*foreach ($colaboradores as $key => $value) {
                                    echo '<li><i class="fa fa-caret-right" style="color: var(--main-cdmx); margin-right: 8px;"></i><a href="'.$this->createUrl('colaborador',array('id'=>$key)).'">'.$value.'</a></li>';
                                }*/
                                /*$colaboradores = Yii::app()->funciones->listaColaboradores();
                                $tipocolaboradores = Yii::app()->funciones->readtableDB2("tbl_tipo_colaboladores");
                                $tipocolaborador = Yii::app()->funciones->readtableDB3();*/
                                if(!empty($tipocolaboradores)){
                                    foreach ($tipocolaboradores as $tid => $tnombre){
                                        if($tid == 0) continue;
                                        echo '<li style="border: 1px solid rgba(255,255,255,.85);background-color: #FFF;color: #000;font-weight:bold;padding:5px;">'.$tnombre.'</li>'."\n";
                                        foreach ($colaboradores as $id => $colaborador){
                                            if($tipocolaborador[$id] == $tid) echo '<li><i class="fa fa-caret-right" style="color: var(--main-cdmx); margin-right: 8px;"></i><a href="'. $this->createUrl('colaborador',array('id'=>$id)) .'">'.$colaborador[0].'</a></li>'."\n";
                                            else continue;
                                        }
                                    }
                                    foreach ($tipocolaboradores as $tid => $tnombre){
                                        if($tid == 0){
                                            echo '<li style="border: 1px solid rgba(255,255,255,.85);background-color: #FFF;color: #000;font-weight:bold;padding:5px;">'.$tnombre.'</li>'."\n";
                                            foreach ($colaboradores as $id => $colaborador){
                                                if($tipocolaborador[$id] == $tid) echo '<li><i class="fa fa-caret-right" style="color: var(--main-cdmx); margin-right: 8px;"></i><a href="'. $this->createUrl('colaborador',array('id'=>$id)) .'">'.$colaborador[0].'</a></li>'."\n";
                                                else continue;
                                            }
                                        }else break;
                                    }
                                }
                            }
                            ?>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php if($model->activo == 1){?>
        <div class="col-xs-12 col-sm-12 col-md-12 col-xl-12">
            <link href="/RIR/themes/admin/css/plugins/datatables/datatables.css" rel="stylesheet">
            <div class="portlet-body">
                <div class="table-responsive">
                    <table id="example-table" class="table table-striped table-bordered table-hover table-green">
                        <thead>
                        <tr><th><center>Art&iacute;culos relacionados</center></th></tr>
                        </thead>
                        <tbody><?php echo $baseDeDatos->readtableDB7($model->id_colaborador,"tbl_documentos"); ?></tbody>
                    </table>
                </div>
                <!-- /.table-responsive -->
            </div>
            <script type="text/javascript" src="/RIR/themes/site/plugins/jquery/jquery.min.js"></script>
            <script src="/RIR/themes/admin/js/plugins/datatables/jquery.dataTables.js"></script>
            <script src="/RIR/themes/admin/js/plugins/datatables/datatables-bs3.js"></script>
            <script>$('#example-table').DataTable();</script>
            <script>window.onload = function() {ScrollPage(document.getElementById("cName"));};</script>
        </div>
    <?php } ?>
</div>