allow in-place editing of product option names
[bse.git] / site / cgi-bin / bse.cfg
CommitLineData
2eca61d5
TC
1[site]
2name=SomeSite
b19047a6
TC
3; url should not include a trailing /
4url=http://your.site.base
5secureurl=$(url)
2eca61d5 6
4ef01459
TC
7[basic]
8randomdata = /dev/urandom
9168c88c 9access_control=0
4ef01459 10
2eca61d5
TC
11[paths]
12; the following needs to be set to a path writable by the BSE processes
13downloads = /somewhere
3c32512d 14siteuser_images = $(paths/downloads)
efcc5a30 15dynamic_cache=$(paths/downloads)/../cache
2eca61d5
TC
16
17[pregenerate]
18
19; the following are required by the system - don't modify them
3fb296b8
TC
20user/editbooking.tmpl = user,user/base_editbooking.tmpl
21user/bookingdetail.tmpl = user,user/base_bookingdetail.tmpl
22user/cancelbooking.tmpl = user,user/base_cancelbooking.tmpl
23user/bookinglist.tmpl = user,user/base_bookinglist.tmpl
ab2cd916 24user/orderdetail.tmpl = user,user/base_orderdetail.tmpl
4ef01459
TC
25user/alreadyblacklisted.tmpl = user,user/alreadyblacklisted_base.tmpl
26user/blacklistdone.tmpl = user,user/blacklistdone_base.tmpl
27user/cantunsub.tmpl = user,user/cantunsub_base.tmpl
28user/confirmed.tmpl = user,user/confirmed_base.tmpl
29user/confsent.tmpl = user,user/confsent_base.tmpl
2a295ea9 30user/confsent_nop.tmpl = user,user/confsent_nop_base.tmpl
4ef01459 31user/email_conferror.tmpl = user,user/email_conferror_base.tmpl
2eca61d5 32user/logon.tmpl = user,user/logon_base.tmpl
2eca61d5 33user/lostemailsent.tmpl = user,user/lostemailsent_base.tmpl
4ef01459 34user/lostpassword.tmpl = user,user/lostpassword_base.tmpl
2eca61d5 35user/lostpwdemail.tmpl = user,user/lostpwdemail_base.tmpl
2a295ea9 36user/nopassword.tmpl = user,user/nopassword_base.tmpl
4ef01459 37user/options.tmpl = user,user/options_base.tmpl
2a295ea9 38user/options_saved.tmpl = user,user/options_saved_base.tmpl
9063386f 39user/options_billing.tmpl = user,user/options_billing_base.tmpl
3c32512d 40user/options_images.tmpl = user,user/options_images_base.tmpl
4ef01459 41user/register.tmpl = user,user/register_base.tmpl
b19047a6 42user/toomany.tmpl = user,user/toomany_base.tmpl
4ef01459 43user/toosoon.tmpl = user,user/toosoon_base.tmpl
531fb3bc
TC
44user/unsuball.tmpl = user,user/unsuball_base.tmpl
45user/unsubone.tmpl = user,user/unsubone_base.tmpl
4ef01459 46user/userpage.tmpl = user,user/userpage_base.tmpl
d49667a2
TC
47user/userpage_wishlist.tmpl = user,user/base_userpage_wishlist.tmpl
48user/wishlist.tmpl = user,user/base_wishlist.tmpl
0eb78304
TC
49user/bookseminar.tmpl = user,user/base_bookseminar.tmpl
50user/bookconfirm.tmpl = user,user/base_bookconfirm.tmpl
51user/bookcomplete.tmpl = user,user/base_bookcomplete.tmpl
5af99440 52user/redirect.tmpl = user,user/base_redirect.tmpl
ee6577c3
TC
53interest/confirm.tmpl = interest,interest/confirm_base.tmpl
54interest/askagain.tmpl = interest,interest/askagain_base.tmpl
55interest/error.tmpl = interest,interest/error_base.tmpl
a5e3fc4b
TC
56formmail/defquery.tmpl = formmail,formmail/defquery_base.tmpl
57formmail/defdone.tmpl = formmail,formmail/defdone_base.tmpl
c2096d67 58error.tmpl = error,error_base.tmpl
0c2e7f7a
TC
59tellafriend/form.tmpl = user,tellafriend/base_form.tmpl
60tellafriend/done.tmpl = user,tellafriend/base_done.tmpl
2eca61d5
TC
61
62[user settings]
63title = My $(site/name)
64
ee6577c3
TC
65[interest settings]
66title = $(site/name) Interest Registration
67
a5e3fc4b
TC
68[formmail settings]
69title = Send us a comment
70
c2096d67
TC
71[error settings]
72title = Error
57d988af 73dynamic = 0
c2096d67 74
2eca61d5
TC
75[messages]
76user/notyourorder = Order $1 isn't your order
721cd24c 77shop/fileitems = You have products in your cart that include downloadable files. Please logon or register before checking out.
6e3d2da5 78shop/logonrequired = This site requires that you be logged on to make a purchase. Please logon or register before checking out.
2eca61d5 79
2404a911
TC
80[downloads]
81; if true, an order must be marked paid for before the user can download
82; the files attached to the products
83;must_be_paid = yes
84; if true, an order must be marked filled before the user can download the
85; files attached to the products
86;must_be_filled = yes
721cd24c
TC
87
88[children of 5]
89template=common/sidebar.tmpl
90template_dirs=sidebar
b19047a6
TC
91
92[extra tags]
b19047a6 93siteUrl = $(site/url)
2a295ea9
TC
94siteName = $(site/name)
95; You can add any static tag definitions you like here
96; salesEmail = someone@yoursite.com
97; salesPhoneNo = 61 2 9999 8888
531fb3bc
TC
98
99[datadump]
100# where to email the data dump
101#to = someone@somewhere
102# program to run to do the dump
103# must take the same parameters as mysqldump
d09682dd 104#mysqldump = /usr/local/mysql/bin/mysqldump
531fb3bc
TC
105
106[subscriptions]
107# if override is non-zero then the fields for the archiving and templates
108# will be available when sending a subscription
109override=1
110
ca9aa2bf
TC
111[level names]
1120=Your Site
918735d1
TC
1131=Page Lev1
1142=Page Lev2
1153=Page Lev3
1164=Page Lev4
1175=Page Lev5
ca9aa2bf
TC
118
119[articles]
120shop=3
caa7299c 121
08123550
TC
122[shop]
123payment_types=0,1,2
124address1=First address line in configuration
125address2=Second address line in configuration
126address3=Third address line in configuration
7b81711b 127enabled=1
d49f56a6
TC
128display_billAddress=Billing Address
129display_name1=First Name
130display_name2=Last Name
131display_address=Address
08123550 132
caa7299c
TC
133[level 1]
134template=common/default.tmpl
135
136[level 2]
137template=common/default.tmpl
138
139[level 3]
140template=common/default.tmpl
141
142[level 4]
143template=common/default.tmpl
144
145[level 5]
146template=common/default.tmpl
147
148[catalogs]
149template=catalog.tmpl
150
151[products]
152template=shopitem.tmpl
08123550 153
cc9019d1
TC
154[templates]
155admin/edit_2=admin/edit_1
156admin/edit_3=admin/edit_1
157admin/edit_4=admin/edit_1
158admin/edit_5=admin/edit_1
159admin/edit_img=admin/article_img
160admin/edit_file=admin/filelist
161
2076966c
TC
162; this used to be handled via the edit target, but since CVS sucks
163; I won't rename the template
164admin/users/view_orders=admin/users/edit_orders
165
08123550 166[Global permissions]
de193691
TC
167change_body = 8
168change_body_no_shop = 9
169full_access = 0
170full_access_no_shop = 3
08123550 171shop_access = 1
de193691
TC
172shop_orders = 5
173subscriptions = 4
174users_and_groups = 6
6555857d
TC
175confirm_members = 12
176manage_members = 13
08123550
TC
177
178[Article permissions]
de193691 179change_body_doc = 2
7b81711b 180change_body_decendants = 10
de193691 181full_access_doc = 7
7b81711b 182full_access_decendants = 11
08123550 183
de193691
TC
184[permission change_body]
185brief=Title & body (Site)
186help=The user has permission to change only the title & body of all articles or products.
187permissions=edit_field_edit_body,edit_field_edit_title,edit_save
08123550 188descendants=1
de193691 189articles=-1
08123550 190
de193691
TC
191[permission change_body_no_shop]
192brief=Title & body except shop admin
193help=The user has permission to change only the title & body of all
194articles except for the shop.
abf5bbc6 195permissions=edit_field_edit_body,edit_field_edit_title,edit_save
de193691
TC
196descendants=1
197articles=not(3)
08123550 198
de193691
TC
199[permission full_access]
200brief=Full access (Site)
201help=Full access to the article. The user can modify all modifiable fields, delete and add articles at will.
7dd6ebae 202permissions=edit_*,regen_*,bse_*
08123550 203descendants=1
de193691 204articles=-1
08123550 205
de193691
TC
206[permission full_access_no_shop]
207brief=Full access except shop admin
208help=The user has complete access to all articles except for the shop.
209permissions=edit_*,regen_*
08123550 210descendants=1
de193691
TC
211articles=not(3)
212
213[permission shop_access]
214brief=Shop administration
215help=The user has complete access to catalogs or products in the shop.
9168c88c 216permissions=not(admin_*)
de193691
TC
217descendants=1
218articles=3
08123550 219
de193691
TC
220[permission shop_orders]
221brief=Shop orders management
222help=The user can view the order list, order details, and mark orders filled.
223permissions=shop_order_*
da6bc286 224articles=-1
da6bc286 225
de193691
TC
226[permission subscriptions]
227brief=Subscriptions management
228help=The user can create, edit and send subscriptions.
229permissions=subs_*
da6bc286 230articles=-1
da6bc286
TC
231
232[permission users_and_groups]
da6bc286 233brief=User/Group management
de193691 234help=The user can manage users, groups and their permissions.
da6bc286 235permissions=admin_*
de193691
TC
236articles=-1
237
238[permission change_body_doc]
239brief=Title & body (Article)
240help=The user has permission to change only the title & body of this
241article or product.
242permissions=edit_field_edit_body,edit_field_edit_title,edit_save
243
7b81711b
TC
244[permission change_body_decendants]
245brief=Title & body (Article + Decendants)
246help=The user has permission to change only the title & body of this article or product and it's decendants.
247permissions=edit_field_edit_body,edit_field_edit_title,edit_save
248descendants=1
249
de193691
TC
250[permission full_access_doc]
251brief=Full access (Article)
252help=Full access to the article. The user can modify all modifiable
253fields for this article or product.
254permissions=edit_*,regen_*
da6bc286 255
7b81711b
TC
256[permission full_access_decendants]
257brief=Full access (Article + Decendants)
258help=Full access to the article and it's decendants. The user can modify all modifiable fields for this article or product.
259permissions=edit_*,regen_*
260descendants=1
918735d1 261
6555857d
TC
262[permission confirm_members]
263brief=Confirm member email address
264help=The user can manually mark a members email address as confirmed.
265permissions=bse_members_confirm
266articles=-1
267
268[permission manage_members]
269brief=Member management
270help=The user can manage site members
271permissions=bse_members_user_*,bse_members_group_*
272articles=-1
273
918735d1 274[article flags]
3f36e485
TC
275A=Disallow browser caching (default, dynamic articles only)
276B=Allow browser caching (dynamic articles only)
277C=Don't index this article or it's descendants
278F=Descendants inherit Always Dynamic
918735d1 279I=Index even if hidden
cc9019d1 280N=Don't index even if listed
efcc5a30 281R=Regenerate even if we're using JIT regen (dynamic pages only)
918735d1
TC
282
283[article 1]
284extra_templates=index.tmpl
285
286[article 2]
287extra_templates=index2.tmpl
b553afa2
TC
288
289[reports]
290sales_summ_by_product=Sales Summary By Product
291product_sales_over_time=Product Sales Over Time
2d873eb6
TC
292monthly_sales=Monthly Sales
293quarterly_sales=Quarterly Sales
294weekly_sales=Weekly Sales
295yearly_sales=Yearly Sales
296total_sales=Total Sales
297users_vs_orders=Users vs Orders
9063386f 298user_products=Products bought by User
988d8721 299bse_test=Test report
b553afa2
TC
300
301[report sales_summ_by_product]
2d873eb6 302sql1=select pr.articleId as "Id", ar.title as "Product", count(*) as "Units" from article ar, product pr, order_item oi where ar.id = pr.articleId and pr.articleId = oi.productId group by pr.articleId, ar.title
9063386f
TC
303sql1link1=<a href="/cgi-bin/admin/report.pl?s_show=1&r=product_sales_over_time&p1=${Id}">Sales Over Time</a>
304sql1link2=<a href="/cgi-bin/admin/add.pl?id=${Id}">Edit</a>
9615cff6
TC
305sort1=-Units;By Unit from highest;order by 3 desc
306sort2=+Units;By Unit;order by 3
307sort3=+Product;Product name;order by 2
308sort4=-Product;Reverse product name;order by 2 desc
b553afa2
TC
309
310[report product_sales_over_time]
2d873eb6 311sql1=select year(od.orderDate) as "Year", month(od.orderDate) as "Month", count(*) as 'Units' from order_item oi, orders od where oi.orderId = od.id and productId = ? group by year(od.orderDate), month(od.orderDate) order by 1 DESC, 2 DESC
650a6188 312sql1params=1
b553afa2 313param1=product,Product
9615cff6
TC
314sort1=-Year;Reverse time order;order by 1 desc, 2 desc
315sort2=+Year;Time order;order by 1 asc, 2 asc
316sort3=-Units;By units desc;order by 3 desc
317sort4=+Units;By units asc;order by 3 asc
b553afa2 318
2d873eb6
TC
319[report weekly_sales]
320sql1=select year(od.orderDate) as "Year", week(od.orderDate) as "Week", count(*) as 'Orders', format(sum(od.total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join site_users su on od.userId =su.userId group by year(od.orderDate), week(od.orderDate) order by 1 DESC, 2 DESC
321
322[report monthly_sales]
323sql1=select year(od.orderDate) as "Year", month(od.orderDate) as "Month", format(sum(od.total)/100.0,2) as 'Total', count(*) as 'Count', count(su.userId) as 'User Registered' from orders od left join site_users su on od.userId = su.userId group by year(od.orderDate), month(od.orderDate) order by 1 DESC, 2 DESC
324
325[report quarterly_sales]
326sql1=select year(od.orderDate) as "Year", quarter(od.orderDate) as "Quarter", format(sum(od.total)/100.0,2) as 'Total', count(*) as 'Count' from orders od group by year(od.orderDate), quarter(od.orderDate) order by 1 DESC, 2 DESC
327
328[report yearly_sales]
329sql1=select year(od.orderDate) as "Year", count(*) as "Orders",format(sum(od.total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join site_users su on od.userId = su.userId group by year(od.orderDate) order by 1 DESC
330
331[report total_sales]
332sql1=select count(*) as "Orders", format(sum(total)/100.0,2) as '$ Total', count(su.userId) as 'Logon Orders' from orders od left join site_users su on od.userId = su.userId
333
334[report user_products]
335sql1=select pr.title, count(*) as 'Count' from orders od, order_item oi, article pr, site_users su where oi.orderId = od.id and oi.productId = pr.id and su.userId = od.userId and su.id = ? group by pr.id
9063386f
TC
336sql1params=1
337param1=site_user,User
2d873eb6
TC
338
339[report users_vs_orders]
340sql1=select delivFirstName as "First Name", delivLastName as "Last Name", userId as "Logon", format(sum(total)/100.0,2) as '$ Total', count(*) as "Orders" from orders group by delivFirstName, delivLastName order by 5 DESC, 2
341
b553afa2
TC
342[report datatype product]
343type=sql
344sql=select ar.id as "id", ar.title as "label" from article ar, product pr where ar.id = pr.articleId order by 2
650a6188
TC
345novalues=[ You don't have any products ]
346
347[report datatype article]
348type=sql
349sql=select id, concat(title, ' (', id, ')') as "label" from article
77804754 350
2d873eb6
TC
351[report datatype site_user]
352type=sql
353sql=select id, userId as "label" from site_users
354novalues=[ There are no registered users ]
355
988d8721
TC
356[report bse_test]
357sql1=select id, title from article where id = ?
358hide=1
359param1=article,Article
360sql1params=1
361
77804754
TC
362[valid child types]
363Article=Article
364Catalog=Catalog,Product
365Product=
95989433
TC
366
367[protect link]
368; articles for which the link field should not be overwritten
369; the values are ignored, but you can include descriptions
3701=home page
3713=shop
3726=formatting guide
3737=RDF
2a295ea9 374
ab2cd916
TC
375[editor]
376;allow_thumbs=1
377;thumbs_class=BSE::Thumb::Imager
378
2a295ea9
TC
379[site users]
380display_name1=First Name
381display_name2=Last Name
382display_address=Street
383display_postcode=Post code
384display_telephone=Phone
829c9ed9 385
2076966c
TC
386[nonajax user agents]
387ie4=MSIE
388
389[ajax user agents]
38de0036 390mozilla=^Mozilla/5\.0
2076966c
TC
391
392[ajax definitions]
454cdabb
TC
393includes=<<INLINE
394inline:<script type="text/javascript" src="/js/prototype.js"></script>
395<script type="text/javascript" src="/js/scriptaculous.js"></script>
396INLINE
2076966c 397
0eb78304
TC
398[nuser controllers]
399user=BSE::UI::User
5af99440 400redirect=BSE::UI::Redirect
e7367b88
TC
401shop=BSE::UI::Shop
402search=BSE::UI::Search
403page=BSE::UI::Page
0c2e7f7a 404tellafriend=BSE::UI::Tellafriend
85aba847 405default=shop
e7367b88 406
4c4d3c3f
TC
407[nadmin controllers]
408shop=BSE::UI::AdminShop
0eb78304 409
829c9ed9
TC
410[includes]
41100bsecfg_d=bsecfg_d/
0c2e7f7a
TC
41250local=bse-local.cfg
413
414[mail resources]
415stylesheet=email/email.css,text/css,1
416
417[targets]
418tellafriend=/cgi-bin/nuser.pl/tellafriend/TARGET
419tellafriend_n=/cgi-bin/nuser.pl/tellafriend