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