edit.vue 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644
  1. <template>
  2. <div class="system-edit-dic-container">
  3. <el-dialog :title="(ruleForm.sourceId !== 0 ? '修改' : '添加') + '数据源'" v-model="isShowDialog" width="769px">
  4. <el-form :model="ruleForm" ref="formRef" :rules="rules" size="default" label-width="110px">
  5. <el-form-item label="数据源标识" prop="key">
  6. <el-input v-model="ruleForm.key" placeholder="请输入数据源名称" :disabled="ruleForm.sourceId" />
  7. </el-form-item>
  8. <el-form-item label="数据源名称" prop="name">
  9. <el-input v-model="ruleForm.name" placeholder="请输入数据源名称" />
  10. </el-form-item>
  11. <el-form-item label="描述" prop="desc">
  12. <el-input v-model="ruleForm.desc" type="textarea" placeholder="请输入内容"></el-input>
  13. </el-form-item>
  14. <el-form-item label="数据来源" prop="from">
  15. <el-radio-group v-model="ruleForm.from">
  16. <el-radio :label="1">api导入</el-radio>
  17. <!-- <el-radio :label="2">数据库</el-radio>
  18. <el-radio :label="3">文件</el-radio> -->
  19. <el-radio :label="4">设备</el-radio>
  20. <el-radio :label="2">数据库</el-radio>
  21. </el-radio-group>
  22. </el-form-item>
  23. <!-- <el-divider content-position="left">规则表达式</el-divider>
  24. <div v-for="(item, index) in rule" :key="index">
  25. <el-form-item label="正则表达式">
  26. <el-input v-model="item.expression" placeholder="请输入正则表达式" />
  27. </el-form-item>
  28. <el-form-item label="替换内容">
  29. <el-input v-model="item.replace" placeholder="请输入替换内容" class="w-35" />
  30. <div class="conicon">
  31. <el-icon @click="delRule(index)" v-if="index > 0"><Delete /></el-icon>
  32. </div>
  33. </el-form-item>
  34. </div>
  35. <div style="padding: 10px">
  36. <el-button type="primary" class="addbutton" @click="addRule">增加</el-button>
  37. </div> -->
  38. <el-divider content-position="left">数据源配置</el-divider>
  39. <div v-if="ruleForm.from == 1">
  40. <el-form-item label="请求方法">
  41. <el-select v-model="config.method" placeholder="请选择请求方法">
  42. <el-option v-for="item in methodData" :key="item.value" :label="item.label" :value="item.value" />
  43. </el-select>
  44. </el-form-item>
  45. <el-form-item label="请求地址">
  46. <el-input v-model="config.url" placeholder="请输入请求地址" />
  47. </el-form-item>
  48. <el-form-item label="定时请求">
  49. <div style="display:flex">
  50. <el-input v-model="config.cronExpression" placeholder="请输入cron表达式" />
  51. <el-button type="success" @click="showCron('config')" style=" margin-left: 5px;">设置</el-button>
  52. </div>
  53. <!-- <ul style="list-style: none">
  54. <li>
  55. <el-icon><ele-WarningFilled /></el-icon> */5 * * * * ? : 每隔5秒执行一次
  56. </li>
  57. <li>
  58. <el-icon><ele-WarningFilled /></el-icon> 20 */1 * * * ? : 每隔1分钟执行一次
  59. </li>
  60. <li>
  61. <el-icon><ele-WarningFilled /></el-icon> 30 0 23 * * ? : 每天23点执行一次
  62. </li>
  63. <li>
  64. <el-icon><ele-WarningFilled /></el-icon> 0 0 1 * * ? : 每天凌晨1点执行一次
  65. </li>
  66. <li>
  67. <el-icon><ele-WarningFilled /></el-icon> 0 0 1 1 * ? : 每月1号凌晨1点执行一次
  68. </li>
  69. </ul> -->
  70. </el-form-item>
  71. <!-- <el-form-item label="更新时间">
  72. <el-input v-model="config.interval" placeholder="请输入更新时间" class="w-35" />
  73. <el-select v-model="config.intervalUnit" placeholder="请选择单位">
  74. <el-option v-for="item in unitData" :key="item.value" :label="item.label" :value="item.value" />
  75. </el-select>
  76. </el-form-item> -->
  77. <div class="box-content">
  78. <div>
  79. <div
  80. v-for="(item, index) in requestParams"
  81. :key="index"
  82. style="padding: 10px; border: 1px solid #eee; margin-bottom: 10px; position: relative">
  83. <div class="conicon" style="width: 100%; text-align: right; position: absolute; right: -8px; top: -8px; color: red">
  84. <el-icon @click="delParams(index)"><CircleClose /></el-icon>
  85. </div>
  86. <div style="display: flex">
  87. <el-divider content-position="left">请求参数</el-divider>
  88. </div>
  89. <div class="content-f" v-for="(aaa, bbb) in item" :key="bbb">
  90. <el-select v-model="aaa.type" placeholder="参数类型" style="width: 320px">
  91. <el-option v-for="item in paramData" :key="item.value" :label="item.label" :value="item.value" />
  92. </el-select>
  93. <el-input v-model="aaa.name" placeholder="请输入参数标题" style="width: 320px" />
  94. <el-input v-model="aaa.key" placeholder="请输入参数名" style="width: 320px" />
  95. <el-input v-model="aaa.value" placeholder="请输入参数值" style="width: 320px" />
  96. <div class="conicon">
  97. <el-icon @click="delParamss(index, bbb)"><Delete /></el-icon>
  98. </div>
  99. </div>
  100. <el-button type="primary" class="addbutton" @click="addParams(index)">增加</el-button>
  101. <div style=""></div>
  102. <!-- <el-button type="danger" class="addbutton" @click="delParams(index)">删除分组</el-button> -->
  103. <!-- <div class="conicon" style=" width: 100%; text-align: right;">
  104. <el-icon @click="delParams(index)" style="border: 2px solid rgb(96 98 102);;border-radius: 5px; "><Minus /></el-icon>
  105. </div> -->
  106. </div>
  107. </div>
  108. </div>
  109. <el-button type="success" class="addbutton" @click="addParamss">增加分组</el-button>
  110. </div>
  111. <div v-if="ruleForm.from == 4">
  112. <el-form-item label="选择设备">
  113. <el-select v-model="devconfig.deviceKey" filterable placeholder="请选择设备" @change="setNode">
  114. <el-option v-for="item in sourceData" :key="item.id" :label="item.key" :value="item.id">
  115. <span style="float: left">{{ item.name }}</span>
  116. <span style="float: right; font-size: 13px">{{ item.key }}</span>
  117. </el-option>
  118. </el-select>
  119. </el-form-item>
  120. </div>
  121. <div v-if="ruleForm.from == 2">
  122. <el-form-item label="数据来源" prop="type">
  123. <el-radio-group v-model="tabconfig.type" >
  124. <el-radio label="mysql">mysql</el-radio>
  125. <el-radio label="mssql">mssql</el-radio>
  126. </el-radio-group>
  127. </el-form-item>
  128. <el-form-item label="主机地址" >
  129. <el-input v-model="tabconfig.host" placeholder="请输入主机地址" />
  130. </el-form-item>
  131. <el-form-item label="端口号">
  132. <el-input v-model="tabconfig.port" placeholder="请输入端口号" />
  133. </el-form-item>
  134. <el-form-item label="用户名">
  135. <el-input v-model="tabconfig.user" placeholder="请输入用户名" />
  136. </el-form-item>
  137. <el-form-item label="密码">
  138. <el-input v-model="tabconfig.passwd" placeholder="请输入密码" />
  139. </el-form-item>
  140. <el-form-item label="数据库名称">
  141. <el-input v-model="tabconfig.dbName" placeholder="请输入数据库名称" />
  142. </el-form-item>
  143. <el-form-item label="表名称">
  144. <el-input v-model="tabconfig.tableName" placeholder="请输入表名称" />
  145. </el-form-item>
  146. <el-form-item label="主键字段">
  147. <el-input v-model="tabconfig.pk" placeholder="请输入主键字段" />
  148. </el-form-item>
  149. <el-form-item label="每次获取数量">
  150. <el-input v-model="tabconfig.num" placeholder="请输入每次获取数量" />
  151. </el-form-item>
  152. <el-form-item label="任务表达式">
  153. <div style="display:flex">
  154. <el-input v-model="tabconfig.cronExpression" placeholder="请输入cron任务表达式" />
  155. <el-button type="success" @click="showCron('tabconfig')" style=" margin-left: 5px;">设置</el-button>
  156. </div>
  157. </el-form-item>
  158. </div>
  159. </el-form>
  160. <template #footer>
  161. <span class="dialog-footer">
  162. <el-button @click="onTest" type="warning" size="default" v-if="ruleForm.sourceId > 0">测试</el-button>
  163. <el-button @click="onCancel" size="default">取 消</el-button>
  164. <el-button type="primary" @click="onSubmit" size="default">{{ ruleForm.sourceId !== 0 ? '修 改' : '添 加' }}</el-button>
  165. </span>
  166. </template>
  167. </el-dialog>
  168. <el-dialog v-model="dialogVisible" title="返回Json数据" width="30%">
  169. <JsonViewer :value="jsonData" boxed sort theme="jv-dark" @click="onKeyclick" />
  170. <template #footer>
  171. <span class="dialog-footer">
  172. <el-button @click="dialogVisible = false">关闭</el-button>
  173. </span>
  174. </template>
  175. </el-dialog>
  176. <el-dialog v-model="cronShow" title="选择Cron规则" width="60%">
  177. <vue3cron @handlelisten="handlelisten" :type="crontype" @close="cronclose"></vue3cron>
  178. </el-dialog>
  179. </div>
  180. </template>
  181. <script lang="ts">
  182. import { reactive, toRefs, defineComponent, ref, unref } from 'vue';
  183. import api from '/@/api/datahub';
  184. import 'vue3-json-viewer/dist/index.css';
  185. import vue3cron from '/@/components/vue3cron/vue3cron.vue';
  186. import { ElMessage } from 'element-plus';
  187. import { Delete, Plus, CircleClose, Minus, Right } from '@element-plus/icons-vue';
  188. interface RuleFormState {
  189. sourceId: number;
  190. name: string;
  191. from: number;
  192. key: string;
  193. userName: string;
  194. password: string;
  195. desc: string;
  196. status: number;
  197. }
  198. interface DicState {
  199. isShowDialog: boolean;
  200. ruleForm: RuleFormState;
  201. rules: {};
  202. }
  203. export default defineComponent({
  204. name: 'Edit',
  205. components: { Delete, Plus, CircleClose, Minus, Right,vue3cron },
  206. setup(prop, { emit }) {
  207. const myRef = ref<HTMLElement | null>(null);
  208. const formRef = ref<HTMLElement | null>(null);
  209. const state = reactive<DicState>({
  210. isShowDialog: false,
  211. dialogVisible: false,
  212. cronShow:false,
  213. crontype:'',
  214. config: {},
  215. devconfig: {},
  216. tabconfig: {},
  217. sourceData: [],
  218. sourceId: 0,
  219. jsonData: '',
  220. ruledata: [
  221. {
  222. expression: '',
  223. replace: '',
  224. //params: {},
  225. },
  226. ],
  227. rule: [
  228. {
  229. expression: '',
  230. replace: '',
  231. // params: {
  232. // name: '',
  233. // value: '',
  234. // },
  235. },
  236. ],
  237. requestParams: [
  238. [
  239. {
  240. type: '',
  241. key: '',
  242. name: '',
  243. value: '',
  244. },
  245. ],
  246. ],
  247. methodData: [
  248. {
  249. label: 'GET',
  250. value: 'get',
  251. },
  252. {
  253. label: 'POST',
  254. value: 'post',
  255. },
  256. {
  257. label: 'PUT',
  258. value: 'put',
  259. },
  260. ],
  261. unitData: [
  262. {
  263. label: '秒',
  264. value: 'second',
  265. },
  266. {
  267. label: '分',
  268. value: 'minute',
  269. },
  270. {
  271. label: '时',
  272. value: 'hour',
  273. },
  274. {
  275. label: '天',
  276. value: 'day',
  277. },
  278. ],
  279. paramData: [
  280. {
  281. lable: 'header',
  282. value: 'header',
  283. },
  284. {
  285. lable: 'body',
  286. value: 'body',
  287. },
  288. {
  289. lable: 'param',
  290. value: 'param',
  291. },
  292. ],
  293. ruleForm: {
  294. sourceId: 0,
  295. name: '',
  296. from: 1,
  297. key: '',
  298. rule: [],
  299. config: {
  300. method: '',
  301. url: '',
  302. interval: '',
  303. intervalUnit: '',
  304. requestParams: [],
  305. },
  306. desc: '',
  307. },
  308. rules: {
  309. key: [{ required: true, message: '数据源标识不能为空', trigger: 'blur' }],
  310. name: [{ required: true, message: '数据源名称不能为空', trigger: 'blur' }],
  311. from: [{ required: true, message: '数据源类型不能为空', trigger: 'blur' }],
  312. },
  313. });
  314. const delParams = (index) => {
  315. state.requestParams.splice(index, 1);
  316. };
  317. const delParamss = (index, bbb) => {
  318. state.requestParams[index].splice(bbb, 1);
  319. };
  320. const addParamss = () => {
  321. state.requestParams.push([
  322. {
  323. type: '',
  324. key: '',
  325. name: '',
  326. value: '',
  327. },
  328. ]);
  329. console.log(state.requestParams);
  330. };
  331. const addParams = (index) => {
  332. state.requestParams[index].push({
  333. type: '',
  334. key: '',
  335. name: '',
  336. value: '',
  337. });
  338. };
  339. const delRule = (index) => {
  340. state.rule.splice(index, 1);
  341. };
  342. const addRule = () => {
  343. state.rule.push({
  344. expression: '',
  345. replace: '',
  346. // params: {
  347. // name: '',
  348. // value: '',
  349. // },
  350. });
  351. };
  352. // 打开弹窗
  353. const openDialog = (row: RuleFormState | null) => {
  354. resetForm();
  355. getDevData();
  356. console.log(state.requestParams);
  357. if (row) {
  358. state.sourceId = row.sourceId;
  359. api.common.detail(row.sourceId).then((res: any) => {
  360. state.ruleForm = res.data;
  361. if (res.data.from == 1) {
  362. state.config = res.data.apiConfig;
  363. state.requestParams = res.data.apiConfig.requestParams;
  364. } else if (res.data.from == 4) {
  365. state.devconfig = res.data.deviceConfig;
  366. } else if (res.data.from == 2) {
  367. state.tabconfig = res.data.dbConfig;
  368. }
  369. res.data.sourceRule.forEach((item, index) => {
  370. state.rule[index].expression = item.expression;
  371. state.rule[index].replace = item.replace;
  372. // state.rule[index].params.name = Object.keys(item.params);
  373. // state.rule[index].params.value = item.params[Object.keys(item.params)];
  374. });
  375. });
  376. }
  377. state.isShowDialog = true;
  378. };
  379. const onKeyclick = (e) => {
  380. if (e.target.innerText && e.target.className == 'jv-key') {
  381. let str = e.target.innerText;
  382. str = str.substr(0, str.length - 1);
  383. console.log(str);
  384. }
  385. };
  386. const resetForm = () => {
  387. state.devconfig = {};
  388. state.tabconfig = {};
  389. state.ruleForm = {
  390. sourceId: 0,
  391. name: '',
  392. from: 1,
  393. key: '',
  394. rule: [],
  395. config: {
  396. method: '',
  397. url: '',
  398. interval: '',
  399. intervalUnit: '',
  400. requestParams: [],
  401. },
  402. desc: '',
  403. };
  404. };
  405. // 关闭弹窗
  406. const closeDialog = () => {
  407. state.isShowDialog = false;
  408. };
  409. // 取消
  410. const onCancel = () => {
  411. closeDialog();
  412. };
  413. const getDevData = () => {
  414. api.common.getdevList({}).then((res: any) => {
  415. state.sourceData = res.device;
  416. });
  417. };
  418. const setNode = (event) => {
  419. state.sourceData.forEach((item, index) => {
  420. if (item.id == event) {
  421. state.devconfig.productKey = item.product.key;
  422. state.devconfig.deviceKey = item.key;
  423. }
  424. });
  425. };
  426. const onTest = () => {
  427. if (state.ruleForm.from == 1) {
  428. api.common.api(state.sourceId).then((res: any) => {
  429. state.jsonData = JSON.parse(res.data);
  430. state.dialogVisible = true;
  431. console.log(res);
  432. });
  433. } else if (state.ruleForm.from == 4) {
  434. api.common.devapi(state.sourceId).then((res: any) => {
  435. state.jsonData = JSON.parse(res.data);
  436. state.dialogVisible = true;
  437. console.log(res);
  438. });
  439. }
  440. };
  441. // 新增
  442. const onSubmit = () => {
  443. const formWrap = unref(formRef) as any;
  444. console.log(formWrap);
  445. if (!formWrap) return;
  446. formWrap.validate((valid: boolean) => {
  447. if (valid) {
  448. //修改rule数据
  449. // state.rule.forEach((item, index) => {
  450. // item.params[item.params.name] = item.params.value;
  451. // delete item.params.name;
  452. // delete item.params.value;
  453. // });
  454. state.ruleForm.rule = state.rule;
  455. if (state.ruleForm.from == 1) {
  456. state.config.requestParams = state.requestParams;
  457. state.ruleForm.config = state.config;
  458. } else if (state.ruleForm.from == 4) {
  459. state.ruleForm.config = state.devconfig;
  460. }else if (state.ruleForm.from == 2) {
  461. state.ruleForm.config = state.tabconfig;
  462. }
  463. if (state.ruleForm.sourceId !== 0) {
  464. //修改
  465. if (state.ruleForm.from == 1) {
  466. api.common.edit(state.ruleForm).then(() => {
  467. ElMessage.success('数据源类型修改成功');
  468. closeDialog(); // 关闭弹窗
  469. emit('typeList');
  470. });
  471. } else if (state.ruleForm.from == 4) {
  472. api.common.devedit(state.ruleForm).then(() => {
  473. ElMessage.success('数据源类型修改成功');
  474. closeDialog(); // 关闭弹窗
  475. emit('typeList');
  476. });
  477. }else if (state.ruleForm.from == 2) {
  478. api.common.dbedit(state.ruleForm).then(() => {
  479. ElMessage.success('数据源类型修改成功');
  480. closeDialog(); // 关闭弹窗
  481. emit('typeList');
  482. });
  483. }
  484. } else {
  485. //添加
  486. if (state.ruleForm.from == 1) {
  487. api.common.add(state.ruleForm).then(() => {
  488. ElMessage.success('数据源类型添加成功');
  489. closeDialog(); // 关闭弹窗
  490. emit('typeList');
  491. });
  492. } else if (state.ruleForm.from == 4) {
  493. api.common.devadd(state.ruleForm).then(() => {
  494. ElMessage.success('数据源类型添加成功');
  495. closeDialog(); // 关闭弹窗
  496. emit('typeList');
  497. });
  498. }else if (state.ruleForm.from == 2) {
  499. api.common.dbadd(state.ruleForm).then(() => {
  500. ElMessage.success('数据源类型添加成功');
  501. closeDialog(); // 关闭弹窗
  502. emit('typeList');
  503. });
  504. }
  505. }
  506. }
  507. });
  508. };
  509. const handlelisten = (e) => {
  510. console.log(e);
  511. if(e.type=='config'){
  512. state.config.cronExpression=e.cron
  513. }else if(e.type=='tabconfig'){
  514. state.tabconfig.cronExpression=e.cron
  515. }
  516. };
  517. const showCron=(type)=>{
  518. state.crontype=type
  519. state.cronShow=true;
  520. };
  521. const cronclose=()=>{
  522. state.cronShow=false;
  523. }
  524. return {
  525. cronclose,
  526. showCron,
  527. onTest,
  528. addRule,
  529. delRule,
  530. handlelisten,
  531. addParams,
  532. addParamss,
  533. delParamss,
  534. delParams,
  535. onKeyclick,
  536. openDialog,
  537. setNode,
  538. closeDialog,
  539. getDevData,
  540. onCancel,
  541. onSubmit,
  542. formRef,
  543. myRef,
  544. ...toRefs(state),
  545. };
  546. },
  547. });
  548. </script>
  549. <style>
  550. .el-input__wrapper {
  551. width: 98%;
  552. }
  553. .box-content {
  554. border: 1px solid #e8e8e8;
  555. margin: 10px;
  556. padding: 10px;
  557. }
  558. .content-f {
  559. display: flex;
  560. margin-bottom: 10px;
  561. }
  562. .content-f .el-input__wrapper {
  563. margin-right: 5px;
  564. }
  565. .addbutton {
  566. width: 100%;
  567. margin-top: 10px;
  568. background: #fff;
  569. border: 1px solid #d1d1d1;
  570. color: #8d8b8b;
  571. }
  572. .conicon {
  573. width: 55px;
  574. height: 25px;
  575. font-size: 28px;
  576. line-height: 28px;
  577. cursor: pointer;
  578. }
  579. .jv-node {
  580. margin-left: 25px;
  581. }
  582. </style>