Интеграция в ЖКХ

home

Как было заявлено, информация с территориально распределенных модулей IoT-AQUA поступает на сервер aqualeak.ru, где аккумулируется в единой базе данных. Эту информацию можно легко использовать для построения пользовательских (дилерских) информационно-аналитических систем и/или использовать в информационно-расчетных системах ЖКХ. Для извлечения данных нужно отправить HTTP-запрос. Сервер формирует ответ в формате JSON:

1. Запрос самых свежих данных IoT-модуля c id=5CCF7F1230F4
http://aqualeak.ru/?id=5CCF7F1230F4&json=1
{"id":"5CCF7F1230F4","ch1":"123795","ch2":"9061","ch01":"36910","ch02":"14640","batt":"57","timestamp":"2017-10-17 19:18:55"}
2. Запрос данных IoT-модуля c id=5CCF7F1230F4 по состоянию на 2017-08-01 00:00:00
http://aqualeak.ru/?id=5CCF7F1230F4&json=1&date=2017-08-01
{"id":"5CCF7F1230F4","ch1":"108970","ch2":"4276","ch01":"22085","ch02":"9855","batt":"76","timestamp":"2017-07-31 22:03:36"}
3. Запрос всех данных IoT-модуля c id=5CCF7F1230F4 за последние 2 дня
http://aqualeak.ru/?id=5CCF7F1230F4&json=1&last=2days
[{"ch1":"123795","ch2":"9061","ch01":"36910","ch02":"14640","batt":"57","timestamp":"2017-10-17 19:18:55"},{"ch1":"123795","ch2":"9061","ch01":"36910","ch02":"14640","batt":"58","timestamp":"2017-10-17 19:18:37"},{"ch1":"123770","ch2":"9051","ch01":"36885","ch02":"14630","batt":"58","timestamp":"2017-10-17 17:01:22"},{"ch1":"123760","ch2":"9046","ch01":"36875","ch02":"14625","batt":"58","timestamp":"2017-10-17 14:44:22"},{"ch1":"123755","ch2":"9046","ch01":"36870","ch02":"14625","batt":"58","timestamp":"2017-10-17 12:27:25"},{"ch1":"123715","ch2":"9031","ch01":"36830","ch02":"14610","batt":"58","timestamp":"2017-10-17 10:10:18"},{"ch1":"123710","ch2":"9026","ch01":"36825","ch02":"14605","batt":"57","timestamp":"2017-10-17 07:53:13"},{"ch1":"123710","ch2":"9026","ch01":"36825","ch02":"14605","batt":"57","timestamp":"2017-10-17 05:36:27"},{"ch1":"123690","ch2":"9016","ch01":"36805","ch02":"14595","batt":"58","timestamp":"2017-10-17 03:19:38"},{"ch1":"123690","ch2":"9016","ch01":"36805","ch02":"14595","batt":"58","timestamp":"2017-10-17 01:02:50"},{"ch1":"123675","ch2":"9011","ch01":"36790","ch02":"14590","batt":"58","timestamp":"2017-10-16 22:46:00"},{"ch1":"123670","ch2":"9006","ch01":"36785","ch02":"14585","batt":"58","timestamp":"2017-10-16 20:29:03"},{"ch1":"123650","ch2":"8996","ch01":"36765","ch02":"14575","batt":"58","timestamp":"2017-10-16 18:12:11"},{"ch1":"123650","ch2":"8996","ch01":"36765","ch02":"14575","batt":"58","timestamp":"2017-10-16 15:55:17"},{"ch1":"123625","ch2":"8986","ch01":"36740","ch02":"14565","batt":"58","timestamp":"2017-10-16 13:37:59"},{"ch1":"123585","ch2":"8966","ch01":"36700","ch02":"14545","batt":"58","timestamp":"2017-10-16 11:21:06"},{"ch1":"123575","ch2":"8961","ch01":"36690","ch02":"14540","batt":"58","timestamp":"2017-10-16 09:04:11"},{"ch1":"123575","ch2":"8961","ch01":"36690","ch02":"14540","batt":"58","timestamp":"2017-10-16 06:47:24"},{"ch1":"123575","ch2":"8961","ch01":"36690","ch02":"14540","batt":"58","timestamp":"2017-10-16 04:30:29"},{"ch1":"123550","ch2":"8946","ch01":"36665","ch02":"14525","batt":"58","timestamp":"2017-10-16 02:13:42"},{"ch1":"123540","ch2":"8936","ch01":"36655","ch02":"14515","batt":"58","timestamp":"2017-10-15 23:56:28"},{"ch1":"123540","ch2":"8936","ch01":"36655","ch02":"14515","batt":"57","timestamp":"2017-10-15 21:39:30"}]
4. Запрос данных IoT-модуля c id=5CCF7F1230F4 за последние 3 месяца с шагом неделя
http://aqualeak.ru/?id=5CCF7F1230F4&json=1&last=3month&step=week

возможен шаг: day, week, month
[{"ch1":"123795","ch2":"9061","ch01":"36910","ch02":"14640","batt":"57","timestamp":"2017-10-17 19:18:55"},{"ch1":"123445","ch2":"8896","ch01":"36560","ch02":"14475","batt":"58","timestamp":"2017-10-14 22:49:57"},{"ch1":"122160","ch2":"8441","ch01":"35275","ch02":"14020","batt":"61","timestamp":"2017-10-07 23:42:37"},{"ch1":"120900","ch2":"7881","ch01":"34015","ch02":"13460","batt":"61","timestamp":"2017-09-30 23:04:19"},{"ch1":"119695","ch2":"7401","ch01":"32810","ch02":"12980","batt":"65","timestamp":"2017-09-23 22:52:43"},{"ch1":"118415","ch2":"6966","ch01":"31530","ch02":"12545","batt":"66","timestamp":"2017-09-16 21:44:58"},{"ch1":"117105","ch2":"6566","ch01":"30220","ch02":"12145","batt":"67","timestamp":"2017-09-09 22:30:50"},{"ch1":"115710","ch2":"6151","ch01":"28825","ch02":"11730","batt":"70","timestamp":"2017-09-02 21:59:02"},{"ch1":"114365","ch2":"5766","ch01":"27480","ch02":"11345","batt":"71","timestamp":"2017-08-26 23:32:28"},{"ch1":"112785","ch2":"5366","ch01":"25900","ch02":"10945","batt":"73","timestamp":"2017-08-19 23:22:00"},{"ch1":"111250","ch2":"4966","ch01":"24365","ch02":"10545","batt":"73","timestamp":"2017-08-12 23:38:00"},{"ch1":"109820","ch2":"4556","ch01":"22935","ch02":"10135","batt":"75","timestamp":"2017-08-05 21:46:12"},{"ch1":"108460","ch2":"4111","ch01":"21575","ch02":"9690","batt":"76","timestamp":"2017-07-29 23:56:32"},{"ch1":"107185","ch2":"3666","ch01":"20300","ch02":"9245","batt":"76","timestamp":"2017-07-22 22:12:36"}]
5. Запрос самых свежих данных по всем потребителям группы c email=aqua@aqualeak.ru
http://aqualeak.ru/?json=1&email=aqua%40aqualeak.ru
{"email":"aqua@aqualeak.ru","date":"2017-10-17 19:33:42","rows":[{"id":"00000000002","ch1":"0","ch2":"0","ch01":"5","ch02":"25","batt":"2","timestamp":"2017-04-12 11:44:41","comment":"Battery Test(finished): Alkaline Energizer (till 2015) 3V4sh"},{"id":"18FE34CB85A2","ch1":"488736","ch2":"204559","ch01":"11365","ch02":"4385","batt":"61","timestamp":"2017-10-17 18:15:17","comment":"Demo3"},{"id":"5CCF7F1230F4","ch1":"123795","ch2":"9061","ch01":"36910","ch02":"14640","batt":"57","timestamp":"2017-10-17 19:18:55","comment":"Demo2"},{"id":"5CCF7F8F6B0A","ch1":"0","ch2":"0","ch01":"0","ch02":"0","batt":"77","timestamp":"2017-09-29 15:34:01","comment":"Refrigerator Test (-18C)"},{"id":"5CCF7FD61E57","ch1":"713320","ch2":"246590","ch01":"77395","ch02":"4275","batt":"68","timestamp":"2017-10-17 17:23:15","comment":"Demo1"}]}
6. Запрос данных по всем потребителям группы c email=aqua@aqualeak.ru по состоянию на 2017-08-01 00:00:00
http://aqualeak.ru/?json=1&email=aqua%40aqualeak.ru&date=2017-08-01
{"email":"aqua@aqualeak.ru","date":"2017-08-01","rows":[{"id":"00000000002","ch1":"0","ch2":"0","ch01":"5","ch02":"25","batt":"2","timestamp":"2017-04-12 11:44:41","comment":"Battery Test(finished): Alkaline Energizer (till 2015) 3V4sh"},{"id":"18FE34CB85A2","comment":"Demo3"},{"id":"5CCF7F1230F4","ch1":"108970","ch2":"4276","ch01":"22085","ch02":"9855","batt":"76","timestamp":"2017-07-31 22:03:36","comment":"Demo2"},{"id":"5CCF7F8F6B0A","comment":"Refrigerator Test (-18C)"},{"id":"5CCF7FD61E57","ch1":"681300","ch2":"246590","ch01":"45375","ch02":"4275","batt":"82","timestamp":"2017-07-31 22:33:41","comment":"Demo1"}]}

Поля структуры JSON:
"id" - уникальный номер IoT-модуля
"ch1" и "ch2" - показание реальных счетчиков расхода воды (в литрах)
"ch01" и "ch02" - внутренние (программные) счетчики расхода воды (в литрах)
"batt" - уровень заряда батареи (в %)
"timestamp" - момент снятия показаний

Ищем партнеров для продвижения проекта в регионах!!!
email: aqua@aqualeak.ru