public function searchTerminatedByDomains($params, $allowed_domains)
{
$validDomains = [];
$this->load($params);
$userId = Yii::$app->user->getId();
$domains_name = [];
foreach ($allowed_domains as $domain) {
$domains_name[] = $domain->name;
}
$connPaths = [];
if ($this->src_domain && $this->dst_domain) {
//if(in_array($this->src_domain, $domains_name) && in_array($this->dst_domain, $domains_name)){
$dstPaths = ConnectionPath::findBySql("\n SELECT cp1.conn_id\n FROM (\n SELECT conn_id, MAX(`path_order`) AS last_path\n FROM `meican_connection_path`\n GROUP BY `conn_id`\n ) cp2\n JOIN `meican_connection_path` cp1\n ON cp1.conn_id = cp2.conn_id AND cp1.domain = '" . $this->dst_domain . "' AND cp1.path_order = cp2.last_path")->asArray()->all();
$allowedConns = [];
foreach ($dstPaths as $dstPath) {
$allowedConns[] = $dstPath['conn_id'];
}
//filtra por conn aceitas pela query anterior
$connPaths = ConnectionPath::find()->where(['in', 'domain', [$this->src_domain]])->andWhere(['path_order' => 0])->andWhere(['in', 'conn_id', $allowedConns])->select(["conn_id"])->distinct(true)->asArray()->all();
//}
} elseif ($this->src_domain) {
//if(in_array($this->src_domain, $domains_name)){
$connPaths = ConnectionPath::find()->where(['in', 'domain', [$this->src_domain]])->andWhere(['path_order' => 0])->select(["conn_id"])->distinct(true)->asArray()->all();
//}
} elseif ($this->dst_domain) {
//if(in_array($this->dst_domain, $domains_name)){
$connPaths = ConnectionPath::findBySql("\n SELECT cp1.conn_id\n FROM (\n SELECT conn_id, MAX(`path_order`) AS last_path\n FROM `meican_connection_path`\n GROUP BY `conn_id`\n ) cp2\n JOIN `meican_connection_path` cp1\n ON cp1.conn_id = cp2.conn_id AND cp1.domain = '" . $this->dst_domain . "' AND cp1.path_order = cp2.last_path")->asArray()->all();
//}
} else {
foreach ($allowed_domains as $domain) {
$validDomains[] = $domain->name;
}
$connPaths = ConnectionPath::find()->where(['in', 'domain', $validDomains])->select(["conn_id"])->distinct(true)->asArray()->all();
}
$validConnIds = [];
foreach ($connPaths as $connPath) {
$validConnIds[] = $connPath['conn_id'];
}
$validConns = Connection::find()->where(['in', 'id', $validConnIds])->select('reservation_id')->distinct(true)->asArray()->all();
$validIds = [];
foreach ($validConns as $conn) {
$validIds[] = $conn['reservation_id'];
}
$invalidConnections = Connection::find()->where(['>=', 'finish', DateUtils::now()])->andWhere(['status' => ["PENDING", "CREATED", "CONFIRMED", "SUBMITTED", "PROVISIONED"]])->select(["reservation_id"])->distinct(true)->asArray()->all();
$invalidIds = [];
foreach ($invalidConnections as $conn) {
$invalidIds[] = $conn['reservation_id'];
}
if (!$this->src_domain && !$this->dst_domain) {
$reservations = Reservation::find()->where(['in', 'id', $validIds])->orWhere(['request_user_id' => Yii::$app->user->getId()])->andWhere(['not in', 'id', $invalidIds])->andWhere(['type' => self::TYPE_NORMAL])->orderBy(['date' => SORT_DESC])->asArray()->all();
} else {
$reservations = Reservation::find()->where(['not in', 'id', $invalidIds])->andWhere(['in', 'id', $validIds])->andWhere(['type' => self::TYPE_NORMAL])->orderBy(['date' => SORT_DESC])->asArray()->all();
}
$validResIds = [];
foreach ($reservations as $res) {
if ($res['request_user_id'] == $userId) {
$validResIds[] = $res['id'];
} else {
if (!$this->request_user) {
$conns = Connection::find()->where(['reservation_id' => $res['id']])->select(["id"])->asArray()->all();
if (!empty($conns)) {
$conn_ids = [];
foreach ($conns as $conn) {
$conn_ids[] = $conn['id'];
}
$paths = ConnectionPath::find()->where(['in', 'domain', $domains_name])->andWhere(['in', 'conn_id', $conn_ids])->select(["conn_id"])->distinct(true)->asArray()->all();
if (!empty($paths)) {
$validResIds[] = $res['id'];
}
}
}
}
}
$dataProvider = new ActiveDataProvider(['query' => Reservation::find()->where(['in', 'id', $validResIds])->orderBy(['date' => SORT_DESC]), 'sort' => false, 'pagination' => ['pageSize' => 10]]);
return $dataProvider;
}
