outsmain
commented
10 years ago - Import data from multiple files are
- sql/SUBS_LOG_ARCH.sql Data in this file are subscribers number log. Changed: add columns are hist_sub_num and service_type
- sql/SUBS_STAT_HIST.sql Data in this file are history of subscribers number
- sql/PORT_TYPE_MAP.sql Data in this file are port_type mapping
- On "Subscriber Report" page add subscriber graph when user click a link on "Node Name" or "Service" column
- Use Flot library to plot graph
- Range of data in this graph are values from between "Start Date" - 6 hours and "End Date" + 6 hours of each row on the table
- Select only data when SUBS_LOG_ARCH.port_state = "UP"
- If user specify parameter "serv" in the URL, filter data only SUBS_LOG_ARCH.service_type = serv
- If user specify multiple parameters "serv", script must use them to select multiple SUBS_LOG_ARCH.service_type too
- There are 2 types of graphs
- When user click on "Node Name" link of each node, display all services for that node
- When user click on "Service" links of each node, display only that service
- X axis label is "Date" use data from SUBS_LOG_ARCH.update_date
- Y axis label is "Subscribers"
- Each data series label is a service name use data mapping from PORT_TYPE_MAP.name, mapping rule is SUBS_LOG_ARCH.port_type = PORT_TYPE_MAP.id
- Each data series value use data from two possible sources
- If SUBS_LOG_ARCH.sub_num is not null use that one, otherwise
- Use data from SUBS_LOG_ARCH.hist_sub_num
- Plot all data with line graph with symbol, one color per service
- Use circle symbol for data from SUBS_LOG_ARCH.sub_num
- Use cross symbol for data from SUBS_LOG_ARCH.hist_sub_num
MrPower-Dev