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_15_11_2021.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()
	{
		$today = date('Y-m-d');
		$data['location'] = $this->Order_model->get_location();

$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;

$data['salesChart'] = $this->Dashboard_model->get_current_month_sales_chart();

/*if($_SERVER['REQUEST_METHOD'] == 'POST')
    	{}
    	else
    	{*/
    		$dbdate = date('m/d/Y').' - '.date('m/d/Y');
    		$this->session->set_userdata('dbdate', $dbdate);

//$curdate = date('Y-m-d');
		      $data['dtrange'] = '';
		      $data['drnge'] = '';
		      $data['purchasesearch'] = 'curdate';

$data['company_id'] = '';
			$data['accounts_purchase_today'] = $this->Dashboard_model->get_purchase_amount_by_date($today);		
			$data['accounts_sales_today'] = $this->Dashboard_model->get_invoice_amount_by_date($today);

$data['accounts_purchase_list'] = $this->Purchasereport_model->get_basic_purchase_list($today,$today);
	        $data['accounts_purchase_product_list'] = $this->Purchasereport_model->get_basic_purhcase_product_list($today,$today);
	        $data['today_invoice_list'] = $this->Dashboard_model->get_invoice_list_by_date($today);

$data['others_lead_today'] = $this->Dashboard_model->lead_yesterday_count($today);
	        $data['other_sales_today'] = $this->Dashboard_model->get_order_amount_by_date($today);
	        $data['other_dinvoice_today'] = $this->Dashboard_model->get_direct_invoice_amount_by_date($today);
	        $data['other_prod_today'] = $this->Dashboard_model->get_other_production_value($today);
	        //$data['other_cash_today'] = $this->Dashboard_model->get_account_receipt_sale_amount_by_date($today);
	        $data['other_cash_today'] = $this->Dashboard_model->get_other_cash_value_amount_by_date($today);

$data['today_lead_list'] = $this->Dashboard_model->get_lead_list_by_date($today);
	        $data['today_so_list'] = $this->Dashboard_model->get_order_list_by_date($today);
	        $data['today_dinvoice_list'] = $this->Dashboard_model->get_direct_invoice_list_by_date($today);
	        $data['today_production_list'] = $this->Productionreport_model->get_basic_production_register_list($today,$today);
	        //$data['today_cash_value_list'] = $this->Dashboard_model->get_account_receipt_sale_by_date($today);
	        $data['today_cash_value_list'] = $this->Dashboard_model->get_other_cash_value_by_date($today);

/*for($i=6;$i<=7;$i++)
	 {
	 	$ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
	 	$ledgerAssAmt = 0;
				$lopt = '';
				foreach($ledger_list as $u_list)
				{
					$accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accrecList)>0)
					{
						$accrec = $accrecList->accrec;
					}
					else
					{
						$accrec = 0;
					}

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accorecList)>0)
					{
						$accorec = $accorecList->accrec;
					}
					else
					{
						$accorec = 0;
					}

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accpayList)>0)
					{
						$accpay = $accpayList->accpay;
					}
					else
					{
						$accpay = 0;
					}

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accopayList)>0)
					{
						$accopay = $accopayList->accpay;
					}
					else
					{
						$accopay = 0;
					}

$acccntsum = $this->Balancesheet_model->get_account_contra_amt_by_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($acccntsum)>0)
					{
						$acccontsum = $acccntsum->depamt;
					}
					else
					{
						$acccontsum = 0;
					}

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($acccntdiff)>0)
					{
						$acccontdiff = $acccntdiff->debamt;
					}
					else
					{
						$acccontdiff = 0;
					}

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($voucherdiff)>0)
					{
						$vdiff = $voucherdiff->voucherpay;
					}
					else
					{
						$vdiff = 0;
					}

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accjournsum)>0)
					{
						$accjournalsum = $accjournsum->creditamt;
					}
					else
					{
						$accjournalsum = 0;
					}

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_date($u_list['ledger_list_id'],$today);
					if(count($accjourndiff)>0)
					{
						$accjournaldiff = $accjourndiff->debitamt;
					}
					else
					{
						$accjournaldiff = 0;
					}

//$lamt = ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
					$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
					$lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view_list/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
					//$ledgerAssAmt+= ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
					$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
				}
				//$lopt.="</table>";
				$lval = "".number_format($ledgerAssAmt,2)."";

if($i==6)
				{
					$data['accounts_cash_today'] = $ledgerAssAmt;
					$data['today_cash_list'] = $lopt;
				}
				else
				{
					$data['accounts_bank_today'] = $ledgerAssAmt;
					$data['today_bank_list'] = $lopt;
				}
	        }*/

/*//Lead
	    $data['overall_count'] = count($this->Dashboard_model->get_lead_list());    
	    $yesterday = date('Y-m-d', strtotime("-1 days"));
	    $today = date('Y-m-d');
	    $datestring=date('Y-m-d', strtotime('first day of last month'));
		$dt=date_create($datestring);
		$lastmonth = $dt->format('Y-m');
		$thismonth = date('Y-m');
	    $data['today_leads'] = $this->Dashboard_model->lead_yesterday_count($today);
	    $data['yesterday_leads'] = $this->Dashboard_model->lead_yesterday_count($yesterday);
	    $data['lastmonth_leads'] = $this->Dashboard_model->lead_lastmonth_count($lastmonth);
	    $data['thismonth_leads'] = $this->Dashboard_model->lead_thismonth_count($thismonth);
	    $data['converted_lead'] = $this->Dashboard_model->converted_lead_list();
	    $data['cancel_lead'] = $this->Dashboard_model->cancel_lead_list();
	    $data['open_lead'] = $this->Dashboard_model->open_lead_list();

//Customer    
	    $data['customer_overall_count'] = count($this->Dashboard_model->get_customer_list());
	    $data['today_customer'] = $this->Dashboard_model->customer_yesterday_count($today);
	    $data['yesterday_customer'] = $this->Dashboard_model->customer_yesterday_count($yesterday);
	    $data['lastmonth_customer'] = $this->Dashboard_model->customer_lastmonth_count($lastmonth);
	    $data['thismonth_customer'] = $this->Dashboard_model->customer_thismonth_count($thismonth);

//Pending Status
	    $data['pending_order_list'] = $this->Dashboard_model->get_pending_order_list();
    	$data['order_list'] = $this->Workorder_model->get_open_order_list();
    	$data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
    	$data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
    	$data['dc_order_list'] = $this->Deliverychallan_model->get_wl_order_list();
    	$data['inv_order_list'] = $this->Invoice_model->get_dc_order_list();

//Recent List
    	$data['recent_order_list'] = $this->Dashboard_model->get_recent_order_list();
    	$data['location_list'] = $this->Rawmaterialstock_model->get_location();

$data['salesChart'] = $this->Dashboard_model->get_current_month_sales_chart();

$data['revenueChart'] = $this->Dashboard_model->get_current_year_revenue_chart();

$data['exceded_so_list'] = $this->Dashboard_model->get_exceded_so_list();

//AI
	    //Process Delay Start
	    $socount=0;
	    $soid='';
	    $solist = $this->Dashboard_model->get_pending_so_list();
	    foreach($solist as $slist)
	    {
	    	if($slist['status']==0)
	    	{
	    		$progpercent = 0;
	    	}
	    	if($slist['status']==1)
	    	{
	    		$progpercent = 20;
	    	}
	    	if($slist['status']==2)
	    	{
	    		$progpercent = 40;
	    	}
	    	if($slist['status']==3)
	    	{
	    		$progpercent = 60;
	    	}
	    	if($slist['status']==4)
	    	{
	    		$progpercent = 80;
	    	}
	    	$ddate = explode(' ', $slist['del_date']);
	    	$earlier = new DateTime($slist['order_date']);
			$later = new DateTime($ddate[0]);

$diff = $later->diff($earlier)->format("%a")+1;

$cday = new DateTime(date('Y-m-d'));
			$ddiff = $later->diff($cday)->format("%a")+1;

$dpercent = number_format((100/$diff),2);

$compdays = $diff-$ddiff;

$compdayspercent = $dpercent*$compdays;

if($progpercent<$compdayspercent)
			{
				$socount++;
				if($soid=='')
					$soid = $slist['order_id'];
				else
					$soid.=','.$slist['order_id'];
			}
	 }
	 $data['socount'] = $socount;
	 $data['soid'] = $soid;
	 //Process Delay End

//Wastage Start
	    $wastageList = $this->Dashboard_model->get_wastage_by_date($today);
	    $wcount=0;
	    $wid='';
	    $wdif='';
	    if(count($wastageList)>0)
	    {
	    	//echo "TRUE";
	    	$wasteProd = $this->Dashboard_model->get_wastage_product_by_id($wastageList->wastage_id);
	    	$issueprodgroup = $this->Dashboard_model->get_sum_issue_prod_weight($today);
	    	foreach($wasteProd as $wprod)
	    	{
	    		foreach($issueprodgroup as $issueprod)
	    		{
	    			if($wprod['rawmaterial_id'] == $issueprod['rawmaterial_id'])
	    			{
	    				$rmlist = $this->Dashboard_model->get_rawmaterial_by_id($wprod['rawmaterial_id']);
	    				$wlim = $rmlist->wastage_limit;
	    				$pkg = $rmlist->per_kg;
	    				if($pkg>0)
	    				{
	    					$pkgwaste = number_format(($wlim/$pkg),2);
	    					$maxissuewaste = number_format(($issueprod['issqty']*$pkgwaste),2);
	    					if($wprod['wastage_quantity']>$maxissuewaste)
	    					{
	    						$wastdiff = number_format(($wprod['wastage_quantity']-$maxissuewaste),2);
	    						$wcount++;
								if($wid=='')
									$wid = $wprod['rawmaterial_id'];
								else
									$wid.=','.$wprod['rawmaterial_id'];

if($wdif=='')
									$wdif = $wastdiff;
								else
									$wdif.=','.$wastdiff;
	 					}
	 				}
	 			}
	 		}
	 	}
	 	if($wcount>0)
	 	{
	 		$wrmid = explode(',', $wid);
	 		$wdid = explode(',', $wdif);
	 		$arr = [];
				foreach($wrmid as $k=>$v)
				{
				 array_push($arr, $wdid[$k]);
				}
				$wid = implode(',',$wrmid);
				$wdif = implode(',',$arr);
	 	}
	 }
	 //echo $pkgwaste." ".$maxissuewaste." ".$wcount." ".$wid;exit;
	 $data['wcount'] = $wcount;
	 $data['wid'] = $wid;
	 $data['wdif'] = $wdif;
	 //Wastage End
	 $data['cdate'] = $cdate = date('Y-m-d');
	 $data['ldate'] = date('m/d/Y');
	 //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();*/
	 //Day Book End
		
		$this->load->view('dashboard',$data); 
	}

public function custom_search()
	{
		$data['location'] = $this->Order_model->get_location();
		$this->load->view('dashboard_custom_search',$data);
	}

public function custom_filter_ajax()
	{

$company_id = $_POST['filterloc'];
		$type = $_POST['dashboard_type'];
		if($type == 'accounts')
		{
			$module = $_POST['filter_account_module'];
		}
		else
		{
			$module = $_POST['filter_other_module'];
		}
		$dfilter = $_POST['searchChange'];

if($dfilter=='curdate')
		{
			$fdate = date('Y-m-d');
			$tdate = date('Y-m-d');
			$dbdate = date('m/d/Y').' - '.date('m/d/Y');
		}
		elseif($dfilter=='date')
		{
			if($this->input->post('dtrange')!='')
			{
			  $odt = explode('/', $this->input->post('dtrange'));
			  $fdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
			  $tdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
			  $dbdate = $this->input->post('dtrange').' - '.$this->input->post('dtrange');
			}
			else
			{
			  $fdate = date('Y-m-d');
			  $tdate = date('Y-m-d');
			  $dbdate = date('m/d/Y').' - '.date('m/d/Y');
			}
		}
		else
		{
			$dtrange = $this->input->post('dtrangepicker');
			$dr = explode(' - ', $dtrange);

$fd = explode('/', $dr[0]);
			$td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
			$tdate = $td[2].'-'.$td[0].'-'.$td[1];
			$dbdate = $dtrange;
		}

if($type=='accounts')
		{
			if($module == 'purchase')
			{
				$data['accounts_purchase_today'] = $this->Dashboard_model->get_purchase_amount_by_daterange_comp_id($fdate,$tdate,$company_id);
				$data['accounts_purchase_list'] = $this->Purchasereport_model->get_basic_purchase_list($fdate,$tdate);
			 $data['accounts_purchase_product_list'] = $this->Dashboard_model->get_basic_purhcase_product_list_by_date_comp_id($fdate,$tdate,$company_id);
			}
			if($module == 'sales')
			{
				$data['accounts_sales_today'] = $this->Dashboard_model->get_invoice_amount_by_daterange_comp_id($fdate,$tdate,$company_id);
				$data['today_invoice_list'] = $this->Dashboard_model->get_invoice_list_by_daterange_comp_id($fdate,$tdate,$company_id);
			}
			else
			{
				for($i=6;$i<=7;$i++)
		 {
		 	$ledger_list = $this->Balancesheet_model->get_ledger_list_by_account_attributes_id($i);
		 	$ledgerAssAmt = 0;
					$lopt = '';
					foreach($ledger_list as $u_list)
					{
						$accrecList = $this->Balancesheet_model->get_account_receipt_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accrecList)>0)
						{
							$accrec = $accrecList->accrec;
						}
						else
						{
							$accrec = 0;
						}

$accorecList = $this->Balancesheet_model->get_account_receipt_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accorecList)>0)
						{
							$accorec = $accorecList->accrec;
						}
						else
						{
							$accorec = 0;
						}

$accpayList = $this->Balancesheet_model->get_account_payment_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accpayList)>0)
						{
							$accpay = $accpayList->accpay;
						}
						else
						{
							$accpay = 0;
						}

$accopayList = $this->Balancesheet_model->get_account_payment_oamt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accopayList)>0)
						{
							$accopay = $accopayList->accpay;
						}
						else
						{
							$accopay = 0;
						}

$acccntsum = $this->Balancesheet_model->get_acc_contra_amt_by_from_credit_ledger_list_id_drange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($acccntsum)>0)
						{
							$acccontsum = $acccntsum->depamt;
						}
						else
						{
							$acccontsum = 0;
						}

$acccntdiff = $this->Balancesheet_model->get_account_contra_amt_by_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($acccntdiff)>0)
						{
							$acccontdiff = $acccntdiff->debamt;
						}
						else
						{
							$acccontdiff = 0;
						}

$voucherdiff = $this->Balancesheet_model->get_voucher_amt_by_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($voucherdiff)>0)
						{
							$vdiff = $voucherdiff->voucherpay;
						}
						else
						{
							$vdiff = 0;
						}

$accjournsum = $this->Balancesheet_model->get_account_journal_from_credit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accjournsum)>0)
						{
							$accjournalsum = $accjournsum->creditamt;
						}
						else
						{
							$accjournalsum = 0;
						}

$accjourndiff = $this->Balancesheet_model->get_account_journal_from_debit_ledger_list_id_daterange_cid($u_list['ledger_list_id'],$fdate,$tdate,$company_id);
						if(count($accjourndiff)>0)
						{
							$accjournaldiff = $accjourndiff->debitamt;
						}
						else
						{
							$accjournaldiff = 0;
						}

//$lamt = ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
						$lamt = ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
						$lopt.="<tr><td>".$u_list['location_name']."</td><td>".$u_list['ledger_list']."</td><td><a href=".base_url()."ledger/ledger_details_view_list/".$u_list['ledger_list_id']." target='_blank'>".number_format($lamt,2)."</a></td></tr>";
						//$ledgerAssAmt+= ($u_list['opening_balance']+$accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
						$ledgerAssAmt+= ($accrec+$acccontsum+$accjournalsum+$accopay) - $accpay - $acccontdiff - $vdiff - $accjournaldiff-$accorec;
					}
					//$lopt.="</table>";
					$lval = "".number_format($ledgerAssAmt,2)."";

if($i==6)
					{
						$data['accounts_cash_today'] = $ledgerAssAmt;
						$data['today_cash_list'] = $lopt;
					}
					else
					{
						$data['accounts_bank_today'] = $ledgerAssAmt;
						$data['today_bank_list'] = $lopt;
					}
		        }
			}
		}

else
		{
			if($module == 'lead')
			{
				$data['others_lead_today'] = $this->Dashboard_model->lead_daterange_count($fdate,$tdate);
				$data['today_lead_list'] = $this->Dashboard_model->get_lead_list_by_daterange($fdate,$tdate);
			}
			if($module == 'sales')
			{
				$data['other_sales_today'] = $this->Dashboard_model->get_order_amount_by_daterange_comp_id($fdate,$tdate,$company_id);
			    $data['other_dinvoice_today'] = $this->Dashboard_model->get_direct_invoice_amount_by_daterange_loc_id($fdate,$tdate,$company_id);

$data['today_so_list'] = $this->Dashboard_model->get_order_list_by_daterange_comp_id($fdate,$tdate,$company_id);
			    $data['today_dinvoice_list'] = $this->Dashboard_model->get_direct_invoice_list_by_daterange_comp_id($fdate,$tdate,$company_id);
			}
			if($module == 'production')
			{
				$data['other_prod_today'] = $this->Dashboard_model->get_other_production_value_by_daterange_comp_id($fdate,$tdate,$company_id);
				$data['today_production_list'] = $this->Dashboard_model->get_basic_production_register_list_by_date_comp_id($fdate,$tdate,$company_id);
			}
			else
			{
				$data['other_cash_today'] = $this->Dashboard_model->get_other_cash_value_amount_by_daterange_comp_id($fdate,$tdate,$company_id);
				$data['today_cash_value_list'] = $this->Dashboard_model->get_other_cash_value_by_daterange_comp_id($fdate,$tdate,$company_id);
			}
		}

$data['type'] = $type;
		$data['module'] = $module;
		$data['dbdate'] = $dbdate;

$location_details = $this->Invoice_model->get_location_by_id($company_id);
		$data['location_name'] = $location_details->location_name;
//echo "<pre>";print_r($data);exit;
		$this->load->view('dashboard_ajax',$data);

//print_r($_POST);exit;

}

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_15_11_2021.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation