VbzCart/docs/queries/discarded: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(qryRstkReq_wItem_info)
m (Woozle moved page VbzCart/VbzCart/queries/discarded to VbzCart/docs/queries/discarded without leaving a redirect: part 2)
 
(7 intermediate revisions by one other user not shown)
Line 1: Line 1:
==v_items==
==More Recent==
===Details===
The pages for these still need to be moved:
* '''Used by''': clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.
* {{l/vc/query|qryCat_Items}} - no longer even works
===SQL===
* {{l/vc/query|qryItms_to_restock_w_info}} - wasn't even migrated to current server
<section begin=sql /><mysql>CREATE OR REPLACE VIEW `v_items` AS
* {{l/vc/query|qryCtg_Titles_active}}
  SELECT
* {{l/vc/query|qryCtg_src}}
    i.ID,
* {{l/vc/query|qryCtg_src_sub}}
    i.CatNum,
* {{l/vc/query|qryItems_needed_forStock}}
    i.isForSale,
* {{l/vc/query|qryRstkItms_active}}
    i.isMaster,
** {{l/vc/query|qryRstkItms_expected}}
    i.qtyInStock,
*** {{l/vc/query|qryRstkItms_expected_byItem}} - grouped by ID_Item
    i.isInPrint,
* {{l/vc/query|qryStk_History}} - combined current stock history and {{l/vc/table|stk_history_legacy}} data
    i.isCloseOut,
* {{l/vc/query|qryStock_containers}} - generated IDS codes
    i.isPulled,
* {{l/vc/query|qryStock_forOpenOrders}}
    i.isDumped,
* {{l/vc/query|qryStock_byOpt_andType}}
    i.ID_Title,
* {{l/vc/query|qryStock_by_Opt_Type}}
    i.ID_ItTyp,
* {{l/vc/query|qryStock_by_Supp_Type_Opt}} - unused (and should be Supp_Opt_Type)
    i.ID_ItOpt,
* {{l/vc/query|qryStock_Titles_most_recent}}
    i.ItOpt_Descr,
* {{l/vc/query|qryStkItms_for_sale_wItem_data}}
    i.ID_ShipCost,
* {{l/vc/query|qryStk_byItem_byBin_wInfo}} - adds information to {{l/vc/query|qryStk_byItem_byBin}}
    i.PriceBuy,
 
    i.PriceSell,
==Older==
    i.PriceList,
* [[/v_items]]
    i.Supp_CatNum,
* [[/qryRstkReq_wItem_info]]
    io.Sort AS OptSort
* [[/qryCbx_Restocks_byStatus]]
  FROM (
* [[/qryCbx_Restocks_byPurchOrd]]
    `cat_items` AS `i` LEFT JOIN
* [[/qryCbx_Restocks]]
    `cat_ioptns` AS `io` ON
      ((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>
<section end=sql />
==qryRstkReq_wItem_info==
===Details===
* '''Status''': not being used
* '''History''':
** '''2008-11-21''' Created for new restock process
** '''2008-12-03''' officially abandoned
===SQL===
<mysql>CREATE OR REPLACE VIEW qryRstkReq_wItem_info AS
SELECT
  rqi.*,
  i.ID_Title,
  r.WhenCreated,
  r.WhenOrdered
FROM
  (rstk_req_item AS rqi
  LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)
  LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>

Latest revision as of 01:55, 25 February 2024

More Recent

The pages for these still need to be moved:

Older

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/discarded&oldid=6726"