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 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;
}
