// no change, collect unit names
// $buffer = $row;
} else {
do_print($buffer);
// print from buffer
do_stats($buffer);
$buffer = $row;
$units_str = $row['unit_name'];
}
}
// end if/else
}
// end while(
do_print($buffer);
// print from buffer
do_stats($buffer);
}
// end else{}
$tick_array2 = array_unique($tick_array);
// delete dupes
$tick_array3 = array_values($tick_array2);
// compress result
$sep = $tick_str = "";
for ($i = 0; $i < count($tick_array3); $i++) {
$tick_str .= $sep . $tick_array3[$i];
$sep = ",";
}
// dump($tick_str);
$query = "SELECT *, \n\t\tUNIX_TIMESTAMP(problemstart) AS `problemstart`,\n\t\tUNIX_TIMESTAMP(problemend) AS `problemend`,\n\t\t`u`.`user` AS `theuser`,\n\t\tNULL AS `unit_name`,\n\t\t`t`.`scope` AS `tick_scope`,\n\t\t`t`.`id` AS `tick_id`,\n\t\t`t`.`description` AS `tick_descr`,\n\t\t`t`.`status` AS `tick_status`,\n\t\t`t`.`street` AS `tick_street`,\n\t\t`t`.`city` AS `tick_city`,\n\t\t`t`.`state` AS `tick_state`,\t\t\t\n\t\t`f`.`name` AS `facy_name` \n\t\tFROM `{$GLOBALS['mysql_prefix']}ticket`\t\t\t `t`\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}user`\t\t `u` ON (`t`.`_by` = `u`.`id`)\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}facilities` `f` ON (`t`.`facility` = `f`.`id`)\n\t\tWHERE `t`.`id` NOT IN ({$tick_str})\n\t\tAND `t`.`status` <> '{$GLOBALS['STATUS_RESERVED']}'\n\t\tORDER BY `problemstart` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
print "<TR><TD COLSPAN=99 ALIGN='center'><B>Not dispatched</B></TD></TR>";
if ($dst[$x] == '1') {
if ($strike) {
$out .= $s[$x];
} else {
$out .= '<strike>' . $s[$x];
}
$strike = true;
} else {
if ($strike) {
$out .= '</strike>';
}
$strike = false;
$out .= $s[$x];
}
}
}
// Many of the underline sequences are also wrapped in asterisks,
// which was yet another way of marking ASCII as 'bold'.
// So if it's an underline sequence, and there are asterisks
// on both ends, strip the asterisks as we've already emboldened the text.
$out = preg_replace('/\\*(<strong>[^<]*<\\/strong>)\\*/', "\\1", $out);
// Finally, remove the backspace characters which we don't need anymore.
return str_replace("", "", $out);
}
$result1 = do_query($table, $length, $numlines, $adult, $cat, 1, $lang, $pattern, $regex, $equal);
if (count($result1)) {
echo $result1[0];
}
if ($stats) {
do_stats($table, $length, $numlines, $adult, $cat, 1, $lang, $pattern, $regex, $equal);
}
function disect_p($data)
{
$tmp = explode('<br>', trim($data->innertext));
$i_cnt = count($tmp) - 1;
while ($tmp[$i_cnt] == '') {
$i_cnt--;
}
$array_values = array();
$sum = break_sum($tmp[$i_cnt]);
for ($i = 0; $i < $i_cnt; $i++) {
#print "monkey = {$tmp[$i]}";
if ($tmp_can = break_candidate($tmp[$i])) {
$st_key = $tmp_can['name'] . '_' . $tmp_can['party'];
$array_values[$st_key] = do_stats(array('votes' => $tmp_can['vals']), $sum);
$array_values[$st_key]['party'] = $tmp_can['party'];
$array_values[$st_key]['name'] = $tmp_can['name'];
}
}
$array_values['MNV'] = get_novote($sum);
$array_values['summary'] = $sum;
return $array_values;
}
function do_im_report($date_in, $func_in)
{
// incident mgmt report $frm_date, $mode as params - 9/27/10
global $types, $tick_array, $deltas, $counts, $severities, $units_str, $evenodd, $logs, $types;
global $types, $incident, $disposition;
// 12/7/10
global $w_tiny, $w_small, $w_medium, $w_large;
// 4/14/11
$tick_array = array(0);
$deltas = array(0, 0, 0, 0);
// normal, medium, high, total
$counts = array(0, 0, 0, 0);
//
$severities = array("", "M", "H");
// severity symbols
$from_to = date_range($date_in, $func_in);
// get date range as array
$where = " WHERE `problemstart` >= '{$from_to[0]}' AND `problemstart` < '{$from_to[1]}'";
function do_print($row_in)
{
global $today, $today_ref, $line_ctr, $units_str, $severities, $evenodd;
global $w_tiny, $w_small, $w_medium, $w_large;
if (empty($today)) {
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
} else {
if (!($today_ref == date("z", $row_in['problemstart']))) {
// date change?
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
}
}
$def_city = get_variable('def_city');
$def_st = get_variable('def_st');
print "<TR CLASS = '{$evenodd[$line_ctr % 2]}' onClick = 'open_tick_window(" . $row_in['tick_id'] . ");' >\n";
print "<TD>{$today}</TD>\n";
// Date -
$problemstart = format_date($row_in['problemstart']);
$problemstart_sh = short_ts($problemstart);
print "<TD onMouseover=\"Tip('{$problemstart}');\" onmouseout='UnTip();'>{$problemstart_sh}</TD>\n";
// start
$problemend = format_date($row_in['problemend']);
$problemend_sh = short_ts($problemend);
print "<TD onMouseover=\"Tip('{$problemend}');\" onmouseout='UnTip();'>{$problemend_sh}</TD>\n";
// end
$elapsed = intval($row_in['problemstart']) > 0 && intval($row_in['problemend']) > 0 ? my_date_diff($row_in['problemstart'], $row_in['problemend']) : "na";
print "<TD>{$elapsed}</TD>\n";
// Ending time
print "<TD ALIGN='center'>{$severities[$row_in['severity']]}</TD>\n";
$scope = $row_in['tick_scope'];
$scope_sh = shorten($row_in['tick_scope'], $w_medium);
print "<TD onMouseover=\"Tip('{$scope}');\" onmouseout='UnTip();'>{$scope_sh}</TD>\n";
// Call type
$comment = $row_in['comments'];
$short_comment = shorten($row_in['comments'], $w_large);
print "<TD onMouseover=\"Tip('{$comment}');\" onMouseout='UnTip();'>{$short_comment}</TD>\n";
// Comments/Disposition
$facility = $row_in['facy_name'];
$facility_sh = shorten($row_in['facy_name'], $w_small);
print "<TD onMouseover=\"Tip('{$facility}');\" onmouseout='UnTip();'>{$facility_sh}</TD>\n";
// Facility
$city = $row_in['tick_city'] == $def_city ? "" : ", {$row_in['tick_city']}";
$st = $row_in['tick_state'] == $def_st ? "" : ", {$row_in['tick_state']}";
$addr = "{$row_in['tick_street']}{$city}{$st}";
$addr_sh = shorten($row_in['tick_street'] . $city . $st, $w_medium);
print "<TD onMouseover=\"Tip('{$addr}');\" onMouseout='UnTip();'>{$addr_sh}</TD>\n";
// Street addr
print "<TD>{$units_str}</TD>\n";
// Units responding
print "</TR>\n\n";
$line_ctr++;
}
// end function do print()
function do_stats($in_row)
{
//
global $deltas, $counts;
if (intval($in_row['problemstart']) > 0 && intval($in_row['problemend']) > 0) {
$deltas[$in_row['severity']] += $in_row['problemend'] - $in_row['problemstart'];
$deltas[3] += $in_row['problemend'] - $in_row['problemstart'];
}
$counts[$in_row['severity']]++;
$counts[3]++;
}
// end function do stats()
// 12/7/10
function do_print_log($ary_in)
{
// ["code"]=> string(1) "3" ["info"]=> string(14) "test test test" ["when"]=> string(10) "1302117158"
global $today, $today_ref, $line_ctr, $evenodd, $types;
global $w_tiny, $w_small, $w_medium, $w_large;
print "<TR CLASS = '{$evenodd[$line_ctr % 2]}'>\n";
print "<TD>{$today}</TD>\n";
// Date -
$when = format_date($ary_in['when']);
$when_sh = short_ts($when);
print "<TD onMouseover=\"Tip('{$when}');\" onmouseout='UnTip();'>{$when_sh}</TD>\n";
// start
print "<TD COLSPAN=3></TD>\n";
// end Ending time
print "<TD><I>Log entry:</I></TD>\n";
// Call type
$info = $ary_in['info'];
$sh_info = shorten($ary_in['info'], $w_large);
print "<TD onMouseover=\"Tip('{$info}');\" onMouseout='UnTip();'>{$sh_info}</TD>\n";
// Comments/Disposition
print "<TD>{$ary_in['user']}</TD>\n";
// Facility
print "<TD COLSPAN=2></TD>\n";
// Street addr, Units responding
print "</TR>\n\n";
$line_ctr++;
}
// end function do print_log()
// populate global logs array
$where_l = str_replace("problemstart", "when", $where);
// log version - 7/22/11
$query = "SELECT `l`.`code`, `l`.`info` AS `info`, UNIX_TIMESTAMP(`l`.`when`) AS `when`, `u`.`user`, `u`.`info` AS `user_info`\n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}log` `l`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}user` u ON (`l`.who = u.id)\n\t\t\t\t{$where_l}\n\t\t\t\tAND (`code` = {$GLOBALS['LOG_COMMENT']})\n\t\t\t\tORDER BY `when` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
array_push($logs, $row);
}
unset($result);
function check_logs($in_time)
{
// prints qualifying log entries
global $logs;
while (!empty($logs) && $logs[0]['when'] <= $in_time) {
do_print_log($logs[0]);
array_shift($logs);
// remove 1st entry
}
}
// end function check_logs()
$query = "SELECT *, UNIX_TIMESTAMP(problemstart) AS `problemstart`,\n\t\t\t\tUNIX_TIMESTAMP(problemend) AS `problemend`,\n\t\t\t\t`a`.`id` AS `assign_id` ,\n\t\t\t\t`a`.`comments` AS `assign_comments`,\n\t\t\t\t`u`.`user` AS `theuser`, `t`.`scope` AS `tick_scope`,\n\t\t\t\t`t`.`id` AS `tick_id`,\n\t\t\t\t`t`.`description` AS `tick_descr`,\n\t\t\t\t`t`.`status` AS `tick_status`,\n\t\t\t\t`t`.`street` AS `tick_street`,\n\t\t\t\t`t`.`city` AS `tick_city`,\n\t\t\t\t`t`.`state` AS `tick_state`,\t\t\t\n\t\t\t\t`r`.`id` AS `unit_id`,\n\t\t\t\t`r`.`name` AS `unit_name` ,\n\t\t\t\t`r`.`type` AS `unit_type` ,\n\t\t\t\t`f`.`name` AS `facy_name` ,\n\t\t\t\t`a`.`as_of` AS `assign_as_of`\n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}assigns` `a`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}ticket`\t `t` ON (`a`.`ticket_id` = `t`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}user`\t\t `u` ON (`a`.`user_id` = `u`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}responder`\t `r` ON (`a`.`responder_id` = `r`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}facilities` `f` ON (`a`.`facility_id` = `f`.`id`)\n\t\t\t\t{$where}\n\t\t\t\tAND `t`.`status` <> '{$GLOBALS['STATUS_RESERVED']}'\t\t\t\t\n\t\t\t\tORDER BY `problemstart` ASC";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
//dump($query);
print "<TABLE BORDER=0 ALIGN='center' cellspacing = 1 CELLPADDING = 4 ID='IM' STYLE='display:block'>";
$to_str = $func_in == "dr" ? "" : " to {$from_to[3]} " . substr($from_to[1], 0, 4);
print "<TR CLASS='even'><TH COLSPAN=99 ALIGN = 'center'>" . "{$incident} Management Report - " . $from_to[2] . $to_str . "</TH></TR>\n";
print "<TR CLASS='odd'>\n\t\t\t\t\t<TD><B>Date</B></TD>\n\t\t\t\t\t<TD><B>Opened</B></TD>\n\t\t\t\t\t<TD><B>Closed</B></TD>\n\t\t\t\t\t<TD><B>Elapsed</B></TD>\n\t\t\t\t\t<TD><B>Severity</B></TD>\n\t\t\t\t\t<TD><B>Call type</B></TD>\n\t\t\t\t\t<TD><B>Comments/{$disposition}</B></TD>\n\t\t\t\t\t<TD><B>Facility</B></TD>\n\t\t\t\t\t<TD><B>Address</B></TD>\n\t\t\t\t\t<TD><B>" . get_text("Unit") . " responding</B></TD>\n\t\t\t\t\t</TR>";
if (mysql_num_rows($result) == 0) {
// empty?
print "<TR CLASS = 'even'><TH COLSPAN=99>none</TH></TR>\n";
print "<TR CLASS = 'odd'><TD COLSPAN=99><BR /><BR /></TD></TR>\n";
} else {
$units_str = "";
$i = 0;
$today = $today_ref = "";
$buffer = "";
$sep = ", ";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// major while ()
array_push($tick_array, $row['tick_id']);
// stack them up
if (empty($buffer)) {
// first time
$buffer = $row;
$units_str = $row['unit_name'];
} else {
// not first time
if ($row['tick_id'] == $buffer['tick_id']) {
$units_str .= $sep . $row['unit_name'];
// no change, collect unit names
// $buffer = $row;
} else {
check_logs($buffer['problemstart']);
// problemstart integer
do_print($buffer);
// print from buffer
do_stats($buffer);
$buffer = $row;
$units_str = $row['unit_name'];
}
}
// end if/else
}
// end while(
check_logs(time());
// everything remaining
do_print($buffer);
// print from buffer
do_stats($buffer);
}
// end else{}
$tick_array2 = array_unique($tick_array);
// delete dupes
$tick_array3 = array_values($tick_array2);
// compress result
$sep = $tick_str = "";
for ($i = 0; $i < count($tick_array3); $i++) {
$tick_str .= $sep . $tick_array3[$i];
$sep = ",";
}
$query = "SELECT *, \n\t\t\t\tUNIX_TIMESTAMP(problemstart) AS `problemstart`,\n\t\t\t\tUNIX_TIMESTAMP(problemend) AS `problemend`,\n\t\t\t\t`u`.`user` AS `theuser`,\n\t\t\t\tNULL AS `unit_name`,\n\t\t\t\t`t`.`scope` AS `tick_scope`,\n\t\t\t\t`t`.`id` AS `tick_id`,\n\t\t\t\t`t`.`description` AS `tick_descr`,\n\t\t\t\t`t`.`status` AS `tick_status`,\n\t\t\t\t`t`.`street` AS `tick_street`,\n\t\t\t\t`t`.`city` AS `tick_city`,\n\t\t\t\t`t`.`state` AS `tick_state`,\t\t\t\n\t\t\t\t`f`.`name` AS `facy_name` \n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}ticket`\t\t\t `t`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}user`\t\t `u` ON (`t`.`_by` = `u`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}facilities` `f` ON (`t`.`facility` = `f`.`id`)\n\t\t\t\t{$where}\n\t\t\t\tAND `t`.`id` NOT IN ({$tick_str})\n\t\t\t\tAND `t`.`status` <> '{$GLOBALS['STATUS_RESERVED']}'\n\t\t\t\tORDER BY `problemstart` ASC";
// dump($query);
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
print "<TR><TD COLSPAN=99 ALIGN='center'><B>Not dispatched</B></TD></TR>";
if (mysql_num_rows($result) == 0) {
print "<TR CLASS='even'><TD COLSPAN=99 ALIGN='center'><B>none</B></TD></TR>";
} else {
$units_str = "";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// incidents not dispatched
do_print($row);
do_stats($row);
}
}
if ($counts[3] > 0) {
// any stats?
print "<TR><TD COLSPAN=99 ALIGN='center'><B><BR />Mean incident close times by severity: ";
for ($i = 0; $i < 3; $i++) {
// each severity level
if ($counts[$i] > 0) {
$mean = round($deltas[$i] / $counts[$i]);
print "<B>" . ucfirst(get_severity($i)) . "</B> ({$counts[$i]}): " . my_date_diff(0, $mean) . ", ";
}
}
$mean = round($deltas[3] / $counts[3]);
// overall
print "<B>Overall</B> ({$counts[3]}): " . my_date_diff(0, $mean);
print "</B></TD></TR>";
}
print "</TABLE>";
return;
}
$options .= "<option value='{$p}'>{$p}</option>\n";
}
$dat = htmlentities($vars['dat']);
print "<form method='post' action='rebill_log.php'>\n\t<select name='paysys_id'>\n\t<option value=''>*** Select a Payment System to continue ***</option>\n\t{$options}</select> <br />\n\t<label><input type='checkbox' name='repeat_declined' value='1' />\n\tRe-process payments that were marked as declined\n\t</label><br />\n\t<input type='submit' value='Continue'>\n\t<input type='hidden' name='dat' value='{$dat}'>\n\t<input type='hidden' name='do' value='rebill'>\n\t</form>\n\t";
} else {
// do rebill
print "\n\t\t<h2>Manual CC Rebill {$hdat} - {$vars['paysys_id']}</h2>";
print "<p><b>Please do not stop/exit your browser, do not run other payment processes until this process is finished!</b></p>";
for ($i = 0; $i < 100; $i++) {
print " \n";
}
// to flush browser/apache buffer for sure
print " Rebilling Process started at " . strftime($config['time_format']) . "....<br />\n";
ob_end_flush();
$dat = date('Y-m-d', strtotime($vars['dat']));
$was = $db->query_one("SELECT COUNT(*) FROM {$db->config[prefix]}rebill_log");
cc_core_rebill($vars['paysys_id'], $dat, $from_cron = false, intval($vars['repeat_declined']));
$now = $db->query_one("SELECT COUNT(*) FROM {$db->config[prefix]}rebill_log");
$added = $now - $was;
print " Rebilling Process finished at " . strftime($config['time_format']) . ".<br />\n\t\t <b>{$added}</b> transactions processed. <br />\n";
print "<br /><a href='rebill_log.php?do=rebill_stats'>Go back to Rebilling Stats</a>";
}
$t->display('admin/footer.inc.html');
}
if ($_REQUEST['do'] == 'rebill_stats') {
do_stats();
} elseif ($_REQUEST['do'] == 'rebill') {
do_rebill();
} else {
do_logs();
}
echo "<h2>{$message}</h2>";
process_errors($message, true);
}
log_console_usage($domain, $_POST);
switch ($do) {
case 'perms':
do_perms($domain);
break;
case 'logs':
do_logs($domain);
break;
case 'cache':
do_cache($domain);
break;
case 'stats':
do_stats($domain);
break;
case 'stats_month':
do_stats_month($domain);
break;
case 'lockdown':
do_lockdown($domain);
break;
case 'undo_lockdown':
do_undo_lockdown($domain);
break;
case 'reset_passwd':
do_password_reset($domain);
break;
case 'wpadmin_ssl':
do_wpadmin_ssl($domain, $ssl_state);
