var vLibreria = 'Páginas';
var objItem;
ExecuteOrDelayUntilScriptLoaded(getAllPage, "sp.js");
function fnExcelReport()
{
var tab_text="
";
var textRange; var j=0;
tab = document.getElementById('datatable'); // id of table
for(j = 0 ; j < tab.rows.length ; j++)
{
tab_text=tab_text+tab.rows[j].innerHTML+"
";
//tab_text=tab_text+"";
}
tab_text=tab_text+"
";
tab_text= tab_text.replace(/]*>|<\/A>/g, "");//remove if u want links in your table
tab_text= tab_text.replace(/]*>/gi,""); // remove if u want images in your table
tab_text= tab_text.replace(/]*>|<\/input>/gi, ""); // reomves input params
txtArea1.document.open("txt/html","replace");
txtArea1.document.write(tab_text);
txtArea1.document.close();
txtArea1.focus();
sa=txtArea1.document.execCommand("SaveAs",true,"Paginas.xls");
return (sa);
}
var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,'
, template = ''
, base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
, format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
return function(table, name) {
if (!table.nodeType) table = document.getElementById(table)
var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
window.location.href = uri + base64(format(template, ctx))
}
})()
function DropDown(el)
{
this.dd = el;
this.initEvents();
}
DropDown.prototype = {
initEvents : function() {
var obj = this;
obj.dd.on('click', function(event){
$(this).toggleClass('active');
event.stopPropagation();
});
}
}
$(function() {
var dd = new DropDown( $('#dd') );
$(document).click(function() {
// all dropdowns
$('.wrapper-dropdown-5').removeClass('active');
});
});
function CreateTable()
{
$('#datatable').dataTable( {
paging: false
//"pagingType": "full_numbers"
} );
}
function getAllPage()
{
var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");
var btnExcelIE = ''
var btnExcel = ''
if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
{
$('#btn_excel').html(btnExcelIE);
}
else
{
$('#btn_excel').html(btnExcel);
}
$("#noticiaLoading").show();
var context = new SP.ClientContext.get_current();
var web = context.get_web();
var list = web.get_lists().getByTitle(vLibreria);
var camlQuery = SP.CamlQuery.createAllItemsQuery();
objItem = list.getItems(camlQuery);
context.load(objItem);
context.executeQueryAsync(Function.createDelegate(this, this.getAllPageSuccess), Function.createDelegate(this, this.getAllPageFail));
}
function getAllPageSuccess(sender, args)
{
var Raiz;
if(window.location.toString().indexOf('x/SiteAssets') == -1)
{
Raiz = 0; //Demas sitios
}
else
{
Raiz = 1; //Sitio Principal
}
$("#datatable").empty();
var vtableHead = 'Páginas | Editor | Aprobador | Publicador |
';
$('#datatable').append(vtableHead);
var listItemEnumerator = objItem.getEnumerator();
while (listItemEnumerator.moveNext())
{
var oListItem = listItemEnumerator.get_current();
var vtitleUrl = oListItem.get_item('FileRef');
if (Raiz == 0)
{
var vTitle = vtitleUrl.split('/')[3];
vTitle = vTitle.split('.')[0];
}
else
{
var vTitle = vtitleUrl.split('/')[2];
vTitle = vTitle.split('.')[0];
}
var vEditor = '';
var vAprobador = '';
var vPublicador = '';
if(oListItem.get_item('Editores') == null)
{
vEditor ='Vacio';
}
else
{
for(var i=0; i < oListItem.get_item('Editores').length; i++)
{
vEditor += "" + oListItem.get_item('Editores')[i].get_lookupValue() + '
';
}
}
if(oListItem.get_item('Aprobador') == null)
{
vAprobador ='Vacio';
}
else
{
for(var i=0; i < oListItem.get_item('Aprobador').length; i++)
{
vAprobador += "" + oListItem.get_item('Aprobador')[i].get_lookupValue() + '
';
}
}
if(oListItem.get_item('Publicador') == null)
{
vPublicador ='Vacio';
}
else
{
for(var i=0; i < oListItem.get_item('Publicador').length; i++)
{
vPublicador += "" + oListItem.get_item('Publicador')[i].get_lookupValue() + '
';
}
}
if(vtitleUrl.toLowerCase().indexOf('delete') > -1)
{
//Contiene delete en el nombre del archivo.
}
else
{
var divHtml = ''+ vTitle +' | '+ vEditor +' | '+ vAprobador +' | '+ vPublicador +' |
';
$('#PagesBody').append(divHtml);
}
}
CreateTable();
var fd = document.URL.split("/");
//alert(fd.length);
if(fd.length == 5)
{
$('#sitio').append(" (Principal)");
}
else
{
$('#sitio').append(" ("+ fd[3]+")");
}
$("#btn_excel").show();
$("#noticiaLoading").hide();
}
function getAllPageFail(sender, args)
{
alert('Request failed (getAllPage).' + args.get_message() + '\n' + args.get_stackTrace());
}