func CloseEvent(username string, colsed_note string, id string) (err error) { q := orm.NewOrm() q.Using("falcon_portal") userid := uic.ReadUserIdByName(username) _, err = q.Raw("Update event_cases SET user_modified = ?, closed_at = ?, status = ?, closed_note = ? WHERE id = ?", userid, time.Now(), "SOLVED", colsed_note, id).Exec() return }
func AddNote(username string, processNote string, eventcaseid string, processStatus string, bossId string) (err error) { q := orm.NewOrm() q.Using("falcon_portal") userid := uic.ReadUserIdByName(username) sqlbase := fmt.Sprintf("SET event_caseId = '%s' , user_id = %d", eventcaseid, userid) if processNote != "" { sqlbase = fmt.Sprintf("%s , note = '%s'", sqlbase, processNote) } //for set boss case id if bossId != "" { sqlbase = fmt.Sprintf("%s, case_id = '%s'", sqlbase, bossId) } if processStatus != "" { sqlbase = fmt.Sprintf("%s, status = '%s'", sqlbase, processStatus) } var processNoteID int q.Raw(fmt.Sprintf("Insert INTO event_note %s, timestamp = ? ;", sqlbase), time.Now()).Exec() err = q.Raw("SELECT LAST_INSERT_ID()").QueryRow(&processNoteID) if processNoteID != 0 && (processStatus == "resolved" || processStatus == "in progress" || processStatus == "ignored") && err == nil { err = UpdateCaseStatus(eventcaseid, processNoteID, processStatus) } return }