@City IoT huab Platform

iSys - Cov Tshuab Txawj Ntse IoT Daws

IoE.Systems

1. Taw qhia.

@City IoT Huab Platform yog nplooj siab "micro-huab" system rau cov neeg siv khoom ntiag tug. Lub Platform tsis tuaj yeem sib faib tau thiab tsuas yog ib tus neeg siv tau nkag mus rau lub cev lossis lub vev xaib virtual (VPS lossis cov servers nplooj siab). Cov neeg siv khoom yuav xaiv ib ntawm kaum plaub cov ntaub ntawv-chaw nyob hauv Europe lossis hauv ntiaj teb.

1.1 Cov khoom siv txhawb nqa.

@City IoT platform muaj nplooj siab xav ua raws li khoom iSys.PL

• IoT - RF / LoRaWAN (Is Taws Nem ntawm Tej Yam)

• CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Cell Xov tooj ntawm yam)

• WiFi

• Ethernet

1.2 .2. Txhawb hom khoom.

@City (eCity) Huab IoT Platform muaj ntau qhov system me rau IP IoT khoom (hu ua ke li @City kho vajtse lossis CioT Li ):

• @City

• @Light

• @Metering

• @Trace

• @AirQ

• @Bin

1.3. Txhawb kev sib txuas lus raws tu qauv

@City IoT platform txhawb nqa cov txheej txheem nram qab no rau kev sib txuas lus:

• UDP - tawm tswv yim rau CIoT sensors / khoom siv (tshwj xeeb NBIoT) - cov ntaub ntawv siv qis tshaj

• TCPIP - tawm tswv yim rau cov khoom siv nrog sib txuas lus nrog kev sib txuas lus - sib tuav tes / lees paub

• HTTP - pom tias tsuas yog rau cov ntaub ntawv nkag mus / pom / xa tawm / "huab rau huab"

• HTTP Webhooks - rau LoRaWAN kev sib txuas lus ntawm LoRaWAN Network / Application Server thiab @City Cloud.

Cov ntaub ntawv xa los ntawm cov maub los rau huab server thiab vice-versa yog encrypted hauv cov cim binary rau cov ntaub ntawv qis tshaj plaws thiab muaj kev ruaj ntseg ntau ntxiv. Txhua tus khub tau txais nws tus kheej cim encryption tseem ceeb rau kev tso cai ntaus ntawv, cov ntaub ntawv siv tau kuaj xyuas, thiab lwm yam.

Rau cov tsis nyob hauv tsev / eCity li peb tuaj yeem muab cov ncauj lus encryption algorithm ( "C" qhov chaws) rau txhua tus khub rau microprocessor los tiv thaiv cov ntaub ntawv ua ntej kev sib txuas lus.

Nyob rau hauv cov ntaub ntawv no cov ntaub ntawv muaj kev ruaj ntseg tag nrho thaum kev sib txuas lus bidirectional hla kev tshaj xov xwm kev sib txuas lus (internet, Cua, thiab lwm yam) )).

1.4. Txhawb Kev Sib Txuas Lus Technology ntawm Cov Khoom Siv

@City IoT platform txhawb:

• GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - cov khoom siv (UDP / TCPIP kev sib txuas lus)

• LoRaWAN cov khoom siv (HTTP Webhooks) - ntawm LoRaWAN lub rooj vag thiab LoRaWAN network / thov servers

• Ethernet Tswjhwm (UDP / TCP kev sib txuas lus)

• WiFi Controllers (UDP / TCP kev sib txuas lus)

• Yav tom ntej IP khoom

• Cov khoom tsis yog IP ntawm kev txuas ntxiv hauv zos @ City / eHouse.PRO Gateway Hardware

@City IoT Platform muaj nplooj siab rau cov khoom siv / nodes:

• Haiv neeg ntawm iSys:

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

  • IoT (LoRaWAN)

  • WiFi - cov khoom lag luam rau @City Platform

  • Ethernet - khoom lag luam rau @City Platform

• Co-Production khoom (tsim los ntawm peb tog raws li iSys daim ntawv tso cai thiab cov hom sab nraud)

• Franchise khoom (tsim los ntawm peb tog raws li iSys daim ntawv tso cai nrog iSys logo)

1.5. @City huab neeg rau zaub mov

@City software ua haujlwm rau Linux raws VPS (Virtual Private Server) lossis Dedicated Server hauv internet sab, nyob ntawm kev thov ua haujlwm ntawm Server (hu ua tom qab Server):

• ntiag tug / pej xeem mus saib

• zuag qhia tag nrho cov khoom suav

• hloov tshiab ntawm cov khoom siv raws li txoj cai ntau zaus

• cov ntaub ntawv refresh

Ntau hom VPS tshwm sim nyob ntawm:

• Nqi

• cov ntaub ntawv-chaw geo-ib ncig

• Txheej txheem virtual cores (1-8)

• Virtual RAM (1-32GB)

• SSD disk (20GB-1TB)

Dozens ntawm Dedicated server tshwm sim nyob ntawm:

• Nqi

• cov ntaub ntawv-chaw geo-ib ncig

• Txheej txheem cores (4 .. 32)

• RAM (16 .. 512GB)

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

Lub @City IoT platform yog mob siab rau cov neeg siv khoom nkaus xwb:

• cov tsoom fwv hauv zos thiab cov tub ceev xwm (Nroog, Zej Zog, Tebchaws)

• B2B (rau tus tswv thib peb)

Vim tias nws tsis tuaj yeem sib qhia Neeg rau zaub mov ntawm cov neeg siv khoom, nws yooj yim kom muaj kev nyab xeeb thiab kev ua haujlwm zoo. Vim qhov laj thawj no tsuas yog cov neeg siv khoom muaj lub luag haujlwm zoo rau kev ruaj ntseg zoo, kev ruaj khov, ua haujlwm zoo, cov ntaub ntawv sib kis, thiab lwm yam. Thaum tsis muaj qhov ua tau zoo, tus neeg yuav khoom yuav cov kev npaj siab dua (VPS lossis Dedicated Server), tau zoo dua rau kev ua haujlwm thiab kev ua haujlwm zoo.

Hauv kis tshwj xeeb "Cloud to cloud" kev sib txuas lus tej zaum yuav raug siv rau kev lag luam thoob ntiaj teb thiab nruab nrab ntawm cov ntaub ntawv mus rau thaj chaw loj dua es tsis txhob muaj huab ntau cov neeg.

1.5.1. Neeg rau zaub mov thiab kev sib txuas lus rooj vag

Kev sib txuas lus ntawm @City Server tau paub raws li daim ntawv thov theem qis rau kev ua haujlwm siab kawg.

Lub ntsiab ntawm @City Server daim ntawv thov yog:

• asynchronously tau txais cov ntaub ntawv los ntawm cov khoom siv (ntawm cov ntaub ntawv: UDP, TCP IP, HTTP)

• txo cov ntaub ntawv siv tsawg thiab nws cov nqi ntawm khoom siv thiab Huab (los ntawm kev siv qib sib txuas lus raws li UDP, TCP IP)

• tau txais cov xwm txheej encrypted of devices (ntawm kev tshaj xov xwm sib txuas lus)

• kev tso cai thiab kev siv cov ntaub ntawv los ntawm cov khoom siv los ntawm kev txiav txim siab ntawm lawv cov xwm txheej

• txiav txim siab kiag li cov xwm txheej thiab hloov kho nws mus rau MariaDB / MySQL cov ntxhuav ncaj qha (hauv cov ntaub ntawv nyoos ntaub ntawv)

  • Cov ntaub ntawv tam sim no (muaj tsuas yog cov xwm txheej tshiab ntawm txhua lub khoom siv)

  • cov ntaub ntawv keeb kwm (muaj txhua cov xwm txheej rau ib qho khoom siv)

• xa cov lus txib tseem tsis tau paub (Txheej xwm) rau khoom siv

• paub tseeb tias kev sib koom tes tuav tes, pov thawj thiab cov lus pom zoo

@City Server software yog tib yam rau txhua tus neeg siv thiab tsis tuaj yeem raug kho rau cov neeg siv khoom sib txawv.

1.5.2 HTTP LoRaWAN kev koom ua ke

LoRaWAN cov tswj hwm tau koom nrog @City huab ntawm lub HTTP interface (webhooks) muaj nyob ntawm LoRaWAN network / application server.

Muaj ntau hom network / application server tau txais kev txhawb nqa:

TTN (sijhawm tsawg "Ntawm Cov Huab Cua" thiab qhov ntau naj npawb ntawm cov lus txib xa mus rau tus tsav tsheb thiab tsis pab txhawb kev txhim kho firmware)

LoraWAN-Tshooj (Yuav tsum tau hosting ntawm lub cev ntaus nrog kev nkag mus rau hauv is taws nem).

LoraServer.Io (Xav tau hosting ntawm lub cev ntaus nrog internet nkag - tsuas yog xa cov ntaub ntawv rau tus neeg rau zaub mov thiab tsis txhawb kev txhim kho firmware)

Lub @City Huab rau LoRaWAN tswj tau muab faib kom zoo ib yam nkaus rau lwm qhov cuam tshuam. Nws yog tham nyob hauv tshooj dhau los.

1.5.3. Pem hauv ntej-kawg interface

Front-kawg interface yog pom tau hais nrog PHP ntawv sau rau extract cov ntaub ntawv customized los ntawm @City huab Database. Nws siv cov txheej txheem tshawb nrhiav qeeb heev, raws li cov lus nug SQL los txwv cov ntaub ntawv xav tau. Interface muab cov lus nug tshawb fawb tau JSON cov qauv rau kev txiav txim siab ntxiv thiab ua los ntawm JavaScript Front-end Web "thov".

Original pem hauv ntej interface yog tib yam rau txhua tus neeg siv thiab tsis tuaj yeem raug kho rau cov neeg siv khoom sib txawv.

Overlay interface yuav tsim los ntawm peb cov neeg ua haujlwm lossis hauv kev koom tes hauv kev ua haujlwm kom paub meej txog kev cai rau cov qhua tuaj noj mov.

1.5.3. Txoj cai rau cov neeg rau zaub mov

Txoj cai ntawm tus neeg siv khoom (rau Server lub cev) yog txwv.

Kev nkag ua ntaub ntawv rau "tus qauv" cov ncauj lus tsuas (cov ntaub ntawv ib txwm siv - .txt, .js, .css, .html):

• ntxiv, tshem tawm, hloov kho cov ntaub ntawv ntshiab HTML (Front-End GUI / Interface Development)

• ntxiv, tshem tawm, hloov kho pure cov ntaub ntawv ntshiab (Front-End GUI / Kev Sib Tham Tsim Kho thiab Cov Txheej Txheem)

• ntxiv, tshem tawm, hloov kho cov CSS Cov Ntaub Ntawv ntshiab (Pem Hauv Ntej-Xaus - Kev cai views / Cov ntsiab lus)

• ntxiv, tshem tawm, hloov kho cov ntawv cov ntaub ntawv ntawm cov qauv (Front-End GUI)

• ntxiv, tshem tawm, hloov kho tabs, luv luv, txuas rau cov txiaj ntsig cov ntaub ntawv

Lwm Txoj Cai Nkag Mus:

• Tag nrho nkag mus rau @City Cloud Database MySQL / MariaDB qhov twg txhua cov cuab yeej siv cov ntaub ntawv khaws cia

• Kev Nkag mus rau Lub Vev Xaib muaj kev txhais tau (kev lees paub) rau cov qhua tuaj noj mov.

• Cov qhua tuaj noj mov tsis raug tso cai hla dhau cov ntawv pov thawj rau cov neeg thib peb (ntau cov kev tshwm sim tuaj yeem cuam tshuam rau kev ua tau zoo, kev ruaj khov thiab kev nyab xeeb ntawm txhua qhov system)

• Raws li qhov xwm txheej tshwj xeeb thiab kev siv qhov kev ua tau zoo Dedicated Server, pej xeem tus account yuav raug teeb tsa los saib xyuas cov ntaub ntawv tam sim no (tsis yog keeb kwm).

• Tus neeg siv yuav theej tawm cov ntaub ntawv rau nws tus kheej MySQL server thiab ua tus kheej cov ntaub ntawv txheeb xyuas thiab ua, thiaj li tsis muaj kev cuam tshuam kev ua haujlwm ntawm @City Server

iSys - Cov neeg ua haujlwm ntse Lub Hauv Paus - muaj kev nkag mus rau tag nrho cov neeg rau zaub mov nrog rau tus lej hauv paus thiab tag nrho DB nkag mus rau kev saib xyuas.

Nyob rau qee qhov xwm txheej iSys yuav tso cai ntau ntxiv rau cov neeg siv khoom (PHP scripts, files) tom qab kuaj xyuas cov lej code, khiav cov kev sim, yog tias nws tsis cuam tshuam rau tag nrho cov system kev ruaj ntseg, ruaj ntseg thiab kev ua haujlwm.

1.6. Pab kiag li lawm

1.6.1. CIoT - GSM khoom siv

Peb cov khoom muaj microcontroller thiab GSM / GPS / GNSS module (2G..4G, NBIoT, CATM1) rau kev sib txuas lus. Microcontroller muaj cov bootloader encrypted rau kev ruaj ntseg txhim kho OTA firmware. Qhov no ua rau peb tsim ntau cov qauv siv raws li qhov qub "CIoT Smart ntaus ntawv".

1.6.3. BAS, BMS, IoT - Ethernet thiab WiFi pab kiag li lawm

Ethernet thiab WiFi tswj tau tso cai IP raws kev sib txuas lus rau cov kab ke (tsis them nyiaj rau cov ntaub ntawv xa mus rau GSM tus neeg ua haujlwm). Cov khoom siv no kuj tseem tau sau cov bootloader thiab cov twj yuav raug hloov kho ntawm nws cov neeg sib txawv. Rau WiFi nws muaj OTA firmware nce qib los ntawm cov neeg rau zaub mov tseem ceeb

1.6.2. - LoRaWAN khoom siv

LoRaWAN enables cov ntaub ntawv sib kis ntawm qhov kev ncua deb tshaj (ze li kwv yees. 15km). Qhov ntau ntawm no yog nyob ntawm qhov nrawm ntawm cov ntaub ntawv xa khoom, tus nqi ntawm cov ntaub ntawv, kev ua nroog ntawm thaj chaw thiab qhov ua tau zoo ntawm cov xov tooj cua txoj kab ntawm cov cuab yeej.

Peb cov khoom siv suav nrog microcontroller thiab LoRaWAN module rau kev sib txuas lus. Tus microcontroller muaj qhov bootloader encrypted rau kev ruaj ntseg hloov kho OTA software. Qhov no tso cai rau koj los tsim kom muaj ntau hom kab ke raws li qhov qub "IoT smart device". Cov cuab yeej siv ua haujlwm hauv ISM qhib band tsis tau them nqi ntxiv. Nws yog qhov tsim nyog yuav tau siv LoRaWAN Gateways los npog tag nrho thaj chaw nrog kev nkag mus rau Is Taws Nem. Cov teeb meem ntawm LoRaWAN cov rooj vag uas tsis muaj nyob hauv thaj tsam ntawm cov khoom siv (teeb tsa rau TTN server), nws tau xa cov ntaub ntawv los ntawm lawv. Firmware upgrade yuav tsum muaj tus kheej network / thov LoRaWAN neeg rau zaub mov thiab ntau yam zoo rau kev sib txuas lus.

1.7. Kev Ua Lag Luam Ua Lag Luam (B2B) kev xaiv

Muaj ntau txoj kev xaiv rau kev lag luam thiab kev koom tes:

• import / export npaj cov khoom lag luam (switchboards, devices) - cov khoom kawg

• import / export OEM khoom (PCBs, maub los, thiab lwm yam) - theem nrab khoom, khoom seem

• franchise - ntau lawm raws li peb daim ntawv tso cai rau kev lag luam hauv zos (peb tsuas muab cov programmom microcontrollers) raws li iSys - Cov Tshuab Txawj Ntse

• Co-Production - (raws li saud) tab sis hauv qab Kev Cuam Tshuam Sab Nraud

2. @City IoT Platform muaj nuj nqi

@City platform txhawb cov ntawv ntim rau Customizable Front-End rau kev pom cov ntaub ntawv, cov lus nug, kev txwv thiab kev ua (cov ntaub ntawv tam sim no / keeb kwm):

• pom tau cov ntaub ntawv raug xaiv hauv daim duab qhia chaw (thaj chaw hauv ib cheeb tsam)

• qhia cov ntaub ntawv xaiv thiab cov txiaj ntsig hauv cov ntxhuav

• qhia pom cov ntaub ntawv xaiv hauv kab kos

• qhia pom cov ntaub ntawv xaiv hauv kab kos keeb kwm

• export cov ntaub ntawv rau cov ntawv thov kev pabcuam thib peb thiab kev ua haujlwm ntxiv

• lwm cov haujlwm yuav raug kho ntawm tus neeg thov.

Tus Neeg Siv Khoom Ua Ntej-Kawg mus siv tau los ntawm IP zoo li qub lossis DNS rov sau / subdomain / ntawv yog tias muaj.

Yam Ntxim Saib Ntxim Ua & Demo installation (Nws tsuas yog qhib rau cov neeg yuav khoom ib leeg xwb).

Thov qhia rau peb thaum koj xav kuaj nws - txhawm rau pab pej xeem mus nkag rau lub platform.

Nws tuaj yeem xav kom IP zoo li qub ntawm tej thaj chaw deb khoos phis tawm kom muaj kev sib txuas lus rau @City platform.

3. Nplooj Ntawv Tseem Ceeb

Lub nplooj ntawv tseem tshuav nyob ncaj qha rau kev ruaj ntseg: http: //% Koj li% / IoT /

Tej zaum nws yuav tso tawm ib qho zuj zus thiab kho thiab muaj cov kev txuas rau txhua qhov kev pabcuam ntawm @City IoT Platform yog tias yuav tsum muaj

4. Daim Ntawv tseem ceeb

Daim foos tseem ceeb yog tsim los tsim cov presets tshiab thiab cov tab: http: //%IP%/IoT/que.php

Nov yog daim ntawv pib rau kev tsim cov txiaj ntsig, kev pom thiab tabs rau txhua qhov kev teeb tsa

Cov lus piav qhia (Los ntawm sab saum toj thiab sab xis mus rau sab xis)

4.1. Header

4.1.1. Tsev Txuas - (qhib cov lus qhia tau tiag tiag)

4.1.2. "X" checkbox - qhib / kaw Daim Ntawv Nug Daim Ntawv

4.1.3. "V" checkbox - qhib / kaw Daim Teb Daim Ntawv

4.1.4. Cov duab nraaj - txuas mus rau qhov pom tau (kho tau)

4.2. Daim ntawv:

4.2.1. "X" checkbox - qhib / kaw tag nrho Daim Ntawv Nug Daim Ntawv

4.2.2. CSS - Xaiv Cov Ntsiab Lus Pom Kev

Hloov kho Visualization ntsiab lus CSS cov ntaub ntawv yuav tsum muaj nyob rau hauv "qauv / css /" ntawv qhia - teev tau siv.

4.2.3.Vauv Teb lub thawv ntsuas - qhia / hides Daim Teb Teev Sau

4.2.4. Tab: Tab Lub Npe mus ntxiv lossis tshem tawm

4.2.5. Ntxiv / Tshem Tawm Nyees khawm - Ntxiv lossis tshem tawm cov tab nrog lub npe hauv Tab teb

4.2.6. Xaiv Tub Ntxhais Khawm

Xaiv cov teb tseem ceeb pom ntawm lub rooj. Nws yog hloov kho cia li tau.

4.2.7. Tsis Xaiv Txhua Khawm

Tsis teb tag nrho cov teb (yuav tsum tau ua raws los ntawm xaiv qee qhov ntawm lawv tus kheej)

4.2.7. Xaiv Txhua Tus Khawm

Xaiv tag nrho cov teb (yuav tsum tau ua raws nrog deselect qee ntawm lawv tus kheej)

4.2.8. Zais Lim - Zais tag nrho Daim Ntawv

Qhov no yog sib npaug ntawm txhua (X) kem

4.2.9. Muab tua Khawm - Hloov cov kev hloov chaw

4.2.10. "V" checkbox - qhia / siab lim teb.

4.3. Tab

Tus kheej tsim tabs nrog cov npe thiab cov presets (khaws cia hauv cfg / tabs.cfg cov ntaub ntawv).

Cov ntaub ntawv tiag muaj lub npe thiab URL (sib cais los ntawm tab tab).

4.4. Cov Txheej Txheem

Qhia txog txhua daim teb txwv los ntawm Kev Ncig Lim.

Liaj teb hauv lub rooj:

4.4.1. Khiav - views tshwm sim hom

daim ntawv qhia- daim phiaj qhia chaw nyob rau hauv daim ntawv qhia (ib lossis ntau daim teb yuav tau xaiv)

keeb kwm - Cov kab kos keeb kwm (ib lossis ntau daim teb yuav raug xaiv)

tab - cov lus qhia cov lus (ib qho ntxiv ntawm cov liaj teb yuav tau xaiv)

bar - tsuas yog ib daim teb tso tawm kom pom ntawm daim duab bar

Ntawm nias ib qho ntawm nws tus nqi nws yuav qhib cov txiaj ntsig tshiab nrog cov chaw uas raug xaiv (rau kab tam sim no).

4.4.2. Luam (+/- txuas tau)

Ntxiv / rho tawm Tab nrog cov npe teev hauv Tab teb. Nws tsuas yog siv cov teb uas xaiv nyob rau tib kab ntawm lub rooj.

4.4.3. Kev Txuas Ntawm Lub Rooj Cell

Nias lwm lub npe teb yuav pib Cov Ntaub Ntawv Pom Kev ntawm teb xaiv rau kab xaiv.

4.5. Cov Ntaub Ntawv Xaj

Kev txiav txim ntawm cov tso tawm teb yog raws li nws cov kev txiav txim hauv daim teb daim ntawv (txawm li cas los xij tm daim teb ib txwm xa mus rau qhov kawg ntawm cov ntawv nyeem). Qhov kev txiav txim no tsuas yog hloov pauv nrog kev kho qhov ncaj qha ntawm URL tsis (teb chaw txiav txim ib feem).

4.6. Piv txwv

Piv txwv li: Teeb Tab nrog Khoom Siv Taug Kev lub npe thiab muaj daim ntawv qhia nrog lub sijhawm thiab nrawm rau ntawm daim pheem thib

Txhua qhov kev piav qhia hais txog kab nyob qhov twg "Map" kab ntawv hauv "Khiav" kem.

1. Sau lub npe "Khoom Siv Taug Kev" hauv Tab teb (tsis muaj cov cim qhia)

2. Nco ntsoov tias txhua kab yog tsis xaiv hauv kab

3. xaiv tm, gps_speed_km tsuas yog hauv kab nkaus xwb

4. nias + khawm qhov uas nyob rau hauv kab

5. Daim Phiaj Xwm

Cov duab qhia tuaj yeem tsim los ntawm MainForm nrog kev teeb tsa ua ntej

5.1. Kev Pib Ua Daim Ntawv Qhia

Daim ntawv qhia chaw pib tau ua manually thaum tua ncaj qha nrog txuas: > http: //%IP%/IoT/maps.php

1. 
   Tus neeg siv yuav tsum tau Xaiv tag nrho cov teb (Nias Tsis xav muab Khawm)

2. Nias qee qhov khij rau cov chaw ua haujlwm pom (eg. Ain5 (rau Smog qib) thiab tm (rau kev ntsuas hnub / sijhawm)

3. nias "V" checkbox los zais teb daim ntawv

4. nias Muab tua khawm kom khiav DB lus nug thiab tso saib cov ntaub ntawv tam sim no los ntawm txhua tus sensors / khoom siv

5. Daim ntawv qhia nrog cov ntaub ntawv tau hloov kho tom qab 30 vib nas this lossis ntau dua.

5.2. Xaiv chaw rau cov lus nug

Cov chaw qhia tau piav los ntawm sab laug mus rau xis (nyob saum toj no).

5.2.1. Hloov MAP nplai (Qib Qib)

1. Zoom theem yuav tau hloov siv (+/-) khawm rau teev (current_scale * 2 lossis current_scale / 2 feem). Nias ib qho ntawm cov nyees khawm no yuav hloov kho qhov nplai.

2. Lwm txoj kev yog xaiv Zoom Theem hauv Zoom Combo Box teb thiab nias Muab tua khawm. Hauv qhov no tag nrho Pom / daim ntawv qhia rov qab thiab kho dua tshiab (siv sijhawm thaum pib lub sijhawm).

5.2.2. IMEI (Xaiv Ntaus Teb)

IMEIteb muaj cov cim ID lossis Cov Cim Cuav rau ib qho khoom siv. Qhov chaw ntawd * (lub npe) uas qhia tau tias qhov tseem ceeb tshaj plaws thiab geolocation rau txhua lub cuab yeej.

Teeb tsa IMEI rau lwm yam nqi, yuav qhia cov ntaub ntawv keeb kwm ntawm xaiv ntaus ntawv. Nws muaj kev nkag siab tsuas yog siv xov tooj ntawm tes thiab txav tau tawm, txwv tsis pub cov qhab nia yuav sib tshooj rau daim duab qhia ntawm tib qho chaw.

5.2.3. Lon, Lat (Longitude, Latitude koom tes teb)

Teeb chaw ntawm daim ntawv qhia. Daim teb no tau teeb tsa tus ncauj lus zoo li txoj haujlwm thaum lub pob nyem nas rau ntawm daim pheem thib.

5.2.4. Hloov MAP Style (Ntsiab)

Daim ntawv qhia cov ntsiab lus / ntsiab lus tuaj yeem xaiv los ntawm Map ComboBox teb (piv txwv li Tsaus, Grey, Topographic).

Ntau daim duab qhia chaw kuj yuav muaj ntau qhov nce qib siab sib txawv yog li ntawd nws yuav yuam kom Lub Hom Phiaj kom nce qib daim ntawv qhia.

5.2.5. COV KAB LIS

Qhov Kev Ncaj Ncees yog siv rau cov lus nug ntxiv {Qhov twg seem} rau MySQL / MariaDB.

Cov kab lus no tau raug coj los txiav txim siab tsim txoj cai QUERY hlua rau cov txiaj ntsig database. Tej zaum nws yuav txwv cov ntaub ntawv, sijhawm thiab lwm yam txiaj ntsig los ntawm kev txwv kev suav cov txiaj ntsig. Thawj lub npe cov lus teb (tsis yog cov npe) yuav tsum siv cov teb no. Xws li.

1. gps_speed_km> 10 // ceev yog ntau tshaj 10km / teev

2. ain5> 3 // ain5 yog qhov ntau dua 3 (tuav 2.5um hais qhov tseeb suav - qib smog)

3. gps_speed_km> 10 thiab ain6> 5 // ceev tshaj 10km / teev thiab ain6 ntau dua 5 (tuav 10um hais tau suav - smog qib)

5.2.6. Muab tua (Khiav Query Button)

Nias lub pob no yog qhov yuav tsum tau hloov pauv txhua lub sijhawm, ntsuas (tshwj tsis yog nias +/- khawm).

Daim ntawv qhia yog thauj khoom los ntawm qhov pib nrog lub presets tshiab.

Daim ntawv qhia tsis yog qhov muag txhua lub sijhawm, thaum tsis muaj cov ntaub ntawv tuaj rau cov lus nug tam sim no.

5.2.7. Tsis Xaiv Txhua (Tshem tawm txhua daim teb los ntawm cov lus nug)

Tom qab koj nias lub pob lus no tsawg kawg ib qhov chaw yuav tsum tau xaiv los ntawm txhais tes los qhia cov txiaj ntsig ntawm daim pheem thib.

5.2.8. "V" Checkbox (Qhib / Kaw Teb Daim Ntawv)

Lub npov no tau siv los qhia / nkaum kev xaiv ntawm cov zaub kom tso saib.

5.2.9. "X" Checkbox (Show / Hide Query Form)

Lub npov no yog zais tag nrho Daim Ntawv tshwj tsis yog ( +/- khawm)

Cov txiaj ntsig hauv daim ntawv qhia yog hloov dua tshiab thiab hloov kho nrog cov txiaj ntsig tshiab

5.3. Piv txwv

Eg Smog cov qhab nia (Cov pa roj teeb nkag ntawm lub tsheb): Cov pa hluav taws ntawm qib 2.5um ib qhov me me (Ain5), Kev nrawm (gps_speed_km), Hnub / Sijhawm (tm), daim ntawv qhia (2 - topographic), nthuav dav 16

Qhov clause:

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

// GPS = siv tau 3D tas hnub & hnub = 2019-02-18 & ceev> 0 km / h

6. Pom Cov Lus Qhia Hauv Cov Lus

Pom cov qhabnias hauv lub rooj.

Nyob rau "Daim Ntawv tseem ceeb" nias "rooj" yam khoom, tom qab xaiv qee cov liaj teb los tso saib lub rooj ua ntej

6.1. Pib ntawm lub rooj

Thaum lub rooj qhib ntawm qhov txuas http: //%IP%/IoT/que.php? func = tabs nws yuav tsum tau ua ntej kev ua ntej ntawm kev teeb tsa.

Koj tuaj yeem xaiv thaj chaw pom (los ntawm nias "Pom liaj teb" ) kem.

1. Nias txhua lub npov uas xav tau rau thaj teb

2. Nias lub thawv "Pom liaj teb" mus nkaum daim teb

3. Xovxwm Execute khawm kom khiav DB lus nug thiab tso saib lub rooj

6.2. Xaiv chaw rau cov lus nug

Cov chaw qhia tau piav los ntawm sab laug mus rau sab xis (ntawm lub screenshot).

6.2.1. Tsi - kev tsim hom teb thiab kev txiav txim nce / nqis

Ruam cov teb yog sib npaug ntawm nias sab header.

6.2.2. DB / IMEI - Xaiv Ntaus Ntawv

IMEIteb muaj cov cim ID lossis Cov Cim Cuav rau ib qho khoom siv. Nrog khoob nqi nws qhia tau cov lus ntawm cov nqi tam sim no.

Teeb tsa IMEI rau lwm yam nqi, yuav qhia cov ntaub ntawv keeb kwm ntawm xaiv ntaus ntawv.

6.2.3. CSS - xaiv style (Nrig txog kev pom lub ntsiab)

6.2.4. Pom liaj teb - Qhia / nkaum Daim Teb Daim Ntawv

6.2.5. Tshem tawm npliag - Tsis txhob khij txhua kab ntawv

6.2.6. "X" Checkbox (Show / Hide Query Form)

6.2.7. Qhov twg Txhab (rau cov ntaub ntawv tsis pub tshaj)

Qhov no yog sufix rau MySQL / MariaDB cov lus nug ntxiv {Qhov twg}

Cov kab lus no tau raug coj los txiav txim siab tsim txoj hlua QUERY rau cov txiaj ntsig database. Tej zaum nws yuav txwv cov ntaub ntawv, sijhawm thiab lwm yam txiaj ntsig los ntawm kev txwv kev suav cov txiaj ntsig. Thawj lub npe cov lus teb (tsis yog cov npe) yuav tsum siv cov teb no. Xws li.

1. gps_speed_km> 10 // ceev yog ntau tshaj 10km / teev

2. ain5> 3 // ain5 yog qhov ntau dua 3 (tuav 2.5um hais qhov tseeb suav - qib smog)

3. gps_speed_km> 10 thiab ain6> 5 // ceev tshaj 10km / teev thiab ain6 ntau dua 5 (tuav 10um hais tau suav - smog qib)

6.2.8. Xaiv Tub Ntxhais Khawm (Qhib cov teb feem ntau)

6.2.9. Tsis Xaiv Txhua Khawm (Tshem tawm txhua cov lus los ntawm cov lus nug)

Tom qab koj nias lub pob lus no tsawg kawg ib qhov chaw yuav tsum tau xaiv los ntawm txhais tes los qhia cov txiaj ntsig ntawm daim pheem thib.

6.2.10. Muab tua (Khiav Query Button)

Nias lub pob no yog qhov yuav tsum tau hloov pauv txhua lub sijhawm, ntsuas (tshwj tsis yog nias +/- khawm).

Cov lus yog reloaded los ntawm thaum pib nrog tshiab presets.

6.2.11. "V" Checkbox (Qhib / Kaw Teb Daim Ntawv)

Lub npov no tau siv los qhia / nkaum kev xaiv ntawm cov zaub kom tso saib.

Cov txiaj ntsig hauv qhov rooj tau txheeb raws li Txheeb chaw teeb tsa. Kev txiav txim siab hloov tau tuaj yeem hloov los ntawm nias kab kab khawm (ib zaug rau ib qho kev qhia ob zaug rau lwm qhov kev taw qhia).

Qee qhov tshwm sim hauv kab ntawv txuas tau txuas ntxiv rau cov ntxaij vab tshaus ua kom pom tseeb (nyuaj-coded).

Thaum tso tawm cov ntaub ntawv keeb kwm rau cov cuab yeej nws yuav tsum txwv nyob rau hauv kom tsis txhob qhia tag nrho cov keeb kwm ntaub ntawv vim tias nws yuav ua rau kev ua haujlwm lossis tawm ntawm cov teeb meem nco.

7. Peb muaj 7. Cov Ntawv Cim Npog.

Cov kab kos kab ntawv yuav tsum raug tua los ntawm Daim Ntawv Tseem Ceeb los ntawm nias ib daim teb hauv "Bar" uake.

Nws qhia kev cais cov txheej xwm ib txwm ua dhau los rau tus nqi siab kawg, uas qhia los ntawm qhov siab tshaj plaws rau qis tshaj kev txiav txim.

Nws yog txiaj ntsig rau qhov ntsuas ceev ceev qhov tshwm sim thiab coj qee yam.

Mouse Over kev tshwm sim yuav qhia cov ntaub ntawv ntxiv rau cov ntaus ntawv.

8. 8. Keeb Kwm Keeb Kwm.

Cov kab kos keeb kwm tuaj yeem pib los ntawm MainForm thaum nias kab ntawv xaiv hauv kab "Keeb kwm" kab (rau ib daim teb).

Rau Ntau daim teb hauv "Keeb Kwm" kab uas xav tau cov teb yuav tsum raug kuaj xyuas thiab "Keeb Kwm" txuas yuav tsum tau nias rau hauv "Khiav" kem.

Keeb kwm cov txiaj ntsig tau tsuas yog kav ntev kawg 24 teev + 24 teev tom ntej (rau cov phiaj xwm ua kom rov zoo nkauj), thaum tsis muaj kev txwv tau teeb tsa.

8.1. Pib cov kab kos keeb kwm

Keeb kwm kab kos thaum qhib los ntawm lub ntsiab txuas xav tau pib ua lwm yam kev tshwm sim, thaum qhib los ntawm qhov txuas tsis muaj qhov txwv tsis tau.

Ntau qhov chaw kuj yuav raug xaiv los ua kom pom ntau yam. Nws tseem tuaj yeem tsim nyob rau hauv Daim Ntawv Lim Av.

1. Nias txhua lub npov uas xav tau rau thaj teb

2. Nias lub thawv "Pom liaj teb" mus nkaum daim teb

3. Xovxwm Execute khawm kom khiav DB lus nug thiab tso saib lub rooj

8.2. Xaiv Chaw ntawm Cov Kab Cim Keeb Kwm

Cov khoom tau piav los ntawm sab saum toj thiab sab laug mus rau sab xis (ntawm lub screenshot).

8.2.1. IMEI - (Xaiv Ntaus ntawv los tso saib cov ntaub ntawv keeb kwm)

IMEIteb muaj cov cim ID lossis Cov Cim Cuav rau ib qho khoom siv. Nrog * (asterix) tus nqi nws qhia cov lus ntawm cov txiaj ntsig tsis ntev los no uas tsis muaj kev nkag siab zoo.

Teeb tsa IMEI rau lwm yam nqi, yuav qhia cov ntaub ntawv keeb kwm ntawm xaiv ntaus ntawv.

8.2.2. Min - txwv tsawg tus nqi ntawm thawj daim teb

8.2.3. Max - txwv tus naj npawb siab kawg ntawm thawj daim teb

8.2.4. "V" - Qhia / nkaum Daim Teb Daim Ntawv

8.2.5. Ntawm: teem hnub / sijhawm tsawg kawg (*)

8.2.6. Rau: teem caij rau hnub tim / sijhawm (*)

8.2.7. "X" Checkbox (Show / Hide Query Form)

8.2.8. "Qhov twg" Txhab

Nqe lus rau kev txwv cov ntaub ntawv kev tshwm sim MySQL / MariaDB cov lus nug ntxiv {Qhov twg seem}.

Cov kab lus no tau raug coj los txiav txim siab tsim txoj cai QUERY hlua rau cov txiaj ntsig database. Tej zaum nws yuav txwv cov ntaub ntawv, sijhawm thiab lwm yam txiaj ntsig los ntawm kev txwv kev suav cov txiaj ntsig. Thawj lub npe cov lus teb (tsis yog lub npe) yuav tsum siv rau hauv daim teb no thiab siv tau SQL syntax. Xws li.

1. gps_speed_km> 10 // ceev yog ntau tshaj 10km / teev

2. ain5> 3 // ain5 yog qhov ntau dua 3 (tuav 2.5um hais qhov tseeb suav - qib smog)

3. gps_speed_km> 10 thiab ain6> 5 // ceev tshaj 10km / teev thiab ain6 ntau dua 5 (tuav 10um hais tau suav - smog qib)

8.2.9. Tsis Xaiv Txhua Khawm (Tshem tawm txhua cov lus los ntawm cov lus nug)

Tom qab nias lub pob lus no tsawg kawg ib qhov chaw yuav tsum tau xaiv los ntawm txhais tes los qhia cov txiaj ntsig keeb kwm.

8.2.10. Muab tua (Khiav Query Button)

Nias lub pob no yuav tsum hloov qee qhov chaw, tsis dhau (tshwj tsis yog qhia pom liaj teb lossis lus nug). Cov lus yog reloaded los ntawm thaum pib nrog tshiab presets.

8.2.11. "V" Checkbox (Qhib / Kaw Teb Daim Ntawv)

Lub npov no tau siv los qhia / nkaum kev xaiv ntawm cov zaub kom tso saib.

8.3. Tuav Variant: (qhia txog cov ntaub ntawv tsuas muaj)

8,4. Nruam variant (nrog tib cov ntaub ntawv):

Nas pointer tso saib qhov tseem ceeb ntawm kev ntsuas thiab hnub thiab sijhawm.

9. 9. Web browser Sib Piv

* - Firefox tsis txhawb nqa hnub / sij hawm xaiv (ntawv teb yuav tsum tau kho kom raug siv siv sijhawm tsim nyog hnub tsim).

Internet Explorer tsis muaj kev txhawb nqa (siv Ntug hloov)

Lwm lub web browsers tsis tau sim.

10. Cov ntsiab lus Customization

Cov nplooj ntawv Web site yog ua raws cov ntaub ntawv dav dav nyob ntawm "Qauv" phau ntawv qhia "* .template".

Ntxiv rau txhua nplooj ntawv muaj:

1. "* .head" cov ntaub ntawv uas khaws lub ntsiab ntawm nplooj ntawv (txuas, CSS txawv teb, JavaScript Cov Ntaub Ntawv, thiab lwm yam. )

2. "* .foot" cov ntaub ntawv uas khaws footer ntawm nplooj ntawv (kev txuas, thiab lwm yam) )

Visualization Theme tuaj yeem hloov pauv raws li cov neeg siv kev nyiam los ntawm kev ua qauv thiab kho cov ntaub ntawv CSS. CSS cov ntaub ntawv nyob hauv "qauv / css" qhia npe. Cov Vev Xaib Sib Txawv Web Nplooj yuav raug siv los tsim qhov zoo rau piv txwv. luam ntawv, SmartPhones, PADs cov qauv.

Table views - muaj qhov chaw xaiv rau xaiv CSS cov ntaub ntawv rau kev ua tiav cov ntsiab lus (khaws cia rau hauv "qauv / css / tabs" coj qhia).

Map kev saib - cov ntsiab lus dav dav yog xaiv los ntawm "daim ntawv qhia" ntaus combo lub thawv. Tsis tas li ntawd muaj qhov ua tiav CSS cov ntawv "qauv / css / map.css" uas muaj qee qhov kev ua haujlwm zoo ib yam li zais / xim tshwm sim raws nws cov txiaj ntsig. Qhov seem ntawm daim ntawv CSS no yog txwv rau qhov kev nug thiab cov foos.

Feem ntau @City Platform PHP files rau visualization txais cssparameter nrog tus nqi ntawm cov ntaub ntawv npe rau lub ntsiab (tsis muaj txuas ntxiv). Cov ntaub ntawv yuav tsum muaj nyob hauv "qauv / css" cov npe thiab npe yog rhiab.

Qee lub ntsiab ntawm Cov Khoom Nqa Pom yog nyob ncaj qha hauv JavaScript cov ntaub ntawv nyob hauv "template / js" qhia npe.

Qhov tseem ceeb @City tsab ntawv"@ City.js" yog nyob rau hauv cov ntawv sab saud. Tsis muaj qhov hloov kho tau ntawm qhov no qhov chaw, txawm li cas los xij tsab ntawv tuaj yeem muab theej rau "qauv / js" phau ntawv qhia thiab hloov kho muaj. Kev siv ntawm tus kheej tsab ntawv yuav tsum hloov kho txhua lub header files.

11. 11. Cov txheej txheem hloov kho

Qee qhov tshwj xeeb sensors yuav xav tau lub zog ua haujlwm muab xam.

Yog tsis muaj peev xwm hloov kho thiab tswj ntau yam sib txawv ntawm @City neeg rau zaub mov Software, Front-kawg PHP interface, uas yuav ua rau ntau qhov teeb meem, hloov kho, yuam kev.

Txoj kev ua tau zoo tshaj plaws thiab yooj yim tshaj plaws los ua kom tiav nws, yog kho cov ntaub ntawv "overlay" rau kev tso saib kom tsim nyog ntawm cov nqi / piav qhia.

Original JS cov ntawv yog qhib ntawv cov ntawv thiab tej zaum yuav raug coj los ua raws li cov neeg siv khoom xav tau. Raws li tau teev hauv tshooj dhau los lawv yuav tsum tau theej rau "qauv / js" phau ntawv qhia uas cov neeg siv khoom muaj cov cai rau kev hloov kho.

Kev pom ntawm lub cajmeem ntawm @City system tsis yog ib qho kev kawm ntawm daim ntawv no, txawm li cas los xij Web tsim nrog cov kev paub yooj yim ntawm HTML thiab JS yuav kho qhov Front-kawg Web daim ntawv thov rau cov tib neeg cov kev xav tau.

12. 12s. Cov Qauv Ntaub Ntawv

@City Database nrog lub npe "IoT" lossis "* IoT" tau muab faib ua ke hauv cov ntxhuav (qhov twg asterix tau sau ua ntej nyob ntawm hosting server - yog tias yuav tsum tau). Cov ntaub ntawv DataBase yuav raug pom nyob hauv PHPAdmin (web thov) ntawm cov ntawv txuas http: //% IP% / phpmyadmin

Ntxhuav Teeb rau Txhua Lub Ntaus (qhov twg * {asterix} yog IMEI chaw nyob - cim ID):

• "* _t" - tokens rau kev tso cai rau cov neeg siv tam sim no (tsis siv rau Ib Tug huab Huab)

• "* _c" - cov lus txib (Txheej xwm) cov ntawv qhia - kom raug xa mus rau lub cuab yeej

• "*" - txhua yam tshwm sim ntawm cov xwm txheej.

Lwm cov ntxhuav:

• "ithings_" cov lus - muaj decoded tam sim no cov xwm txheej ntawm txhua cov khoom siv (nws tau theej thaum lub sijhawm hloov pauv ib qho ntawm "*" rooj). Tus qauv ntawm Ib Feem Kaum_ lub rooj yog yuav luag tib yam rau lub "*" rooj. "ithings_" muaj cov teb ntxiv rau Chaw Xa Ntawv thiab cov lus piav qhia.

• "cov neeg siv" lub rooj yog txwv thiab yuav tsum tau hloov kho.

12.1. "ithings_" thiab "*" cov qauv rooj

• "idx" - Qhov ntsuas

• "tm" - tsis siv neeg timestamp

• "Dt" - unix timestamp

• "imei" - cim ntaus ntawv chaw nyob

• "rssi" - RSSI teeb liab theem

• "rsrp" - RSRP teeb liab

• "Txheej xwm" - tos cov xwm txheej raug xa mus rau tus tswj hwm

• "out1" .. "out16" - txiav txim siab tawm ntawm cov xwm txheej

• "in1" .. "in16" - txiav txim siab inputs xwm txheej

• "ain1" .. "ain8" - DOC qhov tseem ceeb ADC (RAW)

• "sens1" .. "sens8" - hloov dua siab tshiab sensor qhov tseem ceeb (nyob ntawm ntaus ntawv hom)

• "dimm1" .. "dimm8" - rho tawm dimmers qhov tseem ceeb (nyob ntawm ntaus ntawv hom)

• "int1" .. "int6" - cim qhov rooj tus nqi (nyob ntawm ntaus ntaus)

• "text1" .. "text6" - cim ntawm tus nqi ntawm phau ntawv (nyob ntawm ntaus ntawv hom)

• "tsim" - ntaus ntawv tsim hnub / sijhawm

• "kawg" - Hnub kawg / sijhawm

• "neeg siv" - yav tom ntej siv

• "dhau" - yav tom ntej siv

• "sn" - gsm serial nr

• "xwm txheej" - cov xwm txheej tam sim no tsis tau txiav txim siab hauv hom hex

• "hash_code" - siv yav tom ntej

• "addr" - luv ntaus chaw nyob

• "fwnr" - firmware nr

• "xiam oob qhab" - lub cev tsis taus (tsis ua)

• "gsm_nr" - CIoT gsm tus lej

• "tus muag khoom" - cov chaw muag khoom code (rau franchise / co-production)

• "sijhawm cheeb tsam" - Lub Sijhawm Tsam offset

• "dst" - Siv Cov Nyiaj Txiag Txhua Hnub

• "gps_lat" - GPS Nruab Nrab

• "gps_long" - GPS Ntev

• "gps_hdop" - GPS HDOP

• "gps_alt" - GPS Altitude

• "gps_fix" - GPS Fixation (yuav tsum yog 3 - rau qhov tshwm sim siv tau)

• "gps_cog" - GPS Cog

• "gps_speed_km" - GPS Ceev hauv [km / teev]

• "gps_sat" - GPS satellites pom

• "teb chaws", "lub teb chaws", "thaj av", "subregion", "subsubregion", "nroog", "koog tsev kawm ntawv", "txoj kev", "txoj kev_nr", "item_nr" - Cov qhua tuaj noj mov chaw nyob thiab cov lus piav qhia (!!!! Tsis muaj "" " keeb kwm cov ntxhuav)

• "cav" - teev cov ntaub ntawv
  
  Cov npe cov npe tseem ceeb rau kev tsim cov lus nug SQL rau kev nrhiav haujlwm nce ntxiv vim tias lub npe qub yuav tsum tau siv nyob rau hauv nqe lus SQL.
  
  

12,2. Ntaus cov lus txib (Cov xwm txheej) cov kab "* _c" rooj - qauv

Cov lus no yog qhov teeb meem / cov lus txib ua kom haum rau txhua lub cuab yeej thiab muaj cov qauv hauv qab:

• "txib" - hais kom xa los yog twb tau xa mus rau tus tswj hwm

• "pom tseeb" - daim ntawv qhia paub yog tias nws twb tau xa thiab paub tseeb

• "hnub tim" - unix timestamp ntawm kev tshwm sim

• "hloov kho" - pib chij hloov tshiab (tim hnub tim / sijhawm)

12,3. Kev nkag mus rau cov txiaj ntsig tau los ntawm cov ntaub ntawv pov thawj - Qib Nruab Nrab (Cov Ntaub Ntawv Nyeem)

Cov ntaub ntawv tuaj yeem siv tau yam tsis muaj Daim Ntawv Thov Ua Ntej-kawg Web. @City system muaj cov ntawv sau nrog kev ua haujlwm nruab nrab. Cov txiaj ntsig tau xa rov qab rau JSON hom.

12.3.1. Tau txais cov xwm txheej tam sim no ntawm txhua lub khoom siv

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

Lus nug rov qab los ua txhua yam "_ithings" cov lus (cov xwm txheej tam sim no ntawm txhua lub khoom siv) hauv JSON Hom:

[{ "lub teb chaws":"", "lub nroog":"", "sab av loj":"", "lub teb chaws":"", "cheeb tsam":"", "tso quav":"", "subsubregion":"", "lub nroog":"", "cheeb tsam":"", "txoj kev":"", "txoj kev_nr":"", "khoom_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "tsim":"2019-02-09 18:12:38", "kawg":"0000-00-00 00:00:00", "Txheej xwm":"", "neeg siv":"", "dhau":"", "imei":"351580051067110", "sn":"", "xwm txheej":"73000200000f360033026800240000002c002c002dffffffffffffbb63000001c1000001c2000000000000000009250a4f0a760a7a0a750a780a7e0000031d032205fc34029b025c025600460eb", "hash_code":"", "addr":"", "fwnr":"", "xiam oob qhab":"", "gsm_nr":"", "tus muag khoom":"", "sijhawm sijhawm":"", "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":"", "Txheej xwm":"", "out1":"0", "tawm2 lawm":"0", "out3":"0", "tawm4":"0", "out5":"0", "tawm 6":"0", "out7":"0", "out8":"0", "out9":"0", "out10":"1", "out11":"0", "out12":"0", "out13":"0", "out14":"0", "out15":"0", "out16":"0", "in1":"0", "nyob rau hauv2":"0", "in3":"0", "nyob rau hauv4":"0", "nyob rau hauv5":"0", "nyob hauv":"0", "in7":"0", "in8":"0", "in9":"0", "in10":"0", "in11":"0", "in12":"0", "in13":"0", "xyoo 1414":"0", "in15":"0", "in16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "anyob rau hauv5":"0", "ain6":"44", "ain7":"44", "ain8":"45", "sens1":"0", "hnov lawm2":"0", "hnov3":"0", "sens4":"0", "sens5":"0", "hnov6":"0", "hnov7":"0", "sens8":"0", "dimm1":"255", "dimm2":"255", "dimm3":"255", "dimm4":"255", "dimm5":"255", "dimm6":"255", "dimm7":"255", "dimm8":"255", "int1":"-16776767", "rau int2":"450", "int3":"", "int4":"", "int5":"", "int6":"0", "text1":"", "lus2":"", "ntawv nyeem3":"", "ntawv 4":"", "ntawv nyeem5":"", "text6":"" }]

12.3.2. Tau Cov Ntawv Keeb Kwm rau Cov Khoom Siv

Lus nug cov ntaub ntawv keeb kwm ntawm ib qho khoom siv los ntawm IMEI nr:

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

Vim tias tag nrho cov lus yuav muaj ntau lab kab nws yuav tsum txwv nrog WHERE clause kom tsis txhob ua hang-up server.

Cov nras ntxiv tsis muaj url:

func - imeijson

imei - IMEI ntawm kev ntaus ntawv

teb - liaj teb yuav tsum tau tshwm hauv cov txiaj ntsig (coma cais npe)

min - yam tsawg kawg nkaus tus nqi rau thawj daim teb los ntawm daim ntawv

max - tus nqi siab tshaj plaws rau thawj daim teb los ntawm daim ntawv

slossist - teb rau tsi

tm - teb yuav muab ntxiv rau qhov txheeb xyuas tau.

where - qhov twg clause rau limt cov ntaub ntawv

Piv txwv:

Peb xav kom tau txais txiaj ntsig tom qab

rau ntaus nrog imei=356345080018095

qhia liaj teb: ain5, ain6, gps_lat, gps_long

thiab txwv anyob rau hauv5 nyob rau hauv ntau yam ( 1, 10000 ) - yuav tsum sau thawj daim teb

thiab gps muaj cov ntaub ntawv siv tau (gps_fix = 3)

thiab hnub tim / sijhawm (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00

Tsim URL URL:

http: //%IP%/IoT/que.php? func =imeijson& imei =356345080018095& teb =anyob rau hauv5, ain6, gps_lat, gps_long& min =1& max =1000& qhov =gps_fix = 3 thiab tm> "2019-02-14 23:00:19" thiab tm <"2019-02-15 00:00:00"

Cov Lus Nug Txiaj Ntsig:

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

12.3.3. Tau txais cov npe ntawm cov khoom siv - ib daim teb los ntawm cov xwm txheej tam sim no nrog rau kev txwv

Txoj haujlwm no rov qab cov ntaub ntawv txwv ntawm "_ithings" lub rooj

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

Cov Txwv:

func - daim teb

teb - daim teb yuav tsum tau qhia hauv qhov txheeb xyuas tau - imei thiab tm yuav muab ntxiv

min - yam tsawg kawg nkaus tus nqi rau lub tshav pob

max - tus nqi siab tshaj plaws hauv daim teb

Rau cov lus nug saum toj no hlua nws rov ntsiab ntawm ain5, imei, tm liaj teb:

yog anyob rau hauv5 yog nyob rau hauv ntau (13,5000)

Cov Lus Nug Txiaj Ntsig:

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

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

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