In LIS3706, I studied unix commands and shell scripting. I got very comfortable with using the command line and writing scripts to carry out various tasks (such as retrieving information from a database).
For our last lab assignment I had to write several scripts
The first script defined environment variables and created soft links the directories I would need to work in.
This script takes three parameters: year, dealer id, and whether the cars being sold are new, used, or both. It determined the total car sales within the parameters, the total dealer cost, the told amount by paid by ty the buyer, and the total list price.
This script does essentially the same thing as the last one, but takes model name as a parameter instead of dealer id and returns total car sales within the parameters, the total dealer cost, the told amount by paid by ty the buyer, and the total list price based on that instead.
This script takes two parameters: 'dealer' or 'model' and dealer number or model name. It writes a "Sales, Profit, and Discount" report to a file called report.tmp and includes: year, number of cars sold, total dealer cost, total price sold, total list price.
This script is similar to the previous script except it adds total profit, total discount, average profit, and average discount to the report.
This script will create text files of reports for each model in ~/reports and ~/public_html/reports