Combo Excel Error

Suite and Optimus Suite 5
#1

I m trying to do a simple thing here, wich is use a combo into the grid, but with the combo data loaded from Oracle too:

grid.setHeader(“Código,Descrição,Umed.,Custo s/ Encargos, % de Encargos, Perc. Func., Custo Unitário, Qtde. Padrão Mês, Moeda,Grupos de Programas, Tipo de Insumo , Cond. Pagto/Antecip. Compra”);
grid.setColTypes(“ed,ed,combo,price,dyn,dyn,price,dyn,co,co,co,co”);
grid.attachHeader(“#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter”);
grid.setInitWidths(“70,250,80,80,80,80,80,80,80,80,80,320”);
grid.setColSorting(“str,str,str,int,int,int,int,int,str,str,str,str”);
grid.setColAlign(“left,left,center,center,center,center,center,center,center,center,center,center”);
grid.enableSmartRendering(true);

try{
var umed = grid.getColumnCombo(2);
//umed.enableFilteringMode(false);
umed.loadXML(“PHPLib/oracle/umed.php”);}catch(error){alert(error)}
grid.loadXML(‘PHPLib/oracle/info.php’);}catch(error){alert(error)}

So could load the data normaly but the combo junst dont show itself.

Any guess???
Look in the image the error

Also i tried to load data from PHP gridconector , all the properties work normaly but only the combo excel dont work.

look the cod :

$header = new GridConfiguration();
$header->setHeader(“Código,Descrição,Umed.,Custo s/ Encargos, % de Encargos, Perc. Func., Custo Unitário, Qtde. Padrão Mês, Moeda,Grupos de Programas, Tipo de Insumo , Cond. Pagto/Antecip. Compra”);
$header->attachHeader(“#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter”);
$header->setColTypes(“ed,ed,combo,price,dyn,dyn,price,dyn,combo,combo,combo,combo”);
$header->setInitWidths(“70,250,80,80,80,80,80,80,80,80,80,320”);
$header->setColAlign(“str,str,str,int,int,int,int,int,str,str,str,str”);
$header->setColSorting(array(“str”,“str”,“str”,“int”,“int”,“int”,“int”,“int”,“str”,“str”,“str”,“str”));
$header->attachFooter(“Vitor”);

$Umed = new OptionsConnector($res);
$Umed->render_table(“UNIDADES_MEDIDA_ENG”,“UNIM_SIG”,"UNIM_SIG ,UNIM_SIG ");
$grid->set_config($header);
$grid->set_options(‘UMED’,$Umed);
$grid->dynamic_loading(1000);

$grid->render_sql(“SELECT * FROM ITENS_ORCAMENTO tt WHERE ITOR_EPRD_COD = ‘VA025’ AND ITOR_TIPO_ITEM = ‘CAMO’”,
“ITOR_COD”,“ITOR_COD,ITOR_DESC,UMED,ITOR_CUSTO_UNIT_SENC,ITOR_PERC_ENCARGOS,
ITOR_FATOR_MO,ITOR_CUSTO_UNIT_ITEM,ITOR_QTD_HRS_PADRAO_MES,ITOR_MOOR_SIG,ITOR_GRPR_COD,ITOR_TPIN_COD,ITOR_COND_PAGTO”);

All the config header works alright but the options combo dont load at the page.

error.png819×460 22.7 KB

#2

I m posting all the code:

Using Grid conector

<?php require("../../Obj/Connector/codebase/grid_config.php"); require("../../Obj/Connector/codebase/db_oracle.php"); require("../../Obj/Connector/codebase/grid_connector.php"); $res= oci_connect('sisengweb', 'sisengweb', 'homolog'); $grid = new GridConnector($res,"Oracle"); //header //grid.setHeader("Código,Descrição,Umed.,Custo s/ Encargos, % de Encargos, Perc. Func., Custo Unitário, Qtde. Padrão Mês, Moeda,Grupos de Programas, Tipo de Insumo , Cond. Pagto/Antecip. Compra"); //grid.attachHeader("#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter"); //grid.setColTypes("ed,ed,co,price,dyn,dyn,price,dyn,co,co,co,co"); //grid.setInitWidths("70,250,80,80,80,80,80,80,80,80,80,320"); //grid.setColSorting("str,str,str,int,int,int,int,int,str,str,str,str"); //grid.attachFooter("Vitor"); //$config->setHeader("Item Name,Item CD"); $header = new GridConfiguration(); $header->setHeader("Código,Descrição,Umed.,Custo s/ Encargos, % de Encargos, Perc. Func., Custo Unitário, Qtde. Padrão Mês, Moeda,Grupos de Programas, Tipo de Insumo , Cond. Pagto/Antecip. Compra"); $header->attachHeader("#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter"); $header->setColTypes("ed,ed,combo,price,dyn,dyn,price,dyn,combo,combo,combo,combo"); $header->setInitWidths("70,250,80,80,80,80,80,80,80,80,80,320"); $header->setColAlign("str,str,str,int,int,int,int,int,str,str,str,str"); $header->setColSorting(array("str","str","str","int","int","int","int","int","str","str","str","str")); $header->attachFooter("Vitor"); //header //$Umed $Umed = new OptionsConnector($res); $Umed->render_table("UNIDADES_MEDIDA_ENG","UNIM_SIG","UNIM_SIG ,UNIM_SIG "); //$Umed $grid->set_config($header); $grid->set_options('[b]UMED[/b]',$Umed); $grid->dynamic_loading(1000); //$grid->render_table("ITENS_ORCAMENTO","ITOR_COD","ITOR_COD(cod),ITOR_DESC,ITOR_UNIM_SIG,ITOR_CUSTO_UNIT_SENC,ITOR_PERC_ENCARGOS, $grid->render_sql("SELECT * FROM ITENS_ORCAMENTO tt WHERE ITOR_EPRD_COD = 'VA025' AND ITOR_TIPO_ITEM = 'CAMO'", "ITOR_COD","ITOR_COD,ITOR_DESC,[b]UMED[/b],ITOR_CUSTO_UNIT_SENC,ITOR_PERC_ENCARGOS, ITOR_FATOR_MO,ITOR_CUSTO_UNIT_ITEM,ITOR_QTD_HRS_PADRAO_MES,ITOR_MOOR_SIG,ITOR_GRPR_COD,ITOR_TPIN_COD,ITOR_COND_PAGTO"); //header //Unidade de medida //$Umed = new OptionsConnector($res); //$Umed->render_table("UNIDADES_MEDIDA_ENG","UNIM_SIG","UNIM_SIG(value),UNIM_SIG(label)"); //echo $Umed; //Unidade de medida ?>

The other way that i m trying to do, using Js

function ConfigGrid(grid,itemId){

grid.setImagePath("Obj/GridS/codebase/imgs/");	
//Coloca os headers das grids de acordo com a opcao selecionada	
try{   	

	/*if 	(itemId=='Cen'){
		grid.setHeader("A,B,C,D,E");
		grid.setInitWidths("100,850,100,100,100");
	}
	if 	(itemId=='Sub'){
		grid.setHeader("A,B,C,D,E");
		grid.setInitWidths("100,850,100,100,100");
	}
  	if 	(itemId=='Mate'){
  		grid.setHeader("A,B,C,D,E");
		grid.setInitWidths("100,850,100,100,100");
  	}*/
	if 	(itemId=='Mano'){
		grid.setHeader("Código,Descrição,Umed.,Custo s/ Encargos, % de Encargos, Perc. Func., Custo Unitário, Qtde. Padrão Mês, Moeda,Grupos de Programas, Tipo de Insumo , Cond. Pagto/Antecip. Compra");			
		grid.setColTypes("ed,ed,combo,price,dyn,dyn,price,dyn,co,co,co,co");
		grid.attachHeader("#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter,#text_filter");			
		grid.setInitWidths("70,250,80,80,80,80,80,80,80,80,80,320");
		grid.setColSorting("str,str,str,int,int,int,int,int,str,str,str,str");
		grid.setColAlign("left,left,center,center,center,center,center,center,center,center,center,center");
		grid.enableSmartRendering(true);
		grid.attachFooter("Vitor");
		//grid.enablePaging(true, 100, 1, "pagingArea", true, "recinfoArea");
		//grid.setPagingSkin("toolbar","dhx_black");
	}

}catch(error){alert(error)}

//grid.setSkin("modern");
grid.init();
try{
var umed = grid.getColumnCombo(2);
umed.enableFilteringMode(false);
umed.loadXML("PHPLib/oracle/umed.php");}catch(error){alert(error)}


try{

grid.loadXML('PHPLib/oracle/info.php');}catch(error){alert(error)}

}

#3

And yes i tried to do gridconector this way

$Umed->render_table(“UNIDADES_MEDIDA_ENG”,“UNIM_SIG”,“UNIM_SIG(value) ,UNIM_SIG(label)”);

#4

But my bigest problema is with the combo into the Grid dont show itself with the options, it seems to be behind the lines.

I need to show a little project and this is realy a problem for me.
Thank you