Skip to content

Instantly share code, notes, and snippets.

Avatar

Remco Tolsma remcotolsma

View GitHub Profile
@remcotolsma
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
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
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
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 Jul 13, 2020
Custom plugin specific for Pronamic.nl/eu website to add Mollie metadata.
View pronamic-pay-custom-mollie-metadata.php
<?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 Jun 4, 2020
Filter `pronamic_pay_mollie_payment_meta_data`.
View functions.php
<?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">
<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 Feb 3, 2020
Export completed Pronamic Pay payments.
View pronamic-pay-export-payments.sql
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 Feb 7, 2020
Pronamic Pay Google Analytics ecommerce tracking item hit name Gravity Forms entry source URL (HelpScout ticket #19062)
View functions.php
<?php
/**
* Custom.
*/
\add_action(
'plugins_loaded',
function() {
/**
* Check for Gravity Forms API.
View geocode-providers.php
<?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 Nov 11, 2019
Query Gravity Forms entries of specific form and some extra meta values.
View lookup-gf-entries-meta.sql
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 Oct 9, 2019
Update Gravity Forms currency EUR.
View functions.php
<?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',
You can’t perform that action at this time.