[Skip to main content](#vessel-content)

#   \[Réso\]Remplacer "\*\*\*"

##

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago -  12 years 7 months ago [\#115633](#115633) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  *[\[Réso\]Remplacer "\*\*\*"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115633 "&#42;&#42;&#42;&#42;&#42;&#42;")* was created by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")*

******

Last edit: 12 years 7 months ago by [testy60](/forum/user/13963-testy60 "View testy60's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 3 months ago [\#115644](#115644) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115644 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Bonjour,

A vrai dire ces deux éléments n'ont pas grand chose à voir, il est néanmoins possible si vous avez de bonnes bases en php et html d'afficher ce genre de chose.
Pour ça il faut que vous alliez dans Affichage&gt;Vues et que vous éditiez le fichier gauge du dashboard.
A partir de là, le chiffre affiché est stocké dans la variable php $this-&gt;widget-&gt;average
En revanche je ne suis pas sur que ce soit la valeur que vous recherchiez (à savoir le total des dons).
Enfin, l'affichage en front-end n'est pas prévu par ces widgets, je vous conseillerais donc plutôt au final de faire votre propre module.
La récupération des ventes sur un mois n'est pas compliqué (je peux vous donner la requête si besoin) et l'affichage ne dépendra que de votre barre de progression.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago -  12 years 7 months ago [\#115646](#115646) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[\*\*\*](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115646 "&#42;&#42;&#42;&#42;&#42;&#42;")*

***

Last edit: 12 years 7 months ago by [testy60](/forum/user/13963-testy60 "View testy60's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 3 months ago [\#115649](#115649) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115649 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Voici un example de requête:
Code:

SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON prod.order_id = a.order_id WHERE a.order_type='sale' AND prod.product_id IN ('3') AND a.order_created &gt; 1372148201 AND a.order_created &lt; 1374740201 GROUP BY a.order_currency_id

Le "3" correspond à l'id du produit dont vous voulez connaitre les ventes.
Les nombres 1372148201 et 1374740201 correspondent à un timestamp des dates de début et fin de mois. Vous pouvez obtenir ces dates avec ces deux lignes php: Code:

$currentDate=hikashop_getDate($widget-&gt;widget_params-&gt;end,'%m,%d,%Y'); $previousMonthStart=explode(',',$currentDate); $previousMonthEnd=explode(',',$currentDate); //One month Earlier $previousMonthStart[0]=$previousMonthStart[0]-1; $previousMonthStart[1]=1; //First day of previous month $previousMonthEnd[1]=1; //First day of current month $start= mktime(0, 0, 0, $previousMonthStart[0], $previousMonthStart[1], $previousMonthStart[2]); $end= mktime(0, 0, 0, $previousMonthEnd[0], $previousMonthEnd[1], $previousMonthEnd[2])-1;

(ce code vous donne le premier et le dernier jour du mois en cours).
En esperant que vous vous en sortiez avec ces informations ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago [\#115675](#115675) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115675 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Merci beaucoup,

Ca devrait le faire je pense.
Je vous montrerais le résultat.

Bon courage ![:)](/media/kunena/emoticons/3.png ":)").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago [\#115879](#115879) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115879 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Pour les personnes qui souhaitent nous développer le truc (commercial) c'est part ici : [ www.hikashop.com/fr/forum/9-commercial-j...frontend.html#115788](http://www.hikashop.com/fr/forum/9-commercial-jobs/85783-realiser-une-barre-de-progression-en-frontend.html#115788)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago -  12 years 7 months ago [\#115982](#115982) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "J\*\*\*\*"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#115982 "&#42;&#42;&#42;&#42;&#42;&#42;")*

****

Last edit: 12 years 7 months ago by [testy60](/forum/user/13963-testy60 "View testy60's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 3 months ago [\#116005](#116005) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#116005 "&#42;&#42;&#42;&#42;&#42;&#42;")*

GÉNIAL !!!

Je retire ce que j'ai dit votre code fonctionne nickel !!

Waouh je suis heureux ![:)](/media/kunena/emoticons/3.png ":)")

Le problème venait de l'ID du produit il faut prendre l'ID des caractéristique et non pas du produit.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile")
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

13 years 2 months ago [\#117751](#117751) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#117751 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Pour ce projet qui a ete résolu par l utilisation d un module de rendu utilisant SQL .
Quels sont les critères qui amènent le développeur à implémenter / choisir telle ou telle extension ?
C'est une question plus sur joomla que hikashop mais bon ..........

Quel est par ordre croissant de complexité les noms des extensions si cela a un sens ( Module Plugin Component ) ?
Ceux ci peuvent ils avoir des relations entre eux / intérragir ?

Merci

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 2 months ago [\#117837](#117837) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#117837 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Lionel75, je n'ai pas compris...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 2 months ago [\#117858](#117858) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#117858 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Bonjour,

Je dois avouer que nous non plus.

Cordialement,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile")
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

13 years 2 months ago [\#117954](#117954) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#117954 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Cela n'a pas trop d importance .....La réponse me viendra en implémentant un module et un plugin . Cet exercice me permettra de comprendre le contexte de leurs utilisations ( a quels problèmes ils répondent) , leurs différences !

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 2 months ago -  13 years 2 months ago [\#118013](#118013) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#118013 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Bonjour,

Avec le code SQL que ma gentiment donné Eliot, est ce que vous pouvez me donner la requête pour avoir la même chose (le total des ventes d'une période) MAIS avoir uniquement le montant total pour les commandes avec le status "confirmée" (pour exclure les commandes annulé).

Merci beaucoup ![:)](/media/kunena/emoticons/3.png ":)")

Last edit: 13 years 2 months ago by [testy60](/forum/user/13963-testy60 "View testy60's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 2 months ago [\#118015](#118015) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#118015 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Code:

SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON prod.order_id = a.order_id WHERE a.order_type='sale' AND prod.product_id IN ('3') AND a.order_status = 'confirmed' GROUP BY a.order_currency_id

I think that it's what you need, you can change "confirmed" by the desired order status.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 2 months ago [\#118020](#118020) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#118020 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Xavier, je n'ai pas essayé ton code mais c'est bon j'ai trouvé il fallait tout simplement modifié le "Sale" en "confirmed" :
Code:

SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON prod.order_id = a.order_id WHERE a.order_status='confirmed' AND prod.product_id IN ('1') AND a.order_created &gt; 1372148201 AND a.order_created &lt; 1374740201 GROUP BY a.order_currency_id

![:-)](/media/kunena/emoticons/3.png ":-)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[testy60](/forum/user/13963-testy60 "View testy60's Profile")**
- [![testy60's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13963-testy60 "View testy60's Profile") Topic Author
- [ Offline](/forum/user/13963-testy60)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 2 months ago -  12 years 7 months ago [\#118024](#118024) by [testy60](/forum/user/13963-testy60 "View testy60's Profile")  Replied by *[testy60](/forum/user/13963-testy60 "View testy60's Profile")* on topic *[Remplacer "Jauge" par "Barre de progression"](/forum/5-support-en-francais-french-support-/85746-reso-remplacer#118024 "&#42;&#42;&#42;&#42;&#42;&#42;")*

Si vous voulez voir ce que ça donne c'est ça ![:-)](/media/kunena/emoticons/3.png ":-)") :

Last edit: 12 years 7 months ago by [testy60](/forum/user/13963-testy60 "View testy60's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUtc3VwcG9ydC1lbi1mcmFuY2Fpcy1mcmVuY2gtc3VwcG9ydC0vODU3NDYtcmVtcGxhY2VyLXFqYXVnZXEtcGFyLXFiYXJyZS1kZS1wcm9ncmVzc2lvbnE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.170 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
