1, 'unapprove' => 0] as $action => $flag) {
if ($v = e_get($action)) {
$guard();
db()->prepare("UPDATE reviews SET is_approved = ? WHERE id = ?")->execute([$flag, (int)$v]);
flash('ok', $flag ? 'Review published.' : 'Review taken down.');
redirect($back);
}
}
if ($del = e_get('delete')) {
$guard();
$st = db()->prepare("SELECT image_path FROM reviews WHERE id = ?");
$st->execute([(int)$del]);
if ($r = $st->fetch()) {
// shared stock images (review1.png ... review11.png) are never removed from disk
if ($r['image_path'] && !preg_match('/^review\d+\.png$/', $r['image_path'])) {
$f = __DIR__ . '/../uploads/vehicles/' . basename($r['image_path']);
if (is_file($f)) @unlink($f);
}
}
db()->prepare("DELETE FROM reviews WHERE id = ?")->execute([(int)$del]);
flash('ok', 'Review deleted.');
redirect($back);
}
if ($siteId) {
$st = db()->prepare("SELECT r.* FROM reviews r
JOIN review_sites rs ON rs.review_id = r.id
WHERE rs.site_id = ?
ORDER BY r.is_approved ASC, r.created_at DESC LIMIT 300");
$st->execute([$siteId]);
} else {
$st = db()->query("SELECT r.* FROM reviews r ORDER BY r.is_approved ASC, r.created_at DESC LIMIT 300");
}
$reviews = $st->fetchAll();
// which sites each review is shown on, in one query
$map = [];
if ($reviews) {
$ids = implode(',', array_map(fn($r) => (int)$r['id'], $reviews));
foreach (db()->query("SELECT rs.review_id, s.company_name FROM review_sites rs
JOIN sites s ON s.id = rs.site_id
WHERE rs.review_id IN ($ids) ORDER BY s.company_name")->fetchAll() as $r) {
$map[(int)$r['review_id']][] = $r['company_name'];
}
}
$pending = (int)db()->query("SELECT COUNT(*) c FROM reviews WHERE is_approved = 0")->fetch()['c'];
admin_head('Reviews');
admin_topbar('Reviews', '+ Add review');
?>