<?php include 'lib/core.php';


//Show All data
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $show = "SELECT vendor_payouts.*,vendor_profile.full_name,vendor_login.contact,booking_types.title FROM vendor_payouts INNER JOIN vendor_profile ON vendor_profile.vendor_id=vendor_payouts.vendor_id INNER JOIN vendor_login ON vendor_profile.vendor_id=vendor_login.id LEFT JOIN booking_types ON booking_types.id=vendor_payouts.company_id ORDER BY vendor_payouts.id DESC";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $row['created_at'] =date("d-m-Y h:i:s", strtotime($row['created_at']));
                $showdata[] = $row;
            }
            echo json_encode($showdata);
        }
    }
}


if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding available_vehicle

    if (isset($_POST['vendor_id'])) {
        $vendor_id = $_POST['vendor_id'];
        $amount = $_POST['amount'];
        $transaction_type = $_POST['transaction_type'];
        $company_id = $_POST['company_id'];
        $note = $_POST['note'];
        $created_at = date("Y-m-d h:i:s");
        $add = $conn->query("INSERT INTO vendor_payouts(vendor_id,amount,note,transaction_type,company_id,created_at) VALUES('$vendor_id','$amount','$note','$transaction_type','$company_id','$created_at')");

        $res=$conn->query("SELECT * FROM vendor_profile INNER JOIN vendor_login ON vendor_login.id=vendor_profile.vendor_id WHERE vendor_id='$vendor_id'");
    $vendor_data = $res->fetch_assoc();
$tds = 0.01*$amount;
$finalamount= $amount-$tds;
$msg = "Hi ".$vendor_data['full_name']."
Your ".$transaction_type." amount is Rs. ".$amount."/-
1% TDS Deduction 
total payout amount is Rs. ".$finalamount."/-

".$note."
            
Thanks & Regards
CabZ 4 U
Contact number 
👇
7830530004 7060000113 7830530005";

whatsapp($vendor_data['contact'],$msg);

        if ($add) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }

    }

}

?>