public function actionDeactivate()
{
Yii::app()->setImport(['application.modules.cargo.models.*']);
$condition = new CDbCriteria();
$condition->addCondition('TO_DAYS(NOW()) - TO_DAYS(`deleted_status_date`) > 15');
Product::model()->updateAll(['deleted_status' => Product::DEL_SATUS_ARCHIVE], $condition);
Cargo::model()->updateAll(['deleted_status' => Cargo::DEL_SATUS_ARCHIVE], $condition);
Reis::model()->updateAll(['deleted_status' => Reis::DEL_SATUS_ARCHIVE], $condition);
Sklad::model()->updateAll(['deleted_status' => Sklad::DEL_SATUS_ARCHIVE], $condition);
Custom::model()->updateAll(['deleted_status' => Custom::DEL_SATUS_ARCHIVE], $condition);
Insurance::model()->updateAll(['deleted_status' => Insurance::DEL_SATUS_ARCHIVE], $condition);
SpecialTechnique::model()->updateAll(['deleted_status' => SpecialTechnique::DEL_SATUS_ARCHIVE], $condition);
}
public function actionList($company_id = 0)
{
if ($company_id == 0) {
$company_id = Yii::app()->getUser()->getProfile()->company_id;
}
Yii::import('sklad.models.*');
$criteria = new CDbCriteria();
$criteria->with = ['user' => ['joinType' => 'INNER JOIN', 'condition' => 'user.company_id = :company_id']];
$criteria->addCondition('deleted_status != :deleted_status');
$criteria->params = [':company_id' => $company_id, ':deleted_status' => Sklad::DEL_SATUS_DELETED];
$criteria->order = 'sklad_id DESC';
$this->render('list', ['sklad' => Sklad::model()->findAll($criteria), 'company_id' => $company_id]);
}
<br />
<?php
}
?>
</td>
<td>
<?php
echo isset($data->address) ? '<span class="address-icon"></span>' . $data->address->name : '';
?>
</td>
<td>
<?php
foreach ($data->area as $area) {
?>
<?php
echo $area->price . ' ' . Yii::t('SkladModule.default', 'р') . ' <span>' . ($data->type_pay == Sklad::TYPE_RENT ? Sklad::enumSrok($area->srok) . ' ' : '') . Sklad::enumNds($area->nds_include) . '</span>';
?>
<br />
<?php
}
?>
</td>
<?php
if ($data->canWrite()) {
?>
<td>
<?php
$this->widget('bootstrap.widgets.TbButton', ['url' => '/storage/add/' . $data->sklad_id, 'buttonType' => 'link', 'label' => Yii::t('CabinetModule.default', 'Редактировать')]);
?>
<br>
<br>
</section>
</div>
<div class="row geo-search">
<section class="col-md-3">
<?php
echo $form->checkboxListGroup($SkladSearchForm, 'type', ['widgetOptions' => ['data' => Sklad::getType()]]);
?>
</section>
<section class="col-md-3 lease-terms">
<?php
echo $form->checkboxListGroup($SkladSearchForm, 'uslugi', ['widgetOptions' => ['data' => Sklad::getUslugi()]]);
?>
</section>
<section class="col-md-3 lease-terms">
<?php
echo $form->checkboxListGroup($SkladSearchForm, 'srok', ['widgetOptions' => ['data' => Sklad::getSrok()]]);
?>
</section>
</div>
<div class="row">
<section class="col-md-3">
<?php
$this->widget('bootstrap.widgets.TbButton', ['buttonType' => 'submit', 'htmlOptions' => ['name' => 'save', 'value' => 'save'], 'label' => Yii::t('CabinetModule.default', 'Сохранить')]);
?>
</section>
</div>
</div>
<?php
$this->endWidget();
?>
<script>
/**
* Запуск виджета
*/
public function run()
{
switch ($this->type) {
case 'store_add':
$product = Product::model()->find('t.slug = "' . $this->record_id . '"');
$criteria = new CDbCriteria();
$product->category_id = isset($product->category_id) ? $product->category_id : 1;
$criteria->condition = 't.category_id = ' . $product->category_id . ' AND t.status ="active"';
$criteria->limit = 5;
$storecalls = StoreCall::model()->findAll($criteria);
$this->render('store_add', ['storecalls' => $storecalls]);
break;
case 'store_call_add':
$storecall = StoreCall::model()->findByPk($this->record_id);
$criteria = new CDbCriteria();
$storecall->category_id = isset($storecall->category_id) ? $storecall->category_id : 1;
$criteria->condition = 't.category_id =' . $storecall->category_id . ' AND t.status ="1"';
$criteria->limit = 5;
$products = Product::model()->findAll($criteria);
$this->render('store_call_add', ['products' => $products]);
break;
case 'cargo_add':
$cargo = Cargo::model()->with('address_from', 'address_to')->findByPk($this->record_id);
$reissearchform = new ReisSearchForm();
$reissearchform->from_name = $cargo->address_from[0]->name;
$reissearchform->from_address_lat = $cargo->address_from[0]->lat;
$reissearchform->from_address_long = $cargo->address_from[0]->long;
$reissearchform->from_radius = $this->radius;
$reissearchform->to_name = $cargo->address_to[0]->name;
$reissearchform->to_address_lat = $cargo->address_to[0]->lat;
$reissearchform->to_address_long = $cargo->address_to[0]->long;
$reissearchform->to_radius = $this->radius;
$reisIds = $reissearchform->relatedReis();
if (!empty($reisIds)) {
$reis = Reis::model()->findAllByAttributes(array('reis_id' => $reisIds), array('order' => 'reis_id desc', 'limit' => 5));
} else {
$reis = array();
}
$this->render('cargo_add', ['reis' => $reis]);
break;
case 'transport_add':
$transport = Reis::model()->findByPk($this->record_id);
$transport->address_from;
$transport->address_to;
$cargosearchform = new CargoSearchForm();
$cargosearchform->from_name = $transport->address_from[0]->name;
$cargosearchform->from_address_lat = $transport->address_from[0]->lat;
$cargosearchform->from_address_long = $transport->address_from[0]->long;
$cargosearchform->from_radius = $this->radius;
if (!empty($transport->address_to)) {
$cargosearchform->to_name = $transport->address_to[0]->name;
$cargosearchform->to_address_lat = $transport->address_to[0]->lat;
$cargosearchform->to_address_long = $transport->address_to[0]->long;
$cargosearchform->to_radius = $this->radius;
}
$cargoIds = $cargosearchform->relatedCargo();
if (!empty($cargoIds)) {
$cargo = Cargo::model()->findAllByAttributes(array('cargo_id' => $cargoIds), array('order' => 'cargo_id desc', 'limit' => 5));
} else {
$cargo = array();
}
$this->render('transport_add', ['cargo' => $cargo]);
break;
case 'sklad_call_add':
$skladcall = SkladCall::model()->with('address')->findByPk($this->record_id);
if ($skladcall->address->name && $skladcall->address->lat && $skladcall->address->long) {
$skladsearchform = new SkladSearchForm();
$skladsearchform->from_name = $skladcall->address->name;
$skladsearchform->from_address_lat = $skladcall->address->lat;
$skladsearchform->from_address_long = $skladcall->address->long;
$skladsearchform->from_radius = $this->radius;
$criteria = $skladsearchform->getCriteria();
$criteria->limit = 5;
$sklads = Sklad::model()->findAll($criteria);
} else {
$sklads = array();
}
$this->render('sklad_call', ['sklads' => $sklads]);
break;
case 'sklad_add':
$sklad = Sklad::model()->with('address')->findByPk($this->record_id);
if ($sklad->address->name && $sklad->address->lat && $sklad->address->long) {
$skladcallsearchform = new SkladCallSearchForm();
$skladcallsearchform->from_name = $sklad->address->name;
$skladcallsearchform->from_address_lat = $sklad->address->lat;
$skladcallsearchform->from_address_long = $sklad->address->long;
$skladcallsearchform->from_radius = $this->radius;
$criteria = $skladcallsearchform->getCriteria();
$criteria->limit = 5;
$skladcalls = SkladCall::model()->findAll($criteria);
} else {
$skladcalls = array();
}
$this->render('sklad_add', ['skladcalls' => $skladcalls]);
break;
case 'specialtechnique_call_add':
$specialTechniqueCall = SpecialTechnique::model()->with('address')->findByPk($this->record_id);
if ($specialTechniqueCall->address->name && $specialTechniqueCall->address->lat && $specialTechniqueCall->address->long) {
$specialtechniqueform = new SpecialTechniqueForm();
$specialtechniqueform->from_name = $specialTechniqueCall->address->name;
$specialtechniqueform->from_address_lat = $specialTechniqueCall->address->lat;
$specialtechniqueform->from_address_long = $specialTechniqueCall->address->long;
$specialtechniqueform->from_radius = $this->radius;
$specialtechniqueform->type_request = 'offer';
$specialtechniqueform->category_id = $specialTechniqueCall->category_id;
$criteria = $specialtechniqueform->getCriteria();
$criteria->limit = 5;
$specialtechnique = SpecialTechnique::model()->findAll($criteria);
} else {
$specialtechnique = array();
}
$this->render('specialtechnique_call_add', ['specialtechnique' => $specialtechnique]);
break;
case 'specialtechnique_add':
$specialTechnique = SpecialTechnique::model()->with('address')->findByPk($this->record_id);
if ($specialTechnique->address->name && $specialTechnique->address->lat && $specialTechnique->address->long) {
$specialtechniqueform = new SpecialTechniqueForm();
$specialtechniqueform->from_name = $specialTechnique->address->name;
$specialtechniqueform->from_address_lat = $specialTechnique->address->lat;
$specialtechniqueform->from_address_long = $specialTechnique->address->long;
$specialtechniqueform->from_radius = $this->radius;
$specialtechniqueform->type_request = 'request';
$specialtechniqueform->category_id = $specialTechnique->category_id;
$criteria = $specialtechniqueform->getCriteria();
$criteria->limit = 5;
$specialtechniquecall = SpecialTechnique::model()->findAll($criteria);
} else {
$specialtechniquecall = array();
}
$this->render('specialtechnique_add', ['specialtechniquecall' => $specialtechniquecall]);
break;
default:
break;
}
}
</section>
</div>
<div class="row">
<section class="col-sm-12">
<div class="row">
<section class="col-sm-5">
<b class="sklad_attr"><?php
echo Yii::t('SkladModule.default', 'Желаемая цена за м2');
?>
:</b>
</section>
<section class="col-sm-7">
<?php
if (!empty($SkladCall->area)) {
foreach ($SkladCall->area as $area) {
echo $area->price . ' р <span style="color:#51926A;font-weight: bold;">' . ($SkladCall->type_pay == SkladCall::TYPE_RENT ? Sklad::enumSrok($area->srok) . ' ' : '') . SkladCall::enumNds($area->nds_include) . '</span><br />';
}
}
?>
</section>
</div>
</section>
</div>
</section>
<section class="col-sm-6 sp-detail">
<div class="row">
<section class="col-sm-12">
<div class="row">
<section class="col-sm-5">
<b class="sklad_attr"><?php
echo Yii::t('SkladModule.default', 'Высота потолков');
global $message;
//zasobnik na spravy co sa vypisuju uzivatelovi
$sklad = new Sklad();
$sklad->setId($_REQUEST["sklad_id"]);
$sklad->setName(test_input($_REQUEST["meno_skladu"]));
$sklad->setDescription(test_input($_REQUEST["popis_skladu"]));
if ($sklad->updateInDatabase()) {
$message->add("Sklad bol úspešne zmenený");
} else {
$message->add("Sklad nebol znemený");
}
break;
case "zmaz_sklad_proceed":
global $message;
//zasobnik na spravy co sa vypisuju uzivatelovi
$sklad = new Sklad();
$sklad->setId($_REQUEST["sklad_id"]);
if ($sklad->deleteInDatabase()) {
$message->add("Sklad bol vymazaný");
} else {
$message->add("Sklad nebol vymazaný");
}
break;
case "kontaktne_udaje_proceed":
global $message;
global $uzivatel;
//trieda uzivatela, ino o aktualne prihlasenom uzivcatelovi
$meno = test_input($_REQUEST["meno"]);
$priezvisko = test_input($_REQUEST["priezvisko"]);
//udaje o organizacii
$nazov = test_input($_REQUEST["nazov_organizacie"]);
public function actionActivate($id)
{
$model = Sklad::model()->findByPk($id);
if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $model->user->company_id) && (Yii::app()->getUser()->getProfile()->modules->storage != '1' || $model->user_id != Yii::app()->user->id)) {
throw new CHttpException(403);
}
if ($model === null) {
throw new CHttpException(404, 'Указанная запись не найдена');
}
$model->deleted_status = Sklad::DEL_SATUS_ACTIVE;
$model->deleted_status_date = date('Y-m-d H:i:s');
$model->update();
Yii::app()->user->setFlash('success', Yii::t('CabinetModule.default', 'Предложение успешно активированно.'));
$this->redirect('/cabinet/storage');
}
public function actionDelete($id)
{
$user = User::model()->find(array('condition' => 'id = :id', 'params' => array(':id' => $id)));
if (isset($user)) {
if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $user->company_id || Yii::app()->user->id == $id)) {
throw new CHttpException(403);
}
$users = User::getUserList($id);
$model = new ModuleAccess();
if (isset($_POST['ModuleAccess'])) {
$userId = $_POST['ModuleAccess']['user'];
Transport::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Product::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Cargo::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Reis::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Sklad::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Custom::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
Insurance::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
SpecialTechnique::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
if ($user->delete()) {
$this->redirect('/cabinet/staff/list');
}
}
$this->render('delete', array('model' => $model, 'user' => $user, 'users' => $users));
}
}
