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 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 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 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 checkLinkExpiry($emailParam, $tokenValue, $connect) { $db = new db_config(); $sql = $db->mquery("SELECT * FROM users WHERE email = '" . $emailParam . "' AND token ='" . $tokenValue . "'", $connect); $num = $db->numhasrows($sql); $row = $db->fetchobject($sql); $token = $db->strip($row->token); //sha1 chars $time_token = $db->strip($row->time_token); //UNIX timestamp used for expiry - generated during signup $datetime = $row->timestamp; //date time object generated during signup //$time_token and $datetime has different formats but has equal values //use: //date('Y-m-d H:i:s', $time_token) - to convert the unix time format to date time format //strtotime($datetime->format("Y-m-d H:i:s")); - the date time format to unix time format if ($num == 0) { $data = ''; } else { $expiry_date = $time_token; $data = ''; $data = $expiry_date; } return $data; }
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; }