func (repo *DbAccountRepo) FindById(id, userId int) (*domain.Account, error) {
rt := new(domain.Account)
card := new(domain.CreditCard)
err := repo.db.QueryRow("SELECT a.id, account_type, account_name, starting_amount, at.name, display_order, COALESCE(comment, ''), COALESCE(c.last_date, 0), COALESCE(c.paying_month, 0), COALESCE(c.paying_day, 0), COALESCE(c.paying_account, 0), COALESCE(c.holiday, 0) FROM accounts AS a INNER JOIN account_types AS at ON (at.id = a.account_type) LEFT OUTER JOIN credit_cards AS c ON (c.account_id = a.id) WHERE a.id = $1 AND a.owner_id = $2", id, userId).Scan(&rt.Id, &rt.Type, &rt.Name, &rt.StartingAmount, &rt.TypeName, &rt.Order, &rt.Comment, &card.LastDate, &card.PayingMonth, &card.PayingDay, &card.PayingAccount, &card.Holiday)
if err != nil {
return nil, err
}
if rt.Type == 4 {
rt.CreditCard = card
}
return rt, nil
}
func (repo *DbAccountRepo) FindAllByOwner(userId int) ([]*domain.Account, error) {
rows, err := repo.db.Query("SELECT a.id, account_type, account_name, starting_amount, at.name, display_order, COALESCE(c.last_date, 0), COALESCE(c.paying_month, 0), COALESCE(c.paying_day, 0), COALESCE(c.paying_account, 0), COALESCE(c.holiday, 0) FROM accounts AS a INNER JOIN account_types AS at ON (at.id = a.account_type) LEFT OUTER JOIN credit_cards AS c ON (c.account_id = a.id) WHERE a.owner_id = $1 ORDER BY display_order ASC, id ASC", userId)
if err != nil {
return nil, err
}
var rt []*domain.Account
for rows.Next() {
account := new(domain.Account)
card := new(domain.CreditCard)
err = rows.Scan(&account.Id, &account.Type, &account.Name, &account.StartingAmount, &account.TypeName, &account.Order, &card.LastDate, &card.PayingMonth, &card.PayingDay, &card.PayingAccount, &card.Holiday)
if err != nil {
return nil, err
}
if account.Type == 4 {
account.CreditCard = card
}
rt = append(rt, account)
}
return rt, nil
}
func (handler AccountHandler) PutPostJSON(w http.ResponseWriter, r *http.Request, user *usecases.User, title *Title) *WebError {
vars := mux.Vars(r)
var err error
account := new(domain.Account)
if vars["id"] != "create" {
id, _ := strconv.Atoi(vars["id"])
account, err = handler.AccountInteractor.FetchById(id, user.Id)
if err != nil {
log.Println(err)
return nil
}
}
rt, err := ParseJSONBody(r)
if err != nil {
log.Println(err)
return nil
}
if name, ok := rt["Name"].(string); ok {
account.Name = name
}
account.Type = InterfaceToInt(rt["Type"], 0)
account.StartingAmount = InterfaceToInt64(rt["StartingAmount"], 0)
account.Order = InterfaceToInt(rt["Order"], account.Order)
if comment, ok := rt["Comment"].(string); ok {
account.Comment = comment
}
if rt["CreditCard"] != nil {
if card, ok := rt["CreditCard"].(map[string]interface{}); ok {
if account.CreditCard == nil {
account.CreditCard = new(domain.CreditCard)
}
account.CreditCard.LastDate = InterfaceToInt(card["LastDate"], 0)
account.CreditCard.PayingMonth = InterfaceToInt(card["PayingMonth"], 0)
account.CreditCard.PayingDay = InterfaceToInt(card["PayingDay"], 0)
account.CreditCard.PayingAccount = InterfaceToInt(card["PayingAccount"], 0)
account.CreditCard.Holiday = InterfaceToInt(card["Holiday"], 0)
}
}
account.OwnerId = user.Id
err = handler.AccountInteractor.Save(account)
if err != nil {
return &WebError{
Error: err,
Code: 500,
Message: "Error saving account",
Json: true,
}
}
return nil
}