BookModel.go 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870
  1. package models
  2. import (
  3. "bytes"
  4. "crypto/md5"
  5. "errors"
  6. "fmt"
  7. "io"
  8. "io/ioutil"
  9. "os"
  10. "path/filepath"
  11. "regexp"
  12. "strconv"
  13. "strings"
  14. "time"
  15. "github.com/PuerkitoBio/goquery"
  16. "github.com/astaxie/beego"
  17. "github.com/astaxie/beego/logs"
  18. "github.com/astaxie/beego/orm"
  19. "github.com/lifei6671/mindoc/conf"
  20. "github.com/lifei6671/mindoc/utils/cryptil"
  21. "github.com/lifei6671/mindoc/utils/filetil"
  22. "github.com/lifei6671/mindoc/utils/requests"
  23. "github.com/lifei6671/mindoc/utils/ziptil"
  24. "gopkg.in/russross/blackfriday.v2"
  25. )
  26. // Book struct .
  27. type Book struct {
  28. BookId int `orm:"pk;auto;unique;column(book_id)" json:"book_id"`
  29. // BookName 项目名称.
  30. BookName string `orm:"column(book_name);size(500)" json:"book_name"`
  31. // Identify 项目唯一标识.
  32. Identify string `orm:"column(identify);size(100);unique" json:"identify"`
  33. //是否是自动发布 0 否/1 是
  34. AutoRelease int `orm:"column(auto_release);type(int);default(0)" json:"auto_release"`
  35. //是否开启下载功能 0 是/1 否
  36. IsDownload int `orm:"column(is_download);type(int);default(0)" json:"is_download"`
  37. OrderIndex int `orm:"column(order_index);type(int);default(0)" json:"order_index"`
  38. // Description 项目描述.
  39. Description string `orm:"column(description);size(2000)" json:"description"`
  40. //发行公司
  41. Publisher string `orm:"column(publisher);size(500)" json:"publisher"`
  42. Label string `orm:"column(label);size(500)" json:"label"`
  43. // PrivatelyOwned 项目私有: 0 公开/ 1 私有
  44. PrivatelyOwned int `orm:"column(privately_owned);type(int);default(0)" json:"privately_owned"`
  45. // 当项目是私有时的访问Token.
  46. PrivateToken string `orm:"column(private_token);size(500);null" json:"private_token"`
  47. //状态:0 正常/1 已删除
  48. Status int `orm:"column(status);type(int);default(0)" json:"status"`
  49. //默认的编辑器.
  50. Editor string `orm:"column(editor);size(50)" json:"editor"`
  51. // DocCount 包含文档数量.
  52. DocCount int `orm:"column(doc_count);type(int)" json:"doc_count"`
  53. // CommentStatus 评论设置的状态:open 为允许所有人评论,closed 为不允许评论, group_only 仅允许参与者评论 ,registered_only 仅允许注册者评论.
  54. CommentStatus string `orm:"column(comment_status);size(20);default(open)" json:"comment_status"`
  55. CommentCount int `orm:"column(comment_count);type(int)" json:"comment_count"`
  56. //封面地址
  57. Cover string `orm:"column(cover);size(1000)" json:"cover"`
  58. //主题风格
  59. Theme string `orm:"column(theme);size(255);default(default)" json:"theme"`
  60. // CreateTime 创建时间 .
  61. CreateTime time.Time `orm:"type(datetime);column(create_time);auto_now_add" json:"create_time"`
  62. //每个文档保存的历史记录数量,0 为不限制
  63. HistoryCount int `orm:"column(history_count);type(int);default(0)" json:"history_count"`
  64. //是否启用分享,0启用/1不启用
  65. IsEnableShare int `orm:"column(is_enable_share);type(int);default(0)" json:"is_enable_share"`
  66. MemberId int `orm:"column(member_id);size(100)" json:"member_id"`
  67. ModifyTime time.Time `orm:"type(datetime);column(modify_time);null;auto_now" json:"modify_time"`
  68. Version int64 `orm:"type(bigint);column(version)" json:"version"`
  69. //是否使用第一篇文章项目为默认首页,0 否/1 是
  70. IsUseFirstDocument int `orm:"column(is_use_first_document);type(int);default(0)" json:"is_use_first_document"`
  71. }
  72. // TableName 获取对应数据库表名.
  73. func (book *Book) TableName() string {
  74. return "books"
  75. }
  76. // TableEngine 获取数据使用的引擎.
  77. func (book *Book) TableEngine() string {
  78. return "INNODB"
  79. }
  80. func (book *Book) TableNameWithPrefix() string {
  81. return conf.GetDatabasePrefix() + book.TableName()
  82. }
  83. func NewBook() *Book {
  84. return &Book{}
  85. }
  86. //添加一个项目
  87. func (book *Book) Insert() error {
  88. o := orm.NewOrm()
  89. // o.Begin()
  90. _, err := o.Insert(book)
  91. if err == nil {
  92. if book.Label != "" {
  93. NewLabel().InsertOrUpdateMulti(book.Label)
  94. }
  95. relationship := NewRelationship()
  96. relationship.BookId = book.BookId
  97. relationship.RoleId = 0
  98. relationship.MemberId = book.MemberId
  99. err = relationship.Insert()
  100. if err != nil {
  101. logs.Error("插入项目与用户关联 => ", err)
  102. //o.Rollback()
  103. return err
  104. }
  105. document := NewDocument()
  106. document.BookId = book.BookId
  107. document.DocumentName = "空白文档"
  108. document.MemberId = book.MemberId
  109. err = document.InsertOrUpdate()
  110. if err != nil {
  111. //o.Rollback()
  112. return err
  113. }
  114. //o.Commit()
  115. return nil
  116. }
  117. //o.Rollback()
  118. return err
  119. }
  120. func (book *Book) Find(id int) (*Book, error) {
  121. if id <= 0 {
  122. return book, ErrInvalidParameter
  123. }
  124. o := orm.NewOrm()
  125. err := o.QueryTable(book.TableNameWithPrefix()).Filter("book_id", id).One(book)
  126. return book, err
  127. }
  128. //更新一个项目
  129. func (book *Book) Update(cols ...string) error {
  130. o := orm.NewOrm()
  131. temp := NewBook()
  132. temp.BookId = book.BookId
  133. if err := o.Read(temp); err != nil {
  134. return err
  135. }
  136. if book.Label != "" || temp.Label != "" {
  137. go NewLabel().InsertOrUpdateMulti(book.Label + "," + temp.Label)
  138. }
  139. _, err := o.Update(book, cols...)
  140. return err
  141. }
  142. //复制项目
  143. func (book *Book) Copy(identify string) error {
  144. o := orm.NewOrm()
  145. err := o.QueryTable(book.TableNameWithPrefix()).Filter("identify",identify).One(book)
  146. if err != nil {
  147. beego.Error("查询项目时出错 -> ",err)
  148. return err
  149. }
  150. if err := o.Begin();err != nil {
  151. beego.Error("开启事物时出错 -> ",err)
  152. return err
  153. }
  154. bookId := book.BookId
  155. book.BookId = 0
  156. book.Identify = book.Identify + fmt.Sprintf("%s-%s",identify,strconv.FormatInt(time.Now().UnixNano(), 32))
  157. book.BookName = book.BookName + "[副本]"
  158. book.CreateTime = time.Now()
  159. book.CommentCount = 0
  160. book.HistoryCount = 0
  161. if _,err := o.Insert(book);err != nil {
  162. beego.Error("复制项目时出错 -> ",err)
  163. o.Rollback()
  164. return err
  165. }
  166. var rels []*Relationship
  167. if _,err := o.QueryTable(NewRelationship().TableNameWithPrefix()).Filter("book_id",bookId).All(&rels); err != nil {
  168. beego.Error("复制项目关系时出错 -> ",err)
  169. o.Rollback()
  170. return err
  171. }
  172. for _,rel := range rels {
  173. rel.BookId = book.BookId
  174. rel.RelationshipId = 0
  175. if _,err := o.Insert(rel);err != nil {
  176. beego.Error("复制项目关系时出错 -> ",err)
  177. o.Rollback()
  178. return err
  179. }
  180. }
  181. var docs []*Document
  182. if _,err := o.QueryTable(NewDocument().TableNameWithPrefix()).Filter("book_id",bookId).Filter("parent_id",0).All(&docs);err != nil && err != orm.ErrNoRows {
  183. beego.Error("读取项目文档时出错 -> ",err)
  184. o.Rollback()
  185. return err
  186. }
  187. if len(docs) > 0 {
  188. if err := recursiveInsertDocument(docs,o,book.BookId,0);err != nil {
  189. beego.Error("复制项目时出错 -> ",err)
  190. o.Rollback()
  191. return err
  192. }
  193. }
  194. return o.Commit()
  195. }
  196. //递归的复制文档
  197. func recursiveInsertDocument(docs []*Document,o orm.Ormer,bookId int,parentId int) error {
  198. for _,doc := range docs {
  199. docId := doc.DocumentId
  200. doc.DocumentId = 0
  201. doc.ParentId = parentId
  202. doc.BookId = bookId
  203. doc.Version = time.Now().Unix()
  204. if _,err := o.Insert(doc);err != nil {
  205. beego.Error("插入项目时出错 -> ",err)
  206. return err
  207. }
  208. var attachList []*Attachment
  209. //读取所有附件列表
  210. if _,err := o.QueryTable(NewAttachment().TableNameWithPrefix()).Filter("document_id",docId).All(&attachList); err == nil {
  211. for _,attach := range attachList {
  212. attach.BookId = bookId
  213. attach.DocumentId = doc.DocumentId
  214. attach.AttachmentId = 0
  215. if _,err := o.Insert(attach);err != nil {
  216. return err
  217. }
  218. }
  219. }
  220. var subDocs []*Document
  221. if _,err := o.QueryTable(NewDocument().TableNameWithPrefix()).Filter("parent_id",docId).All(&subDocs);err != nil && err != orm.ErrNoRows {
  222. beego.Error("读取文档时出错 -> ",err)
  223. return err
  224. }
  225. if len(subDocs) > 0{
  226. if err := recursiveInsertDocument(subDocs,o,bookId,doc.DocumentId);err != nil {
  227. return err
  228. }
  229. }
  230. }
  231. return nil
  232. }
  233. //根据指定字段查询结果集.
  234. func (book *Book) FindByField(field string, value interface{},cols ...string) ([]*Book, error) {
  235. o := orm.NewOrm()
  236. var books []*Book
  237. _, err := o.QueryTable(book.TableNameWithPrefix()).Filter(field, value).All(&books,cols...)
  238. return books, err
  239. }
  240. //根据指定字段查询一个结果.
  241. func (book *Book) FindByFieldFirst(field string, value interface{}) (*Book, error) {
  242. o := orm.NewOrm()
  243. err := o.QueryTable(book.TableNameWithPrefix()).Filter(field, value).One(book)
  244. return book, err
  245. }
  246. //根据项目标识查询项目
  247. func (book *Book) FindByIdentify(identify string) (*Book, error) {
  248. o := orm.NewOrm()
  249. err := o.QueryTable(book.TableNameWithPrefix()).Filter("identify", identify).One(book)
  250. return book, err
  251. }
  252. //分页查询指定用户的项目
  253. func (book *Book) FindToPager(pageIndex, pageSize, memberId int) (books []*BookResult, totalCount int, err error) {
  254. relationship := NewRelationship()
  255. o := orm.NewOrm()
  256. sql1 := "SELECT COUNT(book.book_id) AS total_count FROM " + book.TableNameWithPrefix() + " AS book LEFT JOIN " +
  257. relationship.TableNameWithPrefix() + " AS rel ON book.book_id=rel.book_id AND rel.member_id = ? WHERE rel.relationship_id > 0 "
  258. err = o.Raw(sql1, memberId).QueryRow(&totalCount)
  259. if err != nil {
  260. return
  261. }
  262. offset := (pageIndex - 1) * pageSize
  263. sql2 := "SELECT book.*,rel.member_id,rel.role_id,m.account as create_name FROM " + book.TableNameWithPrefix() + " AS book" +
  264. " LEFT JOIN " + relationship.TableNameWithPrefix() + " AS rel ON book.book_id=rel.book_id AND rel.member_id = ?" +
  265. " LEFT JOIN " + relationship.TableNameWithPrefix() + " AS rel1 ON book.book_id=rel1.book_id AND rel1.role_id=0" +
  266. " LEFT JOIN " + NewMember().TableNameWithPrefix() + " AS m ON rel1.member_id=m.member_id " +
  267. " WHERE rel.relationship_id > 0 ORDER BY book.order_index DESC,book.book_id DESC LIMIT " + fmt.Sprintf("%d,%d", offset, pageSize)
  268. _, err = o.Raw(sql2, memberId).QueryRows(&books)
  269. if err != nil {
  270. logs.Error("分页查询项目列表 => ", err)
  271. return
  272. }
  273. sql := "SELECT m.account,doc.modify_time FROM md_documents AS doc LEFT JOIN md_members AS m ON doc.modify_at=m.member_id WHERE book_id = ? LIMIT 1 ORDER BY doc.modify_time DESC"
  274. if err == nil && len(books) > 0 {
  275. for index, book := range books {
  276. var text struct {
  277. Account string
  278. ModifyTime time.Time
  279. }
  280. err1 := o.Raw(sql, book.BookId).QueryRow(&text)
  281. if err1 == nil {
  282. books[index].LastModifyText = text.Account + " 于 " + text.ModifyTime.Format("2006-01-02 15:04:05")
  283. }
  284. if book.RoleId == 0 {
  285. book.RoleName = "创始人"
  286. } else if book.RoleId == 1 {
  287. book.RoleName = "管理员"
  288. } else if book.RoleId == 2 {
  289. book.RoleName = "编辑者"
  290. } else if book.RoleId == 3 {
  291. book.RoleName = "观察者"
  292. }
  293. }
  294. }
  295. return
  296. }
  297. // 彻底删除项目.
  298. func (book *Book) ThoroughDeleteBook(id int) error {
  299. if id <= 0 {
  300. return ErrInvalidParameter
  301. }
  302. o := orm.NewOrm()
  303. book, err := book.Find(id)
  304. if err != nil {
  305. return err
  306. }
  307. o.Begin()
  308. sql2 := "DELETE FROM " + NewDocument().TableNameWithPrefix() + " WHERE book_id = ?"
  309. _, err = o.Raw(sql2, book.BookId).Exec()
  310. if err != nil {
  311. o.Rollback()
  312. return err
  313. }
  314. sql3 := "DELETE FROM " + book.TableNameWithPrefix() + " WHERE book_id = ?"
  315. _, err = o.Raw(sql3, book.BookId).Exec()
  316. if err != nil {
  317. o.Rollback()
  318. return err
  319. }
  320. sql4 := "DELETE FROM " + NewRelationship().TableNameWithPrefix() + " WHERE book_id = ?"
  321. _, err = o.Raw(sql4, book.BookId).Exec()
  322. if err != nil {
  323. o.Rollback()
  324. return err
  325. }
  326. if book.Label != "" {
  327. NewLabel().InsertOrUpdateMulti(book.Label)
  328. }
  329. os.RemoveAll(filepath.Join(conf.WorkingDirectory, "uploads", "books", strconv.Itoa(id)))
  330. return o.Commit()
  331. }
  332. //分页查找系统首页数据.
  333. func (book *Book) FindForHomeToPager(pageIndex, pageSize, member_id int) (books []*BookResult, totalCount int, err error) {
  334. o := orm.NewOrm()
  335. offset := (pageIndex - 1) * pageSize
  336. //如果是登录用户
  337. if member_id > 0 {
  338. sql1 := "SELECT COUNT(*) FROM md_books AS book LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.member_id = ? WHERE relationship_id > 0 OR book.privately_owned = 0"
  339. err = o.Raw(sql1, member_id).QueryRow(&totalCount)
  340. if err != nil {
  341. return
  342. }
  343. sql2 := `SELECT book.*,rel1.*,member.account AS create_name,member.real_name FROM md_books AS book
  344. LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.member_id = ?
  345. LEFT JOIN md_relationship AS rel1 ON rel1.book_id = book.book_id AND rel1.role_id = 0
  346. LEFT JOIN md_members AS member ON rel1.member_id = member.member_id
  347. WHERE rel.relationship_id > 0 OR book.privately_owned = 0 ORDER BY order_index DESC ,book.book_id DESC LIMIT ?,?`
  348. _, err = o.Raw(sql2, member_id, offset, pageSize).QueryRows(&books)
  349. } else {
  350. count, err1 := o.QueryTable(book.TableNameWithPrefix()).Filter("privately_owned", 0).Count()
  351. if err1 != nil {
  352. err = err1
  353. return
  354. }
  355. totalCount = int(count)
  356. sql := `SELECT book.*,rel.*,member.account AS create_name,member.real_name FROM md_books AS book
  357. LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.role_id = 0
  358. LEFT JOIN md_members AS member ON rel.member_id = member.member_id
  359. WHERE book.privately_owned = 0 ORDER BY order_index DESC ,book.book_id DESC LIMIT ?,?`
  360. _, err = o.Raw(sql, offset, pageSize).QueryRows(&books)
  361. }
  362. return
  363. }
  364. //分页全局搜索.
  365. func (book *Book) FindForLabelToPager(keyword string, pageIndex, pageSize, memberId int) (books []*BookResult, totalCount int, err error) {
  366. o := orm.NewOrm()
  367. keyword = "%" + keyword + "%"
  368. offset := (pageIndex - 1) * pageSize
  369. //如果是登录用户
  370. if memberId > 0 {
  371. sql1 := "SELECT COUNT(*) FROM md_books AS book LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.member_id = ? WHERE (relationship_id > 0 OR book.privately_owned = 0) AND book.label LIKE ?"
  372. err = o.Raw(sql1, memberId, keyword).QueryRow(&totalCount)
  373. if err != nil {
  374. return
  375. }
  376. sql2 := `SELECT book.*,rel1.*,member.account AS create_name FROM md_books AS book
  377. LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.member_id = ?
  378. LEFT JOIN md_relationship AS rel1 ON rel1.book_id = book.book_id AND rel1.role_id = 0
  379. LEFT JOIN md_members AS member ON rel1.member_id = member.member_id
  380. WHERE (rel.relationship_id > 0 OR book.privately_owned = 0) AND book.label LIKE ? ORDER BY order_index DESC ,book.book_id DESC LIMIT ?,?`
  381. _, err = o.Raw(sql2, memberId, keyword, offset, pageSize).QueryRows(&books)
  382. return
  383. } else {
  384. count, err1 := o.QueryTable(NewBook().TableNameWithPrefix()).Filter("privately_owned", 0).Filter("label__icontains", keyword).Count()
  385. if err1 != nil {
  386. err = err1
  387. return
  388. }
  389. totalCount = int(count)
  390. sql := `SELECT book.*,rel.*,member.account AS create_name FROM md_books AS book
  391. LEFT JOIN md_relationship AS rel ON rel.book_id = book.book_id AND rel.role_id = 0
  392. LEFT JOIN md_members AS member ON rel.member_id = member.member_id
  393. WHERE book.privately_owned = 0 AND book.label LIKE ? ORDER BY order_index DESC ,book.book_id DESC LIMIT ?,?`
  394. _, err = o.Raw(sql, keyword, offset, pageSize).QueryRows(&books)
  395. return
  396. }
  397. }
  398. //发布文档
  399. func (book *Book) ReleaseContent(bookId int) {
  400. o := orm.NewOrm()
  401. var docs []*Document
  402. _, err := o.QueryTable(NewDocument().TableNameWithPrefix()).Filter("book_id", bookId).All(&docs, "document_id", "identify", "content")
  403. if err != nil {
  404. beego.Error("发布失败 =>",bookId, err)
  405. return
  406. }
  407. for _, item := range docs {
  408. if item.Content != "" {
  409. item.Release = item.Content
  410. bufio := bytes.NewReader([]byte(item.Content))
  411. //解析文档中非本站的链接,并设置为新窗口打开
  412. if content, err := goquery.NewDocumentFromReader(bufio); err == nil {
  413. content.Find("a").Each(func(i int, contentSelection *goquery.Selection) {
  414. if src, ok := contentSelection.Attr("href"); ok {
  415. if strings.HasPrefix(src, "http://") || strings.HasPrefix(src, "https://") {
  416. //beego.Info(src,conf.BaseUrl,strings.HasPrefix(src,conf.BaseUrl))
  417. if conf.BaseUrl != "" && !strings.HasPrefix(src, conf.BaseUrl) {
  418. contentSelection.SetAttr("target", "_blank")
  419. if html, err := content.Html(); err == nil {
  420. item.Release = html
  421. }
  422. }
  423. }
  424. }
  425. })
  426. }
  427. }
  428. attachList, err := NewAttachment().FindListByDocumentId(item.DocumentId)
  429. if err == nil && len(attachList) > 0 {
  430. content := bytes.NewBufferString("<div class=\"attach-list\"><strong>附件</strong><ul>")
  431. for _, attach := range attachList {
  432. if strings.HasPrefix(attach.HttpPath, "/") {
  433. attach.HttpPath = strings.TrimSuffix(conf.BaseUrl, "/") + attach.HttpPath
  434. }
  435. li := fmt.Sprintf("<li><a href=\"%s\" target=\"_blank\" title=\"%s\">%s</a></li>", attach.HttpPath, attach.FileName, attach.FileName)
  436. content.WriteString(li)
  437. }
  438. content.WriteString("</ul></div>")
  439. item.Release += content.String()
  440. }
  441. _, err = o.Update(item, "release")
  442. if err != nil {
  443. beego.Error(fmt.Sprintf("发布失败 => %+v", item), err)
  444. } else {
  445. //当文档发布后,需要清除已缓存的转换文档和文档缓存
  446. if doc, err := NewDocument().Find(item.DocumentId); err == nil {
  447. doc.PutToCache()
  448. } else {
  449. doc.RemoveCache()
  450. }
  451. if err := os.RemoveAll(filepath.Join(conf.WorkingDirectory, "uploads", "books", strconv.Itoa(bookId))); err != nil {
  452. beego.Error("删除已缓存的文档目录失败 => ",filepath.Join(conf.WorkingDirectory, "uploads", "books", strconv.Itoa(bookId)))
  453. }
  454. }
  455. }
  456. }
  457. //重置文档数量
  458. func (book *Book) ResetDocumentNumber(bookId int) {
  459. o := orm.NewOrm()
  460. totalCount, err := o.QueryTable(NewDocument().TableNameWithPrefix()).Filter("book_id", bookId).Count()
  461. if err == nil {
  462. _,err = o.Raw("UPDATE md_books SET doc_count = ? WHERE book_id = ?", int(totalCount), bookId).Exec()
  463. if err != nil {
  464. beego.Error("重置文档数量失败 =>",bookId,err)
  465. }
  466. } else {
  467. beego.Error("获取文档数量失败 =>",bookId,err)
  468. }
  469. }
  470. //导入项目
  471. func (book *Book) ImportBook(zipPath string) error {
  472. if !filetil.FileExists(zipPath) {
  473. return errors.New("文件不存在 => " + zipPath)
  474. }
  475. w := md5.New()
  476. io.WriteString(w, zipPath) //将str写入到w中
  477. io.WriteString(w, time.Now().String())
  478. io.WriteString(w, book.BookName)
  479. md5str := fmt.Sprintf("%x", w.Sum(nil)) //w.Sum(nil)将w的hash转成[]byte格式
  480. tempPath := filepath.Join(os.TempDir(), md5str)
  481. if err := os.MkdirAll(tempPath, 0766); err != nil {
  482. beego.Error("创建导入目录出错 => ",err)
  483. }
  484. //如果加压缩失败
  485. if err := ziptil.Unzip(zipPath, tempPath); err != nil {
  486. return err
  487. }
  488. //当导入结束后,删除临时文件
  489. //defer os.RemoveAll(tempPath)
  490. for {
  491. //如果当前目录下只有一个目录,则重置根目录
  492. if entries, err := ioutil.ReadDir(tempPath); err == nil && len(entries) == 1 {
  493. dir := entries[0]
  494. if dir.IsDir() && dir.Name() != "." && dir.Name() != ".." {
  495. tempPath = filepath.Join(tempPath, dir.Name())
  496. break
  497. }
  498. } else {
  499. break
  500. }
  501. }
  502. tempPath = strings.Replace(tempPath, "\\", "/", -1)
  503. docMap := make(map[string]int, 0)
  504. o := orm.NewOrm()
  505. o.Insert(book)
  506. relationship := NewRelationship()
  507. relationship.BookId = book.BookId
  508. relationship.RoleId = 0
  509. relationship.MemberId = book.MemberId
  510. relationship.Insert()
  511. err := filepath.Walk(tempPath, func(path string, info os.FileInfo, err error) error {
  512. path = strings.Replace(path, "\\", "/", -1)
  513. if path == tempPath {
  514. return nil
  515. }
  516. if !info.IsDir() {
  517. ext := filepath.Ext(info.Name())
  518. //如果是Markdown文件
  519. if strings.EqualFold(ext, ".md") || strings.EqualFold(ext, ".markdown") {
  520. beego.Info("正在处理 =>",path,info.Name())
  521. doc := NewDocument()
  522. doc.BookId = book.BookId
  523. doc.MemberId = book.MemberId
  524. docIdentify := strings.Replace(strings.TrimPrefix(path, tempPath+"/"), "/", "-", -1)
  525. if ok, err := regexp.MatchString(`[a-z]+[a-zA-Z0-9_.\-]*$`, docIdentify); !ok || err != nil {
  526. docIdentify = "import-" + docIdentify
  527. }
  528. doc.Identify = docIdentify
  529. //匹配图片,如果图片语法是在代码块中,这里同样会处理
  530. re := regexp.MustCompile(`!\[(.*?)\]\((.*?)\)`)
  531. markdown, err := filetil.ReadFileAndIgnoreUTF8BOM(path)
  532. if err != nil {
  533. return err
  534. }
  535. //处理图片
  536. doc.Markdown = re.ReplaceAllStringFunc(string(markdown), func(image string) string {
  537. images := re.FindAllSubmatch([]byte(image), -1)
  538. if len(images) <= 0 || len(images[0]) < 3 {
  539. return image
  540. }
  541. originalImageUrl := string(images[0][2])
  542. imageUrl := strings.Replace(string(originalImageUrl), "\\", "/", -1)
  543. //如果是本地路径,则需要将图片复制到项目目录
  544. if !strings.HasPrefix(imageUrl, "http://") &&
  545. !strings.HasPrefix(imageUrl, "https://") &&
  546. !strings.HasPrefix(imageUrl,"ftp://") {
  547. //如果路径中存在参数
  548. if l := strings.Index(imageUrl,"?"); l > 0 {
  549. imageUrl = imageUrl[:l]
  550. }
  551. if strings.HasPrefix(imageUrl, "/") {
  552. imageUrl = filepath.Join(tempPath, imageUrl)
  553. } else if strings.HasPrefix(imageUrl, "./") {
  554. imageUrl = filepath.Join(filepath.Dir(path), strings.TrimPrefix(imageUrl, "./"))
  555. } else if strings.HasPrefix(imageUrl, "../") {
  556. imageUrl = filepath.Join(filepath.Dir(path), imageUrl)
  557. } else {
  558. imageUrl = filepath.Join(filepath.Dir(path), imageUrl)
  559. }
  560. imageUrl = strings.Replace(imageUrl, "\\", "/", -1)
  561. dstFile := filepath.Join(conf.WorkingDirectory, "uploads", time.Now().Format("200601"), strings.TrimPrefix(imageUrl, tempPath))
  562. if filetil.FileExists(imageUrl) {
  563. filetil.CopyFile(imageUrl, dstFile)
  564. imageUrl = strings.TrimPrefix(strings.Replace(dstFile,"\\","/",-1), strings.Replace(conf.WorkingDirectory,"\\","/",-1))
  565. if !strings.HasPrefix(imageUrl, "/") && !strings.HasPrefix(imageUrl, "\\") {
  566. imageUrl = "/" + imageUrl
  567. }
  568. }
  569. } else {
  570. imageExt := cryptil.Md5Crypt(imageUrl) + filepath.Ext(imageUrl)
  571. dstFile := filepath.Join(conf.WorkingDirectory, "uploads", time.Now().Format("200601"), imageExt)
  572. if err := requests.DownloadAndSaveFile(imageUrl, dstFile); err == nil {
  573. imageUrl = strings.TrimPrefix(strings.Replace(dstFile, "\\", "/", -1), strings.Replace(conf.WorkingDirectory, "\\", "/", -1))
  574. if !strings.HasPrefix(imageUrl, "/") && !strings.HasPrefix(imageUrl, "\\") {
  575. imageUrl = "/" + imageUrl
  576. }
  577. }
  578. }
  579. imageUrl = strings.Replace(strings.TrimSuffix(image, originalImageUrl+")")+ conf.URLForWithCdnImage(imageUrl) +")", "\\", "/", -1)
  580. return imageUrl
  581. })
  582. linkRegexp := regexp.MustCompile(`\[(.*?)\]\((.*?)\)`)
  583. //处理链接
  584. doc.Markdown = linkRegexp.ReplaceAllStringFunc(doc.Markdown, func(link string) string {
  585. links := linkRegexp.FindAllStringSubmatch(link, -1)
  586. originalLink := links[0][2]
  587. var linkPath string
  588. var err error
  589. if strings.HasPrefix(originalLink,"<") {
  590. originalLink = strings.TrimPrefix(originalLink,"<")
  591. }
  592. if strings.HasSuffix(originalLink,">") {
  593. originalLink = strings.TrimSuffix(originalLink,">")
  594. }
  595. //如果是从根目录开始,
  596. if strings.HasPrefix(originalLink, "/") {
  597. linkPath, err = filepath.Abs(filepath.Join(tempPath, originalLink))
  598. } else if strings.HasPrefix(originalLink, "./") {
  599. linkPath, err = filepath.Abs(filepath.Join(filepath.Dir(path), originalLink[1:]))
  600. } else{
  601. linkPath, err = filepath.Abs(filepath.Join(filepath.Dir(path), originalLink))
  602. }
  603. if err == nil {
  604. //如果本地存在该链接
  605. if filetil.FileExists(linkPath) {
  606. ext := filepath.Ext(linkPath)
  607. //beego.Info("当前后缀 -> ",ext)
  608. //如果链接是Markdown文件,则生成文档标识,否则,将目标文件复制到项目目录
  609. if strings.EqualFold(ext, ".md") || strings.EqualFold(ext, ".markdown") {
  610. docIdentify := strings.Replace(strings.TrimPrefix(strings.Replace(linkPath, "\\", "/", -1), tempPath+"/"), "/", "-", -1)
  611. //beego.Info(originalLink, "|", linkPath, "|", docIdentify)
  612. if ok, err := regexp.MatchString(`[a-z]+[a-zA-Z0-9_.\-]*$`, docIdentify); !ok || err != nil {
  613. docIdentify = "import-" + docIdentify
  614. }
  615. docIdentify = strings.TrimSuffix(docIdentify, "-README.md")
  616. link = strings.TrimSuffix(link, originalLink+")") + conf.URLFor("DocumentController.Read", ":key", book.Identify, ":id", docIdentify) + ")"
  617. } else {
  618. dstPath := filepath.Join(conf.WorkingDirectory, "uploads", time.Now().Format("200601"), originalLink)
  619. filetil.CopyFile(linkPath, dstPath)
  620. tempLink := conf.BaseUrl + strings.TrimPrefix(strings.Replace(dstPath, "\\", "/", -1), strings.Replace(conf.WorkingDirectory, "\\", "/", -1))
  621. link = strings.TrimSuffix(link, originalLink+")") + tempLink + ")"
  622. }
  623. }else{
  624. beego.Info("文件不存在 ->",linkPath)
  625. }
  626. }
  627. return link
  628. })
  629. //codeRe := regexp.MustCompile("```\\w+")
  630. //doc.Markdown = codeRe.ReplaceAllStringFunc(doc.Markdown, func(s string) string {
  631. // //beego.Info(s)
  632. // return strings.Replace(s,"```","``` ",-1)
  633. //})
  634. doc.Content = string(blackfriday.Run([]byte(doc.Markdown)))
  635. doc.Version = time.Now().Unix()
  636. //解析文档名称,默认使用第一个h标签为标题
  637. docName := strings.TrimSuffix(info.Name(), ext)
  638. for _, line := range strings.Split(doc.Markdown, "\n") {
  639. if strings.HasPrefix(line, "#") {
  640. docName = strings.TrimLeft(line, "#")
  641. break
  642. }
  643. }
  644. doc.DocumentName = strings.TrimSpace(docName)
  645. parentId := 0
  646. parentIdentify := strings.Replace(strings.Trim(strings.TrimSuffix(strings.TrimPrefix(path, tempPath), info.Name()), "/"), "/", "-", -1)
  647. if parentIdentify != "" {
  648. if ok, err := regexp.MatchString(`[a-z]+[a-zA-Z0-9_.\-]*$`, parentIdentify); !ok || err != nil {
  649. parentIdentify = "import-" + parentIdentify
  650. }
  651. if id, ok := docMap[parentIdentify]; ok {
  652. parentId = id
  653. }
  654. }
  655. if strings.EqualFold(info.Name(), "README.md") {
  656. beego.Info(path, "|", info.Name(), "|", parentIdentify, "|", parentId)
  657. }
  658. isInsert := false
  659. //如果当前文件是README.md,则将内容更新到父级
  660. if strings.EqualFold(info.Name(), "README.md") && parentId != 0 {
  661. doc.DocumentId = parentId
  662. //beego.Info(path,"|",parentId)
  663. } else {
  664. //beego.Info(path,"|",parentIdentify)
  665. doc.ParentId = parentId
  666. isInsert = true
  667. }
  668. if err := doc.InsertOrUpdate("document_name", "markdown", "content"); err != nil {
  669. beego.Error(doc.DocumentId, err)
  670. }
  671. if isInsert {
  672. docMap[docIdentify] = doc.DocumentId
  673. }
  674. }
  675. } else {
  676. //如果当前目录下存在Markdown文件,则需要创建此节点
  677. if filetil.HasFileOfExt(path, []string{".md", ".markdown"}) {
  678. beego.Info("正在处理 =>",path,info.Name())
  679. identify := strings.Replace(strings.Trim(strings.TrimPrefix(path, tempPath), "/"), "/", "-", -1)
  680. if ok, err := regexp.MatchString(`[a-z]+[a-zA-Z0-9_.\-]*$`, identify); !ok || err != nil {
  681. identify = "import-" + identify
  682. }
  683. parentDoc := NewDocument()
  684. parentDoc.MemberId = book.MemberId
  685. parentDoc.BookId = book.BookId
  686. parentDoc.Identify = identify
  687. parentDoc.Version = time.Now().Unix()
  688. parentDoc.DocumentName = "空白文档"
  689. parentId := 0
  690. parentIdentify := strings.TrimSuffix(identify, "-"+info.Name())
  691. if id, ok := docMap[parentIdentify]; ok {
  692. parentId = id
  693. }
  694. parentDoc.ParentId = parentId
  695. if err := parentDoc.InsertOrUpdate(); err != nil {
  696. beego.Error(err)
  697. }
  698. docMap[identify] = parentDoc.DocumentId
  699. //beego.Info(path,"|",parentDoc.DocumentId,"|",identify,"|",info.Name(),"|",parentIdentify)
  700. }
  701. }
  702. return nil
  703. })
  704. if err != nil {
  705. beego.Error("导入项目异常 => ", err)
  706. book.Description = "【项目导入存在错误:" + err.Error() + "】"
  707. }
  708. beego.Info("项目导入完毕 => ",book.BookName)
  709. book.ReleaseContent(book.BookId)
  710. return err
  711. }