<?php
include("conn.php");
session_start();
if ($_POST['action']) {
  $action = $_POST['action'];
  //Add Data Start
  if ($action == "Add") {
      

      $cashback_for = $_POST['cashback_for'];
      $value = $_POST['value'];
      $user = $_POST['user'];
      $valid_upto = $_POST['valid_upto'];
      if($_POST['code']!="")
      {
      $code = $_POST['code'];
      }
      else
      {
          if($_POST['cashback_for']=="Individual")
          $code = 'USER'. mt_rand(1000, 9999);
          else
          $code = 'MHACB'. mt_rand(1000, 9999);
      }
      
      $sql = "insert into tbl_cashback(cashback_code,cashback_for,user,value,date,valid_upto)values('$code','$cashback_for','$user','$value',CURDATE(),'$valid_upto')";
      if (mysqli_query($conn, $sql)) {
        echo "Cashback Added Successfully";
      } else {
        echo "Failed to Add Cashback. Error:" . mysqli_error($conn);
      }

  }
  else if ($action == "Edit") {
      

      $cashback_for = $_POST['cashback_for'];
      $value = $_POST['value'];
      $user = $_POST['user'];
      $valid_upto = $_POST['valid_upto'];
      if($_POST['code']!="")
      {
      $code = $_POST['code'];
      }
      else
      {
          if($_POST['cashback_for']=="Individual")
          $code = 'USER'. mt_rand(1000, 9999);
          else
          $code = 'MHACB'. mt_rand(1000, 9999);
      }
      
      $sql = "update tbl_cashback set cashback_code='$code',cashback_for='$cashback_for',user='$user',value='$value',valid_upto='$valid_upto' where id='$id'";
      if (mysqli_query($conn, $sql)) {
        echo "Cashback Updated Successfully";
      } else {
        echo "Failed to Update Cashback. Error:" . mysqli_error($conn);
      }

  }

  else if ($action == "Delete") {
    $id = $_POST['id'];

    $sql = "update tbl_cashback set deleted_at=CURRENT_TIMESTAMP() where id='$id'";
    if (mysqli_query($conn, $sql)) {
      echo "Cashback deleted successfully.";
    } else {
      echo "Cashback not deleted. Error:" . mysqli_error($conn);
    }
  }
  //Delete Data End
} else {
  echo "Invalid action specified.";
}
mysqli_close($conn);
?>