Snippets
Created by
Raihan S
last modified
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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 | SELECT
`s`.`id` AS `s_id`,
`s`.`name` AS `s_name`,
`s`.`facility_id` AS `s_facility_id`,
`s`.`designation_id` AS `s_designation_id`,
`s`.`facilityagency_id` AS `s_facilityagency_id`,
`s`.`facilityagency_code` AS `s_facilityagency_code`,
`s`.`facilityagency_name` AS `s_facilityagency_name`,
`s`.`sanctionedpostfirstleveloption_id` AS `s_sanctionedpostfirstleveloption_id`,
`s`.`sanctionedpostfirstleveloption_code` AS `s_sanctionedpostfirstleveloption_code`,
`s`.`sanctionedpostfirstleveloption_name` AS `s_sanctionedpostfirstleveloption_name`,
`s`.`sanctionedpostsecondleveloption_id` AS `s_sanctionedpostsecondleveloption_id`,
`s`.`sanctionedpostsecondleveloption_code` AS `s_sanctionedpostsecondleveloption_code`,
`s`.`sanctionedpostsecondleveloption_name` AS `s_sanctionedpostsecondleveloption_name`,
`s`.`sanctionedposttype_id` AS `s_sanctionedposttype_id`,
`s`.`sanctionedposttype_code` AS `s_sanctionedposttype_code`,
`s`.`sanctionedposttype_name` AS `s_sanctionedposttype_name`,
`p`.`id` AS `p_id`,
`p`.`name` AS `p_name`,
`p`.`name_BN` AS `p_name_BN`,
`p`.`code` AS `p_code`,
`p`.`pds_code` AS `p_pds_code`,
`p`.`dob` AS `p_dob`,
`p`.`national_id_no` AS `p_national_id_no`,
`p`.`retirement_date` AS `p_retirement_date`,
`p`.`fathers_name` AS `p_fathers_name`,
`p`.`mothers_name` AS `p_mothers_name`,
`p`.`email` AS `p_email`,
`p`.`contact_no` AS `p_contact_no`,
`p`.`is_freedomfighter` AS `p_is_freedomfighter`,
`p`.`joining_date_govt_health_service` AS `p_joining_date_govt_health_service`,
`p`.`joining_date_current_place` AS `p_joining_date_current_place`,
`p`.`joining_date_current_designation` AS `p_joining_date_current_designation`,
`p`.`tribaloption_id` AS `p_tribaloption_id`,
`p`.`tribaloption_name` AS `p_tribaloption_name`,
`p`.`sex_id` AS `p_sex_id`,
`p`.`sex_name` AS `p_sex_name`,
`p`.`maritalstatus_id` AS `p_maritalstatus_id`,
`p`.`maritalstatus_name` AS `p_maritalstatus_name`,
`p`.`religiousgroup_name` AS `p_religiousgroup_name`,
`p`.`professionaldiscipline_id` AS `p_professionaldiscipline_id`,
`p`.`professionaldiscipline_name` AS `p_professionaldiscipline_name`,
`p`.`department_id` AS `p_department_id`,
`p`.`department_name` AS `p_department_name`,
`p`.`staffpostingoption_id` AS `p_staffpostingoption_id`,
`p`.`staffpostingoption_name` AS `p_staffpostingoption_name`,
`p`.`staffprofessionalcategory_id` AS `p_staffprofessionalcategory_id`,
`p`.`staffprofessionalcategory_name` AS `p_staffprofessionalcategory_name`,
`p`.`providerclass_id` AS `p_providerclass_id`,
`p`.`providerclass_name` AS `p_providerclass_name`,
`p`.`designationposttype_id` AS `p_designationposttype_id`,
`p`.`designationposttype_name` AS `p_designationposttype_name`,
`p`.`drawsalaryplacetype_id` AS `p_drawsalaryplacetype_id`,
`p`.`drawsalaryplacetype_name` AS `p_drawsalaryplacetype_name`,
`p`.`drawsalarytype_id` AS `p_drawsalarytype_id`,
`p`.`drawsalarytype_name` AS `p_drawsalarytype_name`,
`p`.`designationtypeoption_id` AS `p_designationtypeoption_id`,
`p`.`designationtypeoption_name` AS `p_designationtypeoption_name`,
`p`.`postedasoption_id` AS `p_postedasoption_id`,
`p`.`postedasoption_name` AS `p_postedasoption_name`,
`p`.`workingstatus_id` AS `p_workingstatus_id`,
`p`.`workingstatus_name` AS `p_workingstatus_name`,
`p`.`has_govt_quarter` AS `p_has_govt_quarter`,
`p`.`is_medical` AS `p_is_medical`,
`p`.`last_promotion_confirmed_designation` AS `p_last_promotion_confirmed_designation`,
`p`.`last_promotion_go` AS `p_last_promotion_go`,
`p`.`last_promotion_serial` AS `p_last_promotion_serial`,
`p`.`last_promotion_date` AS `p_last_promotion_date`,
`p`.`desired_designation_group` AS `p_desired_designation_group`,
`p`.`desired_professional_discipline` AS `p_desired_professional_discipline`,
`p`.`ist_year` AS `p_ist_year`,
`p`.`ist_appointment_date` AS `p_ist_appointment_date`,
`p`.`ist_go` AS `p_ist_go`,
`p`.`ist_sl_no` AS `p_ist_sl_no`,
`p`.`ist_date` AS `p_ist_date`,
`p`.`ist_appointment_go` AS `p_ist_appointment_go`,
`p`.`ist_appointment_sl_no` AS `p_ist_appointment_sl_no`,
`p`.`bcs_batch_no` AS `p_bcs_batch_no`,
`p`.`bcs_psc_regularization_date` AS `p_bcs_psc_regularization_date`,
`p`.`bcs_psc_regularization_go` AS `p_bcs_psc_regularization_go`,
`p`.`bcs_psc_regularization_sl_no` AS `p_bcs_psc_regularization_sl_no`,
`p`.`adhoc_go_no` AS `p_adhoc_go_no`,
`p`.`adhoc_sl_no` AS `p_adhoc_sl_no`,
`p`.`adhoc_sl_date` AS `p_adhoc_sl_date`,
`p`.`service_confirmation_date` AS `p_service_confirmation_date`,
`p`.`service_confirmation_go` AS `p_service_confirmation_go`,
`p`.`service_confirmation_sl_no` AS `p_service_confirmation_sl_no`,
`p`.`is_senior_scale_pass` AS `p_is_senior_scale_pass`,
`p`.`is_departmental_exam_pass` AS `p_is_departmental_exam_pass`,
`p`.`experience_in_village` AS `p_experience_in_village`,
`p`.`sanctionedpost_id` AS `p_sanctionedpost_id`,
`p`.`current_basic_pay_taka` AS `p_current_basic_pay_taka`,
`p`.`current_payscale` AS `p_current_payscale`,
`p`.`prlorder_id` AS `p_prlorder_id`,
`p`.`from_sanctionedpost_id` AS `p_from_sanctionedpost_id`,
`p`.`from_sanctionedpost_details` AS `p_from_sanctionedpost_details`,
`p`.`prl_start_date` AS `p_prl_start_date`,
`p`.`prension_received_date` AS `p_prension_received_date`,
`p`.`retirementtype_id` AS `p_retirementtype_id`,
`p`.`retirementtype_name` AS `p_retirementtype_name`,
`p`.`nominee_name` AS `p_nominee_name`,
`p`.`nominee_fathers_name` AS `p_nominee_fathers_name`,
`p`.`nominee_nid` AS `p_nominee_nid`,
`p`.`nominee_hid` AS `p_nominee_hid`,
`p`.`providerstatus_code` AS `p_providerstatus_code`,
`p`.`providerstatus_name` AS `p_providerstatus_name`,
`p`.`has_acr` AS `p_has_acr`,
`p`.`acr_year` AS `p_acr_year`,
`p`.`primary_designation` AS `p_primary_designation`,
`p`.`joining_date_primary_designation` AS `p_joining_date_primary_designation`,
`p`.`attendance_id` AS `p_attendance_id`,
`f`.`name` AS `f_name`,
`f`.`name_BN` AS `f_name_BN`,
`f`.`code` AS `f_code`,
`f`.`division_id` AS `f_division_id`,
`f`.`division_code` AS `f_division_code`,
`f`.`division_name` AS `f_division_name`,
`f`.`district_id` AS `f_district_id`,
`f`.`district_code` AS `f_district_code`,
`f`.`district_name` AS `f_district_name`,
`f`.`upazila_id` AS `f_upazila_id`,
`f`.`upazila_code` AS `f_upazila_code`,
`f`.`upazila_name` AS `f_upazila_name`,
`f`.`paurasava_id` AS `f_paurasava_id`,
`f`.`paurasava_code` AS `f_paurasava_code`,
`f`.`paurasava_name` AS `f_paurasava_name`,
`f`.`union_id` AS `f_union_id`,
`f`.`union_code` AS `f_union_code`,
`f`.`union_name` AS `f_union_name`,
`f`.`ward_id` AS `f_ward_id`,
`f`.`ward_code` AS `f_ward_code`,
`f`.`ward_name` AS `f_ward_name`,
`f`.`village_code` AS `f_village_code`,
`f`.`house_number` AS `f_house_number`,
`f`.`mailing_address` AS `f_mailing_address`,
`f`.`facilitytype_id` AS `f_facilitytype_id`,
`f`.`facilitytype_name` AS `facilitytype_name`,
`f`.`facilityagency_id` AS `f_facilityagency_id`,
`f`.`facilityagency_name` AS `f_facilityagency_name`,
`f`.`facilityfunction_id` AS `f_facilityfunction_id`,
`f`.`facilityfunction_name` AS `f_facilityfunction_name`,
`f`.`facilitylevel_id` AS `f_facilitylevel_id`,
`f`.`facilitylevel_name` AS `f_facilitylevel_name`,
`f`.`facilityhealthcarelevel_id` AS `f_facilityhealthcarelevel_id`,
`f`.`facilityhealthcarelevel_name` AS `f_facilityhealthcarelevel_name`,
`f`.`facilitylocationtype_id` AS `f_facilitylocationtype_id`,
`f`.`facilitylocationtype_name` AS `f_facilitylocationtype_name`,
`f`.`facilityownership_id` AS `f_facilityownership_id`,
`f`.`facilityownership_name` AS `f_facilityownership_name`,
`f`.`is_active` AS `f_is_active`,
`f`.`total_posts_reported` AS `f_total_posts_reported`,
`f`.`filled_posts_reported` AS `f_filled_posts_reported`,
`f`.`vacant_posts_reported` AS `f_vacant_posts_reported`,
`d`.`id` AS `d_id`,
`d`.`name` AS `d_name`,
`d`.`name_BN` AS `d_name_BN`,
`d`.`code` AS `d_code`,
`d`.`rank` AS `d_rank`,
`d`.`designation_primary_category` AS `d_designation_primary_category`,
`d`.`reporting_category` AS `d_reporting_category`,
`d`.`designationpayscale_id` AS `d_designationpayscale_id`,
`d`.`designationpayscale_code` AS `d_designationpayscale_code`,
`d`.`designationpayscale_name` AS `d_designationpayscale_name`,
`d`.`designationclass_id` AS `d_designationclass_id`,
`d`.`designationclass_code` AS `d_designationclass_code`,
`d`.`designationclass_name` AS `d_designationclass_name`,
`d`.`designationdiscipline_id` AS `d_designationdiscipline_id`,
`d`.`designationdiscipline_code` AS `d_designationdiscipline_code`,
`d`.`designationdiscipline_name` AS `d_designationdiscipline_name`,
`d`.`designationgroup_id` AS `d_designationgroup_id`,
`d`.`designationgroup_code` AS `d_designationgroup_code`,
`d`.`designationgroup_name` AS `d_designationgroup_name`,
`d`.`designationbdprofcategory_id` AS `d_designationbdprofcategory_id`,
`d`.`designationbdprofcategory_code` AS `d_designationbdprofcategory_code`,
`d`.`designationbdprofcategory_name` AS `d_designationbdprofcategory_name`,
`d`.`designationwhoprofgroup_id` AS `d_designationwhoprofgroup_id`,
`d`.`designationwhoprofgroup_code` AS `d_designationwhoprofgroup_code`,
`d`.`designationwhoprofgroup_name` AS `d_designationwhoprofgroup_name`,
`d`.`group_code` AS `d_group_code`,
`d`.`is_healthworker` AS `d_is_healthworker`,
`d`.`is_active` AS `d_is_active`,
`p`.`religiousgroup_id` AS `p_religiousgroup_id`,
`p`.`is_active` AS `p_is_active`,
`s`.`is_active` AS `s_is_active`,
`f`.`id` AS `f_id`
FROM
(
(
(
`dghshrml4_sanctionedposts` `s`
LEFT JOIN `dghshrml4_providers` `p` ON (
(
`p`.`sanctionedpost_id` = `s`.`id`
)
)
)
LEFT JOIN `dghshrml4_designations` `d` ON (
(
`s`.`designation_id` = `d`.`id`
)
)
)
LEFT JOIN `dghshrml4_facilities` `f` ON (
(`s`.`facility_id` = `f`.`id`)
)
)
WHERE
isnull(`s`.`deleted_at`)
|
Comments (0)
You can clone a snippet to your computer for local editing. Learn more.