[FogBugz #79] Mise en cache language_produit #141
Loading…
Reference in New Issue
There is no content yet.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?
Assigned To: CLOSED
Project: CAISSE
Area: awcaisse
Category: Bogue
Priority: Ce serait bien !
Event ID: 361
Date: 2013-02-13T13:01:29Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist
Event ID: 360
Date: 2013-02-13T13:01:29Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
Event ID: 291
Date: 2013-02-06T08:33:43Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
/* Formatted on 06/02/2013 09:16:02 (QP5 v5.191) */
SELECT language_produit.id_produit AS a4741,
language_produit.code AS a4742,
language_produit.nom AS a4743,
language_produit.troc_axe1 AS a4744,
language_produit.troc_axe2 AS a4745,
language_produit.troc_axe3 AS a4746,
language_produit.troc_axe4 AS a4747,
language_produit.messagecentrale AS a4748
FROM language_produit
INNER JOIN (SELECT produit_stock_quantite.id_produit,
produit_stock.id_structure,
SUM (produit_stock_quantite.quantite) AS qte
FROM produit_stock_quantite
INNER JOIN produit_stock
ON produit_stock_quantite.id_structure = produit_stock.id_structure
AND produit_stock_quantite.id_stock = produit_stock.id_stock
INNER JOIN param_type_stock
ON produit_stock.id_type_stock = param_type_stock.id_type_stock AND param_type_stock.disponible = 1
WHERE (param_type_stock.disponible = 1) AND (produit_stock_quantite.id_structure = 5)
GROUP BY produit_stock_quantite.id_produit, produit_stock.id_structure) tmp
ON tmp.id_produit = language_produit.id_produit AND tmp.qte > 0
INNER JOIN structure
ON structure.langue = language_produit.code AND structure.id_structure = 5
WHERE 1 = 1
UNION
SELECT language_produit.id_produit AS a4741,
language_produit.code AS a4742,
language_produit.nom AS a4743,
language_produit.troc_axe1 AS a4744,
language_produit.troc_axe2 AS a4745,
language_produit.troc_axe3 AS a4746,
language_produit.troc_axe4 AS a4747,
language_produit.messagecentrale AS a4748
FROM language_produit
INNER JOIN catalogue_ligne
ON catalogue_ligne.id_catalogue IN (SELECT isnull (s.id_catalogue_hors_stock, d.id_catalogue_hors_stock)
FROM structure s LEFT JOIN distributeur d ON d.id_distrib = s.id_distrib
WHERE id_structure = 5)
AND catalogue_ligne.id_produit = language_produit.id_produit
INNER JOIN structure
ON structure.langue = language_produit.code AND structure.id_structure = 5
WHERE 1 = 1
UNION
SELECT language_produit.id_produit AS a4741,
language_produit.code AS a4742,
language_produit.nom AS a4743,
language_produit.troc_axe1 AS a4744,
language_produit.troc_axe2 AS a4745,
language_produit.troc_axe3 AS a4746,
language_produit.troc_axe4 AS a4747,
language_produit.messagecentrale AS a4748
FROM language_produit
INNER JOIN
produit
ON produit.id_produit = language_produit.id_produit AND produit.id_type_produit NOT IN (1, 12)
INNER JOIN structure on structure.langue = language_produit.code AND structure.id_structure = 5
WHERE 1 = 1
Event ID: 290
Date: 2013-02-05T16:13:10Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
toutes les langues se mettent en cache et il manque a priori des ID_PRODUIT
Event ID: 289
Date: 2013-02-05T16:12:40Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist
Event ID: 288
Date: 2013-02-05T16:12:40Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist