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 Corder extends MX_Controller
{
function __construct()
{
parent::__construct();
$this->auth->check_user_auth();
$this->load->model(array(
'dashboard/Orders',
'web/Homes',
'dashboard/Stores',
'dashboard/Variants',
'dashboard/Customers',
'dashboard/Shipping_methods',
'dashboard/Soft_settings',
'dashboard/Reports',
'template/Template_model',
));
$this->load->library('dashboard/occational');
$this->load->library('dashboard/lorder');
$this->load->library('pdfgenerator');
}
public function index()
{
$this->permission->check_label('new_order')->create()->redirect();
$content = $this->lorder->order_add_form();
$this->template_lib->full_admin_html_view($content);
}
public function new_order()
{
$this->permission->check_label('new_order')->create()->redirect();
$content = $this->lorder->order_add_form();
$this->template_lib->full_admin_html_view($content);
}
//Insert product and upload
public function insert_order()
{
$this->permission->check_label('new_order')->create()->redirect();
$customer_id = $this->input->post('customer_id',TRUE);
$customer = $this->db->select('*')->from('customer_information')->where('customer_id', $customer_id)->get()->row();
$order_id = $this->Orders->order_entry();
$this->session->set_userdata(array('message' => display('successfully_added')));
$this->order_inserted_data($order_id);
$customer_id = $this->session->userdata('customerId');
$ship_short_address = $this->input->post('customer_name_others_address',TRUE);
if ($this->input->post('customer_name_others',TRUE)) {
$shipping = array(
'customer_id' => $customer_id,
'order_id' => $order_id,
'customer_name' => $this->input->post('customer_name_others',TRUE),
'first_name' => '',
'last_name' => '',
'customer_short_address' => $ship_short_address,
'customer_address_1' => '',
'customer_address_2' => '',
'city' => '',
'state' => '',
'country' => '',
'zip' => '',
'company' => '',
'customer_mobile' => '',
'customer_email' => '',
);
} else {
$customer = $this->db->select('*')->from('customer_information')->where('customer_id', $customer_id)->get()->row();
$shipping = array(
'customer_id' => $customer_id,
'order_id' => $order_id,
'customer_name' => $customer->customer_name,
'first_name' => ($customer->first_name) ? $customer->first_name : '',
'last_name' => ($customer->last_name) ? $customer->last_name : '',
'customer_short_address' => ($customer->customer_short_address) ? $customer->customer_short_address : '',
'customer_address_1' => ($customer->customer_address_1) ? $customer->customer_address_1 : '',
'customer_address_2' => ($customer->customer_address_2) ? $customer->customer_address_2 : '',
'city' => ($customer->city) ? $customer->city : '',
'state' => ($customer->state) ? $customer->state : '',
'country' => ($customer->country) ? $customer->state : '',
'zip' => ($customer->zip) ? $customer->zip : '',
'company' => ($customer->company) ? $customer->company : '',
'customer_mobile' => ($customer->customer_mobile) ? $customer->customer_mobile : '',
'customer_email' => ($customer->customer_email) ? $customer->customer_email : '',
);
}
//Shipping information entry for existing customer
$this->Homes->shipping_entry($shipping);
$sms_status = $this->db->select('sms_service')->from('soft_setting')->get()->result_array();
if ($sms_status[0]['sms_service'] == 1) {
$this->Homes->send_sms($order_id, $customer_id, 'Order');
}
if (isset($_POST['add-order'])) {
redirect(base_url('dashboard/Corder/manage_order'));
} elseif (isset($_POST['add-order-another'])) {
redirect(base_url('dashboard/Corder'));
}
}
//Retrive right now inserted data to cretae html
public function order_inserted_data($order_id)
{
$content = $this->lorder->order_html_data($order_id);
$this->template_lib->full_admin_html_view($content);
}
//Retrive right now inserted data to cretae html
public function order_details_data($order_id)
{
$this->permission->check_label('manage_order')->read()->redirect();
$CI =& get_instance();
$content = $CI->lorder->order_details_data($order_id);
$this->template_lib->full_admin_html_view($content);
}
//Retrive order PDF Page
public function order_details_pdf($order_id)
{
$this->permission->check_label('manage_order')->read()->redirect();
$order_detail = $this->Orders->retrieve_order_html_data($order_id);
$payinfo = $this->Orders->get_order_payinfo($order_id);
$subTotal_quantity = 0;
$subTotal_cartoon = 0;
$subTotal_discount = 0;
if (!empty($order_detail)) {
foreach ($order_detail as $k => $v) {
$order_detail[$k]['final_date'] = $this->occational->dateConvert($order_detail[$k]['date']);
$subTotal_quantity = $subTotal_quantity + $order_detail[$k]['quantity'];
}
$i = 0;
foreach ($order_detail as $k => $v) {
$i++;
$order_detail[$k]['sl'] = $i;
}
}
$currency_details = $this->Soft_settings->retrieve_currency_info();
$company_info = $this->Orders->retrieve_company();
$data = array(
'title' => display('order_details'),
'order_id' => $order_detail[0]['order_id'],
'order_no' => $order_detail[0]['order'],
'customer_address' => $order_detail[0]['customer_short_address'],
'customer_name' => $order_detail[0]['customer_name'],
'customer_mobile' => $order_detail[0]['customer_mobile'],
'customer_email' => $order_detail[0]['customer_email'],
'final_date' => $order_detail[0]['final_date'],
'total_amount' => $order_detail[0]['total_amount'],
'order_discount' => $order_detail[0]['order_discount'],
'service_charge' => $order_detail[0]['service_charge'],
'paid_amount' => $order_detail[0]['paid_amount'],
'due_amount' => $order_detail[0]['due_amount'],
'details' => $order_detail[0]['details'],
'subTotal_quantity' => $subTotal_quantity,
'order_all_data' => $order_detail,
'company_info' => $company_info,
'currency' => $currency_details[0]['currency_icon'],
'position' => $currency_details[0]['currency_position'],
'payinfo' => $payinfo
);
$pdfhtml = $this->parser->parse('dashboard/order/order_pdf',$data,true);
$file_path = $this->pdfgenerator->generate_order($order_id, $pdfhtml);
$this->load->helper('download');
force_download($file_path, NULL);
redirect('dashboard/Corder/manage_order');
}
public function manage_order()
{
$this->permission->check_label('manage_order')->read()->redirect();
$filter = array(
'order_no' => $this->input->get('order_no', TRUE),
'customer_name' => $this->input->get('customer_name', TRUE),
'order_date' => $this->input->get('date', TRUE),
'invoice_status' => $this->input->get('invoice_status', TRUE)
);
$config["base_url"] = base_url('dashboard/Corder/manage_order');
$config["total_rows"] = $this->Orders->count_order_list($filter);
$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();
$content = $this->lorder->order_list($filter, $page, $config["per_page"], $links);
$this->template_lib->full_admin_html_view($content);
}
//order Update Form
public function order_update_form($order_id)
{
$this->permission->check_label('manage_order')->update()->redirect();
$content = $this->lorder->order_edit_data($order_id);
$this->template_lib->full_admin_html_view($content);
}
// order Update
public function order_update()
{
$this->permission->check_label('manage_order')->update()->redirect();
$order_id = $this->Orders->update_order();
//pdf generate start
$order_detail = $this->Orders->retrieve_order_html_data($order_id);
$subTotal_quantity = 0;
$subTotal_cartoon = 0;
$subTotal_discount = 0;
if (!empty($order_detail)) {
foreach ($order_detail as $k => $v) {
$order_detail[$k]['final_date'] = $this->occational->dateConvert($order_detail[$k]['date']);
$subTotal_quantity = $subTotal_quantity + $order_detail[$k]['quantity'];
}
$i = 0;
foreach ($order_detail as $k => $v) {
$i++;
$order_detail[$k]['sl'] = $i;
}
}
$currency_details = $this->Soft_settings->retrieve_currency_info();
$company_info = $this->Orders->retrieve_company();
$data = array(
'title' => display('order_details'),
'order_id' => $order_detail[0]['order_id'],
'order_no' => $order_detail[0]['order'],
'customer_address' => $order_detail[0]['customer_short_address'],
'customer_name' => $order_detail[0]['customer_name'],
'customer_mobile' => $order_detail[0]['customer_mobile'],
'customer_email' => $order_detail[0]['customer_email'],
'final_date' => $order_detail[0]['final_date'],
'total_amount' => $order_detail[0]['total_amount'],
'order_discount' => $order_detail[0]['order_discount'],
'service_charge' => $order_detail[0]['service_charge'],
'paid_amount' => $order_detail[0]['paid_amount'],
'due_amount' => $order_detail[0]['due_amount'],
'details' => $order_detail[0]['details'],
'subTotal_quantity' => $subTotal_quantity,
'order_all_data' => $order_detail,
'company_info' => $company_info,
'currency' => $currency_details[0]['currency_icon'],
'position' => $currency_details[0]['currency_position'],
);
$chapterList = $this->parser->parse('order/order_pdf',$data,true);
$this->load->library('pdfgenerator');
$file_path = $this->pdfgenerator->generate_order($order_id, $chapterList);
//File path save to database
$this->db->set('file_path', base_url($file_path));
$this->db->where('order_id', $order_id);
$this->db->update('order');
//pdf generate end
$this->session->set_userdata(array('message' => display('successfully_updated')));
redirect('dashboard/Corder/manage_order');
}
//Search Inovoice Item
public function search_inovoice_item()
{
$customer_id = $this->input->post('customer_id',TRUE);
$content = $this->lorder->search_inovoice_item($customer_id);
$this->template_lib->full_admin_html_view($content);
}
// order paid data
public function order_paid_data($order_id)
{
$order_id = $this->Orders->order_paid_data($order_id);
$this->session->set_userdata(array('message' => display('successfully_added')));
redirect('dashboard/Corder/manage_order');
}
// retrieve_product_data
public function retrieve_product_data()
{
$product_id = $this->input->post('product_id',TRUE);
$product_info = $this->Orders->get_total_product($product_id);
echo json_encode($product_info);
}
// product_delete
public function order_delete($order_id)
{
$this->permission->check_label('manage_order')->delete()->redirect();
$result = $this->Orders->delete_order($order_id);
if ($result) {
$this->session->set_userdata(array('message' => display('successfully_delete')));
}else{
$this->session->set_userdata(array('error_message' => display('failed_try_again')));
}
redirect('dashboard/Corder/manage_order');
}
//AJAX order STOCKs
public function product_stock_check($product_id)
{
$purchase_stocks = $this->Orders->get_total_purchase_item($product_id);
$total_purchase = 0;
if (!empty($purchase_stocks)) {
foreach ($purchase_stocks as $k => $v) {
$total_purchase = ($total_purchase + $purchase_stocks[$k]['quantity']);
}
}
$sales_stocks = $this->Orders->get_total_sales_item($product_id);
$total_sales = 0;
if (!empty($sales_stocks)) {
foreach ($sales_stocks as $k => $v) {
$total_sales = ($total_sales + $sales_stocks[$k]['quantity']);
}
}
$final_total = ($total_purchase - $total_sales);
return $final_total;
}
//Search product by product name and category
public function search_product()
{
$product_name = $this->input->post('product_name',TRUE);
$category_id = $this->input->post('category_id',TRUE);
$product_search = $this->Orders->product_search($product_name, $category_id);
if ($product_search) {
foreach ($product_search as $product) {
echo "<div class=\"col-xs-6 col-sm-4 col-md-2 col-p-3\">";
echo "<div class=\"panel panel-bd product-panel select_product\">";
echo "<div class=\"panel-body\">";
echo "<img src=\"$product->image_thumb\" class=\"img-responsive\" alt=\"\">";
echo "<input type=\"hidden\" name=\"select_product_id\" class=\"select_product_id\" value='" . $product->product_id . "'>";
echo "</div>";
echo "<div class=\"panel-footer\">$product->product_model - $product->product_name</div>";
echo "</div>";
echo "</div>";
}
} else {
echo "420";
}
}
//Insert new customer
public function insert_customer()
{
$customer_id = generator(15);
//Customer basic information adding.
$data = array(
'customer_id' => $customer_id,
'customer_name' => $this->input->post('customer_name',TRUE),
'customer_mobile' => $this->input->post('mobile',TRUE),
'customer_email' => $this->input->post('email',TRUE),
'status' => 1
);
$result = $this->Orders->customer_entry($data);
if ($result == TRUE) {
$this->session->set_userdata(array('message' => display('successfully_added')));
redirect(base_url('dashboard/Corder/pos_order'));
} else {
$this->session->set_userdata(array('error_message' => display('already_exists')));
redirect(base_url('dashboard/Corder/pos_order'));
}
}
//This function is used to Generate Key
public function generator($lenth)
{
$number = array("1", "2", "3", "4", "5", "6", "7", "8", "9");
for ($i = 0; $i < $lenth; $i++) {
$rand_value = rand(0, 8);
$rand_number = $number["$rand_value"];
if (empty($con)) {
$con = $rand_number;
} else {
$con = "$con" . "$rand_number";
}
}
return $con;
}
}