EVOLUTION-NINJA

Edit File: CommissionNotificationModel.php

<?php
namespace App\Models;

use CodeIgniter\Model;

class CommissionNotificationModel extends Model
{
    protected $table = 'gss_commission_notifications';
    protected $primaryKey = 'notification_id';
    protected $allowedFields = [
        'booking_id',
        'detail_id',
        'commission_agreement',
        'commission_registration',
        'status',
        'delete_status',
        'created_at',
        'updated_at'
    ];

public function commission_notifications()
    {
        return $this->select('
            A.*, B.*, C.*, D.*, 
            A.delete_status as ad_s, B.delete_status as b_ds, 
            C.delete_status as cd_s, D.delete_status as dd_s, 
            E.delete_status as ed_s, E.registration_date, E.agreement_date, 
            B.associate, F.associate_name, A.status as statuss
        ')
        ->from('gss_commission_notifications A')
        ->join('gss_bookings B', 'B.booking_id = A.booking_id')
        ->join('gss_new_projects C', 'C.project_id = B.project_id')
        ->join('gss_booking_details D', 'D.detail_id = A.detail_id')
        ->join('gss_plot_payments E', 'E.booking_id = A.booking_id')
        ->join('gss_brokers F', 'F.broker_id = B.associate')
        ->where('A.delete_status', 'ACTIVE')
        ->where('B.delete_status', 'ACTIVE')
        ->where('C.delete_status', 'ACTIVE')
        ->where('D.delete_status', 'ACTIVE')
        ->where('E.delete_status', 'ACTIVE')
        ->where('F.delete_status', 'ACTIVE')
        ->where('A.status', 'PENDING')
        ->where('A.commission_agreement', 'Available')
        ->orWhere('A.commission_registration', 'Available')
        ->where('B.booking_status', 'BOOKED')
        ->groupBy('E.booking_id')
        ->orderBy('A.notification_id', 'DESC')
        ->findAll();
    }

}