We apologize for the inconvenience." dictLanguage.Add "english_PrdError_3", "Loading Product Images... If the images do not appear in 15 seconds ." 'Product Related Errors end ' PayPal dictLanguage.Add "english_PayPal_1", "PayPal did not have a shipping phone on record for your account. Please enter the phone number in the Customer Information Section below." '// Express Only - When there is no phone number. dictLanguage.Add "english_PayPal_2", "Review Your PayPal Shipping Address" '"You were NOT charged. There was a communication error when connecting to PayPal.
We apologize for the inconvenience. Please select another payment option." dictLanguage.Add "english_PayPal_3", "Optionally enter a password to be able to log into your account on our store (e.g. to repeat a previous order, download electronic goods, use our Help Desk, etc,)." '// Express Only - Shows the first time you register on the site only. dictLanguage.Add "english_PayPal_4", "Customer Information" '// Express Only dictLanguage.Add "english_PayPal_5", "Billing Information" '// Express Only dictLanguage.Add "english_PayPal_6", "Your Billing Information can not be edited because it is secured at PayPal." '// Express Only dictLanguage.Add "english_PayPal_7", "Payment Method Charge" '// Order Itemization Labels dictLanguage.Add "english_PayPal_8", "Category Discounts" '// Order Itemization Labels dictLanguage.Add "english_PayPal_9", "Gift Wrapping" '// Order Itemization Labels ' Google Checkout dictLanguage.Add "english_GoogleCheckout_1", "Processing Google Checkout Request...
If Google Checkout does not respond in 15 seconds there may be a communication error. You can retrieve your order by viewing your basket and continuing your order from that point. Contact us if you are not able to place your order and we will be happy to assist you." dictLanguage.Add "english_DownloadURLNote_1", "Note: If the download link appears on two lines, please copy and paste each portion of the link into your browser address field and then press the 'Enter' key." 'Recent Products dictLanguage.Add "english_viewProducts_1", "Recently Viewed..." dictLanguage.Add "english_viewProducts_2", "Clear List" ' Generic product ID error dictLanguage.Add "english_msg_210", "The page cannot be loaded because some of the information provided to the system was incorrect (e.g. wrong product or category number). Please try again or contact us if the problem persists." dictLanguage.Add "english_PageNavigaion_1", "First" dictLanguage.Add "english_PageNavigaion_2", "Previous" dictLanguage.Add "english_PageNavigaion_3", "Pages" dictLanguage.Add "english_PageNavigaion_4", "Next" dictLanguage.Add "english_PageNavigaion_5", "Last" dictLanguage.Add "english_PageNavigaion_6", "View All Results" ' End new text strings added for ProductCart v3 ' START New ALT tags added with v3.11 dictLanguage.Add "english_altTag_1", "Show product details for " dictLanguage.Add "english_altTag_2", "Add to the cart: " dictLanguage.Add "english_altTag_2b", "Add to the cart" dictLanguage.Add "english_altTag_3", "Previous Item" dictLanguage.Add "english_altTag_4", "Next Item" dictLanguage.Add "english_altTag_5", "View a larger version of this image" dictLanguage.Add "english_altTag_6", "View quantity discount details" dictLanguage.Add "english_altTag_7", "Save to my Wish List" dictLanguage.Add "english_altTag_8", "Tell a friend" dictLanguage.Add "english_altTag_9", "Customize" dictLanguage.Add "english_altTag_10", "Return to Gift Registry" dictLanguage.Add "english_altTag_11", "Continue shopping" dictLanguage.Add "english_altTag_12", "Checkout" dictLanguage.Add "english_altTag_13", "Remove from cart" dictLanguage.Add "english_altTag_14", "Add to Gift Registry" dictLanguage.Add "english_altTag_15", "Back" ' END New ALT tags added with v3.11 ' START: v3.5 dictLanguage.Add "english_CheckTextField_1", "The text field exceeds " dictLanguage.Add "english_CheckTextField_1a", " characters" dictLanguage.Add "english_GCRecipient_1", "Recipient Information" dictLanguage.Add "english_GCRecipient_2", "Resend Notification" dictLanguage.Add "english_GCRecipient_3", "The notification has been resent successfully!" dictLanguage.Add "english_defaultnotice_1", "Included" dictLanguage.Add "english_orderverify_44", "Product Tax" dictLanguage.Add "english_orderverify_45", "Items in the cart may have changed since this page was first loaded. Please close all other open browser windows before you continue." dictLanguage.Add "english_GateWay_23", "CLICK HERE TO COMPLETE YOUR ORDER!" dictLanguage.Add "english_Custmoda_24", "SSN: " dictLanguage.Add "english_Custmoda_25", "You must enter a valid Social Security Number" dictLanguage.Add "english_Custmoda_26", "VAT ID: " dictLanguage.Add "english_Custmoda_27", "You must enter a valid VAT ID" dictLanguage.Add "english_prdD1_6", "Clear Selection" dictLanguage.Add "english_custOrdInvoice_36", "Bundle Discounts" dictLanguage.Add "english_CustviewPastD_54", "Bundle Discounts" dictLanguage.Add "english_security_6", "Invalid security code. Please enter the security code exactly as shown." dictLanguage.Add "english_security_20", "Please enter your name." dictLanguage.Add "english_security_21", "Please enter your e-mail address." dictLanguage.Add "english_security_22", "Please enter a subject for your message." dictLanguage.Add "english_security_23", "Please enter your message." dictLanguage.Add "english_security_24", "Please enter your friend's name." dictLanguage.Add "english_security_25", "Please enter your friend's e-mail." dictLanguage.Add "english_security_26", "Please enter the code shown below:
This is used to prevent scripts from sending SPAM using this form." dictLanguage.Add "english_NewAffa_2c", "Thank you for joining our affiliate program. Your new affiliate account is ready for you to use. With your e-mail and password you can log into your affiliate account, a dedicated area of our store where you can obtain special links that you can use on your Web site to refer customers to our store. You will also be able to track sales and earned commissions." dictLanguage.Add "english_NewAffa_terms", "Thank you for your interest in our affiliate program.
Please fill out the form below to create a new affiliate account. By applying for an affiliate account, you are agreeing to the terms and conditions of our affiliate program." dictLanguage.Add "english_tellafriend_20", " found something you might like" dictLanguage.Add "english_tellafriend_21", "Thank you for taking the time to refer one of our products to a friend!" dictLanguage.Add "english_tellafriend_22", "Product you referred: " dictLanguage.Add "english_tellafriend_23", "A message was successfully sent to: " dictLanguage.Add "english_tellafriend_24", "Thank you for your referral" dictLanguage.Add "english_tellafriend_25", "Tell A Friend notification" dictLanguage.Add "english_tellafriend_26", "This is just to let you know that a store visitor referred the following product to a friend." dictLanguage.Add "english_categorysearchfield_1", "Narrow By:" dictLanguage.Add "english_categorysearchfield_2", "... show more" dictLanguage.Add "english_categorysearchfield_3", "... show less" dictLanguage.Add "english_categorysearchfield_4", "Please wait..." dictLanguage.Add "english_security_27", "Store administrator," & vbcrlf & "Someone has submit PayPal payment lower than the total value of the shopping cart. This may indicate a fraudulent attempt to purchase goods below their value. Please review order
- To return to the store's home page, click here.
- To contact the store administrator, click here.
- Make sure to use the e-mail that you used when you placed the order.
- The Order Code was included in the e-mail notification that was sent to you when you placed your order.
- If you cannot locate the order code, no problem. Click here to have it sent to the e-mail on file.
If you entered a quantity that was equal or lower than the stock level shown on the product details page, it might be that another customer placed an order before you completed yours, with the result of reducing the inventory levels.
Please reduce the amount of the products affected by this inventory problem, or remove them from the shopping cart.
We sincerely apologize for the inconvenience.
The products affected are:
" dictLanguage.Add "english_validate_5", "Welcome back!
It appears that when you first visited our store, you did not register an account.
Please use the Order Review section of this page to access the system and view order details. Once logged in, you can also convert your account and take advantage of additional features." dictLanguage.Add "english_checkout_29", "Forgot Order Code(s)" dictLanguage.Add "english_checkout_30", "Your email address does not appear to be in our customer database." dictLanguage.Add "english_checkout_31", "You did not place any orders on our store" dictLanguage.Add "english_checkout_32", "Your order code(s) have been e-mailed to you. Please check your e-mail now to retrieve them." dictLanguage.Add "english_checkout_33", "Forgot your order code(s)?" dictLanguage.Add "english_checkout_34", "Click here to have them e-mailed to you." dictLanguage.Add "english_checkout_35", "You have already registered an account with our store. Please log into your account." dictLanguage.Add "english_forgotordercodesmailsubject", "Your order code(s)" dictLanguage.Add "english_forgotordercodesmailbody", "Hello #firstname #lastname," &VBcrlf &VBcrlf & "This is the list of your order code(s):" & VBcrlf & VBcrlf & "#ordercodes" &VBcrlf &VBcrlf &"Thank you for shopping with us." &VBcrlf &VBcrlf & scStoreURL dictLanguage.Add "english_opc_4d", "New customer checkout" dictLanguage.Add "english_opc_4e", "Save a password to checkout faster next time and have access to all account management features." dictLanguage.Add "english_opc_4f", "New customer checkout" dictLanguage.Add "english_opc_4g", "Quickly register a new account with our speedy One Page Checkout system!" dictLanguage.Add "english_opc_5a", "This e-mail address already exists in our customer database. Please enter a different e-mail address, or log into your account by using either this e-mail address and your password (if any), or this e-mail address and the Order Code that was included in the order notification message that you received at the time you placed an order." dictLanguage.Add "english_opc_51a", "OK" dictLanguage.Add "english_opc_85", "You have access to limited features because you logged in with your e-mail and Order Code. To have access to all account features, please log in with your password (retrieve a forgotten password)." dictLanguage.Add "english_storeEmail_30", "ORDER CODE: " dictLanguage.Add "english_storeEmail_31", "Please print out your order code and/or keep it in a safe place." dictLanguage.Add "english_storeEmail_32", "You will need this code and your e-mail address to log in and review your order." dictLanguage.Add "english_showcart_30", "Available" dictLanguage.Add "english_opc_msg2", "Copy from my Billing Address" dictLanguage.Add "english_order_FF", "Receive Product Review Reminders?" dictLanguage.Add "english_prv_22", "To thank you for taking the time to review the product(s) you purchased, we will award some
Hello !
Listed below are products from one of your recent orders that you can review.
" dictLanguage.Add "english_prv_25", "Write a review" dictLanguage.Add "english_prv_26", "(already reviewed)" dictLanguage.Add "english_prv_27", "We have detected that you are not a registered customer. Please add a password to your account so that you can take advantage of theThank you for your recent order. We'd love it if you decided to share your thoughts on the product(s) you purchased with other customers. Your opinion can be very useful to other shoppers.
" dictLanguage.Add "english_prv_29", "To thank you for writing a review, we will add up to
" dictLanguage.Add "english_prv_38", "
Thanks again for shopping with us.
Customer Service
-----------------------------------
UNSUBSCRIBE: If you do not wish to receive ""Write a Review"" reminders like this, please "">click here to unsubscribe." dictLanguage.Add "english_prv_33", "You will no longer receive 'Write a Review' notifications at this address. If you want to change this setting and subscribe again, please log into your account to do so." dictLanguage.Add "english_prv_34", "You must type " dictLanguage.Add "english_prv_35", "more characters before your review can be accepted. Do not use HTML." dictLanguage.Add "english_prv_36", "Please note:
Thanks again for shopping with us.
Customer Service
NOTE: To cancel an Auto-Delivery subscription, click Manage Auto-Delivery Subscription. You will be taken to another website. Click Cancel Subscription. You will need to enter the same password that you entered to log into this page.
" 'SUBSCRIPTIONBRIDGE-E ' end language definitions function clearLanguage() ' clear the dictionary. on error resume next clearLanguage=dictLanguage.removeAll set clearLanguage=nothing end function %> <% 'This file is part of ProductCart, an ecommerce application developed and sold by Early Impact LLC. ProductCart, its source code, the ProductCart name and logo are property of Early Impact, LLC. Copyright 2001-2003. All rights reserved. You are not allowed to use, alter, distribute and/or resell any parts of ProductCart's source code without the written consent of Early Impact. To contact Early Impact, please visit www.earlyimpact.com. %> <% Function RoundTo(intNum, intRn) RoundTo= Int((intNum / intRn)+.5) * intRn End Function function money(anumber) if anumber="" OR anumber=0 then anumber=0 money=0 end if if cdbl(anumber)<0 then test=true bnumber=abs(anumber) else bnumber=anumber end if ' round number if bnumber<>0 then if InStr(Cstr(10/3),",")>0 then if Instr(bnumber,".")>0 then money=FormatNumber(bnumber,,,,0) money=RoundTo(money,.01) money=replace(money,".",",") else money=RoundTo(bnumber,.01) end if else money=RoundTo(bnumber,.01) end if end if if scDecSign="," then ' replace . by , money=replace(money,".",",") else ' replace , by . money=replace(money,",",".") end if ' locate dec division dim indexPoint indexPoint=instr(money, scDecSign) ' for integer, add .00 if indexPoint=0 then money=Cstr(money)+scDecSign+"00" end if ' calculate if 0 or 00 dim moneyLarge, decPart moneyLarge=len(money) decPart=right(money,moneyLarge-indexPoint) ' add to original numbers dim g for g=0 to (1- (moneyLarge-indexPoint)) money=Cstr(money)+"0" next If len(money)>6 then money=divideNo(money) End If dim test if test=true then money="-" & money test=false end if end function function extmoney(anumber) if anumber="" OR anumber=0 then anumber=0 extmoney=0 end if if cdbl(anumber)<0 then test=true anumber=abs(anumber) end if ' round number if anumber<>0 then extmoney=round(anumber,4) end if if scDecSign="," then ' replace . by , extmoney=replace(extmoney,".",",") else ' replace , by . extmoney=replace(extmoney,",",".") end if ' locate dec division dim indexPoint indexPoint=instr(extmoney, scDecSign) ' for integer, add .00 if indexPoint=0 then extmoney=Cstr(extmoney)+scDecSign+"00" end if ' calculate if 0 or 00 dim extmoneyLarge, decPart extmoneyLarge=len(extmoney) decPart=right(extmoney,extmoneyLarge-indexPoint) ' add to original numbers dim g for g=0 to (1- (extmoneyLarge-indexPoint)) extmoney=Cstr(extmoney)+"0" next If len(extmoney)>6 then extmoney=divideNo(extmoney) End If if test=true then extmoney="-" & extmoney test=false end if end function ' use this function to display numbers like 125,000,000 function divideNo(anumber) ' locate scDecSign position scDecSignExist = instr(anumber, scDecSign) - 1 if scDecSignExist <= 0 then scDecSignExist = len(anumber) end if ' add divideNo to integers CntNo = 0 if scDecSignExist > 3 then for indexPoint = scDecSignExist to 1 step -1 pNumber = mid(anumber,indexPoint,1) if pNumber <> scDecSign then CntNo = CntNo + 1 pdivideNo = pNumber & pdivideNo end if if CntNo = 3 and (indexPoint > 1) then pdivideNo = scDivSign & pdivideNo CntNo = 0 end if pNumber = "" next ' add decimals pdivideNo = pdivideNo & mid(anumber, scDecSignExist+1, Len(anumber)) divideNo = pdivideNo else divideNo = anumber end if end function function taxmoney(anumber) ' round number taxmoney=round(anumber,4) end function %> <%private const scShipFromName="Quest Nutrition" private const scOriginPersonName="Shipping" private const scOriginDepartment="" private const scOriginPhoneNumber="888-212-0601" private const scOriginPagerNumber="" private const scOriginFaxNumber="" private const scShipFromAddress1="7723 Somerset Blvd" private const scShipFromAddress2="" private const scShipFromAddress3="" private const scShipFromCity="Paramount" private const scShipFromState="CA" private const scShipFromPostalCode="90723" private const scAlwAltShipAddress="2" private const scComResShipAddress="0" private const scAlwNoShipRates="-1" private const scShipFromPostalCountry="US" private const scShowProductWeight="0" private const scPackageWeightLimit="48" private const scShowCartWeight="0" private const scShowEstimateLink="-1" private const scHideProductPackage="0" private const scHideEstimateDeliveryTimes="0" private const scShipFromWeightUnit="LBS" private const scDefaultProvider="CUSTOM" private const scHideShipAddress="" private const scShipNotifySeparate="0" private const PC_SECTIONSHOW="NA" private const PC_RATESONLY="NO" private const PC_SHIP_DETAIL_TITLE="" private const PC_SHIP_DETAILS="" %> <%private const pTaxonCharges=0 private const pTaxonFees=0 private const ptaxfile=0 private const ptaxsetup=1 private const ptaxshippingaddress="1" private const ptaxseparate="0" private const ptaxwholesale="0" private const pshowVatID="0" private const pVatIdReq="0" private const pshowSSN="0" private const pSSNReq="0" private const ptaxVATrate="0" private const ptaxVATRate_Code="" private const ptaxVAT="0" private const ptaxdisplayVAT="0" private const ptaxRateDefault=", " private const ptaxRateState=", " private const ptaxSNH=", " private const ptaxCanada="" private const ptaxfilename=""%> <% if session("language")="" then session("language")="english" end if dim ship_dictLanguage set ship_dictLanguage=CreateObject("Scripting.Dictionary") ' english ship_dictLanguage.Add "english_shiplogin_a", "Please wait while we gather shipping information for your order" ship_dictLanguage.Add "english_chooseShpmnt_a", "Service Type" ship_dictLanguage.Add "english_chooseShpmnt_b", "Delivery Time" ship_dictLanguage.Add "english_chooseShpmnt_c", "Rate" ship_dictLanguage.Add "english_chooseShpmnt_d", "No shipping rates were returned for your order. The shipping provider's server may be unavailable at this time. Please try again in a few minutes. If the problem persists, please contact the store administrator." ship_dictLanguage.Add "english_chooseShpmnt_e", "*Free shipping applies only to the services that are marked as "Free"." ship_dictLanguage.Add "english_chooseShpmnt_f", "Free*" ship_dictLanguage.Add "english_chooseShpmnt_g", "We were not able to calculate shipping rates for your order at this time. If you continue the checkout process, we will contact you after we receive your order to discuss shipping options with you. Shipping charges will be added to your order at that time." ship_dictLanguage.Add "english_chooseShpmnt_h", "This order will be shipped in " ship_dictLanguage.Add "english_chooseShpmnt_i", " package(s)" ship_dictLanguage.Add "english_login_a", "Not Available" ship_dictLanguage.Add "english_login_b", "Shipping Information" ship_dictLanguage.Add "english_login_c", "Residence" ship_dictLanguage.Add "english_login_d", "Business" ship_dictLanguage.Add "english_login_e", "You have " ship_dictLanguage.Add "english_login_f", ". That means " ship_dictLanguage.Add "english_login_g", " to use towards this purchase!" ship_dictLanguage.Add "english_login_h", "Will this order be shipped to a business or residence?" ship_dictLanguage.Add "english_custRewards_a", "Your current " ship_dictLanguage.Add "english_custRewards_b", " balance is " ship_dictLanguage.Add "english_custRewards_c", "This translates into " ship_dictLanguage.Add "english_custRewards_d", " that you can use for purchases in this store." ship_dictLanguage.Add "english_custRewards_e", "You can use your " ship_dictLanguage.Add "english_custRewards_f", " when placing an order by entering the desired amount on the checkout page." ship_dictLanguage.Add "english_custRewards_g", "To date, you have accrued a total of " ship_dictLanguage.Add "english_custRewards_h", "To date, you have used a total of " ship_dictLanguage.Add "english_viewCart_a", "Total Weight: " ship_dictLanguage.Add "english_viewCart_b", "Estimated Shipping Charges" ship_dictLanguage.Add "english_viewCart_c", "Weight: " ship_dictLanguage.Add "english_noShip_a", "No shipping charge (or no shipping required)." 'do not use more then one comma in this line. ship_dictLanguage.Add "english_noShip_b", "Shipping charges to be determined." 'do not use more then one comma in this line. ship_dictLanguage.Add "english_chooseShpmnt_j", "Flat Rate Shipping" ship_dictLanguage.Add "english_chooseShpmnt_k", "UPS" ship_dictLanguage.Add "english_chooseShpmnt_l", "USPS" ship_dictLanguage.Add "english_chooseShpmnt_m", "FedEx" ship_dictLanguage.Add "english_chooseShpmnt_n", "Canada Post" ' START new text strings in v3 ship_dictLanguage.Add "english_chooseShpmnt_10", "Choose Shipping Provider" ship_dictLanguage.Add "english_chooseShpmnt_11", "Select a Shipping Option" 'Start SDBA ship_dictLanguage.Add "english_dropshipping_msg", "Please note that this order might be shipped from multiple warehouses and therefore arrive in separate packages." ship_dictLanguage.Add "english_partship_sbj_1", "Order ID #
The order #
" 'End SDBA ' END new text strings in v3 ' START new text strings in v3.1 ship_dictLanguage.Add "english_xmlPrdInfo_kg", "kg" ship_dictLanguage.Add "english_xmlPrdInfo_g", "g" ship_dictLanguage.Add "english_xmlPrdInfo_lbs", "lbs" ship_dictLanguage.Add "english_xmlPrdInfo_ozs", "ozs" ' END new text strings in v3.1 ' START new text strings in v3.5 ship_dictLanguage.Add "english_partship_msg_9", "Tracking Link: " ship_dictLanguage.Add "english_orderVerify_msg_1", "You cannot checkout because the order amount has changed and free shipping is not available with the new order amount. Please click on the Back button above to recalculate shipping charges" ' END new text strings in v3.5 ' end language definitions function clearShipLanguage() ' clear the dictionary. on error resume next clearShipLanguage = ship_dictLanguage.removeAll set clearShipLanguage = nothing end function %> <% '-------------------------------------------------------------------- ' Microsoft ADO ' ' (c) 1996 Microsoft Corporation. All Rights Reserved. ' ' ' ' ADO constants include file for VBScript ' '-------------------------------------------------------------------- '---- CursorTypeEnum Values ---- Const adOpenForwardOnly=0 Const adOpenKeyset=1 Const adOpenDynamic=2 Const adOpenStatic=3 '---- CursorOptionEnum Values ---- Const adHoldRecords=&H00000100 Const adMovePrevious=&H00000200 Const adAddNew=&H01000400 Const adDelete=&H01000800 Const adUpdate=&H01008000 Const adBookmark=&H00002000 Const adApproxPosition=&H00004000 Const adUpdateBatch=&H00010000 Const adResync=&H00020000 Const adNotify=&H00040000 '---- LockTypeEnum Values ---- Const adLockReadOnly=1 Const adLockPessimistic=2 Const adLockOptimistic=3 Const adLockBatchOptimistic=4 '---- ExecuteOptionEnum Values ---- Const adRunAsync=&H00000010 '---- ObjectStateEnum Values ---- Const adStateClosed=&H00000000 Const adStateOpen=&H00000001 Const adStateConnecting=&H00000002 Const adStateExecuting=&H00000004 '---- CursorLocationEnum Values ---- Const adUseServer=2 Const adUseClient=3 '---- DataTypeEnum Values ---- Const adEmpty=0 Const adTinyInt=16 Const adSmallInt=2 Const adInteger=3 Const adBigInt=20 Const adUnsignedTinyInt=17 Const adUnsignedSmallInt=18 Const adUnsignedInt=19 Const adUnsignedBigInt=21 Const adSingle=4 Const adDouble=5 Const adCurrency=6 Const adDecimal=14 Const adNumeric=131 Const adBoolean=11 Const adError=10 Const adUserDefined=132 Const adVariant=12 Const adIDispatch=9 Const adIUnknown=13 Const adGUID=72 Const adDate=7 Const adDBDate=133 Const adDBTime=134 Const adDBTimeStamp=135 Const adBSTR=8 Const adChar=129 Const adVarChar=200 Const adLongVarChar=201 Const adWChar=130 Const adVarWChar=202 Const adLongVarWChar=203 Const adBinary=128 Const adVarBinary=204 Const adLongVarBinary=205 '---- FieldAttributeEnum Values ---- Const adFldMayDefer=&H00000002 Const adFldUpdatable=&H00000004 Const adFldUnknownUpdatable=&H00000008 Const adFldFixed=&H00000010 Const adFldIsNullable=&H00000020 Const adFldMayBeNull=&H00000040 Const adFldLong=&H00000080 Const adFldRowID=&H00000100 Const adFldRowVersion=&H00000200 Const adFldCacheDeferred=&H00001000 '---- EditModeEnum Values ---- Const adEditNone=&H0000 Const adEditInProgress=&H0001 Const adEditAdd=&H0002 Const adEditDelete=&H0004 '---- RecordStatusEnum Values ---- Const adRecOK=&H0000000 Const adRecNew=&H0000001 Const adRecModified=&H0000002 Const adRecDeleted=&H0000004 Const adRecUnmodified=&H0000008 Const adRecInvalid=&H0000010 Const adRecMultipleChanges=&H0000040 Const adRecPendingChanges=&H0000080 Const adRecCanceled=&H0000100 Const adRecCantRelease=&H0000400 Const adRecConcurrencyViolation=&H0000800 Const adRecIntegrityViolation=&H0001000 Const adRecMaxChangesExceeded=&H0002000 Const adRecObjectOpen=&H0004000 Const adRecOutOfMemory=&H0008000 Const adRecPermissionDenied=&H0010000 Const adRecSchemaViolation=&H0020000 Const adRecDBDeleted=&H0040000 '---- GetRowsOptionEnum Values ---- Const adGetRowsRest=-1 '---- PositionEnum Values ---- Const adPosUnknown=-1 Const adPosBOF=-2 Const adPosEOF=-3 '---- enum Values ---- Const adBookmarkCurrent=0 Const adBookmarkFirst=1 Const adBookmarkLast=2 '---- MarshalOptionsEnum Values ---- Const adMarshalAll=0 Const adMarshalModifiedOnly=1 '---- AffectEnum Values ---- Const adAffectCurrent=1 Const adAffectGroup=2 Const adAffectAll=3 '---- FilterGroupEnum Values ---- Const adFilterNone=0 Const adFilterPendingRecords=1 Const adFilterAffectedRecords=2 Const adFilterFetchedRecords=3 Const adFilterPredicate=4 '---- SearchDirection Values ---- Const adSearchForward=1 Const adSearchBackward=-1 '---- ConnectPromptEnum Values ---- Const adPromptAlways=1 Const adPromptComplete=2 Const adPromptCompleteRequired=3 Const adPromptNever=4 '---- ConnectModeEnum Values ---- Const adModeUnknown=0 Const adModeRead=1 Const adModeWrite=2 Const adModeReadWrite=3 Const adModeShareDenyRead=4 Const adModeShareDenyWrite=8 Const adModeShareExclusive=&Hc Const adModeShareDenyNone=&H10 '---- IsolationLevelEnum Values ---- Const adXactUnspecified=&Hffffffff Const adXactChaos=&H00000010 Const adXactReadUncommitted=&H00000100 Const adXactBrowse=&H00000100 Const adXactCursorStability=&H00001000 Const adXactReadCommitted=&H00001000 Const adXactRepeatableRead=&H00010000 Const adXactSerializable=&H00100000 Const adXactIsolated=&H00100000 '---- XactAttributeEnum Values ---- Const adXactCommitRetaining=&H00020000 Const adXactAbortRetaining=&H00040000 '---- PropertyAttributesEnum Values ---- Const adPropNotSupported=&H0000 Const adPropRequired=&H0001 Const adPropOptional=&H0002 Const adPropRead=&H0200 Const adPropWrite=&H0400 '---- ErrorValueEnum Values ---- Const adErrInvalidArgument=&Hbb9 Const adErrNoCurrentRecord=&Hbcd Const adErrIllegalOperation=&Hc93 Const adErrInTransaction=&Hcae Const adErrFeatureNotAvailable=&Hcb3 Const adErrItemNotFound=&Hcc1 Const adErrObjectInCollection=&Hd27 Const adErrObjectNotSet=&Hd5c Const adErrDataConversion=&Hd5d Const adErrObjectClosed=&He78 Const adErrObjectOpen=&He79 Const adErrProviderNotFound=&He7a Const adErrBoundToCommand=&He7b Const adErrInvalidParamInfo=&He7c Const adErrInvalidConnection=&He7d Const adErrStillExecuting=&He7f Const adErrStillConnecting=&He81 '---- ParameterAttributesEnum Values ---- Const adParamSigned=&H0010 Const adParamNullable=&H0040 Const adParamLong=&H0080 '---- ParameterDirectionEnum Values ---- Const adParamUnknown=&H0000 Const adParamInput=&H0001 Const adParamOutput=&H0002 Const adParamInputOutput=&H0003 Const adParamReturnValue=&H0004 '---- CommandTypeEnum Values ---- Const adCmdUnknown=&H0008 Const adCmdText=&H0001 Const adCmdTable=&H0002 Const adCmdStoredProc=&H0004 '---- SchemaEnum Values ---- Const adSchemaProviderSpecific=-1 Const adSchemaAsserts=0 Const adSchemaCatalogs=1 Const adSchemaCharacterSets=2 Const adSchemaCollations=3 Const adSchemaColumns=4 Const adSchemaCheckConstraints=5 Const adSchemaConstraintColumnUsage=6 Const adSchemaConstraintTableUsage=7 Const adSchemaKeyColumnUsage=8 Const adSchemaReferentialContraints=9 Const adSchemaTableConstraints=10 Const adSchemaColumnsDomainUsage=11 Const adSchemaIndexes=12 Const adSchemaColumnPrivileges=13 Const adSchemaTablePrivileges=14 Const adSchemaUsagePrivileges=15 Const adSchemaProcedures=16 Const adSchemaSchemata=17 Const adSchemaSQLLanguages=18 Const adSchemaStatistics=19 Const adSchemaTables=20 Const adSchemaTranslations=21 Const adSchemaProviderTypes=22 Const adSchemaViews=23 Const adSchemaViewColumnUsage=24 Const adSchemaViewTableUsage=25 Const adSchemaProcedureParameters=26 Const adSchemaForeignKeys=27 Const adSchemaPrimaryKeys=28 Const adSchemaProcedureColumns=29 %> <% ' Cognecy Edit 30Apr2011 - added to improve session stability - forces 'www' at all times while in the store %> <% pcv_strServerURL = request.ServerVariables("HTTP_HOST") pcv_strScriptName = request.ServerVariables("SCRIPT_NAME") pcv_strQS = "" pcv_strQScount = 0 For Each Item In Request.querystring if pcv_strQScount = 0 then pcv_strQS = pcv_strQS & "?" else pcv_strQS = pcv_strQS & "&" end if pcv_strQS = pcv_strQS & item & "=" & request.QueryString(item) pcv_strQScount = pcv_strQScount + 1 Next if pcv_strServerURL="questproteinbar.com" then Response.Status="301 Moved Permanently" Response.AddHeader "Location", "http://www.questproteinbar.com" & pcv_strScriptName & pcv_strQS else Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control","private, no-cache, must-revalidate" Response.CacheControl = "no-cache" Response.Expires = -1 end if %> <% ' END Cognecy Edit %> <% '// Main function used to sanitize strings function getUserInput(input,stringLength) dim tempStr,i,known_bad known_bad= array("*","--","expression(") if stringLength>0 then tempStr = left(trim(input),stringLength) else tempStr = trim(input) end if for i=lbound(known_bad) to ubound(known_bad) if (instr(1,tempStr,known_bad(i),vbTextCompare)<>0) then tempStr = replace(tempStr,known_bad(i),"",1,-1,1) end if next if tempStr<>"" then tempStr = replace(tempStr,"'","''") tempStr = replace(tempStr,"<","<") tempStr = replace(tempStr,">",">") tempStr = replace(tempStr,"%0d","") tempStr = replace(tempStr,"%0D","") tempStr = replace(tempStr,"%0a","") tempStr = replace(tempStr,"%0A","") tempStr = replace(tempStr,"\r\n","") tempStr = replace(tempStr,"\r","") tempStr = replace(tempStr,"\n","") tempStr = replace(tempStr,"\R\N","") tempStr = replace(tempStr,"\R","") tempStr = replace(tempStr,"\N","") tempStr = replace(tempStr,"EXEC(","",1,-1,1) tempStr = replace(tempStr,"NOT IN (SELECT","",1,-1,1) tempStr = replace(tempStr,"(SELECT","",1,-1,1) tempStr = replace(tempStr,"ResponseSplitting","",1,-1,1) tempStr = replace(tempStr,"Content-Type","",1,-1,1) end if if tempStr<>"" then if IsNumeric(tempStr) then if InStr(Cstr(10/3),",")>0 then if Instr(tempStr,".")>0 then tempStr=FormatNumber(tempStr,,,,0) tempStr=replace(tempStr,".",",") end if end if end if end if getUserInput = tempStr end function '// Slightly different function used for "Recently viewed products" feature function getUserInput2(input,stringLength) dim tempStr,i if stringLength>0 then tempStr = left(trim(input),stringLength) else tempStr = trim(input) end if if tempStr<>"" then tempStr = replace(tempStr,"'","''") tempStr = replace(tempStr,"<","<") tempStr = replace(tempStr,">",">") tempStr = replace(tempStr,"%0d","") tempStr = replace(tempStr,"%0D","") tempStr = replace(tempStr,"%0a","") tempStr = replace(tempStr,"%0A","") tempStr = replace(tempStr,"\r\n","") tempStr = replace(tempStr,"\r","") tempStr = replace(tempStr,"\n","") tempStr = replace(tempStr,"\R\N","") tempStr = replace(tempStr,"\R","") tempStr = replace(tempStr,"\N","") tempStr = replace(tempStr,"EXEC(","",1,-1,1) tempStr = replace(tempStr,"NOT IN (SELECT","",1,-1,1) tempStr = replace(tempStr,"(SELECT","",1,-1,1) tempStr = replace(tempStr,"ResponseSplitting","",1,-1,1) tempStr = replace(tempStr,"Content-Type","",1,-1,1) end if if tempStr<>"" then if IsNumeric(tempStr) then if InStr(Cstr(10/3),",")>0 then if Instr(tempStr,".")>0 then tempStr=FormatNumber(tempStr,,,,0) tempStr=replace(tempStr,".",",") end if end if end if end if getUserInput2 = tempStr end function '[ClearHTMLTags2] 'Coded by Jóhann Haukur Gunnarsson 'joi@innn.is ' Purpose: This function clears all HTML tags from a string using Regular Expressions. ' Inputs: strHTML2; A string to be cleared of HTML TAGS ' intWorkFlow2; An integer that if equals to 0 runs only the regEx2p filter ' .. 1 runs only the HTML source render filter ' .. 2 runs both the regEx2p and the HTML source render ' .. >2 defaults to 0 ' Returns: A string that has been filtered by the function function ClearHTMLTags2(strHTML2, intWorkFlow2) 'Variables used in the function dim regEx2, strTagLess2 '--------------------------------------- strTagLess2 = strHTML2 'Move the string into a private variable 'within the function '--------------------------------------- '--------------------------------------- 'Early Impact codes IF strTagLess2<>"" THEN strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,""," ") strTagLess2=replace(strTagLess2,vbcrlf," ") strTagLess2=replace(strTagLess2,"™","™") strTagLess2=replace(strTagLess2,"©","©") strTagLess2=replace(strTagLess2,"®","®") strTagLess2=trim(strTagLess2) do while instr(strTagLess2," ")>0 strTagLess2=replace(strTagLess2," "," ") loop END IF 'Modify the string to a friendly ONLY 1 LINE string '--------------------------------------- IF strTagLess2<>"" THEN 'regEx2 initialization '--------------------------------------- set regEx2 = New regExp 'Creates a regEx2p object regEx2.IgnoreCase = True 'Don't give frat about case sensitivity regEx2.Global = True 'Global applicability '--------------------------------------- 'Phase I ' "bye bye html tags" if intWorkFlow2 <> 1 then '--------------------------------------- regEx2.Pattern = "<[^>]*>" 'this pattern mathces any html tag strTagLess2 = regEx2.Replace(strTagLess2, "") 'all html tags are stripped '--------------------------------------- end if 'Phase II ' "bye bye rouge leftovers" ' "or, I want to render the source" ' "as html." '--------------------------------------- 'We *might* still have rouge < and > 'let's be positive that those that remain 'are changed into html characters '--------------------------------------- if intWorkFlow2 > 0 and intWorkFlow2 < 3 then regEx2.Pattern = "[<]" 'matches a single < strTagLess2 = regEx2.Replace(strTagLess2, "<") regEx2.Pattern = "[>]" 'matches a single > strTagLess2 = regEx2.Replace(strTagLess2, ">") '--------------------------------------- end if 'Clean up '--------------------------------------- set regEx2 = nothing 'Destroys the regEx2p object '--------------------------------------- END IF 'vefiry strTagLess2 (null strings) '--------------------------------------- ClearHTMLTags2 = strTagLess2 'The results are passed back '--------------------------------------- end function function ClearHTMLTags3(strHTML2, intWorkFlow2) 'Variables used in the function dim regEx2, strTagLess2 '--------------------------------------- strTagLess2 = strHTML2 'Move the string into a private variable 'within the function '--------------------------------------- '--------------------------------------- 'Early Impact codes IF strTagLess2<>"" THEN strTagLess2=replace(strTagLess2,""," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,"
"," ") strTagLess2=replace(strTagLess2,""," ") strTagLess2=replace(strTagLess2,vbcrlf," ") strTagLess2=replace(strTagLess2,"™","™") strTagLess2=replace(strTagLess2,"©","©") strTagLess2=replace(strTagLess2,"®","®") strTagLess2=trim(strTagLess2) do while instr(strTagLess2," ")>0 strTagLess2=replace(strTagLess2," "," ") loop END IF 'Modify the string to a friendly ONLY 1 LINE string '--------------------------------------- IF strTagLess2<>"" THEN 'regEx2 initialization '--------------------------------------- set regEx2 = New regExp 'Creates a regEx2p object regEx2.IgnoreCase = True 'Don't give frat about case sensitivity regEx2.Global = True 'Global applicability '--------------------------------------- 'Phase I ' "bye bye html tags" if intWorkFlow2 <> 1 then '--------------------------------------- regEx2.Pattern = "<[^>]*>" 'this pattern mathces any html tag strTagLess2 = regEx2.Replace(strTagLess2, "") 'all html tags are stripped '--------------------------------------- end if 'Phase II ' "bye bye rouge leftovers" ' "or, I want to render the source" ' "as html." '--------------------------------------- 'We *might* still have rouge < and > 'let's be positive that those that remain 'are changed into html characters '--------------------------------------- if intWorkFlow2 > 0 and intWorkFlow2 < 3 then regEx2.Pattern = "[<]" 'matches a single < strTagLess2 = regEx2.Replace(strTagLess2, "<") regEx2.Pattern = "[>]" 'matches a single > strTagLess2 = regEx2.Replace(strTagLess2, ">") '--------------------------------------- end if 'Clean up '--------------------------------------- set regEx2 = nothing 'Destroys the regEx2p object '--------------------------------------- END IF 'vefiry strTagLess2 (null strings) '--------------------------------------- ClearHTMLTags3 = strTagLess2 'The results are passed back '--------------------------------------- end function 'check for real integers Function validNum(strInput) DIM iposition ' Current position of the character or cursor validNum = true if isNULL(strInput) OR trim(strInput)="" then validNum = false else 'loop through each character in the string and validate that it is a number or integer For iposition=1 To Len(trim(strInput)) if InStr(1, "12345676890", mid(strInput,iposition,1), 1) = 0 then validNum = false Exit For end if Next end if end Function '// This function is used to wrap text in e-mails (e.g. product name, product options) '// Assumption is that Width < len(Text) Public Function WrapString(ByVal Width, ByVal Text) wrapPos=0 iwrap = Width do while mid(Text,iwrap,1) <> " " AND iwrap > 0 iwrap=iwrap-1 loop if iwrap > 0 then WrapString=left(Text,iwrap) wrapPos = iwrap else WrapString=left(Text,Width) wrapPos = Width end if End Function '// Strip out Currency and Percent Characters From a String Public Function pcf_ReplaceChars(pricenumber) on error resume next pcf_ReplaceChars=replace(pricenumber,"%","") pcf_ReplaceChars=replace(pcf_ReplaceChars,scCurSign,"") '// If they still did not type a valid number set equal to zero. if not isNumeric(pcf_ReplaceChars) then pcf_ReplaceChars=0 end if End Function Public Function pcf_PayPalExpressOnly() '// Open Private Connection String Set conPayPalExpressOnly=Server.CreateObject("ADODB.Connection") conPayPalExpressOnly.Open scDSN pcf_PayPalExpressOnly=1 if session("customerType")=1 then query="SELECT idPayment FROM paytypes WHERE active=-1 AND gwCode<>999999 AND gwCode<>50;" else query="SELECT idPayment FROM paytypes WHERE active=-1 AND Cbtob=0 AND gwCode<>999999 AND gwCode<>50;" end if set rs=server.CreateObject("ADODB.RecordSet") set rs=conPayPalExpressOnly.execute(query) if err.number<>0 then set rs=nothing exit function end if PayTypesIndex=Cint(0) if NOT rs.eof then pcv_strTempPaymentOptionValue=rs("idPayment") PayTypesIndex=PayTypesIndex + 1 else set rs=nothing pcf_PayPalExpressOnly=0 end if set rs=nothing if int(PayTypesIndex)=0 then pcf_PayPalExpressOnly=0 end if '// Close Private Connection String conPayPalExpressOnly.Close Set conPayPalExpressOnly=nothing End Function Public Function pcf_PaymentTypes(GatewayName) '// Open Private Connection String Set conPaymentTypes=Server.CreateObject("ADODB.Connection") conPaymentTypes.Open scDSN 'SB S sbCartArr=Session("pcCartSession") If (sbCartArr(1,38)>0) then pcIsSubscription = True strAndSub = "AND (pcPayTypes_Subscription = 1)" Else pcIsSubscription = False strAndSub = "" End if 'SB E pcf_PaymentTypes=1 'SB S if session("customerType")=1 then query="SELECT idPayment FROM paytypes WHERE active=-1 AND gwCode<>50 AND gwCode<>999999 " & strAndSub & ";" else query="SELECT idPayment FROM paytypes WHERE active=-1 AND Cbtob=0 AND gwCode<>50 AND gwCode<>999999 " & strAndSub & ";" end if 'SB E set rs=server.CreateObject("ADODB.RecordSet") set rs=conPaymentTypes.execute(query) if err.number<>0 then set rs=nothing exit function end if PayTypesIndex=Cint(0) if NOT rs.eof then pcv_strTempPaymentOptionValue=rs("idPayment") PayTypesIndex=PayTypesIndex + 1 else set rs=nothing pcf_PaymentTypes=0 end if set rs=nothing if int(PayTypesIndex)=0 then pcf_PaymentTypes=0 end if query="SELECT idPayment FROM paytypes WHERE active=-1 and gwCode=50 " & strAndSub & ";" set rsGoogle=Server.CreateObject("ADODB.Recordset") set rsGoogle=conPaymentTypes.execute(query) if rsGoogle.eof then pcv_intGoogleActive=0 else pcv_intGoogleActive=-1 end if query="SELECT idPayment FROM paytypes WHERE active=-1 and gwCode=999999 " & strAndSub & ";" set rsPayPal=Server.CreateObject("ADODB.Recordset") set rsPayPal=conPaymentTypes.execute(query) if rsPayPal.eof then pcv_intPayPalExpressActive=0 else pcv_intPayPalExpressActive=-1 end if Select Case GatewayName Case "GoogleCheckout":pcv_strPayTypeFilter=(pcv_intGoogleActive=-1) Case "PayPalExp":pcv_strPayTypeFilter=(pcv_intPayPalExpressActive=-1) Case "":pcv_strPayTypeFilter=(pcv_intPayPalExpressActive=-1 OR pcv_intGoogleActive=-1) Case Else:pcv_strPayTypeFilter=(pcv_intPayPalExpressActive=-1 OR pcv_intGoogleActive=-1) End Select if (pcv_strPayTypeFilter) AND pcf_PaymentTypes=0 then pcf_PaymentTypes=0 else pcf_PaymentTypes=1 end if '// Close Private Connection String conPaymentTypes.Close Set conPaymentTypes=nothing End Function Public Function pcf_DiscountedOptions(OriginalOptionsTotal, ProductID, Quantity, CustomerType) '// Dim pcv_intDiscountPerUnit ///// Notes: Dim this variable before this function call to use the value throughout your page. pDiscountPerUnit=0 pDiscountPerWUnit=0 pPercentage=0 pbaseproductonly=0 pcv_intDiscountPerUnit=0 query="SELECT discountPerUnit, percentage, discountPerWUnit, baseproductonly FROM discountsPerQuantity WHERE idProduct="&ProductID&" AND quantityFrom<="&Quantity&" AND quantityUntil>="&Quantity Dim rsDiscountedOptions set rsDiscountedOptions=server.CreateObject("ADODB.RecordSet") set rsDiscountedOptions=conntemp.execute(query) if not rsDiscountedOptions.eof and err.number<>9 then '// There are quantity discounts defined for that quantity and product pDiscountPerUnit=rsDiscountedOptions("discountPerUnit") pDiscountPerWUnit=rsDiscountedOptions("discountPerWUnit") pPercentage=rsDiscountedOptions("percentage") pbaseproductonly=rsDiscountedOptions("baseproductonly") '// )nly factor if the options were included if pbaseproductonly<>"-1" then if pPercentage<>"0" then if CustomerType=1 Then pcv_intDiscountPerUnit=pDiscountPerWUnit else pcv_intDiscountPerUnit=pDiscountPerUnit end if OriginalOptionsTotal= OriginalOptionsTotal - ((pcv_intDiscountPerUnit/100) * OriginalOptionsTotal) end if end if '// if pbaseproductonly<>"-1" then end if if NOT isNumeric(OriginalOptionsTotal) then OriginalOptionsTotal=0 end if pcf_DiscountedOptions=OriginalOptionsTotal '// rsDiscountedOptions=nothing /// Keep this line commented. Close the Obj after the loop. End Function Function pcf_Round(numericValue,decimals) '// Validate Numeric Value If isNULL(numericValue)=True OR numericValue="" Then pcf_Round=0 '// Set the Value to Zero if Validation Fails Exit Function '// Do Not Round... Exit End If If isnumeric(numericValue)=False Then pcf_Round=numericValue '// Restore the Original Value if Validation Fails Exit Function '// Do Not Round... Exit End If '// Perform the Round pcf_Round=round(numericValue, decimals) End Function 'Print last Four Digits of Credit Card in the Invoice Function ShowLastFour(CreditCardNumber) 'Check for Special Characters(Hyphen and Space) in the Credit Card Number CreditCardNumberTemp = CreditCardNumber CreditCardNumber = Replace(CreditCardNumber,"-","") CreditCardNumber = Replace(CreditCardNumber," ","") if IsNumeric(CreditCardNumber) and len(CreditCardNumber)>10 then CreditCardNumber="****" & Right(CreditCardNumber,4) else CreditCardNumber=CreditCardNumberTemp end if ShowLastFour=CreditCardNumber End Function '// Determine Credit Card Type, if possible Function ShowCardType(CreditCardNumber) CreditCardType="Not Available" 'Check for Special Characters(Hyphen and Space) in the Credit Card Number CreditCardNumberTemp = CreditCardNumber CreditCardNumber = Replace(CreditCardNumber,"-","") CreditCardNumber = Replace(CreditCardNumber," ","") if IsNumeric(CreditCardNumber) and len(CreditCardNumber)>10 then 'Check the first two digits first Select Case CInt(Left(CreditCardNumber, 2)) ' 1 Case 34, 37 CreditCardType = "American Express" Case 36 CreditCardType = "Diners Club" Case 38 CreditCardType = "Carte Blanche" Case 51, 52, 53, 54, 55 CreditCardType = "Master Card" Case Else 'None of the above - so check the 'first four digits collectively Select Case CInt(Left(CreditCardNumber, 4)) ' 2 Case 2014, 2149 CreditCardType = "EnRoute" Case 2131, 1800 CreditCardType = "JCB" Case 6011 CreditCardType = "Discover" Case Else 'None of the above - so check the 'first three digits collectively Select Case CInt(Left(CreditCardNumber, 3)) ' 3 Case 300, 301, 302, 303, 304, 305 CreditCardType = "American Diners Club" Case Else 'None of the above - 'so simply check the first digit Select Case CInt(Left(CreditCardNumber, 1)) ' 4 Case 3 CreditCardType = "JCB" Case 4 CreditCardType = "Visa" End Select '4 End Select ' 3 End Select '2 End Select '1 end if ShowCardType=CreditCardType End Function '// To DB #1 Function pcf_SanitizeApostrophe(UserInput) If UserInput<>"" AND NOT isNULL(UserInput) Then pcf_SanitizeApostrophe=replace(UserInput,"'","''") Else pcf_SanitizeApostrophe=UserInput End If End Function '// To DB #2 function removeReplaceSQ(myString) if isNULL(myString) then removeReplaceSQ="" else removeReplaceSQ=replace(myString,"''","'") '// normalize removeReplaceSQ=replace(removeReplaceSQ,"'","''") end if end function '// To Text File function removeSQ(myString) if isNULL(myString) then removeSQ="" else myString=replace(myString,"''","'") '// normalize removeSQ=replace(myString,"""",""") end if end function '// To Print Function pcf_PrintCharacters(UserInput) Dim tempStr tempStr=UserInput If tempStr<>"" AND NOT isNULL(tempStr) Then tempStr=replace(tempStr,"'","''") '// normalize tempStr=replace(tempStr,"''","'") tempStr=replace(tempStr,""","""") if Instr(tempStr,Vbcrlf)>0 then do while Instr(tempStr,Vbcrlf&Vbcrlf)>0 tempStr=replace(tempStr, Vbcrlf&Vbcrlf,Vbcrlf) loop tempStr=replace(tempStr, Vbcrlf," ") end if tempStr=replace(tempStr, Chr(8),"") tempStr=replace(tempStr, Chr(9),"") tempStr=replace(tempStr, Chr(10),"") tempStr=replace(tempStr, Chr(13),"") pcf_PrintCharacters=tempStr Else pcf_PrintCharacters=tempStr End If End Function '// To Email Function pcf_RestoreCharacters(UserInput) Dim tempStr tempStr=UserInput If tempStr<>"" AND NOT isNULL(tempStr) Then tempStr=replace(tempStr,"™","™") tempStr=replace(tempStr,"©","©") tempStr=replace(tempStr,"®","®") pcf_RestoreCharacters=tempStr Else pcf_RestoreCharacters=tempStr End If End Function '// Convert Special Characters To HTML Function pcf_ReplaceCharacters(UserInput) ' NOTES: ' DO NOT add a replace on " (double quotes) because this function is used when saving ' HTML code too (e.g. long product description) and that would break the HTML Dim tempStr tempStr=removeReplaceSQ(UserInput) '// Sanitize UserInput If tempStr<>"" And Not isNull(tempStr) Then tempStr=replace(tempStr,"™","™") tempStr=replace(tempStr,"©","©") tempStr=replace(tempStr,"®","®") pcf_ReplaceCharacters=tempStr Else pcf_ReplaceCharacters=tempStr End If End Function Function pcf_ReplaceQuotes(UserInput) Dim tempStr tempStr=UserInput If tempStr<>"" And Not isNull(tempStr) Then tempStr=replace(tempStr,"""",""") pcf_ReplaceQuotes=tempStr Else pcf_ReplaceQuotes=tempStr End If End Function Function pcf_AddToCart(IdProduct) IF scQuickBuy = "1" THEN '// Feature is inactive pcf_AddToCart=False Exit Function ELSE '// Feature is active If IdProduct<>"" AND NOT isNULL(IdProduct) Then '// Show Add To Cart Button pcf_AddToCart=True '// 1.) PRODUCT FOR SALE: Verify level is 0 OR is 1 with a custmer type of 1 '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// NOTES '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' Check for order level permission "scorderlevel". ' scorderlevel = 0 // everybody ' scorderlevel = 1 // wholesale only ' scorderlevel = 2 // catalog only ' Also check what level the current customer is classified. ' session("customerType") = "" // not logged in ' session("customerType") = 1 // wholesale ' session("customerType") = 0 // retail '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If NOT (scorderlevel = "0" OR pcf_WholesaleCustomerAllowed) Then '// if [everyone] OR [wholesale w/ wholesale only turned on] pcf_AddToCart=False Exit Function End If '// 2.) STOCK CONSIDERATIONS: If out of stock AND out of stock purchase is allowed show button. '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// NOTES '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' The Following Variable Must Be Defined: ' pStock ' pserviceSpec ' pNoStock ' pcv_intBackOrder ' iBTOOutofstockpurchase '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If NOT pcf_OutStockPurchaseAllow Then pcf_AddToCart=False Exit Function End If '// 3.) Product is a BTO product If (pserviceSpec<>0) Then pcf_AddToCart=False Exit Function End If '// 4.) Product has required options (if options are not required, then visiting the product details page is not mandatory) If pcf_CheckForReqOptions(IdProduct)=1 Then pcf_AddToCart=False Exit Function End If '// 5.) Product has required input fields If pcf_CheckForReqInputFields(IdProduct)=1 Then pcf_AddToCart=False Exit Function End If '// 6.) Product has required accessories If pcf_CheckForReqAccessories(IdProduct)=1 Then pcf_AddToCart=False Exit Function End If '// 7.) Product is an Apparel Product '// Does not apply to stores not running the APP Add-on '// 8.) Product has Qty Minimums '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// NOTES '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' Use "pcv_SkipCheckMinQty" to skip the Qty Minimums validation section '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If pcf_CheckMinQty(IdProduct)=1 AND pcv_SkipCheckMinQty<>-1 Then pcf_AddToCart=False Exit Function End If '// 9.) Not for Sale If pFormQuantity="-1" and NotForSaleOverride(session("customerCategory"))=0 Then pcf_AddToCart=False Exit Function End If Else '// If IdProduct<>"" AND NOT isNULL(IdProduct) Then pcf_AddToCart=False Exit Function End If '// If IdProduct<>"" AND NOT isNULL(IdProduct) Then END IF '// Feature is active End Function Public Function pcf_InitializePrototype() If Not (pcv_strPrototype) Then pcv_strPrototype=True pcv_NewLine=CHR(10) pcv_strModal="" pcv_strModal=pcv_strModal&""& pcv_NewLine pcv_strModal=pcv_strModal&""& pcv_NewLine pcf_InitializePrototype = pcv_strModal End If End Function Public Function pcf_ModalWindow(Message, ID, Width) Dim pcv_strModal, pcv_NewLine pcv_NewLine=CHR(10) pcv_strModal="" pcv_strModal=pcv_strModal&""& pcv_NewLine pcv_strModal=""& pcv_NewLine pcv_strModal=pcv_strModal&""& pcv_NewLine
pcv_strModal=pcv_strModal&"
"& pcv_NewLine
pcv_strModal=pcv_strModal&""& pcv_NewLine
pcv_strModal=pcv_strModal&""& pcv_NewLine
pcv_strModal=pcv_strModal&""& pcv_NewLine
pcv_strModal=pcv_strModal&""& pcv_NewLine
pcf_ModalWindow = pcv_strModal
End Function
Sub pcs_GetSubCats(tmpIDParent)
Dim intCount,pcArrSubCat
querySubCat="SELECT idcategory FROM categories WHERE idParentCategory=" & tmpIDParent & ";"
set rsSubCat=connTemp.execute(querySubCat)
if not rsSubCat.eof then
pcArrSubCat=rsSubCat.getRows()
set rsSubCats=nothing
For intCount=0 to ubound(pcArrSubCat,2)
TmpCatList=TmpCatList & "," & pcArrSubCat(0,intCount)
call pcs_GetSubCats(pcArrSubCat(0,intCount))
Next
end if
set rsSubCat=nothing
End Sub
Function pcf_ColumnToArray(pMDA, iCol)
Dim iLoop, Result(), max
max = UBound(pMDA,2)
ReDim Result(max)
For iLoop = 0 To max
Result(iLoop) = pMDA(iCol, iLoop)
Next
pcf_ColumnToArray = Result
End Function
'*****************************************************************************************************
'// START: Add function for ZIP code
'*****************************************************************************************************
Public Function pcf_PostCodes(code)
if len(code)>0 then
code = trim(code)
code = ucase(code)
end if
pcf_PostCodes=code
End Function
'*****************************************************************************************************
'// END: Add function for ZIP code
'*****************************************************************************************************
'*****************************************************************************************************
'// START: Function used to look for admin user in user permission array
'*****************************************************************************************************
Function findUser(ByRef arr, ByVal val, pcArrCount)
findUser=Null
For i=0 To pcArrCount
If CLng(val) = CLng(arr(i)) Then
findUser=i
Exit Function
End If
Next
End Function
'*****************************************************************************************************
'// END
'*****************************************************************************************************
'*****************************************************************************************************
'Get Active Security Key
'*****************************************************************************************************
Function pcs_GetSecureKey()
Dim querygsk,rsGSKObj
querygsk = "SELECT pcSecurityKey FROM pcSecurityKeys WHERE pcActiveKey = 1;"
set rsGSKObj = server.CreateObject("ADODB.RecordSet")
set rsGSKObj = connTemp.execute(querygsk)
if rsGSKObj.eof then
pcv_SecurityPass = scCrypPass
else
pcv_SecurityPass = rsGSKObj("pcSecurityKey")
end if
pcs_GetSecureKey = pcv_SecurityPass
set rsGSKObj=nothing
End Function
Function pcs_GetKeyID()
Dim querygsk,rsGSKObj
querygsk = "SELECT pcSecurityKeyID FROM pcSecurityKeys WHERE pcActiveKey = 1;"
set rsGSKObj = server.CreateObject("ADODB.RecordSet")
set rsGSKObj = connTemp.execute(querygsk)
if rsGSKObj.eof then
pcv_SecurityKeyID = 0
else
pcv_SecurityKeyID = rsGSKObj("pcSecurityKeyID")
end if
pcs_GetKeyID = pcv_SecurityKeyID
set rsGSKObj=nothing
End Function
'*****************************************************************************************************
'Get Active Security Key
'*****************************************************************************************************
'*****************************************************************************************************
'//Get the pcSecurityKey
'*****************************************************************************************************
Function pcs_GetKeyUsed(keyid)
if isNULL(keyid) or keyid&""="" then
keyid = 0
end if
if keyid = 0 then
pcs_GetKeyUsed = scCrypPass
else
query = "SELECT pcSecurityKey FROM pcSecurityKeys WHERE pcSecurityKeyID = "&keyid&";"
set rsGSKObj = server.CreateObject("ADODB.RecordSet")
set rsGSKObj = connTemp.execute(query)
if rsGSKObj.eof then
'redirect
else
pcs_GetKeyUsed = rsGSKObj("pcSecurityKey")
end if
set rsGSKObj = nothing
end if
End Function
'*****************************************************************************************************
'//Get the pcSecurityKey
'*****************************************************************************************************
'*****************************************************************************************************
Function pcf_PurgeCardNumber(CreditCardNumber,keyid)
if isNULL(keyid) or keyid&""="" then
keyid = 0
end if
if keyid = 0 then
sSecurePass = scCrypPass
else
query = "SELECT pcSecurityKey FROM pcSecurityKeys WHERE pcSecurityKeyID = "&keyid&";"
set rsGSKObj = server.CreateObject("ADODB.RecordSet")
set rsGSKObj = connTemp.execute(query)
if rsGSKObj.eof then
'redirect
else
sSecurePass = rsGSKObj("pcSecurityKey")
end if
set rsGSKObj = nothing
end if
tempCC=CreditCardNumber
tempCC=enDeCrypt(tempCC, sSecurePass)
tempfourR=right(tempCC,4)
tempfour="************"&tempfourR
pcf_PurgeCardNumber=enDeCrypt(tempfour, sSecurePass)
End Function
'*****************************************************************************************************
'*****************************************************************************************************
'// Get the Customer Status
'*****************************************************************************************************
Function pcf_GetCustType(CustID)
if CustID="" then CustID=0
query = "SELECT pcCust_Guest FROM customers WHERE idcustomer=" & CustID
set rsCustCType = Server.CreateObject("ADODB.Recordset")
set rsCustCType = conntemp.execute(query)
if NOT rsCustCType.EOF then
pcf_GetCustType = rsCustCType("pcCust_Guest")
else
pcf_GetCustType = ""
end if
set rsCustCType = nothing
End Function
'*****************************************************************************************************
'*****************************************************************************************************
'// Get the Total Discount from Promotions
'*****************************************************************************************************
Function pcf_GetPromoTotal(PromoArr1,PromoIndex)
TotalPromotions=0
For m=1 to PromoIndex
if PromoArr1(m,2)>0 then
TotalPromotions=TotalPromotions+cdbl(PromoArr1(m,2))
end if
Next
pcf_GetPromoTotal = TotalPromotions
End Function
' begin PRV41
'*****************************************************************************************************
'// Format a date for the currently defined database
'*****************************************************************************************************
Function formatDateForDB(varDate)
If IsDate(varDate) then
if scDB="Access" Then
formatDateForDB = "#" & varDate & "#"
Else
formatDateForDB = "'" & varDate & "'"
End If
Else
formatDateForDB = "null"
End If
End function
'*****************************************************************************************************
'*****************************************************************************************************
'// Read a complete text file
'*****************************************************************************************************
Function strReadAll(strFilename)
Dim objFSO, objFile
Set objFSO = server.CreateObject("Scripting.FileSystemObject")
Err.number=0
Set objFile = objFSO.OpenTextFile(strFileName, 1)
strReadAll = objFile.ReadAll()
objFile.close
Set objFile = Nothing
Set objFSO = nothing
End Function
'*****************************************************************************************************
'*****************************************************************************************************
'// simple proper case. if a string is all caps or all lower, forcer to Proper Case
'// (note: does not handle the McGillicuddies and St. Jeans of the world)
'*****************************************************************************************************
Function ProperCase(varString)
If Len(varString)>0 then
If LCase(varString)=varstring Or UCase(varstring)=varstring Then
ProperCase = UCase(Left(varString,1)) & LCase(Mid(varString,2))
Else
ProperCase = varString
End If
End If
End Function
'*****************************************************************************************************
'*****************************************************************************************************
'// Generate a GUID
'*****************************************************************************************************
Function genGUID()
Dim newGuid
newGuid = server.createobject("scriptlet.typelib").guid
' Take the GUID (stripping out the brackets and any extraneous data at the end
newGuid=mid(Left(newGuid,instr(newGuid,"}")-1),2)
genGUID=newGuid
Set newGuid=nothing
end Function
'*****************************************************************************************************
'// Passed what 'should' be a number, return zero if it's null or non-numeric, else return the number
'*****************************************************************************************************
Function fnZeroIfNull(varAny)
fnZeroIfNull = 0
If IsNull(varAny) Then Exit Function
If Len(varAny)=0 Then Exit Function
If IsNumeric(varAny) = False Then Exit Function
fnZeroIfNull = varAny
End function
' end PRV41
'// Replace Comma
'*****************************************************************************************************
function replacecomma(pricenumber)
If IsNumeric(pricenumber) then
if scDecSign="," then
replacecomma=replace(pricenumber,".","")
replacecomma=replace(replacecomma,",",".")
else
replacecomma=replace(pricenumber,",","")
end if
End If
end function
'//Fix Javascript string issues
'*****************************************************************************************************
function FixLang(str)
Dim tmp1
tmp1=str
if tmp1<>"" then
tmp1=replace(tmp1,"\""","""")
tmp1=replace(tmp1,"\'","'")
tmp1=replace(tmp1,"""","\""")
tmp1=replace(tmp1,"'","\'")
end if
FixLang=tmp1
end function
%>
<%
'**************************************************************
'* START - Retrieve Error Handler status from database
'* This variable is set via the Store Settings page
'**************************************************************
Call Opendb()
Dim pcIntErrorHandler
query="SELECT pcStoreSettings_ErrorHandler FROM pcStoreSettings WHERE (((pcStoreSettings_ID)=1));"
set rs=server.CreateObject("ADODB.RecordSet")
set rs=conntemp.execute(query)
pcIntErrorHandler=rs("pcStoreSettings_ErrorHandler")
if pcIntErrorHandler="" then
pcIntErrorHandler=1
end if
set rs=nothing
Call Closedb()
'**************************************************************
'* END - Retrieve Error Handler status from database
'**************************************************************
'log file not yet used
pcStrErrFileName = "#"
'Create an id the customer can use when they call up.
pcStrCustRefID = Session.SessionID & "-" & Hour(Now) & Minute(Now) & Second(Now)
'//do not use yet...
Function LogErrorToFile ()
Dim objFS
Dim objFile
On Error Resume Next
LogError = False
Set objFS = Server.CreateObject ("Scripting.FileSystemObject")
If Err.number = 0 Then
Set objFile = objFS.OpenTextFile (pcStrErrFileName, 8, True)
If Err.number = 0 Then
tErrDescription= Replace(err.description,vbLf,vbCrLf)
objFile.WriteLine "------------------------------------------------------"
objFile.WriteLine "* Error At " & Now
objFile.WriteLine "* CustomerRefID: " & pcStrCustRefID
objFile.WriteLine "* Session ID: " & Session.SessionID
objFile.WriteLine "* Error Number: " & err.number
objFile.WriteLine "* Error Source: " & err.source
objFile.WriteLine "* Error Description: " & tErrDescription
objFile.WriteLine "* RequestMethod: " & Request.ServerVariables("REQUEST_METHOD")
objFile.WriteLine "* ServerPort: " & Request.ServerVariables("SERVER_PORT")
objFile.WriteLine "* HTTPS: " & Request.ServerVariables("HTTPS")
objFile.WriteLine "* LocalAddr: " & Request.ServerVariables("LOCAL_ADDR")
objFile.WriteLine "* HostAddress :" & Request.ServerVariables("REMOTE_ADDR")
objFile.WriteLine "* UserAgent: " & Request.ServerVariables("HTTP_USER_AGENT")
objFile.WriteLine "* URL: " & Request.ServerVariables("URL")
objFile.WriteLine "* FormData: " & Request.Form
objFile.WriteLine "* HTTP Headers: "
objFile.WriteLine "*****************************"
objFile.WriteLine Replace(Request.ServerVariables("ALL_HTTP"),vbLf,vbCrLf)
objFile.WriteLine "*****************************"
objFile.WriteLine "------------------------------------------------------" & vbCrLf
objFile.Close
End If
End If
End Function
Function LogErrorToDatabase()
tErrDescription = Replace(err.description,vbLf,vbCrLf)
if instr(tErrDescription,"SQL") then
else
'// Append the query string for debugging
if query <> "" then
pcv_srtErrDescription = tErrDescription & ""& Message &"
"& pcv_NewLine
pcv_strModal=pcv_strModal&"" & "query=" & query & "
" else pcv_srtErrDescription = tErrDescription end if pcv_srtErrDescription = replace(pcv_srtErrDescription,"'","''") pcv_srtErrDescription = replace(pcv_srtErrDescription,"""","""""") Set conError = Server.CreateObject("ADODB.Connection") Set rstError = Server.CreateObject("ADODB.Recordset") conError.open scDSN if scDB="SQL" then strDtDelim="'" else strDtDelim="#" end if ErrQuery="INSERT INTO pcErrorHandler (pcErrorHandler_SessionID, pcErrorHandler_RequestMethod, pcErrorHandler_ServerPort, pcErrorHandler_HTTPS, pcErrorHandler_LocalAddr, pcErrorHandler_RemoteAddr, pcErrorHandler_UserAgent, pcErrorHandler_URL, pcErrorHandler_HttpHost, pcErrorHandler_HttpLang, pcErrorHandler_ErrNumber, pcErrorHandler_ErrSource, pcErrorHandler_ErrDescription, pcErrorHandler_InsertDate,pcErrorHandler_CustomerRefID) VALUES ('"&Session.SessionID&"','"&Request.ServerVariables("REQUEST_METHOD")&"','"&Request.ServerVariables("SERVER_PORT")&"','"&Request.ServerVariables("HTTPS")&"','"&Request.ServerVariables("LOCAL_ADDR")&"','"&Request.ServerVariables("REMOTE_ADDR")&"','"&Request.ServerVariables("HTTP_USER_AGENT")&"','"&Request.ServerVariables("URL")&"','"&Request.ServerVariables("HTTP_Host")&"','"&Request.ServerVariables("HTTP_ACCEPT_LANGUAGE")&"', '"&err.number&"', '"&err.source&"', '"& pcv_srtErrDescription &"', "&strDtDelim&Date()&strDtDelim&", '"&pcStrCustRefID&"');" Set rstError = Server.CreateObject("ADODB.Recordset") Set rstError = conError.execute(ErrQuery) Set rstError = Nothing conError.close 'If the Error Handler is turned on (1), hide the error. If it's turned off (0), show the error in the browser. if pcIntErrorHandler=0 then response.write "------------------------------------------------------" response.write "* Error At " & Now &"
" response.write "* CustomerRefID: " & pcStrCustRefID &"
" response.write "* Session ID: " & Session.SessionID &"
" response.write "* Error Number: " & err.number &"
" response.write "* Error Source: " & err.source &"
" response.write "* Error Description: " & tErrDescription &"
" if query <> "" then pcv_srtErrDescription=query pcv_srtErrDescription = replace(pcv_srtErrDescription,"'","''") pcv_srtErrDescription = replace(pcv_srtErrDescription,"""","""""") response.write "* Last Query: " & pcv_srtErrDescription &"
" end if response.write "* RequestMethod: " & Request.ServerVariables("REQUEST_METHOD") &"
" response.write "* ServerPort: " & Request.ServerVariables("SERVER_PORT") &"
" response.write "* HTTPS: " & Request.ServerVariables("HTTPS") &"
" response.write "* LocalAddr: " & Request.ServerVariables("LOCAL_ADDR") &"
" response.write "* HostAddress :" & Request.ServerVariables("REMOTE_ADDR") &"
" response.write "* UserAgent: " & Request.ServerVariables("HTTP_USER_AGENT") &"
" response.write "* URL: " & Request.ServerVariables("URL") &"
" response.write "* FormData: " & Request.Form &"
" response.write "* HTTP Headers: " &"
" response.write "*****************************
" response.write Replace(Request.ServerVariables("ALL_HTTP"),vbLf,"
") response.write "*****************************
" response.write "------------------------------------------------------
" response.end end if end if err.clear End Function %> <% 'This file is part of ProductCart, an ecommerce application developed and sold by Early Impact LLC. ProductCart, its source code, the ProductCart name and logo are property of Early Impact, LLC. Copyright 2001-2003. All rights reserved. You are not allowed to use, alter, distribute and/or resell any parts of ProductCart's source code without the written consent of Early Impact. To contact Early Impact, please visit www.earlyimpact.com. Dim pcv_intOptionsExist '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: Are Options '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_CheckForOptions(ID) '//Product ID pcv_str_CheckOptionsID=ID '// CHECK FOR OPTIONS ' TABLES: products, pcProductsOptions, optionsgroups, ptions_optionsGroups query = "SELECT DISTINCT optionsGroups.OptionGroupDesc, pcProductsOptions.pcProdOpt_ID, pcProductsOptions.idOptionGroup, pcProductsOptions.pcProdOpt_Required, pcProductsOptions.pcProdOpt_Order " query = query & "FROM products " query = query & "INNER JOIN ( " query = query & "pcProductsOptions INNER JOIN ( " query = query & "optionsgroups " query = query & "INNER JOIN options_optionsGroups " query = query & "ON optionsgroups.idOptionGroup = options_optionsGroups.idOptionGroup " query = query & ") ON optionsGroups.idOptionGroup = pcProductsOptions.idOptionGroup " query = query & ") ON products.idProduct = pcProductsOptions.idProduct " query = query & "WHERE products.idProduct=" & pcv_str_CheckOptionsID &" " query = query & "AND options_optionsGroups.idProduct=" & pcv_str_CheckOptionsID &" " query = query & "ORDER BY pcProductsOptions.pcProdOpt_Order;" set rsCheckOptions=server.createobject("adodb.recordset") set rsCheckOptions=conntemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rsCheckOptions=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if If NOT rsCheckOptions.eof Then pcf_CheckForOptions=1 Else pcf_CheckForOptions=2 End If set rsCheckOptions = nothing End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: Are Options '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: Required Options '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_CheckForReqOptions(ID) '//Product ID pcv_str_CheckOptionsID=ID '// CHECK FOR REQUIRED OPTIONS ' TABLES: products, pcProductsOptions, optionsgroups, ptions_optionsGroups query = "SELECT DISTINCT optionsGroups.OptionGroupDesc, pcProductsOptions.pcProdOpt_ID, pcProductsOptions.idOptionGroup, pcProductsOptions.pcProdOpt_Required, pcProductsOptions.pcProdOpt_Order " query = query & "FROM products " query = query & "INNER JOIN ( " query = query & "pcProductsOptions INNER JOIN ( " query = query & "optionsgroups " query = query & "INNER JOIN options_optionsGroups " query = query & "ON optionsgroups.idOptionGroup = options_optionsGroups.idOptionGroup " query = query & ") ON optionsGroups.idOptionGroup = pcProductsOptions.idOptionGroup " query = query & ") ON products.idProduct = pcProductsOptions.idProduct " query = query & "WHERE products.idProduct=" & pcv_str_CheckOptionsID &" " query = query & "AND options_optionsGroups.idProduct=" & pcv_str_CheckOptionsID &" " query = query & "ORDER BY pcProductsOptions.pcProdOpt_Order;" set rsCheckOptions=server.createobject("adodb.recordset") set rsCheckOptions=conntemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rsCheckOptions=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if If NOT rsCheckOptions.eof Then pcf_CheckForReqOptions=2 do while not rsCheckOptions.eof if clng(rsCheckOptions("pcProdOpt_Required"))<>0 then pcf_CheckForReqOptions=1 Exit Function end if rsCheckOptions.MoveNext loop Else pcf_CheckForReqOptions=2 End If set rsCheckOptions = nothing End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: Required Options '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: Required Input Fields '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_CheckForReqInputFields(ID) '//Product ID pcv_str_CheckID=ID '// CHECK FOR REQUIRED INPUT FIELDS ' TABLES: products query ="SELECT x1req,x2req,x3req FROM products WHERE idProduct=" & pcv_str_CheckID set rsCheckInput=server.createobject("adodb.recordset") set rsCheckInput=conntemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rsCheckInput=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if If NOT rsCheckInput.eof Then pcf_CheckForReqInputFields=2 if clng(rsCheckInput("x1req"))+clng(rsCheckInput("x2req"))+clng(rsCheckInput("x3req"))<>0 then pcf_CheckForReqInputFields=1 end if Else pcf_CheckForReqInputFields=2 End If set rsCheckInput = nothing End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: Required Input Fields '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: Required Accessories '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_CheckForReqAccessories(ID) '//Product ID IdProduct=ID '// No Required Accessories pcf_CheckForReqAccessories=2 query="SELECT cs_relationships.idproduct, cs_relationships.idrelation, cs_relationships.cs_type, cs_relationships.isRequired, products.servicespec, products.description FROM cs_relationships INNER JOIN products ON cs_relationships.idrelation=products.idProduct WHERE (((cs_relationships.idproduct)="& IdProduct &") AND ((products.active)=-1) AND ((products.removed)=0)) ORDER BY cs_relationships.num,cs_relationships.idrelation;" set rsCheckRequiredAccessories=server.createobject("adodb.recordset") set rsCheckRequiredAccessories=conntemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rsCheckInput=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if If NOT rsCheckRequiredAccessories.EOF Then pcArray_RequiredAccessories=rsCheckRequiredAccessories.GetRows() pcv_intAccessoriesCount=UBound(pcArray_RequiredAccessories,2)+1 End If set rsCheckRequiredAccessories=nothing AccessoriesCnt=Cint(0) do while (AccessoriesCnt < pcv_intAccessoriesCount) cs_pBTOCnt=Cint(0) cs_pOptCnt=Cint(0) cs_pAddtoCart=Cint(0) pidrelation=pcArray_RequiredAccessories(1,AccessoriesCnt) '// rsCheckRequiredAccessories("idrelation") pcsType=pcArray_RequiredAccessories(2,AccessoriesCnt) '// rsCheckRequiredAccessories("cs_type") cs_pserviceSpec=pcArray_RequiredAccessories(4,AccessoriesCnt) '// rsCheckRequiredAccessories("servicespec") pcv_strIsRequiredAccessory=pcArray_RequiredAccessories(3,AccessoriesCnt) '// rsCheckRequiredAccessories("isRequired") AccessoriesCnt=AccessoriesCnt+1 '// CHECK IF THIS PRODUCT HAS AT LEAST ONE ACTIVE CATEGORY pcv_intCategoryActive=1 If Session("customerType")=1 Then pcv_strCSTemp="" else pcv_strCSTemp=" AND pccats_RetailHide<>1 " end if query="SELECT categories_products.idProduct " query=query+"FROM categories_products " query=query+"INNER JOIN categories " query=query+"ON categories_products.idCategory = categories.idCategory " query=query+"WHERE categories_products.idProduct="& pidrelation &" AND iBTOhide=0 " & pcv_strCSTemp & " " query=query+"ORDER BY priority, categoryDesc ASC;" set rsCheckCategory=server.CreateObject("ADODB.RecordSet") set rsCheckCategory=conntemp.execute(query) If rsCheckCategory.eof Then pcv_intCategoryActive=2 End If set rsCheckCategory=nothing '// CHECK FOR REQUIRED OPTIONS pcv_intOptionsExist=pcf_CheckForReqOptions(pidrelation) '// check options function (1=YES, 2=NO) '// CHECK FOR REQUIRED INPUT FIELDS if pcv_intOptionsExist=2 then pcv_intOptionsExist=pcf_CheckForReqInputFields(pidrelation) end if if cs_pserviceSpec=true OR (pcv_intOptionsExist = 1) then If pcv_intOptionsExist = 1 Then cs_pOptCnt=cs_pOptCnt+1 Else cs_pBTOCnt=cs_pBTOCnt+1 End If End If ' If item is either BTO or have options or is within Hidden Category, ' do not require item (bundle) or ' do not require checkbox (accessory) ' as these will not be shown on page if cint(cs_pOptCnt) + cint(cs_pBTOCnt) = 0 then cs_pAddtoCart = 1 end if if ((cs_pAddtoCart=1 AND pcsType<>"Accessory") OR (pcsType="Accessory")) AND (pcv_intCategoryActive=1) then if pcv_strIsRequiredAccessory <> 0 then pcf_CheckForReqAccessories=1 Exit Function end if end if '// Clear Variables cs_pBTOCnt=Cint(0) cs_pOptCnt=Cint(0) cs_pAddtoCart=Cint(0) cs_pserviceSpec="" pidrelation=Cint(0) pcsType="" loop End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: Required Accessories '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: if wholesale allowed, check if customer is also wholesale '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_WholesaleCustomerAllowed if scorderlevel="1" AND session("customerType")=1 then pcf_WholesaleCustomerAllowed = true Else pcf_WholesaleCustomerAllowed = false End If End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: if wholesale allowed, check if customer is also wholesale '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: Check if out of stock purchase allowed '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_OutStockPurchaseAllow If (scOutofStockPurchase=-1 AND CLng(pStock)<1 AND pserviceSpec=0 AND pNoStock=0 AND pcv_intBackOrder=0) OR (pserviceSpec<>0 AND scOutofStockPurchase=-1 AND iBTOOutofstockpurchase=-1 AND CLng(pStock)<1 AND pNoStock=0 AND pcv_intBackOrder=0) Then pcf_OutStockPurchaseAllow = false Else pcf_OutStockPurchaseAllow = true End If End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: Check if out of stock purchase allowed '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' START: QTY Minimums '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Public Function pcf_CheckMinQty(ID) '//Product ID pcv_str_CheckID=ID pcf_CheckMinQty=2 query="SELECT products.pcprod_MinimumQty FROM products WHERE idProduct=" & pcv_str_CheckID & " AND configOnly=0 AND removed=0;" set rsQtyMinimum=server.createobject("adodb.recordset") set rsQtyMinimum=conntemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rsQtyMinimum=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if If NOT rsQtyMinimum.eof Then pcv_lngMinimumQty=rsQtyMinimum("pcprod_MinimumQty") if isNull(pcv_lngMinimumQty) OR pcv_lngMinimumQty="" then pcv_lngMinimumQty="0" end if if pcv_lngMinimumQty <> 0 then pcf_CheckMinQty=1 end if Else pcf_CheckMinQty=2 End If set rsQtyMinimum = nothing End Function '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' END: QTY Minimums '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ %> <% Response.Buffer = True call opendb() %> <% ' findProduct function findProduct(pcCartArray, indexCart, pIdProduct) dim f findProduct=Cint(0) if indexCart>0 then for f=1 to indexCart if pcCartArray(f,10)=0 and int(pcCartArray(f,0))=int(pIdProduct) then findProduct=-1 end if next end if set f=nothing end function 'check for oversized product ' findProduct function oversizecheck(pcCartArray, indexCart) dim f if indexCart>0 then oversizecheck="" for f=1 to indexCart If pcCartArray(f,20)="-1" Then 'response.write "" Else if pcCartArray(f,10)=0 and pcCartArray(f,23)<>"NO" then OSArray=split(pcCartArray(f,23),"||") if ubound(OSArray)>3 then for i=1 to pcCartArray(f,2) oversizecheck=oversizecheck&"1|||"&pcCartArray(f,23)&"||"&pcCartArray(f,6)&"||"&pcCartArray(f,3)&"," next end if end if if pcCartArray(f,16)<>"" then '//Get config info query="SELECT stringProducts, stringPrice, stringQuantity FROM configSessions WHERE idconfigSession="&pcCartArray(f,16)&";" set rsBTOChkObj=server.CreateObject("ADODB.RecordSet") set rsBTOChkObj=conntemp.execute(query) pcv_itemString = rsBTOChkObj(0) pcv_itemPrice = rsBTOChkObj(1) pcv_itemQty = rsBTOChkObj(2) pcv_itemStringArry = split(pcv_itemString,",") pcv_itemPriceArry = split(pcv_itemPrice,",") pcv_itemQtyArry = split(pcv_itemQty,",") for iOSChkCnt=lbound(pcv_itemStringArry) to ubound(pcv_itemStringArry)-1 pcv_tempPrdChk = pcv_itemStringArry(iOSChkCnt) query="SELECT weight, oversizeSpec FROM products WHERE idProduct="&pcv_tempPrdChk&";" set rsOSChkObj=server.CreateObject("ADODB.RecordSet") set rsOSChkObj=conntemp.execute(query) pcv_OSChkWeight=rsOSChkObj(0) pcv_OSChkSpec=rsOSChkObj(1) if pcv_OSChkSpec<>"NO" then for i=1 to pcCartArray(f,2) for iICnt=1 to pcv_itemQtyArry(iOSChkCnt) '//oversized, get array oversizecheck=oversizecheck&"2|||"&pcv_OSChkSpec&"||"&pcv_OSChkWeight&"||"&pcv_itemPriceArry(iOSChkCnt)&"," next next end if next end if End If next end if set f=nothing end function 'If Editing an existing order function eoversizecheck(pcOSCheckOrderNumber) dim f query="SELECT ProductsOrdered.quantity, products.OverSizeSpec, products.weight, ProductsOrdered.idOrder FROM ProductsOrdered INNER JOIN products ON ProductsOrdered.idProduct = products.idProduct WHERE (((ProductsOrdered.idOrder)="&pcOSCheckOrderNumber&"));" set rsOSC=server.CreateObject("ADODB.RecordSet") set rsOSC=connTemp.execute(query) eoversizecheck="" do until rsOSC.eof pcOS_Quantity=rsOSC("quantity") pcOS_OverSizeSpec=rsOSC("OverSizeSpec") pcOS_weight=rsOSC("weight") if pcOS_OverSizeSpec<>"NO" then OSArray=split(pcOS_OverSizeSpec,"||") if ubound(OSArray)>3 then for i=1 to pcOS_Quantity eoversizecheck=eoversizecheck&"1|||"&pcOS_OverSizeSpec&"||"&pcOS_weight&"," next end if end if rsOSC.MoveNext loop set rsOSC=nothing set f=nothing end function ' count cart Rows function countCartRows(pcCartArray, indexCart) dim cont, f cont=Cint(0) if indexCart>0 then for f=1 to indexCart if pcCartArray(f,10)=0 then cont=cont+1 end if next else cont=0 end if countCartRows=cont set f=nothing set cont=nothing end function ' Cart Amount function calculateCartTotal(pcCartArray, indexCart) dim f, total 'SB S Dim subInstArr 'SB E total=0 for f=1 to indexCart if pcCartArray(f,10)=0 then 'SB S If Not (len(pcCartArray(f,38))>0) Then pcCartArray(f,38)=0 if pcCartArray(f,38) > 0 then subInstArr = split(getSubInstallVals(pcCartArray(f,38)),",") else subInstArr = split("0,0,0,0",",") end if 'SB E if pcCartArray(f,16)<>"" then 'SB S if subInstArr(2) = "1" Then '// Trial price no discounts total = total + (pcCartArray(f,2) * cdbl(subInstArr(3))) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) end if 'SB E else 'SB S if subInstArr(2) = "1" Then '// Trial price no discounts total = total + (pcCartArray(f,2)* cdbl(subInstArr(3))) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if 'SB E end if if (pcCartArray(f,27)>"0") AND (pcCartArray(f,28)>"0") then total=total + ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if next calculateCartTotal=total set f=nothing set total=nothing end function ' Cart Ship Amount function calculateShipCartTotal(pcCartArray, indexCart) dim f, total total=0 for f=1 to indexCart if pcCartArray(f,10)=0 AND pcCartArray(f,20)=0 then if pcCartArray(f,16)<>"" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if end if next calculateShipCartTotal=total set f=nothing set total=nothing end function function calculateCategoryDiscounts(pcCartArray, indexCart) Dim TmpProList(100,5) for f=1 to indexCart TmpProList(f,0)=pcCartArray(f,0) TmpProList(f,1)=pcCartArray(f,10) TmpProList(f,3)=pcCartArray(f,2) TmpProList(f,4)=0 if pcCartArray(f,10)=0 then 'Get RowPrice pRowPrice=0 pRowPrice=ccur(pcCartArray(f,2) * pcCartArray(f,17)) pRowPrice=pRowPrice + ccur(pcCartArray(f,2) * pcCartArray(f,5)) if trim(pcCartArray(f,30))<>"" AND trim(pcCartArray(f,30))>"0" then pRowPrice=pRowPrice-pcCartArray(f,30) end if if trim(pcCartArray(f,31))<>"" AND trim(pcCartArray(f,31))>"0" then pRowPrice=pRowPrice+ccur(pcCartArray(f,31)) end if if trim(pcCartArray(f,15))<>"" AND trim(pcCartArray(f,15))>"0" then pRowPrice=pRowPrice-ccur(pcCartArray(f,15)) end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then pRowPrice = ( ccur(pRowPrice) + ccur(TmpProList(cint(pcCartArray(f,27)),2)) ) - ( ( ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28) ) ) * pcCartArray(f,2) ) end if TmpProList(f,2)=pRowPrice end if next ' ------------------------------------------------------ ' START - Calculate category-based quantity discounts ' ------------------------------------------------------ CatDiscTotal=0 query="SELECT pcCD_idCategory as IDCat FROM pcCatDiscounts group by pcCD_idCategory" set rsCDObj=server.CreateObject("ADODB.RecordSet") set rsCDObj=conntemp.execute(query) Do While not rsCDObj.eof CatSubQty=0 CatSubTotal=0 CatSubDiscount=0 For f=1 to indexCart if (TmpProList(f,1)=0) and (TmpProList(f,4)=0) then query="select idproduct from categories_products where idcategory=" & rsCDObj("IDCat") & " and idproduct=" & TmpProList(f,0) set rsCDObjtemp=server.CreateObject("ADODB.RecordSet") set rsCDObjtemp=connTemp.execute(query) if not rsCDObjtemp.eof then CatSubQty=CatSubQty+TmpProList(f,3) CatSubTotal=CatSubTotal+TmpProList(f,2) TmpProList(f,4)=1 end if set rsCDObjtemp=nothing end if Next if CatSubQty>0 then query="SELECT pcCD_discountPerUnit,pcCD_discountPerWUnit,pcCD_percentage,pcCD_baseproductonly FROM pcCatDiscounts WHERE pcCD_idCategory=" & rsCDObj("IDCat") & " AND pcCD_quantityFrom<=" &CatSubQty& " AND pcCD_quantityUntil>=" &CatSubQty set rsCDObjtemp=server.CreateObject("ADODB.RecordSet") set rsCDObjtemp=conntemp.execute(query) if not rsCDObjtemp.eof then ' there are quantity discounts defined for that quantity pDiscountPerUnit=rsCDObjtemp("pcCD_discountPerUnit") pDiscountPerWUnit=rsCDObjtemp("pcCD_discountPerWUnit") pPercentage=rsCDObjtemp("pcCD_percentage") pbaseproductonly=rsCDObjtemp("pcCD_baseproductonly") set rsCDObjtemp=nothing if session("customerType")<>1 then 'customer is a normal user if pPercentage="0" then CatSubDiscount=pDiscountPerUnit*CatSubQty else CatSubDiscount=(pDiscountPerUnit/100) * CatSubTotal end if else 'customer is a wholesale customer if pPercentage="0" then CatSubDiscount=pDiscountPerWUnit*CatSubQty else CatSubDiscount=(pDiscountPerWUnit/100) * CatSubTotal end if end if end if end if CatDiscTotal=CatDiscTotal+CatSubDiscount rsCDObj.MoveNext loop set rsCDObj=nothing '// Round the Category Discount to two decimals if CatDiscTotal<>"" and isNumeric(CatDiscTotal) then CatDiscTotal = Round(CatDiscTotal,2) end if ' ------------------------------------------------------ ' END - Calculate category-based quantity discounts ' ------------------------------------------------------ calculateCategoryDiscounts=CatDiscTotal end function Function CheckTaxEpt(pcv_IDPro,pcv_StateCode) Dim rsD,pcArrayD,intCountD,pcv_mc query="SELECT pcTEpt_StateCode FROM pcTaxEpt WHERE pcTEpt_StateCode='" & pcv_StateCode & "' AND ((pcTEpt_ProductList like '" & pcv_IDPro & ",%') OR (pcTEpt_ProductList like '%," & pcv_IDPro & ",%'))" set rsD=connTemp.execute(query) if not rsD.eof then set rsD=nothing CheckTaxEpt=1 Exit Function end if set rsD=nothing query="SELECT idcategory FROM categories_products WHERE idproduct=" & pcv_IDPro & ";" set rsD=connTemp.execute(query) if not rsD.eof then pcArrayD=rsD.getRows() intCountD=ubound(pcArrayD,2) set rsD=nothing For pcv_mc=0 to intCountD query="SELECT pcTEpt_StateCode FROM pcTaxEpt WHERE pcTEpt_StateCode='" & pcv_StateCode & "' AND ((pcTEpt_CategoryList like '" & pcArrayD(0,pcv_mc) & ",%') OR (pcTEpt_CategoryList like '%," & pcArrayD(0,pcv_mc) & ",%'))" set rsD=connTemp.execute(query) if not rsD.eof then set rsD=nothing CheckTaxEpt=1 Exit Function end if Next end if set rsD=nothing End Function Function CheckTaxEptZone(pcv_IDPro,pcv_ZoneRateID) Dim query, rsD,pcArrayD,intCountD,pcv_mc CheckTaxEptZone=0 query="SELECT pcTaxEpt.pcTaxZoneRate_ID FROM pcTaxEpt WHERE pcTaxEpt.pcTaxZoneRate_ID=" & pcv_ZoneRateID & " AND ((pcTEpt_ProductList like '" & pcv_IDPro & ",%') OR (pcTEpt_ProductList like '%," & pcv_IDPro & ",%'))" set rsD=connTemp.execute(query) if not rsD.eof then set rsD=nothing CheckTaxEptZone=1 Exit Function end if set rsD=nothing query="SELECT idcategory FROM categories_products WHERE idproduct=" & pcv_IDPro & ";" set rsD=connTemp.execute(query) if not rsD.eof then pcArrayD=rsD.getRows() intCountD=ubound(pcArrayD,2) set rsD=nothing For pcv_mc=0 to intCountD query="SELECT pcTaxZoneRate_ID FROM pcTaxEpt WHERE pcTaxZoneRate_ID=" & pcv_ZoneRateID & " AND ((pcTEpt_CategoryList like '" & pcArrayD(0,pcv_mc) & ",%') OR (pcTEpt_CategoryList like '%," & pcArrayD(0,pcv_mc) & ",%'))" set rsD=connTemp.execute(query) if not rsD.eof then set rsD=nothing CheckTaxEptZone=1 Exit Function end if Next end if set rsD=nothing End Function function NontaxableItems(tmpIDConfigSession,parentQty) Dim rs,query,i,tmpResult Dim stringProducts,stringValues,stringCategories,Qstring,Pstring,ArrProduct,ArrValue,ArrCategory,ArrQuantity,ArrPrice Dim TempDiscount,TempD1,QFrom,QTo,DUnit,QPercent,DWUnit tmpResult=0 IF tmpIDConfigSession<>"" AND IsNumeric(tmpIDConfigSession) THEN query="SELECT stringProducts, stringValues, stringCategories,stringQuantity, stringPrice FROM configSessions WHERE idconfigSession=" & tmpIDConfigSession set rs=server.CreateObject("ADODB.RecordSet") set rs=conntemp.execute(query) if not rs.eof then stringProducts=rs("stringProducts") stringValues=rs("stringValues") stringCategories=rs("stringCategories") Qstring=rs("stringQuantity") Pstring=rs("stringPrice") ArrProduct=Split(stringProducts, ",") ArrValue=Split(stringValues, ",") ArrCategory=Split(stringCategories, ",") ArrQuantity=Split(Qstring,",") ArrPrice=split(Pstring,",") set rs=nothing if ArrProduct(0)="na" then else For i=lbound(ArrProduct) to (UBound(ArrProduct)-1) if ArrProduct(i)<>"" then query="SELECT idproduct FROM Products WHERE idproduct=" & ArrProduct(i) & " AND notax<>0;" set rs=connTemp.execute(query) if not rs.eof then tmpResult=tmpResult+ArrQuantity(i)*ArrPrice(i)*parentQty query="select * from discountsPerQuantity where IDProduct=" & ArrProduct(i) set rs=connTemp.execute(query) TempDiscount=0 do while not rs.eof QFrom=rs("quantityFrom") QTo=rs("quantityUntil") DUnit=rs("discountperUnit") QPercent=rs("percentage") DWUnit=rs("discountperWUnit") if (DWUnit=0) and (DUnit>0) then DWUnit=DUnit end if TempD1=0 if (clng(ArrQuantity(i)*parentQty)>=clng(QFrom)) and (clng(ArrQuantity(i)*parentQty)<=clng(QTo)) then if QPercent="-1" then if session("customerType")=1 then TempD1=ArrQuantity(i)*parentQty*ArrPrice(i)*0.01*DWUnit else TempD1=ArrQuantity(i)*parentQty*ArrPrice(i)*0.01*DUnit end if else if session("customerType")=1 then TempD1=ArrQuantity(i)*parentQty*DWUnit else TempD1=ArrQuantity(i)*parentQty*DUnit end if end if end if TempDiscount=TempDiscount+TempD1 rs.movenext loop set rs=nothing tmpResult=tmpResult-TempDiscount end if set rs=nothing end if Next end if end if set rs=nothing END IF NontaxableItems=tmpResult End function function NontaxableZoneItems(tmpIDConfigSession,parentQty,zoneRateID) Dim rs,query,i,tmpResult Dim stringProducts,stringValues,stringCategories,Qstring,Pstring,ArrProduct,ArrValue,ArrCategory,ArrQuantity,ArrPrice Dim TempDiscount,TempD1,QFrom,QTo,DUnit,QPercent,DWUnit tmpResult=0 IF tmpIDConfigSession<>"" AND IsNumeric(tmpIDConfigSession) THEN query="SELECT stringProducts, stringValues, stringCategories,stringQuantity, stringPrice FROM configSessions WHERE idconfigSession=" & tmpIDConfigSession set rs=server.CreateObject("ADODB.RecordSet") set rs=conntemp.execute(query) if not rs.eof then stringProducts=rs("stringProducts") stringValues=rs("stringValues") stringCategories=rs("stringCategories") Qstring=rs("stringQuantity") Pstring=rs("stringPrice") ArrProduct=Split(stringProducts, ",") ArrValue=Split(stringValues, ",") ArrCategory=Split(stringCategories, ",") ArrQuantity=Split(Qstring,",") ArrPrice=split(Pstring,",") set rs=nothing if ArrProduct(0)="na" then else For i=lbound(ArrProduct) to (UBound(ArrProduct)-1) if ArrProduct(i)<>"" then ztest=CheckTaxEptZone(ArrProduct(i),zoneRateID) if ztest=1 then query="SELECT idproduct FROM Products WHERE idproduct=" & ArrProduct(i) else query="SELECT idproduct FROM Products WHERE idproduct=" & ArrProduct(i) & " AND notax<>0;" end if set rs=connTemp.execute(query) if not rs.eof then tmpResult=tmpResult+ArrQuantity(i)*ArrPrice(i)*parentQty query="select * from discountsPerQuantity where IDProduct=" & ArrProduct(i) set rs=connTemp.execute(query) TempDiscount=0 do while not rs.eof QFrom=rs("quantityFrom") QTo=rs("quantityUntil") DUnit=rs("discountperUnit") QPercent=rs("percentage") DWUnit=rs("discountperWUnit") if (DWUnit=0) and (DUnit>0) then DWUnit=DUnit end if TempD1=0 if (clng(ArrQuantity(i)*parentQty)>=clng(QFrom)) and (clng(ArrQuantity(i)*parentQty)<=clng(QTo)) then if QPercent="-1" then if session("customerType")=1 then TempD1=ArrQuantity(i)*parentQty*ArrPrice(i)*0.01*DWUnit else TempD1=ArrQuantity(i)*parentQty*ArrPrice(i)*0.01*DUnit end if else if session("customerType")=1 then TempD1=ArrQuantity(i)*parentQty*DWUnit else TempD1=ArrQuantity(i)*parentQty*DUnit end if end if end if TempDiscount=TempDiscount+TempD1 rs.movenext loop set rs=nothing tmpResult=tmpResult-TempDiscount end if set rs=nothing end if Next end if end if set rs=nothing END IF IF tmpIDConfigSession<>"" AND IsNumeric(tmpIDConfigSession) THEN query="SELECT stringQuantity, stringPrice, stringCProducts, stringCValues, stringCCategories FROM configSessions WHERE idconfigSession=" & tmpIDConfigSession set rs=server.CreateObject("ADODB.RecordSet") set rs=conntemp.execute(query) if not rs.eof then stringProducts=rs("stringCProducts") stringValues=rs("stringCValues") stringCategories=rs("stringCCategories") Qstring=rs("stringQuantity") Pstring=rs("stringPrice") ArrProduct=Split(stringProducts, ",") ArrValue=Split(stringValues, ",") ArrCategory=Split(stringCategories, ",") ArrQuantity=Split(Qstring,",") ArrPrice=split(Pstring,",") set rs=nothing if ArrProduct(0)="na" then else For i=lbound(ArrProduct) to (UBound(ArrProduct)-1) if ArrProduct(i)<>"" then ztest=CheckTaxEptZone(ArrProduct(i),zoneRateID) if ztest=1 then query="SELECT idproduct FROM Products WHERE idproduct=" & ArrProduct(i) else query="SELECT idproduct FROM Products WHERE idproduct=" & ArrProduct(i) & " AND notax<>0;" end if set rs=connTemp.execute(query) if not rs.eof then tmpResult=tmpResult+1*ArrValue(i) end if set rs=nothing end if Next end if end if set rs=nothing END IF NontaxableZoneItems=tmpResult End function ' Cart Taxable Amount function calculateTaxableTotal(pcCartArray, indexCart) Dim f, total,pcv_StateCode,pcv_Country,mtest 'SB S Dim subInstArr 'SB E total=0 If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart mtest=0 if (pcv_StateCode<>"") and (ucase(pcv_Country)="US") then mtest=CheckTaxEpt(pcCartArray(f,0),pcv_StateCode) end if if (pcCartArray(f,10)=0) AND (pcCartArray(f,19)=0) AND (mtest=0) then 'SB S If Not (len(pcCartArray(f,38))>0) Then pcCartArray(f,38)=0 if pcCartArray(f,38) > 0 then subInstArr = split(getSubInstallVals(pcCartArray(f,38)),",") else subInstArr = split("0,0,0,0",",") end if 'SB E if pcCartArray(f,16)<>"" then 'SB S if subInstArr(2) = "1" Then total = total + (pcCartArray(f,2) * cdbl(subInstArr(3))) - NontaxableItems(pcCartArray(f,16),pcCartArray(f,2)) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) - NontaxableItems(pcCartArray(f,16),pcCartArray(f,2)) end if 'SB E else 'SB S If subInstArr(2) = "1" Then total = total + (pcCartArray(f,2) * cdbl(subInstArr(3))) Else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if End If 'SB E end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then total=total + ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if next calculateTaxableTotal=total set f=nothing set total=nothing end function 'SB S function calculateTaxableTotal_SB(pcCartArray, indexCart) Dim f, total,pcv_StateCode,pcv_Country,mtest total=0 If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart mtest=0 if (pcv_StateCode<>"") and (ucase(pcv_Country)="US") then mtest=CheckTaxEpt(pcCartArray(f,0),pcv_StateCode) end if if (pcCartArray(f,10)=0) AND (pcCartArray(f,19)=0) AND (mtest=0) then if pcCartArray(f,16)<>"" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) - NontaxableItems(pcCartArray(f,16),pcCartArray(f,2)) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then total=total + ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if next calculateTaxableTotal_SB=total set f=nothing set total=nothing end function 'SB E ' Cart Taxable Amount function calculateTaxableZoneTotal(pcCartArray, indexCart, zoneRateID) Dim f, total,pcv_StateCode,pcv_Country,mtest total=0 If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart mtest=0 mtest=CheckTaxEptZone(pcCartArray(f,0),zoneRateID) if (pcCartArray(f,10)=0) AND (pcCartArray(f,19)=0) AND (mtest=0) then if pcCartArray(f,16)<>"" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) - NontaxableZoneItems(pcCartArray(f,16),pcCartArray(f,2),zoneRateID) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then total=total + ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if next calculateTaxableZoneTotal=total set f=nothing set total=nothing end function function checkTaxExempt(pcCartArray, indexCart, TaxZoneRateID) Dim f, checkVar, pcv_StateCode, pcv_Country strCheckVar="" If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart if pcCartArray(f,10)=0 AND (pcv_StateCode<>"") and (ucase(pcv_Country)="CA") then strCheckVar=strCheckVar&CheckTaxEptZone(pcCartArray(f,0),TaxZoneRateID)&"," end if next if instr(strCheckVar,"1") then if instr(strCheckVar,"0") then checkVar=0 else checkVar=1 end if else checkVar=0 end if checkTaxExempt=checkVar end function ' Cart Weight function calculateCartWeight(pcCartArray, indexCart) dim f, totalWeight totalWeight=0 for f=1 to indexCart if pcCartArray(f,10)=0 then totalWeight=totalWeight + (pcCartArray(f,6)*pcCartArray(f,2)) end if next if cdbl(totalWeight)>0 AND cdbl(totalWeight)<1 then totalWeight=1 end if totalWeight=round(totalWeight,0) calculateCartWeight=totalWeight set f=nothing set totalWeight=nothing end function ' Cart Weight function calculateShipWeight(pcCartArray, indexCart) dim f, totalWeight totalWeight=0 for f=1 to indexCart if pcCartArray(f,10)=0 AND pcCartArray(f,20)=0 then totalWeight=totalWeight + (pcCartArray(f,6)*pcCartArray(f,2)) end if next if cdbl(totalWeight)>0 AND cdbl(totalWeight)<1 then totalWeight=1 end if totalWeight=round(totalWeight,0) calculateShipWeight=totalWeight set f=nothing set totalWeight=nothing end function ' Cart Surcharge function calculateTotalProductSurcharge(pcCartArray, indexCart) dim f, totalSurcharge dim fQty, fSurcharge1, fSurcharge2 totalSurcharge=0 'Create a new temporary array to group like ProductIDs regardless of option Dim SCArray(100,5) G = Cint(0) for f=1 to indexCart if pcCartArray(f,10)=0 then if G>0 then var_update = 0 for h = 0 to G if SCArray(h,0)=pcCartArray(f,0) then SCArray(h,1)=Cint(SCArray(h,1))+Cint(pcCartArray(f,2)) var_update = 1 end if next if var_update = 0 then SCArray(G,0)=pcCartArray(f,0) SCArray(G,1)=pcCartArray(f,2) SCArray(G,2)=pcCartArray(f,36) SCArray(G,3)=pcCartArray(f,37) end if else SCArray(G,0)=pcCartArray(f,0) SCArray(G,1)=pcCartArray(f,2) SCArray(G,2)=pcCartArray(f,36) SCArray(G,3)=pcCartArray(f,37) end if G = G + 1 end if Next for t=0 to G fQty = SCArray(t,1) 'quantity ordered of product fSurcharge1 = SCArray(t,2) 'Initial Surcharge fSurcharge2 = SCArray(t,3) 'Additional Surcharge totalSurcharge=ccur(totalSurcharge) + ccur(SCArray(t,2)) if fQty > 1 AND fSurcharge2>0 then totalSurcharge=ccur(totalSurcharge) + (ccur(SCArray(t,3))*(CLng(fQty)-1)) end if next calculateTotalProductSurcharge=totalSurcharge set f=nothing set totalSurcharge=nothing end function ' Cart Product Quantity function calculateCartQuantity(pcCartArray, indexCart) dim f, totalQuantity totalQuantity=0 for f=1 to indexCart if pcCartArray(f,10)=0 then totalQuantity=totalQuantity + pcCartArray(f,2) end if next calculateCartQuantity=totalQuantity set f=nothing set totalQuantity=nothing end function 'RP ADDON-S ' Cart Points Rewarded Quantity function calculateCartRewards(pcCartArray, indexCart) dim f, totalQuantity totalQuantity = 0 for f=1 to indexCart if pcCartArray(f,10) = 0 then if (pcCartArray(f,22)="") OR IsNull(pcCartArray(f,22)) then pcCartArray(f,22)=0 end if totalQuantity = totalQuantity + (pcCartArray(f,2) * cdbl(pcCartArray(f,22))) 'BTO Additional Charges Reward Points if (pcCartArray(f,29)<>"") and (pcCartArray(f,29)<>"0") then totalQuantity = totalQuantity + pcCartArray(f,29) end if end if next calculateCartRewards = totalQuantity set f = nothing set totalQuantity = nothing end function 'RP ADDON-E ' Cart Product Quantity function calculateCartShipQuantity(pcCartArray, indexCart) dim f, totalShipQuantity totalShipQuantity=0 for f=1 to indexCart if pcCartArray(f,10)=0 AND pcCartArray(f,20)=0 then totalShipQuantity=totalShipQuantity + pcCartArray(f,2) end if next calculateCartShipQuantity=totalShipQuantity set f=nothing set totalShipQuantity=nothing end function ' Check session lost function checkSessionLost(pcCartArray, pcCartIndex) if pcCartIndex="" then ' session is lost, initialize all variables Session.Timeout=25 Session("idCustomer")=Cint(0) Session("language")=Cstr("english") Session("pcCartIndex")=Cint(0) ReDim pcCartArray(50, 18) Session("pcCartSession")=pcCartArray checkSessionLost=1 else checkSessionLost=0 end if end function '//////////////////////////////////////////////////////////////////////////////////////// '// START: VAT CALCULATIONS '//////////////////////////////////////////////////////////////////////////////////////// '// Removes VAT from UnitPrice when purchased outside the European Union. Function pcf_VAT(Price, ProductID) Dim notax If pcv_IsEUMemberState=1 OR pcv_IsEUMemberState=0 Then notax="-1" If not validNum(ProductID) Then ProductID = 0 End If If ProductID<>0 Then '// Product query="SELECT products.notax FROM products WHERE idProduct=" & ProductID & " AND configOnly=0 AND removed=0 " set rsVAT=server.CreateObject("ADODB.RecordSet") set rsVAT=connTemp.execute(query) If NOT rsVAT.eof Then notax=rsVAT("notax") End If set rsVAT=nothing If ptaxVAT="1" AND notax <> "-1" Then if pcv_IsEUMemberState=0 then pcf_VAT=pcf_RemoveVAT(Price, ProductID) Exit Function else pcf_VAT=Price Exit Function end if Else pcf_VAT=Price Exit Function End If Else '// VAT Item - No Product ID If ptaxVAT="1" Then if pcv_IsEUMemberState=0 then pcf_VAT=pcf_RemoveVAT(Price, ProductID) Exit Function else pcf_VAT=Price Exit Function end if Else pcf_VAT=Price Exit Function End If End If Else '// If pcv_IsEUMemberState=1 OR pcv_IsEUMemberState=0 Then pcf_VAT=Price Exit Function End If End Function '// Removes VAT from Price Function pcf_RemoveVAT(Price,ProductID) pcf_RemoveVAT=Price/(1+pcf_VATRate(ptaxVATRate_Code, ProductID)/100) End Function '// Determines the correct VAT from a Product ID Function pcf_VATRate(StateCode,ProductID) If StateCode="0" OR StateCode="" Then pcf_VATRate=ptaxVATrate '// Default Rate Exit Function Else if not validNum(ProductID) then ProductID = 0 if ProductID="" OR ProductID=0 OR isNULL(ProductID)=True then pcf_VATRate=ptaxVATrate '// Default Rate Exit Function else query="SELECT pcProductsVATRates.pcVATRate_ID, pcVATRates.pcVATRate_Rate, pcVATRates.pcVATRate_ID " query=query&"FROM pcProductsVATRates, pcVATRates " query=query&"WHERE pcProductsVATRates.pcVATRate_ID=pcVATRates.pcVATRate_ID AND pcProductsVATRates.idProduct="&ProductID Set rsVAT=Server.CreateObject("ADODB.Recordset") set rsVAT=connTemp.execute(query) if not rsVAT.eof then pcf_VATRate=rsVAT("pcVATRate_Rate") '// Category Rate else pcf_VATRate=ptaxVATrate '// Default Rate end if set rsVAT=nothing Exit Function end if End If End Function '// Determines if a country is apart of the European Union ' 1 = YES ' 0 = NO ' 2 = Not Applicable Function pcf_IsEUMemberState(CountryCode) pcf_IsEUMemberState=2 If (CountryCode<>"" AND isNULL(CountryCode)=False) Then if (UCASE(CountryCode)=UCASE(scCompanyCountry)) AND ptaxVAT="1" then pcf_IsEUMemberState=1 Exit Function end if End If If ptaxVAT="1" AND (CountryCode<>"" AND isNULL(CountryCode)=False) Then query="SELECT pcVATCountries.pcVATCountry_Code From pcVATCountries WHERE pcVATCountries.pcVATCountry_Code='"&UCASE(CountryCode)&"';" set rsVAT=Server.CreateObject("ADODB.Recordset") set rsVAT=connTemp.execute(query) if not rsVAT.eof then pcf_IsEUMemberState=1 else pcf_IsEUMemberState=0 end if set rsVAT=nothing End If End Function ' Cart VAT Total and Remove VAT function calculateNoVATTotal(pcCartArray, indexCart, TotalStandardDiscount, TotalCategoryDiscount) Dim f, total,pcv_StateCode,pcv_Country,mtest total=0 grandtotal=0 If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart total=0 mtest=0 if (pcv_StateCode<>"") and (ucase(pcv_Country)="US") then mtest=CheckTaxEpt(pcCartArray(f,0),pcv_StateCode) end if if (pcCartArray(f,10)=0) AND (pcCartArray(f,19)=0) AND (mtest=0) then if pcCartArray(f,16)<>"" then total = pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total = pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then total = ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Discount Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// This Line Item represents what % of the Total Discount? Proportional_total = RoundTo((total/ApplicableDisountTotal),.01) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Discount Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Distribute Discounts based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Line Item after discount ApplicableDisount_total = (TotalStandardDiscount * Proportional_total) total = (total - ApplicableDisount_total) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Distribute Discounts based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ if pcv_strrApplicableCategories<>"" then pcArray_ApplicableCategories = split(pcv_strrApplicableCategories, ",") for y=0 to ubound(pcArray_ApplicableCategories)-1 '// For Each Category Discount Available pcArray_ApplicableCategory = split(pcArray_ApplicableCategories(y), chr(124)) tmpApplicableCategoryID = pcArray_ApplicableCategory(1) tmpCategorySubTotal = pcArray_ApplicableCategory(0) ApplicableCategoryItem=False 'response.Write("Category: " & tmpApplicableCategoryID & "
") if pcv_strApplicableProducts <> "" then pcArray_ApplicableProducts = split(pcv_strApplicableProducts, ",") for x=0 to ubound(pcArray_ApplicableProducts)-1 '// Loop through all Products pcArray_ApplicableProduct = split(pcArray_ApplicableProducts(x), chr(124)) tmpProductID = pcArray_ApplicableProduct(0) tmpCategoryID = pcArray_ApplicableProduct(1) 'response.Write("Product: " & tmpProductID & " - " & pcCartArray(f,0) & "
") if (tmpProductID = pcCartArray(f,0)) AND (tmpCategoryID = tmpApplicableCategoryID) then '// This Product is Applicable to this Category ApplicableCategoryItem=True 'response.Write("Hit: " & tmpCategorySubTotal & "
") end if next end if '// if pcv_strApplicableProducts <> "" then If ApplicableCategoryItem=True AND tmpCategorySubTotal>0 Then '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Category Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// This Line Item represents what % of the Total Category? ProportionalCat_total = RoundTo((total/tmpCategorySubTotal),.01) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Category Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Distribute Category based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Line Item after Category ApplicableCatDisount_total = (TotalCategoryDiscount * ProportionalCat_total) total = (total - ApplicableCatDisount_total) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Distribute Category based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ End If next end if '// if pcv_strrApplicableCategories<>"" then total = pcf_RemoveVAT(total, pcCartArray(f,0)) grandtotal = grandtotal + total next calculateNoVATTotal=grandtotal set f=nothing set total=nothing end function ' Cart VAT Total function calculateVATTotal(pcCartArray, indexCart, TotalStandardDiscount, TotalCategoryDiscount) Dim f, total,pcv_StateCode,pcv_Country,mtest total=0 grandtotal=0 If trim(pcStrShippingStateCode)<> "" then pcv_StateCode=trim(pcStrShippingStateCode) else If trim(pcStrBillingStateCode)<> "" then pcv_StateCode=trim(pcStrBillingStateCode) End if end if if trim(pcStrShippingCountryCode)<>"" then pcv_Country=trim(pcStrShippingCountryCode) else if trim(pcStrBillingCountryCode)<>"" then pcv_Country=trim(pcStrBillingCountryCode) end if end if for f=1 to indexCart total=0 mtest=0 if (pcv_StateCode<>"") and (ucase(pcv_Country)="US") then mtest=CheckTaxEpt(pcCartArray(f,0),pcv_StateCode) end if if (pcCartArray(f,10)=0) AND (pcCartArray(f,19)=0) AND (mtest=0) then if pcCartArray(f,16)<>"" then total = pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - (pcCartArray(f,15)+pcCartArray(f,30)) +pcCartArray(f,31) else if pcCartArray(f,15)<>"0" then total=total + pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,17)) - pcCartArray(f,15) else total = pcCartArray(f,2)*(pcCartArray(f,5)+pcCartArray(f,3)) end if end if if (pcCartArray(f,27)>0) AND (pcCartArray(f,28)>0) then total = ( ((ccur(pcCartArray(f,28)) + ccur(pcCartArray(cint(pcCartArray(f,27)),28))) * -1) * pcCartArray(f,2)) end if end if '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Discount Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// This Line Item represents what % of the Total Discount? Proportional_total = RoundTo((total/ApplicableDisountTotal),.01) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Discount Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Distribute Discounts based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Line Item after discount ApplicableDisount_total = (TotalStandardDiscount * Proportional_total) total = (total - ApplicableDisount_total) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Distribute Discounts based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ if pcv_strrApplicableCategories<>"" then pcArray_ApplicableCategories = split(pcv_strrApplicableCategories, ",") for y=0 to ubound(pcArray_ApplicableCategories)-1 '// For Each Category Discount Available pcArray_ApplicableCategory = split(pcArray_ApplicableCategories(y), chr(124)) tmpApplicableCategoryID = pcArray_ApplicableCategory(1) tmpCategorySubTotal = pcArray_ApplicableCategory(0) ApplicableCategoryItem=False 'response.Write("Category: " & tmpApplicableCategoryID & "
") if pcv_strApplicableProducts <> "" then pcArray_ApplicableProducts = split(pcv_strApplicableProducts, ",") for x=0 to ubound(pcArray_ApplicableProducts)-1 '// Loop through all Products pcArray_ApplicableProduct = split(pcArray_ApplicableProducts(x), chr(124)) tmpProductID = pcArray_ApplicableProduct(0) tmpCategoryID = pcArray_ApplicableProduct(1) 'response.Write("Product: " & tmpProductID & " - " & pcCartArray(f,0) & "
") if (tmpProductID = pcCartArray(f,0)) AND (tmpCategoryID = tmpApplicableCategoryID) then '// This Product is Applicable to this Category ApplicableCategoryItem=True 'response.Write("Hit: " & tmpCategorySubTotal & "
") end if next end if '// if pcv_strApplicableProducts <> "" then If ApplicableCategoryItem=True AND tmpCategorySubTotal>0 Then '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Category Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// This Line Item represents what % of the Total Category? ProportionalCat_total = RoundTo((total/tmpCategorySubTotal),.01) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Category Distribution % '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Start: Distribute Category based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// Line Item after Category ApplicableCatDisount_total = (TotalCategoryDiscount * ProportionalCat_total) total = (total - ApplicableCatDisount_total) '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ '// End: Distribute Category based off % above '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ End If next end if '// if pcv_strrApplicableCategories<>"" then grandtotal = grandtotal + total next calculateVATTotal=grandtotal set f=nothing set total=nothing end function '//////////////////////////////////////////////////////////////////////////////////////// '// END: VAT CALCULATIONS '//////////////////////////////////////////////////////////////////////////////////////// '//////////////////////////////////////////////////////////////////////////////////////// '// START: (Re)check stock levels of current cart '//////////////////////////////////////////////////////////////////////////////////////// function checkCartStockLevels(pcCartArray, indexCart, aryBads) Dim intCCSLindex, intCCSLcounter, intCCSLfound Dim strCCSLSQL, strCCSLWarn Dim aryCCSLitems, aryCCSLids Dim objCCSLrs ' Initialize the 'bads' array (an array tied to the index of pcCartArray, indicating which lines are bad) ReDim aryBads(indexCart) ' If cart configuration allows purchasing out-of-stock items, we're all done here If scOutofstockpurchase=0 Then Exit Function ReDim aryCCSLitems(1,0) intCCSLcounter = -1 strCCSLwarn = "" for intCCSLIndex=1 to indexCart intCCSLfound = -1 ' Init to -1 indicating 'not found' if pcCartArray(intCCSLindex,10)=0 then ' If this product has not been deleted from cart, then intCCSLcounter = intCCSLcounter + 1 ReDim preserve aryCCSLitems(1, intCCSLcounter) aryCCSLitems(0,intCCSLcounter) = pcCartArray(intCCSLindex, 0) aryCCSLitems(1,intCCSLcounter) = pcCartArray(intCCSLindex, 2) End If Next ' If there were no viable items found in the cart array (e.g. all were deleted?) then exit now If intCCSLcounter = -1 Then Exit Function ' Unspool/Serialize the idProducts in the array ReDim aryCCSLids(intCCSLcounter) For intCCSLindex=0 to intCCSLcounter aryCCSLids(intCCSLIndex) = aryCCSLitems(0, intCCSLindex) Next strCCSLSQL = "SELECT idproduct, stock, Description, noStock, pcProd_BackOrder FROM products WHERE idproduct in (" & Join(aryCCSLids, ",") & ") and noStock=0 and pcProd_BackOrder=0" Set objCCSLrs = connTemp.execute(strCCSLSQL) If objCCSLrs.eof Then objCCSLrs.close Set objCCSLrs = Nothing Exit Function Else aryCCSLrecs = objCCSLrs.getrows() End If objCCSLrs.close Set objCCSLrs = Nothing ReDim aryBads(UBound(aryCCSLitems,2)) For intCCSLindex=0 to UBound(aryCCSLitems,2) aryBads(intCCSLindex) = 0 ' Flag this line as OK (for now) For intCCSLindex2 = 0 To UBound(aryCCSLrecs, 2) If CLng(aryCCSLitems(0, intCCSLindex)) = CLng(aryCCSLrecs(0, intCCSLindex2)) Then If CLng(aryCCSLitems(1, intCCSLindex)) > CLng(aryCCSLrecs(1, intCCSLindex2)) Then ' Is overstock! strCCSLwarn = strCCSLwarn & ("
- " & strCCSLwarn & "
"&dictLanguage.Item(Session("language")&"_titles_3")&" : "&dictLanguage.Item(Session("language")&"_titles_5")&"") end if End If end If 'check for wholesale customer recalculation%> <% END IF ELSE Response.Cookies("SavedCartGUID")="" END IF call closedb() END IF %> <%END IF%>
|
||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||
 |
||||||||||||||||||||||||||||||||||||||||||||||||||
