content_old.php | searchcode

/application/controllers/content_old.php

https://gitlab.com/wildanoo/E-procurement
PHP | 342 lines | 271 code | 65 blank | 6 comment | 24 complexity | 54c502dfb6db3dbc6d401d608e4dc7de MD5 | raw file

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

if ( ! class_exists('Controller'))
{
	class Controller extends CI_Controller {}
}

class Content extends Controller {

	function __construct()
	{
		parent::__construct();	
		//$this->load->model('m_category', 'm_category');
		$this->load->model('crud', 'crud');
		$this->load->library('session');
		$this->limit = 5;
	}	
	
	function index(){
		if ($this->tank_auth->is_logged_in()) {
	
			$data['user_id']	= $this->tank_auth->get_user_id();
			$data['username']	= $this->tank_auth->get_username();
				
			$sess_like  = $this->session->flashdata('like');
	
			$table 	    = "content_type";
			$page       = $this->uri->segment(3);
			$per_page   = 5;
			$offset     = $this->crud->set_offset($page,$per_page);
			$total_rows = $this->crud->get_total_record("",$table);
			$set_config = array('base_url'=> base_url().'/content/index','total_rows'=>$total_rows,'per_page'=>5,'uri_segment'=>3);
			$config     = $this->crud->set_config($set_config);
				
			$this->load->library('pagination');
			$this->pagination->initialize($config);
			$paging = $this->pagination->create_links();
	
			$order 			     = array('field'=>'created_date','order'=>'DESC');
			$data['pagination']  = $paging;
			$data['num']         = $offset;
			$select 			 = "id,type_name,status,(SELECT username FROM users WHERE id=created_id)as created_id,created_date,last_updated";
				
			if($sess_like){
				$like   = array('col'=>'type_name','field'=>$sess_like);
				$browse = $this->crud->browse("",$table." l","","","true",$select,"","","",$like);	} else {
					$browse = $this->crud->browse_with_paging("",$table." l","","","true",$select,"",$order,$config['per_page'],$offset); }
	
					$data['browse'] = $browse;
					$data['view']	= "content/browse";
					$this->load->view('layout/template',$data);
	
	
		} else {
			$this->session->set_flashdata('message','user not authorized');
			redirect('/auth/login/');
		}
	}
	
	function get_cat_tags(){
		$term   = $_GET['term'];
		$order  = array('field'=>'type_name','sort'=>'ASC'); $select = "type_name as name";
		$result = $this->crud->autocomplete("","content_type",$select,"type_name",$term,"",$order);
		echo json_encode($result);
	}
	
	function get_tags(){
		$term   = $_GET['term'];
		$order  = array('field'=>'type_name','sort'=>'ASC'); $select = "type_name as name";
		$result = $this->crud->autocomplete("","content_type",$select,"type_name",$term,"",$order);
		echo json_encode($result);
	}
	
	function set_sess_search(){
		$like = $_POST['search'];
		$this->session->set_flashdata('like',$like);
	}
	
	function is_exist(){
		$content	  = $_POST['type_name'];
		$is_exist['1']= !$content ? "false" : "true";
		$msg['1']	  = !$content ? "content name required" : "";
	
		if ($is_exist['1']=='true'){
			$where   = array('type_name'=>$content);
			$checked = $this->crud->is_exist("","content_type","id",$where);
			$is_exist['1']    = !$checked ? "true" : "false";
			$msg['1']	= $checked ? "duplicate content name" : "";
	
		}
		$status = in_array('false', $is_exist) ? "false" : "true";
		$result = array('status'=>$status,'msg' =>$msg['1']);
	
		echo json_encode($result);
	}
	
	function create(){
		//$init_code  = $this->m_category->category_code("category");
		$curr_date 	= date('Y-m-d H:i:s'); $userID = $this->tank_auth->get_user_id();
		$data 		= array('id'=>null,
							'type_name'=>$_POST['type_name'],
							'status'=>'1',
							'created_id'=>$userID,
							'created_date'=>$curr_date,
							'last_updated'=>$curr_date);
		$id = $this->crud->insert("","content_type",$data);
		$this->session->set_flashdata('message','1 data success insert');
	}
	
	function form_update(){
		$id 				   = $this->uri->segment(3);
		$select 			   = "id,(SELECT id FROM content_type r WHERE r.id=l.content_id) as content_id, subtype_name,status,created_date,last_updated";
		$def				   = $this->crud->browse("","subcontent_type l","id",$id,"false",$select);
		$data['def']  		   = $def ;
		$content 			   = $this->crud->browse("","content_type","","","true","id,type_name");
		//print_r($content);
		$id   				   = $this->uri->segment(3);
		$select 			   = "id,type_name,created_id,last_updated";
		$data ['def'] 		   = $this->crud->browse ( "", "content_type", "id", $id, "false", $select);
		$this->load->view ('content/form_update', $data );
	}
	
	function form_update1(){
		$id 				   = $this->uri->segment(3);
		$select 			   = "id,init_code,(SELECT id FROM category r WHERE r.id=l.id_cat) as id_cat, subcategory,created_date,last_updated";
		$def				   = $this->crud->browse("","subcategory l","id",$id,"false",$select);
		$data['def']  		   = $def ;
		$category 			   = $this->crud->browse("","category","","","true","id,category");
	
		$id   = $this->uri->segment(3);
		$select = "id,init_code,category,created_id,last_updated";
		$data ['def'] = $this->crud->browse ( "", "category", "id", $id, "false", $select);
		$this->load->view ( 'supplier/category/form_update', $data );
	}
	
	function form_create(){
		$data ['user_id'] = $this->tank_auth->get_user_id ();
		$data ['username'] = $this->tank_auth->get_username ();
		$this->load->view('content/form_create', $data);
	}
	
	function update(){
		$curr_date =  date('Y-m-d H:i:s'); $userID = $this->tank_auth->get_user_id();
		$data = array('type_name'=>$_POST['type_name'],'last_updated'=>$curr_date);
		$this->crud->update("","content_type","id",$_POST['id'],$data);
		$this->session->set_flashdata('message','1 data success update');
	}
	
	function delete(){
	
		$id = $this->uri->segment(3);
		$where = array('content_id'=>$id);
		$checked = $this->crud->is_exist("","subcontent_type","id",$where);
		if ($checked) {
			$this->session->set_flashdata('msg_warning','This data is already in use');
		}
		else {
			$this->crud->delete("","content_type","id",$id);
		}
		$this->session->set_flashdata('message','1 data success deleted');
		redirect('content/','refresh');
	
	}
	
	function subcontent(){
		if ($this->tank_auth->is_logged_in()) {
	
			$data['user_id']	= $this->tank_auth->get_user_id();
			$data['username']	= $this->tank_auth->get_username();
	
			$sess_like  = $this->session->flashdata('like');
	
			$table 	    = "subcontent_type";
			$page       = $this->uri->segment(3);
			$per_page   = 5;
			$offset     = $this->crud->set_offset($page,$per_page);
			$total_rows = $this->crud->get_total_record("",$table);
			$set_config = array('base_url'=> base_url().'/content/subcontent','total_rows'=>$total_rows,'per_page'=>5,'uri_segment'=>3);
			$config     = $this->crud->set_config($set_config);
	
			$this->load->library('pagination');
			$this->pagination->initialize($config);
			$paging = $this->pagination->create_links();
	
			$order 			     = array('field'=>'created_date','order'=>'DESC');
			$data['pagination']  = $paging;
			$data['num']         = $offset;
			$select 			 = "id,(SELECT type_name FROM content_type r WHERE r.id=l.content_id)as content_id,
									subtype_name,status,(SELECT username FROM users WHERE id=created_id)as created_id,
									document_req,created_date,last_updated";
	
			if($sess_like){
				$like   = array('col'=>'subtype_name','field'=>$sess_like);
				$browse = $this->crud->browse("",$table." l","","","true",$select,"","","",$like);	} else {
				$browse = $this->crud->browse_with_paging("",$table." l","","","true",$select,"",$order,$config['per_page'],$offset); }
	
				$data['browse'] = $browse;
				//print_r($data['browse']);
				$data['view']	= "subcontent/browse";
				$this->load->view('layout/template',$data);
	
	
		} else {
			$this->session->set_flashdata('message','user not authorized');
			redirect('/auth/login/');
		}
	}
	
	function get_subcontent_tags(){
		$term   = $_GET['term'];
		$order  = array('field'=>'subtype_name','sort'=>'ASC'); $select = "subtype_name as name";
		$result = $this->crud->autocomplete("","subcontent_type",$select,"subtype_name",$term,"",$order);
		echo json_encode($result);
	}
	
	function set_sess_search_subcontent(){
		$like = $_POST['search'];
		$this->session->set_flashdata('like',$like);
	}
	
	function is_exist_subcontent(){
		$content	  = $_POST['content_id'];
		$subcontent	  = $_POST['subtype_name'];
		$is_exist['1']= !$content ? "false" : "true";
		$is_exist['2']= !$subcontent ? "false" : "true";
		$msg['1']	  = !$content ? "content name required" : "";
		$msg['2']	  = !$subcontent ? "subcontent name required" : "";
	
		if ($is_exist['1']=='true' && $is_exist['2']=='true'){
			$where   = array('content_id'=>$content, 'subtype_name'=>$subcontent);
			$checked = $this->crud->is_exist("","subcontent_type","id",$where);
			$is_exist['1']    = !$checked ? "true" : "false";
			$is_exist['2']    = !$checked ? "true" : "false";
			$msg['1']	= $checked ? "duplicate content name" : "";
			$msg['2']	= $checked ? "duplicate subcontent name" : "";
	
		}
		$status = in_array('false', $is_exist) ? "false" : "true";
		$result = array('status'=>$status,'msg1' =>$msg['1'], 'msg2' =>$msg['2']);
	
		echo json_encode($result);
	}
	
	function form_create_subcontent(){
		$content = $this->crud->browse("","content_type","","","true","id,type_name");
		if(!$content) $content = array();
		$select = array(''=>'-- Select --');
		foreach($content as $val){ $options[$val->id] = $val->type_name; }
		$data['content'] = $select + $options;
		
		$behavior = $this->crud->browse("","behavior","","","true","id,behavior");
		if(!$behavior) $behavior = array();
		$select2 = array(''=>'-- Select --');
		foreach($behavior as $val){ $options2[$val->id] = $val->behavior; }
		$data['behavior'] = $select2 + $options2;
		
		$data['doc']  = $this->crud->browse("","document_req","","","true","id,document_req");
		$this->load->view('subcontent/form_create',$data);
	}
	
	function create_subcontent(){
		$ttl   		  = $_POST['ttl'];
		$subtype  	  = $_POST['subtype_name'];
		$document_req = "";
		$where 	      = array('subtype_name'=>$subtype);
		$is_exist     = $this->crud->is_exist("","subcontent_type","id",$where);
		
		for ($i = 1; $i <= $ttl; $i++) {
			$value = $this->input->post('check'.$i);
			if($value) $doc[] = $value; }
		
			if($doc){ $document_req = implode(",",$doc); }
			$data = array('id'			 => null,
							'content_id'	=> $_POST['content_id'],
							'subtype_name'	=> $_POST['subtype_name'],
							'behavior_id'	=> $_POST['behavior_id'],
							'document_req'	=> $document_req,
							'created_id'	=> $this->tank_auth->get_user_id(),
							'created_date'  => date('Y-m-d H:i:s'),
							'last_updated'  => date('Y-m-d H:i:s'));
		
			if(!$is_exist){
				$this->crud->insert("","subcontent_type",$data); }
					
				$msg1 = "succesfully add new document";
				$msg2 = "duplicate group document";
				$msg  = !$is_exist ? $msg1 : $msg2;
				//print_r($data);exit;
		
		$this->session->set_flashdata('message','1 data success insert');
	}
	
	function form_update_subcontent(){

		$id = $this->uri->segment(3);
		$select = "id,(SELECT id FROM content_type WHERE id=content_id) as content_id,subtype_name,document_req,created_id,created_date,last_updated";
		$def    = $this->crud->browse("","subcontent_type l","id",$id,"false",$select);
		$data['def'] = $def ;
		$content = $this->crud->browse("","content_type","","","true","id,type_name");
		if(!$content) $content = array();
		$select = array(''=>'-- Select --');
		foreach($content as $val){ $options[$val->id] = $val->type_name; }
		$data['content'] = $select + $options;
		
		$order  = array('field'=>'document_req','sort'=>'ASC');
		
		$data['doc']  = $this->crud->browse("","document_req","","","true","id,document_req","",$order);
		
		$this->load->view('subcontent/form_update',$data);
	}
	
	function update_subcontent(){
		$ttl   		 = $_POST['ttl'];
		$id  		 = $_POST['id'];
		$doc		 = "";
		$document	 = "";
		for ($i = 1; $i <= $ttl; $i++) {
			$value = $this->input->post('check'.$i);
			if($value) $doc[] = $value; }
			
			if($doc) $document = implode(",",$doc);
			$update = array('document_req'  => !$document ? "" : $document,
							'id'			=>$id,
							'content_id'	=>$_POST['content_id'],
							'subtype_name'  =>$_POST['subtype_name'],
							'last_updated'  => date('Y-m-d H:i:s'));
			 $this->crud->update("","subcontent_type","id",$id,$update);
			//print_r($update);
			
		$this->session->set_flashdata('message','1 data success update');
		redirect('content/','refresh');
	}
	
	function delete_subcontent(){
	
		$id = $this->uri->segment(3);
		$this->crud->delete("","subcontent_type","id",$id);
		$this->session->set_flashdata('message','1 data success deleted');
		redirect('content/subcontent/','refresh');
	
	}
}