bool CWizIndexBase::SQLToDocumentAttachmentDataArray(const CString& strSQL,
CWizDocumentAttachmentDataArray& arrayAttachment)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZDOCUMENTATTACHMENTDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(documentattachmentATTACHMENT_GUID);
data.strDocumentGUID = query.getStringField(documentattachmentDOCUMENT_GUID);
data.strName = query.getStringField(documentattachmentATTACHMENT_NAME);
data.strURL = query.getStringField(documentattachmentATTACHMENT_URL);
data.strDescription = query.getStringField(documentattachmentATTACHMENT_DESCRIPTION);
data.tInfoModified = query.getTimeField(documentattachmentDT_INFO_MODIFIED);
data.strInfoMD5 = query.getStringField(documentattachmentATTACHMENT_INFO_MD5);
data.tDataModified = query.getTimeField(documentattachmentDT_DATA_MODIFIED);
data.strDataMD5 = query.getStringField(documentattachmentATTACHMENT_DATA_MD5);
data.nVersion = query.getInt64Field(documentattachmentVersion);
arrayAttachment.push_back(data);
query.nextRow();
}
std::sort(arrayAttachment.begin(), arrayAttachment.end());
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
bool WizKMCombineDocumentsToHtmlFile(WizDatabaseManager& dbMgr, const CWizDocumentDataArray& arrayDocument, QString splitter, bool addTitle, QString& strResultFileName, CWizDocumentAttachmentDataArray& arrayAttachment, QString& strError)
{
QString strTempPath = Utils::WizPathResolve::tempPath() + WizGenGUIDLowerCaseLetterOnly() + "/";
::WizEnsurePathExists(strTempPath);
//
CWizStdStringArray htmls;
//
size_t nCount = arrayDocument.size();
for (size_t i = 0; i < nCount; i++)
{
WIZDOCUMENTDATA doc = arrayDocument[i];
//
WizDatabase& db = dbMgr.db(doc.strKbGUID);
if (!db.isDocumentDownloaded(doc.strGUID))
{
strError = QObject::tr("Note has not been downloaded");
return false;
}
//
if (!db.documentToHtmlFile(doc, strTempPath))
{
strError = QObject::tr("Failed to get note data");
return false;
}
//
QString htmlFileName = strTempPath + "index.html";
if (!QFileInfo::exists(htmlFileName))
{
strError = QObject::tr("Failed to get note data");
return false;
}
//
QString html;
if (!WizLoadUnicodeTextFromFile(htmlFileName, html))
{
strError = QObject::tr("Failed to read note data");
return false;
}
//
htmls.push_back(html);
//
CWizDocumentAttachmentDataArray atts;
db.getDocumentAttachments(doc.strGUID, atts);
for (WIZDOCUMENTATTACHMENTDATA att : atts)
{
if (!db.isAttachmentDownloaded(att.strGUID))
{
strError = QObject::tr("Note attachment %1 has not been downloaded").arg(att.strName);
return false;
}
//
arrayAttachment.push_back(att);
}
}
//
CString strAllHTML;
//
for (size_t i = 0; i < nCount; i++)
{
CString html = htmls[i];
WIZDOCUMENTDATA doc = arrayDocument[i];
if (-1 != WizStrStrI_Pos(html, CString(_T("<frameset"))))
{
strError = QObject::tr("Cannot combine html because html contains frame set");
return false;
}
//
CString strTitle = doc.strTitle;
WizOleDateTime t = doc.tCreated;
CString strDate = t.toLocalLongDate();
//
if (addTitle)
{
CString strInfoHtml = WizFormatString2(_T("<h2>%1 (%2)</h2>"), strTitle, strDate);
::WizHTMLInsertTextBeforeBody(strInfoHtml, html);
}
//
if (!WizCombineHtmlText(strAllHTML, html))
{
strError = QObject::tr("Cannot combine html");
return false;
}
//
if (i < nCount - 1)
{
if (!splitter.isEmpty())
{
WizCombineHtmlText(strAllHTML, splitter);
}
}
}
//
strResultFileName = strTempPath + "index.html";
//
bool ret = ::WizSaveUnicodeTextToUtf8File(strResultFileName, strAllHTML);
if (!ret)
{
strError = QObject::tr("Cannot save note html");
return false;
}
return true;
}
