• Howdy! Welcome to our community of more than 130.000 members devoted to web hosting. This is a great place to get special offers from web hosts and post your own requests or ads. To start posting sign up here. Cheers! /Peo, FreeWebSpace.net

WHMCS Custom Reports

LSComputers

Well-Known Member
NLC
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

Well-Known Member
NLC
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";

?>
 
Top