Implementing the Sugar's Default Pagination for Custom Html Page.

[KETANBHALERAO]

Hi ,

Its very urgent.
I am trying to implement the sugar's default pagination for my custom page.

Description :
I am generating reports by retrieving the data from sugar database.
and making a list of it for printing.
I want to implement the pagination for this page.
Is there is any way to override sugar's default Pagination(As in ListView) for my custom page.
Anyone please help me


I want to implement

[jmertic]

Why not just embed a ListView into your form? Check out this example in the product for some ideas:

https://github.com/sugarcrm/sugarcrm.../view.last.php

[KETANBHALERAO]

Hi jmetric,

Thanks for your reply.

I will have a look at the link and try for the solution

[KETANBHALERAO]

Hi jmetric,

Thanks for your reply yesterday.


Please help me
I am in big trouble.
Not getting how to embed the listview in any simple file.
Getting confuse as I was seeing view.last.php file

Can you please guide me how to embed the pagination (listview) for custom page

[jmertic]

Try this code segment for a guide

 <?php

require_once("include/ListView/ListViewFacade.php");

// Create the bean for the module you want a listview for
$mybean = new Account;

// build listview facade object
$lvf = new ListViewFacade($mybean, $mybean->module_dir, 0);

// handle sort order and pagination
$params = array();
if(!empty($_REQUEST['orderBy'])) {
    $params['orderBy'] = $_REQUEST['orderBy'];
    $params['overrideOrder'] = true;
    if(!empty($_REQUEST['sortOrder'])) $params['sortOrder'] = $_REQUEST['sortOrder'];
}

// Hide the various action buttons
$lvf->lv->mergeduplicates = false;
$lvf->lv->showMassupdateFields = false;
$lvf->lv->email = false;
$lvf->template = 'include/ListView/ListViewNoMassUpdate.tpl';

// Now build the ListView and display it
$lvf->setup(
    '', 
    '', 
    $params, 
    return_module_language($GLOBALS['current_language'], $mybean->module_dir), 
    0, 
    -1,
    '', 
    strtoupper(get_class($mybean)), 
    array(), 
    'id'
    );

echo $lvf->display($GLOBALS['app_list_strings']['moduleList'][$mybean->module_dir], 'main', TRUE);  

[KETANBHALERAO]

Hi John,

Thank you very much for your help.
It works.

[rakeshray]

Try this code segment for a guide

 <?php
 
require_once("include/ListView/ListViewFacade.php");
 
// Create the bean for the module you want a listview for
$mybean = new Account;
 
// build listview facade object
$lvf = new ListViewFacade($mybean, $mybean->module_dir, 0);
 
// handle sort order and pagination
$params = array();
if(!empty($_REQUEST['orderBy'])) {
    $params['orderBy'] = $_REQUEST['orderBy'];
    $params['overrideOrder'] = true;
    if(!empty($_REQUEST['sortOrder'])) $params['sortOrder'] = $_REQUEST['sortOrder'];
}
 
// Hide the various action buttons
$lvf->lv->mergeduplicates = false;
$lvf->lv->showMassupdateFields = false;
$lvf->lv->email = false;
$lvf->template = 'include/ListView/ListViewNoMassUpdate.tpl';
 
// Now build the ListView and display it
$lvf->setup(
    '', 
    '', 
    $params, 
    return_module_language($GLOBALS['current_language'], $mybean->module_dir), 
    0, 
    -1,
    '', 
    strtoupper(get_class($mybean)), 
    array(), 
    'id'
    );
 
echo $lvf->display($GLOBALS['app_list_strings']['moduleList'][$mybean->module_dir], 'main', TRUE);  

Hi,

I want to filter this custom list view .
I am putting following code
$params['where'] = " AND status=8";

But this is not effective,nothing is happening.

How to filter it , Please give me some idea
Thanks !
Rakesh

[jmertic]

Change the setup() call in the code to this...

 $lvf->setup(
    '', 
    ' AND status=8', 
    $params, 
    return_module_language($GLOBALS['current_language'], $mybean->module_dir), 
    0, 
    -1,
    '', 
    strtoupper(get_class($mybean)), 
    array(), 
    'id'
    ); 
  

[hoangbao]

Hi John,
please help me,

I want to display listview below editview. How can I do?

Thanks,
hoangbao