Makers of Wintix, Tixsales
and Webtix Box Office
Accounting Software

Welcome! Log In Create A New Profile



Advanced

Improvements in Wintix 5 - the changelog

Posted by bruce 
Improvements in Wintix 5 - the changelog
February 18, 2009 09:45PM
This is a list of the improvements in Wintix version 5.



*7/2/07
* SeasonTx now saves Percent_SC
* SeasonTx has the Internet options button
* SalesRec will save the amount in each pay category
* New options to login: if the login is blank, it will be prompted for it - just like the password.
*7/5/07
* ShowInternetOptions saves the data.
*7/7/7
* Support for the merchants table added so multiple merchants would be used for credit card charging
* Affected ShowEdit and SeasonTx
*7/10/7
* InactiveNames is working.
*7/11/7
* SalesRecTixPrintAll.Init() will accept nulls as mainsale.TixPrnDate
* New form: Merchant data - for the data for unique merchant accounts
*7/12/7
* There is an out of balance report for the run of a show now.
*7/14/07
* proRptUnpaidReservation forms is working and in the Tixpro menu.
*7/16/07
* Customer reports by account and name now ordered by sale number
*7/21/7
* rptCustName and rptCustAcct display the abbrev with "*" + abbrev if from Oldsales
* History.scx displays the abbrev with "*" + abbrev if from Oldsales
* ListEdit.HistoryButton will count the records before going to the History form.
* AboutWin.UpdateSeatsRemaining generates a list of the results - with percentage sold out.
*8/15/7
* Report for the list of clerk permissions is working
*8/22/7
* SaleRunningTotal form was not displaying the current sale because it was not in the mainsale table.
* ShowEdit and PerfEdit were not displaying properly if there was a null value in the show_date field.
* SalesRec credit card was displaying as NULL if the card was null. Now, if isnull(audit.cardnumber),
* the field will be displayed as mainsale.cardnumber.
*8/23/7
* SaleNewST - going back to page 1 needed to display the list of ST
* SaleHistory.scx displays the Oldsales history
* Performance dates where isnull(show_date) can be sold and edited
* rptShowOutOfBalRun needed to include the SC and donation in the report
*8/28/7
* SalesRec would attempt to display a NULL if shows.show_date=NULL
* Daysales1PayType and rptDailyWhatPayTypes are working now.
* Newuser form now copies over another users permissions when requested
*8/29/7
* Domain permissions are working when selling tix.
* Sales for the run of a show and performance have PayTypeDisp() added at the bottom
*9/1/7
* Class perfchoice of generic.vcx now uses glOrderedChoice (if true) and uses DomainShows()
* This class is used as part of season ticket sales when adding performances and in the reporting.
*9/4/7
* There now is a generic search feature as part of the mailing list lookup
* The Heic galaxy galaxyheic0602.jpg no longer shows up by default. It can be anything.
*9/5/7
* ShowInternetOptions has a new button: Webtix check. This checks for a show being ready for sale on the internet.
* It checks: domain, price codes, pay types, performances, performances on sale.
*9/7/7
* Added an alt-K to the menu for logging out and in.
* New form: TixPrintTheHouse
*9/10/7
* MultiCharts are working in SaleNew and SaleNewQuick, rptPerf.
*9/11/7
* Cancelling a sale sets the visible amounts to zero as well as the mainsale table.
*9/13/7
* Run of show, performance, and Daily sales reports have had their built-in reports changed.
* The red background has been replaced with the regular background and 2 fields.
* This was done for speed.
* Daily sales for 1 clerk has the regular reporting button.
*9/19/7
* When editing a customer's record, the program checks for a sale history and allows it to be attached to another name
*9/21/7
* Audit trail in a sales record can be printed now.
*9/27/7
* Returning a sale - lookup by sale number checks for the sale date being consistent with the permissions
* when the domains are on.
*9/27/7
* Returning a sale - lookup by sale number checks for the sale date being consistent with the permissions
* when the domains are on.
*9/28/7
* EditByName now lists the show date and time in the list.
*9/29/7
* Option to save the credit card numbers is initialized as false. The option is a checkbox in InitMenu
* with a note that "you must be PCI compliant"
*10/3/7
* Wintix menu - Changed name of Seats remaining report to Seating chart count.
* rptPerfSumm, got rid of the call to UpdateRemaining(). Replaced it with an update SeatsRemaining with
* capacity-sum(total_tix). This field existed already and using it resulted in a major improvement in speed.
* rptPerfSumm can go to a spreadsheet
* SaleNew.FinalPage.Activate(10) now accounts for null show_date fields
*10/4/7
* Both the seating chart and performance report have a new function UnmatchingSeats() to check if the seats
* are orphaned.
* rptSeatsRemaining has a progress bar that uses PCDone()
* fProcess gets the seat list from the chart instead of aSeats. This eliminates a lot of code and also make the
* sales record reflect the price and categories that actually are on the chart.
*10/5/7
* K_SH_F11 - History of the sale now goes the the sale double-clicked on
* Went through the forms that called the Pending_Sales table and put all the work in the functions.
*10/22/7
* Adding a new performance will pick up the prices and chart from the first performance entered.
*10/23/7
* In MailLook, put an order by in the lookup by company.
*10/26/7
* Finished the delivery method stuff. Now, the delivery method can be entered, edited, put in as part of a
* sale, edited when in a sales record. There are 2 reports by day and 2 by performance.
* We'll see if the gang can figure out to use it for.
*11/2/7
* QuickChoice displays only the shows that have performances on sale. Respects the password permissions
* and domains also. That way, the only shows that show up are the ones that have something for sale.
*11/5/7
* Best available selection is working now in Quick sale. It always was working however the messages after
* seats were rejected appeared that it was not working.
*11/6/7
* If an ODBC error occurs while writing the sales information, the error will be displayed.
*11/7/7
* GL_Codes report includes the donation and service charges now.
*12/1/7
* New report: report | by Day | Clerks | What shows were sold - 1 clerk
*12/3/7
* Editing performance dates will replace any null values of OnSale and OffSale
*12/4/7
* Database name and login is included in the error handling
*12/12/07
* Daily report for 1 show was not appending records if sent to a file.
* Would only happen the second time it was called.
*12/16/7
* PlanNew creates plans now as InnoDB instead of ISAM
*12/21/7
* Performance summary report has a little more space for the show_date field.
*12/22/7
* About Wintix form can maximize - for the updating report
* WhatShows report now sums the categories and creates a relational link with the master and shows tables.
*1/1/8
* Report formats get saved to a new table: report_formats. This was done so everyone could use the same
* reports - no matter where they are.
* Daily sales, run of show, and performance reports have credit cards totaled.
*1/2/08
* SeatPrint() no longer returns "No seats on chart" if there is no chart attached to the performance
* Daily report for 1 show has red bars if there is unmatching seats (it was black).
*1/3/8
* What Shows report put the performances in chronological order properly when the box is checked.
*1/6/8
* Data connection section has the option to quit or try again.
*1/7/8
* CardTotalDisplay and DayCardTotalDisplay have "Discover" instead of "Diner's club"
*1/8/8
* AboutWin now displays 2008 as the copyright date. Environment button also closes the form after clicking.
*1/15/08
* A new show has the option to add the domainlist to the new shows
* A new performance has the question, "That was the first performance. Want to enter the prices?
*1/20/08
* ListAllShows stays open after a show is selected.
*1/23/08
* MaillistGenerate checks to see if anything is returned.
* Menu code: going to last sale checks to see if anything is found.
* ListEdit has buttons to allow skipping in the customer file
*1/24/08
* ShowNew will copy comain permissions now.
*1/25/08
* PerfEdit.Init has bee changed. If chart=1, capacity and seats remaining are disabled
* (information there comes from the tables) Seats remaining and capacity are enabled with
* information coming from a query.
* Updating the shows table in ShowEdit can handle .null. values in Perfinfo1 and Perfinfo2 fields.
* UpdateRemaining and a few other queries now check for .nulls.
*2/3/08
* Put in a check for isnull( total_tix ) in CatDisp(96) for an occasional error
* Added Show, cShow, cTheatre, and cLocation to rptPerf for all the old special report formats
*2/5/08
* CardTotalDisplay and DayCardTotalDisplay have a line for the totals.
* MaillistIncidents form would not add a record if there was an apostrophe in the last name.
*2/7/08
* SalesRec has the numeric field for publicity_codes_id replace with a label and a square button
*2/16/8
* Wintix.mnx has an option to open any file. Defaults to "\Tix7\Output"
* MaillistGroupSetup has been overhauled to write changes as they are written rather than saving at
* the end of the editing.
*2/18/08
* Put letters in the price codes in DomainList for easier referencing.
*2/20/08
* Download an update is working in Help | About Wintix. It requires a right-click in the gray box.
* New program: StartWintix5.exe This is a pre-program that starts Wintix. Its purpose is to check for an
* update to wintix5 (wintix5.new). If the update exists, then steps occur:
* Wintix5.new is checked for size
* Wintix5.old is erased
* Wintix5.exe is renamed to Wintix5.old
* Wintix5.new is renamed to Wintix5.exe
* The new Wintix5 starts.
* This is a long-awaited improvement. StartWintix5.exe will need to be put into the same subdirectory
* as Wintix. The Wintix5 icon will need to be changed to point to StartWintix5.exe instead of Wintix5.
* We'll see how it works out.
3/5/08
* Changed Sales record to not move the tabs while skipping records.
* Adding a new show gives the options to copy domain permissions, price cats, and special tix formats.
*3/6/08
* New form: Look up a sales record by a generic search.
*3/7/08
* Generate a mailing list now has options for the fields to be copied and an added options for searching.
*3/15/08
* Put in new variables in ccProcessing.prg from the "Card Present" guide - for Authorize.net
* x_market_type && retail
* x_device_type && personal computer
* x_response_format && delimited (not XML)
*3/17/08
* SaleNew: Another transaction with Different person, same perf was giving a message, "Nothing available"
* then displaying the dialog to select a show.
*3/31/08
* Generic searchclass will search for character fields if "is blank."
*4/2/08
* Generic Searchclass now has the option "is not empty" for character searches.
* When a "local DBF file" is opened, there is now a menu choice to remove duplications.
*4/3/08
* When a "local DBF file" is opened, there are now a menu choices to view the file
* as a spreadsheet and export as a CSV file.
*4/6/8
* Finally got the MaillistGenerate form working with queries for the sale dates in the mainsale and
* oldsales files with a generic query.
*4/12/08
* ShowEdit and SeasonTx are sensitive to the different width price fields. Done for the 6 decimal places used in Tennessee
*4/19/08
* Class quickchoice OF c:\tix7\libs\generic.vcx uses the option glCountRemaining to force an update of the
* seats remaining by summing the mainsale.
*4/21/08
* ShowInternetOptions has a new page to edit the master.emailform for a custom emailed receipt.
*4/22/08
* Planedit has a field to enter and save the map_coordinates - for multicharts.
*4/26/08
* Made the Download update button visible in AboutWin
*5/10/08
* Got the scantix form working for bar coded tickets.
*5/13/08
* Put the Coffee bean graphic in the project so it could be a background.
*5/14/08
* Made the seats remaining report re-sizeable. Done for the operations that have lots of performances
*5/15/08
* Changed TixprintByPerf, SalesRecTixprintAll and SalesRecTixprintSelected to put TicketNumber on tickets
* The field TicketNumber is a unique field suitable for use with bar coding.
*5/24/08
* Put in 2 reports: rptPayTypeRun and rptPayTypePerf
*6/7/08
* Put in support for gcMarketType in InitMenu for AuthorizeNet
*6/16/08
* Put in a test for the ticket format being opened on another computer before opening it for modification.
* CardTotalDisplay(), PayTypeDisp(), and CatDisp() will give answers now when using the Oldsales files.
*6/21/08
* rptDailyWhatShows1Domain sorts the report by abbrev - request of Jamye
* NewAbbrev and ShowNew no longer accept apostrophes - for saving the data in Webtix.
* Perf is working again - with seating charts
*6/25/08
* BrowseDisp form will order itself according to the column when the header bar is clicked. Also, the
* payx firlds have been replaced by paid. The remo fields have been taken care of with RemoveMemoFields()
* When the report gets ordered, the green bars are turned off.
* Called by rptDaily, rptDaily1Clerk, rptPerf, rptRun, and proRptPerf
*6/26/08
* Clerk field modified to allow clerk lengths > 7. To do this, the length of the clerk field needs to be
* widened in Passlist, Mainsale, and Oldsales. This was done with a new class: generic.ClerkField
*7/1/08
* MailListGenerate automatically includes the Account field now (unless explictly turned off).
* The account field is needed for MailFileSubtract.
* Number of records in the caption taken out - speed improvement
* Limit 1 commands added to the query in MailLook - speed improvement
*7/5/08
* SeasonTix reports supports the oldsales file data
*7/9/08
* SeatPrintChart.prg is part of the program - used for reporting
* SaleGiftCard and rptDayGiftCard are part of the program
*7/10/08
* Removed references to the serial port stuff in SaleNew, Quick, and ST for the pole display and put
* in a new pole.prg. Done for the USB ports.
*7/15/08
* Finally got the partial exchange working
*7/16/08
* rptDaily1Clerk has options for mainsale, oldsales and both tables
*7/28/08
* Label formats can be downloaded from the report_formats table
* Reportformatcheck() checks for the field's existence. If there are any mistakes, it will report them and
* give an option to attempt printing anyway (it cannot evaluate expressions or commas).
*7/29/08
* Got the DownloadReportFormat working
* AboutWin.scx and StartWintix5 have been changed to handle a zipped file for updates.
*8/11/08
* Added Taxable field to the Payplan form.
*8/16/08
* Daily sales report for 1 Clerk has an option for a time range.
*8/26/08
* Browseing a report changed to have totals in the form itself.
*8/27/08
* SeasonTix reports can go to a spreadsheet in the .\Output folder.
*9/4/08
* Removed references to vfpencryption.fll from AboutWin.DownloadUpdate button. It did not seem to do any good
* and would occasionally crash the program with an Error 1691 Library file p:\tix7\vfpencryption71.fll
* is invalid - in 2003 server.
*9/7/08
* Calculations using shows.percent_sc should be working in all forms now
*9/12/08
* New seating plan screen will stop *some* reserved words from being used. Was causing a problem with MySQL.
* New button when editing a performance to edit the chartdata.
* Abbreviations can no longer include "/\$." because they were interfering with the file systems.
*9/22/08
* SalesRecResToSale uses shows.percent_sc properly
* rptDaily1Clerk had a problem when there were no records found
* rptCustName now has mainsale.account and oldsales.account in the information returned by the query
*9/23/08
* Values message changed to "Use values when editing sales records"
*9/24/08
* QuickSale supports price structures with 6 decimal places in the prices
*9/26/08
* Default changed for the credit card log to include the requests and answers.
* Widened the total of the tix in browsereport a little bit and changed the mask to make the maximum
* number of tickets to be a million.
*10/8/08
* Downloading reports and tickets have an offset calculated between the
* local time and the server time. This is used in determining whether to download an update of not.
* Internet Options button allows loading of images to the master table.
*10/26/08
* SalesReceipt creates and relates to temporary master and shows cursors for use in the custom formats.
* This way, the correct master and shows data will be available for all records in the receipt.
*10/31/08
* Rollover is now officially part of the program.
* rptDaily1Clerk defaults to the current day as the starting and ending date
* rptC_Card defaults to the current day as the starting and ending date
*11/5/08
* Removed AccountCancelButton from SalesRec
* When a sale is cancelled, the code will look for a master record where abbrev = 'Cancelled sale' and put
* that master_id in the cancelled sales record. This way, the cancelled sale will be removed when the
* cancelled sales are purged.
* Gift card reporting works - by day and by customer
*11/11/08
* Zipping and unzipping the report formats in UploadReportFormat and DownloadReportFormat
*11/13/08
* Schedule checks if there is anything returned.
* Abri is integrated - if recover.app exists. Abri will check for memo damage in the reports, tickets and labels
*11/22/08
* SeatsRemaining report has been overhauled. Got rid of some unused properties and a method. Add a check
* if ChartExists() so that it would alert to any missing charts. Got rid of the annoying maximize
* screen after the report is run.
* MultiPerfEdit has a progress bar when a new list of charts is built.
*11/24/08
* AddRec - Returns to the new sale instead of the old one
* Mintix - Saves the order selected in TixGetMulti in a public variable: gnPerformanceOrder
*11/25/08
* proRptTopCustomer will go to a text file, dbf, or spreadsheet
*12/3/08
* rptDonations will go to a spreadsheet, text file, or dbf. It will also display as either summed or itemized
* Report added: DonationsSummed. This report has their total donations and includes the customer's address,
* phone and email.
*12/4/08
* Removing shows also cleans up the audit trail and the cancelled sales.
* New table to keep a permanent record of the credit card data.
*12/18/08
* Removed the option to log the credit card numbers - they will all be logged
*12/23/08
* Overhauled the clerk permission report to make it look better
*12/28/08
* Added SearchByCompany and SearchByPhone forms
*12/30/08
* MailLook has been overhauled to allow apostrophes in the first and last names - when the button is clicked
* New permission: Edit the card number when editing a sale.
* New option in list of user's permissions: set a new password. Only for the sysadm
* Brighter colors in the Pass* forms
*12/31/08
* Off-sale shows can be sold. These are defined as performances where the onsale and offsale are out of
* range. Domain permissions are still active.
* Overhauled the inactive customer removal. New option: keep everyone entered since a specified date.
*1/15/09
* Performance summary report has the default option to not update the seats remaining.
* This resulted in a speed improvement for long lists of performances
*2/11/09
* WhatClerks report has a checkbox to give the credit card totals for each clerk (especially Webtix)
2/16/09
* Out of balance report for a performance has been put in Wintix
* EditByName - has an incremental search
*2/18/09
* Sale labels and customer labels are saved in public variables so that they will default to the
* same label each time.
*2/26/09
* DailySalesReport cWhere query overhauled to use datetimes as part of the times query. Problem was that the
* records would be correct, but not the totals.
*2/27/09
* SalesRec.Page2.ReturnSeats displays a mouse pointer when counting up the seats
*3/3/09
* CatDisp displays the promotional codes in the special price totals
*3/4/09
* Authorize.net is sent the abbrev rather than the showname in the comments.
*3/24/09
* Sales records have a skip in alphabetical order if looked up that way - from EditByName
*3/25/09
* Reports have returns the letter of the category
*3/29/09
* RptDaily Automatically checks “include payment types & card” in rptDaily
*4/1/09
* New code used to make sure the customer's address is not blank.
* TicketDeliveryReport has an option for 1 ticket delivery method
* BoxMenu.scx uses Verdana 10 B as the font instead of Fixedsys.
*4/11/09
* Changed the permission list to match the permissions in Webtix.
* rptDailySummary.scx supports custom reports
*4/21/09
* PoleScroll.prg is working now.
*4/22/09
* Clerks can have longer clerk names - if the passlist.clerk field is wide enough. The default is 7.
* If this option is used, the clerk field must be changed in passlist, mainsale and oldsales.
*4/25/09
* Passuser changed to put permission 51 as the "Webtix - Access the administration page"
* DailySummary does separate summaries for Amex, Visa, MC and Discover.
*5/7/09
* Daily report for 1 Show supports reports for a range of times.
*5/9/09
* Editing a sale will display the audit trail - even if it has been sent to the oldsales tables
* File | Environment form displays the MySQL version()
*5/16/09
* Editing sales, lookup by name list ordered by last, first, sale_num
*5/17/09
* Mintixmain.SalesRec has an option for returning seats with an additional sales record - like Wintix
* proRptAccountsRecieveableBrowseDisp.scx will pay all sales in the list
*5/18/09
* SaleNewST.PayPage - changed the location of the verify card and Swipe card buttons.
*5/21/09
* Mintix will print a receipt at the completion of a sale. To do this, SalesReceipt was overhauled to pull the
* appropriate data from the mainsale and customer tables - even they may not be opened.
* TixPrintTheHouse.scx sorts the seating plan by section, row and plan_id before printing
*5/31/09
* AccountChange will default to a phone number if it is available and Numeric incrementing account is not
* checked
*6/4/09
* Mailing list lookup has a lookup for the the partner's name in addition to customer's name.
*6/10/09
* FTPBackup is working so tables can be posted to an FTP site
*6/11/09
* Backup to a local drive is working. Downloads tables to the .\Data\ and .\Plans subdirectories and zips them.
*6/15/09
* rptDailyWhatShows1Clerk.scx would not set the clerk list to a correct entry when the calendar puchbutton
* was clicked.
*6/17/09
* Adding a new show: appended a record to the master then filled in the data.
*6/18/09
* CashDrawer has a port display same as the PoleDisplay form.
* AddRec will pick up the a_agent, tour_group and exp fields and put them in the added record.
* CardSwipe has a warning for IC_Verify to change the payment to type "credit" if amount to be paid < 0
*6/25/09
* rptdailywhatshows1clerk.scx had a misspelling on the calendar button of the ending date
*7/1/09
* CopyPricesPerf and CopyPricesRun support copying cash_sc and percent_sc
* Deleting a show: put in some progress messages
*7/9/09
* EditBySale.OKtoEdit() has a better message, "Your domain, " + gcDomain + " does not have permission to edit sales for this show"
* CopyPricesPerf supports multiselect. That way, users can copy prices to a range of performances.
*7/22/09
* Mintix.TixGetMulti has a button to display the images
*7/27/09
* EditByName:
* The first 2 letters are limited to 30 names
* Everything else is limited to 250 names (rather than 100)
* First name search works the same as the last name
* A message, "Truncated at 250 names" is displayed in the list
*8/8/09
* Out of balance reports speeded up by downloading and writing only the information when necessary
*8/12/09
* WhatShows report for 1 Domain - added radiobuttons: sort by today_date, performance or none.
*8/12/09
* rptDailyWhatShows1Domain - added radiobuttons: sort by today_date, performance or none.
*8/21/09
* Put in a check in SalesRec before SalesRecResToSale gets called if reccount("mainsale") > 0
* Done to stop an occasional error.
*8/31/09
* Ampersands are no longer allowed in the abbreviation - ShowNew and NewAbbrev
*9/1/09
* TixprintTheHouse now indexes the plan on left(lcPlanName + "_id", 10 ). It has to be this way because
* dbf files can only have 10 characters in the field names.
*9/3/09
* AuthorizeNet.prg and ccprocessing.prg support track 2 data.
*9/8/09
* PlanEdit has a button to update all occurrences of the selected plan.
*9/9/09
* Editing a customer's first or last name while editing a sale also updates the mainsale
*9/15/09
* Put in codes for drawing ascii boxes (single, double, and blocks) into GetPlanData, PlanData, and PlanBlockSelect
*9/22/09
* Catdisp needed to group the special price tix by promocode + spec_price
*9/26/09
* SaleNewQuick checks for !empty(sClerk ) before starting a sale. Done in the menu code.
* This was allowing clerks to start a sale with an empty clerk name
*9/29/09
* Plandata.scx has the OK button as the default - not the cancel button
*10/2/09
* Removed reindex permission from Passuser - no longer needed
*10/10/09
* Mintix: _screen.title put before the MySQL connection is made - thefore there is not a long delay with
* Microsoft Visual Foxpro on the screen.
* Mintix: The download update button is visible
* TixGetMulti: Converting the <fieldname> to a character field message is removed
* Mintix closes with 1 click instead of 2 clicks
* Mintix: TixGetSaleInfoMulti will go back and edit and change a chart in the list.
* Mintix: TixGetMulti puts the percent_sc into the perflist.
* Mintix: The SalesRec.Page1.UpgradeSale button only shows up if the exe is mintix
* SalesRec has the totaltix, totalsale, and totalpaid labels blank until the value is calculated.
*10/15/09
* Perfnew will copy the prices from a selected performance (whatever the light bar is on).
*10/19/09
* RollOver: Put in ability to have a starting and ending price code.
*10/22/09
* PlanReassign can add a row to either the top or bottom of a plan
* PlanEdit.CopyPlan copies a plan and makes the primary key to be autoincrementing.
*10/23/09
* PlanReassign has a warning messagebox before cleaning up the status and price codes.
*10/26/09
* gnPerformanceOrder added to PublicVarCheck() and SaveVars(). This global is in Mintix.TixGetMulti.Init
* to determine how the performances are displayed.
* rptDailySummary has added fields pay1 - 10 if the special ticket format is checked. Done for PF.
*11/4/09
* TixSaleInfoMulti supports printing all tix as 1 print job.
*11/6/09
* Trimmed the clerk field before saving it - Done for the clerk report.
* RptPerf supports sending reports to email or PDF's
*11/10/009
* ListEdit has a checkbox for the Optin_email_list field
*11/16/09
* ShowComments will display nulls as chr(32)'s to allow editing.
* Put an Integrity report in the right-click method of the rptDaily, rptRun and rptPerf.
*11/17/09
* Moved the spec_tix and comps to the tickets tab.
*
*11/23/09
* SalesRec.Page2.Column3.Valid will total the number of tix at the bottom of the page.
*11/30/09
* Integrity reports are implemented on the Daily, run and performance reports. Dione with a right-click on the
* run report button
*12/2/09
* Put in the ability to use the 3.51 ODBC driver again. If left blank, the program will default to the 5.1 driver.
*12/3/09
* MailLook and EditByName have a limit to the number of results returned.
*12/9/09
* InitMenu has the options for numeric accounts and Capitalize mailing list entries on page 3
* ListEdit will put in phone numbers as the default account value - same as version 3
* Incremental searches will go to 10,000 in MailLook and EditByName
*12/18/09
* Put in a backup based on MySQLDump
*12/24/09
* Due to the latest XP service pack, updates to Wintix were not being unzipped. Instead Wintix5.exe was erased
* and the program would not start. This was fixed by changing the download file name to wintix5.dld and
* unzipping that file.
* In order to install the update, users will need to erase the old StartWintix5.exe and rename StartWintix5.new
* to StartWintix5.exe - after doing a download. In order to do the download from Windows Explorer,
* click on Tools | Security | Trusted sites | Sites. Uncheck "Require server verification"
* Add centerstage.com in the website line and click on Add. Close and click on OK. Downloads will work.
* Then, open the wintix5pro.zip file and copy the 3 files out. Erase the old StartWintix5.exe and rename
* rename StartWintix5.new to StartWintix5.exe. Tell everyone to go back to work.
* In StartWintix5.exe, the program is started with the /n option. This has the advantage of not leaving a
* command window open on the task bar.
*12/28/09
* StartWintix5.exe will install a new mysqldump.exe if it does not exist.
*1/4/10
* Added a Prompt for backup. Can be turned off in the Initialization section
*1/11/10
* Wintix.mnx - changed the backup destination to .sql rather than .txt
*1/18/10
* New reporting function: PayTypeDispValue.prg
* This will generate a summary for a show or performance with the values organized by pay type.
*1/19/09
* ListEdit.CancelButton has code to check for the phone, workphone or cell phone being blank if the
* Initialization option is checked
*1/20/10
* ListEdit now has code to accommodate email addresses in a memo field.
*1/27/10
* ListEdit.Page3.Zip2.Valid supports lookups in the ZipCity table
* Added SalesWithInaccurateTotals to the integrity reports
*1/30/10
* Put a choice to use customer.address2 and zip2 as the billing address to be submitted for charging
*2/3/10
* C_Card report now works in Mintix
*2/4/10
* ListEdit.CmdCancel.Click logic changed to case glForcePhone .and. ( empty( Phone ) .and. empty(workphone)
* .and. empty(cellphone))
* This was done to make a phone number in any field be adequate for getting out of the sale.
* Previously, all 3 had to be filled.
*2/11/10
* Put the GiftCardPayment object back into Salenew for Cinnamon @ Hale
*2/15/10
* Put in a display of the spouse first and last in MailLook if the incremental serch was checked and if
* the fields existed.
*2/24/10
* SALECHARTINFO.SALEINFO.CLICK( 42 ) checks to see if the sale exists before going to it.
2/26/10
* LISTEDIT.SAVECHANGES( 13 ) checks for the customer table being selected before writing to it.
* *3/15/10
* Added do ChartlistAuthFieldUpdate to update the chartlist.auth field
*3/18/10
* Overhauled the Scantix form. Now, it only allows for selecting a show and performance then running the report
* Actual scanning is done by ScanTix.war
*3/19/10
* Reset glUseDefaultDialog=.t. in MintixMain. This was done to stop all those messages that Pigeon Forge has
* been sending out.
* Put in a select("Mainsale") at the bottom of SalesRecTixPrintAll.SalePrint() Done to stop an occasional error
* at Artisan.
*3/20/10
* Created the report for ticket scanning
*3/21/10
* Put in a function to populate the auth field with a random and unique
* character string. Done for ScanTix
*3/23/10
* EditByName has an option to search by the partner's last name
* Password section supports saving the language in passlist.stringtable
*4/14/10
* TixprintByDay will print as 1 print job - if possible. If there is a different ticket format, fTixprn
* is forced to use the different format in a different print job.
*4/22/10
* DayCardTotalDisplay uses the total paid instead of the total_sale field.
*4/28/10
* Mintix will take a deposit and put it in an additional sale
* Adding a new show trims the leading and trailing blanks on the proposed abbrev
*5/12/10
* Clerk report will report on one show
* Initmenu: Added the option from page 5 to page 2 glResDepDisp - Display
* reservations and deposits in daily reports Returned the
* reservations/refunds/deposits to the daily sales reports.
*5/19/10
* Adding new names to the customer list will set tixflag to 1. Done for the
* FundRaiser integration
* TixSetup.scx: The Lasertix cursor needed to be selected before the label was
* modified. The print preview works again.
*5/22/10
* New field in the customer table customer.website
*5/26/10
* Converting a reservation to a sale will display the service charge
* calculations easier. Also, there is a choice whether to reserve one or
* all reservations.
* The limit for the number of names returned is saved
*5/29/10
* Season ticket editing has a button for WT_Offsale
*6/1/10
* Editing domains saves its changes with a transaction now.
*6/2/10
* Environment.OKButton.RightClick will display any non-InnoDB tables
* This is necessary for Webtix
*6/4/10
* Cancelling a sale has a caption easier to understand.
* Seating plans can be inverted now
*6/6/10
* Editing a show will not delete a performance if there are sales.
* Internet Options checks the size of the images before adding it to the master table
* Daily, run and performance reports have cursors in the modify custom reports
* to show fields available.
*6/9/10
* Environment.OKButton.RightClick will return a message either way for all
* InnoDB or some non-InnoDB tables
*6/10/10
* Editing sales records by company displays the sales records by show_date
*6/11/09
*6/14/10
* Editing sales records by phone displays the sales records by show_date
*6/15/10
*6/16/10
* EmailExport form supports the data in the mainsale table. The fields are
* under the fieldlist tab.
*6/20/10
* Printing tickets by performance report now has the totals for both
* printed and unprinted tix. And, it as an addition to the header to show
* whether it is for paid or all sales
*6/28/10
* TixprintByDay was not putting in the proper prices if the seats were reserved.
*7/3/10
* Put in try / catch and a message "You must fix this error before the report can be runin a bunch of reports and ticket printing operations.
* ftpBackup has an option to upload everything
* SalesReceipt will attempt to open the proper files for modifying the labels using OpenFiles.prg
* SalesRec has a new parameter: ReadOnly. Called by SaleChartInfo to prevent editing
* SalesRec.ServiceChargeLabel has been moved to the payment page
* SalesRec: fixed a couple display problems if the record was locked
*7/6/10
* Printing unprinted tickets for a day will use the Ticket_delivery system
* Daily sales report will print the payment types at the head of each page
*7/8/10
* Email can be sent to a different port. We will see if it works with GMail.
*7/14/10
* ShowInternetOptions.Page6.Command1,2&3 - Size of graphic increased to 100K.
*7/15/10
* Environment no longer has the disk size (it was inaccurate)
* Environment displays the user's domain
* Editing performances: OnSale and OffSale times needed to be widened.
*7/20/10
* SaleChartInfo allows editing of a sales record depending on permission #12. "Allow editing of a sales record
* while in a seating chart."
*7/22/10
* prorptaccountsrecieveablebrowse had an error if the values were selected. The entire values section was overhauled.
* PlanEdit.ModifyPlanButton will create a new local plan each time. Done because sometimes the plans get re-sized.
*7/23/10
* QuickChoice.List1.refresh was not responding to the sortorder checkbox.
* PlanEdit will add and reduce the number of records as necessary to make the record count = width times the length
*7/27/10
* fTixprn: moved the try/catch for the FGL tix to apply to only the label form commands - nothing else.
*7/29/10
* SalesReceipt will print out Ticket_delivery.
*7/30/10
* AboutWin changed to not display the name of the file downloaded
*7/31/10
* Perfsales report cleaned up a little to display the total sale properly
* CatDisp() cleaned up so the the spec_tix and comps line up properly
* Customer history forms default to read-only sales record editing
*8/2/10
* PlanEdit will remove illegal characters in the plan name. Called by PlanNew and PlanNameGet
*8/3/10
* Performance report has a 4th band to clean up some display problems
* rptSeasonTix checks for a spreadsheet being open before writing to it.
* Accounts Recieveable report will go to a spreadsheet.
*8/15/10
* GenericSearch form will do a search in the inactive table. MailLook will find and display the record
* For FundRaiser, customer records marked for deletion are transferred to the inactive table
* The table inactive is created when the program starts - if it does not exist already.
*8/18/10
* Printing selected tickets makes an entry in the audit trail.
*8/21/10
* Adding a performance will not check other shows when doing a show_date and show_time check.
* Editing a show will display the master_id in the lower left corner if the form is right clicked
*8/23/10
* Reassigning seats works like Tixsales
* PlanNumber starts with 1 rather than val( cPlan.Seat_Collm )
*8/24/10
* OutOfBalance Report will not display the show_date if null()
*8/26/10
* In a chart, the leftmost and rightmost columns no longer display any seat data
* Multicharts will not display a seat image if null
*8/28/10
* Donation report will now get donation reports for the logged in domain.
* Season Ticket report had some display problems in the report forms cleaned up. Will display a text file now.
*8/31/10
* The Wintix menu supports domains when the list of shows is built.
* Domain support is also put in ShowEdit, SeasonTix and ListAllShows.
*9/1/10
* PlanPrint report changed to take out the drive and subdirectory. Instead, put in the server and database.
*9/2/10
* Sales records do not display a .null.
* Setup Receipt has a button to edit the receipt.txt
*9/3/10
* Removed a diagnostic messagebox from TixprintByPerf
*9/8/10
* Seats are listed in the following order: section, row and val(seat)
*9/23/10
* EditByName needed to have a left join instead of an inner join. This makes it possible to look up sales records that
* did not have a matching entry in the customer table.
*9/25/10
* GL_Codes reports now includes custom reports.
*9/28/10
* FTPBackup - Removed the messagebox("Finished backing up")
*
*



Edited 2 time(s). Last edit at 09/29/2010 01:04PM by bruce.
Sorry, only registered users may post in this forum.

Click here to login