Filter export based on order custom field dropdown

Hi,

Tried to figure it out, but do not find any relevant information connecting to filtering order list.

Do we have an option on to filter orders on orderlist page and on export page based on custom order fileds?
Maybe it can be just a hack, or some lines to be added to ordermarket/export_show.php and ordermarket/listing.php

Thanks again,
PePe

1.) Vendor dropdown: Vendors
2.) Field: order_location: Dropdown Locations
3.) Field: product_costtype: Dropdown type of costs

Jerome wrote: Hi,

Can you describe me the kind of filtering you want to do for the export ?

Thanks

Jerome wrote: Hi,

Does your custom fields are already dropdown custom fields ?
I am analyzing your requirements and, it should be possible thanks to overrides to have the wanted result but it could be easier to put the filters directly in the SQL query and not process the exported data manually in PHP.

But I will require more details about your custom fields in order to know if we can use them directly or not.

Regards,

Thanks for the analyzis. At least - hopefully - I give a useable point where the team can upgrade the system later.

You mentioned the customly added dropdown to export view. Could you give me a direction point/custom code snippet how to solve that?

Tried to do it, but with no luck:

Dropdowns shown correctly, it's OK. (ordermarket | export_show)
Also added your code snippet to component/com_hikamarket/ordermarket/view.html.php

Tried to add "JRequest::getValue('filter_koltseg_jelleg', '') " but thrown out error in Joomla 3, also tried it with JRequest::get('filter_koltseg_jelleg', '') but nothing happened (maybe I put it to wrong place in the plugin )

So I tried an other way as I realized I should have to filter more fields as well.

In ordermarket | export_show I changed your code to this (and repeated it for all the necessary fields, with different datas).

For example:

echo JHTML::_('select.genericlist', $values_koltseghely, 'data[export][filter_koltseghely]', '', 'value', 'text', '');

echo JHTML::_('select.genericlist', $values_koltsegjelleg, 'data[export][filter_koltseg_jellege]', '', 'value', 'text', '');

echo JHTML::_('select.genericlist', $values_tovabbterhelesikod, 'data[export][filter_tovabbterhelesikod]', '', 'value', 'text', '');

$koltseghely = $formData['export']['filter_koltseghely'];
$koltsegjelleg = $formData['export']['filter_koltseg_jellege'];
$tovabbterhelesikod = $formData['export']['filter_tovabbterhelesikod'];
		
if(!empty($koltseghely))
$filters[] = 'hkorder.order_vendor_id = ' . $db->Quote($koltseghely);
		
if(!empty($koltsegjelleg))
$filters[] = 'hkproduct.koltseg_jellege = ' . $db->Quote($koltsegjelleg);
		
if(!empty($tovabbterhelesikod))
$filters[] = 'hkorderproduct.tovabbterhelesikod = ' . $db->Quote($tovabbterhelesikod);

$query = 'FROM '.hikamarket::table($cfg['table']).' AS hkorder '. 'LEFT JOIN '.hikamarket::table('shop.user').' AS hkuser ON hkorder.order_user_id = hkuser.user_id '.
'LEFT JOIN '.hikamarket::table('joomla.users').' AS juser ON hkuser.user_cms_id = juser.id '.
'LEFT JOIN '.hikamarket::table('shop.order_product').' AS hkorderproduct ON hkorder.order_id = hkorderproduct.order_id '. 
'LEFT JOIN '.hikamarket::table('shop.product').' AS hkproduct ON hkorderproduct.order_product_code = hkproduct.product_code '.
$from.' '.$filters.' '.$order;
		
if(!empty($select) && substr($select, 0, 1) != ',')
$select = ','.$select;
$db->setQuery('SELECT hkorder.*, hkuser.*, juser.name, juser.username, hkorderproduct.*, hkproduct.* '.$select.$query);

Oh, maybe I found the problem.
The problem was the SQL syntax was OK, but as I exporting rows based on products by custom plugin, I used the extended new SQL query not in the right place.

Now using it before:

$rows = $db->loadObjectList('order_id');

Sorry, just catch a small problem:
There's a value option 0 in a dropdown:

<dt class="hikamarket_order_export_tovabbterhelesikod"><label><?php echo JText::_('Továbbterhelési kód:'); ?></label></dt>
<dd class="hikamarket_order_export_tovabbterhelesikod">
<?php 
$values_tovabbterhelesikod = array(
JHTML::_('select.option', '', JText::_('No filter')),
JHTML::_('select.option', '0', '0'),
JHTML::_('select.option', '1', '1'),
JHTML::_('select.option', '2', '2'),
JHTML::_('select.option', '3', '3'),
JHTML::_('select.option', '4', '4')
);
echo JHTML::_('select.genericlist', $values_tovabbterhelesikod, 'data[export][filter_tovabbterhelesikod]', '', 'value', 'text', ''); ?>
</dd>

pepecortez wrote: Sorry, just catch a small problem:
There's a value option 0 in a dropdown:

<dt class="hikamarket_order_export_tovabbterhelesikod"><label><?php echo JText::_('Továbbterhelési kód:'); ?></label></dt>
<dd class="hikamarket_order_export_tovabbterhelesikod">
<?php 
$values_tovabbterhelesikod = array(
JHTML::_('select.option', '', JText::_('No filter')),
JHTML::_('select.option', '0', '0'),
JHTML::_('select.option', '1', '1'),
JHTML::_('select.option', '2', '2'),
JHTML::_('select.option', '3', '3'),
JHTML::_('select.option', '4', '4')
);
echo JHTML::_('select.genericlist', $values_tovabbterhelesikod, 'data[export][filter_tovabbterhelesikod]', '', 'value', 'text', ''); ?>
</dd>

If 0 is choosen SQL is not filtering for 0, show all values from the column. Looks like it's using value 0 as no filter. Is there a trick to solve that?

if(isset($formData['export']['filter_tovabbterhelesikod'])){
$filters[] = 'hkorderproduct.tovabbterhelesikod = ' . $db->Quote($tovabbterhelesikod);
}

if($formData['export']['filter_tovabbterhelesikod'] != NULL )