void opportunity::populate()
{
q.prepare("SELECT ophead_name,"
" ophead_crmacct_id,"
" ophead_owner_username,"
" ophead_opstage_id, ophead_opsource_id,"
" ophead_optype_id,"
" ophead_probability_prcnt, ophead_amount,"
" COALESCE(ophead_curr_id, basecurrid()) AS curr_id,"
" ophead_target_date, ophead_actual_date,"
" ophead_notes"
" FROM ophead"
" WHERE(ophead_id=:ophead_id); ");
q.bindValue(":ophead_id", _opheadid);
q.exec();
if(q.first())
{
_name->setText(q.value("ophead_name").toString());
_crmacct->setId(q.value("ophead_crmacct_id").toInt());
_owner->setUsername(q.value("ophead_owner_username").toString());
_oppstage->setNull();
if(!q.value("ophead_opstage_id").toString().isEmpty())
_oppstage->setId(q.value("ophead_opstage_id").toInt());
_oppsource->setNull();
if(!q.value("ophead_opsource_id").toString().isEmpty())
_oppsource->setId(q.value("ophead_opsource_id").toInt());
_opptype->setNull();
if(!q.value("ophead_optype_id").toString().isEmpty())
_opptype->setId(q.value("ophead_optype_id").toInt());
_probability->clear();
if(!q.value("ophead_probability_prcnt").toString().isEmpty())
_probability->setText(q.value("ophead_probability_prcnt").toDouble());
_amount->clear();
_amount->setId(q.value("curr_id").toInt());
if(!q.value("ophead_amount").toString().isEmpty())
_amount->setLocalValue(q.value("ophead_amount").toDouble());
_targetDate->clear();
if(!q.value("ophead_target_date").toString().isEmpty())
_targetDate->setDate(q.value("ophead_target_date").toDate());
_actualDate->clear();
if(!q.value("ophead_actual_date").toString().isEmpty())
_actualDate->setDate(q.value("ophead_actual_date").toDate());
_notes->setText(q.value("ophead_notes").toString());
_comments->setId(_opheadid);
sFillTodoList();
sFillCharList();
}
}
void opportunity::sDeleteCharacteristic()
{
q.prepare( "DELETE FROM charass "
"WHERE (charass_id=:charass_id);" );
q.bindValue(":charass_id", _charass->id());
q.exec();
sFillCharList();
}
void opportunity::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)
sFillCharList();
}
void opportunity::sNewCharacteristic()
{
if (! save(true))
return;
ParameterList params;
params.append("mode", "new");
params.append("ophead_id", _opheadid);
characteristicAssignment newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillCharList();
}
