123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478 |
- <template>
- <a-card :bordered="false">
- <!-- 查询区域 -->
- <div class="table-page-search-wrapper">
- <a-form layout="inline">
- <a-row :gutter="24">
- <a-col :md="6" :sm="24">
- <a-form-item label="表名">
- <a-input placeholder="请输入表名" v-model="queryParam.tableName"></a-input>
- </a-form-item>
- </a-col>
- <a-col :md="6" :sm="24">
- <a-form-item label="表类型">
- <j-dict-select-tag dictCode="cgform_table_type" v-model="queryParam.tableType"/>
- </a-form-item>
- </a-col>
- <a-col :md="6" :sm="24">
- <span style="float: left;overflow: hidden;" class="table-page-search-submitButtons">
- <a-button type="primary" @click="searchQuery" icon="search">查询</a-button>
- <a-button type="primary" @click="searchReset" icon="reload" style="margin-left: 8px">重置</a-button>
- </span>
- </a-col>
- </a-row>
- </a-form>
- </div>
- <!-- 操作按钮区域 -->
- <div class="table-operator">
- <a-button @click="handleAdd" type="primary" icon="plus">新增</a-button>
- <a-button @click="doCgformButton" type="primary" icon="highlight" style="margin-left:8px">自定义按钮</a-button>
- <a-button @click="doEnhanceJs" type="primary" icon="strikethrough" style="margin-left:8px">JS增强</a-button>
- <a-button @click="doEnhanceSql" type="primary" icon="filter" v-has="'online:sql'" style="margin-left:8px">SQL增强</a-button>
- <a-button @click="doEnhanceJava" type="primary" icon="tool" style="margin-left:8px">Java增强</a-button>
- <a-button @click="importOnlineForm" type="primary" icon="database" style="margin-left:8px">从数据库导入表单</a-button>
- <a-button @click="goGenerateCode" v-has="'online:goGenerateCode'" type="primary" icon="database" style="margin-left:8px">代码生成</a-button>
- <a-dropdown v-if="selectedRowKeys.length > 0">
- <a-menu slot="overlay">
- <a-menu-item key="1" @click="batchDel">
- <a-icon type="delete"/>
- 删除
- </a-menu-item>
- </a-menu>
- <a-button style="margin-left: 8px"> 批量操作
- <a-icon type="down"/>
- </a-button>
- </a-dropdown>
- </div>
- <!-- table区域-begin -->
- <div>
- <div class="ant-alert ant-alert-info" style="margin-bottom: 16px;">
- <i class="anticon anticon-info-circle ant-alert-icon"></i>
- 已选择
- <a style="font-weight: 600">{{ selectedRowKeys.length }}</a>
- 项
- <a style="margin-left: 24px" @click="onClearSelected">清空</a>
- </div>
- <a-table
- ref="table"
- size="middle"
- bordered
- rowKey="id"
- :columns="columns"
- :dataSource="dataSource"
- :pagination="ipagination"
- :loading="loading"
- :rowSelection="{selectedRowKeys: selectedRowKeys, onChange: onSelectChange}"
- @change="handleTableChange">
- <template slot="action" slot-scope="text, record">
- <a @click="handleEdit(record)">编辑</a>
- <a-divider type="vertical"/>
- <a-dropdown>
- <a class="ant-dropdown-link">更多
- <a-icon type="down"/>
- </a>
- <a-menu slot="overlay">
- <a-menu-item v-if="record.isDbSynch!='Y'">
- <a @click="openSyncModal(record.id)">同步数据库</a>
- </a-menu-item>
- <template v-if="record.isDbSynch=='Y' && record.tableType !== 3">
- <a-menu-item>
- <a @click="goPageOnline(record)">功能测试</a>
- </a-menu-item>
- <a-menu-item>
- <a @click="handleOnlineUrlShow(record)">配置地址</a>
- </a-menu-item>
- </template>
- <a-menu-item>
- <a @click="copyConfig(record.id)">复制视图</a>
- </a-menu-item>
- <a-menu-item v-if="record.hascopy==1">
- <a @click="showMyCopyInfo(record.id)">配置视图</a>
- </a-menu-item>
- <a-menu-item>
- <a @click="handleRemoveRecord(record.id)">移除</a>
- </a-menu-item>
- <a-menu-item>
- <a-popconfirm title="确定删除吗?" @confirm="() => handleDelete(record.id)">
- <a>删除</a>
- </a-popconfirm>
- </a-menu-item>
- </a-menu>
- </a-dropdown>
- </template>
- <template slot="dbsync" slot-scope="text">
- <span v-if="text==='Y'" style="color:limegreen">已同步</span>
- <span v-if="text==='N'" style="color:red">未同步</span>
- </template>
- </a-table>
- </div>
- <!-- table区域-end -->
- <!-- 表单区域 -->
- <onl-cgform-head-modal ref="modalForm" @ok="modalFormOk"></onl-cgform-head-modal>
- <!-- 同步数据库提示框 -->
- <a-modal
- :width="500"
- :height="300"
- title="同步数据库"
- :visible="syncModalVisible"
- @cancel="handleCancleDbSync"
- style="top:5%;height: 95%;">
- <template slot="footer">
- <a-button @click="handleCancleDbSync">关闭</a-button>
- <a-button type="primary" :loading="syncLoading" @click="handleDbSync">
- 确定
- </a-button>
- </template>
- <a-radio-group v-model="synMethod">
- <a-radio style="display: block;width: 30px;height: 30px" value="normal">普通同步(保留表数据)</a-radio>
- <a-radio style="display: block;width: 30px;height: 30px" value="force">强制同步(删除表,重新生成)</a-radio>
- </a-radio-group>
- </a-modal>
- <!-- 提示online报表链接 -->
- <a-modal
- :title="onlineUrlTitle"
- :visible="onlineUrlVisible"
- @cancel="handleOnlineUrlClose">
- <template slot="footer">
- <a-button @click="handleOnlineUrlClose">关闭</a-button>
- <a-button type="primary" class="copy-this-text" :data-clipboard-text="onlineUrl" @click="onCopyUrl">复制</a-button>
- </template>
- <p>{{ onlineUrl }}</p>
- </a-modal>
- <enhance-js ref="ehjs"></enhance-js>
- <enhance-sql ref="ehsql"></enhance-sql>
- <enhance-java ref="ehjava"></enhance-java>
- <trans-db2-online ref="transd2o" @ok="transOk"></trans-db2-online>
- <code-generator ref="cg"></code-generator>
- <onl-cgform-button-list ref="btnList"></onl-cgform-button-list>
- </a-card>
- </template>
- <script>
- import { initDictOptions, filterDictText } from '@/components/dict/JDictSelectUtil'
- import { deleteAction, postAction } from '@/api/manage'
- import JDictSelectTag from '../../../../components/dict/JDictSelectTag.vue'
- import { JeecgListMixin } from '@/mixins/JeecgListMixin'
- import Clipboard from 'clipboard'
- import { filterObj } from '@/utils/util';
- export default {
- name: 'OnlCgformHeadList',
- mixins: [JeecgListMixin],
- components: {
- JDictSelectTag,
- },
- data() {
- return {
- description: 'Online表单开发管理页面',
- // 表头
- columns: [
- {
- title: '#',
- dataIndex: '',
- key: 'rowIndex',
- width: 60,
- align: 'center',
- customRender: function(t, r, index) {
- return parseInt(index) + 1
- }
- },
- {
- title: '表类型',
- align: 'center',
- dataIndex: 'tableType',
- customRender: (text) => {
- return filterDictText(this.tableTypeDictOptions, `${text}`)
- }
- },
- {
- title: '表名',
- align: 'center',
- dataIndex: 'tableName'
- },
- {
- title: '表描述',
- align: 'center',
- dataIndex: 'tableTxt'
- },
- {
- title: '版本',
- align: 'center',
- dataIndex: 'tableVersion'
- },
- {
- title: '同步数据库状态',
- align: 'center',
- dataIndex: 'isDbSynch',
- scopedSlots: { customRender: 'dbsync' }
- },
- {
- title: '操作',
- dataIndex: 'action',
- align: 'center',
- scopedSlots: { customRender: 'action' }
- }
- ],
- url: {
- list: '/online/cgform/head/list',
- delete: '/online/cgform/head/delete',
- deleteBatch: '/online/cgform/head/deleteBatch',
- doDbSynch: '/online/cgform/api/doDbSynch/',
- removeRecord: '/online/cgform/head/removeRecord',
- copyOnline: '/online/cgform/head/copyOnline'
- },
- tableTypeDictOptions: [],
- sexDictOptions: [],
- syncModalVisible: false,
- syncFormId: '',
- synMethod: 'normal',
- syncLoading: false,
- onlineUrlTitle: '',
- onlineUrlVisible: false,
- onlineUrl: '',
- selectedRowKeys: [],
- selectedRows: []
- }
- },
- created() {
- //初始化字典 - 表类型
- initDictOptions('cgform_table_type').then((res) => {
- if (res.success) {
- this.tableTypeDictOptions = res.result
- }
- })
- },
- methods: {
- doDbSynch(id) {
- postAction(this.url.doDbSynch + id, { synMethod: '1' }).then((res) => {
- if (res.success) {
- this.$message.success(res.message)
- this.loadData()
- } else {
- this.$message.warning(res.message)
- }
- })
- },
- getQueryParams() {
- //获取查询条件
- var param = Object.assign({}, this.queryParam, this.isorter ,this.filters);
- param.field = this.getQueryField();
- param.pageNo = this.ipagination.current;
- param.pageSize = this.ipagination.pageSize;
- param.copyType = 0;
- return filterObj(param);
- },
- handleCancleDbSync() {
- this.syncModalVisible = false
- },
- handleDbSync() {
- this.syncLoading = true
- postAction(this.url.doDbSynch + this.syncFormId + '/' + this.synMethod).then((res) => {
- this.syncModalVisible = false
- this.syncLoading = false
- if (res.success) {
- this.$message.success(res.message)
- this.loadData()
- } else {
- this.$message.warning(res.message)
- }
- })
- setTimeout(()=>{
- if(this.syncLoading){
- this.syncModalVisible = false
- this.syncLoading = false
- this.$message.success("网络延迟,已自动刷新!")
- this.loadData()
- }
- },10000)
- },
- openSyncModal(id) {
- this.syncModalVisible = true
- this.syncLoading = false
- this.syncFormId = id
- },
- goPageOnline(rd) {
- if(rd.isTree=='Y'){
- this.$router.push({ path: '/online/cgformTreeList/' + rd.id })
- }else{
- this.$router.push({ path: '/online/cgformList/' + rd.id })
- }
- },
- handleOnlineUrlClose() {
- this.onlineUrlTitle = ''
- this.onlineUrlVisible = false
- },
- handleOnlineUrlShow(record) {
- if(record.isTree=='Y'){
- this.onlineUrl = `/online/cgformTreeList/${record.id}`
- }else{
- this.onlineUrl = `/online/cgformList/${record.id}`
- }
- this.onlineUrlVisible = true
- this.onlineUrlTitle = '菜单链接[' + record.tableTxt + ']'
- },
- handleRemoveRecord(id) {
- let that = this
- this.$confirm({
- title: '确认要移除此记录?',
- onOk() {
- deleteAction(that.url.removeRecord, { id: id }).then((res) => {
- if (res.success) {
- that.$message.success('移除成功')
- that.loadData()
- } else {
- that.$message.warning(res.message)
- }
- })
- },
- onCancel() {
- }
- })
- },
- doEnhanceJs() {
- if (!this.selectedRowKeys || this.selectedRowKeys.length != 1) {
- this.$message.warning('请先选中一条记录')
- return
- }
- this.$refs.ehjs.show(this.selectedRowKeys[0])
- },
- doEnhanceSql() {
- if (!this.selectedRowKeys || this.selectedRowKeys.length != 1) {
- this.$message.warning('请先选中一条记录')
- return
- }
- this.$refs.ehsql.show(this.selectedRowKeys[0])
- },
- doEnhanceJava() {
- if (!this.selectedRowKeys || this.selectedRowKeys.length != 1) {
- this.$message.warning('请先选中一条记录')
- return
- }
- this.$refs.ehjava.show(this.selectedRowKeys[0])
- },
- doCgformButton() {
- if (!this.selectedRowKeys || this.selectedRowKeys.length != 1) {
- this.$message.warning('请先选中一条记录')
- return
- }
- this.$refs.btnList.show(this.selectedRowKeys[0])
- //this.$router.push({ path: '/online/cgformButton/' + this.selectedRowKeys[0] })
- },
- importOnlineForm() {
- this.$refs.transd2o.show()
- },
- transOk() {
- this.loadData()
- },
- goGenerateCode() {
- if (!this.selectedRowKeys || this.selectedRowKeys.length != 1) {
- this.$message.warning('请先选中一条记录')
- return
- }
- let row = this.selectedRows[0]
- if (!row.isDbSynch || row.isDbSynch == 'N') {
- this.$message.warning('请先同步数据库!')
- return
- }
- if (row.tableType == 3) {
- this.$message.warning('请选中该表对应的主表生成代码')
- return
- }
- this.$refs.cg.show(this.selectedRowKeys[0])
- },
- onSelectChange(keys, rows) {
- this.selectedRowKeys = keys
- this.selectedRows = rows
- },
- onCopyUrl(){
- var clipboard = new Clipboard('.copy-this-text')
- clipboard.on('success', () => {
- clipboard.destroy()
- this.$message.success('复制成功')
- this.handleOnlineUrlClose()
- })
- clipboard.on('error', () => {
- this.$message.error('该浏览器不支持自动复制')
- clipboard.destroy()
- })
- },
- showMyCopyInfo(id){
- this.$router.push({ path: '/online/copyform/' + id })
- },
- copyConfig(id){
- postAction(`${this.url.copyOnline}?code=${id}`).then(res=>{
- if(res.success){
- this.$message.success("复制成功")
- this.loadData()
- }else{
- this.$message.error("复制失败>>"+res.message)
- }
- })
- }
- }
- }
- </script>
- <style lang="less">
- .ant-card-body .table-operator {
- margin-bottom: 18px;
- }
- .ant-table-tbody .ant-table-row td {
- padding-top: 15px;
- padding-bottom: 15px;
- }
- .anty-row-operator button {
- margin: 0 5px
- }
- .ant-btn-danger {
- background-color: #ffffff
- }
- .ant-modal-cust-warp {
- height: 100%
- }
- .ant-modal-cust-warp .ant-modal-body {
- height: calc(100% - 110px) !important;
- overflow-y: auto
- }
- .ant-modal-cust-warp .ant-modal-content {
- height: 90% !important;
- overflow-y: hidden
- }
- .valid-error-cust{
- .ant-select-selection{
- border:2px solid #f5222d;
- }
- }
- </style>
|