Skip to content

Instantly share code, notes, and snippets.

View remcotolsma's full-sized avatar
🏢
Working @pronamic

Remco Tolsma remcotolsma

🏢
Working @pronamic
128 followers · 141 following
View GitHub Profile
@remcotolsma
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
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
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
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
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
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
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
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,
@remcotolsma
remcotolsma / functions.php
Created October 9, 2019 19:29
Update Gravity Forms currency EUR.
<?php
/**
* Update Gravity Forms currency EUR.
*
* @link https://www.pronamic.nl/2012/04/gravity-forms-euro-teken-voor-bedrag/
* @link https://docs.gravityforms.com/gform_currencies/#1-update-euro
*/
\add_filter(
'gform_currencies',
@remcotolsma
remcotolsma / test.php
Created August 29, 2019 14:20
Providers and slots GEO query WordPress.
<?php
$providers_query = new WP_Query(
array(
'post_type' => 'provider',
'tax_query' => array(
array(
'taxonomy' => 'country',
'field' => 'slug',
'terms' => 'nl',