EVOLUTION-NINJA

Edit File: GssNewProjectsModel.php

<?php

namespace App\Models;

use CodeIgniter\Model;

class GssNewProjectsModel extends Model
{
    protected $table = 'gss_new_projects';
    protected $primaryKey = 'project_id';
    protected $useAutoIncrement = true;
    protected $returnType = 'array';
    protected $allowedFields = [
        'project_name', 'nick_name', 'land_owner_id', 'land_owner_address', 'marketing',
        'project_status', 'site_type', 'nine_and_eleven_image', 'conversion_image',
        'release_image', 'approval_image', 'handled_by', 'booking_status',
        'project_ownership', 'no_of_years', 'maintenance_per_sqft', 'delete_status',
        'created_at', 'updated_at', 'mobile_status'
    ];

protected $useTimestamps = true;
    protected $createdField  = 'created_at';
    protected $updatedField  = 'updated_at';

protected $validationRules = [
        'project_name' => 'required|max_length[100]',
        'nick_name' => 'required|max_length[250]',
        'land_owner_id' => 'required|integer',
        'marketing' => 'required|max_length[50]',
        'project_status' => 'required|in_list[ONGOING,COMPLETED]',
        'site_type' => 'required|max_length[50]',
        'booking_status' => 'required|in_list[NOT BOOKED,BOOKED]',
        'delete_status' => 'required|in_list[ACTIVE,INACTIVE]',
        'mobile_status' => 'required|in_list[NOT_SELECTED,SELECTED]'
    ];

public function get_where_result_alphabetical($table, $where, $orderBy)
    {
        return $this->db->table($table)
                        ->where($where)
                        ->orderBy($orderBy, 'ASC')
                        ->get()
                        ->getResult();
    }
    public function get_where_result($table, $where)
    {
        return $this->db->table($table)
                        ->where($where)
                        ->get()
                        ->getResult();
    }
    
    public function get_where_result_orderby_asc($table, $where, $order_by)
    {
        return $this->db->table($table)
                        ->where($where)
                        ->orderBy($order_by, 'ASC')
                        ->get()
                        ->getResult();
    }

}