Esempio n. 1
0
function validateAddition($var_list)
{
    global $conn;
    $arr_check = array("open", "closed", "escalated");
    if (in_array(strtolower(trim($var_list)), $arr_check) == true) {
        return false;
    }
    $sql = "Select vLookUpValue from sptbl_lookup where vLookUpName='ExtraStatus' and vLookUpValue='{$var_list}'";
    $var_result = executeSelect($sql, $conn);
    if (mysql_num_rows($var_result) > 0) {
        return false;
    } elseif (isValidStatus($var_list)) {
        return true;
    }
}
Esempio n. 2
0
function validateAddition()
{
    global $conn;
    //check priroty value exist
    if (!isValidStatus($_POST['txtExtraPrty'])) {
        return false;
    }
    $sql = "Select * from sptbl_priorities where nPriorityValue='" . mysql_real_escape_string($_POST['cmbValue']) . "'";
    $sql .= " or vPriorityDesc='" . mysql_real_escape_string($_POST['txtExtraPrty']) . "'";
    if (mysql_num_rows(executeSelect($sql, $conn)) > 0) {
        return false;
    }
    return true;
}