@City IoT Cloud Platform
iSys - Akangwara Masisitimu IoT Mhinduro
IoE.Systems
Zviri Mukati
1. Nhanganyaya. 5
1.1 Yakatsigirwa mhando dzemidziyo. 5
1.2. Akatsigira zvigadzirwa mhando. 5
1.3. Zvirongwa zvekutaurirana zvakatsigirwa 5
1.4. Inotsigirwa Kutaurirana Tekinoroji yeZvivakwa 6
1.5. @City Cloud Server 6
1.5.1. Server uye kutaurirana masuo 7
1.5.2 HTTP Kubatanidzwa kweRoRaWAN 7
1.5.3. Mberi-kumagumo interface 8
1.5.3. Kodzero dzekuwana Server 8
1.6. Smart Zvishandiso 9
1.6.1. CIoT - GSM zvishandiso 9
1.6.3. BAS, BMS, IoT - Ethernet nemidziyo yeWiFi 9
1.6.2. IoT -LoRaWAN zvishandiso 9
1.7. Bhizinesi kune Bhizinesi (B2B) sarudzo 9
2. @City atform Platform Kushanda 10
3. Main Peji 11
4. Main Fomu 11
4.1. Musoro 12
4.1.1. Kumba Kunongedzera - (inovhura chaiyo mhedzisiro tafura) 12
4.1.2. "X" bhokisi rekutarisa - rinovhura / rinovhara Query Fomu 12
4.1.3. "V" bhokisi rekutarisa - rinovhura / rinovhara Minda Fomu 12
4.1.4. Graphical icons - zvinongedzo kune yekuona mhinduro (inogadziriswa) 12
4.2. Fomu: 12
4.2.1. "X" bhokisi rekutarisa - rinovhura / rinovhara Query Yese Fomu 12
4.2.2. CSS - Sarudza Kuona Musoro 12
4.2.3. Inoonekwa Minda yekutarisa bhokisi - inoratidza / inovanza Munda Wedzeresa Rondedzero 12
4.2.4. Tab: Tab Zita rekuwedzera kana kubvisa gumi nembiri
4.2.5. Wedzera / Bvisa Mabhatani - Wedzera kana kubvisa mabhu ane zita muTab munda 12
4.2.6. Sarudza Core Bhatani 12
4.2.7. Sarudza Bhatani rese 12
4.2.7. Sarudza Bhatani rese 12
4.2.8. Viga Sefa - Viga Fomu rose gumi nemaviri
4.2.9. Dzorera Bhatani - Chinja parameter marongero 13
4.2.10. "V" bhokisi rekutarisa - show / high filter minda. 13
4.3. Tabhu 13
4.4. Tafura Zviri Mukati 13
4.4.1. Mhanya - maonero mhedzisiro mhando 13
4.4.2. Kopa (+/- zvinongedzo) 13
4.4.3. Tafura Cell Zvinongedzo 13
4.5. Dhata Order 13
4.6. Muenzaniso 13
5. Mepu 15
5.1. Mepu Kutanga 15
5.2. Zvingakudetsera Zvirongwa zvemubvunzo 15
5.2.1. Chinja MAP chikero (Zoom Chikamu) 16
5.2.2. IMEI (Sarudza Munda Midziyo) 16
5.2.3. Lon, Lat (Longitude, Latitude inoratidzira minda) 16
5.2.4. Chinja MAP Chimiro (Musoro) 16
5.2.5. KUPI Chikamu 16
5.2.6. Dzokorora (Mhanya Query Bhatani) 16
5.2.7. Sarudza Zvese (Bvisa minda yese kubva kumubvunzo) 17
5.2.8. "V" Checkbox (Vhura / Vhara Fomu Yemunda) 17
5.2.9. "X" Checkbox (Ratidza / Viga fomu reKubvunza) 17
5.3. Muenzaniso 17
6. Ratidza Mhedzisiro muTafura 18
6.1. Kutanga kwetafura 18
6.2. Zvingakudetsera Zvirongwa zvemubvunzo 19
6.2.1. Ronga - sarudza munda uye odha uchikwira / uchidzika 19
6.2.2. DB / IMEI - Sarudza Mudziyo 19
6.2.3. CSS - sarudza chimiro (Visualization theme) 20
6.2.4. Minda Inoonekwa - Ratidza / Viga Minda Fomu 20
6.2.5. Bvisa Empty - Usaratidze makoramu asina chinhu 20
6.2.6. "X" Checkbox (Ratidza / Viga fomu reKubvunza) 20
6.2.7. Iko Clause (yeganho yedata) 20
6.2.8. Sarudza Core Bhatani (Gonesa akajairwa minda) 20
6.2.9. Sarudza Bhatani rese (Bvisa minda yese kubva pamubvunzo) 20
6.2.10. Dzokorora (Mhanya Query Bhatani) 20
6.2.11. "V" Checkbox (Vhura / Vhara Fomu Yemunda) 20
7. Bar Charts. 21
8. Machati Ezvakaitika. 22
8.1. Kutanga kweNhoroondo machati 22
8.2. Zvirongwa zvekuzvisarudzira zveMachati Ezvakaitika 23
8.2.1. IMEI - (Sarudza Mudziyo kuratidza nhoroondo yezvakaitika) 23
8.2.2. Min - muganho wakaderera kukosha kwekutanga ndima 23
8.2.3. Max - muganho wakanyanya kukosha wekutanga munda 23
8.2.4. "V" - Ratidza / Viga Minda Fomu 23
8.2.5. Kubva: seta shoma zuva / nguva (*) 23
8.2.6. Ku: kumisikidza zuva rakanyanya / nguva (*) 23
8.2.7. "X" Checkbox (Ratidza / Viga fomu reKubvunza) 23
8.2.8. "Kupi" Chitsauko 23
8.2.9. Sarudza Bhatani rese (Bvisa minda yese kubva pamubvunzo) 23
8.2.10. Dzokorora (Mhanya Query Bhatani) 23
8.2.11. "V" Checkbox (Vhura / Vhara Fomu Yemunda) 24
8.3. Mabhawa Akasiyana: (inoratidza chete data rinowanikwa) 24
8.4. Inoenderera mutsauko (iine data rakafanana): 24
9. Webhu saiti kuenderana 25
10. Themes Kugadziriswa 26
11. Maalgorithms Dzokorora 27
12. Dhatabhesi Dhizaini 28
12.1. "ithings_" uye "*" matafura chimiro 29
12.2. Midziyo yemidziyo (Zviitiko) mutsetse "* _c" tafura - chimiro 30
12.3. Kuwana mhedzisiro kubva kudhatabhesi - Mid-Chikamu (Kuverenga Dhata) 30
12.3.1. Wana mamiriro azvino ezvinhu zvese zvishandiso 30
12.3.2. Tora Nhoroondo dhata yeiyo Mudziyo 31
12.3.3. Tora runyorwa rwezvigadzirwa - imwechete munda kubva kumatunhu echinyakare ane muganho 32
@City IoT Cloud Platform yakatsaurwa "micro-gore" system yevatengi vega. Platform haina kugoverwa uye mumwe chete mutengi ndiye anokwanisa kuwana yepanyama kana chaiyo server (VPS kana yakatsaurwa maseva). Mutengi anogona kusarudza imwe yedhizeti yedata-nzvimbo muEurope kana pasi.
@City IoT chikuva chakakumikidzwa mukutevera iSys.PL zvigadzirwa
IoT - RF / LoRaWAN (Internet yezvinhu)
CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Cell Internet yezvinhu)
WiFi
Ethernet
@City (eCity) Cloud IoT Platform yakasiyanasiyana saizi sisitimu yezvinhu IP - zvigadzirwa (zvinodaidzwa pamwechete se @City Hardware kana CioT Midziyo ):
@City
@Chiedza
@Metering
@Trace
@AirQ
@Bin
@City IoT chikuva chinotsigira zvinotevera maprotocol ekutaurirana:
UDP - yakanangidzirwa kuCIoT sensors / zvishandiso (kunyanya NBIoT) - yakaderera mashandisiro edhisheni
TCPIP - inokurudzirwa zvishandiso zvine bidirectional kutaurirana - kubata ruoko / simbiso
HTTP - inokurudzirwa chete yekuwana data / kuona / kutumira / "gore kusvika kune gore"
HTTP Webhooks - yeLoRaWAN kutaurirana pakati peLoRaWAN Network / Application Server uye @City Cloud.
Dhata inotumirwa kubva kumugadziri kuenda kune server server uye zvinopesana-zvakavharidzirwa mune yakasarudzika mabhinari fomati kune yakaderera saizi saizi uye kuwedzerwa kuchengetedzeka. Wese mudiwa anowana yake yakasarudzika yekunyorera kiyi yekubvumidza chishandiso, data rechokwadi kutarisa, nezvimwe.
Kune asiri eHouse / eCity zvishandiso isu tinogona kupa imwechete encryption algorithms ( "C" kodhi yekodhi) kune mumwe nemumwe wepamoyo kune microprocessor kuchengetedza dhata pamberi pekutaurirana.
Mune ino kesi data rakachengeteka zvachose panguva yekudyidzana kwekudyidzana pamusoro peveruzhinji kutaurirana midhiya (internet, Mhepo, nezvimwe. ).
@City IoT chikuva chinotsigira:
GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - zvishandiso (UDP / TCPIP kutaurirana)
LoRaWAN zvishandiso (HTTP Webhooks) - kuburikidza neLoRaWAN gateway uye LoRaWAN network / sevhisi yekushandisa
Ethernet Vanodzora (UDP / TCP kutaurirana)
WiFi Vanodzora (UDP / TCP kutaurirana)
Ramangwana IP zvigadzirwa
Kwete IP zvigadzirwa kuburikidza neakawedzera emuno @ Guta / eHouse. PRO Hardware Gateway
@City atform Platform yakatsaurwa kune zvishandiso / node:
Native iSys zvigadzirwa:
CIoT (GSM / 2G / 3G / 4G / CATM1 / NBIoT)
IoT (LoRaWAN)
WiFi - zvigadzirwa zvakatsaurwa zve @City Platform
Ethernet - zvigadzirwa zvakatsaurwa zve @City Platform
Co-Kugadzira zvigadzirwa (zvakagadzirwa nevechitatu mapato pasi peiyo iSys rezinesi uye yekunze mhando)
Franchise zvigadzirwa (zvakagadzirwa nevechitatu mapato pasi peSys rezinesi ine iSys marogo)
@City software inoshanda paLinux based VPS (Virtual Yakavanzika Server) kana Dedicated Server padivi internet, zvinoenderana nekukumbira kuita kweiyo Server (inonzi gare gare Server):
yakavanzika / yeruzhinji kuwana
zvakajairika zvishandiso kuverenga
gadziriso yemadhigidhi mamiriro frequency
data rekuvandudza mwero
Mhando dzakasiyana dzeVPS dziripo zvichienderana ne:
Mutengo
data-pakati geo-localization
Virtual processor macores (1-8)
Virtual RAM (1-32GB)
SSD dhisiki (20GB-1TB)
Zvizhinji zveDedicated server iripo zvichienderana ne:
Mutengo
data-pakati geo-localization
Processor processor (4 .. 32)
RAM (16 .. 512GB)
SSD / HDD (256GB .. 8TB)
Iyo @City IoT chikuva chakakumikidzwa kune mumwechete mutengi:
hurumende dzemunharaunda nezviremera (Guta, Nharaunda, Nyika)
B2B (yechitatu muridzi webato)
Nekuti haina kugoverwa Server pakati pevatengi, zvinorerutsa kuchengetedzeka kuwana uye nekuita nyaya. Nekuda kweichi chikonzero chete mutengi ndiye ane chekuita nekuchengeteka kwakanaka, kugadzikana, kugona, kubudikidza nedata, nezvimwe. Mukana wekusakwana kwekuita, mutengi anogona kutenga hurongwa hwepamusoro (VPS kana Dedicated Server), yakanyanyisa kuita basa rinotarisirwa nekuita.
Mune zviitiko zvakakosha "Cloud to cloud" kutaurirana kunogona kuve kwekudyidzana kwepasirese uye kwepakati pe data kune nzvimbo hombe panzvimbo pevazhinji-vatengi gore.
Kutaurirana kwe @City Server kunoonekwa zvichibva pane yakaderera nhanho kunyorera kwekuita maximalization.
Main maficha e @City Server application ndeaya:
asynchronously gamuchira data kubva kumidziyo (kuburikidza nema protocols: UDP, TCP IP, HTTP)
kurerutsa kushandiswa kwedata uye nemitengo yaro pakati pemidziyo uye Cloud (nekushandisa zvakaderera nhaurwa dzekutaurirana UDP, TCP IP)
gamuchira mamiriro akavharidzirwa emidziyo (kuburikidza nechero media yekutaurirana)
mvumo uye kusimbisa data kubva kumidziyo nekuburitsa zvimiro zvavo
kugadzirisa mamiriro emidziyo uye kuimutsiridza muMariaDB / MySQL matafura zvakananga (mune yakasvibirira dhata fomati)
yazvino tafura yedata (ine chete chinyowani mamiriro echinhu chimwe nechimwe)
nhoroondo dhata tafura (ine zvese mamiriro echinhu chimwe chete)
tumira mirairo yakamirira (Zviitiko) kune zvishandiso
kuvimbisa kukwazisana, kuongorora uye kusimbisa
@City Server software yakafanana kune yega yega mushandisi uye haigone kuve yakagadzirirwa vatengi vakasiyana.
Vanodzora veRoRaWAN vanobatanidzwa ne @City gore kuburikidza neiyo HTTP interface (webhooks) inowanikwa pane iyo LoRaWAN network / application server.
Mhando dzinoverengeka dze network / application server dzinotsigirwa:
TTN (yakatemwa nguva "Pamhepo" uye iyo yakakwira nhamba yemirairo yakatumirwa kune mutyairi uye haitsigire firmware kusimudzira)
LoraWAN-Stack (Inoda kubatisisa pane chigadzirwa chemuviri chine mukana weinternet).
LoraServer.Io (Inoda kuitisa pamudziyo wepanyama ine internet kuwana - chete kutumira data kuseva uye haitsigire firmware kusimudzira)
Iyo @City Cloud revatariri veLoRaWAN rakakamurwa nenzira imwechete seimwe nzvimbo. Inokurukurwa muchitsauko chakapfuura.
Yemberi-yekupedzisira interface inoonekwa ine PHP zvinyorwa zvekutora yakagadziriswa data kubva ku @City Cloud Dhatabhesi. Iyo inoshandisa chaizvo yakasununguka yekutsvaga mashandiro, yakavakirwa pane yekutanga SQL mibvunzo kudzikisira yaunoda data. Interface inopa mhinduro mhinduro muJSON fomati yekuwedzera kudhindaini uye kugadzirisa ne JavaScript Mberi-kumagumo Webhu "application".
Yekutanga kumberi-kumagumo interface yakafanana kune yega yega mushandisi uye haigone kuve yakagadzirirwa vatengi vakasiyana.
Kufukidza chinongedzo chinogona kugadzirwa nevashandi vedu kana mukubatana kuti vimbise kugadzirisa kwevatengi.
Kodzero dzevatengi dzekuwana (kune yepanyama Server) ishoma.
Faira kuwana ye "matemplate" dhairekitori chete (zvemavara zvinyorwa zvemafaira - .txt, .js, .css, .html):
kuwedzera, kubvisa, kugadzirisa akachena mafaera eHTML (Mberi-Endi GUI / Yemukati Yekuvandudza)
kuwedzera, kubvisa, kugadzirisa akachena mafaera (Mberi-End-GUI / Yemukati Yekusimudzira uye MaAlgorithms)
kuwedzera, kubvisa, kugadzirisa CSS yakachena Mafaira (Mberi-Kupera - Tsika dzinoona / Themes)
kuwedzera, kubvisa, kugadzirisa mafaira emafaira ematemplate (Mberi-Mugumo GUI)
kuwedzera, kubvisa, kugadzirisa matabhu, mapfupi, zvinongedzo kumhedzisiro yedata
Dzimwe kodzero dzekuwana:
Kuwana kuzere kune @City Cloud Dhatabhesi MySQL / MariaDB panochengeterwa data rese remidziyo
Kuwanikwa kweWebhu Services kunotsanangurwa (zvitupa) zvevatengi.
Mutengi haatenderwe kupfuudza zvitupa kune wechitatu mapato (kuwanda kuwana mhedzisiro kunogona kukanganisa mashandiro, kugadzikana uye chengetedzo yehurongwa hwese)
Pasi pemamiriro ezvinhu akasarudzika uye kushandiswa kwepamusoro kushanda Dedicated Server, yeruzhinji account inogona kumisikidzwa kuti icherechedze razvino dhata (kwete nhoroondo).
Mushandisi anogona kudzokorora dhata kune yake yega MySQL server uye aite yake ega kuongorora uye kugadzirisa, kuitira kuti isakanganisa mashandiro e @City Server
iSys - Intelligent Systems vashandi - vane mukana usingagumi kune yese server kusanganisira root account uye yakazara DB yekuwana yekuchengetedza.
Pasi pemamwe mamiriro ezvinhu iSys inogona kupa mamwe maratidziro akaringana kumutengi (zvinyorwa zvePHP, mafaera) mushure mekutarisa kodhi yekodhi, kumhanyisa bvunzo, kana ikasakanganisa kwese system chengetedzo, kugadzikana uye kuita.
Zvishandiso zvedu zvine microcontroller uye GSM / GPS / GNSS module (2G..4G, NBIoT, CATM1) yekutaurirana. Microcontroller ine yakavharidzirwa bootloader yekuchengetedza OTA firmware kusimudzira. Izvi zvinogonesa kugadzira akawanda masystem system anoenderana zvakafanana "CIoT Smart chishandiso".
Ethernet uye WiFi vanodzora vanobvumidza IP yakavakirwa kutaurirana kune iyo system (pasina kubhadharisa kuendesa dhata kune iyo GSM opareta). Izvi zvishandiso zvakare zvine encrypted bootloader uye zvishandiso zvinogona kuvandudzwa kuburikidza neayo echimiro interface. YeWiFi ine OTA firmware kusimudzira kubva kune main server
LoRaWAN inogonesa kufambiswa kwedata pamusoro penzvimbo refu kwazvo (kusvika kusvika approx. 15km). Iyi nharaunda inoenderana nekumhanyisa kwekufambisa kwedata, huwandu hwedata, kukura kwemaguta enharaunda uye kugona kwenzira dzeredhiyo yemidziyo.
Zvishandiso zvedu zvinosanganisira microcontroller uye LoRaWAN module yekutaurirana. Iyo microcontroller ine yakavharidzirwa bootloader yeakachengeteka OTA software yekuvandudza. Izvi zvinokutendera iwe kuti ugadzire akawanda masystem masisitimu anoenderana zvakafanana "IoT smart device". Iwo majaira anoshanda muISM yakavhurika bhendi pasina imwezve yekubhadhara mari. Izvo zvinodikanwa kushandisa LoRaWAN magedhi kuvhara nzvimbo yese nekuwana Internet. Muchiitiko cheanowanikwa maLoRaWAN magedhi mukati mechikamu chemidziyo (yakagadzirirwa TTN server), zvinokwanisika kutumira ruzivo kuburikidza navo. Firmware kusimudzira inoda yega network / kunyorera LoRaWAN server uye yakanaka renji yekutaurirana.
Pane zvakawanda zvingasarudzwa zvebhizinesi pamwe nekubatana:
kupinza / kutumira kunze zvigadzirwa zvakagadzirira (switchboards, zvishandiso) - zvigadzirwa zvekupedzisira
kupinza / kutumira kunze zvigadzirwa zveOEM (maPCB, vatongi, nezvimwewo) - zvigadzirwa zvepakati, zvikamu zvekusiya
kodzero - kugadzirwa kunoenderana nerezinesi redu kumisika yemuno (isu tinopa chete ma microcontroller akarongwa) pasi peSys - Intelligent Systems Brands
Co-Kugadzira - (sezviri pamusoro) asi pasi pekunze Brands
@City chikuva inotsigira inogadziriswa Front-End template yekuona dhata, mubvunzo, kudzikisira nekugadzirisa (Yazvino / dhata dhata):
fungidzira data rakasarudzwa pamepu (geo -inzvimbo)
inoratidza yakasarudzwa data uye mhedzisiro mumatafura
inoratidza yakasarudzwa dhata mumabha machati
inoratidza yakasarudzwa dhata mune zvekare machati
Export dhata kune wechitatu bato kunyorera uye kumwe kugadzirisa
kumwe kushanda kunovandudzwa pane zvikumbiro zvega.
YeVashandisi Yekumberi-Kuguma inowanikwa kuburikidza neiyo static IP kana DNS redirection domain / subdomain / faira kana iripo.
Muenzaniso & Demo kuisirwa (Inogoneswa chete kune vanotarisira vatengi).
Ndokumbira utizivise kana iwe uchida kuyedza - kugonesa kuruzhinji kupinda papuratifomu.
Zvinogona kuda static IP yekombuta iri kure kuti ikwanise kutaurirana ku @City chikuva.
Peji guru rakasiiwa risina chinhu nemaune nekuda kwezvikonzero zvekuchengetedza: http: //% YakoIP% / IoT /
Inogona kuve yega inogoneswa uye kugadziriswa uye iine zvinongedzo kune ese aripo masevhisi e @City atform Platform kana zvichidikanwa
Main Fomu inoitirwa kugadzira matange nyowani uye tabo: http: //%IP%/IoT/que.php
Iyi ndiyo fomu yekutanga yekugadzira mhedzisiro, maonero uye tabo pane yega gadziriso
Tsananguro (Kubva kumusoro uye kuruboshwe kurudyi nzira)
Chinja Visualization theme CSS faira inofanirwa kunge iri mu "matemplate / css /" dhairekitori - yakanyorwa otomatiki.
Sarudza minda mikuru inoonekwa patafura. It yakagadziridzwa otomatiki.
Sarudza minda yese (inofanirwa kuteverwa nekusarudza mamwe acho nemaoko)
Sarudza minda yese (inofanirwa kuteverwa nekusarudza mamwe acho nemaoko)
Izvi zvakaenzana neese (X) bhokisi rekutarisa
Mumwe nemumwe akagadzira tabo ane mazita uye presets (zvakachengetwa mu cfg / tebhu.cfg faira).
Iyo faira iri chaizvo rine zita uye URL (yakaparadzaniswa netabhu char).
Inoratidza minda yese inoganhurirwa neMunda Firita.
Minda iri patafura:
mepu- mepu mhedzisiro pamepu (imwe kana yakawanda ndima inogona kusarudzwa)
nhoroondo - machati ezvakaitika kare (imwe kana yakawanda ndima inogona kusarudzwa)
tab - inoratidza tafura (chero musanganiswa weminda unogona kusarudzwa)
bhaa - munda mumwe chete unoratidzwa pabhawa chati
Pakudzvanya imwe yemutengo wayo ichavhura mitsva mitsva neminda yakasarudzwa (yeravezvino).
Kuwedzera / kubvisa Tab ine zita rakaiswa mukati Tab munda. Iyo inoshandisa chete minda yakasarudzwa mumutsara mumwe chete wetafura.
Kudzvanya chero rimwe zita remunda kuchatanga Data Kuona kwenzvimbo yakasarudzwa yemutsara wakasarudzwa.
Kurongeka kwenzvimbo dzakaratidzwa senge kurongeka kwadzo mumafomu fomu (zvisinei tm munda unogara uchitumirwa kumagumo ezvinyorwa). Iyi odha inogona kungochinjwa nekungonongedza kwakaringana kwe URL parameter (minda odha chikamu).
Semuenzaniso: Kuisa Tab ne Kuchengeta Asset zita uye rine mepu nenguva uye nekumhanyisa pamepu
Tsananguro yese inoreva mutsara uko "Map" chinyorwa chiri mu "Mhanya" column.
Isa zita "Kuchengeta Asset" mukati Tab munda (isina makotesheni)
Ita shuwa kuti ese makoramu haana kusarudzwa mumutsara
sarudza tm, gps_speed_km chete mumutsara
Dhinda + bhatani iko mumutsara
Mamepu anogona kuvhurwa kubva MainForm ine pre-yekumisikidza
Mepu yekutanga inoitwa nemaoko kana yaitwa zvakananga neiyi link: > http: //%IP%/IoT/maps.php
Mushandisi anofanira Kusarudzira minda yese (Press Sarudza Bhatani)
Dhinda rimwe bhokisi rekutarisa minda yakaratidzwa (semuenzaniso. Ain5 (yezinga reSmog) uye tm (yezuva rekuyera / nguva)
Dhinda "V" bhokisi rekutarisa kuviga minda fomu
Dhinda Kuuraya bhatani kumhanya mubvunzo weDB uye kuratidza ruzivo rwezvino kubva kuma sensors / zvishandiso
Mepu ine data inovandudzwa mushure memasekondi makumi matatu kana kudarika.
Zvirongwa zvinotsanangurwa kubva kuruboshwe kuenda kurudyi (pane pamusoro skrini).
Zoom level inogona kuchinjwa uchishandisa (+/-) mabhatani ekuyera (current_scale * 2 kana current_scale / 2 zvakateerana). Kudzvanya imwe yeiyi mabhatani kuchachinja zviyero pachayo.
Imwe nzira ndeye sarudza Zoom Level mukati Zoom Combo Bhokisi munda uye tinya Kuuraya bhatani. Mune ino kesi yakazara View / Mepu inoteedzazve uye inozorodzwa (zvinotora chinguva panguva yekutanga).
IMEImunda une dhivhizheni yakasarudzika ID kana Yakasarudzika alias yechigadzirwa. Kumisikidza kuseta kuri * (asterisk) iyo inoratidza huwandu hwazvino hunhu uye geolocation yechinhu chimwe nechimwe.
Kuisa IMEI kune chero imwe kukosha, kucharatidza nhoroondo yedhata yesarudzo yakasarudzwa. Iyo ine njere chete kune inofamba uye inofamba maseru, zvikasadaro mhedzisiro inowirirana pamepu panzvimbo imwechete.
Gadza nzvimbo yepakati yemepu. Iyi munda yakagadzirirwa nzvimbo yekutambanudza kana bhatani remouse rakadzvanywa pamepu.
Mepu maitiro / theme inogona kusarudzwa kubva Map ComboBox munda (semuenzaniso. Rima, Gireyi, Topographic).
Mepu dzakasiyana dzemepu dzinogona kunge dziine huwandu hwakakura hwekuwedzera zoom saka inogona kumanikidza iwo Musoro wakakodzera kuti uwedzere mapikisi.
Iko Clause inoshandiswa kune yekuwedzera query tambo {PAPI chikamu} cheMySQL / MariaDB.
Ichi chirevo chinotorwa mukufungwa kwekuvaka yakakwana QUERY tambo yemhedzisiro yedhatabhesi. Inogona kudzikisira dhata, nguva uye chero imwe tsika nekukanganisa mhedzisiro kuverenga. Yekutanga tafura yemunda mazita (kwete alias) anofanirwa kushandiswa mune ino ndima. Semuenzaniso.
gps_speed_km> 10 // kumhanya kunopfuura gumikm / h
ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)
gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)
Kudzvanya bhatani iri kunodiwa kuti uchinje chero marongero, paramita (kunze kwekutsikirira +/- mabhatani).
Mepu inotakurwa kubva pakutanga nema presets matsva.
Mepu haina kutakurwa zvachose, kana pasina dhata inowanikwa yemubvunzo wazvino.
Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvabuda pamepu.
Iri bhokisi rekutarisa rinoshandiswa kuratidza / kuviga musarudzo yeminda yekuratidza.
Iri bhokisi rekutarisa rinogonesa kuviga Fomu rese kunze ( +/- mabhatani)
Mhedzisiro pamepu inoramba ichizorodzwa uye ichivandudzwa nemitengo mitsva
SemSmog mhedzisiro (Sensor yakaiswa pamota): Smog level 2.5um particles (Ain5), Speed (gps_speed_km), Date / Time (tm), mepu (2 - topographic), zoom level 16,
Iko chirevo:
"gps_fix = 3 uye tm> "2019-02-18 00:00:00" uye tm <"2019-02-19 00:00:00" uye gps_speed_km> 0".
// GPS = inoshanda 3D mhedzisiro & zuva = 2019-02-18 & kumhanya> 0 km / h
Ratidza zvawanikwa mutafura.
Vhura "Main Fomu" Dhinda "tafura" chinhu, mushure mekusarudza mimwe minda kuratidza pre-yakagadzirirwa tafura
Kana tafura yakavhurika kubva ku link http: //%IP%/IoT/que.php? func = tabo inoda kutanga kwekutanga kwemasetwork.
Unogona kusarudza minda inooneka (nekudzvanya "Minda Inoonekwa" bhokisi rekutarisa.
Dhinda zvese zvinotarisirwa bhokisi rekutarisa minda yakaratidzwa
Dhinda bhokisi rekutarisa "Minda Inoonekwa" kuviga minda fomu
Dhinda Enzesa bhatani kumhanya DB query uye kuratidza tafura
Zvirongwa zvinotsanangurwa kubva kuruboshwe kuenda kurudyi (pane iyo skrini).
Sort munda wakaenzana nekutsikirira musoro musoro.
IMEImunda une dhivhizheni yakasarudzika ID kana Yakasarudzika alias yechigadzirwa. Nemutengo usina chinhu unoratidza tafura yezvazvino tsika.
Kuisa IMEI kune chero imwe kukosha, kucharatidza nhoroondo yedhata yesarudzo yakasarudzwa.
Iyi ndiyo sufix yeMySQL / MariaDB yekuwedzera query tambo {PAPI chikamu}
Ichi chirevo chinotorwa mukuvakirwa kwakakwana QUERY tambo yemhedzisiro yedhatabhesi. Inogona kudzikisira dhata, nguva uye chero imwe tsika nekukanganisa mhedzisiro kuverenga. Yekutanga tafura yemunda mazita (kwete alias) anofanirwa kushandiswa mune ino ndima. Semuenzaniso.
gps_speed_km> 10 // kumhanya kunopfuura gumikm / h
ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)
gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)
Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvabuda pamepu.
Kudzvanya bhatani iri kunodiwa kuti uchinje chero marongero, paramita (kunze kwekutsikirira +/- mabhatani).
Tafura inotakurwa zvakare kubva pakutanga neyakafanogadzirirwa nyowani.
Iri bhokisi rekutarisa rinoshandiswa kuratidza / kuviga musarudzo yeminda yekuratidza.
Mhedzisiro mutafura yakarongedzwa zvinoenderana ne Ronga kumisikidzwa kwemunda. Kuronga kurongeka kunogona kuchinjwa nekutsikirira mutsara musoro (kamwe chete kune rimwe divi kaviri kune rimwe divi).
Mimwe mhedzisiro mumakoramu link yekuwedzera kuona masikirini (akaomeswa -kodhi).
Kana uchiratidzira dhata yezvakaitika yedhijisiti inofanirwa kushomeka kuitira kuti isaratidze nhoroondo yese nhoroondo nekuti inogona kutungamira mukuita kana kunze kwenzvimbo dzekurangarira.
Machati emabhawa anofanirwa kuitwa kubva kuFomu Huru nekutsikirira munda mumwechete mu "Bar" mutsara.
Iyo inoratidza yakarongedzwa mabara akajairwa kusvika pahupamhi kukosha, inoratidza kubva kumusoro-kuderera kurongeka.
Izvo zvinobatsira kukurumidza kuongorora mhedzisiro uye kutora mamwe matanho.
Mouse Pamusoro pechiitiko icharatidza rumwe ruzivo rwechigadzirwa.
Machati enhoroondo anogona kutangwa kubva ku MainForm kana uchimanikidza yakasarudzwa ikholamu mu "Nhoroondo" mutsara (kune imwechete munda).
Kune Multiple minda mu "Nhoroondo" mutsara waunoda minda inofanirwa kuongororwa uye "Nhoroondo" chinongedzo chinofanira kumanikidzwa mu "Mhanya" ikholamu.
Zvakaitika munhoroondo zvinongogumira kumaawa makumi maviri nemana + maawa anotevera makumi maviri nemana (ekuzorodza machati), pakange pasina miganho yakamiswa.
Machati enhoroondo kana achivhurwa kubva ku main link inoda kuvhurwa semimwe mhedzisiro, kana yakavhurwa kubva kune chinongedzo pasina zvido zvekuda.
Minda yakawanda inogona kusarudzwa kuratidza dzakasiyana zvinhu. Iyo inogona zvakare kugadzirirwa muMunda Filter Fomu.
Dhinda zvese zvinotarisirwa bhokisi rekutarisa minda yakaratidzwa
Dhinda bhokisi rekutarisa "Minda Inoonekwa" kuviga minda fomu
Dhinda Ita bhatani kumhanya mubvunzo weDB uye kuratidza tafura
Zvinhu zvinotsanangurwa kubva kumusoro uye kubva kuruboshwe kuenda kurudyi (pane iyo skrini).
IMEImunda une dhivhizheni yakasarudzika ID kana Yakasarudzika alias yechigadzirwa. Iine * (asterix) kukosha inoratidza tafura yeazvino kukosha ayo asina pfungwa.
Kuisa IMEI kune chero imwe kukosha, kucharatidza nhoroondo yedhata yesarudzo yakasarudzwa.
Chirevo chekudzikisira mhedzisiro yedhata MySQL / MariaDB yekuwedzera query tambo {PAPI chikamu}.
Ichi chirevo chinotorwa mukufungwa kwekuvaka yakakwana QUERY tambo yemhedzisiro yedhatabhesi. Inogona kudzikisira dhata, nguva uye chero imwe tsika nekukanganisa mhedzisiro kuverenga. Yekutanga tafura yemunda mazita (kwete alias) anofanirwa kushandiswa mune ino ndima uye inoshanda SQL syntax. Semuenzaniso.
gps_speed_km> 10 // kumhanya kunopfuura gumikm / h
ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)
gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)
Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvaitika kare.
Kudzvanya bhatani iri kunodiwa kuti uchinje chero marongero, paramita (kunze kwekuratidza minda kana pani yemubvunzo). Tafura inotakurwa zvakare kubva pakutanga neyakafanogadzirirwa nyowani.
Iri bhokisi rekutarisa rinoshandiswa kuratidza / kuviga musarudzo yeminda yekuratidza.
Mouse pointer inoratidza kukosha kwezviyero uye zuva / nguva.
Basa / WWW Bhurawuza | Chrome 72 | FireFox 65 | Edge | Opera 58 |
Mepu | + | + | + | + |
Nhoroondo | + | + (*) | + | + |
Mabhawa | + | + | + | + |
Tabs | + | + | + | + |
* - Firefox haitsigire date / time picker (ndima yemavara inofanirwa kugadziridzwa nemaoko uchishandisa chaiyo nguva yenguva fomati).
Internet Explorer haina kutsigirwa (shandisa Edge pachinzvimbo)
Mamwe mabhurawuza ewebhu haana kuyedzwa.
Mapeji eWebhu anobva pane yakajairwa template faira iri pa "matemplate" dhairekitori "* .template".
Kuwedzera yega yega peji peji rine:
"*. musoro" faira inochengeta musoro wenyaya peji (zvinongedzo, kupinza CSS, JavaScript Mafaera, nezvimwe. )
"* .foot" mafaera anochengetera tsoka dzeiyo peji (zvinongedzo, nezvimwe. )
Visualization theme inogona kuchinjwa zvinoenderana nezvinodiwa nemushandisi nekugadzirisa nekugadzirisa maCSS mafaira. CSS mafaera ari mu "matemplate / css" dhairekitori. Mhando dzakasiyana dzeWebhu Peji dzinogona kushandiswa kugadzira yakagadzirirwa semuenzaniso. kudhinda, SmartPhones, maPAD matemplate.
Table maonero - ane nzvimbo yakasarudzika yekusarudza CSS faira yekuzadzikiswa kwenyowani (yakachengetwa mu "matemplate / css / tabo" dhairekitori).
Map maonero - general theme inosarudzwa ne "mepu" mhando combo bhokisi. Pamusoro pezvo pane default CSS faira "matemplate / css / map.css" iyo iine imwe yekuwedzera mashandiro sekuhwanda / kuchenesa mhedzisiro zvichibva pahunhu hwayo. Mamwe ese faira reCSS anongogumira kumubvunzo nemafomu emunda.
Mazhinji e @City Platform PHP mafaera ekuona anotambira cssparamende ine kukosha kwezita refaira reIye Musoro (pasina kuwedzerwa). Faira rinofanirwa kuwanikwa mune "matemplate / css" dhairekitori uye zita iri rinonzwika.
Zvimwe zvinhu zveTemusoro kuratidza zviripo zvakananga mu JavaScript faira iri mu "template / js" dhairekitori.
Main @City script"@ City.js" iri mune yepamusoro dhairekitori. Iko hakuna shanduko mukana mune izvi location, zvakadaro script inogona kuteedzerwa ku "matemplate / js" dhairekitori uye yakagadziridzwa ipapo. Kushandiswa kwescript script kunoda kugadzirisa ese mahedhiyo mafaira.
Dzimwe sensors dzakasarudzika dzinogona kuda zvakatsaurwa ekuverenga mabasa.
Iko hakuna mukana wekugadzirisa uye chengetedza akawanda akasiyana e @City Server Software, Mberi-kumagumo PHP interface, izvo zvaizokonzeresa yakawanda nyaya, shanduro, zvikanganiso.
Yakanakisa uye yakapusa nzira yekuzviita, kuvandudza JavaScript "kufukidza" mafaera kuratidza kwakakodzera kukosha / tsananguro.
Chekutanga JS zvinyorwa zvakavhurika zvinyorwa faira uye zvinogona kutorwa kune zvinodiwa nevatengi. Sezvakataurwa muchitsauko chakapfuura vanofanirwa kuteedzerwa "matemplate / js" dhairekitori apo mutengi anowana kodzero yekushandurwa.
Unyanzvi hunhu pane chirongwa che @City system haisi chidzidzo chegwaro iri, zvakadaro Webhu inogadzira ine ruzivo rwekutanga rweHTML neJS inogona kugadzirisa Front-end Webhu kunyorera kune wega mutengi zvinodiwa.
@City Dhatabhesi rine zita "IoT" kana "* IoT" yakakamurwa mumatafura (uko asterix iri chivakashure zvichienderana nekutambira server - kana zvichidikanwa). DataBase inogona kucherechedzwa muPHPAdmin (web application) pane chinongedzo http: //% IP% / phpmyadmin
Matafura Akagadzirirwa mudziyo wega wega (kupi * {asterix} IMEI kero - yakasarudzika ID):
"_t" - ma tokeni evashandisi vemazuva ano mvumo (isina kushandiswa kune Imwe-Mutengi makore)
"* _c" - mirairo (Zviitiko) mutsara - kutumirwa kuchinhu
"*" - mhedzisiro yese yemamiriro.
Mamwe matafura:
"ithings_" tafura - ine yakatemwa yazvino mamiriro ezvose zvishandiso (inoteedzerwa panguva yekuvandudza chero ye "*" matafura). Maumbirwo e things_ tafura inenge yakafanana kune iyo "*" matafura. "ithings_" une mimwe minda yePero Kero uye tsananguro.
"vashandisi" tafura inorambidzwa uye inofanira kuchinjwa.
"idx" - indekisi
"tm" - otomatiki timestamp
"dt" - unix timestamp
"imei" - yakasarudzika kero yedhijitari
"rssi" - RSSI chiratidzo cheyero
"rsrp" - RSRP chiratidzo
"zviitiko" - yekumirira zviitiko zvinotumirwa kune controller
"out1" .. "out16" - yakatemwa zvabuda mamiriro
"in1" .. "in16" - yakatemwa mamiriro ekuisa
"ain1" .. "ain8" - yakatemwa ADC tsika (RAW)
"sens1" .. "sens8" - akachinja sensor kukosha (zvinoenderana nerudzi rwechigadzirwa)
"dimm1" .. "dimm8" - yakatemwa kudzikisira kukosha (zvinoenderana nerudzi rwechigadzirwa)
"int1" .. "int6" - yakatemwa manhamba ekuverenga (zvinoenderana nerudzi rwechigadzirwa)
"zvinyorwa1" .. "zvinyorwa6" - yakatemwa zvinyorwa zvemavara (zvinoenderana nerudzi rwechigadzirwa)
"zvisikwa" - chigadzirwa chigadzirwa zuva / nguva
"wekupedzisira" - yekupedzisira zuva / nguva
"mushandisi" - kushandiswa mune ramangwana
"pasa" - kushandiswa mune ramangwana
"sn" - gsm serial nr
"chinzvimbo" - yazvino controller chinzvimbo chisina kubviswa mune hex fomati
"hash_code" - kushandiswa mune ramangwana
"addr" - pfupi kero yedhizaini
"fwnr" - firmware nr
"akaremara" - chakaremara chishandiso (hachina kuitwa)
"gsm_nr" - CIoT gsm nhamba
"mutengesi" - kodhi yemutengesi (ye franchise / co-kugadzirwa)
"nguva yenguva" - Nguva Yekugadzirisa
"dst" - Shandisa marongero ezuva nezuva ekuchengetedza
"gps_lat" - GPS Latitude
"gps_long" - GPS Kureba
"gps_hdop" - GPS HDOP
"gps_alt" - Kukwirira kweGPS
"gps_fix" - GPS Kugadziriswa (inofanirwa kunge iri 3 - kune mhedzisiro mhedzisiro)
"gps_cog" - GPS Cog
"gps_speed_km" - GPS Kumhanya mu [km / h]
"gps_sat" - GPS satellites yakawanikwa
"kondinendi", "nyika", "dunhu", "dunhu", "dunhu", "guta", "dunhu", "mugwagwa", "mugwagwa_nr", "chinhu_nr" - Kero yevatengi uye tsananguro minda (!!!! Haisipo ye "*" nhoroondo matafura)
"danda" - dhata dhata
Mazita eminda akakosha mukugadzira mibvunzo yeSQL yekuwedzera mashandiro ekutsvaga nekuti zita rekutanga rinofanira kushandiswa muSQL Statement.
Iyi tafura chiitiko / mirairo pamutsara wechigadzirwa chimwe nechimwe uye ine inotevera mamiriro:
"raira" - raira kutumira kana kutotumirwa kumutungamiriri
"yakasimbiswa" - mureza wekusimbisa kana yanga yatotumirwa nekusimbiswa
"zuva" - unix timestamp yechiitiko
"yakagadziridzwa" - auto inogadziridza mureza (timestamp zuva / nguva)
Dhata inogona kuwanikwa pasina Front-end Webhu kunyorera. @City Sisitimu ine script ine epakati-chikamu mabasa. Mhedzisiro inodzoserwa muJSON fomati.
http: //%IP%/IoT/que.php? func = devsjson
Query inodzoka izere "_ithings" tafura (zvazvino mamiriro ezvese zvishandiso) muJSON Fomati:
[{ "nyika":"", "guta":"", "kondinendi":"", "nyika":"", "nharaunda":"", "subregion":"", "Sububregion":"", "guta":"", "dunhu":"", "mugwagwa":"", "mugwagwa_nr":"", "chinhu_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "zvisikwa":"2019-02-09 18:12:38", "wekupedzisira":"0000-00-00 00:00:00", "zviitiko":"", "mushandisi":"", "pasa":"", "imei":"351580051067110", "sn":"", "chinzvimbo":"73000200000f360033026800240000002c002c002dffffffffffffff5b63000001c1000001c200000000000000000009250a4f0a760a7a0a750a780a7000031d032205fc34029b025c025600460eb30", "hash_code":"", "addr":"", "fwnr":"", "akaremara":"", "gsm_nr":"", "mutengesi":"", "timezone":"", "dst":"", "rssi":"91", "rsrp":"99", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "gps_hdop":"", "gps_alt":"", "gps_fix":"4", "gps_cog":"", "gps_speed_km":"", "gps_sat":"", "zviitiko":"", "out1":"0", "kunze2":"0", "out3":"0", "kunze4":"0", "kunze5":"0", "kunze6":"0", "kunze7":"0", "kunze":"0", "9":"0", "kunze10":"1", "11":"0", "kunze12":"0", "kunze13":"0", "kunze14":"0", "kunze15":"0", "out16":"0", "in1":"0", "in2":"0", "in3":"0", "in4":"0", "in5":"0", "in6":"0", "in7":"0", "in8":"0", "in9":"0", "in10":"0", "in11":"0", "in12":"0", "in13":"0", "in14":"0", "mu15":"0", "in16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "ain5":"0", "ain6":"44", "ain7":"44", "ain8":"45", "sens1":"0", "sens2":"0", "sens3":"0", "sens4":"0", "sens5":"0", "sens6":"0", "sens7":"0", "sens8":"0", "dimm1":"255", "dimm2":"255", "dimm3":"255", "dimm4":"255", "dimm5":"255", "dimm6":"255", "dimm7":"255", "dimm8":"255", "int1":"-16776767", "int2":"450", "int3":"", "int4":"", "int5":"", "int6":"0", "zvinyorwa1":"", "zvinyorwa2":"", "chinyorwa3":"", "zvinyorwa4":"", "chinyorwa5":"", "zvinyorwa6":"" }]
Query nhoroondo dhata yeimwe kifaa neIMEI nr:
http: //%IP%/IoT/que.php? func = imeijson & imei = 356345080018095
Nekuti tafura yese inogona kunge iine mamirioni emitsara inofanirwa kuganhurirwa neCHOKWADI chirevo kuti irege kusungirira server.
Kuwedzera parameter url parameter:
mafaro - imeijson
imei - IMEI yechigadzirwa
munda - minda inofanirwa kuratidzwa mumhedzisiro (coma yakaparadzaniswa runyorwa)
min - pasipasi kukosha kwenzvimbo yekutanga kubva pane runyorwa
max - kukosha kukuru kwenzvimbo yekutanga kubva pane runyorwa
skanat - munda werudzi
tm - munda unowedzerwa otomatiki kumhedzisiro.
where - iko clause yekumisikidza data
Muenzaniso:
Tinoda kuwana zvinotevera mhedzisiro
yechigadzirwa ne imei=356345080018095
ratidza minda: ain5, ain6, gps_lat, gps_long
uye gumira ain5 muhuwandu ( 1, 10000 ) - inofanirwa kuve yekutanga munda mune runyorwa
uye GPS uve nedhata rakakodzera (gps_fix = 3)
uye zuva / nguva (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00
Yakagadzirwa URL tambo:
http: //%IP%/IoT/que.php? func =imeijson& imei =356345080018095& munda =ain5, ain6, gps_lat, gps_long& min =1& max =1000& kupi =gps_fix = 3 uye tm> "2019-02-14 23:00:19" uye tm <"2019-02-15 00:00:00"
Query Mhedzisiro:
[{ "ain5":"66","ain6":"68","gps_lat":"5202.7326N","gps_long":"02115.8073E","tm":"2019-02-14 23:04:31" }, { "ain5":"67","ain6":"76","gps_lat":"5202.7328N","gps_long":"02115.8075E","tm":"2019-02-14 23:05:42" }, { "ain5":"63","ain6":"77","gps_lat":"5202.7328N","gps_long":"02115.8074E","tm":"2019-02-14 23:06:05" }, { "ain5":"58","ain6":"77","gps_lat":"5202.7328N","gps_long":"02115.8075E","tm":"2019-02-14 23:06:32" }, { "ain5":"58","ain6":"68","gps_lat":"5202.7328N","gps_long":"02115.8076E","tm":"2019-02-14 23:06:55" }]
Iri basa rinodzosera mashoma data kubva ku "_ithings" tafura
http: //%IP%/IoT/que.php? func = mundajson & munda = ain5 & min = 13 & max = 5000
Parameter:
mafaro - mundajson
munda - munda kuti uratidzwe mumhedzisiro - imei uye tm zvinowedzerwa otomatiki
min - kukosha kwakaderera kwemunda
max - kukosha kukuru kwemunda
Nezve pamusoro pemubvunzo tambo inodzoka mhedzisiro ye ain5, imei, tm minda:
kana ain5 iri munzvimbo (13,5000)
Query Mhedzisiro:
[{"imei":"353080090069142", "tm":"2019-03-14 11:51:01", "ain5":"14" },
{"imei":"356345080018095", "tm":"2019-02-20 09:13:04", "ain5":"115" },
{"imei":"karczew", "tm":"2019-03-07 13:08:22", "ain5":"103" }]