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