public function test_getConnection()
{
/** === Setup Mocks === */
$this->mResource->shouldReceive('getConnection')->andReturn($this->mConn);
/** === Call and asserts === */
$res = $this->obj->getConnection();
$this->assertInstanceOf(\Magento\Framework\DB\Adapter\AdapterInterface::class, $res);
}
public static function getNewsList()
{
// Запрос к БД
$conn = Db::getConnection();
$newsList = array();
$sql = 'SELECT id, title, date, short_content ' . 'FROM news ' . 'ORDER BY date DESC ';
$stmt = $conn->prepare($sql);
//dayardayt
/* execute prepared statement */
$stmt->execute();
//zapros
$stmt->store_result();
// zapros
if ($stmt->num_rows > 0) {
$stmt->bind_result($id, $title, $date, $sh_content);
// kelgen maanini yigarat
// output data of each row
$i = 0;
while ($row = $stmt->fetch()) {
$newsList[$i]['id'] = $id;
$newsList[$i]['title'] = $title;
$newsList[$i]['date'] = $date;
$newsList[$i]['sh_content'] = $sh_content;
$i++;
}
}
return $newsList;
}
public static function getNewsList()
{
//запрос к БД
$db = Db::getConnection();
//вызываем метод с параметрами подкдючения к базе данных
$newsList = array();
//Создем пустой масив для сохранения результатов
$result = $db->query('SELECT id,title,date,short_content FROM news LIMIT 4');
//Нужний запрос к БД
if (!$result) {
die("Execute query error");
}
$i = 0;
while ($row = $result->fetch(true)) {
// $row -символизирует строку из базы даных
//В цикле мы записываем необходимые даные в масив результатов
$newsList[$i]['id'] = $row['id'];
$newsList[$i]['title'] = $row['title'];
$newsList[$i]['date'] = $row['date'];
$newsList[$i]['short_content'] = $row['short_content'];
$i++;
}
return $newsList;
//Возвращаем масив
}
public function check()
{
$username = $_POST['username'];
$password = $_POST['password'];
$conn = Db::getConnection();
$sql = "SELECT username, password, admin\n\t\t\t\tFROM users\n\t\t\t\tWHERE username = '******'";
$q = $conn->prepare($sql);
$q->execute();
$users = $q->fetch(\PDO::FETCH_ASSOC);
//var_dump($users);die(' proba');
$logger = new Logger();
$error = $logger->checkCredentials($password, $users);
//$isAdmin = $logger->checkAdmin($password,$users);
//var_dump($error);die(' ajde vise!!!');
if ($error) {
//echo '<pre>'; var_dump($error);die(); echo '</pre>';
$html = new Html($this->controllerName);
$html->error = $error;
//echo '<pre>'; var_dump($html->error);die(); echo '</pre>';
$html->render('index');
} else {
$user = new User($users['username'], $users['admin']);
$user->login();
//var_dump($user);die(' jebem li ga');
header('Location: /');
}
}
public static function Reg($reg_name, $reg_surname, $reg_phone, $reg_email, $reg_location, $reg_password_hash, $reg_avatar)
{
$db = Db::getConnection();
$query = $db->prepare("INSERT INTO registration (reg_id, reg_name, reg_surname, reg_date, reg_phone, reg_email, reg_location, reg_password_hash, vk_account, reg_avatar) \n\t\t\t\t\t\t\t\tVALUES (NULL, :reg_name, :reg_surname, CURRENT_TIMESTAMP, :reg_phone, :reg_email, :reg_location, :reg_password_hash, 0, :reg_avatar);");
$query->execute(array('reg_name' => "{$reg_name}", 'reg_surname' => "{$reg_surname}", 'reg_phone' => "{$reg_phone}", 'reg_email' => "{$reg_email}", 'reg_location' => "{$reg_location}", 'reg_password_hash' => "{$reg_password_hash}", 'reg_avatar' => "{$reg_avatar}"));
return $query;
}
public function create()
{
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = password_hash($_POST['password'], PASSWORD_BCRYPT);
$conn = Db::getConnection();
$sql = "SELECT *\n\t\t\t\tFROM users";
$q = $conn->prepare($sql);
$q->execute();
$users = $q->fetchAll(\PDO::FETCH_ASSOC);
$validator = new Validator();
$error = $validator->validateRegisterForm($_POST, $users);
//echo '<pre>'; var_dump($error); echo '</pre>';die();
if ($error) {
//echo '<pre>'; var_dump($error);die(); echo '</pre>';
$html = new Html($this->controllerName);
$html->error = $error;
//echo '<pre>'; var_dump($html->error);die(); echo '</pre>';
//;kweojn'dlfv'dlfkv
$html->render('index');
} else {
$newUserSql = "INSERT INTO users\n\t\t\t(`firstname`, `lastname`, `email`, `username`, `password`, `admin`)\n\t\t\tVALUES\n\t\t\t('{$firstname}', '{$lastname}', '{$email}', '{$username}', '{$password}', '0')";
$q = $conn->prepare($newUserSql);
$q->execute();
header('Location: /login/index');
}
}
public static function getTotalProductsInCategory($categoryId)
{
$db = Db::getConnection();
$result = $db->query('SELECT count(id) AS count FROM product ' . 'WHERE status="1" AND category_id ="' . $categoryId . '"');
$result->setFetchMode(PDO::FETCH_ASSOC);
$row = $result->fetch();
return $row['count'];
}
public static function GetInfo($reg_id)
{
$db = Db::getConnection();
$query = $db->prepare("SELECT * FROM registration WHERE reg_id = :reg_id;");
$query->execute(array('reg_id' => "{$reg_id}"));
$result = $query->fetch();
return $result;
}
public static function addUser($login, $password)
{
$db = Db::getConnection();
$sql = 'INSERT INTO users (login, password) VALUES (:login, :password)';
$result = $db->prepare($sql);
$result->bindParam(':login', $login, PDO::PARAM_INT);
$result->bindParam(':password', $password, PDO::PARAM_INT);
$result->execute();
return $result->execute();
}
static function table($with_db_name = true)
{
$conn = Db::getConnection('streams');
$prefix = empty($conn['prefix']) ? '' : $conn['prefix'];
$table_name = $prefix . 'notification';
if (!$with_db_name) {
return $table_name;
}
$db = Db::connect('streams');
return $db->dbName() . '.' . $table_name;
}
public static function checkEmailExists($email)
{
$db = Db::getConnection();
$sql = 'SELECT COUNT(*) FROM user WHERE email = :email';
$result = $db->prepare($sql);
$result->bindParam(':email', $email, PDO::PARAM_STR);
$result->execute();
if ($result->fetchColumn()) {
return true;
}
return false;
}
public static function amIAdmin($get_reg_id)
{
$db = Db::getConnection();
$query = $db->prepare("SELECT is_admin FROM registration WHERE reg_id = :reg_id;");
$query->execute(array('reg_id' => "{$get_reg_id}"));
$result = $query->fetch();
if ($result['is_admin'] == 1) {
return True;
} else {
return False;
}
}
public static function getCategoriesList()
{
$db = Db::getConnection();
$categoryList = array();
$result = $db->query('SELECT id, name FROM category ' . 'ORDER BY sort_order ASC');
$i = 0;
while ($row = $result->fetch()) {
$categoryList[$i]['id'] = $row['id'];
$categoryList[$i]['name'] = $row['name'];
$i++;
}
return $categoryList;
}
/**
* Return array with list of works
* @return array
*/
public static function getList()
{
$db = Db::getConnection();
$list = array();
$result = $db->query('SELECT title, link FROM base WHERE type="uslugi"');
$i = 0;
while ($row = $result->fetch()) {
$list[$i]['title'] = $row['title'];
$list[$i]['link'] = $row['link'];
$i++;
}
return $list;
}
/**
* Returns an array of categories
*/
public static function getCategoriesList()
{
$db = Db::getConnection();
$categoryList = array();
$result = $db->prepare('SELECT id, name FROM category ORDER BY sort_order ASC');
$result->execute();
$row = $result->fetchAll(PDO::FETCH_ASSOC);
for ($i = 0; $i < count($row); $i++) {
$categoryList[$i]['id'] = $row[$i]['id'];
$categoryList[$i]['name'] = $row[$i]['name'];
}
return $categoryList;
}
public static function sendPost($title, $short_content, $content, $author_name)
{
$db = Db::getConnection();
$sql = 'INSERT INTO posts (title, short_content, content, author_name) ' . 'VALUE(:title, :short_content, :content, :author_name)';
$result = $db->prepare($sql);
$result->bindParam(":title", $title, PDO::PARAM_STR);
$result->bindParam(":short_content", $short_content, PDO::PARAM_STR);
$result->bindParam(":content", $content, PDO::PARAM_STR);
$result->bindParam(":author_name", $author_name, PDO::PARAM_STR);
$result->execute();
$lastId = $db->lastInsertId();
return $lastId;
}
public static function getShortDescription($type)
{
$db = Db::getConnection();
$description = array();
$result = $db->query("SELECT title, description FROM base WHERE type='{$type}'");
$i = 0;
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
$description[$i]['title'] = $row['title'];
$description[$i]['description'] = $row['description'];
$i++;
}
return $description;
}
public static function getCategoryList()
{
$db = Db::getConnection();
$categoryList = array();
$result = $db->query('SELECT id, name FROM category WHERE status = "1" ORDER BY sort_order, name ASC');
$i = 0;
// var_dump($result);
while ($row = $result->fetch()) {
$categoryList[$i] = array('id' => $row['id'], 'name' => $row['name']);
$i++;
}
return $categoryList;
}
public static function checkUserData($email, $password)
{
$db = Db::getConnection();
$sql = 'SELECT * FROM user WHERE email = :email AND password = :password';
$result = $db->prepare($sql);
$result->bindParam(':email', $email, PDO::PARAM_INT);
$result->bindParam(':password', $password, PDO::PARAM_INT);
$result->execute();
$user = $result->fetch();
if ($user) {
return $user['id'];
}
return false;
}
public static function ViewItemById($id)
{
$id = intval($id);
if ($id) {
$db = Db::getConnection();
$sql = 'SELECT * FROM posts WHERE id= :id';
$result = $db->prepare($sql);
$result->bindParam(":id", $id, PDO::PARAM_INT);
$result->setFetchMode(PDO::FETCH_ASSOC);
$result->execute();
$Item = $result->fetch();
return $Item;
}
}
public static function getNewsList()
{
$db = Db::getConnection();
$newsList = array();
$result = $db->query('SELECT `id`, `title`, `date`,`short_content` FROM `news` ORDER BY `date` DESC LIMIT 10');
$i = 0;
while ($row = $result->fetch()) {
$newsList[$i]['id'] = $row['id'];
$newsList[$i]['title'] = $row['title'];
$newsList[$i]['date'] = $row['date'];
$newsList[$i]['short_content'] = $row['short_content'];
$i++;
}
return $newsList;
}
/**
* Returns an array of news item
*/
public static function getNewsList()
{
$db = Db::getConnection();
$newsList = array();
$result = $db->query('SELECT id, title, date, short_content ' . 'FROM news ' . 'ORDER BY date DESC ' . 'LIMIT 10');
$i = 0;
while ($row = $result->fetch()) {
$newsList[$i]['id'] = $row['id'];
$newsList[$i]['title'] = $row['title'];
$newsList[$i]['date'] = $row['date'];
$newsList[$i]['short_content'] = $row['short_content'];
$i++;
}
return $newsList;
}
public function index()
{
$conn = Db::getConnection();
$articleModel = new Article();
$firstFiveArticles = $articleModel->getArticles($conn, 5);
//var_dump($firstFiveArticles);die('lele');
foreach ($firstFiveArticles as &$article) {
$article['time'] = $articleModel->formatArticleDate($article["time"]);
//date("d.m.Y H:i",strtotime($article["time"]))
}
$html = new Html($this->controllerName);
$html->firstFiveArticles = $firstFiveArticles;
$html->render('home');
//var_dump($result);die();
}
/**
* Retrieve the table name to use in SQL statement
* @method table
* @static
* @param {boolean} [$with_db_name=true] Indicates wheather table name should contain the database name
* @return {string|Db_Expression} The table name as string optionally without database name if no table sharding
* was started or Db_Expression class with prefix and database name templates is table was sharded
*/
static function table($with_db_name = true)
{
if (Q_Config::get('Db', 'connections', 'Metrics', 'indexes', 'Session', false)) {
return new Db_Expression(($with_db_name ? '{$dbname}.' : '') . '{$prefix}' . 'session');
} else {
$conn = Db::getConnection('Metrics');
$prefix = empty($conn['prefix']) ? '' : $conn['prefix'];
$table_name = $prefix . 'session';
if (!$with_db_name) {
return $table_name;
}
$db = Db::connect('Metrics');
return $db->dbName() . '.' . $table_name;
}
}
/**
* Returns an array of recommended products
*/
public static function getRecommendedProducts()
{
$db = Db::getConnection();
$productsList = array();
$result = $db->query('SELECT id, name, price, image, is_new FROM product ' . 'WHERE status = "1" AND is_recommended = "1"' . 'ORDER BY id DESC ');
$i = 0;
while ($row = $result->fetch()) {
$productsList[$i]['id'] = $row['id'];
$productsList[$i]['name'] = $row['name'];
$productsList[$i]['image'] = $row['image'];
$productsList[$i]['price'] = $row['price'];
$productsList[$i]['is_new'] = $row['is_new'];
$i++;
}
return $productsList;
}
/**
* Returns an array of blog items
*/
public static function getBlogList()
{
$db = Db::getConnection();
$blogList = array();
$result = $db->prepare('SELECT id, title, date, short_content FROM blog ORDER BY date DESC LIMIT 3');
$result->execute();
$i = 0;
while (($row = $result->fetch_assoc()) != false) {
$blogList[$i]['id'] = $row['id'];
$blogList[$i]['title'] = $row['title'];
$blogList[$i]['date'] = $row['date'];
$blogList[$i]['short_content'] = $row['short_content'];
$i++;
}
return $blogList;
}
public static function getTopList()
{
$db = Db::getConnection();
$topList = array();
$result = $db->query('SELECT id, title, date, short_content, author_name ' . 'FROM posts ' . 'ORDER BY title DESC ' . 'LIMIT 3');
$i = 0;
while ($row = $result->fetch()) {
$topList[$i]['id'] = $row['id'];
$topList[$i]['title'] = $row['title'];
$topList[$i]['data'] = $row['date'];
$topList[$i]['short_content'] = $row['short_content'];
$topList[$i]['author_name'] = $row['author_name'];
$i++;
}
return $topList;
}
public function tag($tag)
{
//die($type);
$conn = Db::getConnection();
//U tabeli tags treba naci id od prosledjenog taga $search,
//nakon toga naci u tabeli articles-tags id-ove svih articles
//koji imaju taj search
$sql = "SELECT articles.id, time, title, img, teaser\n\t\t\t\tFROM articles\n\t\t\t\t JOIN articles_tags ON articles.id = article_id\n\t\t\t\t JOIN tags ON tag_id = tags.id\n\t\t\t\tWHERE tags.name = '{$tag}'";
$q = $conn->prepare($sql);
$q->execute();
$articlesByTags = $q->fetchAll(\PDO::FETCH_ASSOC);
//var_dump($tagIdsArray);die(' da vidimo!!!');
$html = new Html($this->controllerName);
$html->articlesByTags = $articlesByTags;
$html->render('tag');
}
public function getSubCategoriesListAdmin()
{
$db = Db::getConnection();
$id = self::getCategoriesListAdmin();
$result = $db->query('SELECT `id`,`title`,`id_scategories`
FROM `sub_categories`');
$subCategotyList = array();
$i = 0;
while ($row = $result->fetch()) {
$subCategotyList[$i]['id'] = $row['id'];
$subCategotyList[$i]['title'] = $row['title'];
$subCategotyList[$i]['id_scategories'] = $row['id_scategories'];
$i++;
}
return $subCategotyList;
}
public static function save($userName, $userPhone, $userCity, $userAddress, $userComment, $userId, $products)
{
$db = Db::getConnection();
$sql = 'INSERT INTO product_order (user_name,user_phone,user_city,user_address,user_comment,id_user,products)
VALUES (:user_name, :user_phone,:user_city,:user_address,:user_comment, :user_id, :products)';
$products = json_encode($products);
$result = $db->prepare($sql);
$result->bindParam(':user_name', $userName, PDO::PARAM_STR);
$result->bindParam(':user_phone', $userPhone, PDO::PARAM_STR);
$result->bindParam(':user_city', $userCity, PDO::PARAM_STR);
$result->bindParam(':user_address', $userAddress, PDO::PARAM_STR);
$result->bindParam(':user_comment', $userComment, PDO::PARAM_STR);
$result->bindParam(':user_id', $userId, PDO::PARAM_STR);
$result->bindParam(':products', $products, PDO::PARAM_STR);
return $result->execute();
}
