dingdang

Yes I just found out myself about the column name “id” (in my big test table the column name was different). Also noted the SlickGrid implementation – so you already have everything in the box and actually the pagination is not needed at all in that case.

Thanks! Everything works excellent.

A recommendation: you may consider to make it usable for those that don’t like to read the documentation: after the installation you can add a link under the plugin called “HOWTO” or something like that with just a sentence on the next page: “If it seems that the plugin is not working this is because you haven’t spent a minute to look at the docs, so click here and read it” hehe

P.P.S. Actually just to note for anyone interested:
my previous thoughts were theoretical and I supposed that the scrolling would be slow based on some other table plugins experience (which were really slow with 10K lines).
To my surprise this one handles 10K lines super fast including the search.
So I would give it 10 starts if it was possible. ??

IMPORTANT: The only problem is that possibly I found a bug – with the large table the row “NEW” is missing and at the console there is a message (which seems is related):

Couldnt find a column: id defaulting to noedit

Could you look into this?

P.S. an excellent implementation for clustering a big table is done here: https://clusterize.js.org/

There is an example of a table with 400,000 lines nicely handled by the browser

• This reply was modified 6 years, 4 months ago by dingdang.

Yes but as I can guess if the pagination is done by a limited query the search would be limited to only that page but not the whole table contents?

My idea however is the following:
– have the full table loaded (which is OK for all browsers to handle 10-20K lines BUT in memory)
– display just part of them, and pagination would work just to show next part and hide the current part of data displayed
– so search would work as it is now, using the full amount of data

I guess this can be done by just adding a little javascript in the table view page.. but is this done by someone already?

So to resolve this – can you tell me how your search works? where it checks for matches? Will it work if some lines of the table are hidden (display: none or height:0)?
If the answer is yes then a pretty simple universal javascript can be embedded that would hide everything but N lines of the table and when you scroll it would dynamically show more (before of after the current set depending on the scroll direction) and hide the same amount of lines that are off screen. That way dynamically only slice of the data would be visible.

We have managed to hide it as an option when the currency is not supported trough hooks at woocommerce and wpml/woo/multilingual plugins.
It will be a good option however, to have automatically and transparently not to hide it but to convert unsupported currencies to some predefined default one and only after that to send the request to braintree.

It seems it doesn’t consider the currency. To add to the currency problems:
– when a fixed fee is set up, the amount is added as number w/o taking it’s currency
Seems the plugin must be extended to:
a) set up currency as well (in addition to the fixed amount)
b) recalculate the amount based on the current currency on checkout

QUESTION: is there any hook/filter for the fixed amount on checkout so we could extend it easily (if we suppose the amount at the settings page is for some default currency)

P.S. Just to note that the above problem happens while the multicurrency is handled by WPML + woocommerce multilingual

N.B. I just found the appropriate hooks and functions and here is an example code to get this (my problem) fixed (in case ‘EUR’ is the default currency):

add_filter(‘wc_aelia_cs_convert’, ‘sc_fix_surcharge’, 10, 3);
function sc_fix_surcharge ($amount, $base_currency, $current_currency) {
global $woocommerce_wpml;
if ($current_currency != ‘EUR’) {
$exchange_rate = $woocommerce_wpml->multi_currency->exchange_rate_services->get_currency_rate($current_currency);
if ($exchange_rate) {
$amount *= $exchange_rate;
}
}
return $amount;
}

• This reply was modified 6 years, 6 months ago by dingdang.

Thanks. The plugin however need some way to handle the situations where the currency is not supported (like paypal plugin does) as by default it sends the request to the default one with just the number value of the other currency.
Is there any hook that could be used to recalculate the amount*currency to the default currency in such cases?
To give an example – if the amount is 100GBP and let say GBP is not supported by braintree but the default there is EUR, the payment will go trough but for 100EUR (not 100GBP). What we need is transparently recalculate 100GBP to EUR and send the correct amount in EUR in the braintree request.

Disable 3D security – the latest option in settings

Not sure if this will help you, but the same error disappeared when I switched off the “3d security” option at the bottom of the settings page of the plugin (this happens if the 3D security option is not enabled by Braintree for the account).

The URLs are absolutely identical.

Regarding the 1st issue – we managed the problem by using slb_media_item_properties filter hook:

add_filter( ‘slb_media_item_properties’, ‘blabla’ );
function blabla ( $props ) {
… pll_current_language() … is polylang’s current language
… $props->{‘caption’} … is the image caption
… based on the language do something with the caption …
… we are setting ours to “TEXT_LANG1||TEXT_LANG2” so we don’t have to duplicate the media …
}

You can close the ticket, but pay attention to the bug when there is .htaccess auth enabled.

• This reply was modified 7 years ago by dingdang.

Regarding the issue 2 above – the mystery is solved and it is not related to the other plugin but for some reason when a .htaccess or on a server level http-based password protection is activated, the plugin stops working. I’m curious to hear from the author why that happens, didn’t spend more time to debug myself.

2. An update with a bug (lightbox doesn’t work t all). To reproduce:
– install fresh WP (4.9.1), default 2017 theme
– install Simple Lightbox plugin
– install Polylang plugin
– create a page in 2 languages
– add a gallery to the page, links to media
And now.. lightbox doesn’t work anymore.
The interesting part is that if Polylang is totally removed, as well the uploaded images, reinstall the Simple Lightbox plugin (with just a single plugin – the Lightbox) it still doesn’t work (no JS errors), like it is “poisoned” by the other plugin ??

No, but what I’ve discovered is:

– if I do WordPress reinstall (trough the dashboard/updates) then the language appears

– if I don’t do anything for 24 hours, language files appear in some magical way. I say magical, because it is not in the listed WP’s cron jobs (I’ve tried to manually run all of them to see which of them eventually download the language).

So generally this is WordPress problem/bug, who knows. You can try yourself the described scenario to see it live (1. WordPress + theme installed 2. change the language to some different than the default English).

So with simple words:
a) if the language is changed BEFORE the theme is installed, after the theme installation, the language is OK (downloaded immediately)
b) if the language is changed AFTER the theme is installed, after the installation there is no language files. They appear later somehow, or after WordPress core reinstall.

OK, may be I haven’t described the exact case:
– install wordpress
– install the theme
– change the language to something different than English, which is more than 95% translated for generatepress

The result: the theme is not translated. No po/mo in languages/themes/ directory