Platform IoT Cloud

iSys - Tsarin Hankali IoT Magani

IoE.Systems

1. Gabatarwa.

@City IoT Cloud Platform sadaukarwa ne "karamin girgije" tsarin don kowane abokin ciniki. Ba za a iya rarraba dandamali ba kuma abokin ciniki ɗaya ne kawai ke da damar yin amfani da sabar ta zahiri ko kama-da-wane (VPS ko sabobin sadaukarwa). Abokin ciniki na iya zaɓar ɗayan cibiyoyin bayanai da yawa a cikin Turai ko a duniya.

1.1 Nau'ikan kayan tallafi.

Dandalin @City IoT sadaukarwa ne don bin samfuran iSys.PL

• - RF / LoRaWAN (Intanet na Abubuwa)

• CIoT - GSM / 2G / 3G / 4G / CATM1 / NBIoT (Sel ɗin Intanet na Abubuwa)

• WiFi

• Ethernet

1.2. Nau'ukan samfuran tallafi.

@City (eCity) Cloud IoT Platform tsarin girma ne daban-daban don samfuran IP IoT (an kira su tare @Bayin Hardware ko Na'urorin CioT ):

• @Birnin

• @ Haske

• @Matarwa

• @Rariyajarida

• @AirQ

• @Bin

1.3. Goyan ladabi na sadarwa

Dandalin @City IoT yana goyan bayan bin ladabi don sadarwa:

• UDP - an ba da shawarar don na'urori masu auna sigina / na'urori (musamman NBIoT) - mafi ƙarancin amfani da bayanai

• TCPIP - an ba da shawara don na'urori tare da sadarwa ta hanyar biyun - musafiha / tabbatarwa

• HTTP - an ba da shawara ne kawai don samun damar bayanai / gani / fitarwa / "gajimare zuwa gajimare"

• HTTP Webhooks - don sadarwar LoRaWAN tsakanin LoRaWAN Network / Server Server da @City Cloud.

Ana aika bayanai daga mai sarrafawa zuwa sabar girgije kuma akasin haka ana rufaffen su cikin tsari mai kyau na binary don girman data mafi ƙaranci da haɓaka tsaro. Kowane abokin tarayya yana samun maɓallin ɓoyayyen sirri na musamman don izinin na'urar, binciken ingancin bayanai, da sauransu.

Don na'urorin eHouse / eCity wadanda ba zamu iya samar da algorithms na boye mutum ba ( "C" lambar tushe) don kowane abokin tarayya don microprocessor don kare bayanai kafin sadarwa.

A wannan yanayin bayanan suna da cikakken amintacce yayin sadarwa kai tsaye kan hanyoyin sadarwar jama'a (intanet, iska, da sauransu. ).

1.4. Tallafin Fasahar Sadarwa na Na'urorin

Dandalin @City supports na tallafawa:

• GSM: 2G, 3G, 4G (LTE), CATM1 (LTEM1), NBIoT - na'urori (sadarwar UDP / TCPIP)

• Kayan LoRaWAN (HTTP Webhooks) - ta ƙofar LoRaWAN da LoRaWAN cibiyar sadarwar / sabobin aikace-aikace

• Masu Gudanar da Ethernet (sadarwa UDP / TCP)

• Masu Kula da WiFi (sadarwa UDP / TCP)

• Kayan IP na gaba

• Samfurori marasa IP ta hanyar ƙarin @ City / eHouse.PRO Gateofar Kayan aiki

@City IoT Platform an sadaukar dashi ga na'urori / node:

• 'Yan ƙasar iSys kayayyakin:

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

  • IoT (LoRaWAN)

  • WiFi - samfuran sadaukarwa ga @City Platform

  • Ethernet - keɓaɓɓun samfuran don Platform Platform

• Samfurin Co-Production (wanda wasu kamfanoni suka ƙera a ƙarƙashin lasisin iSys da alama ta waje)

• Kayayyakin kamfani (wanda wasu kamfanoni suka ƙera a ƙarƙashin lasisin iSys tare da tambarin iSys)

1.5. @Bayanin Cloud Cloud

@City software tana aiki akan Linux mai tushen VPS (Virtual Private Server) ko Dedicated Server akan intanet, gwargwadon aikin da aka nema na Uwar garke (wanda ake kira daga baya Server):

• samun damar kai / jama'a

• sauran na'urorin suna ƙidaya

• sabunta matsayin matsayin na'urorin

• data sabunta kudi

Yawancin bambance-bambancen VPS sun wanzu dangane da:

• Farashi

• cibiyar-bayanan yanki-yanki

• Processorungiyoyin sarrafawa na Virtual (1-8)

• RAM mai kyau (1-32GB)

• SSD faifai (20GB-1TB)

Yawancin adadin sabar sadaukarwa ta wanzu dangane da:

• Farashi

• cibiyar-bayanan yanki-yanki

• Mai sarrafawa (4 .. 32)

• RAM (16 .. 512GB)

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

An sadaukar da dandalin @City to don abokin ciniki daya:

• ƙananan hukumomi da hukumomi (Birni, Al'umma, Countryasa)

• B2B (don mai shi na uku)

Saboda ba mai raba raba Server bane tsakanin kwastomomi, yana saukaka hanyoyin samun tsaro da al'amuran yi. Saboda wannan dalili ne kawai abokin ciniki ke da alhakin ingantaccen tsaro, kwanciyar hankali, inganci, ƙwarewar bayanai, da dai sauransu. Idan bai isa ba, abokin ciniki na iya siyan babban shiri (VPS ko Dedicated Server), ya fi dacewa da aiki da aikin da ake tsammani.

A cikin lamura na musamman "Cloud to cloud" ana iya aiwatar da sadarwa don dunƙulalliyar duniya da ƙaddamar da bayanai zuwa manyan yankuna maimakon girgije mai yawan ciniki.

1.5.1. Sabis da ƙofofin sadarwa

Sadarwa ta @City Server an samu ne bisa dogaro da aikace-aikacen matakin kasa don kara girman aiki.

Babban fasalulluka na @City Server aikace-aikace sune:

• asynchronously karɓar bayanai daga na'urori (ta hanyar ladabi: UDP, TCP IP, HTTP)

• rage girman amfani da bayanai da kuma tsadarsa tsakanin na'urori da Cloud (ta amfani da ladabi na hanyar sadarwa kaɗan UDP, TCP IP)

• karɓi halin ɓoyayyun na'urori (ta kowace hanyar sadarwa)

• ba da izini da kuma tabbatar da bayanai daga na'urori ta hanyar ɓata matsayinsu

• sauya yanayin na'urori da sabunta shi zuwa teburin MariaDB / MySQL kai tsaye (a cikin tsari mai kyau)

  • teburin data na yanzu (ya ƙunshi sabon yanayin kowane na'urori ne kawai)

  • tebur na bayanan tarihi (yana ƙunshe da dukkan matakan na'urar guda ɗaya)

• aika umarni masu jiran (Abubuwan) zuwa na'urori

• tabbatar da musafiha, tabbaci da tabbatarwa

@City Server software iri daya ne ga kowane mai amfani kuma baza'a iya keɓance shi ga kwastomomi daban-daban ba.

1.5.2 HTTP LoRaWAN hadewa

Masu haɗin LoRaWAN suna haɗe tare da girgije @City ta hanyar haɗin HTTP (webhooks) da ke kan layin sadarwar LoRaWAN / uwar garken aikace-aikace.

Yawancin nau'ikan cibiyar sadarwar / uwar garken aikace-aikace suna tallafawa:

TTN (iyakance lokaci "A Sama" kuma mafi yawan adadin umarnin da aka aika wa direba kuma baya goyan bayan haɓaka firmware)

LoraWAN-Stack (Yana buƙatar tallatawa akan na'urar ta jiki tare da damar intanet).

LoraServer.Io (Yana buƙatar tallatawa akan na'urar ta jiki tare da damar intanet - aika bayanai kawai zuwa sabar kuma baya goyan bayan haɓaka firmware)

An raba Cloud na @City Cloud don masu kula da LoRaWAN kamar yadda yake don sauran musaya. An tattauna a babin da ya gabata.

1.5.3. Gaban-ƙarshen dubawa

Gano gaba-ƙarshe yana tabbata tare da rubutun PHP don cire keɓaɓɓun bayanai daga @City Cloud Database. Yana amfani da tsarin bincike na roba, dangane da asalin tambayoyin SQL don iyakance bayanan da ake so. Interface yana samar da sakamakon tambaya a cikin tsarin JSON don ƙarin dikodi da sarrafawa ta hanyar "Aikace-aikacen" Gidan Yanar Gizon Gaba-gaba.

Asalin keɓaɓɓen ƙarshen-daidai ɗaya ne ga kowane mai amfani kuma ba za a iya keɓance shi don abokan ciniki daban-daban ba.

Staffila ma'aikatanmu za su iya ƙirƙirar keɓaɓɓen aiki ko kuma a cikin haɗin gwiwa don tabbatar da keɓancewa ga abokin ciniki.

1.5.3. Hakkokin samun dama ga saba

Hakkokin samun dama na Abokin Ciniki (zuwa Server ta zahiri) an iyakance.

Samun damar fayil don kundin tsari "kawai" (fayilolin rubutu na asali - .txt, .js, .css, .html):

• addingara, cirewa, gyaggyara fayilolin HTML masu tsayi (Gabatarwa na GI / Gabatarwa ta Farko)

• addingara, cirewa, gyara tsarkakakkun JavaScript fayiloli (Front-End GUI / Interface Development and Algorithms)

• addingara, cirewa, gyaggyara Fayilolin CSS masu tsabta (Gabatarwa - Gani / Jigogi na Musamman)

• addingara, cirewa, gyaggyara fayilolin rubutu na samfuran (Front-End GUI)

• ƙari, cirewa, gyaggyara shafuka, gajerun hanyoyi, hanyoyin haɗi zuwa sakamakon bayanai

Sauran Hakkokin Samun dama:

• Cikakken damar zuwa @City Cloud Database MySQL / MariaDB inda aka adana duk bayanan na'urorin

• Samun dama ga Ayyukan Yanar gizo an ayyana (takardun shaidarka) don abokin ciniki.

• Ba a ba da izinin abokin ciniki ya ba da takardun shaidarka ga wasu kamfanoni ba (samun dama mai yawa na sakamako na iya shafar aiki, kwanciyar hankali da tsaro na tsarin gaba ɗaya)

• A karkashin yanayi na musamman da kuma amfani da babban kwazo mai kwazo, ana iya saita asusun jama'a don kiyaye yawancin bayanai na yanzu (ba tarihi ba).

• Mai amfani na iya yin kwafin bayanai zuwa sabar MySQL na sa kuma yayi nasa bayanan nazari da sarrafa shi, don kar ya shafi aikin @City Server

iSys - Ma'aikatan Tsarin Lantarki - suna da cikakkiyar dama ga duk uwar garken ciki har da tushen asusun da cikakken damar DB don kiyayewa.

A karkashin wasu yanayi iSys na iya ba da ƙarin iyakoki na haƙƙoƙi ga abokin ciniki (rubutun PHP, fayiloli) bayan bincika lambar tushe, gwaje-gwaje masu gudana, idan hakan ba zai shafi cikakken tsarin tsaro, kwanciyar hankali da aiki ba.

1.6. Na'urorin Smart

1.6.1. CIoT - GSM na'urorin

Na'urorinmu sun ƙunshi microcontroller da GSM / GPS / GNSS module (2G..4G, NBIoT, CATM1) don sadarwa. Microcontroller ya ƙunshi ɓoyayyen bootloader don amintaccen haɓaka OTA firmware. Wannan yana ba da damar ƙirƙirar bambance-bambancen tsarin da yawa dangane da wannan "CIoT Smart na'urar".

1.6.3. BAS, BMS, IoT - Ethernet da na'urorin WiFi

Ethernet da masu kula da WiFi suna ba da izinin sadarwar IP ga tsarin (ba tare da caji ba don canja wurin bayanai zuwa mai ba da sabis na GSM). Wadannan na'urori sun kuma ɓoye bootloader kuma ana iya sabunta na'urori ta hanyar amfani da asalin ta. Don WiFi yana da haɓaka OTA firmware daga babban sabar

1.6.2. - Kayan aikin LoRaWAN

LoRaWAN yana ba da damar watsa bayanai akan tazara mai tsayi (har zuwa kusan. 15km) Wannan zangon ya dogara da saurin watsa bayanai, yawan bayanai, birni na yankin da ingancin hanyoyin rediyo na na'urorin.

Na'urorinmu sun hada da microcontroller da LoRaWAN module don sadarwa. Mai sarrafawa ya ƙunshi ɓoyayyen bootloader don amintaccen sabunta software na OTA. Wannan yana ba ku damar ƙirƙirar bambance-bambancen tsarin da yawa dangane da wannan "IoT smart device". Na'urorin suna aiki a cikin buɗaɗɗen buɗe ISM ba tare da ƙarin kuɗin biyan kuɗi ba. Wajibi ne ayi amfani da Kofofin LoRaWAN don rufe dukkan yankin tare da samun damar Intanet. Dangane da ƙofofin LoRaWAN da ke cikin kewayon na'urori (waɗanda aka saita don sabar TTN), yana yiwuwa a aika da bayanai ta hanyarsu. Upgradeaukaka aikin Firmware yana buƙatar cibiyar sadarwar / aikace-aikacen uwar garken LoRaWAN da kyakkyawan kewayon sadarwa.

1.7. Zaɓuɓɓuka don Kasuwanci (B2B)

Akwai zaɓuɓɓuka da yawa don kasuwanci da haɗin kai:

• shigo da / fitarwa kayayyakin da aka shirya (kayan sauyawa, na'urori) - samfuran ƙarshe

• shigo da / fitarwa kayan OEM (PCBs, masu sarrafawa, da sauransu) - samfuran matsakaici, kayan gyara

• ikon amfani da sunan kamfani - samarwa bisa lasisinmu na kasuwannin cikin gida (muna samar da microcontrollers ne kawai) a ƙarƙashin iSys - Masana'antun Masana'antu

• Haɗin Haɓakawa - (kamar yadda yake a sama) amma ƙarƙashin Brandasunan waje

2. @City IoT Yanayin Aiki

Tsarin dandalin @City yana tallafawa samfuri na Gaban-Karshe wanda za'a iya kera shi don ganin bayanai, tambaya, iyakancewa da kuma sarrafawa (bayanan yanzu / tarihin):

• duba bayanan da aka zaba akan taswirar (yanayin-yanki)

• yana nuna zababbun bayanai da sakamako a cikin tebur

• yana nuna zababbun bayanai a cikin jadawalin mashaya

• yana nuna zababbun bayanai a cikin jadawalin tarihi

• fitarwa bayanai zuwa aikace-aikacen ɓangare na uku da ci gaba da aiki

• sauran ayyuka za a sabunta kan buƙatun mutum.

-Arshen er'sarshen Mai amfani yana samun dama ta tsaye IP ko DNS rediyo yankin / ƙaramin yanki / fayil idan akwai.

Mahimmanci & Demo kafuwa (Ana kunna shi ne kawai ga masu son zuwa abokan ciniki).

Da fatan za a sanar da mu lokacin da kake son gwada shi - don ba da damar jama'a ga dandalin.

Zai iya buƙatar IP na tsaye na kwamfutar nesa don bawa damar sadarwa zuwa dandamalin @City.

3. Babban Shafi

Babban shafin an bar fanko da gangan saboda dalilai na tsaro: http: //% YourIP% / IoT /

Yana iya zama daban-daban kunna da edited da kuma dauke da links to duk samuwa ayyuka na Dandalin @City IoT idan ana buqata

4. Babban Fom

Main Form ana nufin ƙirƙirar sababbin saiti da shafuka: http: //%IP%/IoT/que.php

Wannan tsari ne na farko don ƙirƙirar sakamako, ra'ayoyi da shafuka don kowane tsari

Bayani (Daga sama zuwa hagu zuwa dama)

4.1. Header

4.1.1. Adireshin Gida - (Yana buɗe teburin sakamako na ainihi)

4.1.2. "X" akwati - ya buɗe / rufe Fom ɗin Tambaya

4.1.3. "V" akwati - ya buɗe / rufe Fom ɗin Filin

4.1.4. Gumakan gumaka - haɗi zuwa sakamakon gani (mai daidaitawa)

4.2. Form:

4.2.1. "X" akwati - yana buɗewa / rufe dukkanin Fom ɗin Tambaya

4.2.2. CSS - Zaɓi Jigogin gani

Gyara Gani da gani Jigo fayil ɗin CSS dole ne ya kasance a ciki "samfura / css /" kundin adireshi - an jera ta atomatik.

4.2.3.Wasannin da ake iya gani akwati - nuna / ɓoye Jerin Filin Filin Filin

4.2.4. Tab: Sunan Tab don ƙara ko cirewa

4.2.5. /Ara / Cire Buttons - Addara ko cire shafuka tare da suna a ciki Tab fili

4.2.6. Zaɓi Maɓalli Button

Zaɓi manyan filayen da ake gani akan tebur. Yana da an sabunta ta atomatik.

4.2.7. Kada a zabi Duk Button

Zaɓi duk fannoni (dole ne a bi su ta hanyar zaɓar wasu daga cikinsu da hannu)

4.2.7. Zaɓi Duk Button

Zaɓi dukkan fannoni (dole ne a bi su da zaɓin wasu daga cikinsu da hannu)

4.2.8. Boye Tace - ideoye dukkan Fom

Wannan yayi daidai da akwatin (X) duka

4.2.9. Kisa Button - Canja saitunan sigogi

4.2.10. "V" akwati - nuna / manyan filayen matattara.

4.3. Tabs

An kirkiro shafuka daban-daban tare da sunaye da saitattu (adana su a ciki cfg / tabs.cfg fayil).

Fayil ɗin a zahiri ya ƙunshi suna da URL (wanda aka raba shi da tab char).

4.4. Abinda ke Ciki

Nuna duk filayen da aka iyakance da Filter Filter.

Yankuna a tebur:

4.4.1. Gudu - sakamakon sakamakon

taswira- sakamakon zana taswira akan taswira (ana iya zaɓar ɗaya ko fiye da filin)

tarihi - zane-zane na tarihi (ana iya zaɓar ɗaya ko fiye da filin)

tab - yana nuna tebur (ana iya zaɓar kowane haɗin filayen)

mashaya - filin daya kawai aka nuna akan jadawalin mashaya

A kan danna ɗayan darajarta zai buɗe sabon sakamako tare da zaɓaɓɓun filaye (don jere na yanzu).

4.4.2. Kwafa (+/- hanyoyi)

Dingara / cire Tab tare da sunan da aka saita a ciki Tab fili Yana amfani da filayen da aka zaɓa a jere ɗaya na tebur.

4.4.3. Haɗin Layin Tebur

Latsa kowane sunan filin zai fara Ganin Bayanai na filin da aka zaɓa don jere da aka zaba.

4.5. Bayanin Bayanai

Umurnin filayen da aka nuna su ne tsarinta a cikin fannoni (duk da haka tm Ana aika filin koyaushe zuwa ƙarshen rubutu). Za'a iya canza wannan oda tare da gyara kai tsaye na sigogin URL (ɓangaren odar filaye).

4.6. Misali

Misali: Kafa Tab tare da Bibiyar kadari suna kuma ya ƙunshi taswira tare da lokaci da sauri akan taswirar

Duk bayanin da ake magana akan jere inda "Map" rubutu yana ciki "Gudu" shafi.

1. Shigar da suna "Bibiyar kadari" a cikin Tab filin (ba tare da alamun ambato ba)

2. Tabbatar cewa duk ginshiƙai ba'a zaɓa a jere ba

3. za .i tm, gs_speed_km kawai a jere

4. latsa + maballin inda a jere

5. Taswirori

Ana iya ƙaddamar da taswira daga MainForm tare da daidaitawa ta farko

5.1. Fara Taswira

Ana aiwatar da fara taswira da hannu yayin aiwatar da kai tsaye tare da hanyar haɗi: > http: //%IP%/IoT/maps.php

1. 
   Ya kamata Mai amfani ya zaɓi Duk filayen (Latsa Ba a zabi ba Button)

2. Latsa wasu akwati don filayen da aka nuna (misali. Ain5 (don matakin Smog) da tm (don kwanan wata / lokaci)

3. latsa "V" akwati don ɓoye filayen fili

4. latsa Kisa Maballin don gudanar da tambayar DB da nuna bayanan yanzu daga duk na'urori masu auna sigina / na'urori

5. Ana sabunta taswira tare da bayanai bayan daƙiƙa 30 ko fiye.

5.2. Saitunan Zaɓi don tambaya

Saitunan da aka bayyana daga hagu zuwa dama (akan sikirin da ke sama).

5.2.1. Gyara ma'aunin MAP (Matakan zuƙowa)

1. Za'a iya gyara matakin zuƙowa ta amfani da (+/-) maɓallan ma'auni (current_scale * 2 ko current_scale / 2 bi da bi). Latsa ɗayan maɓallin wannan zai gyara sikelin ta atomatik.

2. Wata hanyar kuma za selecti Matakan zuƙowa ciki Zuƙowa Combo Box filin kuma latsa Kisa maballin. A wannan yanayin gabaɗaya Duba / Taswira an sake loda shi kuma an sabunta shi (yana ɗaukar ɗan lokaci yayin farawa).

5.2.2. IMEI (Zaɓi Filin Na'ura)

IMEIfilin ya ƙunshi ID na musamman na musamman ko Musamman laƙabi don na'ura. Tsoffin saitin shine * (alama) wanda ke nuna ƙimomin kwanan nan da kuma yanayin ƙasa don kowane na'ura.

Kafa IMEI zuwa kowane ƙimar, zai nuna bayanan tarihi na zaɓaɓɓiyar na'urar. Yana da ma'ana kawai don wayoyin firikwensin motsi da motsi, in ba haka ba sakamakon zai zo kan taswira a wuri ɗaya.

5.2.3. Lon, Lat (Longitude, Latitude tsara filayen)

Sanya tsakiyar taswira. An saita wannan filin zuwa matsayin siginan kwamfuta lokacin da aka danna maɓallin linzamin kwamfuta akan taswirar.

5.2.4. Gyara MAP Salo (Jigo)

Ana iya zaɓar salon taswira / taken daga Map Filin ComboBox (misali. Duhu, Grey, Topographic).

Daban-daban taswirar taswira na iya samun matakan zuƙowa daban-daban don haka zai iya aiwatar da Jigon da ya dace don haɓaka sikelin ma'auni.

5.2.5. INA magana

Inda ake amfani da Magana don ƙarin zaren tambaya {INA bangare} don MySQL / MariaDB.

Ana amfani da wannan jimlar don gina cikakken kirtani na QUERY don sakamakon bayanan bayanai. Yana iya iyakance bayanai, lokaci da duk wasu ƙimomi ta iyakance sakamakon ƙidaya. Dole ne a yi amfani da sunayen filin tebur na asali (ba wanda aka ce masa ba) a cikin wannan filin. Misali.

1. gps_speed_km> 10 // gudun ya fi 10km / h

2. ain5> 3 // ain5 ya fi girma fiye da 3 (yana riƙe da ƙididdigar ƙirar 2.5um - matakin ƙara)

3. gps_speed_km> 10 da ain6> 5 // gudun ya fi 10km / h kuma ain6 ya fi 5 girma (rike 10um barbashi yana kidaya - matakin hayaki)

5.2.6. Kisa (Run Bututun Tambaya)

Ana buƙatar danna wannan maɓallin don canza kowane saituna, sigogi (banda latsawa +/- maballin)

An ɗora taswira daga farko tare da sabbin abubuwan saiti.

Taswira ba a ɗorawa kwata-kwata ba, lokacin da babu bayanai don tambayoyin yanzu.

5.2.7. Kada a zabi Duk (Cire dukkan filayen daga tambaya)

Bayan latsa wannan maɓallin aƙalla filin guda ɗaya dole ne a zaba shi da hannu don nuna sakamako a kan taswirar.

5.2.8. "V" Akwati (Buɗe / Rufe Filin Filin)

Ana amfani da wannan akwatin don nuna / ɓoye mai zaɓin filayen don nunawa.

5.2.9. "X" Akwati (Nuna / Formoye Fom na Tambaya)

Wannan akwatin yana ba da damar ɓoye duka Fom ban da ( +/- maballin)

Sakamako a kan taswirar ana ci gaba da wartsakarwa da sabunta su tare da sababbin ƙimomi

5.3. Misali

Sakamakon Smog Smog (Sensor da aka sanya a mota): Smog matakin 2.5um barbashi (Ain5), Speed ​​(gps_speed_km), Kwanan Wata / Lokaci (tm), taswira (2 - topographic), matakin zuƙowa 16,

Inda magana:

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

// GPS = sakamako mai inganci na 3D & kwanan wata = 2019-02-18 & saurin> 0 km / h

6. Nuna Sakamako a Tebur

Nuna sakamako a tebur.

Kunnawa "Babban Fom" latsa "tebur" abu, bayan zaɓar wasu filayen don nuna matakan da aka riga aka saita

6.1. Alizationaddamarwa na tebur

Lokacin da aka buɗe tebur daga mahada http: //%IP%/IoT/que.php? func = shafuka yana buƙatar fara farawa saituna.

Zaka iya zaɓar filayen da ake gani (ta latsawa "Field Field" ) akwati.

1. Latsa duk akwatin da ake buƙata don filayen da aka nuna

2. Latsa akwati "Field Field" don ɓoye filayen

3. Latsa maɓallin Kashe don gudanar da tambayar DB da teburin nuni

6.2. Saitunan Zaɓi don tambaya

An bayyana saituna daga hagu zuwa dama (akan sikirin).

6.2.1. Tsara - raba filin da oda zuwa hawa / saukowa

Yankin yanki yana daidai da layin rubutun shafi.

6.2.2. DB / IMEI - Zaɓi Na'ura

IMEIfilin ya ƙunshi ID na musamman na musamman ko Musamman laƙabi don na'ura. Tare da ƙima mara amfani yana nuna tebur na ƙimomin kwanan nan.

Kafa IMEI zuwa kowane ƙimar, zai nuna bayanan tarihi na zaɓaɓɓiyar na'urar.

6.2.3. CSS - Zaɓi salo (Theme na gani)

6.2.4. Field Field - Nuna / Boye Filayen Filaye

6.2.5. Cire fanko - Kada a nuna ginshiƙan wofi

6.2.6. "X" Akwati (Nuna / Formoye Fom na Tambaya)

6.2.7. Ina Magana - (don iyakance bayanai)

Wannan shine kari akan MySQL / MariaDB ƙarin tambarin tambaya {INA bangare}

Ana la'akari da wannan sashin don gina cikakken kirtani na QUERY don sakamakon bayanan bayanai. Yana iya iyakance bayanai, lokaci da duk wasu ƙimomi ta iyakance sakamakon ƙidaya. Dole ne a yi amfani da sunayen filin tebur na asali (ba wanda aka ce masa ba) a cikin wannan filin. Misali.

1. gps_speed_km> 10 // gudun ya fi 10km / h

2. ain5> 3 // ain5 ya fi girma fiye da 3 (yana riƙe da ƙididdigar ƙirar 2.5um - matakin ƙara)

3. gps_speed_km> 10 da ain6> 5 // gudun ya fi 10km / h kuma ain6 ya fi 5 girma (rike 10um barbashi yana kidaya - matakin hayaki)

6.2.8. Zaɓi Maɓalli Button (Kunna filayen da aka fi sani)

6.2.9. Kada a zabi Duk Button (Cire dukkan fannoni daga tambaya)

Bayan latsa wannan maɓallin aƙalla filin guda ɗaya dole ne a zaba shi da hannu don nuna sakamako a kan taswirar.

6.2.10. Kisa (Run Bututun Tambaya)

Ana buƙatar danna wannan maɓallin don canza kowane saituna, sigogi (banda latsawa +/- maballin)

An sake loda tebur daga farko tare da sabbin abubuwan saiti.

6.2.11. "V" Akwati (Buɗe / Rufe Filin Filin)

Ana amfani da wannan akwatin don nuna / ɓoye mai zaɓin filayen don nunawa.

Sakamako a cikin tebur ana jera su bisa ga Tsara saitin fili Za'a iya canza tsari ta hanyar latsa taken jere (sau ɗaya don shugabanci sau biyu don wani shugabanci).

Wasu sakamako a cikin ginshiƙai suna haɗi zuwa ƙarin fuskokin gani (mai lamba mai lamba).

Lokacin nuna bayanan tarihi don na'ura ya kamata a iyakance don kar a nuna cikakkun bayanai na tarihi saboda yana iya haifar da aiki ko daga matsalolin ƙwaƙwalwa.

7. Charts na Bar.

Yakamata a zartar da shingen shinge daga Babban Fayi ta latsa filin guda a jere "Bar".

Yana nuna sandunan da aka jera zuwa daidaitaccen darajar, yana nuna daga mafi girma zuwa mafi ƙarancin tsari.

Yana da amfani don bincika sakamako mai sauri da ɗaukar wasu matakai.

Mouse Over taron zai nuna ƙarin bayani don na'urar.

8. Charts na Tarihi.

Za'a iya farawa da jadawalin tarihi daga MainForm yayin danna layin da aka zaɓa a layin "Tarihi" (don filin guda ɗaya).

Don filaye da yawa a layin "Tarihi" dole ne a bincika filayen da ake so kuma dole ne a latsa mahaɗin "Tarihi" a cikin layin "Run".

Sakamakon tarihi ya iyakance zuwa awanni 24 na ƙarshe + awanni 24 masu zuwa (don jadawalin shakatawa masu zuwa), lokacin da ba'a kafa iyaka ba.

8.1. Alizationaddamar da jadawalin Tarihi

Charts na tarihi lokacin buɗewa daga babban hanyar haɗi suna buƙatar farawa kamar sauran sakamako, lokacin buɗewa daga haɗin haɗi ba tare da sigogin abubuwan da aka zaɓa ba.

Za'a iya zaɓar filaye da yawa don nuna abubuwa da yawa. Hakanan za'a iya saita shi a cikin Filter Filter Filter.

1. Latsa duk akwatin da ake buƙata don filayen da aka nuna

2. Latsa akwati "Field Field" don ɓoye filayen

3. Latsa maɓallin Kashe don gudanar da tambayar DB kuma nuna tebur

8.2. Saitunan Zabi na Charts na Tarihi

Abubuwan da aka bayyana daga sama da hagu zuwa dama (akan sikirin).

8.2.1. IMEI - (Zaɓi Na'ura don nuna bayanan tarihi)

IMEIfilin ya ƙunshi ID na musamman na musamman ko Musamman laƙabi don na'ura. Tare da ƙimar * (asterix) yana nuna tebur na ƙimomin kwanan nan wanda bashi da ma'ana.

Kafa IMEI zuwa kowane ƙimar, zai nuna bayanan tarihi na zaɓaɓɓiyar na'urar.

8.2.2. Min - iyakance ƙimar ƙimar filin farko

8.2.3. Max - iyakance iyakar ƙimar filin farko

8.2.4. "V" - Nuna / Boye Filayen Filaye

8.2.5. Daga: saita kwanan wata / lokaci (*)

8.2.6. Zuwa: saita mafi kwanan wata kwanan wata / lokaci (*)

8.2.7. "X" Akwati (Nuna / Formoye Fom na Tambaya)

8.2.8. "Ina" Magana -

Jumla don iyakance sakamakon bayanai MySQL / MariaDB ƙarin kirtani tambaya {INA bangare}.

Ana amfani da wannan jimlar don gina cikakken kirtani na QUERY don sakamakon bayanan bayanai. Yana iya iyakance bayanai, lokaci da duk wasu ƙimomi ta iyakance sakamakon ƙidaya. Dole ne a yi amfani da sunayen filin tebur na asali (ba wanda aka ce masa ba) a cikin wannan filin kuma ingantaccen haɗin ginin SQL. Misali.

1. gps_speed_km> 10 // gudun ya fi 10km / h

2. ain5> 3 // ain5 ya fi girma fiye da 3 (yana riƙe da ƙididdigar ƙirar 2.5um - matakin ƙara)

3. gps_speed_km> 10 da ain6> 5 // gudun ya fi 10km / h kuma ain6 ya fi 5 girma (rike 10um barbashi yana kidaya - matakin hayaki)

8.2.9. Kada a zabi Duk Button (Cire dukkan fannoni daga tambaya)

Bayan latsa wannan maɓallin aƙalla filin guda ɗaya dole ne a zaɓi shi da hannu don nuna sakamakon tarihi.

8.2.10. Kisa (Run Bututun Tambaya)

Ana buƙatar danna wannan maɓallin don canza kowane saituna, sigogi (banda nuna filaye ko rukunin tambaya). An sake loda tebur daga farko tare da sabbin abubuwan saiti.

8.2.11. "V" Akwati (Buɗe / Rufe Filin Filin)

Ana amfani da wannan akwatin don nuna / ɓoye mai zaɓin filayen don nunawa.

8.3. Sanduna Bambance-bambancen: (ana nuna kawai bayanan da ke akwai)

8.4. Cigaba bambance-bambancen (tare da wannan bayanan):

Valuesimar nuni na Mouse na ma'auni da kwanan wata / lokaci.

9. Karfin gidan yanar gizo

* - Firefox baya goyan bayan kwanan wata / lokaci mai zaba (filin rubutu dole ne a gyara shi da hannu ta hanyar amfani da tsarin kwanan wata).

Internet Explorer ba ta da tallafi (amfani Edge maimakon)

Ba a gwada sauran masu binciken yanar gizo ba.

10. Jigogi gyare-gyare

Shafukan yanar gizon suna dogara ne akan babban fayil ɗin samfuri wanda yake a "Shaci" kundin adireshi "*. samfuri".

Bugu da ƙari kowane nau'in shafi yana ƙunshe da:

1. Fayil din "* .head" wanda yake adana taken shafin (hanyoyin, CSS da aka shigo dasu, JavaScript Fayiloli, da sauransu. )

2. "* .foot" fayilolin da ke adana ƙafafun shafin (hanyoyin haɗi, da sauransu) )

Za'a iya canza Jigo na gani bisa ga fifikon mai amfani ta hanyar jurewa da gyaran fayilolin CSS. Fayilolin CSS suna cikin "samfura / css" kundin adireshi. Za'a iya amfani da Jigogi Shafukan Yanar Gizon Daban-daban don ƙirƙirar ingantattu misali. bugu, SmartPhones, PADs samfura.

Table ra'ayoyi - sami filin zaɓaɓɓe don zaɓar fayil ɗin CSS don cikakken gyaran jigo (adana shi a ciki "samfura / css / shafuka" kundin adireshi).

Map ra'ayoyi - janar janar an zaɓi ta "taswira" buga akwatin haduwa. Bugu da ƙari akwai tsoho fayil CSS "samfura / css / map.css" wanda ya ƙunshi wasu ƙarin ayyuka kamar ɓoye / canza launi sakamakon ƙimar sa. Sauran wannan fayil ɗin CSS kusan ana iyakance ga tambaya da fom ɗin filin.

Mafi yawan Dandalin @Bayi PHP fayiloli don gani gani karɓa csssiga tare da darajar sunan fayil don Jigo (ba tare da tsawo ba). Dole ne fayil ya kasance a cikin "shaci / css" kuma sunan yana da matsala.

Wasu abubuwa na Jigo nuni yana tsaye kai tsaye a cikin JavaScript fayil dake cikin "samfuri / js" kundin adireshi.

Babban @Birnin rubutun"@ Yasmin07" yana cikin babban kundin adireshi. Babu yiwuwar gyara a cikin wannan wuri, duk da haka ana iya yin kwafin rubutun zuwa "samfura / js" kundin adireshi kuma an gyara shi a can. Amfani da rubutun mutum yana buƙatar ɗaukaka duk fayilolin kanun labarai.

11. Algorithms Sabuntawa

Wasu na'urori masu auna firikwensin na musamman na iya buƙatar sadaukar da ayyukan lissafi.

Babu yiwuwar sabuntawa da kiyaye nau'ikan bambance bambancen na @Serftar Sabar Komputa, Matsayi na ƙarshe na PHP, wanda zai haifar da matsaloli da yawa, juzu'i, kurakurai.

Hanya mafi kyawu kuma mafi sauƙi don cimma hakan, shine sabunta fayilolin "overlay" don nuna ƙimar darajar / kwatancen.

Asalin rubutun JS na asali buɗaɗɗen fayil ne kuma ana iya ɗaukarsu ga bukatun abokin ciniki. Kamar yadda aka fada a babin da ya gabata dole a kwafa su "samfura / js" Littafin adireshi inda abokin ciniki ke da haƙƙoƙin samun dama don gyara.

Fasaha fasaha a kan shirye-shirye na @Birnin tsarin ba batun wannan daftarin aiki bane, duk da haka mai haɓaka Yanar gizo tare da masaniyar HTML da JS na iya tsara aikace-aikacen Gidan yanar gizo na Gabatarwa ga bukatun abokin ciniki.

12. Tsarin Bayanan Bayanai

@ Database na gari tare da suna "IoT" ko "* KYAUTA" an raba shi a cikin tebur (inda asterix prefix ya dogara da uwar garken talla - idan an buƙata). Ana iya lura da Bayanai a cikin PHPAdmin (aikace-aikacen yanar gizo) a mahaɗin http: //% IP% / phpmyadmin

Tables ga kowane Na'ura (ina * {asterix} adireshin IMEI ne - ID na musamman):

• "* _t" - alamomi don ba da izini ga masu amfani na yanzu (ba a amfani da su don giza-gizan Abokin Ciniki guda ɗaya)

• "* _c" - umarni (Abubuwan) layin - don aikawa zuwa na'urar

• "*" - duk sakamakon halin dikodi.

Sauran tebur:

• "yan_saber_" tebur - ya ƙunshi halin dikodod na yanzu na na'urori duka (an kwafe shi yayin ɗaukaka kowane ɗayan "*" tebur). Tsarin syeda_hussain tebur kusan iri daya ne da "*" tebur. "yan_saber_" suna da ƙarin fannoni don Adireshin gidan waya da kwatancin.

• Tebur "masu amfani" an iyakance shi kuma ya kamata a canza shi.

12.1. Tsarin tebur "ithings_" da "*"

• "idx" - fihirisa

• "tm" - atomatik timestamp

• "dt" - cire unix timestamp

• "imei" - adireshin na'urar na musamman

• "rssi" - matakin siginar RSSI

• "rsrp" - siginar RSRP

• "abubuwan da suka faru" - jiran abubuwan da za a aika zuwa mai sarrafawa

• "fita1" .. "fita16" - ƙayyadaddun kayan haɓakawa halin aiki

• "cikin 1" .. "cikin16" - yanayin shigar da kayan masarufi

• "ain1" .. "ain8" - ƙididdigar ADC dabi'u (RAW)

• "azan1" .. "azan8" - dabi'un firikwensin da aka canza (ya dogara da nau'in na'urar)

• "dimm1" .. "dimm8" - ƙididdigar ƙimar dimmers (ya dogara da nau'in na'urar)

• "int1" .. "int6" - ƙididdigar ƙididdigar ƙididdiga (ya dogara da nau'in na'urar)

• "rubutu1" .. "rubutu6" - ƙaddara matakan rubutu (ya dogara da nau'in na'urar)

• "halitta" - kwanan wata / lokaci

• "na karshe" - kwanan wata / lokaci na ƙarshe

• "mai amfani" - amfani nan gaba

• "wucewa" - amfani da gaba

• "sn" - gsm serial nr

• "matsayi" - Halin mai sarrafawa na yanzu wanda ba'a ƙaddara shi ba

• "hash_code" - amfani nan gaba

• "addr" - gajeren adireshin na'urar

• "fwnr" - firmware nr

• "naƙasasshe" - na'urar da aka kashe (ba a yi ba)

• "gsm_nr" - lambar gsm CIoT

• "mai siyarwa" - lambar mai siyarwa (don kamfani / haɗin gwiwa)

• "yankin lokaci" - Zoneaddamar da Yankin Lokaci

• "dst" - Yi amfani da saitunan tanadi na yau da kullun

• "gps_lat" - Latitude GPS

• "gps_long" - Longitude GPS

• "gps_hdop" - GPS HDOP

• "gps_alt" - Tsawan GPS

• "gps_fix" - Gyara GPS (dole ne ya zama 3 - don sakamako mai inganci)

• "gps_cog" - GPS Cog

• "gs_speed_km" - Gudun GPS a cikin [km / h]

• "gps_sat" - An samo tauraron dan adam na GPS

• "nahiyar", "kasa", "yanki", "yanki", "sububregion", "birni", "gundumar", "titi", "street_nr", "item_nr" - Adireshin abokin ciniki da filayen kwatanci (!!!! Babu ga "*" teburin tarihi)

• "log" - bayanan shiga
  
  Sunayen filayen suna da mahimmanci don ƙirƙirar tambayoyin SQL don haɓaka ayyukan bincike saboda dole ne a yi amfani da suna na asali a cikin Bayanin SQL.
  
  

12.2. Umurnin na'urori (Abubuwan da suka faru) jerin gwano "* _c" tebur - tsari

Wannan teburin jerin layuka ne / umarni ga kowane na'ura kuma suna da tsari mai zuwa:

• "umarni" - umarni don aikawa ko riga an aika shi zuwa ga mai sarrafawa

• "an tabbatar" - tutar tabbatarwa idan an riga an aika kuma an tabbatar da ita

• "kwanan wata" - unix timestamp na taron

• "sabunta" - tutar sabuntawa ta atomatik (kwanan lokaci / lokaci)

12.3. Samun sakamako daga ɗakunan bayanai - Matsakaicin Matsakaici (Bayanai na Karatu)

Bayanai zasu iya zama ba tare da aikace-aikacen Gidan yanar gizo na Front-end ba. Tsarin @City yana dauke da rubutu tare da matsakaiciyar ayyuka. An dawo da sakamako a tsarin JSON.

12.3.1. Sami halin yanzu na dukkan na'urori

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

Tambaya ta dawo gaba ɗaya "_wannan" tebur (halin yanzu na dukkan na'urori) a Tsarin JSON:

[{ "ƙasa":"", "birni":"", "nahiyar":"", "ƙasa":"", "yanki":"", "subregion":"", "yanki":"", "birni":"", "gundumar":"", "titi":"", "titin_nr":"", "abu_nr":"", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "tm":"2019-02-10 12:56:23", "halitta":"2019-02-09 18:12:38", "na karshe":"0000-00-00 00:00:00", "abubuwan da suka faru":"", "mai amfani":"", "wuce":"", "imei":"351580051067110", "sn":"", "matsayi":"73000200000f36003303088240000002c002c002dffffffffffffff5b63000001c1000001c20000000000000009250a4f0a760a7a0a750a780a7e0000031d032205fc34029b025c025600460", "lambar hash_code":"", "addr":"", "rana":"", "naƙasassu":"", "gsm_nr":"", "mai siyarwa":"", "lokaci":"", "dst":"", "rssi":"91", "rsrp":"99", "gps_lat":"0000.0000N", "gps_long":"00000.0000E", "gps_hdop":"", "gps_alt":"", "gps_fix":"4", "gps_cog":"", "gs_speed_km":"", "gps_sat":"", "abubuwan da suka faru":"", "fita1":"0", "fita2":"0", "fita3":"0", "fita4":"0", "fita5":"0", "fita6":"0", "fita7":"0", "fita8":"0", "fita9":"0", "fita10":"1", "out11":"0", "fita12":"0", "fita 13":"0", "fita14":"0", "fita15":"0", "fita16":"0", "cikin 1":"0", "cikin 2":"0", "cikin 3":"0", "a cikin 4":"0", "cikin 5":"0", "cikin 6":"0", "cikin 7":"0", "cikin 8":"0", "cikin9":"0", "cikin 10":"0", "in11":"0", "cikin 12":"0", "cikin 13":"0", "cikin 14":"0", "cikin 15":"0", "cikin16":"0", "ain1":"3894", "ain2":"51", "ain3":"616", "ain4":"36", "acikin 5":"0", "ain6":"44", "ain7":"44", "ain8":"45", "azan1":"0", "azanci2":"0", "azanci3":"0", "azanci4":"0", "azanci5":"0", "azanci6":"0", "azanci7":"0", "azan8":"0", "dimm1":"255", "dimm2":"255", "dim3":"255", "dimm4":"255", "dimm5":"255", "dim6":"255", "m7":"255", "dimm8":"255", "int1":"-16776767", "int2":"450", "int3":"", "int4":"", "int5":"", "int6":"0", "rubutu1":"", "rubutu2":"", "rubutu3":"", "rubutu4":"", "rubutu5":"", "rubutu6":"" }]

12.3.2. Samu bayanan Tarihi don Na'urar

Neman bayanan tarihin na'urar daya ta IMEI nr:

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

Saboda duka tebur na iya ƙunsar miliyoyin layuka ya kamata a iyakance shi da INA sashi don kar a rataya sabar.

Parametersarin sigogi ur sigogi:

func - imeijson

imei - IMEI na na'urar

fili - filayen da za a nuna a cikin sakamakon (jerin raba coma)

min - mafi ƙarancin darajar filin farko daga jerin

max - matsakaicin darajar filin farko daga jerin

skot - filin don iri

tm - an kara filin ta atomatik zuwa sakamakon.

where - inda magana zuwa lalata bayanai

Misali:

Muna son samun sakamako mai zuwa

ga na'ura tare da imei=356345080018095

nuna filaye: ain5, ain6, gps_lat, gps_long

kuma iyaka acikin 5 a cikin kewayon ( 1, 10000 ) - dole ne ya zama filin farko a jerin

kuma gps da ingantattun bayanai (gps_fix = 3)

da kwanan wata / lokaci (tm) from2019-02-14 23:00:19 to 2019-02-15 00:00:00

Kirkirar URL ɗin da aka gina:

http: //%IP%/IoT/que.php? func =imeijson& imei =356345080018095& filin =acikin 5, ain6, gps_lat, gps_long& min =1& max =1000& ina =gps_fix = 3 da tm> "2019-02-14 23:00:19" da tm <"2019-02-15 00:00:00"

Sakamakon Tambaya:

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

12.3.3. Samo jerin na'urori - yanki guda ɗaya daga ƙa'idodin halin yanzu tare da iyakancewa

Wannan aikin yana dawo da iyakantattun bayanai daga tebur "_ithings"

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

Sigogi:

func - filin

fili - filin da za a nuna a cikin sakamakon - imei kuma tm ana kara ta atomatik

min - mafi ƙarancin darajar filin

max - matsakaicin darajar filin

Don layin tambaya na sama yana dawowa sakamakon ain5, imei, tm filaye:

idan acikin 5 yana cikin kewayo (13,5000)

Sakamakon Tambaya:

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

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

{"imei":"karzzew", "tm":"2019-03-07 13:08:22", "acikin 5":"103" }]