���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() 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/ |
<?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; } } ?>