@City IoT Cloud Platform

iSys - Intelligent Systems IoT Zothetsera

Machitidwe

1. Chiyambi.

@City IoT Cloud Platform yadzipereka "mitambo yaying'ono" dongosolo la makasitomala payekha. Pulatifomu sigawana nawo ndipo kasitomala m'modzi yekha amakhala ndi seva yakuthupi kapena yeniyeni (VPS kapena ma seva odzipereka). Makasitomala angasankhe chimodzi mwazambiri zopezeka ku Europe kapena padziko lapansi.

1.1 Mitundu yazida zothandizira.

Pulatifomu ya @City is imaperekedwa kuti itsatire zinthu za iSys.PL

• - RF / LoRaWAN (Intaneti ya Zinthu)

• CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Cell Intaneti ya Zinthu)

• Wifi

• Efaneti

1.2. Mitundu yazogulitsa.

@City (eCity) Cloud IoT Platform ndi makina osiyanasiyana azipangizo za IP IoT (omwe amatchedwa pamodzi @City Zida kapena Zipangizo za CioT ):

• @City

• @KamemeTvKenya

• @Metering

• @KamemeTvKenya

• @KamemeTvKenya

• @Bin

1.3. Ndondomeko zoyankhulirana zothandizidwa

Pulatifomu ya @City supports imathandizira kutsatira njira zoyankhulirana:

• UDP - yopangira ma sensa / zida za CIoT (makamaka NBIoT) - kugwiritsa ntchito kwambiri data

• TCPIP - yopangira zida zokhala ndi kulumikizana kwamitundu iwiri - kugwirana chanza / kutsimikizira

• HTTP - imangotanthauza kupeza deta / kuwonera / kutumiza / "mtambo kukhala mtambo"

• HTTP Webhooks - yolumikizirana ndi LoRaWAN pakati pa LoRaWAN Network / Application Server ndi @City Cloud.

Kutumiza kwazinthu kuchokera kwa wolamulira kupita ku seva ya mtambo ndipo mosemphanitsa zimasungidwa mumitundu yapadera ya mabakiteriya pamlingo wotsikitsitsa kwambiri komanso chitetezo chowonjezeka. Wokondedwa aliyense amatenga kiyi yake yapadera yosungira chilolezo chazida, kuwona kutsimikizika kwa deta, ndi zina zambiri.

Kwa zida zomwe sizili eHouse / eCity titha kukupatsani ma algorithms amtundu uliwonse ( "C" kachidindo) kwa mnzake aliyense wa microprocessor kuteteza deta asanalankhulane.

Pachifukwa ichi deta imakhala yotetezeka kotheratu panthawi yolumikizirana pakati pa mawayilesi (intaneti, Air, ndi zina zambiri. ).

1.4. Tekinoloje Yoyankhulana Yothandizidwa

Pulatifomu ya @City supports imathandizira:

• GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - zida (kulumikizana kwa UDP / TCPIP)

• Zipangizo za LoRaWAN (HTTP Webhooks) - kudzera pa LoRaWAN gateway ndi LoRaWAN network / application server

• Opanga ma Ethernet (kulumikizana kwa UDP / TCP)

• Olamulira a WiFi (kulumikizana kwa UDP / TCP)

• Zamakono IP

• Pulogalamu yapadera ya IP siingathe kulumikizidwa mwachindunji ndi intaneti, kotero ndi yotetezeka kwambiri kuposa adilesi ya IP

Platform ya @City dedicated imaperekedwa kuzida / zida:

• Zogulitsa zachilengedwe za iSys:

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

  • IoT (LoRaWAN)

  • WiFi - zoperekedwa kwa @City Platform

  • Ethernet - zoperekedwa kwa @City Platform

• Zogulitsa za Co-Production (zopangidwa ndi ena mothandizidwa ndi layisensi ya iSys ndi mtundu wakunja)

• Zogulitsa zamalonda (zopangidwa ndi anthu ena pansi pa layisensi ya iSys yokhala ndi ma logo a iSys)

1.5. @City Cloud Server

Mapulogalamu a @City amagwira ntchito pa Linux yochokera ku VPS (Virtual Private Server) kapena Dedicated Server patsamba la intaneti, kutengera magwiridwe antchito a Seva (yotchedwa Server yotsatira):

• kupezeka kwachinsinsi / pagulu

• zida zonse zimawerengeredwa

• Kusintha kwa mafupipafupi azida

• mlingo wotsitsimula

Pali mitundu ingapo ya VPS malinga ndi:

• Mtengo

• malo opangira deta

• Mapulogalamu oyendetsa bwino (1-8)

• Pafupifupi RAM (1-32GB)

• Diski ya SSD (20GB-1TB)

Makasitomala ambiri odzipereka amapezeka kutengera:

• Mtengo

• malo opangira deta

• Mapulogalamu a processor (4 .. 32)

• RAM (16 .. 512GB)

• SSD / HDD (256GB .. Zamgululi

Pulatifomu ya @City is imaperekedwa kwa kasitomala m'modzi:

• maboma ndi oyang'anira (City, Community, Country)

• B2B (ya mwini wake)

Chifukwa sichitha kugawana Seva pakati pa makasitomala, imachepetsa mwayi wopezeka chitetezo ndi magwiridwe antchito. Chifukwa chaichi ndi kasitomala yekhayo amene ali ndiudindo wachitetezo chokhazikika, kukhazikika, kuchita bwino, kulowetsa deta, etc. Pakakhala kusakwanira kwa ntchito, kasitomala amatha kugula mapulani apamwamba (VPS kapena Dedicated Server), yogwira ntchito moyenera ndikuchita bwino.

Muzochitika zapadera "Cloud to cloud" kulumikizana kumatha kukhazikitsidwa pakudalirana kwa dziko lonse lapansi komanso kuphatikizira deta kumadera akulu m'malo mwamtambo wa makasitomala ambiri.

1.5.1. Seva ndi njira zolumikizirana

Kuyankhulana kwa @City Server kumakwaniritsidwa kutengera kugwiritsa ntchito kotsika kwa magwiridwe antchito.

Zinthu zazikulu zogwiritsa ntchito @City Server ndi:

• landirani molondola kuchokera kuzipangizo (kudzera pama protocol: UDP, TCP IP, HTTP)

• kuchepetsa kugwiritsa ntchito deta ndi mtengo wake pakati pazida ndi Cloud (pogwiritsa ntchito njira zoyankhulirana zotsika UDP, TCP IP)

• landirani mawonekedwe obisika azida (kudzera pazoyankhulana zilizonse)

• chilolezo ndi kutsimikizira deta kuchokera pazida pochotsa mawonekedwe awo

• kusanja mawonekedwe azida ndikusinthira m'matawuni a MariaDB / MySQL molunjika (mumafayilo osaphika)

  • tebulo lazomwe zilipo (lili ndi mawonekedwe atsopano pazida zilizonse)

  • tebulo lazambiri zakale (lili ndimikhalidwe yonse ya chida chimodzi)

• tumizani malamulo odikira (Zochitika) kuzida

• kutsimikizira kugwirana chanza, kutsimikizira ndi kutsimikizira

Mapulogalamu a @City Server ndi ofanana ndi aliyense wogwiritsa ntchito ndipo sangasinthidwe kwa makasitomala osiyanasiyana.

1.5.2 Kuphatikiza kwa HTTP LoRaWAN

Oyang'anira a LoRaWAN amaphatikizidwa ndi @City mtambo kudzera pa HTTP interface (ma webhooks) omwe amapezeka pa intaneti ya LoRaWAN / seva yothandizira.

Mitundu ingapo ya seva / netiweki yothandizira imathandizidwa:

TTN (nthawi yochepa "Pamwamba" ndi kuchuluka kwa malamulo omwe adatumizidwa kwa dalaivala ndipo samathandizira kukweza kwa firmware)

LoraWAN-Stack (Imafuna kuchititsa zinthu ndi intaneti).

LoraServer.Io (Imafuna kuchititsa zinthu ndi intaneti - imangotumiza zidziwitso ku seva ndipo sizigwirizana ndi kukweza kwa firmware)

The @City Cloud for owongolera a LoRaWAN agawika chimodzimodzi ndi maupangiri ena. Zinafotokozedwa m'mutu wapitawu.

1.5.3. Mawonekedwe akutsogolo

Mawonekedwe akutsogolo amadziwika ndi zolembedwa za PHP kuti mupeze zomwe mwasankha kuchokera ku @City Cloud Database. Imagwiritsa ntchito makina osakira kwambiri, kutengera mafunso apachiyambi a SQL kuti muchepetse zomwe mukufuna. Chiyankhulo chimapereka zotsatira zafunsidwe mu mtundu wa JSON kuti isinthidwe ndi kukonzedwa ndi application Front-end Web "application".

Mawonekedwe oyambira kutsogolo ndi ofanana ndi aliyense wosuta ndipo sangasinthidwe kwa makasitomala osiyanasiyana.

Chowonekera pamwamba chikhoza kupangidwa ndi antchito athu kapena mogwirizana kuti mutsimikizire makonda anu makasitomala.

1.5.3. Ufulu wopeza seva

Ufulu wofikira kwamakasitomala (ku Seva yakuthupi) ndi ochepa.

Kupeza mafayilo azithunzi za "ma templates" okha (mafayilo amtundu wakale - .txt, .js, .css, .html):

• kuwonjezera, kuchotsa, kusintha mafayilo angwiro a HTML (Front-End GUI / Interface Development)

• kuwonjezera, kuchotsa, kusintha mafayilo oyera (Front-End GUI / Interface Development and Algorithms)

• kuwonjezera, kuchotsa, kusintha mafayilo oyera a CSS (Kutsogolo-Kutha - Mawonekedwe / Mitu Yachikhalidwe)

• kuwonjezera, kuchotsa, kusintha mafayilo amalemba azithunzi (Front-End GUI)

• kuwonjezera, kuchotsa, kusintha ma tabu, njira zazifupi, maulalo azotsatira za data

Ufulu Wina Wofikira:

• Kufikira kwathunthu ku @City Cloud Database MySQL / MariaDB pomwe zimasungidwa zonse

• Kufikira Web Services kumatanthauzidwa (zikalata) kwa kasitomala.

• Makasitomala saloledwa kupereka ziphaso kwa anthu ena (kupeza zambiri pazotsatira kungakhudze magwiridwe antchito, kukhazikika ndi chitetezo cha dongosolo lonse)

• Pazifukwa zapadera ndikugwiritsiridwa ntchito kwa Seva Yodzipereka, akaunti ya anthu ikhoza kukhazikitsidwa kuti izisunga zomwe zachitika (osati zakale).

• Wogwiritsa ntchito akhoza kutsanzira zomwe adalemba pa seva yake ya MySQL ndikuchita zomwe angawunikire ndikusintha, kuti asakhudze magwiridwe antchito a @City Server

Ogwira ntchito a iSys - Intelligent Systems - amakhala ndi mwayi wopanda malire ku seva yonse kuphatikiza akaunti ya mizu komanso mwayi wathunthu wosamalira DB.

Nthawi zina iSys imatha kupatsanso ufulu wochulukirapo kwa kasitomala (zolemba za PHP, mafayilo) atayang'ana nambala yoyambira, kuyesa mayeso, ngati sizingakhudze chitetezo chonse, kukhazikika ndi magwiridwe antchito.

1.6. Zida Zanzeru

1.6.1. CIoT - Zipangizo za GSM

Zida zathu zili ndi microcontroller ndi module ya GSM / GPS / GNSS (2G..4G, NBIoT, CATM1) yolumikizirana. Microcontroller imakhala ndi bootloader yotsekedwa kuti ikonzeke bwino ya OTA firmware. Izi zimathandizira kupanga mitundu yambiri yamachitidwe kutengera chimodzimodzi "CIoT Smart chida".

1.6.3. BAS, BMS, IoT - Zipangizo za Ethernet ndi WiFi

Oyang'anira ma Ethernet ndi WiFi amalola kulumikizana ndi IP pa pulogalamuyi (popanda kulipiritsa kuti mutumizire deta kwa woyendetsa GSM). Zipangizozi zatulutsanso bootloader ndipo zida zimatha kusinthidwa kudzera pa mawonekedwe ake. Kwa WiFi ili ndi kukweza kwa firmware kwa OTA kuchokera pa seva yayikulu

1.6.2. IoT - Zipangizo za LoRaWAN

LoRaWAN imathandizira kutumizirana deta pamaulendo ataliatali (mpaka pafupifupi. 15km). Mtunduwu umadalira kuthamanga kwa kufalitsa deta, kuchuluka kwa deta, kuchuluka kwa mizinda m'derali komanso njira zadongosolo zamawayilesi.

Zida zathu zimaphatikizapo gawo loyendetsa ma microcontroller ndi LoRaWAN yolumikizirana. Microcontroller imakhala ndi bootloader yotsekedwa kuti isinthidwe pulogalamu ya OTA. Izi zimakuthandizani kuti mupange mitundu ingapo yamachitidwe potengera momwemo "IoT smart device". Zipangizazi zimagwira ntchito pagulu lotseguka la ISM popanda ndalama zowonjezera zolembetsa. Ndikofunikira kugwiritsa ntchito zipata za LoRaWAN kuphimba dera lonselo ndikupezeka pa intaneti. Pankhani ya zipata za LoRaWAN zomwe zilipo pakati pazida (zopangidwira seva ya TTN), ndizotheka kutumiza zidziwitso kudzera pa iwo. Kukweza kwa fimuweya kumafuna seva ya LoRaWAN ya netiweki / pulogalamu ndi njira zabwino zoyankhulirana.

1.7. Business to Business (B2B) zosankha

Pali njira zingapo zamabizinesi ndi mgwirizano:

• kuitanitsa / kutumiza katundu wokonzeka (zotchinga, zida) - zomaliza

• kuitanitsa / kutumiza katundu wa OEM (ma PCB, owongolera, ndi zina) - zopangira zapakatikati, zida zosinthira

• chilolezo - kupanga kutengera layisensi yathu pamisika yakomweko (timangopereka ma microcontroller omwe adapangidwa) pansi pa iSys - Intelligent Systems Brands

• Co-Production - (monga pamwambapa) koma pansi pa Makampani akunja

2. @City atform Kugwiritsa Ntchito Pulatifomu

Pulatifomu ya @City imagwirizira template yakutsogolo yakumapeto kwa kuwonera deta, kufunsa, kuchepetsa ndikusintha (Zambiri / mbiri yakale):

• yerekezerani data yomwe mwasankha pamapu (kutengera kusanja kwanu)

• imasonyeza deta yosankhidwa ndi zotsatira pa matebulo

• imasonyeza deta yosankhidwa m'mabati a bar

• imasonyeza deta yosankhidwa m'mabuku a mbiriyakale

• tumizani zidziwitso ku ntchito za ena ndikukonzanso zina

• magwiridwe ena azisinthidwa pazofunsira payokha.

Front-End ya Mtumiki imapezeka kudzera pa static IP kapena DNS redirection domain / subdomain / fayilo ngati ilipo.

Kuyika Kwachitsanzo & Pachiwonetsero (Zimathandizidwa kokha kwa makasitomala oyembekezera).

Chonde tiuzeni pamene mukufuna kuyesa - kuti athe kupeza anthu papulatifomu.

Itha kufunikira kuti IP yokhazikika ya kompyuta yakutali kuti izitha kulumikizana ndi nsanja ya @City.

3. Tsamba Lalikulu

Tsamba lalikulu limasiyidwa opanda kanthu mwadala pazifukwa zachitetezo: http: //% YanuIP% / IoT /

Itha kukhala yothandizidwa payokha ndikusinthidwa ndikukhala ndi maulalo azithandizo zonse za @City atform Malo ngati pakufunika

4. Main Fomu

Fomu Yaikulu imapangidwa kuti ipange zokonzekera zatsopano ndi ma tabuhttp: //%IP%/IoT/que.php

Iyi ndi fomu yoyamba yopanga zotsatira, mawonedwe ndi ma tabu pakusintha kulikonse

Mafotokozedwe (Kuchokera pamwamba ndi kumanzere kupita kumanja)

4.1. Chamutu

4.1.1. Ulalo Wanyumba - (amatsegula tebulo la zotsatira)

4.1.2. "X" cheke - amatsegula / kutseka Fomu Yofunsira

4.1.3. "V" checkbox - imatsegula / kutseka Fomu ya Minda

4.1.4. Zithunzi zojambula - Maulalo azotsatira zowoneka (zosinthika)

4.2. Mawonekedwe:

4.2.1. "X" checkbox - imatsegula / kutseka Fomu yonse ya Kufunsira

4.2.2. Kutumiza & Malangizo Sankhani Mutu Wowonera

Sinthani fayilo ya CSS ya Chiwonetsero cha CSS iyenera kukhalapo mu "zidindo / css /" chikwatu - chodziwikiratu.

Masamba Owonetseredwa a 4.2.3 cheke - chikuwonetsa / chimabisa Mndandanda Wosefera Mundawo

4.2.4. Tsamba: Tabu Dzina kuti muwonjezere kapena kuchotsa

4.2.5. Onjezani / Chotsani Mabatani - Onjezani kapena chotsani ma tabu omwe ali ndi dzina mu Tab munda

4.2.6. Sankhani Core Batani

Sankhani minda yayikulu yomwe ikuwoneka patebulo. Icho yasinthidwa basi.

4.2.7. Sankhani Zonse Batani

Sankhani magawo onse (ayenera kutsatidwa posankha ena mwa iwo)

4.2.7. Sankhani Zonse Batani

Sankhani magawo onse (ayenera kutsatidwa ndikusankhira ena mwa iwo)

4.2.8. Bisani Fyuluta - Bisani Fomu yonse

Izi ndizofanana ndi bokosi la (X) lonse

4.2.9. Pangani Button - Sinthani zosintha za magawo

4.2.10. "V" bokosi loyang'ana - zowonetsera / fyuluta yayikulu.

4.3. Masamba

Ma tabu omwe adapanga payokha omwe ali ndi mayina ndi zokonzekera (zosungidwa mu cfg / ma tabo.cfg fayilo).

Fayiloyi ili ndi dzina ndi URL (yosiyanitsidwa ndi tabu char).

4.4. Zamkatimu

Ikuwonetsa magawo onse ochepetsedwa ndi Fyuluta Yam'munda.

Minda patebulo:

4.4.1. Kuthamanga - mtundu wazotsatira

mapu- kupanga mapu pa mapu (gawo limodzi kapena angapo akhoza kusankhidwa)

mbiri - ma chart am'mbiri (gawo limodzi kapena zingapo zitha kusankhidwa)

tab - zowonetsera tebulo (kuphatikiza kulikonse kungasankhidwe)

bala - gawo limodzi lokha likuwonetsedwa pa tchati

Pogwiritsa ntchito mtengo wake umodzi imatsegula zotsatira zatsopano ndi magawo osankhidwa (pamzere wapano).

4.4.2. Koperani (+/- maulalo)

Kuwonjezera / kuchotsa Tab yomwe dzina limayikidwa Tab munda. Imagwiritsa ntchito magawo okhawo osankhidwa pamzere womwewo wa tebulo.

4.4.3. Ma Cell Cell Ma tebulo

Kusindikiza dzina lina lililonse kumayambira Kuwonetsera kwa Masamba osankhidwa pamzere wosankhidwa.

4.5. Dongosolo la Deta

Dongosolo lamasamba omwe akuwonetsedwa ndi momwe limayendetsera mawonekedwe ake (komabe tm field imatumizidwa nthawi zonse kumapeto kwa mawu). Dongosolo ili lingasinthidwe ndikusinthidwa kwachindunji kwa magawo a URL (magawo oyitanitsa magawo).

4.6. Mwachitsanzo

Mwachitsanzo: Kukhazikitsa Tab ndi Kutsata Mtengo dzina ndipo lili ndi map ndi nthawi komanso liwiro pamapu

Malongosoledwe onse onena za mzere komwe "Map" malemba ali mu "Thamangani" gawo.

1. Lowetsani dzina "Kutsata Mtengo" mkati Tab munda (wopanda zilembo)

2. Onetsetsani kuti zipilala zonse sizimasankhidwa pamzerewu

3. sankhani tm, alireza mzere wokha

4. atolankhani + batani komwe mzerewu

5. Mamapu

Mamapu atha kuyambitsidwa kuchokera ku MainForm ndikukonzekereratu

5.1. Kuyambitsa Mapu

Kuyambitsa mapu kumachitika pamanja mukamayikidwa mwachindunji ndi ulalo: > http: //%IP%/IoT/maps.php

1. 
   Wogwiritsa akuyenera kusankha magawo onse (Press Sankhani Batani)

2. Dinani bokosi lina lazowunikira (monga. 5 (pamlingo wa Smog) ndi tm (tsiku loyesa / nthawi)

3. atolankhani "V" cheke kuti mubise mawonekedwe aminda

4. atolankhani Pangani batani loyendetsa funso la DB ndikuwonetsa zambiri zaposachedwa kuchokera kuma sensa / zida zonse

5. Mapu okhala ndi deta amasinthidwa pambuyo pa masekondi 30 kapena kupitilira apo.

5.2. Zikhonda zafunsani

Makonda omwe afotokozedwa kuchokera kumanzere kupita kumanja (pazithunzi pamwambapa).

5.2.1. Sinthani kukula kwa MAP (Makulitsidwe)

1. Mulingo wosintha ukhoza kusinthidwa pogwiritsa ntchito mabatani (+/-) a scale (current_scale * 2 kapena current_scale / 2 motsatira). Kukanikiza chimodzi mwa mabataniwa kumangosintha kukula kwake.

2. Njira ina ndikusankha Makulitsidwe mkati Onerani patali Bokosi la Combo Box ndikudina Pangani batani. Poterepa Mawonekedwe / Mapu onse amatsitsidwanso ndikutsitsimutsidwa (zimatenga kanthawi poyambitsa).

5.2.2. IMEI (Sankhani Chipangizo Cha Chipangizo)

IMEIMunda uli ndi ID yapadera kapena zida zapadera za chipangizocho. Kukhazikitsa kosasintha ndi * (asterisk) yomwe imawonetsa zinthu zaposachedwa kwambiri komanso mawonekedwe am'malo pachida chilichonse.

Kukhazikitsa IMEI ku mtengo wina uliwonse, kukuwonetsani zidziwitso zam'mbuyomu zazida zomwe mwasankha. Ndizomveka kokha pama sensa oyenda komanso osunthira, apo ayi zotsatira zitha kupezeka pamapu pamalo omwewo.

5.2.3. Lon, Lat (Longitude, Latitude amayang'anira minda)

Ikani malo apakati pamapu. Danga ili kuti likhale cholozera pomwe batani la mbewa lasindikizidwa pamapu.

5.2.4. Sinthani Mtundu wa MAP (Mutu)

Mtundu wamapu / mutu ungasankhidwe kuchokera Map Munda wa ComboBox (mwachitsanzo. Mdima, Wofiirira, Mawonekedwe).

Mitu yosiyanasiyana yamapu imatha kukhala ndi makulidwe osiyanasiyana osiyanasiyana kotero kuti itha kukakamiza Mutu woyenera kuwonjezera mapikidwe.

5.2.5. KUMENE Clause

Komwe Gawo limagwiritsidwa ntchito pazowonjezera zina zafunso {KUMENE gawo} la MySQL / MariaDB.

Chigamulochi chimaganiziridwa pakupanga chingwe chathunthu cha QUERY pazotsatira zamtundu wachinsinsi. Itha kuchepetsa deta, nthawi ndi zina zilizonse pochepetsa kuchuluka kwa zotsatira. Mayina am'magawo oyambira (osati maina) ayenera kugwiritsidwa ntchito pamundawu. Mwachitsanzo.

1. gps_speed_km> 10 // liwiro ndiloposa 10km / h

2. ain5> 3 // ain5 ndi wamkulu kuposa 3 (wokhala ndi 2.5um particles count - smog level)

3. gps_speed_km> 10 ndi ain6> 5 // liwiro ndiloposa 10km / h ndipo ain6 ndi wamkulu kuposa 5 (akugwira 10um particles count - smog level)

5.2.6. Pangani (Yambani Bulu Lofufuzira)

Kusindikiza batani ili kumafunika kuti musinthe mawonekedwe aliwonse, magawo (kupatula kukanikiza +/- mabatani).

Mapu amanyamula kuyambira pachiyambi ndi zosintha zatsopano.

Mapu samakwezedwa konse, pomwe palibe deta yomwe ikupezeka pamafunso apano.

5.2.7. Sankhani Zonse (Chotsani magawo onse pazofunsa)

Mukakanikiza batani ili osachepera gawo limodzi liyenera kusankhidwa pamanja kuti muwonetse zotsatira pamapu.

5.2.8. "V" Bokosi loyang'ana (Open / Close Field Fomu)

Bokosili limagwiritsidwa ntchito kuwonetsa / kubisa malo osankhira omwe angawoneke.

5.2.9. "X" Bokosi Loyang'ana (Onetsani / Bisani Fomu Yofunsa)

Bokosili limathandiza kubisa Fomu yonse kupatula ( +/- mabatani)

Zotsatira pamapu zimatsitsimutsidwa mosalekeza ndikusinthidwa ndimikhalidwe yatsopano

5.3. Mwachitsanzo

Mwachitsanzo zotsatira za Smog (Sensor yoyikidwa m'galimoto): Smog level 2.5um particles (Ain5), Speed ​​(gps_speed_km), Date / Time (tm), map (2 - topographic), zoom level 16,

Kumene kuli gawo:

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

// GPS = zotsatira zenizeni za 3D & date = 2019-02-18 & liwiro> 0 km / h

6. Onetsani Zotsatira mu Gome

Onetsani zotsatira patebulopo.

Yatsani "Main Fomu" atolankhani "tebulo" item, mutasankha magawo ena kuti muwonetse tebulo lokonzekera kale

6.1. Kukhazikitsa tebulo

Patebulo litseguka kuchokera kulumikizana http: //%IP%/IoT/que.php? func = tabu imafuna kuyambitsanso koyambirira kwamakonzedwe.

Mutha kusankha magawo owoneka (mwa kukanikiza "Minda Yowoneka" bokosi lofufuzira.

1. Dinani mabokosi onse ofunikira aminda yowonetsedwa

2. Press bokosi "Minda Yowoneka" kubisa mawonekedwe aminda

3. Dinani batani la Execute kuti muyankhe funso la DB ndikuwonetsa tebulo

6.2. Zikhonda zafunsani

Makonda amafotokozedwa kuchokera kumanzere kupita kumanja (pa skrini).

6.2.1. Sanjani - Sanjani gawo ndi kuyitanitsa kukwera / kutsika

Sanjani gawo ndilofanana ndi kukanikiza mutu wamutu.

6.2.2. DB / IMEI - Sankhani Chipangizo

IMEIMunda uli ndi ID yapadera kapena zida zapadera za chipangizocho. Ndi zopanda pake zikuwonetsa tebulo lazomwe zaposachedwa kwambiri.

Kukhazikitsa IMEI ku mtengo wina uliwonse, kukuwonetsani zidziwitso zam'mbuyomu zazida zomwe mwasankha.

6.2.3. Kutumiza & Malangizo sankhani mawonekedwe (Mutu wowonera)

6.2.4. Minda Yowoneka - Onetsani / Bisani Minda Fomu

6.2.5. Chotsani Chopanda - Musawonetse mizati yopanda kanthu

6.2.6. "X" Bokosi Loyang'ana (Onetsani / Bisani Fomu Yofunsa)

6.2.7. Kuti Ndime (yochepetsera deta)

Izi ndizokwanira pa zingwe zina za MySQL / MariaDB {WHERE part}

Gawo ili limawerengedwa kuti lipange chingwe chathunthu cha QUERY pazotsatira zamtundu wachinsinsi. Itha kuchepetsa deta, nthawi ndi zina zilizonse pochepetsa kuchuluka kwa zotsatira. Mayina am'magawo oyambira (osati maina) ayenera kugwiritsidwa ntchito pamundawu. Mwachitsanzo.

1. gps_speed_km> 10 // liwiro ndiloposa 10km / h

2. ain5> 3 // ain5 ndi wamkulu kuposa 3 (wokhala ndi 2.5um particles count - smog level)

3. gps_speed_km> 10 ndi ain6> 5 // liwiro ndiloposa 10km / h ndipo ain6 ndi wamkulu kuposa 5 (akugwira 10um particles count - smog level)

6.2.8. Sankhani Core Batani (Yambitsani magawo ambiri)

6.2.9. Sankhani Zonse Batani (Chotsani magawo onse pazofunsa)

Mukakanikiza batani ili osachepera gawo limodzi liyenera kusankhidwa pamanja kuti muwonetse zotsatira pamapu.

6.2.10. Pangani (Yambani Bulu Lofufuzira)

Kusindikiza batani ili kumafunika kuti musinthe mawonekedwe aliwonse, magawo (kupatula kukanikiza +/- mabatani).

Tebulo limabwezeretsedwanso kuyambira pachiyambi ndi kukonzekera kwatsopano.

6.2.11. "V" Bokosi loyang'ana (Open / Close Field Fomu)

Bokosili limagwiritsidwa ntchito kuwonetsa / kubisa malo osankhira omwe angawoneke.

Zotsatira patebulopo zimasankhidwa malinga ndi Sanjani kolowera kumunda. Kusanja momwe mungasinthire kungasinthidwe mwa kukanikiza mutu wa mzere (kamodzi kumayendedwe amodzi kawiri mbali ina).

Zotsatira zina zimalumikizidwa ndi mizati kuti ipititse patsogolo zowonera (zolembedwera molimbika).

Mukamawonetsa mbiri yakale yazida ziyenera kuchepetsedwa kuti zisawonetse mbiri yonse chifukwa zitha kubweretsa magwiridwe antchito kapena zovuta zokumbukira.

7. Ma chart a Bar.

Ma chart a bar ayenera kuchitidwa kuchokera ku Main Fomu pakukakamiza gawo limodzi mu "Bar" mzere.

Imawonetsa mipiringidzo yosankhidwa kuti ikwaniritse bwino kwambiri, kuwonetsa kuyambira pamwamba mpaka kutsika kwambiri.

Ndiwothandiza kuwunika mwachangu zotsatira zoopsa ndikuchitapo kanthu.

Zochitika Pakuwonetsa ziwonetsanso zowonjezera za chipangizocho.

8. Zolemba Zakale.

Ma chart am'mbiri amatha kuyambitsidwa kuchokera ku MainForm mukakanikiza mzere wosankhidwa mu "Mbiri" mzere (pamunda umodzi).

M'minda ingapo mu "Mbiri" mzere wofunidwa uyenera kuyang'aniridwa ndipo ulalo wa "Mbiri" uyenera kukanikizidwa mu "Run".

Zotsatira zam'mbuyomu zimangokhala kumapeto kwa maola 24 + maola 24 otsatira (pamapeto pake otsitsimutsa), pomwe panalibe malire.

8.1. Kukhazikitsa ma chart a Mbiri

Ma chart am'mbuyomu akamatsegulidwa kuchokera ku ulalo waukulu amafunika kuyambitsidwa monga zotsatira zina, akatseguka kulumikizana popanda magawo omwe amakonda.

Minda ingasankhidwe kuti iwonetse zinthu zosiyanasiyana. Ikhozanso kukhazikitsidwa mu Fomu ya Fyuluta Yam'munda.

1. Dinani mabokosi onse ofunikira aminda yowonetsedwa

2. Press bokosi "Minda Yowoneka" kubisa mawonekedwe aminda

3. Dinani batani la Execute kuti muyankhe funso la DB ndikuwonetsa tebulo

8.2. Makhalidwe Abwino a Ma Mbiri Akale

Zinthu zofotokozedwa kuchokera pamwamba komanso kuchokera kumanzere kupita kumanja (pa skrini).

8.2.1. IMEI - (Sankhani Chipangizo kuti muwonetse mbiri yakale)

IMEIMunda uli ndi ID yapadera kapena zida zapadera za chipangizocho. Ndi * (asterix) mtengo umawonetsa mndandanda wazikhalidwe zaposachedwa kwambiri zomwe sizimveka.

Kukhazikitsa IMEI ku mtengo wina uliwonse, kukuwonetsani zidziwitso zam'mbuyomu zazida zomwe mwasankha.

8.2.2. Zochepa - chepetsani mtengo wochepa wamunda woyamba

8.2.3. Max - dulani malire akutali kwa gawo loyamba

8.2.4. "V" - Onetsani / Bisani Minda Fomu

8.2.5. Kuchokera: ikani tsiku / nthawi yocheperako (*)

8.2.6. Kuti: ikani tsiku / nthawi yayikulu (*)

8.2.7. "X" Bokosi Loyang'ana (Onetsani / Bisani Fomu Yofunsa)

8.2.8. "Kuti" Ndime

Ndime yochepetsera zotsatira zamtundu wa MySQL / MariaDB zowonjezera zamafunso {KUMENE gawo}.

Chigamulochi chimaganiziridwa pakupanga chingwe chathunthu cha QUERY pazotsatira zamtundu wachinsinsi. Itha kuchepetsa deta, nthawi ndi zina zilizonse pochepetsa kuchuluka kwa zotsatira. Mayina am'magawo oyambira (osati maina) ayenera kugwiritsidwa ntchito pamundawu ndi mawu omveka bwino a SQL. Mwachitsanzo.

1. gps_speed_km> 10 // liwiro ndiloposa 10km / h

2. ain5> 3 // ain5 ndi wamkulu kuposa 3 (wokhala ndi 2.5um particles count - smog level)

3. gps_speed_km> 10 ndi ain6> 5 // liwiro ndiloposa 10km / h ndipo ain6 ndi wamkulu kuposa 5 (akugwira 10um particles count - smog level)

8.2.9. Sankhani Zonse Batani (Chotsani magawo onse pazofunsa)

Mukakanikiza batani ili gawo limodzi liyenera kusankhidwa pamanja kuti muwonetse zotsatira za mbiriyakale.

8.2.10. Pangani (Yambani Bulu Lofufuzira)

Kusindikiza batani ili kumafunika kuti musinthe makonda, magawo (kupatula kuwonetsa magawo kapena gulu lamafunso). Tebulo limabwezeretsedwanso kuyambira pachiyambi ndi kukonzekera kwatsopano.

8.2.11. "V" Bokosi loyang'ana (Open / Close Field Fomu)

Bokosili limagwiritsidwa ntchito kuwonetsa / kubisa malo osankhira omwe angawoneke.

8.3. Mabala Zosiyana: (amawonetsa zopezeka zokha)

8.4. Wopitilira zosiyana (ndi zomwezo):

Cholozera mbewa chiwonetsero cha miyezo ndi tsiku / nthawi.

9. Kugwirizana kwa msakatuli

* - Firefox siyigwirizira chosankhira tsiku / nthawi (gawo lamalemba liyenera kusinthidwa pamanja pogwiritsa ntchito nthawi yoyenera yamasiku).

Internet Explorer sichithandizidwa (gwiritsani ntchito Mphepete m'malo)

Masakatuli ena sanayesedwe.

10. Kusintha kwa Mitu

Masamba atsamba amatengera fayilo ya template yomwe ili ku "ma tempulo" chikwatu "* .template".

Kuphatikiza apo tsamba lililonse lili ndi:

1. "* .head" fayilo yomwe imasunga mutu wa tsambalo (maulalo, kunja kwa CSS, JavaScript Mafayilo, ndi zina zambiri. )

2. "* .foot" mafayilo omwe amasungira tsambalo (maulalo, ndi zina zambiri. )

Chiwonetsero cha Visualization chingasinthidwe malinga ndi zomwe ogwiritsa ntchito akusintha pothana ndi kusintha mafayilo a CSS. Maofesi a CSS amapezeka mu "ma templates / css" zolemba. Mitu Yosiyanasiyana ya Tsamba Lawebusayiti itha kugwiritsidwa ntchito popanga zokometsera mwachitsanzo. kusindikiza, SmartPhones, ma templates a PAD.

Table malingaliro - ali ndi gawo losankhidwa pakusankha fayilo ya CSS kuti mutu wonse usinthidwe (wosungidwa mu "ma templates / css / ma tabo" chikwatu).

Map malingaliro - mutu waukulu umasankhidwa ndi "mapu" lembani combo box. Kuphatikiza apo pali fayilo yosasintha ya CSS "ma templates / css / map.css" yomwe ili ndi magwiridwe ena owonjezera monga kubisala / zotsatira za utoto kutengera malingaliro ake. Zina zonse za fayilo ya CSS sizingowonjezera pamafunso ndi mawonekedwe am'munda.

Ambiri mwa @City Platform Mafayilo a PHP owonera amavomereza csschizindikiro chokhala ndi dzina la fayilo pamutuwo (popanda kuwonjezera). Fayilo iyenera kupezeka pamndandanda wa "ma templates / css" ndipo dzinalo limayang'anitsitsa.

Zinthu zina zowonetsera Mutu zili mwachindunji mu fayilo ya located yomwe ili mu "template / js" zolemba.

Main @City zolemba@Alirezatalischioriginal ili kumtunda wapamwamba. Palibe kusintha kosintha mu izi location, komabe script ikhoza kukopera "ma templates / js" directory ndikusinthidwa pamenepo. Kugwiritsa ntchito script payekha kumafunikira mafayilo amutu onse.

11. Ma algorithms Kusintha

Masensa ena apadera angafunike kuwerengera modzipereka.

Palibe kuthekera kosintha ndikusunga mitundu ingapo ya @City Server Mapulogalamu, Kutsogolo kwa PHP mawonekedwe, zomwe zingayambitse mavuto ambiri, mitundu, zolakwika.

Njira yabwino kwambiri komanso yosavuta kuti mukwaniritsire, ndikusintha mafayilo a "wokutira" kuti muwone bwino mtengo / malongosoledwe.

Zolemba zoyambirira za JS ndi mafayilo otseguka ndipo atha kutengera zosowa zamakasitomala. Monga tanenera m'mutu wapitawu ayenera kutengera "ma templates / js" chikwatu pomwe kasitomala ali ndi ufulu wopeza zosintha.

Zojambula pamapangidwe a @City dongosolo silili mutu wa chikalatachi, komabe wopanga mawebusayiti yemwe ali ndi chidziwitso chambiri cha HTML ndi JS atha kusintha makonda a Front-end Web posowa kwa kasitomala aliyense.

12. Kapangidwe ka Database

@City Database yokhala ndi dzina "IoT" kapena "IoT" imagawidwa m'matebulo (pomwe asterix ndi manambala oyamba kutengera seva yolandirira - ngati pakufunika kutero). DataBase imatha kuwonedwa mu PHPAdmin (intaneti) http: //% IP% / phpmyadmin

Matebulo Amayikidwa pa Chipangizo chilichonse (kuti * {asterix} ndi adilesi ya IMEI - ID yapadera):

• "_ _t" - ma tokeni a chilolezo cha ogwiritsa ntchito pano (osagwiritsidwa ntchito pamitambo ya Makasitomala Amodzi)

• "* _c" - Malamulo (Zochitika) pamzere - kuti uzitumizidwa ku chipangizocho

• "* - zotsatira zonse zosankhidwa.

Magome ena:

• "anayankha tebulo - ili ndi mawonekedwe amtundu uliwonse azida zonse (imakopedwa pomwe ikusinthidwa iliyonse ya "* matebulo). Kapangidwe ka mulaudzi tebulo ndi pafupifupi lofanana ndi "* matebulo. "anayankha khalani ndi magawo ena a Adilesi Yapositi ndi mafotokozedwe.

• "ogwiritsa" tebulo ndi loletsedwa ndipo liyenera kusinthidwa.

12.1. "ithings_" ndi "*" kapangidwe ka matebulo

• "idx" - cholozera

• "tm" - sitampu yokhazikika

• "dt" - sitepe yampikisano

• "imei" - adilesi yapaderadera

• "rssi" - Mulingo wa ma RSSI

• "rsrp" - Chizindikiro cha RSRP

• "zochitika" - zochitika zodikirira kuti zizitumizidwa kwa owongolera

• "kutuluka1" .. "kutuluka16" - zotulutsa zomwe zasankhidwa

• "mu1" .. "mu16" - mawonekedwe olowetsedwa

• "ain1" .. "ain8" - zilembo za ADC zosinthidwa (RAW)

• "sens1" .. "sens8" - mawonekedwe amtundu wotembenuka (zimadalira mtundu wachida)

• "dimm1" .. "dimm8" - ma decimed dimmers values ​​(zimadalira mtundu wachida)

• "int1" .. "int6" - zowerengera zamtengo wapatali (zimadalira mtundu wachida)

• "mawu1" .. "mawu6" - zilembo zamtundu wosankhidwa (zimatengera mtundu wazida)

• "chilengedwe" - tsiku lopanga zida / nthawi

• "omaliza" - tsiku lomaliza / nthawi

• "wosuta" - kugwiritsa ntchito mtsogolo

• "pass" - kugwiritsa ntchito mtsogolo

• "sn" - gsm siriyo nr

• "udindo" - mawonekedwe oyang'anira pakadali pano sanasimbidwe mu hex

• "hash_code" - kugwiritsa ntchito mtsogolo

• "addr" - adilesi yayifupi yachida

• "fwnr" - fimuweya nr

• "olumala" - chida cholemala (sichidachitidwe)

• "gsm_nr" - nambala ya CIoT gsm

• "vendor" - nambala ya ogulitsa (yopanga chilolezo / kupanga nawo)

• "nthawi ya nthawi" - Time zone yakhazikitsidwa

• "dst" - Gwiritsani ntchito makonda osungidwa tsiku ndi tsiku

• "gps_lat" - GPS Latitude

• "gps_long" - GPS Kutali

• "gps_hdop" - GPS HDOP

• "gps_alt" - Kutalika kwa GPS

• "gps_fix" - Kukonzekera kwa GPS (kuyenera kukhala 3 - pazotsatira zomveka)

• "gps_cog" - GPS Cog

• "gps_momwemo" - Kuthamanga kwa GPS mu [km / h]

• "gps_sat" - Ma satellite a GPS apezeka

• "kontinentiyo", "dziko", "dera", "subregion", "subsubregion", "city", "district", "street", "street_nr", "item_nr" - Adilesi yamakasitomala ndi magawo ofotokozera (!!!! Sikupezeka kwa "*" matebulo akale)

• "log" - zolemba zamakalata
  
  Mayina am'minda ndiofunikira pakupanga mafunso a SQL owonjezera magwiridwe antchito chifukwa dzina loyambirira liyenera kugwiritsidwa ntchito mu SQL Statement.
  
  

12.2. Mzere wazida zamalamulo (Zochitika) pamzere wa "* _c" - dongosolo

Gome ili ndi mzere / zochitika pamzere pachida chilichonse ndipo zili ndi mawonekedwe awa:

• "command" - lamulirani kutumiza kapena kutumizidwa kale kwa wowongolera

• "anatsimikizira" - mbendera yotsimikizira ngati idatumizidwa kale ndikutsimikiziridwa

• "tsiku" - sitepe yampikisano yosonyeza zochitika

• "kusinthidwa" - mbendera yosinthira yokha (deti / nthawi ya sitampu)

12.3. Kupeza zotsatira kuchokera kumasamba - Pakati Pakati (Kuwerenga Zambiri)

Zambiri zitha kupezeka popanda kugwiritsa ntchito Webusayiti. @City dongosolo lili ndi zolemba zokhala ndi ntchito zapakatikati. Zotsatira zimabwezedwa mu mtundu wa JSON.

12.3.1. Pezani momwe zinthu ziliri pakadali pano

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

Kufufuza kumabwerera kwathunthu "_thawi" tebulo (mawonekedwe apano azida zonse) mu Mtundu wa JSON:

[{ "dziko":"", "mzinda":"", "kontrakitala":"", "dziko":"", "dera":"", "chigawo":"", "kugonjera":"", "mzinda":"", "chigawo":"", "msewu":"", "msewu_nr":"", "chinthu_nr":"", "gps_lat":"Kufufuza", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "chilengedwe":"2019-02-09 18:12:38", "omaliza":"0000-00-00 00:00:00", "zochitika":"", "wosuta":"", "kudutsa":"", "imei":"351580051067110", "sn":"", "udindo":"73000200000f360033026800240000002c002c002dfffffffffffffffbb000010001c1000001c200000000000000000000005050a4f0a760a7a0a750a780a700000031d032205fc34029b025c025600460eb30", "hash_code":"", "addr":"", "fwnr":"", "olumala":"", "gsm_nr":"", "wogulitsa":"", "nthawi":"", "dst":"", "rssi":"91", "rsrp":"99", "gps_lat":"Kufufuza", "gps_long":"00000.0000E", "gps_hdop":"", "gps_alt":"", "gps_fix":"4", "gps_cog":"", "gps_momwemo":"", "gps_sat":"", "zochitika":"", "kutuluka1":"0", "kunja2":"0", "kunja3":"0", "kunja4":"0", "kunja":"0", "kunja6":"0", "kunja7":"0", "kunja8":"0", "kunja9":"0", "kunja10":"1", "11":"0", "kunja12":"0", "kunja13":"0", "kunja14":"0", "kunja15":"0", "kutuluka16":"0", "mu1":"0", "in2":"0", "in3":"0", "in4":"0", "mkati":"0", "in6":"0", "mu .7":"0", "in8":"0", "mu9":"0", "mu10":"0", "in11":"0", "in12":"0", "mu13":"0", "mu14":"0", "mu15":"0", "mu16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "amkati":"0", "ain6":"44", "ain7":"44", "ain8":"45", "sens1":"0", "zomverera":"0", "Masewerera":"0", "mphamvu4":"0", "chidwi5":"0", "mphamvu6":"0", "zomverera":"0", "sens8":"0", "dimm1":"255", "dimm2":"255", "dimm3":"255", "kuchepa4":"255", "dimm5":"255", "dimm6":"255", "kusokoneza7":"255", "dimm8":"255", "int1":"-16776767", "int2":"450", "int3":"", "int4":"", "int5":"", "int6":"0", "mawu1":"", "malemba2":"", "malemba3":"", "malemba4":"", "mawu5":"", "mawu6":"" }]

12.3.2. Pezani Mbiri Yakale pa Chipangizocho

Kufunsa zambiri zam'mbuyomu za IMEI nr:

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

Chifukwa tebulo lonse limatha kukhala ndi mizere mamiliyoni iyenera kuchepetsedwa ndi WHERE clause kuti isamapachike seva.

Zowonjezera magawo a url:

chisangalalo - imeijson

imei - IMEI yachida

munda - minda yomwe iyenera kuwonetsedwa muzotsatira (mndandanda wosiyana wa coma)

min - osachepera pamunda woyamba pamndandanda

Max - mtengo wokwanira pamunda woyamba pamndandanda

skapenat - gawo lamtundu

tm - gawo limangowonjezeredwa kuzotsatira.

where - komwe gawo lochepetsa deta

Chitsanzo:

Tikufuna zotsatira zotsatirazi

kwa chipangizo ndi imei=356345080018095

onetsani minda: ain5, ain6, gps_lat, gps_long

ndi malire amkati mulingo ( 1, 10000 ) - iyenera kukhala gawo loyamba pamndandanda

ndipo GPS khalani ndi chidziwitso chovomerezeka (gps_fix = 3)

ndi tsiku / nthawi (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00

Chingwe cha URL chopangidwa:

http: //%IP%/IoT/que.php? func =alireza& imei =356345080018095& gawo =amkati, ain6, gps_lat, gps_long& mphindi =1& max =1000& kumene =gps_fix = 3 ndi tm> "2019-02-14 23:00:19" ndi tm <"2019-02-15 00:00:00"

Zotsatira Zakufunsa:

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

12.3.3. Pezani mndandanda wazida - gawo limodzi kuchokera pazomwe zilipo pakali pano

Ntchitoyi imabwezeretsa zochepa kuchokera pagome la "_ithings"

HOME '' ZOSANGALATSA ''

Magawo:

chisangalalo - mundajson

munda - Munda kuti uwonetsedwe muzotsatira - imei ndipo tm ali basi anawonjezera

min - mtengo osachepera pamunda

Max - mtengo wapatali pamunda

Kwa chingwe chapamwamba pamafunso chimabwerera zotsatira za ain5, imei, tm minda:

ngati amkati ilipo (13,5000)

Zotsatira Zakufunsa:

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

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

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