Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51

From 12.1 to 11.1

From version 21.1

edited by Theodore Xu
on 2023/10/26 10:51

Change comment: There is no comment for this version

To version 12.1

edited by Hunter
on 2023/02/18 15:29

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.AiXia
++XWiki.Hunter

Content

@@ -1,5 +1,17 @@
  = **1 Interface description** =
++(% style="width:749.222px" %)
++|=(% scope="row" style="width: 374px;" %)z|=(% style="width: 373px;" %)cxz
++|=(% style="width: 374px;" %) |(% style="width:373px" %)
++|=(% style="width: 374px;" %) |(% style="width:373px" %)
++
++|分类|宽|高
++|网页全屏|700-850|400
++|手机全屏|300|400
++|其他大图片|400左右|400左右
++|小图片|200左右|200左右
++
++
  == **Data type definition** ==
  |=**Type**|=**Description**
@@ -1356,14 +1356,186 @@
  {{/code}}
  (((
--
++= **8 Internal register** =
  )))
++The internal registers of the box are divided into bit addresses and word addresses, which can be accessed in two ways (taking HDW as an example):
++
++**Access by word, prefix @W_HDW.**
++
++For example: @W_HDW0 represents the first word of the system data area, @W_HDW1 represents the second word of the system data area.
++
++**Access in bit mode, the prefix is @B_HDX, the number in front of "." indicates the number of the word, and the number behind is the bit number of the word.**
++
++**For example:** @B_HDX1020.12, its meaning is to access the system data area in bit mode, the specific location is the 13th bit of the 1020th word.
++
++(% class="box infomessage" %)
  (((
--= **8 General Functions** =
++**✎Note: **
++
++* The address in @B_HDX is taken from the word in @W_HDW, so pay special attention when using the address.
++** For example, @B_HDX1020.12 is to access the 13th bit of the 1020th word. The value of this bit is the same as the word obtained by @W_HDW001020. The 13th bit of this word is actually the same bit as @B_HDX1020.12.
++* The address of the bit address @B_HDX has a decimal point, while the word address is an integer.
  )))
++
  (((
++== **Data storage area（HDW/HDX）** ==
++)))
++
++The system storage area (HDW) of the V-BOX is used to store temporary data:
++
++1. Access by word, the number range is: "@W_HDW0"-"@W_HDW299999".
++1. Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
++
++(((
++== **Special data area (HSW/HSX)** ==
++
++(% class="box infomessage" %)
++(((
++**✎Note: **
++
++* //HSW// is a system special register, so please refer to the system special register table during use. Do not use addresses that are not mentioned in the table, and use the addresses stated in the table with caution (example: restart ("@W_HSW0") Writing a value of 1 will cause V-BOX to restart).
++* //Without any conditions. Direct use ("@W_HSW0") will cause the V-BOX to restart continuously.// When using ("@W_HSW0") address, please add judgment conditions, such as: connection to MQTT fails, there is no network, the value of a PLC address meets the condition or counts to a certain value.
++)))
++)))
++
++The system data area (HSW) of the box is used for system special registers (system reserved). Use //addr_getword// to obtain the following register information:
++
++(% class="table-bordered" %)
++|=(% style="width: 151px;" %)address|=(% style="width: 169px;" %)function|=(% style="width: 456px;" %)Read and write status: read only, write only, read and write
++|(% style="width:151px" %)@W_HSW0|(% style="width:169px" %)restart|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW1|(% style="width:169px" %)Box time: year|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW2|(% style="width:169px" %)Box time: month|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW3|(% style="width:169px" %)Box time: day|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW4|(% style="width:169px" %)Box time: hour|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW5|(% style="width:169px" %)Box time: minute|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW6|(% style="width:169px" %)Box time: second|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW7|(% style="width:169px" %)Box time: week|(% style="width:456px" %)read and write
++|(% style="width:151px" %)@W_HSW8|(% style="width:169px" %)Ethernet IP1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW9|(% style="width:169px" %)Ethernet IP2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW10|(% style="width:169px" %)Ethernet IP3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW11|(% style="width:169px" %)Ethernet IP4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW12|(% style="width:169px" %)Ethernet Mask 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW13|(% style="width:169px" %)Ethernet Mask 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW14|(% style="width:169px" %)Ethernet Mask 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW15|(% style="width:169px" %)Ethernet Mask 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW16|(% style="width:169px" %)Ethernet Gateway 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW17|(% style="width:169px" %)Ethernet Gateway 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW18|(% style="width:169px" %)Ethernet Gateway 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW19|(% style="width:169px" %)Ethernet Gateway 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW21|(% style="width:169px" %)Ethernet MAC1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW22|(% style="width:169px" %)Ethernet MAC2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW23|(% style="width:169px" %)Ethernet MAC3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW24|(% style="width:169px" %)Ethernet MAC4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW25|(% style="width:169px" %)Ethernet MAC3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW26|(% style="width:169px" %)Ethernet MAC4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW128|(% style="width:169px" %)WIFI IP1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW129|(% style="width:169px" %)WIFI IP2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW130|(% style="width:169px" %)WIFI IP3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW131|(% style="width:169px" %)WIFI IP4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW132|(% style="width:169px" %)WIFI Mask 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW133|(% style="width:169px" %)WIFI Mask 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW134|(% style="width:169px" %)WIFI Mask 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW135|(% style="width:169px" %)WIFI Mask 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW136|(% style="width:169px" %)WIFI Gateway 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW137|(% style="width:169px" %)WIFI Gateway 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW138|(% style="width:169px" %)WIFI Gateway 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW139|(% style="width:169px" %)WIFI Gateway 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW140|(% style="width:169px" %)WIFI MAC1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW141|(% style="width:169px" %)WIFI MAC2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW142|(% style="width:169px" %)WIFI MAC3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW143|(% style="width:169px" %)WIFI MAC4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW144|(% style="width:169px" %)WIFI MAC5|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW145|(% style="width:169px" %)WIFI MAC6|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW146|(% style="width:169px" %)WIFI Signal value|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW148|(% style="width:169px" %)4G IP1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW149|(% style="width:169px" %)4G IP2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW150|(% style="width:169px" %)4G IP3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW151|(% style="width:169px" %)4G IP4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW152|(% style="width:169px" %)4G Mask 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW153|(% style="width:169px" %)4G Mask 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW154|(% style="width:169px" %)4G Mask 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW155|(% style="width:169px" %)4G Mask 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW156|(% style="width:169px" %)4G Gateway 1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW157|(% style="width:169px" %)4G Gateway 2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW158|(% style="width:169px" %)4G Gateway 3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW159|(% style="width:169px" %)4G Gateway 4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW160|(% style="width:169px" %)4G MAC1|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW161|(% style="width:169px" %)4G MAC2|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW162|(% style="width:169px" %)4G MAC3|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW163|(% style="width:169px" %)4G MAC4|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW164|(% style="width:169px" %)4G MAC5|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW165|(% style="width:169px" %)4G MAC6|(% style="width:456px" %)read only
++|(% style="width:151px" %)@W_HSW166|(% style="width:169px" %)4G Signal value|(% style="width:456px" %)read only
++
++**Others**
++
++* Access password: addr_getstring("@W_HSW27", 16)
++* Machine code: addr_getstring("@W_HSW60", 64)
++* Positioning method (@W_HSW167): (read only)
++** Latitude and longitude
++*** Longitude: addr_getdouble("@W_HSW168") (read only)
++*** Latitude: addr_getdouble("@W_HSW172") (read only)
++** Base station positioning
++*** LAC: addr_getdword("@W_HSW168") (read only)
++*** CI: addr_getdword("@W_HSW172") (read only)
++* Convert base station to latitude and longitude via API
++** Longitude: addr_getdouble("@W_HSW187") (read only)
++** Latitude: addr_getdouble("@W_HSW183") (read only)
++* Operator information: addr_getdword("@W_HSW181") (read only)
++* Networking mode: addr_getword("@W_HSW177") (read only)
++** 0: Ethernet
++** 1: WIFI
++** 2: 4G
++** 3: 2G
++* Map fence flag: addr_getword("@W_HSW178") (read only)
++** 0: No map fence is drawn
++** 1: Draw a map fence and the box is in the fence
++** 2: Draw a map fence and the box is not in the fence
++* SIM card status addr_getword("@W_HSW179") (read only)
++** 1: No card detected
++** 2: Card insertion detected
++** 3: The card status is abnormal
++* MQTT status addr_getword("@W_HSW180") (read only)
++** 1: online, 2: offline
++* IO interface, X is read only, Y is read and write (H series)
++** addr_getbit(addr1), addr_setbit(addr2)
++** addr1:"@B_Y0" "@B_Y1" "@B_X0" "@B_X1"
++** addr2:"@B_Y0" "@B_Y1"
++* Obtaining IMEI (read only)
++** addr_getstring("@W_HSW191",17)
++* Obtaining ICCID (read only)
++** addr_getstring("@W_HSW225",15)
++* (((
++TSAP settings of Siemens LOGO PLC*
++
++(((
++addr_setword("@W_0#HSW1200",8192) means set the Local TSAP as 20.00
++)))
++
++* (((
++addr_setword("@W_0#HSW1201",4096) means set the Remote TSAP as 10.00
++)))
++)))
++
++(((
++== **Power-down storage area (HAW/HAX)** ==
++
++The system storage area (HAW) is used for the system power-down hold registers:
++
++1. Accessed as a word, numbered in the range: "@W_HAW0"-"@W_HAW199999".
++1. Accessed by bit, the numbering range is: "@B_HAX0.0"-"@B_HAX199999.15".
++
++(% class="box infomessage" %)
++(((
++**✎Note:** HAW/HAX is a power-down hold, that is, the registers of this type can retain the data before power-down in case of power-down.
++)))
++
++= **9 General Functions** =
++)))
++
++(((
  == **send_sms_ira(string number, string message)** ==
  )))
@@ -1629,7 +1629,7 @@
  end
  {{/code}}
--= **9 Special function for V-NET** =
++= **10 Special function for V-NET** =
  == **normal_get_alldata()** ==
@@ -1700,8 +1700,186 @@
  Failed: nil
--= **10 Message summary algorithm** =
++= **11 MySQL database operation** =
++== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
++
++**Function:** Configure database connection parameters
++
++**Parameter:**
++
++sourcename: the name of database
++
++username: the username of the connection
++
++password: the password of the connection
++
++host: the host name of the connection
++
++port: the host port of the connection
++
++character: the character set of the connection
++
++**Return:**
++
++Succeed: string
++
++Failed: multi
++
++== **luaMySql.exec(string statement)** ==
++
++**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
++
++**Parameter:**
++
++statement: the given SQL statement
++
++**Return:**
++
++Succeed: status: returns the number of rows affected by SQL statement execution.
++
++Failed: nil, errorString
++
++== **luaMySql.execWithResult(string statement)** ==
++
++**Function:** Execute the given SQL statement returning the result set (check)
++
++**Parameter:**
++
++statement: the given SQL statement
++
++**Return:**
++
++Succeed: table: returns the result set
++
++Failed: nil, errorString
++
++**For example:**
++
++{{code language="LUA"}}
++mysql = require"mysqlclient"
++
++function DataInitRight()
++
++local dbName = "db_lua1"
++
++local user = "root"
++
++local pwd = "123456"
++
++local host = "192.168.56.186"
++
++local port = 3306
++local character = "UTF8"
++
++mysql.init(dbName, user, pwd, host, port, character)
++
++end
++
++function ExecFunc()
++
++status, errorString = mysql.exec("delete from tb_lua1 where mykey =
++
++10;")
++
++if nil == status then
++
++print("ExecFunc() error:", errorString)
++
++return -1
++
++else
++
++print("the number of rows affected by the command:", status)
++
++end
++
++return 0
++
++end
++
++function ExecWithResultFunc()
++
++status, errorString = mysql.execWithResult("select * from tb_lua1;")
++
++if nil == status then
++
++print("ExecWithResultFunc() error:", errorString)
++
++return -1
++
++else
++
++print("ExecWithResultFunc()
++
++success
++
++: status
++
++type
++
++=
++
++",
++
++type(status))
++
++print("ExecWithResultFunc() success : status len = ", #status)
++
++local num = #status
++
++local i = 1
++
++if num > 0 then
++
++for i = 1, num, 1 do
++
++local var = string.format("select result[%d] :mykey = %d,
++
++value = %s", i, status[i].mykey, status[i].value)
++
++print(var)
++
++end
++
++end
++
++print("---------------")
++
++end
++
++return 0
++end
++
++function luaMysql_apiTest.main()
++
++print("script running ...")
++
++DataInitRight()
++
++--use exec demo
++
++if ExecFunc() < 0 then
++
++return
++
++end
++
++--use execWithResult demo
++
++if ExecWithResultFunc() < 0 then
++
++return
++
++end
++
++print("script running success")
++
++end
++{{/code}}
++
++= **12 Message summary algorithm** =
++
  == **hmac(string hash_func, string key, string message)** ==
  **Function:** HMAC calculate

Changes for page 01 Lua Functions

Summary

Details

Navigation

Table of Contents