//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; }