func FindItemByItemSalePriceLTE(price, limit string) ([]entity.Item, error) {
if limit == "" {
limit = "100"
}
q := "SELECT * FROM item WHERE itemSalePrice <= " + price + " ORDER BY itemNo LIMIT " + limit
items, err := datastore.ItemQueryWithCache(q)
if err != nil {
return nil, err
}
return items, nil
}
func FindItemBySupplier(supplier, limit string) ([]entity.Item, error) {
if limit == "" {
limit = "100"
}
q := "SELECT * FROM item WHERE itemSupplier = '" + supplier + "' ORDER BY itemNo LIMIT " + limit
items, err := datastore.ItemQueryWithCache(q)
if err != nil {
return nil, err
}
return items, nil
}
func FindItemByItemSoldQuantityGTE(quantity, limit string) ([]entity.Item, error) {
if limit == "" {
limit = "100"
}
q := "SELECT * FROM item WHERE itemSoldQuantity >= " + quantity + " ORDER BY itemNo LIMIT " + limit
items, err := datastore.ItemQueryWithCache(q)
if err != nil {
return nil, err
}
return items, nil
}
func FindItemByItemID(itemID string) (item entity.Item, err error) {
if itemID == "" {
return
}
q := "SELECT * FROM item WHERE id = '" + itemID + "'"
items, err := datastore.ItemQueryWithCache(q)
if err != nil {
return
}
if len(items) == 0 {
return
}
return items[0], nil
}
func FindItemByPostItemStateNotEQ(state, limit string) ([]entity.Item, error) {
if limit == "" {
limit = "100"
}
q := "SELECT postItemId FROM post4 WHERE postItemState <> '" + state + "'"
posts, err := datastore.PostQueryForItemID(q)
if err != nil {
return nil, err
}
itemIDMap := make(map[string]bool, len(posts))
for i := range posts {
if itemIDMap[posts[i]] {
continue
}
itemIDMap[posts[i]] = true
}
itemIDs := make([]byte, 11*len(posts))
for id := range itemIDMap {
itemIDs = append(itemIDs, "'"...)
itemIDs = append(itemIDs, id...)
itemIDs = append(itemIDs, "',"...)
}
q = "SELECT * FROM item WHERE id IN(" + string(itemIDs) + ") ORDER BY userNo LIMIT " + limit
items, err := datastore.ItemQueryWithCache(q)
if err != nil {
return nil, err
}
if len(items) == 0 {
return nil, nil
}
return items, nil
}
