reprintCreditMemos::reprintCreditMemos(QWidget *parent,
const char *name,
bool modal,
Qt::WFlags fl)
: reprintMulticopyDocument("CreditMemoCopies", "CreditMemoWatermark",
"CreditMemoShowPrices", parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
list()->addColumn(tr("C/M #"), _orderColumn, Qt::AlignRight, true, "docnumber");
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "cmhead_docdate");
list()->addColumn(tr("Cust. #"), -1, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Report"), -1, Qt::AlignLeft, false, "reportname");
_docListQueryString = "SELECT cmhead_id, cust_id,"
" cmhead_number AS docnumber, cmhead_docdate,"
" cust_number, cust_name,"
" findCustomerForm(cust_id, 'C') AS reportname"
" FROM cmhead"
" JOIN custinfo ON (cmhead_cust_id=cust_id)"
" WHERE checkCreditMemoSitePrivs(cmhead_id)"
" ORDER BY cmhead_docdate DESC;" ;
setDoctype("CM");
setReportKey("cmhead_id");
sPopulate();
}
printPurchaseOrder::printPurchaseOrder(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("POCopies", "POWatermark",
"POShowPrices", "",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("PO");
setReportKey("pohead_id");
_docinfoQueryString =
"SELECT pohead_id AS docid, pohead_id,"
" pohead_number AS docnumber,"
" pohead_printed AS printed,"
" false AS posted,"
" 'PurchaseOrder' AS reportname,"
" pohead_saved"
" FROM pohead"
" WHERE (pohead_id=<? value('docid') ?>);" ;
_markOnePrintedQry = "UPDATE pohead"
" SET pohead_printed=TRUE "
" WHERE (pohead_id=<? value('docid') ?>);" ;
connect(_po, SIGNAL(newId(int, QString)), this, SLOT(setId(int)));
connect(this, SIGNAL(docUpdated(int)), this, SLOT(sHandleDocUpdated(int)));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sHandlePopulated(XSqlQuery*)));
}
reprintInvoices::reprintInvoices(QWidget *parent,
const char *name,
bool modal,
Qt::WFlags fl)
: reprintMulticopyDocument("InvoiceCopies", "InvoiceWatermark",
"InvoiceShowPrices",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
list()->addColumn(tr("Invoice #"), _orderColumn, Qt::AlignRight, true, "docnumber");
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "invchead_invcdate");
list()->addColumn(tr("Cust. #"), -1, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Total Amount"),_bigMoneyColumn, Qt::AlignRight, true, "extprice" );
list()->addColumn(tr("Balance"), _bigMoneyColumn, Qt::AlignRight, true, "balance" );
list()->addColumn(tr("Report"), -1, Qt::AlignLeft, false,"reportname");
QString errmsg;
bool ok = false;
MetaSQLQuery mql = MQLUtil::mqlLoad("invoices", "detail", errmsg, &ok);
if (! ok)
ErrorReporter::error(QtCriticalMsg, this, tr("Error Getting Invoices"),
errmsg, __FILE__, __LINE__);
setDoctype("IN");
setReportKey("invchead_id");
_docListQueryString = mql.getSource();
}
printQuote::printQuote(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("QT");
setReportKey("quhead_id");
_docinfoQueryString = "SELECT quhead_id AS docid, quhead_id,"
" quhead_number AS docnumber,"
" false AS printed,"
"<? if exists('reportname') ?>"
" <? value('reportname') ?>"
"<? else ?>"
" findCustomerForm(quhead_cust_id, 'Q')"
" <? endif ?> AS reportname"
" FROM quhead"
" WHERE (quhead_id=<? value('docid') ?>);" ;
connect(_quote, SIGNAL(newId(int)), this, SLOT(sHandleNewQuoteId()));
connect(_report, SIGNAL(newID(int)), this, SLOT(sHandleButtons()));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sFinishedWithAll()));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sPopulate(XSqlQuery*)));
}
printPoForm::printPoForm(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("PO");
setReportKey("pohead_id");
_docinfoQueryString = "SELECT pohead_id AS docid, pohead_id,"
" pohead_number AS docnumber,"
" pohead_printed AS printed,"
"<? if exists('reportname') ?>"
" (SELECT form_report_name"
" FROM form"
" WHERE ((form_name=<? value('reportname') ?>)"
" AND (form_key='PO')))"
"<? else ?>"
" COALESCE((SELECT MIN(form_report_name)"
" FROM form WHERE (form_key='PO')),"
" 'PurchaseOrder')"
"<? endif ?> AS reportname"
" FROM pohead"
" WHERE (pohead_id=<? value('docid') ?>);" ;
_report->populate( "SELECT form_id, form_name, form_name "
"FROM form "
"WHERE (form_key='PO') "
"ORDER BY form_name;" );
connect(_po, SIGNAL(newId(int, QString)), this, SLOT(sHandleNewOrderId()));
connect(_report, SIGNAL(newID(int)), this, SLOT(sHandleButtons()));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sFinishedWithAll()));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sPopulate(XSqlQuery*)));
}
printInvoices::printInvoices(QWidget *parent, const char *name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("InvoiceCopies", "InvoiceWatermark",
"InvoiceShowPrices", "PostMiscInvoices",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("IN");
setReportKey("invchead_id");
_distributeInventory = true;
_shipvia->populate( "SELECT MIN(invchead_id), invchead_shipvia "
" FROM invchead "
" WHERE ( (NOT invchead_printed)"
" AND (NOT invchead_posted) )"
" GROUP BY invchead_shipvia"
" ORDER BY invchead_shipvia;" );
QString errmsg;
bool ok = false;
MetaSQLQuery mql = MQLUtil::mqlLoad("invoices", "print", errmsg, &ok);
if (ok)
_docinfoQueryString = mql.getSource();
else
ErrorReporter::error(QtCriticalMsg, this, tr("Getting Invoices to Print"),
errmsg, __FILE__, __LINE__);
_markAllPrintedQry = "UPDATE invchead"
" SET invchead_printed=TRUE "
" WHERE invchead_id IN ("
"<? foreach('printedDocs') ?>"
" <? if not isfirst('printedDocs') ?>, <? endif ?>"
" <? value('printedDocs') ?>"
"<? endforeach ?>"
");" ;
_postFunction = "postInvoice";
_postQuery = "SELECT postInvoice(<? value('docid') ?>) AS result;" ;
_askBeforePostingQry = "SELECT invoiceTotal(<? value('docid') ?>) = 0 AS ask;" ;
_askBeforePostingMsg = tr("<p>Invoice %1 has a total value of 0.<br/>"
"Would you like to post it anyway?</p>");
_errCheckBeforePostingQry =
"SELECT EXISTS(SELECT *"
" FROM curr_rate, invchead "
" WHERE ((curr_id=invchead_curr_id)"
" AND (invchead_invcdate BETWEEN curr_effective AND curr_expires)"
" AND (invchead_id=<? value('docid') ?>))) AS ok;" ;
_errCheckBeforePostingMsg =
tr("Could not post Invoice %1 because of a missing exchange rate.");
connect(this, SIGNAL(aboutToStart(XSqlQuery*)), this, SLOT(sHandleAboutToStart(XSqlQuery*)));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sHandleFinishedWithAll()));
}
printShippingForms::printShippingForms(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("ShippingFormCopies", "ShippingFormWatermark",
"ShippingFormShowPrices", "",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("P");
setReportKey("shiphead_id");
_distributeInventory = false;
if (_preferences->boolean("XCheckBox/forgetful"))
{
_printNew->setChecked(true);
_printDirty->setChecked(true);
}
// TODO: tohead?
_docinfoQueryString =
"SELECT shiphead_id AS docid,"
" shiphead_number AS docnumber,"
" (shiphead_sfstatus = 'P') AS printed,"
" NULL AS posted,"
" shipform_report_name AS reportname,"
" shiphead_id, shiphead_shipchrg_id"
" FROM shiphead"
" JOIN cohead ON (shiphead_order_id=cohead_id"
" AND shiphead_order_type='SO')"
" JOIN shipform ON (shipform_id=COALESCE(shiphead_shipform_id,"
" cohead_shipform_id))"
" WHERE NOT shiphead_shipped"
"<? if exists('printFlags') ?>"
" AND (shiphead_sfstatus IN ("
" <? foreach('printFlags') ?>"
" <? if not isfirst('printFlags') ?> , <? endif ?>"
" <? value('printFlags') ?>"
" <? endforeach ?>"
" ))"
"<? endif ?>"
" ORDER BY shiphead_id;" ;
_markOnePrintedQry = "UPDATE shiphead"
" SET shiphead_sfstatus='P'"
" WHERE (shiphead_id=<? value('docid') ?>);" ;
}
printApOpenItem::printApOpenItem(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
_docinfoQueryString = "SELECT apopen_id AS docid, apopen_id,"
" apopen_docnumber AS docnumber,"
" false AS printed,"
" 'APOpenItem' AS reportname,"
" apopen_doctype"
" FROM apopen"
" WHERE (apopen_id=<? value('docid') ?>);" ;
setReportKey("apopen_id");
connect(_apopen, SIGNAL(valid(bool)), this, SLOT(setPrintEnabled(bool)));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sPopulate(XSqlQuery*)));
}
printCreditMemos::printCreditMemos(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("CreditMemoCopies", "CreditMemoWatermark",
"CreditMemoShowPrices", "PostARDocuments",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("CM");
setReportKey("cmhead_id");
_distributeInventory = true;
_docinfoQueryString =
"SELECT cmhead_id AS docid,"
" cmhead_number AS docnumber,"
" cmhead_printed AS printed,"
" cmhead_posted AS posted,"
" cmhead_cust_id,"
" findCustomerForm(cmhead_cust_id, 'C') AS reportname"
" FROM cmhead "
" WHERE (NOT cmhead_hold"
" AND NOT COALESCE(cmhead_printed, false)"
" AND checkCreditMemoSitePrivs(cmhead_id));" ;
_markAllPrintedQry = "UPDATE cmhead"
" SET cmhead_printed=TRUE "
" WHERE cmhead_id IN ("
"<? foreach('printedDocs') ?>"
" <? if not isfirst('printedDocs') ?>, <? endif ?>"
" <? value('printedDocs') ?>"
"<? endforeach ?>"
");" ;
_postFunction = "postCreditMemo";
_postQuery = "SELECT postCreditMemo(<? value('docid') ?>, 0) AS result;" ;
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sHandleFinishedWithAll()));
}
printStatementsByCustomerType::printStatementsByCustomerType(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
_asOf->setDate(omfgThis->dbDate(), true);
_customerTypes->setType(ParameterGroup::CustomerType);
if (_preferences->boolean("XCheckBox/forgetful"))
_dueonly->setChecked(true);
setPrintEnabled(true);
setDoctype("AR");
setReportKey("cust_id");
bool ok = false;
QString msg;
MetaSQLQuery custm = MQLUtil::mqlLoad("customers", "statement", msg, &ok);
if (ok)
_docinfoQueryString = custm.getSource();
else
ErrorReporter::error(QtCriticalMsg, this, tr("Getting Customers to Print"),
msg, __FILE__, __LINE__);
}
