WHMCS Custom Reports

[LSComputers]

Hey All,

I have a client who has grown significantly over the last year, at this time they are looking to generate some significant reporting for their hosting business.

The requirements are as follows:

Report Cancelled/Terminated sorted by a specific Date Range (Monthly, Quarterly, Yearly, Custom)

1) Client ID

2) Detail Plan Type (Shared, Reseller, VPS, Dedicated)

3) Detail Addon's (Domain, Licenses, IP's)

4) Reason for Termination

Note, this would all be displaying on 1 report. With #'s being the colum.

If anyone can confirm the build for this and possibly a cost that would help me out greatly!

 

[LSComputers]

Update:

I have been able to gather the following, however calling specific area's in the database is not my speciality.

<?php

# The title of your report
$reportdata["title"] = "Account Cancellations";

# The description of your report
$reportdata["description"] = "";

# Header text - this gets displayed above the report table of data
$reportdata["headertext"] = "Header - Detailed Report for the selected period";

$reportdata["headertext"] = '<form method="post" action="reports.php?report=Cancellation">Date Range: <input type="text" name="datefrom" value="'.$datefrom.'" class="datepick" /> to <input type="text"

name="dateto" value="'.$dateto.'" class="datepick" /> (Leave blank for all time) <input type="submit" value="Generate Report" /></form>';


# Report Table of Data Column Headings - should be an array of values
$reportdata["tableheadings"] = array("Client Name & ID","Account Type & Plan","Add-ons","Termination Reason");

# Report Table Values - one of these lines for each row you want in the table
# should be an array of values to match the column headings
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");
$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3","Data 4");



# Report Footer Text - this gets displayed below the report table of data
$data["footertext"] = "Footer - Detailed Report for the selected period";

?>