@City IoT Kapua Paepae

iSys - Nā Pūnaehana ʻIoT. Nā Solutions

IoE.Systems

1. Hoʻolauna.

@City IoT hoʻolaʻa ʻia ʻo Cloud Platform "ʻāpua-uila" ʻōnaehana no kēlā me kēia mea kūʻai aku. ʻAʻole hiki ke mahele ʻia ka paepae a hoʻokahi wale nō mea kūʻai aku i loaʻa i ka pūnaewele a i ʻole kikowaena pūnaewele (VPS a i ʻole nā ​​kikowaena i hoʻolaʻa ʻia). Koho paha ka mea kūʻai aku i kekahi o nā kikowaena kikoʻī ma ʻEulopa a i ʻole i ka honua.

1.1 Nā ʻano hāmeʻa i kākoʻo ʻia.

Hoʻolaʻa ʻia ka paahana @City IoT i ka ukali ʻana i nā huahana iSys.PL

• IoT - RF / LoRaWAN (Pūnaewele o nā Mea)

• CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Pūnaewele Pūnaewele o nā Mea)

• WiFi

• Ethernet

1.2. Nā huahana i kākoʻo ʻia.

@City (eCity) Kapua IoT Paepae kahi ʻōnaehana nui like ʻole no nā huahana IP IoT (i kapa ʻia he @City Lako paʻa a i ʻole Nā hāmeʻa CioT ):

• @ Kulanakauhale

• @Kukui

• @Mikaolala

• @Kauai

• @AirQ

• @Bin

1.3. Nā leka uila kamaʻilio i kākoʻo ʻia

Kākoʻo ʻo @City IoT i nā kaʻina hana no ke kamaʻilio:

• UDP - manaʻo ʻia no ka CIoT sensors / manaʻo (ʻoiaʻiʻo NBIoT) - hoʻohana haʻahaʻa i ka ʻikepili

• TCPIP - manaʻo ʻia no nā hāmeʻa me ke kamaʻilio ʻelua - ka lūlū lima ʻana / hōʻoia

• HTTP - manaʻo wale ʻia no ka ʻike ʻikepili / nānā / hoʻokuʻu / "ʻōpua i ke ao"

• HTTP Webhooks - no ke kamaʻilio LoRaWAN ma waena o LoRaWAN Pūnaewele / Pūnaewele Noi a me @City Cloud.

Hoʻouna ʻia ka ʻikepili mai ka mea hoʻoponopono i ke kikowaena kapua a me ka versa i hoʻopā ʻia i kahi ʻano binary binary no ka nui o ka nui o ka ʻikepili a hoʻonui i ka palekana. Loaʻa i kēlā me kēia hoa i kāna kī hoʻopunipuni ʻokoʻa no ka ʻae ʻana i ka ʻikepili, ka hōʻoia ʻana o ka ʻikepili, a pēlā aku.

No nā pono ʻole eHouse / eCity hiki iā mākou ke hoʻolako i kēlā me kēia algorithms hoʻopunipuni ( "C" code code) no kēlā me kēia hoa no microprocessor e pale i ka ʻikepili ma mua o ke kamaʻilio ʻana.

I kēia hihia e paʻa paʻa loa ka ʻikepili i ka wā o ka kamaʻilio bidirectional ma luna o ka pāpāho kamaʻilio lehulehu (pūnaewele, Air, etc. ).

1.4. Kākoʻo ʻia ʻenehana ʻenehana o nā hāmeʻa

Kākoʻo ʻo @City IoT paepae:

• GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - hāmeʻa (kamaʻilio UDP / TCPIP)

• Nā polokalamu LoRaWAN (HTTP Webhooks) - ma o ka puka LoRaWAN a me LoRaWAN pūnaewele / kikowaena pūnaewele

• Ethernet Controllers (kamaʻilio UDP / TCP)

• Nā mea hoʻokele WiFi (kamaʻilio UDP / TCP)

• Nā huahana IP e hiki mai ana

• Nā huahana IP ʻole ma o kahi kūloko @ City / eHouse.PRO Puka Lako paʻa

@City IoT hoʻolaʻa ʻia ka anuu i nā hāmeʻa / node:

• Nā huahana iSys ʻōiwi:

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

  • (LoRaWAN)

  • WiFi - nā huahana i hoʻolaʻa ʻia no @City Platform

  • Ethernet - nā huahana i hoʻolaʻa ʻia no @City Platform

• Nā huahana Co-Production (hana ʻia e nā ʻaoʻao ʻekolu ma lalo o ka laikini iSys a me ka brand kūwaho)

• Nā huahana franchise (hana ʻia e nā ʻaoʻao ʻekolu ma lalo o ka laikini iSys me nā lepili iSys)

1.5. @City Kapua Pūnaewele

Hana ka polokalamu @City ma Linux ma muli o VPS (Virtual Private Server) a i ʻole Dedicated Server ma ka ʻaoʻao pūnaewele, e pili ana i ka noi i noi ʻia e ka. Kikowaena (i kapa ʻia ma hope Pūmau):

• komo pilikino / lehulehu

• helu pono ʻia nā hāmeʻa holoʻokoʻa

• IeAIIeXIAaIEN o nā hāmeʻa kūlana alapine (frequency)

• helu hōʻemi ʻikepili

Aia kekahi mau ʻano o VPS e kaukaʻi ʻia:

• Kumukūʻai

• geo-localization kikowaena-ʻikepili

• Nā pūnaewele unu lawelawe virtual (1-8)

• RAM hūnā (1-32GB)

• Diski disk (20GB-1TB)

Aia nā kekena o nā kikowaena hoʻolaʻa e like me:

• Kumukūʻai

• geo-localization kikowaena-ʻikepili

• Nā Puke Hana (4 .. 32)

• Hipa kāne (16 .. 512GB)

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

Hoʻolaʻa ʻia ka paahana @City to i hoʻokahi mea kūʻai aku:

• nā aupuni kūloko a me nā luna (City, Community, Country)

• B2B (no ka ʻaoʻao ʻekolu ona)

Ma muli o ka mahele ʻole ʻia o ka Server ma waena o nā mea kūʻai aku, maʻalahi ia i ke komo ʻana o ka palekana a me nā pilikia hana. Ma muli o kēia kumu wale nō ke kuleana o ka mea kūʻai aku no ka palekana kūpono, kūpaʻa, maikaʻi, ʻikeʻike data, etc. Inā lawa ʻole ka hana, hiki i ka mea kūʻai ke kūʻai aku i kahi hoʻolālā kiʻekiʻe (VPS a i ʻole Dedicated Server), ʻoi aku ka maikaʻi loa i nā hana i manaʻo ʻia a me ka hana.

I nā hihia kūikawā "Cloud to cloud" E hoʻokomo paha i ka kamaʻilio no ka globalisation a me ka centralization o ka ʻikepili i nā wahi nui aʻe ma kahi o ke ao lehulehu-mea kūʻai.

1.5.1. ʻO nā puka komo kikowaena a me nā kamaʻilio kamaʻilio

Hoʻomaopopo ʻia ke kamaʻilio o @City Server ma muli o ka noi pae haʻahaʻa no ka hoʻonui ʻana i ka hana.

ʻO nā hiʻohiʻona nui o ka noi ʻo @City Server:

• loaʻa ʻikepili ʻole mai nā hāmeʻa (ma o nā kaʻina hana: UDP, TCP IP, HTTP)

• hoʻoliʻiliʻi i ka hoʻohana ʻana i ka ʻikepili a me kāna mau koina ma waena o nā hāmeʻa a me Kapua (ma o ka hoʻohana ʻana i nā kuʻina kamaʻilio haʻahaʻa pae UDP, TCP IP)

• loaʻa ke kūlana hoʻopunipuni o nā hāmeʻa (ma o ka pāpāho kamaʻilio)

• ʻae a me ka hōʻoia ʻana i ka ʻikepili mai nā hāmeʻa ma o ka hoʻopau ʻana i kā lākou kūlana

• ke hoʻololi ʻana i ke kūlana a me ka hoʻohou ʻana i loko o nā papa ʻo MariaDB / MySQL (i ka hōkeo ʻikepili maka)

  • papa ʻaina o kēia manawa (loaʻa wale ke kūlana hou o kēlā me kēia meahana)

  • papa ʻaina mōʻaukala (loaʻa nā kūlana a pau no ka hāmeʻa hoʻokahi)

• e hoʻouna i nā kauoha e kali ana (Nā hanana) i nā hāmeʻa

• hōʻoia i ka hoʻolulima ʻana, ka hōʻoia ʻana a me ka hōʻoia ʻana

ʻO ka polokalamu ʻo @City Server like ia no kēlā me kēia mea hoʻohana a ʻaʻole hiki ke hoʻonohonoho ʻia no nā mea kūʻai aku ʻokoʻa.

1.5.2 hoʻohui HTTP LoRaWAN

Hoʻohui ʻia nā mea hoʻokele o LoRaWAN me ke ao @City ma o ka interface HTTP (webhooks) i loaʻa ma ka pūnaewele LoRaWAN / kikowaena pūnaewele.

Kākoʻo ʻia kekahi mau ʻano o ka kikowaena pūnaewele / noi:

TTN (manawa kaupalena "Ma ka lewa" a me ka nui o nā kauoha i hoʻouna ʻia i ka mea hoʻokele a ʻaʻole kākoʻo i ka hoʻomaikaʻi firmware)

LoraWAN-Stack (Koi pono i ka hoʻokipa ʻana ma kahi hāmeʻa kino me ka pūnaewele).

LoraServer.Io (Koi aku i ka hoʻokipa ʻana ma ka hāmeʻa pono me ka pūnaewele - e hoʻouna wale ana i ka ʻikepili i ka kikowaena a kākoʻo ʻole i ka hoʻomaikaʻi firmware)

Ua hoʻokaʻawale ʻia ka @City Cloud no nā loea LoRaWAN i ke ala like me nā mea ʻē aʻe. Kūkākūkā ʻia ma ka mokuna mua.

1.5.3. ʻO ke kikowaena mua

Hoʻomaopopo ʻia ka ʻaoʻao mua me nā script PHP no ka unuhi ʻana i ka ʻikepili i hoʻopilikino ʻia mai @City Cloud Database. Hoʻohana ia i kahi hana ʻimi loa, ma muli o nā nīnau SQL kumu e palena ai i ka ʻikepili i makemake ʻia. Hāʻawi ka ʻaoʻao i nā hualoaʻa ma ka palapala JSON no ka hoʻopau hou ʻana a me ka hana ʻana e ka "palapala noi" pūnaewele mua.

Kūlike ka pilina o mua i hope no kēlā me kēia mea hoʻohana a ʻaʻole hiki ke hoʻopili ʻia no nā mea kūʻai aku ʻokoʻa.

Hoʻokumu ʻia paha ka interface overlay e kā mākou limahana a i ʻole i ka hana pū ʻana e hōʻoia i ka pilikino no ka mea kūʻai aku.

1.5.3. Nā kuleana komo kikowaena

Loaʻa nā kuleana komo mea kūʻai aku (i ka Server pūnaewele).

Loaʻa i ka faila no ka papa kuhikuhi "template" wale nō (nā faila kikokiko maoli - .txt, .js, .css, .html):

• hoʻohui, hoʻohemo, hoʻololi i nā faila HTML maʻemaʻe (Front-End GUI / Hoʻolaha Interface)

• ke hoʻohui nei, ka hoʻoneʻe ʻana, ka hoʻololi ʻana i nā faila pure (Front-End GUI / Interface Development a me nā Algorithms)

• ke hoʻohui nei, ka hoʻoneʻe ʻana, ka hoʻololi ʻana i nā faile CSS maʻemaʻe (Ma mua-hopena - Manaʻo / ʻike kumumanaʻo)

• ke hoʻohui nei, ka hoʻoneʻe ʻana, ka hoʻololi ʻana i nā faila kikokikona o nā template (Front-End GUI)

• hoʻohui, hoʻohemo, hoʻololi i nā kapu, nā pōkole, nā loulou i nā hopena ʻikepili

Nā kuleana ʻē aʻe:

• Ke komo piha i ka @City Cloud Database MySQL / MariaDB kahi e waiho ai nā ʻikepili āpau

• Hoʻomaopopo ʻia ke komo ʻana i nā lawelawe Pūnaewele (palapala hōʻoia) no ka mea kūʻai aku.

• ʻAʻole ʻae ʻia ka mea kūʻai aku e hāʻawi i ka hōʻoia i nā ʻaoʻao ʻekolu (hiki i nā hopena he nui i ka hopena, kūpaʻa a palekana o ka ʻōnaehana holoʻokoʻa)

• Ma lalo o nā kūlana kūikawā a me ka hoʻohana ʻana o kahi kiʻekiʻe ʻo Dedicated Server, hoʻonohonoho ʻia paha ka waihona lehulehu e nānā i nā ʻike o kēia manawa (ʻaʻole ka mōʻaukala).

• Hiki i ka mea hoʻohana ke hoʻopili i ka ʻikepili i kāna kikowaena MySQL ponoʻī a hana i ka ʻikepili a me ka hana ponoʻ ʻana, i ʻole e hoʻopili i ka hana o @City Server.

iSys - Nā limahana o ka ʻōnaehana ʻikepili - loaʻa ʻole ka palena i ke kikowaena pūnaewele piha me ka moʻokāki a me ke komo ʻana DB piha no ka mālama ʻana.

Ma lalo o kekahi mau kumuwaiwai e hāʻawi paha ʻo iSys i nā kuleana i kaupalena ʻia i ka mea kūʻai mai (script PHP, nā faila) ma hope o ka nānā ʻana i nā code kumu, nā hoʻokolohua holo ʻana, inā ʻaʻole ia e hoʻopili i ka palekana ʻōnaehana holoʻokoʻa, paʻa a me ka hana.

1.6. Nā hāmeʻa akamai

1.6.1. CIoT - hāmeʻa GSM

Loaʻa i kā mākou hāmeʻa ka microcontroller a me ka module GSM / GPS / GNSS (2G..4G, NBIoT, CATM1) no ke kamaʻilio. Aia i loko o Microcontroller kahi bootloader encrypted no ka paʻa o ka firmware OTA paʻa. Hāʻawi kēia i ka hana ʻana i nā ʻano ʻōnaehana he nui e like me ka like "CIoT akamai hāmeʻa".

1.6.3. BAS, BMS, IoT - Nā hāmeʻa Ethernet a me Wifi

Hāʻawi ʻo Ethernet a me nā mea hoʻokele WiFi i ka kamaʻilio IP i ka ʻōnaehana (me ka ʻole o ka hoʻouka ʻana no ka hoʻoili ʻikepili i ka mea hoʻohana ʻo GSM). Ua hoʻopunipuni ʻia kēia mau hāmeʻa bootloader a e hoʻohou hou ʻia paha nā hāmeʻa ma o kāna kuʻina ʻōiwi. No WiFi aia iā OTA firmware upgrade mai ka kikowaena kikowaena

1.6.2. IoT - Nā polokalamu LoRaWAN

LoRaWAN hiki ai i ka lawe ʻana o ka ʻikepili ma kahi mamao loa (a hiki i ka approx. 15km). Aia kēia pae i ka wikiwiki o ka lawe ʻana o ka ʻikepili, ka nui o ka ʻikepili, ka noho kūlanakauhale ʻana o ka wahi a me ka maikaʻi o nā ala lekiō o nā hāmeʻa.

Hoʻopili kā mākou hāmeʻa i kahi microcontroller a me LoRaWAN module no ke kamaʻilio. Loaʻa i ka microcontroller kahi bootloader i hoʻopunipuni ʻia no ka hoʻohou polokalamu OTA paʻa. ʻAe kēia iā ʻoe e hana i nā ʻano ʻōnaehana he nui e like me ka like "IoT smart device". Hana nā hāmeʻa i ka bana hāmama ISM me ka ʻole o nā uku kau inoa. Pono e hoʻohana i nā LoRaWAN Gateways e uhi i ka wahi āpau me ke komo ʻana i ka Pūnaewele. I ke ʻano o nā puka LoRaWAN e kū nei ma loko o ka laulā o nā hāmeʻa (hoʻonohonoho ʻia no ka kikowaena TTN), hiki ke hoʻouna i ka ʻike ma o lākou nei. Pono ka hoʻonui Firmware i kahi kikowaena pūnaewele / noi LoRaWAN kikowaena a me kahi pae maikaʻi no ke kamaʻilio.

1.7. Nā koho ʻoihana i ka ʻoihana (B2B)

Nui a hewahewa nā koho no ka ʻoihana a me ke alu like.

• lawe mai / hoʻopuka i nā huahana mākaukau (switchboard, hāmeʻa) - nā huahana hope loa

• lawe mai / hoʻokuʻu aku i nā huahana OEM (PCB, nā mea hoʻokele, a me nā mea ʻē aʻe) - nā huahana waena, nā ʻāpana hoʻokoe

• franchise - ka hana e pili ana i kā mākou laikini no nā mākeke kūloko (hoʻolako mākou i nā microcontrollers i papahana wale ʻia) ma lalo o iSys - Nā Mana ʻEnehana Manaʻo.

• Co-Production - (e like me luna) akā ma lalo o nā mana kūwaho

2. @City IoT Paepae Hana

Kākoʻo ʻo @City paepae i kā template mua-hopena no ka ʻike ʻike, noi, ka palena ʻana a me ka hana ʻana (ʻIke / ʻikepili / moʻolelo):

• ʻike i nā ʻikepili i koho ʻia ma ka palapala ʻāina (geo-localization)

• hōʻike i nā ʻikepili i koho ʻia a me nā hopena i nā papa

• hōʻike i nā ʻikepili i koho ʻia i nā pakuhi pā

• hōʻike i nā ʻikepili i wae ʻia i nā pakuhi mōʻaukala

• lawe i ka ʻikepili i nā noi a ke kolu a me ka hana hou

• e hoʻohou hou ʻia nā hana ʻē aʻe ma nā noi pākahi.

Loaʻa ke alo o ka mea hoʻohana ma o IP kūpaʻa a i ʻole DNS redirection domain / subdomain / file inā loaʻa.

Hoʻonohonoho hiʻohiʻona & Demo (Hoʻohana ʻia ia no nā mea kūʻai aku e hiki mai ana).

E ʻoluʻolu e haʻi iā mākou ke makemake ʻoe e hoʻāʻo iā ia - e hiki ai i ka lehulehu ke komo i ka paepae.

Hiki iā ia ke koi aku iā IP kūpaʻa o ke kamepiula mamao e hiki ai i ke kamaʻilio i ka paepae @City.

3. ʻAoʻao Nui

Ua waiho hakahaka ʻia ka ʻaoʻao nui no nā kumu palekana. http: //% KouIP% / IoT /

E ʻae pākahi ʻia a hoʻoponopono ʻia a loaʻa nā loulou i nā lawelawe i loaʻa o @City IoT anuu inā koi ʻia

4. Pepa Nui

Manaʻo ʻia ka Form Main e hana i nā presets a me nā kapu hou: http: //%IP%/IoT/que.php

ʻO kēia kahi palapala mua no ka hoʻokumu ʻana i nā hopena, nā ʻike a me nā kapu no kēlā me kēia hoʻonohonoho ʻana

Nā wehewehe (Mai luna a me ka hema a me ka ʻaoʻao ʻākau)

4.1. Poʻomanaʻo

4.1.1. Loulou Home - (wehe i ka papa hopena hualoaʻa)

4.1.2. "X" pahu hōʻoia - wehe / pani i ka palapala noi

4.1.3. "V" pahu hōʻoia - wehe / pani i nā Pepa Kahua

4.1.4. Nā kiʻi kiʻi - nā loulou i nā hopena ʻike (hoʻoponopono ʻia)

4.2. Palapala:

4.2.1. "X" pahu hōʻoia - wehe / pani i ka palapala noi holoʻokoʻa

4.2.2. CSS - Koho i ke Kumuhana Visualization

Pono e hoʻololi i ka faila CSS Visualization Theme ma loko "template / css /" papa kuhikuhi - papa inoa ʻia.

4.2.3. Nā Kūʻai ʻIke pahu hōʻoia - hōʻike / hūnā i ka papa inoa kānana kahua

4.2.4. Kapu: Kapa inoa e hoʻohui a hemo paha

4.2.5. Hoʻohui / Wehe Nā Pihi - Hoʻohui a wehe i nā kapu me ka inoa i loko Tab kahua

4.2.6. Koho Kora Pihi

Koho i nā kahua nui i ʻike ʻia ma ka papa. ʻO ia hōʻano hou ʻia akomi.

4.2.7. Koho i nā mea āpau Pihi

Koho i nā kahua āpau (pono e ukali ʻia e ke koho ʻana ʻana i kekahi o lākou)

4.2.7. Koho All Pihi

Koho i nā kahua āpau (pono e ukali ʻia me ke koho ʻole ʻia i kekahi o lākou me ka lima)

4.2.8. Hūnā Kānana - Hūnā pepa holoʻokoʻa

Ua like kēia me ka pahu (X) āpau

4.2.9. Hooko Pihi - Hoʻololi i nā hoʻonohonoho hoʻonohonoho

4.2.10. "V" pahu kaha - hōʻike / kiʻekiʻe kahua kānana.

4.3. Nā Tabs

Hana ʻia nā kapu me nā inoa a me nā preset (mālama ʻia i loko cfg / tabs.cfg faile).

Aia ka faila i ka inoa a me ka URL (hoʻokaʻawale ʻia e tab char).

4.4. Papa Kuhikuhi

Hōʻike i nā kahua āpau i kaupalena ʻia e Field Filter.

Nā māla i ka papa:

4.4.1. Holo - ʻano hopena hopena

palapala ʻāina- nā hopena palapala ma ka palapala ʻāina (e koho ʻia kekahi a ʻoi paha kahua)

mōʻaukala - nā pakuhi mōʻaukala (koho ʻia hoʻokahi a ʻoi paha kahua)

tab - hōʻike i ka papaʻaina (koho ʻia nā hui āpau)

pā - hoʻokahi wale nō māla i hōʻike ʻia ma ka pakuhi pā

Ma ke kaomi ʻana i kekahi o kāna waiwai e wehe ia i nā hopena hou me nā kahua i wae ʻia (no ka lālani o kēia manawa).

4.4.2. Kope (+/- loulou)

Hoʻohui / hoʻoneʻe i kahi Tab me ka inoa i hoʻonohonoho ʻia Tab kahua. Hoʻohana wale ia i nā kahua i koho ʻia i ka lālani like o ka papa.

4.4.3. Nā Loulou Pūnaewele Papa

ʻO ka paʻi ʻana i kahi inoa kahua ʻē aʻe e hoʻomaka ai ka Visualization ʻIkepili o ke kahua i wae ʻia no ka lālani i wae ʻia.

4.5. Kauoha ʻikepili

ʻO ke kauoha o nā kahua i hōʻike ʻia e like me ke ʻano o kāna papa i nā ʻano māla (eia naʻe tm hoʻouna mau ke kahua i ka hopena o ka ʻōlelo). Hiki ke hoʻololi wale ʻia kēia kauoha me ka hoʻoponopono pololei ʻana o nā palena URL (ʻāpana ʻāpana papa).

4.6. Laʻana

ʻO kahi laʻana: Ke hoʻonohonoho nei i ka Tab me ʻImi Waiwai inoa a loaʻa ka palapala ʻāina me ka manawa a me ka wikiwiki ma ka palapala ʻāina

ʻO nā wehewehe āpau e pili ana i ka lālani kahi "Map" Kikokikona i "Holo" kolamu.

1. Hoʻokomo inoa "ʻImi Waiwai" i loko o Tab kahua (me ka ʻole o nā kaha puanaʻī)

2. E hōʻoia i ka wae ʻole ʻia o nā kolamu āpau i ka lālani

3. koho tm, gps_speed_km ma ka lālani wale nō

4. kaomi + pihi kahi ma ka lālani

5. Palapala ʻāina

Hiki ke hoʻokuʻu ʻia nā palapala ʻāina mai MainForm me ka hoʻonohonoho mua ʻana

5.1. Initialization Palapala ʻāina

Hana lima ʻia ka palapala hoʻomaka palapala ʻāina ke hana pololei ʻia me ka loulou: > http: //%IP%/IoT/maps.php

1. 
   Pono e hoʻohana ka mea hoʻohana i nā kahua āpau (Press Koho ʻole Pihi)

2. Kaomi aku i kahi pahu hōʻoia no nā kahua i hōʻike ʻia (e laʻa. Ain5 (no ka pae Smog) a tm (no ka lā ana / manawa ana)

3. kaomi "V" pahu hulina e hūnā i nā ʻano kahua

4. kaomi Hooko pihi e holo i ka nīnau DB a hōʻike i ka ʻike o kēia manawa mai nā mea ʻikepili a me nā hāmeʻa āpau

5. Hoʻohou ʻia ka palapala ʻāina me ka ʻikepili ma hope o 30 kekona a ʻoi.

5.2. Nā Koho Koho no ka nīnau

Ua wehewehe ʻia nā hoʻonohonoho ma ka hema a me ka ʻākau (ma luna o ka screenshot).

5.2.1. Hoʻololi i ka pālākiō MAP (Papa Kūʻai)

1. Hoʻololi ʻia paha ka pae hoʻonui me ka hoʻohana ʻana i nā pihi (+/-) no ka pālākiō (current_scale * 2 a i ʻole current_scale / 2 pakahi). Ke kaomi nei i kekahi o kēia mau pihi e hoʻololi wale i ka pālākiō.

2. Koho ʻia kekahi ala ʻē aʻe i ka pae Zoom Hoʻokokoke Kaha Combo Box a kaomi Hooko pihi. I kēia hihia ua hoʻouka hou a ʻike hou ʻia ka View / Map (kahi manawa i ka hoʻomaka ʻana).

5.2.2. IMEI (Koho i nā kahua hāmeʻa)

IMEIAia i ka māla ka hāmeʻa ID a i ʻole ʻokoʻa alias no kahi hāmeʻa. ʻO ka hoʻonohonoho paʻamau ʻo * (asterisk) e hōʻike nei i nā waiwai hou loa a me ka geolocation no kēlā me kēia hāmeʻa.

Ke hoʻonohonoho nei iā IMEI i kekahi waiwai ʻē aʻe, e hōʻike i ka ʻikepili mōʻaukala o ka hāmeʻa i koho ʻia. He ʻano wale nō ia no nā mīkini uila a neʻe, inā ʻaʻole e hoʻopili nā hualoaʻa ma ka palapala ʻāina i ke kūlana like.

5.2.3. Lon, Lat (Pālākiō, latitude coordinate kahua)

E hoʻonohonoho i ke kūlana waena o ka palapala ʻāina. Hoʻonohonoho ʻia kēia kahua i ke kūlana hōʻino ke kaomi ʻia ka pihi ʻiole ma ka palapala ʻāina.

5.2.4. Hoʻololi i ka MAP Style (Kumuhana)

Hiki ke koho ʻia ka kaila palapala / kumuhana mai Map Kaha ComboBox (e laʻa. ʻEleʻele, ʻeleʻele, Topographic).

Loaʻa paha i nā poʻomanaʻo palapala ʻāina like ʻole nā ​​pae hoʻoulu minimal like ʻole i mea e hoʻokū pono ai i ke Kumuhana e hoʻonui i ka pālākiō palapala ʻāina

5.2.5. Kahi Paukū

Kahi e hoʻohana ʻia ai ka paukū no ke aho hulina hou aku {KAI hapa ʻ}} no MySQL / MariaDB.

Lawe ʻia kēia paukū i ka moʻoʻī no ke kūkulu ʻana i ke aho QUERY piha no ka hopena pūnaewele. Palena paha ia i ka ʻikepili, ka manawa a me nā waiwai ʻē aʻe ma o ka kaupalena ʻana i nā helu o nā hopena. Pono e hoʻohana i nā inoa pākaukau papa (ʻaʻole alias) i kēia kahua. Eg.

1. gps_speed_km> 10 // ʻoi aku ka wikiwiki ma mua o 10km / h

2. ain5> 3 // ain5 ʻoi aku ma mua o 3 (e paʻa nei i nā helu ʻāpana 2.5um - pae smog)

3. gps_speed_km> 10 a me ain6> 5 // ʻoi aku ka wikiwiki ma mua o 10km / h a ʻoi aku ka nui o ain6 ma mua o 5 (e paʻa ana i nā helu ʻāpana 10um - pae smog)

5.2.6. Hooko (Holo i ka Pihi Ui)

Koi ʻia kēia pihi e hoʻololi i nā hoʻonohonoho, nā palena (koe naʻe kaomi ʻana +/- pihi).

Hoʻouka ʻia ka palapala ʻāina mai ka hoʻomaka me nā presets hou.

ʻAʻole hoʻoili ʻia ka palapala ʻāina, ke loaʻa ʻole kahi ʻikepili no ka hulina o kēia manawa.

5.2.7. Koho i nā mea āpau (Wehe i nā kahua āpau mai ka hulina)

Ma hope o ke kaomi ʻana i kēia pihi ma ka liʻiliʻi pono e koho lima ʻia kahi kahua e hōʻike i nā hopena ma ka palapala ʻāina.

5.2.8. "V" Pahu (Puka / Puka Papa Puka)

Hoʻohana ʻia kēia pahu hōʻoia e hōʻike / hūnā i nā mea koho o nā kahua e hōʻike.

5.2.9. "X" Pahu (Hōʻike / Hūnā Nīnau Ui)

Hiki i kēia pahu pahu ke hūnā i ka palapala holoʻokoʻa koe ( +/- pihi)

Hoʻomau mau ʻia nā hopena ma ka palapala ʻāina a hōʻano hou ʻia me nā waiwai hou

5.3. Laʻana

Nā hualoaʻa Eg Smog (Sensor i kau ʻia ma ke kaʻa): Nūhou pae ʻāpana 2.5um (Ain5), Wikiwiki (gps_speed_km), Lā / Manawa (tm), palapala ʻāina (2 - topographic), zoom pae 16,

Kahi paukū:

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

// GPS = kūpono nā hopena 3D & lā = 2019-02-18 & wikiwiki> 0 km / h

6. Hōʻike i nā hopena i ka Papa

Hōʻike i nā hopena i ka papa.

Ma "Pepa Nui" kaomi "pākaukau" ikamu, ma hope o ke koho ʻana i kekahi mau kahua e hōʻike ai i ka papa ʻaina i hoʻonohonoho mua ʻia

6.1. Initialization o ka papaʻaina

Ke wehe ʻia ka papa ʻaina mai ka loulou http: //%IP%/IoT/que.php? func = kapu pono ia i ka hoʻomaka mua ʻana o nā hoʻonohonoho.

Hiki iā ʻoe ke koho i nā kahua ʻike ʻia (ma ke kaomi ʻana "Nā Kaha ʻike" ) pahu kaha.

1. Kaomi i nā pahu hōʻoia a pau e pono ai no nā kahua i hōʻike ʻia

2. Pahu pahu paʻi "Nā Kaha ʻike" e hūnā i nā ʻano kahua

3. E kaomi i ka pihi hoʻokō e holo i ka noi a me ka papa hōʻike DB

6.2. Nā Koho Koho no ka nīnau

Hōʻike ʻia nā hoʻonohonoho mai hema a ʻākau (ma ka screenshot).

6.2.1. Hoʻokaʻina - hoʻokaʻina kahua a me ke kauoha e piʻi / iho ana i lalo

ʻO ke kahua hoʻokaʻina ʻokoʻa ia o ke poʻo o ke kolamu.

6.2.2. DB / IMEI - Koho hāmeʻa

IMEIAia i ka māla ka hāmeʻa ID a i ʻole ʻokoʻa alias no kahi hāmeʻa. Me ka waiwai ʻole e hōʻike ana i ka papaʻaina o nā waiwai hou loa.

Ke hoʻonohonoho nei iā IMEI i kekahi waiwai ʻē aʻe, e hōʻike i ka ʻikepili mōʻaukala o ka hāmeʻa i koho ʻia.

6.2.3. CSS - wae kaila (Kaha Kiʻiona)

6.2.4. Nā Kaha ʻike - Hōʻike / Hūnā i nā Pepa Kūʻai

6.2.5. Wehe i Empty - Mai hōʻike i nā kolamu hakahaka

6.2.6. "X" Pahu (Hōʻike / Hūnā Nīnau Ui)

6.2.7. Ma hea Paukū (no ka palena o ka ʻikepili)

ʻO kēia kahi hoʻopiʻi no MySQL / MariaDB string string hou {KAHI wahi}

Lawe ʻia kēia paukū i loko o ka moʻokāki e kūkulu i nā aho QUERY piha no ka hopena pūnaewele. Palena paha ia i ka ʻikepili, ka manawa a me nā waiwai ʻē aʻe ma o ka kaupalena ʻana i nā helu o nā hopena. Pono e hoʻohana i nā inoa pākaukau papa (ʻaʻole alias) i kēia kahua. Eg.

1. gps_speed_km> 10 // ʻoi aku ka wikiwiki ma mua o 10km / h

2. ain5> 3 // ain5 ʻoi aku ma mua o 3 (e paʻa nei i nā helu ʻāpana 2.5um - pae smog)

3. gps_speed_km> 10 a me ain6> 5 // ʻoi aku ka wikiwiki ma mua o 10km / h a ʻoi aku ka nui o ain6 ma mua o 5 (e paʻa ana i nā helu ʻāpana 10um - pae smog)

6.2.8. Koho Kora Pihi (Hoʻā i nā māla maʻamau)

6.2.9. Koho i nā mea āpau Pihi (Wehe i nā kahua āpau mai ka hulina)

Ma hope o ke kaomi ʻana i kēia pihi ma ka liʻiliʻi pono e koho lima ʻia kahi kahua e hōʻike i nā hopena ma ka palapala ʻāina.

6.2.10. Hooko (Holo i ka Pihi Ui)

Koi ʻia kēia pihi e hoʻololi i nā hoʻonohonoho, nā palena (koe naʻe kaomi ʻana +/- pihi).

Hoʻouka hou ʻia ka papa ʻaina mai ka hoʻomaka me nā presets hou.

6.2.11. "V" Pahu (Puka / Puka Papa Puka)

Hoʻohana ʻia kēia pahu hōʻoia e hōʻike / hūnā i nā mea koho o nā kahua e hōʻike.

Hoʻonohonoho ʻia nā hopena i ka papa ʻaina e like me Hoʻokaʻina kahua hoʻonohonoho. Hiki ke hoʻololi i ka ʻoka hoʻonohonoho ʻana ma ke kaomi ʻana i ka poʻo poʻo lālani (hoʻokahi no hoʻokahi ʻelua manawa no kahi ʻaoʻao ʻē aʻe).

Loulou kekahi mau hualoaʻa i nā kolamu i nā pale ʻike hou aʻe (kuhi paʻakikī).

Ke hōʻike nei i nā ʻike mōʻaukala no ka hāmeʻa pono e kaupalena ʻia i ʻole e hōʻike i ka ʻike holoʻokoʻa no ka mea hiki i ka hana a i ʻole nā ​​pilikia hoʻomanaʻo.

7. Nā Palapala Hoʻopaʻa.

Pono e hoʻokō ʻia nā pakuhi pā mai ka Main Form ma ke kaomi ʻana i hoʻokahi kahua i ka lālani "Bar".

Hōʻike ia i nā kī i hoʻonohonoho ʻia e hoʻonui ʻia i ka waiwai nui, e hōʻike ana mai ka papa kiʻekiʻe a haʻahaʻa.

He mea pono no ka hoʻokēʻai wikiwiki ʻana i nā hopena loa a hana i kekahi mau hana.

Hōʻike ka hanana ʻo Mouse Over i nā ʻike hou aku no ka hāmeʻa.

8. Nā Palapala Kahiki.

Hiki ke hoʻomaka ʻia nā palapala kiʻi mōʻaukala mai ka MainForm ke kaomi ʻana i ka kolamu i wae ʻia i ka lālani "Mōʻaukala" (no ka pā hoʻokahi).

No nā kahua he nui i ka lālani "Mōʻaukala" e pono ai nā pā i makemake ʻia e pono a kaomi ʻia ka loulou "Mōʻaukala" i ka kolamu "Holo".

Ua kaupalena ʻia nā hopena o ka mōʻaukala i nā hola he 24 + ma hope o 24 mau hola (no nā pakuhi hōʻoluʻolu hope loa), ke kau ʻole ʻia nā palena.

8.1. Initialization o nā pakuhi mōʻaukala

ʻO nā pakuhi mōʻaukala ke wehe ʻia mai ka loulou nui e koi i ka hoʻomaka ʻana e like me nā hopena ʻē aʻe, ke wehe ʻia mai ka loulou me ka ʻole o nā palena makemake.

Koho ʻia paha nā kahua he nui e hōʻike i nā mea like ʻole. Hiki iā ia ke hoʻonohonoho ʻia i ka Form Form Filter.

1. Kaomi i nā pahu hōʻoia a pau e pono ai no nā kahua i hōʻike ʻia

2. Pahu pahu paʻi "Nā Kaha ʻike" e hūnā i nā ʻano kahua

3. E kaomi i ka pihi hoʻokō e holo i ka nīnau a DB a hōʻike i ka pākaukau

8.2. Nā Koho Koho o nā Palapala Mōʻaukala

Hōʻike ʻia nā mea mai luna a mai hema a ʻākau (ma ka screenshot).

8.2.1. IMEI - (Koho i nā hāmeʻa e hōʻike i ka ʻike mōʻaukala)

IMEIAia i ka māla ka hāmeʻa ID a i ʻole ʻokoʻa alias no kahi hāmeʻa. Me ka waiwai (asterix) hōʻike ia i ka papaʻaina o nā waiwai hou loa i manaʻo ʻole.

Ke hoʻonohonoho nei iā IMEI i kekahi waiwai ʻē aʻe, e hōʻike i ka ʻikepili mōʻaukala o ka hāmeʻa i koho ʻia.

8.2.2. Min - palena palena iki o ke kahua mua

8.2.3. Max - palena i ka waiwai nui o ke kahua mua

8.2.4. "V" - Hōʻike / Hūnā i nā Pepa Kūʻai

8.2.5. Mai: hoʻonoho i ka lā / manawa liʻiliʻi (*)

8.2.6. Iā: hoʻonoho i ka lā / manawa nui loa (*)

8.2.7. "X" Pahu (Hōʻike / Hūnā Nīnau Ui)

8.2.8. "Ma hea" Paukū

Paukū no ka hōʻemi ʻana i nā hopena ʻikepili MySQL / MariaDB keu hulina noi {KAI hapa}.

Lawe ʻia kēia paukū i ka moʻoʻī no ke kūkulu ʻana i ke aho QUERY piha no ka hopena pūnaewele. Palena paha ia i ka ʻikepili, ka manawa a me nā waiwai ʻē aʻe ma o ka kaupalena ʻana i nā helu o nā hopena. Pono e hoʻohana i nā inoa kahua papa ʻaina (ʻaʻole alias) i kēia kahua a kūpono hoʻi i ka syntax SQL. Eg.

1. gps_speed_km> 10 // ʻoi aku ka wikiwiki ma mua o 10km / h

2. ain5> 3 // ain5 ʻoi aku ma mua o 3 (e paʻa nei i nā helu ʻāpana 2.5um - pae smog)

3. gps_speed_km> 10 a me ain6> 5 // ʻoi aku ka wikiwiki ma mua o 10km / h a ʻoi aku ka nui o ain6 ma mua o 5 (e paʻa ana i nā helu ʻāpana 10um - pae smog)

8.2.9. Koho i nā mea āpau Pihi (Wehe i nā kahua āpau mai ka hulina)

Ma hope o ke kaomi ʻana i kēia pihi ma ka liʻiliʻi pono e koho lima ʻia kahi kahua e hōʻike i nā hopena o ka mōʻaukala.

8.2.10. Hooko (Holo i ka Pihi Ui)

Koi ʻia kēia pihi e hoʻololi i nā hoʻonohonoho, nā palena (ʻokoʻa ka hōʻike ʻana i nā kahua a i ʻole ka nīnau nīnau). Hoʻouka hou ʻia ka papa ʻaina mai ka hoʻomaka me nā presets hou.

8.2.11. "V" Pahu (Puka / Puka Papa Puka)

Hoʻohana ʻia kēia pahu hōʻoia e hōʻike / hūnā i nā mea koho o nā kahua e hōʻike.

8.3. Pākaʻa ʻAno ʻē: (hōʻike i nā ʻike i loaʻa wale nō)

8.4. Hoʻomau ʻokoʻa (me ka ʻikepili like):

Hōʻike nā māka helu i nā helu o nā ana a me ka lā / manawa.

9. Hoʻohui pūnaewele pūnaewele

* - ʻAʻole kākoʻo ʻo Firefox i ka mea koho lā / manawa (pono e hoʻoponopono lima ʻia ka māna ʻatikala me ka hoʻohana ʻana i ka manawa manawa lā kūpono).

Kākoʻo ʻole ʻia ʻo Internet Explorer (hoʻohana Lihi ma kahi)

ʻAʻole i hoʻāʻo ʻia nā polokalamu kele pūnaewele ʻē aʻe.

10. Nā Poʻomanaʻo Hoʻopilikino

Hoʻokumu ʻia nā ʻaoʻao pūnaewele ma ka faila template maʻamau i aia ma "template" papa kuhikuhi "* .template".

Hoʻopili i kēlā me kēia ʻaoʻao ʻaoʻao i:

1. Waihona "* .head" i mālama ʻia ke poʻo o ka ʻaoʻao (nā loulou, lawe ʻia CSS, JavaScript Nā faila, a pēlā aku. )

2. Nā faila "* .foot" e mālama nei i nā paepae wāwae o ka ʻaoʻao (nā loulou, a pēlā aku. )

Hiki ke hoʻololi i ke kumumanaʻo Visualization e like me nā makemake o ka mea hoʻohana ma ke kāpae ʻana a me ka hoʻololi ʻana i nā faila CSS. Aia nā faile CSS ma "template / css" papa kuhikuhi. Hoʻohana ʻia paha nā ʻatikala ʻaoʻao pūnaewele e hana i hoʻomākaukau ʻia no eg. paʻi, SmartPhones, anakuhi PADs.

Table ʻike - i kahua koho no ke koho ʻana i ka faila CSS no ka hoʻololi piha ʻana i ke kumuhana (waiho ʻia i loko "template / css / kapu" papa kuhikuhi).

Map manaʻo - koho ʻia ke kumuhana laulā e "palapala ʻāina" pahu koka ʻano. Eia kekahi aia he paʻamau CSS faile "template / css / map.css" i loaʻa kekahi mau hana hou e like me ka hūnā ʻana / nā hopena kala ma muli o kāna waiwai. Hoʻomaha palena ʻia ke koena o kēia faila CSS i ka nīnau a me nā ʻano kahua.

ʻO ka hapa nui o @Kahua Paepae ʻAe nā faila PHP no ka ʻike kiʻi cssaiao me ka waiwai o ka inoa file no ka Theme (me ka hoʻolōʻihi ʻia). Pono e waiho i ka faile ma ka papa kuhikuhi "template / css" a pilikino ka inoa i ka hihia.

Aia kekahi mau mea o ka hōʻike Theme i ka faila JavaScript i loko "anakuhi / js" papa kuhikuhi.

Mea nui @ Kulanakauhale kōmi ʻōkuhi"@ Kulanakauhale.js" Aia ma ka papa kuhikuhi kiʻekiʻe. ʻAʻohe hiki ke hoʻololi i kēia wahi, akā kope ʻia paha i ka palapala "template / js" papa kuhikuhi a hoʻoponopono ʻia ma laila. Pono ka hoʻohana ʻana i kēlā me kēia palapala hōʻano i ka hoʻonui hou ʻana i nā faile pane.

11. Hōʻano Hou Algorithms

Pono paha kekahi mau mea ʻike kuʻuna e hoʻolaʻa i nā hana helu.

ʻAʻohe hiki ke hoʻohou a mālama i nā ʻano like ʻole o Polokalamu kikowaena pūnaewele @City, ʻO ke kikowaena PHP mua, ka mea e kumu i nā pilikia he nui, nā mana, nā hewa.

ʻO ke ala ʻoi loa a maʻalahi hoʻi e hoʻokō ai, ke hōʻano nei i nā faila JavaScript "uhi" no ka hōʻike kūpono o ka waiwai / wehewehe.

ʻO nā palapala JS kumu wehe i ka faila kikokiko a wehe ʻia paha i nā makemake o nā mea kūʻai aku. E like me ka mea i ʻōlelo ʻia ma ka mokuna mua e kope ʻia ai lākou "template / js" papa kuhikuhi kahi e loaʻa ai i nā mea kūʻai aku ke kuleana o ka hoʻololi.

ʻOihana loea ma ka hoʻolālā ʻana o @ Kulanakauhale ʻAʻole pili ka ʻōnaehana i kēia palapala, akā naʻe ʻo ka mea hoʻomohala pūnaewele me ka ʻike kumu o HTML a me JS paha e hoʻopilikino i ka polokalamu Pūnaewele Wahi Ma mua i kēlā me kēia pono o nā mea kūʻai aku.

12. Kūlana Hōʻikepili

@City Database me kahi inoa "IoT" a i ʻole "* IoT" mahele ʻia i nā pākaukau (kahi asterix ka pīpeka e pili ana i ka lawelawe kikowaena - inā koi ʻia). ʻIke ʻia paha ʻo DataBase ma PHPAdmin (polokalamu pūnaewele) ma ka loulou http: //% IP% / phpmyadmin

Nā Papa Hoʻonohonoho no kēlā me kēia hāmeʻa (kahi * ʻO {asterix} ka helu IMEI - kahi ʻano ʻokoʻa):

• "* _t" - nā hōʻailona no ka ʻae ʻana o nā mea hoʻohana i kēia manawa (ʻaʻole hoʻohana ʻia no nā kapua Kū hoʻokahi)

• "* _c" - kauoha (Hanana) lālani - e hoʻouna ʻia i ka hāmeʻa

• "*" - nā hopena kūlana decode āpau.

Nā papa ʻē aʻe:

• "aloha_" pākaukau - loaʻa ka decoded kūlana i kēia manawa o nā hāmeʻa āpau (kope kope ʻia i ka wā o ka hoʻohou ʻana i kekahi o "*" pākaukau). Kūlana o liuliuliu aneane like ka papa ʻaina me ka "*" papaʻaina. "aloha_" he mau kahua hou aʻe no ka helu wahi leka a me nā wehewehe ʻana.

• Kapu ʻia ka papa ʻaina "mea hoʻohana" a pono e hoʻololi ʻia.

12.1. "ithings_" a me "*" papahana papa

• "idx" - papa kuhikuhi

• "tm" - timestamp akomi

• "dt" - unix timestamp

• "imei" - kahi leka uila kūikawā

• "rssi" - RSSI pae hōʻailona

• "rsrp" - hōʻailona RSRP

• "hanana" - ke kali nei i nā hanana e hoʻouna ʻia i ka luna hoʻomalu

• "waho1" .. "waho16" - decoded outputs status

• "in1" .. "in16" - decoded hoʻokomo i ke kūlana

• "ain1" .. "ain8" - decoded nā helu ADC (RAW)

• "sens1" .. "sens8" - nā loiloi sensor i hoʻololi ʻia (pili i ka ʻano o nā hāmeʻa)

• "dimm1" .. "dimm8" - decoded dimmers mau waiwai (kaukaʻi ʻia i ka ʻano o nā hāmeʻa)

• "int1" .. "int6" - nā helu helu helu decoded (pili i ka ʻano o nā hāmeʻa)

• "text1" .. "text6" - decoded nā helu waiwai (kaukaʻi ʻia i ka ʻano o nā hāmeʻa)

• "hana" - ka lā hana / ka manawa hana

• "hope" - ka lā / manawa hope loa

• "mea hoʻohana" - hoʻohana i ka wā e hiki mai ana

• "pass" - hoʻohana i ka wā e hiki mai ana

• "sn" - gsm pūkaʻina nr

• "kūlana" - ʻaʻole i decoded ke kūlana o ka mea hoʻomalu i kēia manawa ma ka hōʻano hex

• "hash_code" - hoʻohana i ka wā e hiki mai ana

• "addr" - wahi leka uila pōkole

• "fwnr" - firmware nr

• "polokalamu kīnā" - polokalamu kīnā (ʻaʻole hoʻokō ʻia)

• "gsm_nr" - CIoT helu gsm

• "mea kūʻai aku" - code code (no ka franchise / hana pū ʻana)

• "timezone" - offset Wā Wā

• "dst" - E hoʻohana i nā hoʻonohonoho mālama mālama i kēlā me kēia lā

• "gps_lat" - Latitude GPS

• "gps_long" - GPS Longitude

• "gps_hdop" - GPS HDOP

• "gps_alt" - Kiʻekiʻena GPS

• "gps_fix" - Hoʻoponopono GPS (pono 3 - no nā hopena kūpono)

• "gps_cog" - GPS Cog

• "gps_speed_km" - GPS wikiwiki i [km / h]

• "gps_sat" - Ua loaʻa nā ukali GPS

• "ka ʻāina", "ʻāina", "ʻāina", "subregion", "subsubregion", "city", "district", "street", "street_nr", "item_nr" - Nā kahua kūʻai a me nā kahua wehewehe o ka mea kūʻai (!!!! ʻAʻole loaʻa no "*" nā papa mōʻaukala)

• "log" - ʻikepili ʻikepili
  
  He mea nui nā inoa o ke kahua no ka hana ʻana i nā nīnau SQL no ka hoʻonui ʻana i nā hana ʻimi no ka mea pono e hoʻohana ʻia ka inoa kumu i ka SQL Statement.
  
  

12.2. Palena kauoha (hanana) lālani "* _c" pākaukau - kūkulu

ʻO kēia pākaukau ka hanana hanana / kauoha no kēlā me kēia hāmeʻa a eia ke ʻano o kēia:

• "kauoha" - kauoha e hoʻouna a hoʻouna ʻia paha i ka luna hoʻomalu

• "ua hōʻoia" - hōʻoia hae inā ua hoʻouna ʻia a hōʻoia ʻia

• "lā" - unix timestamp o ka hanana

• "hōʻano" - hae hōʻano hou auto (lā / manawa timestamp)

12.3. Ke kiʻi ʻana i nā hopena mai ka ʻikepili - Mid-Level (Heluhelu Heluhelu ʻana)

Hiki ke kiʻi ʻia i ka ʻikepili me ka ʻole o ka pūnaewele Paʻa mua. Aia ka ʻōnaehana @City me ka hana me ka pae waena. Hoʻihoʻi ʻia nā hopena i ka format JSON.

12.3.1. E kiʻi i nā kūlana i kēia manawa o nā hāmeʻa āpau

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

Hoʻi holoʻokoʻa ka nīnau "_liili" pākaukau (nā kūlana o kēia manawa o nā hāmeʻa āpau) ma ka Hōʻoia JSON:

[{ "ʻāina":"", "kulanakauhale":"", "ʻĀinapuniʻole":"", "ʻāina":"", "ʻāpana":"", "subregion":"", "kauā kau":"", "kulanakauhale":"", "apana":"", "alanui":"", "alanui_nr":"", "item_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "hana":"2019-02-09 18:12:38", "hope":"0000-00-00 00:00:00", "hanana":"", "mea hoʻohana":"", "hooholo":"", "imei":"351580051067110", "sn":"", "kūlana":"73000200000f360033026800240000002c002c002dffffffffffffff5b63000001c1000001c2000000000000000009250a4f0a760a7a0a750a780a7e0000031d032205fc34029b025c025600460eb305320000", "hash_code":"", "addr":"", "fwnr":"", "kīnā":"", "gsm_nr":"", "mea kūʻai aku":"", "ʻāpana kau makahiki":"", "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":"", "hanana":"", "waho1":"0", "i waho2":"0", "i waho3":"0", "i waho4":"0", "waho5":"0", "i waho6":"0", "i waho7":"0", "i waho8":"0", "i waho9":"0", "i waho10":"1", "waho11":"0", "i waho12":"0", "i waho13":"0", "i waho14":"0", "i waho15":"0", "waho16":"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", "i loko o14":"0", "in15":"0", "in16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "ain5":"0", "ain6":"44", "ain7":"44", "ain8":"45", "sens1":"0", "ʻalā2":"0", "ʻāpana3":"0", "pāʻālua4":"0", "ʻalā5":"0", "sens6":"0", "ʻike7":"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", "text1":"", "kikokikona2":"", "kikokiko3":"", "kikokikona4":"", "kikokikona5":"", "text6":"" }]

12.3.2. E kiʻi i ka ʻikepili mōʻaukala no ka hāmeʻa

Nā ʻikepili mōʻaukala o ka manaʻo hoʻokahi e IMEI nr:

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

No ka mea i loko o ka papa ʻaina piha he mau miliona o nā lālani e kaupalena ʻia ia me WHERE paukū i ʻole e kau ʻia ka luna lawelawe.

Nā palena kikoʻī url kikoʻī:

ʻaʻā - imeijson

imei - IMEI o ka hāmeʻa

kahua - nā kahua e hōʻike ʻia i nā hualoaʻa (papa inoa hoʻokaʻawale ʻia ka koma)

min - Ka palena haʻahaʻa no ka māla mua mai ka papa inoa

max - ke kiʻekiʻena waiwai no ka māla mua mai ka papa inoa

sa i ʻolet - kahua no ke ʻano

tm - Pākuʻi ʻia ke kahua i nā hopena.

where - kahi e wehewehe ai i ka ʻikepili

Laʻana:

Makemake mākou e ukali i ka hopena

no ka hāmeʻa me imei=356345080018095

hōʻike kahua: ain5, ain6, gps_lat, gps_long

a palena ain5 i ka pae ( 1, 10000 ) - pono ke kahua mua i ka papa inoa

a gps he ʻikepili kūpono (gps_fix = 3)

a me ka lā / manawa (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00

Hana ʻia ke kaula URL:

http: //%IP%/IoT/que.php? func =imeijson& imei =356345080018095& kahua =ain5, ain6, gps_lat, gps_long& min =1& max =1000& ma hea =gps_fix = 3 and tm> "2019-02-14 23:00:19" a me tm <"2019-02-15 00:00:00"

Nā hopena nīnau:

[{ "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. E kiʻi i ka papa inoa o nā hāmeʻa - kahua hoʻokahi mai nā kūlana o kēia manawa me ka palena

Hōʻike kēia hana i ka palena o ka ʻikepili mai ka papa "_ithings"

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

Kiko'î:

ʻaʻā - fieldjson

kahua - kahua e hōʻike ʻia i nā hopena - imei a tm Hoʻohui 'akomi' ia

min - ka palena iki no ke kahua

max - ka waiwai nui no ke kahua

No ke aho nīnau ma luna e hoʻi nā hopena o ain5, imei, tm kahua:

inā ain5 aia i ka laulā (13,5000)

Nā hopena nīnau:

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