1#@!#!123s

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

class Exhibitors extends CI_Controller
{

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

	public function index()
	{
		check_login();
		$data['exhibitors'] = $this->Exhibitors_model->list_exhibitors();
		$data['content'] = "admin/exhibitors/list";
		$this->load->view('admin/template', $data);
	}

	public function add()
	{
		$data['type'] = $this->Exhibitors_model->list_type();
		$data['special'] = $this->Exhibitors_model->list_product();
		$data['content'] = "admin/exhibitors/add";
		$this->load->view('admin/template', $data);
	}

	public function type()
	{
		check_login();
		$data['type'] = $this->Exhibitors_model->list_type();
		$data['content'] = "admin/exhibitors/industry_type";
		$this->load->view('admin/template', $data);
	}

	public function product()
	{
		check_login();
		$data['type'] = $this->Exhibitors_model->list_type();
		$data['special'] = $this->Exhibitors_model->list_product();
		$data['content'] = "admin/exhibitors/specialization";
		$this->load->view('admin/template', $data);
	}

	public function feedback()
	{
		$data['exhibitors'] = $this->Exhibitors_model->list_exhibitors();
		$data['content'] = "admin/exhibitors/feedback_form";
		$this->load->view('admin/template', $data);
	}

	public function Lists()
	{
		check_login();
		$data['feedback'] = $this->Exhibitors_model->list_feedback();
		$data['content'] = "admin/exhibitors/feedback_list";
		$this->load->view('admin/template', $data);
	}

	public function save_industry_type()
	{
		$id = $this->input->post('industry_id');
		$industry_type = $this->input->post('industry_type');
		$status = 1;

		if (!empty($id)) {
			$this->Exhibitors_model->update_type($id, $industry_type);
		} else {
			$this->Exhibitors_model->save_type($industry_type, $status);
		}
		redirect('type');
	}


	public function type_delete($id)
	{
		$result = $this->Exhibitors_model->delete_type($id);
		redirect('type');
	}

	public function save_specialization()
	{
		$id = $this->input->post('product_id');
		$type_id = $this->input->post('type_id');
		$specialization = $this->input->post('specialization');
		$status = 1;

		if (!empty($id)) {
			$this->Exhibitors_model->update_product($id, $type_id, $specialization);
		} else {
			$this->Exhibitors_model->save_product($type_id, $specialization, $status);
		}
		redirect('product');
	}


	public function product_delete($id)
	{
		$result = $this->Exhibitors_model->delete_product($id);
		redirect('product');
	}

	public function get_specializations()
	{
		$industry_type_id = $this->input->post('industry_type_id');
		$specializations = $this->Exhibitors_model->specializations_get($industry_type_id);

		foreach ($specializations as $specialization) {
			echo '<option value="' . $specialization->id . '">' . $specialization->specialization . '</option>';
		}
	}


	public function save_exhibitors()
	{
		$id = $this->input->post('exhibitors_id');
		$company_name = $this->input->post('company_name');
		$employee_name = $this->input->post('employee_name');
		$email = $this->input->post('email');
		$job_title = $this->input->post('job_title');
		$industry_type = $this->input->post('industry_type');
		$specialization = $this->input->post('specialization');
		$phone_number = $this->input->post('phone_number');
		$website = $this->input->post('website');
		$city = $this->input->post('city');
		$country = $this->input->post('country');
		$linkedin_contact = $this->input->post('linkedin_contact');
		$total_employee = $this->input->post('total_employee');
		$revenue = $this->input->post('revenue');
		$address = $this->input->post('address');
		$status = 1;

		if (!empty($id)) {
			$this->Exhibitors_model->update_exhibitors($id, $company_name, $employee_name, $email, $job_title, $industry_type, $specialization, $phone_number, $website, $city, $country, $linkedin_contact, $total_employee, $revenue, $address);
		} else {
			$this->Exhibitors_model->save_exhibitors($company_name, $employee_name, $email, $job_title, $industry_type, $specialization, $phone_number, $website, $city, $country, $linkedin_contact, $total_employee, $revenue, $address, $status);
		}
		redirect('list');
	}

	public function form($id = null)
	{
		if ($id) {
			$exhibitor = $this->Exhibitors_model->exhibitor_edit($id);
			$data['exhibitor'] = $exhibitor;
		} else {
			$data['exhibitor'] = null;
		}

		// Load the form view with exhibitor data
		$data['type'] = $this->Exhibitors_model->list_type();
		$data['special'] = $this->Exhibitors_model->list_product();
		$data['content'] = "admin/exhibitors/add";
		$this->load->view('admin/template', $data);
	}


	public function edit_exhibitor($id)
	{
		$exhibitor = $this->Exhibitors_model->exhibitor_edit($id);
		echo json_encode($exhibitor);
	}


	public function exhibitors_delete($id)
	{
		$result = $this->Exhibitors_model->delete_exhibitors($id);
		redirect('list');
	}

	public function get_company()
	{
		$id = $this->input->post('id');
		if ($id) {
			$exhibitor = $this->Exhibitors_model->get_exhibitor_by_id($id);
			if ($exhibitor) {
				echo json_encode($exhibitor);
			} else {
				echo json_encode(null);
			}
		}
	}

	public function save_feedback()
	{
		$id = $this->input->post('feedback_id');
		$company_name = $this->input->post('company_name');
		$employee_name = $this->input->post('employee_name');
		$phone_number = $this->input->post('phone_number');
		$email = $this->input->post('email');
		$rating = $this->input->post('rating');
		$event = $this->input->post('event');
		$Quality = $this->input->post('Quality');
		$Facilities = $this->input->post('Facilities');
		$Attendance = $this->input->post('Attendance');
		$Networking = $this->input->post('Networking');
		$erbil_expo = $this->input->post('erbil_expo');
		$future_event = $this->input->post('future_event');
		$suggestions = $this->input->post('suggestions');
		$status = 1;

		if (!empty($id)) {
			$this->Exhibitors_model->update_feedback($id, $company_name, $employee_name, $phone_number, $email, $rating, $event, $Quality, $Facilities, $Attendance, $Networking, $erbil_expo, $future_event, $suggestions);
		} else {
			$this->Exhibitors_model->save_feedback($company_name, $employee_name, $phone_number, $email, $rating, $event, $Quality, $Facilities, $Attendance, $Networking, $erbil_expo, $future_event, $suggestions, $status);
		}
		redirect('Lists');
	}

	public function edit($id = null)
	{
		if ($id) {
			$feedback = $this->Exhibitors_model->feedback_edit($id);
			$data['feedback'] = $feedback;
		} else {
			$data['feedback'] = null;
		}

		// Load the form view with exhibitor data
		$data['exhibitors'] = $this->Exhibitors_model->list_exhibitors();
		$data['content'] = "admin/exhibitors/feedback_form";
		$this->load->view('admin/template', $data);
	}


	public function edit_feedback($id)
	{
		$feedback = $this->Exhibitors_model->feedback_edit($id);
		echo json_encode($feedback);
	}

	public function feedback_delete($id)
	{
		$result = $this->Exhibitors_model->delete_feedback($id);
		redirect('Lists');
	}

	public function print_feedback($id)
	{
		$feedback = $this->Exhibitors_model->feedback_edit($id);
		$data['feedback'] = $feedback;

		$this->load->view('admin/exhibitors/print_feedback', $data);
	}

	public function export_pdf()
	{
		$selectedIds = $this->input->post('selectedIds');
		$idsArray = explode(',', $selectedIds);
		$data['feedback'] = $this->Exhibitors_model->get_feedback_by_ids($idsArray);

		$data['content'] = "admin/exhibitors/feedback_pdf";
		$this->load->view('admin/template', $data);
	}

	public function export_csv()
	{
		// Fetch data from the Exhibitors table, Industry Type table, and Specialization table
		$exhibitors = $this->Exhibitors_model->list_exhibitors();
		$industry_types = $this->Exhibitors_model->list_type(); // Assuming you have a method to fetch industry types
		$specializations = $this->Exhibitors_model->list_product(); // Assuming you have a method to fetch specializations

		if (isset($_POST['downloadExcel'])) {
			$filename = 'exhibitorsreport.csv';
			header('Content-Type: text/csv');
			header('Content-Disposition: attachment; filename="' . $filename . '"');
			header('Pragma: no-cache');
			header('Expires: 0');

			$output = fopen('php://output', 'w');

			// First Section - Exhibitors Data
			fputcsv($output, array('Exhibitors Data'));
			fputcsv($output, array('Company Name', 'Employee Name', 'Email', 'Job Title', 'Industry Type', 'Specialization', 'Phone Number', 'Website', 'City', 'Country', 'Linkedin Contacts', 'Total Employee', 'Revenue', 'Address'));

			if (!empty($exhibitors)) {
				// Limit to 1 exhibitor
				$row = $exhibitors[0];
				fputcsv($output, array(
					$row->company_name,
					$row->employee_name,
					$row->email,
					$row->job_title,
					$row->industry_type,
					$row->specialization,
					$row->phone_number,
					$row->website,
					$row->city,
					$row->country,
					$row->linkedin_contact,
					$row->total_employee,
					$row->revenue,
					$row->address,
				));
			} else {
				fputcsv($output, array('No exhibitor data found'));
			}

			// Add a separator line before the next section
			fputcsv($output, array(''));

			// Second Section - Industry Types Data
			fputcsv($output, array('Industry Types Data'));
			fputcsv($output, array('Industry Type ID', 'Industry Type Name'));

			if (!empty($industry_types)) {
				foreach ($industry_types as $type) {
					fputcsv($output, array(
						$type->id,
						$type->industry_type,
					));
				}
			} else {
				fputcsv($output, array('No industry type data found'));
			}

			// Add a separator line before the next section
			fputcsv($output, array(''));

			// Third Section - Specializations Data
			fputcsv($output, array('Specializations Data'));
			fputcsv($output, array('Specialization ID', 'Specialization Name'));

			if (!empty($specializations)) {
				foreach ($specializations as $specialization) {
					fputcsv($output, array(
						$specialization->id,
						$specialization->specialization,
					));
				}
			} else {
				fputcsv($output, array('No specialization data found'));
			}

			fclose($output);
			exit;
		} else {
			echo 'No data found';
		}
	}


	public function import()
	{
		$data = array();
		$memData = array();

		if ($this->input->post('importSubmit')) {
			$this->form_validation->set_rules('file', 'CSV file', 'callback_file_check');

			if ($this->form_validation->run() == true) {
				$insertCount = $updateCount = $rowCount = $notAddCount = 0;

				if (is_uploaded_file($_FILES['file']['tmp_name'])) {
					$this->load->library('CSVReader');

					$csvData = $this->csvreader->parse_csv($_FILES['file']['tmp_name']);

					if (!empty($csvData)) {
						foreach ($csvData as $row) {
							$rowCount++;

							// Prepare data for insertion/update
							$memData = array(
								'company_name' => !empty($row['Company Name']) ? $row['Company Name'] : null,
								'employee_name' => !empty($row['Employee Name']) ? $row['Employee Name'] : null,
								'email' => !empty($row['Email']) ? $row['Email'] : null,
								'job_title' => !empty($row['Job Title']) ? $row['Job Title'] : null,
								'industry_type' => !empty($row['Industry Type']) ? $row['Industry Type'] : null,
								'specialization' => !empty($row['Specialization']) ? $row['Specialization'] : null,
								'phone_number' => !empty($row['Phone Number']) ? $row['Phone Number'] : null,
								'website' => !empty($row['Website']) ? $row['Website'] : null,
								'city' => !empty($row['City']) ? $row['City'] : null,
								'country' => !empty($row['Country']) ? $row['Country'] : null,
								'linkedin_contact' => !empty($row['Linkedin Contacts']) ? $row['Linkedin Contacts'] : null,
								'total_employee' => !empty($row['Total Employee']) ? $row['Total Employee'] : null,
								'revenue' => !empty($row['Revenue']) ? $row['Revenue'] : null,
								'address' => !empty($row['Address']) ? $row['Address'] : null,
								'status' => 1,
								'create_at' => date("Y-m-d H:i:s"),
							);

							// Check whether member already exists in the database with the same email
							// $con = array(
							//     'where' => array('email' => $row['Email']),
							//     'returnType' => 'count'
							// );
							// $prevCount = $this->Exhibitors_model->getRows($con);

							// if ($prevCount > 0) {
							//     // Update member data
							//     $condition = array('email' => $row['Email']);
							//     $update = $this->Exhibitors_model->update($memData, $condition);

							//     if ($update) {
							//         $updateCount++;
							//     }
							// } 
							// else {
							// Insert member data
							$insert = $this->Exhibitors_model->insert($memData);

							if ($insert) {
								$insertCount++;
							}
							//}
						}

						$this->session->set_userdata('success_msg', 'Data imported successfully. Inserted: ' . $insertCount . ' Updated: ' . $updateCount);
					} else {
						$this->session->set_userdata('error_msg', 'No data found in the CSV file.');
					}
				} else {
					$this->session->set_userdata('error_msg', 'Error on file upload, please try again.');
				}
			} else {
				$this->session->set_userdata('error_msg', 'Invalid file, please select only a CSV file.');
			}
		}
		redirect('Exhibitors');
	}


	public function file_check($str)
	{
		$allowed_mime_types = array(
			'text/x-comma-separated-values',
			'text/comma-separated-values',
			'application/octet-stream',
			'application/vnd.ms-excel',
			'application/x-csv',
			'text/x-csv',
			'text/csv',
			'application/csv',
			'application/excel',
			'application/vnd.msexcel',
			'text/plain'
		);
		if (isset($_FILES['file']['name']) && $_FILES['file']['name'] != "") {
			$mime = get_mime_by_extension($_FILES['file']['name']);
			$fileAr = explode('.', $_FILES['file']['name']);
			$ext = end($fileAr);
			if (($ext == 'csv') && in_array($mime, $allowed_mime_types)) {
				return true;
			} else {
				$this->form_validation->set_message('file_check', 'Please select only CSV file to upload.');
				return false;
			}
		} else {
			$this->form_validation->set_message('file_check', 'Please select a CSV file to upload.');
			return false;
		}
	}
}