google_forms/application/controllers/Response_submit.php

<?php

class Response_submit extends CI_Controller
{
    public function view($form_id)
    {
        $this->load->model('Response_model');

        $data['form'] = $this->Response_model->get_form($form_id);
        $questions = $this->Response_model->get_questions($form_id);

        foreach ($questions as $question) {
            $question->options = $this->Response_model->get_options($question->id);
        }

        $data['questions'] = $questions;

        // Redirect to the view_responses function in the Response_submit controller
        redirect('responses/' . $form_id);
    }

    public function view_responses($form_id)
    {
        $this->load->model('Response_model');

        $data['form'] = $this->Response_model->get_form($form_id);
        $data['responses'] = $this->Response_model->get_responses_by_form($form_id);

        $this->load->view('templates/header');
        $this->load->view('responses_list', $data);
        // $this->load->view('templates/footer');
    }


    public function submit_form()
    {
        $this->load->model('Response_model');
        $responses = $this->input->post('responses');
        $user_id = $this->session->userdata('user_id'); // Assuming user_id is stored in session
        $form_id = $this->input->post('form_id'); // Assuming form_id is passed

        // Insert into responses table
        $response_id = $this->Response_model->insert_response([
            'form_id' => $form_id,
            'user_id' => $user_id,
            'submitted_at' => date('Y-m-d H:i:s')
        ]);

        // Insert each answer into response_answers table
        foreach ($responses as $response) {
            $answered_text = '';

            if (isset($response['options'])) {
                if (is_array($response['options'])) {
                    $answered_text = implode(', ', $response['options']);
                } else {
                    $answered_text = $response['options'];
                }
            } elseif (isset($response['answered_text'])) {
                $answered_text = $response['answered_text'];
            }

            $data = [
                'response_id' => $response_id,
                'question_id' => $response['question_id'],
                'answered_text' => $answered_text,
                'submitted_at' => date('Y-m-d H:i:s')
            ];

            $this->Response_model->insert_response_answer($data);
        }

        redirect('responses/' . $form_id);
    }


    // Method to list responses for a form
    public function list_responses($form_id)
    {
        $this->load->model('Response_model');
        $data['form'] = $this->Response_model->get_form($form_id);
        $data['responses'] = $this->Response_model->get_responses($form_id);

        $this->load->view('Frontend/header');
        $this->load->view('responses_list_view', $data);
        $this->load->view('Frontend/footer');
    }

    // Method to view questions and answers for a specific response
    public function viewresponse($response_id)
    {
        $this->load->model('Response_model');
        $data['response'] = $this->Response_model->get_response($response_id);
        $data['form'] = $this->Response_model->get_form_by_response($response_id); // Get form details
        $data['questions_and_answers'] = $this->Response_model->get_questions_and_answers($response_id);

        $this->load->view('templates/header');
        $this->load->view('response_details_view', $data);
        $this->load->view('templates/footer');
    }

    public function summary($form_id)
    {
        $this->load->model('Form_model');
        $this->load->model('Response_model');

        // Check if the user is logged in
        if (!$this->session->userdata('logged_in')) {
            redirect('users/login');
        }

        // Fetch form details
        $form = $this->Form_model->get_form_by_id($form_id);
        if (!$form) {
            show_404();
        }

        // Fetch summary data
        $summary_data = $this->Response_model->get_summary_data($form_id);

        $data['form'] = $form;
        $data['summary_data'] = $summary_data;

        $this->load->view('Forms/summary', $data);
    }


    public function __construct()
    {
        parent::__construct();
        $this->load->model('response_model');
    }

    public function index()
    {
        $data['responses'] = $this->response_model->get_responses_with_details();
        $this->load->view('templates/header');
        $this->load->view('allresponse_details_view', $data);
        $this->load->view('templates/footer');
    }
    public function response_summary()
    {
        $data['forms'] = $this->Response_model->get_forms();
        $this->load->view('templates/header');
        $this->load->view('responses/response_summary', $data);
        $this->load->view('templates/footer');
    }

    public function response_summary_by_form($form_id)
    {
        $responses = $this->Response_model->get_response_summary_by_form($form_id);
        $data = $this->prepare_data($responses);
        $data['form_id'] = $form_id;

        $this->load->view('templates/header');
        $this->load->view('responses/summary', $data);
        $this->load->view('templates/footer');
    }

    private function prepare_data($responses)
    {
        $data = [];
        foreach ($responses as $response) {
            $question_text = $response->question_text;
            if (!isset($data[$question_text])) {
                $data[$question_text] = ['type' => $response->question_type, 'answers' => []];
            }
            $data[$question_text]['answers'][] = $response->answer_text;
        }
        return $data;
    }
}