void financialLayoutSpecial::populate()
{
XSqlQuery financialpopulate;
financialpopulate.prepare( "SELECT * "
"FROM flspec "
"WHERE (flspec_id=:flspec_id);" );
financialpopulate.bindValue(":flspec_id", _flspecid);
financialpopulate.exec();
if (financialpopulate.first())
{
_name->setText(financialpopulate.value("flspec_name").toString());
_showBeginning->setChecked(financialpopulate.value("flspec_showstart").toBool());
_showEnding->setChecked(financialpopulate.value("flspec_showend").toBool());
_showDB->setChecked(financialpopulate.value("flspec_showdelta").toBool());
_showBudget->setChecked(financialpopulate.value("flspec_showbudget").toBool());
_showDiff->setChecked(financialpopulate.value("flspec_showdiff").toBool());
_showCustom->setChecked(financialpopulate.value("flspec_showcustom").toBool());
_showBeginningPrcnt->setChecked(financialpopulate.value("flspec_showstartprcnt").toBool());
_showEndingPrcnt->setChecked(financialpopulate.value("flspec_showendprcnt").toBool());
_showDBPrcnt->setChecked(financialpopulate.value("flspec_showdeltaprcnt").toBool());
_showBudgetPrcnt->setChecked(financialpopulate.value("flspec_showbudgetprcnt").toBool());
_showDiffPrcnt->setChecked(financialpopulate.value("flspec_showdiffprcnt").toBool());
_showCustomPrcnt->setChecked(financialpopulate.value("flspec_showcustomprcnt").toBool());
QString src = financialpopulate.value("flspec_custom_source").toString();
if("S" == src)
_customUseBeginning->setChecked(true);
else if("E" == src)
_customUseEnding->setChecked(true);
else if("D" == src)
_customUseDebits->setChecked(true);
else if("C" == src)
_customUseCredits->setChecked(true);
else if("B" == src)
_customUseBudget->setChecked(true);
else if("F" == src)
_customUseDiff->setChecked(true);
if(financialpopulate.value("flspec_subtract").toBool())
_subtract->setChecked(true);
else
_add->setChecked(true);
if(financialpopulate.value("flspec_type").toString() == "OpenAP")
_type->setCurrentIndex(1);
else //if(financialpopulate.value("flspec_type").toString() == "OpenAR")
_type->setCurrentIndex(0);
_flheadid = financialpopulate.value("flspec_flhead_id").toInt();
int grpid = financialpopulate.value("flspec_prcnt_flgrp_id").toInt();
sFillGroupList();
_group->setId(grpid);
}
}
void financialLayoutGroup::populate()
{
XSqlQuery financialpopulate;
financialpopulate.prepare( "SELECT flgrp_name, flgrp_descrip, flgrp_subtotal,"
" flgrp_summarize, flgrp_subtract,"
" flgrp_showstart, flgrp_showend,"
" flgrp_showdelta, flgrp_showbudget, flgrp_showdiff, flgrp_showcustom,"
" flgrp_showstartprcnt, flgrp_showendprcnt,"
" flgrp_showdeltaprcnt, flgrp_showbudgetprcnt, flgrp_showdiffprcnt, flgrp_showcustomprcnt,"
" flgrp_flhead_id, flgrp_prcnt_flgrp_id, flgrp_usealtsubtotal, flgrp_altsubtotal "
"FROM flgrp "
"WHERE (flgrp_id=:flgrp_id);" );
financialpopulate.bindValue(":flgrp_id", _flgrpid);
financialpopulate.exec();
if (financialpopulate.first())
{
_flheadid = financialpopulate.value("flgrp_flhead_id").toInt();
_name->setText(financialpopulate.value("flgrp_name").toString());
_description->setText(financialpopulate.value("flgrp_descrip").toString());
_showSubtotal->setChecked(financialpopulate.value("flgrp_subtotal").toBool());
_summarize->setChecked(financialpopulate.value("flgrp_summarize").toBool());
_altSubtotal->setChecked(financialpopulate.value("flgrp_usealtsubtotal").toBool());
_altSubtotalLabel->setText(financialpopulate.value("flgrp_altsubtotal").toString());
if(_summarize->isChecked() || _showSubtotal->isChecked())
{
_showStart->setChecked(financialpopulate.value("flgrp_showstart").toBool());
_showEnd->setChecked(financialpopulate.value("flgrp_showend").toBool());
_showDelta->setChecked(financialpopulate.value("flgrp_showdelta").toBool());
_showBudget->setChecked(financialpopulate.value("flgrp_showbudget").toBool());
_showDiff->setChecked(financialpopulate.value("flgrp_showdiff").toBool());
_showCustom->setChecked(financialpopulate.value("flgrp_showcustom").toBool());
_showStartPrcnt->setChecked(financialpopulate.value("flgrp_showstartprcnt").toBool());
_showEndPrcnt->setChecked(financialpopulate.value("flgrp_showendprcnt").toBool());
_showDeltaPrcnt->setChecked(financialpopulate.value("flgrp_showdeltaprcnt").toBool());
_showBudgetPrcnt->setChecked(financialpopulate.value("flgrp_showbudgetprcnt").toBool());
_showDiffPrcnt->setChecked(financialpopulate.value("flgrp_showdiffprcnt").toBool());
_showCustomPrcnt->setChecked(financialpopulate.value("flgrp_showcustomprcnt").toBool());
}
if(financialpopulate.value("flgrp_subtract").toBool())
_subtract->setChecked(true);
else
_add->setChecked(true);
if ((_rpttype != cAdHoc) && ((_showEndPrcnt->isChecked()) || (_showDiffPrcnt->isChecked())))
_showPrcnt->setChecked(true);
int grpid = financialpopulate.value("flgrp_prcnt_flgrp_id").toInt();
sFillGroupList();
_group->setId(grpid);
}
}
enum SetResponse financialLayoutSpecial::set(const ParameterList &pParams)
{
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("flhead_id", &valid);
if (valid)
{
_flheadid = param.toInt();
sFillGroupList();
}
param = pParams.value("flgrp_id", &valid);
if (valid)
_flgrpid = param.toInt();
param = pParams.value("flspec_id", &valid);
if (valid)
{
_flspecid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
}
else if (param.toString() == "edit")
{
_mode = cEdit;
_buttonBox->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_buttonBox->setFocus();
}
}
return NoError;
}
enum SetResponse financialLayoutGroup::set(const ParameterList &pParams)
{
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("flhead_id", &valid);
if (valid)
{
_flheadid = param.toInt();
sFillGroupList();
}
param = pParams.value("flgrp_flgrp_id", &valid);
if (valid)
_flgrp_flgrpid = param.toInt();
param = pParams.value("flgrp_id", &valid);
if (valid)
{
_flgrpid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
}
else if (param.toString() == "edit")
{
_mode = cEdit;
}
else if (param.toString() == "view")
{
_mode = cView;
_buttonBox->clear();
_buttonBox->addButton(QDialogButtonBox::Close);
_name->setEnabled(false);
_description->setEnabled(false);
_subSummGroup->setEnabled(false);
_operationGroup->setEnabled(false);
}
}
param = pParams.value("type", &valid);
if (valid)
{
if (param.toString() == "adHoc")
{
_rpttype = cAdHoc;
_showPrcnt->setHidden(true);
}
else
{
_showStart->setHidden(true);
_showEnd->setHidden(true);
_showDelta->setHidden(true);
_showBudget->setHidden(true);
_showDiff->setHidden(true);
_showCustom->setHidden(true);
_showStartPrcnt->setHidden(true);
_showEndPrcnt->setHidden(true);
_showDeltaPrcnt->setHidden(true);
_showBudgetPrcnt->setHidden(true);
_showDiffPrcnt->setHidden(true);
_showCustomPrcnt->setHidden(true);
}
if (param.toString() == "income")
{
_rpttype = cIncome;
_showPrcnt->setHidden(false);
_showStart->setChecked(false);
_showEnd->setChecked(false);
_showDelta->setChecked(false);
_showBudget->setChecked(true);
_showDiff->setChecked(true);
}
else if (param.toString() == "balance")
{
_rpttype = cBalance;
_showPrcnt->setHidden(false);
_showStart->setChecked(false);
_showEnd->setChecked(true);
_showDelta->setChecked(false);
_showBudget->setChecked(true);
_showDiff->setChecked(false);
}
else if (param.toString() == "cash")
{
_rpttype = cCash;
_showPrcnt->setHidden(false);
_showStart->setChecked(false);
_showEnd->setChecked(false);
_showDelta->setChecked(true);
_showBudget->setChecked(true);
_showDiff->setChecked(true);
}
}
return NoError;
}
void financialLayoutItem::populate()
{
q.prepare( "SELECT * "
"FROM flitem "
"LEFT OUTER JOIN subaccnttype ON flitem_subaccnttype_code=subaccnttype_code "
"WHERE (flitem_id=:flitem_id);" );
q.bindValue(":flitem_id", _flitemid);
q.exec();
if (q.first())
{
if ( q.value("flitem_accnt_id").toInt() == -1 )
{
_selectSegment->setChecked(TRUE);
if (_metrics->value("GLCompanySize").toInt())
_company->setText(q.value("flitem_company"));
if (_metrics->value("GLProfitSize").toInt())
_profit->setText(q.value("flitem_profit"));
_number->setText(q.value("flitem_number"));
if (_metrics->value("GLSubaccountSize").toInt())
_sub->setText(q.value("flitem_sub"));
if (q.value("flitem_type").toString() == "A")
_type->setCurrentIndex(0);
else if (q.value("flitem_type").toString() == "L")
_type->setCurrentIndex(1);
else if (q.value("flitem_type").toString() == "E")
_type->setCurrentIndex(2);
else if (q.value("flitem_type").toString() == "R")
_type->setCurrentIndex(3);
else if (q.value("flitem_type").toString() == "Q")
_type->setCurrentIndex(4);
else
_type->setCurrentIndex(5);
_subType->setId(q.value("subaccnttype_id").toInt());
}
else
{
_selectAccount->setChecked(TRUE);
_account->setId(q.value("flitem_accnt_id").toInt());
}
_showBeginning->setChecked(q.value("flitem_showstart").toBool());
_showEnding->setChecked(q.value("flitem_showend").toBool());
_showDB->setChecked(q.value("flitem_showdelta").toBool());
_showBudget->setChecked(q.value("flitem_showbudget").toBool());
_showDiff->setChecked(q.value("flitem_showdiff").toBool());
_showCustom->setChecked(q.value("flitem_showcustom").toBool());
_showBeginningPrcnt->setChecked(q.value("flitem_showstartprcnt").toBool());
_showEndingPrcnt->setChecked(q.value("flitem_showendprcnt").toBool());
_showDBPrcnt->setChecked(q.value("flitem_showdeltaprcnt").toBool());
_showBudgetPrcnt->setChecked(q.value("flitem_showbudgetprcnt").toBool());
_showDiffPrcnt->setChecked(q.value("flitem_showdiffprcnt").toBool());
_showCustomPrcnt->setChecked(q.value("flitem_showcustomprcnt").toBool());
if ((_rpttype != cAdHoc) & ((_showDiffPrcnt->isChecked()) || (_showEndingPrcnt->isChecked())))
_showPrcnt->setChecked(TRUE);
QString src = q.value("flitem_custom_source").toString();
if("S" == src)
_customUseBeginning->setChecked(TRUE);
else if("E" == src)
_customUseEnding->setChecked(TRUE);
else if("D" == src)
_customUseDebits->setChecked(TRUE);
else if("C" == src)
_customUseCredits->setChecked(TRUE);
else if("B" == src)
_customUseBudget->setChecked(TRUE);
else if("F" == src)
_customUseDiff->setChecked(TRUE);
if(q.value("flitem_subtract").toBool())
_subtract->setChecked(TRUE);
else
_add->setChecked(TRUE);
_flheadid = q.value("flitem_flhead_id").toInt();
int grpid = q.value("flitem_prcnt_flgrp_id").toInt();
sFillGroupList();
_group->setId(grpid);
sToggleShowPrcnt();
}
}
enum SetResponse financialLayoutItem::set(const ParameterList &pParams)
{
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("flhead_id", &valid);
if (valid)
{
_flheadid = param.toInt();
sFillGroupList();
}
param = pParams.value("flgrp_id", &valid);
if (valid)
_flgrpid = param.toInt();
param = pParams.value("flitem_id", &valid);
if (valid)
{
_flitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
}
else if (param.toString() == "edit")
{
_mode = cEdit;
_buttonBox->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_buttonBox->clear();
_buttonBox->addButton(QDialogButtonBox::Close);
_buttonBox->setFocus();
_selectAccount->setEnabled(FALSE);
_selectSegment->setEnabled(FALSE);
_operationGroup->setEnabled(FALSE);
_showColumns->setEnabled(FALSE);
_showPrcnt->setEnabled(FALSE);
_group->setEnabled(FALSE);
_showCustom->setEnabled(FALSE);
_buttonBox->setFocus();
}
}
param = pParams.value("type", &valid);
if (valid)
{
if (param.toString() == "adHoc")
{
_rpttype = cAdHoc;
_showPrcnt->setHidden(TRUE);
}
else
{
_showColumns->setHidden(TRUE);
_showCustom->setHidden(TRUE);
}
if (param.toString() == "income")
{
_rpttype = cIncome;
_showBeginning->setChecked(FALSE);
_showEnding->setChecked(FALSE);
_showDB->setChecked(FALSE);
_showBudget->setChecked(TRUE);
_showDiff->setChecked(TRUE);
_showCustom->setChecked(FALSE);
}
else if (param.toString() == "balance")
{
_rpttype = cBalance;
_showBeginning->setChecked(FALSE);
_showEnding->setChecked(TRUE);
_showDB->setChecked(FALSE);
_showBudget->setChecked(TRUE);
_showDiff->setChecked(TRUE);
_showCustom->setChecked(FALSE);
}
else if (param.toString() == "cash")
{
_rpttype = cCash;
_showBeginning->setChecked(FALSE);
_showEnding->setChecked(FALSE);
_showDB->setChecked(TRUE);
_showBudget->setChecked(TRUE);
_showDiff->setChecked(TRUE);
_showCustom->setChecked(FALSE);
}
}
return NoError;
}
