function toDesignPlotter($plotter) { $obj->successful = true; $obj->method = 'toDesignPlotter'; logPrevisionUpdateFull($plotter->previsionId, 'toDesignPlotter'); // prevision back to in design state $update = "UPDATE previsions set designed = false where id = '" . $plotter->previsionId . "'"; if (!mysql_query($update)) { $obj->successful = false; $obj->updatePrevision = $update; } else { $select = "SELECT * from previsions where id = '" . $plotter->previsionId . "'"; $result = mysql_query($select); $obj->prevision = reset(fetch_array($result)); $obj->query = $select; } // remove all plotters with the same prevision id $query = "SELECT p.* FROM plotters p join previsions pre on pre.id = p.previsionId WHERE pre.id = '" . $plotter->previsionId . "'"; $result = mysql_query($query); $obj->deletePlotterResults = array(); $rows = fetch_array($result); foreach ($rows as $row) { $result = deletePlotter($row['id']); if (!$result->successful) { $obj->successful = false; $obj->query = $result->query; $obj->submethod = $result->method; } array_push($obj->deletePlotterResults, $result); } return $obj; }
function deletePrevision($id) { $obj->successful = true; // delete $query = "DELETE FROM previsioncloth WHERE previsionId = '" . $id . "'"; if (!mysql_query($query)) { $obj->successful = false; } logPrevisionUpdateFull($id, 'deletePrevision'); $query = "DELETE FROM previsions WHERE id = '" . $id . "'"; if (!mysql_query($query)) { $obj->successful = false; } return $obj; }
function acceptStateChange($prevision) { $obj->successful = true; $obj->method = 'acceptStateChange()'; logPrevisionUpdateFull($prevision->id, 'acceptStateChange'); $update = "UPDATE previsions\n\t\t\t\t\t\t SET stateAccepted = true,\n\t\t\t\t\t\t\t\t\t\tstateAcceptedDate = now()\n\t\t\t\t\t WHERE id = '" . $prevision->id . "'"; if (!mysql_query($update)) { $obj->successful = false; $obj->update = $update; } return $obj; }