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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Gstrworkings extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->model(array('Gstrworkings_model'));
    $this->load->model(array('Dashboard_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', 'Report');
  }

public function index()
  {
    $data['location_list'] = $this->Gstrworkings_model->get_location_list();
    $sdate = $this->Dashboard_model->get_start_date();
    $diff = date('Y') - $sdate->year;
    $opt = "";
    for($i=$diff;$i>=0;$i--)
    {
      $y = date('Y') - $i;
      if($y==date('Y'))
        $opt.="<option value=".$y." selected>".$y."</option>";
      else
        $opt.="<option value=".$y.">".$y."</option>";
    }
    $data['yearList'] = $opt;

if($sdate->year == date('Y'))
    {
      $syearmonth = $this->Dashboard_model->get_start_year_months($sdate->month);
    }
    else
    {
      $syearmonth = $this->Dashboard_model->get_other_year_months();
    }
    $data['monthList'] = $syearmonth;

$this->load->view('gstrworkings/gstr_workings',$data);
  }

public function getYearMonth()
  {
    $year = $_POST['year'];

$sdate = $this->Dashboard_model->get_start_date();

if($sdate->year == $year)
    {
      $syearmonth = $this->Dashboard_model->get_start_year_change_months($sdate->month);
    }
    else if($year<date('Y'))
    {
      $syearmonth = $this->Dashboard_model->get_other_year_change_months();
    }
    else
    {
      $syearmonth = $this->Dashboard_model->get_other_year_months();
    }

$monthList = $syearmonth;
    $option ="<option value=''>Select Month</option>";
    foreach($monthList as $schart)
    {
      $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
    }
    echo $option;
  }

public function working_report()
  {
    $data['syear'] = $syear = $_POST['syear'];
    $data['smonth'] = $smonth = $_POST['smonth'];
    $compid = $_POST['compid'];

if($smonth!=1)
    {
      $pmonth = $smonth-1;
      $pyear = $syear;
    }
    else
    {
      $pmonth = 12;
      $pyear = $syear-1;
    }
    $data['pmonth_tax'] = $this->Gstrworkings_model->get_gst_tax_by_year_month_location($pyear,$pmonth,$compid);

$data['location_list'] = $this->Gstrworkings_model->get_location_by_id($compid);

/*$data['tn_sales'] = $this->db->query("SELECT state_id,invoice_id,product_gst,sum(amt) as tamt,sum(pcharge) as tpcharge,sum(ocharge) as tocharge FROM ((SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt,sum(i.packing_charges) as pcharge, sum(i.other_charges) as ocharge FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst) UNION (SELECT c.state_id,i.invoice_id,ip.product_gst,sum(i.taxable_amount) as amt,sum(i.packing_charges) as pcharge, sum(i.other_charges) as ocharge FROM `invoice_product` ip,invoice i,customer c WHERE ip.invoice_id = i.invoice_id AND i.customer_id = c.customer_id AND c.state_id=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst)) t GROUP BY product_gst")->result_array();*/

$data['tn_sales'] = $this->db->query("SELECT product_gst,sum(amt) as tamt,sum(packing_charges) as tpcharge, sum(other_charges) as tocharge FROM ((SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) UNION (SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice` i,invoice_product ip,customer c WHERE i.invoice_id = ip.invoice_id AND i.customer_id = c.customer_id AND c.state_id=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) ORDER BY product_gst ASC) t GROUP BY product_gst")->result_array();

$data['os_sales'] = $this->db->query("SELECT product_gst,sum(amt) as tamt,sum(packing_charges) as tpcharge, sum(other_charges) as tocharge FROM ((SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id!=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) UNION (SELECT ip.product_gst,sum(ip.amount) as amt,i.* FROM `invoice` i,invoice_product ip,customer c WHERE i.invoice_id = ip.invoice_id AND i.customer_id = c.customer_id AND c.state_id!=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst, i.invoice_id) ORDER BY product_gst ASC) t GROUP BY product_gst")->result_array();

/*$data['os_sales'] = $this->db->query("SELECT state_id,invoice_id,product_gst,sum(amt) as tamt,sum(pcharge) as tpcharge,sum(ocharge) as tocharge FROM ((SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt,sum(i.packing_charges) as pcharge, sum(i.other_charges) as ocharge FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id!=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst) UNION (SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt,sum(i.packing_charges) as pcharge, sum(i.other_charges) as ocharge FROM `invoice_product` ip,invoice i,customer c WHERE ip.invoice_id = i.invoice_id AND i.customer_id = c.customer_id AND c.state_id!=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst)) t GROUP BY product_gst")->result_array();*/

/*$data['tn_sales'] = $this->db->query("SELECT state_id,invoice_id,product_gst,sum(amt) as tamt FROM ((SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst) UNION (SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt FROM `invoice_product` ip,invoice i,customer c WHERE ip.invoice_id = i.invoice_id AND i.customer_id = c.customer_id AND c.state_id=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst)) t GROUP BY product_gst")->result_array();

$data['os_sales'] = $this->db->query("SELECT state_id,invoice_id,product_gst,sum(amt) as tamt FROM ((SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt FROM `invoice_product` ip,invoice i,`order` o,customer c WHERE ip.invoice_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND c.state_id!=33 AND o.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst) UNION (SELECT c.state_id,i.invoice_id,ip.product_gst,sum(ip.amount) as amt FROM `invoice_product` ip,invoice i,customer c WHERE ip.invoice_id = i.invoice_id AND i.customer_id = c.customer_id AND c.state_id!=33 AND i.location_id='$compid' AND YEAR(i.invoice_date)='$syear' AND MONTH(i.invoice_date)='$smonth' GROUP BY ip.product_gst)) t GROUP BY product_gst")->result_array();*/

$data['expense_list'] = $this->db->query("SELECT sum(taxable_value) as tblvalue,sum(igst) as tigst,sum(cgst) as tcgst,sum(sgst) as tsgst FROM expense WHERE location_id='$compid' AND YEAR(expense_date)='$syear' AND MONTH(expense_date)='$smonth' AND tax_rate!=0 AND status!=2")->row();

$data['tn_purchase_list'] = $this->db->query("SELECT sum(p.taxable_amount) as tblamt,sum(p.tax_amount) as txamt FROM `purchase` p,purchase_order po,vendor v WHERE p.purchase_order_id = po.purchase_order_id AND po.vendor_id = v.vendor_id AND v.state_id=33 AND YEAR(p.purchase_date)='$syear' AND MONTH(p.purchase_date)='$smonth' AND po.location_id='$compid'")->row();

$data['os_purchase_list'] = $this->db->query("SELECT sum(p.taxable_amount) as tblamt,sum(p.tax_amount) as txamt FROM `purchase` p,purchase_order po,vendor v WHERE p.purchase_order_id = po.purchase_order_id AND po.vendor_id = v.vendor_id AND v.state_id!=33 AND YEAR(p.purchase_date)='$syear' AND MONTH(p.purchase_date)='$smonth' AND po.location_id='$compid'")->row();

$this->load->view('gstrworkings/working_report',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Gstrworkings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation