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(); } }