Ejemplo n.º 1
0
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_disputes;
//Searchpage: disputes-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("case_id", "S_case_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("case_type", "S_case_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("case_creation_date", "S_case_creation_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("receipt_id", "S_receipt_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0);
    $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);
Ejemplo n.º 2
0
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_order_items;
//Searchpage: orders-items-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("order_id", "S_order_id", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("refund_id", "S_refund_id", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("item_name", "S_item_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("item_number", "S_item_number", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("os0", "S_os0", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("on0", "S_on0", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("os1", "S_os1", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("on1", "S_on1", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("quantity", "S_quantity", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_handling", "S_mc_handling", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_shipping", "S_mc_shipping", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("creation_timestamp", "S_creation_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("raw_log_id", "S_raw_log_id", "AND", "=", 1);
    //save the query in a session variable
Ejemplo n.º 3
0
$row_father = mysql_fetch_assoc($father);
$totalRows_father = mysql_num_rows($father);
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAcategory;
//Searchpage: category_search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
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("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 {
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_recurring_payments;
//Searchpage: recurring-payments-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("protection_eligibility", "S_protection_eligibility", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("notify_version", "S_notify_version", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_status", "S_payer_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("currency_code", "S_currency_code", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("amount", "S_amount", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_type", "S_payment_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("receiver_id", "S_receiver_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0);
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_recurring_payment_profiles;
//Searchpage: recurring-payment-profiles-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("payment_cycle", "S_payment_cycle", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("next_payment_date", "S_next_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("residence_country", "S_residence_country", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("initial_payment_amount", "S_initial_payment_amount", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("rp_invoice_id", "S_rp_invoice_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("currency_code", "S_currency_code", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("time_created", "S_time_created", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("verify_sign", "S_verify_sign", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("period_type", "S_period_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_status", "S_payer_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0);
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_mass_payments;
//Searchpage: mass-payments-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("masspay_txn_id", "S_masspay_txn_id", "AND", "Includes", 0);
    $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 {
Ejemplo n.º 7
0
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_orders;
//Searchpage: orders-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("receiver_email", "S_receiver_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("pending_reason", "S_pending_reason", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("tax", "S_tax", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_currency", "S_mc_currency", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_type", "S_txn_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_street", "S_address_street", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_city", "S_address_city", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_state", "S_address_state", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_zip", "S_address_zip", "AND", "Includes", 0);
}
require_once "../../webassist/database_management/wada_search.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAarticles;
//Searchpage: articles_search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
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;
        }
Ejemplo n.º 9
0
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_raw_log;
//Searchpage: raw-log-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("created_timestamp", "S_created_timestamp", "AND", "=", 2);
    $WADbSearch1->addComparisonFromEdit("ipn_data_serialized", "S_ipn_data_serialized", "AND", "Includes", 0);
    //save the query in a session variable
    if (1 == 1) {
        $_SESSION["WADbSearch1_rawlogresults"] = $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_rawlogresults"]) && $_SESSION["WADbSearch1_rawlogresults"] != "") {
            $WADbSearch1->whereClause = $_SESSION["WADbSearch1_rawlogresults"];
        } else {
            $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
        }
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_subscription_payments;
//Searchpage: subscription-payments-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_email", "S_payer_email", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("memo", "S_memo", "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("os0", "S_os0", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("on0", "S_on0", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("os1", "S_os1", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("on1", "S_on1", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("quantity", "S_quantity", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_type", "S_payment_type", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("txn_id", "S_txn_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_fee", "S_mc_fee", "AND", "=", 1);
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_subscriptions;
//Searchpage: subscriptions-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("custom", "S_custom", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("subscr_id", "S_subscr_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("subscr_date", "S_subscr_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("subscr_effective", "S_subscr_effective", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("period1", "S_period1", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("period2", "S_period2", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("period3", "S_period3", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("amount1", "S_amount1", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("amount2", "S_amount2", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("amount3", "S_amount3", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_amount1", "S_mc_amount1", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_amount2", "S_mc_amount2", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_amount3", "S_mc_amount3", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("recurring", "S_recurring", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("reattempt", "S_reattempt", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("retry_at", "S_retry_at", "AND", "Includes", 0);
Ejemplo n.º 12
0
//WA Database Search Include
require_once "../WADbSearch/HelperPHP.php";
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApaypal_refunds;
//Searchpage: refunds-search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) {
    session_start();
}
if (isset($_GET["Search_x"]) && $_GET["Search_x"] != "") {
    $WADbSearch1 = new FilterDef();
    $WADbSearch1->initializeQueryBuilder("MYSQL", "1");
    //keyword array declarations
    //comparison list additions
    $WADbSearch1->addComparisonFromEdit("ipn_status", "S_ipn_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_gross", "S_mc_gross", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("invoice", "S_invoice", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("protection_eligibility", "S_protection_eligibility", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payer_id", "S_payer_id", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_street", "S_address_street", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_date", "S_payment_date", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("payment_status", "S_payment_status", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("charset", "S_charset", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("address_zip", "S_address_zip", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("mc_shipping", "S_mc_shipping", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("mc_handling", "S_mc_handling", "AND", "=", 1);
    $WADbSearch1->addComparisonFromEdit("first_name", "S_first_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("memo", "S_memo", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("last_name", "S_last_name", "AND", "Includes", 0);
    $WADbSearch1->addComparisonFromEdit("product_name", "S_product_name", "AND", "Includes", 0);