tableformbrs.vue 54 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517
  1. <template>
  2. <div class="data-table">
  3. <div
  4. :style="dataTableContentStyle"
  5. v-loading="loading"
  6. element-loading-text="拼命加载中"
  7. element-loading-spinner="el-icon-loading"
  8. element-loading-background="rgba(0, 0, 0, 0.8)"
  9. class="data-table-content"
  10. >
  11. <template v-if="tableData.length && upid == 1">
  12. <el-table
  13. :data="tableData"
  14. style="width: 100%"
  15. ref="userTableData"
  16. >
  17. <el-table-column
  18. :label="dataContent[1] + '国航行李BRS扫描数据统计表'"
  19. >
  20. <el-table-column
  21. prop="A"
  22. label="日期"
  23. >
  24. </el-table-column>
  25. <el-table-column label="离港数">
  26. <el-table-column
  27. prop="totalfly"
  28. label="航班(架次)"
  29. width="240"
  30. >
  31. </el-table-column>
  32. <el-table-column
  33. prop="totalbag"
  34. label="行李(件数)"
  35. width="240"
  36. >
  37. </el-table-column>
  38. </el-table-column>
  39. <el-table-column label="扫描数">
  40. <el-table-column
  41. prop="brsfly"
  42. label="航班(架次)"
  43. >
  44. </el-table-column>
  45. <el-table-column
  46. prop="brsbag"
  47. label="行李(件数)"
  48. >
  49. </el-table-column>
  50. </el-table-column>
  51. <el-table-column label="扫描率">
  52. <el-table-column
  53. prop="ra_brsfly"
  54. label="航班"
  55. >
  56. </el-table-column>
  57. <el-table-column
  58. prop="ra_brsbag"
  59. label="行李"
  60. >
  61. </el-table-column>
  62. </el-table-column>
  63. </el-table-column>
  64. </el-table>
  65. </template>
  66. <template v-else-if="tableData.length && upid == 2">
  67. <el-table
  68. :data="tableData"
  69. style="width: 100%"
  70. ref="userTableDatard"
  71. >
  72. <el-table-column label="Mannual Load扫描数据统计表">
  73. <el-table-column
  74. prop="A"
  75. label="日期"
  76. >
  77. </el-table-column>
  78. <el-table-column label="离港数">
  79. <el-table-column
  80. prop="totalfly"
  81. label="航班(架次)"
  82. width="240"
  83. >
  84. </el-table-column>
  85. <el-table-column
  86. prop="totalbag"
  87. label="行李(件数)"
  88. width="240"
  89. >
  90. </el-table-column>
  91. </el-table-column>
  92. <el-table-column label="扫描数">
  93. <el-table-column
  94. prop="starfly"
  95. label="航班(架次)"
  96. >
  97. </el-table-column>
  98. <el-table-column
  99. prop="starbag"
  100. label="行李(件数)"
  101. >
  102. </el-table-column>
  103. </el-table-column>
  104. <el-table-column label="扫描率">
  105. <el-table-column
  106. prop="ra_starfly"
  107. label="航班"
  108. >
  109. </el-table-column>
  110. <el-table-column
  111. prop="ra_starbag"
  112. label="行李"
  113. >
  114. </el-table-column>
  115. </el-table-column>
  116. </el-table-column>
  117. </el-table>
  118. </template>
  119. <template v-else-if="tableData.length && upid == 3">
  120. <el-table
  121. :data="tableData"
  122. style="width: 100%"
  123. ref="TableDatardrfid"
  124. >
  125. <el-table-column label="航易行RFID扫描数据统计表">
  126. <el-table-column
  127. prop="A"
  128. label="日期"
  129. >
  130. </el-table-column>
  131. <el-table-column label="离港数">
  132. <el-table-column
  133. prop="totalfly"
  134. label="航班(架次)"
  135. width="240"
  136. >
  137. </el-table-column>
  138. <el-table-column
  139. prop="totalbag"
  140. label="行李(件数)"
  141. width="240"
  142. >
  143. </el-table-column>
  144. </el-table-column>
  145. <el-table-column label="扫描数">
  146. <el-table-column
  147. prop="hyxfly"
  148. label="航班(架次)"
  149. >
  150. </el-table-column>
  151. <el-table-column
  152. prop="hyxbag"
  153. label="行李(件数)"
  154. >
  155. </el-table-column>
  156. </el-table-column>
  157. <el-table-column label="扫描率">
  158. <el-table-column
  159. prop="ra_hyxfly"
  160. label="航班"
  161. >
  162. </el-table-column>
  163. <el-table-column
  164. prop="ra_hyxbag"
  165. label="行李"
  166. >
  167. </el-table-column>
  168. </el-table-column>
  169. </el-table-column>
  170. </el-table>
  171. </template>
  172. <template v-else-if="tableData.length && upid == 4">
  173. <el-table
  174. ref="userTableDatas"
  175. :data="tableData"
  176. style="width: 100%"
  177. :show-summary="true"
  178. :summary-method="totalOutPrice"
  179. :cell-class-name="cellClass"
  180. @cell-click="cellClickHandler"
  181. >
  182. <el-table-column
  183. prop="fd"
  184. label="日期"
  185. >
  186. </el-table-column>
  187. <el-table-column label="中转行李流向">
  188. <el-table-column label="D-D" v-if="DD">
  189. <el-table-column
  190. prop="fly_dd_need_trans"
  191. label="进港中转航班数"
  192. >
  193. </el-table-column>
  194. <el-table-column
  195. prop="fly_dd_trans"
  196. label="中转出航班数"
  197. >
  198. </el-table-column>
  199. <el-table-column
  200. prop="bag_dd_need_trans"
  201. label="须中转行李数"
  202. >
  203. </el-table-column>
  204. <el-table-column
  205. prop="bag_dd_trans"
  206. label="完成中转行李数"
  207. >
  208. </el-table-column>
  209. <!-- <el-table-column
  210. prop="Transferout_dd"
  211. label="转出成功率"
  212. >
  213. </el-table-column> -->
  214. </el-table-column>
  215. <el-table-column label="D-I" v-if="DI">
  216. <el-table-column
  217. prop="fly_di_need_trans"
  218. label="进港中转航班数"
  219. >
  220. </el-table-column>
  221. <el-table-column
  222. prop="fly_di_trans"
  223. label="中转出航班数"
  224. >
  225. </el-table-column>
  226. <el-table-column
  227. prop="bag_di_need_trans"
  228. label="须中转行李数"
  229. >
  230. </el-table-column>
  231. <el-table-column
  232. prop="bag_di_trans"
  233. label="完成中转行李数"
  234. >
  235. </el-table-column>
  236. <!-- <el-table-column
  237. prop="Transferout_di"
  238. label="转出成功率"
  239. >
  240. </el-table-column> -->
  241. </el-table-column>
  242. <el-table-column label="I-I" v-if="II">
  243. <el-table-column
  244. prop="fly_ii_need_trans"
  245. label="进港中转航班数"
  246. >
  247. </el-table-column>
  248. <el-table-column
  249. prop="fly_ii_trans"
  250. label="中转出航班数"
  251. >
  252. </el-table-column>
  253. <el-table-column
  254. prop="bag_ii_need_trans"
  255. label="须中转行李数"
  256. >
  257. </el-table-column>
  258. <el-table-column
  259. prop="bag_ii_trans"
  260. label="完成中转行李数"
  261. >
  262. </el-table-column>
  263. <!-- <el-table-column
  264. prop="Transferout_ii"
  265. label="转出成功率"
  266. >
  267. </el-table-column> -->
  268. </el-table-column>
  269. <el-table-column label="I-D" v-if="ID">
  270. <el-table-column
  271. prop="fly_id_need_trans"
  272. label="进港中转航班数"
  273. >
  274. </el-table-column>
  275. <el-table-column
  276. prop="fly_id_trans"
  277. label="中转出航班数"
  278. >
  279. </el-table-column>
  280. <el-table-column
  281. prop="bag_id_need_trans"
  282. label="须中转行李数"
  283. >
  284. </el-table-column>
  285. <el-table-column
  286. prop="bag_id_trans"
  287. label="完成中转行李数"
  288. >
  289. </el-table-column>
  290. <!-- <el-table-column
  291. prop="Transferout_id"
  292. label="转出成功率"
  293. >
  294. </el-table-column> -->
  295. </el-table-column>
  296. </el-table-column>
  297. </el-table>
  298. </template>
  299. <template v-else-if="tableData.length && upid == 5">
  300. <el-table
  301. ref="transferTableData"
  302. :data="tableData"
  303. style="width: 100%"
  304. :show-summary="true"
  305. :summary-method="totalOutPrice"
  306. :cell-class-name="cellClass"
  307. @cell-click="cellClickHandler"
  308. >
  309. <el-table-column
  310. prop="fd"
  311. label="日期"
  312. >
  313. </el-table-column>
  314. <el-table-column label="D-D" v-if="DD">
  315. <el-table-column label="T2-T2" v-if="t1">
  316. <el-table-column
  317. prop="need_trans_flight_dd_22"
  318. label="进港中转航班数"
  319. >
  320. </el-table-column>
  321. <el-table-column
  322. prop="finish_trans_flight_dd_22"
  323. label="中转出航班数"
  324. >
  325. </el-table-column>
  326. <el-table-column
  327. prop="need_trans_bag_dd_22"
  328. label="须中转行李数"
  329. >
  330. </el-table-column>
  331. <el-table-column
  332. prop="finish_trans_bag_dd_22"
  333. label="完成中转行李数"
  334. >
  335. </el-table-column>
  336. <el-table-column
  337. prop="not_trans_bag_dd_22"
  338. label="未中转行李数"
  339. >
  340. </el-table-column>
  341. <el-table-column
  342. prop="Transferout_dd_22"
  343. label="转出成功率"
  344. >
  345. </el-table-column>
  346. </el-table-column>
  347. <el-table-column label="T2-T3" v-if="t2">
  348. <el-table-column
  349. prop="need_trans_flight_dd_23"
  350. label="进港中转航班数"
  351. >
  352. </el-table-column>
  353. <el-table-column
  354. prop="finish_trans_flight_dd_23"
  355. label="中转出航班数"
  356. >
  357. </el-table-column>
  358. <el-table-column
  359. prop="need_trans_bag_dd_23"
  360. label="须中转行李数"
  361. >
  362. </el-table-column>
  363. <el-table-column
  364. prop="finish_trans_bag_dd_23"
  365. label="完成中转行李数"
  366. >
  367. </el-table-column>
  368. <el-table-column
  369. prop="not_trans_bag_dd_23"
  370. label="未中转行李数"
  371. >
  372. </el-table-column>
  373. <el-table-column
  374. prop="Transferout_dd_23"
  375. label="转出成功率"
  376. >
  377. </el-table-column>
  378. </el-table-column>
  379. <el-table-column label="T3-T3" v-if="t3">
  380. <el-table-column
  381. prop="need_trans_flight_dd_33"
  382. label="进港中转航班数"
  383. >
  384. </el-table-column>
  385. <el-table-column
  386. prop="finish_trans_flight_dd_33"
  387. label="中转出航班数"
  388. >
  389. </el-table-column>
  390. <el-table-column
  391. prop="need_trans_bag_dd_33"
  392. label="须中转行李数"
  393. >
  394. </el-table-column>
  395. <el-table-column
  396. prop="finish_trans_bag_dd_33"
  397. label="完成中转行李数"
  398. >
  399. </el-table-column>
  400. <el-table-column
  401. prop="not_trans_bag_dd_33"
  402. label="未中转行李数"
  403. >
  404. </el-table-column>
  405. <el-table-column
  406. prop="Transferout_dd_33"
  407. label="转出成功率"
  408. >
  409. </el-table-column>
  410. </el-table-column>
  411. <el-table-column label="T3-T2" v-if="t4">
  412. <el-table-column
  413. prop="need_trans_flight_dd_32"
  414. label="进港中转航班数"
  415. >
  416. </el-table-column>
  417. <el-table-column
  418. prop="finish_trans_flight_dd_32"
  419. label="中转出航班数"
  420. >
  421. </el-table-column>
  422. <el-table-column
  423. prop="need_trans_bag_dd_32"
  424. label="须中转行李数"
  425. >
  426. </el-table-column>
  427. <el-table-column
  428. prop="finish_trans_bag_dd_32"
  429. label="完成中转行李数"
  430. >
  431. </el-table-column>
  432. <el-table-column
  433. prop="not_trans_bag_dd_32"
  434. label="未中转行李数"
  435. >
  436. </el-table-column>
  437. <el-table-column
  438. prop="Transferout_dd_32"
  439. label="转出成功率"
  440. >
  441. </el-table-column>
  442. </el-table-column>
  443. </el-table-column>
  444. <el-table-column label="D-I" v-if="DI">
  445. <el-table-column label="T2-T2" v-if="t1">
  446. <el-table-column
  447. prop="need_trans_flight_di_22"
  448. label="进港中转航班数"
  449. >
  450. </el-table-column>
  451. <el-table-column
  452. prop="finish_trans_flight_di_22"
  453. label="中转出航班数"
  454. >
  455. </el-table-column>
  456. <el-table-column
  457. prop="need_trans_bag_di_22"
  458. label="须中转行李数"
  459. >
  460. </el-table-column>
  461. <el-table-column
  462. prop="finish_trans_bag_di_22"
  463. label="完成中转行李数"
  464. >
  465. </el-table-column>
  466. <el-table-column
  467. prop="not_trans_bag_di_22"
  468. label="未中转行李数"
  469. >
  470. </el-table-column>
  471. <el-table-column
  472. prop="Transferout_di_22"
  473. label="转出成功率"
  474. >
  475. </el-table-column>
  476. </el-table-column>
  477. <el-table-column label="T2-T3" v-if="t2">
  478. <el-table-column
  479. prop="need_trans_flight_di_23"
  480. label="进港中转航班数"
  481. >
  482. </el-table-column>
  483. <el-table-column
  484. prop="finish_trans_flight_di_23"
  485. label="中转出航班数"
  486. >
  487. </el-table-column>
  488. <el-table-column
  489. prop="need_trans_bag_di_23"
  490. label="须中转行李数"
  491. >
  492. </el-table-column>
  493. <el-table-column
  494. prop="finish_trans_bag_di_23"
  495. label="完成中转行李数"
  496. >
  497. </el-table-column>
  498. <el-table-column
  499. prop="not_trans_bag_di_23"
  500. label="未中转行李数"
  501. >
  502. </el-table-column>
  503. <el-table-column
  504. prop="Transferout_di_23"
  505. label="转出成功率"
  506. >
  507. </el-table-column>
  508. </el-table-column>
  509. <el-table-column label="T3-T3" v-if="t3">
  510. <el-table-column
  511. prop="need_trans_flight_di_33"
  512. label="进港中转航班数"
  513. >
  514. </el-table-column>
  515. <el-table-column
  516. prop="finish_trans_flight_di_33"
  517. label="中转出航班数"
  518. >
  519. </el-table-column>
  520. <el-table-column
  521. prop="need_trans_bag_di_33"
  522. label="须中转行李数"
  523. >
  524. </el-table-column>
  525. <el-table-column
  526. prop="finish_trans_bag_di_33"
  527. label="完成中转行李数"
  528. >
  529. </el-table-column>
  530. <el-table-column
  531. prop="not_trans_bag_di_33"
  532. label="未中转行李数"
  533. >
  534. </el-table-column>
  535. <el-table-column
  536. prop="Transferout_di_33"
  537. label="转出成功率"
  538. >
  539. </el-table-column>
  540. </el-table-column>
  541. <el-table-column label="T3-T2" v-if="t4">
  542. <el-table-column
  543. prop="need_trans_flight_di_32"
  544. label="进港中转航班数"
  545. >
  546. </el-table-column>
  547. <el-table-column
  548. prop="finish_trans_flight_di_32"
  549. label="中转出航班数"
  550. >
  551. </el-table-column>
  552. <el-table-column
  553. prop="need_trans_bag_di_32"
  554. label="须中转行李数"
  555. >
  556. </el-table-column>
  557. <el-table-column
  558. prop="finish_trans_bag_di_32"
  559. label="完成中转行李数"
  560. >
  561. </el-table-column>
  562. <el-table-column
  563. prop="not_trans_bag_di_32"
  564. label="未中转行李数"
  565. >
  566. </el-table-column>
  567. <el-table-column
  568. prop="Transferout_di_32"
  569. label="转出成功率"
  570. >
  571. </el-table-column>
  572. </el-table-column>
  573. </el-table-column>
  574. <el-table-column label="I-I" v-if="II">
  575. <el-table-column label="T2-T2" v-if="t1">
  576. <el-table-column
  577. prop="need_trans_flight_ii_22"
  578. label="进港中转航班数"
  579. >
  580. </el-table-column>
  581. <el-table-column
  582. prop="finish_trans_flight_ii_22"
  583. label="中转出航班数"
  584. >
  585. </el-table-column>
  586. <el-table-column
  587. prop="need_trans_bag_ii_22"
  588. label="须中转行李数"
  589. >
  590. </el-table-column>
  591. <el-table-column
  592. prop="finish_trans_bag_ii_22"
  593. label="完成中转行李数"
  594. >
  595. </el-table-column>
  596. <el-table-column
  597. prop="not_trans_bag_ii_22"
  598. label="未中转行李数"
  599. >
  600. </el-table-column>
  601. <el-table-column
  602. prop="Transferout_ii_22"
  603. label="转出成功率"
  604. >
  605. </el-table-column>
  606. </el-table-column>
  607. <el-table-column label="T2-T3" v-if="t2">
  608. <el-table-column
  609. prop="need_trans_flight_ii_23"
  610. label="进港中转航班数"
  611. >
  612. </el-table-column>
  613. <el-table-column
  614. prop="finish_trans_flight_ii_23"
  615. label="中转出航班数"
  616. >
  617. </el-table-column>
  618. <el-table-column
  619. prop="need_trans_bag_ii_23"
  620. label="须中转行李数"
  621. >
  622. </el-table-column>
  623. <el-table-column
  624. prop="finish_trans_bag_ii_23"
  625. label="完成中转行李数"
  626. >
  627. </el-table-column>
  628. <el-table-column
  629. prop="not_trans_bag_ii_23"
  630. label="未中转行李数"
  631. >
  632. </el-table-column>
  633. <el-table-column
  634. prop="Transferout_ii_23"
  635. label="转出成功率"
  636. >
  637. </el-table-column>
  638. </el-table-column>
  639. <el-table-column label="T3-T3" v-if="t3">
  640. <el-table-column
  641. prop="need_trans_flight_ii_33"
  642. label="进港中转航班数"
  643. >
  644. </el-table-column>
  645. <el-table-column
  646. prop="finish_trans_flight_ii_33"
  647. label="中转出航班数"
  648. >
  649. </el-table-column>
  650. <el-table-column
  651. prop="need_trans_bag_ii_33"
  652. label="须中转行李数"
  653. >
  654. </el-table-column>
  655. <el-table-column
  656. prop="finish_trans_bag_ii_33"
  657. label="完成中转行李数"
  658. >
  659. </el-table-column>
  660. <el-table-column
  661. prop="not_trans_bag_ii_33"
  662. label="未中转行李数"
  663. >
  664. </el-table-column>
  665. <el-table-column
  666. prop="Transferout_ii_33"
  667. label="转出成功率"
  668. >
  669. </el-table-column>
  670. </el-table-column>
  671. <el-table-column label="T3-T2" v-if="t4">
  672. <el-table-column
  673. prop="need_trans_flight_ii_32"
  674. label="进港中转航班数"
  675. >
  676. </el-table-column>
  677. <el-table-column
  678. prop="finish_trans_flight_ii_32"
  679. label="中转出航班数"
  680. >
  681. </el-table-column>
  682. <el-table-column
  683. prop="need_trans_bag_ii_32"
  684. label="须中转行李数"
  685. >
  686. </el-table-column>
  687. <el-table-column
  688. prop="finish_trans_bag_ii_32"
  689. label="完成中转行李数"
  690. >
  691. </el-table-column>
  692. <el-table-column
  693. prop="not_trans_bag_ii_32"
  694. label="未中转行李数"
  695. >
  696. </el-table-column>
  697. <el-table-column
  698. prop="Transferout_ii_32"
  699. label="转出成功率"
  700. >
  701. </el-table-column>
  702. </el-table-column>
  703. </el-table-column>
  704. <el-table-column label="I-D" v-if="ID">
  705. <el-table-column label="T2-T2" v-if="t1">
  706. <el-table-column
  707. prop="need_trans_flight_id_22"
  708. label="进港中转航班数"
  709. >
  710. </el-table-column>
  711. <el-table-column
  712. prop="finish_trans_flight_id_22"
  713. label="中转出航班数"
  714. >
  715. </el-table-column>
  716. <el-table-column
  717. prop="need_trans_bag_id_22"
  718. label="须中转行李数"
  719. >
  720. </el-table-column>
  721. <el-table-column
  722. prop="finish_trans_bag_id_22"
  723. label="完成中转行李数"
  724. >
  725. </el-table-column>
  726. <el-table-column
  727. prop="not_trans_bag_id_22"
  728. label="未中转行李数"
  729. >
  730. </el-table-column>
  731. <el-table-column
  732. prop="Transferout_id_22"
  733. label="转出成功率"
  734. >
  735. </el-table-column>
  736. </el-table-column>
  737. <el-table-column label="T2-T3" v-if="t2">
  738. <el-table-column
  739. prop="need_trans_flight_id_23"
  740. label="进港中转航班数"
  741. >
  742. </el-table-column>
  743. <el-table-column
  744. prop="finish_trans_flight_id_23"
  745. label="中转出航班数"
  746. >
  747. </el-table-column>
  748. <el-table-column
  749. prop="need_trans_bag_id_23"
  750. label="须中转行李数"
  751. >
  752. </el-table-column>
  753. <el-table-column
  754. prop="finish_trans_bag_id_23"
  755. label="完成中转行李数"
  756. >
  757. </el-table-column>
  758. <el-table-column
  759. prop="not_trans_bag_id_23"
  760. label="未中转行李数"
  761. >
  762. </el-table-column>
  763. <el-table-column
  764. prop="Transferout_id_23"
  765. label="转出成功率"
  766. >
  767. </el-table-column>
  768. </el-table-column>
  769. <el-table-column label="T3-T3" v-if="t3">
  770. <el-table-column
  771. prop="need_trans_flight_id_33"
  772. label="进港中转航班数"
  773. >
  774. </el-table-column>
  775. <el-table-column
  776. prop="finish_trans_flight_id_33"
  777. label="中转出航班数"
  778. >
  779. </el-table-column>
  780. <el-table-column
  781. prop="need_trans_bag_id_33"
  782. label="须中转行李数"
  783. >
  784. </el-table-column>
  785. <el-table-column
  786. prop="finish_trans_bag_id_33"
  787. label="完成中转行李数"
  788. >
  789. </el-table-column>
  790. <el-table-column
  791. prop="not_trans_bag_id_33"
  792. label="未中转行李数"
  793. >
  794. </el-table-column>
  795. <el-table-column
  796. prop="Transferout_id_33"
  797. label="转出成功率"
  798. >
  799. </el-table-column>
  800. </el-table-column>
  801. <el-table-column label="T3-T2" v-if="t4">
  802. <el-table-column
  803. prop="need_trans_flight_id_32"
  804. label="进港中转航班数"
  805. >
  806. </el-table-column>
  807. <el-table-column
  808. prop="finish_trans_flight_id_32"
  809. label="中转出航班数"
  810. >
  811. </el-table-column>
  812. <el-table-column
  813. prop="need_trans_bag_id_32"
  814. label="须中转行李数"
  815. >
  816. </el-table-column>
  817. <el-table-column
  818. prop="finish_trans_bag_id_32"
  819. label="完成中转行李数"
  820. >
  821. </el-table-column>
  822. <el-table-column
  823. prop="not_trans_bag_id_32"
  824. label="未中转行李数"
  825. >
  826. </el-table-column>
  827. <el-table-column
  828. prop="Transferout_id_32"
  829. label="转出成功率"
  830. >
  831. </el-table-column>
  832. </el-table-column>
  833. </el-table-column>
  834. <el-table-column
  835. prop="a14"
  836. label="中转出航班数总数"
  837. >
  838. </el-table-column>
  839. <el-table-column
  840. prop="a15"
  841. label="中转出航班数总数"
  842. >
  843. </el-table-column>
  844. <el-table-column
  845. prop="a16"
  846. label="须中转行李数总数"
  847. >
  848. </el-table-column>
  849. <el-table-column
  850. prop="a17"
  851. label="完成中转行李数总数"
  852. >
  853. </el-table-column>
  854. <el-table-column
  855. prop="a19"
  856. label="未中转行李数总数"
  857. >
  858. </el-table-column>
  859. <el-table-column
  860. prop="a18"
  861. label="转出成功率"
  862. >
  863. </el-table-column>
  864. </el-table>
  865. </template>
  866. <template v-else-if="tableData.length && upid == 6">
  867. <el-table
  868. ref="transferBaggageTableData"
  869. :data="tableData"
  870. style="width: 100%"
  871. :show-summary="true"
  872. >
  873. <el-table-column
  874. prop="a1"
  875. label="日期"
  876. >
  877. </el-table-column>
  878. <el-table-column
  879. prop="a2"
  880. label="进港中转航班量"
  881. >
  882. </el-table-column>
  883. <el-table-column
  884. prop="a3"
  885. label="中转行李件数"
  886. >
  887. </el-table-column>
  888. <el-table-column
  889. prop="a4"
  890. label="未转出件数"
  891. >
  892. </el-table-column>
  893. <el-table-column label="未转出件数分项">
  894. <el-table-column
  895. prop="a5"
  896. label="MCT时间紧"
  897. >
  898. </el-table-column>
  899. <el-table-column
  900. prop="a6"
  901. label="过检设备原因"
  902. >
  903. </el-table-column>
  904. <el-table-column
  905. prop="a7"
  906. label="混装"
  907. >
  908. </el-table-column>
  909. <el-table-column
  910. prop="a8"
  911. label="布控"
  912. >
  913. </el-table-column>
  914. <el-table-column
  915. prop="a9"
  916. label="等锥桶"
  917. >
  918. </el-table-column>
  919. <el-table-column
  920. prop="a10"
  921. label="车辆故障"
  922. >
  923. </el-table-column>
  924. <el-table-column
  925. prop="a11"
  926. label="货舱门/卡锁故障"
  927. >
  928. </el-table-column>
  929. <el-table-column
  930. prop="a12"
  931. label="机位远"
  932. >
  933. </el-table-column>
  934. <el-table-column
  935. prop="a13"
  936. label="未通过扫描"
  937. >
  938. </el-table-column>
  939. <el-table-column
  940. prop="a14"
  941. label="BHS无记录"
  942. >
  943. </el-table-column>
  944. <el-table-column
  945. prop="a15"
  946. label="分拣设备故障"
  947. >
  948. </el-table-column>
  949. <el-table-column
  950. prop="a16"
  951. label="进港晚卸"
  952. >
  953. </el-table-column>
  954. <el-table-column
  955. prop="a17"
  956. label="设备紧张"
  957. >
  958. </el-table-column>
  959. <el-table-column
  960. prop="a18"
  961. label="导入晚"
  962. >
  963. </el-table-column>
  964. <el-table-column
  965. prop="a19"
  966. label="正常传出未装机"
  967. >
  968. </el-table-column>
  969. <el-table-column
  970. prop="a20"
  971. label="错传"
  972. >
  973. </el-table-column>
  974. <el-table-column
  975. prop="a21"
  976. label="原因待定"
  977. >
  978. </el-table-column>
  979. </el-table-column>
  980. </el-table>
  981. </template>
  982. <template v-else-if="tableData.length && upid == 7">
  983. <el-table
  984. ref="baggageProportionTableData"
  985. :data="tableData"
  986. style="width: 100%"
  987. :show-summary="true"
  988. >
  989. <el-table-column
  990. prop="a1"
  991. label="日期"
  992. >
  993. </el-table-column>
  994. <el-table-column label="总">
  995. <el-table-column
  996. prop="a2"
  997. label="中转行李百分比"
  998. >
  999. </el-table-column>
  1000. <el-table-column
  1001. prop="a3"
  1002. label="行李总件数"
  1003. >
  1004. </el-table-column>
  1005. <el-table-column
  1006. prop="a4"
  1007. label="中转行李件数"
  1008. >
  1009. </el-table-column>
  1010. </el-table-column>
  1011. <el-table-column label="国内">
  1012. <el-table-column
  1013. prop="a5"
  1014. label="中转行李百分比"
  1015. >
  1016. </el-table-column>
  1017. <el-table-column
  1018. prop="a6"
  1019. label="行李总件数"
  1020. >
  1021. </el-table-column>
  1022. <el-table-column
  1023. prop="a7"
  1024. label="中转行李件数"
  1025. >
  1026. </el-table-column>
  1027. </el-table-column>
  1028. <el-table-column label="国际">
  1029. <el-table-column
  1030. prop="a8"
  1031. label="中转行李百分比"
  1032. >
  1033. </el-table-column>
  1034. <el-table-column
  1035. prop="a9"
  1036. label="行李总件数"
  1037. >
  1038. </el-table-column>
  1039. <el-table-column
  1040. prop="a10"
  1041. label="中转行李件数"
  1042. >
  1043. </el-table-column>
  1044. </el-table-column>
  1045. </el-table>
  1046. </template>
  1047. <template v-else-if="tableData.length && upid == 8">
  1048. <el-table
  1049. :data="tableData"
  1050. style="width: 100%"
  1051. :show-summary="true"
  1052. ref="userTableDataelt"
  1053. >
  1054. <el-table-column
  1055. prop="time"
  1056. label="日期"
  1057. >
  1058. </el-table-column>
  1059. <el-table-column
  1060. prop="bpm"
  1061. label="有BPM行李数量"
  1062. >
  1063. </el-table-column>
  1064. <el-table-column
  1065. prop="bsm"
  1066. label="总数量"
  1067. >
  1068. </el-table-column>
  1069. <el-table-column
  1070. prop="lv"
  1071. label="行李全流程跟踪服务水平(%)"
  1072. >
  1073. </el-table-column>
  1074. </el-table>
  1075. </template>
  1076. <template v-else>
  1077. <NoData
  1078. image-width="auto"
  1079. image-height="100%"
  1080. />
  1081. </template>
  1082. </div>
  1083. </div>
  1084. </template>
  1085. <script>
  1086. import NoData from '@/components/nodata'
  1087. import { TempQuery } from '@/api/temp'
  1088. import { exportToExcel } from '@/utils/table'
  1089. import { Query } from '@/api/webApi'
  1090. export default {
  1091. props: {
  1092. // 接口ID
  1093. dataId: {
  1094. type: [String, Number],
  1095. default: '',
  1096. },
  1097. isloadings: {
  1098. type: Number,
  1099. },
  1100. upid: {
  1101. type: [String, Number],
  1102. },
  1103. dataContent: {
  1104. type: Array,
  1105. default: () => [],
  1106. },
  1107. textShow: {
  1108. type: Array,
  1109. default: () => [],
  1110. },
  1111. textShowtp: {
  1112. type: Array,
  1113. default: () => [],
  1114. },
  1115. },
  1116. data() {
  1117. return {
  1118. loading: false,
  1119. page: 0,
  1120. serviceId: null,
  1121. rowTitle: '',
  1122. tableCols: [], //表头数据
  1123. tableData: [
  1124. // {
  1125. // date: "wnz(7月)",
  1126. // name: "409",
  1127. // province: "18946",
  1128. // city: "409",
  1129. // address: "18294",
  1130. // zip: "100%",
  1131. // cp: "96.56%",
  1132. // },
  1133. ],
  1134. DD: true,
  1135. DI: true,
  1136. II: true,
  1137. ID: true,
  1138. t1: true,
  1139. t2: true,
  1140. t3: true,
  1141. t4: true,
  1142. }
  1143. },
  1144. components: {
  1145. NoData,
  1146. },
  1147. watch: {
  1148. dataContent: {
  1149. handler(val) {
  1150. if (val) {
  1151. this.getQuery()
  1152. }
  1153. },
  1154. deep: true,
  1155. },
  1156. isloadings: {
  1157. handler(val) {
  1158. this.downFile()
  1159. },
  1160. },
  1161. textShow: {
  1162. handler(val) {
  1163. if (val.length === 0) {
  1164. this.DD = true
  1165. this.DI = true
  1166. this.II = true
  1167. this.ID = true
  1168. } else {
  1169. this.DD = false
  1170. this.DI = false
  1171. this.II = false
  1172. this.ID = false
  1173. val.forEach(element => {
  1174. if (element === 'D-D') {
  1175. this.DD = true
  1176. } else if (element === 'D-I') {
  1177. this.DI = true
  1178. } else if (element === 'I-I') {
  1179. this.II = true
  1180. } else if (element === 'I-D') {
  1181. this.ID = true
  1182. }
  1183. });
  1184. }
  1185. },
  1186. },
  1187. textShowtp: {
  1188. handler(val) {
  1189. if (val.length === 0) {
  1190. this.t1 = true
  1191. this.t2 = true
  1192. this.t3 = true
  1193. this.t4 = true
  1194. } else {
  1195. this.t1 = false
  1196. this.t2 = false
  1197. this.t3 = false
  1198. this.t4 = false
  1199. val.forEach(element => {
  1200. if (element === 'T2-T2') {
  1201. this.t1 = true
  1202. } else if (element === 'T2-T3') {
  1203. this.t2 = true
  1204. } else if (element === 'T3-T3') {
  1205. this.t3 = true
  1206. } else if (element === 'T3-T2') {
  1207. this.t4 = true
  1208. }
  1209. });
  1210. }
  1211. },
  1212. },
  1213. },
  1214. computed: {
  1215. dataTableContentStyle() {
  1216. const style = {}
  1217. if (this.minHeight) {
  1218. style['min-height'] = this.minHeight
  1219. }
  1220. if (this.tableHeight) {
  1221. style['height'] = this.tableHeight
  1222. }
  1223. return style
  1224. },
  1225. },
  1226. mounted() {
  1227. // this.getQuery();
  1228. },
  1229. methods: {
  1230. totalOutPrice(param) {
  1231. const { columns, data } = param;
  1232. const sums = [];
  1233. columns.forEach((column, index) => {
  1234. if (index === 0) {
  1235. sums[index] = "合计";
  1236. return;
  1237. }
  1238. const values = data.map((item) => Number(item[column.property]));
  1239. if (
  1240. column.property != "stand" &&
  1241. column.property != "flightdate" &&
  1242. column.property != "indexs" &&
  1243. column.property != "flightNo" &&
  1244. column.property != "line" &&
  1245. column.property != "cargoCompany"
  1246. ) {
  1247. sums[index] = values.reduce((prev, curr) => {
  1248. const value = Number(curr);
  1249. if (!isNaN(value)) {
  1250. return prev + curr;
  1251. } else {
  1252. return "";
  1253. }
  1254. }, 0);
  1255. sums[index];
  1256. }
  1257. if (this.upid == 4) {
  1258. // sums[6] = (sums[4] * 100 / (sums[3] > 0 ? sums[3] : 1)).toFixed(2) + '%'
  1259. // sums[12] = (sums[10] * 100 / (sums[9] > 0 ? sums[9] : 1)).toFixed(2) + '%'
  1260. // sums[18] = (sums[16] * 100 / (sums[15] > 0 ? sums[15] : 1)).toFixed(2) + '%'
  1261. // sums[24] = (sums[22] * 100 / (sums[21] > 0 ? sums[21] : 1)).toFixed(2) + '%'
  1262. // sums[30] = (sums[28] * 100 / (sums[27] > 0 ? sums[27] : 1)).toFixed(2) + '%'
  1263. }
  1264. if (this.upid == 5) {
  1265. // sums[6] = (sums[4] * 100 / sums[3]).toFixed(2) + '%'
  1266. // sums[12] = (sums[10] * 100 / sums[9]).toFixed(2) + '%'
  1267. // sums[18] = (sums[16] * 100 / sums[15]).toFixed(2) + '%'
  1268. // sums[24] = (sums[22] * 100 / sums[21]).toFixed(2) + '%'
  1269. // sums[30] = (sums[28] * 100 / sums[27]).toFixed(2) + '%'
  1270. // sums[36] = (sums[34] * 100 / sums[33]).toFixed(2) + '%'
  1271. // sums[42] = (sums[40] * 100 / sums[39]).toFixed(2) + '%'
  1272. for(var i = 6; i < sums.length; i+=6) {
  1273. sums[i] = (sums[i-2] * 100 / (sums[i-3] > 0 ? sums[i-3] : 1)).toFixed(2) + '%'
  1274. }
  1275. // sums[6] = (sums[4] * 100 / (sums[3] > 0 ? sums[3] : 1)).toFixed(2) + '%'
  1276. // sums[12] = (sums[10] * 100 / (sums[9] > 0 ? sums[9] : 1)).toFixed(2) + '%'
  1277. // sums[18] = (sums[16] * 100 / (sums[15] > 0 ? sums[15] : 1)).toFixed(2) + '%'
  1278. // sums[24] = (sums[22] * 100 / (sums[21] > 0 ? sums[21] : 1)).toFixed(2) + '%'
  1279. // sums[30] = (sums[28] * 100 / (sums[27] > 0 ? sums[27] : 1)).toFixed(2) + '%'
  1280. // sums[36] = (sums[34] * 100 / (sums[33] > 0 ? sums[33] : 1)).toFixed(2) + '%'
  1281. // sums[42] = (sums[40] * 100 / (sums[39] > 0 ? sums[39] : 1)).toFixed(2) + '%'
  1282. }
  1283. });
  1284. return sums;
  1285. },
  1286. //获取表格数据
  1287. async getQuery() {
  1288. try {
  1289. this.loading = true
  1290. const { code, returnData } = await Query({
  1291. serviceId: Number(this.dataId),
  1292. dataContent: this.dataContent,
  1293. })
  1294. if (code == 0) {
  1295. this.tableData = returnData
  1296. if (returnData.length === 0) {
  1297. this.page--
  1298. this.noMore = true
  1299. this.loading = false
  1300. }
  1301. const titleColumn = returnData.columnSet.find(
  1302. item => item.needShow === 1
  1303. )
  1304. if (titleColumn) {
  1305. this.rowTitle = titleColumn.columnName
  1306. }
  1307. // returnData.listValues.forEach((res) => {
  1308. // if (!res.A) {
  1309. // res.A = 0;
  1310. // }
  1311. // if (!res.totalfly) {
  1312. // res.totalfly = 0;
  1313. // }
  1314. // if (!res.totalbag) {
  1315. // res.totalbag = 0;
  1316. // }
  1317. // if (!res.brsfly) {
  1318. // res.brsfly = 0;
  1319. // }
  1320. // if (!res.brsbag) {
  1321. // res.brsbag = 0;
  1322. // }
  1323. // if (!res.ra_brsfly) {
  1324. // res.ra_brsfly = 0;
  1325. // }
  1326. // if (!res.ra_brsbag) {
  1327. // res.ra_brsbag = 0;
  1328. // }
  1329. // if (!res.starfly) {
  1330. // res.starfly = 0;
  1331. // }
  1332. // if (!res.starbag) {
  1333. // res.starbag = 0;
  1334. // }
  1335. // if (!res.ra_starfly) {
  1336. // res.ra_starfly = 0;
  1337. // }
  1338. // if (!res.ra_starfly) {
  1339. // res.ra_starfly = 0;
  1340. // }
  1341. // if (!res.hyxfly) {
  1342. // res.hyxfly = 0;
  1343. // }
  1344. // if (!res.hyxbag) {
  1345. // res.hyxbag = 0;
  1346. // }
  1347. // if (!res.ra_hyxfly) {
  1348. // res.ra_hyxfly = 0;
  1349. // }
  1350. // if (!res.ra_hyxbag) {
  1351. // res.ra_hyxbag = 0;
  1352. // }
  1353. // });
  1354. this.tableData = returnData
  1355. this.tableCols = returnData.columnSet
  1356. this.serviceId = returnData.submitID
  1357. this.loading = false
  1358. if(this.upid == 4){
  1359. // this.tableData.forEach(element => {
  1360. // element.Transferout_dd = (element.finish_trans_bag_dd * 100 / (element.need_trans_bag_dd > 0 ? element.need_trans_bag_dd : 1)).toFixed(2) + '%'
  1361. // element.Transferout_di = (element.finish_trans_bag_di * 100 / (element.need_trans_bag_di > 0 ? element.need_trans_bag_di : 1)).toFixed(2) + '%'
  1362. // element.Transferout_ii = (element.finish_trans_bag_ii * 100 / (element.need_trans_bag_ii > 0 ? element.need_trans_bag_ii : 1)).toFixed(2) + '%'
  1363. // element.Transferout_id = (element.finish_trans_bag_id * 100 / (element.need_trans_bag_id > 0 ? element.need_trans_bag_id : 1)).toFixed(2) + '%'
  1364. // element.a14 = (this.DD ? element.need_trans_flight_dd : 0) + (this.DI ? element.need_trans_flight_di : 0) + (this.II ? element.need_trans_flight_ii : 0) + (this.ID ? element.need_trans_flight_id : 0)
  1365. // element.a15 = (this.DD ? element.finish_trans_flight_dd : 0) + (this.DI ? element.finish_trans_flight_di : 0) + (this.II ? element.finish_trans_flight_ii : 0) + (this.ID ? element.finish_trans_flight_id : 0)
  1366. // element.a16 = (this.DD ? element.need_trans_bag_dd : 0) + (this.DI ? element.need_trans_bag_di : 0) + (this.II ? element.need_trans_bag_ii : 0) + (this.ID ? element.need_trans_bag_id : 0)
  1367. // element.a17 = (this.DD ? element.finish_trans_bag_dd : 0) + (this.DI ? element.finish_trans_bag_di : 0) + (this.II ? element.finish_trans_bag_ii : 0) + (this.ID ? element.finish_trans_bag_id : 0)
  1368. // element.a19 = (this.DD ? element.not_trans_bag_dd : 0) + (this.DI ? element.not_trans_bag_di : 0) + (this.II ? element.not_trans_bag_ii : 0) + (this.ID ? element.not_trans_bag_id : 0)
  1369. // element.a18 = (element.a17 * 100 /( element.a16 > 0 ? element.a16 : 0)).toFixed(2) + '%'
  1370. // });
  1371. } else if (this.upid == 5) {
  1372. this.tableData.forEach(element => {
  1373. element.Transferout_dd_22 = (element.finish_trans_bag_dd_22 * 100 / (element.need_trans_bag_dd_22 > 0 ? element.need_trans_bag_dd_22 : 1)).toFixed(2) + '%'
  1374. element.Transferout_dd_23 = (element.finish_trans_bag_dd_23 * 100 / (element.need_trans_bag_dd_23 > 0 ? element.need_trans_bag_dd_23 : 1)).toFixed(2) + '%'
  1375. element.Transferout_dd_33 = (element.finish_trans_bag_dd_33 * 100 / (element.need_trans_bag_dd_33 > 0 ? element.need_trans_bag_dd_33 : 1)).toFixed(2) + '%'
  1376. element.Transferout_dd_32 = (element.finish_trans_bag_dd_32 * 100 / (element.need_trans_bag_dd_32 > 0 ? element.need_trans_bag_dd_32 : 1)).toFixed(2) + '%'
  1377. element.Transferout_di_22 = (element.finish_trans_bag_di_22 * 100 / (element.need_trans_bag_di_22 > 0 ? element.need_trans_bag_di_22 : 1)).toFixed(2) + '%'
  1378. element.Transferout_di_23 = (element.finish_trans_bag_di_23 * 100 / (element.need_trans_bag_di_23 > 0 ? element.need_trans_bag_di_23 : 1)).toFixed(2) + '%'
  1379. element.Transferout_di_33 = (element.finish_trans_bag_di_33 * 100 / (element.need_trans_bag_di_33 > 0 ? element.need_trans_bag_di_33 : 1)).toFixed(2) + '%'
  1380. element.Transferout_di_32 = (element.finish_trans_bag_di_32 * 100 / (element.need_trans_bag_di_32 > 0 ? element.need_trans_bag_di_32 : 1)).toFixed(2) + '%'
  1381. element.Transferout_ii_22 = (element.finish_trans_bag_ii_22 * 100 / (element.need_trans_bag_ii_22 > 0 ? element.need_trans_bag_ii_22 : 1)).toFixed(2) + '%'
  1382. element.Transferout_ii_23 = (element.finish_trans_bag_ii_23 * 100 / (element.need_trans_bag_ii_23 > 0 ? element.need_trans_bag_ii_23 : 1)).toFixed(2) + '%'
  1383. element.Transferout_ii_33 = (element.finish_trans_bag_ii_33 * 100 / (element.need_trans_bag_ii_33 > 0 ? element.need_trans_bag_ii_33 : 1)).toFixed(2) + '%'
  1384. element.Transferout_ii_32 = (element.finish_trans_bag_ii_32 * 100 / (element.need_trans_bag_ii_32 > 0 ? element.need_trans_bag_ii_32 : 1)).toFixed(2) + '%'
  1385. element.Transferout_id_22 = (element.finish_trans_bag_id_22 * 100 / (element.need_trans_bag_id_22 > 0 ? element.need_trans_bag_id_22 : 1)).toFixed(2) + '%'
  1386. element.Transferout_id_23 = (element.finish_trans_bag_id_23 * 100 / (element.need_trans_bag_id_23 > 0 ? element.need_trans_bag_id_23 : 1)).toFixed(2) + '%'
  1387. element.Transferout_id_33 = (element.finish_trans_bag_id_33 * 100 / (element.need_trans_bag_id_33 > 0 ? element.need_trans_bag_id_33 : 1)).toFixed(2) + '%'
  1388. element.Transferout_id_32 = (element.finish_trans_bag_id_32 * 100 / (element.need_trans_bag_id_32 > 0 ? element.need_trans_bag_id_32 : 1)).toFixed(2) + '%'
  1389. let t1DD = (this.t1 ? element.need_trans_flight_dd_22 : 0) + (this.t2 ? element.need_trans_flight_dd_23 : 0) + (this.t3 ? element.need_trans_flight_dd_33 : 0) + (this.t4 ? element.need_trans_flight_dd_32 : 0)
  1390. let t1DI = (this.t1 ? element.need_trans_flight_di_22 : 0) + (this.t2 ? element.need_trans_flight_di_23 : 0) + (this.t3 ? element.need_trans_flight_di_23 : 0) + (this.t4 ? element.need_trans_flight_di_32 : 0)
  1391. let t1II = (this.t1 ? element.need_trans_flight_ii_22 : 0) + (this.t2 ? element.need_trans_flight_ii_23 : 0) + (this.t3 ? element.need_trans_flight_ii_33 : 0) + (this.t4 ? element.need_trans_flight_ii_32 : 0)
  1392. let t1ID = (this.t1 ? element.need_trans_flight_id_22 : 0) + (this.t2 ? element.need_trans_flight_id_23 : 0) + (this.t3 ? element.need_trans_flight_id_33 : 0) + (this.t4 ? element.need_trans_flight_id_32 : 0)
  1393. element.a14 = (this.DD ? t1DD : 0) + (this.DI ? t1DI : 0) + (this.II ? t1II : 0) + (this.II ? t1ID : 0)
  1394. let t2DD = (this.t1 ? element.finish_trans_flight_dd_22 : 0) + (this.t2 ? element.finish_trans_flight_dd_23 : 0) + (this.t3 ? element.finish_trans_flight_dd_33 : 0) + (this.t4 ? element.finish_trans_flight_dd_32 : 0)
  1395. let t2DI = (this.t1 ? element.finish_trans_flight_di_22 : 0) + (this.t2 ? element.finish_trans_flight_di_23 : 0) + (this.t3 ? element.finish_trans_flight_di_33 : 0) + (this.t4 ? element.finish_trans_flight_di_32 : 0)
  1396. let t2II = (this.t1 ? element.finish_trans_flight_ii_22 : 0) + (this.t2 ? element.finish_trans_flight_ii_23 : 0) + (this.t3 ? element.finish_trans_flight_ii_33 : 0) + (this.t4 ? element.finish_trans_flight_ii_32 : 0)
  1397. let t2ID = (this.t1 ? element.finish_trans_flight_id_22 : 0) + (this.t2 ? element.finish_trans_flight_id_23 : 0) + (this.t3 ? element.finish_trans_flight_id_33 : 0) + (this.t4 ? element.finish_trans_flight_id_32 : 0)
  1398. element.a15 = (this.DD ? t2DD : 0) + (this.DI ? t2DI : 0) + (this.II ? t2II : 0) + (this.II ? t2ID : 0)
  1399. let t3DD = (this.t1 ? element.need_trans_bag_dd_22 : 0) + (this.t2 ? element.need_trans_bag_dd_23 : 0) + (this.t3 ? element.need_trans_bag_dd_33 : 0) + (this.t4 ? element.need_trans_bag_dd_32 : 0)
  1400. let t3DI = (this.t1 ? element.need_trans_bag_di_22 : 0) + (this.t2 ? element.need_trans_bag_di_23 : 0) + (this.t3 ? element.need_trans_bag_di_33 : 0) + (this.t4 ? element.need_trans_bag_di_32 : 0)
  1401. let t3II = (this.t1 ? element.need_trans_bag_ii_22 : 0) + (this.t2 ? element.need_trans_bag_ii_23 : 0) + (this.t3 ? element.need_trans_bag_ii_33 : 0) + (this.t4 ? element.need_trans_bag_ii_32 : 0)
  1402. let t3ID = (this.t1 ? element.need_trans_bag_id_22 : 0) + (this.t2 ? element.need_trans_bag_id_23 : 0) + (this.t3 ? element.need_trans_bag_id_33 : 0) + (this.t4 ? element.need_trans_bag_id_32 : 0)
  1403. element.a16 = (this.DD ? t3DD : 0) + (this.DI ? t3DI : 0) + (this.II ? t3II : 0) + (this.II ? t3ID : 0)
  1404. let t4DD = (this.t1 ? element.finish_trans_bag_dd_22 : 0) + (this.t2 ? element.finish_trans_bag_dd_23 : 0) + (this.t3 ? element.finish_trans_bag_dd_33 : 0) + (this.t4 ? element.finish_trans_bag_dd_32 : 0)
  1405. let t4DI = (this.t1 ? element.finish_trans_bag_di_22 : 0) + (this.t2 ? element.finish_trans_bag_di_23 : 0) + (this.t3 ? element.finish_trans_bag_di_33 : 0) + (this.t4 ? element.finish_trans_bag_di_32 : 0)
  1406. let t4II = (this.t1 ? element.finish_trans_bag_ii_22 : 0) + (this.t2 ? element.finish_trans_bag_ii_23 : 0) + (this.t3 ? element.finish_trans_bag_ii_33 : 0) + (this.t4 ? element.finish_trans_bag_ii_32 : 0)
  1407. let t4ID = (this.t1 ? element.finish_trans_bag_id_22 : 0) + (this.t2 ? element.finish_trans_bag_id_23 : 0) + (this.t3 ? element.finish_trans_bag_id_33 : 0) + (this.t4 ? element.finish_trans_bag_id_32 : 0)
  1408. element.a17 = (this.DD ? t4DD : 0) + (this.DI ? t4DI : 0) + (this.II ? t4II : 0) + (this.II ? t4ID : 0)
  1409. let t5DD = (this.t1 ? element.not_trans_bag_dd_22 : 0) + (this.t2 ? element.not_trans_bag_dd_23 : 0) + (this.t3 ? element.not_trans_bag_dd_33 : 0) + (this.t4 ? element.not_trans_bag_dd_32 : 0)
  1410. let t5DI = (this.t1 ? element.not_trans_bag_di_22 : 0) + (this.t2 ? element.not_trans_bag_di_23 : 0) + (this.t3 ? element.not_trans_bag_di_33 : 0) + (this.t4 ? element.not_trans_bag_di_32 : 0)
  1411. let t5II = (this.t1 ? element.not_trans_bag_ii_22 : 0) + (this.t2 ? element.not_trans_bag_ii_23 : 0) + (this.t3 ? element.not_trans_bag_ii_33 : 0) + (this.t4 ? element.not_trans_bag_ii_32 : 0)
  1412. let t5ID = (this.t1 ? element.not_trans_bag_id_22 : 0) + (this.t2 ? element.not_trans_bag_id_23 : 0) + (this.t3 ? element.not_trans_bag_id_33 : 0) + (this.t4 ? element.not_trans_bag_id_32 : 0)
  1413. element.a19 = (this.DD ? t5DD : 0) + (this.DI ? t5DI : 0) + (this.II ? t5II : 0) + (this.II ? t5ID : 0)
  1414. element.a18 = (element.a17 * 100 /( element.a16 > 0 ? element.a16 : 0)).toFixed(2) + '%'
  1415. });
  1416. } else if (this.upid == 8) {
  1417. this.tableData.forEach(element => {
  1418. element.lv = element.lv.toFixed(2)
  1419. element.time = this.dataContent[0] + '至' + this.dataContent[1]
  1420. });
  1421. }
  1422. // setTimeout(() => {
  1423. // this.initTableData();
  1424. // this.loading = false;
  1425. // }, 100);
  1426. } else {
  1427. this.page--
  1428. this.loading = false
  1429. this.$message.error('获取表格数据失败')
  1430. }
  1431. } catch (error) {
  1432. this.page--
  1433. this.loading = false
  1434. }
  1435. },
  1436. downFile() {
  1437. if (this.upid == 1) {
  1438. let tableName = this.dataContent[1] + '国航行李BRS扫描数据统计表'
  1439. const table = this.$refs['userTableData'].$el.cloneNode(true)
  1440. const fileName = `${tableName}.xlsx`
  1441. exportToExcel(table, tableName, fileName)
  1442. } else if (this.upid == 2) {
  1443. let tableName = 'Mannual Load扫描数据统计表'
  1444. const table = this.$refs['userTableDatard'].$el.cloneNode(true)
  1445. const fileName = `${tableName}.xlsx`
  1446. exportToExcel(table, tableName, fileName)
  1447. } else if (this.upid == 3) {
  1448. let tableName = '航易行RFID扫描数据统计表'
  1449. const table = this.$refs['TableDatardrfid'].$el.cloneNode(true)
  1450. const fileName = `${tableName}.xlsx`
  1451. exportToExcel(table, tableName, fileName)
  1452. } else if (this.upid == 4) {
  1453. let tableName = '中转四个流向统计表'
  1454. const table = this.$refs['userTableDatas'].$el.cloneNode(true)
  1455. const fileName = `${tableName}.xlsx`
  1456. exportToExcel(table, tableName, fileName)
  1457. } else if (this.upid == 5) {
  1458. let tableName = '中转流向明细统计表'
  1459. const table = this.$refs['transferTableData'].$el.cloneNode(true)
  1460. const fileName = `${tableName}.xlsx`
  1461. exportToExcel(table, tableName, fileName)
  1462. } else if (this.upid == 6) {
  1463. let tableName = '中转行李因素分析统计表'
  1464. const table = this.$refs['transferBaggageTableData'].$el.cloneNode(true)
  1465. const fileName = `${tableName}.xlsx`
  1466. exportToExcel(table, tableName, fileName)
  1467. } else if (this.upid == 7) {
  1468. let tableName = '中转行李比例明细统计表'
  1469. const table =
  1470. this.$refs['baggageProportionTableData'].$el.cloneNode(true)
  1471. const fileName = `${tableName}.xlsx`
  1472. exportToExcel(table, tableName, fileName)
  1473. }else if (this.upid == 8) {
  1474. let tableName = '行李全流程服务水平百分比表'
  1475. const table =
  1476. this.$refs['userTableDataelt'].$el.cloneNode(true)
  1477. const fileName = `${tableName}.xlsx`
  1478. exportToExcel(table, tableName, fileName)
  1479. }
  1480. },
  1481. cellClass({ row, column, rowIndex, columnIndex }) {
  1482. const classes = []
  1483. if (
  1484. column.property.includes('trans_bag') &&
  1485. row[column.property] &&
  1486. Number(row[column.property])
  1487. ) {
  1488. classes.push('cell-click')
  1489. }
  1490. return classes.join(' ')
  1491. },
  1492. cellClickHandler(...payload) {
  1493. this.$emit('cell-click', ...payload)
  1494. }
  1495. },
  1496. }
  1497. </script>
  1498. <style lang="scss" scoped>
  1499. ::v-deep .el-table {
  1500. .cell-click {
  1501. cursor: pointer;
  1502. color: #2d7cff;
  1503. }
  1504. }
  1505. </style>