X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=inc%2Fclass.eq.inc.php;h=7f0d5a6e887671fb744d508cd3468d9b6aaf1508;hb=f043aa9ef5f150757d49f113307ea912c23006bc;hp=ca6b8097d9e69841b87845eeadb668342a8d1ed0;hpb=87fe12720f10a6ef93f81726ccb90b812393d599;p=eq%2F.git diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index ca6b809..7f0d5a6 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -1,7 +1,8 @@ True, 'schedule' => True, 'admin' => True, + 'email' => True, 'email_appt' => True, 'willing_view' => True, 'willing_update' => True, @@ -166,6 +168,9 @@ class eq $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'); + $link_data['menuaction'] = 'eq.eq.email'; + $this->t->set_var('link_email',$GLOBALS['phpgw']->link('/eq/index.php',$link_data)); + $this->t->set_var('lang_email','Email'); $this->t->pparse('out','eq_header'); } @@ -1405,7 +1410,34 @@ class eq $table_data=""; $completed_data=""; $totals_data=""; $year = date('Y'); - + + // Get the EQ President + $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'); + $president_name_array = explode(",",$president_name); + $president_last_name = $president_name_array[0]; + $president_id = $this->db->f('elder'); + $presidency_id = $this->db->f('presidency'); + $interviewer = $this->db->f('elder'); + $district_number = '*'; + $district_name = $president_name; + $sql = "SELECT * FROM eq_elder where elder='$president_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $indiv_id = $this->db2->f('indiv_id'); + } + $sql = "SELECT * FROM eq_parent where indiv_id='$indiv_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $president_address = $this->db2->f('address'); + } + } else { + print "

-E- Unable to locate EQ President in eq_presidency table

"; + return; + } + if($action == 'save') { // Save any changes made to the appointment table @@ -1415,16 +1447,18 @@ class eq { $elder = $entry['elder']; $appointment = $entry['appointment']; - - //print "elder: $elder appointment: $appointment
"; + $location = $entry['location']; + if($location == "") { $location = "$president_last_name"." home ($president_address)"; } + if($elder == 0) { $location = ""; } //Only perform a database update if we have made a change to this appointment - $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and elder='$elder'"; + $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and elder='$elder' and location='$location'"; $this->db->query($sql,__LINE__,__FILE__); if(!$this->db->next_record()) { // Perform database save actions here $this->db->query("UPDATE eq_appointment set " . " elder='" . $elder . "'" . + ",location='" . $location . "'" . " WHERE appointment=" . $appointment,__LINE__,__FILE__); // Email the appointment $this->email_appt($appointment); @@ -1452,21 +1486,6 @@ class eq $take_me_to_url = $GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_sched'); //Header('Location: ' . $take_me_to_url); } - - // Get the EQ President - $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'); - $president_id = $this->db->f('elder'); - $presidency_id = $this->db->f('presidency'); - $interviewer = $this->db->f('elder'); - $district_number = '*'; - $district_name = $president_name; - } else { - print "

-E- Unable to locate EQ President in eq_presidency table

"; - return; - } // create the elder id -> elder name mapping $sql = "SELECT * FROM eq_elder where valid=1 ORDER BY name ASC"; @@ -1483,11 +1502,12 @@ class eq array_multisort($elder_name, $elder_id); // APPOINTMENT TABLE - $date_width=150; $time_width=100; $elder_width=200; - $appt_table_width=$date_width + $time_width + $elder_width; + $date_width=250; $time_width=100; $elder_width=200; $location_width=100; + $appt_table_width=$date_width + $time_width + $elder_width + $location_width; $appt_header_row = "Date"; $appt_header_row.= "Time"; $appt_header_row.= "Elder"; + $appt_header_row.= "Location"; $appt_table_data = ""; $total_elders=0; $elders_with_yearly_ppi=0; @@ -1507,6 +1527,8 @@ class eq { $appointment = $this->db->f('appointment'); $elder = $this->db->f('elder'); + $location = $this->db->f('location'); + if(($location == "") && ($elder > 0)) { $location = "$president_last_name"." home ($president_address)"; } $date = $this->db->f('date'); $date_array = explode("-",$date); @@ -1530,7 +1552,10 @@ class eq $appt_table_data.= ''; } $appt_table_data.=''; - + + $appt_table_data.= ''; + $appt_table_data.= ''; $tr_color = $this->nextmatchs->alternate_row_color($tr_color); @@ -1570,11 +1595,11 @@ class eq // If this elder has had a yearly PPI this year, don't show him on the schedule list $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=" . $id; + "AND elder=" . $id . " AND eqpresppi=1"; $this->db2->query($sql,__LINE__,__FILE__); if(!$this->db2->next_record()) { - $sql = "SELECT * FROM eq_ppi WHERE elder=" . $id . " ORDER BY date DESC"; + $sql = "SELECT * FROM eq_ppi WHERE elder=" . $id . " AND eqpresppi=1 ORDER BY date DESC"; $this->db->query($sql,__LINE__,__FILE__); if($this->db->next_record()) { $date = $this->db->f('date'); } else { $date = ""; } $link_data['menuaction'] = 'eq.eq.ppi_update'; @@ -1702,7 +1727,22 @@ class eq if($month >= 7 && $month <= 9) { $quarter_start=$year."-07-01"; $quarter_end=$year."-10-01"; } if($month >= 10 && $month <= 12) { $quarter_start=$year."-10-01"; $quarter_end=$nextyear."-01-01"; } //print "year: $year month: $month quarter_start: $quarter_start quarter_end: $quarter_end
"; - + + // create the elder id -> elder name mapping + $sql = "SELECT * FROM eq_elder where valid=1 ORDER BY name ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + $elder_id_data = NULL; + $elder_name_data = NULL; + while ($this->db->next_record()) + { + $elder_name_data[$i] = $this->db->f('name'); + $elder_id_data[$i] = $this->db->f('elder'); + $elderid2name[$elder_id_data[$i]] = $elder_name_data[$i]; + $i++; + } + array_multisort($elder_name_data, $elder_id_data); + if($action == 'save') { // Save any changes made to the appointment table @@ -1712,15 +1752,34 @@ class eq { $elder = $entry['elder']; $appointment = $entry['appointment']; + $location = $entry['location']; + if($location == "") { + $supervisor = $entry['supervisor']; + $supervisor_array = explode(",", $elderid2name[$supervisor]); + $supervisor_last_name = $supervisor_array[0]; + $sql = "SELECT * FROM eq_elder where elder='$supervisor'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $indiv_id = $this->db2->f('indiv_id'); + } + $sql = "SELECT * FROM eq_parent where indiv_id='$indiv_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $supervisor_address = $this->db2->f('address'); + } + $location = "$supervisor_last_name"." home ($supervisor_address)"; + } + if($elder == 0) { $location = ""; } //print "elder: $elder appointment: $appointment
"; //Only perform a database update if we have made a change to this appointment - $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and elder='$elder'"; + $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and elder='$elder' and location='$location'"; $this->db->query($sql,__LINE__,__FILE__); if(!$this->db->next_record()) { // Perform database save actions here $this->db->query("UPDATE eq_appointment set " . " elder='" . $elder . "'" . + ",location='" . $location . "'" . " WHERE appointment=" . $appointment,__LINE__,__FILE__); // Email the appointment @@ -1771,27 +1830,14 @@ class eq $i++; } - // create the elder id -> elder name mapping - $sql = "SELECT * FROM eq_elder where valid=1 ORDER BY name ASC"; - $this->db->query($sql,__LINE__,__FILE__); - $i=0; - $elder_id_data = NULL; - $elder_name_data = NULL; - while ($this->db->next_record()) - { - $elder_name_data[$i] = $this->db->f('name'); - $elder_id_data[$i] = $this->db->f('elder'); - $i++; - } - array_multisort($elder_name_data, $elder_id_data); - // APPOINTMENT TABLE $district = 1; - $date_width=150; $time_width=100; $elder_width=200; - $appt_table_width=$date_width + $time_width + $elder_width; + $date_width=250; $time_width=100; $elder_width=200; $location_width=100; + $appt_table_width=$date_width + $time_width + $elder_width + $location_width; $appt_header_row = "Date"; $appt_header_row.= "Time"; $appt_header_row.= "Elder"; + $appt_header_row.= "Location"; $appt_table_data = ""; $total_comps=0; $comps_with_quarterly_int=0; @@ -1802,6 +1848,19 @@ class eq $this->t->set_var('district_number',$districts[$d]['district']); $this->t->set_var('district_name',$districts[$d]['name']); $supervisor = $districts[$d]['supervisor']; + $supervisor_array = explode(",", $supervisor); + $supervisor_last_name = $supervisor_array[0]; + $sql = "SELECT * FROM eq_elder where elder='$supervisor'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $indiv_id = $this->db2->f('indiv_id'); + } + $sql = "SELECT * FROM eq_parent where indiv_id='$indiv_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $supervisor_address = $this->db2->f('address'); + } + $location = "$supervisor_last_name"." home ($supervisor_address)"; $table_title = "District ".$districts[$d]['district'].": ".$districts[$d]['name'].": All Elders with Interviews Not Completed"; $appt_table_title = "District ".$districts[$d]['district'].": ".$districts[$d]['name'].": Interview Appointment Slots"; $this->t->set_var('table_title',$table_title); @@ -1815,6 +1874,8 @@ class eq { $appointment = $this->db->f('appointment'); $elder = $this->db->f('elder'); + $location = $this->db->f('location'); + if(($location == "") && ($elder > 0)) { $location = "$supervisor_last_name"." home ($supervisor_address)"; } $date = $this->db->f('date'); $date_array = explode("-",$date); @@ -1839,7 +1900,11 @@ class eq } $appt_table_data.=''; + $appt_table_data.= ''; + $appt_table_data.= ''; + $appt_table_data.= ''; $tr_color = $this->nextmatchs->alternate_row_color($tr_color); $this->t->set_var('tr_color',$tr_color); @@ -2056,7 +2121,26 @@ class eq $table_data=""; $completed_data=""; $totals_data=""; $year = date('Y'); - + + // create the family id -> family name mapping + $sql = "SELECT * FROM eq_family where valid=1 and elder_id != 0 ORDER BY name ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + $family_id = NULL; + while ($this->db->next_record()) + { + $family_id[$i] = $this->db->f('family'); + $family_name[$i] = $this->db->f('name'); + $familyid2name[$family_id[$i]] = $family_name[$i]; + $sql = "SELECT * FROM eq_parent where family='$family_id[$i]'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $familyid2address[$family_id[$i]] = $this->db2->f('address'); + } + $i++; + } + array_multisort($family_name, $family_id); + if($action == 'save') { // Save any changes made to the appointment table @@ -2066,15 +2150,23 @@ class eq { $family = $entry['family']; $appointment = $entry['appointment']; + $location = $entry['location']; + if($location == "") { + $family_name_array = explode(",", $familyid2name[$family]); + $family_last_name = $family_name_array[0]; + $family_address = $familyid2address[$family]; + $location = "$family_last_name"." home ($family_address)"; + } + if($family == 0) { $location = ""; } //Only perform a database update if we have made a change to this appointment - $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and family='$family'"; + $sql = "SELECT * FROM eq_appointment where appointment='$appointment' and family='$family' and location='$location'"; $this->db->query($sql,__LINE__,__FILE__); if(!$this->db->next_record()) { - // Perform database save actions here $this->db->query("UPDATE eq_appointment set " . " family='" . $family . "'" . + ",location='" . $location . "'" . " WHERE appointment=" . $appointment,__LINE__,__FILE__); // Email the appointment @@ -2088,14 +2180,14 @@ class eq foreach ($new_data as $entry) { $visit_notes = $entry['notes']; - $family_id = $entry['family_id']; + $family = $entry['family_id']; $visit_pri = $entry['pri']; // Perform database save actions here $this->db->query("UPDATE eq_family set " . " visit_notes='" . $visit_notes . "'" . ",visit_pri='" . $visit_pri . "'" . - " WHERE family=" . $family_id,__LINE__,__FILE__); + " WHERE family=" . $family,__LINE__,__FILE__); } @@ -2104,11 +2196,12 @@ class eq } // APPOINTMENT TABLE - $date_width=150; $time_width=100; $family_width=250; - $appt_table_width=$date_width + $time_width + $family_width; + $date_width=250; $time_width=100; $family_width=250; $location_width=100; + $appt_table_width=$date_width + $time_width + $family_width + $location_width; $appt_header_row = "Date"; $appt_header_row.= "Time"; $appt_header_row.= "Family"; + $appt_header_row.= "Location"; $appt_table_data = ""; // Find out what the EQ Presidency ID is @@ -2121,20 +2214,7 @@ class eq print "

-E- Unable to locate EQ Presidency in eq_presidency table

"; return; } - - // create the family id -> family name mapping - $sql = "SELECT * FROM eq_family where valid=1 and elder_id != 0 ORDER BY name ASC"; - $this->db->query($sql,__LINE__,__FILE__); - $i=0; - $family_id = NULL; - while ($this->db->next_record()) - { - $family_id[$i] = $this->db->f('family'); - $family_name[$i] = $this->db->f('name'); - $i++; - } - array_multisort($family_name, $family_id); - + // query the database for all the appointments $sql = "SELECT * FROM eq_appointment where presidency=$presidency_id and date>=CURDATE() ORDER BY date ASC, time ASC"; $this->db->query($sql,__LINE__,__FILE__); @@ -2143,7 +2223,12 @@ class eq { $appointment = $this->db->f('appointment'); $family = $this->db->f('family'); - + $location = $this->db->f('location'); + $family_name_array = explode(",", $familyid2name[$family]); + $family_last_name = $family_name_array[0]; + $family_address = $familyid2address[$family]; + if(($location == "") && ($family > 0)) { $location = "$family_last_name"." home ($family_address)"; } + $date = $this->db->f('date'); $date_array = explode("-",$date); $year = $date_array[0]; $month = $date_array[1]; $day = $date_array[2]; @@ -2167,6 +2252,9 @@ class eq } $appt_table_data.=''; + $appt_table_data.= ''; + $appt_table_data.= ''; $tr_color = $this->nextmatchs->alternate_row_color($tr_color); @@ -3141,7 +3229,7 @@ class eq else if($current_month >= 4 && $current_month <= 6) { $current_month=6; } else if($current_month >= 7 && $current_month <= 9) { $current_month=9; } else if($current_month >= 10 && $current_month <= 12) { $current_month=12; } - + $sql = "SELECT * FROM eq_elder where valid=1"; $this->db->query($sql,__LINE__,__FILE__); $i=0; @@ -3157,10 +3245,10 @@ class eq $i=0; $last_time = 0; $found_sunday = 0; - $sunday_list[0]['date'] = date("Y-m-d", mktime(0, 0, 0, $current_month-$num_months, 1, date("y"))); + $sunday_list[0]['date'] = date("Y-m-d", mktime(0, 0, 0, ($current_month-$num_months)+1, 1, date("y"))); $last_date = explode("-",$sunday_list[0]['date']); $last_time = mktime(0, 0, 0, $last_date[1], $last_date[2], $last_date[0]); - $time_limit = mktime(0, 0, 0, date("m"), date("t"), date("y")); + $time_limit = mktime(0, 0, 0, $current_month, 31, date("y")); while($last_time < $time_limit) { $day = date("w",$last_time); @@ -3171,7 +3259,8 @@ class eq $sunday_list[$i]['day'] = $last_date[2]; $sunday_list[$i]['month'] = date("M",$last_time); $sunday_list[$i]['year'] = $last_date[0]; - $found_sunday = 1; + $found_sunday = 1; + $last_date = $sunday_list[$i]['date']; } $last_time += 90000; if($found_sunday) { $i++; $found_sunday=0; } @@ -3560,14 +3649,45 @@ class eq $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'); - $date_width=150; $time_width=200; $elder_width=200; $family_width=200; - $table_width=$date_width + $time_width + $elder_width + $family_width; + $date_width=150; $time_width=220; $elder_width=170; $family_width=180; $location_width=100; + $table_width=$date_width + $time_width + $elder_width + $family_width + $location_width; $header_row = "Date"; $header_row.= "Time"; $header_row.= "Elder"; $header_row.= "Family"; + $header_row.= "Location"; $table_data = ""; + $sql = "SELECT * FROM eq_presidency where valid=1"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + while ($this->db->next_record()) + { + $presidency_data[$i]['id'] = $this->db->f('presidency'); + $presidency_data[$i]['name'] = $this->db->f('name'); + $presidency_data[$i]['elder'] = $this->db->f('elder'); + $presidency2name[$presidency_data[$i]['id']] = $presidency_data[$i]['name']; + $presidency2elder[$presidency_data[$i]['id']] = $presidency_data[$i]['elder']; + $i++; + } + + $sql = "SELECT * FROM eq_family where valid=1 and elder_id != 0 ORDER BY name ASC"; + $this->db->query($sql,__LINE__,__FILE__); + $i=0; + while ($this->db->next_record()) + { + $family_id[$i] = $this->db->f('family'); + $family_name[$i] = $this->db->f('name'); + $familyid2name[$family_id[$i]] = $family_name[$i]; + $sql = "SELECT * FROM eq_parent where family='$family_id[$i]'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $familyid2address[$family_id[$i]] = $this->db2->f('address'); + } + $i++; + } + array_multisort($family_name, $family_id); + if($action == 'save') { $new_data = get_var('sched',array('POST')); @@ -3577,21 +3697,51 @@ class eq { $presidency = $entry['presidency']; $appointment = $entry['appointment']; + $location = $entry['location']; $date = $entry['date']; $hour = $entry['hour']; $minute = $entry['minute']; $pm = $entry['pm']; $elder = $entry['elder']; $family = $entry['family']; + $location = $entry['location']; if($pm) { $hour = $hour + 12; } $time = $hour.':'.$minute.':'.'00'; $uid = 0; + // Update our location + if($location == "") { + if($family > 0) { + $family_name_array = explode(",", $familyid2name[$family]); + $family_last_name = $family_name_array[0]; + $family_address = $familyid2address[$family]; + $location = "$family_last_name"." home ($family_address)"; + } + else if($elder > 0) { + $supervisor_name_array = explode(",",$presidency2name[$presidency]); + $supervisor_last_name = $supervisor_name_array[0]; + $sql = "SELECT * FROM eq_elder where elder='$presidency2elder[$presidency]'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $indiv_id = $this->db2->f('indiv_id'); + } + $sql = "SELECT * FROM eq_parent where indiv_id='$indiv_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $supervisor_address = $this->db2->f('address'); + } + $location = "$supervisor_last_name"." home ($supervisor_address)"; + } + } + // Zero out the family or elder if date = NULL if($date == "") { $elder = 0; $family = 0; + $location = ""; } + + if(($elder == 0) && ($family == 0)) { $location = ""; } // Update an existing appointment if($appointment < $this->max_appointments) @@ -3603,7 +3753,8 @@ class eq " and elder='$elder'" . " and family='$family'" . " and date='$date'" . - " and time='$time'"; + " and time='$time'" . + " and location='$location'"; $this->db->query($sql,__LINE__,__FILE__); if(!$this->db->next_record()) { $old_date = $this->db->f('date'); @@ -3613,6 +3764,7 @@ class eq " ,elder=" . $elder . " ,date='" . $date . "'" . " ,time='" . $time . "'" . + " ,location='" . $location . "'" . " ,presidency='" . $presidency . "'" . " WHERE appointment=" . $appointment,__LINE__,__FILE__); @@ -3625,9 +3777,9 @@ class eq else if(($appointment >= $this->max_appointments) && ($date != "") && ($time != "")) { //print "adding entry: appt=$appointment date: $date time: $time elder: $elder family: $family
"; - $this->db2->query("INSERT INTO eq_appointment (appointment,presidency,family,elder,date,time,uid) " - . "VALUES (NULL,'" . $presidency . "','" . $family . "','" - . $elder . "','" . $date . "','" . $time . "','" . $uid ."')",__LINE__,__FILE__); + $this->db2->query("INSERT INTO eq_appointment (appointment,presidency,family,elder,date,time,location,uid) " + . "VALUES (NULL,'" . $presidency . "','" . $family . "','" . $elder . "','" + . $date . "','" . $time . "','" . $location . "','" . $uid ."')",__LINE__,__FILE__); // Now reselect this entry from the database to see if we need // to send an appointment out for it. @@ -3637,7 +3789,8 @@ class eq " and presidency='$presidency'" . " and date='$date'" . " and time='$time'" . - " and uid='$uid'"; + " and uid='$uid'" . + " and location='$location'"; $this->db3->query($sql,__LINE__,__FILE__); if($this->db3->next_record()) { // Email the appointment if warranted @@ -3652,17 +3805,6 @@ class eq $take_me_to_url = $GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.schedule'); //Header('Location: ' . $take_me_to_url); } - - $sql = "SELECT * FROM eq_presidency where valid=1"; - $this->db->query($sql,__LINE__,__FILE__); - $i=0; - while ($this->db->next_record()) - { - $presidency_data[$i]['id'] = $this->db->f('presidency'); - $presidency_data[$i]['name'] = $this->db->f('name'); - $presidency_data[$i]['elder'] = $this->db->f('elder'); - $i++; - } $sql = "SELECT * FROM eq_elder where valid=1 ORDER BY elder ASC"; $this->db->query($sql,__LINE__,__FILE__); @@ -3675,17 +3817,6 @@ class eq $i++; } array_multisort($elder_name, $elder_id); - - $sql = "SELECT * FROM eq_family where valid=1 and elder_id != 0 ORDER BY name ASC"; - $this->db->query($sql,__LINE__,__FILE__); - $i=0; - while ($this->db->next_record()) - { - $family_id[$i] = $this->db->f('family'); - $family_name[$i] = $this->db->f('name'); - $i++; - } - array_multisort($family_name, $family_id); for ($i=0; $i < count($presidency_data); $i++) { $presidency = $presidency_data[$i]['id']; @@ -3704,6 +3835,31 @@ class eq $appointment = $this->db->f('appointment'); $elder = $this->db->f('elder'); $family = $this->db->f('family'); + $location = $this->db->f('location'); + + if($location == "") { + if($family > 0) { + $family_name_array = explode(",", $familyid2name[$family]); + $family_last_name = $family_name_array[0]; + $family_address = $familyid2address[$family]; + $location = "$family_last_name"." home ($family_address)"; + } + else if($elder > 0) { + $supervisor_name_array = explode(",",$presidency2name[$presidency]); + $supervisor_last_name = $supervisor_name_array[0]; + $sql = "SELECT * FROM eq_elder where elder='$presidency2elder[$presidency]'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $indiv_id = $this->db2->f('indiv_id'); + } + $sql = "SELECT * FROM eq_parent where indiv_id='$indiv_id'"; + $this->db2->query($sql,__LINE__,__FILE__); + if($this->db2->next_record()) { + $supervisor_address = $this->db2->f('address'); + } + $location = "$supervisor_last_name"." home ($supervisor_address)"; + } + } $date = $this->db->f('date'); $date_array = explode("-",$date); @@ -3731,7 +3887,7 @@ class eq $table_data.= ""; // Elder drop down list (for PPIs) - $table_data.= ''; $table_data.= ''; for ($j=0; $j < count($elder_id); $j++) { $id = $elder_id[$j]; @@ -3742,7 +3898,7 @@ class eq $table_data.=''; // Family drop down list (for Visits) - $table_data.= ''; $table_data.= ''; for ($j=0; $j < count($elder_id); $j++) { $id = $family_id[$j]; @@ -3751,6 +3907,10 @@ class eq $table_data.= ''; } $table_data.=''; + + // Location text box + $table_data.= ''; $table_data.= ''; $table_data.= ''; @@ -3776,7 +3936,7 @@ class eq $table_data.= ""; // Elder drop down list - $table_data.= ''; $table_data.= ''; for ($j=0; $j < count($elder_id); $j++) { $id = $elder_id[$j]; @@ -3786,7 +3946,7 @@ class eq $table_data.=''; // Family drop down list - $table_data.= ''; $table_data.= ''; for ($j=0; $j < count($elder_id); $j++) { $id = $family_id[$j]; @@ -3794,6 +3954,10 @@ class eq $table_data.= ''; } $table_data.=''; + + // Location text box + $table_data.= ''; $table_data.= ''; $table_data.= ''; @@ -3812,7 +3976,39 @@ class eq $this->t->pfp('out','sched_t'); $this->save_sessiondata(); } - + + function email() + { + $this->t->set_file(array('email_t' => 'email.tpl')); + $this->t->set_block('email_t','elder_list','list'); + + $action = get_var('action',array('GET','POST')); + + $this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.email')); + $this->t->set_var('title','EQ Email Tool'); + + $this->t->set_var('lang_email','Send Email'); + $this->t->set_var('lang_reset','Cancel'); + + $this->t->set_var('email_member_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.email&action=member')); + $this->t->set_var('email_member_link_title','Email Quorum Member'); + + $this->t->set_var('email_quorum_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.email&action=quorum')); + $this->t->set_var('email_quorum_link_title','Email Quorum'); + + $this->t->set_var('email_reminder_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.email&action=reminder')); + $this->t->set_var('email_reminder_link_title','Email Reminders'); + + $this->t->set_var('email_edit_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.email&action=edit')); + $this->t->set_var('email_edit_link_title','Edit Email Addresses'); + + $table_width=600; + $this->t->set_var('table_width',$table_width); + + $this->t->pfp('out','email_t'); + $this->save_sessiondata(); + } + function admin() { $this->t->set_file(array('admin_t' => 'admin.tpl')); @@ -4196,6 +4392,7 @@ class eq { $appointment = $this->db->f('appointment'); $presidency = $this->db->f('presidency'); + $location = $this->db->f('location'); $interviewer = ""; $email = ""; $elder = $this->db->f('elder'); @@ -4204,7 +4401,6 @@ class eq $family_name = ""; $appt_name = ""; $phone = ""; - $location = ""; $uid = $this->db->f('uid'); // Extract the year, month, day, hours, minutes, seconds from the appointment time @@ -4238,7 +4434,6 @@ class eq $elder_name = $this->db2->f('name'); $phone = $this->db2->f('phone'); $appt_name = $elder_name . " Interview"; - $location = "$interviewer"."'s home"; $duration = $this->default_ppi_appt_duration * 60; } } @@ -4256,11 +4451,6 @@ class eq if($this->db3->next_record()) { $phone = $this->db3->f('phone'); } - $sql = "SELECT * FROM eq_parent where family='$family'"; - $this->db3->query($sql,__LINE__,__FILE__); - if($this->db3->next_record()) { - $location=$this->db3->f('address'); - } $duration = $this->default_visit_appt_duration * 60; } }