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: Quotation.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 Quotation extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Quotation_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Lead_model'));
    $this->load->model(array('Customer_model'));
    $this->load->library("pagination");
    //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', 'Quote Management');
  }

/*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 quotation_export()
  {
    $schange = isset($_SESSION['qschange'])?$_SESSION['qschange']:'all';
    $dtrange = isset($_SESSION['qdtrange'])?$_SESSION['qdtrange']:'';
    $qsearch_change = isset($_SESSION['qsearch_change'])?$_SESSION['qsearch_change']:'';

if($qsearch_change!='') {
      $sc = 'AND (q.quotation_code LIKE "%'.$qsearch_change.'%" OR au.displayname LIKE "%'.$qsearch_change.'%" OR c.customer_name LIKE "%'.$qsearch_change.'%")';
     
    }
    else {
      $sc = '';
    }

if($schange == '')
      $schange='all';

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

if($schange == 'all')
    {
      $data['drnge'] = '';
      $quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();
    }
    elseif($schange == 'today')
    {
      $quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') = CURDATE() $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();
    }
    else if($schange == 'thisweek')
    {
      $quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and YEARWEEK(STR_TO_DATE(q.quotation_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();
    }      
    else if($schange == 'thismonth')
    {
      $quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and MONTH(STR_TO_DATE(q.quotation_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();
    }
    else if($schange == 'thisyear')
    {
      
      $finstart = $_SESSION['finstart'];
      $finend = $_SESSION['finend'];

$quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid 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];
      $quotation_list = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();
    }

$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()->setCellValue('A1', 'Quotation No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Quotation Date');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Customer / Lead');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Grand Total');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Last Updated On');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Last Updated By');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Status');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($quotation_list as $u_list ) { 
      $qlist = $this->Quotation_model->get_quotation_view_by_id($u_list['qid']);
     if($u_list['customer_id']!=0)
    {
      $customer_list = $this->Quotation_model->get_customer_view_by_id($u_list['customer_id']);
      $cusDetails = $this->Quotation_model->get_customer_contact_details($u_list['customer_id']);
      $pno = $cusDetails->phone_no;
      if($customer_list->customer_type==2)
      {
        $ico = 'D';
      }
      else
      {
        $ico = 'C';
      }
      //$cusdet = $customer_list->customer_name.' - '.$pno;
      //$cusdetails = strlen($cusdet) > 15 ? substr($cusdet,0,15)."..." : $cusdet;
      $cusfdet = $customer_list->customer_code.' - '.$customer_list->customer_name.' - '.$pno;
      $conveted=1;
    }
    else if($u_list['lead_id']!=0)
    {
      $lead_list = $this->Quotation_model->get_lead_view_by_id($u_list['lead_id']);

$pno = $lead_list->contact_no;
      $ico = 'L';
      //$cusdet = $lead_list->lead_name.' - '.$pno;
      //$cusdetails = strlen($cusdet) > 15 ? substr($cusdet,0,15)."..." : $cusdet;
      $cusfdet = $lead_list->lead_no.' - '.$lead_list->lead_name.' - '.$pno;
      $conveted = $lead_list->converted;
    }
    else
    {
      $lead_list = $this->Quotation_model->get_dealer_view_by_id($u_list['dealer_id']);
      $pno = $lead_list->phone_no;
      $ico = 'D';
      //$cusdet = $lead_list->dealer_name.' - '.$pno;
      //$cusdetails = strlen($cusdet) > 15 ? substr($cusdet,0,15)."..." : $cusdet;
      $cusfdet = $lead_list->dealer_no.' - '.$lead_list->dealer_name.' - '.$pno;
      $conveted = 1;
    }
    $g_settings = general_setting_details();

$qfdate = $qlist->created_on;
    $qfby = $qlist->created_by;
    $qfbydet = $this->Quotation_model->get_admin_user_by_id($qfby);
    $qfbyname = $qfbydet->displayname;

$quotlist = $this->Quotation_model->get_quotation_view_by_id($u_list['qid']);

if($qlist->status==0)
      $status = 'Open';
    else
      $status = 'Ordered';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['quotation_code']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, date_format(date_create($quotlist->quotation_date),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $cusfdet.' - '.$ico);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $quotlist->grand_total);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, date_format(date_create($quotlist->created_on),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $quotlist->displayname);
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $status);

$i++;
    }

$filename='Quotation.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 index()
  { 
    $config = array();
    $config["base_url"] = base_url() . "quotation";
    $config["per_page"] = 10;
    $config["uri_segment"] = 2;
    $config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
    $config['full_tag_close'] = '</ul></div>';
    $config['num_tag_open'] = '<li class="page-item">';
    $config['num_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="page-item active"><a class="page-link" href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['next_tag_open'] = '<li class="page-item">';
    $config['next_tagl_close'] = '</a></li>';
    $config['prev_tag_open'] = '<li class="page-item">';
    $config['prev_tagl_close'] = '</li>';
    $config['first_tag_open'] = '<li class="page-item">';
    $config['first_tagl_close'] = '</li>';
    $config['last_tag_open'] = '<li class="page-item">';
    $config['last_tagl_close'] = '</a></li>';
    $config['attributes'] = array('class' => 'page-link');
    $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
    $perpage = $config['per_page'];
    /*if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      $catchange = $this->input->post('filterpcat');
      if($catchange!='')
        $ct = 'AND p.category_id='.$catchange;
      else
        $ct = '';
      $data['catchange'] = $catchange;
      $data['product_list'] = $this->db->query("SELECT p.*,pc.product_category FROM product p, product_category pc WHERE p.category_id = pc.product_category_id AND p.status=0 $ct")->result_array();
    }
    else
    {
      $data['catchange'] = '';
      $data['product_list'] = $this->Product_model->get_product_list();
    }*/

//$data['quotation_list'] = $this->Quotation_model->get_quotation_list();

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['qschange']) || isset($_SESSION['qdtrange']) || isset($_SESSION['qsearch_change']))))
    {
      $btn = $this->input->post('goButton');
      $this->session->set_userdata('qschange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['qschange']);
      $this->session->set_userdata('qdtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['qdtrange']);
      // $this->session->set_userdata('qsearch_change', $this->input->post('q_search')!=''?$this->input->post('q_search'):$_SESSION['qsearch_change']);
      $this->session->set_userdata('qsearch_change', $this->input->post('q_search'));

$schange = isset($_SESSION['qschange'])?$_SESSION['qschange']:$this->input->post('searchChange');
      //echo $schange;
      $dtrange = isset($_SESSION['qdtrange'])?$_SESSION['qdtrange']:$this->input->post('dtrange');

$qsearch_change = isset($_SESSION['qsearch_change'])?$_SESSION['qsearch_change']:$this->input->post('q_search');

// $qsearch_change = $this->input->post('q_search');
      // $_SESSION['qsearch_change'] = isset($_SESSION['qsearch_change'])?$_SESSION['qsearch_change']:$this->input->post('q_search');
      if($qsearch_change!='') {
        $sc = 'AND (q.quotation_code LIKE "%'.$qsearch_change.'%" OR au.displayname LIKE "%'.$qsearch_change.'%" OR c.customer_name LIKE "%'.$qsearch_change.'%")';
       
      }
      else {
        $sc = '';
      }

if($schange == '')
        $schange='all';

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

if($schange == 'all')
      {
        $data['drnge'] = '';
        $data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);
        $data['quotation_list'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
      }
      elseif($schange == 'today')
      {
        $data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') = CURDATE() $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);

$data['quotation_list'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') = CURDATE() $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
      }
      else if($schange == 'thisweek')
      {
        $data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and YEARWEEK(STR_TO_DATE(q.quotation_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);

$data['quotation_list'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and YEARWEEK(STR_TO_DATE(q.quotation_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
      }      
      else if($schange == 'thismonth')
      {
        $data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and MONTH(STR_TO_DATE(q.quotation_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);

$data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $data['qlist'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);

$data['quotation_list'] = $this->db->query("SELECT q.*,c.customer_name,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au, customer c WHERE q.created_by = au.id AND c.customer_id = q.customer_id AND q.status!=2 and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(q.quotation_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $sc GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
      }
      //echo $schange;exit;
      $data['purchasesearch'] = $schange;
      $data['drnge'] = $dtrange;
      $data['qsearch_change'] = $qsearch_change;
    }
    else
    {

$this->session->unset_userdata('qschange');
      $this->session->unset_userdata('qdtrange');
      $this->session->unset_userdata('qsearch_change');
      $data['purchasesearch'] = '';
      $data['drnge'] = '';

if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1){
          // $data['quotation_list'] = $this->Quotation_model->get_quotation_list();
          $data['qlist'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);
          
          $data['quotation_list'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
        }
        else{
          // $data['quotation_list'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
          $data['qlist'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 AND q.created_by = '".$_SESSION['user_id']."' GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);
          
          $data['quotation_list'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 AND q.created_by = '".$_SESSION['user_id']."' GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
        }
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        // $data['quotation_list'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
        $data['qlist'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 AND q.created_by = '".$_SESSION['user_id']."' GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

$config["total_rows"] = count($data['qlist']);
        
        $data['quotation_list'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 AND q.created_by = '".$_SESSION['user_id']."' GROUP BY q.parent_quotation_id ORDER BY qid DESC Limit $page, $perpage")->result_array();
      }
      else
      {
        // $data['quotation_list'] = $this->Quotation_model->get_super_user_quotation_list($_SESSION['company_id']);
        $data['qlist'] = $this->db->query("SELECT q.*,max(q.quotation_id) as qid,q.quotation_code,count(q.quotation_id) as qcount ,q.parent_quotation_id,au.displayname FROM `quotation` q, admin_users au WHERE q.created_by = au.id AND q.status!=2 AND q.company_id = '".$_SESSION['company_id']."' GROUP BY q.parent_quotation_id ORDER BY qid DESC")->result_array();

//$data['quotation_list'] = $this->Quotation_model->get_quotation_list();
    }

//$data['overall_quotation'] = $this->Quotation_model->get_quotation_list();
    if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
          $data['overall_quotation'] = $this->Quotation_model->get_quotation_list();
        else
          $data['overall_quotation'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        $data['overall_quotation'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
      }
      else
      {
        $data['overall_quotation'] = $this->Quotation_model->get_super_user_quotation_list($_SESSION['company_id']);
      }
    $this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    $this->load->view('quotation/quotation_list',$data);
  }

public function getDealerDiscountPercentage()
  {
    $did = $_POST['did'];
    $dealer_list = $this->Quotation_model->get_dealer_view_by_id($did);
    echo $dealer_list->discount_percentage."|".$dealer_list->state_id;
  }

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

public function getLeadCountry()
  {
    $did = $_POST['did'];
    $lead_list = $this->Quotation_model->get_lead_view_by_id($did);
    echo $lead_list->state_id;
  }

public function quotation_add()
  {
    $data['customer_list'] = $this->Quotation_model->get_customer_list();
    $data['lead_list'] = $this->Quotation_model->get_lead_list();
    $data['dealer_list'] = $this->Quotation_model->get_dealer_list();
    $data['category_list'] = $this->Quotation_model->get_category_list();
    $data['uom_list'] = $this->Quotation_model->get_uom_list();
    $data['payment_term'] = $this->Quotation_model->get_quotation_payment_term();
    $data['delivery_term'] = $this->Quotation_model->get_quotation_delivery_term();
    $data['application'] = $this->Quotation_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    $data['bank_list'] = $this->Quotation_model->get_active_bank_list();
    $data['state_list'] = $this->Quotation_model->get_state_list();
    //$data['product_list'] = $this->Quotation_model->get_product_list();
    $data['whatsapp_configuration'] = general_setting_details();

//$data['company_list'] = company_list();
    if($_SESSION['company_id']==0)
      $data['company_list'] = $this->Quotation_model->get_location();
    else
      $data['company_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);

$this->load->view('quotation/quotation_add',$data);
  }

public function getPriceFormula()
  {
    $uom_id = $_POST['uom_id'];
    $result = $this->Quotation_model->get_price_formula_by_uom_id($uom_id);
    echo $result->price_formula_id."|".$result->price_unit;
  }

public function getProduct()
  {
    $cat_id = $_POST['cat_id'];
    $compId = $_POST['compId'];
    $product = $this->Quotation_model->get_product_by_category_location_id($cat_id,$compId);
    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 getProductDetails()
  {
    $prod_id = $_POST['prod_id'];
    $product = $this->Quotation_model->get_product_details_by_id($prod_id);
    echo $product->uom."|".$product->uom_id."|".$product->unit_price."|".$product->price_formula."|".$product->type_id."|".$product->is_purchase."|".$product->gst;
  }

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($pf_id==3)
    {
      $price = (($csl*$csw)/144)*$rpsf;
    }
    else
    {
      $price = $csl*$csw*$rpsf;
    }
    $rate = $price*$qty;*/
    if($csl!=0 && $csw!=0)
    {
      $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;
      }
      /*if($pf_id==3)
      {
        $price = (($csl*$csw)/144)*$rpsf;
      }
      else
      {
        $price = $csl*$csw*$rpsf;
      }*/
      //$rate = $price*$qty;
    }
    else
    {
      $rate = $rpsf*$qty;
    }
    echo $rate;
  }

public function create_quotation()
  {
    $whatsapp_configuration = general_setting_details();
    $printQtn = $this->input->post('print_quotation');
    $emailQtn = $this->input->post('mail_quotation');
    $smsQtn = $this->input->post('sms_quotation');
    if($whatsapp_configuration->is_whatsapp_enable==1)
      $wapQtn = $this->input->post('whatsapp_quotation');
    else
      $wapQtn = 0;
    $last_id_value = $this->Quotation_model->last_quotation_code();
    if(count($last_id_value)==0)
      $last_value = 0;
    else
    {
      $last_value = intval(substr($last_id_value->quotation_code,4));
    }
    $next_value = $last_value + 1;
    $quotation_id = $next_value;
    $data['quotation_code'] = 'QTN-'.$quotation_id;

$customer_type=$this->input->post('customer_t');
    if($customer_type=='Customer')
    {
      $data['customer_id'] = $this->input->post('customer_id');
      $data['lead_id'] = 0;
      $data['dealer_id'] = 0;
    }
    else if($customer_type=='Lead')
    {
      $data['customer_id'] = 0;
      $data['lead_id'] = $this->input->post('lead_id');
      $data['dealer_id'] = 0;
    }
    else
    {      
      $data['customer_id'] = 0;
      $data['lead_id'] = 0;
      $data['dealer_id'] = $this->input->post('dealer_id');
    }
    $qdt = explode('/', $this->input->post('quotation_date'));
    $data['quotation_date'] = $qdt[2].'-'.$qdt[0].'-'.$qdt[1];
    $vdt = explode('/', $this->input->post('validity_date'));
    $data['validity_date'] = $vdt[2].'-'.$vdt[0].'-'.$vdt[1];
    $data['revised'] = 0;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $last_id_value = $this->Quotation_model->last_id();
    if(count($last_id_value)>0)
    {
      $last_value=$last_id_value->count_val;
      $data['parent_quotation_id'] = $last_value+1;
    }
    else
    {
      $data['parent_quotation_id'] = 1;
    }
    $data['taxable_amount'] = $this->input->post('taxable_amount');
    $data['total_tax'] = $this->input->post('total_tax');
    $data['round_off'] = $this->input->post('round_off');
    $data['grand_total'] = $this->input->post('grand_total');
    $data['payment_term_id'] = $this->input->post('payment_term_id');
    $data['delivery_term_id'] = $this->input->post('delivery_term_id');
    $data['application_id'] = $this->input->post('application_id');
    $data['reference_id'] = $this->input->post('reference_id');
    $data['f_o_r'] = $this->input->post('f_o_r');
    $data['bank_ids'] = implode(",",$this->input->post('bank_ids'));
    $data['disc_percent'] = $this->input->post('disc_percent');
    $data['disc_amount'] = $this->input->post('disc_amount');
    $data['supply_from'] = $this->input->post('supply_from');
    $data['supply_to'] = $this->input->post('supply_to');
    $data['packing_charges'] = $this->input->post('packing_charges');
    $data['other_charges'] = $this->input->post('other_charges');
    $data['remarks'] = $this->input->post('remarks');
    $data['company_id'] = $this->input->post('company_id');
    //print_r($data);exit;
    
    $result = $this->Quotation_model->create_quotation($data);

if ($result) {
      $last_id_value = $this->Quotation_model->last_id();
      $last_value=$last_id_value->count_val;
      $data1['quotation_id'] = $last_value;

$cid = explode(",",implode(",",$this->input->post('category_id')));
      $pid = explode(",",implode(",",$this->input->post('product_id')));
      $uid = explode(",",implode(",",$this->input->post('uom_id')));
      $uom = explode(",",implode(",",$this->input->post('uom')));
      $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')));
      $ptid = explode(",",implode(",",$this->input->post('product_type_id')));
      $pgst = explode(",",implode(",",$this->input->post('product_gst')));
      $subcount = count($this->input->post('category_id')); 
      for($i=0;$i<$subcount;$i++)
      {
        if($cid[$i] != ''){
          $data1['category_id'] = $cid[$i];
          $data1['product_id'] = $pid[$i];
          $data1['uom_id'] = $uid[$i];
          $data1['uom'] = $uom[$i];
          $data1['price_formula_id'] = $pfid[$i];
          $data1['cut_size_length'] = $csl[$i];
          $data1['cut_size_width'] = $csw[$i];
          $data1['cut_size_height'] = 0;
          $data1['finish_size_length'] = $fsl[$i];
          $data1['finish_size_width'] = $fsw[$i];
          $data1['finish_size_height'] = 0;
          $data1['rate_per_sqft'] = $rpsq[$i];
          $data1['quantity'] = $qty[$i];
          $data1['rate'] = $rate[$i];
          $data1['disc'] = $disc[$i];
          $data1['amount'] = $amt[$i];
          $data1['product_type_id'] = $ptid[$i];
          $data1['product_gst'] = $pgst[$i];
          $this->Quotation_model->create_quotation_product($data1);
        }
      }

$pdata['qlist'] = $qlist = $this->Quotation_model->get_quotation_view_by_id($last_value);
      if($qlist->customer_id!=0)
      {
        $pdata['customer_list'] = $customer_list = $this->Quotation_model->get_customer_view_by_id($qlist->customer_id);
        $cusemail = $this->Quotation_model->get_customer_email_by_id($qlist->customer_id);
        $cusphone = $this->Quotation_model->get_customer_contact_details($qlist->customer_id);
        $cphone = $cusphone->phone_no;
        $cname = $customer_list->customer_name;
        $pcode = $customer_list->pincode;
        $gst = $customer_list->gst_no;
        $cus_address = $pdata['cus_address'] = $this->Quotation_model->get_customer_address($qlist->customer_id);
        if(count($cusemail)>0)
        {
          $cemail = $cusemail->email;
        }
        else
        {
          $cemail = '';
        }

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

}
      else if($qlist->lead_id!=0)
      {
        $pdata['lead_list'] = $lead_list = $this->Quotation_model->get_lead_view_by_id($qlist->lead_id);
        $cname = $lead_list->lead_name;
        $cphone = $lead_list->contact_no;
        $pcode = $lead_list->pincode;
        $gst = '';
        $sadd = $pdata['sadd'] = $lead_list->address;
        $badd = $pdata['badd'] = $lead_list->address;
        if($lead_list->email_id!='')
        {
          $cemail = $lead_list->email_id;
        }
        else
        {
          $cemail = '';
        }
      }
      else
      {
        $pdata['dealer_list'] = $dealer_list = $this->Quotation_model->get_dealer_view_by_id($qlist->dealer_id);
        $cname = $dealer_list->dealer_name;
        $cphone = $dealer_list->phone_no;
        $pcode = '';
        $gst = '';
        $badd = $pdata['badd'] = $dealer_list->address;
        $sadd = $pdata['sadd'] = $dealer_list->address;
        if($dealer_list->email_id!='')
        {
          $cemail = $dealer_list->email_id;
        }
        else
        {
          $cemail = '';
        }
      }
      $pdata['quotation_product'] = $quotation_product = $this->Quotation_model->get_quotation_product_by_id($last_value);

$pdata['general_setting'] = $general_setting = $this->Quotation_model->get_general_settings_details();

$tc = $pdata['terms_and_conditions'] = $this->Quotation_model->get_quotation_terms_and_conditions();

$html = '';
if($pcode!='' || $pcode!=0)
  $pcode = $pcode;
else
  $pcode = '';

$sfrom = $this->Quotation_model->get_state_by_id($qlist->supply_from);
$sto = $this->Quotation_model->get_state_by_id($qlist->supply_to);

$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;font-size:20px;">QUOTATION / PROFORM</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%;">'.$cname.' - '.$cphone.'</td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$badd.' '.$pcode.'</td>
                        </tr>';
                        if($gst!=''){
                        $html.='<tr>
                            <td style="width:100%;">GSTIN : '.$gst.'</td>
                        </tr>';
                      }
                        $html.='<tr>
                            <td style="width:100%;"></td>
                        </tr>                        
                        <tr>
                            <td style="width:100%;"><b>Shipped To</b></td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$cname.' - '.$cphone.'</td>
                        </tr>
                        <tr>
                            <td style="width:100%;">'.$sadd.' '.$pcode.'</td>
                        </tr>
                    </table>
                </div>';
                $g_settings = general_setting_details(); 
                $qdate = date_format(date_create($qlist->quotation_date),$g_settings->date_format); 
                $vdate = date_format(date_create($qlist->validity_date),$g_settings->date_format); 
                $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>Quotation No</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$qlist->quotation_code.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Quotation Date</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$qdate.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Valid Upto</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$vdate.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Your Reference</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$qlist->reference.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Supply From</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$sfrom->state.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Supply To</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:60%;">'.$sto->state.'</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>';
                      if($qlist->supply_to==33){
                      $html.='<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>';
                    }else{
                      $html.='<th>IGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>';
                    }
                      $html.='<th>Total Amount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</th>
                  </tr></thead><tbody>';
                  $taxamt=0;$tottax=0;$i=1;foreach($quotation_product 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);

$uomlist = $this->Quotation_model->get_uom_by_id($oprod['uom_id']);

if($oprod['product_type_id']==2)
                    {
                      $size = 'Cut Size '.number_format($oprod['cut_size_length'],2).'x'.number_format($oprod['cut_size_width'],2).'x'.number_format($oprod['cut_size_height'],2).' '.$uomlist->uom.'; Finish Size '.number_format($oprod['finish_size_length'],2).'x'.number_format($oprod['finish_size_width'],2).'x'.number_format($oprod['finish_size_height'],2).' '.$uomlist->uom;
                    }
                    else
                      $size = '';

$html.='
                  <tr>
                    <td>'.$i.'</td>
                    <td>'.$oprod['hsn_code'].'</td>
                    <td>'.$oprod['product_name'].'_'.$oprod['brand'].'_'.$oprod['description'].' '.$size.'</td>
                    <td>'.$oprod['quantity'].'</td>
                    <td>'.$oprod['rate']/$oprod['quantity'].'</td>
                    <td>'.$oprod['disc'].'</td>
                    <td>'.$oprod['amount'].'</td>';
                    if($qlist->supply_to==33){
                    $html.='<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>';
                  }else{
                    $igst = $sgst+$cgst;
                    $html.='<td><table><tr><td>'.$igst.'</td></tr></table><table><tr><td>@'.number_format($oprod['gst']*2, 2).'%</td></tr></table></td>';
                  }
                    $html.='<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($qlist->payment_term_id!=0)
            {
              $ptem = $this->Quotation_model->get_patyment_term_by_id($qlist->payment_term_id);
              $payterm = $ptem->payment_term;
            }
            else
            {
              $payterm = '-';
            }
            if($qlist->delivery_term_id!=0)
            {
              $dtem = $this->Quotation_model->get_delivery_term_by_id($qlist->delivery_term_id);
              $delterm = $dtem->delivery_term;
            }
            else
            {
              $delterm = '-';
            }
            $bids = explode(',', $qlist->bank_ids);
            $html.='<div style="width:100%;float:left;margin-bottom:15px;">
                <div style="width:55%;float:left;border:1px solid #ddd;padding:10px;">
                    <table style="width:100%;">
                        <tr>
                            <td style="width:30%;"><b>F.O.R</b></td>
                            <td style="width:2%;">:</td>
                            <td style="width:68%;">'.$qlist->f_o_r.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Payment Terms</b></td>
                            <td style="width:2%;">:</td>
                            <td style="width:68%;">'.$payterm.'</td>
                        </tr>
                        <tr>
                            <td style="width:30%;"><b>Delivery Terms</b></td>
                            <td style="width:2%;">:</td>
                            <td style="width:68%;">'.$delterm.'</td>
                        </tr>';
                        $i=0; foreach ($bids as $bid){
                            $bdet = $this->Quotation_model->get_bank_by_id($bid);
                        $html.='<tr>
                            <td style="width:30%;"><b>Bank A/c Details '.($i+1).'</b></td>
                            <td style="width:2%;">:</td>
                            <td style="width:68%;">                                
                                <table style="width:100%">
                                    <tr>
                                        <td style="width:20%;">Account</td>
                                        <td style="width:10%;">:</td>
                                        <td style="width:70%;">'.$bdet->account_name.'</td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="width:30%;"></td>
                            <td style="width:10%;"></td>
                            <td style="width:60%;"> 
                                <table style="width:100%">
                                    <tr>
                                        <td style="width:20%;">Bank</td>
                                        <td style="width:10%;">:</td>
                                        <td style="width:70%;">'.$bdet->bank_name.'</td>
                                    </tr>
                                    <tr>
                                        <td style="width:20%;">Branch</td>
                                        <td style="width:10%;">:</td>
                                        <td style="width:70%;">'.$bdet->branch_name.'</td>
                                    </tr>
                                    <tr>
                                        <td style="width:20%;">Account No</td>
                                        <td style="width:10%;">:</td>
                                        <td style="width:70%;">'.$bdet->account_no.'</td>
                                    </tr>
                                    <tr>
                                        <td style="width:20%;">IFSC Code</td>
                                        <td style="width:10%;">:</td>
                                        <td style="width:70%;">'.$bdet->ifsc_code.'</td>
                                    </tr>
                                </table>
                            </td>
                        </tr>';
                      $i++;}
                    $html.='</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>Packing & Forwarding Charges ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($qlist->packing_charges, 2).'</td>
                        </tr>
                        <tr>
                            <td style="width:40%;"><b>Other Charges ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($qlist->other_charges, 2).'</td>
                        </tr>';
                        if($qlist->supply_to==33){
                        $html.='<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($qlist->total_tax/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($qlist->total_tax/2, 2).'</td>
                        </tr>';
                      }else{
                        $html.='<tr>
                            <td style="width:40%;"><b>IGST ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($qlist->total_tax, 2).'</td>
                        </tr>';
                      }if($qlist->disc_amount!=0){
                        $html.='<tr>
                            <td style="width:40%;"><b>Discount ( <span style="font-family: DejaVu Sans; sans-serif;">&#8377;</span> )</b></td>
                            <td style="width:10%;">:</td>
                            <td style="width:50%;">'.number_format($qlist->disc_amount, 2).'</td>
                        </tr>';
                      }
                        $html.='<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%;">'.$qlist->round_off.'</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($qlist->grand_total, 2).'</td>
                        </tr>
                    </table>
                </div>
            </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();
//file_put_contents("pdf/register_$userid.pdf", $output);
//file_put_contents("pdfbill/".$cusName."_".$cusCity."_".$bill_id.".pdf", $output);
file_put_contents("pdfquotation/".str_replace(' ', '', str_replace('/', '', $cname))."_".$last_value.".pdf", $output);

if($smsQtn==1)
{
  $genset = $this->Quotation_model->get_general_settings_details();
  $nlcontent = $this->Quotation_model->get_new_quotation_msg();
  $content = $nlcontent->sms_content;
  $content = str_replace('#name#', ucwords($cname), $content);
  $content = str_replace('#quotationId#', $last_value, $content);
  sendsms($cphone,$content,$genset->sms_auth_key,$genset->sms_sender_id);
}

if($wapQtn==1)
{
  $genset = $this->Quotation_model->get_general_settings_details();
  $wpcontent = $this->Quotation_model->get_new_quotaion_whatsappmsg();
  $wapcontent = $wpcontent->whatsapp_content;
  $wapcontent = str_replace('#name#', ucwords($cname), $wapcontent);
  $wapcontent = str_replace('#quotationId#', $last_value, $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!='')
  {
    $attched_file= site_url()."pdfquotation/".str_replace(' ', '', str_replace('/', '', $cname))."_".$last_value.".pdf";
    $mcRes = $this->Quotation_model->get_general_settings_details();

//$smtp_pwd = $this->aes128Decrypt('arjunerp', $mcRes->smtp_password);   
    $smtp_pwd = decryptthis($mcRes->smtp_password,'arjunerp');
    $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->Quotation_model->quotation_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('#quotationId#', $last_value, $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', 'Qutotation has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    //redirect('/quotation');
    if($printQtn==1)
      $this->load->view('quotation/printview',$pdata);
    else
      redirect('/quotation');
  }

/*public function quotation_view($id)
  {
    $quotId = $data['quotation_list'] = $this->Quotation_model->get_quotation_view_by_id($id);
    if($quotId->customer_id!=0)
      $data['customer_list'] = $this->Quotation_model->get_customer_view_by_id($quotId->customer_id);
    else
      $data['lead_list'] = $this->Quotation_model->get_lead_view_by_id($quotId->lead_id);
    $data['quotation_product'] = $this->Quotation_model->get_quotation_product_by_id($id);
    $this->load->view('quotation/quotation_view',$data);
  }*/

public function quotation_view($id)
  {
    $quot['quotation_id'] = $id;
    $quotlist = $this->Quotation_model->get_quotation_view_by_id($id);
    $qcode = $quotlist->quotation_code;

if(strpos($qcode, '/') !== false)
    {
      $exp = explode('/', $qcode);
      $baseqno = $exp[0];
      $rqno = $exp[0].'/';
    }
    else
    {
      $baseqno = $qcode;
      $crev = $this->Quotation_model->getCheckRevQuotation($baseqno);
      if(count($crev)>0)
        $rqno=$qcode.'/';
      else
        $rqno='';
    }

if($rqno!='')
    {
      $quot['quotation_list'] = $this->Quotation_model->getViewRevQuotationList($baseqno,$rqno);
    }
    else
    {
      $quot['quotation_list'] = $this->Quotation_model->getViewQuotationList($baseqno);
    }

$this->load->view('quotation/quotation_view',$quot);
  }

public function quotation_edit($id)
  {
    $quotId = $data['quotation_list'] = $this->Quotation_model->get_quotation_view_by_id($id);
    if($quotId->customer_id!=0)
      $data['customer_list'] = $this->Quotation_model->get_customer_view_by_id($quotId->customer_id);
    elseif($quotId->lead_id!=0)
      $data['lead_list'] = $this->Quotation_model->get_lead_view_by_id($quotId->lead_id);
    else
      $data['dealer_list'] = $this->Quotation_model->get_dealer_view_by_id($quotId->dealer_id);
    $data['quotation_product'] = $this->Quotation_model->get_quotation_product_by_id($id);

$data['category_list'] = $this->Quotation_model->get_category_list();
    $data['uom_list'] = $this->Quotation_model->get_uom_list();
    $data['payment_term'] = $this->Quotation_model->get_quotation_payment_term();
    $data['delivery_term'] = $this->Quotation_model->get_quotation_delivery_term();
    $data['application'] = $this->Quotation_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    $data['bank_list'] = $this->Quotation_model->get_active_bank_list();
    $data['state_list'] = $this->Quotation_model->get_state_list();

$data['whatsapp_configuration'] = general_setting_details();

//$data['company_list'] = company_list();
    
    //$data['company_list'] = $this->Quotation_model->get_location();
    
    if($_SESSION['company_id']==0)
      $data['company_list'] = $this->Quotation_model->get_location();
    else
      $data['company_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);

$this->load->view('quotation/quotation_edit',$data);
  }

public function update_quotation()
  {
    $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;
    $qtncode = $this->input->post('quotation_code');
    $qtn_id = $this->input->post('quotation_id');
    if(strpos($qtncode, '/') !== false)
    {
      $exp = explode('/', $qtncode);
        $tval = $exp[1]+1;
        $data['quotation_code'] = $exp[0].'/'.$tval;
    }
    else
    {
      $data['quotation_code'] = $qtncode.'/1';
    }

$data['customer_id'] = $this->input->post('customer_id');
    $data['lead_id'] = $this->input->post('lead_id');
    $data['dealer_id'] = $this->input->post('dealer_id');
    $qdt = explode('/', $this->input->post('quotation_date'));
    $data['quotation_date'] = $qdt[2].'-'.$qdt[0].'-'.$qdt[1];
    $vdt = explode('/', $this->input->post('validity_date'));
    $data['validity_date'] = $vdt[2].'-'.$vdt[0].'-'.$vdt[1];
    $data['revised'] = 1;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['parent_quotation_id'] = $this->input->post('parent_quotation_id');
    $data['taxable_amount'] = $this->input->post('taxable_amount');
    $data['total_tax'] = $this->input->post('total_tax');
    $data['round_off'] = $this->input->post('round_off');
    $data['grand_total'] = $this->input->post('grand_total');
    $data['payment_term_id'] = $this->input->post('payment_term_id');
    $data['delivery_term_id'] = $this->input->post('delivery_term_id');
    $data['application_id'] = $this->input->post('application_id');
    $data['reference_id'] = $this->input->post('reference_id');
    $data['f_o_r'] = $this->input->post('f_o_r');
    $data['bank_ids'] = implode(",",$this->input->post('bank_ids'));
    $data['disc_percent'] = $this->input->post('disc_percent');
    $data['disc_amount'] = $this->input->post('disc_amount');
    $data['supply_from'] = $this->input->post('supply_from');
    $data['supply_to'] = $this->input->post('supply_to');
    $data['packing_charges'] = $this->input->post('packing_charges');
    $data['other_charges'] = $this->input->post('other_charges');
    $data['remarks'] = $this->input->post('remarks');
    $data['company_id'] = $this->input->post('company_id');
    
    $result = $this->Quotation_model->create_quotation($data);

if ($result) {
      $last_id_value = $this->Quotation_model->last_id();
      $last_value=$last_id_value->count_val;
      $data1['quotation_id'] = $last_value;

$data2['parent'] = 1;
      $data2['quotation_id'] = $qtn_id;
      $data2['modified_on'] = date('Y-m-d H:i:s');
      $data2['modified_by'] = $_SESSION['user_id'];
      $this->Quotation_model->update_quotation_parent($data2);

$pdata['qlist'] = $qlist = $this->Quotation_model->get_quotation_view_by_id($last_value);
      if($qlist->customer_id!=0)
      {
        $pdata['customer_list'] = $customer_list = $this->Quotation_model->get_customer_view_by_id($qlist->customer_id);
        $cusemail = $this->Quotation_model->get_customer_email_by_id($qlist->customer_id);
        $cusphone = $this->Quotation_model->get_customer_contact_details($qlist->customer_id);
        $cphone = $cusphone->phone_no;
        $pcode = $customer_list->pincode;
        $gst = $customer_list->gst_no;
        $cus_address = $pdata['cus_address'] = $this->Quotation_model->get_customer_address($qlist->customer_id);
        $cname = $customer_list->customer_name;
        if(count($cusemail)>0)
        {
          $cemail = $cusemail->email;
        }
        else
        {
          $cemail = '';
        }

$pdata['general_setting'] = $general_setting = $this->Quotation_model->get_general_settings_details();

$tc = $pdata['terms_and_conditions'] = $this->Quotation_model->get_quotation_terms_and_conditions();

$html = '';
if($pcode!='' || $pcode!=0)
  $pcode = $pcode;
else
  $pcode = '';

$sfrom = $this->Quotation_model->get_state_by_id($qlist->supply_from);
$sto = $this->Quotation_model->get_state_by_id($qlist->supply_to);

$uomlist = $this->Quotation_model->get_uom_by_id($oprod['uom_id']);

if(count($tc)>0){

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

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

$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('#quotationId#', $last_value, $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', 'Qutotation has been revised successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    //redirect('/quotation');
    //$this->load->view('quotation/printview',$pdata);
    if($printQtn==1)
      $this->load->view('quotation/printview',$pdata);
    else
      redirect('/quotation');
  }

public function quotation_print($id)
  {
    $pdata['qlist'] = $qlist = $this->Quotation_model->get_quotation_view_by_id($id);
    $tc = $pdata['terms_and_conditions'] = $this->Quotation_model->get_quotation_terms_and_conditions();
    if($qlist->customer_id!=0)
    {
      $pdata['customer_list'] = $customer_list = $this->Quotation_model->get_customer_view_by_id($qlist->customer_id);
      $cname = $customer_list->customer_name;
      $cus_id = $qlist->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Quotation_model->get_customer_address($cus_id);
      $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;
      }
    }
    else if($qlist->lead_id!=0)
    {
      $pdata['lead_list'] = $lead_list = $this->Quotation_model->get_lead_view_by_id($qlist->lead_id);
      $cname = $lead_list->lead_name;
      $pdata['badd'] = $lead_list->address;
      $pdata['sadd'] = $lead_list->address;
    }
    else
    {
      $pdata['dealer_list'] = $dealer_list = $this->Quotation_model->get_dealer_view_by_id($qlist->dealer_id);
      $cname = $dealer_list->dealer_name;
      $pdata['badd'] = $dealer_list->address;
      $pdata['sadd'] = $dealer_list->address;
    }
    $pdata['quotation_product'] = $quotation_product = $this->Quotation_model->get_quotation_product_by_id($id);

$pdata['general_setting'] = $general_setting = $this->Quotation_model->get_general_settings_details();

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

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 conv_order()
{
  $lid = $data['bid']=$_POST['id'];
  $this->load->view('quotation/convert_order',$data);
}

public function convert_order()
{
  $id = $this->input->post('quotation_id');
  $qlist = $this->Quotation_model->get_quotation_view_by_id($id);
  //$quotation_product = $this->Quotation_model->get_quotation_product_by_id($id);
  $product_type = $this->Quotation_model->get_product_type_list();
  $cus_id = $qlist->customer_id;
  if($qlist->customer_id==0)
  {
    $customer = $this->Quotation_model->get_customer_by_lead_id($qlist->lead_id);
    $cus_id = $customer->customer_id;
  }
  $l_user = login_user_details($_SESSION['user_id']);
  $data['customer_id'] = $cus_id;
  $locId = $data['location_id'] = $qlist->company_id;
  $data['order_date'] = date('Y-m-d');
  $data['del_date'] = date("Y-m-d H:i", strtotime("+ 5 day"));
  $data['payment_term_id'] = 0;
  $data['delivery_term_id'] = 0;
  $data['transport'] = '';
  $data['booking_place'] = '';
  $data['incharge'] = $l_user->displayname;
  $data['advance_amount'] = 0;
  $data['created_by'] = $_SESSION['user_id'];
  $data['delivery_permission_id'] = 1;
  $iscpo = $data['is_customer_po'] = $this->input->post('is_customer_po');
  //$data['customer_po_no'] = '';
  //$data['customer_po_bill'] = '';
  $data['application_id'] = $qlist->application_id;
  $data['reference_id'] = $qlist->reference_id;
  $data['supply_from'] = $qlist->supply_from;
  $data['supply_to'] = $qlist->supply_to;
  $data['packing_charges'] = $qlist->packing_charges;
  $data['other_charges'] = $qlist->other_charges;
  $data['remarks'] = $qlist->remarks;
  $data['eyelets'] = 0;

if($iscpo==1)
    {
      $rmnorep = str_replace('/', '-', $ono);
      $data['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();
          $data['customer_po_bill'] = $profileName;
        }
        else
        {
          $data['customer_po_bill'] = '';
        }
      }
      else
      {
        $data['customer_po_bill'] = '';
      }
    }
    else
    {
      $data['customer_po_no'] = '';
      $data['customer_po_bill'] = '';
    }

$punit = $data['prod_unit'] = $this->input->post('prod_unit');

foreach($product_type as $ptype)
  {
    $quotation_product = $this->Quotation_model->get_quotaion_product_by_ptype_id($ptype['product_type_id'],$id);
    if(count($quotation_product)>0)
    {
      $data['product_type_id'] = $ptype['product_type_id'];
      $data['created_on'] = date('Y-m-d H:i:s');
      $last_id_value = $this->Order_model->last_order_id_by_unit($punit);

if(count($last_id_value)==0)
      {
        //$data['order_no'] = date("Y").'/'.date('m').'/SO001';
        if($punit=='unit1')
          $ono = $data['order_no'] = date("Y").'/'.date('m').'/U1/SO001';
        else
          $ono = $data['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;
        //$data['order_no'] = date("Y").'/'.date('m').'/SO'.$nval;
        if($punit=='unit1')
          $ono = $data['order_no'] = date("Y").'/'.date('m').'/U1/SO'.$nval;
        else
          $ono = $data['order_no'] = date("Y").'/'.date('m').'/U2/SO'.$nval;
      }
      /*$data['taxable_amount'] = 0;
      $data['total_tax'] = 0;
      $data['round_off'] = '';
      $data['grand_total'] = 0;
      $data['balance_amount'] = 0;*/
      $data['taxable_amount'] = $qlist->taxable_amount;
      $data['total_tax'] = $qlist->total_tax;
      $data['round_off'] = $qlist->round_off;
      $data['grand_total'] = $qlist->grand_total;
      $data['balance_amount'] = $qlist->grand_total;
      $data['quotation_id'] = $id;

$result = $this->Order_model->create_order($data);
      if($result)
      {
        $last_id_value = $this->Order_model->last_order_id();
        $last_value=$last_id_value->order_id;
        $oid = $ordprod['order_id'] = $last_value;
        $taxamt = 0;
        $tottax = 0;
        foreach($quotation_product as $qprod)
        {
          $ordprod['product_id'] = $qprod['product_id'];
          $ordprod['uom_id'] = $qprod['uom_id'];
          $ordprod['product_type_id'] = $qprod['product_type_id'];
          $ordprod['product_gst'] = $qprod['product_gst'];
          $ordprod['price_formula_id'] = $qprod['price_formula_id'];
          $ordprod['cut_size_length'] = $qprod['cut_size_length'];
          $ordprod['cut_size_width'] = $qprod['cut_size_width'];
          $ordprod['cut_size_height'] = $qprod['cut_size_height'];
          $ordprod['finish_size_length'] = $qprod['finish_size_length'];
          $ordprod['finish_size_width'] = $qprod['finish_size_width'];
          $ordprod['finish_size_height'] = $qprod['finish_size_height'];
          $ordprod['rate_per_sqft'] = $qprod['rate_per_sqft'];
          $ordprod['quantity'] = $qprod['quantity'];
          $ordprod['rate'] = $qprod['rate'];
          $ordprod['disc'] = $qprod['disc'];
          $ordprod['amount'] = $qprod['amount'];

if($qprod['product_type_id']==1)
          {
            /*$locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$qprod['product_type_id']);
            if(count($locproduct)>0)
            {
              $lpqty = $locproduct[0]['stock'];
              $dedstock = $lpqty - $qprod['quantity'];

$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+$qprod['quantity'];
                $bstock = $qprod['quantity'];
                $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=$qprod['quantity'];
              $np = $qprod['quantity'];
              $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);
          
          $tottax+= (($qprod['amount']*$qprod['product_gst'])/100)*2;
          $taxamt+= $qprod['amount'];
          $gtot = round($tottax+$taxamt);
          $roff = $gtot - ($tottax+$taxamt);
        }

/*$uporder['taxable_amount'] = $taxamt;
        $uporder['total_tax'] = $tottax;
        $uporder['round_off'] = $roff;
        $uporder['grand_total'] = $gtot;
        $uporder['balance_amount'] = $gtot;
        $uporder['order_id'] = $oid;
        $this->Quotation_model->update_quotaion_order($uporder);*/
      }

}
  }

$qsts['status']=1;
  $this->Quotation_model->change_quotation_status($qsts,$id);
  
  $this->session->set_flashdata('add_success', 'Qutotation has been conveted to Order successfully.');
  redirect('/quotation');

}

public function lead_customer()
{
  $lid=$_POST['lid'];
  $data['qid'] = $qid = $_POST['qid'];
  $logid = $_SESSION['user_id'];
  $data['log_user'] = $this->Lead_model->user_view_details($logid);
  $data['lead_list'] = $this->Lead_model->get_lead_view_by_id($lid);
  //$data['lead_product'] = $this->Lead_model->get_lead_product_by_id($lid);

$data['customer_type'] = $this->Customer_model->get_customer_type();
  $data['customer_category'] = $this->Customer_model->get_customer_category();
  $data['email_type'] = $this->Customer_model->get_email_type();
  $data['phone_type'] = $this->Customer_model->get_phone_type();
  $data['address_type'] = $this->Customer_model->get_address_type();
  $data['product_list'] = $this->Customer_model->get_active_products();
  $data['state_list'] = $this->Customer_model->get_state_list();

$this->load->view('quotation/convert_customer',$data);
}

public function convert_customer()
  {

$lead_id = $this->input->post('cust_lead_id');
    $lead_list = $this->Lead_model->get_lead_view_by_id($lead_id);
    $this->Lead_model->change_lead_to_cust_status($lead_id);

$checkcustomer = $this->Customer_model->customer_phone_no_unique($lead_list->contact_no);
    if(count($checkcustomer)==0)
    {
      $last_id_value = $this->Customer_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['customer_code'] = date("Y").'/'.date('m').'/CUS001';
    }
    else
    {
      $lno = $last_id_value->customer_code;
      $exlno = substr($lno,11);
      $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;
      $data['customer_code'] = date("Y").'/'.date('m').'/CUS'.$nval;
    }

$customerName = $data['customer_name']=$this->input->post('customer_name');
    $data['customer_type']=$this->input->post('customer_type');
    $data['customer_category']=$this->input->post('customer_category');
    $data['company_name']=$this->input->post('company_name');
    $data['pan_no']=$this->input->post('pan_no');
    $data['gst_no']=$this->input->post('gst_no');
    $data['address']=$this->input->post('comp_address');
    $data['website']=$this->input->post('website');
    $data['bank_name']='';
    $data['branch_name']='';
    $data['account_no']='';
    $data['payment_term']=0;
    $data['lead_id'] = $lead_id;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    /*if($this->input->post('intrested_products')!='')
    {
      $data['intrested_products'] = implode(",",$this->input->post('intrested_products'));
    }
    else
    {
      $data['intrested_products'] = '';
    }*/
    $data['intrested_products'] = '';
    $data['state_id']=$this->input->post('state_id'); 
    $data['pincode']=$this->input->post('pincode');

$data['discount_percentage']=0;
    $data['opening_balance']=0;
    $data['crdr']=0;
    $data['is_sister_concern']=0;
    $data['sister_concern_location_id']=0;
    
    $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;

/*if($this->input->post('email_type_id')!='')
      {
        $etid = explode(",",implode(",",$this->input->post('email_type_id')));
        $eid = explode(",",implode(",",$this->input->post('email_id')));

$subcount = count($this->input->post('email_type_id'));      
          $data1['customer_id'] =  $customer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($etid[$i] != ''){
            $data1['email_type_id'] = $etid[$i];
            $data1['email_id'] = $eid[$i];
            $this->Customer_model->create_customer_email($data1);
          }
        }
      }*/

if($this->input->post('email_id')!='')
      {
        $data1['customer_id'] =  $customer_id;
        $data1['email_type_id'] = 0;
        $data1['email_id'] = $this->input->post('email_id');
        $this->Customer_model->create_customer_email($data1);
      }

/*if($this->input->post('phone_type_id')!='')
      {
        $ptid = explode(",",implode(",",$this->input->post('phone_type_id')));
        $pno = explode(",",implode(",",$this->input->post('phone_no')));

$subcount = count($this->input->post('phone_type_id'));      
          $data2['customer_id'] =  $customer_id;
          $pnosms = '';
        for($i=0;$i<$subcount;$i++)
        {
          if($ptid[$i] != ''){
            if($pnosms=='')
              $pnosms=$pno[$i];
            $data2['phone_type_id'] = $ptid[$i];
            $data2['phone_no'] = $pno[$i];
            $this->Customer_model->create_customer_phone($data2);
          }
        }
      }*/

if($this->input->post('phone_no')!='')
      {
        //$ptid = explode(",",implode(",",$this->input->post('phone_type_id')));
        $pno = explode(",",implode(",",$this->input->post('phone_no')));

$subcount = count($this->input->post('phone_no'));      
          $data2['customer_id'] =  $customer_id;
          $pnosms = '';
        for($i=0;$i<$subcount;$i++)
        {
          if($pno[$i] != ''){
            if($pnosms=='')
              $pnosms=$pno[$i];
            $data2['phone_type_id'] = 0;
            $data2['phone_no'] = $pno[$i];
            $this->Customer_model->create_customer_phone($data2);
          }
        }
      }

/*if($this->input->post('address_type_id')!='')
      {
        $atid = explode(",",implode(",",$this->input->post('address_type_id')));
        $adress = explode("|",implode("|",$this->input->post('address')));

$subcount = count($this->input->post('address_type_id'));      
          $data3['customer_id'] =  $customer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($atid[$i] != ''){
            $data3['address_type_id'] = $atid[$i];
            $data3['address'] = $adress[$i];
            $this->Customer_model->create_customer_address($data3);
          }
        }
      }*/

if($this->input->post('address_type_id')!='')
      {
        $atid = explode(",",implode(",",$this->input->post('address_type_id')));
        $adress = explode("|",implode("|",$this->input->post('address')));
        $adress_state_id = explode("|",implode("|",$this->input->post('address_state_id')));
        $adress_pincode = explode("|",implode("|",$this->input->post('address_pincode')));

$subcount = count($this->input->post('address_type_id'));      
          $data3['customer_id'] =  $customer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($atid[$i] != ''){
            $data3['address_type_id'] = $atid[$i];
            $data3['address'] = $adress[$i];
            $data3['address_state_id'] = $adress_state_id[$i];
            $data3['address_pincode'] = $adress_pincode[$i];
            $this->Customer_model->create_customer_address($data3);
          }
        }
      }

if($this->input->post('contact_person_name')!='')
      {
        $cpname = explode(",",implode(",",$this->input->post('contact_person_name')));
        $cpmno = explode(",",implode(",",$this->input->post('contact_no')));
        $cpemid = explode(",",implode(",",$this->input->post('contact_email_id')));

$subcount = count($this->input->post('contact_person_name'));      
          $data4['customer_id'] =  $customer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($cpname[$i] != ''){
            $data4['contact_person_name'] = $cpname[$i];
            $data4['contact_no'] = $cpmno[$i];
            $data4['contact_email_id'] = $cpemid[$i];
            //$this->db->insert('order_product',$op);
            $this->Customer_model->create_customer_contact_details($data4);
          }
        }
      }

}
    }
    else
    {
      $data['customer_id'] = $custId = $checkcustomer->customer_id;
      $data['intrested_products'] = '';
      $data['lead_id'] = $lead_id;

$data['modified_on'] = date('Y-m-d H:i:s');
      $data['modified_by'] = $_SESSION['user_id'];
      $result = $this->Lead_model->update_lead_customer($data);

}

//Convert to Order

$id = $this->input->post('qid');
    $qlist = $this->Quotation_model->get_quotation_view_by_id($id);
    //$quotation_product = $this->Quotation_model->get_quotation_product_by_id($id);
    $product_type = $this->Quotation_model->get_product_type_list();
    $cus_id = $qlist->customer_id;
    if($qlist->customer_id==0)
    {
      $customer = $this->Quotation_model->get_customer_by_lead_id($qlist->lead_id);
      $cus_id = $customer->customer_id;
    }

$data['customer_id'] = $cus_id;
    $locId = $data['location_id'] = 1;
    $data['order_date'] = date('Y-m-d');
    $data['del_date'] = date("Y-m-d", strtotime("+ 5 day"));
    $data['payment_term_id'] = 0;
    $data['delivery_term_id'] = 0;
    $data['transport'] = '';
    $data['booking_place'] = '';
    $data['incharge'] = '';
    $data['advance_amount'] = 0;
    $data['created_by'] = $_SESSION['user_id'];
    $data['delivery_permission_id'] = 1;
    $data['customer_po_no'] = '';
    $data['customer_po_no'] = '';
    $data['customer_po_bill'] = '';
    $data['application_id'] = $qlist->application_id;

foreach($product_type as $ptype)
    {
      $quotation_product = $this->Quotation_model->get_quotaion_product_by_ptype_id($ptype['product_type_id'],$id);
      if(count($quotation_product)>0)
      {
        $data['product_type_id'] = $ptype['product_type_id'];
        $data['created_on'] = date('Y-m-d H:i:s');
        $last_id_value = $this->Order_model->last_order_id();

if(count($last_id_value)==0)
        {
          $data['order_no'] = date("Y").'/'.date('m').'/SO001';
        }
        else
        {
          $lno = $last_id_value->order_no;
          $exlno = substr($lno,10);
          $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;
          $data['order_no'] = date("Y").'/'.date('m').'/SO'.$nval;
        }
        $data['taxable_amount'] = 0;
        $data['total_tax'] = 0;
        $data['round_off'] = '';
        $data['grand_total'] = 0;
        $data['balance_amount'] = 0;
        $data['quotation_id'] = $id;

$result = $this->Order_model->create_order($data);
        if($result)
        {
          $last_id_value = $this->Order_model->last_order_id();
          $last_value=$last_id_value->order_id;
          $oid = $ordprod['order_id'] = $last_value;
          $taxamt = 0;
          $tottax = 0;
          foreach($quotation_product as $qprod)
          {
            $ordprod['product_id'] = $qprod['product_id'];
            $ordprod['uom_id'] = $qprod['uom_id'];
            $ordprod['product_type_id'] = $qprod['product_type_id'];
            $ordprod['product_gst'] = $qprod['product_gst'];
            $ordprod['price_formula_id'] = $qprod['price_formula_id'];
            $ordprod['cut_size_length'] = $qprod['cut_size_length'];
            $ordprod['cut_size_width'] = $qprod['cut_size_width'];
            $ordprod['cut_size_height'] = $qprod['cut_size_height'];
            $ordprod['finish_size_length'] = $qprod['finish_size_length'];
            $ordprod['finish_size_width'] = $qprod['finish_size_width'];
            $ordprod['finish_size_height'] = $qprod['finish_size_height'];
            $ordprod['rate_per_sqft'] = $qprod['rate_per_sqft'];
            $ordprod['quantity'] = $qprod['quantity'];
            $ordprod['rate'] = $qprod['rate'];
            $ordprod['disc'] = $qprod['disc'];
            $ordprod['amount'] = $qprod['amount'];

if($qprod['product_type_id']==1)
            {
              /*$locproduct = $this->Order_model->get_pstock_by_locid_prodid($locId,$qprod['product_type_id']);
              if(count($locproduct)>0)
              {
                $lpqty = $locproduct[0]['stock'];
                $dedstock = $lpqty - $qprod['quantity'];

$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+$qprod['quantity'];
                  $bstock = $qprod['quantity'];
                  $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=$qprod['quantity'];
                $np = $qprod['quantity'];
                $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);
            
            $tottax+= (($qprod['amount']*$qprod['product_gst'])/100)*2;
            $taxamt+= $qprod['amount'];
            $gtot = number_format(round(($tottax+$taxamt)),2);
            $roff = number_format(($gtot - ($tottax+$taxamt)),2);
          }

$uporder['taxable_amount'] = number_format($taxamt,2);
          $uporder['total_tax'] = number_format($tottax,2);
          $uporder['round_off'] = $roff;
          $uporder['grand_total'] = $gtot;
          $uporder['balance_amount'] = $gtot;
          $uporder['order_id'] = $oid;
          $this->Quotation_model->update_quotaion_order($uporder);
        }

}
    }

$qsts['status']=1;
    $this->Quotation_model->change_quotation_status($qsts,$id);
    
    $this->session->set_flashdata('add_success', 'Qutotation has been conveted to Order successfully.');
    redirect('/quotation');
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Quotation.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation