change format date on cakephp

$tgllahir = $this->request->data['Wisuda']['tgllahir'];
             
$tgl=$tgllahir['year'].'-'.$tgllahir['month'].'-'.$tgllahir['day'];

query join cakephp custom with pagination no model

$this->paginate = array('joins' => array(
                    array('table' => 'users', 'alias' => 'User', 'type' => 'INNER', 'conditions' => array(
                            'Tracer.nimhsmsmh=User.username'))),
                'conditions' => array('User.tracer_tahun' => $event, 'User.jurusan' => $jur, 'OR' => array('Tracer.nimhsmsmh like ' => "%$cari%", 'User.nama like' => "%$cari%", 'User.jurusan like' => "%$cari%", 'Tracer.saran like' => "%$cari%", 'Tracer.masukan like' => "%$cari%")), 'fields' => array('Tracer.*', 'User.*'),
                'limit' => $cfilter, 'order' => 'Tracer.id asc');
            $tracers = $this->paginate('Tracer');
            $this->set(compact('tracers', 'cari', 'cfilter', 'tahun', 'sms', 'jur'));

datetime PHP or Cakephp

2017-04-18 12:59:32


$tg=date("Y-m-d H:i:s");

Query and dan Or Cakephp beserta Pagination

caranya dibawah ini

$this->paginate = array('conditions' => array('Nilaifeeder.smt' => $tahun, 'Nilaifeeder.jenis' => 'khs', 'Nilaifeeder.ID_KLS' => $username,'OR'=>array('Nilaifeeder.NM_PD like'=>"%$cari%",'Nilaifeeder.nim like'=>"%$cari%")), 'limit' => $cfilter, 'order' => array('Nilaifeeder.id' => 'asc'));
 $nilais = $this->paginate('Nilaifeeder');

Memanggil Prosedur Mysql di Cakephp

$khs=$this->Feeder->query(" CALL khs('$username','$tahun','$sms')");

membuat pdf pada Cakephp dengan FPDF

cara membuat pdf di cakephp dowload dulu fpdfnya disini
langkahnya :
1.taruh library fpdf di app/vendor
2.buat layout baru yaitu pdf.ctp dan isikan kode berikut

<?php
    header('Content-Disposition: attachment; filename="downloaded.pdf"');
    echo $content_for_layout;

 ?>

3.buat function di controller pdf() seperti dibawah ini

public function pdf(){
            App::import('Vendor', 'Fpdf', array('file' => 'fpdf/fpdf.php'));
            $this->layout = 'pdf'; //this will use the pdf.ctp layout
            $this->set('fpdf', new FPDF('P', 'mm', 'A4'));
            $data=$this->Post->find('first', array('conditions' => array('Post.id' => '14')));
            $this->set(compact('data'));
            $this->render('pdf');
    }

4.buat view sesuai controllernya pdf.ctp

<?php
$judul = "Halo apa kabar";
        $header = array(
            array("label" => "NIM", "length" => 30, "align" => "L"),
array("label" => "NAMA", "length" => 30, "align" => "L"),
            array("label" => "ALAMAT", "length" => 30, "align" => "L"),
            array("label" => "ALAMAT", "length" => 30, "align" => "L"),
            array("label" => "ALAMAT", "length" => 30, "align" => "L"),
            array("label" => "TGL LAHIR", "length" => 30, "align" => "L")
        );
$pdf = new FPDF();
        $fpdf->AddPage();
        #tampilkan judul
        $fpdf->SetFont('Arial', 'B', 16);
        $fpdf->Cell(10, 10, $judul);
        #buat header tabel
        $fpdf->SetFont('Arial', '', '10');
        $fpdf->SetFillColor(255, 0, 0);
        $fpdf->SetTextColor(255);
        $fpdf->SetDrawColor(128, 0, 0);
        foreach ($header as $kolom) {
//            debug($kolom);exit;
            $fpdf->Cell($kolom['length'], 5, $kolom['label'], 1, '0', $kolom['align'], true);
        }
        $fpdf->Ln();
        #tampilkan data tabelnya
        $fpdf->SetFillColor(224, 235, 255);
        $fpdf->SetTextColor(0);
        $fpdf->SetFont('');
        $fill = false;
        foreach ($data as $baris) {
            $i = 0;
            foreach ($baris as $cell) {
//                debug($header);exit;
//                $fpdf->Cell($header[$i]['length'], 5, $cell, 1, '0', $kolom['align'], $fill);
                $fpdf->Cell(30, 5, $cell, 1, '0', $kolom['align'], $fill);
                $i++;
            }
            $fill = !$fill;
            $fpdf->Ln();
        }
        
        
        $fpdf->Output();
        ?>

Cakephp set date time default

cara untuk mensetting tanggal dan waktu default di cakephp adalah sebagai berikut
1. masuk app config core.php
2. search timezone
3. tamahkan kode berikut pada core.php
        date_default_timezone_set('Asia/Jakarta');

// Configure::write('Config.timezone', 'Asia/Jakarta');
        date_default_timezone_set('Asia/Jakarta');

Membuat Kondisi + Limit

$this->Tiket->recursive = 0;
$this->paginate = array('limit' => 1000);
$penontons = $this->Paginate('Tiket',array('Tiket.status' => 'lunas'));
$this->set(compact('penontons'));