"i 7ddlZddlZddlZejejj ej jdej je ddl m Z ddl m Z e ddZejd0dedefd Zejd1d edefd Zejd2d ededefd Zejd3dedededefdZejd0dedefdZej d4dededededededefdZejd5dededefdZejdedefdZejd6dedefdZejdedededefdZejdefdZejdedefdZejd2ded edefd!Zejd0dedefd"Z ejd7d#edefd$Z!ejd8d#ededefd%Z"ejd9d#ed ededefd&Z#ejd8d#ededefd'Z$ejd8d#ededefd(Z%ejd9d#edededefd)Z&ejOd*defd+Z(ejSdefd,Z*ejSdedefd-Z+ejSdedefd.Z,e-d/k(rej]yy):N)FastMCPgetzIDEAL OMS AnalyticszEReal-time analytics and operational tools for the IDEAL textbook OMS.)name instructionsaccount_year_idreturnctdd|iS)z High-level KPIs for the current (or specified) season. Returns: total orders, order value, dispatched count, pending dispatch, collections received, overdue amount, open credit note requests, stock alert count. zseason-summaryrrrs 9D:\Projects\php\service-ideal0324-oms\pyapi\mcp_server.pyget_season_summaryr s "3_!E FFdays_remainingctdd|iS)z Products that will run out of stock within `days_remaining` days at the current order rate. Returns product name, current stock, avg daily orders, days remaining. z stock-alertsrr)rs r get_stock_alertsrs ~ 0.A BBrzone_idc td||dS)z Order quantity vs. target by district with attainment percentage. Optionally filter by zone_id or account_year_id. zdistrict-performancerrrrs r get_district_performancer(s %7'_ ``rlimit from_dateto_datec"td|||dS)zr Top products ranked by total quantity ordered. Dates are ISO format YYYY-MM-DD. Default limit is 10. z top-productsrrrrrs r get_top_productsr1s ~YSZ[ \\rctdd|iS)zg Products where total orders exceed available stock. Critical for purchase order planning. zshortfall-productsrrr s r get_shortfall_productsr:s #&7%I JJr client_id district_idstatusc (td||||||dS)z Search orders with flexible filters. Status values: placed, approved, dispatched, invoiced, cancelled. Dates are ISO format YYYY-MM-DD. ordersrrr rrrrr#s r search_ordersr$Cs* x "   rmin_days_overduec td||dS)z Clients with overdue payments sorted by amount descending. `min_days_overdue` filters to only collections overdue by at least that many days. zoverdue-collectionsr%rrr's r get_overdue_collectionsr(]s $;KV[&\ ]]rctd|S)u ML-generated payment delay probability (0.0–1.0) for a specific client, plus a risk_level label: LOW, MEDIUM, or HIGH. zcollection-risk/rrs r score_collection_riskr+fs !)- ..rctdd|iS)z Credit note requests flagged as anomalous. Returns anomaly score, risk level, and the trigger reason for each record. z cn-anomaliesrr)rs r get_cn_anomaliesr-os ~/ 00r product_idnext_season_startc"td|||dS)u Prophet model demand forecast for a product × district combination. `next_season_start` must be an ISO date string e.g. "2026-04-01". Returns predicted_qty with lower and upper confidence bounds. zdemand-forecastr.rr/rr1s r forecast_demandr2xs"  )*0# rctdS)zw Count and list of items awaiting admin action: credit note requests, purchase orders, and orders on hold. zpending-approvalsrrr get_pending_approvalsr5s " ##rc td|dS)z Full analytical profile for a client: lifetime orders, lifetime value, current outstanding balance, YTD credit note count, AI segment, collection risk level. zclients/z/profilerr*s r get_client_profiler7s )H- ..r sales_user_idc td||dS)zo Season attainment percentage per sales user. Shows orders placed, target, attainment %, and rank. zsales-performancerr8rr:s r get_sales_performancer;s "*(% rctdd|iS)z Approved orders ready for dispatch, optionally filtered by district. Grouped by geographic cluster with suggested batching. zdispatch-queuerrrs r get_dispatch_queuer>s -!= >>rqueryctdd|iS)a- Resolve a human-readable year reference to an account year record with its id. Accepted formats: - Short range: '25-26', '2025-26' - Full range: '2025-2026' - Single year: '2025' - Relative: 'current', 'active', 'this year', 'last year', 'past year', 'previous year', 'last 2 years', 'last 3 years', 'past 2 years' Returns id, title, from_period, to_period, status, status_label. Call BEFORE any tool that accepts account_year_id when the user gives a year by name. zlookup/account-yearqr)r?s r lookup_account_yearrBs $sEl 33rc td||dS)z Search products by name or code. Returns id, name, code, product_head, stock. Call BEFORE forecast_demand or get_shortfall_products when you only have a product name. zlookup/productsrArrr?rs r lookup_productrFs  "> ??rc"td|||dS)z Search districts by name or code. Returns id, district_name, zone_id, zone_name. Call BEFORE forecast_demand, get_district_performance, get_dispatch_queue, or search_orders when you only have a district name. zlookup/districts)rArrr)r?rrs r lookup_districtrHs !7U#S TTrc td||dS)z Search zones by name or code. Returns id, zone_code, zone_name. Call BEFORE get_district_performance when filtering by zone name. z lookup/zonesrDrrEs r lookup_zonerJs ~UU; < ₹1L exposure. r4r4rr daily_ops_briefingrR%s rc  d|d|d|d|d S)z&Deep-dive review of a specific client.z! You are reviewing client ID z3 for a sales manager. Call get_client_profile(zA) to retrieve their profile. Then call score_collection_risk(z:) for payment risk. Then call search_orders(client_id=a4, limit=10) for recent orders. Provide: 1. A 2-sentence summary of who this client is and their value to IDEAL. 2. Their payment behaviour and current risk level. 3. Any red flags (high CN rate, overdue balance, dropping order frequency). 4. A recommended action for the sales team. r4r*s r client_reviewrT:s9!!* ,&K(%%.K0''0k2  rcd|d|d|dS)z9Demand forecast and stock planning report for a district.z= Generate a season stock planning report for district ID z. Steps: 1. Call get_stock_alerts() and filter for this district. 2. Call get_shortfall_products() to identify gaps. 3. Call get_district_performance() with district_id=zm for target context. 4. For the top 3 shortfall products, call forecast_demand(product_id=X, district_id=z, next_season_start="2026-04-01") to get next season estimates. Output a markdown table: Product | Current Stock | Projected Need | Gap | Suggested PO Qty Then write a 2-sentence purchasing recommendation. r4r=s r season_forecast_reportrVLs7==HMJ9 :E FYYdXef  r__main__)N))NN) NN)NNNNN)rX)r[)current))Nr])/sysosurllib3disable_warnings exceptionsInsecureRequestWarningpathinsertdirname__file__mcp.server.fastmcprlaravel_clientrmcptoolintdictr rrstrrrr$r(r+r-r2r5r7r;r>rBrFrHrJrLrNresourcerPpromptrRrTrV__name__runr4rr rss ++BBC277??8,-& XGGtG GCSC$C Caca3aRVa a]C]]c]UY] ]KCK4K K         2^c^s^D^ ^/S/T/ /1C11 1  # # RV   $t$ $/#/$/ /3cUY ?C?4? ? 4s 44 4  4"@#@c@4@ @U3UUCUU U=s=3== =CSCCdC C[[3[c[4[ [%&11'1fC(SS"$ zGGIr