function InsertWorkOrder($WorkOrderDetails, $user, $password) { $Errors = array(); $db = db($user, $password); if (gettype($db) == 'integer') { $Errors[0] = NoAuthorisation; return $Errors; } foreach ($WorkOrderDetails as $key => $value) { $WorkOrderDetails[$key] = DB_escape_string($value); } $WorkOrder['wo'] = GetNextTransactionNo(40, $db); $WorkOrderItem['wo'] = $WorkOrder['wo']; if (isset($WorkOrderDetails['loccode'])) { $Errors = VerifyFromStockLocation($WorkOrderDetails['loccode'], sizeof($Errors), $Errors, $db); $WorkOrder['loccode'] = $WorkOrderDetails['loccode']; } if (isset($WorkOrderDetails['requiredby'])) { // $Errors=VerifyRequiredByDate($WorkOrderDetails['requiredby'], sizeof($Errors), $Errors, $db); $WorkOrder['requiredby'] = $WorkOrderDetails['requiredby']; } if (isset($WorkOrderDetails['startdate'])) { // $Errors=VerifyStartDate($WorkOrderDetails['startdate'], sizeof($Errors), $Errors, $db); $WorkOrder['startdate'] = $WorkOrderDetails['startdate']; } if (isset($WorkOrderDetails['costissued'])) { $Errors = VerifyCostIssued($WorkOrderDetails['costissued'], sizeof($Errors), $Errors, $db); $WorkOrder['costissued'] = $WorkOrderDetails['costissued']; } if (isset($WorkOrderDetails['closed'])) { $Errors = VerifyCompleted($WorkOrderDetails['closed'], sizeof($Errors), $Errors); $WorkOrder['closed'] = $WorkOrderDetails['closed']; } if (isset($WorkOrderDetails['stockid'])) { $Errors = VerifyStockCodeExists($WorkOrderDetails['stockid'], sizeof($Errors), $Errors, $db); $WorkOrderItem['stockid'] = $WorkOrderDetails['stockid']; } if (isset($WorkOrderDetails['qtyreqd'])) { $Errors = VerifyQtyReqd($WorkOrderDetails['qtyreqd'], sizeof($Errors), $Errors); $WorkOrderItem['qtyreqd'] = $WorkOrderDetails['qtyreqd']; } if (isset($WorkOrderDetails['qtyrecd'])) { $Errors = VerifyQtyRecd($WorkOrderDetails['qtyrecd'], sizeof($Errors), $Errors); $WorkOrderItem['qtyrecd'] = $WorkOrderDetails['qtyrecd']; } if (isset($WorkOrderDetails['stdcost'])) { $Errors = VerifyStdCost($WorkOrderDetails['stdcost'], sizeof($Errors), $Errors); $WorkOrderItem['stdcost'] = $WorkOrderDetails['stdcost']; } if (isset($WorkOrderDetails['nextlotsnref'])) { $Errors = VerifyLotSerialNumber($WorkOrderDetails['nextlotsnref'], sizeof($Errors), $Errors); $WorkOrderItem['nextlotsnref'] = $WorkOrderDetails['nextlotsnref']; } $WOFieldNames = ''; $WOFieldValues = ''; foreach ($WorkOrder as $key => $value) { $WOFieldNames .= $key . ', '; $WOFieldValues .= '"' . $value . '", '; } $ItemFieldNames = ''; $ItemFieldValues = ''; foreach ($WorkOrderItem as $key => $value) { $ItemFieldNames .= $key . ', '; $ItemFieldValues .= '"' . $value . '", '; } if (sizeof($Errors) == 0) { $wosql = 'INSERT INTO workorders (' . substr($WOFieldNames, 0, -2) . ') ' . 'VALUES (' . substr($WOFieldValues, 0, -2) . ') '; $itemsql = 'INSERT INTO woitems (' . substr($ItemFieldNames, 0, -2) . ') ' . 'VALUES (' . substr($ItemFieldValues, 0, -2) . ') '; $systypessql = 'UPDATE systypes set typeno=' . GetNextTransactionNo(40, $db) . ' where typeid=40'; DB_Txn_Begin($db); $woresult = DB_Query($wosql, $db); $itemresult = DB_Query($itemsql, $db); $systyperesult = DB_Query($systypessql, $db); DB_Txn_Commit($db); if (DB_error_no($db) != 0) { $Errors[0] = DatabaseUpdateFailed; } else { $Errors[0] = 0; $Errors[1] = $WorkOrder['wo']; } } return $Errors; }
function ModifySalesOrderLine($OrderLine, $user, $password) { $Errors = array(); $db = db($user, $password); if (gettype($db) == 'integer') { $Errors[0] = NoAuthorisation; return $Errors; } foreach ($OrderLine as $key => $value) { $OrderLine[$key] = DB_escape_string($value); } $Errors = VerifyOrderHeaderExists($OrderLine['orderno'], sizeof($Errors), $Errors, $db); $Errors = VerifyStockCodeExists($OrderLine['stkcode'], sizeof($Errors), $Errors, $db); if (isset($OrderLine['unitprice'])) { $Errors = VerifyUnitPrice($OrderLine['unitprice'], sizeof($Errors), $Errors); } if (isset($OrderLine['quantity'])) { $Errors = VerifyQuantity($OrderLine['quantity'], sizeof($Errors), $Errors); } if (isset($OrderLine['qtyinvoiced'])) { $Errors = VerifyQuantityInvoiced($OrderLine['qtyinvoiced'], sizeof($Errors), $Errors); } if (isset($OrderLine['discountpercent'])) { $OrderLine['discountpercent'] = $OrderLine['discountpercent'] / 100; $Errors = VerifyDiscountPercent($OrderLine['discountpercent'], sizeof($Errors), $Errors); } if (isset($OrderLine['narrative'])) { $Errors = VerifyDiscountPercent($OrderLine['narrative'], sizeof($Errors), $Errors); } if (isset($OrderLine['actualdispatchdate'])) { $Errors = VerifyActualDispatchDate($OrderLine['actualdispatchdate'], sizeof($Errors), $Errors); } if (isset($OrderLine['itemdue'])) { $Errors = VerifyItemDueDate($OrderLine['itemdue'], sizeof($Errors), $Errors); } if (isset($OrderLine['completed'])) { $Errors = VerifyCompleted($OrderLine['completed'], sizeof($Errors), $Errors); } if (isset($OrderLine['poline'])) { $Errors = VerifyPOLine($OrderLine['poline'], sizeof($Errors), $Errors); } $sql = 'UPDATE salesorderdetails SET '; foreach ($OrderLine as $key => $value) { $sql .= $key . '="' . $value . '", '; } $sql = substr($sql, 0, -2) . ' WHERE orderno="' . $OrderLine['orderno'] . '" and " orderlineno=' . $OrderLine['orderlineno']; if (sizeof($Errors) == 0) { $result = DB_Query($sql, $db); echo DB_error_no($db); if (DB_error_no($db) != 0) { $Errors[0] = DatabaseUpdateFailed; } else { $Errors[0] = 0; } } return $Errors; }