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

//ADDING Drivers DATA

if(isset($_POST["name"]))
{
    $name=test_input($_POST['name']);
    $vendor=test_input($_POST['vendor']);
    $contact=test_input($_POST['contact']);
    $altcontact=test_input($_POST['altContact']);
    $dlno=test_input($_POST['dlno']);
    $created_at=date('Y-m-d H:i:s');

    $dir='uploads/driver/';

    if (isset($_FILES['dl_front_image']) && $_FILES['dl_front_image']['error'] == 0) {
        $ext = str_replace(" ","",$_FILES['dl_front_image']['name']);
        $dl_name='DL_'.$driver_name.rand(000,999).'_'.$ext;
        $dir_dl=$dir.$dl_name;
        move_uploaded_file($_FILES['dl_front_image']['tmp_name'], '../cabzvendor_api/' .$dir_dl);
    }
    
    if (isset($_FILES['dl_back_image']) && $_FILES['dl_back_image']['error'] == 0) {
        $ext = str_replace(" ","",$_FILES['dl_back_image']['name']);
        $dl_back_name='DL_BACK_'.$driver_name.rand(000,999).'_'.$ext;
        $dir_dl_back=$dir.$dl_back_name;
        move_uploaded_file($_FILES['dl_back_image']['tmp_name'], '../cabzvendor_api/' .$dir_dl_back);
    }
    if (isset($_FILES['aadhar_front_image']) && $_FILES['aadhar_front_image']['error'] == 0) {
        $ext = str_replace(" ","",$_FILES['aadhar_front_image']['name']);
        $adhaar_name='ADHAAR_'.$driver_name.rand(000,999).'_'.$ext;
        $dir_adhaar=$dir.$adhaar_name;
        move_uploaded_file($_FILES['aadhar_front_image']['tmp_name'], '../cabzvendor_api/' .$dir_adhaar);
    }

    if (isset($_FILES['aadhar_back_image']) && $_FILES['aadhar_back_image']['error'] == 0) {   
        $ext = str_replace(" ","",$_FILES['aadhar_back_image']['name']);
        $adhaar_back_name='ADHAAR_BACK_'.$driver_name.rand(000,999).'_'.$ext;
        $dir_adhaar_back=$dir.$adhaar_back_name;
        move_uploaded_file($_FILES['aadhar_back_image']['tmp_name'], '../cabzvendor_api/' .$dir_adhaar_back);
    }

    if (isset($_FILES['driver_image']) && $_FILES['driver_image']['error'] == 0) {   
        $ext = str_replace(" ","",$_FILES['driver_image']['name']);
        $selfie_name='SELFIE_'.$driver_name.rand(000,999).'_'.$ext;
        $dir_selfie=$dir.$selfie_name;
        move_uploaded_file($_FILES['driver_image']['tmp_name'], '../cabzvendor_api/' .$dir_selfie);
    }


    $sql="insert into drivers (driver_name,vendor_id,contact,alternate_contact,d_l_no,dl_img, dl_back_img, adhaar, adhaar_back, picture,created_at) values('$name','$vendor','$contact','$altcontact','$dlno','$dir_dl','$dir_dl_back','$dir_adhaar','$dir_adhaar_back','$dir_selfie','$created_at')";            
    if($conn->query($sql))
    {
      echo "success";
  }
  else
  {
      echo $conn->error;
  }
}
//DELETING Drivers DATA

if(isset($_POST['delete_id']))
{
    $id_d=$_POST["delete_id"];
    $sql="delete from drivers where id=$id_d";
    if($conn->query($sql))
    {
        echo "success";

    }
    else
        echo "error";
}

//FETCHING Drivers DETAILS

if(isset($_POST['driver_details']))
{
    if($_POST['filter']){
        $date = explode('-', $_POST['filter']);
        $date1 = date('Y-m-d', strtotime($date[0]));
        $date2 = date('Y-m-d', strtotime($date[1]));
        $filter="AND DATE(created_at) BETWEEN '$date1' AND '$date2'";

    }else{
        $filter='';
    }

    $sql="SELECT d.* ,v.full_name FROM drivers d ,vendor_profile v where v.vendor_id=d.vendor_id $filter";
    if($result=$conn->query($sql))
    {
        if($result->num_rows>0)
        {
            $all_drivers=array();
            while($row=$result->fetch_assoc())
            {
                //   echo $row;
               $all_drivers[]=$row;
           }
           echo json_encode($all_drivers);
       }
       else
        echo "unable to fetch data";
}    
}

//UPDATING Drivers DATA

// if(isset($_POST["ename"]))
// {
//     $id=$_POST['edit'];
//     $name=test_input($_POST['ename']);
//     $evendor=test_input($_POST['evendor']);
//     $econtact=test_input($_POST['econtact']);
//     $ealtContact=test_input($_POST['ealtContact']);
//     $dlno=test_input($_POST['edlno']);
//     $sql="update drivers set driver_name ='$name',vendor_id='$evendor',contact='$econtact',alternate_contact='$ealtContact',d_l_no= '$dlno' where id=$id";
//     if($conn->query($sql))
//     {
//       echo "success";
//   }
//   else
//   {
//       echo "error";
//   }
// }


if (isset($_POST["ename"])) {
    // Sanitize input data
    $name = test_input($_POST['ename']);
    $vendor = test_input($_POST['evendor']);
    $contact = test_input($_POST['econtact']);
    $altcontact = test_input($_POST['ealtContact']);
    $dlno = test_input($_POST['edlno']);
    $id = test_input($_POST['edit']); 

    $dir = 'uploads/driver/';

    // Initialize variables for uploaded file paths
    $updateFields = [];

    // Handle DL Front Image
    if (isset($_FILES['dl_front_image']) && $_FILES['dl_front_image']['error'] == 0) {
        $ext = str_replace(" ", "", $_FILES['dl_front_image']['name']);
        $dl_name = 'DL_' . $name . rand(100, 999) . '_' . $ext;
        $dir_dl = $dir . $dl_name;
        move_uploaded_file($_FILES['dl_front_image']['tmp_name'], '../cabzvendor_api/' . $dir_dl);
        $updateFields[] = "dl_img = '$dir_dl'";
    }

    // Handle DL Back Image
    if (isset($_FILES['dl_back_image']) && $_FILES['dl_back_image']['error'] == 0) {
        $ext = str_replace(" ", "", $_FILES['dl_back_image']['name']);
        $dl_back_name = 'DL_BACK_' . $name . rand(100, 999) . '_' . $ext;
        $dir_dl_back = $dir . $dl_back_name;
        move_uploaded_file($_FILES['dl_back_image']['tmp_name'], '../cabzvendor_api/' . $dir_dl_back);
        $updateFields[] = "dl_back_img = '$dir_dl_back'";
    }

    // Handle Aadhar Front Image
    if (isset($_FILES['aadhar_front_image']) && $_FILES['aadhar_front_image']['error'] == 0) {
        $ext = str_replace(" ", "", $_FILES['aadhar_front_image']['name']);
        $adhaar_name = 'ADHAAR_' . $name . rand(100, 999) . '_' . $ext;
        $dir_adhaar = $dir . $adhaar_name;
        move_uploaded_file($_FILES['aadhar_front_image']['tmp_name'], '../cabzvendor_api/' . $dir_adhaar);
        $updateFields[] = "adhaar = '$dir_adhaar'";
    }

    // Handle Aadhar Back Image
    if (isset($_FILES['aadhar_back_image']) && $_FILES['aadhar_back_image']['error'] == 0) {
        $ext = str_replace(" ", "", $_FILES['aadhar_back_image']['name']);
        $adhaar_back_name = 'ADHAAR_BACK_' . $name . rand(100, 999) . '_' . $ext;
        $dir_adhaar_back = $dir . $adhaar_back_name;
        move_uploaded_file($_FILES['aadhar_back_image']['tmp_name'], '../cabzvendor_api/' . $dir_adhaar_back);
        $updateFields[] = "adhaar_back = '$dir_adhaar_back'";
    }

    // Handle Driver Selfie
    if (isset($_FILES['driver_image']) && $_FILES['driver_image']['error'] == 0) {
        $ext = str_replace(" ", "", $_FILES['driver_image']['name']);
        $selfie_name = 'SELFIE_' . $name . rand(100, 999) . '_' . $ext;
        $dir_selfie = $dir . $selfie_name;
        move_uploaded_file($_FILES['driver_image']['tmp_name'], '../cabzvendor_api/' . $dir_selfie);
        $updateFields[] = "picture = '$dir_selfie'";
    }

    // Add non-image fields to update query
    $updateFields[] = "driver_name = '$name'";
    $updateFields[] = "vendor_id = '$vendor'";
    $updateFields[] = "contact = '$contact'";
    $updateFields[] = "alternate_contact = '$altcontact'";
    $updateFields[] = "d_l_no = '$dlno'";

    // Build the update query
    $sql = "UPDATE drivers SET " . implode(", ", $updateFields) . " WHERE id = '$id'";

    // Execute the query
    if ($conn->query($sql)) {
        echo "success";
    } else {
        echo "Error: " . $conn->error;
    }
}


// server side get

if(isset($_REQUEST['driver_list'])){
    if($_REQUEST['filter']){
        $date = explode('-', $_REQUEST['filter']);
        $date1 = date('Y-m-d', strtotime($date[0]));
        $date2 = date('Y-m-d', strtotime($date[1]));
        $filter="AND DATE(created_at) BETWEEN '$date1' AND '$date2'";

    }else{
        $filter='';
    }

    $sql="SELECT d.* ,v.full_name FROM drivers d ,vendor_profile v where v.vendor_id=d.vendor_id $filter";

// Fetch data
    $result = $conn->query($sql);
    $totalData = $result->num_rows;


// Server-side processing

    if (!empty($_REQUEST['search']['value'])) {
        $sql .= " AND (driver_name LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR d.vendor_id LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR full_name LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR d_l_no LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR d.contact LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR d.alternate_contact LIKE '%" . $_REQUEST['search']['value'] . "%' ";
        $sql .= " OR d.id LIKE '%" . $_REQUEST['search']['value'] . "%' )";
    }

    $query = mysqli_query($conn, $sql);
    $totalFiltered = mysqli_num_rows($query);



// Server-side processing
    $sql .= " ORDER BY d.id DESC";
    if($_REQUEST['length']!=-1){
        $sql .= " LIMIT " . $_REQUEST['start'] . ", " . $_REQUEST['length'];
        }

    $result = $conn->query($sql);
    $totalFiltered = $totalData;

    $data = array();
$serial = $_REQUEST['start'] + 1; // Serial number counter
while ($row = $result->fetch_assoc()) {

    $nestedData = array();
    $nestedData[] = $serial; // Serial number
    $nestedData[] = '<span id="driver_name'.$serial.'">'.$row['driver_name'].'</span>';
    $nestedData[] = '<span id="full_name'.$serial.'">'.$row['full_name'].'
    <input id="vendor_id'.$serial.'" type="hidden" value="'.$row['vendor_id'].'"></span>';
    $nestedData[] = '<span id="d_l_no'.$serial.'">'.$row['d_l_no'].'</span>';
    $nestedData[] = '<span id="contact'.$serial.'">'.$row['contact'].'</span>';
    $nestedData[] = '<span id="alternate_contact'.$serial.'">'.$row['alternate_contact'].'</span>';
    $nestedData[] = '<a href="../cabzvendor_api/'.$row['picture'].'" data-fancybox="gallery"><img src="../cabzvendor_api/'.$row['picture'].'" width="100px"></a>';
    $nestedData[] = '<a href="../cabzvendor_api/'.$row['adhaar'].'" data-fancybox="gallery"><img src="../cabzvendor_api/'.$row['adhaar'].'" width="100px"></a>';
    $nestedData[] = '<a href="../cabzvendor_api/'.$row['adhaar_back'].'" data-fancybox="gallery"><img src="../cabzvendor_api/'.$row['adhaar_back'].'" width="100px"></a>';
    $nestedData[] = '<a href="../cabzvendor_api/'.$row['dl_img'].'" data-fancybox="gallery"><img src="../cabzvendor_api/'.$row['dl_img'].'" width="100px"></a>';
    $nestedData[] = '<a href="../cabzvendor_api/'.$row['dl_back_img'].'" data-fancybox="gallery"><img src="../cabzvendor_api/'.$row['dl_back_img'].'" width="100px"></a>';

    $nestedData[] = '<button type="button" class="btn btn-success" id="edit_modal'.$serial.'" onclick=show_data('.$row['id'].','.$serial.') value="'.$serial.'" data_id="'.$row['id'].'" data-toggle="modal" data-target="#modal-edit">
    <i class="fa fa-edit btn-success"></i>
    </button>
    <button type="button" name="del" class="btn btn-danger" value="'.$row['id'].'" onclick=del('.$row['id'].')>
    <i class="fa fa-trash"></i></button>';

    $data[] = $nestedData;
    $serial++;
}

// Prepare JSON data
$json_data = array(
    "draw" => intval($_REQUEST['draw']),
    "recordsTotal" => intval($totalData),
    "recordsFiltered" => intval($totalFiltered),
    "data" => $data
);

echo json_encode($json_data);
}

?>