| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Scheduler/admin/siteneed/ |
Upload File : |
<?
// admin/siteneed/siteneed_ListForm.phpinc
// Display the siteneed List form.
t_Begin(); // Begin TRACKing included file.
if ( !isset($casePrefix) ) { $casePrefix = ''; }
// Get siteneedstatus.
$query = "
SELECT siteneedstatusId
, siteneedstatusName
FROM `siteneedstatus`
WHERE siteneedstatusInactive = 0
ORDER BY siteneedstatusName
";
d_Var('siteneedstatusResult',$query,'q');
$siteneedstatusResult = query_do($query);
$siteneedstatusCount = $GLOBALS['_QUERY']['count'];
d_Var('$siteneedstatusResult',$siteneedstatusResult);
#if ( $siteneedstatusCount != 1 ) programmingError('The siteneedstatusId ('.$siteneedstatusId.') did not return one record. '.$siteneedstatusCount.' returned.');
#if ( !$siteneedstatusCount ) programmingError('The siteneedstatusId ('.$siteneedstatusId.') did not return any records.');
$siteneedstatus = array();
if ( $siteneedstatusCount ) {
query_seek($siteneedstatusResult, 0);
while ($siteneedstatusInfo = query_row($siteneedstatusResult)) {
$siteneedstatus[$siteneedstatusInfo['siteneedstatusId']] = $siteneedstatusInfo['siteneedstatusName'];
}
}
#d_Var('siteneedstatusInfo',$query,'q');
#$siteneedstatusInfo = query_info($query);
#d_Var('$siteneedstatusInfo',$siteneedstatusInfo);
?>
<div id="div_siteneedListForm">
<table class="centered"><tr><td>
<fieldset><legend>Site needs</legend>
<form name="form_siteneedListForm" action="<?=php_self()?>" method="post" enctype="multipart/form-data">
<input type="hidden" name="form" value="form_siteneedListForm">
<input type="hidden" name="uuid" value="<?=uuid()?>">
<table>
<tr>
<? if ( hasPermission('Admin') ) { ?>
<td><input type="button" value="Add" onclick="formSubmit(this,'<?=$casePrefix?>Add');" onmouseover="ttShow('Add a new siteneed');" onmouseout="ttHide();"></td>
<? } ?>
<th class="left">Name</th>
<th class="left">Problem or Need</th>
<th>Status</th>
<th><? echo ttMake('Date', 'The date the need was added or last modified.','info'); ?></th>
</tr>
<?
$query = "
SELECT *
FROM `siteneed`
ORDER BY siteneedDone, siteneedActive DESC, ModifiedOn DESC, AddedOn, siteneedName
";
#d_Var('siteneedResult',$query,'q');
$siteneedResult = query_do($query);
#d_Var('$siteneedResult',$siteneedResult,'');
$siteneedCount = $GLOBALS['_QUERY']['count'];
#d_Var('$siteneedCount',$siteneedCount,'');
if ( $siteneedCount ) {
$siteneedAddedOnlyDisplay = false;
query_seek($siteneedResult, 0);
while ($siteneedInfo = query_row($siteneedResult)) { // Loop thru $siteneedResult.
if ($siteneedInfo['siteneedActive']) {
$trClass = 'Active';
} elseif ($siteneedInfo['siteneedDone']) {
$trClass = 'Done';
} else {
$trClass = $siteneedstatus[$siteneedInfo['siteneedstatusId']];
}
$siteneedStatus = $siteneedstatus[$siteneedInfo['siteneedstatusId']];
if ($siteneedInfo['siteneedDone']) {
$siteneedStatus .= '<br>Done';
}
if ($siteneedInfo['ModifiedOn']) {
$siteNeedDate = $siteneedInfo['ModifiedOn'];
$siteneedAddedOnly = false;
} else {
$siteNeedDate = $siteneedInfo['AddedOn'];
$siteneedAddedOnly = true;
}
$siteNeedDate = valid_date($siteNeedDate,'M jS, Y');
if (!$siteneedAddedOnlyDisplay && $siteneedAddedOnly) { // Should the unmodified site needs row be shown?
$siteneedAddedOnlyDisplay = true;
?>
<tr>
<?
if ( hasPermission('Admin') ) {
$colcount = 5;
} else {
$colcount = 4;
}
?>
<td colspan="<?=$colcount?>" class="info center">Unmodified site needs</td>
</tr>
<?
} // Should the unmodified site needs row be shown?
?>
<tr class="siteneed-<?=$trClass?>">
<? if ( hasPermission('Admin') ) { ?>
<td><input type="button" value="Edit" onclick="formSubmit(this,{'task':'<?=$casePrefix?>Edit','siteneedId':<?=$siteneedInfo['siteneedId']?>});" onmouseover="ttShow('Edit');" onmouseout="ttHide();"></td>
<? } ?>
<td class="nowrap"><?=$siteneedInfo['siteneedName']?></td>
<td>
<?=$siteneedInfo['siteneedText']?>
<? if ($siteneedInfo['siteneedFix']) { echo "\n<br><b>Fix:</b>\n",$siteneedInfo['siteneedFix']; } ?>
</td>
<td><?=$siteneedStatus?></td>
<td class="nowrap"><?=$siteNeedDate?></td>
</tr>
<?
} // Loop thru $siteneedResult.
}
?>
</table>
</form><!-- form_siteneedListForm -->
</fieldset>
</td></tr></table>
</div><!-- div_siteneedListForm -->
<?
t_End(); // End TRACKing included file.
?>