Exemplo n.º 1
0
    if ($errors) {
        echo $errors;
        return false;
    }
    echo $zas_modul->return_warnings();
}
$branchJS = $zas_modul->getJSApi();
if ($branchJS == false) {
    $errors = $zas_modul->return_errors();
    if ($errors) {
        echo $errors;
        return false;
    }
    echo $zas_modul->return_warnings();
}
echo $zas_modul->checkVersion();
$list = "SELECT #__{vm}_orders.order_id,order_status, #__{vm}_orders.cdate,#__{vm}_orders.mdate,order_total,order_currency,#__{vm}_orders.user_id,";
$list .= "first_name, last_name,ship_method_id FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";
$count = "SELECT count(*) as num_rows FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";
$q = "address_type = 'BT' AND ";
if (!empty($keyword)) {
    $q .= "(#__{vm}_orders.order_id LIKE '%{$keyword}%' ";
    $q .= "OR #__{vm}_orders.order_status LIKE '%{$keyword}%' ";
    $q .= "OR first_name LIKE '%{$keyword}%' ";
    $q .= "OR last_name LIKE '%{$keyword}%' ";
    $q .= "OR CONCAT(`first_name`, ' ', `last_name`) LIKE '%{$keyword}%' ";
    $q .= ") AND ";
}
if (!empty($show)) {
    $q .= "order_status = '{$show}' AND ";
}