queryTemplateColumn.vue 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502
  1. <template>
  2. <div class="airportInfo scroll-y">
  3. <div class="wrap">
  4. <Minheader :is-auth="true" :is-statuser="true" @addForm="addForm">
  5. <template #header>
  6. <div class="status flex-wrap">
  7. <div class="manageTitle">查询项设置</div>
  8. </div>
  9. </template></Minheader
  10. >
  11. <div class="app-containers">
  12. <DataTable
  13. :tableHeader="tableCols"
  14. :tableData="tableData"
  15. :tableBtnGroup="tableBtnGroup"
  16. :tableProperty="{ rowKey: 'ID' }"
  17. @btnClick="btnClick"
  18. />
  19. </div>
  20. <Dialog
  21. width="734px"
  22. :flag="flag"
  23. :type="type"
  24. :msgTitle="msgTitle"
  25. @resetForm="resetForm"
  26. @delRest="delRest"
  27. @submitForm="submitForm"
  28. @delRemove="delRemove"
  29. >
  30. <div class="diacont">
  31. <el-form
  32. :model="tableForm"
  33. :rules="formRules"
  34. ref="queryTemplateColumnForm"
  35. >
  36. <el-row :gutter="24">
  37. <el-col :span="12">
  38. <el-form-item
  39. label="名称"
  40. size="default"
  41. prop="columnName"
  42. :rules="formRules.isNotNull"
  43. >
  44. <el-input
  45. v-model="tableForm.columnName"
  46. placeholder="请输入名称"
  47. />
  48. </el-form-item>
  49. </el-col>
  50. <el-col :span="12">
  51. <el-form-item
  52. label="标签"
  53. size="default"
  54. prop="columnLabel"
  55. :rules="formRules.isNotNull"
  56. >
  57. <el-input
  58. v-model="tableForm.columnLabel"
  59. placeholder="请输入标签"
  60. />
  61. </el-form-item>
  62. </el-col>
  63. <el-col :span="12">
  64. <el-form-item label="描述" size="default">
  65. <el-input
  66. v-model="tableForm.columnDescribe"
  67. placeholder="请输入描述"
  68. />
  69. </el-form-item>
  70. </el-col>
  71. <el-col :span="12">
  72. <el-form-item label="排序" size="default">
  73. <el-select
  74. style="width: 100%"
  75. v-model="tableForm.needSort"
  76. class="input-shadow"
  77. filterable
  78. default-first-option
  79. clearable
  80. placeholder="请选择"
  81. >
  82. <el-option
  83. v-for="item in tableOptionser"
  84. :key="item.v ? item.v : item.planDepartureApt"
  85. :label="item.k ? item.k : item.planDepartureApt"
  86. :value="item.v ? item.v : item.planDepartureApt"
  87. >
  88. </el-option>
  89. </el-select>
  90. </el-form-item>
  91. </el-col>
  92. <el-col :span="12">
  93. <el-form-item label="过滤" size="default">
  94. <el-select
  95. style="width: 100%"
  96. v-model="tableForm.needFilters"
  97. class="input-shadow"
  98. filterable
  99. default-first-option
  100. clearable
  101. placeholder="请选择"
  102. >
  103. <el-option
  104. v-for="item in tableOptionser"
  105. :key="item.v ? item.v : item.planDepartureApt"
  106. :label="item.k ? item.k : item.planDepartureApt"
  107. :value="item.v ? item.v : item.planDepartureApt"
  108. >
  109. </el-option>
  110. </el-select>
  111. </el-form-item>
  112. </el-col>
  113. <el-col :span="12">
  114. <el-form-item label="显示" size="default">
  115. <el-select
  116. style="width: 100%"
  117. v-model="tableForm.needShow"
  118. class="input-shadow"
  119. filterable
  120. default-first-option
  121. clearable
  122. placeholder="请选择"
  123. >
  124. <el-option
  125. v-for="item in tableOptionser"
  126. :key="item.v ? item.v : item.planDepartureApt"
  127. :label="item.k ? item.k : item.planDepartureApt"
  128. :value="item.v ? item.v : item.planDepartureApt"
  129. >
  130. </el-option>
  131. </el-select>
  132. </el-form-item>
  133. </el-col>
  134. <el-col :span="12">
  135. <el-form-item label="数据类型" size="default">
  136. <el-input
  137. v-model="tableForm.dataType"
  138. placeholder="请输入数据类型"
  139. />
  140. </el-form-item>
  141. </el-col>
  142. <el-col :span="12">
  143. <el-form-item label="分组" size="default">
  144. <el-select
  145. style="width: 100%"
  146. v-model="tableForm.needGroup"
  147. class="input-shadow"
  148. filterable
  149. default-first-option
  150. clearable
  151. placeholder="请选择"
  152. >
  153. <el-option
  154. v-for="item in tableOptionser"
  155. :key="item.v ? item.v : item.planDepartureApt"
  156. :label="item.k ? item.k : item.planDepartureApt"
  157. :value="item.v ? item.v : item.planDepartureApt"
  158. >
  159. </el-option>
  160. </el-select>
  161. </el-form-item>
  162. </el-col>
  163. <el-col :span="12">
  164. <el-form-item label="下拉" size="default">
  165. <el-select
  166. style="width: 100%"
  167. v-model="tableForm.listqueryTemplateID"
  168. class="input-shadow"
  169. filterable
  170. default-first-option
  171. clearable
  172. placeholder="请选择"
  173. >
  174. <el-option
  175. v-for="item in tableOptionser"
  176. :key="item.v ? item.v : item.planDepartureApt"
  177. :label="item.k ? item.k : item.planDepartureApt"
  178. :value="item.v ? item.v : item.planDepartureApt"
  179. >
  180. </el-option>
  181. </el-select>
  182. </el-form-item>
  183. </el-col>
  184. <el-col :span="12">
  185. <el-form-item label="合计" size="default">
  186. <el-select
  187. style="width: 100%"
  188. v-model="tableForm.needCount"
  189. class="input-shadow"
  190. filterable
  191. default-first-option
  192. clearable
  193. placeholder="请选择"
  194. >
  195. <el-option
  196. v-for="item in tableOptionser"
  197. :key="item.v ? item.v : item.planDepartureApt"
  198. :label="item.k ? item.k : item.planDepartureApt"
  199. :value="item.v ? item.v : item.planDepartureApt"
  200. >
  201. </el-option>
  202. </el-select>
  203. </el-form-item>
  204. </el-col>
  205. <el-col :span="12">
  206. <el-form-item label="字段排序" size="default">
  207. <el-select
  208. style="width: 100%"
  209. v-model="tableForm.orderNumber"
  210. class="input-shadow"
  211. filterable
  212. default-first-option
  213. clearable
  214. placeholder="请选择"
  215. >
  216. <el-option
  217. v-for="item in tableOptionser"
  218. :key="item.v ? item.v : item.planDepartureApt"
  219. :label="item.k ? item.k : item.planDepartureApt"
  220. :value="item.v ? item.v : item.planDepartureApt"
  221. >
  222. </el-option>
  223. </el-select>
  224. </el-form-item>
  225. </el-col>
  226. </el-row>
  227. </el-form>
  228. </div>
  229. </Dialog>
  230. </div>
  231. </div>
  232. </template>
  233. <script setup lang="ts">
  234. import DataTable from "@/components/tableTemp/index.vue";
  235. import Minheader from "@/components/minheader/index.vue";
  236. import Dialog from "@/components/dialog/index.vue";
  237. import { Query, GeneralDataReception } from "@/api/webApi";
  238. import { ElMessage } from "element-plus";
  239. const route = useRoute();
  240. const formRules = useElement().formRules;
  241. const page = ref<number>(0); //分页参数
  242. const dataContent = ref<object>({});
  243. const noMore = ref<Boolean>(false);
  244. const rowTitle = ref<String>("");
  245. const tableCols = ref([]); //表头数据
  246. const serviceId = ref<String>("");
  247. const tableObj = ref({}); //增删改数据缓存
  248. const flag = ref<Boolean>(false); //弹窗开关
  249. const type = ref<String>(""); //判断是否删除
  250. const msgTitle = ref<String>("新增查询项"); //弹窗标题
  251. const tableColsCopys = reactive<Object>({}); //弹窗
  252. const tableOptionser = ref<Array>([
  253. {
  254. k: "是",
  255. v: "1",
  256. },
  257. {
  258. k: "否",
  259. v: "0",
  260. },
  261. ]); //弹窗下拉
  262. const tableForm = reactive({
  263. queryTemplateColumnSetID: "",
  264. queryTemplateID: route.query.queryTemplateID,
  265. columnName: "",
  266. columnLabel: "",
  267. columnDescribe: "",
  268. needSort: "",
  269. needFilters: "",
  270. needShow: "",
  271. needGroup: "",
  272. dataType: "",
  273. listqueryTemplateID: "",
  274. needCount: "",
  275. orderNumber: "",
  276. needSearch: "",
  277. event: "",
  278. }); //弹窗内容
  279. //列表
  280. const tableData = ref([]);
  281. //表头
  282. const state = reactive({
  283. list: [
  284. { label: "名称", key: "name" },
  285. { label: "标签", key: "china" },
  286. { label: "描述", key: "englin" },
  287. { label: "排序", key: "two" },
  288. { label: "过滤", key: "three" },
  289. { label: "显示", key: "text" },
  290. { label: "分组", key: "text1" },
  291. { label: "下拉", key: "text2" },
  292. { label: "数据类型", key: "text3" },
  293. { label: "字段排位", key: "text4" },
  294. { label: "合计", key: "text5" },
  295. ],
  296. listLoading: true,
  297. });
  298. const tableBtnGroup = ref([
  299. {
  300. name: "编辑",
  301. className: "editBtn",
  302. param: 2,
  303. },
  304. {
  305. name: "删除",
  306. className: "delBtn",
  307. param: 3,
  308. },
  309. ]);
  310. //新增
  311. const addForm = () => {
  312. msgTitle.value = "新增查询项";
  313. flag.value = true;
  314. tableForm.event = 1;
  315. type.value = "";
  316. };
  317. //取消
  318. const resetForm = () => {
  319. flag.value = false;
  320. tableForm.queryTemplateColumnSetID = "";
  321. tableForm.columnName = "";
  322. tableForm.columnLabel = "";
  323. tableForm.columnDescribe = "";
  324. tableForm.needSort = "";
  325. tableForm.needFilters = "";
  326. tableForm.needShow = "";
  327. tableForm.needGroup = "";
  328. tableForm.dataType = "";
  329. tableForm.listqueryTemplateID = "";
  330. tableForm.needCount = "";
  331. tableForm.orderNumber = "";
  332. tableForm.needSearch = "";
  333. };
  334. //编辑
  335. // const editDialog = (data) => {
  336. // msgTitle.value = "编辑航司信息维护";
  337. // flag.value = true;
  338. // type.value = "";
  339. // tableForm.name = data.name;
  340. // tableForm.china = data.china;
  341. // tableForm.englin = data.englin;
  342. // tableForm.two = data.two;
  343. // tableForm.three = data.three;
  344. // tableForm.text = data.text;
  345. // };
  346. //编辑-删除
  347. const btnClick = (row, index, param) => {
  348. if (param === 2) {
  349. msgTitle.value = "编辑查询项";
  350. flag.value = true;
  351. type.value = "";
  352. tableForm.event = 2;
  353. tableForm.queryTemplateColumnSetID = index.queryTemplateColumnSetID;
  354. tableForm.columnName = index.columnName;
  355. tableForm.columnLabel = index.columnLabel;
  356. tableForm.columnDescribe = index.columnDescribe;
  357. tableForm.needSort = index.needSort === "需要" ? "1" : "0";
  358. tableForm.needFilters = index.needFilters === "需要" ? "1" : "0";
  359. tableForm.needShow = index.needShow === "需要" ? "1" : "0";
  360. tableForm.needGroup = index.needGroup === "需要" ? "1" : "0";
  361. tableForm.dataType = index.dataType;
  362. tableForm.listqueryTemplateID =
  363. index.listqueryTemplateID === "需要" ? "1" : "0";
  364. tableForm.needCount = index.needCount === "需要" ? "1" : "0";
  365. tableForm.orderNumber = index.orderNumber === "需要" ? "1" : "0";
  366. tableForm.needSearch = index.needSearch;
  367. } else if (param === 3) {
  368. msgTitle.value = "删除查询项";
  369. flag.value = true;
  370. type.value = "del";
  371. tableForm.event = 3;
  372. tableForm.queryTemplateColumnSetID = index.queryTemplateColumnSetID;
  373. tableForm.columnName = index.columnName;
  374. tableForm.columnLabel = index.columnLabel;
  375. tableForm.columnDescribe = index.columnDescribe;
  376. tableForm.needSort = index.needSort;
  377. tableForm.needFilters = index.needFilters;
  378. tableForm.needShow = index.needShow;
  379. tableForm.needGroup = index.needGroup;
  380. tableForm.dataType = index.dataType;
  381. tableForm.listqueryTemplateID = index.listqueryTemplateID;
  382. tableForm.needCount = index.needCount;
  383. tableForm.orderNumber = index.orderNumber;
  384. tableForm.needSearch = index.needSearch;
  385. } else if (param === 4) {
  386. }
  387. };
  388. //删除
  389. const eleDialog = () => {
  390. msgTitle.value = "删除查询项";
  391. flag.value = true;
  392. type.value = "del";
  393. };
  394. const delRemove = () => {
  395. tableForm.event = 3;
  396. generalDataReception(tableForm);
  397. };
  398. //删除
  399. const delRest = () => {
  400. flag.value = false;
  401. };
  402. //获取表格数据
  403. const getQuery = async () => {
  404. try {
  405. const { code, returnData } = await Query({
  406. id: DATACONTENT_ID.sysQueryChildTabId,
  407. needPage: ++page.value,
  408. dataContent: [route.query.queryTemplateID],
  409. });
  410. if (code === "0") {
  411. if (returnData.listValues.length === 0) {
  412. page.value--;
  413. noMore.value = true;
  414. }
  415. const titleColumn = returnData.columnSet.find(
  416. (item) => item.needShow === 1
  417. );
  418. if (titleColumn) {
  419. rowTitle.value = titleColumn.columnName;
  420. }
  421. tableData.value.push(...returnData.listValues);
  422. tableCols.value = returnData.columnSet;
  423. tableCols.value.forEach((element) => {
  424. element.label = element.columnLabel;
  425. element.key = element.columnName;
  426. // if (element.columnName === "queryTemplate") {
  427. // element.width = "300px";
  428. // }
  429. });
  430. serviceId.value = returnData.submitID;
  431. } else {
  432. page.value--;
  433. }
  434. } catch (error) {
  435. page.value--;
  436. }
  437. };
  438. //确认提交
  439. const queryTemplateColumnForm: any = ref(null);
  440. const submitForm = () => {
  441. queryTemplateColumnForm.value.validate((valid: any) => {
  442. if (valid) {
  443. generalDataReception(tableForm);
  444. } else {
  445. return false;
  446. }
  447. });
  448. };
  449. const resetTable = () => {
  450. page.value = 0;
  451. noMore.value = false;
  452. tableData.value = [];
  453. };
  454. //新增-编辑-删除
  455. const generalDataReception = async (data) => {
  456. try {
  457. let obj = {
  458. IATACode: route.query.IATACode,
  459. };
  460. data = {
  461. ...data,
  462. ...obj,
  463. };
  464. const { code } = await GeneralDataReception({
  465. serviceId: serviceId.value,
  466. dataContent: JSON.stringify(data),
  467. });
  468. if (code == 0) {
  469. ElMessage.success(`操作成功`);
  470. // this.$message.success("操作成功");
  471. resetTable();
  472. getQuery();
  473. resetForm();
  474. flag.value = false;
  475. // rmFlag.value = false;
  476. tableObj.value = {};
  477. // this.$router.go(0);
  478. } else {
  479. ElMessage.error(`操作失败`);
  480. // this.$message.error("操作失败");
  481. // this.flag = false;
  482. // this.rmFlag = false;
  483. tableObj.value = {};
  484. resetForm();
  485. }
  486. } catch (error) {
  487. flag.value = false;
  488. // rmFlag.value = false;
  489. tableObj.value = {};
  490. resetForm();
  491. }
  492. };
  493. getQuery();
  494. </script>
  495. <style lang="scss" scoped>
  496. ::v-deep .el-form-item__label {
  497. width: 100px;
  498. }
  499. .app-containers {
  500. height: calc(100vh - 180px);
  501. }
  502. </style>