+ 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 schedule()
+ {
+ $this->t->set_file(array('sched_t' => 'schedule.tpl'));
+ $this->t->set_block('sched_t','district_list','list');
+
+ $action = get_var('action',array('GET','POST'));
+
+ $this->t->set_var('actionurl',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.schedule&action=save'));
+ $this->t->set_var('title','EQ Scheduling Tool');
+
+ $this->t->set_var('lang_save','Save Schedule');
+ $this->t->set_var('lang_reset','Cancel');
+
+ $this->t->set_var('schedule_ppi_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.ppi_sched'));
+ $this->t->set_var('schedule_ppi_link_title','Schedule Yearly PPIs');
+
+ $this->t->set_var('schedule_vis_link',$GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.vis_sched'));
+ $this->t->set_var('schedule_vis_link_title','Schedule Yearly Visits');
+
+ $date_width=150; $time_width=200; $elder_width=200; $family_width=200;
+ $table_width=$date_width + $time_width + $elder_width + $family_width;
+ $header_row = "<th width=$date_width><font size=-2>Date</th>";
+ $header_row.= "<th width=$time_width><font size=-2>Time</th>";
+ $header_row.= "<th width=$elder_width><font size=-2>Elder</th>";
+ $header_row.= "<th width=$family_width><font size=-2>Family</th>";
+ $table_data = "";
+
+ if($action == 'save')
+ {
+ $new_data = get_var('sched',array('POST'));
+ foreach ($new_data as $district_array)
+ {
+ foreach ($district_array as $entry)
+ {
+ $district = $entry['district'];
+ $appointment = $entry['appointment'];
+ $date = $entry['date'];
+ $hour = $entry['hour'];
+ $minute = $entry['minute'];
+ $pm = $entry['pm'];
+ $elder = $entry['elder'];
+ $family = $entry['family'];
+ if($pm) { $hour = $hour + 12; }
+ $time = $hour.':'.$minute.':'.'00';
+
+ // Update an existing appointment
+ if($appointment != 0)
+ {
+ $this->db->query("UPDATE eq_appointment set" .
+ " family=" . $family .
+ " ,elder=" . $elder .
+ " ,date='" . $date . "'" .
+ " ,time='" . $time . "'" .
+ " WHERE appointment=" . $appointment,__LINE__,__FILE__);
+
+ //print "updating entry: appt=$appointment date: $date time: $time elder: $elder family: $family<br>";
+ }
+
+ // Add a new appointment
+ else if(($appointment == 0) && ($date != "") && ($time != ""))
+ {
+ $this->db->query("INSERT INTO eq_appointment (appointment,district,family,elder,date,time) "
+ . "VALUES ('" . $appointment . "','" . $district . "','" . $family . "','"
+ . $elder . "','" . $date . "','" . $time ."')",__LINE__,__FILE__);
+
+ //print "adding entry: appt=$appointment date: $date time: $time elder: $elder family: $family<br>";
+ }
+ }
+ }
+
+ $take_me_to_url = $GLOBALS['phpgw']->link('/eq/index.php','menuaction=eq.eq.schedule');
+ Header('Location: ' . $take_me_to_url);
+ }
+
+ $sql = "SELECT * FROM eq_district where district != 0 ORDER BY district ASC";
+ $this->db->query($sql,__LINE__,__FILE__);
+ $i=0;
+ while ($this->db->next_record())
+ {
+ $districts[$i]['district'] = $this->db->f('district');
+ $districts[$i]['name'] = $this->db->f('name');
+ $districts[$i]['supervisor'] = $this->db->f('supervisor');
+ $i++;
+ }
+
+ $sql = "SELECT * FROM eq_elder where valid=1 ORDER BY elder ASC";
+ $this->db->query($sql,__LINE__,__FILE__);
+ $i=0;
+ while ($this->db->next_record())
+ {
+ $elder_id[$i] = $this->db->f('elder');
+ $elder_name[$i] = $this->db->f('name');
+ $elder_phone[$elder_id[$i]] = $this->db->f('phone');
+ $i++;
+ }
+ array_multisort($elder_name, $elder_id);
+
+ $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($districts); $i++) {
+ $district = $districts[$i]['district'];
+ $this->t->set_var('district_number',$districts[$i]['district']);
+ $this->t->set_var('district_name',$districts[$i]['name']);
+ $supervisor = $districts[$i]['supervisor'];
+ $table_data="";
+
+ // query the database for all the appointments
+ $sql = "SELECT * FROM eq_appointment where district=$district and date>=CURDATE() ORDER BY date ASC, time ASC";
+ $this->db->query($sql,__LINE__,__FILE__);
+
+ // Prefill any existing appointment slots
+ while ($this->db->next_record())
+ {
+ $appointment = $this->db->f('appointment');
+ $elder = $this->db->f('elder');
+ $family = $this->db->f('family');
+
+ $date = $this->db->f('date');
+ $date_array = explode("-",$date);
+ $year = $date_array[0]; $month = $date_array[1]; $day = $date_array[2];
+ $day_string = date("l d-M-Y", mktime(0,0,0,$month,$day,$year));
+
+ $time = $this->db->f('time');
+ $time_array = explode(":",$time);
+ $hour = $time_array[0];
+ $minute = $time_array[1];
+ $pm = 0;
+ if($hour > 12) { $pm=1; $hour = $hour - 12; }
+ $time_string = date("g:i a", mktime($time_array[0], $time_array[1], $time_array[2]));
+
+ $table_data.= "<tr bgcolor=". $this->t->get_var('tr_color') .">";
+
+ // Date selection
+ $table_data.= '<td align=left>';
+ $table_data.= $this->jscal->input('sched['.$district.']['.$appointment.'][date]',$date,'','','','','',$this->cal_options);
+ $table_data.= '</td>';
+
+ // Hour & Minutes selection
+ $table_data.= "<td align=center>";
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][hour]>';
+ foreach(range(1,12) as $num) {
+ if($hour == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
+ $table_data.= '<option value='.$num.' '.$selected[$num].'>'.$num.'</option>';
+ }
+ $table_data.= '</select>';
+ $table_data.= ' : ';
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][minute]>';
+ foreach(range(0,3) as $num) {
+ $num = $num * 15; if($num == 0) { $num = "00"; }
+ if($minute == $num) { $selected[$num] = 'selected="selected"'; } else { $selected[$num] = ''; }
+ $table_data.= '<option value='.$num.' '.$selected[$num].'>'.$num.'</option>';
+ }
+ $table_data.= '</select>';
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][pm]>';
+ if($pm == 0) { $table_data.= '<option value=0 selected>am</option>'; $table_data.= '<option value=1>pm</option>'; }
+ else { $table_data.= '<option value=0>am</option>'; $table_data.= '<option value=1 selected>pm</option>'; }
+ $table_data.= '</select>';
+ $table_data.= "</td>";
+
+ // Elder drop down list (for PPIs)
+ $table_data.= '<td align=center><select name=sched['.$district.']['.$appointment.'][elder]>';
+ $table_data.= '<option value=0></option>';
+ for ($j=0; $j < count($elder_id); $j++) {
+ $id = $elder_id[$j];
+ $name = $elder_name[$j];
+ if($elder_id[$j] == $elder) { $selected[$id] = 'selected="selected"'; } else { $selected[$id] = ''; }
+ $table_data.= '<option value='.$id.' '.$selected[$id].'>'.$name.'</option>';
+ }
+ $table_data.='</select></td>';
+
+ // Family drop down list (for Visits)
+ $table_data.= '<td align=center><select name=sched['.$district.']['.$appointment.'][family]>';
+ $table_data.= '<option value=0></option>';
+ for ($j=0; $j < count($elder_id); $j++) {
+ $id = $family_id[$j];
+ $name = $family_name[$j];
+ if($family_id[$j] == $family) { $selected[$id] = 'selected="selected"'; } else { $selected[$id] = ''; }
+ $table_data.= '<option value='.$id.' '.$selected[$id].'>'.$name.' Family</option>';
+ }
+ $table_data.='</select></td>';
+
+ $table_data.= '<input type=hidden name="sched['.$district.']['.$appointment.'][appointment]" value="'.$appointment.'">';
+ $table_data.= '<input type=hidden name="sched['.$district.']['.$appointment.'][district]" value="'.$district.'">';
+
+ $tr_color = $this->nextmatchs->alternate_row_color($tr_color);
+ $this->t->set_var('tr_color',$tr_color);
+
+ }
+
+ // Create blank appointment slot
+ $appointment = 0;
+ $table_data.= "<tr bgcolor=". $this->t->get_var('tr_color') .">";
+
+ // Date selection
+ $table_data.= '<td align=left>';
+ $table_data.= $this->jscal->input('sched['.$district.']['.$appointment.'][date]','','','','','','',$this->cal_options);
+ $table_data.= '</td>';
+
+ // Time selection
+ $table_data.= "<td align=center>";
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][hour]>';
+ $table_data.= '<option value=""></option>';
+ foreach(range(1,12) as $num) {
+ $table_data.= '<option value='.$num.' '.$selected[$num].'>'.$num.'</option>';
+ }
+ $table_data.= '</select>';
+ $table_data.= ' : ';
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][minute]>';
+ $table_data.= '<option value=""></option>';
+ foreach(range(0,3) as $num) {
+ $num = $num * 15; if($num == 0) { $num = "00"; }
+ $table_data.= '<option value='.$num.'>'.$num.'</option>';
+ }
+ $table_data.= '</select>';
+ $table_data.= '<select name=sched['.$district.']['.$appointment.'][pm]>';
+ $table_data.= '<option value=""></option>';
+ $table_data.= '<option value=0>am</option>';
+ $table_data.= '<option value=1>pm</option>';
+ $table_data.= '</select>';
+ $table_data.= "</td>";
+
+ // Elder drop down list
+ $table_data.= '<td align=center><select name=sched['.$district.']['.$appointment.'][elder]>';
+ $table_data.= '<option value=0></option>';
+ for ($j=0; $j < count($elder_id); $j++) {
+ $id = $elder_id[$j];
+ $name = $elder_name[$j];
+ $table_data.= '<option value='.$id.'>'.$name.'</option>';
+ }
+ $table_data.='</select></td>';
+
+ // Family drop down list
+ $table_data.= '<td align=center><select name=sched['.$district.']['.$appointment.'][family]>';
+ $table_data.= '<option value=0></option>';
+ for ($j=0; $j < count($elder_id); $j++) {
+ $id = $family_id[$j];
+ $name = $family_name[$j];
+ $table_data.= '<option value='.$id.'>'.$name.' Family</option>';
+ }
+ $table_data.='</select></td>';
+
+ $table_data.= '<input type=hidden name="sched['.$district.']['.$appointment.'][appointment]" value="'.$appointment.'">';
+ $table_data.= '<input type=hidden name="sched['.$district.']['.$appointment.'][district]" value="'.$district.'">';
+
+ $this->t->set_var('table_data',$table_data);
+ $this->t->set_var('header_row',$header_row);
+ $this->t->set_var('table_width',$table_width);
+ $this->t->fp('list','district_list',True);
+
+ }
+
+ $this->t->pfp('out','sched_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") ||
+ ($_FILES['uploadedfile']['type'] == "application/x-zip-compressed") ||
+ ($_FILES['uploadedfile']['type'] == "application/x-zip") ||
+ ($_FILES['uploadedfile']['type'] == "application/octet-stream")) &&
+ (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path))) {
+ $uploadstatus = "<b>The following file was uploaded successfully: </b><br><br>";
+ $uploadstatus.= "Filename : " . $_FILES['uploadedfile']['name'] . "<br>";
+ $uploadstatus.= "Type : " . $_FILES['uploadedfile']['type'] . "<br>";
+ $uploadstatus.= "Size : " . $_FILES['uploadedfile']['size'] . "<br>";
+ $this->t->set_var('uploadstatus',$uploadstatus);
+ $this->t->pfp('uploadhandle','upload');
+ $this->t->set_var('uploadhandle','');
+ print "<table border=1 width=80%><tr><td>\n<pre>";
+
+ # 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<br>\n";
+ exec('mkdir ' . $data_dir . ' 2>&1', $result, $return_code);
+ if($return_code != 0) {
+ print implode('\n',$result) . "<br>";
+ print "<b><font color=red>";
+ print "-E- Unable to create the data directory. Aborting import.";
+ print "</font></b>";
+ return 0;
+ }
+
+ # move the file uploaded into this directory
+ print "-> Moving the uploaded file into the data dir<br>\n";
+ exec('mv ' . $target_path . ' ' . $data_dir . '/' . ' 2>&1', $result, $return_code);
+ if($return_code != 0) {
+ print implode('\n',$result) . "<br>";
+ print "<b><font color=red>";
+ print "-E- Unable to move the uploaded file into the data dir. Aborting import.";
+ print "</font></b>";
+ return 0;
+ }
+
+ # unzip the data into this directory
+ print "-> Unzipping the data<br>\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) . "<br>";
+ print "<b><font color=red>";
+ print "-E- Unable to unzip the uploaded file into the data dir. Aborting import.";
+ print "</font></b>";
+ 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<br>\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) . "<br>";
+ print "<b><font color=red>";
+ print "-E- Unable to update the data latest link. Aborting import.";
+ print "</font></b>";
+ 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<br>\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<br>";
+ #print "parse_cmd: $parse_cmd<br>";
+ 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 "</pre></td></tr></table>";
+
+ } 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 = "<b><font color=red>The file format must be a .zip file, please try again! </font></b>";
+ $uploadstatus.= "<br><br><b>Detected file format: " . $_FILES['uploadedfile']['type'] . "</b>";
+ $this->t->set_var('uploadstatus',$uploadstatus);
+ $this->t->pfp('uploadhandle','upload',True);
+ } else {
+ $uploadstatus = "<b><font color=red> There was an error (" . $_FILES['uploadedfile']['error'];
+ $uploadstatus.= ") uploading the file, please try again! </font></b>";
+ $this->t->set_var('uploadstatus',$uploadstatus);
+ $this->t->pfp('uploadhandle','upload',True);
+ }
+ }
+ else
+ {
+ $this->t->set_var('adminhandle','');
+ $this->t->pfp('adminhandle','admin');
+ }
+
+ $this->save_sessiondata();
+ }
+