| 1 |
- "use strict";(self["webpackChunkyos_manage"]=self["webpackChunkyos_manage"]||[]).push([[188],{188:function(e,t,a){a.r(t),a.d(t,{default:function(){return x}});var s=function(){var e=this,t=e.$createElement,a=e._self._c||t;return a("div",{staticClass:"container"},[a("el-row",{attrs:{gutter:40}},[a("list",{ref:"list"})],1)],1)},l=[],r=function(){var e=this,t=e.$createElement,a=e._self._c||t;return a("div",[a("el-tabs",{attrs:{type:"card",addable:""},on:{"tab-click":e.clickTab,"tab-add":function(t){return e.addTab()}},model:{value:e.currentTabName,callback:function(t){e.currentTabName=t},expression:"currentTabName"}},e._l(e.currentTabs,(function(t,s){return a("el-tab-pane",{key:t.name,attrs:{label:t.title,name:t.name}},[a("div",{staticStyle:{"margin-bottom":"10px"}},[a("div",{staticStyle:{display:"flex"}},[a("el-select",{staticStyle:{width:"120px",margin:"0px 0px 10px 10px"},attrs:{size:"mini",placeholder:"请选择",filterable:""},model:{value:e.currentTab.datakey,callback:function(t){e.$set(e.currentTab,"datakey",t)},expression:"currentTab.datakey"}},e._l(e.datakeys,(function(e){return a("el-option",{key:e.datakey,staticStyle:{"font-size":"10px"},attrs:{label:e.datakey,value:e.datakey}})})),1),a("el-button",{staticClass:"el-icon-caret-right",staticStyle:{color:"orange",margin:"0px 0px 10px 10px"},attrs:{size:"mini"},on:{click:function(a){return e.listData(t)}}},[e._v("执行 ")]),a("exportdataimportmodel",{staticStyle:{"margin-left":"10px"},attrs:{data:t}}),a("div",{staticStyle:{width:"100%","text-align":"right"}},[a("el-button",{staticClass:"el-icon-upload",staticStyle:{color:"orange",margin:"0px 0px 10px 10px"},attrs:{size:"mini"},on:{click:function(t){e.insertsqltempletdialog=!0}}},[e._v("存为SQL模板 ")]),a("el-dialog",{staticStyle:{"margin-top":"70px"},attrs:{visible:e.insertsqltempletdialog,"append-to-body":"",model:e.form,width:"500px"},on:{"update:visible":function(t){e.insertsqltempletdialog=t}}},[a("el-form",{attrs:{"label-position":"left","label-width":"70px",model:e.form,size:"mini"}},[a("el-row",[a("el-form-item",{attrs:{label:"模版名称"}},[a("el-input",{staticStyle:{width:"90%"},attrs:{placeholder:"请输入"},model:{value:e.sqltempletname,callback:function(t){e.sqltempletname=t},expression:"sqltempletname"}})],1)],1),a("el-row",{staticStyle:{"text-align":"center","margin-top":"50px"}},[a("el-button",{attrs:{size:"mini",type:"primary"},on:{click:function(t){return e.insertsqltemplet()}}},[e._v("保 存 ")]),a("el-button",{staticStyle:{"margin-left":"20px"},attrs:{size:"mini",type:"primary"},on:{click:function(t){e.insertsqltempletdialog=!1}}},[e._v("关闭 ")])],1)],1)],1),a("el-select",{staticStyle:{width:"250px",margin:"0px 30px 10px 10px"},attrs:{size:"mini",placeholder:"请选择",filterable:""},on:{change:e.sqltempletselect},model:{value:e.currentTab.sys_dataquery_sqltempletid,callback:function(t){e.$set(e.currentTab,"sys_dataquery_sqltempletid",t)},expression:"currentTab.sys_dataquery_sqltempletid"}},e._l(e.sqltemplets,(function(t){return a("el-option",{key:t.sys_dataquery_sqltempletid,staticStyle:{"font-size":"10px"},attrs:{label:t.templetname,value:t.sys_dataquery_sqltempletid}},[a("span",{staticStyle:{float:"left"}},[e._v(e._s(t.templetname))]),a("span",{staticStyle:{float:"right",color:"#8492a6","font-size":"13px"}},[a("el-popconfirm",{attrs:{title:"确定删除该SQL查询模版吗？"},on:{confirm:function(a){return e.deletesqltemplet(t.sys_dataquery_sqltempletid)}}},[a("el-button",{attrs:{slot:"reference",type:"text",icon:"el-icon-delete"},on:{click:function(e){e.stopPropagation()}},slot:"reference"})],1)],1)])})),1)],1)],1),a("el-input",{staticStyle:{width:"98%","margin-left":"10px"},attrs:{size:"small",type:"textarea",placeholder:"请输入查询语句",autosize:{minRows:10,maxRows:20}},on:{input:e.SQLChanged},model:{value:t.sql,callback:function(a){e.$set(t,"sql",a)},expression:"query.sql"}})],1),""!==t.errmsg?a("div",{staticStyle:{color:"red",margin:"0px 0px 10px 10px","font-size":"12px"}},[e._v(" "+e._s(t.errmsg)+" ")]):e._e(),a("el-table",{staticStyle:{width:"98%",margin:"10px 10px 10px 10px"},attrs:{data:t.pagerows,size:"mini","highlight-current-row":"",border:"","max-height":"1000px","header-cell-style":{background:"#f1f2f3",color:"#333"}}},[a("el-table-column",{attrs:{prop:"rowindex",label:"",width:"60px",align:"center",fixed:"",resizable:!1}}),e._l(t.columns,(function(s){return a("el-table-column",{attrs:{label:t.columnsmate?t.columnsmate[s].column_title:"","header-align":"center"}},[a("el-table-column",{attrs:{prop:s,label:s,"header-align":"center",width:e.getColumnWitd(t.columnsmate[s]),align:e.getColumnAlign(t.columnsmate[s]),"show-overflow-tooltip":""},scopedSlots:e._u([{key:"default",fn:function(t){return[a("div",{staticStyle:{"font-size":"10px"}},[e._v(" "+e._s(t.row[s])+" ")])]}}],null,!0)})],1)}))],2),a("div",{staticStyle:{margin:"20px 0","text-align":"right"}},[a("el-pagination",{attrs:{background:"",small:"","current-page":t.currentPage,"page-sizes":t.pageSizes,"page-size":t.pageSize,layout:"sizes,total, prev, pager, next, jumper",total:t.total},on:{"size-change":e.handleSizeChange,"current-change":e.handleCurrentChange,"update:pageSizes":function(a){return e.$set(t,"pageSizes",a)},"update:page-sizes":function(a){return e.$set(t,"pageSizes",a)}}})],1)],1)})),1)],1)},n=[],i=function(){var e=this,t=e.$createElement,a=e._self._c||t;return a("div",[a("el-button",{staticStyle:{color:"gray"},attrs:{size:"mini"},on:{click:function(t){return e.exportExcel()}}},[e._v("导出Excel")])],1)},o=[],p={props:["data"],data(){return{}},methods:{async exportExcel(){if(0!==this.data.datarows.length){let e=function(e,t){return t.map((t=>e.map((e=>t[e]))))};Promise.all([a.e(18),a.e(162)]).then((()=>{const{export_json_to_excel:t}=a(6162),s=this.data.columns,l=this.data.columns,r=this.data.datarows,n=e(l,r);t(s,n,"数据查询"+Date.now(),"Sheet1")}).bind(null,a))["catch"](a.oe)}}}},c=p,m=a(1001),u=(0,m.Z)(c,i,o,!1,null,null,null),d=u.exports,y={components:{exportdataimportmodel:d},data(){return{param:{classname:"sysmanage.develop.sys_object.sys_object",method:"dataquery",content:{sql:"",datakey:"default"}},query_datakey_param:{classname:"sysmanage.develop.optiontype.optiontype",method:"optiontypeselect",content:{pageNumber:1,pageSize:2e3,typename:"datakeyselect",parameter:{}}},query_sqltemplet_param:{classname:"sysmanage.develop.optiontype.optiontype",method:"optiontypeselect",content:{pageNumber:1,pageSize:2e3,typename:"dataquerysqltemplet",parameter:{}}},query_sqltempletsql_param:{classname:"sysmanage.develop.sys_object.sys_object",method:"queryTempletSQL",content:{sys_dataquery_sqltempletid:1}},delete_sqltempletsql_param:{classname:"sysmanage.develop.sys_object.sys_object",method:"deleteTempletSQL",content:{sys_dataquery_sqltempletid:1}},insert_sqltempletsql_param:{classname:"sysmanage.develop.sys_object.sys_object",method:"insertTempletSQL",content:{templetname:"",datakey:"",sqlstr:""}},datakeys:[],sqltemplets:[],currentTabName:"1",currentTabs:[{title:"查询 1",name:"1",datarows:[],pagerows:[],columns:[],columnsmate:{},sql:"",datakey:"default",sys_dataquery_sqltempletid:"",errmsg:"",total:0,currentPage:1,pageSize:20,pageSizes:[20,50,100,250,500,1e3]}],currentTab:{datakey:"default"},maxtabid:1,insertsqltempletdialog:!1,sqltempletname:""}},methods:{addTab(){let e=++this.maxtabid+"";this.currentTabs.push({title:"查询 "+e,name:e,datarows:[],pagerows:[],columns:[],columnsmate:{},sql:"",datakey:"default",sys_dataquery_sqltempletid:"",errmsg:"",total:0,currentPage:1,pageSize:20,pageSizes:[20,50,100,250,500,1e3]}),this.currentTabName=e,this.currentTab=this.currentTabs[this.currentTabs.length-1]},clickTab(e){this.currentTab=this.currentTabs[e.index]},query_dayakey(){this.$api.requested(this.query_datakey_param).then((e=>{this.datakeys=e.data}))},query_sqltemplet(){this.$api.requested(this.query_sqltemplet_param).then((e=>{this.sqltemplets=e.data}))},sqltempletselect(e){this.query_sqltempletsql_param.content.sys_dataquery_sqltempletid=e,this.$api.requested(this.query_sqltempletsql_param).then((t=>{this.currentTab.sql=t.data.sqlstr,this.currentTab.datakey=t.data.datakey,this.currentTab.sys_dataquery_sqltempletid=e}))},deletesqltemplet(e){this.delete_sqltempletsql_param.content.sys_dataquery_sqltempletid=e,this.$api.requested(this.delete_sqltempletsql_param).then((e=>{this.query_sqltemplet()}))},insertsqltemplet(){this.insert_sqltempletsql_param.content.templetname=this.sqltempletname,""!==this.sqltempletname?(this.insert_sqltempletsql_param.content.datakey=this.currentTab.datakey,this.insert_sqltempletsql_param.content.sqlstr=this.currentTab.sql,this.$api.requested(this.insert_sqltempletsql_param).then((e=>{this.query_sqltemplet()})),this.insertsqltempletdialog=!1):alert("请填写模板名称！")},listData(e){e.datarows=[],e.pagerows=[],e.columns=[],e.columnsmate={},this.param.content.sql=e.sql,this.param.content.datakey=e.datakey,this.$api.requested(this.param).then((t=>{if(1===t.code){if(e.datarows=t.data.rows,e.columns=t.data.columns,e.columnsmate=t.data.columnsmeta,e.total=e.datarows.length,e.currentPage=1,e.total<=e.pageSize)e.pagerows=e.datarows;else for(let t=0;t<e.pageSize;t++)e.pagerows[t]=e.datarows[t];e.errmsg=""}else e.errmsg=t.msg}))},getColumnWitd(e){return"Date"===e.fieldtype?150:"Long"===e.fieldtype||"BigDecimal"===e.fieldtype||"Integer"===e.fieldtype||50===e.precision?100:"String"===e.fieldtype?200:0},getColumnAlign(e){return"Long"===e.fieldtype||"BigDecimal"===e.fieldtype?"right":"Integer"===e.fieldtype||"status"===e.column_name||"type"===e.column_name?"center":"left"},handleSizeChange(e){this.currentTab.pageSize=e,this.currentTab.currentPage=1,this.handleCurrentChange(1)},handleCurrentChange(e){if(this.currentTab.total<=this.currentTab.pageSize)this.currentTab.pagerows=this.currentTab.datarows;else{this.currentTab.pagerows=[];let t=0;for(;t<this.currentTab.pageSize;){if(!(this.currentTab.total>(e-1)*this.currentTab.pageSize+t))break;this.currentTab.pagerows[t]=this.currentTab.datarows[(e-1)*this.currentTab.pageSize+t],t+=1}}},SQLChanged(e){sessionStorage.setItem("dataquery"+this.currentTab.name,e),sessionStorage.setItem("datakey"+this.currentTab.name,this.currentTab.datakey)}},mounted(){this.currentTab=this.currentTabs[0],this.currentTab.sql=sessionStorage.getItem("dataquery"+this.currentTab.name),this.currentTab.datakey=sessionStorage.getItem("datakey"+this.currentTab.name),this.query_dayakey(),this.query_sqltemplet()}},h=y,g=(0,m.Z)(h,r,n,!1,null,"1b5a890c",null),q=g.exports,b={components:{list:q},methods:{onSuccess(){this.$refs.list.listData()}}},_=b,f=(0,m.Z)(_,s,l,!1,null,"63bef66e",null),x=f.exports}}]);
|
