portal.mkgtu.ru/common/modules/abiturient/traits/bachelor/BachelorApplicationAutofill...

148 lines
5.1 KiB
PHP
Executable File

<?php
namespace common\modules\abiturient\traits\bachelor;
use common\components\IndependentQueryManager\IndependentQueryManager;
use common\models\dictionary\Speciality;
use common\modules\abiturient\models\bachelor\AdmissionCampaign;
use common\modules\abiturient\models\bachelor\BachelorApplication;
use common\modules\abiturient\models\bachelor\BachelorSpeciality;
use common\modules\abiturient\models\repositories\SpecialityRepository;
use Yii;
use yii\db\ActiveQuery;
use yii\db\Query;
trait BachelorApplicationAutofillSpecialityTrait
{
public function getSpecialitiesForAutofillQuery(): ActiveQuery
{
$budgetBasisGuid = Yii::$app->configurationManager->getCode('budget_basis_guid');
$targetReceptionGuid = Yii::$app->configurationManager->getCode('target_reception_guid');
$tnCampaigns = '{{%campaigns}}';
$tnSpeciality = Speciality::tableName();
$tnAdmissionCampaign = AdmissionCampaign::tableName();
$tnBachelorSpeciality = BachelorSpeciality::tableName();
$tnEducationSource = '{{%education_source_ref}}';
$queryCampaignRefId = $this->getType()
->select("{$tnAdmissionCampaign}.ref_id")
->joinWith('campaign');
$querySpecialitiesIsNotOnlyBudgetCategory = Speciality::find()
->select("{$tnSpeciality}.curriculum_ref_id")
->active()
->joinWith('educationSourceRef education_source_ref', false)
->andWhere(['IN', "{$tnSpeciality}.campaign_ref_id", $queryCampaignRefId])
->andWhere([
'IN',
"{$tnSpeciality}.id",
$this
->getSpecialitiesWithoutOrdering()
->select("{$tnBachelorSpeciality}.speciality_id")
])
->andWhere([
'OR',
['IN', "{$tnEducationSource}.reference_uid", [$targetReceptionGuid]],
["{$tnSpeciality}.special_right" => true]
]);
$excludeSpecialtyIds = [];
$session = Yii::$app->session;
if ($session->has('notSelectedSpecialtyIds')) {
$excludeSpecialtyIds = $session->get('notSelectedSpecialtyIds');
}
return Speciality::find()
->active()
->joinWith('educationSourceRef education_source_ref', false)
->joinWith('educationFormRef education_form_ref', false)
->joinWith('detailGroupRef detail_group_ref', false)
->joinWith('campaignRef campaign_ref', false)
->leftJoin(
[$tnCampaigns => SpecialityRepository::getAdmissionCampaignQuery()],
SpecialityRepository::getJoinQueryForAdmissionCampaign(),
)
->andWhere(["{$tnSpeciality}.special_right" => false])
->andWhere(['NOT IN', "{$tnSpeciality}.id", $excludeSpecialtyIds])
->andWhere(['IN', "{$tnSpeciality}.campaign_ref_id", $queryCampaignRefId])
->andWhere(['IN', "{$tnEducationSource}.reference_uid", [$budgetBasisGuid]])
->andWhere(['IN', "{$tnSpeciality}.curriculum_ref_id", $querySpecialitiesIsNotOnlyBudgetCategory])
->andWhere(['>=', IndependentQueryManager::strToDateTime("{$tnCampaigns}.date_final"), date('Y-m-d H:i:s')])
->andWhere(['<=', IndependentQueryManager::strToDateTime("{$tnCampaigns}.date_start"), date('Y-m-d H:i:s')]);
}
public function hasSpecialitiesForAutofill(): bool
{
if ($this->status != BachelorApplication::STATUS_CREATED) {
return false;
}
$tnSpeciality = Speciality::tableName();
$tnBachelorSpeciality = BachelorSpeciality::tableName();
$baseQuery = $this->getSpecialitiesForAutofillQuery()
->groupBy("{$tnSpeciality}.id");
$requiredQuantity = (new Query())
->select(['COUNT(*)'])
->from(['required_table' => $baseQuery]);
$availableQuantity = (new Query())
->select(['COUNT(*)'])
->from(['available_table' => $this
->getSpecialitiesWithoutOrdering()
->andWhere([
'IN',
"{$tnBachelorSpeciality}.speciality_id",
$baseQuery->select("{$tnSpeciality}.id")
])]);
$havingQuery = (Yii::$app->db->driverName === 'pgsql') ?
'"required_quantity" != "available_quantity"' :
'`required_quantity` != `available_quantity`';
return (new Query())
->from(['comparing_table' => (new Query())->select([
'required_quantity' => $requiredQuantity,
'available_quantity' => $availableQuantity,
])])
->groupBy(['required_quantity', 'available_quantity'])
->having($havingQuery)
->exists();
}
public function getSpecialitiesForAutofill(): array
{
$tnSpeciality = Speciality::tableName();
return $this
->getSpecialitiesForAutofillQuery()
->select("{$tnSpeciality}.id")
->groupBy("{$tnSpeciality}.id")
->column();
}
}