Totally Zenned
- Join Date:
- Jan 2007
- Location:
- Los Angeles, California, United States
- Posts:
- 10,011
- Plugin Contributions:
- 3
OLD Super Orders 2.0 (See v3.0 thread instead)
So just wanted to follow-up with my testing of these changes..
I applied these changes to not only the super_batch_status.php file, but the super_batch_forms.php as well.. It appears that this has fixed the SQL errors as well as the errors that would ocurr if you clicked the "Search" button on either the batch print or batch updates pages, when no order search criteria is entered.
I've been pounding away at it, and it works.. No more errors..
There is one small thing: Using the Order Totals "=(equals to)" option does not bring back any results no matter WHAT you type into the field.
Any thoughts?? Obviously, truly this is minor in the scheme of things..
Anyway, just wanted to say thanks.. This worked perfectly!:clap:
Now I am going to figure out once and for all why some of the Super Order form fields (particularly "textarea") act strange in IE.. another long standing pet peeve..:smile: Experimenting with this as we speak..
nagelkruid:
Should be long standing indeed, as the = in the array is set as == which would never work in that statement.
The <= is probably not working, either because of browser issue or some cleaner stripping html tags.
To make it work you could do this, first rewrite the array in <admin folder>/super_batch_status.php:
$ot_sign = array();
$ot_sign[] = array('id' => '1',
'text' => ' > ' . DROPDOWN_GREATER_THAN);
$ot_sign[] = array('id' => '2',
'text' => ' < ' . DROPDOWN_LESS_THAN);
$ot_sign[] = array('id' => '3',
'text' => ' = ' . DROPDOWN_EQUAL_TO);
> ```
if (isset($_GET['order_total']) && zen_not_null($_GET['order_total'])) {
if ($_GET['ot_sign'] == 3) { $sign_operator = '='; }
elseif ($_GET['ot_sign'] == 2) { $sign_operator = '<='; }
else { $sign_operator = '>='; }
$orders_query_raw .= " AND o.order_total " . $sign_operator . " '" . (int)$_GET['order_total'] . "'";
//$orders_query_raw .= " AND o.order_total " . $_GET['ot_sign'] . " '" . (int)$_GET['order_total'] . "'";
}
```finally, have a last look at these fields, as you will probably never use em while they're error free :cool:
>
> Jeroen
