function sqlAddOperation($partOperations, $partID) { global $opBeginDelimiter; global $opEndDelimiter; global $dataDelimiter; global $allBeginDelimiters; global $toolBeginDelimiter; global $progBeginDelimiter; global $machineBeginDelimiter; global $holderBeginDelimiter; global $toolHolderBeginDelimiter; if ($partOperations == NULL || $partOperations == "") { return; } $operationValues = getValues($partOperations, $opBeginDelimiter, $opEndDelimiter); $opOnlyDataCount = 0; $holderOnlyDataCount = 0; $mainProgramId = 0; $numOperationValues = count($operationValues); $numToolHolderOnlyData = 0; for ($idx = 0; $idx < $numOperationValues; $idx++) { $operationTokens = $operationValues[$idx]; $numOpTokens = count($operationTokens); for ($curOpToken = 0; $curOpToken < $numOpTokens; $curOpToken++) { $beginDelimiter = getBeginDelimiter($operationTokens[$curOpToken]); if ($beginDelimiter != "") { if ($beginDelimiter == $progBeginDelimiter) { $progId = sqlAddProgramForOperation($operationTokens[$curOpToken], $mainProgramId); if ($mainProgramId == 0) { $mainProgramId = $progId; } } else if ($beginDelimiter == $toolHolderBeginDelimiter) { $toolHolderOnlyData[$numToolHolderOnlyData++] = sqlAddAndGetToolHolderData($operationTokens[$curOpToken]); } else if ($beginDelimiter == $machineBeginDelimiter) { sqlAddMachine($operationTokens[$curOpToken]); } } else { $operationOnlyData[$opOnlyDataCount++] = $operationTokens[$curOpToken]; } } $operationName = $operationOnlyData[0]; $operationMachineID = $operationOnlyData[1]; $operationDescription = $operationOnlyData[2]; $operationCuttingTime = $operationOnlyData[3]; $operationClampingTime = $operationOnlyData[4]; $query = "INSERT INTO OPERATIONS (PartID, Name, Machine, Description, CuttingTime, ClampingTime) VALUES ('$partID', '$operationName', '$operationMachineID', '$operationDescription', '$operationCuttingTime', '$operationClampingTime');"; $result = sqlQuery($query); $opId = mysql_insert_id(); if (IsSet($toolHolderOnlyData)) { $numToolHolderOnlyData = count($toolHolderOnlyData); for ($idx = 0; $idx < $numToolHolderOnlyData; $idx++) { $toolHolderData = $toolHolderOnlyData[$idx]; $toolPartNumber = $toolHolderData[0]; $toolId = sqlGetToolIdFromDB($toolPartNumber); $holderName = $toolHolderData[1]; $holderId = sqlGetHolderIdFromDB($holderName); $toolRemarks = $toolHolderData[2]; $toolOverHang = $toolHolderData[3]; $toolLife = $toolHolderData[4]; $query = "INSERT INTO OPERATION_TOOL_HOLDER_MAPPING (OperationID, ToolID, HolderID, ToolLife, ToolOverHang, ToolRemark) VALUES ('$opId', '$toolId', '$holderId', '$toolLife', '$toolOverHang', '$toolRemark');"; $result = sqlQuery($query); } } } }
<HTML> <TITLE>Create/Report Resource</TITLE> <HEAD> <?php include ('variables.php'); include ('commonAPIs.php'); include ('sqlAPI.php'); include ('phpDebugAPI.php'); include ('sqlAddData.php'); include ('sqlGetData.php'); sqlConnect("root", "root", "PartsDB"); if (IsSet($_GET['AddMachine']) && $_GET['AddMachine'] == "true") { sqlAddMachine(); } else if (IsSet($_GET['AddSupplier']) && $_GET['AddSupplier'] == "true") { sqlAddSupplierFromPost(); } else if (IsSet($_GET['AddPart']) && $_GET['AddPart'] == "true") { sqlAddPart(); } else if (IsSet($_GET['AddTool']) && $_GET['AddTool'] == "true") { sqlAddToolFromPost(); } else if (IsSet($_GET['UpdateToolUsage']) && $_GET['UpdateToolUsage'] == "true") { sqlUpdateToolUsage(); } $machineNames = sqlGetMachines(); $toolPartNumbers = sqlGetTools(); $insertPartNumbers = sqlGetInserts(); $toolTypes = sqlGetToolTypes(); $holderNames = sqlGetHolders();