dataJi.vue 62 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739
  1. <template>
  2. <div style="width: 99%;display: flex;margin-left: 1%;background-color:#F5F8F9;;">
  3. <el-card style="width: 18%;height: 100%;overflow: auto;height: 85vh;background-color: white;overflow-x: hidden;" shadow="never">
  4. <template #header>
  5. <div class="card-header" style="display: flex;align-items: center;justify-content: space-between;">
  6. <span>目录:</span>
  7. <div>
  8. <el-icon @click="addDir" style="cursor: pointer;color: #409EFF;"><Plus /></el-icon>
  9. </div>
  10. </div>
  11. </template>
  12. <el-tree :expand-on-click-node="false" ref="treeRef" :filter-node-method="filterNode" :current-node-key="currentNodeKey" class="treeLeft"
  13. :data="data" @node-click="handleNodeClick" node-key="id" style="margin-left: -10%;margin-top: 0%;width: 120%;background-color: transparent;" default-expand-all :key="valueKet">
  14. <template #default="{ node, data }">
  15. <span style="justify-content: space-between;display: flex;width: 30%;align-items: center;margin-left: 1%;">
  16. <div class="custom-tree-node" style="align-items: center;line-height: 1.5;">
  17. <svg-icon icon-class="model" v-if="data.nodeType=='SET'"/>
  18. <svg-icon icon-class="model2" v-if="data.nodeType=='TREE'"/>
  19. <span style="font-size: 1rem;">{{ node.label }}</span>
  20. </div>
  21. <div style="margin-right: 1%;position: absolute;left:90%;">
  22. <el-dropdown trigger="hover" @click.stop v-if="currentNodeKey === data.id">
  23. <!-- <el-icon class="el-icon--right" style="color: black;">
  24. <plus />
  25. </el-icon> -->
  26. <svg-icon icon-class="zhankai"/>
  27. <template #dropdown>
  28. <el-dropdown-menu>
  29. <el-dropdown-item style="display: flex;" @click="add1Level">
  30. <el-icon class="el-icon--right" style="color: black;">
  31. <CirclePlus />
  32. </el-icon>
  33. <div>
  34. 添加同级
  35. </div>
  36. </el-dropdown-item>
  37. <el-dropdown-item style="display: flex;" @click="addNextLevel">
  38. <el-icon class="el-icon--right" style="color: black;">
  39. <Connection />
  40. </el-icon>
  41. <div>
  42. 新建下级
  43. </div>
  44. </el-dropdown-item>
  45. <divider/>
  46. <el-dropdown-item style="display: flex;" @click="delAll" divided>
  47. <el-icon class="el-icon--right" style="color: black;">
  48. <CircleClose />
  49. </el-icon>
  50. <div>
  51. 删除节点
  52. </div>
  53. </el-dropdown-item>
  54. </el-dropdown-menu>
  55. </template>
  56. </el-dropdown>
  57. </div>
  58. </span>
  59. </template>
  60. </el-tree>
  61. </el-card>
  62. <div style="width: 80%;margin-left: 1%;background-color: white;">
  63. <div style="display: flex;justify-content: space-between;width: 100%;align-items: center;margin-left: 0%;padding: 1%;">
  64. <div style="display: flex;width: 50%;align-items: center;">
  65. <div>
  66. 名称
  67. </div>
  68. <el-input size="mini" v-model="dcName" style="width: 30%;margin-left: 1%;"/>
  69. <el-button type="primary" @click="getTable" size="mini" style="margin-left:1%;">查询</el-button>
  70. </div>
  71. <el-button type="primary" @click="showAdd" size="mini" style="margin-left:1%;" :disabled="!parTree">新增</el-button>
  72. </div>
  73. <el-table
  74. :data="tableData"
  75. style="width: 99%;margin-left: 1%;margin-top: 0.5%;"
  76. :cell-style="{ padding:'5px' }"
  77. :header-cell-style="{height: heightAll*0.01+'px',}"
  78. :row-style="{ fontSize: '16px',textAlign:'center'}"
  79. border
  80. :height="tableheight">
  81. <el-table-column type="index" label="序号" width="80"></el-table-column>
  82. <el-table-column prop="dcName" label="名称:">
  83. </el-table-column>
  84. <el-table-column prop="dcType" label="分类"/>
  85. <el-table-column prop="dcNote" label="说明"/>>
  86. <el-table-column prop="address" label="操作" width="250">
  87. <template #default="scope">
  88. <div style="display: flex;justify-content: space-between;width: 100%;">
  89. <el-button type="primary" @click="showPei(scope.row)" size="mini" text style="margin-left: 0%;">数据项配置</el-button>
  90. <el-button type="primary" @click="showEdit(scope.row)" size="mini" text style="margin-left:0%;">编辑</el-button>
  91. <el-button @click="delRow(scope.row)" type="danger" text size="mini" style="margin-left: 0%;">删除</el-button>
  92. </div>
  93. </template>
  94. </el-table-column>
  95. </el-table>
  96. <div style="float: right;margin-top: 0.5%;margin-right: 1%;">
  97. <!-- <el-pagination
  98. small
  99. v-model='currentPage'
  100. @current-change="changePage"
  101. background
  102. layout="prev, pager, next"
  103. :total="total"
  104. class="mt-4"
  105. /> -->
  106. </div>
  107. </div>
  108. </div>
  109. <el-dialog :title="title" @close="clearForm" v-model="dialogVisible" title="" width="30%" destroy-on-close :key="tableKey">
  110. <el-form :label-width="140" label-position="right" :disabled="isEdit" style="margin-left: 5%;margin-top: 2%;" :model="formZu" class="demo-form-inline" ref="formRefZu" :rules="rulesZu">
  111. <el-form-item label="数据集中文名:" prop="dcName" style="">
  112. <el-input v-model="formZu.dcName" style="width: 75%;" placeholder="" resize="none"/>
  113. </el-form-item>
  114. <el-form-item label="数据集说明:" prop="dcNote" style="">
  115. <el-input v-model="formZu.dcNote" style="width: 75%;" placeholder="" type="textarea" :row="2" resize="none"/>
  116. </el-form-item>
  117. <el-form-item label="数据集类型:" prop="dcType" style="">
  118. <el-select
  119. v-model="formZu.dcType"
  120. class="noBorSel"
  121. placeholder=""
  122. style="width: 75%;margin-left: 0%;"
  123. >
  124. <el-option
  125. v-for="item in optionsShuLei"
  126. :key="item.value"
  127. :label="item.label"
  128. :value="item.value"
  129. />
  130. </el-select>
  131. </el-form-item>
  132. <el-form-item label="排序:" prop="dcSort">
  133. <el-input-number v-model="formZu.dcSort" :min="1" style="width: 50%;"/>
  134. </el-form-item>
  135. </el-form>
  136. <template #footer>
  137. <span class="dialog-footer">
  138. <el-button size="mini" @click="dialogVisible = false">取消</el-button>
  139. <el-button v-if="isAddTa" type="primary" @click="addTa" size="mini">
  140. 提交
  141. </el-button>
  142. <el-button v-if="!isAddTa" type="primary" @click="saveEditTa" size="mini">
  143. 提交
  144. </el-button>
  145. </span>
  146. </template>
  147. </el-dialog>
  148. <el-dialog @close="" v-model="dialogVisibleTree" title="sql配置管理" width="60%" destroy-on-close :key="tableKey" @opened="refreshEditor">
  149. <div style="display: flex;align-items: center;width: 100%;">
  150. <div>
  151. 数据源:
  152. </div>
  153. <div style="width: 15%;">
  154. <el-select
  155. v-model="dsCodeSql"
  156. size="mini"
  157. style="width: 100%;margin-left: 1%;"
  158. >
  159. <el-option
  160. v-for="item in optionsDs"
  161. :key="item.value"
  162. :label="item.label"
  163. :value="item.value"
  164. />
  165. </el-select>
  166. </div>
  167. </div>
  168. <div style="border: solid 1px #e9e9eb;margin-top:1%;">
  169. <Codemirror
  170. v-model:value="codeSQl"
  171. :options="cmOptions"
  172. height="100px"
  173. ref="cmRef"
  174. style="margin-top: 0%;"
  175. />
  176. </div>
  177. <div style="margin-top:0%;">
  178. <div style="display: flex;justify-content: space-between;align-items: center;">
  179. </div>
  180. <el-button @click="testSql" style="margin-top: -3%;left: 93%;z-index:555;position: absolute;" type="info" plain size="mini">测试</el-button>
  181. <el-button v-if="activeName=='first'" @click="addCan" style="position: absolute;right: 1%;margin-top: 2%;" type="success" size="mini" plain>新增字段</el-button>
  182. <el-tabs
  183. v-model="activeName"
  184. type="card"
  185. class="demo-tabs"
  186. style="margin-top: 2%;"
  187. @tab-click="handleClick"
  188. >
  189. <el-tab-pane label="参数" name="first">
  190. <div style="display: flex;width: 100%;margin-top: 0%;">
  191. </div>
  192. <el-table
  193. style="margin-top: 1%;width: 98%;"
  194. :data="tableDataCan"
  195. :cell-style="{ textAlign: 'center',padding:'2px 0' }"
  196. :header-cell-style="{ textAlign: 'center'}"
  197. :row-style="{ height: heightAll*0.01+'px',fontSize: '16px',textAlign:'center' }"
  198. border >
  199. <el-table-column prop="itemName" label="字段编码" width="200">
  200. <template #default="scope">
  201. <el-input placeholder="(必填)" type="primary" class="noBor" v-model="scope.row.paramCode" size="mini" text style="margin-left: 0%;"></el-input>
  202. </template>
  203. </el-table-column>
  204. <el-table-column prop="itemName" label="字段名称">
  205. <template #default="scope">
  206. <div style="width: 100%;">
  207. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.paramName" size="mini" text style="margin-left: 0%;"></el-input>
  208. </div>
  209. </template>
  210. </el-table-column>
  211. <el-table-column prop="itemName" label="字段类型(必填)">
  212. <template #default="scope">
  213. <div style="width: 100%;">
  214. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.paramType" size="mini" text style="margin-left: 0%;"></el-input>
  215. </div>
  216. </template>
  217. </el-table-column>
  218. <el-table-column prop="itemName" label="长度" >
  219. <template #default="scope">
  220. <div style="width: 100%;">
  221. <el-input type="primary" class="noBor" v-model="scope.row.paramLength" size="mini" text style="margin-left: 0%;"></el-input>
  222. </div>
  223. </template>
  224. </el-table-column>
  225. <el-table-column prop="itemName" label="默认值" >
  226. <template #default="scope">
  227. <div style="width: 100%;">
  228. <el-input type="primary" class="noBor" v-model="scope.row.paramValue" size="mini" text style="margin-left: 0%;"></el-input>
  229. </div>
  230. </template>
  231. </el-table-column>
  232. <el-table-column prop="itemName" label="说明" >
  233. <template #default="scope">
  234. <div style="width: 100%;">
  235. <el-input type="primary" class="noBor" v-model="scope.row.paramNote" size="mini" text style="margin-left: 0%;"></el-input>
  236. </div>
  237. </template>
  238. </el-table-column>
  239. <el-table-column prop="itemName" label="主键" width="80">
  240. <template #default="scope">
  241. <div style="width: 100%;">
  242. <el-checkbox v-model="scope.row.fieldIspri" label="" size="large" />
  243. </div>
  244. </template>
  245. </el-table-column>
  246. <el-table-column prop="address" label="操作" width="100">
  247. <template #default="scope">
  248. <div style="width: 100%;">
  249. <el-button type="danger" @click="delCan(scope.$index)" size="mini" text style="margin-left: 0%;">删除</el-button>
  250. </div>
  251. </template>
  252. </el-table-column>
  253. </el-table>
  254. </el-tab-pane>
  255. <el-tab-pane label="结果集" name="second">
  256. <el-tree :expand-on-click-node="false" ref="treeRefReturun" :filter-node-method="filterNode" :current-node-key="currentNodeKey" class="treeLeft"
  257. :data="dataTreeReturn" @node-click="" node-key="id" style="margin-left: 1%;margin-top: 0%;width: 50%;background-color: transparent;"
  258. default-expand-all :key="valueKet" :props="defaultProps">
  259. <template #default="{ node, data }">
  260. <span style="justify-content: space-between;display: flex;width: 30%;align-items: center;margin-left: 1%;" @mouseenter="setId(data)">
  261. <div class="custom-tree-node" style="align-items: center;line-height: 1.5;font-size: 10px;">
  262. <span style="font-size: 1rem;">{{ data.fieldCode }}</span>
  263. </div>
  264. <div style="position: absolute;left:40%;">
  265. <div style="color: #67C23A;" v-if="data.fieldType=='string'">
  266. string
  267. </div>
  268. <div style="color: #E6A23C;" v-else-if="data.fieldType=='array'">
  269. array
  270. </div>
  271. <div style="color: #F56C6C;" v-else-if="data.fieldType=='number'">
  272. number
  273. </div>
  274. <div style="color: #909399;" v-else>
  275. {{ data.fieldType }}
  276. </div>
  277. </div>
  278. <div style="margin-right: 1%;position: absolute;left:60%;">
  279. <el-dropdown trigger="hover">
  280. <svg-icon icon-class="zhankai"/>
  281. <template #dropdown>
  282. <el-dropdown-menu>
  283. <el-dropdown-item style="display: flex;" @click="add1LevelTree">
  284. <el-icon class="el-icon--right" style="color: black;">
  285. <CirclePlus />
  286. </el-icon>
  287. <div>
  288. 添加同级
  289. </div>
  290. </el-dropdown-item>
  291. <el-dropdown-item style="display: flex;" @click="addNextLevelTree">
  292. <el-icon class="el-icon--right" style="color: black;">
  293. <Connection />
  294. </el-icon>
  295. <div>
  296. 新建下级
  297. </div>
  298. </el-dropdown-item>
  299. <divider/>
  300. <el-dropdown-item style="display: flex;" @click="delNode" divided>
  301. <el-icon class="el-icon--right" style="color: black;">
  302. <CircleClose />
  303. </el-icon>
  304. <div>
  305. 删除
  306. </div>
  307. </el-dropdown-item>
  308. </el-dropdown-menu>
  309. </template>
  310. </el-dropdown>
  311. </div>
  312. <div style="margin-right: 1%;position: absolute;left:70%;">
  313. <div style="">
  314. <span style="font-size: 1rem;">{{ data.fieldName }}</span>
  315. </div>
  316. </div>
  317. </span>
  318. </template>
  319. </el-tree>
  320. </el-tab-pane>
  321. <el-tab-pane label="预览" name="third">
  322. <div style="overflow: auto;height: 20vh;margin-top: -1%;">
  323. <el-input placeholder="" :rows="8" type="textarea" v-model="testSqlResult" size="mini" text style="margin-top: 1%;width: 98%;" ></el-input>
  324. </div>
  325. </el-tab-pane>
  326. </el-tabs>
  327. <div>
  328. </div>
  329. </div>
  330. <template #footer>
  331. <span class="dialog-footer">
  332. <el-button size="mini" @click="dialogVisibleTree = false">取消</el-button>
  333. <el-button type="primary" @click="addPei" size="mini">
  334. 提交
  335. </el-button>
  336. </span>
  337. </template>
  338. </el-dialog>
  339. <el-dialog @close="clearForm" v-model="dialogVisibleData" title="新增数据项" width="30%" destroy-on-close :key="tableKey">
  340. <el-form :label-width="100" label-position="right" :disabled="isEdit" style="margin-left: 5%;margin-top: 2%;" :model="formTree" class="demo-form-inline" ref="formRefTree" :rules="rulesTree">
  341. <el-form-item label="名称:" prop="itemName" style="">
  342. <el-input v-model="formTree.itemName" style="width: 75%;" placeholder="" resize="none"/>
  343. </el-form-item>
  344. <el-form-item label="说明:" prop="itemNotes">
  345. <el-input v-model="formTree.itemNotes" style="width: 75%;" placeholder="" resize="none"/>
  346. </el-form-item>
  347. <el-form-item label="节点:" prop="itemNotes" v-if="byNode">
  348. <el-tree-select
  349. v-model="valueNode"
  350. :data="data"
  351. check-strictly
  352. :render-after-expand="true"
  353. style="width: 75%;"
  354. />
  355. </el-form-item>
  356. <el-form-item label="级别:" prop="itemNotes" v-if="byNode">
  357. <el-radio-group v-model="radioLev" class="ml-4">
  358. <el-radio label="1" size="small">同级</el-radio>
  359. <el-radio label="2" size="small">子级</el-radio>
  360. </el-radio-group>
  361. </el-form-item>
  362. <el-form-item label="排序:" prop="itemNo">
  363. <el-input-number v-model="formTree.itemNo" :min="1" style="width: 50%;"/>
  364. </el-form-item>
  365. </el-form>
  366. <template #footer>
  367. <span class="dialog-footer">
  368. <el-button size="mini" @click="dialogVisibleData = false">取消</el-button>
  369. <el-button type="primary" @click="addataXiang" size="mini">
  370. 提交
  371. </el-button>
  372. </span>
  373. </template>
  374. </el-dialog>
  375. <el-dialog @close="" v-model="dialogVisibleApi" title="api配置管理" width="60%" destroy-on-close :key="tableKey">
  376. <div style="display: flex;align-items: center;width: 100%;">
  377. <div>
  378. API:
  379. </div>
  380. <div style="width: 18%;">
  381. <el-tree-select
  382. v-model="valueSel"
  383. :data="dataSel"
  384. :render-after-expand="false"
  385. style="margin-left:1%;width: 100%;"
  386. />
  387. </div>
  388. </div>
  389. <div style="margin-top:0%;">
  390. <div style="display: flex;justify-content: space-between;align-items: center;">
  391. </div>
  392. <el-button style="margin-top: 2%;left: 92%;z-index:555;position: absolute;" type="info" plain size="mini">测试</el-button>
  393. <el-button v-if="activeName=='first'" @click="addCan" style="position: absolute;right: 1%;margin-top: 2%;" type="success" size="mini" plain>新增字段</el-button>
  394. <el-tabs
  395. v-model="activeName"
  396. type="card"
  397. class="demo-tabs"
  398. style="margin-top: 2%;"
  399. @tab-click="handleClick"
  400. >
  401. <el-tab-pane label="参数" name="first">
  402. <div style="display: flex;width: 100%;margin-top: 0%;">
  403. <!-- <el-button @click="addCan" style="margin-top: 0%;" type="success" size="mini" plain>新增字段</el-button> -->
  404. </div>
  405. <el-table
  406. style="margin-top: 1%;width: 98%;"
  407. :data="tableDataCan"
  408. :cell-style="{ textAlign: 'center',padding:'2px 0' }"
  409. :header-cell-style="{ textAlign: 'center'}"
  410. :row-style="{ height: heightAll*0.01+'px',fontSize: '16px',textAlign:'center' }"
  411. border >
  412. <el-table-column prop="itemName" label="字段编码" width="200">
  413. <template #default="scope">
  414. <el-input placeholder="(必填)" type="primary" class="noBor" v-model="scope.row.paramCode" size="mini" text style="margin-left: 0%;"></el-input>
  415. </template>
  416. </el-table-column>
  417. <el-table-column prop="itemName" label="字段名称">
  418. <template #default="scope">
  419. <div style="width: 100%;">
  420. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.paramName" size="mini" text style="margin-left: 0%;"></el-input>
  421. </div>
  422. </template>
  423. </el-table-column>
  424. <el-table-column prop="itemName" label="字段类型(必填)">
  425. <template #default="scope">
  426. <div style="width: 100%;">
  427. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.paramType" size="mini" text style="margin-left: 0%;"></el-input>
  428. </div>
  429. </template>
  430. </el-table-column>
  431. <el-table-column prop="itemName" label="长度" >
  432. <template #default="scope">
  433. <div style="width: 100%;">
  434. <el-input type="primary" class="noBor" v-model="scope.row.paramLength" size="mini" text style="margin-left: 0%;"></el-input>
  435. </div>
  436. </template>
  437. </el-table-column>
  438. <el-table-column prop="itemName" label="默认值" >
  439. <template #default="scope">
  440. <div style="width: 100%;">
  441. <el-input type="primary" class="noBor" v-model="scope.row.paramValue" size="mini" text style="margin-left: 0%;"></el-input>
  442. </div>
  443. </template>
  444. </el-table-column>
  445. <el-table-column prop="itemName" label="说明" >
  446. <template #default="scope">
  447. <div style="width: 100%;">
  448. <el-input type="primary" class="noBor" v-model="scope.row.paramNote" size="mini" text style="margin-left: 0%;"></el-input>
  449. </div>
  450. </template>
  451. </el-table-column>
  452. <el-table-column prop="itemName" label="主键" width="80">
  453. <template #default="scope">
  454. <div style="width: 100%;">
  455. <el-checkbox v-model="scope.row.fieldIspri" label="" size="large" />
  456. </div>
  457. </template>
  458. </el-table-column>
  459. <el-table-column prop="address" label="操作" width="100">
  460. <template #default="scope">
  461. <div style="width: 100%;">
  462. <el-button type="danger" @click="delCan(scope.$index)" size="mini" text style="margin-left: 0%;">删除</el-button>
  463. </div>
  464. </template>
  465. </el-table-column>
  466. </el-table>
  467. </el-tab-pane>
  468. <el-tab-pane label="结果集" name="second">
  469. <el-tree :expand-on-click-node="false" ref="treeRefReturun" :filter-node-method="filterNode" :current-node-key="currentNodeKey" class="treeLeft"
  470. :data="dataTreeReturn" @node-click="" node-key="id" style="margin-left: 1%;margin-top: 0%;width: 50%;background-color: transparent;"
  471. default-expand-all :key="valueKet" :props="defaultProps">
  472. <template #default="{ node, data }">
  473. <span style="justify-content: space-between;display: flex;width: 30%;align-items: center;margin-left: 1%;" @mouseenter="setId(data)">
  474. <div class="custom-tree-node" style="align-items: center;line-height: 1.5;font-size: 10px;">
  475. <span style="font-size: 1rem;">{{ data.fieldCode }}</span>
  476. </div>
  477. <div style="position: absolute;left:40%;">
  478. <div style="color: #67C23A;" v-if="data.fieldType=='string'">
  479. string
  480. </div>
  481. <div style="color: #E6A23C;" v-else-if="data.fieldType=='array'">
  482. array
  483. </div>
  484. <div style="color: #F56C6C;" v-else-if="data.fieldType=='number'">
  485. number
  486. </div>
  487. <div style="color: #909399;" v-else>
  488. {{ data.fieldType }}
  489. </div>
  490. </div>
  491. <div style="margin-right: 1%;position: absolute;left:60%;">
  492. <el-dropdown trigger="hover">
  493. <svg-icon icon-class="zhankai"/>
  494. <template #dropdown>
  495. <el-dropdown-menu>
  496. <el-dropdown-item style="display: flex;" @click="add1LevelTree">
  497. <el-icon class="el-icon--right" style="color: black;">
  498. <CirclePlus />
  499. </el-icon>
  500. <div>
  501. 添加同级
  502. </div>
  503. </el-dropdown-item>
  504. <el-dropdown-item style="display: flex;" @click="addNextLevelTree">
  505. <el-icon class="el-icon--right" style="color: black;">
  506. <Connection />
  507. </el-icon>
  508. <div>
  509. 新建下级
  510. </div>
  511. </el-dropdown-item>
  512. <divider/>
  513. <el-dropdown-item style="display: flex;" @click="delNode" divided>
  514. <el-icon class="el-icon--right" style="color: black;">
  515. <CircleClose />
  516. </el-icon>
  517. <div>
  518. 删除
  519. </div>
  520. </el-dropdown-item>
  521. </el-dropdown-menu>
  522. </template>
  523. </el-dropdown>
  524. </div>
  525. <div style="margin-right: 1%;position: absolute;left:70%;">
  526. <div style="">
  527. <span style="font-size: 1rem;">{{ data.fieldName }}</span>
  528. </div>
  529. </div>
  530. </span>
  531. </template>
  532. </el-tree>
  533. </el-tab-pane>
  534. <el-tab-pane label="预览" name="third">
  535. <div style="overflow: auto;height: 20vh;margin-top: -1%;">
  536. <el-input placeholder="" :rows="8" type="textarea" v-model="JsonAdd" size="mini" text style="margin-top: 1%;width: 98%;" ></el-input>
  537. </div>
  538. </el-tab-pane>
  539. </el-tabs>
  540. <div>
  541. </div>
  542. </div>
  543. <template #footer>
  544. <span class="dialog-footer">
  545. <el-button size="mini" @click="dialogVisibleTree = false">取消</el-button>
  546. <el-button type="primary" @click="addPei" size="mini">
  547. 提交
  548. </el-button>
  549. </span>
  550. </template>
  551. </el-dialog>
  552. <el-dialog @close="" v-model="dialogVisibleFile" title="文件配置管理" width="60%" destroy-on-close :key="tableKey">
  553. <div style="display: flex;align-items: center;width: 100%;">
  554. <div>
  555. 文件类型:
  556. </div>
  557. <div style="width: 18%;">
  558. <el-select
  559. v-model="fileType"
  560. size="mini"
  561. style="width: 100%;margin-left: 1%;"
  562. >
  563. <el-option
  564. v-for="item in optionsFileTy"
  565. :key="item.value"
  566. :label="item.label"
  567. :value="item.value"
  568. />
  569. </el-select>
  570. </div>
  571. <!-- <div style="margin-left:2% ">
  572. 文件格式:
  573. </div>
  574. <div style="width: 18%;;">
  575. <el-select
  576. v-model="valueDs"
  577. size="mini"
  578. style="width: 100%;margin-left: 1%;"
  579. >
  580. <el-option
  581. v-for="item in optionsFilege"
  582. :key="item.value"
  583. :label="item.label"
  584. :value="item.value"
  585. />
  586. </el-select>
  587. </div> -->
  588. </div>
  589. <el-divider/>
  590. <div style="display: flex;align-items: center;width: 100%;">
  591. </div>
  592. <div style="margin-top:0%;">
  593. <div style="display: flex;justify-content: space-between;align-items: center;">
  594. </div>
  595. <el-button style="margin-top: 2%;left: 92%;z-index:555;position: absolute;" type="info" plain size="mini">测试</el-button>
  596. <el-tabs
  597. v-model="activeName"
  598. type="card"
  599. class="demo-tabs"
  600. style="margin-top: 2%;"
  601. @tab-click="handleClick"
  602. >
  603. <el-tab-pane label="参数" name="first">
  604. <el-upload
  605. ref="uploadRef"
  606. :limit="1"
  607. accept=".xlsx, .xls"
  608. :headers="upload.headers"
  609. :on-change="handleChange"
  610. :file-list="fileList"
  611. :action="upload.url + '?file=' + upload.updateSupport"
  612. :on-progress="handleFileUploadProgress"
  613. :on-success="handleFileSuccess"
  614. :auto-upload="false"
  615. drag
  616. >
  617. <el-icon class="el-icon--upload"><upload-filled /></el-icon>
  618. <div class="el-upload__text">将文件拖到此处,或<em>点击上传</em></div>
  619. </el-upload>
  620. <el-link style="margin-top: 1%;" type="primary" @click="download">{{fileName}}</el-link>
  621. </el-tab-pane>
  622. <el-tab-pane label="结果集" name="second">
  623. <el-tree :expand-on-click-node="false" ref="treeRefReturun" :filter-node-method="filterNode" :current-node-key="currentNodeKey" class="treeLeft"
  624. :data="dataTreeReturn" @node-click="" node-key="id" style="margin-left: 1%;margin-top: 0%;width: 50%;background-color: transparent;"
  625. default-expand-all :key="valueKet" :props="defaultProps">
  626. <template #default="{ node, data }">
  627. <span style="justify-content: space-between;display: flex;width: 30%;align-items: center;margin-left: 1%;" @mouseenter="setId(data)">
  628. <div class="custom-tree-node" style="align-items: center;line-height: 1.5;font-size: 10px;">
  629. <span style="font-size: 1rem;">{{ data.fieldCode }}</span>
  630. </div>
  631. <div style="position: absolute;left:40%;">
  632. <div style="color: #67C23A;" v-if="data.fieldType=='string'">
  633. string
  634. </div>
  635. <div style="color: #E6A23C;" v-else-if="data.fieldType=='array'">
  636. array
  637. </div>
  638. <div style="color: #F56C6C;" v-else-if="data.fieldType=='number'">
  639. number
  640. </div>
  641. <div style="color: #909399;" v-else>
  642. {{ data.fieldType }}
  643. </div>
  644. </div>
  645. <div style="margin-right: 1%;position: absolute;left:60%;">
  646. <el-dropdown trigger="hover">
  647. <svg-icon icon-class="zhankai"/>
  648. <template #dropdown>
  649. <el-dropdown-menu>
  650. <el-dropdown-item style="display: flex;" @click="add1LevelTree">
  651. <el-icon class="el-icon--right" style="color: black;">
  652. <CirclePlus />
  653. </el-icon>
  654. <div>
  655. 添加同级
  656. </div>
  657. </el-dropdown-item>
  658. <el-dropdown-item style="display: flex;" @click="addNextLevelTree">
  659. <el-icon class="el-icon--right" style="color: black;">
  660. <Connection />
  661. </el-icon>
  662. <div>
  663. 新建下级
  664. </div>
  665. </el-dropdown-item>
  666. <divider/>
  667. <el-dropdown-item style="display: flex;" @click="delNode" divided>
  668. <el-icon class="el-icon--right" style="color: black;">
  669. <CircleClose />
  670. </el-icon>
  671. <div>
  672. 删除
  673. </div>
  674. </el-dropdown-item>
  675. </el-dropdown-menu>
  676. </template>
  677. </el-dropdown>
  678. </div>
  679. <div style="margin-right: 1%;position: absolute;left:70%;">
  680. <div style="">
  681. <span style="font-size: 1rem;">{{ data.fieldName }}</span>
  682. </div>
  683. </div>
  684. </span>
  685. </template>
  686. </el-tree>
  687. </el-tab-pane>
  688. <el-tab-pane label="预览" name="third">
  689. <div style="overflow: auto;height: 20vh;margin-top: -1%;">
  690. <el-input placeholder="" :rows="8" type="textarea" v-model="JsonAdd" size="mini" text style="margin-top: 1%;width: 98%;" ></el-input>
  691. </div>
  692. </el-tab-pane>
  693. </el-tabs>
  694. <div>
  695. </div>
  696. </div>
  697. <template #footer>
  698. <span class="dialog-footer">
  699. <el-button size="mini" @click="dialogVisibleTree = false">取消</el-button>
  700. <el-button type="primary" @click="addPei" size="mini">
  701. 提交
  702. </el-button>
  703. </span>
  704. </template>
  705. </el-dialog>
  706. <el-dialog @close="clear" title="" v-model="dialogVisibleTreeEdit" width="55%" destroy-on-close :key="tableKey">
  707. <el-button @click="addCanAdd" style="margin-top: 1%;" type="success" size="mini" :disabled="isEdit" plain>新增参数</el-button>
  708. <el-table
  709. style="margin-top: 1%;width: 98%;"
  710. :data="tableDataCanAdd"
  711. :cell-style="{ textAlign: 'center',padding:'2px 0' }"
  712. :header-cell-style="{ textAlign: 'center'}"
  713. :row-style="{ height: heightAll*0.01+'px',fontSize: '16px',textAlign:'center' }"
  714. border >
  715. <el-table-column prop="itemName" label="字段编码" width="200">
  716. <template #default="scope">
  717. <el-input placeholder="(必填)" type="primary" class="noBor" v-model="scope.row.fieldCode" size="mini" text style="margin-left: 0%;"></el-input>
  718. </template>
  719. </el-table-column>
  720. <el-table-column prop="itemName" label="字段名称">
  721. <template #default="scope">
  722. <div style="width: 100%;">
  723. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.fieldName" size="mini" text style="margin-left: 0%;"></el-input>
  724. </div>
  725. </template>
  726. </el-table-column>
  727. <el-table-column prop="itemName" label="字段类型">
  728. <template #default="scope">
  729. <div style="width: 100%;">
  730. <el-input placeholder="" type="primary" class="noBor" v-model="scope.row.fieldType" size="mini" text style="margin-left: 0%;"></el-input>
  731. </div>
  732. </template>
  733. </el-table-column>
  734. <el-table-column prop="itemName" label="长度" >
  735. <template #default="scope">
  736. <div style="width: 100%;">
  737. <el-input type="primary" class="noBor" v-model="scope.row.fieldLength" size="mini" text style="margin-left: 0%;"></el-input>
  738. </div>
  739. </template>
  740. </el-table-column>
  741. <el-table-column prop="itemName" label="默认值" >
  742. <template #default="scope">
  743. <div style="width: 100%;">
  744. <el-input type="primary" class="noBor" v-model="scope.row.fieldDefault" size="mini" text style="margin-left: 0%;"></el-input>
  745. </div>
  746. </template>
  747. </el-table-column>
  748. <el-table-column prop="itemName" label="说明" >
  749. <template #default="scope">
  750. <div style="width: 100%;">
  751. <el-input type="primary" class="noBor" v-model="scope.row.fieldDesc" size="mini" text style="margin-left: 0%;"></el-input>
  752. </div>
  753. </template>
  754. </el-table-column>
  755. <el-table-column prop="itemName" label="主键" width="80">
  756. <template #default="scope">
  757. <div style="width: 100%;">
  758. <el-checkbox v-model="scope.row.fieldIspri" label="" size="large" />
  759. </div>
  760. </template>
  761. </el-table-column>
  762. <el-table-column prop="address" label="操作" width="100">
  763. <template #default="scope">
  764. <div style="width: 100%;">
  765. <el-button type="danger" @click="delCanAdd(scope.$index)" size="mini" text style="margin-left: 0%;">删除</el-button>
  766. </div>
  767. </template>
  768. </el-table-column>
  769. </el-table>
  770. <template #footer>
  771. <span class="dialog-footer">
  772. <el-button size="mini" @click="dialogVisibleTreeEdit = false">取消</el-button>
  773. <el-button type="primary" @click="addToTree" size="mini">
  774. 确定
  775. </el-button>
  776. </span>
  777. </template>
  778. </el-dialog>
  779. </template>
  780. <script setup>
  781. import { reactive } from 'vue'
  782. import { Plus } from '@element-plus/icons-vue'
  783. import { modelTreeSelect } from "@/api/service/info";
  784. import { cateTree,addCate,delCate,fieldAll,addSet,dataSetList,editSet,fieldAdd,delField,getDataSourceList,delSet,dataJisql,
  785. dataJiApi,dataJiFile,dataJiSql,getDataJiSql, getDataJiApi,getDataJiFile,getDataJiParam,getDataJiParamRe,addJiFan,addJiCan
  786. } from "@/api/register/regCom.js";
  787. import { ref, onMounted, onUnmounted, nextTick } from 'vue';
  788. import Codemirror from 'codemirror-editor-vue3';
  789. import { getToken } from "@/utils/auth";
  790. import { cloneDeep } from 'lodash'
  791. import 'codemirror/lib/codemirror.css'; // 核心样式
  792. import 'codemirror/theme/dracula.css'; // 主题
  793. import 'codemirror/mode/sql/sql.js';
  794. import { id } from 'element-plus/es/locales.mjs';
  795. const code = ref('const example = "Hello, CodeMirror!"');
  796. const cmRef = ref(null)
  797. const optionsFileTy = ref([
  798. {
  799. value:'excel',
  800. label:'excel'
  801. },
  802. {
  803. value:'csv',
  804. label:'csv'
  805. },
  806. {
  807. value:'txt',
  808. label:'txt'
  809. },
  810. ])
  811. const cmOptions = {
  812. mode: 'x-sql',
  813. hintOptions: {
  814. completeSingle: false,
  815. tables: {
  816. users: ['id', 'name', 'email'], // 自定义表字段提示
  817. products: ['id', 'price', 'stock']
  818. }
  819. }
  820. };
  821. const downLink = ref('')
  822. const upload = reactive({
  823. // 是否显示弹出层(用户导入)
  824. open: false,
  825. // 弹出层标题(用户导入)
  826. title: "",
  827. // 是否禁用上传
  828. isUploading: false,
  829. // 是否更新已经存在的用户数据
  830. updateSupport: '',
  831. // 设置上传的请求头部
  832. headers: { Authorization: "Bearer " + getToken() },
  833. // 上传的地址
  834. url: import.meta.env.VITE_APP_BASE_API + "/common/upload"
  835. });
  836. const tableDataCan = ref([])
  837. const optionsShuLei = ref([
  838. {label:"SQL数据集",
  839. value:'SQL'
  840. },
  841. {label:"API数据集",
  842. value:'API'
  843. },
  844. {label:"文件数据集",
  845. value:'FILE'
  846. },
  847. ])
  848. const valueNode = ref('')
  849. const radioLev = ref('1')
  850. const dsCodeSql = ref('')
  851. const activeName = ref('first')
  852. const uploadRef = ref(null);
  853. const dialogVisibleApi = ref(false)
  854. const dialogVisibleFile = ref(false)
  855. const valueSel = ref('')
  856. const { proxy } = getCurrentInstance();
  857. const data = ref([])
  858. const title = ref([])
  859. const titleTree = ref([])
  860. const dialogVisibleData = ref(false)
  861. const currentPage = ref(1)
  862. const total = ref(1)
  863. const tableData = ref([])
  864. const tableheight = window.innerHeight*0.78
  865. const heightAll = window.innerHeight
  866. const dialogVisible = ref(false)
  867. const dialogVisibleTreeEdit = ref(false)
  868. const parLevTree = ref(1)
  869. const isAdd = ref(false)
  870. const isAddTa = ref(false)
  871. const treeId = ref('');
  872. const dcName =ref()
  873. const parDel = ref({})
  874. const parTree = ref(null)
  875. const fileName = ref('')
  876. const dataTreeReturn = ref([])
  877. const codeSQl = ref('')
  878. const fileType = ref('')
  879. const dialogVisibleTree = ref(false)
  880. const parDcCode = ref('')
  881. const formZu = ref({
  882. cateId:'',
  883. dcName:'',
  884. dcType:'',
  885. dcSort:1,
  886. dcNote:''
  887. });
  888. const byNode = ref(false)
  889. const optionsDs = ref([])
  890. const testSqlResult = ref('')
  891. const currentNodeKey = ref('')
  892. const rulesZu = reactive({
  893. dcName: [{ required: true, message: '必填', trigger: 'blur' }],
  894. dcType: [{ required: true, message: '必填', trigger: 'blur' }],
  895. dcSort: [{ required: true, message: '必填', trigger: 'blur' }],
  896. });
  897. const formRefZu = ref();
  898. const tableDataCanAdd = ref([])
  899. const idCount = ref(500)
  900. const formTree = ref({
  901. itemName:'',
  902. itemNo:'',
  903. itemNotes:'',
  904. });
  905. const parType = ref('')
  906. const defaultProps = ref({
  907. children: 'children',
  908. })
  909. const dataSel = ref([])
  910. const parMeta = ref({})
  911. const rulesTree = reactive({
  912. itemName: [{ required: true, message: '必填', trigger: 'blur' }],
  913. itemNo: [{ required: true, message: '必填', trigger: 'blur' }]
  914. });
  915. const formRefTree = ref();
  916. const parDscode = ref('')
  917. const parLev = ref(1)
  918. const parAr = ref([])
  919. const parTreeId = ref('')
  920. const parTreeParentId = ref('')
  921. function clear(){
  922. tableDataCanAdd.value = []
  923. }
  924. async function delNode(){
  925. removeNodeById(dataTreeReturn.value,parTreeId.value)
  926. }
  927. function removeNodeById(tree, targetId) {
  928. // 检查树是否为空
  929. if (!tree || !Array.isArray(tree) || tree.length === 0) {
  930. return false;
  931. }
  932. for (let i = 0; i < tree.length; i++) {
  933. const node = tree[i];
  934. // 如果找到目标节点
  935. if (node.id === targetId) {
  936. tree.splice(i, 1); // 从数组中删除该节点
  937. return true; // 返回删除成功
  938. }
  939. // 如果当前节点有子节点,递归遍历子节点
  940. if (node.children && node.children.length > 0) {
  941. const isRemoved = removeNodeById(node.children, targetId);
  942. if (isRemoved) {
  943. return true; // 如果在子树中成功删除,直接返回
  944. }
  945. }
  946. }
  947. return false; // 未找到目标节点
  948. }
  949. function setId(data){
  950. parTreeId.value = data.id
  951. parTreeParentId.value = data.parentId
  952. }
  953. function addDir() {
  954. byNode.value = true
  955. valueNode.value = data.value[0].value
  956. dialogVisibleData.value = true
  957. }
  958. function add1LevelTree(){
  959. dialogVisibleTreeEdit.value = true
  960. parLev.value = 1
  961. }
  962. function addNextLevelTree(){
  963. dialogVisibleTreeEdit.value = true
  964. parLev.value = 2
  965. }
  966. function testSql(){
  967. if(!dsCodeSql.value){
  968. proxy.$modal.msgWarning("数据源编码不能为空");
  969. }
  970. else if(!codeSQl.value){
  971. proxy.$modal.msgWarning("sql语句不能为空");
  972. }
  973. else{
  974. var par = {
  975. dsCode:dsCodeSql.value,
  976. sql:codeSQl.value
  977. }
  978. dataJisql(par).then(res=>{
  979. if(res.code===200){
  980. proxy.$modal.msgSuccess(res.msg);
  981. testSqlResult.value = JSON.stringify(res.data )
  982. }
  983. })
  984. }
  985. }
  986. function download(){
  987. var url = window.location.host + downLink.value
  988. console.log(url)
  989. const link = document.createElement('a');
  990. link.href = 'http://' + url.toString();
  991. link.download = downLink.value; // 自定义文件名(可选)
  992. document.body.appendChild(link);
  993. link.click();
  994. document.body.removeChild(link);
  995. }
  996. async function getTreeSel(){
  997. await modelTreeSelect().then(res=>{
  998. dataSel.value = renameTreeProperties(res.data)
  999. console.log(dataSel.value)
  1000. })
  1001. }
  1002. function filterModelNodes(nodes) {
  1003. if (!Array.isArray(nodes)) return [];
  1004. const result = [];
  1005. for (const node of nodes) {
  1006. // 递归处理子节点(如果有)
  1007. const filteredChildren = node.children ? filterModelNodes(node.children) : [];
  1008. if (node.nodeType === 'MODEL') {
  1009. // 保留当前节点,并更新其子节点
  1010. node.value = node.id
  1011. result.push({
  1012. ...node,
  1013. children: filteredChildren
  1014. });
  1015. } else {
  1016. // 删除当前节点,将其子节点提升到当前层级
  1017. result.push(...filteredChildren);
  1018. }
  1019. }
  1020. return result;
  1021. }
  1022. function getOptionsDs(){
  1023. getDataSourceList().then(res=>{
  1024. optionsDs.value = res.rows
  1025. optionsDs.value.forEach(item=>{
  1026. item.label = item.dsDbname
  1027. item.value = item.dsCode
  1028. })
  1029. total.value = res.total
  1030. })
  1031. }
  1032. const refreshEditor = () => {
  1033. nextTick(() => {
  1034. cmRef.value?.refresh(); // 关键调用
  1035. });
  1036. };
  1037. function delAll(){
  1038. proxy.$modal.confirm('是否确认删除?').then(function () {
  1039. return delCate(parTree.value.id);
  1040. }).then(() => {
  1041. getTree();
  1042. proxy.$modal.msgSuccess("删除成功");
  1043. }).catch(() => {});
  1044. }
  1045. function addToTree() {
  1046. if(parLev.value === 1){
  1047. parTreeParentId.value
  1048. if(tableDataCanAdd.value){
  1049. tableDataCanAdd.value.forEach(item=>{
  1050. if(item.fieldIspri===true){
  1051. item.fieldIspri = '1'
  1052. }
  1053. if(item.fieldIspri===true){
  1054. item.fieldIspri = '0'
  1055. }
  1056. item.parentId = parTreeId.value
  1057. item.dcCode = parDcCode.value
  1058. addSiblingNode(dataTreeReturn.value,parTreeId.value,item)
  1059. })
  1060. dialogVisibleTreeEdit.value = false
  1061. }
  1062. }
  1063. if(parLev.value === 2){
  1064. tableDataCanAdd.value.forEach(item=>{
  1065. item.parentId = parTreeId.value
  1066. item.dcCode = parDcCode.value
  1067. addChildNode(dataTreeReturn.value,parTreeId.value,item)
  1068. })
  1069. dialogVisibleTreeEdit.value = false
  1070. }
  1071. console.log(findNode(dataTreeReturn.value,parTreeParentId.value))
  1072. }
  1073. function flattenTreeWithArrayIndex(treeData, parentId = 0, result = []) {
  1074. for (const node of treeData) {
  1075. // 创建新节点对象,避免污染原数据
  1076. const newNode = {
  1077. id: node.id,
  1078. parentId: parentId,
  1079. dcCode:parDcCode.value,
  1080. fieldCode: node.fieldCode,
  1081. fieldName: node.fieldName,
  1082. fieldType: node.fieldType,
  1083. fieldLength: node.fieldLength,
  1084. fieldDesc: node.fieldDesc,
  1085. fieldDefault: node.fieldDefault,
  1086. fieldIspri: node.fieldIspri,
  1087. isArray: node.isArray,
  1088. arrayIndex: node.arrayIndex
  1089. // 可根据需要添加或删除其他属性
  1090. };
  1091. result.push(newNode);
  1092. // 处理当前节点的子节点
  1093. if (node.children && node.children.length > 0) {
  1094. idCount.value++
  1095. if (node.fieldType === 'array') {
  1096. // 为 array 类型节点创建中间索引层级
  1097. var par = idCount.value
  1098. const middleNode = {
  1099. id: par, // 使用随机ID
  1100. parentId: node.id,
  1101. dcCode:parDcCode.value,
  1102. fieldCode: '[0]',
  1103. fieldName: node.fieldName,
  1104. fieldType: node.fieldType,
  1105. fieldLength: node.fieldLength,
  1106. fieldDesc: node.fieldDesc,
  1107. fieldDefault: node.fieldDefault,
  1108. fieldIspri: node.fieldIspri,
  1109. isArray: null, // 通常不是数组
  1110. arrayIndex: 0 // 数组索引
  1111. };
  1112. result.push(middleNode);
  1113. // 递归处理子节点,并将中间层节点作为它们的父节点
  1114. flattenTreeWithArrayIndex(node.children, par, result);
  1115. } else {
  1116. // 非 array 类型节点,直接递归处理子节点
  1117. flattenTreeWithArrayIndex(node.children, node.id, result);
  1118. }
  1119. }
  1120. }
  1121. return result;
  1122. }
  1123. function findNode(nodes, targetId, mode = 'id') {
  1124. if (!Array.isArray(nodes)) return null;
  1125. for (const node of nodes) {
  1126. // 检查当前节点是否匹配目标
  1127. if ((mode === 'id' && node.id === targetId) || (mode === 'parentId' && node.parentId === targetId)) {
  1128. return node;
  1129. }
  1130. // 如果该节点有子节点,则递归搜索其子树
  1131. if (node.children && node.children.length > 0) {
  1132. const found = findNode(node.children, targetId, mode);
  1133. if (found) return found;
  1134. }
  1135. }
  1136. return null; // 未找到
  1137. }
  1138. function addChildNode(treeData, parentId, newNode) {
  1139. const parentNode = findNode(treeData, parentId, 'id');
  1140. if (!parentNode) {
  1141. console.warn(`未找到ID为 ${parentId} 的父节点`);
  1142. return false;
  1143. }
  1144. // 初始化父节点的children数组(如果不存在)
  1145. if (!Array.isArray(parentNode.children)) {
  1146. parentNode.children = [];
  1147. }
  1148. // 将新节点添加到父节点的children数组中
  1149. parentNode.children.push(newNode);
  1150. return true;
  1151. }
  1152. function addSiblingNode(treeData, siblingId, newNode) {
  1153. // 1. 首先找到目标兄弟节点
  1154. const siblingNode = findNode(treeData, siblingId, 'id');
  1155. console.log(siblingNode)
  1156. if (!siblingNode) {
  1157. console.warn(`未找到ID为 ${siblingId} 的兄弟节点`);
  1158. return false;
  1159. }
  1160. // 2. 找到兄弟节点的父节点(通过parentId查找)
  1161. const parentNode = findNode(treeData, siblingNode.parentId, 'id');
  1162. console.log(parentNode)
  1163. if (!parentNode&&siblingNode) {
  1164. newNode.id = (idCount.value++)*10
  1165. treeData.push(newNode);
  1166. return true;
  1167. }
  1168. // 3. 将新节点添加到父节点的children数组中
  1169. if (!Array.isArray(parentNode.children)) {
  1170. parentNode.children = [];
  1171. }
  1172. parentNode.children.push(newNode);
  1173. return true;
  1174. }
  1175. function addValueField(nodes) {
  1176. if (!Array.isArray(nodes)) return;
  1177. for (const node of nodes) {
  1178. // 添加value字段,其值等于id
  1179. node.value = node.id;
  1180. // 如果存在子节点,递归处理
  1181. if (node.children && Array.isArray(node.children)) {
  1182. addValueField(node.children);
  1183. }
  1184. }
  1185. }
  1186. const flattenTree = (nodes) => {
  1187. const result = [];
  1188. const stack = [...nodes];
  1189. while (stack.length) {
  1190. const node = stack.pop();
  1191. result.push({ id: node.id, pid: node.pid }); // 只提取 id 和 pid
  1192. if (node.children && node.children.length) {
  1193. stack.push(...node.children);
  1194. }
  1195. }
  1196. return result;
  1197. };
  1198. function addataXiang(){
  1199. console.log(data.value)
  1200. if(byNode.value===true){
  1201. if(radioLev.value==='2'){
  1202. formTree.value.catePid = valueNode.value
  1203. }
  1204. else{
  1205. var par = ''
  1206. parAr.value.forEach(item => {
  1207. if (item.id === valueNode.value) {
  1208. par = item.pid
  1209. }
  1210. })
  1211. formTree.value.catePid = par
  1212. }
  1213. addCate(formTree.value).then(res=>{
  1214. if(res.code===200){
  1215. proxy.$modal.msgSuccess("修改成功");
  1216. getTree()
  1217. dialogVisibleData.value = false
  1218. }
  1219. })
  1220. }
  1221. else{
  1222. if(parLev.value===1){
  1223. formTree.value.catePid = parTree.value.pid
  1224. }
  1225. else{
  1226. formTree.value.catePid = parTree.value.id
  1227. }
  1228. addCate(formTree.value).then(res=>{
  1229. if(res.code===200){
  1230. proxy.$modal.msgSuccess("修改成功");
  1231. getTree()
  1232. dialogVisibleData.value = false
  1233. }
  1234. })
  1235. }
  1236. }
  1237. function add1Level(){
  1238. byNode.value = false
  1239. parLevTree.value = 1
  1240. dialogVisibleTreeEdit.value = true
  1241. }
  1242. function addNextLevel(){
  1243. byNode.value = false
  1244. parLevTree.value = 2
  1245. dialogVisibleTreeEdit.value = true
  1246. }
  1247. async function addPei(){
  1248. if(parType.value==='SQL数据集'){
  1249. console.log(dataTreeReturn.value)
  1250. console.log(flattenTreeWithArrayIndex(dataTreeReturn.value))
  1251. var parDia = false
  1252. var parDia1 = false
  1253. await addJiFan(flattenTreeWithArrayIndex(dataTreeReturn.value)).then(res=>{
  1254. if(res.code===200){
  1255. parDia = true
  1256. }
  1257. })
  1258. await addJiCan(tableDataCan.value).then(res=>{
  1259. if(res.code===200){
  1260. parDia1 = true
  1261. }
  1262. })
  1263. var par = {
  1264. dsCode:dsCodeSql.value,
  1265. dcCode:parDcCode.value,
  1266. runSql:codeSQl.value
  1267. }
  1268. await dataJiSql(par).then(res=>{
  1269. if(res.code===200&&parDia&&parDia1){
  1270. proxy.$modal.msgSuccess("编辑成功");
  1271. dialogVisibleTree.value = false
  1272. }
  1273. })
  1274. }
  1275. if(parType.value==='API数据集'){
  1276. console.log(dataTreeReturn.value)
  1277. console.log(flattenTreeWithArrayIndex(dataTreeReturn.value))
  1278. var parDia = false
  1279. var parDia1 = false
  1280. await addJiFan(flattenTreeWithArrayIndex(dataTreeReturn.value)).then(res=>{
  1281. if(res.code===200){
  1282. parDia = true
  1283. }
  1284. })
  1285. await addJiCan(tableDataCan.value).then(res=>{
  1286. if(res.code===200){
  1287. parDia1 = true
  1288. }
  1289. })
  1290. var par = {
  1291. srvId:valueSel.value,
  1292. dcCode:parDcCode.value,
  1293. }
  1294. await dataJiApi(par).then(res=>{
  1295. if(res.code===200&&parDia&&parDia1){
  1296. proxy.$modal.msgSuccess("编辑成功");
  1297. dialogVisibleApi.value = false
  1298. }
  1299. })
  1300. }
  1301. if(parType.value==='文件数据集'){
  1302. await addJiFan(flattenTreeWithArrayIndex(dataTreeReturn.value)).then(res=>{
  1303. if(res.code===200){
  1304. parDia = true
  1305. }
  1306. })
  1307. proxy.$refs["uploadRef"].submit();
  1308. }
  1309. }
  1310. async function handleFileSuccess(response, file, fileList){
  1311. var par = {
  1312. dcCode:parDcCode.value,
  1313. fileType:fileType.value,
  1314. filePath:response.fileName,
  1315. originalFilename:response.originalFilename
  1316. }
  1317. await dataJiFile(par).then(res=>{
  1318. if(res.code===200){
  1319. proxy.$modal.msgSuccess("编辑成功");
  1320. dialogVisibleFile.value = false
  1321. }
  1322. })
  1323. };
  1324. function buildTree1(list, rootParentId = 0) {
  1325. // 1. 创建一个映射(字典)以便通过id快速查找节点,并为每个节点初始化children数组
  1326. const nodeMap = {};
  1327. const tree = [];
  1328. // 初始化映射,每个节点初始时都有空的孩子数组
  1329. list.forEach(item => {
  1330. nodeMap[item.id] = { ...item, children: [] };
  1331. });
  1332. // 2. 遍历数组,根据parentId将节点放入父节点的children中
  1333. list.forEach(item => {
  1334. const node = nodeMap[item.id];
  1335. const parentId = item.parentId;
  1336. if (parentId === rootParentId) {
  1337. // 如果parentId是根父ID(默认为0),则作为根节点直接添加到树中
  1338. tree.push(node);
  1339. } else {
  1340. // 否则,尝试找到父节点并将当前节点加入其children数组
  1341. const parentNode = nodeMap[parentId];
  1342. if (parentNode) {
  1343. parentNode.children.push(node);
  1344. } else {
  1345. // 可选:处理parentId不存在于列表中的情况(孤儿节点)
  1346. // 这里选择将其提升为根节点,你也可以选择其他处理方式,如console.warn报警
  1347. tree.push(node);
  1348. }
  1349. }
  1350. });
  1351. // 3. 返回构建好的树
  1352. return tree;
  1353. }
  1354. function dfsRecursive(node, parent = null, grandParent = null) {
  1355. if (!node) return;
  1356. const reg = /\[\d+\]/;
  1357. console.log(2)
  1358. if (parent && reg.test(parent.fieldCode)) {
  1359. console.log(1)
  1360. grandParent.children = []
  1361. grandParent.children.push(parent);
  1362. parent.children.forEach(child => {
  1363. child.parentId = grandParent.id
  1364. grandParent.children.push(child);
  1365. });
  1366. grandParent.children.splice(0,1)
  1367. }
  1368. if(node.children){
  1369. node.children.forEach(child => {
  1370. dfsRecursive(child, node, parent);
  1371. });
  1372. }
  1373. return node;
  1374. }
  1375. async function showPei(row){
  1376. parDcCode.value = row.dcCode
  1377. parType.value = row.dcType
  1378. var par = {
  1379. dcCode:row.dcCode,
  1380. }
  1381. await getDataJiParam(par).then(res=>{
  1382. if(res.code===200){
  1383. tableDataCan.value = res.data
  1384. }
  1385. })
  1386. await getDataJiParamRe(par).then(res=>{
  1387. if(res.code===200){
  1388. dataTreeReturn.value = res.data
  1389. // dataTreeReturn.value = []
  1390. // var par = {
  1391. // id:idCount.value,
  1392. // parentId:0,
  1393. // fieldCode:'data',
  1394. // fieldType:'array',
  1395. // }
  1396. // dataTreeReturn.value.push(par)
  1397. if(dataTreeReturn.value.length === 0){
  1398. var par = {
  1399. id:idCount.value,
  1400. parentId:0,
  1401. fieldCode:'data',
  1402. fieldType:'array',
  1403. }
  1404. dataTreeReturn.value.push(par)
  1405. }
  1406. else{
  1407. const fullTree = buildTree1(res.data)
  1408. console.log(fullTree)
  1409. fullTree.forEach((item,index) => {
  1410. if(item.children && item.children.length > 0){
  1411. item = dfsRecursive(item)
  1412. }
  1413. });
  1414. dataTreeReturn.value = fullTree
  1415. }
  1416. }
  1417. })
  1418. if(row.dcType==='SQL'){
  1419. dialogVisibleTree.value = true
  1420. getDataJiSql(row.dcCode).then(res=>{
  1421. if(res.code===200){
  1422. dsCodeSql.value = res.data.dsCode
  1423. codeSQl.value = res.data.runSql
  1424. }
  1425. })
  1426. }
  1427. if(row.dcType==='API'){
  1428. dialogVisibleApi.value = true
  1429. getDataJiApi(row.dcCode).then(res=>{
  1430. if(res.code===200){
  1431. codeSQl.value = res.data.runSql
  1432. }
  1433. })
  1434. }
  1435. if(row.dcType==='FILE'){
  1436. dialogVisibleFile.value = true
  1437. getDataJiFile(row.dcCode).then(res=>{
  1438. if(res.code===200){
  1439. downLink.value = res.data.filePath
  1440. fileName.value = res.data.originalFilename
  1441. }
  1442. })
  1443. }
  1444. parMeta.value = row
  1445. var par = {
  1446. dsCode:parDscode.value,
  1447. metaTable:row.metaTable,
  1448. }
  1449. // getMetaFiele(par).then(res=>{
  1450. // tableDataCanAdd.value = res.data
  1451. // tableDataCanAdd.value.forEach(item=>{
  1452. // if(item.fieldIspri==='1'){
  1453. // item.fieldIspri = true
  1454. // }
  1455. // if(item.fieldIspri==='2'){
  1456. // item.fieldIspri = false
  1457. // }
  1458. // })
  1459. // })
  1460. }
  1461. function clearForm(){
  1462. tableDataCan.value = []
  1463. activeName.value = 'first'
  1464. dataTreeReturn.value = []
  1465. }
  1466. function addCan(){
  1467. var par = {
  1468. dcCode:parDcCode.value,
  1469. }
  1470. tableDataCan.value.push(par)
  1471. }
  1472. function delCan(index){
  1473. tableDataCan.value.splice(index, 1)
  1474. }
  1475. function addCanAdd(){
  1476. var par = {
  1477. id: idCount.value++,
  1478. dcCode:parDcCode.value,
  1479. }
  1480. tableDataCanAdd.value.push(par)
  1481. }
  1482. function delCanAdd(index){
  1483. tableDataCanAdd.value.splice(index, 1)
  1484. }
  1485. function getTable(){
  1486. var par = {
  1487. cateId:currentNodeKey.value,
  1488. }
  1489. dataSetList(par).then(res=>{
  1490. tableData.value = res.rows
  1491. })
  1492. }
  1493. function showAdd(){
  1494. isAddTa.value = true
  1495. title.value = '新增'
  1496. dialogVisible.value = true
  1497. }
  1498. function showEdit(row){
  1499. isAddTa.value = false
  1500. title.value = '编辑'
  1501. dialogVisible.value = true
  1502. formZu.value = row
  1503. }
  1504. function showAddTree(){
  1505. isAdd.value = true
  1506. titleTree.value = '新增节点'
  1507. dialogVisibleTree.value = true
  1508. }
  1509. function clearFromTree(){
  1510. formTree.value = {
  1511. itemName:'',
  1512. catePid:'',
  1513. itemNo:'',
  1514. itemNotes:''
  1515. }
  1516. }
  1517. function getTree(){
  1518. cateTree().then(res=>{
  1519. data.value = res.data
  1520. data.value.forEach(item=>{
  1521. item.value = item.id
  1522. item.id = item.id
  1523. })
  1524. addValueField(data.value)
  1525. parAr.value = flattenTree(data.value);
  1526. })
  1527. }
  1528. function addTa(){
  1529. formRefZu.value.validate(async (valid) => {
  1530. if(valid){
  1531. formZu.value.cateId = currentNodeKey.value
  1532. await addSet(formZu.value).then(res=>{
  1533. if(res.code===200){
  1534. proxy.$modal.msgSuccess("新增成功");
  1535. getTable()
  1536. dialogVisible.value = false
  1537. }
  1538. })
  1539. }
  1540. });
  1541. }
  1542. function saveEditTa(){
  1543. formRefZu.value.validate(async (valid) => {
  1544. if(valid){
  1545. editSet(formZu.value).then(res=>{
  1546. if(res.code===200){
  1547. proxy.$modal.msgSuccess("修改成功");
  1548. dialogVisible.value = false
  1549. getTable()
  1550. }
  1551. })
  1552. }
  1553. });
  1554. }
  1555. function delRow(row) {
  1556. proxy.$modal.confirm('是否确认删除?').then(function () {
  1557. return delSet(row.dcCode);
  1558. }).then(() => {
  1559. getTable();
  1560. proxy.$modal.msgSuccess("删除成功");
  1561. }).catch(() => {});
  1562. };
  1563. async function addTree(){
  1564. formRefTree.value.validate(async (valid) => {
  1565. await addDataCate(formTree.value).then(res=>{
  1566. if(res.code===200){
  1567. proxy.$modal.msgSuccess("新增成功");
  1568. getTree()
  1569. dialogVisibleTree.value = false
  1570. }
  1571. })
  1572. });
  1573. }
  1574. function saveEditTree(){
  1575. editCate(formTree.value).then(res=>{
  1576. if(res.code===200){
  1577. proxy.$modal.msgSuccess("修改成功");
  1578. dialogVisibleTree.value = false
  1579. getTree()
  1580. }
  1581. })
  1582. }
  1583. function handleNodeClick(node, data){
  1584. currentNodeKey.value = data.data.id
  1585. parTree.value = data.data
  1586. getTable()
  1587. }
  1588. function delTree(node, data) {
  1589. proxy.$modal.confirm('是否确认删除?').then(function () {
  1590. return delCate(data.id);
  1591. }).then(() => {
  1592. getTree();
  1593. proxy.$modal.msgSuccess("删除成功");
  1594. }).catch(() => {});
  1595. };
  1596. function editTree(node, data){
  1597. console.log(data)
  1598. titleTree.value = '编辑'
  1599. isAdd.value = false
  1600. dialogVisibleTree.value = true
  1601. getCateDe(data.id).then(res=>{
  1602. formTree.value = res.data
  1603. })
  1604. console.log(node, data)
  1605. }
  1606. function renameTreeProperties(tree) {
  1607. // 深拷贝避免修改原始数据(可选,根据需求)
  1608. const newTree = cloneDeep(tree); // 使用 lodash
  1609. // 或:const newTree = JSON.parse(JSON.stringify(tree)); // 原生方法(不兼容函数等)
  1610. // 递归处理函数
  1611. const processNode = (node) => {
  1612. // 重命名属性
  1613. if ('cateName' in node) {
  1614. node.label = node.cateName;
  1615. delete node.cateName;
  1616. }
  1617. if ('id' in node) {
  1618. node.value = node.id;
  1619. delete node.id;
  1620. }
  1621. // 递归处理子节点
  1622. if (node.children && node.children.length > 0) {
  1623. node.children.forEach(child => processNode(child));
  1624. }
  1625. };
  1626. // 遍历根节点
  1627. newTree.forEach(rootNode => processNode(rootNode));
  1628. return newTree;
  1629. }
  1630. onMounted(() => {
  1631. getTree()
  1632. getOptionsDs()
  1633. getTreeSel()
  1634. // getTable()
  1635. });
  1636. </script>
  1637. <style scoped>
  1638. :deep(.svg-icon) {
  1639. outline: none;
  1640. }
  1641. :deep(.svg-icon svg) {
  1642. stroke: none;
  1643. }
  1644. :deep(.el-tree-node__expand-icon) {
  1645. margin-left:5%; /* 向右推动图标 */
  1646. }
  1647. :deep(.el-table__body tr:hover > td) {
  1648. background-color: #eaf7ff !important;
  1649. }
  1650. :deep(.treeLeft) .el-tree-node__content {
  1651. width: 100%;
  1652. display: flex !important;
  1653. height: 30px !important;
  1654. align-items: center;
  1655. padding-top: 0 !important;
  1656. }
  1657. :deep(.treeLeft) .el-tree-node__content:hover {
  1658. background-color: #ecf5ff;
  1659. }
  1660. :deep(.treeLeft) .el-tree-node__content:active {
  1661. background-color: #d9ecff !important;
  1662. }
  1663. /* 选中态(Active) */
  1664. :deep(.treeLeft) .el-tree-node.is-current > .el-tree-node__content {
  1665. background-color: #c6e2ff !important;
  1666. }
  1667. .drag-handle {
  1668. cursor: move;
  1669. }
  1670. .ghost {
  1671. opacity: 0.5;
  1672. background: #c8ebfb;
  1673. }
  1674. /* 防止文字选中 */
  1675. :deep(.el-table__row) {
  1676. user-select: none;
  1677. -webkit-user-select: none;
  1678. }
  1679. </style>
  1680. <style scoped lang="scss">
  1681. .el-table .el-table__row td {
  1682. height: 60px !important; /* 行高 */
  1683. }
  1684. .custom-tree-node {
  1685. display: flex; /* 启用 Flex 布局 */
  1686. align-items: center; /* 垂直居中 */
  1687. gap: 6px; /* 图标与文字间距 */
  1688. }
  1689. .custom-tree-node {
  1690. flex: 1;
  1691. display: flex;
  1692. align-items: center;
  1693. justify-content: space-between;
  1694. font-size: 14px;
  1695. padding-right: 8px;
  1696. }
  1697. </style>