Re: [mv] Transaction tracking?

[Scott Benson <scott@rant.tzo.com>]

******    message to minivend-users from Scott Benson <scott@rant.tzo.com>     ******

That is  basically how I got it to work for me. I have a seperate table that I created in the
database (I am using MySQL) that gets populated through some SQL tags in etc/report:

[sql type=set base=ordertracking interpolate=1]
insert into ordertracking
values
('[value mv_order_number]',
'[total-cost]',
CURDATE(),
"pending",
"",
"",
'[data session username]'
)
[/sql]

and then can be queried through more SQL tags from a modified query/check_orders.html

I haven't quite gotten everything ironed out but it appears to be working ok.

Scott

Gideon van Gelder wrote:

> ******    message to minivend-users from "Gideon van Gelder" <gideon@swingmaster.nl>     ******
>
> Hi,
>
> Let me help you,
>
> for some users, transactions.gdbm needs to be exported first, to
> transactions.raw, because this doesn't happen automatically sometimes.
>
> However, you'll notice that in 3.X, this feature doesn't work for
> orders with multiple items.
>
> So, what you need to do, is export the transactions-database, and
> rewrite the order-history-page. I advise you to make two databases,
> in one you set which user placed which order, as the default is, but
> now: create another db, in which you set the information about the order
> itself, item-qty etc. You can accomplish this by just slightly rephrasing
> mike's original code, simlpy use seperate db's and you'll get it to work:
> I have, and it works beautifully.
> However, you might find this a little tough if
> you're not a experienced Minivendor.
>
> Ciao,
>
> -Gideon
>
> > ******    message to minivend-users from orienell
> <orienell@5thelement.com>     ******
> >
> > I have been trying to figure out how to enable transaction logging so
> > users can check the status of their order. I am setting up the simple
> > sample system that comes with minivend but modifying the look of the
> > pages. The sample has a link created in the leftside page that links to
> > pages/query/check_orders.html. This page looks for the file
> > transactions.raw which I find in the products directory, but can't seem
> > to find any documentation on how to enable this feature?
> >
> > I am trying to modify the sample because I'm not a very good programmer.
> >
> > Thanks
> >
> > Brian
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list