void incident::populate()
{
q.prepare("SELECT incdt_number,"
" incdt_crmacct_id,"
" COALESCE(incdt_cntct_id,-1) AS incdt_cntct_id,"
" (cntct_first_name || ' ' || cntct_last_name) AS cntct_name,"
" incdt_summary, incdt_descrip,"
" incdt_item_id, incdt_ls_id,"
" incdt_status, incdt_assigned_username,"
" incdt_incdtcat_id, incdt_incdtseverity_id,"
" incdt_incdtpriority_id, incdt_incdtresolution_id"
" FROM incdt LEFT OUTER JOIN cntct ON (incdt_cntct_id=cntct_id)"
" WHERE (incdt_id=:incdt_id); ");
q.bindValue(":incdt_id", _incdtid);
q.exec();
if(q.first())
{
_crmacct->setId(q.value("incdt_crmacct_id").toInt());
_cntct->setId(q.value("incdt_cntct_id").toInt());
_number->setText(q.value("incdt_number").toString());
_assignedTo->setUsername(q.value("incdt_assigned_username").toString());
_category->setNull();
if(!q.value("incdt_incdtcat_id").toString().isEmpty())
_category->setId(q.value("incdt_incdtcat_id").toInt());
_status->setCurrentIndex(_statusCodes.indexOf(q.value("incdt_status").toString()));
_severity->setNull();
if(!q.value("incdt_incdtseverity_id").toString().isEmpty())
_severity->setId(q.value("incdt_incdtseverity_id").toInt());
_priority->setNull();
if(!q.value("incdt_incdtpriority_id").toString().isEmpty())
_priority->setId(q.value("incdt_incdtpriority_id").toInt());
_resolution->setNull();
if(!q.value("incdt_incdtresolution_id").toString().isEmpty())
_resolution->setId(q.value("incdt_incdtresolution_id").toInt());
if(!q.value("incdt_item_id").toString().isEmpty())
_item->setId(q.value("incdt_item_id").toInt());
else
_item->setId(-1);
if(!q.value("incdt_ls_id").toString().isEmpty())
_lotserial->setId(q.value("incdt_ls_id").toInt());
else
_lotserial->setId(-1);
_description->setText(q.value("incdt_summary").toString());
_notes->setText(q.value("incdt_descrip").toString());
_comments->setId(_incdtid);
sFillHistoryList();
sFillTodoList();
}
}
void incident::populate()
{
XSqlQuery incidentpopulate;
incidentpopulate.prepare("SELECT incdt_number,"
" incdt_crmacct_id,"
" COALESCE(incdt_cntct_id,-1) AS incdt_cntct_id,"
" (cntct_first_name || ' ' || cntct_last_name) AS cntct_name,"
" incdt_summary, incdt_descrip,"
" incdt_item_id, incdt_ls_id,"
" incdt_status, incdt_assigned_username,"
" incdt_incdtcat_id, incdt_incdtseverity_id,"
" incdt_incdtpriority_id, incdt_incdtresolution_id,"
" incdt_owner_username, incdt_recurring_incdt_id,"
" COALESCE(incdt_aropen_id, -1) AS docId,"
" COALESCE(aropen_docnumber, '') AS docNumber,"
" CASE WHEN (aropen_doctype='C') THEN :creditMemo"
" WHEN (aropen_doctype='D') THEN :debitMemo"
" WHEN (aropen_doctype='I') THEN :invoice"
" WHEN (aropen_doctype='R') THEN :cashdeposit"
" ELSE ''"
" END AS docType, "
" COALESCE(incdt_prj_id,-1) AS incdt_prj_id,"
" COALESCE(incdt_public, false) AS incdt_public,"
" aropen_doctype "
"FROM incdt LEFT OUTER JOIN cntct ON (incdt_cntct_id=cntct_id)"
" LEFT OUTER JOIN aropen ON (incdt_aropen_id=aropen_id) "
"WHERE (incdt_id=:incdt_id); ");
incidentpopulate.bindValue(":incdt_id", _incdtid);
incidentpopulate.bindValue(":creditMemo", tr("Credit Memo"));
incidentpopulate.bindValue(":debitMemo", tr("Debit Memo"));
incidentpopulate.bindValue(":invoice", tr("Invoice"));
incidentpopulate.bindValue(":cashdeposit", tr("Customer Deposit"));
incidentpopulate.exec();
if(incidentpopulate.first())
{
_cntct->setId(incidentpopulate.value("incdt_cntct_id").toInt());
_crmacct->setId(incidentpopulate.value("incdt_crmacct_id").toInt());
_owner->setUsername(incidentpopulate.value("incdt_owner_username").toString());
_number->setText(incidentpopulate.value("incdt_number").toString());
_assignedTo->setUsername(incidentpopulate.value("incdt_assigned_username").toString());
_category->setNull();
if(!incidentpopulate.value("incdt_incdtcat_id").toString().isEmpty())
_category->setId(incidentpopulate.value("incdt_incdtcat_id").toInt());
_status->setCurrentIndex(_statusCodes.indexOf(incidentpopulate.value("incdt_status").toString()));
_severity->setNull();
if(!incidentpopulate.value("incdt_incdtseverity_id").toString().isEmpty())
_severity->setId(incidentpopulate.value("incdt_incdtseverity_id").toInt());
_priority->setNull();
if(!incidentpopulate.value("incdt_incdtpriority_id").toString().isEmpty())
_priority->setId(incidentpopulate.value("incdt_incdtpriority_id").toInt());
_resolution->setNull();
if(!incidentpopulate.value("incdt_incdtresolution_id").toString().isEmpty())
_resolution->setId(incidentpopulate.value("incdt_incdtresolution_id").toInt());
if(!incidentpopulate.value("incdt_item_id").toString().isEmpty())
_item->setId(incidentpopulate.value("incdt_item_id").toInt());
else
_item->setId(-1);
if(!incidentpopulate.value("incdt_ls_id").toString().isEmpty())
_lotserial->setId(incidentpopulate.value("incdt_ls_id").toInt());
else
_lotserial->setId(-1);
_description->setText(incidentpopulate.value("incdt_summary").toString());
_notes->setText(incidentpopulate.value("incdt_descrip").toString());
_comments->setId(_incdtid);
_documents->setId(_incdtid);
_charass->setId(_incdtid);
_alarms->setId(_incdtid);
_project->setId(incidentpopulate.value("incdt_prj_id").toInt());
_public->setChecked(incidentpopulate.value("incdt_public").toBool());
_docType->setText(incidentpopulate.value("docType").toString());
_docNumber->setText(incidentpopulate.value("docNumber").toString());
_aropenid = incidentpopulate.value("docId").toInt();
_ardoctype = incidentpopulate.value("aropen_doctype").toString();
if (_aropenid > 0)
_viewAR->setEnabled(true);
_recurring->setParent(incidentpopulate.value("incdt_recurring_incdt_id").isNull() ?
_incdtid : incidentpopulate.value("incdt_recurring_incdt_id").toInt(),
"INCDT");
sFillHistoryList();
sFillTodoList();
emit populated();
}
}
void incident::populate()
{
q.prepare("SELECT incdt_number,"
" incdt_crmacct_id,"
" COALESCE(incdt_cntct_id,-1) AS incdt_cntct_id,"
" (cntct_first_name || ' ' || cntct_last_name) AS cntct_name,"
" incdt_summary, incdt_descrip,"
" incdt_item_id, incdt_ls_id,"
" incdt_status, incdt_assigned_username,"
" incdt_incdtcat_id, incdt_incdtseverity_id,"
" incdt_incdtpriority_id, incdt_incdtresolution_id, incdt_owner_username, "
" COALESCE(incdt_aropen_id, -1) AS docId,"
" COALESCE(aropen_docnumber, '') AS docNumber,"
" CASE WHEN (aropen_doctype='C') THEN :creditMemo"
" WHEN (aropen_doctype='D') THEN :debitMemo"
" WHEN (aropen_doctype='I') THEN :invoice"
" WHEN (aropen_doctype='R') THEN :cashdeposit"
" ELSE ''"
" END AS docType "
"FROM incdt LEFT OUTER JOIN cntct ON (incdt_cntct_id=cntct_id)"
" LEFT OUTER JOIN aropen ON (incdt_aropen_id=aropen_id) "
"WHERE (incdt_id=:incdt_id); ");
q.bindValue(":incdt_id", _incdtid);
q.bindValue(":creditMemo", tr("C/M"));
q.bindValue(":debitMemo", tr("D/M"));
q.bindValue(":invoice", tr("Invoice"));
q.bindValue(":cashdeposit", tr("C/D"));
q.exec();
if(q.first())
{
_crmacct->setId(q.value("incdt_crmacct_id").toInt());
_cntct->setId(q.value("incdt_cntct_id").toInt());
_owner->setUsername(q.value("incdt_owner_username").toString());
_number->setText(q.value("incdt_number").toString());
_assignedTo->setUsername(q.value("incdt_assigned_username").toString());
_category->setNull();
if(!q.value("incdt_incdtcat_id").toString().isEmpty())
_category->setId(q.value("incdt_incdtcat_id").toInt());
_status->setCurrentIndex(_statusCodes.indexOf(q.value("incdt_status").toString()));
_statusCache=_status->currentIndex();
_severity->setNull();
if(!q.value("incdt_incdtseverity_id").toString().isEmpty())
_severity->setId(q.value("incdt_incdtseverity_id").toInt());
_priority->setNull();
if(!q.value("incdt_incdtpriority_id").toString().isEmpty())
_priority->setId(q.value("incdt_incdtpriority_id").toInt());
_resolution->setNull();
if(!q.value("incdt_incdtresolution_id").toString().isEmpty())
_resolution->setId(q.value("incdt_incdtresolution_id").toInt());
if(!q.value("incdt_item_id").toString().isEmpty())
_item->setId(q.value("incdt_item_id").toInt());
else
_item->setId(-1);
if(!q.value("incdt_ls_id").toString().isEmpty())
_lotserial->setId(q.value("incdt_ls_id").toInt());
else
_lotserial->setId(-1);
_description->setText(q.value("incdt_summary").toString());
_notes->setText(q.value("incdt_descrip").toString());
_comments->setId(_incdtid);
_documents->setId(_incdtid);
_alarms->setId(_incdtid);
_docType->setText(q.value("docType").toString());
_docNumber->setText(q.value("docNumber").toString());
_aropenid = q.value("docId").toInt();
if (_aropenid > 0)
_viewAR->setEnabled(true);
sFillHistoryList();
sFillTodoList();
_updated=false;
}
}
