EVOLUTION-NINJA

Edit File: report_analysis.php

<?php 
namespace App\Controllers\admin;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
use App\Models\RegisterUserModel;
use App\Models\OrganisationModel;
use App\Models\conference_AttendUserModel;
use App\Models\Conf_About;
use App\Models\Conf_paymentModel;

class report_analysis extends BaseController{

use ResponseTrait;
    public function __construct()
    {
        helper(['form']);
        // helper(['url']);
    }

public function index(){

$org_id = session()->get('org_id');

$conference_id = $_GET['id'];
        $data['conf_id'] = $conference_id;

$e_library=['z,x,y'];
        $data['conferencelist'] = $e_library;

$model = new OrganisationModel();
        $details  = $model->get()->getResultArray();
        $data['org'] = $details;

return view('admin/report_demography',$data);

}

public function demography_data(){

$db = \Config\Database::connect();
            $builder = $db->table('cnb_postop');
            $query = $builder->select("cnb_patient_details.weight_kg, cnb_patient_details.dr_id,cnb_patient_details.age");
            $builder->join('cnb_patient_details', 'cnb_patient_details.id = cnb_postop.patient_id');
            $query = $builder->join("cnb_preop", "cnb_preop.patient_id = cnb_postop.patient_id");
            //$query = $builder->where('cnb_postop.procedure_date >=', date('Y-m-d', strtotime($from_date)));
            //$query = $builder->where('cnb_postop.procedure_date <=', date('Y-m-d', strtotime($to_date))); 
            $query = $builder->get();
            $data = $query->getResult();
            //$data = $query->get()->getResultArray();

return $this->respondCreated($data); 
    } 
}
?>