Good morning to the entire node red community, I am new to this, as you will see I am learning from node red, and of course I have a question, I have a template of an html table that I use to view some data from my mysql, and I want to convert those same table to pdf, but I can't make it take the range of data that I wanted, it only picks one row, does anyone have any idea how to make it go from html, as I say I'm still learning and it's part of my practice, I would like to know your opinions, greetings to all and a hug.
in case you want to review this is my flow:
[
{
"id": "619ad3d9eee698c2",
"type": "tab",
"label": "Flow 1",
"disabled": false,
"info": "",
"env": []
},
{
"id": "86e33cefbcccd463",
"type": "ui_date_picker",
"z": "619ad3d9eee698c2",
"name": "",
"label": "Inicio",
"group": "bd91d6d28d4a7275",
"order": 1,
"width": 0,
"height": 0,
"passthru": true,
"topic": "",
"topicType": "str",
"className": "",
"x": 110,
"y": 160,
"wires": [
[
"e1674f835c06592a",
"ac9359a706cb2172"
]
]
},
{
"id": "ac9359a706cb2172",
"type": "moment",
"z": "619ad3d9eee698c2",
"name": "",
"topic": "",
"input": "payload",
"inputType": "msg",
"inTz": "America/Bogota",
"adjAmount": "1",
"adjType": "days",
"adjDir": "subtract",
"format": "",
"locale": "es_ES",
"output": "payload",
"outputType": "msg",
"outTz": "America/Bogota",
"x": 340,
"y": 160,
"wires": [
[
"d1f1debeb2a4f7ec",
"63ed3bf3dc2e3de2"
]
]
},
{
"id": "d1f1debeb2a4f7ec",
"type": "debug",
"z": "619ad3d9eee698c2",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 510,
"y": 80,
"wires": []
},
{
"id": "e1674f835c06592a",
"type": "debug",
"z": "619ad3d9eee698c2",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 190,
"y": 80,
"wires": []
},
{
"id": "63ed3bf3dc2e3de2",
"type": "string",
"z": "619ad3d9eee698c2",
"name": "",
"methods": [
{
"name": "left",
"params": [
{
"type": "num",
"value": "10"
}
]
}
],
"prop": "payload",
"propout": "payload",
"object": "msg",
"objectout": "msg",
"x": 570,
"y": 160,
"wires": [
[
"cfa668d69d7677a5",
"647cbe381f9e49c8"
]
]
},
{
"id": "cfa668d69d7677a5",
"type": "debug",
"z": "619ad3d9eee698c2",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 770,
"y": 100,
"wires": []
},
{
"id": "647cbe381f9e49c8",
"type": "function",
"z": "619ad3d9eee698c2",
"name": "",
"func": "var date1= msg.payload;\nvar date2= date1 +\" 00:00:00\";\nglobal.set('Inicio',date2);\nmsg.payload=date2;\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 760,
"y": 160,
"wires": [
[]
]
},
{
"id": "271c2cc9be54b0ef",
"type": "ui_date_picker",
"z": "619ad3d9eee698c2",
"name": "",
"label": "Final",
"group": "bd91d6d28d4a7275",
"order": 2,
"width": 0,
"height": 0,
"passthru": true,
"topic": "",
"topicType": "str",
"className": "",
"x": 110,
"y": 220,
"wires": [
[
"8c684312f0964f72"
]
]
},
{
"id": "8c684312f0964f72",
"type": "moment",
"z": "619ad3d9eee698c2",
"name": "",
"topic": "",
"input": "payload",
"inputType": "msg",
"inTz": "America/Bogota",
"adjAmount": "1",
"adjType": "days",
"adjDir": "subtract",
"format": "",
"locale": "es_ES",
"output": "payload",
"outputType": "msg",
"outTz": "America/Bogota",
"x": 340,
"y": 220,
"wires": [
[
"a51d5f3b34a99682"
]
]
},
{
"id": "a51d5f3b34a99682",
"type": "string",
"z": "619ad3d9eee698c2",
"name": "",
"methods": [
{
"name": "left",
"params": [
{
"type": "num",
"value": "10"
}
]
}
],
"prop": "payload",
"propout": "payload",
"object": "msg",
"objectout": "msg",
"x": 570,
"y": 220,
"wires": [
[
"57d99656df049a0f"
]
]
},
{
"id": "57d99656df049a0f",
"type": "function",
"z": "619ad3d9eee698c2",
"name": "",
"func": "var date1= msg.payload;\nvar date2= date1 +\" 23:59:59\";\nglobal.set('Final',date2);\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 760,
"y": 220,
"wires": [
[]
]
},
{
"id": "a8a2a1a9e3f660ac",
"type": "debug",
"z": "619ad3d9eee698c2",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 710,
"y": 280,
"wires": []
},
{
"id": "65163045a5f2b7f2",
"type": "ui_button",
"z": "619ad3d9eee698c2",
"name": "",
"group": "bd91d6d28d4a7275",
"order": 8,
"width": 0,
"height": 0,
"passthru": false,
"label": "Filtrar",
"tooltip": "",
"color": "",
"bgcolor": "",
"className": "",
"icon": "",
"payload": "",
"payloadType": "str",
"topic": "",
"topicType": "str",
"x": 110,
"y": 340,
"wires": [
[
"ac970b42137fc67c"
]
]
},
{
"id": "a228b337854168ee",
"type": "comment",
"z": "619ad3d9eee698c2",
"name": "Ordenar Datos",
"info": "",
"x": 120,
"y": 40,
"wires": []
},
{
"id": "fc79d95366bd9799",
"type": "mysql",
"z": "619ad3d9eee698c2",
"mydb": "fb05e811b8b0da75",
"name": "",
"x": 490,
"y": 340,
"wires": [
[
"a8a2a1a9e3f660ac",
"4ba0e4585c7a12ae"
]
]
},
{
"id": "ac970b42137fc67c",
"type": "function",
"z": "619ad3d9eee698c2",
"name": "",
"func": "var from = global.get(\"Inicio\");\nvar to = global.get(\"Final\");\n\nmsg.topic = 'SELECT * FROM plc.trupal WHERE `Fecha` BETWEEN \"'+from+'\" AND \"'+to+'\";';\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 300,
"y": 340,
"wires": [
[
"fc79d95366bd9799"
]
]
},
{
"id": "4ba0e4585c7a12ae",
"type": "ui_template",
"z": "619ad3d9eee698c2",
"group": "4f96a77756f4ce93",
"name": "",
"order": 1,
"width": "24",
"height": "13",
"format": "<style>\n #history {\n font-family: \"Arial\";\n border-collapse: collapse;\n width: 100%;\n }\n \n #history td, #history th {\n border: 1px solid #ddd;\n padding: 8px;\n }\n #history tr:nth-child(even){background-color: #A8EEF8;}\n \n #history tr:hover {background-color: #40aeea;}\n \n #history th {\n padding-top: 12px;\n padding-bottom: 12px;\n text-align: center;\n background-color: #696969;\n color: white;\n }\n \n \n </style>\n \n <table id=\"history\" border=\"1\">\n <tr align=\"center\">\n \n <th>id</th>\n <th>Fecha</th>\n <th>OEE_ME</th>\n <th>RECHAZO</th>\n <th>ENERGIAT1</th>\n <th>ENERGIA_T2</th>\n <th>ENERGIAT3</th>\n <th>ENERGIAPROMEDIO</th>\n <th>ENERGIA_TOTAL_T</th>\n <th>ENERGIAACTUAL</th>\n \n </tr>\n <tbody>\n <tr align=\"center\" ng-repeat=\"row in msg.payload\">\n <td ng-repeat=\"item in row\" >{{item}}</td>\n </tr>\n </tbody>\n </table>\n \n ",
"storeOutMessages": true,
"fwdInMessages": true,
"resendOnRefresh": true,
"templateScope": "local",
"className": "",
"x": 680,
"y": 340,
"wires": [
[]
]
},
{
"id": "bd91d6d28d4a7275",
"type": "ui_group",
"name": "Produccion",
"tab": "4e037359f216eb68",
"order": 1,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "fb05e811b8b0da75",
"type": "MySQLdatabase",
"name": "",
"host": "127.0.0.1",
"port": "3306",
"db": "plc",
"tz": "",
"charset": "UTF8"
},
{
"id": "4f96a77756f4ce93",
"type": "ui_group",
"name": "Datos por Fecha",
"tab": "4e037359f216eb68",
"order": 3,
"disp": true,
"width": "24",
"collapse": true,
"className": ""
},
{
"id": "4e037359f216eb68",
"type": "ui_tab",
"name": "Trupal",
"icon": "dashboard",
"order": 16,
"disabled": false,
"hidden": false
}
]
