sheetApi.js 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354
  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. * @returns
  93. */
  94. export const sheetDetail = params => {
  95. return http.get('/datamanage/excel_info/detail',params)
  96. }
  97. /**
  98. * 保存草稿
  99. * @param {*} params ExcelInfoId ExcelName ExcelClassifyId Content
  100. * @returns
  101. */
  102. export const sheetDrafSave = params => {
  103. return http.post('/datamanage/excel_info/draft/add',params)
  104. }
  105. /**
  106. *
  107. * @param {*} params Image
  108. * @returns
  109. */
  110. export const uploadImg = params => {
  111. return http.post('/resource/upload_image_base64',params)
  112. }
  113. /**
  114. * 获取表格数据
  115. */
  116. export const getSheetData = params=>{
  117. return http.get('/datamanage/excel_info/table_data',params)
  118. }
  119. /* =====自定义表格====== */
  120. /**
  121. * 选择指标插入的数据 第一个指标
  122. * @param {*} params
  123. * EdbInfoId Num
  124. * @returns
  125. */
  126. export const getEdbInsertDataA = params => {
  127. return http.get('/datamanage/excel_info/table/first_edb_data_list',params)
  128. }
  129. /**
  130. * 选择指标根据日期插入数据 第N个指标
  131. * @param {*} params
  132. * EdbInfoId DateList
  133. * @returns
  134. */
  135. export const getEdbInsertDataOther = params => {
  136. return http.post('/datamanage/excel_info/table/other_edb_data_list',params)
  137. }
  138. /**
  139. * 根据公式计算结果
  140. * @param {*} params
  141. * "CalculateFormula": "=A+B/C",
  142. "TagMap":{
  143. "A":100,
  144. "B":200,
  145. "C":0,
  146. }
  147. * @returns
  148. */
  149. export const calculateCustomCellData = params => {
  150. return http.post('/datamanage/excel_info/table/calculate',params)
  151. }
  152. /**
  153. * 获取未来日期的数据
  154. * @param {*} params
  155. * "EdbInfoIdList": [102227],
  156. "DateType":2,
  157. "StartDate":"2023-07-28",
  158. "EndDate":"2023-11-28",
  159. * @returns
  160. */
  161. export const getCustomFutureData = params => {
  162. return http.post('/datamanage/excel_info/table/future_date_list',params)
  163. }
  164. /**
  165. * 获取过去N期数据
  166. * @param {*} params
  167. * EdbInfoIdList [] EndDate Num
  168. * @returns
  169. */
  170. export const getCustomPastData = params => {
  171. return http.post('/datamanage/excel_info/table/history_date_list',params)
  172. }
  173. /**
  174. * 编辑页详情 ExcelInfoId
  175. * @param {*} params
  176. * @returns
  177. */
  178. export const getCustomSheetDetail = params => {
  179. return http.get('/datamanage/excel_info/table/detail',params)
  180. }
  181. /**
  182. * 刷新表格 ExcelInfoId
  183. * @param {*} params
  184. * @returns
  185. */
  186. export const refreshCustomSheet = params => {
  187. return http.get('/datamanage/excel_info/table/refresh',params)
  188. }
  189. /**
  190. * 下载excel
  191. * @param {*} params ExcelInfoId authorization
  192. * @returns
  193. */
  194. export const downExcelFile = params => {
  195. return http.get('/datamanage/excel_info/table/download',params)
  196. }
  197. /**
  198. * 另存为
  199. * @param {*} params
  200. * ExcelInfoId ExcelName ExcelClassifyId
  201. * @returns
  202. */
  203. export const copyExcel = params => {
  204. return http.post('/datamanage/excel_info/copy',params)
  205. }
  206. /* ======混合表格======= */
  207. /**
  208. * 指标搜索
  209. * @param {*} params KeyWord CurrentIndex PageSize
  210. * @returns
  211. */
  212. export const searchTarget = params => {
  213. return http.get('/datamanage/edb_info/filter_by_es/all',params)
  214. }
  215. /**
  216. * 插值
  217. * @param {*} params EdbInfoId Date
  218. * @returns
  219. */
  220. export const insertData = params => {
  221. return http.get('/datamanage/edb_info/date_data',params)
  222. }
  223. /**
  224. * 获取日期最近几期的数据
  225. * @param {*} params EdbInfoId Date Num
  226. * @returns
  227. */
  228. export const getDateLatelyData = params => {
  229. return http.get('/datamanage/edb_info/date_data/before_after',params)
  230. }
  231. /* =====自定义分析==== */
  232. export const sheetAnalysisInterface = {
  233. /**
  234. * 移动表格
  235. * @param {*} params ExcelClassifyId ExcelInfoId PrevExcelInfoId NextExcelInfoId
  236. * @returns
  237. */
  238. sheetMove: params => {
  239. return http.post('/datamanage/excel_info/move',params)
  240. },
  241. /**
  242. * 新增表格
  243. * @param {*} params ExcelName ExcelClassifyId ExcelImage Content
  244. * @returns
  245. */
  246. excelSheetAdd: params => {
  247. return http.post('/custom_analysis/add',params)
  248. },
  249. /**
  250. * 获取详情
  251. * @param {*} params UniqueCode
  252. * @returns
  253. */
  254. getExcelDetail: params => {
  255. return http.get('/custom_analysis/excel/base',params)
  256. },
  257. /**
  258. * 分页加载celldata
  259. * @param {*} params UniqueCode Page
  260. * @returns
  261. */
  262. getExcelDataByPage: params => {
  263. return http.get('/custom_analysis/excel/data',params)
  264. },
  265. /**
  266. * 表格保存
  267. * @param {*} params ExcelName ExcelInfoId ExcelClassifyId ExcelImage Content
  268. */
  269. sheetEdit: params => {
  270. return http.post('/custom_analysis/save',params)
  271. },
  272. /**
  273. * 生成指标
  274. * @param {*} params
  275. * EdbName ExcelInfoId ClassifyId Frequency Unit DateSequenceVal DataSequenceVal DateSequenceStr DataSequenceStr
  276. * @returns
  277. */
  278. edbAddBysheet: params => {
  279. return http.post('/custom_analysis/edb/add',params)
  280. },
  281. /**
  282. * 指标编辑
  283. * @param {*} params
  284. * EdbName ExcelInfoId EdbInfoId ClassifyId Frequency Unit DateSequenceVal DataSequenceVal
  285. * @returns
  286. */
  287. edbEditBysheet: params => {
  288. return http.post('/custom_analysis/edb/edit',params)
  289. },
  290. /**
  291. * 获取表格生成的指标列表
  292. * @param {*} params ExcelInfoId
  293. * @returns
  294. */
  295. edbListBySheet: params => {
  296. return http.get('/custom_analysis/edb/list',params)
  297. },
  298. /**
  299. * 刷新
  300. * @param {*} params ExcelInfoId
  301. * @returns
  302. */
  303. sheetRefresh: params => {
  304. return http.get('/custom_analysis/edb/refresh',params)
  305. },
  306. /**
  307. * 检查是否有同名表格
  308. * @param {*} params ExcelName
  309. * @returns
  310. */
  311. checkSheetRepeat: params => {
  312. return http.get('/custom_analysis/excel_by_name',params)
  313. }
  314. }