EVOLUTION-NINJA

Edit File: Dashboard.php

<?php

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

class Dashboard extends CI_Controller {

public function __construct() {
        parent::__construct();

$this->check_islogin(); //check user login session exist or not
        $this->output->set_header('Last-Modified: ' . gmdate("D, d M Y H:i:s") . ' GMT');
        $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
        $this->output->set_header('Pragma: no-cache');
        $this->output->set_header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
        $this->load->model('yarn_model');
        $this->load->model('marketing_model');
        $this->load->model('planning_yarn');
        $this->load->model('planning_shade');

date_default_timezone_set('asia/kolkata');
    }

//Checking the Login or not
    private function check_islogin() {
        if (!$this->session->userdata('logged_in')) {
            redirect(base_url(), 'refresh');
        }
    }

public function session_data_pass()
{
if($this->session->userdata('logged_in'))
    {
    return $this->yarn_model->get_userdata();
    }
}

//display dashboard   
    public function index() {
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
        $this->load->view('yarn_master/dashboard');
        //$this->load->view('templates/user_footer');
    }

//display add quality page
    public function add_quality() {
        if ($this->input->post('submitquality')) {
            $this->form_validation->set_rules('yarntype', 'Yarn type', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarnquality', 'Yarn Quality', 'trim|required|xss_clean');
			$this->form_validation->set_rules('yarnname', 'Yarn Name', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarndenier', 'Yarn Denier', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarnspecifications', 'Yarn Specification', 'trim|required|xss_clean');
            $this->form_validation->set_rules('hanklength', 'Hank Length', 'trim|required|xss_clean');
            $this->form_validation->set_rules('hankwt', 'Hank Weight', 'trim|required|xss_clean');
            if ($this->form_validation->run() == FALSE) {
                $data['check_specification'] = $this->yarn_model->check_spec_exists();
                $this->load->view('templates/header_inside');
                $this->load->view('import_module/add_quality', $data);
                $this->load->view('templates/footer_inside');
            } else {
                $quality_data = array('yarnType' => $this->input->post('yarntype'),
                    'yarnQuality' => $this->input->post('yarnquality'),
					'yarnName' => $this->input->post('yarnname'),
                    'yarnSpecification' => $this->input->post('yarnspecifications'),
                    'yarnDenier' => $this->input->post('yarndenier'),
                    'hankLength' => $this->input->post('hanklength'),
                    'hankWt' => $this->input->post('hankwt'),
                 
                );
                $qtyinsert = $this->yarn_model->yarn_qty_insert($quality_data);
                if ($qtyinsert == 1) {
                    redirect(base_url() . 'dashboard/yarn_details', 'refresh');
                } else {
                    echo "notinserted";
                }
            }
        } else {
            $data['check_specification'] = $this->yarn_model->check_spec_exists();
        
           $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
         $this->load->view('import_module/add_quality', $data);
            $this->load->view('templates/footer_inside');
        }
    }

//display add quality page
    public function yarn_details() {
        $data['getalldata'] = $this->yarn_model->display_yarnqty_data();
          $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('import_module/yarn_details', $data);
        $this->load->view('templates/footer_inside');
    }

//create Import file No in supplier master
    public function create_unique() {
        if ($_REQUEST['q'] == "import") {
            $charector = "I";
        } else {
            $charector = "L";
        }
        $this->db->like('import_fileno', $charector, 'after');
        $query = $this->db->get('supplier_details');

$invoiceno = $query->num_rows() + 1;
        $invID = str_pad($invoiceno, 5, '0', STR_PAD_LEFT);
        if ($_REQUEST['q'] == "import") {
            echo "I" . $invID;
        } else {
            echo "L" . $invID;
        }
    }

//display yarn master form.
    public function add_yarn() {
        if ($this->input->post('submitquality')) {
            $this->form_validation->set_rules('yarntype', 'Yarn type', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarnquality', 'Yarn Quality', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarndenier', 'Yarn Denier', 'trim|required|xss_clean');
            $this->form_validation->set_rules('yarnspecifications', 'Yarn Specification', 'trim|required|xss_clean');
            $this->form_validation->set_rules('hanklength', 'Hank Length', 'trim|required|xss_clean');
            $this->form_validation->set_rules('hankwt', 'Hank Weight', 'trim|required|xss_clean');
            $this->form_validation->set_rules('korashrinkage', 'Kora Shrinkage', 'trim|required|xss_clean');
            $this->form_validation->set_rules('dyedshrinkage', 'Dyed Shrinkage', 'trim|required|xss_clean');
            if ($this->form_validation->run() == FALSE) {
                $data['check_specification'] = $this->planning_yarn->check_spec_exists();
             
                $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
                $this->load->view('planning_module/add_yarn', $data);
                $this->load->view('templates/footer_inside');
            } else {
                $quality_data = array('yarnType' => $this->input->post('yarntype'),
                    'yarnQuality' => $this->input->post('yarnquality'),
                    'yarnSpecification' => $this->input->post('yarnspecifications'),
                    'yarnDenier' => $this->input->post('yarndenier'),
                    'hankLength' => $this->input->post('hanklength'),
                    'hankWt' => $this->input->post('hankwt'),
                    'kora_shrinkage' => $this->input->post('korashrinkage'),
                    'dyed_shrinkage' => $this->input->post('dyedshrinkage')
                );
                $qtyinsert = $this->planning_yarn->planning_yarn_insert($quality_data);
                if ($qtyinsert == 1) {
                    redirect(base_url() . 'dashboard/planning_yarn_details', 'refresh');
                } else {
                    echo "not inserted";
                }
            }
        } else {
            $data['check_specification'] = $this->planning_yarn->check_spec_exists();
               $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
            $this->load->view('planning_module/add_yarn', $data);
            $this->load->view('templates/footer_inside');
        }
    }

public function planning_yarn_details() {
        $data['getalldata'] = $this->planning_yarn->display_yarnqty_data();
         $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('planning_module/planning_yarn_details', $data);
        $this->load->view('templates/footer_inside');
    }

//display color master form.
    public function color_master() {
        if ($this->input->post('submitcolormaster')) {
            $this->form_validation->set_rules('color', 'Color', 'trim|required|xss_clean');
            if ($this->form_validation->run() == FALSE) {
                $this->load->view('templates/header_inside');
                $this->load->view('planning_module/color_master');
                $this->load->view('templates/footer_inside');
            } else {
                $color_data = array('color' => $this->input->post('color')
                );
                $colorinsert = $this->planning_shade->color_insert($color_data);
                if ($colorinsert == 1) {
                    redirect(base_url() . 'dashboard/color_details', 'refresh');
                } else {
                    echo "not inserted";
                }
            }
        } else {
            $data['check_specification'] = $this->yarn_model->check_spec_exists();
   $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
            $this->load->view('planning_module/color_master', $data);
            $this->load->view('templates/footer_inside');
        }
    }

public function add_article() {

$data['yarnqty'] = $this->yarn_model->display_yarnQuality();
        $data['warp_denier'] = $this->yarn_model->display_yarndenier_warp();
        $data['weft_denier'] = $this->yarn_model->display_yarndenier_weft();
        if ($this->input->post('submitarticle')) {
            $this->form_validation->set_rules('articleNo', 'Article Number', 'trim|required|xss_clean|alpha_numeric');
            $this->form_validation->set_rules('quality', 'Quality', 'trim|required|xss_clean');
            $this->form_validation->set_rules('design', 'Design', 'trim|required|xss_clean');
            $this->form_validation->set_rules('width', 'Width', 'trim|required|xss_clean');
            $this->form_validation->set_rules('wrapEnd', 'Wrap End', 'trim|required|xss_clean');
            $this->form_validation->set_rules('reed', 'Reed', 'trim|required|xss_clean');
            $this->form_validation->set_rules('warptotalends', 'Warp Total Ends', 'trim|required|xss_clean');

$this->form_validation->set_rules('picks', 'Picks', 'trim|required|xss_clean');

$this->form_validation->set_rules('wrapQty', 'Wrap Quantity', 'trim|required|xss_clean');
            $this->form_validation->set_rules('wrapDenier', 'Wrap Denier', 'trim|required|xss_clean');
            $this->form_validation->set_rules('wrapSpecification', 'Wrap Specification', 'trim|required|xss_clean');
            $this->form_validation->set_rules('warpfinaldenier', 'Warp Final denier', 'trim|required|xss_clean|alpha');
            $this->form_validation->set_rules('wrapWt', 'Wrap Wt', 'trim|required|xss_clean');

$this->form_validation->set_rules('wrapSr', 'Wrap Sr', 'trim|required|xss_clean');
            $this->form_validation->set_rules('wrapWaste', 'Wrap Waste', 'trim|required|xss_clean');

$this->form_validation->set_rules('loomFinWt', 'Loom Fin Wt', 'trim|required|xss_clean');

if ($this->form_validation->run() == FALSE) {
                 $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
                $this->load->view('marketing/add_article', $data);
                $this->load->view('templates/footer_inside');
            } else {
                $article_data = array(
                    'articleNo' => $this->input->post('articleNo'),
                    'quality' => $this->input->post('quality'),
                    'design' => $this->input->post('design'),
                    'width' => $this->input->post('width'),
                    'wrapEnd' => $this->input->post('wrapEnd'),
                    'reed' => $this->input->post('reed'),
                    'warp_total_ends' => $this->input->post('warptotalends'),
                    'picks' => $this->input->post('picks'),
                    'wrapQty' => $this->input->post('wrapQty'),
                    'wrapSpecification' => $this->input->post('wrapSpecification'),
                    'warpfinaldenier' => $this->input->post('warpfinaldenier'),
                    'wrapWt' => $this->input->post('wrapWt'),
                    'wrapDenier' => $this->input->post('wrapDenier'),
                    'wrapSr' => $this->input->post('wrapSr'),
                    'wrapWaste' => $this->input->post('wrapWaste'),
                    'loomFinWt' => $this->input->post('loomFinWt'),
                    'weftQty' => $this->input->post('weftQty'),
                    'weftSpecification' => $this->input->post('weftSpecification'),
                    'weftfinaldenier' => $this->input->post('weftfinaldenier'),
                    'weftWt' => $this->input->post('weftWt'),
                    'weftDenier' => $this->input->post('weftDenier'),
                    'weftSr' => $this->input->post('weftSr'),
                    'weftWaste' => $this->input->post('weftWaste')
                );
                $articleinsert = $this->marketing_model->article_insert($article_data);

if ($articleinsert == 1) {
                    redirect(base_url() . 'dashboard/article_details', 'refresh');
                } else {
                    echo "notinserted";
                }
            }
        } else {
              $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
            $this->load->view('marketing/add_article', $data);
            $this->load->view('templates/footer_inside');
        }
    }

public function color_details() {
        $data['getalldata'] = $this->planning_shade->display_color();
          $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('planning_module/color_details', $data);
        $this->load->view('templates/footer_inside');
    }
public function add_usermanage()
{
        if ($this->input->post('adduser')) {
            $this->form_validation->set_rules('firstname', 'First Name', 'trim|required|xss_clean|alpha_numeric');
            $this->form_validation->set_rules('lastname', 'Last Name', 'trim|required|xss_clean');
            $this->form_validation->set_rules('username', 'UserName', 'trim|required|callback_check_database');
            $this->form_validation->set_rules('emailid', 'Email', 'trim|required|callback_check_email');
            $this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean');
            $this->form_validation->set_rules('role', 'Role', 'trim|required|xss_clean');

if ($articleinsert == 1) {
                    redirect(base_url() . 'dashboard/user_managment', 'refresh');
                } else {
                    echo "notinserted";
                }
            }
        } else {
              $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
            $this->load->view('usermanagment/add_user_management');
            $this->load->view('templates/footer_inside');
        }
    
}

public function article_master() {
         $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('marketing/add_article');
        $this->load->view('templates/footer_inside');
    }
      public function user_managment() {
        $data['getall']=$this->marketing_model->display_user_managment();
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('usermanagment/user',$data);
        $this->load->view('templates/footer_inside');
 
    }
           public function add_user() {
     
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
        $this->load->view('usermanagment/add_user_management');
        $this->load->view('templates/footer_inside');
 
    }
      
      public function delete_user_management()
      {
          $id=$_REQUEST['ide'];
       $this->marketing_model->delete_users($id);
       redirect(base_url().'dashboard/user_managment','refresh');    
                 
  
      }
      public function edit_user_management($id)
      {
          
     $data['editdata']=$this->marketing_model->get_usermanage_editdata($id);
    if($this->input->post('edituser'))
    {
    $this->form_validation->set_rules('firstname', 'First Name', 'trim|required|xss_clean|alpha_numeric');
            $this->form_validation->set_rules('lastname', 'Last Name', 'trim|required|xss_clean');
            $this->form_validation->set_rules('username', 'UserName', 'trim|required');
            $this->form_validation->set_rules('emailid', 'Email', 'trim|required');
            $this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean');
            $this->form_validation->set_rules('role', 'Role', 'trim|required|xss_clean');
            
    
    if($this->form_validation->run() == FALSE)
    {
      $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
    $this->load->view('usermanagment/edit_user_management',$data);
    $this->load->view('templates/footer_inside');
    }       
    else
    {
    $supplier_data = array('fName' => $this->input->post('firstname'),
                    'lName' => $this->input->post('lastname'),
                    'username' => $this->input->post('username'),
                    'email' => $this->input->post('emailid'),
                    'password' => $this->input->post('password'),
                    'role' => $this->input->post('role')
                  
                           ); 
                           $supupdate=$this->marketing_model->user_management_update($supplier_data,$id);
                 
                 if($supupdate==1)
                 {
                redirect(base_url().'dashboard/user_managment','refresh');    
                 }
    }
    }
    else
    {
           $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
    
    $this->load->view('usermanagment/edit_user_management',$data);
    $this->load->view('templates/footer_inside');
    }
 
          
      }
    //csv download
    public function csv_download($tablename) {
        $this->load->dbutil();
        $this->load->helper('download');
        $query = $this->db->query("SELECT * FROM $tablename");
        $delimiter = ",";
        $newline = "\r\n";
        $data = $this->dbutil->csv_from_result($query, $delimiter, $newline);
        force_download("CSV_Report.csv", $data);
    }

//pdf download
    public function pdf_download($tablename) {
        //$data['getalldata']=$this->yarn_model->getpdfdata($tablename);
        $this->load->helper('pdf_helper');
        $data['getalldata'] = $tablename;
        //$data['datatalbe'] = "mahendra";
        $this->load->view('pdfindex', $data);
    }

//excel download test
    public function excel_download($tablename) {
//load our new PHPExcel library
        $this->load->library('excel');
        $data['getalldata'] = $this->yarn_model->getpdfdata($tablename);
        $this->load->view('excelindex', $data);
    }

//
    public function masters_name_address() {
        $nameaddress = $this->yarn_model->get_name_address($_REQUEST['fileno']);
        //echo $_REQUEST['fileno'];
        //print_r($nameaddress);
        foreach ($nameaddress as $na_result) {
            echo $na_result->customer_name . '@@' . $na_result->address;
        }
    }

public function testing() {
               $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('addmore');
    }

public function article_testing() {
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('addmore1');
    }

public function transactions_order_input_testing() {
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('addmore2');
    }

public function add_article_testing() {
        $data['userdetails'] = $this->session_data_pass();
        $this->load->view('templates/header_inside',$data);
     
        $this->load->view('addmore3');
    }
	
	public function charts_amcharts() {
        //$this->load->view('templates/header_inside');
        $this->load->view('charts_amcharts');
    }

//logout
    public function logout() {
        $this->session->sess_destroy();
        redirect(base_url());
    }

}