📄 reports.php
字号:
. form_input('type2_week', $report[value1], 1)
. " week(s) on <br /> "
. form_checkbox_single('1', 1, @in_array(1, $days), 'type2_day') . " Mon "
. form_checkbox_single('2', 1, @in_array(2, $days), 'type2_day') . " Tue "
. form_checkbox_single('3', 1, @in_array(3, $days), 'type2_day') . " Wed "
. form_checkbox_single('4', 1, @in_array(4, $days), 'type2_day') . " Thu "
. form_checkbox_single('5', 1, @in_array(5, $days), 'type2_day') . " Fri "
. form_checkbox_single('6', 1, @in_array(6, $days), 'type2_day') . " Sat "
. form_checkbox_single('7', 1, @in_array(7, $days), 'type2_day') . " Sun "
);
} else {
$table[] = array('<b>Weekly Repeat</b>',
"<input type=\"radio\" name=\"type\" value=\"2\">
Run this report every "
. form_input('type2_week', '', 1) . " week(s) on <br /> "
. form_checkbox_single('1', 1, '', 'type2_day') . " Mon "
. form_checkbox_single('2', 1, '', 'type2_day') . " Tue "
. form_checkbox_single('3', 1, '', 'type2_day') . " Wed "
. form_checkbox_single('4', 1, '', 'type2_day') . " Thu "
. form_checkbox_single('5', 1, '', 'type2_day') . " Fri "
. form_checkbox_single('6', 1, '', 'type2_day') . " Sat "
. form_checkbox_single('7', 1, '', 'type2_day') . " Sun "
);
}
if ($report[repeattype] == 3) {
$table[] = array('<b>Monthly Repeat</b>',
"<input type=\"radio\" name=\"type\" value=\"3\" checked=checked>
Run this report on the "
. form_select('type3_day', make_numberarray(1, 31), '', $report[value1])
. " day of every "
. form_input('type3_month', $report[value2], 3)
. " month(s)"
);
} else {
$table[] = array('<b>Monthly Repeat</b>',
"<input type=\"radio\" name=\"type\" value=\"3\">
Run this report on the "
. form_select('type3_day', make_numberarray(1, 31), '', $report[value1])
. " day of every "
. form_input('type3_month', '', 3)
. " month(s)"
);
}
if ($report[repeattype] == 4) {
$table[] = array('<b>Yearly Repeat</b>',
"<input type=\"radio\" name=\"type\" value=\"4\" checked=checked>
Run this report every year on "
. form_select('type4_day', make_numberarray(1, 31), '', $report[value1])
. " "
. form_select('type4_month', $month, '', $report[value2])
);
} else {
$table[] = array('<b>Yearly Repeat</b>',
"<input type=\"radio\" name=\"type\" value=\"4\">
Run this report every year on "
. form_select('type4_day', make_numberarray(1, 31))
. " "
. form_select('type4_month', $month)
);
}
if ($_REQUEST['do'] == 'editreport') {
$hidden = array('do' => 'editreport2', 'id' => $report[id]);
$end = 'Edit Report';
} else {
$hidden = array('do' => 'newreport2');
$end = 'Create Report';
}
$width = array('40%', '60%');
table_header('Field Display Properties', 'reports.php', $hidden, '', 'dpform');
table_content('', $table, '', '', '', '', $width);
table_footer($end, 'center', '', '', "onclick=\"submitAllOptions(this.form.list21, this.form.stats)\"");
}
############################### EDIT / NEW REPORT ###############################
if ($_REQUEST['do'] == "newreport2" OR $_REQUEST['do'] == "editreport2") {
if ($_REQUEST[type] == '1') {
$repeattype = 'daily';
$val1 = $_REQUEST[type1_day];
} elseif ($_REQUEST[type] == '2') {
$repeattype = 'weekly';
$val1 = $_REQUEST[type2_week];
if (is_array($_REQUEST[type2_day])) {
foreach ($_REQUEST[type2_day] AS $key => $var) {
if ($var > 0) {
$tmp_array[] = $key;
}
}
}
$val2 = serialize($tmp_array);
unset($tmp_array);
} elseif ($_REQUEST[type] == '3') {
$repeattype = 'monthly';
$val1 = $_REQUEST[type3_day];
$val2 = $_REQUEST[type3_month];
} elseif ($_REQUEST[type] == '4') {
$repeattype = 'yearly';
$val1 = $_REQUEST[type4_day];
$val2 = $_REQUEST[type4_month];
}
if ($_REQUEST['do'] == 'newreport2') {
$db->query("INSERT INTO report SET
name = '" . mysql_escape_string($_REQUEST[name]) . "',
title = '" . mysql_escape_string($_REQUEST[title]) . "',
description = '" . mysql_escape_string($_REQUEST[description]) . "',
style = '" . mysql_escape_string($_REQUEST[style]) . "',
format = '" . mysql_escape_string($_REQUEST[format]) . "',
path = '" . mysql_escape_string($_REQUEST[path]) . "',
value1 = '" . mysql_escape_string($val1) . "',
value2 = '" . mysql_escape_string($val2) . "',
repeattype = '$repeattype',
email = '" . mysql_escape_string($_REQUEST[email]) . "'
");
$id = $db->last_id();
} else {
$db->query("UPDATE report SET
name = '" . mysql_escape_string($_REQUEST[name]) . "',
title = '" . mysql_escape_string($_REQUEST[title]) . "',
description = '" . mysql_escape_string($_REQUEST[description]) . "',
style = '" . mysql_escape_string($_REQUEST[style]) . "',
format = '" . mysql_escape_string($_REQUEST[format]) . "',
path = '" . mysql_escape_string($_REQUEST[path]) . "',
value1 = '" . mysql_escape_string($val1) . "',
value2 = '" . mysql_escape_string($val2) . "',
repeattype = '$repeattype',
email = '" . mysql_escape_string($_REQUEST[email]) . "'
WHERE id = '$id'
");
$db->query("DELETE FROM report_relations WHERE reportid = '$id'");
}
$relations = split(',', $_REQUEST[stats]);
foreach ($relations AS $key => $var) {
if ($var) {
$array[] = array($id, $var);
}
}
if (is_array($array)) {
$db->query("INSERT INTO report_relations (reportid, statid) VALUES " . insertsql($array));
}
if ($_REQUEST['do'] == 'newreport2') {
jump("reports.php?do=editreport&id=$id", 'New Report Created');
} else {
jump("reports.php?do=editreport&id=$id", 'Report Updated');
}
}
############################### EDIT / NEW STAT ###############################
if ($_REQUEST['do'] == "newstat2" OR $_REQUEST['do'] == "editstat2") {
// sort out ticket fields
if ($_REQUEST[awaiting_status]) {
$fixed_general[awaiting_status] = $_REQUEST[awaiting_status];
}
if ($_REQUEST[open_status]) {
$fixed_general[open_status] = $_REQUEST[open_status];
}
if ($_REQUEST[category]) {
$fixed_general[category] = $_REQUEST[category];
}
if ($_REQUEST[priority]) {
$fixed_general[priority] = $_REQUEST[priority];
}
// sort out ticket fields
$db->query("SELECT * from ticket_def");
while ($result = $db->row_array()) {
$data = field_def_val($result, $_REQUEST[ticketfields][$result[name]], $_REQUEST[ticketfields]["extra" . $result[name]], 1);
$fixed_ticket[$result[name]] = $data;
$fixed_ticket["$result[name]_not"] = $_REQUEST['ticketfields'][$result[name].'_not'];
$fixed_ticket["$result[name]_match"] = $_REQUEST['ticketfields'][$result[name].'_match'];
}
// sort out user fields
$db->query("SELECT * from user_def");
while ($result = $db->row_array()) {
$data = field_def_val($result, $_REQUEST[userfields][$result[name]], $_REQUEST[userfields]["extra" . $result[name]], 1);
$fixed_user[$result[name]] = $data;
$fixed_user["$result[name]_not"] = $_REQUEST['userfields'][$result[name].'_not'];
$fixed_user["$result[name]_match"] = $_REQUEST['userfields'][$result[name].'_match'];
}
$fixed_user = serialize($fixed_user);
$fixed_ticket = serialize($fixed_ticket);
$fixed_general = serialize($fixed_general);
$interval = intval($_REQUEST[txtYears]).','.
intval($_REQUEST[txtDays]).','.
intval($_REQUEST[txtHours]).','.
intval($_REQUEST[txtMinutes]);
if ($_REQUEST['do'] == 'newstat2') {
$db->query("INSERT INTO report_stat SET
title = '" . mysql_escape_string($_REQUEST[title]) . "',
description = '" . mysql_escape_string($_REQUEST[description]) . "',
variable1 = '" . mysql_escape_string($_REQUEST[variable1]) . "',
variable2 = '" . mysql_escape_string($_REQUEST[variable2]) . "',
appendix = '" . mysql_escape_string($_REQUEST[appendix]) . "',
dateaffect = '" . mysql_escape_string($_REQUEST[dateaffect]) . "',
displaytype = '" . mysql_escape_string($_REQUEST[displaytype]) . "',
fixed_user = '" . mysql_escape_string($fixed_user) . "',
displayfields = '" . mysql_escape_string($_REQUEST[fields]) . "',
fixed_ticket = '" . mysql_escape_string($fixed_ticket) . "',
fixed_general = '" . mysql_escape_string($fixed_general) . "',
variable1times = '" . mysql_escape_string($interval) . "'
");
$id = $db->last_id();
} else {
$db->query("UPDATE report_stat SET
title = '" . mysql_escape_string($_REQUEST[title]) . "',
description = '" . mysql_escape_string($_REQUEST[description]) . "',
variable1 = '" . mysql_escape_string($_REQUEST[variable1]) . "',
variable2 = '" . mysql_escape_string($_REQUEST[variable2]) . "',
appendix = '" . mysql_escape_string($_REQUEST[appendix]) . "',
dateaffect = '" . mysql_escape_string($_REQUEST[dateaffect]) . "',
displaytype = '" . mysql_escape_string($_REQUEST[displaytype]) . "',
fixed_user = '" . mysql_escape_string($fixed_user) . "',
displayfields = '" . mysql_escape_string($_REQUEST[fields]) . "',
fixed_ticket = '" . mysql_escape_string($fixed_ticket) . "',
fixed_general = '" . mysql_escape_string($fixed_general) . "',
variable1times = '" . mysql_escape_string($interval) . "'
WHERE id = '$id'
");
}
if ($_REQUEST['do'] == 'newstat2') {
jump("reports.php?do=editstat&id=$id", 'New Statistic Created');
} else {
jump("reports.php?do=editstat&id=$id", 'Statistic Updated');
}
}
############################### EDIT / NEW STAT ###############################
if ($_REQUEST['do'] == "editstat" OR $_REQUEST['do'] == "newstat") {
if ($_REQUEST['do'] == 'editstat') {
admin_header('Reports', 'Edit Stat');
} else {
admin_header('Reports', 'New Stat');
}
echo get_javascript('selectBox.js');
if ($_REQUEST['do'] == "editstat") {
$stat = $db->query_return("SELECT * FROM report_stat WHERE id = '$id'");
$fixed_user = unserialize($stat[fixed_user]);
$fixed_general = unserialize($stat[fixed_general]);
$fixed_ticket = unserialize($stat[fixed_ticket]);
}
$db->query("SELECT id, name FROM ticket_cat");
while ($result = $db->row_array()) {
$cat_array[$result[id]] = $result[name];
}
$db->query("SELECT id, name FROM ticket_pri");
while ($result = $db->row_array()) {
$pri_array[$result[id]] = $result[name];
}
$table[] = array('<b>Title</b> ' . ahelp('Reports', 'Title'),
form_input('title', $stat[title])
);
$table[] = array('<b>Description</b> ' . ahelp('Reports', 'Description'),
form_textarea('description', 60, 5, $stat[description])
);
$table[] = array('<b>Display Type</b> ' . ahelp('Reports', 'Display Type'),
form_select('displaytype',
array('data' => 'Data (Show a Table)',
'bar' => 'Bar Graph',
'databar' => 'Table and Bar Graph',
'pie' => 'Pie Chart',
'datapie' => 'Table and Pie Chart',
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -