True,
'ht_update' => True,
'act_list' => True,
'act_view' => True,
'act_update' => True,
'par_view' => True,
'ppi_view' => True,
'ppi_update' => True,
'ppi_sched' => True,
'int_view' => True,
'int_update' => True,
'int_sched' => True,
'vis_sched' => True,
'vis_view' => True,
'vis_update' => True,
'att_view' => True,
'att_update' => True,
'dir_view' => True,
'org_view' => True,
'schedule' => True,
'admin' => True,
'email_appt' => True,
'send_ical_appt' => True,
'assign_view' => True,
'assign_update' => True,
);
function eq()
{
$this->default_ht_num_months = 3;
$this->default_ppi_num_months = 3;
$this->default_ppi_num_years = 0;
$this->default_int_num_quarters = 1;
$this->default_int_num_years = 0;
$this->default_att_num_quarters = 1;
$this->default_vis_num_years = 1;
$this->upload_target_path = "/home/users/eqpres/eq_data/";
$this->script_path = "/usr/share/phpgroupware/eq/";
$this->db = $GLOBALS['phpgw']->db;
$this->db2 = $this->db;
$this->db3 = $this->db;
$this->nextmatchs = CreateObject('phpgwapi.nextmatchs');
$this->t = $GLOBALS['phpgw']->template;
$this->account = $GLOBALS['phpgw_info']['user']['account_id'];
$this->grants = $GLOBALS['phpgw']->acl->get_grants('eq');
$this->grants[$this->account] = PHPGW_ACL_READ + PHPGW_ACL_ADD + PHPGW_ACL_EDIT + PHPGW_ACL_DELETE;
$this->jscal = CreateObject('phpgwapi.jscalendar'); // before phpgw_header() !!!
$this->cal_options = 'daFormat : "%Y-%m-%d",
ifFormat : "%Y-%m-%d",
mondayFirst : false,
weekNumbers : false';
$GLOBALS['phpgw_info']['flags']['app_header'] = 'Elders Quorum Tools';
$GLOBALS['phpgw']->common->phpgw_header();
$this->current_day = `date '+%d'`;
$this->current_day = $this->current_day-0; // Make it numeric
$this->current_month = `date '+%m'`;
$this->current_month = $this->current_month-0; // Make it numeric
$this->current_year = `date '+%Y'`;
$this->current_year = $this->current_year-0; // Make it numeric
echo parse_navbar();
$this->display_app_header();
}
function save_sessiondata()
{
}
function display_app_header()
{
$this->t->set_file(array('eq_header' => 'header.tpl'));
if (isset($phpgw_info['user']['preferences']['eq']['eq_font']))
{
$font = $phpgw_info['user']['preferences']['eq']['eq_font'];
}
else
{
$font = 'Arial';
}
$this->t->set_var('bg_color',$phpgw_info['theme']['th_bg']);
$this->t->set_var('font',$font);
$link_data['menuaction'] = 'eq.eq.ht_view';
$this->t->set_var('link_hometeaching',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_hometeaching','HomeTeaching');
$link_data['menuaction'] = 'eq.eq.act_list';
$this->t->set_var('link_activity',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_activity','Activities');
$link_data['menuaction'] = 'eq.eq.assign_view';
$this->t->set_var('link_assignment',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_assignment','Assignments');
$link_data['menuaction'] = 'eq.eq.par_view';
$this->t->set_var('link_participation',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_participation','Participation');
$link_data['menuaction'] = 'eq.eq.ppi_view';
$this->t->set_var('link_ppi',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_ppi','PPIs');
$link_data['menuaction'] = 'eq.eq.int_view';
$this->t->set_var('link_int',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_int','Interviews');
$link_data['menuaction'] = 'eq.eq.vis_view';
$this->t->set_var('link_visit',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_visit','Visits');
$link_data['menuaction'] = 'eq.eq.att_view';
$this->t->set_var('link_attendance',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_attendance','Attendance');
$link_data['menuaction'] = 'eq.eq.dir_view';
$this->t->set_var('link_dir',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_dir','Directory');
$link_data['menuaction'] = 'eq.eq.org_view';
$this->t->set_var('link_org',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_org','Callings');
$link_data['menuaction'] = 'eq.eq.admin';
$this->t->set_var('link_admin',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_admin','Admin');
$link_data['menuaction'] = 'eq.eq.schedule';
$this->t->set_var('link_schedule',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_schedule','Scheduling');
$this->t->pparse('out','eq_header');
}
function ht_view()
{
$this->t->set_file(array('ht_view_t' => 'ht_view.tpl'));
$this->t->set_block('ht_view_t','district_list','list');
$this->t->set_var('linkurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ht_view'));
$num_months = get_var('num_months',array('GET','POST'));
if($num_months == '') { $num_months = $this->default_ht_num_months; }
$this->t->set_var('num_months',$num_months);
$this->t->set_var('lang_filter','Filter');
if($num_months == 1) { $this->t->set_var('lang_num_months','Month of History'); }
else { $this->t->set_var('lang_num_months','Months of History'); }
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ht_view'));
$this->t->set_var('title','Hometeaching');
$sql = "SELECT * FROM eq_district where valid=1 ORDER BY district ASC";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record())
{
$districts[$i]['district'] = $this->db->f('district');
$districts[$i]['name'] = $this->db->f('name');
$districts[$i]['supervisor'] = $this->db->f('supervisor');
$i++;
}
$sql = "SELECT * FROM eq_elder where valid=1 ORDER BY elder ASC";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record())
{
$elder_id[$i] = $this->db->f('elder');
$elder_name[$i] = $this->db->f('name');
$elder_phone[$elder_id[$i]] = $this->db->f('phone');
$i++;
}
array_multisort($elder_name, $elder_id);
// Make an array mapping elder_ids to elder_names
for($i=0; $i < count($elder_id); $i++) {
$id = $elder_id[$i];
$elders[$id] = $elder_name[$i];
}
$sql = "SELECT * FROM eq_aaronic where valid=1 ORDER BY aaronic ASC";
$this->db->query($sql,__LINE__,__FILE__);
while ($this->db->next_record())
{
$aaronic_id = $this->db->f('aaronic');
$aaronic[$aaronic_id]['name'] = $this->db->f('name');
$aaronic[$aaronic_id]['phone'] = $this->db->f('phone');
}
$total_families = 0;
$this->nextmatchs->template_alternate_row_color(&$this->t);
for ($i=0; $i < count($districts); $i++) {
$this->t->set_var('district_number',$districts[$i]['district']);
$this->t->set_var('district_name',$districts[$i]['name']);
$supervisor = $districts[$i]['supervisor'];
$unique_companionships='';
// Select all the unique companionship numbers for this district
$sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district'];
$this->db->query($sql,__LINE__,__FILE__);
$j=0;
while ($this->db->next_record())
{
$unique_companionships[$j]['companionship'] = $this->db->f('companionship');
$j++;
}
$comp_width=450; $visit_width=25; $table_width=$comp_width + $num_months*$visit_width;
$table_data=""; $num_companionships = 0; $num_families = 0;
for($m=$num_months; $m >= 0; $m--) { $visits[$m] = 0; }
for ($j=0; $j < count($unique_companionships); $j++) {
$companion_table_entry = "";
// Select all the companions in each companionship
$sql = "SELECT * FROM eq_companionship where valid=1 and ".
"companionship=". $unique_companionships[$j]['companionship'];
$this->db->query($sql,__LINE__,__FILE__);
while ($this->db->next_record())
{
// Get this companions information
if($companion_table_entry != "") { $companion_table_entry .= " / "; }
$companionship = $this->db->f('companionship');
$elder_id = $this->db->f('elder');
$aaronic_id = $this->db->f('aaronic');
if($elder_id) {
$name = $elders[$elder_id];
$phone = $elder_phone[$elder_id];
}
else if($aaronic_id) {
$name = $aaronic[$aaronic_id]['name'];
$phone = $aaronic[$aaronic_id]['phone'];
}
$companion_table_entry .= "$name $family_name Family ";
// Find out how many times Visits were performed by this companionship
// in the past $num_months for this Family
$header_row="Families $month ";
}
}
else {
$visits[$m]++; $total_visits[$m]++;
$table_data .= " ";
}
}
$table_data .= "$num_families Families $visits[$m] $total_families Total Families $total_visits[$m] / "; }
$companionship = $this->db->f('companionship');
$elder_id = $this->db->f('elder');
$aaronic_id = $this->db->f('aaronic');
if($elder_id) {
$name = $elders[$elder_id];
$phone = $elder_phone[$elder_id];
}
else if($aaronic_id) {
$name = $aaronic[$aaronic_id]['name'];
$phone = $aaronic[$aaronic_id]['phone'];
}
$companion_table_entry .= "$name $family_name Family ";
$header_row="Families $month ';
$table_data .= ' ';
} else if($this->db2->f('visited') == 'n') {
$table_data .= '';
$table_data .= ' ';
} else {
$table_data .= '';
$table_data .= ' ';
}
}
else {
$value .= "/";
$table_data .= '';
$table_data .= ' ';
}
}
$table_data .= "$num_families Families $visits "); }
else { $this->t->set_var('table_sep',""); }
if(($i) % 3 == 0) { $this->nextmatchs->template_alternate_row_color(&$this->t); }
$this->t->fp('list','part_list',True);
}
$this->t->pfp('out','act_view_t');
$this->save_sessiondata();
}
function act_update()
{
$this->t->set_file(array('form' => 'act_update.tpl'));
$this->t->set_block('form','elder_list','list');
$this->t->set_block('form','add','addhandle');
$this->t->set_block('form','edit','edithandle');
$this->t->set_var('lang_done','Done');
$action = get_var('action',array('GET','POST'));
$this->t->set_var('done_action',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.act_list'));
$activity['activity'] = intval(get_var('activity',array('GET','POST')));
if($action == 'save')
{
$activity['assignment'] = $this->db->db_addslashes(get_var('assignment',array('POST')));
$activity['date'] = $this->db->db_addslashes(get_var('date',array('POST')));
$activity['notes']= $this->db->db_addslashes(get_var('notes',array('POST')));
$this->db->query("UPDATE eq_activity set " .
" assignment='" . $activity['assignment'] .
"', date='" . $activity['date'] . "'" .
", notes='" . $activity['notes'] . "'" .
" WHERE activity=" . $activity['activity'],__LINE__,__FILE__);
// Delete all the elders who have particiapted in this activity
$this->db->query("DELETE from eq_participation where activity=".$activity['activity'],__LINE__,__FILE__);
// Re-add the elders who are checked as having participated in this activity
$elders = get_var('elder_name',array('POST'));
foreach ($elders as $elder)
{
$this->db->query("INSERT INTO eq_participation (elder,activity) "
. "VALUES (" . $elder . ",". $activity['activity'] . ")",__LINE__,__FILE__);
}
$this->act_list();
return false;
}
if($action == 'insert')
{
$activity['assignment'] = $this->db->db_addslashes(get_var('assignment',array('POST')));
$activity['date'] = $this->db->db_addslashes(get_var('date',array('POST')));
$activity['notes']= $this->db->db_addslashes(get_var('notes',array('POST')));
$this->db->query("INSERT INTO eq_activity (assignment,date,notes) "
. "VALUES ('" . $activity['assignment'] . "','"
. $activity['date'] . "','" . $activity['notes'] . "')",__LINE__,__FILE__);
$sql = "SELECT * FROM eq_activity WHERE assignment='".$activity['assignment']."' "
. " AND date='".$activity['date']."' AND notes='".$activity['notes']."'";
$this->db->query($sql,__LINE__,__FILE__);
if($this->db->next_record()) {
print "activity: " . $this->db->f('activity') . "';
$assignment_data.= ''.$name.' ';
}
$assignment_data.=' ';
$this->t->set_var('assignment_data',$assignment_data);
// Create elder selection boxes
$sql = "SELECT * FROM eq_elder";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record())
{
if($this->db->f('valid') == 1 || $action != 'add') {
$elder_name[$i] = $this->db->f('name');
$elder_id[$i] = $this->db->f('elder');
$elder_valid[$i] = $this->db->f('valid');
$i++;
}
}
array_multisort($elder_name, $elder_id, $elder_valid);
$j=0;
for ($i=0; $i < count($elder_id); $i++)
{
//$this->nextmatchs->template_alternate_row_color(&$this->t);
$sql = "SELECT * FROM eq_participation where activity=". $activity['activity'] . " AND elder=" . $elder_id[$i];
$this->db->query($sql,__LINE__,__FILE__);
if($this->db->next_record()) { $this->t->set_var('checked','checked'); $checked=1; }
else { $this->t->set_var('checked',''); $checked=0; }
if($checked || $elder_valid[$i] == 1) {
$this->t->set_var('elder_name',$elder_name[$i]);
$this->t->set_var('elder',$elder_id[$i]);
if(($j+1) % 3 == 0) { $this->t->set_var('table_sep'," "); }
else { $this->t->set_var('table_sep',""); }
if(($j) % 3 == 0) { $this->nextmatchs->template_alternate_row_color(&$this->t); }
$this->t->fp('list','elder_list',True);
$j++;
}
}
$this->t->set_var('lang_reset','Clear Form');
$this->t->set_var('lang_add','Add Activity');
$this->t->set_var('lang_save','Save Changes');
$this->t->set_var('edithandle','');
$this->t->set_var('addhandle','');
$this->t->pfp('out','form');
if($action == 'edit') { $this->t->pfp('addhandle','edit'); }
if($action == 'add') { $this->t->pfp('addhandle','add'); }
$this->save_sessiondata();
}
function assign_view()
{
$this->t->set_file(array('assign_view_t' => 'assign_view.tpl'));
$this->t->set_block('assign_view_t','assign_view','list');
$this->t->set_var('lang_name','Assignment Name');
$this->t->set_var('lang_code','Code');
$sql = "SELECT * FROM eq_assignment ORDER BY name ASC";
$this->db->query($sql,__LINE__,__FILE__);
$total_records = $this->db->num_rows();
$i = 0;
while ($this->db->next_record())
{
$assignment_list[$i]['assignment'] = $this->db->f('assignment');
$assignment_list[$i]['name'] = $this->db->f('name');
$assignment_list[$i]['code'] = $this->db->f('code');
$i++;
}
for ($i=0; $i < count($assignment_list); $i++)
{
$this->nextmatchs->template_alternate_row_color(&$this->t);
$this->t->set_var('name',$assignment_list[$i]['name']);
$this->t->set_var('code',$assignment_list[$i]['code']);
$link_data['menuaction'] = 'eq.eq.assign_update';
$link_data['assignment'] = $assignment_list[$i]['assignment'];
$link_data['action'] = 'edit';
$this->t->set_var('edit',$GLOBALS['phpgw']->link('/eq/index.php',$link_data));
$this->t->set_var('lang_edit','Edit');
$link_data['menuaction'] = 'eq.eq.assign_update';
$link_data['assignment'] = '0';
$link_data['action'] = 'add';
$this->t->set_var('add','');
$this->t->fp('list','assign_view',True);
}
$this->t->pfp('out','assign_view_t');
$this->save_sessiondata();
}
function assign_update()
{
$this->t->set_file(array('form' => 'assign_update.tpl'));
$this->t->set_block('form','add','addhandle');
$this->t->set_block('form','edit','edithandle');
$this->t->set_var('lang_done','Done');
$action = get_var('action',array('GET','POST'));
$this->t->set_var('done_action',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.assign_view'));
$assignment['assignment'] = intval(get_var('assignment',array('GET','POST')));
if($action == 'save')
{
$assignment['name'] = $this->db->db_addslashes(get_var('name',array('POST')));
$assignment['code'] = $this->db->db_addslashes(get_var('code',array('POST')));
$this->db->query("UPDATE eq_assignment set " .
" name='" . $assignment['name'] . "'" .
", code='" . $assignment['code'] . "'" .
" WHERE assignment=" . $assignment['assignment'],__LINE__,__FILE__);
$this->assign_view();
return false;
}
if($action == 'insert')
{
$assignment['name'] = $this->db->db_addslashes(get_var('name',array('POST')));
$assignment['code'] = $this->db->db_addslashes(get_var('code',array('POST')));
$this->db->query("INSERT INTO eq_assignment (name,code) "
. "VALUES ('" . $assignment['name'] . "','"
. $assignment['code'] . "')",__LINE__,__FILE__);
$this->assign_view();
return false;
}
if($action == 'add')
{
$assignment['assignment'] = 0;
$this->t->set_var('name','');
$this->t->set_var('code','');
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Adding New Assignment');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.assign_update&assignment='
. $assignment['assignment'] . '&action=' . 'insert'));
}
if($action == 'edit')
{
$sql = "SELECT * FROM eq_assignment WHERE assignment=" . $assignment['assignment'];
$this->db->query($sql,__LINE__,__FILE__);
$this->db->next_record();
$this->t->set_var('name', $this->db->f('name'));
$this->t->set_var('code', $this->db->f('code'));
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Editing Assignment');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.assign_update&assignment='
. $assignment['assignment'] . '&action=' . 'save'));
}
$this->t->set_var('lang_reset','Clear Form');
$this->t->set_var('lang_add','Add Assignment');
$this->t->set_var('lang_save','Save Changes');
$this->t->set_var('edithandle','');
$this->t->set_var('addhandle','');
$this->t->pfp('out','form');
if($action == 'edit') { $this->t->pfp('addhandle','edit'); }
if($action == 'add') { $this->t->pfp('addhandle','add'); }
$this->save_sessiondata();
}
function par_view()
{
$this->t->set_file(array('par_view_t' => 'par_view.tpl'));
$this->t->set_block('par_view_t','header_list','list1');
$this->t->set_block('par_view_t','elder_list','list2');
$sql = "SELECT * FROM eq_elder where valid=1";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record())
{
$elder_name[$i] = $this->db->f('name');
$elder_id[$i] = $this->db->f('elder');
$i++;
}
array_multisort($elder_name, $elder_id);
$sql = "SELECT * FROM eq_activity ORDER BY date DESC";
$this->db->query($sql,__LINE__,__FILE__);
$total_records = $this->db->num_rows();
$i = 0;
while ($this->db->next_record())
{
$activity_list[$i]['assignment'] = $this->db->f('assignment');
$activity_list[$i]['date'] = $this->db->f('date');
$activity_list[$i]['activity'] = $this->db->f('activity');
$i++;
}
$sql = "SELECT * FROM eq_assignment ORDER BY name ASC";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while($this->db->next_record())
{
$assignment_list[$i]['assignment'] = $this->db->f('assignment');
$assignment_list[$i]['name'] = $this->db->f('name');
$assignment_list[$i]['code'] = $this->db->f('code');
$i++;
}
$elder_width=270; $part_width=25; $assignment_width=50;
$total_width=$elder_width+$part_width;
for ($i=0; $i < count($assignment_list); $i++) {
$this->t->set_var('assignment_name',$assignment_list[$i]['name']);
$this->t->set_var('assignment_code',$assignment_list[$i]['code']);
$this->t->fp('list1','header_list',True);
$total_width += $assignment_width;
}
for ($i=0; $i < count($elder_id); $i++) {
$participated=0; $part_table = '';
$this->nextmatchs->template_alternate_row_color(&$this->t);
$this->t->set_var('elder_name',$elder_name[$i]);
for ($j=0; $j < count($assignment_list); $j++) {
$date = "0000-00-00"; $checkmark=0; $num_matches=0;
for ($k=0; $k < count($activity_list); $k++) {
if($assignment_list[$j]['assignment'] == $activity_list[$k]['assignment']) {
$sql = "SELECT * FROM eq_participation where "
. " activity=" . $activity_list[$k]['activity']
. " AND elder=" . $elder_id[$i];
$this->db->query($sql,__LINE__,__FILE__);
while($this->db->next_record()) {
if($activity_list[$k]['date'] > $date) {
$date = $activity_list[$k]['date'];
}
$checkmark=1;
$num_matches++;
$participated++;
}
}
}
if($checkmark) {
$part_table .= ' ';
}
}
if($participated) { $part_table .= ' '; }
$this->t->set_var('part_table',$part_table);
$this->t->fp('list2','elder_list',True);
}
$this->t->set_var('total_width',$total_width);
$this->t->set_var('elder_width',$elder_width);
$this->t->set_var('part_width',$part_width);
$this->t->set_var('act_width',$act_width);
$this->t->pfp('out','par_view_t');
$this->save_sessiondata();
}
function ppi_sched()
{
$this->t->set_file(array('ppi_sched_t' => 'ppi_sched.tpl'));
$this->t->set_block('ppi_sched_t','elder_list','elderlist');
$this->t->set_block('ppi_sched_t','appt_list','apptlist');
$action = get_var('action',array('GET','POST'));
$this->t->set_var('lang_save','Save Appt / Pri / Notes');
$this->t->set_var('lang_reset','Clear Changes');
$this->t->set_var('ppi_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_view'));
$this->t->set_var('ppi_link_title','Yearly PPIs');
$this->t->set_var('schedule_ppi_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_sched'));
$this->t->set_var('schedule_ppi_link_title','Schedule Yearly PPIs');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_sched&action=save'));
$this->t->set_var('title','Yearly PPI Scheduler');
$elder_width=500; $phone_width=25; $pri_width=10; $notes_width=128; $ppi_date_width=20;
$table_width=$elder_width + $phone_width + $pri_width + $notes_width + $ppi_date_width;
$header_row = "Elder Name Phone Priority Last PPI Scheduling Notes -E- Unable to locate EQ President in eq_presidency table Date Time Elder ";
$appt_table_data.= "$day_string ";
$appt_table_data.= "$time_string ";
$appt_table_data.= '';
$appt_table_data.= ''.$name.' ';
}
$appt_table_data.=' $name $phone ";
//$table_data.= "$ppi_pri ";
$table_data.= "";
$table_data.= '';
foreach(range(0,6) as $num) {
if($num == 0) { $num = 1; } else {$num = $num*5; }
if($ppi_pri == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= "$date ";
$table_data.= '$name $phone ";
$completed_data.= "$date $ppi_notes ";
$completed_data.= 'Elder Name Phone Date PPI Notes Elders $year ";
$totals_data.= "Total Elders with yearly PPIs completed: $elders_with_yearly_ppi / $total_elders ";
$totals_data.= "Percentage: $percent% ";
$this->t->set_var('totals',$totals_data);
$this->t->set_var('totals_header_row',$totals_header_row);
$this->t->set_var('totals_table_width',$totals_table_width);
$this->t->pfp('out','ppi_sched_t');
$this->save_sessiondata();
}
function int_sched()
{
$this->t->set_file(array('int_sched_t' => 'int_sched.tpl'));
$this->t->set_block('int_sched_t','elder_list','elderlist');
$this->t->set_block('int_sched_t','appt_list','apptlist');
$action = get_var('action',array('GET','POST'));
$this->t->set_var('lang_save','Save Appt / Pri / Notes');
$this->t->set_var('lang_reset','Clear Changes');
$this->t->set_var('int_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.int_view'));
$this->t->set_var('int_link_title','Hometeaching Interviews');
$this->t->set_var('schedule_int_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.int_sched'));
$this->t->set_var('schedule_int_link_title','Schedule Hometeaching Interviews');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.int_sched&action=save'));
$this->t->set_var('title','Hometeaching Interviews Scheduler');
$elder_width=500; $phone_width=25; $pri_width=10; $notes_width=128; $int_date_width=20;
$table_width=$elder_width + $phone_width + $pri_width + $notes_width + $int_date_width;
$header_row = "Elder Name Phone Priority Last Interview Scheduling Notes Date Time Elder ";
$appt_table_data.= "$day_string ";
$appt_table_data.= "$time_string ";
$appt_table_data.= '';
$appt_table_data.= ''.$name.' ';
}
$appt_table_data.=' $name $phone ";
$completed_data.= "$date $int_notes ";
$completed_data.= '$name $phone ";
$table_data.= "";
$table_data.= '';
foreach(range(0,6) as $num) {
if($num == 0) { $num = 1; } else {$num = $num*5; }
if($int_pri == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= "$date ";
$table_data.= '$name $phone ";
$completed_data.= "$date $int_notes ";
$completed_data.= 'Elder Name Phone Date Interview Notes Elders $year ";
$totals_data.= "Total Companionships with interviews completed: $comps_with_quarterly_int / $total_comps ";
$totals_data.= "Percentage: $percent% ";
$this->t->set_var('totals',$totals_data);
$this->t->set_var('totals_header_row',$totals_header_row);
$this->t->set_var('totals_table_width',$totals_table_width);
$this->t->pfp('out','int_sched_t');
$this->save_sessiondata();
}
function vis_sched()
{
$this->t->set_file(array('vis_sched_t' => 'vis_sched.tpl'));
$this->t->set_block('vis_sched_t','family_list','familylist');
$this->t->set_block('vis_sched_t','appt_list','apptlist');
$action = get_var('action',array('GET','POST'));
$this->t->set_var('lang_save','Save Appt / Pri / Notes');
$this->t->set_var('lang_reset','Clear Changes');
$this->t->set_var('vis_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_view'));
$this->t->set_var('vis_link_title','View Yearly Visits');
$this->t->set_var('schedule_vis_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_sched'));
$this->t->set_var('schedule_vis_link_title','Schedule Yearly Visits');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_sched&action=save'));
$this->t->set_var('title','EQ Presidency Yearly Visit Scheduler');
$family_width=500; $phone_width=40; $pri_width=10; $notes_width=128; $visit_date_width=20;
$table_width=$family_width + $phone_width + $pri_width + $notes_width + $visit_date_width;
$header_row = "Family Name Phone Priority Last Visit Scheduling Notes Date Time Family -E- Unable to locate EQ Presidency in eq_presidency table ";
$appt_table_data.= "$day_string ";
$appt_table_data.= "$time_string ";
$appt_table_data.= '';
$appt_table_data.= ''.$name.' Family ';
}
$appt_table_data.=' $name Family $phone ";
$table_data.= "";
$table_data.= '';
foreach(range(0,6) as $num) {
if($num == 0) { $num = 1; } else {$num = $num*5; }
if($vis_pri == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= "$date ";
$table_data.= '$name Family $phone ";
$completed_data.= "$date $vis_notes ";
$completed_data.= 'Family Name Phone Date Visit Notes Families $year ";
$totals_data.= "Total Families with yearly Visits completed: $families_with_yearly_visit / $total_families ";
$totals_data.= "Percentage: $percent% ";
$this->t->set_var('table_width',$table_width);
$this->t->set_var('header_row',$header_row);
$this->t->set_var('table_data',$table_data);
$this->t->set_var('totals_header_row',$totals_header_row);
$this->t->set_var('totals_table_width',$totals_table_width);
$this->t->set_var('completed_header_row',$completed_header_row);
$this->t->set_var('completed_table_width',$completed_table_width);
$this->t->set_var('completed',$completed_data);
$this->t->set_var('totals',$totals_data);
$this->t->fp('familylist','family_list',True);
$this->t->fp('apptlist','appt_list',True);
$this->t->pfp('out','vis_sched_t');
$this->save_sessiondata();
}
function ppi_view()
{
$this->t->set_file(array('ppi_view_t' => 'ppi_view.tpl'));
$this->t->set_block('ppi_view_t','district_list','list');
$this->t->set_var('linkurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_view'));
$num_months = get_var('num_months',array('GET','POST'));
if($num_months == '') { $num_months = $this->default_ppi_num_months; }
$this->t->set_var('num_months',$num_months);
if($num_months == 1) { $this->t->set_var('lang_num_months','Month of History'); }
else { $this->t->set_var('lang_num_months','Months of History'); }
$this->t->set_var('lang_filter','Filter');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_view'));
$this->t->set_var('ppi_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_view'));
$this->t->set_var('ppi_link_title','Yearly PPIs');
$this->t->set_var('schedule_ppi_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_sched'));
$this->t->set_var('schedule_ppi_link_title','Schedule Yearly PPIs');
$this->t->set_var('title','Yearly PPIs');
$num_months = get_var('num_months',array('GET','POST'));
if($num_months == '') { $num_months = $this->default_ppi_num_years; }
$this->t->set_var('num_months',$num_months);
if($num_months == 1) { $this->t->set_var('lang_num_months','Year of History'); }
else { $this->t->set_var('lang_num_months','Years of History'); }
$sql = "SELECT * FROM eq_presidency where president=1 and valid=1";
$this->db->query($sql,__LINE__,__FILE__);
if($this->db->next_record()) {
$president_name = $this->db->f('name');
$interviewer = $this->db->f('elder');
$eqpresppi = 1;
} else {
print "-E- Unable to locate EQ President in eq_presidency table Elder Name $year $name "; }
}
$table_data .= "$total_elders Elders $ppis[$m] $name Companionship $month "; }
}
$table_data .= "$num_companionships Companionships $quarter_total $total_companionships Total Comps $quarter_total "); }
else { $this->t->set_var('table_sep',""); }
if(($i) % 3 == 0) { $this->nextmatchs->template_alternate_row_color(&$this->t); }
$this->t->fp('list2','family_list',True);
}
$this->t->pfp('out','vis_view_t');
$this->save_sessiondata();
}
function vis_update()
{
$this->t->set_file(array('form' => 'vis_update.tpl'));
$this->t->set_block('form','add','addhandle');
$this->t->set_block('form','edit','edithandle');
$this->t->set_var('done_action',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_view'));
$this->t->set_var('readonly','');
$this->t->set_var('disabled','');
$action = get_var('action',array('GET','POST'));
$visit = get_var('visit',array('GET','POST'));
$family = get_var('family',array('GET','POST'));
$name = get_var('name',array('GET','POST'));
$date = get_var('date',array('GET','POST'));
$notes = get_var('notes',array('GET','POST'));
$companionship = 0;
if($action == 'save')
{
$notes = $this->db->db_addslashes(get_var('notes',array('POST')));
$this->db->query("UPDATE eq_visit set " .
" date='" . $date . "'" .
", notes='" . $notes . "'" .
" WHERE visit=" . $visit,__LINE__,__FILE__);
$this->vis_view();
return false;
}
if($action == 'insert')
{
$notes = $this->db->db_addslashes(get_var('notes',array('POST')));
$this->db->query("INSERT INTO eq_visit (family,companionship,date,notes) "
. "VALUES ('" . $family . "','" . $companionship . "','"
. $date . "','" . $notes . "')",__LINE__,__FILE__);
$this->vis_view();
return false;
}
if($action == 'add')
{
$this->t->set_var('cal_date',$this->jscal->input('date','','','','','','',$this->cal_options));
$this->t->set_var('family', $family);
$this->t->set_var('visit', '');
$this->t->set_var('name', $name);
$this->t->set_var('date','');
$this->t->set_var('notes','');
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Adding New Visit');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_update&family='
. $family . '&action=' . 'insert'));
}
if($action == 'edit' || $action == 'view')
{
$sql = "SELECT * FROM eq_visit WHERE visit=".$visit;
$this->db->query($sql,__LINE__,__FILE__);
$this->db->next_record();
$this->t->set_var('visit',$visit);
$this->t->set_var('name',$name);
$this->t->set_var('family', $family);
$this->t->set_var('date',$this->db->f('date'));
$this->t->set_var('notes',$this->db->f('notes'));
}
if($action == 'edit')
{
$this->t->set_var('cal_date',$this->jscal->input('date',$date,'','','','','',$this->cal_options));
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Editing Visit');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_update&visit='
. $visit . '&action=' . 'save'));
}
if($action == 'view')
{
$date = $this->db->f('date');
$this->t->set_var('cal_date','$cur_month $cur_year ';
}
}
$this->t->set_var('att_table',$att_table);
$this->t->fp('list3','elder_list',True);
}
$this->t->set_var('total_width',$total_width);
$this->t->set_var('elder_width',$elder_width);
$this->t->set_var('att_width',$att_width);
# Now calculate attendance for these months
$attendance_str = "";
$nonattendance_str = "";
$aveattendance_str = "";
$avenonattendance_str = "";
$num_months=0;
$ave_total_attended=0;
ksort($attendance);
foreach($attendance as $att => $value) {
$total_attended = $attendance[$att];
$ave_total_attended += $attendance[$att]; $num_months++;
$percent = ceil(($total_attended / $total_elders)*100);
$attendance_str.="$total_attended ($percent%) $total_nonattended ($percent%) $total_attended ($percent%) $total_attended ($percent%) Date Time Elder Family ";
// Date selection
$table_data.= '';
$table_data.= $this->jscal->input('sched['.$presidency.']['.$appointment.'][date]',$date,'','','','','',$this->cal_options);
$table_data.= ' ';
// Hour & Minutes selection
$table_data.= "";
$table_data.= '';
foreach(range(1,12) as $num) {
if($hour == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= ' : ';
$table_data.= '';
foreach(range(0,3) as $num) {
$num = $num * 15; if($num == 0) { $num = "00"; }
if($minute == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= '';
if($pm == 0) { $table_data.= 'am '; $table_data.= 'pm '; }
else { $table_data.= 'am '; $table_data.= 'pm '; }
$table_data.= ' ';
$table_data.= " ";
// Elder drop down list (for PPIs)
$table_data.= '';
$table_data.= ''.$name.' ';
}
$table_data.=' ';
$table_data.= ''.$name.' Family ';
}
$table_data.=' ";
// Date selection
$table_data.= '';
$table_data.= $this->jscal->input('sched['.$presidency.']['.$appointment.'][date]','','','','','','',$this->cal_options);
$table_data.= ' ';
// Time selection
$table_data.= "";
$table_data.= '';
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= ' : ';
$table_data.= '';
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= '';
$table_data.= 'am ';
$table_data.= 'pm ';
$table_data.= ' ';
$table_data.= " ";
// Elder drop down list
$table_data.= '';
$table_data.= ''.$name.' ';
}
$table_data.=' ';
$table_data.= ''.$name.' Family ';
}
$table_data.=' The following file was uploaded successfully: \n";
# make a directory for this data to be stored in
$date="data_" . date("Y_m_d");
$data_dir = $this->upload_target_path . $date;
print "-> Making the data directory: $date";
print "-E- Unable to create the data directory. Aborting import.";
print " ";
print "-E- Unable to move the uploaded file into the data dir. Aborting import.";
print " ";
print "-E- Unable to unzip the uploaded file into the data dir. Aborting import.";
print " ";
print "-E- Unable to update the data latest link. Aborting import.";
print "
";
} else if(($_FILES['uploadedfile']['type'] != "application/zip") &&
($_FILES['uploadedfile']['type'] != "application/x-zip-compressed") &&
($_FILES['uploadedfile']['type'] != "application/x-zip") &&
($_FILES['uploadedfile']['type'] != "application/octet-stream")) {
$uploadstatus = "The file format must be a .zip file, please try again! Detected file format: " . $_FILES['uploadedfile']['type'] . " ";
$this->t->set_var('uploadstatus',$uploadstatus);
$this->t->pfp('uploadhandle','upload',True);
} else {
$uploadstatus = " There was an error (" . $_FILES['uploadedfile']['error'];
$uploadstatus.= ") uploading the file, please try again! 
