task::task(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_save, SIGNAL(clicked()), this, SLOT(sSave()));
connect(_actualExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_budgetExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_actualHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
connect(_budgetHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
_budgetHours->setValidator(omfgThis->qtyVal());
_actualHours->setValidator(omfgThis->qtyVal());
_budgetExp->setValidator(omfgThis->qtyVal());
_actualExp->setValidator(omfgThis->qtyVal());
_balanceHours->setPrecision(omfgThis->qtyVal());
_balanceExp->setPrecision(omfgThis->qtyVal());
//_usr->addColumn( tr("Username"),_itemColumn, AlignLeft, true, "usr_username");
//_usr->addColumn( tr("Proper Name"), -1, AlignLeft, true, "usr_propername");
_prjid = -1;
_prjtaskid = -1;
adjustSize();
}
/*
* Constructs a task as a child of 'parent', with the
* name 'name' and widget flags set to 'f'.
*
* The dialog will by default be modeless, unless you set 'modal' to
* true to construct a modal dialog.
*/
task::task(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
// signals and slots connections
connect(_close, SIGNAL(clicked()), this, SLOT(reject()));
connect(_save, SIGNAL(clicked()), this, SLOT(sSave()));
connect(_actualExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_budgetExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_actualHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
connect(_budgetHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
init();
}
void task::populate()
{
q.prepare( "SELECT prjtask.* "
"FROM prjtask "
"WHERE (prjtask_id=:prjtask_id);" );
q.bindValue(":prjtask_id", _prjtaskid);
q.exec();
if (q.first())
{
_number->setText(q.value("prjtask_number"));
_name->setText(q.value("prjtask_name"));
_descrip->setText(q.value("prjtask_descrip").toString());
_owner->setUsername(q.value("prjtask_owner_username").toString());
_assignedTo->setUsername(q.value("prjtask_username").toString());
_started->setDate(q.value("prjtask_start_date").toDate());
_assigned->setDate(q.value("prjtask_assigned_date").toDate());
_due->setDate(q.value("prjtask_due_date").toDate());
_completed->setDate(q.value("prjtask_completed_date").toDate());
QString status = q.value("prjtask_status").toString();
if("P" == status)
_status->setCurrentIndex(0);
else if("O" == status)
_status->setCurrentIndex(1);
else if("C" == status)
_status->setCurrentIndex(2);
_budgetHours->setText(formatQty(q.value("prjtask_hours_budget").toDouble()));
_actualHours->setText(formatQty(q.value("prjtask_hours_actual").toDouble()));
_budgetExp->setText(formatCost(q.value("prjtask_exp_budget").toDouble()));
_actualExp->setText(formatCost(q.value("prjtask_exp_actual").toDouble()));
_alarms->setId(_prjtaskid);
_comments->setId(_prjtaskid);
sHoursAdjusted();
sExpensesAdjusted();
//if (q.value("prjtask_anyuser").toBool())
// _anyUser->setChecked(TRUE);
//else
// _userList->setChecked(TRUE);
}
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
//sFillUserList();
}
task::task(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_buttonBox, SIGNAL(accepted()), this, SLOT(sSave()));
connect(_actualExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_budgetExp, SIGNAL(lostFocus()), this, SLOT(sExpensesAdjusted()));
connect(_actualHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
connect(_budgetHours, SIGNAL(lostFocus()), this, SLOT(sHoursAdjusted()));
_budgetHours->setValidator(omfgThis->qtyVal());
_actualHours->setValidator(omfgThis->qtyVal());
_budgetExp->setValidator(omfgThis->costVal());
_actualExp->setValidator(omfgThis->costVal());
_balanceHours->setPrecision(omfgThis->qtyVal());
_balanceExp->setPrecision(omfgThis->costVal());
_prjid = -1;
_prjtaskid = -1;
_owner->setType(UsernameLineEdit::UsersActive);
_assignedTo->setType(UsernameLineEdit::UsersActive);
}
void task::populate()
{
q.prepare( "SELECT prjtask_number, prjtask_name, prjtask_descrip, prjtask_status,"
" prjtask_hours_budget, prjtask_hours_actual,"
" prjtask_exp_budget, prjtask_exp_actual "
"FROM prjtask "
"WHERE (prjtask_id=:prjtask_id);" );
q.bindValue(":prjtask_id", _prjtaskid);
q.exec();
if (q.first())
{
_number->setText(q.value("prjtask_number"));
_name->setText(q.value("prjtask_name"));
_descrip->setText(q.value("prjtask_descrip").toString());
QString status = q.value("prjtask_status").toString();
if("P" == status)
_status->setCurrentItem(0);
else if("O" == status)
_status->setCurrentItem(1);
else if("C" == status)
_status->setCurrentItem(2);
_budgetHours->setText(formatQty(q.value("prjtask_hours_budget").toDouble()));
_actualHours->setText(formatQty(q.value("prjtask_hours_actual").toDouble()));
_budgetExp->setText(formatCost(q.value("prjtask_exp_budget").toDouble()));
_actualExp->setText(formatCost(q.value("prjtask_exp_actual").toDouble()));
sHoursAdjusted();
sExpensesAdjusted();
//if (q.value("prjtask_anyuser").toBool())
// _anyUser->setChecked(TRUE);
//else
// _userList->setChecked(TRUE);
}
//sFillUserList();
}
