[eluser]Pramod[/eluser]
Hi,
I need Flexigrid with extra search parameter(search form outside the frame).
I have done for one case like this
Add search Criteria
Code:
$searchCriteria=array(
'validity_dt_from' => $this->general_model->dateInSecond($_POST['validity_dt_from'],'dd/mm/yyyy'),
'validity_dt_to' => $this->general_model->dateInSecond($_POST['validity_dt_to'],'dd/mm/yyyy'),
'exp_dt_from' => $this->general_model->dateInSecond($_POST['exp_dt_from'],'dd/mm/yyyy'),
'exp_dt_to' => $this->general_model->dateInSecond($_POST['exp_dt_to'],'dd/mm/yyyy'),
'p_distributor' => $_POST['p_distributor'],
'state' => $_POST['state'],
'alis_name' => $_POST['alis_name'],
'par_value_from' => $_POST['par_value_from'],
'par_value_to' => $_POST['par_value_to']
);
And pass to ajax file as
Code:
$grid_js = build_grid_js('flex1',site_url("Reports/mposAjax/getdataCTC"),$colModel,'REPORT_ID','asc',$gridParams,$buttons,$searchCriteria);
Then I modified in flexigrid.js in line ~585
Code:
if (p.page>p.pages) p.page = p.pages;
var param = {page:p.newp, rp: p.rp, sortname: p.sortname, sortorder: p.sortorder, query: p.query, qtype: p.qtype,state:p.state,validityDateFrom:p.validity_dt_from,validityDateTo:p.validity_dt_to,expDateFrom:p.exp_dt_from,expDateTo:p.exp_dt_to,destri:p.p_distributor,aliasName:p.alis_name,parValueFrom:p.par_value_from,parValueTo:p.par_value_to};
I also changed sql for advance serach criteria.
But problem is it works for only one form.
If i want this for many form how Can i do it.
I have paging problem in Oracle since oracle doesnot support LIMIT.
Can any one can help me.
Thanks in advance