Skill To Linebot

{
    "timeZone": "Asia/Taipei",
    "dependencies": {},
    "exceptionLogging": "STACKDRIVER",
    "runtimeVersion": "V8",
    "webapp": {
        "executeAs": "USER_DEPLOYING",
        "access": "ANYONE_ANONYMOUS"
    }
}

/**
 * {{SKILL_NAME}} LINE Bot - 設定檔
 * 
 * 請將以下設定填入 Script Properties：
 * File > Project properties > Script properties
 */

const Config = {
  // LINE Bot
  LINE_CHANNEL_SECRET: PropertiesService.getScriptProperties().getProperty('LINE_CHANNEL_SECRET') || '',
  LINE_CHANNEL_ACCESS_TOKEN: PropertiesService.getScriptProperties().getProperty('LINE_CHANNEL_ACCESS_TOKEN') || '',
  
  // OpenAI
  OPENAI_API_KEY: PropertiesService.getScriptProperties().getProperty('OPENAI_API_KEY') || '',
  OPENAI_MODEL: 'gpt-4o',
  
  // Google Sheets
  SPREADSHEET_ID: PropertiesService.getScriptProperties().getProperty('SPREADSHEET_ID') || '',
  
  // 服務設定
  BOT_NAME: '{{SKILL_DISPLAY_NAME}}',
  WELCOME_MESSAGE: '{{WELCOME_MESSAGE}}',
  
  // 可選：Vector Store（用於 RAG）
  OPENAI_VECTOR_STORE_ID: PropertiesService.getScriptProperties().getProperty('OPENAI_VECTOR_STORE_ID') || ''
};

/**
 * Google Sheets 資料庫操作
 * 
 * 此模組為通用模組，提供用戶管理和使用記錄功能
 */

const Database = {
  
  /**
   * 取得試算表
   */
  getSpreadsheet() {
    return SpreadsheetApp.openById(Config.SPREADSHEET_ID);
  },
  
  /**
   * 取得工作表（不存在則自動建立）
   */
  getSheet(name) {
    const ss = this.getSpreadsheet();
    let sheet = ss.getSheetByName(name);
    
    if (!sheet) {
      sheet = ss.insertSheet(name);
      this.initSheet(sheet, name);
    }
    
    return sheet;
  },
  
  /**
   * 初始化工作表欄位
   */
  initSheet(sheet, name) {
    const headers = {
      'users': ['userId', 'displayName', 'joinDate', 'usageCount', 'lastUsedDate', 'state'],
      'logs': ['id', 'userId', 'input', 'output', 'createdAt']
    };
    
    if (headers[name]) {
      sheet.getRange(1, 1, 1, headers[name].length).setValues([headers[name]]);
      sheet.setFrozenRows(1);
    }
  },
  
  // =====================
  // 用戶管理
  // =====================
  
  /**
   * 建立新用戶
   */
  createUser(userId) {
    const existingUser = this.getUser(userId);
    if (existingUser) return existingUser;
    
    const sheet = this.getSheet('users');
    const profile = LineBot.getProfile(userId) || {};
    
    const userData = [
      userId,
      profile.displayName || '',
      new Date().toISOString(),
      0,    // usageCount
      '',   // lastUsedDate
      ''    // state (JSON)
    ];
    
    sheet.appendRow(userData);
    return this.getUser(userId);
  },
  
  /**
   * 取得用戶資料
   */
  getUser(userId) {
    const sheet = this.getSheet('users');
    const data = sheet.getDataRange().getValues();
    
    for (let i = 1; i < data.length; i++) {
      if (data[i][0] === userId) {
        return {
          row: i + 1,
          userId: data[i][0],
          displayName: data[i][1],
          joinDate: data[i][2],
          usageCount: data[i][3] || 0,
          lastUsedDate: data[i][4],
          state: data[i][5] ? JSON.parse(data[i][5]) : null
        };
      }
    }
    
    return null;
  },
  
  /**
   * 增加使用次數
   */
  incrementUsage(userId) {
    const user = this.getUser(userId);
    if (!user) return;
    
    const sheet = this.getSheet('users');
    sheet.getRange(user.row, 4).setValue(user.usageCount + 1);
    sheet.getRange(user.row, 5).setValue(new Date().toISOString());
  },
  
  /**
   * 設定用戶狀態（用於多輪對話）
   */
  setUserState(userId, state) {
    let user = this.getUser(userId);
    if (!user) {
      this.createUser(userId);
      user = this.getUser(userId);
    }
    
    const sheet = this.getSheet('users');
    sheet.getRange(user.row, 6).setValue(JSON.stringify(state));
  },
  
  /**
   * 取得用戶狀態
   */
  getUserState(userId) {
    const user = this.getUser(userId);
    return user ? user.state : null;
  },
  
  /**
   * 清除用戶狀態
   */
  clearUserState(userId) {
    const user = this.getUser(userId);
    if (!user) return;
    
    const sheet = this.getSheet('users');
    sheet.getRange(user.row, 6).setValue('');
  },
  
  // =====================
  // 使用記錄
  // =====================
  
  /**
   * 儲存使用記錄
   */
  saveLog(userId, input, output) {
    const sheet = this.getSheet('logs');
    const id = Utilities.getUuid();
    
    sheet.appendRow([
      id,
      userId,
      input.substring(0, 1000),  // 限制長度
      output.substring(0, 5000), // 限制長度
      new Date().toISOString()
    ]);
    
    return id;
  },
  
  /**
   * 取得最近一次記錄（用於追問功能）
   */
  getLastLog(userId, withinMinutes = 30) {
    const sheet = this.getSheet('logs');
    const data = sheet.getDataRange().getValues();
    
    for (let i = data.length - 1; i >= 1; i--) {
      if (data[i][1] === userId) {
        const createdAt = new Date(data[i][4]);
        const now = new Date();
        const diffMinutes = (now - createdAt) / (1000 * 60);
        
        if (diffMinutes <= withinMinutes) {
          return {
            input: data[i][2],
            output: data[i][3],
            createdAt: data[i][4]
          };
        }
        break;
      }
    }
    
    return null;
  }
};

/**
 * LINE Messaging API 封裝
 * 
 * 此模組為通用模組，無需修改即可使用
 */

const LineBot = {
  
  /**
   * 回覆訊息（使用 replyToken，不消耗 push 額度）
   */
  reply(replyToken, messages) {
    const url = 'https://api.line.me/v2/bot/message/reply';
    
    const options = {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'Authorization': 'Bearer ' + Config.LINE_CHANNEL_ACCESS_TOKEN
      },
      payload: JSON.stringify({
        replyToken: replyToken,
        messages: messages
      }),
      muteHttpExceptions: true
    };
    
    const response = UrlFetchApp.fetch(url, options);
    return JSON.parse(response.getContentText());
  },
  
  /**
   * 主動推送訊息（消耗 push 額度）
   */
  push(userId, messages) {
    const url = 'https://api.line.me/v2/bot/message/push';
    
    const options = {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'Authorization': 'Bearer ' + Config.LINE_CHANNEL_ACCESS_TOKEN
      },
      payload: JSON.stringify({
        to: userId,
        messages: messages
      }),
      muteHttpExceptions: true
    };
    
    const response = UrlFetchApp.fetch(url, options);
    return JSON.parse(response.getContentText());
  },
  
  /**
   * 顯示思考中動畫
   * @param {string} chatId - 用戶 ID
   * @param {number} seconds - 持續秒數 (5-60)
   */
  showLoading(chatId, seconds) {
    const url = 'https://api.line.me/v2/bot/chat/loading/start';
    
    const options = {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
        'Authorization': 'Bearer ' + Config.LINE_CHANNEL_ACCESS_TOKEN
      },
      payload: JSON.stringify({
        chatId: chatId,
        loadingSeconds: Math.min(Math.max(seconds || 20, 5), 60)
      }),
      muteHttpExceptions: true
    };
    
    try {
      UrlFetchApp.fetch(url, options);
    } catch (e) {
      Logger.log('showLoading error: ' + e.message);
    }
  },
  
  /**
   * 取得用戶資料
   */
  getProfile(userId) {
    const url = 'https://api.line.me/v2/bot/profile/' + userId;
    
    const options = {
      method: 'GET',
      headers: {
        'Authorization': 'Bearer ' + Config.LINE_CHANNEL_ACCESS_TOKEN
      },
      muteHttpExceptions: true
    };
    
    try {
      const response = UrlFetchApp.fetch(url, options);
      return JSON.parse(response.getContentText());
    } catch (e) {
      Logger.log('Error getting profile: ' + e);
      return null;
    }
  },
  
  /**
   * 建立純文字訊息
   */
  textMessage(text) {
    return { type: 'text', text: text };
  },
  
  /**
   * 驗證 Webhook 簽名
   */
  verifySignature(body, signature) {
    const hash = Utilities.computeHmacSha256Signature(body, Config.LINE_CHANNEL_SECRET);
    const expectedSignature = Utilities.base64Encode(hash);
    return signature === expectedSignature;
  }
};

/**
 * {{SKILL_NAME}} LINE Bot - Webhook 入口
 * 
 * 純文字版本，穩定易除錯
 */

// ============================================
// Webhook 處理
// ============================================

function doPost(e) {
  try {
    const data = JSON.parse(e.postData.contents);
    Logger.log('Webhook received: ' + JSON.stringify(data));
    
    if (data.events) {
      data.events.forEach(event => {
        try {
          handleEvent(event);
        } catch (err) {
          Logger.log('Event handling error: ' + err.message);
        }
      });
    }
    
    return ContentService.createTextOutput('OK');
  } catch (error) {
    Logger.log('doPost error: ' + error.message);
    return ContentService.createTextOutput('ERROR');
  }
}

function doGet(e) {
  return ContentService.createTextOutput(Config.BOT_NAME + ' is running!');
}

// ============================================
// 事件處理
// ============================================

function handleEvent(event) {
  const userId = event.source.userId;
  const replyToken = event.replyToken;
  
  // 處理加好友事件
  if (event.type === 'follow') {
    handleFollow(userId, replyToken);
    return;
  }
  
  // 處理文字訊息
  if (event.type === 'message' && event.message.type === 'text') {
    const userMessage = event.message.text.trim();
    handleTextMessage(userId, replyToken, userMessage);
    return;
  }
}

/**
 * 處理新用戶加好友
 */
function handleFollow(userId, replyToken) {
  // 建立用戶記錄
  Database.createUser(userId);
  
  // 發送歡迎訊息
  const welcomeText = Config.WELCOME_MESSAGE || 
    `歡迎使用 ${Config.BOT_NAME}！\n\n直接輸入訊息即可開始使用。`;
  
  LineBot.reply(replyToken, [
    LineBot.textMessage(welcomeText)
  ]);
}

/**
 * 處理文字訊息
 */
function handleTextMessage(userId, replyToken, userMessage) {
  // 顯示思考中動畫
  LineBot.showLoading(userId, 30);
  
  try {
    // 呼叫 SkillCore 處理訊息
    const response = SkillCore.processMessage(userId, userMessage);
    
    // 回覆純文字
    LineBot.reply(replyToken, [
      LineBot.textMessage(response)
    ]);
    
    // 記錄使用
    Database.incrementUsage(userId);
    Database.saveLog(userId, userMessage, response);
    
  } catch (e) {
    Logger.log('處理訊息錯誤：' + e.message);
    LineBot.reply(replyToken, [
      LineBot.textMessage('抱歉，處理您的訊息時發生錯誤，請稍後再試。')
    ]);
  }
}

// ============================================
// 測試函數
// ============================================

/**
 * 測試用：取得測試用戶 ID
 */
function getTestUserId() {
  return PropertiesService.getScriptProperties().getProperty('TEST_USER_ID');
}

/**
 * 測試 LINE 發送功能
 */
function testLineSend() {
  const userId = getTestUserId();
  if (!userId) {
    Logger.log('請設定 TEST_USER_ID');
    return;
  }
  
  LineBot.push(userId, [
    LineBot.textMessage('✅ LINE Bot 連接正常！')
  ]);
  Logger.log('✅ 測試訊息已發送');
}

/**
 * 測試 SkillCore
 */
function testSkillCore() {
  const userId = getTestUserId();
  if (!userId) {
    Logger.log('請設定 TEST_USER_ID');
    return;
  }
  
  try {
    const response = SkillCore.processMessage(userId, '測試訊息');
    LineBot.push(userId, [
      LineBot.textMessage('✅ SkillCore 測試結果：\n\n' + response)
    ]);
    Logger.log('✅ SkillCore 測試完成');
  } catch (e) {
    LineBot.push(userId, [
      LineBot.textMessage('❌ SkillCore 測試失敗：' + e.message)
    ]);
    Logger.log('❌ SkillCore 測試失敗：' + e.message);
  }
}

/**
 * {{SKILL_NAME}} LINE Bot - OpenAI 整合
 * 
 * 此模組提供 OpenAI API 呼叫功能
 */

const OpenAI = {
  
  /**
   * 呼叫 Chat Completions API
   * @param {string} userMessage - 用戶訊息
   * @param {string} systemPrompt - 系統提示詞
   * @param {number} maxTokens - 最大回應長度
   * @returns {string} AI 回應文字
   */
  chat(userMessage, systemPrompt, maxTokens = 1000) {
    const url = 'https://api.openai.com/v1/chat/completions';
    
    const payload = {
      model: Config.OPENAI_MODEL,
      messages: [
        { role: 'system', content: systemPrompt },
        { role: 'user', content: userMessage }
      ],
      max_tokens: maxTokens,
      temperature: 0.7
    };
    
    try {
      const response = UrlFetchApp.fetch(url, {
        method: 'POST',
        headers: {
          'Authorization': 'Bearer ' + Config.OPENAI_API_KEY,
          'Content-Type': 'application/json'
        },
        payload: JSON.stringify(payload),
        muteHttpExceptions: true
      });
      
      const result = JSON.parse(response.getContentText());
      
      if (result.error) {
        Logger.log('OpenAI error: ' + result.error.message);
        return '抱歉，AI 處理時發生錯誤：' + result.error.message;
      }
      
      return result.choices[0].message.content.trim();
      
    } catch (e) {
      Logger.log('OpenAI exception: ' + e);
      return '抱歉，AI 服務暫時無法使用，請稍後再試。';
    }
  },
  
  /**
   * 帶有對話歷史的 Chat（用於多輪對話）
   * @param {Array} messages - 對話歷史 [{role, content}, ...]
   * @param {string} systemPrompt - 系統提示詞
   * @returns {string} AI 回應文字
   */
  chatWithHistory(messages, systemPrompt, maxTokens = 1000) {
    const url = 'https://api.openai.com/v1/chat/completions';
    
    const fullMessages = [
      { role: 'system', content: systemPrompt },
      ...messages
    ];
    
    const payload = {
      model: Config.OPENAI_MODEL,
      messages: fullMessages,
      max_tokens: maxTokens,
      temperature: 0.7
    };
    
    try {
      const response = UrlFetchApp.fetch(url, {
        method: 'POST',
        headers: {
          'Authorization': 'Bearer ' + Config.OPENAI_API_KEY,
          'Content-Type': 'application/json'
        },
        payload: JSON.stringify(payload),
        muteHttpExceptions: true
      });
      
      const result = JSON.parse(response.getContentText());
      
      if (result.error) {
        Logger.log('OpenAI error: ' + result.error.message);
        return '抱歉，AI 處理時發生錯誤。';
      }
      
      return result.choices[0].message.content.trim();
      
    } catch (e) {
      Logger.log('OpenAI exception: ' + e);
      return '抱歉，AI 服務暫時無法使用，請稍後再試。';
    }
  },
  
  /**
   * 使用 Responses API（支援 file_search / Vector Store）
   * 注意：需要設定 OPENAI_VECTOR_STORE_ID
   */
  responsesWithSearch(userMessage, systemPrompt) {
    if (!Config.OPENAI_VECTOR_STORE_ID) {
      // 如果沒有 Vector Store，使用一般 chat
      return this.chat(userMessage, systemPrompt);
    }
    
    const url = 'https://api.openai.com/v1/responses';
    
    const payload = {
      model: Config.OPENAI_MODEL,
      input: userMessage,
      instructions: systemPrompt,
      tools: [{
        type: 'file_search',
        vector_store_ids: [Config.OPENAI_VECTOR_STORE_ID]
      }]
    };
    
    try {
      const response = UrlFetchApp.fetch(url, {
        method: 'POST',
        headers: {
          'Authorization': 'Bearer ' + Config.OPENAI_API_KEY,
          'Content-Type': 'application/json'
        },
        payload: JSON.stringify(payload),
        muteHttpExceptions: true
      });
      
      const result = JSON.parse(response.getContentText());
      
      if (result.error) {
        Logger.log('OpenAI Responses error: ' + result.error.message);
        // 降級到一般 chat
        return this.chat(userMessage, systemPrompt);
      }
      
      return result.output_text || result.output?.[0]?.content?.[0]?.text || '無法取得回應';
      
    } catch (e) {
      Logger.log('OpenAI Responses exception: ' + e);
      return this.chat(userMessage, systemPrompt);
    }
  }
};

/**
 * {{SKILL_NAME}} LINE Bot - Skill 核心邏輯
 * 
 * ⚠️ 此檔案需要根據具體 Skill 進行客製化
 * 
 * AI 將會根據分析的 Skill 內容填充以下區塊：
 * - SYSTEM_PROMPT: 系統提示詞
 * - processMessage(): 訊息處理邏輯
 */

const SkillCore = {
  
  // ============================================
  // 系統提示詞（由 AI 根據 Skill 生成）
  // ============================================
  
  SYSTEM_PROMPT: `{{SYSTEM_PROMPT}}`,
  
  // ============================================
  // 主要處理函數
  // ============================================
  
  /**
   * 處理用戶訊息
   * @param {string} userId - 用戶 ID
   * @param {string} userMessage - 用戶訊息
   * @returns {string} 回應文字
   */
  processMessage(userId, userMessage) {
    {{PROCESS_MESSAGE_LOGIC}}
  },
  
  // ============================================
  // 輔助函數（可選，由 AI 根據需要添加）
  // ============================================
  
  {{HELPER_FUNCTIONS}}
};