jgarth

https://git.io/fpZ5b

jgarth

WITH billed_by_courier AS (
  SELECT 
    vendor_ref
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE
  	accounting_vendor_invoices.type IN ('Accounting::VendorInvoices::UPS', 'Accounting::VendorInvoices::DPD')
  GROUP BY 

jgarth

WITH billed_by_courier AS (
  SELECT 
    vendor_ref
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE
  	accounting_vendor_invoices.type IN ('Accounting::VendorInvoices::UPS', 'Accounting::VendorInvoices::DPD')
  GROUP BY 

jgarth

WITH billed_by_courier AS (
  SELECT 
    vendor_ref
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE
  	accounting_vendor_invoices.type IN ('Accounting::VendorInvoices::UPS', 'Accounting::VendorInvoices::DPD')
  GROUP BY 

jgarth

WITH billed_by_courier AS (
  SELECT 
    vendor_ref
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE
  	accounting_vendor_invoices.type IN ('Accounting::VendorInvoices::UPS', 'Accounting::VendorInvoices::DPD')
  GROUP BY 

jgarth

WITH billed_by_ups AS (
  SELECT 
    vendor_ref, SUM(amount) AS sum_amount, vendor_invoice_id
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE 
  	accounting_vendor_invoices.type = 'Accounting::VendorInvoices::UPS'
  GROUP BY 

jgarth

WITH billed_by_ups AS (
  SELECT 
    vendor_ref, SUM(amount) AS sum_amount, vendor_invoice_id
  FROM 
    accounting_vendor_billables
  INNER JOIN
  	accounting_vendor_invoices ON accounting_vendor_invoices.id = accounting_vendor_billables.vendor_invoice_id
  WHERE 
  	accounting_vendor_invoices.type = 'Accounting::VendorInvoices::UPS'
  	AND accounting_vendor_billables.type = 'delivery'

jgarth

# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
#   name = value
#
# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
# "#" anywhere on a line.  The complete list of parameter names and allowed

jgarth

require 'rails_helper'

describe 'AASM hooks' do
  class Foo
    include AASM
    include Concerns::TriggersHooksAfterAASMStateChanges

    aasm do
      state :pending, initial: true # waiting for manual review
      state :reviewed               # either manual or auto; waiting for arrive, could be in transit

jgarth

pod 'RestKit'
pod 'RestKit/Testing'

# Fix RestKit/Testing Pod after installation
post_install do |installer|
	print "Fixing RestKit/Testing Pod\n"
	system "sed -ie '/RKManagedObjectStore\+RKSearchAdditions/d' ./Pods/RestKit/Code/Testing/RKTestFactory.m"
end