���� 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/controllers/ |
<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Creport extends MX_Controller { function __construct() { parent::__construct(); $this->auth->check_user_auth(); $this->load->model(array( 'dashboard/Soft_settings', 'dashboard/Reports', 'dashboard/Suppliers', 'dashboard/Products', 'dashboard/Stores', 'template/Template_model', )); $this->load->library('dashboard/occational'); $this->load->library('dashboard/lreport'); } public function index() { $this->permission->check_label('stock_report')->read()->redirect(); $CI =& get_instance(); $today = date('m-d-Y'); $product_id = $this->input->post('product_id')?$this->input->post('product_id'):""; $date=$this->input->post('stock_date')?$this->input->post('stock_date'):$today; $limit=20; $start_record=($this->uri->segment(5)) ? $this->uri->segment(5) : 0; $date=($this->uri->segment(4)) ? $this->uri->segment(4) : $date; $link=$this->pagination($limit,"dashboard/Creport/index/$date",$date); $content = $CI->lreport->stock_report_single_item($product_id,$date,$limit,$start_record,$link); $this->template_lib->full_admin_html_view($content); } //=======stock report store wise ========== public function store_wise_product() { # #pagination starts # $config["base_url"] = base_url('dashboard/Creport/store_wise_product/'); $config["total_rows"] = @count($this->Reports->store_wise_product()); $config["per_page"] = 20; $config["uri_segment"] = 4; $config["num_links"] = 5; /* This Application Must Be Used With BootStrap 3 * */ $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tag_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; /* ends of bootstrap */ $this->pagination->initialize($config); $page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0; $links = $this->pagination->create_links(); # #pagination ends # $content = $this->lreport->store_wise_product($links, $config["per_page"], $page); $this->template_lib->full_admin_html_view($content); } //Out of stock product public function out_of_stock(){ $this->load->library('lreport'); $content = $this->lreport->out_of_stock(); $this->template_lib->full_admin_html_view($content); } //Stock report product wise public function stock_report_product_wise() { $this->permission->check_label('stock_report_product_wise')->read()->redirect(); $today = date('m-d-Y'); $product_id = $this->input->post('product_id',TRUE) ? $this->input->post('product_id',TRUE) : ""; $supplier_id = $this->input->post('supplier_id',TRUE) ? $this->input->post('supplier_id',TRUE) : ""; $from_date = $this->input->post('from_date',TRUE); $to_date = $this->input->post('to_date',TRUE) ? $this->input->post('to_date',TRUE) : $today; # #pagination starts # $config["base_url"] = base_url('dashboard/Creport/stock_report_product_wise'); $config["total_rows"] = $this->Reports->stock_report_product_bydate_count($supplier_id, $supplier_id, $from_date, $to_date); $config["per_page"] = 20; $config["uri_segment"] = 4; $config["num_links"] = 5; /* This Application Must Be Used With BootStrap 3 * */ $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tag_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; /* ends of bootstrap */ $this->pagination->initialize($config); $page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0; $links = $this->pagination->create_links(); # #pagination ends # $content =$this->lreport->stock_report_product_wise($product_id,$supplier_id,$from_date,$to_date,$links,$config["per_page"],$page); $this->template_lib->full_admin_html_view($content); } //Stock report supplier report public function stock_report_supplier_wise() { $this->permission->check_label('stock_report_supplier_wise')->read()->redirect(); $today = date('m-d-Y'); $product_id = $this->input->post('product_id',TRUE) ? $this->input->post('product_id',TRUE) : ""; $supplier_id = $this->input->post('supplier_id',TRUE) ? $this->input->post('supplier_id',TRUE) : ""; $date = $this->input->post('stock_date',TRUE) ? $this->input->post('stock_date',TRUE) : $today; # #pagination starts # $config["base_url"] = base_url('dashboard/Creport/stock_report_supplier_wise/'); $config["total_rows"] = $this->Reports->product_counter_by_supplier($supplier_id, $date); $config["per_page"] = 20; $config["uri_segment"] = 4; $config["num_links"] = 5; /* This Application Must Be Used With BootStrap 3 * */ $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tag_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; /* ends of bootstrap */ $this->pagination->initialize($config); $page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0; $links = $this->pagination->create_links(); # #pagination ends # $content =$this->lreport->stock_report_supplier_wise($product_id,$supplier_id,$date,$links,$config["per_page"],$page); $this->template_lib->full_admin_html_view($content); } public function stock_report_store_wise() { $this->permission->check_label('stock_report_store_wise')->read()->redirect(); $today = date('Y-m-d'); $from_date = $this->input->get('from_date',TRUE); $product_id = $this->input->get('product_id',TRUE); $to_date = $this->input->get('to_date',TRUE); $store_id = $this->input->get('store_id',TRUE); if (empty($store_id)) { $from_date = date('Y-m-01'); $to_date = date('Y-m-d'); $result = $this->db->select('store_id')->from('store_set')->where('default_status=', 1)->get()->row(); $store_id = $result->store_id; } # #pagination starts # $config["base_url"] = base_url('dashboard/Creport/stock_report_store_wise/'); $config["reuse_query_string"] = true; $config["total_rows"] = $this->Reports->stock_report_variant_bydate_count($from_date, $to_date, $store_id, $product_id ); $config["per_page"] = 20; $config["uri_segment"] = 4; $config["num_links"] = 5; /* This Application Must Be Used With BootStrap 3 * */ $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tag_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; /* ends of bootstrap */ $this->pagination->initialize($config); $page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0; $links = $this->pagination->create_links(); # #pagination ends # $content =$this->lreport->stock_report_variant_wise($from_date,$to_date,$store_id,$links, $config["per_page"],$page, $product_id); $this->template_lib->full_admin_html_view($content); } //Get product by supplier public function get_product_by_supplier() { $supplier_id = $this->input->post('supplier_id',TRUE); $product_info_by_supplier = $this->db->select('*') ->from('product_information') ->where('supplier_id', $supplier_id) ->get() ->result(); if ($product_info_by_supplier) { echo "<select class=\"form-control\" id=\"supplier_id\" name=\"supplier_id\"> <option value=\"\">" . display('select_one') . "</option>"; foreach ($product_info_by_supplier as $product) { echo "<option value='" . $product->product_id . "'>" . $product->product_name . '-(' . $product->product_model . ')' . " </option>"; } echo " </select>"; } } //Get variant by product public function retrive_variant_by_product() { $product_id = $this->input->post('product_id',TRUE); $product_information = $this->db->select('variants') ->from('product_information') ->where('product_id', $product_id) ->get() ->row(); $html = ""; if ($product_information->variants) { $exploded = explode(',', $product_information->variants); $html .= "<select id=\"variant_id\" class=\"form-control variant_id\" required=\"\" style=\"width:200px\"> <option>Select Variant</option>"; foreach ($exploded as $elem) { $this->db->select('*'); $this->db->from('variant'); $this->db->where('variant_id', $elem); $this->db->order_by('variant_name', 'asc'); $result = $this->db->get()->row(); $html .= "<option value=" . $result->variant_id . ">" . $result->variant_name . "</option>"; } $html .= "</select>"; } echo $html; } #===============Report paggination=============# public function pagination($per_page, $page, $date) { $product_id = $this->input->post('product_id',TRUE); $config = array(); $config["base_url"] = base_url() . $page; $config["total_rows"] = $this->Reports->product_counter($product_id, $date); $config["per_page"] = $per_page; $config["uri_segment"] = 5; $config["num_links"] = 5; /* This Application Must Be Used With BootStrap 3 * */ $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tag_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; $this->pagination->initialize($config); $page = ($this->uri->segment(5)) ? $this->uri->segment(5) : 0; $limit = $config["per_page"]; return $links = $this->pagination->create_links(); } public function stock_by_variant($id) { $data = $this->Reports->get_stock_items($id); $content=$this->parser->parse('report/stock_report_by_variant', $data, true); $this->template_lib->full_admin_html_view($content); } }