Forum PHP.pl

Cytat(Mike0 @ 27.11.2012, 17:14:00 )

btw. Czy dobrze nazwałem IF(City.country_id=147, 1, 0) as ordinal jako pole dynamiczne?

[PHP] pobierz, plaintext 
array(
 'City' => array(
   // dane z city
 ),
 '0' => array(
    'ordinal' => 'costam'  // ordinal
  )
)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$this->City->virtualFields['ordinal'] = 'IF(City.country_id=147, 1, 0)';
// teraz paginate
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<table>
<tr>
<th>Pole</th><th>Pole</th><th>Pole</th>
<tr>
<tbody>
<tr>
<td>Wartosc</td><td>Wartosc</td><td>Wartosc</td>
</tr>
</tbody>
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
$headers = $this->Html->tableHeaders(array('Pole', 'Pole', 'Pole'));
$tbody = $this->Html->tableCells(array('wartosc', 'wartosc', 'wartosc'));
$tbody = $this->Html->tag('tbody', $tbody); 
$table = $header;
$table .= $tbody;
echo $this->Html->tag('table', $table);
[PHP] pobierz, plaintext 

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

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