Exemple #1
0
void dspInventoryHistoryByParameterList::sPopulateMenu(QMenu *pMenu, QTreeWidgetItem *pItem)
{
  int menuItem;

  menuItem = pMenu->insertItem(tr("View Transaction Information..."), this, SLOT(sViewTransInfo()), 0);
  menuItem = pMenu->insertItem(tr("Edit Transaction Information..."), this, SLOT(sEditTransInfo()), 0);

  if ( (pItem->text(3).length()) &&
       ( (pItem->text(2) == "RM") || (pItem->text(2) == "IM") ) )
  {
    QString orderNumber = _invhist->currentItem()->text(4);
    int sep1            = orderNumber.find('-');
    int sep2            = orderNumber.find('-', (sep1 + 1));
    int mainNumber      = orderNumber.mid((sep1 + 1), ((sep2 - sep1) - 1)).toInt();
    int subNumber       = orderNumber.right((orderNumber.length() - sep2) - 1).toInt();

    if ( (mainNumber) && (subNumber) )
    {
      q.prepare( "SELECT wo_id "
                 "FROM wo "
                 "WHERE ( (wo_number=:wo_number)"
                 " AND (wo_subnumber=:wo_subnumber) );" );
      q.bindValue(":wo_number", mainNumber);
      q.bindValue(":wo_subnumber", subNumber);
      q.exec();
      if (q.first())
      {
          menuItem = pMenu->insertItem(tr("View Work Order Information..."), this, SLOT(sViewWOInfo()), 0);
          if ((!_privileges->check("MaintainWorkOrders")) && (!_privileges->check("ViewWorkOrders")))
            pMenu->setItemEnabled(menuItem, FALSE);
      }
    }
  }
}
void dspInventoryHistory::sPopulateMenu(QMenu *pMenu, QTreeWidgetItem *pItem, int)
{
    XSqlQuery dspPopulateMenu;
    QAction *menuItem;

    menuItem = pMenu->addAction(tr("View Transaction Information..."), this, SLOT(sViewTransInfo()));
    menuItem = pMenu->addAction(tr("Edit Transaction Information..."), this, SLOT(sEditTransInfo()));

    if ( (pItem->text(list()->column("warehous_code")).length()) &&
            ( (pItem->text(list()->column("invhist_transtype")) == "RM") || (pItem->text(list()->column("invhist_transtype")) == "IM") ) )
    {
        QString orderNumber = list()->currentItem()->text(list()->column("orderlocation"));
        int sep1            = orderNumber.indexOf('-');
        int sep2            = orderNumber.indexOf('-', (sep1 + 1));
        int mainNumber      = orderNumber.mid((sep1 + 1), ((sep2 - sep1) - 1)).toInt();
        int subNumber       = orderNumber.right((orderNumber.length() - sep2) - 1).toInt();

        if ( (mainNumber) && (subNumber) )
        {
            dspPopulateMenu.prepare( "SELECT wo_id "
                                     "FROM wo "
                                     "WHERE ( (wo_number=:wo_number)"
                                     " AND (wo_subnumber=:wo_subnumber) );" );
            dspPopulateMenu.bindValue(":wo_number", mainNumber);
            dspPopulateMenu.bindValue(":wo_subnumber", subNumber);
            dspPopulateMenu.exec();
            if (dspPopulateMenu.first())
            {
                menuItem = pMenu->addAction(tr("View Work Order Information..."), this, SLOT(sViewWOInfo()));
                menuItem->setEnabled(_privileges->check("MaintainWorkOrders") || _privileges->check("ViewWorkOrders"));
            }
        }
    }
}