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

class Project extends CI_Controller {
	
	public function __construct()
	{
		parent::__construct();
		$this->load->model('Project_model'); 
		$this->load->model('Commonsql_model'); 
	
	}

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see https://codeigniter.com/user_guide/general/urls.html
	 */
	public function project_list()
	{
		if($this->session->userdata('id')==""){redirect('');}
		
		$data['pro']=$this->Project_model->list_pro();
		$this->load->view('project/project_list',$data);
	}
	public function viewProject($id)
	{
		if($this->session->userdata('id')==""){redirect('');}
		
		$data['viewProject']=$this->Project_model->viewProject($id);
		//echo $this->db->last_query();exit;
		$this->load->view('project/view_project',$data);
	}
	function add_project()
	{
		if($this->session->userdata('id')==""){redirect('');}
		$currentUser=$this->session->userdata('id');
		
		$data['dep']=$this->Project_model->get_dep();
		$data['stu']=$this->Project_model->get_stu();
		$data['sub']=$this->Project_model->get_sub();
		$data['semester']=$this->Project_model->get_semester();
		
		if($this->input->post('submit'))
		{
			
			$name=$this->input->post('projectName');
			$date=$this->input->post('date');
			//$pDate= implode("-", array_reverse(explode("-", $date)));
			$student=$this->input->post('student');
			$code=$this->input->post('code');
			$semesterId=$this->input->post('semesterId');
			$subject=$this->input->post('subject');
			$department=$this->input->post('department');
			$description=$this->input->post('description');
			$drivelink=$this->input->post('drivelink');
			$video=$this->input->post('vedio');
		
		
			if (!is_dir('uploads/project')) {
				mkdir('./uploads/project', 0777, TRUE);
			}
			
			
			if(file_exists($_FILES['titleImage']['tmp_name']))
			{
			$temp_user_img=$_FILES['titleImage']['tmp_name'];
			$user_img=str_replace(' ', '_', $_FILES["titleImage"]["name"]);
			$allowed =  array('png,jpeg,jpg');
			$extension1 = pathinfo($user_img, PATHINFO_EXTENSION);
			$user_img='title'.date('ymdhis').'.'.$extension1;
			$targetPath='./uploads/project/';
			$targetFile=$targetPath.$user_img;
			move_uploaded_file($temp_user_img, $targetFile);
			}
			
			$table="project";
			$values=array('projectName'=>$name,
			             'date'=>$date,
						 'studentId'=>$student,
						 'semesterId'=>$semesterId,
						 'departmentId'=>$department,
						 'subjectId'=>$subject,
						 'code'=>$code,
						 'image'=>$user_img,
						 'description'=>$description,
						 //'faculty'=>$faculty,
						 'drivelink'=>$drivelink,
						 'vedio'=>$video,
						 'createdOn'=>date('Y-m-d'),
						 'createdBy'=>$currentUser,
						 'status'=>1);
			$result=$this->Commonsql_model->insert_table($table,$values);
			
			$projectId=$this->db->insert_id();
			//Image table insert
			$title		 	= $this->input->post('title');	
			$muldescription	= $this->input->post('muldescription');	
			
			foreach($title as $key=>$value)
			{
				if($_FILES['profileimage']['tmp_name'])
				{
					if (!is_dir('uploads/project')) {
					mkdir('./uploads/project', 0777, TRUE);
					}
					$temp_vehicle_doc=$_FILES['profileimage']['tmp_name'][$key];
					$projectImage=str_replace(' ', '_', $_FILES["profileimage"]["name"][$key]);
					$extension1 = pathinfo($projectImage, PATHINFO_EXTENSION);
					$pImage=$projectId.'.'.$projectImage;
					$document='uploads/project/'.$pImage;
					 
					$targetPath = './uploads/project/'; 
					$targetFile=$targetPath.$pImage;
					
									
					if(move_uploaded_file($temp_vehicle_doc, $targetFile))
					{ 
						$tablename='projectdetail';
						$data=array('projectId'=>$projectId,
									'title'=>$title[$key],
									'description'=>$muldescription[$key],
									'image'=>$pImage,
									'status'=>1);
							
						$product=$this->Commonsql_model->insert_table($tablename,$data);
					//echo $this->db->last_query();

					}		 
				}		
			}
			//exit;	
			if($result)
			{
				$this->session->set_userdata('suc','successfully added');
				redirect('project');
			}
			else
			{
				$this->session->set_userdata('err','Please try again');
				redirect('project');
			}
		}
		$this->load->view('project/add_project',$data);
	}
	
	
	function editProject($id)
	{	
		if($this->session->userdata('id')==""){redirect('');}
		$currentUser=$this->session->userdata('id');
		
		$data['dep']=$this->Project_model->get_dep();
		$data['stu']=$this->Project_model->get_stu();
		$data['sub']=$this->Project_model->get_sub();
		$data['semester']=$this->Project_model->get_semester();
		
	    $data['pro']=$this->Project_model->get_pro($id);
       
		$data['getMultipleImage']=$this->Project_model->getMultipleImage($id);
		
		if($this->input->post('submit'))
		{
			$date=$this->input->post('date');
			$projectName=$this->input->post('projectName');
			$code=$this->input->post('code');
			$studentId=$this->input->post('student');
			$semesterId=$this->input->post('semesterId');
			$subjectId=$this->input->post('subjectId');
			$departmentId=$this->input->post('departmentId');
			$titleImage=$this->input->post('titleImage');
			$oldImage=$this->input->post('oldImage');
			$description=$this->input->post('description');
			$drivelink=$this->input->post('drivelink');
			$video=$this->input->post('video');
			
			if($titleImage=="" ){$newImage=$oldImage;}
			if(file_exists($_FILES['titleImage']['tmp_name']))
			{
			$temp_user_img=$_FILES['titleImage']['tmp_name'];
			$newImage=str_replace(' ', '_', $_FILES["titleImage"]["name"]);
			$allowed =  array('png,jpeg,jpg');
			$extension1 = pathinfo($newImage, PATHINFO_EXTENSION);
			$newImage='title'.date('ymdhis').'.'.$extension1;
			$targetPath='./uploads/project/';
			$targetFile=$targetPath.$newImage;
			move_uploaded_file($temp_user_img, $targetFile);
			}
			
			$table="project";
			$where=array("id"=>$id);
			$values=array('projectName'=>$projectName,
			             'date'=>$date,
			             'code'=>$code,
						 'studentId'=>$studentId,
						 'semesterId'=>$semesterId,
						 'subjectId'=>$subjectId,
						 'departmentId'=>$departmentId,
						 'image'=>$newImage,
						 'description'=>$description,
						 'drivelink'=>$drivelink,
						 'vedio'=>$video,
						 'updatedOn'=>date('Y-m-d'),
						 'updatedBy'=>$currentUser);
						 
			$result=$this->Commonsql_model->updateTable($table,$where,$values);
			
			//Image Multiple
			$title = $this->input->post('title');	
			$muldescription = $this->input->post('muldescription');	
			$profileimage = $this->input->post('profileimage');	
			$projectDetailId = $this->input->post('projectDetailName');	
			$oldImage = $this->input->post('profileimageOld');	
			//print_r ($muldescription);exit;
			
			//Update old datas
			foreach($title as $key=>$value)
			{
				
				if($projectDetailId[$key]!="")
				{
					
				if($_FILES['profileimage']['name'][$key])
				{
				$temp_file=$_FILES['profileimage']['tmp_name'][$key];
				$business_doc=str_replace(' ', '_', $_FILES["profileimage"]["name"][$key]);
				$extension1 = pathinfo($business_doc, PATHINFO_EXTENSION);
				$newImage=$id.'.'.$business_doc;
				$document='uploads/project/'.$newImage;
				 
				$targetPath = './uploads/project/'; 
				$targetFile=$targetPath.$newImage;
				
								
				if(move_uploaded_file($temp_file, $targetFile))
				{ }
				}
				else{ 
				$newImage=$oldImage[$key]; 
				}
				$tablename='projectdetail';
				$data=array('title'=>$title[$key],
							'description'=>$muldescription[$key],
							'image'=>$newImage);
				$where=array('id'=>$projectDetailId[$key]);
				$result=$this->Commonsql_model->updateTable($tablename,$where,$data);
				//echo $this->db->last_query();
					
				}
				
				//Remove Existing One  
				$existingRow=$this->Project_model->getMultipleImage($id);
				//echo $this->db->last_query();
				if($existingRow->num_rows()>0)
				{
					//echo "test";exit;
					$primaryId=array();
					foreach($existingRow->result() as $list)
					{
						$primaryId[]=$list->id ;
					}
				}
				//Remove Row
				$diff=array_diff($primaryId,$projectDetailId);
				//print_r ($diff);exit;
				if($diff>0)
				{
					//echo "sdsds";exit;
					foreach($diff as $value)
					{
						$where=array('id'=>$value); 
						$tablename="projectdetail"; 
						$values=array('status'=>0);
						if($projectDetailId[$key]!=""){
						$result=$this->Commonsql_model->updateTable($tablename,$where,$values);}
						//echo $this->db->last_query();
					}
				}
				//New Row Insertion
				if($projectDetailId[$key]=="")
				{
					
				if($_FILES['profileimage']['tmp_name'])
				{
					$tempDocument=$_FILES['profileimage']['tmp_name'][$key];
					$getImage=str_replace(' ', '_', $_FILES["profileimage"]["name"][$key]);
					$extension1 = pathinfo($getImage, PATHINFO_EXTENSION);
					$image=$id.'.'.$getImage;
					//$document='uploads/subject/'.$business_document;
					$targetPath = './uploads/project/'; 
					$targetFile=$targetPath.$image;
					
									
					if(move_uploaded_file($tempDocument, $targetFile))
					{ 
						$tablename='projectdetail';
						$data=array('projectId'=>$id,
							'title'=>$title[$key],
							'description'=>$muldescription[$key],
							'image'=>$image,
							'status'=>1);
							
				$result=$this->Commonsql_model->insert_table($tablename,$data);
					}		 
				}
				  
				}
			}
			
			if($result)
			{
				$this->session->set_userdata('suc','successfully Updated');
				redirect('project');
				
			}
			else
			{
				$this->session->set_userdata('err','Please try again');
				redirect('project');
			}
			
		}
		$this->load->view('project/edit_project',$data);
	}
	
	function deleteProject()
	{
		if($this->session->userdata('id')==""){redirect('');}
		$currentUser=$this->session->userdata('id');
		
		if($this->input->post('submit'))
		{
			$projectId=$this->input->post('projectId');
			
			$table="project";
			$where=array("id"=>$projectId);
			$values=array('status'=>0,'updatedOn'=>date('Y-m-d'),'updatedBy'=>$currentUser);
			$result=$this->Commonsql_model->updateTable($table,$where,$values);
			
			$dTable="projectdetail";
			$dWhere=array("projectId"=>$projectId);
			$dValue=array('status'=>0);
			
			$result=$this->Commonsql_model->updateTable($table,$where,$values);
			
			$dResult=$this->Commonsql_model->updateTable($dTable,$dWhere,$dValue);
			//echo $this->db->last_query();exit;
			if($result && $dResult)
			{
				$this->session->set_userdata('suc','successfully deleted');
				redirect('project');
				
			}
			else
			{
				$this->session->set_userdata('err','Please try again');
				redirect('project');
			}
		}	
	}
	
	
	
}