[TYPO3-commerce] commerce_couponss

[Ralf Merz]

Hi Roland,

thanx for your mails. First of all, yeah, there is still some bad code 
in this extension. Sorry for that!

Now let´s go over your questions:

robelix schrieb:
> A quick Follow-up after some more testing:
> 
> First of all two quick fixes to get rid of some BE-errors:
> 
> 1) in ext_tables.sql
> 
> 	order_id varchar(80) DEFAULT '' NOT NULL,
> 
> has to be added to the table tx_commercecoupons_coupons
> 
> 2) in class.tx_commercecoupons_fields.php in the function related_article
> 
> 	$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*',
> 'tx_commercecoupons_articles', 'coupon_id='.$cUid);
> 
> needs to be changed to:
> 
> 	$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*',
> 'tx_commercecoupons_articles', 'coupon_id=\''.$cUid.'\'');

Ok. I see.
> 
> 
> 
> I found out, that the syscoupon_special works mostly as expected - At
> least this one shows up in the basket. But I still don't understand why
> three diffrent types. Is there just some code missing in the hooks - or
> is this going to be "something completely diffrent"

There are three types:
- coupon with money or percent amount: You enter a code and get 5 EUR or 
10% from the basket sum. Should work so far.

- coupon with articles: You enter a code and can get an amount of money 
or percent plus an article, for example a small bottle of sparkling wine 
(Piccolo, as we Germans say)

- coupon as article: you can buy a coupon. That means you put one into 
the basket, order it, ckeckout and then get a coupon code, which you can 
send as a gift to a friend.

So, these are the three coupon types. Is it now clearer?

> 
> And I still don't understand the diffrence between coupons with articles
> and coupons without. Is this going to be something like selling coupons
> in shop? (A feature I don't need - the coupons are only prizes of a game)

As I mentioned above, so both is possible. The selling coupons feature 
is rudimentary.

> 
> Finally, I expected the coupon to be moved to the "used" folder - Ok,
> they cannot be used a second time, so it's just to keep an overview in
> the BE.

Well, the BE structure has to be changed a bit, maybe. At the moment, 
the coupons stay in the folder where they are created. Nothing will be 
moved automatically.
The only thing wich changes is the number of coupons, if you don´t set 
them as unlimited.

I hope I could help a bit. This week, time runs short. But I´ll try to 
give answers.
> 
> 
> Roland
> 


-- 
--
Greetings
Ralf Merz

Heindl Internet AG
Tübingen , Germany
ralf.merz at heindl.de