Dao.go 53 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967
  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 GetDictDataById(id int64) (domain.DictData, error) {
  1416. var dictData domain.DictData
  1417. _, err := configs.Engine.Table("dictData").Where("id = ?", id).Get(&dictData)
  1418. if err != nil {
  1419. return dictData, err
  1420. }
  1421. return dictData, nil
  1422. }
  1423. func GetDictDataListInId(ids []int64) ([]domain.DictData, error) {
  1424. rows, err := configs.Engine.Table("dictData").In("id", ids).Rows(&domain.DictData{})
  1425. if err != nil {
  1426. return make([]domain.DictData, 0), err
  1427. }
  1428. defer rows.Close()
  1429. var list []domain.DictData
  1430. for rows.Next() {
  1431. var u domain.DictData
  1432. rows.Scan(&u)
  1433. list = append(list, u)
  1434. }
  1435. return list, nil
  1436. }
  1437. func GetDictDataList(dictData domain.DictData, pageNum, pageSize int) (vo.BaseListVo, error) {
  1438. var arr []domain.DictData
  1439. Count, err := configs.Engine.Table("dictData").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &dictData)
  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 SaveDictData(dictData *domain.DictData) (domain.DictData, error) {
  1457. _, err := configs.Engine.Table("dictData").Insert(&dictData)
  1458. if err != nil {
  1459. return *dictData, err
  1460. }
  1461. return *dictData, nil
  1462. }
  1463. func SetDictData(dictDataMap map[string]interface{}, id int64) (domain.DictData, bool, error) {
  1464. var dictData domain.DictData
  1465. _, err := configs.Engine.Table("dictData").Where("id = ?", id).Update(dictDataMap)
  1466. if err != nil {
  1467. return dictData, false, err
  1468. }
  1469. return dictData, true, nil
  1470. }
  1471. func DeleteDictData(id int64) bool {
  1472. var dictData domain.DictData
  1473. i, err := configs.Engine.Table("dictData").Where("id = ?", id).Delete(&dictData)
  1474. if err != nil {
  1475. return false
  1476. }
  1477. return i > 0
  1478. }
  1479. func GetDictTypeById(id int64) (domain.DictType, error) {
  1480. var dictType domain.DictType
  1481. _, err := configs.Engine.Table("dictType").Where("id = ?", id).Get(&dictType)
  1482. if err != nil {
  1483. return dictType, err
  1484. }
  1485. return dictType, nil
  1486. }
  1487. func GetDictTypeListInId(ids []int64) ([]domain.DictType, error) {
  1488. rows, err := configs.Engine.Table("dictType").In("id", ids).Rows(&domain.DictType{})
  1489. if err != nil {
  1490. return make([]domain.DictType, 0), err
  1491. }
  1492. defer rows.Close()
  1493. var list []domain.DictType
  1494. for rows.Next() {
  1495. var u domain.DictType
  1496. rows.Scan(&u)
  1497. list = append(list, u)
  1498. }
  1499. return list, nil
  1500. }
  1501. func GetDictTypeList(dictType domain.DictType, pageNum, pageSize int) (vo.BaseListVo, error) {
  1502. var arr []domain.DictType
  1503. Count, err := configs.Engine.Table("dictType").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &dictType)
  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 SaveDictType(dictType *domain.DictType) (domain.DictType, error) {
  1521. _, err := configs.Engine.Table("dictType").Insert(&dictType)
  1522. if err != nil {
  1523. return *dictType, err
  1524. }
  1525. return *dictType, nil
  1526. }
  1527. func SetDictType(dictTypeMap map[string]interface{}, id int64) (domain.DictType, bool, error) {
  1528. var dictType domain.DictType
  1529. _, err := configs.Engine.Table("dictType").Where("id = ?", id).Update(dictTypeMap)
  1530. if err != nil {
  1531. return dictType, false, err
  1532. }
  1533. return dictType, true, nil
  1534. }
  1535. func DeleteDictType(id int64) bool {
  1536. var dictType domain.DictType
  1537. i, err := configs.Engine.Table("dictType").Where("id = ?", id).Delete(&dictType)
  1538. if err != nil {
  1539. return false
  1540. }
  1541. return i > 0
  1542. }
  1543. func GetManageUserById(id int64) (domain.ManageUser, error) {
  1544. var manageUser domain.ManageUser
  1545. _, err := configs.Engine.Table("manageUser").Where("id = ?", id).Get(&manageUser)
  1546. if err != nil {
  1547. return manageUser, err
  1548. }
  1549. return manageUser, nil
  1550. }
  1551. func GetManageUserListInId(ids []int64) ([]domain.ManageUser, error) {
  1552. rows, err := configs.Engine.Table("manageUser").In("id", ids).Rows(&domain.ManageUser{})
  1553. if err != nil {
  1554. return make([]domain.ManageUser, 0), err
  1555. }
  1556. defer rows.Close()
  1557. var list []domain.ManageUser
  1558. for rows.Next() {
  1559. var u domain.ManageUser
  1560. rows.Scan(&u)
  1561. list = append(list, u)
  1562. }
  1563. return list, nil
  1564. }
  1565. func GetManageUserList(manageUser domain.ManageUser, pageNum, pageSize int) (vo.BaseListVo, error) {
  1566. var arr []domain.ManageUser
  1567. Count, err := configs.Engine.Table("manageUser").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &manageUser)
  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 SaveManageUser(manageUser *domain.ManageUser) (domain.ManageUser, error) {
  1585. _, err := configs.Engine.Table("manageUser").Insert(&manageUser)
  1586. if err != nil {
  1587. return *manageUser, err
  1588. }
  1589. return *manageUser, nil
  1590. }
  1591. func SetManageUser(manageUserMap map[string]interface{}, id int64) (domain.ManageUser, bool, error) {
  1592. var manageUser domain.ManageUser
  1593. _, err := configs.Engine.Table("manageUser").Where("id = ?", id).Update(manageUserMap)
  1594. if err != nil {
  1595. return manageUser, false, err
  1596. }
  1597. return manageUser, true, nil
  1598. }
  1599. func DeleteManageUser(id int64) bool {
  1600. var manageUser domain.ManageUser
  1601. i, err := configs.Engine.Table("manageUser").Where("id = ?", id).Delete(&manageUser)
  1602. if err != nil {
  1603. return false
  1604. }
  1605. return i > 0
  1606. }
  1607. func GetShopTopicById(id int64) (domain.ShopTopic, error) {
  1608. var shopTopic domain.ShopTopic
  1609. _, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Get(&shopTopic)
  1610. if err != nil {
  1611. return shopTopic, err
  1612. }
  1613. return shopTopic, nil
  1614. }
  1615. func GetShopTopicListInId(ids []int64) ([]domain.ShopTopic, error) {
  1616. rows, err := configs.Engine.Table("shopTopic").In("id", ids).Rows(&domain.ShopTopic{})
  1617. if err != nil {
  1618. return make([]domain.ShopTopic, 0), err
  1619. }
  1620. defer rows.Close()
  1621. var list []domain.ShopTopic
  1622. for rows.Next() {
  1623. var u domain.ShopTopic
  1624. rows.Scan(&u)
  1625. list = append(list, u)
  1626. }
  1627. return list, nil
  1628. }
  1629. func GetShopTopicList(shopTopic domain.ShopTopic, pageNum, pageSize int) (vo.BaseListVo, error) {
  1630. var arr []domain.ShopTopic
  1631. Count, err := configs.Engine.Table("shopTopic").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopTopic)
  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 SaveShopTopic(shopTopic *domain.ShopTopic) (domain.ShopTopic, error) {
  1649. _, err := configs.Engine.Table("shopTopic").Insert(&shopTopic)
  1650. if err != nil {
  1651. return *shopTopic, err
  1652. }
  1653. return *shopTopic, nil
  1654. }
  1655. func SetShopTopic(shopTopicMap map[string]interface{}, id int64) (domain.ShopTopic, bool, error) {
  1656. var shopTopic domain.ShopTopic
  1657. _, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Update(shopTopicMap)
  1658. if err != nil {
  1659. return shopTopic, false, err
  1660. }
  1661. return shopTopic, true, nil
  1662. }
  1663. func DeleteShopTopic(id int64) bool {
  1664. var shopTopic domain.ShopTopic
  1665. i, err := configs.Engine.Table("shopTopic").Where("id = ?", id).Delete(&shopTopic)
  1666. if err != nil {
  1667. return false
  1668. }
  1669. return i > 0
  1670. }
  1671. func GetShopAdviceCarouselById(id int64) (domain.ShopAdviceCarousel, error) {
  1672. var shopAdviceCarousel domain.ShopAdviceCarousel
  1673. _, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Get(&shopAdviceCarousel)
  1674. if err != nil {
  1675. return shopAdviceCarousel, err
  1676. }
  1677. return shopAdviceCarousel, nil
  1678. }
  1679. func GetShopAdviceCarouselListInId(ids []int64) ([]domain.ShopAdviceCarousel, error) {
  1680. rows, err := configs.Engine.Table("shopAdviceCarousel").In("id", ids).Rows(&domain.ShopAdviceCarousel{})
  1681. if err != nil {
  1682. return make([]domain.ShopAdviceCarousel, 0), err
  1683. }
  1684. defer rows.Close()
  1685. var list []domain.ShopAdviceCarousel
  1686. for rows.Next() {
  1687. var u domain.ShopAdviceCarousel
  1688. rows.Scan(&u)
  1689. list = append(list, u)
  1690. }
  1691. return list, nil
  1692. }
  1693. func GetShopAdviceCarouselList(shopAdviceCarousel domain.ShopAdviceCarousel, pageNum, pageSize int) (vo.BaseListVo, error) {
  1694. var arr []domain.ShopAdviceCarousel
  1695. Count, err := configs.Engine.Table("shopAdviceCarousel").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopAdviceCarousel)
  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 SaveShopAdviceCarousel(shopAdviceCarousel *domain.ShopAdviceCarousel) (domain.ShopAdviceCarousel, error) {
  1713. _, err := configs.Engine.Table("shopAdviceCarousel").Insert(&shopAdviceCarousel)
  1714. if err != nil {
  1715. return *shopAdviceCarousel, err
  1716. }
  1717. return *shopAdviceCarousel, nil
  1718. }
  1719. func SetShopAdviceCarousel(shopAdviceCarouselMap map[string]interface{}, id int64) (domain.ShopAdviceCarousel, bool, error) {
  1720. var shopAdviceCarousel domain.ShopAdviceCarousel
  1721. _, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Update(shopAdviceCarouselMap)
  1722. if err != nil {
  1723. return shopAdviceCarousel, false, err
  1724. }
  1725. return shopAdviceCarousel, true, nil
  1726. }
  1727. func DeleteShopAdviceCarousel(id int64) bool {
  1728. var shopAdviceCarousel domain.ShopAdviceCarousel
  1729. i, err := configs.Engine.Table("shopAdviceCarousel").Where("id = ?", id).Delete(&shopAdviceCarousel)
  1730. if err != nil {
  1731. return false
  1732. }
  1733. return i > 0
  1734. }
  1735. func GetShopTopicSkuById(id int64) (domain.ShopTopicSku, error) {
  1736. var shopTopicSku domain.ShopTopicSku
  1737. _, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Get(&shopTopicSku)
  1738. if err != nil {
  1739. return shopTopicSku, err
  1740. }
  1741. return shopTopicSku, nil
  1742. }
  1743. func GetShopTopicSkuListInId(ids []int64) ([]domain.ShopTopicSku, error) {
  1744. rows, err := configs.Engine.Table("shopTopicSku").In("id", ids).Rows(&domain.ShopTopicSku{})
  1745. if err != nil {
  1746. return make([]domain.ShopTopicSku, 0), err
  1747. }
  1748. defer rows.Close()
  1749. var list []domain.ShopTopicSku
  1750. for rows.Next() {
  1751. var u domain.ShopTopicSku
  1752. rows.Scan(&u)
  1753. list = append(list, u)
  1754. }
  1755. return list, nil
  1756. }
  1757. func GetShopTopicSkuList(shopTopicSku domain.ShopTopicSku, pageNum, pageSize int) (vo.BaseListVo, error) {
  1758. var arr []domain.ShopTopicSku
  1759. Count, err := configs.Engine.Table("shopTopicSku").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &shopTopicSku)
  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 SaveShopTopicSku(shopTopicSku *domain.ShopTopicSku) (domain.ShopTopicSku, error) {
  1777. _, err := configs.Engine.Table("shopTopicSku").Insert(&shopTopicSku)
  1778. if err != nil {
  1779. return *shopTopicSku, err
  1780. }
  1781. return *shopTopicSku, nil
  1782. }
  1783. func SetShopTopicSku(shopTopicSkuMap map[string]interface{}, id int64) (domain.ShopTopicSku, bool, error) {
  1784. var shopTopicSku domain.ShopTopicSku
  1785. _, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Update(shopTopicSkuMap)
  1786. if err != nil {
  1787. return shopTopicSku, false, err
  1788. }
  1789. return shopTopicSku, true, nil
  1790. }
  1791. func DeleteShopTopicSku(id int64) bool {
  1792. var shopTopicSku domain.ShopTopicSku
  1793. i, err := configs.Engine.Table("shopTopicSku").Where("id = ?", id).Delete(&shopTopicSku)
  1794. if err != nil {
  1795. return false
  1796. }
  1797. return i > 0
  1798. }