Support Incident Tracker GIT4.x
billing_matrix.php File Reference

Go to the source code of this file.

Variables

 $permission = PERM_BILLING_DURATION_EDIT
 $title = $strBillingMatrix
 $sql = "SELECT DISTINCT tag FROM `{$dbBillingMatrix}"
 $result = mysql_query($sql)
if(mysql_error())
trigger_error(mysql_error() 
E_USER_WARNING
 if (mysql_num_rows($result) >=1) = "ORDER BY date DESC"

Variable Documentation

Definition at line 15 of file billing_matrix.php.

$result = mysql_query($sql)

Definition at line 30 of file billing_matrix.php.

Referenced by User::add(), Contact::add(), admin_contact_contracts(), all_contact_contracts(), approve_incident_transaction(), authenticate(), authenticateContact(), authenticateSQL(), average_incident_duration(), billable_units_site(), billing_matrix_selector(), calculate_incident_working_time(), close_billable_incident(), closingstatus_drop_down(), cmi_create_table(), cmi_users_roleid(), configure_menu_items_function(), contact_contracts(), contact_count_incidents(), contact_count_inventory_items(), contact_count_open_incidents(), contact_drop_down(), contact_feedback(), contact_notify(), contact_notify_email(), contact_realname(), contact_site(), contact_site_drop_down(), contact_vcard(), contract_balance(), contract_details(), contract_product(), contract_service_table(), contract_site(), contract_software(), contract_transaction_total(), contract_unit_balance(), contracts_for_contacts_table(), count_incident_stats(), count_incidents(), count_incoming_updates(), countdayclosedincidents(), countdaycurrentincidents(), countdayincidents(), create_incident(), create_incident_from_incoming(), create_temp_incoming(), current_schema_version(), customerExistsInDB(), dashboard_holidays(), dashboard_incoming_display(), dashboard_rss_display(), dashboard_rss_edit(), dashboard_rss_install(), dashboard_statistics_display(), dashboard_tasks(), dashboard_tms_backup(), dashboard_user_incidents_display(), dashboard_watch_incidents_display(), dashboard_watch_incidents_edit(), dashboard_watch_incidents_install(), database_schema_version(), db_read_column(), User::disable(), Contact::disable(), display_drafts(), display_holiday_table(), display_update_page(), does_contact_have_billable_contract(), drafts_waiting_on_incident(), draw_file_row(), User::edit(), Contact::edit(), email_templates(), emailtemplate_drop_down(), escalation_path_drop_down(), Trigger::fromID(), generate_row(), get_all_available_multipliers(), get_billable_contract_id(), get_billable_multiplier(), get_contract_balance(), get_globalsignature(), get_incident_billable_breakdown_array(), get_incident_billing_details(), get_incident_transactionid(), get_overdraft(), get_public_holidays(), get_service_balance(), get_service_incidentrate(), get_service_percentage(), get_service_unitrate(), get_serviceid(), get_site_billable_contract_id(), get_tag_id(), get_user_config_vars(), give_overview(), global_signature(), group_user_selector(), guess_contract_id(), incident(), incident_backup_switchover(), incident_drop_down(), incident_firstupdate(), incident_get_next_target(), incident_id_from_subject(), incident_lastupdate(), incident_service_level(), incident_sla(), incident_sla_history(), incident_slaid(), incident_time_since_review(), incidentstatus_drop_down(), incidentstatus_name(), install_dashboard_components(), is_billable_incident_approved(), is_contract_timed(), is_dashlet_installed(), is_day_bank_holiday(), Contact::is_duplicate(), is_kb_article(), is_transaction_approved(), journal(), kb_article(), kb_name(), ldap_storeDetails(), ldapImportCustomerFromEmail(), licence_type_drop_down(), list_incidents(), list_tag_icons(), list_tags(), login(), maintenance_drop_down(), maintenance_servicelevel_tag(), maintid_from_transaction(), make_incident_billing_array(), new_tag(), new_update(), num_unread_emails(), number_of_slas(), open_activities_for_incident(), open_activities_for_site(), portal_incident_table(), postpone_task(), process_new_contact(), product_drop_down(), purge_tag(), purge_tags(), readable_last_updates(), reassign_incident(), remove_tag(), reopen_incident(), replace_tags(), reseller_drop_down(), reserve_monies(), User::retrieveDetails(), Group::retrieveDetails(), role_drop_down(), saction_ChaseCustomers(), saction_CheckTasksDue(), saction_CheckWaitingEmail(), saction_CloseIncidents(), saction_ldapSync(), saction_PurgeExpiredFTPItems(), saction_PurgeJournal(), saction_SetUserStatus(), saction_TimeCalc(), saction_tms_backup(), saction_tms_backup_purge(), schedule_actions_due(), service_dropdown_contract(), service_dropdown_site(), service_transaction_total(), servicelevel_drop_down(), servicelevel_maxpriority(), servicelevel_timed(), serviceleveltag_drop_down(), set_user_status(), setup_check_adminuser(), setup_createdb(), show_create_links(), show_dashboard_component(), show_links(), show_notes(), show_tag_cloud(), site_count_incidents(), site_count_inventory_items(), site_drop_down(), site_feedback(), sitetype_drop_down(), skill_drop_down(), sla_target_content(), software_backup_dropdown(), software_backup_userid(), software_name(), softwareproduct_drop_down(), suggest_reassign_userid(), supported_contacts(), template_description(), tms_backup_save(), transactions_report(), trigger_to_html(), TriggerEvent::TriggerEvent(), update(), update_contract_balance(), upgrade_dashlets(), upload_file(), user_activeincidents(), user_count_holidays(), user_countincidents(), user_drop_down(), user_group_id(), user_holiday(), user_id(), user_incidents(), user_online(), user_online_icon(), user_realname(), userstatus_bardrop_down(), userstatus_drop_down(), valid_username(), and vendor_drop_down().

$sql = "SELECT DISTINCT tag FROM `{$dbBillingMatrix}"

Definition at line 29 of file billing_matrix.php.

Referenced by User::add(), Trigger::add(), Contact::add(), admin_contact_contracts(), all_contact_contracts(), approve_incident_transaction(), authenticate(), authenticateContact(), authenticateSQL(), average_incident_duration(), billable_units_site(), billing_matrix_selector(), book_appointment(), calculate_incident_working_time(), cfgSave(), close_billable_incident(), closingstatus_drop_down(), cmi_create_table(), cmi_users_roleid(), configure_menu_items_function(), contact_contracts(), contact_count_incidents(), contact_count_inventory_items(), contact_count_open_incidents(), contact_drop_down(), contact_feedback(), contact_notify(), contact_notify_email(), contact_realname(), contact_site(), contact_site_drop_down(), contact_vcard(), contract_balance(), contract_details(), contract_product(), contract_service_table(), contract_site(), contract_software(), contract_transaction_total(), contract_unit_balance(), contracts_for_contacts_table(), count_incident_stats(), count_incidents(), count_incoming_updates(), countdayclosedincidents(), countdaycurrentincidents(), countdayincidents(), create_admin_user(), create_incident(), create_incident_feedback(), create_incident_from_incoming(), create_temp_incoming(), current_schema_version(), customerExistsInDB(), dashboard_holidays(), dashboard_incoming_display(), dashboard_rss_display(), dashboard_rss_edit(), dashboard_statistics_display(), dashboard_tasks(), dashboard_tms_backup(), dashboard_user_incidents_display(), dashboard_watch_incidents_display(), dashboard_watch_incidents_edit(), database_schema_version(), db_read_column(), decrement_free_incidents(), delete_holding_queue_update(), delete_signature(), User::disable(), Contact::disable(), display_update_page(), does_contact_have_billable_contract(), drafts_waiting_on_incident(), draw_file_row(), User::edit(), Trigger::edit(), Contact::edit(), email_templates(), emailtemplate_drop_down(), escalation_path_drop_down(), Trigger::fromID(), generate_row(), get_all_available_multipliers(), get_billable_contract_id(), get_billable_multiplier(), get_contract_balance(), get_globalsignature(), get_incident_billable_breakdown_array(), get_incident_billing_details(), get_incident_transactionid(), get_overdraft(), get_public_holidays(), get_service_balance(), get_service_incidentrate(), get_service_percentage(), get_service_unitrate(), get_serviceid(), get_site_billable_contract_id(), get_sql_statement(), get_tag_id(), get_user_config_vars(), get_users_appointments(), give_overview(), global_signature(), group_user_selector(), guess_contract_id(), incident(), incident_backup_switchover(), incident_drop_down(), incident_firstupdate(), incident_get_next_target(), incident_id_from_subject(), incident_lastupdate(), incident_service_level(), incident_sla(), incident_sla_history(), incident_slaid(), incident_time_since_review(), incidentstatus_drop_down(), incidentstatus_name(), increment_incidents_used(), install_dashboard_components(), is_billable_incident_approved(), is_contract_timed(), is_dashlet_installed(), is_day_bank_holiday(), Contact::is_duplicate(), is_kb_article(), is_transaction_approved(), journal(), kb_article(), kb_name(), ldapImportCustomerFromEmail(), licence_type_drop_down(), list_incidents(), list_tag_icons(), list_tags(), load_entitlements(), login(), maintenance_drop_down(), maintenance_servicelevel_tag(), maintid_from_transaction(), make_incident_billing_array(), mark_task_completed(), move_update_to_incident(), new_tag(), new_update(), notice_templates(), num_unread_emails(), number_of_slas(), open_activities_for_incident(), open_activities_for_site(), portal_incident_table(), postpone_task(), process_new_contact(), product_drop_down(), purge_tag(), purge_tags(), readable_last_updates(), reassign_incident(), remove_tag(), reopen_incident(), replace_tags(), reseller_drop_down(), reserve_monies(), User::retrieveDetails(), Group::retrieveDetails(), role_drop_down(), saction_ChaseCustomers(), saction_CheckTasksDue(), saction_CheckWaitingEmail(), saction_CloseIncidents(), saction_ldapSync(), saction_PurgeExpiredFTPItems(), saction_PurgeJournal(), saction_SetUserStatus(), saction_TimeCalc(), saction_tms_backup(), saction_tms_backup_purge(), schedule_action_done(), schedule_action_started(), schedule_actions_due(), service_dropdown_contract(), service_dropdown_site(), service_transaction_total(), servicelevel_drop_down(), servicelevel_maxpriority(), servicelevel_timed(), serviceleveltag_drop_down(), set_user_status(), setup_check_adminuser(), setup_createdb(), setup_exec_sql(), setup_user_triggers(), show_create_links(), show_dashboard_component(), show_edit_site(), show_links(), show_notes(), show_tag_cloud(), site_count_incidents(), site_count_inventory_items(), site_drop_down(), site_feedback(), sitetype_drop_down(), skill_drop_down(), sla_target_content(), software_backup_dropdown(), software_backup_userid(), software_name(), softwareproduct_drop_down(), suggest_reassign_userid(), supported_contacts(), template_description(), tms_backup_save(), transactions_report(), transition_reserved_monites(), trigger_to_html(), TriggerEvent::TriggerEvent(), unreserve_monies(), update(), update_contract_balance(), update_last_billed_time(), update_sit_version_number(), update_transaction(), upgrade_dashlets(), upload_file(), user_activeincidents(), user_count_holidays(), user_countincidents(), user_drop_down(), user_group_id(), user_holiday(), user_id(), user_incidents(), user_online(), user_online_icon(), user_realname(), userstatus_bardrop_down(), userstatus_drop_down(), valid_username(), and vendor_drop_down().

$title = $strBillingMatrix

Definition at line 20 of file billing_matrix.php.

if (mysql_error()) trigger_error(mysql_error() E_USER_WARNING

Definition at line 31 of file billing_matrix.php.

Referenced by User::add(), Trigger::add(), admin_contact_contracts(), approve_incident_transaction(), authenticate(), authenticateContact(), authenticateSQL(), average_incident_duration(), billable_units_site(), billing_matrix_selector(), calculate_incident_working_time(), cfgSave(), check_group_holiday(), clean_fixed_list(), clean_float(), clean_int(), close_billable_incident(), closingstatus_drop_down(), cmi_check_column_exists(), cmi_create_table(), cmi_recreate_table(), cmi_users_roleid(), configure_menu_items_function(), contact_count_incidents(), contact_count_inventory_items(), contact_count_open_incidents(), contact_drop_down(), contact_feedback(), contact_notify(), contact_notify_email(), contact_realname(), contact_site(), contact_site_drop_down(), contact_vcard(), contract_balance(), contract_details(), contract_service_table(), contract_transaction_total(), contract_unit_balance(), contracts_for_contacts_table(), count_incident_stats(), count_incidents(), create_admin_user(), create_ftp_connection(), current_schema_version(), dashboard_holidays(), dashboard_incoming_display(), dashboard_random_tip_display(), dashboard_rss_display(), dashboard_rss_edit(), dashboard_rss_install(), dashboard_statistics_display(), dashboard_tasks(), dashboard_tms_backup(), dashboard_user_incidents_display(), dashboard_watch_incidents_display(), dashboard_watch_incidents_edit(), database_schema_version(), db_read_column(), debug_log(), delete_holding_queue_update(), User::disable(), Contact::disable(), display_update_page(), does_contact_have_billable_contract(), does_site_have_certain_sla_contract(), draw_chart(), User::edit(), Trigger::edit(), Contact::edit(), email_templates(), emailtemplate_drop_down(), escalation_path_drop_down(), fetch_rss(), Trigger::fire(), format_external_id(), Trigger::fromID(), generate_row(), get_all_available_multipliers(), get_billable_contract_id(), get_billable_multiplier(), get_contract_balance(), get_globalsignature(), get_incident_billable_breakdown_array(), get_incident_billing_details(), get_incident_transactionid(), get_overdraft(), get_public_holidays(), get_service_balance(), get_service_incidentrate(), get_service_percentage(), get_service_unitrate(), get_serviceid(), get_site_billable_contract_id(), get_tag_id(), give_overview(), group_selector(), group_user_selector(), icon(), incident_backup_switchover(), incident_drop_down(), incident_firstupdate(), incident_get_next_target(), incident_lastupdate(), incident_maintid(), incident_service_level(), incident_sla_history(), incident_time_since_review(), incidentstatus_drop_down(), incidentstatus_name(), install_dashboard_components(), is_billable_incident_approved(), is_contract_timed(), is_dashlet_installed(), is_kb_article(), is_transaction_approved(), journal(), kb_article(), kb_name(), ldapImportCustomerFromEmail(), ldapOpen(), list_incidents(), list_tag_icons(), list_tags(), load_entitlements(), login(), maintenance_servicelevel_tag(), maintid_from_transaction(), make_incident_billing_array(), notice_templates(), num_unread_emails(), number_of_slas(), open_activities_for_incident(), portal_incident_table(), postpone_task(), process_new_contact(), product_drop_down(), purge_tags(), reassign_incident(), rec_copy(), replace_vars(), reseller_drop_down(), reserve_monies(), User::retrieveDetails(), Group::retrieveDetails(), role_drop_down(), saction_ChaseCustomers(), saction_CheckWaitingEmail(), saction_CloseIncidents(), saction_ldapSync(), saction_PurgeExpiredFTPItems(), saction_PurgeJournal(), saction_SetUserStatus(), saction_TimeCalc(), saction_tms_backup_purge(), schedule_actions_due(), send_email(), send_email_template(), service_dropdown_contract(), service_dropdown_site(), service_transaction_total(), servicelevel_maxpriority(), servicelevel_timed(), show_create_links(), show_dashboard_component(), show_edit_site(), show_links(), show_notes(), show_tag_cloud(), sit_error_handler(), site_count_incidents(), site_count_inventory_items(), site_feedback(), sitetype_drop_down(), skill_drop_down(), sla_target_content(), software_backup_dropdown(), software_backup_userid(), softwareproduct_drop_down(), suggest_reassign_userid(), supported_contacts(), tms_backup_save(), transactions_report(), trigger_to_html(), TriggerEvent::TriggerEvent(), upgrade_dashlets(), upload_file(), user_activeincidents(), user_alert(), user_count_holidays(), user_countincidents(), user_drop_down(), user_group_id(), user_holiday(), user_id(), user_incidents(), user_online(), user_online_icon(), user_realname(), userstatus_bardrop_down(), userstatus_drop_down(), and vendor_drop_down().

if = "ORDER BY date DESC"

Unassigned Incidents queue This special queue shows a list of incidents that are currently not assigned to any engineer. This could happen if a user goes on holiday but has no substitutes defined. Spam queue This special queue shows a list of incoming spam

Definition at line 33 of file billing_matrix.php.