<?php
/* @var $this BancoVariableController */
/* @var $model BancoVariable */

$this->breadcrumbs=array(
	'Banco Variables'=>array('index'),
	'Manage',
);

$this->menu=array(
	array('label'=>'List BancoVariable', 'url'=>array('index')),
	array('label'=>'Create BancoVariable', 'url'=>array('create')),
);

Yii::app()->clientScript->registerScript('search', "
$('.search-button').click(function(){
	$('.search-form').toggle();
	return false;
});
$('.search-form form').submit(function(){
	$('#banco-variable-grid').yiiGridView('update', {
		data: $(this).serialize()
	});
	return false;
});
");
?>

<h3 class="text-center">Administraci&oacute;n de las variables por bancos</h3>
<hr>
<?php 
    $this->widget('bootstrap.widgets.TbAlert', array(
        'block' => true, // display a larger alert block?
        'fade' => true, // use transitions?
        'closeText' => '×', // close link text - if set to false, no close link is displayed
        'alerts' => array(// configurations per alert type
        'success' => array('block' => true, 'fade' => true, 'closeText' => '×'), // success, info, warning, error or danger
        'error' => array('block' => true, 'fade' => true, 'closeText' => '×'), // success, info, warning, error or danger
        ),
    ));
    echo CHtml::link('Registrar variable a banco', Yii::app()->createUrl('/configuracion/BancoVariable/create'),array('class'=>'btn btn-inverse'));
?>
<?php $this->widget('bootstrap.widgets.TbGridView', array(
	'id'=>'banco-variable-grid',
	'dataProvider'=>$model->search(),
	'filter'=>$model,
	'columns'=>array(
		[
			'name'=>'idbanco',
			'value'=>'$data->idBanco?$data->idBanco->descripcion:""',
			'filter'=>CHtml::activeDropDownList($model,'idbanco',CHtml::listData(Banco::model()->findAll(['join'=>'JOIN configuracion.param_bancos as b ON t.codigo=substring(num_cuenta from 1 for 4)' ,'order'=>'descripcion']), 'idbanco', 'descripcion'),array('class'=>'ui selection dropdown','prompt'=>'-- SELECCIONE --')),
		],
		[
			'name'=>'id_conf_variable_banco',
			'value'=>'$data->idConfVariableBanco?$data->idConfVariableBanco->nombre_variable:""',
			'filter'=>CHtml::activeDropDownList($model,'id_conf_variable_banco',CHtml::listData(ConfVaribaleBanco::model()->findAll('id in(SELECT a.id_conf_variable_banco  FROM configuracion.banco_variable as a WHERE idbanco =:idbanco )',[':idbanco'=>(int)$model->idbanco]), 'id','nombre_variable'),array('class'=>'ui selection dropdown','prompt'=>'-- SELECCIONE --')),
		],
		[
			'name'=>'tipo_campo',
			'value'=>'$data->getTipoDato($data->tipo_campo)',
			'filter'=>CHtml::activeDropDownList($model,'tipo_campo',$model->getTipoDato(),array('class'=>'ui selection dropdown','prompt'=>'-- SELECCIONE --')),
		],
		'blnborrado',
		array(
			'class'=>'bootstrap.widgets.TbButtonColumn',
			'template'=>'{view}{update}',
		),
	),
)); ?>