excel.vue 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
  1. <template>
  2. <div v-if="!excelViewStatus">
  3. <el-table :data="tableData" class="tableView">
  4. <el-table-column fixed prop="formName" label="表格名称" align="center" />
  5. <el-table-column prop="formType" label="表格类型" align="center">
  6. <template #default="scope">
  7. {{ dictS.getLableByValue("excel_type", scope.row.formType) }}
  8. </template>
  9. </el-table-column>
  10. <el-table-column prop="writeData" align="center" label="是否已填报">
  11. <template #default="scope">
  12. <span
  13. :class="{
  14. 'red-text': scope.row.writeData === '',
  15. 'green-text': scope.row.writeData !== '',
  16. }"
  17. >
  18. {{ scope.row.writeData === "" ? "否" : "是" }}
  19. </span>
  20. </template>
  21. </el-table-column>
  22. <el-table-column label="操作" fixed="right" width="200">
  23. <template #default="scope">
  24. <el-button
  25. link
  26. v-if="scope.row.writeData !== ''"
  27. class="btnText"
  28. type="primary"
  29. @click="handleLook(scope.row)"
  30. >
  31. 查看
  32. </el-button>
  33. <el-button
  34. link
  35. class="btnText"
  36. type="primary"
  37. @click="handleEdit(scope.row)"
  38. >
  39. 编辑
  40. </el-button>
  41. <el-popconfirm
  42. v-if="scope.row.writeData !== ''"
  43. :visible="scope.row.dialogVisible"
  44. title="您确认重置吗?(重置此操作不可逆)"
  45. width="200"
  46. @cancel="scope.row.dialogVisible = false"
  47. @confirm="reset(scope.row)"
  48. >
  49. <el-button> 取消 </el-button>
  50. <el-button type="primary"> 确认 </el-button>
  51. <template #reference>
  52. <el-button
  53. link
  54. class="btnText"
  55. type="primary"
  56. @click="scope.row.dialogVisible = true"
  57. >重置</el-button
  58. >
  59. </template>
  60. </el-popconfirm>
  61. </template>
  62. </el-table-column>
  63. </el-table>
  64. </div>
  65. <div class="excelView" v-else>
  66. <div class="view">
  67. <ExcelView
  68. v-model:data="excelData"
  69. :option="excelOptions"
  70. ref="excelViewRef"
  71. />
  72. </div>
  73. <div class="opeara">
  74. <div>
  75. <el-button
  76. v-if="excelOptions.edit"
  77. type="primary"
  78. class="btn"
  79. @click="submitData"
  80. >提交</el-button
  81. >
  82. <el-button class="btn" @click="resetData">{{
  83. excelOptions.edit ? "取消" : "返回"
  84. }}</el-button>
  85. </div>
  86. </div>
  87. </div>
  88. </template>
  89. <script setup>
  90. defineOptions({
  91. name: "Excel",
  92. });
  93. import { getExcelData, setExcelData } from "@/api/prosteps/excel";
  94. import { useProcessStore } from "@/store";
  95. import { useDictionaryStore } from "@/store";
  96. const dictS = useDictionaryStore();
  97. const store = useProcessStore();
  98. const tableData = ref([]);
  99. const dataList = async () => {
  100. const { data } = await getExcelData(store.scanInfo.id);
  101. tableData.value = data;
  102. };
  103. const useExcelHook = () => {
  104. const excelViewStatus = ref(false);
  105. const excelData = ref(null);
  106. const excelViewRef = ref(null);
  107. const excelSelectRow = ref(null);
  108. const excelOptions = ref({
  109. opreaState: true,
  110. in: true,
  111. out: true,
  112. print: true,
  113. edit: true,
  114. inName: "",
  115. });
  116. const resetData = () => {
  117. if (excelViewRef.value) {
  118. excelViewRef.value.saveCellData();
  119. excelViewRef.value.reset();
  120. }
  121. excelViewStatus.value = false;
  122. excelData.value = null;
  123. excelSelectRow.value = null;
  124. excelOptions.value = {
  125. opreaState: true,
  126. in: true,
  127. out: true,
  128. print: true,
  129. edit: true,
  130. inName: "",
  131. };
  132. };
  133. const reset = async (row) => {
  134. excelData.value = "";
  135. const { data, code } = await setExcelData({
  136. excelData: excelData.value,
  137. formName: row.formName,
  138. excelFormId: row.excelFormId,
  139. formType: row.formType,
  140. processId: store.scanInfo.id,
  141. });
  142. if (code == "200") {
  143. ElMessage.success("操作成功!");
  144. row.dialogVisible = false;
  145. resetData();
  146. dataList();
  147. }
  148. };
  149. const handleEdit = (row) => {
  150. excelSelectRow.value = row;
  151. if (row.writeData == "") {
  152. excelData.value = JSON.parse(row.excelData);
  153. } else {
  154. excelData.value = JSON.parse(row.writeData);
  155. }
  156. excelOptions.value.inName = row.formName;
  157. excelViewStatus.value = true;
  158. };
  159. const handleLook = (row) => {
  160. excelOptions.value.edit = false;
  161. excelData.value = JSON.parse(row.writeData);
  162. excelOptions.value.inName = row.formName;
  163. excelViewStatus.value = true;
  164. };
  165. const submitData = async () => {
  166. excelData.value = excelViewRef.value.getData();
  167. const { data, code } = await setExcelData({
  168. excelData: excelData.value,
  169. excelFormId: excelSelectRow.value.excelFormId,
  170. formName: excelSelectRow.value.formName,
  171. formType: excelSelectRow.value.formType,
  172. processId: store.scanInfo.id,
  173. });
  174. if (code == "200") {
  175. ElMessage.success("操作成功!");
  176. resetData();
  177. dataList();
  178. }
  179. };
  180. return {
  181. excelViewStatus,
  182. excelOptions,
  183. excelData,
  184. excelViewRef,
  185. resetData,
  186. handleEdit,
  187. submitData,
  188. handleLook,
  189. reset,
  190. };
  191. };
  192. const {
  193. excelViewStatus,
  194. excelOptions,
  195. excelData,
  196. excelViewRef,
  197. resetData,
  198. handleEdit,
  199. submitData,
  200. handleLook,
  201. reset,
  202. } = useExcelHook();
  203. onMounted(() => {
  204. dataList();
  205. });
  206. </script>
  207. <style lang="scss" scoped>
  208. .btnText {
  209. font-size: $f20;
  210. color: black;
  211. }
  212. .excelView {
  213. width: 100%;
  214. height: calc(100vh - 260px);
  215. padding: 20px;
  216. display: flex;
  217. background-color: white;
  218. border-radius: 16px;
  219. .view {
  220. position: relative;
  221. flex: 1;
  222. height: calc(100vh - 300px);
  223. }
  224. .opeara {
  225. width: 200px;
  226. height: 100%;
  227. padding: 10px;
  228. display: flex;
  229. align-items: center;
  230. }
  231. }
  232. .tableView {
  233. width: 100%;
  234. height: calc(100vh - 260px);
  235. padding: 20px 0px;
  236. border-radius: 16px;
  237. }
  238. .btn {
  239. width: 180px;
  240. border-radius: 16px;
  241. height: 40px;
  242. font-size: 16px;
  243. margin: 10px 0;
  244. }
  245. .red-text {
  246. color: red;
  247. }
  248. .green-text {
  249. color: green;
  250. }
  251. </style>