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