public function run()
{
$criteria = new CDbCriteria();
$criteria->with = array('user');
$criteria->addCondition('user.id!=""');
$criteria->order = 'cargo_id DESC';
$criteria->limit = 2;
$model = Cargo::model()->findAll($criteria);
$this->render($this->view, ['model' => $model]);
}
public function actionList($company_id = 0)
{
if ($company_id == 0) {
$company_id = Yii::app()->getUser()->getProfile()->company_id;
}
Yii::import('balance.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' => Cargo::DEL_SATUS_DELETED];
$criteria->order = 'cargo_id DESC';
$this->render('list', ['cargos' => Cargo::model()->findAll($criteria), 'company_id' => $company_id]);
}
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 getMenuCargos()
{
return CHtml::listData(Cargo::model()->findAll(), "id", "descripcion");
}
?>
<?php
echo $form->dropDownList($model, 'ultimo_nivel_educativo', CHtml::listData(UltimoNivelAprobado::model()->findAll(), 'Codigo', 'Descripcion'), array('class' => 'Ccombo', 'prompt' => 'Seleccione...', 'options' => array($modelold->ultimo_nivel_educativo => array('selected' => true))));
?>
<?php
echo $form->error($model, 'ultimo_nivel_educativo');
?>
</td>
</tr>
<tr>
<td>
<?php
echo $form->labelEx($model, 'cargo');
?>
<?php
echo $form->dropDownList($model, 'cargo', CHtml::listData(Cargo::model()->findAll(), 'Codigo', 'Descripcion'), array('class' => 'Ccombo', 'prompt' => 'Seleccione...', 'options' => array($modelold->cargo => array('selected' => true))));
?>
<?php
echo $form->error($model, 'cargo');
?>
</td>
<td>
<?php
echo $form->labelEx($model, 'nombre_cargo');
?>
<?php
echo $form->dropDownList($model, 'nombre_cargo', CHtml::listData(NombreCargo::model()->findAll(), 'Codigo', 'Descripcion'), array('class' => 'Ccombo', 'prompt' => 'Seleccione...', 'options' => array($modelold->nombre_cargo => array('selected' => true))));
?>
<?php
echo $form->error($model, 'nombre_cargo');
?>
?>
<?php
echo $form->dropDownList($model, 'Ubicacion_idUbicacion', array(), array('prompt' => 'Seleccione una'));
?>
<?php
echo $form->error($model, 'Ubicacion_idUbicacion');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'Cargo_idCargo');
?>
<?php
echo $form->dropDownList($model, 'Cargo_idCargo', CHtml::listData(Cargo::model()->findAll(), 'idCargo', 'Nombre'), array('empty' => 'Seleccione un cargo'));
?>
<?php
echo $form->error($model, 'Cargo_idCargo');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'Dependencia_idDependencia');
?>
<?php
echo $form->dropDownList($model, 'Dependencia_idDependencia', CHtml::listData(Dependencia::model()->findAll(), 'idDependencia', 'Nombre'), array('empty' => 'Seleccione una dependencia'));
?>
<?php
echo $form->error($model, 'Dependencia_idDependencia');
public function actionActivate($id)
{
$model = Cargo::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->cargo != '1' || $Cargo->user_id != Yii::app()->user->id)) {
throw new CHttpException(403);
}
if ($model === null) {
throw new CHttpException(404, 'Указанная запись не найдена');
}
$model->deleted_status = \Product::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/cargo');
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
*/
public function loadModel()
{
if ($this->_model === null) {
if (isset($_GET['id'])) {
$this->_model = Cargo::model()->findbyPk($_GET['id']);
}
if ($this->_model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
}
return $this->_model;
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Cargo::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Reportar bienes faltantes.
* @redirected to 'view' page.
*/
public function actionCreate()
{
$user_id = Yii::app()->user->getId();
$user = Usuario::model()->findbyPk($user_id);
date_default_timezone_set('America/Caracas');
$fecha = date('Y-m-d H:i:s');
$model = new Fbm3();
$model->dependencia_id = $user->dependencia_id;
$model->observador = new Persona();
$model->observador->pdata = new PersonaData();
$model->observador->cargo = new Cargo();
$model->status_id = 1;
// creando
$model->fecha = $fecha;
if (isset($_POST['Fbm3'])) {
$model->attributes = $_POST['Fbm3'];
$model->observador->attributes = $_POST['Persona'];
$model->observador->pdata->attributes = $_POST['PersonaData'];
$exists = PersonaData::model()->exists('cedula=' . $model->observador->pdata->cedula);
if (!$exists) {
$model->observador->pdata->f_creacion = $fecha;
$model->observador->pdata->f_cambios = $fecha;
if ($model->observador->pdata->save()) {
$model->observador->pdata_id = $model->observador->pdata->id;
}
//$model->observador->cargo->attributes = $_POST['Cargo'];
$model->observador->dependencia_id = $_POST['Persona']['dependencia_id'];
$model->observador->fecha = $fecha;
if ($model->observador->save()) {
$model->observador_id = $model->observador->id;
} else {
//print_r($model->observador->getErrors());
//exit;
}
} else {
$pdata = PersonaData::model()->findByAttributes(array('cedula' => $model->observador->pdata->cedula));
$model->observador->pdata_id = $pdata->id;
$persona = Persona::model()->find(array('condition' => 't.pdata_id=' . $model->observador->pdata_id . ' AND t.dependencia_id=' . $model->observador->dependencia_id));
if (!$persona) {
// guardar persona
$model->observador->dependencia_id = $_POST['Persona']['dependencia_id'];
$model->observador->fecha = $fecha;
if ($model->observador->save()) {
$model->observador_id = $model->observador->id;
}
} else {
$model->observador_id = $persona->id;
$model->observador = $persona;
}
}
if ($model->save()) {
$this->redirect(array('adscribir', 'id' => $model->id));
}
}
$responsables = Responsable::model()->findAll();
$profesiones = Profesion::model()->findAll();
$dps = Dependencia::model()->findAll(array('condition' => 'sede_id=1'));
$generos = Sexo::model()->findAll();
$cargos = Cargo::model()->findAll();
$this->render('create', array('model' => $model, 'responsables' => $responsables, 'profesiones' => $profesiones, 'dps' => $dps, 'generos' => $generos, 'cargos' => $cargos));
}
/**
* Asociar Cargo
*/
public function actionAdd($persona_id)
{
$persona = PersonaData::model()->findByPk($persona_id);
if (isset($persona)) {
$model = new Persona();
$model->pdata_id = $persona->id;
$model->status_id = 1;
if (isset($_POST['Persona'])) {
$model->attributes = $_POST['Persona'];
date_default_timezone_set('America/Caracas');
$fecha = date('Y-m-d H:i:s');
$model->fecha = $fecha;
if ($model->save()) {
$this->redirect(array('view', 'pid' => $model->pdata_id));
//else print_r($model->getErrors()); exit;
}
//else print_r($persona->getErrors()); exit;
}
if ($persona->sexo_id == 1) {
$cargos = Cargo::model()->findAll(array('order' => 'descripcion ASC'));
} else {
$cargos = Cargo::model()->findAll(array('select' => 'id, desc_f as descripcion', 'order' => 'descripcion ASC'));
}
$dps = Dependencia::model()->findAll(array('condition' => 'sede_id=1', 'order' => 'descripcion ASC'));
$this->render('add', array('persona_id' => $persona->id, 'model' => $model, 'cargos' => $cargos, 'dps' => $dps));
} else {
$this->redirect(array('create'));
}
}
/**
* Запуск виджета
*/
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;
}
}
?>
<p class="help-block">Los campos con un <span class="required">*</span> son requeridos.</p>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->textFieldControlGroup($model, 'usu_rut', array('maxlength' => 13, 'disabled' => Yii::app()->controller->action->id !== 'create'));
?>
<?php
echo $form->dropDownListControlGroup($model, 'emp_rut', CHtml::listData(Empresa::model()->findAll('emp_desabilitado=0'), 'emp_rut', 'emp_nombre'), array('empty' => 'Seleccione una empresa'));
?>
<?php
echo $form->dropDownListControlGroup($model, 'car_id', CHtml::listData(Cargo::model()->findAll('car_desabilitado=0'), 'car_id', 'car_nombre'), array('empty' => 'Seleccione un Cargo'));
?>
<?php
echo $form->textFieldControlGroup($model, 'usu_nombre', array('maxlength' => 256));
?>
<?php
echo $form->textFieldControlGroup($model, 'usu_apellido', array('maxlength' => 512));
?>
<?php
echo $form->passwordFieldControlGroup($model, 'usu_password', array('maxlength' => 128));
?>
<?php
echo $form->dropDownListControlGroup($model, 'usu_rol', array('admins' => 'Administrador', 'users' => 'Usuario', 'viewver' => 'Observador'), array('empty' => 'Seleccione un Cargo'));
?>
<?php
echo $form->textFieldControlGroup($model, 'usu_fono', array('maxlength' => 64));
public static function getModelName($model_id)
{
$Cargo = Cargo::model()->findByPk($model_id);
return $Cargo !== NULL ? $Cargo->name->name : Yii::t('CargoModule.default', 'Грузы');
}
<?php
switch ($data['modelName']) {
case "Transport":
Transport::disableDefaultScope();
$model = Transport::model('Transport')->findByPk($data['key']);
echo $this->renderPartial('application.views.transport._view', array('data' => $model));
break;
case "Cargo":
Cargo::disableDefaultScope();
$model = Cargo::model()->findByPk($data['key']);
echo $this->renderPartial('application.views.cargo._view', array('data' => $model));
break;
case "Tender":
$model = Tender::model()->findByPk($data['key']);
echo $this->renderPartial('application.views.tender._view', array('data' => $model));
break;
case "User":
$model = User::model()->findByPk($data['key']);
echo $this->renderPartial('application.views.user._view', array('data' => $model));
break;
default:
echo "Не правильные данные обратитесь к администратору.";
}
/**
* Удаляем из раздела Cargo model - modules/cargo/model/Cargo, controller modules/cargo/controllers/DefaultController
*
* @param User $user
*/
private function deleteCargo(\User $user)
{
$data = 'user_id = :user_id';
$param = array(':user_id' => $user->id);
$count = Cargo::model()->count($data, $param);
$cargos = Cargo::model()->findAll($data, $param);
foreach ($cargos as $cargo) {
/* $adreses = Yii::app()->db->createCommand('select address_id from site_reis_address WHERE reis_id = '.$reis->reis_id)->queryAll();
foreach ($adreses as $adres) {
$this->deleteAddress($adres['address_id']);
}*/
$this->deleteRelationsAll($cargo->cargo_id, 'cargo_id', 'site_cargo_address', 'address_id', 'site_address');
$this->deleteRelation($cargo->cargo_id, 'cargo_id', 'site_cargo_relations');
$this->deleteRelationsAll($cargo->cargo_id, 'cargo_id', 'site_cargo_cost', 'cost_id', 'site_cost');
}
if ($this->debug) {
echo " ... Cargo del " . $count . " \n";
} else {
Cargo::model()->deleteAll($data, $param);
}
}
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));
}
}
