3 \0@sddlZddlZddlZddlZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZddlm Z ddl!m"Z"m#Z#m$Z$ddl%m&Z&ddl'm(Z(e#dddg\Z)Z*e"ddZ+e#dddg\Z,Z-Gddde j.Z/Gddde j.Z0Gddde/e j.Z1Gd d!d!e/e j.Z2Gd"d#d#e j.Z3Gd$d%d%e j.Z4Gd&d'd'e j.Z5dS)(N)Decimal) ROUND_DOWN)settings) exceptions)models)Q)date)reverse)cached_property)get_current_timezonenow) gettext_lazy)AUTH_USER_MODEL) deprecated) get_class get_classes get_model)fields)currencyzoffer.managersActiveOfferManagerBrowsableRangeManagerz offer.results ZERO_DISCOUNTz offer.utils load_proxy unit_pricec@sBeZdZGdddZddZddZeddZed d Zd S) BaseOfferMixinc@seZdZdZdS)zBaseOfferMixin.MetaTN)__name__ __module__ __qualname__abstractrr;/var/www/html/oscar2019/oscar/apps/offer/abstract_models.pyMetasr!cCs|j}|j|jkr|St|j}x$t|jD]}|jdr0||=q0W|jrpt |j}|j|krf|S|f|S|j |kr||j f|St d|jj j |j fdS)z( Return the proxy model _zUnrecognised %s type (%s)N) proxy_map __class__valuesdict__dict__listkeys startswith proxy_classrtype RuntimeErrorrlower)selfZklassmap field_dictfieldklassrrr proxy"s       zBaseOfferMixin.proxycCs|jS)N)name)r/rrr __str__:szBaseOfferMixin.__str__cCs(|j}|jr"|j|jkr"td|jS)z A plaintext description of the benefit/condition. Every proxy class has to implement it. This is used in the dropdowns within the offer dashboard. z,Name property is not defined on proxy class.)r3r+r$AssertionErrorr4)r/Zproxy_instancerrr r4=szBaseOfferMixin.namecCs|jS)zi A description of the benefit/condition. Defaults to the name. May contain HTML. )r4)r/rrr descriptionJszBaseOfferMixin.descriptionN) rrrr!r3r5propertyr4r7rrrr rs  rcs0eZdZdZejedddeddZej eddddd Z ej ed ded d Z dx\Z ZZZe edfeedfeedfeedffZejedee ddZejededddZdy\ZZZejeddedZejd ejd!ed"d#Zejd$ejd!ed%d#Zejed&d'ed(d)Zejed*dded+d,Z ejed-dded.d,Z!ej"ed/ed0ddd1Z#ej"ed2ed3ddd1Z$ej"ed4dded5d,Z%ej&ed6d7d8dded9d:Z'ej&ed;d7d8e(d<d=Z)ej"ed>d'd?Z*ej"ed@d'd?Z+ej,edAddBZ-ejedCddDZ.ej/Z0e1Z2dEZ3GdFdGdGZ4fdHdIZ5dJdKZ6dLdMZ7dNdOZ8e9dPdQZ:e9dRdSZ;dTdUZde>_=dzdXdYZ?dZd[Z@d\d]ZAd^d_ZBd`daZCdbdcZDdddeZEdfdgZFd{dhdiZGdjdkZHdldmZIdndoZJdeJ_=dpdqZKdrdsZLe9dtduZMdvdwZNZOS)|AbstractConditionalOfferz5 A conditional offer (eg buy 1, get 10% off) NameTz.This is displayed within the customer's basket) max_lengthunique help_textSlugr4)r<r= populate_from Descriptionz,This is displayed on the offer browsing page)blankr>SiteVoucherUserSessionz#Site offer - available to all userszJVoucher offer - only available after entering the appropriate voucher codez/User offer - available to certain types of userzWSession offer - temporary offer, available for a user for the duration of their sessionType)choicesdefaultr<zExclusive offerz5Exclusive offers cannot be combined on the same items)r>rIOpen SuspendedConsumedStatus@)r<rIzoffer.Conditionoffers Condition) on_delete related_name verbose_namez offer.BenefitBenefitZPriorityrz-The highest priority offers are applied first)rIr>z Start datezWOffers are active from the start date. Leave this empty if the offer has no start date.)rBnullr>zEnd datezWOffers are active until the end date. Leave this empty if the offer has no expiry date.zMax global applicationszCThe number of times this offer can be used before it is unavailable)r>rBrUzMax user applicationsz4The number of times a single user can use this offerzMax basket applicationszEThe number of times this offer can be applied to a basket (and order)z Max discount zgWhen an offer has given more discount to orders than this threshold, then the offer becomes unavailable)decimal_places max_digitsrUrBr>zTotal Discountz0.00)rXrYrIzNumber of applications)rIzNumber of OrderszURL redirect (optional))rBz Date Created) auto_now_addNc@s,eZdZdZdZddgZedZedZdS)zAbstractConditionalOffer.MetaTofferz -prioritypkzConditional offerzConditional offersN) rrrr app_labelorderingr"rSverbose_name_pluralrrrr r!s r!cs2|js$|jdkr|j|_n|j|_tj||S)Nr) is_suspendedget_max_applicationsCONSUMEDstatusOPENsupersave)r/argskwargs)r$rr rfs   zAbstractConditionalOffer.savecCstdd|jidS)Nz offer:detailslug)rh)r ri)r/rrr get_absolute_urlsz)AbstractConditionalOffer.get_absolute_urlcCs|jS)N)r4)r/rrr r5sz AbstractConditionalOffer.__str__cCs*|jr&|jr&|j|jkr&tjtddS)Nz(End date should be later than start date)start_datetime end_datetimerValidationErrorr")r/rrr cleans  zAbstractConditionalOffer.cleancCs |j|jkS)N)rcrd)r/rrr is_opensz AbstractConditionalOffer.is_opencCs |j|jkS)N)rc SUSPENDED)r/rrr r`sz%AbstractConditionalOffer.is_suspendedcCs|j|_|jdS)N)rprcrf)r/rrr suspendsz AbstractConditionalOffer.suspendcCs|j|_|jdS)N)rdrcrf)r/rrr unsuspendsz"AbstractConditionalOffer.unsuspendcCsb|jr dS|dkrt}g}|jr2|j|j|k|jrH|j||jkt|rTdS|j|dkS)zA Test whether this offer is available to be used FNr)r`r rkappendrlanyra)r/userZ test_dateZ predicatesrrr is_availablesz%AbstractConditionalOffer.is_availablecCs|jjj||S)N) conditionr3 is_satisfied)r/basketrrr is_condition_satisfiedsz/AbstractConditionalOffer.is_condition_satisfiedcCs|jjj||S)N)rwr3is_partially_satisfied)r/ryrrr is_condition_partially_satisfiedsz9AbstractConditionalOffer.is_condition_partially_satisfiedcCs|jjj||S)N)rwr3get_upsell_message)r/ryrrr r}sz+AbstractConditionalOffer.get_upsell_messagecCs(|j|stS|jjj||jj|S)zS Applies the benefit to the given basket and returns the discount. )rzrbenefitr3applyrw)r/ryrrr apply_benefit"s  z&AbstractConditionalOffer.apply_benefitcCs|jjj|||S)z{ Applies any deferred benefits. These are things like adding loyalty points to someone's account. )r~r3apply_deferred)r/ryorder applicationrrr apply_deferred_benefit+sz/AbstractConditionalOffer.apply_deferred_benefitcCs ||_dS)N)_voucher)r/voucherrrr set_voucher2sz$AbstractConditionalOffer.set_vouchercCs|jS)N)r)r/rrr get_voucher5sz$AbstractConditionalOffer.get_vouchercCsz|jr|j|jkrdSdg}|jrB|rB|jtd|j|j||jrT|j|j|jrr|jtd|j|jt |S)zl Return the number of times this offer can be applied to a basket for a given user. ri') max_discounttotal_discountmax_user_applicationsrsmaxget_num_user_applicationsmax_basket_applicationsmax_global_applicationsnum_applicationsmin)r/ruZlimitsrrr ra8s   z-AbstractConditionalOffer.get_max_applicationscCsBtdd}|jj|j|djtjdd}|ddk r>|dSdS)Nr OrderDiscount)offer_idZ order__user frequency)totalrr)robjectsfilterid aggregaterSum)r/rur aggregatesrrr rMs   z2AbstractConditionalOffer.get_num_user_applicationscCs|jjj|S)N)r~r3shipping_discount)r/chargerrr rTsz*AbstractConditionalOffer.shipping_discountcCs>|j|d7_|j|d7_|jd7_|jdS)Nfreqdiscount)rr num_ordersrf)r/rrrr record_usageWsz%AbstractConditionalOffer.record_usagecCs |j}dd|D}dj|S)zF Return a description of when this offer is available cSsg|] }|dqS)r7r).0rrrr cszEAbstractConditionalOffer.availability_description..z
)availability_restrictionsjoin)r/ restrictions descriptionsrrr availability_description^sz1AbstractConditionalOffer.availability_descriptioncCsg}|jr|jtddd|jrX|j|j}td|j|d}|j||dkd|jr|jdkrrtd}ntd d |ji}|j|d d|jr|jdkrtd }ntd d |ji}|j|d ddd}|js|jrt }|jo|jr8td||j||jd}|j|ko0|jkn}nR|jrbtdd||ji}||jk}n(|jrtdd||ji}||jk}|j||d|j rtddt |j i}|j||j |j kd|S)NzOffer is suspendedF)r7rxz3Limited to %(total)d uses (%(remainder)d remaining))r remainderrrzLimited to 1 use per userz"Limited to %(total)d uses per userrTzLimited to 1 use per basketz$Limited to %(total)d uses per basketcSsD|jr|jt}n|}|jdkr8|jdkr8t|tjSt|tjS)Nr) tzinfo astimezoner hourminute date_filterr DATE_FORMATDATETIME_FORMAT)dt localtimerrr hide_time_if_zeros  zMAbstractConditionalOffer.availability_restrictions..hide_time_if_zeroz'Available between %(start)s and %(end)s)startendzAvailable from %(start)srzAvailable until %(end)srzLimited to a cost of %(max)sr) r`rsr"rrrrrkrlr rrr)r/r remainingdescrtodayrxrrr rfsj                z2AbstractConditionalOffer.availability_restrictionscCs |jjdk S)N)rwrange)r/rrr has_productssz%AbstractConditionalOffer.has_productscCs<tdd}|js|jjS|jjj}|jddj|j dS)z= Return a queryset of products in this offer catalogueProductT)is_discountable) structure) rrrnonerwr all_productsrexcludeCHILD)r/rquerysetrrr productss     z!AbstractConditionalOffer.products)rCrDrErF)rJrKrL)NN)N)Prrr__doc__r CharFieldr"r4r AutoSlugFieldri TextFieldr7SITEZVOUCHERUSERZSESSION TYPE_CHOICES offer_type BooleanField exclusiverdrprbrc ForeignKeyCASCADErwr~ IntegerFieldpriority DateTimeFieldrkrlPositiveIntegerFieldrrr DecimalFieldrDrrrExtendedURLField redirect_url date_createdManagerrractiverr!rfrjr5rnr8ror`rq alters_datarrrvrzr|r}rrrrrarrrrrrr __classcell__rr)r$r r9Ss                            I r9c @sveZdZejdddejeddZdC\ZZ Z Z dD\Z Z Zeed fe ed fe edfe edfe edfeedfe edffZejeddeddZejeddddddZejedddeddZejedddd ZGd!d"d"Zed#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Z d/d0Z!d1d2Z"d3d4Z#d5d6Z$d7d8Z%d9d:Z&d;d<Z'd=d>Z(dEd?d@Z)dAdBZ*dS)FAbstractBenefitz offer.RangeTRange)rBrUrQrS PercentageAbsoluteMultibuy Fixed priceShipping percentageShipping absoluteShipping fixed pricez3Discount is a percentage off of the product's valuez5Discount is a fixed amount off of the product's valuez1Discount is to give the cheapest product for freez:Get the products that meet the condition for a fixed pricez/Discount is a fixed amount of the shipping costzGet shipping for a fixed pricez1Discount is a percentage off of the shipping costrGr;)r<rHrBValuerVrW)rXrYrUrBzMax Affected Itemsz]Set this to prevent the discount consuming all items within the range that are in the basket.)rBrUr>z Custom classN)r<rIc@s$eZdZdZdZedZedZdS)zAbstractBenefit.MetaTr[rTZBenefitsN)rrrrr]r"rSr_rrrr r!sr!cCsX|jtdd|jtdd|jtdd|jtdd|jtdd|jtdd|jtddiS) Nzoffer.benefitsZPercentageDiscountBenefitZAbsoluteDiscountBenefitZMultibuyDiscountBenefitZFixedPriceBenefitZShippingAbsoluteDiscountBenefitZShippingFixedPriceBenefitZ!ShippingPercentageDiscountBenefit) PERCENTAGErFIXEDMULTIBUY FIXED_PRICESHIPPING_ABSOLUTESHIPPING_FIXED_PRICESHIPPING_PERCENTAGE)r/rrr r#szAbstractBenefit.proxy_mapcCstS)N)r)r/ryrwr[rrr rszAbstractBenefit.applycCsdS)Nr)r/ryrrrrr r szAbstractBenefit.apply_deferredcCs:|js dSd|jjjdd}t||r6t||dS)Nzclean_%s r")r,r.replacehasattrgetattr)r/ method_namerrr rn s  zAbstractBenefit.cleancCsRg}|js|jtd|jr,|jtd|jr@|jtd|rNtj|dS)Nz)Multibuy benefits require a product rangez'Multibuy benefits don't require a valuez@Multibuy benefits don't require a 'max affected items' attribute)rrsr"valuemax_affected_itemsrrm)r/errorsrrr clean_multibuyszAbstractBenefit.clean_multibuycCsXg}|js|jtd|js.|jtdn|jdkrF|jtd|rTtj|dS)Nz+Percentage benefits require a product rangez,Percentage discount benefits require a valuedz.Percentage discount cannot be greater than 100)rrsr"rrrm)r/rrrr clean_percentage"s z AbstractBenefit.clean_percentagecCsRg}|js|jtd|jr,|jtd|jr@|jtd|rNtj|dS)NzA discount value is requiredzFNo range should be selected as this benefit does not apply to productszAShipping discounts don't require a 'max affected items' attribute)rrsr"rrrrm)r/rrrr clean_shipping_absolute0sz'AbstractBenefit.clean_shipping_absolutecCslg}|js|jtdn|jdkr2|jtd|jrF|jtd|jrZ|jtd|rhtj|dS)Nz,Percentage discount benefits require a valuerz.Percentage discount cannot be greater than 100zFNo range should be selected as this benefit does not apply to productszAShipping discounts don't require a 'max affected items' attribute)rrsr"rrrrm)r/rrrr clean_shipping_percentage>s z)AbstractBenefit.clean_shipping_percentagecCs>g}|jr|jtd|jr,|jtd|r:tj|dS)NzFNo range should be selected as this benefit does not apply to productszAShipping discounts don't require a 'max affected items' attribute)rrsr"rrrm)r/rrrr clean_shipping_fixed_priceOsz*AbstractBenefit.clean_shipping_fixed_pricecCs|jrtjtddS)NzHNo range should be selected as the condition range will be used instead.)rrrmr")r/rrr clean_fixed_price[sz!AbstractBenefit.clean_fixed_pricecCs>g}|js|jtd|js,|jtd|r:tj|dS)Nz/Fixed discount benefits require a product rangez'Fixed discount benefits require a value)rrsr"rrrm)r/rrrr clean_absoluteaszAbstractBenefit.clean_absolutecCs$ttdrtj|S|jtdtS)z3 Apply rounding to discount amount OSCAR_OFFER_ROUNDING_FUNCTIONz.01)rrrquantizerr)r/amountrrr roundks  zAbstractBenefit.roundcCs|jr |jSdS)z Return the maximum number of items that can have a discount applied during the application of this benefit i')r)r/rrr _effective_max_affected_itemsssz-AbstractBenefit._effective_max_affected_itemscCs|jo |jjS)zV Determines whether the benefit can be applied to a given basket line ) stockrecordproductr)r/linerrr can_apply_benefitzsz!AbstractBenefit.can_apply_benefitcCs|dkr|j}g}x^|jD]R}|j}|j| s|j| r@qt||}|sPq|j|dkr`q|j||fqWt|t j ddS)z Return the basket lines that are available to be discounted :basket: The basket :range: The range of products to use for filtering. The fixed-price benefit ignores its range and uses the condition range Nr)key) r all_linesrcontains_productr rquantity_without_offer_discountrssortedoperator itemgetter)r/r[ryr line_tuplesr rpricerrr get_applicable_liness z$AbstractBenefit.get_applicable_linescCstdS)Nz0.00)r)r/rrrr rsz!AbstractBenefit.shipping_discount)rrrr)rrr)N)+rrrrrrr"rrrrrrrrrrr,rPositiveDecimalFieldrrr NullCharFieldr+r!r8r#rrrnrrrrrrrrrr rrrrrr rsV             rc@seZdZdZd&\ZZZeedfeedfeedffZe j dd d e j ed d Z e j ed d ed dZejedddd d dZejeddddZGdddZeddZddZddZddZd d!Zd"d#Zd'd$d%ZdS)(AbstractConditionz A condition for an offer to be applied. You can either specify a custom proxy class, or need to specify a type, range and value. CountrCoveragez@Depends on number of items in basket that are in condition rangez?Depends on value of items in basket that are in condition rangezHNeeds to contain a set number of DISTINCT items from the condition rangez offer.RangeTr)rBrUrQrSrGr;)r<rHrBrVrW)rXrYrUrBz Custom classrN)r<rIc@s$eZdZdZdZedZedZdS)zAbstractCondition.MetaTr[rPZ ConditionsN)rrrrr]r"rSr_rrrr r!sr!cCs(|jtdd|jtdd|jtddiS)Nzoffer.conditionsZCountConditionZValueConditionZCoverageCondition)COUNTrVALUECOVERAGE)r/rrr r#s zAbstractCondition.proxy_mapcCsdS)Nr)r/r[ryZaffected_linesrrr consume_itemsszAbstractCondition.consume_itemscCsdS)z Determines whether a given basket meets this condition. This is stubbed in this top-class object. The subclassing proxies are responsible for implementing it correctly. Fr)r/r[ryrrr rxszAbstractCondition.is_satisfiedcCsdS)z Determine if the basket partially meets the condition. This is useful for up-selling messages to entice customers to buy something more in order to qualify for an offer. Fr)r/r[ryrrr r{sz(AbstractCondition.is_partially_satisfiedcCsdS)Nr)r/r[ryrrr r}sz$AbstractCondition.get_upsell_messagecCs$|js dS|j}|jj|o"|jS)zX Determines whether the condition can be applied to a given basket line F)stockrecord_idrrr get_is_discountable)r/r rrrr can_apply_conditions  z%AbstractCondition.can_apply_conditioncCshg}x:|jD].}|j|sqt||}|s.q|j||fqWtjd}|r\t|d|dSt||dS)zW Return line data for the lines that can be consumed by this condition rT)r r )r )r r rrsrrr)r/r[ryZmost_expensive_firstrr rr rrr rs   z&AbstractCondition.get_applicable_lines)rrr)T)rrrrrrrr"rrrrrrr,rrrrr+r!r8r#rrxr{r}r rrrrr rs2      rc@seZdZdZejeddddZej edddddZ ej dd Z ej ed d ed d Zej edd dZejdddedddZejdddeddZejdddeddZejdddeddZejeddddd Zejed!dd"ZdZdZdZdZdZejZe Z!Gd#d$d$Z"d%d&Z#d'd(Z$e%d)d*Z&dKd+d,Z'd-d.Z(d/d0Z)e*d1d2Z+d3d4Z,e%d5d6Z-d7d8Z.d9d:Z/d;d<Z0d=d>Z1d?d@Z2dAdBZ3dCdDZ4dEdFZ5e6dGdHZ7e6dIdJZ8dS)L AbstractRangez Represents a range of products that can be used within an offer. Ranges only support adding parent or stand-alone products. Offers will consider child products automatically. r:r;T)r<r=r?r4)r<r=r@)rBz Is public?Fz)Public ranges have a customer-facing page)rIr>zIncludes all products?)rIzcatalogue.ProductZincludeszIncluded Productszoffer.RangeProduct)rRrBrSthroughZexcludeszExcluded Products)rRrBrSzcatalogue.ProductClassclassesz Product Typeszcatalogue.CategoryzIncluded Categoriesz Custom classrN)r<rIr=z Date Created)rZc@s$eZdZdZdZedZedZdS)zAbstractRange.MetaTr[rRangesN)rrrrr]r"rSr_rrrr r!0sr!cCs|jS)N)r4)r/rrr r56szAbstractRange.__str__cCstdd|jidS)Nzcatalogue:rangeri)rh)r ri)r/rrr rj9szAbstractRange.get_absolute_urlcCs|jrt|jSdS)N)r+r)r/rrr r3=szAbstractRange.proxycCsr|pd}tdd}|jj||d|id\}}|dk rL|j|krL||_|j|j|jkrn|jj||j dS)a Add product to the range When adding product that is already in the range, prevent re-adding it. If display_order is specified, update it. Default display_order for a new product in the range is 0; this puts the product at the top of the list. rr[ RangeProduct display_order)rrdefaultsN) rr get_or_creater&rfr_excluded_product_idsexcluded_productsremoveinvalidate_cached_ids)r/rr&Z initial_orderr%relation__rrr add_productBs    zAbstractRange.add_productcCs6tdd}|jj||dj|jj||jdS)z Remove product from range. To save on queries, this function does not check if the product is in fact in the range. r[r%)rrN)rrrdeleter*addr,)r/rr%rrr remove_product]s  zAbstractRange.remove_productcCs|jr|jj|S|j}|j|kr(dS|jr2dS|j}|rP|jj|krPdS|j}|jrn|j j|krndS|j|kr|dS|j }|rx<|j j |j D](}x"|D]}||ks|j|rdSqWqWdS)zI Check whether the passed product is part of this range. FT)r3r r)rincludes_all_products _class_idsget_product_class_included_product_idsis_childparent_included_categoriesget_categoriesonly_category_comparison_fieldsis_descendant_of)r/rZexcluded_product_idsZ class_idsZincluded_product_idsZtest_categoriescategoryZ test_categoryrrr r ks0        zAbstractRange.contains_productcCs |j|S)N)r )r/rrrr containsszAbstractRange.containscCs&|jdd}tjj|}t|dhS)z Expects a product queryset; gets the primary keys of the passed products and their children. Verbose, but database and memory friendly. r\Z children__pkN) values_list itertoolschain from_iterableset)r/rZpk_tuples_iterableZ flat_iterablerrr Z__get_pks_and_child_pkss  z%AbstractRange.__get_pks_and_child_pkscCstdd}t|dfS)NrCategoryCOMPARISON_FIELDS)rr)r/rErrr r<s z)AbstractRange._category_comparison_fieldscCs0|js|jjS|jdkr*|jj|j|_|jS)N)rincluded_categoriesr#_AbstractRange__included_categoriesr;r<)r/rrr r9s    z"AbstractRange._included_categoriescCs(|js gS|jdkr"|j|j|_|jS)N)r$_AbstractRange__included_product_ids%_AbstractRange__get_pks_and_child_pksincluded_products)r/rrr r6s   z#AbstractRange._included_product_idscCs(|js gS|jdkr"|j|j|_|jS)N)r$_AbstractRange__excluded_product_idsrJr*)r/rrr r)s   z#AbstractRange._excluded_product_idscCs"|jdkr|jjddd|_|jS)Nr\T)flat)_AbstractRange__class_idsr#r@)r/rrr r4s zAbstractRange._class_idscCsX|jdkrRg}x<|jD]0}|jjddd}|j|j|jt|qW||_|jS)Nr\T)rM)_AbstractRange__category_idsr9get_descendantsr@rsr\extendr()r/idsr>Z children_idsrrr _category_idss   zAbstractRange._category_idscCsd|_d|_d|_d|_dS)N)rOrHrIrL)r/rrr r,sz#AbstractRange.invalidate_cached_idscCs&|jr|jjS|jrdS|jjS)N)r3 num_productsr3rcount)r/rrr rTs  zAbstractRange.num_productscCsx|jr|jjStdd}|jr6|jjj|jdS|jjt |j dt |j dBt |j dBj|jdj S)z Return a queryset containing all the products in the range This includes included_products plus the products contained in the included classes and categories, minus the products in excluded_products. rr)Zid__in)Zproduct_class_id__in)Z productcategory__category_id__in)r3rrr3r browsablerr)rrr6r4rSdistinct)r/rrrr rs    zAbstractRange.all_productscCs|j S)zI Test whether this range can be edited in the dashboard. )r+)r/rrr is_editableszAbstractRange.is_editablecCs t|jdkot|jdkS)zH Test whether products for the range can be re-ordered. r)lenr4r9)r/rrr is_reorderableszAbstractRange.is_reorderable)N)9rrrrrrr"r4rrrirr7rZ is_publicr3ManyToManyFieldrKr*r#rGrr+rrrIrLrHrNrOrrrrVr!r5rjr r3r/r2r rr?rJr<r9r6r)r4rSr,rTrr8rXrZrrrr r!sh       "    r!c@sJeZdZdZejdejdZejdejdZej ddZ GdddZ d S) AbstractRangeProductzP Allow ordering products inside ranges Exists to allow customising. z offer.Range)rQzcatalogue.Productr)rIc@seZdZdZdZdZdS)zAbstractRangeProduct.MetaTr[rrN)rr)rrrrr]unique_togetherrrrr r!sr!N) rrrrrrrrrrr&r!rrrr r\s  r\c@sJeZdZejdejdeddZejedddZ ej edZ eje ejed d Z ejed d d Zd,\ZZZeefeefeeffZejeddeedZejeddd dZejedd dZej edd dZej edd dZej edd dZGdddZeddZd-d d!Zd"d#Zd$d%Zd&d'Z d(d)Z!d*d+Z"dS).AbstractRangeProductFileUploadz offer.RangeZ file_uploadsr)rQrRrSz File Pathr)r<Sizez Uploaded By)rQrSz Date UploadedT)rZPendingFailed ProcessedrM )r<rHrIz Error Message)r<rBzDate Processed)rUzNumber of New SKUszNumber of Unknown SKUszNumber of Duplicate SKUsc@s(eZdZdZdZdZedZedZdS)z#AbstractRangeProductFileUpload.MetaTr[-date_uploadedzRange Product Uploaded FilezRange Product Uploaded FilesN)rd) rrrrr]r^r"rSr_rrrr r!7s r!cCstjj|jS)N)ospathbasenamefilepath)r/rrr filename>sz'AbstractRangeProductFileUpload.filenameNcCs"t|_||_|j|_|jdS)N)r date_processed error_messageFAILEDrcrf)r/messagerrr mark_as_failedBsz-AbstractRangeProductFileUpload.mark_as_failedcCs.|j|_t|_||_||_||_|jdS)N) PROCESSEDrcr rj num_new_skusnum_unknown_skusnum_duplicate_skusrf)r/Znum_newZ num_unknownZ num_duplicaterrr mark_as_processedHs z0AbstractRangeProductFileUpload.mark_as_processedcCs |j|jkS)N)rcro)r/rrr was_processing_successfulPsz8AbstractRangeProductFileUpload.was_processing_successfulcCst|j}|jj}|jddd}ttt|}|jddd}ttt|}|j|}||}tdd}|j jt j |dt j |dB}x|D]}|jj |qW|jddd} ttt| } ttt|jddd} | j| } || } t|j |} |j|jt| t| |S) zG Process the file upload and add products to the range Zstockrecords__partner_skuT)rMupcrr)Zstockrecords__partner_sku__in)Zupc__in)rD extract_idsrrr@rboolunionr_default_managerrrr/ intersectionrsrUrY)r/Zall_idsrZ existing_skusZ existing_upcsZ existing_idsnew_idsrrZ found_skusZ found_upcsZ found_idsZ missing_idsZdupesrrr processSs0         z&AbstractRangeProductFileUpload.processc csJt|jd4}x,|D]$}xtjd|D]}|r&|Vq&WqWWdQRXdS)zD Extract all SKU- or UPC-like strings from the file rz [^\w:\.-]N)openrhresplit)r/fhr rrrr rvts  z*AbstractRangeProductFileUpload.extract_idscCstj|jdS)N)reunlinkrh)r/rrr delete_file~sz*AbstractRangeProductFileUpload.delete_file)r`rarb)N)#rrrrrrr"rrrhrsizerZ uploaded_byrZ date_uploadedPENDINGrlrorHrcrkrjrprqrrr!r8rirnrsrtr|rvrrrrr r^sF         ! r^)6rArrer~decimalrrr django.confr django.corer django.dbrdjango.db.models.queryrdjango.template.defaultfiltersrr django.urlsr django.utils.functionalr Zdjango.utils.timezoner r django.utils.translationr r"oscar.core.compatroscar.core.decoratorsrZoscar.core.loadingrrrZ oscar.modelsr#oscar.templatetags.currency_filtersrrrrrrModelrr9rrr!r\r^rrrr sD               5oa_