<?php if (!defined('BASEPATH')) {
  exit('No direct script access allowed');
}

class Payment extends Customer_Controller
{
  private $order_id = null;

  function __construct()
  {
    parent::__construct();
    $this->load->model('order_m');
    $this->load->model('order_detail_m');
    $this->load->model('product_m');
    $this->load->model('configuration_m');
    $this->load->library('cart');
    $this->load->library('paypal_lib');
    $this->load->library('encryption');
    $this->load->library('GoogleClient');
    $this->load->library('VisitorTracking');
    $this->load->model('Top_banner_m');
    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('mainpage', 'english');
    } else {
      $this->lang->load('mainpage', 'indonesian');
    }
    $loginUrl = $this->googleclient->getLoginUrl();

    $this->data_footer['googleUrl'] = $loginUrl;
  }

  public function process()
  {
    if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'failed',
          'message' => 'Invalid request method'
        ]));
      return;
    }

    $payment_data = $this->input->post();
    // Validasi data yang diperlukan
    if (!isset($payment_data['orderId']) && !isset($payment_data['paymentType'])) {
      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'failed',
          'message' => 'Order ID or Payment Type is missing'
        ]));
      return;
    }

    $orderId = $payment_data['orderId'];
    $paymentType = $payment_data['paymentType'];
    $paymentTypeSlug = [
      'bank transfer BCA' => 'bca',
      'bank transfer MANDIRI' => 'mandiri',
      'DOKU' => 'doku',
      'Paypal' => 'paypal'
    ];

    $orderData = $this->getOrderDataById($orderId);
    if (!$orderData) {
      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'failed',
          'message' => 'Order data not found'
        ]));
      return;
    }


    // Doku data
    $orderDetails = $this->getOrderDetailByOrderId($orderId);
    $basket = [];
    foreach ($orderDetails as $item) {
      $basket[] = sprintf(
        '%s,%s,%s,%s',
        $item['item_name'],   // Nama produk
        number_format($item['item_price'], 2, '.', ''),  // Harga dengan format 2 desimal
        $item['quantity'],    // Jumlah produk
        number_format($item['subtotal'], 2, '.', '')     // Subtotal dengan format 2 desimal
      );
    }

    $basket = implode(';', $basket);

    if (strtolower($paymentType) === 'doku') {
      // Doku payment process
      $dokuEndpoint = 'https://pay.doku.com/Suite/Receive';
      $mallID = '10746346';
      $sharedKey = 'W4p2h2N3L4X8';
      $transIdMerchant = $orderId;
      $totalAmount = $orderData['grand_total_amount'];
      $msg =  number_format($totalAmount, 2, '.', '') . $mallID . $sharedKey . $transIdMerchant;
      $words = sha1($msg);

      $requestData = [
        'BASKET' => $basket,
        'MALLID' => '10746346',
        'CHAINMERCHANT' => 'NA',
        'CURRENCY' => 360,
        'PURCHASECURRENCY' => 360,
        'AMOUNT' => number_format($totalAmount, 2, '.', ''),
        'PURCHASEAMOUNT' => number_format($totalAmount, 2, '.', ''),
        'TRANSIDMERCHANT' => $transIdMerchant,
        'WORDS' => $words,
        'REQUESTDATETIME' => date('YmdHis'),
        'SESSIONID' => session_id(),
        'PAYMENTCHANNEL' => '',
        'EMAIL' => $orderData['customer_email'],
        'NAME' => $orderData['name'],
        'ADDRESS' => $orderData['shipping_address'],
        'COUNTRY' => 360,
        'STATE' => $orderData['shipping_district'],
        'CITY' => $orderData['shipping_district'],
        'PROVINCE' => $orderData['shipping_province'],
        'ZIPCODE' => $orderData['shipping_postcode'],
        'HOMEPHONE' => $orderData['shipping_phone'],
        'MOBILEPHONE' => $orderData['shipping_phone'],
        'WORKPHONE' => $orderData['shipping_phone'],
        'BIRTHDATE' => $orderData['birthday'],
      ];

      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'success',
          'message' => 'Redirecting to DOKU payment page.',
          'response' => $requestData,
          'redirect_url' => $dokuEndpoint,
          'payment_type' => $paymentType,
        ]));
      return;
    }
    if (strtolower($paymentType) == 'paypal') {
      $paypalEndpoint = base_url() . 'payment/paypal_payment/' . $orderId;
      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'success',
          'message' => 'Redirecting to Paypal payment page.',
          'redirect_url' => $paypalEndpoint,
          'payment_type' => $paymentType,
        ]));
      return;
    } else {
      // Metode pembayaran lain (BCA, Mandiri)
      $confirmationUrl = base_url("payment/confirmation?orderid={$orderId}&payment={$paymentTypeSlug[$paymentType]}");

      $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode([
          'status' => 'success',
          'message' => 'Redirecting to confirmation page.',
          'redirect_url' => $confirmationUrl,
          'payment_type' => $paymentType,
        ]));
    }

    // $confirmationUrl = base_url("payment/confirmation?orderid={$orderId}&payment={$paymentTypeSlug[$paymentType]}");

    // $this->output
    //   ->set_content_type('application/json')
    //   ->set_output(json_encode([
    //     'status' => 'success',
    //     'message' => 'Redirecting to confirmation page.',
    //     'redirect_url' => $confirmationUrl,
    //     'payment_type' => $paymentType,
    //   ]));
  }

  private function getOrderDataById($order_id)
  {
    $this->db->select('orders.*, customers.email AS customer_email, customers.birthday, customers.reseller_id, customers.name, customers.shipping_name, customers.shipping_address, customers.shipping_province, customers.shipping_district, customers.shipping_subdistrict, customers.shipping_postcode, customers.shipping_phone, customers.phone, customers.type');
    $this->db->from('orders');
    $this->db->join('customers', 'customers.id_customers = orders.customer_id', 'left');
    $this->db->where('orders.id_orders', $order_id);

    $query = $this->db->get();
    return $query->row_array();
  }


  private function getOrderDetailByOrderId($order_id)
  {
    $this->db->select('orders_detail.*, product_images.image AS item_image');
    $this->db->from('orders_detail');
    $this->db->join('product_images', 'orders_detail.item_id = product_images.product_details_id');
    $this->db->where('orders_detail.orders_id', $order_id);
    $this->db->where('product_images.status', 1);
    $this->db->where('product_images.priority', 1);
    $query = $this->db->get();
    return $query->result_array();
  }


  public function confirmation()
  {
    $this->visitortracking->trackVisitor();
    $orderId = $this->input->get('orderid');
    $paymentType = $this->input->get('payment');
    $website_data = $this->db->select('website_icon, browser_title, meta_description')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();

    // Handle language
    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('mainpage', 'english');
    } else {
      $this->lang->load('mainpage', 'indonesian');
    }

    $orderData = $this->getOrderDataById($orderId);
    $orderDetails = $this->getOrderDetailByOrderId($orderId);
    $bankData = $this->getBankData($paymentType);

    $meta_description = ($this->session->userdata('site_lang') == 'english')
      ? "Payment’s received! Now just sit back, relax, and let us handle the rest. Check your order history & get ready for the pleasure to roll in!"
      : "Mantap, pembayaran berhasil! Sekarang tinggal duduk manis, pesananmu segera diproses. Cek riwayat transaksi & tunggu kenikmatan dari Laci Asmara!";

    $data_view = [
      'orderData' => $orderData,
      'orderDetails' => $orderDetails,
      'paymentType' => $paymentType,
      'bankData' => $bankData,
      'website_icon' => $website_data->website_icon,
      'browser_title' => ucwords($website_data->browser_title) . ' - Payment Confirmation',
      'meta_description' => $meta_description,
    ];

    // Update payment status
    try {
      if (!empty($orderData['reseller_id'])) {
        $data = [
          'payment_status' => 0,
        ];
      } else {
        $data = [
          'payment_status' => 1,
        ];
      }

      $this->db->where('id_orders', $orderId);
      $this->db->update('orders', $data);

      // Commit transaction if no errors
      $this->db->trans_complete();

      if ($this->db->trans_status() === FALSE) {
        throw new Exception('Error updating payment status.');
      }
    } catch (Exception $e) {
      $this->db->trans_rollback();
      log_message('error', $e->getMessage());
      show_error('An error occurred while processing the payment status.');
    }

    try {
      // Coba kirim email konfirmasi
      $this->send_confirmation_email($paymentType, $orderData, $orderDetails, $bankData);
    } catch (Exception $e) {
      // Log error jika email gagal dikirim
      log_message('error', 'Gagal mengirim email konfirmasi: ' . $e->getMessage());
    }

    $this->cart->destroy();
    $this->destroy_session_data();
    $this->load->view('payment/order-confirmation', $data_view);
  }

  private function getBankData($paymentType)
  {
    $this->db->select('payment_type, bank_name, account_number, account_holder');
    $this->db->from('bank_accounts');
    $this->db->where('payment_type', $paymentType);
    $query = $this->db->get();
    return $query->row_array();
  }


  function post_payment()
  {
    // echo '<pre>';
    // echo $this->session->userdata('shipping_cart');
    // echo '</pre>';
    // exit();
    if (!$this->session->userdata('shipping_cart')) {
      redirect('cart');
    }

    if (!isset($_POST['lanjutPembayaran'])) {
      redirect('shipping');
    }

    //check if user not register yet
    if (
      !$this->session->userdata('customer') ||
      $this->session->userdata('customer')['customer_id'] == null ||
      $this->session->userdata('customer')['customer_type'] == 'guest'
    ) {
      //register new guest and return the id
      //from guest checkout shipping
      //check if email already exist, and check customer type..
      $count_customer = $this->db
        ->select('id_customers')
        ->from('customers')
        ->where(
          'email',
          $this->security->xss_clean($this->input->post('email'))
        )
        ->get()
        ->num_rows();

      if ($count_customer > 0) {
        //customer already exist
        //check customer type. if customer type is regular, then update shipping information only..
        $guest_data = [
          'shipping_name' => $this->security->xss_clean(
            $this->input->post('name')
          ),
          'shipping_phone' => $this->security->xss_clean(
            $this->input->post('phone')
          ),
          'shipping_id_province' => $this->input->post('shipping_province'),
          'shipping_id_district' => $this->input->post('shipping_district'),
          'shipping_id_subdistrict' => $this->input->post(
            'shipping_subdistrict'
          ),
          'address' => $this->security->xss_clean(
            $this->input->post('address')
          ),
          'shipping_address' => $this->security->xss_clean(
            $this->input->post('address')
          ),
          'postcode' => $this->security->xss_clean(
            $this->input->post('postcode')
          ),
          'shipping_postcode' => $this->security->xss_clean(
            $this->input->post('postcode')
          ),
          'birthday' => $this->security->xss_clean(
            $this->input->post('birthday')
          ),
          'sex_type' => $this->security->xss_clean(
            $this->input->post('sex_type')
          ),
        ];
        $this->db->where(
          'email',
          $this->security->xss_clean($this->input->post('email'))
        );
        $this->db->update('customers', $guest_data);

        //get customer id
        $this->db
          ->select('id_customers, name')
          ->from('customers')
          ->where(
            'email',
            $this->security->xss_clean($this->input->post('email'))
          );
        $customer_data = $this->db->get()->row();
        $customer_name = $customer_data->name;
        $customer_id = $customer_data->id_customers;

        $guest_data = [
          'customer_name' => ucwords($customer_name),
          'customer_email' => $this->session->userdata('guest_details')['email'],
          'customer_id' => $customer_id,
          'customer_loggedin' => true,
          'customer_type' => 'guest',
        ];
        $this->session->set_userdata('customer', $guest_data);
      } else {
        //customer not yet exist
        //insert new customer
        $guest_data = [
          'name' => $this->security->xss_clean($this->input->post('name')),
          'recipient_name' => $this->security->xss_clean(
            $this->input->post('name')
          ),
          'shipping_name' => $this->security->xss_clean(
            $this->input->post('name')
          ),
          'email' => $this->security->xss_clean($this->input->post('email')),
          'phone' => $this->security->xss_clean($this->input->post('phone')),
          'shipping_phone' => $this->security->xss_clean(
            $this->input->post('phone')
          ),
          'shipping_id_province' => $this->input->post('shipping_province'),
          'shipping_id_district' => $this->input->post('shipping_district'),
          'shipping_id_subdistrict' => $this->input->post(
            'shipping_subdistrict'
          ),
          'address' => $this->security->xss_clean(
            $this->input->post('address')
          ),
          'shipping_address' => $this->security->xss_clean(
            $this->input->post('address')
          ),
          'postcode' => $this->security->xss_clean(
            $this->input->post('postcode')
          ),
          'shipping_postcode' => $this->security->xss_clean(
            $this->input->post('postcode')
          ),
          'birthday' => $this->security->xss_clean(
            $this->input->post('birthday')
          ),
          'sex_type' => $this->security->xss_clean(
            $this->input->post('sex_type')
          ),
          'type' => 'guest',
        ];
        $this->db->insert('customers', $guest_data);
        $customer_id = $this->db->insert_id();

        $customer_data = [
          'customer_name' => 'Guest',
          'customer_email' => $this->session->userdata('guest_details')['email'],
          'customer_id' => $customer_id,
          'customer_loggedin' => true,
          'customer_type' => 'guest',
        ];
        $this->session->set_userdata('customer', $customer_data);
      }
    } elseif (
      $this->session->userdata('customer')['customer_id'] != null &&
      $this->session->userdata('customer')['customer_type'] == 'regular'
    ) {
      //customer is logged in..
      //update detail
      $id = $this->session->userdata('customer')['customer_id'];
      $temp_is_first =  $this->db->select('is_first')->from('customers')->where('id_customers', $id)->get()->row()->is_first;

      $customer_data = [
        'shipping_id_province' => $this->input->post('shipping_province'),
        'shipping_id_district' => $this->input->post('shipping_district'),
        'is_first' => $temp_is_first + 1,
        'shipping_id_subdistrict' => $this->input->post('shipping_subdistrict'),
        'shipping_address' => $this->security->xss_clean(
          $this->input->post('address')
        ),
        'shipping_postcode' => $this->security->xss_clean(
          $this->input->post('postcode')
        ),
      ];

      //check if shipping_name & shipping_phone empty
      $customer = $this->db
        ->select('name, phone, shipping_name, shipping_phone')
        ->from('customers')
        ->where(
          'id_customers',
          $this->session->userdata('customer')['customer_id']
        )
        ->get()
        ->row();

      if (empty($customer->shipping_name)) {
        $customer_data['shipping_name'] = $customer->name;
      }

      if (empty($customer->shipping_phone)) {
        $customer_data['shipping_phone'] = $customer->phone;
      }
      $this->db->where(
        'id_customers',
        $this->session->userdata('customer')['customer_id']
      );
      $this->db->update('customers', $customer_data);
    }

    //set customer_note into session
    $this->session->set_userdata(
      'customer_note',
      $this->security->xss_clean($this->input->post('customer_note'))
    );
    $this->session->set_userdata(
      'receiver_name',
      $this->security->xss_clean($this->input->post('receiver_name'))
    );
    $this->session->set_userdata(
      'receiver_phone',
      $this->security->xss_clean($this->input->post('receiver_phone'))
    );
    $this->session->set_userdata(
      'insurance_cost',
      $this->security->xss_clean($this->input->post('insurance_cost'))
    );
    $this->session->set_userdata(
      'insurance_status',
      $this->security->xss_clean($this->input->post('insurance_status'))
    );

    redirect('payment');
  }

  function index()
  {
    if (!$this->session->userdata('shipping_cart')) {
      redirect('cart');
    }

    if (!$this->session->userdata('shipping_to_payment')) {
      redirect('shipping');
    }

    //check shipping_cart if the stock is available for each warehouse
    $have_stock = true;

    foreach ($this->session->userdata('shipping_cart') as $rowid => $item) {
      //get product name
      $product_name = $this->db
        ->select('title')
        ->from('products')
        ->where('id_products', $item['product_id'])
        ->get()
        ->row()->title;

      //get total stok from warehouse
      $current_stock = $this->db
        ->select('stock')
        ->from('stock')
        ->where('id_product', $item['product_id'])
        ->where('id_product_detail', $item['id'])
        ->where('warehouse_id', $item['warehouse_id'])
        ->get()
        ->row()->stock;

      if ($current_stock < $item['qty']) {
        if ($item['is_backorder'] == 'no') {
          $this->session->set_flashdata(
            'no_stock' . $rowid,
            'Not Enough Stock'
          );
          $have_stock = false;
        }
      }
    }

    if ($have_stock == false) {
      redirect('shipping/no_stock');
    }

    //INSERT NEW ORDERS
    $grand_total = 0;
    foreach ($this->session->userdata('shipping_cart') as $rowid => $item) {
      $grand_total = $grand_total + $item['subtotal'];
    }

    //GET THE VALUE OF INDENT (only for indent item)
    $indent_remaining = 0;
    foreach (
      $this->session->userdata('shipping_cart')
      as $rowid => $shipping_cart_item
    ) {
      if ($shipping_cart_item['is_backorder'] == 'yes') {
        $indent_remaining =
          $indent_remaining +
          ($shipping_cart_item['price'] - $shipping_cart_item['dp_price']) *
          $shipping_cart_item['qty'];
      }
    }

    //GET THE VALUE OF INDENT SHIPPING FEE (only for indent item)
    $indent_shipping_fee = 0;
    foreach (
      $this->session->userdata('shipping_cart')
      as $rowid => $shipping_cart_item
    ) {
      if ($shipping_cart_item['is_backorder'] == 'yes') {
        $indent_shipping_fee =
          $indent_shipping_fee + $shipping_cart_item['shipping_fee'];
      }
    }

    //get shipping address, province, district and subdistrict
    $customer_data = $this->db
      ->select(
        'email, shipping_name, shipping_address, shipping_id_province, shipping_id_district, shipping_id_subdistrict, shipping_postcode, shipping_phone, shipping_country,current_pointreward,is_first, refferal'
      )
      ->from('customers')
      ->where(
        'id_customers',
        $this->session->userdata('customer')['customer_id']
      )
      ->get()
      ->row();

    //get subdistrict, distirct and province name
    $subdistrict = $this->db
      ->select('subdistrict')
      ->from('indonesia_subdistricts')
      ->where(
        'rajaongkir_id_subdistrict',
        $customer_data->shipping_id_subdistrict
      )
      ->get()
      ->row()->subdistrict;

    //get district
    $district = $this->db
      ->select('district')
      ->from('indonesia_districts')
      ->where('rajaongkir_id_district', $customer_data->shipping_id_district)
      ->get()
      ->row()->district;

    //get province
    $province = $this->db
      ->select('province')
      ->from('indonesia_provinces')
      ->where('rajaongkir_province_id', $customer_data->shipping_id_province)
      ->get()
      ->row()->province;

    $get_grand_total = 0;
    foreach ($this->session->userdata('shipping_cart') as $item) {
      $get_grand_total += $item['subtotal'];
    }

    $q_config_cond = $this->db
      ->select(
        'type_cond_prov_free_shipping, cond_more_prov_free_shipping, cond_less_prov_free_shipping'
      )
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();

    $reseller_tier_config = $this->db
      ->select(
        'minimum_order'
      )
      ->from('resellers')
      ->get()
      ->row();

    $free_shipping_type = $this->db
      ->select('free_shipping_type')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row()->free_shipping_type;

    $condition_freeshipping = false;

    $reseller_id = $this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id'])->get()->row()->reseller_id;
    if ($reseller_id == null) {
      if ($free_shipping_type == 'region') {
        if ($this->session->userdata('cart_has_discounted_items') == 'no') {
          $selected_region_province = $this->db
            ->select('*')
            ->from('free_shipping_region')
            ->where('configuration_id', 1)
            ->where('province_id', $customer_data->shipping_id_province)
            ->get();

          if ($selected_region_province->num_rows() > 0) {
            switch ($q_config_cond->type_cond_prov_free_shipping) {
              case 'more_than':
                if (
                  // Kalau grand totalnya lebih besar dari 1.500.000
                  $get_grand_total >= $q_config_cond->cond_more_prov_free_shipping
                ) {
                  $condition_freeshipping = true;
                } else {
                  $condition_freeshipping = false;
                }
                break;
              case 'less_than':
                if (
                  $get_grand_total <= $q_config_cond->cond_less_prov_free_shipping
                ) {
                  $condition_freeshipping = true;
                } else {
                  $condition_freeshipping = false;
                }
                break;

              default:
                $condition_freeshipping = true;
                break;
            }
          }
        }
      }

      if ($free_shipping_type == 'region') {
        if ($this->session->userdata('cart_has_discounted_items') == 'yes') {
          $selected_region_province = $this->db
            ->select('*')
            ->from('free_shipping_region')
            ->where('configuration_id', 1)
            ->where('province_id', $customer_data->shipping_id_province)
            ->get();

          if ($selected_region_province->num_rows() > 0) {
            switch ($q_config_cond->type_cond_prov_free_shipping) {
              case 'more_than':
                if (
                  $get_grand_total >= $q_config_cond->cond_more_prov_free_shipping
                ) {
                  $condition_freeshipping = true;
                } else {
                  $condition_freeshipping = false;
                }
                break;
              case 'less_than':
                if (
                  $get_grand_total <= $q_config_cond->cond_less_prov_free_shipping
                ) {
                  $condition_freeshipping = true;
                } else {
                  $condition_freeshipping = false;
                }
                break;

              default:
                $condition_freeshipping = true;
                break;
            }
          }
        }
      }
    } else {
      $condition_freeshipping = false;
    }
    if ($this->session->userdata('cart_has_discounted_items') == 'no') {
      $isfirst = $customer_data->is_first;
    } else {
      $isfirst = 2;
    }
    //insert new order to orders table
    $data = [
      'customer_id' => (int) $this->session->userdata('customer')['customer_id'],
      'total_amount' => $grand_total,
      'order_date' => date('Y-m-d H:i:s'),
      'recipient_name' => $customer_data->shipping_name,
      'address' => $customer_data->shipping_address,
      'subdistrict' => $subdistrict,
      'district' => $district,
      'province' => $province,
      'postcode' => $customer_data->shipping_postcode,
      'phone' => $customer_data->shipping_phone,
      'email' => $customer_data->email,
      'first' => $isfirst,
      'country' => $customer_data->shipping_country,
      'shipping_fee' => $this->session->userdata('total_shipping_fee'),
      'free_shipping_fee' => $this->session->userdata('free_shipping'),
      'created_by' => 'system',
      'indent_remaining' => $indent_remaining,
      'indent_shipping_fee' => $indent_shipping_fee,
      'customer_note' => $this->session->userdata('customer_note'),
      'gift_receiver_name' => $this->session->userdata('receiver_name'),
      'gift_receiver_phone' => $this->session->userdata('receiver_phone'),
      'insurance_status' => $this->session->userdata('insurance_status'),
      'insurance_cost' => $this->session->userdata('insurance_cost'),
      'referral' => !empty($this->session->userdata('referral')) ? $this->session->userdata('referral') : $customer_data->refferal,
      'special_event' => $this->session->userdata('gimmickeligible'),
      'source' => $this->session->userdata('visitor_tracking')['source'],
      'medium' => $this->session->userdata('visitor_tracking')['medium'],
      'campaign' => $this->session->userdata('visitor_tracking')['campaign'],
    ];

    // $customer_data->refferal
    if ($this->session->userdata('site_lang') == 'english') {
      $data['order_language'] = 'english';
    } else {
      $data['order_language'] = 'indonesian';
    }

    //add voucher
    if ($this->session->userdata('chosen_voucher_code')) {
      $data['redeemed_voucher_code'] = $this->session->userdata(
        'chosen_voucher_code'
      );
      $data['redeemed_voucher_type'] = $this->session->userdata(
        'chosen_voucher_type'
      );
      $data['redeemed_voucher_value'] = $this->session->userdata(
        'chosen_voucher_discount'
      );
      $data['redeemed_voucher_amount'] = $this->session->userdata(
        'redeemed_voucher_amount'
      );
    }

    //add tax
    if ($this->session->userdata('tax')) {
      $data['ppn'] = $this->session->userdata('tax');
    }

    //add point rewards
    $pointrewards = $this->db
      ->select('*')
      ->from('point_rewards')
      ->where('id_point_rewards', 1)
      ->get()
      ->row();

    if ($this->session->userdata('customer')['customer_type'] != 'guest') {
      if ($pointrewards->active == 'yes') {

        $reseller_id = $this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id'])->get()->row()->reseller_id;
        if ($reseller_id == NULL) {
          $data['plus_reward'] = ceil($grand_total / $pointrewards->ratio);
        } else {
          $data['plus_reward'] = 0;
        }
      }
    }

    //minus point rewards
    if ($this->session->userdata('chosen_point')) {
      $data['current_reward'] = $customer_data->current_pointreward;
      $data['sisa_reward'] =
        $customer_data->current_pointreward -
        $this->session->userdata('chosen_point');
      $data['minus_reward'] = $this->session->userdata('chosen_point');
      $data['minus_reward_amount'] = $this->session->userdata(
        'chosen_point_discount'
      );
    }

    //GRAND FINAL TOTAL AMOUNT CALCULATION
    $finalshippingfee = 0;

    $calculate_finalshippingfee =
      $this->session->userdata('total_shipping_fee') -
      $this->session->userdata('free_shipping');

    if ($calculate_finalshippingfee > 0) {
      $finalshippingfee = $calculate_finalshippingfee;
    }
    if ($this->session->userdata('insurance_status') == 'Yes') {
      $insurance = $this->session->userdata('insurance_cost');
    } else {
      $insurance = 0;
    }
    $data['grand_total_amount'] =
      $grand_total -
      $this->session->userdata('redeemed_voucher_amount') -
      $this->session->userdata('chosen_point_discount') +
      $finalshippingfee + $insurance;

    if ($data['grand_total_amount'] <= 0) {
      if ($finalshippingfee > 0) {
        $data['grand_total_amount'] = $finalshippingfee;
      }
    }

    //get total downpayment
    $data['total_downpayment'] =
      $data['grand_total_amount'] - $indent_remaining - $indent_shipping_fee;

    if ($condition_freeshipping == true) {
      $data['grand_total_amount'] =
        $data['grand_total_amount'] -
        $data['shipping_fee'] -
        $data['indent_shipping_fee'];

      $data['total_downpayment'] =
        $data['total_downpayment'] -
        $data['shipping_fee'] -
        $data['indent_shipping_fee'];

      $data['shipping_fee'] = 0;
    }

    $this->db->insert('orders', $data);
    $order_id = $this->db->insert_id();

    /*insert shipping session to shipping table*/
    if ($this->session->userdata('shipping_session') != null) {
      foreach (
        $this->session->userdata('shipping_session')
        as $shipping_session
      ) {
        $insert_shipping_session = [
          'order_id' => $order_id,
          'warehouse_id' => $shipping_session['warehouse_id'],
          'shipping_fee' => $shipping_session['shipping_fee'],
          'is_indent' => $shipping_session['is_indent'],
        ];
        $this->db->insert('shipping', $insert_shipping_session);
      }
    }

    if ($this->session->userdata('chosen_point')) {
      //deduct minus_rewards to customer current point rewards..
      //get customer current point reward
      $current_point_reward = $this->db
        ->select('current_pointreward')
        ->from('customers')
        ->where(
          'id_customers',
          (int) $this->session->userdata('customer')['customer_id']
        )
        ->get()
        ->row()->current_pointreward;
      $new_point_reward = $current_point_reward - (int) $data['minus_reward'];

      //add new point back to customers table
      $data = [
        'current_pointreward' => $new_point_reward,
      ];
      $this->db->where(
        'id_customers',
        (int) $this->session->userdata('customer')['customer_id']
      );
      $this->db->update('customers', $data);
    }
    //insert new order details to order details table
    foreach ($this->session->userdata('shipping_cart') as $item) {
      $item_data = [
        'orders_id' => $order_id,
        'item_id' => (int) $item['id'],
        'product_id' => (int) $item['product_id'],
        'item_name' => $item['name'],
        'item_price' => (int) $item['price'],
        'quantity' => (int) $item['qty'],
        'subtotal' => (int) $item['subtotal'],
        'warehouse_id' => $item['warehouse_id'],
        'chosen_shipping_id' => $item['chosen_shipping_id'],
        'shipping_fee' => $item['shipping_fee'],
        'is_backorder' => $item['is_backorder'],
        'dp_percentage' => $item['dp_percentage'],
        'indent_message' => $item['indent_message'],
        'is_flashsale' => $item['is_flashsale'],
        'attribute_detail_ids' => serialize($item['attribute_detail_ids']),
      ];

      //get SKU
      $item_data['sku'] = $this->db
        ->select('sku')
        ->from('product_details')
        ->where('id', $item['id'])
        ->get()
        ->row()->sku;

      //get Atribute details
      $item_data['attributes'] = '';
      $count = 1;
      foreach ($item['attribute_detail_ids'] as $detail_id) {
        if ($this->session->userdata('site_lang') == 'english') {
          $detail_name = $this->db
            ->select('attribute_detail_en')
            ->from('product_attributes_detail')
            ->where('id', $detail_id)
            ->get()
            ->row()->attribute_detail_en;
        } else {
          $detail_name = $this->db
            ->select('attribute_detail')
            ->from('product_attributes_detail')
            ->where('id', $detail_id)
            ->get()
            ->row()->attribute_detail;
        }

        if ($count == 1) {
          $item_data['attributes'] = $detail_name;
        } else {
          $item_data['attributes'] =
            $item_data['attributes'] . ', ' . $detail_name;
        }
        $count++;
      }

      if ($item['is_sale'] == true) {
        $item_data['is_sale'] = 'yes';
      } else {
        $item_data['is_sale'] = 'no';
      }
      $this->order_detail_m->save($item_data, $id = null);

      //ONLY FOR FLASHSALE ITEM
      //check if an item is currently in flashsale
      $count_product = $this->db
        ->select('product_id')
        ->from('flashsale_products')
        ->where('flashsale_id', $this->session->userdata('flashsale_id_active'))
        ->where('product_id', $item['product_id'])
        ->get()
        ->num_rows();

      if ($count_product > 0) {
        //this product is part of flashsale
        $counter_data = $this->db
          ->select('counter, terjual')
          ->from('flashsale_products')
          ->where(
            'flashsale_id',
            $this->session->userdata('flashsale_id_active')
          )
          ->where('product_id', $item['product_id'])
          ->get()
          ->row();
        $current_counter = $counter_data->counter;
        $current_terjual = $current_counter->terjual;

        $data = [
          'counter' => $current_counter - $item['qty'],
          'terjual' => $current_terjual + $item['qty'],
        ];
        $this->db->where(
          'flashsale_id',
          $this->session->userdata('flashsale_id_active')
        );
        $this->db->where('product_id', $item['product_id']);
        $this->db->update('flashsale_products', $data);

        //update also flashsale customer
        $data = [
          'customer_id' => $this->session->userdata('customer')['customer_id'],
          'flashsale_id' => $this->session->userdata('flashsale_id_active'),
          'flashsale_product_id' => $item['product_id'],
          'purchase_qty' => $item['qty'],
        ];
        $this->db->insert('flashsale_customer', $data);
      }

      //DEDUCT VOUCHERS FROM VOUCHER TABLE
      if ($this->session->userdata('chosen_voucher_code')) {
        $qty_ready = $this->db
          ->select('qty_ready')
          ->from('vouchers')
          ->where(
            'voucher_code',
            $this->session->userdata('chosen_voucher_code')
          )
          ->get()
          ->row()->qty_ready;

        if ($qty_ready != null) {
          $new_qty_ready = $qty_ready - 1;
          $data = [
            'qty_ready' => $new_qty_ready,
          ];
          $this->db->where(
            'voucher_code',
            $this->session->userdata('chosen_voucher_code')
          );
          $this->db->update('vouchers', $data);
        }
      }

      //UPDATE VOUCHER USER TABLE
      //get voucher id
      if ($this->session->userdata('chosen_voucher_code')) {
        $voucher_id = $this->db
          ->select('id_vouchers')
          ->from('vouchers')
          ->where(
            'voucher_code',
            $this->session->userdata('chosen_voucher_code')
          )
          ->get()
          ->row()->id_vouchers;

        //check if this voucher already been used before in voucher user table
        $count_voucher = $this->db
          ->select('id_voucher_users')
          ->from('voucher_users')
          ->where('voucher_id', $voucher_id)
          ->where(
            'customer_id',
            (int) $this->session->userdata('customer')['customer_id']
          )
          ->get()
          ->num_rows();

        if ($count_voucher == 0) {
          //voucher not exist yet, insert new voucher
          $data = [
            'voucher_id' => $voucher_id,
            'customer_id' => (int) $this->session->userdata('customer')['customer_id'],
            'voucher_used' => 1,
          ];
          $this->db->insert('voucher_users', $data);
        } else {
          //voucher already exist
          //get current used voucher quantity, and add 1
          $voucher_user = $this->db
            ->select('id_voucher_users, voucher_used')
            ->from('voucher_users')
            ->where('voucher_id', (int) $voucher_id)
            ->where(
              'customer_id',
              (int) $this->session->userdata('customer')['customer_id']
            )
            ->get()
            ->row();
          $new_voucher_used = $voucher_user->voucher_used + 1;

          $data = [
            'voucher_used' => (int) $new_voucher_used,
          ];
          $this->db->where('id_voucher_users', $voucher_user->id_voucher_users);
          $this->db->update('voucher_users', $data);
        }
      }
    }

    //DEDUCT CURRENT STOCK WITH PURCHASE QUANTITY
    foreach ($this->session->userdata('shipping_cart') as $rowid => $item) {
      if ($item['is_backorder'] == 'no') {
        //get current stock from stock table
        $current_stock = $this->db
          ->select('id, stock')
          ->from('stock')
          ->where('id_product', (int) $item['product_id'])
          ->where('id_product_detail', (int) $item['id'])
          ->where('warehouse_id', (int) $item['warehouse_id'])
          ->get()
          ->row();
        $new_item_stock = $current_stock->stock - (int) $item['qty'];
        $stock_data = [
          'stock' => $new_item_stock,
        ];
        //update the product item stock in database
        $this->db->where('id_product', (int) $item['product_id']);
        $this->db->where('id_product_detail', (int) $item['id']);
        $this->db->where('warehouse_id', (int) $item['warehouse_id']);
        $this->db->update('stock', $stock_data);

        //get $stock_id
        $stock_id = $current_stock->id;

        //update stock_movement_table
        $movement_data = [
          'stock_id' => $stock_id,
          'type' => '-',
          'stock_change' => (int) $item['qty'],
          'remark' => 'Sales Order No: ' . $order_id,
          'total' => (int) $new_item_stock,
          'name' => 'System'
        ];
        $this->db->insert('stock_movement', $movement_data);
      }
    }

    $order = $this->db
      ->select('*')
      ->from('orders')
      ->where('id_orders', $order_id)
      ->get()
      ->row();

    $grand_final_total =
      $order->grand_total_amount -
      $order->indent_remaining -
      $order->indent_shipping_fee;

    $finalshippingfee = 0;

    $calculate_finalshippingfee =
      $order->shipping_fee -
      $order->free_shipping_fee -
      $order->indent_shipping_fee;

    if ($calculate_finalshippingfee > 0) {
      $finalshippingfee = $calculate_finalshippingfee;
    }

    $total_non_shipping =
      $order->total_amount -
      $order->redeemed_voucher_amount -
      $order->minus_reward_amount;

    if ($grand_final_total <= 0) {
      if ($finalshippingfee <= 0) {
        $this->session->set_userdata('free_order_id', $order_id);

        $update_payment_status = [
          'payment_type' => 'free order',
          'payment_status' => 3,
          'sisa_kembali' => $grand_final_total,
        ];
        $this->db->where('id_orders', $order_id);
        $this->db->update('orders', $update_payment_status);

        redirect('payment/free_order');
      }
    }

    //LOAD MIDTRANS PAYMENTS IF ACTIVE
    // $midtrans_active = $this->db->select('midtrans')->from('configuration')->where('id_configuration', 1)->get()->row()->midtrans;
    // if($midtrans_active == 1) {
    // 	//load midtrans payment function
    // 	$data = $this->midtrans_processing($order, $order_id, $total_non_shipping, $finalshippingfee, $customer_data, $subdistrict, $district, $province);
    // }

    //LOAD DOKU PAYMENTS ID ACTIVE
    $data['doku_payment'] = $this->doku_processing(
      $order,
      $order_id,
      $total_non_shipping,
      $finalshippingfee,
      $customer_data,
      $subdistrict,
      $district,
      $province
    );

    //LOAD BANK TRANSFER MANUAL IF ACTIVE
    $bank_active = $this->db
      ->select('bank_transfer, bank_transfer1')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();

    $data['bca_is_active'] = $bank_active->bank_transfer;
    $data['mandiri_is_active'] = $bank_active->bank_transfer1;
    $data['order_id'] = $order_id;

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('payment', 'english');
    } else {
      $this->lang->load('payment', 'indonesian');
    }
    //load payment view
    $website_name = $this->db
      ->select('website_name')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row()->website_name;
    $this->data_header['browser_title'] = ucwords($website_name) . ' - Payment';
    $this->data_header['meta_description'] =
      ucwords($website_name) . ' - Payment';

    $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('payment', $data);
    $this->load->view("themes/$this->theme_no/footer", $this->data_footer);

    $this->session->unset_userdata('shipping_to_payment');
  }

  public function paypal_payment($id)
  {
    $key = 'sb-hws8i3184847';

    $data_payment = [
      'payment_type' => 'Paypal',
    ];
    $this->db->where('id_orders', $id);
    $this->db->update('orders', $data_payment);

    $method = 'aes-256-cbc';
    $iv = openssl_random_pseudo_bytes(openssl_cipher_iv_length($method));
    $encryptedId = openssl_encrypt($id, $method, $key, 0, $iv);
    $encryptedId = base64_encode($iv . $encryptedId);
    $encryptedId = strtr($encryptedId, '+/=', '._-');

    // Set variables for PayPal form
    $returnURL = base_url('payment/paypal_success/') . $encryptedId; // Payment success URL
    $cancelURL = base_url('payment/paypal_cancel/') . $encryptedId; // Payment cancel URL
    $notifyURL = base_url('payment/paypal_ipn/') . $encryptedId; // IPN URL

    // Get particular product data
    $order = $this->db->select('*')
      ->from('orders')
      ->where('id_orders', $id)
      ->get()
      ->row();
    $userID = $order->customer_id; // Current user ID
    $logo = base_url() . 'Your_logo_url';
    $amount = $order->grand_total_amount / 14000;

    // PayPal fields
    $this->paypal_lib->add_field('return', $returnURL);
    $this->paypal_lib->add_field('cancel_return', $cancelURL);
    $this->paypal_lib->add_field('notify_url', $notifyURL);
    $this->paypal_lib->add_field('item_name', 'Order Laciasmara :' . $id);
    $this->paypal_lib->add_field('custom', $userID);
    $this->paypal_lib->add_field('item_number', $id);
    $this->paypal_lib->add_field('amount', $amount);
    $this->paypal_lib->image($logo);

    $this->paypal_lib->paypal_auto_form();
  }

  public function preview_paypal_success()
  {
    $this->load->view('paypal_success');
  }

  public function preview_paypal_fail()
  {
    $this->load->view('paypal_fail');
  }


  public function paypal_success($encryptedId)
  {
    $key = 'sb-hws8i3184847';

    $encryptedId = strtr($encryptedId, '._-', '+/=');
    $decodedData = base64_decode($encryptedId);
    $method = 'aes-256-cbc';
    $ivLength = openssl_cipher_iv_length($method);
    $iv = substr($decodedData, 0, $ivLength);
    $encryptedId = substr($decodedData, $ivLength);
    $id = openssl_decrypt($encryptedId, $method, $key, 0, $iv);

    if ($id === false) {
      redirect(base_url());
    }

    $order = $this->db->select('*')
      ->from('orders')
      ->where('id_orders', $id)
      ->get()
      ->row();

    if (!$order) {
      redirect(base_url());
    }

    $paypalInfo = $this->input->get();

    // Transaction data
    $data['item_number'] = $paypalInfo['item_number'];
    $data['txn_id'] = $paypalInfo["tx"];
    $data['payment_amt'] = $paypalInfo["amt"];
    $data['currency_code'] = $paypalInfo["cc"];
    $data['status'] = $paypalInfo["st"];

    // Update order status
    $order = [
      'payment_status' => 3,
    ];

    $this->db->where('id_orders', $id);
    $this->db->update('orders', $order);

    $this->destroy_session_data();

    // $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('paypal_success', $data);
    // $this->load->view("themes/$this->theme_no/footer", $this->data_footer);
  }


  function paypal_cancel($encryptedId)
  {
    //if transaction cancelled
    // $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('paypal_fail');
    // $this->load->view("themes/$this->theme_no/footer", $this->data_footer);
  }

  function paypal_ipn()
  {
    //paypal return transaction details array
    $paypalInfo    = $this->input->post();
    $data['user_id'] = $paypalInfo['custom'];
    $data['product_id']    = $paypalInfo["item_number"];
    $data['txn_id']    = $paypalInfo["txn_id"];
    $data['payment_gross'] = $paypalInfo["mc_gross"];
    $data['currency_code'] = $paypalInfo["mc_currency"];
    $data['payer_email'] = $paypalInfo["payer_email"];
    $data['payment_status']    = $paypalInfo["payment_status"];
    $paypalURL = $this->paypal_lib->paypal_url;
    $result    = $this->paypal_lib->curlPost($paypalURL, $paypalInfo);

    //check whether the payment is verified
    if (preg_match("/VERIFIED/i", $result)) {
      //insert the transaction data into the database
      $this->product->storeTransaction($data);
    }
  }

  private function doku_processing(
    $order,
    $order_id,
    $total_non_shipping,
    $finalshippingfee,
    $customer_data,
    $subdistrict,
    $district,
    $province
  ) {
    //Process DOKU script
    $doku_data['transidmerchant'] = $order_id;
    // $doku_data['payment_type'] =  $this->session->userdata('chosen_payment_type');
    $doku_data['payment_type'] = 'doku_creditcard';
    $doku_data['basket'] = $this->session->userdata('shipping_cart');
    $doku_data['amount'] = $total_non_shipping;
    $doku_data['cname'] = $customer_data->shipping_name;
    $doku_data['cemail'] = $customer_data->email;
    $doku_data['cwphone'] = $customer_data->shipping_phone;
    $doku_data['cmphone'] = $customer_data->shipping_phone;
    $doku_data['caddress'] = $customer_data->shipping_address;
    $doku_data['czipcode'] = $customer_data->shipping_postcode;
    $doku_data['birthday'] = $customer_data->birthday;
    $doku_data['ccity'] =  $district;
    $doku_data['cstate'] = $province;
    $doku_data['ccountry'] = 'Indonesia';
    $doku_data['saddress'] = $customer_data->shipping_address;
    $doku_data['szipcode'] = $customer_data->shipping_postcode;
    $doku_data['scity'] = $subdistrict;
    $doku_data['sstate'] = $province;
    $doku_data['scountry'] = 'Indonesia';
    $doku_data['carrier_name'] = $this->session->userdata('carrier_name');
    $doku_data['total_shipping_fee'] = $finalshippingfee;

    if ($this->session->userdata('cart_has_discounted_items') == 'no') {
      $disc_first = 0;
      $referral = !empty($order->referral) ? $order->referral : $order->redeemed_voucher_code;

      $affiliator = $this->db->select('kategori')
        ->from('affiliator_register')
        ->where('referral', $referral)
        ->get()
        ->row();

      if ($customer_data->first == 1) { // Jika ini adalah pembelian pertama
        if ($order->order_date >= '2024-08-01') {
          if (!empty($affiliator)) {
            if ($affiliator->kategori == 'asmarasana' || $referral == 'laciput') {
              $disc_first = $order->total_amount * 0.05;
            } elseif ($affiliator->kategori == 'asmaradoor') {
              $disc_first = $order->total_amount * 0.10;
            }
          } else {
            $disc_first = $order->total_amount * 0.05;
          }
        } else {
          $disc_first = $order->total_amount * 0.05;
        }
        $firstpurchase = ($total_non_shipping) * $disc_first;
      } else {
        $firstpurchase = 0;
      }
    }
    $doku_data['total_amount'] = number_format(
      (float) ($total_non_shipping + $finalshippingfee - $firstpurchase),
      2,
      '.',
      ''
    );

    if ($this->session->userdata('tax')) {
      $doku_data['tax'] = $this->session->userdata('tax');
    }

    return $doku_data;
  }

  private function midtrans_processing(
    $order,
    $order_id,
    $total_non_shipping,
    $finalshippingfee,
    $customer_data,
    $subdistrict,
    $district,
    $province
  ) {
    require_once APPPATH . 'third_party/Veritrans.php';

    //get key
    $midtrans = $this->db
      ->select(
        'veritrans_server_key, veritrans_sandbox_server_key, veritrans_client_key, veritrans_sandbox_client_key, veritrans_production_mode, credit_card, gopay, permata_va, bni_va, mandiri_bill, akulaku'
      )
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();
    $production_mode = $midtrans->veritrans_production_mode;

    //Set erver key
    if ($production_mode == 'true') {
      Veritrans_Config::$isProduction = true;
      Veritrans_Config::$serverKey = $midtrans->veritrans_server_key;
      $data['client_key'] = $midtrans->veritrans_client_key;
      $data['snap_url'] = 'https://app.midtrans.com/snap/snap.js';
    } else {
      Veritrans_Config::$isProduction = false;
      Veritrans_Config::$serverKey = $midtrans->veritrans_sandbox_server_key;
      $data['client_key'] = $midtrans->veritrans_sandbox_client_key;
      $data['snap_url'] = 'https://app.sandbox.midtrans.com/snap/snap.js';
    }

    // Enable sanitization
    Veritrans_Config::$isSanitized = true;

    // Enable 3D-Secure
    Veritrans_Config::$is3ds = true;

    if ($total_non_shipping <= 0) {
      if ($finalshippingfee > 0) {
        //disable midtrans non product transaction items to avoid negative grand total
        $midtrans_disable_non_product_items = true;
      }
    }

    // Populate items
    // define a two-dimensional array
    //get order detail
    $order_details = $this->db
      ->select('*')
      ->from('orders_detail')
      ->where('orders_id', $order_id)
      ->get()
      ->result();

    $total_item_price = 0;

    foreach ($order_details as $item) {
      //get dp price for indent porduct
      if ($item->is_backorder == 'yes') {
        $price = ($item->item_price * $item->dp_percentage) / 100;
        $name = strip_tags(substr($item->item_name, 0, 48)) . '..Downpayment';
      } else {
        $price = $item->item_price;
        $name = strip_tags(substr($item->item_name, 0, 48)) . '..';
      }

      $items[] = [
        'id' => $item->product_id,
        'price' => (int) $price,
        'quantity' => $item->quantity,
        'name' => $name,
      ];

      $total_item_price = $total_item_price + $price * $item->quantity;
    }

    if (!isset($midtrans_disable_non_product_items)) {
      //add voucher discount into the item
      if ($order->redeemed_voucher_amount != null) {
        if ($order->redeemed_voucher_type == 'amount') {
          //by amount
          //deduct voucher into item, so gross == total items
          $items[] = [
            'id' => 'voucher',
            'price' => -$order->redeemed_voucher_amount,
            'quantity' => 1,
            'name' => 'Voucher: ' . $order->redeemed_voucher_code,
          ];
        } else {
          //by percentage
          //deduct voucher into item, so gross == total items
          $items[] = [
            'id' => 'voucher',
            'price' => -$order->redeemed_voucher_amount,
            'quantity' => 1,
            'name' => 'Voucher: ' . $order->redeemed_voucher_code,
          ];
        }
      }

      //add point rewards discount
      if ($order->minus_reward_amount != null) {
        $items[] = [
          'id' => 'pointrewards',
          'price' => -$order->minus_reward_amount,
          'quantity' => 1,
          'name' => 'Point Rewards',
        ];
      }

      if ($finalshippingfee > 0) {
        //add shipping fee into the item
        $set_shipping_fee = 0;
        foreach ($order_details as $key) {
          if ($key->is_backorder == 'yes') {
            $set_shipping_fee += $key->shipping_fee;
          } else {
            $set_shipping_fee += 0;
          }
        }
        $items[] = [
          'id' => 'shipping',
          'price' => $set_shipping_fee,
          'quantity' => 1,
          'name' => 'Shipping Fee',
        ];

        //add free shipping
        if ($order->free_shipping_fee != null) {
          $items[] = [
            'id' => 'freeshipping',
            'price' => -$order->free_shipping_fee,
            'quantity' => 1,
            'name' => 'Free Shipping',
          ];
        }
      }

      //add creditcard total fee (transaction fee + admin fee)
      if ($this->session->userdata('chosen_payment_type') == 'veritrans') {
        $items[] = [
          'id' => 'veritrans_fee',
          'price' => (int) $this->session->userdata('veritrans_total_fee'),
          'quantity' => 1,
          'name' => 'Credit Card Admin',
        ];
      }

      //add virtualaccount total fee (admin fee)
      if ($this->session->userdata('chosen_payment_type') == 'virtualaccount') {
        $items[] = [
          'id' => 'virtualaccount_fee',
          'price' => (int) $this->session->userdata('virtualaccount_total_fee'),
          'quantity' => 1,
          'name' => 'Virtual Account Admin',
        ];
      }

      //add tax
      if ($this->session->userdata('tax')) {
        $items[] = [
          'id' => 'tax',
          'price' => (int) $this->session->userdata('tax'),
          'quantity' => 1,
          'name' => 'Tax',
        ];
      }
    } else {
      $items[] = [
        'id' => 'discount',
        'price' => -$total_item_price,
        'quantity' => 1,
        'name' => 'Discount',
      ];

      if ($finalshippingfee > 0) {
        //add shipping fee into the item
        $items[] = [
          'id' => 'shipping',
          'price' => $order->shipping_fee,
          'quantity' => 1,
          'name' => 'Shipping Fee',
        ];

        //add free shipping
        if ($order->free_shipping_fee != null) {
          $items[] = [
            'id' => 'freeshipping',
            'price' => -$order->free_shipping_fee,
            'quantity' => 1,
            'name' => 'Free Shipping',
          ];
        }
      }
    }

    // echo '<pre>';
    // print_r($items);
    // echo '</pre>';
    // exit();

    // Populate customer's billing address
    $billing_address = [
      'first_name' => $customer_data->shipping_name,
      'last_name' => '',
      'address' => $customer_data->shipping_address,
      'city' => $subdistrict . '. ' . $district . '. ' . $province,
      'postal_code' => $customer_data->shipping_postcode,
      'phone' => $customer_data->shipping_phone,
      'country_code' => 'IDN',
    ];

    // Populate customer's shipping address
    $shipping_address = [
      'first_name' => $customer_data->shipping_name,
      'last_name' => '',
      'address' => $customer_data->shipping_address,
      'city' => $subdistrict . '. ' . $district . '. ' . $province,
      'postal_code' => $customer_data->shipping_postcode,
      'phone' => $customer_data->shipping_phone,
      'country_code' => 'IDN',
    ];

    // Populate customer's Info
    $customer_details = [
      'first_name' => $customer_data->shipping_name,
      'last_name' => '',
      'email' => $customer_data->email,
      'phone' => $customer_data->shipping_phone,
      'billing_address' => $billing_address,
      'shipping_address' => $shipping_address,
    ];

    if ($midtrans->credit_card == 1) {
      //MIDTRANS CREDIT CARD
      $transaction_details_cc = [
        'order_id' => $order_id . '-cc',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_creditcard = [
        'enabled_payments' => ['credit_card'],
        'transaction_details' => $transaction_details_cc,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_cc'] = Veritrans_Snap::getSnapToken(
        $transaction_creditcard
      );
    }

    if ($midtrans->gopay == 1) {
      //MIDTRANS GOPAY
      $transaction_details_gopay = [
        'order_id' => $order_id . '-gopay',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_gopay = [
        'enabled_payments' => ['gopay'],
        'transaction_details' => $transaction_details_gopay,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_gopay'] = Veritrans_Snap::getSnapToken(
        $transaction_gopay
      );
    }

    if ($midtrans->akulaku == 1) {
      //MIDTRANS AKULAKU
      $transaction_details_akulaku = [
        'order_id' => $order_id . '-akulaku',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_akulaku = [
        'enabled_payments' => ['akulaku'],
        'transaction_details' => $transaction_details_akulaku,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_akulaku'] = Veritrans_Snap::getSnapToken(
        $transaction_akulaku
      );
    }

    if ($midtrans->permata_va == 1) {
      //MIDTRANS PERMATA VA
      $transaction_details_permatava = [
        'order_id' => $order_id . '-permatava',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_permatava = [
        'enabled_payments' => ['permata_va'],
        'transaction_details' => $transaction_details_permatava,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_permatava'] = Veritrans_Snap::getSnapToken(
        $transaction_permatava
      );
    }

    if ($midtrans->bni_va == 1) {
      //MIDTRANS BNI VA
      $transaction_details_bniva = [
        'order_id' => $order_id . '-bniva',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_bniva = [
        'enabled_payments' => ['bni_va'],
        'transaction_details' => $transaction_details_bniva,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_bniva'] = Veritrans_Snap::getSnapToken(
        $transaction_bniva
      );
    }

    if ($midtrans->mandiri_bill == 1) {
      //MIDTRANS MANDIRI BILL PAYMENT
      $transaction_details_echannel = [
        'order_id' => $order_id . '-echannel',
        'gross_amount' => (int) $grand_final_total,
      ];

      $transaction_echannel = [
        'enabled_payments' => ['echannel'],
        'transaction_details' => $transaction_details_echannel,
        'customer_details' => $customer_details,
        'item_details' => $items,
      ];

      $data['snapToken_echannel'] = Veritrans_Snap::getSnapToken(
        $transaction_echannel
      );
    }

    $data['order_id'] = $order_id;

    //create midtrans order_id session to be used by response success midtrans page
    $this->session->set_userdata('midtrans_order_id', $order_id);

    return $data;
  }

  public function bank_transfer_processing($bank_name = null, $order_id = null)
  {
    if ($bank_name == null && $order_id == null) {
      redirect('shipping');
    }

    $this->order_id = $order_id;

    $order = $this->db
      ->select('*')
      ->from('orders')
      ->where('id_orders', $order_id)
      ->get()
      ->row();

    //get order detail
    $order_details = $this->db
      ->select('*')
      ->from('orders_detail')
      ->where('orders_id', $order_id)
      ->get()
      ->result();

    //get customer district / city name
    $customer_data = $this->db
      ->select(
        'name, email, phone, shipping_address, shipping_id_district, shipping_id_subdistrict, shipping_id_province'
      )
      ->from('customers')
      ->where(
        'id_customers',
        (int) $this->session->userdata('customer')['customer_id']
      )
      ->get()
      ->row();

    //get subdistrict, distirct and province name
    $subdistrict = $this->db
      ->select('subdistrict')
      ->from('indonesia_subdistricts')
      ->where(
        'rajaongkir_id_subdistrict',
        $customer_data->shipping_id_subdistrict
      )
      ->get()
      ->row()->subdistrict;

    //get district
    $district = $this->db
      ->select('district')
      ->from('indonesia_districts')
      ->where('rajaongkir_id_district', $customer_data->shipping_id_district)
      ->get()
      ->row()->district;

    //get province
    $province = $this->db
      ->select('province')
      ->from('indonesia_provinces')
      ->where('rajaongkir_province_id', $customer_data->shipping_id_province)
      ->get()
      ->row()->province;

    //BCA manual bank transfer
    if ($bank_name == 'bca') {
      $payment_type = 'bank transfer BCA';

      $reseller_id = $this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id'])->get()->row()->reseller_id;

      if ($reseller_id == NULL) {
        //update payment status to become 1 // not paid
        $data = [
          'payment_status' => 1,
          'payment_type' => $payment_type,

        ];
        $this->db->where('id_orders', $order_id);
        $this->db->update('orders', $data);

        //Send email
        $this->process_send_email($payment_type);
      } else {

        $data = [
          'payment_status' => 0,
          'payment_type' => $payment_type,
        ];

        $this->db->where('id_orders', $order_id);
        $this->db->update('orders', $data);
      }
      //LOAD PAYMENT RETURN PAGE
      $data['bank'] = $this->configuration_m->get_bank();
      $data['email'] = $customer_data->email;
      $data['order_id'] = $order_id;

      $data['order_info'] = $this->db
        ->select(
          'insurance_status, insurance_cost, redeemed_voucher_type, minus_reward_amount, grand_total_amount, total_amount, indent_remaining, indent_shipping_fee, id_orders, order_date,payment_status, payment_confirm, recipient_name, address, district, subdistrict, province, postcode, shipping_fee, free_shipping_fee, minus_reward, redeemed_voucher_code, redeemed_voucher_amount, redeemed_voucher_value, first, referral'
        )
        ->from('orders')
        ->where('id_orders', $order_id)
        ->get()
        ->row();

      $this->destroy_session_data();

      if ($this->session->userdata('site_lang') == 'english') {
        $this->lang->load('order_history', 'english');
      } else {
        $this->lang->load('order_history', 'indonesian');
      }

      //create new session to display on thank you page
      $bca_data = [
        'grand_total' =>
        $data['order_info']->grand_total_amount -
          $data['order_info']->indent_remaining -
          $data['order_info']->indent_shipping_fee,
        'order_info' => $data['order_info'],
        'bank' => $data['bank'],
        'email' => $data['email'],
        'order_id' => $data['order_id'],
      ];
      $this->session->set_userdata('bca_data', $bca_data);

      if ($reseller_id == NULL) {
        redirect('payment/process_payment');
      } else {
        redirect('payment/retailer_approval_process');
      }
    }

    //MANDIRI manual bank transfer
    if ($bank_name == 'mandiri') {
      $payment_type = 'bank transfer MANDIRI';

      $reseller_id = $this->db->select('reseller_id')->from('customers')->where('id_customers', $this->session->userdata('customer')['customer_id'])->get()->row()->reseller_id;

      if ($reseller_id == NULL) {
        //update payment status to become 1 // not paid
        $data = [
          'payment_status' => 1,
          'payment_type' => $payment_type,

        ];
        $this->db->where('id_orders', $order_id);
        $this->db->update('orders', $data);

        //Send email
        $this->process_send_email($payment_type);
      } else {

        $data = [
          'payment_status' => 0,
          'payment_type' => $payment_type,
        ];

        $this->db->where('id_orders', $order_id);
        $this->db->update('orders', $data);
      }



      //LOAD PAYMENT RETURN PAGE
      $data['bank'] = $this->configuration_m->get_bank1();
      $data['email'] = $customer_data->email;
      $data['order_id'] = $order_id;

      $data['order_info'] = $this->db
        ->select(
          'insurance_status, insurance_cost, redeemed_voucher_type, minus_reward_amount, grand_total_amount, total_amount, indent_remaining, indent_shipping_fee, id_orders, order_date,payment_status, payment_confirm, recipient_name, address, district, subdistrict, province, postcode, shipping_fee, free_shipping_fee, minus_reward, redeemed_voucher_code, redeemed_voucher_amount, redeemed_voucher_value, first, referral'
        )
        ->from('orders')
        ->where('id_orders', $order_id)
        ->get()
        ->row();

      $this->destroy_session_data();

      if ($this->session->userdata('site_lang') == 'english') {
        $this->lang->load('order_history', 'english');
      } else {
        $this->lang->load('order_history', 'indonesian');
      }

      //create new session to display on thank you page
      $mandiri_data = [
        'grand_total' =>
        $data['order_info']->grand_total_amount -
          $data['order_info']->indent_remaining -
          $data['order_info']->indent_shipping_fee,
        'order_info' => $data['order_info'],
        'bank' => $data['bank'],
        'email' => $data['email'],
        'order_id' => $data['order_id'],
      ];
      $this->session->set_userdata('mandiri_data', $mandiri_data);

      if ($reseller_id == NULL) {
        redirect('payment/process_payment');
      } else {
        redirect('payment/retailer_approval_process');
      }
    }
  }

  public function retailer_approval_process()
  {
    if (
      !$this->session->userdata('bca_data') &&
      !$this->session->userdata('mandiri_data')
    ) {
      redirect(base_url());
    }

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('order_history', 'english');
    } else {
      $this->lang->load('order_history', 'indonesian');
    }

    $this->data_header['datalayer'] = [
      'ecomm_pagetype' => 'purchase',
    ];

    if ($this->session->userdata('bca_data')) {
      //get SEO
      $this->db
        ->select('website_name')
        ->from('configuration')
        ->where('id_configuration', 1);
      $website_name = $this->db->get()->row();
      $this->data_header['browser_title'] =
        ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';
      $this->data_header['meta_description'] =
        ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';

      $data = $this->session->userdata('bca_data');
    }

    if ($this->session->userdata('mandiri_data')) {
      //get SEO
      $this->db
        ->select('website_name')
        ->from('configuration')
        ->where('id_configuration', 1);
      $website_name = $this->db->get()->row();
      $this->data_header['browser_title'] =
        ucwords($website_name->website_name) .
        ' - MANDIRI Manual Bank Transfer';
      $this->data_header['meta_description'] =
        ucwords($website_name->website_name) .
        ' - MANDIRI Manual Bank Transfer';

      $data = $this->session->userdata('mandiri_data');
    }

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('payment', 'english');
    } else {
      $this->lang->load('payment', 'indonesian');
    }

    $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('retailerapproval', $data);
    $this->load->view("themes/$this->theme_no/footer", $this->data_footer);

    //destroy bank data
    $this->session->unset_userdata('bca_data');
    $this->session->unset_userdata('mandiri_data');
  }

  public function process_payment()
  {
    if (
      !$this->session->userdata('bca_data') &&
      !$this->session->userdata('mandiri_data')
    ) {
      redirect(base_url());
    }

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('order_history', 'english');
    } else {
      $this->lang->load('order_history', 'indonesian');
    }

    $this->data_header['datalayer'] = [
      'ecomm_pagetype' => 'purchase',
    ];

    if ($this->session->userdata('bca_data')) {
      //get SEO
      $this->db
        ->select('website_name')
        ->from('configuration')
        ->where('id_configuration', 1);
      $website_name = $this->db->get()->row();
      $this->data_header['browser_title'] =
        ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';
      $this->data_header['meta_description'] =
        ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';

      $data = $this->session->userdata('bca_data');
    }

    if ($this->session->userdata('mandiri_data')) {
      //get SEO
      $this->db
        ->select('website_name')
        ->from('configuration')
        ->where('id_configuration', 1);
      $website_name = $this->db->get()->row();
      $this->data_header['browser_title'] =
        ucwords($website_name->website_name) .
        ' - MANDIRI Manual Bank Transfer';
      $this->data_header['meta_description'] =
        ucwords($website_name->website_name) .
        ' - MANDIRI Manual Bank Transfer';

      $data = $this->session->userdata('mandiri_data');
    }

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('payment', 'english');
    } else {
      $this->lang->load('payment', 'indonesian');
    }

    $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('banktransfer', $data);
    $this->load->view("themes/$this->theme_no/footer", $this->data_footer);

    //destroy bank data
    $this->session->unset_userdata('bca_data');
    $this->session->unset_userdata('mandiri_data');
  }

  public function free_order()
  {
    $order_id = $this->session->userdata('free_order_id');
    $this->session->unset_userdata('free_order_id');

    if ($order_id == null) {
      redirect('welcome');
    }

    //get customer district / city name
    $customer_data = $this->db
      ->select(
        'name, email, phone, shipping_address, shipping_id_district, shipping_id_subdistrict, shipping_id_province'
      )
      ->from('customers')
      ->where(
        'id_customers',
        (int) $this->session->userdata('customer')['customer_id']
      )
      ->get()
      ->row();

    //LOAD PAYMENT RETURN PAGE
    $data['email'] = $customer_data->email;
    $data['order_id'] = $order_id;

    $data['order_info'] = $this->db
      ->select(
        'insurance_status, insurance_cost, id_orders,order_date,payment_status,payment_confirm,recipient_name,address,district,subdistrict,province,postcode'
      )
      ->from('orders')
      ->where('id_orders', $order_id)
      ->get()
      ->row();
    $data['grand_total'] = '0';

    $this->destroy_session_data();

    if ($this->session->userdata('site_lang') == 'english') {
      $this->lang->load('order_history', 'english');
    } else {
      $this->lang->load('order_history', 'indonesian');
    }

    //get SEO
    $website_name = $this->db
      ->select('website_name')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();
    $this->data_header['browser_title'] =
      ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';
    $this->data_header['meta_description'] =
      ucwords($website_name->website_name) . ' - BCA Manual Bank Transfer';

    $this->load->view("themes/$this->theme_no/header", $this->data_header);
    $this->load->view('free_order', $data);
    $this->load->view("themes/$this->theme_no/footer", $this->data_footer);
  }

  private function send_confirmation_email($paymentType, $orderData, $orderDetails, $bankData)
  {
    $email_data['email'] = $orderData['email'];
    $email_data['name'] = $orderData['name'];
    $email_data['phone'] = $orderData['phone'];
    $email_data['type'] = $orderData['type'];

    $email_data['emails'] = $this->configuration_m->get_emails();
    $email_data['bank'] = $bankData;
    if ($this->session->userdata('site_lang') == 'english') {
      $email_data['subject'] = 'Order Confirmation';
    } else {
      $email_data['subject'] = 'Konfirmasi Pesanan';
    }
    $email_data['order'] = $orderData;
    $email_data['order_details'] = $orderDetails;


    switch ($paymentType) {
      case 'bca':
        if ($this->session->userdata('site_lang') == 'english') {
          $view_file = 'email/english/bank_transfer_english';
        } else {
          $view_file = 'email/indonesian/bank_transfer_indo';
        }
        break;
      case 'mandiri':
        if ($this->session->userdata('site_lang') == 'english') {
          $view_file = 'email/english/bank_transfer_english';
        } else {
          $view_file = 'email/indonesian/bank_transfer_indo';
        }
        break;
    }

    $data_log = [
      'recipient_name' => $orderData['name'],  // Alamat email penerima
      'recipient_email' => $orderData['email'],  // Alamat email penerima
      'recipient_phone' => $orderData['phone'],  // no telp penerima
      'recipient_type' => $orderData['type'],  // Alamat email penerima
      'subject' => $email_data['subject'],        // Subjek email
      'email_body' => $this->load->view($view_file, $email_data, TRUE),  // Isi email
    ];

    // Loggin berhasil
    $this->db->insert('email_payment_log', $data_log);
    $this->send_email($view_file, $email_data);
  }
  private function process_send_email($payment_type)
  {
    //----SEND EMAIL TO CUSTOMER
    //get customer name
    if ($this->session->userdata('customer')['customer_id'] != null) {
      $customer_id = (int) $this->session->userdata('customer')['customer_id'];
    } else {
      $customer_id = $this->db
        ->select('customer_id')
        ->from('orders')
        ->where('id_orders', $this->order_id)
        ->get()
        ->row()->customer_id;
    }
    $this->db
      ->select('name,phone,type,email')
      ->from('customers')
      ->where('id_customers', $customer_id);
    $email_data['customer'] = $this->db->get()->row();
    $email_data['email'] = $email_data['customer']->email;
    $email_data['name'] = $email_data['customer']->name;
    $email_data['phone'] = $email_data['customer']->phone;
    $email_data['type'] = $email_data['customer']->type;

    $email_data['emails'] = $this->configuration_m->get_emails();

    if ($payment_type == 'bank transfer BCA') {
      $email_data['bank'] = $this->db
        ->select('bank')
        ->from('configuration')
        ->where('id_configuration', 1)
        ->get()
        ->row()->bank;
    } elseif ($payment_type == 'bank transfer MANDIRI') {
      $email_data['bank'] = $this->db
        ->select('bank1')
        ->from('configuration')
        ->where('id_configuration', 1)
        ->get()
        ->row()->bank1;
    }

    if ($this->session->userdata('site_lang') == 'english') {
      $email_data['subject'] = 'Order Confirmation';
    } else {
      $email_data['subject'] = 'Konfirmasi Pesanan';
    }

    //get order detail and customer detail
    $email_data['order'] = $this->order_m->get_order($this->order_id);
    $email_data['order_details'] = $this->order_detail_m->get_orders_detail(
      $this->order_id
    );

    //get vouchers detail
    if ($this->session->userdata('chosen_voucher_code')) {
      $email_data['chosen_voucher_code'] = $this->session->userdata(
        'chosen_voucher_code'
      );
      $email_data['chosen_voucher_type'] = $this->session->userdata(
        'chosen_voucher_type'
      );
      $email_data['chosen_voucher_discount'] = $this->session->userdata(
        'chosen_voucher_discount'
      );
      $email_data['redeemed_voucher_amount'] = $this->session->userdata(
        'redeemed_voucher_amount'
      );
    }

    //get shipping fee total
    $email_data['carrier_name'] = $this->session->userdata('carrier_name');
    $email_data['total_shipping_fee'] = $this->session->userdata(
      'total_shipping_fee'
    );

    //add tax to email, if exist..
    if ($this->session->userdata('tax')) {
      $email_data['tax'] = $this->session->userdata('tax');
    }

    //add point reward to email, if exist..
    if ($this->session->userdata('chosen_point')) {
      $email_data['chosen_point'] = $this->session->userdata('chosen_point');
      $email_data['chosen_point_discount'] = $this->session->userdata(
        'chosen_point_discount'
      );
    }

    switch ($payment_type) {
      case 'bank transfer BCA':
        if ($this->session->userdata('site_lang') == 'english') {
          $view_file = 'email/english/bank_transfer_english';
        } else {
          $view_file = 'email/indonesian/bank_transfer_indo';
        }
        break;
      case 'bank transfer MANDIRI':
        if ($this->session->userdata('site_lang') == 'english') {
          $view_file = 'email/english/bank_transfer_english';
        } else {
          $view_file = 'email/indonesian/bank_transfer_indo';
        }
        break;
      case 'cod':
        if ($this->session->userdata('site_lang') == 'english') {
          $view_file = 'email/english/cod';
        } else {
          $view_file = 'email/indonesian/cod';
        }
        break;
      case 'midtrans':
        if ($this->session->userdata('site_lang') == 'english') {
          /*$email = $this->load->view('email/english/bank_transfer', $data, TRUE);   */
          $view_file = 'email/english/bank_transfer_english';
        } else {
          $view_file = 'email/indonesian/bank_transfer_indo';
        }
        break;
    }
    $data_log = [
      'recipient_name' => $email_data['name'],  // Alamat email penerima
      'recipient_email' => $email_data['email'],  // Alamat email penerima
      'recipient_phone' => $email_data['phone'],  // no telp penerima
      'recipient_type' => $email_data['type'],  // Alamat email penerima
      'subject' => $email_data['subject'],        // Subjek email
      'email_body' => $this->load->view($view_file, $email_data, TRUE),  // Isi email
    ];

    $this->db->insert('email_payment_log', $data_log);


    $this->send_email($view_file, $email_data); //function in My_Controller
  }

  private function destroy_session_data()
  {
    if ($this->session->userdata('customer')['customer_type'] == 'guest') {
      $this->session->unset_userdata('customer');
    }

    //DESTROY CART AND UNSET SOME SESSION, BUT NOT CUSTOMER SESSION
    $this->cart->destroy();
    $this->session->unset_userdata('grand_total');
    $this->session->unset_userdata('recipient_name');
    $this->session->unset_userdata('address');
    $this->session->unset_userdata('id_district');
    $this->session->unset_userdata('id_subdistrict');
    $this->session->unset_userdata('id_province');
    $this->session->unset_userdata('district');
    $this->session->unset_userdata('subdistrict');
    $this->session->unset_userdata('province');
    $this->session->unset_userdata('country');
    $this->session->unset_userdata('postcode');
    $this->session->unset_userdata('phone');
    $this->session->unset_userdata('order_id');
    $this->session->unset_userdata('is_from_cart');
    $this->session->unset_userdata('chosen_voucher_type');
    $this->session->unset_userdata('chosen_voucher_discount');
    $this->session->unset_userdata('chosen_voucher_code');
    $this->session->unset_userdata('total_categoryproduct_promo');
    $this->session->unset_userdata('redeemed_voucher_amount');
    $this->session->unset_userdata('total_shipping_fee');
    $this->session->unset_userdata('referral');
    $this->session->unset_userdata('gimmickeligible');
    $this->session->unset_userdata('carrier');
    $this->session->unset_userdata('carrier_name');
    $this->session->unset_userdata('summary_message');
    $this->session->unset_userdata('add_point_reward');
    $this->session->unset_userdata('minus_point_reward');
    $this->session->unset_userdata('chosen_point');
    $this->session->unset_userdata('chosen_point_discount');
    $this->session->unset_userdata('chosen_payment_type');
    $this->session->unset_userdata('tax');
    $this->session->unset_userdata('productpage_to_cart');
    $this->session->unset_userdata('choose_dropship_status');
    $this->session->unset_userdata('destination_latitude');
    $this->session->unset_userdata('destination_longitude');
    $this->session->unset_userdata('current_viewed_category_id');
    $this->session->unset_userdata('shipping_cart');
    $this->session->unset_userdata('prescription_uniqid');
    $this->session->unset_userdata('guest_details');
    $this->session->unset_userdata('guest_shipping_id');
    $this->session->unset_userdata('customer_note');
    $this->session->unset_userdata('referral'); //unset user referral data after payment successful
    $this->session->unset_userdata('visitor_tracking');
    $this->session->unset_userdata('initial_visitor_tracking');
    $this->session->unset_userdata('current_page_tracked');
  }

  public function send_email_view()
  {
    $orderId = 194196;
    $paymentType = "bca";
    $orderData = $this->getOrderDataById($orderId);
    $orderDetails = $this->getOrderDetailByOrderId($orderId);
    $bankData = $this->getBankData($paymentType);
    $website_data = $this->db->select('website_icon, browser_title, meta_description')
      ->from('configuration')
      ->where('id_configuration', 1)
      ->get()
      ->row();

    $data_view = [
      'orderData' => $orderData,
      'orderDetails' => $orderDetails,
      'paymentType' => $paymentType,
      'bankData' => $bankData,
      'website_icon' => $website_data->website_icon,
      'browser_title' => ucwords($website_data->browser_title) . ' - Payment Confirmation',
      'meta_description' => $website_data->meta_description,
    ];
    $this->load->view('email/indonesian/bank_transfer_indo', $data_view);
  }
}