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);
}
