bindData.vue 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  1. <template>
  2. <div class="binddata__panel">
  3. <el-tabs v-model="activeName">
  4. <el-tab-pane label="绑定数据字段" name="first"></el-tab-pane>
  5. <el-tab-pane label="数据集" name="second"></el-tab-pane>
  6. </el-tabs>
  7. <div v-if="activeName === 'first'">
  8. <div v-for="(item,idx) in panels" :key="idx" class="mt-10">
  9. <div v-if="item.printElementType.type === 'text'">
  10. <p class="preview__item">{{item.options.title}}</p>
  11. <el-select size="mini" v-model="item.options.sys_printdatasetid" placeholder="请选择" @click.native="act_DataBaseID = idx">
  12. <el-option
  13. v-for="i in databastlist"
  14. :key="i.sys_printdatasetid"
  15. :label="i.datasetname"
  16. :value="i.sys_printdatasetid"
  17. @click.native="queryDataBaseDetail(i.sys_printdatasetid)"
  18. @visible-change="visibleChange">
  19. </el-option>
  20. </el-select>&nbsp;
  21. <el-select size="mini" v-model="item.options.field" :disabled="idx !== act_DataBaseID" placeholder="请选择" @change="onChange">
  22. <el-option
  23. v-for="i in sys_printdataset"
  24. :key="i.sys_printdataset_columnsid"
  25. :label="i.column_name"
  26. :value="i.column_name"
  27. @visible-change="visibleChange">
  28. </el-option>
  29. </el-select>
  30. </div>
  31. <div v-if="item.printElementType.type === 'table'">
  32. <p style="font-size:12px">表格数据</p>
  33. <div>
  34. <el-select size="mini" v-model="item.options.sys_printdatasetid" placeholder="请选择" @click.native="act_DataBaseID = idx" @change="queryDataBaseDetail">
  35. <el-option
  36. v-for="i in databastlist"
  37. :key="i.sys_printdatasetid"
  38. :label="i.datasetname"
  39. :value="i.sys_printdatasetid"
  40. @click.native="setTableField(item.options.field = `dataset${i.sys_printdatasetid}`)">
  41. </el-option>
  42. </el-select>&nbsp;
  43. <div v-for="td in item.options.columns[0]" :key="td.index">
  44. <p class="preview__item">{{td.title}}</p>
  45. <el-select size="mini" v-model="td.field" :disabled="idx !== act_DataBaseID" placeholder="请选择" @change="onChange">
  46. <el-option
  47. v-for="i in sys_printdataset"
  48. :key="i.sys_printdataset_columnsid"
  49. :label="i.column_name"
  50. :value="i.column_name"
  51. @visible-change="visibleChange">
  52. </el-option>
  53. </el-select>
  54. </div>
  55. </div>
  56. </div>
  57. </div>
  58. <el-button type="primary" size="mini" @click="saveJson">保 存</el-button>
  59. </div>
  60. <div v-else>
  61. <el-tag style="margin:0 10px 10px 0" type="danger" v-for="item in databastlist" :key="item.index" :disable-transitions="true" effect="dark" size="small" @close="deleteDatabase(item)" closable> {{item.datasetname}}</el-tag>
  62. <div class="normal-margin">
  63. <el-input style="margin-bottom:10px" size="small" v-model="database.datasetname" placeholder="请输入数据集名称"></el-input>
  64. <el-input size="small" type="textarea" v-model="database.sqlstr" placeholder="请输入sql语句" :autosize="{ minRows: 3, maxRows: 6 }"></el-input>
  65. </div>
  66. <el-button type="primary" size="small" @click="saveDatabase">保存</el-button>
  67. </div>
  68. </div>
  69. </template>
  70. <script>
  71. export default {
  72. props:['temp','modeData'],
  73. computed:{
  74. formComponent(){
  75. if (this.dialogFormVisible) {
  76. return ()=>import(`@/style/sv-print.css`)
  77. } else {
  78. return
  79. }
  80. }
  81. },
  82. data () {
  83. return {
  84. activeName:'first',
  85. template:{},
  86. panels:{},
  87. databastlist:[],
  88. sys_printdataset:[],
  89. act_DataBaseID:null,
  90. modeData:{},
  91. database:{}
  92. }
  93. },
  94. methods:{
  95. onDesigned () {},
  96. async saveJson () {
  97. console.log(this.modeData)
  98. this.template.panels[0].printElements = this.panels
  99. const res = await this.$api.requested({
  100. "id": 20221121160001,
  101. "content": {
  102. "sys_printmodelid": this.$route.query.id,
  103. "systemappid":this.modeData.systemappid,
  104. "modelname":this.modeData.modelname,
  105. "modeljson":this.template,
  106. "isused":this.modeData.isused
  107. }
  108. })
  109. },
  110. async saveDatabase () {
  111. this.database.sys_printmodelid = this.$route.query.id
  112. const res = await this.$api.requested({
  113. "id": 20221121160301,
  114. "content": this.database,
  115. })
  116. this.querDataBase()
  117. },
  118. async querDataBase () {
  119. const res = await this.$api.requested({
  120. "id": 20221121160201,
  121. "content": {
  122. "sys_printmodelid": this.$route.query.id
  123. }
  124. })
  125. this.databastlist = res.data
  126. },
  127. async deleteDatabase (item) {
  128. const res = await this.$api.requested({
  129. "id": 20221121160401,
  130. "content": {
  131. "sys_printdatasetid":item.sys_printdatasetid
  132. }
  133. })
  134. this.querDataBase()
  135. },
  136. async queryDataBaseDetail (item) {
  137. const res = await this.$api.requested({
  138. "id": 20221121160501,
  139. "content": {
  140. "sys_printdatasetid":item
  141. }
  142. })
  143. this.sys_printdataset = res.data
  144. },
  145. visibleChange (val) {
  146. // val?this.queryDataBaseDetail():''
  147. val?'':this.sys_printdataset = []
  148. },
  149. onChange () {},
  150. onClose () {
  151. this.$emit('onClose')
  152. },
  153. setTableField (item,id) {
  154. console.log(item,id)
  155. }
  156. },
  157. watch:{
  158. temp (val) {
  159. this.template = JSON.parse(val)
  160. this.panels = this.template.panels[0].printElements
  161. }
  162. },
  163. mounted () {
  164. this.querDataBase()
  165. }
  166. }
  167. </script>
  168. <style scoped>
  169. .preview{
  170. position: fixed;
  171. min-height: 600px;
  172. width: 550px;
  173. top:10px;
  174. right:30px;
  175. z-index: 99;
  176. background: #fff;
  177. box-shadow: 0 2px 4px #0000004d;
  178. padding: 10px;
  179. }
  180. .preview__item{
  181. position: relative;
  182. font-size: 12px;
  183. line-height: 30px;
  184. }
  185. .preview__item__table{
  186. display: flex;
  187. align-items: center;
  188. margin-bottom: 10px;
  189. }
  190. .preview__item__table p{
  191. flex: 1;
  192. width:80px ;
  193. border: 1px solid #f1f2f3;
  194. font-size: 12px;
  195. text-align: center;
  196. line-height: 30px;
  197. margin-left: -1px;
  198. }
  199. .binddata__panel{
  200. height: 600px;
  201. overflow-y:scroll ;
  202. }
  203. </style>