1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / Doshmananehmarefat / application / controllers /
Filename : Reports.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Reports extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        if ($this->session->userdata('id') == '') {
            redirect(base_url() . 'Nirvakam');
        }

        $this->data['theme'] = 'Nirvakam';
        $this->data['module'] = 'reports';
        $this->data['page'] = '';
        $this->data['base_url'] = base_url();

        $this->load->model('Common_model', 'Common');
        $this->load->model('Blog_model', 'blog');
    }

    public function index()
    {
        $this->data['reports_category'] = $this->Common->get_records("tbl_reports_category", "*", array('status' => 0));
        $this->data['reports_subcategory'] = $this->Common->get_records("tbl_reports_subcategory", "*", array('status' => 0));
        $this->data['settings'] = $this->Common->get_records("tbl_settings", "*", array('status' => 0));
        $this->data['page'] = 'reports_create';
        $this->load->vars($this->data);
        $this->load->view($this->data['theme'] . '/template');
    }

    public function reports_list()
    {
        $this->data['reports'] = $this->Common->get_records("tbl_reports", "*", array('status' => 0));
        $this->data['page'] = 'reports_list';
        $this->load->vars($this->data);
        $this->load->view($this->data['theme'] . '/template');
    }

    public function reports_save()
    {

        $id = $where['id'] = $this->input->post('id');
        $values['category_id'] = $this->input->post('category_id');
        $values['subcategory_id'] = $this->input->post('subcategory_id');
        $values['settings_id'] = $this->input->post('settings_id');
        $values['title'] = $this->input->post('title');
        $values['description'] = $this->input->post('description');
        $values['content_type'] = $this->input->post('content_type');

        if ($values['content_type'] == 'link') {
            $values['content_link'] = $this->input->post('content_link');
        } elseif ($values['content_type'] == 'pdf') {
            if (isset($_FILES['content_pdf']['name']) && !empty($_FILES['content_pdf']['name'])) {
                $config['upload_path'] = 'uploads/reports';
                $config['allowed_types'] = 'pdf';
                $config['file_name'] = rand() . time();

                $this->load->library('upload', $config);

                if (!$this->upload->do_upload('content_pdf')) {
                    $this->session->set_flashdata('error', $this->upload->display_errors());
                    redirect('reports_create');
                    return;
                } else {
                    $data = $this->upload->data();
                    $values['content_pdf'] = $data['file_name'];
                }
            }
        } elseif ($values['content_type'] == 'own_content') {
            $values['own_content'] = $this->input->post('own_content');
        }

        if (isset($_FILES['image']['name']) && !empty($_FILES['image']['name'])) {
            $config['upload_path'] = 'uploads/reports';
            $config['allowed_types'] = 'jpg|png|jpeg|webp';
            $config['file_name'] = rand() . time();

            $this->load->library('upload', $config);

            if (!$this->upload->do_upload('image')) {
                $this->session->set_flashdata('error', "Please upload an image with dimensions 1568 * 789.");
                redirect('reports_create');
                return;
            } else {
                $data = array('upload_data' => $this->upload->data());
                $values['image'] = $data['upload_data']['file_name'];
            }
        }
        if (!empty($id)) {
            $values['updated_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->update('tbl_reports', $values, $where);
            $this->session->set_flashdata('success', 'Reports updated successfully.');
        } else {
            $values['created_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->insert('tbl_reports', $values);
            $this->session->set_flashdata('success', 'Reports added successfully.');
        }

        redirect("reports_list");
    }

    public function reports_edit($id = NULL)
    {
        $this->data['reports_category'] = $this->Common->get_records("tbl_reports_category", "*", array('status' => 0));
        $this->data['reports_subcategory'] = $this->Common->get_records("tbl_reports_subcategory", "*", array('status' => 0));
        $this->data['settings'] = $this->Common->get_records("tbl_settings", "*", array('status' => 0));
        $this->data['reports'] = null;

        if ($id) {
            $this->data['reports'] = $this->blog->getreports($id);
        }

        $this->data['page'] = 'reports_create';
        $this->load->vars($this->data);
        $this->load->view($this->data['theme'] . '/template');
    }

    public function reports_delete($id)
    {

        $where['id'] = $id;
        $values['status'] = 1;
        $this->Common->update('tbl_reports', $values, $where);
        $this->session->set_flashdata('success', 'Reports deleted successfully');
        redirect("reports_list");
    }

    public function reports_category()
    {
        $this->data['reports_category'] = $this->Common->get_records("tbl_reports_category", "*", array('status' => 0));
        $id = $this->uri->segment(3);
        if ($id) {
            $this->data['edit_category'] = $this->Common->get_record("tbl_reports_category", "*", array('id' => $id));
        } else {
            $this->data['edit_category'] = null;
        }
        $this->data['page'] = 'reports_category';
        $this->load->vars($this->data);
        $this->load->view($this->data['theme'] . '/template');
    }

    public function reports_category_save()
    {
        $id = $this->input->post('id');
        $values = array(
            'title' => $this->input->post('title'),
            'description' => $this->input->post('description')
        );

        if (!empty($id)) {
            $values['updated_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->update('tbl_reports_category', $values, array('id' => $id));
            $this->session->set_flashdata('success', 'Reports Category updated successfully.');
        } else {
            $values['created_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->insert('tbl_reports_category', $values);
            $this->session->set_flashdata('success', 'Reports Category added successfully.');
        }
        redirect("reports_category");
    }

    public function reports_category_delete($id)
    {
        $where['id'] = $id;
        $values['status'] = 1;
        $this->Common->update('tbl_reports_category', $values, $where);
        $this->session->set_flashdata('success', 'Reports Category deleted successfully');
        redirect("reports_category");
    }

    public function reports_subcategory()
    {
        $this->data['reports_category'] = $this->Common->get_records("tbl_reports_category", "*", array('status' => 0));
        $this->data['reports_subcategory'] = $this->Common->get_records("tbl_reports_subcategory", "*", array('status' => 0));
        $id = $this->uri->segment(3);
        if ($id) {
            $this->data['edit_subcategory'] = $this->Common->get_record("tbl_reports_subcategory", "*", array('id' => $id));
        } else {
            $this->data['edit_subcategory'] = null;
        }
        $this->data['page'] = 'reports_subcategory';
        $this->load->vars($this->data);
        $this->load->view($this->data['theme'] . '/template');
    }

    public function reports_subcategory_save()
    {
        $id = $this->input->post('id');
        $values = array(
            'category_id' => $this->input->post('category_id'),
            'title' => $this->input->post('title'),
            'description' => $this->input->post('description')
        );

        if (!empty($id)) {
            $values['updated_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->update('tbl_reports_subcategory', $values, array('id' => $id));
            $this->session->set_flashdata('success', 'Reports SubCategory updated successfully.');
        } else {
            $values['created_at'] = date('Y-m-d h:i:s');
            $insert_id = $this->Common->insert('tbl_reports_subcategory', $values);
            $this->session->set_flashdata('success', 'Reports SubCategory added successfully.');
        }
        redirect("reports_subcategory");
    }

    public function reports_subcategory_delete($id)
    {
        $where['id'] = $id;
        $values['status'] = 1;
        $this->Common->update('tbl_reports_subcategory', $values, $where);
        $this->session->set_flashdata('success', 'Reports SubCategory deleted successfully');
        redirect("reports_subcategory");
    }
}