<?php

$link = mysqli_connect("192.168.82.50", "root", "yb9738z", "fullerton");

if(!link)
{
die("Connection Failed!".mysqli_connect_error());
}

$query = "SELECT count(cca.crm_id) as calls,cca.user_id as user_id,r.lan,r.mobile,r.client,r.status,r.dialer_status,r.dialer_substatus FROM records as r left join crmcalls_archive as cca on r.id=cca.crm_id group by cca.number";
$sql = mysqli_query($link, $query);
$sqlResult = mysqli_fetch_all($sql,MYSQLI_ASSOC);

$uquery ="SELECT id,username,fullname as telecaller FROM users";
$usql = mysqli_query($link, $uquery);
$usqlResult = mysqli_fetch_all($usql, MYSQLI_ASSOC);

foreach($usqlResult as $ures)
{
	$userArr[$ures['id']] = $ures; 
}

$reportArr = array();

foreach($sqlResult as $res)
{
	$tuser = $userArr[$res['user_id']];
	$res['user_id']=$tuser['username'];
	$reportArr[] = $res;
}

header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="alldump.csv";');

$headers = ['Attemps','Agent','lan','mobile','client','status','dialer_status','dialer_substatus'];

$f = fopen('php://output','w');

fputcsv($f, $headers);

foreach($reportArr as $arr)
{
	fputcsv($f, $arr);
}

mysqli_close($link);

?>