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)
|
}
|
}
|
}
|
