meetchandan’s gists

meetchandan / payload.json

Created June 18, 2025 07:38

	{
	"exref": {
	"exref_type_code": "mp_instant_order",
	"mp_code": "nooninstant",
	"external_ref": "IAEF6H759ZNA5YRRXA"
	},
	"lines": [
	{
	"entity_from": "entity::legal_entity_v2::ae::LE1QX7CQGAE",
	"entity_to": "entity::customer_address::ae::50c3d72fa9091aa3733558ac64dcf868::2",

meetchandan / gift_card.json

Created June 17, 2025 10:55

	{
	"exref": {
	"exref_type_code": "mp_instant_order",
	"mp_code": "nooninstant",
	"external_ref": "IAEF6H759ZNA5YRRXA"
	},
	"lines": [
	{
	"entity_from": "entity::partner::ae::302207",
	"entity_to": "entity::customer_address::ae::50c3d72fa9091aa3733558ac64dcf868::2",

meetchandan / core_price.sql

Created June 12, 2025 12:24

	insert into minutes_price(country_code, price, psku_code, is_active, msrp)
	values
	('AE', 1750 , 'a71f4fc2e0120913ff612ce5fb7595ca', true, null),
	('AE', 1800 , 'a5685af91220017aed8642f89220502a', true, null),
	('AE', 1300 , 'a893e369f41b85596e19f59a3228d73a', true, null),
	('AE', 1600 , 'a58f7c9dcf65f97a8f229979645dd26a', true, null),
	('AE', 1000 , 'ad4719ea7585cf269beb35f08b83107a', true, null),
	('AE', 1000 , 'a830be40e4104b1966545ca7be80986a', true, null),
	('AE', 11000 , 'a704fc729f48bcd8e18ad8de6f9d290a', true, null),
	('AE', 7000 , 'a9392f6ffce3201bc7fb7cbef871c2ba', true, null),

meetchandan / noon_one.sql

Created June 9, 2025 18:55

	Select
	country_code,date(subscribed_timestamp) as acq_date,
	CASE
	WHEN lower(mp) in ('food','noonfood') then 'food'
	WHEN lower(mp) in ('nooninstant') then 'minutes'
	WHEN lower(mp) in ('ecom') then 'core'
	else lower(mp)
	end as mp,
	count(distinct customer_code) as cx_count
	from

meetchandan / a.xml

Created May 22, 2025 12:06

	<?xml version="1.0"?>
	<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
	<channel>
	<title>noon</title>
	<link>http://www.noon.com</link>
	<description></description>
	{% for row in rows %}
	<item>
	{% for key, val in row.items() -%}

meetchandan / content.sql

Created April 9, 2025 06:27

	SELECT
	sku,
	pen.brand AS brand_en,
	COALESCE(po.en_title, pen.base_title) AS base_title_en,
	COALESCE(JSON_EXTRACT_SCALAR(pen.attributes, '$.product_subtitle'), po.en_size_info,
	CASE
	WHEN JSON_EXTRACT_SCALAR(pen.attributes, '$.vsku_size_info') IS NOT NULL THEN JSON_EXTRACT_SCALAR(pen.attributes, '$.vsku_size_info')
	WHEN JSON_EXTRACT_SCALAR(pen.attributes, '$.size_info') IS NOT NULL THEN JSON_EXTRACT_SCALAR(pen.attributes, '$.size_info')
	WHEN JSON_EXTRACT_SCALAR(pen.attributes, '$.size') IS NOT NULL AND JSON_EXTRACT_SCALAR(pen.attributes, '$.size_unit') IS NOT NULL AND JSON_EXTRACT_SCALAR(pen.attributes, '$.quantity') IS NOT NULL THEN CONCAT(JSON_EXTRACT_SCALAR(pen.attributes, '$.size'), JSON_EXTRACT_SCALAR(pen.attributes, '$.size_unit'), ' x ', JSON_EXTRACT_SCALAR(pen.attributes, '$.quantity'))
	WHEN JSON_EXTRACT_SCALAR(pen.attributes, '$.size') IS NOT NULL AND JSON_EXTRACT_SCALAR(pen.attributes, '$.size_unit') IS NOT NULL THEN CONCAT(JSON_EXTRACT_SCALAR(pen.attributes, '$.siz

meetchandan / statements.sql

Created March 12, 2025 08:58

	select
	mu.id_partner,
	mu.statement_date,
	mu.statement_nr,
	mu.currency_code,
	ft.name_en as fee_name,
	mu.unique_line_ref1 as item_nr,
	mu.delta_amount as amount
	from noonbiprosel.mpst_union.mpst_union mu
	left join noondwh.mpst.fee_type_v2 ft on ft.zsku= mu.zsku

meetchandan / cancel.txt

Created February 18, 2025 12:13

["IAEF2I031TD873DBKA","IAEF2I14761WAJQDMA","ISAF2I244ROAHXO5SA","ISAF2I965FRLQCO4EA","IAEF2I7051MVASP1UA","IAEF2I7423CDZ3AUXA","IAEF2I151Q205TO47A","ISAF2I028LVR4NI8AA","IAEF2I147HYCB1Y6RA","ISAF2I0872L79OCUEA","IAEF2I905ML6SBKMFA","IAEF2I049XY6LHFMKA","IAEF2I674X85DZDB0A","ISAF2I030RWGGG8F1A","IAEF2I245RXDGFTFFA","IAEF2I2260JHW1FVQA","IAEF2I150IX63P5XLA","ISAF2I028XGB3JYBKA","IAEF2I864Q4IFL9JBA","ISAF2I2488GZ6UTZDA","IAEF2I122LK4OQ79YA","IAEF2I195Q3CRT3R9A","IAEF2I16551X5VTQ5A","ISAF2I654PMC2DGILA","IAEF2I1966P95AWZPA","ISAF2I027L1W50ZNHA","ISAF2I245A2G5YYGKA","IAEF2I122EX20YW1OA","ISAF2I248B3BI0I4ZA","ISAF2I2177DZH47J7A","IAEF2I129YRI5JZ8EA","IAEF2I2475RM1AJ4YA","IAEF2I1873NWHR41LA","ISAF2I104SKI9X0S0A","IAEF2I705A4YILCT8A","ISAF2I900ZHHS9ZEJA","IAEF2I739O5GST336A","IAEF2I740WR9EDJRVA","IAEF2I241N7BXYBGLA","IAEF2I863OH7U3R94A","IAEF2I147HGHGECSEA","IAEF2I032NTO9X0C5A","IAEF2I24394BP5EZ3A","IAEF2I145DPF1046UA","IAEF2I050REKEF4VJA","ISAF2I633X3SAGEE2A","IAEF2I286H3BCK3JXA","IAEF2I033J9N458KOA","IAEF2I863EAK8R

meetchandan / payload.json

Created February 13, 2025 09:04

	{
	"exref": {
	"exref_type_code": "mp_instant_order",
	"mp_code": "nooninstant",
	"external_ref": "IAEF2C248QIDWF9E9A"
	},
	"lines": [
	{
	"entity_from": "entity::partner::ae::9411",
	"entity_to": "entity::customer_address::ae::683eaaa9ea66648d0da2cfc8e07e5f45::2",

meetchandan / ok.sql

Created February 6, 2025 20:13

	WITH vsku_category AS (
	SELECT DISTINCT vsku, category, 'AE' as country
	FROM noondwh.instant_instant_order.virtual_sku_item vsi
	JOIN noonbinimuae.ref.category_AE cae USING(sku)
	UNION ALL
	SELECT DISTINCT vsku, category as category_sa, 'SA' as country
	FROM noondwh.instant_instant_order.virtual_sku_item vsi
	JOIN noonbinimuae.ref.category_SA cae USING(sku)
	),
	vsku_conv AS(

Chandan Bhattad meetchandan