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);
}
}