class.go 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. // Package postgre
  2. /**
  3. * @ File:
  4. * @ Date: 2021/4/26 11:26
  5. * @ Author: JYQ
  6. * @ Description:
  7. */
  8. package postgre
  9. type PGClass struct {
  10. }
  11. func (PGClass) ClassQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  12. err = getClient().Raw("select fn_class_List_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  13. Scan(&result).Error
  14. return
  15. }
  16. func (PGClass) ClassAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  17. err = getClient().Raw("select fn_class_Add(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  18. Scan(&result).Error
  19. return
  20. }
  21. func (PGClass) ClassEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  22. err = getClient().Raw("select fn_class_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  23. Scan(&result).Error
  24. return
  25. }
  26. func (PGClass) ClassStatusEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  27. err = getClient().Raw("select fn_class_status_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  28. Scan(&result).Error
  29. return
  30. }
  31. func (PGClass) ClassColorEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  32. err = getClient().Raw("select fn_class_color_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  33. Scan(&result).Error
  34. return
  35. }
  36. func (PGClass) ClassVisibleStatusEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  37. err = getClient().Raw("select fn_class_visible_status_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  38. Scan(&result).Error
  39. return
  40. }
  41. func (PGClass) ClassVipUserEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  42. err = getClient().Raw("select fn_class_vip_user_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  43. Scan(&result).Error
  44. return
  45. }
  46. func (PGClass) SttPlanBasicListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  47. err = getClient().Raw("select fn_stt_plan_basic_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  48. Scan(&result).Error
  49. return
  50. }
  51. func (PGClass) SttPlanBasicAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  52. err = getClient().Raw("select fn_stt_plan_basic_add(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  53. Scan(&result).Error
  54. return
  55. }
  56. func (PGClass) SttPlanBasicEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  57. err = getClient().Raw("select fn_stt_plan_basic_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  58. Scan(&result).Error
  59. return
  60. }
  61. func (PGClass) SttPlanBasicShopEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  62. err = getClient().Raw("select fn_stt_plan_basic_shop_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  63. Scan(&result).Error
  64. return
  65. }
  66. func (PGClass) SttPlanBasicStatusEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  67. err = getClient().Raw("select fn_stt_plan_basic_status_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  68. Scan(&result).Error
  69. return
  70. }
  71. func (PGClass) SttPlanPublish(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  72. err = getClient().Raw("select fn_stt_plan_publish(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  73. Scan(&result).Error
  74. return
  75. }
  76. func (PGClass) SttPlanPreview(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  77. err = getClient().Raw("select fn_stt_plan_preview(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  78. Scan(&result).Error
  79. return
  80. }
  81. func (PGClass) SttPlanCopy(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  82. err = getClient().Raw("select fn_stt_plan_copy(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  83. Scan(&result).Error
  84. return
  85. }
  86. func (PGClass) SttPlanDetailListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  87. err = getClient().Raw("select fn_stt_plan_detail_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  88. Scan(&result).Error
  89. return
  90. }
  91. func (PGClass) SttPlanDetailBatchSave(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  92. err = getClient().Raw("select fn_stt_plan_detail_batch_save(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  93. Scan(&result).Error
  94. return
  95. }
  96. func (PGClass) STTBasicListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  97. err = getClient().Raw("select fn_stt_basic_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  98. Scan(&result).Error
  99. return
  100. }
  101. func (PGClass) STTBasicAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  102. err = getClient().Raw("select fn_stt_basic_add(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  103. Scan(&result).Error
  104. return
  105. }
  106. func (PGClass) STTBasicEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  107. err = getClient().Raw("select fn_stt_basic_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  108. Scan(&result).Error
  109. return
  110. }
  111. func (PGClass) STTBasicStatusEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  112. err = getClient().Raw("select fn_stt_basic_status_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  113. Scan(&result).Error
  114. return
  115. }
  116. func (PGClass) SchoolTimetablePreview(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  117. err = getClient().Raw("select fn_stt_detail_preview(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  118. Scan(&result).Error
  119. return
  120. }
  121. func (PGClass) SchoolTimeTableCopy(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  122. err = getClient().Raw("select fn_stt_copy(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  123. Scan(&result).Error
  124. return
  125. }
  126. func (PGClass) STTBasicOfflineEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  127. err = getClient().Raw("select fn_stt_basic_offline_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  128. Scan(&result).Error
  129. return
  130. }
  131. func (PGClass) STTDetailListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  132. err = getClient().Raw("select fn_stt_detail_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  133. Scan(&result).Error
  134. return
  135. }
  136. func (PGClass) STTDetailBatchSave(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  137. err = getClient().Raw("select fn_stt_detail_batch_save(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  138. Scan(&result).Error
  139. return
  140. }
  141. func (PGClass) STTDetailAllowDelCheck(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  142. err = getClient().Raw("select fn_stt_detail_allow_del_check(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  143. Scan(&result).Error
  144. return
  145. }
  146. func (PGClass) ClassSimpleQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  147. err = getClient().Raw("select fn_class_simple_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  148. Scan(&result).Error
  149. return
  150. }