notontimepackage.php

<?php
include "index.php";
// fetch records
$sql = "SELECT `package`.`package_id` , `package`.`package_type` ,`customer`.`name` , `time`.`schedule_time` , `time`.`end_time` , `transportation`.`type_name`
FROM `package` 
LEFT JOIN `payment` ON `package`.`package_id`=`payment`.`package_id`  
LEFT JOIN `time` ON `time`.`package_id`=`package`.`package_id` 
LEFT JOIN `customer` ON `payment`.`customer_id`=`customer`.`customer_id` 
LEFT JOIN `transportation` ON `transportation`.`transportation_id`=`package`.`transportation_id`
WHERE `time`.`end_time` > `time`.`schedule_time`";
$result = mysqli_query($con, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    $array[] = $row;
}

$dataset = array(
    "echo" => 1,
    "totalrecords" => count($array),
    "totaldisplayrecords" => count($array),
    "data" => $array
);
echo json_encode($dataset);