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' => True,
'email_appt' => True,
'willing_view' => True,
'willing_update' => True,
'send_ical_appt' => True,
'assign_view' => True,
'assign_update' => True,
'get_time_selection_form' => True,
);
function tc()
{
if(file_exists("setup/tc_config.local")) {
include("setup/tc_config.local");
} else {
include("setup/tc_config");
}
$this->script_path = "$this->application_path"."/bin";
$this->max_presidency_members = 99;
$this->max_appointments = 32768;
$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('tc');
$this->grants[$this->account] = PHPGW_ACL_READ + PHPGW_ACL_ADD + PHPGW_ACL_EDIT + PHPGW_ACL_DELETE;
$this->jscal = CreateObject('tc.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'] = 'The 3rd Counselor';
$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('tc_header' => 'header.tpl'));
if (isset($phpgw_info['user']['preferences']['tc']['tc_font']))
{
$font = $phpgw_info['user']['preferences']['tc']['tc_font'];
}
else
{
$font = 'Arial';
}
$this->t->set_var('bg_color',$phpgw_info['theme']['th_bg']);
$this->t->set_var('font',$font);
$link_data['menuaction'] = 'tc.tc.ht_view';
$this->t->set_var('link_hometeaching',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_hometeaching','HomeTeaching');
$link_data['menuaction'] = 'tc.tc.act_list';
$this->t->set_var('link_activity',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_activity','Activities');
$link_data['menuaction'] = 'tc.tc.willing_view';
$this->t->set_var('link_willing',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_willing','Willingness');
$link_data['menuaction'] = 'tc.tc.assign_view';
$this->t->set_var('link_assignment',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_assignment','Assignments');
$link_data['menuaction'] = 'tc.tc.par_view';
$this->t->set_var('link_participation',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_participation','Participation');
$link_data['menuaction'] = 'tc.tc.ppi_view';
$this->t->set_var('link_ppi',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_ppi','PPIs');
$link_data['menuaction'] = 'tc.tc.int_view';
$this->t->set_var('link_int',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_int','Interviews');
$link_data['menuaction'] = 'tc.tc.vis_view';
$this->t->set_var('link_visit',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_visit','Visits');
$link_data['menuaction'] = 'tc.tc.att_view';
$this->t->set_var('link_attendance',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_attendance','Attendance');
$link_data['menuaction'] = 'tc.tc.dir_view';
$this->t->set_var('link_dir',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_dir','Directory');
$link_data['menuaction'] = 'tc.tc.org_view';
$this->t->set_var('link_org',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_org','Callings');
$link_data['menuaction'] = 'tc.tc.admin';
$this->t->set_var('link_admin',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_admin','Admin');
$link_data['menuaction'] = 'tc.tc.schedule';
$this->t->set_var('link_schedule',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_schedule','Scheduling');
$link_data['menuaction'] = 'tc.tc.email';
$this->t->set_var('link_email',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_email','Email');
$this->t->pparse('out','tc_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('/tc/index.php','menuaction=tc.tc.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('/tc/index.php','menuaction=tc.tc.ht_view'));
$this->t->set_var('title','Hometeaching');
$sql = "SELECT * FROM tc_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 tc_individual where valid=1 ORDER BY individual ASC";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record()) {
$individual[$i] = $this->db->f('individual');
$indiv_name[$i] = $this->db->f('name');
$indiv_phone[$individual[$i]] = $this->db->f('phone');
$i++;
}
array_multisort($indiv_name, $individual);
// Make an array mapping individuals to indiv_names
for($i=0; $i < count($individual); $i++) {
$id = $individual[$i];
$indivs[$id] = $indiv_name[$i];
}
$this->nextmatchs->template_alternate_row_color(&$this->t);
for($m=$num_months; $m >= 0; $m--) { $total_families[$m]=0; }
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'];
// Select all the unique companionship numbers for this district
$sql = "SELECT distinct companionship FROM tc_companionship where valid=1 and district=". $districts[$i]['district'];
$this->db->query($sql,__LINE__,__FILE__);
$j=0; $unique_companionships = '';
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;
for($m=$num_months; $m >= 0; $m--) {
$visits[$m]=0;
$num_families[$m]=0;
}
for ($j=0; $j < count($unique_companionships); $j++) {
$companion_table_entry = "";
// Select all the companions in each companionship
$sql = "SELECT * FROM tc_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');
$individual = $this->db->f('individual');
$name = $indivs[$individual];
$phone = $indiv_phone[$individual];
$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 .= "Families Hometaught: $visits[$m] / $num_families[$m] Total Families Hometaught: $total_visits[$m] / $total_families[$m] / "; }
$companionship = $this->db->f('companionship');
$individual = $this->db->f('individual');
$name = $indivs[$individual];
$phone = $indiv_phone[$individual];
$companion_table_entry .= "$name $family_name Family ";
$header_row="Families $month ';
$table_data .= ' ';
} else if($this->db2->f('visited') == 'n') {
$num_families++;
$table_data .= '';
$table_data .= ' ';
} else {
$table_data .= '';
$table_data .= ' ';
}
}
else {
$value .= "/";
$table_data .= '';
$table_data .= ' ';
}
}
$table_data .= "Families Hometaught: $visits / $num_families ");
} 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','individual_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('/tc/index.php','menuaction=tc.tc.act_list'));
$activity['activity'] = intval(get_var('activity',array('GET','POST')));
if($action == 'save') {
$activity['assignment'] = get_var('assignment',array('POST'));
$activity['date'] = get_var('date',array('POST'));
$activity['notes']= get_var('notes',array('POST'));
$this->db->query("UPDATE tc_activity set " .
" assignment='" . $activity['assignment'] .
"', date='" . $activity['date'] . "'" .
", notes='" . $activity['notes'] . "'" .
" WHERE activity=" . $activity['activity'],__LINE__,__FILE__);
// Delete all the individuals who have particiapted in this activity
$this->db->query("DELETE from tc_participation where activity=".$activity['activity'],__LINE__,__FILE__);
// Re-add the individuals who are checked as having participated in this activity
$indivs = get_var('individual_name',array('POST'));
if(is_array($indivs)) { // Only do the foreach loop if we have a valid array of indivs to work with
foreach ($indivs as $indiv) {
$this->db->query("INSERT INTO tc_participation (individual,activity) " .
"VALUES (" . $individual . ",". $activity['activity'] . ")",__LINE__,__FILE__);
}
}
$this->act_list();
return false;
}
if($action == 'insert') {
$activity['assignment'] = get_var('assignment',array('POST'));
$activity['date'] = get_var('date',array('POST'));
$activity['notes']= get_var('notes',array('POST'));
$this->db->query("INSERT INTO tc_activity (assignment,date,notes) " .
"VALUES ('" . $activity['assignment'] . "','" .
$activity['date'] . "','" . $activity['notes'] . "')",__LINE__,__FILE__);
$sql = "SELECT * FROM tc_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 individual selection boxes
$sql = "SELECT * FROM tc_individual";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record()) {
if($this->db->f('valid') == 1 || $action != 'add') {
$indiv_name[$i] = $this->db->f('name');
$individual[$i] = $this->db->f('individual');
$indiv_valid[$i] = $this->db->f('valid');
$i++;
}
}
array_multisort($indiv_name, $individual, $indiv_valid);
$j=0;
for ($i=0; $i < count($individual); $i++) {
//$this->nextmatchs->template_alternate_row_color(&$this->t);
$sql = "SELECT * FROM tc_participation where activity=". $activity['activity'] . " AND individual=" . $individual[$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 || $indiv_valid[$i] == 1) {
$this->t->set_var('individual_name',$indiv_name[$i]);
$this->t->set_var('individual',$individual[$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','individual_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','Abbreviation');
$sql = "SELECT * FROM tc_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]['abbreviation'] = $this->db->f('abbreviation');
$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('abbreviation',$assignment_list[$i]['abbreviation']);
$link_data['menuaction'] = 'tc.tc.assign_update';
$link_data['assignment'] = $assignment_list[$i]['assignment'];
$link_data['action'] = 'edit';
$this->t->set_var('edit',$GLOBALS['phpgw']->link('/tc/index.php',$link_data));
$this->t->set_var('lang_edit','Edit');
$link_data['menuaction'] = 'tc.tc.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('/tc/index.php','menuaction=tc.tc.assign_view'));
$assignment['assignment'] = intval(get_var('assignment',array('GET','POST')));
if($action == 'save') {
$assignment['name'] = get_var('name',array('POST'));
$assignment['abbreviation'] = get_var('abbreviation',array('POST'));
$this->db->query("UPDATE tc_assignment set " .
" name='" . $assignment['name'] . "'" .
", abbreviation='" . $assignment['abbreviation'] . "'" .
" WHERE assignment=" . $assignment['assignment'],__LINE__,__FILE__);
$this->assign_view();
return false;
}
if($action == 'insert') {
$assignment['name'] = get_var('name',array('POST'));
$assignment['abbreviation'] = get_var('abbreviation',array('POST'));
$this->db->query("INSERT INTO tc_assignment (name,abbreviation) " .
"VALUES ('" . $assignment['name'] . "','" .
$assignment['abbreviation'] . "')",__LINE__,__FILE__);
$this->assign_view();
return false;
}
if($action == 'add') {
$assignment['assignment'] = 0;
$this->t->set_var('name','');
$this->t->set_var('abbreviation','');
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Adding New Assignment');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.assign_update&assignment=' .
$assignment['assignment'] . '&action=' . 'insert'));
}
if($action == 'edit')
{
$sql = "SELECT * FROM tc_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('abbreviation', $this->db->f('abbreviation'));
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('lang_action','Editing Assignment');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.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','individual_list','list2');
// TODO: changed this so it picks the quorum dynamically
$sql = "SELECT * FROM tc_individual where steward='Elder' and valid=1";
$this->db->query($sql,__LINE__,__FILE__);
$i=0;
while ($this->db->next_record()) {
$individual_name[$i] = $this->db->f('name');
$individual[$i] = $this->db->f('individual');
$i++;
}
array_multisort($individual_name, $individual);
$sql = "SELECT * FROM tc_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 tc_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]['abbreviation'] = $this->db->f('abbreviation');
$i++;
}
$individual_width=300; $part_width=25; $assignment_width=50;
$total_width=$individual_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_abbreviation',$assignment_list[$i]['abbreviation']);
$this->t->fp('list1','header_list',True);
$total_width += $assignment_width;
}
for ($i=0; $i < count($individual); $i++) {
$participated=0; $part_table = '';
$this->nextmatchs->template_alternate_row_color(&$this->t);
$this->t->set_var('individual_name',$individual_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 tc_participation where " .
" activity=" . $activity_list[$k]['activity'] .
" AND individual=" . $individual[$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 .= ''.$num_matches.' '.$date.' ';
}
}
if($participated) {
$part_table .= ' ';
}
$this->t->set_var('part_table',$part_table);
$this->t->fp('list2','individual_list',True);
}
$this->t->set_var('total_width',$total_width);
$this->t->set_var('individual_width',$individual_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 willing_view()
{
$this->t->set_file(array('willing_view_t' => 'willing_view.tpl'));
$this->t->set_block('willing_view_t','header_list','list1');
$this->t->set_block('willing_view_t','individual_list','list2');
$this->t->set_var('lang_filter','Filter');
$this->t->set_var('lang_filter_unwilling','Filter out unwilling individuals:');
$filter_unwilling = get_var('filter_unwilling',array('POST'));
$this->t->set_var('filter_unwilling',$filter_unwilling);
if($filter_unwilling == 'y' || $filter_unwilling == '') {
$filter_input = "'.$date_part.' ";
}
}
if(!$found_willingness) {
$indiv_willing=1;
$willing_table .= " ";
}
}
if(($indiv_willing == 1) || ($filter_unwilling == 'n')) {
$this->t->set_var('willing_table',$willing_table);
$this->t->fp('list2','individual_list',True);
$this->nextmatchs->template_alternate_row_color(&$this->t);
}
}
$stat_table = 'Total Willing to Serve ".$total_willing[$j]." Willingness Update Under Constrcution ";
//$this->willing_view();
//return false;
$this->t->set_file(array('willing_update_t' => 'willing_update.tpl'));
$this->t->set_block('willing_update_t','assignment_list','list');
$this->t->set_block('willing_update_t','save','savehandle');
$individual = get_var('individual',array('GET','POST'));
$this->t->set_var('individual',$individual);
$action = get_var('action',array('GET','POST'));
$this->t->set_var('done_action',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.willing_view'));
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.willing_update&action=save'));
$this->t->set_var('lang_done','Cancel');
$this->t->set_var('title','Willingness Update ');
if($action == 'save') {
// Delete all the previous willingness entries for this individual
$this->db->query("DELETE from tc_willingness where individual=" . $individual ,__LINE__,__FILE__);
// Now, add the assignment willingness that is checked for this individual
$new_data = get_var('willingness',array('POST'));
foreach ($new_data as $data) {
$data_array = explode("/",$data);
$assignment = $data_array[0];
$willing = $data_array[1];
//print "individual: $individual assignment: $assignment willing: $willing $assignment_name ";
$header_row="Assignments Willingness ";
$sql = "SELECT * FROM tc_willingness WHERE individual=".$individual." AND assignment=".$assignment;
$this->db2->query($sql,__LINE__,__FILE__);
$value = $assignment;
if($this->db2->next_record()) {
if($this->db2->f('willing') == 'y') {
$table_data .= '';
$table_data .= ' ';
} else if($this->db2->f('willing') == 'n') {
$table_data .= '';
$table_data .= ' ';
} else {
$table_data .= '';
$table_data .= ' ';
}
} else {
$table_data .= '';
$table_data .= ' ';
}
$table_data .= "\n";
$table_data .= "individual Name Phone Priority Last PPI Scheduling Notes -E- Unable to locate President in tc_presidency table Date Time indiv Location ";
$appt_table_data.= "$day_string ";
$appt_table_data.= "$time_string ";
$appt_table_data.= '';
$appt_table_data.= ''.$name.' ';
}
$appt_table_data.=' $name $phone ";
//$table_data.= "$priority ";
$table_data.= "";
$table_data.= '';
foreach(range(0,6) as $num) {
if($num == 0) { $num = 1; } else {$num = $num*5; }
if($priority == $num) {
$selected[$num] = 'selected="selected"';
} else {
$selected[$num] = '';
}
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= "$date ";
$table_data.= '$name $phone ";
$completed_data.= "$date $notes ";
$completed_data.= 'Individual Name Phone Date PPI Notes Individuals $year ";
$totals_data.= "Total Individuals with yearly PPIs completed: $indivs_with_yearly_ppi / $total_indivs ";
$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','individual_list','indivlist');
$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('/tc/index.php','menuaction=tc.tc.int_view'));
$this->t->set_var('int_link_title','Hometeaching Interviews');
$this->t->set_var('schedule_int_link',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.int_sched'));
$this->t->set_var('schedule_int_link_title','Schedule Hometeaching Interviews');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.int_sched&action=save'));
$this->t->set_var('title','Hometeaching Interviews Scheduler');
$indiv_width=500; $phone_width=25; $pri_width=10; $notes_width=128; $int_date_width=20;
$table_width=$indiv_width + $phone_width + $pri_width + $notes_width + $int_date_width;
$header_row = "individual Name Phone Priority Last Interview Scheduling Notes Date Time Individual Location ";
$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 $hti_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($hti_pri == $num) {
$selected[$num] = 'selected="selected"';
} else {
$selected[$num] = '';
}
$table_data.= ''.$num.' ';
}
$table_data.= ' ';
$table_data.= "$date ";
$table_data.= '$name $phone ";
$completed_data.= "$date $hti_notes ";
$completed_data.= 'Individual Name Phone Date Interview Notes Individuals $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('/tc/index.php','menuaction=tc.tc.vis_view'));
$this->t->set_var('vis_link_title','View Yearly Visits');
$this->t->set_var('schedule_vis_link',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.vis_sched'));
$this->t->set_var('schedule_vis_link_title','Schedule Yearly Visits');
$this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.vis_sched&action=save'));
$this->t->set_var('title','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 Location -E- Unable to locate Presidency in tc_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('/tc/index.php','menuaction=tc.tc.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('/tc/index.php','menuaction=tc.tc.ppi_view'));
$this->t->set_var('ppi_link',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.ppi_view'));
$this->t->set_var('ppi_link_title','Yearly PPIs');
$this->t->set_var('schedule_ppi_link',$GLOBALS['phpgw']->link('/tc/index.php','menuaction=tc.tc.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 tc_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('individual');
$interview_type = 'ppi';
} else {
print "-E- Unable to locate President in tc_presidency table Individual Name $year $name ";
}
}
$table_data .= "$total_indivs Individuals $ppis[$m] $name Companionship $month ";
}
}
$table_data .= "$num_companionships Companionships $total $total_companionships Total Comps $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('/tc/index.php','menuaction=tc.tc.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 = get_var('notes',array('POST'));
$this->db->query("UPDATE tc_visit set " .
" date='" . $date . "'" .
", notes='" . $notes . "'" .
" WHERE visit=" . $visit,__LINE__,__FILE__);
$this->vis_view();
return false;
}
if($action == 'insert') {
$notes = get_var('notes',array('POST'));
$this->db->query("INSERT INTO tc_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('/tc/index.php','menuaction=tc.tc.vis_update&family=' .
$family . '&action=' . 'insert'));
}
if($action == 'edit' || $action == 'view') {
$sql = "SELECT * FROM tc_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('/tc/index.php','menuaction=tc.tc.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','individual_list',True);
}
$this->t->set_var('total_width',$total_width);
$this->t->set_var('individual_width',$individual_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_individuals)*100);
$attendance_str.="$total_attended ($percent%) $total_nonattended ($percent%) $total_attended ($percent%) $total_attended ($percent%) Date Time individual Family Location ";
// 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 .= $this->get_time_selection_form($hour, $minute, $pm, $presidency, $appointment);
$table_data.= " ";
// individual 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 .= $this->get_time_selection_form(0, 0, 0, $presidency, $appointment);
$table_data.= " ";
// individual drop down list
$table_data.= '';
$table_data.= ''.$name.' ';
}
$table_data.=' ';
$table_data.= ''.$name.' Family ';
}
$table_data.=' -E- Unable to move the uploaded file to ";
$uploadstatus.= "the target path (check the path and permissions) of: $target_path The following file was uploaded successfully: 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: $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! Individual Email District President Counselor Secretary ";
while ($this->db->next_record()) {
// Extract the data for each presidency record
$id = $this->db->f('presidency');
$indiv = $this->db->f('individual');
$district = $this->db->f('district');
$name = $this->db->f('name');
$email = $this->db->f('email');
$president = $this->db->f('president');
$counselor = $this->db->f('counselor');
$secretary = $this->db->f('secretary');
// Create the forms needed in the table
$table_data .= " ";
// Presidency ID
$table_data .= '';
$table_data.= ''.$name.' ';
}
$table_data.=' ';
$table_data.= ''.$j.' ';
}
$table_data.=' ';
if($president == 1) { $table_data .= '0 1 '; }
else { $table_data .= '0 1 '; }
$table_data.=' ';
if($counselor == 1) { $table_data .= '0 1 '; }
else { $table_data .= '0 1 '; }
$table_data.=' ';
if($secretary == 1) { $table_data .= '0 1 '; }
else { $table_data .= '0 1 '; }
$table_data.=' \n";
$tr_color = $this->nextmatchs->alternate_row_color($tr_color);
$this->t->set_var('tr_color',$tr_color);
}
// Now create 1 blank row to always have a line available to add a new individual with
$id = $this->max_presidency_members;
$table_data .= "";
// Presidency ID
$table_data .= '';
$table_data.= ''.$name.' ';
}
$table_data.=' ';
$table_data.= ''.$j.' ';
}
$table_data.=' ';
$table_data.= '0 1 ';
$table_data.=' ';
$table_data.= '0 1 ';
$table_data.=' ';
$table_data.= '0 1 ';
$table_data.=' \n";
$tr_color = $this->nextmatchs->alternate_row_color($tr_color);
$this->t->set_var('tr_color',$tr_color);
$this->t->set_var('header_row',$header_row);
$this->t->set_var('table_data',$table_data);
$this->t->pfp('presidencyhandle','presidency',True);
$this->save_sessiondata();
}
function email_appt($appointment)
{
//print "Emailing notification of appointment: $appointment ';
if($blank == 1) { $form_data.= ''.$num.' ';
}
$form_data.= ' ';
$form_data.= ' : ';
$form_data.= '';
if($blank == 1) { $form_data.= ''.$num.' ';
$num = $num + $this->time_drop_down_list_inc;
}
$form_data.= ' ';
} else {
// Use free form text fields to get the time
if($blank == 1) {
$hour = "";
$minute = "";
$ampm = "";
}
$form_data.= '';
if($blank == 0) {
if($pm == 0) {
$form_data.= 'am ';
$form_data.= 'pm ';
}
if($pm == 1) {
$form_data.= 'am ';
$form_data.= 'pm ';
}
} else {
$form_data.= 'am ';
$form_data.= 'pm ';
}
$form_data.= ' ';
return $form_data;
}
}
?>
