Dicas - RibaFS Portal

Customizando a Paginação

2017-06-25T20:11:23-03:00

Customizando a Paginação

Alterando a Paginação para 15 registros por página

public $paginate = [
'limit' => 15,
'order' => ['Clientes.id' => 'asc']
];

Código Padrão

2017-06-25T20:11:23-03:00

Código padrão de aplicativo do CakePHP 3

Controller

<?php
class ArticlesController extends AppController
{

    public function initialize()
    {
        parent::initialize();
        // Requerido
        $this->loadComponent('Flash'); // Include the FlashComponent
    }

    public function index()
    {
        $articles = $this->Articles->find('all');
        $this->set(compact('articles'));
    }

    public function view($id = null)
    {
        $article = $this->Articles->get($id);
        $this->set(compact('article'));
    }

    public function add()
    {
        $article = $this->Articles->newEntity();
        if ($this->request->is('post')) {
            $article = $this->Articles->patchEntity($article, $this->request->data);
            if ($this->Articles->save($article)) {
                $this->Flash->success(__('Your article has been saved.'));
                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('Unable to add your article.'));
        }
        $this->set('article', $article);
    }

    public function edit($id = null)
    {
        $article = $this->Articles->get($id);
        if ($this->request->is(['post', 'put'])) {
            $this->Articles->patchEntity($article, $this->request->data);
            if ($this->Articles->save($article)) {
                $this->Flash->success(__('Your article has been updated.'));
                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('Unable to update your article.'));
        }

        $this->set('article', $article);
    }

    public function delete($id)
    {
        $this->request->allowMethod(['post', 'delete']);

        $article = $this->Articles->get($id);
        if ($this->Articles->delete($article)) {
            $this->Flash->success(__('The article with id: {0} has been deleted.', h($id)));
            return $this->redirect(['action' => 'index']);
        }
    }
}

Template/view index.ctp

<!-- File: src/Template/Articles/index.ctp  (edit links added) -->

<h1>Blog articles</h1>
<p><?= $this->Html->link("Add Article", ['action' => 'add']) ?></p>
<table>

    <tr>

        <th>Id</th>

        <th>Title</th>

        <th>Created</th>

        <th>Action</th>

    </tr>



<!-- Here's where we iterate through our $articles query object, printing out article info -->



<?php foreach ($articles as $article): ?>

    <tr>

        <td><?= $article->id ?></td>

        <td>

            <?= $this->Html->link($article->title, ['action' => 'view', $article->id]) ?>

        </td>

        <td>

            <?= $article->created->format(DATE_RFC850) ?>

        </td>

        <td>

            <?= $this->Html->link('Edit', ['action' => 'edit', $article->id]) ?>

        </td>

        <td>

            <?= $this->Form->postLink(

                'Delete',

                ['action' => 'delete', $article->id],

                ['confirm' => 'Are you sure?'])

            ?>

            <?= $this->Html->link('Edit', ['action' => 'edit', $article->id]) ?>

        </td>

    </tr>

<?php endforeach; ?>



</table>



<!-- File: src/Template/Articles/view.ctp -->



<h1><?= h($article->title) ?></h1>

<p><?= h($article->body) ?></p>

<p><small>Created: <?= $article->created->format(DATE_RFC850) ?></small></p>



<!-- File: src/Template/Articles/add.ctp -->



<h1>Add Article</h1>

<?php

    echo $this->Form->create($article);

    echo $this->Form->input('title');

    echo $this->Form->input('body', ['rows' => '3']);

    echo $this->Form->button(__('Save Article'));

    echo $this->Form->end();

?>



<!-- File: src/Template/Articles/edit.ctp -->



<h1>Edit Article</h1>

<?php

    echo $this->Form->create($article);

    echo $this->Form->input('title');

    echo $this->Form->input('body', ['rows' => '3']);

    echo $this->Form->button(__('Save Article'));

    echo $this->Form->end();

?>

    <?= $this->Form->create($articles, [

          'url'   => [

               'controller' => 'Articles','action' => 'busca'

           ],

          'id'    => 'web-form',

          'class' =>'panel-body wrapper-lg'

       ]

    ) 

?>

Dicas Diversas

2017-06-25T20:11:23-03:00

Dicas diversas do CakePHP3

Capturar nome do action atual:
$this->request->action

Capturar nome do controller:
$this->request->controller

Usando o MessageHelper para exibir:
<?=$this->Message->msg($this->request->controller) ?>

Criando link com o HtmlHelper:
<?= $this->Html->link(__('Lista de Usuário'), ['action' => 'index']) ?>

Criando formulário com o FormHelper
<?= $this->Form->create($user) ?>
<legend><?= __('Editar Usuário') ?></legend>
<?php
echo $this->Form->input('username');
echo $this->Form->input('password');
echo $this->Form->input('role', ['admin'=>'Administrador','user'=>'Usuário']);
?>
<?= $this->Form->button(__('Submit')) ?>
<?= $this->Form->end() ?>

Campo input simular select em FormHelper e mudando o label:

echo $this->Form->label('Tipo'); // Criando o Label
echo $this->Form->select('role', ['user'=>'Usuário','admin'=>'Administrador'], ['default' => 'admin']);

Acesso a Bancos de Dados

2017-06-25T20:11:23-03:00

Acesso a Bancos de Dados no CakePHP 3

use Cake\Datasource\ConnectionManager;

Conexão
$connection = ConnectionManager::get('default');

Select
$results = $connection->execute('SELECT * FROM articles')->fetchAll('assoc');

ou
$results = $connection->execute('SELECT * FROM articles WHERE id = :id', ['id' => 1])->fetchAll('assoc');

Insert
use Cake\Datasource\ConnectionManager;

$connection = ConnectionManager::get('default');
$connection->insert('articles', [
'title' => 'A New Article',
'created' => new DateTime('now')
], ['created' => 'datetime']);

Update
use Cake\Datasource\ConnectionManager;
$connection = ConnectionManager::get('default');
$connection->update('articles', ['title' => 'New title'], ['id' => 10]);

Delete
use Cake\Datasource\ConnectionManager;
$connection = ConnectionManager::get('default');
$connection->delete('articles', ['id' => 10]);

$stmt = $conn->query('UPDATE posts SET published = 1 WHERE id = 2');

The query() method does not allow for additional parameters. If you need additional parameters you should use the execute() method, which allows for placeholders to be used:

$stmt = $conn->execute(
'UPDATE posts SET published = ? WHERE id = ?',
[1, 2]
);

$stmt = $conn->execute(
'UPDATE posts SET published_date = ? WHERE id = ?',
[new DateTime('now'), 2],
['date', 'integer']
);

$stmt->execute();

Ler um registro
$row = $stmt->fetch('assoc');

Ler todos os registros
$rows = $stmt->fetchAll('assoc');

Ler registros interagindo
foreach ($rows as $row) {
// Do work
}

$rowCount = count($stmt);
$rowCount = $stmt->rowCount();

Insert
$query = $articles->query();
$query->insert(['title', 'body'])
->values([
'title' => 'First post',
'body' => 'Some body text'
])
->execute();

$select = $articles->find()
->select(['title', 'body', 'published'])
->where(['id' => 3]);

$query = $articles->query()
->insert(['title', 'body', 'published'])
->values($select)
->execute()

Update
$query = $articles->query();
$query->update()
->set(['published' => true])
->where(['id' => $id])
->execute();

Delete
$query = $articles->query();
$query->delete()
->where(['id' => $id])
->execute();

Outras
$matchingComment = $articles->association('Comments')->find()
->select(['article_id'])
->distinct()
->where(['comment LIKE' => '%CakePHP%']);

$query = $articles->find()
->where(['id' => $matchingComment]);

Layout no CakePHP 3

2017-06-25T20:11:23-03:00

Layouts no CakePHP 3

Os layouts são camadas de software que organizam o espaço nas páginas.
Definem o que fica no cabeçalho, menus, conteúdo, rodapé, etc.
O que fica na região de conteúdo.
Na região de cabeçalho.

<!DOCTYPE html>
<html lang="en">
<head>
<title><?= h($this->fetch('title')) ?></title>
<link rel="shortcut icon" href="http://backup/portal/favicon.ico" type="image/x-icon">

<?php
echo $this->fetch('meta');
echo $this->fetch('css');
echo $this->fetch('script');
?>
</head>
<body>


<div id="header">
<div id="menu">...</div>
</div>


<?= $this->fetch('content') ?>


<div id="footer">...</div>

</body>
</html>

Podemos definir vários layouts para nosso aplicativo.

Os layouts devem ficar no diretório
src/Template/Layout

O CakePHP já vem com um layout default.ctp.

Atribuindo título para o aplicativo e definindo um layout no AppController:

class UsersController extends AppController
{
public function view_active()
{
$this->set('title', 'View Active Users');
$this->viewBuilder()->layout('default_small_ad');
}

public function view_image()
{
$this->viewBuilder()->layout('image');
}
}