PDF Not working

Hi All,

Operating system : Linux Ubuntu 12.04 LTS
Database : MySQL 5.5.41
PHP version : 5.4
Web Server : Apache/2.2.22

i have install already install suitecrm which is working fine !

Now i have created a custom module called as Order which we are using in order management process . All the Order are created using API from Web shop .

So what i am trying to do here is i need a PDF Report based on User search . so what i did is i created a Custom button on basic search called as GetReport as show in screen shot below

my code for adding custom button in basic search is below
under suitecrm/custom/include/SearchForm/tpls/SearchFormGeneric.tpl

{if $module eq 'o_order'}
    <input title='Get Report' id='get_report' onclick ="SUGAR.ajaxUI.submitForm(this.form);" class='button' type='submit' name='button'  value='GetReport'/>

For generating PDF based on search i am using mpdf class and i have created a function here’s my code for that

Under suitecrmDemo/custom/modules/o_order/views/view.list.php

code :


class o_orderViewList extends ViewList
     * @see ViewList::preDisplay()
    public function preDisplay()

    public function display()

  	public function listViewProcess()        // genrating listview 
        $this->lv->searchColumns = $this->searchForm->searchColumns;
        if(empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false){
            $this->lv->setup($this->seed, 'include/ListView/ListViewGeneric.tpl', $this->where, $this->params);
            $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']);
            $configObject = new Configurator();
            $configObject->config['save_query'] = 'no';
            echo $this->lv->display();

    public function getpdf($cond)
           $d_image = explode('?',SugarThemeRegistry::current()->getImageURL('company_logo.png'));
           $head =  '<table style="width: 100%; font-family: Arial; text-align: center;" border="0" cellpadding="2" cellspacing="2">
                            <tbody style="text-align: left;">
                            <tr style="text-align: left;">
                            <td style="text-align: left;">
                            <p><img src="'.$d_image[0].'" style="float: left;"/>&nbsp;</p>
                            <tr style="text-align: left;">
                            <td style="text-align: left;"></td>
                             <tr style="text-align: left;">
                            <td style="text-align: left;">
                            <tr style="text-align: left;">
                            <td style="text-align: left;"></td>
                            <tr style="text-align: left;">
                            <td style="text-align: left;">
                            </table><br />';
            global $db;   
            $sql = "SELECT o_order.id , o_order.order_number , o_order.billing_address_country , o_order.total_cost , o_order.tracking_id , o_order.billing_address_city , o_order.order_status , o_order.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, o_order.date_entered , o_order.assigned_user_id FROM o_order LEFT JOIN users jt0 ON o_order.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0 where ($cond) AND o_order.deleted=0 ORDER BY o_order.date_entered DESC";  
            $res = $db->query($sql);
            $body_head = '<table cellpadding="0" cellspacing="0" width="100%" border="0" ><tbody><tr>
                    <td scope="col" width="12%" bgcolor="#35478F" color="#FFFFFF" > Order number </td>
                    <td scope="col" width="12%" bgcolor="#35478F" color="#FFFFFF" > Billing Country </td>
                    <td scope="col" width="12%" bgcolor="#35478F" color="#FFFFFF" > Order status </td>
                    <td scope="col" width="12%" bgcolor="#35478F" color="#FFFFFF" > Phone </td>
                    <td scope="col" width="19%" bgcolor="#35478F" color="#FFFFFF" > Tracking Id </td>
                    <td scope="col" width="2%"  bgcolor="#35478F" color="#FFFFFF" > Total Cost </td>
                    <td scope="col" width="2%"  bgcolor="#35478F" color="#FFFFFF" > Date Entered </td></tr>';
            $body_foot = '</tbody></table>';
             while($f_res = $db->fetchByAssoc($res)){
                    $out_put .= '<tr hight="20"><td scope="row" align="left" valign="top">'.$f_res['order_number'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['billing_address_country'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['order_status'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['phone_office'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['tracking_id'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['total_cost'].'</td>
                                 <td scope="row" align="left" valign="top">'.$f_res['date_entered'].'</td>                                 
            $table = $body_head.$out_put.$body_foot;
            $stylesheet = file_get_contents('themes/Suite7/css/style.css');
            $pdf=new mPDF('en','A4','','DejaVuSansCondensed');
            $pdf->WriteHTML('<p><h1>Order Report</h1></p>',2);
            $pdf->WriteHTML('<p><h1>            </h1></p>',2);            
            $pdf->Output('Order Report', "D");

so now when i click on GetReport button its creating a Pdf based on search criteria . as shown in screen shot

i am using chromium web browser .

Now when i click on it’s showing like this

but if i open the pdf from pdf reader then its working as shown

so my question is

1 ) what might be the problem is it the problem with browser ? or some thing else ?

2 ) or is there a way to attache this file directly with mail ? ( i know this question dose not belong to question title )

Thank you so much for your time !

Have you tried different browsers to see if it works? I would say the the issue is with the formatting of the pdf file some how. And yes it is possible to just email the file. http://developer.sugarcrm.com/2011/08/15/howto-send-and-archive-an-email-in-sugar-via-php There is a way to add attachments to the emails.

Hi Andy ,

Thank you for the reply !

yes i have tried with other browser ( Mozilla fire fox ) it’s working fine with that .

it gives error with chrome browser . and thank you for the link i will try that out !.

Thanks for your time

HI andy ,

Thanks for the suggestion it’s working fine now !

Thanks for your time and support