getOne($get_previous_job);
$get_next_job = "
SELECT id
FROM jobs
WHERE id > '$job_id' AND status ='$status'
ORDER BY id ASC
LIMIT 1
";
$next_job = $database->getOne($get_next_job);
}
?>
getOne($get_previous_job);
$get_next_job = "
SELECT id
FROM quotes
WHERE id > '$quote_id' AND status = '$status'
ORDER BY id ASC
LIMIT 1
";
$next_job = $database->getOne($get_next_job);
?>
debug = true;
$current_date = date('Y-m-d');
$get_previous_job = "
SELECT id
FROM timesheets
WHERE id < '$id' AND start_time >= '$current_date 00:00:00' AND end_time <= '$current_date 29:59:59'
ORDER BY id DESC
LIMIT 1
";
$prev_id = $database->getOne($get_previous_job);
$get_next_job = "
SELECT id
FROM timesheets
WHERE id > '$id' AND start_time >= '$current_date 00:00:00' AND end_time <= '$current_date 29:59:59'
ORDER BY id ASC
LIMIT 1
";
$next_id = $database->getOne($get_next_job);
?>
getOne($get_previous_job);
$get_stock = "
SELECT id
FROM stocks
WHERE id > '$stock_no' AND status = '$status'
ORDER BY id ASC
LIMIT 1
";
$next_job = $database->getOne($get_stock);
?>
getOne($get_previous_job);
$get_stock = "
SELECT order_material_id
FROM stock_order_materials
WHERE order_material_id > '$matid' AND order_no = '$stock_no'
ORDER BY order_material_id ASC
LIMIT 1
";
$next_job = $database->getOne($get_stock);
?>
getOne($get_previous_job);
$get_stock = "
SELECT id
FROM materials_inventory
WHERE id > '$inv_id' AND status = '$status'
ORDER BY id ASC
LIMIT 1
";
$next_job = $database->getOne($get_stock);
?>
