Login Retreive lost passwordRegister
Search

Forum Index / General / linkSelectFields do not load data

[ This topic is unsolved! ]

  Jonathan Clavijo 18 November 09 / 17:51  
I have a form with 3 SelectField and 2 linkSelectFields, the first linkSelectFields load the second SelectField with a query, while the second linkSelectFields doesn't load the data when I select the first record of the second SelectField. code here:

<?php
session_start();
include './configs/funciones.php';
include './configs/smarty.php';
include './configs/bd.php';
include './configs/bdfh3.php';
include './modelo/bd_guardar_regla_producto.php';
include './modelo/bd_lista_binesmb.php';
include './modelo/bd_lista_sucursales2.php';
include './modelo/bd_obt_regla_producto.php';

$f1=new dbFormHandler('reglas',NULL,'onclick="highlight(event)"');
$f1->setLanguage('es');
$f1->setConnectionResource($link,'reglas_producto','mysql');
$f1->SelectField('<b>Tienda</b>','sucursal_id',bd_lista_sucursales($_SESSION['usuario']['id']),FH_NOT_EMPTY,true);
$f1->SelectField('<b>Cuenta</b>','afiliado_id',array(),FH_NOT_EMPTY,true);
$f1->linkSelectFields("recarga_afiliado2.php","sucursal_id","afiliado_id");
$f1->SelectField('<b>Regla</b>','regla_id',array(),FH_NOT_EMPTY,true);
$f1->linkSelectFields("recarga_regla.php","afiliado_id","regla_id");
$f1->SelectField('<b>Producto</b>','binesmb_id',bd_lista_binesmb(),FH_NOT_EMPTY,true);
$f1->submitButton('Continuar','continuar');
$f1->onCorrect('proceso');

function proceso($d)
{
****more code****
}

$multivposss->assign('f1',$f1->flush(true));
$multivposss->disp();
unset($_SESSION['mensaje']);

and code of LinkSelectFields "recarga_regla.php":

<?php
session_start();
include './configs/funciones.php';
include './configs/smarty.php';
include './configs/bd.php';
include './configs/bdfh3.php';

$filter = $_POST['filter'];
switch( $_POST['field'] ) {
case 'regla_id':
if( $filter != 0 )
{
$regla_id = sql2opciones("SELECT sucursal_reglas.id,sucursal_reglas.nombre,razon_social FROM sucursal_reglas,sucursales,sucursal_bancos
WHERE sucursal_bancos.id='$filter' and sucursal_bancos.sucursal_id=sucursales.id and
sucursal_reglas.sucursal_id=sucursales.id
order by sucursal_reglas.nombre asc");
$n = count($regla_id);
if ($n != 0)
{
FormHandler::setDynamicOptions($regla_id);
break;
}
}
default:
FormHandler::setDynamicOptions( array());
break;
}

and code of LinkSelectField "recarga_afiliado2.php"

<?php
session_start();
include './configs/funciones.php';
include './configs/smarty.php';
include './configs/bd.php';
include './configs/bdfh3.php';

$filter = $_POST['filter'];
switch( $_POST['field'] ) {
case 'afiliado_id':
if( $filter != 0 )
{
$afiliado_id = sql2opciones("SELECT sucursal_bancos.id as afiliado_id,concat(bancos.nombre,', Afiliado:',afiliado) as cuenta,
afiliado,bancos.nombre,sucursales.id as sucursal_id,razon_social
FROM sucursales,sucursal_bancos,bancos
WHERE sucursales.id=sucursal_bancos.sucursal_id and
bancos.id=sucursal_bancos.banco_id and sucursales.id='$filter' order by razon_social,bancos.nombre,afiliado asc");
$n = count($afiliado_id);
if ($n != 0)
{
FormHandler::setDynamicOptions($afiliado_id);
break;
}
}
default:
FormHandler::setDynamicOptions( array() );
break;
}

  Top


powered by PHP-GLOBE   © 2004 - 2010 FormHandler. All rights reserved.   -   Open source license