1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
|
SELECT
s0_.session_id AS session_id_0,
s0_.name AS name_1,
s0_.date_ouverture AS date_ouverture_2,
s0_.date_cloture AS date_cloture_3,
s0_.online AS online_4,
s0_.organisme_prestataire AS organisme_prestataire_5,
s0_.organisme_sous_traitant AS organisme_sous_traitant_6,
s0_.created_at AS created_at_7,
s0_.interface_qb AS interface_qb_8,
s0_.exclue_campagne_mail AS exclue_campagne_mail_9,
s1_.session_questionnaire_id AS session_questionnaire_id_10,
s1_.name AS name_11,
s1_.type AS type_12,
s1_.date_debut AS date_debut_13,
s1_.date_fin AS date_fin_14,
s1_.created_at AS created_at_15,
s1_.afficher_reponses AS afficher_reponses_16,
s1_.auto_correct AS auto_correct_17,
s1_.envoi_auto_mail AS envoi_auto_mail_18,
s1_.date_envoi_auto_mail AS date_envoi_auto_mail_19,
s1_.envoi_auto_relance AS envoi_auto_relance_20,
s1_.date_envoi_auto_relance AS date_envoi_auto_relance_21,
s1_.commentaire AS commentaire_22,
q2_.questionnaire_id AS questionnaire_id_23,
q2_.name AS name_24,
q2_.image AS image_25,
q2_.online AS online_26,
q2_.tempsEstime AS tempsEstime_27,
q2_.created_at AS created_at_28,
e3_.evaluation_id AS evaluation_id_29,
e3_.avancement AS avancement_30,
e3_.note AS note_31,
e3_.temps AS temps_32,
e3_.token AS token_33,
e3_.created_at AS created_at_34,
e3_.envoi_mail AS envoi_mail_35,
e3_.envoi_relance AS envoi_relance_36,
p4_.participant_id AS participant_id_37,
p4_.version AS version_38,
p4_.uuid AS uuid_39,
p4_.matricule AS matricule_40,
p4_.civilite AS civilite_41,
p4_.name AS name_42,
p4_.firstname AS firstname_43,
p4_.code_emploi AS code_emploi_44,
p4_.emploi AS emploi_45,
p4_.email AS email_46,
p4_.date_naissance AS date_naissance_47,
p4_.lieu_naissance AS lieu_naissance_48,
p4_.created_at AS created_at_49,
p4_.updated_at AS updated_at_50,
p5_.participant_id AS participant_id_51,
p5_.version AS version_52,
p5_.uuid AS uuid_53,
p5_.matricule AS matricule_54,
p5_.civilite AS civilite_55,
p5_.name AS name_56,
p5_.firstname AS firstname_57,
p5_.code_emploi AS code_emploi_58,
p5_.emploi AS emploi_59,
p5_.email AS email_60,
p5_.date_naissance AS date_naissance_61,
p5_.lieu_naissance AS lieu_naissance_62,
p5_.created_at AS created_at_63,
p5_.updated_at AS updated_at_64,
s0_.campagne_id AS campagne_id_65,
s0_.formation_id AS formation_id_66,
s0_.formateur_id AS formateur_id_67,
s0_.niveau_id AS niveau_id_68,
s1_.questionnaire_id AS questionnaire_id_69,
s1_.session_id AS session_id_70,
q2_.groupe_id AS groupe_id_71,
q2_.questionnaire_type_id AS questionnaire_type_id_72,
e3_.questionnaire_id AS questionnaire_id_73,
e3_.session_questionnaire_id AS session_questionnaire_id_74,
e3_.session_id AS session_id_75,
e3_.participant_id AS participant_id_76,
p4_.manager_id AS manager_id_77,
p4_.user_id AS user_id_78,
p4_.niveau_id AS niveau_id_79,
FROM
session s0_
LEFT JOIN session_questionnaire s1_ ON s0_.session_id = s1_.session_id
LEFT JOIN questionnaire q2_ ON s1_.questionnaire_id = q2_.questionnaire_id
LEFT JOIN evaluation e3_ ON s1_.session_questionnaire_id = e3_.session_questionnaire_id
LEFT JOIN participant p4_ ON e3_.participant_id = p4_.participant_id
WHERE
s1_.session_questionnaire_id IN (?)
AND (
e3_.avancement IS NULL
OR e3_.avancement LIKE ?
)
AND p4_.manager_id = ? |
Partager