82
82
$_GET['edit'] = $sample_import_id;
85
if (isset($_POST['submitvp']))
87
$sample_import_id = intval($_POST['sample_import_id']);
89
unset($_POST['submitvp']);
90
unset($_POST['sample_import_id']);
94
$sql = "UPDATE sample_import_var_restrict
96
WHERE sample_import_id = $sample_import_id";
100
foreach($_POST as $p => $val)
102
$sql = "UPDATE sample_import_var_restrict
104
WHERE sample_import_id = $sample_import_id
105
AND `var` LIKE " . $db->qstr($p);
110
$db->CompleteTrans();
112
$_GET['view'] = $sample_import_id;
85
115
if (isset($_GET['rename']))
87
117
xhtml_head(T_("Rename"),true,array("../css/table.css"));
144
if (isset($_GET['view']))
146
xhtml_head(T_("Operator viewing permissions"),true,array("../css/table.css"));
148
$sample_import_id = intval($_GET['view']);
150
$sql = "SELECT sample_id
152
WHERE import_id = $sample_import_id";
154
$sample_id = $db->GetOne($sql);
156
$sql = "SELECT si.description, sv.val, sv.var,
157
CONCAT('<input type=\'checkbox\' ', CASE WHEN (sir.restrict IS NULL || sir.restrict = 0) THEN 'checked=\"checked\"' ELSE '' END ,' name=\'',sv.var,'\' value=\'11\'/>') as box,
158
sir.restrict IS NULL as existss
159
FROM sample_import as si
160
JOIN `sample` as s ON (s.import_id = si.sample_import_id AND s.sample_id = $sample_id)
161
JOIN sample_var as sv ON (sv.sample_id = s.sample_id)
162
LEFT JOIN sample_import_var_restrict as sir ON (sir.sample_import_id = si.sample_import_id AND sir.var = sv.var)
163
WHERE si.sample_import_id = $sample_import_id";
165
$rs = $db->GetAll($sql);
167
//if not in restrict table, then insert
170
if ($r['existss'] == 1)
172
$sql = "INSERT INTO sample_import_var_restrict (sample_import_id,var,`restrict`)
173
VALUES ($sample_import_id,'{$r['var']}',0)";
179
print "<h2>" . T_("Operator viewing permissions") . ": " . $rs[0]['description'] . "</h2>";
180
echo "<p><a href='?'>" . T_("Go back") . "</a></p>";
182
print "<p>" . T_("Select which fields from this sample should be able to be viewed by operators") . "</p>";
185
<form action="?" method="post">
187
xhtml_table($rs,array("var","val","box"),array(T_("Field"),T_("Example data"),T_("Allow operator to see?")));
189
<div><input type='hidden' name='sample_import_id' value='<?php echo $sample_import_id;?>'/></div>
190
<div><input type="submit" name="submitvp" value="<?php echo T_("Save changes");?>"/></div>
113
200
if (isset($_GET['edit']))
115
202
xhtml_head(T_("Deidentify"),true,array("../css/table.css"));
180
267
as enabledisable,
181
268
CONCAT('<a href=\'?edit=',sample_import_id,'\'>" . T_("Deidentify") . "</a>') as did,
269
CONCAT('<a href=\'?view=',sample_import_id,'\'>" . T_("Operator viewing permissions") . "</a>') as vp,
182
270
CONCAT('<a href=\'?rename=',sample_import_id,'\'>" . T_("Rename") . "</a>') as rname,
184
272
FROM sample_import";
188
276
xhtml_head(T_("Sample list"),true,array("../css/table.css"));
190
$columns = array("description","enabledisable","did","rname");
191
$titles = array(T_("Sample"),T_("Enable/Disable"),T_("Deidentify"),T_("Rename"));
278
$columns = array("description","enabledisable","did","vp","rname");
279
$titles = array(T_("Sample"),T_("Enable/Disable"),T_("Deidentify"),T_("Operator viewing permissions"),T_("Rename"));
193
281
xhtml_table($rs,$columns,$titles);