We use cookies to improve your experience on this site. By viewing our pages, you give us consent to use cookies. Find out more.

Don’t invest unless you’re prepared to lose all the money you invest. NextFin promotes high - risk investments and you are unlikely to be protected if something goes wrong.
Take 2 minutes to learn more.

user['id']."' "); $user_referrers = $cms->get('user referrer reports', array('user'=>$auth->user['id']), 1); if (!count($user_referrers)) { die('no referrers'); } $opts['g'] = array( 'referrals' => 'referrals', 'enquiries' => 'enquiries', //'clickthrus' => 'clickthrus', //'funders' => 'funders', ); $opts['s'] = array( 'total' => 'total', 'referrer' => 'referrer', ); $key = 'enquiries'; $heading = 'enquiries'; $tooltip_template = '£<%=number_format(value) %>'; $legend_template = '£<%=number_format(segments[i].value) %>'; $where_str = 'WHERE ('; foreach($user_referrers['referrer'] as $v) { $where_str .= "referrer='".escape($v['value'])."' OR "; } $where_str = substr($where_str, 0, -4); $where_str .= ')'; if ($_GET['download']) { $rows = sql_query("SELECT * FROM raise_finance_contact $where_str AND deleted = 0 "); array_to_csv_file($rows, 'businessagent referrals'); } switch($_GET['s']){ case 'referrer': switch($_GET['g']){ case 'enquiries': $query = "SELECT referrer AS `name`, COUNT(id) AS `enquiries`, DATE_FORMAT(created,'%Y/%m') AS `date` FROM raise_finance_contact $where_str AND deleted = 0 GROUP BY referrer, Year(created), Month(created) ORDER BY date "; break; default: // referraks $query = "SELECT referrer AS `name`, SUM(visits) AS `enquiries`, DATE_FORMAT(date,'%Y/%m') AS `date` FROM referral_visits $where_str GROUP BY referrer, Year(date), Month(date) ORDER BY date "; break; } $stats = sql_query($query); //debug($stats); // get dates $dates = array(); foreach($stats as $k=>$v) { $dates[] = $v['date']; } $dates = array_unique($dates); //print_r($dates);exit; foreach($stats as $v) { $datasets[$v['name']][$v['date']] = $v[$key]; } // fill in missing dates foreach($datasets as $k=>$v) { foreach($dates as $date) { if (!array_key_exists($date, $v)) { $datasets[$k][$date] = 0; } } ksort($datasets[$k]); } //print_r($datasets);exit; $data = array(); $i = 0; foreach ($datasets as $name=>$dataset) { $data['datasets'][$i] = array( 'label'=>$name, 'borderColor' => $colors[$i], 'pointBorderColor' => $colors[$i], 'backgroundColor' => $colors[$i], 'fill' => false, 'data' => array_values($dataset) ); $i++; } foreach($dates as $date) { $data['labels'][] = dateformat('F Y', $date); } //debug($data, true); break; default: switch($_GET['g']){ case 'enquiries': $query = "SELECT COUNT(id) AS `enquiries`, DATE_FORMAT(created,'%Y/%m') AS `date` FROM raise_finance_contact $where_str AND deleted = 0 GROUP BY Year(created), Month(created) ORDER BY date "; break; default: // referrals $query = "SELECT SUM(visits) AS `enquiries`, DATE_FORMAT(date,'%Y/%m') AS `date` FROM referral_visits $where_str GROUP BY Year(date), Month(date) ORDER BY date "; break; } $stats = sql_query($query); $data = array(); $data['datasets'][0] = array( 'label'=>$_GET['s'], 'fillColor' => "rgba(220,220,220,0)", 'strokeColor' => "rgba(220,180,0,1)", 'pointColor' => "rgba(220,180,0,1)", 'fill' => false, 'data' => array() ); foreach($stats as $v) { $data['labels'][] = dateformat('F Y', $v['date']); $data['datasets'][0]['data'][] = $v[$key]; } break; } $title = "Referrer Stats"; $sites = $cms->get('crowdfunding sites', array('stats'=>1), null, 'name'); //debug($stats); $months = array(); foreach($stats as $v){ $months[$v['date']][] = $v; } //debug($months); $pie_data = array(); $other = 0; $i = 0; foreach(current($months) as $site){ if( isset($site['stats']) and $site['stats']==0 ){ $other += $site[$key]; continue; } $pie_data[] = array( 'value' => (int)round($site[$key]), 'color' => $colors[$i], 'highlight' => $highlights[$i], 'label' => $site['name'] ); $i++; } if($other){ $pie_data[] = array( 'value' => (int)round($other), 'color' => $colors[$i], 'highlight' => $colors[$i], 'label' => 'Other' ); } // get enquiries $statuses = sql_query("SELECT application_status, COUNT(*) AS `count`, SUM(amount)/100 AS `commission` FROM raise_finance_contact $where_str AND deleted = 0 GROUP BY application_status "); ?>

Referrer Stats

Show by

All enquiries

Status Count Estimated Commission
£0.00

Download enquiries

  • Internet Business Awards Category Award Winner 2015
  • Hertfordshire Business Awards Finalist 2014

As seen in:

  • The Guardian
  • Financial Times
  • Yahoo! Finance
  • The Times
  • The Daily Telegraph