1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / www / public / functions /
Filename : preferences.php
back
<?php
require_once __DIR__ . '/../../config/gl_config.php';
require_once __DIR__ . '/helpers.php'; // Ensure helpers.php is included for db_select

function record_user_preference($user_id, $action_type, $item_id) {
    // Map action_type to interaction_type (simplified mapping)
    $interaction_type = ($action_type === 'signup') ? 'signup' : 'view_service'; // Adjust mapping as needed
    $sql = "INSERT INTO user_interactions (user_id, service_id, interaction_type, created_at) VALUES (?, ?, ?, NOW())";
    return db_prepare_execute($sql, [$user_id, $item_id, $interaction_type], 'iis') !== false;
}

function get_user_preferences($user_id) {
    $sql = "SELECT interaction_type, service_id as item_id, COUNT(*) as frequency FROM user_interactions WHERE user_id = ? GROUP BY interaction_type, service_id ORDER BY frequency DESC";
    $result = db_select($sql, [$user_id], 'i');
    return $result ?: []; // Return empty array if result is false
}

function suggest_items($user_id, $limit = 5) {
    $preferences = get_user_preferences($user_id);
    if (empty($preferences)) {
        // Fallback: Suggest popular items across all users
        $sql = "SELECT service_id as item_id, COUNT(*) as global_freq FROM user_interactions GROUP BY service_id ORDER BY global_freq DESC LIMIT ?";
        $popular_items = db_select($sql, [$limit], 'i') ?: [];
        $suggestions = [];
        foreach ($popular_items as $item) {
            $sql = "SELECT id, name, price FROM services WHERE id = ? LIMIT 1";
            $service = db_select($sql, [$item['item_id']], 'i');
            if ($service && !empty($service)) {
                $suggestions[] = $service[0];
            }
            if (count($suggestions) >= $limit) break;
        }
        return $suggestions;
    }

    $suggestions = [];
    foreach ($preferences as $pref) {
        if (in_array($pref['interaction_type'], ['view_service', 'signup'])) { // Adjust based on valid interaction_types
            $sql = "SELECT id, name, price FROM services WHERE id = ? LIMIT 1";
            $service = db_select($sql, [$pref['item_id']], 'i');
            if ($service && !empty($service)) {
                $suggestions[] = $service[0];
            }
        }
        if (count($suggestions) >= $limit) break;
    }
    return $suggestions;
}