<?php

namespace App\Models;

use CodeIgniter\Model;

class ProductEnquiryModel extends Model
{
    protected $table = 'tbl_product_enquiry';
    protected $primaryKey = 'ID';

    protected $allowedFields = [
        'productID',
        'name',
        'mobile',
        'email',
        'message',
        'address',
        'created_at'
    ];

    protected $useTimestamps = false;
    public function getEnquiriesWithProduct()
    {
        return $this->select('
                tbl_product_enquiry.*,
                tbl_product.productName,
                tbl_product.productSize,
                tbl_product.productThicknes,
                tbl_product.productGrade
            ')
            ->join('tbl_product', 'tbl_product.id = tbl_product_enquiry.productID', 'left')
            ->orderBy('tbl_product_enquiry.ID', 'DESC')
            ->findAll();
    }

    public function totalCount(){
        return $this->countAll();
    }



}