EVOLUTION-NINJA

Edit File: Yaskawa.php

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

class yaskawa extends CI_Controller{

//index view

public function index()

{

$this->load->view('admin/login');

}

//Login page

public function admin_login()

{

$this->load->view('admin/login');

}

//Admin login

public function login()

{

$email    = $this->input->post('email');

$password = md5($this->input->post('password'));

$pass_word = $this->input->post('password');

$remember = $this->input->post('remember');

$result   = $this->yaskawa_model->admin_login($email,$password);

if($result)

{

if($result->user_type_id == '1')

{

$this->session->set_userdata('admin',$result->user_name);

$this->session->set_userdata('admin_id',$result->user_id);

$this->session->set_userdata('user_type',$result->user_type_name);

$this->session->set_userdata('user_type_id',$result->user_type_id);

$this->session->set_userdata('role_id',$result->role_id);

echo json_encode(array(

'result'    => 1,

'user_type' => $this->session->userdata('user_type'),

'user_name'  => $this->session->userdata('admin'),

'admin_id'  => $this->session->userdata('admin_id'),

'user_type_id'  => $this->session->userdata('user_type_id'),

'role_id'  => $this->session->userdata('role_id'),

));

if($remember==1)

{

$this->load->helper('cookie');

set_cookie("password", $pass_word, time()+86500);

set_cookie("email", $email, time()+86500);

set_cookie("remember", $remember, time()+86500);

}

else if($result->user_type_id == '2')

{

$this->session->set_userdata('user',$result->user_name);

$this->session->set_userdata('user_name',$result->user_name);

$this->session->set_userdata('admin_id',$result->user_id);

$this->session->set_userdata('user_type',$result->user_type_name);

$this->session->set_userdata('role_id',$result->role_id);

echo json_encode(array(

'result'    => 1,

'user_type' => $this->session->userdata('user_type'),

'user_name'  => $this->session->userdata('user_name'),

'admin_id'  => $this->session->userdata('user_id'),

'role_id'  => $this->session->userdata('role_id'),

));

if($remember==1)

{

$this->load->helper('cookie');

set_cookie("password", $password, time()+86500);

set_cookie("email", $email, time()+86500);

set_cookie("remember", $remember, time()+86500);

}

else

{

echo json_encode(array('result'=>0,'message'=>"Wrong login credentials"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Wrong login credentials"));

}

//Logout

public function logout()

{

$this->session->sess_destroy();

redirect('/admin-login');

}

//Admin dashboard

public function admin_dashboard()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/index',$data);

}

else

{

redirect('/');

}

//add_new_leads view

public function new_lead()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$data['user_details']=$this->yaskawa_model->get_user_details();

$data['source_details']=$this->yaskawa_model->get_lead_source_details();

$data['status_details']=$this->yaskawa_model->get_lead_status_details();

$data['lead_ratings']=$this->yaskawa_model->get_lead_ratings_details();

$data['honorific']=$this->yaskawa_model->get_honorific();

$data['customer_type']=$this->yaskawa_model->get_customer_type();

$data['lead_process']=$this->yaskawa_model->get_lead_process();

$data['industry_details']=$this->yaskawa_model->get_lead_industry_details();

$this->load->view('admin/add_new_leads',$data);

}

else

{

redirect('/');

}

//add_new_leads view

public function lead_list()

{

$lead_ids=$this->input->post('lead_ids');

$this->yaskawa_model->deleteleads($lead_ids);

$admin_id = $this->session->userdata('admin_id');

$role_id  = $this->session->userdata('role_id');

if($admin_id)

{

$result['user_type_id'] = $this->access_id();

$result['access'] = $this->access_details();

$result['lead_list']  = $this->yaskawa_model->get_all_leads($role_id);

$result['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/new_lead_list',$result);

}

else

{

redirect('/');

}

//add_new_leads view

// public function add_new_leads()

// {

// 	$admin_id = $this->session->userdata('admin_id');

// 	if($admin_id)

// 	{

// 		$data['user_type_id'] = $this->access_id();

//            $data['access'] = $this->access_details();

// 		$data['company_details']=$this->yaskawa_model->fetch_company_details();

// 		$this->load->view('admin/add_new_lead',$data);

// 	}

// 	else

// 	{

// 		redirect('/');

// 	}

// }

//lead_module view

public function lead_module()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_module',$data);

}

else

{

redirect('/');

}

//list_lead_module view

public function list_lead_module()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/list_lead_module',$data);

}

else

{

redirect('/');

}

//add_employees view

public function add_employees()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['dept_list']   = $this->yaskawa_model->get_all_departments();

$data['e_id']=$this->yaskawa_model->get_emp_id();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/add_new_employee',$data);

}

else

{

redirect('/');

}

//add_department view

public function add_department()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$result['user_type_id'] = $this->access_id();

$result['access'] = $this->access_details();

$result['dept_list']   = $this->yaskawa_model->get_all_departments();

$result['emp_list']   =$this->yaskawa_model->employee_list();

$result['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/add_department',$result);

}

else

{

redirect('/');

}

//add_new_leads view

public function add_designation()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$result['user_type_id'] = $this->access_id();

$result['access'] = $this->access_details();

$result['desig_list']   = $this->yaskawa_model->get_all_designation();

$result['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/add_designation',$result);

}

else

{

redirect('/');

}

//lead_feeds view

public function lead_contact()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_contact',$data);

}

else

{

redirect('/');

}

//lead_feeds view

public function calender()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/calender',$data);

}

else

{

redirect('/');

}

//all_reports view

public function all_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','delete_status'=>'ACTIVE');

$data['contents']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/all_reports',$data);

}

else

{

redirect('/');

}

//recent_reports view

public function recent_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/recent_reports',$data);

}

else

{

redirect('/');

}

//recent_reports_me view

public function recent_reports_me()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/recent_reports_me',$data);

}

else

{

redirect('/');

}

//shared_reports view

public function shared_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/shared_reports',$data);

}

else

{

redirect('/');

}

//potential_reports view

public function potential_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','type'=>'Potential Reports');

$data['contents']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/potential_reports',$data);

}

else

{

redirect('/');

}

//lead_reports view

public function lead_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','type'=>'Lead Reports');

$data['contents']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_reports',$data);

}

else

{

redirect('/');

}

//activity_reports view

public function activity_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','type'=>'Activity Reports');

$data['contents']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/activity_reports',$data);

}

else

{

redirect('/');

}

//sales_matrics_reports view

public function sales_matrics_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','type'=>'Sales Metrics Reports');

$data['contents']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/sales_matrics_report',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function recently_deleted_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$table="report_menu";

$where=array('report_status'=>'ACTIVE','delete_status'=>'DEACTIVE');

$data['content']=$this->yaskawa_model->get_alldata($table,$where);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/recently_deleted_reports',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function potential_performance_reports()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/potential_performance_reports',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function potential_lead_source()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/potential_lead_source',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function potential_sales_this_month()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/potential_sales_this_month',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function potential_todays_sales()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/potential_todays_sales',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_industry_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_industry_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_ownership_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_ownership_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_converted_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_converted_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_todays_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_todays_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_status_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_status_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function lead_source_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_source_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function activity_task_event_list()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/activity_task_event_list',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function sales_across_owners()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/sales_across_owners',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function sales_count_across_owners()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/sales_count_across_owners',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function sales_across_industry()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/sales_across_industry',$data);

}

else

{

redirect('/');

}

//recently_deleted_reports view

public function sales_across_source()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/sales_across_source',$data);

}

else

{

redirect('/');

}

//Sachin-part

public function auto()

{

$keyword=$this->input->get('term');

$key=substr($keyword,1);

$data1=$this->yaskawa_model->Get_search($key);

//print_r($data1);

foreach($data1 as $row)

{

$data[]=$row->lead_owner;

}

echo json_encode($data);

}

//lead_feeds view

public function lead_feeds()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$result['user_type_id'] = $this->access_id();

$result['access'] = $this->access_details();

$result['comment']=$this->yaskawa_model->get_all_comments();

// print_r($result['comment']);

// die();

$result['udata']=$this->yaskawa_model->get_all_users();

$result['send_data']=$this->yaskawa_model->feed_data($admin_id);

$result['login_person_data']=$this->yaskawa_model->login_person($admin_id);

$result['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/lead_feeds',$result);

}

else

{

redirect('/');

}

public function admin_functions()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$user_data['user_type_id'] = $this->access_id();

$user_data['access'] = $this->access_details();

$user_data['users']=$this->yaskawa_model->number_of_users();

$user_data['company_details']=$this->yaskawa_model->fetch_company_details();

$user_data['login_person_data']=$this->yaskawa_model->login_person($admin_id);

$user_data['roles_list_admin'] = $this->yaskawa_model->get_all_roles_admin();

$this->load->view('admin/admin_user',$user_data);

}

else

{

redirect('/');

}

public function insert_feeds()

{

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$send_at 	= $date->format('Y-m-d H:i:s');

$date 		= $date->format('Y-m-d');

$sender_id 	= $this->session->userdata('admin_id');

$user_id    = $this->input->post('user_id');

$message    = $this->input->post('text');

$this->load->library('image_lib');

$file_name = "";

if($_FILES)

{

if(empty($_FILES['upload']['name']))

{

$file_name = "";

}

else

{

$target='document_uploads/';

$target.=time().$_FILES['upload']['name'];

$file_name=time().$_FILES['upload']['name'];

$image=$target;

move_uploaded_file($_FILES['upload']['tmp_name'],$target);

$config['source_image']=$target;

$config['maintain_ratio']=TRUE;

// $config['width']=1280;

// $config['height']=960;

$this->image_lib->initialize($config);

//$this->image_lib->resize();

}

$feeds_details=array(

'sender_id'		     => $sender_id,

'receiver_id'		 => $user_id,

'message'			 => $message,

'send_date_time'     => $send_at,

'document_name'	     => $file_name,

'date'	     		 => $date,

'delete_status'		 =>'ACTIVE'

);

$result=$this->yaskawa_model->feed_insert($feeds_details);

if($result)

{

echo json_encode(array('result'=>1,'res'=>$result));

}

else

{

echo json_encode(array('result'=>0));

}

//sachin part

public function feeds_data_filter(){

$days=$this->input->post('days');

$dt = new DateTime();

if($days=="today"){

$days=$dt->format('Y-m-d');

$result=$this->yaskawa_model->feeds_records($days);
			$ar=array();
			foreach ($result as $key => $value) {

$where=$value->feeds_id;
				//echo $where;
				$table="feeds_comment";
				$data['subcomment']=$this->yaskawa_model->feeds_records1($where,$table);

array_push($ar,$data);
			}

if($ar){

echo json_encode(array('date_result'=>$ar,'result'=>1));

}

else

{

echo json_encode(array('date_result'=>$result,'result'=>0));

}

}else if($days=="yesterday"){

$days=date("Y-m-d", strtotime("-1 day"));

$result=$this->yaskawa_model->feeds_records($days);

$ar=array();
			foreach ($result as $key => $value) {

$where=$value->feeds_id;
				//echo $where;
				$table="feeds_comment";
				$data['subcomment']=$this->yaskawa_model->feeds_records1($where,$table);

array_push($ar,$data);
			}

if($ar){

echo json_encode(array('date_result'=>$ar,'result'=>1));

}

else

{

echo json_encode(array('date_result'=>$result,'result'=>0));

}

}else if($days=="lastweek"){

$date= new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$result=$this->yaskawa_model->feeds_lastweek__records();

$ar1=array();
			foreach ($result as $key => $value) {

$where=$value->feeds_id;
				//echo $where;
				$table="feeds_comment";
				$data['subcomment']=$this->yaskawa_model->feeds_lastweek__records1($where,$table);

array_push($ar1,$data);
			}

if($ar1){

echo json_encode(array('date_result'=>$ar1,'result'=>1));

}

else

{

echo json_encode(array('date_result'=>$result,'result'=>0));

}

}else if($days=="current-month"){

$date= new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$current_month = $date->format('m');

$result=$this->yaskawa_model->currentmonth_feeds_records($current_month);

$ar2=array();
			foreach ($result as $key => $value) {

$where=$value->feeds_id;
				//echo $where;
				$table="feeds_comment";
				$data['subcomment']=$this->yaskawa_model->currentmonth_feeds_records1($where,$table,$current_month);

array_push($ar2,$data);
			}

if($ar2){

echo json_encode(array('date_result'=>$ar2,'result'=>1));

}

else

{

echo json_encode(array('date_result'=>$result,'result'=>0));

}

}else if($days=="lastmonth"){

$date= new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$date = $date->format("Y-m-d");

$lastmonth=date("m", strtotime("-1 MONTH"));

$result=$this->yaskawa_model->feeds_lastmonth__records($lastmonth);

$ar3=array();
			foreach ($result as $key => $value) {

$data['user_name']=$value->sender_name;
				$data['comment']=$value->message;
				$data['admin_pic']=$value->admin_pic;
				$data['document_name']=$value->document_name;
				$data['receiver_name']=$value->receiver_name;
				$data['send_date_time']=$value->send_date_time;
				
				$where=$value->feeds_id;
				//echo $where;
				$table="feeds_comment";
				$data['subcomment']=$this->yaskawa_model->currentmonth_feeds_records1($where,$table,$lastmonth);

array_push($ar3,$data);
			}

if($ar3){

echo json_encode(array('date_result'=>$ar3,'result'=>1));

}

else

{

echo json_encode(array('date_result'=>$result,'result'=>0));

}

//Add New Leads

public function add_new_lead()

{
 	$admin_id			 	  = $this->session->userdata('admin_id');

$role_id 				  = $this->session->userdata('role_id');

$lead_owner               = $this->input->post('lead_owner');

$company_name             = $this->input->post('company_name');

$first_name               = $this->input->post('first_name');

$last_name       		  = $this->input->post('last_name');

$lead_title 			  = $this->input->post('lead_title');

$email   				  = $this->input->post('email');

$phone   				  = $this->input->post('phone');

$fax      				  = $this->input->post('fax');

$mobile      		      = $this->input->post('mobile');

$website      			  = $this->input->post('website');

$lead_source      		  = $this->input->post('lead_source');

$industry           	  = $this->input->post('industry');

$no_of_employees          = $this->input->post('no_of_employees');

$annual_revenue           = $this->input->post('annual_revenue');

$ratings           		  = $this->input->post('ratings');

$email_otp           	  = $this->input->post('email_otp');

$skype_id                 = $this->input->post('skype_id');

$sec_email                = $this->input->post('sec_email');

$twitter                  = $this->input->post('twitter');

$street          		  = $this->input->post('street');

$city           		  = $this->input->post('city');

$state         			  = $this->input->post('state');

$zip_code        	      = $this->input->post('zip_code');

$country                  = $this->input->post('country');

$Cperson                  = $this->input->post('Cperson');

$Cphone                   = $this->input->post('Cphone');

$cType                    = $this->input->post('cType');

$lprocess                 = $this->input->post('lprocess');

$description              = $this->input->post('description');

$lead_status              = $this->input->post('lead_status');

$this->load->library('image_lib');

$file_name = "";

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$created_at = $date->format('Y-m-d');

$lead_details  = array(
							'user_id'			 =>	$admin_id,

'role_id'			 =>	$role_id,

'lead_owner'         => $lead_owner,

'company_name'   	 => $company_name,

'first_name'     	 => $first_name,

'last_name'     	 => $last_name,

'lead_title'		 => $lead_title,

'email'  			 => $email,

'phone'  			 => $phone,

'website'    		 => $website,

'fax'     			 => $fax,

'mobile'     	     => $mobile,

'lead_source'        => $lead_source,

'lead_status'        => $lead_status,

'industry'     		 => $industry,

'no_of_employees'    => $no_of_employees,

'annual_revenue'     => $annual_revenue,

'ratings'             => $ratings,

'email_otp'          => $email_otp,

'skype_id'    		 => $skype_id,

'sec_email'    		 => $sec_email,

'twitter'    		 => $twitter,

'street'    		 => $street,

'city'     			=> $city,

'state'             => $state,

'zip_code'          => $zip_code,

'country'           => $country,

'Cperson' 			=> $Cperson,

'Cphone' 			=> $Cphone,

'cType' 			=> $cType,

'lprocess' 			=> $lprocess,

'description'       => $description,

'delete_status'     => 'ACTIVE',

'created_at'        => $created_at

);

$result = $this->yaskawa_model->add_leads($lead_details);

if($result)

{

echo json_encode(array('result'=>1,'message'=>"Lead added successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Something went wrong.. try again"));

}

//lead list

public function leads_list()

{

$result   = $this->yaskawa_model->get_all_leads();

$menu   = $this->yaskawa_model->get_menu();

// print_r($menu);

// die();

if($result)

{

echo json_encode(array('menu'=>$menu,'leads_list'=>$result,'result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//Delete lead

public function delete_lead()

{

$lead_id    = $this->input->post('lead_id');

$data       = array('delete_status'=>'INACTIVE');

$result     = $this->yaskawa_model->delete_lead($lead_id,$data);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>'Deleted successfully'));

}

else

{

echo json_encode(array('result'=>0));

}

//Edit lead

public function edit_lead()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$lead_id      = $this->uri->segment(2);

$data['lead_details'] = $this->yaskawa_model->edit_lead_details($lead_id);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/edit_content_form',$data);

}

else

{

redirect('/');

}

//Update lead

public function update_lead()

{

$lead_id                  = $this->input->post('lead_id');

$lead_owner               = $this->input->post('lead_owner');

$company_name             = $this->input->post('company_name');

$first_name               = $this->input->post('first_name');

$last_name       		  = $this->input->post('last_name');

$lead_title 			  = $this->input->post('lead_title');

$email   				  = $this->input->post('email');

$phone   				  = $this->input->post('phone');

$fax      				  = $this->input->post('fax');

$mobile      		      = $this->input->post('mobile');

$website      			  = $this->input->post('website');

$lead_source      		  = $this->input->post('lead_source');

$industry           	  = $this->input->post('industry');

$no_of_employees          = $this->input->post('no_of_employees');

$annual_revenue           = $this->input->post('annual_revenue');

$ratings           		  = $this->input->post('ratings');

$email_otp           	  = $this->input->post('email_otp');

$skype_id                 = $this->input->post('skype_id');

$sec_email                = $this->input->post('sec_email');

$twitter                  = $this->input->post('twitter');

$street          		  = $this->input->post('street');

$city           		  = $this->input->post('city');

$state         			  = $this->input->post('state');

$zip_code        	      = $this->input->post('zip_code');

$country                  = $this->input->post('country');

$description              = $this->input->post('description');

$date           = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$updated_at     = $date->format('Y-m-d H:i:s');

$lead_details  = array(

'lead_owner'         => $lead_owner,

'company_name'   	 => $company_name,

'first_name'     	 => $first_name,

'last_name'     	 => $last_name,

'lead_title'		 => $lead_title,

'email'  			 => $email,

'phone'  			 => $phone,

'website'    		 => $website,

'fax'     			 => $fax,

'mobile'     	     => $mobile,

'lead_source'        => $lead_source,

'industry'     		 => $industry,

'no_of_employees'    => $no_of_employees,

'annual_revenue'     => $annual_revenue,

'ratings'             => $ratings,

'email_otp'          => $email_otp,

'skype_id'    		 => $skype_id,

'sec_email'    		 => $sec_email,

'twitter'    		 => $twitter,

'street'    		 => $street,

'city'     			=> $city,

'state'             => $state,

'zip_code'          => $zip_code,

'country'           => $country,

'description'       => $description,

'delete_status'     => 'ACTIVE',

'updated_at'        => $updated_at

);

$result   = $this->yaskawa_model->update_lead($lead_id,$lead_details);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>"Updated successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Failed to update. Try again"));

}

//Add New Employee

public function add_new_employees()

{

$employee_id       		    = $this->input->post('employee_id');

$first_name                 = $this->input->post('first_name');

$last_name         		    = $this->input->post('last_name');

$email_id             	    = $this->input->post('email_id');

$nick_name       	  		= $this->input->post('nick_name');

$department 			    = $this->input->post('department');

$reporting_to   	 		= $this->input->post('reporting_to');

$source_of_hire 		    = $this->input->post('source_of_hire');

$location 		 		    = $this->input->post('location');

$title                      = $this->input->post('title');

$date_of_joining            = $this->input->post('date_of_joining');

$seating_location           = $this->input->post('seating_location');

$work_phone                 = $this->input->post('work_phone');

$extension                  = $this->input->post('extension');

$employee_status       	    = $this->input->post('employee_status');

$employee_type        	    = $this->input->post('employee_type');

$employee_role      		= $this->input->post('employee_role');

$pan_no      			    = $this->input->post('pan_no');

$date_of_birth      		= $this->input->post('date_of_birth');

$address      				= $this->input->post('address');

$residential_address        = $this->input->post('residential_address');

$marital_status      		= $this->input->post('marital_status');

$job_description    	    = $this->input->post('job_description');

$about_me    			    = $this->input->post('about_me');

$date_of_exit     		    = $this->input->post('date_of_exit');

$gender       				= $this->input->post('gender');

$pre_com_name      		    = $this->input->post('pre_com_name');

$job_title       			= $this->input->post('job_title');

$from_date                  = $this->input->post('from_date');

$to_date                    = $this->input->post('to_date');

$work_job_description       = $this->input->post('work_job_description');

$school_name                = $this->input->post('school_name');

$diplamo_degree             = $this->input->post('diplamo_degree');

$field_of_study             = $this->input->post('field_of_study');

$date_of_completion         = $this->input->post('date_of_completion');

$additional_notes           = $this->input->post('additional_notes');

$interests                  = $this->input->post('interests');

$dependent_name             = $this->input->post('dependent_name');

$dependent_relationship     = $this->input->post('dependent_relationship');

$dependent_dob              = $this->input->post('dependent_dob');

$pre_company      	   	    =	serialize($pre_com_name);

$job_tit                	=	serialize($job_title);

$fromdate               	=	serialize($from_date);

$todate                 	=	serialize($to_date);

$work_job_desc   	    	=	serialize($work_job_description);

$schoolname             	=	serialize($school_name);

$diplamodegree          	=	serialize($diplamo_degree);

$fieldofstudy           	=	serialize($field_of_study);

$dateofcompletion       	=	serialize($date_of_completion);

$additionalnotes        	=	serialize($additional_notes);

$interest               	=	serialize($interests);

$dependentname          	=	serialize($dependent_name);

$dependentrelationship  	=	serialize($dependent_relationship);

$dependentdob           	=	serialize($dependent_dob);

$this->load->library('image_lib');

$file_name = "";

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$created_at = $date->format('Y-m-d H:i:s');

$employee_details  = array(

'employee_id'    	 => $employee_id,

'first_name'    	 => $first_name,

'last_name'   		 => $last_name,

'email_id'     	     => $email_id,

'nick_name'     	 => $nick_name,

'department'		 => $department,

'reporting_to'       => $reporting_to,

'source_of_hire'     => $source_of_hire,

'location'           => $location,

'title'    			 => $title,

'date_of_joining'    => $date_of_joining,

'seating_location'   => $seating_location,

'work_phone'         => $work_phone,

'extension'          => $extension,

'employee_status'    => $employee_status,

'employee_type'      => $employee_type,

'employee_role'      => $employee_role,

'pan_no'             => $pan_no,

'date_of_birth'      => $date_of_birth,

'address'            => $address,

'residential_address'   => $residential_address,

'marital_status'     => $marital_status,

'job_description'    => $job_description,

'about_me'           => $about_me,

'date_of_exit'       => $date_of_exit,

'gender'             => $gender,

'pre_company_name'   => $pre_company,

'job_title'          => $job_tit,

'from_date'          => $fromdate,

'to_date'            => $todate,

'work_job_description'   => $work_job_desc,

'school_name'        => $schoolname,

'diplamo_degree'     => $diplamodegree,

'field_of_study'     => $fieldofstudy,

'date_of_completion' => $dateofcompletion,

'additional_notes'   => $additionalnotes,

'interests'          => $interest,

'dependent_name'     => $dependentname,

'dependent_relationship' => $dependentrelationship,

'dependent_dob'      => $dependentdob,

'delete_status'      => 'ACTIVE',

'created_at'         => $created_at

);

$result = $this->yaskawa_model->add_employee($employee_details);

if($result)

{

echo json_encode(array('result'=>1,'message'=>"Employee added successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Something went wrong.. try again"));

}

//employee list

public function employee_list()

{

$result   = $this->yaskawa_model->get_all_employees();

if($result)

{

echo json_encode(array('employee_list'=>$result,'result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//Add New department

public function add_new_department()

{

$department_name       		= $this->input->post('department_name');

$email_id             	    = $this->input->post('email_id');

$department_lead 		    = $this->input->post('department_lead');

$parent_department   	 	= $this->input->post('parent_department');

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$created_at = $date->format('Y-m-d H:i:s');

$department_details  = array(

'department_name'     => $department_name,

'email_id'     	      => $email_id,

'department_lead'	  => $department_lead,

'parent_department'   => $parent_department,

'delete_status'      => 'ACTIVE',

'created_at'         => $created_at

);

$result = $this->yaskawa_model->add_department($department_details);

if($result)

{

echo json_encode(array('result'=>1,'message'=>"Department added successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Something went wrong.. try again"));

}

//department list

public function department_list()

{

$result   = $this->yaskawa_model->get_all_departments();

if($result)

{

echo json_encode(array('department_list'=>$result,'result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//Delete department

public function delete_department()

{

$department_id    = $this->input->post('department_id');

$data       = array('delete_status'=>'INACTIVE');

$result     = $this->yaskawa_model->delete_department($department_id,$data);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>'Deleted successfully'));

}

else

{

echo json_encode(array('result'=>0));

}

//Edit department

public function edit_department()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$department_id      = $this->uri->segment(2);

$data['emp_details'] = $this->yaskawa_model->edit_department_details($department_id);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/edit_content_form',$data);

}

else

{

redirect('/');

}

//update department

public function update_department()

{

$department_id              = $this->input->post('department_id');

$department_name       		= $this->input->post('department_name');

$email_id             	    = $this->input->post('email_id');

$department_lead 		    = $this->input->post('department_lead');

$parent_department   	 	= $this->input->post('parent_department');

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$updated_at = $date->format('Y-m-d H:i:s');

$department_details  = array(

'department_name'     => $department_name,

'email_id'     	      => $email_id,

'department_lead'	  => $department_lead,

'parent_department'   => $parent_department,

'delete_status'      => 'ACTIVE',

'updated_at'         => $updated_at

);

$result = $this->yaskawa_model->update_department($department_id,$department_details);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>"Updated successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Failed to update. Try again"));

}

//Add New designation

public function add_new_designation()

{

$designation_name       = $this->input->post('designation_name');

$email_id             	= $this->input->post('email_id');

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$created_at = $date->format('Y-m-d H:i:s');

$designation_details  = array(

'designation_name'     => $designation_name,

'email_id'     	      => $email_id,

'delete_status'      => 'ACTIVE',

'created_at'         => $created_at

);

$result = $this->yaskawa_model->add_designation($designation_details);

if($result)

{

echo json_encode(array('result'=>1,'message'=>"Designation added successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Something went wrong.. try again"));

}

//designation list

public function designation_list()

{

$result   = $this->yaskawa_model->get_all_designation();

if($result)

{

echo json_encode(array('designation_list'=>$result,'result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//Delete department

public function delete_designation()

{

$designation_id    = $this->input->post('designation_id');

$data       = array('delete_status'=>'INACTIVE');

$result     = $this->yaskawa_model->delete_designation($designation_id,$data);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>'Deleted successfully'));

}

else

{

echo json_encode(array('result'=>0));

}

//Edit designation

public function edit_designation()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$designation_id      = $this->uri->segment(2);

$data['des_details'] = $this->yaskawa_model->edit_designation_details($designation_id);

$data['company_details']=$this->yaskawa_model->fetch_company_details();

$this->load->view('admin/edit_content_form',$data);

}

else

{

redirect('/');

}

//update department

public function update_designation()

{

$designation_name       = $this->input->post('designation_name');

$email_id             	= $this->input->post('email_id');

$designation_id         = $this->input->post('designation_id');

$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));

$updated_at = $date->format('Y-m-d H:i:s');

$designation_details  = array(

'designation_name'     => $designation_name,

'email_id'     	      => $email_id,

'delete_status'      => 'ACTIVE',

'updated_at'         => $updated_at

);

$result = $this->yaskawa_model->update_designation($designation_id,$designation_details);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1,'message'=>"Updated successfully"));

}

else

{

echo json_encode(array('result'=>0,'message'=>"Failed to update. Try again"));

}

//menu_list

public function menu_list()

{

$result   = $this->yaskawa_model->get_all_menu();

if($result)

{

echo json_encode(array('menu_list'=>$result,'result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//menu_details

public function menu_details()

{

$menu_id       = $this->input->post('id');

$alt_name       = $this->input->post('alt_name');

$menu_status       = array('status'=>'1');

$result   = $this->yaskawa_model->update_menu_status($menu_id,$menu_status);

if($this->db->affected_rows() > 0)

{

echo json_encode(array('result'=>1));

}

else

{

echo json_encode(array('result'=>0));

}

//single_lead_view

public function single_lead_view()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$lead_id      = $this->uri->segment(2);

$data['user_details']=$this->yaskawa_model->get_user_details();

//$data['lead_details1']    = $this->yaskawa_model->leads_track_owners();

$data['customer_type']=$this->yaskawa_model->get_customer_type();

$data['single_details'] = $this->yaskawa_model->single_lead_details($lead_id);

$data['pic_details']    = $this->yaskawa_model->get_pic_details($lead_id);

$data['lead_details']    = $this->yaskawa_model->get_event_call_details($lead_id);

$data['closed_details']    = $this->yaskawa_model->get_event_closed_details($lead_id);

$data['notes_details']    = $this->yaskawa_model->get_notes_details($lead_id);

$data['attachment_details']    = $this->yaskawa_model->get_attachment_details($lead_id);

$data['company_details']=$this->yaskawa_model->fetch_company_details();
		 
		  $this->load->view('admin/lead_information',$data);

}

else

{

redirect('/');

}

//lead_information view

public function closed_activity()

{

$admin_id = $this->session->userdata('admin_id');

if($admin_id)

{

$data['user_type_id'] = $this->access_id();

$data['access'] = $this->access_details();

$task_id      = $this->uri->segment(2);

$dat=array('delete_status'=>'Closed');

$this->yaskawa_model->update_status($task_id,$dat);

$det=$this->yaskawa_model->get_row($task_id);

$lead_id=$det->lead_id;