Yii2.0 pagination issue second page not working -

-

how do pagination? have search form , search button passes in date range. first page working successfully, when click on second page, shows everything. how pass date range pagination?

edit: below reportsearch.php (model)

    $dataprovider = new activedataprovider([         'query' => $query,         'pagination' => [             'pagesize' => 5,             //'params' => array('search' => 'true', 'from_dt'=>$stockmovement_summary_from_sales_date, 'to_dt'=> $stockmovement_summary_to_sales_date),         ],     ]);      $dataprovider->setsort([         'defaultorder' => [             'd_item.desc_e_tx' => sort_asc,         ],         'attributes' => [             'd_item.desc_e_tx'         ]     ]);      return $dataprovider; }

below controller:

$searchmodel = new reportsearch();             $dataprovider = $searchmodel->searchstockmovementsummary($stockmovement_summary_from_sales_date, $stockmovement_summary_to_sales_date);             return $this->render('stockmovementreportsummary', [                         'search' => 'true',                         'dataprovider' => $dataprovider,                         'from_dt' => $stockmovement_summary_from_sales_date,                         'to_dt' => $stockmovement_summary_to_sales_date,                         'model' => $searchmodel,             ]);

below index.php

$reports = $dataprovider->getmodels();     $i=1;      echo "<table class='table table-striped table-bordered'>";     echo "<tr><th>#</th><th>item</th><th>total summary usage qty</th><th>current stock on hand</th><th>measurement</th></tr>";     foreach ($reports $report) {         $item_key = $report['report_item_key'];         $item_model = item::find()->where(['item_key' =>$item_key])->one();         $item_e_desc_tx = $item_model->desc_e_tx;         $item_c_desc_tx = $item_model->desc_c_tx;         $item_qty_no = $item_model->qty_no;         $item_measurement_tx = $item_model->measurement;         echo "<tr>";         echo "<td>" . $i++ . "</td>";         echo "<td>" . html::a($item_key, array('stockmovementreportdetailbyitem', 'item_key' => $item_key, 'search' => 'true', 'from_dt' => $from_dt, 'to_dt'=>$to_dt)) . "<br>" . $item_e_desc_tx . "<br>" . $item_c_desc_tx ."</td>";         echo "<td>" . $report['total_summary_usage_qty'] . "</td>";         echo "<td>" . $item_qty_no . "</td>";         echo "<td>" . $item_measurement_tx . "</td>";         echo "</tr>";     }     echo "</table>";     echo \yii\widgets\linkpager::widget([         'pagination'=>$dataprovider->pagination,          ]);

gridview should used not think help. chance use post instead of filter results? if take here https://github.com/yiisoft/yii2/blob/master/framework/data/pagination.php#l257 @ createurl function see uses getqueryparams http://www.yiiframework.com/doc-2.0/yii-web-request.html#getqueryparams() create query string. if use post function not pick params hence next page pagination fail.

ok, because use post have create own pagination function takes post consideration. or use get. not performing operations db can safely use get. better everybody.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

ios - Possible to get UIButton sizeThatFits to work? -

-
i have been using method of resizing uibuttons depreciated, , not robust. , other reasons, want sizethatfits work uibuttons. i've read online, i'm not sure if should work (seems working some, not others, difference maybe between style, i'm using custom). here simple test code recreate issue (i put in viewdidload test, shouldn't matter, , real code part of large project): uibutton *btn = [uibutton buttonwithtype:uibuttontypecustom]; [btn settitle:@"this test long title need word wrap more single line when displayed on tiny ipod in portrait view." forstate:uicontrolstatenormal]; btn.titlelabel.linebreakmode = uilinebreakmodewordwrap; // depreciated - nothing replace it? cgrect r = btn.frame; r.origin.x = 0; r.origin.y = 0; r.size.width = 320; r.size.height = [btn.titlelabel.text sizewithfont:btn.titlelabel.font constrainedtosize:cgsizemake(r.size.width,100000) linebreakmode:btn.titlelabel.linebreakmode].height; // returns approx 86 , changes correctly ...
Read more