Как эффективно использовать переговорные комнаты при помощи интернета вещей?

1) Modus is currently implemented using:
• TCP/IP over Ethernet
• Asynchronous serial transmission over various media (wire: RS-232, RS-485; fiber, radio, and so on)
• ModbusPLUS, a high speed token passing network.
Modbus defines a simple protocol data unit that is independent of the underlying communication layers. The mapping on specific buses or networks can introduce some additional fields on the application data unit. The protocol follows a client-server approach, where a client initiates a Modbus transaction to poll a server for data.

2) The typical workflow of the adapter is the following:
1. Read a certain file, based on a set of configuration parameters.
2. Go through the file content and extract valuable fields as instructed by an adapter parsing schema file.
3. Map such fields onto the concepts and entities of the Internet of Things Service (for example, device addressing metadata, measurements and so on), also based on the parsing schema file of the adapter.
4. Stream normalized data up to Internet of Things Core Service.
5. Remove the target file from its original location and, optionally, back it up into another folder.
The supported file formats are JSON, CSV, and binary. For binary, the file is transferred as a Base64 encoded string to the Internet of Things Core Service.

3) The Internet of Things Gateway integrates OPC UA Servers by acting as an OPC UA Client. The adapter can connect to the server to establish an OPC UA session; at first connection, the adapter browses the server address space and creates a corresponding device with a set of sensors. Then, it configures the retrieval of data, per two possible options:
• Periodic pull mode: the adapter polls the server for data on a periodic base, with a configurable polling interval
• Subscription mode: the adapter creates a subscription on the server nodes, to be notified by the server itself whenever the value of a node changes

4) SigFox is a French company employing a UNB-based (Ultra Narrow Band) radio technology to connect IoT devices to its network. It currently uses the ISM band on 868MHz (as defined by ETSI and CEPT) in Europe and on 902MHz in the US (as defined by the FCC), depending on specific regional regulations. To expand the service coverage area, SigFox has partnerships with several network operators around the world. By utilizing the UNB infrastructure provided by these partners, SigFox enables communication between devices operating the SigFox radio protocol and the SigFox cloud. In this context, the SigFox infrastructure acts as the transport layer which sends the data generated by the devices to the cloud. This layer is data-agnostic, meaning that it does not interpret the data but simply transfers it. Considering this, device manufacturers who install the SigFox firmware on their products can use the SigFox service to access their data, and a set of REST APIs to build applications based on this data. The graphic illustrates the SigFox network in a simplified way.

5) The data flow follows two routes:
• The Internet of Things Gateway issues a cyclic polling over all the devices, performing a complete MIB-WALK for each connected device.
• The Internet of Things Gateway receives traps from devices, if the devices are able to send the traps.

const http = require('http');
const hdb = require('hdb');

http.createServer(function (req, res) {
  
  if (req.method === 'POST') {
        let body = '';

    req.on('data', chunk => {
        body += chunk.toString(); // convert Buffer to string
    });

    req.on('end', () => {
        
		var data = JSON.parse(body);
		var id = data.id;
		var data = data.payload;
		var timestamp = data.TIMESTAMP; 

                              var vcap_services = JSON.parse(process.env.VCAP_SERVICES);
		  var db_cred = vcap_services["hana-db"];
		  var credentials = db_cred[0].credentials;
		  var port = credentials.port;
		  var host = credentials.host;
		  var crt = credentials.certificate;
		  
		  var client = hdb.createClient({
		  host     : host,
		  port     : port,
		  user     : 'user_name',
		  password : 'password',
		  useTLS: true
		  });
		  
		  client.on('error', function (err) {
		  console.error('Network connection error', err);
		  });
		  
		  console.log(client.readyState); // new
		  
		  client.connect(function (err) {
		  if (err) {
			return console.error('Error:', err);
		  }
		  console.log(client.readyState); // connected
		  });
		  
		  client.prepare('call NEW_EVENT (?, ?, ?)', function(err, statement){
		  if (err) {
			return console.error('Prepare error:', err);
		  }

		  statement.exec({ ID: id, PAYLOAD : data, TS: timestamp}, function(err, affectedRows)                    {
			if (err) {
			  return console.error('Exec error:', err);
			}
			console.log('Number of affected rows:', affectedRows);			
		  });
		  });
		  
		  res.write("OK");
		 
		  res.end();
	} 

renderer: function (oRM, oControl) {
		    var model;
		    var d;
		    var view = sap.ui.getCore().byId("samplecontainer---mainview");
		
		    if (!this.status)
		        this.status = {"door":"","motion":"","color":"#2bbc2d","busy":0};
		   
		    if (view != undefined)
		        model = view.getModel("DT1");
		    if (model != undefined){
		        d = JSON.parse(model.getJSON());
		        if (this.status){
    		        this.status.busy = d.busy;
    		        this.status.door = d.door;
    		        this.status.motion = d.motion;
    		        this.status.color = d.color;
		        }
		    }
			oRM.write("<div");
			oRM.writeControlData(oControl);
			oRM.write(">");
</spoiler>
			if (this.status.busy == 0){
		        oRM.write("<img id='iDT1' src='/iotex/images/room_empty.png' alt='Empty' height='64' width='70'>");
			} else {
			    oRM.write("<img id='iDT1' src='/iotex/images/room_booked.png' alt='Booked' height='64' width='70'>");
			}
		    oRM.write("<canvas id='cDT1' width='30' height='30'></canvas>");
			oRM.write("<script>");
			oRM.write("var canvas = document.getElementById('cDT1');");
            oRM.write("var context = canvas.getContext('2d');");
            oRM.write("var centerX = canvas.width / 2;");
            oRM.write("var centerY = canvas.height / 2;");
            oRM.write("var radius = 12;");
            oRM.write("context.beginPath();");
            oRM.write("context.arc(centerX, centerY, radius, 0, 2 * Math.PI, false);");
            if ((this.status.busy == 1)&&((this.status.door != 0)||(this.status.motion != 0))){
                oRM.write("context.fillStyle = '#f46e41';");//red
            } else {
                oRM.write("context.fillStyle = '#ffff00';"); //yellow
            }
            if (this.status.busy == 0){
                oRM.write("context.fillStyle = '#2bbc2d';"); //green
            }
            oRM.write("context.fill();");
            oRM.write("</script>");
			oRM.write("</div>");
		    
		}

$.ajax
                ({
                    type: "GET",
                    url: "/iotex/odatasource/rooms.xsodata/rooms?$format=json",
                    dataType: 'json',
                    async: false,
                    success: function (data, status){
        	            var aData = data.d.results;
        	            var UData = {Data: aData};
        	            room_model.setData(UData);
                    }
                });
            View.setModel(room_model,"Rooms");
            
            var oVizFrame = this.oVizFrame = this.getView().byId("idVizFrame");
            
            var oDataset = new sap.viz.ui5.data.FlattenedDataset({
        			dimensions : [{
        			        name : 'Time',
        				    value : "{Time}"}],
        			               
        			measures : [{
        				name : 'Usage',
        				value : '{Value}'} ],
        			             
        			data : {
        				path : "/Data"
        			}
		    });		
		
            oVizFrame.setDataset(oDataset);
            
            oVizFrame.setVizProperties({
			title:{
				text : "Статистика бронирования переговорной комнаты"
			},
            plotArea: {
            	colorPalette : ['#2bbc2d','#f46e41','#c5f442'],
            	drawingEffect: "glossy"
                }});
		
            var feedSize = new sap.viz.ui5.controls.common.feeds.FeedItem({
		      'uid': "size",
		      'type': "Measure",
		      'values': ["Usage"]
		    }), 
		    feedColor = new sap.viz.ui5.controls.common.feeds.FeedItem({
		      'uid': "color",
		      'type': "Dimension",
		      'values': ["Time"]
		    });
	
            oVizFrame.addFeed(feedSize);
		
            oVizFrame.addFeed(feedColor);

var datapiechart = {
                    			"Data" : []};
                            
                            var yellow = {"Time":"Abused","Value":data.yellow};
                            var red = {"Time":"Occupied","Value":data.red};
                            var green = {"Time":"Free","Value":data.green};
                            
                            datapiechart.Data.push(yellow);
                            datapiechart.Data.push(red);
                            datapiechart.Data.push(green);
                            
                            var mod = viz.getModel();
                            mod.setData(datapiechart);
                            viz.setModel(mod);