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

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

public function index()
  { 
    $data['stocktransfer_list'] = $this->Stocktransfer_model->get_stock_transfer_list();    
    $this->load->view('stocktransfer/stocktransfer_list',$data);
  }

public function stocktransfer_add()
  {
    $data['location_list'] = $this->Stocktransfer_model->get_active_location();
    $data['rawmaterial_list'] = $this->Stocktransfer_model->get_active_rawmaterials();
    $data['product_list'] = $this->Stocktransfer_model->get_active_products();
    $this->load->view('stocktransfer/stocktransfer_add',$data);
  }

public function getProductStock()
  {    
    $pid = $_POST['id'];
    $lid = $_POST['lid'];
    $product = $this->Stocktransfer_model->get_product_stock_by_location_id($pid,$lid);
    if(count($product)>0)
      echo $product->product_stock_id."|".$product->stock;
    else
      echo '0|0';
  }

public function getRawmaterialStock()
  {    
    $rmsid = $_POST['id'];
    $product = $this->Stocktransfer_model->get_rawmaterial_stock_by_id($rmsid);
    if(count($product)>0)
      echo $product->stock;
    else
      echo '0';
  }

public function getRawMaterialMNO()
  {
    $rmid = $_POST['id'];
    $lid = $_POST['lid'];
    $product = $this->Stocktransfer_model->get_rawmaterial_stock_by_location_id($rmid,$lid);
    if(count($product)>0)
    {
      $st = '<option value="">Select MNO</option>';
      foreach ($product as $prod) {
        if($prod['stock']>0){
          $st.='<option value='.$prod["rawmaterial_stock_id"].'>'.$prod["m_no"].'</option>';
        }
      }
    }
    else
    {
      $st = '<option value="">No Stock Available</option>';
    }
    echo $st;
  }

public function create_stocktransfer()
  {
    $data['stock_transfer_date'] = date('Y-m-d');
    $floc = $data['from_location_id'] = $this->input->post('from_location_id');
    $tloc = $data['to_location_id'] = $this->input->post('to_location_id');
    $typ = $data['type'] = $this->input->post('type');    
    if($typ=='product')
    {
      $data['rawmaterial_id'] = 0;
      $prodId = $data['product_id'] = $this->input->post('product_id');
    }
    else
    {
      $rmId = $data['rawmaterial_id'] = $this->input->post('rawmaterial_id');
      $data['product_id'] = 0;
    }
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];

$result = $this->Stocktransfer_model->create_stocktransfer($data);
    if ($result) {
      $last_id_value = $this->Stocktransfer_model->last_id();
      $last_value=$last_id_value->stock_transfer_id;
      if($typ=='product')
      {
        $data1['stock_transfer_id'] = $last_value;
        $data1['rawmaterial_stock_id'] = 0;
        $psid = $data1['product_stock_id'] = $this->input->post('product_stock_id');
        $tstk = $data1['transfer_stock'] = $this->input->post('tstock');
        $this->Stocktransfer_model->create_stocktransfer_product($data1);

$product = $this->Stocktransfer_model->get_product_stock_by_product_stock_id($psid);
        $pstk = $product->stock;
        $remstk = $pstk - $tstk;
        $this->Stocktransfer_model->update_product_stock_by_product_stock_id($psid,$remstk);

$productcheck = $this->Stocktransfer_model->get_product_stock_by_location_id($prodId,$tloc);
        if(count($productcheck)>0)
        {
          $pstk = $productcheck->stock;
          $adstk = $pstk + $tstk;
          $psid = $productcheck->product_stock_id;
          $this->Stocktransfer_model->update_product_stock_by_product_stock_id($psid,$adstk);
        }
        else
        {
          $data2['location_id'] = $tloc;
          $data2['product_id'] = $pid;
          $data2['stock'] = $tstk;
          $data2['created_on'] = date('Y-m-d H:i:s');
          $data2['created_by'] = $_SESSION['user_id'];
          $this->Purchase_model->add_product_stock_by_location_id($data2);
        }
      }
      else
      {
        if($this->input->post('rawmaterial_stock_id')!='')
        {
          $rmsid = explode(",",implode(",",$this->input->post('rawmaterial_stock_id')));
          $tstk = explode(",",implode(",",$this->input->post('tansfer_stock')));
          $subcount = count($this->input->post('rawmaterial_stock_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($rmsid[$i] != 0){
              $rmstk['stock_transfer_id'] = $last_value;
              $rmsidval = $rmstk['rawmaterial_stock_id'] = $rmsid[$i];
              $rmstk['product_stock_id'] = 0;
              $tstkval = $rmstk['transfer_stock'] = $tstk[$i];
              $this->Stocktransfer_model->create_stocktransfer_product($rmstk);

$product = $this->Stocktransfer_model->get_rawmaterial_stock_by_id($rmsidval);
              $pstk = $product->stock;
              $remstk = $pstk - $tstkval;
              $this->Stocktransfer_model->update_rawmaterial_stock_by_id($remstk,$rmsidval);

/*$productcheck = $this->Stocktransfer_model->get_rawmaterial_stock_by_location_rawmaterial_id($tloc,$rmId);
              if(count($productcheck)>0)
              {
                $pstk = $productcheck->stock;
                $adstk = $pstk + $tstkval;
                $psid = $productcheck->rawmaterial_stock_id;
                $this->Stocktransfer_model->update_rawmaterial_stock_by_id($adstk,$psid);
              }
              else
              {*/
                $data3['location_id']=$tloc;
                $data3['rm_date'] = date('Y-m-d'); 
                $data3['rawmaterial_id'] = $rmId;
                $last_id_value = $this->Rawmaterialstock_model->last_id();
                if(count($last_id_value)==0)
                {
                  $mno = $data3['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 = $data3['m_no'] = date("Y").'/'.date('m').'/RMNO'.$nval;
                }
                $data3['stock'] = $tstkval;
                $nwgt = $data3['net_weight'] = $tstkval;
                $data3['created_on'] = date('Y-m-d H:i:s');
                $data3['created_by'] = $_SESSION['user_id'];

$this->Purchase_model->create_rawmaterial_stock($data3);

$rmnorep = str_replace('/', '-', $mno);
                $rmnorep = $rmnorep.'-'.$nwgt;
                $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");
              //}
            }
          }
        }
      }
    
      $this->session->set_flashdata('add_success', 'Stock Transfer has been added successfully.');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Something Went Wrong.');
    }
    redirect('/stocktransfer');
  }

public function stocktransfer_view($id)
  {
    $pod = $data['stocktransfer_details'] = $this->Stocktransfer_model->get_stocktransfer_by_id($id);
    /*if($pod->type=='raw material')
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_id($id);
    else
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_product_id($id);*/
      $data['stocktransfer_products'] = $this->Stocktransfer_model->get_stocktransfer_product_by_id($id);
    $this->load->view('stocktransfer/stocktransfer_view',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Stocktransfer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation