search

mateipavel-github / ajutorspitale-backend

0 stars 0 forks source link

Export: authenticated Needs_volunteers should be able to export data in csv format #24

Open dira opened 4 years ago

dira commented 4 years ago

Only processed and validated requests

Here's the query I'm using right now:

select sum(quantity) as 'nr', metadata_need_types.label as 'ce',
help_requests.medical_unit_name as "nume unitate (din cerere)", metadata_medical_unit_types.label as Tip, medical_units.name as 'nume oficial spital de stat',

 help_requests.name as 'contact', help_requests.job_title as 'functie', help_requests.phone_number as 'telefon din cerere', help_requests.created_at as 'primita la', help_requests.updated_at as 'ultima actualizare', medical_units.address as 'adresa gasita de un voluntar', medical_units.website, medical_units.facebook_page,
 metadata_counties.label as Județ, 
 CONCAT('https://cereri.ajutorspitale.ro/admin/request/', help_request_id) as Link from help_request_change_needs 
 INNER JOIN help_request_changes on help_request_change_id = help_request_changes.id
 INNER JOIN help_requests ON help_request_changes.help_request_id = help_requests.id 
 INNER JOIN metadata_counties ON metadata_counties.id = help_requests.county_id 
 INNER JOIN metadata_medical_unit_types ON metadata_medical_unit_types.id = help_requests.medical_unit_type_id 
 INNER JOIN metadata_need_types ON metadata_need_types.id = help_request_change_needs.need_type_id
 LEFT OUTER JOIN medical_units on help_requests.medical_unit_id = medical_units.id
 where 
  help_requests.status IN (1, 41)
   group by need_type_id, help_request_id 
   order by 'ce' desc