How to set a colspan in a grid in dhtmlx 5


#1

$dom = new myDomDocument();

//XML Root
$root = $dom->addElement($dom, "rows", "");

//Config
$head = $dom->addElement($root, "head", "");

$column = $dom->addElement($head, "column", '');
addConfig($column, '50', 'left', 'ro', 'str', 'true', '', 'ID_COLUMN1');
$column = $dom->addElement($head, "column", '');
addConfig($column, '50', 'left', 'ro', 'str', 'true', '', 'ID_COLUMN2');
$column = $dom->addElement($head, "column", '');
addConfig($column, '90', 'left', 'ro', 'str', 'true', '', 'ID_COLUMN3');
$column = $dom->addElement($head, "column", '');
addConfig($column, '80', 'left', 'ro', 'str', 'true', '', 'ID_COLUMN4');



// $column = $dom->addElement($head, "column", _("IdRisk"));

// addConfig($column, ‘100’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘ID_RISK’);
//$column = $dom->addElement($head, “column”, _(“IdGlobal”));
// addConfig($column, ‘100’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘ID_GLOBAL’);
$column = $dom->addElement($head, “column”, _(“RiskAreaCategory”));
addConfig($column, ‘140’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISK_NAME’);
$column = $dom->addElement($head, “column”, _(“ValidFrom”));
addConfig($column, ‘80’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISKCONTROL_DATEFROM’);
$column = $dom->addElement($head, “column”, _(“ValidTo”));
addConfig($column, ‘80’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISKCONTROL_DATETO’);
$column = $dom->addElement($head, “column”, _(“RiskArea”));
addConfig($column, ‘180’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISK_AREA’);
$column = $dom->addElement($head, “column”, _(“RiskCategory”));
addConfig($column, ‘140’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISK_CATEGORY’);
$column = $dom->addElement($head, “column”, _(“RiskSubcategory”));
addConfig($column, ‘140’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘RISK_SUBCATEGORY’);
$column = $dom->addElement($head, “column”, _(“RiskObjective”) );
addConfig($column, ‘200’, ‘left’, ‘ro’, ‘str’, ‘true’, ‘’, ‘GW_CONTROL_OBJECTIVE’);
$column = $dom->addElement($head, “column”, _(“MinimumRequirement”) );
addConfig($column, ‘90’, ‘center’, ‘roch’, ‘str’, ‘true’, ‘’, ‘MINIMUM_REQUIREMENT’);
$column = $dom->addElement($head, “column”, ‘Essential Of Risk’);
addConfig($column, ‘90’, ‘left’, ‘roch’, ‘str’,‘true’, ‘’, ‘ID_REQCOLUMN1’);

  $column = $dom->addElement($head, "column", '');
  addConfig($column, '90', 'left', 'roch', 'str', 'true', '', 'ID_REQCOLUMN2');
  $column = $dom->addElement($head, "column", '');
  addConfig($column, '90', 'left', 'roch', 'str', 'true', '', 'ID_REQCOLUMN3');
  $column = $dom->addElement($head, "column", '');
  addConfig($column, '90', 'left', 'roch', 'str', 'true', '', 'ID_REQCOLUMN4');
  $column = $dom->addElement($head, "column", '');
  addConfig($column, '90', 'left', 'roch', 'str', 'true', '', 'ID_REQCOLUMN5');

$beforeInit = $dom->addElement($head, “beforeInit”, “”);
$call = $dom->addElement($beforeInit, “call”, “”);
$call->setAttribute(“command”, “attachHeader”);

$param = $dom->addElement($call, "param", "#combo_filter,#combo_filter,#combo_filter,#combo_filter,#text_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#text_filter,#combo_filter,,,,,,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#text_filter,#text_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#text_filter,#text_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter,#combo_filter");

//Config
$head = $dom->addElement($root, “head”, “”);

//Config
$head = $dom->addElement($root, “head”, “”);

$db->closeConn();


header("Content-Type: text/xml");
print $dom->saveXML();

i need to merge ID_REQCOLUMN2,ID_REQCOLUMN3,ID_REQCOLUMN4,ID_REQCOLUMN5 these four column into single column.like colspan4 for ex.essential of risk column under these 4 columns.

how to do this in a grid.my code look like above

Please help me urgent


#2

https://docs.dhtmlx.com/grid__headers_and_footers.html#colspansrowspans
all the columns of the co0lspan (ID_REQCOLUMN3,ID_REQCOLUMN4,ID_REQCOLUMN5) should have the “#cspan” as a title of the column.