/**
* Update last owner and operator for the fleet
* @since Version 3.9.1
* @return void
* @param \Railpage\Locos\LocoClass $Class
*/
public static function updateFleet_OwnerOperator(LocoClass $Class)
{
$Database = (new AppCore())->getDatabaseConnection();
$members = $Class->members();
foreach ($members['locos'] as $row) {
$Loco = LocosFactory::CreateLocomotive($row['loco_id']);
$query = "(SELECT operator_id AS owner_id, link_type FROM loco_org_link WHERE loco_id = ? AND link_type = 1 ORDER BY link_weight DESC LIMIT 0,1)\r\nUNION ALL\r\n(SELECT operator_id, link_type FROM loco_org_link WHERE loco_id = ? AND link_type = 2 ORDER BY link_weight DESC LIMIT 0,1)";
$result = $Database->fetchAll($query, array($Loco->id, $Loco->id));
#$commit = false;
foreach ($result as $row) {
#printArray($row['organisation_id']); printArray($Loco->owner_id); die;
if ($row['link_type_id'] == 1) {
$Loco->owner_id = $row['operator_id'];
#$commit = true;
}
if ($row['link_type_id'] == 2) {
$Loco->operator_id = $row['operator_id'];
#$commit = true;
}
}
#if ($commit) {
$Loco->commit();
#}
#break;
}
$Class->flushMemcached();
return;
}
