X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=inc%2Fclass.eq.inc.php;h=d6bf500688d66b88a3a558d35284e0b65ff62fea;hb=e5ddee51384dd75fd9611897ce92cb4e76e37952;hp=dd3343c3c7614e4349bdc4fc6c3a9384e2ea8534;hpb=5be4f84484b7a86269ae91194950a4f9c3a7550e;p=eq%2F.git diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index dd3343c..d6bf500 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -23,6 +23,10 @@ class eq var $default_ppi_num_months; var $default_ppi_num_years; var $default_att_num_months; + var $current_year; + var $current_month; + var $upload_target_path; + var $script_path; var $public_functions = array ( @@ -37,15 +41,20 @@ class eq 'vis_view' => True, 'vis_update' => True, 'att_view' => True, - 'att_update' => True + 'att_update' => True, + 'dir_view' => True, + 'org_view' => True, + 'admin' => True ); function eq() { - $this->default_ht_num_months = 1; - $this->default_ppi_num_months = 1; + $this->default_ht_num_months = 3; + $this->default_ppi_num_months = 3; $this->default_ppi_num_years = 0; - $this->default_att_num_months = 1; + $this->default_att_num_months = 3; + $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; @@ -63,6 +72,12 @@ class eq $GLOBALS['phpgw_info']['flags']['app_header'] = 'Elders Quorum Tools'; $GLOBALS['phpgw']->common->phpgw_header(); + + $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(); } @@ -105,6 +120,15 @@ class eq $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'); $this->t->pparse('out','eq_header'); } @@ -124,7 +148,7 @@ class eq $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; @@ -143,6 +167,7 @@ class eq { $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); @@ -159,6 +184,7 @@ class eq { $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; @@ -170,7 +196,7 @@ class eq $unique_companionships=''; // Select all the unique companionship numbers for this district - $sql = "SELECT distinct companionship FROM eq_companionship where district=". $districts[$i]['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()) @@ -192,18 +218,25 @@ class eq while ($this->db->next_record()) { // Get this companions information - if($companion_table_entry != "") { $companion_table_entry .= " / "; } + 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]; } - else if($aaronic_id) { $name = $aaronic[$aaronic_id]['name']; } - $companion_table_entry .= "$name"; + 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"; } - $table_data.= "$companion_table_entry
"; + $table_data.= "$companion_table_entry
"; // Get the names of the families assigned this home teaching companionship $sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship']; + $sql = $sql . " ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); $k=0; while ($this->db->next_record()) @@ -217,11 +250,18 @@ class eq // in the past $num_months for this Family $header_row="Families"; for($m=$num_months; $m >= 0; $m--) { - $month = date('m/Y', strtotime('-'.$m.' month')); - $month_start = date('Y-m', strtotime('-'.$m.' month')); $month_start .= "-01"; - $month_end = date('Y-m', strtotime('-'.$m.' month')); $month_end .= "-31"; + $month = $this->current_month - $m; + $year = $this->current_year; + if($month <= 0) { $remainder = $month; $month = 12 + $remainder; $year=$year-1; } + if($month < 10) { $month = "0"."$month"; } + $month_start = "$year"."-"."$month"."-"."01"; + $month_end = "$year"."-"."$month"."-"."31"; + $month = "$month"."/"."$year"; + //print "m: $m month: $month year: $year month_start: $month_start month_end: $month_end
"; + // Add this to the query to filter on only visits made by this companionship: + // " AND companionship=" . $unique_companionships[$j]['companionship']. $sql = "SELECT * FROM eq_visit WHERE date >= '$month_start' AND date <= '$month_end' ". - " AND companionship=" . $unique_companionships[$j]['companionship']. + " AND companionship!=0". " AND family=". $family_id; $this->db2->query($sql,__LINE__,__FILE__); $link_data['menuaction'] = 'eq.eq.ht_update'; @@ -243,9 +283,15 @@ class eq else if($this->db2->f('visited') == 'n') { $table_data .= ''; } - else { $table_data .= " "; } + else { + $visits[$m]++; $total_visits[$m]++; + $table_data .= " "; + } + } + else { + $visits[$m]++; $total_visits[$m]++; + $table_data .= " "; } - else { $table_data .= " "; } } $table_data .= ""; $k++; @@ -307,7 +353,7 @@ class eq if($action == 'save') { // Get a list of all the companionships in this district - $sql = "SELECT distinct companionship FROM eq_companionship where district=". $district; + $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); $j=0; while ($this->db->next_record()) @@ -317,6 +363,15 @@ class eq } for ($j=0; $j < count($unique_companionships); $j++) { + // FIXME: We won't be able to go back and edit history on families that have been + // reassigned to a different companionship. The following delete command will not delete + // the history of visits under an older companionship, only the ones for the existing + // companionship. This will lead to duplicate visits being entered for an older + // month for the same family, making it impossible to change the past history once + // a family is reassigned. However, you will be able to view the history just fine. + + //$comp=$unique_companionships[$j]['companionship']; + //print "deleting from eq_visit where companionship=$comp and date=$date and district=$district
"; // Delete all the visits that have taken place for all families for this month $this->db->query("DELETE from eq_visit where companionship=" . $unique_companionships[$j]['companionship'] . " AND " . "date='" . $date . "'",__LINE__,__FILE__); @@ -351,6 +406,7 @@ class eq { $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); @@ -367,10 +423,11 @@ class eq { $aaronic_id = $this->db->f('aaronic'); $aaronic[$aaronic_id]['name'] = $this->db->f('name'); + $aaronic[$aaronic_id]['phone'] = $this->db->f('phone'); } // Select all the unique companionship numbers for this district - $sql = "SELECT distinct companionship FROM eq_companionship where district=". $district; + $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); $j=0; $unique_companionships=''; while ($this->db->next_record()) @@ -379,7 +436,7 @@ class eq $j++; } - $comp_width=300; $visit_width=25; $table_width=$comp_width + $num_months*$visit_width; + $comp_width=300; $visit_width=25; $table_width=$comp_width + $visit_width; $table_data=""; $num_companionships = 0; $num_families = 0; $visits=0; for ($j=0; $j < count($unique_companionships); $j++) { $companion_table_entry = ""; @@ -391,18 +448,25 @@ class eq while ($this->db->next_record()) { // Get this companions information - if($companion_table_entry != "") { $companion_table_entry .= " / "; } + 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]; } - else if($aaronic_id) { $name = $aaronic[$aaronic_id]['name']; } - $companion_table_entry .= "$name"; + 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"; } - $table_data.= "$companion_table_entry
"; + $table_data.= "$companion_table_entry
"; // Get the names of the families assigned this home teaching companionship $sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship']; + $sql = $sql . " ORDER BY name ASC"; $this->db->query($sql,__LINE__,__FILE__); while ($this->db->next_record()) { @@ -414,7 +478,7 @@ class eq $header_row="Families"; $sql = "SELECT * FROM eq_visit WHERE date >= '$month_start' AND date <= '$month_end' ". - " AND companionship=" . $unique_companionships[$j]['companionship'] . + " AND companionship!=0". " AND family=". $family_id; $this->db2->query($sql,__LINE__,__FILE__); $value = $family_id . "/" . $unique_companionships[$j]['companionship'] . "/" . $date; @@ -823,10 +887,16 @@ class eq $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'); - if($eqpresppi == 0) { $i++; } + if($eqpresppi == 1 && $this->db->f('district') == 1) { + $districts[$i]['district'] = $this->db->f('district'); + $districts[$i]['name'] = $this->db->f('name'); + $districts[$i]['supervisor'] = $this->db->f('supervisor'); + } else if($eqpresppi == 0) { + $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"; @@ -836,6 +906,7 @@ class eq { $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); @@ -850,6 +921,7 @@ class eq { $aaronic_id = $this->db->f('aaronic'); $aaronic[$aaronic_id]['name'] = $this->db->f('name'); + $aaronic[$aaronic_id]['phone'] = $this->db->f('phone'); } $total_companionships = 0; @@ -867,10 +939,10 @@ class eq // Select all the unique companionship numbers for this district if($eqpresppi == 1) { - $sql = "SELECT distinct companionship FROM eq_companionship"; + $sql = "SELECT distinct companionship FROM eq_companionship where valid=1"; } else { - $sql = "SELECT distinct companionship FROM eq_companionship where district=". $districts[$i]['district']; + $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district']; } $this->db->query($sql,__LINE__,__FILE__); $j=0; @@ -879,9 +951,9 @@ class eq $unique_companionships[$j]['companionship'] = $this->db->f('companionship'); $j++; } - + $comp_width=400; $ppi_width=25; $table_width=$comp_width + $num_months*$ppi_width; - $table_data=""; $num_companionships = 0; $num_elders = 0; + $table_data=""; $num_companionships = $j; $num_elders = 0; for($m=$num_months; $m >= 0; $m--) { $ppis[$m] = 0; } for ($j=0; $j < count($unique_companionships); $j++) { // Select all the companions in each companionship @@ -895,30 +967,35 @@ class eq } $this->db->query($sql,__LINE__,__FILE__); $k=0; + $comp = $unique_companionships[$j]['companionship']; + for($m=$num_months; $m >= 0; $m--) { $ppi_recorded[$comp][$m] = 0; } while ($this->db->next_record()) { // Get this companions information - $num_elders++; $num_companionships++; + $num_elders++; $companionship = $this->db->f('companionship'); $elder_id = $this->db->f('elder'); $aaronic_id = $this->db->f('aaronic'); - if($elder_id) { $name = $elders[$elder_id]; } - else if($aaronic_id) { $name = $aaronic[$aaronic_id]['name']; } + 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']; + } $link_data['menuaction'] = 'eq.eq.ppi_update'; $link_data['companionship'] = $companionship; $link_data['interviewer'] = $supervisor; $link_data['elder'] = $elder_id; + $link_data['aaronic'] = $aaronic_id; $link_data['name'] = $name; $link_data['ppi'] = ''; $link_data['eqpresppi'] = $eqpresppi; $link_data['action'] = 'add'; $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data); - if($aaronic_id == 0) { - $table_data.= "$name"; - } else { - $table_data.= "$name"; - } - + $table_data.= "$name"; + // Find out how many times PPIs were performed in the past $num_months for this Elder $header_row="Companionship"; for($m=$num_months; $m >= 0; $m--) { @@ -926,26 +1003,33 @@ class eq $year = date('Y') - $m; $year_start = $year - 1 . "-12-31"; $year_end = $year + 1 . "-01-01"; $sql = "SELECT * FROM eq_ppi WHERE date > '$year_start' AND date < '$year_end' ". - "AND elder=" . $elder_id . " AND eqpresppi=1"; + "AND elder=" . $elder_id . " AND aaronic=" . $aaronic_id . " AND eqpresppi=1"; $this->db2->query($sql,__LINE__,__FILE__); $header_row .= "$year"; } else { - $month = date('m/Y', strtotime('-'.$m.' month')); - $month_start = date('Y-m', strtotime('-'.$m.' month')); $month_start .= "-01"; - $month_end = date('Y-m', strtotime('-'.$m.' month')); $month_end .= "-31"; + $month = $this->current_month - $m; + $year = $this->current_year; + if($month <= 0) { $remainder = $month; $month = 12 + $remainder; $year=$year-1; } + if($month < 10) { $month = "0"."$month"; } + $month_start = "$year"."-"."$month"."-"."01"; + $month_end = "$year"."-"."$month"."-"."31"; + $month = "$month"."/"."$year"; $sql = "SELECT * FROM eq_ppi WHERE date >= '$month_start' AND date <= '$month_end' ". - "AND elder=" . $elder_id . " AND eqpresppi=0"; + "AND elder=" . $elder_id . " AND aaronic=" . $aaronic_id . " AND eqpresppi=0"; $this->db2->query($sql,__LINE__,__FILE__); $header_row .= "$month"; } if(!$total_ppis[$m]) { $total_ppis[$m] = 0; } if($this->db2->next_record()) { - $ppis[$m]++; $total_ppis[$m]++; + if(!$ppi_recorded[$companionship][$m]) { + $ppis[$m]++; $total_ppis[$m]++; $ppi_recorded[$companionship][$m]=1; + } $link_data['menuaction'] = 'eq.eq.ppi_update'; $link_data['companionship'] = $companionship; - $link_data['interviewer'] = $supervisor; + $link_data['interviewer'] = $this->db2->f('interviewer'); $link_data['elder'] = $elder_id; + $link_data['aaronic'] = $aaronic_id; $link_data['name'] = $name; $link_data['ppi'] = $this->db2->f('ppi'); $link_data['eqpresppi'] = $eqpresppi; @@ -955,19 +1039,13 @@ class eq $month = $date_array[1]; $day = $date_array[2]; $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data); - - if($aaronic_id == 0) { - $table_data .= '
'.$month.'-'.$day.''; - } else { - $table_data .= ''; - } + $table_data .= '
'.$month.'-'.$day.''; } else { $table_data .= " "; } } $table_data .= ""; $k++; } - if($num_companionships % 2 != 0) { $num_companionships++; } $table_data .= "
"; } // Now add Elders not assigned to any companionship to the table if we are in eqpresppi mode @@ -978,7 +1056,7 @@ class eq $this->db->query($sql,__LINE__,__FILE__); if(!$this->db->next_record()) { // We found an Elder not in a companionship, add them to the table - $num_elders++; $num_companionships++; + $num_elders++; $companionship=0; $name = $elders[$elder_id]; $link_data['menuaction'] = 'eq.eq.ppi_update'; @@ -1018,7 +1096,6 @@ class eq } } } - $num_companionships = ceil($num_companionships/2); $total_companionships += $num_companionships; if($eqpresppi == 1) { $stat_data = "$num_elders Elders
PPI Totals:"; @@ -1068,10 +1145,11 @@ class eq $name = get_var('name',array('GET','POST')); $ppi = get_var('ppi',array('GET','POST')); $elder = get_var('elder',array('GET','POST')); + $aaronic = get_var('aaronic',array('GET','POST')); $date = get_var('date',array('GET','POST')); $notes = get_var('notes',array('GET','POST')); $eqpresppi = get_var('eqpresppi',array('GET','POST')); - + $sql = "SELECT * FROM eq_district where valid=1 ORDER BY district ASC"; $this->db->query($sql,__LINE__,__FILE__); while ($this->db->next_record()) @@ -1098,6 +1176,7 @@ class eq " ppi='" . $ppi . "'" . ", interviewer='" . $interviewer . "'" . ", elder='" . $elder . "'" . + ", aaronic='" . $aaronic . "'" . ", date='" . $date . "'" . ", notes='" . $notes . "'" . ", eqpresppi='" . $eqpresppi . "'" . @@ -1109,8 +1188,8 @@ class eq if($action == 'insert') { $notes = $this->db->db_addslashes(get_var('notes',array('POST'))); - $this->db->query("INSERT INTO eq_ppi (interviewer,elder,date,notes,eqpresppi) " - . "VALUES ('" . $interviewer . "','" . $elder . "','" + $this->db->query("INSERT INTO eq_ppi (interviewer,elder,aaronic,date,notes,eqpresppi) " + . "VALUES ('" . $interviewer . "','" . $elder . "','" . $aaronic . "','" . $date . "','" . $notes . "','" . $eqpresppi ."')",__LINE__,__FILE__); $this->ppi_view(); return false; @@ -1123,6 +1202,7 @@ class eq $this->t->set_var('interviewer', $interviewer); $this->t->set_var('name',$name); $this->t->set_var('elder',$elder); + $this->t->set_var('aaronic',$aaronic); $this->t->set_var('date',''); $this->t->set_var('notes',''); $this->t->set_var('eqpresppi',$eqpresppi); @@ -1141,6 +1221,7 @@ class eq $this->t->set_var('name',$name); $this->t->set_var('interviewer', $this->db->f('interviewer')); $this->t->set_var('elder',$this->db->f('elder')); + $this->t->set_var('aaronic',$this->db->f('aaronic')); $this->t->set_var('date',$this->db->f('date')); $this->t->set_var('notes',$this->db->f('notes')); $this->t->set_var('eqpresppi',$this->db->f('eqpresppi')); @@ -1208,7 +1289,7 @@ class eq { $this->nextmatchs->template_alternate_row_color(&$this->t); - $sql = "SELECT * FROM eq_family WHERE valid=1 AND family=".$visit_list[$i]['family']; + $sql = "SELECT * FROM eq_family WHERE family=".$visit_list[$i]['family']; $this->db->query($sql,__LINE__,__FILE__); $this->db->next_record(); @@ -1422,7 +1503,8 @@ class eq $last_time += 90000; if($found_sunday) { $i++; $found_sunday=0; } } - + + $total_elders = count($elder_id); $old_month=$sunday_list[0]['month']; $span=0; for ($i=0; $i < count($sunday_list); $i++) { $date = $sunday_list[$i]['date']; @@ -1436,6 +1518,9 @@ class eq $link_data['month'] = $sunday_list[$i-1]['month']; $link_data['year'] = $sunday_list[$i-1]['year']; $link_data['action'] = 'update_month'; + $cur_month = $sunday_list[$i-1]['month']; + $cur_year = $sunday_list[$i-1]['year']; + $header_row .= "$cur_month $cur_year"; $this->t->set_var('update_month',$GLOBALS['phpgw']->link('/eq/index.php',$link_data)); $this->t->set_var('month',$sunday_list[$i-1]['month']); $this->t->set_var('year',$sunday_list[$i-1]['year']); @@ -1443,7 +1528,9 @@ class eq $this->t->fp('list1','month_list',True); } $span++; } - + $this->t->set_var('total_elders',$total_elders); + $this->t->set_var('header_row',$header_row); + $elder_width=200; $att_width=25; $total_width=$elder_width; for ($i=0; $i < count($sunday_list); $i++) { $link_data['menuaction'] = 'eq.eq.att_update'; @@ -1474,6 +1561,11 @@ class eq . $sunday_list[$j]['date'] . "' AND elder=" . $elder_id[$i]; $this->db->query($sql,__LINE__,__FILE__); if($this->db->next_record()) { + $cur_month = $sunday_list[$j]['month']; + if($attended[$i][$cur_month] != 1) { + $attended[$i][$cur_month]=1; + $attendance[$cur_month]++; + } $att_table .= ''; } else { $att_table .= ' '; @@ -1486,6 +1578,35 @@ class eq $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; + 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 = $total_elders - $total_attended; + $percent = ceil(($total_nonattended / $total_elders)*100); + $nonattendance_str.="$total_nonattended ($percent%)"; + + $total_attended = ceil(($ave_total_attended / $num_months)); + $percent = ceil(($total_attended / $total_elders)*100); + $aveattendance_str .= "$total_attended ($percent%)"; + $total_attended = $total_elders - ceil(($ave_total_attended / $num_months)); + $percent = ceil(($total_attended / $total_elders)*100); + $avenonattendance_str .= "$total_attended ($percent%)"; + } + + $this->t->set_var('attendance',$attendance_str); + $this->t->set_var('aveattendance',$aveattendance_str); + $this->t->set_var('nonattendance',$nonattendance_str); + $this->t->set_var('avenonattendance',$avenonattendance_str); + $this->t->pfp('out','att_view_t'); $this->save_sessiondata(); } @@ -1639,6 +1760,223 @@ class eq $this->save_sessiondata(); } + function dir_view() + { + $this->t->set_file(array('dir_view_t' => 'dir_view.tpl')); + $this->t->set_block('dir_view_t','dir_list','list'); + + $sql = "SELECT * FROM eq_parent where valid=1 ORDER BY name ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + while ($this->db->next_record()) + { + $parent[$i]['id'] = $this->db->f('parent'); + $parent[$i]['name'] = $this->db->f('name'); + $parent[$i]['phone'] = $this->db->f('phone'); + $parent[$i]['address'] = $this->db->f('address'); + $i++; + } + + for ($i=0; $i < count($parent); $i++) + { + $name = $parent[$i]['name']; + $phone = $parent[$i]['phone']; + $address = $parent[$i]['address']; + $this->t->set_var('name', $name); + $this->t->set_var('address', $address); + $this->t->set_var('phone', $phone); + $tr_color = $this->nextmatchs->alternate_row_color($tr_color); + $this->t->set_var('tr_color',$tr_color); + $this->t->fp('list','dir_list',True); + //print "$phone $name $address
"; + } + $this->t->pfp('out','dir_view_t'); + $this->save_sessiondata(); + } + + function org_view() + { + $this->t->set_file(array('org_view_t' => 'org_view.tpl')); + $this->t->set_block('org_view_t','calling_list','list1'); + $this->t->set_block('org_view_t','org_list','list2'); + + # Display a list ordered alphabetically + $sql = "SELECT * FROM eq_calling ORDER BY name ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + while ($this->db->next_record()) + { + $calling[$i]['id'] = $this->db->f('indiv_id'); + $calling[$i]['name'] = $this->db->f('name'); + $calling[$i]['position'] = $this->db->f('position'); + $calling[$i]['sustained'] = $this->db->f('sustained'); + $calling[$i]['organization'] = $this->db->f('organization'); + $i++; + } + for ($i=0; $i < count($calling); $i++) + { + $name = $calling[$i]['name']; + $position = $calling[$i]['position']; + $sustained = $calling[$i]['sustained']; + $organization = $calling[$i]['organization']; + $this->t->set_var('name', $name); + $this->t->set_var('position', $position); + $this->t->set_var('sustained', $sustained); + $this->t->set_var('organization', $organization); + $tr_color = $this->nextmatchs->alternate_row_color($tr_color); + $this->t->set_var('tr_color',$tr_color); + $this->t->fp('list1','calling_list',True); + } + + # Display a list ordered by organization + $sql = "SELECT * FROM eq_calling ORDER BY sequence ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + while ($this->db->next_record()) + { + $calling[$i]['id'] = $this->db->f('indiv_id'); + $calling[$i]['name'] = $this->db->f('name'); + $calling[$i]['position'] = $this->db->f('position'); + $calling[$i]['sustained'] = $this->db->f('sustained'); + $calling[$i]['organization'] = $this->db->f('organization'); + $i++; + } + for ($i=0; $i < count($calling); $i++) + { + $name = $calling[$i]['name']; + $position = $calling[$i]['position']; + $sustained = $calling[$i]['sustained']; + $organization = $calling[$i]['organization']; + $this->t->set_var('name', $name); + $this->t->set_var('position', $position); + $this->t->set_var('sustained', $sustained); + $this->t->set_var('organization', $organization); + $tr_color = $this->nextmatchs->alternate_row_color($tr_color); + $this->t->set_var('tr_color',$tr_color); + $this->t->fp('list2','org_list',True); + } + + $this->t->pfp('out','org_view_t'); + $this->save_sessiondata(); + } + + function admin() + { + $this->t->set_file(array('admin_t' => 'admin.tpl')); + $this->t->set_block('admin_t','upload','uploadhandle'); + $this->t->set_block('admin_t','admin','adminhandle'); + $this->t->set_block('admin_t','cmd','cmdhandle'); + + $this->t->set_var('upload_action',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.admin&action=upload')); + + $action = get_var('action',array('GET','POST')); + + $this->t->pfp('out','admin_t'); + + if($action == 'upload') + { + $target_path = $this->upload_target_path . basename( $_FILES['uploadedfile']['name']); + + if(($_FILES['uploadedfile']['type'] == "application/zip") && + (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path))) { + $uploadstatus = "The following file was uploaded successfully:

"; + $uploadstatus.= "Filename : " . $_FILES['uploadedfile']['name'] . "
"; + $uploadstatus.= "Type : " . $_FILES['uploadedfile']['type'] . "
"; + $uploadstatus.= "Size : " . $_FILES['uploadedfile']['size'] . "
"; + $this->t->set_var('uploadstatus',$uploadstatus); + $this->t->pfp('uploadhandle','upload'); + $this->t->set_var('uploadhandle',''); + print "
\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
\n";
+	    exec('mkdir ' . $data_dir . ' 2>&1', $result, $return_code);
+	    if($return_code != 0) {
+	      print implode('\n',$result) . "
";
+	      print "";
+	      print "-E- Unable to create the data directory. Aborting import.";
+	      print "";
+	      return 0;
+	    }
+
+	    # move the file uploaded into this directory
+	    print "-> Moving the uploaded file into the data dir
\n";
+	    exec('mv ' . $target_path . ' ' . $data_dir . '/' . ' 2>&1', $result, $return_code);
+	    if($return_code != 0) {
+	      print implode('\n',$result) . "
";
+	      print "";
+	      print "-E- Unable to move the uploaded file into the data dir. Aborting import.";
+	      print "";
+	      return 0;
+	    }
+	    
+	    # unzip the data into this directory
+	    print "-> Unzipping the data
\n";
+	    $data_file = $data_dir . '';
+	    exec('unzip ' . $data_dir . '/*.zip -d ' . $data_dir . ' 2>&1', $result, $return_code);
+	    if($return_code != 0) {
+	      print implode('\n',$result) . "
";
+	      print "";
+	      print "-E- Unable to unzip the uploaded file into the data dir. Aborting import.";
+	      print "";
+	      return 0;
+	    }
+	    exec('mv ' . $data_dir . '/*/* '. $data_dir . ' 2>&1', $result, $return_code);
+
+	    # update the data_latest link to point to this new directory
+	    print "-> Updating the latest data dir link
\n";
+	    $data_latest = $this->upload_target_path . 'data_latest';
+	    exec('rm ' . $data_latest. '; ln -s ' . $data_dir .' '. $data_latest .' 2>&1', $result, $return_code);
+	    if($return_code != 0) {
+	      print implode('\n',$result) . "
";
+	      print "";
+	      print "-E- Unable to update the data latest link. Aborting import.";
+	      print "";
+	      return 0;
+	    }
+	    
+	    # run the import perl script to encorporate it into the DB
+	    ob_start('ob_logstdout', 2);
+	    print "-> Importing the data into the EQ database
\n";
+	    ob_flush(); flush(); sleep(1);
+	    $import_log = $this->upload_target_path . '/import.log';
+	    $data_log = $this->upload_target_path . '/data.log';
+	    $import_cmd = $this->script_path . 'import_ward_data ' . $data_latest . ' | tee ' . $import_log;
+	    $parse_cmd = $this->script_path . 'parse_ward_data -v ' . $data_latest . ' > ' . $data_log;
+	    #print "import_cmd: $import_cmd
";
+	    #print "parse_cmd: $parse_cmd
";
+	    ob_start('ob_logstdout', 2);
+	    passthru($import_cmd);
+	    passthru($parse_cmd);
+	    ob_flush(); flush(); sleep(1);
+
+	    # fix the permissions of the data dir
+	    exec('chmod -R o-rwx ' . $data_dir, $result, $return_code);
+	    
+	    $this->t->pfp('cmdhandle','cmd');
+	    print "
"; + + } else if($_FILES['uploadedfile']['type'] != "application/zip") { + $uploadstatus = "The file format must be a .zip file, please try again! "; + $this->t->set_var('uploadstatus',$uploadstatus); + + } else { + $uploadstatus = " There was an error (" . $_FILES['uploadedfile']['error']; + $uploadstatus.= ") uploading the file, please try again! "; + $this->t->set_var('uploadstatus',$uploadstatus); + } + } + else + { + $this->t->set_var('adminhandle',''); + $this->t->pfp('adminhandle','admin'); + } + + $this->save_sessiondata(); + } + } ?>