avniproject / calcutta-kids

0 stars 0 forks source link

Report card colours to be updated #196

Open mahalakshme opened 3 weeks ago

mahalakshme commented 3 weeks ago

Need:

AC:

Details to identify the card with issues and colour compatibility:

Query used:

select dscm.id as dashboard_section_card_mapping_id, o.name as org_name, ds.name as dashboard_section_name, rc.name as report_card_name, rc.colour as report_card_color
from dashboard_section ds
         inner join dashboard_section_card_mapping dscm on ds.id = dscm.dashboard_section_id
         inner join report_card rc on dscm.card_id = rc.id
         inner join organisation o on ds.organisation_id = o.id where
    o.name in ('JSCS', 'Shelter', 'Goonj', 'Adolescent Sewa Rural', 'Swadhar swayam', 'CTRITH IPH', 'Sakhi App', 'Calcutta Kids', 'Ward Implementation and Management Committee - AKRSP','Periodshala', 'APF Odisha','PoWER', 'Mobile Creches', 'JSS', 'Chashma', 'Yenepoya', 'JSS Singrauli', 'Lend a Hand India', 'JSSCP')
                                     and rc.is_voided=false and dscm.is_voided= false and ds.is_voided=false;

and used the results in a HTML to identify colour compatibility