@Umujyi IoT Igicu

iSys - Sisitemu Yubwenge IoT Ibisubizo

IoE.Sisitemu

1. Intangiriro.

@Umujyi Plat Ihuriro ryibicu ryeguriwe "micro-igicu" Sisitemu kubakiriya kugiti cyabo. Ihuriro ntirisangirwa kandi umukiriya umwe gusa niwe ushobora kubona seriveri yumubiri cyangwa igaragara (VPS cyangwa seriveri zabigenewe). Umukiriya arashobora guhitamo imwe muma data-centre yuburayi cyangwa kwisi.

1.1 Ubwoko bwibikoresho bishyigikiwe.

@Umujyi IoT urubuga rweguriwe gukurikira ibicuruzwa bya iSys.PL

• - RF / LoRaWAN (Internet yibintu)

• CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Interineti Yibintu)

• WiFi

• Ethernet

1.2. Ubwoko bwibicuruzwa bishyigikiwe.

@Umujyi (eCity) Igicu form Ihuriro nubunini butandukanye bwa sisitemu ya IP IoT ibicuruzwa (byitwa hamwe nka @City Hardware cyangwa Ibikoresho bya CioT ):

• @Umujyi

• @Umucyo

• @Metering

• @Trace

• @AirQ

• @Bin

1.3. Gushyigikira protocole y'itumanaho

@Umujyi IoT urubuga rushyigikira protocole ikurikira yo gutumanaho:

• UDP - yatanzwe kuri sensor ya CIoT / ibikoresho (cyane cyane NBIoT) - gukoresha amakuru make

• TCPIP - yatanzwe kubikoresho bifite itumanaho ryerekezo - gukubita intoki / kwemeza

• HTTP - yatanzwe gusa kubijyanye no kubona amakuru / iyerekwa / kohereza / "igicu"

• HTTP Urubuga - kubitumanaho bya LoRaWAN hagati ya Network ya LoRaWAN / Seriveri ya Porogaramu na @City Cloud.

Amakuru yoherejwe kuva mugenzuzi kuri seriveri ya seriveri na versa ihishe muburyo budasanzwe bwa binini kubunini bwamakuru make kandi byongerewe umutekano. Buri mufatanyabikorwa abona urufunguzo rwihariye rwibanga rwo kwemerera ibikoresho, kugenzura amakuru yemewe, nibindi.

Kubikoresho bitari eHouse / eCity turashobora gutanga algorithm ya encryption kugiti cye ( "C" inkomoko yinkomoko) kuri buri mufatanyabikorwa kuri microprocessor kugirango arinde amakuru mbere yitumanaho.

Muri iki gihe amakuru afite umutekano rwose mugihe cyitumanaho ryibice byombi kubitangazamakuru rusange (interineti, Umuyaga, nibindi. ).

1.4. Gushyigikira Ikoranabuhanga mu Itumanaho ryibikoresho

@Umujyi IoT urubuga rushyigikira:

• GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - ibikoresho (itumanaho rya UDP / TCPIP)

• Ibikoresho bya LoRaWAN (Urubuga rwa HTTP) - ukoresheje amarembo ya LoRaWAN hamwe numuyoboro wa LoRaWAN / seriveri

• Abagenzuzi ba Ethernet (itumanaho rya UDP / TCP)

• Abagenzuzi ba WiFi (itumanaho rya UDP / TCP)

• Ibicuruzwa bya IP bizaza

• Ibicuruzwa bitari IP ukoresheje inyongera yaho @ Umujyi / eHouse.PRO Irembo ryibikoresho

@Umujyi IoT Ihuriro ryeguriwe ibikoresho / node:

• Ibicuruzwa bya iSys kavukire:

  • CIoT (GSM / 2G / 3G / 4G / CATM1 / NBIoT)

  • (LoRaWAN)

  • WiFi - ibicuruzwa byabugenewe kuri @Umujyi

  • Ethernet - ibicuruzwa byabugenewe bya @Umujyi

• Ibicuruzwa biva mu mahanga (byakozwe nabandi bantu munsi yimpushya za iSys nibirango byo hanze)

• Ibicuruzwa bya francise (byakozwe nabandi bantu bafite uruhushya rwa iSys hamwe na logo ya iSys)

1.5. @Umujyi Igicu Seriveri

@City software ikora kuri Linux ishingiye kuri VPS (Virtual Private Server) cyangwa Seriveri Yeguriwe kuruhande rwa interineti, ukurikije imikorere isabwa ya Seriveri (bita nyuma Seriveri):

• kwiherera / kugana rusange

• muri rusange ibikoresho bibara

• kuvugurura ibikoresho imiterere inshuro

• igipimo cyo kugarura amakuru

Impinduka nyinshi za VPS zirahari bitewe na:

• Igiciro

• amakuru-hagati ya geo-yegereye

• Ibikoresho bitunganijwe neza (1-8)

• RAM ya Virtual (1-32GB)

• Disiki ya SSD (20GB-1TB)

Seriveri nyinshi zabigenewe zirahari bitewe na:

• Igiciro

• amakuru-hagati ya geo-yegereye

• Ibikoresho bitunganijwe (4 .. 32)

• RAM (16 .. 512GB)

• SSD / HDD (256GB .. 8TB)

@City IoT platform yeguriwe umukiriya umwe:

• inzego z'ibanze n'abayobozi (Umujyi, Umuryango, Igihugu)

• B2B (kuri nyir'abandi)

Kuberako idasangiwe na seriveri hagati yabakiriya, yoroshya uburyo bwo kubona umutekano nibibazo byimikorere. Kubera iyo mpamvu, abakiriya gusa ni bo bashinzwe umutekano, umutekano, gukora neza, kwinjiza amakuru, nibindi. Mugihe imikorere idahagije, umukiriya arashobora kugura gahunda ihanitse (VPS cyangwa Seriveri yihariye), birashoboka cyane kubikorwa byateganijwe nibikorwa.

Mu bihe bidasanzwe "Cloud to cloud" itumanaho rishobora gushyirwa mubikorwa byo kwishyira hamwe no guhuza amakuru ahantu hanini aho kuba abakiriya benshi.

1.5.1. Seriveri n'itumanaho

Itumanaho rya @Umujyi Serveri ryagerwaho hashingiwe ku rwego rwo hasi rwo gusaba gukora cyane.

Ibyingenzi byingenzi bya porogaramu ya @City Server ni:

• idahwitse yakira amakuru avuye mubikoresho (ukoresheje protocole: UDP, TCP IP, HTTP)

• gabanya imikoreshereze yamakuru nigiciro cyayo hagati yibikoresho na Cloud (ukoresheje protocole yo mu rwego rwo hasi UDP, TCP IP)

• yakira ibanga ryibikoresho (ukoresheje itangazamakuru iryo ari ryo ryose ryitumanaho)

• uburenganzira no kwemeza amakuru avuye mubikoresho mugusiba statuts zabo

• gushushanya ibikoresho byimiterere no kuyivugurura mumeza ya MariaDB / MySQL muburyo butaziguye (muburyo bwamakuru)

  • imbonerahamwe yamakuru agezweho (ikubiyemo gusa imiterere mishya ya buri gikoresho)

  • imbonerahamwe yamakuru yamateka (ikubiyemo statuts zose kubikoresho bimwe)

• ohereza amategeko ategereje (Ibyabaye) kubikoresho

• kwizeza ukuboko, kugenzura no kwemeza

@City Server software ni imwe kuri buri mukoresha kandi ntishobora guhindurwa kubakiriya batandukanye.

1.5.2 Kwishyira hamwe kwa HTTP LoRaWAN

Abagenzuzi ba LoRaWAN bahujwe nigicu cya @Umujyi ukoresheje interineti ya HTTP (webhooks) iboneka kumurongo wa LoRaWAN / seriveri.

Ubwoko butandukanye bwurusobe / porogaramu seriveri irashyigikiwe:

TTN (igihe ntarengwa "Ku kirere" n'umubare ntarengwa w'amabwiriza yoherejwe kuri shoferi kandi ntushyigikire kuzamura software)

LoraWAN-Stack (Irasaba kwakira ku gikoresho gifatika gifite interineti).

LoraServer.Io (Irasaba kwakira ku gikoresho gifatika gifite interineti - kohereza gusa amakuru kuri seriveri kandi ntushyigikire kuzamura software)

Igicu cya @Umujyi kubagenzuzi ba LoRaWAN bigabanijwe muburyo bumwe nkubundi buryo. Byaganiriweho mu gice kibanziriza iki.

1.5.3. Imbere-Impera

Imbere-Impera yimbere igaragara hamwe ninyandiko za PHP zo gukuramo amakuru yihariye muri @City Cloud Data base. Ikoresha uburyo bworoshye bwo gushakisha, bushingiye kubibazo bya SQL byumwimerere kugirango ugabanye amakuru wifuza. Imigaragarire itanga ibisubizo mubisubizo bya JSON kugirango irusheho gushushanya no gutunganya Web Imbere-Urubuga "porogaramu".

Imigirire yumwimerere-impera nimwe kuri buri mukoresha kandi ntishobora guhindurwa kubakiriya batandukanye.

Imigaragarire yuzuye irashobora gushirwaho nabakozi bacu cyangwa mubufatanye kugirango tumenye neza abakiriya.

1.5.3. Uburenganzira bwo kubona seriveri

Uburenganzira bwo kubona abakiriya (kuri seriveri yumubiri) bugarukira.

Ububiko bwa dosiye kububiko bwa "templates" gusa (dosiye yinyandiko kavukire - .txt, .js, .css, .html):

• kongeraho, gukuraho, guhindura dosiye nziza ya HTML (Imbere-Impera ya GUI / Iterambere ryimbere)

• kongeraho, gukuraho, guhindura pure dosiye zuzuye (Imbere-Impera ya GUI / Iterambere rya Interineti na Algorithms)

• kongeraho, gukuraho, guhindura dosiye ya CSS yuzuye (Imbere-Impera - Reba ibintu byihariye / Insanganyamatsiko)

• kongeraho, gukuraho, guhindura dosiye yinyandiko zerekana (Imbere-Impera ya GUI)

• kongeraho, gukuraho, guhindura tabs, shortcuts, guhuza ibisubizo byamakuru

Ubundi burenganzira bwo kubona:

• Kugera byuzuye kuri @City Cloud Data base MySQL / MariaDB aho ububiko bwibikoresho byose bubitswe

• Kugera kuri Serivisi zurubuga bisobanuwe (ibyangombwa) kubakiriya.

• Umukiriya ntabwo yemerewe gutanga ibyangombwa kubandi bantu (kubona ibisubizo byinshi bishobora kugira ingaruka kumikorere, ituze n'umutekano bya sisitemu rusange)

• Mubihe bidasanzwe no gukoresha imikorere yo hejuru Yeguriwe Seriveri, konti rusange irashobora gushyirwaho kugirango turebe amakuru menshi agezweho (ntabwo ari amateka).

• Umukoresha arashobora kwigana amakuru kuri seriveri ye bwite ya MySQL kandi agakora isesengura ryamakuru kandi akanayitunganya, kugirango adahindura imikorere ya @City Server

iSys - Abakozi ba sisitemu yubwenge - bafite uburyo butagira imipaka kuri seriveri yose harimo konti yumuzi hamwe na DB yuzuye yo kubungabunga.

Mubihe bimwe na bimwe iSys irashobora gutanga uburenganzira bwinyongera kubakiriya (inyandiko ya PHP, dosiye) nyuma yo kugenzura code yinkomoko, gukora ibizamini, niba bidafite ingaruka kumutekano rusange, umutekano hamwe nibikorwa.

1.6. Ibikoresho byubwenge

1.6.1. CIoT - ibikoresho bya GSM

Ibikoresho byacu birimo microcontroller na GSM / GPS / GNSS module (2G..4G, NBIoT, CATM1) kugirango itumanaho. Microcontroller ikubiyemo ibanga rya bootloader kugirango ibashe kuzamura porogaramu ya OTA itekanye. Ibi bifasha gukora sisitemu nyinshi zitandukanye zishingiye kuri kimwe "Igikoresho cyubwenge".

1.6.3. BAS, BMS, IoT - Ibikoresho bya Ethernet na WiFi

Igenzura rya Ethernet na WiFi ryemerera itumanaho rishingiye kuri IP kuri sisitemu (utishyuye amafaranga yoherejwe kubakoresha GSM). Ibi bikoresho kandi byabitswe bootloader kandi ibikoresho birashobora kuvugururwa hifashishijwe interineti kavukire. Kuri WiFi ifite porogaramu ya OTA ivugurura kuva seriveri nkuru

1.6.2. - Ibikoresho bya LoRaWAN

LoRaWAN ituma amakuru yoherezwa mumwanya muremure cyane (kugeza hafi. 15km). Uru rutonde rushingiye ku muvuduko wo kohereza amakuru, ingano yamakuru, imijyi yo muri ako karere hamwe nuburyo bwiza bwa radiyo yibikoresho.

Ibikoresho byacu birimo microcontroller na LoRaWAN module yo gutumanaho. Microcontroller ikubiyemo ibanga ryibanga ryibanga rya software ya OTA itekanye. Ibi biragufasha gukora sisitemu nyinshi zitandukanye zishingiye kuri kimwe "IoT smart device". Ibikoresho bikorera muri ISM ifunguye nta yandi mafranga yo kwiyandikisha. Birakenewe gukoresha amarembo ya LoRaWAN kugirango utwikire akarere kose hamwe na enterineti. Kubireba amarembo ya LoRaWAN ariho murwego rwibikoresho (byashyizweho kuri seriveri ya TTN), birashoboka kohereza amakuru binyuze muri bo. Kuzamura software bisaba umuyoboro / porogaramu ya seriveri ya LoRaWAN hamwe nintera nziza yo gutumanaho.

1.7. Ubucuruzi Kubucuruzi (B2B) amahitamo

Hariho uburyo bwinshi bwubucuruzi nubufatanye:

• gutumiza / kohereza ibicuruzwa byiteguye (ibibaho, ibikoresho) - ibicuruzwa byanyuma

• gutumiza / kohereza ibicuruzwa bya OEM (PCBs, abagenzuzi, nibindi) - ibicuruzwa hagati, ibice byabigenewe

• franchise - umusaruro ushingiye ku ruhushya rwacu ku masoko yaho (dutanga microcontrollers gusa) munsi ya iSys - Brands Intelligent Systems Brands

• Gukorera hamwe - (nkuko byavuzwe haruguru) ariko munsi yibicuruzwa byo hanze

2. @Umujyi IoT Imikorere ya platform

@Umujyi ushyigikira icyitegererezo cyimbere-Impera yicyitegererezo cyo kubona amakuru, kubaza, kugabanya no gutunganya (Amakuru / amateka yamakuru):

• tekereza amakuru yatoranijwe ku ikarita (geo-localisation)

• yerekana amakuru yatoranijwe nibisubizo mumeza

• yerekana amakuru yatoranijwe mu mbonerahamwe

• yerekana amakuru yatoranijwe mu mbonerahamwe yamateka

• kohereza amakuru kumurongo wigice cya gatatu no gukomeza gutunganya

• indi mikorere izavugururwa kubisabwa kugiti cye.

Umukoresha Imbere-Impera iraboneka binyuze kuri IP ihagaze cyangwa DNS yohereza indangarubuga / subdomain / dosiye niba ihari.

Kwishyiriraho intangarugero & Demo (Birashoboka gusa kubakiriya).

Nyamuneka utumenyeshe mugihe ushaka kubigerageza - kugirango ushoboze kugera kumurongo.

Irashobora gusaba IP ihagaze ya mudasobwa ya kure kugirango itume itumanaho kuri @Umujyi.

3. Urupapuro nyamukuru

Urupapuro nyamukuru rusigaye ubusa nkana kubwimpamvu z'umutekano: http: //% YourIP% / IoT /

Irashobora gushyirwaho kugiti cye no guhindurwa kandi ikubiyemo amahuza kuri serivisi zose zishoboka za @Umujyi form Ihuriro niba bikenewe

4. Ifishi nyamukuru

Ifishi nyamukuru igamije gukora ibishya na tabs: http: //%IP%/IoT/que.php

Nuburyo bwambere bwo gukora ibisubizo, kureba na tabs kuri buri gikoresho

Ibisobanuro (Kuva hejuru n'ibumoso ugana iburyo)

4.1. Umutwe

4.1.1. Ihuza ry'urugo - (ifungura ibisubizo nyabyo)

4.1.2. "X" agasanduku - gufungura / gufunga Ifishi y'ibibazo

4.1.3. "V" agasanduku - gufungura / gufunga Ifishi yumurima

4.1.4. Udushushondanga - amahuza kubisubizo biboneka (bikosorwa)

4.2. Ifishi:

4.2.1. "X" agasanduku - gufungura / gufunga Ifishi yose yibibazo

4.2.2. CSS - Hitamo Insanganyamatsiko

Hindura Amashusho ya CSS dosiye igomba kubaho muri "Inyandikorugero / css /" ububiko - urutonde rwikora.

4.2.3.Imirima igaragara agasanduku - yerekana / ahisha Umwanya wo kuyungurura urutonde

4.2.4. Tab: Izina rya Tab kugirango wongere cyangwa ukureho

4.2.5. Ongeraho / Kuraho Utubuto - Ongeraho cyangwa ukureho tabs hamwe nizina muri Tab umurima

4.2.6. Hitamo Core Button

Hitamo imirima nyamukuru igaragara kumeza. Ni ni bishya mu buryo bwikora.

4.2.7. Hitamo Byose Button

Hitamo imirima yose (igomba gukurikizwa no guhitamo bimwe murintoki)

4.2.7. Hitamo byose Button

Hitamo imirima yose (igomba gukurikizwa no guhitamo bimwe murintoki)

4.2.8. Hisha Akayunguruzo - Hisha Ifishi yose

Ibi bihwanye na agasanduku kose (X)

4.2.9. Kora Buto - Hindura ibipimo byimiterere

4.2.10. "V" agasanduku - kwerekana / hejuru muyunguruzi.

4.3. Tab

Umuntu ku giti cye yaremye ama tabs hamwe namazina (yabitswe muri cfg / tabs.cfg dosiye).

Idosiye ikubiyemo izina na URL (bitandukanijwe na tab char).

4.4. Imbonerahamwe

Yerekana imirima yose igarukira kumurima.

Imirima iri kumeza:

4.4.1. Kwiruka - Reba ibisubizo Ubwoko

ikarita- gushushanya ibisubizo ku ikarita (umurima umwe cyangwa byinshi ushobora gutoranywa)

amateka - imbonerahamwe yamateka (umurima umwe cyangwa byinshi birashobora gutorwa)

tab - yerekana imbonerahamwe (ihuriro ryose ryimirima irashobora gutoranywa)

bar - umurima umwe gusa ugaragara kumashusho yumurongo

Kanda kamwe mu gaciro kayo bizafungura ibisubizo bishya hamwe nimirima yatoranijwe (kumurongo wubu).

4.4.2. Gukoporora (+/- amahuza)

Ongeraho / ukureho Tab ifite izina ryashyizweho Tab umurima. Ikoresha gusa imirima yatoranijwe kumurongo umwe wimeza.

4.4.3. Imbonerahamwe Ihuza Akagari

Kanda irindi zina ryizina bizatangiza Data Visualisation yumurima watoranijwe kumurongo watoranijwe.

4.5. Itondekanya ryamakuru

Itondekanya ryimirima yerekanwe nuburyo bwayo muburyo bwimirima (nyamara tm umurima uhora wohereza kumpera yinyandiko). Iri teka rishobora guhinduka gusa hamwe no guhindura ibice bya URL (igice cyateganijwe igice).

4.6. Urugero

Kurugero: Gushiraho Tab hamwe Gukurikirana Umutungo izina kandi ikubiyemo ikarita hamwe nigihe n'umuvuduko kurikarita

Ibisobanuro byose bivuga umurongo aho "Map" inyandiko iri "Iruka" inkingi.

1. Injiza izina "Gukurikirana Umutungo" in Tab umurima (udafite ibimenyetso byavuzwe)

2. Menya neza ko inkingi zose zitatoranijwe kumurongo

3. hitamo tm, gps_umuvuduko_km gusa ku murongo

4. kanda + buto aho kumurongo

5. Ikarita

Ikarita irashobora gutangizwa muri MainForm hamwe nuburyo bwabanjirije

5.1. Gutangiza Ikarita

Gutangiza ikarita bikorwa nintoki iyo bikozwe neza na link: > http: //%IP%/IoT/maps.php

1. 
   Umukoresha agomba Guhitamo imirima yose (Kanda Guhitamo Button)

2. Kanda ahanditse agasanduku k'imirima yerekanwe (urugero. Ain5 (kurwego rwumwotsi) na tm (yo gupima itariki / isaha)

3. kanda "V" agasanduku kugirango uhishe imirima ifishi

4. kanda Kora buto kugirango ukore DB ikibazo kandi werekane amakuru agezweho kuva sensor zose / ibikoresho

5. Ikarita ifite amakuru ivugururwa nyuma yamasegonda 30 cyangwa arenga.

5.2. Igenamiterere ridahinduka kubibazo

Igenamiterere ryasobanuwe uhereye ibumoso ugana iburyo (hejuru yerekana ishusho).

5.2.1. Hindura igipimo cya MAP (Urwego rwo hejuru)

1. Urwego rwohinduranya rushobora guhindurwa ukoresheje (+/-) buto yubunini (igipimo_cyerekezo * 2 cyangwa ikigezweho / 2). Kanda imwe muriyi buto izahita ihindura igipimo.

2. Ubundi buryo ni uguhitamo Kuzamura Urwego muri Kuzamura Agasanduku ka Combo hanyuma ukande Kora buto. Muri iki kibazo cyose Reba / Ikarita irongera kandi igarurwa (ifata igihe mugihe cyo gutangira).

5.2.2. IMEI (Hitamo Umwanya wibikoresho)

IMEIumurima urimo igikoresho ID idasanzwe cyangwa izina ryihariye kubikoresho. Igenamiterere risanzwe ni * (inyenyeri) yerekana indangagaciro ziheruka na geolokisiyo kuri buri gikoresho.

Gushiraho IMEI kubindi bikoresho byose, bizerekana amakuru yamateka yibikoresho byatoranijwe. Ifite ibisobanuro gusa kuri mobile na sensor igenda, bitabaye ibyo ibisubizo bizahurira ku ikarita kumwanya umwe.

5.2.3. Lon, Lat (Uburebure, Uburinganire buhuza imirima)

Shiraho umwanya wikarita. Uyu murima washyizweho indanga umwanya iyo buto yimbeba ikanda ku ikarita.

5.2.4. Hindura uburyo bwa MAP (Insanganyamatsiko)

Ikarita yuburyo / insanganyamatsiko irashobora guhitamo kuva Map Umwanya wa ComboBox (urugero. Umwijima, Icyatsi, Topografiya).

Ikarita zitandukanye zinsanganyamatsiko zishobora kugira urwego runini rwo kugereranya kugirango rushobore gukurikiza Insanganyamatsiko ikwiye yo kongera igipimo cyikarita.

5.2.5. AHO Ingingo

Aho Ingingo ikoreshwa kumurongo wongeyeho ikibazo {AHO igice} kuri MySQL / MariaDB.

Iyi ngingo yitabwaho kugirango yubake umurongo wuzuye wa QUERY kubisubizo byububiko. Irashobora kugabanya amakuru, igihe nizindi ndangagaciro mugabanya ibisubizo bibarwa. Amazina yumwimerere yumurima (ntabwo ari alias) agomba gukoreshwa muriki gice. Urugero.

1. gps_umuvuduko_km> 10 // umuvuduko urenze 10km / h

2. ain5> 3 // ain5 irarenze 3 (ifata ibice 2,5um ibara - urwego rwumwotsi)

3. gps_umuvuduko_km> 10 na ain6> 5 // umuvuduko urenze 10km / h naho ain6 irenze 5 (gufata ibice 10um ibara - urwego rwumwotsi)

5.2.6. Kora (Koresha Ikibazo Buto)

Kanda iyi buto birasabwa guhindura igenamiterere iryo ariryo ryose, ibipimo (usibye gukanda +/- buto).

Ikarita yapakiwe guhera muntangiriro hamwe nibishya.

Ikarita ntabwo yapakiwe na gato, mugihe nta makuru aboneka kubibazo biriho.

5.2.7. Hitamo Byose (Kuraho imirima yose kubibazo)

Nyuma yo gukanda iyi buto byibuze umurima umwe ugomba gutoranywa nintoki kugirango werekane ibisubizo kurikarita.

5.2.8. "V" Agasanduku (Gufungura / Gufunga Ifishi yumurima)

Agasanduku gakoreshwa mukwerekana / guhisha abatoranya imirima kugirango berekane.

5.2.9. "X" Agasanduku (Erekana / Hisha Ifishi y'Ibibazo)

Agasanduku gashoboza guhisha Ifishi yose usibye ( +/- buto)

Ibisubizo ku ikarita bikomeza kugarurwa no kuvugururwa nindangagaciro nshya

5.3. Urugero

Urugero ibisubizo byumwotsi (Sensor yashyizwe kumodoka): Urwego rwumwotsi 2.5um (Ain5), Umuvuduko (gps_speed_km), Itariki / Igihe (tm), ikarita (2 - topografiya), zoom urwego 16,

Aho ingingo:

"gps_fix = 3 na tm> "2019-02-18 00:00:00" na tm <"2019-02-19 00:00:00" na gps_umuvuduko_km> 0".

// GPS = ibisubizo bya 3D byemewe & itariki = 2019-02-18 & umuvuduko> 0 km / h

6. Erekana ibisubizo mu mbonerahamwe

Erekana ibisubizo kumeza.

Kuri "Ifishi nyamukuru" kanda "ameza" ikintu, nyuma yo guhitamo imirima imwe kugirango yerekane imbonerahamwe yabanjirije

6.1. Gutangiza imbonerahamwe

Iyo imbonerahamwe ifunguye kuva kumurongo http: //%IP%/IoT/que.php? imikorere = tabs bisaba gutangiza mbere igenamiterere.

Urashobora guhitamo imirima igaragara (mukanda "Imirima igaragara" agasanduku.

1. Kanda ibisobanuro byose bisabwa kugirango ubone imirima yerekanwe

2. Kanda agasanduku "Imirima igaragara" guhisha imirima ifishi

3. Kanda ahanditse Execute kugirango ukore ikibazo cya DB hanyuma werekane imbonerahamwe

6.2. Igenamiterere ridahinduka kubibazo

Igenamiterere risobanurwa uhereye ibumoso ugana iburyo (kuri ecran).

6.2.1. Sort - gutondekanya umurima no gutondeka kuzamuka / kumanuka

Gutandukanya umurima uhwanye no gukanda inkingi umutwe.

6.2.2. DB / IMEI - Hitamo Igikoresho

IMEIumurima urimo igikoresho ID idasanzwe cyangwa izina ryihariye kubikoresho. Hamwe nagaciro kerekana imbonerahamwe yagaciro kanyuma.

Gushiraho IMEI kubindi bikoresho byose, bizerekana amakuru yamateka yibikoresho byatoranijwe.

6.2.3. CSS - hitamo uburyo (Insanganyamatsiko)

6.2.4. Imirima igaragara - Erekana / Hisha Ifishi Yumurima

6.2.5. Kuraho Ubusa - Ntugaragaze inkingi zubusa

6.2.6. "X" Agasanduku (Erekana / Hisha Ifishi y'Ibibazo)

6.2.7. Aho Ingingo (kubijyanye no kugabanya amakuru)

Nibisobanuro kuri MySQL / MariaDB umugozi wibibazo byongeweho {AHO igice}

Iyi ngingo ifatwa kugirango yubake umurongo wa QUERY wuzuye kubisubizo byububiko. Irashobora kugabanya amakuru, igihe nizindi ndangagaciro mugabanya ibisubizo bibarwa. Amazina yumwimerere yumurima (ntabwo ari alias) agomba gukoreshwa muriki gice. Urugero.

1. gps_umuvuduko_km> 10 // umuvuduko urenze 10km / h

2. ain5> 3 // ain5 irarenze 3 (ifata ibice 2,5um ibara - urwego rwumwotsi)

3. gps_umuvuduko_km> 10 na ain6> 5 // umuvuduko urenze 10km / h naho ain6 irenze 5 (gufata ibice 10um ibara - urwego rwumwotsi)

6.2.8. Hitamo Core Buto (Gushoboza imirima isanzwe)

6.2.9. Hitamo Byose Buto (Kuraho imirima yose kubibazo)

Nyuma yo gukanda iyi buto byibuze umurima umwe ugomba gutoranywa nintoki kugirango werekane ibisubizo kurikarita.

6.2.10. Kora (Koresha Ikibazo Buto)

Kanda iyi buto birasabwa guhindura igenamiterere iryo ariryo ryose, ibipimo (usibye gukanda +/- buto).

Imbonerahamwe yongeye gusubirwamo kuva itangiriro hamwe nibishya.

6.2.11. "V" Agasanduku (Gufungura / Gufunga Ifishi yumurima)

Agasanduku gakoreshwa mukwerekana / guhisha abatoranya imirima kugirango berekane.

Ibisubizo mu mbonerahamwe byatoranijwe ukurikije Sort Igenamiterere. Gutondekanya gahunda birashobora guhinduka mukanda kumurongo umutwe (rimwe kumurongo umwe kabiri kubindi byerekezo).

Ibisubizo bimwe murinkingi bihuza kugirango ubone amashusho (bigoye-code).

Mugihe werekana amakuru yamateka kubikoresho bigomba kuba bike kugirango bitagaragaza amateka yose kuko bishobora kuganisha kumikorere cyangwa hanze yibibazo byo kwibuka.

7. Imbonerahamwe y'utubari.

Imbonerahamwe yumurongo igomba gukorwa kuva kuri Main Main ukanda umurima umwe kumurongo "Bar".

Yerekana utubari dutondekanye dusanzwe kugeza ku giciro kinini, yerekana kuva hejuru kugeza hasi.

Nibyiza kugenzura byihuse ibisubizo bikabije no gufata ibikorwa bimwe.

Imbeba Kurenza ibyabaye izerekana amakuru yinyongera kubikoresho.

8. Imbonerahamwe yamateka.

Imbonerahamwe yamateka irashobora gutangizwa kuva muri MainForm mugihe ukanze inkingi yatoranijwe kumurongo "Amateka" (kumurima umwe).

Kubice byinshi mumirongo "Amateka" umurongo wifuzwa ugomba kugenzurwa kandi "Amateka" ihuza igomba gukanda kumurongo "Kwiruka".

Ibisubizo byamateka bigarukira kumasaha 24 yanyuma + amasaha 24 ataha (kubishushanyo mbonera bigarura ubuyanja), mugihe nta mbibi zashyizweho.

8.1. Gutangiza imbonerahamwe yamateka

Imbonerahamwe yamateka iyo ifunguye kumurongo wingenzi bisaba gutangira nkibindi bisubizo, iyo ufunguye kumurongo udafite ibipimo byifuzo.

Imirima myinshi irashobora gutoranywa kugirango yerekane ibintu bitandukanye. Irashobora kandi gushyirwaho muburyo bwo kuyungurura.

1. Kanda ibisobanuro byose bisabwa kugirango ubone imirima yerekanwe

2. Kanda agasanduku "Imirima igaragara" guhisha imirima ifishi

3. Kanda ahanditse Execute kugirango ukore ikibazo cya DB hanyuma werekane imbonerahamwe

8.2. Igenamiterere ridahwitse ryamateka

Ibintu byasobanuwe kuva hejuru no kuva ibumoso ugana iburyo (kuri ecran).

8.2.1. IMEI - (Hitamo Igikoresho kugirango werekane amakuru yamateka)

IMEIumurima urimo igikoresho ID idasanzwe cyangwa izina ryihariye kubikoresho. Hamwe na * (asterix) agaciro yerekana imbonerahamwe yindangagaciro ziheruka zidafite ubusobanuro.

Gushiraho IMEI kubindi bikoresho byose, bizerekana amakuru yamateka yibikoresho byatoranijwe.

8.2.2. Min - kugabanya agaciro gake kumurima wambere

8.2.3. Icyiza - kugabanya agaciro ntarengwa k'umurima wambere

8.2.4. "V" - Erekana / Hisha Ifishi Yumurima

8.2.5. Kuva: shiraho itariki ntarengwa / igihe (*)

8.2.6. Kuri: shiraho itariki ntarengwa itariki / isaha (*)

8.2.7. "X" Agasanduku (Erekana / Hisha Ifishi y'Ibibazo)

8.2.8. "Aho" Ingingo

Ingingo yo kugabanya ibisubizo byamakuru MySQL / MariaDB umugozi wongeyeho ikibazo {AHO igice}.

Iyi ngingo yitabwaho kugirango yubake umurongo wuzuye wa QUERY kubisubizo byububiko. Irashobora kugabanya amakuru, igihe nizindi ndangagaciro mugabanya ibisubizo bibarwa. Amazina yumwimerere yumurima (ntabwo ari alias) agomba gukoreshwa muriki gice hamwe na SQL yemewe. Urugero.

1. gps_umuvuduko_km> 10 // umuvuduko urenze 10km / h

2. ain5> 3 // ain5 irarenze 3 (ifata ibice 2,5um ibara - urwego rwumwotsi)

3. gps_umuvuduko_km> 10 na ain6> 5 // umuvuduko urenze 10km / h naho ain6 irenze 5 (gufata ibice 10um ibara - urwego rwumwotsi)

8.2.9. Hitamo Byose Buto (Kuraho imirima yose kubibazo)

Nyuma yo gukanda iyi buto byibuze umurima umwe ugomba guhitamo intoki kugirango werekane ibisubizo byamateka.

8.2.10. Kora (Koresha Ikibazo Buto)

Kanda iyi buto birasabwa guhindura igenamiterere iryo ariryo ryose, ibipimo (usibye kwerekana imirima cyangwa ikibazo cyibibazo). Imbonerahamwe yongeye gusubirwamo kuva itangiriro hamwe nibishya.

8.2.11. "V" Agasanduku (Gufungura / Gufunga Ifishi yumurima)

Agasanduku gakoreshwa mukwerekana / guhisha abatoranya imirima kugirango berekane.

8.3. Utubari Ibitandukanye: (yerekana gusa amakuru aboneka)

8.4. Gukomeza variant (hamwe namakuru amwe):

Imbeba yerekana indangagaciro zerekana ibipimo nitariki / isaha.

9. Urubuga Mucukumbuzi

* - Firefox ntabwo ishyigikiye itariki / igihe cyo gutoranya (umurima winyandiko ugomba guhindurwa nintoki ukoresheje imiterere yigihe cyagenwe).

Internet Explorer idashyigikiwe (koresha Impande ahubwo)

Abandi bashakisha urubuga ntibageragejwe.

10. Insanganyamatsiko

Urupapuro rwurubuga rushingiye kuri dosiye rusange yicyitegererezo iri kuri "Inyandikorugero" ububiko "* .icyitegererezo".

Byongeye kandi, buri bwoko bwurupapuro burimo:

1. "* .umutwe" dosiye ibika umutwe wurupapuro (amahuza, CSS yatumijwe hanze, JavaScript Idosiye, nibindi. )

2. "* .ibirenge" dosiye zibika munsi yurupapuro (amahuza, nibindi. )

Insanganyamatsiko yo Kubona irashobora guhinduka ukurikije ibyifuzo byabakoresha mugukemura no guhindura dosiye ya CSS. Idosiye ya CSS iri "inyandikorugero / css" ububiko. Urubuga rutandukanye Urubuga Insanganyamatsiko zirashobora gukoreshwa mugukora neza urugero. icapiro, SmartPhones, PADs inyandikorugero.

Table ibitekerezo - bifite ikibanza cyatoranijwe cyo guhitamo dosiye ya CSS kugirango ihindure byuzuye insanganyamatsiko (ibitswe muri "inyandikorugero / css / tabs" ububiko).

Map ibitekerezo - insanganyamatsiko rusange yatoranijwe na "ikarita" andika agasanduku. Byongeye kandi, hari dosiye isanzwe ya CSS "inyandikorugero / css / ikarita.css" ikubiyemo imikorere yinyongera nko guhisha / gusiga ibisubizo ukurikije indangagaciro zayo. Ahasigaye iyi dosiye ya CSS igarukira kubibazo no kumiterere yumurima.

Byinshi muri byo @Umujyi Amadosiye ya PHP yo kubona amashusho yemere cssibipimo bifite agaciro ka dosiye yizina ryinsanganyamatsiko (nta kwagura). Idosiye igomba kuba iri mububiko bwa "templates / css" kandi izina ryoroshye.

Bimwe mubintu byinsanganyamatsiko byerekana biri muri JavaScript dosiye iri "icyitegererezo / js" ububiko.

Main @Umujyi Inyandiko"@ Umujyi.js" ni i Ububiko bwo hejuru. Nta guhinduka gushoboka muribi ahantu, icyakora inyandiko irashobora kwimurwa kuri "inyandikorugero / js" ububiko kandi bwahinduwe aho. Gukoresha inyandiko yihariye bisaba kuvugurura dosiye zose.

11. Kuvugurura Algorithms

Bimwe mu byuma byifashishwa bishobora gusaba imirimo yo kubara.

Ntabwo bishoboka kuvugurura no kubungabunga ibintu byinshi bya Porogaramu ya Seriveri, Imbere-Impera yimbere, byatera ibibazo byinshi, verisiyo, amakosa.

Inzira nziza kandi yoroshye yo kubigeraho, ni uguhindura JavaScript "kurenga" dosiye kugirango yerekane neza agaciro / ibisobanuro.

Inyandiko y'umwimerere ya JS ni fayili yinyandiko kandi irashobora gukoreshwa mubyo abakiriya bakeneye. Nkuko byavuzwe mu gice kibanziriza iki bagomba kwimurwa "inyandikorugero / js" ububiko aho abakiriya bafite uburenganzira bwo guhindura.

Ubuhanga bwa tekinike kuri gahunda ya @Umujyi Sisitemu ntabwo ari ingingo yiyi nyandiko, icyakora uwatezimbere Urubuga afite ubumenyi bwibanze bwa HTML na JS arashobora guhitamo Imbere-Impera yurubuga kubakiriya bakeneye.

12. Imiterere yububiko

@Umujyi Ububiko hamwe nizina "IoT" cyangwa "* IoT" igabanijwe mumeza (aho asterix ni prefix bitewe na seriveri yakira - niba bikenewe). DataBase irashobora kugaragara muri PHPAdmin (porogaramu y'urubuga) kumurongo http: //% IP% / phpmyadmin

Imbonerahamwe Gushiraho kuri buri Gikoresho (aho * {asterix} ni aderesi ya IMEI - ID idasanzwe):

• "* _t" - ibimenyetso kubakoresha ubu uburenganzira (ntibukoreshwa kubicu-Umukiriya umwe)

• "* _c" - amategeko (Ibyabaye) umurongo - koherezwa kubikoresho

• "*" - ibisubizo byose byimiterere.

Izindi mbonerahamwe:

• "ithings_" imbonerahamwe - ikubiyemo decode yimiterere yibikoresho byose (yandukuwe mugihe cyo kuvugurura icyaricyo cyose "*" imbonerahamwe). Imiterere ya ithings_ Imbonerahamwe ni Nka Kuri "*" ameza. "ithings_" gira imirima yinyongera kuri Aderesi ya posita nibisobanuro.

• Imbonerahamwe "abakoresha" irabujijwe kandi igomba guhinduka.

12.1. "ithings_" na "*" imiterere yimbonerahamwe

• "idx" - indangagaciro

• "tm" - igihe cyikora

• "dt" - unix timestamp

• "imei" - aderesi idasanzwe

• "rssi" - Urwego rwa RSSI

• "rsrp" - Ikimenyetso cya RSRP

• "ibyabaye" - gutegereza ibyabaye byoherezwa kubagenzuzi

• "out1" .. "out16" - ibisobanuro byerekana ibisubizo

• "in1" .. "in16" - inyandikomvugo yinjiza imiterere

• "ain1" .. "ain8" - indangagaciro za ADC (RAW)

• "sens1" .. "sens8" - guhindura sensor indangagaciro (biterwa nubwoko bwibikoresho)

• "dimm1" .. "dimm8" - decode ya dimmers indangagaciro (biterwa nubwoko bwibikoresho)

• "int1" .. "int6" - kubara decode indangagaciro (biterwa nubwoko bwibikoresho)

• "inyandiko1" .. "umwandiko6" - indangagaciro zanditse (biterwa nubwoko bwibikoresho)

• "ibyaremwe" - itariki yo gukora ibikoresho / isaha

• "uwanyuma" - itariki yanyuma / isaha

• "umukoresha" - gukoresha ejo hazaza

• "pass" - gukoresha ejo hazaza

• "sn" - gsm serial nr

• "imiterere" - imiterere yubugenzuzi bwubu ntabwo yanditswe muburyo bwa hex

• "hash_code" - gukoresha ejo hazaza

• "addr" - aderesi igikoresho gito

• "fwnr" - software nr

• "ubumuga" - igikoresho cyamugaye (kidakozwe)

• "gsm_nr" - Umubare wa CIoT gsm

• "umucuruzi" - kode y'abacuruzi (kuri franchise / gufatanya)

• "timezone" - Igihe cyagenwe

• "dst" - Koresha igenamigambi rya buri munsi

• "gps_lat" - Ubunini bwa GPS

• "gps_long" - Uburebure bwa GPS

• "gps_hdop" - GPS HDOP

• "gps_alt" - Uburebure bwa GPS

• "gps_fix" - Gukosora GPS (igomba kuba 3 - kubisubizo byemewe)

• "gps_cog" - GPS Cog

• "gps_umuvuduko_km" - Umuvuduko wa GPS muri [km / h]

• "gps_sat" - Satelite ya GPS yabonetse

• "umugabane", "igihugu", "akarere", "subregion", "sububregion", "umujyi", "akarere", "umuhanda", "umuhanda_nr", "ikintu_nr" - Aderesi yabakiriya nibisobanuro byumurima (!!!! Ntiboneka kuri "*" imbonerahamwe y'amateka)

• "log" - amakuru yinjira
  
  Amazina yimirima ni ngombwa mugukora ibibazo bya SQL kugirango yongere imikorere yubushakashatsi kuko izina ryumwimerere rigomba gukoreshwa muri SQL Itangazo.
  
  

12.2. Amabwiriza y'ibikoresho (Ibyabaye) umurongo "* _c" imbonerahamwe - imiterere

Iyi mbonerahamwe ni ibyabaye / amabwiriza umurongo kuri buri gikoresho kandi ifite imiterere ikurikira:

• "itegeko" - itegeko ryo kohereza cyangwa rimaze koherezwa mugenzuzi

• "byemejwe" - ibendera ryemeza niba ryarigeze koherezwa kandi ryemejwe

• "itariki" - unix ingengabihe y'ibyabaye

• "ivugururwa" - ibendera ryo kuvugurura ibinyabiziga (itariki ntarengwa / igihe)

12.3. Kubona ibisubizo bivuye mububiko - Hagati-Urwego (Gusoma Data)

Amakuru arashobora kugerwaho adafite Urubuga rwanyuma. @Umujyi urimo inyandiko hamwe nibikorwa byo murwego rwo hagati. Ibisubizo bisubizwa muburyo bwa JSON.

12.3.1. Shakisha statut yibikoresho byose

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

Ikibazo gisubira byose "_ibikorwa" imbonerahamwe (imiterere yubu yibikoresho byose) muburyo bwa JSON:

[{ "igihugu":"", "umujyi":"", "umugabane":"", "igihugu":"", "karere":"", "subregion":"", "sububregion":"", "umujyi":"", "karere":"", "ibarabara":"", "ibarabara_nr":"", "ikintu_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "ibyaremwe":"2019-02-09 18:12:38", "uwanyuma":"0000-00-00 00:00:00", "ibyabaye":"", "umukoresha":"", "pass":"", "imei":"351580051067110", "sn":"", "imiterere":"73000200000f360033026800240000002c002c002dffffffffffffffff5b63000001c1000001c2000000000000000009250a4f0a760a7a0a750a780a7e0000031d032205fc34029b025c025600460e", "hash_code":"", "addr":"", "fwnr":"", "bamugaye":"", "gsm_nr":"", "umucuruzi":"", "timezone":"", "dst":"", "rssi":"91", "rsrp":"99", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "gps_hdop":"", "gps_alt":"", "gps_fix":"4", "gps_cog":"", "gps_umuvuduko_km":"", "gps_sat":"", "ibyabaye":"", "out1":"0", "hanze2":"0", "hanze3":"0", "hanze4":"0", "hanze5":"0", "hanze6":"0", "hanze7":"0", "hanze8":"0", "hanze9":"0", "hanze10":"1", "hanze11":"0", "hanze12":"0", "hanze13":"0", "hanze14":"0", "hanze15":"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", "in15":"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", "inyandiko1":"", "inyandiko2":"", "inyandiko3":"", "inyandiko4":"", "inyandiko5":"", "umwandiko6":"" }]

12.3.2. Shakisha amakuru yamateka kubikoresho

Baza amakuru yamateka yigikoresho kimwe na IMEI nr:

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

Kuberako imbonerahamwe yose ishobora kuba irimo amamiriyoni yumurongo igomba kugarukira AHO ingingo kugirango itamanikwa seriveri.

Ibipimo byinyongera url ibipimo:

imikorere - imeijson

imei - IMEI y'ibikoresho

umurima - imirima igomba kugaragara mubisubizo (coma yatandukanijwe)

min - agaciro ntarengwa kumurima wambere uhereye kurutonde

max - agaciro ntarengwa kumurima wambere uhereye kurutonde

scyangwat - Umwanya Kuri Ubwoko

tm - umurima uhita wongerwaho ibisubizo.

where - aho ingingo yo kugabanya amakuru

Urugero:

Turashaka kubona ibisubizo bikurikira

kubikoresho hamwe imei=356345080018095

Erekana imirima: ain5, ain6, gps_lat, gps_ururimi

n'imbibi ain5 mu ntera ( 1, 10000 ) - igomba kuba ikibanza cya mbere kurutonde

na gps Kugira amakuru yemewe (gps_fix = 3)

n'itariki / isaha (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00

Umugozi wa URL wubatswe:

http: //%IP%/IoT/que.php? imikorere =imeijson& imei =356345080018095& umurima =ain5, ain6, gps_lat, gps_ururimi& min =1& max =1000& aho =gps_fix = 3 na tm> "2019-02-14 23:00:19" na tm <"2019-02-15 00:00:00"

Ibisubizo by'ibibazo:

[{ "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. Shakisha urutonde rwibikoresho - umurima umwe uhereye kumiterere iriho ubu ntarengwa

Iyi mikorere isubiza amakuru make kuva kumeza "_ibikorwa"

http: //%IP%/IoT/que.php? imikorere = fieldjson & umurima = ain5 & min = 13 & max = 5000

Ibipimo:

imikorere - fieldjson

umurima - umurima ugomba kugaragara mubisubizo - imei na tm Byahiswemo

min - agaciro ntarengwa kumurima

max - agaciro ntarengwa kumurima

Kuri hejuru ikibazo cyumugozi kiragaruka ibisubizo bya ain5, imei, tm imirima:

niba ain5 ni murwego (13,5000)

Ibisubizo by'ibibazo:

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