<?php $titulocabecera = "Documentos";if(SYS_ADMIN_PLANTILLA){ ?>
<!-- begin PAGE TITLE ROW -->
<div class="row">
<div class="col-lg-12">
<div class="page-title">
<h1><?php echo $titulocabecera; ?></h1>
<ol class="breadcrumb">
<li><i class="fa fa-dashboard"></i> <a href="<?php echo $this->createUrl('dashboard/'); ?>">Dashboard</a></li>
<li class="active"><?php echo $titulocabecera; ?></li>
</ol>
</div>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<!-- end PAGE TITLE ROW -->
<?php }else{ ?>
<div class="row">
<div class="col-lg-12">
<h3 class="page-title" style="margin: 0 0 20px;"><?php echo $titulocabecera; ?><small></small></h3>
<div class="page-bar">
<ul class="page-breadcrumb">
<li><i class="fa fa-dashboard"></i><a href="<?php echo $this->createUrl('dashboard/'); ?>">Inicio</a><i class="fa fa-angle-right"></i></li>
<li><span><?php echo $titulocabecera; ?></span></li>
</ul>
</div>
</div>
</div>
<?php } ?>
<!-- begin ADVANCED TABLES ROW -->
<div class="row">
<div class="col-lg-12">
<a href="<?php echo $this->createUrl('tiposDocumentos/');?>"><button class="btn btn-default"><i class="fa fa-tag" style="margin-right:8px"></i>Tipos Documentos</button></a>
<a href="<?php echo $this->createUrl('create');?>"><button class="btn btn-<?php if(SYS_ADMIN_PLANTILLA){ echo "green"; }else{ echo "blue";} ?>"><i class="fa fa-plus" style="margin-right:8px"></i>Nuevo</button></a>
<div style = "margin:15px;"></div>
<div class="portlet portlet-default">
<div class="portlet-heading">
<div class="portlet-title"><h4><?php echo $titulocabecera; ?></h4></div>
<div class="clearfix"></div>
</div>
<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><?php echo Documentos::model()->getAttributeLabel('titulo') ?></th>
<th><?php echo Documentos::model()->getAttributeLabel('id_tipo') ?></th>
<th><?php echo Documentos::model()->getAttributeLabel('descripcion') ?></th>
<th><?php echo Documentos::model()->getAttributeLabel('descargas') ?></th>
<th><center>Autores / Colaboradores</center></th>
<th><center>Activo</center></th>
<th><center>Opciones</center></th>
</tr>
</thead>
<tbody><?php
class baseDeDatos{
public function connectDBBDD(){
$servername = "localhost";
$username = "root";
$password = "PkJXPQFykKLmS3cWhqmZKNYE";
$dbname = "RIR";
$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 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 .= "".substr(mysqli_fetch_array($res)[0],0,10).",<br>";
}
if($str == "") $str = "<center><i class=\"fa fa-plus\"></i> Añadir</center>";
$conn->close();
return $str;
}
public function readtableDB6($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;
}
}
$baseDeDatos = new baseDeDatos();
$idimg = 0; ?>
<?php if(isset($model) && !empty($model)){
foreach ($model as $item) { ?>
<?php
//$baseDeDatos -> readtableDB4("tbl_colaboladores");
//$baseDeDatos -> readtableDB5("tbl_documentos",$item->id_documento);
?>
<tr>
<td><?php if($item->archivo != ""){ ?><img src="<?php $idimg++;echo Yii::app()->request->baseUrl; ?>/images/loading001.gif" style="width:0px;" class="imgpdfv" id="idimgv<?php echo $idimg; ?>" data-file="<?php echo $item->archivo; ?>" data-name="<?php echo substr($item->archivo,0,-4); ?>" data-acti="<?php echo ($item->activo == 1)? '1': '0';?>" /><?php } ?>
<?php echo $item->titulo ?></td>
<td><?php echo $item->idTipo->nombre ?></td>
<td><?php echo Yii::app()->funciones->cortarString($item->descripcion,150)?></td>
<td><?php echo $item->descargas ?></td>
<td onClick="llamardocform(<?php echo $item->id_documento; ?>,'<?php echo $item->titulo ?>')" data-toggle="modal" data-target="#myModal" id="idscol<?php echo $item->id_documento; ?>"><?php echo $baseDeDatos -> readtableDB5("tbl_documentos",$item->id_documento,"tbl_colaboladores"); ?><!--<button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#myModal">Open Modal</button>--></td>
<td>
<span class="checkslide cambiarActivo"
url="<?php echo $this->createUrl('activo',array('id'=>$item->id_documento)) ?>"
name="<?php echo $item->titulo; ?>">
<input type="checkbox" <?php echo ($item->activo == 1)? 'checked': '';?>>
<label data-on="SI" data-off="NO"></label>
</span>
</td>
<td class="center">
<center>
<!--a href="<?php #echo $this->createUrl('/catalogoGalerias/create',array('id'=>$item->id_producto)) ?>" style="margin-right:15px;"><span><i class="fa fa-picture-o"></i></span></a-->
<a href="<?php echo $this->createUrl('update',array('id'=>$item->id_documento)) ?>" style="margin-right:15px;"><span><i class="fa fa-pencil"></i></span></a>
<!--a href="<?php #echo $this->createUrl('view',array('id'=>$item->id_documento)) ?>" ><span><i class="fa fa-eye"></i></span></a-->
<a href="javaScript:void(0)"
url="<?php echo $this->createUrl('delete',array('id'=>$item->id_documento)) ?>"
class="eliminarRegistro"
name="<?php echo $item->titulo ?>"
data-text = "<?php echo $item->titulo ?>" >
<span><i class="fa fa-trash"></i></span>
</a>
</center>
</td>
</tr>
<?php }
} ?>
</tbody>
</table>
</div>
<!-- /.table-responsive -->
</div>
<!-- /.portlet-body -->
</div>
<!-- /.portlet -->
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<!--se agrego-->
<!-- Modal -->
<div class="modal fade" id="myModal" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><!--×--><i class="fa fa-times"></i></button>
<h4 class="modal-title" id="modal-modal-title"></h4>
</div>
<div class="modal-body"><i class="fa fa-users"></i> Autores / Colaboradores</div>
<div class="modal-body" id="modal-modal-body"></div>
<div class="modal-footer">
<button type="button" class="btn btn-primary" data-dismiss="modal" id="kdjfasjinfciaenfds" onClick="javascript:datosfDocumentos(event);" disabled>Guardar</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
</div>
</div>
</div>
</div>
<!---- ><textarea id="dfsgsgsegsgsg"></textarea><!---->
<!---- ><img id="uploadPreview" /><!---->
<!---- ><a id="downloadimageasdasdasdad" href="#">Download PNG</a><!---->
<!---- ><a id="downloadimageasdasdasdad" href="#" style="display: none;"></a><!---->
<!---- ><canvas id="the-canvas" style="border:1px solid black"></canvas><!---->
<canvas id="the-canvas" style="display: none;"></canvas>
<script src="/RIR/js/pdf.js"></script>
<script src="/RIR/js/pdf.worker.js"></script>
<script>
<?php if(SYS_ADMIN_PLANTILLA){ ?>function bba(str){ return btoa(btoa(btoa(btoa(str)))); }
function bab(str){ return atob(atob(atob(atob(str)))); }<?php } ?>
function validate (input){if($(input).attr('type') == 'email' || $(input).attr('name') == 'email'){if($(input).val().trim().match(/^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{1,5}|[0-9]{1,3})(\]?)$/) == null){return false;}}else{if($(input).val().trim() == ''){return false;}}}
function showValidate(input){var thisAlert = $(input).parent();$(thisAlert).addClass('alert-validate');}
function hideValidate(input){var thisAlert = $(input).parent();$(thisAlert).removeClass('alert-validate');}
function datosfDocumentos(event){
//event.preventDefault();
var total = document.getElementById("ytDocumentos_colaboradores").value;
var tmp = 0;
var str = "*";
for(var a = 0;a <= total;a++){
if(document.getElementById("Documentos_colaboradores_"+a)){
tmp = document.getElementById("Documentos_colaboradores_"+a);
if(tmp.checked){
str = str+','+tmp.dataset.value;
}
}
}
/**/var documentosautor = " ";
if(document.getElementById("Documentos_autor").value == '') documentosautor = " ";
else documentosautor = document.getElementById("Documentos_autor").value;/**/
var dato01 = bba(document.getElementById("yiDocumentos_colaboradores").value);
var dato02 = bba(str);
var dato03 = bba(documentosautor);
var dato04 = bab("VjIwd05XVlhTbFJOV0VKcFdub3dPUT09");
var dato05 = bab(atob("VjFkMGFrNVhTblJTYkdoUFVrUkJPUT09"));
if(dato01 != ""){
//document.getElementById("contact2").innerHTML = '<span class="contact100-form-title">Enviando Mensaje...</span>';
//$('#kdjfasjinfciaenfds').prop('disabled', true);
var parametros = {"d1" : dato01,"d2" : dato02,"d3" : dato03,"d4" : dato04,"status" : dato05};
$.ajax({
data: parametros,url: '/RIR/autores.php?sefargzlskmgfoirmnfsoirnfoaeinfozeifnosefnzekxtghbxbgtg=adwdawdaefaefa.f8aef.46ae4fas8e4f.aef4.se4fsef.s8ef4es8f4d...-egser',type: 'post',
beforeSend: function (){ },
success: function (response){
document.getElementById("idscol"+document.getElementById("yiDocumentos_colaboradores").value).innerHTML = response;
//alert(response);
}
});
}
}
function llamardocform(id,titulo){//idscol#
document.getElementById("modal-modal-title").innerHTML = '<i class="fa fa-file-text"></i> '+titulo;
document.getElementById("modal-modal-body").innerHTML = '<center><img src="/RIR/images//ajax-loader-gears.gif"></center>';
var dato01 = bba(id),dato02 = bab("VjIwd05XVlhTbFJOV0VKcFdub3dPUT09"),dato03 = bab(atob("VjFkMGFrNVhTblJTYkdoUFVrUkJPUT09"));
if(dato01 != ""){
var parametros = {"d1" : dato01,"d2" : dato02,"status" : dato03};
$.ajax({
data: parametros,url: '/RIR/autores.php?sefargzxfkdjfkldsmflakdsmaskdmfaoivaostbxtghbxbgtg=adwdawd.edfa.waef5a6efaf.f1.f1aefa.aw4.f.ghe.4f.d...-egser',type: 'post',
beforeSend: function (){ },
success: function (response){
//alert(response);
if(response === ''){
document.getElementById("modal-modal-body").innerHTML = '<center><i class="fa fa-warning" style="font-size:50px;color:red;"></i><br>Intentelo mas tarde.</center>';
}else{
document.getElementById("modal-modal-body").innerHTML = '<div class="row"><div class="col-md-12"><div class="form-group">'+response+'</div></div></div>';
$('#kdjfasjinfciaenfds').prop('disabled', false);
}
}
});
}
}
function exists(file){
var http = new XMLHttpRequest();
http.open('HEAD',file,false);
http.send();
return http.status != 404;
}
function detalleimagen(file,id){
//$('#the-canvas').get(0).toDataURL("image/jpeg", 1)
//document.getElementById('dfsgsgsegsgsg').innerHTML = $('#the-canvas').get(0).toDataURL("image/jpeg", 1);
var img_b64 = $('#the-canvas').get(0).toDataURL("image/jpeg", 1);
var jpg = img_b64.split(',')[1];
/*var the_file = new Blob([window.atob(jpg)], {type: 'image/jpeg', encoding: 'utf-8'});
/*var fr = new FileReader();
fr.onload = function ( oFREvent ) {
var v = oFREvent.target.result.split(',')[1]; // encoding is messed up here, so we fix it
//alert(v);
v = atob(v);
var good_b64 = btoa(decodeURIComponent(escape(v)));
//document.getElementById("uploadPreview").src = "data:image/jpeg;base64," + good_b64;
};
fr.readAsDataURL(the_file);/**/
var dato01 = bba("*");
var dato02 = bba(file);
var dato03 = jpg;
var dato04 = bab("VjIwd05XVlhTbFJOV0VKcFdub3dPUT09");
var dato05 = bab(atob("VjFkMGFrNVhTblJTYkdoUFVrUkJPUT09"));
var parametros = {"d1" : dato01,"d2" : dato02,"d3" : dato03,"d4" : dato04,"status" : dato05};
/**/$.ajax({
data: parametros,url: '/RIR/imagenes.php?djfkndfnnfajnfaenflienfaleuh9348rj9o348w=jkfnawiejfa984ja98ifa98ij9w8aj39a8jeew8ja9ejapej983jr9i3fsieu3',type: 'post',
beforeSend: function (){ },
success: function (response){
//alert(response);
//alert(id);
if(document.getElementById(id)) document.getElementById(id).style.width = 0+"px";
}
});/**/
}
function extracimagepdf(id,fi,pd){
PDFJS.disableWorker = true;
PDFJS.getDocument(pd).then(function getPdfHelloWorld(pdf) {
pdf.getPage(1).then(function getPageHelloWorld(page) {
var scale = 0.28;//1.5
var viewport = page.getViewport(scale);
var canvas = document.getElementById('the-canvas');
var context = canvas.getContext('2d');
viewport.width = 125;/*125x158*/
viewport.height = 158;
canvas.width = viewport.width;
canvas.height = viewport.height;
//page.render({canvasContext: context, viewport: viewport});
var pageRendering = page.render({canvasContext: context, viewport: viewport});
var completeCallback = pageRendering._internalRenderTask.callback;
pageRendering._internalRenderTask.callback = function (error) {
completeCallback.call(this, error);
//$('#the-canvas').get(0).toDataURL("image/jpeg", 1)
detalleimagen(fi,id);
};
});
});
}
var asd = 0;
function imagenesindex(){
var t = <?php echo $idimg; ?>;
var ipv = document.getElementsByClassName("imgpdfv");
var pdfid = "",id = "",fi = "",im = "",pd = "",ac = "",di = "<?php echo Yii::app()->request->baseUrl."/documentos/"; ?>";
//Object.keys();
for(c = 0;c < ipv.length;c++){
if(document.getElementById(ipv[c].id)){
id = ipv[c].id;
fi = ipv[c].dataset.name;
ac = ipv[c].dataset.acti;
im = di+fi+'.jpg';
pd = di+ipv[c].dataset.file;
if(exists(im)){
//document.getElementById(id).src = im;
document.getElementById(id).style.width = 0+"px";
}else{
document.getElementById(id).style.width = 20+"px";
if((exists(pd)) && (ac == 1)){
//alert(fi+' , '+pd);
//if((asd == 0) && (id == 'idimgv43')){
asd = 1;
extracimagepdf(id,fi,pd);
//}
}
}
}
}
}
imagenesindex();
/*$("#downloadimageasdasdasdad").on('click', function() {
$(this).attr('href', $('#the-canvas').get(0).toDataURL("image/jpeg", 1)).attr('download', 'page.jpg');
//$("#downloadimageasdasdasdad").attr('href', $('#the-canvas').get(0).toDataURL("image/jpeg", 1)).attr('download', 'page.jpg');
});/**/
</script>
<!--/Se Agrego-->