// import _ from "lodash";

import { executeQuery } from "~/lib/db";
import helper from "~/functions/helper";
// import cache from "~/functions/cache";

async function getList() {
	let list = null;

	// if (cache.has("itemsList")) {
	// 	list = cache.get("itemsList");
	// } else {
	const rows = await executeQuery({
		query: `
				SELECT
					itemID,
					itemSetID,
					itemBundleID,
					itemCategoryID,
					itemSubCategoryID,
					itemGroupID,
					itemSubGroupID,
					makerID,
					statusID,
					itemNumber,
					description,
					price,
					priceUnknown,
					shipping,
					shippingFree,
					sourceID,
					primaryPhoto,
					purchasedDate,
					purchasedDateNA,
					shippedDate,
					shippedDateNA,
					deliveredDate,
					deliveredDateNA,
					lockGeneral,
					lockPhotos
				FROM
					vw_items
				ORDER BY
					categorySortOrder,
					subCategorySortOrder,
					groupSortOrder,
					subGroupSortOrder
			`,
	});

	list = helper.emptyOrRows(rows);

	// cache.set("itemsList", list);
	// }

	return list;
}

export default {
	getList,
};