<?php

    require_once('php/razorpay-php/Razorpay.php');
    include 'php/config.php';
    include 'php/db.connect.php';
    include 'php/generate_inv_no.php';
    use Razorpay\Api\Api;
    use Razorpay\Api\Errors\SignatureVerificationError;
    date_default_timezone_set('Asia/Kolkata');
    $api = new Api($keyId, $keySecret);
    $user_id = $_REQUEST['user_id'];
    $shipping = $_REQUEST['shipping'];
    $razorpay_payment_id = $_REQUEST['razorpay_payment_id'];
    $razorpay_signature = $_REQUEST['razorpay_signature'];
    $razorpay_order_id = $_REQUEST['razorpay_order_id'];
    $dealer_id = $_REQUEST['dealer_id'];
    $date_time=date('Y-m-d H:i:s');
    $time = date('H:i:s');
    $success = true;
    $error = "Payment Failed";
// echo  $Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`varstatus`,`order_tc_id`,`orderstatus`,`res_id`,`type`,`order_date_time`) VALUES ('$sessionid_free','$browsessionid','$maxcorderid','$orderid_new_s','0','0','0','0','','$dt2')";

if (empty($razorpay_payment_id) === false) {
    $api = new Api($keyId, $keySecret);

    try
    {
        // Please note that the razorpay order ID must
        // come from a trusted source (session here, but
        // could be database or something else)
        $attributes = array(
            'razorpay_order_id' => $razorpay_order_id,
            'razorpay_payment_id' => $razorpay_payment_id,
            'razorpay_signature' => $razorpay_signature ,
        );

        $api->utility->verifyPaymentSignature($attributes);
    } catch (SignatureVerificationError $e) {
        $success = false;
        $error = 'Razorpay Error : ' . $e->getMessage();
    }
}

if ($success === true) {
   if($shipping == "yes"){
    $order_tc_id = 0;
   }else{
    $order_tc_id = 1;
   }

 $get_co = mysqli_query($conn, "SELECT * FROM `tbl_confirmorder` WHERE varstatus!='Cash' and company_name='Energy Foods' and `orid` in (select orderid from tbl_order)");
 $check_ref_rows = mysqli_num_rows($get_co);
 $ref_id = generate('2', $conn);
 
// get dealer discount info
  $get_bill_user = mysqli_query($conn, "SELECT * FROM shop_user where user_id='$user_id'");
  $set_bill_user = mysqli_fetch_assoc($get_bill_user);
    $offer = $set_bill_user['discount'];
  
    // get dealer shipping charges
    $get_ship = mysqli_query($conn, "SELECT amount_dealer_2 from tbl_courier_charges where `state`='".$set_bill_user['state']."'"); 
    
    $check_ship_rows = mysqli_num_rows($get_ship);
    if($check_ship_rows > 0){
        $set_ship = mysqli_fetch_assoc($get_ship);
        $cust_ship = $set_ship['amount_dealer_2'];
    }else{
       $get_others = mysqli_query($conn, "SELECT amount_dealer_2 from tbl_courier_charges where `state`='Others'"); 
       $set_others = mysqli_fetch_assoc($get_others);
       $cust_ship = $set_others['amount_dealer_2'];
    }
// main order
$insert = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`refid`,`varstatus`,`order_tc_id`,`orderstatus`,`res_id`,`type`,`order_date_time`, `contry`, `city`, `state`, `address`, `pin`,`dif_name`, `dif_phone`, `company_name`, `offer`, `need_shipping`, `custom_charge`) VALUES 
('$user_id','  $razorpay_payment_id ','$ref_id','Razorpay','$order_tc_id','0','0','','$date_time', '".$set_bill_user['country']."', '".$set_bill_user['city']."', '".$set_bill_user['state']."', '".$set_bill_user['address']."', '".$set_bill_user['postcode']."','".$set_bill_user['name']."','".$set_bill_user['phone']."', 'Energy Foods', '$offer', '2', '$cust_ship')";	

if(mysqli_query($conn, $insert)){
    $last = mysqli_insert_id($conn);
    $update = "UPDATE tbl_confirmorder SET orderid = '$last' where orid='$last'";
    mysqli_query($conn, $update);

// order list

$get_ord = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_temp where dealer_id = '$dealer_id'");
while($set_ord = mysqli_fetch_assoc($get_ord)){
    $insert_ord = "INSERT INTO tbl_order (price,totprice,orderdate,ordertime,user_id,res_id,`type`,productid,session_id,orderid,qty,batchno,freeqty,need_shipping,custom_charge) VALUES
	 ('".$set_ord['price']."','".$set_ord['tot_price']."','$date_time','$time','$user_id',0,'','".$set_ord['prod_id']."','$razorpay_payment_id','$last','".$set_ord['qty']."','va','0',NULL,NULL)";
mysqli_query($conn, $insert_ord);
}
$delete = mysqli_query($conn, "DELETE FROM tbl_dealer_ef_temp where dealer_id='$dealer_id'");
mysqli_query($conn, $delete);
header('Location: payment_success_dealer.php?ref_no='.$razorpay_payment_id.'&order_id='.$ref_id);
}
}
?>