আমাদের APIs-এর মাধ্যমে আপনার ওয়েবসাইটে লটারির ফলাফল যুক্ত করুন

namespace App\Services;

use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\Log;

class DearLotteryApiService
{
    protected string $baseUrl = 'https://dearlotterysambad.live/api/v1';
    protected string $apiKey;

    public function __construct()
    {
        $this->apiKey = config('services.dear_lottery.key');
    }

    /**
     * Ingest latest structured results with incremental updated_since filter.
     */
    public function syncResults(?string $updatedSince = null, string $state = 'sikkim-lottery-result'): ?array
    {
        $params = ['state' => $state, 'per_page' => 20];
        if ($updatedSince) {
            $params['updated_since'] = $updatedSince;
        }

        $response = Http::withHeaders([
            'X-API-KEY' => $this->apiKey,
            'Accept' => 'application/json',
        ])->timeout(12)->get("{$this->baseUrl}/results", $params);

        if ($response->successful()) {
            $data = $response->json();
            
            // Log remaining subscription days for monitoring
            $daysLeft = $data['api_subscription']['remaining_days'] ?? null;
            if ($daysLeft !== null && $daysLeft <= 7) {
                Log::warning("Dear Lottery API subscription expiring soon: {$daysLeft} days remaining.");
            }

            return $data['data'] ?? [];
        }

        if ($response->status() === 403 && $response->json('error.code') === 'API_EXPIRED') {
            Log::alert('Dear Lottery API subscription has expired! Please renew immediately.');
        }

        return null;
    }
}

import fetch from 'node-fetch';

const API_KEY = process.env.LOTTERY_API_KEY || 'dls_dom_YOUR_SECRET_KEY';
const API_URL = 'https://dearlotterysambad.live/api/v1/results?state=sikkim-lottery-result&per_page=1';

async function fetchStructuredResults() {
    try {
        const response = await fetch(API_URL, {
            method: 'GET',
            headers: {
                'X-API-KEY': API_KEY,
                'Accept': 'application/json'
            }
        });

        const data = await response.json();

        if (response.ok && data.success) {
            console.log(`[OK] Domain: ${data.domain} | Days Left: ${data.api_subscription.remaining_days}`);
            
            for (const result of data.data) {
                console.log(`Draw: ${result.lottery_name} [${result.identity_key}]`);
                for (const prize of result.prizes) {
                    console.log(`  Tier ${prize.rank} (${prize.prize_name}): ${prize.winning_numbers.join(', ')}`);
                }
            }
        } else if (response.status === 403 && data.error?.code === 'API_EXPIRED') {
            console.error(`[EXPIRED] Subscription ended on ${data.data?.expired_at}`);
        } else {
            console.error(`[ERROR] HTTP ${response.status}:`, data.error);
        }
    } catch (err) {
        console.error('Network failure connecting to Lottery API:', err);
    }
}

fetchStructuredResults();

-- Suggested MySQL Schema for Partner Database Ingestion
CREATE TABLE partner_lottery_draws (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    identity_key VARCHAR(191) NOT NULL UNIQUE, -- e.g. "SK-2026-11-03-13:00:00-dear-everest-morning"
    state_code VARCHAR(10) NOT NULL,
    state_name VARCHAR(100) NOT NULL,
    lottery_name VARCHAR(191) NOT NULL,
    draw_date DATE NOT NULL,
    draw_time TIME NOT NULL,
    draw_number VARCHAR(50),
    first_prize_sold_by VARCHAR(191),
    pdf_embed_url TEXT,
    original_pdf_url TEXT,
    verified_at DATETIME,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_draw_date (draw_date),
    INDEX idx_state_code (state_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE partner_lottery_prizes (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    draw_id BIGINT UNSIGNED NOT NULL,
    rank_order INT NOT NULL,
    prize_name VARCHAR(100) NOT NULL,
    prize_amount VARCHAR(100) NOT NULL,
    winner_name VARCHAR(191),
    winning_numbers JSON NOT NULL, -- Stored as JSON array: ["97K 95045"]
    FOREIGN KEY (draw_id) REFERENCES partner_lottery_draws(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Ingestion Logic: Use identity_key to perform an idempotent UPDATE or INSERT (Upsert)
-- This ensures running your sync job repeatedly never creates duplicate rows!