<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Vouchers extends Admin_Controller {

	//this property is used for validating existing voucher title on call back edit voucher
	private $voucher_current_id = NULL;
		
	function __construct() {
		parent::__construct();	
		$this->load->model('voucher_m'); 
		$this->load->helper('rajaongkir');
	} 
		
	//this is to list all vouchers
	public function index() {

		/*----FILTER SEARCH VOUCHER--*/
		if(isset($_POST['search_voucher'])) { 

			//get product name from form
			$this->data['keyword'] = $this->security->xss_clean($this->input->post('voucher'));

			//get all customers
			$this->db->select('*');
			$this->db->from('vouchers');
			$this->db->like('voucher_name', $this->data['keyword']);
			$this->db->or_like('voucher_code', $this->data['keyword']);
			$this->db->order_by('created_date', 'DESC');
			$this->data['vouchers'] = $this->db->get()->result();

		} else {
		
			//pagination in action. 300 results per page
			$this->load->library('pagination');
			$config['base_url'] = base_url() . 'admin/vouchers/index';
			$config['total_rows'] = $this->voucher_m->record_count(); 
			$config['per_page'] = 300;
			$config["uri_segment"] = 4;
			$config['num_tag_open'] = '<span style="padding-left:10px; padding-right:10px">';
			$config['num_tag_close'] = '</span>';

			$this->pagination->initialize($config);
	   		$this->data['vouchers'] = $this->voucher_m->get_all_vouchers($config["per_page"], 
			$this->uri->segment(4));  
			$this->data['use_pagination'] = 'yes'; 
		}	

		//load view
		$this->data['subview'] = 'admin/vouchers/index';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');			
    }
	
	//to add a new voucher 
	public function add() {
	
		$this->data['vouchers'] = $this->voucher_m->get_new();

		//get parent product categories
		$this->load->model('category_m');
		$this->data['parent_categories'] = $this->category_m->get_parent_categories(); 	 

		//get brands
		$this->db->select('id_brands, brand')->from('brands')->where('status', '1')->order_by('brand', 'ASC');
		$this->data['brands'] = $this->db->get()->result(); 
		
		//validation in action
		//validation check in action 
		$config = $this->voucher_m->rules;
		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {

			$created_date = date('Y-m-d H:i:s');
			
			if ($this->input->post('expired_date')) {
				
				$expired_date = explode('-', $this->input->post('expired_date'));

				$new_expired_date = $expired_date[2] . '-' . $expired_date[1] . '-' . $expired_date[0];	

			} else {
				$new_expired_date = NULL;
			}

			$data = $this->table_data_processing(
				$this->input->post('voucher_name'), 
				$this->input->post('voucher_code'), 
				$this->input->post('qty_ready'), 
				$this->input->post('maxqty_per_person'), 
				$this->input->post('min_order'), 
				$this->input->post('discount_type'), 
				$this->input->post('discount_value'), 
				$created_date, 
				$new_expired_date,
				$this->input->post('voucher_type'),
				$this->input->post('birthmonth'),
				$this->input->post('gender'),
				$this->input->post('promostart'),
				$this->input->post('promoend'),
				$this->input->post('provincepromo'),
				$this->input->post('quantitypromo')
				);
			$this->voucher_m->add_voucher($data);

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Voucher Add Successful</p>');

			redirect('admin/vouchers');	
		} 
		
		//get all provinces data from provinces table
		$this->db->select('rajaongkir_province_id, province')->from('indonesia_provinces')->order_by('rajaongkir_province_id', 'ASC');
		$this->data['provinces'] = $this->db->get()->result();
		
		//load view
		$this->data['subview'] = 'admin/vouchers/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');
	}
	
	//to edit voucher in admin
	public function edit($id = NULL) { 

		//check if id exist. If not exist, show 404.
		$count = $this->voucher_m->count_exist($id);
		
		if ($count == 0) { 
			//page not exist
			show_404();
		}	

		$this->load->model('category_m');
		$this->data['parent_categories'] = $this->category_m->get_parent_categories(); 	

		//get brands
		$this->db->select('id_brands, brand')->from('brands')->where('status', '1')->order_by('brand', 'ASC');
		$this->data['brands'] = $this->db->get()->result(); 

		$this->data['vouchers'] = $this->voucher_m->get($id);	 

		//get all chosen (active) categories
		$active_categories = $this->data['vouchers']->categorypromo;
		if($active_categories != NULL) {
			$this->data['chosen_categories'] = array_filter(explode(',', $active_categories)); //array_filter to remove empty array element
		} 

		//get all chosen (active) brands
		$active_brands = $this->data['vouchers']->brandpromo;
		if($active_brands != NULL) {
			$this->data['chosen_brands'] = array_filter(explode(',', $active_brands)); //array_filter to remove empty array element
		} 

		$this->voucher_current_id = (int) $id;

		//validation check in action
		$config = $this->voucher_m->rules; 

		$this->form_validation->set_rules($config); 
		$this->form_validation->set_error_delimiters('<div class="error">', '</div>');

		if($this->form_validation->run($this) == TRUE) {
			
			//get current created date from table
			$this->db->select('created_date')->from('vouchers')->where('id_vouchers', (int) $id);
			$created_date = $this->db->get()->row()->created_date;

			if ($this->input->post('expired_date')) {
				
				$expired_date = explode('-', $this->input->post('expired_date'));

				$new_expired_date = $expired_date[2] . '-' . $expired_date[1] . '-' . $expired_date[0];	

			} else {
				$new_expired_date = NULL; 
			}

			$data = $this->table_data_processing(
				$this->input->post('voucher_name'), 
				$this->input->post('voucher_code'), 
				$this->input->post('qty_ready'), 
				$this->input->post('maxqty_per_person'), 
				$this->input->post('min_order'), 
				$this->input->post('discount_type'), 
				$this->input->post('discount_value'), 
				$created_date, 
				$new_expired_date,
				$this->input->post('voucher_type'),
				$this->input->post('birthmonth'),
				$this->input->post('gender'),
				$this->input->post('promostart'),
				$this->input->post('promoend'),
				$this->input->post('provincepromo'),
				$this->input->post('quantitypromo')
				);

			$this->voucher_m->edit_voucher($id, $data); 

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Voucher Edit Successful</p>');
			
			redirect('admin/vouchers/edit/' .  $id);
		} 

		//get all provinces data from provinces table
		$this->db->select('rajaongkir_province_id, province')->from('indonesia_provinces')->order_by('rajaongkir_province_id', 'ASC');
		$this->data['provinces'] = $this->db->get()->result();
		
		//load view
		$this->data['subview'] = 'admin/vouchers/edit';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');
	}
	

	//to delete a voucher
	public function delete($id) {

		//check if id exist. If not exist, show 404.
		$count = $this->voucher_m->count_exist($id);
		
		if ($count == 0) { 
			//page not exist
			show_404();
		}		

		//delete voucher
		$this->voucher_m->delete($id); 

		$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Voucher Delete Successful</p>');
		redirect('admin/vouchers');
	} 


	private function table_data_processing(
		$voucher_name, 
		$voucher_code, 
		$qty_ready, 
		$maxqty_per_person, 
		$min_order, 
		$discount_type, 
		$discount_value, 
		$created_date, 
		$new_expired_date,
		$voucher_type,
		$birthmonth,
		$gender,
		$promostart,
		$promoend,
		$provincepromo,
		$quantitypromo) {

		$data = array(
				'voucher_name' 		=> $this->security->xss_clean($voucher_name),
				'voucher_code' 		=> $this->security->xss_clean($voucher_code),
				'discount_type' => $discount_type,
				'discount_value' => (int) $this->security->xss_clean($discount_value),
				'created_date' => $created_date,
				'expired_date' => $new_expired_date,
				'voucher_type' => $voucher_type,
				'birthmonth' => $birthmonth,
				'gender' => $gender,
				'promostart' => $promostart,
				'promoend' => $promoend,
				'provincepromo' => $provincepromo,
				'quantitypromo' => $quantitypromo

		);		

		if ($qty_ready == '') {
			$data['qty_ready'] = NULL;
		} else {
			$data['qty_ready'] = (int) $this->security->xss_clean($qty_ready);
		}

		if ($maxqty_per_person == '') {
			$data['maxqty_per_person'] = NULL;
		} else {
			$data['maxqty_per_person'] = (int) $this->security->xss_clean($maxqty_per_person);
		}

		if ($min_order == '') {
			$data['min_order'] = NULL;
		} else {
			$data['min_order'] = (int) $this->security->xss_clean($min_order);
		}

		//Promo by Product Category
		//get category_id from view,
		$categories_id = $this->input->post('category_id');

		//check id there is content inside category array
		$categories_id_count = count($categories_id);

		if ($categories_id_count > 0) {
			$data['categorypromo'] = implode(',',$categories_id);
		} else {
			$data['categorypromo'] = NULL;
		}

		//Promo by Brand
		//get brand_id from view,
		$brands_id = $this->input->post('brand_id');

		//check id there is content inside brand array
		$brands_id_count = count($brands_id);

		if ($brands_id_count > 0) {
			$data['brandpromo'] = implode(',', $brands_id);
		} else {
			$data['brandpromo'] = NULL;
		}

		return $data;
	}

	//callback function validation add new voucher
	//make it private by adding _
	public function _cek_existing_voucher_code($str) {

		$num_rows = $this->voucher_m->cek_existing_voucher_code($str, $this->voucher_current_id);   
		if ($num_rows != 0 ) {   
			$this->form_validation->set_message('_cek_existing_voucher_code', 'voucher code already exist !');
			return FALSE;
		} else {
			return TRUE;  
		}
	}

	public function upload_vouchers() {

		//upload products data
		if(!isset($_POST['upload_csv'])) { show_404(); }

		//check if the uploaded file is csv format
		$mimes = array('application/vnd.ms-excel','text/plain','text/csv','text/tsv');
		
		if(in_array($_FILES['userfile']['type'],$mimes)){

			ini_set('auto_detect_line_endings', TRUE); //to detect line ending

			//continue import operation
			//open the csv file and put into variable
			$file = fopen($_FILES['userfile']['tmp_name'],'r') or die('cannot open file');

			//initialize array
	   		$csv_data = array();

			//if not reach end of file...
			while (!feof($file)) {
				//put the csv into array..
				$csv_data[] = fgetcsv($file, 10000, '~'); //file, length, separator..
			}
	   		fclose($file); //close the file

	   		/* echo '<pre>';
	   		print_r($csv_data);
	   		echo '</pre>';
	   		exit(); */

			 $row_number = 0;

			 foreach ($csv_data as $item) {

				$row_number = $row_number + 1;
			
				//skip the 1st row...
				if($row_number != 1) {

					if(empty($item)) {continue;} //if array is empty, then continue to next iteration and bypass below script..

					//check if product code already exist, if already exist, update the row, else, insert new
					$this->db->select('voucher_code')->from('vouchers')->where('voucher_code', $item[0]);
					$count_code = $this->db->get()->num_rows();
					
					if($count_code > 0) {

						//voucher code already exist. update only..
						
						
					} else { 
						//insert new vouchers
						//add to vouchers table
						$data = array(
							'voucher_code' => $item[0],
							'voucher_name' => $item[1],
							'voucher_type' => $item[2],
							'discount_type' => $item[7], 
							'discount_value' => $item[8]
						);

						if(empty($item[6])) {
							$data['min_order'] = NULL;
						} else {
							$data['min_order'] = $item[6];
						}

						if(empty($item[5])) {
							$data['maxqty_per_person'] = NULL;
						} else {
							$data['maxqty_per_person'] = $item[5];
						}

						if(empty($item[4])) {
							$data['qty_ready'] = NULL;
						} else {
							$data['qty_ready'] = $item[4];
						}

						if(empty($item[9])) {
							$data['expired_date'] = NULL;
						} else {
							$data['expired_date'] = $item[9];
						}

						switch ($item[2]) {
							
							case 'normal promo':
								# code...
							break;

							case 'birthday promo':
								$data['birthmonth'] = $item[3];
							break;	

							case 'time promo':
								
								if (strpos($item[3], '|') !== false) {	
									//must have | for start and end time
									$timepromo_array = explode('|', $item[3]);

									$data['promostart'] = trim($timepromo_array[0]);
									$data['promoend'] = trim($timepromo_array[1]);
								} 
							break;	

							case 'quantity promo':
								$data['quantitypromo'] = $item[3];
							break;		

							case 'province promo':
								
								$this->db->select('rajaongkir_province_id')->from('indonesia_provinces')->where('province', $item[3]);
								$province_id = $this->db->get()->row();
								
								if(count($province_id) > 0) {
									$data['provincepromo'] = $province_id->rajaongkir_province_id;
								}
							break;	

							case 'category promo':
								
								if (strpos($item[3], '|') !== false) {	
									//has more than 1 category
									$category_array = explode('|', $item[3]);

									$category_id_array = array();

									foreach ($category_array as $category_name) {
										//check if category exist
										$this->db->select('id_categories')->from('categories')->where('category', trim($category_name));
										$category_id = $this->db->get()->row();

										if(count($category_id) > 0) {
											$category_id_array[] = $category_id->id_categories;
										}
									}

									$data['categorypromo'] = implode(',', $category_id_array);
								
								} else {
									//has only 1 category
									//check if category exist
									$this->db->select('id_categories')->from('categories')->where('category', trim($item[3]));
									$category_id = $this->db->get()->row();

									if(count($category_id) > 0) {
										$data['categorypromo'] = $category_id->id_categories;
									}
								} 
							break;				
							
							case 'brand promo':
								
								if (strpos($item[3], '|') !== false) {	
									//has more than 1 brand
									$brand_array = explode('|', $item[3]);

									$brand_id_array = array();

									foreach ($brand_array as $brand_name) {
										//check if category exist
										$this->db->select('id_brands')->from('brands')->where('brand', trim($brand_name));
										$brand_id = $this->db->get()->row();

										if(count($brand_id) > 0) {
											$brand_id_array[] = $brand_id->id_brands;
										}
									}

									$data['brandpromo'] = implode(',', $brand_id_array);
								
								} else {
									//has only 1 brand
									//check if brand exist
									$this->db->select('id_brands')->from('brands')->where('brand', trim($item[3]));
									$brand_id = $this->db->get()->row();

									if(count($brand_id) > 0) {
										$data['brandpromo'] = $brand_id->id_brands;
									}
								} 
							break;	
						}

						//insert into vouchers table
						$this->db->insert('vouchers', $data); 	
					}

				} /*---end if($row_number != 1) --*/	
			} /*---end foreach ($csv_data as $item) ---*/

			$this->session->set_flashdata('success', '<br><p style="background:green; color:white; padding:5px; font-weight:bold;">Vouchers CSV Imported.</p>');
			redirect('admin/vouchers');

		} else {
			//not a csv file. Not allowed.
			die('Sorry, file type not allowed. Please upload only CSV file.');
		}
	}

	function upload_vouchers_xls() {

		if(!$_POST) {
			redirect('admin/vouchers');
		}
 
		$config['upload_path']		= 'uploads/excel/';
        $config['allowed_types']	= 'xlsx|xls';
        
        $this->load->library('upload', $config);
        
        if ( ! $this->upload->do_upload('userfile')){
            $this->session->set_flashdata('error', '<p style="background:red; color:white; padding:5px; font-weight:bold;">'.strip_tags($this->upload->display_errors()).'</p>');
            redirect('admin/vouchers');
        }
        else{
        	require_once APPPATH . 'third_party/PHPExcel/IOFactory.php';

            $data 			= array('upload_data' => $this->upload->data());
            $upload_data 	= $this->upload->data(); //Mengambil detail data yang di upload
            $filename 		= $upload_data['file_name'];//Nama File

			//ini_set('memory_limit', '-1');

		    $inputFileName = 'uploads/excel/'.$filename;

		    try {
		    	$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
		    } 
		    catch(Exception $e) {
		    	die('Error loading file :' . $e->getMessage());
		    }

		    $worksheet	= $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
		    $numRows 	= count($worksheet);
		  
		    for ($i=1; $i < ($numRows+1) ; $i++) { 
		    	if ($i > 500) {
		    		break;
		    	}
		    	if($i != 1){
		    		$voucher_code = $worksheet[$i]["A"];
		    		$voucher_name = $worksheet[$i]["B"];
		    		$voucher_type = $worksheet[$i]["C"];
		    		$voucher_params = $worksheet[$i]["D"];
		    		$qty_ready = $worksheet[$i]["E"];
		    		$max_qty_person = $worksheet[$i]["F"];
		    		$min_total_order = $worksheet[$i]["G"];
		    		$discount_type = $worksheet[$i]["H"];
		    		$discount_amount = $worksheet[$i]["I"];
		    		$expired_date = $worksheet[$i]["J"];  

		    		$data = array(
							'voucher_name' 		=> $voucher_name,
							'voucher_code' 		=> $voucher_code,
							'voucher_type' 		=> $voucher_type,
							'discount_type' 	=> $discount_type,
							'discount_value' 	=> (int)$discount_amount,
							// 'created_date' 		=> date('Y-m-d'),
							'expired_date' 		=> $expired_date,
							'qty_ready' 		=> $qty_ready,
							'maxqty_per_person' 		=> $max_qty_person,
							'min_order' 		=> $min_total_order,
							// 'brandpromo' 		=> $min_total_order,
							// 'categorypromo' 		=> $min_total_order,
							// 'birthmonth' 		=> $birthmonth,
							// 'gender' 			=> $gender,
							// 'promostart' => $promostart,
							// 'promoend' => $promoend,
							// 'provincepromo' => $provincepromo,
							// 'quantitypromo' => $quantitypromo

					); 
					switch (strtolower($voucher_type)) {
						case 'normal promo':

						break;

						case 'birthday promo':
							$data['birthmonth'] = $voucher_params;
						break;	

						case 'time promo':
							
							if (strpos($voucher_params, '|') !== false) {	
								//must have | for start and end time
								$timepromo_array = explode('|', $voucher_params);

								$data['promostart'] = trim($timepromo_array[0]);
								$data['promoend'] = trim($timepromo_array[1]);
							} 

						break;	

						case 'quantity promo':
							$data['quantitypromo'] = $voucher_params;
						break;		

						case 'province promo':
							
							$this->db->select('rajaongkir_province_id')->from('indonesia_provinces')->where('province', $voucher_params);
							$province_id = $this->db->get()->row();
							
							if(count($province_id) > 0) {
								$data['provincepromo'] = $province_id->rajaongkir_province_id;
							}
						break;	

						case 'category promo':
							
							if (strpos($voucher_params, '|') !== false) {	
								//has more than 1 category
								$category_array = explode('|', $voucher_params);

								$category_id_array = array();

								foreach ($category_array as $category_name) {
									//check if category exist
									$this->db->select('id_categories')->from('categories')->where('category', trim($category_name));
									$category_id = $this->db->get()->row();

									if(count($category_id) > 0) {
										$category_id_array[] = $category_id->id_categories;
									}
								}

								$data['categorypromo'] = implode(',', $category_id_array);
							
							} else {
								//has only 1 category
								//check if category exist
								$this->db->select('id_categories')->from('categories')->where('category', trim($voucher_params));
								$category_id = $this->db->get()->row();

								if(count($category_id) > 0) {
									$data['categorypromo'] = $category_id->id_categories;
								}
							} 
						break;				
						
						case 'brand promo':
							
							if (strpos($voucher_params, '|') !== false) {	
								//has more than 1 brand
								$brand_array = explode('|', $voucher_params);

								$brand_id_array = array();

								foreach ($brand_array as $brand_name) {
									//check if category exist
									$this->db->select('id_brands')->from('brands')->where('brand', trim($brand_name));
									$brand_id = $this->db->get()->row();

									if(count($brand_id) > 0) {
										$brand_id_array[] = $brand_id->id_brands;
									}
								}

								$data['brandpromo'] = implode(',', $brand_id_array);
							
							} else {
								//has only 1 brand
								//check if brand exist
								$this->db->select('id_brands')->from('brands')->where('brand', trim($voucher_params));
								$brand_id = $this->db->get()->row();

								if(count($brand_id) > 0) {
									$data['brandpromo'] = $brand_id->id_brands;
								}
							} 
						break;
					}

					$this->db->insert('vouchers', $data);	
					$id_vouchers = $this->db->insert_id();	

		    	}		            
		    }

		    unlink('uploads/excel/'.$filename);
		    $this->session->set_flashdata('success', '<p style="background:green; color:white; padding:5px; font-weight:bold;">Vouchers XLSX/XLS Imported.</p>');

		    redirect('admin/vouchers');
		}



	}

	
		
}