SmartDukaan – //trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/

Rev 37683 – Move the knowlarity insights pull into dao, and delete the ...

amit — Thu, 17 Sep 2026 17:53:09 +0530

amit – 6 file(s) modified
Move the knowlarity insights pull into dao, and delete the dead earlier attempt

The pull belongs in dao because its SCHEDULE moves to profitmandi-cron while the
fofo portal still reads the same rows. Both modules depend on dao, so that is the
only place the two can share it.

KnowlarityInsightsSyncService fetches via KnowlarityApiClient (moved here from
fofo, unchanged) and upserts cs.agent_daily_insight. No DDL: every column it
writes already exists.

It writes what the old chrome scrape could not:
- the *_seconds columns. Verified on prod over 7 consecutive days, every row had
logged_in_seconds, break_seconds, available_seconds and talk_seconds = 0. The
API returns fractional seconds as numbers, so they are stored directly rather
than re-parsed out of a display string.
- calls_answered / missed_calls / total_calls, also 0 on every row, because the
scrape never captured them at all.

auth_id resolution keeps the email-PREFIX match from the fofo version: some
stored emails are truncated ('user@smartdukaan.co..'), so matching the whole
address silently misses those agents.

Redis keys are deliberately the same pair the portal reads, so its fast path
stays warm across the process boundary. ⚠ That makes AgentInsightRow's getter
names a contract with fofo's AgentInsightDTO -- rename one without the other and
the portal deserialises blanks.

Also deleted, all with zero external references:
- KnowlarityAgentInsightsService: an earlier, unfinished run at this same API.
Its ALT_INSIGHTS_APIS list of guessed endpoints is the giveaway that it never
worked; nothing ever called it. It owned three redis keys nobody read
(knowlarity:agent:insights, :summary, :lastUpdate) -- distinct from the live
knowlarity:insights:* pair, which stays.
- AgentInsightsDTO / AgentInsightsSummaryDTO: used only by that service.
- KnowlaritySocketTest: a scratch main(), never referenced.

x /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/dto/AgentInsightsDTO.java
x /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/dto/AgentInsightsSummaryDTO.java
x /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityAgentInsightsService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityApiClient.java (copied from /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/KnowlarityApiClient.java@37682)
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityInsightsSyncService.java
x /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlaritySocketTest.java

Rev 37227 – password update knowlarity

ranu — Tue, 04 Aug 2026 18:29:38 +0530

ranu – 3 file(s) modified
password update knowlarity

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlaritySocketTest.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/KnowlarityInsightsService.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/KnowlarityScraperService.java

Rev 36445 – knowlarity username password update

ranu — Fri, 01 May 2026 19:41:42 +0530

ranu – 4 file(s) modified
knowlarity username password update

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/knowlarity/KnowlarityCallMonitorScheduler.java
~ /trunk/profitmandi-cron/src/main/resources/META-INF/dev.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/prod.properties
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlaritySocketTest.java

Rev 36239 – changeList

ranu — Fri, 10 Apr 2026 15:31:23 +0530

ranu – 1 file(s) modified
changeList

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36238 – changeList

ranu — Fri, 10 Apr 2026 15:21:07 +0530

ranu – 1 file(s) modified
changeList

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36236 – changeList

ranu — Fri, 10 Apr 2026 15:00:17 +0530

ranu – 1 file(s) modified
changeList

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36180 – weekly rating system live on calling module

ranu — Thu, 02 Apr 2026 23:30:37 +0530

ranu – 3 file(s) modified
weekly rating system live on calling module

+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/dto
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/dto/AgentInsightsDTO.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/dto/AgentInsightsSummaryDTO.java

Rev 36179 – weekly rating system live on calling module

ranu — Thu, 02 Apr 2026 23:22:40 +0530

ranu – 6 file(s) modified
weekly rating system live on calling module

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/enumuration/ActivationType.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityAgentInsightsService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/invoicing/InvoiceService.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/KnowlarityInsightsService.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm_call_target.vm

Rev 36139 – code for socket snapshot

ranu — Wed, 01 Apr 2026 19:19:29 +0530

ranu – 4 file(s) modified
code for socket snapshot

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/knowlarity/KnowlarityCallMonitorScheduler.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityEventListener.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityLiveCallClient.java

Rev 36118 – code for socket snapshot

ranu — Tue, 31 Mar 2026 18:27:21 +0530

ranu – 4 file(s) modified
code for socket snapshot

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/knowlarity/KnowlarityCallMonitorScheduler.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/AgentLiveStatusRedisService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityLiveCallClient.java

Rev 36115 – rbm rating consolidate mail

ranu — Tue, 31 Mar 2026 18:04:30 +0530

ranu – 5 file(s) modified
rbm rating consolidate mail

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/knowlarity/KnowlarityCallMonitorScheduler.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/AgentLiveStatusRedisService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityLiveCallClient.java

Rev 36091 – persistance logout and other status ...agent live status (deduplication)

ranu — Fri, 27 Mar 2026 18:46:49 +0530

ranu – 1 file(s) modified
persistance logout and other status ...agent live status (deduplication)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36090 – correction on breaking and avaialble timing

ranu — Fri, 27 Mar 2026 17:12:34 +0530

ranu – 1 file(s) modified
correction on breaking and avaialble timing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36089 – correction on breaking and avaialble timing

ranu — Fri, 27 Mar 2026 16:29:10 +0530

ranu – 1 file(s) modified
correction on breaking and avaialble timing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36087 – correction on breaking and avaialble timing

ranu — Fri, 27 Mar 2026 15:56:26 +0530

ranu – 1 file(s) modified
correction on breaking and avaialble timing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36086 – code commit via websocket instead of selenium for agent status

ranu — Fri, 27 Mar 2026 15:30:05 +0530

ranu – 4 file(s) modified
code commit via websocket instead of selenium for agent status

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/RbmBreakLogRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm_call_target.vm

Rev 36084 – correction on breaking and avaialble timing

ranu — Fri, 27 Mar 2026 12:31:46 +0530

ranu – 1 file(s) modified
correction on breaking and avaialble timing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36075 – code commit via websocket instead of selenium for agent status

ranu — Thu, 26 Mar 2026 17:08:22 +0530

ranu – 4 file(s) modified
code commit via websocket instead of selenium for agent status

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/RbmBreakLogRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityBreakLogService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java

Rev 36072 – correction on breaking and avaialble timing

ranu — Thu, 26 Mar 2026 13:25:13 +0530

ranu – 2 file(s) modified
correction on breaking and avaialble timing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityBreakLogService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java

Rev 36058 – web socket done for agent status

ranu — Wed, 25 Mar 2026 17:17:34 +0530

ranu – 8 file(s) modified
web socket done for agent status

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/b2b/Listing.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/knowlarity/KnowlarityCallMonitorScheduler.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.java
~ /trunk/profitmandi-cron/src/main/resources/META-INF/dev.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/prod.properties
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityBreakLogService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlaritySocketTest.java

Rev 36057 – code commit via websocket instead of selenium for agent status

ranu — Wed, 25 Mar 2026 17:06:07 +0530

ranu – 11 file(s) modified
code commit via websocket instead of selenium for agent status

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/CacheConfig.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/auth/SipMaster.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/AgentLiveStatusRedisService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityAgentResolver.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityLiveCallClient.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/knowlarity/KnowlarityCallMonitorController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/AgentLiveStatusService.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/KnowlarityScraperService.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm_call_target.vm

Rev 36018 – Add Knowlarity live call monitoring - WebSocket client, auth, agent ...

amit — Wed, 18 Mar 2026 18:19:49 +0530

amit – 11 file(s) modified
Add Knowlarity live call monitoring - WebSocket client, auth, agent resolver, event processing. Maps CC-Agent-Number/CC-SR-Number to sip_master for agent identification. Added authId to SipMaster entity, selectBySipUrl and selectAll to SipRepository. Added Tyrus WebSocket client dependency.

~ /trunk/profitmandi-dao/build.gradle
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/auth/SipMaster.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/auth/SipRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/auth/SipRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityAgentResolver.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityAuthService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallEvent.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityCallMonitorService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityEventListener.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/knowlarity/KnowlarityLiveCallClient.java