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: Warehousestocktransfer.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Warehousestocktransfer extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Warehousestocktransfer_model'));
    $this->load->model(array('Stocktransfer_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', 'Stock Transfer Warehouse');
  }

public function warehousestocktransfer_export()
  {
    $whssearch_change = isset($_SESSION['whssearch_change'])?$_SESSION['whssearch_change']:'';

if ($whssearch_change != '') {
      $sc = 'AND (l.location_name LIKE "%'.$whssearch_change.'%" OR w.warehouse_name LIKE "%'.$whssearch_change.'%" OR wt.transfer_date LIKE "%'.$whssearch_change.'%")';
    }
    else {
      $sc = '';
    }

$warehousestocktransfer_list = $this->db->query("SELECT wt.*,l.location_name,w.warehouse_name FROM warehouse_transfer wt,location l, warehouse w WHERE wt.location_id = l.location_id AND wt.warehouse_id = w.warehouse_id $sc ORDER BY wt.warehouse_transfer_id DESC")->result_array();

$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', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Location');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Warehouse');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($warehousestocktransfer_list as $u_list ) {

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($u_list['transfer_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $u_list['warehouse_name']);

$i++;
    }

$filename='Warehouse_Stock_Transfer.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() . "warehousestocktransfer";
    $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'];
    
    if ($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['whssearch_change'])))) {
      // $this->session->set_userdata('whssearch_change', $this->input->post('whs_search')!=''?$this->input->post('whs_search'):$_SESSION['whssearch_change']);
      $this->session->set_userdata('whssearch_change', $this->input->post('whs_search'));
      $whssearch_change = isset($_SESSION['whssearch_change'])?$_SESSION['whssearch_change']:$this->input->post('whs_search');

if ($whssearch_change != '') {
        $sc = 'AND (l.location_name LIKE "%'.$whssearch_change.'%" OR w.warehouse_name LIKE "%'.$whssearch_change.'%" OR wt.transfer_date LIKE "%'.$whssearch_change.'%")';
      }
      else {
        $sc = '';
      }
      $data['whssearch_change'] = $whssearch_change;

$data['warehousestocktransfer_list_count'] = $this->db->query("SELECT wt.*,l.location_name,w.warehouse_name FROM warehouse_transfer wt,location l, warehouse w WHERE wt.location_id = l.location_id AND wt.warehouse_id = w.warehouse_id $sc ORDER BY wt.warehouse_transfer_id DESC")->result_array();
      $config['total_rows'] = count($data['warehousestocktransfer_list_count']);

$data['warehousestocktransfer_list'] = $this->db->query("SELECT wt.*,l.location_name,w.warehouse_name FROM warehouse_transfer wt,location l, warehouse w WHERE wt.location_id = l.location_id AND wt.warehouse_id = w.warehouse_id $sc ORDER BY wt.warehouse_transfer_id DESC LIMIT $page, $perpage")->result_array();
    }
    else {
      $data['whssearch_change'] = '';
      $this->session->unset_userdata('whssearch_change');
      $data['warehousestocktransfer_list_count'] = $this->db->query("SELECT wt.*,l.location_name,w.warehouse_name FROM warehouse_transfer wt,location l, warehouse w WHERE wt.location_id = l.location_id AND wt.warehouse_id = w.warehouse_id ORDER BY wt.warehouse_transfer_id DESC")->result_array();
      $config['total_rows'] = count($data['warehousestocktransfer_list_count']);

$data['warehousestocktransfer_list'] = $this->db->query("SELECT wt.*,l.location_name,w.warehouse_name FROM warehouse_transfer wt,location l, warehouse w WHERE wt.location_id = l.location_id AND wt.warehouse_id = w.warehouse_id ORDER BY wt.warehouse_transfer_id DESC LIMIT $page, $perpage")->result_array();
    }
    // $data['warehousestocktransfer_list'] = $this->Warehousestocktransfer_model->get_warehouse_stock_transfer_list(); 
    $this->pagination->initialize($config);
    $data['links'] = $this->pagination->create_links();   
    $this->load->view('warehousestocktransfer/warehousestocktransfer_list',$data);
  }

public function warehousestocktransfer_add()
  {
    $data['location_list'] = $this->Stocktransfer_model->get_active_location();
    $this->load->view('warehousestocktransfer/warehousestocktransfer_add',$data);
  }
  public function getLocationWarehouse()
    {
        $lid = $_POST['id'];
        $product = $this->Warehousestocktransfer_model->get_warehouse_by_location_id($lid);
        if(count($product)>0)
        {
          $st = '<option value="">Select Warehouse</option>';
          foreach ($product as $prod) {
            $st.='<option value='.$prod["warehouse_id"].'>'.$prod["warehouse_name"].'</option>';
          }
        }
        else
        {
          $st = '<option value="">No Warehouse Available</option>';
        }
        echo $st;
    }

public function getLocationRawmaterial()
    {
        $lid = $_POST['id'];
        $product = $this->Warehousestocktransfer_model->get_rawmaterial_by_location_id($lid);
        if(count($product)>0)
        {
          $st = '<option value="">Select Rawmaterial</option>';
          foreach ($product as $prod) {
            if($prod['totstock']!=0)
            {
                $st.='<option value='.$prod["rawmaterial_id"].'>'.$prod["rawmaterial"].'</option>';
            }
          }
        }
        else
        {
          $st = '<option value="">No Rawmaterial Available</option>';
        }
        echo $st;
    }

public function getLocationProduct()
    {
        $lid = $_POST['id'];
        $product = $this->Warehousestocktransfer_model->get_product_stock_location_id($lid);
        if(count($product)>0)
        {
          $st = '<option value="">Select Product</option>';
          foreach ($product as $prod) {
            if($prod['totstock']!=0)
            {
                $st.='<option value='.$prod["product_id"].'>'.$prod["product_name"].'</option>';
            }
          }
        }
        else
        {
          $st = '<option value="">No Product Available</option>';
        }
        echo $st;
    }

public function getRawmaterialStock()
  {    
    $locId = $_POST['locId'];
    $rmId = $_POST['rmId'];
    $product = $this->Warehousestocktransfer_model->get_rawmaterial_totstock_by_id($rmId,$locId);
    if(count($product)>0)
      echo $product->totstock;
    else
      echo '0';
  }

public function getProductStock()
  {    
    $locId = $_POST['locId'];
    $pId = $_POST['pId'];
    $product = $this->Warehousestocktransfer_model->get_product_totstock_by_id($pId,$locId);
    if(count($product)>0)
      echo $product->totstock;
    else
      echo '0';
  }

public function create_warehousestocktransfer()
  {
    $data['transfer_date'] = date('Y-m-d');
    $locId = $data['location_id'] = $this->input->post('location_id');
    $whId = $data['warehouse_id'] = $this->input->post('warehouse_id');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $result = $this->Warehousestocktransfer_model->create_warehousestocktransfer($data);
    if ($result) {
      $last_id_value = $this->Warehousestocktransfer_model->last_id();
      $last_value=$last_id_value->warehouse_transfer_id;

$typ = explode(",",implode(",",$this->input->post('type')));
      $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
      $prodid = explode(",",implode(",",$this->input->post('product_id')));
      $stk = explode(",",implode(",",$this->input->post('stock')));
      $subcount = count($this->input->post('type')); 
      for($i=0;$i<$subcount;$i++)
      {
        if($typ[$i] != ''){
          if($typ[$i]=='rawmaterial')
          {
            $stock = $stk[$i];
            $rmstock = $this->Warehousestocktransfer_model->get_rawmaterial_stock_by_location_rawmaterial_id($locId,$rmid[$i]);
            foreach($rmstock as $rms)
            {
              if($rms['stock']>=$stock)
              {
                $sk = $rms['stock']-$stock;
                $this->Warehousestocktransfer_model->update_rawmaterial_stock_by_id($sk,$rms['rawmaterial_stock_id']);
                break;
              }
              else
              {
                $sk=0;
                $this->Warehousestocktransfer_model->update_rawmaterial_stock_by_id($sk,$rms['rawmaterial_stock_id']);
                $stock = $stock-$rms['stock'];
              }
            }

$wtrm['warehouse_transfer_id'] = $last_value;
            $wtrm['type'] = $typ[$i];
            $wtrm['rawmaterial_id'] = $rmid[$i];
            $wtrm['product_id'] = 0;
            $wtrm['stock'] = $stk[$i];
            $this->Warehousestocktransfer_model->create_warehousestocktransfer_product($wtrm);

$wstk = $this->Warehousestocktransfer_model->get_whstock_by_location_wh_rawmaterial($locId,$whId,$rmid[$i]);
            if(count($wstk)>0)
            {
              $whstk = $wstk->stock;
              $warstkrm = $whstk+$stk[$i];
              $this->Warehousestocktransfer_model->update_warehouse_stock_by_id($warstkrm,$wstk->warehouse_stock_id);
            }
            else
            {
              $whsdet['location_id'] = $locId;
              $whsdet['warehouse_id'] = $whId;
              $whsdet['rawmaterial_id'] = $rmid[$i];
              $whsdet['product_id'] = 0;
              $whsdet['stock'] = $stk[$i];
              $whsdet['created_on'] = date('Y-m-d H:i:s');
              $whsdet['created_by'] = $_SESSION['user_id'];
              $this->Warehousestocktransfer_model->create_warehouse_stock($whsdet);
            }
          }
          else
          {
            $stock = $stk[$i];
            $prodstock = $this->Warehousestocktransfer_model->get_product_stock_by_location_id($prodid[$i],$locId);
            $pstock = $prodstock->stock;
            $fstock = $pstock-$stock;
            $this->Warehousestocktransfer_model->update_product_stock_by_product_stock_id($prodstock->product_stock_id,$fstock);

$wtprod['warehouse_transfer_id'] = $last_value;
            $wtprod['type'] = $typ[$i];
            $wtprod['rawmaterial_id'] = 0;
            $wtprod['product_id'] = $prodid[$i];
            $wtprod['stock'] = $stk[$i];
            $this->Warehousestocktransfer_model->create_warehousestocktransfer_product($wtprod);

$wstk = $this->Warehousestocktransfer_model->get_whstock_by_location_wh_product($locId,$whId,$prodid[$i]);
            if(count($wstk)>0)
            {
              $whstk = $wstk->stock;
              $warstkrm = $whstk+$stk[$i];
              $this->Warehousestocktransfer_model->update_warehouse_stock_by_id($warstkrm,$wstk->warehouse_stock_id);
            }
            else
            {
              $whsdet['location_id'] = $locId;
              $whsdet['warehouse_id'] = $whId;
              $whsdet['rawmaterial_id'] = 0;
              $whsdet['product_id'] = $prodid[$i];
              $whsdet['stock'] = $stk[$i];
              $whsdet['created_on'] = date('Y-m-d H:i:s');
              $whsdet['created_by'] = $_SESSION['user_id'];
              $this->Warehousestocktransfer_model->create_warehouse_stock($whsdet);
            }
          }
        }
      }
      $this->session->set_flashdata('add_success', 'Warehouse Stock Transfered successfully.');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Something Went Wrong.');
    }
    redirect('/warehousestocktransfer');
  }

public function warehousestocktransfer_view($wstid)
  {
    $data['wstransfer_list'] = $this->Warehousestocktransfer_model->get_warehouse_stock_transfer_by_id($wstid);
    $data['wstransfer_product_list'] = $this->Warehousestocktransfer_model->get_warehouse_stock_transfer_product_by_id($wstid);
    $this->load->view('warehousestocktransfer/warehousestocktransfer_view',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Warehousestocktransfer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation