[Cake]Wyszukiwanie danych z zakresu dat, jQuery Datepicker - date range Opcje

[QeX]

Witam,

Jest w tabeli pewna liczba dokumentów zawierających w treści daty. Aktualnie realizowane jest wyszukiwanie po konkretnej dacie (pole contdate).

Kod kontrolera:

[PHP] pobierz, plaintext 
if(isset($this->request->data['Doc']['contdate']) && trim($this->request->data['Doc']['contdate']) != ''){
$conditions[] = array('DATE(Doc.contdate) ' => $this->request->data['Doc']['contdate']);
$this->set('docs', $this->Doc->find('all', array('conditions' => $conditions)));
}
[PHP] pobierz, plaintext 

Kod widoku:

[PHP] pobierz, plaintext 
echo $this->Form->create('Doc', array('inputDefaults' => array('label' => false,'div' => false)));
echo $this->Form->input('contdate', array('type' => 'text', 'label' => 'Wpisz datę:<br>'));
[PHP] pobierz, plaintext 

Chciałbym zrealizować wyszukiwanie dokumentów z określonego zakresu dat, przy pomocy jQuery Datepicker. Jak "spiąć" Datepickera z zawartością tabeli docs?

Kod Datepickera z formularzem:

CODE

$("#from").datepicker({
maxDate: 0,
onSelect: function( selectedDate ) {
$("#to").datepicker( "option", "minDate", selectedDate );
}
});
$("#to").datepicker({
maxDate: 0,
onSelect: function( selectedDate ) {
$("#from").datepicker( "option", "maxDate", selectedDate );
}
});

<label for="from">From</label>
<input type="text" id="from" name="from"/>
<label for="to">to</label>
<input type="text" id="to" name="to"/>

[kleus]

Pytasz jak wyslac dane do controller przez helper Js czy jak obslugiwac dane w controller?

Wysylanie do controller

[PHP] pobierz, plaintext 
$this->Js->get('#element')->event('change',
	$this->Js->request->array(
		array(
			'controller' => 'controller_name',
			'action' => 'action_name',
			'admin' => true // or false //
		),
		array(
			'update' => '#content',
    			'evalScripts' => true,
    			'before' => $this->Js->get('#busy-indicator')->effect('fadeIn', array('buffer' => false)),
    			'complete' => $this->Js->get('#busy-indicator')->effect('fadeOut', array('buffer' => false)),
		),
	)
);
[PHP] pobierz, plaintext 

reszte doczytaj w BOOK

pozdrawiam!

[QeX]

Chodzi mi o to jak obsłużyć ten konkretny przypadek. W BOOK nie ma nic na ten temat.

[kleus]

czyli nie wiesz jak w controller to zrobic czyli musisz patrzyc na retriving your data w sekcji models
http://book.cakephp.org/2.0/en/models/retr...-your-data.html
a dokładnie jest taki przyklad podany:

[PHP] pobierz, plaintext 
array('Post.read_count BETWEEN ? AND ?' => array(1,10))
[PHP] pobierz, plaintext 

czyli robisz

[PHP] pobierz, plaintext 
$this->ModelName->find('all', array(
   'conditions' => array(
      'ModelName.created BETWEEN ? AND ?' => array($dateFrom, $dateTo)
   )
));
[PHP] pobierz, plaintext 

[QeX]

Dzięki za pomoc.

Nadal jednak chyba nie ma przepływu danych z pól formularza #from i #to (Datepicker) do kontrolera, bo zakres dat wogóle nie jest brany pod uwagę przy wyszukiwaniu.

[kleus]

ja mam tak u siebie zrobione
PostsController

[PHP] pobierz, plaintext 
public function admin_index(){
		$this->paginate = array(
			'order' => 'Post.published DESC',
			'limit' => '10',
			'conditions' => array(
 
			)
		);
		if($this->RequestHandler->isAjax()){
			$this->paginate['conditions'] = Set::merge(
				$this->paginate['conditions'],
				array(
					'Post.modified BETWEEN ? AND ?' => array($this->request->data['Post']['from'], $this->request->data['Post']['to'])
				)
			);
		}
		$Posts = $this->paginate('Post');
		$this->set(compact('Posts'));
		if($this->RequestHandler->isAjax()){
			$this->render('ajax/admin_indexUpdate');
		}
	}
[PHP] pobierz, plaintext 

admin_index.ctp

[PHP] pobierz, plaintext 
<?php
	$url = array(
		'plugin' => false,
		'controller' => 'posts',
		'admin' => true,
		'prefix' => 'admin'
	);
 
	$this->Html->addCrumb('Blog', array(
		'plugin'	=> false,
		'controller' => 'posts',
		'action' => 'index',
		'admin' => true,
		'prefix' => 'admin'
	));
?>
<section class="row">
<?php
	echo $this->Form->create(null, array('id' => 'dateUpdate'));
	echo $this->Form->input('from', array(
			'class' => 'input-append date',
			'id' => 'dp',
			'value' => date('Y-m-d')
	));
	echo $this->Form->input('to', array(
			'class' => 'input-append date',
			'id' => 'dp2',
			'value' => date('Y-m-d')
	));
	echo $this->Form->end();
$data = $this->Js->get('#dateUpdate')->serializeForm(array(
				'isForm' => true,
				'inline' => true
			));
$this->Js->get('#dateUpdate')->event('change',
	$this->Js->request(
		Router::url(array(
			'controller' => 'posts',
			'action' => 'index',
			'admin' => true // or false //
		)),
		array(
			'update' => '#update',
    		'async' => true,
         'dataExpression'=>true,
         'method' => 'POST',
    		'data' => $data
		)
));
echo $this->Html->scriptBlock("
	$('#dp').datepicker({dateFormat: 'yy-mm-dd'});
	$('#dp2').datepicker({dateFormat: 'yy-mm-dd'});
");
?>
	<section class="span8" id="update">
		<?php echo $this->element('BootstrapPagination', array('update' => 'update')); ?>
		<table class="table table-bordered">
		<?php echo $this->Html->tableHeaders(array(
			$this->Paginator->sort('id'),
			$this->Paginator->sort('status'),
			$this->Paginator->sort('modified'),
			$this->Paginator->sort('title'),
			$this->Paginator->sort('author'),
			'Actions'
		)); ?>
		<?php foreach($Posts as $k => $Post): ?>
			<?php
				switch($Post['Post']['status']){
					case '0':
						$Post = array_merge($Post, array('status' => 'Unpublished'));
						break;
					case '1':
						$Post = array_merge($Post, array('status' => 'Published'));
				}
			?>
			<?php echo $this->Html->tableCells(array(
				h($Post['Post']['id']),
				h($Post['status']),
				h(
					$this->Time->format('Y-m-d H:i:s', $Post['Post']['modified'], false, $_SESSION['timezone'])	
				),
				h($Post['Post']['title']),
				h($Post['User']['name']),
				$this->Html->Link('',
					array_merge($url, array('action' => 'delete', $Post['Post']['id'])),
					array('class' => 'icon-trash'),
					 __('Are you sure?'), false
				),
				$this->Html->Link('',
					array_merge($url, array('action' => 'view', $Post['Post']['id'])),
					array('class' => 'icon-eye-open')
				),
				$this->Html->Link('',
					array_merge($url, array('action' => 'edit', $Post['Post']['id'])),
					array('class' => 'icon-edit')
				)
			)); ?>
		<?php endforeach; ?>
		</table>
		<?php echo $this->element('BootstrapPagination'); ?>
	</section>
	<aisde class="span3 offset1">
		<ul class="nav nav-list">
			<li class="nav-header actions">
				Blog Actions
			</li>
			<li class="divider"></li>
			<li><?php echo $this->Html->link(__('List Posts'), array_merge(
				$url, array('action' => 'index')
			)); ?></li>
			<li><?php echo $this->Html->link(__('New Post'), array_merge(
				$url, array('action' => 'add')
			)); ?></li>
		</ul>
	</aside>
</section>
[PHP] pobierz, plaintext 

i śmiga