From 5e6ca455c750b289781cecf9155a5bf2c2c39b0e Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期一, 19 六月 2023 14:39:05 +0800
Subject: [PATCH] 更改getSqlByValue方法

---
 Source/UBCS-WEB/src/components/advanced-query/advancedQuery.vue |   78 +++++++++++++++++++++++++++++++-------
 1 files changed, 63 insertions(+), 15 deletions(-)

diff --git a/Source/UBCS-WEB/src/components/advanced-query/advancedQuery.vue b/Source/UBCS-WEB/src/components/advanced-query/advancedQuery.vue
index b6354df..28c5d8a 100644
--- a/Source/UBCS-WEB/src/components/advanced-query/advancedQuery.vue
+++ b/Source/UBCS-WEB/src/components/advanced-query/advancedQuery.vue
@@ -52,7 +52,8 @@
                         <div class="grid-content">
                             <el-select placeholder="璇烽�夋嫨" v-model="searchFormArrays[index].condition">
                                 <el-option
-                                    v-for="condition in item.fieldType=='text' ? searchConditions:switchSearchConditions"
+                                    v-for="condition in item.fieldType==='text' || item.fieldType==='combox' ? 
+                                    item.fieldType==='text' ? searchConditions:switchSearchConditions:dateConditions"
                                     :key="condition.value"
                                     :label="condition.label"
                                     :value="condition.value">
@@ -62,8 +63,8 @@
                     </el-col>
                     <el-col :span="12">
                         <div class="grid-content">
-                            <el-input v-if="item.fieldType==='text' || item.fieldType===''" v-model="searchFormArrays[index].fieldValue" type="text" placeholder="璇疯緭鍏�"></el-input>
-                            <el-select v-else-if="item.fieldType==='combox'" v-model="searchFormArrays[index].fieldValue" placeholder="璇烽�夋嫨">
+                            <el-input v-if="item.fieldType==='text' || item.fieldType===''" v-model="searchFormArrays[index].fieldValue" type="text" placeholder="璇疯緭鍏�" :display="item.display"></el-input>
+                            <el-select v-else-if="item.fieldType==='combox'" v-model="searchFormArrays[index].fieldValue" placeholder="璇烽�夋嫨" :display="item.display">
                                 <el-option
                                     v-for="option in item.data"
                                     :key="option.itemValue"
@@ -71,7 +72,20 @@
                                     :value="option.itemValue">
                                 </el-option>
                             </el-select>
-                            <el-switch  v-else-if="item.fieldType==='truefalse'" v-model="searchFormArrays[index].fieldValue"></el-switch>
+                            <el-switch v-else-if="item.fieldType==='truefalse'" v-model="searchFormArrays[index].fieldValue" :display="item.display"></el-switch>
+                            <el-date-picker v-else-if="item.fieldType==='datetime'" :display="item.display"
+                                v-model="searchFormArrays[index].fieldValue"
+                                type="date"
+                                placeholder="閫夋嫨鏃ユ湡">
+                            </el-date-picker>
+                            <vci-web-refer
+                                v-else-if="item.fieldType==='refer'"
+                                :referConfig="item.referConfigData || {}"
+                                :value="searchFormArrays[index].fieldValue"
+                                :disabled="item.referConfig.showField"
+                                :display="item.display"
+                                @setReferValue="setReferValue">
+                            </vci-web-refer>
                         </div>
                     </el-col>
                     <el-col :span="2">
@@ -87,7 +101,9 @@
 
 <script>
 import { getDictionary } from "@/api/omd/enum";
+import vciWebRefer from '../refer/vciWebRefer.vue';
 export default {
+  components: { vciWebRefer },
     name: "advancedQuery",
     props: {
         // 瀵硅瘽妗嗘樉绀洪殣钘忔帶鍒�
@@ -106,7 +122,7 @@
             // 瀵硅瘽妗嗘樉绀烘帶鍒�
             isShowDialog: this.visible,
             initOptions: [],
-            // 瀛楁鏄緭鍏ユ绫诲瀷鐨勬潯浠舵暟缁�
+            // 瀛楁绫诲瀷鏄緭鍏ユ绫诲瀷鐨勬潯浠舵暟缁�
             searchConditions: [
                 {
                     value: "_equal",
@@ -120,15 +136,9 @@
                 },{
                     value: "_notlike",
                     label: "涓嶅寘鍚�",
-                },{
-                    value: "_ge", //澶т簬锛岄粯璁や负澶т簬绛変簬
-                    label: "澶т簬", 
-                },{
-                    value: "_le", //灏忎簬锛岄粯璁や负灏忎簬绛変簬
-                    label: "灏忎簬",
-                },
+                }
             ],
-            // 瀛楁鏄崟閫夋垨涓嬫媺妗嗙被鍨嬬殑鏉′欢鏁扮粍
+            // 瀛楁绫诲瀷鏄崟閫夋垨涓嬫媺妗嗙被鍨嬬殑鏉′欢鏁扮粍
             switchSearchConditions: [
                 {
                     value: "_equal",
@@ -137,6 +147,22 @@
                     value: "_notequal",
                     label: "涓嶇瓑浜�",
                 }
+            ],
+            // 瀛楁绫诲瀷鏄棩鏈�
+            dateConditions: [
+                {
+                    value: "_equal",
+                    label: "绛変簬",
+                },{
+                    value: "_notequal",
+                    label: "涓嶇瓑浜�",
+                },{
+                    value: "_ge", //澶т簬锛岄粯璁や负澶т簬绛変簬
+                    label: "澶т簬", 
+                },{
+                    value: "_le", //灏忎簬锛岄粯璁や负灏忎簬绛変簬
+                    label: "灏忎簬",
+                },
             ],
             searchFormArrays: [],
             fieldValue: '',
@@ -164,6 +190,16 @@
                             localStorage.setItem(item.comboxKey,JSON.stringify(res.data.data));
                         })
                     }
+                }else if(item.fieldType==='refer'){
+                    item = Object.assign(item,{referConfigData:{
+                        title: item.referConfig.textField,
+                        showField: item.showField || item.field,
+                        field: item.field,
+                        placeholder: item.inputTip || '',
+                        options: item.referConfig,
+                    }})
+                    //console.log(item.referConfigData.options.type);
+                    //console.log(item);   
                 }
                 let add = {
                     queryField: String(item.queryField),
@@ -172,10 +208,19 @@
                 }
                 this.searchFormArrays.push(add)
             });
+            console.log(this.initOptions);
             //console.log(this.searchFormArrays);
         }
     },
     methods: {
+
+        /** 涓哄弬鐓х被鍨嬫椂鍊奸�夋嫨涔嬪悗鐨勫鐞� */
+        setReferValue(data){
+            // if(data.field) {
+               
+            // }
+            //console.log(data);
+        },
 
         // 灞炴�у垏鎹㈡椂鏌ヨ鏉′欢鍜屾煡璇㈠�间篃闇�瑕佸杈撳叆妗嗚繘琛屽垏鎹�
         // changeField(index) {
@@ -236,7 +281,7 @@
             const searchConditions = this.searchFormArrays;
             for(let index = 0; index < searchConditions.length; index++) {
                 //console.log(condtionParam['conditionMap['+searchConditions[index].queryField+']']+'' == 'undefined');
-                if(searchConditions[index].fieldValue.trim() != '' || searchConditions[index].fieldValue+''==='false') {
+                if(searchConditions[index].fieldValue+'' != '' || searchConditions[index].fieldValue+''==='false') {
                     // 瀛樺湪鐩稿悓鐨勬煡璇㈡潯浠�
                     if(condtionParam['conditionMap['+searchConditions[index].queryField+']']+'' != 'undefined' ) {
                         this.$message.warning("瀛樺湪閲嶅鏌ヨ鏉′欢锛岃浠旂粏鏍稿!");
@@ -247,7 +292,7 @@
                     condtionParam['conditionMap['+searchConditions[index].queryField+searchConditions[index].condition+']'] = searchConditions[index].fieldValue;
                 }
             }
-            // 鏌ヨ鏉′欢娌℃湁鍑虹幇閲嶅灞炴�э紝骞朵笖杩囨护鎺変簡绌哄�硷紝浼犻�掔粰鐖剁粍浠�
+            // 鏌ヨ鏉′欢娌℃湁鍑虹幇閲嶅灞炴�э紝骞朵笖杩囨护鎺変簡绌哄�硷紝灏变紶閫掔粰鐖剁粍浠�
             // console.log(condtionParam);
             this.$emit('echoContion',condtionParam)
             this.isShowDialog = false;
@@ -316,6 +361,9 @@
         line-height: 40px;
         height: 40px;
     }
+    .grid-content > .el-date-editor.el-input, .el-date-editor.el-input__inner{
+        width: 100%;
+    }
 
 
 </style>
\ No newline at end of file

--
Gitblit v1.9.3