read csv-data and put it in an array

Perlchamp · May 2, 2020, 6:01 PM

i will have a look on it, though MERCI !

sdetweil · May 2, 2020, 7:55 PM

@Perlchamp one other thing, u need to start a timer for when the month changes, when the timer expires, send a CONFIG message to the node_helper and it will send the latest birthdays list and everything will recalculate

Perlchamp · May 2, 2020, 8:03 PM

hi sam, yes i thought about. in the moment this is the actually file, though there is code annotate and at the wrong place, … just so you don’t wonder … :

/* global Module */

/* Magic Mirror
 * Module: birthdaylist
 *
 * Author: perlchamp@gmx.net
 * Lizenz: MIT
 */

Module.register("birthdaylist", {
    // Default module config.
    defaults: {
	
	debugging: false,
	initialLoadDelay: 0,		// How many seconds to wait on a fresh start up.
					// This is to prevent collision with all other modules also
					// loading all at the same time. This only happens once,
					// when the mirror first starts up.
	dimmEntries: true,   		// true: dims entries and the associated 
					//       symbol when the date has expired.
					// false: delete entries and the associated 
					//        symbol when the date has expired.

	language: "de",			// needed for dateformatting
	updateDelay: 5		        // How many seconds after midnight before a refresh
				        // This is to prevent collision with other modules refreshing
				        // at the same time.
    },

    active_birthdays: {
		
    },


    init: function() {
	Log.log(this.name + " is in init!");
    },

    // Override start method
    start: function() {
	Log.log("Starting module: " + this.name);

	// set locale here, default: de
	moment.locale(config.language);

	// Calculate next midnight and add updateDelay
	var now = moment();
	this.midnight = moment([now.year(), now.month(), now.date() + 1]).add(this.config.updateDelay, "seconds");
	this.loaded = false;
	this.scheduleUpdate(this.config.initialLoadDelay * 1000);
    },

    loaded: function(callback) {
	Log.log(this.name + " is loaded!");
	callback();
    },

    // return list of other functional scripts to use, if any (like require in node_helper)
    getScripts: function () {
	return ["moment.js"];
    },
 
    // return list of stylesheet files to use if any
    getStyles: function() {
	return [this.data.path + "/css/bdl.css"];
    },

    // you can configure the heading of the list in config.js
    getHeader: function() {
	return this.data.header;
    },


    // messages received from other modules and the system (NOT from your node helper)
    // payload is a notification dependent data structure
    notificationReceived: function(notification, payload, sender) {
	// once everybody is loaded up
	if(notification === "ALL_MODULES_STARTED") {
	    // send our config to our node_helper
	    this.sendSocketNotification("CONFIG",this.config);
	}
	if (sender) {
	    Log.log(this.name + " received a module notification: " + notification + " from sender: " + sender.name);
	}
	else {
	    Log.log(this.name + " received a system notification: " + notification);
	}
    },
	
    // messages received from from your node helper (NOT other modules or the system)
    // payload is a notification dependent data structure, up to you to design between module and node_helper
    socketNotificationReceived: function(notification, payload) {
	if(notification === "JSONDATA") {

	    var self = this;
	    Log.log(this.name + " received a socket notification: " + notification + " - Payload: " + payload);
			
	    var now = moment();
	    var day_month = moment().format("DD");
	    
	    for(var birthday of payload) {
		// get 1st 5 chars of birthdate, thru month
		// we will use this as the key in the hash
		var birth_date = birthday.birth.substring(0,5);
				
		// get the birthday as a moment in this year, for comparing
		var birth_date_moment = moment(birth_date + now.year(),"DD.MMYYYY");

		// you can add days to a moment object and then compare 
		//     if the birthdate is before that date (and after now)
		//     so within the next xx days

		// if the date is the same or later, don't use time of day
		if(birth_date_moment.month() == now.month() ) {

		    // birthday is in this month
		    // check the hash if we've seen anything for today yet
		    // if we haven't see this date yet
		    if(this.active_birthdays[birth_date] == undefined) {
           
			// create the holder for its info (array of 
			//	names) in the hash
			this.active_birthdays[birth_date] = [];
		    }
			
		    // save the persons name on the list
		    self.active_birthdays[birth_date].push({'name':birthday.name, 
			'age': now.diff(moment(birthday.birth,'DD.MM.YYYY'), 'years') })
		}
	    }
     
	    // tell MM to call and get our content
	    self.updateDom();
	}     			
    },

    // system notification your module is being hidden
    // typically you would stop doing UI updates (getDom/updateDom) if the module is hidden
    suspend: function() {

    },

    // system notification your module is being unhidden/shown
    // typically you would resume doing UI updates (getDom/updateDom) if the module is shown
    resume: function() {

    },

    // this is the major worker of the module, it provides the 
    // 	   displayable content for this module
    getDom: function() {
	var self = this;
	var wrapper = document.createElement("div");
		
	// tell MM to call and get our content
	Log.log(JSON.stringify(this.active_birthdays))



	if ((moment() > this.midnight) || (!this.loaded)) {
	    var month = moment().month();
	    var year = moment().year();
//	    var monthName = moment().format("MMMM");
//	    var monthLength = moment().daysInMonth();

	    // tabelle erstellen
	    var wrapper = document.createElement("table");
	    wrapper.className = 'table';
	    wrapper.id = 'birthday-table';

	    // tabellenkopf erstellen
	    var tHeader = document.createElement("thead");
	    tHeader.className = "thead";
	    tHeader.id = "birthday-thead";

	    var headerTR = document.createElement("tr");
	    headerTR.className = "tr-head";
	    headerTR.id = "birthday-tr-head";			    

	    var headerTH = document.createElement("th");
	    headerTH.colSpan = "2";
	    headerTH.scope = "col";
	    headerTH.className = "th-head";
	    headerTH.id = "birthday-th-head";
	    headerTH.innerHTML = this.translate(this.config.title);
	    headerTR.appendChild(headerTH);
	    			
	    tHeader.appendChild(headerTR);
	    wrapper.appendChild(tHeader);
		    
	    // Create TFOOT section -- currently used for debugging only
	    var tFooter = document.createElement('tfoot');
	    tFooter.className = "tfoot";
	    tFooter.id = "birthday-tfoot";

	    var footerTR = document.createElement("tr");
	    footerTR.className = "tr-foot";
	    footerTR.id = "birthday-tr-foot";

	    var footerTD = document.createElement("td");
	    footerTD.colSpan ="2";
	    footerTD.className = "td-foot";
	    footerTD.id = "birthday-td-foot";
	    if (this.config.debugging) {
		footerTD.innerHTML = "Birthdaylist is currently in DEBUG mode!<br />Please see console log.";
	    }
	    else {
		footerTD.innerHTML = "";
	    }

	    footerTR.appendChild(footerTD);
	    tFooter.appendChild(footerTR);
	    wrapper.appendChild(tFooter);






	for(var birthday of Object.keys(this.active_birthdays)) {
	    for(var person of this.active_birthdays[birthday]) {
				
		var m=document.createElement('div');
				
		// create tour table row here				
		m.innerText = birthday + ' ' + person.name + ' age=' + person.age;
		wrapper.appendChild(m);					
	    }
	}
	
	// pass the created content back to MM to add to DOM.
	this.loaded = true;
	return wrapper;

/*
			
	    // Create TBODY section with day names
	    var eintraege = 3;
	    for (var i=1; i<=eintraege; i++) {
		var tBody = document.createElement("tBody");
		tBody.className = "tbody";
		tBody.id = "birthday-tbody";

		var bodyTR = document.createElement("tr");
		bodyTR.className = "tr-body";
		bodyTR.id = "birthday-tr-body";

		var bodyTDimage = document.createElement("td");
		bodyTDimage.className = "td-image";
		bodyTDimage.id = "birthday-td-image";
		bodyTDimage.innerHTML = "23";

		var bodyTD = document.createElement("td");
		bodyTD.className = "td-body";
		bodyTD.id = "birthday-td-body";
		bodyTD.innerHTML = "Bettina Zimmermann&nbsp;&nbsp;<span class=\"age-span\">46</span></br>Frank Dubiel&nbsp;&nbsp;<span class=\"age-span\">54</span></br>Jürgen Gruse&nbsp;&nbsp;<span class=\"age-span\">52</span>";


//		var bodyAgeSpan = document.createElement("span");
//		bodyAgeSpan.className = "age-span";
//		bodyAgeSpan.id = "birthday-age-span";
//		bodyAgeSpan.innerHTML = "&nbsp;&nbsp;46";
//		bodyTD.appendChild(bodyAgeSpan);
		

		bodyTR.appendChild(bodyTDimage);
		bodyTR.appendChild(bodyTD);
		tBody.appendChild(bodyTR);
		wrapper.appendChild(tBody);
	    }
*/	
    },
    
    scheduleUpdate: function(delay) {
	if (this.config.debugging) {
	    Log.log("= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =");
	    Log.log("Birthdaylist IS IN DEBUG MODE!");
	    Log.log("Remove 'debugging' option from config/config.js to disable.");
	    Log.log("Current moment(): " + moment() + " (" + moment().format("hh:mm:ss a") + ")");
	    Log.log("scheduleUpdate() delay set at: " + delay);
	}

	if (typeof delay !== "undefined" && delay >= 0) {
	    nextReload = delay;
	}

	if (delay > 0) {
	    // Calculate the time DIFFERENCE to that next reload!
	    nextReload = moment.duration(nextReload.diff(moment(), "milliseconds"));
	    if (this.config.debugging) {
		var hours = Math.floor(nextReload.asHours());
		var  mins = Math.floor(nextReload.asMinutes()) - hours * 60;
		var  secs = Math.floor(nextReload.asSeconds()) - ((hours * 3600 ) + (mins * 60));
		Log.log("  nextReload should happen at: " + delay + " (" + moment(delay).format("hh:mm:ss a") + ")");
		Log.log("                  which is in: " + mins + " minutes and " + secs + " seconds.");
		Log.log("              midnight set at: " + this.midnight + " (" + moment(this.midnight).format("hh:mm:ss a") + ")");
		Log.log("= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =");
	    }
	}

	var self = this;
	setTimeout(function() {
	    self.reloadDom();
	}, nextReload);

    },

    reloadDom: function() {
	if (this.config.debugging) {
	    Log.log("          Calling reloadDom()!");
	}

	var now = moment();
	if (now > this.midnight) {
	    this.updateDom(this.config.fadeSpeed * 1000);
	    this.midnight = moment([now.year(), now.month(), now.date() + 1]).add(this.config.updateDelay, "seconds");
	}

	var nextRefresh = moment([now.year(), now.month(), now.date(), now.hour() + 1]);
	this.scheduleUpdate(nextRefresh);
    }
    
});

and thanks agaibn for your time …

sdetweil · May 2, 2020, 8:09 PM

@Perlchamp awesome…

Perlchamp · May 2, 2020, 8:13 PM

thanks :-)
i although thought about to include a template, but first i want to figure out the html-stuff and the if … than -statements (people the same day, date passed, and so on …), but you see i’m on fire right now …

sdetweil · May 2, 2020, 8:14 PM

@Perlchamp cool… i did the age correction

Perlchamp · May 2, 2020, 8:16 PM

cool too :-) , so you still burn, too :-))

Perlchamp · May 2, 2020, 9:03 PM

hi sam, i know that the code of table is working (in testmodule). but can’t get objects in there. did look in dev-widow, but looks fine. in the terminal-window i see that objects have been handed over (node to module.js). this is the code for the body of the table:

	    // create TBODY section with day names
	    var tBody = document.createElement("tBody");
	    tBody.className = "tbody";
	    tBody.id = "birthday-tbody";
	    
	    for(var birthday of Object.keys(this.active_birthdays)) {
		for(var person of this.active_birthdays[birthday]) {
				
		    //var m = document.createElement('div');
				
		    // create looped row section
		    var bodyTR = document.createElement("tr");
		    bodyTR.className = "tr-body";
		    bodyTR.id = "birthday-tr-body";

		    var bodyTDimage = document.createElement("td");
		    bodyTDimage.className = "td-image";
		    bodyTDimage.id = "birthday-td-image";
		    bodyTDimage.innerHTML = birthday;

		    var bodyTD = document.createElement("td");
		    bodyTD.className = "td-body";
		    bodyTD.id = "birthday-td-body";
		    bodyTD.innerHTML = person.name + "<span class=\"age-span\">" + person.age + "</span>";
		    				
		    //m.innerText = birthday + ' ' + person.name + ' age=' + person.age;
		    //wrapper.appendChild(m);
		    
		    bodyTR.appendChild(bodyTDimage);
		    bodyTR.appendChild(bodyTD);
		    tBody.appendChild(bodyTR);
		    wrapper.appendChild(tBody);
		    
		}
	    }

what did i make wrong ?

Perlchamp · May 2, 2020, 9:10 PM

@Perlchamp said in read csv-data and put it in an array:

bodyTD.innerHTML = person.name + “” + person.age + “”;

should be:
bodyTD.innerHTML = person.name + span class = … + person.age + /span;

can’t send html tags here ? how i have to escape them here ?

sdetweil · May 2, 2020, 10:37 PM

@Perlchamp cannot escape tags here, long time complaint