public function actionEscuelas()
{
$model = new VisitasEscuelas();
$VisitasLugares = VisitasLugares::find()->where('estatus_did = 1')->all();
$VisitasEscuelas = VisitasEscuelas::find()->where('estatus_did = 1')->all();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect('escuelas');
} else {
return $this->render('escuelas', ['model' => $model, 'VisitasLugares' => $VisitasLugares, 'VisitasEscuelas' => $VisitasEscuelas]);
}
}
public function actionImprimirFiltro()
{
//echo'<pre>';print_r($_GET);echo'</pre>'; exit;
$fechaInicial = date("d-m-Y", strtotime($_GET['fechas']["filtro"]["fechaInicial"]));
$fechaFinal = date("d-m-Y", strtotime($_GET['fechas']["filtro"]["fechaFinal"]));
$formato = 'fecha_ft >= "' . $fechaInicial . '" and fecha_ft <= "' . $fechaFinal . '"';
$VisitasLugares = VisitasLugares::find()->where('fecha_ft >= :fechaInicial and fecha_ft <= :fechaFinal', ['fechaInicial' => $fechaInicial, 'fechaFinal' => $fechaFinal])->all();
$content = $this->renderPartial('_imprimir', ['VisitasLugares' => $VisitasLugares]);
$header = $this->renderPartial('_header', ['VisitasLugares' => $VisitasLugares]);
$pdf = new Pdf(['format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'destination' => Pdf::DEST_BROWSER, 'content' => $content, 'cssFile' => '@vendor/kartik-v/yii2-mpdf/assets/kv-mpdf-bootstrap.min.css', 'cssInline' => '.kv-heading-1{font-size:18px}', 'options' => ['title' => 'Krajee Report Title'], 'methods' => ['SetHeader' => $header, 'SetFooter' => ['{PAGENO}']]]);
// return the pdf output as per the destination setting
return $pdf->render();
}
/**
* @return \yii\db\ActiveQuery
*/
public function getVisitasLugares()
{
return $this->hasMany(VisitasLugares::className(), ['lugares_did' => 'id']);
}
