<?php

/*
 * Son of Service
 * Copyright (C) 2003-2009 by Andrew Ziem.  All rights reserved.
 * Licensed under the GNU General Public License.  See COPYING for details.
 *
 * $Id: summary.php,v 1.16 2009/02/12 04:11:20 andrewziem Exp $
 *
 */

require_once(SOS_PATH .'functions/table.php');

if (preg_match('/summary.php/i', $_SERVER['PHP_SELF']))
{
    die('Do not access this page directly.');
}


function volunteer_summary()
{
    global $volunteer, $db;
    
    
    $vid = intval($_GET['vid']);   
    
    if (!has_permission(PC_VOLUNTEER, PT_READ, $vid, NULL))
    {
	save_message(MSG_SYSTEM_ERROR, _("Insufficient permissions."), __FILE__, __LINE__);
	return FALSE;
    }    

    // show contact card

    $contact_card = '';
    if ($volunteer['first'] or $volunteer['last'])
    {
	$contact_card .= $volunteer['prefix'].' '.$volunteer['first'].' '.$volunteer['middle'].' '.$volunteer['last'].' '.$volunteer['suffix'].' (#'.$volunteer['volunteer_id'].")\n";
    }
    if (!empty($volunteer['organization']))
    {
	$contact_card .= $volunteer['organization']."\n";
    }
    if (strlen(trim($volunteer['street'])))
    {
	$contact_card .= $volunteer['street'] . "\n";
    }
    $address = $volunteer['city'].', '.$volunteer['state'].' '.$volunteer['postal_code'].' '.$volunteer['country']." \n";
    if (strlen(trim($address))>2)
    {
	$contact_card .= $address;
    }
    // get phone numbers
    $sql = "SELECT number, memo FROM phone_numbers WHERE volunteer_id = $vid";
    $phone_result = $db->Execute($sql);
    if (!$phone_result)
    {
	die_message(MSG_SYSTEM_ERROR, _("Error querying database."), __FILE__, __LINE__, $sql);
    }
    
    while (!$phone_result->EOF)
    {
	$phone = $phone_result->fields;
	$contact_card .= _("Phone:").' '.$phone['number'].' '.$phone['memo'] ."\n";
	$phone_result->MoveNext();
    }

    echo ("<P>".nl2br($contact_card)."</P>\n");

    // show notes

    // code to consolidate notes and work history:
    // select concat(year(date),'-',month(date),'-',dayofmonth(date)) as date, work_id, 'workhistory', concat(hours,' ',if(isnull(memo),'',memo)) from work union select year(dt), month(dt), dayofmonth(dt), note_id, 'notes', message from notes;

    include_once('notes.php');

    volunteer_view_notes(TRUE);

    // show work history

    include_once('workhistory.php');
    
    $dtd = new DataTableDisplay();
    
    $fields['hours_life']['label'] = _("Hours: Lifetime");
    $fields['hours_ytd']['label'] = _("Hours: Year to date");
    $fields['hours_ly']['label'] = _("Hours: Last year");    
//    $fields['last_volunteered']['label'] = _("Last volunteered");
//    $fields['last_volunteered']['type'] = TT_DATE;
    
    $sql = "SELECT hours_life, hours_ytd, hours_ly FROM volunteers WHERE volunteer_id =  $vid";
    
    $result = $db->Execute($sql);
    
    if (!$result)
    {
        die_message(MSG_SYSTEM_ERROR, _("Error querying database."), __FILE__, __LINE__, $sql);	
    }
    
    if (1 == $result->RecordCount() and $result->fields['hours_life'] > 0)
    {
	echo ("<H3>Work history</H3>");
	
	$dtd->setHeaders($fields);
	$dtd->begin();
	$dtd->addRow($result->fields);
	$dtd->end();
    }

    // show skills

    include_once('skills.php');

    volunteer_view_skills(TRUE);

    // show availability

    include_once('availability.php');

    volunteer_view_availability(TRUE);

    // show custom fields

    // todo

    // show relationships

    include_once('relationships.php');

    relationships_view(TRUE);

}

?>