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

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

public function index()
  { 
    $data['location_list'] = $this->Warehousestock_model->get_location();
    $data['warehouse_list'] = $this->Warehousestock_model->get_warehouse_list();

if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      $locchange = $this->input->post('filterctype');
      $warchange = $this->input->post('filterwar');
      if($locchange!='')
        $ct = 'AND ws.location_id='.$locchange;
      else
        $ct = '';
    if($warchange!='')
        $wh = 'AND ws.warehouse_id='.$warchange;
      else
        $wh = '';
      $data['locchange'] = $locchange;
      $data['warchange'] = $warchange;
      $data['warehouse_stock_list'] = $this->db->query("SELECT ws.*,l.location_name,w.warehouse_name FROM `warehouse_stock` ws, location l, warehouse w WHERE ws.location_id = l.location_id AND ws.warehouse_id = w.warehouse_id $wh $ct ORDER BY ws.location_id ASC ")->result_array();
    }
    else
    {
      $data['locchange'] = '';
      $data['warchange'] = '';
      $data['warehouse_stock_list'] = $this->Warehousestock_model->get_warehouse_stock_list();
    }
    
    $this->load->view('warehousestock/warehousestock_list',$data);
  }

public function update_warehousestock_upload()
  {    
    $this->load->view('warehousestock/update_warehousestock_upload');
  }

public function update_sampleupload()
  {
    $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()->getRowDimension(1)->setRowHeight(20);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Company');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Warehouse');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Product');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Rawmaterial');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Stock');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);

$warehousestock = $this->Warehousestock_model->get_warehouse_stock_list();

$i=2;
    foreach($warehousestock as $loc) {

if($loc['product_id']==0)
        {
            $rawmat = $this->Warehousestock_model->get_rawmaterial_by_id($loc['rawmaterial_id']);
            $raw = $rawmat->rawmaterial;
            $prod = '';
        }
        else
        {
            $prodmat = $this->Warehousestock_model->get_product_view_by_id($loc['product_id']);
            $raw = '';
            $prod = $prodmat->product_name;
        }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $loc['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $loc['warehouse_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prod);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $raw);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $loc['stock']);
      $i++;
    }

$filename='Warehousestock_update.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 update_warehousestock_import()
  {
    if(isset($_POST["import"]))
    {
      PHPExcel_IOFactory::createReader('Excel2007');
      $filename=$_FILES["file"]["tmp_name"];
      if($_FILES["file"]["size"] > 0)
      {
        try
        {
          $objPHPExcel = PHPExcel_IOFactory::load($filename);
        }catch(Exception $e)
        {
          die('Error loading file "'.pathinfo($filename,PATHINFO_BASENAME).'": '.$e->getMessage());
        }
        $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
        $arrayCount = count($allDataInSheet);  // Here get total count of row in that Excel sheet
        $ins=0;$alr=0;$emptrow=1;
        
        if(trim($allDataInSheet[1]["A"])=='Company' && trim($allDataInSheet[1]["B"])=='Warehouse' && trim($allDataInSheet[1]["C"])=='Product' && trim($allDataInSheet[1]["D"])=='Rawmaterial' && trim($allDataInSheet[1]["E"])=='Stock')
        {
          $val=0;$iv='';$err='';
          for($i=2;$i<=$arrayCount;$i++){
            $ln='';$wh='';$prod='';$rm='';$stk='';
            if(trim($allDataInSheet[1]["A"])=='' && trim($allDataInSheet[1]["B"])=='' && trim($allDataInSheet[1]["C"])=='' && trim($allDataInSheet[1]["D"])=='' && trim($allDataInSheet[1]["E"])=='')
            {
              $emptrow++;
              $errmsg = '1';
            }
            else
            {
              if(trim($allDataInSheet[$i]["A"])!='')
              {
                $locn = $this->Warehousestock_model->get_location_by_name($allDataInSheet[$i]["A"]);
                if(count($locn)>0)
                {
                  $lid = $proddata['location_id'] = $locn->location_id;
                }
                else
                {
                  $ln = $i;
                }
              }

if(trim($allDataInSheet[$i]["B"])!='')
              {
                $locn = $this->Warehousestock_model->get_warehouse_by_name($allDataInSheet[$i]["B"]);
                if(count($locn)>0)
                {
                  $wid = $proddata['warehouse_id'] = $locn->warehouse_id;
                }
                else
                {
                  $wh = $i;
                }
              }

if((trim($allDataInSheet[$i]["C"])!='') || (trim($allDataInSheet[$i]["D"])!=''))
              {
                  if(trim($allDataInSheet[$i]["C"])!='')
                  {
                    $prodname = $this->Warehousestock_model->get_product_by_product_name($allDataInSheet[$i]["C"]);
                    if(count($prodname)>0)
                    {
                      $pid = $proddata['product_id'] = $prodname->product_id;
                      $rid = '';
                    }
                    else
                    {
                      $prod = $i;
                    }
                  }

if(trim($allDataInSheet[$i]["D"])!='')
                  {
                    $prodname = $this->Warehousestock_model->get_rawmaterial_by_name($allDataInSheet[$i]["D"]);
                    if(count($prodname)>0)
                    {
                      $rid = $proddata['rawmaterial_id'] = $prodname->rawmaterial_id;
                      $pid = '';
                    }
                    else
                    {
                      $rm = $i;
                    }
                  }
              }
              else
              {
                $prod = $i;
              }

if(trim($allDataInSheet[$i]["E"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["E"])))
                {
                  $stock = trim($allDataInSheet[$i]["E"]);
                }
                else
                {
                  $stk = $i;
                }
              }
              else
              {
                $stk = $i;
              }

}

if($ln=='' && $wh=='' && $prod=='' && $rm=='' && $stk=='')
            {
                if($pid!='')
                    $pstock = $this->Warehousestock_model->get_warehouse_stock_by_loc_war_prod_id($lid,$wid,$pid);
                else
                    $pstock = $this->Warehousestock_model->get_warehouse_stock_by_loc_war_rm_id($lid,$wid,$rid);
              if(count($pstock)>0)
              {
                //$ostk = $pstock->stock;
                $wsdata['stock'] = $stock;
                $wsdata['warehouse_stock_id'] = $pstock->warehouse_stock_id;
                $this->Warehousestock_model->update_warehouse_stock_by_id($wsdata);
              }
              /*else
              {          
                $data['location_id']=$lid;
                $data['product_id'] = $pid; 
                $data['stock'] = $stock;
                $data['created_on'] = date('Y-m-d H:i:s');
                $data['created_by'] = $_SESSION['user_id'];
                $this->Productstock_model->add_product_stock_by_location_id($data);
              }*/
            }
            else
            {
              if($iv=='')
                $iv = $i;
              else
                $iv.= ','.$i;
            }

}

if($emptrow==$arrayCount)
            $this->session->set_flashdata('add_err', 'All Rows are Empty');
          else if($iv=='')
            $this->session->set_flashdata('add_success', 'Warehouse Stock Updated Successfully.');
          else
            $this->session->set_flashdata('add_err', 'Some Error In row '.$iv);
          redirect('/warehousestock/update_warehousestock_upload');

}
        else
        {
          $this->session->set_flashdata('add_err', 'Invalid File.');
          redirect('/warehousestock/update_warehousestock_upload');
        }
      }
    }
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Warehousestock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation