Login/Create account
Donate
checkout
view cart (
0
)Login/Create account
Donate
checkoutview cart (
0
)
© 2000-2021, Osher Lifelong Learning Institute, College of Social Sciences, UHM. All rights reserved.
|
Debugging Information
Execution Time
SQL Queries checkAccessControlRules (Datasource=LumensCustomers, Time=15ms, Records=8) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 14:22:04.004SELECT DISTINCT ACA.int_actor_type_id FROM tbl_access_control_rules ACR INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id WHERE str_fuse_action LIKE ? AND ISNULL(ACA.int_actor_type_id,'')<>'' AND ACA.bit_allow = 1 Query Parameter Value(s) -FeatureConfigurationQry (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\FeatureConfigurationQry.cfm @ 14:22:04.004SET NOCOUNT ON
DECLARE @UsesRefundRequest CHAR(1)
SET @UsesRefundRequest = 0
SET @UsesRefundRequest = (
SELECT 1
FROM RefundPaymentMethods
WHERE RefundPaymentMethodID = 7
AND STATUS = 'A'
)
SELECT TOP 1 rg.RegionID
, rg.NAME
, rg.Address1
, rg.Address2
, rtrim(rg.City) + ', ' + rg.STATE + ' ' + rg.Zip AS CSZ
, rg.Phone1
, rg.SiteTitle
, rg.Footer
/**/
, rg.prefooter
, rg.brandingfooter
/**/
, rg.MetaText
, rg.EmailAux4
, IsNull((
SELECT Fee
FROM Products
WHERE Code = 'REGFEE'
AND STATUS = 'A'
AND RegionID = rg.RegionID
), 0.00) AS RegistrationFee
, IsNull((
SELECT Fee
FROM Products
WHERE Code = 'DEFERRED_PAYMENT_FEE'
AND STATUS = 'A'
AND RegionID = rg.RegionID
), 0.00) AS deferred_payment_fee
, fc.*
, @UsesRefundRequest AS UsesRefundRequest
, rg.privacy_data_mask_id
, rg.str_google_verify
, rg.str_yahoo_verify
, rg.str_hubspot_portal_id
, rg.str_hubspot_salog_version
, rg.str_hubspot_ppa
, rg.str_genoo_api_key
, rg.str_genoo_tracking_code
, rg.TimeZoneHourAdjustment
/**/
/**/
/**/
, e.str_erp_name
/**/
/**/
, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
/**/
/**/
, rg.theURL
, rg.URLText
, rg.str_analytics_linked_domains
, rg.GTMContainerID
, rg.str_social_media_sharing
, ec.*
, (
SELECT TOP 1 Description
FROM PaymentMethods
WHERE PaymentMethodID >= 200
AND STATUS = 'A'
) AS str_internal_payment_method_name
FROM FeatureConfiguration fc
INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
WHERE rg.STATUS = 'A'
qryGetRegion (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\globalVariables.cfm @ 14:22:04.004SELECT regionId,orgID FROM featureConfigurationQry WHERE baseurl LIKE '%v8testing7.augusoft.net%' MenuQry (Datasource=v8Testing7, Time=0ms, Records=12) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 14:22:04.004SET NOCOUNT ON SELECT OrgID , RegionID , MenuItemID , MenuItemType , MainLevel , SubLevel ,MainLevelSortOrder , SubLevelSortOrder , SiteURL , AccessLevel , IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1 , IsNull(DisplayValue_1, '') AS DisplayValue_1 , IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2 , IsNull(DisplayValue_2, '') AS DisplayValue_2 , Condition , LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName , m.Label AS UniqueLable , CASE WHEN str_user_nav_label IS NULL THEN CASE WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9440' THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership') WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9620' THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member') /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'Donate' THEN Replace(m.Label, 'Donate', 'Support OLLI-UHM') /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'MERCHANDISE' THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise') WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships' THEN Replace(m.Label, 'Scholarships', 'Scholarship') ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"') END ELSE /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ CASE WHEN str_menu_label LIKE 'Donate' THEN (str_user_nav_label) ELSE str_user_nav_label END /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ END AS Label , CASE WHEN str_user_nav_label IS NULL THEN CASE WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9440' THEN Replace(m.Label, 'Membership', 'Membership') WHEN MenuItemType != 'Lnk' AND SiteURL = 'index.cfm?fuseaction=9620' THEN Replace(m.Label, 'Member', 'Member') /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'Donate' THEN Replace(m.Label, 'Donate', 'Support OLLI-UHM') /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ WHEN m.Label LIKE 'MERCHANDISE' THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise') WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships' THEN Replace(m.Label, 'Scholarships', 'Scholarship') ELSE m.Label END ELSE /*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */ CASE WHEN str_menu_label LIKE 'Donate' THEN dbo.fun_strip_html((str_user_nav_label)) ELSE dbo.fun_strip_html(str_user_nav_label) END /*END NEO 00106 20 FEB 2015 Student Donations UC-02 */ END AS LabelNoHTML , ISNULL(int_parent_id,0) as int_parent_id , int_sort_order , m.UniqueLabel , m.bit_default_behavior FROM MenuItems m LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id WHERE STATUS = 'A' AND SubCategoryID IS NULL AND ( int_actor_type_id = ? OR ( int_actor_type_id IS NULL AND AccessLevel = ? ) ) AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/ ORDER BY int_sort_order Query Parameter Value(s) -qGetDashboardName (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 14:22:04.004SET ANSI_NULLS ON SELECT IsNull(( CASE WHEN str_dashboard_name = '' THEN NULL ELSE str_dashboard_name END ), CASE WHEN ActorTypeID = 55 THEN 'Dashboard' ELSE 'my dashboard' END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */ FROM ActorTypes WHERE ActorTypeID = ? Query Parameter Value(s) -qLearnerfields (Datasource=v8Testing7, Time=0ms, Records=114) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:22:04.004SELECT pfo.int_order
, pf.str_field_display_name
, pf.str_field_name
, pfo.int_profile_field_tab_id
, pf.str_actor_types
, pf.chr_field_type
FROM tbl_profile_field_order pfo
INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
WHERE pf.int_region_id = ?
AND bit_enabled = ?
AND
(
(
pf.chr_field_type not in ('C','O')
)
OR
(
pf.chr_field_type in ('C','O') AND
(
pf.str_actor_types LIKE ?
)
)
)
ORDER BY pfo.int_profile_field_tab_id
, pfo.int_order ASC
Query Parameter Value(s) -qsocialNetFieldDetails (Datasource=v8Testing7, Time=0ms, Records=4) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:22:04.004select * from tbl_social_media_details WHERE int_region_id = ? order by int_order asc Query Parameter Value(s) -qGraphics (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:22:04.004select * from UIVariables where RegionID = ? Query Parameter Value(s) -qUserNavItems (Datasource=v8Testing7, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:22:04.004SELECT menitms.SiteURL AS nav_site_url , menitms.label AS nav_label , menitms.rowNum , COUNT(menitms.rowNum) OVER () AS Total_Rows , menitms.DisplayCriteria_1 , menitms.DisplayValue_1 , menitms.DisplayCriteria_2 , menitms.DisplayValue_2 , menitms.Condition , menitms.NewWindowName FROM ( SELECT SiteURL , label , DisplayCriteria_1 , DisplayValue_1 , DisplayCriteria_2 , DisplayValue_2 , Condition , Row_Number() OVER ( ORDER BY MenuitemID ASC ) AS rowNum , NewWindowName FROM MenuItems WHERE AccessLevel = ? AND RegionID = ? AND bit_display_in_nav=1 AND STATUS = ? ) menitms Query Parameter Value(s) -qFooterNavItems (Datasource=v8Testing7, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:22:04.004SELECT menitms.SiteURL , menitms.label , menitms.AccessLevel , menitms.rowNum , ((rowNum - 1) / 4) + 1 AS block , menitms.DisplayCriteria_1 , menitms.DisplayValue_1 , menitms.DisplayCriteria_2 , menitms.DisplayValue_2 , menitms.Condition , menitms.NewWindowName FROM ( SELECT SiteURL , label , AccessLevel , DisplayCriteria_1 , DisplayValue_1 , DisplayCriteria_2 , DisplayValue_2 , Condition , Row_Number() OVER ( ORDER BY MenuitemID ASC ) AS rowNum , NewWindowName FROM MenuItems WHERE AccessLevel = ? AND RegionID = ? AND bit_display_in_footer=1 AND STATUS = ? ) menitms Query Parameter Value(s) -qUser (Datasource=v8Testing7, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:22:04.004DECLARE @currentTime DATETIME2 = ? UPDATE tbl_cart_class_detail SET EnteredDate = @currentTime WHERE SessionID = ?; UPDATE tbl_cart_merchandise_detail SET EnteredDate = @currentTime WHERE SessionID = ?; Query Parameter Value(s) -qUser (Datasource=v8Testing7, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:22:04.004DECLARE @expireRequestsAfter DATETIME2 = ?; DELETE FROM tbl_cart_class_detail WHERE EnteredDate <= @expireRequestsAfter; DELETE FROM tbl_cart_merchandise_detail WHERE EnteredDate <= @expireRequestsAfter; Query Parameter Value(s) -variables.custom_scripts (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:22:04.004SELECT str_header_script , str_footer_script FROM tbl_style_settings WITH (NOLOCK) -- WHERE int_region_id = Commented as long as multiple regions are not there qGraphics (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:22:04.004select * from UIVariables where RegionID = ? Query Parameter Value(s) -qTempMenu (Datasource=, Time=0ms, Records=11) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 14:22:04.004select * from qTempMenu where MenuItemID NOT IN (510) qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 14:22:04.004select * from qSocialMedia order by int_order desc qGetDonateUserNavLabel (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:22:04.004SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) -qGetDonateUserNavLabel (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:22:04.004SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) -qGetDonateUserNavLabel (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:22:04.004SELECT isNull(str_user_nav_label,'') AS str_menu_label FROM tbl_user_nav_menu_label WHERE int_actor_type_id = ? AND str_menu_label LIKE 'DONATE' AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1'; Query Parameter Value(s) -qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) -qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) -qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) -qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 597 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 525 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 598 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 595 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 596 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 503 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 2 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 5 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 6 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:22:04.004select * from qMenu where int_parent_id = 7 qGetOrganisationPhoneQry (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004SET NOCOUNT ON SELECT rg.Phone1, rg.Phone1Ext FROM Regions rg WHERE rg.RegionID = 1 AND rg.Status = 'A' q (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004DECLARE @TimeZoneShift as float;
Set @TimeZoneShift = IsNull((select TimeZoneHourAdjustment from Regions where RegionID = 1),0)
SELECT
CL.*
,cst.str_course_series_type_name
,csg.SeriesGroupMatFeeAdv
,csg.int_category_id
FROM tbl_class_listing CL
INNER JOIN CourseSeriesGroups CSG ON CSG.SeriesGroupID = CL.int_course_series_group_id
INNER JOIN tbl_course_series_type cst ON cst.int_course_series_type_id = CSG.int_course_series_type_id
WHERE
CL.str_class_type = 'cs'
AND CL.int_course_series_group_id = ?
AND
DateAdd(hh, @TimeZoneShift, dbo.fun_GetDateCT()) BETWEEN cl.AppearanceStartDate AND DateAdd(ms, -10, CAST(CL.AppearanceEndDate as datetime))
AND (SELECT COUNT(clR.classid) FROM tbl_class_course_series_group cgR INNER JOIN Classes clR ON clR.classid = cgR.int_class_id WHERE cgR.int_series_group_id = ? AND clR.status in ('R','X')) = 0
AND CSG.bit_disp_cs_to_public = 1
Query Parameter Value(s) -qGetCourseSeriesType (Datasource=v8Testing7, Time=16ms, Records=3) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004SELECT * FROM tbl_course_series_type WHERE chr_status='A' qGetClassListingOrder (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004select str_class_listing_order from tbl_class_listing_order qryGetCourseSeriesDetails (Datasource=v8Testing7, Time=15ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004SELECT
Cl.*, (select str_contact_phone FROM CourseSeries WHERE CourseSeries.CourseSeriesID=CL.int_course_series_id) as contactPhone
,cst.str_course_series_type_name as CourseSeriesType
,csg.SeriesGroupMatFeeAdv
,cs.bit_info_request
,cs.str_info_request_email
,CSG.Seriesgroupid AS CourseSeriesGroupID
,CS.SeriesTuitionFee
,csg.bit_requires_release_form
,csg.str_default_text_for_call_message_class
FROM tbl_class_listing CL
INNER JOIN CourseSeriesGroups CSG ON CSG.SeriesGroupID = CL.int_course_series_group_id
INNER JOIN tbl_course_series_type cst ON cst.int_course_series_type_id = CSG.int_course_series_type_id
INNER JOIN CourseSeries cs on cs.CourseSeriesID = csg.CourseSeriesID
WHERE CL.int_course_series_group_id=?
AND CL.str_class_type='CS'
AND cs.bit_disp_cs_to_public = 1
AND CSG.bit_disp_cs_to_public = 1
Query Parameter Value(s) -qryGetClassInformation (Datasource=v8Testing7, Time=64ms, Records=2) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:04.004SELECT
cl.Name as ClassName,
cl.CourseID,
cl.ClassID,
CASE WHEN co.int_schedule_type_id=2 THEN
CASE WHEN MIN(Cl.dat_public_registration_begin) < MIN(cl.dat_staff_registration_begin)
THEN MIN(Cl.dat_public_registration_begin)
ELSE MIN(cl.dat_staff_registration_begin)
END
ELSE
cl.StartDate
END AS StartDate,
isnull(cl.RemainingSeats,0) as RemainingSeats,
isnull(cl.PublicRegistration,0) as PublicRegistration,
cl.dat_public_registration_begin,
(SELECT Min(c.dat_public_registration_closes) FROM classes c
inner join tbl_class_course_series_group t on t.int_class_id = c.classid
where t.int_Series_group_id = ccsg.int_Series_group_id) AS dat_public_registration_closes,
cl.dat_staff_registration_begin,
(select FeatureConfiguration.UsesWaitingLists from FeatureConfiguration) as UsesWaitingLists,
(SELECT (
SELECT Location = Stuff((
SELECT ', ' + Name AS [text()]
FROM (
SELECT DISTINCT l.name AS Name
FROM tbl_ClassSchedules cls
LEFT JOIN locations l ON cls.int_location_id = l.locationid
WHERE cls.classid = cl.classid
) x
FOR XML PATH('')
), 1, 1, '')
)
) AS Location,
L.locationID,
co.CourseID,
co.coursenumber,
isnull(cl.TotalSeats,0) as TotalSeats,
IsNull((select count(registrationId) FROM Registrations WHERE classID = cl.classid AND IsCancelled = 0),0) AS TotalRegs,
IsNull((SELECT sum(int_reserved_seats) FROM tbl_class_course_series_group WHERE int_class_ID = cl.classID AND int_series_group_id =ccsg.int_series_group_id),0) AS ReservedSeats,
IsNull((SELECT sum(int_reserved_seats) FROM tbl_class_course_series_group WHERE int_class_ID = cl.classID AND int_series_group_id !=ccsg.int_series_group_id),0) AS OtherSeriesReservedSeats,
IsNull((SELECT count(registrationid) FROM registrations WHERE classid = cl.classid AND iscancelled =0 AND (int_series_group_id =0 OR int_series_group_id is null)),0) As NonSeriesRegs,
IsNull((SELECT count(registrationid) FROM registrations WHERE classid = cl.classid AND iscancelled =0 AND int_series_group_id = ccsg.int_series_group_id),0) As SeriesRegs,
IsNull((SELECT count(registrationid) FROM registrations WHERE classid = cl.classid AND iscancelled =0 AND int_series_group_id >0 AND int_series_group_id !=ccsg.int_series_group_id),0) As OtherSeriesRegs,
(select count(RegistrationID) from registrations where classID= ccsg.int_class_id and IsCancelled =0 and isnull(int_series_group_id,0) != ccsg.int_Series_group_id) as FilledSeats,
isnull(ccsg.int_reserved_seats,0) as int_reserved_seats,
isnull(ccsg.int_remaining_seats,0) as int_remaining_seats,
(select count(RegistrationID) from registrations where classID= ccsg.int_class_id and IsCancelled =0 and int_series_group_id = ccsg.int_Series_group_id) as SeriesFilledSeats
,isnull((select sum(ISNULL(int_reserved_seats,0)) from tbl_certificates_classes tcc where tcc.int_class_id = cl.ClassID),0) AS int_certificate_reserved_seats
,isnull((select sum(ISNULL(int_remaining_seats,0)) from tbl_certificates_classes tcc where tcc.int_class_id = cl.ClassID),0) AS int_certificate_remaining_seats
,(SELECT count(isnull(registrationid,0)) FROM registrations WHERE classid = cl.classid AND iscancelled =0 AND int_certificate_id > 0) As int_certificate_regs,
cdr.str_schedule_display_list as ClassSchedule
,(SELECT count(LearnerID) FROM WaitingListEntries wle
INNER JOIN waitinglists wl on wl.WaitListID=wle.WaitListID
Where wl.int_course_series_group_id = ccsg.int_Series_group_id) WiatingListStudents
,0 as Enrolled
,cl.Status
FROM Classes cl
LEFT JOIN tbl_class_detail_report cdr ON cdr.int_class_id=cl.ClassID
LEFT JOIN Locations L ON cl.LocationID= L.LocationID
INNER JOIN courses co ON cl.courseID = co.CourseID
INNER JOIN tbl_class_course_series_group ccsg ON cl.classID= ccsg.int_class_id
WHERE
ccsg.int_Series_group_id=?
and cl.status IN ('A','C')
GROUP BY
cl.Name,
cl.CourseID,
cl.ClassID,
co.int_schedule_type_id,
cl.RemainingSeats,
cdr.str_schedule_display_list,
cl.PublicRegistration,
cl.dat_public_registration_begin,
cl.dat_staff_registration_begin,
cl.dat_public_registration_closes,
l.Name,l.LocationID,co.CourseID,co.CourseNumber,cl.TotalSeats,
ccsg.int_Series_group_id,ccsg.int_class_id,ccsg.int_reserved_seats,ccsg.int_remaining_seats,
cl.StartDate
,cl.Status
ORDER BY cl.Name ASC,cl.StartDate DESC
Query Parameter Value(s) -qryGetCountofCourseSeriesReg (Datasource=v8Testing7, Time=3ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:05.005SELECT COUNT(RegistrationID) as CountofCourseSeriesReg
FROM Registrations
INNER JOIN CourseSeriesGroups csg
ON Registrations.int_series_group_id = csg.SeriesGroupID
INNER JOIN CourseSeries cs
ON csg.CourseSeriesID = cs.CourseSeriesID
WHERE cs.CourseSeriesID=?
AND classID =?
Query Parameter Value(s) -qryGetCountofCourseSeriesReg (Datasource=v8Testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:05.005SELECT COUNT(RegistrationID) as CountofCourseSeriesReg
FROM Registrations
INNER JOIN CourseSeriesGroups csg
ON Registrations.int_series_group_id = csg.SeriesGroupID
INNER JOIN CourseSeries cs
ON csg.CourseSeriesID = cs.CourseSeriesID
WHERE cs.CourseSeriesID=?
AND classID =?
Query Parameter Value(s) -qClassID (Datasource=v8Testing7, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\model\courseSeries\act_register_for_course_series.cfm @ 14:22:05.005SELECT DISTINCT int_class_id as ClassID FROM tbl_class_course_series_group WHERE int_Series_group_id = 3 /*Modified Sept 09 2013 Changed the query of query to improve speed Neo 00110*/ Stored Procedures
Scope Variables CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=E:\Lumens\index.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE=CGI/1.1 HTTPS=off HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=*/* HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION= HTTP_COOKIE= HTTP_HOST=v8testing7.augusoft.net HTTP_REFERER= HTTP_URL=/index.cfm?CourseSeriesGroupId=3&method=CourseSeries.CourseSeriesRegistration HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) LOCAL_ADDR=172.31.100.171 PATH_INFO= PATH_TRANSLATED=E:\Lumens\index.cfm QUERY_STRING=CourseSeriesGroupId=3&method=CourseSeries.CourseSeriesRegistration REMOTE_ADDR=172.31.103.195 REMOTE_HOST=172.31.103.195 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/index.cfm SERVER_NAME=v8testing7.augusoft.net SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/10.0 WEB_SERVER_API= Cookie Variables: LUMPERSIST=56A352EDD518BBAB042E770297A656A0 Session Variables: actortypeid=90 addtoken=CFID=17338740&CFTOKEN=8aaf28d899dd7a1a-7250B619-BF5B-AB4C-D3BAB75B65F785C5&jsessionid=B3A6AA3FAA134133768791F78E3A7C02.cfusion allowunmaskeddata=0 appname=v8Testing7 basecfcs=versions.v81QA basecode=/versions/v81QA bit_canvas_failed_process=false bit_member=0 customcct= customcfcs=Customers.v8Testing7 customerid=495 custompath=/Customers/v8Testing7/custom debug=0 debugoutput=1 docxdir=DocxHTML domain=v8testing7.augusoft.net ds=v8Testing7 enabledlivechat=false enabledsupportwidget=false enteredsiteusingipaddress=1 foundeo_firewall_ip=216.73.216.101 foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) loggedin=No loggeduseremail= loggeduserfname=Guest loggeduserlname= membershiptypeid=0 menuid=1 orgid=1 privacypolicyack= regionid=1 sessionid=B3A6AA3FAA134133768791F78E3A7C02.cfusion sitepath=/Customers/v8Testing7 sslreturnurl=https://v8testing7.augusoft.net/ stylesheetpath=/Customers/v8Testing7/StyleSheets/style.css timeoutminutes=60 urltoken=CFID=17338740&CFTOKEN=8aaf28d899dd7a1a-7250B619-BF5B-AB4C-D3BAB75B65F785C5&jsessionid=B3A6AA3FAA134133768791F78E3A7C02.cfusion version=v81QA URL Parameters: CourseSeriesGroupId=3 method=CourseSeries.CourseSeriesRegistrationDebug Rendering Time: 16 ms |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
buy