Hi I ma using a SuperCube and Datatable widget. I have issues with the header

this is the report code

function setup()
    {
        $this->src('db')
        ->query('CALL getSplitRewardReportFrom(:year)')
        ->params(array(
            ":year"=>$this->params["year"],
        ))
        ->pipe(new SuperCube(array(
            "rows" => "teacher_id, id_number",
            "columns" => "hour_num",
            "max" => 'profession_id, class_id',
            "sum" => "total_hours"
        )))
        ->pipe(new \koolreport\processes\RemoveColumn(array(
            '{{all}}','{{others}}'
        )))
        ->pipe($this->dataStore("st"));
    }

And this is the view code

<?php
        DataTables::create(array(
            "name" => "myTable",
            "language" => "he", //use 'DataTables.de.json'
            "dataSource"=>$this->dataStore("st"),
            "emptyValue" => "", // use an empty string as filler for empty values
            "options"=>array(
                "colReorder"=>false,
                'autoWidth' => false,
                "order"=>[],
                'ordering' => false,
                'columnDefs' => array(
                    array(
        				'visible' => false,
        				//'targets' => [$this->monthDays+6], //hide the first column
        			)
        		),
            ),
            'complexHeaders' => true,
            'headerSeparator' => ' - ',
            "groupCellsInColumns" => [0, 1], // group similar cells in columns
            'cssClass'=>array(
                'table'=>'table table-bordered',
                'tr'=>'cssItem',
                'td'=>function($row,$colName)
                {
                    return in_array($colName, array('teacher_id','id_number')) ? 'border-dark text-right' : 'border-dark text-center';
                },
                'th'=>function($colName)
                {
                    return in_array($colName, array('teacher_id','id_number')) ? 'table-dark border-dark text-right' : 'table-dark border-dark text-center';
                },
            ),
        ));
        echo '<div class="footer print-only">'.lang('tts.print_footer').'</div>';
        ?>

This is the result header that I get

1. how do I remove the {{all}} | profession_id column.
2. How to I remove the hour_num top header that was generated.
3. How to I update a label of a column like 1 | profession_id and the one in the bottom called max?

?

Hello I need complex headers. the top row is hour number 1 to 7 in each hour there are three columns class_id, profession_id and total_hours

like this:

I need to output to look like this

and not like this

?

After Applying SuperCube I am getting a header with three headers like this:

My question is how do I change the header to look like I need. I need to apply rowsapn on the header in the top level while on the bottom it will say split like this

Yes. I did not manage solving the problem with this solution: 1. I don't know how to make a rowspan of a column on the code. 2. how can I remove the top column hour_num generated by the SuperCube

When using

complexheader = true 
'headerSeparator' => ' | ',

the following code does not change the labels of the $meta

->pipe(new \koolreport\processes\Map(array(
            "{meta}" => function($meta) {
                $colMetas = $meta["columns"];
                foreach ($colMetas as $colKey => $colMeta) {
                    if (strpos($colKey, 'hour_num')!== false) {
                        $colMetas[$colKey]['label'] = rand();
                    }
                    // = lang("tts.$colKey"); //for column 'hour_num'
                }
                $meta["columns"] = $colMetas;
                return $meta;
            }
        )))

if I set complexheader = false the above code is working!

how to change the label of the header if I set complex header true?

Any updates?

?

IT does not matter what I ma trying to do in the code, right after the SuperCube process the table column names does not change. you code is not working in this case.

This is the code of the

function setup()
    {
        $this->src('db')
        ->query('CALL getSplitRewardReportFrom(:year)')
        ->params(array(
            ":year"=>$this->params["year"],
        ))
        ->pipe(new SuperCube(array(
            "rows" => "teacher_id, id_number",
            "columns" => "hour_num",
            "max" => 'profession_id, class_id',
            "sum" => "total_hours"
        )))
        ->pipe(new \koolreport\processes\Map(array(
            "{value}" => function($row) {
                foreach ($row as $colName => $colValue) {
                    if (substr( $colName, 0, 11 ) === "hour_num | ") {
                        $newColName = substr($colName, 11);
                        $row[$newColName] = $row[$colName];
                        unset($row[$colName]);
                    }
                }
                return $row;
            }
        )))
        ->pipe(new \koolreport\processes\RemoveColumn(array(
            'hour_num - {{all}} | profession_id - max','hour_num - {{all}} | class_id - max','hour_num - {{all}} | total_hours - sum'
        )))
        ->pipe($this->dataStore("st"));
    }

The column names remains the same "hour_num - 1", "hour_num - 2" etc.

?

ok it seems to work and this is the list of columns I get after the Map process

string(10) "teacher_id"
string(9) "id_number"
string(23) "1 | profession_id - max"
string(23) "2 | profession_id - max"
string(23) "3 | profession_id - max"
string(23) "4 | profession_id - max"
string(23) "5 | profession_id - max"
string(23) "6 | profession_id - max"
string(23) "7 | profession_id - max"
string(18) "1 | class_id - max"
string(18) "2 | class_id - max"
string(18) "3 | class_id - max"
string(18) "4 | class_id - max"
string(18) "5 | class_id - max"
string(18) "6 | class_id - max"
string(18) "7 | class_id - max"
string(21) "1 | total_hours - sum"
string(21) "2 | total_hours - sum"
string(21) "3 | total_hours - sum"
string(21) "4 | total_hours - sum"
string(21) "5 | total_hours - sum"
string(21) "6 | total_hours - sum"

I am trying to change the label of the columns using the method

$colMetas[$newColName] ["label"]= lang($newColName);

but it is not working. the labels remain the same!

?

I can not use the real columns names because the SuperCube process changes it by adding Sum, Max etc. Beside that can I do ComplexHeader in Table Widget?

You should make DataTable support label change very fast because in most reports I use DataTable and I can't use the real column names in the stored procedure because it is multi language! please add it in the next version and let me know!