123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146 |
- function aggiornaPages() {
- var jsonurl = weburl + "wp-json/wp/v2/pages/";
- $.ajax({
- dataType: "json"
- , url: jsonurl
- , success: function (data) {
- $.each(data, function (key, val) {
- var id = val.id;
- var time = val.modified;
- var title = val.title.rendered;
- var content = val.content.rendered;
- FONTE.dbHandler.executeSql('INSERT INTO xm24_pages VALUES (?,?,?,?)', [id, title, time, content], function (resultSet) {
- console.log('resultSet.insertId: ' + resultSet.insertId);
- console.log('resultSet.rowsAffected: ' + resultSet.rowsAffected);
- }, function (error) {
- console.log('INSERT error: ' + error.message);
- });
- });
- }
- , error: JSONErrorHandler
- });
- };
- function aggiornaSingleCategory(category) {
- //resetta la variabile d'errore per le chiamate ajax asincrone
- FONTE.ajaxError = false;
- var jsonurl = weburl + "wp-json/wp/v2/posts?per_page=100";
- var storage = window.localStorage;
- var lastUpdate = storage.getItem('db_update_date');
- if (lastUpdate) jsonurl += "&filter[date_query][column]=post_modified_gmt&filter[date_query][after]=" + lastUpdate;
- getSinglePageRecur(jsonurl, category, 1)
- };
- function aggiornaTagsToPosts(id, tagId) {
- FONTE.dbHandler.executeSql('INSERT INTO xm24_tags_to_posts VALUES (?,?)', [id, tagId], function (resultSet) {
- console.log('resultSet.insertId: ' + resultSet.insertId);
- console.log('resultSet.rowsAffected: ' + resultSet.rowsAffected);
- }, function (error) {
- console.log('INSERT error: ' + error.message);
- //feedback
- $("#aggiorna").attr("src", "./image/aggiorna.png");
- });
- }
- function aggiornaTags(pagenum) {
- var jsonurl = weburl + "wp-json/wp/v2/tags?per_page=100&page=" + pagenum;
- $.ajax({
- dataType: "json"
- , url: jsonurl
- , success: function (data, status, xhr) {
- var totalPages = parseInt(xhr.getResponseHeader("X-WP-TotalPages"));
- $.each(data, function (key, val) {
- var name = val.name;
- var slug = val.slug;
- var id = val.id;
- var blob = JSON.stringify(val);
- FONTE.dbHandler.executeSql('INSERT INTO xm24_tags VALUES (?,?,?)', [id, slug, blob], function (resultSet) {
- console.log('resultSet.insertId: ' + resultSet.insertId);
- console.log('resultSet.rowsAffected: ' + resultSet.rowsAffected);
- }, function (error) {
- console.log('INSERT error: ' + error.message);
- });
- });
- pagenum += 1
- if (pagenum <= totalPages) aggiornaTags(pagenum)
- }
- , error: JSONErrorHandler
- });
- };
- function aggiornaora() {
- $("#aggiornaora").popup("open");
- };
- function resetAndUpdate() {
- var storage = window.localStorage;
- //resetto la data e droppo le tabelle
- storage.setItem('db_update_date', null);
- FONTE.dbHandler.executeSql('DROP TABLE IF EXISTS xm24_posts;');
- FONTE.dbHandler.executeSql('CREATE TABLE IF NOT EXISTS xm24_posts (id INTEGER PRIMARY KEY, title, date, category, post)');
- partialUpdate();
- }
- function update() {
- FONTE.dbHandler.executeSql('SELECT COUNT(*) AS numPosts FROM xm24_posts', [], function (resultSet) {
- var numPosts = resultSet.rows.item(0).numPosts;
- if (numPosts < 300) { //questo numero e' scelto in maniera arbitraria, ricordati Cri.
- resetAndUpdate()
- } else {
- partialUpdate();
- }
- });
- }
- function partialUpdate() {
- //feedback
- $("#aggiorna").attr("src", "./image/icona_aggiorna.gif");
- var storage = window.localStorage;
- var jsonurl = weburl + "wp-json/wp/v2/posts?per_page=100&categories=";
- FONTE.updatedCategoriesCount = 0;
- FONTE.updatedPostsCount = 0;
- FONTE.neededPostsCount = 0;
- for (var index in FONTE.categoriesList) {
- aggiornaSingleCategory(FONTE.categoriesList[index])
- }
- FONTE.dbHandler.executeSql('DROP TABLE IF EXISTS xm24_tags;');
- // FONTE.dbHandler.executeSql('DROP TABLE IF EXISTS xm24_tags_to_posts;');
- FONTE.dbHandler.executeSql('DROP TABLE IF EXISTS xm24_pages;');
- FONTE.dbHandler.executeSql('CREATE TABLE IF NOT EXISTS xm24_tags (id INTEGER PRIMARY KEY, title, tag)');
- // FONTE.dbHandler.executeSql('CREATE TABLE IF NOT EXISTS xm24_tags_to_posts (id, tagid)');
- FONTE.dbHandler.executeSql('CREATE TABLE IF NOT EXISTS xm24_pages (id INTEGER PRIMARY KEY, title, date, page)');
- aggiornaTags(1);
- aggiornaPages();
- var firstTime = storage.getItem('db_lastnews_firsttime');
- if (firstTime == null) storage.setItem('db_lastnews_firsttime', 'yes');
- if (firstTime == 'yes') storage.setItem('db_lastnews_firsttime', 'no');
- $("#benvenuta").popup("close");
- checkloader();
- };
- /*
- * data ultimo aggiornamento
- */
- function ultimoAggiornamento() {
- var lastUpdate = window.localStorage.getItem('db_update_date');
- if (lastUpdate) {
- var data = lastUpdate.split('T');
- var datagiorno = data[0];
- var dataora = data[1];
- $("#datadiritti").empty();
- $("#datadirittiora").empty();
- display_results("#datadiritti", datagiorno)
- display_results("#datadirittiora", dataora)
- if (data) {
- $("#boxdata").css("display", "block");
- }
- } else {
- toastr.warning('Warn: manca la data del tuo ultimo aggiornamento. Aggiorna al più presto.');
- }
- };
|