public function toDatabase(JDatabaseQuery &$query) { parent::toDatabase($query); $query->set("startdate = '" . $query->escape(strftime("%Y-%m-%d", $this->start)) . "'"); $query->set("enddate = '" . $query->escape(strftime("%Y-%m-%d", $this->endDate)) . "'"); $query->set("nocontactofficehours = " . (int) $this->noContactOfficeHours); $query->set("challenge = " . (int) $this->challenge); $query->set("swg = " . (int) $this->swg); $query->set("version = " . $this->alterations->version); $query->set("lastmodified = '" . $query->escape($this->alterations->lastModified) . "'"); $query->set('detailsaltered = ' . (int) $this->alterations->details); $query->set('cancelled = ' . (int) $this->alterations->cancelled); $query->set('organiseraltered = ' . (int) $this->alterations->organiser); $query->set('datealtered = ' . (int) $this->alterations->date); if (!empty($this->latLng)) { $query->set("latitude = " . $this->latLng->lat); $query->set("longitude = " . $this->latLng->lng); } else { $query->set("latitude = NULL"); $query->set("longitude = NULL"); } }
public function toDatabase(JDatabaseQuery &$query) { $query->set("on_date = '" . $query->escape(strftime("%Y-%m-%d", $this->start)) . "'"); if (date("Hi", $this->start) != 0) { $query->set("starttime = '" . $query->escape(strftime("%H:%M", $this->start)) . "'"); } else { $query->set("starttime = NULL"); } if (!empty($this->end)) { $query->set("endtime = '" . $query->escape(strftime("%H:%M", $this->end)) . "'"); } else { $query->set("endtime = NULL"); } if (!empty($this->newMemberStart)) { $query->set("newmemberstart = '" . $query->escape(strftime("%H:%M", $this->newMemberStart)) . "'"); } else { $query->set("newmemberstart = NULL"); } if (!empty($this->newMemberEnd)) { $query->set("newmemberend = '" . $query->escape(strftime("%H:%M", $this->newMemberEnd)) . "'"); } else { $query->set("newmemberend = NULL"); } $query->set("version = " . $this->alterations->version); $query->set("lastmodified = '" . $query->escape($this->alterations->lastModified) . "'"); $query->set('detailsaltered = ' . (int) $this->alterations->details); $query->set('cancelled = ' . (int) $this->alterations->cancelled); $query->set('placetimealtered = ' . (int) $this->alterations->placeTime); $query->set('organiseraltered = ' . (int) $this->alterations->organiser); $query->set('datealtered = ' . (int) $this->alterations->date); if (!empty($this->latLng)) { $query->set("latitude = " . $this->latLng->lat); $query->set("longitude = " . $this->latLng->lng); } else { $query->set("latitude = NULL"); $query->set("longitude = NULL"); } parent::toDatabase($query); }
public function toDatabase(JDatabaseQuery &$query) { parent::toDatabase($query); if (!empty($this->start)) { $query->set("WalkDate = '" . $query->escape(strftime("%Y-%m-%d", $this->start)) . "'"); $query->set("meettime = '" . $query->escape(strftime("%H:%M", $this->start)) . "'"); } /* Commented out by Tom G - columns become duplicated for unknown reasons if (!empty($this->meetPoint)) { $query->set("meetplace = ". (int)$this->meetPoint->id); $query->set("meetplacetime = '". $query->escape($this->meetPoint->extra)."'"); } else if (!empty($this->meetPointId)) { $query->set("meetplace = ". (int)$this->meetPointId); $query->set("meetplacetime = '". $query->escape($this->meetPlaceTime)."'"); } else { $query->set("meetplace = 0"); $query->set("meetplacetime = '". $query->escape($this->meetPlaceTime)."'"); } if (!empty($this->leaderId)) $query->set("leaderid = ". (int)$this->leaderId); else $query->set("leaderid = ".Leader::TBC); // TBC */ if (isset($this->leader) && $this->leader->hasDisplayName) { $query->set("leadername = '" . $query->escape($this->leader->displayName) . "'"); } elseif (isset($this->leaderName)) { $query->set("leadername = '" . $query->escape($this->leaderName) . "'"); } else { $query->set("leadername = ''"); } /* Commented out by Tom G - columns become duplicated for unknown reasons if (!empty($this->backmarkerId)) $query->set("backmarkerid = ". (int)$this->backmarkerId); else $query->set("backmarkerid = ".Leader::TBC); // TBC */ if (isset($this->backmarker) && $this->backmarker->hasDisplayName) { $query->set("backmarkername = '" . $query->escape($this->backmarker->displayName) . "'"); } elseif (isset($this->backmarkerName)) { $query->set("backmarkername = '" . $query->escape($this->backmarkerName) . "'"); } else { $query->set("backmarkername = ''"); } if (isset($this->distance)) { $query->set("distance = " . (int) $this->distance); } if (isset($this->headCount)) { $query->set("headcount = " . (int) $this->headCount); } $query->set('version = ' . (int) $this->alterations->version); $query->set('lastmodified = ' . (int) $this->alterations->lastModified); $query->set('detailsaltered = ' . (int) $this->alterations->details); $query->set('cancelled = ' . (int) $this->alterations->cancelled); $query->set('meetplacetimedetailsaltered = ' . (int) $this->alterations->placeTime); $query->set('walkleaderdetailsaltered = ' . (int) $this->alterations->organiser); $query->set('datealtered = ' . (int) $this->alterations->date); }