//Display login box if not logged in
$file = 'inc/login-box.htm';
if (!file_exists($file)) {
$content = 'Login box is missing';
} else {
$content = file_get_contents($file);
}
}
/**
*
*/
if ($cmd == '[HOME]') {
$content .= '<div class="container">';
$field = array('name', 'first_name', 'note', 'date_entered');
$sql = "SELECT mmb_jobs_notes_rel.id, mmb_jobs_notes_rel.mmb_job_id, mmb_jobs_notes_rel.mmb_note_id, notes.id, notes.first_name, notes.note, notes.date_entered,mmb_bespoke_job.id, mmb_bespoke_job.name\n\t\t\t\tFROM {$tbn7} JOIN {$tbn6} ON {$tbn7}.mmb_note_id={$tbn6}.id JOIN {$tbn} ON {$tbn7}.mmb_job_id={$tbn}.id ORDER BY {$tbn6}.date_entered DESC LIMIT 100";
$content .= DisplayNotes($sql, $field) . '</div>';
}
if ($cmd == '[NEW_JOB]') {
isset($_POST['id']) ? $id = $_POST['id'] : ($id = $id);
$content .= '<div class="row"><div class="col-s-5 col-md-offset-4">
<a class="btn btn-link" href="?cmd=[NEW_JOB]&sc=job_number&id=' . $id . '" role="button">Job number</a>
<a class="btn btn-link" href="?cmd=[NEW_JOB]&sc=add_pictures&id=' . $id . '" role="button">Add Pictures</a>
<a class="btn btn-link" href="?cmd=[NEW_JOB]&sc=add_details&id=' . $id . '" role="button">Add Details</a>
<a class="btn btn-link" href="?cmd=[NEW_JOB]&sc=add_inv_details&id=' . $id . '" role="button">Add Invoice Details</a>
<a class="btn btn-link" href="?cmd=[DETAIL]&id=' . $id . '" role="button">To Job</a>
</div></div><hr>';
if ($sc == 'job_number') {
//Form to add new job with job number
$content .= '<h1 class="text-center">' . Translate('new_job') . '</h1><hr>
<div class="container"><div class="row"><div class="col-md-4 col-md-offset-4">
<div class="form-group">
function JobNote()
{
$content = '';
$field = array('first_name', 'note', 'date_entered');
$sql = "SELECT * FROM mmb_jobs_notes_rel JOIN notes ON mmb_jobs_notes_rel.mmb_note_id=notes.id WHERE mmb_job_id= '" . $_REQUEST['id'] . "' ORDER BY date_entered";
$content .= DisplayNotes($sql, $field);
$content .= CreateNote() . '<hr>';
return $content;
}
