function getPsiData(&$psi3hr, &$psi24hr, &$comments) { $currPSI = 'XXX'; $comments = ''; $lastUpdated = ''; $datasetName = 'psi_update'; $keyref = '781CF461BB6606ADC4A6A6217F5F2AD6C5A6581D44B62228'; $url = 'http://api.nea.gov.sg/api/WebAPI/?dataset=' . $datasetName . '&keyref=' . $keyref; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_FAILONERROR, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_TIMEOUT, 15); $response = curl_exec($ch); if (curl_errno($ch)) { echo 'Curl error: ' . curl_error($ch); $comments = 'Error! Unable to connect to NEA server..'; } else { $xmlResponse = simplexml_load_string($response); $psi3hr = array("north" => (string) $xmlResponse->item->region[0]->record->reading[1]['value'], "main" => (string) $xmlResponse->item->region[1]->record->reading[1]['value'], "central" => (string) $xmlResponse->item->region[2]->record->reading[1]['value'], "east" => (string) $xmlResponse->item->region[3]->record->reading[1]['value'], "west" => (string) $xmlResponse->item->region[4]->record->reading[1]['value'], "south" => (string) $xmlResponse->item->region[5]->record->reading[1]['value'], "raw_timestamp" => (string) $xmlResponse->item->region[1]->record['timestamp'], "timestamp" => getFormattedDate($xmlResponse->item->region[1]->record['timestamp'])); $psi24hr = array("north" => (string) $xmlResponse->item->region[0]->record->reading[0]['value'], "main" => (string) $xmlResponse->item->region[1]->record->reading[0]['value'], "central" => (string) $xmlResponse->item->region[2]->record->reading[0]['value'], "east" => (string) $xmlResponse->item->region[3]->record->reading[0]['value'], "west" => (string) $xmlResponse->item->region[4]->record->reading[0]['value'], "south" => (string) $xmlResponse->item->region[5]->record->reading[0]['value'], "raw_timestamp" => (string) $xmlResponse->item->region[1]->record['timestamp'], "timestamp" => getFormattedDate($xmlResponse->item->region[1]->record['timestamp'])); } curl_close($ch); }
function getMiniCalEvents($mini_cal_auth) { global $template, $db, $lang; // initialise some sql bits if ($mini_cal_auth['view']) { $days_ahead_sql = MINI_CAL_DAYS_AHEAD > 0 ? " AND (c.stamp <= DATE_ADD(CURDATE(), INTERVAL " . MINI_CAL_DAYS_AHEAD . " DAY)) " : ''; // get the events $sql = "SELECT\n\t\t\t\t\tc.id, c.stamp, c.eventspan, c.subject,\n\t\t\t\t\tMONTH(c.stamp) as cal_month,\n\t\t\t\t\tDAYOFWEEK(DATE_SUB(c.stamp, INTERVAL " . MINI_CAL_FDOW . " DAY)) as cal_weekday,\n\t\t\t\t\tDAYOFMONTH(c.stamp) as cal_monthday,\n\t\t\t\t\tYEAR(c.stamp) as cal_year,\n\t\t\t\t\tHOUR(c.stamp) as cal_hour,\n\t\t\t\t\tMINUTE(c.stamp) as cal_min,\n\t\t\t\t\tSECOND(c.stamp) as cal_sec,\n\n\t\t\t\t\tMONTH(c.eventspan) as cal_month_end,\n\t\t\t\t\tDAYOFWEEK(DATE_SUB(c.eventspan, INTERVAL " . MINI_CAL_FDOW . " DAY)) as cal_weekday_end,\n\t\t\t\t\tDAYOFMONTH(c.eventspan) as cal_monthday_end,\n\t\t\t\t\tYEAR(c.eventspan) as cal_year_end\n\t\t\t\tFROM\n\t\t\t\t\t" . CAL_TABLE . " as c\n\t\t\t\tWHERE ((c.stamp >= CURDATE()) OR (CURDATE() <= c.eventspan))\n\t\t\t\t\t{$days_ahead_sql}\n\t\t\t\t\t{$mini_cal_auth_sql}\n\t\t\t\tORDER BY\n\t\t\t\t\tc.stamp ASC\n\t\t\t\tLIMIT\n\t\t\t\t\t0," . MINI_CAL_LIMIT; // did we get a result? // if not then the user does not have MyCalendar installed // so just die quielty don't bother to output an error message $db->sql_return_on_error(true); $result = $db->sql_query($sql); $db->sql_return_on_error(false); if ($result) { // ok we've got MyCalendar $template->assign_block_vars('switch_mini_cal_events', array()); if ($db->sql_numrows($result) > 0) { // we've even got some events // initialise out date formatting patterns $cal_date_pattern = unserialize(MINI_CAL_DATE_PATTERNS); // output our events in the given date format for the current language while ($row = $db->sql_fetchrow($result)) { $cal_date = getFormattedDate($row['cal_weekday'], $row['cal_month'], $row['cal_monthday'], $row['cal_year'], $row['cal_hour'], $row['cal_min'], $row['cal_sec'], $lang['Mini_Cal_date_format']); if ($row['eventspan'] > $row['stamp']) { $cal_date .= ' - ' . getFormattedDate($row['cal_weekday_end'], $row['cal_month_end'], $row['cal_monthday_end'], $row['cal_year_end'], '', '', '', $lang['Mini_Cal_date_format']); } $template->assign_block_vars('mini_cal_events', array('MINI_CAL_EVENT_DATE' => $cal_date, 'S_MINI_CAL_EVENT' => $row['subject'], 'U_MINI_CAL_EVENT' => append_sid(IP_ROOT_PATH . 'calendar.' . PHP_EXT . '?id=' . $row['id'] . '&mode=display'))); } } else { // no events :( $template->assign_block_vars('mini_cal_no_events', array()); } $db->sql_freeresult($result); } } }
<? //register a globals variable for security $GLOBALS['vlDC']=true; include "conf.php"; ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" cellspacing="0" cellpadding="0" class="trailanalytics"> <tr> <td class="tab_active">Changes by <?php echo $createdby; ?> in <?php echo getFormattedDate($theDate); ?> </td> </tr> </table></td> </tr> <tr> <td style="border:1px solid #CCCCFF; padding:20px"> <table width="100%" border="0" class="trailanalytics"> <tr> <td> <div style="height: 270px; overflow: auto; padding:3px"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="vl_tdsub" width="90%"><strong>Post-Warning Submission Details</strong></td> <td class="vl_tdsub" width="10%"><strong>Time</strong></td> </tr> <?
while($sq=mysqlfetcharray($squery)) { if($scount%2) { $scolor="#FFFFFF"; } else { $scolor="#F4F4F4"; } ?> <tr bgcolor="<?php echo $scolor; ?> "> <td><a href="../admin/?act=statisticsremovals&nav=statistics&soption=removalsByUser&theDate=<?php echo $sq["datecreated"]; ?> "><?php echo getFormattedDate($sq["datecreated"]); ?> </a></td> <td><?php echo number_format((double) $sq["stat"]); ?> </td> </tr> <? $stotal+=$sq["stat"]; $scount++; } } else { ?> <tr> <td colspan="2">No statistics available for this query.</td>
function getMiniCalEvents($mini_cal_auth) { global $db, $template, $lang; // initialise some sql bits $mini_cal_auth_sql = $mini_cal_auth['view'] != '' ? ' AND t.forum_id in (' . $mini_cal_auth['view'] . ') ' : ''; $days_ahead_sql = MINI_CAL_DAYS_AHEAD > 0 ? " AND (c.cal_date <= DATE_ADD(CURDATE(), INTERVAL " . MINI_CAL_DAYS_AHEAD . " DAY)) " : ''; // get the events $sql = "SELECT\n\t\t\t\tc.topic_id, c.cal_date, c.forum_id,\n\t\t\t\tMONTH(c.cal_date) as cal_month,\n\t\t\t\tDAYOFWEEK(DATE_SUB(c.cal_date, INTERVAL " . MINI_CAL_FDOW . " DAY)) as cal_weekday,\n\t\t\t\tDAYOFMONTH(c.cal_date) as cal_monthday,\n\t\t\t\tYEAR(c.cal_date) as cal_year,\n\t\t\t\tHOUR(c.cal_date) as cal_hour,\n\t\t\t\tMINUTE(c.cal_date) as cal_min,\n\t\t\t\tSECOND(c.cal_date) as cal_sec,\n\t\t\t\tt.topic_title\n\t\t\tFROM\n\t\t\t\t" . MYCALENDAR_TABLE . " as c,\n\t\t\t\t" . TOPICS_TABLE . " as t\n\t\t\tWHERE\n\t\t\t\tc.topic_id = t.topic_id\n\t\t\t\tAND (c.cal_date >= CURDATE())\n\t\t\t\t{$days_ahead_sql}\n\t\t\t\t{$mini_cal_auth_sql}\n\t\t\tORDER BY\n\t\t\t\tc.cal_date ASC\n\t\t\tLIMIT\n\t\t\t\t0," . MINI_CAL_LIMIT; // did we get a result? // if not then the user does not have MyCalendar installed // so just die quielty don't bother to output an error message $db->sql_return_on_error(true); $result = $db->sql_query($sql); $db->sql_return_on_error(false); if ($result) { // ok we've got MyCalendar $template->assign_block_vars('switch_mini_cal_events', array()); if ($db->sql_numrows($result) > 0) { // we've even got some events // initialise out date formatting patterns $cal_date_pattern = unserialize(MINI_CAL_DATE_PATTERNS); // output our events in the given date format for the current language while ($row = $db->sql_fetchrow($result)) { $cal_date = getFormattedDate($row['cal_weekday'], $row['cal_month'], $row['cal_monthday'], $row['cal_year'], $row['cal_hour'], $row['cal_min'], $row['cal_sec'], $lang['Mini_Cal_date_format']); $template->assign_block_vars('mini_cal_events', array('MINI_CAL_EVENT_DATE' => $cal_date, 'S_MINI_CAL_EVENT' => $row['topic_title'], 'U_MINI_CAL_EVENT' => append_sid(IP_ROOT_PATH . CMS_PAGE_VIEWTOPIC . "?" . POST_TOPIC_URL . '=' . $row['topic_id']))); } } else { // no events :( $template->assign_block_vars('mini_cal_no_events', array()); } $db->sql_freeresult($result); } }
echo $user->name; ?> 's Forest</div> <br> <center> <img class="empty-forest" src="img/empty_forest.png"/> </center> <?php $gifts = getGifts($user); while ($gift = array_shift($gifts)) { ?> <img data-tooltip aria-haspopup="true" title="Gift for <strong><?php echo $gift->friendName; ?> </strong> <br/> given on <?php echo getFormattedDate($gift->giftDate); ?> <br> (<?php echo $gift->plantName; ?> , <?php echo $gift->points; ?> Points)" class="tree has-tip radius" src="img/tree.png" width="50px" style="display:none;"> <?php } ?> <div class="name floater">Plants gifted</div><div class="name" style="float:right"><?php echo sizeof(getGifts($user)); ?> </div>
} ?> <table width="100%" border="0" class="vl"> <tr> <td><span style='font-weight: bold'>Emails sent by the site</span></td> </tr> <tr> <td><img src="images/horizontal_400.gif" width="400" height="1" vspace="3"></td> </tr> <? switch($soption) { case details: ?> <tr> <td><span style='font-weight: bold'>Emails for the date: <font color="#FF0000"><?php echo getFormattedDate($xdetails); ?> </font></span></td> </tr> <tr> <td><table width="95%" cellpadding="0" cellspacing="0" class="vl"> <? $squery=0; $squery=mysqlquery("select * from vl_daemon_email where date(created)='$xdetails' order by created desc"); if(mysqlnumrows($squery)) { $sq=array(); while($sq=mysqlfetcharray($squery)) { ?> <tr> <td> </td> </tr>
$count+=1; $status=0; $status=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]'","outcome"); if($count<$num) { echo "<tr> <td class=\"vl_tdstandard\">$q[formNumber]</td> <td class=\"vl_tdstandard\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td> <td class=\"vl_tdstandard\">".($status?$status:"Pending")."</td> <td class=\"vl_tdstandard\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td> </tr>"; } else { echo "<tr> <td class=\"vl_tdnoborder\">$q[formNumber]</td> <td class=\"vl_tdnoborder\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td> <td class=\"vl_tdnoborder\">".($status?$status:"Pending")."</td> <td class=\"vl_tdnoborder\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td> </tr>"; } } ?> </table> </div> </fieldset> </td> </tr> </table> </div> </td> </tr> <? } else { ?> <tr>
case 'm': $new_title = $titles['m'] . ' ' . $titles['y']; break; case 'd': $new_title = $titles['d'] . ' ' . $titles['m'] . ' ' . $titles['y']; break; default: $new_title = ''; break; } $new_title = ucfirst($new_title); $newdoc['pagetitle'] = $new_title; $newdoc['longtitle'] = $new_title; $newdoc['menutitle'] = $new_title; $newdoc['alias'] = $aliases[$f]; $newdoc['menuindex'] = getFormattedDate($dt, $f, 'menuindex'); // Insert the new page $new_page = $modx->db->insert($newdoc, $modx->getFullTableName('site_content')); // If it's inserted correctly, remember the new page as the last parent $src_id = $last_parent; $last_parent = $new_page !== false ? $new_page : $last_parent; // Also duplicate any manager permissions $doc_group_table = $modx->getFullTableName('document_groups'); $permissions = $modx->db->select("*", $doc_group_table, "document = {$src_id}"); if ($new_page !== false && $modx->db->getRecordCount($permissions) >= 1) { while ($row = $modx->db->getRow($permissions)) { $dup_perms = array('document' => $new_page, 'document_group' => $row['document_group']); $modx->db->insert($dup_perms, $doc_group_table); } } }
function getMiniCalEvents($mini_cal_auth) { global $template, $db, $phpEx, $lang, $mini_cal_today, $mini_cal_this_month, $mini_cal_this_year, $mini_cal_this_day; // start and end date $start_date = mktime(0,0,0, intval(substr($mini_cal_today, 4, 2)), $mini_cal_this_day, $mini_cal_this_year); $w_month = $mini_cal_this_month; $days_ahead_sql = ''; if (MINI_CAL_DAYS_AHEAD > 0) { $w_year = $mini_cal_this_year; if ($w_month > 12) { $w_month = 01; $w_year++; } $end_date = mktime(0,0,0, $w_month, $mini_cal_this_day + MINI_CAL_DAYS_AHEAD, $w_year); $days_ahead_sql = " AND topic_calendar_time < $end_date "; } // initialise some sql bits $mini_cal_auth_sql = ($mini_cal_auth['view']) ? ' AND t.forum_id in (' . $mini_cal_auth['view'] . ') ' : ''; // get events $sql = "SELECT t.topic_id, t.topic_calendar_time, t.topic_title, t.forum_id, t.topic_calendar_duration FROM " . TOPICS_TABLE . " t WHERE topic_calendar_time >= $start_date $days_ahead_sql AND topic_calendar_time IS NOT NULL AND topic_calendar_time <> 0 $mini_cal_auth_sql ORDER BY t.topic_calendar_time ASC LIMIT 0," . MINI_CAL_LIMIT; // did we get a result? if( $result = $db->sql_query($sql) ) { $template->assign_block_vars('switch_mini_cal_events', array()); if ( $db->sql_numrows($result) > 0 ) { // we've got some events // now let's output our events in the given date format for the current language while ($row = $db->sql_fetchrow($result)) { $cal_time = $row['topic_calendar_time']; $day_span = (date("Ymd", $cal_time) < date("Ymd", $cal_time+$row['topic_calendar_duration'])); $include_time = date("His", $cal_time) > 0; $cal_date = getFormattedDate( date('w', $cal_time), date('n', $cal_time), date('d', $cal_time), date('Y', $cal_time), date('H', $cal_time), date('i', $cal_time), date('s', $cal_time), $lang['Mini_Cal_date_format'].((!$day_span && $include_time)?' '.$lang['Mini_Cal_date_format_Time']:'') ); if ($day_span || $row['topic_calendar_duration'] > 0) { $cal_time = $cal_time + $row['topic_calendar_duration']; $cal_date .= ' - ' . getFormattedDate( date('w', $cal_time), date('n', $cal_time), date('d', $cal_time), date('Y', $cal_time), date('H', $cal_time), date('i', $cal_time), date('s', $cal_time), ((!$day_span)?$lang['Mini_Cal_date_format_Time']:$lang['Mini_Cal_date_format']) ); } $template->assign_block_vars('mini_cal_events', array( 'MINI_CAL_EVENT_DATE' => $cal_date, 'S_MINI_CAL_EVENT' => $row['topic_title'], 'U_MINI_CAL_EVENT' => append_sid( $phpbb_root_path . "viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $row['topic_id'] ) ) ); } } else { // no events :( $template->assign_block_vars('mini_cal_no_events', array()); } $db->sql_freeresult($result); } }
//to be activated: ensure lrCategory, lrEnvelopeNumber and lrNumericID are supplied if(!$lrCategory && (!$lrEnvelopeNumber || $lrEnvelopeNumber==$default_envelopeNumber) && !$lrNumericID) { $error.="<br /><strong>".($lrCategory=="V"?"Location":"Rejection")." ID is Missing</strong><br />Kindly provide a ".($lrCategory=="V"?"Location or Rejection":"Rejection or Location")." ID<br />"; } //to be edited: ensure envelope number is valid if($lrCategory && $lrEnvelopeNumber && $lrEnvelopeNumber!="Envelope #" && $lrNumericID) { if(!preg_match("/^[0-9]{4}[\-]{1}[0-9]{1,5}$/",$lrEnvelopeNumber)) { $error.="<br /><strong>Incorrect Envelope Number '$lrEnvelopeNumber'.</strong><br />Correct Envelope Number Format is ".getFormattedDateYearShort($datetime).getFormattedDateMonth($datetime)."-00001.<br /> Kindly resubmit with a Valid Envelope Number.<br />"; } } //ensure form number is unique if(getDetailedTableInfo2("vl_samples","formNumber='$formNumber' limit 1","id")) { $error.="<br /><strong>Duplicate Form Number '$formNumber'.</strong><br />The Form Number <strong>$formNumber</strong> was entered on <strong>".getFormattedDate(getDetailedTableInfo2("vl_samples","formNumber='$formNumber' limit 1","created"))."</strong> by <strong>".getDetailedTableInfo2("vl_samples","formNumber='$formNumber' limit 1","createdby")."</strong> <a href=\"#\" onclick=\"iDisplayMessage('/verify/preview/".getDetailedTableInfo2("vl_samples","formNumber='$formNumber' limit 1","id")."/1/noedit/')\">Click here to see the entry</a>.<br /> Kindly input this record with an alternative Form Number.<br />"; } //ensure form number is numeric if(!is_numeric($formNumber)) { $error.="<br /><strong>Form Number '$formNumber' is Not Numeric.</strong><br />The Form Number should be Numeric i.e it should not contain alphanumeric characters e.g A-Z.<br />"; } //ensure form number is valid if(!getDetailedTableInfo2("vl_forms_clinicalrequest","formNumber='$formNumber' or formNumber='".($formNumber/1)."' limit 1","id")) { $error.="<br /><strong>Invalid Form Number '$formNumber'.</strong><br />The Form Number <strong>$formNumber</strong> does not exist in the list of valid Form Numbers.<br /> Kindly input this record with a valid Form Number.<br />"; } //ensure facility is valid if(!getDetailedTableInfo2("vl_facilities","id='$facilityID'","id")) { $error.="<br /><strong>Incorrect Facility '$facilityID'.</strong><br />Kindly select an existing Facility from the list or Request an Administrator to first add this Facility '$facilityID' to the System's Database before Proceeding.<br />";
//24hr cache $template = 'statistics_monthlyleader.tpl'; $cacheid = isset($_GET['month']); if (!$smarty->is_cached($template, $cacheid)) { require_once 'geograph/gridimage.class.php'; require_once 'geograph/gridsquare.class.php'; require_once 'geograph/imagelist.class.php'; $db = NewADOConnection($GLOBALS['DSN']); if (!$db) { die('Database connection failed'); } $length = isset($_GET['month']) ? 10 : 7; $topusers = $db->GetAll("SELECT gridimage_id,SUBSTRING( submitted, 1, {$length} ) AS \nsubmitted_month , user_id, realname, COUNT(*) as imgcount\nFROM `gridimage_search` \nGROUP BY SUBSTRING( submitted, 1, {$length} ) , user_id \nORDER BY submitted_month DESC"); $month = array(); foreach ($topusers as $idx => $entry) { if (!isset($month[$topusers[$idx]['submitted_month']]) || $topusers[$idx]['imgcount'] > $month[$topusers[$idx]['submitted_month']]) { $month[$topusers[$idx]['submitted_month']] = $topusers[$idx]['imgcount']; } } foreach ($topusers as $idx => $entry) { if ($topusers[$idx]['imgcount'] < $month[$topusers[$idx]['submitted_month']]) { unset($topusers[$idx]); } else { $topusers[$idx]['month'] = getFormattedDate($topusers[$idx]['submitted_month']); } } $smarty->assign_by_ref('topusers', $topusers); //lets find some recent photos new RecentImageList($smarty); } $smarty->display($template, $cacheid);
if ($timerel == 'during') { if (!empty($when) && !empty($when2)) { $timesqlrel = "BETWEEN YEAR('{$whenlow}')*12+MONTH('{$whenlow}') AND YEAR('{$whenhigh}')*12+MONTH('{$whenhigh}')-1"; $timedescrel = sprintf($MESSAGES['leaderboard']['time_during'], getFormattedDate($when)); } } else { if ($timerel == 'dbefore') { if (!empty($when2)) { $timesqlrel = "< YEAR('{$whenhigh}')*12+MONTH('{$whenhigh}')"; $timedescrel = sprintf($MESSAGES['leaderboard']['time_until'], getFormattedDate($when2)); } } else { if ($timerel == 'dafter') { if (!empty($when)) { $timesqlrel = ">= YEAR('{$whenlow}')*12+MONTH('{$whenlow}')"; $timedescrel = sprintf($MESSAGES['leaderboard']['time_from'], getFormattedDate($when)); } } } } } if ($timesqlrel !== '') { if ($date == 'both') { $timesql = " and year(imagetaken) != 0 and year(submitted) != 0 and month(imagetaken) != 0 and month(submitted) != 0 and year(imagetaken)*12+month(imagetaken) {$timesqlrel} and year(submitted)*12+month(submitted) {$timesqlrel}"; $timedesc = sprintf($MESSAGES['leaderboard']['taken_submitted'], $timedescrel); } else { $column = $date == 'taken' ? 'imagetaken' : 'submitted'; $timesql = " and year({$column}) != 0 and month({$column}) != 0 and year({$column})*12+month({$column}) {$timesqlrel}"; $timedesc = sprintf($MESSAGES['leaderboard'][$date == 'taken' ? 'taken' : 'submitted'], $timedescrel); } }
?> </td> </tr> <? } ?> <tr> <td>Captured By</td> <td><?php echo getDetailedTableInfo2("vl_samples", "id='{$id}' limit 1", "createdby"); ?> </td> </tr> <tr> <td>On</td> <td><?php echo getFormattedDate(getDetailedTableInfo2("vl_samples", "id='{$id}' limit 1", "created")); ?> </td> </tr> <tr> <td width="20%" valign="top">Received Status</td> <td width="80%"> </td> </tr> <tr> <td>Lab Comments</td> <td><textarea name="comments" id="comments" cols="40" rows="3" class="searchLarge"></textarea></td> </tr> </table> </div>
echo getDetailedTableInfo2("vl_forms_clinicalrequest", "refNumber='{$q['refNumber']}' order by formNumber desc limit 1", "formNumber"); ?> )</div> </td> <td class="<?php echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder"; ?> "> <? if(!getDetailedTableInfo2("vl_forms_clinicalrequest_dispatch","refNumber='$q[refNumber]' limit 1","id")) { ?> <div class="vls_grey" style="padding:3px 0px 0px 0px"><a href="/generateforms/dispatch/<?php echo $q["refNumber"]; ?> /">Input Dispatch Date</a></div> <? } else { ?> <div class="vls_grey" style="padding:3px 0px 0px 0px">Dispatched on <?php echo getFormattedDate(getDetailedTableInfo2("vl_forms_clinicalrequest_dispatch", "refNumber='{$q['refNumber']}' limit 1", "dispatchDate")); ?> (<a href="/generateforms/dispatch/<?php echo $q["refNumber"]; ?> /">edit</a>)</div> <? } ?> </td> </tr> <? } ?> </table> </div> </td> </tr> <tr> <td style="padding:20px 0px 0px 0px"><a href="/generateforms/">Return to Generate Forms</a> :: <a href="/dashboard/">Return to Dashboard</a></td>
echo $artNumber ? "ART Number" : ""; echo $artNumber && $otherID ? "/" : ""; echo $otherID ? "OtherID" : ""; ?> :</strong> <?php echo $artNumber ? $artNumber : ""; echo $artNumber && $otherID ? "/" : ""; echo $otherID ? $otherID : ""; ?> </div> <div class="vls_grey" style="padding:3px 0px 0px 0px"><strong>SampleID:</strong> <?php echo $sampleID; ?> </div> <div class="vls_grey" style="padding:3px 0px 0px 0px"><strong>Scheduled on:</strong> <?php echo getFormattedDate($created); ?> by <?php echo $createdby; ?> </div> </td> <td class="<?php echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder"; ?> " align="center"><a href="javascript:if(confirm('Are you sure?')) { document.location.href='?act=repeatSamples&nav=datamanagement&option=remove&id=<?php echo $q["id"]; ?> '; }">delete</a></td> </tr> <? } ?>
$smarty->assign('tendown', range(9, 0)); } else { //must be a date (unless something has gone wrong!) $year = preg_match('/year$/', $_GET['by']) === 1; $taken = preg_match('/^taken/', $_GET['by']) === 1; $length = $year ? 4 : 7; $column = $taken ? 'imagetaken' : 'submitted'; $msgid = ($year ? 'year' : 'month') . '_' . ($taken ? 'taken' : 'submitted'); $breakdown_title = $MESSAGES['browse']['bdtitle_' . $msgid]; $title = $MESSAGES['browse']['title_' . $msgid]; $all = $db->cacheGetAll($cacheseconds, "SELECT SUBSTRING({$column},1,{$length}) as date,count(*),\n\t\t\t\tgridimage_id,title,user_id,gi.realname as credit_realname,if(gi.realname!='',gi.realname,user.realname) as realname\n\t\t\t\tFROM gridimage gi inner join user using(user_id)\n\t\t\t\tWHERE gridsquare_id = '{$square->gridsquare_id}'\n\t\t\t\tAND {$user_crit} {$custom_where}\n\t\t\t\tGROUP BY SUBSTRING({$column},1,{$length})"); $column = $taken ? 'taken' : 'submitted'; $start = rand(0, max(0, count($all) - 20)); $end = $start + 20; foreach ($all as $row) { $date = getFormattedDate($row[0]); $breakdown[$i] = array('name' => "{$title} <b>{$date}</b>", 'count' => $row[1]); if (empty($_GET['ht']) && $i >= $start && $i < $end) { $breakdown[$i]['image'] = new GridImage(); $row['grid_reference'] = $square->grid_reference; $breakdown[$i]['image']->fastInit($row); } if ($row[1] > 20) { $datel = $row[0] . substr('-00-00', 0, 10 - $length); $breakdown[$i]['link'] = "/search.php?gridref={$square->grid_reference}&distance=1&orderby=submitted&{$column}_start={$datel}&{$column}_end={$datel}&do=1"; } elseif ($row[1] == 1) { $breakdown[$i]['link'] = "/photo/{$row[2]}"; } else { $breakdown[$i]['link'] = "/gridref/{$square->grid_reference}?{$_GET['by']}={$row[0]}" . $extra; } $i++;
$smarty->assign_by_ref('profile', $profile); $title .= " for " . $profile->realname; } if ($ri) { $where[] = "reference_index = {$ri}"; $smarty->assign('ri', $ri); $title .= " in " . $CONF['references_all'][$ri]; } if (count($where)) { $where_sql = " WHERE " . join(' AND ', $where); } $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; $table = $db->GetAll("\nselect substring(submitted,1,7) as `Month`,\ncount(*) as `Submitted`,\nsum(imagetaken LIKE CONCAT(substring(submitted,1,7),'%')) as `Submitted and Taken` \nfrom gridimage_search {$where_sql} \ngroup by substring(submitted,1,7); "); foreach ($table as $idx => $entry) { if ($entry['Month'] . '-00') { $table[$idx]['Month'] = getFormattedDate($entry['Month'] . '-00'); } $table[$idx]['Percentage'] = number_format($entry['Submitted and Taken'] / $entry['Submitted'] * 100); } $smarty->assign_by_ref('table', $table); $smarty->assign("h2title", $title); $smarty->assign("total", count($table)); $smarty->assign_by_ref('references', $CONF['references_all']); $extra = array(); foreach (array('users', 'date') as $key) { if (isset($_GET[$key])) { $extra[$key] = $_GET[$key]; } } $smarty->assign_by_ref('extra', $extra); } else {
</tr> </table> </div> </fieldset> </td> </tr> <tr> <td> <fieldset style="width: 100%"> <legend><strong>REPEAT SCHEDULE DETAILS</strong></legend> <div style="padding:5px 0px 0px 0px"> <table width="100%" border="0" class="vl"> <tr> <td width="30%" style="padding:4px 0px; border-bottom: 1px dashed #dfe6e6">Scheduled on</td> <td width="70%" style="padding:4px 0px; border-bottom: 1px dashed #dfe6e6"><?php echo getFormattedDate($scheduledDate); ?> </td> </tr> <tr> <td style="padding:4px 0px">By</td> <td style="padding:4px 0px"><?php echo $by; ?> </td> </tr> </table> </div> </fieldset> </td> </tr>
$analytics = PincodeAnalytics::getTodayAnalytics($connection, $city); } elseif ($period === "weekly") { $analytics = PincodeAnalytics::getWeeklyAnalytics($connection, $city); } elseif ($period === "monthly") { $analytics = PincodeAnalytics::getMonthlyAnalytics($connection, $city); } elseif ($period === "tilldate") { $analytics = PincodeAnalytics::getTillDateAnalytics($connection, $city); } //No pincodes collected if (empty($analytics) === TRUE) { $output_json = array("status" => "success", "count" => 0, "date" => getFormattedDate($period), "total_business_collected" => 0); echo json_encode($output_json); return; } $total_business_collected = calculateTotalBusinessCollected($analytics); echo json_encode(array("status" => "success", "date" => getFormattedDate($period), "count" => count($analytics), "analytics" => $analytics, "total_business_collected" => $total_business_collected)); } catch (DatabaseConnectionException $e) { $failure_json = array("status" => "error", "error" => "Database Unavailable"); echo json_encode($failure_json); return; } catch (QueryFailedException $e) { error_log(mysqli_error($connection)); $failure_json = array("status" => "error", "error" => "Query Failed"); echo json_encode($failure_json); return; } mysqli_close($connection); function calculateTotalBusinessCollected($analytics) { $total = 0; foreach ($analytics as $index => $data) {
$noDaysInPeriod = isset($_POST['noDays']) ? $_POST['noDays'] : 0; if ($absolute) { $startDate = isset($_POST['startDate']) ? $_POST['startDate'] : null; $daysToRelStart = null; } else { $daysToRelStart = isset($_POST['daysToRelStart']) ? $_POST['daysToRelStart'] : 0; } $policy = array('id' => $id, 'name' => $name, 'description' => $description, 'policyType' => $type, 'absolute' => $absolute, 'startDate' => $startDate, 'daysToRelStart' => $daysToRelStart, 'daysInPeriod' => $noDaysInPeriod, 'numberOfPeriods' => 1, 'active' => $active, 'assignable' => $assignable, 'quotaInPeriod' => $quotaInPeriod); } else { if ($type == "GRADUAL") { $maxQuota = isset($_POST['maxQuota']) ? $_POST['maxQuota'] : 0; $noPeriods = isset($_POST['noPeriods']) ? $_POST['noPeriods'] : 0; $noDaysInPeriod = isset($_POST['noDaysInPeriod']) ? $_POST['noDaysInPeriod'] : 0; if ($absolute) { $startDate = isset($_POST['startDate']) ? $_POST['startDate'] : null; $startDate = getFormattedDate("/", $startDate); $daysToRelStart = null; } else { $startDate = null; $daysToRelStart = isset($_POST['daysToRelStart']) ? $_POST['daysToRelStart'] : 0; } $policy = array('id' => $id, 'name' => $name, 'description' => $description, 'policyType' => $type, 'absolute' => $absolute, 'startDate' => $startDate, 'daysToRelStart' => $daysToRelStart, 'daysInPeriod' => $noDaysInPeriod, 'numberOfPeriods' => $noPeriods, 'active' => $active, 'assignable' => $assignable, 'maximum' => $maxQuota, 'quotaInPeriod' => $quotaInPeriod); } else { if ($type == "MINMAX") { $maxQuota = isset($_POST['maxQuota']) ? $_POST['maxQuota'] : 0; $minQuota = isset($_POST['minQuota']) ? $_POST['minQuota'] : 0; $noPeriods = isset($_POST['noPeriods']) ? $_POST['noPeriods'] : 0; $noDaysInPeriod = isset($_POST['noDaysInPeriod']) ? $_POST['noDaysInPeriod'] : 0; if ($absolute) { $startDate = isset($_POST['startDate']) ? $_POST['startDate'] : null; //$startDate = getFormattedDate("/",$startDate);
<td> <fieldset style="width: 100%"> <legend><strong>ENTRANT'S DETAILS</strong></legend> <div style="padding:5px 0px 0px 0px"> <table width="100%" border="0" class="vl"> <tr> <td width="30%" style="padding:4px 0px; border-bottom: 1px dashed #dfe6e6">Captured By</td> <td width="70%" style="padding:4px 0px; border-bottom: 1px dashed #dfe6e6"><?php echo $createdby; ?> </td> </tr> <tr> <td style="padding:4px 0px">On</td> <td style="padding:4px 0px"><?php echo getFormattedDate($created) . " at " . getFormattedTimeLessS($created); ?> </td> </tr> </table> </div> </fieldset> </td> </tr> </table> </div> </td> </tr> <tr> <td><img src="/images/spacer.gif" width="10" height="10" /></td> </tr>
" width="20%"><?php echo $q["username"]; ?> </td> <td class="<?php echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder"; ?> " width="40%"><?php echo $q["email"]; ?> </td> <td class="<?php echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder"; ?> " width="20%"><?php echo getFormattedDate($q["login"]) ? getFormattedDateLessDay($q["login"]) : "Unavailable"; ?> </td> <td class="<?php echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder"; ?> " width="20%"><a href="?act=admins&nav=configuration&modify=modify&id=<?php echo $q["id"]; ?> ">edit</a> :: <a href="javascript:if(confirm('Are you sure?')) { document.location.href='?act=admins&nav=configuration&option=remove&id=<?php echo $q["id"]; ?> '; }">delete</a></td> </tr> <? } ?> </table>
$error.="<br /><strong>Incorrect Envelope Number $lrEnvelopeNumber for a DBS Type Sample.</strong><br />The valid range for DBS type samples is $lrEnvelopeNumberArray[0]-0501 and above.<br />"; } //possible contradicting gender $mostRecentGender=0; $mostRecentGender=getDetailedTableInfo2("vl_patients","id='$patientID' limit 1","gender"); $mostRecentGenderCreated=0; $mostRecentGenderCreated=getDetailedTableInfo2("vl_patients","id='$patientID' limit 1","created"); $mostRecentGenderCreatedBy=0; $mostRecentGenderCreatedBy=getDetailedTableInfo2("vl_patients","id='$patientID' limit 1","createdby"); if($mostRecentGender && (($mostRecentGender=="Female" && $gender=="Male") || ($mostRecentGender=="Male" && $gender=="Female")) && !$proceedWithWarningGender) { $warnings.="<div style=\"padding: 10px 0px 0px 0px\">Possible Data Contradiction!</div> <div style=\"padding: 5px 0px 0px 0px\" class=\"vls_grey\">The patient with ".($artNumber?"ART <strong>$artNumber</strong>":"").($artNumber && $otherID?", ":"").($otherID?"Other ID <strong>$otherID</strong>":"")." created on <strong>".getFormattedDate($mostRecentGenderCreated)."</strong> by <strong>$mostRecentGenderCreatedBy</strong> was last created with the gender <strong>$mostRecentGender</strong>.</div> <div style=\"padding: 5px 0px 0px 0px\" class=\"vls_grey\">You are however currently submitting this patient with the gender <strong>$gender</strong>. If the gender you have supplied is accurate, click \"Proceed Anyway\" otherwise, change the gender to <strong>$mostRecentGender</strong> then click \"Save Samples\" to proceed.</div> <div style=\"padding: 10px 0px 10px 0px\" class=\"trailanalyticss_grey\"><input type=\"submit\" name=\"proceedWithWarningGender\" class=\"button\" value=\" Proceed Anyway \" /></div>"; } //If the facilityID is different from that of the facility this form was dispatched to, inform the user //reference number based on form number $refNumberByFormNumber=0; $refNumberByFormNumber=getDetailedTableInfo2("vl_forms_clinicalrequest","formNumber='$formNumber' limit 1","refNumber"); //facility ID based on form number $facilityIDByFormNumber=0; $facilityIDByFormNumber=getDetailedTableInfo2("vl_forms_clinicalrequest_dispatch","refNumber='$refNumberByFormNumber' limit 1","facilityID"); if($facilityIDByFormNumber && $facilityIDByFormNumber!=$facilityID && !$proceedWithWarningAlternativeFacilities) { $warnings.="<div style=\"padding: 10px 0px 0px 0px\">Possible incorrect Facility!</div> <div style=\"padding: 5px 0px 0px 0px\" class=\"vls_grey\">The form with number <strong>$formNumber</strong> was originally dispatched to facility <strong>".getDetailedTableInfo2("vl_facilities","id='$facilityIDByFormNumber' limit 1","facility")."</strong></div> <div style=\"padding: 5px 0px 0px 0px\" class=\"vls_grey\">Your submission indicates it's being returned from another facility <strong>".getDetailedTableInfo2("vl_facilities","id='$facilityID' limit 1","facility")."</strong>. If this is the case, then click \"Proceed Anyway\" otherwise, input amend the facility then click \"Save Samples\" to proceed.</div>
$db = NewADOConnection($GLOBALS['DSN']); if (!$db) { die('Database connection failed'); } } $andwhere = ''; if ($when) { if (strlen($when) == 7) { $andwhere = " and submitted < DATE_ADD('{$when}-01',interval 1 month)"; } elseif (strlen($when) == 4) { $andwhere = " and submitted < DATE_ADD('{$when}-01-01',interval 1 year)"; } else { $andwhere = " and submitted < '{$when}'"; } $smarty->assign_by_ref('when', $when); $smarty->assign('whenname', getFormattedDate($when)); } if ($where) { $andwhere .= " and grid_reference like '{$where}%'"; $smarty->assign_by_ref('where', $where); } $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; if (isset($_GET['cloud'])) { if ($andwhere) { $users = $db->CacheGetAssoc(3600 * 6, "select\r\n\t\t\t\tnickname,user.user_id,user.realname,user.user_id,count(*) as images\r\n\t\t\t\tfrom user\r\n\t\t\t\t\tinner join gridimage_search gi using (user_id)\r\n\t\t\t\twhere nickname != '' and rights IS NOT NULL {$andwhere}\r\n\t\t\t\tgroup by gi.user_id\r\n\t\t\t\torder by images desc"); $smarty->assign('what', 'Contributors'); } else { $users = $db->CacheGetAssoc(3600 * 6, "select\r\n\t\t\t\tnickname,user.user_id,user.realname,user.user_id,`us`.images\r\n\t\t\t\tfrom user\r\n\t\t\t\t\tinner join user_stat `us` using (user_id)\r\n\t\t\t\twhere nickname != '' and rights IS NOT NULL \r\n\t\t\t\torder by images desc"); $smarty->assign('what', 'Contributors'); } $size = $startsize = 30;
function renderAchievement($id, &$a, $guid) { // Skip show if not completed parent present or no_points not completed if ($a['parentAchievement'] || !$a['date'] && !$a['points'] && $guid) { return; } echo '<div class="ach_show' . ($a['date'] ? '' : ' locked') . '" onclick="showAchReq(this);">'; // Render icon echo '<img class=ach_icon src="' . getSpellIcon($a['iconId']) . '">'; echo '<div class=ach_frame></div>'; // Render points if ($a['points']) { echo '<div class=ach_point>' . $a['points'] . '</div>'; } echo '<div class=ach_title>' . $a['name'] . '</div>'; echo '<div class=ach_desc>' . $a['description'] . '</div>'; // echo '<div class=ach_desc>Flags - 0x'.dechex($a['flags']).' - '.$a['count'].'</div>'; // Render requirements echo '<div class=ach_req id=' . $id . '>'; if ($a['flags'] & CUSTOM_ACHIEVEMENT_SHOW) { getAchievementValue(&$a, &$value, &$maxvalue); if ($a['flags'] & ACHIEVEMENT_FLAG_BAR) { echo '<div class="sub bar">' . renderProgress($value, $maxvalue) . '</div>'; } else { if ($a['flags'] & ACHIEVEMENT_FLAG_MAX_USED) { echo '<div class="sub bar">' . renderProgress($value, $maxvalue) . '</div>'; } else { echo '<div class="sub ' . ($value >= $maxvalue ? 'compl' : '') . '">' . $value . '</div>'; } } } foreach ($a['requirement'] as $r) { if ($r['completionFlag'] & ACHIEVEMENT_CRITERIA_FLAG_HIDE_CRITERIA) { continue; } if ($r['completionFlag'] & ACHIEVEMENT_CRITERIA_FLAG_SHOW_PROGRESS_BAR) { echo '<div class=sub_bar>' . renderProgress(@$r['counter'], $r['value'], $r['completionFlag'] & ACHIEVEMENT_CRITERIA_FLAG_MONEY_COUNTER) . '</div>'; } else { $text = $r['name'] ? $r['name'] : $a['name']; $completed = $r['counter'] ? $r['counter'] >= $r['value'] ? 'compl' : '' : ''; // $text.="-> $r[id] - f=$r[completionFlag], c=$r[counter], d=$r[data], v=$r[value]"; echo '<div class="sub ' . $completed . '">' . $text . '</div>'; } } echo '<br clear="all"/></div>' . "\n"; // render date if ($a['date']) { echo '<div class=ach_date>' . getFormattedDate($a['date']) . '</div>'; } if ($a['titleReward']) { echo '<div class=ach_reward>' . $a['titleReward'] . '</div>'; } echo '</div>'; }
$where[] = "poster_id=" . $u; $smarty->assign('u', $u); $profile = new GeographUser($u); $smarty->assign_by_ref('profile', $profile); $title .= " for " . $profile->realname; } else { $columns_sql = ", count( DISTINCT poster_id ) AS `Different Posters`"; } if (count($where)) { $where_sql = " WHERE " . join(' AND ', $where); } $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; $table = $db->GetAll("SELECT \n\tsubstring( post_time, 1, {$length} ) AS `Date`, \n\tcount( * ) AS `Posts`, \n\tcount( DISTINCT forum_id ) AS `Different Forums`, \n\tcount( DISTINCT topic_id ) AS `Different Topics`\n\t{$columns_sql}\nFROM `geobb_posts` {$where_sql}\nGROUP BY substring( post_time, 1, {$length} )"); if (!isset($_GET['output']) || $_GET['output'] != 'csv') { foreach ($table as $idx => $entry) { $table[$idx]['Date'] = getFormattedDate($table[$idx]['Date']); } } $smarty->assign_by_ref('table', $table); $smarty->assign("h2title", $title); $smarty->assign("total", count($table)); $extra = array(); foreach (array('month') as $key) { if (isset($_GET[$key])) { $extra[$key] = $_GET[$key]; } } $smarty->assign_by_ref('extra', $extra); } else { if ($u) { $profile = new GeographUser($u);
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php echo getDetailedTableInfo2("vl_appendix_viralloadtesting", "id='{$viralLoadTesting}' limit 1", "appendix"); ?> </td> </tr> <tr> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>Current Regimen</strong></td> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php echo $currentRegimen; ?> </td> </tr> <tr> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>Treatment Initiation Date <font class="vl_red">*</font></strong></td> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php echo getFormattedDate($treatmentInitiationDate); ?> </td> </tr> <tr> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>Treatment Initiation <font class="vl_red">*</font></strong></td> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php echo getDetailedTableInfo2("vl_appendix_treatmentinitiation", "id='{$treatmentInitiation}' limit 1", "appendix"); ?> </td> </tr> <tr> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>Treatment Status <font class="vl_red">*</font></strong></td> <td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php echo getDetailedTableInfo2("vl_appendix_treatmentstatus", "id='{$treatmentStatus}' limit 1", "appendix"); ?>
<tr> <td> </td> </tr> <? } ?> <tr> <td class="toplinks" style="padding:0px 0px 10px 0px"><a class="toplinks" href="/dashboard/">HOME</a> <a class="toplinks" href="/samples/">SAMPLES</a></td> </tr> <? //if(getDetailedTableInfo2("vl_samples_verify","sampleID='$modify'","outcome")) { ?> <!-- <tr> <td class="vl_error"> <div>This Sample's Status was changed to <strong><?php echo getDetailedTableInfo2("vl_samples_verify", "sampleID='{$modify}'", "outcome"); ?> </strong> on <strong><?php echo getFormattedDate(getDetailedTableInfo2("vl_samples_verify", "sampleID='{$modify}'", "created")); ?> </strong> by <strong><?php echo getDetailedTableInfo2("vl_samples_verify", "sampleID='{$modify}'", "createdby"); ?> </strong></div> <div style="padding:3px 0px 0px 0px" class="vls_grey">This sample can therefore no longer be modified!</div> <div style="padding:1px 0px 0px 0px" class="vls_grey"><a href="#" onclick="iDisplayMessage('/verify/status/<?php echo $modify; ?> /<?php echo getDetailedTableInfo2("vl_samples_verify", "sampleID='{$modify}'", "outcome"); ?> /')">Click to View <?php echo getDetailedTableInfo2("vl_samples_verify", "sampleID='{$modify}'", "outcome"); ?>
function builddate(&$dataarray, $which) { if (isset($dataarray[$which . 'Year'])) { $dataarray[$which] = sprintf("%04d-%02d-%02d", $dataarray[$which . 'Year'], $dataarray[$which . 'Month'], $dataarray[$which . 'Day']); if ($dataarray[$which] == '0000-00-00') { $dataarray[$which] = ''; } } if (!empty($dataarray[$which])) { $dataarray[$which . 'String'] = getFormattedDate($dataarray[$which]); } }