function delete_record($useUUID = false) { if (!$useUUID) { $whereclause = $this->buildWhereClause(); //support tables link to tabledefs using uuids not ids, so we must make sure that they are uuids. $this->idsArray = getUuidArray($this->db, "tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3", $this->idsArray); } else { $whereclause = $this->buildWhereClause($this->maintable . ".uuid"); } //passed variable is array of user ids to be revoked $linkedwhereclause = ""; $relationshipswhereclause = ""; $linkedwhereclause = $this->buildWhereClause("tabledefid"); $relationshipswhereclause = $this->buildWhereClause("fromtableid") . " OR " . $this->buildWhereClause("totableid"); $querystatement = "DELETE FROM tablecolumns WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM tablefindoptions WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM tableoptions WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM tablesearchablefields WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM usersearches WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM relationships WHERE " . $relationshipswhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM tabledefs WHERE " . $whereclause . ";"; $queryresult = $this->db->query($querystatement); $message = $this->buildStatusMessage(); $message .= " deleted."; return $message; }
function delete_record($useUUID = false) { if (!$useUUID) { $whereclause = $this->buildWhereClause(); //attachments.fileid must be a uuid and not an id. //so, we adjust the attachment where clause to always be //uuids. $this->idsArray = getUuidArray($this->db, "tbld:80b4f38d-b957-bced-c0a0-ed08a0db6475", $this->idsArray); } else { $whereclause = $this->buildWhereClause($this->maintable . ".uuid"); } $attachmentwhereclause = $this->buildWhereClause("attachments.fileid"); $querystatement = "DELETE FROM attachments WHERE " . $attachmentwhereclause . " AND attachments.fileid!='file:c1818692-cfaa-8536-7f62-e385c0f6920d';"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM files WHERE " . $whereclause . " AND files.uuid!='file:c1818692-cfaa-8536-7f62-e385c0f6920d';"; $queryresult = $this->db->query($querystatement); $message = $this->buildStatusMessage(); $message .= " deleted"; return $message; }
function delete_record($useUUID = false) { if (!$useUUID) { $whereclause = $this->buildWhereClause(); //support tables link to tabledefs using uuids not ids, so we must make sure that they are uuids. $this->idsArray = getUuidArray($this->db, "tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb", $this->idsArray); } else { $whereclause = $this->buildWhereClause($this->maintable . ".uuid"); } $linkedwhereclause = $this->buildWhereClause("reportuuid"); $querystatement = "DELETE FROM reportsettings WHERE " . $linkedwhereclause . ";"; $queryresult = $this->db->query($querystatement); $querystatement = "DELETE FROM reports WHERE " . $whereclause . ";"; $queryresult = $this->db->query($querystatement); $message = $this->buildStatusMessage(); $message .= " deleted."; return $message; }
function runPush($pushRecordUuid) { include_once "modules/api/include/push.php"; $uuidArray = getUuidArray($this->db, $this->tabledefuuid, $this->idsArray); if ($uuidArray === false) { $uuidArray = array(); } $push = new push($this->db, $pushRecordUuid, $uuidArray); $thereturn = $push->process(); if ($thereturn !== false) { $message = count($push->uuidArray) . " record(s) pushed."; } else { $message = "An error has occured."; } return $message; }
function delete_record($useUUID = false) { if (!$useUUID) { $whereclause = $this->buildWhereClause(); //menu.parentid must be a uuid and not an id. //so, we adjust the verify where clause to always be //uuids. $this->idsArray = getUuidArray($this->db, "tbld:83187e3d-101e-a8a5-037f-31e9800fed2d", $this->idsArray); } else { $whereclause = $this->buildWhereClause($this->maintable . ".uuid"); } $verifywhereclause = $this->buildWhereClause("menu.parentid"); $querystatement = "SELECT id FROM menu WHERE " . $verifywhereclause; $queryresult = $this->db->query($querystatement); if (!$this->db->numRows($queryresult)) { $querystatement = "DELETE FROM menu WHERE " . $whereclause; $queryresult = $this->db->query($querystatement); } $message = $this->buildStatusMessage(); $message .= " deleted."; return $message; }