Datanory Production » Datanory - GOLDCREST

select * from di_mobile_txn_eod where member_id= 'c534a1625a6b4966959975a68ea91513' order by eod_date desc
select * from txn_mobile_eod where member_id= 'c534a1625a6b4966959975a68ea91513' order by created_date desc
select * from txn_mobile_eod_at where member_id= 'c534a1625a6b4966959975a68ea91513' order by created_date desc
select * from member where member_cd= 'wwq'

select * from product_item where item_name like '% boboi%'

select * from warehouse where warehouse_code= 'wwq'
-- 9bfd5ff8-e9a6-4e4d-b4ea-5868795b98e0
select * from warehouse_inventory_header where warehouse_id='9bfd5ff8-e9a6-4e4d-b4ea-5868795b98e0' order by created_date desc

select * from warehouse_inventory_detail where warehouse_inventory_hdr_id= 'WWQ-GOLDCREST-20240419' order by created_date desc

SELECT *
FROM warehouse_inventory_detail
WHERE warehouse_inventory_hdr_id = 'WWQ-GOLDCREST-20240419'
AND opening_gs <> 0.00
ORDER BY created_date DESC;

• from

txn_mobile_van_goods_request_header vgr  
inner join txn_mobile_van_goods_request_detail vgd on vgr.van_goods_request_hdr_id = vgd.van_goods_request_hdr_id
inner join product_item p on vgd.item_id = p.item_id where 
vgr.warehouse_id='9bfd5ff8-e9a6-4e4d-b4ea-5868795b98e0' --and vgr.salesman_id= '9bfd5ff8-e9a6-4e4d-b4ea-5868795b98e0' and vgd.item_id= 'b6e16a92-c1f9-47a1-9fb4-e39ceccb437c'
order by vgr.created_date desc
select * from warehouse_
select * from warehouse_stock_transaction_detail where   item_id= 'b6e16a92-c1f9-47a1-9fb4-e39ceccb437c' and updated_by= '9bfd5ff8-e9a6-4e4d-b4ea-5868795b98e0'

250ml boboi boy blackcurrent

19/04/2024
WWQ 27/7 which means 27 cotton and 7 pieces

20-21 was not working

22/04/27/1 which means 27 cotton and 1 pieces suppose to be same as 19(27/7) why 27/1
WHY???

have to do simulation on this