o hw @s<ddlZddlmZedddZddZdd Zd d ZdS) N) Salesforcez;https://sitetracker-tillmanfiber2--sitetracker.vf.force.comzp00DDm000000L2eu!AQEAQObkypZDOwvBIMx9oTyIE6ZVvjYhrhyuuiMzmD6g3mO3ODzIRi0tlV54yX58r02WZ_wv1aj9y3XwU0hxVoYo7sIm3b4l) instance_url session_idcCsNtd|}|r%|d}t|d}d|}|dd}||fSdS)NFX4-F([A-Z]{2})-(\d{2})D-Hd)zD-HXXr)rematchuppergroupint) cabinet_namer letters suffix_numprefixbaser+/home/ubuntu/webapp/app/siteTrackerCalls.pyparse_distribution_prefix s   rcCs"td|}|rt|dSdS)Nz(\d+)$r)r searchrr )wor rrrextract_suffixs rc s8td|}|s dS|d}t|d}|}d||td|d}|ds0d S|dd d }td |d }|d}fdd|D} fdd| sYd} nt| fddd} | d} | d} | d} | rz| dn|d }| | dd| dd| dd| dd| dddfS)Nr)NzInvalid cabinet formatrrrzl SELECT Id, Ring_Number__c FROM sitetracker__Project__c WHERE LLD_WO_Number__c = 'z' LIMIT 1 records)NNrRing_Number__cz SELECT LLD_WO_Number__c, County__c, MO__c, Distribution_Area__c, Engineering_Vendor_Assigned_Name__c, Construction_Vendor_Assigned_Name__c FROM sitetracker__Project__c WHERE Ring_Number__c = 'z/' AND Job_Type__c = 'Distribution' csg|] }|dr|qS)LLD_WO_Number__c) startswith).0r full_prefixrr <sz,get_next_distribution_wo..cs(td|}|rt|dSdS)Nz(\d+)rr)r r rr )wo_namer r!rrr>sz0get_next_distribution_wo..extract_suffixcs |dS)Nrr)r )rrrEs z*get_next_distribution_wo..)keyr02drMO__czN/A County__cDistribution_Area__c#Engineering_Vendor_Assigned_Name__c$Construction_Vendor_Assigned_Name__c)MOCountyDistribution_AreaEngineering_VendorConstruction_Vendor) r r r r rsfquery query_allmaxget)rr rsuffixblockresult ring_number dist_result wo_records matching_wos next_suffixhighest last_suffixnext_wometadata_sourcer)rr"rget_next_distribution_wosB          rC)r simple_salesforcerr2rrrCrrrrs