POST "; print_r($_POST); echo ""; } $new_group = clean($_POST['new_group' ]); $new_test = clean($_POST['new_test' ]); $new_lab = clean($_POST['new_lab' ]); $new_coa = clean($_POST['new_coa' ]); $new_code = clean($_POST['new_code' ]); $new_method = clean($_POST['new_method']); $new_units = clean($_POST['new_units' ]); $new_format = clean($_POST['new_format']); $new_cost = clean($_POST['new_cost' ]); if(isset($_POST['new_stdev'])) $new_stdev = 1; else $new_stdev = 0; if(isset($_POST['new_round'])) $new_round = clean($_POST['new_round']); else $new_round = 0; if(isset($_POST['new_calc'])) $new_calc = clean($_POST['new_calc']); else $new_calc = 0; $new_labname = clean($_POST['new_labname' ]); if(isset($_POST['new_accredited'])) $new_accredited = 1; else $new_accredited = 0; if(isset($_POST['new_showavg'])) $new_showavg = 1; else $new_showavg = 0; if(isset($_POST['new_order'])) $new_order = clean($_POST['new_order']); else $new_order = 1; if($new_order=="") $new_order = 1; //get all tests that are >= order, and add 1 $sql=" Select dw_test.testID, dw_test.testOrder From dw_test Where dw_test.testGroup = ? And dw_test.testOrder >= ? And dw_test.testSite = ? Order By dw_test.testOrder, dw_test.testText "; if(!$qrytests = mysqli_prepared_query($link, $sql, "iii", array($new_group, $new_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($qrytests as $test_row){ $sql=" UPDATE dw_test SET testOrder = ? WHERE testID = ? "; if(!savesql($link, $sql, "ii", array(($test_row['testOrder']+1), $test_row['testID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } $sql=" INSERT INTO dw_test ( testGroup, testText, testTextLab, testTextCOA, testCode, testMethod, testUnits, testFormat, testStdev, testRound, testCalc, testOrder, testActive, testSite, testModDate, testModUser, testLabName, testAccredited, testShowAvg, testCost) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , 1 , ? , now() , ? , ? , ? , ? , ? ) "; if(!savesql($link, $sql, "issssssiiiiiiisiid", array($new_group, $new_test, $new_lab, $new_coa, $new_code, $new_method, $new_units, $new_format, $new_stdev, $new_round, $new_calc, $new_order, $_SESSION['userSite'], $_SESSION['userID'], $new_labname, $new_accredited, $new_showavg, $new_cost), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } if(isset($_POST['edit_id'] ) && $_POST['edit_id' ]!="" && $_POST['edit_id']!=null){ //edit existing test //get values $edit_id = clean($_POST['edit_id' ]); $edit_group = clean($_POST['edit_group' ]); $edit_test = clean($_POST['edit_test' ]); $edit_lab = clean($_POST['edit_lab' ]); $edit_coa = clean($_POST['edit_coa' ]); $edit_code = clean($_POST['edit_code' ]); $edit_method = clean($_POST['edit_method' ]); $edit_units = clean($_POST['edit_units' ]); $edit_format = clean($_POST['edit_format' ]); if(isset($_POST['edit_stdev'])) $edit_stdev = 1; else $edit_stdev = 0; $edit_round = clean($_POST['edit_round' ]); if(empty($_POST['edit_calc'])) $edit_calc = 0; else $edit_calc = $_POST['edit_calc']; $edit_cost = clean($_POST['edit_cost' ]); $edit_labname = clean($_POST['edit_labname' ]); if(isset($_POST['edit_accredited'])) $edit_accredited = 1; else $edit_accredited = 0; if(isset($_POST['edit_showavg'])) $edit_showavg = 1; else $edit_showavg = 0; /* $edit_order = clean($_POST['edit_order' ]); if($edit_order=="" || $edit_order==null) $edit_order = 0; $edit_order_old = clean($_POST['edit_order_old']); */ $edit_reason = clean($_POST['edit_reason' ]); if(isset($_POST['edit_active'])) $edit_active = 1; else $edit_active = 0; /* if($edit_order_old != $edit_order){ //update all the test orders +1 $sql=" Select dw_test.testID, dw_test.testOrder From dw_test Where dw_test.testGroup = ? And dw_test.testOrder > ? And dw_test.testOrder <= ? And dw_test.testSite = ? Order By dw_test.testOrder, dw_test.testText "; if(!$qrytests = mysqli_prepared_query($link, $sql, "iiii", array($edit_group, $edit_order_old, $edit_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($qrytests as $test_row){ $sql=" UPDATE dw_test SET testOrder = ? WHERE testID = ? "; if(!savesql($link, $sql, "ii", array(($test_row['testOrder']+1), $test_row['testID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } */ $sql = "UPDATE dw_test SET testGroup = ?, testText = ?, testTextLab = ?, testTextCOA = ?, testCode = ?, testMethod = ?, testUnits = ?, testFormat = ?, testStdev = ?, testRound = ?, testCalc = ?, testLabName = ?, testAccredited = ?, testChangeCode = ?, testActive = ?, testShowAvg = ?, testCost = ?, testModDate = now(), testModUser = ? WHERE testID = ?"; if(!savesql($link, $sql, " i s s s s s s i i i i s i s i i d i i", array( $edit_group , $edit_test , $edit_lab , $edit_coa , $edit_code , $edit_method , $edit_units , $edit_format , $edit_stdev , $edit_round , $edit_calc , $edit_labname , $edit_accredited , $edit_reason , $edit_active , $edit_showavg , $edit_cost , $_SESSION['userID'], $edit_id ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } $title = "Tests"; require "inc/head.php"; $menu = "test"; require "inc/menu.php"; if($debug) showdebug(); ?>

Please wait. Loading...
 Please wait while loading...

" aria-controls="collapse"> [".$group_row['groupID']."]"; ?>

" role="tabpanel" aria-labelledby="heading">

New test details

required onkeyup="populatefield('new_test', 'new_lab', 'new_coa');" placeholder="Only users will see this field" > required onkeyup="populatefield('new_lab', 'new_coa');" placeholder="This is what will see" > required placeholder="This name will only appear on reports and COAs" >
? Order By dw_format.formatOrder, dw_format.formatText "; if(!$format_query = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); echo ""; ?>
decimal places
0){ ?>
$

Edit test details

"; foreach($group_query as $grouprow){ echo ""; } echo ""; ?>
required onchange="update('edit_test_reason', 'T1');" placeholder="Only users will see this field" >
required onchange="update('edit_test_reason', 'T1');" placeholder="This is what will see" >
required onchange="update('edit_test_reason', 'T1');" placeholder="This name will only appear on reports and COAs" >
Reports
? Order By dw_format.formatOrder, dw_format.formatText "; if(!$format_query = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); echo ""; ?>
decimal places
$
$('#edit_test_form').modal('show'); update_test_edit(".clean($_GET['t']).", ".($debug ? "1" : "0")."); "; } } require "inc/footer.php"; ?>