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

export default {
	async getScanRecord(orderNo, materialName) {
		try {
			return query('select count(*) AS quantity from scan_records where orderNo = ? and materialName = ?', [
				orderNo,
				materialName
			])
		} catch (e) {
			console.error('getScanRecord', e)
		}
	},

	async getScanRecords(orderNo, materialName) {
		try {
			return query('select * from scan_records where orderNo = ? and materialName = ? order by scan_time desc', [orderNo,
				materialName
			])
		} catch (e) {
			console.error('getScanRecord', e)
		}
	},

	async saveScanRecord(orderNo, materialName, scanContent, contents) {
		try {
			let referenceContent = '';
			const createTime = new Date().toISOString()

			if (typeof contents[0] == 'object') {
				for (var index = 0; index < contents.length; index++) {
					var element = contents[index];
					if (index > 0) {
						referenceContent += '@#@'
					}
					referenceContent += element.text;
				}
			} else {
				referenceContent = contents.join("@#@")
			}

			return await insert('scan_records', {
				orderNo: orderNo,
				materialName: materialName,
				scan_content: scanContent,
				reference_content: referenceContent,
				is_matched: true,
				scan_time: createTime
			})
		} catch (e) {
			console.error('saveScanRecord', e)
		}
	}
}