Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Order_old.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

require_once 'dompdf/autoload.inc.php';

/* reference the Dompdf namespace */

use Dompdf\Dompdf;

class Order extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Order_model'));
    $this->load->model(array('Customer_model'));
    $this->load->model(array('Workorder_model'));
    $this->load->model(array('Issueregister_model'));
    $this->load->model(array('Worklog_model'));
    $this->load->model(array('Deliverychallan_model'));
    $this->load->model(array('Invoice_model'));
    $this->load->model(array('Producttype_model'));
    $this->load->model(array('Application_model'));
    $this->load->model(array('Product_model'));
    $this->load->model(array('Deliverypermission_model'));
    $this->load->model(array('Reference_model'));
    $this->load->model(array('Paymentterm_model'));
    $this->load->model(array('Deliveryterm_model'));
    $this->load->model(array('Quotation_model'));
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Sale Order');
  }

function aes128Decrypt($key, $data) {
$data = base64_decode($data);
if(16 !== strlen($key)) $key = hash('MD5', $key, true);
$data = mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $data, MCRYPT_MODE_CBC, str_repeat("\0", 16));
$padding = ord($data[strlen($data) - 1]); 
return substr($data, 0, -$padding); 
}

public function index()
  { 
    $data['customer_list'] = $this->Order_model->get_customer_list();
    $data['application'] = $this->Order_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    //$data['location'] = $this->Order_model->get_location();

if($_SESSION['company_id']==0)
      $data['location'] = $this->Order_model->get_location();
    else
      $data['location'] = $this->Order_model->get_location_by_comp_id($_SESSION['company_id']);

/*$_SESSION['fin2cstart'] = $_SESSION['fin2ostart'];
    $_SESSION['fin2cend'] = $_SESSION['fin2oend'];*/
    //$data['order_list'] = $this->Order_model->get_order_list();
    if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      $typchange = $this->input->post('filterctype');
      //$catchange = $this->input->post('filterccat');
      $applichange = $this->input->post('filterappli');
      $refchange = $this->input->post('filterref');
      $locchange = $this->input->post('filterloc');
      $unitchange = $this->input->post('filterunit');

if($typchange!='')
        $ct = 'AND o.customer_id='.$typchange;
      else
        $ct = '';

if($applichange!='')
        $app = 'AND o.application_id='.$applichange;
      else
        $app = '';

if($refchange!='')
        $ref = 'AND o.reference_id='.$refchange;
      else
        $ref = '';

if($locchange!='')
        $loc = 'AND o.location_id='.$locchange;
      else
        $loc = '';

if($unitchange!='')
        $unit = 'AND o.prod_unit="'.$unitchange.'"';
      else
        $unit = '';

$btn = $this->input->post('goButton');
      $schange = $this->input->post('searchChange');
      //echo $schange;
      $dtrange = $this->input->post('dtrange');

//if($btn=='Go')
        //$schange='';
      /*if($btn=='')
        $dtrange='';*/

if($btn=='')
      {
        $dtrange='';
      }
      if($schange == '')
        $schange='';

$data['typchange'] = $typchange;
      $data['applichange'] = $applichange;
      $data['refchange'] = $refchange;
      $data['locchange'] = $locchange;
      $data['unitchange'] = $unitchange;
      //$data['catchange'] = $catchange;

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND o.created_by='.$_SESSION['user_id'];
          }
          else
          {
            $issu = '';
          }
        }
      }
      else
      {
        $compId = 'AND o.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND o.created_by='.$_SESSION['user_id'];
        }
        else
        {
          $issu = '';
        }
      }

if($schange == '')
      {
        /*$fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');*/
        
        if(isset($_SESSION['fin2cstart']))
        {
          if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
          {
            $fdate = $_SESSION['fin2cstart'].'-04-01';
            $tdate = $_SESSION['fin2cend'].'-03-31'; 
          }
          else
          {
            $fdate = date('Y-m-d', strtotime('-7 days'));
            $tdate = date('Y-m-d');
          }
        }
        else
        {
          $fdate = date('Y-m-d', strtotime('-7 days'));
          $tdate = date('Y-m-d');
        }

$data['drnge'] = '';
        $data['order_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_date>='$fdate' AND o.order_date<='$tdate' $ct $app $ref $loc $unit $compId $issu GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
      elseif($schange == 'today')
      {
        $data['order_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and STR_TO_DATE(order_date, '%Y-%m-%d') = CURDATE() GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
      else if($schange == 'thisweek')
      {
        $data['order_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and YEARWEEK(STR_TO_DATE(order_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }      
      else if($schange == 'thismonth')
      {
        $data['order_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and MONTH(STR_TO_DATE(order_date, '%Y-%m-%d')) = MONTH(CURDATE()) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
      else if($schange == 'thisyear')
      {
        //$data['order_list'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and YEAR(STR_TO_DATE(order_date, '%Y-%m-%d')) = YEAR(CURDATE()) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['order_list'] = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and  STR_TO_DATE(order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
      else
      {
        $data['drnge'] = $dtrange;
        $dr = explode(' - ', $dtrange);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $data['order_list'] = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and  STR_TO_DATE(order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
      //echo $schange;exit;
      $data['purchasesearch'] = $schange;
      $data['drnge'] = $dtrange;

if($this->input->post('top_fin_year')!='')
      {
        $topfin = explode('-', $this->input->post('top_fin_year'));
        $_SESSION['fin2cstart'] = $topfin[0];
        $_SESSION['fin2cend'] = $topfin[1];

if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31'; 
        }
        else
        {
          $fdate = date('Y-m-d', strtotime('-7 days'));
          $tdate = date('Y-m-d');
        }
        $data['order_list'] = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id $ct $app $ref $loc $unit $compId $issu and  STR_TO_DATE(order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
      }
    }
    else
    {
      if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31'; 
        }
        else
        {
          $fdate = date('Y-m-d', strtotime('-7 days'));
          $tdate = date('Y-m-d');
        }
      }
      else
      {
        $fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');
      }

$data['typchange'] = '';
      $data['applichange'] = '';
      $data['refchange'] = '';
      $data['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['locchange'] = '';
      $data['unitchange'] = '';
      //$data['catchange'] = '';
      //$data['order_list'] = $this->Order_model->get_order_list();

if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
          $data['order_list'] = $this->Order_model->get_order_list($fdate,$tdate);
        else
          $data['order_list'] = $this->Order_model->get_user_order_list($_SESSION['user_id'],$fdate,$tdate);
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        $data['order_list'] = $this->Order_model->get_user_order_list($_SESSION['user_id'],$fdate,$tdate);
      }
      else
      {
        $data['order_list'] = $this->Order_model->get_super_user_order_list($_SESSION['company_id'],$fdate,$tdate);
      }

}

//$data['overall_order'] = $this->Order_model->get_order_list();
    
      $fdate = date('Y-m-d', strtotime('-7 days'));
      $tdate = date('Y-m-d');

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        $data['overall_order'] = $this->Order_model->get_order_list($fdate,$tdate);
      else
        $data['overall_order'] = $this->Order_model->get_user_order_list($_SESSION['user_id'],$fdate,$tdate);
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['overall_order'] = $this->Order_model->get_user_order_list($_SESSION['user_id'],$fdate,$tdate);
    }
    else
    {
      $data['overall_order'] = $this->Order_model->get_super_user_order_list($_SESSION['company_id'],$fdate,$tdate);
    }
    
    $this->load->view('order/order_list',$data);
  }

// To get source base on leads
  public function location_based_order_count()
  {
    
    $lead_type_baseds = $this->Order_model->location_based_order_count();  
    $lead_type_count  = count($lead_type_baseds) ;
    $res = array();
    foreach ($lead_type_baseds as $key => $lead_type_based) {

$key = $key+1;
      if($key  != $lead_type_count){

$option = array('label' => $lead_type_based->label,'value' => $lead_type_based->lvalue);
      }else{
        $option = array('label' => $lead_type_based->label,'value' => $lead_type_based->lvalue);
      }

array_push($res, $option);

}
    echo json_encode( $res);
  }

public function order_add()
  {
    $data['customer_list'] = $this->Order_model->get_customer_list();
    //$data['location_list'] = $this->Order_model->get_location();
    $data['uom_list'] = $this->Order_model->get_uom_list();
    $data['product_list'] = $this->Order_model->get_product_list();
    $data['payment_term'] = $this->Order_model->get_so_payment_term();
    $data['delivery_term'] = $this->Order_model->get_so_delivery_term();
    $data['product_type'] = $this->Order_model->get_product_type();
    $data['delivery_permission'] = $this->Order_model->get_delivery_permission();
    $data['application'] = $this->Order_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    $data['state_list'] = $this->Order_model->get_state_list();
    $data['whatsapp_configuration'] = general_setting_details();

if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Order_model->get_location();
    else
      $data['location_list'] = $this->Order_model->get_location_by_comp_id($_SESSION['company_id']);

$this->load->view('order/order_add',$data);
  }

public function unique_email()
  {
    $val = $_POST['value'];
    $result = $this->Order_model->customer_unique_email($val);
    echo count($result);
  }

public function phone_no_unique()
  {
    $val = $_POST['value'];
    $result = $this->Order_model->customer_phone_no_unique($val);
    echo count($result);
  }

/*public function getCustomerCountry()
  {
    $did = $_POST['did'];
    $customer_list = $this->Order_model->get_customer_view_by_id($did);
    echo $customer_list->state_id;
  }*/

public function getCustomerCountry()
  {
    $did = $_POST['did'];
    //$customer_list = $this->Order_model->get_customer_view_by_id($did);
    //echo $customer_list->state_id;
    $billing_address = $this->Order_model->get_customer_billing_address_by_id($did);
    $shipping_address = $this->Order_model->get_customer_shipping_address_by_id($did);

if(count($billing_address)>0)
    {
      $ba = '<option value="">Select Billing Address</option>';
      foreach ($billing_address as $baddress) {
          $ba.='<option value='.$baddress["customer_address_id"].'>'.$baddress["address"].' - '.$baddress["state"].' - '.$baddress["address_pincode"].'</option>';
      }
    }
    else
    {
      $ba = '<option value="">No Address Available</option>';
    }

if(count($shipping_address)>0)
    {
      $sa = '<option value="">Select Shipping Address</option>';
      foreach ($shipping_address as $saddress) {
          $sa.='<option value='.$saddress["customer_address_id"].'>'.$saddress["address"].' - '.$saddress["state"].' - '.$saddress["address_pincode"].'</option>';
      }
    }
    else
    {
      $sa = '<option value="">No Address Available</option>';
    }

echo $ba."|".$sa;
  }

public function getDealerCountry()
  {
    $did = $_POST['did'];
    //$customer_list = $this->Order_model->get_customer_view_by_id($did);
    //echo $customer_list->state_id;
    $billing_address = $this->Order_model->get_dealer_billing_address_by_id($did);
    $shipping_address = $this->Order_model->get_dealer_shipping_address_by_id($did);

if(count($billing_address)>0)
    {
      $ba = '<option value="">Select Billing Address</option>';
      foreach ($billing_address as $baddress) {
          $ba.='<option value='.$baddress["dealer_address_id"].'>'.$baddress["address"].' - '.$baddress["state"].' - '.$baddress["address_pincode"].'</option>';
      }
    }
    else
    {
      $ba = '<option value="">No Address Available</option>';
    }

if(count($shipping_address)>0)
    {
      $sa = '<option value="">Select Shipping Address</option>';
      foreach ($shipping_address as $saddress) {
          $sa.='<option value='.$saddress["dealer_address_id"].'>'.$saddress["address"].' - '.$saddress["state"].' - '.$saddress["address_pincode"].'</option>';
      }
    }
    else
    {
      $sa = '<option value="">No Address Available</option>';
    }

echo $ba."|".$sa;
  }

public function getProduct()
  {
    $pt_id = $_POST['id'];
    $locId = $_POST['locId'];
    $punit = $_POST['punit'];
    $product = $this->Order_model->get_product_by_product_type_unit_location_id($pt_id,$locId,$punit);
    if(count($product)>0)
    {
      $st = '<option value="">Select Product</option>';
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'>'.$prod["product_code"].' - '.$prod["product_name"].'</option>';
      }
    }
    else
    {
      $st = '<option value="">No Products Available</option>';
    }
    echo $st;
  }

public function getPriceFormula()
  {
    $uom_id = $_POST['uom_id'];
    $result = $this->Order_model->get_price_formula_by_uom_id($uom_id);
    echo $result->price_formula_id;
  }

public function getProductDetails()
  {
    $prod_id = $_POST['prod_id'];
    //$location = $_POST['location'];
    $product = $this->Order_model->get_product_details_by_id($prod_id);
    /*if($product->type_id==1)
    {
      if($location!='')
      {
        $locproduct = $this->Order_model->get_pstock_by_locid_prodid($location,$prod_id);
        if(count($locproduct)>0)
        {
          echo $product->uom."|".$product->uom_id."|".$product->unit_price."|".$product->price_formula."|".$product->type_id."|".$product->gst."|".$product->is_purchase;
        }
        else
        {
          echo '0';
        }
      }
      else
      {
        echo '1';
      }
    }
    else
    {*/
      //echo $product->uom."|".$product->uom_id."|".$product->unit_price."|".$product->price_formula."|".$product->type_id."|".$product->gst."|".$product->is_purchase;
      echo "0|0|".$product->unit_price."|".$product->price_formula."|".$product->type_id."|".$product->gst."|".$product->is_purchase;
    //}
  }

public function getProductRate()
  {
    //$pf_id = $_POST['pf_id'];
    $csl = $_POST['csl'];
    $csw = $_POST['csw'];
    $csh = $_POST['csh'];
    $rpsf = $_POST['rpsf'];
    $qty = $_POST['qty'];
    $prod = $_POST['prod'];
    $uom_id = $_POST['uom_id'];

if($csl!=0 && $csw!=0)
    {
      /*if($pf_id==3)
      {
        $price = (($csl*$csw)/144)*$rpsf;
      }
      else
      {
        $price = $csl*$csw*$rpsf;
      }
      $rate = $price*$qty;*/
      $ppw = $this->Quotation_model->get_product_price_weight_by_prod_uom_id($prod,$uom_id);
      if(count($ppw)>0)
      {
        $price = $ppw->price;
        $price = str_replace('X', '*', $price);
        $price = str_replace('L', $csl, $price);
        $price = str_replace('W', $csw, $price);
        $price = str_replace('RATE/SQ.FT', $rpsf, $price);
        $price = str_replace('RATE/SQ.MTR', $rpsf, $price);
        $price = str_replace('RATE/SQ.FT', $rpsf, $price);
        eval( '$price = (' . $price. ');' );
        //$qty = floatval($qty);
        //$price = floatval($price);
        $rate = $price*$qty;
      }
      else
      {
        $rate = $rpsf*$qty;
      }
    }
    else
    {
      $rate = $rpsf*$qty;
    }
    echo $rate;
  }

public function create_order()
  {
    $whatsapp_configuration = general_setting_details();
    $printQtn = $this->input->post('print_quotation');
    $emailQtn = $this->input->post('mail_quotation');
    $smsQtn = $this->input->post('sms_quotation');
    //$wapQtn = $this->input->post('whatsapp_quotation');
    if($whatsapp_configuration->is_whatsapp_enable==1)
      $wapQtn = $this->input->post('whatsapp_quotation');
    else
      $wapQtn = 0;
    $punit = $ord['prod_unit'] = $this->input->post('prod_unit');
    //$last_id_value = $this->Order_model->last_order_id();
    $last_id_value = $this->Order_model->last_order_id_by_unit($punit);
    /*if(count($last_id_value)==0)
      $last_value = 0;
    else
    {
      $last_value = $last_id_value->order_id;
    }
    $next_value = $last_value + 1;
    $order_no = $next_value;
    $ord['order_no'] = 'ORD-'.$order_no;*/

if(count($last_id_value)==0)
    {
      if($punit=='unit1')
        $ono = $ord['order_no'] = date("Y").'/'.date('m').'/U1/SO001';
      else
        $ono = $ord['order_no'] = date("Y").'/'.date('m').'/U2/SO001';
    }
    else
    {
      $lno = $last_id_value->order_no;
      $exlno = substr($lno,13);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      //$ono = $ord['order_no'] = date("Y").'/'.date('m').'/SO'.$nval;
      if($punit=='unit1')
        $ono = $ord['order_no'] = date("Y").'/'.date('m').'/U1/SO'.$nval;
      else
        $ono = $ord['order_no'] = date("Y").'/'.date('m').'/U2/SO'.$nval;
    }

//$customer_type=$this->input->post('customer_t');
    //if($customer_type=='Existing')
    //{
      $ord['customer_id'] = $this->input->post('customer_id');
      $ord['dealer_id'] = 0;      
      $odt = explode('/', $this->input->post('order_date'));
      $ord['order_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      /*$ddt = explode('/', $this->input->post('del_date'));
      $ord['del_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];*/ 
      $ord['del_date'] = $this->input->post('del_date');     
      $locId = $ord['location_id'] = $this->input->post('location_id');
    /*}
    else
    {
      $last_id_value = $this->Customer_model->last_id();
      if(count($last_id_value)==0)
        $last_value = 0;
      else
        $last_value=$last_id_value->count_val;
      $next_value = $last_value + 1;
      $customer_id = $next_value;
      $data['customer_code'] = 'CUS-'.$customer_id;

$data['customer_name'] = $this->input->post('customer_name');
      $data['customer_type'] = 1;
      $data['customer_category'] = 1;
      $data['pan_no'] = '';
      $data['gst_no'] = '';
      $data['address'] = '';
      $data['website'] = '';
      $data['bank_name'] = '';
      $data['branch_name'] = '';
      $data['account_no'] = '';
      $data['payment_term'] = 0;

$data['intrested_products'] = '';

$data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];
      
      $result = $this->Customer_model->create_customer($data);
      if ($result) {
        $last_id_value = $this->Customer_model->last_id();
        $last_value=$last_id_value->count_val;
        $customer_id = $last_value;

$data2['customer_id'] = $customer_id;
        $data2['phone_type_id'] = 1;
        $data2['phone_no'] = $this->input->post('contact_no');
        $this->Customer_model->create_customer_phone($data2);

$data1['customer_id'] = $customer_id;
        $data1['email_type_id'] = 1;
        $data1['email_id'] = $this->input->post('email_id');
        $this->Customer_model->create_customer_email($data1);

$data3['customer_id'] = $customer_id;
        $data3['address_type_id'] = 1;
        $data3['address'] = $this->input->post('address');
        $this->Customer_model->create_customer_address($data3);
      }

$ord['customer_id'] = $customer_id;      
      $odt = explode('/', $this->input->post('order_date_new'));
      $ord['order_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $ddt = explode('/', $this->input->post('order_date_new'));
      $ord['del_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
      $locId = $ord['location_id'] = $this->input->post('location_id_new');
    }*/
    $ord['created_on'] = date('Y-m-d H:i:s');
    $ord['created_by'] = $_SESSION['user_id'];
    $ord['taxable_amount'] = $this->input->post('taxable_amount');
    $ord['total_tax'] = $this->input->post('total_tax');
    $ord['round_off'] = $this->input->post('round_off');
    $ord['grand_total'] = $this->input->post('grand_total');
    $ord['payment_term_id'] = $this->input->post('payment_term_id');
    $ord['delivery_term_id'] = $this->input->post('delivery_term_id');
    $ord['transport'] = $this->input->post('transport');
    $ord['booking_place'] = $this->input->post('booking_place');
    $ord['incharge'] = $this->input->post('incharge');
    $ord['advance_amount'] = $this->input->post('advance_amount');
    $ord['balance_amount'] = $this->input->post('balance_amount');
    $ord['product_type_id'] = $this->input->post('product_type');
    $ord['quotation_id'] = 0;
    $ord['delivery_permission_id'] = $this->input->post('delivery_permission_id');
    $ord['application_id'] = $this->input->post('application_id');
    $ord['reference_id'] = $this->input->post('reference_id');
    $ord['supply_from'] = $this->input->post('supply_from');
    //$ord['supply_to'] = $this->input->post('supply_to');
    $ord['supply_to'] = 0;
    $ord['packing_charges'] = $this->input->post('packing_charges');
    $ord['other_charges'] = $this->input->post('other_charges');
    $ord['remarks'] = $this->input->post('remarks');
    $ord['eyelets'] = $this->input->post('eyelets');
    $ord['delivery_type'] = $this->input->post('delivery_type');
    $ord['customer_billing_address_id'] = $this->input->post('customer_billing_address_id');
    $ord['customer_shipping_address_id'] = $this->input->post('customer_shipping_address_id');

$iscpo = $ord['is_customer_po'] = $this->input->post('is_customer_po');
    if($iscpo==1)
    {
      $rmnorep = str_replace('/', '-', $ono);
      $ord['customer_po_no'] = $this->input->post('customer_po_no');

if(!empty($_FILES['customer_po_bill']['name']))
      {
        $ext = pathinfo($_FILES['customer_po_bill']['name'], PATHINFO_EXTENSION);
        $config['upload_path'] = 'customerpobill';
        $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
        $config['file_name'] = $rmnorep;
        $profileName = $config['file_name'].'.'.$ext;
        $this->load->library('upload',$config);
        $this->upload->initialize($config);
        if($this->upload->do_upload('customer_po_bill'))
        {
          $uploadData = $this->upload->data();
          $ord['customer_po_bill'] = $profileName;
        }
        else
        {
          $ord['customer_po_bill'] = '';
        }
      }
      else
      {
        $ord['customer_po_bill'] = '';
      }
    }
    else
    {
      $ord['customer_po_no'] = '';
      $ord['customer_po_bill'] = '';
    }

$result = $this->Order_model->create_order($ord);

if ($result) {
      $last_id_value = $this->Order_model->last_order_id();
      $last_value=$last_id_value->order_id;
      $ordprod['order_id'] = $last_value;

$pid = explode(",",implode(",",$this->input->post('product_id')));
      $uid = explode(",",implode(",",$this->input->post('uom_id')));
      $ptid = explode(",",implode(",",$this->input->post('product_type_id')));
      $pfid = explode(",",implode(",",$this->input->post('price_formula_id')));
      $pgst = explode(",",implode(",",$this->input->post('product_gst')));
      $csl = explode(",",implode(",",$this->input->post('cut_size_length')));
      $csw = explode(",",implode(",",$this->input->post('cut_size_width')));
      //$csh = explode(",",implode(",",$this->input->post('cut_size_height')));
      $fsl = explode(",",implode(",",$this->input->post('finish_size_length')));
      $fsw = explode(",",implode(",",$this->input->post('finish_size_width')));
      //$fsh = explode(",",implode(",",$this->input->post('finish_size_height')));
      $rpsq = explode(",",implode(",",$this->input->post('rate_per_sqft')));
      $qty = explode(",",implode(",",$this->input->post('quantity')));
      $rate = explode(",",implode(",",$this->input->post('rate')));
      $disc = explode(",",implode(",",$this->input->post('disc')));
      $amt = explode(",",implode(",",$this->input->post('amount')));
      $subcount = count($this->input->post('product_id')); 
      for($i=0;$i<$subcount;$i++)
      {
        if($pid[$i] != ''){
          $ordprod['product_id'] = $pid[$i];
          $ordprod['uom_id'] = $uid[$i];
          $ordprod['product_type_id'] = $ptid[$i];
          $ordprod['product_gst'] = $pgst[$i];
          $ordprod['price_formula_id'] = $pfid[$i];
          $ordprod['cut_size_length'] = $csl[$i];
          $ordprod['cut_size_width'] = $csw[$i];
          $ordprod['cut_size_height'] = 0;
          $ordprod['finish_size_length'] = $fsl[$i];
          $ordprod['finish_size_width'] = $fsw[$i];
          $ordprod['finish_size_height'] = 0;
          $ordprod['rate_per_sqft'] = $rpsq[$i];
          $ordprod['quantity'] = $qty[$i];
          $ordprod['rate'] = $rate[$i];
          $ordprod['disc'] = $disc[$i];
          $ordprod['amount'] = $amt[$i];

if($ptid[$i]==1)
          {
            /*$locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$pid[$i]);
            if(count($locproduct)>0)
            {
              $lpqty = $locproduct[0]['stock'];
              $dedstock = $lpqty - $qty[$i];

$bqty = $locproduct[0]['booked'];

if($dedstock<0)
              {
                $bookstock = $bqty+$lpqty;
                $bstock = $lpqty;
                $npqty = $locproduct[0]['need_production'];
                $npur = $npqty+abs($dedstock);
                $np = abs($dedstock);
                $dedstock = 0;
              }
              else
              {
                $bookstock = $bqty+$qty[$i];
                $bstock = $qty[$i];
                $npur=0;
                $np=0;
              }
              $dstock = $this->Order_model->update_pstock_by_locid_prodid($locId,$pid[$i],$dedstock,$bookstock,$npur);
            }
            else
            {
              $dedstock=0;
              $bookstock=0;
              $bstock=0;
              $npur=$qty[$i];
              $np = $qty[$i];
              $created_on = date('Y-m-d H:i:s');
              $created_by = $_SESSION['user_id'];
              $this->Order_model->add_pstock_by_locid_prodid($locId,$pid[$i],$dedstock,$bookstock,$npur,$created_on,$created_by);
            }
            $ordprod['booked'] = $bstock;
            $ordprod['need_production'] = $np;*/

$ordprod['booked'] = 0;
            $ordprod['need_production'] = 0;
          }
          else
          {
            $ordprod['booked'] = 0;
            $ordprod['need_production'] = 0;
          }

$this->Order_model->create_order_product($ordprod);
        }
      }

$pdata['general_setting'] = $general_setting = $this->Order_model->get_general_settings_details();
      $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($last_value);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$cusemail = $this->Order_model->get_customer_email_by_id($cus_id);
      $cname = $order_list->customer_name;
      if(count($cusemail)>0)
      {
        $cemail = $cusemail->email;
      }
      else
      {
        $cemail = '';
      }

$order_product_list = $pdata['order_product_list'] = $this->Order_model->get_order_product_by_id($last_value);
      $tc = $pdata['terms_and_conditions'] = $this->Order_model->get_order_terms_and_conditions();

$html = '';

$html.='<html>
<head>
<style>
table > thead > tr > th {vertical-align: middle; font-size:12px;}
table > tbody > tr > td {vertical-align: middle; font-size:10px;}
</style>
</head>
          <body style="border:1px solid black;float:left;width:100%;padding:10px;">
            <div style="width:100%;float:left;">
              <img src="assets/images/product_logo/arjun_header.jpg" style="height:100%;width:100%;float:left;">
            </div>
                     
            <div style="clear:both!important;"></div>
            <div style="width:100%;float:right;">
              <p style="text-align:right;margin-bottom:0px!important;">SALE ORDER</p>
            </div>
                     
            <div style="clear:both!important;"></div>
            <hr style="border-bottom:1px solid #000;float:left;width:100%;">
            <div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
                <div style="width:50%;float:left;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                    <table style="width:100%;">
                        <tr>
                            <td style="width:100%;"><b>Billed To</b></td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$order_list->customer_name.'</td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$badd.'</td>
                        </tr>
                        <tr>
                            <td style="width:100%;"></td>
                        </tr>                        
                        <tr>
                            <td style="width:100%;"><b>Shipped To</b></td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$order_list->customer_name.'</td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$sadd.'</td>
                        </tr>
                    </table>
                </div>';
                $odate = date_format(date_create($order_list->order_date),'d M Y'); 
                $delper = $this->Order_model->get_deliverypermission_by_id($order_list->delivery_permission_id);
                $delpermission = $delper->delivery_permission;
                $html.='<div style="width:40%;float:right;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                    <table style="width:100%;">
                        <tr>
                            <td style="width:30%;"><b>SO No</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$order_list->order_no.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>SO Date</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$odate.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Delivery Permission</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$delpermission.'</td>
                        </tr>
                    </table>
                </div>
            </div>
            <div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
                <table border="1" cellpadding="5" style="width:100%;border-collapse:collapse;">
                  <thead>
                  <tr>
                      <th>S.No</th>
                      <th>HSN</th>
                      <th>Description</th>
                      <th>Qty</th>
                      <th>Unit Price ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                      <th>Disc %</th>
                      <th>Taxable Value ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                      <th>SGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                      <th>CGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                      <th>Total Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                  </tr></thead><tbody>';
                  $taxamt=0;$tottax=0;$i=1;foreach($order_product_list as $oprod){
                    $sgst = str_replace(',', '', number_format($oprod['amount']*$oprod['gst']/100, 2));
                    $cgst = str_replace(',', '', number_format($oprod['amount']*$oprod['gst']/100, 2));
                    $totamt = number_format($oprod['amount']+$sgst+$cgst, 2);
                  $html.='
                  <tr>
                    <td>'.$i.'</td>
                    <td>'.$oprod['hsn_code'].'</td>
                    <td>'.$oprod['product_name'].'</td>
                    <td>'.$oprod['quantity'].'</td>
                    <td>'.$oprod['rate']/$oprod['quantity'].'</td>
                    <td>'.$oprod['disc'].'</td>
                    <td>'.$oprod['amount'].'</td>
                    <td><table><tr><td>'.$sgst.'</td></tr></table><table><tr><td>@'.number_format($oprod['gst'], 2).'%</td></tr></table></td>
                    <td><table><tr><td>'.$cgst.'</td></tr></table><table><tr><td>@'.number_format($oprod['gst'], 2).'%</td></tr></table></td>
                    <td>'.$totamt.'</td>
                  </tr>';
                  $taxamt+=$oprod['amount'];$tottax+=$sgst+$cgst;$i++;}
                  $html.='</tbody>
                </table>
            </div>
            <div style="clear:both!important;"></div>';

$sumamt = $taxamt+$tottax;
            $rnd = round($sumamt);
            $rofval = round($rnd-$sumamt,2);
            if($order_list->payment_term_id!=0)
            {
              $ptem = $this->Order_model->get_patyment_term_by_id($order_list->payment_term_id);
              $payterm = $ptem->payment_term;
            }
            else
            {
              $payterm = '-';
            }
            if($order_list->delivery_term_id!=0)
            {
              $dtem = $this->Order_model->get_delivery_term_by_id($order_list->delivery_term_id);
              $delterm = $dtem->delivery_term;
            }
            else
            {
              $delterm = '-';
            }
            $html.='<div style="width:100%;float:left;margin-bottom:15px;">

<div style="width:40%;float:right;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                    <table style="width:100%;">
                        <tr>
                            <td style="width:40%;"><b>Taxable Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($taxamt, 2).'</td>
                        </tr>
                        <tr>
                            <td style="width:40%;"><b>CGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($tottax/2, 2).'</td>
                        </tr>
                        <tr>
                            <td style="width:40%;"><b>SGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($tottax/2, 2).'</td>
                        </tr>
                        <tr>
                            <td style="width:40%;"><b>Round Off ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.$rofval.'</td>
                        </tr>
                        <tr>
                            <td style="width:40%;"><b>Grand Total ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($rnd, 2).'</td>
                        </tr>
                    </table>
                </div>
            </div>

<div style="width:100%;float:left;margin-bottom:15px;">
              <table style="width:100%;">
                <tr>
                    <td style="width:20%;"><b>Tax Amount (in words)</b></td>
                    <td style="width:2%;">:</td>
                    <td style="width:78%;">'.$this->convertToIndianCurrency(str_replace(',', '', number_format($tottax, 2))).'</td>
                </tr>
                <tr>
                    <td style="width:20%;"><b>Grand Total (in words)</b></td>
                    <td style="width:2%;">:</td>
                    <td style="width:78%;">'.$this->convertToIndianCurrency(str_replace(',', '', number_format($rnd, 2))).'</td>
                </tr>
              </table>
            </div>';

if(count($tc)>0){

$html.='<div style="clear:both!important;"></div>
            
            <div style="width:100%;float:left;margin-bottom:15px;">
              <table style="width:100%;">
                <tr>
                    <td>'.$tc->terms_and_conditions.'</td>
                </tr>
              </table>
            </div>';
          }

$html.='<div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
              <div style="float:right;padding:10px;">
                <p style="font-size:13px;">For <b>Arjun Agri & Bio Energy Private Limited,</b></p>
                <br>
                <p style="font-size:13px;">Authorized Signatory</p>
              </div>
            </div>';

$html.='</body></html>';
$data['html'] = $html;

$html = preg_replace('/>\s+</', "><", $html);
$dompdf = new DOMPDF();
$dompdf->load_html($html);
$dompdf->set_paper('A4','portrait');
$dompdf->render();
$output = $dompdf->output();
$rmnorep = str_replace('/', '-', $order_list->order_no);
file_put_contents("pdfsalesorder/".$rmnorep.".pdf", $output);

if($smsQtn==1)
{
  $genset = $this->Order_model->get_general_settings_details();
  $nlcontent = $this->Order_model->get_new_order_msg();
  $content = $nlcontent->sms_content;
  $content = str_replace('#name#', ucwords($cname), $content);
  $content = str_replace('#orderId#', $order_list->order_no, $content);
  $content = str_replace('#orderDate#', $odate, $content);
  $content = str_replace('#orderAmount#', number_format($rnd, 2), $content);
  sendsms($cphone,$content,$genset->sms_auth_key,$genset->sms_sender_id);
}

if($wapQtn==1)
{
  $genset = $this->Order_model->get_general_settings_details();
  $wpcontent = $this->Order_model->get_new_order_whatsappmsg();
  $wapcontent = $wpcontent->whatsapp_content;
  $wapcontent = str_replace('#name#', ucwords($cname), $wapcontent);
  $wapcontent = str_replace('#orderId#', $order_list->order_no, $wapcontent);
  $wapcontent = str_replace('#orderDate#', $odate, $wapcontent);
  $wapcontent = str_replace('#orderAmount#', number_format($rnd, 2), $wapcontent);

$wmsg = [
      'phone' => '91'.$cphone, // Receivers phone
      'body' => $wapcontent, // Message
  ];
  //print_r($wmsg);exit;
  $json = json_encode($wmsg); // Encode data to JSON
  // URL for request POST /message
  $url = $genset->whatsapp_api_key;
  // Make a POST request
  $options = stream_context_create(['http' => [
          'method'  => 'POST',
          'header'  => 'Content-type: application/json',
          'content' => $json
      ]
  ]);
  // Send a request
  $result = file_get_contents($url, false, $options);
}

if($emailQtn==1)
{
  if($cemail!='')
  {
    $rmnorep = str_replace('/', '-', $order_list->order_no);
    $attched_file= site_url()."pdfsalesorder/".$rmnorep.".pdf";
    $mcRes = $this->Order_model->get_general_settings_details();

$smtp_pwd = $this->aes128Decrypt('arjunerp', $mcRes->smtp_password);   
    $config = Array( 
    'protocol' => 'smtp',
    'smtp_host' => $mcRes->smtp_host_name,
    'smtp_user' => $mcRes->smtp_user_name, 
    'smtp_pass' => $smtp_pwd,
    'smtp_port' => 587,
    'mailtype'  => 'html', 
    'charset'   => 'utf-8',
    'newline'  => "\r\n",
    'wordwrap' => TRUE,
    );
     $et = $this->Order_model->order_mail_template();
            $subject = $et->email_subject;
            $content = $et->email_content;

$content = str_replace('#displayName#',ucfirst($cname), $content);
            $content = str_replace('#year#', date('Y'), $content);
            $content = str_replace('#productLogo#', $mcRes->product_logo, $content);
            $content = str_replace('#baseurl#', base_url(), $content);
            $content = str_replace('#orderId#', $order_list->order_no, $content);
            $content = str_replace('#orderDate#', $odate, $content);
            $content = str_replace('#orderAmount#', number_format($rnd, 2), $content);
            $this->load->library('email',$config);
            $this->email->initialize($config);
            $this->email->from($mcRes->from_mail);          
            $this->email->to($cemail);
            $this->email->subject($subject);
            $this->email->message($content);
            $this->email->attach($attched_file);
    if($this->email->send())
    {
       //echo "Your Password has been sent to your email id";
    }else{
      //echo "error";
     //echo $this->email->print_debugger();
     //die();
     //echo "Your Password has been sent to your email id";
    }
  }
}

public function convertToIndianCurrency($number) {
    $no = round($number);
    $decimal = round($number - ($no = floor($number)), 2) * 100;    
    $digits_length = strlen($no);    
    $i = 0;
    $str = array();
    $words = array(
        0 => '',
        1 => 'One',
        2 => 'Two',
        3 => 'Three',
        4 => 'Four',
        5 => 'Five',
        6 => 'Six',
        7 => 'Seven',
        8 => 'Eight',
        9 => 'Nine',
        10 => 'Ten',
        11 => 'Eleven',
        12 => 'Twelve',
        13 => 'Thirteen',
        14 => 'Fourteen',
        15 => 'Fifteen',
        16 => 'Sixteen',
        17 => 'Seventeen',
        18 => 'Eighteen',
        19 => 'Nineteen',
        20 => 'Twenty',
        30 => 'Thirty',
        40 => 'Forty',
        50 => 'Fifty',
        60 => 'Sixty',
        70 => 'Seventy',
        80 => 'Eighty',
        90 => 'Ninety');
    $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
    while ($i < $digits_length) {
        $divider = ($i == 2) ? 10 : 100;
        $number = floor($no % $divider);
        $no = floor($no / $divider);
        $i += $divider == 10 ? 1 : 2;
        if ($number) {
            $plural = (($counter = count($str)) && $number > 9) ? 's' : null;            
            $str [] = ($number < 21) ? $words[$number] . ' ' . $digits[$counter] . $plural : $words[floor($number / 10) * 10] . ' ' . $words[$number % 10] . ' ' . $digits[$counter] . $plural;
        } else {
            $str [] = null;
        }  
    }
    
    $Rupees = implode(' ', array_reverse($str));
    $paise = ($decimal) ? "And Paise " . ($words[$decimal - $decimal%10]) ." " .($words[$decimal%10])  : '';
    return ($Rupees ? 'Rupees ' . $Rupees : '') . $paise . " Only";
}

public function order_view($id)
  {
    $olist = $this->Order_model->get_order_by_id($id);
    if($olist->customer_id!=0)
      $data['order_list'] = $this->Order_model->get_order_view_by_id($id);
    else
      $data['order_list'] = $this->Order_model->get_dealer_order_view_by_id($id);
    $data['order_product_list'] = $this->Order_model->get_order_product_by_id($id);
    $data['payment_history'] = $this->Order_model->get_payment_history_by_order_id($id);
    $this->load->view('order/order_view',$data);
  }

public function order_print($id)
  {
    $pdata['general_setting'] = $general_setting = $this->Order_model->get_general_settings_details();

$tc = $pdata['terms_and_conditions'] = $this->Order_model->get_order_terms_and_conditions();
      /*$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($id);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);*/

$olist = $this->Order_model->get_order_by_id($id);
      if($olist->customer_id!=0)
      {
        $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($id);
        $cus_id = $order_list->customer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);
      }
      else
      {
        $order_list = $pdata['order_list'] = $this->Order_model->get_dealer_order_view_by_id($id);
        $cus_id = $order_list->dealer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_dealer_address_by_dealer_id($cus_id);
      }

$badd='';
      $sadd = '';
      if($order_list->customer_billing_address_id==0)
      {
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }
      }
      else
      {
        if($olist->customer_id!=0)
        {
          $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
          $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
        }
        else
        {
          $baddress = $this->Order_model->get_dealer_address_by_id($order_list->customer_billing_address_id);
          $saddress = $this->Order_model->get_dealer_address_by_id($order_list->customer_shipping_address_id);
        }
        $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
        $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
        $pdata['stid'] = $baddress->address_state_id;
      }

$order_product_list = $pdata['order_product_list'] = $this->Order_model->get_order_product_by_id($id);

$this->load->view('order/printview',$pdata);
  }

public function order_edit($id)
  {
    $data['customer_list'] = $this->Order_model->get_customer_list();
    $data['dealer_list'] = $this->Order_model->get_dealer_list();
    //$data['location_list'] = $this->Order_model->get_location();
    $data['uom_list'] = $this->Order_model->get_uom_list();
    //$order_list = $data['order_list'] = $this->Order_model->get_order_view_by_id($id);

$data['olist'] = $olist = $this->Order_model->get_order_by_id($id);
    if($olist->customer_id!=0)
      $order_list = $data['order_list'] = $this->Order_model->get_order_view_by_id($id);
    else
      $order_list = $data['order_list'] = $this->Order_model->get_dealer_order_view_by_id($id);

$data['order_product_list'] = $this->Order_model->get_order_product_by_id($id);
    //$data['location_product'] = $this->Order_model->get_product_by_location_id($order_list->location_id);    
    //$data['product_list'] = $this->Order_model->get_product_list();
    $data['payment_term'] = $this->Order_model->get_so_payment_term();
    $data['delivery_term'] = $this->Order_model->get_so_delivery_term();
    $data['delivery_permission'] = $this->Order_model->get_delivery_permission();
    $data['product_type'] = $this->Order_model->get_product_type();
    $data['application'] = $this->Order_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    $data['state_list'] = $this->Order_model->get_state_list();
    $data['whatsapp_configuration'] = general_setting_details();
    
    if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Order_model->get_location();
    else
      $data['location_list'] = $this->Order_model->get_location_by_comp_id($_SESSION['company_id']);
    
    $product = $data['product_list'] = $this->Order_model->get_product_by_product_type_location_id($order_list->product_type_id,$order_list->location_id);
    if(count($product)>0)
    {
      $st = "<option value=''>Select Product</option>";
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'>'.$prod["product_code"].' - '.str_replace('"', '\'\'', $prod["product_name"]).'</option>';
      }
    }
    $data['st'] = $st;
//echo $st;exit;
    $this->load->view('order/order_edit',$data);
  }

public function update_order()
  {    
    $order_id = $this->input->post('order_id');
    $olist = $this->Order_model->get_order_by_id($order_id);

if($olist->status==0)
    {
      $whatsapp_configuration = general_setting_details();
      //$order_id = $this->input->post('order_id');
      $printQtn = $this->input->post('print_quotation');
      $emailQtn = $this->input->post('mail_quotation');
      $smsQtn = $this->input->post('sms_quotation');
      //$wapQtn = $this->input->post('whatsapp_quotation');
      if($whatsapp_configuration->is_whatsapp_enable==1)
        $wapQtn = $this->input->post('whatsapp_quotation');
      else
        $wapQtn = 0;
      $ord['customer_id'] = $this->input->post('customer_id');      
      $odt = explode('/', $this->input->post('order_date'));
      $ord['order_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      /*$ddt = explode('/', $this->input->post('del_date'));
      $ord['del_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];*/ 
      $ord['del_date'] = $this->input->post('del_date');     
      $locId = $ord['location_id'] = $this->input->post('location_id');
      $ord['modified_on'] = date('Y-m-d H:i:s');
      $ord['modified_by'] = $_SESSION['user_id'];
      $ord['taxable_amount'] = $this->input->post('taxable_amount');
      $ord['total_tax'] = $this->input->post('total_tax');
      $ord['round_off'] = $this->input->post('round_off');
      $ord['grand_total'] = $this->input->post('grand_total');
      $ord['payment_term_id'] = $this->input->post('payment_term_id');
      $ord['delivery_term_id'] = $this->input->post('delivery_term_id');
      $ord['transport'] = $this->input->post('transport');
      $ord['booking_place'] = $this->input->post('booking_place');
      $ord['incharge'] = $this->input->post('incharge');
      $ord['advance_amount'] = $this->input->post('advance_amount');
      $ord['balance_amount'] = $this->input->post('balance_amount');
      $ord['product_type_id'] = $this->input->post('product_type');
      $ord['delivery_permission_id'] = $this->input->post('delivery_permission_id');
      $ord['application_id'] = $this->input->post('application_id');
      $ord['reference_id'] = $this->input->post('reference_id');
      $ord['supply_from'] = $this->input->post('supply_from');
      //$ord['supply_to'] = $this->input->post('supply_to');
      $ord['supply_to'] = 0;
      $ord['packing_charges'] = $this->input->post('packing_charges');
      $ord['other_charges'] = $this->input->post('other_charges');
      $ord['remarks'] = $this->input->post('remarks');
      $ord['eyelets'] = $this->input->post('eyelets');
      $ord['delivery_type'] = $this->input->post('delivery_type');
      $ord['customer_billing_address_id'] = $this->input->post('customer_billing_address_id');
      $ord['customer_shipping_address_id'] = $this->input->post('customer_shipping_address_id');
      $ord['dealer_id'] = $this->input->post('dealer_id');

$iscpo = $ord['is_customer_po'] = $this->input->post('is_customer_po');
      if($iscpo==1)
      {
        $rmnorep = str_replace('/', '-', $this->input->post('order_no'));
        $ord['customer_po_no'] = $this->input->post('customer_po_no');

if(!empty($_FILES['customer_po_bill']['name']))
        {
          $ext = pathinfo($_FILES['customer_po_bill']['name'], PATHINFO_EXTENSION);
          $config['upload_path'] = 'customerpobill';
          $config['allowed_types'] = 'jpg|jpeg|png|doc|docx|pdf';
          $config['file_name'] = $rmnorep;
          $profileName = $config['file_name'].'.'.$ext;
          $this->load->library('upload',$config);
          $this->upload->initialize($config);
          if($this->upload->do_upload('customer_po_bill'))
          {
            $uploadData = $this->upload->data();
            $ord['customer_po_bill'] = $profileName;
          }
          else
          {
            $ord['customer_po_bill'] = '';
          }
        }
        else
        {
          $ord['customer_po_bill'] = '';
        }
      }
      else
      {
        $ord['customer_po_no'] = '';
        $ord['customer_po_bill'] = '';
      }
      
      $result = $this->Order_model->update_order($ord,$order_id);

if ($result) {
        $ordprod['order_id'] = $order_id;

/*$order_product_list = $this->Order_model->get_order_product_by_id($order_id);
        foreach($order_product_list as $oplist)
        {
          $locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$oplist['product_id']);
          print_r($locproduct);
          echo $locId."<br>";
          echo $oplist['product_id'];
          $lpqty = $locproduct[0]['stock'];
          $bqty = $locproduct[0]['booked'];
          $npur = $locproduct[0]['need_production'];
          $dedstock = $lpqty + $oplist['booked'];
          $bookstock = $bqty - $oplist['booked'];
          $np = $npur - $oplist['need_production'];
          $dstock = $this->Order_model->update_pstock_by_locid_prodid($locId,$oplist['product_id'],$dedstock,$bookstock,$np);
        }
        exit;*/
        $this->Order_model->delete_order_product($order_id);

$pid = explode(",",implode(",",$this->input->post('product_id')));
        $uid = explode(",",implode(",",$this->input->post('uom_id')));
        $ptid = explode(",",implode(",",$this->input->post('product_type_id')));
        $pgst = explode(",",implode(",",$this->input->post('product_gst')));
        $pfid = explode(",",implode(",",$this->input->post('price_formula_id')));
        $csl = explode(",",implode(",",$this->input->post('cut_size_length')));
        $csw = explode(",",implode(",",$this->input->post('cut_size_width')));
        //$csh = explode(",",implode(",",$this->input->post('cut_size_height')));
        $fsl = explode(",",implode(",",$this->input->post('finish_size_length')));
        $fsw = explode(",",implode(",",$this->input->post('finish_size_width')));
        //$fsh = explode(",",implode(",",$this->input->post('finish_size_height')));
        $rpsq = explode(",",implode(",",$this->input->post('rate_per_sqft')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $rate = explode(",",implode(",",$this->input->post('rate')));
        $disc = explode(",",implode(",",$this->input->post('disc')));
        $amt = explode(",",implode(",",$this->input->post('amount')));
        $subcount = count($this->input->post('product_id')); 
        for($i=0;$i<$subcount;$i++)
        {
          if($pid[$i] != ''){
            $ordprod['product_id'] = $pid[$i];
            $ordprod['uom_id'] = $uid[$i];
            $ordprod['product_type_id'] = $ptid[$i];
            $ordprod['product_gst'] = $pgst[$i];
            $ordprod['price_formula_id'] = $pfid[$i];
            $ordprod['cut_size_length'] = $csl[$i];
            $ordprod['cut_size_width'] = $csw[$i];
            $ordprod['cut_size_height'] = 0;
            $ordprod['finish_size_length'] = $fsl[$i];
            $ordprod['finish_size_width'] = $fsw[$i];
            $ordprod['finish_size_height'] = 0;
            $ordprod['rate_per_sqft'] = $rpsq[$i];
            $ordprod['quantity'] = $qty[$i];
            $ordprod['rate'] = $rate[$i];
            $ordprod['disc'] = $disc[$i];
            $ordprod['amount'] = $amt[$i];

/*if($ptid[$i]==1)
            {
              $locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$pid[$i]);
              $lpqty = $locproduct[0]['stock'];
              $dedstock = $lpqty - $qty[$i];
              $dstock = $this->Order_model->update_pstock_by_locid_prodid($locId,$pid[$i],$dedstock);
            }*/
            if($ptid[$i]==1)
            {
              /*$locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$pid[$i]);
              if(count($locproduct)>0)
              {
                $lpqty = $locproduct[0]['stock'];
                $dedstock = $lpqty - $qty[$i];

$bqty = $locproduct[0]['booked'];

if($dedstock<0)
                {
                  $bookstock = $bqty+$lpqty;
                  $bstock = $lpqty;
                  $npqty = $locproduct[0]['need_production'];
                  $npur = $npqty+abs($dedstock);
                  $np = abs($dedstock);
                  $dedstock = 0;
                }
                else
                {
                  $bookstock = $bqty+$qty[$i];
                  $bstock = $qty[$i];
                  $npur=0;
                  $np=0;
                }
                $dstock = $this->Order_model->update_pstock_by_locid_prodid($locId,$pid[$i],$dedstock,$bookstock,$npur);
              }
              else
              {
                $dedstock=0;
                $bookstock=0;
                $bstock=0;
                $npur=$qty[$i];
                $np = $qty[$i];
                $created_on = date('Y-m-d H:i:s');
                $created_by = $_SESSION['user_id'];
                $this->Order_model->add_pstock_by_locid_prodid($locId,$pid[$i],$dedstock,$bookstock,$npur,$created_on,$created_by);
              }
              $ordprod['booked'] = $bstock;
              $ordprod['need_production'] = $np;*/

$ordprod['booked'] = 0;
              $ordprod['need_production'] = 0;
            }
            else
            {
              $ordprod['booked'] = 0;
              $ordprod['need_production'] = 0;
            }

$this->Order_model->create_order_product($ordprod);
          }
        }

$pdata['general_setting'] = $general_setting = $this->Order_model->get_general_settings_details();
        /*$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($order_id);

$cus_id = $order_list->customer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);
        
        $cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
        $cphone = $cusphone->phone_no;

$cusemail = $this->Order_model->get_customer_email_by_id($cus_id);
        $cname = $order_list->customer_name;*/

$olist = $this->Order_model->get_order_by_id($order_id);
        if($olist->customer_id!=0)
        {
          $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($order_id);
          $cus_id = $order_list->customer_id;
          $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
          $cphone = $cusphone->phone_no;

$cusemail = $this->Order_model->get_customer_email_by_id($cus_id);
          $cname = $order_list->customer_name;

if(count($cusemail)>0)
          {
            $cemail = $cusemail->email;
          }
          else
          {
            $cemail = '';
          }
        }
        else
        {
          $order_list = $pdata['order_list'] = $this->Order_model->get_dealer_order_view_by_id($order_id);
          $cus_id = $order_list->dealer_id;
          $cus_address = $pdata['cus_address'] = $this->Order_model->get_dealer_address_by_dealer_id($cus_id);

$dlist = $this->Order_model->get_dealer_view_by_id($cus_id);

$cphone = $dlist->phone_no;
          $cname = $dlist->email_id;
        }

/*if(count($cusemail)>0)
        {
          $cemail = $cusemail->email;
        }
        else
        {
          $cemail = '';
        }*/

$badd='';
        $sadd = '';
        if($order_list->customer_billing_address_id==0)
        {
          foreach($cus_address as $cadd)
          {
            if($cadd['address_type_id']==1)
            {
              $badd = $cadd['address'];
            }
            if($cadd['address_type_id']==2)
            {
              $sadd = $cadd['address'];
            }
          }
          if($badd=='')
          {
            $pdata['badd'] = $badd = $sadd;
          }
          else
          {
            $pdata['badd'] = $badd = $badd;
          }
          if($sadd=='')
          {
            $pdata['sadd'] = $sadd = $badd;
          }
          else
          {
            $pdata['sadd'] = $sadd = $sadd;
          }
        }
        else
        {
          /*$baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
          $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);*/        
          if($olist->customer_id!=0)
          {
            $baddress = $this->Order_model->get_customer_address_by_id($order_list->customer_billing_address_id);
            $saddress = $this->Order_model->get_customer_address_by_id($order_list->customer_shipping_address_id);
          }
          else
          {
            $baddress = $this->Order_model->get_dealer_address_by_id($order_list->customer_billing_address_id);
            $saddress = $this->Order_model->get_dealer_address_by_id($order_list->customer_shipping_address_id);
          }
          $pdata['badd'] = $badd = $baddress->address." - ".$baddress->state." - ".$baddress->address_pincode;
          $pdata['sadd'] = $sadd = $saddress->address." - ".$saddress->state." - ".$saddress->address_pincode;
          $pdata['stid'] = $baddress->address_state_id;
        }

$order_product_list = $pdata['order_product_list'] = $this->Order_model->get_order_product_by_id($order_id);

$tc = $pdata['terms_and_conditions'] = $this->Order_model->get_order_terms_and_conditions();

$html = '';

$html.='<html>
  <head>
  <style>
  table > thead > tr > th {vertical-align: middle; font-size:12px;}
  table > tbody > tr > td {vertical-align: middle; font-size:10px;}
  </style>
  </head>
            <body style="border:1px solid black;float:left;width:100%;padding:10px;">
              <div style="width:100%;float:left;">
                <img src="assets/images/product_logo/arjun_header.jpg" style="height:100%;width:100%;float:left;">
              </div>
                       
              <div style="clear:both!important;"></div>
              <div style="width:100%;float:right;">
                <p style="text-align:right;margin-bottom:0px!important;">SALE ORDER</p>
              </div>
                       
              <div style="clear:both!important;"></div>
              <hr style="border-bottom:1px solid #000;float:left;width:100%;">
              <div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
                  <div style="width:50%;float:left;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                      <table style="width:100%;">
                          <tr>
                              <td style="width:100%;"><b>Billed To</b></td>
                          </tr>
                          <tr>
                              <td style="width:100%;">'.$order_list->customer_name.'</td>
                          </tr>
                          <tr>
                              <td style="width:100%;">'.$badd.'</td>
                          </tr>
                          <tr>
                              <td style="width:100%;"></td>
                          </tr>                        
                          <tr>
                              <td style="width:100%;"><b>Shipped To</b></td>
                          </tr>
                          <tr>
                              <td style="width:100%;">'.$order_list->customer_name.'</td>
                          </tr>
                          <tr>
                              <td style="width:100%;">'.$sadd.'</td>
                          </tr>
                      </table>
                  </div>';
                  $odate = date_format(date_create($order_list->order_date),'d M Y'); 
                  $delper = $this->Order_model->get_deliverypermission_by_id($order_list->delivery_permission_id);
                  $delpermission = $delper->delivery_permission;
                  $html.='<div style="width:40%;float:right;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                      <table style="width:100%;">
                          <tr>
                              <td style="width:30%;"><b>SO No</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:60%;">'.$order_list->order_no.'</td>
                          </tr>
                          <tr>
                              <td style="width:30%;"><b>SO Date</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:60%;">'.$odate.'</td>
                          </tr>
                          <tr>
                              <td style="width:30%;"><b>Delivery Permission</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:60%;">'.$delpermission.'</td>
                          </tr>
                      </table>
                  </div>
              </div>
              <div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
                  <table border="1" cellpadding="5" style="width:100%;border-collapse:collapse;">
                    <thead>
                    <tr>
                        <th>S.No</th>
                        <th>HSN</th>
                        <th>Description</th>
                        <th>Qty</th>
                        <th>Unit Price ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                        <th>Disc %</th>
                        <th>Taxable Value ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                        <th>SGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                        <th>CGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                        <th>Total Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                    </tr></thead><tbody>';
                    $taxamt=0;$tottax=0;$i=1;foreach($order_product_list as $oprod){
                      $sgst = str_replace(',', '', number_format($oprod['amount']*$oprod['gst']/100, 2));
                      $cgst = str_replace(',', '', number_format($oprod['amount']*$oprod['gst']/100, 2));
                      $totamt = number_format($oprod['amount']+$sgst+$cgst, 2);
                    $html.='
                    <tr>
                      <td>'.$i.'</td>
                      <td>'.$oprod['hsn_code'].'</td>
                      <td>'.$oprod['product_name'].'</td>
                      <td>'.$oprod['quantity'].'</td>
                      <td>'.$oprod['rate']/$oprod['quantity'].'</td>
                      <td>'.$oprod['disc'].'</td>
                      <td>'.$oprod['amount'].'</td>
                      <td><table><tr><td>'.$sgst.'</td></tr></table><table><tr><td>@'.number_format($oprod['gst'], 2).'%</td></tr></table></td>
                      <td><table><tr><td>'.$cgst.'</td></tr></table><table><tr><td>@'.number_format($oprod['gst'], 2).'%</td></tr></table></td>
                      <td>'.$totamt.'</td>
                    </tr>';
                    $taxamt+=$oprod['amount'];$tottax+=$sgst+$cgst;$i++;}
                    $html.='</tbody>
                  </table>
              </div>
              <div style="clear:both!important;"></div>';

$sumamt = $taxamt+$tottax;
              $rnd = round($sumamt);
              $rofval = round($rnd-$sumamt,2);
              if($order_list->payment_term_id!=0)
              {
                $ptem = $this->Order_model->get_patyment_term_by_id($order_list->payment_term_id);
                $payterm = $ptem->payment_term;
              }
              else
              {
                $payterm = '-';
              }
              if($order_list->delivery_term_id!=0)
              {
                $dtem = $this->Order_model->get_delivery_term_by_id($order_list->delivery_term_id);
                $delterm = $dtem->delivery_term;
              }
              else
              {
                $delterm = '-';
              }
              $html.='<div style="width:100%;float:left;margin-bottom:15px;">

<div style="width:50%;float:left;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                      <table style="width:100%;">
                          <tr>
                              <td style="width:40%;"><b>Payment Terms</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$payterm.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Delivery Terms</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$delterm.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Transport</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$order_list->transport.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Destination Point</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$order_list->booking_place.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Incharge</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$order_list->incharge.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Advance Recd. ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$order_list->advance_amount.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Balance Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$order_list->balance_amount.'</td>
                          </tr>
                      </table>
                  </div>
                  <div style="width:40%;float:right;border:1px solid #ddd;padding:10px;margin-bottom:15px;">
                      <table style="width:100%;">
                          <tr>
                              <td style="width:40%;"><b>Taxable Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.number_format($taxamt, 2).'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>CGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.number_format($tottax/2, 2).'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>SGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.number_format($tottax/2, 2).'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Round Off ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.$rofval.'</td>
                          </tr>
                          <tr>
                              <td style="width:40%;"><b>Grand Total ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                              <td style="width:10%;">:</td>
                              <td style="width:50%;">'.number_format($rnd, 2).'</td>
                          </tr>
                      </table>
                  </div>
              </div>

<div style="width:100%;float:left;margin-bottom:15px;">
                <table style="width:100%;">
                  <tr>
                      <td style="width:20%;"><b>Tax Amount (in words)</b></td>
                      <td style="width:2%;">:</td>
                      <td style="width:78%;">'.$this->convertToIndianCurrency(str_replace(',', '', number_format($tottax, 2))).'</td>
                  </tr>
                  <tr>
                      <td style="width:20%;"><b>Grand Total (in words)</b></td>
                      <td style="width:2%;">:</td>
                      <td style="width:78%;">'.$this->convertToIndianCurrency(str_replace(',', '', number_format($rnd, 2))).'</td>
                  </tr>
                </table>
              </div>';

if(count($tc)>0){

$html.='<div style="clear:both!important;"></div>
              
              <div style="width:100%;float:left;margin-bottom:15px;">
                <table style="width:100%;">
                  <tr>
                      <td>'.$tc->terms_and_conditions.'</td>
                  </tr>
                </table>
              </div>';

}

$html.='<div style="clear:both!important;"></div>

<div style="width:100%;float:left;margin-bottom:15px;">
                <div style="float:right;padding:10px;">
                  <p style="font-size:13px;">For <b>Arjun Agri & Bio Energy Private Limited,</b></p>
                  <br>
                  <p style="font-size:13px;">Authorized Signatory</p>
                </div>
              </div>';

$html.='</body></html>';
  $data['html'] = $html;

$html = preg_replace('/>\s+</', "><", $html);
  $dompdf = new DOMPDF();
  $dompdf->load_html($html);
  $dompdf->set_paper('A4','portrait');
  $dompdf->render();
  $output = $dompdf->output();
  $rmnorep = str_replace('/', '-', $order_list->order_no);
  file_put_contents("pdfsalesorder/".$rmnorep.".pdf", $output);

if($smsQtn==1)
  {
    $genset = $this->Order_model->get_general_settings_details();
    $nlcontent = $this->Order_model->get_new_order_msg();
    $content = $nlcontent->sms_content;
    $content = str_replace('#name#', ucwords($cname), $content);
    $content = str_replace('#orderId#', $order_list->order_no, $content);
    $content = str_replace('#orderDate#', $odate, $content);
    $content = str_replace('#orderAmount#', number_format($rnd, 2), $content);
    sendsms($cphone,$content,$genset->sms_auth_key,$genset->sms_sender_id);
  }

if($wapQtn==1)
  {
    $genset = $this->Order_model->get_general_settings_details();
    $wpcontent = $this->Order_model->get_new_order_whatsappmsg();
    $wapcontent = $wpcontent->whatsapp_content;
    $wapcontent = str_replace('#name#', ucwords($cname), $wapcontent);
    $wapcontent = str_replace('#orderId#', $order_list->order_no, $wapcontent);
    $wapcontent = str_replace('#orderDate#', $odate, $wapcontent);
    $wapcontent = str_replace('#orderAmount#', number_format($rnd, 2), $wapcontent);

$wmsg = [
        'phone' => '91'.$cphone, // Receivers phone
        'body' => $wapcontent, // Message
    ];
    //print_r($wmsg);exit;
    $json = json_encode($wmsg); // Encode data to JSON
    // URL for request POST /message
    $url = $genset->whatsapp_api_key;
    // Make a POST request
    $options = stream_context_create(['http' => [
            'method'  => 'POST',
            'header'  => 'Content-type: application/json',
            'content' => $json
        ]
    ]);
    // Send a request
    $result = file_get_contents($url, false, $options);
  }

if($emailQtn==1)
  {
    if($cemail!='')
    {
      $rmnorep = str_replace('/', '-', $order_list->order_no);
      $attched_file= site_url()."pdfsalesorder/".$rmnorep.".pdf";
      $mcRes = $this->Order_model->get_general_settings_details();

$smtp_pwd = $this->aes128Decrypt('arjunerp', $mcRes->smtp_password);   
      $config = Array( 
      'protocol' => 'smtp',
      'smtp_host' => $mcRes->smtp_host_name,
      'smtp_user' => $mcRes->smtp_user_name, 
      'smtp_pass' => $smtp_pwd,
      'smtp_port' => 587,
      'mailtype'  => 'html', 
      'charset'   => 'utf-8',
      'newline'  => "\r\n",
      'wordwrap' => TRUE,
      );
       $et = $this->Order_model->order_mail_template();
              $subject = $et->email_subject;
              $content = $et->email_content;

$content = str_replace('#displayName#',ucfirst($cname), $content);
              $content = str_replace('#year#', date('Y'), $content);
              $content = str_replace('#productLogo#', $mcRes->product_logo, $content);
              $content = str_replace('#baseurl#', base_url(), $content);
              $content = str_replace('#orderId#', $order_list->order_no, $content);
              $content = str_replace('#orderDate#', $odate, $content);
              $content = str_replace('#orderAmount#', number_format($rnd, 2), $content);
              $this->load->library('email',$config);
              $this->email->initialize($config);
              $this->email->from($mcRes->from_mail);          
              $this->email->to($cemail);
              $this->email->subject($subject);
              $this->email->message($content);
              $this->email->attach($attched_file);
      if($this->email->send())
      {
         //echo "Your Password has been sent to your email id";
      }else{
        //echo "error";
       //echo $this->email->print_debugger();
       //die();
       //echo "Your Password has been sent to your email id";
      }
    }
  }

$this->session->set_flashdata('add_success', 'Order has been created successfully.');
      }
      else{
        $this->session->set_flashdata('add_err', 'Something went wrong');
      }
        //redirect('/order');
      if($printQtn==1)
        $this->load->view('order/printview',$pdata);
      else
        redirect('/order');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Already workorder Created. Not able to edit this order!');
      redirect('/order');
    }
  }

public function wo_print()
  {   
    $id = $_POST['id'];
    //print_r($id);exit;
    $workorder = $pdata['workorder'] = $this->Workorder_model->get_work_order_by_id($id);

$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($workorder->order_id);

$cus_id = $order_list->customer_id;

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
    $cphone = $cusphone->phone_no;

$pdata['customer_phone'] = $cphone;

$pdata['workorder_product'] = $this->Workorder_model->get_work_order_product_by_id($id);

$pdata['workorder_rm_details'] = $this->Workorder_model->get_work_order_rm_details_by_id($id);
    
    $this->load->view('order/wo_print',$pdata);
  }

public function wl_print()
  {   
    $id = $_POST['id'];
    $pdata['work_log_details'] = $this->Worklog_model->get_work_log_by_id($id);
    $pdata['work_log_product_details'] = $this->Worklog_model->get_work_log_product_by_id($id);
    
    $this->load->view('order/wlg_print',$pdata);
  }

public function dc_print()
  {   
    $delivery_challan_id = $_POST['id'];
    $deliverychallan = $pdata['delivery_challan'] = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);
    $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($deliverychallan->order_id);

$cus_id = $order_list->customer_id;
    $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
    $cphone = $cusphone->phone_no;

$badd='';
    $sadd = '';
    foreach($cus_address as $cadd)
    {
      if($cadd['address_type_id']==1)
      {
        $badd = $cadd['address'];
      }
      if($cadd['address_type_id']==2)
      {
        $sadd = $cadd['address'];
      }
    }
    if($badd=='')
    {
      $pdata['badd'] = $badd = $sadd;
    }
    else
    {
      $pdata['badd'] = $badd = $badd;
    }
    if($sadd=='')
    {
      $pdata['sadd'] = $sadd = $badd;
    }
    else
    {
      $pdata['sadd'] = $sadd = $sadd;
    }

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);
    
    $this->load->view('order/dc_print',$pdata);
  }

public function inv_print()
  {   
      $invoice_id = $_POST['id'];
      $intype = $_POST['intype'];
      if($intype=='SO')
      {
        $invoice = $pdata['invoice'] = $this->Invoice_model->get_invoice_by_id($invoice_id);
        $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($invoice->order_id);

$cus_id = $order_list->customer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
        $cphone = $cusphone->phone_no;

$badd='';
        $sadd = '';
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }

$pdata['customer_phone'] = $cphone;

$pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
    
        $this->load->view('order/inv_print',$pdata);
      }
      else
      {
        $invoice_list = $pdata['invoice_list'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

$cus_id = $invoice_list->customer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
        $cphone = $cusphone->phone_no;

$badd='';
        $sadd = '';
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }

$pdata['customer_phone'] = $cphone;

$pdata['invoice'] = $this->Invoice_model->get_direct_invoice_view_by_id($invoice_id);

if($invoice_list->type=='raw material')
        {
          $pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_rawmaterial_id($invoice_id);
        }
        else
        {
          $pdata['invoice_product'] = $this->Invoice_model->get_invoice_product_by_id($invoice_id);
        }
      
        $this->load->view('order/direct_inv_print',$pdata);
      }
  }

public function order_short_close()
{
  $lid = $data['bid']=$_POST['id'];
  $this->load->view('order/order_short_close',$data);
}

public function short_close()
{
  $ordId = $this->input->post('order_id');
  $olist = $this->Order_model->get_order_by_id($ordId);
  if($olist->status==0 || $olist->status==1)
  {
    $ordsts['status']=20;
    $this->Workorder_model->update_order_status($ordsts,$ordId);

$wolist = $this->Order_model->get_work_order_by_order_id($ordId);

if(count($wolist)>0)
    {
      $woId = $wolist->work_order_id;
      $wordsts['status']=20;
      $this->Issueregister_model->update_work_order_status($wordsts,$woId);
    }

$this->session->set_flashdata('add_success', 'Order has been Short Close successfully.');
    redirect('/order');
  }
  else
  {
    $this->session->set_flashdata('add_success', 'Already worklog Created. Not able to delete this order!');
    redirect('/order');
  }

}

public function dealer_so_upload()
  {    
    $this->load->view('order/dealer_so_upload');
  }

public function sampleupload()
  {
    $objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
            'font' => array(
                'bold' => true,
                'color' => array('rgb' => '000000')
            )/*,
            'alignment' => array(
                'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
            )*/
        );
    //$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(20);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Production Unit');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Dealer Contact No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Location');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Del Date');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Product Type');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Delivery Permission');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Application');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Reference');
    $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Product');
    $objPHPExcel->getActiveSheet()->getStyle('I1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('J1', 'UOM');
    $objPHPExcel->getActiveSheet()->getStyle('J1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('K1', 'Cut Size Length');
    $objPHPExcel->getActiveSheet()->getStyle('K1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Cut Size Width');
    $objPHPExcel->getActiveSheet()->getStyle('L1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Finish Size Length');
    $objPHPExcel->getActiveSheet()->getStyle('M1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('N1', 'Finish Size Width');
    $objPHPExcel->getActiveSheet()->getStyle('N1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('O1', 'Quantity');
    $objPHPExcel->getActiveSheet()->getStyle('O1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('P1', 'Payment Term');
    $objPHPExcel->getActiveSheet()->getStyle('P1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('Q1', 'Delivery Term');
    $objPHPExcel->getActiveSheet()->getStyle('Q1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('R1', 'Transport');
    $objPHPExcel->getActiveSheet()->getStyle('R1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('S1', 'Destination Point');
    $objPHPExcel->getActiveSheet()->getStyle('S1')->applyFromArray($styleArray);
    //$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(20);
    $objPHPExcel->getActiveSheet()->setCellValue('T1', 'Advance Amount');
    $objPHPExcel->getActiveSheet()->getStyle('T1')->applyFromArray($styleArray);

$objWorkSheet = $objPHPExcel->createSheet('2');
    $objPHPExcel->setActiveSheetIndex(1)->getRowDimension(1)->setRowHeight(20);
    $objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', 'Product Type');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('A1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$prodType = $this->Product_model->get_product_type();

foreach($prodType as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A'.$i, $row['product_type']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('B1', 'Location');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('B1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$loc = $this->Order_model->get_location();

foreach($loc as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('B'.$i, $row['location_name']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('C')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('C1', 'Delivery Permission');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('C1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$delper = $this->Order_model->get_delivery_permission();

foreach($delper as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('C'.$i, $row['delivery_permission']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('D')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D1', 'Application');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('D1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$appli = $this->Product_model->get_active_application();

foreach($appli as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('D'.$i, $row['application']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('E1', 'UOM');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('E1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$uomlist = $this->Product_model->get_uom_list();

foreach($uomlist as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('E'.$i, $row['uom']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('F')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('F1', 'Reference');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('F1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$refer = $this->Order_model->get_active_reference();

foreach($refer as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('F'.$i, $row['reference']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('G')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('G1', 'Product');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('G1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$prodlist = $this->Order_model->get_product_list();

foreach($prodlist as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('G'.$i, $row['product_name']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('H')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('H1', 'Payment Term');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('H1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$pterm = $this->Order_model->get_so_payment_term();

foreach($pterm as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('H'.$i, $row['payment_term']);
      $i++;
      $j++;      
    }

$objPHPExcel->setActiveSheetIndex(1)->getColumnDimension('I')->setWidth(20);
    $objPHPExcel->setActiveSheetIndex(1)->setCellValue('I1', 'Delivery Term');
    $objPHPExcel->setActiveSheetIndex(1)->getStyle('I1')->applyFromArray($styleArray);
    $ty = "";
    $i  = 2;
    $j  = 1;

$dterm = $this->Order_model->get_so_delivery_term();

foreach($dterm as $row)
    {     
      $objPHPExcel->setActiveSheetIndex(1)->setCellValue('I'.$i, $row['delivery_term']);
      $i++;
      $j++;      
    }

$objWorkSheet->setTitle("Dropdown Information");

$filename='Sample_SO.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
    //if you want to save it as .XLSX Excel 2007 format
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
    $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output'); 
  }

public function order_import()
  {
    if(isset($_POST["import"]))
    {
      PHPExcel_IOFactory::createReader('Excel2007');
      $filename=$_FILES["file"]["tmp_name"];
      if($_FILES["file"]["size"] > 0)
      {
        try
        {
          $objPHPExcel = PHPExcel_IOFactory::load($filename);
        }catch(Exception $e)
        {
          die('Error loading file "'.pathinfo($filename,PATHINFO_BASENAME).'": '.$e->getMessage());
        }
        $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
        $arrayCount = count($allDataInSheet);  // Here get total count of row in that Excel sheet
        $ins=0;$alr=0;$emptrow=1;
        //print_r($allDataInSheet[1]);exit;
        if(trim($allDataInSheet[1]["A"])=='Production Unit' && trim($allDataInSheet[1]["B"])=='Dealer Contact No' && trim($allDataInSheet[1]["C"])=='Location' && trim($allDataInSheet[1]["D"])=='Del Date' && trim($allDataInSheet[1]["E"])=='Product Type' && trim($allDataInSheet[1]["F"])=='Delivery Permission' && trim($allDataInSheet[1]["G"])=='Application' && trim($allDataInSheet[1]["H"])=='Reference' && trim($allDataInSheet[1]["I"])=='Product' && trim($allDataInSheet[1]["J"])=='UOM' && trim($allDataInSheet[1]["K"])=='Cut Size Length' && trim($allDataInSheet[1]["L"])=='Cut Size Width' && trim($allDataInSheet[1]["M"])=='Finish Size Length' && trim($allDataInSheet[1]["N"])=='Finish Size Width' && trim($allDataInSheet[1]["O"])=='Quantity' && trim($allDataInSheet[1]["P"])=='Payment Term' && trim($allDataInSheet[1]["Q"])=='Delivery Term' && trim($allDataInSheet[1]["R"])=='Transport' && trim($allDataInSheet[1]["S"])=='Destination Point' && trim($allDataInSheet[1]["T"])=='Advance Amount')
        {
          $val=0;$iv='';$err='';$pid='';
          for($i=2;$i<=$arrayCount;$i++){
            $pu='';$d='';$loc='';$del='';$pt='';$delper='';$app='';$ref='';$pterm='';$dterm='';$ddate='';$trans='';$despoint='';$ocnt = 0;
            if(trim($allDataInSheet[1]["A"])=='' && trim($allDataInSheet[1]["B"])==''&&trim($allDataInSheet[1]["C"])=='' && trim($allDataInSheet[1]["D"])=='' && trim($allDataInSheet[1]["E"])=='' && trim($allDataInSheet[1]["F"])=='' && trim($allDataInSheet[1]["G"])=='' && trim($allDataInSheet[1]["H"])=='' && trim($allDataInSheet[1]["I"])=='' && trim($allDataInSheet[1]["J"])=='' && trim($allDataInSheet[1]["K"])=='' && trim($allDataInSheet[1]["L"])=='' && trim($allDataInSheet[1]["M"])=='' && trim($allDataInSheet[1]["N"])=='' && trim($allDataInSheet[1]["O"])=='' && trim($allDataInSheet[1]["P"])=='' && trim($allDataInSheet[1]["Q"])=='' && trim($allDataInSheet[1]["R"])=='' && trim($allDataInSheet[1]["S"])=='' && trim($allDataInSheet[1]["T"])=='')
            {
              $emptrow++;
              $errmsg = '1';
            }
            else
            {
              if(trim($allDataInSheet[$i]["A"])!='')
              {
                if(trim($allDataInSheet[$i]["A"])=='Unit 1')
                {
                  $punit = $proddata['prod_unit'] = 'unit1';
                  $ocnt++;
                }
                else if(trim($allDataInSheet[$i]["A"])=='Unit 2')
                {
                  $punit = $proddata['prod_unit'] = 'unit2';
                  $ocnt++;
                }
                else
                {
                  $pu = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $pu = $i;
                }
              }

if(trim($allDataInSheet[$i]["B"])!='')
              {
                //$dealer = $this->Order_model->dealer_phone_no_unique(trim($allDataInSheet[$i]["B"]));
                $dealer = $this->Order_model->customer_phone_no_unique(trim($allDataInSheet[$i]["B"]));
                if(count($dealer)>0)
                {
                  $proddata['customer_id'] = $dealer->customer_id;
                  $customerdet = $this->Order_model->get_customer_view_by_id($dealer->customer_id);
                  $dbill_address = $this->Order_model->get_dealer_first_billing_address_by_id($dealer->customer_id);
                  $dship_address = $this->Order_model->get_dealer_first_shipping_address_by_id($dealer->customer_id);

$badd = $sadd = '';
                  if(count($dbill_address)>0)
                  {
                    $badd = $dbill_address->customer_address_id;
                  }
                  if(count($dship_address)>0)
                  {
                    $sadd = $dship_address->customer_address_id;
                  }

if($badd=='')
                  {
                    $proddata['customer_billing_address_id'] = $badd = $sadd;
                  }
                  else
                  {
                    $proddata['customer_billing_address_id'] = $badd = $badd;
                  }
                  if($sadd=='')
                  {
                    $proddata['customer_shipping_address_id'] = $sadd = $badd;
                  }
                  else
                  {
                    $proddata['customer_shipping_address_id'] = $sadd = $sadd;
                  }

$ocnt++;
                }
                else
                {
                  $d = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $d = $i;
                }
              }

if(trim($allDataInSheet[$i]["C"])!='')
              {
                $loclist = $this->Order_model->get_location_by_name(trim($allDataInSheet[$i]["C"]));
                if(count($loclist)>0)
                {
                  $locId = $proddata['location_id'] = $loclist->location_id;
                  $ocnt++;
                }
                else
                {
                  $loc = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $loc = $i;
                }
              }

if(trim($allDataInSheet[$i]["D"])!='')
              {
                 $proddata['del_date'] = date_format(date_create(trim($allDataInSheet[$i]["D"])),'Y-m-d')." 00:00";
                  $ocnt++;
              }              
              else
              {
                if($pid=='')
                {
                  $ddate = $i;
                }
              }

if(trim($allDataInSheet[$i]["E"])!='')
              {
                $ptype = $this->Producttype_model->checkProductTypeUnique(trim($allDataInSheet[$i]["E"]));
                if(count($ptype)>0)
                {
                  $proddata['product_type_id'] = $ptype->product_type_id;
                  $ocnt++;
                }
                else
                {
                  $pt = $i;
                }
              }  
              else
              {
                if($pid=='')
                {
                  $pt = $i;
                }
              }

if(trim($allDataInSheet[$i]["F"])!='')
              {
                $dper = $this->Deliverypermission_model->checkDeliverypermissionUnique(trim($allDataInSheet[$i]["F"]));
                if(count($dper)>0)
                {
                  $proddata['delivery_permission_id'] = $dper->delivery_permission_id;
                  $ocnt++;
                }
                else
                {
                  $delper = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $delper = $i;
                }
              }

if(trim($allDataInSheet[$i]["G"])!='')
              {
                $appli = $this->Application_model->checkApplicationUnique(trim($allDataInSheet[$i]["G"]));
                if(count($appli)>0)
                {
                  $proddata['application_id'] = $appli->application_id;
                  $ocnt++;
                }
                else
                {
                  $app = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $app = $i;
                }
              }

if(trim($allDataInSheet[$i]["H"])!='')
              {
                $refre = $this->Reference_model->checkReferenceUnique(trim($allDataInSheet[$i]["H"]));
                if(count($refre)>0)
                {
                  $proddata['reference_id'] = $refre->reference_id;
                  $ocnt++;
                }
                else
                {
                  $ref = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $ref = $i;
                }
              }

if(trim($allDataInSheet[$i]["P"])!='')
              {
                $payterm = $this->Paymentterm_model->checkPaymenttermUnique(trim($allDataInSheet[$i]["P"]));
                if(count($payterm)>0)
                {
                  $proddata['payment_term_id'] = $payterm->payment_term_id;
                  $ocnt++;
                }
                else
                {
                  $pterm = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $pterm = $i;
                }
              }

if(trim($allDataInSheet[$i]["Q"])!='')
              {
                $delterm = $this->Deliveryterm_model->checkDeliverytermUnique(trim($allDataInSheet[$i]["Q"]));
                if(count($delterm)>0)
                {
                  $proddata['delivery_term_id'] = $delterm->delivery_term_id;
                  $ocnt++;
                }
                else
                {
                  $dterm = $i;
                }
              }
              else
              {
                if($pid=='')
                {
                  $dterm = $i;
                }
              }

if(trim($allDataInSheet[$i]["R"])!='')
              {
                $proddata['transport'] = trim($allDataInSheet[$i]["R"]);
              }
              else
              {
                $proddata['transport'] = '';
              }

if(trim($allDataInSheet[$i]["S"])!='')
              {
                $proddata['booking_place'] = trim($allDataInSheet[$i]["S"]);
              }
              else
              {
                $proddata['booking_place'] = '';
              }

}

if($pu=='' && $d=='' && $loc=='' && $del=='' && $pt=='' && $delper=='' && $app=='' && $ref=='' && $pterm=='' && $dterm=='' && $ddate=='' && $ocnt==10)
            {
              $tamt=0;$ttot=0;$roff=0;$totamt=0;

if($pid!='')
              {
                $order_product_list = $this->Order_model->get_order_product_by_id($pid);
                foreach($order_product_list as $oplist)
                {
                  $tax = (($oplist['amount']*$oplist['product_gst'])/100)*2;
                  $tamt+=$oplist['amount'];
                  $ttot+=$tax;
                }
                $tottaxamt = $tamt+$ttot;
                $totamt = round($tottaxamt);
                $roff = $totamt-$tottaxamt;
                $uporder['taxable_amount'] = $tamt;
                $uporder['total_tax'] = $ttot;
                $uporder['round_off'] = number_format($roff,2);
                $uporder['grand_total'] = $totamt;
                $uporder['order_id'] = $pid;
                $this->Order_model->update_order_amount_value($uporder);
              }

$last_id_value = $this->Order_model->last_order_id_by_unit($punit);

if(count($last_id_value)==0)
              {
                if($punit=='unit1')
                  $ono = $proddata['order_no'] = date("Y").'/'.date('m').'/U1/SO001';
                else
                  $ono = $proddata['order_no'] = date("Y").'/'.date('m').'/U2/SO001';
              }
              else
              {
                $lno = $last_id_value->order_no;
                $exlno = substr($lno,13);
                $next_value = (int)$exlno + 1;
                $slen = strlen($next_value);
                if($slen==1)
                  $nval = '00'.$next_value;
                else if($slen==2)
                  $nval = '0'.$next_value;
                else
                  $nval = $next_value;
                //$ono = $ord['order_no'] = date("Y").'/'.date('m').'/SO'.$nval;
                if($punit=='unit1')
                  $ono = $proddata['order_no'] = date("Y").'/'.date('m').'/U1/SO'.$nval;
                else
                  $ono = $proddata['order_no'] = date("Y").'/'.date('m').'/U2/SO'.$nval;
              }
              $l_user = login_user_details($_SESSION['user_id']);
              $proddata['order_date']=date('Y-m-d');
              $proddata['created_on'] = date('Y-m-d H:i:s');
              $proddata['created_by'] = $_SESSION['user_id'];
              $proddata['taxable_amount'] = 0;
              $proddata['total_tax'] = 0;
              $proddata['round_off'] = '';
              $proddata['grand_total'] = 0;
              $proddata['incharge'] = $l_user->displayname;;
              $proddata['advance_amount'] = 0;
              $proddata['balance_amount'] = 0;
              $proddata['quotation_id'] = 0;
              $proddata['is_customer_po'] = 0;
              $proddata['customer_po_no'] = '';
              $proddata['customer_po_bill'] = '';
              $proddata['dealer_id'] = 0;
              $proddata['supply_from']=33;
              $proddata['supply_to']=0;
              $proddata['packing_charges']=0;
              $proddata['other_charges']=0;
              $proddata['remarks']='';
              $proddata['eyelets']='0';
              $proddata['delivery_type']=1;
              $result = $this->Order_model->create_order($proddata);

if($result) {
                $last_id_value = $this->Order_model->last_order_id();
                $last_value=$last_id_value->order_id;
                $pid = $ordprod['order_id'] = $last_value;

$pname=''; $um='';

if(trim($allDataInSheet[$i]["I"])!='')
                {
                  $delterm = $this->Order_model->get_product_by_name(trim($allDataInSheet[$i]["I"]));
                  if(count($delterm)>0)
                  {
                    $ordprod['product_id'] = $delterm->product_id;
                    $prodtype = $ordprod['product_type_id'] = $delterm->type_id;
                    $pgst = $ordprod['product_gst'] = $delterm->gst;
                    $rpsf = $ordprod['rate_per_sqft'] = $delterm->unit_price;
                  }
                  else
                  {
                    $pname = $i;
                  }
                }

if(trim($allDataInSheet[$i]["J"])!='')
                {
                  $uom = $this->Product_model->get_uom_by_name(trim($allDataInSheet[$i]["J"]));
                  if(count($uom)>0)
                  {
                    $ordprod['uom_id'] = $uom->uom_id;
                    $pform = $this->Product_model->get_price_formula_by_uom_id($uom->uom_id);
                    $ordprod['price_formula_id'] = $pform->price_formula_id;
                  }
                  else
                  {
                    $um = $i;
                  }
                }

if(trim($allDataInSheet[$i]["K"])!='')
                {
                  if(is_numeric(trim($allDataInSheet[$i]["K"])))
                  {
                    $csl = $ordprod['cut_size_length'] = trim($allDataInSheet[$i]["K"]);
                  }
                  else
                  {
                    $csl = $ordprod['cut_size_length'] = 0;
                  }
                }
                else
                {
                  $csl = $ordprod['cut_size_length'] = 0;
                }

if(trim($allDataInSheet[$i]["L"])!='')
                {
                  if(is_numeric(trim($allDataInSheet[$i]["L"])))
                  {
                    $csw = $ordprod['cut_size_width'] = trim($allDataInSheet[$i]["L"]);
                  }
                  else
                  {
                    $csw = $ordprod['cut_size_width'] = 0;
                  }
                }
                else
                {
                  $csw = $ordprod['cut_size_width'] = 0;
                }

if(trim($allDataInSheet[$i]["M"])!='')
                {
                  if(is_numeric(trim($allDataInSheet[$i]["M"])))
                  {
                    $ordprod['finish_size_length'] = trim($allDataInSheet[$i]["M"]);
                  }
                  else
                  {
                    $ordprod['finish_size_length'] = 0;
                  }
                }
                else
                {
                  $ordprod['finish_size_length'] = 0;
                }

if(trim($allDataInSheet[$i]["N"])!='')
                {
                  if(is_numeric(trim($allDataInSheet[$i]["N"])))
                  {
                    $ordprod['finish_size_width'] = trim($allDataInSheet[$i]["N"]);
                  }
                  else
                  {
                    $ordprod['finish_size_width'] = 0;
                  }
                }
                else
                {
                  $ordprod['finish_size_width'] = 0;
                }

if(trim($allDataInSheet[$i]["O"])!='')
                {
                  if(is_numeric(trim($allDataInSheet[$i]["O"])))
                  {
                    $qty = $ordprod['quantity'] = trim($allDataInSheet[$i]["O"]);
                  }
                  else
                  {
                    $qty = $ordprod['quantity'] = 0;
                  }
                }
                else
                {
                  $qty = $ordprod['quantity'] = 0;
                }

if($pname=='' && $um=='')
                {
                  $ordprod['cut_size_height'] = 0;
                  $ordprod['finish_size_height'] = 0;

if($csl!=0 && $csw!=0)
                  {
                    if($pf_id==3)
                    {
                      $price = (($csl*$csw)/144)*$rpsf;
                    }
                    else
                    {
                      $price = $csl*$csw*$rpsf;
                    }
                    $rate = $price*$qty;
                  }
                  else
                  {
                    $rate = $rpsf*$qty;
                  }

$ordprod['rate'] = $rate;
                  //$ordprod['disc'] = 0;
                  $ordprod['disc'] = $customerdet->discount_percentage;
                  $disamt = $rate*$customerdet->discount_percentage/100;
                  $ordprod['amount'] = $rate-$disamt;
                  $ordprod['booked'] = 0;
                  $ordprod['need_production'] = 0;
                  $this->Order_model->create_order_product($ordprod);

}

}
            }
            else if($pu=='' && $d=='' && $loc=='' && $del=='' && $pt=='' && $delper=='' && $app=='' && $ref=='' && $pterm=='' && $dterm=='' && $ddate=='' && $ocnt==0)
            {
              $pname=''; $um='';
              $ordprod['order_id'] = $pid;
              if(trim($allDataInSheet[$i]["I"])!='')
              {
                $delterm = $this->Order_model->get_product_by_name(trim($allDataInSheet[$i]["I"]));
                if(count($delterm)>0)
                {
                  $ordprod['product_id'] = $delterm->product_id;
                  $prodtype = $ordprod['product_type_id'] = $delterm->type_id;
                  $pgst = $ordprod['product_gst'] = $delterm->gst;
                  $rpsf = $ordprod['rate_per_sqft'] = $delterm->unit_price;
                }
                else
                {
                  $pname = $i;
                }
              }

if(trim($allDataInSheet[$i]["J"])!='')
              {
                $uom = $this->Product_model->get_uom_by_name(trim($allDataInSheet[$i]["J"]));
                if(count($uom)>0)
                {
                  $ordprod['uom_id'] = $uom->uom_id;
                  $pform = $this->Product_model->get_price_formula_by_uom_id($uom->uom_id);
                  $ordprod['price_formula_id'] = $pform->price_formula_id;
                }
                else
                {
                  $um = $i;
                }
              }

if(trim($allDataInSheet[$i]["K"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["K"])))
                {
                  $csl = $ordprod['cut_size_length'] = trim($allDataInSheet[$i]["K"]);
                }
                else
                {
                  $csl = $ordprod['cut_size_length'] = 0;
                }
              }
              else
              {
                $csl = $ordprod['cut_size_length'] = 0;
              }

if(trim($allDataInSheet[$i]["L"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["L"])))
                {
                  $csw = $ordprod['cut_size_width'] = trim($allDataInSheet[$i]["L"]);
                }
                else
                {
                  $csw = $ordprod['cut_size_width'] = 0;
                }
              }
              else
              {
                $csw = $ordprod['cut_size_width'] = 0;
              }

if(trim($allDataInSheet[$i]["M"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["M"])))
                {
                  $ordprod['finish_size_length'] = trim($allDataInSheet[$i]["M"]);
                }
                else
                {
                  $ordprod['finish_size_length'] = 0;
                }
              }
              else
              {
                $ordprod['finish_size_length'] = 0;
              }

if(trim($allDataInSheet[$i]["N"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["N"])))
                {
                  $ordprod['finish_size_width'] = trim($allDataInSheet[$i]["N"]);
                }
                else
                {
                  $ordprod['finish_size_width'] = 0;
                }
              }
              else
              {
                $ordprod['finish_size_width'] = 0;
              }

if(trim($allDataInSheet[$i]["O"])!='')
              {
                if(is_numeric(trim($allDataInSheet[$i]["O"])))
                {
                  $qty = $ordprod['quantity'] = trim($allDataInSheet[$i]["O"]);
                }
                else
                {
                  $qty = $ordprod['quantity'] = 0;
                }
              }
              else
              {
                $qty = $ordprod['quantity'] = 0;
              }

if($pname=='' && $um=='')
              {
                $ordprod['cut_size_height'] = 0;
                $ordprod['finish_size_height'] = 0;

if($csl!=0 && $csw!=0)
                {
                  if($pf_id==3)
                  {
                    $price = (($csl*$csw)/144)*$rpsf;
                  }
                  else
                  {
                    $price = $csl*$csw*$rpsf;
                  }
                  $rate = $price*$qty;
                }
                else
                {
                  $rate = $rpsf*$qty;
                }

$ordprod['rate'] = $rate;
                //$ordprod['disc'] = 0;
                $ordprod['disc'] = $customerdet->discount_percentage;
                $disamt = $rate*$customerdet->discount_percentage/100;
                $ordprod['amount'] = $rate-$disamt;
                //$ordprod['amount'] = $rate;
                $ordprod['booked'] = 0;
                $ordprod['need_production'] = 0;

$this->Order_model->create_order_product($ordprod);

}
            }
            else
            {
              if($iv=='')
                $iv = $i;
              else
                $iv.= ','.$i;
            }

if($i==$arrayCount)
            {
              $order_product_list = $this->Order_model->get_order_product_by_id($pid);
                foreach($order_product_list as $oplist)
                {
                  $tax = (($oplist['amount']*$oplist['product_gst'])/100)*2;
                  $tamt+=$oplist['amount'];
                  $ttot+=$tax;
                }
                $tottaxamt = $tamt+$ttot;
                $totamt = round($tottaxamt);
                $roff = $totamt-$tottaxamt;
                $uporder['taxable_amount'] = $tamt;
                $uporder['total_tax'] = $ttot;
                $uporder['round_off'] = number_format($roff,2);
                $uporder['grand_total'] = $totamt;
                $uporder['order_id'] = $pid;
                $this->Order_model->update_order_amount_value($uporder);
            }

}

if($emptrow==$arrayCount)
            $this->session->set_flashdata('add_err', 'All Rows are Empty');
          else if($iv=='')
            $this->session->set_flashdata('add_success', 'SO Added Successfully.');
          else
            $this->session->set_flashdata('add_err', 'Some Error In row '.$iv);
          redirect('/order/dealer_so_upload');

}
        else
        {
          $this->session->set_flashdata('add_err', 'Invalid File.');
          redirect('/order/dealer_so_upload');
        }
      }
    }
  }

public function receipt_print($id)
  {
    $data['order_details'] = $this->Order_model->get_order_view_by_id($id);
    $this->load->view('order/receipt_printview',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Order_old.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation