PHP FilterDef Examples

Example #1

File: disputes-results.php Project: Rhenan/Email-Marketing

    $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("invoice", "S_invoice", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("reason_code", "S_reason_code", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("test_ipn", "S_test_ipn", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_disputesresults"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_disputesresults"]) && $_SESSION["WADbSearch1_disputesresults"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_disputesresults"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {

Example #2

File: index.php Project: esquarenews/MortgageBlog

}
if (isset($_GET["Search"]) || isset($_GET["Search_x"])) {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("cat_name", "cat_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("cat_desc", "cat_desc", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("cat_father_id", "cat_father_id", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("hide", "hide", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_category_results"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_category_results"]) && $_SESSION["WADbSearch1_category_results"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_category_results"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {

Example #3

File: recurring-payment-profiles-results.php Project: Rhenan/Email-Marketing

    $WADbSearch1->addComparisonFromEdit("amount_per_cycle", "S_amount_per_cycle", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("profile_status", "S_profile_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("amount", "S_amount", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("outstanding_balance", "S_outstanding_balance", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("recurring_payment_id", "S_recurring_payment_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("product_name", "S_product_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("test_ipn", "S_test_ipn", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_recurringpaymentprofilesresults"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_recurringpaymentprofilesresults"]) && $_SESSION["WADbSearch1_recurringpaymentprofilesresults"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_recurringpaymentprofilesresults"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {

Example #4

File: mass-payments-results.php Project: Rhenan/Email-Marketing

    $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("status", "S_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("unique_id", "S_unique_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("test_ipn", "S_test_ipn", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_masspaymentsresults"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_masspaymentsresults"]) && $_SESSION["WADbSearch1_masspaymentsresults"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_masspaymentsresults"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {

Example #5

File: articles_results.php Project: esquarenews/eliteRespiteCare

if (!session_id()) {
    session_start();
}
if (isset($_GET["Search"]) || isset($_GET["Search_x"])) {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("articlesType", "articlesType", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("artlicesLive", "artlicesLive", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_articles_results"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_articles_results"]) && $_SESSION["WADbSearch1_articles_results"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_articles_results"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {

Example #6

File: subscriptions-results.php Project: Rhenan/Email-Marketing

    $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("item_name", "S_item_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("item_number", "S_item_number", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("test_ipn", "S_test_ipn", "AND", "=", 1);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_subscriptionsresults"] = $WADbSearch1->whereClause;
    }
} else {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //get the filter definition from a session variable
    if (1 == 1) {
        if (isset($_SESSION["WADbSearch1_subscriptionsresults"]) && $_SESSION["WADbSearch1_subscriptionsresults"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_subscriptionsresults"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
    } else {
        $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
    }
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
if (!function_exists("GetSQLValueString")) {