dspInventoryLocator::dspInventoryLocator(QWidget* parent, const char*, Qt::WindowFlags fl) : display(parent, "dspInventoryLocator", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Location/Lot/Serial # Detail")); setListLabel(tr("Locations")); setReportName("LocationLotSerialNumberDetail"); setMetaSQLOptions("inventoryLocator", "detail"); setUseAltId(true); list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code"); list()->addColumn(tr("Location"), 200, Qt::AlignLeft, true, "locationname"); list()->addColumn(tr("Netable"), _orderColumn, Qt::AlignCenter,true, "netable"); list()->addColumn(tr("Usable"), _orderColumn, Qt::AlignCenter,true, "usable"); list()->addColumn(tr("Lot/Serial #"), -1, Qt::AlignLeft, true, "lotserial"); list()->addColumn(tr("Expiration"),_dateColumn, Qt::AlignCenter,true, "expiration"); list()->addColumn(tr("Warranty"), _dateColumn, Qt::AlignCenter,true, "warranty"); list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "qoh"); ParameterWidget *pw = parameterWidget(); pw->append(tr("Site"), "site", ParameterWidget::Site); pw->append(tr("Location"), "_location_name", ParameterWidget::Text); pw->append(tr("Lot/Serial"), "lot_serial", ParameterWidget::Text); setupCharacteristics("LS"); setParameterWidgetVisible(true); }
employees::employees(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "employees", fl) { setWindowTitle(tr("Employees")); setReportName("EmployeeList"); setMetaSQLOptions("employees", "detail"); setParameterWidgetVisible(true); setNewVisible(true); setSearchVisible(true); setQueryOnStartEnabled(true); parameterWidget()->append(tr("Show Inactive"), "showInactive", ParameterWidget::Exists); if (_metrics->boolean("MultiWhs")) parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site); parameterWidget()->applyDefaultFilterSet(); connect(omfgThis, SIGNAL(employeesUpdated(int)), this, SLOT(sFillList())); list()->addColumn(tr("Site"), _whsColumn, Qt::AlignLeft, true, "warehous_code"); list()->addColumn(tr("Active"), _ynColumn, Qt::AlignLeft, true, "emp_active"); list()->addColumn(tr("Code"), _itemColumn, Qt::AlignLeft, true, "emp_code"); list()->addColumn(tr("Number"), -1, Qt::AlignLeft, true, "emp_number"); list()->addColumn(tr("First"), _itemColumn, Qt::AlignLeft, true, "cntct_first_name"); list()->addColumn(tr("Last"), _itemColumn, Qt::AlignLeft, true, "cntct_last_name"); setupCharacteristics(characteristic::Employees); parameterWidget()->applyDefaultFilterSet(); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen())); if (!_privileges->check("MaintainEmployees")) newAction()->setEnabled(FALSE); }
dspBookings::dspBookings(QWidget* parent, const char*, Qt::WindowFlags fl) : display(parent, "dspBookings", fl) { setWindowTitle(tr("Bookings")); setReportName("Bookings"); setMetaSQLOptions("bookings", "detail"); setParameterWidgetVisible(true); setUseAltId(true); parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date, QDate::currentDate(), true ); parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date, QDate::currentDate(), true); parameterWidget()->append(tr("Customer"), "cust_id", ParameterWidget::Customer); parameterWidget()->append(tr("Customer Ship-to"), "shipto_id", ParameterWidget::Shipto); parameterWidget()->appendComboBox(tr("Customer Group"), "custgrp_id", XComboBox::CustomerGroups); parameterWidget()->append(tr("Customer Group Pattern"), "custgrp_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Customer Type"), "custtype_id", XComboBox::CustomerTypes); parameterWidget()->append(tr("Customer Type Pattern"), "custtype_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item); parameterWidget()->appendComboBox(tr("Product Category"), "prodcat_id", XComboBox::ProductCategories); parameterWidget()->append(tr("Product Category Pattern"), "prodcat_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Sales Rep."), "salesrep_id", XComboBox::SalesReps); if (_metrics->boolean("MultiWhs")) parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site); parameterWidget()->applyDefaultFilterSet(); list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "cohead_number" ); list()->addColumn(tr("Line #"), _seqColumn, Qt::AlignLeft, true, "f_linenumber" ); list()->addColumn(tr("Ord. Date"), _dateColumn, Qt::AlignCenter, true, "cohead_orderdate"); list()->addColumn(tr("Cust. #"), _itemColumn, Qt::AlignLeft, true, "cust_number" ); list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, false, "cust_name" ); list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number" ); list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescription" ); list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyord" ); if (_privileges->check("ViewCustomerPrices")) { list()->addColumn(tr("Unit Price"), _priceColumn, Qt::AlignRight, false, "coitem_price" ); list()->addColumn(tr("Ext. Price"), _bigMoneyColumn, Qt::AlignRight, false, "extprice" ); list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignCenter, false, "currAbbr" ); list()->addColumn(tr("Base Unit Price"), _priceColumn, Qt::AlignRight, true, "baseunitprice" ); list()->addColumn(tr("Base Ext. Price"), _bigMoneyColumn, Qt::AlignRight, true, "baseextprice" ); } if (_privileges->check("ViewCosts")) { list()->addColumn(tr("Unit Cost"), _costColumn, Qt::AlignRight, false, "coitem_unitcost" ); list()->addColumn(tr("Ext. Cost"), _bigMoneyColumn, Qt::AlignRight, false, "extcost" ); } if (_privileges->check("ViewCustomerPrices") && _privileges->check("ViewCosts")) { list()->addColumn(tr("Margin"), _bigMoneyColumn, Qt::AlignRight, false, "margin" ); list()->addColumn(tr("Margin %"), _prcntColumn, Qt::AlignRight, false, "marginpercent" ); } setupCharacteristics("SO"); }
opportunityList::opportunityList(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "opportunityList", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Opportunities")); setReportName("OpportunityList"); setMetaSQLOptions("opportunities", "detail"); setUseAltId(true); setParameterWidgetVisible(true); setNewVisible(true); setSearchVisible(true); setQueryOnStartEnabled(true); list()->addColumn(tr("Number"), _orderColumn, Qt::AlignLeft, false, "ophead_number" ); list()->addColumn(tr("Active"), _orderColumn, Qt::AlignLeft, false, "ophead_active" ); list()->addColumn(tr("Name"), -1, Qt::AlignLeft, true, "ophead_name" ); list()->addColumn(tr("CRM Acct."), _userColumn, Qt::AlignLeft, true, "crmacct_number" ); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "ophead_owner_username" ); list()->addColumn(tr("Assigned"), _userColumn, Qt::AlignLeft, false, "ophead_username" ); list()->addColumn(tr("Stage"), _orderColumn, Qt::AlignLeft, true, "opstage_name" ); list()->addColumn(tr("Priority"), _orderColumn, Qt::AlignLeft, true, "incdtpriority_name" ); list()->addColumn(tr("Source"), _orderColumn, Qt::AlignLeft, true, "opsource_name" ); list()->addColumn(tr("Type"), _orderColumn, Qt::AlignLeft, true, "optype_name" ); list()->addColumn(tr("Prob.%"), _prcntColumn, Qt::AlignCenter, true, "ophead_probability_prcnt" ); list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "ophead_amount" ); list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, false, "f_currency" ); list()->addColumn(tr("Target Date"), _dateColumn, Qt::AlignLeft, true, "ophead_target_date" ); list()->addColumn(tr("Actual Date"), _dateColumn, Qt::AlignLeft, false, "ophead_actual_date" ); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sEdit())); bool canEditUsers = _privileges->check("MaintainOtherTodoLists") || _privileges->check("ViewOtherTodoLists"); parameterWidget()->append(tr("User"), "username", ParameterWidget::User, omfgThis->username(), !canEditUsers); if (canEditUsers) parameterWidget()->append(tr("User Pattern"), "usr_pattern", ParameterWidget::Text); else parameterWidget()->setEnabled(tr("User"), false); parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date); parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date); parameterWidget()->append(tr("CRM Account"), "crmacct_id", ParameterWidget::Crmacct); parameterWidget()->appendComboBox(tr("Type"), "optype_id", XComboBox::OpportunityTypes); parameterWidget()->append(tr("Type Pattern"), "optype_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Source"), "opsource_id", XComboBox::OpportunitySources); parameterWidget()->append(tr("Source Pattern"), "source_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Stage"), "opstage_id", XComboBox::OpportunityStages); parameterWidget()->append(tr("Stage Pattern"), "opstage_pattern", ParameterWidget::Text); setupCharacteristics(characteristic::Opportunities); parameterWidget()->applyDefaultFilterSet(); }
dspBacklog::dspBacklog(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "dspBacklog", fl) { setWindowTitle(tr("Backlog")); setReportName("Backlog"); setMetaSQLOptions("backlog", "detail"); setUseAltId(true); setParameterWidgetVisible(true); parameterWidget()->append(tr("Start Order Date"), "startDate", ParameterWidget::Date); parameterWidget()->append(tr("End Order Date"), "endDate", ParameterWidget::Date); parameterWidget()->append(tr("Start Schedule Date"), "startDateSched", ParameterWidget::Date); parameterWidget()->append(tr("End Schedule Date"), "endDateSched", ParameterWidget::Date); parameterWidget()->append(tr("Customer"), "cust_id", ParameterWidget::Customer); parameterWidget()->appendComboBox(tr("Customer Group"), "custgrp_id", XComboBox::CustomerGroups); parameterWidget()->append(tr("Customer Group Pattern"), "custgrp_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Customer Type"), "custtype_id", XComboBox::CustomerTypes); parameterWidget()->append(tr("Customer Type Pattern"), "custtype_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Customer Ship-To"), "shipto_id", ParameterWidget::Shipto); parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item); parameterWidget()->appendComboBox(tr("Product Category"), "prodcat_id", XComboBox::ProductCategories); parameterWidget()->append(tr("Product Category Pattern"), "prodcat_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Sales Order"), "cohead_id", ParameterWidget::SalesOrder); parameterWidget()->appendComboBox(tr("Sales Rep."), "salesrep_id", XComboBox::SalesRepsActive); if (_metrics->boolean("MultiWhs")) parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site); parameterWidget()->applyDefaultFilterSet(); setupCharacteristics(characteristic::SalesOrders); list()->setSelectionMode(QAbstractItemView::ExtendedSelection); list()->addColumn(tr("S/O #/Line #"),_itemColumn, Qt::AlignLeft, true, "coitem_linenumber"); list()->addColumn(tr("Customer/Item Number"), -1, Qt::AlignLeft, true, "item_number"); list()->addColumn(tr("Order"), _dateColumn, Qt::AlignCenter,true, "cohead_orderdate"); list()->addColumn(tr("Ship/Sched."), _dateColumn, Qt::AlignCenter,true, "coitem_scheddate"); list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter,true, "uom_name"); list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyord"); list()->addColumn(tr("Shipped"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyshipped"); list()->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "qtybalance"); if (_privileges->check("ViewCustomerPrices") || _privileges->check("MaintainCustomerPrices")) list()->addColumn(tr("Ext. Price"), _bigMoneyColumn, Qt::AlignRight, true, "baseextpricebalance"); list()->addColumn(tr("Firm"), _ynColumn, Qt::AlignCenter,false, "coitem_firm"); list()->setPopulateLinear(true); }
void projects::sBuildList() { list()->setColumnCount(0); if (!_showHierarchy->isChecked()) { // List Hierarchy Display setMetaSQLOptions("projects", "detail"); list()->addColumn(tr("Number"), _orderColumn, Qt::AlignLeft, true, "name"); list()->addColumn(tr("Name"), -1, Qt::AlignLeft, true, "item"); list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip"); list()->addColumn(tr("Status"), _itemColumn, Qt::AlignCenter, true, "status" ); list()->addColumn(tr("Project Type"), _itemColumn, Qt::AlignCenter, true, "project_type" ); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, false, "prj_owner_username"); list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "prj_username"); list()->addColumn(tr("Account/Customer"), _userColumn, Qt::AlignLeft, true, "customer"); list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, false, "contact"); list()->addColumn(tr("City"), -1, Qt::AlignLeft, false, "city"); list()->addColumn(tr("State"), -1, Qt::AlignLeft, false, "state"); list()->addColumn(tr("Qty"), _qtyColumn, Qt::AlignRight, true, "qty" ); list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignLeft, true, "uom" ); list()->addColumn(tr("Value"), _qtyColumn, Qt::AlignRight, true, "value" ); list()->addColumn(tr("Due"), _dateColumn, Qt::AlignCenter, true, "due"); list()->addColumn(tr("Assigned"), _dateColumn, Qt::AlignCenter, true, "assigned"); list()->addColumn(tr("Started"), _dateColumn, Qt::AlignCenter, true, "started"); list()->addColumn(tr("Completed"), _dateColumn, Qt::AlignCenter, true, "completed"); list()->addColumn(tr("Budget Hrs."), _costColumn, Qt::AlignRight, true, "hrs_budget"); list()->addColumn(tr("Actual Hrs."), _costColumn, Qt::AlignRight, true, "hrs_actual"); list()->addColumn(tr("Balance Hrs."), _costColumn, Qt::AlignRight, true, "hrs_balance"); list()->addColumn(tr("Budget Exp."), _priceColumn, Qt::AlignRight, false, "exp_budget"); list()->addColumn(tr("Actual Exp."), _priceColumn, Qt::AlignRight, false, "exp_actual"); list()->addColumn(tr("Balance Exp."), _priceColumn, Qt::AlignRight, false, "exp_balance"); } else { // List flat display (for CSV export purposes) setMetaSQLOptions("projects", "detail_nohierarchy"); // Project Details list()->addColumn(tr("Project"), _orderColumn, Qt::AlignLeft, true, "prj_number"); list()->addColumn(tr("Project Name"), -1, Qt::AlignLeft, true, "prj_name"); list()->addColumn(tr("Project Description"), -1, Qt::AlignLeft, true, "prj_descrip"); list()->addColumn(tr("Status"), _itemColumn, Qt::AlignCenter, true, "project_status" ); list()->addColumn(tr("Project Type"), _itemColumn, Qt::AlignCenter, true, "project_type" ); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "prj_owner_username"); list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "prj_username"); list()->addColumn(tr("Account"), _userColumn, Qt::AlignLeft, true, "crmacct_name"); list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, true, "cntct_name"); list()->addColumn(tr("City"), -1, Qt::AlignLeft, true, "addr_city"); list()->addColumn(tr("State"), -1, Qt::AlignLeft, true, "addr_state"); list()->addColumn(tr("Project Due"), _dateColumn, Qt::AlignCenter, true, "prj_due_date"); list()->addColumn(tr("Project Assigned"), _dateColumn, Qt::AlignCenter, true, "prj_assigned_date"); list()->addColumn(tr("Project Started"), _dateColumn, Qt::AlignCenter, true, "prj_start_date"); list()->addColumn(tr("Project Completed"), _dateColumn, Qt::AlignCenter, true, "prj_completed_date"); // Task Details list()->addColumn(tr("Task"), _orderColumn, Qt::AlignLeft, true, "prjtask_number"); list()->addColumn(tr("Task Name"), -1, Qt::AlignLeft, true, "prjtask_name"); list()->addColumn(tr("Task Description"), -1, Qt::AlignLeft, true, "prjtask_descrip"); list()->addColumn(tr("Task Status"), _itemColumn, Qt::AlignCenter, true, "task_status" ); list()->addColumn(tr("Task Owner"), _userColumn, Qt::AlignLeft, true, "prjtask_owner_username"); list()->addColumn(tr("Task Assigned To"), _userColumn, Qt::AlignLeft, true, "prjtask_username"); list()->addColumn(tr("Customer"), _userColumn, Qt::AlignLeft, true, "cust_name"); list()->addColumn(tr("Task Due"), _dateColumn, Qt::AlignCenter, true, "prjtask_due_date"); list()->addColumn(tr("Task Assigned"), _dateColumn, Qt::AlignCenter, true, "prjtask_assigned_date"); list()->addColumn(tr("Task Started"), _dateColumn, Qt::AlignCenter, true, "prjtask_start_date"); list()->addColumn(tr("Task Completed"), _dateColumn, Qt::AlignCenter, true, "prjtask_completed_date"); list()->addColumn(tr("Budget Hrs."), _costColumn, Qt::AlignRight, true, "prjtask_hours_budget"); list()->addColumn(tr("Actual Hrs."), _costColumn, Qt::AlignRight, true, "prjtask_hours_actual"); list()->addColumn(tr("Balance Hrs."), _costColumn, Qt::AlignRight, true, "prjtask_hours_balance"); list()->addColumn(tr("Budget Exp."), _priceColumn, Qt::AlignRight, true, "prjtask_exp_budget"); list()->addColumn(tr("Actual Exp."), _priceColumn, Qt::AlignRight, true, "prjtask_exp_actual"); list()->addColumn(tr("Balance Exp."), _priceColumn, Qt::AlignRight, true, "prjtask_exp_balance"); setupCharacteristics(characteristic::Projects); _showHierarchy->setEnabled(false); } sFillList(); }
incidentWorkbench::incidentWorkbench(QWidget* parent, const char*, Qt::WindowFlags fl) : display(parent, "incidentWorkbench", fl) { setWindowTitle(tr("Incidents")); setListLabel(tr("Incidents")); setReportName("IncidentWorkbenchList"); setMetaSQLOptions("incidents", "detail"); setParameterWidgetVisible(true); setNewVisible(_privileges->check("MaintainAllIncidents") || _privileges->check("MaintainPersonalIncidents")); setSearchVisible(true); setQueryOnStartEnabled(true); setAutoUpdateEnabled(true); QString qryStatus = QString("SELECT status_seq, " " CASE WHEN status_code = 'N' THEN '%1' " " WHEN status_code = 'F' THEN '%2' " " WHEN status_code = 'C' THEN '%3' " " WHEN status_code = 'A' THEN '%4' " " WHEN status_code = 'R' THEN '%5' " " WHEN status_code = 'L' THEN '%6' " " END AS name, status_code AS code " "FROM status; ") .arg(tr("New")) .arg(tr("Feedback")) .arg(tr("Confirmed")) .arg(tr("Assigned")) .arg(tr("Resolved")) .arg(tr("Closed")); QString qryPriority = "SELECT incdtpriority_id, incdtpriority_name " "FROM incdtpriority " "ORDER BY incdtpriority_order, incdtpriority_name "; parameterWidget()->append(tr("Account"), "crmAccountId", ParameterWidget::Crmacct); parameterWidget()->append(tr("Contact"),"cntct_id", ParameterWidget::Contact); parameterWidget()->append(tr("Category"), "categorylist", ParameterWidget::Multiselect, QVariant(), false, "SELECT incdtcat_id, incdtcat_name" " FROM incdtcat" " ORDER BY incdtcat_name;"); parameterWidget()->appendComboBox(tr("Status Above"), "status_above", qryStatus, 4); parameterWidget()->append(tr("Status"), "statuslist", ParameterWidget::Multiselect, QVariant(), false, qryStatus); parameterWidget()->appendComboBox(tr("Severity"), "severity_id", XComboBox::IncidentSeverity); parameterWidget()->append(tr("User"), "username", ParameterWidget::User, omfgThis->username()); parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User); parameterWidget()->append(tr("Assigned To"), "assigned_username", ParameterWidget::User); parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date); parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date); parameterWidget()->append(tr("Priority"), "incdtpriority_id_list", ParameterWidget::Multiselect, QVariant(), false, qryPriority); parameterWidget()->append(tr("Project"), "prj_id", ParameterWidget::Project); if(_metrics->boolean("IncidentsPublicPrivate")) parameterWidget()->append(tr("Public"), "public", ParameterWidget::CheckBox); parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item); if (_metrics->boolean("LotSerialControl")) parameterWidget()->append(tr("Lot/Serial Pattern"), "lspattern", ParameterWidget::Text); parameterWidget()->applyDefaultFilterSet(); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen())); if (!_privileges->check("MaintainAllIncidents") && !_privileges->check("MaintainPersonalIncidents")) newAction()->setEnabled(false); list()->addColumn(tr("Number"), _orderColumn,Qt::AlignLeft, true, "incdt_number" ); list()->addColumn(tr("Created"), _dateColumn, Qt::AlignLeft, true, "incdt_timestamp" ); list()->addColumn(tr("Account"), _itemColumn, Qt::AlignLeft, true, "crmacct_name" ); list()->addColumn(tr("Status"), _itemColumn, Qt::AlignLeft, true, "incdt_status" ); list()->addColumn(tr("Updated"), _dateColumn, Qt::AlignLeft, true, "incdt_updated" ); list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "incdt_assigned_username" ); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "incdt_owner_username" ); list()->addColumn(tr("Summary"), -1, Qt::AlignLeft, true, "incdt_summary" ); list()->addColumn(tr("Category"), _userColumn, Qt::AlignLeft, false, "incdtcat_name"); list()->addColumn(tr("Severity"), _userColumn, Qt::AlignLeft, false, "incdtseverity_name"); list()->addColumn(tr("Priority"), _userColumn, Qt::AlignLeft, false, "incdtpriority_name"); list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, false, "cntct_name"); list()->addColumn(tr("Project"), _userColumn, Qt::AlignLeft, false, "prj_number"); if(_metrics->boolean("IncidentsPublicPrivate")) list()->addColumn(tr("Public"), _userColumn, Qt::AlignLeft, false, "incdt_public"); list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, false, "item_number"); list()->addColumn(tr("Lot/Serial"), _itemColumn, Qt::AlignLeft, false, "ls_number"); setupCharacteristics("INCDT"); parameterWidget()->applyDefaultFilterSet(); }
contacts::contacts(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "contacts", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Contacts")); setReportName("ContactsMasterList"); setMetaSQLOptions("contacts", "detail"); setParameterWidgetVisible(true); setNewVisible(true); setSearchVisible(true); setQueryOnStartEnabled(true); _crmacctid = -1; _attachAct = 0; _detachAct = 0; if (_privileges->check("MaintainAllContacts") || _privileges->check("ViewAllContacts")) { parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User); parameterWidget()->append(tr("Owner Pattern"), "owner_usr_pattern", ParameterWidget::Text); } parameterWidget()->append(tr("CRM Account"), "crmacct_id", ParameterWidget::Crmacct); parameterWidget()->append(tr("Name Pattern"), "cntct_name_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Phone Pattern"), "cntct_phone_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Email Pattern"), "cntct_email_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Street Pattern"), "addr_street_pattern", ParameterWidget::Text); parameterWidget()->append(tr("City Pattern"), "addr_city_pattern", ParameterWidget::Text); parameterWidget()->append(tr("State Pattern"), "addr_state_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Postal Code Pattern"), "addr_postalcode_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Country Pattern"), "addr_country_pattern", ParameterWidget::Text); parameterWidget()->applyDefaultFilterSet(); list()->addColumn(tr("First Name"), 80, Qt::AlignLeft, true, "cntct_first_name"); list()->addColumn(tr("Last Name"), 100, Qt::AlignLeft, true, "cntct_last_name"); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, false, "cntct_owner_username"); list()->addColumn(tr("Account #"), 80, Qt::AlignLeft, true, "crmacct_number"); list()->addColumn(tr("Account Name"), -1, Qt::AlignLeft, true, "crmacct_name"); list()->addColumn(tr("Title"), -1, Qt::AlignLeft, true, "cntct_title"); list()->addColumn(tr("Phone"), 100, Qt::AlignLeft, true, "cntct_phone"); list()->addColumn(tr("Alternate"), 100, Qt::AlignLeft, true, "cntct_phone2"); list()->addColumn(tr("Fax"), 100, Qt::AlignLeft, false, "cntct_fax"); list()->addColumn(tr("E-Mail"), 100, Qt::AlignLeft, true, "cntct_email"); list()->addColumn(tr("Web Address"), 100, Qt::AlignLeft, false, "cntct_webaddr"); list()->addColumn(tr("Address"), -1, Qt::AlignLeft, false, "addr_line1"); list()->addColumn(tr("City"), 75, Qt::AlignLeft, false, "addr_city"); list()->addColumn(tr("State"), 50, Qt::AlignLeft, false, "addr_state"); list()->addColumn(tr("Country"), 100, Qt::AlignLeft, false, "addr_country"); list()->addColumn(tr("Postal Code"), 75, Qt::AlignLeft, false, "addr_postalcode"); list()->setSelectionMode(QAbstractItemView::ExtendedSelection); setupCharacteristics(characteristic::Contacts); parameterWidget()->applyDefaultFilterSet(); QToolButton * attachBtn = new QToolButton(this); attachBtn->setText(tr("Attach")); _attachAct = toolBar()->insertWidget(filterSeparator(), attachBtn); _attachAct->setEnabled(false); _attachAct->setVisible(false); QToolButton * detachBtn = new QToolButton(this); detachBtn->setText(tr("Detach")); _detachAct = toolBar()->insertWidget(filterSeparator(), detachBtn); _detachAct->setEnabled(false); _detachAct->setVisible(false); connect(attachBtn, SIGNAL(clicked()), this, SLOT(sAttach())); connect(detachBtn, SIGNAL(clicked()), this, SLOT(sDetach())); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen())); if (_privileges->check("MaintainAllContacts") || _privileges->check("MaintainPersonalContacts")) { _attachAct->setEnabled(true); connect(list(), SIGNAL(valid(bool)), _detachAct, SLOT(setEnabled(bool))); } else { newAction()->setEnabled(false); } }
projects::projects(QWidget* parent, const char*, Qt::WindowFlags fl) : display(parent, "projects", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Projects")); setMetaSQLOptions("projects", "detail_nohierarchy"); setReportName("ProjectsList"); setParameterWidgetVisible(true); setNewVisible(true); setSearchVisible(true); setQueryOnStartEnabled(true); setUseAltId(true); // Project Details list()->addColumn(tr("Project"), _orderColumn, Qt::AlignLeft, true, "prj_number"); list()->addColumn(tr("Project Name"), -1, Qt::AlignLeft, true, "prj_name"); list()->addColumn(tr("Project Description"), -1, Qt::AlignLeft, true, "prj_descrip"); list()->addColumn(tr("Status"), _itemColumn, Qt::AlignCenter, true, "project_status" ); list()->addColumn(tr("Project Type"), _itemColumn, Qt::AlignCenter, true, "project_type" ); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "prj_owner_username"); list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "prj_username"); list()->addColumn(tr("Account"), _userColumn, Qt::AlignLeft, true, "crmacct_name"); list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, true, "cntct_name"); list()->addColumn(tr("City"), -1, Qt::AlignLeft, true, "addr_city"); list()->addColumn(tr("State"), -1, Qt::AlignLeft, true, "addr_state"); list()->addColumn(tr("Project Due"), _dateColumn, Qt::AlignCenter, true, "prj_due_date"); list()->addColumn(tr("Project Assigned"), _dateColumn, Qt::AlignCenter, true, "prj_assigned_date"); list()->addColumn(tr("Project Started"), _dateColumn, Qt::AlignCenter, true, "prj_start_date"); list()->addColumn(tr("Project Completed"), _dateColumn, Qt::AlignCenter, true, "prj_completed_date"); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen())); if (!_privileges->check("MaintainAllProjects") && !_privileges->check("MaintainPersonalProjects")) newAction()->setEnabled(false); _salesOrders->setChecked(false); _workOrders->setChecked(false); _purchaseOrders->setChecked(false); _incidents->setChecked(false); _showHierarchy->setChecked(false); connect(omfgThis, SIGNAL(projectsUpdated(int)), this, SLOT(sFillList())); connect(_showComplete, SIGNAL(toggled(bool)), this, SLOT(sFillList())); // connect(_salesOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList())); // connect(_workOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList())); // connect(_purchaseOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList())); // connect(_incidents, SIGNAL(toggled(bool)), this, SLOT(sFillList())); // connect(_showHierarchy, SIGNAL(toggled(bool)), this, SLOT(sBuildList())); _ordersGroup->hide(); QString qryType = QString( "SELECT prjtype_id, prjtype_descr FROM prjtype " ); QString qryStatus = QString( "SELECT 1, '%1' UNION " "SELECT 2, '%2' UNION " "SELECT 3, '%3'") .arg(tr("Complete")) .arg(tr("Concept")) .arg(tr("In-Process")); parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User); parameterWidget()->append(tr("AssignedTo"), "assigned_username", ParameterWidget::User); parameterWidget()->append(tr("Account"), "crmacct_id", ParameterWidget::Crmacct); parameterWidget()->append(tr("Contact"), "cntct_id", ParameterWidget::Contact); parameterWidget()->appendComboBox(tr("Project Type"), "prjtype_id", qryType); parameterWidget()->appendComboBox(tr("Project Status"), "prjstatus_id", qryStatus); parameterWidget()->append(tr("Project"), "prj_id", ParameterWidget::Project); parameterWidget()->append(tr("Project Task"), "project_task", ParameterWidget::Text); parameterWidget()->append(tr("Sales Order"), "cohead_id", ParameterWidget::SalesOrder); parameterWidget()->append(tr("Work Order"), "wo_id", ParameterWidget::WorkOrder); parameterWidget()->append(tr("Purchase Order"), "pohead_id", ParameterWidget::PurchaseOrder); parameterWidget()->append(tr("Start Start Date"), "startStartDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Start End Date"), "startEndDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Due Start Date"), "dueStartDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Due End Date"), "dueEndDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Assigned Start Date"), "assignedStartDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Assigned End Date"), "assignedEndDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Completed Start Date"), "completedStartDate", ParameterWidget::Date, QDate::currentDate()); parameterWidget()->append(tr("Completed End Date"), "completedEndDate", ParameterWidget::Date, QDate::currentDate()); setupCharacteristics("PROJ"); _statuses << "None" << "C" << "P" << "O"; // sBuildList(); }