I need your help.
I need to put a column of type “combo” in a dhtmlxGrid but it must be filled with the dhtmlxconnector and have dhtmlxcombo functionalities.
Appreciate if you can get an example of how to code this behavior as the interaction is only in the server and not in xml file
my email is .
/******************* my code ********/
var mygrid2 = tabbar.cells(“a3”).attachGrid();
mygrid2.setImagePath("dhtmlxConnector_php/samples/common/imgs/");
mygrid2.setHeader("IDJORNADA,IDPARALELO,CODIGOMATERIA, JORNADA , PARALELO , MATERIA , PROFESOR ");
mygrid2.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter")
mygrid2.setInitWidths("20,20,20,80,80,200,300")
mygrid2.setDateFormat("%Y-%m-%d");
mygrid2.setColTypes("ro,ro,ro,ro,ro,ro,combo");
mygrid2.setColSorting("connector,connector,connector,connector,connector,connector,connector")
mygrid2.setColSorting("str,str,str,str,str,str,str")
mygrid2.enableSmartRendering(true);
mygrid2.enableMultiselect(true);
mygrid2.setSkin("dhx_skyblue");
//mygrid2.enableLightMouseNavigation(true);
mygrid2.init();
mygrid2.setColumnIds("IDJORNADA,IDPARALELO,CODIGOMATERIA,JORNADA,PARALELO,MATERIA,IDPROFESOR");
mygrid2.loadXML("php/getMateriasAsignadas.php");
var dp2 = new dataProcessor("php/getMateriasAsignadas.php");
dp2.init(mygrid2);
dp2.setUpdateMode("off");
/****************************/
/* my server code */
$sql_doc =“SELECT IDPROFESOR as value,
concat( RTRIM(LTRIM(APELLIDO1)),’ ‘,RTRIM(LTRIM(APELLIDO2)),’ ‘,RTRIM(LTRIM(NOMBRE1)),’ ',RTRIM(LTRIM(NOMBRE2))) as label FROM sca_profesor”;
$docentesOpciones = new OptionsConnector($conn);
$docentesOpciones->render_sql($sql_doc,“IDPROFESOR”,“IDPROFESOR(value),label(label)”);
$sql = “SELECT CONCAT(sca_materia_profesor.IDJORNADA,sca_materia_profesor.IDPARALELO,
sca_materia_profesor.CODIGOMATERIA,sca_materia_profesor.IDPROFESOR) CLAVE,
sca_materia_profesor.IDJORNADA ,
sca_materia_profesor.IDPARALELO ,
sca_materia_profesor.CODIGOMATERIA ,
sca_jornada.DESJORNADA ,
sca_paralelo.DESPARALELO ,
sca_materias.DESMATERIA ,
sca_materia_profesor.IDPROFESOR
FROM
sca_periodo , sca_materia_profesor ,sca_materias , sca_jornada , sca_paralelo
where sca_periodo.ACTIVO = 1 and sca_materias.ACTIVA = 1 and sca_materia_profesor.ACTIVO = 1 and
sca_periodo.IDESCUELA = sca_materia_profesor.IDESCUELA and
sca_periodo.INICIOPERIODO = sca_materia_profesor.INICIOPERIODO and
sca_periodo.FINALPERIODO = sca_materia_profesor.FINALPERIODO and
sca_paralelo.IDPARALELO = sca_materia_profesor.IDPARALELO and
sca_jornada.IDJORNADA = sca_materia_profesor.IDJORNADA and
sca_materias.CODIGOMATERIA = sca_materia_profesor.CODIGOMATERIA and
sca_materia_profesor.IDESCUELA = “.$_SESSION[“escuela”].” and
sca_materia_profesor.INICIOPERIODO= '”.$_SESSION[“inicioperiodo”]."’ and
sca_materia_profesor.FINALPERIODO = ‘".$_SESSION[“finalperiodo”]."’
order by sca_jornada.DESJORNADA,sca_paralelo.DESPARALELO,sca_materias.DESMATERIA
";
$grid_mat_asig = new GridConnector($conn);
$grid_mat_asig->enable_log(“temp.log”,true);
$grid_mat_asig->dynamic_loading(1000);
$grid_mat_asig->sql->attach(“Update”,“UPDATE sca_materia_profesor
SET
IDPROFESOR=’{IDPROFESOR}’
WHERE
IDESCUELA = “.$_SESSION[“escuela”].” and
INICIOPERIODO= '”.$_SESSION[“inicioperiodo”]."’ and
FINALPERIODO = ‘".$_SESSION[“finalperiodo”]."’ and
IDJORNADA = {IDJORNADA} and
IDPARALELO= {IDPARALELO} and
CODIGOMATERIA = ‘{CODIGOMATERIA}’ " );
$grid_mat_asig->set_options(“IDPROFESOR”,$docentesOpciones);
$grid_mat_asig->render_sql( $sql ,“CLAVE”,“IDJORNADA,IDPARALELO,CODIGOMATERIA, DESJORNADA,DESPARALELO, DESMATERIA , IDPROFESOR”);
/* ****************************/
if i put
mygrid2.setColTypes(“ro,ro,ro,ro,ro,ro,coro”);
work is correct but no present combo
if i put
mygrid2.setColTypes(“ro,ro,ro,ro,ro,ro,combo”);
the error is:
/******************/
Message: Object doesn’t support this property or method
Line: 1579
Char: 733
Code: 0
URI: localhost/federacion/dhtmlxConne … /dhtmlx.js
/****************/
i understand dhtmlxConnector not supported “combo” type inside the dhtmlxgrid
Please
your comments is greatly appreciated