/application/controllers/merchantaccount.php

Large files files are truncated, but you can click here to view the full file

<?php
class Merchantaccount extends CI_Controller {	
		
	public function __construct()
	{
		parent::__construct();
		$this->load->library(array('form_validation','session', 'ip2location', 'customclass'));	
		
		

		$this->load->helper(array('form', 'url'));
		//$this->load->library('encrypt');
		$this->load->database();
		$this->load->model(array('users','CI_auth','CI_encrypt', 'offers','Admin_Model'));
						
		if($this->CI_auth->check_logged()===FALSE)
		{			
			$this->CI_auth->redirect_nonlogged_user();

		}else{

			$sess_user_data = $this->session->all_userdata();
			if($sess_user_data['user_type']!='2' && $sess_user_data['user_type']!='3')
			{
				$this->CI_auth->redirect_nonlogged_user();				
			}
			
		}	
		
		
	}
	public function index()
	{		
		
	}
	public function contactinfo()
	{	
		
		/* USER ACCESS TYPE CHECK DATA START */
		$logged_user_access_type = $this->users->get_user_access_type();
		$data['logged_user_access_type'] = $logged_user_access_type;
		$data['logged_user_access_sections'] = array();
		if($logged_user_access_type=='3')
		{
			$data['logged_user_access_sections'] = $this->users->get_user_access_sections();
			if(!in_array("1",$data['logged_user_access_sections']))
			{
				redirect('/merchantaccount/welcomeuser', 'refresh');	
			}
		}
		/* USER ACCESS TYPE CHECK DATA END */


		
		$user_id='';
		// $user_id=$this->CI_auth->logged_id();
		$user_id = $this->users->get_main_merchant_id();


		$this->db->select('position_id, position_value');
		$condition=array('delete_status' => '0'); //  Note: Zero is for active, 1 is for deleted
		$this->db->where($condition);
		$positionquery = $this->db->get('user_position');
		$data['positiondata'] = $positionquery->result();		
		
		$data['title'] = 'Services on demand - Ondi.com';	
		
		$this->db->select('email, position, position_other, phone, contact_name, terms_condition, merchant_steps_completed');
		$query = $this->db->get_where('users', array('user_id' => $user_id));
		$data['user_data'] = $query->result();		
		$merchant_steps_completed=$data['user_data'][0]->merchant_steps_completed;
		

		$this->form_validation->set_rules('contact_name', 'Contact Name', 'trim|required');
		$this->form_validation->set_rules('position', 'Position', 'trim|required');		
		$this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email');	
		//$this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email|matches[confirm_email]');		
		//$this->form_validation->set_rules('confirm_email', 'Confirm Email', 'trim|required|valid_email');
		$this->form_validation->set_rules('terms_condition', 'Terms & Condition', 'trim|required');
		

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

			$this->load->view('/merchantaccount/contactinfo', $data);
		}
		else{

			
			if($this->input->post('contact_action')){
				
				$contact_name = $this->input->post('contact_name');
				$position = $this->input->post('position');
				$position_other = $this->input->post('position_other');
				$email = $this->input->post('email');
				$phone = $this->input->post('phone');
				
				$terms_condition = $this->input->post('terms_condition');
				
				if($merchant_steps_completed==0)
				{
					$data = array(
						   'contact_name' => $contact_name,
						   'position' => $position,
						   'position_other' => $position_other,
						   'email' => $email,
						   'phone' => $phone,
						   'terms_condition' => $terms_condition,
						   'merchant_steps_completed' => '1'
							);

				}else{

					$data = array(
					   'contact_name' => $contact_name,
					   'position' => $position,
					   'position_other' => $position_other,
					   'email' => $email,
					   'phone' => $phone,
					   'terms_condition' => $terms_condition
					);

				}
				
				//print_r($data);
				//die;
				$this->db->where('user_id', $user_id);
				$this->db->update('users', $data);
				
				$user_steps_completed = $this->users->user_steps_completed($user_id);
				
				if($user_steps_completed>2)
				{
					redirect('/merchantaccount/viewcontactinfo', 'refresh');
				}
				else
				{
					redirect('/merchantaccount/businessprofile', 'refresh');
				}
			}	
			

		}	

	}
	public function businessprofile()
	{
								
		/* USER ACCESS TYPE CHECK DATA START */
		$logged_user_access_type = $this->users->get_user_access_type();		
		/* USER ACCESS TYPE CHECK DATA END */
				
		$user_id=''; // hard coded as of now
		// $user_id=$this->CI_auth->logged_id();
		$user_id=$this->users->get_main_merchant_id();
		
		$this->db->select('merchant_steps_completed');
		$merchant_steps_completed_query = $this->db->get_where('users', array('user_id' => $user_id));
		$data_merchant_steps_completed = $merchant_steps_completed_query->result();
		$merchant_steps_completed = $data_merchant_steps_completed[0]->merchant_steps_completed;
		if($merchant_steps_completed == '0')
		{
			redirect('/merchantaccount/contactinfo', 'refresh');
		}

		$this->db->select('id, city_name');
		$cityquery = $this->db->get('city');

		
		$this->db->select('state, state_id');
		$statequery = $this->db->get('states');

		//$this->db->select('type_id, type_name');
		//$business_types = $this->db->get('business_types');
		$sql_business_types = "SELECT * FROM business_types WHERE (display_status = '1' OR  merchant_id = '".$user_id."') and delete_status = '0' ORDER BY type_name ASC ";
		$business_types = $this->db->query($sql_business_types);
		//$business_types = $query_business_types->result();


		$this->db->select('pg_id, pg_name');
		$this->db->order_by("pg_id", "desc");
		$price_guide_list_options = $this->db->get('price_guide');
		
		

		$this->db->select('*');
		$userquery_check = $this->db->get_where('merchant_businessprofile', array('user_id' => $user_id));
		$bt_check = $userquery_check->result();
		if(sizeof($bt_check)==0)
		{
			$ins_mp = array('user_id'=>$user_id);
			$this->db->insert('merchant_businessprofile', $ins_mp);		
		}

		$this->db->select('*');
		$userquery = $this->db->get_where('merchant_businessprofile', array('user_id' => $user_id));
		//echo $this->db->last_query(); die;

		//$this->db->select('*');
		//$userquery = $this->db->get('merchant_businessprofile');

		//$this->db->select('*');
		//$opening_hours_query = $this->db->get_where('merchant_opening_hours', array('user_id' => $user_id)); 
		
		$condition=array('a.user_id' => $user_id);
		$this->db->select('a.*');
		$this->db->from('merchant_opening_hours as a');
		$this->db->join('days as b', 'b.day_name = a.day', 'left');
		//$this->db->order_by("b.day_display_order", "asc");
		$this->db->order_by('a.time_group ASC, b.day_display_order asc, a.id asc'); 
		$this->db->where($condition);
		$opening_hours_query = $this->db->get();
		//echo $this->db->last_query(); die;
		//$opening_hours_querydata = $opening_hours_query->result();
		//print_r($opening_hours_querydata); die;




		/*$bt = $userquery->result();
		$cat_array = explode(",", $bt[0]->business_type);
		$this->db->select('service_id, service');
		$this->db->where_in('business_type', $cat_array);
		$servicesquery = $this->db->get('services');
		$dataservices = $servicesquery->result();*/

		$bt = $userquery->result();
		$cat_array = explode(",", $bt[0]->business_type);
		//$this->db->select('id, option_value');
		//$this->db->where_in('business_type', $cat_array);
		//$servicesquery = $this->db->get('business_types_options');
		//echo $this->db->last_query(); die;
		//$dataservices = $servicesquery->result();
		
		
		if($bt[0]->business_type != '')
		{
			$query_services = "SELECT id, option_value FROM business_types_options WHERE (business_type IN (".$bt[0]->business_type.") AND display_status = 1) OR ( merchant_id = '".$user_id."' AND display_status = 0) ";
			$servicesquery = $this->db->query($query_services);
			$dataservices = $servicesquery->result();
		}


		$service_offered_array = explode(",", $bt[0]->service_offered);
		$this->db->select('id, option_value');
		$this->db->where_in('id', $service_offered_array);
		$service_offered_query = $this->db->get('business_types_options');
		if((bool)$this->config->item('test_mode'))
		{
			//echo $this->db->last_query(); die;
		}
		$dataservicesoffered = $service_offered_query->result();


		$perfect_for_array = explode(",", $bt[0]->perfect_for);
		$this->db->select('pf_id, pf_name');
		$this->db->where_in('pf_id', $perfect_for_array);
		$perfect_for_query = $this->db->get('perfect_for');
		//echo $this->db->last_query(); die;
		$dataperfectfor = $perfect_for_query->result();
		//print_r($dataperfectfor);




		$this->db->select('type_name');
		$this->db->where_in('type_id', $cat_array);
		$businesstypesqueryjk = $this->db->get('business_types');
		$databusinesstypesqueryjk = $businesstypesqueryjk->result();



		/*$this->db->select('pf_id, pf_name');
		$condition=array('delete_status' => '0'); //  Note: Zero is for active, 1 is for deleted
		$this->db->where($condition);
		$perfect_for_list_options = $this->db->get('perfect_for');*/

		if($bt[0]->business_type != '')
		{
			$query_pf = "SELECT * FROM perfect_for WHERE (business_type IN (".$bt[0]->business_type.") AND delete_status = 0) OR pf_name='N/A' ";
			$pfquery = $this->db->query($query_pf);
			$datapf = $pfquery->result();
		}


		if($logged_user_access_type=='3')
		{

			$data = array('city_options' => $cityquery->result(), 'state_options' => $statequery->result(), 'userdata' => $userquery->result(), 'business_types' => $business_types->result(), 'price_guide_list_options' => $price_guide_list_options->result(), 'perfect_for_list_options' => $datapf, 'title' => 'Services on demand - Ondi.com', 'opening_hours_query' => $opening_hours_query->result(), 'dataservices' => $dataservices, 'logged_user_access_type' =>$logged_user_access_type, 'logged_user_access_sections'=>$this->users->get_user_access_sections(), 'databusinesstypesqueryjk' => $databusinesstypesqueryjk, 'dataservicesoffered' => $dataservicesoffered, 'dataperfectfor' => $dataperfectfor);

		}else{

			$data = array('city_options' => $cityquery->result(), 'state_options' => $statequery->result(), 'userdata' => $userquery->result(), 'business_types' => $business_types->result(), 'price_guide_list_options' => $price_guide_list_options->result(), 'perfect_for_list_options' => $datapf, 'title' => 'Services on demand - Ondi.com', 'opening_hours_query' => $opening_hours_query->result(), 'dataservices' => $dataservices, 'logged_user_access_type' =>$logged_user_access_type, 'logged_user_access_sections'=>array(), 'databusinesstypesqueryjk' => $databusinesstypesqueryjk, 'dataservicesoffered' => $dataservicesoffered, 'dataperfectfor' => $dataperfectfor);	

		}
			
		
		$this->form_validation->set_rules('business_name', 'Business Name', 'trim|required');
		$this->form_validation->set_rules('website_address', 'Website Address', 'trim|required');
		$this->form_validation->set_rules('street_address', 'Street Address', 'trim|required');
		$this->form_validation->set_rules('suburb', 'Suburb', 'trim|required');
		$this->form_validation->set_rules('post_code', 'Post Code', 'trim|required');
		$this->form_validation->set_rules('city', 'City', 'trim|required');
		$this->form_validation->set_rules('state', 'State', 'trim|required');
		$this->form_validation->set_rules('business_phone', 'Business phone', 'trim|required');
		$this->form_validation->set_rules('price_guide', 'Price Guide', 'trim|required');
		//$this->form_validation->set_rules('perfect_for', 'Perfect For', 'trim|required');
		
		/*Check if the form passed its validation */
		if ($this->form_validation->run() == FALSE) {
			
			$this->load->view('/merchantaccount/businessprofile', $data);
		}
		else {
			if($this->input->post('submit')){
				//print_r($_POST);
				//print_r($_FILES);
				//exit();
				$business_name = $this->input->post('business_name');
				$website_address = $this->input->post('website_address');
				$street_address = $this->input->post('street_address');
				$suburb = $this->input->post('suburb');
				$post_code = $this->input->post('post_code');
				$city = $this->input->post('city');
				$state = $this->input->post('state');
				$business_phone = $this->input->post('business_phone');
				$mobile_number = $this->input->post('mobile_number');
				$facebook = $this->input->post('facebook');
				$twitter = $this->input->post('twitter');
				$linkedin = $this->input->post('linkedin');
				$googleplus = $this->input->post('googleplus');
				$business_type = $this->input->post('choosen_business_types');
				
				



				// INSERT ADDITIONAL CATEGORIES IF ANY /////
				$num_category = $this->input->post('num_category');
				for($nso = 1; $nso<=$num_category; $nso++)
				{
					$additional_business_category = $this->input->post('additional_cat_'.$nso);
					if(trim($additional_business_category) != '')
					{
						$sql_count_duplicate = "SELECT type_id FROM business_types WHERE (type_name = '".$additional_business_category."' AND display_status = '1') OR ( type_name = '".$additional_business_category."' AND merchant_id = '".$user_id."' )";
						$query_count_duplicate = $this->db->query($sql_count_duplicate);
						$count_duplicate = $query_count_duplicate->num_rows();
						if($count_duplicate==0)
						{						
							$insert_add_cat = array('type_name'=>$additional_business_category, 'display_status' => '0', 'merchant_id' => $user_id);
							$this->db->insert('business_types', $insert_add_cat);	
							$newcategoryid = $this->db->insert_id();

							//$emailmessage = "A new category ".$additional_business_category." added. Kindly approve from admin panel.";
							
							
							$message = '<ul style=" float: left; width: 100%; list-style-type: none; margin: 12px 0; padding: 0px; border: 0;">
							 <li style=" float: left; width: 100%; margin: 12px 0; padding: 0; border: 0;">
							  <div style=" float: left; width: 100%; font-size: 19px; color: #6b6766; text-align: left; line-height: 36px; margin: 0 22px 0 0; padding: 0; border: 0;" align="left">Dear Admin, <br/>A new category '.$additional_business_category.' added. Kindly approve from admin panel.</div>
							</li>
							</ul>';

							
							$emailmessage = '<!DOCTYPE html>
							<html style="overflow: hidden; overflow-y: scroll;  margin: 0; padding: 0; border: 0;">
							<head>
							<meta charset="utf-8">
							<meta name="viewport" content="width=device-width, initial-scale = 1.0, user-scalable = no">
							<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
							<title>ONDI FOOD</title>
							</head>
							<body style="font-size: 12px; color: #181818; font-family: arial; overflow: hidden;  background-color: #fff; margin: 0; padding: 0; border: 0;" bgcolor="#fff">
							<div style=" width: 100%; height: auto; float: left; position: relative; background-color: #fff; margin: 0; padding: 0; border: 0;">
							  <div style=" width: 800px; height: auto; margin: 30px auto; padding: 0; border: 0;">
								<div style="padding:0px 0px; margin:0px 0px 20px 0px; text-indent:25px; text-align:right"><img src="'.$this->config->item('base_url').'public/mailerimages/mailer_logo2.jpg" ></div>
								<div style=" width: 100%; height: auto; float: left; border-top:1px solid #2d2d2d; border-bottom:1px solid #2d2d2d; margin: 0; padding: 15px 0px; ">
								 <img src="'.$this->config->item('base_url').'public/mailerimages/admin_notification.jpg">
								</div>
								<div style=" width: 100%; height: auto; float: left; margin: 30px 0 0; padding: 0; border: 0;">
								  <div style=" width: 798px; height: auto; float: left; margin: 0; padding: 5px 0px; border: 1px solid #c0bdbd;">
									<div style=" height: auto; float: left; width: 92%; font-size: 28px; color: #2d2d2d; font-weight: bold; margin: 0; padding: 25px 32px 0px; "><span style=" font-size: 19px; color: #6b6766; font-weight: normal; margin: 0; padding: 0; border: 0;">'.$message.'</span></div>
								</div>
							  </div>
							</div>
							</body>
							</html>
							';
							
							
							
							
							
							
							$this->offers->send_mail("info@ondi.com", "New Category Added", $emailmessage);
							//$this->offers->send_mail("jitendra.revolute@gmail.com", "New Category Added", $emailmessage);

							if($business_type != '')
							{
								$business_type = $business_type.",".$newcategoryid;
							}
							else
							{
								$business_type = $newcategoryid;
							}
						}
						else
						{
							$data_check_cat = $query_count_duplicate->result();
							$type_id = $data_check_cat[0]->type_id;

							if($business_type != '')
							{
								$explode_business_category = explode(",", $business_type);
								if (!in_array($type_id, $explode_business_category)) {
									$business_type = $business_type.",".$type_id;
								}
							}
							else
							{
								$business_type = $type_id;
							}
						}
					}
				}
				// INSERT ADDITIONAL CATEGORIES IF ANY /////

				$old_profile_picture = $this->input->post('old_profile_picture');
				$old_supporting_picture = $this->input->post('old_supporting_picture');
				$old_widescreen_picture = $this->input->post('old_widescreen_picture');
				$old_pdf_menu = $this->input->post('old_pdf_menu');
				
				$service_offered = '';
				$services_offered = $this->input->post('services_offered');
				for($nso = 0; $nso<=sizeof($services_offered); $nso++)
				{
					if($services_offered[$nso] != '')
					{
						$service_offered .= trim($services_offered[$nso]).',';
					}
				}
				if($service_offered != '') $service_offered = substr($service_offered, 0, -1);
				
				// INSERT ADDITIONAL SERVICES OFFERED IF ANY /////
				$num_so = $this->input->post('num_so');
				for($nso = 1; $nso<=$num_so; $nso++)
				{
					$additional_so = $this->input->post('additional_so_'.$nso);
					if(trim($additional_so) != '')
					{
						$sql_count_duplicate_so = "SELECT id FROM business_types_options WHERE (option_value = '".$additional_so."' AND display_status = '1') OR ( option_value = '".$additional_so."' AND merchant_id = '".$user_id."' )";
						$query_count_duplicate_so = $this->db->query($sql_count_duplicate_so);
						$count_duplicate_so = $query_count_duplicate_so->num_rows();
						if($count_duplicate_so==0)
						{						
							$insert_add_cat = array('option_value'=>$additional_so, 'display_status' => '0', 'merchant_id' => $user_id);
							$this->db->insert('business_types_options', $insert_add_cat);	
							$newsoid = $this->db->insert_id();

							//$emailmessage = "A new service offered ".$additional_so." added. Kindly approve from admin panel.";

							$message = '<ul style=" float: left; width: 100%; list-style-type: none; margin: 12px 0; padding: 0px; border: 0;">
							 <li style=" float: left; width: 100%; margin: 12px 0; padding: 0; border: 0;">
							  <div style=" float: left; width: 100%; font-size: 19px; color: #6b6766; text-align: left; line-height: 36px; margin: 0 22px 0 0; padding: 0; border: 0;" align="left">Dear Admin, <br/>A new service offered '.$additional_so.' added. Kindly approve from admin panel.</div>
							</li>
							</ul>';

							
							$emailmessage = '<!DOCTYPE html>
							<html style="overflow: hidden; overflow-y: scroll;  margin: 0; padding: 0; border: 0;">
							<head>
							<meta charset="utf-8">
							<meta name="viewport" content="width=device-width, initial-scale = 1.0, user-scalable = no">
							<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
							<title>ONDI FOOD</title>
							</head>
							<body style="font-size: 12px; color: #181818; font-family: arial; overflow: hidden;  background-color: #fff; margin: 0; padding: 0; border: 0;" bgcolor="#fff">
							<div style=" width: 100%; height: auto; float: left; position: relative; background-color: #fff; margin: 0; padding: 0; border: 0;">
							  <div style=" width: 800px; height: auto; margin: 30px auto; padding: 0; border: 0;">
								<div style="padding:0px 0px; margin:0px 0px 20px 0px; text-indent:25px; text-align:right"><img src="'.$this->config->item('base_url').'public/mailerimages/mailer_logo2.jpg" ></div>
								<div style=" width: 100%; height: auto; float: left; border-top:1px solid #2d2d2d; border-bottom:1px solid #2d2d2d; margin: 0; padding: 15px 0px; ">
								 <img src="'.$this->config->item('base_url').'public/mailerimages/admin_notification.jpg">
								</div>
								<div style=" width: 100%; height: auto; float: left; margin: 30px 0 0; padding: 0; border: 0;">
								  <div style=" width: 798px; height: auto; float: left; margin: 0; padding: 5px 0px; border: 1px solid #c0bdbd;">
									<div style=" height: auto; float: left; width: 92%; font-size: 28px; color: #2d2d2d; font-weight: bold; margin: 0; padding: 25px 32px 0px; "><span style=" font-size: 19px; color: #6b6766; font-weight: normal; margin: 0; padding: 0; border: 0;">'.$message.'</span></div>
								</div>
							  </div>
							</div>
							</body>
							</html>
							';


							$this->offers->send_mail("info@ondi.com", "New service offered added", $emailmessage);
							//$this->offers->send_mail("jitendra.revolute@gmail.com", "New service offered added", $emailmessage);

							if($service_offered != '')
							{
								$service_offered = $service_offered.",".$newsoid;
							}
							else
							{
								$service_offered = $newsoid;
							}
						}
					}
				}
				// INSERT ADDITIONAL SERVICES OFFERED IF ANY /////




				$price_guide = $this->input->post('price_guide');
				$perfect_for = $this->input->post('perfect_for');

				$confirmation_methods_array = $this->input->post('confirmation_methods');
				if(is_array($confirmation_methods_array))
				{
					$confirmation_methods = implode(",", $confirmation_methods_array);
				}
				else
				{
					$confirmation_methods = '';
				}

				$array_perfect_for = $this->input->post('perfect_for');
				if(is_array($array_perfect_for))
				{
					$perfect_for = implode(",", $array_perfect_for);
				}
				else
				{
					$perfect_for = '';
				}
				
				$sql_cityname = "SELECT city_name FROM city WHERE id ='".$city."' ";
				$exe_cityname = $this->db->query($sql_cityname);
				$data_cityname = $exe_cityname->result();
				$city_name = $data_cityname[0]->city_name;

				$sql_statename = "SELECT state FROM states WHERE state_id ='".$state."' ";
				$exe_statename = $this->db->query($sql_statename);
				$data_statename = $exe_statename->result();
				$state_name = $data_statename[0]->state;

				$about_business = $this->input->post('about_business');
				$parking_details = $this->input->post('parking_details');
				$street_address_map = str_replace(" ", "+", $street_address);
				$suburb_map = str_replace(" ", "+", $suburb);
				$post_code_map = str_replace(" ", "+", $post_code);
				$city_name_map = str_replace(" ", "+", $city_name);
				$state_name_map = str_replace(" ", "+", $state_name);

				$url='http://maps.googleapis.com/maps/api/geocode/json?address='.$street_address_map.'+'.$suburb_map.'+'.$post_code_map.'+'.$city_name_map.'+'.$state_name_map.'&sensor=false';
				//$source = file_get_contents($url);
				$ch = curl_init();
				curl_setopt($ch, CURLOPT_URL, $url);
				curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
				curl_setopt($ch, CURLOPT_PROXYPORT, 3128);
				curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
				curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
				$response = curl_exec($ch);
				curl_close($ch);
				$obj = json_decode($response);

				
				if((bool)$this->config->item('test_mode'))
				{
					//echo $url;
					//print_r($response); die;
				}
				
				
				if(isset($obj))
				{
					$lat = $obj->results[0]->geometry->location->lat;
					$long = $obj->results[0]->geometry->location->lng;
				}
				else
				{
					$lat = "-35.283333";
					$long = "149.216667";
				}




				/*
				
				$config_image['upload_path'] = 'public/uploads/';
				$config_image['allowed_types'] = 'gif|jpg|png';
				$config_image['max_size']	= '1000';
				$config_image['max_width']  = '500';
				$config_image['max_height']  = '400';
				$this->load->library('upload', $config_image);
				$this->upload->initialize($config_image);
				$this->upload->set_allowed_types('*');
				
				if ($this->upload->do_upload('profile_picture')) {
					$data_profile_picture = $this->upload->data();
					$image_profile_picture = $data_profile_picture['file_name'];
					$profile_picture = $config_image['upload_path'].$data_profile_picture['file_name'];
				}
				else
				{
					$profile_picture = $old_profile_picture;
					//$profile_picture = '';
				}

				if ($this->upload->do_upload('supporting_picture')) {
					$data_supporting_picture = $this->upload->data();
					$image_supporting_picture = $data_supporting_picture['file_name'];
					$supporting_picture = $config_image['upload_path'].$data_supporting_picture['file_name'];
				} 
				else
				{
					$supporting_picture = $old_supporting_picture;
					//$supporting_picture = '';
				}

				if ($this->upload->do_upload('widescreen_picture')) {
					$data_widescreen_picture = $this->upload->data();
					$image_widescreen_picture = $data_widescreen_picture['file_name'];
					$widescreen_picture = $config_image['upload_path'].$data_widescreen_picture['file_name'];
				}
				else
				{
					$widescreen_picture = $old_widescreen_picture;
					//$supporting_picture = '';
				}


				*/
				
				$temp_profile_picture = $this->input->post('temp_profile_picture');
				$temp_supporting_picture = $this->input->post('temp_supporting_picture');
				$temp_widescreen_picture = $this->input->post('temp_widescreen_picture');

				$old_profile_picture = $this->input->post('old_profile_picture');
				$old_supporting_picture = $this->input->post('old_supporting_picture');
				$old_widescreen_picture = $this->input->post('old_widescreen_picture');

				if($temp_profile_picture != "")
				{
					$sql_temp_pp = "SELECT * FROM temp_images WHERE id ='".$temp_profile_picture."' ";
					$exe_temp_pp = $this->db->query($sql_temp_pp);
					$count_temp_pp = $exe_temp_pp->num_rows();
					if($count_temp_pp>0)
					{
						foreach($exe_temp_pp->result() as $tmp)
						{
							$profile_picture = $tmp->img_path;

							$sql_del= "DELETE FROM temp_images WHERE id ='".$temp_profile_picture."' ";
							$exe_del = $this->db->query($sql_del);	
							@unlink($old_profile_picture);
						}
					}
				}
				else
				{
					$profile_picture = $old_profile_picture;
				}
				
				
				if($temp_supporting_picture != "")
				{
					$sql_temp_pp = "SELECT * FROM temp_images WHERE id ='".$temp_supporting_picture."' ";
					$exe_temp_pp = $this->db->query($sql_temp_pp);
					$count_temp_pp = $exe_temp_pp->num_rows();
					if($count_temp_pp>0)
					{
						foreach($exe_temp_pp->result() as $tmp)
						{
							$supporting_picture = $tmp->img_path;
							$sql_del= "DELETE FROM temp_images WHERE id ='".$temp_supporting_picture."' ";
							$exe_del = $this->db->query($sql_del);	
							@unlink($old_supporting_picture);
						}
					}
				}
				else
				{
					$supporting_picture = $old_supporting_picture;
				}
				
				if($temp_widescreen_picture != "")
				{
					$sql_temp_pp = "SELECT * FROM temp_images WHERE id ='".$temp_widescreen_picture."' ";
					$exe_temp_pp = $this->db->query($sql_temp_pp);
					$count_temp_pp = $exe_temp_pp->num_rows();
					if($count_temp_pp>0)
					{
						foreach($exe_temp_pp->result() as $tmp)
						{
							$widescreen_picture = $tmp->img_path;
							$sql_del= "DELETE FROM temp_images WHERE id ='".$temp_widescreen_picture."' ";
							$exe_del = $this->db->query($sql_del);	
							@unlink($old_widescreen_picture);
						}
					}
				}
				else
				{
					$widescreen_picture = $old_widescreen_picture;
				}
				//die;




				$config_pdf['upload_path'] = 'public/uploads/pdf/';
				$config_pdf['allowed_types'] = 'pdf';
				$config_pdf['max_size']	= '1000';
				$this->load->library('upload', $config_pdf);
				$this->upload->initialize($config_pdf);
				$this->upload->set_allowed_types('*');
				
				if ($this->upload->do_upload('pdf_menu')) {
					$data_pdf_menu = $this->upload->data();
					//print_r($data_pdf_menu);
					$file_pdf_menu = $data_pdf_menu['file_name'];
					$pdf_menu = $config_pdf['upload_path'].$file_pdf_menu;
				} 
				else
				{
					$pdf_menu = $old_pdf_menu;
					//$pdf_menu = '';
				}
				//echo $file_pdf_menu['file_name'];

				$data_insert = array(
				   'user_id' => $user_id,
				   'business_name' => $business_name,
				   'website_address' => $website_address,
				   'street_address' => $street_address,
				   'suburb' => $suburb,
				   'post_code' => $post_code,
				   'city' => $city,
				   'state' => $state,
				   'business_phone' => $business_phone,
				   'mobile_number' => $mobile_number,
				   'facebook' => $facebook,
				   'twitter' => $twitter,
				   'linkedin' => $linkedin,
				   'googleplus' => $googleplus,
				   'business_type' => $business_type,
				   'service_offered' => $service_offered,
				   'price_guide' => $price_guide,
				   'perfect_for' => $perfect_for,
				   'confirmation_methods' => $confirmation_methods,
				   'about_business' => $about_business,
				   'parking_details' => $parking_details,
				   'profile_picture' => $profile_picture,
				   'supporting_picture' => $supporting_picture,
				   'widescreen_picture' => $widescreen_picture,
				   'pdf_menu' => $pdf_menu,
				   'lat' => $lat,
				   'long' => $long
				);
				$data_update = array(
				   'business_name' => $business_name,
				   'website_address' => $website_address,
				   'street_address' => $street_address,
				   'suburb' => $suburb,
				   'post_code' => $post_code,
				   'city' => $city,
				   'state' => $state,
				   'business_phone' => $business_phone,
				   'mobile_number' => $mobile_number,
				   'facebook' => $facebook,
				   'twitter' => $twitter,
				   'linkedin' => $linkedin,
				   'googleplus' => $googleplus,
				   'business_type' => $business_type,
				   'service_offered' => $service_offered,
				   'price_guide' => $price_guide,
				   'perfect_for' => $perfect_for,
				   'confirmation_methods' => $confirmation_methods,
				   'about_business' => $about_business,
				   'parking_details' => $parking_details,
				   'profile_picture' => $profile_picture,
				   'supporting_picture' => $supporting_picture,
				   'widescreen_picture' => $widescreen_picture,
				   'pdf_menu' => $pdf_menu,
				   'lat' => $lat,
				   'long' => $long
				);
				
				if((bool)$this->config->item('test_mode'))
				{
					//print_r($data_update); die;
				}

				$query = $this->db->get_where('merchant_businessprofile', array('user_id' => $user_id)); 
				$count= $query->num_rows(); 
				//echo $count; die;
				if($count === 0)
				{ 
					$this->db->insert('merchant_businessprofile', $data_insert);
				}
				else
				{
					$this->db->where('user_id', $user_id);
					$this->db->update('merchant_businessprofile', $data_update);
				}
				

				//print_r($_POST);
				//exit();
				for($no=1; $no<=7; $no++)
				{
					if(isset($_POST['oh_'.$no]))
					{
						$arroh = $_POST['oh_'.$no];
						$selected_days_for_this_time_group = "";
						for($jk=0; $jk<sizeof($arroh); $jk++)
						{
							$dayrecord = $arroh[$jk];
							$from = $this->input->post('from_'.$no);
							$from_ampm = $this->input->post('from_ampm_'.$no);
							$to = $this->input->post('to_'.$no);
							$to_ampm = $this->input->post('to_ampm_'.$no);
							$timinings_id = $this->input->post('timinings_id_'.$no);
							$time_group = $this->input->post('time_group_'.$no);

							if($dayrecord =='Mo') $day = "monday";
							else if($dayrecord =='Tu') $day = "tuesday";
							else if($dayrecord =='We') $day = "wednesday";
							else if($dayrecord =='Th') $day = "thursday";
							else if($dayrecord =='Fr') $day = "friday";
							else if($dayrecord =='Sa') $day = "saturday";
							else if($dayrecord =='Su') $day = "sunday";
							
							$selected_days_for_this_time_group .= "'".$day."',";

							if($time_group == "")
							{
								// INSERT ENTRY FOR NEW TIME GROUP
								$time_group = $no;
								$query_insert_oh = "INSERT INTO merchant_opening_hours SET user_id = '".$user_id."', day = '".$day."' , from_hour = '".$from."' , from_ampm = '".$from_ampm."' , to_hour = '".$to."' , to_ampm = '".$to_ampm."' , time_group = '".$time_group."' ";
								$exe_query_insert_oh = $this->db->query($query_insert_oh);



								//////////// VIKAS CODE STARTS /////////////
								$last_opening_insert_id = $this->db->insert_id();	
								$distinct_offer_id = $this->users->get_distinct_offer_id_having_moh_id();
								foreach($distinct_offer_id as $offer_val)
								{
									$offer_id = $offer_val->offer_id;
									if(!empty($offer_id))
									{
										if($update_existing_offers=='1')
										{
											//***** inserting opening hours in existing merchant_offers_available_time start *******//
											if($from_ampm=='am' || $from_ampm=='AM')
											{
												if($from==12)
												{
													$from_hours = '0000';
												}
												else
												{
													$from_hours = $from * 100;
													if($from>=1 && $from<=9)
													{
														$from_hours = '0'.$from_hours;
													}
												}
											}
											else if($from_ampm=='pm' || $from_ampm=='PM')
											{
												if($from==12)
												{
													$from_hours = '1200';
												}
												else
												{
													$from_hours = 1200 + ($from * 100);								
												}
											}						
											if($to_ampm=='am' || $to_ampm=='AM')
											{
												if($to==12)
												{
													$to_hours = '0000';
												}
												else
												{
													$to_hours = $to * 100;
													if($to>=1 && $to<=9)
													{
														$to_hours = '0'.$to_hours;
													}
												}
											}
											else if($to_ampm=='pm' || $to_ampm=='PM')
											{
												if($to==12)
												{
													$to_hours = '1200';
												}
												else
												{
													$to_hours = 1200 + ($to * 100);								
												}
											}
											$days_display_order='';
											if($day=='monday')
											{
												$days_display_order = '1';
											}
											else if($day=='tuesday')
											{
												$days_display_order = '2';
											}
											else if($day=='wednesday')
											{
												$days_display_order = '3';
											}
											else if($day=='thursday')
											{
												$days_display_order = '4';
											}
											else if($day=='friday')
											{
												$days_display_order = '5';
											}
											else if($day=='saturday')
											{
												$days_display_order = '6';
											}
											else if($day=='sunday')
											{
												$days_display_order = '7';
											}
											$available_time_data = array(
												'offer_id' => $offer_id,
												'merchant_id' => $user_id,
												'available_day' => $day,
												'time_from' => $from,
												'time_from_am_pm' => $from_ampm,
												'from_hours' => $from_hours,
												'time_to' => $to,
												'time_to_am_pm' => $to_ampm,
												'to_hours' => $to_hours,
												'quantity' => '1',
												'max_pax' => '',
												'added_date' => date('Y-m-d H:i:s'),
												'available_time_slots_capacity' => '3',
												'days_display_order' => $days_display_order,
												'moh_id' => $last_opening_insert_id
											);										
											if(!empty($offer_id))
											{
												$this->db->insert('merchant_offers_available_time', $available_time_data);
											}																
											//***** inserting opening hours in existing merchant_offers_available_time start *******//
										}
									}
								}
								////////// VIKAS CODE ENDS //////////
							}
							else
							{
								// UPDATE ENTRY FOR OLD TIME GROUP
								$query_select_db_oh = "SELECT id FROM merchant_opening_hours WHERE time_group = '".$time_group."' AND user_id = '".$user_id."' AND  day = '".$day."' ";
								$exe_query_select_db_oh = $this->db->query($query_select_db_oh);
								$data_query_select_db_oh = $exe_query_select_db_oh->result();
								$entry_id = $data_query_select_db_oh[0]->id;
								if($entry_id != '')
								{
									$query_update_oh = "UPDATE merchant_opening_hours SET from_hour = '".$from."' , from_ampm = '".$from_ampm."' , to_hour = '".$to."' , to_ampm = '".$to_ampm."'  WHERE time_group = '".$time_group."' AND user_id = '".$user_id."' AND  day = '".$day."' ";
									$exe_query_update_oh = $this->db->query($query_update_oh);
									/////////  VIKAS CODE STARTS ///////////
									//*************************** updating existing merchant_offers_available_time start ***************************//
									if($from_ampm=='am' || $from_ampm=='AM')
									{
										if($from==12)
										{
											$from_hours = '0000';
										}
										else
										{
											$from_hours = $from * 100;
											if($from>=1 && $from<=9)
											{
												$from_hours = '0'.$from_hours;
											}
										}
									}
									else if($from_ampm=='pm' || $from_ampm=='PM')
									{
										if($from==12)
										{
											$from_hours = '1200';
										}
										else
										{
											$from_hours = 1200 + ($from * 100);								
										}
									}						
									if($to_ampm=='am' || $to_ampm=='AM')
									{
										if($to==12)
										{
											$to_hours = '0000';
										}
										else
										{
											$to_hours = $to * 100;
											if($to>=1 && $to<=9)
											{
												$to_hours = '0'.$to_hours;
											}
										}
									}
									else if($to_ampm=='pm' || $to_ampm=='PM')
									{
										if($to==12)
										{
											$to_hours = '1200';

										}
										else
										{
											$to_hours = 1200 + ($to * 100);								
										}
									}
									$available_time_data = array(							
										'time_from' => $from,
										'time_from_am_pm' => $from_ampm,
										'from_hours' => $from_hours,
										'time_to' => $to,
										'time_to_am_pm' => $to_ampm,
										'to_hours' => $to_hours,
										'added_date' => date('Y-m-d H:i:s')							
									);
									$this->db->where(array('merchant_id'=>$user_id, 'available_time_slots_capacity'=>3, 'moh_id'=>$timinings_id ));
									$this->db->update('merchant_offers_available_time', $available_time_data);							
									//*************************** updating existing merchant_offers_available_time end ***************************//
									/////////   VIKAS CODE ENDS //////////////
								}
								else
								{
									$query_insert_oh = "INSERT INTO merchant_opening_hours SET user_id = '".$user_id."', day = '".$day."' , from_hour = '".$from."' , from_ampm = '".$from_ampm."' , to_hour = '".$to."' , to_ampm = '".$to_ampm."' , time_group = '".$time_group."' ";
									$exe_query_insert_oh = $this->db->query($query_insert_oh);
									//////////// VIKAS CODE STARTS /////////////
									$last_opening_insert_id = $this->db->insert_id();	
									$distinct_offer_id = $this->users->get_distinct_offer_id_having_moh_id();
									foreach($distinct_offer_id as $offer_val)
									{
										$offer_id = $offer_val->offer_id;
										if(!empty($offer_id))
										{
											if($update_existing_offers=='1')
											{
												//***** inserting opening hours in existing merchant_offers_available_time start *******//
												if($from_ampm=='am' || $from_ampm=='AM')
												{
													if($from==12)
													{
														$from_hours = '0000';
													}
													else
													{
														$from_hours = $from * 100;
														if($from>=1 && $from<=9)
														{
															$from_hours = '0'.$from_hours;
														}
													}
												}
												else if($from_ampm=='pm' || $from_ampm=='PM')
												{
													if($from==12)
													{
														$from_hours = '1200';
													}
													else
													{
														$from_hours = 1200 + ($from * 100);								
													}
												}						
												if($to_ampm=='am' || $to_ampm=='AM')
												{
													if($to==12)
													{
														$to_hours = '0000';
													}
													else
													{
														$to_hours = $to * 100;
														if($to>=1 && $to<=9)
														{
															$to_hours = '0'.$to_hours;
														}
													}
												}
												else if($to_ampm=='pm' || $to_ampm=='PM')
												{
													if($to==12)
													{
														$to_hours = '1200';
													}
													else
													{
														$to_hours = 1200 + ($to * 100);								
													}
												}
												$days_display_order='';
												if($day=='monday')
												{
													$days_display_order = '1';
												}
												else if($day=='tuesday')
												{
													$days_display_order = '2';
												}
												else if($day=='wednesday')
												{
													$days_display_order = '3';
												}
												else if($day=='thursday')
												{
													$days_display_order = '4';
												}
												else if($day=='friday')
												{
													$days_display_order = '5';
												}
												else if($day=='saturday')
												{
													$days_display_order = '6';
												}
												else if($day=='sunday')
												{
													$days_display_order = '7';
												}
												$available_time_data = array(
													'offer_id' => $offer_id,
													'merchant_id' => $user_id,
													'available_day' => $day,
													'time_from' => $from,
													'time_from_am_pm' => $from_ampm,
													'from_hours' => $from_hours,
													'time_to' => $to,
													'time_to_am_pm' => $to_ampm,
													'to_hours' => $to_hours,
													'quantity' => '1',
													'max_pax' => '',
													'added_date' => date('Y-m-d H:i:s'),
													'available_time_slots_capacity' => '3',
													'days_display_order' => $days_display_order,
													'moh_id' => $last_opening_insert_id
												);										
												if(!empty($offer_id))
												{
													$this->db->insert('merchant_offers_available_time', $available_time_data);
												}																
												//***** inserting opening hours in existing merchant_offers_available_time start *******//
											}
										}
									}
									////////// VIKAS CODE ENDS //////////
								}
							}
						}
						// DELETE THE RECORD FROM DB IF USER NOT SELECTED THE DAY FOR THIS TIME GROUP
						if($selected_days_for_this_time_group != '') 
						{
							$selected_days_for_this_time_group = substr($selected_days_for_this_time_group, 0, -1);
							$query_select_deleteable_oh = "SELECT id FROM merchant_opening_hours WHERE time_group = '".$time_group."' AND user_id = '".$user_id."' AND  day NOT IN (".$selected_days_for_this_time_group.")";
							$exe_query_select_deleteable_oh = $this->db->query($query_select_deleteable_oh);
							$data_query_select_deleteable_oh = $exe_query_select_deleteable_oh->result();
							foreach($data_query_select_deleteable_oh as $this_deleteable_oh)
							{
								$id_to_del = $this_deleteable_oh->id;
								$query_delete_oh = "DELETE FROM merchant_opening_hours WHERE id = '".$id_to_del."' ";
								$exe_qquery_delete_oh = $this->db->query($query_delete_oh);
							}
						}
					}
					else
					{
						$time_group = $_POST['time_group_'.$no];
						if($time_group != "")
						{
							$query_delete_oh = "DELETE FROM merchant_opening_hours WHERE time_group = '".$time_group."' AND user_id = '".$user_id."' ";
							$exe_qquery_delete_oh = $this->db->query($query_delete_oh);
						}
						
					}
				}

				if($merchant_steps_completed == '1')
				{
					$steps_completed_update = array(
							'merchant_steps_completed' => '2'
					);
					$this->db->where('user_id', $user_id);
					$this->db->update('users', $steps_completed_update);
					redirect('/merchantaccount/bankingdetails', 'refresh');
				}
				else
				{
					redirect('/merchantaccount/viewbusinessprofile', 'refresh');
				}
				
			}
		}


		
	}

	public function bankingdetails()
	{	
		/* USER ACCESS TYPE CHECK DATA START */
		$logged_user_access_type = $this->users->get_user_access_type();
		$data['logged_user_access_type'] = $logged_user_access_type;
		$data['logged_user_access_sections'] = array();
		if($logged_user_access_type=='3')
		{
			$data['logged_user_access_sections'] = $this->users->get_user_access_sections();
		}
		/* USER ACCESS TYPE CHECK DATA END */
		
		
		$user_id='';
		// $user_id=$this->CI_auth->logged_id();
		$user_id=$this->users->get_main_merchant_id();
		
		$data['title'] = 'Services on demand - Ondi.com';		
		
		// $user_id = $this->CI_auth->logged_id();	
		$user_id = $this->users->get_main_merchant_id();

		$this->db->select('branch_name, account_name, bsb, account_number, abn, merchant_steps_completed');
		$query = $this->db->get_where('users', array('user_id' => $user_id));
		$data['user_data'] = $query->result();
		$merchant_steps_completed=$data['user_data'][0]->merchant_steps_completed;	
		

		if($merchant_steps_completed==1)
		{
			redirect('/merchantaccount/businessprofile', 'refresh');
		}

		
		$this->form_validation->set_rules('branch_name', 'Branch name', 'trim|required');
		$this->form_validation->set_rules('account_name', 'Account name', 'trim|required');		
		$this->form_validation->set_rules('bsb', 'BSB', 'trim|required');		
		$this->form_validation->set_rules('account_number', 'Account Number', 'trim|required');
		$this->form_validation->set_rules('abn', 'ABN', 'trim|required');
		

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

			$this->load->view('/merchantaccount/bankingdetails', $data);
		}
		else{

			
			if($this->input->post('bank_detail_action')){
				
				$branch_name = $this->input->post('branch_name');
				$account_name = $this->input->post('account_name');
				$bsb = $this->input->post('bsb');
				$account_number = $this->input->post('account_number');
				$abn = $this->input->post('abn');
				
				
				if($merchant_steps_completed==2)
				{
					$data = array(
						   'branch_name' => $branch_name,
						   'account_name' => $account_name,
						   'bsb' => $bsb,
						   'account_number' => $account_number,
						   'abn' => $abn,
						   'merchant_steps_completed' => 3
						);
				$this->db->where('user_id', $user_id);
				$this->db->update('users', $data);
				redirect('/merchantaccount/profilecompleted', 'refresh');

				}else{

					$data = array(
						   'branch_name' => $branch_name,
						   'account_name' => $account_name,
						   'bsb' => $bsb,
						   'account_number' => $account_number,
						   'abn' => $abn
						);
				$this->db->where('user_id', $user_id);
				$this->db->update('users', $data);
				redirect('/merchantaccount/viewbankingdetails', 'refresh');

				}

			}			

		}
		

	}

	public function profilecompleted()
	{
		$user_id='';
		// $user_id=$this->CI_auth->logged_id();
		$user_id=$this->users->get_main_merchant_id();
		
		/* USER ACCESS TYPE CHECK DATA START */
		$logged_user_access_type = $this->users->get_user_access_type();
		$data['logged_user_access_type'] = $logged_user_access_type;
		$data['logged_user_access_sections'] = array();
		if($logged_user_access_type=='3')
		{
			$data['logged_user_access_sections'] = $this->users->get_user_access_sections();
		}
		/* USER ACCESS TYPE CHECK DATA END */


		$data['users_data'] = $this->users->get_userslist();
		$this->load->view('/merchantaccount/profilecompleted', $data);
	}

	public function welcomeuser()
	{
		$user_id='';
		// $user_id=$this->CI_auth->logged_id();
		$user_id=$this->users->get_main_merchant_id();
		
		/* USER ACCESS TYPE CHECK DATA START */
		$logged_user_access_type = $this->users->get_user_access_type();
		$data['logged_user_access_type'] = $logged_user_access_type;
		$data['logged_user_access_sections'] = array();
		if($logged_user_access_type=='3')
		{
			$data['logged_user_access_sections'] = $this->users->get_user_access_sections();
		}
		/* USER ACCESS TYPE CHECK DATA END */


		$data['users_data'] = $this->users->get_userslist();
		$this->load->view('/merchantaccount/welcomeuser', $data);
	}

	public function getservices()
	{
		$bt = $this->input->post('bt');
		if($bt != '')
		{
			$cat_array = explode(",", $bt);
			$this->db->select('id, option_value');
			$this->db->where_in('business_type', $cat_array);
			$servicesquery = $this->db->get('business_types_options');
			//echo $this->db->last_query();		
			$dataservices = $servicesquery->result();
			$business_type_list = array();
			
			$strreturn = '<ul id="checkboxesgroupso">';
			foreach($dataservices as $row)  
			{
				$chk = '';
				if(in_array('.$row->id.', '.$array_service_offered.'))
				{ 
					$chk =  "checked='checked'"; 
				}
				$strreturn .= ' <li><input class="class_services_offered"  type="checkbox" value="'.$row->id.'" name="services_offered[]" '.$chk.' title="'.$row->option_value.'" onclick="change_so(this);" >'.$row->option_value.'</li>';
			}
			$strreturn .= ' </ul> ';

			if($selectedservicesoffered == '') $selectedservicesoffered = " *Please select";
			$return = '<span><a href="javascript:void(0);" onclick="uncheckall_bp(\'checkboxesgroupso\');">Clear all..</a></span>'.$strreturn.' ';
		}
		else
		{
			$return = '<ul id="checkboxesgroupso"></ul> ';
		}

		
        

		
		echo $return;
	}


	public function getperfectfor()
	{
		$bt = $this->input->post('bt');
		$sql_pf = "SELECT * FROM perfect_for WHERE delete_status = '0' AND business_type IN (".$bt.")  OR pf_name='N/A' ORDER BY pf_name ASC ";
		$exe_pf = $this->db->query($sql_pf);
		$data_pf = $exe_pf->result();
		
		
		


		/*$strreturn = '<img src="'.$this->config->item('base_url').'public/images/…