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

export default {
	async saveMaterialContent(orderNo, materialName, originalContent, contents) {
		const reference = {
			reference_content_index: '',
			reference_content: ''
		}
		for (var index = 0; index < contents.length; index++) {
			var element = contents[index];
			if (index > 0) {
				reference.reference_content += '@#@'
				reference.reference_content_index += '@#@'
			}
			reference.reference_content += element.text;

			reference.reference_content_index += JSON.stringify(element.indexes);
		}

		let counts = await query("select count(*) AS count from materials_content where reference_content like '%" +
			reference.reference_content + "%' and orderNo = ?", [orderNo]);
		if (counts[0].count === 0) {
			await insert('materials_content', {
				orderNo: orderNo,
				material_name: materialName,
				reference_content_index: reference.reference_content_index,
				original_content: originalContent,
				reference_content: reference.reference_content
			})
		}
	},

	async getMaterialContent(orderNo, materialName) {
		try {
			const contents = await query(
				'select reference_content from materials_content where orderNo = ? and material_name = ?',
				[orderNo, materialName]);
			return contents;
		} catch (e) {
			console.error('getMaterialContent', e)
		}
	},

	async getAMaterialContent(orderNo, materialName) {
		try {
			const contents = await query(
				'select * from materials_content where orderNo = ? and material_name = ?',
				[orderNo, materialName]);
			return contents;
		} catch (e) {
			console.error('getAMaterialContent', e)
		}
	},
}