article.go 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333
  1. package models
  2. import (
  3. "rdluck_tools/orm"
  4. )
  5. type CygxArticle struct {
  6. Id int `orm:"column(id);pk"`
  7. ArticleId int `description:"文章id"`
  8. Title string `description:"标题"`
  9. TitleEn string `description:"英文标题 "`
  10. UpdateFrequency string `description:"更新周期"`
  11. CreateDate string `description:"创建时间"`
  12. PublishDate string `description:"发布时间"`
  13. Body string `description:"内容"`
  14. BodyText string `description:"内容"`
  15. Abstract string `description:"摘要"`
  16. CategoryName string `description:"一级分类"`
  17. SubCategoryName string `description:"二级分类"`
  18. PublishStatus int `description:"发布状态"`
  19. CategoryId int `description:"分类id"`
  20. ExpertBackground string `description:"专家背景"`
  21. ExpertNumber string `description:"专家编号"`
  22. InterviewDate string `description:"访谈日期"`
  23. Department string `description:"作者"`
  24. ArticleIdMd5 string `description:"ID,md5值"`
  25. IsClass int `description:"是否归类,1是,0否"`
  26. IsSummary int `description:"是否是纪要库,1是,0否"`
  27. IsReport int `description:"是否属于报告,1是,0否"`
  28. ReportType int `description:"报告类型,1行业报告,2产业报告,0无"`
  29. FileLink string `description:"下载预览链接"`
  30. }
  31. //新增文章
  32. func AddCygxArticle(item *CygxArticle) (lastId int64, err error) {
  33. o := orm.NewOrm()
  34. lastId, err = o.Insert(item)
  35. return
  36. }
  37. type HomeArticle struct {
  38. ArticleId int `description:"文章id"`
  39. Title string `description:"标题"`
  40. TitleEn string `description:"英文标题 "`
  41. UpdateFrequency string `description:"更新周期"`
  42. CreateDate string `description:"创建时间"`
  43. PublishDate string `description:"发布时间"`
  44. Body string `description:"内容"`
  45. Abstract string `description:"摘要"`
  46. CategoryName string `description:"一级分类"`
  47. SubCategoryName string `description:"二级分类"`
  48. ExpertBackground string `description:"专家背景"`
  49. }
  50. type ArticleDetail struct {
  51. ArticleId int `description:"报告id"`
  52. Title string `description:"标题"`
  53. TitleEn string `description:"英文标题 "`
  54. UpdateFrequency string `description:"更新周期"`
  55. CreateDate string `description:"创建时间"`
  56. PublishDate string `description:"发布时间"`
  57. Body string `description:"内容"`
  58. Abstract string `description:"摘要"`
  59. CategoryName string `description:"一级分类"`
  60. SubCategoryName string `description:"二级分类"`
  61. IsCollect bool `description:"是否收藏:true,已收藏,false:未收藏"`
  62. IsInterviewApply bool `description:"是否申请访谈:true,已申请,false:未申请"`
  63. BodyText string `description:"内容"`
  64. InterviewApplyStatus string `description:"当前访谈申请状态:'待邀请','待访谈','已完成','已取消'"`
  65. InterviewDate string `description:"访谈时间"`
  66. ExpertBackground string `description:"专家背景"`
  67. ExpertNumber string `description:"专家编号"`
  68. Department string `description:"作者"`
  69. SellerMobile string `description:"销售手机号"`
  70. SellerName string `description:"销售名称"`
  71. ArticleIdMd5 string `description:"纪要id"`
  72. IsClass int `description:"是否归类,1是,0否"`
  73. CategoryId int `description:"分类ID"`
  74. FileLink string `description:"下载预览链接"`
  75. SellerList []*SellerRep
  76. }
  77. type SellerRep struct {
  78. SellerMobile string `description:"销售手机号"`
  79. SellerName string `description:"销售名称"`
  80. }
  81. func GetArticleDetailById(articleId int) (item *ArticleDetail, err error) {
  82. o := orm.NewOrm()
  83. sql := `SELECT * FROM cygx_article WHERE article_id = ? `
  84. err = o.Raw(sql, articleId).QueryRow(&item)
  85. return
  86. }
  87. func GetSellerList(articleId int) (items []*SellerRep, err error) {
  88. o := orm.NewOrm()
  89. o.Using("tactics")
  90. sql := `SELECT
  91. ac.phone_number as seller_mobile,
  92. ac.name as seller_name
  93. FROM
  94. article_author AS au
  95. INNER JOIN account_client as ac ON au.author_id = ac.phone_number
  96. WHERE article_id = ?`
  97. _, err = o.Raw(sql, articleId).QueryRows(&items)
  98. return
  99. }
  100. func GetArticleDetailByIdMd5(articleIdMd5 string) (item *ArticleDetail, err error) {
  101. o := orm.NewOrm()
  102. sql := `SELECT * FROM cygx_article WHERE article_id_md5 = ? `
  103. err = o.Raw(sql, articleIdMd5).QueryRow(&item)
  104. return
  105. }
  106. func GetArticleDetailByIdStr(articleIdStr string) (items []*ArticleDetail, err error) {
  107. o := orm.NewOrm()
  108. sql := `SELECT * FROM cygx_article WHERE article_id IN(` + articleIdStr + `) `
  109. _, err = o.Raw(sql).QueryRows(&items)
  110. return
  111. }
  112. //func GetArticlePermission(categoryName string) (item []*ChartPermission, err error) {
  113. // o := orm.NewOrm()
  114. // sql := ` SELECT b.* FROM cygx_permission_mapping AS a
  115. // INNER JOIN chart_permission AS b ON a.chart_permission_id=b.chart_permission_id
  116. // WHERE a.sub_category_name=? `
  117. // _, err = o.Raw(sql, categoryName).QueryRows(&item)
  118. // return
  119. //}
  120. func GetArticlePermission(companyId int) (item *ChartPermission, err error) {
  121. o := orm.NewOrm()
  122. sql := `SELECT
  123. b.*
  124. FROM
  125. cygx_report_mapping AS a
  126. INNER JOIN chart_permission AS b ON a.chart_permission_id = b.chart_permission_id
  127. WHERE
  128. a.category_id = ?`
  129. err = o.Raw(sql, companyId).QueryRow(&item)
  130. //_, err = o.Raw(sql, companyId).QueryRows(&item)
  131. return
  132. }
  133. type ArticleDetailResp struct {
  134. Detail *ArticleDetail
  135. HasPermission int `description:"1:有该行业权限,正常展示,2:无该行业权限,不存在权益客户下,3:无该品类权限,已提交过申请,4:无该行业权限,未提交过申请,5:潜在客户,未提交过申请,6:潜在客户,已提交过申请"`
  136. HasFree int `description:"1:已付费(至少包含一个品类的权限),2:未付费(没有任何品类权限)"`
  137. }
  138. func ModifyArticleExpert(articleId int, expertNumStr, expertContentStr, interviewDateStr, bodyText string) (err error) {
  139. o := orm.NewOrm()
  140. sql := `UPDATE cygx_article SET expert_background=?,expert_number=?,interview_date=?,body_text=? WHERE article_id=? `
  141. _, err = o.Raw(sql, expertContentStr, expertNumStr, interviewDateStr, bodyText, articleId).Exec()
  142. return
  143. }
  144. type ArticleDetailTest struct {
  145. ArticleId int `description:"报告id"`
  146. Title string `description:"标题"`
  147. BodyText string `description:"内容"`
  148. Body string `json:"-" description:"内容"`
  149. }
  150. func GetArticleDetailTestById(articleId int) (item *ArticleDetailTest, err error) {
  151. o := orm.NewOrm()
  152. sql := `SELECT * FROM cygx_article WHERE article_id = ? `
  153. err = o.Raw(sql, articleId).QueryRow(&item)
  154. return
  155. }
  156. func GetArticleAll() (item []*ArticleDetail, err error) {
  157. o := orm.NewOrm()
  158. sql := `SELECT * FROM cygx_article `
  159. _, err = o.Raw(sql).QueryRows(&item)
  160. return
  161. }
  162. func ModifyArticleContent(articleId int, content, expertNumStr, expertContentStr, interviewDateStr string) (err error) {
  163. o := orm.NewOrm()
  164. sql := `UPDATE cygx_article SET body=?,expert_background=?,expert_number=?,interview_date=? WHERE article_id=? `
  165. _, err = o.Raw(sql, content, expertContentStr, expertNumStr, interviewDateStr, articleId).Exec()
  166. return
  167. }
  168. type ElasticArticleDetail struct {
  169. ArticleId int `description:"报告id"`
  170. Title string `description:"标题"`
  171. TitleEn string `description:"英文标题 "`
  172. UpdateFrequency string `description:"更新周期"`
  173. CreateDate string `description:"创建时间"`
  174. PublishDate string `description:"发布时间"`
  175. Abstract string `description:"摘要"`
  176. CategoryName string `description:"一级分类"`
  177. SubCategoryName string `description:"二级分类"`
  178. IsCollect bool `description:"是否收藏:true,已收藏,false:未收藏"`
  179. IsInterviewApply bool `description:"是否申请访谈:true,已申请,false:未申请"`
  180. BodyText string `description:"内容"`
  181. InterviewApplyStatus string `description:"当前访谈申请状态:'待邀请','待访谈','已完成','已取消'"`
  182. InterviewDate string `description:"访谈时间"`
  183. ExpertBackground string `description:"专家背景"`
  184. ExpertNumber string `description:"专家编号"`
  185. Department string `description:"作者"`
  186. SellerMobile string `description:"销售手机号"`
  187. SellerName string `description:"销售名称"`
  188. ArticleIdMd5 string `description:"纪要id"`
  189. }
  190. func GetArticleCountById(articleId int) (count int, err error) {
  191. o := orm.NewOrm()
  192. sql := `SELECT COUNT(1) AS count FROM cygx_article WHERE article_id = ? `
  193. err = o.Raw(sql, articleId).QueryRow(&count)
  194. return
  195. }
  196. type CygxArticles struct {
  197. Id int `orm:"column(id);pk"`
  198. ArticleId int `description:"文章id"`
  199. Title string `description:"标题"`
  200. TitleEn string `description:"英文标题 "`
  201. UpdateFrequency string `description:"更新周期"`
  202. CreateDate string `description:"创建时间"`
  203. PublishDate string `description:"发布时间"`
  204. Body string `description:"内容"`
  205. BodyText string `description:"内容"`
  206. Abstract string `description:"摘要"`
  207. CategoryName string `description:"一级分类"`
  208. SubCategoryName string `description:"二级分类"`
  209. PublishStatus int `description:"发布状态"`
  210. CategoryId int `description:"分类id"`
  211. ExpertBackground string `description:"专家背景"`
  212. ExpertNumber string `description:"专家编号"`
  213. InterviewDate string `description:"访谈日期"`
  214. Department string `description:"作者"`
  215. ArticleIdMd5 string `description:"ID,md5值"`
  216. IsClass int `description:"是否归类,1是,0否"`
  217. IsSummary int `description:"是否是纪要库,1是,0否"`
  218. IsReport int `description:"是否属于报告,1是,0否"`
  219. ReportType int `description:"报告类型,1行业报告,2产业报告,0无"`
  220. }
  221. //新增文章
  222. func AddCygxArticles(item *CygxArticle) (lastId int64, err error) {
  223. o := orm.NewOrm()
  224. lastId, err = o.Insert(item)
  225. return
  226. }
  227. func GetPermissionMappingById(categoryId int) (count int, err error) {
  228. o := orm.NewOrm()
  229. sql := `SELECT COUNT(1) AS count FROM cygx_permission_mapping WHERE category_id = ? `
  230. err = o.Raw(sql, categoryId).QueryRow(&count)
  231. return
  232. }
  233. func GetReportMappingById(categoryId int) (count int, err error) {
  234. o := orm.NewOrm()
  235. sql := `SELECT COUNT(1) AS count FROM cygx_report_mapping WHERE category_id = ? `
  236. err = o.Raw(sql, categoryId).QueryRow(&count)
  237. return
  238. }
  239. type ReportArticle struct {
  240. ArticleId int `description:"文章id"`
  241. Title string `description:"标题"`
  242. TitleEn string `description:"英文标题 "`
  243. UpdateFrequency string `description:"更新周期"`
  244. CreateDate string `description:"创建时间"`
  245. PublishDate string `description:"发布时间"`
  246. Body string `description:"内容"`
  247. Abstract string `description:"摘要"`
  248. CategoryName string `description:"一级分类"`
  249. SubCategoryName string `description:"二级分类"`
  250. ExpertBackground string `description:"专家背景"`
  251. IsRed bool `description:"是否标记红点"`
  252. Readnum int `description:"阅读数量"`
  253. }
  254. func GetReportPermission(categoryName string) (item []*ChartPermission, err error) {
  255. o := orm.NewOrm()
  256. sql := ` SELECT b.* FROM cygx_report_mapping AS a
  257. INNER JOIN chart_permission AS b ON a.chart_permission_id=b.chart_permission_id
  258. WHERE a.sub_category_name=? `
  259. _, err = o.Raw(sql, categoryName).QueryRows(&item)
  260. return
  261. }
  262. type ReportMappingCategoryRep struct {
  263. CategoryId int `description:"文章分类id"`
  264. }
  265. func GetReportMappingCategoryID() (item []*ReportMappingCategoryRep, err error) {
  266. o := orm.NewOrm()
  267. sql := ` SELECT category_id FROM cygx_permission_mapping GROUP BY category_id `
  268. _, err = o.Raw(sql).QueryRows(&item)
  269. return
  270. }
  271. type PermissionMappingCategoryRep struct {
  272. CategoryId int `description:"文章分类id"`
  273. }
  274. func GetPermissionMappingCategoryID() (item []*PermissionMappingCategoryRep, err error) {
  275. o := orm.NewOrm()
  276. sql := ` SELECT category_id FROM cygx_report_mapping GROUP BY category_id `
  277. _, err = o.Raw(sql).QueryRows(&item)
  278. return
  279. }
  280. //检查用户是否阅读某一分类最新文章
  281. func GetUserIsReadThisNewCategoryArticleCount(categoryId, uid int) (count int, err error) {
  282. sqlCount := `SELECT COUNT(1) as count FROM
  283. cygx_article_history_record
  284. WHERE
  285. article_id = ( SELECT article_id FROM cygx_article WHERE category_id = ? ORDER BY publish_date DESC LIMIT 0, 1 )
  286. AND user_id = ?`
  287. o := orm.NewOrm()
  288. err = o.Raw(sqlCount, categoryId, uid).QueryRow(&count)
  289. return
  290. }
  291. type ArticleId struct {
  292. ArticleId int `description:"文章id"`
  293. }
  294. //获取自定义分类的文章ID
  295. func GetCustomArticleId() (item []*ArticleId, err error) {
  296. o := orm.NewOrm()
  297. sql := ` SELECT article_id FROM cygx_article WHERE is_custom = 1 `
  298. _, err = o.Raw(sql).QueryRows(&item)
  299. return
  300. }