ProjectLineEdit::ProjectLineEdit(QWidget* pParent, const char* pName) :
VirtualClusterLineEdit(pParent, "prj", "prj_id", "prj_number", "prj_name", 0, 0, pName)
{
setTitles(tr("Project"), tr("Projects"));
setUiName("project");
setEditPriv("MaintainProjects");
setNewPriv("MaintainProjects");
setViewPriv("ViewProjects");
_type = Undefined;
}
OpportunityClusterLineEdit::OpportunityClusterLineEdit(QWidget* pParent, const char* pName) :
CrmClusterLineEdit(pParent, "ophead", "ophead_id", "ophead_name", 0, "ophead_notes", "ophead_owner_username", "ophead_username", 0, pName)
{
_objtype = "OPP";
setTitles(tr("Opportunity"), tr("Opportunities"));
setUiName("opportunity");
setEditPriv("MaintainAllOpportunities");
setNewPriv("MaintainAllOpportunities");
setViewPriv("ViewAllOpportunities");
setEditOwnPriv("MaintainPersonalOpportunities");
setViewOwnPriv("ViewPersonalOpportunities");
}
CLineEdit::CLineEdit(QWidget *pParent, const char *pName) :
VirtualClusterLineEdit(pParent, "cust", "id", "number", "name", "description", 0, pName, "active")
{
_crmacctId = -1;
_type = AllCustomers;
_subtype = CRMAcctLineEdit::Cust;
_canEdit = false;
_editMode = false;
if (! pName)
setObjectName("CLineEdit");
setTitles(tr("Customer"), tr("Customers"));
setUiName("customer");
setEditPriv("MaintainCustomerMasters");
setViewPriv("ViewCustomerMasters");
setNewPriv("MaintainCustomerMasters");
_query = " SELECT * FROM ( "
" SELECT cust_id AS id, "
" cust_number AS number, "
" cust_name AS name,"
" addr_line1 AS description,"
" cust_active AS active, "
" cust_creditstatus, "
" crmacct_id, true AS iscustomer, "
" addr.*, cntct.*, "
" formatAddr(addr_line1, addr_line2, addr_line3, '', '') AS street "
" FROM custinfo "
" LEFT OUTER JOIN cntct ON (cust_cntct_id=cntct_id) "
" LEFT OUTER JOIN addr ON (cntct_addr_id=addr_id) "
" LEFT OUTER JOIN crmacct ON (crmacct_cust_id=cust_id) "
" UNION "
" SELECT prospect_id AS id, "
" prospect_number AS number,"
" prospect_name AS name,"
" addr_line1 AS description,"
" prospect_active AS active, "
" 'G' AS cust_creditstatus, "
" crmacct_id, false AS iscustomer, "
" addr.*, cntct.*, "
" formatAddr(addr_line1, addr_line2, addr_line3, '', '') AS street "
" FROM prospect "
" LEFT OUTER JOIN cntct ON (prospect_cntct_id=cntct_id) "
" LEFT OUTER JOIN addr ON (cntct_addr_id=addr_id) "
" LEFT OUTER JOIN crmacct ON (crmacct_prospect_id=prospect_id) "
" ) cust "
"WHERE (true) ";
_modeAct = new QAction(tr("Edit Number"), this);
_modeAct->setToolTip(tr("Sets number for editing"));
_modeAct->setCheckable(true);
connect(_modeAct, SIGNAL(triggered(bool)), this, SLOT(setEditMode(bool)));
}
IncidentClusterLineEdit::IncidentClusterLineEdit(QWidget* pParent, const char* pName) :
CrmClusterLineEdit(pParent, "incdt", "incdt_id", "incdt_number::text", "incdt_summary", 0, "incdt_owner_username", "incdt_assigned_username", 0, pName)
{
_objtype = "INCDT";
setTitles(tr("Incident"), tr("Incidents"));
setUiName("incident");
setEditPriv("MaintainAllIncidents");
setNewPriv("MaintainAllIncidents");
setViewPriv("ViewAllIncidents");
setEditOwnPriv("MaintainPersonalIncidents");
setViewOwnPriv("ViewPersonalIncidents");
}
CRMAcctLineEdit::CRMAcctLineEdit(QWidget* pParent, const char* pName) :
CrmClusterLineEdit(pParent, "crmacct", "crmacct_id", "crmacct_number", "crmacct_name", 0, "crmacct_owner_username", 0, 0, pName, "crmacct_active")
{
_objtype = "CRMA";
setTitles(tr("Account"), tr("Accounts"));
setUiName("crmaccount");
setEditPriv("MaintainAllCRMAccounts");
setViewPriv("ViewAllCRMAccounts");
setNewPriv("MaintainAllCRMAccounts");
setEditOwnPriv("MaintainPersonalCRMAccounts");
setViewOwnPriv("ViewPersonalCRMAccounts");
setSubtype(Crmacct);
}
ProjectLineEdit::ProjectLineEdit(QWidget* pParent, const char* pName) :
CrmClusterLineEdit(pParent, "prj", "prj_id", "prj_number", "prj_name", 0, "prj_owner_username", "prj_username", 0, pName)
{
_objtype = "J";
setTitles(tr("Project"), tr("Projects"));
setUiName("project");
setEditPriv("MaintainAllProjects");
setNewPriv("MaintainAllProjects");
setViewPriv("ViewAllProjects");
setEditOwnPriv("MaintainPersonalProjects");
setViewOwnPriv("ViewPersonalProjects");
_type = Undefined;
}
void ShiptoEdit::setCustid(int pCustid)
{
if (pCustid == _custid)
return;
clear();
_custid = pCustid;
if (_custid != -1)
{
_extraClause = QString(" (shipto_cust_id=%1) ").arg(_custid);
setNewPriv("MaintainShiptos");
}
else
{
_extraClause = " (false) ";
setNewPriv("");
}
sUpdateMenu();
emit newCustid(pCustid);
emit disableList(_custid == -1);
}
ContactClusterLineEdit::ContactClusterLineEdit(QWidget* pParent, const char* pName) :
VirtualClusterLineEdit(pParent, "cntct", "cntct_id", "cntct_name", 0, "cntct_title", 0, pName, "cntct_active")
{
_searchAcctId = -1;
setTitles(tr("Contact"), tr("Contacts"));
setUiName("contact");
setEditPriv("MaintainContacts");
setNewPriv("MaintainContacts");
setViewPriv("ViewContacts");
_query = "SELECT cntct_id AS id, cntct_name AS number, cntct_title AS description, "
" cntct_active AS active, "
" cntct_first_name, cntct_last_name, crmacct_name, cntct_title, cntct_phone, "
" cntct_phone2,cntct_fax, cntct_email, cntct_webaddr "
"FROM cntct LEFT OUTER JOIN crmacct ON (cntct_crmacct_id = crmacct_id) "
"WHERE (true) ";
}
ShiptoEdit::ShiptoEdit(QWidget *pParent, const char *pName) :
VirtualClusterLineEdit(pParent, "shiptoinfo", "shipto_id", "shipto_num", "shipto_name", "addr_line1", " (false) ", pName, "shipto_active")
{
setTitles(tr("Ship To Address"), tr("Ship To Addresses"));
setUiName("shipTo");
setEditPriv("MaintainShiptos");
setViewPriv("ViewShiptos");
setNewPriv("MaintainShiptos");
_custid = 0;
setCustid(-1);
_query = "SELECT shipto_id AS id, shipto_num AS number, shipto_name AS name, "
" addr_line1 AS description, "
" (addr_city || ', ' || addr_state || ' ' || addr_postalcode) AS csv,"
" shipto_active AS active "
"FROM shiptoinfo "
" LEFT OUTER JOIN addr ON (shipto_addr_id=addr_id) "
"WHERE (true) ";
}
PlanOrdLineEdit::PlanOrdLineEdit(QWidget* pParent, const char* pName) :
VirtualClusterLineEdit(pParent, "planord", "planord_id", "formatPloNumber(planord_id)", "item_number", "(item_descrip1 ' ' item_descrip2)", 0, pName)
{
setTitles(tr("Planned Order"), tr("Planned Orders"));
setUiName("plannedOrder");
setEditPriv("CreatePlannedOrders");
setViewPriv("ViewPlannedOrders");
setNewPriv("CreatePlannedOrders");
_query = "SELECT planord_id AS id,"
" formatPloNumber(planord_id) AS number, "
" item_number AS name, "
" (item_descrip1 || ' ' || item_descrip2) AS description, "
" NULL AS active, "
" warehous_code, item_number, uom_name,"
" item_descrip1, item_descrip2 "
"FROM planord "
" JOIN itemsite ON (planord_itemsite_id=itemsite_id) "
" JOIN item ON (itemsite_item_id=item_id) "
" JOIN whsinfo ON (itemsite_warehous_id=warehous_id) "
" JOIN uom ON (item_inv_uom_id=uom_id) "
"WHERE (true) ";
}
ItemLineEdit::ItemLineEdit(QWidget* pParent, const char* pName) :
VirtualClusterLineEdit(pParent, "item", "item_id", "item_number", "(item_descrip1 || ' ' || item_descrip2) ", 0, 0, pName)
{
if (DEBUG)
qDebug("ItemLineEdit::ItemLineEdit(%p, %s) entered", pParent, pName);
setObjectName(pName ? pName : "ItemLineEdit");
setTitles(tr("Item"), tr("Items"));
setUiName("item");
setEditPriv("MaintainItemMasters");
setViewPriv("ViewItemMasters");
setNewPriv("MaintainItemMasters");
setAcceptDrops(TRUE);
_type = cUndefined;
_defaultType = cUndefined;
_useQuery = FALSE;
_useValidationQuery = FALSE;
_itemNumber = "";
_uom = "";
_itemType = "";
_id = -1;
_configured = FALSE;
_fractional = FALSE;
_delegate = new ItemLineEditDelegate(this);
connect(_aliasAct, SIGNAL(triggered()), this, SLOT(sAlias()));
// Add alias
if (_x_preferences)
{
if (!_x_preferences->boolean("ClusterButtons"))
menu()->insertAction(menu()->actions().at(2),_aliasAct);
}
}
