Equipment Details Sync
- Frank Zerillo (Deactivated)
- Brian Dixon
Owned by Frank Zerillo (Deactivated)
Sync Service GLA, Owner and Location to Equipment
Equipment Details Sync
<?php
/**
* Event: Custom PHP Event
* Frequency: Hourly
* Time:
* Listener Class: Core_Model_Event
* Listener Method: eventCustom
*/
PCR_Event::attachDb("equipment-bulk-update", ["Application_Model_Equipment_Equipment" => "eventBulkUpdate"]);
$records = $this->query(<<<SQL
SELECT
S.RECID AS SERVICES_RECID,
E.RECID AS EQUIPMENT_RECID,
S.OWNER_CONTACTS_RECID AS SERVICE_OWNER_CONTACTS_RECID,
E.OWNER_CONTACTS_RECID AS EQUIPMENT_OWNER_CONTACTS_RECID,
S.OWNER_DEPT_HIERARCHY_RECID AS SERVICE_OWNER_DEPT_HIERARCHY_RECID,
E.OWNER_DEPT_HIERARCHY_RECID AS EQUIPMENT_OWNER_DEPT_HIERARCHY_RECID,
CASE
WHEN S.OWNER_CONTACTS_RECID IS NULL
THEN SDH.BILLING_GROUPS_RECID
WHEN SCON.BILLING_GROUPS_RECID IS NULL
THEN SCON_DEPT.BILLING_GROUPS_RECID
ELSE SCON.BILLING_GROUPS_RECID
END AS SERVICE_BILLING_GROUP,
CASE
WHEN E.OWNER_CONTACTS_RECID IS NULL
THEN EDH.BILLING_GROUPS_RECID
WHEN ECON.BILLING_GROUPS_RECID IS NULL
THEN ECON_DEPT.BILLING_GROUPS_RECID
ELSE ECON.BILLING_GROUPS_RECID
END AS EQUIPMENT_BILLING_GROUP,
SEG.GLA_RECID AS SERVICE_GLA,
EEG.GLA_RECID AS EQUIPMENT_GLA,
S.LOCATIONS_RECID AS SERVICE_LOCATION,
E.LOCATIONS_RECID AS EQUIPMENT_LOCATION,
S.MULTIPLE_LOCATIONS,
COALESCE(EG.FORMAT,SG.FORMAT) AS GLA_FORMAT,
E.BILLABLE,
E.WARRANTY_END_DATE
FROM SERVICES S
JOIN SERVICES_EQUIPMENT SE ON S.RECID = SE.SERVICES_RECID
JOIN EQUIPMENT E ON SE.EQUIPMENT_RECID = E.RECID
LEFT JOIN DEPT_HIERARCHY EDH ON E.OWNER_DEPT_HIERARCHY_RECID = EDH.RECID
LEFT JOIN DEPT_HIERARCHY SDH ON S.OWNER_DEPT_HIERARCHY_RECID = SDH.RECID
LEFT JOIN CONTACTS ECON ON E.OWNER_CONTACTS_RECID = ECON.RECID
LEFT JOIN DEPT_HIERARCHY ECON_DEPT ON ECON.DEPT_HIERARCHY_RECID = ECON_DEPT.RECID
LEFT JOIN CONTACTS SCON ON S.OWNER_CONTACTS_RECID = SCON.RECID
LEFT JOIN DEPT_HIERARCHY SCON_DEPT ON SCON.DEPT_HIERARCHY_RECID = SCON_DEPT.RECID
LEFT JOIN SERVICES_EXPENSE_GLA SEG ON S.RECID = SEG.SERVICES_RECID
LEFT JOIN EQUIPMENT_EXPENSE_GLA EEG ON E.RECID = EEG.EQUIPMENT_RECID
LEFT JOIN LISTS SEGL ON SEG.EXPENSE_TYPE_LISTS_RECID = SEGL.RECID
LEFT JOIN LISTS EEGL ON EEG.EXPENSE_TYPE_LISTS_RECID = EEGL.RECID
LEFT JOIN GLA EG ON EEG.GLA_RECID = EG.RECID
LEFT JOIN GLA SG ON SEG.GLA_RECID = SG.RECID
WHERE
-- GLAs are Default and 100% or are not set
(
((SEGL.CODE = 'DEFAULT' AND SEG.PERCENT = 100) OR SEGL.CODE IS NULL)
AND
((EEGL.CODE = 'DEFAULT' AND SEG.PERCENT = 100) OR EEGL.CODE IS NULL)
)
-- if the OWNER is different
AND
(
(
(S.OWNER_CONTACTS_RECID <> E.OWNER_CONTACTS_RECID AND S.OWNER_CONTACTS_RECID IS NOT NULL AND E.OWNER_CONTACTS_RECID IS NOT NULL)
OR (S.OWNER_DEPT_HIERARCHY_RECID <> E.OWNER_DEPT_HIERARCHY_RECID AND S.OWNER_DEPT_HIERARCHY_RECID IS NOT NULL AND E.OWNER_DEPT_HIERARCHY_RECID IS NOT NULL)
OR (S.OWNER_CONTACTS_RECID IS NULL AND E.OWNER_CONTACTS_RECID IS NOT NULL)
OR (S.OWNER_CONTACTS_RECID IS NOT NULL AND E.OWNER_CONTACTS_RECID IS NULL)
OR (S.OWNER_DEPT_HIERARCHY_RECID IS NULL AND E.OWNER_DEPT_HIERARCHY_RECID IS NOT NULL)
OR (S.OWNER_DEPT_HIERARCHY_RECID IS NOT NULL AND E.OWNER_DEPT_HIERARCHY_RECID IS NULL)
)
-- if the location is different
OR (NOT(S.LOCATIONS_RECID <=> E.LOCATIONS_RECID) AND S.MULTIPLE_LOCATIONS = 0)
-- if the GLAs are different
OR NOT(SEG.GLA_RECID <=> EEG.GLA_RECID )
);
SQL
);
foreach ($records as $rec) {
$eventParams = [
"contact" => 101452, // PCR Admin contact
"users_recid" => 485, // pcradmin user
"selectedEquipmentRecids" => [$rec['EQUIPMENT_RECID']],
"gla_enabled" => false,
"condition_enabled" => false,
"cabling_eqp_type_enabled" => false,
"status_enabled" => false,
"location_enabled" => false,
"assoc_service_enabled" => false,
"equipment_type_enabled" => false,
"dhcp_enabled" => false,
"lan_name_enabled" => false,
"host_name_enabled" => false,
"private_enabled" => false,
"billable_enabled" => false,
"billable" => $rec["BILLABLE"],
"war_date_enabled" => false,
"war_date" => $rec["WARRANTY_END_DATE"],
"dept_hier_owner_enabled" => false,
"contact_owner_enabled" => false,
// other junk from the EQP Bulk UPdate
"gla_format" => $rec["GLA_FORMAT"],
"selectedEquipmentTypeListRecid" => null,
"isLocationRequired" => null,
"comment" => null,
];
if (empty($rec['SERVICE_OWNER_CONTACTS_RECID'])
&& $rec['SERVICE_OWNER_DEPT_HIERARCHY_RECID'] != $rec['EQUIPMENT_OWNER_DEPT_HIERARCHY_RECID']
) {
$eventParams['dept_hier_owner_enabled'] = true;
$eventParams['dept_hier_owner'] = $rec['SERVICE_OWNER_DEPT_HIERARCHY_RECID'];
} elseif(empty($rec['SERVICE_OWNER_DEPT_HIERARCHY_RECID'])
&& $rec['SERVICE_OWNER_CONTACTS_RECID'] != $rec['EQUIPMENT_OWNER_CONTACTS_RECID']
) {
$eventParams['contact_owner_enabled'] = true;
$eventParams['contact_owner'] = $rec['SERVICE_OWNER_CONTACTS_RECID'];
} elseif(empty($rec['SERVICE_OWNER_DEPT_HIERARCHY_RECID'])
&& $rec['SERVICE_OWNER_CONTACTS_RECID'] == $rec['EQUIPMENT_OWNER_CONTACTS_RECID']
) {
// Equipment has both Contact and Dept Owners -
// @see https://jira.pcr.com/browse/PCR360-7612
// updating the contact Owner even though it is already set will clear the Dept Owner
$eventParams['contact_owner_enabled'] = true;
$eventParams['contact_owner'] = $rec['SERVICE_OWNER_CONTACTS_RECID'];
}
if($rec['MULTIPLE_LOCATIONS'] == "0"
&& $rec['SERVICE_LOCATION'] != $rec['EQUIPMENT_LOCATION']
){
$eventParams['location_enabled'] = true;
$eventParams['location'] = $rec['SERVICE_LOCATION'];
}
if($rec['SERVICE_GLA'] != $rec['EQUIPMENT_GLA']){
$eventParams['gla_enabled'] = true;
$eventParams['gla'] = $rec['SERVICE_GLA'];
}
// Only trigger the bulk update if any of the options are enabled. Otherwise nothing is changing, there is no
// need to trigger a bulk update if nothing is changing.
if($eventParams['dept_hier_owner_enabled']
|| $eventParams['location_enabled']
|| $eventParams['gla_enabled']
|| $eventParams['contact_owner_enabled']
){
PCR_Event::trigger("equipment-bulk-update", $eventParams);
}
}