From 3a675efd3a8883f23208cefd39e0e871bf57a70b Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 31 八月 2023 10:21:29 +0800
Subject: [PATCH] 2023-08-31

---
 src/views/billprint/index.jsx |   33 +++++++++++++++++++++++++++------
 1 files changed, 27 insertions(+), 6 deletions(-)

diff --git a/src/views/billprint/index.jsx b/src/views/billprint/index.jsx
index a245790..c46417f 100644
--- a/src/views/billprint/index.jsx
+++ b/src/views/billprint/index.jsx
@@ -719,16 +719,11 @@
       _dataresource = `select top 1000 ${setting.arr_field} from ${_dataresource} `
     }
 
-    // 娴嬭瘯绯荤粺鎵撳嵃鏌ヨ璇彞
-    if (window.GLOB.debugger === true) {
-      _customScript &&  console.info(`${_dataresource ? '' : '/*涓嶆墽琛岄粯璁ql*/\n'}${_customScript}`)
-      _dataresource &&  console.info(_dataresource)
-    }
-
     return {
       name: dataName,
       columns: columns,
       par_tablename: '',
+      order: setting.order || '',
       type: format === 'array' ? format : '',
       primaryKey: setting.primaryKey || '',
       foreign_key: '',
@@ -755,6 +750,18 @@
     let district = sessionStorage.getItem('district') || ''
     let address = sessionStorage.getItem('address') || ''
 
+    let regoptions = [
+      { reg: /@pageSize@/ig, value: 9999 },
+      { reg: /@pageIndex@/ig, value: 1},
+      { reg: /@ID@/ig, value: `''`},
+      { reg: /@BID@/ig, value: `'${BID || ''}'`},
+      { reg: /@LoginUID@/ig, value: `'${sessionStorage.getItem('LoginUID') || ''}'`},
+      { reg: /@SessionUid@/ig, value: `'${localStorage.getItem('SessionUid') || ''}'`},
+      { reg: /@UserID@/ig, value: `'${sessionStorage.getItem('UserID') || ''}'`},
+      { reg: /@Appkey@/ig, value: `'${window.GLOB.appkey || ''}'`},
+      { reg: /@typename@/ig, value: `'admin'`},
+    ]
+
     let LText = params.map((item, index) => {
       let _sql = item.sql
       let _script = item.script
@@ -766,6 +773,20 @@
         `
       }
 
+      _sql = _sql.replace(/@orderBy@/ig, item.order)
+      _script = _script.replace(/@orderBy@/ig, item.order)
+      
+      regoptions.forEach(cell => {
+        _sql = _sql.replace(cell.reg, cell.value)
+        _script = _script.replace(cell.reg, cell.value)
+      })
+
+      // 娴嬭瘯绯荤粺鎵撳嵃鏌ヨ璇彞
+      if (window.GLOB.debugger === true) {
+        _script && console.info(`${_sql ? '' : '/*涓嶆墽琛岄粯璁ql*/\n'}${_script}`)
+        _sql &&  console.info(_sql)
+      }
+
       item.columns.forEach(cell => {
         LText_field.push(`Select '${item.name}' as tablename,'${cell.field}' as fieldname,'${cell.datatype}' as field_type`)
       })

--
Gitblit v1.8.0