Hi, can I use the values of a get_dropdown_values of a column in another column? for example: the var $str2 of the column area I want to use in the query of another column or How can I get the value the user select for that dropdown?
//------------------Area
$col = array();
$col["formatter"] = "select";
$col["title"] = "Área";
$col["name"] = "id_area";
$col["width"] = "60";
$col["editable"] = true;
$col["align"] = "center";
$col["search"] = false;
# fetch data from database, with alias k for key, v for value
$area_lookup = $g->get_dropdown_values("select distinct id_area as k, nombre_area as v from inventario_produccion.areas ORDER by id_area");
# these 3 lines will make dropdown in search autofilter
$col["stype"] = "select";
// all row, blank row, then all db values. ; is separator
$str2 = ":;".$area_lookup;
$col["searchoptions"] = array("value" => $str2, "separator" => ":", "delimiter" => ";");
$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>":;".$area_lookup); // with these values "key:value;key:value;key:value"
$cols[] = $col;
//---------------Articulo
$col = array();
$col["formatter"] = "select";
$col["title"] = "Artículo";
$col["name"] = "codigo_articulo";
$col["width"] = "80";
$col["editable"] = true;
$col["align"] = "center";
$col["search"] = false;
$col["editoptions"] = array("size"=>35);
# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("SELECT articulos_areas.codigo_articulo, concat_ws(' ',nombre_articulo,tipo,nombre_marca)
FROM inventario_produccion.articulos_areas,inventario_produccion.articulos, inventario_produccion.marcas
where id_area = ".$str2." and articulos_areas.codigo_articulo = articulos.codigo_articulo and articulos.id_marca = marcas.id_marca");
$col["edittype"] = "select"; // render as select
$col["editoptions"] = array("value"=>":;".$str);
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('{$col["name"]}'); },200); }";
$col["stype"] = "select"; // render as select
$col["searchoptions"] = array("value"=>$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('gs_{$col["name"]}');},200);}";
$cols[] = $col;
1 Answers
In first dropdown, you need to define onchange option mentioned field-to-update and sql query. e.g.
$sql = "SELECT articulos_areas.codigo_articulo, concat_ws(' ',nombre_articulo,tipo,nombre_marca)
FROM inventario_produccion.articulos_areas,inventario_produccion.articulos, inventario_produccion.marcas
where id_area = '{id_area}' and articulos_areas.codigo_articulo = articulos.codigo_articulo and articulos.id_marca = marcas.id_marca";
$col["editoptions"] = array("value"=>":;".$area_lookup);
$col["editoptions"]["onchange"] = array( "update_field" => "codigo_articulo", "sql" => $sql );
For working example, refer demos/appearance/dropdown-dependent.php
thanks, I’m gonna try it
Your Answer

