array('publish', 'private') ) ,false ); //write_log("size of meetings:" . sizeof($meetings)); $cellcontents = array(); foreach ($meetings as $meeting) { @$parts = explode(', ', $meeting['formatted_address']); $day = $meeting['day']; $formatted_day = ""; if($day == 0){ $formatted_day = "Sunday"; }elseif ($day == 1){ $formatted_day = "Monday"; }elseif ($day == 2){ $formatted_day = "Tuesday"; }elseif ($day == 3){ $formatted_day = "Wednesday"; }elseif ($day == 4){ $formatted_day = "Thursday"; }elseif ($day == 5){ $formatted_day = "Friday"; }elseif ($day == 6){ $formatted_day = "Saturday"; }else{ $formatted_day = "Unknown Day"; } //cobble the meeting text together $meetingtext = ""; $meetingtext .= "" . $meeting['region'] . " "; $meetingtext .= $meeting['sub_region'] . ", "; $meetingtext .= $meeting['time_formatted'] . ", "; $meetingtext .= "(" . implode (',' , $meeting['types']) . ") "; $meetingtext .= @$meeting['name'] . ". "; $meetingtext .= @$meeting['location'] . ". "; $meetingtext .= @$parts[0] . ". "; $meetingtext .= @$meeting['notes'] . ". "; $meetingtext .= @$meeting['location_notes'] . ". "; //let's strip carriage returns that might be in location notes and notes $meetingtext = str_replace("\r", "", $meetingtext); $meetingtext = str_replace("\n", "", $meetingtext); $meetingtext = str_replace("\t", "", $meetingtext); $thismeeting = array( 'text' => $meetingtext, 'day' => $meeting['day'], 'formatted_day' => $formatted_day ); //put this meeting in array array_push($cellcontents, $thismeeting); } return $cellcontents; }