// we want to add full sub inventory output to the getWebGeneralInventory method date 6/13/19 branch name = elt-add-subs-to-getWebGeneralInventory to do: - alter the code on the web/webApi/getwebgeneralinventory.cfm page done - alter the code on the shop/webComponents/adilasWeb.cfc - "getWebGeneralInventory" method getWebGeneralInventory corpKeyId flagSearch - "yes" seems to be the only value that does anything. It also seems to be tied to the aruments.partIdList pageNumber partCategoryId partIdList - default of "". May contain a list of part id's to filter or limit the search to. Other filters may still be used, but this limits things based on part id or a list of part id's. partNumber storeId showPerPage showUnlimited subInventorySaleType webCategoryBuffer webHideInventory - qGetCorpParts part_id, inventory_type_id - create a list of part id's "tempPartId_list" - get all of the quickPartQuantity - method call - qGetSubTotals sums sub qty as qty, part_id, sub_reference_id - qGetSubDisabledTotals sums sub qty as qty, part_id, sub_reference_id - set a counter "disabledQty" - override the and set "tempPartId_list" to blank - looping over a qty check - check for unlimited - check for web buffers - grab the sub quantities - recheck buffers - set some record counts - figure out total pages - figure out start and end values (pagination) - create a new part id list based off of the pagination "partId_list" - qGetWebInventory main query - pretty big with lots of aliases - add the sub inventory stuff... (new project) - qGetSubTotals sums sub qty as qty, sub_reference_id, part_id - qGetSubDisabledTotals sums sub qty as qty, sub_reference_id, part_id - qGetPartPhotos photo stuff - set the outbound pieces adilasStatus mainMessage secondMessage qGetWebInventory qGetSubTotals qGetSubDisabledTotals qryGetPossibleSubInventory qryGetLimitedSubAttributes qGetTextSubValues qGetNumericSubValues qGetDateSubValues allInventoryPartId_list startValue endValue totalRecords totalPages - update the documentation and go through the whole thing... it seems like some of the documentation was done a while ago and has not been updated. - as a note, sometime i use qSomething and other times i use qrySomething. for this one... use the qSomething to keep it standard. x CORP_IMAGE_FOLDER x END_VALUE x QRY_GENERAL_INVENTORY_ARRAY x CORPID x INVENTORYTYPEID x MARKEDUPPRICE x PARTCATEGORYBUFFER x PARTCATEGORYID x PARTCATEGORYNAME x PARTCOST x PARTDESCRIPTION x PARTID x PARTMARKUP x PARTNUMBER x PARTSALEPRICE x PARTWEIGHT x PHOTOCOUNT x PHOTOLIST x PRICESETTINGSHORT x PRICESETTINGTEXT x RFIDTAGNUMBER x SMART_GROUP_COUNT x SMART_GROUP_OPTIONS x BUTTON_COLOR x BUTTON_NAME x BUTTON_RULES_ARRAY x ITEM_PRICE x PRICE_PER_ITEM x RULE_END x RULES-START x CART_FAVORITE_ID x CUSTOMER_TYPE_ID x CUSTOMER_TYPE_NAME x SUB_CHILD_INVENTORY_ARRAY x SUB_ATTRIBUTES x ATTRIBUTE_COLUMN x ATTRIBUTE_ID x ATTRIBUTE_NAME x ATTRIBUTE_TYPE x ATTRIBUTE_VALUE x SUB_BAR_CODE x SUB_COST x SUB_DESCRIPTION x SUB_DISABLED x SUB_ID x SUB_PRICE x SUB_QTY x SUB_RFID x TIME_ID x TAXCATEGORYID x THUMBNAIL x UOMDESCRIPTION x UOMINITIALS x USEMARKUP x VENDORPAYEEID x WEBPRICE x WEBPRICESETTINGID x WEB_ALTERNATE_MESSAGE x WEB_LONG_DESCRIPTION x WEB_RELATED_PARTS x WEB_REVIEWS x WEB_SPECS x WEB_VIDEO_LINK RET_MAIN_MESSAGE RET_SECOND_MESSAGE RET_STATUS RET_TYPE x START_VALUE x TOTAL_PAGES x TOTAL_RECORDS /////////////////////////////////////////////