excel.vue 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  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. formType: row.formType,
  139. processId: store.scanInfo.id,
  140. });
  141. if (code == "200") {
  142. ElMessage.success("操作成功!");
  143. row.dialogVisible = false;
  144. resetData();
  145. dataList();
  146. }
  147. };
  148. const handleEdit = (row) => {
  149. excelSelectRow.value = row;
  150. if (row.writeData == "") {
  151. excelData.value = JSON.parse(row.excelData);
  152. } else {
  153. excelData.value = JSON.parse(row.writeData);
  154. }
  155. excelOptions.value.inName = row.formName;
  156. excelViewStatus.value = true;
  157. };
  158. const handleLook = (row) => {
  159. excelOptions.value.edit = false;
  160. excelData.value = JSON.parse(row.writeData);
  161. excelOptions.value.inName = row.formName;
  162. excelViewStatus.value = true;
  163. };
  164. const submitData = async () => {
  165. excelData.value = excelViewRef.value.getData();
  166. const { data, code } = await setExcelData({
  167. excelData: excelData.value,
  168. excelFormId: excelSelectRow.value.excelFormId,
  169. formName: excelSelectRow.value.formName,
  170. formType: excelSelectRow.value.formType,
  171. processId: store.scanInfo.id,
  172. });
  173. if (code == "200") {
  174. ElMessage.success("操作成功!");
  175. resetData();
  176. dataList();
  177. }
  178. };
  179. return {
  180. excelViewStatus,
  181. excelOptions,
  182. excelData,
  183. excelViewRef,
  184. resetData,
  185. handleEdit,
  186. submitData,
  187. handleLook,
  188. reset,
  189. };
  190. };
  191. const {
  192. excelViewStatus,
  193. excelOptions,
  194. excelData,
  195. excelViewRef,
  196. resetData,
  197. handleEdit,
  198. submitData,
  199. handleLook,
  200. reset,
  201. } = useExcelHook();
  202. onMounted(() => {
  203. dataList();
  204. });
  205. </script>
  206. <style lang="scss" scoped>
  207. .btnText {
  208. font-size: $f20;
  209. color: black;
  210. }
  211. .excelView {
  212. width: 100%;
  213. height: calc(100vh - 260px);
  214. padding: 20px;
  215. display: flex;
  216. background-color: white;
  217. border-radius: 16px;
  218. .view {
  219. position: relative;
  220. flex: 1;
  221. height: calc(100vh - 300px);
  222. }
  223. .opeara {
  224. width: 200px;
  225. height: 100%;
  226. padding: 10px;
  227. display: flex;
  228. align-items: center;
  229. }
  230. }
  231. .tableView {
  232. width: 100%;
  233. height: calc(100vh - 260px);
  234. padding: 20px 0px;
  235. border-radius: 16px;
  236. }
  237. .btn {
  238. width: 180px;
  239. border-radius: 16px;
  240. height: 40px;
  241. font-size: 16px;
  242. margin: 10px 0;
  243. }
  244. .red-text {
  245. color: red;
  246. }
  247. .green-text {
  248. color: green;
  249. }
  250. </style>