<?php

class ConfPreNominaController extends Controller
{
    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     *             using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters()
    {
        return [
            'accessControl', // perform access control for CRUD operations
            'postOnly + delete', // we only allow deletion via POST request
        ];
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     *
     * @return array access control rules
     */
    public function accessRules()
    {
        return [
            ['allow',  // allow all users to perform 'index' and 'view' actions
                'actions' => ['index', 'view'],
                'users' => ['*'],
            ],
            ['allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions' => ['create', 'update'],
                'users' => ['@'],
            ],
            ['allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions' => ['admin', 'delete'],
                'users' => ['@'],
            ],
            ['deny',  // deny all users
                'users' => ['*'],
            ],
        ];
    }

    /**
     * Displays a particular model.
     *
     * @param int $id the ID of the model to be displayed
     */
    public function actionView($id)
    {
        $this->render('view', [
            'model' => $this->loadModel($id),
        ]);
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate()
    {
        $model = ConfPreNomina::model()->find('blnborrado= false');
        if ($model) {
            return $this->redirect(['update']);
        }
        $model = new ConfPreNomina();
        $confBeneficiario = ConfBeneficiario::model()->findByPk(1);

        $tipoNomina = CHtml::listData(TipoNomina::model()->findAll('id in(1,2,3,4)'), 'id', 'nombre_nomina');

        foreach ($tipoNomina as $key => $value) {
            $numero_periodo[$key] = [
                'descripcion' => $value,
                'cantidad' => 0,
            ];
        }

        $confBeneficiario->getCuentaContable();

        if (isset($_POST['ConfPreNomina'])) {
            $model->attributes = $_POST['ConfPreNomina'];
            $confBeneficiario->attributes = $_POST['ConfBeneficiario'];
            $confBeneficiario->setCuentaContable();

            $numero_periodo = $periodos = [];

            if (isset($_POST['NumeroPeriodo'])) {
                foreach ($_POST['NumeroPeriodo'] as $key => $value) {
                    $periodos[$key] = $value['numero'];

                    $numero_periodo[$key] = [
                        'descripcion' => $tipoNomina[$key],
                        'cantidad' => $value['numero'],
                    ];
                }
            }

            $transaction = Yii::app()->getDb()->beginTransaction();
            try {
                $model->tipo_nomina = json_encode($periodos);

                if (! $model->save()) {
                    throw new Exception('Error al guardar configuracion de prenomina.');
                }

                if (! $confBeneficiario->save()) {
                    throw new Exception('Error al guardar cuenta contable.');
                }

                $transaction->commit();
                $this->redirect(['admin']);
            } catch (Exception $e) {
                $transaction->rollback();
            }
        }

        $this->render('create', [
            'model' => $model,
            'confBeneficiario' => $confBeneficiario,
            'tipoNomina' => $tipoNomina,
            'numero_periodo' => $numero_periodo,
        ]);
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     *
     * @param int $id the ID of the model to be updated
     */
    public function actionUpdate()
    {
        $model = ConfPreNomina::model()->find('blnborrado= false');
        $confBeneficiario = ConfBeneficiario::model()->findByPk(1);

        $confBeneficiario->getCuentaContable();

        $periodos = [];

        if ($model->tipo_nomina != '') {
            $periodos = json_decode($model->tipo_nomina, true);
        }

        $numero_periodo = [];

        $tipoNomina = CHtml::listData(TipoNomina::model()->findAll('id in(1,2,3,4)'), 'id', 'nombre_nomina');

        foreach ($tipoNomina as $key => $value) {
            $numero_periodo[$key] = [
                'descripcion' => $value,
                'cantidad' => isset($periodos[$key]) ? $periodos[$key] : 0,
            ];
        }

        if (isset($_POST['ConfPreNomina'])) {
            $numero_periodo = $periodos = [];

            $model->attributes = $_POST['ConfPreNomina'];
            $confBeneficiario->attributes = $_POST['ConfBeneficiario'];
            $confBeneficiario->setCuentaContable();

            if (isset($_POST['NumeroPeriodo'])) {
                foreach ($_POST['NumeroPeriodo'] as $key => $value) {
                    $periodos[$key] = $value['numero'];

                    $numero_periodo[$key] = [
                        'descripcion' => $tipoNomina[$key],
                        'cantidad' => $value['numero'],
                    ];
                }
            }

            $transaction = Yii::app()->getDb()->beginTransaction();
            try {
                $model->tipo_nomina = json_encode($periodos);

                if (! $model->save()) {
                    throw new Exception('Error al guardar configuracion de prenomina.');
                }

                if (! $confBeneficiario->save()) {
                    throw new Exception('Error al guardar cuenta contable.');
                }

                $transaction->commit();
                $this->redirect(['admin']);
            } catch (Exception $e) {
                $transaction->rollback();
            }
        }

        $this->render('update', [
            'model' => $model,
            'confBeneficiario' => $confBeneficiario,
            'tipoNomina' => $tipoNomina,
            'numero_periodo' => $numero_periodo,
        ]);
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     *
     * @param int $id the ID of the model to be deleted
     */
    public function actionDelete($id)
    {
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (! isset($_GET['ajax'])) {
            $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : ['admin']);
        }
    }

    /**
     * Lists all models.
     */
    public function actionIndex()
    {
        $this->redirect(['admin']);
        $dataProvider = new CActiveDataProvider('ConfPreNomina');
        $this->render('index', [
            'dataProvider' => $dataProvider,
        ]);
    }

    /**
     * Manages all models.
     */
    public function actionAdmin()
    {
        $model = new ConfPreNomina('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['ConfPreNomina'])) {
            $model->attributes = $_GET['ConfPreNomina'];
        }

        $this->render('admin', [
            'model' => $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 int $id the ID of the model to be loaded
     *
     * @return ConfPreNomina the loaded model
     *
     * @throws CHttpException
     */
    public function loadModel($id)
    {
        $model = ConfPreNomina::model()->findByPk($id);
        if ($model === null) {
            throw new CHttpException(404, 'The requested page does not exist.');
        }

        return $model;
    }

    /**
     * Performs the AJAX validation.
     *
     * @param ConfPreNomina $model the model to be validated
     */
    protected function performAjaxValidation($model)
    {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'conf-pre-nomina-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }
}