@City IoT Cloud Platform




iSys - Intelligent Systems IoT Izixazululo









Izinhlelo ze-IoE

Okuqukethwe

1. Isingeniso. 5

1.1 Izinhlobo zedivayisi ezisekelwayo. 5

1.2. Izinhlobo zemikhiqizo esekelwayo. 5

1.3. Izivumelwano zokuxhumana ezisekelwayo 5

1.4. Ubuchwepheshe Bezokuxhumana Obusekelwayo 6

1.5. @City Cloud Server 6

1.5.1. Amasango wesiphakeli nokuxhumana 7

1.5.2 Ukuhlanganiswa kwe-HTTP LoRaWAN 7

1.5.3. Isixhumi esibonakalayo sangaphambili

1.5.3. Amalungelo okufinyelela kwiseva 8

1.6. Amadivayisi ahlakaniphile 9

1.6.1. I-CIoT - Amadivayisi we-GSM 9

1.6.3. BAS, BMS, IoT - Amadivayisi we-Ethernet ne-WiFi 9

1.6.2. Devices -LoRaWAN amadivayisi 9

1.7. Izinketho ze Business to Business (B2B) 9

2. @City atform Ipulatifomu Ukusebenza 10

3. Ikhasi eliyinhloko 11

4. Ifomu Elikhulu 11

4.1. Unhlokweni 12

4.1.1. I-Home Link - (ivula ithebula lemiphumela langempela) 12

4.1.2. Ibhokisi lokuhlola le- "X" - livula / livala i-Query Form 12

4.1.3. Ibhokisi lokuhlola le- "V" - livula / livala i-Fields Form 12

4.1.4. Izithonjana zokuqhafaza - izixhumanisi zemiphumela yokubuka (kuhleleka) 12

4.2. Ifomu: 12

4.2.1. Ibhokisi lokuhlola le- "X" - livula / livala yonke i-Query Form 12

4.2.2. I-CSS - Khetha i-Visualization Theme 12

4.2.3 Ibhokisi lokuhlola le-Fields ebonakalayo - likhombisa / lifihla Uhlu Lokuhlunga Kwensimu 12

4.2.4. Ithebhu: Ithebhu Igama ukwengeza noma ukususa i-12

4.2.5. Faka / Susa Izinkinobho - Faka noma susa amathebhu anegama eliku-Tab field 12

4.2.6. Khetha i-Core Button 12

4.2.7. Ungakhethi Yonke Inkinobho 12

4.2.7. Khetha Zonke Inkinobho 12

4.2.8. Fihla isihlungi - Fihla iFomu 12 lonke

4.2.9. Inkinobho Yokwenza - Shintsha izilungiselelo zamapharamitha 13

4.2.10. "V" ibhokisi lokuhlola - izinkambu zokubonisa / zokuhlunga eziphezulu. 13

4.3. Amathebhu 13

4.4. Okuqukethwe Ithebula 13

4.4.1. Run - ukubukwa komphumela wohlobo 13

4.4.2. Kopisha (+/- izixhumanisi) 13

4.4.3. Izixhumanisi Zamaseli Wethebula 13

4.5. I-Data Order 13

4.6. Isibonelo 13

5. Amamephu 15

5.1. Ukuqaliswa Kwemephu 15

5.2. Amasethingi wokuzikhethela wombuzo 15

5.2.1. Shintsha isikali se-MAP (Izinga lokusondeza) 16

5.2.2. I-IMEI (Khetha Inkambu Yedivayisi) 16

5.2.3. I-Lon, i-Lat (i-Longitude, izinkambu ezixhumanisa i-Latitude) 16

5.2.4. Shintsha isitayela se-MAP (Isihloko) 16

5.2.5. LAPHO Isigaba sesi-16

5.2.6. Khipha (Inkinobho Yombuzo Yokuqalisa) 16

5.2.7. Ungakhethi konke (Susa zonke izinkambu embuzweni) 17

5.2.8. Ibhokisi lokuhlola le- "V" (Vula / Vala ifomu lenkambu) 17

5.2.9. "X" Ibhokisi Lokuhlola (Ifomu Lokukhombisa / Fihla Umbuzo) 17

5.3. Isibonelo 17

6. Khombisa Imiphumela kuthebula 18

6.1. Ukuqaliswa kwetafula 18

6.2. Amasethingi wokuzikhethela wombuzo 19

6.2.1. Hlunga - hlunga inkambu nokuhleleka kukhuphuke / kwehle 19

6.2.2. I-DB / IMEI - Khetha Idivayisi 19

6.2.3. I-CSS - khetha isitayela (i-Visualization Theme) 20

6.2.4. Izinkambu Ezibonakalayo - Khombisa / Fihla Izinkambu Ifomu 20

6.2.5. Susa okungenalutho - Ungakhombisi amakholamu angenalutho 20

6.2.6. "X" Ibhokisi Lokuhlola (Ifomu Lokukhombisa / Fihla Umbuzo) 20

6.2.7. Lapho Isigaba somthetho (sokukhawulelwa kwedatha) 20

6.2.8. Khetha Inkinobho Yesisekelo (Nika amandla izinkambu ezivame kakhulu) 20

6.2.9. Ungakhethi Yonke Inkinobho (Susa zonke izinkambu embuzweni) 20

6.2.10. Khipha (Inkinobho Yombuzo Yokuqalisa) 20

6.2.11. Ibhokisi lokuhlola le- "V" (Vula / Vala ifomu lenkambu) 20

7. Amashadi Webha. 21

8. Amashadi Wezomlando. 22

8.1. Ukuqaliswa kwamashadi wezomlando 22

8.2. Amasethingi Ongakukhetha Amashadi Omlando 23

8.2.1. I-IMEI - (Khetha Idivayisi ukubonisa imininingwane yomlando) 23

8.2.2. Imikhawulo - khawula inani elincane lenkambu yokuqala 23

8.2.3. Umkhawulo - umkhawulo wenani eliphezulu lenkambu yokuqala 23

8.2.4. "V" - Khombisa / Fihla Izinkambu Ifomu 23

8.2.5. Kusuka: setha idethi / isikhathi esincane (*) 23

8.2.6. Ku: setha usuku / isikhathi esiphezulu sedethi (*) 23

8.2.7. "X" Ibhokisi Lokuhlola (Khombisa / Fihla Ifomu Lombuzo) 23

8.2.8. "Kuphi" Isigaba somthetho 23

8.2.9. Ungakhethi Yonke Inkinobho (Susa zonke izinkambu embuzweni) 23

8.2.10. Yenza (Inkinobho Yombuzo Yokuqalisa) 23

8.2.11. Ibhokisi lokuhlola le- "V" (Vula / Vala ifomu lenkambu) 24

8.3. Ukwahluka kwamabha: (ibonisa kuphela idatha etholakalayo) 24

8.4. Ukwahluka okuqhubekayo (ngemininingwane efanayo): 24

9. Ukuhambelana kwesiphequluli seWebhu 25

10. Ukwenza ngokwezifiso izingqikithi 26

11. Ukuvuselelwa Kwama-algorithm 27

12. Isakhiwo sedatabase 28

12.1. Isakhiwo setafula "ithings_" no "*" 29

12.2. Umugqa wedivayisi (Imicimbi) ulayini "* _c" ithebula - isakhiwo 30

12.3. Ukuthola imiphumela kusuka kulwazi - Mid-Level (Reading Data) 30

12.3.1. Thola izimo zamanje zawo wonke amadivayisi 30

12.3.2. Thola idatha Yomlando Yedivayisi 31

12.3.3. Thola uhlu lwamadivayisi - inkambu eyodwa kusuka ezimeni zamanje ezinomkhawulo 32


1. Isingeniso.

@City IoT Cloud Platform kunikezelwe "ifu elincane" uhlelo lwamakhasimende ngamanye. Ipulatifomu ayabelwana futhi yikhasimende elilodwa kuphela elikwazi ukufinyelela kwiseva ebonakalayo noma ebonakalayo (i-VPS noma amaseva azinikele). Ikhasimende lingakhetha esinye sezikhungo eziningi zedatha eYurophu noma emhlabeni.

1.1 Izinhlobo zedivayisi ezisekelwayo.

Ipulatifomu ye- @City dedicated inikezelwe ukulandela imikhiqizo ye-iSys.PL



1.2. Izinhlobo zemikhiqizo esekelwayo.

Ipulatifomu ye- @City (eCity) Cloud is uhlelo losayizi abahlukahlukene bemikhiqizo ye-IP ((ebizwa njenge- @City Hardware noma Amadivayisi we-CioT ):


1.3. Izivumelwano zokuxhumana ezisekelwayo

Ipulatifomu ye- @City supports isekela imigomo elandelayo yokuxhumana:

Ukuthunyelwa kwedatha kusuka kusilawuli kuya kuseva yamafu futhi okuphambene nalokho kubethelwe ngefomethi kanambambili ehlukile ngosayizi wedatha ophansi kakhulu nokuvikeleka okwandisiwe. Umlingani ngamunye uthola ukhiye wakhe wokubethela oyingqayizivele wokugunyazwa kwedivayisi, ukuhlola ukufaneleka kwedatha, njll.


Kwamadivayisi angewona ama-eHouse / eCity singahlinzeka ngamasu wokubethela ngamanye ( "C" ikhodi yomthombo) yomlingani ngamunye we-microprocessor ukuvikela idatha ngaphambi kokuxhumana.

Kulesi simo idatha ivikeleke ngokuphelele ngesikhathi sokuxhumana okuvela kumakhompiyutha ngemidiya yezokuxhumana yomphakathi (i-inthanethi, i-Air, njll. ).


1.4. Ubuchwepheshe Bokuxhumana Osekelwayo Bamadivayisi

Ipulatifomu ye- @City supports iyasekela:


Ipulatifomu le- @City is linikezelwe kumadivayisi / ama-node:


1.5. @City Cloud Server

Isoftware ye- @City isebenza kwi-VPS eseLinux (i-Virtual Private Server) noma i-Dedicated Server ngasohlangothini lwe-inthanethi, kuya ngokusebenza okuceliwe kwe- Iseva (ebizwa kamuva iseva):


Izinhlobo ezahlukahlukene ze-VPS zikhona ngokuya nge:


Inqwaba yeseva ezinikezele ikhona ngokuya nge:


Ipulatifomu ye- @City is inikezelwe kumthengi oyedwa:


Ngoba ayikwazi ukwabiwa phakathi kweServer phakathi kwamakhasimende, yenza lula ukufinyelela kwezokuphepha nezinkinga zokusebenza. Ngenxa yalesi sizathu kuphela ikhasimende elibhekele ukuphepha okusebenzayo, ukuzinza, ukusebenza kahle, ukudluliswa kwedatha, njll. Uma kungasebenzi kahle, ikhasimende lingathenga uhlelo oluphakeme (i-VPS noma i-Dedicated Server), esebenza kahle kakhulu ekusebenzeni nasekusebenzeni okulindelekile.

Ezimweni ezikhethekile "Cloud to cloud" ukuxhumana kungahle kusetshenziselwe ukusatshalaliswa komhlaba kanye nokubekwa ndawonye kwedatha ezindaweni ezinkulu esikhundleni sefu lamakhasimende amaningi.

1.5.1. Amasango wesiphakeli nokuxhumana

Ukuxhumana kwe @City Server kutholakala ngokususelwa kuhlelo lokusebenza olusezingeni eliphansi lokusebenza kahle.

Izici eziyinhloko zohlelo lokusebenza lwe- @City Server yilezi:

Isoftware ye- @City Server iyafana kumsebenzisi ngamunye futhi ayikwazi ukwenziwa ngendlela oyifisayo kumakhasimende ahlukile.

1.5.2 Ukuhlanganiswa kwe-HTTP LoRaWAN

Abalawuli beLoRaWAN bahlanganiswe nefu @City nge-interface ye-HTTP (ama-webhooks) atholakala kunethiwekhi ye-LoRaWAN yenethiwekhi / iseva yohlelo lokusebenza.

Izinhlobo eziningi zeseva yenethiwekhi / yohlelo lokusebenza ziyasekelwa:

I-TTN (isikhathi esilinganiselwe "Emoyeni" kanye nenombolo enkulu yemiyalo ethunyelwe kumshayeli futhi ayisekeli ukuthuthukiswa kwe-firmware)

I-LoraWAN-Stack (Idinga ukusingathwa kudivayisi ebonakalayo enokufinyelela kwe-inthanethi).

I-LoraServer.Io (Idinga ukusingathwa kudivayisi ebonakalayo enokufinyelela kwe-inthanethi - ukuthumela kuphela idatha kuseva futhi akusekeli ukuthuthukiswa kwe-firmware)



Izilawuli ze- @City Cloud zabakwaLoRaWAN zihlukaniswe ngendlela efanayo nezinye iziphambano. Kuxoxwa ngakho esahlukweni esedlule.

1.5.3. Isixhumi esibonakalayo sangaphambili

Isixhumi esibonakalayo sangaphambili-phambili sibonwa ngemibhalo ye-PHP yokukhipha idatha eyenziwe ngokwezifiso ku- @City Cloud Database. Isebenzisa indlela yokusesha enwebeka kakhulu, ngokuya ngemibuzo yoqobo ye-SQL ukukhawulela idatha oyifunayo. I-interface ihlinzeka ngemiphumela yombuzo ngefomethi ye-JSON yokuqhubeka nokukhipha amakhodi nokucutshungulwa yi- "application Front-end Web" application ".

Isixhumi esibonakalayo sangaphambili sangaphambili siyafana kumsebenzisi ngamunye futhi asikwazi ukwenziwa ngendlela oyifisayo kumakhasimende ahlukile.

Imbondela imbondela ingadalwa ngabasebenzi bethu noma ngokubambisana ukuqinisekisa ukwenza ngokwezifiso kwekhasimende.

1.5.3. Amalungelo okufinyelela kwiseva

Amalungelo okufinyelela kwamakhasimende (kuServer ebonakalayo) anqunyelwe.

Ukufinyelela kwefayela lwemibhalo "yezifanekiso" kuphela (amafayela wombhalo womdabu - .txt, .js, .css, .html):

Amanye amalungelo wokufinyelela:


Abasebenzi be-iSys - Intelligent Systems - banokufinyelela okungenamkhawulo kuseva yonke kubandakanya i-akhawunti yezimpande nokufinyelela okugcwele kwe-DB kokugcinwa.

Ngaphansi kwezimo ezithile i-iSys inganikeza ngamalungelo athe xaxa kumakhasimende (imibhalo ye-PHP, amafayela) ngemuva kokubheka ikhodi yomthombo, ukwenza izivivinyo, uma kungathinti ukuphepha kohlelo jikelele, ukuzinza nokusebenza.


1.6. Amadivayisi ahlakaniphile

1.6.1. I-CIoT - amadivayisi we-GSM

Amadivayisi wethu aqukethe i-microcontroller ne-module ye-GSM / GPS / GNSS (2G..4G, NBIoT, CATM1) yokuxhumana. I-Microcontroller iqukethe i-bootloader ebethelwe yokuthuthuka okuphephile kwe-OTA firmware. Lokhu kunika amandla ukudala ukwahlukahluka okuningi kohlelo ngokuya ngokufanayo "Idivayisi ye-CIoT Smart".


1.6.3. BAS, BMS, IoT - Amadivayisi we-Ethernet ne-WiFi


Izilawuli ze-Ethernet ne-WiFi zivumela ukuxhumana okusekelwe nge-IP ohlelweni (ngaphandle kokushaja ukudluliswa kwedatha ku-opharetha we-GSM). Lawa madivayisi abethele i-bootloader ebethelwe futhi amadivayisi angavuselelwa nge-interface yawo yomdabu. Kwi-WiFi inokuthuthuka kwe-OTA firmware kusuka kuseva enkulu


1.6.2. Devices - amadivayisi we-LoRaWAN

I-LoRaWAN inika amandla ukudluliswa kwedatha emabangeni amade kakhulu (kufika ku-approx. 15km). Ububanzi buya ngejubane lokudluliswa kwedatha, inani ledatha, ukufuduka kwendawo kanye nokusebenza kahle kwezindlela zomsakazo zamadivayisi.

Amadivayisi ethu afaka imodyuli ye-microcontroller ne-LoRaWAN yokuxhumana. I-microcontroller iqukethe i-bootloader ebethelwe yokuvuselelwa kwesoftware ye-OTA. Lokhu kukuvumela ukuthi udale ukwahlukahluka okuningi kohlelo ngokuya ngokufanayo "IoT smart device". Amadivayisi asebenza kubhendi evulekile ye-ISM ngaphandle kwemali eyengeziwe yokubhalisa. Kuyadingeka ukusebenzisa i-LoRaWAN Gateways ukumboza yonke indawo ngokufinyelela kwi-Intanethi. Endabeni yamasango akhona we-LoRaWAN ngaphakathi kobubanzi bamadivayisi (amiselwe iseva ye-TTN), kungenzeka ukuthumela imininingwane ngawo. Ukuthuthukiswa kwe-Firmware kudinga iseva ye-LoRaWAN yenethiwekhi / yesicelo nebanga elihle lokuxhumana.

1.7. Izinketho zeBusiness to Business (B2B)


Kunezinketho eziningi zebhizinisi nokubambisana:

2. @City atform Ipulatifomu Ukusebenza

Ipulatifomu le- @City lisekela isifanekiso esenziwe ngokwezifiso se-Front-End sokubona idatha, umbuzo, ukukhawulela nokucubungula (idatha yamanje / yomlando):


I-Front-End Yomsebenzisi iyatholakala nge-static IP noma i-DNS redirection domain / subdomain / file uma ikhona.


Ukufakwa okuyisibonelo & kweDemo (Kuvunyelwe kuphela kumakhasimende angaba khona).

Sicela usazise lapho ufuna ukuyihlola - ukunika amandla ukufinyelela komphakathi kungxenyekazi.

Kungadinga i-IP emile yekhompyutha ekude ukunika amandla ukuxhumana ku-Platform yaseCity.


3. Ikhasi Elikhulu

Ikhasi eliyinhloko lishiywa lingenalutho ngamabomu ngenxa yezizathu zokuphepha: http: //% YakhoIP% / IoT /

Ingavunyelwa ngawodwana futhi ihlelwe futhi iqukathe izixhumanisi zazo zonke izinsizakalo ezitholakalayo ze- @City IoT Ipulatifomu uma kudingeka


4. Ifomu Elikhulu

Ifomu eliyinhloko kuhloswe ngalo ukwenza ukusetha okusha namathebhu: http: //%IP%/IoT/que.php

Le yifomu lokuqala lokwakha imiphumela, ukubukwa namathebhu ekucushweni ngakunye




Izincazelo (Ukusuka phezulu nakwesobunxele kuya kusiyakwesokudla)

4.1. Unhlokweni

4.1.1. Isixhumanisi sasekhaya - (ivula itafula lemiphumela yangempela)

4.1.2. "X" ibhokisi lokuhlola - livula / livala ifomu lombuzo

4.1.3. "V" ibhokisi lokuhlola - livula / livale ifomu lenkambu

4.1.4. Izithonjana zokuqhafaza - izixhumanisi zemiphumela yokubuka (kuhleleka)


4.2. Ifomu:

4.2.1. "X" ibhokisi lokuhlola - livula / livala ifomu lonke lombuzo

4.2.2. I-CSS - Khetha i-Visualization Theme

Shintsha ifayela le-Visualization Theme CSS kumele libe khona ku- "amathempulethi / css /" umkhombandlela - ubhalwe ngokuzenzakalela.

Izinkundla ezibonakalayo ibhokisi lokuhlola - likhombisa / lifihla Uhlu Lokuhlunga Kwensimu

4.2.4. Ithebhu: Igama lethebhu ukwengeza noma ukususa

4.2.5. Faka / Susa Izinkinobho - Faka noma susa amathebhu anegama ku- Ithebhu inkambu

4.2.6. Khetha u-Core Inkinobho

Khetha izinkambu ezinkulu ezibonakala etafuleni. It ivuselelwa ngokuzenzakalela.

4.2.7. Ungakhethi konke Inkinobho

Ungakhethi zonke izinkambu (kufanele zilandelwe ngokukhetha ezinye zazo ngesandla)

4.2.7. Khetha konke Inkinobho

Khetha zonke izinkambu (kufanele zilandelwe lapho ungakhethi ezinye zazo ngesandla)

4.2.8. Fihla isihlungi - Fihla lonke ifomu

Lokhu kulingana nakho konke (X) ibhokisi lokuhlola

4.2.9. Khipha Inkinobho - Shintsha izilungiselelo zamapharamitha

4.2.10. "V" ibhokisi lokuhlola - izinkambu zokubonisa / zokuhlunga eziphakeme.


4.3. Amathebhu

Amathebhu enziwe ngawodwa anamagama nokusetha kabusha (okugcinwe ku- cfg / amathebhu.cfg ifayela).

Ifayela empeleni liqukethe igama ne-URL (ehlukaniswe yithebhu char).


4.4. Okuqukethwe Ithebula

Ibonisa zonke izinkambu ezikhawulelwe ngesihlungi senkambu.


Izinkambu etafuleni:

4.4.1. Gijima - uhlobo lomphumela wokubukwa

imephu- Imiphumela yemephu ebalazweni (kungakhethwa inkambu eyodwa noma eziningi)

umlando - amashadi omlando (inkambu eyodwa noma eziningi zingakhethwa)

tab - ekhombisa itafula (noma iyiphi inhlanganisela yamasimu ingakhethwa)

ibha - Inkambu eyodwa kuphela eboniswa kushadi lebha

Ngokucindezela eyodwa yenani laso kuzovula imiphumela emisha ngezinkambu ezikhethiwe (kumugqa wamanje).


4.4.2. Kopisha (+/- izixhumanisi)

Ukungeza / ukususa i-Tab enegama elifakwe ku Ithebhu inkambu. Isebenzisa kuphela izinkambu ezikhethwe kumugqa ofanayo wetafula.


4.4.3. Izixhumanisi Zamaseli Etafula

Ukucindezela noma yiliphi elinye igama lenkambu kuzoqala ukubonwa kwedatha kwenkambu ekhethiwe yomugqa okhethiwe.


4.5. I-Data Order


I-oda lezinkambu ezibonisiwe linjenge-oda lalo kwifomu lezinkambu (noma kunjalo i-tm field ihlala ithunyelwa ekugcineni kombhalo). Leli oda lingashintshwa kuphela ngokuhlelwa okuqondile kwamapharamitha we-URL (ingxenye yoku-oda izinkambu).


4.6. Isibonelo

Isibonelo: Ukubeka ithebhu nge Ukulandelwa Kwefa igama futhi liqukethe imephu ngesikhathi nangejubane emephini

Yonke incazelo ebhekise kulayini lapho "Map" umbhalo ungene "Gijima" ikholomu.

  1. Faka igama "Ukulandelwa Kwefa" phakathi Ithebhu inkambu (ngaphandle kwezimpawu zokucaphuna)

  2. Qinisekisa ukuthi wonke amakholomu akhethiwe emugqeni

  3. khetha i-tm, gps_speed_km kulayini kuphela

  4. cindezela + inkinobho lapho kulayini






5. Amamephu

Amamephu angaqaliswa kusuka ku-MainForm ngokulungiswa kwangaphambili


5.1. Ukuqaliswa Kwemephu

Ukuqala kwemephu kwenziwa ngesandla lapho kwenziwa ngqo ngesixhumanisi: > http: //%IP%/IoT/maps.php


  1. Umsebenzisi kufanele akhethe zonke izinkambu (Cindezela Susa ukukhetha Inkinobho)

  2. Cindezela ibhokisi elithile lokuhlola izinkambu ezibonisiwe (isb. Ain5 (ngeleveli yeSmog) kanye ne- i-tm (ngosuku / isikhathi sokulinganisa)

  3. cindezela "V" ibhokisi lokuhlola ukufihla ifomu lezinkambu

  4. cindezela Khipha inkinobho yokusebenzisa umbuzo we-DB futhi ubonise imininingwane yamanje evela kuwo wonke ama-sensors / amadivayisi

  5. Imephu enedatha ivuselelwa ngemuva kwamasekhondi angu-30 noma ngaphezulu.


5.2. Amasethingi wokuzikhethela wombuzo

Izilungiselelo ezichazwe kusuka kwesobunxele ziye kwesokudla (kusithombe-skrini esingenhla).

5.2.1. Shintsha isikali se-MAP (Ileveli yokusondeza)

  1. Izinga lokusondeza lingahle liguqulwe kusetshenziswa izinkinobho (+/-) zesikala (current_scale * 2 noma current_scale / 2 ngokulandelana). Ukucindezela eyodwa yalezi zinkinobho kuzolungisa ngokuzenzakalela isikali.

  2. Enye indlela ukukhetha ileveli yokusondeza ku Sondeza Inkambu yeCombo Box bese ucindezela Khipha inkinobho. Kulokhu Ukubuka / Imephu yonke ilayishwa kabusha futhi ivuselelwe (kuthatha isikhashana ngesikhathi sokuqalisa).

5.2.2. IMEI (Khetha Inkambu Yedivayisi)

IMEIinkambu iqukethe i-ID eyingqayizivele yedivayisi noma alias ehlukile yedivayisi. Isilungiselelo esizenzakalelayo ngu- * (asterisk) ekhombisa amanani akamuva kakhulu ne-geolocation yedivayisi ngayinye.

Ukusetha i-IMEI kunoma yiliphi elinye inani, kuzobonisa idatha yomlando yedivayisi ekhethiwe. Kunengqondo kuphela ngezinzwa ezihambayo nezinyakazayo, ngaphandle kwalokho imiphumela izongena ebalazweni endaweni efanayo.


5.2.3. I-Lon, Lat (I-Longitude, izinkambu zokuxhumanisa zeLatitude)

Setha indawo emaphakathi yemephu. Le nkambu isethelwe endaweni yesikhombi lapho inkinobho yegundane icindezelwa emephini.


5.2.4. Shintsha isitayela se-MAP (Itimu)

Isitayela semephu / itimu ingakhethwa kusuka ku- Map Inkambu yeComboBox (isb. Mnyama, Mpunga, Isimo sendawo).

Izindikimba ezahlukahlukene zemephu zingaba namazinga wokusondeza ahlukene kakhulu ngakho-ke kungahle kuphoqelele iTimu efanelekile ukukhulisa isikali semephu.


5.2.5. LAPHO Isigaba somthetho

Lapho isigatshana sisetshenziselwa intambo yombuzo eyengeziwe {LAPHO ingxenye} ye-MySQL / MariaDB.

Lesi sigatshana sinakwa ngokwakhiwa kwentambo ephelele ye-QUERY yemiphumela yemininingwane. Kungakhawulela idatha, isikhathi nanoma yimaphi amanye amanani ngokulinganisela ukubalwa kwemiphumela. Amagama wenkambu yangempela yetafula (hhayi alias) kufanele asetshenziswe kule nkambu. Isib.

  1. gps_speed_km> 10 // isivinini singaphezu kuka-10km / h

  2. i-ain5> 3 // ain5 inkulu kune-3 (ukubamba inani lezinhlayiya ezingu-2.5um - ileveli ye-smog)

  3. gps_speed_km> 10 no-ain6> 5 // isivinini singaphezu kuka-10km / h kanti i-ain6 ingaphezu kuka-5 (ukubamba izinhlayiya eziyi-10um - ileveli ye-smog)


5.2.6. Khipha (Inkinobho Yokuqalisa Umbuzo)

Ukucindezela le nkinobho kuyadingeka ukushintsha noma yiziphi izilungiselelo, amapharamitha (ngaphandle kokucindezela +/- izinkinobho).

Imephu ilayishwe kusukela ekuqaleni ngama-preset amasha.

Imephu ayilayishiwe nakancane, lapho kungekho datha etholakalayo yombuzo wamanje.

5.2.7. Ungakhethi konke (Susa zonke izinkambu embuzweni)

Ngemuva kokucindezela le nkinobho okungenani kufanele kukhethwe inkambu eyodwa ngesandla ukubonisa imiphumela ebalazweni.


5.2.8. "V" Ibhokisi lokuhlola (Ifomu leNkundla evulekile / evaliwe)

Leli bhokisi lokuhlola lisetshenziselwa ukukhombisa / ukufihla isikhethi sezinkambu esizoboniswa.


5.2.9. "X" Ibhokisi lokuhlola (Khombisa / Fihla Ifomu Lombuzo)

Leli bhokisi lokuhlola linika amandla ukufihla lonke ifomu ngaphandle ( +/- izinkinobho)


Imiphumela ebalazweni ivuselelwa ngokuqhubekayo futhi ivuselelwa ngamanani amasha

5.3. Isibonelo

Imiphumela yeSm Smog (Kufakwe iSensor emotweni): Izinga leSmog 2.5um izinhlayiya (Ain5), Speed ​​(gps_speed_km), Date / Time (tm), imephu (2 - topographic), zoom level 16,

Lapho isigatshana:

"gps_fix = 3 and tm> "2019-02-18 00:00:00" ne-tm <"2019-02-19 00:00:00" ne-gps_speed_km> 0".

// GPS = imiphumela ye-3D evumelekile nedethi = 2019-02-18 nesivinini> 0 km / h



6. Khombisa Imiphumela kuthebula

Khombisa imiphumela etafuleni.

Vuliwe "Ifomu Elikhulu" cindezela "itafula" into, ngemuva kokukhetha ezinye izinkambu zokubonisa itafula elilungiselelwe ngaphambilini




6.1. Ukuqaliswa kwetafula

Lapho itafula livulekile kusixhumanisi http: //%IP%/IoT/que.php? func = amathebhu kudinga ukuqala kokuqala kwezilungiselelo.

Ungakhetha izinkambu ezibonakalayo (ngokucindezela "Izinkambu ezibonakalayo" ibhokisi lokuhlola.



  1. Cindezela wonke amabhokisi wokuhlola adingekayo ezinkambu ezibonisiwe

  2. Cindezela ibhokisi lokuhlola "Izinkambu ezibonakalayo" ukufihla ifomu lezinkambu

  3. Cindezela inkinobho ethi Khipha ukuze usebenzise umbuzo we-DB netafula elibonisayo


6.2. Amasethingi wokuzikhethela wombuzo

Amasethingi achazwa kusuka kwesobunxele kuye kwesokudla (kusithombe-skrini).

6.2.1. Hlunga - hlunga inkambu nokuhleleka kukhuphuke / kwehle

Inkambu yokuhlunga ilingana nokucindezela unhlokweni wekholomu.

6.2.2. DB / IMEI - Khetha Idivayisi

IMEIinkambu iqukethe i-ID eyingqayizivele yedivayisi noma alias ehlukile yedivayisi. Ngenani elingenalutho ikhombisa ithebula lamanani wakamuva kakhulu.

Ukusetha i-IMEI kunoma yiliphi elinye inani, kuzobonisa idatha yomlando yedivayisi ekhethiwe.


6.2.3. I-CSS - khetha isitayela (i-Visualization Theme)

6.2.4. Izinkambu ezibonakalayo - Khombisa / Fihla Izinkambu zeFomu

6.2.5. Susa okungenalutho - Ungabonisi amakholomu angenalutho

6.2.6. "X" Ibhokisi lokuhlola (Khombisa / Fihla Ifomu Lombuzo)

6.2.7. Kuphi Isigaba somthetho (ngomkhawulo wedatha)

Lokhu kuyi-sufix yochungechunge lombuzo olwengeziwe lwe-MySQL / MariaDB {WHERE part}

Lesi sigatshana siyabhekelwa ukwakha intambo ephelele ye-QUERY yemiphumela yemininingwane. Kungakhawulela idatha, isikhathi nanoma yimaphi amanye amanani ngokulinganisela ukubalwa kwemiphumela. Amagama wenkambu yangempela yetafula (hhayi alias) kufanele asetshenziswe kule nkambu. Isib.

  1. gps_speed_km> 10 // isivinini singaphezu kuka-10km / h

  2. i-ain5> 3 // ain5 inkulu kune-3 (ukubamba inani lezinhlayiya ezingu-2.5um - ileveli ye-smog)

  3. gps_speed_km> 10 no-ain6> 5 // isivinini singaphezu kuka-10km / h kanti i-ain6 ingaphezu kuka-5 (ukubamba izinhlayiya eziyi-10um - ileveli ye-smog)


6.2.8. Khetha u-Core Inkinobho (Nika amandla izinkambu ezivame kakhulu)


6.2.9. Ungakhethi konke Inkinobho (Susa zonke izinkambu embuzweni)

Ngemuva kokucindezela le nkinobho okungenani kufanele kukhethwe inkambu eyodwa ngesandla ukubonisa imiphumela ebalazweni.


6.2.10. Khipha (Inkinobho Yokuqalisa Umbuzo)

Ukucindezela le nkinobho kuyadingeka ukushintsha noma yiziphi izilungiselelo, amapharamitha (ngaphandle kokucindezela +/- izinkinobho).

Ithebula lilayishwa kabusha kusukela ekuqaleni ngokusethwa okusha.



6.2.11. "V" Ibhokisi lokuhlola (Ifomu leNkundla evulekile / evaliwe)

Leli bhokisi lokuhlola lisetshenziselwa ukukhombisa / ukufihla isikhethi sezinkambu esizoboniswa.



Imiphumela etafuleni ihlelwe ngokuya nge- Hlunga ukulungiselelwa kwenkambu. Ukuhlunga ukuhleleka kungashintshwa ngokucindezela unhlokweni womugqa (kanye ngokuya ngakunye kabili kolunye uhlangothi).

Eminye imiphumela ixhumanisa amakholomu nokuqhubekisela phambili izikrini zokubona (ezinekhodi eqinile).


Lapho kukhonjiswa idatha yomlando yedivayisi kufanele ikhawulelwe ukuze ingabonisi lonke ulwazi lomlando ngoba ingaholela ekusebenzeni noma ngaphandle kwezinkinga zememori.


7. Amashadi Webha.

Amashadi wamabha kufanele asetshenziswe kusuka kufomu eyinhloko ngokucindezela inkambu eyodwa kumugqa we- "Bar".

Ibonisa imigoqo ehleliwe eyenziwe yaba yinani eliphezulu kakhulu, ikhombisa kusuka kokuphakeme kuya kokuphansi kakhulu.

Kuyasiza ekuhloleni ngokushesha imiphumela eyeqisayo futhi uthathe izinyathelo ezithile.





Umcimbi we-Mouse Over uzobonisa imininingwane eyengeziwe yedivayisi.


8. Amashadi Wezomlando.

Amashadi omlando angaqalwa kusuka ku-MainForm lapho ucindezela ikholomu ekhethiwe kumugqa "Wezomlando" (wenkambu eyodwa).

Ezinkambu eziningi kumigqa efiselekayo yomugqa "Umlando" kufanele ihlolwe futhi isixhumanisi "Somlando" kufanele sicindezelwe kukholomu "Run".

Imiphumela yomlando ikhawulelwe emahoreni angama-24 + amahora angama-24 alandelayo (ukuthola amashadi aqabulayo ekugcineni), lapho kungekho mingcele ebekiwe.

8.1. Ukuqaliswa kwamashadi wezomlando


Amashadi omlando lapho evulwa kusixhumanisi esikhulu adinga ukuqalwa njengeminye imiphumela, lapho evulwa kusixhumanisi ngaphandle kwemingcele yokuncamelayo.

Izinkambu eziningi zingakhethwa ukubonisa izinto ezahlukahlukene. Ingasethwa futhi kwifomu lokuhlunga le-Field.




  1. Cindezela wonke amabhokisi wokuhlola adingekayo ezinkambu ezibonisiwe

  2. Cindezela ibhokisi lokuhlola "Izinkambu ezibonakalayo" ukufihla ifomu lezinkambu

  3. Cindezela inkinobho ethi Khipha ukuze usebenzise umbuzo we-DB futhi ubonise itafula


8.2. Izilungiselelo zokuzikhethela zamashadi omlando

Izinto ezichazwe kusuka phezulu nangakwesobunxele ziye kwesokudla (kusithombe-skrini).

8.2.1. IMEI - (Khetha Idivayisi ukubonisa idatha yomlando)

IMEIinkambu iqukethe i-ID eyingqayizivele yedivayisi noma alias ehlukile yedivayisi. Ngevelu * (asterix) ikhombisa ithebula lamanani akamuva kakhulu angenangqondo.

Ukusetha i-IMEI kunoma yiliphi elinye inani, kuzobonisa idatha yomlando yedivayisi ekhethiwe.

8.2.2. Ubuncane - khawula inani elincane lenkambu yokuqala

8.2.3. Ubukhulu - khawula inani eliphezulu kakhulu lenkambu yokuqala

8.2.4. "V" - Khombisa / Fihla Izinkambu zeFomu

8.2.5. Kusuka ku-: setha usuku / isikhathi esincane (*)

8.2.6. Ku: setha usuku / isikhathi esiphezulu sedethi (*)

8.2.7. "X" Ibhokisi lokuhlola (Khombisa / Fihla Ifomu Lombuzo)

8.2.8. "Kuphi" Isigaba somthetho

Isigaba sokunciphisa imiphumela yedatha ye-MySQL / MariaDB yochungechunge lombuzo owengeziwe {LAPHO ingxenye}.

Lesi sigatshana sinakwa ngokwakhiwa kwentambo ephelele ye-QUERY yemiphumela yemininingwane. Kungakhawulela idatha, isikhathi nanoma yimaphi amanye amanani ngokulinganisela ukubalwa kwemiphumela. Amagama wenkambu yetafula langempela (hhayi ama-alias) kufanele asetshenziswe kule nkambu ne-syntax evumelekile ye-SQL. Isib.

  1. gps_speed_km> 10 // isivinini singaphezu kuka-10km / h

  2. i-ain5> 3 // ain5 inkulu kune-3 (ukubamba inani lezinhlayiya ezingu-2.5um - ileveli ye-smog)

  3. gps_speed_km> 10 no-ain6> 5 // isivinini singaphezu kuka-10km / h kanti i-ain6 ingaphezu kuka-5 (ukubamba izinhlayiya eziyi-10um - ileveli ye-smog)


8.2.9. Ungakhethi konke Inkinobho (Susa zonke izinkambu embuzweni)

Ngemuva kokucindezela le nkinobho okungenani kufanele kukhethwe inkambu eyodwa ngesandla ukubonisa imiphumela yomlando.


8.2.10. Khipha (Inkinobho Yokuqalisa Umbuzo)

Ukucindezela le nkinobho kuyadingeka ukushintsha noma yiziphi izilungiselelo, amapharamitha (ngaphandle kokukhombisa izinkambu noma iphaneli yombuzo). Ithebula lilayishwa kabusha kusukela ekuqaleni ngokusethwa okusha.

8.2.11. "V" Ibhokisi lokuhlola (Ifomu leNkundla evulekile / evaliwe)

Leli bhokisi lokuhlola lisetshenziselwa ukukhombisa / ukufihla isikhethi sezinkambu esizoboniswa.


8.3. Amabha Okuhlukile: (ibonisa kuphela idatha etholakalayo)



8.4. Iyaqhubeka okuhlukile (ngemininingwane efanayo):



Isibonisi semouse sibonisa amanani ezilinganiso nosuku / isikhathi.

9. Ukuhambisana kwesiphequluli sewebhu


Umsebenzi / Isiphequluli seWWW

I-Chrome 72

IFireFox 65

Umphetho

I-Opera 58

Amamephu

+

+

+

+

Ezomlando

+

+ (*)

+

+

Amabha

+

+

+

+

Amathebhu

+

+

+

+


* - IFirefox ayisekeli isikhethi sosuku / isikhathi (inkambu yombhalo kufanele ihlelwe ngesandla kusetshenziswa ifomethi yesikhathi esifanele sosuku).

I-Internet Explorer ayisekelwa (sebenzisa Umphetho esikhundleni)

Ezinye iziphequluli zewebhu azivivinywanga.



10. Izihloko ngokwezifiso

Amakhasi wewebhu asuselwa kufayela lesifanekiso elijwayelekile elise- "izifanekiso" umkhombandlela "* .template".

Ngokwengeziwe uhlobo lwekhasi ngalinye liqukethe:

  1. Ifayela le - "* .head" eligcina unhlokweni wekhasi (izixhumanisi, i-CSS engenisiwe, JavaScript Amafayela, njll. )

  2. "* .foot" amafayela agcina unyaweni wekhasi (izixhumanisi, njll. )


I-Visualization Theme ingashintshwa ngokuya ngokuncamelayo komsebenzisi ngokubhekana nokuguqula amafayela we-CSS. Amafayela we-CSS atholakala ku- "izifanekiso / i-css" umkhombandlela. Izindikimba ezihlukile zekhasi lewebhu zingasetshenziselwa ukudala okwenzelwe isb. ukuphrinta, ama-SmartPhones, izifanekiso zama-PAD.


Ithebhule ukubukwa - kunenkambu ekhethiwe yokukhetha ifayela le-CSS ukuguqulwa okuphelele kwetimu (okugcinwe ku- "amathempulethi / i-css / amathebhu" umkhombandlela).




Map imibono - itimu ejwayelekile ikhethwa yi "imephu" thayipha ibhokisi le-combo. Ngokwengeziwe kunefayela le-CSS elizenzakalelayo "amathempulethi / i-css / imephu.css" equkethe okunye ukusebenza okufana nemiphumela yokufihla / yokufaka imibala ngokuya ngamanani ayo. Elinye leli fayela le-CSS likhawulelwe cishe kumafomu ombuzo kanye nensimu.


Iningi labo @City Platform Amafayela we-PHP wamukelwa ngeso lengqondo cssipharamitha enenani legama lefayela leTimu (ngaphandle kwesandiso). Ifayela kufanele litholakale kumkhombandlela we- "templates / css" futhi igama libucayi.


Ezinye izinto ze-Theme display zitholakala ngqo kufayela le-located eliku- "ithempulethi / js" umkhombandlela.

Okuyinhloko @City iskripthi"@ City.js" itholakala enkombeni ephezulu. Akukho kungenzeka ukuguqulwa kulokhu location, Nokho umbhalo ungakopishelwa kuwo "izifanekiso / js" isiqondisi futhi siguqulwe lapho. Ukusetshenziswa kweskripthi ngasinye kudinga ukubuyekeza wonke amafayela kanhlokweni.

11. Ukuvuselelwa Kwama-algorithms


Ezinye izinzwa ezihlukile zingadinga imisebenzi ezinikelwe yokubala.

Akunakwenzeka ukuvuselela nokugcina okuhlukahlukene okuningi kwe- @City Server Isoftware, Isibonisi se-Front-end PHP, okungadala izingqinamba eziningi, izinhlobo, amaphutha.

Indlela enhle nelula yokukufeza, ukubuyekeza amafayela JavaScript "wokumbondelana" ukuze uboniswe kahle inani / incazelo.

Izikripthi ze-JS zoqobo ziyifayela lombhalo ovulekile futhi zingasetshenziswa ezidingweni zamakhasimende. Njengoba kushiwo esahlukweni esedlule kufanele bakopishelwe kuwo "izifanekiso / js" isiqondisi lapho ikhasimende linamalungelo okufinyelela okuguqulwa.


Isici sobuchwepheshe ezinhlelweni ze @City system akuyona isihloko salo mbhalo, kepha umthuthukisi weWebhu onolwazi oluyisisekelo lwe-HTML ne-JS angenza ngokwezifiso uhlelo lokusebenza lweWebhu Eseqophelweni eliphezulu ngezidingo zamakhasimende ngazinye.


12. Isakhiwo sedatabase


@City Database enegama "IoT" noma "* IoT" ihlukaniswe ngamatafula (lapho i-asterix iyisiqalo ngokuya ngeseva yokubamba - uma kudingeka). IdathaBase ingahle ibhekwe ku-PHPAdmin (uhlelo lokusebenza lewebhu) kusixhumanisi http: //% IP% / phpmyadmin




Amathebula Asethelwe Idivayisi ngayinye (kuphi * I- {asterix} ikheli le-IMEI - i-ID ehlukile):

Amanye amatafula:



12.1. Isakhiwo setafula "ithings_" ne "*"

12.2. Imiyalo yedivayisi (Imicimbi) umugqa wethebula "* _c" - isakhiwo


Leli thebula lingumugqa womcimbi / wemiyalo wedivayisi ngayinye futhi unesakhiwo esilandelayo:



12.3. Ukuthola imiphumela kusuka kulwazi - Mid-Level (Ukufunda Idatha)


Idatha ingafinyeleleka ngaphandle kohlelo lokusebenza lwe-Front-end Web. @City system iqukethe iskripthi esinemisebenzi esezingeni eliphakathi. Imiphumela ibuyiselwa ngefomethi ye-JSON.


12.3.1. Thola izimo zamanje zawo wonke amadivayisi

http: //%IP%/IoT/que.php? func = devsjson


Umbuzo ubuya uphelele "_izikhathi" table (izimo zamanje zawo wonke amadivayisi) ngefomethi ye-JSON:

[{ "izwe":"", "idolobha":"", "izwekazi":"", "izwe":"", "isifunda":"", "isifunda":"", "ukubhalisa":"", "idolobha":"", "isifunda":"", "umgwaqo":"", "umgwaqo_nr":"", "into_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "ukudala":"2019-02-09 18:12:38", "okokugcina":"0000-00-00 00:00:00", "imicimbi":"", "umsebenzisi":"", "phasa":"", "imei":"351580051067110", "sn":"", "isimo":"73000200000f360033026800240000002c002c002dffffffffffffff5b63000001c1000001c200000000000000000000005050a4f0a760a7a0a750a780a7000000031d032205fc34029b025c025600460eb30530", "hash_code":"", "i-addr":"", "fwnr":"", "ikhubaziwe":"", "gsm_nr":"", "umthengisi":"", "izoni yesikhathi":"", "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":"", "imicimbi":"", "ukuphuma1":"0", "ukuphuma2":"0", "ukuphuma3":"0", "ukuphuma4":"0", "5":"0", "ukuphuma6":"0", "ukuphuma7":"0", "phuma8":"0", "9":"0", "ukuphuma10":"1", "phuma11":"0", "ukuphuma12":"0", "13":"0", "baphume14":"0", "15":"0", "ukuphuma16":"0", "ku1":"0", "ku2":"0", "ku3":"0", "ku -4":"0", "ku5":"0", "ku -6":"0", "ngo -7":"0", "ku -8":"0", "ku9":"0", "ngo -10":"0", "ngo -11":"0", "in12":"0", "ngo -13":"0", "ngo -14":"0", "ngo -15":"0", "ngo-16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "aku5":"0", "ain6":"44", "ain7":"44", "ain8":"45", "sens1":"0", "umuzwa2":"0", "umuzwa":"0", "izinzwa4":"0", "Inzwa5":"0", "izinzwa6":"0", "izinzwa7":"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", "umbhalo1":"", "umbhalo2":"", "umbhalo3":"", "umbhalo4":"", "umbhalo5":"", "umbhalo6":"" }]

12.3.2. Thola idatha Yomlando Yedivayisi

Buza idatha yomlando yedivayisi eyodwa nge-IMEI nr:

http: //%IP%/IoT/que.php? func = imeijson & imei = 356345080018095


Ngoba itafula lonke lingaqukatha izigidi zemigqa kufanele ikhawulelwe NGOKUPHELA kwesigatshana ukuze kungafakwa i-hang-up server.

Amapharamitha angeziwe we-url:

i-func - imeijson

imei - IMEI yedivayisi

inkambu - Izinkambu ezizokhonjiswa emiphumeleni (uhlu oluhlukaniswe ikhoma)

ubuncane - Inani eliphansi lenkambu yokuqala ohlwini

ubuningi - inani eliphakeme lenkambu yokuqala ohlwini

snomat - inkambu yokuhlunga

i-tm - Inkambu ifakwa ngokuzenzakalela emiphumeleni.

where - lapho isigatshana sokukhawulela idatha


Isibonelo:

Sifuna ukuthola imiphumela elandelayo

yedivayisi ene imei=356345080018095

bonisa izinkambu: ain5, ain6, gps_lat, gps_long

futhi ukhawule aku5 ebangeni ( 1, 10000 ) - kufanele kube inkambu yokuqala ohlwini

futhi i-GPS unedatha evumelekile (gps_fix = 3)

nosuku / isikhathi (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00


Uchungechunge lwe-URL olwakhiwe:

http: //%IP%/IoT/que.php? func =imeijson& imei =356345080018095& inkambu =aku5, ain6, gps_lat, gps_long& min =1& max =1000& kuphi =gps_fix = 3 and tm> "2019-02-14 23:00:19" ne-tm <"2019-02-15 00:00:00"


Imiphumela yombuzo:

[{ "aku5":"66","ain6":"68","gps_lat":"5202.7326N","gps_long":"02115.8073E","tm":"2019-02-14 23:04:31" }, { "aku5":"67","ain6":"76","gps_lat":"5202.7328N","gps_long":"02115.8075E","tm":"2019-02-14 23:05:42" }, { "aku5":"63","ain6":"77","gps_lat":"5202.7328N","gps_long":"02115.8074E","tm":"2019-02-14 23:06:05" }, { "aku5":"58","ain6":"77","gps_lat":"5202.7328N","gps_long":"02115.8075E","tm":"2019-02-14 23:06:32" }, { "aku5":"58","ain6":"68","gps_lat":"5202.7328N","gps_long":"02115.8076E","tm":"2019-02-14 23:06:55" }]

12.3.3. Thola uhlu lwamadivayisi - inkambu eyodwa kusuka kuzimo zamanje ezinomkhawulo

Lo msebenzi ubuyisa idatha enqunyelwe etafuleni le- "_ithings"


http: //%IP%/IoT/que.php? func = i-fieldjson nenkambu = ain5 & min = 13 & max = 5000



Amapharamitha:

i-func - inkambujson

inkambu - Inkambu ezokhonjiswa emiphumeleni - imei futhi i-tm ziyangezwa ngokuzenzakalela

ubuncane - Inani eliphansi lenkambu

ubuningi - inani eliphakeme lenkambu


Okwezintambo zombuzo ezingenhla kuyabuya imiphumela ye- ain5, imei, tm izinkambu:

uma aku5 ibanga (13,5000)


Imiphumela yombuzo:

[{"imei":"353080090069142", "tm":"2019-03-14 11:51:01", "aku5":"14" },

{"imei":"356345080018095", "tm":"2019-02-20 09:13:04", "aku5":"115" },

{"imei":"karczew", "tm":"2019-03-07 13:08:22", "aku5":"103" }]