@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


1. Nhanganyaya.

@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.

1.1 Yakatsigirwa mhando dzemidziyo.

@City IoT chikuva chakakumikidzwa mukutevera iSys.PL zvigadzirwa



1.2. Akatsigira zvigadzirwa mhando.

@City (eCity) Cloud IoT Platform yakasiyanasiyana saizi sisitimu yezvinhu IP - zvigadzirwa (zvinodaidzwa pamwechete se @City Hardware kana CioT Midziyo ):


1.3. Zvirongwa zvekutaurirana zvakatsigirwa

@City IoT chikuva chinotsigira zvinotevera maprotocol ekutaurirana:

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. ).


1.4. Yakatsigirwa Kutaurirana Tekinoroji yeZvivakwa

@City IoT chikuva chinotsigira:


@City atform Platform yakatsaurwa kune zvishandiso / node:


1.5. @City Cloud Server

@City software inoshanda paLinux based VPS (Virtual Yakavanzika Server) kana Dedicated Server padivi internet, zvinoenderana nekukumbira kuita kweiyo Server (inonzi gare gare Server):


Mhando dzakasiyana dzeVPS dziripo zvichienderana ne:


Zvizhinji zveDedicated server iripo zvichienderana ne:


Iyo @City IoT chikuva chakakumikidzwa kune mumwechete mutengi:


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.

1.5.1. Server uye kutaurirana masuo

Kutaurirana kwe @City Server kunoonekwa zvichibva pane yakaderera nhanho kunyorera kwekuita maximalization.

Main maficha e @City Server application ndeaya:

@City Server software yakafanana kune yega yega mushandisi uye haigone kuve yakagadzirirwa vatengi vakasiyana.

1.5.2 HTTP Kubatanidzwa kweRoRaWAN

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.

1.5.3. Mberi-kumagumo interface

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.

1.5.3. Kodzero dzekuwana Server

Kodzero dzevatengi dzekuwana (kune yepanyama Server) ishoma.

Faira kuwana ye "matemplate" dhairekitori chete (zvemavara zvinyorwa zvemafaira - .txt, .js, .css, .html):

Dzimwe kodzero dzekuwana:


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.


1.6. Smart Zvishandiso

1.6.1. CIoT - GSM zvishandiso

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".


1.6.3. BAS, BMS, IoT - Ethernet uye neWiFi zvishandiso


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


1.6.2. IoT - zvishandiso zveLoRaWAN

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.

1.7. Bhizinesi kune Bhizinesi (B2B) sarudzo


Pane zvakawanda zvingasarudzwa zvebhizinesi pamwe nekubatana:

2. @City atform Platform Kushanda

@City chikuva inotsigira inogadziriswa Front-End template yekuona dhata, mubvunzo, kudzikisira nekugadzirisa (Yazvino / dhata dhata):


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.


3. Main Peji

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


4. Main Fomu

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)

4.1. Musoro

4.1.1. Musha Unganidzo - (inovhura tafura yemhedzisiro)

4.1.2. "X" cheki bhokisi - rinovhura / rinovhara Query Fomu

4.1.3. "V" cheki bhokisi - rinovhura / rinovhara Minda Yemafomu

4.1.4. Mifananidzo yemifananidzo - zvinongedzo kumhedzisiro yekuona (inogadziriswa)


4.2. Fomu:

4.2.1. "X" cheki bhokisi - rinovhura / rinovhara yakazara Query Fomu

4.2.2. CSS - Sarudza Visualization theme

Chinja Visualization theme CSS faira inofanirwa kunge iri mu "matemplate / css /" dhairekitori - yakanyorwa otomatiki.

Minda inooneka cheki bhokisi - rinoratidza / rinohwanda Munda Wedzeresa Chinyorwa

4.2.4. Tab: Tab Zita rekuwedzera kana kubvisa

4.2.5. Wedzera / Bvisa Mabhatani - Wedzera kana kubvisa mabhu ane zita mu Tab munda

4.2.6. Sarudza Core Bhatani

Sarudza minda mikuru inoonekwa patafura. It yakagadziridzwa otomatiki.

4.2.7. Sarudza Zvese Bhatani

Sarudza minda yese (inofanirwa kuteverwa nekusarudza mamwe acho nemaoko)

4.2.7. Sarudza zvose Bhatani

Sarudza minda yese (inofanirwa kuteverwa nekusarudza mamwe acho nemaoko)

4.2.8. Viga Sefa - Viga Fomu rose

Izvi zvakaenzana neese (X) bhokisi rekutarisa

4.2.9. Kuuraya Bhatani - Chinja parameter marongero

4.2.10. "V" cheki bhokisi - show / yakakwira mafirita minda.


4.3. Tabs

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).


4.4. Tafura Zviri Mukati

Inoratidza minda yese inoganhurirwa neMunda Firita.


Minda iri patafura:

4.4.1. Mhanya - maonero mhedzisiro mhando

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).


4.4.2. Kopa (+/- zvinongedzo)

Kuwedzera / kubvisa Tab ine zita rakaiswa mukati Tab munda. Iyo inoshandisa chete minda yakasarudzwa mumutsara mumwe chete wetafura.


4.4.3. Tafura Cell Zvinongedzo

Kudzvanya chero rimwe zita remunda kuchatanga Data Kuona kwenzvimbo yakasarudzwa yemutsara wakasarudzwa.


4.5. Dhata Dhata


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).


4.6. Semuenzaniso

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.

  1. Isa zita "Kuchengeta Asset" mukati Tab munda (isina makotesheni)

  2. Ita shuwa kuti ese makoramu haana kusarudzwa mumutsara

  3. sarudza tm, gps_speed_km chete mumutsara

  4. Dhinda + bhatani iko mumutsara






5. Mepu

Mamepu anogona kuvhurwa kubva MainForm ine pre-yekumisikidza


5.1. Mepu Kutanga

Mepu yekutanga inoitwa nemaoko kana yaitwa zvakananga neiyi link: > http: //%IP%/IoT/maps.php


  1. Mushandisi anofanira Kusarudzira minda yese (Press Sarudza Bhatani)

  2. Dhinda rimwe bhokisi rekutarisa minda yakaratidzwa (semuenzaniso. Ain5 (yezinga reSmog) uye tm (yezuva rekuyera / nguva)

  3. Dhinda "V" bhokisi rekutarisa kuviga minda fomu

  4. Dhinda Kuuraya bhatani kumhanya mubvunzo weDB uye kuratidza ruzivo rwezvino kubva kuma sensors / zvishandiso

  5. Mepu ine data inovandudzwa mushure memasekondi makumi matatu kana kudarika.


5.2. Inesarudzo Zvirongwa zvemubvunzo

Zvirongwa zvinotsanangurwa kubva kuruboshwe kuenda kurudyi (pane pamusoro skrini).

5.2.1. Chinja MAP chikero (Zoom Chikamu)

  1. Zoom level inogona kuchinjwa uchishandisa (+/-) mabhatani ekuyera (current_scale * 2 kana current_scale / 2 zvakateerana). Kudzvanya imwe yeiyi mabhatani kuchachinja zviyero pachayo.

  2. 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).

5.2.2. IMEI (Sarudza Munda Midziyo)

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.


5.2.3. Lon, Lat (Longitude, Latitude inoratidzira minda)

Gadza nzvimbo yepakati yemepu. Iyi munda yakagadzirirwa nzvimbo yekutambanudza kana bhatani remouse rakadzvanywa pamepu.


5.2.4. Chinja MAP Chimiro (Musoro)

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.


5.2.5. PAPI Clause

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.

  1. gps_speed_km> 10 // kumhanya kunopfuura gumikm / h

  2. ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)

  3. gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)


5.2.6. Kuuraya (Mhanya Query Bhatani)

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.

5.2.7. Sarudza Zvese (Bvisa minda yese kubva kumubvunzo)

Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvabuda pamepu.


5.2.8. "V" Checkbox (Vhura / Vhara Munda Fomu)

Iri bhokisi rekutarisa rinoshandiswa kuratidza / kuviga musarudzo yeminda yekuratidza.


5.2.9. "X" Checkbox (Ratidza / Hide Query Fomu)

Iri bhokisi rekutarisa rinogonesa kuviga Fomu rese kunze ( +/- mabhatani)


Mhedzisiro pamepu inoramba ichizorodzwa uye ichivandudzwa nemitengo mitsva

5.3. Semuenzaniso

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



6. Ratidza Mhedzisiro muTafura

Ratidza zvawanikwa mutafura.

Vhura "Main Fomu" Dhinda "tafura" chinhu, mushure mekusarudza mimwe minda kuratidza pre-yakagadzirirwa tafura




6.1. Kutanga kwetafura

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.



  1. Dhinda zvese zvinotarisirwa bhokisi rekutarisa minda yakaratidzwa

  2. Dhinda bhokisi rekutarisa "Minda Inoonekwa" kuviga minda fomu

  3. Dhinda Enzesa bhatani kumhanya DB query uye kuratidza tafura


6.2. Inesarudzo Zvirongwa zvemubvunzo

Zvirongwa zvinotsanangurwa kubva kuruboshwe kuenda kurudyi (pane iyo skrini).

6.2.1. Ronga - rongedza munda uye odha kukwira / kuburuka

Sort munda wakaenzana nekutsikirira musoro musoro.

6.2.2. DB / IMEI - Sarudza Mudziyo

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.


6.2.3. CSS - sarudza chimiro (Visualization theme)

6.2.4. Minda Inoonekwa - Ratidza / Viga Minda Fomu

6.2.5. Bvisa Chisina - Usaratidze makoramu asina chinhu

6.2.6. "X" Checkbox (Ratidza / Hide Query Fomu)

6.2.7. Kupi Chirevo (yekuganhurirwa kwedata)

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.

  1. gps_speed_km> 10 // kumhanya kunopfuura gumikm / h

  2. ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)

  3. gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)


6.2.8. Sarudza Core Bhatani (Bvumira akajairika minda)


6.2.9. Sarudza Zvese Bhatani (Bvisa minda yese kubva kumubvunzo)

Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvabuda pamepu.


6.2.10. Kuuraya (Mhanya Query Bhatani)

Kudzvanya bhatani iri kunodiwa kuti uchinje chero marongero, paramita (kunze kwekutsikirira +/- mabhatani).

Tafura inotakurwa zvakare kubva pakutanga neyakafanogadzirirwa nyowani.



6.2.11. "V" Checkbox (Vhura / Vhara Munda Fomu)

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.


7. Bar Charts.

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.


8. Machati Ezvakaitika.

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.

8.1. Kutanga kweye Historical machati


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.




  1. Dhinda zvese zvinotarisirwa bhokisi rekutarisa minda yakaratidzwa

  2. Dhinda bhokisi rekutarisa "Minda Inoonekwa" kuviga minda fomu

  3. Dhinda Ita bhatani kumhanya mubvunzo weDB uye kuratidza tafura


8.2. Zvingasarudzika Zvirongwa zveNhoroondo maChati

Zvinhu zvinotsanangurwa kubva kumusoro uye kubva kuruboshwe kuenda kurudyi (pane iyo skrini).

8.2.1. IMEI - (Sarudza Mudziyo kuratidza nhoroondo yezvakaitika)

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.

8.2.2. Min - gumira shoma kukosha kwekutanga munda

8.2.3. Max - gumira huwandu hwakanyanya hwenzvimbo yekutanga

8.2.4. "V" - Ratidza / Viga Minda Fomu

8.2.5. Kubva: seta shoma zuva / nguva (*)

8.2.6. Ku: gadza rakakura zuva / nguva (*)

8.2.7. "X" Checkbox (Ratidza / Hide Query Fomu)

8.2.8. "Kupi" Chirevo

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.

  1. gps_speed_km> 10 // kumhanya kunopfuura gumikm / h

  2. ain5> 3 // ain5 yakakura kudarika matatu (yakabata 2.5um particles count - smog level)

  3. gps_speed_km> 10 uye ain6> 5 // kumhanya kunodarika 10km / h uye ain6 yakakura kupfuura mashanu (akabata gumium zvikamu zvekuverenga - smog level)


8.2.9. Sarudza Zvese Bhatani (Bvisa minda yese kubva kumubvunzo)

Mushure mekubaya bhatani iri kanenge munda mumwe chete unofanirwa kusarudzwa nemaoko kuratidza zvaitika kare.


8.2.10. Kuuraya (Mhanya Query Bhatani)

Kudzvanya bhatani iri kunodiwa kuti uchinje chero marongero, paramita (kunze kwekuratidza minda kana pani yemubvunzo). Tafura inotakurwa zvakare kubva pakutanga neyakafanogadzirirwa nyowani.

8.2.11. "V" Checkbox (Vhura / Vhara Munda Fomu)

Iri bhokisi rekutarisa rinoshandiswa kuratidza / kuviga musarudzo yeminda yekuratidza.


8.3. Mabhawa Musiyano: (inoratidza chete iripo data)



8.4. Kuenderera mberi zvakasiyana (iine data rakafanana):



Mouse pointer inoratidza kukosha kwezviyero uye zuva / nguva.

9. Webhu saiti kuenderana


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.



10. Themes Kugadziriswa

Mapeji eWebhu anobva pane yakajairwa template faira iri pa "matemplate" dhairekitori "* .template".

Kuwedzera yega yega peji peji rine:

  1. "*. musoro" faira inochengeta musoro wenyaya peji (zvinongedzo, kupinza CSS, JavaScript Mafaera, nezvimwe. )

  2. "* .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.

11. Algorithms Kwidziridzo


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.


12. Dhatabhesi Dhizaini


@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):

Mamwe matafura:



12.1. "ithings_" uye "*" matafura chimiro

12.2. Midziyo yemidziyo (Zviitiko) mutsetse "* _c" tafura - chimiro


Iyi tafura chiitiko / mirairo pamutsara wechigadzirwa chimwe nechimwe uye ine inotevera mamiriro:



12.3. Kuwana mhedzisiro kubva kudhatabhesi - Mid-Chikamu (Kuverenga Dhata)


Dhata inogona kuwanikwa pasina Front-end Webhu kunyorera. @City Sisitimu ine script ine epakati-chikamu mabasa. Mhedzisiro inodzoserwa muJSON fomati.


12.3.1. Tora zvimiro zvazvino zvemidziyo yese

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":"" }]

12.3.2. Tora Nhoroondo dhata yeMudziyo

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" }]

12.3.3. Tora runyorwa rwezvigadzirwa - imwechete munda kubva kumatunhu echinyakare ane muganho

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" }]