I need two scripts to help me manage a cyber cafe software. (windows environment)
estimate time for someone to finish this job is 10-15 hours
script 1 - generate a report & email it.
The employees are supposed to sell time to clients, sometimes they dont and they give time for free, which is the same thing as steeling. We want a report to help us stop this. The report is simple. I have made an example of how the report should look like. see the attachment. "[login to view URL]" The report has to show the total time given to clients, and the total approximate fee's that should have been collected.
note 1: We have a specific price structure for members and non-members. For this reason the report script needs to have a config file, so we can specifiy the fee structure. see the sample [login to view URL]
note 2: I want the script to be ran with an icon on the desktop. batch file. at the end of every shift. when they run this report, the app should download a snapshot of the db. analyze it. and save it into a folder /report/archive file name "snapshot-7-1-2018-5pm" and the report file name should be "snapshot-7-1-2018-5pm-report" the next shift employee will run the report again, and the system will generate a new file called "report-7-2-2018-3am" the system will compare the previous file, and the new file, to be able to see the diffrences.
note 3: we will need to setup a time, so i can demo to you the cyber cafe software. and how it works. via skype audio and teamviewer. you can also download the app and run in on your system to learn and understand how it works. you can download it for free here [login to view URL]
note 4: i would like the report to be email to me using my google gmail credentials. so the config file, will need to have the smpt settings etc...
note 5: The app uses paradox database, and is accessible when the app is open.
script 2 - clear time from accounts
I need another script to run nightly using the windows scheduler. run and exit.
the script will run and do the following:
1. find any account that has more than 3000 minutes and bring it down to 0, and disable the account in tinasoft.
2. find any account which has the name allday* disable the account, and make the expiration date the previous day's date.
3. find any account with the username pc01 >>> pc50 and make the time 0 on all of them
1. we must be able to talk via voice and screensharing so i can show everything before i award the project
2. i will put 100% of the payment in escrow
3. must be availble usa hours california time to talk about project and do testing when the app is ready
⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hello.I am Russia Developer. I read your description carefully. I have rich experiences in DB . I will do my best to finish your job ASAP. Thanks. Best Regards. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐