function checkAnyErrors(&$wine_name, &$winery_name, &$minCost, &$maxCost, &$minStock, &$minOrdered, &$minInputYear, &$maxInputYear, $minYear, $maxYear)
{
if (!checkValidText($wine_name)) {
$wine_name = '';
return 'Please check that there are no invalid' . '\\ncharacters entered for Wine name';
} elseif (!checkValidText($winery_name)) {
$winery_name = '';
return 'Please check that there are no invalid' . '\\ncharacters entered for Winery name';
} elseif (!checkValidCurr($minCost) || !checkValidCurr($maxCost)) {
$minCost = '';
$maxCost = '';
return 'Please check that currency is written in the correct ' . '\\nformat for cost of Wine with up to 2 decimal places';
} elseif (!checkValidNum($minStock)) {
$minStock = '';
return 'Please ensure that a valid whole number is entered' . '\\nfor the number of Wines in stock';
} elseif (!checkValidNum($minOrdered)) {
$minOrdered = '';
return 'Please ensure that a valid whole number is entered' . '\\nfor the minimum number of Wines ordered';
} elseif (!checkValidYear($minYear, $maxYear, $minInputYear, $maxInputYear)) {
$minInputYear = '';
$maxInputYear = '';
return 'Please make sure that year range is between' . '\\n' . $minYear . ' and ' . $maxYear . ' for Wine year';
} else {
/*reset all fields if no errors*/
$wine_name = '';
$winery_name = '';
$minCost = '';
$maxCost = '';
$minStock = '';
$minOrdered = '';
$minInputYear = '';
$maxInputYear = '';
return 'none';
}
}
function validateDiscography($form)
{
global $db;
if (!checkEmpty($form['year']) && !checkLength($form['year'], 4)) {
$msg = str_replace('%field%', _LBL_YEAR, _ALRT_CHECK_LENGTH);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
if (!checkEmpty($form['year']) && !checkValidYear($form['year'])) {
$msg = str_replace('field', _LBL_YEAR, _ALRT_VALID_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
if (!checkEmpty($form['album']) && !checkLength($form['album'], 255)) {
$msg = str_replace('%field%', _LBL_ALBUM, _ALRT_CHECK_LENGTH);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
if (!checkEmpty($form['label']) && !checkLength($form['label'], 255)) {
$msg = str_replace('%field%', _LBL_LABEL, _ALRT_CHECK_LENGTH);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
if (!checkEmpty($form['year'])) {
if (checkEmpty($form['album'])) {
$msg = str_replace('field', _LBL_ALBUM, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
} else {
if (checkEmpty($form['label'])) {
$msg = str_replace('field', _LBL_LABEL, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
}
}
if (!checkEmpty($form['album'])) {
if (checkEmpty($form['year'])) {
$msg = str_replace('field', _LBL_YEAR, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
} else {
if (checkEmpty($form['label'])) {
$msg = str_replace('field', _LBL_LABEL, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
}
}
if (!checkEmpty($form['label'])) {
if (checkEmpty($form['year'])) {
$msg = str_replace('field', _LBL_YEAR, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
} else {
if (checkEmpty($form['album'])) {
$msg = str_replace('field', _LBL_ALBUM, _ALRT_REQUIRED_FIELD);
$show_tab_type = 'DISCG_INFO';
return $msg;
}
}
}
if (isset($form['album_id'])) {
$discg_select = "SELECT * FROM xebura_ARTIST_DISCOG \r\n\t\t\tWHERE AF_ARTIST_DISCOG_NAME = '" . stripslashes($form['album']) . "'\r\n\t\t\tAND AF_ARTIST_DISCOG_CATEGORY = '" . stripslashes($form['category']) . "' \r\n\t\t\tAND AF_ARTIST_DISCOG_ID != '" . $form['album_id'] . "'\r\n\t\t\tAND AF_ARTIST_ID = '" . $_SESSION['User_Account_Id'] . "'";
} else {
$discg_select = "SELECT * FROM xebura_ARTIST_DISCOG \r\n\t\t\tWHERE AF_ARTIST_DISCOG_NAME = '" . stripslashes($form['album']) . "'\r\n\t\t\tAND AF_ARTIST_DISCOG_CATEGORY = '" . stripslashes($form['category']) . "'\r\n\t\t\tAND AF_ARTIST_ID = '" . $_SESSION['User_Account_Id'] . "'";
}
if ($db->query_affected_rows($discg_select) > 0) {
$msg = _CHECK_DUPLICATE_DISCOGRAPHY;
$show_tab_type = 'DISCG_INFO';
return $msg;
}
return true;
}
