Skip to content

Instantly share code, notes, and snippets.


Remco Tolsma remcotolsma

View GitHub Profile
remcotolsma / orbis-query-subscriptions-over-50-quota.sql
Last active Jul 14, 2020
Query subscriptions over 50% time quota.
View orbis-query-subscriptions-over-50-quota.sql
SELECT AS company_id, AS company_name, AS subscription_id, AS subscription_name, AS product_id, AS product_name,
SUM( timesheet.number_seconds ) AS registered_time,
100 / product.time_per_year * SUM( timesheet.number_seconds ) AS time_percentage,
remcotolsma / orbis-query-companies-number-support-subscriptions.sql
Last active Jul 20, 2020
Query companies and the number of WordPress support subscriptions and users.
View orbis-query-companies-number-support-subscriptions.sql
orbis_companies AS company
remcotolsma / pronamic-pay-custom-mollie-metadata.php
Created Jul 13, 2020
Custom plugin specific for website to add Mollie metadata.
View pronamic-pay-custom-mollie-metadata.php
* Plugin Name: Pronamic Pay - Custom Mollie metadata
* Plugin URI:
* Description: Custom plugin specific for website to add Mollie metadata.
* Version: 1.0.0
* Requires at least: 4.7
* Author: Pronamic
remcotolsma / functions.php
Created Jun 4, 2020
Filter `pronamic_pay_mollie_payment_meta_data`.
View functions.php
\add_filter( 'pronamic_pay_mollie_payment_meta_data', function( $meta_data, $payment ) {
$data = array();
$customer = $payment->get_customer();
if ( null !== $customer ) {
$vat_number = $customer->get_vat_number();
View svg-test-ie11.html
<!doctype html>
<html lang="en">
<meta charset="utf-8">
<title>SVG test on IE11</title>
<meta name="description" content="SVG test on IE11.">
<meta name="author" content="Pronamic">
remcotolsma / pronamic-pay-export-payments.sql
Last active Feb 3, 2020
Export completed Pronamic Pay payments.
View pronamic-pay-export-payments.sql
MAX( IF( meta.meta_key = "_pronamic_payment_description", meta.meta_value, NULL ) ) AS payment_description,
MAX( IF( meta.meta_key = "_pronamic_payment_amount", meta.meta_value, NULL ) ) AS payment_amount,
MAX( IF( meta.meta_key = '_pronamic_payment_currency', meta.meta_value, NULL ) ) AS payment_currency,
MAX( IF( meta.meta_key = '_pronamic_payment_config_id', meta.meta_value, NULL ) ) AS payment_config_id,
MAX( IF( meta.meta_key = '_pronamic_payment_status', meta.meta_value, NULL ) ) AS payment_status,
remcotolsma / functions.php
Last active Feb 7, 2020
Pronamic Pay Google Analytics ecommerce tracking item hit name Gravity Forms entry source URL (HelpScout ticket #19062)
View functions.php
* Custom.
function() {
* Check for Gravity Forms API.
View geocode-providers.php
define( 'WP_USE_THEMES', false );
require './wp-blog-header.php';
$query = new WP_Query(
'post_type' => 'provider',
'nopaging' => true,
remcotolsma / lookup-gf-entries-meta.sql
Created Nov 11, 2019
Query Gravity Forms entries of specific form and some extra meta values.
View lookup-gf-entries-meta.sql
SELECT AS entry_id,
entry.date_created AS entry_created_on,
entry.form_id AS form_id,
form.title AS form_title,
user.display_name AS user_display_name,
emtry_meta_km.meta_value AS number_kilometers,
emtry_meta_office_id.meta_value AS office_id,
emtry_meta_date.meta_value AS period,
office.code AS office_code,
remcotolsma / functions.php
Created Oct 9, 2019
Update Gravity Forms currency EUR.
View functions.php
* Update Gravity Forms currency EUR.
* @link
* @link
You can’t perform that action at this time.