function deletePlotter($plotterId) { $obj->successful = true; $obj->method = 'deletePlotter'; // If plotter to delete is already cutted we need to restablish mts to the rolls // (i'm doing a restore plotter just to reuse code, it will be deleted later anywise) $query = "SELECT * FROM plotters WHERE id = '{$plotterId}'"; $result = mysql_query($query); $rows = fetch_array($result); // unique result if ($rows[0]['cutted'] == true || $rows[0]['cutted'] == '1') { $plotter = new stdClass(); $plotter->id = $plotterId; $plotter->cuts = array(); $query = "SELECT * FROM plottercuts WHERE plotterId = '{$plotterId}'"; $result = mysql_query($query); $cutsrows = fetch_array($result); foreach ($cutsrows as $row) { $cut = new stdClass(); $cut->mtsCutted = $row['mtsCutted']; $cut->rollId = $row['rollId']; array_push($plotter->cuts, $cut); } restorePlotter($plotter); } // insert in removed plotters $query = "INSERT INTO removedplotters SELECT *, now() FROM plotters WHERE id = '{$plotterId}'"; if (!mysql_query($query)) { $obj->successful = false; $obj->query = $query; } // delete plotter $query = "DELETE FROM plotters WHERE id = '" . $plotterId . "'"; if (!mysql_query($query)) { $obj->successful = false; $obj->query = $query; } // delete assigned cuts (Note: plotter cuts assigned but not cutted are not reduced from roll mts so no need to restore nothing here) $query = "DELETE FROM plottercuts WHERE plotterId = '{$plotterId}'"; if (!mysql_query($query)) { $obj->successful = false; $obj->query = $query; } // TODO possible after removing a plotter the prevision get in allCutted state -> include info in response $prevision = checkAllClothsCutted($rows[0]['previsionId']); $obj->allCutted = $prevision['allCutted']; $obj->plotterId = $plotterId; $obj->row0 = $rows[0]; return $obj; }
if (isset($_GET['clothId'])) { $value = getPrevisions($_GET['clothId'], $designed, $expand, null); } else { if (isset($_GET['listForProduction'])) { // deprecated - use with POST $value = getPrevisions(null, null, $expand, true, null, $_GET['sellerCode'], $filters); } else { if (isset($_GET['listHistoric'])) { // deprecated - use with POST $value = getPrevisions(null, null, $expand, null, true, $_GET['sellerCode']); } else { if (isset($_GET['expand']) && $_GET['expand'] == 'NONE') { $value = getPrevisionsBasic(); } else { if (isset($_GET['checkAllClothsCutted'])) { $value = checkAllClothsCutted($_GET['previsionId']); } else { if (isset($_GET['updateAllPrevisionsStates'])) { $value = updateAllPrevisionsStates($_GET['updateClothId'], $_GET['limit'], $_GET['offset']); } else { if (isset($_GET['updatePrevisionState'])) { $value = updatePrevisionState($_GET['updateClothId']); } else { if (isset($_GET['weeksBySeason'])) { $value = getWeeksBySeason($_GET['weeksBySeason']); } else { $value = getPrevisions(null, $designed, $expand, null); } } } }