USE fetchmetrics; DROP PROCEDURE IF EXISTS fetchmetrics.p_dog_get_many_distraction; DELIMITER // CREATE PROCEDURE fetchmetrics.p_dog_get_many_distraction ( IN a_id_user INT , IN a_get_all_distraction BIT , IN a_get_inactive_distraction BIT , IN a_ids_distraction TEXT , IN a_notes_distraction TEXT , IN a_min_quantity_distraction INT , IN a_max_quantity_distraction INT , IN a_min_proximity_metres_distraction FLOAT , IN a_max_proximity_metres_distraction FLOAT , IN a_get_all_distraction_type BIT , IN a_get_inactive_distraction_type BIT , IN a_ids_distraction_type TEXT , IN a_names_distraction_type TEXT , IN a_get_all_intensity_level_emotional BIT , IN a_get_inactive_intensity_level_emotional BIT , IN a_ids_intensity_level_emotional TEXT , IN a_names_intensity_level_emotional TEXT , IN a_get_all_intensity_level_scent BIT , IN a_get_inactive_intensity_level_scent BIT , IN a_ids_intensity_level_scent TEXT , IN a_names_intensity_level_scent TEXT , IN a_get_all_intensity_level_sight BIT , IN a_get_inactive_intensity_level_sight BIT , IN a_ids_intensity_level_sight TEXT , IN a_names_intensity_level_sight TEXT , IN a_get_all_intensity_level_sound BIT , IN a_get_inactive_intensity_level_sound BIT , IN a_ids_intensity_level_sound TEXT , IN a_names_intensity_level_sound TEXT , IN a_get_all_intensity_level_touch BIT , IN a_get_inactive_intensity_level_touch BIT , IN a_ids_intensity_level_touch TEXT , IN a_names_intensity_level_touch TEXT , IN a_get_all_AC_Link BIT , IN a_get_inactive_AC_Link BIT , IN a_ids_AC_Link TEXT , IN a_min_distance_from_handler_metres_AC_Link FLOAT , IN a_max_distance_from_handler_metres_AC_Link FLOAT , IN a_value_is_in_sight_of_handler_AC_Link BIT , IN a_value_is_in_scent_range_of_handler_AC_Link BIT , IN a_value_is_in_hearing_range_of_handler_AC_Link BIT , IN a_value_is_on_lead_AC_Link BIT , IN a_min_trial_count_AC_Link FLOAT , IN a_max_trial_count_AC_Link FLOAT , IN a_get_all_assessment BIT , IN a_get_inactive_assessment BIT , IN a_ids_assessment TEXT , IN a_notes_assessment TEXT , IN a_min_temperature_assessment DECIMAL(5, 2) , IN a_max_temperature_assessment DECIMAL(5, 2) , IN a_get_all_assessment_type BIT , IN a_get_inactive_assessment_type BIT , IN a_ids_assessment_type TEXT , IN a_names_assessment_type TEXT , IN a_get_all_weather BIT , IN a_get_inactive_weather BIT , IN a_ids_weather TEXT , IN a_names_weather TEXT , IN a_get_all_lighting_level BIT , IN a_get_inactive_lighting_level BIT , IN a_ids_lighting_level TEXT , IN a_names_lighting_level TEXT , IN a_get_all_location BIT , IN a_get_inactive_location BIT , IN a_ids_location TEXT , IN a_names_location TEXT , IN a_get_all_user_handler BIT , IN a_get_inactive_user_handler BIT , IN a_ids_user_handler TEXT -- , IN a_auth0_ids_user_handler TEXT , IN a_names_user_handler TEXT , IN a_emails_user_handler TEXT , IN a_get_all_command_category BIT , IN a_get_inactive_command_category BIT , IN a_ids_command_category TEXT , IN a_names_command_category TEXT , IN a_get_all_command BIT , IN a_get_inactive_command BIT , IN a_ids_command TEXT , IN a_names_command TEXT , IN a_hand_signal_default_descriptions_command TEXT , IN a_notes_command TEXT , IN a_get_all_reinforcement_schedule BIT , IN a_get_inactive_reinforcement_schedule BIT , IN a_ids_reinforcement_schedule TEXT , IN a_names_reinforcement_schedule TEXT , IN a_require_all_id_search_filters_met BIT , IN a_require_any_id_search_filters_met BIT , IN a_require_all_non_id_search_filters_met BIT , IN a_require_any_non_id_search_filters_met BIT , IN a_show_errors BIT , IN a_debug BIT ) BEGIN DECLARE v_can_view BIT; DECLARE v_code_type_error_bad_data VARCHAR(100); DECLARE v_code_type_error_no_permission VARCHAR(100); DECLARE v_guid BINARY(36); DECLARE v_id_access_level_view INT; DECLARE v_id_minimum INT; DECLARE v_id_permission_dog_view INT; DECLARE v_id_type_error_bad_data INT; DECLARE v_id_type_error_no_permission INT; DECLARE v_time_start TIMESTAMP(6); DECLARE exit handler for SQLEXCEPTION BEGIN GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE , @errno = MYSQL_ERRNO , @text = MESSAGE_TEXT ; ROLLBACK; CREATE TEMPORARY TABLE IF NOT EXISTS tmp_Msg_Error ( id_error INT NOT NULL PRIMARY KEY AUTO_INCREMENT , id_type INT , code VARCHAR(250) NOT NULL , msg TEXT NOT NULL ); INSERT INTO tmp_Msg_Error ( id_type , code , msg ) SELECT MET.id_type , @errno , @text FROM fetchmetrics.CORE_Msg_Error_Type MET WHERE MET.code = 'MYSQL_ERROR' ; SELECT t_ERROR.id_error , t_ERROR.id_type , t_ERROR.code , ERROR_TYPE.name , ERROR_TYPE.description , ERROR_TYPE.is_breaking_error , ERROR_TYPE.background_colour , ERROR_TYPE.text_colour , t_ERROR.msg FROM tmp_Msg_Error t_ERROR INNER JOIN fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE ON t_ERROR.id_type = ERROR_TYPE.id_type ; DROP TABLE IF EXISTS tmp_Msg_Error; END; SET v_time_start := CURRENT_TIMESTAMP(6); SET v_guid := UUID(); SET v_code_type_error_bad_data := 'BAD_DATA'; SET v_code_type_error_no_permission := 'NO_PERMISSION'; SET v_id_type_error_bad_data := (SELECT ERROR_TYPE.id_type FROM fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE WHERE ERROR_TYPE.code = v_code_type_error_bad_data LIMIT 1); SET v_id_type_error_no_permission := (SELECT ERROR_TYPE.id_type FROM fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE WHERE ERROR_TYPE.code = v_code_type_error_no_permission LIMIT 1); SET v_id_permission_dog_view := (SELECT PERMISSION.id_permission FROM fetchmetrics.DOG_Permission PERMISSION WHERE PERMISSION.code = 'DOG_VIEW' LIMIT 1); SET v_id_access_level_view := (SELECT ACCESS_LEVEL.id_access_level FROM fetchmetrics.DOG_Access_Level ACCESS_LEVEL WHERE ACCESS_LEVEL.code = 'VIEW' LIMIT 1); SET a_id_user := IFNULL(a_id_user, 0); /* Filters handled by Calc Stored Procedure */ SET a_show_errors := IFNULL(a_show_errors, 1); SET a_debug := IFNULL(a_debug, 0); IF a_debug = 1 THEN SELECT a_id_user , a_get_all_distraction , a_get_inactive_distraction , a_ids_distraction , a_notes_distraction , a_min_quantity_distraction , a_max_quantity_distraction , a_min_proximity_metres_distraction , a_max_proximity_metres_distraction , a_get_all_distraction_type , a_get_inactive_distraction_type , a_ids_distraction_type , a_names_distraction_type , a_get_all_intensity_level_emotional , a_get_inactive_intensity_level_emotional , a_ids_intensity_level_emotional , a_names_intensity_level_emotional , a_get_all_intensity_level_scent , a_get_inactive_intensity_level_scent , a_ids_intensity_level_scent , a_names_intensity_level_scent , a_get_all_intensity_level_sight , a_get_inactive_intensity_level_sight , a_ids_intensity_level_sight , a_names_intensity_level_sight , a_get_all_intensity_level_sound , a_get_inactive_intensity_level_sound , a_ids_intensity_level_sound , a_names_intensity_level_sound , a_get_all_intensity_level_touch , a_get_inactive_intensity_level_touch , a_ids_intensity_level_touch , a_names_intensity_level_touch , a_get_all_AC_link , a_get_inactive_AC_link , a_ids_AC_link , a_min_distance_from_handler_metres_AC_Link , a_max_distance_from_handler_metres_AC_Link , a_value_is_in_sight_of_handler_AC_Link , a_value_is_in_scent_range_of_handler_AC_Link , a_value_is_in_hearing_range_of_handler_AC_Link , a_value_is_on_lead_AC_Link , a_min_trial_count_AC_Link , a_max_trial_count_AC_Link , a_get_all_assessment , a_get_inactive_assessment , a_ids_assessment , a_notes_assessment , a_min_temperature_assessment , a_max_temperature_assessment , a_get_all_assessment_type , a_get_inactive_assessment_type , a_ids_assessment_type , a_names_assessment_type , a_get_all_weather , a_get_inactive_weather , a_ids_weather , a_names_weather , a_get_all_lighting_level , a_get_inactive_lighting_level , a_ids_lighting_level , a_names_lighting_level , a_get_all_location , a_get_inactive_location , a_ids_location , a_names_location , a_get_all_user_handler , a_get_inactive_user_handler , a_ids_user_handler -- , a_auth0_ids_user_handler , a_names_user_handler , a_emails_user_handler , a_get_all_command_category , a_get_inactive_command_category , a_ids_command_category , a_names_command_category , a_get_all_command , a_get_inactive_command , a_ids_command , a_names_command , a_hand_signal_default_descriptions_command , a_notes_command , a_get_all_reinforcement_schedule , a_get_inactive_reinforcement_schedule , a_ids_reinforcement_schedule , a_names_reinforcement_schedule , a_require_all_id_search_filters_met , a_require_any_id_search_filters_met , a_require_all_non_id_search_filters_met , a_require_any_non_id_search_filters_met , a_show_errors , a_debug ; SELECT v_id_type_error_bad_data , v_id_type_error_no_permission , v_guid , v_id_permission_dog_view , v_time_start ; END IF; DROP TEMPORARY TABLE IF EXISTS tmp_Msg_Error; DROP TEMPORARY TABLE IF EXISTS tmp_Distraction; CREATE TEMPORARY TABLE tmp_Distraction ( id_distraction INT NOT NULL , id_assessment_command_link INT , id_distraction_type INT , id_intensity_level_emotional INT , id_intensity_level_scent INT , id_intensity_level_sight INT , id_intensity_level_sound INT , id_intensity_level_touch INT , quantity INT , proximity_metres FLOAT -- , difficulty_level DOUBLE , notes TEXT , active BIT , does_meet_id_filters BIT NOT NULL , does_meet_non_id_filters BIT NOT NULL ); CREATE TEMPORARY TABLE IF NOT EXISTS tmp_Msg_Error ( id_error INT NOT NULL PRIMARY KEY AUTO_INCREMENT , id_type INT , code VARCHAR(250) NOT NULL , msg TEXT NOT NULL ); -- Permissions IF a_debug = 1 THEN SELECT v_guid , 0 -- get_all_user , 0 -- get_inactive_user , a_id_user -- ids_user , '' -- a_auth0_ids_user , '' -- a_names_user , '' -- a_emails_user , 1 -- a_require_all_id_search_filters_met , 1 -- a_require_any_id_search_filters_met , 0 -- a_require_all_non_id_search_filters_met , 0 -- a_require_any_non_id_search_filters_met , v_id_permission_dog_view -- ids_permission , v_id_access_level_view -- ids_access_level , 0 -- a_show_errors , 0 -- a_debug ; END IF; CALL fetchmetrics.p_dog_calc_user_access( v_guid , 0 -- get_all_user , 0 -- get_inactive_user , a_id_user -- ids_user , '' -- a_auth0_ids_user , '' -- a_names_user , '' -- a_emails_user , 1 -- a_require_all_id_search_filters_met , 1 -- a_require_any_id_search_filters_met , 0 -- a_require_all_non_id_search_filters_met , 0 -- a_require_any_non_id_search_filters_met , v_id_permission_dog_view -- ids_permission , v_id_access_level_view -- ids_access_level , 0 -- a_show_errors , 0 -- a_debug ); SELECT IFNULL(CALC_USER_T.has_access, 0) INTO v_can_view FROM fetchmetrics.DOG_Calc_User_Access_Temp CALC_USER_T WHERE CALC_USER_T.GUID = v_guid LIMIT 1 ; IF a_debug = 1 THEN SELECT v_can_view; SELECT COUNT(*) AS Count_Errors FROM tmp_Msg_Error t_ERROR; SELECT * FROM tmp_Msg_Error t_ERROR; END IF; IF (v_can_view = 0) THEN DELETE t_ME FROM tmp_Msg_Error t_ME WHERE t_ME.id_type <> v_id_type_error_no_permission ; INSERT INTO tmp_Msg_Error ( id_type , code , msg ) VALUES ( v_id_type_error_no_permission , v_code_type_error_no_permission , 'You do not have permission to view Distractions.' ) ; END IF; CALL fetchmetrics.p_dog_clear_calc_user_access( v_guid , 0 -- a_debug ); -- Call Distraction Calc IF NOT EXISTS(SELECT * FROM tmp_Msg_Error t_ERROR INNER JOIN fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE ON t_ERROR.id_type = ERROR_TYPE.id_type WHERE ERROR_TYPE.is_breaking_error = 1 LIMIT 1) THEN IF a_debug = 1 THEN SELECT v_guid -- a_guid , a_id_user -- a_id_user , a_get_all_distraction , a_get_inactive_distraction , a_ids_distraction , a_notes_distraction , a_min_quantity_distraction , a_max_quantity_distraction , a_min_proximity_metres_distraction , a_max_proximity_metres_distraction , a_get_all_distraction_type , a_get_inactive_distraction_type , a_ids_distraction_type , a_names_distraction_type , a_get_all_intensity_level_emotional , a_get_inactive_intensity_level_emotional , a_ids_intensity_level_emotional , a_names_intensity_level_emotional , a_get_all_intensity_level_scent , a_get_inactive_intensity_level_scent , a_ids_intensity_level_scent , a_names_intensity_level_scent , a_get_all_intensity_level_sight , a_get_inactive_intensity_level_sight , a_ids_intensity_level_sight , a_names_intensity_level_sight , a_get_all_intensity_level_sound , a_get_inactive_intensity_level_sound , a_ids_intensity_level_sound , a_names_intensity_level_sound , a_get_all_intensity_level_touch , a_get_inactive_intensity_level_touch , a_ids_intensity_level_touch , a_names_intensity_level_touch , a_get_all_AC_link , a_get_inactive_AC_link , a_ids_AC_link , a_min_distance_from_handler_metres_AC_Link , a_max_distance_from_handler_metres_AC_Link , a_value_is_in_sight_of_handler_AC_Link , a_value_is_in_scent_range_of_handler_AC_Link , a_value_is_in_hearing_range_of_handler_AC_Link , a_value_is_on_lead_AC_Link , a_min_trial_count_AC_Link , a_max_trial_count_AC_Link , a_get_all_assessment , a_get_inactive_assessment , a_ids_assessment , a_notes_assessment , a_min_temperature_assessment , a_max_temperature_assessment , a_get_all_assessment_type , a_get_inactive_assessment_type , a_ids_assessment_type , a_names_assessment_type , a_get_all_weather , a_get_inactive_weather , a_ids_weather , a_names_weather , a_get_all_lighting_level , a_get_inactive_lighting_level , a_ids_lighting_level , a_names_lighting_level , a_get_all_location , a_get_inactive_location , a_ids_location , a_names_location , a_get_all_user_handler , a_get_inactive_user_handler , a_ids_user_handler -- , a_auth0_ids_user_handler , a_names_user_handler , a_emails_user_handler , a_get_all_command_category , a_get_inactive_command_category , a_ids_command_category , a_names_command_category , a_get_all_command , a_get_inactive_command , a_ids_command , a_names_command , a_hand_signal_default_descriptions_command , a_notes_command , a_get_all_reinforcement_schedule , a_get_inactive_reinforcement_schedule , a_ids_reinforcement_schedule , a_names_reinforcement_schedule , a_require_all_id_search_filters_met , a_require_any_id_search_filters_met , a_require_all_non_id_search_filters_met , a_require_any_non_id_search_filters_met , 0 -- a_show_errors , 0 -- a_debug ; END IF; CALL fetchmetrics.p_dog_calc_distraction ( v_guid -- a_guid , a_id_user -- a_id_user , a_get_all_distraction , a_get_inactive_distraction , a_ids_distraction , a_notes_distraction , a_min_quantity_distraction , a_max_quantity_distraction , a_min_proximity_metres_distraction , a_max_proximity_metres_distraction , a_get_all_distraction_type , a_get_inactive_distraction_type , a_ids_distraction_type , a_names_distraction_type , a_get_all_intensity_level_emotional , a_get_inactive_intensity_level_emotional , a_ids_intensity_level_emotional , a_names_intensity_level_emotional , a_get_all_intensity_level_scent , a_get_inactive_intensity_level_scent , a_ids_intensity_level_scent , a_names_intensity_level_scent , a_get_all_intensity_level_sight , a_get_inactive_intensity_level_sight , a_ids_intensity_level_sight , a_names_intensity_level_sight , a_get_all_intensity_level_sound , a_get_inactive_intensity_level_sound , a_ids_intensity_level_sound , a_names_intensity_level_sound , a_get_all_intensity_level_touch , a_get_inactive_intensity_level_touch , a_ids_intensity_level_touch , a_names_intensity_level_touch , a_get_all_AC_link , a_get_inactive_AC_link , a_ids_AC_link , a_min_distance_from_handler_metres_AC_Link , a_max_distance_from_handler_metres_AC_Link , a_value_is_in_sight_of_handler_AC_Link , a_value_is_in_scent_range_of_handler_AC_Link , a_value_is_in_hearing_range_of_handler_AC_Link , a_value_is_on_lead_AC_Link , a_min_trial_count_AC_Link , a_max_trial_count_AC_Link , a_get_all_assessment , a_get_inactive_assessment , a_ids_assessment , a_notes_assessment , a_min_temperature_assessment , a_max_temperature_assessment , a_get_all_assessment_type , a_get_inactive_assessment_type , a_ids_assessment_type , a_names_assessment_type , a_get_all_weather , a_get_inactive_weather , a_ids_weather , a_names_weather , a_get_all_lighting_level , a_get_inactive_lighting_level , a_ids_lighting_level , a_names_lighting_level , a_get_all_location , a_get_inactive_location , a_ids_location , a_names_location , a_get_all_user_handler , a_get_inactive_user_handler , a_ids_user_handler -- , a_auth0_ids_user_handler , a_names_user_handler , a_emails_user_handler , a_get_all_command_category , a_get_inactive_command_category , a_ids_command_category , a_names_command_category , a_get_all_command , a_get_inactive_command , a_ids_command , a_names_command , a_hand_signal_default_descriptions_command , a_notes_command , a_get_all_reinforcement_schedule , a_get_inactive_reinforcement_schedule , a_ids_reinforcement_schedule , a_names_reinforcement_schedule , a_require_all_id_search_filters_met , a_require_any_id_search_filters_met , a_require_all_non_id_search_filters_met , a_require_any_non_id_search_filters_met , 0 -- a_show_errors , 0 -- a_debug ); IF a_debug = 1 THEN SELECT COUNT(*) FROM fetchmetrics.DOG_Distraction_Temp; SELECT * FROM fetchmetrics.DOG_Distraction_Temp; END IF; INSERT INTO tmp_Distraction ( id_distraction , id_assessment_command_link , id_distraction_type , id_intensity_level_emotional , id_intensity_level_scent , id_intensity_level_sight , id_intensity_level_sound , id_intensity_level_touch , quantity , proximity_metres , notes , active , does_meet_id_filters , does_meet_non_id_filters ) SELECT DISTRACTION_T.id_distraction , DISTRACTION_T.id_assessment_command_link , DISTRACTION_T.id_distraction_type , DISTRACTION_T.id_intensity_level_emotional , DISTRACTION_T.id_intensity_level_scent , DISTRACTION_T.id_intensity_level_sight , DISTRACTION_T.id_intensity_level_sound , DISTRACTION_T.id_intensity_level_touch , DISTRACTION_T.quantity , DISTRACTION_T.proximity_metres , DISTRACTION_T.notes , DISTRACTION_T.active , DISTRACTION_T.does_meet_id_filters , DISTRACTION_T.does_meet_non_id_filters FROM fetchmetrics.DOG_Distraction_Temp DISTRACTION_T WHERE DISTRACTION_T.GUID = v_guid ; IF a_debug = 1 THEN SELECT COUNT(*) FROM tmp_Distraction; SELECT * FROM tmp_Distraction; END IF; END IF; -- Filter outputs IF EXISTS(SELECT * FROM tmp_Msg_Error t_ERROR INNER JOIN fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE ON t_ERROR.id_type = ERROR_TYPE.id_type WHERE ERROR_TYPE.is_breaking_error = 1 LIMIT 1) THEN IF a_debug = 1 THEN SELECT * FROM tmp_Distraction; END IF; DELETE FROM tmp_Distraction; END IF; -- Outputs -- Distractions SELECT t_DISTRACTION.id_distraction , t_DISTRACTION.id_assessment_command_link , t_DISTRACTION.id_distraction_type , DISTRACTION_TYPE.name AS name_distraction_type , t_DISTRACTION.id_intensity_level_emotional , INTENSITY_LEVEL_EMOTIONAL.name AS name_intensity_level_emotional , t_DISTRACTION.id_intensity_level_scent , INTENSITY_LEVEL_SCENT.name AS name_intensity_level_scent , t_DISTRACTION.id_intensity_level_sight , INTENSITY_LEVEL_SIGHT.name AS name_intensity_level_sight , t_DISTRACTION.id_intensity_level_sound , INTENSITY_LEVEL_SOUND.name AS name_intensity_level_sound , t_DISTRACTION.id_intensity_level_touch , INTENSITY_LEVEL_TOUCH.name AS name_intensity_level_touch , t_DISTRACTION.quantity , t_DISTRACTION.proximity_metres , t_DISTRACTION.notes , t_DISTRACTION.active , t_DISTRACTION.does_meet_id_filters , t_DISTRACTION.does_meet_non_id_filters FROM tmp_Distraction t_DISTRACTION LEFT JOIN fetchmetrics.DOG_Distraction_Type DISTRACTION_TYPE ON t_DISTRACTION.id_distraction_type = DISTRACTION_TYPE.id_type LEFT JOIN fetchmetrics.DOG_Distraction_Intensity_Level INTENSITY_LEVEL_EMOTIONAL ON t_DISTRACTION.id_intensity_level_emotional = INTENSITY_LEVEL_EMOTIONAL.id_intensity_level LEFT JOIN fetchmetrics.DOG_Distraction_Intensity_Level INTENSITY_LEVEL_SCENT ON t_DISTRACTION.id_intensity_level_scent = INTENSITY_LEVEL_SCENT.id_intensity_level LEFT JOIN fetchmetrics.DOG_Distraction_Intensity_Level INTENSITY_LEVEL_SIGHT ON t_DISTRACTION.id_intensity_level_sight = INTENSITY_LEVEL_SIGHT.id_intensity_level LEFT JOIN fetchmetrics.DOG_Distraction_Intensity_Level INTENSITY_LEVEL_SOUND ON t_DISTRACTION.id_intensity_level_sound = INTENSITY_LEVEL_SOUND.id_intensity_level LEFT JOIN fetchmetrics.DOG_Distraction_Intensity_Level INTENSITY_LEVEL_TOUCH ON t_DISTRACTION.id_intensity_level_touch = INTENSITY_LEVEL_TOUCH.id_intensity_level ORDER BY DISTRACTION_TYPE.name LIMIT 1000 ; -- Errors SELECT t_ERROR.id_error , t_ERROR.id_type , t_ERROR.code , ERROR_TYPE.name , ERROR_TYPE.description , ERROR_TYPE.is_breaking_error , ERROR_TYPE.background_colour , ERROR_TYPE.text_colour , t_ERROR.msg FROM tmp_Msg_Error t_ERROR INNER JOIN fetchmetrics.CORE_Msg_Error_Type ERROR_TYPE ON t_ERROR.id_type = ERROR_TYPE.id_type ; IF a_debug = 1 AND v_can_view = 1 THEN SELECT * FROM tmp_Distraction; END IF; CALL fetchmetrics.p_dog_clear_calc_distraction( v_guid -- a_guid , 0 -- a_debug ); DROP TEMPORARY TABLE IF EXISTS tmp_Msg_Error; DROP TEMPORARY TABLE IF EXISTS tmp_Distraction; IF a_debug = 1 THEN CALL fetchmetrics.p_core_debug_timing_reporting ( v_time_start ); END IF; END // DELIMITER ; /* CALL fetchmetrics.p_dog_get_many_distraction ( 1 -- 'auth0|6582b95c895d09a70ba10fef', -- a_id_user , 1 -- a_get_all_distraction , 0 -- a_get_inactive_distraction , '' -- a_ids_distraction , '' -- a_notes_distraction , NULL -- a_min_quantity_distraction , NULL -- a_max_quantity_distraction , NULL -- a_min_proximity_metres_distraction , NULL -- a_max_proximity_metres_distraction , 1 -- a_get_all_distraction_type , 0 -- a_get_inactive_distraction_type , '' -- a_ids_distraction_type , '' -- a_names_distraction_type , 1 -- a_get_all_intensity_level_emotional , 0 -- a_get_inactive_intensity_level_emotional , '' -- a_ids_intensity_level_emotional , '' -- a_names_intensity_level_emotional , 1 -- a_get_all_intensity_level_scent , 0 -- a_get_inactive_intensity_level_scent , '' -- a_ids_intensity_level_scent , '' -- a_names_intensity_level_scent , 1 -- a_get_all_intensity_level_sight , 0 -- a_get_inactive_intensity_level_sight , '' -- a_ids_intensity_level_sight , '' -- a_names_intensity_level_sight , 1 -- a_get_all_intensity_level_sound , 0 -- a_get_inactive_intensity_level_sound , '' -- a_ids_intensity_level_sound , '' -- a_names_intensity_level_sound , 1 -- a_get_all_intensity_level_touch , 0 -- a_get_inactive_intensity_level_touch , '' -- a_ids_intensity_level_touch , '' -- a_names_intensity_level_touch , 1 -- a_get_all_AC_link , 0 -- a_get_inactive_AC_link , '' -- a_ids_AC_link , NULL -- a_min_distance_from_handler_metres_AC_Link , NULL -- a_max_distance_from_handler_metres_AC_Link , NULL -- a_value_is_in_sight_of_handler_AC_Link , NULL -- a_value_is_in_scent_range_of_handler_AC_Link , NULL -- a_value_is_in_hearing_range_of_handler_AC_Link , NULL -- a_value_is_on_lead_AC_Link , NULL -- a_min_trial_count_AC_Link , NULL -- a_max_trial_count_AC_Link , 1 -- a_get_all_assessment , 0 -- a_get_inactive_assessment , '' -- a_ids_assessment , '' -- a_notes_assessment , NULL -- a_min_temperature_assessment , NULL -- a_max_temperature_assessment , 1 -- a_get_all_assessment_type , 0 -- a_get_inactive_assessment_type , '' -- a_ids_assessment_type , '' -- a_names_assessment_type , 1 -- a_get_all_weather , 0 -- a_get_inactive_weather , '' -- a_ids_weather , '' -- a_names_weather , 1 -- a_get_all_lighting_level , 0 -- a_get_inactive_lighting_level , '' -- a_ids_lighting_level , '' -- a_names_lighting_level , 1 -- a_get_all_location , 0 -- a_get_inactive_location , '' -- a_ids_location , '' -- a_names_location , 1 -- a_get_all_user_handler , 0 -- a_get_inactive_user_handler , '' -- a_ids_user_handler -- , IN a_auth0_ids_user_handler TEXT , '' -- a_names_user_handler , '' -- a_emails_user_handler , 1 -- a_get_all_command_category , 0 -- a_get_inactive_command_category , '' -- a_ids_command_category , '' -- a_names_command_category , 1 -- a_get_all_command , 0 -- a_get_inactive_command , '' -- a_ids_command , '' -- a_names_command , '' -- a_hand_signal_default_descriptions_command , '' -- a_notes_command , 1 -- a_get_all_reinforcement_schedule , 0 -- a_get_inactive_reinforcement_schedule , '' -- a_ids_reinforcement_schedule , '' -- a_names_reinforcement_schedule , 1 -- a_require_all_id_search_filters_met , 1 -- a_require_any_id_search_filters_met , 0 -- a_require_all_non_id_search_filters_met , 1 -- a_require_any_non_id_search_filters_met , 1 -- a_show_errors , 1 -- a_debug ); */