Create New Job
if(!$_POST['submitme']) { ?>
} else {
$registration = $_POST['registration'];
$make = $_POST['make'];
$model = $_POST['model'];
$type = $_POST['type'];
$colour = $_POST['colour'];
$load = $_POST['load'];
$customer = $_POST['customer'];
$orderno = $_POST['orderno'];
$location = $_POST['location'];
$fault = $_POST['fault'];
$workdone = $_POST['workdone'];
$status = $_POST['status'];
$created = $_POST['created'];
$onsite = $_POST['onsite'];
$offsite = $_POST['offsite'];
$errorcode = $_POST['errorcode'];
$joberror = "";
if($_SESSION['access_level'] == "2") {
$agent = $_SESSION['loggedin_as'];
}
if(!$registration){
$joberror .= "No Registration Number was entered
";
}
if(!$joberror) {
include "inc/dbc.inc.php";
$sql = "INSERT INTO jobs (`registration`, `make`,`model`,`type`,`colour`,`load`, `customer`, `orderno`, `location`, `fault`, `workdone`, `status`, `created`, `onsite`, `offsite`, `errorcode`, `agent`)
VALUES
(\"$registration\", \"$make\", \"$model\", \"$type\", \"$colour\", \"$load\", \"$customer\", \"$orderno\", \"$location\", \"$fault\", \"$workdone\", \"$status\", NOW(), \"$onsite\", \"$offsite\", \"$errorcode\", \"$agent\")";
$query = mysql_query($sql) or die ('MYSQL error: ' . mysql_error());
echo "
The job has been logged - Redirecting to summary page.
";
} else {
echo "
Sorry but the job sheet contained some errors, please press back and try again. The error is shown below
$joberror
";
}
}
?>
include "inc/footer.inc.php";
?>