StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14568126
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
2013-01-28T18:18:51.773
CreationDate
2013-01-28T17:54:49.763
FavoriteCount
0
LastActivityDate
2013-01-29T01:03:24.537
LastEditDate
2013-01-29T01:03:24.537
LastEditorUserId
1989862
OwnerUserId
1989862
ParentId
12292784
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>Code below - it's only example, main principles of solution. First principle: we don't need refresh page (by the submit), we need only refresh CGridView after request.</p> <h2>The solution has a few parts:</h2> <ol> <li><p>We need form with some parameters. In your case - <em>fromDate</em> and <em>toDate</em>. You have this one already. But we don't need any submit element. At all! We will use AJAX.</p></li> <li><p>We need some function for initiate AJAX-request. For example, let's event for this request will be <strong>change</strong> of parameters *from_date* or *to_date*. This function also must update CGridView after request. </p></li> <li><p>We need action in controller for processing AJAX-request.</p></li> </ol> <h2>Let's begin from part 2. It may be some like this:</h2> <blockquote> <pre><code>Yii::app()->clientScript->registerScript('scriptId', "var ajaxUpdateTimeout; var ajaxRequest; $('**selector_for_parameters_fields**').change(function(){ ajaxRequest = $(this).serialize(); clearTimeout(ajaxUpdateTimeout); ajaxUpdateTimeout = setTimeout(function () { $.fn.yiiGridView.update( // this is the id of the CGridView 'acc-payment-recei-grid', {data: ajaxRequest} ) }, // this is the delay 300); });" ); </code></pre> </blockquote> <p>Place this code into view. Notes:</p> <p><code>$(this).serialize()</code> - key moment. Look for <a href="http://api.jquery.com/serialize/" rel="nofollow">more info</a></p> <p><code>selector_for_parameters_fields</code> - give them ( <em>fromDate</em> and <em>toDate</em> ) some unique selector</p> <p>We use some <code>delay</code> (300 ms) for decreasing loading from unnecessary AJAX-requests</p> <h2>Now - about action in Controller</h2> <blockquote> <pre><code>public function actionIndex($fromDate='', $toDate='') { $criteria = new CDbCriteria(); if(!empty($fromDate)) $criteria->addSearchCondition('your search condition about fromDate'); if(!empty($toDate)) $criteria->addSearchCondition('your search condition about toDate'); $dataProvider=new CActiveDataProvider('YourModel', array('criteria' => $criteria,)); $this->render('YourView',array('dataProvider'=>$dataProvider,)); } </code></pre> </blockquote> <p>It must works, but requires some tuning for concrete conditions.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POyii : how to ajax update the cgridview
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAlexander Yakutskiy
UserOwnerUserId
1. USAlexander Yakutskiy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.