Database connector for contacts view

💬 General Discussion
10

@GraemeMac
You can make special field in module Contacts and one of parameters write: ‘function’. For example there is my code for write age of contact.
Field in custom/Extension/modules/Contacts/Ext/Vardefs/age_years.php of Contacts module:

 $dictionary['Lead']['fields']['age_years']  = 
  array (
    'name' => 'age_years',
    'vname' => 'LBL_AGE_YEARS',
    'type' => 'int',
    'len' => '3',
    'comment' => '',
    'importable' => true,
    'function' => array('name' => 'get_age_years', 'returns' => 'html', 'onListView' => 'true', 'include' => 'custom/modules/Contacts/Contacts_fields_functions.php'),
    'studio' => 'false',
    'source' => 'non-db',
  );

Function in custom/modules/Contacts/Contacts_fields_functions.php

<?php
function get_age_years($focus, $field, $value, $view) {
    if ($view == 'ListView') {
        if (isset ($focus['ID']) && !empty($focus['ID'])) {
            $contact = new Contact();
            $contact->retrieve($focus['ID']);
            if (!empty($contact->birthdate)) {
                $age_years=ageYears($contact->birthdate);
            }else{
                $age_years = '-';
            }
            return $age_years;
        } else {
            return "?";
        }
    } elseif ($view == 'DetailView') {
            if (!empty($focus->birthdate)) {
                $age_years=ageYears($focus->birthdate);
            }else{
                $age_years = '-';
            }
            return $age_years;
    }
}
function ageYears ($birthdate){
    global $timedate;
    $birthdate_date = date_create_from_format($timedate->get_date_format(),$birthdate);
    $age_years = date("Y") - $birthdate_date->format("Y");
    if (date("md") < $birthdate_date->format("md")) {
        $age_years = $age_years - 1;
    }
    if ($age_years < 0 || $age_years > 999){
        $age_years = '-';
    }
    return $age_years;
}

And add the field ‘age_years’ to custom/modules/Contacts/metadata/listviewdefs.php

...
  'AGE_YEARS' => 
  array (
    'width' => '5%',
    'label' => 'LBL_AGE_YEARS',
    'default' => true,
    'sortable' => false,
  ),
...
2 Likes