ClicShopping #347

      return true;
    }
    $finfo = finfo_open(FILEINFO_MIME_TYPE);
    $mimeType = finfo_file($finfo, $filePath);
    finfo_close($finfo);
finfo_close() has been deprecated in PHP 8.5 and will be removed from PHP in the next major version.
Time to fix: about 2 hours
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 12:13:22 +0000 by clicshopping
                    
    // Define allowed MIME types based on configured extensions
    $allowedMimeTypes = [
      // Images
      'image/jpeg' => ['jpg', 'jpeg'],

      curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params));
    }
    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
curl_close() has been deprecated in PHP 8.5 and will be removed from PHP in the next major version.
Time to fix: about 2 hours
Read doc Permalink Copy Prompt

                                    Last edited Sun, 26 Apr 2026 14:05:24 +0000 by clicshopping
                    
    if ($response === false) {
      return ['error' => ['message' => 'Stripe API request failed (curl).']];
    }

    // Check if detected MIME type matches expected extension
    foreach ($allowedMimeTypes as $mime => $extensions) {
      if ($mimeType === $mime) {
        $fileExtension = $this->getExtension();
        return in_array($fileExtension, $extensions);
in_array() should be called with the third parameter set to true to enable strict comparison and avoid type juggling bugs.
Time to fix: about 15 minutes
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 12:13:22 +0000 by clicshopping
                    
      }
    }
    // If MIME type not in whitelist, reject
    return false;

      // Fallback: use multiple sources of entropy
      // This should never happen on PHP 7.0+ but provides safety
      $fallback = hash('sha256', 
        uniqid('antispam_', true) . 
        microtime(true) . 
        mt_rand() . 
The function mt_rand() is not cryptographically secure. Use random_int() or random_bytes() instead.
Time to fix: about 2 hours
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 13:31:37 +0000 by clicshopping
                    
        (function_exists('random_bytes') ? bin2hex(random_bytes(16)) : '')
      );
      trigger_error(
        'Failed to generate cryptographically secure secret, using fallback. Error: ' . $e->getMessage(),

      if (strpos($error, 'Hybrid result missing') !== false) {
        return "I couldn't complete your request because some of the required information is missing. Please try breaking your question into smaller parts or asking about something else.";
      }
      // Pattern: "Empty response"
      if (strpos($error, 'empty') !== false || strpos($error, 'Empty') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
        return "I couldn't find any results for your query. The information you're looking for might not be available in the system yet. Please try rephrasing your question or asking about something else.";
      }
    }
    // Default fallback message

        // Semantic results MUST have sources OR data, unless it's a valid LLM/memory fallback
        if (!$hasSources) {
          $sourceType = strtolower($finalResult['source_attribution']['source_type'] ?? '');
          $isLLMFallback = $hasTextResponse && (
            strpos($sourceType, 'llm') !== false ||
            strpos($sourceType, 'general knowledge') !== false ||
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
            strpos($sourceType, 'conversation') !== false ||
            strpos($sourceType, 'memory') !== false
          );
          if (!$isLLMFallback) {

  private function generateUserFriendlyErrorMessage(array $errors): string
  {
    // Check for common error patterns and generate appropriate messages
    foreach ($errors as $error) {
      // Pattern: "Semantic result missing sources and data"
      if (strpos($error, 'Semantic result missing sources and data') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
        return "I couldn't find any information about that in the database. The requested content (like terms and conditions) may not be available yet. Please try asking about something else or contact support to add this content.";
      }
      // Pattern: "Analytics result missing data"
      if (strpos($error, 'Analytics result missing data') !== false) {

        if (!$hasSources) {
          $sourceType = strtolower($finalResult['source_attribution']['source_type'] ?? '');
          $isLLMFallback = $hasTextResponse && (
            strpos($sourceType, 'llm') !== false ||
            strpos($sourceType, 'general knowledge') !== false ||
            strpos($sourceType, 'conversation') !== false ||
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
            strpos($sourceType, 'memory') !== false
          );
          if (!$isLLMFallback) {
            $sourcesStatus = isset($finalResult['sources']) ? 'empty' : 'not set';

      if (strpos($error, 'Analytics result missing data') !== false) {
        return "I couldn't retrieve the requested data. This might be because there are no records matching your query, or the data hasn't been entered yet. Please try a different query or check if the data exists.";
      }
      // Pattern: "Hybrid result missing"
      if (strpos($error, 'Hybrid result missing') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
        return "I couldn't complete your request because some of the required information is missing. Please try breaking your question into smaller parts or asking about something else.";
      }
      // Pattern: "Empty response"
      if (strpos($error, 'empty') !== false || strpos($error, 'Empty') !== false) {

        // Semantic results MUST have sources OR data, unless it's a valid LLM/memory fallback
        if (!$hasSources) {
          $sourceType = strtolower($finalResult['source_attribution']['source_type'] ?? '');
          $isLLMFallback = $hasTextResponse && (
            strpos($sourceType, 'llm') !== false ||
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
            strpos($sourceType, 'general knowledge') !== false ||
            strpos($sourceType, 'conversation') !== false ||
            strpos($sourceType, 'memory') !== false
          );

          $sourceType = strtolower($finalResult['source_attribution']['source_type'] ?? '');
          $isLLMFallback = $hasTextResponse && (
            strpos($sourceType, 'llm') !== false ||
            strpos($sourceType, 'general knowledge') !== false ||
            strpos($sourceType, 'conversation') !== false ||
            strpos($sourceType, 'memory') !== false
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
          );
          if (!$isLLMFallback) {
            $sourcesStatus = isset($finalResult['sources']) ? 'empty' : 'not set';
            $dataStatus = isset($finalResult['data']) ? 'empty' : 'not set';

      if (strpos($error, 'Semantic result missing sources and data') !== false) {
        return "I couldn't find any information about that in the database. The requested content (like terms and conditions) may not be available yet. Please try asking about something else or contact support to add this content.";
      }
      // Pattern: "Analytics result missing data"
      if (strpos($error, 'Analytics result missing data') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
        return "I couldn't retrieve the requested data. This might be because there are no records matching your query, or the data hasn't been entered yet. Please try a different query or check if the data exists.";
      }
      // Pattern: "Hybrid result missing"
      if (strpos($error, 'Hybrid result missing') !== false) {

    // Check if goals contain contradictory terms
    foreach ($contradictions as $pair) {
      $has1in1 = strpos($goal1, $pair[0]) !== false;
      $has2in1 = strpos($goal1, $pair[1]) !== false;
      $has1in2 = strpos($goal2, $pair[0]) !== false;
      $has2in2 = strpos($goal2, $pair[1]) !== false;
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      // If obj1 has first term and obj2 has second term (or vice versa)
      if (($has1in1 && $has2in2) || ($has2in1 && $has1in2)) {
        // Check if they're operating on similar subjects
        $similarity = $this->calculateSimilarity($obj1, $obj2);

      'optimize' => ['optimize', 'improve', 'enhance', 'tune']
    ];
    foreach ($operationPatterns as $operation => $keywords) {
      foreach ($keywords as $keyword) {
        if (strpos($text, $keyword) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
          $operations[] = $operation;
          break;
        }
      }
    }

      ['grow', 'shrink']
    ];
    // Check if goals contain contradictory terms
    foreach ($contradictions as $pair) {
      $has1in1 = strpos($goal1, $pair[0]) !== false;
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      $has2in1 = strpos($goal1, $pair[1]) !== false;
      $has1in2 = strpos($goal2, $pair[0]) !== false;
      $has2in2 = strpos($goal2, $pair[1]) !== false;
      // If obj1 has first term and obj2 has second term (or vice versa)

      'database', 'table', 'index', 'query', 'cache', 'memory',
      'file', 'log', 'configuration', 'setting', 'registry'
    ];
    foreach ($resourceKeywords as $keyword) {
      if (strpos($text, $keyword) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
        $resources[] = $keyword;
      }
    }
    return array_unique($resources);

    ];
    // Check if goals contain contradictory terms
    foreach ($contradictions as $pair) {
      $has1in1 = strpos($goal1, $pair[0]) !== false;
      $has2in1 = strpos($goal1, $pair[1]) !== false;
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      $has1in2 = strpos($goal2, $pair[0]) !== false;
      $has2in2 = strpos($goal2, $pair[1]) !== false;
      // If obj1 has first term and obj2 has second term (or vice versa)
      if (($has1in1 && $has2in2) || ($has2in1 && $has1in2)) {

    // Check if goals contain contradictory terms
    foreach ($contradictions as $pair) {
      $has1in1 = strpos($goal1, $pair[0]) !== false;
      $has2in1 = strpos($goal1, $pair[1]) !== false;
      $has1in2 = strpos($goal2, $pair[0]) !== false;
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      $has2in2 = strpos($goal2, $pair[1]) !== false;
      // If obj1 has first term and obj2 has second term (or vice versa)
      if (($has1in1 && $has2in2) || ($has2in1 && $has1in2)) {
        // Check if they're operating on similar subjects

    if (strpos($errorLower, 'syntax') !== false) {
      return "There was a SQL syntax error. Try rephrasing your query or using a simpler time period.";
    }
    if (strpos($errorLower, 'permission') !== false || strpos($errorLower, 'access') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 05 May 2026 04:34:32 +0000 by clicshopping
                    
      return "You may not have permission to access the required data. Contact your administrator.";
    }
    if (strpos($errorLower, 'timeout') !== false) {
      return "The query took too long. Try a shorter time range or simpler aggregation.";

    if (strpos($errorLower, 'table') !== false) {
      return "The required table for {$temporalPeriod} aggregation may not exist. Verify your database structure.";
    }
    if (strpos($errorLower, 'syntax') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 05 May 2026 04:34:32 +0000 by clicshopping
                    
      return "There was a SQL syntax error. Try rephrasing your query or using a simpler time period.";
    }
    if (strpos($errorLower, 'permission') !== false || strpos($errorLower, 'access') !== false) {
      return "You may not have permission to access the required data. Contact your administrator.";

  private function determineSuggestedActionForSqlError(string $errorMessage, string $temporalPeriod): string
  {
    $errorLower = strtolower($errorMessage);
    // Check for common error patterns
    if (strpos($errorLower, 'column') !== false || strpos($errorLower, 'field') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 05 May 2026 04:34:32 +0000 by clicshopping
                    
      return "The database may not have the required columns for {$temporalPeriod} aggregation. Try a different time period or check your data schema.";
    }
    if (strpos($errorLower, 'table') !== false) {
      return "The required table for {$temporalPeriod} aggregation may not exist. Verify your database structure.";

    // Check for common error patterns
    if (strpos($errorLower, 'column') !== false || strpos($errorLower, 'field') !== false) {
      return "The database may not have the required columns for {$temporalPeriod} aggregation. Try a different time period or check your data schema.";
    }
    if (strpos($errorLower, 'table') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 05 May 2026 04:34:32 +0000 by clicshopping
                    
      return "The required table for {$temporalPeriod} aggregation may not exist. Verify your database structure.";
    }
    if (strpos($errorLower, 'syntax') !== false) {
      return "There was a SQL syntax error. Try rephrasing your query or using a simpler time period.";

    if (strpos($errorLower, 'permission') !== false || strpos($errorLower, 'access') !== false) {
      return "You may not have permission to access the required data. Contact your administrator.";
    }
    if (strpos($errorLower, 'timeout') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 05 May 2026 04:34:32 +0000 by clicshopping
                    
      return "The query took too long. Try a shorter time range or simpler aggregation.";
    }
    // Default suggestion
    return "Try rephrasing your query or using a different temporal period. If the problem persists, contact support.";

                    // Format: ['table' => 'column']
                    $table = $key;
                    $column = $value;
                } else {
                    // Format: ['table.column']
                    if (strpos($value, '.') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 06:20:37 +0000 by clicshopping
                    
                        list($table, $column) = explode('.', $value, 2);
                    } else {
                        // Cannot validate without table context
                        if ($this->debug) {
                            error_log("SchemaValidator: Column '{$value}' has no table context");

    // Display mode badges
    $badges = [];
    foreach ($modesUsed as $mode) {
      $badge = '';
      if (strpos($mode, 'mode_a') !== false || strpos($mode, 'ai_overview') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        $badge = "🤖 " . $this->language->getDef('text_rag_mode_ai_overview');
      } elseif (strpos($mode, 'mode_d') !== false || strpos($mode, 'amazon') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_amazon_shopping');
      } elseif (strpos($mode, 'mode_b') !== false || strpos($mode, 'shopping') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_shopping');

        $badge = "🛒 " . $this->language->getDef('text_rag_mode_amazon_shopping');
      } elseif (strpos($mode, 'mode_b') !== false || strpos($mode, 'shopping') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_shopping');
      } elseif (strpos($mode, 'mode_c') !== false || strpos($mode, 'rag') !== false) {
        $badge = "🔍 " . $this->language->getDef('text_rag_mode_rag_scraping');
      } elseif (strpos($mode, 'mode_e') !== false || strpos($mode, 'google_trends') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        $badge = "📈 " . $this->language->getDef('text_rag_mode_google_trends');
      }
      if (!empty($badge)) {
        $badges[] = "<span class='badge badge-primary' style='margin-right: 10px; padding: 8px 12px; font-size: 0.9em;'>{$badge}</span>";

    if (isset($metadata['engines_used']) && is_array($metadata['engines_used'])) {
      $modesUsed = $metadata['engines_used'];
      $isHybrid = count($modesUsed) > 1;
    } elseif (isset($metadata['mode_type'])) {
      $modesUsed = [$metadata['mode_type']];
      $isHybrid = (strpos($metadata['mode_type'], 'hybrid') !== false);
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
    }
    // Display hybrid label if applicable
    if ($isHybrid) {
      $output .= "<strong>" . $this->language->getDef('text_rag_hybrid_search') . "</strong><br>";

    foreach ($modesUsed as $mode) {
      $badge = '';
      if (strpos($mode, 'mode_a') !== false || strpos($mode, 'ai_overview') !== false) {
        $badge = "🤖 " . $this->language->getDef('text_rag_mode_ai_overview');
      } elseif (strpos($mode, 'mode_d') !== false || strpos($mode, 'amazon') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_amazon_shopping');
      } elseif (strpos($mode, 'mode_b') !== false || strpos($mode, 'shopping') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_shopping');
      } elseif (strpos($mode, 'mode_c') !== false || strpos($mode, 'rag') !== false) {
        $badge = "🔍 " . $this->language->getDef('text_rag_mode_rag_scraping');

        $badge = "🤖 " . $this->language->getDef('text_rag_mode_ai_overview');
      } elseif (strpos($mode, 'mode_d') !== false || strpos($mode, 'amazon') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_amazon_shopping');
      } elseif (strpos($mode, 'mode_b') !== false || strpos($mode, 'shopping') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_shopping');
      } elseif (strpos($mode, 'mode_c') !== false || strpos($mode, 'rag') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        $badge = "🔍 " . $this->language->getDef('text_rag_mode_rag_scraping');
      } elseif (strpos($mode, 'mode_e') !== false || strpos($mode, 'google_trends') !== false) {
        $badge = "📈 " . $this->language->getDef('text_rag_mode_google_trends');
      }

      if (strpos($mode, 'mode_a') !== false || strpos($mode, 'ai_overview') !== false) {
        $badge = "🤖 " . $this->language->getDef('text_rag_mode_ai_overview');
      } elseif (strpos($mode, 'mode_d') !== false || strpos($mode, 'amazon') !== false) {
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_amazon_shopping');
      } elseif (strpos($mode, 'mode_b') !== false || strpos($mode, 'shopping') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        $badge = "🛒 " . $this->language->getDef('text_rag_mode_shopping');
      } elseif (strpos($mode, 'mode_c') !== false || strpos($mode, 'rag') !== false) {
        $badge = "🔍 " . $this->language->getDef('text_rag_mode_rag_scraping');
      } elseif (strpos($mode, 'mode_e') !== false || strpos($mode, 'google_trends') !== false) {
        $badge = "📈 " . $this->language->getDef('text_rag_mode_google_trends');

      return "year {$matches[2]}";
    }
    // Check for relative time patterns
    foreach (self::RELATIVE_TIME_PATTERNS as $pattern => $range) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        return $range;
      }
    }
    return null;

  public static function extractBaseMetric(string $query): ?string
  {
    $query = strtolower($query);
    foreach (self::FINANCIAL_METRICS as $pattern => $metric) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 13 May 2026 12:12:21 +0000 by clicshopping
                    
        return $metric;
      }
    }
    return null;

    $lowerQuery = strtolower($query);
    $needsContext = false;
    foreach ($contextualKeywords as $keyword) {
      if (strpos($lowerQuery, $keyword) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Sun, 03 May 2026 11:55:53 +0000 by clicshopping
                    
        $needsContext = true;
        break;
      }
    }

      'as an ai',
      'i\'m an ai'
    ];
    foreach ($genericPhrases as $phrase) {
      if (strpos($response, $phrase) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
        $validationErrors[] = "Response contains generic LLM phrase indicating lack of knowledge";
        return false;
      }
    }

    // Check if source type is valid (case-insensitive, partial match)
    $sourceType = strtolower($sourceAttr['source_type']);
    $isValidSource = false;
    foreach ($validSourceTypes as $validType) {
      if (strpos($sourceType, strtolower($validType)) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
        $isValidSource = true;
        break;
      }
    }

    ];
    // If extension has defined magic bytes, validate them
    if (isset($magicBytes[$extension])) {
      foreach ($magicBytes[$extension] as $magic) {
        if (strpos($bytes, $magic) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 12:13:22 +0000 by clicshopping
                    
          return true;
        }
      }
      return false;
    }

        // Simple contradiction check
        $s1Lower = strtolower($statement1);
        $s2Lower = strtolower($statement2);
        // Check for negation patterns
        if (strpos($s1Lower, 'not') !== false && strpos($s2Lower, 'not') === false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 17 Feb 2026 13:08:46 +0000 by clicshopping
                    
            return true;
        }
        return false;
    }

    }
    // Check for relative time patterns
    $relativePatterns = self::getRelativeTimePatterns();
    foreach ($relativePatterns as $pattern => $range) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 09 Jan 2026 21:30:47 +0000 by clicshopping
                    
        return $range;
      }
    }
    // Check for date range patterns (e.g., "from January to March")

            $tableName = $metadata['source_table'];
            // Remove prefix and _embedding suffix
            $prefix = CLICSHOPPING::getConfig('db_table_prefix');
            if (strpos($tableName, $prefix) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Sun, 04 Jan 2026 03:17:42 +0000 by clicshopping
                    
              $tableName = substr($tableName, strlen($prefix));
            }
            $tableName = str_replace('_embedding', '', $tableName);
            $tableName = str_replace('_', ' ', $tableName);
            $docName = ucwords($tableName);

   */
  private function categorizeError(string $errorMessage): string
  {
    $message = strtolower($errorMessage);
    if (strpos($message, 'database') !== false || strpos($message, 'sql') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'database';
    }
    if (strpos($message, 'timeout') !== false || strpos($message, 'time out') !== false) {
      return 'timeout';
    }

      return 'timeout';
    }
    if (strpos($message, 'memory') !== false) {
      return 'memory';
    }
    if (strpos($message, 'validation') !== false || strpos($message, 'invalid') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'validation';
    }
    if (strpos($message, 'classification') !== false || strpos($message, 'intent') !== false) {
      return 'classification';
    }

      return 'memory';
    }
    if (strpos($message, 'validation') !== false || strpos($message, 'invalid') !== false) {
      return 'validation';
    }
    if (strpos($message, 'classification') !== false || strpos($message, 'intent') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'classification';
    }
    if (strpos($message, 'api') !== false || strpos($message, 'gpt') !== false) {
      return 'api';
    }

      return 'database';
    }
    if (strpos($message, 'timeout') !== false || strpos($message, 'time out') !== false) {
      return 'timeout';
    }
    if (strpos($message, 'memory') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'memory';
    }
    if (strpos($message, 'validation') !== false || strpos($message, 'invalid') !== false) {
      return 'validation';
    }

      return 'validation';
    }
    if (strpos($message, 'classification') !== false || strpos($message, 'intent') !== false) {
      return 'classification';
    }
    if (strpos($message, 'api') !== false || strpos($message, 'gpt') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'api';
    }
    return 'unknown';
  }

    $message = strtolower($errorMessage);
    if (strpos($message, 'database') !== false || strpos($message, 'sql') !== false) {
      return 'database';
    }
    if (strpos($message, 'timeout') !== false || strpos($message, 'time out') !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return 'timeout';
    }
    if (strpos($message, 'memory') !== false) {
      return 'memory';
    }

    $text = strtolower("$reason $comment");
    foreach ($keywords as $type => $words) {
      foreach ($words as $word) {
        if (strpos($text, $word) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
          return $type;
        }
      }
    }

        return $rawResult['text_response'];
      }
    }
    // Priority 5: Use finalResponse if available (but not if it's the JSON fallback)
    if (!empty($finalResponse) && strpos($finalResponse, 'Résultat:') === false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      return $finalResponse;
    }
    return '';
  }

      }
    }
    // Priority 4: Check if rawResult has 'text_response' field (but not if it's the JSON fallback)
    if (isset($rawResult['text_response']) && !empty($rawResult['text_response'])) {
      if (strpos($rawResult['text_response'], 'Résultat:') === false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
        return $rawResult['text_response'];
      }
    }
    // Priority 5: Use finalResponse if available (but not if it's the JSON fallback)

    // If it's an array, search for the response
    if (is_array($executionResult)) {
      if (isset($executionResult['text_response']) && !empty($executionResult['text_response'])) {
        // Check if text_response is NOT the JSON fallback
        if (strpos($executionResult['text_response'], 'Résultat:') === false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
          return $executionResult['text_response'];
        }
      }
      if (isset($executionResult['response']) && !empty($executionResult['response'])) {

      // 🔍 DEBUG: Log prompt loading verification
      if ($this->debug) {
        error_log("[INFO : ANALYSE] [UnifiedQueryAnalyzer] Prompt Loading Verification:");
        error_log("  Prompt length: " . strlen($prompt) . " characters");
        error_log("  Prompt preview (first 200 chars): " . substr($prompt, 0, 200) . "...");
        error_log("  Query in prompt: " . (strpos($prompt, $query) !== false ? 'YES' : 'NO'));
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      }
      // Single GPT call for everything
      // Use Gpt::getGptResponse() instead of non-existent complete() method

    if ($this->debug) {
      error_log("UnifiedQueryAnalyzer: Built prompt from language file sections");
      error_log("UnifiedQueryAnalyzer: Query to analyze: {$query}");
      error_log("UnifiedQueryAnalyzer: Total prompt length: " . strlen($prompt) . " characters");
      error_log("UnifiedQueryAnalyzer: Prompt contains query: " . (strpos($prompt, $query) !== false ? 'YES' : 'NO'));
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
    }
    return $prompt;
  }

      return "year {$matches[2]}";
    }
    // Check for relative time patterns
    foreach (self::RELATIVE_TIME_PATTERNS as $pattern => $range) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 09 Jan 2026 02:43:04 +0000 by clicshopping
                    
        return $range;
      }
    }
    return null;

  public static function extractBaseMetric(string $query): ?string
  {
    $query = strtolower($query);
    foreach (self::FINANCIAL_METRICS as $pattern => $metric) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 09 Jan 2026 02:43:04 +0000 by clicshopping
                    
        return $metric;
      }
    }
    return null;

     * @return string Escaped value
     */
    private function escapeCsvValue(string $value): string
    {
        // Escape quotes and wrap in quotes if contains comma, quote, or newline
        if (strpos($value, ',') !== false || strpos($value, '"') !== false || strpos($value, "\n") !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 17 Feb 2026 13:08:46 +0000 by clicshopping
                    
            return '"' . str_replace('"', '""', $value) . '"';
        }
        return $value;
    }

  {
    $query = strtolower($query);
    $detected = [];
    foreach (SuperlativePatterns::$superlativeKeywords as $pattern) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Sun, 04 Jan 2026 03:17:42 +0000 by clicshopping
                    
        $detected[] = $pattern;
      }
    }
    return $detected;

  public static function hasSuperlativePattern(string $query): bool
  {
    $query = strtolower($query);
    foreach (SuperlativePatterns::$superlativeKeywords as $pattern) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Sun, 04 Jan 2026 03:17:42 +0000 by clicshopping
                    
        return true;
      }
    }
    return false;

          // Fallback to source_table if no name found
          if ($docName === null && isset($metadata['source_table'])) {
            $tableName = $metadata['source_table'];
            // Remove prefix and _embedding suffix
            $prefix = defined('CLICSHOPPING_DB_TABLE_PREFIX') ? CLICSHOPPING_DB_TABLE_PREFIX : 'clic_';
            if (strpos($tableName, $prefix) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Wed, 08 Apr 2026 07:41:04 +0000 by clicshopping
                    
              $tableName = substr($tableName, strlen($prefix));
            }
            $tableName = str_replace('_embedding', '', $tableName);
            $tableName = str_replace('_', ' ', $tableName);
            $docName = ucwords($tableName);

      return $entityType;
    }
    // Remove table prefix if present
    $prefix = CLICSHOPPING::getConfig('db_table_prefix');
    if (!empty($prefix) && strpos($tableName, $prefix) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 20 Feb 2026 11:48:25 +0000 by clicshopping
                    
      $tableName = substr($tableName, strlen($prefix));
    }
    // Remove '_embedding' suffix if present
    $tableName = str_replace('_embedding', '', $tableName);

            }
            $keywords[] = $entityType;
            $keywords[] = str_replace('_', ' ', $entityType);
            if (substr($entityType, -3) === 'ies') {
Consider replacing substr() with str_ends_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 20 Feb 2026 14:56:16 +0000 by clicshopping
                    
                $keywords[] = substr($entityType, 0, -3) . 'y';
            } elseif (substr($entityType, -1) === 's') {
                $keywords[] = substr($entityType, 0, -1);
            } else {
                $keywords[] = $entityType . 's';

     * @return bool
     */
    private function hasKeyword(string $text, array $keywords): bool
    {
        foreach ($keywords as $keyword) {
            if (strpos($text, $keyword) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Tue, 17 Feb 2026 13:08:46 +0000 by clicshopping
                    
                return true;
            }
        }
        return false;
    }

            $keywords[] = $entityType;
            $keywords[] = str_replace('_', ' ', $entityType);
            if (substr($entityType, -3) === 'ies') {
                $keywords[] = substr($entityType, 0, -3) . 'y';
            } elseif (substr($entityType, -1) === 's') {
Consider replacing substr() with str_ends_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Fri, 20 Feb 2026 14:56:16 +0000 by clicshopping
                    
                $keywords[] = substr($entityType, 0, -1);
            } else {
                $keywords[] = $entityType . 's';
            }
        }

      // Propose permission level always requires approval for write actions
      if ($permissionLevel === self::PERMISSION_PROPOSE) {
        $writeActions = ['create', 'update', 'delete', 'modify', 'propose'];
        foreach ($writeActions as $writeAction) {
          if (strpos($action, $writeAction) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
            return true;
          }
        }
      }

      $table = $matches[1];
    }
    // Ajouter le préfixe si nécessaire
    $prefix = CLICSHOPPING::getConfig('db_prefix');
    if (!empty($prefix) && strpos($table, $prefix) !== 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      $table = $prefix . $table;
    }
    return trim($table, '`"\'');
  }

  {
    $query = strtolower($query);
    $metrics = self::getMetricsPatterns();
    foreach ($metrics as $pattern => $metric) {
      if (strpos($query, $pattern) !== false) {
Consider replacing strpos() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 26 Jan 2026 19:53:52 +0000 by clicshopping
                    
        return $metric;
      }
    }
    return null;

     * @param string $sql The SQL query
     * @return bool True if comments found
     */
    private function hasComments(string $sql): bool
    {
        return preg_match('/--/', $sql) || preg_match('/\/\*/', $sql);
Consider replacing preg_match() with str_contains() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 06:20:37 +0000 by clicshopping
                    
    }
    /**
     * Check if query contains UNION statement.
     *

    if (isset($metadata['source_table']) && !empty($metadata['source_table'])) {
      $tableName = $metadata['source_table'];
      // Remove prefix and _embedding suffix
      $prefix = CLICSHOPPING::getConfig('db_table_prefix');
      if (!empty($prefix) && strpos($tableName, $prefix) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Sun, 04 Jan 2026 03:17:42 +0000 by clicshopping
                    
        $tableName = substr($tableName, strlen($prefix));
      }
      $tableName = str_replace('_embedding', '', $tableName);
      // Convert to readable format (e.g., "pages_manager_description" -> "Pages Manager Description")

  public function __construct(EmbeddingGeneratorInterface $embeddingGenerator, string $tableName = 'rag_embeddings')
  {
    $this->embeddingGenerator = $embeddingGenerator;
    $prefix = CLICSHOPPING::getConfig('db_table_prefix');
    if (!empty($prefix) && strpos($tableName, $prefix) === 0) {
Consider replacing strpos() with str_starts_with() for improved readability.
Time to fix: about 1 hour
Read doc Permalink Copy Prompt

                                    Last edited Thu, 18 Dec 2025 01:44:05 +0000 by clicshopping
                    
      $this->tableName = $tableName;
    } else {
      $this->tableName = $prefix . $tableName;
    }

        // Escape foreign key name for SQL injection protection
        $escaped_fk_name = self::prepareIdentifier($name);
        // Escape column names in foreign key definition
        $escaped_cols = array_map([self::class, 'prepareIdentifier'], $fields['col']);
        $escaped_ref_cols = array_map([self::class, 'prepareIdentifier'], $fields['ref_col']);
Use the first-class callable syntax ($this->method(...))
Time to fix: about 15 minutes
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 12:13:22 +0000 by clicshopping
                    
        // Escape reference table name
        $escaped_ref_table = self::prepareIdentifier($fields['ref_table']);
        $row = '  FOREIGN KEY ' . $escaped_fk_name . ' (' . implode(', ', $escaped_cols) . ') REFERENCES ' . (isset($prefix) && (!isset($fields['prefix']) || ($fields['prefix'] != 'false')) ? $prefix : '') . $escaped_ref_table . '(' . implode(', ', $escaped_ref_cols) . ')';

      foreach ($schema['foreign'] as $name => $fields) {
        // Escape foreign key name for SQL injection protection
        $escaped_fk_name = self::prepareIdentifier($name);
        // Escape column names in foreign key definition
        $escaped_cols = array_map([self::class, 'prepareIdentifier'], $fields['col']);
Use the first-class callable syntax ($this->method(...))
Time to fix: about 15 minutes
Read doc Permalink Copy Prompt

                                    Last edited Tue, 28 Apr 2026 12:13:22 +0000 by clicshopping
                    
        $escaped_ref_cols = array_map([self::class, 'prepareIdentifier'], $fields['ref_col']);
        // Escape reference table name
        $escaped_ref_table = self::prepareIdentifier($fields['ref_table']);

    // Build a mapping of table names (without prefix) to entity types
    $tableToEntityType = [];
    foreach ($allTables as $fullTableName) {
      $entityType = $registry->getEntityTypeForTable($fullTableName);
      // Remove prefix and _embedding suffix to get base table name
      $tableName = str_replace([$prefix, '_embedding'], '', $fullTableName);
Use the first-class callable syntax ($this->method(...))
Time to fix: about 15 minutes
Read doc Permalink Copy Prompt

                                    Last edited Mon, 04 May 2026 07:25:43 +0000 by clicshopping
                    
      $tableToEntityType[$tableName] = $entityType;
    }
    // Pattern 1: FROM {table_name}
    if (preg_match('/FROM\s+(?:\w+\.)?(\w+)/i', $query, $matches)) {