function civicrm_api3_group_contact_getstat ($params) {
$sql = "SELECT count(*) as total,civicrm_group.id, civicrm_group.name
FROM civicrm_group_contact, civicrm_group
WHERE civicrm_group_contact.group_id = civicrm_group.id
GROUP BY civicrm_group.id";
return _civicrm_api3_basic_getsql ($params,$sql);
}
function civicrm_api3_tag_getstat ($params) {
$sql = "SELECT count(*) as total, civicrm_tag.id, civicrm_tag.name, civicrm_tag.parent_id, description
FROM civicrm_tag, civicrm_entity_tag
WHERE civicrm_tag.id = civicrm_entity_tag.tag_id AND entity_table = 'civicrm_contact'
GROUP BY civicrm_tag.id";
return _civicrm_api3_basic_getsql ($params,$sql);
}
function civicrm_api3_participant_getstat ($params) {
$sql="SELECT COUNT(id),DATE(register_date) as register from civicrm_participant group by DATE(register_date)";
return _civicrm_api3_basic_getsql ($params,$sql);
}
