mkllnk

proxy_cache_path /data/nginx/cache keys_zone=STATIC:500m;

server {
   listen 443 ssl http2;
   listen [::]:443 ssl http2;
   server_name discover.openfoodnetwork.org.au api.regenerative.org.au;
   root /home/openfoodnetwork/apps/discover/current/public;
    ssl_certificate /etc/letsencrypt/live/api.regenerative.org.au/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/api.regenerative.org.au/privkey.pem; # managed by Certbot
   

mkllnk

# An idea for a convention. Not sure it will be useful yet.
module I18nLib
  def lazy_translate(translation_key, options = {})
    scope = self.class.to_s.underscore.tr("/", ".")
    options.merge!(scope: scope)
    I18n.t(translation_key, **options)
  end
end

mkllnk

mkllnk

sql='
SELECT
    SUBSTRING(CONCAT(completed_at) from 1 for 7) AS month,
    COUNT(DISTINCT distributor_id) AS shops,
    COUNT(DISTINCT email) AS customers,
    COUNT(o.id) AS orders,
    SUM(o.total) AS VALUE
  FROM spree_orders o
  WHERE o.completed_at >= DATE_TRUNC($$year$$, now() - interval $$2 months$$)
    AND o.state = $$complete$$ GROUP BY month ORDER BY month;

mkllnk

#!/bin/sh

git fetch upstream
latest="$(git tag --sort="-v:refname" | head -1)"

echo "Changes since last release $latest:"

pr_numbers() {
	git log "$latest.." --merges --oneline |\
        grep -oP 'Merge pull request #\K[0-9]+(?= from)'

mkllnk

enterprise = Enterprise.find_by_permalink("bawbawfoodhub")
scoper = OpenFoodNetwork::ScopeVariantToHub.new(enterprise)

#producer,distributor,name,display_name,variant_unit_name,sku,units,unit_type,price,on_hand,on_demand
data = enterprise.inventory_items.visible.map do |item|
  variant = item.variant
  scoper.scope(variant) if variant
  product = variant&.product
  {
    producer: product&.supplier&.name,

mkllnk

producers = Enterprise.is_primary_producer.joins(:address).where(spree_addresses: {state_id: 1061493592}).map { |e| {id: e.id, name: e.name, contact: e.contact_name, phone: e.phone, email: e.email_address, properties: e.producer_properties.map(&:value).join("|")} }
CSV.open("producers.csv", "wb") { |csv| csv << producers.first.keys; producers.each { |p| csv << p.values } }

mkllnk

#!/usr/bin/env ruby

# Create CSV files for each producer in recently closed order cycles.
#
# It's similar data to the email sent to producers but as a CSV file.
#
# Use like this:
#
#   bundle exec rails runner script/order_cycle_producer_csv.rb

mkllnk

./monthly-sales.sh `date --date "-1 month" +%Y-%m-01` `date +%Y-%m-01` > monthly-sales-`date --date "-1 month" +%Y-%m`.csv

mkllnk

#!/bin/sh

set -ex

test -w git-ftp
test -w tests/git-ftp-test.sh

test "$(git status -uno --porcelain | wc -l)" -eq 0

current="$(grep "\<VERSION='.*'" git-ftp | cut -d "'" -f2)"