public function getContactHistory($phoneNum, $returnTag, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC dbo.show_ContactName @phone_number = '" . $phoneNum . "'", $connect);
$num = $db->numrows($sql);
while ($row = $db->fetchobject($sql)) {
$name = $db->strip($row->Name);
$caller_tag = $db->strip($row->Caller_Tag);
if ($caller_tag == 'P') {
$caller_tag_image = 'images/image-personal-tag-hp.png';
} else {
if ($caller_tag == 'W') {
$caller_tag_image = 'images/image-work-tag-hp.png';
} else {
$caller_tag_image = 'images/image-untagged-tag-hp.png';
}
}
$data = $name;
$data_tag = $caller_tag_image;
}
if ($returnTag == 'y') {
return $data_tag;
} else {
return $data;
}
}
public function generateCSVData($filterFields, $accountNum, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC dbo.getCalls @caller_tag = '" . $filterFields . "', @account_number = '" . $accountNum . "'", $connect);
$num = $db->numrows($sql);
$HeadingsArray = array('Caller tag', 'Date', 'Time', 'Contact Name', 'Phone number', 'Duration', 'Estimated cost', 'Actual cost', 'Bill issued');
$csvContent = implode(",", $HeadingsArray) . "\n";
while ($row = $db->fetchobject($sql)) {
$valuesArray['caller_tag'] = $db->strip($row->caller_tag);
$call_date = $db->strip($row->call_date);
$valuesArray['call_date_format'] = date('d M', strtotime($call_date));
$valuesArray['time'] = $db->strip($row->time);
$valuesArray['contact_name'] = $db->strip($row->contact_name);
$valuesArray['phone_number'] = $db->strip($row->phone_number);
$date = new DateTime('2000-01-01');
$date->add(new DateInterval('P0Y0M0DT0H0M' . $row->duration . 'S'));
$valuesArray['duration'] = $date->format('i\\m s\\s');
$valuesArray['estimated_cost'] = $db->strip($row->estimated_cost);
$valuesArray['actual_cost'] = $db->strip($row->actual_cost);
$valuesArray['bill_issued'] = $db->strip($row->bill_issued);
$csvContent .= implode(",", $valuesArray) . "\r\n";
unset($valuesArray);
}
$fileName = date("Y-m-d") . "_export.csv";
header('Content-Type: text/csv');
header("Content-length: " . filesize($fileName));
header('Content-Disposition: inline; filename="' . $fileName . '"');
echo $csvContent;
}
public function getBills($accountNum, $isNumRows, $connect)
{
$dbCon = new db_config();
$data = '';
$sqlQ = $dbCon->mquery("EXEC dbo.getbill_upload @account_number = '" . $accountNum . "'", $connect);
$num = $dbCon->numrows($sqlQ);
$counter = 1;
while ($row = $dbCon->fetcharray($sqlQ, SQLSRV_FETCH_ASSOC)) {
//use fetcharray function here not object
$upload_date = date_format($row['upload_date'], 'd M Y');
$bill_name = $dbCon->strip($row['bill_name']);
$bill_date = $dbCon->strip($row['bill_date']);
$data .= "<tr>";
$data .= "<td>" . $upload_date . "</td>";
$data .= "<td>" . $bill_name . "</td>";
$data .= "<td>" . $bill_date . "</td>";
$data .= "</tr>";
//$totalContacts = $counter++;
}
if ($isNumRows == 'y') {
//return $totalContacts;
} else {
return $data;
}
}
public function getHistory($phoneNum, $accountNum, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC dbo.getcallhistory @phone_number = '" . $phoneNum . "', @account_number = '" . $accountNum . "'", $connect);
$num = $db->numrows($sql);
while ($row = $db->fetchobject($sql)) {
$call_date = $db->strip($row->call_date);
$call_date_format = date('d M', strtotime($call_date));
$time = $db->strip($row->time);
$call_id = $db->strip($row->call_id);
$contact_name = $db->strip($row->contact_name);
$phone_number = $db->strip($row->phone_number);
$date = new DateTime('2000-01-01');
$date->add(new DateInterval('P0Y0M0DT0H0M' . $row->duration . 'S'));
//$duration = $date->format('H:i:s');
$duration = $date->format('i\\m s\\s');
$estimated_cost = $db->strip($row->estimated_cost);
$actual_cost = $db->strip($row->actual_cost);
$caller_tag = $db->strip($row->caller_tag);
$bill_issued = $db->strip($row->bill_issued);
$data .= "<tr>";
$data .= "<td>" . $call_date_format . "</td>";
$data .= "<td>" . $time . "</td>";
$data .= "<td>" . $duration . "</td>";
$data .= "<td>" . "\$" . number_format($estimated_cost, 2) . "</td>";
$data .= "<td>" . "\$" . number_format($actual_cost, 2) . "</td>";
$data .= "<td>" . $bill_issued . "</td>";
$data .= "</tr>";
}
return $data;
}
public function getReports($accountNum, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC callchart @acct_no = '" . $accountNum . "'", $connect);
$num = $db->numrows($sql);
$callers = array();
while ($row = $db->fetcharray($sql)) {
$fields[0] = $row[caller_tag];
$fields[1] = $row[No_of_Calls];
array_push($callers, $fields);
}
print json_encode($callers, JSON_NUMERIC_CHECK);
//return $data;
}
public function loginPage($username, $password, $connect)
{
$db = new db_config();
$sql = "SELECT * FROM tbl_users WHERE username = '******' AND password = '******'";
$result = mysqli_query($connect, $sql);
$num = $db->numrows($result);
$row = $db->fetcharray($result);
if ($num == 0) {
echo "user not existing";
} else {
$data = '';
$username = $row['username'];
$is_admin = $row['is_admin'];
$brand_name = $row['brand_name'];
$id = $row['id'];
if ($is_admin == 1) {
session_start();
$_SESSION['session_userid'] = $username;
$_SESSION['session_is_admin'] = $is_admin;
$_SESSION['brand_name'] = $brand_name;
$_SESSION['id'] = $id;
session_write_close();
header("Location: index.php");
} else {
if ($is_admin == 0) {
session_start();
$_SESSION['session_userid'] = $username;
$_SESSION['session_is_admin'] = $is_admin;
$_SESSION['brand_name'] = $brand_name;
$_SESSION['id'] = $id;
session_write_close();
header("Location: /user/index.php");
}
}
}
return $data;
}
public function getContacts($accountNum, $isNumRows, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC dbo.getContacts @account_number = '" . $accountNum . "'", $connect);
$num = $db->numrows($sql);
$counter = 1;
while ($row = $db->fetchobject($sql)) {
$phone_number = $db->strip($row->Phonenumber);
$name = $db->strip($row->Name);
$caller_tag = $db->strip($row->Caller_tag);
$data .= "<tr>";
$data .= "<td>" . $phone_number . "</td>";
$data .= "<td>" . $name . "</td>";
$data .= "<td>" . $caller_tag . "</td>";
$data .= "</tr>";
$totalContacts = $counter++;
}
if ($isNumRows == 'y') {
return $totalContacts;
} else {
return $data;
}
}
