}
Add_Item("My List", "mylist.php");
Add_Item("Open Tickets", "list.php");
Add_Item("Ticket Lookup (by ID)", "lookup.php");
Add_Item("New Ticket", "new.php");
Add_Item("Search Ticket", "search.php");
Add_ItemRed("Check User", "check_user.php");
if (IsKarnafAdminSession()) {
Add_Itemx("Edit types", "mng_cat.php?table=cat1");
Add_Itemx("Edit catagories", "mng_cat.php?table=cat2");
Add_Itemx("Edit subjects", "mng_cat.php?table=cat3");
Add_Itemx("Edit templates", "mng_templates.php");
Add_Itemx("View Logs", "mng_viewlogs.php");
Add_Itemx("Edit SQL", "mng_editsql.php");
Add_Itemx("Stats", "stats.php");
Add_Item("Logout", "logout.php");
}
?>
<tr><td>
<br>
<u>Tickets:</u>
<br>
<?php
$tickets = 0;
$query = squery("SELECT count(*) FROM karnaf_tickets");
if ($result = sql_fetch_array($query)) {
$tickets = $result[0];
}
sql_free_result($query);
echo $tickets;
?>
function Module_JSON($db)
{
$report_id = Functions::Post_Int('report_id');
$project_id = Functions::Post_Int('project_id');
$action = Functions::Post('action');
$date_input = Functions::Post('date');
$employee_id = Functions::Post_Int('employee_id');
$hours = Functions::Post('time');
$description = Functions::Post('description');
$billable = Functions::Post_Active('billable');
$custom_rate = Functions::Post_Active('custom_rate');
if (!Functions::Report_Load($db, $report_id, $loaded_report)) {
return JSON_Response_Error('#Error#', 'Report not found');
}
if (!Functions::Project_Load($db, $project_id, $loaded_project)) {
return JSON_Response_Error('#Error#', 'Project not found');
}
if (!Functions::ReportProject_Load_ReportProject($db, $report_id, $project_id, $loaded_report_project)) {
return JSON_Response_Error('#Error#', 'Report project not found');
}
if ($custom_rate === 1 && $loaded_report_project['custom_rate_id'] === 1) {
return JSON_Response_Error('#Error#', 'You cannot set this item to have a custom rate, until you select a custom rate type');
}
if ($date_input == '') {
return JSON_Response_Error('#Error#', 'Please select a date');
}
$item_date = new DateTime($date_input);
$date_from = new DateTime($loaded_report['date_from']);
$date_to = new DateTime($loaded_report['date_to']);
if ($item_date < $date_from || $item_date > $date_to) {
return JSON_Response_Error('#Error#', 'The date range of the item does not fall within the date range of the report');
}
if (!is_numeric($hours) || $hours < 0) {
return JSON_Response_Error('#Error#', 'Hours must be positive');
}
if ($description == '') {
return JSON_Response_Error('#Error#', 'Description cannot be blank');
}
switch ($employee_id) {
case 0:
// fee
$type = 1;
$employee_id = 0;
$hours = number_format($hours, 2);
break;
case 1:
// credit - web
$type = 2;
$employee_id = 0;
$hours = Functions::format_hour($hours);
break;
case 2:
// credit - junior
$type = 3;
$employee_id = 0;
$hours = Functions::format_hour($hours);
break;
case 3:
// credit - cust
$type = 4;
$employee_id = 0;
$hours = Functions::format_hour($hours);
break;
default:
$type = 0;
$hours = Functions::format_hour($hours);
break;
}
if ($type == 0 && !Functions::Employee_Load($db, $employee_id, $null)) {
return JSON_Response_Error('#Error#', 'Employee could not be found');
}
if ($action === 'add') {
return Add_Item($db, $type, $date_input, $employee_id, $hours, $description, $billable, $custom_rate, $loaded_report_project['id']);
} else {
if ($action === 'update') {
return Update_Item($db, $type, $date_input, $employee_id, $hours, $description, $billable, $custom_rate);
}
}
return JSON_Response_Error('#Error#', 'Invalid action');
}
