issue.go 42 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625
  1. // Copyright 2014 The Gogs Authors. All rights reserved.
  2. // Use of this source code is governed by a MIT-style
  3. // license that can be found in the LICENSE file.
  4. package models
  5. import (
  6. "bytes"
  7. "errors"
  8. "fmt"
  9. "io"
  10. "mime/multipart"
  11. "os"
  12. "path"
  13. "strconv"
  14. "strings"
  15. "time"
  16. "github.com/Unknwon/com"
  17. "github.com/go-xorm/xorm"
  18. "github.com/gogits/gogs/modules/base"
  19. "github.com/gogits/gogs/modules/log"
  20. "github.com/gogits/gogs/modules/setting"
  21. gouuid "github.com/gogits/gogs/modules/uuid"
  22. )
  23. var (
  24. ErrWrongIssueCounter = errors.New("Invalid number of issues for this milestone")
  25. ErrAttachmentNotLinked = errors.New("Attachment does not belong to this issue")
  26. ErrMissingIssueNumber = errors.New("No issue number specified")
  27. )
  28. // Issue represents an issue or pull request of repository.
  29. type Issue struct {
  30. ID int64 `xorm:"pk autoincr"`
  31. RepoID int64 `xorm:"INDEX"`
  32. Index int64 // Index in one repository.
  33. Name string
  34. Repo *Repository `xorm:"-"`
  35. PosterID int64
  36. Poster *User `xorm:"-"`
  37. Labels []*Label `xorm:"-"`
  38. MilestoneID int64
  39. Milestone *Milestone `xorm:"-"`
  40. AssigneeID int64
  41. Assignee *User `xorm:"-"`
  42. IsRead bool `xorm:"-"`
  43. IsPull bool // Indicates whether is a pull request or not.
  44. IsClosed bool
  45. Content string `xorm:"TEXT"`
  46. RenderedContent string `xorm:"-"`
  47. Priority int
  48. NumComments int
  49. Deadline time.Time
  50. Created time.Time `xorm:"CREATED"`
  51. Updated time.Time `xorm:"UPDATED"`
  52. Attachments []*Attachment `xorm:"-"`
  53. Comments []*Comment `xorm:"-"`
  54. }
  55. // HashTag returns unique hash tag for issue.
  56. func (i *Issue) HashTag() string {
  57. return "issue-" + com.ToStr(i.ID)
  58. }
  59. func (i *Issue) AfterSet(colName string, _ xorm.Cell) {
  60. var err error
  61. switch colName {
  62. case "id":
  63. i.Attachments, err = GetAttachmentsByIssueID(i.ID)
  64. if err != nil {
  65. log.Error(3, "GetAttachmentsByIssueID[%d]: %v", i.ID, err)
  66. }
  67. i.Comments, err = GetCommentsByIssueID(i.ID)
  68. if err != nil {
  69. log.Error(3, "GetCommentsByIssueID[%d]: %v", i.ID, err)
  70. }
  71. case "milestone_id":
  72. if i.MilestoneID == 0 {
  73. return
  74. }
  75. i.Milestone, err = GetMilestoneByID(i.MilestoneID)
  76. if err != nil {
  77. log.Error(3, "GetMilestoneById[%d]: %v", i.ID, err)
  78. }
  79. case "assignee_id":
  80. if i.AssigneeID == 0 {
  81. return
  82. }
  83. i.Assignee, err = GetUserByID(i.AssigneeID)
  84. if err != nil {
  85. log.Error(3, "GetUserByID[%d]: %v", i.ID, err)
  86. }
  87. }
  88. }
  89. // IsPoster returns true if given user by ID is the poster.
  90. func (i *Issue) IsPoster(uid int64) bool {
  91. return i.PosterID == uid
  92. }
  93. func (i *Issue) GetPoster() (err error) {
  94. i.Poster, err = GetUserByID(i.PosterID)
  95. if IsErrUserNotExist(err) {
  96. i.PosterID = -1
  97. i.Poster = NewFakeUser()
  98. return nil
  99. }
  100. return err
  101. }
  102. func (i *Issue) hasLabel(e Engine, labelID int64) bool {
  103. return hasIssueLabel(e, i.ID, labelID)
  104. }
  105. // HasLabel returns true if issue has been labeled by given ID.
  106. func (i *Issue) HasLabel(labelID int64) bool {
  107. return i.hasLabel(x, labelID)
  108. }
  109. func (i *Issue) addLabel(e *xorm.Session, label *Label) error {
  110. return newIssueLabel(e, i, label)
  111. }
  112. // AddLabel adds new label to issue by given ID.
  113. func (i *Issue) AddLabel(label *Label) (err error) {
  114. sess := x.NewSession()
  115. defer sessionRelease(sess)
  116. if err = sess.Begin(); err != nil {
  117. return err
  118. }
  119. if err = i.addLabel(sess, label); err != nil {
  120. return err
  121. }
  122. return sess.Commit()
  123. }
  124. func (i *Issue) getLabels(e Engine) (err error) {
  125. if len(i.Labels) > 0 {
  126. return nil
  127. }
  128. i.Labels, err = getLabelsByIssueID(e, i.ID)
  129. if err != nil {
  130. return fmt.Errorf("getLabelsByIssueID: %v", err)
  131. }
  132. return nil
  133. }
  134. // GetLabels retrieves all labels of issue and assign to corresponding field.
  135. func (i *Issue) GetLabels() error {
  136. return i.getLabels(x)
  137. }
  138. func (i *Issue) removeLabel(e *xorm.Session, label *Label) error {
  139. return deleteIssueLabel(e, i, label)
  140. }
  141. // RemoveLabel removes a label from issue by given ID.
  142. func (i *Issue) RemoveLabel(label *Label) (err error) {
  143. sess := x.NewSession()
  144. defer sessionRelease(sess)
  145. if err = sess.Begin(); err != nil {
  146. return err
  147. }
  148. if err = i.removeLabel(sess, label); err != nil {
  149. return err
  150. }
  151. return sess.Commit()
  152. }
  153. func (i *Issue) ClearLabels() (err error) {
  154. sess := x.NewSession()
  155. defer sessionRelease(sess)
  156. if err = sess.Begin(); err != nil {
  157. return err
  158. }
  159. if err = i.getLabels(sess); err != nil {
  160. return err
  161. }
  162. for idx := range i.Labels {
  163. if err = i.removeLabel(sess, i.Labels[idx]); err != nil {
  164. return err
  165. }
  166. }
  167. return sess.Commit()
  168. }
  169. func (i *Issue) GetAssignee() (err error) {
  170. if i.AssigneeID == 0 || i.Assignee != nil {
  171. return nil
  172. }
  173. i.Assignee, err = GetUserByID(i.AssigneeID)
  174. if IsErrUserNotExist(err) {
  175. return nil
  176. }
  177. return err
  178. }
  179. // ReadBy sets issue to be read by given user.
  180. func (i *Issue) ReadBy(uid int64) error {
  181. return UpdateIssueUserByRead(uid, i.ID)
  182. }
  183. func (i *Issue) changeStatus(e *xorm.Session, doer *User, isClosed bool) (err error) {
  184. if i.IsClosed == isClosed {
  185. return nil
  186. }
  187. i.IsClosed = isClosed
  188. if err = updateIssue(e, i); err != nil {
  189. return err
  190. } else if err = updateIssueUsersByStatus(e, i.ID, isClosed); err != nil {
  191. return err
  192. }
  193. // Update labels.
  194. if err = i.getLabels(e); err != nil {
  195. return err
  196. }
  197. for idx := range i.Labels {
  198. if i.IsClosed {
  199. i.Labels[idx].NumClosedIssues++
  200. } else {
  201. i.Labels[idx].NumClosedIssues--
  202. }
  203. if err = updateLabel(e, i.Labels[idx]); err != nil {
  204. return err
  205. }
  206. }
  207. // Update milestone.
  208. if err = changeMilestoneIssueStats(e, i); err != nil {
  209. return err
  210. }
  211. // New action comment.
  212. if _, err = createStatusComment(e, doer, i.Repo, i); err != nil {
  213. return err
  214. }
  215. return nil
  216. }
  217. // ChangeStatus changes issue status to open/closed.
  218. func (i *Issue) ChangeStatus(doer *User, isClosed bool) (err error) {
  219. sess := x.NewSession()
  220. defer sessionRelease(sess)
  221. if err = sess.Begin(); err != nil {
  222. return err
  223. }
  224. if err = i.changeStatus(sess, doer, isClosed); err != nil {
  225. return err
  226. }
  227. return sess.Commit()
  228. }
  229. // CreateIssue creates new issue with labels for repository.
  230. func NewIssue(repo *Repository, issue *Issue, labelIDs []int64, uuids []string) (err error) {
  231. // Check attachments.
  232. attachments := make([]*Attachment, 0, len(uuids))
  233. for _, uuid := range uuids {
  234. attach, err := GetAttachmentByUUID(uuid)
  235. if err != nil {
  236. if IsErrAttachmentNotExist(err) {
  237. continue
  238. }
  239. return fmt.Errorf("GetAttachmentByUUID[%s]: %v", uuid, err)
  240. }
  241. attachments = append(attachments, attach)
  242. }
  243. sess := x.NewSession()
  244. defer sessionRelease(sess)
  245. if err = sess.Begin(); err != nil {
  246. return err
  247. }
  248. if _, err = sess.Insert(issue); err != nil {
  249. return err
  250. } else if _, err = sess.Exec("UPDATE `repository` SET num_issues=num_issues+1 WHERE id=?", issue.RepoID); err != nil {
  251. return err
  252. }
  253. var label *Label
  254. for _, id := range labelIDs {
  255. if id == 0 {
  256. continue
  257. }
  258. label, err = getLabelByID(sess, id)
  259. if err != nil {
  260. return err
  261. }
  262. if err = issue.addLabel(sess, label); err != nil {
  263. return fmt.Errorf("addLabel: %v", err)
  264. }
  265. }
  266. if issue.MilestoneID > 0 {
  267. if err = changeMilestoneAssign(sess, 0, issue); err != nil {
  268. return err
  269. }
  270. }
  271. if err = newIssueUsers(sess, repo, issue); err != nil {
  272. return err
  273. }
  274. for i := range attachments {
  275. attachments[i].IssueID = issue.ID
  276. // No assign value could be 0, so ignore AllCols().
  277. if _, err = sess.Id(attachments[i].ID).Update(attachments[i]); err != nil {
  278. return fmt.Errorf("update attachment[%d]: %v", attachments[i].ID, err)
  279. }
  280. }
  281. // Notify watchers.
  282. act := &Action{
  283. ActUserID: issue.Poster.Id,
  284. ActUserName: issue.Poster.Name,
  285. ActEmail: issue.Poster.Email,
  286. OpType: CREATE_ISSUE,
  287. Content: fmt.Sprintf("%d|%s", issue.Index, issue.Name),
  288. RepoID: repo.ID,
  289. RepoUserName: repo.Owner.Name,
  290. RepoName: repo.Name,
  291. IsPrivate: repo.IsPrivate,
  292. }
  293. if err = notifyWatchers(sess, act); err != nil {
  294. return err
  295. }
  296. return sess.Commit()
  297. }
  298. // GetIssueByRef returns an Issue specified by a GFM reference.
  299. // See https://help.github.com/articles/writing-on-github#references for more information on the syntax.
  300. func GetIssueByRef(ref string) (issue *Issue, err error) {
  301. var issueNumber int64
  302. var repo *Repository
  303. n := strings.IndexByte(ref, byte('#'))
  304. if n == -1 {
  305. return nil, ErrMissingIssueNumber
  306. }
  307. if issueNumber, err = strconv.ParseInt(ref[n+1:], 10, 64); err != nil {
  308. return
  309. }
  310. if repo, err = GetRepositoryByRef(ref[:n]); err != nil {
  311. return
  312. }
  313. return GetIssueByIndex(repo.ID, issueNumber)
  314. }
  315. // GetIssueByIndex returns issue by given index in repository.
  316. func GetIssueByIndex(repoID, index int64) (*Issue, error) {
  317. issue := &Issue{
  318. RepoID: repoID,
  319. Index: index,
  320. }
  321. has, err := x.Get(issue)
  322. if err != nil {
  323. return nil, err
  324. } else if !has {
  325. return nil, ErrIssueNotExist{0, repoID, index}
  326. }
  327. return issue, nil
  328. }
  329. // GetIssueByID returns an issue by given ID.
  330. func GetIssueByID(id int64) (*Issue, error) {
  331. issue := new(Issue)
  332. has, err := x.Id(id).Get(issue)
  333. if err != nil {
  334. return nil, err
  335. } else if !has {
  336. return nil, ErrIssueNotExist{id, 0, 0}
  337. }
  338. return issue, nil
  339. }
  340. // Issues returns a list of issues by given conditions.
  341. func Issues(uid, assigneeID, repoID, posterID, milestoneID int64, page int, isClosed, isMention bool, labels, sortType string) ([]*Issue, error) {
  342. sess := x.Limit(setting.IssuePagingNum, (page-1)*setting.IssuePagingNum)
  343. if repoID > 0 {
  344. sess.Where("issue.repo_id=?", repoID).And("issue.is_closed=?", isClosed)
  345. } else {
  346. sess.Where("issue.is_closed=?", isClosed)
  347. }
  348. if assigneeID > 0 {
  349. sess.And("issue.assignee_id=?", assigneeID)
  350. } else if posterID > 0 {
  351. sess.And("issue.poster_id=?", posterID)
  352. }
  353. if milestoneID > 0 {
  354. sess.And("issue.milestone_id=?", milestoneID)
  355. }
  356. switch sortType {
  357. case "oldest":
  358. sess.Asc("created")
  359. case "recentupdate":
  360. sess.Desc("updated")
  361. case "leastupdate":
  362. sess.Asc("updated")
  363. case "mostcomment":
  364. sess.Desc("num_comments")
  365. case "leastcomment":
  366. sess.Asc("num_comments")
  367. case "priority":
  368. sess.Desc("priority")
  369. default:
  370. sess.Desc("created")
  371. }
  372. labelIDs := base.StringsToInt64s(strings.Split(labels, ","))
  373. if len(labelIDs) > 0 {
  374. validJoin := false
  375. queryStr := "issue.id=issue_label.issue_id"
  376. for _, id := range labelIDs {
  377. if id == 0 {
  378. continue
  379. }
  380. validJoin = true
  381. queryStr += " AND issue_label.label_id=" + com.ToStr(id)
  382. }
  383. if validJoin {
  384. sess.Join("INNER", "issue_label", queryStr)
  385. }
  386. }
  387. if isMention {
  388. queryStr := "issue.id=issue_user.issue_id AND issue_user.is_mentioned=1"
  389. if uid > 0 {
  390. queryStr += " AND issue_user.uid=" + com.ToStr(uid)
  391. }
  392. sess.Join("INNER", "issue_user", queryStr)
  393. }
  394. issues := make([]*Issue, 0, setting.IssuePagingNum)
  395. return issues, sess.Find(&issues)
  396. }
  397. type IssueStatus int
  398. const (
  399. IS_OPEN = iota + 1
  400. IS_CLOSE
  401. )
  402. // GetIssueCountByPoster returns number of issues of repository by poster.
  403. func GetIssueCountByPoster(uid, rid int64, isClosed bool) int64 {
  404. count, _ := x.Where("repo_id=?", rid).And("poster_id=?", uid).And("is_closed=?", isClosed).Count(new(Issue))
  405. return count
  406. }
  407. // .___ ____ ___
  408. // | | ______ ________ __ ____ | | \______ ___________
  409. // | |/ ___// ___/ | \_/ __ \| | / ___// __ \_ __ \
  410. // | |\___ \ \___ \| | /\ ___/| | /\___ \\ ___/| | \/
  411. // |___/____ >____ >____/ \___ >______//____ >\___ >__|
  412. // \/ \/ \/ \/ \/
  413. // IssueUser represents an issue-user relation.
  414. type IssueUser struct {
  415. ID int64 `xorm:"pk autoincr"`
  416. UID int64 `xorm:"uid INDEX"` // User ID.
  417. IssueID int64
  418. RepoID int64 `xorm:"INDEX"`
  419. MilestoneID int64
  420. IsRead bool
  421. IsAssigned bool
  422. IsMentioned bool
  423. IsPoster bool
  424. IsClosed bool
  425. }
  426. func newIssueUsers(e *xorm.Session, repo *Repository, issue *Issue) error {
  427. users, err := repo.GetAssignees()
  428. if err != nil {
  429. return err
  430. }
  431. iu := &IssueUser{
  432. IssueID: issue.ID,
  433. RepoID: repo.ID,
  434. }
  435. // Poster can be anyone.
  436. isNeedAddPoster := true
  437. for _, u := range users {
  438. iu.ID = 0
  439. iu.UID = u.Id
  440. iu.IsPoster = iu.UID == issue.PosterID
  441. if isNeedAddPoster && iu.IsPoster {
  442. isNeedAddPoster = false
  443. }
  444. iu.IsAssigned = iu.UID == issue.AssigneeID
  445. if _, err = e.Insert(iu); err != nil {
  446. return err
  447. }
  448. }
  449. if isNeedAddPoster {
  450. iu.ID = 0
  451. iu.UID = issue.PosterID
  452. iu.IsPoster = true
  453. if _, err = e.Insert(iu); err != nil {
  454. return err
  455. }
  456. }
  457. return nil
  458. }
  459. // NewIssueUsers adds new issue-user relations for new issue of repository.
  460. func NewIssueUsers(repo *Repository, issue *Issue) (err error) {
  461. sess := x.NewSession()
  462. defer sessionRelease(sess)
  463. if err = sess.Begin(); err != nil {
  464. return err
  465. }
  466. if err = newIssueUsers(sess, repo, issue); err != nil {
  467. return err
  468. }
  469. return sess.Commit()
  470. }
  471. // PairsContains returns true when pairs list contains given issue.
  472. func PairsContains(ius []*IssueUser, issueId, uid int64) int {
  473. for i := range ius {
  474. if ius[i].IssueID == issueId &&
  475. ius[i].UID == uid {
  476. return i
  477. }
  478. }
  479. return -1
  480. }
  481. // GetIssueUsers returns issue-user pairs by given repository and user.
  482. func GetIssueUsers(rid, uid int64, isClosed bool) ([]*IssueUser, error) {
  483. ius := make([]*IssueUser, 0, 10)
  484. err := x.Where("is_closed=?", isClosed).Find(&ius, &IssueUser{RepoID: rid, UID: uid})
  485. return ius, err
  486. }
  487. // GetIssueUserPairsByRepoIds returns issue-user pairs by given repository IDs.
  488. func GetIssueUserPairsByRepoIds(rids []int64, isClosed bool, page int) ([]*IssueUser, error) {
  489. if len(rids) == 0 {
  490. return []*IssueUser{}, nil
  491. }
  492. buf := bytes.NewBufferString("")
  493. for _, rid := range rids {
  494. buf.WriteString("repo_id=")
  495. buf.WriteString(com.ToStr(rid))
  496. buf.WriteString(" OR ")
  497. }
  498. cond := strings.TrimSuffix(buf.String(), " OR ")
  499. ius := make([]*IssueUser, 0, 10)
  500. sess := x.Limit(20, (page-1)*20).Where("is_closed=?", isClosed)
  501. if len(cond) > 0 {
  502. sess.And(cond)
  503. }
  504. err := sess.Find(&ius)
  505. return ius, err
  506. }
  507. // GetIssueUserPairsByMode returns issue-user pairs by given repository and user.
  508. func GetIssueUserPairsByMode(uid, rid int64, isClosed bool, page, filterMode int) ([]*IssueUser, error) {
  509. ius := make([]*IssueUser, 0, 10)
  510. sess := x.Limit(20, (page-1)*20).Where("uid=?", uid).And("is_closed=?", isClosed)
  511. if rid > 0 {
  512. sess.And("repo_id=?", rid)
  513. }
  514. switch filterMode {
  515. case FM_ASSIGN:
  516. sess.And("is_assigned=?", true)
  517. case FM_CREATE:
  518. sess.And("is_poster=?", true)
  519. default:
  520. return ius, nil
  521. }
  522. err := sess.Find(&ius)
  523. return ius, err
  524. }
  525. // IssueStats represents issue statistic information.
  526. type IssueStats struct {
  527. OpenCount, ClosedCount int64
  528. AllCount int64
  529. AssignCount int64
  530. CreateCount int64
  531. MentionCount int64
  532. }
  533. // Filter modes.
  534. const (
  535. FM_ALL = iota
  536. FM_ASSIGN
  537. FM_CREATE
  538. FM_MENTION
  539. )
  540. func parseCountResult(results []map[string][]byte) int64 {
  541. if len(results) == 0 {
  542. return 0
  543. }
  544. for _, result := range results[0] {
  545. return com.StrTo(string(result)).MustInt64()
  546. }
  547. return 0
  548. }
  549. // GetIssueStats returns issue statistic information by given conditions.
  550. func GetIssueStats(repoID, uid, labelID, milestoneID int64, isShowClosed bool, filterMode int) *IssueStats {
  551. stats := &IssueStats{}
  552. // issue := new(Issue)
  553. queryStr := "SELECT COUNT(*) FROM `issue` "
  554. if labelID > 0 {
  555. queryStr += "INNER JOIN `issue_label` ON `issue`.id=`issue_label`.issue_id AND `issue_label`.label_id=" + com.ToStr(labelID)
  556. }
  557. baseCond := " WHERE issue.repo_id=? AND issue.is_closed=?"
  558. if milestoneID > 0 {
  559. baseCond += " AND issue.milestone_id=" + com.ToStr(milestoneID)
  560. }
  561. switch filterMode {
  562. case FM_ALL:
  563. resutls, _ := x.Query(queryStr+baseCond, repoID, false)
  564. stats.OpenCount = parseCountResult(resutls)
  565. resutls, _ = x.Query(queryStr+baseCond, repoID, true)
  566. stats.ClosedCount = parseCountResult(resutls)
  567. case FM_ASSIGN:
  568. baseCond += " AND assignee_id=?"
  569. resutls, _ := x.Query(queryStr+baseCond, repoID, false, uid)
  570. stats.OpenCount = parseCountResult(resutls)
  571. resutls, _ = x.Query(queryStr+baseCond, repoID, true, uid)
  572. stats.ClosedCount = parseCountResult(resutls)
  573. case FM_CREATE:
  574. baseCond += " AND poster_id=?"
  575. resutls, _ := x.Query(queryStr+baseCond, repoID, false, uid)
  576. stats.OpenCount = parseCountResult(resutls)
  577. resutls, _ = x.Query(queryStr+baseCond, repoID, true, uid)
  578. stats.ClosedCount = parseCountResult(resutls)
  579. case FM_MENTION:
  580. queryStr += " INNER JOIN `issue_user` ON `issue`.id=`issue_user`.issue_id"
  581. baseCond += " AND `issue_user`.uid=? AND `issue_user`.is_mentioned=?"
  582. resutls, _ := x.Query(queryStr+baseCond, repoID, false, uid, true)
  583. stats.OpenCount = parseCountResult(resutls)
  584. resutls, _ = x.Query(queryStr+baseCond, repoID, true, uid, true)
  585. stats.ClosedCount = parseCountResult(resutls)
  586. }
  587. return stats
  588. }
  589. // GetUserIssueStats returns issue statistic information for dashboard by given conditions.
  590. func GetUserIssueStats(uid int64, filterMode int) *IssueStats {
  591. stats := &IssueStats{}
  592. issue := new(Issue)
  593. stats.AssignCount, _ = x.Where("assignee_id=?", uid).And("is_closed=?", false).Count(issue)
  594. stats.CreateCount, _ = x.Where("poster_id=?", uid).And("is_closed=?", false).Count(issue)
  595. return stats
  596. }
  597. func updateIssue(e Engine, issue *Issue) error {
  598. _, err := e.Id(issue.ID).AllCols().Update(issue)
  599. return err
  600. }
  601. // UpdateIssue updates information of issue.
  602. func UpdateIssue(issue *Issue) error {
  603. return updateIssue(x, issue)
  604. }
  605. func updateIssueUsersByStatus(e Engine, issueID int64, isClosed bool) error {
  606. _, err := e.Exec("UPDATE `issue_user` SET is_closed=? WHERE issue_id=?", isClosed, issueID)
  607. return err
  608. }
  609. // UpdateIssueUsersByStatus updates issue-user relations by issue status.
  610. func UpdateIssueUsersByStatus(issueID int64, isClosed bool) error {
  611. return updateIssueUsersByStatus(x, issueID, isClosed)
  612. }
  613. func updateIssueUserByAssignee(e *xorm.Session, issue *Issue) (err error) {
  614. if _, err = e.Exec("UPDATE `issue_user` SET is_assigned=? WHERE issue_id=?", false, issue.ID); err != nil {
  615. return err
  616. }
  617. // Assignee ID equals to 0 means clear assignee.
  618. if issue.AssigneeID > 0 {
  619. if _, err = e.Exec("UPDATE `issue_user` SET is_assigned=? WHERE uid=? AND issue_id=?", true, issue.AssigneeID, issue.ID); err != nil {
  620. return err
  621. }
  622. }
  623. return updateIssue(e, issue)
  624. }
  625. // UpdateIssueUserByAssignee updates issue-user relation for assignee.
  626. func UpdateIssueUserByAssignee(issue *Issue) (err error) {
  627. sess := x.NewSession()
  628. defer sessionRelease(sess)
  629. if err = sess.Begin(); err != nil {
  630. return err
  631. }
  632. if err = updateIssueUserByAssignee(sess, issue); err != nil {
  633. return err
  634. }
  635. return sess.Commit()
  636. }
  637. // UpdateIssueUserByRead updates issue-user relation for reading.
  638. func UpdateIssueUserByRead(uid, issueID int64) error {
  639. _, err := x.Exec("UPDATE `issue_user` SET is_read=? WHERE uid=? AND issue_id=?", true, uid, issueID)
  640. return err
  641. }
  642. // UpdateIssueUsersByMentions updates issue-user pairs by mentioning.
  643. func UpdateIssueUsersByMentions(uids []int64, iid int64) error {
  644. for _, uid := range uids {
  645. iu := &IssueUser{UID: uid, IssueID: iid}
  646. has, err := x.Get(iu)
  647. if err != nil {
  648. return err
  649. }
  650. iu.IsMentioned = true
  651. if has {
  652. _, err = x.Id(iu.ID).AllCols().Update(iu)
  653. } else {
  654. _, err = x.Insert(iu)
  655. }
  656. if err != nil {
  657. return err
  658. }
  659. }
  660. return nil
  661. }
  662. // .____ ___. .__
  663. // | | _____ \_ |__ ____ | |
  664. // | | \__ \ | __ \_/ __ \| |
  665. // | |___ / __ \| \_\ \ ___/| |__
  666. // |_______ (____ /___ /\___ >____/
  667. // \/ \/ \/ \/
  668. // Label represents a label of repository for issues.
  669. type Label struct {
  670. ID int64 `xorm:"pk autoincr"`
  671. RepoID int64 `xorm:"INDEX"`
  672. Name string
  673. Color string `xorm:"VARCHAR(7)"`
  674. NumIssues int
  675. NumClosedIssues int
  676. NumOpenIssues int `xorm:"-"`
  677. IsChecked bool `xorm:"-"`
  678. }
  679. // CalOpenIssues calculates the open issues of label.
  680. func (m *Label) CalOpenIssues() {
  681. m.NumOpenIssues = m.NumIssues - m.NumClosedIssues
  682. }
  683. // NewLabel creates new label of repository.
  684. func NewLabel(l *Label) error {
  685. _, err := x.Insert(l)
  686. return err
  687. }
  688. func getLabelByID(e Engine, id int64) (*Label, error) {
  689. if id <= 0 {
  690. return nil, ErrLabelNotExist{id}
  691. }
  692. l := &Label{ID: id}
  693. has, err := x.Get(l)
  694. if err != nil {
  695. return nil, err
  696. } else if !has {
  697. return nil, ErrLabelNotExist{l.ID}
  698. }
  699. return l, nil
  700. }
  701. // GetLabelByID returns a label by given ID.
  702. func GetLabelByID(id int64) (*Label, error) {
  703. return getLabelByID(x, id)
  704. }
  705. // GetLabelsByRepoID returns all labels that belong to given repository by ID.
  706. func GetLabelsByRepoID(repoID int64) ([]*Label, error) {
  707. labels := make([]*Label, 0, 10)
  708. return labels, x.Where("repo_id=?", repoID).Find(&labels)
  709. }
  710. func getLabelsByIssueID(e Engine, issueID int64) ([]*Label, error) {
  711. issueLabels, err := getIssueLabels(e, issueID)
  712. if err != nil {
  713. return nil, fmt.Errorf("getIssueLabels: %v", err)
  714. }
  715. var label *Label
  716. labels := make([]*Label, 0, len(issueLabels))
  717. for idx := range issueLabels {
  718. label, err = getLabelByID(e, issueLabels[idx].LabelID)
  719. if err != nil && !IsErrLabelNotExist(err) {
  720. return nil, fmt.Errorf("getLabelByID: %v", err)
  721. }
  722. labels = append(labels, label)
  723. }
  724. return labels, nil
  725. }
  726. // GetLabelsByIssueID returns all labels that belong to given issue by ID.
  727. func GetLabelsByIssueID(issueID int64) ([]*Label, error) {
  728. return getLabelsByIssueID(x, issueID)
  729. }
  730. func updateLabel(e Engine, l *Label) error {
  731. _, err := e.Id(l.ID).AllCols().Update(l)
  732. return err
  733. }
  734. // UpdateLabel updates label information.
  735. func UpdateLabel(l *Label) error {
  736. return updateLabel(x, l)
  737. }
  738. // DeleteLabel delete a label of given repository.
  739. func DeleteLabel(repoID, labelID int64) error {
  740. l, err := GetLabelByID(labelID)
  741. if err != nil {
  742. if IsErrLabelNotExist(err) {
  743. return nil
  744. }
  745. return err
  746. }
  747. sess := x.NewSession()
  748. defer sessionRelease(sess)
  749. if err = sess.Begin(); err != nil {
  750. return err
  751. }
  752. if _, err = x.Where("label_id=?", labelID).Delete(new(IssueLabel)); err != nil {
  753. return err
  754. } else if _, err = sess.Delete(l); err != nil {
  755. return err
  756. }
  757. return sess.Commit()
  758. }
  759. // .___ .____ ___. .__
  760. // | | ______ ________ __ ____ | | _____ \_ |__ ____ | |
  761. // | |/ ___// ___/ | \_/ __ \| | \__ \ | __ \_/ __ \| |
  762. // | |\___ \ \___ \| | /\ ___/| |___ / __ \| \_\ \ ___/| |__
  763. // |___/____ >____ >____/ \___ >_______ (____ /___ /\___ >____/
  764. // \/ \/ \/ \/ \/ \/ \/
  765. // IssueLabel represetns an issue-lable relation.
  766. type IssueLabel struct {
  767. ID int64 `xorm:"pk autoincr"`
  768. IssueID int64 `xorm:"UNIQUE(s)"`
  769. LabelID int64 `xorm:"UNIQUE(s)"`
  770. }
  771. func hasIssueLabel(e Engine, issueID, labelID int64) bool {
  772. has, _ := e.Where("issue_id=? AND label_id=?", issueID, labelID).Get(new(IssueLabel))
  773. return has
  774. }
  775. // HasIssueLabel returns true if issue has been labeled.
  776. func HasIssueLabel(issueID, labelID int64) bool {
  777. return hasIssueLabel(x, issueID, labelID)
  778. }
  779. func newIssueLabel(e *xorm.Session, issue *Issue, label *Label) (err error) {
  780. if _, err = e.Insert(&IssueLabel{
  781. IssueID: issue.ID,
  782. LabelID: label.ID,
  783. }); err != nil {
  784. return err
  785. }
  786. label.NumIssues++
  787. if issue.IsClosed {
  788. label.NumClosedIssues++
  789. }
  790. return updateLabel(e, label)
  791. }
  792. // NewIssueLabel creates a new issue-label relation.
  793. func NewIssueLabel(issue *Issue, label *Label) (err error) {
  794. sess := x.NewSession()
  795. defer sessionRelease(sess)
  796. if err = sess.Begin(); err != nil {
  797. return err
  798. }
  799. if err = newIssueLabel(sess, issue, label); err != nil {
  800. return err
  801. }
  802. return sess.Commit()
  803. }
  804. func getIssueLabels(e Engine, issueID int64) ([]*IssueLabel, error) {
  805. issueLabels := make([]*IssueLabel, 0, 10)
  806. return issueLabels, e.Where("issue_id=?", issueID).Asc("label_id").Find(&issueLabels)
  807. }
  808. // GetIssueLabels returns all issue-label relations of given issue by ID.
  809. func GetIssueLabels(issueID int64) ([]*IssueLabel, error) {
  810. return getIssueLabels(x, issueID)
  811. }
  812. func deleteIssueLabel(e *xorm.Session, issue *Issue, label *Label) (err error) {
  813. if _, err = e.Delete(&IssueLabel{
  814. IssueID: issue.ID,
  815. LabelID: label.ID,
  816. }); err != nil {
  817. return err
  818. }
  819. label.NumIssues--
  820. if issue.IsClosed {
  821. label.NumClosedIssues--
  822. }
  823. return updateLabel(e, label)
  824. }
  825. // DeleteIssueLabel deletes issue-label relation.
  826. func DeleteIssueLabel(issue *Issue, label *Label) (err error) {
  827. sess := x.NewSession()
  828. defer sessionRelease(sess)
  829. if err = sess.Begin(); err != nil {
  830. return err
  831. }
  832. if err = deleteIssueLabel(sess, issue, label); err != nil {
  833. return err
  834. }
  835. return sess.Commit()
  836. }
  837. // _____ .__.__ __
  838. // / \ |__| | ____ _______/ |_ ____ ____ ____
  839. // / \ / \| | | _/ __ \ / ___/\ __\/ _ \ / \_/ __ \
  840. // / Y \ | |_\ ___/ \___ \ | | ( <_> ) | \ ___/
  841. // \____|__ /__|____/\___ >____ > |__| \____/|___| /\___ >
  842. // \/ \/ \/ \/ \/
  843. // Milestone represents a milestone of repository.
  844. type Milestone struct {
  845. ID int64 `xorm:"pk autoincr"`
  846. RepoID int64 `xorm:"INDEX"`
  847. Name string
  848. Content string `xorm:"TEXT"`
  849. RenderedContent string `xorm:"-"`
  850. IsClosed bool
  851. NumIssues int
  852. NumClosedIssues int
  853. NumOpenIssues int `xorm:"-"`
  854. Completeness int // Percentage(1-100).
  855. Deadline time.Time
  856. DeadlineString string `xorm:"-"`
  857. IsOverDue bool `xorm:"-"`
  858. ClosedDate time.Time
  859. }
  860. func (m *Milestone) BeforeUpdate() {
  861. if m.NumIssues > 0 {
  862. m.Completeness = m.NumClosedIssues * 100 / m.NumIssues
  863. } else {
  864. m.Completeness = 0
  865. }
  866. }
  867. func (m *Milestone) AfterSet(colName string, _ xorm.Cell) {
  868. if colName == "deadline" {
  869. if m.Deadline.Year() == 9999 {
  870. return
  871. }
  872. m.DeadlineString = m.Deadline.Format("2006-01-02")
  873. if time.Now().After(m.Deadline) {
  874. m.IsOverDue = true
  875. }
  876. }
  877. }
  878. // CalOpenIssues calculates the open issues of milestone.
  879. func (m *Milestone) CalOpenIssues() {
  880. m.NumOpenIssues = m.NumIssues - m.NumClosedIssues
  881. }
  882. // NewMilestone creates new milestone of repository.
  883. func NewMilestone(m *Milestone) (err error) {
  884. sess := x.NewSession()
  885. defer sessionRelease(sess)
  886. if err = sess.Begin(); err != nil {
  887. return err
  888. }
  889. if _, err = sess.Insert(m); err != nil {
  890. return err
  891. }
  892. if _, err = sess.Exec("UPDATE `repository` SET num_milestones=num_milestones+1 WHERE id=?", m.RepoID); err != nil {
  893. return err
  894. }
  895. return sess.Commit()
  896. }
  897. func getMilestoneByID(e Engine, id int64) (*Milestone, error) {
  898. m := &Milestone{ID: id}
  899. has, err := e.Get(m)
  900. if err != nil {
  901. return nil, err
  902. } else if !has {
  903. return nil, ErrMilestoneNotExist{id, 0}
  904. }
  905. return m, nil
  906. }
  907. // GetMilestoneByID returns the milestone of given ID.
  908. func GetMilestoneByID(id int64) (*Milestone, error) {
  909. return getMilestoneByID(x, id)
  910. }
  911. // GetRepoMilestoneByID returns the milestone of given ID and repository.
  912. func GetRepoMilestoneByID(repoID, milestoneID int64) (*Milestone, error) {
  913. m := &Milestone{ID: milestoneID, RepoID: repoID}
  914. has, err := x.Get(m)
  915. if err != nil {
  916. return nil, err
  917. } else if !has {
  918. return nil, ErrMilestoneNotExist{milestoneID, repoID}
  919. }
  920. return m, nil
  921. }
  922. // GetAllRepoMilestones returns all milestones of given repository.
  923. func GetAllRepoMilestones(repoID int64) ([]*Milestone, error) {
  924. miles := make([]*Milestone, 0, 10)
  925. return miles, x.Where("repo_id=?", repoID).Find(&miles)
  926. }
  927. // GetMilestones returns a list of milestones of given repository and status.
  928. func GetMilestones(repoID int64, page int, isClosed bool) ([]*Milestone, error) {
  929. miles := make([]*Milestone, 0, setting.IssuePagingNum)
  930. sess := x.Where("repo_id=? AND is_closed=?", repoID, isClosed)
  931. if page > 0 {
  932. sess = sess.Limit(setting.IssuePagingNum, (page-1)*setting.IssuePagingNum)
  933. }
  934. return miles, sess.Find(&miles)
  935. }
  936. func updateMilestone(e Engine, m *Milestone) error {
  937. _, err := e.Id(m.ID).AllCols().Update(m)
  938. return err
  939. }
  940. // UpdateMilestone updates information of given milestone.
  941. func UpdateMilestone(m *Milestone) error {
  942. return updateMilestone(x, m)
  943. }
  944. func countRepoMilestones(e Engine, repoID int64) int64 {
  945. count, _ := e.Where("repo_id=?", repoID).Count(new(Milestone))
  946. return count
  947. }
  948. // CountRepoMilestones returns number of milestones in given repository.
  949. func CountRepoMilestones(repoID int64) int64 {
  950. return countRepoMilestones(x, repoID)
  951. }
  952. func countRepoClosedMilestones(e Engine, repoID int64) int64 {
  953. closed, _ := e.Where("repo_id=? AND is_closed=?", repoID, true).Count(new(Milestone))
  954. return closed
  955. }
  956. // CountRepoClosedMilestones returns number of closed milestones in given repository.
  957. func CountRepoClosedMilestones(repoID int64) int64 {
  958. return countRepoClosedMilestones(x, repoID)
  959. }
  960. // MilestoneStats returns number of open and closed milestones of given repository.
  961. func MilestoneStats(repoID int64) (open int64, closed int64) {
  962. open, _ = x.Where("repo_id=? AND is_closed=?", repoID, false).Count(new(Milestone))
  963. return open, CountRepoClosedMilestones(repoID)
  964. }
  965. // ChangeMilestoneStatus changes the milestone open/closed status.
  966. func ChangeMilestoneStatus(m *Milestone, isClosed bool) (err error) {
  967. repo, err := GetRepositoryByID(m.RepoID)
  968. if err != nil {
  969. return err
  970. }
  971. sess := x.NewSession()
  972. defer sessionRelease(sess)
  973. if err = sess.Begin(); err != nil {
  974. return err
  975. }
  976. m.IsClosed = isClosed
  977. if err = updateMilestone(sess, m); err != nil {
  978. return err
  979. }
  980. repo.NumMilestones = int(countRepoMilestones(sess, repo.ID))
  981. repo.NumClosedMilestones = int(countRepoClosedMilestones(sess, repo.ID))
  982. if _, err = sess.Id(repo.ID).AllCols().Update(repo); err != nil {
  983. return err
  984. }
  985. return sess.Commit()
  986. }
  987. func changeMilestoneIssueStats(e *xorm.Session, issue *Issue) error {
  988. if issue.MilestoneID == 0 {
  989. return nil
  990. }
  991. m, err := getMilestoneByID(e, issue.MilestoneID)
  992. if err != nil {
  993. return err
  994. }
  995. if issue.IsClosed {
  996. m.NumOpenIssues--
  997. m.NumClosedIssues++
  998. } else {
  999. m.NumOpenIssues++
  1000. m.NumClosedIssues--
  1001. }
  1002. return updateMilestone(e, m)
  1003. }
  1004. // ChangeMilestoneIssueStats updates the open/closed issues counter and progress
  1005. // for the milestone associated witht the given issue.
  1006. func ChangeMilestoneIssueStats(issue *Issue) (err error) {
  1007. sess := x.NewSession()
  1008. defer sessionRelease(sess)
  1009. if err = sess.Begin(); err != nil {
  1010. return err
  1011. }
  1012. if err = changeMilestoneIssueStats(sess, issue); err != nil {
  1013. return err
  1014. }
  1015. return sess.Commit()
  1016. }
  1017. func changeMilestoneAssign(e *xorm.Session, oldMid int64, issue *Issue) error {
  1018. if oldMid > 0 {
  1019. m, err := getMilestoneByID(e, oldMid)
  1020. if err != nil {
  1021. return err
  1022. }
  1023. m.NumIssues--
  1024. if issue.IsClosed {
  1025. m.NumClosedIssues--
  1026. }
  1027. if err = updateMilestone(e, m); err != nil {
  1028. return err
  1029. } else if _, err = e.Exec("UPDATE `issue_user` SET milestone_id=0 WHERE issue_id=?", issue.ID); err != nil {
  1030. return err
  1031. }
  1032. }
  1033. if issue.MilestoneID > 0 {
  1034. m, err := getMilestoneByID(e, issue.MilestoneID)
  1035. if err != nil {
  1036. return err
  1037. }
  1038. m.NumIssues++
  1039. if issue.IsClosed {
  1040. m.NumClosedIssues++
  1041. }
  1042. if m.NumIssues == 0 {
  1043. return ErrWrongIssueCounter
  1044. }
  1045. if err = updateMilestone(e, m); err != nil {
  1046. return err
  1047. } else if _, err = e.Exec("UPDATE `issue_user` SET milestone_id=? WHERE issue_id=?", m.ID, issue.ID); err != nil {
  1048. return err
  1049. }
  1050. }
  1051. return updateIssue(e, issue)
  1052. }
  1053. // ChangeMilestoneAssign changes assignment of milestone for issue.
  1054. func ChangeMilestoneAssign(oldMid int64, issue *Issue) (err error) {
  1055. sess := x.NewSession()
  1056. defer sess.Close()
  1057. if err = sess.Begin(); err != nil {
  1058. return err
  1059. }
  1060. if err = changeMilestoneAssign(sess, oldMid, issue); err != nil {
  1061. return err
  1062. }
  1063. return sess.Commit()
  1064. }
  1065. // DeleteMilestoneByID deletes a milestone by given ID.
  1066. func DeleteMilestoneByID(mid int64) error {
  1067. m, err := GetMilestoneByID(mid)
  1068. if err != nil {
  1069. if IsErrMilestoneNotExist(err) {
  1070. return nil
  1071. }
  1072. return err
  1073. }
  1074. repo, err := GetRepositoryByID(m.RepoID)
  1075. if err != nil {
  1076. return err
  1077. }
  1078. sess := x.NewSession()
  1079. defer sessionRelease(sess)
  1080. if err = sess.Begin(); err != nil {
  1081. return err
  1082. }
  1083. if _, err = sess.Id(m.ID).Delete(m); err != nil {
  1084. return err
  1085. }
  1086. repo.NumMilestones = int(countRepoMilestones(sess, repo.ID))
  1087. repo.NumClosedMilestones = int(countRepoClosedMilestones(sess, repo.ID))
  1088. if _, err = sess.Id(repo.ID).AllCols().Update(repo); err != nil {
  1089. return err
  1090. }
  1091. if _, err = sess.Exec("UPDATE `issue` SET milestone_id=0 WHERE milestone_id=?", m.ID); err != nil {
  1092. return err
  1093. } else if _, err = sess.Exec("UPDATE `issue_user` SET milestone_id=0 WHERE milestone_id=?", m.ID); err != nil {
  1094. return err
  1095. }
  1096. return sess.Commit()
  1097. }
  1098. // _________ __
  1099. // \_ ___ \ ____ _____ _____ ____ _____/ |_
  1100. // / \ \/ / _ \ / \ / \_/ __ \ / \ __\
  1101. // \ \___( <_> ) Y Y \ Y Y \ ___/| | \ |
  1102. // \______ /\____/|__|_| /__|_| /\___ >___| /__|
  1103. // \/ \/ \/ \/ \/
  1104. // CommentType defines whether a comment is just a simple comment, an action (like close) or a reference.
  1105. type CommentType int
  1106. const (
  1107. // Plain comment, can be associated with a commit (CommitId > 0) and a line (Line > 0)
  1108. COMMENT_TYPE_COMMENT CommentType = iota
  1109. COMMENT_TYPE_REOPEN
  1110. COMMENT_TYPE_CLOSE
  1111. // References.
  1112. COMMENT_TYPE_ISSUE_REF
  1113. // Reference from a commit (not part of a pull request)
  1114. COMMENT_TYPE_COMMIT_REF
  1115. // Reference from a comment
  1116. COMMENT_TYPE_COMMENT_REF
  1117. // Reference from a pull request
  1118. COMMENT_TYPE_PULL_REF
  1119. )
  1120. type CommentTag int
  1121. const (
  1122. COMMENT_TAG_NONE CommentTag = iota
  1123. COMMENT_TAG_POSTER
  1124. COMMENT_TAG_ADMIN
  1125. COMMENT_TAG_OWNER
  1126. )
  1127. // Comment represents a comment in commit and issue page.
  1128. type Comment struct {
  1129. ID int64 `xorm:"pk autoincr"`
  1130. Type CommentType
  1131. PosterID int64
  1132. Poster *User `xorm:"-"`
  1133. IssueID int64 `xorm:"INDEX"`
  1134. CommitID int64
  1135. Line int64
  1136. Content string `xorm:"TEXT"`
  1137. RenderedContent string `xorm:"-"`
  1138. Created time.Time `xorm:"CREATED"`
  1139. Attachments []*Attachment `xorm:"-"`
  1140. // For view issue page.
  1141. ShowTag CommentTag `xorm:"-"`
  1142. }
  1143. // HashTag returns unique hash tag for comment.
  1144. func (c *Comment) HashTag() string {
  1145. return "issuecomment-" + com.ToStr(c.ID)
  1146. }
  1147. // EventTag returns unique event hash tag for comment.
  1148. func (c *Comment) EventTag() string {
  1149. return "event-" + com.ToStr(c.ID)
  1150. }
  1151. func (c *Comment) AfterSet(colName string, _ xorm.Cell) {
  1152. var err error
  1153. switch colName {
  1154. case "id":
  1155. c.Attachments, err = GetAttachmentsByCommentID(c.ID)
  1156. if err != nil {
  1157. log.Error(3, "GetAttachmentsByCommentID[%d]: %v", c.ID, err)
  1158. }
  1159. case "poster_id":
  1160. c.Poster, err = GetUserByID(c.PosterID)
  1161. if err != nil {
  1162. if IsErrUserNotExist(err) {
  1163. c.PosterID = -1
  1164. c.Poster = NewFakeUser()
  1165. } else {
  1166. log.Error(3, "GetUserByID[%d]: %v", c.ID, err)
  1167. }
  1168. }
  1169. }
  1170. }
  1171. func createComment(e *xorm.Session, u *User, repo *Repository, issue *Issue, commitID, line int64, cmtType CommentType, content string, uuids []string) (_ *Comment, err error) {
  1172. comment := &Comment{
  1173. PosterID: u.Id,
  1174. Type: cmtType,
  1175. IssueID: issue.ID,
  1176. CommitID: commitID,
  1177. Line: line,
  1178. Content: content,
  1179. }
  1180. if _, err = e.Insert(comment); err != nil {
  1181. return nil, err
  1182. }
  1183. // Check comment type.
  1184. switch cmtType {
  1185. case COMMENT_TYPE_COMMENT:
  1186. if _, err = e.Exec("UPDATE `issue` SET num_comments=num_comments+1 WHERE id=?", issue.ID); err != nil {
  1187. return nil, err
  1188. }
  1189. // Check attachments.
  1190. attachments := make([]*Attachment, 0, len(uuids))
  1191. for _, uuid := range uuids {
  1192. attach, err := getAttachmentByUUID(e, uuid)
  1193. if err != nil {
  1194. if IsErrAttachmentNotExist(err) {
  1195. continue
  1196. }
  1197. return nil, fmt.Errorf("getAttachmentByUUID[%s]: %v", uuid, err)
  1198. }
  1199. attachments = append(attachments, attach)
  1200. }
  1201. for i := range attachments {
  1202. attachments[i].IssueID = issue.ID
  1203. attachments[i].CommentID = comment.ID
  1204. // No assign value could be 0, so ignore AllCols().
  1205. if _, err = e.Id(attachments[i].ID).Update(attachments[i]); err != nil {
  1206. return nil, fmt.Errorf("update attachment[%d]: %v", attachments[i].ID, err)
  1207. }
  1208. }
  1209. // Notify watchers.
  1210. act := &Action{
  1211. ActUserID: u.Id,
  1212. ActUserName: u.LowerName,
  1213. ActEmail: u.Email,
  1214. OpType: COMMENT_ISSUE,
  1215. Content: fmt.Sprintf("%d|%s", issue.Index, strings.Split(content, "\n")[0]),
  1216. RepoID: repo.ID,
  1217. RepoUserName: repo.Owner.LowerName,
  1218. RepoName: repo.LowerName,
  1219. IsPrivate: repo.IsPrivate,
  1220. }
  1221. if err = notifyWatchers(e, act); err != nil {
  1222. return nil, err
  1223. }
  1224. case COMMENT_TYPE_REOPEN:
  1225. if _, err = e.Exec("UPDATE `repository` SET num_closed_issues=num_closed_issues-1 WHERE id=?", repo.ID); err != nil {
  1226. return nil, err
  1227. }
  1228. case COMMENT_TYPE_CLOSE:
  1229. if _, err = e.Exec("UPDATE `repository` SET num_closed_issues=num_closed_issues+1 WHERE id=?", repo.ID); err != nil {
  1230. return nil, err
  1231. }
  1232. }
  1233. return comment, nil
  1234. }
  1235. func createStatusComment(e *xorm.Session, doer *User, repo *Repository, issue *Issue) (*Comment, error) {
  1236. cmtType := COMMENT_TYPE_CLOSE
  1237. if !issue.IsClosed {
  1238. cmtType = COMMENT_TYPE_REOPEN
  1239. }
  1240. return createComment(e, doer, repo, issue, 0, 0, cmtType, "", nil)
  1241. }
  1242. // CreateComment creates comment of issue or commit.
  1243. func CreateComment(doer *User, repo *Repository, issue *Issue, commitID, line int64, cmtType CommentType, content string, attachments []string) (comment *Comment, err error) {
  1244. sess := x.NewSession()
  1245. defer sessionRelease(sess)
  1246. if err = sess.Begin(); err != nil {
  1247. return nil, err
  1248. }
  1249. comment, err = createComment(sess, doer, repo, issue, commitID, line, cmtType, content, attachments)
  1250. if err != nil {
  1251. return nil, err
  1252. }
  1253. return comment, sess.Commit()
  1254. }
  1255. // CreateIssueComment creates a plain issue comment.
  1256. func CreateIssueComment(doer *User, repo *Repository, issue *Issue, content string, attachments []string) (*Comment, error) {
  1257. return CreateComment(doer, repo, issue, 0, 0, COMMENT_TYPE_COMMENT, content, attachments)
  1258. }
  1259. // GetCommentById returns the comment with the given id
  1260. func GetCommentById(id int64) (*Comment, error) {
  1261. c := new(Comment)
  1262. _, err := x.Id(id).Get(c)
  1263. return c, err
  1264. }
  1265. // GetCommentsByIssueID returns all comments of issue by given ID.
  1266. func GetCommentsByIssueID(issueID int64) ([]*Comment, error) {
  1267. comments := make([]*Comment, 0, 10)
  1268. return comments, x.Where("issue_id=?", issueID).Asc("created").Find(&comments)
  1269. }
  1270. func (c *Comment) AfterDelete() {
  1271. _, err := DeleteAttachmentsByComment(c.ID, true)
  1272. if err != nil {
  1273. log.Info("Could not delete files for comment %d on issue #%d: %s", c.ID, c.IssueID, err)
  1274. }
  1275. }
  1276. // Attachment represent a attachment of issue/comment/release.
  1277. type Attachment struct {
  1278. ID int64 `xorm:"pk autoincr"`
  1279. UUID string `xorm:"uuid UNIQUE"`
  1280. IssueID int64 `xorm:"INDEX"`
  1281. CommentID int64
  1282. ReleaseID int64 `xorm:"INDEX"`
  1283. Name string
  1284. Created time.Time `xorm:"CREATED"`
  1285. }
  1286. // AttachmentLocalPath returns where attachment is stored in local file system based on given UUID.
  1287. func AttachmentLocalPath(uuid string) string {
  1288. return path.Join(setting.AttachmentPath, uuid[0:1], uuid[1:2], uuid)
  1289. }
  1290. // LocalPath returns where attachment is stored in local file system.
  1291. func (attach *Attachment) LocalPath() string {
  1292. return AttachmentLocalPath(attach.UUID)
  1293. }
  1294. // NewAttachment creates a new attachment object.
  1295. func NewAttachment(name string, buf []byte, file multipart.File) (_ *Attachment, err error) {
  1296. attach := &Attachment{
  1297. UUID: gouuid.NewV4().String(),
  1298. Name: name,
  1299. }
  1300. if err = os.MkdirAll(path.Dir(attach.LocalPath()), os.ModePerm); err != nil {
  1301. return nil, fmt.Errorf("MkdirAll: %v", err)
  1302. }
  1303. fw, err := os.Create(attach.LocalPath())
  1304. if err != nil {
  1305. return nil, fmt.Errorf("Create: %v", err)
  1306. }
  1307. defer fw.Close()
  1308. if _, err = fw.Write(buf); err != nil {
  1309. return nil, fmt.Errorf("Write: %v", err)
  1310. } else if _, err = io.Copy(fw, file); err != nil {
  1311. return nil, fmt.Errorf("Copy: %v", err)
  1312. }
  1313. sess := x.NewSession()
  1314. defer sessionRelease(sess)
  1315. if err := sess.Begin(); err != nil {
  1316. return nil, err
  1317. }
  1318. if _, err := sess.Insert(attach); err != nil {
  1319. return nil, err
  1320. }
  1321. return attach, sess.Commit()
  1322. }
  1323. func getAttachmentByUUID(e Engine, uuid string) (*Attachment, error) {
  1324. attach := &Attachment{UUID: uuid}
  1325. has, err := x.Get(attach)
  1326. if err != nil {
  1327. return nil, err
  1328. } else if !has {
  1329. return nil, ErrAttachmentNotExist{0, uuid}
  1330. }
  1331. return attach, nil
  1332. }
  1333. // GetAttachmentByUUID returns attachment by given UUID.
  1334. func GetAttachmentByUUID(uuid string) (*Attachment, error) {
  1335. return getAttachmentByUUID(x, uuid)
  1336. }
  1337. // GetAttachmentsByIssueID returns all attachments for given issue by ID.
  1338. func GetAttachmentsByIssueID(issueID int64) ([]*Attachment, error) {
  1339. attachments := make([]*Attachment, 0, 10)
  1340. return attachments, x.Where("issue_id=? AND comment_id=0", issueID).Find(&attachments)
  1341. }
  1342. // GetAttachmentsByCommentID returns all attachments if comment by given ID.
  1343. func GetAttachmentsByCommentID(commentID int64) ([]*Attachment, error) {
  1344. attachments := make([]*Attachment, 0, 10)
  1345. return attachments, x.Where("comment_id=?", commentID).Find(&attachments)
  1346. }
  1347. // DeleteAttachment deletes the given attachment and optionally the associated file.
  1348. func DeleteAttachment(a *Attachment, remove bool) error {
  1349. _, err := DeleteAttachments([]*Attachment{a}, remove)
  1350. return err
  1351. }
  1352. // DeleteAttachments deletes the given attachments and optionally the associated files.
  1353. func DeleteAttachments(attachments []*Attachment, remove bool) (int, error) {
  1354. for i, a := range attachments {
  1355. if remove {
  1356. if err := os.Remove(a.LocalPath()); err != nil {
  1357. return i, err
  1358. }
  1359. }
  1360. if _, err := x.Delete(a.ID); err != nil {
  1361. return i, err
  1362. }
  1363. }
  1364. return len(attachments), nil
  1365. }
  1366. // DeleteAttachmentsByIssue deletes all attachments associated with the given issue.
  1367. func DeleteAttachmentsByIssue(issueId int64, remove bool) (int, error) {
  1368. attachments, err := GetAttachmentsByIssueID(issueId)
  1369. if err != nil {
  1370. return 0, err
  1371. }
  1372. return DeleteAttachments(attachments, remove)
  1373. }
  1374. // DeleteAttachmentsByComment deletes all attachments associated with the given comment.
  1375. func DeleteAttachmentsByComment(commentId int64, remove bool) (int, error) {
  1376. attachments, err := GetAttachmentsByCommentID(commentId)
  1377. if err != nil {
  1378. return 0, err
  1379. }
  1380. return DeleteAttachments(attachments, remove)
  1381. }