CString CWizIndexBase::FormatModifiedQuerySQL(const CString& strTableName, const CString& strFieldList) { return WizFormatString2(_T("select %1 from %2 where WIZ_VERSION = -1"), strFieldList, strTableName); }
CString CWizIndexBase::FormatDeleteSQLFormat(const CString& strTableName, const CString& strKey) { return WizFormatString2(_T("delete from %1 where %2=%s"), strTableName, strKey); }
CString CWizIndexBase::FormatQuerySQL(const CString& strTableName, const CString& strFieldList) { return WizFormatString2(_T("select %1 from %2"), strFieldList, strTableName); }
void CWizNoteInfoForm::setDocument(const WIZDOCUMENTDATA& data) { Q_ASSERT(!data.strKbGUID.isEmpty()); m_docKbGuid = data.strKbGUID; m_docGuid = data.strGUID; CWizDatabase& db = CWizDatabaseManager::instance()->db(data.strKbGUID); QString doc = db.GetDocumentFileName(data.strGUID); QString sz = ::WizGetFileSizeHumanReadalbe(doc); ui->editTitle->setText(data.strTitle); // private document if (data.strKbGUID == CWizDatabaseManager::instance()->db().kbGUID()) { ui->labelNotebook->setText(data.strLocation); QString tags = db.GetDocumentTagsText(data.strGUID); ui->labelTags->setText(tags); ui->editAuthor->setText(data.strAuthor); // group document } else { CWizTagDataArray arrayTag; if (!db.GetDocumentTags(data.strGUID, arrayTag)) { ui->labelNotebook->clear(); } else { if (arrayTag.size() > 1) { TOLOG1("Group document should only have one tag: %1", data.strTitle); } QString tagText; if (arrayTag.size()) { tagText = db.getTagTreeText(arrayTag[0].strGUID); } ui->labelNotebook->setText("/" + db.name() + tagText + "/"); } ui->labelTags->clear(); ui->editAuthor->setText(data.strAuthor); } // common fields ui->editCreateTime->setText(data.tCreated.toString()); ui->editUpdateTime->setText(data.tModified.toString()); ui->editURL->setText(data.strURL); ui->labelOpenURL->setText(WizFormatString2("<a href=\"%1\">%2</a>", data.strURL, tr("Open"))); ui->labelSize->setText(sz); ui->checkEncrypted->setChecked(data.nProtected ? true : false); bool canEdit = (db.CanEditDocument(data) && !CWizDatabase::IsInDeletedItems(data.strLocation)); ui->editAuthor->setReadOnly(!canEdit); ui->editTitle->setReadOnly(!canEdit); ui->editURL->setReadOnly(!canEdit); ui->checkEncrypted->setEnabled(canEdit && !db.IsGroup()); }
void CWizKbSync::startDownloadObjectsData() { m_db->GetAllObjectsNeedToBeDownloaded(m_arrayAllObjectsNeedToBeDownloaded); int nTotal = m_arrayAllObjectsNeedToBeDownloaded.size(); if (m_nDaysDownload == -1) { m_arrayAllObjectsNeedToBeDownloaded.clear(); } else { COleDateTime tNow = ::WizGetCurrentTime(); size_t count = m_arrayAllObjectsNeedToBeDownloaded.size(); for (intptr_t i = count - 1; i >= 0; i--) { COleDateTime t = m_arrayAllObjectsNeedToBeDownloaded[i].tTime; t = t.addDays(m_nDaysDownload); if (t < tNow) { m_arrayAllObjectsNeedToBeDownloaded.erase(m_arrayAllObjectsNeedToBeDownloaded.begin() + i); continue; } if (m_arrayAllObjectsNeedToBeDownloaded[i].eObjectType == wizobjectDocumentAttachment) { m_arrayAllObjectsNeedToBeDownloaded.erase(m_arrayAllObjectsNeedToBeDownloaded.begin() + i); continue; } } } int nTotalDownload = m_arrayAllObjectsNeedToBeDownloaded.size(); if (nTotal) { Q_EMIT processLog(WizFormatString2(tr("downloading objects data, total %1 objects need download, actually download: %2"), QString::number(nTotal), QString::number(nTotalDownload))); } Q_EMIT progressChanged(progressAttachmentUploaded); downloadNextObjectData(); }
QString formatLabelLink(const QString& linkHref, const QString& text) { return WizFormatString2("<a href=\"%1\" style=\"color:#5990EF;" "text-decoration:none;\">%2</a>", linkHref, text); }
QString WizXmlRpcFaultValue::toString() const { return WizFormatString2("Fault error: %1, %2", WizIntToStr(getFaultCode()), getFaultString()); }
virtual CString ToString() const { return WizFormatString2(_T("Fault error: %1, %2"), WizIntToStr(GetFaultCode()), GetFaultString()); }
QString CWizXmlRpcFaultValue::ToString() const { return WizFormatString2(_T("Fault error: %1, %2"), WizIntToStr(GetFaultCode()), GetFaultString()); }
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; }