Dao.go 54 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037
  1. package manage
  2. import (
  3. "demo/configs"
  4. "demo/data/domain"
  5. "demo/data/domain/vo"
  6. )
  7. func GetArticleById(id int64) (domain.Article, error) {
  8. var article domain.Article
  9. _, err := configs.Engine.Table("article").Where("id = ?", id).Get(&article)
  10. if err != nil {
  11. return article, err
  12. }
  13. return article, nil
  14. }
  15. func GetArticleListInId(ids []int64) ([]domain.Article, error) {
  16. rows, err := configs.Engine.Table("article").In("id", ids).Rows(&domain.Article{})
  17. if err != nil {
  18. return make([]domain.Article, 0), err
  19. }
  20. defer rows.Close()
  21. var list []domain.Article
  22. for rows.Next() {
  23. var u domain.Article
  24. rows.Scan(&u)
  25. list = append(list, u)
  26. }
  27. return list, nil
  28. }
  29. func GetArticleList(article domain.Article, pageNum, pageSize int) (vo.BaseListVo, error) {
  30. var arr []domain.Article
  31. Count, err := configs.Engine.Table("article").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &article)
  32. var vo vo.BaseListVo
  33. if err != nil {
  34. return vo, err
  35. }
  36. if err != nil {
  37. return vo, err
  38. }
  39. vo.PageNum = pageNum
  40. vo.PageSize = pageSize
  41. vo.List = make([]any, len(arr))
  42. for i, v := range arr {
  43. vo.List[i] = v
  44. }
  45. vo.Total = int(Count)
  46. return vo, nil
  47. }
  48. func SaveArticle(article *domain.Article) (domain.Article, error) {
  49. _, err := configs.Engine.Table("article").Insert(&article)
  50. if err != nil {
  51. return *article, err
  52. }
  53. return *article, nil
  54. }
  55. func SetArticle(articleMap map[string]interface{}, id int64) (domain.Article, bool, error) {
  56. var article domain.Article
  57. _, err := configs.Engine.Table("article").Where("id = ?", id).Update(articleMap)
  58. if err != nil {
  59. return article, false, err
  60. }
  61. return article, true, nil
  62. }
  63. func DeleteArticle(id int64) bool {
  64. var article domain.Article
  65. i, err := configs.Engine.Table("article").Where("id = ?", id).Delete(&article)
  66. if err != nil {
  67. return false
  68. }
  69. return i > 0
  70. }
  71. func GetArticleTagById(id int64) (domain.ArticleTag, error) {
  72. var articleTag domain.ArticleTag
  73. _, err := configs.Engine.Table("articleTag").Where("id = ?", id).Get(&articleTag)
  74. if err != nil {
  75. return articleTag, err
  76. }
  77. return articleTag, nil
  78. }
  79. func GetArticleTagListInId(ids []int64) ([]domain.ArticleTag, error) {
  80. rows, err := configs.Engine.Table("articleTag").In("id", ids).Rows(&domain.ArticleTag{})
  81. if err != nil {
  82. return make([]domain.ArticleTag, 0), err
  83. }
  84. defer rows.Close()
  85. var list []domain.ArticleTag
  86. for rows.Next() {
  87. var u domain.ArticleTag
  88. rows.Scan(&u)
  89. list = append(list, u)
  90. }
  91. return list, nil
  92. }
  93. func GetArticleTagList(articleTag domain.ArticleTag, pageNum, pageSize int) (vo.BaseListVo, error) {
  94. var arr []domain.ArticleTag
  95. Count, err := configs.Engine.Table("articleTag").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &articleTag)
  96. var vo vo.BaseListVo
  97. if err != nil {
  98. return vo, err
  99. }
  100. if err != nil {
  101. return vo, err
  102. }
  103. vo.PageNum = pageNum
  104. vo.PageSize = pageSize
  105. vo.List = make([]any, len(arr))
  106. for i, v := range arr {
  107. vo.List[i] = v
  108. }
  109. vo.Total = int(Count)
  110. return vo, nil
  111. }
  112. func SaveArticleTag(articleTag *domain.ArticleTag) (domain.ArticleTag, error) {
  113. _, err := configs.Engine.Table("articleTag").Insert(&articleTag)
  114. if err != nil {
  115. return *articleTag, err
  116. }
  117. return *articleTag, nil
  118. }
  119. func SetArticleTag(articleTagMap map[string]interface{}, id int64) (domain.ArticleTag, bool, error) {
  120. var articleTag domain.ArticleTag
  121. _, err := configs.Engine.Table("articleTag").Where("id = ?", id).Update(articleTagMap)
  122. if err != nil {
  123. return articleTag, false, err
  124. }
  125. return articleTag, true, nil
  126. }
  127. func DeleteArticleTag(id int64) bool {
  128. var articleTag domain.ArticleTag
  129. i, err := configs.Engine.Table("articleTag").Where("id = ?", id).Delete(&articleTag)
  130. if err != nil {
  131. return false
  132. }
  133. return i > 0
  134. }
  135. func GetArticleTopicById(id int64) (domain.ArticleTopic, error) {
  136. var articleTopic domain.ArticleTopic
  137. _, err := configs.Engine.Table("articleTopic").Where("id = ?", id).Get(&articleTopic)
  138. if err != nil {
  139. return articleTopic, err
  140. }
  141. return articleTopic, nil
  142. }
  143. func GetArticleTopicListInId(ids []int64) ([]domain.ArticleTopic, error) {
  144. rows, err := configs.Engine.Table("articleTopic").In("id", ids).Rows(&domain.ArticleTopic{})
  145. if err != nil {
  146. return make([]domain.ArticleTopic, 0), err
  147. }
  148. defer rows.Close()
  149. var list []domain.ArticleTopic
  150. for rows.Next() {
  151. var u domain.ArticleTopic
  152. rows.Scan(&u)
  153. list = append(list, u)
  154. }
  155. return list, nil
  156. }
  157. func GetArticleTopicList(articleTopic domain.ArticleTopic, pageNum, pageSize int) (vo.BaseListVo, error) {
  158. var arr []domain.ArticleTopic
  159. Count, err := configs.Engine.Table("articleTopic").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &articleTopic)
  160. var vo vo.BaseListVo
  161. if err != nil {
  162. return vo, err
  163. }
  164. if err != nil {
  165. return vo, err
  166. }
  167. vo.PageNum = pageNum
  168. vo.PageSize = pageSize
  169. vo.List = make([]any, len(arr))
  170. for i, v := range arr {
  171. vo.List[i] = v
  172. }
  173. vo.Total = int(Count)
  174. return vo, nil
  175. }
  176. func SaveArticleTopic(articleTopic *domain.ArticleTopic) (domain.ArticleTopic, error) {
  177. _, err := configs.Engine.Table("articleTopic").Insert(&articleTopic)
  178. if err != nil {
  179. return *articleTopic, err
  180. }
  181. return *articleTopic, nil
  182. }
  183. func SetArticleTopic(articleTopicMap map[string]interface{}, id int64) (domain.ArticleTopic, bool, error) {
  184. var articleTopic domain.ArticleTopic
  185. _, err := configs.Engine.Table("articleTopic").Where("id = ?", id).Update(articleTopicMap)
  186. if err != nil {
  187. return articleTopic, false, err
  188. }
  189. return articleTopic, true, nil
  190. }
  191. func DeleteArticleTopic(id int64) bool {
  192. var articleTopic domain.ArticleTopic
  193. i, err := configs.Engine.Table("articleTopic").Where("id = ?", id).Delete(&articleTopic)
  194. if err != nil {
  195. return false
  196. }
  197. return i > 0
  198. }
  199. func GetBackAuthorityById(id int64) (domain.BackAuthority, error) {
  200. var backAuthority domain.BackAuthority
  201. _, err := configs.Engine.Table("backAuthority").Where("id = ?", id).Get(&backAuthority)
  202. if err != nil {
  203. return backAuthority, err
  204. }
  205. return backAuthority, nil
  206. }
  207. func GetBackAuthorityListInId(ids []int64) ([]domain.BackAuthority, error) {
  208. rows, err := configs.Engine.Table("backAuthority").In("id", ids).Rows(&domain.BackAuthority{})
  209. if err != nil {
  210. return make([]domain.BackAuthority, 0), err
  211. }
  212. defer rows.Close()
  213. var list []domain.BackAuthority
  214. for rows.Next() {
  215. var u domain.BackAuthority
  216. rows.Scan(&u)
  217. list = append(list, u)
  218. }
  219. return list, nil
  220. }
  221. func GetBackAuthorityList(backAuthority domain.BackAuthority, pageNum, pageSize int) (vo.BaseListVo, error) {
  222. var arr []domain.BackAuthority
  223. Count, err := configs.Engine.Table("backAuthority").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &backAuthority)
  224. var vo vo.BaseListVo
  225. if err != nil {
  226. return vo, err
  227. }
  228. if err != nil {
  229. return vo, err
  230. }
  231. vo.PageNum = pageNum
  232. vo.PageSize = pageSize
  233. vo.List = make([]any, len(arr))
  234. for i, v := range arr {
  235. vo.List[i] = v
  236. }
  237. vo.Total = int(Count)
  238. return vo, nil
  239. }
  240. func SaveBackAuthority(backAuthority *domain.BackAuthority) (domain.BackAuthority, error) {
  241. _, err := configs.Engine.Table("backAuthority").Insert(&backAuthority)
  242. if err != nil {
  243. return *backAuthority, err
  244. }
  245. return *backAuthority, nil
  246. }
  247. func SetBackAuthority(backAuthorityMap map[string]interface{}, id int64) (domain.BackAuthority, bool, error) {
  248. var backAuthority domain.BackAuthority
  249. _, err := configs.Engine.Table("backAuthority").Where("id = ?", id).Update(backAuthorityMap)
  250. if err != nil {
  251. return backAuthority, false, err
  252. }
  253. return backAuthority, true, nil
  254. }
  255. func DeleteBackAuthority(id int64) bool {
  256. var backAuthority domain.BackAuthority
  257. i, err := configs.Engine.Table("backAuthority").Where("id = ?", id).Delete(&backAuthority)
  258. if err != nil {
  259. return false
  260. }
  261. return i > 0
  262. }
  263. func GetBackMenuById(id int64) (domain.BackMenu, error) {
  264. var backMenu domain.BackMenu
  265. _, err := configs.Engine.Table("backMenu").Where("id = ?", id).Get(&backMenu)
  266. if err != nil {
  267. return backMenu, err
  268. }
  269. return backMenu, nil
  270. }
  271. func GetBackMenuListInId(ids []int64) ([]domain.BackMenu, error) {
  272. rows, err := configs.Engine.Table("backMenu").In("id", ids).Rows(&domain.BackMenu{})
  273. if err != nil {
  274. return make([]domain.BackMenu, 0), err
  275. }
  276. defer rows.Close()
  277. var list []domain.BackMenu
  278. for rows.Next() {
  279. var u domain.BackMenu
  280. rows.Scan(&u)
  281. list = append(list, u)
  282. }
  283. return list, nil
  284. }
  285. func GetBackMenuList(backMenu domain.BackMenu, pageNum, pageSize int) (vo.BaseListVo, error) {
  286. var arr []domain.BackMenu
  287. Count, err := configs.Engine.Table("backMenu").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &backMenu)
  288. var vo vo.BaseListVo
  289. if err != nil {
  290. return vo, err
  291. }
  292. if err != nil {
  293. return vo, err
  294. }
  295. vo.PageNum = pageNum
  296. vo.PageSize = pageSize
  297. vo.List = make([]any, len(arr))
  298. for i, v := range arr {
  299. vo.List[i] = v
  300. }
  301. vo.Total = int(Count)
  302. return vo, nil
  303. }
  304. func SaveBackMenu(backMenu *domain.BackMenu) (domain.BackMenu, error) {
  305. _, err := configs.Engine.Table("backMenu").Insert(&backMenu)
  306. if err != nil {
  307. return *backMenu, err
  308. }
  309. return *backMenu, nil
  310. }
  311. func SetBackMenu(backMenuMap map[string]interface{}, id int64) (domain.BackMenu, bool, error) {
  312. var backMenu domain.BackMenu
  313. _, err := configs.Engine.Table("backMenu").Where("id = ?", id).Update(backMenuMap)
  314. if err != nil {
  315. return backMenu, false, err
  316. }
  317. return backMenu, true, nil
  318. }
  319. func DeleteBackMenu(id int64) bool {
  320. var backMenu domain.BackMenu
  321. i, err := configs.Engine.Table("backMenu").Where("id = ?", id).Delete(&backMenu)
  322. if err != nil {
  323. return false
  324. }
  325. return i > 0
  326. }
  327. func GetBackRoleById(id int64) (domain.BackRole, error) {
  328. var backRole domain.BackRole
  329. _, err := configs.Engine.Table("backRole").Where("id = ?", id).Get(&backRole)
  330. if err != nil {
  331. return backRole, err
  332. }
  333. return backRole, nil
  334. }
  335. func GetBackRoleListInId(ids []int64) ([]domain.BackRole, error) {
  336. rows, err := configs.Engine.Table("backRole").In("id", ids).Rows(&domain.BackRole{})
  337. if err != nil {
  338. return make([]domain.BackRole, 0), err
  339. }
  340. defer rows.Close()
  341. var list []domain.BackRole
  342. for rows.Next() {
  343. var u domain.BackRole
  344. rows.Scan(&u)
  345. list = append(list, u)
  346. }
  347. return list, nil
  348. }
  349. func GetBackRoleList(backRole domain.BackRole, pageNum, pageSize int) (vo.BaseListVo, error) {
  350. var arr []domain.BackRole
  351. Count, err := configs.Engine.Table("backRole").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &backRole)
  352. var vo vo.BaseListVo
  353. if err != nil {
  354. return vo, err
  355. }
  356. if err != nil {
  357. return vo, err
  358. }
  359. vo.PageNum = pageNum
  360. vo.PageSize = pageSize
  361. vo.List = make([]any, len(arr))
  362. for i, v := range arr {
  363. vo.List[i] = v
  364. }
  365. vo.Total = int(Count)
  366. return vo, nil
  367. }
  368. func SaveBackRole(backRole *domain.BackRole) (domain.BackRole, error) {
  369. _, err := configs.Engine.Table("backRole").Insert(&backRole)
  370. if err != nil {
  371. return *backRole, err
  372. }
  373. return *backRole, nil
  374. }
  375. func SetBackRole(backRoleMap map[string]interface{}, id int64) (domain.BackRole, bool, error) {
  376. var backRole domain.BackRole
  377. _, err := configs.Engine.Table("backRole").Where("id = ?", id).Update(backRoleMap)
  378. if err != nil {
  379. return backRole, false, err
  380. }
  381. return backRole, true, nil
  382. }
  383. func DeleteBackRole(id int64) bool {
  384. var backRole domain.BackRole
  385. i, err := configs.Engine.Table("backRole").Where("id = ?", id).Delete(&backRole)
  386. if err != nil {
  387. return false
  388. }
  389. return i > 0
  390. }
  391. func GetBackRoleAuthorityById(id int64) (domain.BackRoleAuthority, error) {
  392. var backRoleAuthority domain.BackRoleAuthority
  393. _, err := configs.Engine.Table("backRoleAuthority").Where("id = ?", id).Get(&backRoleAuthority)
  394. if err != nil {
  395. return backRoleAuthority, err
  396. }
  397. return backRoleAuthority, nil
  398. }
  399. func GetBackRoleAuthorityListInId(ids []int64) ([]domain.BackRoleAuthority, error) {
  400. rows, err := configs.Engine.Table("backRoleAuthority").In("id", ids).Rows(&domain.BackRoleAuthority{})
  401. if err != nil {
  402. return make([]domain.BackRoleAuthority, 0), err
  403. }
  404. defer rows.Close()
  405. var list []domain.BackRoleAuthority
  406. for rows.Next() {
  407. var u domain.BackRoleAuthority
  408. rows.Scan(&u)
  409. list = append(list, u)
  410. }
  411. return list, nil
  412. }
  413. func GetBackRoleAuthorityList(backRoleAuthority domain.BackRoleAuthority, pageNum, pageSize int) (vo.BaseListVo, error) {
  414. var arr []domain.BackRoleAuthority
  415. Count, err := configs.Engine.Table("backRoleAuthority").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &backRoleAuthority)
  416. var vo vo.BaseListVo
  417. if err != nil {
  418. return vo, err
  419. }
  420. if err != nil {
  421. return vo, err
  422. }
  423. vo.PageNum = pageNum
  424. vo.PageSize = pageSize
  425. vo.List = make([]any, len(arr))
  426. for i, v := range arr {
  427. vo.List[i] = v
  428. }
  429. vo.Total = int(Count)
  430. return vo, nil
  431. }
  432. func SaveBackRoleAuthority(backRoleAuthority *domain.BackRoleAuthority) (domain.BackRoleAuthority, error) {
  433. _, err := configs.Engine.Table("backRoleAuthority").Insert(&backRoleAuthority)
  434. if err != nil {
  435. return *backRoleAuthority, err
  436. }
  437. return *backRoleAuthority, nil
  438. }
  439. func SetBackRoleAuthority(backRoleAuthorityMap map[string]interface{}, id int64) (domain.BackRoleAuthority, bool, error) {
  440. var backRoleAuthority domain.BackRoleAuthority
  441. _, err := configs.Engine.Table("backRoleAuthority").Where("id = ?", id).Update(backRoleAuthorityMap)
  442. if err != nil {
  443. return backRoleAuthority, false, err
  444. }
  445. return backRoleAuthority, true, nil
  446. }
  447. func DeleteBackRoleAuthority(id int64) bool {
  448. var backRoleAuthority domain.BackRoleAuthority
  449. i, err := configs.Engine.Table("backRoleAuthority").Where("id = ?", id).Delete(&backRoleAuthority)
  450. if err != nil {
  451. return false
  452. }
  453. return i > 0
  454. }
  455. func GetBackRoleMenuById(id int64) (domain.BackRoleMenu, error) {
  456. var backRoleMenu domain.BackRoleMenu
  457. _, err := configs.Engine.Table("backRoleMenu").Where("id = ?", id).Get(&backRoleMenu)
  458. if err != nil {
  459. return backRoleMenu, err
  460. }
  461. return backRoleMenu, nil
  462. }
  463. func GetBackRoleMenuListInId(ids []int64) ([]domain.BackRoleMenu, error) {
  464. rows, err := configs.Engine.Table("backRoleMenu").In("id", ids).Rows(&domain.BackRoleMenu{})
  465. if err != nil {
  466. return make([]domain.BackRoleMenu, 0), err
  467. }
  468. defer rows.Close()
  469. var list []domain.BackRoleMenu
  470. for rows.Next() {
  471. var u domain.BackRoleMenu
  472. rows.Scan(&u)
  473. list = append(list, u)
  474. }
  475. return list, nil
  476. }
  477. func GetBackRoleMenuList(backRoleMenu domain.BackRoleMenu, pageNum, pageSize int) (vo.BaseListVo, error) {
  478. var arr []domain.BackRoleMenu
  479. Count, err := configs.Engine.Table("backRoleMenu").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &backRoleMenu)
  480. var vo vo.BaseListVo
  481. if err != nil {
  482. return vo, err
  483. }
  484. if err != nil {
  485. return vo, err
  486. }
  487. vo.PageNum = pageNum
  488. vo.PageSize = pageSize
  489. vo.List = make([]any, len(arr))
  490. for i, v := range arr {
  491. vo.List[i] = v
  492. }
  493. vo.Total = int(Count)
  494. return vo, nil
  495. }
  496. func SaveBackRoleMenu(backRoleMenu *domain.BackRoleMenu) (domain.BackRoleMenu, error) {
  497. _, err := configs.Engine.Table("backRoleMenu").Insert(&backRoleMenu)
  498. if err != nil {
  499. return *backRoleMenu, err
  500. }
  501. return *backRoleMenu, nil
  502. }
  503. func SetBackRoleMenu(backRoleMenuMap map[string]interface{}, id int64) (domain.BackRoleMenu, bool, error) {
  504. var backRoleMenu domain.BackRoleMenu
  505. _, err := configs.Engine.Table("backRoleMenu").Where("id = ?", id).Update(backRoleMenuMap)
  506. if err != nil {
  507. return backRoleMenu, false, err
  508. }
  509. return backRoleMenu, true, nil
  510. }
  511. func DeleteBackRoleMenu(id int64) bool {
  512. var backRoleMenu domain.BackRoleMenu
  513. i, err := configs.Engine.Table("backRoleMenu").Where("id = ?", id).Delete(&backRoleMenu)
  514. if err != nil {
  515. return false
  516. }
  517. return i > 0
  518. }
  519. func GetGenTableById(id int64) (domain.GenTable, error) {
  520. var genTable domain.GenTable
  521. _, err := configs.Engine.Table("genTable").Where("id = ?", id).Get(&genTable)
  522. if err != nil {
  523. return genTable, err
  524. }
  525. return genTable, nil
  526. }
  527. func GetGenTableListInId(ids []int64) ([]domain.GenTable, error) {
  528. rows, err := configs.Engine.Table("genTable").In("id", ids).Rows(&domain.GenTable{})
  529. if err != nil {
  530. return make([]domain.GenTable, 0), err
  531. }
  532. defer rows.Close()
  533. var list []domain.GenTable
  534. for rows.Next() {
  535. var u domain.GenTable
  536. rows.Scan(&u)
  537. list = append(list, u)
  538. }
  539. return list, nil
  540. }
  541. func GetGenTableList(genTable domain.GenTable, pageNum, pageSize int) (vo.BaseListVo, error) {
  542. var arr []domain.GenTable
  543. Count, err := configs.Engine.Table("genTable").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &genTable)
  544. var vo vo.BaseListVo
  545. if err != nil {
  546. return vo, err
  547. }
  548. if err != nil {
  549. return vo, err
  550. }
  551. vo.PageNum = pageNum
  552. vo.PageSize = pageSize
  553. vo.List = make([]any, len(arr))
  554. for i, v := range arr {
  555. vo.List[i] = v
  556. }
  557. vo.Total = int(Count)
  558. return vo, nil
  559. }
  560. func SaveGenTable(genTable *domain.GenTable) (domain.GenTable, error) {
  561. _, err := configs.Engine.Table("genTable").Insert(&genTable)
  562. if err != nil {
  563. return *genTable, err
  564. }
  565. return *genTable, nil
  566. }
  567. func SetGenTable(genTableMap map[string]interface{}, id int64) (domain.GenTable, bool, error) {
  568. var genTable domain.GenTable
  569. _, err := configs.Engine.Table("genTable").Where("id = ?", id).Update(genTableMap)
  570. if err != nil {
  571. return genTable, false, err
  572. }
  573. return genTable, true, nil
  574. }
  575. func DeleteGenTable(id int64) bool {
  576. var genTable domain.GenTable
  577. i, err := configs.Engine.Table("genTable").Where("id = ?", id).Delete(&genTable)
  578. if err != nil {
  579. return false
  580. }
  581. return i > 0
  582. }
  583. func GetGenTableColumnById(id int64) (domain.GenTableColumn, error) {
  584. var genTableColumn domain.GenTableColumn
  585. _, err := configs.Engine.Table("genTableColumn").Where("id = ?", id).Get(&genTableColumn)
  586. if err != nil {
  587. return genTableColumn, err
  588. }
  589. return genTableColumn, nil
  590. }
  591. func GetGenTableColumnListInId(ids []int64) ([]domain.GenTableColumn, error) {
  592. rows, err := configs.Engine.Table("genTableColumn").In("id", ids).Rows(&domain.GenTableColumn{})
  593. if err != nil {
  594. return make([]domain.GenTableColumn, 0), err
  595. }
  596. defer rows.Close()
  597. var list []domain.GenTableColumn
  598. for rows.Next() {
  599. var u domain.GenTableColumn
  600. rows.Scan(&u)
  601. list = append(list, u)
  602. }
  603. return list, nil
  604. }
  605. func GetGenTableColumnList(genTableColumn domain.GenTableColumn, pageNum, pageSize int) (vo.BaseListVo, error) {
  606. var arr []domain.GenTableColumn
  607. Count, err := configs.Engine.Table("genTableColumn").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &genTableColumn)
  608. var vo vo.BaseListVo
  609. if err != nil {
  610. return vo, err
  611. }
  612. if err != nil {
  613. return vo, err
  614. }
  615. vo.PageNum = pageNum
  616. vo.PageSize = pageSize
  617. vo.List = make([]any, len(arr))
  618. for i, v := range arr {
  619. vo.List[i] = v
  620. }
  621. vo.Total = int(Count)
  622. return vo, nil
  623. }
  624. func SaveGenTableColumn(genTableColumn *domain.GenTableColumn) (domain.GenTableColumn, error) {
  625. _, err := configs.Engine.Table("genTableColumn").Insert(&genTableColumn)
  626. if err != nil {
  627. return *genTableColumn, err
  628. }
  629. return *genTableColumn, nil
  630. }
  631. func SetGenTableColumn(genTableColumnMap map[string]interface{}, id int64) (domain.GenTableColumn, bool, error) {
  632. var genTableColumn domain.GenTableColumn
  633. _, err := configs.Engine.Table("genTableColumn").Where("id = ?", id).Update(genTableColumnMap)
  634. if err != nil {
  635. return genTableColumn, false, err
  636. }
  637. return genTableColumn, true, nil
  638. }
  639. func DeleteGenTableColumn(id int64) bool {
  640. var genTableColumn domain.GenTableColumn
  641. i, err := configs.Engine.Table("genTableColumn").Where("id = ?", id).Delete(&genTableColumn)
  642. if err != nil {
  643. return false
  644. }
  645. return i > 0
  646. }
  647. func GetGoodsById(id int64) (domain.Goods, error) {
  648. var goods domain.Goods
  649. _, err := configs.Engine.Table("goods").Where("id = ?", id).Get(&goods)
  650. if err != nil {
  651. return goods, err
  652. }
  653. return goods, nil
  654. }
  655. func GetGoodsListInId(ids []int64) ([]domain.Goods, error) {
  656. rows, err := configs.Engine.Table("goods").In("id", ids).Rows(&domain.Goods{})
  657. if err != nil {
  658. return make([]domain.Goods, 0), err
  659. }
  660. defer rows.Close()
  661. var list []domain.Goods
  662. for rows.Next() {
  663. var u domain.Goods
  664. rows.Scan(&u)
  665. list = append(list, u)
  666. }
  667. return list, nil
  668. }
  669. func GetGoodsList(goods domain.Goods, pageNum, pageSize int) (vo.BaseListVo, error) {
  670. var arr []domain.Goods
  671. Count, err := configs.Engine.Table("goods").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goods)
  672. var vo vo.BaseListVo
  673. if err != nil {
  674. return vo, err
  675. }
  676. if err != nil {
  677. return vo, err
  678. }
  679. vo.PageNum = pageNum
  680. vo.PageSize = pageSize
  681. vo.List = make([]any, len(arr))
  682. for i, v := range arr {
  683. vo.List[i] = v
  684. }
  685. vo.Total = int(Count)
  686. return vo, nil
  687. }
  688. func SaveGoods(goods *domain.Goods) (domain.Goods, error) {
  689. _, err := configs.Engine.Table("goods").Insert(&goods)
  690. if err != nil {
  691. return *goods, err
  692. }
  693. return *goods, nil
  694. }
  695. func SetGoods(goodsMap map[string]interface{}, id int64) (domain.Goods, bool, error) {
  696. var goods domain.Goods
  697. _, err := configs.Engine.Table("goods").Where("id = ?", id).Update(goodsMap)
  698. if err != nil {
  699. return goods, false, err
  700. }
  701. return goods, true, nil
  702. }
  703. func DeleteGoods(id int64) bool {
  704. var goods domain.Goods
  705. i, err := configs.Engine.Table("goods").Where("id = ?", id).Delete(&goods)
  706. if err != nil {
  707. return false
  708. }
  709. return i > 0
  710. }
  711. func GetGoodsCommodityAreaById(id int64) (domain.GoodsCommodityArea, error) {
  712. var goodsCommodityArea domain.GoodsCommodityArea
  713. _, err := configs.Engine.Table("goodsCommodityArea").Where("id = ?", id).Get(&goodsCommodityArea)
  714. if err != nil {
  715. return goodsCommodityArea, err
  716. }
  717. return goodsCommodityArea, nil
  718. }
  719. func GetGoodsCommodityAreaListInId(ids []int64) ([]domain.GoodsCommodityArea, error) {
  720. rows, err := configs.Engine.Table("goodsCommodityArea").In("id", ids).Rows(&domain.GoodsCommodityArea{})
  721. if err != nil {
  722. return make([]domain.GoodsCommodityArea, 0), err
  723. }
  724. defer rows.Close()
  725. var list []domain.GoodsCommodityArea
  726. for rows.Next() {
  727. var u domain.GoodsCommodityArea
  728. rows.Scan(&u)
  729. list = append(list, u)
  730. }
  731. return list, nil
  732. }
  733. func GetGoodsCommodityAreaList(goodsCommodityArea domain.GoodsCommodityArea, pageNum, pageSize int) (vo.BaseListVo, error) {
  734. var arr []domain.GoodsCommodityArea
  735. Count, err := configs.Engine.Table("goodsCommodityArea").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsCommodityArea)
  736. var vo vo.BaseListVo
  737. if err != nil {
  738. return vo, err
  739. }
  740. if err != nil {
  741. return vo, err
  742. }
  743. vo.PageNum = pageNum
  744. vo.PageSize = pageSize
  745. vo.List = make([]any, len(arr))
  746. for i, v := range arr {
  747. vo.List[i] = v
  748. }
  749. vo.Total = int(Count)
  750. return vo, nil
  751. }
  752. func SaveGoodsCommodityArea(goodsCommodityArea *domain.GoodsCommodityArea) (domain.GoodsCommodityArea, error) {
  753. _, err := configs.Engine.Table("goodsCommodityArea").Insert(&goodsCommodityArea)
  754. if err != nil {
  755. return *goodsCommodityArea, err
  756. }
  757. return *goodsCommodityArea, nil
  758. }
  759. func SetGoodsCommodityArea(goodsCommodityAreaMap map[string]interface{}, id int64) (domain.GoodsCommodityArea, bool, error) {
  760. var goodsCommodityArea domain.GoodsCommodityArea
  761. _, err := configs.Engine.Table("goodsCommodityArea").Where("id = ?", id).Update(goodsCommodityAreaMap)
  762. if err != nil {
  763. return goodsCommodityArea, false, err
  764. }
  765. return goodsCommodityArea, true, nil
  766. }
  767. func DeleteGoodsCommodityArea(id int64) bool {
  768. var goodsCommodityArea domain.GoodsCommodityArea
  769. i, err := configs.Engine.Table("goodsCommodityArea").Where("id = ?", id).Delete(&goodsCommodityArea)
  770. if err != nil {
  771. return false
  772. }
  773. return i > 0
  774. }
  775. func GetGoodsCouponById(id int64) (domain.GoodsCoupon, error) {
  776. var goodsCoupon domain.GoodsCoupon
  777. _, err := configs.Engine.Table("goodsCoupon").Where("id = ?", id).Get(&goodsCoupon)
  778. if err != nil {
  779. return goodsCoupon, err
  780. }
  781. return goodsCoupon, nil
  782. }
  783. func GetGoodsCouponListInId(ids []int64) ([]domain.GoodsCoupon, error) {
  784. rows, err := configs.Engine.Table("goodsCoupon").In("id", ids).Rows(&domain.GoodsCoupon{})
  785. if err != nil {
  786. return make([]domain.GoodsCoupon, 0), err
  787. }
  788. defer rows.Close()
  789. var list []domain.GoodsCoupon
  790. for rows.Next() {
  791. var u domain.GoodsCoupon
  792. rows.Scan(&u)
  793. list = append(list, u)
  794. }
  795. return list, nil
  796. }
  797. func GetGoodsCouponList(goodsCoupon domain.GoodsCoupon, pageNum, pageSize int) (vo.BaseListVo, error) {
  798. var arr []domain.GoodsCoupon
  799. Count, err := configs.Engine.Table("goodsCoupon").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsCoupon)
  800. var vo vo.BaseListVo
  801. if err != nil {
  802. return vo, err
  803. }
  804. if err != nil {
  805. return vo, err
  806. }
  807. vo.PageNum = pageNum
  808. vo.PageSize = pageSize
  809. vo.List = make([]any, len(arr))
  810. for i, v := range arr {
  811. vo.List[i] = v
  812. }
  813. vo.Total = int(Count)
  814. return vo, nil
  815. }
  816. func SaveGoodsCoupon(goodsCoupon *domain.GoodsCoupon) (domain.GoodsCoupon, error) {
  817. _, err := configs.Engine.Table("goodsCoupon").Insert(&goodsCoupon)
  818. if err != nil {
  819. return *goodsCoupon, err
  820. }
  821. return *goodsCoupon, nil
  822. }
  823. func SetGoodsCoupon(goodsCouponMap map[string]interface{}, id int64) (domain.GoodsCoupon, bool, error) {
  824. var goodsCoupon domain.GoodsCoupon
  825. _, err := configs.Engine.Table("goodsCoupon").Where("id = ?", id).Update(goodsCouponMap)
  826. if err != nil {
  827. return goodsCoupon, false, err
  828. }
  829. return goodsCoupon, true, nil
  830. }
  831. func DeleteGoodsCoupon(id int64) bool {
  832. var goodsCoupon domain.GoodsCoupon
  833. i, err := configs.Engine.Table("goodsCoupon").Where("id = ?", id).Delete(&goodsCoupon)
  834. if err != nil {
  835. return false
  836. }
  837. return i > 0
  838. }
  839. func GetGoodsCouponUserById(id int64) (domain.GoodsCouponUser, error) {
  840. var goodsCouponUser domain.GoodsCouponUser
  841. _, err := configs.Engine.Table("goodsCouponUser").Where("id = ?", id).Get(&goodsCouponUser)
  842. if err != nil {
  843. return goodsCouponUser, err
  844. }
  845. return goodsCouponUser, nil
  846. }
  847. func GetGoodsCouponUserListInId(ids []int64) ([]domain.GoodsCouponUser, error) {
  848. rows, err := configs.Engine.Table("goodsCouponUser").In("id", ids).Rows(&domain.GoodsCouponUser{})
  849. if err != nil {
  850. return make([]domain.GoodsCouponUser, 0), err
  851. }
  852. defer rows.Close()
  853. var list []domain.GoodsCouponUser
  854. for rows.Next() {
  855. var u domain.GoodsCouponUser
  856. rows.Scan(&u)
  857. list = append(list, u)
  858. }
  859. return list, nil
  860. }
  861. func GetGoodsCouponUserList(goodsCouponUser domain.GoodsCouponUser, pageNum, pageSize int) (vo.BaseListVo, error) {
  862. var arr []domain.GoodsCouponUser
  863. Count, err := configs.Engine.Table("goodsCouponUser").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsCouponUser)
  864. var vo vo.BaseListVo
  865. if err != nil {
  866. return vo, err
  867. }
  868. if err != nil {
  869. return vo, err
  870. }
  871. vo.PageNum = pageNum
  872. vo.PageSize = pageSize
  873. vo.List = make([]any, len(arr))
  874. for i, v := range arr {
  875. vo.List[i] = v
  876. }
  877. vo.Total = int(Count)
  878. return vo, nil
  879. }
  880. func SaveGoodsCouponUser(goodsCouponUser *domain.GoodsCouponUser) (domain.GoodsCouponUser, error) {
  881. _, err := configs.Engine.Table("goodsCouponUser").Insert(&goodsCouponUser)
  882. if err != nil {
  883. return *goodsCouponUser, err
  884. }
  885. return *goodsCouponUser, nil
  886. }
  887. func SetGoodsCouponUser(goodsCouponUserMap map[string]interface{}, id int64) (domain.GoodsCouponUser, bool, error) {
  888. var goodsCouponUser domain.GoodsCouponUser
  889. _, err := configs.Engine.Table("goodsCouponUser").Where("id = ?", id).Update(goodsCouponUserMap)
  890. if err != nil {
  891. return goodsCouponUser, false, err
  892. }
  893. return goodsCouponUser, true, nil
  894. }
  895. func DeleteGoodsCouponUser(id int64) bool {
  896. var goodsCouponUser domain.GoodsCouponUser
  897. i, err := configs.Engine.Table("goodsCouponUser").Where("id = ?", id).Delete(&goodsCouponUser)
  898. if err != nil {
  899. return false
  900. }
  901. return i > 0
  902. }
  903. func GetGoodsIntroductionById(id int64) (domain.GoodsIntroduction, error) {
  904. var goodsIntroduction domain.GoodsIntroduction
  905. _, err := configs.Engine.Table("goodsIntroduction").Where("id = ?", id).Get(&goodsIntroduction)
  906. if err != nil {
  907. return goodsIntroduction, err
  908. }
  909. return goodsIntroduction, nil
  910. }
  911. func GetGoodsIntroductionListInId(ids []int64) ([]domain.GoodsIntroduction, error) {
  912. rows, err := configs.Engine.Table("goodsIntroduction").In("id", ids).Rows(&domain.GoodsIntroduction{})
  913. if err != nil {
  914. return make([]domain.GoodsIntroduction, 0), err
  915. }
  916. defer rows.Close()
  917. var list []domain.GoodsIntroduction
  918. for rows.Next() {
  919. var u domain.GoodsIntroduction
  920. rows.Scan(&u)
  921. list = append(list, u)
  922. }
  923. return list, nil
  924. }
  925. func GetGoodsIntroductionList(goodsIntroduction domain.GoodsIntroduction, pageNum, pageSize int) (vo.BaseListVo, error) {
  926. var arr []domain.GoodsIntroduction
  927. Count, err := configs.Engine.Table("goodsIntroduction").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsIntroduction)
  928. var vo vo.BaseListVo
  929. if err != nil {
  930. return vo, err
  931. }
  932. if err != nil {
  933. return vo, err
  934. }
  935. vo.PageNum = pageNum
  936. vo.PageSize = pageSize
  937. vo.List = make([]any, len(arr))
  938. for i, v := range arr {
  939. vo.List[i] = v
  940. }
  941. vo.Total = int(Count)
  942. return vo, nil
  943. }
  944. func SaveGoodsIntroduction(goodsIntroduction *domain.GoodsIntroduction) (domain.GoodsIntroduction, error) {
  945. _, err := configs.Engine.Table("goodsIntroduction").Insert(&goodsIntroduction)
  946. if err != nil {
  947. return *goodsIntroduction, err
  948. }
  949. return *goodsIntroduction, nil
  950. }
  951. func SetGoodsIntroduction(goodsIntroductionMap map[string]interface{}, id int64) (domain.GoodsIntroduction, bool, error) {
  952. var goodsIntroduction domain.GoodsIntroduction
  953. _, err := configs.Engine.Table("goodsIntroduction").Where("id = ?", id).Update(goodsIntroductionMap)
  954. if err != nil {
  955. return goodsIntroduction, false, err
  956. }
  957. return goodsIntroduction, true, nil
  958. }
  959. func DeleteGoodsIntroduction(id int64) bool {
  960. var goodsIntroduction domain.GoodsIntroduction
  961. i, err := configs.Engine.Table("goodsIntroduction").Where("id = ?", id).Delete(&goodsIntroduction)
  962. if err != nil {
  963. return false
  964. }
  965. return i > 0
  966. }
  967. func GetGoodsOrderById(id int64) (domain.GoodsOrder, error) {
  968. var goodsOrder domain.GoodsOrder
  969. _, err := configs.Engine.Table("goodsOrder").Where("id = ?", id).Get(&goodsOrder)
  970. if err != nil {
  971. return goodsOrder, err
  972. }
  973. return goodsOrder, nil
  974. }
  975. func GetGoodsOrderListInId(ids []int64) ([]domain.GoodsOrder, error) {
  976. rows, err := configs.Engine.Table("goodsOrder").In("id", ids).Rows(&domain.GoodsOrder{})
  977. if err != nil {
  978. return make([]domain.GoodsOrder, 0), err
  979. }
  980. defer rows.Close()
  981. var list []domain.GoodsOrder
  982. for rows.Next() {
  983. var u domain.GoodsOrder
  984. rows.Scan(&u)
  985. list = append(list, u)
  986. }
  987. return list, nil
  988. }
  989. func GetGoodsOrderList(goodsOrder domain.GoodsOrder, pageNum, pageSize int) (vo.BaseListVo, error) {
  990. var arr []domain.GoodsOrder
  991. Count, err := configs.Engine.Table("goodsOrder").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsOrder)
  992. var vo vo.BaseListVo
  993. if err != nil {
  994. return vo, err
  995. }
  996. if err != nil {
  997. return vo, err
  998. }
  999. vo.PageNum = pageNum
  1000. vo.PageSize = pageSize
  1001. vo.List = make([]any, len(arr))
  1002. for i, v := range arr {
  1003. vo.List[i] = v
  1004. }
  1005. vo.Total = int(Count)
  1006. return vo, nil
  1007. }
  1008. func SaveGoodsOrder(goodsOrder *domain.GoodsOrder) (domain.GoodsOrder, error) {
  1009. _, err := configs.Engine.Table("goodsOrder").Insert(&goodsOrder)
  1010. if err != nil {
  1011. return *goodsOrder, err
  1012. }
  1013. return *goodsOrder, nil
  1014. }
  1015. func SetGoodsOrder(goodsOrderMap map[string]interface{}, id int64) (domain.GoodsOrder, bool, error) {
  1016. var goodsOrder domain.GoodsOrder
  1017. _, err := configs.Engine.Table("goodsOrder").Where("id = ?", id).Update(goodsOrderMap)
  1018. if err != nil {
  1019. return goodsOrder, false, err
  1020. }
  1021. return goodsOrder, true, nil
  1022. }
  1023. func DeleteGoodsOrder(id int64) bool {
  1024. var goodsOrder domain.GoodsOrder
  1025. i, err := configs.Engine.Table("goodsOrder").Where("id = ?", id).Delete(&goodsOrder)
  1026. if err != nil {
  1027. return false
  1028. }
  1029. return i > 0
  1030. }
  1031. func GetGoodsSkuById(id int64) (domain.GoodsSku, error) {
  1032. var goodsSku domain.GoodsSku
  1033. _, err := configs.Engine.Table("goodsSku").Where("id = ?", id).Get(&goodsSku)
  1034. if err != nil {
  1035. return goodsSku, err
  1036. }
  1037. return goodsSku, nil
  1038. }
  1039. func GetGoodsSkuListInId(ids []int64) ([]domain.GoodsSku, error) {
  1040. rows, err := configs.Engine.Table("goodsSku").In("id", ids).Rows(&domain.GoodsSku{})
  1041. if err != nil {
  1042. return make([]domain.GoodsSku, 0), err
  1043. }
  1044. defer rows.Close()
  1045. var list []domain.GoodsSku
  1046. for rows.Next() {
  1047. var u domain.GoodsSku
  1048. rows.Scan(&u)
  1049. list = append(list, u)
  1050. }
  1051. return list, nil
  1052. }
  1053. func GetGoodsSkuList(goodsSku domain.GoodsSku, pageNum, pageSize int) (vo.BaseListVo, error) {
  1054. var arr []domain.GoodsSku
  1055. Count, err := configs.Engine.Table("goodsSku").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsSku)
  1056. var vo vo.BaseListVo
  1057. if err != nil {
  1058. return vo, err
  1059. }
  1060. if err != nil {
  1061. return vo, err
  1062. }
  1063. vo.PageNum = pageNum
  1064. vo.PageSize = pageSize
  1065. vo.List = make([]any, len(arr))
  1066. for i, v := range arr {
  1067. vo.List[i] = v
  1068. }
  1069. vo.Total = int(Count)
  1070. return vo, nil
  1071. }
  1072. func SaveGoodsSku(goodsSku *domain.GoodsSku) (domain.GoodsSku, error) {
  1073. _, err := configs.Engine.Table("goodsSku").Insert(&goodsSku)
  1074. if err != nil {
  1075. return *goodsSku, err
  1076. }
  1077. return *goodsSku, nil
  1078. }
  1079. func SetGoodsSku(goodsSkuMap map[string]interface{}, id int64) (domain.GoodsSku, bool, error) {
  1080. var goodsSku domain.GoodsSku
  1081. _, err := configs.Engine.Table("goodsSku").Where("id = ?", id).Update(goodsSkuMap)
  1082. if err != nil {
  1083. return goodsSku, false, err
  1084. }
  1085. return goodsSku, true, nil
  1086. }
  1087. func DeleteGoodsSku(id int64) bool {
  1088. var goodsSku domain.GoodsSku
  1089. i, err := configs.Engine.Table("goodsSku").Where("id = ?", id).Delete(&goodsSku)
  1090. if err != nil {
  1091. return false
  1092. }
  1093. return i > 0
  1094. }
  1095. func GetGoodsSkuCardById(id int64) (domain.GoodsSkuCard, error) {
  1096. var goodsSkuCard domain.GoodsSkuCard
  1097. _, err := configs.Engine.Table("goodsSkuCard").Where("id = ?", id).Get(&goodsSkuCard)
  1098. if err != nil {
  1099. return goodsSkuCard, err
  1100. }
  1101. return goodsSkuCard, nil
  1102. }
  1103. func GetGoodsSkuCardListInId(ids []int64) ([]domain.GoodsSkuCard, error) {
  1104. rows, err := configs.Engine.Table("goodsSkuCard").In("id", ids).Rows(&domain.GoodsSkuCard{})
  1105. if err != nil {
  1106. return make([]domain.GoodsSkuCard, 0), err
  1107. }
  1108. defer rows.Close()
  1109. var list []domain.GoodsSkuCard
  1110. for rows.Next() {
  1111. var u domain.GoodsSkuCard
  1112. rows.Scan(&u)
  1113. list = append(list, u)
  1114. }
  1115. return list, nil
  1116. }
  1117. func GetGoodsSkuCardList(goodsSkuCard domain.GoodsSkuCard, pageNum, pageSize int) (vo.BaseListVo, error) {
  1118. var arr []domain.GoodsSkuCard
  1119. Count, err := configs.Engine.Table("goodsSkuCard").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsSkuCard)
  1120. var vo vo.BaseListVo
  1121. if err != nil {
  1122. return vo, err
  1123. }
  1124. if err != nil {
  1125. return vo, err
  1126. }
  1127. vo.PageNum = pageNum
  1128. vo.PageSize = pageSize
  1129. vo.List = make([]any, len(arr))
  1130. for i, v := range arr {
  1131. vo.List[i] = v
  1132. }
  1133. vo.Total = int(Count)
  1134. return vo, nil
  1135. }
  1136. func SaveGoodsSkuCard(goodsSkuCard *domain.GoodsSkuCard) (domain.GoodsSkuCard, error) {
  1137. _, err := configs.Engine.Table("goodsSkuCard").Insert(&goodsSkuCard)
  1138. if err != nil {
  1139. return *goodsSkuCard, err
  1140. }
  1141. return *goodsSkuCard, nil
  1142. }
  1143. func SetGoodsSkuCard(goodsSkuCardMap map[string]interface{}, id int64) (domain.GoodsSkuCard, bool, error) {
  1144. var goodsSkuCard domain.GoodsSkuCard
  1145. _, err := configs.Engine.Table("goodsSkuCard").Where("id = ?", id).Update(goodsSkuCardMap)
  1146. if err != nil {
  1147. return goodsSkuCard, false, err
  1148. }
  1149. return goodsSkuCard, true, nil
  1150. }
  1151. func DeleteGoodsSkuCard(id int64) bool {
  1152. var goodsSkuCard domain.GoodsSkuCard
  1153. i, err := configs.Engine.Table("goodsSkuCard").Where("id = ?", id).Delete(&goodsSkuCard)
  1154. if err != nil {
  1155. return false
  1156. }
  1157. return i > 0
  1158. }
  1159. func GetGoodsTagById(id int64) (domain.GoodsTag, error) {
  1160. var goodsTag domain.GoodsTag
  1161. _, err := configs.Engine.Table("goodsTag").Where("id = ?", id).Get(&goodsTag)
  1162. if err != nil {
  1163. return goodsTag, err
  1164. }
  1165. return goodsTag, nil
  1166. }
  1167. func GetGoodsTagListInId(ids []int64) ([]domain.GoodsTag, error) {
  1168. rows, err := configs.Engine.Table("goodsTag").In("id", ids).Rows(&domain.GoodsTag{})
  1169. if err != nil {
  1170. return make([]domain.GoodsTag, 0), err
  1171. }
  1172. defer rows.Close()
  1173. var list []domain.GoodsTag
  1174. for rows.Next() {
  1175. var u domain.GoodsTag
  1176. rows.Scan(&u)
  1177. list = append(list, u)
  1178. }
  1179. return list, nil
  1180. }
  1181. func GetGoodsTagList(goodsTag domain.GoodsTag, pageNum, pageSize int) (vo.BaseListVo, error) {
  1182. var arr []domain.GoodsTag
  1183. Count, err := configs.Engine.Table("goodsTag").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsTag)
  1184. var vo vo.BaseListVo
  1185. if err != nil {
  1186. return vo, err
  1187. }
  1188. if err != nil {
  1189. return vo, err
  1190. }
  1191. vo.PageNum = pageNum
  1192. vo.PageSize = pageSize
  1193. vo.List = make([]any, len(arr))
  1194. for i, v := range arr {
  1195. vo.List[i] = v
  1196. }
  1197. vo.Total = int(Count)
  1198. return vo, nil
  1199. }
  1200. func SaveGoodsTag(goodsTag *domain.GoodsTag) (domain.GoodsTag, error) {
  1201. _, err := configs.Engine.Table("goodsTag").Insert(&goodsTag)
  1202. if err != nil {
  1203. return *goodsTag, err
  1204. }
  1205. return *goodsTag, nil
  1206. }
  1207. func SetGoodsTag(goodsTagMap map[string]interface{}, id int64) (domain.GoodsTag, bool, error) {
  1208. var goodsTag domain.GoodsTag
  1209. _, err := configs.Engine.Table("goodsTag").Where("id = ?", id).Update(goodsTagMap)
  1210. if err != nil {
  1211. return goodsTag, false, err
  1212. }
  1213. return goodsTag, true, nil
  1214. }
  1215. func DeleteGoodsTag(id int64) bool {
  1216. var goodsTag domain.GoodsTag
  1217. i, err := configs.Engine.Table("goodsTag").Where("id = ?", id).Delete(&goodsTag)
  1218. if err != nil {
  1219. return false
  1220. }
  1221. return i > 0
  1222. }
  1223. func GetGoodsTypeById(id int64) (domain.GoodsType, error) {
  1224. var goodsType domain.GoodsType
  1225. _, err := configs.Engine.Table("goodsType").Where("id = ?", id).Get(&goodsType)
  1226. if err != nil {
  1227. return goodsType, err
  1228. }
  1229. return goodsType, nil
  1230. }
  1231. func GetGoodsTypeListInId(ids []int64) ([]domain.GoodsType, error) {
  1232. rows, err := configs.Engine.Table("goodsType").In("id", ids).Rows(&domain.GoodsType{})
  1233. if err != nil {
  1234. return make([]domain.GoodsType, 0), err
  1235. }
  1236. defer rows.Close()
  1237. var list []domain.GoodsType
  1238. for rows.Next() {
  1239. var u domain.GoodsType
  1240. rows.Scan(&u)
  1241. list = append(list, u)
  1242. }
  1243. return list, nil
  1244. }
  1245. func GetGoodsTypeList(goodsType domain.GoodsType, pageNum, pageSize int) (vo.BaseListVo, error) {
  1246. var arr []domain.GoodsType
  1247. Count, err := configs.Engine.Table("goodsType").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsType)
  1248. var vo vo.BaseListVo
  1249. if err != nil {
  1250. return vo, err
  1251. }
  1252. if err != nil {
  1253. return vo, err
  1254. }
  1255. vo.PageNum = pageNum
  1256. vo.PageSize = pageSize
  1257. vo.List = make([]any, len(arr))
  1258. for i, v := range arr {
  1259. vo.List[i] = v
  1260. }
  1261. vo.Total = int(Count)
  1262. return vo, nil
  1263. }
  1264. func SaveGoodsType(goodsType *domain.GoodsType) (domain.GoodsType, error) {
  1265. _, err := configs.Engine.Table("goodsType").Insert(&goodsType)
  1266. if err != nil {
  1267. return *goodsType, err
  1268. }
  1269. return *goodsType, nil
  1270. }
  1271. func SetGoodsType(goodsTypeMap map[string]interface{}, id int64) (domain.GoodsType, bool, error) {
  1272. var goodsType domain.GoodsType
  1273. _, err := configs.Engine.Table("goodsType").Where("id = ?", id).Update(goodsTypeMap)
  1274. if err != nil {
  1275. return goodsType, false, err
  1276. }
  1277. return goodsType, true, nil
  1278. }
  1279. func DeleteGoodsType(id int64) bool {
  1280. var goodsType domain.GoodsType
  1281. i, err := configs.Engine.Table("goodsType").Where("id = ?", id).Delete(&goodsType)
  1282. if err != nil {
  1283. return false
  1284. }
  1285. return i > 0
  1286. }
  1287. func GetUserById(id int64) (domain.User, error) {
  1288. var user domain.User
  1289. _, err := configs.Engine.Table("user").Where("id = ?", id).Get(&user)
  1290. if err != nil {
  1291. return user, err
  1292. }
  1293. return user, nil
  1294. }
  1295. func GetUserListInId(ids []int64) ([]domain.User, error) {
  1296. rows, err := configs.Engine.Table("user").In("id", ids).Rows(&domain.User{})
  1297. if err != nil {
  1298. return make([]domain.User, 0), err
  1299. }
  1300. defer rows.Close()
  1301. var list []domain.User
  1302. for rows.Next() {
  1303. var u domain.User
  1304. rows.Scan(&u)
  1305. list = append(list, u)
  1306. }
  1307. return list, nil
  1308. }
  1309. func GetUserList(user domain.User, pageNum, pageSize int) (vo.BaseListVo, error) {
  1310. var arr []domain.User
  1311. Count, err := configs.Engine.Table("user").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &user)
  1312. var vo vo.BaseListVo
  1313. if err != nil {
  1314. return vo, err
  1315. }
  1316. if err != nil {
  1317. return vo, err
  1318. }
  1319. vo.PageNum = pageNum
  1320. vo.PageSize = pageSize
  1321. vo.List = make([]any, len(arr))
  1322. for i, v := range arr {
  1323. vo.List[i] = v
  1324. }
  1325. vo.Total = int(Count)
  1326. return vo, nil
  1327. }
  1328. func SaveUser(user *domain.User) (domain.User, error) {
  1329. _, err := configs.Engine.Table("user").Insert(&user)
  1330. if err != nil {
  1331. return *user, err
  1332. }
  1333. return *user, nil
  1334. }
  1335. func SetUser(userMap map[string]interface{}, id int64) (domain.User, bool, error) {
  1336. var user domain.User
  1337. _, err := configs.Engine.Table("user").Where("id = ?", id).Update(userMap)
  1338. if err != nil {
  1339. return user, false, err
  1340. }
  1341. return user, true, nil
  1342. }
  1343. func DeleteUser(id int64) bool {
  1344. var user domain.User
  1345. i, err := configs.Engine.Table("user").Where("id = ?", id).Delete(&user)
  1346. if err != nil {
  1347. return false
  1348. }
  1349. return i > 0
  1350. }
  1351. func GetUserWalletById(id int64) (domain.UserWallet, error) {
  1352. var userWallet domain.UserWallet
  1353. _, err := configs.Engine.Table("userWallet").Where("id = ?", id).Get(&userWallet)
  1354. if err != nil {
  1355. return userWallet, err
  1356. }
  1357. return userWallet, nil
  1358. }
  1359. func GetUserWalletListInId(ids []int64) ([]domain.UserWallet, error) {
  1360. rows, err := configs.Engine.Table("userWallet").In("id", ids).Rows(&domain.UserWallet{})
  1361. if err != nil {
  1362. return make([]domain.UserWallet, 0), err
  1363. }
  1364. defer rows.Close()
  1365. var list []domain.UserWallet
  1366. for rows.Next() {
  1367. var u domain.UserWallet
  1368. rows.Scan(&u)
  1369. list = append(list, u)
  1370. }
  1371. return list, nil
  1372. }
  1373. func GetUserWalletList(userWallet domain.UserWallet, pageNum, pageSize int) (vo.BaseListVo, error) {
  1374. var arr []domain.UserWallet
  1375. Count, err := configs.Engine.Table("userWallet").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &userWallet)
  1376. var vo vo.BaseListVo
  1377. if err != nil {
  1378. return vo, err
  1379. }
  1380. if err != nil {
  1381. return vo, err
  1382. }
  1383. vo.PageNum = pageNum
  1384. vo.PageSize = pageSize
  1385. vo.List = make([]any, len(arr))
  1386. for i, v := range arr {
  1387. vo.List[i] = v
  1388. }
  1389. vo.Total = int(Count)
  1390. return vo, nil
  1391. }
  1392. func SaveUserWallet(userWallet *domain.UserWallet) (domain.UserWallet, error) {
  1393. _, err := configs.Engine.Table("userWallet").Insert(&userWallet)
  1394. if err != nil {
  1395. return *userWallet, err
  1396. }
  1397. return *userWallet, nil
  1398. }
  1399. func SetUserWallet(userWalletMap map[string]interface{}, id int64) (domain.UserWallet, bool, error) {
  1400. var userWallet domain.UserWallet
  1401. _, err := configs.Engine.Table("userWallet").Where("id = ?", id).Update(userWalletMap)
  1402. if err != nil {
  1403. return userWallet, false, err
  1404. }
  1405. return userWallet, true, nil
  1406. }
  1407. func DeleteUserWallet(id int64) bool {
  1408. var userWallet domain.UserWallet
  1409. i, err := configs.Engine.Table("userWallet").Where("id = ?", id).Delete(&userWallet)
  1410. if err != nil {
  1411. return false
  1412. }
  1413. return i > 0
  1414. }
  1415. func GetAuthorityById(id int64) (domain.Authority, error) {
  1416. var authority domain.Authority
  1417. _, err := configs.Engine.Table("authority").Where("id = ?", id).Get(&authority)
  1418. if err != nil {
  1419. return authority, err
  1420. }
  1421. return authority, nil
  1422. }
  1423. func GetAuthorityListInId(ids []int64) ([]domain.Authority, error) {
  1424. rows, err := configs.Engine.Table("authority").In("id", ids).Rows(&domain.Authority{})
  1425. if err != nil {
  1426. return make([]domain.Authority, 0), err
  1427. }
  1428. defer rows.Close()
  1429. var list []domain.Authority
  1430. for rows.Next() {
  1431. var u domain.Authority
  1432. rows.Scan(&u)
  1433. list = append(list, u)
  1434. }
  1435. return list, nil
  1436. }
  1437. func GetAuthorityList(authority domain.Authority, pageNum, pageSize int) (vo.BaseListVo, error) {
  1438. var arr []domain.Authority
  1439. Count, err := configs.Engine.Table("authority").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &authority)
  1440. var vo vo.BaseListVo
  1441. if err != nil {
  1442. return vo, err
  1443. }
  1444. if err != nil {
  1445. return vo, err
  1446. }
  1447. vo.PageNum = pageNum
  1448. vo.PageSize = pageSize
  1449. vo.List = make([]any, len(arr))
  1450. for i, v := range arr {
  1451. vo.List[i] = v
  1452. }
  1453. vo.Total = int(Count)
  1454. return vo, nil
  1455. }
  1456. func SaveAuthority(authority *domain.Authority) (domain.Authority, error) {
  1457. _, err := configs.Engine.Table("authority").Insert(&authority)
  1458. if err != nil {
  1459. return *authority, err
  1460. }
  1461. return *authority, nil
  1462. }
  1463. func SetAuthority(authorityMap map[string]interface{}, id int64) (domain.Authority, bool, error) {
  1464. var authority domain.Authority
  1465. _, err := configs.Engine.Table("authority").Where("id = ?", id).Update(authorityMap)
  1466. if err != nil {
  1467. return authority, false, err
  1468. }
  1469. return authority, true, nil
  1470. }
  1471. func DeleteAuthority(id int64) bool {
  1472. var authority domain.Authority
  1473. i, err := configs.Engine.Table("authority").Where("id = ?", id).Delete(&authority)
  1474. if err != nil {
  1475. return false
  1476. }
  1477. return i > 0
  1478. }
  1479. func GetDictDataById(id int64) (domain.DictData, error) {
  1480. var dictData domain.DictData
  1481. _, err := configs.Engine.Table("dictData").Where("id = ?", id).Get(&dictData)
  1482. if err != nil {
  1483. return dictData, err
  1484. }
  1485. return dictData, nil
  1486. }
  1487. func GetDictDataListInId(ids []int64) ([]domain.DictData, error) {
  1488. rows, err := configs.Engine.Table("dictData").In("id", ids).Rows(&domain.DictData{})
  1489. if err != nil {
  1490. return make([]domain.DictData, 0), err
  1491. }
  1492. defer rows.Close()
  1493. var list []domain.DictData
  1494. for rows.Next() {
  1495. var u domain.DictData
  1496. rows.Scan(&u)
  1497. list = append(list, u)
  1498. }
  1499. return list, nil
  1500. }
  1501. func GetDictDataList(dictData domain.DictData, pageNum, pageSize int) (vo.BaseListVo, error) {
  1502. var arr []domain.DictData
  1503. Count, err := configs.Engine.Table("dictData").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &dictData)
  1504. var vo vo.BaseListVo
  1505. if err != nil {
  1506. return vo, err
  1507. }
  1508. if err != nil {
  1509. return vo, err
  1510. }
  1511. vo.PageNum = pageNum
  1512. vo.PageSize = pageSize
  1513. vo.List = make([]any, len(arr))
  1514. for i, v := range arr {
  1515. vo.List[i] = v
  1516. }
  1517. vo.Total = int(Count)
  1518. return vo, nil
  1519. }
  1520. func SaveDictData(dictData *domain.DictData) (domain.DictData, error) {
  1521. _, err := configs.Engine.Table("dictData").Insert(&dictData)
  1522. if err != nil {
  1523. return *dictData, err
  1524. }
  1525. return *dictData, nil
  1526. }
  1527. func SetDictData(dictDataMap map[string]interface{}, id int64) (domain.DictData, bool, error) {
  1528. var dictData domain.DictData
  1529. _, err := configs.Engine.Table("dictData").Where("id = ?", id).Update(dictDataMap)
  1530. if err != nil {
  1531. return dictData, false, err
  1532. }
  1533. return dictData, true, nil
  1534. }
  1535. func DeleteDictData(id int64) bool {
  1536. var dictData domain.DictData
  1537. i, err := configs.Engine.Table("dictData").Where("id = ?", id).Delete(&dictData)
  1538. if err != nil {
  1539. return false
  1540. }
  1541. return i > 0
  1542. }
  1543. func GetDictTypeById(id int64) (domain.DictType, error) {
  1544. var dictType domain.DictType
  1545. _, err := configs.Engine.Table("dictType").Where("id = ?", id).Get(&dictType)
  1546. if err != nil {
  1547. return dictType, err
  1548. }
  1549. return dictType, nil
  1550. }
  1551. func GetDictTypeListInId(ids []int64) ([]domain.DictType, error) {
  1552. rows, err := configs.Engine.Table("dictType").In("id", ids).Rows(&domain.DictType{})
  1553. if err != nil {
  1554. return make([]domain.DictType, 0), err
  1555. }
  1556. defer rows.Close()
  1557. var list []domain.DictType
  1558. for rows.Next() {
  1559. var u domain.DictType
  1560. rows.Scan(&u)
  1561. list = append(list, u)
  1562. }
  1563. return list, nil
  1564. }
  1565. func GetDictTypeList(dictType domain.DictType, pageNum, pageSize int) (vo.BaseListVo, error) {
  1566. var arr []domain.DictType
  1567. Count, err := configs.Engine.Table("dictType").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &dictType)
  1568. var vo vo.BaseListVo
  1569. if err != nil {
  1570. return vo, err
  1571. }
  1572. if err != nil {
  1573. return vo, err
  1574. }
  1575. vo.PageNum = pageNum
  1576. vo.PageSize = pageSize
  1577. vo.List = make([]any, len(arr))
  1578. for i, v := range arr {
  1579. vo.List[i] = v
  1580. }
  1581. vo.Total = int(Count)
  1582. return vo, nil
  1583. }
  1584. func SaveDictType(dictType *domain.DictType) (domain.DictType, error) {
  1585. _, err := configs.Engine.Table("dictType").Insert(&dictType)
  1586. if err != nil {
  1587. return *dictType, err
  1588. }
  1589. return *dictType, nil
  1590. }
  1591. func SetDictType(dictTypeMap map[string]interface{}, id int64) (domain.DictType, bool, error) {
  1592. var dictType domain.DictType
  1593. _, err := configs.Engine.Table("dictType").Where("id = ?", id).Update(dictTypeMap)
  1594. if err != nil {
  1595. return dictType, false, err
  1596. }
  1597. return dictType, true, nil
  1598. }
  1599. func DeleteDictType(id int64) bool {
  1600. var dictType domain.DictType
  1601. i, err := configs.Engine.Table("dictType").Where("id = ?", id).Delete(&dictType)
  1602. if err != nil {
  1603. return false
  1604. }
  1605. return i > 0
  1606. }
  1607. func GetManageUserById(id int64) (domain.ManageUser, error) {
  1608. var manageUser domain.ManageUser
  1609. _, err := configs.Engine.Table("manageUser").Where("id = ?", id).Get(&manageUser)
  1610. if err != nil {
  1611. return manageUser, err
  1612. }
  1613. return manageUser, nil
  1614. }
  1615. func GetManageUserListInId(ids []int64) ([]domain.ManageUser, error) {
  1616. rows, err := configs.Engine.Table("manageUser").In("id", ids).Rows(&domain.ManageUser{})
  1617. if err != nil {
  1618. return make([]domain.ManageUser, 0), err
  1619. }
  1620. defer rows.Close()
  1621. var list []domain.ManageUser
  1622. for rows.Next() {
  1623. var u domain.ManageUser
  1624. rows.Scan(&u)
  1625. list = append(list, u)
  1626. }
  1627. return list, nil
  1628. }
  1629. func GetManageUserList(manageUser domain.ManageUser, pageNum, pageSize int) (vo.BaseListVo, error) {
  1630. var arr []domain.ManageUser
  1631. Count, err := configs.Engine.Table("manageUser").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &manageUser)
  1632. var vo vo.BaseListVo
  1633. if err != nil {
  1634. return vo, err
  1635. }
  1636. if err != nil {
  1637. return vo, err
  1638. }
  1639. vo.PageNum = pageNum
  1640. vo.PageSize = pageSize
  1641. vo.List = make([]any, len(arr))
  1642. for i, v := range arr {
  1643. vo.List[i] = v
  1644. }
  1645. vo.Total = int(Count)
  1646. return vo, nil
  1647. }
  1648. func SaveManageUser(manageUser *domain.ManageUser) (domain.ManageUser, error) {
  1649. _, err := configs.Engine.Table("manageUser").Insert(&manageUser)
  1650. if err != nil {
  1651. return *manageUser, err
  1652. }
  1653. return *manageUser, nil
  1654. }
  1655. func SetManageUser(manageUserMap map[string]interface{}, id int64) (domain.ManageUser, bool, error) {
  1656. var manageUser domain.ManageUser
  1657. _, err := configs.Engine.Table("manageUser").Where("id = ?", id).Update(manageUserMap)
  1658. if err != nil {
  1659. return manageUser, false, err
  1660. }
  1661. return manageUser, true, nil
  1662. }
  1663. func DeleteManageUser(id int64) bool {
  1664. var manageUser domain.ManageUser
  1665. i, err := configs.Engine.Table("manageUser").Where("id = ?", id).Delete(&manageUser)
  1666. if err != nil {
  1667. return false
  1668. }
  1669. return i > 0
  1670. }
  1671. func GetShopTopicById(id int64) (domain.ShopTopic, error) {
  1672. var shopTopic domain.ShopTopic
  1673. _, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Get(&shopTopic)
  1674. if err != nil {
  1675. return shopTopic, err
  1676. }
  1677. return shopTopic, nil
  1678. }
  1679. func GetShopTopicListInId(ids []int64) ([]domain.ShopTopic, error) {
  1680. rows, err := configs.Engine.Table("shopTopic").In("id", ids).Rows(&domain.ShopTopic{})
  1681. if err != nil {
  1682. return make([]domain.ShopTopic, 0), err
  1683. }
  1684. defer rows.Close()
  1685. var list []domain.ShopTopic
  1686. for rows.Next() {
  1687. var u domain.ShopTopic
  1688. rows.Scan(&u)
  1689. list = append(list, u)
  1690. }
  1691. return list, nil
  1692. }
  1693. func GetShopTopicList(shopTopic domain.ShopTopic, pageNum, pageSize int) (vo.BaseListVo, error) {
  1694. var arr []domain.ShopTopic
  1695. Count, err := configs.Engine.Table("shopTopic").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopTopic)
  1696. var vo vo.BaseListVo
  1697. if err != nil {
  1698. return vo, err
  1699. }
  1700. if err != nil {
  1701. return vo, err
  1702. }
  1703. vo.PageNum = pageNum
  1704. vo.PageSize = pageSize
  1705. vo.List = make([]any, len(arr))
  1706. for i, v := range arr {
  1707. vo.List[i] = v
  1708. }
  1709. vo.Total = int(Count)
  1710. return vo, nil
  1711. }
  1712. func SaveShopTopic(shopTopic *domain.ShopTopic) (domain.ShopTopic, error) {
  1713. _, err := configs.Engine.Table("shopTopic").Insert(&shopTopic)
  1714. if err != nil {
  1715. return *shopTopic, err
  1716. }
  1717. return *shopTopic, nil
  1718. }
  1719. func SetShopTopic(shopTopicMap map[string]interface{}, id int64) (domain.ShopTopic, bool, error) {
  1720. var shopTopic domain.ShopTopic
  1721. _, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Update(shopTopicMap)
  1722. if err != nil {
  1723. return shopTopic, false, err
  1724. }
  1725. return shopTopic, true, nil
  1726. }
  1727. func DeleteShopTopic(id int64) bool {
  1728. var shopTopic domain.ShopTopic
  1729. i, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Delete(&shopTopic)
  1730. if err != nil {
  1731. return false
  1732. }
  1733. return i > 0
  1734. }
  1735. func GetShopAdviceCarouselById(id int64) (domain.ShopAdviceCarousel, error) {
  1736. var shopAdviceCarousel domain.ShopAdviceCarousel
  1737. _, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Get(&shopAdviceCarousel)
  1738. if err != nil {
  1739. return shopAdviceCarousel, err
  1740. }
  1741. return shopAdviceCarousel, nil
  1742. }
  1743. func GetShopAdviceCarouselListInId(ids []int64) ([]domain.ShopAdviceCarousel, error) {
  1744. rows, err := configs.Engine.Table("shopAdviceCarousel").In("id", ids).Rows(&domain.ShopAdviceCarousel{})
  1745. if err != nil {
  1746. return make([]domain.ShopAdviceCarousel, 0), err
  1747. }
  1748. defer rows.Close()
  1749. var list []domain.ShopAdviceCarousel
  1750. for rows.Next() {
  1751. var u domain.ShopAdviceCarousel
  1752. rows.Scan(&u)
  1753. list = append(list, u)
  1754. }
  1755. return list, nil
  1756. }
  1757. func GetShopAdviceCarouselList(shopAdviceCarousel domain.ShopAdviceCarousel, pageNum, pageSize int) (vo.BaseListVo, error) {
  1758. var arr []domain.ShopAdviceCarousel
  1759. Count, err := configs.Engine.Table("shopAdviceCarousel").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopAdviceCarousel)
  1760. var vo vo.BaseListVo
  1761. if err != nil {
  1762. return vo, err
  1763. }
  1764. if err != nil {
  1765. return vo, err
  1766. }
  1767. vo.PageNum = pageNum
  1768. vo.PageSize = pageSize
  1769. vo.List = make([]any, len(arr))
  1770. for i, v := range arr {
  1771. vo.List[i] = v
  1772. }
  1773. vo.Total = int(Count)
  1774. return vo, nil
  1775. }
  1776. func SaveShopAdviceCarousel(shopAdviceCarousel *domain.ShopAdviceCarousel) (domain.ShopAdviceCarousel, error) {
  1777. _, err := configs.Engine.Table("shopAdviceCarousel").Insert(&shopAdviceCarousel)
  1778. if err != nil {
  1779. return *shopAdviceCarousel, err
  1780. }
  1781. return *shopAdviceCarousel, nil
  1782. }
  1783. func SetShopAdviceCarousel(shopAdviceCarouselMap map[string]interface{}, id int64) (domain.ShopAdviceCarousel, bool, error) {
  1784. var shopAdviceCarousel domain.ShopAdviceCarousel
  1785. _, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Update(shopAdviceCarouselMap)
  1786. if err != nil {
  1787. return shopAdviceCarousel, false, err
  1788. }
  1789. return shopAdviceCarousel, true, nil
  1790. }
  1791. func DeleteShopAdviceCarousel(id int64) bool {
  1792. var shopAdviceCarousel domain.ShopAdviceCarousel
  1793. i, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Delete(&shopAdviceCarousel)
  1794. if err != nil {
  1795. return false
  1796. }
  1797. return i > 0
  1798. }
  1799. func GetShopTopicSkuById(id int64) (domain.ShopTopicSku, error) {
  1800. var shopTopicSku domain.ShopTopicSku
  1801. _, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Get(&shopTopicSku)
  1802. if err != nil {
  1803. return shopTopicSku, err
  1804. }
  1805. return shopTopicSku, nil
  1806. }
  1807. func GetShopTopicSkuListInId(ids []int64) ([]domain.ShopTopicSku, error) {
  1808. rows, err := configs.Engine.Table("shopTopicSku").In("id", ids).Rows(&domain.ShopTopicSku{})
  1809. if err != nil {
  1810. return make([]domain.ShopTopicSku, 0), err
  1811. }
  1812. defer rows.Close()
  1813. var list []domain.ShopTopicSku
  1814. for rows.Next() {
  1815. var u domain.ShopTopicSku
  1816. rows.Scan(&u)
  1817. list = append(list, u)
  1818. }
  1819. return list, nil
  1820. }
  1821. func GetShopTopicSkuList(shopTopicSku domain.ShopTopicSku, pageNum, pageSize int) (vo.BaseListVo, error) {
  1822. var arr []domain.ShopTopicSku
  1823. Count, err := configs.Engine.Table("shopTopicSku").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopTopicSku)
  1824. var vo vo.BaseListVo
  1825. if err != nil {
  1826. return vo, err
  1827. }
  1828. if err != nil {
  1829. return vo, err
  1830. }
  1831. vo.PageNum = pageNum
  1832. vo.PageSize = pageSize
  1833. vo.List = make([]any, len(arr))
  1834. for i, v := range arr {
  1835. vo.List[i] = v
  1836. }
  1837. vo.Total = int(Count)
  1838. return vo, nil
  1839. }
  1840. func SaveShopTopicSku(shopTopicSku *domain.ShopTopicSku) (domain.ShopTopicSku, error) {
  1841. _, err := configs.Engine.Table("shopTopicSku").Insert(&shopTopicSku)
  1842. if err != nil {
  1843. return *shopTopicSku, err
  1844. }
  1845. return *shopTopicSku, nil
  1846. }
  1847. func SetShopTopicSku(shopTopicSkuMap map[string]interface{}, id int64) (domain.ShopTopicSku, bool, error) {
  1848. var shopTopicSku domain.ShopTopicSku
  1849. _, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Update(shopTopicSkuMap)
  1850. if err != nil {
  1851. return shopTopicSku, false, err
  1852. }
  1853. return shopTopicSku, true, nil
  1854. }
  1855. func DeleteShopTopicSku(id int64) bool {
  1856. var shopTopicSku domain.ShopTopicSku
  1857. i, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Delete(&shopTopicSku)
  1858. if err != nil {
  1859. return false
  1860. }
  1861. return i > 0
  1862. }