/application/controllers/project.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Project extends CI_Controller {
	
	function __construct(){
		parent::__construct();
		$this->load->database();
		$this->load->helper(array('url', 'captcha', 'download'));
		$this->load->library(array('form_validation', 'Themelib', 'Captchalib', 'pagination'));
		checkAuth(); // Check Authentikasi User
	}
	
	function testpage(){
		$config= $this->config;
		$data= array();
		$data['title']= "Testing Page";
		$data['jscript']= "";
		
		/*$this->load->view('test', $data);*/
		$this->themelib->getpage("test", $data, "inc/theme_main");
	}
	public function server_var(){
		/*echo urlencode("~!@#$%^&*()_+-:");*/
		echo urlencode("Aplikasi CMS | CMS");
/*		foreach( $_SERVER as $key=>$value ){
			echo $key . "->" . $value . "<br/>";
		}*/
/*		echo "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] . "<br/>";
		echo site_url();*/
	}
	
	function newpage(){
		echo "abc";
	}
	
	// Setting PO ID format
	public function setting_po_id($process=""){		
		if( empty($process) ){
			$config= $this->config;
			$data= array();
			$data['poid']= $this->db->limit('1')->get('poid_format')->row_array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= $this->load->view('js/po_id', $data, true);
			$this->themelib->getpage("project/po_id", $data, "inc/theme_main");
		}else{
			$POST= $this->input->post();
			
			// Set Rules Validasi
			$config= array(
						array(
							'field'=> 'Prefix',
							'label'=> 'Prefix',
							'rules'=> 'required'
						),
						array(
							'field'=> 'Digit',
							'label'=> 'Digit Number',
							'rules'=> 'required|integer'
						)
					);
			$this->form_validation->set_rules($config);
			
			if( $this->form_validation->run() == TRUE ){ // Cek Validasi
				if( isset($POST['submit']) || $POST['type'] == "ajax" ){
					extract($POST);
					
					// Get PO_ID Format
					$poid_format= $this->db->get_where('poid_format')->row_array();
					
					// Remove Data pada Tabel poid_format					
					$this->db->truncate('poid_format');
					
					// Insert Data
					unset($POST['submit'], $POST['type']);
					if( $this->Jmodel->insert('poid_format', $POST) ){
						// Get PO_ID Data
						$poid_dt= $this->db->get('po_id')->result_array();
						foreach( $poid_dt as $key=>$value ){
							$jml= strlen($poid_format['Prefix']);
							$poid_val= substr($value['PO_ID'], $jml);
							$poid_val= $POST['Prefix'] . sprintf('%0' . $POST['Digit'] . 's', $poid_val+1);
							/*echo $poid_val . "<br/>";*/
							
							// Update PO_ID
							$update_poid= array('PO_ID'=>$poid_val);
							$where= array('Project_ID'=>$value['Project_ID']);
							$this->Jmodel->update('po_id', $update_poid, $where);
						}
						/*exit;*/
						$feedback= array('type'=>'success', 'response'=>'PO ID has been set.');
						$feedback= json_encode($feedback);
						if( $type == "ajax" ){
							echo $feedback;
							exit;
						}else{
							$this->session->set_userdata('feedback', $feedback);
							redirect("project/setting_po_id");
						}
					}
				}
			}else{
				$config= $this->config;
				$data= array();
				$data['poid']= $this->db->limit('1')->get('poid_format')->row_array();
				$data['bar_path']= $config->item('loading');
				$data['main_url']= base_url();
				$data['jscript']= $this->load->view('js/po_id', $data, true);
				$this->themelib->getpage("project/po_id", $data, "inc/theme_main");
			}
		}
	}
	
	// MD5 Function
	public function md5(){
		echo md5("sales");
		exit;
		echo 'administrator' . date("Y-m-d H:i:s") . "->" . md5('administrator' . date("Y-m-d H:i:s")) . "<br/>";
		echo 'administrator2' . date("Y-m-d H:i:s") . "->" . md5('administrator2' . date("Y-m-d H:i:s"));
	}

	// Struktur Organisasi
	public function structure($process=""){
		$config= $this->config;
		$js_path= $config->item('js_path');
				
		// Create Structure List Using jwMenu Class
		$data= $this->db->get('structure')->result_array();
		$this->jwmenu->baseUrl= base_url();
		$this->jwmenu->setStyle("org", "");
		$this->jwmenu->setClassLink("structure-link");
		/*$this->jwmenu->setIcon();*/
		$structure= $this->jwmenu->create_tree($data);
		
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= '';
		$data['css_files']= array($js_path . "/jOrgChart/css/jquery.jOrgChart.css");
		$data['js_files']= array($js_path . "/jOrgChart/js/jquery.jOrgChart.js");
		$data['structure']= $structure;
		$this->themelib->getpage("structure", $data, "inc/theme_main");
	}
	
	// Change Password User
	public function change_password($process=""){
		if( $process == "process" ){
			$POST= $this->input->post();
/*			echo "<pre>";
			print_r($POST);
			echo "</pre>";*/
			
			// Set Rules Validasi
			$config= array(
						array(
							'field'=> 'OldPassword',
							'label'=> 'Old Password',
							'rules'=> 'required'
						),
						array(
							'field'=> 'NewPassword',
							'label'=> 'New Password',
							'rules'=> 'required'
						),
						array(
							'field'=> 'PasswordConf',
							'label'=> 'Password Confirmation',
							'rules'=> 'required'
						)						
					);
			$this->form_validation->set_rules($config);
			
			if( $this->form_validation->run() == TRUE ){ // Cek Validasi
				if( isset($POST['submit']) || $POST['type'] == "ajax" ){
					extract($POST);
					
					// Cek Old Password sesuai
					$Username= $this->session->userdata('Username');
					$where= array('Password'=>md5($OldPassword), 'Username'=>$Username);
					$jml= $this->db->get_where('user', $where)->num_rows();
/*					echo $this->db->last_query();
					exit;*/
					if( ! $jml ){
						$feedback= array('type'=>'error', 'response'=>'Old Password tidak sesuai !');
						$feedback= json_encode($feedback);
						if( $type == "ajax" ){
							echo $feedback;
							exit;
						}else{
							$this->session->set_userdata('feedback', $feedback);
							redirect("change_password");
						}
					}
					
					// Change Password
					$where= array('Username'=>$Username);
					$data= array('Password'=>md5($NewPassword));
					if( $this->Jmodel->update('user', $data, $where) ){
						$feedback= array('type'=>'success', 'response'=>'Password has been changed !');
						$feedback= json_encode($feedback);
						if( $type == "ajax" ){
							echo $feedback;
							exit;
						}else{
							$this->session->set_userdata('feedback', $feedback);
							redirect("change_password");
						}
					}
				}
			}else{
				$config= $this->config;
				$data= array();
				$data['bar_path']= $config->item('loading');
				$data['main_url']= base_url();
				$data['jscript']= $this->load->view('js/change_password', $data, TRUE);
				$this->themelib->getpage("user/change_password", $data, "inc/theme_main");
			}
		}else{
			$config= $this->config;
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= $this->load->view('js/change_password', $data, TRUE);
			$this->themelib->getpage("user/change_password", $data, "inc/theme_main");
		}
	}
	
	// Dashboard Page
	public function dashboard(){
		$config= $this->config;
		
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= "";
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$this->themelib->getpage("", $data, "inc/theme_new");
	}
	
	public function new_menu(){
		$config= $this->config;
		
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= "";
		/*$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);*/
		$this->themelib->getpage("testing", $data, "inc/theme_new");
		/*$this->themelib->getpage("testing", $data, "inc/theme_main");*/
	}
		
	// Dashboard Page
/*	public function sticky_test(){
		$config= $this->config;
		
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= "";
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);		
		$this->themelib->getpage("sticky_test", $data, "inc/theme_main");
	}*/
	
	// Notify ToDo ( User Login ) setiap 5 menit
	public function notify_todo(){
		$Username= $this->session->userdata('Username');
		$today= date("Y-m-d H:i:s");
		$cur_date= explode(" ", $today);
		$date= explode("-", $cur_date[0]);;
		$time= explode(":", $cur_date[1]);
		
		list($year, $month, $day)= $date;
		list($hour, $minute, $second)= $time;
		$last_time= date("Y-m-d H:i:s", mktime($hour, $minute-5, 0, $month, $day, $year));
		$now_time= date("Y-m-d H:i:s", mktime($hour, $minute, 0, $month, $day, $year));
		
		$sql= "SELECT * FROM todo 
			WHERE DueDate BETWEEN '" . $last_time . "' AND '" . $now_time. 
			"' AND Username='" . $Username . "' AND Status != 'yes'";
		$todo= array();
		$todo= $this->db->query($sql)->row_array();
/*		echo "<pre>";
		echo $sql;
		echo "</pre>";
		exit;*/
		if( count($todo) ){
			$notifyId= $todo['Id'];
			$notify_dt= '<p><a href="' . site_url() . 'project/detail/' . $todo['IdProject'] . '">' . $todo['Task'] . 
			'</a></p>';
			$notify= array(
			'Id'=>$notifyId,
			'Element'=>$notify_dt
			);
			echo json_encode($notify);
		}
		exit;
	}
	
	// Process Untuk Set Status Complete or Not
	public function process_todo(){
		$POST= $this->input->post();
		
		$where= array('Id'=>$POST['Id']);
		unset($POST['Id']);
		if( $this->Jmodel->update('todo', $POST, $where) ){
			echo "success";
		}
	}
	
	// PopUp for Todo pada Halaman Project Detail ( Add, Edit )
	// Serta Processing u/ Delete ToDo
	public function todo($IdProject="", $action="", $IdTodo= ""){
		$config= $this->config;
		if( $action == "edit" )	{ // PopUp Edit ToDo
			$where= array('Id'=>$IdTodo);
			$todo= $this->db->get_where('todo', $where)->row_array();
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= "";
			$data['IdProject']= $IdProject;
			$data['hrefElement']= site_url() . $this->uri->uri_string();
			$data['todo']= $todo;
			$html= $this->load->view('todo/edit', $data, TRUE);
			echo $html;
			exit;		
		}elseif( $action == "delete" ){ // Delete ToDo
			$where= array("Id"=>$IdTodo);
			if( $this->db->delete('todo', $where) ){
				echo "success";
				exit;
			}
		}else{ // PopUp Add ToDo
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= "";
			$data['IdProject']= $IdProject;
			$html= $this->load->view('todo/todo', $data, TRUE);
			echo $html;
			exit;
		}
	}
	
	// Display All ToDos dari Login User
	public function todo_list(){
		$Username= $this->session->userdata('Username');
		
		$todos= array();
		$sql= "SELECT a.*, b.Project_Name FROM todo a 
		LEFT JOIN project b ON b.Project_ID= a.IdProject 
		WHERE a.Username= '" . $Username . "' AND a.Status= 'no' 
		ORDER BY a.DueDate DESC";
		$todos= $this->db->query($sql)->result_array();
		
		$today= date("d-m-Y");
		$today= explode("-", $today);
		list($day, $month, $year)= $today;
		$today= mktime(0, 0, 0, $month, $day, $year);
		$tomorrow= mktime(0, 0, 0, $month, $day+1, $year);
		
		// Grouping ToDos ( Late, Today, Upcoming)
		$late_todos= array();
		$today_todos= array();
		$upcoming_todos= array();
		foreach( $todos as $todo ){
			$DueDate= strtotime($todo['DueDate']);			
			if( $DueDate < $today  ){
				$late_todos[]= $todo;
			}elseif( $DueDate >= $tomorrow ){
				$upcoming_todos[]= $todo;
			}else{
				$today_todos[]= $todo;
			}
		}		
		$todos['late']= $late_todos;
		$todos['today']= $today_todos;
		$todos['upcoming']= $upcoming_todos;
		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= $this->load->view('js/todo_list', $data, TRUE);
		$data['todos']= $todos;
		$this->themelib->getpage("todo/todo_list", $data, "inc/theme_main");
	}
	
	// Processing Save, Edit and Delete Todo Data Into Database 
	public function todo_save($action=""){
		$POST= $this->input->post();
		// Set Data for inserting to DBase
		$POST['Username']= $this->session->userdata('Username');
		$POST['DueDate'].= " " . $POST['Hour'] . ":" . $POST['Minutes'] . " " . $POST['IdTime'];
		$POST['DueDate']= date("Y-m-d H:i:s", strtotime($POST['DueDate']));		
		unset($POST['Hour'], $POST['Minutes'], $POST['IdTime'], $POST['submit']);		
					
		if( $action == "edit" ){ // Edit ToDo
			$POST['ModifyDate']= date("Y-m-d H:i:s");
			$IdTodo= $POST['Id'];
			$IdProject= $POST['IdProject'];
			unset($POST['Id'], $POST['IdProject']);
			$where= array('Id'=>$IdTodo);
			if( $this->Jmodel->update('todo', $POST, $where) ){
				$element= $this->getElementTodo($IdTodo, $IdProject);
				$html= array(
				'type'=>'success',
				'html'=>$element
				);
				echo json_encode($html);				
			}
		}else{ // Save ToDo
			$POST['AddDate']= date("Y-m-d H:i:s");
			$insertId= $this->Jmodel->insert('todo', $POST, TRUE);
			if( $insertId ){
				$element= $this->getElementTodo($insertId, $POST['IdProject']);
				$html= array(
				'type'=>'success',
				'html'=>$element
				);
				echo json_encode($html);
			}
		}
	}
	
	// Get Element HTML dari Todo berdasarkan IdTodo
	public function getElementTodo($idTodo="", $IdProject=""){
		$where= array('Id'=>$idTodo);
		$todo= $this->db->get_where('todo', $where)->row_array();
		$extraAttr= array();
		$labelClass= "";
		if( $todo['Status'] == "yes" ){
			$extraAttr['checked']= 'checked';
			$labelClass= " complete-todos";
		}
		$attr_checkbox= array(
			'name'=>'todo'.$todo['Id'],
			'value'=>$todo['Id'],
			'class'=>'todos'
		);
		$attr_checkbox= array_merge($attr_checkbox, $extraAttr);
		$html= '
		<div class="todos-row">
			<span class="btnactions">
				<a class="btn todos-btn todos-edit" href="' . site_url("project/todo") . "/" . $IdProject . 
				'/edit/' . $idTodo . '">
					<i class="icon-pencil"></i>
				</a>
				<a class="btn todos-btn todos-delete" href="' . site_url("project/todo") . "/" . $IdProject . 
				'/delete/' . $idTodo . '">
					<i class="icon-trash"></i>
				</a>
			</span>
			<label class="checkbox checkbox-tags' . $labelClass . '">' . 
			form_checkbox($attr_checkbox) . 
			'<span>' . $todo['Task'] . '</span>
			<span class="label label-warning">' . date("l, d F Y h:i A", strtotime($todo['DueDate'])) . '</span>' . 
			'</label>' . 
		'</div>';
		
		return $html;
	}
	
	// Show Employee Detail
	public function employee_detail($Username=""){
		$Username= urldecode($Username);
		// Get Data User Detail
		$sql= "SELECT * FROM user a 
			LEFT JOIN user_detail b ON b.Id= a.IdDetail 
			WHERE a.Username= '" . $Username . "'";
		$user= $this->db->query($sql)->row_array();
		
		// Table Description
		$description_user= array('Name'=>'Name', 'Address'=>'Address', 
		'Gender'=>'Jenis Kelamin', 'DateOfBirth'=>'Tanggal Lahir', 'Contacts'=>'Kontak');
		
		foreach( $description_user as $key=>$value ){
			$userdt= ( empty($user[$key]) ) ? "-" : $user[$key];
			$user[$key]= $userdt;
		}
		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['jscript']= $this->load->view('js/profile', $data, TRUE);
		$data['img_path']= $config->item('img_path');
		$data['description_user']= $description_user;
		$data['user']= $user;
		$this->themelib->getpage("user/profile", $data, "inc/theme_main");
	}
	
	// Show List of Employees
	public function employees($nopage="", $sorting=""){
		$POST= $this->input->post();
		$url= explode("&", $sorting);
		
		// Parsing Url Sorting dan Filter ( Jika Sorting dan Filter dimasukan pada URL setelah submit ditekan )
		// Set Filter Searching
		$filter_params= $this->themelib->get_filter_params($url, $POST);
		extract($filter_params); // Variable Extact( sorting, filter_str, filter )
		
		// Set Default / Sorting
		$sorting= ( empty($sorting) ) ? "a.Username=ASC" : urldecode($sorting);
		$sort= explode("=", $sorting);
		
		// Get Seluruh Data Employees
		$employees= $this->Jmodel->getEmployees("", "", $sort, $filter);
		$jml= count($employees);
		
		$nopage= ( empty($nopage) ) ? 1 : $nopage;
		$numpage= $nopage;
		$nopage= (int)$nopage-1;
		$perpage= 12;
		$offset= $nopage * $perpage; // Nilai Offset u/ Query
		$jml_page= ceil($jml / $perpage); // Jumlah Halaman
		
		// Jika Halaman lebih dari Jumlah Halaman atau Negative Page
		// dan tidak Ada $POST Searching
		if( ( $numpage > $jml_page || $numpage < 1 ) && empty($POST) ){
			redirect("employees/1"); // Redirect ke First Page
		}
		
		// Pagination Config
		$config['base_url'] = site_url() . 'employees';
		$config['suffix']= "/" . urlencode($sorting) . "&" . $filter_str;
		$config['total_rows'] = $jml;
		$config['per_page'] = $perpage;
		$config['use_page_numbers'] = FALSE;
		$config['uri_segment']= 2; // Pengenal URI Active Page
		$config['first_url']= 1;
		$this->pagination->initialize($config);
		
		// Jika User Melakukan Searching tidak dari Halaman 1
		if( ! empty($POST) && ! empty($nopage) ){
			redirect('employees/1/' . urlencode($sorting) . "&" . $filter_str);
		}
		
		// Get Data Project from DB sesuai dengan current Page 
		$employees= $this->Jmodel->getEmployees($perpage, $offset, $sort, $filter);
		$description= array("Name", "Description");
		
		// Fields for Searching Filter
		$fields= array(
			'a.Username'=>'Username',
			'b.Name'=>'Name',
			'c.Description'=>'Usertype'
		);
		
		$operator= $this->themelib->operator_search; // Get Operator Searching
		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['jscript']= $this->load->view('js/filter', $data, TRUE);
		$data['img_path']= $config->item('img_path');
		$data['employees']= $employees;
		$data['description']= $description;
		$data['searching_fields']= $fields;
		$data['operator']= $operator;
		$data['pagination']= $this->pagination->create_links();
		$this->themelib->getpage("employees", $data, "inc/theme_main");
	}
	
	// Halaman Edit Profile Detail
	public function edit_profile($Username=""){
		if( ! empty($Username) ){
			$Username= urldecode($Username);
		}else{
			$Username= $this->session->userdata('Username');
		}
		$Id= $this->session->userdata('Id');
		
		// Get Data User Detail
		$sql= "SELECT * FROM user a 
			LEFT JOIN user_detail b ON b.Id= a.Id 
			WHERE a.Username= '" . $Username . "'";
		$user= $this->db->query($sql)->row_array();
		
		// Table Description
		$labels= array('Name'=>'Nama', 'Address'=>'Alamat', 'Gender'=>'Jenis Kelamin', 
		'DateOfBirth'=>'Tanggal Lahir', 'Contacts'=>'Kontak', 'Image'=>'Gambar');
		
		$feedback= "";
		if( empty($user) ){
			$feedback= "User " . $Username . " tidak ada.";
		}
		
/*		echo "<pre>";
		print_r($user);
		echo "</pre>";
		exit;*/
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['jscript']= "";
		$data['img_path']= $config->item('img_path');
		$data['user']= $user;
		$data['labels']= $labels;
		$data['feedback']= $feedback;
		$data['userId']= $Id;
		echo $this->load->view("user/edit_profile", $data, TRUE);
		/*$this->themelib->getpage("user/edit_profile", $data, "inc/theme_main");*/
	}	
	
	// Halaman View Profile Detail
	public function profile($type=""){
		if( empty($type) ){
			$Username= $this->session->userdata('Username');
			
			// Get Data User Detail
			$sql= "SELECT * FROM user a 
				LEFT JOIN user_detail b ON b.Id= a.Id 
				WHERE a.Username= '" . $Username . "'";
			$user= $this->db->query($sql)->row_array();
			
			// Table Description
			$description_user= array('Name'=>'Name', 'Address'=>'Address', 
			'Gender'=>'Jenis Kelamin', 'DateOfBirth'=>'Tanggal Lahir', 'Contacts'=>'Kontak');
			
			foreach( $description_user as $key=>$value ){
				$userdt= ( empty($user[$key]) ) ? "-" : $user[$key];
				$user[$key]= $userdt;
			}
/*			echo "<pre>";
			print_r($user);
			echo "</pre>";
			exit;*/
			
			$config= $this->config;
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['jscript']= $this->load->view('js/profile', $data, TRUE);
			$data['img_path']= $config->item('img_path');
			$data['description_user']= $description_user;
			$data['user']= $user;
			$this->themelib->getpage("user/profile", $data, "inc/theme_main");
		}else{
			$POST= $this->input->post();
			
/*			print_r($POST);
			print_r($_FILES);
			exit;*/
			foreach( $_FILES as $key=>$value ){
				$$key= $value;
			}
			
			$act_image= FALSE;
			if( !empty($Image['name']) ){				
				// File Image tidak boleh lebih dari 2MB
				$maxsize= 2000000;
				if( $Image['size'] > $maxsize ){
					echo "File tidak boleh lebih dari 2MB !";
					exit;
				}
				
				// Cek Extension
				$image_ext= pathinfo($Image['name'], PATHINFO_EXTENSION);
				$reg_image= "#^(jpeg|jpg|png)$#";
				if( ! preg_match($reg_image, $image_ext) ){
					echo "File harus gambar ( jpeg|jpg|png ) !";
					exit;
				}
							
				$Username= $this->session->userdata('Username');
				$filename= $Username . "_avatar." . $image_ext;
				$tmp_file= $Image['tmp_name'];
				$fullpath= $this->config->item('assets_img') . "user/" . $filename;
				
				if( move_uploaded_file($tmp_file, $fullpath) ){
					$config['image_library'] = 'gd2';
					$config['source_image'] = $fullpath;
					$config['create_thumb'] = FALSE;
					$config['maintain_ratio'] = FALSE;
					$config['width'] = 200;
					$config['height'] = 200;
					$this->load->library('image_lib', $config);
					
					// Resize Image
					if( ! $this->image_lib->resize() ){
						echo "Resize File tidak berhasil. Silakan Coba Lagi !";
						exit;
					}else{
						$act_image= TRUE;
					}
				}else{
					echo "Error terjadi, Silakan coba lagi !";
					exit;
				}
			}
			
			if( $act_image ){
				$POST['Image']= $filename;
			}
			/*$POST['Id']= '10';*/
			$POST['DateOfBirth']= ( empty($POST['DateOfBirth']) ) ? "" : date('Y-m-d', strtotime($POST['DateOfBirth']));
			/*$POST['DateOfBirth']= date('Y-m-d', strtotime($POST['DateOfBirth']));*/
/*			echo $POST['DateOfBirth'];
			exit;*/
			
/*			print_r($POST);
			exit;*/
			$sql= "SELECT * FROM user a 
			INNER JOIN user_detail b ON b.Id= a.Id 
			WHERE a.Id= '" . $POST['Id'] . "'";
			$row= $this->db->query($sql)->row_array();
			
			if( empty($row) ){
				// Insert Data to user_detail
				$ins_detail= $POST;
				unset($ins_detail['Username']);
				$this->Jmodel->insert('user_detail', $ins_detail);
				
/*				$ins_user= array('IdDetail'=>$insert_id);
				$where= array('Id'=>$POST['Id']);
				$this->Jmodel->update('user', $ins_user, $where);*/
			}else{
/*				print_r($upd_detail);
				exit;			*/
				// Update Data user_detail
				$upd_detail= $POST;
				unset($upd_detail['Id']);
				$where= array('Id'=>$POST['Id']);
				$this->Jmodel->update('user_detail', $upd_detail, $where);
			}
			echo "success";
			exit;
		}
	}
	
	// Remove Tag / Untag
	public function untag(){
		$POST= $this->input->post();
		
		// Cek Apa Tag tsb di-tag pada Project
		$where= array('Project_ID'=>$POST['IdProject']);
		$sql= "SELECT * FROM project 
			WHERE Project_ID='" . $POST['IdProject'] . "'  AND IdTag LIKE '%" . $POST['IdTag'] . "%'";
		$query= $this->db->query($sql);
		$row= $query->row_array();
		
		// Remove Tag
		$IdTag= array();
		$IdTag= $row['IdTag'];
		$IdTag= array_flip(explode(",", $IdTag));
		unset($IdTag[$POST['IdTag']]);
		$IdTag= array_flip($IdTag);
		
		// Update DBase
		$data= array('IdTag'=>implode(",",$IdTag));
		if( $this->Jmodel->update('project', $data, $where) ){
			echo "success";
			exit;
		};
/*		echo "<pre>";
		print_r($IdTag);
		echo "</pre>";
		exit;		*/
	}
	
	// Add Tag to Project
	public function tag(){
		$POST= $this->input->post();
		// Get Data IdTag Field Sebelumnya
		/*$POST['IdProject']= '46';*/
		$where= array('Project_ID'=>$POST['IdProject']);
		$sql= "SELECT * FROM project 
			WHERE Project_ID='" . $POST['IdProject'] . "'  AND IdTag NOT LIKE '%" . $POST['IdTag'] . "%'";
		$query= $this->db->query($sql);
		$row= $query->row_array();
		
		// Jika tidak kosong tambahkan dengan data sebelumnya		
		if( ! empty($row['IdTag']) ){
			$POST['IdTag']= $row['IdTag'] . "," . $POST['IdTag'];
		}
		
		// Update
		unset($POST['IdProject']);
		if( $this->Jmodel->update('project', $POST, $where) ){
			echo "success";
			exit;
		}
		
/*		echo "<pre>";
		print_r($POST);
		echo "</pre>";
		exit;*/		
	}
		
	// View Untuk Add New Tag ( ColorPicker )
	public function addtag(){
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$html= $this->load->view("tag/create", $data, TRUE);
		echo $html;
		/*$this->themelib->getpage("tag/create", $data, "inc/theme_main");*/
	}
	
	// Get Current Tag yang baru di-create
	public function get_tag(){
		$POST= $this->input->post();
		$POST['tagName']= strtoupper($POST['tagName']);
		
		// Get Current Tag yang baru di-create
		$where= array('tagName'=>$POST['tagName']);
		$tag= $this->db->get_where('tag', $where)->row_array();
		
		// Create Group Checkbox Tag
		$attr_checkbox= array(
			'name'=>$tag['tagName'].'[name]',
			'value'=>$tag['tagName'],
			'class'=>'tags'
		);
		$prev_tags= '<label class="checkbox">';
		$prev_tags.= form_checkbox($attr_checkbox);
		$prev_tags.= form_hidden($tag['tagName'].'[color]', $tag['tagColor']);
		$prev_tags.= $tag['tagName'];
		$prev_tags.= '</label>';
		echo $prev_tags;
/*		$tags= $this->db->get("tag")->result_array();
		$prev_tags= "";
		foreach( $tags as $tag ){
			$prev_tags.= '<label class="checkbox">' . 
			'<input type="checkbox" name="tagName" value="' . $tag['tagName'] . '">' . $tag['tagName'] . 
			'</label>';
		}*/
		/*echo json_encode($tags);*/
	}
	
	// Save / Process to Database
	public function savetag(){
		$POST= $this->input->post();
		$POST['tagName']= strtoupper($POST['tagName']);
/*		echo "<pre>";
		print_r($POST);
		echo "</pre>";
		exit;*/
		
		// Check Apakah Tag Name sudah digunakan
		$where= array('tagName'=>$POST['tagName']);
		if( $this->db->get_where('tag', $where)->num_rows() ){
			echo "Tag dengan nama tersebut sudah ada.";
			exit;
		}
		
		// Insert to Database				
		if( $this->Jmodel->insert('tag', $POST) ){
			echo "success";
			exit;
		}
	}
	
	// Add New Tag ( ColorPicker )
	public function colorPicker(){
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$this->themelib->getpage("test", $data, "inc/theme_main");
	}
	
	// Get List Of Template	
	public function template_all($param="page", $nopage="", $sorting=""){
		$POST= $this->input->post();
		$url= explode("&", $sorting);
		
		// Parsing Url Sorting dan Filter ( Jika Sorting dan Filter dimasukan pada URL setelah submit ditekan )				
		// Set Filter Searching
		$filter_params= $this->themelib->get_filter_params($url, $POST);
		extract($filter_params); // Variable Extact( sorting, filter_str, filter )
		
		// Set Default / Sorting
		$sorting= ( empty($sorting) ) ? "Name=ASC" : urldecode($sorting);
		$sort= explode("=", $sorting);
		
		// Get Jumlah Project List
		$jml= $this->Jmodel->getData("project_template", "", "", $sort, $filter, true);
				
		// Process Per-page dan Offset
		$nopage= ( empty($nopage) ) ? 1 : $nopage;
		$numpage= $nopage;
		$nopage= (int)$nopage-1;
		$perpage= 5;
		$offset= $nopage * $perpage; // Nilai Offset u/ Query
		$jml_page= ceil($jml / $perpage); // Jumlah Halaman
		
		// Jika Halaman lebih dari Jumlah Halaman atau Negative Page
		// dan tidak Ada $POST Searching 
		if( ( $numpage > $jml_page || $numpage < 1 ) && empty($POST) ){
			redirect("project/template_all");
		}
		
		// Pagination Config
		$config['base_url'] = base_url() . 'project/template_all/page';
		$config['suffix']= "/" . urlencode($sorting) . "&" . $filter_str;
		$config['total_rows'] = $jml;
		$config['per_page'] = $perpage;
		$config['use_page_numbers'] = FALSE;
		$config['uri_segment']= 4; // Pengenal URI Active Page
		$config['first_url']= 1;
		$this->pagination->initialize($config);
		
		// Jika User Melakukan Searching tidak dari Halaman 1
		if( ! empty($POST) && !empty($nopage) ){
			redirect('project/template_all/page/1/' . urlencode($sorting) . "&" . $filter_str);
		}
				
		// Get Data Project from DB sesuai dengan current Page
		$rows= $this->Jmodel->getData("project_template", $perpage, $offset, $sort, $filter);
		$list= array();
		if( ! empty($rows) ){						
			// Get IdTemplate Untuk SQL Condition
			$data_in= array();
			foreach( $rows as $row ){
				$data_in[]= $row['Id'];
			}
			$IdTemplate= "'" . implode("','", $data_in) . "'";
			
			$operand= "";
			if( ! empty($filter) ){
				$operand= "AND";
			}
			// Get Seluruh Data template dan project process
			$sql= "SELECT * FROM project_template a 
				LEFT JOIN pos_menu b ON b.IdTemplate= a.Id 
				WHERE a.Id IN(" . $IdTemplate . ") " . $operand . " {condition}
				ORDER BY {sorting}, b.Urutan";
			$rows= $this->Jmodel->getData("", "", "", $sort, $filter, false, $sql);
			
			// Modify List untuk dipakai pada Perulangan
			foreach( $rows as $row ){
				$list[$row['Name']][]= $row;
			}
		}
		
		// Fields for Searching Filter
		$fields= array(
			'Name'=>'Template Name'
		);
		
		$operator= $this->themelib->operator_search; // Get Operator Searching
		
		// Current Page
		$curpage= $this->uri->segment(4);
/*		echo "<pre>";
		print_r($list);
		echo "</pre>";
		exit;*/
		$rows= array();
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		/*$data['jscript']= '';*/
		$data['jscript']= $this->load->view('js/filter', $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data['rows']= $list;
		$data['pagination']= $this->pagination->create_links();
		$data['hrefNewProject']= site_url() . "project/template";
		/* Searching Data */
		$data['baseurl_sort']= site_url() . "project/template_all";
		$data['searching_fields']= $fields;
		$data['operator']= $operator;
		$data['filter_str']= $filter_str;
		$data['nopage']= ( ! empty($curpage) ) ? $curpage : 1;
		$this->themelib->getpage("project/template_all", $data, "inc/theme_main");
	}
	
	// Create New / Edit Project Template
	// Halaman Ini Mengirimkan POST serta Pengeditan pada Halaman dengan Javascript Enabled
	public function template($action="", $templateName= ""){
		$templateName= urldecode($templateName);
		if( $action == "edit" ){
			// Get Data Template 
			$where= array('Name'=>$templateName);
			$template= $this->db->get_where("project_template", $where)->row_array();
			
			// Get Data Step Process
			$where= array('IdTemplate'=>$template['Id']);
			$this->db->order_by('Urutan ASC');
			$process= $this->db->get_where("pos_menu", $where)->result_array();
						
/*			echo "<pre>";
			print_r($template);
			print_r($process);
			echo "</pre>";
			exit;			*/
			$config= $this->config;
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= $this->load->view("js/project_template.php", $data, TRUE);
			$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
			$data['template']= $template;
			$data['process']= $process;
			$this->themelib->getpage("project/template_edit", $data, "inc/theme_main");
		}elseif( $action == "delete" ){
			// Get Id Template
			$where= array('Name'=>$templateName);
			$template= $this->db->get_where('project_template', $where)->row_array();
			
			$where= array('IdTemplate'=>$template['Id']);
			$jml= $this->db->get_where('project', $where)->num_rows();
			if( $jml ){				
				echo json_encode(array('type'=>'error', 
				'msg'=>"Template tidak bisa di-hapus !\nTemplate sudah digunakan pada Project."));
			}else{
				// Delete Data pada Tabel project_template dan pos_menu
				$where_project_template= array('Id'=>$template['Id']);
				if( $this->db->delete('project_template', $where_project_template) ){
					echo json_encode(array('type'=>'success', 
					'msg'=>"Data has been delete"));					
				}
			}
		}else{
			$config= $this->config;
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= $this->load->view("js/project_template.php", $data, TRUE);
			$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
			$this->themelib->getpage("project/template", $data, "inc/theme_main");
		}
	}
	
	// Edit And Delete Template
	public function action_template($action){
		$POST= $this->input->post();
/*		print_r($POST);
		exit;*/
		if( $action == "edit" ){
		
			// Group Data New Process yang akan ditambahkan
			$newProcess= array();
			if( isset($POST['process']) ){
				extract($POST['process']);
				foreach( $Name as $key=>$value ){
					$data= array();
					$data['Process_Name']= $value;
					$data['Score_Completion']= $Score[$key];
					$data['Urutan']= $Urutan[$key];
					$data['IdTemplate']= $POST['template']['Id'];
					$newProcess[]= $data;
				}
			}		
			
			// Get Previous Process POST
			$prevProcess= $POST['prev_process'];
			
			// Get Previous Process di DBase
			$where= array('IdTemplate'=>$POST['template']['Id']);
			$dbProcess= $this->db->get_where('pos_menu', $where)->result_array();
			
			// Get Data Process yang Harus di-Delete
			$delProcess= array();
			foreach( $dbProcess as $process ){
				if( ! array_key_exists($process['Id'], $prevProcess) ){
					$this->db->delete('pos_menu', array('Id'=>$process['Id']));
					$delProcess[]= $process;
				}
			}
			
			// Update Previous Process
			$dtUpdate= array();
			foreach( $prevProcess as $list ){
				$dtUpdate['Process_Name']= $list['Name'];
				$dtUpdate['Score_Completion']= $list['Score'];
				$dtUpdate['Urutan']= $list['Urutan'];
				$where= array('Id'=>$list['Id']);
				$this->Jmodel->update('pos_menu', $dtUpdate, $where);
			}
			
			// Insert New Process
			foreach( $newProcess as $list ){
				$this->Jmodel->insert('pos_menu', $list);
			}
			
			if( $POST['type'] == "ajax" ){
				echo "success";
				exit;
			}
/*			echo "<pre>";
			print_r($process);
			print_r($prevProcess);
			print_r($newProcess);
			print_r($delProcess);
			echo "</pre>";
			exit;*/
		}else{
			
		}		
	}
	
	// Create New Project Template
	public function create_template(){
		$POST= $this->input->post();
		
		// Cek Jika Template dengan Nama tsb tidak Ada
		$template= array('Name'=>$POST['template_name']);
		if( $this->db->get_where('project_template', $template)->num_rows() ){
			if( $POST['type'] == "ajax" ){
				echo "Template dengan nama tersebut sudah Ada !";
				exit;
			}else{
				$this->session->set_userdata('error', 'Template dengan nama tersebut sudah Ada !');
				redirect('project/template_all');
			}
		}
		
		// Extract process dari parameter POST 
		extract($POST['process']);
		
		// Gabungkan Array Process dan Score
		$posmenu= array();
		$urut= 1;
		foreach( $Name as $key=>$value ){
			$posmenu[$key]= array('Process_Name'=>$value, 'Score_Completion'=>$Score[$key], 
			'Urutan'=>$Urutan[$key]);
			$urut++;
		}
		
/*		echo "<pre>";
		print_r($posmenu);
		echo "</pre>";
		exit;*/
		// Insert Template to Database 
		$template= array('Name'=>$POST['template_name']);
		$insert_id= $this->Jmodel->insert("project_template", $template, true);
		if( $insert_id ){
			foreach( $posmenu as $row ){
				$row['IdTemplate']= $insert_id;
				$this->Jmodel->insert('pos_menu', $row);
			}
		}
		
		if( $POST['type'] == "ajax" ){
			echo "success";
			exit;
		}else{
			redirect('project/template_all');
		}
	}
		
	public function getPassword(){
		$this->load->view("");
		echo md5('sales_admin');
	}
	
	public function select_template(){
		$rows= $this->db->get('project_template')->result_array();
		$template= array();
		$template[""]= "-- Select --";		
		foreach( $rows as $row ){
			$template[$row['Id']]= $row['Name'];
		}
		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= $this->load->view("js/select_template.php", $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data['template']= $template;
		$data['hrefAction']= base_url() . "setting/summary";
		$this->themelib->getpage("project/select_template", $data, "inc/theme_main");
	}	
	
	// Create And Edit Setting Summary
	// @param1 string berisi 'summary',  
	// @param2 int berisi IdTemplate u/ ByPass Ketika User klik Save Redirect Langsung ke halaman Ini
	public function setting($param="", $IdTemplate=""){		
		$POST= $this->input->post();
		if( ! empty($POST) ){
			extract($POST);
		}		
		
		// Jika Tidak Ada IdTemplate Redirect untuk select Template
		if( ! isset($IdTemplate) || empty($IdTemplate) ){
			redirect("project/select_template");
		}
		
		// Get Previous Setting Summary
		$Username= $this->session->userdata("Username");
		$where= array("Username"=>$Username, "IdTemplate"=>$IdTemplate);
		$rows= $this->db->get_where("summary", $where)->result_array();
		
		if( count($rows) ){
			$summaries= array();
			foreach( $rows as $row ){
				$summaryFields= unserialize($row['summaryFields']);
				$summaries[$row['Posmenu_ID']]= $summaryFields;
			}
		}
		
		// Get Seluruh Field pada setiap Process berdasarkan Template Yang di-Select
		$sql= "SELECT a.Id AS IdProcess, a.Process_Name, a.Table, b.* FROM pos_menu a 
			LEFT JOIN form_fields b ON b.FormID= a.FormID 
			WHERE ( b.Name!= 'Project_ID' OR b.Name IS NULL ) AND a.IdTemplate= '" . $IdTemplate . "' 
			ORDER BY a.Id";
		$rows= $this->db->query($sql)->result_array();
						
		$process= array();
		$description= array();
		foreach( $rows as $row ){
			if( !empty($row["Name"]) ){
				$process[$row["IdProcess"]][]= $row;
				$description[$row["IdProcess"]]["Process_Name"]= $row["Process_Name"];
				$description[$row["IdProcess"]]["Id"]= $row["IdProcess"];
			}else{
				$process[$row["IdProcess"]]= array();
				$description[$row["IdProcess"]]["Process_Name"]= $row["Process_Name"];
				$description[$row["IdProcess"]]["Id"]= $row["IdProcess"];
			}
		}
		
/*		echo "<pre>";		
		print_r($POST);
		print_r($description);
		echo "</pre>";
		exit;*/				
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= "";
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data["process"]= $process;
		$data["description"]= $description;
		$data['summaries']= ( isset($summaries) ) ? $summaries : "";
		$data['IdTemplate']= $IdTemplate;
		$this->themelib->getpage("project/setting_summary", $data, "inc/theme_main");
	}
	
	// Processing Summary
	public function set_summary(){
/*		echo "<pre>";
		print_r($jml);
		echo "</pre>";
		exit;*/	
		$POST= $this->input->post();
		$Username= $this->session->userdata("Username");
		$IdTemplate= $POST['IdTemplate'];
		
		// Check If Data is exist remove it first
		$jml= $this->db->get_where('summary', array('Username'=>$Username, 'IdTemplate'=>$IdTemplate))->num_rows();
		if( $jml ){
			$this->db->where(array('Username'=>$Username, 'IdTemplate'=>$IdTemplate));
			$this->db->delete('summary');
		}
		
		// Insert Score		
		$scoreData= array();
		$scoreData['Username']= $Username;
		$scoreData['summaryFields']= serialize($POST['score']);
		$scoreData['Posmenu_ID']= '0';
		$scoreData['IdTemplate']= $IdTemplate;
		$this->Jmodel->insert("summary", $scoreData);
		
		// Insert Semua Data Summary ke Tabel summary	
		foreach( $POST['Process'] as $key=>$process ){
			$insData= array();
			$insData['Username']= $Username;
			$insData['summaryFields']= serialize($process);
			$insData['Posmenu_ID']= $key;
			$insData['IdTemplate']= $IdTemplate;
			$this->Jmodel->insert("summary", $insData);
		}
		
		// Set Feedback and Redirect
		$this->session->set_userdata('feedback','The changes has been saved !');
		redirect("project/setting/summary/" . $IdTemplate);
	}
	
	public function getdata(){
		$data= $this->db->get_where("project_process", array("Id"=>"3"))->row_array();
		$row= unserialize($data["formValue"]);
		echo "<pre>";
		print_r($row);
		echo "</pre>";
	}
	
	// Create Project
	public function index($params=""){
		$rows= $this->db->get('project_template')->result_array();
		$template= array();
		$template[""]= "-- Select --";
		foreach( $rows as $row ){
			$template[$row['Id']]= $row['Name'];
		}
				
/*		echo "<pre>";
		print_r($template);
		echo "</pre>";
		exit;*/		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= $this->load->view("js/create_pro.php", $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data['template']= $template;
		
		$POST= $this->input->post();
		if( isset($POST["submit"]) || $POST["type"] == "ajax" ){
			// Set Rules Validasi
			$config= array(
						array(
							'field'=> 'Project_Name',
							'label'=> 'Project Name',
							'rules'=> 'required'
						),
						array(
							'field'=> 'Identitas_Perusahaan',
							'label'=> 'Identitas Perusahaan',
							'rules'=> 'required'
						)						
					);
			$this->form_validation->set_rules($config);
			
			if( $this->form_validation->run() == TRUE ){ // Cek Validasi
				$type= isset($POST["type"]) ? $POST["type"] : "";
				// Set Data
				$POST["Username"]= $this->session->userdata("Username");
				
				// Cek Project Name ada atau tidak dengan GroupName tsb 
				// karena ada 2 User Type yaitu Admin dan Sales yang bisa mengakses project yg sama
				$where= array("Username"=>$POST["Username"], "Project_Name"=>$POST["Project_Name"]);
				$exist= $this->db->get_where("project", $where)->num_rows();
				if( ! $exist ){
					unset($POST["submit"], $POST["type"]); // Unset Data
					
					// Insert Data to DB
					if( $this->db->insert("project", $POST) ){
						if( $type == "ajax" ){
							echo "success";
							exit;
						}else{
							$this->session->set_userdata("error_ot","Data has been saved.");
							$this->themelib->getpage("project/create", $data, "inc/theme_main");
						}
					}
				}else{
					if( $type == "ajax" ){
						echo "Project Name is already exist.";
						exit;
					}else{
						$this->session->set_userdata("error_ot","Project Name is already exist.");
						$this->themelib->getpage("project/create", $data, "inc/theme_main");
					}
				}
			}else{
				$this->themelib->getpage("project/create", $data, "inc/theme_main");
			}
		}else{
			$this->themelib->getpage("project/create", $data, "inc/theme_main");
		}
	}
	
/*	public function formBuilder(){
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= $this->load->view("js/formbuilder.php", $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$this->themelib->getpage("formbuilder", $data);
	}
	
	public function formBuilder_create(){
		$POST= $this->input->post();
		$config= $this->config;
		$data= array();
		
		// Cek Data pada Tabel masterform
		$where= array("FormID"=>$POST["FormID"]);
		$jml= $this->db->get_where("masterform", $where)->num_rows();

		if( ! $jml ){ // Jika Data tidak Ada Insert data tsb
			// Insert Data ke Tabel masterform
			$form= array("FormID"=>$POST["FormID"], "ActionUrl"=>"#");
			$this->db->insert("masterform", $form);
			
			// Insert Data ke Tabel form_fields
			$fields= $POST;
			unset($fields["submit"], $fields["FormID"]);
			foreach( $fields as $key=>$field ){
				$insfield= array();
				$insfield["FormID"]= $POST["FormID"];
				$insfield["Name"]= $key;
				if( $key == "Project_ID" ){
					$insfield["FieldType"]= $field;
				}else{
					$data= explode("~", $field);
					$insfield["FieldType"]= $data[0];
					$insfield["Label"]= $data[1];
				}
				$this->db->insert("form_fields", $insfield);
			}
			redirect("project/formBuilder");
		}else{ // Jika Data Ada Redirect dan display error
			$this->session->set_userdata("error", "Form dengan ID tersebut sudah Ada.");
			redirect("project/formBuilder");						
		}
	}			
	*/		
		
	// Create Project
	public function edit($IdProject=""){
		// Check Project
		$where= array("Project_ID"=>$IdProject);
		$query= $this->db->get_where("project", $where);
		$jml= $query->num_rows();
		
		if( empty($jml) ){
			redirect("project/daftar");
		}else{
			$config= $this->config;
			$data= array();
			$data['bar_path']= $config->item('loading');
			$data['main_url']= base_url();
			$data['jscript']= $this->load->view("js/create_pro.php", $data, TRUE);
			/*$data['jscript']= "";*/
			$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
			$data['row']= $query->row_array();
			$this->db->flush_cache();
			$this->themelib->getpage("project/edit", $data, "inc/theme_main");					
		}
	}	
	
	public function daftar($param="page", $nopage="", $sorting=""){
		// Get Jumlah Baris dari tabel Project dengan GroupName yang sama
		$Username= $this->session->userdata("Username");
		/*$Username= "sales";*/
		$POST= $this->input->post();
		$url= explode("&", $sorting);
		
		// Parsing Url Sorting dan Filter ( Jika Sorting dan Filter dimasukan pada URL setelah submit ditekan )
		// Set Filter Searching
		$filter_params= $this->themelib->get_filter_params($url, $POST);
		extract($filter_params); // Variable Extact( sorting, filter_str, filter )
/*		echo "<pre>";
		print_r($filter_params);
		echo "</pre>";*/
		
		/*exit;*/
/*		$sorting= $url[0];
		$filter_url= ( isset($url[1]) ) ? $url[1] : "";
		$filter_str= ""; // 
		if( isset($POST['btnSubmit']) ){
			// Set Limit to default
			$nopage= 1;
			// Set Filter properties dan set $filter_str untuk dimasukan ke url pagination
			$filter= array('field'=>$POST['search'], 'op'=>$POST['op_search'], 'key'=>$POST['search_key']);
			foreach( $filter as $key=>$value ){
				$filter[$key]= urlencode($value);
			}
			$filter_str= implode(":", $filter);
		}else{
			// Set Filter dari Pagination Url
			$filter= "";
			if( ! empty($filter_url) ){
				$filter_str= $filter_url;
				$filter_url= explode(":", $filter_url);
				$filter= array('field'=>$filter_url[0], 'op'=>$filter_url[1], 'key'=>$filter_url[2]);
			}
		}*/
		
		// Set Default / Sorting
		$sorting= ( empty($sorting) ) ? "Project_Name=ASC" : urldecode($sorting);
		$sort= explode("=", $sorting);
		
		// Get Jumlah Project List
		$rows= $this->Jmodel->getProjectByUsertype($Username, "", "", "", $filter, TRUE);
		$jml= count($rows);
		
		// Get Offset, Jumlah Page
		$nopage= ( empty($nopage) ) ? 1 : $nopage;
		$numpage= $nopage; // Get Number Page from URL
		$nopage= (int)$nopage-1;
		$perpage= 5;
		$offset= $nopage * $perpage; // Nilai Offset u/ Query
		$jml_page= ceil($jml / $perpage); // Jumlah Halaman
		
		// Jika Halaman lebih dari Jumlah Halaman atau Negative Page 
		// dan tidak Ada $POST Searching 
/*		echo "<pre>";
		if( ! $numpage < 1 ){
			echo $numpage . "->" . $jml_page . "<br/>";
		}
		print_r($POST);
		echo "</pre>";*/
		if( ( $numpage > $jml_page || $numpage < 1 ) && empty($POST) ){
			redirect("project/daftar"); // Redirect ke First Page
		}
		
/*		echo $filter_str;
		exit;*/
		// Pagination Config
		$config['base_url'] = site_url('project/daftar/page');
		$config['suffix']= "/" . urlencode($sorting) . "&" . $filter_str;
		$config['total_rows'] = $jml;
		$config['per_page'] = $perpage;
		$config['use_page_numbers'] = FALSE;
		$config['uri_segment']= 4; // Pengenal URI Active Page
		$config['first_url']= 1;
		$this->pagination->initialize($config);
		
		// Jika User Melakukan Searching tidak dari Halaman 1
		if( ! empty($POST) && !empty($nopage) ){
			redirect('project/daftar/page/1/' . urlencode($sorting) . "&" . $filter_str);
		}
				
		// Get Data Project from DB sesuai dengan current Page 
		$getRows= $this->Jmodel->getProjectByUsertype($Username, $perpage, $offset, $sort, $filter);
		// Set Project_Id sebagai Key
		$rows= array();
		foreach( $getRows as $list ){
			$rows[$list['Project_ID']]= $list;
		}
		
		// Get Summary untuk setiap Project	dan di Group Berdasarkan IdTemplate
		// Group Score Berdasarkan IdTemplate
		$dtsummaries= $this->db->get_where('summary', array('Username'=>$Username))->result_array();
		$getsummaries= array();
		$statScore= array();
		foreach( $dtsummaries as $summary ){
			if( $summary['Posmenu_ID'] == "0" ){
				$statScore[$summary['IdTemplate']][]= unserialize($summary['summaryFields']);
				continue;
			}
			$getsummaries[$summary['IdTemplate']][]= $summary;
		}
		
		// Get summaries and formValue
		$values= array();
		$summaries= array();
		$file= array();
		foreach( $rows as $row ){
			if( isset($getsummaries[$row['IdTemplate']]) ){
				foreach( $getsummaries[$row['IdTemplate']] as $summary ){
					$where= array('Posmenu_ID'=>$summary['Posmenu_ID'], 'Project_ID'=>$row['Project_ID']);
					$getdt= $this->db->get_where('project_process', $where)->row_array();
					$formValue= ( isset($getdt['formValue']) ) ? unserialize($getdt['formValue']) : "";
					// Add formValue Data sesuai Project_ID -> Posmenu_ID
					if( $formValue ){						
						// Get Description Type Upload File
						$regfile= "#^.+\..{3,4}$#";
						foreach( $formValue as $formKey=>$form ){
							if( preg_match($regfile, $form) ){
								$where= array('Filename'=>$form);
								$dtfile= $this->db->get_where('upload', $where)->row_array();
								$file[$dtfile['Filename']]= $dtfile;
								/*echo $formKey . "->" . $form . "<br/>";*/
							}elseif($formKey == "PO_ID" ){
								$where= array('Project_ID'=>$row['Project_ID']);
								$poid= $this->db->get_where('po_id', $where)->row_array();
								
								$formValue[$formKey]= ( isset($poid['PO_ID']) ) ? $poid['PO_ID'] : "";
							}
						}
						$values[$row['Project_ID']][$summary['Posmenu_ID']]= $formValue;
					}
					// Modify Summary Data sesuai Dengan Template Yang Dipilih Untuk Project
					$summary_field= unserialize($summary['summaryFields']);
					$summaries[$row['IdTemplate']][$summary['Posmenu_ID']]= $summary_field;
				}
			}
		}
		
		// Remove unnecessary Fields / Get Fields sesuai Summary
		foreach( $values as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				foreach( $subvalue as $fieldkey=>$field ){
					$IdTemplate= $rows[$key]['IdTemplate'];
					/*echo $IdTemplate . "<br/>";*/
					if( ! in_array($fieldkey, $summaries[$IdTemplate][$subkey]) ){
						unset($values[$key][$subkey][$fieldkey]);
					}
				}
			}
		}
		
		// Get Score u/ Setiap Project
		$dbscore= $statScore;
		$score= array();
		$score= $this->getScore("", $rows);
		
		// Get Description Untuk Setiap Fields
		$description= array();
		foreach( $summaries as $templatekey=>$list ){
			foreach( $list as $key=>$summary ){
				$sql= "SELECT b.Label, b.Name FROM pos_menu a 
					LEFT JOIN form_fields b ON b.FormID= a.FormID 
					WHERE a.Id= '" . $key . "' AND a.IdTemplate= '" . $templatekey . "' AND b.Name != 'Project_ID'";
				$getfields= $this->db->query($sql)->result_array();
				foreach( $getfields as $fieldkey=>$field ){
					$description[$key][$field['Name']]= $field['Label'];
				}
			}
		}
		
		// Get Available Tags
		$dbTags= $this->db->get('tag')->result_array();
		$tags= array();
		$tag_filter= array();
		foreach( $dbTags as $tag ){
			$tags[$tag['tagName']]= $tag;
			$tag_filter[]= $tag['tagName'];
		}
		$tag_filter= implode(",", $tag_filter);
		
		// Fields for Searching Filter
		$fields= array(
			'Project_Name'=>'Project Name',
			'Identitas_Perusahaan'=>'Identitas Perusahaan'
		);
		
		$operator= $this->themelib->operator_search; // Get Operator Searching
/*		echo "<pre>";
		print_r($tag_filter);
		echo "</pre>";
		exit;*/
/*		echo "<pre>";
		print_r($summaries);
		print_r($description);
		print_r($values);
		echo "</pre>";
		exit;*/
		// Current Page
		$curpage= $this->uri->segment(4);
		
/*		echo count($tag_filter);
		exit;*/
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		/*$data['jscript']= $this->load->view('js/filter', $data, TRUE);*/
		$data['jscript']= "";
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data["list"]= $rows;
		$data["summaries"]= $summaries;
		$data["description"]= $description;
		$data["file"]= $file; // Description About File Upload / Document
		$data["tags"]= $tags;
		$data["formValues"]= $values;
		$data["statScore"]= $statScore;
		$data["score"]= $score;
		/* Searching Data */
		$data['baseurl_sort']= site_url() . "project/daftar";
		$data['searching_fields']= $fields;
		$data['operator']= $operator;
		$data['filter_str']= $filter_str;
		$data['tag_filter']= $tag_filter;
		/*echo $this->uri->segment(4) . "<br/>";*/
		$data['nopage']= ( ! empty($curpage) ) ? $curpage : 1;
		/* End Searching */
		$data["pagination"]= $this->pagination->create_links();
		$this->themelib->getpage("project/view", $data, "inc/theme_main");
	}
	
	// Get Score Completion Untuk satu atau Beberapa Project
	// @access	private
	// @param1 String, @param2 Array
	// @return Array
	private function getScore($IdProject="", $rows=""){
		$dtscore= array();
		$jml= 0;
		foreach( $rows as $row ){
			if( is_array($row) ){
				$getscore= $this->calcScore($row);
				$key= array_keys($getscore);
				$value= array_values($getscore);
				$dtscore[$key[0]]= $value[0];
			}else{
				$jml= 1;
			}
		}
		// Calculate Score Per Data using Method calcScore
		if( $jml ){
			$dtscore= $this->calcScore($rows);
		}
		
		return $dtscore;
	}
	
	// Calculate Score for each project
	// @access private
	// @param Array
	// @return Array
	private function calcScore($row=""){
		// Get Seluruh Project Process 
		$posMenu= $this->db->get('pos_menu')->result_array();
		
		$dtscore= array();
		$score= 0;
		foreach( $posMenu as $pos ){
			$IdProject= $row['Project_ID'];
			$Posmenu_ID= $pos['Id'];
			$FormID= $pos['FormID'];
			
			// Get Seluruh Field Dari Form Yang di-select
			$sql= "SELECT * FROM form_fields WHERE FormID= '" . $FormID . "' AND Name != 'Project_ID'";
			$fields= $this->db->query($sql)->result_array();
			$comfields= array();
			if( !empty($fields) ){
				foreach( $fields as $field ){
					$comfields[$field["Name"]]= "";
				}
			}
			
			// Get Data Form Dari Tabel project_process
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			$query= $this->db->get_where("project_process", $where);
			$jml= $query->num_rows();
			
			$dtscore[$IdProject]= $score;
			if( $jml ){
				$dtform= $query->row_array();
				$formValue= unserialize($dtform["formValue"]);
				$formValue= array_merge($comfields, $formValue); // Merge Data Array FormValue dengan All Fields
				
				// Cek Empty Field Pada Process
				$emptystat= 0;
				foreach( $formValue as $key=>$value ){
					if( empty($value) ){
						$emptystat= 1;
					}
				}
				
				// Jika data sudah terisi semua tambahkan score Untuk masing2x Project
				if( ! $emptystat ){
					$score+= $pos["Score_Completion"];
					$dtscore[$IdProject]= $score;
				}
			}
		}

		return $dtscore;
	}
	
	// Display PopUp Share
	// Normal Display, Searching
	public function shares($nopage=""){
		$POST= $this->input->post();
		$Username= $this->session->userdata('Username');
		/*$Username= "posix";*/
		
		$IdShares= array();
		if( isset($POST['IdProject']) ){
			$where= array('Project_ID'=>$POST['IdProject']);
			$project= $this->db->get_where('project', $where)->row_array();		
			$IdShares= explode(",", $project['IdShare']);
		}
/*		print_r($IdShares);
		exit;*/
		
		// Get Jumlah Record
		if( isset($POST['search']) ){			
			// Get Jumlah Record Sales dengan Username != dengan Current User / Sales
			// dan Username sesuai dengan Key yang di-Inputs
			$sql= "SELECT * FROM user 
			WHERE IdUsertype= '5' AND Username LIKE '%" . 
			$POST['search'] . "%' AND Username != '" . $Username . "'";
			$jml= $this->db->query($sql)->num_rows();
		}else{
			// Get Jumlah Record Sales dengan Username != dengan Current User / Sales
			$jml= $this->db->get_where('user', array('IdUsertype'=>'5', 'Username !='=>$Username))->num_rows();
		}
				
		/*$jml= $this->db->get_where('user', array('IdUsertype'=>'5'))->num_rows();*/
		
		// Set Offset, PerPage, dan Jumlah Page
		$nopage= ( empty($nopage) ) ? 1 : $nopage;
		$nopage= (int)$nopage-1;
		$perpage= 2;
		$offset= $nopage * $perpage; // Nilai Offset u/ Query
		$jml_page= ceil($jml / $perpage); // Jumlah Halaman
				
		// Jika Halaman lebih dari Jumlah Halaman atau Negatif Value		
		if( $nopage >= $jml_page || $nopage < 0 ){
			$nopage= 1;
		}
				
		// Pagination Config
		$base_url= base_url() . 'project/shares/';
		$config['base_url'] = $base_url;
		$config['total_rows'] = $jml;
		$config['per_page'] = $perpage;
		$config['use_page_numbers'] = FALSE;
		$config['uri_segment']= 4; // Pengenal URI Active Page
		$config['first_url']= 1;
		$config['num_links']= $jml_page;
		$config['next_link']= FALSE;		
		$this->pagination->initialize($config);		
		
		// Create Pagination jika user load untuk First Page 
		$pagination= "";
		$data['IdShares']= $IdShares;
		if( isset($POST['search']) ){
			// Get Jumlah Record Sales dengan Username != dengan Current User / Sales
			// dan Username sesuai dengan Key yang di-Inputs
			$sql= "SELECT * FROM user 
			WHERE IdUsertype= '5' AND Username LIKE '%" . 
			$POST['search'] . "%' AND Username != '" . $Username . "' 
			ORDER BY Username ASC 
			LIMIT " . $offset . "," . $perpage;
			$sales= $this->db->query($sql)->result_array();			
		}else{
			// Get Jumlah Record Sales dengan Username != dengan Current User / Sales
			$this->db->order_by('Username','ASC');
			$sales= $this->db->get_where('user', 
			array('IdUsertype'=>'5', 'Username !='=>$Username), $perpage, $offset)->result_array();
/*			echo $this->db->last_query();
			exit;*/
		}
		
		// Display Data
		if( ! isset($POST['type']) ){
			// Ketika PopUp pertama kali dibuka
			$pagination= $this->pagination->create_links();
			$data['pagination']= $pagination;
			$data['sales']= $sales;
			$data['base_url'] = $base_url;
			$popUp= $this->load->view("dialog/shares_project", $data, true);
			echo $popUp;
		}else{
			$html= "";	
			foreach( $sales as $sale ){
				$extraAttr= array();
				if( in_array($sale['Username'], $IdShares) ){
					$extraAttr= array('checked'=>'checked');
				}
				$attr_box= array('name'=>'sales_id[]', 'value'=>$sale['Username'], 'class'=>'salesBox');
				$attr_box= array_merge($attr_box, $extraAttr);
				$html.= '<tr class="page' . ($nopage+1) . '">' . 
				'<td>' . 
				'<label class="checkbox">' . 
				form_checkbox($attr_box) . 
				'<span>' . ucwords($sale['Username']) . '</span>' . 
				'</label>' . 
				'</td>' . 
				'</tr>';
			}
			
			if( isset($POST['search']) && $POST['type'] == "search" ){
				// Ketika Button Search di-Klik
				$pagination= $this->pagination->create_links();
				$html= array('dataTable'=>$html, 'pagination'=>$pagination);
				echo json_encode($html);
			}else{
				// Ketika Button Navigate di-Klik
				echo $html;
			}
		}
		
/*		echo "<pre>";
		print_r($data);
		echo "</pre>";
		exit;*/
	}
	
	public function process_share(){
		$POST= $this->input->post();		
		
		$where= array("Project_ID"=>$POST['IdProject']);
		unset($POST['IdProject']);
		if( $this->Jmodel->update('project', $POST, $where) ){
			echo "success";
			exit;
		}
/*		echo "<pre>";
		print_r($POST);
		echo "</pre>";
		exit;*/
	}
	
	// Download File pada Project Detail
	public function download($IdProject="", $IdProcess="", $filename=""){
		$where= array('Filename'=>$filename);
		$file= $this->db->get_where('upload', $where)->row_array();
		
		$config= $this->config;
		$fullpath= $config->item('assets_img') . "project/" . $IdProject. "/" . $IdProcess . "/" . $filename;
		$data= file_get_contents($fullpath);
		
		force_download($file['Description'], $data);
	}
		
	public function detail($IdProject){
		// Get Data Project Name
		$where= array("Project_ID"=>$IdProject);
		$project= $this->db->get_where("project", $where)->row_array();
		
		// Get Data Step Completion
		$where= array("IdTemplate"=>$project['IdTemplate']);
		$this->db->order_by('Urutan','ASC');
		$rows= $this->db->get_where("pos_menu", $where)->result_array();
		$this->db->flush_cache();
				
		$score= 0;
		$ct= 0;
		$barisId= 1;
		$jml_steps= count($rows);
		$view= array();
		$file= array(); // Store Data about File Upload		
		// Hitung Score Completion Dan Get Form Value / Isian
		foreach( $rows as $row ){
			$tabel= $row["Table"];
			$Posmenu_ID= $row["Id"];
			$FormID= $row["FormID"];
			
			// Get Seluruh Field Dari Form Yang di-select
			$sql= "SELECT * FROM form_fields WHERE FormID= '" . $FormID . "' AND Name != 'Project_ID'";
			$fields= $this->db->query($sql)->result_array();
			if( !empty($fields) ){
				$comfields= array();
				foreach( $fields as $field ){
					$comfields[$field["Name"]]= "";
				}
			}
			
			// Get Data Form Dari Tabel project_process
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			$query= $this->db->get_where("project_process", $where);			
			$jml= $query->num_rows();
						
			if( $jml ){ // Jika Data Form ada
				$dtform= $query->row_array();
				$formValue= unserialize($dtform["formValue"]);
				$formValue= array_merge($comfields, $formValue); // Merge Data Array FormValue dengan All Fields
				
				// Cek Empty Field Pada Process
				$emptystat= 0;
				foreach( $formValue as $key=>$value ){
					if( empty($value) ){
						$emptystat= 1;
					}
				}
				
				// Jika data sudah terisi semua tambahkan ke score dan aktifkan next process
				$Aktif= 0;
				if( ! $emptystat ){
					$score+= $row["Score_Completion"];
					$Aktif= 1;
					$rows[$ct]['Status']= 2; // Complete
					$barisId+= 1; // Digunakan untuk pengenal barisId yang Aktif
				}else{
					$rows[$ct]['Status']= 2; // Aktif
				}
				
				$view[$Posmenu_ID]= $formValue; // Data untuk tampilan Edit	
				
				// Get Description Type Upload File
				$regfile= "#^.+\..{3,4}$#";
				foreach( $formValue as $formKey=>$form ){
					if( preg_match($regfile, $form) ){
						$where= array('Filename'=>$form);
						$dtfile= $this->db->get_where('upload', $where)->row_array();
						$file[$Posmenu_ID][$dtfile['Filename']]= $dtfile;
						/*echo $formKey . "->" . $form . "<br/>";*/
					}
				}
				// Jika Ada field yang kosong pada process tertentu hentikan perulangan
				if( ! $Aktif ){
					break;
				}
			}else{ // Jika Data Form tidak ada
				break; // Hentikan Perulangan
			}
			$ct++;
		}
		
		$Username= $this->session->userdata('Username'); // Get Username from Session
		$IdUsertype= $this->session->userdata('IdUsertype'); // Get Username from Session
		$where= array('Id'=>$IdUsertype);
		$usertype= $this->db->get_where('usertype', $where)->row_array();
		
		$boxShare= "";
		$share= array();
		if( $usertype['Usertype'] == "sales" ){
			if( $project['Username'] == $Username ){
				// Jika Username Login sama dengan Username yg create project
				// Munculkan Box Share ( ngeShare )
				$boxShare= "yes";
			}else{
				// Jika Username Login tidak sama dengan Username yg create project
				// Ganti Dengan BoxShare ( diShare )
				$boxShare= "no";
			}
			
			// Bagi IdShare menjadi Username masing2x atau terpisah
			// $share berisi data jika Username yang create project adalah username yg Login
			if( ! empty($project['IdShare']) ){
				$UsernameSales= explode(",", $project['IdShare']);
				foreach( $UsernameSales as $sales ){
					$where= array('Username'=>$sales);
					$share[]= $this->db->get_where('user', $where)->row_array();
				}
			}
		}
		
		// Get Data Tag yg di-select
		$selectedTags= "";
		if( ! empty($project['IdTag']) ){
			$selectedTags= explode(",", $project['IdTag']);
		}
		
		// Get Available Tags from DBase
		$tags= $this->db->get("tag")->result_array();
		
		// Get ToDo List dari User Login
		$todos= array();
		$where= array("IdProject"=>$IdProject, "Username"=>$Username);
		$todos= $this->db->get_where("todo", $where)->result_array();
				
		$usertype['Usertype']= "sales";
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['hrefAction']= base_url() . "project/process_share";
		$data['jscript']= $this->load->view("js/pro_detail.php", $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data["rows"]= $rows;
		$data["score"]= $score;
		$data["barisId"]= $barisId;
		$data["IdProject"]= $IdProject;
		$data["view"]= $view;
		$data["file"]= $file; // Store File Upload Description
		$data["share"]= $share;
		$data["boxShare"]= $boxShare;
		$data["tags"]= $tags;
		$data["todos"]= $todos; // Todo List
		$data["selectedTags"]= $selectedTags;
		$data["Project_Name"]= $project["Project_Name"];
		$data['project']= $project;
		$data['Usertype']= $usertype['Usertype'];
		$data['hrefDialog']= "project/dialog/";
		$data['hrefShare']= "project/shares";
		$data['hrefAction']= "project/process_share";
		$this->themelib->getpage("project/detail", $data, "inc/theme_main");
	}
		
	/*public function detail($IdProject){	
		// Get Data Project Name
		$where= array("Project_ID"=>$IdProject);
		$project= $this->db->get_where("project", $where)->row_array();
		
		// Get Data Step Completion
		$rows= $this->db->get("pos_menu")->result_array();
		$this->db->flush_cache();
		
		// Hitung Score Completion
		$score= 0;
		$ct= 0;
		$barisId= 1;
		$view= array();
		foreach( $rows as $row ){
			$tabel= $row["Table"];
			$Posmenu_ID= $row["Id"];
			$FormID= $row["FormID"];
			
			// Get Seluruh Field Dari Form Yang di-select
			$sql= "SELECT * FROM form_fields WHERE FormID= '" . $FormID . "' AND Name != 'Project_ID'";
			$fields= $this->db->query($sql)->result_array();
			if( !empty($fields) ){
				$comfields= array();
				foreach( $fields as $field ){
					$comfields[$field["Name"]]= "";
				}
			}
			
			// Get Data Form Dari Tabel project_process
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			$query= $this->db->get_where("project_process", $where);			
			$jml= $query->num_rows();
			if( $jml ){
				$dtform= $query->row_array();
				$formValue= unserialize($dtform["formValue"]);
				$formValue= array_merge($comfields, $formValue); // Merge Data Array FormValue dengan All Fields
				
				// Cek Empty Field Pada Process
				$emptystat= 0;
				foreach( $formValue as $key=>$value ){
					if( empty($value) ){
						$emptystat= 1;
					}
				}
				
				// Jika data sudah terisi semua tambahkan ke score dan aktifkan next process
				$Aktif= 0;
				if( ! $emptystat ){
					$score+= $row["Score_Completion"];
					$rows[$ct]['Status']= "Complete";
				}else{
					$rows[$ct]['Status']= "Aktif";
				}
				$view[$tabel]= $formValue; // Data untuk tampilan Edit
			}else{
				$rows[$ct]['Status']= "Aktif";
			}
			$ct++;
		}
		
		$config= $this->config;
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['jscript']= $this->load->view("js/pro_detail.php", $data, TRUE);
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data["rows"]= $rows;
		$data["score"]= $score;
		$data["barisId"]= $barisId;
		$data["IdProject"]= $IdProject;
		$data["view"]= $view;
		$data["Project_Name"]= $project["Project_Name"];
		$this->themelib->getpage("project/detail", $data, "inc/theme_main");
	}*/
	
	public function action($type="", $IdProject=""){
		if( $type == "edit" ){
			$POST= $this->input->post();
			$IdProject= $POST["Project_ID"];
			unset($POST["submit"], $POST["type"], $POST["Project_ID"]);
			$this->db->where("Project_ID", $IdProject);
			$this->db->update("project", $POST);
			echo "success";
			exit;
		}else if( $type == "delete" ){
			$this->db->where('Project_ID', $IdProject);
			$hasil= $this->db->delete('project');
			redirect("project/daftar");
		}
	}
	
/*	// Method untuk render page ( refactor code aja )
	private function getpage($page, $data="", $theme=""){
		$POST= $this->input->post();
		$config= $this->config;
		
		$profile= array(
			'Profile'=> site_url("profile"),
			'LogOut'=> site_url("login/dologout")
		);
		
		// Set Parameter Data
		$data['imgpath']= $config->item('img_path');
		$data['csspath']= $config->item('css_path');
		$data['jspath']= $config->item('js_path');
		$data['bar_path']= $config->item('loading');
		$data['captcha']= base_url() . strtolower(__CLASS__) . "/captcha";
		$data['main_url']= base_url();
		$data['logOutHref']= base_url() . "login/dologout";
		$data['profile']= $profile;
		$data['Username']= $this->session->userdata("Username");

		if( isset($POST['type']) && $POST['type'] == "ajax" ){
			$data['type']= $POST['type'];
			echo $this->load->view($page, $data, TRUE);
		}else{
			// Set Path Parameters
			$data['page']= $page;
			$data['LeftNavigation']= $this->themelib->make_menu();
			$data['Content']= $this->themelib->getData($page, $data);
			$this->themelib->create($theme, $data);
		}
	}*/
	
	public function dialog($IdProcess, $IdProject, $action){		
/*		$IdProcess= 56;
		$IdProject= 47;
		$action= 'add';*/
		
		// Get ID dari Process / pos_menu
		$where= array("Id"=>$IdProcess);
		$process= $this->db->get_where("pos_menu", $where)->row_array();
		
		$FormID= $process["FormID"];
/*		$IdUsertype= "3"; // Sales
		$IdUsertype= "2"; // Supervisor*/
		$IdUsertype= $this->session->userdata("IdUsertype");
		if( ! empty($FormID) ){
			// Check Privilege Setting Pada Form
			$where= array('FormID'=>$FormID, 'IdUsertype'=>$IdUsertype);
			if( ! $this->db->get_where('config_fields', $where)->num_rows() ){
				echo "Set Privilege Form terlebih dahulu !";
				exit;
			}
			
			$sql= "SELECT b.FieldType, b.Label, b.Name, c.Privilege FROM masterform a 
			LEFT JOIN form_fields b ON b.FormID= a.FormID 
			LEFT JOIN config_fields c ON c.IdField= b.Id 
			WHERE a.FormID= '" . $FormID . "' AND c.IdUsertype= '" . $IdUsertype . "'";
			$fields= $this->db->query($sql)->result_array();
			
			// Jika Ada Field dengan Name PO_ID Disabled Field
			// Tambahkan Field Value untuk memudahkan pengisian pada View 
			foreach( $fields as $key=>$field ){
				$fields[$key]['Value']= '';
				if( $field['Name'] == "PO_ID" ){
					// Check Apakah PO_ID sudah di-Create
					$where= array('Project_ID'=>$IdProject);
					$query= $this->db->get_where('po_id', $where);
					$jml= $query->num_rows();
					
					if( $jml ){
						// Get Data PO_ID dari Project Ini
						$poid= $query->row_array();
						$poid_val= $poid['PO_ID'];
					}else{
						// Get PO_ID Format
						$poid_format= $this->db->get_where('poid_format')->row_array();
						
						// Get PO_ID Value
						$poid= $this->db->order_by('PO_ID', 'DESC')->limit('1')->get('po_id')->row_array();
						
						$jml= strlen($poid_format['Prefix']);
						$latest_poid= substr($poid['PO_ID'], $jml);
						$poid_val= $poid_format['Prefix'] . sprintf('%0' . $poid_format['Digit'] . 's', $latest_poid+1);
						
						// Insert Data to po_id Table
						$po_data= array('Project_ID'=>$IdProject, 'PO_ID'=>$poid_val);
						$this->Jmodel->insert('po_id', $po_data);
					}
					$fields[$key]['Value']= $poid_val;
					$fields[$key]['Privilege']= 'r|';
					$status_po= TRUE;
				}
			}
		}else{
			echo "Process ini belum memiliki Form yang di-set !";
			exit;
		}

		// Get Pos Menu untuk Title
		$pos= $this->db->get_where('pos_menu', array('Id'=>$IdProcess))->row_array();
		
		$config= $this->config;
		$IdProcess= strtolower($IdProcess);
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data['jscript']= $this->load->view("js/dialog.php", $data, TRUE);
		/*$data['jscript']= $this->load->view("js/" . $IdProcess. ".php", $data, TRUE);*/
		$data["caller"]= "dialog";
		$data["fields"]= $fields;
		/*$data['PO_ID']= "true";*/
		$data["Title"]= ucwords(str_replace("_", " ", $pos['Process_Name']));
		$data["action"]= $IdProcess . "/" . $IdProject;
		
		if( $action == "add" ){ // Add
/*			$this->themelib->notify_js= FALSE; 
			$this->themelib->getpage("dialog/add", $data, "inc/theme_main");*/
			if( isset($status_po) ){ // Add Hidden Field Untuk PO_ID
				$data["hiddenFields"]= array('PO_ID'=>$poid_val);
			}
			echo $this->load->view("dialog/add", $data, TRUE);
		}else{ // Edit
			$where= array("Id"=>$IdProcess);
			$row= $this->db->get_where("pos_menu", $where)->row_array();
			
			// Get Data Value Pada Form Process
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$row["Id"]);
			$form= $this->db->get_where("project_process", $where)->row_array();
			$formValue= unserialize($form["formValue"]); // Unserialize Data
			
			// Add Value to $fields Array
			$ct= 0;
			foreach( $fields as $field ){
				$fieldName= $field["Name"];
				if( $fieldName != "PO_ID" ){
					$fields[$ct]["Value"]= ( isset($formValue[$fieldName]) ) ? $formValue[$fieldName] : "";
				}
				$ct++;
			}
			
			// Hidden Field Data
			$data["hiddenFields"]= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$row["Id"]);
			if( isset($status_po) ){
				$PO_field= array('PO_ID'=>$poid_val);
				$data["hiddenFields"]= array_merge($data["hiddenFields"], $PO_field);
			}			
			$data["fields"]= $fields;
/*			echo "<pre>";
			print_r($fields);
			echo "<pre>";
			exit;*/
			echo $this->load->view("dialog/edit", $data, TRUE);
		}
	}
	
	public function process($IdProcess, $IdProject, $action){
		if( $action == "add" ){
			$POST= $this->input->post();
/*			echo "<pre>";
			print_r($POST);
			print_r($_FILES);
			echo "</pre>";
			exit;*/
			unset($POST["submit"], $POST["type"]);
			
			foreach( $_FILES as $key=>$Image ){
				if( !empty($Image['name']) ){
					// Create Directory
					$image_path= $this->config->item('assets_img');
					$image_path.= "project/" . $IdProject . "/" . $IdProcess;
					if( ! file_exists($image_path) ){
						if( ! mkdir($image_path, 0, TRUE) ){
							echo "Error terjadi, Silakan coba lagi !";
							exit;
						}
					}
					
					$extension= pathinfo($Image['name'], PATHINFO_EXTENSION); // Get Extension
					// Set Filename
					$filename= md5(random_string('unique') . date("Y-m-d H:i:s"));
					$filename.= "." . $extension;
					$tmp_file= $Image['tmp_name'];
					$fullpath= $image_path . "/" . $filename;
					
					// Upload File
					if( move_uploaded_file($tmp_file, $fullpath) ){
						// Insert Data Upload File Ke DBase
						$Upload= array(
						'Filename'=>$filename,
						'Description'=>$Image['name'],
						'AddDate'=>date('Y-m-d H:i:s'),
						);
						if( ! $this->Jmodel->insert('upload', $Upload) ){
							echo "Error terjadi, Silakan coba lagi !";
							exit;
						}
						$POST[$key]= $filename; // Add Filename to Post u/ insert data ke Tabel project_process
					}else{
						echo "Error terjadi, Silakan coba lagi !";
						exit;
					}
				}				
			}
			
			// Get ID Pos Menu 
			$where= array("Id"=>$IdProcess);
			$posmenu= $this->db->get_where("pos_menu", $where)->row_array();

			// Set Data Yang akan Di-insert
			$data= array();
			$data["formValue"]= serialize($POST);

			// Cek Apa Data ada pada Tabel project_process 
			$Posmenu_ID= $IdProcess;
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			if( $this->db->get_where("project_process", $where)->num_rows() ){
				// Update				
				$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
				$this->Jmodel->update("project_process", $data, $where);
				
				// Send Feedback
				$score= "";
				$msg= array("response"=>"success","score"=>$score);
				$msg= json_encode($msg);
				echo $msg;
				exit;
			}else{
				// Set Data
				$data["Project_ID"]= $IdProject;
				$data["Posmenu_ID"]= $Posmenu_ID;
				
				// Insert Data, Update Score
				if( $this->Jmodel->insert("project_process", $data) ){
					/*$score= $this->updateScore($IdProject);*/
					$score= "";
					$msg= array("response"=>"success","score"=>$score);
					$msg= json_encode($msg);
					echo $msg;
					exit;
				}
			}
		}else{
			$POST= $this->input->post();
			unset($POST["submit"], $POST["type"], $POST["Project_ID"], $POST["Posmenu_ID"]);
			extract($POST);
			
			foreach( $_FILES as $key=>$Image ){
				if( !empty($Image['name']) ){
					// Create Directory
					$image_path= $this->config->item('assets_img');
					$image_path.= "project/" . $IdProject . "/" . $IdProcess;
					if( ! file_exists($image_path) ){
						if( ! mkdir($image_path, 0, TRUE) ){
							echo "Error terjadi, Silakan coba lagi !";
							exit;
						}
					}
					
					$extension= pathinfo($Image['name'], PATHINFO_EXTENSION); // Get Extension
					// Set Filename
					$filename= md5(random_string('unique') . date("Y-m-d H:i:s"));
					$filename.= "." . $extension;
					$tmp_file= $Image['tmp_name'];
					$fullpath= $image_path . "/" . $filename;
					
					// Upload File
					if( move_uploaded_file($tmp_file, $fullpath) ){
						// Insert Data Upload File Ke DBase
						$Upload= array(
						'Filename'=>$filename,
						'Description'=>$Image['name'],
						'AddDate'=>date('Y-m-d H:i:s'),
						);
						if( ! $this->Jmodel->insert('upload', $Upload) ){
							echo "Error terjadi, Silakan coba lagi !";
							exit;
						}
						$POST[$key]= $filename;
					}else{
						echo "Error terjadi, Silakan coba lagi !";
						exit;
					}
				}
			}
			
			// Get ID Pos Menu
			$where= array("Id"=>$IdProcess);
			$pos_row= $this->db->get_where("pos_menu", $where)->row_array();
			$Posmenu_ID= $pos_row["Id"];
			
			// Get Previous Value dari Form Process
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			$form= $this->db->get_where("project_process", $where)->row_array();
			$formValue= unserialize($form["formValue"]);
			
			$fileField= array();
			$regfile= "#^.+\..{3,4}$#";
			foreach( $POST as $key=>$value ){
				if( preg_match($regfile, $value) ){					
					// Delete Data pada Tabel upload
					$where= array('Filename'=>$formValue[$key]);
					$this->db->delete('upload', $where);
					
					// Delete File Pada Direktori
					$imgpath= $this->config->item('assets_img');
					$fullpath= $imgpath . "project/" . $IdProject . "/" . $IdProcess . "/" . $formValue[$key];
					unlink($fullpath);					
				}
			}
			
			// Merge Existing Data dengan New Input Lalu di-serialize
			$formValue= array_merge($formValue, $POST);
			$data= array("formValue"=>serialize($formValue));
			
/*			echo "<pre>";
			print_r($data);
			echo json_encode($data);
			echo "</pre>";
			exit;*/
			// Update Data dan Kirim Feedback
			$where= array("Project_ID"=>$IdProject, "Posmenu_ID"=>$Posmenu_ID);
			$jml= $this->Jmodel->update("project_process", $data, $where);
			if( $jml != -1 ){
				$msg= array("response"=>"success","score"=>0);
				$msg= json_encode($msg);
				echo $msg;
				exit;
			}
		}
	}	
/*	public function dialog($IdProcess, $IdProject, $action){
		// Get ID dari Process / pos_menu
		$where= array("Table"=>$IdProcess);
		$process= $this->db->get_where("pos_menu", $where)->row_array();
		
		// Get active Field sesuai Pos Menu dan Usertype
		$where= array("IdPosMenu"=>$process["Id"], "IdUsertype"=>$this->session->userdata("IdUsertype"));
		$rows_field= $this->db->get_where("setting_fields", $where)->row_array();
		$active_field= explode(",", $rows_field["Fields"]);
		
		$rows= $this->db->list_fields(strtolower($IdProcess));
		$fields= array(); // Simpan Data seluruh fields
		$ct= 1;
		foreach( $rows as $key=>$value ){
			if( $value != "Project_ID" ){ // Simpan Data selain Project_ID field
				$fields[$ct]= $value;
				$ct++;
			}
		}
		
		// Hapus data Fields yang aktif, Simpan disable Fields
		$disable_fields= array();
		foreach( $fields as $key=>$field ){
			if( ! in_array($key, $active_field)){
				$disable_field[]= $field;
			}
		}
		
		$disable_fields= "";
		if( ! empty($disable_field) ){
			$disable_fields= implode(",", $disable_field); // String dg separate comma untuk ke JS
		}
				
		$config= $this->config;
		$IdProcess= strtolower($IdProcess);
		$data= array();
		$data['bar_path']= $config->item('loading');
		$data['main_url']= base_url();
		$data['menu']= $this->load->view("inc/menu.php", $data, TRUE);
		$data['disable_fields']= $disable_fields;
		$data['jscript']= $this->load->view("js/" . $IdProcess. ".php", $data, TRUE);
		$data["caller"]= "dialog";
		$data["action"]= $IdProcess . "/" . $IdProject;
		
		if( $action == "add" ){
			echo $this->load->view($IdProcess . "/add", $data, TRUE);
		}else{
			$where= array("Project_ID"=>$IdProject);
			$data["row"]= $this->db->get_where($IdProcess, $where)->row_array();
			$this->db->flush_cache();
			echo $this->load->view($IdProcess . "/edit", $data, TRUE);
		}		
	}
	
	public function process($IdProcess, $IdProject, $action){
		if( $action == "add" ){
			$POST= $this->input->post();
			
			echo "<pre>";
			print_r($POST);
			echo "</pre>";
			exit;
			
			$POST["Project_ID"]= $IdProject;
			unset($POST["submit"], $POST["type"]);
			
			// Pengecekan untuk HALAMAN IDENTIFIED PROJECT 
			if( isset($POST["Identitas_Perusahaan"]) ){
				$where= array("Identitas_Perusahaan"=>$POST["Identitas_Perusahaan"]);
				$jml= $this->db->get_where($IdProcess, $where)->num_rows();
				if( $jml ){
					$msg= array("response"=>"Identitas Perusahaan is already exists", "score"=>0);
					$msg= json_encode($msg);
					echo $msg;
					exit;
				}
			}
			
			// Check u/ memastikan jika Kedua Usertype sudah membuka Dialog add bersamaan
			// Jika Id Project sudah ada update data sebelumnya
			$where= array("Project_ID"=>$IdProject);
			if( $this->db->get_where($IdProcess, $where)->num_rows() ){
				// Update
				$where= array("Project_ID"=>$IdProject);
				$this->Jmodel->update($IdProcess, $POST, $where);
				
				// Send Feedback
				$score= "";
				$msg= array("response"=>"success","score"=>$score);
				$msg= json_encode($msg);
				echo $msg;
				exit;
			}
			
			// Insert Data, Update Score
			if( $this->Jmodel->insert($IdProcess, $POST) ){
				$score= $this->updateScore($IdProject);
				$msg= array("response"=>"success","score"=>$score);
				$msg= json_encode($msg);
				echo $msg;
				exit;
			}
		}else{
			$POST= $this->input->post();
			unset($POST["submit"], $POST["type"]);
			extract($POST);
			
			// Update Data dan Kirim Feedback
			$where= array("Project_ID"=>$IdProject);
			$jml= $this->Jmodel->update($IdProcess, $POST, $where);
			if( $jml != -1 ){
				$msg= array("response"=>"success","score"=>0);
				$msg= json_encode($msg);
				echo $msg;
				exit;
			}
		}
	}	
*/			
}
?>