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