���� 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 Cpurchase extends MX_Controller { function __construct() { parent::__construct(); $this->auth->check_user_auth(); $this->load->model(array( 'dashboard/Suppliers', 'dashboard/Purchases', 'dashboard/Stores', 'dashboard/Variants', 'dashboard/Soft_settings', 'template/Template_model', )); $this->load->library('dashboard/occational'); } //Default index function loading public function index() { $this->permission->check_label('add_purchase')->create()->redirect(); $all_supplier = $this->Purchases->select_all_supplier(); $store_list = $this->Stores->store_list(); $get_def_store = $this->Stores->get_def_store(); $variant_list = $this->Variants->variant_list(); $data = array( 'title' => display('add_purchase'), 'all_supplier' => $all_supplier, 'store_list' => $store_list, 'def_store' => $get_def_store, 'variant_list' => $variant_list, ); $data['setting'] = $this->Template_model->setting(); $data['module'] = "dashboard"; $data['page'] = 'purchase/add_purchase_form'; $this->parser->parse('template/layout', $data); } //Purchase Add Form public function manage_purchase() { $this->permission->check_label('manage_purchase')->read()->redirect(); $purchases_list = $this->Purchases->purchase_list(); if (!empty($purchases_list)) { $j = 0; foreach ($purchases_list as $k => $v) { $purchases_list[$k]['final_date'] = $this->occational->dateConvert($purchases_list[$j]['purchase_date']); $j++; } $i = 0; foreach ($purchases_list as $k => $v) { $i++; $purchases_list[$k]['sl'] = $i; } } $currency_details = $this->Soft_settings->retrieve_currency_info(); $data = array( 'title' => display('manage_purchase'), 'purchases_list' => $purchases_list, 'currency' => $currency_details[0]['currency_icon'], 'position' => $currency_details[0]['currency_position'], ); $data['setting'] = $this->Template_model->setting(); $data['module'] = "dashboard"; $data['page'] = 'purchase/purchase'; $this->parser->parse('template/layout', $data); } //Insert Purchase and uload public function insert_purchase() { $this->permission->check_label('add_purchase')->create()->redirect(); $this->Purchases->purchase_entry(); $this->session->set_userdata(array('message' => display('successfully_added'))); if (isset($_POST['add-purchase'])) { redirect(base_url('dashboard/Cpurchase/manage_purchase')); } elseif (isset($_POST['add-purchase-another'])) { redirect(base_url('dashboard/Cpurchase')); } } //Purchase Update Form public function purchase_update_form($purchase_id) { $this->permission->check_label('manage_purchase')->update()->redirect(); $purchase_detail = $this->Purchases->retrieve_purchase_editdata($purchase_id); $supplier_id = $purchase_detail[0]['supplier_id']; $supplier_list = $this->Suppliers->supplier_list(); $supplier_selected = $this->Suppliers->supplier_search_item($supplier_id); $this->load->model('Wearhouses'); $wearhouse_list = $this->Wearhouses->wearhouse_list(); $store_list = $this->Stores->store_list(); $variant_list = $this->Variants->variant_list(); if (!empty($purchase_detail)) { $i = 0; foreach ($purchase_detail as $k => $v) { $i++; $purchase_detail[$k]['sl'] = $i; } } $data = array( 'title' => display('purchase_edit'), 'purchase_id' => $purchase_detail[0]['purchase_id'], 'invoice_no' => $purchase_detail[0]['invoice_no'], 'supplier_name' => $purchase_detail[0]['supplier_name'], 'supplier_id' => $purchase_detail[0]['supplier_id'], 'grand_total' => $purchase_detail[0]['grand_total_amount'], 'purchase_details' => $purchase_detail[0]['purchase_details'], 'purchase_date' => $purchase_detail[0]['purchase_date'], 'store_id' => $purchase_detail[0]['store_id'], 'wearhouse_id' => $purchase_detail[0]['wearhouse_id'], 'variant_id' => $purchase_detail[0]['variant_id'], 'purchase_info' => $purchase_detail, 'supplier_list' => $supplier_list, 'supplier_selected' => $supplier_selected, 'wearhouse_list' => $wearhouse_list, 'store_list' => $store_list, 'variant_list' => $variant_list, ); $data['setting'] = $this->Template_model->setting(); $data['module'] = "dashboard"; $data['page'] = 'purchase/edit_purchase_form'; $this->parser->parse('template/layout', $data); } //Purchase Update public function purchase_update() { $this->permission->check_label('manage_purchase')->update()->redirect(); $this->Purchases->update_purchase(); $this->session->set_userdata(array('message' => display('successfully_updated'))); redirect(base_url('dashboard/Cpurchase/manage_purchase')); } // Purchase delete public function purchase_delete($purchase_id) { $this->permission->check_label('manage_purchase')->delete()->redirect(); $this->Purchases->delete_purchase($purchase_id); $this->session->set_userdata(array('message' => display('successfully_delete'))); redirect('dashboard/Cpurchase/manage_purchase'); } //Purchase item by search public function purchase_item_by_search() { $supplier_id = $this->input->post('supplier_id',TRUE); $purchases_list = $this->Purchases->purchase_by_search($supplier_id); $j = 0; if (!empty($purchases_list)) { foreach ($purchases_list as $k => $v) { $purchases_list[$k]['final_date'] = $this->occational->dateConvert($purchases_list[$j]['purchase_date']); $j++; } $i = 0; foreach ($purchases_list as $k => $v) { $i++; $purchases_list[$k]['sl'] = $i; } } $data = array( 'purchases_list' => $purchases_list ); $data['setting'] = $this->Template_model->setting(); $data['module'] = "dashboard"; $data['page'] = 'purchase/purchase'; $this->parser->parse('template/layout', $data); } //Purchase search by supplier id public function product_search_by_supplier() { $supplier_id = $this->input->post('supplier_id',TRUE); $product_name = $this->input->post('product_name',TRUE); $product_info = $this->Suppliers->product_search_item($supplier_id, $product_name); $list[''] = ""; foreach ($product_info as $value) { $json_product[] = array('label' => $value['product_name'] . '-(' . $value['product_model'] . ')', 'value' => $value['product_id']); } echo json_encode($json_product); } // Retrieve Purchase Data public function retrieve_product_data() { $product_id = $this->input->post('product_id',TRUE); $product_info = $this->Purchases->get_total_product($product_id); echo json_encode($product_info); } //Retrive right now inserted data to cretae html public function purchase_details_data($purchase_id) { $purchase_detail = $this->Purchases->purchase_details_data($purchase_id); if (!empty($purchase_detail)) { $i = 0; foreach ($purchase_detail as $k => $v) { $i++; $purchase_detail[$k]['sl'] = $i; } foreach ($purchase_detail as $k => $v) { $purchase_detail[$k]['convert_date'] = $this->occational->dateConvert($purchase_detail[$k]['purchase_date']); } } $currency_details = $this->Soft_settings->retrieve_currency_info(); $company_info = $this->Purchases->retrieve_company(); $data = array( 'title' => display('purchase_ledger'), 'purchase_id' => $purchase_detail[0]['purchase_id'], 'purchase_details' => $purchase_detail[0]['purchase_details'], 'supplier_name' => $purchase_detail[0]['supplier_name'], 'final_date' => $purchase_detail[0]['convert_date'], 'sub_total_amount' => $purchase_detail[0]['grand_total_amount'], 'invoice_no' => $purchase_detail[0]['invoice_no'], 'purchase_all_data' => $purchase_detail, 'company_info' => $company_info, 'currency' => $currency_details[0]['currency_icon'], 'position' => $currency_details[0]['currency_position'], ); $data['setting'] = $this->Template_model->setting(); $data['module'] = "dashboard"; $data['page'] = 'purchase/purchase_detail'; $this->parser->parse('template/layout', $data); } // Get variant price and stock public function check_admin_2d_variant_info() { $product_id = $this->input->post('product_id',TRUE); $store_id = $this->input->post('store_id',TRUE); $variant_id = $this->input->post('variant_id',TRUE); $variant_color = $this->input->post('variant_color',TRUE); $stock = $this->Purchases->check_variant_wise_stock($product_id, $store_id, $variant_id, $variant_color); if ($stock > 0) { $result[0] = "yes"; $price = $this->Purchases->check_variant_wise_price($product_id, $variant_id, $variant_color); $result[1] = $stock; //stock $result[2] = floatval($price['price']); //price $result[3] = 0; //discount } else { $result[0] = 'no'; } echo json_encode($result); } //Stock in available public function available_stock() { $product_id = $this->input->post('product_id',TRUE); $store_id = $this->input->post('store_id',TRUE); $variant_id = $this->input->post('variant_id',TRUE); $variant_color = $this->input->post('variant_color',TRUE); $this->db->select('SUM(a.quantity) as total_purchase'); $this->db->from('transfer a'); $this->db->where('a.product_id', $product_id); $this->db->where('a.store_id', $store_id); $this->db->where('a.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('a.variant_color', $variant_color); } $total_purchase = $this->db->get()->row(); $this->db->select('SUM(b.quantity) as total_sale'); $this->db->from('invoice_details b'); $this->db->where('b.product_id', $product_id); $this->db->where('b.store_id', $store_id); $this->db->where('b.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('b.variant_color', $variant_color); } $total_sale = $this->db->get()->row(); echo $total_purchase->total_purchase - $total_sale->total_sale; } //check stock product quantity public function check_product_stock() { $product_id = $this->input->post('product_id',TRUE); $variant_id = $this->input->post('variant_id',TRUE); $store_id = $this->input->post('store_id',TRUE); $variant_color = $this->input->post('variant_color',TRUE); $this->db->select('SUM(a.quantity) as total_purchase'); $this->db->from('transfer a'); $this->db->where('a.product_id', $product_id); $this->db->where('a.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('a.variant_color', $variant_color); } $this->db->where('a.store_id', $store_id); $total_purchase = $this->db->get()->row(); $this->db->select('SUM(b.quantity) as total_sale'); $this->db->from('invoice_details b'); $this->db->where('b.product_id', $product_id); $this->db->where('b.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('b.variant_color', $variant_color); } $this->db->where('b.store_id', $store_id); $total_sale = $this->db->get()->row(); echo $total_purchase->total_purchase - $total_sale->total_sale; } //Wearhouse available stock check public function wearhouse_available_stock() { $product_id = $this->input->post('product_id',TRUE); $variant_id = $this->input->post('variant_id',TRUE); $variant_color = $this->input->post('variant_color',TRUE); $store_id = $this->input->post('store_id',TRUE); $purchase_to = $this->input->post('purchase_to'); $this->db->select('SUM(a.quantity) as total_purchase'); $this->db->from('transfer a'); $this->db->where('a.product_id', $product_id); $this->db->where('a.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('a.variant_color', $variant_color); } $this->db->where('a.store_id', $store_id); $total_purchase = $this->db->get()->row(); $this->db->select('SUM(b.quantity) as total_sale'); $this->db->from('invoice_details b'); $this->db->where('b.product_id', $product_id); $this->db->where('b.variant_id', $variant_id); if(!empty($variant_color)){ $this->db->where('b.variant_color', $variant_color); } $this->db->where('b.store_id', $store_id); $total_sale = $this->db->get()->row(); echo $total_purchase->total_purchase - $total_sale->total_sale; } // check default store is or not public function check_default_store() { $store_id = $this->input->post('store_id', TRUE); $result = false; if(!empty($store_id)){ $this->db->where('store_id', $store_id); $this->db->where('default_status', 1); $query = $this->db->get('store_set'); if($query->num_rows() > 0){ $result = TRUE; } } echo $result; } }