Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 10.1
edited by Hunter
on 2023/01/15 16:45
Change comment: There is no comment for this version
To version 5.27
edited by Stone Wu
on 2022/07/12 10:30
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -V-BOX.V-Net.Manual.04 Lua Script.WebHome
1 +V-BOX.V-Net.1\.User Manual.04 Lua Script.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Hunter
1 +XWiki.Stone
Content
... ... @@ -140,7 +140,7 @@
140 140  
141 141   Table 2-1
142 142  
143 -(% class="box infomessage" %)
143 +(% class="box errormessage" %)
144 144  (((
145 145  **✎Note: **If HLword enters any other value, it will be treated as invalid.
146 146  )))
... ... @@ -608,12 +608,11 @@
608 608  Attempting to use a script to open a serial port in an unsupported mode will result in an error directly, as below.
609 609  
610 610  |(((
611 -{{code language="LUA"}}
612 612  local setup = {
613 613  
614 614  name = "COM2",
615 615  
616 -mode = 422, -- COM2 does not support RS422
615 +mode = 422, ~-~- COM2 does not support RS422
617 617  
618 618  ...
619 619  
... ... @@ -620,7 +620,6 @@
620 620  }
621 621  
622 622  serial.open(setup)
623 -{{/code}}
624 624  )))
625 625  
626 626  **Data bit:**
... ... @@ -1065,9 +1065,8 @@
1065 1065  
1066 1066  If there is no custom configuration, return an empty table, otherwise, return with "field name/field content"
1067 1067  
1068 -**For example:**
1066 +E.g:
1069 1069  
1070 -{{code language="LUA"}}
1071 1071  {
1072 1072  
1073 1073  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}},
... ... @@ -1080,8 +1080,7 @@
1080 1080  
1081 1081  }
1082 1082  
1083 -Failed: table empty table
1084 -{{/code}}
1080 +Failed: //table// empty table
1085 1085  
1086 1086  (((
1087 1087  == **bns_get_config(string from)** ==
... ... @@ -1161,15 +1161,13 @@
1161 1161  
1162 1162  Type (1: switch, 2: number, 3: string)
1163 1163  
1164 -**For example:**
1160 +E.g:
1161 + {
1165 1165  
1166 -{{code language="LUA"}}
1167 -{
1163 +[1]={~-~-The first communication port
1168 1168  
1169 -[1]={--The first communication port
1165 +[1]={~-~-monitoring point array of the first communication port
1170 1170  
1171 -[1]={--monitoring point array of the first communication port
1172 -
1173 1173  [1]={[1]=11,[2]='data1',[3]=3,[4]=2},
1174 1174  
1175 1175  [2]={[1]=12,[2]='data2',[3]=3,[4]=2},
... ... @@ -1176,23 +1176,23 @@
1176 1176  
1177 1177  ...
1178 1178  
1179 -[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},--n monitoring points
1173 +[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},~-~-n monitoring points
1180 1180  
1181 1181  },
1182 1182  
1183 -[2]=14, --ID
1177 +[2]=14, ~-~-ID
1184 1184  
1185 -[3]='Modbus TCP' --n monitoring points
1179 +[3]='Modbus TCP' ~-~-n monitoring points
1186 1186  
1187 1187  },
1188 1188  
1189 -[2]={--The second communication port
1183 +[2]={~-~-The second communication port
1190 1190  
1191 -[1]={},--The monitoring point of the second communication port is not configured and is empty
1185 +[1]={},~-~-The monitoring point of the second communication port is not configured and is empty
1192 1192  
1193 -[2]=15, --ID
1187 +[2]=15, ~-~-ID
1194 1194  
1195 -[3]='WECON' --communication protocol name
1189 +[3]='WECON' ~-~-communication protocol name
1196 1196  
1197 1197  },
1198 1198  
... ... @@ -1199,7 +1199,6 @@
1199 1199  ...n communication ports and so on
1200 1200  
1201 1201  }
1202 -{{/code}}
1203 1203  
1204 1204  Failed~:// table// empty table
1205 1205  
... ... @@ -1279,9 +1279,8 @@
1279 1279  
1280 1280  Succeed: //table// one-dimensional array
1281 1281  
1282 -**For example:**
1275 +E.g:
1283 1283  
1284 -{{code language="LUA"}}
1285 1285  {
1286 1286  
1287 1287  [1]="This is the oldest message", - the first is the oldest message
... ... @@ -1293,7 +1293,6 @@
1293 1293  [n]="This is the latest message", - the last is the latest message
1294 1294  
1295 1295  }
1296 -{{/code}}
1297 1297  
1298 1298  Failede: nil
1299 1299  
... ... @@ -1311,7 +1311,7 @@
1311 1311  
1312 1312  == **https request** ==
1313 1313  
1314 -**For example:**
1305 +Example：
1315 1315  
1316 1316  {{code language="LUA"}}
1317 1317  local json = require("json")
... ... @@ -1367,7 +1367,7 @@
1367 1367  
1368 1368  **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.**
1369 1369  
1370 -**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.
1361 +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.
1371 1371  
1372 1372  (% class="box infomessage" %)
1373 1373  (((
... ... @@ -1389,7 +1389,7 @@
1389 1389  1. Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
1390 1390  
1391 1391  (((
1392 -== **Special data area (HSW/HSX)** ==
1383 +== **8.2 Special data area (HSW/HSX)** ==
1393 1393  
1394 1394  (% class="box infomessage" %)
1395 1395  (((
... ... @@ -1507,14 +1507,6 @@
1507 1507  ** addr_getstring("@W_HSW191",17)
1508 1508  * Obtaining ICCID (read only)
1509 1509  ** addr_getstring("@W_HSW225",15)
1510 -* (((
1511 -TSAP settings of Siemens LOGO PLC* (((
1512 -addr_setword("@W_0#HSW1200",8192) means set the Local TSAP as 20.00
1513 -)))
1514 -* (((
1515 -addr_setword("@W_0#HSW1201",4096) means set the Remote TSAP as 10.00
1516 -)))
1517 -)))
1518 1518  
1519 1519  (((
1520 1520  == **Power-down storage area (HAW/HAX)** ==
... ... @@ -1551,7 +1551,7 @@
1551 1551  Failed: multi
1552 1552  
1553 1553  (((
1554 -== **send_sms_ucs2(string number, string message)** ==
1537 +== **9.2 send_sms_ucs2(string number, string message)** ==
1555 1555  )))
1556 1556  
1557 1557  **Function:**
... ... @@ -1700,429 +1700,163 @@
1700 1700  * number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false.
1701 1701  * number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false.
1702 1702  
1703 -**Return:**
1686 +Return:
1704 1704  
1705 1705  Success: crc object
1706 1706  
1707 1707  Failure: multi, error code
1708 1708  
1709 -(((
1710 -|=Parameter model name|=poly|=init|=xorout|=refin|=refout
1711 -|crc8|0x07|0x00|0x00|false|false
1712 -|crc8_cdma2000|0x9B|0xFF|0x00|false|false
1713 -|crc8_darc|0x39|0x00|0x00|true|true
1714 -|crc8_dvb_s2|0xD5|0x00|0x00|false|false
1715 -|crc8_ebu|0x1D|0xFF|0x00|true|true
1716 -|crc8_i_code|0x1D|0xFD|0x00|false|false
1717 -|crc8_itu|0x07|0x00|0x55|false|false
1718 -|crc8_maxim|0x31|0x00|0x00|true|true
1719 -|crc8_rohc|0x07|0xFF|0x00|true|true
1720 -|crc8_wcdma|0x9B|0x00|0x00|true|true
1721 -|crc8_sae_j1850|0x1D|0xFF|0xFF|false|false
1722 -|crc8_opensafety|0x2F|0x00|0x00|false|false
1723 -|crc16_tms37157|0x1021|0x3791|0x0000|true|true
1724 -|crc16_a|0x1021|0x6363|0x0000|true|true
1725 -|crc16_riello|0x1021|0x554D|0x0000|true|true
1726 -|crc16_ccitt_false|0x1021|0xFFFF|0x0000|false|false
1727 -|crc16_arc|0x8005|0x0000|0x0000|true|true
1728 -|crc16_arc_ccitt|0x1021|0x1D0F|0x0000|false|false
1729 -|crc16_buypass|0x8005|0x0000|0x0000|false|false
1730 -|crc16_cdma2000|0xC867|0xFFFF|0x0000|false|false
1731 -|crc16_dds110|0x8005|0x800D|0x0000|false|false
1732 -|crc16_dect_r|0x0589|0x0000|0x0001|false|false
1733 -|crc16_dect_x|0x0589|0x0000|0x0000|false|false
1734 -|crc16_dnp|0x3D65|0x0000|0xFFFF|true|true
1735 -|crc16_en_13757|0x3D65|0x0000|0xFFFF|false|false
1736 -|crc16_genibus|0x1021|0xFFFF|0xFFFF|false|false
1737 -|crc16_maxim|0x8005|0x0000|0xFFFF|true|true
1738 -|crc16_mcrf4xx|0x1021|0xFFFF|0x0000|true|true
1739 -|crc16_t10_dif|0x8BB7|0x0000|0x0000|false|false
1740 -|crc16_teledisk|0xA097|0x0000|0x0000|false|false
1741 -|crc16_usb|0x8005|0xFFFF|0xFFFF|true|true
1742 -|crc16_kermit|0x1021|0x0000|0x0000|true|true
1692 +|=(% style="width: 193px;" %)Parameter model name|=(% style="width: 65px;" %)poly|=init|=(% style="width: 184px;" %)xorout|=(% style="width: 69px;" %)refin|=refout
1693 +|(% style="width:193px" %)crc8|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1694 +|(% style="width:193px" %)crc8_cdma2000|(% style="width:65px" %)0x9B|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1695 +|(% style="width:193px" %)crc8_darc|(% style="width:65px" %)0x39|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1696 +|(% style="width:193px" %)crc8_dvb_s2|(% style="width:65px" %)0xD5|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1697 +|(% style="width:193px" %)crc8_ebu|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1698 +|(% style="width:193px" %)crc8_i_code|(% style="width:65px" %)0x1D|0xFD|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1699 +|(% style="width:193px" %)crc8_itu|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0X55|(% style="width:69px" %)false|false
1700 +|(% style="width:193px" %)crc8_maxim|(% style="width:65px" %)0x31|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1701 +|(% style="width:193px" %)crc8_rohc|(% style="width:65px" %)0x07|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1702 +|(% style="width:193px" %)crc8_wcdma|(% style="width:65px" %)0x9B|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1703 +|(% style="width:193px" %)crc8_sae_j1850|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0xFF|(% style="width:69px" %)false|false
1704 +|(% style="width:193px" %)crc8_opensafaty|(% style="width:65px" %)0x2F|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1705 +|(% style="width:193px" %)crc16_tms37157|(% style="width:65px" %)0x1021|0x3791|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1706 +|(% style="width:193px" %)crc16_a|(% style="width:65px" %)0x1021|0x6363|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1707 +|(% style="width:193px" %)crc16_riello|(% style="width:65px" %)0x1021|0x554D|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1708 +|(% style="width:193px" %)crc16_ccitt_false|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1709 +|(% style="width:193px" %)crc16_arc|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1710 +|(% style="width:193px" %)crc16_arc_ccitt|(% style="width:65px" %)0x1021|0X1D0F|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1711 +|(% style="width:193px" %)crc16_cdma2000|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1712 +|(% style="width:193px" %)crc16_dds110|(% style="width:65px" %)0xC867|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1713 +|(% style="width:193px" %)crc16_dect_r|(% style="width:65px" %)0x0589|0x800D|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1714 +|(% style="width:193px" %)crc16_dect_x|(% style="width:65px" %)0x0589|0x0000|(% style="width:184px" %)0x0001|(% style="width:69px" %)false|false
1715 +|(% style="width:193px" %)crc16_dnp|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1716 +|(% style="width:193px" %)crc16_en_13757|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1717 +|(% style="width:193px" %)crc16_genibus|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1718 +|(% style="width:193px" %)crc16_maxim|(% style="width:65px" %)0x8005|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1719 +|(% style="width:193px" %)crc16_mcrf4xx|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1720 +|(% style="width:193px" %)crc16_r10_dif|(% style="width:65px" %)0x8BB7|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1721 +|(% style="width:193px" %)crc16_teldisk|(% style="width:65px" %)0xA097|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1722 +|(% style="width:193px" %)crc16_usb|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1723 +|(% style="width:193px" %)crc16_kermit|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1724 +|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1725 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1726 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1727 +|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1728 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1729 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1730 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1731 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1732 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1733 +|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1734 +|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1735 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)true|true
1736 +|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1737 +|(% style="width:193px" %) |(% style="width:65px" %) |0x0000000000000000|(% style="width:184px" %)0x0000000000000000|(% style="width:69px" %)false|false
1738 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1739 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)false|false
1740 +|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1741 +|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1742 +|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1743 +|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1743 1743  
1744 -(% class="wikigeneratedid" %)
1745 -Table 9-1
1746 -
1747 -== **crc:calc(string crcValue)** ==
1748 -
1749 -**Function:** Calculate CRC result
1750 -
1751 -**Parameter:**
1752 -
1753 -crcValue: the value to be calculated
1754 -
1755 -**Return:**
1756 -
1757 -Succeed: calculated result
1758 -
1759 -Failed: multi, error code
1745 +(((
1746 +== **set_network(table config)** ==
1760 1760  )))
1761 1761  
1762 -**For example:**
1749 +**Function:** Set V-BOX network, take effect after restart
1763 1763  
1764 -{{code language="LUA"}}
1765 -function crcTest.main()
1751 +**parameter:**
1766 1766  
1767 -local param = {
1753 +//config~:// incoming network configuration table
1768 1768  
1769 -name = '',
1755 +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.
1756 +1. ethernetEnable: Whether to enable Ethernet, 1: enable, 0: disable, and it is not allowed to be empty.
1757 +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.
1758 +1. ethernetIpMode: Whether to enable Ethernet static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
1759 +1. ethernetIp: The IP address needs to be configured when the Ethernet static IP is used, and it is not allowed to be empty.
1760 +1. ethernetNetmask: The subnet mask needs to be configured when Ethernet static IP is used, and it is not allowed to be empty.
1761 +1. ethernetGateway: The gateway can be configured when Ethernet static IP is used.
1770 1770  
1771 -width = 64,
1763 +1. When using the Ethernet network, if the Gateway is empty, V-BOX will not connect to the server.
1764 +1. If you only use Ethernet to directly connect to the PLC for communication, you do not need to configure a gateway.
1772 1772  
1773 -poly = 0x42F0E1EBA9EA3693,
1766 +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.
1767 +1. ethernetSpareDns: Alternate DNS server can be configured when the Ethernet static IP is used, and it is allowed to be empty.
1768 +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.
1769 +1. wifiName: WIFI name, if WIFI is enabled, it is not allowed to be empty.
1770 +1. wifiPassword: WIFI password, it is allowed to be empty.
1771 +1. wifiIpMode: Whether to enable WIFI static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
1772 +1. wifiIp: IP address needs to be configured when WIFI static IP is used, it is not allowed to be empty.
1773 +1. wifiNetmask: The subnet mask needs to be configured when WIFI static IP is used, and it is not allowed to be empty.
1774 +1. wifiGateway: The gateway can be configured when WIFI static IP is used, and it is not allowed to be empty.
1775 +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.
1776 +1. wifiSpareDns: Alternate DNS server can be configured when the WIFI static IP is used, and it is allowed to be empty.
1777 +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.
1778 +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.
1779 +1. apnName: APN name, if you choose to manually configure APN, it is not allowed to be empty.
1780 +1. apnPassword: APN username, it is allowed to be empty.
1781 +1. apnUserName: APN number, it is allowed to be empty.
1782 +1. apnNumber: APN number, it is allowed to be empty.
1774 1774  
1775 -init = 0xFFFFFFFFFFFFFFFF,
1776 -
1777 -xorout = 0xFFFFFFFFFFFFFFFF,
1778 -
1779 -refin = 1,
1780 -
1781 -refout = 1
1782 -
1783 -}
1784 -
1785 -crc64,err = crc.init(param)
1786 -
1787 -if not crc64 then
1788 -
1789 -print("Crc init failed:", err)
1790 -else
1791 -
1792 -crcvalue = crc64:calc("123456789")
1793 -
1794 -print(string.format("crc64 calc :0X%16X", crcvalue))
1795 -
1796 -end
1797 -
1798 -end
1799 -{{/code}}
1800 -
1801 -= **10 Special function for V-NET** =
1802 -
1803 -== **normal_get_alldata()** ==
1804 -
1805 -**Function: **Obtain the data of all the monitoring points
1806 -
1807 -**Parameter: None**
1808 -
1809 1809  **Return:**
1810 1810  
1811 -Succeed: table two-dimensional arrays, as follows:
1786 +Succeed: true
1812 1812  
1813 -* Each item is a monitoring point and contains 4 attributes:
1814 -** 1: ID
1815 -** 2: status
1816 -** 3: tag name
1817 -** 4: value
1818 -* Status contains 3 enumerated values
1819 -** 0: offline
1820 -** 1: online
1821 -** 2: timeout
1822 -* Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
1788 +Faied: multi
1823 1823  
1824 -**For example:**
1790 +(((
1791 +== **9.7 remote_com_start(string config)** ==
1792 +)))
1825 1825  
1826 -{{code language="LUA"}}
1827 -{
1794 +**Function:**
1828 1828  
1829 -[1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
1796 +start serial port pass-through
1830 1830  
1831 -[2]= {[1]=1235, [2]=1, [3]='humi', [4]='67'},
1832 -
1833 -...
1834 -
1835 -[n]= {[1]=xxxx, [2]=x, [3]='xxxx', [4]='xx.x'},
1836 -
1837 -}
1838 -
1839 -Failed: table, empty table
1840 -{{/code}}
1841 -
1842 -== **normal_setdata_byname(string name, string data)** ==
1843 -
1844 -**Function:** Write data to the monitoring point name
1845 -
1846 1846  **Parameter:**
1847 1847  
1848 -name: the name of monitoring point
1800 +//config: //incoming serial port parameter configuration, JSON format
1849 1849  
1850 -data: the data to be written
1802 +1. type:0, serial port pass-through
1803 +1. port: serial port number marked on the V-BOX
1804 +1. comtype:0-RS232, 1-RS485, 2-RS422
1805 +1. baudrate: Baud Rate
1806 +1. data_length: Data Bits
1807 +1. stop_bit: Stop Bit
1808 +1. check_bit: Check Bit
1851 1851  
1852 1852  **Return:**
1853 1853  
1854 -Succeed: string: The value of the monitor point before it is written
1812 +Succeed: true
1855 1855  
1856 -Failed: nil
1814 +Failed: multi
1857 1857  
1858 -== **normal_getdata_byname(string name)** ==
1816 +(((
1817 +== **9.8 remote_com_stop()** ==
1818 +)))
1859 1859  
1860 -**Function:** Read the data of the monitoring point name
1820 +**Function:**
1861 1861  
1862 -**Parameter:**
1822 +close serial port pass-through
1863 1863  
1864 -name: the name of monitoring point
1865 -
1866 1866  **Return:**
1867 1867  
1868 -Succeed: string
1826 +Succeed: true
1869 1869  
1870 -Failed: nil
1871 -
1872 -= **11 MySQL database operation** =
1873 -
1874 -== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1875 -
1876 -**Function:** Configure database connection parameters
1877 -
1878 -**Parameter:**
1879 -
1880 -sourcename: the name of database
1881 -
1882 -username: the username of the connection
1883 -
1884 -password: the password of the connection
1885 -
1886 -host: the host name of the connection
1887 -
1888 -port: the host port of the connection
1889 -
1890 -character: the character set of the connection
1891 -
1892 -**Return:**
1893 -
1894 -Succeed: string
1895 -
1896 1896  Failed: multi
1897 1897  
1898 -== **luaMySql.exec(string statement)** ==
1830 +(((
1831 +== **9.9 remote_com_state()** ==
1832 +)))
1899 1899  
1900 -**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
1834 +**Function:**
1901 1901  
1902 -**Parameter:**
1836 +query the serial port pass-through status and pass-through server domain name and port
1903 1903  
1904 -statement: the given SQL statement
1905 -
1906 1906  **Return:**
1907 1907  
1908 -Succeed: status: returns the number of rows affected by SQL statement execution.
1840 +Succeed:
1909 1909  
1910 -Failed: nil, errorString
1842 +1. number, current pass-through status: 0-none 1,2-starting pass-through 3-penetrating 4,5-finishing pass-through 6-pass-through error
1843 +1. string, pass-through server domain name and port number, xxxx (domain name): xxx (port number)
1911 1911  
1912 -== **luaMySql.execWithResult(string statement)** ==
1913 -
1914 -**Function:** Execute the given SQL statement returning the result set (check)
1915 -
1916 -**Parameter:**
1917 -
1918 -statement: the given SQL statement
1919 -
1920 -**Return:**
1921 -
1922 -Succeed: table: returns the result set
1923 -
1924 -Failed: nil, errorString
1925 -
1926 -**For example:**
1927 -
1928 -{{code language="LUA"}}
1929 -mysql = require"mysqlclient"
1930 -
1931 -function DataInitRight()
1932 -
1933 -local dbName = "db_lua1"
1934 -
1935 -local user = "root"
1936 -
1937 -local pwd = "123456"
1938 -
1939 -local host = "192.168.56.186"
1940 -
1941 -local port = 3306
1942 -local character = "UTF8"
1943 -
1944 -mysql.init(dbName, user, pwd, host, port, character)
1945 -
1946 -end
1947 -
1948 -function ExecFunc()
1949 -
1950 -status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1951 -
1952 -10;")
1953 -
1954 -if nil == status then
1955 -
1956 -print("ExecFunc() error:", errorString)
1957 -
1958 -return -1
1959 -
1960 -else
1961 -
1962 -print("the number of rows affected by the command:", status)
1963 -
1964 -end
1965 -
1966 -return 0
1967 -
1968 -end
1969 -
1970 -function ExecWithResultFunc()
1971 -
1972 -status, errorString = mysql.execWithResult("select * from tb_lua1;")
1973 -
1974 -if nil == status then
1975 -
1976 -print("ExecWithResultFunc() error:", errorString)
1977 -
1978 -return -1
1979 -
1980 -else
1981 -
1982 -print("ExecWithResultFunc()
1983 -
1984 -success
1985 -
1986 -: status
1987 -
1988 -type
1989 -
1990 -=
1991 -
1992 -",
1993 -
1994 -type(status))
1995 -
1996 -print("ExecWithResultFunc() success : status len = ", #status)
1997 -
1998 -local num = #status
1999 -
2000 -local i = 1
2001 -
2002 -if num > 0 then
2003 -
2004 -for i = 1, num, 1 do
2005 -
2006 -local var = string.format("select result[%d] :mykey = %d,
2007 -
2008 -value = %s", i, status[i].mykey, status[i].value)
2009 -
2010 -print(var)
2011 -
2012 -end
2013 -
2014 -end
2015 -
2016 -print("---------------")
2017 -
2018 -end
2019 -
2020 -return 0
2021 -end
2022 -
2023 -function luaMysql_apiTest.main()
2024 -
2025 -print("script running ...")
2026 -
2027 -DataInitRight()
2028 -
2029 ---use exec demo
2030 -
2031 -if ExecFunc() < 0 then
2032 -
2033 -return
2034 -
2035 -end
2036 -
2037 ---use execWithResult demo
2038 -
2039 -if ExecWithResultFunc() < 0 then
2040 -
2041 -return
2042 -
2043 -end
2044 -
2045 -print("script running success")
2046 -
2047 -end
2048 -{{/code}}
2049 -
2050 -= **12 Message summary algorithm** =
2051 -
2052 -== **hmac(string hash_func, string key, string message)** ==
2053 -
2054 -**Function:** HMAC calculate
2055 -
2056 -**Function name**
2057 -
2058 -hash_func:
2059 -
2060 -* [md5, sha1, sha224, sha256, sha384, sha512]
2061 -* [sha512_224, sha512_256, sha3_224, sha3_256]
2062 -* [sha3_384, sha3_512]
2063 -
2064 -**Parameter:**
2065 -
2066 -key: the key
2067 -
2068 -message: message content
2069 -
2070 -**Return:**
2071 -
2072 -Succeed: string, calculation result
2073 -
2074 -Failed: nil
2075 -
2076 -**For example:**
2077 -
2078 -{{code language="LUA"}}
2079 -local sha = require"sha2"
2080 -
2081 -function hmac_test.main()
2082 -
2083 -local hmac = sha.hmac
2084 -
2085 -print(hmac(sha.sha1,
2086 -
2087 -"your key", "your message"))
2088 -
2089 -end
2090 -{{/code}}
2091 -
2092 -== **sha(string message** ==
2093 -
2094 -**Function:** SHA calculate
2095 -
2096 -**Function name:**
2097 -
2098 -sha:
2099 -
2100 -* sha1, sha224, sha256, sha384, sha512]
2101 -* [sha512_224, sha512_256, sha3_224, sha3_256]
2102 -* [sha3_384, sha3_512]
2103 -
2104 -**Parameter:**
2105 -
2106 -key: the key
2107 -
2108 -message: message content
2109 -
2110 -**Return:**
2111 -
2112 -Succeed: string, calculation result
2113 -
2114 -Failed: nil
2115 -
2116 -For example:
2117 -
2118 -{{code language="LUA"}}
2119 -local sha = require"sha2"
2120 -
2121 -function sha_test.main()
2122 -
2123 -local sha256 = sha.sha256
2124 -
2125 -print(sha256("your message"))
2126 -
2127 -end
2128 -{{/code}}
1845 +Failed: multi