WebSVN RSS feed – SmartDukaanThu, 08 Oct 2026 00:25:58 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_web_offer_circular_sync.sql&max=40& Thu, 03 Sep 2026 17:43:36 +0530amit<div><strong>amit – 11 file(s) modified</strong><br/>offer circular: division aliases, portal-editable scope, web offer sync (dao)<br /> <br /> - division_alias support: CircularIngestRepository.selectDivisionAliases so an<br /> alternate OEM label resolves onto an existing division instead of dropping the<br /> rows as UNKNOWN. Both pdf_label columns are ALIASED - Hibernate discovers<br /> native-query results by name and throws NonUniqueDiscoveredSqlAlias on a dup.<br /> <br /> - OfferScopeRepository{,Impl}: write side for scope config (add/edit a division,<br /> in_scope toggle, label aliases). Kept apart from OfferCurationRepository, whose<br /> contract is limited to product_alias - a bad alias mismaps one product, a bad<br /> scope change silently drops a whole brand.<br /> <br /> - OfferCircularRepositoryImpl: label-side division join now resolves through<br /> division_alias (dva), otherwise an UNPARSED row under an aliased label is hidden<br /> by the inScopeOnly filter - exactly the rows the review screen exists to show.<br /> Also isoDate(): period_month left as java.sql.Date serialised to epoch millis,<br /> which an &lt;input type=date> silently rejects, so the circular filter cleared<br /> itself and every circular showed every row.<br /> <br /> - WebOfferSyncRepository{,Impl} + migration: publish a parsed circular into<br /> dtr.web_offer / web_offer_product. Anchored on (document, page, row) stored as<br /> VALUES, never offers.offer.id, which is recreated on every re-ingest. source<br /> defaults to MANUAL so the 3850 hand-typed rows are untouched; web_offer_sync_shadow<br /> is what lets a human edit win over a later sync.</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/CircularIngestRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/CircularIngestRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/OfferCircularRepositoryImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/OfferScopeRepository.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/OfferScopeRepositoryImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/WebOfferSyncRepository.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/offers/WebOfferSyncRepositoryImpl.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/add_web_offer_circular_sync.sql<br />+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/dao/repository<br />+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/dao/repository/offers<br />+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/dao/repository/offers/OfferCircularDateSerialisationTest.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_web_offer_circular_sync.sql&rev=37525https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_web_offer_circular_sync.sql&rev=37525