{"File":"/root/aadharbot/index.js","LineNumber":1067,"LineContent":" const res = await pool.query('SELECT credits, plan_type, plan_expires_at FROM users WHERE telegram_id = $1', [userId]);"} {"File":"/root/aadharbot/index.js","LineNumber":1071,"LineContent":" const planExpires = row.plan_expires_at ? new Date(row.plan_expires_at) : null;"} {"File":"/root/aadharbot/index.js","LineNumber":1502,"LineContent":" db[userId] = { name: firstName, credits: 120, plan_type: 'credits', plan_expires_at: null, referred_by: referrerId };"} {"File":"/root/aadharbot/index.js","LineNumber":1927,"LineContent":" plan_expires_at: val.plan_expires_at || ''"} {"File":"/root/aadharbot/index.js","LineNumber":1951,"LineContent":" const usersRes = await pool.query('SELECT telegram_id, name, credits, thread_id, plan_type, plan_expires_at, created_at FROM users');"} {"File":"/root/aadharbot/index.js","LineNumber":1958,"LineContent":" const userHeaders = ['telegram_id', 'name', 'credits', 'thread_id', 'plan_type', 'plan_expires_at', 'created_at'];"} {"File":"/root/aadharbot/index.js","LineNumber":2049,"LineContent":" plan_expires_at: val.plan_expires_at || ''"} {"File":"/root/aadharbot/index.js","LineNumber":2140,"LineContent":" plan_expires_at: db[targetUserId].plan_expires_at || null"} {"File":"/root/aadharbot/index.js","LineNumber":2167,"LineContent":" const expiryStr = user.plan_expires_at ? new Date(user.plan_expires_at).toLocaleString('en-IN', { timeZone: 'Asia/Kolkata' }) : 'Never (No Active Plan)';"} {"File":"/root/aadharbot/index.js","LineNumber":2257,"LineContent":" db[targetUserId].plan_expires_at = planExpiry.toISOString();"} {"File":"/root/aadharbot/index.js","LineNumber":2261,"LineContent":" `INSERT INTO users (telegram_id, name, credits, plan_type, plan_expires_at, created_at, updated_at) "} {"File":"/root/aadharbot/index.js","LineNumber":2264,"LineContent":" DO UPDATE SET plan_type = 'unlimited', plan_expires_at = EXCLUDED.plan_expires_at`,"} {"File":"/root/aadharbot/index.js","LineNumber":3153,"LineContent":" `UPDATE users SET credits = credits - $1, plan_type = 'unlimited', plan_expires_at = $2 WHERE telegram_id = $3`,"} {"File":"/root/aadharbot/index.js","LineNumber":4693,"LineContent":" db[payment.userId].plan_expires_at = planExpiresAt.toISOString();"} {"File":"/root/aadharbot/index.js","LineNumber":4697,"LineContent":" `INSERT INTO users (telegram_id, name, credits, plan_type, plan_expires_at, created_at, updated_at) "} {"File":"/root/aadharbot/index.js","LineNumber":4700,"LineContent":" DO UPDATE SET plan_type = 'unlimited', plan_expires_at = EXCLUDED.plan_expires_at`,"} {"File":"/root/aadharbot/index.js","LineNumber":4720,"LineContent":" db[payment.userId].plan_expires_at = null;"} {"File":"/root/aadharbot/index.js","LineNumber":4725,"LineContent":" `INSERT INTO users (telegram_id, name, credits, plan_type, plan_expires_at, created_at, updated_at) "} {"File":"/root/aadharbot/index.js","LineNumber":4728,"LineContent":" DO UPDATE SET credits = users.credits + EXCLUDED.credits, plan_type = 'credits', plan_expires_at = NULL"}