function get_addr()
{
// returns incident address 11/27/09
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE `id`= " . get_ticket_id() . " LIMIT 1";
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row = stripslashes_deep(mysql_fetch_array($result));
return "{$row['street']}<br />{$row['city']}<br /> {$row['state']}";
}
?>
";
side_bar_html+="</DIV></form></TD></TR><TR><TD COLSPAN=99> </TD></TR><TR><TD ALIGN='center' COLSPAN=99><INPUT TYPE='button' VALUE='Update' onClick='form_validate(document.region_form);'></TD></TR></TABLE>";
$("region_boxes").innerHTML = side_bar_html;
</SCRIPT>
<?php
}
?>
<A NAME="page_bottom" /> <!-- 5/13/10 -->
<FORM NAME='reLoad_Form' METHOD = 'get' ACTION="<?php
print basename(__FILE__);
?>
">
<INPUT TYPE='hidden' NAME='ticket_id' VALUE='<?php
print get_ticket_id();
?>
' /> <!-- 10/25/08 -->
</FORM>
</BODY>
<?php
// dump($addrs);
if ($addrs) {
// 10/21/08
?>
<SCRIPT>
function do_notify() {
// alert(352);
var theAddresses = '<?php
function get_cd_str($in_row)
{
// unit row in,
global $unit_id;
// // first, already on this run?
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . get_ticket_id() . "\n\t\t\t\t\t AND (`responder_id`={$in_row['unit_id']}) \n\t\t\t\t\t AND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00')) LIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " CHECKED DISABLED ";
}
if ($unit_id != "" && (mysql_affected_rows() != 1 || mysql_affected_rows() == 1 && intval($in_row['multi']) == 1)) {
print "checked";
return " CHECKED ";
}
// 12/18/10 - Checkbox checked here individual unit seleted.
if (intval($in_row['dispatch']) == 2) {
return " DISABLED ";
}
// 2nd, disallowed - 5/30/10
if (intval($in_row['multi']) == 1) {
return "";
}
// 3rd, allowed
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\tWHERE `responder_id`={$in_row['unit_id']} \n\t\t\t\t\tAND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00'))\n\t\t\t\t\tLIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " DISABLED ";
} else {
return "";
}
}
