devanmoylan’s gists

devanmoylan / tm_ft_allocated_po_line_query

Last active May 12, 2022 21:36

[WIP] Transmetro and fashionthing allocated purchase order line query

	-- TODOS:
	-- filter out nike
	-- filter out unpublished
	-- improve allocated po number splitting
	-- update item type data source to be transmetro

	-- NOTES:
	-- money: cost and price values are in lowest unit for the currency (e.g. cents for USD)
	-- update date: a revision to update date does not necessarily mean a relevant attribute changed; but instead something on the data source changed

devanmoylan / tm_ft_allocated_po_header_query

Last active May 12, 2022 21:31

[WIP] Transmetro and fashionthing allocated purchase order header query

	-- TODOS:
	-- oracle po number substring approach sufficient? improve by dropping on and after the first dash
	-- return null on Supplier Brand Name if multiple brands exist
	-- filter out non published po's
	-- talk with IT about how they plan us timestamps -- use that to drive our inclusion strat for timestamps

	-- NOTES:
	-- filters: inner and out filter exists for the header
	-- update dates: are commented out right now
	-- money: cost and price values are in lowest unit for the currency (e.g. cents for USD)

devanmoylan / tm_ft_blanket_po_header_query

Last active May 12, 2022 21:20

[WIP] Transmetro and fashionthing blanket purchase order header query

	-- TODO:
	-- return nil for multiple brand names
	-- add filters
	-- only published (look at `fashionthing.purchase_order_events.description`)

	-- notes:
	-- filters: inner and out filters exist for the header
	-- money: cost and price values are in lowest unit for the currency (e.g. cents for USD)
	-- exclusive brand: is_exclusive returns true if ANY merch buy is exclusive
	-- update date: an update to update date does not necessarily mean a relevant attribute changed

devanmoylan / tm_ft_blanket_po_line_query

Last active May 12, 2022 21:22

[WIP] Transmetro and fashionthing blanket purchase order line query

	-- TODOS:
	-- update item type data source to be transmetro
	-- filter out nike
	-- filter out not published po's

	-- NOTES:
	-- cost and price values are in lowest unit for the currency (e.g. cents for USD)
	-- size spectrum: if an issue of missing value, might have to fall back `style.merch_mode_object.size_spectrums.first`
	-- primary client focus: if an issue of missing value, might have to default to 'general'

devanmoylan / gist:301de9cc882f2c845378090db2bb9557

Last active March 23, 2021 20:19

	SELECT DISTINCT(pos.sku_id)
	FROM "hive"."po_service"."purchase_orders" po
	LEFT JOIN "hive"."po_service"."purchase_order_skus" pos ON po.id=pos.purchase_order_id
	WHERE po.purchase_order_number IN (
	'A130055',
	'A151077',
	'A163402',
	'A164092',
	'A165126',
	'A165942',

devanmoylan / attributes__dropship_only_womens

Last active February 5, 2021 15:00

devanmoylan / attributes__dropship_only

Last active February 5, 2021 16:11

devanmoylan / fabric-content.yml

Last active July 17, 2020 17:16 — forked from monicaseing/fabric-content.yml

devanmoylan / fabric_attribute__common_fabric

Last active July 28, 2020 13:25

devanmoylan / fabric_attribute__leather_appearance

Last active June 26, 2020 19:16

Devan Moylan devanmoylan