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