Jonathan Rosenbaum
8810c7f3f1
This fixes #65 .
* Hadn't updated populate.sql to take advantage of the new change, and demo it out of the box. Nice default.
* show_soldto_not_signed_in = 1 & show_soldto_signed_in = 0
7 years ago
Jonathan Rosenbaum
57ecbab44a
Modifies date in shops from date to datetime for #26 .
7 years ago
Jonathan Rosenbaum
44748ca740
Changing Sale Date to Donation Date for all Donations.
7 years ago
Jonathan Rosenbaum
f889eccc71
Turns off quantity (community_bike) for Memberships.
7 years ago
Jonathan Rosenbaum
c1bde007b4
Minor text edit.
7 years ago
Jonathan Rosenbaum
04846ae362
Uses a new type for the volunteer column.
7 years ago
Jonathan Rosenbaum
52ba58d805
Changes the model suggestion for volunteer table.
7 years ago
Jonathan Rosenbaum
4feb5022eb
Puts all volunteer data into one column called "volunteer".
* Reflects the changes in json, and adds more definition to the json callback.
7 years ago
Jonathan Rosenbaum
3087e5d21f
Adds Stand Time transaction type.
7 years ago
Jonathan Rosenbaum
1805449b50
Changes Personal to Stand Time and many other things:
* Updates populate
* Makes Stand Time a special transaction_type_id
* Adds new definitions to database_functions
7 years ago
Jonathan Rosenbaum
df15b6933f
Adds some improvements:
* Adds Stand Time Transaction
* Turns off Build Your Own Bike Transaction
* Improves documentation
7 years ago
Jonathan Rosenbaum
51f91ddbad
Add a deposit to initialize the POS
8 years ago
Jonathan Rosenbaum
bb89cba8ba
Thought it would be a good idea to add the database schema.
8 years ago
Jonathan Rosenbaum
16e0bbcbf9
Adds documentation for Memberships transaction_type_id.
9 years ago
Jonathan Rosenbaum
3358af425f
Added documentation for other_volunteer.
9 years ago
Jonathan Rosenbaum
91ede32f80
Adds other_volunteer to the table. Useful for treating community volunteer hours differently in stats, etc.
9 years ago
Jonathan Rosenbaum
6d1bb2ad8b
Modifies Student Volunteer to Student Volunteer/Community Service
Changes fixed size in shop_log to relative for sign-in display
Changes Donations to the accounting group Donations
9 years ago
Jonathan Rosenbaum
c5755bcddf
Added the change, not just documentation, for parent 3234faa46
.
9 years ago
Jonathan Rosenbaum
3234faa464
This tiny change fixes the Bookkeeping Reports. What threw me off was the caveat concerning the purpose of "Accounting Group", basically is used to group together similar types of transactions, like Sales, Deposits, and Receivables.
9 years ago
Jonathan Rosenbaum
71aa35af00
Fixed two bugs with interest survey.
1) Removed UNIQUE from selections.selection
2) SELECT query added contact_id
nicer
10 years ago
Jonathan Rosenbaum
5a36eea47b
Stores comments from interest inventory as 1.
10 years ago
Jonathan Rosenbaum
e9e3a0ef66
This completes the interest survey logic.
1). In confs, update works well, delete has an issue with on delete cascade.
2). Saves state properly. Now just need to create a front-end to query for volunteer organizers.
10 years ago
Jonathan Rosenbaum
433ab1a224
Changed table name from choices to selections. Makes better sense.
10 years ago
Jonathan Rosenbaum
1ee42f580a
This changes the database schema for interest survey.
10 years ago
Jonathan Rosenbaum
ec69322128
Made id a fk to contact_id in contacts.
10 years ago
Jonathan Rosenbaum
cf3cfe8838
Created a new table 'options' to store interest inventory values
also ..
1). zip to Zip Code .. some day will need to make international
2) changed Fill-in Form to "Check them out!" for volunteer interest .. subject to real world testing.
10 years ago
Jonathan Rosenbaum
b1a11b9f3b
Saves state for waiver & email_list, and more
1). Adds configuration options to turn off waiver & email_list options
2). Puts waiver in Connections/waiver.txt
3). New MySQL waiver column added, receive_newsletter used for email_list.
10 years ago
Jonathan Rosenbaum
ba0b491344
Corrected the focus on transction_id, also
1). In mysql, description is not text
2). .. added history as blob, drupalish
10 years ago
Jonathan Rosenbaum
60bd4befea
Replaces show_soldto_location with 2 new columns.
1). show_soldto_signed_in or show_soldto_not_signed_in
2). More info can be found in populate.sql
10 years ago
Jonathan Rosenbaum
e444cdb93c
Preparing GnuCash CSV interface, and fixed no shop bug with new logic.
10 years ago
Jonathan Rosenbaum
bf2527e1cf
Changed some text is populate.
10 years ago
Jonathan Rosenbaum
a44e5e93f2
Fixes an issue when Sum has ",", and a spelling mistake.
10 years ago
Jonathan Rosenbaum
c1a33b7076
Provides anonymous capability for transactions.
10 years ago
Jonathan Rosenbaum
b68b4926b4
Added Bike Delivery as shop type.
10 years ago
Jonathan Rosenbaum
d16811fe95
Added editable Change Fund.
1. Mouseover allows edit of Change Fund.
2. Difference is shown, and stored in db for page reloads.
10 years ago
Jonathan Rosenbaum
7658c11d53
Added check number when Check is clicked.
10 years ago
Jonathan Rosenbaum
f6d392b0b5
Several improvements:
1. Now uses better function, CurrentShopUser for signed-in users so that people need to be signed in to make purchases.
2. Improved header text for Contacts.
3. Removed edit link when paid checked.
4. Fixed populate.sql
5. Added payment type column in transaction_log.php
10 years ago
Jonathan Rosenbaum
9ab7723b6a
Fixed now.
10 years ago
Jonathan Rosenbaum
3dc17d58dd
Fixed sql.
10 years ago
Jonathan Rosenbaum
d41f647211
Removed an unnessary parenthesis in sql.
10 years ago
Jonathan Rosenbaum
dc7dd4d01f
Beginning of transaction calculator framework & enh.
10 years ago
Jonathan Rosenbaum
baebf5612b
Improves Deposit presentation.
Also,
1. renumbered tabindex
2. added constant for default number of rows shown for transactions.
10 years ago
Jonathan Rosenbaum
2370ccee7b
Many goodies for a better user experience.
1. New NONSHOP constant. 0=no function =>1 is function
2. Moved individual_hours_log back to /
3. Added better view/business logic for storage transactions,
and new documentation.
4. New users logging in can immediately add a project/comments
5. Added more documentation to populate and a new show_payment field.
10 years ago
Jonathan Rosenbaum
f72f022811
Added payment_type.
10 years ago
Jonathan Rosenbaum
baf8f61d9e
Fixes time behavior for DST, and adds a user-defined constant.
10 years ago
Jonathan Rosenbaum
6f1a9d241e
Another UI change, css file, and sql change.
10 years ago
Jonathan Rosenbaum
2274b69a8e
Replaces some hardwired variables with user-defined constants.
populate.sql will be updated usually via work done at https://github.com/fspc/ybdb
10 years ago
Jonathan Rosenbaum
796c1f6ebb
A few changes before implementing jquery, and move sql to sql dir.
10 years ago