ListView*
ReportList::findModule(const QString& name)
{
// Check if already exists
for (unsigned int i = 0; i < _views.size(); ++i) {
if (_views[i]->name() == name)
return _views[i];
}
// Add to modules list
if (_module->lastItem() == NULL) {
ListViewItem* item = new ListViewItem(_module);
item->setText(0, name);
} else {
ListViewItem* last = (ListViewItem*)_module->lastItem();
ListViewItem* item = new ListViewItem(_module, last);
item->setText(0, name);
}
// Create new ListView
ListView* list = new ListView(_stack, name);
list->setAllColumnsShowFocus(true);
list->setShowSortIndicator(true);
connect(list, SIGNAL(doubleClicked(QListViewItem*)), SLOT(slotView()));
// Set columns depending on whether its the all tab or not
if (name == tr("All")) {
list->addTextColumn(tr("Name"), 60);
list->addTextColumn(tr("Module"), 17);
} else {
list->addTextColumn(tr("Name"), 80);
}
list->setSorting(0);
_views.push_back(list);
_stack->addWidget(list);
return list;
}
void
CashReconcile::slotReconcile()
{
if (_lines->selectedItem() == NULL) {
QString message;
if (_company.shiftMethod() == Company::BY_STATION) {
message = tr("A station must be picked");
} else {
message = tr("An employee must be picked");
}
QMessageBox::critical(this, tr("Error"), message);
return;
}
Id station_id = stationId();
Id employee_id = employeeId();
Id store_id = _store->getId();
Id safe_store_id = _safeStore->getId();
Id safe_id = _safeId->getId();
Id adjust_id = _adjust->getId();
Id transfer_id = _transfer->getId();
Id safe_station_id;
Id safe_employee_id;
if (_company.shiftMethod() == Company::BY_STATION)
safe_station_id = safe_id;
else
safe_employee_id = safe_id;
if (store_id == INVALID_ID) {
QString message = tr("A store must be entered");
QMessageBox::critical(this, tr("Error"), message);
_store->setFocus();
return;
}
if (safe_store_id == INVALID_ID) {
QString message = tr("A safe store must be entered");
QMessageBox::critical(this, tr("Error"), message);
_tabs->showPage(_setup);
_safeStore->setFocus();
return;
}
if (safe_id == INVALID_ID) {
QString message = tr("A safe must be entered");
QMessageBox::critical(this, tr("Error"), message);
_tabs->showPage(_setup);
_safeId->setFocus();
return;
}
if (adjust_id == INVALID_ID) {
QString message = tr("An over/short account must be entered");
QMessageBox::critical(this, tr("Error"), message);
_tabs->showPage(_setup);
_adjust->setFocus();
return;
}
if (transfer_id == INVALID_ID) {
QString message = tr("A transfer account must be entered");
QMessageBox::critical(this, tr("Error"), message);
_tabs->showPage(_setup);
_transfer->setFocus();
return;
}
if (_shifts.size() == 0) {
QString message = tr("You must have at least one shift");
QMessageBox::critical(this, tr("Error"), message);
return;
}
QDate date = _date->getDate();
if (date.isNull()) {
QString message = tr("The date to reconcile is required");
QMessageBox::critical(this, tr("Error"), message);
_date->setFocus();
return;
}
// Posting time is current time if closing for today or 11:59:59 PM
QTime time = QTime::currentTime();
if (date != QDate::currentDate())
time = QTime(23, 59, 59);
vector<Shift> shifts = _shifts;
vector<TenderCount> counts = _counts;
if (shifts.size() > 1 || counts.size() > 1) {
// TODO: ask which shifts/counts to use
}
QApplication::setOverrideCursor(waitCursor);
qApp->processEvents();
Id shift_id = shifts[0].id();
_tenders.clear();
_summary.clear();
// Process shifts and add tenders to summary
unsigned int i;
for (i = 0; i < shifts.size(); ++i) {
const Shift& shift = shifts[i];
GltxSelect conditions;
conditions.shift_id = shift.id();
conditions.activeOnly = true;
vector<Gltx> gltxs;
_quasar->db()->select(gltxs, conditions);
for (unsigned int j = 0; j < gltxs.size(); ++j) {
const Gltx& gltx = gltxs[j];
for (unsigned int k = 0; k < gltx.tenders().size(); ++k) {
Id tender_id = gltx.tenders()[k].tender_id;
fixed amount = gltx.tenders()[k].conv_amt;
if (gltx.tenders()[k].voided) continue;
addShiftAmt(tender_id, amount);
}
}
}
// Process counts and add tenders to summary
for (i = 0; i < counts.size(); ++i) {
const TenderCount& count = counts[i];
for (unsigned int j = 0; j < count.tenders().size(); ++j) {
const TenderInfo& info = count.tenders()[j];
addCountAmt(info.tender_id, info.amount);
}
}
// Sort tenders by menu number
std::sort(_summary.begin(), _summary.end());
// Prepare over/short transaction
TenderAdjust adjustment;
adjustment.setPostDate(date);
adjustment.setPostTime(time);
adjustment.setMemo(tr("Over/Short"));
adjustment.setStoreId(store_id);
adjustment.setStationId(station_id);
adjustment.setEmployeeId(employee_id);
adjustment.setShiftId(shift_id);
adjustment.setAccountId(adjust_id);
// Prepare transfer out transaction
TenderAdjust transOut;
transOut.setPostDate(date);
transOut.setPostTime(time);
transOut.setMemo(tr("Deposit to safe"));
transOut.setStoreId(store_id);
transOut.setStationId(station_id);
transOut.setEmployeeId(employee_id);
transOut.setShiftId(shift_id);
transOut.setAccountId(transfer_id);
// Memo for transfer in depends on method
QString memo;
if (station_id != INVALID_ID) {
Station station;
_quasar->db()->lookup(station_id, station);
memo = tr("Deposit from: %1").arg(station.name());
} else {
Employee employee;
_quasar->db()->lookup(employee_id, employee);
memo = tr("Deposit from: %1").arg(employee.nameFL());
}
// Prepare transfer in transaction
TenderAdjust transIn;
transIn.setPostDate(date);
transIn.setPostTime(time);
transIn.setMemo(memo);
transIn.setStoreId(safe_store_id);
transIn.setStationId(safe_station_id);
transIn.setEmployeeId(safe_employee_id);
transIn.setAccountId(transfer_id);
// Setup screen
QDialog* dialog = new QDialog(this, "Summary", true);
dialog->setCaption(tr("Reconcile Summary"));
ListView* tenderList = new ListView(dialog);
tenderList->addTextColumn(tr("Tender"), 20);
tenderList->addMoneyColumn(tr("Shifts"));
tenderList->addMoneyColumn(tr("Counts"));
tenderList->addMoneyColumn(tr("Over/Short"));
tenderList->setAllColumnsShowFocus(true);
tenderList->setSorting(-1);
QFrame* buttons = new QFrame(dialog);
QPushButton* post = new QPushButton(tr("Reconcile"), buttons);
QPushButton* cancel = new QPushButton(tr("Cancel"), buttons);
cancel->setDefault(true);
connect(post, SIGNAL(clicked()), dialog, SLOT(accept()));
connect(cancel, SIGNAL(clicked()), dialog, SLOT(reject()));
QGridLayout* buttonGrid = new QGridLayout(buttons);
buttonGrid->setSpacing(3);
buttonGrid->setMargin(3);
buttonGrid->setColStretch(0, 1);
buttonGrid->addWidget(post, 0, 1);
buttonGrid->addWidget(cancel, 0, 2);
QGridLayout* grid = new QGridLayout(dialog);
grid->setSpacing(3);
grid->setMargin(3);
grid->setRowStretch(0, 1);
grid->setColStretch(0, 1);
grid->addWidget(tenderList, 0, 0);
grid->addWidget(buttons, 1, 0);
// Process summary info
fixed shiftsTotal = 0.0;
fixed countsTotal = 0.0;
fixed overShort = 0.0;
fixed transferAmt = 0.0;
ListViewItem* last = NULL;
for (i = 0; i < _summary.size(); ++i) {
const Tender& tender = _summary[i].tender;
fixed shiftsAmt = _summary[i].shiftsAmt;
fixed countsAmt = _summary[i].countsAmt;
fixed overShortAmt = countsAmt - shiftsAmt;
// Add to table to show to user
ListViewItem* item = new ListViewItem(tenderList, last);
last = item;
item->setValue(0, tender.name());
item->setValue(1, shiftsAmt);
item->setValue(2, countsAmt);
item->setValue(3, overShortAmt);
// Add to over/short if there is an amount
if (overShortAmt != 0.0) {
TenderLine info;
info.tender_id = tender.id();
info.conv_amt = overShortAmt;
info.conv_rate = tender.convertRate();
info.amount = overShortAmt * tender.convertRate();
info.amount.moneyRound();
info.is_change = false;
info.voided = false;
adjustment.tenders().push_back(info);
overShort += info.amount;
}
// Add counted to transfer in/out
TenderLine info;
info.tender_id = tender.id();
info.conv_amt = countsAmt;
info.conv_rate = tender.convertRate();
info.amount = countsAmt * tender.convertRate();
info.amount.moneyRound();
info.is_change = false;
info.voided = false;
transIn.tenders().push_back(info);
transferAmt += info.amount;
info.amount = -info.amount;
info.conv_amt = -info.conv_amt;
transOut.tenders().push_back(info);
shiftsTotal += shiftsAmt;
countsTotal += countsAmt;
}
// Add total line
ListViewItem* item = new ListViewItem(tenderList, last);
item->setValue(0, tr("Total"));
item->setValue(1, shiftsTotal);
item->setValue(2, countsTotal);
item->setValue(3, countsTotal - shiftsTotal);
// Show table to user and allow cancel or post
QApplication::restoreOverrideCursor();
int ch = dialog->exec();
if (ch != QDialog::Accepted) return;
// Check total over/short
if (overShort > 5.0 || overShort < -5.0) {
QString message = tr("Warning - your over/short is large.\n"
"Are you sure you mean to post this?");
int ch = QMessageBox::warning(this, tr("Post?"), message,
QMessageBox::No, QMessageBox::Yes);
if (ch != QMessageBox::Yes) return;
}
QApplication::setOverrideCursor(waitCursor);
qApp->processEvents();
// Add accounts to adjustment
adjustment.accounts().push_back(AccountLine(adjust_id, -overShort));
for (i = 0; i < adjustment.tenders().size(); ++i) {
Id tender_id = adjustment.tenders()[i].tender_id;
fixed amount = adjustment.tenders()[i].amount;
Tender tender;
findTender(tender_id, tender);
Id tender_acct = tender.accountId();
if (_company.shiftMethod() == Company::BY_STATION) {
if (adjustment.stationId() == safe_station_id)
if (tender.safeId() != INVALID_ID)
tender_acct = tender.safeId();
} else {
if (adjustment.employeeId() == safe_employee_id)
if (tender.safeId() != INVALID_ID)
tender_acct = tender.safeId();
}
adjustment.accounts().push_back(AccountLine(tender_acct, amount));
}
// Add accounts to transfer out
transOut.accounts().push_back(AccountLine(transfer_id, transferAmt));
for (i = 0; i < transOut.tenders().size(); ++i) {
Id tender_id = transOut.tenders()[i].tender_id;
fixed amount = transOut.tenders()[i].amount;
Tender tender;
findTender(tender_id, tender);
Id tender_acct = tender.accountId();
if (_company.shiftMethod() == Company::BY_STATION) {
if (transOut.stationId() == safe_station_id)
if (tender.safeId() != INVALID_ID)
tender_acct = tender.safeId();
} else {
if (transOut.employeeId() == safe_employee_id)
if (tender.safeId() != INVALID_ID)
tender_acct = tender.safeId();
}
transOut.accounts().push_back(AccountLine(tender_acct, amount));
}
// Add accounts to transfer in
transIn.accounts().push_back(AccountLine(transfer_id, -transferAmt));
for (i = 0; i < transIn.tenders().size(); ++i) {
Id tender_id = transIn.tenders()[i].tender_id;
fixed amount = transIn.tenders()[i].amount;
Tender tender;
findTender(tender_id, tender);
Id tender_acct = tender.safeId();
if (tender_acct == INVALID_ID)
tender_acct = tender.accountId();
transIn.accounts().push_back(AccountLine(tender_acct, amount));
}
// Post adjustment if any tenders
if (adjustment.tenders().size() > 0) {
QApplication::restoreOverrideCursor();
if (!_quasar->db()->create(adjustment)) {
QString message = tr("Failed creating over/short transaction");
QMessageBox::critical(this, tr("Error"), message);
return;
}
}
// Post transfers
if (!_quasar->db()->create(transOut)) {
QApplication::restoreOverrideCursor();
QString message = tr("Failed creating transfer out transaction");
QMessageBox::critical(this, tr("Error"), message);
if (adjustment.id() != INVALID_ID)
_quasar->db()->remove(adjustment);
return;
}
if (!_quasar->db()->create(transIn)) {
QApplication::restoreOverrideCursor();
QString message = tr("Failed creating transfer in transaction");
QMessageBox::critical(this, tr("Error"), message);
if (adjustment.id() != INVALID_ID)
_quasar->db()->remove(adjustment);
_quasar->db()->remove(transOut);
return;
}
// Link the transfers
_quasar->db()->linkTx(transOut.id(), transIn.id());
// Set shift in shifts
for (int cnt = shifts.size() - 1; cnt >= 0; --cnt) {
Shift shift = shifts[cnt];
shift.setShiftId(shift_id);
shift.setAdjustmentId(adjustment.id());
shift.setTransferId(transOut.id());
_quasar->db()->update(shifts[cnt], shift);
}
// Set shift in counts
for (i = 0; i < counts.size(); ++i) {
TenderCount count = counts[i];
count.setShiftId(shift_id);
_quasar->db()->update(counts[i], count);
}
Company orig, company;
_quasar->db()->lookup(orig);
company = orig;
company.setSafeStore(safe_store_id);
company.setSafeStation(safe_station_id);
company.setSafeEmployee(safe_employee_id);
company.setOverShortAccount(adjust_id);
company.setTransferAccount(transfer_id);
_quasar->db()->update(orig, company);
QApplication::restoreOverrideCursor();
slotRefresh();
}
void
TxSummary::addFrame(EmployeeInfo& info)
{
QString name = info.employee.name();
if (name.isEmpty()) name = "<Blank>";
QFrame* frame = new QFrame(_tabs);
_tabs->addTab(frame, name);
_frames.push_back(frame);
ListView* list = new ListView(frame);
list->setAllColumnsShowFocus(true);
list->setSorting(-1);
list->addTextColumn(tr(""), 12);
for (unsigned int i = 0; i < _tenders.size(); ++i) {
if (_tenderCnts[i] == 0)
continue;
list->addMoneyColumn(_tenders[i].name());
}
list->addMoneyColumn(tr("Total"));
QLabel* voidTxLabel = new QLabel(tr("Trans. Voids:"), frame);
IntegerEdit* voidTxCnt = new IntegerEdit(frame);
voidTxCnt->setLength(6, '9');
voidTxCnt->setFocusPolicy(NoFocus);
voidTxCnt->setInt(info.voidTxCnt);
QLabel* voidItemLabel = new QLabel(tr("Item Voids:"), frame);
IntegerEdit* voidItemCnt = new IntegerEdit(frame);
voidItemCnt->setLength(6, '9');
voidItemCnt->setFocusPolicy(NoFocus);
voidItemCnt->setInt(info.voidItemCnt);
QLabel* discountLabel = new QLabel(tr("Discounts:"), frame);
MoneyEdit* discountTotal = new MoneyEdit(frame);
discountTotal->setLength(8, '9');
discountTotal->setFocusPolicy(NoFocus);
discountTotal->setFixed(info.discountTotal);
QGridLayout* grid = new QGridLayout(frame);
grid->setSpacing(3);
grid->setMargin(3);
grid->setRowStretch(0, 1);
grid->setColStretch(2, 1);
grid->addMultiCellWidget(list, 0, 0, 0, 4);
grid->addWidget(voidTxLabel, 1, 0);
grid->addWidget(voidTxCnt, 1, 1);
grid->addWidget(discountLabel, 1, 3);
grid->addWidget(discountTotal, 1, 4);
grid->addWidget(voidItemLabel, 2, 0);
grid->addWidget(voidItemCnt, 2, 1);
EmployeeLine total;
total.addLine(info.sales);
total.addLine(info.returns);
total.addLine(info.payouts);
total.addLine(info.payments);
total.addLine(info.withdraws);
total.addLine(info.nosales);
total.addLine(info.others);
EmployeeLine remain;
remain.addLine(total);
remain.addLine(info.deposits);
remain.addLine(info.overShorts);
_last = NULL;
listItem(list, tr("Sales"), info.sales);
listItem(list, tr("Returns"), info.returns);
listItem(list, tr("Payouts"), info.payouts);
listItem(list, tr("Payments"), info.payments);
listItem(list, tr("Withdraws"), info.withdraws);
listItem(list, tr("Nosales"), info.nosales);
listItem(list, tr("Other"), info.others);
listItem(list, tr("Total"), total);
listItem(list, tr("Deposited"), info.deposits);
listItem(list, tr("Over/Short"), info.overShorts);
listItem(list, tr("Remain"), remain);
}
