public function show($email)
{
$passwordReset = R::getRow('SELECT `users`.`id` AS `userId`, `passwordResets`.`id`, `passwordResets`.`token`, `passwordResets`.`created`
FROM ( `users` )
LEFT JOIN `passwordResets`
ON ( `passwordResets`.`userId` = `users`.`id` )
WHERE `users`.`email` = :email', [':email' => $email]);
return !empty($passwordReset) ? $passwordReset : false;
}
public static function login($username, $password)
{
$row = R::getRow("SELECT * FROM `user` WHERE username = ? ", array($username));
if ($row != null && password_verify($password, $row["password"])) {
$_SESSION["username"] = $username;
$_SESSION["password"] = $password;
return true;
} else {
unset($_SESSION["username"]);
unset($_SESSION["password"]);
return false;
}
}
public function index()
{
$perPage = 10;
$page = @$_GET['page'] ? $_GET['page'] : 1;
$start = ($page - 1) * $perPage;
$items = R::find('contactdealer', 'LIMIT ?,?', [$start, $perPage]);
$count = R::count('contactdealer');
foreach ($items as &$item) {
$item->ownProvince = R::getRow('SELECT * FROM provinces WHERE province_id=?', [$item->province_id]);
$item->ownGeography = R::getRow('SELECT * FROM geography WHERE geo_id=?', [$item->geo_id]);
// var_dump($item); exit();
}
$maxPage = floor($count / $perPage) + ($count % $perPage == 0 ? 0 : 1);
$this->slim->render("contactdealer/list.php", ['items' => $items, 'page' => $page, 'maxPage' => $maxPage]);
}
public function save()
{
if (!$this->emptyAttr('id')) {
$contactDealer = R::findOne('contactdealer', 'id=?', [$this->getAttr('id')]);
$contactDealer->updated_at = date('Y-m-d H:i:s');
} else {
$contactDealer = R::dispense('contactdealer');
$contactDealer->created_at = date('Y-m-d H:i:s');
$contactDealer->updated_at = date('Y-m-d H:i:s');
}
$contactDealer->name = $this->getAttr('name');
$contactDealer->address = $this->getAttr('address', '');
$contactDealer->phone = $this->getAttr('phone', '');
$contactDealer->province_id = $this->getAttr('province_id', '');
$contactDealer->geo_id = $this->getAttr('geo_id', '');
$contactDealer->lat = $this->getAttr('lat', '');
$contactDealer->lng = $this->getAttr('lng', '');
$province = R::getRow('SELECT * FROM provinces WHERE province_id = ?', [$contactDealer->province_id]);
if ($province) {
$contactDealer->geo_id = $province['geo_id'];
}
$success = R::store($contactDealer);
return $success;
}
public function addRoomUse()
{
$productId = $this->slim->request->post()['product_id'];
$roomName = $this->slim->request->post()['room_name'];
$item = R::findOne('product', 'id=?', [$productId]);
if (!$item) {
header('Content-Type: application/json');
echo json_encode(['error' => 'NOT_FOUND_PRODUCT'], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
exit;
}
$dateStr = date('Y-m-d');
$productView = R::getRow('SELECT * FROM product_room WHERE product_id=? AND room_name=? AND view_date=?', [$productId, $roomName, $dateStr]);
if (!$productView) {
R::exec('INSERT INTO product_room SET product_id=?, room_name=? , view_date=?', [$productId, $roomName, $dateStr]);
}
R::exec('UPDATE product_room SET view_count = view_count+1 WHERE product_id=? AND room_name=? AND view_date=?', [$productId, $roomName, $dateStr]);
header('Content-Type: application/json');
echo json_encode(['successs' => true], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
exit;
}
public function productAddStat($productId)
{
$dateStr = date('Y-m-d');
$productView = R::getRow('SELECT * FROM product_add WHERE product_id=? AND add_date=?', [$productId, $dateStr]);
if (!$productView) {
R::exec('INSERT INTO product_add SET product_id=?, add_date=?', [$productId, $dateStr]);
}
R::exec('UPDATE product_add SET add_count = add_count+1 WHERE product_id=? AND add_date=?', [$productId, $dateStr]);
header('Content-Type: application/json');
echo json_encode(['success' => true], JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
exit;
}
public function build(&$item)
{
$item['province'] = R::getRow('SELECT * FROM provinces WHERE province_id=?', [$item['province_id']]);
$item['geography'] = R::getRow('SELECT * FROM geography WHERE geo_id=?', [$item['geo_id']]);
}