Custom Subpanel Pagination Issue in Suitecrm Version 7.10.22

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi All,

I am trying to add Custom Subpanel in my Custom Module. But there is an Pagination issue in Custom Subpanel.
When Page is Load all data shows perfectly in Custom Subpanel with pagination, when click on Next button then Custom Subpanel Shows no result. When reload the page again then the result for Next page shows and so on.

$layout_defs['ftc_round'] = array(
    'subpanel_setup' => array(
        'round_inquiries' => array(
            'order' => 49,
            'module' => 'ftc_inquiries',
            'subpanel_name' => 'ForRound',
            'get_subpanel_data' => 'function:get_round_inquiry',
            'generate_select' => true,
            'title_key' => 'Inquiries',
            'top_buttons' => array(),
            'function_parameters' => array(
                'import_function_file' => 'modules/ftc_round/roundSubpanel.php',
                'round_id' => $this->_focus->id,
                'contact_id' => $this->_focus->contact_id,
                'return_as_array' => 'true'
                ),
        ),   
    ),
);

function get_round_inquiry($params) {

    $args = func_get_args();

    $GLOBALS['log']->fatal("Inquiry subpanel Round");
    $GLOBALS['log']->fatal(print_r($args,true));
    $roundId = $args[0]['round_id'];
    $contactId = $args[0]['contact_id'];

    $return_array['select'] = " SELECT *";
    $return_array['from'] = " FROM ftc_inquiries ";
    $return_array['where'] = " WHERE ftc_round_details.contact_id = '".$contactId."' AND ftc_round_details.round_id = '".$roundId."' AND ftc_round_details.inquiry_id != '' AND ftc_round_details.deleted = '0'";
    $return_array['join'] = "  INNER JOIN ftc_round_details on ftc_inquiries.id  = ftc_round_details.inquiry_id";
    $return_array['join_tables'] = '';
    return $return_array;
}