Example #1
0
AropenLineEdit::AropenLineEdit(QWidget *pParent, const char *pName) :
  VirtualClusterLineEdit(pParent, "aropen", "aropen_id", "aropen_docnumber", 
          "formatmoney(aropen_amount-aropen_paid- "
          
          //Subtract amount on existing checks
          "(SELECT COALESCE(SUM(checkhead_amount),0) "
          " FROM checkhead,checkitem "
          " WHERE ((checkhead_id=checkitem_checkhead_id) "
          " AND (NOT checkhead_posted) "
          " AND (NOT checkhead_void) "
          " AND (checkitem_aropen_id=aropen_id))) "
          
          ")"
          
          , "aropen_doctype", 
          EXTRACLAUSE, pName)
{
  setAllowedDocTypes(AnyType);
  _custId       = -1;
  _standardExtraClause = EXTRACLAUSE;

  if (DEBUG)
    qDebug("%s::AropenLineEdit() _standardExtraClause = %s",
           qPrintable(objectName()), qPrintable(_standardExtraClause));

}
Example #2
0
ApopenLineEdit::ApopenLineEdit(QWidget *pParent, const char *pName) :
    VirtualClusterLineEdit(pParent, "apopen", "apopen_id", "apopen_docnumber",
                           "formatmoney(apopen_amount-apopen_paid) "
                           , "apopen_doctype",
                           EXTRACLAUSE, pName)
{
    setAllowedDocTypes(AnyType);
    _vendId       = -1;
    _standardExtraClause = EXTRACLAUSE;

    if (DEBUG)
        qDebug("%s::ApopenLineEdit() _standardExtraClause = %s",
               qPrintable(objectName()), qPrintable(_standardExtraClause));

}