[interchange-cvs] interchange - edl modified 6 files
interchange-cvs at icdevgroup.org
interchange-cvs at icdevgroup.org
Thu Dec 4 13:57:34 EST 2003
User: edl
Date: 2003-12-04 18:57:34 GMT
Modified: dist/lib/UI/pages/admin commerce.html customer_view.html
Modified: entry.html item_option_phantom.html order_view.html
Modified: tax.html
Log:
Added table= parameter to [query ...] tag in these files.
Revision Changes Path
2.2 +3 -1 interchange/dist/lib/UI/pages/admin/commerce.html
rev 2.2, prev_rev 2.1
Index: commerce.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/commerce.html,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -r2.1 -r2.2
--- commerce.html 14 Jan 2003 02:25:50 -0000 2.1
+++ commerce.html 4 Dec 2003 18:57:34 -0000 2.2
@@ -157,7 +157,9 @@
</tr>
<tr>
-[query list=1
+[query
+ list=1
+ table=country
sql="select code,name,tax from state where country = '[value taxcountry]'"
]
<tr>
2.13 +4 -3 interchange/dist/lib/UI/pages/admin/customer_view.html
rev 2.13, prev_rev 2.12
Index: customer_view.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/customer_view.html,v
retrieving revision 2.12
retrieving revision 2.13
diff -u -r2.12 -r2.13
--- customer_view.html 6 Nov 2003 19:55:34 -0000 2.12
+++ customer_view.html 4 Dec 2003 18:57:34 -0000 2.13
@@ -21,6 +21,7 @@
[perl tables=country]### pre-open database for calcs below[/perl]
[query list=1
+ table=userdb
prefix=loop
sql="select * from userdb where username = '[cgi customer]'"]
<table width="100%" border="0" cellspacing="0" cellpadding="0">
@@ -44,7 +45,7 @@
<td width="25%" nowrap class="block4bold">
[L]Total Sales[/L]:
- [query arrayref=totals sql=|
+ [query arrayref=totals table=transactions sql=|
SELECT total_cost,status
FROM transactions
WHERE username = '[loop-code]'
@@ -325,7 +326,7 @@
<td width="14%" class=rhead style="padding: 5px; text-align: right">[L]Subtotal[/L]</td>
<td width="14%" class=rhead style="padding: 5px; text-align: right">[L]Total[/L]</td>
</tr>
-[query list=1 sql="select * from transactions where username = '[loop-param username]'"]
+[query list=1 table=transactions sql="select * from transactions where username = '[loop-param username]'"]
<tr class="[sql-alternate 2]rowalt[else]rownorm[/else][/sql-alternate]">
<td style="padding: 5px">[page href="admin/order_status"
form="order=[sql-code]"
@@ -393,4 +394,4 @@
<!-- ----- END REAL STUFF ----- -->
@_UI_STD_FOOTER_@
-<!-- page: @@MV_PAGE@@ version: $Id: customer_view.html,v 2.12 2003/11/06 19:55:34 mheins Exp $ -->
+<!-- page: @@MV_PAGE@@ version: $Id: customer_view.html,v 2.13 2003/12/04 18:57:34 edl Exp $ -->
2.15 +1 -0 interchange/dist/lib/UI/pages/admin/entry.html
rev 2.15, prev_rev 2.14
Index: entry.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/entry.html,v
retrieving revision 2.14
retrieving revision 2.15
diff -u -r2.14 -r2.15
--- entry.html 17 Jun 2003 21:31:00 -0000 2.14
+++ entry.html 4 Dec 2003 18:57:34 -0000 2.15
@@ -148,6 +148,7 @@
[comment] Get previous order numbers for possible repeat [/comment]
[if value customer_id]
[query
+ table=transactions
sql="
select order_number from transactions
where username = '[value customer_id]'
2.2 +1 -0 interchange/dist/lib/UI/pages/admin/item_option_phantom.html
rev 2.2, prev_rev 2.1
Index: item_option_phantom.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/item_option_phantom.html,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -r2.1 -r2.2
--- item_option_phantom.html 18 Aug 2002 08:09:05 -0000 2.1
+++ item_option_phantom.html 4 Dec 2003 18:57:34 -0000 2.2
@@ -142,6 +142,7 @@
return;
[/perl]
[query
+ table=options
list=1
hashref=master
sql="SELECT * FROM options
2.17 +2 -2 interchange/dist/lib/UI/pages/admin/order_view.html
rev 2.17, prev_rev 2.16
Index: order_view.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/order_view.html,v
retrieving revision 2.16
retrieving revision 2.17
diff -u -r2.16 -r2.17
--- order_view.html 20 Nov 2003 22:11:31 -0000 2.16
+++ order_view.html 4 Dec 2003 18:57:34 -0000 2.17
@@ -318,7 +318,7 @@
<td width="14%" class=rhead style="padding: 5px; text-align: right">[L]Unit Price[/L]</td>
<td width="14%" class=rhead style="padding: 5px; text-align: right">[L]Total[/L]</td>
</tr>
-[query list=1 sql="select * from orderline where order_number = '[loop-code]'"]
+[query list=1 table=orderline sql="select * from orderline where order_number = '[loop-code]'"]
<tr class="[sql-alternate 2]rowalt[else]rownorm[/else][/sql-alternate]" valign=top>
<td style="padding: 5px">[page href="admin/order_status"
form="order=[loop-code]"
@@ -435,4 +435,4 @@
<!-- ----- END REAL STUFF ----- -->
@_UI_STD_FOOTER_@
-<!-- page: @@MV_PAGE@@ version: $Id: order_view.html,v 2.16 2003/11/20 22:11:31 edl Exp $ -->
+<!-- page: @@MV_PAGE@@ version: $Id: order_view.html,v 2.17 2003/12/04 18:57:34 edl Exp $ -->
2.4 +1 -0 interchange/dist/lib/UI/pages/admin/tax.html
rev 2.4, prev_rev 2.3
Index: tax.html
===================================================================
RCS file: /var/cvs/interchange/dist/lib/UI/pages/admin/tax.html,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -r2.3 -r2.4
--- tax.html 14 Nov 2003 18:09:47 -0000 2.3
+++ tax.html 4 Dec 2003 18:57:34 -0000 2.4
@@ -159,6 +159,7 @@
<tr>
[query list=1
+ table=state
sql="select code,name,tax from state where country = '[value taxcountry]'"
]
<tr>
More information about the interchange-cvs
mailing list