package order

import (
	"zhiyuan/models"
	"zhiyuan/pkg/db"
)

var ASOrderIssue models.ASOrderIssue

func AddMultiIssue(issueMap []map[string]interface{}) (int64, error) {
	return db.Insert(ASOrderIssue.TableName(), issueMap)
}

func GetIssues(where map[string]interface{}, fields []string, retVal interface{}) ([]*models.ASOrderIssue, error) {
	return ASOrderIssue.GetMulti(where, fields, retVal)
}

func DelIssueByOrder(id int) (int64, error) {
	return db.Delete(ASOrderIssue.TableName(), map[string]interface{}{"order_id": id})
}

func GetIssueWidthOrder(where map[string]string, param map[string]interface{}, retVal interface{}) error {
	sql := "SELECT o.*, i.issue_desc, i.director, i.brand, issue_id FROM zy_as_order_issue i LEFT JOIN zy_as_order o ON i.order_id=o.id"
	return db.GetMultiRaw(sql, where, param, retVal)
}