import {
	deleteData,
	insert,
	query,
	update
} from "../common/sqlite";


export default {
	async saveOrderMaterials(orderNo, materials) {
		try {
			for (var i = 0; i < materials.length; i++) {

				const result = await query('select * from order_materials where orderNo = ? and material_name = ?',
					[orderNo,
						materials[i].name
					]);

				if (result.length === 0) {
					await insert('order_materials', {
						orderNo: orderNo,
						material_name: materials[i].name,
						tab_order: i + 1
					});
				}
			}
		} catch (e) {
			console.error('订单物料关系添加错误', e);
			throw new Error('订单物料关系添加错误' + e)
		}
	},

	async updateMatOrder(orderNo, materials) {
		try {
			for (var i = 0; i < materials.length; i++) {

				const result = await query('select * from order_materials where orderNo = ? and material_name = ?',
					[orderNo,
						materials[i].name
					]);

				if (result.length === 1) {
					await update('order_materials', {
						tab_order: i + 1
					}, ' orderNo = ? and material_name = ? ', [orderNo,
						materials[i].name
					]);
				}
			}
		} catch (e) {
			console.error('订单物料排序修改错误', e);
			throw new Error('订单物料排序修改错误' + e)
		}
	},

	async deleteOrderMat(orderNo, matName) {
		try {
			await deleteData('order_materials', ' orderNo = ? and material_name = ? ', [orderNo, matName])
		} catch (e) {
			console.error('订单物料删除错误', e);
			throw new Error('订单物料删除错误' + e)
		}
	},

	async getMaterials(orderNo) {
		try {
			const materials = await query('select * from order_materials where orderNo = ? order by tab_order', [
				orderNo
			]);
			return materials;
		} catch (e) {
			console.error('物料查询错误', e)
		}
	}
}