I have checked the correctness of the query and they are exact. However have noticed that inside the get_list_view_data function of the Meeting.php file my variable does not assume any value, and therefore inside the column "town" of the dashlets doesn't appear nothing.Someone can tell me some other file must modify? My variable is formed by the column billing_address_city and billing_address_state of the accounts table or primary_address_city and primary_address_state of the Leads and Accounts table.
Bye
PHP Code:
function get_list_view_data() {
$meeting_fields = $this->get_list_view_array();
global $app_list_strings, $focus, $action, $currentModule, $image_path;
if(isset($this->parent_type))
$meeting_fields['PARENT_MODULE'] = $this->parent_type;
if($this->status == "Planned") {
//cn: added this if() to deal with sequential Closes in Meetings. this is a hack to a hack(formbase.php->handleRedirect)
if(empty($action)) { $action = "index"; }
$meeting_fields['SET_COMPLETE'] = "<a href='index.php?return_module=$currentModule&return_action=$action&return_id=$this->id&action=EditView&status=Held&module=Meetings&record=$this->id&status=Held'>".get_image($image_path."close_inline","alt='Close' border='0'")."</a>";
}
global $timedate;
$today = gmdate('Y-m-d H:i:s', time());
$nextday = gmdate('Y-m-d', time() + 3600*24);
$mergeTime = $meeting_fields['DATE_START']; //$timedate->merge_date_time($meeting_fields['DATE_START'], $meeting_fields['TIME_START']);
$date_db = $timedate->to_db($mergeTime);
if($date_db < $today ) {
$meeting_fields['DATE_START']= "<font class='overdueTask'>".$meeting_fields['DATE_START']."</font>";
}else if($date_db < $nextday) {
$meeting_fields['DATE_START'] = "<font class='todaysTask'>".$meeting_fields['DATE_START']."</font>";
} else {
$meeting_fields['DATE_START'] = "<font class='futureTask'>".$meeting_fields['DATE_START']."</font>";
}
$meeting_fields['CONTACT_ID'] = empty($this->contact_id) ? '' : $this->contact_id;
//echo("<p>Indirizzo".$this->mia_variabile."</p>");
$meeting_fields['MIA_VARIABILE'] = $this->mia_variabile;
//echo("<p>".$this->parent_name."</p>");
$meeting_fields['PARENT_NAME'] = $this->parent_name;
return $meeting_fields;
}

Originally Posted by
arasdeveloper Hi to everybody, have inserted a new field inside the dashlet "my meetings" which shows the town and the company's province. To extract the data of my interest I have modified the modules/Meetings/Meeting.php file, but it is not shown not at all inside the dashlet. If to the cheque variable however one presses it is shown. To extract this information use the same instructions used to obtain the company's name from the 'Leads'' tables, Contacts' and ' Accounts'. Must I produce a few modifications also in other files?
Thank you.
Bookmarks