Pour utiliser le profil de caissier pour la cassette pour SET - MIA (Merchant Initiated Authorization) avec une carte d'achat, dans une base de données Oracle, procédez comme suit :
<!--
<SelectStatement id="1" allowMultiples="true" >
SELECT PARTNUMBER, SHORTDESCRIPTION, integer(QUANTITY) as INT_QUANTITY, RTRIM(QUANTITYMEASURE) as QTYMEASURE, integer(PRICE*{currency_factor}) as UNITCOST,
integer( (TOTALPRODUCT+TAXAMOUNT+SHIPCHARGE+SHIPTAXAMOUNT+TOTALADJUSTMENT) * {facteur_devise}) as TOTALCOST
FROM orderitems, catentry, catentship, catentdesc
WHERE orders_id = {IDcommande}
AND orderitems.catentry_id = catentry.catentry_id
AND orderitems.catentry_id = catentship.catentry_id
AND orderitems.catentry_id = catentdesc.catentry_id
AND catentdesc.language_id = {ID_langue_acheteur}
</SelectStatement>-->
<SelectStatement id="1" allowMultiples="true" >
SELECT PARTNUMBER, SHORTDESCRIPTION, round(QUANTITY) as INT_QUANTITY, RTRIM(QUANTITYMEASURE) as QTYMEASURE, round(PRICE*{facteur_devise}) as UNITCOST,
round( (TOTALPRODUCT+TAXAMOUNT+SHIPCHARGE+SHIPTAXAMOUNT+TOTALADJUSTMENT) * {facteur_devise}) as TOTALCOST
FROM orderitems, catentry, catentship, catentdesc
WHERE orders_id = {IDcommande}
AND orderitems.catentry_id = catentry.catentry_id
AND orderitems.catentry_id = catentship.catentry_id
AND orderitems.catentry_id = catentdesc.catentry_id
AND catentdesc.language_id = {ID_langue_acheteur}
</SelectStatement>
Remarque : Il n'est pas nécessaire d'arrêter WebSphere Commerce Server pour mettre à jour le profil.
![]() |