$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';
+ $link_data['elder'] = $id;
+ $link_data['aaronic'] = 0;
+ $link_data['name'] = $name;
+ $link_data['ppi'] = '';
+ $link_data['eqpresppi'] = 1;
+ $link_data['action'] = 'add';
+ $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data);
$table_data.= "<tr bgcolor=". $this->t->get_var('tr_color') ."><td title=\"$phone\"><a href=$link>$name</a></td>";
$table_data.= "<td align=center>$phone</td>";
//$table_data.= "<td align=center>$ppi_pri</td>";
$appt_table_data = "";
// create the family id -> family name mapping
- $sql = "SELECT * FROM eq_family where valid=1 and companionship != 0 ORDER BY name ASC";
+ $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;
// VISIT SCHEDULING TABLE
- $sql = "SELECT * FROM eq_family where valid=1 and companionship != 0 ORDER BY visit_pri ASC";
+ $sql = "SELECT * FROM eq_family where valid=1 and elder_id != 0 ORDER BY visit_pri ASC";
$this->db->query($sql,__LINE__,__FILE__);
$total_families=0; $families_with_yearly_visit=0;
$sql = "SELECT * FROM eq_visit WHERE family=" . $id . " AND companionship=0 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.vis_update';
+ $link_data['visit'] = '';
+ $link_data['family'] = $id;
+ $link_data['name'] = $name;
+ $link_data['action'] = 'add';
+ $link = $GLOBALS['phpgw']->link('/eq/index.php',$link_data);
$table_data.= "<tr bgcolor=". $this->t->get_var('tr_color') ."><td title=\"$phone\"><a href=$link>$name Family</a></td>";
$table_data.= "<td align=center>$phone</td>";
$table_data.= "<td align=center>";
}
array_multisort($elder_name, $elder_id);
- $sql = "SELECT * FROM eq_family where valid=1 and companionship != 0 ORDER BY name ASC";
+ $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())
{
$target_path = $this->upload_target_path . basename( $_FILES['uploadedfile']['name']);
- if((($_FILES['uploadedfile']['type'] == "application/zip") || ($_FILES['uploadedfile']['type'] == "application/x-zip-compressed")) &&
+ 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>";
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-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);