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

class Mycontroller extends CI_Controller {

	function __construct()
	{
		parent::__construct(); //call constructor
		$this->load->model('spry_model'); // loding model
		$this->load->database();  //loading database
		$this->load->helper(array('form','url'));  //loading form and url helper
		$this->load->helper('date_helper.php'); //loading date helper
		$this->load->library('session');    //loading session library
		$this->load->library('form_validation'); //loading form validation library
	}

function index()
	{
		$this->admin();
	}
	function admin()
	{
		$this->load->view('login_view');
	}
	function submit() //submit function to login
	{
		$uname = $this->input->post('uname');
		$password = $this->input->post('pwd');
		if($this->spry_model->checkUserAvailability($uname,$password)==1) {//checkUserAvailability function to check user avaibility
			$this->session->set_userdata('user_name', $uname);
			redirect('mycontroller/showwelcome');
		}else {
			echo "username is invalid";
		}
	}
	function showwelcome(){ //showwelcome function to set session variable
		$userName = $this->session->userdata('user_name');
		if($userName != "")
		$this->load->view('welcome');
		else
		$this->load->view('login_view');
	}
	function user() //user function to set session variable and view group management page
	{
		$userName = $this->session->userdata('user_name');
		$arrUser = $this->spry_model->getUserDetails();


		if($userName != ""){

			$data['arrUser']=$arrUser;
			$this->load->view('user', $data);
		}
		else
		$this->load->view('login_view');
	}
	function group()//group function to set session variable and view group management page
	{
		$userName = $this->session->userdata('user_name');
		$arrUser = $this->spry_model->getGroupDetails();
		if($userName != ""){
			$data['arrUser']=$arrUser;
			$this->load->view('group',$data);
		}
		else
		$this->load->view('login_view');
	}
	function form()//group function to set session variable and view group management page
	{
		$userName = $this->session->userdata('user_name');
		$arrUser = $this->spry_model->getFormDetails();
			$arrUser1 = $this->spry_model->getGroupNames();
		if($userName != ""){
			$data1['group']=$arrUser1;
		$data['arrUser']=$arrUser;
		$this->load->view('form',$data,$data1);
		}
		else
		$this->load->view('login_view');
	}
	function adduser()//adduser function to add user in database and for form validation
	{
		$username = $this->input->post('uname');
		$password = $this->input->post('password');
		$cpassword = $this->input->post('cpassword');
		$email = $this->input->post('email');
		$group = $this->input->post('gname');
		$isactive = $this->input->post('isactive');
		$isadmin = $this->input->post('isadmin');
 $this->form_validation->set_message('required', 'Please select %s');
		$this->form_validation->set_rules('uname', 'Username', 'required');
		$this->form_validation->set_rules('password', 'Password', 'required|matches[cpassword]');
		$this->form_validation->set_rules('cpassword', 'Password Confirmation', 'required');
		$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
		$this->form_validation->set_rules('gname', 'Group name', 'required');
		$this->form_validation->set_rules('isactive', 'IsActive', 'required');
		$this->form_validation->set_rules('isadmin', 'IsAdmin', 'required');
		if ($this->form_validation->run() == TRUE){
		$arrUser = array();
		$arrUser['username'] = $username;
		$arrUser['password'] = $password;
		$arrUser['email'] = $email;
		$arrUser['group'] = $group;
		$arrUser['isactive'] = $isactive;
		$arrUser['isadmin'] = $isadmin;
			$arrUser['cd'] = now();
		if($this->spry_model->checkUserAvailability($username,$password) == 0) {
			if($this->spry_model->insertUser($arrUser) == 1){
				$this->session->set_flashdata('item', 'Member added successfully!');

				redirect('/mycontroller/user');
			} else
			$this->session->set_flashdata('item', 'Database error occured');

			redirect('/mycontroller/user');
		} else{
			$this->session->set_flashdata('item', 'Username is not available try something else!');

			redirect('/mycontroller/user');
		}}
		else {
		$this->load->view('adduser_view');
		}
	}
	function addgroup()//addgroup function to add user in database and for form validation
	{
		echo date('Y-m-d H:i:s');
		$groupname = $this->input->post('gname');
		$isactive = $this->input->post('isactive');
		$arrUser = array();
		$arrUser['group_name'] = $groupname;
		$arrUser['isactive'] = $isactive;

	$arrUser['create_time'] = date('Y-m-d H:i:s');

		if($this->spry_model->checkGroupAvailability($groupname) == 0) {
			if($this->spry_model->insertGroup($arrUser) == 1){
				$this->session->set_flashdata('item', 'Group added successfully!');
				redirect('/mycontroller/group');
			} else
			$this->session->set_flashdata('item', 'Database error occured');
			redirect('/mycontroller/group');
		} else{
			$this->session->set_flashdata('item', 'Groupname is not available try something else!');
			redirect('/mycontroller/group');
		}
	}
	function addform()//addform function to add user in database and for form validation
	{
		$formname = $this->input->post('fname');
		$groupname = $this->input->post('gname');
		$isactive = $this->input->post('isactive');
		$formcontent = $this->input->post('content');
		$arrUser = array();
		$arrUser['cd'] = now();
		$arrUser['group_name'] = $groupname;
		$arrUser['form_name'] = $formname;
		$arrUser['isactive'] = $isactive;
		$arrUser['content'] = $formcontent;


		if($this->spry_model->checkFormAvailability($formname) == 0) {
			if($this->spry_model->insertForm($arrUser) == 1){
				$this->session->set_flashdata('item', 'Group added successfully!');
				redirect('/mycontroller/group');
			} else
			$this->session->set_flashdata('item', 'Database error occured');
			redirect('/mycontroller/group');
		} else{
			$this->session->set_flashdata('item', 'Groupname is not available try something else!');
			redirect('/mycontroller/group');
		}
	}

	function logout()//logout function to logout,unset and destroy destroy session variable
	{
		$this->session->unset_userdata('user_name');
		$this->session->sess_destroy();
		redirect(base_url());

	}
	function edituser()//edituser function is to get user to edit their profile
	{
		$arrUser1 = $this->spry_model->getGroupNames();
	if(isset($_POST['id'])){
		$uid = $this->input->post('id');
		$arrUser = $this->spry_model->UserDetails($uid);

	$data1 = array();

$data1['user'] = $arrUser;
$data1['group']=$arrUser1;
		$this->load->view('user_view',$data1);
	}
	else
	{
		$data3['group']=$arrUser1;
		$this->load->view('adduser_view',$data3);
	}
	}
function editgroup()//editform function is to edit form and update form
	{
		if(isset($_POST['id'])){
		$gid = $this->input->post('id');
		$arrUser = $this->spry_model->GroupDetails($gid);
		$userdata['group']=$arrUser;
		$this->load->view('updategroup_view', $userdata);
		}
		else {

		$this->load->view('group_view');
		}

	}
function deleteuser()//deleteuser function is to delete user
	{
		$uid = $this->uri->segment(3);
		 if($this->spry_model->DeleteUser($uid)  == 1){
		 	$this->session->set_flashdata('item', 'User deleted successfully!');
				redirect('/mycontroller/user');
		 }
		$this->session->set_flashdata('item', 'Some error occured');
			redirect('/mycontroller/user');
	}
function deletegroup()//deletegroup function is to delete group
	{
		$gid = $this->uri->segment(3);
		 if($this->spry_model->DeleteGroup($gid)  == 1){
		 	$this->session->set_flashdata('item', 'Group deleted successfully!');
				redirect('/mycontroller/group');
		 }
		$this->session->set_flashdata('item', 'Some error occured');
			redirect('/mycontroller/group');
	}
function deleteform()//deleteform function is to delete form
	{
		$fid = $this->uri->segment(3);
		 if($this->spry_model->DeleteForm($fid)  == 1){
		 	$this->session->set_flashdata('item', 'Form deleted successfully!');
				redirect('/mycontroller/form');
		 }
		$this->session->set_flashdata('item', 'Some error occured');
			redirect('/mycontroller/form');
	}
function userUpdate()//to update after edit user profile
	{
		$id = $this->input->post('id');
		$username = $this->input->post('uname');
		$password = $this->input->post('password');
		$cpassword = $this->input->post('cpassword');
		$email = $this->input->post('email');
		$group = $this->input->post('gname');
		$isactive = $this->input->post('isactive');
		$isadmin = $this->input->post('isadmin');
		 $this->form_validation->set_message('required', 'Please select %s');
		$this->form_validation->set_rules('uname', 'Username', 'required');
		$this->form_validation->set_rules('password', 'Password', 'required|matches[cpassword]');
		$this->form_validation->set_rules('cpassword', 'Password Confirmation', 'required');
		$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
		$this->form_validation->set_rules('gname', 'Group name', 'required');
		$this->form_validation->set_rules('isactive', 'IsActive', 'required');
		$this->form_validation->set_rules('isadmin', 'IsAdmin', 'required');
		  if ($this->form_validation->run() == TRUE){
		$arrUser = array();
		$arrUser['username'] = $username;
		$arrUser['password'] = $password;
		$arrUser['group'] = $group;
		$arrUser['isactive'] = $isactive;
		$arrUser['isadmin'] = $isadmin;
		$arrUser['email'] = $email;

		if($this->spry_model->updateUser($arrUser, $id)){
				$this->session->set_flashdata('item', 'Updated successfully!');
				redirect('/mycontroller/user');
		} else {
			$this->session->set_flashdata('item', 'Error Occured!');
				redirect('/mycontroller/user');
		}}
		else {
		$this->load->view('user_view');
		  }

	}
	function updategroup()//to update after edit group
		{
		$gid = $this->input->post('id');
		$gname = $this->input->post('gname');
			$isactive = $this->input->post('isactive');
			$arrUser = array();
			$arrUser['group_name'] = $gname;
			$arrUser['isactive'] = $isactive;
	if($this->spry_model->updateGroup($arrUser, $gid)){
				$this->session->set_flashdata('item', 'Updated successfully!');
				redirect('/mycontroller/group');
		} else {
			$this->session->set_flashdata('item', 'Error Occured!');
				redirect('/mycontroller/group');
		}

	}
}