Tul xxx Tul

Viewing: PaymentController.php

<?php

namespace App\Controllers;

use App\Controllers\BaseController;
use App\Models\CompanyModel;
use App\Models\PaymentModel;
use App\Models\UserModel;

class PaymentController extends BaseController
{
    protected $paymentModel, $userModel;

    public function __construct()
    {
        $this->paymentModel = new PaymentModel();
        $this->userModel = new UserModel();
    }

    public function index()
    {
        $companyModel = new CompanyModel();
        $data['company']= $companyModel->first();
        return view('cliente/payments', $data);
    }

    public function show()
    {
        $desde = $this->request->getGet('desde');
        $hasta = $this->request->getGet('hasta');

        // Construye la consulta con los filtros de fecha si están presentes
        $builder = $this->paymentModel->select('payments.*, memberships.user_id, membership_types.name AS membership_name')
            ->join('memberships', 'memberships.id = payments.membership_id')
            ->join('membership_types', 'membership_types.id = memberships.membership_type_id');

        if ($desde) {
            $builder->where('payments.payment_date >=', $desde);
        }

        if ($hasta) {
            $builder->where('payments.payment_date <=', $hasta);
        }

        // Ejecuta la consulta y obtiene los resultados
        $data = $builder->where('user_id', session('user_id'))->orderBy('payments.id', 'desc')->findAll();

        // Añade un índice "item" a los resultados
        $item = 1;
        foreach ($data as &$row) {
            $row['item'] = $item;
            $item++;
        }

        // Devuelve los datos en formato JSON
        return $this->response->setJSON($data);
    }

    public function generatePaymentTicket($id)
    {
        $companyModel = new CompanyModel();
        $data['company'] = $companyModel->first();

        $data['payment'] = $this->paymentModel->select('payments.*, memberships.user_id, membership_types.name AS membership_name')
            ->join('memberships', 'memberships.id = payments.membership_id')
            ->join('membership_types', 'membership_types.id = memberships.membership_type_id')
            ->find($id);

        $data['user'] = $this->userModel->find($data['payment']['user_id']);

        // Renderiza la vista del ticket a HTML
        $html = view('admin/payments/payment_ticket', $data);

        // Cargar dompdf
        $dompdf = new \Dompdf\Dompdf();
        $options = $dompdf->getOptions();
        $options->set('isJavascriptEnabled', true);
        $options->set('isRemoteEnabled', true);
        $dompdf->setOptions($options);
        $dompdf->loadHtml($html);

        // Renderiza el PDF
        $dompdf->setPaper(array(0, 0, 226.77, 500));
        $this->response->setHeader('Content-Type', 'application/pdf');
        // Enviar el PDF al navegador
        $dompdf->render();
        $dompdf->stream('payment_ticket.pdf', ['Attachment' => 0]);
    }
}
User / IP	: 216.73.217.33
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64