index.vue 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547
  1. <template>
  2. <div class="airportInfo">
  3. <div class="header">
  4. <div
  5. :class="action === index ? 'navs' : 'nav'"
  6. v-for="(item, index) in levelList"
  7. :key="index"
  8. @click="up(index)"
  9. >
  10. {{ item.name }}
  11. </div>
  12. </div>
  13. <div class="variable">
  14. <StatisticsHeader
  15. :title="titleTop"
  16. :items="formItems"
  17. :data="formData"
  18. :eledata="eledata"
  19. with-setting
  20. :withSetting="false"
  21. :withExport="true"
  22. @getFormData="getFormData"
  23. @export="tableToExcel"
  24. />
  25. </div>
  26. <div class="echart">
  27. <Echarts :id="dataid" :option="tableData" />
  28. </div>
  29. </div>
  30. </template>
  31. <script>
  32. import Echarts from "../components/echart/index.vue";
  33. import StatisticsHeader from "../components/echart/statisticsHeader.vue";
  34. import { export_json_to_excel } from "@/utils/Export2Excel";
  35. import { Query } from "@/api/webApi";
  36. export default {
  37. name: "ChartsBar",
  38. data() {
  39. return {
  40. action: 0,
  41. dataid: "collection_ecahrt0",
  42. listqueryTemplateID: DATACONTENT_ID.modeLoadingweight,
  43. eledata: null,
  44. set: "",
  45. isShow: Echarts,
  46. tableList: [],
  47. listname: "",
  48. listHeader: [],
  49. tableData: {
  50. time: [],
  51. data1: [],
  52. data2: [],
  53. kg: "",
  54. tyol: "",
  55. },
  56. formData: {
  57. airport: "",
  58. dateTime: "",
  59. },
  60. titleTop: "加货重量统计",
  61. levelList: [
  62. {
  63. name: "加货重量统计",
  64. },
  65. {
  66. name: "航班量统计",
  67. },
  68. {
  69. name: "特货统计",
  70. },
  71. {
  72. name: "货量统计",
  73. },
  74. ],
  75. formItems: [
  76. {
  77. prop: "fttp",
  78. inputType: "select",
  79. placeholder: "国内国际",
  80. requiredWarning: "请先选择国内国际",
  81. clearable: true,
  82. options: [
  83. {
  84. value: "国内离港",
  85. label: "国内离港",
  86. },
  87. {
  88. value: "国际离港",
  89. label: "国际离港",
  90. },
  91. ],
  92. },
  93. {
  94. prop: "kht",
  95. inputType: "select",
  96. placeholder: "客货类型",
  97. requiredWarning: "请先选择客货类型",
  98. clearable: true,
  99. options: [
  100. {
  101. value: "客机",
  102. label: "客机",
  103. },
  104. {
  105. value: "货机",
  106. label: "货机",
  107. },
  108. {
  109. value: "其它",
  110. label: "其它",
  111. },
  112. {
  113. value: "全部",
  114. label: "全部",
  115. },
  116. ],
  117. },
  118. {
  119. prop: "td",
  120. inputType: "select",
  121. placeholder: "统计维度",
  122. requiredWarning: "请先选择统计时间维度",
  123. clearable: true,
  124. options: [
  125. {
  126. value: "月",
  127. label: "月",
  128. },
  129. {
  130. value: "年",
  131. label: "年",
  132. },
  133. ],
  134. },
  135. {
  136. prop: "spe",
  137. inputType: "select",
  138. placeholder: "特货类型",
  139. requiredWarning: "",
  140. clearable: true,
  141. disabled: true,
  142. options: [
  143. {
  144. value: "贵重物品",
  145. label: "贵重物品",
  146. },
  147. {
  148. value: "鲜活",
  149. label: "鲜活",
  150. },
  151. {
  152. value: "动物",
  153. label: "动物",
  154. },
  155. {
  156. value: "邮件",
  157. label: "邮件",
  158. },
  159. {
  160. value: "锂电池",
  161. label: "锂电池",
  162. },
  163. {
  164. value: "全部",
  165. label: "全部",
  166. },
  167. ],
  168. },
  169. {
  170. prop: "set",
  171. inputType: "select",
  172. placeholder: "统计运单",
  173. requiredWarning: "",
  174. clearable: true,
  175. disabled: true,
  176. options: [
  177. {
  178. value: "1",
  179. label: "统计运单",
  180. },
  181. {
  182. value: "2",
  183. label: "统计重量",
  184. },
  185. ],
  186. },
  187. {
  188. prop: "dateTime",
  189. inputType: "datePicker",
  190. clearable: true,
  191. width: "240px",
  192. options: [],
  193. },
  194. ],
  195. };
  196. },
  197. mounted() {
  198. // this.getQuery([]);
  199. },
  200. watch: {
  201. // 监听数据变化,重绘折线图
  202. option: {
  203. deep: true,
  204. handler(newVal) {},
  205. },
  206. },
  207. destroyed() {},
  208. methods: {
  209. up(index) {
  210. this.action = index;
  211. if (index === 0) {
  212. this.eledata = 0;
  213. this.dataid = "collection_ecahrt0";
  214. this.listqueryTemplateID = DATACONTENT_ID.modeLoadingweight;
  215. this.titleTop = "加货重量统计";
  216. this.tableData.time = [];
  217. this.tableData.data1 = [];
  218. this.tableData.data2 = [];
  219. this.formItems[3].disabled = true;
  220. this.formItems[4].disabled = true;
  221. this.formItems[0].options = [
  222. {
  223. value: "国内离港",
  224. label: "国内离港",
  225. },
  226. {
  227. value: "国际离港",
  228. label: "国际离港",
  229. },
  230. ];
  231. } else if (index === 1) {
  232. this.eledata = 1;
  233. this.dataid = "collection_ecahrt1";
  234. this.formItems[3].disabled = true;
  235. this.formItems[4].disabled = true;
  236. this.formItems[0].options = [
  237. {
  238. value: "国内离港",
  239. label: "国内离港",
  240. },
  241. {
  242. value: "国际离港",
  243. label: "国际离港",
  244. },
  245. {
  246. value: "国内进港",
  247. label: "国内进港",
  248. },
  249. {
  250. value: "国际进港",
  251. label: "国际进港",
  252. },
  253. ];
  254. this.tableData.time = [];
  255. this.tableData.data1 = [];
  256. this.tableData.data2 = [];
  257. this.listqueryTemplateID = DATACONTENT_ID.modeFlightvolume;
  258. // this.getQuery();
  259. this.titleTop = "航班量统计";
  260. } else if (index === 2) {
  261. this.dataid = "collection_ecahrt2";
  262. this.formItems[3].disabled = false;
  263. this.formItems[4].disabled = false;
  264. this.tableData.time = [];
  265. this.tableData.data1 = [];
  266. this.tableData.data2 = [];
  267. this.formItems[0].options = [
  268. {
  269. value: "国内离港",
  270. label: "国内离港",
  271. },
  272. {
  273. value: "国际离港",
  274. label: "国际离港",
  275. },
  276. {
  277. value: "国内进港",
  278. label: "国内进港",
  279. },
  280. {
  281. value: "国际进港",
  282. label: "国际进港",
  283. },
  284. ];
  285. this.eledata = 2;
  286. this.listqueryTemplateID = DATACONTENT_ID.modeSpecialgoods;
  287. this.titleTop = "特货统计";
  288. } else if (index === 3) {
  289. this.dataid = "collection_ecahrt3";
  290. this.tableData.time = [];
  291. this.tableData.data1 = [];
  292. this.tableData.data2 = [];
  293. this.formItems[0].options = [
  294. {
  295. value: "国内离港",
  296. label: "国内离港",
  297. },
  298. {
  299. value: "国际离港",
  300. label: "国际离港",
  301. },
  302. {
  303. value: "国内进港",
  304. label: "国内进港",
  305. },
  306. {
  307. value: "国际进港",
  308. label: "国际进港",
  309. },
  310. ];
  311. this.formItems[3].disabled = true;
  312. this.formItems[4].disabled = true;
  313. this.eledata = 3;
  314. this.titleTop = "货量统计";
  315. this.listqueryTemplateID = DATACONTENT_ID.modeCargostatistics;
  316. }
  317. },
  318. getFormData(data) {
  319. this.tableData.time = [];
  320. this.tableData.data1 = [];
  321. this.tableData.data2 = [];
  322. if (this.action === 2) {
  323. this.set = data.set;
  324. let option = [
  325. {
  326. fttp: data.fttp,
  327. kht: data.kht,
  328. td: data.td,
  329. fd1: data.dateTime[0],
  330. fd2: data.dateTime[1],
  331. spe: data.spe,
  332. },
  333. ];
  334. this.getQuery(option, data.set);
  335. } else {
  336. let option = [
  337. {
  338. fttp: data.fttp,
  339. kht: data.kht,
  340. td: data.td,
  341. fd1: data.dateTime[0],
  342. fd2: data.dateTime[1],
  343. },
  344. ];
  345. this.getQuery(option, null);
  346. }
  347. if (this.action === 0) {
  348. this.listname =
  349. "加货重量统计" +
  350. data.fttp +
  351. data.kht +
  352. data.td +
  353. data.dateTime[0] +
  354. "--" +
  355. data.dateTime[1];
  356. this.listHeader = ["序号", "时间", "重量"];
  357. } else if (this.action === 1) {
  358. this.listname =
  359. "航班量统计" +
  360. data.fttp +
  361. data.kht +
  362. data.td +
  363. data.dateTime[0] +
  364. "--" +
  365. data.dateTime[1];
  366. this.listHeader = ["序号", "时间", "重量"];
  367. } else if (this.action === 2) {
  368. this.listname =
  369. "特货统计" +
  370. data.fttp +
  371. data.kht +
  372. data.td +
  373. data.spe +
  374. data.dateTime[0] +
  375. "--" +
  376. data.dateTime[1];
  377. console.log();
  378. if (data.set == 1) {
  379. this.listHeader = ["序号", "时间", "单"];
  380. } else if (data.set == 2) {
  381. this.listHeader = ["序号", "时间", "重量"];
  382. }
  383. } else if (this.action === 3) {
  384. this.listname =
  385. "货量统计" +
  386. data.fttp +
  387. data.kht +
  388. data.td +
  389. data.dateTime[0] +
  390. "--" +
  391. data.dateTime[1];
  392. this.listHeader = ["序号", "时间", "重量"];
  393. }
  394. },
  395. //获取表格数据
  396. async getQuery(data, dat) {
  397. try {
  398. const { code, returnData } = await Query({
  399. id: this.listqueryTemplateID,
  400. dataContent: data,
  401. });
  402. if (code == 0) {
  403. this.tableList = returnData.listValues;
  404. returnData.listValues.forEach((element) => {
  405. if (this.action === 0) {
  406. this.tableData.data2.push(element.weight ? element.weight : 0);
  407. this.tableData.time.push(element.dat);
  408. this.tableData.kg = "单位:吨";
  409. } else if (this.action === 1) {
  410. this.tableData.data2.push(
  411. element.flightNum ? element.flightNum : 0
  412. );
  413. this.tableData.time.push(element.dat);
  414. this.tableData.kg = "单位:班";
  415. } else if (this.action === 2) {
  416. this.tableData.time.push(element.dat);
  417. if (dat == 1) {
  418. this.tableData.data2.push(
  419. element.flightNum ? element.flightNum : 0
  420. );
  421. this.tableData.kg = "单位:单";
  422. } else if (dat == 2) {
  423. this.tableData.kg = "单位:吨";
  424. this.tableData.data2.push(element.weight ? element.weight : 0);
  425. }
  426. } else if (this.action === 3) {
  427. this.tableData.data2.push(element.weight ? element.weight : 0);
  428. this.tableData.time.push(element.fdt);
  429. this.tableData.kg = "单位:吨";
  430. }
  431. this.tableData.data1 = [];
  432. });
  433. let ar = [];
  434. this.tableData.data1.push(0);
  435. for (let index = 0; index < this.tableData.data2.length; index++) {
  436. // const element =
  437. // (this.tableData.data2[index + 1] - this.tableData.data2[index]) /
  438. // this.tableData.data2[index];
  439. // console.log(element);
  440. if (index > 0) {
  441. const element =
  442. (this.tableData.data2[index] -
  443. this.tableData.data2[index - 1]) /
  444. this.tableData.data2[index - 1];
  445. this.tableData.data1.push(element.toFixed(2));
  446. }
  447. }
  448. // this.tableData = returnData.listValues;
  449. // console.log(this.tableData[0])
  450. }
  451. } catch (error) {
  452. this.page--;
  453. }
  454. },
  455. tableToExcel() {
  456. import("../../../utils/Export2Excel").then((excel) => {
  457. // 设置导出表格的头部
  458. const tHeader = this.listHeader;
  459. // 将要导出的数据进行一个过滤
  460. /**
  461. * 源数据导入到excel的数据每一条重新拼成一个数组,数组里的每个元素就是filterVal里的每个字段
  462. */
  463. const data = this.tableList.map((item, index) => {
  464. if (this.action === 0) {
  465. return [index + 1, item.dat, item.weight];
  466. } else if (this.action === 1) {
  467. return [index + 1, item.dat, item.flightNum];
  468. } else if (this.action === 2) {
  469. if (this.set == 1) {
  470. return [index + 1, item.dat, item.flightNum];
  471. } else if (this.set == 2) {
  472. return [index + 1, item.dat, item.weight];
  473. }
  474. } else if (this.action === 3) {
  475. return [index + 1, item.fdt, item.weight];
  476. }
  477. });
  478. // 调用我们封装好的方法进行导出Excel
  479. excel.export_json_to_excel({
  480. // 导出的头部
  481. header: tHeader,
  482. // 导出的内容
  483. data,
  484. // 导出的文件名称
  485. filename: this.listname,
  486. // 导出的表格宽度是否自动
  487. autoWidth: true,
  488. // 导出文件的后缀类型
  489. bookType: "xlsx",
  490. });
  491. });
  492. },
  493. },
  494. components: {
  495. Echarts,
  496. StatisticsHeader,
  497. },
  498. };
  499. </script>
  500. <style lang="scss" scoped>
  501. .airportInfo {
  502. position: relative;
  503. .header {
  504. width: 103%;
  505. height: 36px;
  506. display: flex;
  507. align-items: center;
  508. justify-content: center;
  509. background: #f7f7f7;
  510. position: relative;
  511. left: -23px;
  512. > .nav {
  513. padding: 0 30px 0 30px;
  514. cursor: pointer;
  515. font-size: 16px;
  516. font-family: Microsoft YaHei;
  517. font-weight: 400;
  518. color: #101116;
  519. }
  520. > .navs {
  521. height: 100%;
  522. padding: 0 30px 0 30px;
  523. cursor: pointer;
  524. display: flex;
  525. align-items: center;
  526. font-size: 16px;
  527. font-family: Microsoft YaHei;
  528. font-weight: bold;
  529. color: #ac014d;
  530. border-bottom: 2px solid #ac014d;
  531. }
  532. }
  533. .variable {
  534. width: 100%;
  535. height: 64px;
  536. }
  537. .echart {
  538. width: 100%;
  539. height: 710px;
  540. position: absolute;
  541. background: #ffffff;
  542. box-shadow: 0px 3px 3px 0px rgba(0, 0, 0, 0.1);
  543. border-radius: 4px;
  544. }
  545. }
  546. </style>