public function searchByDomains($params, $domains)
{
$validDomains = [];
$this->load($params);
if ($this->domain_name) {
Yii::trace($this->domain_name);
$domain = Domain::findOne(['name' => $this->domain_name]);
$devices = Device::find()->where(['domain_id' => $domain->id]);
} else {
foreach ($domains as $domain) {
$validDomains[] = $domain->id;
}
$devices = Device::find()->where(['in', 'domain_id', $validDomains]);
}
$dataProvider = new ActiveDataProvider(['query' => $devices, 'sort' => false, 'pagination' => ['pageSize' => 15]]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getDevice()
{
return $this->hasOne(Device::className(), ['id' => 'device_id']);
}
private function importDevices($devicesArray, $domainName, $invalidDevices, $netUrn = null)
{
$validDevices = [];
//VERIFICA PORTAS
$validBiPorts = [];
if ($this->parser instanceof NMWGParser) {
$type = Port::TYPE_NMWG;
//$invalidBiPorts = Port::find()->where(['type'=>$type]);
$invalidBiPorts = false;
} else {
$type = Port::TYPE_NSI;
$net = Network::findByUrn($netUrn)->one();
if ($net) {
$invalidBiPorts = Port::find()->where(['type' => $type, 'directionality' => Port::DIR_BI, 'network_id' => $net->id]);
} else {
$invalidBiPorts = false;
}
}
foreach ($devicesArray as $deviceNode => $deviceData) {
$device = Device::findOneByDomainAndNode($domainName, $deviceNode);
if (!$device) {
$change = $this->buildChange();
$change->type = Change::TYPE_CREATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_DEVICE;
$change->data = json_encode(['node' => $deviceNode, 'lat' => isset($deviceData["lat"]) ? $deviceData['lat'] : null, 'lng' => isset($deviceData["lng"]) ? $deviceData['lng'] : null, 'address' => isset($deviceData["address"]) ? $deviceData['address'] : null]);
$change->save();
} else {
$validDevices[] = $device->id;
if (isset($deviceData['lat']) && isset($deviceData['lng']) && (intval($device->latitude) != intval($deviceData['lat']) || intval($device->longitude) != intval($deviceData['lng']))) {
$change = $this->buildChange();
$change->type = Change::TYPE_UPDATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_DEVICE;
$change->item_id = $device->id;
$change->data = json_encode(['node' => $deviceNode, 'lat' => $deviceData['lat'], 'lng' => $deviceData['lng'], 'address' => $deviceData['address']]);
$change->save();
}
}
foreach ($deviceData["biports"] as $urnString => $portData) {
$port = Port::findByUrn($urnString)->one();
if (!$port) {
$change = $this->buildChange();
$change->type = Change::TYPE_CREATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_BIPORT;
$change->data = json_encode(['netUrn' => $netUrn, 'node' => $deviceNode, 'urn' => $urnString, 'type' => $type, 'name' => $portData["port"], 'cap_max' => isset($portData["capMax"]) ? $portData["capMax"] : null, 'cap_min' => isset($portData["capMin"]) ? $portData["capMin"] : null, 'granu' => isset($portData["granu"]) ? $portData["granu"] : null, 'vlan' => isset($portData["vlan"]) ? $portData["vlan"] : null]);
$change->save();
} else {
$validBiPorts[] = $port->id;
}
if ($this->parser instanceof NMWGParser) {
//PERFSONAR
$srcPort = Port::findByUrn($urnString)->one();
if (isset($portData['aliasUrn'])) {
$dstPort = Port::findByUrn($portData['aliasUrn'])->one();
if (!$dstPort || !$srcPort || $srcPort->alias_id != $dstPort->id) {
$change = $this->buildChange();
$change->domain = $domainName;
$change->type = $srcPort ? $srcPort->alias_id ? Change::TYPE_UPDATE : Change::TYPE_CREATE : Change::TYPE_CREATE;
$change->item_type = Change::ITEM_TYPE_LINK;
$change->data = json_encode(['node' => $deviceNode, 'port' => $portData["port"], 'urn' => $urnString, 'dst_urn' => $portData['aliasUrn']]);
$change->save();
}
} elseif ($srcPort && $srcPort->alias_id) {
$change = $this->buildChange();
$change->type = Change::TYPE_DELETE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_LINK;
$change->item_id = $srcPort->id;
$change->data = json_encode(['' => '']);
$change->save();
}
} else {
foreach ($portData["uniports"] as $uniPortUrn => $uniPortData) {
$uniport = Port::findByUrn($uniPortUrn)->one();
if (!$uniport) {
$change = $this->buildChange();
$change->type = Change::TYPE_CREATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_UNIPORT;
$change->data = json_encode(['netUrn' => $netUrn, 'node' => $deviceNode, 'type' => Port::TYPE_NSI, 'dir' => $uniPortData['type'], 'urn' => $uniPortUrn, 'biPortUrn' => $urnString, 'biPort' => $portData["port"], 'name' => $uniPortData["port"], 'cap_max' => isset($uniPortData["capMax"]) ? $uniPortData["capMax"] : null, 'cap_min' => isset($uniPortData["capMin"]) ? $uniPortData["capMin"] : null, 'granu' => isset($uniPortData["granu"]) ? $uniPortData["granu"] : null, 'vlan' => isset($uniPortData["vlan"]) ? $uniPortData["vlan"] : null]);
$change->save();
} else {
//update port
if (isset($uniPortData["vlan"]) && $uniport->vlan_range != $uniPortData['vlan']) {
$change = $this->buildChange();
$change->type = Change::TYPE_UPDATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_UNIPORT;
$change->item_id = $uniport->id;
$change->data = json_encode(['vlan' => $uniPortData["vlan"]]);
$change->save();
}
}
if (isset($uniPortData['aliasUrn'])) {
$dstPort = Port::findByUrn($uniPortData['aliasUrn'])->one();
if (!$dstPort || !$uniport || $uniport->alias_id != $dstPort->id) {
$change = $this->buildChange();
$change->type = $uniport ? $uniport->alias_id ? Change::TYPE_UPDATE : Change::TYPE_CREATE : Change::TYPE_CREATE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_LINK;
$change->data = json_encode(['node' => $deviceNode, 'port' => $uniPortData["port"], 'urn' => $uniPortUrn, 'dst_urn' => $uniPortData['aliasUrn']]);
$change->save();
}
} elseif ($uniport && $uniport->alias_id) {
$change = $this->buildChange();
$change->type = Change::TYPE_DELETE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_LINK;
$change->item_id = $uniport->id;
$change->data = json_encode(['' => '']);
$change->save();
}
}
}
}
}
if ($invalidBiPorts) {
$invalidBiPorts = $invalidBiPorts->andWhere(['not in', 'id', $validBiPorts])->all();
foreach ($invalidBiPorts as $port) {
$change = $this->buildChange();
$change->type = Change::TYPE_DELETE;
$change->domain = $domainName;
$change->item_type = Change::ITEM_TYPE_BIPORT;
$change->item_id = $port->id;
$change->data = json_encode(["node" => $port]);
$change->save();
}
}
if ($invalidDevices) {
$invalidDevices->andWhere(['not in', 'id', $validDevices]);
}
}
public function actionGetParentLocation($id)
{
$temp = Json::encode(Device::findOneParentLocation($id));
Yii::trace($temp);
return $temp;
}
public function actionGetDevicePorts($dom = null, $type = null)
{
if ($dom != null) {
$validDevs = Device::find()->where(['domain_id' => $dom])->asArray()->select('id')->all();
$devs = [];
foreach ($validDevs as $value) {
$devs[] = $value['id'];
}
$portsWithAlias = Port::find()->where(['in', 'device_id', $devs])->andWhere(['type' => $type])->select(['id', 'name', 'directionality', 'max_capacity', 'device_id', 'alias_id'])->all();
} else {
$portsWithAlias = Port::find()->select(['id', 'name', 'directionality', 'max_capacity', 'device_id', 'alias_id'])->all();
}
$ports = [];
foreach ($portsWithAlias as $port) {
$devId1 = $port->device_id;
$aliasPort = $port->getAlias()->select(['id', 'device_id'])->asArray()->one();
$devId2 = $aliasPort['device_id'];
isset($ports[$devId1]) ? null : ($ports[$devId1] = []);
$devId2 ? isset($ports[$devId2]) ? null : ($ports[$devId2] = []) : null;
if (!in_array($port->id, $ports[$devId1])) {
$ports[$devId1][$port->id] = ['dir' => $port->directionality, 'name' => $port->name, 'cap' => $port->max_capacity, 'link' => ['dev' => $devId2, 'port' => $aliasPort['id']]];
}
}
Yii::trace($ports);
return json_encode($ports);
}
static function findOneParentLocation($id)
{
$dev = Device::find()->where(['id' => $id])->select(['id', 'name', 'latitude', 'longitude', 'domain_id'])->one();
if (!$dev) {
return null;
}
if ($dev->latitude != null) {
return $dev;
}
foreach ($dev->getPorts()->select(['network_id'])->distinct(true)->all() as $port) {
$net = $port->getNetwork()->select(['latitude', 'longitude'])->asArray()->one();
if ($net && $net['latitude']) {
$dev->latitude = $net['latitude'];
$dev->longitude = $net['longitude'];
return $dev;
}
}
$prov = Provider::find()->where(['domain_id' => $dev->domain_id])->select(['latitude', 'longitude'])->asArray()->one();
if ($prov) {
$dev->latitude = $prov['latitude'];
$dev->longitude = $prov['longitude'];
}
return $dev;
}
public function actionGetStp($id)
{
$dev = Device::findOneParentLocation($id);
$dom = $dev->getDomain()->select(['name'])->one()->name;
$data = [];
$data['id'] = $id;
$data["dom"] = $dom;
$data["name"] = $dev->name;
$data['lat'] = $dev->latitude;
$data['lng'] = $dev->longitude;
$data = json_encode($data);
Yii::trace($data);
return $data;
}
public function actionEditorUpdate($id = null)
{
$this->layout = 'wireit';
if ($id) {
$workflow = BpmWorkflow::findOne(['id' => $id]);
if ($workflow) {
$domain = Domain::findOne(['name' => $workflow->domain]);
if ($domain) {
if (!self::can('workflow/update', $domain->name)) {
if (!self::can("workflow/read")) {
return $this->goHome();
} else {
Yii::$app->getSession()->setFlash('warning', Yii::t("bpm", 'You are not allowed to edit in domain {domain}', ['domain' => $domain->name]));
return $this->redirect(array('/bpm/workflow/index'));
}
}
$ownerDomain = [];
$ownerDomain[$domain->name] = $domain->name;
$domains = Domain::find()->orderBy(['name' => SORT_ASC])->all();
$allDomains = [];
foreach ($domains as $dom) {
$allDomains[$dom->name] = $dom->name;
}
$roles = $domain->getUserDomainsRoles()->all();
$adminsNames = [];
foreach ($roles as $role) {
$adminsNames[$role->getUser()->id] = $role->getUser()->name;
}
foreach (User::find()->all() as $user) {
$usersNames[$user->id] = $user->name;
}
$groupsNames = [];
foreach (Group::find()->where(['type' => Group::TYPE_DOMAIN, 'domain' => $domain->name])->orWhere(['type' => Group::TYPE_DOMAIN, 'domain' => null])->all() as $group) {
$groupsNames[$group->id] = $group->name;
}
$devicesNames = [];
foreach (Device::find()->where(['domain_id' => $domain->id])->all() as $device) {
$devicesNames[$device->id] = $device->name;
}
Yii::trace($roles);
Yii::trace($usersNames);
Yii::trace($groupsNames);
Yii::trace($devicesNames);
return $this->render('editor', array('owner_domain' => $ownerDomain, 'domains' => $allDomains, 'groups' => $groupsNames, 'users' => $usersNames, 'admins' => $adminsNames, 'devices' => $devicesNames, 'id' => $_GET['id']));
}
}
}
if (!self::can("workflow/read")) {
return $this->goHome();
} else {
return $this->redirect(array('/bpm/workflow/index'));
}
}
public function getBiPorts()
{
$portsArray = [];
$devices = Device::find()->where(['domain_id' => $this->id])->all();
foreach ($devices as $device) {
$ports = Port::find()->where(['device_id' => $device->id, 'type' => Port::TYPE_NSI, 'directionality' => Port::DIR_BI])->all();
foreach ($ports as $port) {
$portsArray[$port->id] = $port;
}
}
return $portsArray;
}
public function getDetails()
{
$data = json_decode($this->data);
switch ($this->type) {
case self::TYPE_DELETE:
switch ($this->item_type) {
case self::ITEM_TYPE_DOMAIN:
return Yii::t('topology', 'Domain');
case self::ITEM_TYPE_PROVIDER:
return Yii::t('topology', '<b>Provider</b>: {name}, <b>Type</b>: {type}', ['name' => $data->name, 'type' => $data->type]);
case self::ITEM_TYPE_PEERING:
return "";
case self::ITEM_TYPE_SERVICE:
return Yii::t('topology', 'Domain');
case self::ITEM_TYPE_NETWORK:
return Yii::t('topology', 'Network');
case self::ITEM_TYPE_DEVICE:
return $data->node;
case self::ITEM_TYPE_BIPORT:
$port = Port::findOne($this->item_id);
return $port ? $port->name : '';
case self::ITEM_TYPE_UNIPORT:
return Yii::t('topology', 'Port');
case self::ITEM_TYPE_LINK:
return '';
default:
return Yii::t('topology', 'Error');
}
case self::TYPE_UPDATE:
switch ($this->item_type) {
case self::ITEM_TYPE_DOMAIN:
return Yii::t('topology', 'Domain');
case self::ITEM_TYPE_PROVIDER:
$prov = Provider::findOne($this->item_id);
return Yii::t('topology', 'To: <b>Provider</b>: {name}, <b>Type</b>: {type}, <b>Latitude</b>: {lat}' . ', <b>Longitude</b>: {lng}', ['name' => $data->name, 'type' => $data->type, 'lat' => $data->lat, 'lng' => $data->lng]);
case self::ITEM_TYPE_PEERING:
return "";
case self::ITEM_TYPE_SERVICE:
return Yii::t('topology', 'Domain');
case self::ITEM_TYPE_NETWORK:
return Yii::t('topology', 'Network');
case self::ITEM_TYPE_DEVICE:
$dev = Device::findOne($this->item_id);
return Yii::t('topology', '<b>Device</b>: {node}<br><b>Latitude</b>: {lat}, <b>Longitude</b>: {lng}', ['node' => $data->node, 'lat' => $data->lat, 'lng' => $data->lng]);
case self::ITEM_TYPE_BIPORT:
return Yii::t('topology', 'Port');
case self::ITEM_TYPE_UNIPORT:
$port = Port::findOneArraySelect($this->item_id, ['urn']);
$vlan = $data->vlan ? Yii::t('topology', ' - <b>VLAN Range</b>: {vlan}', ['vlan' => $data->vlan]) : "";
return Yii::t('topology', '<b>Unidirectional Port</b>: {urn}', ['urn' => $port['urn']]) . $vlan;
case self::ITEM_TYPE_LINK:
return Yii::t('topology', '<b>Link to Port</b>: {dst_urn}', ['dst_urn' => $data->dst_urn]);
default:
return Yii::t('topology', 'Error');
}
case self::TYPE_CREATE:
switch ($this->item_type) {
case self::ITEM_TYPE_DOMAIN:
return "";
case self::ITEM_TYPE_PROVIDER:
return Yii::t('topology', '<b>Provider</b>: {name}<br><b>Type</b>: {type}<br><b>Latitude</b>: {lat}' . ', <b>Longitude</b>: {lng}', ['name' => $data->name, 'type' => Provider::getTypeLabels()[$data->type], 'lat' => $data->lat, 'lng' => $data->lng]);
case self::ITEM_TYPE_PEERING:
return Yii::t('topology', '<b>Provider</b>: {nsa}<br><b>Peering with</b>: {dstNsaId}', ['nsa' => $data->srcNsaId, 'dstNsaId' => $data->dstNsaId]);
case self::ITEM_TYPE_SERVICE:
return Yii::t('topology', '<b>Provider</b>: {nsa}<br><b>Service</b>: {type}<br><b>URL</b>: {url}', ['nsa' => $data->provNsa, 'url' => $data->url, 'type' => Service::getTypeLabels()[$data->type]]);
case self::ITEM_TYPE_NETWORK:
$location = $data->lat ? Yii::t('topology', '<br><b>Latitude</b>: {lat}, <b>Longitude</b>: {lng}', ['lat' => $data->lat, 'lng' => $data->lng]) : "";
return Yii::t('topology', '<b>Network</b>: {urn}', ['urn' => $data->urn]) . $location;
case self::ITEM_TYPE_DEVICE:
$location = $data->lat ? Yii::t('topology', '<br><b>Latitude</b>: {lat}, <b>Longitude</b>: {lng}', ['lat' => $data->lat, 'lng' => $data->lng]) : "";
return Yii::t('topology', '<b>Device</b>: {node}', ['node' => $data->node]) . $location;
case self::ITEM_TYPE_BIPORT:
$vlan = $data->vlan ? Yii::t('topology', '<br><b>VLAN Range</b>: {vlan}', ['vlan' => $data->vlan]) : "";
return Yii::t('topology', '<b>Device</b>: {node}<br><b>Port</b>: {urn}', ['urn' => $data->urn, 'node' => $data->node]) . $vlan;
case self::ITEM_TYPE_UNIPORT:
$vlan = $data->vlan ? Yii::t('topology', '<br><b>VLAN Range</b>: {vlan}', ['vlan' => $data->vlan]) : "";
return Yii::t('topology', '<b>Bidirectional Port</b>: {biPortUrn}<br><b>Port</b>: {urn}', ['urn' => $data->urn, 'biPortUrn' => $data->biPortUrn]) . $vlan;
case self::ITEM_TYPE_LINK:
return Yii::t('topology', '<b>From</b>: {src}<br><b>To</b>: {dst}', ['dst' => $data->dst_urn, 'src' => $data->urn]);
default:
return Yii::t('topology', 'Error');
}
}
}