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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

/* ************************************************************************************
		Purpose : To handle all dashboard functions
		Date    : 23-10-2018 
***************************************************************************************/
class Dashboard extends CI_Controller {

public function __construct()
	{
		parent::__construct();
    	$this->load->model(array('Dashboard_model'));
    	$this->load->model(array('Purchasereport_model'));
    	$this->load->model(array('Invoice_model'));
    	$this->load->model(array('Order_model'));
    	$this->load->model(array('Balancesheet_model'));
    	$this->load->model(array('Productionreport_model'));
    	$this->load->model(array('Accountreceipt_model'));
		
		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', 'Dashboard');
	}
	
	/* ************************************************************************************
						Purpose : To handle dashboard Functions
	        **********************************************************************/
	public function index()
	{
		$this->load->view('dashboard_view');
	}

public function getDayBook()
	{
		$data['ldate'] = $dt = $_POST['dt'];
		$dbdt = explode('/', $dt);
      	$data['cdate'] = $cdate = $dbdt[2].'-'.$dbdt[0].'-'.$dbdt[1];
	    //Day Book Start
	    $data['daybook_list'] = $this->db->query("(SELECT aa.account_attributes as particulars,'' as user_id,'' as user_type,'' as expense_type,'Journal' as vchtype,aj.account_journal_id as vchno,'Debit' as ptype,aj.amount,aj.created_on FROM account_journal aj,account_attributes aa WHERE aj.account_attributes_id = aa.account_attributes_id AND STR_TO_DATE(aj.created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d'))UNION(SELECT particulars,user_id,'' as user_type,expense_type,'Payment' as vchtype,account_payment_id as vchno,'Debit' as ptype,amount,created_on FROM account_payment WHERE STR_TO_DATE(created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d'))UNION(SELECT particulars,user_id,user_type,expense_type,'Receipt' as vchtype,account_receipt_id as vchno,'Credit' as ptype,amount,created_on FROM account_receipt WHERE STR_TO_DATE(created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d'))UNION(SELECT v.vendor_name as particulars,e.vendor_id as user_id,'' as user_type,'' as expense_type,'Expense' as vchtype,e.expense_no as vchno,'Debit' as ptype,e.total_amount as amount,e.created_on FROM expense e,vendor v WHERE v.vendor_id = e.vendor_id AND STR_TO_DATE(e.created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d'))UNION(SELECT c.customer_name as particulars,o.customer_id as user_id,'' as user_type,'' as expense_type,'Sales' as vchtype,o.order_no as vchno,'Credit' as ptype,o.grand_total as amount,o.created_on FROM `order` o,customer c WHERE o.customer_id = c.customer_id AND STR_TO_DATE(o.created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d'))UNION(SELECT v.vendor_name as particulars,p.vendor_id as user_id,'' as user_type,'' as expense_type,'Purchase' as vchtype,p.purchase_no as vchno,'Debit' as ptype,p.total_amount as amount,p.created_on FROM purchase p,vendor v WHERE p.vendor_id = v.vendor_id AND STR_TO_DATE(p.created_on, '%Y-%m-%d') = STR_TO_DATE('$cdate', '%Y-%m-%d')) ORDER BY created_on ASC")->result_array();
	    $this->load->view('ai/day_book',$data);
	}

public function delay_so_list()
	{
		$soid = $_POST['soid'];
		/*$data['delay_so_list'] = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id AND o.order_id IN ($soid) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();*/
		$data['delay_so_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_id IN ($soid) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
		$this->load->view('ai/delay_so_list',$data); 
	}

public function exceded_so_list()
	{
		$data['delay_so_list'] = $this->Dashboard_model->get_exceded_so_list();
		$this->load->view('ai/exceded_so_list',$data); 
	}

public function exceded_wastage_list()
	{
		$wid = $_POST['wid'];
		$val = $_POST['val'];
		$data['exceded_wastage_list'] = $this->db->query("SELECT r.*,ru.rawmaterial_uom FROM `rawmaterial` r,rawmaterial_uom ru WHERE r.rawmaterial_uom_id = ru.rawmaterial_uom_id AND r.rawmaterial_id IN ($wid)")->result_array();
		$data['val'] = $val;
		$this->load->view('ai/exceded_wastage_list',$data); 
	}

public function getYearMonth()
  {
    $year = $_POST['year'];
    //$query2 = $this->db->query("SELECT MONTH(STR_TO_DATE(billDate, '%m/%d/%Y')) as month, MONTHNAME(STR_TO_DATE(billDate, '%m/%d/%Y')) as name FROM `biller` where YEAR(STR_TO_DATE(billDate, '%m/%d/%Y')) = ".$year." group by MONTH(STR_TO_DATE(billDate, '%m/%d/%Y'))");

$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 getSalesByMonthAndYear()
  {
    $year = $_POST['year'];
    $month = $_POST['month'];
    if($year=='')
      $year=date("Y");
    if($month=='')
      $month = date("m");

$result = $this->Dashboard_model->get_dynamic_month_sales_chart($month,$year);
  	echo json_encode($result);
  }

public function getRevenueByYear()
  {
    $year = $_POST['year'];
    $result = $this->Dashboard_model->get_dynamic_year_revenue_chart($year);
  	echo json_encode($result);
  }

public function sideindex()
	{
		
		$this->load->view('sidedashboard'); 
	}
	
}
/********************** END: Dashboard Controller   **************************************/
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Dashboard_2021_11_16.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation