myLKW_report.class.php

Go to the documentation of this file.

<?php
namespace dbx\myLKW;
 
dbx()->use_system_class('dbxReport');
use function dbx\myLKW\dbx_get_datum;
 
 
class dbxReport_Dispo extends \dbxReport {
 
    public function run_body($content) {
        $activ_id = $this->_activ_id;
        $record   = $this->_record;
 
        
        $record['observacion']      = str_repeat('&nbsp;', 10);
        $record['d2_carga_lugar']   = substr($record['d2_carga_lugar'], 0, 10);
        $record['d2_observaciones'] = substr($record['d2_observaciones'], 0, 7);
 
        $this->_class_body['TIPO']=$record['TIPO'] ;
        
 
 
        $this->_class_body['d2_carga_region']=$this->_class_body['d2_carga_region'] = strtoupper(substr($record['d2_carga_region'], 0, 1));
        
        $record['TIPO'] = str_replace('-', '&#8209;', $record['TIPO']);
        $this->_record=$record;
        $content=$this->forward_run_body($content);
        return $content;
    }
}
 
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 
 
 
 
 
 
 
 
 
class myLKW_report {
 
private function get_report_dispo($page=0,$col=0) {
 
    $dd      = 'lkw';
    $form_id = 'report-dispo-prn-'.$page.'-'.$col;
 
    $oReport = new dbxReport_Dispo;
 
    // WICHTIG: Keine interne Pagination
    $oReport->init($form_id, 'report-dispo-prn', 999999, 999999, 0);
 
    $oReport->_dd       = $dd;
  
 
    $oDB = dbx()->get_system_obj('dbxDB');
 
    $flds = [
        'id'               => '',
        'TRACTOR'          => 'TRACTOR',
        'TIPO'             => 'TIPO',
        'd2_carga_region'  => 'Reg.',
        'd2_carga_lugar'   => 'Lugar',
        'd2_observaciones' => 'Obser.',
        'observacion'      => 'observación',
    ];
    
 
    
    // -----------------------------------------
    // NEU: TIPO BASIERTE SEITENLOGIK
    // -----------------------------------------
 
    $perColumn = 54;
 
    // Seite 1 definierte TIPOs
    $tipos_page1 = [
        'PM',
        'TL-PM',
        'DK-PM',
        'TAL',
        'BAN',
        'LT-BAS',
        'AST'
    ];
 
    $rwhere = 'TRACTOR > " "';
 
    // -----------------------------------------
    // WHERE nach Seite
    // -----------------------------------------
 
    if ($page == 1) {
 
        $tipoList = "'" . implode("','", $tipos_page1) . "'";
        $rwhere  .= " AND TIPO IN ($tipoList)";
 
    } else {
 
        $tipoList = "'" . implode("','", $tipos_page1) . "'";
        $rwhere  .= " AND (TIPO NOT IN ($tipoList) OR TIPO IS NULL OR TIPO='')";
 
    }
 
    // -----------------------------------------
    // OFFSET NUR innerhalb gefilterter Daten
    // -----------------------------------------
 
    $rrows = $perColumn;
    $rpos  = ($col - 1) * $perColumn;
 
    // -----------------------------------------
    // SORT
    // -----------------------------------------
 
    $rsort = 'TIPO DESC, d2_carga_region ASC, TRACTOR ASC';
    $rdesc  = '';
    $rgroup = '';
 
    $count = $oDB->count($dd,$rwhere);
 
    $rdata = $oDB->select(
        $dd,
        $rwhere,
        $flds,
        $rsort,
        $rdesc,
        $rgroup,
        $rrows,
        $rpos
    );
 
    dbx()->debug("LKW Print page=($page) col=($col) rpos=($rpos) rows=($rrows)");
 
    // -----------------------------------------
    // Report Setup – DRUCKMODUS
    // -----------------------------------------
 
    $oReport->_rcount = count($rdata);
    $oReport->_rdata  = $rdata;
 
    $oReport->_pages  = 0;
    $oReport->_mode   = 'table';
    $oReport->_rflds  = $flds;
 
    // WICHTIG: Alles deaktivieren
    $oReport->_create_sel_flds    = 0;
    $oReport->_create_row_select  = 0;
    $oReport->_create_row_edit    = 0;
    $oReport->_create_row_copy    = 0;
    $oReport->_create_row_delete  = 0;
    $oReport->_create_row_print   = 0;
    $oReport->_data_table         = 0;
 
    $oReport->set_style_haeder('TIPO','width:42px');
    
    $oReport->set_style_haeder('TRACTOR','width:74px');
    $oReport->set_style_haeder('d2_carga_region','width:30px');
    
    $oReport->set_style_haeder('d2_carga_lugar','width:80px');
    
    $oReport->set_style_haeder('d2_observaciones','width:40px');
    
    //$oReport->set_style_haeder('observacion','width:100%');
   
 
 
    $content= $oReport->run(0,$flds);
    return $content;
}
     
 
  /* ========================================================= */

    public function run() {
        $oTPL = dbx()->get_system_obj('dbxTPL');
        $page = dbx()->get_modul_var('page',0,'int');
        $col  = dbx()->get_modul_var('col' ,0,'int');
    
 
        $data['date'] = dbx_get_datum('day dd month yyyy', 1);
        dbx()->debug("myLKW_report page=($page) col=($col)");
        if (!$page && !$col) { 
            $page=dbx()->get_modul_var('dbx_page',0,'parameter');
            if ($page) dbx()->set_system_var('dbx_page',$page);  // window support 
            $data = array_merge($data, array(
                'frame_id'            => 'lkw_report',
                'frame_panel_class'   => 'dbxReport noPrint',
                'frame_panel_attrs'   => '',
                'frame_subbar'        => '',
                'frame_form_open'     => '',
                'frame_form_close'    => '',
                'frame_body_class'    => '',
                'frame_body_head'     => '',
                'frame_body_tail'     => '',
                'bar_class'           => 'dbx-module-bar noPrint',
                'bar_title_class'     => 'dbx-module-bar-titleblock',
                'bar_actions_class'   => 'dbx-module-bar-actions',
                'bar_title'           => 'LKW Report',
                'bar_icon'            => 'bi-printer',
                'bar_subtitle'        => '',
                'bar_title_pre'       => '',
                'bar_title_heading_attrs' => '',
                'bar_middle'          => '',
                'bar_extra'           => '',
                'bar_actions'         => $oTPL->get_tpl('myLKW|report-lkw-print-action'),
            ));
            $content=$oTPL->get_tpl('myLKW|report-lkw-cols',$data);
 
        }    
        if ($page && $col) {
            $content=$this->get_report_dispo($page,$col);
            // hier kommt dann der Report Aufruf hin der den content einer seiter einer spalte zurück gibt
 
        }
        return $content;
    }
 
    /* ========================================================= */
 
}