🏢

Remco Tolsma remcotolsma

🏢

WordPress Developer at @pronamic Working on Pronamic Pay plugin to integrate payment providers like Adyen and Mollie with WooCommerce, Gravity Forms, etc.

132 followers · 172 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

remcotolsma / orbis-query-companies-number-hosting-subscriptions.sql

Last active November 27, 2020 09:07

Query companies and the number of hosting subscriptions and users.

	SELECT
	company.name,
	company_subscriptions.number_support_subbscriptions,
	company_users.number_company_users
	FROM
	orbis_companies AS company
	LEFT JOIN
	(
	SELECT
	subscription.company_id,

remcotolsma / orbis-query-subscriptions-over-50-quota.sql

Last active July 14, 2020 13:32

Query subscriptions over 50% time quota.

	SELECT
	company.id AS company_id,
	company.name AS company_name,
	subscription.id AS subscription_id,
	subscription.name AS subscription_name,
	product.id AS product_id,
	product.name AS product_name,
	product.time_per_year,
	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 November 27, 2020 08:48

Query companies and the number of WordPress support subscriptions and users.

	SELECT
	company.name,
	company_subscriptions.number_support_subbscriptions,
	company_users.number_company_users
	FROM
	orbis_companies AS company
	LEFT JOIN
	(
	SELECT
	subscription.company_id,

remcotolsma / pronamic-pay-custom-mollie-metadata.php

Created July 13, 2020 08:47

Custom plugin specific for Pronamic.nl/eu website to add Mollie metadata.

	<?php
	/**
	* Plugin Name: Pronamic Pay - Custom Mollie metadata
	* Plugin URI: https://gist.github.com/remcotolsma/277254ae239641c36b91ec8f8fe0da92
	* Description: Custom plugin specific for Pronamic.nl/eu website to add Mollie metadata.
	*
	* Version: 1.0.0
	* Requires at least: 4.7
	*
	* Author: Pronamic

remcotolsma / functions.php

Created June 4, 2020 15:06

Filter `pronamic_pay_mollie_payment_meta_data`.

	<?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();

remcotolsma / svg-test-ie11.html

Last active March 6, 2020 12:31

SVG test on IE11

	<!doctype html>

	<html lang="en">
	<head>
	<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 February 3, 2020 08:18

Export completed Pronamic Pay payments.

	SELECT
	post.ID,
	post.post_title,
	post.post_date,
	post.post_status,
	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 February 7, 2020 14:57

Pronamic Pay Google Analytics ecommerce tracking item hit name Gravity Forms entry source URL (HelpScout ticket #19062)

	<?php

	/**
	* Custom.
	*/
	\add_action(
	'plugins_loaded',
	function() {
	/**
	* Check for Gravity Forms API.

remcotolsma / geocode-providers.php

Last active January 9, 2020 15:29

Geocode providers.

	<?php

	define( 'WP_USE_THEMES', false );

	require './wp-blog-header.php';

	$query = new WP_Query(
	array(
	'post_type' => 'provider',
	'nopaging' => true,

remcotolsma / lookup-gf-entries-meta.sql

Created November 11, 2019 12:51

Query Gravity Forms entries of specific form and some extra meta values.

	SELECT
	entry.id 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,

Newer Older