How to overwrite the core file to remove the timezone from the print to pdf file, How can we do this through the customization?

Path: sugar\modules\Reports\sugarpdf\sugarpdf.reports.php

Code : $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name, $timedate->getNow(true)"));

$timedate->getNow(true) instead of this we need to replace "date("D M j G:i:s")

Parents

0 Neeraja P over 5 years ago
Hi Gurpreet Singh,

Though it is not possible to edit the sugarpdf.reports.php, it is actually being extended by other sub-classes, which is the one you have to override. But - the only downside is that, you have to copy the whole file into your custom folder and customize it.

For example, for Summary report, the PDF file used is modules/Reports/sugarpdf/sugarpdf.summary.php, which extends sugarpdf.reports.php. So in order to override the report, you can copy the file from modules folder into custom/modules/Reports/sugarpdf/sugarpdf.summary.php and modify the preDisplay section to set the header that you need, eg:

Fullscreen
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
class ReportsSugarpdfSummary extends ReportsSugarpdfReports
{
function preDisplay()
{
parent::preDisplay();
//Set PDF document properties
if ($this->bean->name == "untitled") {
$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module], date("D M j G:i:s"));
} else {
$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name, date("D M j G:i:s"));
}
}
function display()
{
// ... Copy and paste the code from modules/Reports/sugarpdf/sugarpdf.summary.php
}
}
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
<?php class ReportsSugarpdfSummary extends ReportsSugarpdfReports { function preDisplay() { parent::preDisplay(); //Set PDF document properties if ($this->bean->name == "untitled") { $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module], date("D M j G:i:s")); } else { $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name, date("D M j G:i:s")); } } function display() { // ... Copy and paste the code from modules/Reports/sugarpdf/sugarpdf.summary.php } }

But - there is a downside to this method. Sugar currently doesn't accept custom class names, so you have to copy the entire file (with the same ClassName) from modules/Reports folder into the custom folder - which adds additional work of merge/update during Sugar Upgrades.
0 Gurpreet Singh over 5 years ago in reply to Neeraja P

I have tried by the same way but it's not working for me.
0 Neeraja P over 5 years ago in reply to Gurpreet Singh

Gurpreet Singh, can you share the file and it's location? I can take a quick peek and see what's happening.

0 Gurpreet Singh over 5 years ago in reply to Neeraja P

File Path: custom/modules/Reports/sugarpdf/sugarpdf.summary.php

Fullscreen

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
class ReportsSugarpdfSummary extends ReportsSugarpdfReports
{
      function preDisplay(){
        parent::preDisplay();
        //Set PDF document properties
        if($this->bean->name == "untitled") {
            $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module], date("D M j G:i:s"));
            //$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module]);
        } else {
            $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name, date("D M j G:i:s"));//$timedate->getNow(true)
            //$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name);//$timedate->getNow(true)
        }
        
    }
    
    function display()
    {
        global $locale;
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

<?php

class ReportsSugarpdfSummary extends ReportsSugarpdfReports
{
      function preDisplay(){
        parent::preDisplay();
        //Set PDF document properties
   		if($this->bean->name == "untitled") {
            $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module], date("D M j G:i:s"));
			//$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $app_list_strings['moduleList'][$this->bean->module]);
        } else {
            $this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name, date("D M j G:i:s"));//$timedate->getNow(true)
			//$this->SetHeaderData(PDF_SMALL_HEADER_LOGO, PDF_SMALL_HEADER_LOGO_WIDTH, $this->bean->name);//$timedate->getNow(true)
        }
        
    }
	
	function display()
    {
        global $locale;

        //add chart
        if (isset($_REQUEST['id']) && $_REQUEST['id'] != false) {
            $this->bean->is_saved_report = true;
        }

        // fixing bug #47260: Print PDF Reports
        // if chart_type is 'none' we don't need do add any image to pdf
        if ($this->bean->chart_type != 'none') {
            $chartDisplay = new ChartDisplay();
            $xmlFile = $chartDisplay->get_cache_file_name($this->bean);

            $sugarChart = SugarChartFactory::getInstance();

            $shouldIncludeImage = true;
            // scheduleReportWithImage should not be set to true until chart gen service is in place
            if ($this->bean->isScheduledReport && empty(SugarConfig::getInstance()->get('schedule_report_with_chart'))) {
                $shouldIncludeImage = false;
            }
            if ($sugarChart->supports_image_export && $shouldIncludeImage) {
                $imageFile = $sugarChart->get_image_cache_file_name($xmlFile, ".".$sugarChart->image_export_type);
                // check image size is not '0'
                if (file_exists($imageFile) && getimagesize($imageFile) > 0) {
                    $this->AddPage();
                    list($width, $height) = getimagesize($imageFile);
                    $imageWidthAsUnits = $this->pixelsToUnits($width);
                    $imageHeightAsUnits = $this->pixelsToUnits($height);

                    $dimensions = $this->getPageDimensions();

                    $pageWidth = $dimensions['wk'];
                    $pageHeight = $dimensions['hk'];

                    $marginTop = $dimensions['tm'];
                    $marginBottom = $dimensions['bm'];
                    $marginLeft = $dimensions['lm'];
                    $marginRight = $dimensions['rm'];

                    $freeWidth = 0.9 * ($pageWidth - $marginLeft - $marginRight);
                    $freeHeight = 0.9 * ($pageHeight - $marginTop - $marginBottom);

                    $rate = min($freeHeight / $imageHeightAsUnits, $freeWidth / $imageWidthAsUnits, 2);
                    $imageWidth = floor($rate * $imageWidthAsUnits);
                    $imageHeight = floor($rate * $imageHeightAsUnits);

                    $leftOffset = $this->GetX() + ($pageWidth - $marginLeft - $marginRight - $imageWidth) / 2;
                    $topOffset = $this->GetY();

                    $this->Image($imageFile, $leftOffset, $topOffset, $imageWidth, $imageHeight, "", "", "N", false, 300, "", false, false, 0, true);

                    if ($sugarChart->print_html_legend_pdf) {
                        $legend = $sugarChart->buildHTMLLegend($xmlFile);
                        $this->writeHTML($legend, true, false, false, true, "");
                    }
                }
            }
        }

        //Create new page
        $this->AddPage();

        $this->bean->run_summary_query();
        $item = array();
        $header_row = $this->bean->get_summary_header_row();
        $count = 0;

        if (count($this->bean->report_def['summary_columns']) == 0) {
            $item[$count]['']='';
            $count++;
        }
        if (count($this->bean->report_def['summary_columns']) > 0) {
            while ($row = $this->bean->get_summary_next_row()) {
                for ($i= 0; $i < sizeof($header_row); $i++) {
                    $label = $header_row[$i];
                    $value = '';
                    if (isset($row['cells'][$i])) {
                        $value = $row['cells'][$i];
                    }
                    $item[$count][$label] = $value;

                }
                $count++;
            }
        }

        $this->writeCellTable($item, $this->options);
        $this->Ln1();

        $this->bean->clear_results();

        if ($this->bean->has_summary_columns()) {
            $this->bean->run_total_query();
        }

        $total_header_row = $this->bean->get_total_header_row();
        $total_row = $this->bean->get_summary_total_row();
        $item = array();
        $count = 0;

        for ($j=0; $j < sizeof($total_header_row); $j++) {
            $label = $total_header_row[$j];
            $item[$count][$label] = $total_row['cells'][$j];
        }

        $this->writeCellTable($item, $this->options);

    }
}

0 Neeraja P over 5 years ago in reply to Gurpreet Singh

The file and location looks correct to me. This raises a couple of questions:

1. Did you do a quick repair before running the export?

2. The override was only for the PDF Summary, so did you actually export a summary report? If not, can you give details on what kind of report you're trying to export? If you are trying to export a rows/columns report or a matrix report, it comes from a different file. You will have to extend the corresponding file:

sugarpdf.detail_and_total.php
sugarpdf.listview.php
sugarpdf.reports.php
sugarpdf.summary.php
sugarpdf.summary_combo.php
sugarpdf.total.php

I have exactly the same file as you locally and I was able to see the difference in the summary report.

Before:

PDF

After:

PDF
0 Gurpreet Singh over 5 years ago in reply to Neeraja P

PDF
0 Gurpreet Singh over 5 years ago in reply to Neeraja P

Yes we did quick repair before running the export.
+1 Neeraja P over 5 years ago in reply to Gurpreet Singh

Ah okay, looks like you're export summation+details, so the file you have to override is sugarpdf.summary_combo.php . sugarpdf.summary.php is just plain Summation report.

You can see in the right top corner of the report, which mentions the "Report Type".

Here are the 4 report types and their corresponding PDF generation files:

Report Type PDF Template File

Rows & Columns sugarpdf.listview.php

Summation sugarpdf.summary.php

Summation with Details sugarpdf.summary_combo.php

Matrix sugarpdf.summary.php

^ Gurpreet Singh
0 Gurpreet Singh over 5 years ago in reply to Neeraja P

Neeraja P Thank you so much. It's Working for me.

Reply

0 Gurpreet Singh over 5 years ago in reply to Neeraja P

Neeraja P Thank you so much. It's Working for me.

Children

No Data

Report Type	PDF Template File
Rows & Columns	sugarpdf.listview.php
Summation	sugarpdf.summary.php
Summation with Details	sugarpdf.summary_combo.php
Matrix	sugarpdf.summary.php