o I iJ@sddlZddlmZddlZddZddZddZdd d Zdd d ZddZ ddZ ddZ e dkrBdZ dZe e dgddSdS)N) defaultdictc Cs|dkrdS|d}|d\}}t|dkrL|ddd}|ddg}|dd}tdt|dD] }||||dq3d |ddd}n|}d |d|S) uD Format amount in Indian currency format ₹xx,xx,xx,xxx.zz ru₹0.00z.2f.N,u₹)splitlenrangeappendjoin) amount amount_str integer_part decimal_part reversed_intformatted_parts remainingi formatted_intr:/var/www/html/minaions-tender/ai-engine/seller_analysis.pyformat_indian_currencys  rc Cs>|sdStddt|}zt|WSttfyYdSw)z3 Parse price string and return float value z[^\d.])resubstrfloat ValueError TypeError) price_str cleaned_pricerrr parse_price&s r#cCszed|vrcd|dvrc|dd}d|vrc|d}t|tr+d|vr+|ddi}nt|tr7|di}ni}|rcd|vrc|d}t|trc|}t|D]}|rb|dsb|WSqPWdSt yoYdSw) z3 Extract location from bid's buyer details detailedInfosections bidDetailsparent buyerDetailsaddress*N) isinstancedictgetrrreversed startswithstriptitle Exception)bidr% bid_details buyer_detailsr)partspartrrrextract_location_from_bid5s,      r8anycCs|r|sdgfSt|tr|g}ndd|D}|s"dgfSd|}g}|D] }||vr8||q-|dkrKt|t|k}||fSt|dk}||fS)a Check if keywords match in bd_category_name and return which keywords matched Args: bd_category_list (list): List of category strings from bd_category_name keywords (str or list): Single keyword string or list of keywords search_mode (str): "any" (OR logic) or "all" (AND logic) Returns: tuple: (bool: match_found, list: matched_keywords) FcSs g|] }|r|qSr)r0lower).0kwrrr ks z4check_keyword_match_with_details.. allr)r+rr0r:r r r )bd_category_listkeywords search_mode keyword_list category_textmatched_keywordskeyword match_foundrrr check_keyword_match_with_detailsXs$     rHc&CsNt|ddd }t|}Wdn1swYtdd}d}d}g} |dD]} |d 7}g} |rt| d d g| d d g| d ididg| d ididg} t| ||\} } | st| | dq,|d 7}t| }d| vsd| dvrq,| dd}d|vsd|dvrq,|dd}d}d|dvrd|ddvr|dddr|ddd}|D]?}|dd }|sq||dd kr|||d<|r||d || D] }||d |q||dd 7<|dd  }|r||dd 7<|dkr||d d 7<|d!d"}t |}||d#|7<|r||d$si}d%|vr^|d%r^|d%r^|d%|d%<d&|vrw|d&rw|d&rw|d&|d&<|r|||d$<n|d'kr||d(d 7<n ||d)d 7<g}|d*d }|r|d+vr|||d,d }d-|vr|d-d.|vr|d.|d/d }|rd-|vr|d-d.|vr|d.d0|vr|d0|D] }||d1 |qqq,|D]-}t t ||d1||d1<t t ||d||d<t t ||d||d<qg}|D]E\}}|d|d|d|d)|d |d(t|d#|d#|d|d|d1rhd2|d1nd3d4 } |d$rw|d$| d$<|| q8|jd5dd6d7i}!|rt|tr|g|!d8<nt ||!d8<||!d9<||!d:<||!d;<nd}!t||d d<|d d=ttd>d?|D|!| d@gdA}"t|d D]>\}#}|#|d|d|d|d)|d |d(|dB|dC|dD|d1dE } d$|vr|d$r|d$| d$<|"d| qt|dFdd}tj|"|dGdHdIWdn 1s,wYtdJt|dK|r\d2|!d8}$tdL|$dM|dNtdO|dP|dQntdRtdS|tdT|"d dUtdVt|ddWd D]\}#}t|#dX|ddY|ddZtd[|dd\|d)td]|d d^|d(td_|dBtd`|dCrd2|dCndatdb|dDrd2|dDndad$|vr |d$r |d$}d%|vrtdc|d%d&|vr tdd|d&qdedf|D}%|%r!tdgt|%dhdStdidS)ja Analyze bid data to extract seller statistics and save to output JSON file. Args: input_file_path (str): Path to input JSON file output_file_path (str): Path to output JSON file search_keywords (str or list, optional): Keywords to filter bids by bd_category_name search_mode (str): "any" for OR logic, "all" for AND logic (default: "any") rzutf-8)encodingNc Ss"dddddddttitd S)Nrrr) seller_nametotal_bids_appliedtotal_bids_qualifiedtotal_bids_disqualifiedtotal_bids_won_l1 total_bids_l2total_amount_won_l1 locationsrEseller_detailsspecial_status)setrrrrsz!analyze_bidders..rbidsr1r descriptionmetadataapiDatabd_category_name bbt_title bidNumberr$r% evaluationsellerssummaryl1Winner_details sellerNamerKrRrErLrankrML1rO totalPrice0rQrSr)contactL2rPrN mseStatus)N/ArstatusMSEMII statusTypez Under PMArTz, None) rKrLrMrNrOrPtotal_amount_won_l1_formattedtotal_amount_won_l1_rawseller_locationskeyword_matchesrTcSs|dS)NrLr)xrrrrVFsT)keyreverserArBtotal_bids_in_sourcefiltered_bids_count scrapedAt totalBidscss|]}|dVqdS)rrNrr;sellerrrr [sz"analyze_bidders..)total_unique_sellers analysis_datesource_total_bidstotal_amount_won_all_l1_bidsfilter_appliedbids_not_matched)rZr`rqrsrt) serial_numberrKrLrMrNrOrPrQrsrtrTwrF)indent ensure_asciizAnalysis complete! Found z unique sellers.zFilter applied: Keywords 'z' with 'z' logicz Processed z out of z total bidsz-No keyword filter applied - analyzed all bidszResults saved to: z% Total amount won by all L1 bidders: rz$ Top 5 sellers by bid participation:z. z: z bidsz - Qualified: z, Disqualified: z - L1 wins: z, L2: z - Amount won: z - Locations: rkz - Keywords: z - Address: z - Contact: cSs@g|]}|d|d|dks|d|d|dkr|qS)rMrNrLrOrPrr|rrrr=s z#analyze_bidders..z Warning: Found z% sellers with data validation issues.u. ✓ All seller data passed validation checks.)openjsonloadrr-rHr r8r0addupperr#sortedlistitemsrr sortr+rr sum enumeratedumpprint)&input_file_pathoutput_file_pathsearch_keywordsrBfiledata seller_statstotal_bids_processedryrr3rEr@rG bid_locationr%r`l1_winner_detailsr}rKrFrd total_pricer detailsspecial_statuses mse_status main_status status_typerl sellers_liststats seller_entry filter_info output_datar keywords_strvalidation_issuesrrranalyze_bidderssj  T                            ]            "&&   rcCt|||dS)zSearch for a single keywordr9r) input_file output_filerFrrranalyze_single_keywordrcCr)z)Search for any of the keywords (OR logic)r9rrr keywords_listrrranalyze_any_keywordsrrcCr)z#Search for all keywords (AND logic)r?rrrrranalyze_all_keywordsrr__main__z%/content/processed_bids_data (1).jsonzseller_analysis_output.jsonzexxon_resellers.json) lubricantgreaseMobilzgear oilz hydraulic oilz engine oil)r9)Nr9)r collectionsrrrr#r8rHrrrr__name__rrrrrrs$ ! # +$