public function actionIndex()
{
//Get the preferences model
$preferences = new Preferences();
// Make an user model from current user
$person = \Yii::$app->user->identity;
if (isset(\Yii::$app->request->post()['Preferences'])) {
$preferences->load(\Yii::$app->request->post());
$preferences->saveForUser($person);
}
// Fill preferences with user preferences
$preferences->fillForUser($person);
// Show data as form
return $this->render("index", ["model" => $person, "preferences" => $preferences]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Preferences::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['pref_ID' => $this->pref_ID]);
$query->andFilterWhere(['like', 'pref_name', $this->pref_name])->andFilterWhere(['like', 'pref_value', $this->pref_value]);
return $dataProvider;
}
// Form 1 : Decisions per month pew organizations
echo Html::beginForm('index.php?r=results/resultsb21afmorg', 'post');
// 2. Show selected Organisations
echo '<label class="control-label">Οργανισμοί</label>';
echo Select2::widget(['name' => 'select_orgs', 'data' => $currentOrgs, 'value' => '', 'options' => ['placeholder' => 'Οργανισμός...', 'multiple' => false]]);
echo Html::textInput("set_afm");
?>
<br>
<?php
echo Html::submitButton('Εμφάνιση');
?>
<br>
<?php
echo Html::endForm();
?>
</div>
</div>
</div>
<p>
<?php
$updateDate = Preferences::getRefreshDate();
echo '<br><br><label class="control-label">Τελευταία Ενημέρωση: </label>';
echo '<label class="control-label">' . $updateDate[0] . '</label>';
?>
</p>
<?php use yii\helpers\Html; use app\models\Preferences; use yii\widgets\ActiveForm; ?> <div class="preferences"> <?php echo $form->field($model, 'durations')->checkboxlist(Preferences::getDurationsList()); ?> <?php echo $form->field($model, 'workTypes')->checkboxlist(Preferences::getWorkTypesList()); ?> <?php echo !$no_courses ? $form->field($model, 'courses')->checkboxlist(Preferences::getCoursesList()) : ""; ?> </div>
/**
* Finds the Preferences model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Preferences the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Preferences::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionRefreshdataajax()
{
$currentOrgs = Preferences::getSelectedOrgIds();
//print_r($currentOrgs);
$currentTypes = Preferences::getSelectedTypes();
//print_r($currentTypes);
$currentDates = Preferences::getSelectedDates();
//print_r($currentDates);
$pages = 0;
$b21_counter = 0;
$client = new \OpendataClient();
$client->setAuth('apiuser_1', 'ApiUser@1');
foreach ($currentOrgs as $corg) {
$pages = 0;
foreach ($currentTypes as $ctype) {
$string = "/search?org=" . $corg . "&type=" . $ctype . "&size=500&from_date=" . $currentDates[0] . "&to_date=" . $currentDates[1] . "&page=" . $pages;
//print ($string);
$response = $client->getResource($string);
if ($response->code === 200) {
$unitData = $response->data;
$sum = 0.0;
$counter = 1;
$actual_size = 1;
$breakOrg = 0;
while ($actual_size != 0) {
foreach ($unitData['decisions'] as $unit) {
try {
//print_r($unit);
Yii::$app->db->createCommand()->insert('decisions', ['ada' => $unit['ada'], 'protocolNumber' => $unit['protocolNumber'], 'subject' => $unit['subject'], 'issueDate' => gmdate("Y-m-d", $unit['issueDate'] / 1000), 'decisionTypeId' => $unit['decisionTypeId'], 'organizationId' => $unit['organizationId'], 'submissionTimestamp' => gmdate("Y-m-d", $unit['submissionTimestamp'] / 1000), 'versionId' => $unit['versionId'], 'status' => $unit['status'], 'url' => $unit['documentUrl'], 'documentChecksum' => $unit['documentChecksum'], 'correctedVersionId' => $unit['correctedVersionId']])->execute();
$b21_counter++;
$orgData = $unit['extraFieldValues']['org'];
//foreach ($orgData as $org) {
//print_r($orgData);
if (isset($orgData['enterName']['name'])) {
$Name = $orgData['enterName']['name'];
} else {
$Name = '-';
}
if (isset($orgData['afmCountry'])) {
$Country = $orgData['afmCountry'];
} else {
$Country = '';
}
Yii::$app->db->createCommand()->insert('decisionsb21', ['b21_ada' => $unit['ada'], 'afm' => $orgData['afm'], 'afmType' => $orgData['afmType'], 'afmCountry' => $Country, 'enterName' => '1', 'name' => $Name])->execute();
//}
$sponsorData = $unit['extraFieldValues']['sponsor'];
//print_r($sponsorData);
foreach ($sponsorData as $sponsor1) {
// Expense Amount DATA
if (!isset($sponsor1['expenseAmount']['kae'])) {
$kae = null;
} else {
$kae = $sponsor1['expenseAmount']['kae'];
}
if (!isset($sponsor1['expenseAmount']['amount'])) {
$amount = null;
} else {
$amount = $sponsor1['expenseAmount']['amount'];
}
if (!isset($sponsor1['expenseAmount']['currency'])) {
$currency = null;
} else {
$currency = $sponsor1['expenseAmount']['currency'];
}
// Sponsor DATA
if (!isset($sponsor1['sponsorAFMName']['afmType'])) {
$afmType = null;
} else {
$afmType = $sponsor1['sponsorAFMName']['afmType'];
}
if (!isset($sponsor1['sponsorAFMName']['name'])) {
$name = null;
} else {
$name = $sponsor1['sponsorAFMName']['name'];
}
if (!isset($sponsor1['sponsorAFMName']['noVATOrg'])) {
$noVATOrg = null;
} else {
$noVATOrg = $sponsor1['sponsorAFMName']['noVATOrg'];
}
if (!isset($sponsor1['sponsorAFMName']['afm'])) {
$afm = null;
} else {
$afm = $sponsor1['sponsorAFMName']['afm'];
}
if (!isset($sponsor1['sponsorAFMName']['afmCountry'])) {
$afmCountry = null;
} else {
$afmCountry = $sponsor1['sponsorAFMName']['afmCountry'];
}
if (!isset($sponsor1['sponsorAFMName']['noVATOrg'])) {
$noVATOrg = null;
} else {
$noVATOrg = $sponsor1['sponsorAFMName']['noVATOrg'];
}
// CPV DATA
if (!isset($sponsor1['cpv'])) {
$cpv = "-";
} else {
$cpv = $sponsor1['cpv'];
}
Yii::$app->db->createCommand()->insert('sponsor', ['sp_ada' => $unit['ada'], 'afm' => $afm, 'afmType' => $afmType, 'afmCountry' => $afmCountry, 'enterName' => '1', 'name' => $name, 'noVATOrg' => $noVATOrg, 'kae' => $kae, 'amount' => $amount, 'currency' => $currency, 'cpv' => $cpv])->execute();
/*Yii::$app->db->createCommand()->insert('cpvperdecisions', [
'cpd_ada' => $unit['ada'],
'cpd_cpv' => $cpv,
])->execute();*/
}
$counter++;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n<br>";
$exc = $e->getMessage();
//if (strstr($exc, "1062 Duplicate entry") != FALSE){
//$breakOrg = 1;
//break;
//}
}
}
$pages++;
$string = "/search?org=" . $corg . "&type=" . $ctype . "&size=500&from_date=" . $currentDates[0] . "&to_date=" . $currentDates[1] . "&page=" . $pages;
$response = $client->getResource($string);
$unitData = $response->data;
//echo "---" . $unitData['info']['actualSize'];
$actual_size = $unitData['info']['actualSize'];
if ($actual_size == NULL) {
$actualSize = 1;
} else {
if ($actual_size == 0) {
break;
}
}
unset($unit);
unset($orgData);
unset($kae);
unset($afmType);
//unset($cpv);
unset($afmType);
unset($name);
unset($amount);
//if ($breakOrg == 1) {
//$actualSize = 0;
// break;
//}
}
} else {
echo "Error " . $response->code;
}
}
}
// Update TimeStamp
$mysqltime = date("d-m-Y H:i:s");
Yii::$app->db->createCommand("DELETE FROM preferences WHERE pref_name LIKE 'lastrefreshdate'")->execute();
Yii::$app->db->createCommand("INSERT INTO preferences (pref_name, pref_value) VALUES ('lastrefreshdate','" . $mysqltime . "')")->execute();
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['message' => $b21_counter + ' ΑΠΟΦΑΣΕΙΣ ΤΥΠΟΥ Β.2.1 ΠΡΟΣΤΕΘΗΚΑΝ', 'code' => $b21_counter];
}
public function actionResultsb21afmorg()
{
if (!isset($_POST['select_orgs']) || empty($_POST['select_orgs'])) {
$orgID1 = Preferences::findOne(['pref_name' => 'Resultsb21afmorgID']);
$orgID = $orgID1->pref_value;
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgID']);
} else {
$orgID = $_POST['select_orgs'];
}
if (!isset($_POST['set_afm']) || empty($_POST['set_afm'])) {
$afm1 = Preferences::findOne(['pref_name' => 'Resultsb21afmorgcpv']);
$afm = $afm1->pref_value;
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgcpv']);
} else {
$afm = $_POST['set_afm'];
}
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgID']);
Yii::$app->view->params['Resultsb21afmorgID'] = $orgID;
$pref = new Preferences();
$pref->pref_name = 'Resultsb21afmorgID';
$pref->pref_value = $orgID;
$pref->save();
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgcpv']);
Yii::$app->view->params['Resultsb21afmorgcpv'] = $afm;
$pref = new Preferences();
$pref->pref_name = 'Resultsb21afmorgcpv';
$pref->pref_value = $afm;
$pref->save();
return $this->render('resultsb21afmorg');
}
public function createnewstep3()
{
$model = new Vacancy();
$preferences = new Preferences();
$data = Yii::$app->request->post();
$model->load($data);
$preferences->load($data);
$transaction = \Yii::$app->db->beginTransaction();
try {
//TODO check for errors and cancel transaction
$model->save();
$model->savePreferences($preferences);
$connection = \Yii::$app->db;
// TODO Place this in preferences logic
$connection->createCommand("INSERT INTO person_vacancy_role (person_id, vacancy_id, role_id) " . "VALUES (:person_id, :vacancy_id, :role_id)")->bindValues([":person_id" => \YII::$app->getUser()->getIdentity()->getId(), ":vacancy_id" => $model->getPrimaryKey(), ":role_id" => VacancyRoleHelper::OWNER])->execute();
// Vacanty - course_id
$course_id = $this->getSession()['create-new-vacancy-course-id'];
if (isset($course_id) && $course_id != "none") {
$connection->createCommand("INSERT INTO course_vacancy (course_id, vacancy_id) VALUES (:course_id, :vacancy_id)")->bindValues([":course_id" => $course_id, ":vacancy_id" => $model->getPrimaryKey()])->execute();
}
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
return $this->actionView($model->id);
}
?>
<?php
$form = RoleBasedActiveForm::begin();
?>
<?php
echo $form->field($preferences, 'courses')->checkboxlist(Preferences::getCoursesList());
?>
<?php
echo $form->field($preferences, 'workTypes')->checkboxlist(Preferences::getWorkTypesList());
?>
<?php
echo $form->field($preferences, 'durations')->checkboxlist(Preferences::getDurationsList());
?>
<style>
.form-group {
float: left;
margin-right: 200px;
}
</style>
<div class="form-group">
<?php
echo Html::submitButton('Update', ['class' => 'btn btn-primary']);
$this->params['breadcrumbs'][] = $this->title;
?>
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<div class="row">
<div style="text-align: justify;" class="col-lg-12">
<?php
$currentOrgs = Preferences::getSelectedOrgIds();
//print_r($currentOrgs);
$currentTypes = Preferences::getSelectedTypes();
//print_r($currentTypes);
$currentDates = Preferences::getSelectedDates();
//print_r($currentDates);
$pages = 0;
$client = new OpendataClient();
$client->setAuth('apiuser_1', 'ApiUser@1');
foreach ($currentOrgs as $corg) {
$pages = 0;
foreach ($currentTypes as $ctype) {
$string = "/search?org=" . $corg . "&type=" . $ctype . "&size=500&from_date=" . $currentDates[0] . "&to_date=" . $currentDates[1] . "&page=" . $pages;
//print ($string);
$response = $client->getResource($string);
if ($response->code === 200) {
$unitData = $response->data;
$sum = 0.0;
$counter = 1;
$actual_size = 1;
