";
}
}
//show value
switch ($fieldArray['fieldType']) {
case $SN_FIELD_NUMBER:
switch ($fieldArray['fieldDP']) {
case 1:
$step = "0.1";
break;
case 2:
$step = "0.01";
break;
case 3:
$step = "0.001";
break;
case 4:
$step = "0.0001";
break;
default:
$step = "1";
}
echo "
";
break;
case $SN_FIELD_TIME:
echo "
";
//to change to html5 compliant, change this from text to time (doesnt work with Chrome)
break;
case $SN_FIELD_CALC:
if ($debug) {
$showfield = "number";
} else {
$showfield = "hidden";
}
$sql = '# get calculation
SELECT
dw_sn_field1.fieldTitle AS fieldTitle1,
dw_sn_field.fieldOperator,
dw_sn_field2.fieldTitle AS fieldTitle2
FROM
dw_sn_field LEFT JOIN
dw_sn_field dw_sn_field1 ON dw_sn_field1.fieldID = dw_sn_field.fieldSum1 LEFT JOIN
dw_sn_field dw_sn_field2 ON dw_sn_field.fieldSum2 = dw_sn_field2.fieldID
WHERE
dw_sn_field.fieldID = ?';
if (!$calcquery = mysqli_prepared_query($link, $sql, "i", array($fieldArray['fieldID']), __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
$value = number_format(getDataRecursive($fieldArray['fieldID'], $c), $fieldArray['fieldDP']);
echo "
";
break;
case $SN_FIELD_LIST:
echo "
";
$sql = "
Select
dw_dtarea.dtAreaID,
dw_dtarea.dtAreaText
From
dw_dtarea
Where
dtAreaBC = ?
Order By
dw_dtarea.dtAreaOrder,
dw_dtarea.dtAreaText";
if ($fieldArray['fieldList'] == 4) {
if (!$dtquery = mysqli_prepared_query($link, $sql, "i", array(1), __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
} else {
if (!$dtquery = mysqli_prepared_query($link, $sql, "i", array(0), __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
}
if ($fieldArray['fieldReadOnly'] == 1) {
$readonly = " disabled ";
} else {
$readonly = "";
}
echo "
";
if ($fieldArray['fieldList'] == 2 || $fieldArray['fieldList'] == 4) {
time_input($fieldArray['fieldID']);
}
echo "
";
$listdata = '';
$sql = '# Get items for 7 (list)
Select
dw_dtarea.dtAreaText,
dw_sn_value.valueValue
From
dw_sn_value Left Join
dw_dtarea
On dw_sn_value.valueReason = dw_dtarea.dtAreaID
Where
dw_sn_value.valueField = ? And
dw_sn_value.valueDay = ?
Order By
dw_dtarea.dtAreaOrder,
dw_dtarea.dtAreaText';
if (!$listquery = mysqli_prepared_query($link, $sql, "is", array($fieldArray['fieldID'], $c), __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
foreach ($listquery as $listarray) {
$listdata .= "
" . $listarray['dtAreaText'] . " - " . $listarray['valueValue'] . ""; //not sure if nobr still works??
}
echo "
";
break;
case $SN_FIELD_SPACE:
echo " ";
break;
case $SN_FIELD_SLIDER:
echo "
" . $fieldArray['fieldMin'] . "
" . $fieldArray['fieldMax'] . "
";
break;
case $SN_FIELD_YESNO:
?>
= ?
Order By
userFirst,
userLast';
if (!$qry = mysqli_prepared_query($link, $sql, 'i', array(0), __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
echo "
";
break;
case $SN_FIELD_API:
echo '
';
$sql = "# get data for Llumin
SELECT
fieldTitle AS `title`,
v.valueValue AS `value`
FROM
dw_sn_field f LEFT JOIN
dw_sn_value v ON f.fieldID = v.valueField AND v.valueDay = ?
WHERE
f.fieldActive = 1
AND f.fieldType <> $SN_FIELD_SPACE
AND f.fieldPage = ?
AND EXISTS (
SELECT 1
FROM dw_sn_value craft_value
INNER JOIN dw_sn_field craft_field ON craft_value.valueField = craft_field.fieldID
WHERE craft_field.fieldTitle = 'Craft'
AND craft_value.valueValue = ?
AND craft_value.valueDay = v.valueDay
)
ORDER BY
f.fieldOrder,
v.valueID";
$params = [
$c,
$pages,
$pageText
];
if (!$field_query = mysqli_prepared_query($link, $sql, 'sis', $params, __FILE__, __LINE__)) {
reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
}
// Collect data by field title and row index
$data = [];
foreach ($field_query as $field) {
$data[$field['title']][] = $field['value'];
}
// Build column titles dynamically from the keys of $data
$column_titles = array_keys($data);
// Remove "Craft" from column titles
if (($key = array_search('Craft', $column_titles)) !== false) {
unset($column_titles[$key]);
}
// Find which row indices are allowed (where Craft == $pageText)
$allowed = [];
if (isset($data['Craft'])) {
foreach ($data['Craft'] as $key => $value) {
if ($value == $pageText) {
$allowed[] = $key;
}
}
}
// Build the HTML table
echo '';
foreach ($column_titles as $title) {
echo '| ' . htmlspecialchars($title) . ' | ';
}
echo '
';
// For each allowed row index, print a table row
foreach ($allowed as $row_index) {
echo '';
foreach ($column_titles as $title) {
echo '| ';
$value = isset($data[$title][$row_index]) ? htmlspecialchars($data[$title][$row_index]) : '';
if ($title == 'Work order number') {
echo '' . $value . '';
} else if (substr($value, 0, 4) == 'http') {
echo '' . $value . '';
} else {
// For other fields, just print the value
echo $value;
}
echo ' | ';
}
echo '
';
}
echo '
';
break;
default:
echo "
";
}
if ($debug) {
$showfield = "text";
} else {
$showfield = "hidden";
}
//JS for time colons
if ($fieldArray['fieldType'] == $SN_FIELD_TIME) {
time_input($fieldArray['fieldID']);
}
//extra
if ($fieldArray['fieldExtra'] != "" && $fieldArray['fieldExtra'] != null && $fieldArray['fieldType'] != $SN_FIELD_YESNO) {
echo "
" . $fieldArray['fieldExtra'] . "
";
}
//end divs col-sm-3 form-group
if ($fieldArray['fieldType'] != $SN_FIELD_CALC || $fieldArray['fieldShow'] == 1) {
echo "