Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Purchase.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Purchase extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Purchase_model'));
    $this->load->model(array('Rawmaterialstock_model'));
    $this->load->model(array('Grn_model'));
    $this->load->model(array('Invoice_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->model(array('Accountpayment_model'));
    $this->load->model(array('Productcategory_model'));
    $this->load->library('pagination');
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Purchase');
    $this->load->helper('download');
  }

public function purchase_export()
  {
    /*$pursearch_change = isset($_SESSION['pursearch_change'])?$_SESSION['pursearch_change']:'';
    $purfiltervendor = isset($_SESSION['purfiltervendor'])?$_SESSION['purfiltervendor']:'all';
    $purfilterstatus = isset($_SESSION['purfilterstatus'])?$_SESSION['purfilterstatus']:'all';*/

$purfiltervendor = isset($_SESSION['purfiltervendor'])?$_SESSION['purfiltervendor']:'all';
    $purfilterstatus = isset($_SESSION['purfilterstatus'])?$_SESSION['purfilterstatus']:'all';

$locchange = isset($_SESSION['pur_locchange'])?$_SESSION['pur_locchange']:'all';
    $purschange = isset($_SESSION['pur_schange'])?$_SESSION['pur_schange']:'all';
    $purdtrange = isset($_SESSION['pur_dtrange'])?$_SESSION['pur_dtrange']:'';
    $pursearch_change = isset($_SESSION['pursearch_change'])?$_SESSION['pursearch_change']:'';

if ($pursearch_change != '') {
      $sc = 'AND (v.vendor_name LIKE "%'.$pursearch_change.'%" OR p.invoice_no LIKE "%'.$pursearch_change.'%" OR p.purchase_receipt_no LIKE "%'.$pursearch_change.'%")';
    }
    else {
      $sc = '';
    }

if($purfiltervendor!='all'){
      $ven = 'AND v.vendor_id='.$purfiltervendor;
    }
    else{
      $ven = '';
    }

if($purfilterstatus!='all'){
      $psts = 'AND p.status='.$purfilterstatus;
    }
    else{
      $psts = '';
    }

if($locchange!='all')
    {
      $loc = 'AND g.location_id='.$locchange;
      $ploc = 'AND p.location_id='.$locchange;
    }
    else
    {
      $loc = '';
      $ploc = '';
    }

//$purchase_list = $this->db->query("SELECT p.*,v.vendor_name FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 $ven $sc $psts ORDER BY p.purchase_id DESC")->result_array();

if($purschange=='all')
      {
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
      }

elseif($purschange == 'today')
      {
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') = CURDATE() $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') = CURDATE() $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
      }
      else if($purschange == 'thisweek')
      {
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 and YEARWEEK(STR_TO_DATE(p.purchase_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 and YEARWEEK(STR_TO_DATE(p.purchase_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
      }      
      else if($purschange == 'thismonth')
      {
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE()) $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE()) $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
      }
      else if($purschange == 'thisyear')
      {
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
      }
      else
      {
        $data['drnge_sess'] = $_SESSION['pur_dtrange'];
        $data['drnge'] = $this->input->post('dtrange');

if(isset($data['drnge']) && $data['drnge'] != '') { $dt_filt = $data['drnge']; } elseif(isset($data['drnge_sess']) && $data['drnge_sess'] != '') { $dt_filt = $data['drnge_sess']; }
        $dr = explode(' - ', $dt_filt);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $purchase_list = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
        //echo "SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $ven $sc $comp ORDER BY p.purchase_id DESC Limit $page, $perpage";exit;
      }

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
        'font' => array(
            'bold' => true,
            'color' => array('rgb' => '000000')
        )/*,
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )*/
    );

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Vendor');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Receipt No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Receipt Date');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Invoice No');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Invoice Date');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Amount');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Status');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($purchase_list as $u_list ) { 
      if($u_list['status']==0)
        $sts = 'Pending';
      else
        $sts = 'Approved';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['vendor_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['purchase_receipt_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, date_format(date_create($u_list['purchase_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['invoice_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, date_format(date_create($u_list['invoice_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($u_list['total_amount'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $sts);

$i++;
    }

$filename='Purchase.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
    //if you want to save it as .XLSX Excel 2007 format
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
    $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function index()
  { 
    $config = array();
    $config["base_url"] = base_url() . "purchase";
    $config["per_page"] = 10;
    $config["uri_segment"] = 2;
    $config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
    $config['full_tag_close'] = '</ul></div>';
    $config['num_tag_open'] = '<li class="page-item">';
    $config['num_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="page-item active"><a class="page-link" href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['next_tag_open'] = '<li class="page-item">';
    $config['next_tagl_close'] = '</a></li>';
    $config['prev_tag_open'] = '<li class="page-item">';
    $config['prev_tagl_close'] = '</li>';
    $config['first_tag_open'] = '<li class="page-item">';
    $config['first_tagl_close'] = '</li>';
    $config['last_tag_open'] = '<li class="page-item">';
    $config['last_tagl_close'] = '</a></li>';
    $config['attributes'] = array('class' => 'page-link');
    $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
    
    $perpage = $config['per_page'];

$data['vendor_list'] = $this->Purchase_model->get_active_vendor();
    $data['location'] = $this->Purchase_model->get_location_list();

if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      $vendorchange = $this->input->post('filtervendor');
      // $this->session->set_userdata('pursearch_change', $this->input->post('pur_search')!=''?$this->input->post('pur_search'):$_SESSION['pursearch_change']);
      $this->session->set_userdata('pursearch_change', $this->input->post('pur_search'));
      $pursearch_change = isset($_SESSION['pursearch_change'])?$_SESSION['pursearch_change']:$this->input->post('pur_search');
      $this->session->set_userdata('purfiltervendor', $this->input->post('filtervendor')!=''?$this->input->post('filtervendor'):$_SESSION['purfiltervendor']);
      $this->session->set_userdata('purfilterstatus', $this->input->post('pfilterstatus')!=''?$this->input->post('pfilterstatus'):$_SESSION['purfilterstatus']);

$this->session->set_userdata('pur_locchange', $this->input->post('filterexpcomp')!=''?$this->input->post('filterexpcomp'):$_SESSION['pur_locchange']);
      $this->session->set_userdata('pur_schange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['pur_schange']);
      $this->session->set_userdata('pur_dtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['pur_dtrange']);

$purfiltervendor = isset($_SESSION['purfiltervendor'])?$_SESSION['purfiltervendor']:$this->input->post('filtervendor');
      $purfilterstatus = isset($_SESSION['purfilterstatus'])?$_SESSION['purfilterstatus']:$this->input->post('pfilterstatus');

$locchange = isset($_SESSION['pur_locchange'])?$_SESSION['pur_locchange']:$this->input->post('filterexpcomp');
      $purschange = isset($_SESSION['pur_schange'])?$_SESSION['pur_schange']:$this->input->post('searchChange');
      $purdtrange = isset($_SESSION['pur_dtrange'])?$_SESSION['pur_dtrange']:$this->input->post('dtrange');

if ($pursearch_change != '') {
        $sc = 'AND (v.vendor_name LIKE "%'.$pursearch_change.'%" OR p.invoice_no LIKE "%'.$pursearch_change.'%" OR p.purchase_receipt_no LIKE "%'.$pursearch_change.'%")';
      }
      else {
        $sc = '';
      }

if($purfiltervendor!='all'){
        $ven = 'AND v.vendor_id='.$purfiltervendor;
      }
      else{
        $ven = '';
      }

if($purfilterstatus!='all'){
        $psts = 'AND p.status='.$purfilterstatus;
      }
      else{
        $psts = '';
      }

if($locchange!='all')
      {
        $loc = 'AND g.location_id='.$locchange;
        $ploc = 'AND p.location_id='.$locchange;
      }
      else
      {
        $loc = '';
        $ploc = '';
      }

$data['vendorchange'] = $purfiltervendor;
      $data['statuschange'] = $purfilterstatus;
      $data['pursearch_change'] = $pursearch_change;

if($purschange=='all')
      {
        $data['purchase_list_count'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC")->result_array();
        $config['total_rows'] = count($data['purchase_list_count']);
        $data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts)) s ORDER BY s.purchase_id DESC LIMIT $page, $perpage")->result_array();
      }

elseif($purschange == 'today')
      {
        $data['clist'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') = CURDATE()) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') = CURDATE())) s ORDER BY s.purchase_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);

$data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and YEARWEEK(STR_TO_DATE(p.purchase_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1)) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and YEARWEEK(STR_TO_DATE(p.purchase_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1))) s ORDER BY s.purchase_id DESC Limit $page, $perpage")->result_array();
      }      
      else if($purschange == 'thismonth')
      {
        $data['clist'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE())) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE()))) s ORDER BY s.purchase_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);

$data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE())) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE()))) s ORDER BY s.purchase_id DESC Limit $page, $perpage")->result_array();
      }
      else if($purschange == 'thisyear')
      {
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['clist'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d')) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d'))) s ORDER BY s.purchase_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $data['aclist'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d')) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d'))) s ORDER BY s.purchase_id DESC")->result_array();

$config["total_rows"] = count($data['aclist']);

$data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d')) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d'))) s ORDER BY s.purchase_id DESC Limit $page, $perpage")->result_array();
        //echo "SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $ven $sc $comp ORDER BY p.purchase_id DESC Limit $page, $perpage";exit;
      }
      $data['expcompchange'] = $locchange;
      $data['purchasesearch'] = $purschange;
      $data['drnge'] = $purdtrange;
    }

elseif ((isset($_SESSION['pursearch_change']) || isset($_SESSION['purfiltervendor']) || isset($_SESSION['purfilterstatus']) || isset($_SESSION['pur_locchange']) || isset($_SESSION['pur_schange']) || isset($_SESSION['pur_dtrange'])))
    {
      $purfiltervendor = isset($_SESSION['purfiltervendor'])?$_SESSION['purfiltervendor']:$this->input->post('filtervendor');
      $purfilterstatus = isset($_SESSION['purfilterstatus'])?$_SESSION['purfilterstatus']:$this->input->post('pfilterstatus');

if ($pursearch_change != '') {
        $sc = 'AND (v.vendor_name LIKE "%'.$pursearch_change.'%" OR p.invoice_no LIKE "%'.$pursearch_change.'%" OR p.purchase_receipt_no LIKE "%'.$pursearch_change.'%")';
      }
      else {
        $sc = '';
      }

if($purfiltervendor!='all'){
        $ven = 'AND v.vendor_id='.$purfiltervendor;
      }
      else{
        $ven = '';
      }

if($purfilterstatus!='all'){
        $psts = 'AND p.status='.$purfilterstatus;
      }
      else{
        $psts = '';
      }

/*if($locchange!='all')
        $loc = 'AND g.location_id='.$locchange;
      else
        $loc = '';*/
      if($locchange!='all')
      {
        $loc = 'AND g.location_id='.$locchange;
        $ploc = 'AND p.location_id='.$locchange;
      }
      else
      {
        $loc = '';
        $ploc = '';
      }

$data['vendorchange'] = $purfiltervendor;
      $data['statuschange'] = $purfilterstatus;
      $data['pursearch_change'] = $pursearch_change;

$config["total_rows"] = count($data['clist']);

$data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE())) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and MONTH(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(p.purchase_date, '%Y-%m-%d')) = YEAR(CURDATE()))) s ORDER BY s.purchase_id DESC Limit $page, $perpage")->result_array();
      }
      else if($purschange == 'thisyear')
      {
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['clist'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d')) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d'))) s ORDER BY s.purchase_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$config["total_rows"] = count($data['aclist']);

$data['purchase_list'] = $this->db->query("SELECT s.*,s.vendor_name,s.state_id FROM ((SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 AND p.grn_id!=0 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d')) UNION (SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 AND p.grn_id=0 $ploc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d'))) s ORDER BY s.purchase_id DESC Limit $page, $perpage")->result_array();
        //echo "SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v,grn g WHERE p.vendor_id = v.vendor_id AND p.grn_id = g.grn_id AND p.status!=5 $loc $ven $sc $psts and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(p.purchase_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $ven $sc $comp ORDER BY p.purchase_id DESC Limit $page, $perpage";exit;
      }
      $data['expcompchange'] = $locchange;
      $data['purchasesearch'] = $purschange;
      $data['drnge'] = $purdtrange;
    }
    else
    {
      $data['pursearch_change'] = '';
      $data['vendorchange'] = '';
      $data['statuschange'] = 'all';
      $data['expcompchange'] = 'all';
      $data['drnge'] = '';
      $this->session->unset_userdata('pursearch_change');
      $this->session->unset_userdata('purfiltervendor');
      $this->session->unset_userdata('purfilterstatus');
      $this->session->unset_userdata('pur_locchange');
      $this->session->unset_userdata('pur_schange');
      $this->session->unset_userdata('pur_dtrange');

// $data['purchase_list'] = $this->Purchase_model->get_purchase_list();
      $data['purchase_list_count'] = $this->db->query("SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 ORDER BY p.purchase_id DESC")->result_array();
      // echo count($data['purchase_list_count']);
       $config['total_rows'] = count($data['purchase_list_count']);
      // die();
      $data['purchase_list'] = $this->db->query("SELECT p.*,v.vendor_name,v.state_id FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.status!=5 ORDER BY p.purchase_id DESC LIMIT $page, $perpage")->result_array();
    }
   
    $this->pagination->initialize($config);
    $data['links'] = $this->pagination->create_links();
    $this->load->view('purchase/purchase_list',$data);
  }

public function purchase_add()
  {
    $data['gsttax_list'] = $this->Productcategory_model->get_active_gsttax_list();
    $data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchase_model->get_active_vendor();
    $data['pending_po_list'] = $this->Purchase_model->get_pending_po_list();
    $data['grn_list'] = $this->Purchase_model->get_pending_grn();

$last_id_value = $this->Purchase_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['purchase_receipt_no'] = date("Y").'/'.date('m').'/001';
    }
    else
    {
      $lno = $last_id_value->purchase_receipt_no;
      $exlno = substr($lno,8);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $data['purchase_receipt_no'] = date("Y").'/'.date('m').'/'.$nval;
    }

$this->load->view('purchase/purchase_add',$data);
  }

public function getPurchaseProductByBillNo()
  {
    $bill_no = $_POST['bno'];

$checkbnoexist = $this->Purchase_model->check_purchase_by_bno($bill_no);
    if(count($checkbnoexist)>0)
    {
      echo 'Exist';
    }
    else
    {
      echo 'New';
    }
  }

/*public function getGRNProduct()
  {
    $bill_no = $_POST['bno'];
    $grn = $this->Purchase_model->get_grn_by_bil_no($bill_no);
    if(count($grn)>0){
      $data['type'] = $grn->type;
      if($grn->type=='raw material')
        $grn_products_group = $data['grn_products_group'] = $this->Purchase_model->getGRNProduct($bill_no);
      else
        $grn_products_group = $data['grn_products_group'] = $this->Purchase_model->getGRNProduct_by_product($bill_no);
      //$data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();
      if(count($grn_products_group)>0)
      {
        $this->load->view('purchase/grn_product_detail',$data);
      }
      else
      {
        echo 0;
      }
    }
    else
    {
      echo 0;
    }
  }*/

public function getGRNProduct()
  {
    $grn_id = $_POST['grn_id'];
    $grn = $this->Purchase_model->get_grn_by_id($grn_id);
    if(count($grn)>0){
      $data['type'] = $grn->type;
      if($grn->type=='raw material')
        $grn_products_group = $data['grn_products_group'] = $this->Purchase_model->getGRNProduct($grn_id);
      else
        $grn_products_group = $data['grn_products_group'] = $this->Purchase_model->getGRNProduct_by_product($grn_id);
      //$data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();
      if(count($grn_products_group)>0)
      {
        $this->load->view('purchase/grn_product_detail',$data);
      }
      else
      {
        echo 0;
      }
    }
    else
    {
      echo 0;
    }
  }

public function create_purchase()
  {
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_date'));
    $data['purchase_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['purchase_receipt_no']=$this->input->post('purchase_receipt_no');
    $data['invoice_no']=$this->input->post('invoice_no');
    $idt = explode('/', $this->input->post('invoice_date'));
    $data['invoice_date'] = $idt[2].'-'.$idt[0].'-'.$idt[1]; 
    $data['total_amount']=$this->input->post('total_amount');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_percent']=$this->input->post('tax_percent');
    $data['tax_amount']=$this->input->post('tax_amount');
    $poid = $data['purchase_order_id'] = $this->input->post('purchase_order_id');

$last_id_value = $this->Purchase_model->last_id();
    if(count($last_id_value)==0)
    {
      $pno = $data['purchase_no'] = date("Y").'/'.date('m').'/PUR001';
    }
    else
    {
      $lno = $last_id_value->purchase_no;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $pno = $data['purchase_no'] = date("Y").'/'.date('m').'/PUR'.$nval;
    }

$rmnorep = str_replace('/', '-', $pno);

if(!empty($_FILES['purchase_bill']['name'])){
      $ext = pathinfo($_FILES['purchase_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'purchasebill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('purchase_bill'))
      {
        $uploadData = $this->upload->data();
        $data['purchase_bill'] = $profileName;
      }
      else
      {
        $data['purchase_bill'] = '';
      }
    }
    else
    {
      $data['purchase_bill'] = '';
    }
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['grn_id'] = $this->input->post('grn_id');
    $data['other_charges'] = $this->input->post('other_charges');
    $data['no_of_rolls'] = $this->input->post('no_of_rolls');
    $data['remarks'] = $this->input->post('remarks');
    $data['location_id'] = 0;

$result = $this->Purchase_model->create_purchase($data);

if($result)
    {
      $type = $this->input->post('type');
      $last_id_value = $this->Purchase_model->last_id();
      $last_value=$last_id_value->count_val;
      $purproduct['purchase_id'] = $last_value;
      if($type == 'raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
          $gwgt = explode(",",implode(",",$this->input->post('grn_weight')));
          $rwgt = explode(",",implode(",",$this->input->post('rm_weight')));
          $rate = explode(",",implode(",",$this->input->post('rate')));
          $dper = explode(",",implode(",",$this->input->post('disc_percentage')));
          $amt = explode(",",implode(",",$this->input->post('amount')));
          $purqty = explode(",",implode(",",$this->input->post('purchase_quantity')));

$subcount = count($this->input->post('rawmaterial_id')); 
          $s=0;
          for($i=0;$i<$subcount;$i++)
          {
            if($rmid[$i] != ''){
              $purproduct['rawmaterial_id'] = $rmid[$i];
              $purproduct['gsm'] = $gsm[$i];
              $purproduct['quantity'] = $qty[$i];
              $purproduct['net_weight'] = $nwgt[$i];
              $purproduct['grn_weight'] = $gwgt[$i];
              $purproduct['rm_weight'] = $rwgt[$i];
              $purproduct['rate'] = $rate[$i];
              $purproduct['disc_percentage'] = $dper[$i];
              $purproduct['amount'] = $amt[$i];
              $purproduct['purchase_quantity'] = $purqty[$i];
              $this->Purchase_model->create_purchase_product($purproduct);

$tpoqQry = $this->Purchase_model->get_po_rm_qty_by_poid_rmid($poid,$rmid[$i]);
              $tpoq = $tpoqQry->quantity;

$tpqQry = $this->Purchase_model->get_purchase_qty_by_pid_rmid($poid,$rmid[$i]);
              $tpq = $tpqQry->pqty;

$uppo['received_quantity'] = $tpq;

if($tpoq == $tpq)
              {
                $uppo['status'] = 1;
              }
              else
              {
                $uppo['status'] = 0;
              }

$this->Purchase_model->update_purchase_order_prod_remqty($uppo,$poid,$rmid[$i]);

}
          }

$poprodQry = $this->Purchase_model->get_purchase_order_product_by_id($poid);

$popcnt = count($poprodQry);

$sumsts = $this->Purchase_model->get_pop_status_sum_by_poid($poid);

$sqty = $sumsts->sqty;
          $srqty = $sumsts->srqty;

if($srqty==0)
          {
            $uppos['status']=0;
          }
          else if($sqty!=$srqty)
          {
            $uppos['status'] = 1;
          }
          else
          {
            $uppos['status'] = 2;
          }
          $this->Purchase_model->update_purchase_order_status_by_id($uppos,$poid);
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $prod = explode(",",implode(",",$this->input->post('product_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
          $gwgt = explode(",",implode(",",$this->input->post('grn_weight')));
          $rwgt = explode(",",implode(",",$this->input->post('rm_weight')));
          $rate = explode(",",implode(",",$this->input->post('rate')));
          $dper = explode(",",implode(",",$this->input->post('disc_percentage')));
          $amt = explode(",",implode(",",$this->input->post('amount')));
          $purqty = explode(",",implode(",",$this->input->post('purchase_quantity')));

$subcount = count($this->input->post('product_id')); 
          $s=0;
          for($i=0;$i<$subcount;$i++)
          {
            if($prod[$i] != ''){
              $purproduct['product_id'] = $prod[$i];
              $purproduct['gsm'] = $gsm[$i];
              $purproduct['quantity'] = $qty[$i];
              $purproduct['net_weight'] = $nwgt[$i];
              $purproduct['grn_weight'] = $gwgt[$i];
              $purproduct['rm_weight'] = $rwgt[$i];
              $purproduct['rate'] = $rate[$i];
              $purproduct['amount'] = $amt[$i];
              $purproduct['purchase_quantity'] = $purqty[$i];
              $purproduct['disc_percentage'] = $dper[$i];
              $this->Purchase_model->create_purchase_product_by_product_id($purproduct);

$tpoqQry = $this->Purchase_model->get_po_rm_qty_by_poid_prodid($poid,$prod[$i]);
              $tpoq = $tpoqQry->quantity;

$tpqQry = $this->Purchase_model->get_purchase_qty_by_pid_prodid($poid,$prod[$i]);
              $tpq = $tpqQry->pqty;

$uppo['received_quantity'] = $tpq;

if($tpoq == $tpq)
              {
                $uppo['status'] = 1;
              }
              else
              {
                $uppo['status'] = 0;
              }

$this->Purchase_model->update_purchase_order_prod_remqty_prodid($uppo,$poid,$prod[$i]);

}
          }

$poprodQry = $this->Purchase_model->get_purchase_order_product_by_product_id($poid);

$popcnt = count($poprodQry);

$sumsts = $this->Purchase_model->get_pop_status_sum_by_poid($poid);

$sqty = $sumsts->sqty;
          $srqty = $sumsts->srqty;

/*$rmslist = $this->Purchase_model->get_rawmaterial_stock_by_bcno($bcno);

if(count($rmslist)>0)
      {
        for($i=0;$i<$subcount;$i++)
        {
          $rmswgt = $this->Purchase_model->get_rawmaterial_weight_by_rmid_bcno($rmid[$i],$bcno);
          $wgt = $rmswgt->wgt;
          if($wgt==null)
            $wgt = 0;
          $this->Purchase_model->update_purchase_product_rmwgt_by_pid_rmid($wgt,$rmid[$i],$last_value);
        }

$this->Purchase_model->update_rmstock_purchase_id_by_bcno($bcno,$last_value);

}*/

$this->session->set_flashdata('add_success', 'Purchase has been added successfully.');
      redirect('/purchase');
    }
  }

public function purchase_view($id)
  {
    $purdet = $data['purchase_details'] = $this->Purchase_model->get_purchase_by_id($id);
    $grn_list = $this->Purchase_model->get_grn_by_id($purdet->grn_id);
    if($grn_list->type == 'raw material')
      $data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_id($id);
    else
      $data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_product_id($id);
    $data['type'] = $grn_list->type;
    $data['company_name'] = $grn_list->location_name;
    $this->load->view('purchase/purchase_view',$data);
  }

public function direct_purchase_view($id)
  {
    $purdet = $data['purchase_details'] = $this->Purchase_model->get_direct_purchase_by_id($id);
    
    $data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_product_id($id);

$data['purchase_rawmaterial'] = $this->Purchase_model->get_purchase_product_by_id($id);
    //$data['type'] = $grn_list->type;
    $data['company_name'] = $purdet->location_name;
    $this->load->view('purchase/direct_purchase_view',$data);
  }

public function purchase_edit($id)
  {    
    /*$data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchase_model->get_active_vendor();
    $data['pending_po_list'] = $this->Purchase_model->get_pending_po_list();
    $data['grn_list'] = $this->Purchase_model->get_pending_grn();*/

$data['gsttax_list'] = $this->Productcategory_model->get_active_gsttax_list();
    $data['pending_po_list'] = $this->Purchase_model->get_pending_po_list();
    $data['grn_list'] = $this->Purchase_model->get_pending_grn();
    $data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchase_model->get_active_vendor();
    $purdet = $data['purchase_details'] = $this->Purchase_model->get_purchase_by_id($id);
    //$data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_id($id);

$grn_list = $this->Purchase_model->get_grn_by_id($purdet->grn_id);
    if($grn_list->type == 'raw material')
      $data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_id($id);
    else
      $data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_product_id($id);
    $this->load->view('purchase/purchase_edit',$data);
  }

public function update_purchase()
  {
    $pid = $data['purchase_id'] = $this->input->post('purchase_id');
    $purdet = $this->Purchase_model->get_purchase_by_id($pid);
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_date'));
    $data['purchase_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['purchase_receipt_no']=$this->input->post('purchase_receipt_no');
    $data['invoice_no']=$this->input->post('invoice_no');
    $idt = explode('/', $this->input->post('invoice_date'));
    $data['invoice_date'] = $idt[2].'-'.$idt[0].'-'.$idt[1]; 
    $data['total_amount']=$this->input->post('total_amount');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_percent']=$this->input->post('tax_percent');
    $data['tax_amount']=$this->input->post('tax_amount');
    $poid = $data['purchase_order_id'] = $this->input->post('purchase_order_id');

$rmnorep = str_replace('/', '-', $purdet->purchase_no);

if(!empty($_FILES['purchase_bill']['name'])){
      $ext = pathinfo($_FILES['purchase_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'purchasebill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('purchase_bill'))
      {
        $uploadData = $this->upload->data();
        $data['purchase_bill'] = $profileName;
      }
      else
      {
        $data['purchase_bill'] = '';
      }
    }
    else
    {
      $data['purchase_bill'] = '';
    }
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['grn_id'] = $this->input->post('grn_id');
    $data['other_charges'] = $this->input->post('other_charges');
    $data['no_of_rolls'] = $this->input->post('no_of_rolls');
    $data['remarks'] = $this->input->post('remarks');

$result = $this->Purchase_model->update_purchase($data);

if($result)
    {
      $this->Purchase_model->delete_purchase_product_by_id($pid);
      $type = $this->input->post('type');
      $purproduct['purchase_id'] = $pid;
      if($type == 'raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
          $gwgt = explode(",",implode(",",$this->input->post('grn_weight')));
          $rwgt = explode(",",implode(",",$this->input->post('rm_weight')));
          $rate = explode(",",implode(",",$this->input->post('rate')));
          $amt = explode(",",implode(",",$this->input->post('amount')));
          $dper = explode(",",implode(",",$this->input->post('disc_percentage')));
          $purqty = explode(",",implode(",",$this->input->post('purchase_quantity')));

$subcount = count($this->input->post('rawmaterial_id')); 
          $s=0;
          for($i=0;$i<$subcount;$i++)
          {
            if($rmid[$i] != ''){
              $purproduct['rawmaterial_id'] = $rmid[$i];
              $purproduct['gsm'] = $gsm[$i];
              $purproduct['quantity'] = $qty[$i];
              $purproduct['net_weight'] = $nwgt[$i];
              $purproduct['grn_weight'] = $gwgt[$i];
              $purproduct['rm_weight'] = $rwgt[$i];
              $purproduct['rate'] = $rate[$i];
              $purproduct['amount'] = $amt[$i];
              $purproduct['purchase_quantity'] = $purqty[$i];
              $purproduct['disc_percentage'] = $dper[$i];
              $this->Purchase_model->create_purchase_product($purproduct);

}
          }
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $prod = explode(",",implode(",",$this->input->post('product_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
          $gwgt = explode(",",implode(",",$this->input->post('grn_weight')));
          $rwgt = explode(",",implode(",",$this->input->post('rm_weight')));
          $rate = explode(",",implode(",",$this->input->post('rate')));
          $amt = explode(",",implode(",",$this->input->post('amount')));
          $purqty = explode(",",implode(",",$this->input->post('purchase_quantity')));
          $dper = explode(",",implode(",",$this->input->post('disc_percentage')));

}
          }
        }
      }

$this->session->set_flashdata('add_success', 'Purchase has been updated successfully.');
      redirect('/purchase');
    }
  }

public function purchase_approve_edit($id)
  {
    /*$data['pending_po_list'] = $this->Purchase_model->get_pending_po_list();
    $data['grn_list'] = $this->Purchase_model->get_pending_grn();
    $data['rawmaterial_list'] = $this->Purchase_model->get_active_rawmaterials();*/
    $data['vendor_list'] = $this->Purchase_model->get_active_vendor();
    $purdet = $data['purchase_details'] = $this->Purchase_model->get_purchase_by_id($id);
    //$data['purchase_product'] = $this->Purchase_model->get_purchase_product_by_id($id);

public function update_approve_purchase()
  {
    $pid = $data['purchase_id'] = $this->input->post('purchase_id');
    $purdet = $this->Purchase_model->get_purchase_by_id($pid);
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_date'));
    $data['purchase_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['purchase_receipt_no']=$this->input->post('purchase_receipt_no');
    $data['invoice_no']=$this->input->post('invoice_no');
    $idt = explode('/', $this->input->post('invoice_date'));
    $data['invoice_date'] = $idt[2].'-'.$idt[0].'-'.$idt[1]; 
    $data['total_amount']=$this->input->post('total_amount');
    $data['taxable_amount']=$this->input->post('taxable_amount');
    $data['tax_percent']=$this->input->post('tax_percent');
    $data['tax_amount']=$this->input->post('tax_amount');
    $poid = $data['purchase_order_id'] = $this->input->post('purchase_order_id');

$rmnorep = str_replace('/', '-', $purdet->purchase_no);

if(!empty($_FILES['purchase_bill']['name'])){
      $ext = pathinfo($_FILES['purchase_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'purchasebill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('purchase_bill'))
      {
        $uploadData = $this->upload->data();
        $data['purchase_bill'] = $profileName;
      }
      else
      {
        $data['purchase_bill'] = '';
      }
    }
    else
    {
      $data['purchase_bill'] = '';
    }
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['grn_id'] = $this->input->post('grn_id');
    $data['other_charges'] = $this->input->post('other_charges');
    $data['no_of_rolls'] = $this->input->post('no_of_rolls');
    $data['remarks'] = $this->input->post('remarks');

$result = $this->Purchase_model->update_purchase($data);

if($result)
    {
      $this->session->set_flashdata('add_success', 'Purchase has been updated successfully.');
      redirect('/purchase');
    }
  }

/*public function update_purchase()
  {
    $pid = $data['purchase_id']=$this->input->post('purchase_id');
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_date'));
    $data['purchase_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['no_of_packets']=$this->input->post('no_of_packets');
    $data['transporter']=$this->input->post('transporter');
    $data['vehicle_no']=$this->input->post('vehicle_no');
    $data['total_amount']=$this->input->post('total_amount');

$obill = $this->input->post('old_bill');

$pno = $this->input->post('purchase_no');

$rmnorep = str_replace('/', '-', $pno);

if(!empty($_FILES['purchase_bill']['name'])){
      $ext = pathinfo($_FILES['purchase_bill']['name'], PATHINFO_EXTENSION);
      if($obill!='')
        unlink('purchasebill/'.$obill);
      $config['upload_path'] = 'purchasebill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('purchase_bill'))
      {
        $uploadData = $this->upload->data();
        $data['purchase_bill'] = $profileName;
      }
      else
      {
        $data['purchase_bill'] = '';
      }
    }
    else
    {
      $data['purchase_bill'] = $obill;
    }
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $bcno = $data['bill_copy_no'] = $this->input->post('bill_copy_no');

$result = $this->Purchase_model->update_purchase($data);

if($result)
    {
      $this->Purchase_model->delete_purchase_product_by_id($pid);
      $purproduct['purchase_id'] = $pid;
      if($this->input->post('rawmaterial_id')!='')
      {
        $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
        $gsm = explode(",",implode(",",$this->input->post('gsm')));
        $size = explode(",",implode(",",$this->input->post('size')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
        $rate = explode(",",implode(",",$this->input->post('rate')));
        $amt = explode(",",implode(",",$this->input->post('amount')));

$subcount = count($this->input->post('rawmaterial_id')); 
        for($i=0;$i<$subcount;$i++)
        {
          if($rmid[$i] != ''){
            $purproduct['rawmaterial_id'] = $rmid[$i];
            $purproduct['gsm'] = $gsm[$i];
            $purproduct['size'] = $size[$i];
            $purproduct['quantity'] = $qty[$i];
            $purproduct['net_weight'] = $nwgt[$i];
            $purproduct['rate'] = $rate[$i];
            $purproduct['amount'] = $amt[$i];
            $this->Purchase_model->create_purchase_product($purproduct);
          }
        }
        
      }

$rmslist = $this->Purchase_model->get_rawmaterial_stock_by_bcno($bcno);

$this->Purchase_model->update_rmstock_purchase_id_by_bcno($bcno,$pid);

}

$this->session->set_flashdata('add_success', 'Purchase has been updated successfully.');
      redirect('/purchase');
    }
  }*/
  public function downloadbill($id)
  {
    if ($id) {
      $purchase_details = $this->Purchase_model->get_purchase_by_id($id);
      $pbill = $purchase_details->purchase_bill;
      $file = realpath ( "purchasebill" ) . "/" . $pbill;
      
      // check file exists    
      if (file_exists ( $file )) {
       // get file content
       $data = file_get_contents ( $file );
       //force download
       force_download ( $pbill, $data );
      } else {
       // Redirect to base url
       redirect ( base_url ('purchase') );
      }
     }
  }

public function pur_approve()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('purchase/purchase_approve',$data);
  }

/*public function purchaseApprove(){ 
    $bid=$_POST['field'];
    $purchase_details = $this->Purchase_model->get_purchase_by_id($bid);
    //$bill_no = $purchase_details->bill_copy_no;
    $grn_id = $purchase_details->grn_id;
    $grn_products = $this->Purchase_model->get_grn_product_by_grn_id($grn_id);

//$grn_list = $this->Purchase_model->get_grn_by_bil_no($bill_no);
    $grn_list = $this->Grn_model->get_grn_by_id($grn_id);

foreach($grn_products as $gprod)
    {
      $grnid = $gprod['grn_id'];
      $grn_details = $this->Grn_model->get_grn_by_id($grnid);

if($grn_list->type=='raw material')      
      {
        $data['location_id']=$grn_details->location_id;
        $data['rm_date'] = date('Y-m-d'); 
        $data['rawmaterial_id'] = $gprod['rawmaterial_id'];
        $last_id_value = $this->Rawmaterialstock_model->last_id();
        if(count($last_id_value)==0)
        {
          $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO001';
        }
        else
        {
          $lno = $last_id_value->m_no;
          $exlno = substr($lno,12);
          $next_value = (int)$exlno + 1;
          $slen = strlen($next_value);
          if($slen==1)
            $nval = '00'.$next_value;
          else if($slen==2)
            $nval = '0'.$next_value;
          else
            $nval = $next_value;
          $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO'.$nval;
        }
        $data['stock'] = $gprod['net_weight'];
        $nwgt = $data['net_weight'] = $gprod['net_weight'];
        $data['created_on'] = date('Y-m-d H:i:s');
        $data['created_by'] = $_SESSION['user_id'];
        $data['grn_id'] = $grnid;

$this->Purchase_model->create_rawmaterial_stock($data);
        $grnid = $gprod['grn_id'];

$rmnorep = str_replace('/', '-', $mno);
        //$rmnorep = $rmnorep.'-'.$nwgt;
        $rmnorep = $rmnorep.'-'.number_format((float)$nwgt, 3, '.', '');
        $this->load->library('zend');
        $this->zend->load('Zend/Barcode');
     
        $file = Zend_Barcode::draw('code128', 'image', array('text' => $rmnorep), array());
        $store_image = imagepng($file,"./mnobarcode/{$rmnorep}.png");
      }
      else
      {
        $pstock = $this->Purchase_model->get_product_stock_by_location_id($gprod['product_id'],$grn_details->location_id);
        if(count($pstock)>0)
        {
          $ostk = $pstock->stock;
          $upstk['stock'] = $ostk+$gprod['quantity'];
          $upstk['booked'] = $pstock->booked;
          $upstk['need_production'] = $pstock->need_production;
          $upstk['modified_on'] = date('Y-m-d H:i:s');
          $upstk['modified_by'] = $_SESSION['user_id'];
          $this->Purchase_model->update_product_stock_by_location_id($grn_details->location_id,$gprod['product_id'],$upstk);
        }
        else
        {          
          $data['location_id']=$grn_details->location_id;
          $data['product_id'] = $gprod['product_id']; 
          $data['stock'] = $gprod['quantity'];
          $data['created_on'] = date('Y-m-d H:i:s');
          $data['created_by'] = $_SESSION['user_id'];
          $this->Purchase_model->add_product_stock_by_location_id($data);
        }
      }
    }

$grn['grn_id'] = $grnid;
    $grn['status'] = 1;
    $grn['modified_on'] = date('Y-m-d H:i:s');
    $grn['modified_by'] = $_SESSION['user_id'];

$this->Purchase_model->update_grn_status($grn);

$pur['purchase_id'] = $bid;
    $pur['status'] = 1;
    $pur['modified_on'] = date('Y-m-d H:i:s');
    $pur['modified_by'] = $_SESSION['user_id'];

$result = $this->Purchase_model->purchaseApprove($pur);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Purchase has been Approved successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }*/

public function purchaseApprove(){ 
    $bid=$_POST['field'];

$pdet = $this->Purchase_model->get_purchase_by_purchase_id($bid);
    $purdate = $pdet->purchase_date;
    if($pdet->grn_id!=0)
    {
      $purchase_details = $this->Purchase_model->get_purchase_by_id($bid);
      //$bill_no = $purchase_details->bill_copy_no;
      $grn_id = $purchase_details->grn_id;
      $stid = $purchase_details->state_id;
      //$grn_products = $this->Purchase_model->get_grn_product_by_grn_id($grn_id);
      //$grn_products = $this->Purchase_model->get_purchase_product_by_id($bid);
      $grn_list = $this->Grn_model->get_grn_by_id($grn_id);

if($grn_list->type == 'raw material')
        $grn_products = $this->Purchase_model->get_purchase_product_by_id($bid);
      else
        $grn_products = $this->Purchase_model->get_purchase_product_by_product_id($bid);

//$grn_list = $this->Purchase_model->get_grn_by_bil_no($bill_no);

foreach($grn_products as $gprod)
      {
        //$grnid = $gprod['grn_id'];
        $grn_details = $this->Grn_model->get_grn_by_id($grn_id);

if($grn_list->type=='raw material')      
        {
          $data['location_id']=$grn_details->location_id;
          $data['rm_date'] = date('Y-m-d'); 
          $data['rawmaterial_id'] = $gprod['raw_material_id'];
          $last_id_value = $this->Rawmaterialstock_model->last_id();
          if(count($last_id_value)==0)
          {
            $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO001';
          }
          else
          {
            $lno = $last_id_value->m_no;
            $exlno = substr($lno,12);
            $next_value = (int)$exlno + 1;
            $slen = strlen($next_value);
            if($slen==1)
              $nval = '00'.$next_value;
            else if($slen==2)
              $nval = '0'.$next_value;
            else
              $nval = $next_value;
            $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO'.$nval;
          }
          $data['stock'] = $gprod['purchase_quantity'];
          $nwgt = $data['net_weight'] = $gprod['purchase_quantity'];
          $data['created_on'] = date('Y-m-d H:i:s');
          $data['created_by'] = $_SESSION['user_id'];
          $data['grn_id'] = $grn_id;

$this->Purchase_model->create_rawmaterial_stock($data);
          //$grnid = $gprod['grn_id'];

$rmnorep = str_replace('/', '-', $mno);
          //$rmnorep = $rmnorep.'-'.$nwgt;
          $rmnorep = $rmnorep.'-'.number_format((float)$nwgt, 3, '.', '');
          $this->load->library('zend');
          $this->zend->load('Zend/Barcode');
       
          $file = Zend_Barcode::draw('code128', 'image', array('text' => $rmnorep), array());
          $store_image = imagepng($file,"./mnobarcode/{$rmnorep}.png");
        }
        else
        {
          $pstock = $this->Purchase_model->get_product_stock_by_location_id($gprod['product_id'],$grn_details->location_id);
          if(count($pstock)>0)
          {
            $ostk = $pstock->stock;
            $upstk['stock'] = $ostk+$gprod['purchase_quantity'];
            $upstk['booked'] = $pstock->booked;
            $upstk['need_production'] = $pstock->need_production;
            $upstk['modified_on'] = date('Y-m-d H:i:s');
            $upstk['modified_by'] = $_SESSION['user_id'];
            $this->Purchase_model->update_product_stock_by_location_id($grn_details->location_id,$gprod['product_id'],$upstk);
          }
          else
          {          
            $data['location_id']=$grn_details->location_id;
            $data['product_id'] = $gprod['product_id']; 
            $data['stock'] = $gprod['purchase_quantity'];
            $data['created_on'] = date('Y-m-d H:i:s');
            $data['created_by'] = $_SESSION['user_id'];
            $this->Purchase_model->add_product_stock_by_location_id($data);
          }
        }
      }

$grn['grn_id'] = $grn_id;
      $grn['status'] = 1;
      $grn['modified_on'] = date('Y-m-d H:i:s');
      $grn['modified_by'] = $_SESSION['user_id'];

$this->Purchase_model->update_grn_status($grn);
    }
    else
    {
      //$locdetails = $this->Invoice_model->get_location_by_id($locId);
      //$locname = $locdetails->location_name;
      $vendetails = $this->Invoice_model->get_vendor_by_id($pdet->vendor_id);
      $stid = $vendetails->state_id;
      $purinv = $pdet->invoice_no;
      $invdet = $this->Purchase_model->get_invoice_by_invoice_no($purinv);
      if($invdet->type == 'raw material')
        $grn_products = $this->Purchase_model->get_purchase_product_by_id($bid);
      else
        $grn_products = $this->Purchase_model->get_purchase_product_by_product_id($bid);
      foreach($grn_products as $gprod)
      {
        if($invdet->type=='raw material')      
        {
          $data['location_id']=$pdet->location_id;
          $data['rm_date'] = date('Y-m-d'); 
          $data['rawmaterial_id'] = $gprod['raw_material_id'];
          $last_id_value = $this->Rawmaterialstock_model->last_id();
          if(count($last_id_value)==0)
          {
            $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO001';
          }
          else
          {
            $lno = $last_id_value->m_no;
            $exlno = substr($lno,12);
            $next_value = (int)$exlno + 1;
            $slen = strlen($next_value);
            if($slen==1)
              $nval = '00'.$next_value;
            else if($slen==2)
              $nval = '0'.$next_value;
            else
              $nval = $next_value;
            $mno = $data['m_no'] = date("Y").'/'.date('m').'/RMNO'.$nval;
          }
          $data['stock'] = $gprod['purchase_quantity'];
          $nwgt = $data['net_weight'] = $gprod['purchase_quantity'];
          $data['created_on'] = date('Y-m-d H:i:s');
          $data['created_by'] = $_SESSION['user_id'];
          $data['grn_id'] = 0;

$this->Purchase_model->create_rawmaterial_stock($data);
          //$grnid = $gprod['grn_id'];

$rmnorep = str_replace('/', '-', $mno);
          //$rmnorep = $rmnorep.'-'.$nwgt;
          $rmnorep = $rmnorep.'-'.number_format((float)$nwgt, 3, '.', '');
          $this->load->library('zend');
          $this->zend->load('Zend/Barcode');
       
          $file = Zend_Barcode::draw('code128', 'image', array('text' => $rmnorep), array());
          $store_image = imagepng($file,"./mnobarcode/{$rmnorep}.png");
        }
        else
        {
          $pstock = $this->Purchase_model->get_product_stock_by_location_id($gprod['product_id'],$pdet->location_id);
          
          if(count($pstock)>0)
          {
            $ostk = $pstock->stock;
            $upstk['stock'] = $ostk+$gprod['purchase_quantity'];
            $upstk['booked'] = $pstock->booked;
            $upstk['need_production'] = $pstock->need_production;
            $upstk['modified_on'] = date('Y-m-d H:i:s');
            $upstk['modified_by'] = $_SESSION['user_id'];
            $this->Purchase_model->update_product_stock_by_location_id($pdet->location_id,$gprod['product_id'],$upstk);
          }
          else
          {          
            $data['location_id']=$pdet->location_id;
            $data['product_id'] = $gprod['product_id']; 
            $data['stock'] = $gprod['purchase_quantity'];
            $data['created_on'] = date('Y-m-d H:i:s');
            $data['created_by'] = $_SESSION['user_id'];
            $this->Purchase_model->add_product_stock_by_location_id($data);
          }
        }
      }
    }

$pur['purchase_id'] = $bid;
    $pur['status'] = 1;
    $pur['modified_on'] = date('Y-m-d H:i:s');
    $pur['modified_by'] = $_SESSION['user_id'];

$result = $this->Purchase_model->purchaseApprove($pur);
    if ($result) {

if($stid == 33)
      {
        $pgst = $purchase_details->tax_percent/2;
        $cgstledgname = 'INPUT CGST '.$pgst.'%';
        $cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$grn_list->location_id);
        if(count($cgstledg)>0)
        {
          $cgst = $purchase_details->tax_amount/2;
          $cgstdata['tax_ledger_line_item_date'] = $purdate;
          $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
          $cgstdata['tax_type'] = 1;
          $cgstdata['type'] = 'Purchase Tax';
          $cgstdata['type_id'] = $purchase_details->purchase_id;
          $cgstdata['amount'] = $cgst;
          $cgstdata['status'] = 0;
          $cgstdata['created_on'] = date('Y-m-d H:i:s');
          $cgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$grn_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$cgstledgname;
          $this->Ledger_model->create_ledger_list($led);

$cgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($cgstledgname,$grn_list->location_id);
          if(count($cgstledg)>0)
          {
            $cgst = $purchase_details->tax_amount/2;
            $cgstdata['tax_ledger_line_item_date'] = $purdate;
            $cgstdata['ledger_list_id'] = $cgstledg->ledger_list_id;
            $cgstdata['tax_type'] = 1;
            $cgstdata['type'] = 'Purchase Tax';
            $cgstdata['type_id'] = $purchase_details->purchase_id;
            $cgstdata['amount'] = $cgst;
            $cgstdata['status'] = 0;
            $cgstdata['created_on'] = date('Y-m-d H:i:s');
            $cgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($cgstdata);
          }
        }

$sgstledgname = 'INPUT SGST '.$pgst.'%';
        $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$grn_list->location_id);
        if(count($sgstledg)>0)
        {
          $sgst = $purchase_details->tax_amount/2;
          $sgstdata['tax_ledger_line_item_date'] = $purdate;
          $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
          $sgstdata['tax_type'] = 1;
          $sgstdata['type'] = 'Purchase Tax';
          $sgstdata['type_id'] = $purchase_details->purchase_id;
          $sgstdata['amount'] = $sgst;
          $sgstdata['status'] = 0;
          $sgstdata['created_on'] = date('Y-m-d H:i:s');
          $sgstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$grn_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$sgstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $sgstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($sgstledgname,$grn_list->location_id);
          if(count($sgstledg)>0)
          {
            $sgst = $purchase_details->tax_amount/2;
            $sgstdata['tax_ledger_line_item_date'] = $purdate;
            $sgstdata['ledger_list_id'] = $sgstledg->ledger_list_id;
            $sgstdata['tax_type'] = 1;
            $sgstdata['type'] = 'Purchase Tax';
            $sgstdata['type_id'] = $purchase_details->purchase_id;
            $sgstdata['amount'] = $sgst;
            $sgstdata['status'] = 0;
            $sgstdata['created_on'] = date('Y-m-d H:i:s');
            $sgstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($sgstdata);
          }
        }
        
      }
      else
      {
        $igsttax = $purchase_details->tax_percent;
        $igstledgname = 'INPUT IGST '.$igsttax.'%';
        $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$grn_list->location_id);
        if(count($igstledg)>0)
        {
          $igst = $purchase_details->tax_amount;
          $igstdata['tax_ledger_line_item_date'] = $purdate;
          $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
          $igstdata['tax_type'] = 1;
          $igstdata['type'] = 'Purchase Tax';
          $igstdata['type_id'] = $purchase_details->purchase_id;
          $igstdata['amount'] = $igst;
          $igstdata['status'] = 0;
          $igstdata['created_on'] = date('Y-m-d H:i:s');
          $igstdata['created_by'] = $_SESSION['user_id'];
          $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
        }
        else
        {
          $led['type']='Liabilities';
          $led['account_attributes_id']=10;
          $led['location_id']=$grn_list->location_id;
          $led['remarks']='';
          $led['opening_balance']=0;
          $led['status'] = 0;
          $led['created_on'] = date('Y-m-d H:i:s');
          $led['created_by'] = $_SESSION['user_id'];
          $led['ledger_code']='';
          $led['crdr']=0;
          $led['tax_ledger_status']=1;
          $led['ledger_list']=$igstledgname;
          $this->Ledger_model->create_ledger_list($led);
          
          $igstledg = $this->Invoice_model->get_tax_ledger_by_name_loc_id($igstledgname,$grn_list->location_id);
          if(count($igstledg)>0)
          {
            $igst = $purchase_details->tax_amount;
            $igstdata['tax_ledger_line_item_date'] = $purdate;
            $igstdata['ledger_list_id'] = $igstledg->ledger_list_id;
            $igstdata['tax_type'] = 1;
            $igstdata['type'] = 'Purchase Tax';
            $igstdata['type_id'] = $purchase_details->purchase_id;
            $igstdata['amount'] = $igst;
            $igstdata['status'] = 0;
            $igstdata['created_on'] = date('Y-m-d H:i:s');
            $igstdata['created_by'] = $_SESSION['user_id'];
            $this->Invoice_model->insert_tax_ledger_line_item($igstdata);
          }
        }
      }

$this->session->set_flashdata('add_success', 'Purchase has been Approved successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function pur_delete()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('purchase/purchase_delete',$data);
  }

public function purchaseDelete(){ 
    $bid=$_POST['field'];
    $result = $this->Purchase_model->purchase_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Purchase has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function pur_up_bill()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('purchase/bill_upload',$data);
  }

public function bill_upload()
  {
    $pid = $data['purchase_id'] = $this->input->post('purchase_id');
    $purdet = $this->Purchase_model->get_purchase_by_id($pid);

$rmnorep = str_replace('/', '-', $purdet->purchase_no);

if(!empty($_FILES['purchase_bill']['name'])){
      $ext = pathinfo($_FILES['purchase_bill']['name'], PATHINFO_EXTENSION);
      $config['upload_path'] = 'purchasebill';
      $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
      $config['file_name'] = $rmnorep;
      $profileName = $config['file_name'].'.'.$ext;
      $this->load->library('upload',$config);
      $this->upload->initialize($config);
      if($this->upload->do_upload('purchase_bill'))
      {
        $uploadData = $this->upload->data();
        $data['purchase_bill'] = $profileName;
      }
      else
      {
        $data['purchase_bill'] = '';
      }
    }
    else
    {
      $data['purchase_bill'] = '';
    }
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];

$result = $this->Purchase_model->update_purchase_bill($data);

if($result)
    {
      $this->session->set_flashdata('add_success', 'Purchase Bill has been uploaded successfully.');
      redirect('/purchase');
    }
  }

public function barcode_sample_download($id)
  {
    $pur_list = $this->Purchase_model->get_purchase_by_id($id);
    //$this->load->view('invoice/barcode_printview',$data);

$rmslist = $this->Purchase_model->get_rawmaterial_stock_by_grn_id($pur_list->grn_id);

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
            'font' => array(
                'bold' => true,
                'color' => array('rgb' => '000000')
            )
        );
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Barcode');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);

$i=2;
    $g_settings = general_setting_details();
    foreach($rmslist as $rms) {
      $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $rms['rawmaterial']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $rms['m_no']);
      $i++;
    }
    $filename='rawmaterial_barcode.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation