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 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 queryCheck($email, $activationcode, $connect)
{
$db = new db_config();
if ($activationcode == 0) {
$sql = $db->mquery("SELECT * FROM users", $connect);
$row = $db->fetchobject($sql);
print_r($row);
} else {
}
}
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;
}
}
public function registerInterest($data, $connect)
{
$db = new db_config();
$dbCheck = new db_config();
$email_data = $data['@email'];
$sqlCheck = $dbCheck->mquery("SELECT * FROM register_interest WHERE email = '" . $email_data . "'", $connect);
$num = $dbCheck->numhasrows($sqlCheck);
$row = $dbCheck->fetchobject($sqlCheck);
if ($num == 0) {
$sql = $db->mquery_insert("dbo.registerInterest", $data, $connect);
header("location: confirmation?register_success=true");
} else {
$sql = $db->mquery_insert("dbo.registerInterest", $data, $connect);
header("location: confirmation?register_success=true");
//note: for the meantime duplicates are okay
//header ("location: index.php?emailcheck=true");
}
}
public function getBills($accountNum, $connect)
{
$db = new db_config();
$data = '';
$sql = $db->mquery("EXEC dbo.getbill_upload @account_number = '" . $accountNum . "'", $connect);
$num = $db->numhasrows($sql);
$uploadedbills = array();
$i = 0;
while ($row = $db->fetchobject($sql)) {
$ctr = $i++;
$bill_id = $db->strip($row->id);
$bill_date = $db->strip($row->bill_date);
$data .= '<li id="btype_' . $ctr . '" onclick="btype_data(\'' . $ctr . '\', \'' . $bill_date . '\');" rel="' . $ctr . '" class="btype">';
$data .= '<a tabindex="-1" href="#" class="opt"><span class="pull-left">' . $bill_date . '</span></a>';
$data .= '</li>';
}
return $data;
}
