Hi,

My datasource is looking as follow:

[day, hour_num, teacher_id, teacher_name, class_id]

each row represent a single hour in a specific weekday.

for example

[1, 1, 1, 'John Do', 1] The teacher John Do is teaching class 1 on Sunday (1) First Hour (1) I want to to be able to generate this report but not to look like a table but like a teacher schedule look attached image for example

Sir, any comment?

this is what i get

require_once APPPATH."/libraries/koolreport/core/autoload.php";
use \koolreport\cube\processses\Cube;
class Teacher_schedule extends \koolreport\KoolReport
{
    
    function setup()
    {
        $this->src('sbm')
        ->query('CALL getTeacherSchedule(:year, :teacher_id)')
        ->params(array(
            ":year"=>$this->params["year"],
            ":date"=>$this->params["teacher_id"]
        ))
        ->pipe(new \koolreport\cube\Cube(array(
            "row" => "hour_num",
            "column" => "day",
            "count" => "teacher_id",
        )))
        ->pipe($this->dataStore("st"));
    }
}

An uncaught Exception was encountered Type: Error

Message: Class 'koolreport\cube\Cube' not found

Filename: /var/www/parashapp.com/public_html/dev/sbm/application/reports/Teacher_schedule.php

Line Number: 33

Backtrace:

File: /var/www/parashapp.com/public_html/dev/sbm/application/libraries/koolreport/core/src/KoolReport.php Line: 100 Function: setup

File: /var/www/parashapp.com/public_html/dev/sbm/application/controllers/Report.php Line: 30 Function: __construct

File: /var/www/parashapp.com/public_html/dev/sbm/index.php Line: 315 Function: require_once

Gives the same error in both options

I have the pro version. I am using it with codeigniter and it in the library folder. I have other report that is using datagrid and it is working but with the cube it is making a problem. I verified the the cube folder exists and it is!

this is a screen shot of the project folder where the koolreport is located

tnx david. btw this typo appears in your documentation website

https://www.koolreport.com/docs/cube/cube_process/

<?php
use \koolreport\cube\processses\Cube;
class MyReport extends \koolreport\KoolReport
{
    ...
    public function setup()
    {
        $this->src('sales')
        ->query("SELECT country,product,sale from tblPurchases")
        ->pipe(new Cube(array(
            "row"=>"country",
            "column"=>"product",
            "sum"=>"sale"
        )))
        ->pipe($this->dataStore('sales'));
    }
}

this is where I took it from

this is the code of the view

Table::create(array(
            "dataSource"=>$this->dataStore("st"),
             "cssClass"=>array(
                "table"=>"table table-bordered",
                "th"=>"table-dark",
            )
        ))

and this is the result

1. I want to remove/hide the {{all}} column
2. I want to replace the day number and hour number to text

tnx david. I want to add extra data that is in the stored procedure. currently I display only class_name in each <TD> but I want to add profession_name and group_name both are from the stored procedure. when I defined the cube it give me only class name. please view the setup:

function setup()
    {
        $this->src('sbm')
        ->query('CALL getTeacherSchedule(:year, :teacher_id)')
        ->params(array(
            ':year'=>$this->params['year'],
            ':teacher_id'=>$this->params['teacher_id']
        ))
        ->pipe(new Cube(array(
            'row' => 'hour_num',
            'column' => 'day',
            'max' => 'class_name',
        )))
        ->pipe(new \koolreport\processes\RemoveColumn(array(
            '{{all}}'
        )))
        ->pipe(new \koolreport\processes\ColumnMeta(array(
            'hour_num'=>array('label'=>lang('hour_num')),
            '1' => array("label" => lang('day_1')),
            '2' => array("label" => lang('day_2')),
            '3' => array("label" => lang('day_3')),
            '4' => array("label" => lang('day_4')),
            '5' => array("label" => lang('day_5')),
            '6' => array("label" => lang('day_6')),
        )))
        ->pipe($this->dataStore("st"));
    }

I want each TD to display more columns (class_name, group_name, profession_name etc)

I need all the data inside one cell no to generate more columns. superCube will just add me more columns

1. when I do this it is doing the job BUT the right side column of hour_num which should display the hour number of each day is gone.
2. in each cell where the is not value I see 0. I need it to be empty string /null

still see 0 in empty cells

I fixed the code a little bit and it did the job ` ->pipe(new Map(array(

        "{value}" => function($row) {
            foreach ($row as $k => $v)
                if ($v == null) $row[$k] = 0;
            return $row;
        }
    )))

I have two extra questions:
1. I want to display in each report page a different teacher schedule. the datasource will include rows with all the teachers. teacher_id is the unique column for each teacher's schedule. 
2. In the datasource I have a column called "teacher_name" I want to display this name in the top of the table but not part of the table element like this 

sorry i missed this part <h3 class="text-center"><u><?php echo $row['teacher_name']; ?></u></h3>

sir?

Can you give me a sample code how to do it. this is my current setup function

function setup()
    {
        $this->src('sbm')
        ->query('CALL getTeacherSchedule(:year, :teacher_id)')
        ->params(array(
            ':year'=>$this->params['year'],
            ':teacher_id'=>$this->params['teacher_id']
        ))
        ->pipe(new \koolreport\processes\Map(array(
            "{value}" => function($row) {
                $row['class_name'] =
                    $row['group_name'].'<br>'.
                    ( $this->params['show_class'] != null ? $row['class_name'] != '' ? $row['class_name'] : 'ללא כיתה' : null ).'<br>'.
                    ( $this->params['show_profession'] != null ? $row['profession_name'] : null ).'<br>'.
                    ( $this->params['show_room'] != null ? $row['room_name'] : null );
                $this->teacherName = $row['teacher_name'];
                return $row;
            }
        )))
        ->pipe(new Cube(array(
            'row' => 'hour_num',
            'column' => 'day',
            'max' => 'class_name'
        )))
        ->pipe(new \koolreport\processes\Map(array(
            "{value}" => function($row) {
                foreach ($row as $k => $v)
                    if ($v == null) $row[$k] = "";
                return $row;
            }
        )))
        ->pipe(new \koolreport\processes\RemoveColumn(array(
            '{{all}}'
        )))
        ->pipe(new \koolreport\processes\ColumnMeta(array(
            'hour_num'=>array('label'=>lang('hour_num')),
            '1' => array("label" => lang('day_1')),
            '2' => array("label" => lang('day_2')),
            '3' => array("label" => lang('day_3')),
            '4' => array("label" => lang('day_4')),
            '5' => array("label" => lang('day_5')),
            '6' => array("label" => lang('day_6')),
        )))
        ->pipe($this->dataStore("st"));
    }

and the this is the view code:

<?php
    //MyReport.view.php
    use \koolreport\widgets\koolphp\Table;
?>
<html>
    <head>
        <title><?php echo lang('report_teacher_schdule'); ?></title></title>
        <style>
        @media print {
            .hidden-print {
                display: none !important;
            }
        }
        </style>
    </head>
    <body DIR="RTL">
        <div class="row">
            <div class="col text-center">
                <div class="hidden-print">
                    <button id="print" class="btn btn-success" href="<?php echo base_url('reports'); ?>" onclick="javascript: window.print()">
                        <?php echo lang('print'); ?>
                    </button>
                    <a class="btn btn-secondary mr-2" href="<?php echo base_url('reports'); ?>">
                        <?php echo lang('back'); ?>
                    </a>
                </div>
            </div>
        </div>
        <h1 class="text-center"><?php echo lang('report_teacher_schdule'); ?></h1>
        <h3 class="text-center"><u><?php echo $this->teacherName; ?></u></h3>

        <?php
        Table::create(array(
            "dataSource"=>$this->dataStore("st"),
            "cssClass"=>array(
                "table"=>"table table-bordered text-center",
                "th"=>"table-dark text-center",
            ),
            "sorting"=>array(
                "hour_num"=>"asc",
            )
        ))
        ?>
    </body>
</html>

Sir?

I will appreciate you response for the above?

I am trying to get your response for the last two weeks?

ok sir. wating for david.

ok I got it to work. tnx. now two questions: 1. In the report view header I have the teacher name. I do I make it to replace in each data source? 2. How do I make a page break for each teacher to be printed in a single page?

here is the code

<?php
//MyReport.php
require_once APPPATH."libraries/koolreport/core/autoload.php";
use \koolreport\cube\processes\Cube;
use \koolreport\processes\Filter;
class Teacher_schedule extends \koolreport\KoolReport
{
    use \koolreport\amazing\Theme;

    var $teacherName = "";

    function settings()
    {
        return array(
            "assets"=>array(
                "path"=>"../../assets",
                "url"=>"assets",
            ),
            "dataSources"=>array(
                "sbm"=>array(
                    "connectionString"=>"mysql:host=localhost;dbname=sbm",
                    "username"=>"admin",
                    "password"=>"9b72fa959aecee8a397ae1c3192ad30bef8ec2fe76cfe68a",
                    "charset"=>"utf8"
                )
            )
        );
    }

    function setup()
    {
        $this->src("sbm")
        ->query('CALL getTeacherSchedule(:year, :teacher_id)')
        ->params(array(
            ':year'=>$this->params['year'],
            ':teacher_id'=>$this->params['teacher_id']
        ))
        ->saveTo($node1);

        foreach (array(1,2,3,4) as $teacher) {
            $node1->pipe( new Filter( array (
                array("teacher_id", "=", $teacher)
            )))
            ->pipe(new \koolreport\processes\Map(array(
                "{value}" => function($row) {
                    $row['class_name'] =
                        $row['group_name'].'<br>'.
                        ( $this->params['show_class'] != null ? $row['class_name'] != '' ? $row['class_name'] : 'ללא כיתה' : null ).'<br>'.
                        ( $this->params['show_profession'] != null ? $row['profession_name'] : null ).'<br>'.
                        ( $this->params['show_room'] != null ? $row['room_name'] : null );
                    $this->teacherName = $row['teacher_name'];
                    return $row;
                }
            )))
            ->pipe(new Cube(array(
                'row' => 'hour_num',
                'column' => 'day',
                'max' => 'class_name'
            )))
            ->pipe(new \koolreport\processes\Map(array(
                "{value}" => function($row) {
                    foreach ($row as $k => $v)
                        if ($v == null) $row[$k] = "";
                    return $row;
                }
            )))
            ->pipe(new \koolreport\processes\RemoveColumn(array(
                '{{all}}'
            )))
            ->pipe(new \koolreport\processes\ColumnMeta(array(
                'hour_num'=>array('label'=>lang('hour_num')),
                '1' => array("label" => lang('day_1')),
                '2' => array("label" => lang('day_2')),
                '3' => array("label" => lang('day_3')),
                '4' => array("label" => lang('day_4')),
                '5' => array("label" => lang('day_5')),
                '6' => array("label" => lang('day_6')),
            )))
            ->pipe($this->dataStore("DS_" . $teacher));
        }    
    }
}

ok I managed to solve the issue with the teacher name in the header of each table. the only issue I have now is that I want each table (teacher) to appear is a single portrait page like page breaks. how do I do it?

its not working!

no