"ID","firstname"=>"First Name","lastname"=>"Last 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"] = ''; if (!isset($_GET['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"] = '

'; for ( $i = 1; $i <= 5; $i ++ ) { $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= '

Fields to Include	'; $i=0; foreach ($filterfields AS $k=>$v) { $reportdata["headertext"] .= ''; $i++; if (($i%5)==0) $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= ' '.$v.'
Filter '.$i.'	None'; foreach ($filterfields AS $k=>$v) { $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= ' Exact Match

'; } if (isset($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 = ''; foreach ($incfields AS $fieldname) { if (array_key_exists($fieldname,$filterfields)) { $reportdata["tableheadings"][] = $filterfields[$fieldname]; $fieldlist .= $fieldname.','; } } $fieldlist = substr($fieldlist,0,-1); $result = select_query("tblclients",$fieldlist,$filters); while ($data = mysql_fetch_assoc($result)) { if (isset($data['currency'])) $data['currency'] = get_query_val("tblcurrencies","code",array("id"=>$data['currency'])); $reportdata["tablevalues"][] = $data; } } ?>