if ($sc == 'parcel_uk') { $content .= '<a href="?cmd=[INVOICE]&pid=' . $pid . '" class="btn btn-info">INVOICE</a>'; } $content .= '</div>'; } if ($id != '') { $content .= '<div class="col-md-4">' . JobDetails() . Button('remove_from_parcel', 'Remove', 'btn-danger pull-right'); $sql = "SELECT * FROM mmb_bespoke_job WHERE id = '{$id}'"; $content .= EditRecordSticky($sql, array('cost'), 'edit_job', 'id', $id); $content .= '</div>'; } $content .= '</div></div>'; } if ($cmd == '[EDIT_PARCEL]') { $content .= '<div class="container"><div class="pull-right"><a href="?cmd=[PARCEL]&sc=' . $sc . '&pid=' . $pid . '" class="btn btn-info">BACK TO PARCEL</a></div>'; $table = SelectTable(); $sql = "SELECT * from {$table} where id ='{$pid}'"; $field = array('name', 'tracking', 'date_sent', 'date_received'); $content .= EditRecordSticky($sql, $field, 'edit_parcel', 'id', $pid) . '<hr ><div class="pull-right"> ' . DeleteRecordForm($pid, 'delete_parcel') . '</div><div class="clearfix"></div><hr ></div>'; } if ($cmd == '[INVOICE]') { $field = array('name', 'inv_quantity', 'inv_desc', 'inv_metal', 'inv_price'); $sql = "SELECT * from mmb_parcel__bespoke_job_c JOIN mmb_bespoke_job ON mmb_parcel__bespoke_job_c.mmb_parcel090foke_job_idb = mmb_bespoke_job.id WHERE mmb_parcel__bespoke_job_c.mmb_parcele16e_parcel_ida = '{$pid}' order by due_back_date"; $content .= DisplayTable($sql, $field, 'invoice', 0); } if ($cmd == '[SEARCH]') { if ($_REQUEST['query_string'] != '' | $s != '') { if (trim($_REQUEST['query_string']) == '') { $s = $_REQUEST['s']; } else { $s = $_REQUEST['query_string'];
function DeleteParcel() { $table = SelectTable(); DeleteRecord($table, 'id = "' . $_REQUEST['pid'] . '"'); }