void incident::sDeleteCharacteristic() { q.prepare( "DELETE FROM charass " "WHERE (charass_id=:charass_id);" ); q.bindValue(":charass_id", _charass->id()); q.exec(); sFillCharacteristicsList(); }
void incident::sEditCharacteristic() { ParameterList params; params.append("mode", "edit"); params.append("charass_id", _charass->id()); characteristicAssignment newdlg(this, "", TRUE); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillCharacteristicsList(); }
void incident::sNewCharacteristic() { ParameterList params; params.append("mode", "new"); params.append("incdt_id", _incdtid); characteristicAssignment newdlg(this, "", TRUE); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillCharacteristicsList(); }
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); _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"); sFillCharacteristicsList(); sFillHistoryList(); sFillTodoList(); emit populated(); } }