.-.-.-.-.-

<?php

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

class Ledger extends CI_Controller {

public $menu;

function __construct() {
        parent::__construct();
        isLoggedIn();
        $this->load->model('ledger/Ledger_model');
        $this->load->model('ledger/Ledger_under_chk_model');
		$this->load->model('group/Group_model');
    }

//Account form
    public function index() {
        if(hasPermission('ledger_create')){

$page_data['page_title'] = 'Manage Ledger';
        $page_data['page_name'] = 'admin/ledger/ledger';

$this->load->view('admin/template', $page_data);
    }else{
        redirect(base_url('dashboard'));
    
    }
    }

public function add() {
        if(hasPermission('ledger_create')){
         //$group_name = $this->Group_model->getgroupsname()->result_array();
        $under_ledger = $this->Ledger_under_chk_model->ledger_under_validation()->result_array();

$page_data['page_title'] = 'Create Ledger';
        $page_data['page_name'] = 'admin/ledger/add';
       $page_data['group_name'] = $under_ledger;

$this->load->view('admin/template', $page_data);
    }else{
        redirect(base_url('dashboard'));
    
    }
    }

function getgroups() {
        $CI = & get_instance();
        $CI->load->model('Ledger_model');
        echo $this->Ledger_model->getgroupsname();
    }

//echo $this->db->last_query();

$data = array();
        $start = $_POST['start'];

$count_row = 0;
        $count_filtered = 0;

//print_r($list);

foreach ($list as $ledger) {

$row = array();

$ledger_id = $ledger['ledger_id'];

$ledger_name = ucwords($ledger['ledger_name']);

$group_name = ucwords($ledger['group_name']);
            $pan_no = ucwords($ledger['pan_no']);
            $gst_no = ucwords($ledger['gst_no']);
            $place = ucwords($ledger['place']);
            $address = ucwords($ledger['address']);
            $editUrl = base_url("ledger/edit/$ledger_id");
           $delUrl = base_url("ledger/active");
            $deleteUrl = base_url("ledger/delete");

$is_parent = $ledger['is_parent'];

$status = $ledger['status'];

$status_class = ($status == 1) ? "label label-primary" : "label label-danger";
            $status_lable = ($status == 1) ? "Active" : "Inactive";
            $status_title = ($status == 1) ? "Active" : "Inactive";
            $status_padding = ($status == 1) ? "padding-left: 10px ;padding-right: 10px;" : "";
            $active = '<center class="xs-disply-inline"> <span class="' . $status_class . '" title="' . $status_title . '"style="' . $status_padding . '" >' . $status_lable . '</span> </center>';

$btn_title_change = ($status == 1) ? "Deactivate" : "Activate";
            $btn_color_change = ($status == 1) ? "btn btn-danger" : "btn btn-info";
            $btn_padding = ($status == 0) ? "padding-right:18px;padding-left:18px" : "";
            $data_status = ($status == 1) ? '0' : '1';
            $action = '<center>';
            
          
            if (hasPermission('ledger_update') || hasPermission('ledger_delete')|| hasPermission('ledger_update')) {
            
            $action .='<div class="dropdown  col-sm-6  pl-xs-0 xs-text-left text-center xs-disply-inline">  <a class="dropdown-toggle" type="" data-toggle="dropdown"> <i class="glyphicon glyphicon-option-horizontal fs-24"></i></a>
  
    <ul class="dropdown-menu dropdown-menu-right">';
    if (hasPermission('ledger_update')) {
        $action .=  '<li><a href="' . $editUrl . '">Edit   </a> </li>';
    }
    if (hasPermission('ledger_status')) {
	
	 $action .='<li><a href="javascript:void(0);" data-id="' . $ledger_id . '" data-msg="' . $group_name . '" class="active_status" data-status="' . $data_status . '" data-label="quality name" data-url="' . $delUrl . '">  ' . $btn_title_change . '</a></li>';
       }
       if (hasPermission('ledger_delete')) {
        $action .='<li><a href="javascript:void(0);" data-id="' . $ledger_id . '" data-msg="' . $group_name . '" class="delete" data-status="2" data-label="Ads name" data-url="' . $deleteUrl . '">  Delete </a></li></ul></div>';
             }
             }

$action .= '</center>';

//$row[] = $prname;

$row[] = $start + 1;

$row[] = $ledger_name;
            $row[] = $group_name;
            $row[] = $pan_no;
            $row[] = $gst_no;
            $row[] = $place;
            $row[] = $address;
            $row[] = ($is_parent == 0) ? $action : "";

$row['DT_RowId'] = $ledger_id;

$data[] = $row;
            $start++;
        }

$output = array(
            "draw" => $_POST['draw'],
            "recordsTotal" => $this->Ledger_table->count_all(),
            "recordsFiltered" => $this->Ledger_table->count_filtered(),
            "data" => $data,
        );

//output to json format
        echo json_encode($output);
    }

public function insert() {
        $error_type = '';
        $msg = '';
        $result = false;
        $accounts_group_id = $this->input->post('id');

$this->form_validation->set_rules('ledger_name', 'Name', 'trim|required|min_length[1]|max_length[255]');
        $this->form_validation->set_rules('ledger_under', 'Under', 'trim|required');
      // $this->form_validation->set_rules('id', 'Id', 'trim|required');
        if ($accounts_group_id == 8) {
            $this->form_validation->set_rules('pan_no', 'PAN No', 'trim|required|min_length[10]|max_length[10]');
            $this->form_validation->set_rules('gst_no', 'GST No', 'trim|required|min_length[15]|max_length[15]');
            $this->form_validation->set_rules('place', 'Place', 'trim|min_length[1]|max_length[255]');
            $this->form_validation->set_rules('address', 'Address', 'trim|min_length[1]|max_length[255]');
        }

if ($this->form_validation->run() == FALSE) {

$error_type = 'v';
            $msg = validation_errors('<p class="error">', '</p>'); //validation_errors(); 	
            $result = false;
        } else {

$data = array(
                'ledger_name' => $this->input->post('ledger_name'),
                'accounts_group_id' => $this->input->post('ledger_under'),
                'pan_no' => $this->input->post('pan_no'),
                'gst_no' => $this->input->post('gst_no'),
                'place' => $this->input->post('place'),
                'address' => $this->input->post('address')
            );

$result = $this->db->insert('accounts_ledger', $data);
            // print_r($result);exit;
            $ledger_id = $this->db->insert_id();

$group_name_detail = $this->Group_model->getgroupsnameNew($accounts_group_id)->result_array();
           $group_name_log = $group_name_detail['group_name'];

logActivity('Ledger information created ' .  $this->input->post('ledger_name') . ' under'.$group_name_log, LOG_LEDGER);
			set_alert('success', "Ledger information created successfully.");

$error_type = 'm';
            $msg = 'Ledger Successful added';
            $result = true;
			
        }
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
    }

public function edit() {
        if(hasPermission('ledger_update')){
        $id = $this->uri->segment(3);

if ($id != '') {
        $under_ledger = $this->Ledger_under_chk_model->ledger_under_validation()->result_array();

$ledger = $this->Ledger_model->retrieve_ledger_editdata($id);
           
     if($ledger->num_rows() > 0){
		 $ledger_detail = $ledger->row_array();
		
            $data = array(
                'page_title' => 'Edit Ledger',
                'page_name' => 'admin/ledger/edit',
                'ledger_id' => $ledger_detail['ledger_id'],
                'ledger_name' => $ledger_detail['ledger_name'],
                //'group_name' => $ledger_detail[0]['group_name'],
                'accounts_group_id' => $ledger_detail['accounts_group_id'],
                'pan_no' => $ledger_detail['pan_no'],
                'gst_no' => $ledger_detail['gst_no'],
                'place' => $ledger_detail['place'],
                'address' => $ledger_detail['address'],
                'group' => $under_ledger,
            );

$this->load->view('admin/template', $data);
        } else {
            redirect(base_url('ledger'));
        }
    }
}else{
    redirect(base_url('dashboard'));

}
   
	}

public function update() {
        if(hasPermission('ledger_update')){
        $error_type = '';
        $msg = '';
        $result = false;
        $accounts_group_id = $this->input->post('ledger_under');
        $ledger_id = $this->input->post('ledger_id');
        
        $this->form_validation->set_rules('ledger_name', 'Name', 'trim|required|min_length[1]|max_length[255]');
        $this->form_validation->set_rules('ledger_under', 'Under', 'trim|required');
        //$this->form_validation->set_rules('id', 'Id', 'trim|required');
        if ($accounts_group_id == 8) {
            $this->form_validation->set_rules('pan_no', 'PAN No', 'trim|required|min_length[10]|max_length[10]');
            $this->form_validation->set_rules('gst_no', 'GST No', 'trim|required|min_length[15]|max_length[15]');
            $this->form_validation->set_rules('place', 'Place', 'trim|min_length[1]|max_length[255]');
            $this->form_validation->set_rules('address', 'Address', 'trim|min_length[1]|max_length[255]');
        }

if ($this->form_validation->run() == FALSE) {

$error_type = 'v';
            $msg = validation_errors('<p class="error">', '</p>'); //validation_errors(); 	
            $result = false;
        } else {
            $ledger_id = $this->input->post('ledger_id');
            $data = array(
                'ledger_name' => $this->input->post('ledger_name'),
                'accounts_group_id' => $this->input->post('ledger_under'),
                'pan_no' => $this->input->post('pan_no'),
                'gst_no' => $this->input->post('gst_no'),
                'place' => $this->input->post('place'),
                'address' => $this->input->post('address')
            );

// print_r($accounts_group_id);die;
            $group_name_detail = $this->Group_model->getgroupsnameNew($accounts_group_id)->row_array();
            $group_name_log = $group_name_detail['group_name'];

$get_ledger_name_det = $this->Ledger_model->getLedgerName($ledger_id)->row_array();

$ledger_name_old = $get_ledger_name_det['ledger_name'];

$group_name_detail_old = $this->Group_model->getgroupsnameNew($get_ledger_name_det['accounts_group_id'])->row_array();
            $group_name_log_old = $group_name_detail_old['group_name'];

$this->db->where('ledger_id', $ledger_id)->update('accounts_ledger', $data);

logActivity('Ledger information updated from '.$ledger_name_old.' under '.$group_name_log_old.' to ' . $this->input->post('ledger_name') .' under '.$group_name_log, LOG_LEDGER);
			set_alert('success', "Ledger information updated successfully.");

$error_type = 'm';
            $msg = 'Ledger Successful updated';
            $result = true;
        }
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg));
    }else{
        redirect(base_url('dashboard'));
    
    }
    }

public function active() {
        $id = $this->input->post('id');
        $msg = $this->input->post('msg');
        $status = $this->input->post('status');
        
        $log =($status == 1 ) ? 'activated' : 'deactivated' ;

$data = array();
        $data['status'] = $status;

$get_ledger_name_det = $this->Ledger_model->getLedgerName($id)->row_array();

$ledger_name_old = $get_ledger_name_det['ledger_name'];

$result = $this->Ledger_model->active_update($id, $data);
        //echo $this->db->last_query();
        $result = ($result > 0) ? True : False;
        ($result) ? logActivity(' Ledger '. $ledger_name_old.' [' . $msg .' - '.$log. ']', LOG_LEDGER) : '';
        echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
    }
	public function delete() {
        $id = $this->input->post('id');
        $msg = $this->input->post('msg');
        $status = $this->input->post('status');
        
        $log =($status == 2 ) ? 'deleted' : '' ;

$data = array();
        $data['status'] = $status;

$get_ledger_name_det = $this->Ledger_model->getLedgerName($id)->row_array();

$ledger_name_old = $get_ledger_name_det['ledger_name'];

$result = $this->Ledger_model->active_update($id, $data);
        //echo $this->db->last_query();
        $result = ($result > 0) ? True : False;

($result) ? logActivity(' Ledger '. $ledger_name_old.' [' . $msg .' - '.$log. ']', LOG_LEDGER) : '';
        echo json_encode(array('rs' => $result, 'log' => $log, 'msg' => $msg));
    }

public function ledger_under_validation() {
        echo $this->Ledger_under_chk_model->ledger_under_validation();
    }

}

/var/www/yapwebtv.com/../../www/krcollege.co/application/controllers/Ledger.php