Php Editing
Report Edits
1. Compare 2 reports (Activity Summary and Billing Summary) and fix so
that both reports return the same totals. They are run on the same data, and are currently showing about $1000-1500 difference in totals.
2. When the report page loads, add a multiple select box function on the right side of each row of data, so that for each row, the user can decide not to include some lines on the report by checking a box on the right side of that row. Checking this box should not delete the data from the database, but will instead only delete the rows from the output of the current report.
3. After selecting rows NOT to show on the report, refresh the report
page. Add a button which says “bill these services?” or print. If “bill
these services” is checked, do the following:
a. Update that record in tblacts.billed with a “1” for each row.
For example:
UPDATE `famsol01_avail`.`tblacts` SET `billed` = ‘1’ WHERE `tblacts`.`actid` =2147190620;
Note that each “row” in an Activity Summary or Billing
Summary report contains one “activity” (tblacts record, which are uniquely identified by an integer (tblacts.actid).
b. After the update, refresh the screen, and include a button allowing the user to download a .csv version of the report data. Allow the user to select the download location. Name the file with this kind of name:
date_time_activitysummary.csv or
date_time_billingsummary.csv
4. Edit the two screens for “Activity Summary” and “Billing Summary” to allow the user (in addition to the other choices available) to choose:
– Show all records, billed* and unbilled**
– Show only billed* records
– Show only unbilled** records
billed* = tblacts.billed has a “1” in it
unbilled** = tblacts.billed has a “0” in it
5. If a user selects to show “billed” items, give the user an option to change the status to “unbilled” by doing this kind of update:
UPDATE `famsol01_avail`.`tblacts` SET `billed` = ‘0’ WHERE `tblacts`.`actid` =2147190620;
6. Make sure that only the “admin” user or one designated as a “1” in
tbladmin.superadmin is allowed to run both the Billing Summary and
Activity Summary. Non-superadmin users (tbladmin.superadmin = 0) can only run the Activity Summary, with their staffname pre-selected. Their staff name should be unchangeable on the Activity Summary Form screen.
The forms are in forms.rar and the reports are in reports.rar. More detailed information can be given to the selected programmer. Thank you very much.