Please Note:
Quarter | MPS Upgrades | Seton Upgrades | St. Joseph Academy Upgrades | Veritas Upgrades | Total Cards | Upgraded Cards |
---|---|---|---|---|---|---|
" & upg.Fields("quarter") & " | " & upg.Fields("mps") & " | " & upg.Fields("seton") & " | " & upg.Fields("sja") & " | " & upg.Fields("veritas") & " | " & upg.Fields("total_cards") & " | " & upg.Fields("upgraded_cards") & " |
No data found for Upgrades by Branch, please check later...
" rs5.Close set rs5 = nothing Else chart5.loadArray rs5.getRows() chart5.draw rs5.Close set rs5 = nothing End If Set upgb_cmd = Server.CreateObject("ADODB.Command") upgb_cmd.ActiveConnection = MM_MPL_STRING upgb_cmd.CommandText = "SELECT * FROM upgrades_branch WHERE quarter = CAST(CONCAT(EXTRACT(YEAR from now() - interval 1 quarter),'-',EXTRACT(QUARTER FROM NOW() - INTERVAL 1 quarter)) as CHAR(50))" upgb_cmd.Prepared = true Set upgb = upgb_cmd.Execute Response.Write"Quarter | Branch | Upgrades |
---|---|---|
" & upgb.Fields("quarter") & " | " & upgb.Fields("branch") & " | " & upgb.Fields("count") & " |
Quarter | Digital Cards with MBLOCKS | Upgraded Cards with MBLOCKS | Upgraded Cards with Fines > $5 | Digital Cards Blocked Total | Upgraded Cards Blocked Total | Upgraded Cards Unblocked Total |
---|---|---|---|---|---|---|
" & bl.Fields("quarter") & " | " & bl.Fields("reg_mblocks") & " | " & bl.Fields("upgraded_mblocks") & " | " & bl.Fields("upgraded_fines_over_5") & " | " & bl.Fields("reg_blocked") & " | " & bl.Fields("upgraded_blocked") & " | " & bl.Fields("upgraded_unblocked") & " |
<%=Server.HTMLEncode(fld.Name)%> | <%Next%>
---|
<%=Server.HTMLEncode(fld.Name)%> | <%Next%>
---|
No data found for Educator upgrades, please check later...
" rs4.Close set rs4 = nothing Else chart4.loadArray rs4.getRows() chart4.draw rs4.Close set rs4 = nothing End If Set upge_cmd = Server.CreateObject("ADODB.Command") upge_cmd.ActiveConnection = MM_MPL_STRING upge_cmd.CommandText = "SELECT * FROM educator_upgrades" upge_cmd.Prepared = true Set upge = upge_cmd.Execute Response.Write"Quarter | Total Cards | Upgraded Cards |
---|---|---|
" & upge.Fields("quarter") & " | " & upge.Fields("total_cards") & " | " & upge.Fields("upgraded_cards") & " |