����JFIF��� ( %"1"%)+...383,7(-.- 404 Not Found
Sh3ll
OdayForums


Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20
System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64
User : apache ( 48)
PHP Version : 7.4.20
Disable Function : NONE
Directory :  /var/www/html/adimi/application/modules/dashboard/libraries/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //var/www/html/adimi/application/modules/dashboard/libraries/Lreport.php
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Lreport
{
    // Retrieve All Stock Report
    public function stock_report($limit, $page, $links)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');
        $stok_report = $CI->Reports->stock_report($limit, $page);

        if (!empty($stok_report)) {
            $i = $page;
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['sl'] = $i;
            }
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['stok_quantity'] = $stok_report[$k]['totalBuyQnty'] - $stok_report[$k]['totalSalesQnty'];
                $stok_report[$k]['totalSalesCtn'] = $stok_report[$k]['totalSalesQnty'] / $stok_report[$k]['cartoon_quantity'];
                $stok_report[$k]['totalPrhcsCtn'] = $stok_report[$k]['totalBuyQnty'] / $stok_report[$k]['cartoon_quantity'];

                $stok_report[$k]['stok_quantity_cartoon'] = $stok_report[$k]['stok_quantity'] / $stok_report[$k]['cartoon_quantity'];

            }
        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('stock_report'),
            'stok_report' => $stok_report,
            'links' => $links,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],

        );
        $reportList = $CI->parser->parse('dashboard/report/stock_report', $data, true);
        return $reportList;
    }

    //Out of stock
    public function out_of_stock()
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');

        $out_of_stock = $CI->Reports->out_of_stock();

        if (!empty($out_of_stock)) {
            $i = 0;
            foreach ($out_of_stock as $k => $v) {
                $i++;
                $out_of_stock[$k]['sl'] = $i;
            }
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('out_of_stock'),
            'out_of_stock' => $out_of_stock,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );

        $reportList = $CI->parser->parse('dashboard/report/out_of_stock', $data, true);
        return $reportList;
    }

    // Retrieve Single Item Stock Stock Report
    public function stock_report_single_item($product_id, $date, $limit, $page, $link)
    {

        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->library('dashboard/occational');
        $stok_report = $CI->Reports->stock_report_bydate($product_id, $date, $limit, $page);
        if (($stok_report)) {
            $i = $page;
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['sl'] = $i;
            }
            foreach ($stok_report as $k => $v) {

                $sales = $CI->db->select("
					sum(quantity) as totalSalesQnty,
					quantity
					")
                    ->from('invoice_details')
                    ->where('product_id', $v['product_id'])
                    ->get()
                    ->row();
                $stok_report[$k]['stok_quantity_cartoon'] = ($stok_report[$k]['totalPurchaseQnty'] - $sales->totalSalesQnty);
                $stok_report[$k]['totalSalesCtn'] = $sales->totalSalesQnty;
                $stok_report[$k]['totalPrhcsCtn'] = $stok_report[$k]['totalPurchaseQnty'];
            }
        } else {
            $CI->session->set_userdata('error_message', display('stock_not_available'));
            redirect('dashboard/Creport');
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();

        $data = array(
            'title' => display('stock_report'),
            'stok_report' => $stok_report,
            'link' => $link,
            'date' => $date,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );

        $reportList = $CI->parser->parse('dashboard/report/stock_report', $data, true);
        return $reportList;
    }

    // Stock report supplier wise
    public function stock_report_supplier_wise($product_id, $supplier_id, $date, $links, $per_page, $page)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Suppliers');
        $CI->load->library('dashboard/occational');
        $stok_report = $CI->Reports->stock_report_supplier_bydate($product_id, $supplier_id, $date, $per_page, $page);
        $supplier_list = $CI->Suppliers->supplier_list_report();
        $supplier_info = $CI->Suppliers->retrieve_supplier_editdata($supplier_id);

        $sub_total_in = 0;
        $sub_total_out = 0;
        $sub_total_stock = 0;

        if (($stok_report)) {
            $i = $page;
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['sl'] = $i;
            }
            foreach ($stok_report as $k => $v) {
                $i++;

                $sales = $CI->db->select("
					sum(quantity) as totalSalesQnty,
					quantity
					")
                    ->from('invoice_details')
                    ->where('product_id', $v['product_id'])
                    ->get()
                    ->row();

                $stok_report[$k]['stok_quantity'] = ($stok_report[$k]['totalPrhcsCtn'] - $sales->totalSalesQnty);
                $stok_report[$k]['SubTotalOut'] = ($sub_total_out + $sales->totalSalesQnty);
                $sub_total_out = $stok_report[$k]['SubTotalOut'];
                $stok_report[$k]['SubTotalIn'] = ($sub_total_in + $stok_report[$k]['totalPrhcsCtn']);
                $sub_total_in = $stok_report[$k]['SubTotalIn'];
                $stok_report[$k]['in_qnty'] = $stok_report[$k]['totalPrhcsCtn'];
                $stok_report[$k]['out_qnty'] = $sales->totalSalesQnty;
                $stok_report[$k]['SubTotalStock'] = ($sub_total_stock + $stok_report[$k]['stok_quantity']);
                $sub_total_stock = $stok_report[$k]['SubTotalStock'];
            }
        } else {
            $CI->session->set_userdata('error_message', display('stock_not_available'));
            redirect('dashboard/Creport');
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('stock_report_supplier_wise'),
            'stok_report' => $stok_report,
            'product_model' => $stok_report[0]['product_model'],
            'links' => $links,
            'date' => $date,
            'sub_total_in' => $sub_total_in,
            'sub_total_out' => $sub_total_out,
            'sub_total_stock' => $sub_total_stock,
            'supplier_list' => $supplier_list,
            'supplier_info' => $supplier_info,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );

        $reportList = $CI->parser->parse('dashboard/report/stock_report_supplier_wise', $data, true);
        return $reportList;
    }

    // Stock Report Product Wise
    public function stock_report_product_wise($product_id, $supplier_id, $from_date, $to_date, $links, $per_page, $page)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Suppliers');
        $CI->load->library('dashboard/occational');
        $stok_report = $CI->Reports->stock_report_product_bydate($product_id, $supplier_id, $from_date, $to_date, $per_page, $page);

        $supplier_list = $CI->Suppliers->supplier_list_report();
        $supplier_info = $CI->Suppliers->retrieve_supplier_editdata($supplier_id);

        $sub_total_in = 0;
        $sub_total_out = 0;
        $sub_total_stock = 0;
        $sub_total_in_qnty = 0;
        $sub_total_out_qnty = 0;
        $sub_total_in_taka = 0;
        $sub_total_out_taka = 0;
        $stok_quantity_cartoon = 0;

        if (($stok_report)) {
            $i = $page;
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['sl'] = $i;
            }

            foreach ($stok_report as $k => $v) {
                $i++;

                $sales = $CI->db->select("
					sum(quantity) as totalSalesQnty,
					quantity,
					rate
					")
                    ->from('invoice_details')
                    ->where('product_id', $v['product_id'])
                    ->get()
                    ->row();

                $stok_report[$k]['stok_quantity_cartoon'] = ($stok_report[$k]['totalPurchaseQnty'] - $sales->totalSalesQnty);
                $stok_report[$k]['totalSalesQnty'] = ($sales->totalSalesQnty);
                $stok_report[$k]['SubTotalStock'] = ($sub_total_stock + $stok_report[$k]['stok_quantity_cartoon']);
                $sub_total_stock = $stok_report[$k]['SubTotalStock'];
                $stok_report[$k]['in_taka'] = $stok_report[$k]['totalPurchaseQnty'] * $stok_report[$k]['supplier_price'];
                $stok_report[$k]['out_taka'] = $sales->totalSalesQnty * $stok_report[$k]['supplier_price'];
                $stok_report[$k]['SubTotalinQnty'] = ($sub_total_in_qnty + $stok_report[$k]['totalPurchaseQnty']);
                $sub_total_in_qnty = $stok_report[$k]['SubTotalinQnty'];
                $stok_report[$k]['SubTotaloutQnty'] = ($sub_total_out_qnty + $sales->totalSalesQnty);
                $sub_total_out_qnty = $stok_report[$k]['SubTotaloutQnty'];
                $stok_report[$k]['SubTotalinTaka'] = ($sub_total_in_taka + $stok_report[$k]['in_taka']);
                $sub_total_in_taka = $stok_report[$k]['SubTotalinTaka'];
                $stok_report[$k]['SubTotalOutTaka'] = ($sub_total_out_taka + $stok_report[$k]['out_taka']);
                $sub_total_out_taka = $stok_report[$k]['SubTotalOutTaka'];
            }
        } else {
            $CI->session->set_userdata('error_message', display('stock_not_available'));
            redirect('dashboard/Creport');
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('stock_report_product_wise'),
            'stok_report' => $stok_report,
            'product_model' => $stok_report[0]['product_model'],
            'links' => $links,
            'date' => $to_date,
            'sub_total_in' => $sub_total_in,
            'sub_total_out' => $sub_total_out,
            'sub_total_stock' => $sub_total_stock,
            'SubTotalinQnty' => $sub_total_in_qnty,
            'SubTotaloutQnty' => $sub_total_out_qnty,
            'sub_total_in_taka' => number_format($sub_total_in_taka, 2, '.', ','),
            'sub_total_out_taka' => number_format($sub_total_out_taka, 2, '.', ','),
            'supplier_list' => $supplier_list,
            'supplier_info' => $supplier_info,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );

        $reportList = $CI->parser->parse('dashboard/report/stock_report_product_wise', $data, true);
        return $reportList;
    }

    // Stock Report Variant Wise
    public function stock_report_variant_wise($from_date, $to_date, $store_id, $links, $per_page, $page, $product_id = false)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Suppliers');
        $CI->load->model('dashboard/Products');
        $CI->load->model('dashboard/Stores');
        $CI->load->library('dashboard/occational');

        if(empty($store_id)){
           $from_date = date('m-01-Y');
           $to_date = date('m-d-Y');
            $result =  $CI->db->select('store_id')->from('store_set')->where('default_status=',1)->get()->row();
            $store_id = $result->store_id;
        }

        $stok_report = $CI->Reports->stock_report_by_store($from_date, $to_date, $store_id, $per_page, $page, $product_id);

        $product_list = $CI->Products->product_list();

        $store_list = $CI->Stores->store_list();

        $sub_total_in = 0;
        $sub_total_out = 0;
        $sub_total_stock = 0;

        $i = $page;
        foreach ($stok_report as $k => $v) {
            $i++;
            $stok_report[$k]['sl'] = $i;

        }
        if ($stok_report) {
            foreach ($stok_report as $k => $v) {
                $i++;

                $CI->db->select("sum(quantity) as totalSalesQnty,quantity");
                $CI->db->from('invoice_details');
                $CI->db->where('product_id', @$v['product_id']);
                $CI->db->where('variant_id', @$v['variant_id']);

                if(!empty($v['variant_color'])){
                  $CI->db->where('variant_color', @$v['variant_color']);  
                }

                $CI->db->where('store_id', @$v['store_id']);
                $sales = $CI->db->get()->row();

                $CI->db->select("sum(b.quantity) as totalPrhcsCtn");
                $CI->db->from('transfer b');
                $CI->db->where('product_id', @$v['product_id']);
                $CI->db->where('variant_id', @$v['variant_id']);
                if(!empty($v['variant_color'])){
                  $CI->db->where('variant_color', @$v['variant_color']);  
                }
                $CI->db->where('store_id', @$v['store_id']);
                $CI->db->where('t_store_id =', null);
                $purchase = $CI->db->get()->row();

                $CI->db->select("sum(b.quantity) as totalReceive");
                $CI->db->from('transfer b');
                $CI->db->where('product_id', @$v['product_id']);
                $CI->db->where('variant_id', @$v['variant_id']);
                if(!empty($v['variant_color'])){
                  $CI->db->where('variant_color', @$v['variant_color']);  
                }
                $CI->db->where('store_id', @$v['store_id']);
                $CI->db->where('quantity >', 0);
                $CI->db->where('t_store_id !=', null);
                $receive = $CI->db->get()->row();

                $CI->db->select("sum(b.quantity) as totalSend");
                $CI->db->from('transfer b');
                $CI->db->where('product_id', @$v['product_id']);
                $CI->db->where('variant_id', @$v['variant_id']);
                if(!empty($v['variant_color'])){
                  $CI->db->where('variant_color', @$v['variant_color']);  
                }
                $CI->db->where('store_id', @$v['store_id']);
                $CI->db->where('quantity <', 0);
                $CI->db->where('t_store_id !=', null);
                $send = $CI->db->get()->row();


                $stok_report[$k]['stok_quantity'] = (@$purchase->totalPrhcsCtn + @$receive->totalReceive -
                    $sales->totalSalesQnty + @$send->totalSend);

                $stok_report[$k]['SubTotalOut'] = ($sub_total_out + $sales->totalSalesQnty);
                $sub_total_out = $stok_report[$k]['SubTotalOut'];

                $stok_report[$k]['SubTotalIn'] = ($sub_total_in + @$receive->totalReceive + @$purchase->totalPrhcsCtn);
                $sub_total_in = $stok_report[$k]['SubTotalIn'];

                $stok_report[$k]['in_qnty'] = @$purchase->totalPrhcsCtn;
                $stok_report[$k]['out_qnty'] = $sales->totalSalesQnty;
                $stok_report[$k]['rec_qty'] = @$receive->totalReceive;

                $stok_report[$k]['issue_qty'] = @substr($send->totalSend, 1);
                $stok_report[$k]['SubTotalStock'] = ($sub_total_stock + $stok_report[$k]['stok_quantity']);
                $sub_total_stock = $stok_report[$k]['SubTotalStock'];

            }
        } else {
            $CI->session->set_userdata('error_message', display('stock_not_available'));

        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('stock_report_store_wise'),
            'stok_report' => $stok_report,
            'product_model' => @$stok_report[0]['product_model'],
            'links' => $links,
            'date' => '',
            'sub_total_in' => $sub_total_in,
            'sub_total_out' => $sub_total_out,
            'sub_total_stock' => $sub_total_stock,
            'product_list' => $product_list,
            'store_list' => $store_list,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/stock_report_variant_wise', $data, true);
        return $reportList;


    }

// ===========================STORE WISE STOCK REPORT======================
    public function store_wise_product($links = null, $per_page = null, $page = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $stok_report = $CI->Reports->store_wise_product($per_page, $page);
        $i = $page;
        if (!empty($stok_report)) {
            foreach ($stok_report as $k => $v) {
                $i++;
                $stok_report[$k]['sl'] = $i;
            }
        }

        $data = [
            'store_product_list' => $stok_report,
            'links' => $links
        ];
        $reportList = $CI->parser->parse('dashboard/report/stock_report_store_wise', $data, true);
        return $reportList;

    }


//=================sales report store wise==================
    public function sales_report_store_wise($links = null, $per_page = null, $page = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Stores');
        $CI->load->model('dashboard/Reports');
        $store_list = $CI->Stores->store_list();
        $data = [
            'stores' => $store_list
        ];
        $reportList = $CI->parser->parse('dashboard/report/sales_report_store_wise', $data, true);
        return $reportList;
    }

    public function retrieve_sales_report_store_wise($store_id, $start_date = null, $end_date = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Stores');
        $store_list = $CI->Stores->store_list();
        $sales_reports = $CI->Reports->retrieve_sales_report_store_wise($store_id, $start_date, $end_date);
        $data = [
            'sales_reports' => $sales_reports,
            'stores' => $store_list,
            'start_date' => $start_date,
            'end_date' => $end_date
        ];
        $reportList = $CI->parser->parse('dashboard/report/sales_report_store_wise', $data, true);
        return $reportList;
    }

    // Retrieve todays_sales_report
    public function todays_sales_report($links = null, $per_page = null, $page = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Web_settings');
        $CI->load->library('dashboard/occational');
        $sales_report = $CI->Reports->todays_sales_report($per_page, $page);
        $sales_amount = 0;
        if (!empty($sales_report)) {
            $i = 0;
            foreach ($sales_report as $k => $v) {
                $i++;
                $sales_report[$k]['sl'] = $i;
                $sales_report[$k]['sales_date'] = $CI->occational->dateConvert($sales_report[$k]['date']);
                $sales_amount = $sales_amount + $sales_report[$k]['total_amount'];
            }
        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();

        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('todays_sales_report'),
            'sales_amount' => number_format($sales_amount, 2, '.', ','),
            'sales_report' => $sales_report,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
            'links' => $links,
        );
        $reportList = $CI->parser->parse('dashboard/report/sales_report', $data, true);
        return $reportList;
    }

    // Retrieve datewise sales report
    public function retrieve_dateWise_SalesReports($start_date = false, $end_date=false)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Web_settings');
        $CI->load->library('dashboard/occational');
        $sales_report = $CI->Reports->retrieve_dateWise_SalesReports($start_date, $end_date);

        $sales_amount = 0;
        if (!empty($sales_report)) {
            $i = 0;
            foreach ($sales_report as $k => $v) {
                $i++;
                $sales_report[$k]['sl'] = $i;
                $sales_report[$k]['sales_date'] = $CI->occational->dateConvert($sales_report[$k]['date']);
                $sales_amount = $sales_amount + $sales_report[$k]['total_amount'];
            }
        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('sales_report'),
            'sales_amount' => $sales_amount,
            'sales_report' => $sales_report,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
            'links' => '',
        );
        $reportList = $CI->parser->parse('dashboard/report/sales_report', $data, true);
        return $reportList;
    }

    // Retrieve todays_purchase_report
    public function todays_purchase_report($links = null, $per_page = null, $page = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Web_settings');
        $CI->load->library('dashboard/occational');
        $purchase_report = $CI->Reports->todays_purchase_report($per_page, $page);
        $purchase_amount = 0;

        if (!empty($purchase_report)) {
            $i = 0;
            foreach ($purchase_report as $k => $v) {
                $i++;
                $purchase_report[$k]['sl'] = $i;
                $purchase_report[$k]['prchse_date'] = $CI->occational->dateConvert($purchase_report[$k]['purchase_date']);
                $purchase_amount = $purchase_amount + $purchase_report[$k]['grand_total_amount'];
            }
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('todays_purchase_report'),
            'purchase_amount' => number_format($purchase_amount, 2, '.', ','),
            'purchase_report' => $purchase_report,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
            'links' => $links,
        );
        $reportList = $CI->parser->parse('dashboard/report/purchase_report', $data, true);
        return $reportList;
    }

    //Total profit report
    public function total_profit_report($links, $per_page, $page)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');
        $total_profit_report = $CI->Reports->total_profit_report($per_page, $page);

        $profit_ammount = 0;
        $SubTotalSupAmnt = 0;
        $SubTotalSaleAmnt = 0;
        if (!empty($total_profit_report)) {
            $i = 0;
            foreach ($total_profit_report as $k => $v) {
                $total_profit_report[$k]['sl'] = $i;
                $total_profit_report[$k]['prchse_date'] = $CI->occational->dateConvert($total_profit_report[$k]['date']);
                $profit_ammount = $profit_ammount + $total_profit_report[$k]['total_profit'];
                $SubTotalSupAmnt = $SubTotalSupAmnt + $total_profit_report[$k]['total_supplier_rate'];
                $SubTotalSaleAmnt = $SubTotalSaleAmnt + $total_profit_report[$k]['total_sale'];
            }
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('total_profit_report'),
            'profit_ammount' => number_format($profit_ammount, 2, '.', ','),
            'total_profit_report' => $total_profit_report,
            'SubTotalSupAmnt' => number_format($SubTotalSupAmnt, 2, '.', ','),
            'SubTotalSaleAmnt' => number_format($SubTotalSaleAmnt, 2, '.', ','),
            'links' => $links,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/profit_report', $data, true);
        return $reportList;
    }

    //Retrive datewise purchase report
    public function retrieve_dateWise_PurchaseReports($start_date, $end_date)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');
        $purchase_report = $CI->Reports->retrieve_dateWise_PurchaseReports($start_date, $end_date);
        $purchase_amount = 0;
        if (!empty($purchase_report)) {
            $i = 0;
            foreach ($purchase_report as $k => $v) {
                $i++;
                $purchase_report[$k]['sl'] = $i;
                $purchase_report[$k]['prchse_date'] = $CI->occational->dateConvert($purchase_report[$k]['purchase_date']);
                $purchase_amount = $purchase_amount + $purchase_report[$k]['grand_total_amount'];
            }
        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $company_info = $CI->Reports->retrieve_company();
        $data = array(
            'title' => display('purchase_report'),
            'purchase_amount' => $purchase_amount,
            'purchase_report' => $purchase_report,
            'company_info' => $company_info,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
            'links' => ''
        );
        $reportList = $CI->parser->parse('dashboard/report/purchase_report', $data, true);
        return $reportList;
    }

    //Retrive date wise total profit report
    public function retrieve_dateWise_profit_report($start_date, $end_date)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');
        $total_profit_report = $CI->Reports->retrieve_dateWise_profit_report($start_date, $end_date);

        $profit_ammount = 0;
        $SubTotalSupAmnt = 0;
        $SubTotalSaleAmnt = 0;
        if (!empty($total_profit_report)) {
            $i = 0;
            foreach ($total_profit_report as $k => $v) {
                $total_profit_report[$k]['sl'] = $i;
                $total_profit_report[$k]['prchse_date'] = $CI->occational->dateConvert($total_profit_report[$k]['date']);
                $profit_ammount = $profit_ammount + $total_profit_report[$k]['total_profit'];
                $SubTotalSupAmnt = $SubTotalSupAmnt + $total_profit_report[$k]['total_supplier_rate'];
                $SubTotalSaleAmnt = $SubTotalSaleAmnt + $total_profit_report[$k]['total_sale'];
            }
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('profit_report'),
            'profit_ammount' => number_format($profit_ammount, 2, '.', ','),
            'total_profit_report' => $total_profit_report,
            'SubTotalSupAmnt' => number_format($SubTotalSupAmnt, 2, '.', ','),
            'SubTotalSaleAmnt' => number_format($SubTotalSaleAmnt, 2, '.', ','),
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/profit_report', $data, true);
        return $reportList;
    }

    // Retrieve transfer report
    public function transfer_report($from_date = null, $to_date = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');

        $store_to_store_transfer = $CI->Reports->store_to_store_transfer($from_date, $to_date);
        $store_to_warehouse_transfer = $CI->Reports->store_to_warehouse_transfer($from_date, $to_date);
        $warehouse_to_store_transfer = $CI->Reports->warehouse_to_store_transfer($from_date, $to_date);
        $warehouse_to_warehouse_transfer = $CI->Reports->warehouse_to_warehouse_transfer($from_date, $to_date);

        $data = array(
            'title' => display('transfer_report'),
            'store_to_store_transfer' => $store_to_store_transfer,
            'store_to_warehouse_transfer' => $store_to_warehouse_transfer,
            'warehouse_to_store_transfer' => $warehouse_to_store_transfer,
            'warehouse_to_warehouse_transfer' => $warehouse_to_warehouse_transfer,
        );
        $reportList = $CI->parser->parse('dashboard/report/transfer_report', $data, true);
        return $reportList;
    }

    // Retrieve store to store transfer report
    public function store_to_store_transfer($from_date = null, $to_date = null, $from_store = null, $to_store = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Stores');

        $store_to_store_transfer = $CI->Reports->store_to_store_transfer($from_date, $to_date, $from_store, $to_store);
        $store_list = $CI->Stores->store_list();

        $data = array(
            'title' => display('store_to_store_transfer'),
            'store_to_store_transfer' => $store_to_store_transfer,
            'store_list' => $store_list,
        );
        $reportList = $CI->parser->parse('dashboard/report/store_to_store_transfer', $data, true);
        return $reportList;
    }

    // Store to wearhouse transfer
    public function store_to_warehouse_transfer($from_date = null, $to_date = null, $from_store = null, $t_wearhouse = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Stores');
        $CI->load->model('dashboard/Wearhouses');

        $store_to_warehouse_transfer = $CI->Reports->store_to_warehouse_transfer($from_date, $to_date, $from_store, $t_wearhouse);
        $store_list = $CI->Stores->store_list();
        $wearhouse_list = $CI->Wearhouses->wearhouse_list();

        $data = array(
            'title' => display('store_to_warehouse_transfer'),
            'store_to_warehouse_transfer' => $store_to_warehouse_transfer,
            'store_list' => $store_list,
            'wearhouse_list' => $wearhouse_list,
        );
        $reportList = $CI->parser->parse('dashboard/report/store_to_warehouse_transfer', $data, true);
        return $reportList;
    }

    // Wearhouse to store transfer
    public function warehouse_to_store_transfer($from_date = null, $to_date = null, $wearhouse = null, $t_store = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Stores');
        $CI->load->model('dashboard/Wearhouses');

        $warehouse_to_store_transfer = $CI->Reports->warehouse_to_store_transfer($from_date, $to_date, $wearhouse, $t_store);
        $store_list = $CI->Stores->store_list();
        $wearhouse_list = $CI->Wearhouses->wearhouse_list();

        $data = array(
            'title' => display('warehouse_to_store_transfer'),
            'warehouse_to_store_transfer' => $warehouse_to_store_transfer,
            'store_list' => $store_list,
            'wearhouse_list' => $wearhouse_list,
        );
        $reportList = $CI->parser->parse('dashboard/report/warehouse_to_store_transfer', $data, true);
        return $reportList;
    }

    // Wearhouse to wearhouse transfer
    public function warehouse_to_warehouse_transfer($from_date = null, $to_date = null, $wearhouse = null, $t_wearhouse = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Wearhouses');

        $warehouse_to_warehouse_transfer = $CI->Reports->warehouse_to_warehouse_transfer($from_date, $to_date, $wearhouse, $t_wearhouse);
        $wearhouse_list = $CI->Wearhouses->wearhouse_list();
        $data = array(
            'title' => display('warehouse_to_warehouse_transfer'),
            'warehouse_to_warehouse_transfer' => $warehouse_to_warehouse_transfer,
            'wearhouse_list' => $wearhouse_list,
        );
        $reportList = $CI->parser->parse('dashboard/report/warehouse_to_warehouse_transfer', $data, true);
        return $reportList;
    }

    // Retrieve tax report
    public function tax_report($from_date = null, $to_date = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');

        $tax_report_product_wise = $CI->Reports->tax_report_product_wise($from_date, $to_date);
        $Subtotal_tax_amnt = 0;
        if (!empty($tax_report_product_wise)) {
            $i = 0;
            foreach ($tax_report_product_wise as $k => $v) {
                $tax_report_product_wise[$k]['sl'] = $i;
                $tax_report_product_wise[$k]['date'] = $CI->occational->dateConvert($tax_report_product_wise[$k]['date']);
                $Subtotal_tax_amnt = $Subtotal_tax_amnt + $tax_report_product_wise[$k]['amount'];
            }
        }

        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('tax_report_product_wise'),
            'tax_report_product_wise' => $tax_report_product_wise,
            'Subtotal_tax_amnt' => $Subtotal_tax_amnt,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/tax_report_product_wise', $data, true);
        return $reportList;
    }

    // Retrieve tax report
    public function tax_report_invoice_wise($from_date = null, $to_date = null)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');

        $tax_report_invoice_wise = $CI->Reports->tax_report_invoice_wise($from_date, $to_date);
        $Subtotal_tax_amnt = 0;
        if (!empty($tax_report_invoice_wise)) {
            $i = 0;
            foreach ($tax_report_invoice_wise as $k => $v) {
                $tax_report_invoice_wise[$k]['sl'] = $i;
                $tax_report_invoice_wise[$k]['date'] = $CI->occational->dateConvert($tax_report_invoice_wise[$k]['date']);
                $Subtotal_tax_amnt = $Subtotal_tax_amnt + $tax_report_invoice_wise[$k]['tax_amount'];
            }
        }


        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('tax_report_invoice_wise'),
            'tax_report_invoice_wise' => $tax_report_invoice_wise,
            'Subtotal_tax_amnt' => $Subtotal_tax_amnt,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/tax_report_invoice_wise', $data, true);
        return $reportList;
    }

    //Products search report
    public function get_products_search_report($from_date, $to_date)
    {
        $CI =& get_instance();
        $CI->load->model('dashboard/Reports');
        $CI->load->model('dashboard/Soft_settings');
        $CI->load->library('dashboard/occational');
        $product_report = $CI->Reports->retrieve_product_search_sales_report($from_date, $to_date);

        if (!empty($product_report)) {
            $i = 0;
            foreach ($product_report as $k => $v) {
                $i++;
                $product_report[$k]['sl'] = $i;
            }
        }
        $sub_total = 0;
        if (!empty($product_report)) {
            foreach ($product_report as $k => $v) {
                $product_report[$k]['sales_date'] = $CI->occational->dateConvert($product_report[$k]['date']);
                $sub_total = $sub_total + $product_report[$k]['total_price'];
            }
        }
        $currency_details = $CI->Soft_settings->retrieve_currency_info();
        $data = array(
            'title' => display('sales_report_product_wise'),
            'sub_total' => number_format($sub_total, 2, '.', ','),
            'product_report' => $product_report,
            'currency' => $currency_details[0]['currency_icon'],
            'position' => $currency_details[0]['currency_position'],
        );
        $reportList = $CI->parser->parse('dashboard/report/product_report', $data, true);
        return $reportList;
    }
}

?>

ZeroDay Forums Mini