Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/resources/sql/ – Rev 37804

Last modification

Rev 37804 2026-09-29 00:19:53
Author: amit
Log message:
fix(fofo-store): store every GSTIN in upper case at the entity setter

FofoStore.setGstNumber now normalises through StringUtils.normalizeGstNumber,
so no write path can store a mixed-case GSTIN. Only the partner-update path
normalised before; the LOI and trial-form paths wrote the field directly,
which is how 06bmlpk3545g1z0 and 03AAccn9802g1zp reached the table. NIC
expects upper case, and case-sensitive comparisons (including the own-seller
GSTIN check behind a NIC refusal) silently failed to match.

uppercase_fofo_store_gstin_20260928.sql corrects the four rows already on
record; it is already applied on hadb1 (0 mixed-case GSTINs remain).

Path	Last modification			Log	RSS
20260916_sync_internal_store_addresses.sql	37652	21 d 8 h	amit	Log	RSS
add_credit_block_log.sql	37030	92 d 9 h	amit	Log	RSS
add_credit_note_id_to_returnorderinfo.sql	36817	119 d 9 h	amit	Log	RSS
add_idx_account_statement_perf.sql	36691	134 d 6 h	amit	Log	RSS
add_idx_order_grn_pending.sql	37588	26 d 6 h	amit	Log	RSS
add_idx_uwh_timestamp_reftype.sql	36330	169 d 8 h	amit	Log	RSS
add_inventory_cost_layer_20260917.sql	37694	20 d 5 h	amit	Log	RSS
add_irn_error_message.sql	36675	135 d 4 h	amit	Log	RSS
add_po_created_by_20260924.sql	37769	13 d 5 h	amit	Log	RSS
add_po_reopened_at_20260918.sql	37708	19 d 19 h	amit	Log	RSS
add_reference_to_offer_scheme.sql	36451	158 d 6 h	amit	Log	RSS
add_return_b2c_refund_20260921.sql	37790	9 d 9 h	amit	Log	RSS
add_uk_fofo_order_fofo_invoice.sql	36362	168 d 4 h	amit	Log	RSS
add_web_offer_circular_sync.sql	37525	34 d 6 h	amit	Log	RSS
add_web_offer_per_model.sql	37581	27 d 9 h	amit	Log	RSS
alter_monitor_type_normal_to_base.sql	36443	159 d 8 h	amit	Log	RSS
backdated_po_auto_approval_backfill_20260917.sql	37679	20 d 7 h	amit	Log	RSS
backfill_debit_note_status_old_flow_20260924.sql	37797	9 d 7 h	amit	Log	RSS
backfill_dn_return_credit_note_id.sql	36926	104 d 9 h	amit	Log	RSS
backfill_po_rejected_orders.sql	36790	124 d 11 h	amit	Log	RSS
backfill_receipt_origin_20260918.sql	37713	19 d 19 h	amit	Log	RSS
catalog_monitor_type.sql	36441	159 d 10 h	amit	Log	RSS
cleanup_abandoned_draft_orders.sql	36795	121 d 11 h	amit	Log	RSS
cleanup_phantom_payment_failed.sql	36795	121 d 11 h	amit	Log	RSS
contact_us.sql	36888	107 d 11 h	aman	Log	RSS
create_cron_batch_tables.sql	36305	171 d 16 h	amit	Log	RSS
create_tag_listing_price_log_20260915.sql	37634	22 d 6 h	amit	Log	RSS
delist_inactive_listings_rolling_24m.sql	37778	13 d 1 h	amit	Log	RSS
delist_samsung_pre2025_no_stock.sql	37562	27 d 23 h	amit	Log	RSS
drop_dead_ageing_columns_20260912.sql	37601	25 d 9 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_20260914.sql	37625	23 d 5 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_20260915.sql	37639	22 d 6 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_hotspot_20260916.sql	37667	21 d 4 h	amit	Log	RSS
drop_internal_vendor_pricing_20260912.sql	37608	25 d 6 h	amit	Log	RSS
drop_po_reopened_at_20260924.sql	37769	13 d 5 h	amit	Log	RSS
fix_dark_model_retire_20260924.sql	37778	13 d 1 h	amit	Log	RSS
fix_invoice_receiveDate_from_purchase.sql	36314	170 d 12 h	amit	Log	RSS
flagship_credit_schema.sql	36557	144 d 17 h	amit	Log	RSS
hot_deal_brand_migration.sql	37646	22 d 5 h	amit	Log	RSS
hot_deal_brand_remove_5_catalogs_20260918.sql	37724	19 d 5 h	amit	Log	RSS
hot_deal_brand_schema.sql	37640	22 d 6 h	amit	Log	RSS
mail_outbox.sql	35956	214 d 11 h	amit	Log	RSS
migration_bulk_order_approval_report_menu.sql	35966	214 d 9 h	amit	Log	RSS
migration_demo_partner_access.sql	37785	12 d 7 h	amit	Log	RSS
migration_dn_status_retailer_ack.sql	36446	159 d 0 h	amit	Log	RSS
migration_dummy_warehouses.sql	36309	170 d 23 h	amit	Log	RSS
migration_external_api_client.sql	37149	72 d 9 h	amit	Log	RSS
migration_external_api_v2.sql	37284	58 d 7 h	amit	Log	RSS
migration_gst_to_fofo_store.sql	35908	219 d 13 h	amit	Log	RSS
migration_hdfc_payment_credited_flag.sql	36943	103 d 7 h	amit	Log	RSS
migration_imei_net_margin_modal_api.sql	36407	163 d 4 h	amit	Log	RSS
migration_lead_live_location.sql	36711	133 d 5 h	ranu	Log	RSS
migration_lead_visit_approval.sql	36642	138 d 3 h	ranu	Log	RSS
migration_loan_imei_table.sql	36958	99 d 8 h	amit	Log	RSS
migration_mail_outbox_sendgrid_to_relay.sql	37483	37 d 6 h	amit	Log	RSS
migration_menu_icons.sql	36567	144 d 10 h	amit	Log	RSS
migration_order_wallet_adjustment.sql	36713	133 d 5 h	amit	Log	RSS
migration_outlet_name_to_fofo_store.sql	36439	159 d 11 h	amit	Log	RSS
migration_pjp_agenda_instances.sql	37163	69 d 12 h	amit	Log	RSS
migration_pjp_agenda_menu.sql	37186	69 d 6 h	amit	Log	RSS
migration_po_transaction_mapping.sql	36910	105 d 12 h	amit	Log	RSS
migration_requested_hid_allocation_approved_by.sql	36894	107 d 9 h	amit	Log	RSS
migration_running_balance_wallet_history.sql	36515	150 d 5 h	amit	Log	RSS
migration_scheme_item_windowing.sql	36406	163 d 6 h	amit	Log	RSS
migration_store_closure.sql	37764	13 d 6 h	amit	Log	RSS
migration_unsettled_purchase_return_menu.sql	36318	170 d 4 h	aman	Log	RSS
model_flagship_schema.sql	36565	144 d 10 h	amit	Log	RSS
model_hot_deal_activated_to_fresh.sql	37268	58 d 13 h	amit	Log	RSS
model_hot_deal_attributes.sql	37268	58 d 13 h	amit	Log	RSS
model_hot_deal_schema.sql	37211	64 d 11 h	amit	Log	RSS
partner_investment_snapshot.sql	37592	26 d 4 h	amit	Log	RSS
reconcile_inventory_snapshot.sql	36512	150 d 7 h	amit	Log	RSS
register_aged_apple_imeis_api.sql	37597	26 d 4 h	amit	Log	RSS
retag_manual_scheme_reversals_to_others.sql	37074	85 d 13 h	amit	Log	RSS
retire_counter_privatedealuser_20260916.sql	37688	20 d 6 h	amit	Log	RSS
return_reversal_20260921.sql	37776	13 d 3 h	amit	Log	RSS
revert_price_drop_vendor_catalog_pricing_20260915.sql	37634	22 d 6 h	amit	Log	RSS
rollback_delist_recent_movement_20260910.sql	37566	27 d 12 h	amit	Log	RSS
solr_update_failures.sql	35547	266 d 8 h	amit	Log	RSS
uppercase_fofo_store_gstin_20260928.sql	37804	8 d 23 h	amit	Log	RSS
void_net_settled_stranded_orders.sql	36796	121 d 10 h	amit	Log	RSS