Phoca Forum

Code: Select all

/**
     * Assigns user to Phoca Cart customer groups based on their custom date of birth field.
     * Users older than 60 years should be assigned to a specific group.
     *
     * @param   int  $userId
     *
     * @since 4.1.0
     */
    private function assignRegistrationGroups(int $userId): void
    {
        if (!$this->loadPhocaCart()) {
            return;
        }

        $db = Factory::getDBO();

        // Fetch the user's date of birth from custom fields table
        $query = $db->getQuery(true)
            ->select($db->qn('value'))
            ->from($db->qn('#__fields_values')) // Custom fields are stored in #__fields_values table
            ->where($db->qn('item_id') . ' = ' . (int)$userId) // item_id corresponds to the user ID
            ->where($db->qn('field_id') . ' = ' . $db->quote($this->params->get('dob_custom_field_id'))); // Fetching value by custom field ID

        $db->setQuery($query);

        $dob = $db->loadResult();

        // Check if DOB exists
        if (!$dob) {
            return;
        }

        // Calculate age based on the date of birth
        $dobDate = new DateTime($dob);
        $currentDate = new DateTime();
        $age = $currentDate->diff($dobDate)->y;

        // Senior group ID - configured in the plugin parameters
        $groupIdForSenior = $this->params->get('senior_group_id', 2); // Default group ID 2

        // Check if the user is older than 60
        if ($age > 60) {
            // Fetch other customer groups
            $query = $db->getQuery(true)
                ->select($db->qn('id'))
                ->from($db->qn('#__phocacart_groups'))
                ->where($db->qn('activate_registration') . ' = 1 OR ' . $db->qn('id') . ' = 1');

            $db->setQuery($query);
            $groups = $db->loadColumn();

            if ($groups) {
                // Add the senior group to the list of groups
                $groups[] = $groupIdForSenior;

                // Store the groups for the user
                if (PhocacartGroup::storeGroupsById((int)$userId, 1, $groups)) {
                    // Successful assignment
                } else {
                    // Failed assignment
                }
            }
        }
    }

Code: Select all

 // Assign user to customer groups based on settings
        if ($isnew) {
            $this->assignRegistrationGroups($user['id']);
        } else {
            // Call assignRegistrationGroups to check for existing users as well
            $this->assignRegistrationGroups($user['id']);