Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (!defined("WHMCS"))
- die("This file cannot be accessed directly");
- $reportdata["title"] = "Clients";
- $filterfields = array("id"=>"ID","firstname"=>"First Name","lastname"=>"Last Name","domain"=>"Domain Name","companyname"=>"Company Name","email"=>"Email","address1"=>"Address 1","address2"=>"Address 2","city"=>"City","state"=>"State","postcode"=>"Postcode","country"=>"Country","phonenumber"=>"Phone Number","currency"=>"Currency","groupid"=>"Client Group ID","credit"=>"Credit","datecreated"=>"Creation Date","notes"=>"Notes","status"=>"Status");
- $reportdata["description"] = $reportdata["headertext"] = '';
- $incfields = $whmcs->get_req_var('incfields');
- $filterfield = $whmcs->get_req_var('filterfield');
- $filtertype = $whmcs->get_req_var('filtertype');
- $filterq = $whmcs->get_req_var('filterq');
- if (!is_array($incfields)) $incfields = array();
- if (!is_array($filterfield)) $filterfield = array();
- if (!is_array($filtertype)) $filtertype = array();
- if (!is_array($filterq)) $filterq = array();
- if (!$print) {
- $reportdata["description"] = "This report can be used to generate a custom export of clients by applying up to 5 filters. CSV Export is available via the download link at the bottom of the page.";
- $reportdata["headertext"] = '<form method="post" action="reports.php?report='.$report.'">
- <table class="form" width="100%" border="0" cellspacing="2" cellpadding="3">
- <tr><td width="20%" class="fieldlabel">Fields to Include</td><td class="fieldarea"><table width="100%"><tr>';
- $i=0;
- foreach ($filterfields AS $k=>$v) {
- $reportdata["headertext"] .= '<td width="20%"><input type="checkbox" name="incfields[]" value="'.$k.'" id="fd'.$k.'"';
- if (in_array($k,$incfields)) $reportdata["headertext"] .= ' checked';
- $reportdata["headertext"] .= ' /> <label for="fd'.$k.'">'.$v.'</labe></td>'; $i++;
- if (($i%5)==0) $reportdata["headertext"] .= '</tr><tr>';
- }
- $reportdata["headertext"] .= '</tr></table></td></tr>';
- for ( $i = 1; $i <= 5; $i ++ ) {
- $reportdata["headertext"] .= '<tr><td width="20%" class="fieldlabel">Filter '.$i.'</td><td class="fieldarea"><select name="filterfield['.$i.']"><option value="">None</option>';
- foreach ($filterfields AS $k=>$v) {
- $reportdata["headertext"] .= '<option value="'.$k.'"';
- if (isset($filterfield[$i]) && $filterfield[$i]==$k) $reportdata["headertext"] .= ' selected';
- $reportdata["headertext"] .= '>'.$v.'</option>';
- }
- $reportdata["headertext"] .= '</select> <select name="filtertype['.$i.']"><option>Exact Match</option><option value="like"';
- if (isset($filtertype[$i]) && $filtertype[$i]=="like") $reportdata["headertext"] .= ' selected';
- $reportdata["headertext"] .= '>Containing</option></select> <input type="text" name="filterq['.$i.']" size="30" value="'.(isset($filterq[$i])?$filterq[$i]:'').'" /></td></tr>';
- }
- $reportdata["headertext"] .= '</table>
- <p align="center"><input type="submit" value="Filter" /></p>
- </form>';
- }
- if (count($incfields)) {
- $filters = array();
- foreach ($filterfield AS $i=>$val) {
- if ($val && array_key_exists($val,$filterfields)) $filters[$val] = ($filtertype[$i]=="like") ? array("sqltype"=>"LIKE","value"=>$filterq[$i]) : $filterq[$i];
- }
- $fieldlist = array();
- foreach ($incfields AS $fieldname) {
- if (array_key_exists($fieldname,$filterfields)) {
- $reportdata["tableheadings"][] = $filterfields[$fieldname];
- $fieldlist[] = $fieldname;
- }
- }
- $result = select_query("tblclients",implode(',',$fieldlist),$filters);
- while ($data = mysql_fetch_assoc($result)) {
- if (isset($data['currency'])) $data['currency'] = get_query_val("tblcurrencies","code",array("id"=>$data['currency']));
- else if (isset($data['domain'])) $data['domain'] = get_query_val("tblhosting","domain",array("id"=>$data['domain']));
- $reportdata["tablevalues"][] = $data;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement