sheetApi.js 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406
  1. import http from "@/api/http.js"
  2. /**
  3. * 获取分类
  4. * @returns
  5. */
  6. export const classifyList = params =>{
  7. return http.get('/datamanage/excel_classify/list',params)
  8. }
  9. /**
  10. * 新增分类
  11. * @param {*} params "ExcelClassifyName": "分类1-2"
  12. * @returns
  13. */
  14. export const classifyAdd = params =>{
  15. return http.post('/datamanage/excel_classify/add',params)
  16. }
  17. /**
  18. * 编辑分类
  19. * @param {*} params ExcelClassifyName ExcelClassifyId
  20. * @returns
  21. */
  22. export const classifyEdit = params =>{
  23. return http.post('/datamanage/excel_classify/edit',params)
  24. }
  25. /**
  26. * 删除分类检测
  27. * @param {*} params ExcelClassifyId ExcelInfoId
  28. * @returns
  29. */
  30. export const classifyDelCheck = params =>{
  31. return http.post('/datamanage/excel_classify/delete/check',params)
  32. }
  33. /**
  34. * 删除分类
  35. * @param {*} params ExcelClassifyId ExcelInfoId
  36. * @returns
  37. */
  38. export const classifyDel = params =>{
  39. return http.post('/datamanage/excel_classify/delete',params)
  40. }
  41. /**
  42. * 移动分类
  43. * @param {*} params ClassifyId "PrevClassifyId":1, "NextClassifyId":2,
  44. * @returns
  45. */
  46. export const classifyMove = params =>{
  47. return http.post('/datamanage/excel_classify/move',params)
  48. }
  49. /**
  50. * 移动表格
  51. * @param {*} params ExcelClassifyId ExcelInfoId PrevExcelInfoId NextExcelInfoId
  52. * @returns
  53. */
  54. export const sheetMove = params => {
  55. return http.post('/datamanage/excel_info/move',params)
  56. }
  57. /**
  58. * 表格列表
  59. * @param {*} params CurrentIndex PageSize ExcelClassifyId
  60. */
  61. export const sheetList = params => {
  62. return http.get('/datamanage/excel_info/list',params)
  63. }
  64. /**
  65. * 表格分类
  66. * @param {*} params
  67. * @returns
  68. */
  69. export const excelClassifyOne = params => {
  70. return http.get('/datamanage/excel_classify/items',params)
  71. }
  72. /**
  73. * 新增表格
  74. * @param {*} params ExcelName ExcelClassifyId Content
  75. * //自定义表格ExcelImage ExcelType TableData
  76. * @returns
  77. */
  78. export const sheetAdd = params => {
  79. return http.post('/datamanage/excel_info/add',params)
  80. }
  81. /**
  82. * 保存表格
  83. * @param {*} params ExcelInfoId ExcelName ExcelClassifyId Content
  84. * @returns
  85. */
  86. export const sheetEdit = params => {
  87. return http.post('/datamanage/excel_info/edit',params)
  88. }
  89. /**
  90. * 标记表格的编辑状态
  91. * @param {*} params ExcelInfoId
  92. * @param {*} params Status 1:编辑中,2:编辑完成
  93. * @returns
  94. */
  95. export const markSheetEditStatus = params => {
  96. return http.post('/datamanage/excel_info/mark',params)
  97. }
  98. /**
  99. * 获取表格详情
  100. * @param {*} params ExcelInfoId
  101. * @returns
  102. */
  103. export const sheetDetail = params => {
  104. return http.get('/datamanage/excel_info/detail',params)
  105. }
  106. /**
  107. * 保存草稿
  108. * @param {*} params ExcelInfoId ExcelName ExcelClassifyId Content
  109. * @returns
  110. */
  111. export const sheetDrafSave = params => {
  112. return http.post('/datamanage/excel_info/draft/add',params)
  113. }
  114. /**
  115. *
  116. * @param {*} params Image
  117. * @returns
  118. */
  119. export const uploadImg = params => {
  120. return http.post('/resource/upload_image_base64',params)
  121. }
  122. /**
  123. * 获取表格数据
  124. */
  125. export const getSheetData = params=>{
  126. return http.get('/datamanage/excel_info/table_data',params)
  127. }
  128. /* =====自定义表格====== */
  129. /**
  130. * 选择指标插入的数据 第一个指标
  131. * @param {*} params
  132. * EdbInfoId Num
  133. * @returns
  134. */
  135. export const getEdbInsertDataA = params => {
  136. return http.get('/datamanage/excel_info/table/first_edb_data_list',params)
  137. }
  138. /**
  139. * 选择指标根据日期插入数据 第N个指标
  140. * @param {*} params
  141. * EdbInfoId DateList
  142. * @returns
  143. */
  144. export const getEdbInsertDataOther = params => {
  145. return http.post('/datamanage/excel_info/table/other_edb_data_list',params)
  146. }
  147. /**
  148. * 根据公式计算结果
  149. * @param {*} params
  150. * "CalculateFormula": "=A+B/C",
  151. "TagMap":{
  152. "A":100,
  153. "B":200,
  154. "C":0,
  155. }
  156. * @returns
  157. */
  158. export const calculateCustomCellData = params => {
  159. return http.post('/datamanage/excel_info/table/calculate',params)
  160. }
  161. /**
  162. * 获取未来日期的数据
  163. * @param {*} params
  164. * "EdbInfoIdList": [102227],
  165. "DateType":2,
  166. "StartDate":"2023-07-28",
  167. "EndDate":"2023-11-28",
  168. * @returns
  169. */
  170. export const getCustomFutureData = params => {
  171. return http.post('/datamanage/excel_info/table/future_date_list',params)
  172. }
  173. /**
  174. * 获取过去N期数据
  175. * @param {*} params
  176. * EdbInfoIdList [] EndDate Num
  177. * @returns
  178. */
  179. export const getCustomPastData = params => {
  180. return http.post('/datamanage/excel_info/table/history_date_list',params)
  181. }
  182. /**
  183. * 编辑页详情 ExcelInfoId
  184. * @param {*} params
  185. * @returns
  186. */
  187. export const getCustomSheetDetail = params => {
  188. return http.get('/datamanage/excel_info/table/detail',params)
  189. }
  190. /**
  191. * 刷新表格 ExcelInfoId
  192. * @param {*} params
  193. * @returns
  194. */
  195. export const refreshCustomSheet = params => {
  196. return http.get('/datamanage/excel_info/table/refresh',params)
  197. }
  198. /**
  199. * 下载excel
  200. * @param {*} params ExcelInfoId authorization
  201. * @returns
  202. */
  203. export const downExcelFile = params => {
  204. return http.get('/datamanage/excel_info/table/download',params)
  205. }
  206. /**
  207. * 另存为
  208. * @param {*} params
  209. * ExcelInfoId ExcelName ExcelClassifyId
  210. * @returns
  211. */
  212. export const copyExcel = params => {
  213. return http.post('/datamanage/excel_info/copy',params)
  214. }
  215. /* ======混合表格======= */
  216. /**
  217. * 指标搜索
  218. * @param {*} params KeyWord CurrentIndex PageSize
  219. * @returns
  220. */
  221. export const searchTarget = params => {
  222. return http.get('/datamanage/edb_info/filter_by_es/all',params)
  223. }
  224. /**
  225. * 插值
  226. * @param {*} params EdbInfoId Date
  227. * @returns
  228. */
  229. export const insertData = params => {
  230. return http.get('/datamanage/edb_info/date_data',params)
  231. }
  232. /**
  233. * 获取日期最近几期的数据
  234. * @param {*} params EdbInfoId Date Num
  235. * @returns
  236. */
  237. export const getDateLatelyData = params => {
  238. return http.get('/datamanage/edb_info/date_data/before_after',params)
  239. }
  240. /**
  241. * 获取系统日期
  242. * @param {*} params
  243. * "DataTimeType": 1,
  244. "Value": "{\"Source\":3,\"Frequency\":\"本周\",\"Day\":\"周日\",\"CalculateNum\":0,\"CalculateFrequency\":\"\"}"
  245. * @returns
  246. */
  247. export const getSystemDate = params => {
  248. return http.post('/datamanage/excel_info/get_system_date',params)
  249. }
  250. /**
  251. * 混合表格指标计算
  252. * @param {*} params
  253. * EdbInfoId Source Formula Frequency Calendar MoveType MoveFrequency
  254. * @returns
  255. */
  256. export const getMixedCalculateData = params => {
  257. return http.post('/datamanage/excel_info/mixed/calculate',params)
  258. }
  259. /**
  260. * 表格一键刷新
  261. * @param {Object} params
  262. * @param {Array} params.ExcelCodes 表格唯一编码
  263. * @param {String} params.Source 来源,枚举值:report、english_report、smart_report
  264. * @param {Number} params.ReportId 报告id
  265. * @param {Number} params.ReportChapterId 章节id 非章节传0
  266. */
  267. export const refreshSheet = (params)=>{
  268. return http.post('/datamanage/excel_info/table/batch_refresh',params)
  269. }
  270. /**
  271. * 获取表格刷新结果
  272. * @param {Object} params
  273. * @param {String} params.Source 来源,枚举值:report、english_report、smart_report
  274. * @param {Number} params.ReportId 报告id
  275. * @param {Number} params.ReportChapterId 章节id 非章节传0
  276. */
  277. export const getRefreshResult = (params)=>{
  278. return http.post('/datamanage/excel_info/table/batch_refresh/result',params)
  279. }
  280. /* =====自定义分析==== */
  281. export const sheetAnalysisInterface = {
  282. /**
  283. * 移动表格
  284. * @param {*} params ExcelClassifyId ExcelInfoId PrevExcelInfoId NextExcelInfoId
  285. * @returns
  286. */
  287. sheetMove: params => {
  288. return http.post('/datamanage/excel_info/move',params)
  289. },
  290. /**
  291. * 新增表格
  292. * @param {*} params ExcelName ExcelClassifyId ExcelImage Content
  293. * @returns
  294. */
  295. excelSheetAdd: params => {
  296. return http.post('/custom_analysis/add',params)
  297. },
  298. /**
  299. * 获取详情
  300. * @param {*} params UniqueCode
  301. * @returns
  302. */
  303. getExcelDetail: params => {
  304. return http.get('/custom_analysis/excel/base',params)
  305. },
  306. /**
  307. * 分页加载celldata
  308. * @param {*} params UniqueCode Page
  309. * @returns
  310. */
  311. getExcelDataByPage: params => {
  312. return http.get('/custom_analysis/excel/data',params)
  313. },
  314. /**
  315. * 表格保存
  316. * @param {*} params ExcelName ExcelInfoId ExcelClassifyId ExcelImage Content
  317. */
  318. sheetEdit: params => {
  319. return http.post('/custom_analysis/save',params)
  320. },
  321. /**
  322. * 生成指标
  323. * @param {*} params
  324. * EdbName ExcelInfoId ClassifyId Frequency Unit DateSequenceVal DataSequenceVal DateSequenceStr DataSequenceStr
  325. * @returns
  326. */
  327. edbAddBysheet: params => {
  328. return http.post('/custom_analysis/edb/add',params)
  329. },
  330. /**
  331. * 指标编辑
  332. * @param {*} params
  333. * EdbName ExcelInfoId EdbInfoId ClassifyId Frequency Unit DateSequenceVal DataSequenceVal
  334. * @returns
  335. */
  336. edbEditBysheet: params => {
  337. return http.post('/custom_analysis/edb/edit',params)
  338. },
  339. /**
  340. * 获取表格生成的指标列表
  341. * @param {*} params ExcelInfoId
  342. * @returns
  343. */
  344. edbListBySheet: params => {
  345. return http.get('/custom_analysis/edb/list',params)
  346. },
  347. /**
  348. * 刷新
  349. * @param {*} params ExcelInfoId
  350. * @returns
  351. */
  352. sheetRefresh: params => {
  353. return http.get('/custom_analysis/edb/refresh',params)
  354. },
  355. /**
  356. * 检查是否有同名表格
  357. * @param {*} params ExcelName
  358. * @returns
  359. */
  360. checkSheetRepeat: params => {
  361. return http.get('/custom_analysis/excel_by_name',params)
  362. }
  363. }