| 1 |
- (self["webpackChunkyos_manage"]=self["webpackChunkyos_manage"]||[]).push([[188],{188:function(e,t,a){"use strict";a.r(t),a.d(t,{default:function(){return v}});var n=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)},s=[],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,n){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(n){return a("el-table-column",{attrs:{label:t.columnsmate?t.columnsmate[n].column_title:"","header-align":"center"}},[a("el-table-column",{attrs:{prop:n,label:n,"header-align":"center",width:e.getColumnWitd(t.columnsmate[n]),align:e.getColumnAlign(t.columnsmate[n]),"show-overflow-tooltip":""},scopedSlots:e._u([{key:"default",fn:function(t){return[a("div",{staticStyle:{"font-size":"10px"}},[e._v(" "+e._s(t.row[n])+" ")])]}}],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)},l=[],i=(a(8309),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=[],c=a(6198),u=(a(5666),a(1249),{props:["data"],data:function(){return{}},methods:{exportExcel:function(){var e=this;return(0,c.Z)(regeneratorRuntime.mark((function t(){var n;return regeneratorRuntime.wrap((function(t){while(1)switch(t.prev=t.next){case 0:0!==e.data.datarows.length&&(n=function(e,t){return t.map((function(t){return e.map((function(e){return t[e]}))}))},Promise.all([a.e(779),a.e(783)]).then(function(){var t=a(6162),s=t.export_json_to_excel,r=e.data.columns,l=e.data.columns,i=e.data.datarows,o=n(l,i);s(r,o,"数据查询"+Date.now(),"Sheet1")}.bind(null,a))["catch"](a.oe));case 1:case"end":return t.stop()}}),t)})))()}}}),p=u,m=a(1001),d=(0,m.Z)(p,i,o,!1,null,null,null),y=d.exports,h={components:{exportdataimportmodel:y},data:function(){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:function(){var 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:function(e){this.currentTab=this.currentTabs[e.index]},query_dayakey:function(){var e=this;this.$api.requested(this.query_datakey_param).then((function(t){e.datakeys=t.data}))},query_sqltemplet:function(){var e=this;this.$api.requested(this.query_sqltemplet_param).then((function(t){e.sqltemplets=t.data}))},sqltempletselect:function(e){var t=this;this.query_sqltempletsql_param.content.sys_dataquery_sqltempletid=e,this.$api.requested(this.query_sqltempletsql_param).then((function(a){t.currentTab.sql=a.data.sqlstr,t.currentTab.datakey=a.data.datakey,t.currentTab.sys_dataquery_sqltempletid=e}))},deletesqltemplet:function(e){var t=this;this.delete_sqltempletsql_param.content.sys_dataquery_sqltempletid=e,this.$api.requested(this.delete_sqltempletsql_param).then((function(e){t.query_sqltemplet()}))},insertsqltemplet:function(){var e=this;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((function(t){e.query_sqltemplet()})),this.insertsqltempletdialog=!1):alert("请填写模板名称！")},listData:function(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((function(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(var a=0;a<e.pageSize;a++)e.pagerows[a]=e.datarows[a];e.errmsg=""}else e.errmsg=t.msg}))},getColumnWitd:function(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:function(e){return"Long"===e.fieldtype||"BigDecimal"===e.fieldtype?"right":"Integer"===e.fieldtype||"status"===e.column_name||"type"===e.column_name?"center":"left"},handleSizeChange:function(e){this.currentTab.pageSize=e,this.currentTab.currentPage=1,this.handleCurrentChange(1)},handleCurrentChange:function(e){if(this.currentTab.total<=this.currentTab.pageSize)this.currentTab.pagerows=this.currentTab.datarows;else{this.currentTab.pagerows=[];for(var t=0;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:function(e){sessionStorage.setItem("dataquery"+this.currentTab.name,e),sessionStorage.setItem("datakey"+this.currentTab.name,this.currentTab.datakey)}},mounted:function(){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()}},f=h,g=(0,m.Z)(f,r,l,!1,null,"1b5a890c",null),q=g.exports,b={components:{list:q},methods:{onSuccess:function(){this.$refs.list.listData()}}},_=b,x=(0,m.Z)(_,n,s,!1,null,"63bef66e",null),v=x.exports},2092:function(e,t,a){var n=a(9974),s=a(1702),r=a(8361),l=a(7908),i=a(6244),o=a(5417),c=s([].push),u=function(e){var t=1==e,a=2==e,s=3==e,u=4==e,p=6==e,m=7==e,d=5==e||p;return function(y,h,f,g){for(var q,b,_=l(y),x=r(_),v=n(h,f),S=i(x),k=0,T=g||o,w=t?T(y,S):a||m?T(y,0):void 0;S>k;k++)if((d||k in x)&&(q=x[k],b=v(q,k,_),e))if(t)w[k]=b;else if(b)switch(e){case 3:return!0;case 5:return q;case 6:return k;case 2:c(w,q)}else switch(e){case 4:return!1;case 7:c(w,q)}return p?-1:s||u?u:w}};e.exports={forEach:u(0),map:u(1),filter:u(2),some:u(3),every:u(4),find:u(5),findIndex:u(6),filterReject:u(7)}},7475:function(e,t,a){var n=a(7854),s=a(3157),r=a(4411),l=a(111),i=a(5112),o=i("species"),c=n.Array;e.exports=function(e){var t;return s(e)&&(t=e.constructor,r(t)&&(t===c||s(t.prototype))?t=void 0:l(t)&&(t=t[o],null===t&&(t=void 0))),void 0===t?c:t}},5417:function(e,t,a){var n=a(7475);e.exports=function(e,t){return new(n(e))(0===t?0:t)}},1249:function(e,t,a){"use strict";var n=a(2109),s=a(2092).map,r=a(1194),l=r("map");n({target:"Array",proto:!0,forced:!l},{map:function(e){return s(this,e,arguments.length>1?arguments[1]:void 0)}})},8309:function(e,t,a){var n=a(9781),s=a(6530).EXISTS,r=a(1702),l=a(3070).f,i=Function.prototype,o=r(i.toString),c=/function\b(?:\s|\/\*[\S\s]*?\*\/|\/\/[^\n\r]*[\n\r]+)*([^\s(/]*)/,u=r(c.exec),p="name";n&&!s&&l(i,p,{configurable:!0,get:function(){try{return u(c,o(this))[1]}catch(e){return""}}})}}]);
|
