chart_info.go 107 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802
  1. package data_manage
  2. import (
  3. "errors"
  4. "eta/eta_api/models/mgo"
  5. "eta/eta_api/utils"
  6. "fmt"
  7. "github.com/beego/beego/v2/client/orm"
  8. "github.com/rdlucklib/rdluck_tools/paging"
  9. "go.mongodb.org/mongo-driver/bson"
  10. "strconv"
  11. "strings"
  12. "time"
  13. )
  14. type ChartInfo struct {
  15. ChartInfoId int `orm:"column(chart_info_id);pk"`
  16. ChartName string `description:"图表名称"`
  17. ChartNameEn string `description:"英文图表名称"`
  18. ChartClassifyId int `description:"图表分类id"`
  19. SysUserId int
  20. SysUserRealName string
  21. UniqueCode string `description:"图表唯一编码"`
  22. CreateTime time.Time
  23. ModifyTime time.Time
  24. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间"`
  25. StartDate string `description:"自定义开始日期"`
  26. EndDate string `description:"自定义结束日期"`
  27. IsSetName int `description:"设置名称"`
  28. EdbInfoIds string `description:"指标id"`
  29. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图,7:柱方图,8:商品价格曲线图,9:相关性图,10:截面散点图, 11:雷达图"`
  30. Calendar string `description:"公历/农历"`
  31. SeasonStartDate string `description:"季节性图开始日期"`
  32. SeasonEndDate string `description:"季节性图开始日期"`
  33. ChartImage string `description:"图表图片"`
  34. Sort int `description:"排序字段,数字越小越排前面"`
  35. XMin string `description:"图表X轴最小值"`
  36. XMax string `description:"图表X轴最大值"`
  37. LeftMin string `description:"图表左侧最小值"`
  38. LeftMax string `description:"图表左侧最大值"`
  39. RightMin string `description:"图表右侧最小值"`
  40. RightMax string `description:"图表右侧最大值"`
  41. Right2Min string `description:"图表右侧2最小值"`
  42. Right2Max string `description:"图表右侧2最大值"`
  43. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  44. Disabled int `description:"是否禁用,0:启用,1:禁用,默认:0"`
  45. BarConfig string `description:"柱方图的配置,json数据"`
  46. Source int `description:"1:ETA图库;2:商品价格曲线"`
  47. ExtraConfig string `description:"图表额外配置,json数据"`
  48. SeasonExtraConfig string `description:"季节性图表中的配置,json数据"`
  49. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  50. ChartThemeId int `description:"图表应用主题ID"`
  51. SourcesFrom string `description:"图表来源"`
  52. Instructions string `description:"图表说明"`
  53. MarkersLines string `description:"标识线"`
  54. MarkersAreas string `description:"标识区"`
  55. Unit string `description:"中文单位名称"`
  56. UnitEn string `description:"英文单位名称"`
  57. IsJoinPermission int `description:"是否加入权限管控,0:不加入;1:加入;默认:0"`
  58. ForumChartInfoId int `description:"社区的图表ID"`
  59. ChartAlias string `description:"图表别名"`
  60. }
  61. type ChartInfoMore struct {
  62. ChartInfo
  63. IsEnChart bool `description:"是否展示英文标识"`
  64. HaveOperaAuth bool `description:"是否有数据权限,默认:false"`
  65. }
  66. func AddChartInfo(item *ChartInfo) (lastId int64, err error) {
  67. o := orm.NewOrmUsingDB("data")
  68. lastId, err = o.Insert(item)
  69. return
  70. }
  71. type ChartInfoItem struct {
  72. ChartInfoId int `description:"图表id"`
  73. ChartName string `description:"图表名称"`
  74. ChartClassifyId int `description:"图表分类"`
  75. }
  76. // GetChartInfoAll 用于分类展示
  77. // @param source int 1:ETA图库;2:商品价格曲线
  78. func GetChartInfoAll(sourceList []int) (items []*ChartClassifyItems, err error) {
  79. num := len(sourceList)
  80. if num <= 0 {
  81. return
  82. }
  83. o := orm.NewOrmUsingDB("data")
  84. sql := ` SELECT chart_info_id,chart_classify_id,chart_name AS chart_classify_name,chart_name_en AS chart_classify_name_en,
  85. unique_code,sys_user_id,sys_user_real_name,date_type,start_date,end_date,chart_type,calendar,season_start_date,season_end_date,source
  86. FROM chart_info WHERE source in (` + utils.GetOrmInReplace(num) + `) ORDER BY sort asc,chart_info_id ASC `
  87. _, err = o.Raw(sql, sourceList).QueryRows(&items)
  88. return
  89. }
  90. // GetChartInfoByAdminId 获取所有我创建的图表,用于分类展示
  91. func GetChartInfoByAdminId(sourceList []int, adminId int) (items []*ChartClassifyItems, err error) {
  92. num := len(sourceList)
  93. if num <= 0 {
  94. return
  95. }
  96. o := orm.NewOrmUsingDB("data")
  97. sql := ` SELECT chart_info_id,chart_classify_id,chart_name AS chart_classify_name,
  98. unique_code,sys_user_id,sys_user_real_name,date_type,start_date,end_date,chart_type,calendar,season_start_date,season_end_date
  99. FROM chart_info where source in (` + utils.GetOrmInReplace(num) + `) AND sys_user_id = ? ORDER BY sort asc,create_time ASC `
  100. _, err = o.Raw(sql, sourceList, adminId).QueryRows(&items)
  101. return
  102. }
  103. // 用于分类展示
  104. func GetChartInfoAllList() (items []*ChartInfo, err error) {
  105. o := orm.NewOrmUsingDB("data")
  106. sql := ` SELECT *
  107. FROM chart_info ORDER BY create_time ASC `
  108. _, err = o.Raw(sql).QueryRows(&items)
  109. return
  110. }
  111. // 图表检索数据
  112. type ChartInfoSearch struct {
  113. EdbCode string `description:"图表编码"`
  114. StartDate string `description:"起始日期"`
  115. EndDate string `description:"终止日期"`
  116. DataList []*EdbInfoSearchData
  117. }
  118. type ChartInfoSearchData struct {
  119. DataTime string `description:"数据日期"`
  120. Value float64 `description:"数据"`
  121. }
  122. type ChartInfoSearchResp struct {
  123. SearchItem *EdbInfoSearch `description:"图表分类"`
  124. Status int `description:"1:数据已存在于弘则数据库,2:新数据"`
  125. }
  126. func GetChartInfoById(chartInfoId int) (item *ChartInfo, err error) {
  127. o := orm.NewOrmUsingDB("data")
  128. sql := ` SELECT * FROM chart_info WHERE chart_info_id=? `
  129. err = o.Raw(sql, chartInfoId).QueryRow(&item)
  130. return
  131. }
  132. func GetChartInfoViewById(chartInfoId int) (item *ChartInfoView, err error) {
  133. o := orm.NewOrmUsingDB("data")
  134. sql := ` SELECT * FROM chart_info WHERE chart_info_id=? `
  135. err = o.Raw(sql, chartInfoId).QueryRow(&item)
  136. return
  137. }
  138. func GetChartInfoViewByIds(chartInfoIds []string) (list []*ChartInfoView, err error) {
  139. o := orm.NewOrmUsingDB("data")
  140. sql := ` SELECT * FROM chart_info WHERE chart_info_id in ("` + strings.Join(chartInfoIds, `","`) + `") `
  141. _, err = o.Raw(sql).QueryRows(&list)
  142. return
  143. }
  144. type SaveChartInfoReq struct {
  145. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  146. ChartInfoId int `description:"图表id,新增时传0"`
  147. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间,6:起始日期至今"`
  148. StartDate string `description:"自定义开始日期"`
  149. EndDate string `description:"自定义结束日期"`
  150. Calendar string `description:"公历/农历"`
  151. LeftMin string `description:"图表左侧最小值"`
  152. LeftMax string `description:"图表左侧最大值"`
  153. RightMin string `description:"图表右侧最小值"`
  154. RightMax string `description:"图表右侧最大值"`
  155. Right2Min string `description:"图表右侧最小值"`
  156. Right2Max string `description:"图表右侧最大值"`
  157. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  158. ExtraConfig string `description:"图表额外配置,json数据"`
  159. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  160. }
  161. type ChartSaveItem struct {
  162. EdbInfoId int `description:"指标id"`
  163. MaxData float64 `description:"上限"`
  164. MinData float64 `description:"下限"`
  165. IsOrder bool `description:"true:正序,false:逆序"`
  166. IsAxis int `description:"1:左轴,0:右轴"`
  167. EdbInfoType int `description:"1:标准指标,0:领先指标"`
  168. LeadValue int `description:"领先值"`
  169. LeadUnit string `description:"领先单位"`
  170. ChartStyle string `description:"图表类型"`
  171. ChartColor string `description:"颜色"`
  172. PredictChartColor string `description:"预测数据的颜色"`
  173. ChartWidth float64 `description:"线条大小"`
  174. Source int `description:"1:ETA图库;2:商品价格曲线"`
  175. EdbAliasName string `description:"中文别名"`
  176. IsConvert int `description:"是否数据转换 0不转 1转"`
  177. ConvertType int `description:"数据转换类型 1乘 2除 3对数"`
  178. ConvertValue float64 `description:"数据转换值"`
  179. ConvertUnit string `description:"数据转换单位"`
  180. ConvertEnUnit string `description:"数据转换单位"`
  181. }
  182. func DeleteChartInfoAndData(chartInfoId int) (err error) {
  183. o := orm.NewOrmUsingDB("data")
  184. to, err := o.Begin()
  185. if err != nil {
  186. return
  187. }
  188. defer func() {
  189. if err != nil {
  190. _ = to.Rollback()
  191. } else {
  192. _ = to.Commit()
  193. }
  194. }()
  195. sql := ` DELETE FROM chart_info WHERE chart_info_id=? `
  196. _, err = to.Raw(sql, chartInfoId).Exec()
  197. if err != nil {
  198. return
  199. }
  200. sql = ` DELETE FROM chart_edb_mapping WHERE chart_info_id=? `
  201. _, err = to.Raw(sql, chartInfoId).Exec()
  202. return
  203. }
  204. func GetChartInfoCountByCondition(condition string, pars []interface{}) (count int, err error) {
  205. o := orm.NewOrmUsingDB("data")
  206. sql := ` SELECT COUNT(1) AS count FROM chart_info WHERE 1=1 `
  207. if condition != "" {
  208. sql += condition
  209. }
  210. err = o.Raw(sql, pars).QueryRow(&count)
  211. return
  212. }
  213. type EditChartInfoReq struct {
  214. ChartInfoId int `description:"图表ID"`
  215. ChartName string `description:"图表名称"`
  216. ChartNameEn string `description:"英文图表名称"`
  217. ChartClassifyId int `description:"分类id"`
  218. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  219. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图,7:柱方图,8:商品价格曲线图,9:相关性图,10:截面散点图"`
  220. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间,6:起始日期至今,20:N年至今"`
  221. StartDate string `description:"自定义开始日期"`
  222. EndDate string `description:"自定义结束日期"`
  223. Calendar string `description:"公历/农历"`
  224. LeftMin string `description:"图表左侧最小值"`
  225. LeftMax string `description:"图表左侧最大值"`
  226. RightMin string `description:"图表右侧最小值"`
  227. RightMax string `description:"图表右侧最大值"`
  228. Right2Min string `description:"图表右侧最小值"`
  229. Right2Max string `description:"图表右侧最大值"`
  230. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  231. BarChartInfo BarChartInfoReq `description:"柱方图的配置"`
  232. CorrelationChartInfo CorrelationChartInfoReq `description:"相关性图表配置"`
  233. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  234. SeasonExtraConfig SeasonExtraItem `description:"季节性图表中的配置,json数据"`
  235. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  236. ChartThemeId int `description:"图表应用主题ID"`
  237. SourcesFrom string `description:"图表来源"`
  238. Instructions string `description:"图表说明"`
  239. MarkersLines string `description:"标识线"`
  240. MarkersAreas string `description:"标识区"`
  241. Unit string `description:"中文单位名称"`
  242. UnitEn string `description:"英文单位名称"`
  243. ChartAlias string `description:"图表别名"`
  244. }
  245. type MarkersLine struct {
  246. Axis int `json:"axis" description:"1左轴 2右轴 3横轴"`
  247. AxisName string `json:"axisName" description:"轴的名称,例如'左轴'"`
  248. MarkerType string `json:"markerType" description:"标识线或标识区"`
  249. MarkLineType int `json:"markLineType" description:"1:固定 2:指标计算"`
  250. Value string `json:"value" description:"连线指向的数值,例如'4000'"`
  251. FromValue string `json:"fromValue" description:"连线的起始点,可以为空"`
  252. ToValue string `json:"toValue" description:"连线的结束点,可以为空"`
  253. LineWidth int `json:"lineWidth" description:"连线的宽度"`
  254. DashStyle string `json:"dashStyle" description:"连线的虚线样式,例如'ShortDashDot'"`
  255. Color string `json:"color" description:"连线的颜色"`
  256. Text string `json:"text" description:"连线旁边显示的文本"`
  257. TextPosition string `json:"textPosition" description:"文本的显示位置,例如'bottom'"`
  258. TextColor string `json:"textColor" description:"文本颜色"`
  259. TextFontSize int `json:"textFontSize" description:"文本的字号大小"`
  260. IsShow bool `json:"isShow" description:"是否显示连线及文本"`
  261. EdbType int `json:"edbType" description:"指标类型 0图中第一个指标 1其他指标 前端回显用"`
  262. EdbInfoId int `json:"edbInfoId" description:"指标id"`
  263. Calculation int `json:"calculation" description:"计算方式 1区间均值 2区间均值加N倍标准差 3区间个数分位 4区间数值分位"`
  264. CalculationValue int `json:"calculationValue" description:"计算方式对应的值 2就是几倍标准差 3就是分位值 4就是数值值·"`
  265. TimeIntervalType int `json:"timeInterval" description:"时间区间 0跟随图表 1自定义"`
  266. StartDate MarkersLineTime `json:"startTime" description:"开始时间"`
  267. EndDate MarkersLineTime `json:"endTime" description:"结束时间"`
  268. }
  269. type MarkersLineTime struct {
  270. TimeType int `json:"timeType" description:"时间类型 1固定 2动态 3至今(仅结束时间)"`
  271. Date string `json:"date" description:"日期"`
  272. Conf EdbDateChangeConf `json:"conf" description:"动态时间配置"`
  273. }
  274. // EdbDateExtraConf
  275. // @Description: 导入指标日期前移和日期变换
  276. type EdbDateChangeConf struct {
  277. MoveForward int `description:"前移的期数"`
  278. BaseDate int `description:"基准日期 0系统日期 1指标最新日期"`
  279. DateChange []*EdbDateConfDateChange
  280. }
  281. type EdbDateConfDateChange struct {
  282. Year int
  283. Month int
  284. Day int
  285. Frequency string `description:"频度变换"`
  286. FrequencyDay string `description:"频度的固定日期"`
  287. ChangeType int `description:"日期变换类型1日期位移,2指定频率"`
  288. }
  289. type EditFutureGoodChartInfoReq struct {
  290. EditChartInfoReq
  291. BarChartInfo FutureGoodBarChartInfoReq
  292. }
  293. type EditChartEnInfoReq struct {
  294. ChartInfoId int `description:"图表ID"`
  295. ChartNameEn string `description:"英文图表名称"`
  296. ChartEdbInfoList []*EditChartEnInfoEdbItem `description:"指标及配置信息"`
  297. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  298. ChartAlias string `description:"图表别名"`
  299. }
  300. type EditChartEnInfoEdbItem struct {
  301. EdbInfoId int `description:"指标ID"`
  302. EdbNameEn string `description:"英文指标名称"`
  303. UnitEn string `description:"英文单位"`
  304. }
  305. // EditChartInfoBaseReq
  306. // @Description: 图表基础信息修改
  307. type EditChartInfoBaseReq struct {
  308. ChartInfoId int `description:"图表ID"`
  309. ChartName string `description:"图表名称(根据语言版本区分)"`
  310. ChartEdbInfoList []*EditChartInfoEdbBaseItem `description:"指标及配置信息"`
  311. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  312. ChartAlias string `description:"图表别名"`
  313. }
  314. type EditChartInfoEdbBaseItem struct {
  315. EdbInfoId int `description:"指标ID"`
  316. EdbName string `description:"指标名称(根据语言版本区分)"`
  317. Unit string `description:"单位(根据语言版本区分)"`
  318. }
  319. func ModifyChartInfo(item *EditChartInfoReq) (err error) {
  320. o := orm.NewOrmUsingDB("data")
  321. sql := ` UPDATE chart_info
  322. SET
  323. chart_name =?,
  324. chart_classify_id = ?,
  325. is_set_name=1,
  326. modify_time = NOW()
  327. WHERE chart_info_id = ?`
  328. _, err = o.Raw(sql, item.ChartName, item.ChartClassifyId, item.ChartInfoId).Exec()
  329. return
  330. }
  331. func SetForumChartInfoId(chartInfoId, forumChartInfoId int) (err error) {
  332. o := orm.NewOrmUsingDB("data")
  333. sql := ` UPDATE chart_info
  334. SET
  335. forum_chart_info_id=?,
  336. modify_time = NOW()
  337. WHERE chart_info_id = ?`
  338. _, err = o.Raw(sql, forumChartInfoId, chartInfoId).Exec()
  339. return
  340. }
  341. type ChartInfoList struct {
  342. ChartInfoId int `orm:"column(chart_info_id);pk"`
  343. ChartName string `description:"来源名称"`
  344. ChartChartClassifyId int `description:"图表分类id"`
  345. SysUserId int
  346. SysUserRealName string
  347. UniqueCode string `description:"图表唯一编码"`
  348. CreateTime time.Time
  349. ModifyTime time.Time
  350. EdbInfoList []*EdbInfoList
  351. ChartAlias string `description:"图表别名"`
  352. }
  353. type ChartInfoListResp struct {
  354. Paging *paging.PagingItem
  355. Item *ChartInfoList
  356. }
  357. func GetChartInfoByCondition(condition string, pars []interface{}) (item *ChartInfo, err error) {
  358. o := orm.NewOrmUsingDB("data")
  359. sql := ` SELECT * FROM chart_info WHERE 1=1 `
  360. if condition != "" {
  361. sql += condition
  362. }
  363. err = o.Raw(sql, pars).QueryRow(&item)
  364. return
  365. }
  366. func GetChartInfoByNewest(source int) (item *ChartInfoList, err error) {
  367. o := orm.NewOrmUsingDB("data")
  368. sql := ` SELECT * FROM chart_info WHERE 1=1 AND source = ? ORDER BY modify_time DESC LIMIT 1 `
  369. err = o.Raw(sql, source).QueryRow(&item)
  370. return
  371. }
  372. func ModifyChartInfoModifyTime(chartInfoId int64) (err error) {
  373. o := orm.NewOrmUsingDB("data")
  374. sql := ` UPDATE chart_info SET modify_time = NOW() WHERE chart_info_id = ? `
  375. _, err = o.Raw(sql, chartInfoId).Exec()
  376. return
  377. }
  378. type MoveChartInfoReq struct {
  379. ChartInfoId int `description:"图表ID"`
  380. PrevChartInfoId int `description:"上一个图表ID"`
  381. NextChartInfoId int `description:"下一个图表ID"`
  382. ChartClassifyId int `description:"分类id"`
  383. }
  384. func MoveChartInfo(chartInfoId, classifyId int) (err error) {
  385. o := orm.NewOrmUsingDB("data")
  386. sql := ` UPDATE chart_info
  387. SET
  388. chart_classify_id = ?
  389. WHERE chart_info_id = ?`
  390. _, err = o.Raw(sql, classifyId, chartInfoId).Exec()
  391. return
  392. }
  393. type DeleteChartInfoReq struct {
  394. ChartInfoId int `description:"图表ID"`
  395. }
  396. type EdbDataList struct {
  397. EdbDataId int `description:" 指标数据ID"`
  398. EdbInfoId int `description:"指标ID"`
  399. DataTime string //`json:"-" description:"数据日期"`
  400. DataTimestamp int64 `description:"数据日期"`
  401. Value float64 `description:"数据值"`
  402. }
  403. // GetEdbDataList
  404. // @Description: 获取指标的数据(日期正序返回)
  405. // @author: Roc
  406. // @datetime 2024-05-07 10:48:43
  407. // @param source int
  408. // @param subSource int
  409. // @param edbInfoId int
  410. // @param startDate string
  411. // @param endDate string
  412. // @return list []*EdbDataList
  413. // @return err error
  414. func GetEdbDataList(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  415. // 自有数据需要额外处理(从mongo获取)
  416. if source == utils.DATA_SOURCE_BUSINESS && utils.UseMongo {
  417. return getEdbDataListByMongo(source, subSource, edbInfoId, startDate, endDate)
  418. }
  419. return getEdbDataListByMysql(source, subSource, edbInfoId, startDate, endDate)
  420. }
  421. // getEdbDataListByMysql
  422. // @Description: 通过mysql查询指标数据
  423. // @author: Roc
  424. // @datetime 2024-05-07 10:40:43
  425. // @param source int
  426. // @param subSource int
  427. // @param edbInfoId int
  428. // @param startDate string
  429. // @param endDate string
  430. // @return list []*EdbDataList
  431. // @return err error
  432. func getEdbDataListByMysql(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  433. tableName := GetEdbDataTableName(source, subSource)
  434. if tableName == "" {
  435. err = errors.New("无效的渠道:" + strconv.Itoa(source))
  436. list = make([]*EdbDataList, 0)
  437. return list, err
  438. }
  439. var pars []interface{}
  440. sql := `SELECT edb_data_id,edb_info_id,data_time,value,data_timestamp FROM %s WHERE edb_info_id=? `
  441. if startDate != "" {
  442. sql += ` AND data_time>=? `
  443. pars = append(pars, startDate)
  444. }
  445. if endDate != "" {
  446. sql += ` AND data_time<=? `
  447. pars = append(pars, endDate)
  448. }
  449. sql += ` ORDER BY data_time ASC `
  450. sql = fmt.Sprintf(sql, tableName)
  451. o := orm.NewOrmUsingDB("data")
  452. _, err = o.Raw(sql, edbInfoId, pars).QueryRows(&list)
  453. return
  454. }
  455. // getEdbDataListByMongo
  456. // @Description: 通过mongo查询指标数据
  457. // @author: Roc
  458. // @datetime 2024-05-07 10:40:43
  459. // @param source int
  460. // @param subSource int
  461. // @param endInfoId int
  462. // @param startDate string
  463. // @param endDate string
  464. // @return list []*EdbDataList
  465. // @return err error
  466. func getEdbDataListByMongo(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  467. list = make([]*EdbDataList, 0)
  468. mogDataObj := mgo.EdbDataBusiness{}
  469. // 构建查询条件
  470. queryConditions := bson.M{
  471. "edb_info_id": edbInfoId,
  472. }
  473. // 数据日期
  474. dateCondition, err := mgo.BuildDateCondition(startDate, endDate)
  475. if err != nil {
  476. return
  477. }
  478. if len(dateCondition) > 0 {
  479. queryConditions["data_time"] = dateCondition
  480. }
  481. // 获取列表数据
  482. tmpDataList, tmpErr := mogDataObj.GetAllDataList(queryConditions, []string{"data_time"})
  483. if tmpErr != nil {
  484. err = tmpErr
  485. return
  486. }
  487. for k, v := range tmpDataList {
  488. list = append(list, &EdbDataList{
  489. EdbDataId: k + 1,
  490. EdbInfoId: v.EdbInfoId,
  491. DataTime: v.DataTime.Format(utils.FormatDate),
  492. DataTimestamp: v.DataTimestamp,
  493. Value: v.Value,
  494. })
  495. }
  496. return
  497. }
  498. type EdbDataListByUniqueCode struct {
  499. EdbDataId int `description:" 指标数据ID" json:"-"`
  500. EdbInfoId int `description:"指标ID" json:"-"`
  501. DataTime string //`json:"-" description:"数据日期"`
  502. DataTimestamp int64 `description:"数据日期"`
  503. Value float64 `description:"数据值"`
  504. }
  505. func GetEdbDataLunarList(endInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  506. tableName := "edb_data_quarter"
  507. sql := `SELECT edb_data_id,edb_info_id,data_time,TRUNCATE(value,2) AS value,data_timestamp FROM %s WHERE edb_info_id=? AND data_time>=? AND data_time<=? ORDER BY data_time ASC `
  508. sql = fmt.Sprintf(sql, tableName)
  509. o := orm.NewOrmUsingDB("data")
  510. _, err = o.Raw(sql, endInfoId, startDate, endDate).QueryRows(&list)
  511. return
  512. }
  513. // GetEdbDataListMinAndMax
  514. // @Description: 根据条件数据库中获取指标数据最小值和最大值
  515. // @author: Roc
  516. // @datetime 2024-05-07 13:11:32
  517. // @param source int
  518. // @param subSource int
  519. // @param edbInfoId int
  520. // @param startDate string
  521. // @param endDate string
  522. // @return min_data float64
  523. // @return max_data float64
  524. // @return err error
  525. func GetEdbDataListMinAndMax(source, subSource, edbInfoId int, startDate, endDate string) (min_data, max_data float64, err error) {
  526. // 自有数据需要额外处理(从mongo获取)
  527. if source == utils.DATA_SOURCE_BUSINESS && utils.UseMongo {
  528. return getEdbDataListMinAndMaxByMongo(source, subSource, edbInfoId, startDate, endDate)
  529. }
  530. return getEdbDataListMinAndMaxByMysql(source, subSource, edbInfoId, startDate, endDate)
  531. }
  532. // getEdbDataListMinAndMaxByMysql
  533. // @Description: 根据条件从mysql数据库中获取指标数据最小值和最大值
  534. // @author: Roc
  535. // @datetime 2024-05-07 13:11:22
  536. // @param source int
  537. // @param subSource int
  538. // @param edbInfoId int
  539. // @param startDate string
  540. // @param endDate string
  541. // @return minData float64
  542. // @return maxData float64
  543. // @return err error
  544. func getEdbDataListMinAndMaxByMysql(source, subSource, edbInfoId int, startDate, endDate string) (minData, maxData float64, err error) {
  545. tableName := GetEdbDataTableName(source, subSource)
  546. sql := `SELECT min(value) AS min_data,max(value) AS max_data FROM %s WHERE edb_info_id=? `
  547. var pars []interface{}
  548. var condition string
  549. if startDate != "" {
  550. condition += ` AND data_time>=? `
  551. pars = append(pars, startDate)
  552. }
  553. if endDate != "" {
  554. condition += ` AND data_time<=? `
  555. pars = append(pars, endDate)
  556. }
  557. sql = fmt.Sprintf(sql, tableName)
  558. o := orm.NewOrmUsingDB("data")
  559. if condition != "" {
  560. sql += condition
  561. }
  562. err = o.Raw(sql, edbInfoId, pars).QueryRow(&minData, &maxData)
  563. return
  564. }
  565. // getEdbDataListMinAndMaxByMongo
  566. // @Description: 根据条件从mongo数据库中获取指标数据最小值和最大值
  567. // @author: Roc
  568. // @datetime 2024-05-07 13:10:26
  569. // @param source int
  570. // @param subSource int
  571. // @param edbInfoId int
  572. // @param startDate string
  573. // @param endDate string
  574. // @return minData float64
  575. // @return maxData float64
  576. // @return err error
  577. func getEdbDataListMinAndMaxByMongo(source, subSource, edbInfoId int, startDate, endDate string) (minData, maxData float64, err error) {
  578. mogDataObj := mgo.EdbDataBusiness{}
  579. // 构建查询条件
  580. queryConditions := bson.M{
  581. "edb_info_id": edbInfoId,
  582. }
  583. // 日期
  584. dateCondition, err := mgo.BuildDateCondition(startDate, endDate)
  585. if err != nil {
  586. return
  587. }
  588. if len(dateCondition) > 0 {
  589. queryConditions["data_time"] = dateCondition
  590. }
  591. pipeline := []bson.M{
  592. {"$match": queryConditions},
  593. {"$group": bson.M{
  594. "_id": nil,
  595. "min_value": bson.M{"$min": "$value"},
  596. "max_value": bson.M{"$max": "$value"},
  597. }},
  598. {"$project": bson.M{"_id": 0}}, // 可选,如果不需要_id字段
  599. }
  600. result, err := mogDataObj.GetEdbInfoMaxAndMinInfo(pipeline)
  601. if err != nil {
  602. return
  603. }
  604. minData = result.MinValue
  605. maxData = result.MaxValue
  606. return
  607. }
  608. type ChartEdbInfoMapping struct {
  609. EdbInfoId int `description:"指标id"`
  610. SourceName string `description:"来源名称"`
  611. Source int `description:"来源id"`
  612. SubSource int `description:"来源id"`
  613. EdbCode string `description:"指标编码"`
  614. EdbName string `description:"指标名称"`
  615. EdbAliasName string `description:"指标名称(别名)"`
  616. EdbNameEn string `description:"英文指标名称"`
  617. EdbAliasNameEn string `description:"英文指标名称(别名)"`
  618. EdbType int `description:"指标类型:1:基础指标,2:计算指标"`
  619. Frequency string `description:"频率"`
  620. FrequencyEn string `description:"英文频率"`
  621. Unit string `description:"单位"`
  622. UnitEn string `description:"英文单位"`
  623. StartDate string `description:"起始日期"`
  624. EndDate string `description:"终止日期"`
  625. ModifyTime string `description:"指标最后更新时间"`
  626. ChartEdbMappingId int `description:"图表指标id"`
  627. ChartInfoId int `description:"图表id"`
  628. MaxData float64 `description:"上限"`
  629. MinData float64 `description:"下限"`
  630. IsOrder bool `description:"true:正序,false:逆序"`
  631. IsAxis int `description:"1:左轴,0:右轴"`
  632. EdbInfoType int `description:"1:标准指标,0:领先指标"`
  633. EdbInfoCategoryType int `description:"0:普通指标,1:预测指标"`
  634. LeadValue int `description:"领先值"`
  635. LeadUnit string `description:"领先单位"`
  636. LeadUnitEn string `description:"领先英文单位"`
  637. ChartStyle string `description:"图表类型"`
  638. ChartColor string `description:"颜色"`
  639. PredictChartColor string `description:"预测数据的颜色"`
  640. ChartWidth float64 `description:"线条大小"`
  641. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图,7:柱方图,8:商品价格曲线图,9:相关性图"`
  642. LatestDate string `description:"数据最新日期"`
  643. LatestValue float64 `description:"数据最新值"`
  644. MoveLatestDate string `description:"移动后的数据最新日期"`
  645. UniqueCode string `description:"指标唯一编码"`
  646. MinValue float64 `json:"-" description:"最小值"`
  647. MaxValue float64 `json:"-" description:"最大值"`
  648. DataList interface{}
  649. IsNullData bool `json:"-" description:"是否空数据"`
  650. MappingSource int `description:"1:ETA图库;2:商品价格曲线"`
  651. RegionType string `description:"交易所来源,海外还是国内" json:"-"`
  652. ClassifyId int `description:"分类id"`
  653. SubSourceName string `description:"子数据来源名称"`
  654. IndicatorCode string `description:"指标代码"`
  655. IsConvert int `description:"是否数据转换 0不转 1转"`
  656. ConvertType int `description:"数据转换类型 1乘 2除 3对数"`
  657. ConvertValue float64 `description:"数据转换值"`
  658. ConvertUnit string `description:"数据转换单位"`
  659. ConvertEnUnit string `description:"数据转换单位"`
  660. IsJoinPermission int `description:"是否加入权限管控,0:不加入;1:加入;默认:0"`
  661. HaveOperaAuth bool `description:"是否有数据权限,默认:false"`
  662. }
  663. type QuarterData struct {
  664. Year int
  665. DataList []*EdbDataList
  666. CuttingDataTimestamp int64 `description:"切割的时间戳"`
  667. ChartLegend string
  668. Years string
  669. }
  670. type QuarterXDateItem struct {
  671. StartDate time.Time
  672. EndDate time.Time
  673. ShowName string
  674. ChartLegend string
  675. CuttingDataTimestamp int64 `description:"切割的时间戳"`
  676. }
  677. type QuarterDataByUniqueCode struct {
  678. Year int
  679. DataList []*EdbDataListByUniqueCode
  680. }
  681. type ChartEdbInfoDetailResp struct {
  682. EdbInfo *ChartEdbInfoMapping
  683. }
  684. type ChartInfoDetailResp struct {
  685. ChartInfo *ChartInfoView
  686. EdbInfoList []*ChartEdbInfoMapping
  687. XEdbIdValue []int `description:"柱方图的x轴数据,指标id"`
  688. YDataList []YData `description:"柱方图的y轴数据"`
  689. XDataList []XData `description:"商品价格曲线的X轴数据"`
  690. BarChartInfo BarChartInfoReq `description:"柱方图的配置"`
  691. CorrelationChartInfo *CorrelationInfo `description:"相关性图表信息"`
  692. DataResp interface{} `description:"图表数据,根据图的类型而定的,没有确定的数据格式"`
  693. ClassifyLevels []string `description:"图表分类的UniqueCode-从最顶级到当前分类(给前端回显定位用的=_=!)"`
  694. }
  695. type FutureGoodChartInfoDetailResp struct {
  696. ChartInfo *ChartInfoView
  697. EdbInfoList []*ChartEdbInfoMapping
  698. XEdbIdValue []int `description:"柱方图的x轴数据,指标id"`
  699. YDataList []YData `description:"柱方图的y轴数据"`
  700. XDataList []XData `description:"商品价格曲线的X轴数据"`
  701. BarChartInfo FutureGoodBarChartInfoReq `description:"柱方图的配置"`
  702. CorrelationChartInfo *CorrelationInfo `description:"相关性图表信息"`
  703. DataResp interface{} `description:"图表数据,根据图的类型而定的,没有确定的数据格式"`
  704. }
  705. type BalanceTableChartListResp struct {
  706. List []*BalanceChartInfoDetailResp
  707. }
  708. type BalanceChartInfoDetailResp struct {
  709. *ChartInfoDetailResp
  710. ExcelEdbList []*ExcelChartEdbView
  711. }
  712. type ExcelChartEdbView struct {
  713. ExcelChartEdbId int
  714. DateSequenceStr string `description:"日期序列选区"`
  715. DataSequenceStr string `description:"数据序列选区"`
  716. FromTag string `description:"标签"`
  717. }
  718. // XData 商品价格曲线的的x轴数据
  719. type XData struct {
  720. Name string `description:"别名"`
  721. NameEn string `description:"英文别名"`
  722. IsHide int `description:"是否隐藏,0不隐藏,1隐藏"`
  723. }
  724. // YData 柱方图的y轴数据
  725. type YData struct {
  726. Date string `description:"数据日期"`
  727. ConfigDate time.Time `description:"配置的日期" json:"-"`
  728. Color string `description:"数据颜色"`
  729. Name string `description:"别名"`
  730. NameEn string `description:"英文别名"`
  731. Value []float64 `description:"每个指标的值"`
  732. NoDataEdbList []int `description:"没有数据的指标列表"`
  733. XEdbInfoIdList []int `description:"对应X轴的指标id列表"`
  734. NameList []string `description:"每个值对应的名称"`
  735. EnNameList []string `description:"每个值对应的英文名称"`
  736. EdbValMap map[int]float64 `description:"指标与值的对应" json:"-"`
  737. M []int `description:"对应开始日期的间隔值" json:"-"`
  738. Unit string `description:"中文单位名称"`
  739. UnitEn string `description:"英文单位名称"`
  740. SeriesEdb struct {
  741. SeriesId int `description:"因子指标系列ID"`
  742. EdbInfoId int `description:"指标ID"`
  743. } `description:"对应的系列指标"`
  744. }
  745. func ModifyChartInfoAndMapping(edbInfoIdStr string, req *SaveChartInfoReq, chartType int) (err error) {
  746. o := orm.NewOrmUsingDB("data")
  747. to, err := o.Begin()
  748. if err != nil {
  749. return
  750. }
  751. defer func() {
  752. if err != nil {
  753. _ = to.Rollback()
  754. } else {
  755. _ = to.Commit()
  756. }
  757. }()
  758. //非季节图
  759. if chartType != 2 {
  760. updateStr := `edb_info_ids=?,
  761. modify_time = NOW(),
  762. date_type=?,
  763. start_date=?,
  764. end_date=?,
  765. left_min=?,
  766. left_max=?,
  767. right_min=?,
  768. right_max=?,
  769. right2_min=?,
  770. right2_max=?,
  771. min_max_save=?,
  772. start_year=?`
  773. pars := []interface{}{edbInfoIdStr, req.DateType, req.StartDate, req.EndDate, req.LeftMin, req.LeftMax, req.RightMin, req.RightMax, req.Right2Min, req.Right2Max, req.MinMaxSave, req.StartYear}
  774. if req.ExtraConfig != `` {
  775. updateStr += `,extra_config=? `
  776. pars = append(pars, req.ExtraConfig)
  777. }
  778. pars = append(pars, req.ChartInfoId)
  779. sql := ` UPDATE chart_info SET ` + updateStr + ` WHERE chart_info_id = ?`
  780. _, err = to.Raw(sql, pars).Exec()
  781. if err != nil {
  782. fmt.Println("UPDATE chart_info Err:", err.Error())
  783. return err
  784. }
  785. } else {
  786. sql := ` UPDATE chart_info
  787. SET
  788. edb_info_ids=?,
  789. modify_time = NOW(),
  790. calendar=?,
  791. date_type=?,
  792. start_date=?,
  793. end_date=?,
  794. season_start_date=?,
  795. season_end_date=?,
  796. left_min=?,
  797. left_max=?,
  798. right_min=?,
  799. right_max=?,
  800. right2_min=?,
  801. right2_max=?,
  802. min_max_save=?,
  803. start_year=?
  804. WHERE chart_info_id = ?`
  805. _, err = to.Raw(sql, edbInfoIdStr, req.Calendar, req.DateType, req.StartDate, req.EndDate, req.StartDate, req.EndDate, req.LeftMin, req.LeftMax, req.RightMin, req.RightMax, req.Right2Min, req.Right2Max, req.MinMaxSave, req.StartYear, req.ChartInfoId).Exec()
  806. if err != nil {
  807. fmt.Println("UPDATE chart_info Err:", err.Error())
  808. return err
  809. }
  810. }
  811. var edbInfoIdArr []string
  812. mapList := make([]*ChartEdbMapping, 0)
  813. for _, v := range req.ChartEdbInfoList {
  814. edbInfoIdArr = append(edbInfoIdArr, strconv.Itoa(v.EdbInfoId))
  815. var count int
  816. csql := `SELECT COUNT(1) AS count FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id=? `
  817. err = to.Raw(csql, req.ChartInfoId, v.EdbInfoId).QueryRow(&count)
  818. if err != nil {
  819. fmt.Println("QueryRow Err:", err.Error())
  820. return err
  821. }
  822. if count > 0 {
  823. msql := `UPDATE chart_edb_mapping
  824. SET
  825. modify_time = NOW(),
  826. max_data = ?,
  827. min_data = ?,
  828. is_order = ?,
  829. is_axis = ?,
  830. edb_info_type = ?,
  831. lead_value = ?,
  832. lead_unit = ?,
  833. chart_style = ?,
  834. chart_color = ?,
  835. predict_chart_color = ?,
  836. chart_width = ?
  837. WHERE chart_info_id =? AND edb_info_id=? `
  838. _, err = to.Raw(msql, v.MaxData, v.MinData, v.IsOrder, v.IsAxis, v.EdbInfoType, v.LeadValue, v.LeadUnit, v.ChartStyle, v.ChartColor, v.PredictChartColor, v.ChartWidth, req.ChartInfoId, v.EdbInfoId).Exec()
  839. if err != nil {
  840. fmt.Println("chart_edb_mapping Err:" + err.Error())
  841. return err
  842. }
  843. } else {
  844. mapItem := new(ChartEdbMapping)
  845. mapItem.ChartInfoId = req.ChartInfoId
  846. mapItem.EdbInfoId = v.EdbInfoId
  847. mapItem.CreateTime = time.Now()
  848. mapItem.ModifyTime = time.Now()
  849. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  850. mapItem.UniqueCode = utils.MD5(utils.CHART_PREFIX + "_" + timestamp)
  851. mapItem.MaxData = v.MaxData
  852. mapItem.MinData = v.MinData
  853. mapItem.IsOrder = v.IsOrder
  854. mapItem.IsAxis = v.IsAxis
  855. mapItem.EdbInfoType = v.EdbInfoType
  856. mapItem.LeadValue = v.LeadValue
  857. mapItem.LeadUnit = v.LeadUnit
  858. mapItem.ChartStyle = v.ChartStyle
  859. mapItem.ChartColor = v.ChartColor
  860. mapItem.PredictChartColor = v.PredictChartColor
  861. mapItem.ChartWidth = v.ChartWidth
  862. mapList = append(mapList, mapItem)
  863. }
  864. }
  865. if len(mapList) > 0 {
  866. _, err = to.InsertMulti(1, mapList)
  867. if err != nil {
  868. fmt.Println("AddChartEdbMapping Err:" + err.Error())
  869. return err
  870. }
  871. }
  872. if len(edbInfoIdArr) > 0 {
  873. edbInfoIdStr := strings.Join(edbInfoIdArr, ",")
  874. if edbInfoIdStr != "" {
  875. dsql := `DELETE FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id NOT IN(` + edbInfoIdStr + `)`
  876. _, err = to.Raw(dsql, req.ChartInfoId).Exec()
  877. if err != nil {
  878. fmt.Println("delete err:" + err.Error())
  879. return err
  880. }
  881. }
  882. }
  883. return
  884. }
  885. // EditChartInfoAndMapping 修改 ETA图库 的 图表与指标 的关系
  886. func EditChartInfoAndMapping(req *EditChartInfoReq, edbInfoIdStr string, calendar string, dateType, disabled int, barChartConf string, chartEdbInfoList []*ChartSaveItem, seasonExtra string) (err error) {
  887. o := orm.NewOrmUsingDB("data")
  888. to, err := o.Begin()
  889. if err != nil {
  890. return
  891. }
  892. defer func() {
  893. if err != nil {
  894. _ = to.Rollback()
  895. } else {
  896. _ = to.Commit()
  897. }
  898. }()
  899. var pars []interface{}
  900. pars = append(pars, req.ChartName)
  901. pars = append(pars, req.ChartNameEn)
  902. pars = append(pars, edbInfoIdStr)
  903. pars = append(pars, req.ChartType)
  904. pars = append(pars, req.ChartClassifyId)
  905. pars = append(pars, disabled)
  906. pars = append(pars, barChartConf)
  907. pars = append(pars, req.ExtraConfig)
  908. pars = append(pars, seasonExtra)
  909. pars = append(pars, req.StartYear)
  910. pars = append(pars, req.ChartThemeId)
  911. pars = append(pars, req.SourcesFrom)
  912. pars = append(pars, req.Instructions)
  913. pars = append(pars, req.MarkersLines)
  914. pars = append(pars, req.MarkersAreas)
  915. pars = append(pars, req.Unit)
  916. pars = append(pars, req.UnitEn)
  917. sql := ` UPDATE chart_info
  918. SET
  919. chart_name =?,
  920. chart_name_en =?,
  921. edb_info_ids=?,
  922. chart_type=?,
  923. chart_classify_id = ?,
  924. modify_time = NOW(),
  925. disabled = ?,
  926. bar_config = ?,
  927. extra_config = ?,
  928. season_extra_config = ?,
  929. start_year = ?,
  930. chart_theme_id = ?,
  931. sources_from = ?,
  932. instructions = ?,
  933. markers_lines = ?,
  934. markers_areas = ?,
  935. unit = ?,
  936. unit_en = ?
  937. `
  938. if calendar != "" {
  939. sql += `,calendar = ? `
  940. pars = append(pars, calendar)
  941. }
  942. if dateType > 0 {
  943. sql += `,date_type = ? `
  944. pars = append(pars, dateType)
  945. }
  946. sql += `,start_date = ? `
  947. pars = append(pars, req.StartDate)
  948. sql += `,end_date = ? `
  949. pars = append(pars, req.EndDate)
  950. sql += `,season_start_date = ? `
  951. pars = append(pars, req.StartDate)
  952. sql += `,season_end_date = ? `
  953. pars = append(pars, req.EndDate)
  954. sql += `,left_min = ? `
  955. pars = append(pars, req.LeftMin)
  956. sql += `,left_max = ? `
  957. pars = append(pars, req.LeftMax)
  958. sql += `,right_min = ? `
  959. pars = append(pars, req.RightMin)
  960. sql += `,right_max = ? `
  961. pars = append(pars, req.RightMax)
  962. sql += `,right2_min = ? `
  963. pars = append(pars, req.Right2Min)
  964. sql += `,right2_max = ? `
  965. pars = append(pars, req.Right2Max)
  966. sql += `,min_max_save = ? `
  967. pars = append(pars, req.MinMaxSave)
  968. sql += `,chart_alias = ? `
  969. pars = append(pars, req.ChartAlias)
  970. sql += `WHERE chart_info_id = ?`
  971. pars = append(pars, req.ChartInfoId)
  972. _, err = to.Raw(sql, pars).Exec()
  973. if err != nil {
  974. fmt.Println("UPDATE chart_info Err:", err.Error())
  975. return err
  976. }
  977. chartEdbMappingIdList := make([]string, 0)
  978. // 获取已经配置的关联指标列表
  979. var tmpChartEdbMappingList []*ChartEdbMapping
  980. csql := `SELECT * FROM chart_edb_mapping WHERE chart_info_id=? AND source = ? ORDER BY chart_edb_mapping_id ASC`
  981. _, err = to.Raw(csql, req.ChartInfoId, utils.CHART_SOURCE_DEFAULT).QueryRows(&tmpChartEdbMappingList)
  982. if err != nil {
  983. fmt.Println("获取已经配置的关联指标列表 Err:", err.Error())
  984. return err
  985. }
  986. // 已经配置的关联指标列表长度下标
  987. tmpEdbIndex := len(tmpChartEdbMappingList) - 1
  988. // 当下要配置的关联指标列表长度下标
  989. reqEdbIndex := len(chartEdbInfoList) - 1
  990. addChartEdbList := make([]*ChartEdbMapping, 0)
  991. removeIdList := make([]int, 0)
  992. for k, v := range chartEdbInfoList {
  993. // 如果当前下标小于等于已经配置的关联指标的最大长度,那么就校验
  994. if k <= tmpEdbIndex {
  995. tmpChartEdbMapping := tmpChartEdbMappingList[k]
  996. // 顺序未变
  997. if tmpChartEdbMapping.EdbInfoId == v.EdbInfoId {
  998. chartEdbMappingIdList = append(chartEdbMappingIdList, strconv.Itoa(tmpChartEdbMapping.ChartEdbMappingId))
  999. tmpChartEdbMapping.ModifyTime = time.Now()
  1000. tmpChartEdbMapping.MaxData = v.MaxData
  1001. tmpChartEdbMapping.MinData = v.MinData
  1002. tmpChartEdbMapping.IsOrder = v.IsOrder
  1003. tmpChartEdbMapping.IsAxis = v.IsAxis
  1004. tmpChartEdbMapping.EdbInfoType = v.EdbInfoType
  1005. tmpChartEdbMapping.LeadValue = v.LeadValue
  1006. tmpChartEdbMapping.LeadUnit = v.LeadUnit
  1007. tmpChartEdbMapping.ChartStyle = v.ChartStyle
  1008. tmpChartEdbMapping.ChartColor = v.ChartColor
  1009. tmpChartEdbMapping.PredictChartColor = v.PredictChartColor
  1010. tmpChartEdbMapping.ChartWidth = v.ChartWidth
  1011. tmpChartEdbMapping.EdbAliasName = v.EdbAliasName
  1012. tmpChartEdbMapping.IsConvert = v.IsConvert
  1013. tmpChartEdbMapping.ConvertType = v.ConvertType
  1014. tmpChartEdbMapping.ConvertValue = v.ConvertValue
  1015. tmpChartEdbMapping.ConvertUnit = v.ConvertUnit
  1016. tmpChartEdbMapping.ConvertEnUnit = v.ConvertEnUnit
  1017. _, err = to.Update(tmpChartEdbMapping, "ModifyTime", "MaxData", "MinData", "IsOrder", "IsAxis", "EdbInfoType", "LeadValue", "LeadUnit", "ChartStyle", "ChartColor", "PredictChartColor", "ChartWidth", "EdbAliasName",
  1018. "IsConvert", "ConvertType", "ConvertValue", "ConvertUnit", "ConvertEnUnit")
  1019. if err != nil {
  1020. fmt.Println("chart_edb_mapping Err:" + err.Error())
  1021. return err
  1022. }
  1023. continue
  1024. } else {
  1025. // 如果是指标的顺序变了,那么需要删除该配置,进行新的配置
  1026. removeIdList = append(removeIdList, tmpChartEdbMapping.ChartEdbMappingId)
  1027. }
  1028. }
  1029. // 如果是指标的顺序变了 或者
  1030. // 如果当前下标是超过了已经配置的关联指标的最大长度,那么就新增
  1031. mapItem := new(ChartEdbMapping)
  1032. mapItem.ChartInfoId = req.ChartInfoId
  1033. mapItem.EdbInfoId = v.EdbInfoId
  1034. mapItem.CreateTime = time.Now()
  1035. mapItem.ModifyTime = time.Now()
  1036. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  1037. mapItem.UniqueCode = utils.MD5(utils.CHART_PREFIX + "_" + timestamp + "_" + strconv.Itoa(v.EdbInfoId))
  1038. mapItem.MaxData = v.MaxData
  1039. mapItem.MinData = v.MinData
  1040. mapItem.IsOrder = v.IsOrder
  1041. mapItem.IsAxis = v.IsAxis
  1042. mapItem.EdbInfoType = v.EdbInfoType
  1043. mapItem.LeadValue = v.LeadValue
  1044. mapItem.LeadUnit = v.LeadUnit
  1045. mapItem.ChartStyle = v.ChartStyle
  1046. mapItem.ChartColor = v.ChartColor
  1047. mapItem.PredictChartColor = v.PredictChartColor
  1048. mapItem.ChartWidth = v.ChartWidth
  1049. mapItem.Source = utils.CHART_SOURCE_DEFAULT
  1050. mapItem.EdbAliasName = v.EdbAliasName
  1051. mapItem.IsConvert = v.IsConvert
  1052. mapItem.ConvertType = v.ConvertType
  1053. mapItem.ConvertValue = v.ConvertValue
  1054. mapItem.ConvertUnit = v.ConvertUnit
  1055. mapItem.ConvertEnUnit = v.ConvertEnUnit
  1056. addChartEdbList = append(addChartEdbList, mapItem)
  1057. }
  1058. // 当前保存的指标数与已有的指标数不一致,需要删除已有的指标关联配置
  1059. if reqEdbIndex < tmpEdbIndex {
  1060. for i := reqEdbIndex + 1; i <= tmpEdbIndex; i++ {
  1061. removeIdList = append(removeIdList, tmpChartEdbMappingList[i].ChartEdbMappingId)
  1062. }
  1063. }
  1064. // 删除已经移除了的指标关联配置
  1065. removeNum := len(removeIdList)
  1066. if removeNum > 0 {
  1067. dsql := `DELETE FROM chart_edb_mapping WHERE chart_info_id=? AND chart_edb_mapping_id IN(` + utils.GetOrmInReplace(removeNum) + `)`
  1068. _, err = to.Raw(dsql, req.ChartInfoId, removeIdList).Exec()
  1069. if err != nil {
  1070. fmt.Println("delete err:" + err.Error())
  1071. return err
  1072. }
  1073. }
  1074. // 将新的指标关联配置写入
  1075. if len(addChartEdbList) > 0 {
  1076. _, err = to.InsertMulti(500, addChartEdbList)
  1077. }
  1078. return
  1079. }
  1080. // EditFutureGoodChartInfoAndMapping 修改商品价格曲线的 图表与指标 的关系
  1081. func EditFutureGoodChartInfoAndMapping(req *EditFutureGoodChartInfoReq, edbInfoIdStr string, calendar string, dateType, disabled int, barChartConf string) (err error) {
  1082. o := orm.NewOrmUsingDB("data")
  1083. to, err := o.Begin()
  1084. if err != nil {
  1085. return
  1086. }
  1087. defer func() {
  1088. if err != nil {
  1089. _ = to.Rollback()
  1090. } else {
  1091. _ = to.Commit()
  1092. }
  1093. }()
  1094. var pars []interface{}
  1095. pars = append(pars, req.ChartName)
  1096. pars = append(pars, edbInfoIdStr)
  1097. pars = append(pars, req.ChartType)
  1098. pars = append(pars, req.ChartClassifyId)
  1099. pars = append(pars, disabled)
  1100. pars = append(pars, barChartConf)
  1101. sql := ` UPDATE chart_info
  1102. SET
  1103. chart_name =?,
  1104. edb_info_ids=?,
  1105. chart_type=?,
  1106. chart_classify_id = ?,
  1107. modify_time = NOW(),
  1108. disabled = ?,
  1109. bar_config = ?
  1110. `
  1111. if calendar != "" {
  1112. sql += `,calendar = ? `
  1113. pars = append(pars, calendar)
  1114. }
  1115. if dateType > 0 {
  1116. sql += `,date_type = ? `
  1117. pars = append(pars, dateType)
  1118. }
  1119. sql += `,start_date = ? `
  1120. pars = append(pars, req.StartDate)
  1121. sql += `,end_date = ? `
  1122. pars = append(pars, req.EndDate)
  1123. sql += `,season_start_date = ? `
  1124. pars = append(pars, req.StartDate)
  1125. sql += `,season_end_date = ? `
  1126. pars = append(pars, req.EndDate)
  1127. sql += `,left_min = ? `
  1128. pars = append(pars, req.LeftMin)
  1129. sql += `,left_max = ? `
  1130. pars = append(pars, req.LeftMax)
  1131. sql += `,right_min = ? `
  1132. pars = append(pars, req.RightMin)
  1133. sql += `,right_max = ? `
  1134. pars = append(pars, req.RightMax)
  1135. sql += `,right2_min = ? `
  1136. pars = append(pars, req.Right2Min)
  1137. sql += `,right2_max = ? `
  1138. pars = append(pars, req.Right2Max)
  1139. sql += `WHERE chart_info_id = ?`
  1140. pars = append(pars, req.ChartInfoId)
  1141. _, err = to.Raw(sql, pars).Exec()
  1142. if err != nil {
  1143. fmt.Println("UPDATE chart_info Err:", err.Error())
  1144. return err
  1145. }
  1146. chartEdbMappingIdList := make([]string, 0)
  1147. for _, v := range req.BarChartInfo.EdbInfoIdList {
  1148. // 查询该指标是否存在,如果存在的话,那么就去修改,否则新增
  1149. var tmpChartEdbMapping *ChartEdbMapping
  1150. csql := `SELECT * FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id=? AND source = ? `
  1151. err = to.Raw(csql, req.ChartInfoId, v.EdbInfoId, v.Source).QueryRow(&tmpChartEdbMapping)
  1152. if err != nil && err.Error() != utils.ErrNoRow() {
  1153. fmt.Println("QueryRow Err:", err.Error())
  1154. return err
  1155. }
  1156. if tmpChartEdbMapping != nil {
  1157. chartEdbMappingIdList = append(chartEdbMappingIdList, strconv.Itoa(tmpChartEdbMapping.ChartEdbMappingId))
  1158. //tmpChartEdbMapping.ModifyTime = time.Now()
  1159. //tmpChartEdbMapping.MaxData = v.MaxData
  1160. //tmpChartEdbMapping.MinData = v.MinData
  1161. //tmpChartEdbMapping.IsOrder = v.IsOrder
  1162. //tmpChartEdbMapping.IsAxis = v.IsAxis
  1163. //tmpChartEdbMapping.EdbInfoType = v.EdbInfoType
  1164. //tmpChartEdbMapping.LeadValue = v.LeadValue
  1165. //tmpChartEdbMapping.LeadUnit = v.LeadUnit
  1166. //tmpChartEdbMapping.ChartStyle = v.ChartStyle
  1167. //tmpChartEdbMapping.ChartColor = v.ChartColor
  1168. //tmpChartEdbMapping.PredictChartColor = v.PredictChartColor
  1169. //tmpChartEdbMapping.ChartWidth = v.ChartWidth
  1170. //_, err = to.Update(tmpChartEdbMapping, "ModifyTime", "MaxData", "MinData", "IsOrder", "IsAxis", "EdbInfoType", "LeadValue", "LeadUnit", "ChartStyle", "ChartColor", "PredictChartColor", "ChartWidth")
  1171. //if err != nil {
  1172. // fmt.Println("chart_edb_mapping Err:" + err.Error())
  1173. // return err
  1174. //}
  1175. } else {
  1176. mapItem := new(ChartEdbMapping)
  1177. mapItem.ChartInfoId = req.ChartInfoId
  1178. mapItem.EdbInfoId = v.EdbInfoId
  1179. mapItem.CreateTime = time.Now()
  1180. mapItem.ModifyTime = time.Now()
  1181. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  1182. mapItem.UniqueCode = utils.MD5(utils.CHART_PREFIX + "_" + timestamp + "_" + strconv.Itoa(v.EdbInfoId))
  1183. //mapItem.MaxData = v.MaxData
  1184. //mapItem.MinData = v.MinData
  1185. mapItem.IsOrder = true
  1186. mapItem.IsAxis = 1
  1187. mapItem.EdbInfoType = 1
  1188. //mapItem.LeadValue = v.LeadValue
  1189. //mapItem.LeadUnit = v.LeadUnit
  1190. //mapItem.ChartStyle = v.ChartStyle
  1191. //mapItem.ChartColor = v.ChartColor
  1192. //mapItem.PredictChartColor = v.PredictChartColor
  1193. //mapItem.ChartWidth = v.ChartWidth
  1194. mapItem.Source = v.Source
  1195. tmpId, err := to.Insert(mapItem)
  1196. if err != nil {
  1197. fmt.Println("AddChartEdbMapping Err:" + err.Error())
  1198. return err
  1199. }
  1200. mapItem.ChartEdbMappingId = int(tmpId)
  1201. chartEdbMappingIdList = append(chartEdbMappingIdList, strconv.Itoa(mapItem.ChartEdbMappingId))
  1202. }
  1203. }
  1204. if len(chartEdbMappingIdList) > 0 {
  1205. chartEdbMappingIdStr := strings.Join(chartEdbMappingIdList, ",")
  1206. dsql := `DELETE FROM chart_edb_mapping WHERE chart_info_id=? AND chart_edb_mapping_id NOT IN(` + chartEdbMappingIdStr + `)`
  1207. _, err = to.Raw(dsql, req.ChartInfoId).Exec()
  1208. if err != nil {
  1209. fmt.Println("delete err:" + err.Error())
  1210. return err
  1211. }
  1212. }
  1213. return
  1214. }
  1215. // EditChartEnInfoAndEdbEnInfo
  1216. // @Description: 修改图表和指标的英文信息
  1217. // @author: Roc
  1218. // @datetime 2024-04-18 13:58:13
  1219. // @param req *EditChartEnInfoReq
  1220. // @return err error
  1221. func EditChartEnInfoAndEdbEnInfo(req *EditChartEnInfoReq) (err error) {
  1222. o := orm.NewOrmUsingDB("data")
  1223. to, err := o.Begin()
  1224. if err != nil {
  1225. return
  1226. }
  1227. defer func() {
  1228. if err != nil {
  1229. _ = to.Rollback()
  1230. } else {
  1231. _ = to.Commit()
  1232. }
  1233. }()
  1234. var pars []interface{}
  1235. updateField := ` chart_name_en =?, `
  1236. pars = append(pars, req.ChartNameEn)
  1237. if req.ExtraConfig != `` {
  1238. updateField += ` extra_config =?, `
  1239. pars = append(pars, req.ExtraConfig)
  1240. }
  1241. updateField += ` chart_alias =?, `
  1242. pars = append(pars, req.ChartAlias)
  1243. sql := ` UPDATE chart_info
  1244. SET ` + updateField + ` modify_time = NOW()
  1245. WHERE chart_info_id = ?`
  1246. pars = append(pars, req.ChartInfoId)
  1247. _, err = to.Raw(sql, pars).Exec()
  1248. if err != nil {
  1249. fmt.Println("UPDATE chart_info Err:", err.Error())
  1250. return err
  1251. }
  1252. var edbInfoIdArr []string
  1253. for _, v := range req.ChartEdbInfoList {
  1254. edbInfoIdArr = append(edbInfoIdArr, strconv.Itoa(v.EdbInfoId))
  1255. var count int
  1256. csql := `SELECT COUNT(1) AS count FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id=? `
  1257. err = to.Raw(csql, req.ChartInfoId, v.EdbInfoId).QueryRow(&count)
  1258. if err != nil {
  1259. fmt.Println("QueryRow Err:", err.Error())
  1260. return err
  1261. }
  1262. if count > 0 {
  1263. msql := ` UPDATE edb_info
  1264. SET
  1265. edb_name_en =?,
  1266. unit_en = ?,
  1267. modify_time = NOW()
  1268. WHERE edb_info_id = ? `
  1269. _, err = to.Raw(msql, v.EdbNameEn, v.UnitEn, v.EdbInfoId).Exec()
  1270. if err != nil {
  1271. fmt.Println("edb_info Err:" + err.Error())
  1272. return err
  1273. }
  1274. }
  1275. }
  1276. return
  1277. }
  1278. // EditChartBaseInfoAndEdbEnInfo
  1279. // @Description: 修改图表和指标的基础信息
  1280. // @author: Roc
  1281. // @datetime 2024-04-18 13:28:16
  1282. // @param req *EditChartInfoBaseReq
  1283. // @param chartItem *ChartInfo
  1284. // @param lang string
  1285. // @return err error
  1286. func EditChartBaseInfoAndEdbEnInfo(req *EditChartInfoBaseReq, chartItem *ChartInfo, lang string) (err error) {
  1287. o := orm.NewOrmUsingDB("data")
  1288. to, err := o.Begin()
  1289. if err != nil {
  1290. return
  1291. }
  1292. defer func() {
  1293. if err != nil {
  1294. _ = to.Rollback()
  1295. } else {
  1296. _ = to.Commit()
  1297. }
  1298. }()
  1299. updateChartCols := make([]string, 0)
  1300. switch lang {
  1301. case utils.EnLangVersion:
  1302. chartItem.ChartNameEn = req.ChartName
  1303. updateChartCols = append(updateChartCols, "ChartNameEn")
  1304. default:
  1305. chartItem.ChartName = req.ChartName
  1306. updateChartCols = append(updateChartCols, "ChartName")
  1307. }
  1308. if req.ExtraConfig != `` {
  1309. chartItem.ExtraConfig = req.ExtraConfig
  1310. updateChartCols = append(updateChartCols, "ExtraConfig")
  1311. }
  1312. chartItem.ModifyTime = time.Now()
  1313. updateChartCols = append(updateChartCols, "ModifyTime")
  1314. _, err = to.Update(chartItem, updateChartCols...)
  1315. if err != nil {
  1316. fmt.Println("UPDATE chart_info Err:", err.Error())
  1317. return err
  1318. }
  1319. var edbInfoIdArr []string
  1320. for _, v := range req.ChartEdbInfoList {
  1321. edbInfoIdArr = append(edbInfoIdArr, strconv.Itoa(v.EdbInfoId))
  1322. var count int
  1323. csql := `SELECT COUNT(1) AS count FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id=? `
  1324. err = to.Raw(csql, req.ChartInfoId, v.EdbInfoId).QueryRow(&count)
  1325. if err != nil {
  1326. fmt.Println("QueryRow Err:", err.Error())
  1327. return err
  1328. }
  1329. if count > 0 {
  1330. msql := ` UPDATE edb_info SET modify_time = NOW() `
  1331. pars := make([]interface{}, 0)
  1332. switch lang {
  1333. case utils.EnLangVersion:
  1334. msql += ` ,edb_name_en = ? `
  1335. pars = append(pars, v.EdbName)
  1336. // 如果有传单位
  1337. if v.Unit != `` {
  1338. msql += ` ,unit_en = ? `
  1339. pars = append(pars, v.Unit)
  1340. }
  1341. default:
  1342. msql += ` ,edb_name = ? `
  1343. pars = append(pars, v.EdbName)
  1344. // 如果有传单位
  1345. if v.Unit != `` {
  1346. msql += ` ,unit = ? `
  1347. pars = append(pars, v.Unit)
  1348. }
  1349. }
  1350. msql += ` WHERE edb_info_id = ? `
  1351. pars = append(pars, v.EdbInfoId)
  1352. _, err = to.Raw(msql, pars...).Exec()
  1353. if err != nil {
  1354. fmt.Println("edb_info Err:" + err.Error())
  1355. return err
  1356. }
  1357. }
  1358. }
  1359. return
  1360. }
  1361. type AddChartInfoReq struct {
  1362. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  1363. ChartClassifyId int `description:"分类id"`
  1364. ChartName string `description:"图表名称"`
  1365. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图,7:柱方图"`
  1366. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间,6:起始日期至今"`
  1367. StartDate string `description:"自定义开始日期"`
  1368. EndDate string `description:"自定义结束日期"`
  1369. Calendar string `description:"公历/农历"`
  1370. LeftMin string `description:"图表左侧最小值"`
  1371. LeftMax string `description:"图表左侧最大值"`
  1372. RightMin string `description:"图表右侧最小值"`
  1373. RightMax string `description:"图表右侧最大值"`
  1374. Right2Min string `description:"图表右侧2最小值"`
  1375. Right2Max string `description:"图表右侧2最大值"`
  1376. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  1377. BarChartInfo BarChartInfoReq `description:"柱方图的配置"`
  1378. CorrelationChartInfo CorrelationChartInfoReq `description:"相关性图表配置"`
  1379. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  1380. ChartImage string `description:"封面图" json:"-"`
  1381. SeasonExtraConfig SeasonExtraItem `description:"季节性图表中的配置,json数据"`
  1382. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  1383. ChartThemeId int `description:"图表应用主题ID"`
  1384. SourcesFrom string `description:"图表来源"`
  1385. Instructions string `description:"图表说明"`
  1386. MarkersLines string `description:"标识线"`
  1387. MarkersAreas string `description:"标识区"`
  1388. Unit string `description:"中文单位名称"`
  1389. UnitEn string `description:"英文单位名称"`
  1390. ChartAlias string `description:"图表别名"`
  1391. }
  1392. type AddFutureGoodChartInfoReq struct {
  1393. AddChartInfoReq
  1394. BarChartInfo FutureGoodBarChartInfoReq
  1395. }
  1396. type PreviewChartInfoReq struct {
  1397. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  1398. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间,6:起始日期至今 20:最近N年"`
  1399. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图,7:柱方图"`
  1400. StartDate string `description:"自定义开始日期"`
  1401. EndDate string `description:"自定义结束日期"`
  1402. Calendar string `description:"公历/农历"`
  1403. SeasonExtraConfig SeasonExtraItem `description:"季节性图表中的配置,json数据"`
  1404. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  1405. ChartSource int
  1406. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  1407. MarkersLines string `description:"标识线"`
  1408. }
  1409. type SeasonExtraItem struct {
  1410. ChartLegend []SeasonChartLegend `description:"自定义的图例名称"`
  1411. XStartDate string `description:"横坐标显示的起始日"`
  1412. XEndDate string `description:"横坐标显示的截止日"`
  1413. JumpYear int `description:"横坐标日期是否跨年,1跨年,0不跨年"`
  1414. RightAxis SeasonRightAxis `description:"自定义右轴指标"`
  1415. MaxMinLimits MaxMinLimits `description:"自定义同期上下限"`
  1416. SamePeriodAverage SamePeriodAverage `description:"自定义同期均线"`
  1417. SamePeriodStandardDeviation SamePeriodStandardDeviation `description:"自定义同期标准差"`
  1418. }
  1419. type SeasonChartLegend struct {
  1420. Name string
  1421. Value string
  1422. }
  1423. // 自定义右轴指标
  1424. type SeasonRightAxis struct {
  1425. IndicatorType int `description:"右轴指标类型 1:左轴指标同比,2:指标库,3:预测指标 "`
  1426. Style string `description:"生成样式"`
  1427. Shape string `description:"形状"`
  1428. ChartColor string `description:"图表颜色"`
  1429. Size int `description:"大小"`
  1430. Legend string `description:"图例名称"`
  1431. NumFormat int `description:"数值格式 1:百分比 2:小数"`
  1432. IsConnected int `description:"是否连接 0不连接 1连接"`
  1433. LineColor string `description:"线条颜色"`
  1434. LineWidth int `description:"线条宽度"`
  1435. LineStyle string `description:"线条样式"`
  1436. IsShow bool `description:"是否显示"`
  1437. IsAdd bool `description:"是否添加"`
  1438. }
  1439. // 自定义同期上下限
  1440. type MaxMinLimits struct {
  1441. Color string `description:"颜色"`
  1442. Year int `description:"上下限取值范围"`
  1443. Legend string `description:"图例名称"`
  1444. IsShow bool `description:"是否显示"`
  1445. IsAdd bool `description:"是否添加"`
  1446. }
  1447. // 自定义同期均线
  1448. type SamePeriodAverage struct {
  1449. Color string `description:"颜色"`
  1450. Year int `description:"均线取值范围"`
  1451. Legend string `description:"图例名称"`
  1452. LineType string `description:"线型"`
  1453. LineWidth int `description:"线宽"`
  1454. IsShow bool `description:"是否显示"`
  1455. IsAdd bool `description:"是否添加"`
  1456. }
  1457. // 自定义同期均线
  1458. type SamePeriodAverageResp struct {
  1459. Color string `description:"颜色"`
  1460. Year int `description:"均线取值范围"`
  1461. Legend string `description:"图例名称"`
  1462. LineType string `description:"线型"`
  1463. LineWidth int `description:"线宽"`
  1464. IsShow bool `description:"是否显示"`
  1465. List []*SamePeriodAverageData `description:"自定义均线列表"`
  1466. IsAdd bool `description:"是否添加"`
  1467. }
  1468. type SamePeriodAverageData struct {
  1469. DataTime string `description:"数据日期"`
  1470. DataTimestamp int64 `description:"数据日期时间戳"`
  1471. Value float64 `description:"均值"`
  1472. }
  1473. // 自定义同期标准差
  1474. type SamePeriodStandardDeviation struct {
  1475. Color string `description:"颜色"`
  1476. Year int `description:"标准差取值范围"`
  1477. Legend string `description:"图例名称"`
  1478. Multiple float64 `description:"标准差倍数"`
  1479. IsShow bool `description:"是否显示"`
  1480. IsAdd bool `description:"是否添加"`
  1481. }
  1482. type SamePeriodStandardDeviationResp struct {
  1483. Color string `description:"颜色"`
  1484. Year int `description:"标准差取值范围"`
  1485. Legend string `description:"图例名称"`
  1486. Multiple float64 `description:"标准差倍数"`
  1487. IsShow bool `description:"是否显示"`
  1488. List []*MaxMinLimitsData `description:"自定义标准差列表"`
  1489. IsAdd bool `description:"是否添加"`
  1490. }
  1491. type SeasonChartResp struct {
  1492. MaxMinLimits MaxMinLimitsResp `description:"自定义上下限"`
  1493. SamePeriodAverage SamePeriodAverageResp `description:"自定义同期均线"`
  1494. SamePeriodStandardDeviation SamePeriodStandardDeviationResp `description:"自定义同期标准差线"`
  1495. RightAxis SeasonRightAxisResp `description:"自定义右轴指标"`
  1496. }
  1497. // 自定义右轴指标
  1498. type SeasonRightAxisResp struct {
  1499. SeasonRightAxis
  1500. EdbInfoList []*ChartEdbInfoMapping
  1501. }
  1502. type MaxMinLimitsResp struct {
  1503. List []*MaxMinLimitsData `description:"自定义上下限列表"`
  1504. Color string `description:"颜色"`
  1505. Year int `description:"上下限取值范围"`
  1506. Legend string `description:"图例名称"`
  1507. IsShow bool `description:"是否显示"`
  1508. IsAdd bool `description:"是否添加"`
  1509. }
  1510. type MaxMinLimitsData struct {
  1511. DataTime string `description:"数据日期"`
  1512. DataTimestamp int64 `description:"数据日期时间戳"`
  1513. MaxValue float64 `description:"最大值"`
  1514. MinValue float64 `description:"最小值"`
  1515. }
  1516. type AddChartInfoResp struct {
  1517. ChartInfoId int `description:"图表id"`
  1518. UniqueCode string `description:"图表唯一编码"`
  1519. ChartType int `description:"生成样式:1:曲线图,2:季节性图"`
  1520. ClassifyId int `description:"分类ID"`
  1521. }
  1522. type QuarterDataList []*QuarterData
  1523. func (m QuarterDataList) Len() int {
  1524. return len(m)
  1525. }
  1526. func (m QuarterDataList) Less(i, j int) bool {
  1527. return m[i].Years < m[j].Years
  1528. }
  1529. func (m QuarterDataList) Swap(i, j int) {
  1530. m[i], m[j] = m[j], m[i]
  1531. }
  1532. // BalanceSeasonChartLegendPreviewResp 表格中季节性图表预览接口
  1533. type BalanceSeasonChartLegendPreviewResp struct {
  1534. List QuarterDataList
  1535. }
  1536. // 判断图表指标是否已经存在
  1537. func ChartInfoExist(condition, edbInfoIdStr string) (count int, err error) {
  1538. sql := `SELECT COUNT(1) AS count FROM (
  1539. SELECT GROUP_CONCAT(edb_info_id ORDER BY edb_info_id ASC SEPARATOR ',') AS edb_info_id_str
  1540. FROM chart_edb_mapping AS a
  1541. WHERE 1=1`
  1542. if condition != "" {
  1543. sql += condition
  1544. }
  1545. sql += ` GROUP BY chart_info_id
  1546. )AS t
  1547. WHERE t.edb_info_id_str=?
  1548. GROUP BY t.edb_info_id_str `
  1549. o := orm.NewOrmUsingDB("data")
  1550. err = o.Raw(sql, edbInfoIdStr).QueryRow(&count)
  1551. return
  1552. }
  1553. func ChartInfoSearchByKeyWord(keyword string, showSysId int) (searchList []*ChartInfo, err error) {
  1554. o := orm.NewOrmUsingDB("data")
  1555. sql := ` SELECT * FROM chart_info WHERE 1=1 `
  1556. var pars []interface{}
  1557. if keyword != "" {
  1558. sql += `AND chart_name LIKE ? `
  1559. pars = append(pars, utils.GetLikeKeyword(keyword))
  1560. }
  1561. if showSysId > 0 {
  1562. sql += ` AND sys_user_id = ? `
  1563. pars = append(pars, showSysId)
  1564. }
  1565. sql += ` ORDER BY create_time DESC `
  1566. if keyword == "" {
  1567. sql += ` LIMIT 100 `
  1568. }
  1569. _, err = o.Raw(sql, pars).QueryRows(&searchList)
  1570. return
  1571. }
  1572. // ChartInfoSearchByEmptyKeyWord 没有关键字的时候获取默认100条数据
  1573. func ChartInfoSearchByEmptyKeyWord(showSysId int, sourceList []int, noPermissionChartIdList []int, startSize, pageSize int) (total int64, searchList []*ChartInfo, err error) {
  1574. num := len(sourceList)
  1575. o := orm.NewOrmUsingDB("data")
  1576. baseSql := ` FROM chart_info WHERE 1=1 AND source in (` + utils.GetOrmInReplace(num) + `)`
  1577. var basePars []interface{}
  1578. basePars = append(basePars, sourceList)
  1579. if showSysId > 0 {
  1580. baseSql += ` AND sys_user_id = ? `
  1581. basePars = append(basePars, showSysId)
  1582. }
  1583. lenNoPermissionChartIdList := len(noPermissionChartIdList)
  1584. if lenNoPermissionChartIdList > 0 {
  1585. baseSql += ` AND chart_info_id not in (` + utils.GetOrmInReplace(lenNoPermissionChartIdList) + `) `
  1586. basePars = append(basePars, noPermissionChartIdList)
  1587. }
  1588. // 查找数量
  1589. totalSql := " SELECT count(1) as total " + baseSql
  1590. err = o.Raw(totalSql, basePars).QueryRow(&total)
  1591. if err != nil {
  1592. return
  1593. }
  1594. // 查找列表数据
  1595. sql := " SELECT * " + baseSql + ` ORDER BY create_time DESC LIMIT ?,? `
  1596. basePars = append(basePars, startSize, pageSize)
  1597. _, err = o.Raw(sql, basePars).QueryRows(&searchList)
  1598. return
  1599. }
  1600. func GetNextChartInfo(classifyId int) (item *ChartInfo, err error) {
  1601. o := orm.NewOrmUsingDB("data")
  1602. sql := ` SELECT b.* FROM chart_classify AS a
  1603. INNER JOIN chart_info AS b ON a.chart_classify_id=b.chart_classify_id
  1604. WHERE a.chart_classify_id>?
  1605. ORDER BY a.chart_classify_id ASC
  1606. LIMIT 1 `
  1607. err = o.Raw(sql, classifyId).QueryRow(&item)
  1608. return
  1609. }
  1610. // GetChartInfoRefreshData 获取图表关联的指标信息
  1611. func GetChartInfoRefreshData(chartInfoId int) (baseEdbInfoArr, calculateInfoArr []*EdbInfo, err error) {
  1612. o := orm.NewOrmUsingDB("data")
  1613. sql := ` SELECT b.* FROM chart_edb_mapping AS a
  1614. INNER JOIN edb_info AS b ON a.edb_info_id=b.edb_info_id
  1615. WHERE a.chart_info_id=? `
  1616. edbInfoList := make([]*EdbInfo, 0)
  1617. _, err = o.Raw(sql, chartInfoId).QueryRows(&edbInfoList)
  1618. if err != nil {
  1619. return
  1620. }
  1621. for _, v := range edbInfoList {
  1622. fmt.Println(v.EdbInfoId, v.EdbType)
  1623. if v.EdbType == 1 {
  1624. baseEdbInfoArr = append(baseEdbInfoArr, v)
  1625. } else {
  1626. calculateInfoArr = append(calculateInfoArr, v)
  1627. newBaseEdbInfoArr, newCalculateInfoArr, err := GetChartRefreshEdbInfo(v.EdbInfoId, v.Source, 0)
  1628. if err != nil {
  1629. return baseEdbInfoArr, calculateInfoArr, err
  1630. }
  1631. baseEdbInfoArr = append(baseEdbInfoArr, newBaseEdbInfoArr...)
  1632. calculateInfoArr = append(calculateInfoArr, newCalculateInfoArr...)
  1633. }
  1634. }
  1635. return
  1636. }
  1637. func GetChartRefreshEdbInfo(edbInfoId, source, n int) (baseEdbInfoArr, calculateInfoArr []*EdbInfo, err error) {
  1638. calculateList, err := GetEdbInfoCalculateMap(edbInfoId, source)
  1639. if err != nil && err.Error() != utils.ErrNoRow() {
  1640. return
  1641. }
  1642. n++
  1643. for _, item := range calculateList {
  1644. fmt.Println(item.EdbInfoId)
  1645. if item.EdbType == 1 {
  1646. baseEdbInfoArr = append(baseEdbInfoArr, item)
  1647. } else {
  1648. calculateInfoArr = append(calculateInfoArr, item)
  1649. if n > 10 {
  1650. return
  1651. }
  1652. newBaseEdbInfoArr, newCalculateInfoArr, _ := GetChartRefreshEdbInfo(item.EdbInfoId, item.Source, n)
  1653. baseEdbInfoArr = append(baseEdbInfoArr, newBaseEdbInfoArr...)
  1654. calculateInfoArr = append(calculateInfoArr, newCalculateInfoArr...)
  1655. }
  1656. }
  1657. return
  1658. }
  1659. type SetChartInfoImageReq struct {
  1660. ChartInfoId int `description:"图表ID"`
  1661. ImageUrl string `description:"图表图片地址"`
  1662. }
  1663. func EditChartInfoImage(req *SetChartInfoImageReq) (err error) {
  1664. o := orm.NewOrmUsingDB("data")
  1665. sql := ` UPDATE chart_info SET chart_image=?, modify_time = NOW() WHERE chart_info_id = ? `
  1666. _, err = o.Raw(sql, req.ImageUrl, req.ChartInfoId).Exec()
  1667. if err != nil {
  1668. fmt.Println("EditChartInfoImage Err:", err.Error())
  1669. return err
  1670. }
  1671. return
  1672. }
  1673. type ChartInfoDetailFromUniqueCodeResp struct {
  1674. ChartInfo *ChartInfoView
  1675. Status bool `description:"true:图表存在,false:图表不存在"`
  1676. EdbInfoList []*ChartEdbInfoMapping
  1677. XEdbIdValue []int `description:"柱方图的x轴数据,指标id"`
  1678. YDataList []YData `description:"柱方图的y轴数据"`
  1679. XDataList []XData `description:"商品价格曲线的X轴数据"`
  1680. BarChartInfo BarChartInfoReq `description:"柱方图的配置"`
  1681. CorrelationChartInfo *CorrelationInfo `description:"相关性图表信息"`
  1682. DataResp interface{} `description:"图表数据,根据图的类型而定的,没有确定的数据格式"`
  1683. }
  1684. type FutureChartInfoDetailFromUniqueCodeResp struct {
  1685. ChartInfo *ChartInfoView
  1686. Status bool `description:"true:图表存在,false:图表不存在"`
  1687. EdbInfoList []*ChartEdbInfoMapping
  1688. XEdbIdValue []int `description:"柱方图的x轴数据,指标id"`
  1689. YDataList []YData `description:"柱方图的y轴数据"`
  1690. XDataList []XData `description:"商品价格曲线的X轴数据"`
  1691. BarChartInfo FutureGoodBarChartInfoReq `description:"柱方图的配置"`
  1692. CorrelationChartInfo *CorrelationInfo `description:"相关性图表信息"`
  1693. DataResp interface{} `description:"图表数据,根据图的类型而定的,没有确定的数据格式"`
  1694. }
  1695. func GetChartInfoByUniqueCode(uniqueCode string) (item *ChartInfo, err error) {
  1696. o := orm.NewOrmUsingDB("data")
  1697. sql := ` SELECT * FROM chart_info WHERE unique_code=? `
  1698. err = o.Raw(sql, uniqueCode).QueryRow(&item)
  1699. return
  1700. }
  1701. func GetChartInfoViewByUniqueCode(uniqueCode string) (item *ChartInfoView, err error) {
  1702. o := orm.NewOrmUsingDB("data")
  1703. sql := ` SELECT * FROM chart_info WHERE unique_code=? `
  1704. err = o.Raw(sql, uniqueCode).QueryRow(&item)
  1705. return
  1706. }
  1707. // GetFirstChartInfoByClassifyId 获取当前分类下,且排序数相同 的排序第一条的数据
  1708. func GetFirstChartInfoByClassifyId(classifyId int) (item *ChartInfo, err error) {
  1709. o := orm.NewOrmUsingDB("data")
  1710. sql := ` SELECT * FROM chart_info WHERE chart_classify_id=? order by sort asc,chart_info_id asc limit 1`
  1711. err = o.Raw(sql, classifyId).QueryRow(&item)
  1712. return
  1713. }
  1714. // UpdateChartInfoSortByClassifyId 根据图表id更新排序
  1715. func UpdateChartInfoSortByClassifyId(classifyId, nowSort, prevChartInfoId int, sourceList []int, updateSort string) (err error) {
  1716. o := orm.NewOrmUsingDB("data")
  1717. num := len(sourceList)
  1718. if num <= 0 {
  1719. return
  1720. }
  1721. sql := ` update chart_info set sort = ` + updateSort + ` WHERE chart_classify_id=? AND source in (` + utils.GetOrmInReplace(num) + `) AND `
  1722. if prevChartInfoId > 0 {
  1723. sql += ` (sort > ? or (chart_info_id > ` + fmt.Sprint(prevChartInfoId) + ` and sort = ` + fmt.Sprint(nowSort) + `))`
  1724. }
  1725. _, err = o.Raw(sql, classifyId, sourceList, nowSort).Exec()
  1726. return
  1727. }
  1728. // Update 更新图表基础信息
  1729. func (chartInfo *ChartInfo) Update(cols []string) (err error) {
  1730. o := orm.NewOrmUsingDB("data")
  1731. _, err = o.Update(chartInfo, cols...)
  1732. return
  1733. }
  1734. type ChartInfoView struct {
  1735. ChartInfoId int `orm:"column(chart_info_id);pk"`
  1736. ChartName string `description:"来源名称"`
  1737. ChartNameEn string `description:"英文图表名称"`
  1738. Unit string `description:"中文单位名称"`
  1739. UnitEn string `description:"英文单位名称"`
  1740. ChartClassifyId int `description:"图表分类id"`
  1741. ChartClassifyName string `description:"图表名称"`
  1742. SysUserId int
  1743. SysUserRealName string
  1744. UniqueCode string `description:"图表唯一编码"`
  1745. CreateTime time.Time
  1746. ModifyTime time.Time
  1747. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间"`
  1748. StartDate string `description:"自定义开始日期"`
  1749. EndDate string `description:"自定义结束日期"`
  1750. IsSetName int `description:"设置名称"`
  1751. EdbInfoIds string `description:"指标id"`
  1752. ChartType int `description:"生成样式:1:曲线图,2:季节性图"`
  1753. Calendar string `description:"公历/农历"`
  1754. SeasonStartDate string `description:"季节性图开始日期"`
  1755. SeasonEndDate string `description:"季节性图开始日期"`
  1756. ChartImage string `description:"图表图片"`
  1757. Sort int `description:"排序字段,数字越小越排前面"`
  1758. IsAdd bool `description:"true:已加入我的图库,false:未加入我的图库"`
  1759. MyChartId int
  1760. MyChartClassifyId string `description:"我的图表分类,多个用逗号隔开"`
  1761. ChartClassify []*ChartClassifyView
  1762. EdbEndDate string `description:"指标最新更新日期"`
  1763. XMin string `description:"图表X轴最小值"`
  1764. XMax string `description:"图表X轴最大值"`
  1765. LeftMin string `description:"图表左侧最小值"`
  1766. LeftMax string `description:"图表左侧最大值"`
  1767. RightMin string `description:"图表右侧最小值"`
  1768. RightMax string `description:"图表右侧最大值"`
  1769. Right2Min string `description:"图表右侧最小值"`
  1770. Right2Max string `description:"图表右侧最大值"`
  1771. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  1772. IsEdit bool `description:"是否有编辑权限"`
  1773. IsEnChart bool `description:"是否展示英文标识"`
  1774. WarnMsg string `description:"错误信息"`
  1775. Disabled int `description:"是否禁用,0:启用,1:禁用,默认:0"`
  1776. BarConfig string `description:"柱方图的配置,json数据" json:"-"`
  1777. Source int `description:"1:ETA图库;2:商品价格曲线;3:相关性图表"`
  1778. //CorrelationLeadUnit string `description:"相关性图表-领先单位"`
  1779. ExtraConfig string `description:"图表额外配置,json数据"`
  1780. ChartSource string `description:"图表来源str"`
  1781. ChartSourceEn string `description:"图表来源(英文)"`
  1782. Button ChartViewButton `description:"操作按钮"`
  1783. SeasonExtraConfig string `description:"季节性图表中的配置,json数据"`
  1784. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  1785. ChartThemeId int `description:"图表应用主题ID"`
  1786. ChartThemeStyle string `description:"图表应用主题样式"`
  1787. SourcesFrom string `description:"图表来源"`
  1788. Instructions string `description:"图表说明"`
  1789. MarkersLines string `description:"标识线"`
  1790. MarkersAreas string `description:"标识区"`
  1791. IsJoinPermission int `description:"是否加入权限管控,0:不加入;1:加入;默认:0"`
  1792. HaveOperaAuth bool `description:"是否有数据权限,默认:false"`
  1793. ForumChartInfoId int `description:"社区的图表ID"`
  1794. ChartAlias string `description:"图表别名"`
  1795. }
  1796. type ChartViewButton struct {
  1797. IsEdit bool `description:"是否有编辑权限"`
  1798. IsEnChart bool `description:"是否展示英文标识"`
  1799. IsAdd bool `description:"true:已加入我的图库,false:未加入我的图库"`
  1800. IsCopy bool `description:"是否有另存为按钮"`
  1801. IsSetName int `description:"设置名称"`
  1802. }
  1803. type ImageSvgToPngResp struct {
  1804. Data struct {
  1805. ResourceURL string `json:"ResourceUrl"`
  1806. } `json:"Data"`
  1807. ErrCode string `json:"ErrCode"`
  1808. ErrMsg string `json:"ErrMsg"`
  1809. IsSendEmail bool `json:"IsSendEmail"`
  1810. Msg string `json:"Msg"`
  1811. Ret int64 `json:"Ret"`
  1812. Success bool `json:"Success"`
  1813. }
  1814. // GetChartInfoByClassifyIdAndName 根据分类id和图表名获取图表信息
  1815. func GetChartInfoByClassifyIdAndName(classifyId int, chartName string) (item *ChartInfo, err error) {
  1816. o := orm.NewOrmUsingDB("data")
  1817. sql := ` SELECT * FROM chart_info WHERE chart_classify_id = ? and chart_name=? `
  1818. err = o.Raw(sql, classifyId, chartName).QueryRow(&item)
  1819. return
  1820. }
  1821. // BatchChartRefreshReq 批量刷新图表请求
  1822. type BatchChartRefreshReq struct {
  1823. ChartInfoCode []string `description:"图表编码数组"`
  1824. PrimaryId int `description:"研报/智能研报/PPT主键"`
  1825. SubId int `description:"报告章节ID"`
  1826. Source string `description:"来源,枚举值:report、english_report、smart_report、ppt"`
  1827. }
  1828. // GetChartInfoListByUniqueCodeSlice 根据图表编码获取图表列表数据
  1829. func GetChartInfoListByUniqueCodeSlice(uniqueCodeSlice []string) (total int64, items []*ChartInfo, err error) {
  1830. if len(uniqueCodeSlice) <= 0 {
  1831. return
  1832. }
  1833. o := orm.NewOrmUsingDB("data")
  1834. sql := ` SELECT * FROM chart_info WHERE unique_code in ("` + strings.Join(uniqueCodeSlice, `","`) + `") `
  1835. total, err = o.Raw(sql).QueryRows(&items)
  1836. return
  1837. }
  1838. // GetChartInfoRefreshDataByChartInfoIdSlice 根据图表id切片获取对应的指标数据
  1839. func GetChartInfoRefreshDataByChartInfoIdSlice(chartInfoIdSlice []string) (baseEdbInfoArr, calculateInfoArr []*EdbInfo, err error) {
  1840. o := orm.NewOrmUsingDB("data")
  1841. if len(chartInfoIdSlice) <= 0 {
  1842. return
  1843. }
  1844. sql := ` SELECT b.* FROM chart_edb_mapping AS a
  1845. INNER JOIN edb_info AS b ON a.edb_info_id=b.edb_info_id
  1846. WHERE a.chart_info_id in (` + strings.Join(chartInfoIdSlice, ",") + `) `
  1847. edbInfoList := make([]*EdbInfo, 0)
  1848. _, err = o.Raw(sql).QueryRows(&edbInfoList)
  1849. if err != nil {
  1850. return
  1851. }
  1852. for _, v := range edbInfoList {
  1853. if v.EdbType == 1 {
  1854. baseEdbInfoArr = append(baseEdbInfoArr, v)
  1855. } else {
  1856. calculateInfoArr = append(calculateInfoArr, v)
  1857. newBaseEdbInfoArr, newCalculateInfoArr, err := GetChartRefreshEdbInfo(v.EdbInfoId, v.Source, 0)
  1858. if err != nil {
  1859. return baseEdbInfoArr, calculateInfoArr, err
  1860. }
  1861. baseEdbInfoArr = append(baseEdbInfoArr, newBaseEdbInfoArr...)
  1862. calculateInfoArr = append(calculateInfoArr, newCalculateInfoArr...)
  1863. }
  1864. }
  1865. return
  1866. }
  1867. // CopyAddChartInfoReq 复制并新增图表
  1868. type CopyAddChartInfoReq struct {
  1869. ChartInfoId int `description:"待复制的图表id"`
  1870. ChartClassifyId int `description:"分类id"`
  1871. ChartName string `description:"图表名称"`
  1872. }
  1873. // ChartInfoListByEsResp 图表数据Es搜索返回
  1874. type ChartInfoListByEsResp struct {
  1875. Paging *paging.PagingItem
  1876. List []*ChartInfoMore
  1877. }
  1878. // GetChartInfoListByCondition 根据条件获取图表数据了列表
  1879. func GetChartInfoListByCondition(condition string, pars []interface{}, startSize, pageSize int) (items []*ChartInfo, err error) {
  1880. o := orm.NewOrmUsingDB("data")
  1881. sql := ` SELECT * FROM chart_info WHERE 1=1 `
  1882. if condition != "" {
  1883. sql += condition
  1884. }
  1885. sql += ` ORDER BY chart_info_id DESC LIMIT ?,? `
  1886. _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
  1887. return
  1888. }
  1889. // GetChartInfoListGroupByUserId 根据指标id列表、用户分组获取指标信息
  1890. func GetChartInfoListGroupByUserId(edbIdList []string) (items []*ChartInfo, err error) {
  1891. num := len(edbIdList)
  1892. if num <= 0 {
  1893. return
  1894. }
  1895. o := orm.NewOrmUsingDB("data")
  1896. sql := ` SELECT * FROM chart_info WHERE chart_info_id in (` + utils.GetOrmInReplace(num) + `) ORDER BY chart_info_id desc `
  1897. _, err = o.Raw(sql, edbIdList).QueryRows(&items)
  1898. return
  1899. }
  1900. // GetChartInfoListByChartIdList
  1901. // @Description: 根据图表id列表获取列表信息
  1902. // @param edbIdList
  1903. // @return items
  1904. // @return err
  1905. func GetChartInfoListByChartIdList(charIdList []string) (items []*ChartInfo, err error) {
  1906. num := len(charIdList)
  1907. if num <= 0 {
  1908. return
  1909. }
  1910. o := orm.NewOrmUsingDB("data")
  1911. sql := ` SELECT * FROM chart_info WHERE chart_info_id in (` + utils.GetOrmInReplace(num) + `) ORDER BY chart_info_id desc `
  1912. _, err = o.Raw(sql, charIdList).QueryRows(&items)
  1913. return
  1914. }
  1915. // GetChartInfoListByUserId
  1916. // @Description: 根据图表id列表获取列表信息
  1917. // @param userIdList []int
  1918. // @param source int
  1919. // @return items
  1920. // @return err
  1921. func GetChartInfoListByUserId(userIdList []int, source int) (items []*ChartInfo, err error) {
  1922. num := len(userIdList)
  1923. if num <= 0 {
  1924. return
  1925. }
  1926. o := orm.NewOrmUsingDB("data")
  1927. sql := ` SELECT * FROM chart_info WHERE source = ? AND sys_user_id in (` + utils.GetOrmInReplace(num) + `) ORDER BY chart_info_id desc `
  1928. _, err = o.Raw(sql, source, userIdList).QueryRows(&items)
  1929. return
  1930. }
  1931. // ModifyChartInfoUserIdByCodeList 根据指标code列表修改创建人
  1932. func ModifyChartInfoUserIdByCodeList(edbIdList []string, userId int, userName string) (err error) {
  1933. num := len(edbIdList)
  1934. if num <= 0 {
  1935. return
  1936. }
  1937. o := orm.NewOrmUsingDB("data")
  1938. sql := `UPDATE chart_info SET sys_user_id=?,sys_user_real_name=? WHERE chart_info_id in (` + utils.GetOrmInReplace(num) + `) `
  1939. _, err = o.Raw(sql, userId, userName, edbIdList).Exec()
  1940. return
  1941. }
  1942. // ModifyChartInfoUserIdByOldUserId
  1943. // @Description: 根据旧的用户id修改创建人
  1944. // @author: Roc
  1945. // @datetime 2024-03-25 19:14:59
  1946. // @param oldUserId int
  1947. // @param userId int
  1948. // @param userName string
  1949. // @return err error
  1950. func ModifyChartInfoUserIdByOldUserId(oldUserIdList []int, userId int, userName string) (err error) {
  1951. num := len(oldUserIdList)
  1952. if num <= 0 {
  1953. return
  1954. }
  1955. o := orm.NewOrmUsingDB("data")
  1956. sql := `UPDATE chart_info SET sys_user_id=?,sys_user_real_name=? WHERE sys_user_id in (` + utils.GetOrmInReplace(num) + `) `
  1957. _, err = o.Raw(sql, userId, userName, oldUserIdList).Exec()
  1958. return
  1959. }
  1960. // BarChartInfoReq 柱方图预览请求数据
  1961. type BarChartInfoReq struct {
  1962. EdbInfoIdList []BarChartInfoEdbItemReq `description:"指标信息"`
  1963. DateList []BarChartInfoDateReq `description:"日期配置"`
  1964. Sort BarChartInfoSortReq `description:"排序"`
  1965. XEdbList []BarChartInfoEdbItemReq `description:"X轴选择的指标列表"`
  1966. YEdbList []BarChartInfoEdbItemReq `description:"Y轴选择的指标列表"`
  1967. Unit string `description:"中文单位"`
  1968. UnitEn string `description:"英文单位"`
  1969. }
  1970. type FutureGoodBarChartInfoReq struct {
  1971. EdbInfoIdList []BarChartInfoEdbItemReq `description:"指标信息"`
  1972. DateList []BarChartInfoDateReq `description:"日期配置"`
  1973. XDataList []XData `description:"横轴配置"`
  1974. BaseEdbInfoId int `description:"日期基准指标id"`
  1975. }
  1976. // BarChartInfoEdbItemReq 柱方图预览请求数据(指标相关)
  1977. type BarChartInfoEdbItemReq struct {
  1978. EdbInfoId int `description:"指标ID"`
  1979. Name string `description:"别名"`
  1980. NameEn string `description:"英文别名"`
  1981. Source int `description:"1:ETA图库;2:商品价格"`
  1982. IsConvert int `description:"是否数据转换 0不转 1转"`
  1983. ConvertType int `description:"数据转换类型 1乘 2除 3对数"`
  1984. ConvertValue float64 `description:"数据转换值"`
  1985. ConvertUnit string `description:"数据转换单位"`
  1986. ConvertEnUnit string `description:"数据转换单位"`
  1987. IsHide int `description:"是否隐藏该项,0不隐藏,1隐藏"`
  1988. }
  1989. // BarChartInfoDateReq 柱方图预览请求数据(日期相关)
  1990. type BarChartInfoDateReq struct {
  1991. Type int `description:"配置类型"`
  1992. Date string `description:"固定日期"`
  1993. Value int `description:"N天的值"`
  1994. Color string `description:"颜色"`
  1995. Name string `description:"别名"`
  1996. }
  1997. // BarChartInfoSortReq 柱方图预览请求数据(排序相关)
  1998. type BarChartInfoSortReq struct {
  1999. Sort int `description:"排序类型,0:默认,1:升序,2:降序"`
  2000. DateIndex int `description:"日期数据的下标,从0开始"`
  2001. }
  2002. // CorrelationChartInfoReq 相关性图表请求体
  2003. type CorrelationChartInfoReq struct {
  2004. LeadValue int `description:"领先期数"`
  2005. LeadUnit string `description:"频度"`
  2006. CalculateValue int `description:"计算窗口"`
  2007. CalculateUnit string `description:"计算频度"`
  2008. BaseCalculateValue int `description:"基础计算窗口(滚动相关性的时候用到)"`
  2009. BaseCalculateUnit string `description:"基础计算频度(滚动相关性的时候用到)"`
  2010. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间,6:起始日期至今"`
  2011. StartDate string `description:"开始日期"`
  2012. EndDate string `description:"结束日期"`
  2013. EdbInfoIdList []CorrelationChartInfoEdbItemReq `description:"指标信息"`
  2014. }
  2015. // CorrelationChartInfoEdbItemReq 相关性图表请求指标
  2016. type CorrelationChartInfoEdbItemReq struct {
  2017. EdbInfoId int `description:"指标ID"`
  2018. Name string `description:"别名"`
  2019. NameEn string `description:"英文别名"`
  2020. //Source int `description:"1:ETA图库;2:商品价格"`
  2021. }
  2022. // EditCorrelationChartInfoAndMapping 修改相关性图表的 图表与指标 的关系
  2023. func EditCorrelationChartInfoAndMapping(req *EditChartInfoReq, edbInfoIdStr string, calendar string, dateType, disabled int, barChartConf string, correlationChart *ChartInfoCorrelation, correlationUpdateCols []string) (err error) {
  2024. o := orm.NewOrmUsingDB("data")
  2025. to, err := o.Begin()
  2026. if err != nil {
  2027. return
  2028. }
  2029. defer func() {
  2030. if err != nil {
  2031. _ = to.Rollback()
  2032. } else {
  2033. _ = to.Commit()
  2034. }
  2035. }()
  2036. var pars []interface{}
  2037. pars = append(pars, req.ChartName)
  2038. pars = append(pars, edbInfoIdStr)
  2039. pars = append(pars, req.ChartType)
  2040. pars = append(pars, req.ChartClassifyId)
  2041. pars = append(pars, disabled)
  2042. pars = append(pars, barChartConf)
  2043. pars = append(pars, req.ExtraConfig)
  2044. pars = append(pars, req.SourcesFrom)
  2045. sql := ` UPDATE chart_info
  2046. SET
  2047. chart_name =?,
  2048. edb_info_ids=?,
  2049. chart_type=?,
  2050. chart_classify_id = ?,
  2051. modify_time = NOW(),
  2052. disabled = ?,
  2053. bar_config = ?,
  2054. extra_config = ?,
  2055. sources_from = ?
  2056. `
  2057. if calendar != "" {
  2058. sql += `,calendar = ? `
  2059. pars = append(pars, calendar)
  2060. }
  2061. if dateType > 0 {
  2062. sql += `,date_type = ? `
  2063. pars = append(pars, dateType)
  2064. }
  2065. sql += `,start_date = ? `
  2066. pars = append(pars, req.StartDate)
  2067. sql += `,end_date = ? `
  2068. pars = append(pars, req.EndDate)
  2069. sql += `,season_start_date = ? `
  2070. pars = append(pars, req.StartDate)
  2071. sql += `,season_end_date = ? `
  2072. pars = append(pars, req.EndDate)
  2073. sql += `,left_min = ? `
  2074. pars = append(pars, req.LeftMin)
  2075. sql += `,left_max = ? `
  2076. pars = append(pars, req.LeftMax)
  2077. sql += `,right_min = ? `
  2078. pars = append(pars, req.RightMin)
  2079. sql += `,right_max = ? `
  2080. pars = append(pars, req.RightMax)
  2081. sql += `WHERE chart_info_id = ?`
  2082. pars = append(pars, req.ChartInfoId)
  2083. _, err = to.Raw(sql, pars).Exec()
  2084. if err != nil {
  2085. fmt.Println("UPDATE chart_info Err:", err.Error())
  2086. return err
  2087. }
  2088. chartEdbMappingIdList := make([]string, 0)
  2089. for _, v := range req.CorrelationChartInfo.EdbInfoIdList {
  2090. // 查询该指标是否存在,如果存在的话,那么就去修改,否则新增
  2091. var tmpChartEdbMapping *ChartEdbMapping
  2092. csql := `SELECT * FROM chart_edb_mapping WHERE chart_info_id=? AND edb_info_id=? AND source = ? `
  2093. err = to.Raw(csql, req.ChartInfoId, v.EdbInfoId, utils.CHART_SOURCE_CORRELATION).QueryRow(&tmpChartEdbMapping)
  2094. if err != nil && err.Error() != utils.ErrNoRow() {
  2095. fmt.Println("QueryRow Err:", err.Error())
  2096. return err
  2097. }
  2098. if tmpChartEdbMapping != nil {
  2099. chartEdbMappingIdList = append(chartEdbMappingIdList, strconv.Itoa(tmpChartEdbMapping.ChartEdbMappingId))
  2100. //tmpChartEdbMapping.ModifyTime = time.Now()
  2101. //tmpChartEdbMapping.MaxData = v.MaxData
  2102. //tmpChartEdbMapping.MinData = v.MinData
  2103. //tmpChartEdbMapping.IsOrder = v.IsOrder
  2104. //tmpChartEdbMapping.IsAxis = v.IsAxis
  2105. //tmpChartEdbMapping.EdbInfoType = v.EdbInfoType
  2106. //tmpChartEdbMapping.LeadValue = v.LeadValue
  2107. //tmpChartEdbMapping.LeadUnit = v.LeadUnit
  2108. //tmpChartEdbMapping.ChartStyle = v.ChartStyle
  2109. //tmpChartEdbMapping.ChartColor = v.ChartColor
  2110. //tmpChartEdbMapping.PredictChartColor = v.PredictChartColor
  2111. //tmpChartEdbMapping.ChartWidth = v.ChartWidth
  2112. //_, err = to.Update(tmpChartEdbMapping, "ModifyTime", "MaxData", "MinData", "IsOrder", "IsAxis", "EdbInfoType", "LeadValue", "LeadUnit", "ChartStyle", "ChartColor", "PredictChartColor", "ChartWidth")
  2113. //if err != nil {
  2114. // fmt.Println("chart_edb_mapping Err:" + err.Error())
  2115. // return err
  2116. //}
  2117. } else {
  2118. mapItem := new(ChartEdbMapping)
  2119. mapItem.ChartInfoId = req.ChartInfoId
  2120. mapItem.EdbInfoId = v.EdbInfoId
  2121. mapItem.CreateTime = time.Now()
  2122. mapItem.ModifyTime = time.Now()
  2123. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  2124. mapItem.UniqueCode = utils.MD5(utils.CHART_PREFIX + "_" + timestamp + "_" + strconv.Itoa(v.EdbInfoId))
  2125. //mapItem.MaxData = v.MaxData
  2126. //mapItem.MinData = v.MinData
  2127. mapItem.IsOrder = true
  2128. mapItem.IsAxis = 1
  2129. mapItem.EdbInfoType = 1
  2130. //mapItem.LeadValue = v.LeadValue
  2131. //mapItem.LeadUnit = v.LeadUnit
  2132. //mapItem.ChartStyle = v.ChartStyle
  2133. //mapItem.ChartColor = v.ChartColor
  2134. //mapItem.PredictChartColor = v.PredictChartColor
  2135. //mapItem.ChartWidth = v.ChartWidth
  2136. mapItem.Source = utils.CHART_SOURCE_CORRELATION
  2137. tmpId, err := to.Insert(mapItem)
  2138. if err != nil {
  2139. fmt.Println("AddChartEdbMapping Err:" + err.Error())
  2140. return err
  2141. }
  2142. mapItem.ChartEdbMappingId = int(tmpId)
  2143. chartEdbMappingIdList = append(chartEdbMappingIdList, strconv.Itoa(mapItem.ChartEdbMappingId))
  2144. }
  2145. }
  2146. if len(chartEdbMappingIdList) > 0 {
  2147. chartEdbMappingIdStr := strings.Join(chartEdbMappingIdList, ",")
  2148. dsql := `DELETE FROM chart_edb_mapping WHERE chart_info_id=? AND chart_edb_mapping_id NOT IN(` + chartEdbMappingIdStr + `)`
  2149. _, err = to.Raw(dsql, req.ChartInfoId).Exec()
  2150. if err != nil {
  2151. fmt.Println("delete err:" + err.Error())
  2152. return err
  2153. }
  2154. }
  2155. // 相关性图表
  2156. _, err = to.Update(correlationChart, correlationUpdateCols...)
  2157. return
  2158. }
  2159. // PreviewSectionScatterChartReq 预览截面散点图的请求
  2160. type PreviewSectionScatterChartReq struct {
  2161. ChartName string `description:"图表名称"`
  2162. ChartClassifyId int `description:"分类id"`
  2163. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  2164. }
  2165. // SectionScatterReq 截面散点请求
  2166. type SectionScatterReq struct {
  2167. XName string `description:"x轴名称"`
  2168. XNameEn string `description:"x轴名称(英文)"`
  2169. XUnitName string `description:"x轴单位名称"`
  2170. XUnitNameEn string `description:"x轴单位名称(英文)"`
  2171. YName string `description:"y轴名称"`
  2172. YNameEn string `description:"y轴名称(英文)"`
  2173. YUnitName string `description:"y轴单位名称"`
  2174. YUnitNameEn string `description:"y轴单位名称(英文)"`
  2175. XMinValue string `description:"X轴的最小值"`
  2176. XMaxValue string `description:"X轴的最大值"`
  2177. YMinValue string `description:"Y轴的最小值"`
  2178. YMaxValue string `description:"Y轴的最大值"`
  2179. //EdbList []SectionScatterEdbItemReq `description:"指标数据"`
  2180. SeriesList []SectionScatterSeriesItemReq `description:"系列数据"`
  2181. }
  2182. // SectionScatterSeriesItemReq 系列的请求
  2183. type SectionScatterSeriesItemReq struct {
  2184. Name string `description:"系列名"`
  2185. NameEn string `description:"系列名(英文名)"`
  2186. IsNameDefault bool `description:"是否使用默认的系列名 false修改过 true默认 影响自动更新"`
  2187. Color string `description:"颜色"`
  2188. EdbInfoList []SectionScatterEdbItemReq
  2189. ShowTrendLine bool `description:"是否展示趋势线"`
  2190. ShowFitEquation bool `description:"是否展示方程式"`
  2191. ShowRSquare bool `description:"是否展示R平方"`
  2192. }
  2193. // SectionScatterEdbItemReq 截面散点请求的指标
  2194. type SectionScatterEdbItemReq struct {
  2195. XEdbInfoId int `description:"X轴的指标ID"`
  2196. YEdbInfoId int `description:"Y轴的指标ID"`
  2197. Name string `description:"别名"`
  2198. NameEn string `description:"英文别名"`
  2199. XDateType int `description:"X轴的日期配置类型"`
  2200. XDate string `description:"X轴的日期固定日期"`
  2201. XDateValue int `description:"X轴的日期N天的值"`
  2202. YDateType int `description:"Y轴的日期配置类型"`
  2203. YDate string `description:"Y轴的日期固定日期"`
  2204. YDateValue int `description:"Y轴的日期N天的值"`
  2205. IsShow bool `description:"是否展示"`
  2206. }
  2207. // SectionScatterInfoResp 截面散点图数据
  2208. type SectionScatterInfoResp struct {
  2209. XName string `description:"x轴名称"`
  2210. XNameEn string `description:"x轴名称(英文)"`
  2211. XUnitName string `description:"x轴单位名称"`
  2212. XUnitNameEn string `description:"x轴单位名称(英文)"`
  2213. YName string `description:"y轴名称"`
  2214. YNameEn string `description:"y轴名称(英文)"`
  2215. YUnitName string `description:"y轴单位名称"`
  2216. YUnitNameEn string `description:"y轴单位名称(英文)"`
  2217. XMinValue string `description:"X轴的最小值"`
  2218. XMaxValue string `description:"X轴的最大值"`
  2219. YMinValue string `description:"Y轴的最小值"`
  2220. YMaxValue string `description:"Y轴的最大值"`
  2221. DataList []SectionScatterSeriesItemResp `description:"数据列"`
  2222. }
  2223. // SectionScatterSeriesItemResp 系列的返回
  2224. type SectionScatterSeriesItemResp struct {
  2225. Name string `description:"系列名"`
  2226. NameEn string `description:"系列名(英文)"`
  2227. IsNameDefault bool `description:"是否使用默认的系列名 false修改过 true默认 影响自动更新"`
  2228. Color string `description:"颜色"`
  2229. EdbInfoList []SectionScatterEdbItemResp
  2230. ShowTrendLine bool `description:"是否展示趋势线"`
  2231. ShowFitEquation bool `description:"是否展示方程式"`
  2232. ShowRSquare bool `description:"是否展示R平方"`
  2233. TrendLine string `description:"方程式"`
  2234. RSquare string `description:"R平方的值(决定系数R2)"`
  2235. TrendLimitData []CoordinatePoint `description:"趋势线的前后坐标点"`
  2236. }
  2237. // SectionScatterEdbItemResp 截面散点的返回参数
  2238. type SectionScatterEdbItemResp struct {
  2239. XEdbInfoId int `description:"X轴指标id"`
  2240. XDate string `description:"X轴指标实际日期"`
  2241. XName string `description:"X轴指标名称"`
  2242. XNameEn string `description:"X轴指标英文名称"`
  2243. XValue float64 `description:"X轴实际值"`
  2244. YEdbInfoId int `description:"Y轴指标id"`
  2245. YDate string `description:"Y轴指标实际日期"`
  2246. YName string `description:"Y轴指标名称"`
  2247. YNameEn string `description:"Y轴指标英文名称"`
  2248. YValue float64 `description:"Y轴实际值"`
  2249. IsShow bool `description:"是否展示"`
  2250. Name string `description:"标签名称"`
  2251. NameEn string `description:"英文标签名称"`
  2252. }
  2253. // CoordinatePoint 坐标点
  2254. type CoordinatePoint struct {
  2255. X float64
  2256. Y float64
  2257. }
  2258. // RollingCorrelationChartDataResp 滚动相关性图
  2259. type RollingCorrelationChartDataResp struct {
  2260. XDateTimeValue []string `description:"滚动相关性图的x轴数据,日期数据"`
  2261. YDataList []YData `description:"滚动相关性图的y轴数据"`
  2262. }
  2263. // GetChartInfoAll 用于分类展示
  2264. // @param source int 1:ETA图库;2:商品价格曲线
  2265. func GetChartInfoAllByClassifyId(source, classifyId int) (items []*ChartClassifyItems, err error) {
  2266. o := orm.NewOrmUsingDB("data")
  2267. sql := ` SELECT chart_info_id,chart_classify_id,chart_name AS chart_classify_name,chart_name_en AS chart_classify_name_en,
  2268. unique_code,sys_user_id,sys_user_real_name,date_type,start_date,end_date,chart_type,calendar,season_start_date,season_end_date,is_join_permission
  2269. FROM chart_info WHERE chart_classify_id = ? AND source = ? ORDER BY sort asc,create_time DESC `
  2270. _, err = o.Raw(sql, classifyId, source).QueryRows(&items)
  2271. return
  2272. }
  2273. // ProfitFutureGoodChartResp 商品利润图
  2274. type ProfitFutureGoodChartResp struct {
  2275. XDataList []XData
  2276. YDataList []YData
  2277. ProfitName string `description:"利润的名称"`
  2278. ProfitNameEn string `description:"利润的英文名称"`
  2279. }
  2280. func FIXChartClassifyId(newId, oldId int) (err error) {
  2281. o := orm.NewOrmUsingDB("data")
  2282. sql := ` UPDATE chart_info SET chart_classify_id=? WHERE chart_classify_id=? `
  2283. _, err = o.Raw(sql, newId, oldId).Exec()
  2284. return
  2285. }
  2286. // GetChartInfoByAdminIdAndClassify 获取所有我创建的图表,用于分类展示
  2287. func GetChartInfoByAdminIdAndClassify(sourceList []int, adminId, classifyId int) (items []*ChartClassifyItems, err error) {
  2288. num := len(sourceList)
  2289. if num <= 0 {
  2290. return
  2291. }
  2292. o := orm.NewOrmUsingDB("data")
  2293. sql := ` SELECT chart_info_id,chart_classify_id,chart_name AS chart_classify_name,
  2294. unique_code,sys_user_id,sys_user_real_name,date_type,start_date,end_date,chart_type,calendar,season_start_date,season_end_date,is_join_permission
  2295. FROM chart_info where source in (` + utils.GetOrmInReplace(num) + `) AND sys_user_id = ? AND chart_classify_id = ? ORDER BY sort asc,create_time ASC `
  2296. _, err = o.Raw(sql, sourceList, adminId, classifyId).QueryRows(&items)
  2297. return
  2298. }
  2299. // GetChartInfoAdminList 根据条件获取图表数据了列表
  2300. func GetChartInfoAdminList() (items []int, err error) {
  2301. o := orm.NewOrmUsingDB("data")
  2302. sql := ` SELECT sys_user_id FROM chart_info GROUP BY sys_user_id `
  2303. _, err = o.Raw(sql).QueryRows(&items)
  2304. return
  2305. }
  2306. // EditChartInfoExtraConfig 修改 ETA图库 的 图表额外配置
  2307. func EditChartInfoExtraConfig(chartId int, extraConfig string) (err error) {
  2308. o := orm.NewOrmUsingDB("data")
  2309. var pars []interface{}
  2310. pars = append(pars, extraConfig)
  2311. sql := ` UPDATE chart_info
  2312. SET
  2313. modify_time = NOW(),
  2314. extra_config = ?
  2315. `
  2316. sql += `WHERE chart_info_id = ?`
  2317. pars = append(pars, chartId)
  2318. _, err = o.Raw(sql, pars).Exec()
  2319. if err != nil {
  2320. fmt.Println("UPDATE chart_info Err:", err.Error())
  2321. return err
  2322. }
  2323. return
  2324. }
  2325. // PreviewRadarChartReq 预览雷达图的请求入参
  2326. type PreviewRadarChartReq struct {
  2327. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  2328. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  2329. }
  2330. // RadarChartInfoReq 雷达图预览请求数据
  2331. type RadarChartInfoReq struct {
  2332. DateList []RadarChartInfoDateReq `description:"日期配置"`
  2333. }
  2334. // RadarChartInfoEdbItemReq 雷达图预览请求数据(指标相关)
  2335. type RadarChartInfoEdbItemReq struct {
  2336. EdbInfoId int `description:"指标ID"`
  2337. Name string `description:"别名"`
  2338. //NameEn string `description:"英文别名"`
  2339. //Source int `description:"1:ETA图库;2:商品价格"`
  2340. }
  2341. // RadarChartInfoDateReq 雷达图预览请求数据(日期相关)
  2342. type RadarChartInfoDateReq struct {
  2343. Type int `description:"配置类型"`
  2344. Date string `description:"固定日期"`
  2345. Value int `description:"N天的值"`
  2346. Color string `description:"颜色"`
  2347. Name string `description:"别名"`
  2348. }
  2349. // RadarChartInfoResp 雷达图数据
  2350. type RadarChartInfoResp struct {
  2351. YDataList []RadarYData `description:"数据列"`
  2352. XEdbIdValue []int
  2353. }
  2354. // RadarYData 雷达图的y轴数据
  2355. type RadarYData struct {
  2356. Date string `description:"数据日期"`
  2357. Color string `description:"数据颜色"`
  2358. Name string `description:"别名"`
  2359. Value []float64 `description:"每个指标的值"`
  2360. }
  2361. // ChartInfoSourcesFrom 图表来源
  2362. type ChartInfoSourcesFrom struct {
  2363. IsShow bool `description:"是否展示" json:"isShow"`
  2364. Text string `description:"来源文本" json:"text"`
  2365. Color string `description:"来源颜色" json:"color"`
  2366. FontSize int `description:"来源字号" json:"fontSize"`
  2367. }
  2368. // UpdateChartInfoSortByClassifyIdV2 根据分类id更新排序
  2369. func UpdateChartInfoSortByClassifyIdV2(classifyId, nowSort int, prevChartInfoId int, updateSort string) (err error) {
  2370. o := orm.NewOrmUsingDB("data")
  2371. sql := ` update chart_info set sort = ` + updateSort + ` WHERE chart_classify_id = ?`
  2372. if prevChartInfoId > 0 {
  2373. sql += ` AND ( sort > ? or ( chart_info_id > ` + fmt.Sprint(prevChartInfoId) + ` and sort=` + fmt.Sprint(nowSort) + ` )) `
  2374. } else {
  2375. sql += ` AND ( sort > ? )`
  2376. }
  2377. _, err = o.Raw(sql, classifyId, nowSort).Exec()
  2378. return
  2379. }
  2380. // GetChartInfoMaxSortByClassifyId 获取分类下指标的最大的排序数
  2381. func GetChartInfoMaxSortByClassifyId(classifyId int) (sort int, err error) {
  2382. o := orm.NewOrmUsingDB("data")
  2383. sql := `SELECT Max(sort) AS sort FROM chart_info WHERE chart_classify_id = ? `
  2384. err = o.Raw(sql, classifyId).QueryRow(&sort)
  2385. return
  2386. }
  2387. // GetChartInfoBySourceAndParentId 根据图表来源及父级ID获取图表
  2388. func GetChartInfoBySourceAndParentId(source, parentId, adminId int) (items []*ChartClassifyItems, err error) {
  2389. o := orm.NewOrmUsingDB("data")
  2390. sql := ` SELECT chart_info_id,chart_classify_id,chart_name AS chart_classify_name,chart_name_en AS chart_classify_name_en,
  2391. unique_code,sys_user_id,sys_user_real_name,date_type,start_date,end_date,chart_type,calendar,season_start_date,season_end_date,source
  2392. FROM chart_info WHERE source = ? AND chart_classify_id = ?`
  2393. pars := make([]interface{}, 0)
  2394. pars = append(pars, source, parentId)
  2395. if adminId > 0 {
  2396. sql += ` AND sys_user_id = ?`
  2397. pars = append(pars, adminId)
  2398. }
  2399. sql += ` ORDER BY sort asc,chart_info_id ASC `
  2400. _, err = o.Raw(sql, pars).QueryRows(&items)
  2401. return
  2402. }
  2403. // PreviewSeasonChartReq 预览季节性图的请求入参
  2404. type PreviewSeasonChartReq struct {
  2405. ChartEdbInfoList []*ChartSaveItem `description:"指标及配置信息"`
  2406. SeasonExtraConfig SeasonExtraItem `description:"季节图额外配置信息,json字符串"`
  2407. }
  2408. // 截面组合图额外配置
  2409. type ChartSectionExtraConf struct {
  2410. DateConfList []*ChartSectionDateConfItem
  2411. IsHeap int `description:"是否堆积(1.堆积,0不堆积)"`
  2412. XDataList []XData `description:"横轴名称设置"`
  2413. UnitList *ChartSectionCombineUnit `description:"纵轴单位设置"`
  2414. BaseChartSeriesName string `description:"基准系列名称"`
  2415. SortType int `description:"排序类型,0默认,1升序,2降序"`
  2416. }
  2417. // 截面组合图额外配置
  2418. type ChartSectionAllExtraConf struct {
  2419. ChartSectionExtraConf
  2420. SeriesList []*ChartSectionSeriesItem
  2421. }
  2422. type ChartSectionDateConfItem struct {
  2423. MoveForward int `description:"前移的期数"`
  2424. EdbInfoId int `description:"指标ID"`
  2425. EdbName string `description:"指标名称"`
  2426. EdbNameEn string `description:"指标名称英文"`
  2427. EdbInfoType int `description:"指标类型"`
  2428. Frequency string `description:"频度"`
  2429. EndDate string `description:"最新日期"`
  2430. DateType int `description:"日期类型:0 指标日期,1系统日期"`
  2431. DateConfName string `description:"引用日期名称"` // 引用日期名称不能重复
  2432. DateConfNameEn string `description:"引用日期英文名称"`
  2433. DateChange []*ChartSectionDateChange
  2434. }
  2435. // 截面组合图引用日期配置
  2436. type ChartSectionDateChange struct {
  2437. Year int
  2438. Month int
  2439. Day int
  2440. Frequency string `description:"频度变换"`
  2441. FrequencyDay string `description:"频度的固定日期"`
  2442. ChangeType int `description:"日期变换类型1日期位移,2指定频率"`
  2443. }
  2444. // 截面组合图系列配置
  2445. type ChartSectionSeriesItem struct {
  2446. ChartSeriesId int `description:"系列ID"`
  2447. SeriesName string `description:"系列名称"` //系列名称不可同名
  2448. SeriesNameEn string `description:"系列英文名称"`
  2449. ChartStyle string `description:"图表类型"`
  2450. ChartColor string `description:"颜色"`
  2451. ChartWidth int `description:"线条大小"`
  2452. IsPoint int `description:"是否用数据点展示(0 否,1是)"`
  2453. IsNumber int `description:"是否用数值展示(0 否,1是)"`
  2454. IsAxis int `description:"1:左轴,0:右轴"`
  2455. MaxData float64 `description:"上限"`
  2456. MinData float64 `description:"下限"`
  2457. //IsOrder bool `description:"true:正序,false:逆序"`
  2458. EdbInfoList []*ChartSectionSeriesEdbConf
  2459. DataList []float64
  2460. NoDataEdbIndex []int
  2461. }
  2462. type ChartSectionSeriesEdbConf struct {
  2463. ChartSeriesEdbMappingId int `description:"映射ID"`
  2464. ChartSeriesId int `description:"系列ID"`
  2465. //ChartInfoId int `description:"图表ID"`
  2466. EdbInfoId int `description:"指标id"`
  2467. DateConf *ChartSectionSeriesDateConfItem
  2468. EdbName string `description:"中文别名"`
  2469. EdbNameEn string `description:"英文别名"`
  2470. EdbInfoType int `description:"指标类型"`
  2471. Unit string `description:"单位"`
  2472. UnitEn string `description:"英文单位"`
  2473. DateConfName string `description:"引用日期名称"`
  2474. DateConfType int `description:"日期类型,0指标最新日期, 1引用日期"`
  2475. }
  2476. type ChartSectionCombineDataResp struct {
  2477. DateConfList []*ChartSectionDateConfItem
  2478. IsHeap int `description:"是否堆积(1.堆积,0不堆积)"`
  2479. XDataList []XData `description:"横轴名称设置"`
  2480. UnitList *ChartSectionCombineUnit `description:"纵轴单位设置"`
  2481. BaseChartSeriesName string `description:"基准系列名称"`
  2482. SortType int `description:"排序类型,0默认,1升序,2降序"`
  2483. SeriesList []*ChartSectionSeriesItem
  2484. LeftMin string `description:"图表左侧最小值"`
  2485. LeftMax string `description:"图表左侧最大值"`
  2486. RightMin string `description:"图表右侧最小值"`
  2487. RightMax string `description:"图表右侧最大值"`
  2488. Right2Min string `description:"图表右侧最小值"`
  2489. Right2Max string `description:"图表右侧最大值"`
  2490. }
  2491. // 系列里的指标日期配置
  2492. type ChartSectionSeriesDateConfItem struct {
  2493. MoveForward int `description:"前移的期数"`
  2494. DateChange []*ChartSectionDateChange
  2495. }
  2496. // PreviewSectionCombineChartReq 预览截面组合图的请求
  2497. type PreviewSectionCombineChartReq struct {
  2498. ChartName string `description:"图表名称"`
  2499. ChartClassifyId int `description:"分类id"`
  2500. ExtraConfig string `description:"图表额外配置信息,json字符串"`
  2501. }
  2502. type ChartSectionCombineUnit struct {
  2503. LeftName string `description:"左轴单位"`
  2504. LeftNameEn string `description:"左轴英文单位"`
  2505. RightName string `description:"右轴单位"`
  2506. RightNameEn string `description:"右轴英文单位"`
  2507. RightTwoName string `description:"右2轴单位"`
  2508. RightTwoNameEn string `description:"右2轴英文单位"`
  2509. }
  2510. // EditChartInfoImageV2
  2511. // @Description: 修改图表的缩略图
  2512. // @author: Roc
  2513. // @datetime 2024-07-09 10:52:34
  2514. // @param chartInfoId int
  2515. // @param imageUrl string
  2516. // @return err error
  2517. func EditChartInfoImageV2(chartInfoId int, imageUrl string) (err error) {
  2518. o := orm.NewOrmUsingDB("data")
  2519. sql := ` UPDATE chart_info SET chart_image=?, modify_time = NOW() WHERE chart_info_id = ? `
  2520. _, err = o.Raw(sql, imageUrl, chartInfoId).Exec()
  2521. if err != nil {
  2522. fmt.Println("EditChartInfoImageV2 Err:", err.Error())
  2523. return err
  2524. }
  2525. return
  2526. }
  2527. // 时序组合图额外配置
  2528. type ChartTimeCombineExtraConf struct {
  2529. IsHeap int `description:"是否堆积(1.堆积,0不堆积)"`
  2530. }
  2531. type ChartTimeCombineDataResp struct {
  2532. IsHeap int `description:"是否堆积(1.堆积,0不堆积)"`
  2533. }