richardcalahan

WITH 
custom_values AS (
  SELECT 
    location_id,
    COALESCE(
      JSONB_OBJECT_AGG(name, value) FILTER (WHERE name IS NOT NULL), 
      '{}'
    ) AS data
  FROM custom_values
  GROUP BY location_id

richardcalahan

#!/bin/bash

BUCKET="sgw-pd-t1"
PAGE_SIZE=10

# Search and replace this key
NEW_META_KEY="file-permissions"
NEW_META_VALUE="0777"

# can manually set in case of script failure, new token is output every `PAGE_SIZE` requests. 

richardcalahan

<td class="paddingcomp" style="border-collapse:collapse; mso-table-lspace:0pt; mso-table-rspace:0pt;border:0px;padding:7px 15px;font-size:12pt;font-family:Arial,Helvetica;line-height:19pt;border-top:0px none ;   border-bottom:0px none ;padding-top:4px;padding-bottom:21px;padding-right:120px;padding-left:120px;">
  <div componentbgcolor="#000000" componentpaddingbottom="21px" componentpaddingleft="120px" componentpaddingright="120px" componentpaddingtop="4px" style="background-color: rgb(0, 0, 0);">
    <p align="center" style="font-family:Arial,verdana;font-size:12px; color:#000000;padding:0px;margin: 0;line-height: 19pt; text-align: center;"><font color="#ffffff" face="Arial, Helvetica" style="font-size: 10pt;">&nbsp;You are receiving this email as you signed up for our newsletters.</font></p>
    <p align="center" style="font-family:Arial,verdana;font-size:12px; color:#000000;padding:0px;margin: 0;line-height: 19pt; text-align: center;"><font color="#ffffff"><font face="Arial, Helvetica" style="font-size: 1

richardcalahan

server {
  listen 80;
  server_name api.lakeandskye.test;
  return 301 https://api.lakeandskye.test$request_uri;
}

server {
  listen 80;
  server_name cms.lakeandskye.test;
  return 301 https://cms.lakeandskye.test$request_uri;

richardcalahan

server {
  listen 80;
  server_name api.commoncitizen.test;
  return 301 https://api.commoncitizen.test$request_uri;
}

server {
  listen 80;
  server_name cms.commoncitizen.test;
  return 301 https://cms.commoncitizen.test$request_uri;

richardcalahan

import Promise from 'bluebird'
import Cookies from 'js-cookie'

export const init = () => {
  return Promise.map(window.vinoshipper.accounts, account => {
    return $
      .get(`https://vinoshipper.com/json-api/v2/wine-list?id=${account.id}`)
      .then(data => {
        account.shipsTo = data.shipsTo
        account.wines = data.wines

richardcalahan

<script type="text/javascript">
    var productsPurchased = [];
    var orderTotal = 0;
    {% for item in checkout.order.line_items %}
      productsPurchased.push({
        product_id: '{{ item.variant_id }}',
        product_name: '{{ item.title }}',
        product_brand: '{{ item.vendor }}',
        product_size: '{{ item.grams }}',
        product_price: '{{ item.final_price }}',

richardcalahan

exports.userCreateProps = functions.auth.user().onCreate( (user) => {

  const props = {};

  props["email"] = user.email;
  if ( user.displayName ) {
    props["displayName"] = user.displayName;
  }
  if ( user.phoneNumber ) {
    props["phoneNumber"] = user.phoneNumber;

richardcalahan

{
    "development": {
        "shopify_api_key":"[your key]",
        "shopify_password":"[your password]",
        "shopify_url":"[your dev shop url]",
        "shopify_theme":"[the theme id to sync to]"
    }
}

richardcalahan

NOTES!

This is the single html page to be loaded by phonegap.

The only elements to be hard coded are the initial host locations for the
css/js assets. Currently set to my rails app on the network. 
(note, localhost won't work in development. Must be an explicit IP)

In a phonegap app, we have to explicitly declare a host for all ajax request. 
This is because the main html page is not being served from a web server.