Changes for page 01 Lua Functions

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

From 5.16 to 5.17 From 5.35 to 5.36

From version 5.17

edited by Stone Wu
on 2022/07/12 09:55

Change comment: (Autosaved)

To version 5.35

edited by Stone Wu
on 2022/07/12 11:00

Change comment: (Autosaved)

Raw
Rendered

Summary

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

Details

Page properties

Content

@@ -1370,7 +1370,6 @@
  )))
--
  (((
  == **Data storage area（HDW/HDX）** ==
  )))
@@ -1501,7 +1501,6 @@
  ** addr_getstring("@W_HSW225",15)
  (((
--(% class="wikigeneratedid" %)
  == **Power-down storage area (HAW/HAX)** ==
  The system storage area (HAW) is used for the system power-down hold registers:
@@ -1575,7 +1575,7 @@
  == **jwt_encode(table head, table payload, string aud, number iat, number exp, string key, int jwttype)** ==
  )))
--**Function:** Convert data to JWT format
++**Function:** Convert data to JWT format
  **parameter:**
@@ -1621,19 +1621,20 @@
  //key~:// the private key required for encryption
--For example:
++**For example:**
++{{code language="LUA"}}
  function jwt.main()
--local PRIVATE_KEY = ~[~[~-~- Please enter the secret key~-~-]]
++local PRIVATE_KEY = [[-- Please enter the secret key--]]
  local JWTType=0
--local payload = ~{~{key="test1",value="test1",type="0"},
++local payload = {{key="test1",value="test1",type="0"},
  {key="test",value="123122131",type="1"}}
--local head = ~{~{ key="name",value="data",type="0"},
++local head = {{ key="name",value="data",type="0"},
  {key="test2",value="test2",type="0"}}
@@ -1648,15 +1648,14 @@
  print(en)
  End
++{{/code}}
  (((
--== **9.5 convertohex(number type, number value)** ==
++== **convertohex(number type, number value)** ==
  )))
--**Function:**
++**Function:** Convert data into hexadecimal data
--Convert data into hexadecimal data
--
  **parameter:**
  //type~:// incoming data type 0:word 1:dword 2:float
@@ -1669,106 +1669,243 @@
  Failed: multi
++== **crc.init(table prarm)** ==
++
++**Function:** Initialize the CRC
++
++**Parameters:**
++
++prarm is a Lua table and needs to contain the following fields.
++
++* string prarm name, see table 9-1 for details of the parameter model name When this parameter is passed in, the default table parameters are used and the poly,init,xorout,refin,and refout passed in are invalid.
++* number prarm.width: the width, i.e. the number of CRC bits.
++* number [prarm.poly]: short for the generated item in hexadecimal. For example, CRC-32 is 0x04C11DB7, ignoring the highest bit "1", i.e., the complete generation item is 0x104C11DB7.
++* number [prarm.init]: the initialization preset value of the register (crc) at the beginning of the algorithm in hexadecimal.
++* number [prarm.xorout]: the final CRC value obtained after heterodyning the calculation result with this parameter.
++* number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false.
++* number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false.
++
++Return:
++
++Success: crc object
++
++Failure: multi, error code
++
  (((
--== **9.6 set_network(table config)** ==
++|=Parameter model name|=poly|=init|=xorout|=refin|=refout
++|crc8|0x07|0x00|0x00|false|false
++|crc8_cdma2000|0x9B|0xFF|0x00|false|false
++|crc8_darc|0x39|0x00|0x00|true|true
++|crc8_dvb_s2|0xD5|0x00|0x00|false|false
++|crc8_ebu|0x1D|0xFF|0x00|true|true
++|crc8_i_code|0x1D|0xFD|0x00|false|false
++|crc8_itu|0x07|0x00|0x55|false|false
++|crc8_maxim|0x31|0x00|0x00|true|true
++|crc8_rohc|0x07|0xFF|0x00|true|true
++|crc8_wcdma|0x9B|0x00|0x00|true|true
++|crc8_sae_j1850|0x1D|0xFF|0xFF|false|false
++|crc8_opensafety|0x2F|0x00|0x00|false|false
++|crc16_tms37157|0x1021|0x3791|0x0000|true|true
++|crc16_a|0x1021|0x6363|0x0000|true|true
++|crc16_riello|0x1021|0x554D|0x0000|true|true
++|crc16_ccitt_false|0x1021|0xFFFF|0x0000|false|false
++|crc16_arc|0x8005|0x0000|0x0000|true|true
++|crc16_arc_ccitt|0x1021|0x1D0F|0x0000|false|false
++|crc16_buypass|0x8005|0x0000|0x0000|false|false
++|crc16_cdma2000|0xC867|0xFFFF|0x0000|false|false
++|crc16_dds110|0x8005|0x800D|0x0000|false|false
++|crc16_dect_r|0x0589|0x0000|0x0001|false|false
++|crc16_dect_x|0x0589|0x0000|0x0000|false|false
++|crc16_dnp|0x3D65|0x0000|0xFFFF|true|true
++|crc16_en_13757|0x3D65|0x0000|0xFFFF|false|false
++|crc16_genibus|0x1021|0xFFFF|0xFFFF|false|false
++|crc16_maxim|0x8005|0x0000|0xFFFF|true|true
++|crc16_mcrf4xx|0x1021|0xFFFF|0x0000|true|true
++|crc16_t10_dif|0x8BB7|0x0000|0x0000|false|false
++|crc16_teledisk|0xA097|0x0000|0x0000|false|false
++|crc16_usb|0x8005|0xFFFF|0xFFFF|true|true
++|crc16_kermit|0x1021|0x0000|0x0000|true|true
++
++(% class="wikigeneratedid" %)
++Table 9-1
++
++== **crc:calc(string crcValue)** ==
++
++**Function:** Calculate CRC result
++
++**Parameter:**
++
++crcValue: the value to be calculated
++
++**Return:**
++
++Succeed: calculated result
++
++Failed: multi, error code
  )))
--**Function:**
++Example:
--Set V-BOX network, take effect after restart
++{{code language="LUA"}}
++function crcTest.main()
--**parameter:**
++local param = {
--//config~:// incoming network configuration table
++name = '',
--1. connectMode: the way V-BOX connects to the server, 0: Ethernet, 1: WIFI, 2: 4G, 3: 2G, it is not allowed to be empty.
--1. ethernetEnable: Whether to enable Ethernet, 1: enable, 0: disable, and it is not allowed to be empty.
--1. ethernetLanIp: Set the LAN IP address. Only V-BOX with three network ports support this configuration, and other models of V-BOX do not support setting LAN IP. This item is allowed to be empty.
--1. ethernetIpMode: Whether to enable Ethernet static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
--1. ethernetIp: The IP address needs to be configured when the Ethernet static IP is used, and it is not allowed to be empty.
--1. ethernetNetmask: The subnet mask needs to be configured when Ethernet static IP is used, and it is not allowed to be empty.
--1. ethernetGateway: The gateway can be configured when Ethernet static IP is used.
++width = 64,
--1. When using the Ethernet network, if the Gateway is empty, V-BOX will not connect to the server.
--1. If you only use Ethernet to directly connect to the PLC for communication, you do not need to configure a gateway.
++poly = 0x42F0E1EBA9EA3693,
--1. ethernetFirstDns: You can configure the preferred DNS server when the Ethernet static IP is used, and it is allowed to be empty. If you use the Ethernet network and do not fill in the DNS server, V-BOX will not be connected to the server.
--1. ethernetSpareDns: Alternate DNS server can be configured when the Ethernet static IP is used, and it is allowed to be empty.
--1. wifiEnable: Whether to enable WIFI, 1: enable, 0: disable, it is not allowed to be empty. If it is a model that does not include WIFI, directly disable it.
--1. wifiName: WIFI name, if WIFI is enabled, it is not allowed to be empty.
--1. wifiPassword: WIFI password, it is allowed to be empty.
--1. wifiIpMode: Whether to enable WIFI static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
--1. wifiIp: IP address needs to be configured when WIFI static IP is used, it is not allowed to be empty.
--1. wifiNetmask: The subnet mask needs to be configured when WIFI static IP is used, and it is not allowed to be empty.
--1. wifiGateway: The gateway can be configured when WIFI static IP is used, and it is not allowed to be empty.
--1. wifiFirstDns: You can configure the preferred DNS server when the WIFI static IP is used, and it is allowed to be empty. If you use the WIFI network and do not fill in the DNS server, V-BOX will not be connected to the server.
--1. wifiSpareDns: Alternate DNS server can be configured when the WIFI static IP is used, and it is allowed to be empty.
--1. mobileEnable: Whether to enable the mobile network, 1: enable, 0: disable, it is not allowed to be empty, if it does not include 4G models, directly disable it.
--1. mobileApnMode: Whether to manually configure the APN, 0: Use the default APN, 1: Manually configure the APN, it is not allowed to be empty.
--1. apnName: APN name, if you choose to manually configure APN, it is not allowed to be empty.
--1. apnPassword: APN username, it is allowed to be empty.
--1. apnUserName: APN number, it is allowed to be empty.
--1. apnNumber: APN number, it is allowed to be empty.
++init = 0xFFFFFFFFFFFFFFFF,
++xorout = 0xFFFFFFFFFFFFFFFF,
++
++refin = 1,
++
++refout = 1
++
++}
++
++crc64,err = crc.init(param)
++
++if not crc64 then
++
++print("Crc init failed:", err)
++else
++
++crcvalue = crc64:calc("123456789")
++
++print(string.format("crc64 calc :0X%16X", crcvalue))
++
++end
++
++end
++{{/code}}
++
++= **10 Special function for V-NET** =
++
++== **normal_get_alldata()** ==
++
++**Function: **Obtain the data of all the monitoring points
++
++**Parameter: None**
++
  **Return:**
--Succeed: true
++Succeed: table two-dimensional arrays, as follows:
--Faied: multi
++* Each item is a monitoring point and contains 4 attributes:
++** 1: ID
++** 2: status
++** 3: tag name
++** 4: value
++* Status contains 3 enumerated values
++** 0: offline
++** 1: online
++** 2: timeout
++* Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
--(((
--== **9.7 remote_com_start(string config)** ==
--)))
++For example:
--**Function:**
++{
--start serial port pass-through
++[1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
++[2]= {[1]=1235, [2]=1, [3]='humi', [4]='67'},
++
++...
++
++[n]= {[1]=xxxx, [2]=x, [3]='xxxx', [4]='xx.x'},
++
++}
++
++Failed: table, empty table
++
++== **normal_setdata_byname(string name, string data)** ==
++
++**Function:** Write data to the monitoring point name
++
  **Parameter:**
--//config: //incoming serial port parameter configuration, JSON format
++name: the name of monitoring point
--1. type:0, serial port pass-through
--1. port: serial port number marked on the V-BOX
--1. comtype:0-RS232, 1-RS485, 2-RS422
--1. baudrate: Baud Rate
--1. data_length: Data Bits
--1. stop_bit: Stop Bit
--1. check_bit: Check Bit
++data: the data to be written
  **Return:**
--Succeed: true
++Succeed: string: The value of the monitor point before it is written
--Failed: multi
++Failed: mil
--(((
--== **9.8 remote_com_stop()** ==
--)))
++== **normal_getdata_byname(string name)** ==
--**Function:**
--close serial port pass-through
++
++**Function:** Read the data of the monitoring point name
++
++**Parameter:**
++
++name: the name of monitoring point
++
  **Return:**
--Succeed: true
++Succeed: string
++Failed: mil
++
++= **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
--(((
--== **9.9 remote_com_state()** ==
--)))
++== **luaMySql.exec(string statement)** ==
--**Function:**
++**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
--query the serial port pass-through status and pass-through server domain name and port
++**Parameter:**
++statement: the given SQL statement
++
  **Return:**
--Succeed:
++Succeed: status: returns the number of rows affected by SQL statement execution.
--1. number, current pass-through status: 0-none 1,2-starting pass-through 3-penetrating 4,5-finishing pass-through 6-pass-through error
--1. string, pass-through server domain name and port number, xxxx (domain name): xxx (port number)
++Failed: mil, errorString
--Failed: multi
++== **luaMySql.execWithResult(string statement)** ==
++
++
++**Function:** Execute the given SQL statement returning the result set (che)
++
++**Parameter:**
++
++statement: the given SQL statement
++
++**Return:**
++
++Succeed: status: returns the number of rows affected by SQL statement execution.
++
++Failed: mil, errorString

Changes for page 01 Lua Functions

Summary

Details

Navigation

Table of Contents