File manager - Edit - /home/webapp69.cm.in.th/u69319090028/Shop/app/Models/UserAddress.php
Back
<?php /** * UserAddress Model * Maps to `user_addresses` table */ require_once __DIR__ . '/../Core/Model.php'; class UserAddress extends Model { protected string $table = 'user_addresses'; public function getByUserId(int $userId): array { $sql = "SELECT * FROM `user_addresses` WHERE `user_id` = :user_id ORDER BY `is_default` DESC, `id` DESC"; return $this->fetchAll($sql, [':user_id' => $userId]); } public function getDefaultAddress(int $userId): ?array { $sql = "SELECT * FROM `user_addresses` WHERE `user_id` = :user_id AND `is_default` = 1 LIMIT 1"; return $this->fetchOne($sql, [':user_id' => $userId]); } public function findUserAddress(int $addressId, int $userId): ?array { $sql = "SELECT * FROM `user_addresses` WHERE `id` = :id AND `user_id` = :user_id LIMIT 1"; return $this->fetchOne($sql, [':id' => $addressId, ':user_id' => $userId]); } public function clearDefault(int $userId): void { $sql = "UPDATE `user_addresses` SET `is_default` = 0 WHERE `user_id` = :user_id"; $this->query($sql, [':user_id' => $userId]); } public function setDefault(int $addressId, int $userId): bool { $this->clearDefault($userId); $sql = "UPDATE `user_addresses` SET `is_default` = 1 WHERE `id` = :id AND `user_id` = :user_id"; $this->query($sql, [':id' => $addressId, ':user_id' => $userId]); return true; } public function countUserAddresses(int $userId): int { $sql = "SELECT COUNT(*) FROM `user_addresses` WHERE `user_id` = :user_id"; $stmt = $this->query($sql, [':user_id' => $userId]); return (int)$stmt->fetchColumn(); } }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.25 |
proxy
|
phpinfo
|
Settings