/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Comunicado::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['dependencia_id' => $this->dependencia_id, 'tipocomunicado_id' => $this->tipocomunicado_id]);
$query->andFilterWhere(['like', 'dependencia', $this->dependencia])->andFilterWhere(['like', 'siglas', $this->siglas])->andFilterWhere(['like', 'envia_comunicado', $this->envia_comunicado])->andFilterWhere(['like', 'direccion', $this->direccion])->andFilterWhere(['like', 'asistente', $this->asistente]);
/*
echo "<br><br>";
$command = $query->createCommand();
echo "<pre>";
print_r($command);
echo "</pre>";
exit;
*/
return $dataProvider;
}
?>
<div class="form-group">
<?php
echo Html::a('Regresar', Yii::$app->request->referrer, ['class' => 'btn btn-primary']);
?>
<?php
echo Html::submitButton($model->isNewRecord ? 'Nueva Cuenta' : 'Actualizar Datos', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<div class="row">
<div class="col-xs-3">
<?php
$data = ArrayHelper::map(\backend\models\Comunicado::listaEnvios(), 'id', 'desc');
$model->envia_comunicado = 'No';
// Gobierno Federal
echo $form->field($model, 'envia_comunicado')->dropDownList($data);
?>
</div>
</div>
<div class="row">
<div class="col-xs-3">
<?php
// Tipo de Cuenta
$lista = ArrayHelper::map(\backend\models\Tipocomunicado::find()->asArray()->all(), 'tipocomunicadoid', 'tipocomunicado');
$model->tipocomunicado_id = 1;
/**
* @return \yii\db\ActiveQuery
*/
public function getDependencia()
{
return $this->hasOne(Comunicado::className(), ['dependencia_id' => 'dependenciaid']);
}
?>
</p>
<?php
$gridColumns = [['class' => 'kartik\\grid\\SerialColumn', 'width' => '25px'], ['class' => 'kartik\\grid\\ActionColumn', 'template' => '{update} {delete}', 'width' => '25px'], ['class' => 'kartik\\grid\\ExpandRowColumn', 'value' => function ($modelo, $key, $index, $column) {
return GridView::ROW_COLLAPSED;
}, 'expandOneOnly' => true, 'detail' => function ($model, $key, $index, $column) {
$searchModel = new \backend\models\search\ComunicadoscontactosSearch();
$searchModel->dependenciaid = $model->dependencia_id;
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return Yii::$app->controller->renderPartial('_contactos-details', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}], ['class' => 'kartik\\grid\\EditableColumn', 'width' => '100px', 'label' => 'Envian Comunicados de Prensa', 'attribute' => 'envia_comunicado', 'value' => function ($model) {
return $model->envia_comunicado;
}, 'filterType' => GridView::FILTER_SELECT2, 'filter' => \yii\helpers\ArrayHelper::map(\backend\models\Comunicado::listaEnvios(), 'id', 'desc'), 'filterWidgetOptions' => ['pluginOptions' => ['allowClear' => true]], 'filterInputOptions' => ['placeholder' => 'Envian'], 'editableOptions' => function ($model) {
return ['formOptions' => ['action' => Url::to(['comunicado/change', 'id' => $model->dependencia_id])], 'header' => 'Envian Comunicado', 'size' => 'md', 'inputType' => \kartik\editable\Editable::INPUT_SELECT2, 'options' => ['data' => \yii\helpers\ArrayHelper::map(\backend\models\Comunicado::listaEnvios(), 'id', 'desc')]];
}], ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => 'dependencia', 'width' => '140px', 'value' => function ($model, $key, $index, $widget) {
return $model->dependencia;
}, 'editableOptions' => function ($model, $key, $index, $widget) {
return ['formOptions' => ['action' => Url::to(['comunicado/change', 'id' => $model->dependencia_id])], 'header' => 'Dependencia', 'size' => 'md'];
}], ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => 'siglas', 'width' => '140px', 'value' => function ($model, $key, $index, $widget) {
return $model->siglas;
}, 'editableOptions' => function ($model, $key, $index, $widget) {
return ['formOptions' => ['action' => Url::to(['comunicado/change', 'id' => $model->siglas])], 'header' => 'Siglas', 'size' => 'md'];
}], ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => 'direccion', 'width' => '140px', 'value' => function ($model, $key, $index, $widget) {
return $model->direccion;
}, 'editableOptions' => function ($model, $key, $index, $widget) {
return ['formOptions' => ['action' => Url::to(['comunicado/change', 'id' => $model->direccion])], 'header' => 'Dirección', 'size' => 'md'];
}], ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => 'asistente', 'width' => '140px', 'value' => function ($model, $key, $index, $widget) {
return $model->asistente;
}, 'editableOptions' => function ($model, $key, $index, $widget) {
/**
* @return \yii\db\ActiveQuery
*/
public function getComunicados()
{
return $this->hasMany(Comunicado::className(), ['tipocomunicado_id' => 'tipocomunicadoid']);
}
/**
* Finds the Comunicado model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Comunicado the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Comunicado::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
