[eluser]Jilani Jidni[/eluser]
Hi
I wanna add multiple datagrid into same view page. I have done this but the column order by is not working. please view my code
Controller
Code:
$this->load->model('Merchant_model', 'Merchant_model', TRUE);
$data['packageList'] = $this->Merchant_model->getMerchantPackages($merchant_row_id);
$data['paymentHistory'] = $this->Merchant_model->getPaymentHistory($merchant_row_id);
$this->load->view('administration/merchantDetails', $data);
Model
Code:
function getMerchantPackages($merchant_row_id)
{
$sql = 'SELECT
pack.package_id, pack.package_name, m.subscription_type,m.subscription_date,m.completion_date,m.active_status
FROM tbl_merchant_package_history m, tbl_package pack
WHERE m.merchant_row_id = '.$merchant_row_id.' and pack.package_id = m.package_id';
$sql = '(' . $sql . ' ) AS abc';
$getInstance = & get_instance ();
$getInstance->load->library ( 'rapyd' );
$this->rapyd->load ( 'datagrid' );
$grid = new DataGrid ( '', $sql );
$grid->order_by ( 'subscription_date', 'DESC' );
$grid->per_page = 10;
$grid->column_orderby ( 'Package', 'package_name', 'package_name', 'align=\'center\'' );
$grid->column ( 'Subscription Type', 'subscription_type', 'subscription_type', 'align=\'center\'' );
$grid->column_orderby ( 'Subscription Date', 'subscription_date', 'subscription_date', 'align=\'center\'' );
$grid->column ( 'Package completion date', 'completion_date', 'completion_date', 'align=\'center\'' );
$grid->column ( 'Active Status', 'active_status', 'active_status', 'align=\'center\'' );
$grid->build ();
return $grid->output;
}
function getPaymentHistory($merchant_row_id)
{
$sql = '(SELECT ack, payment_id,error_text,date_of_transaction
FROM tbl_payment_details
WHERE pd.merchant_row_id =' . $merchant_row_id .')as abc';
$getInstance = & get_instance();
$getInstance->load->library('rapyd');
$this->rapyd->load('datagrid');
$grid = new DataGrid('', $sql);
$grid->per_page = 10;
$grid->order_by ( 'payment_id', 'DESC' );
$grid->column_orderby ('Charge Date', 'date_of_transaction', 'date_of_transaction', 'align=\'center\'');
$grid->column ('Payment Status', 'ack', 'align=\'center\'');
$grid->column ('Error', 'error_text', 'align=\'center\'');
$grid->build();
return $grid->output;
}
View
Code:
<tr><td>Package List</td></tr>
<tr><td>
<?=$packageList?>
</td></tr>
<tr><td>Payment History</td></tr>
<tr><td>
<?=$paymentHistory?>
</td></tr>
when I am clicked on order by link then its shows a database error. This error occurred because every time it called the same controller function.
please help me on this issue.