const { Client } = require('ssh2');

const conn = new Client();

conn.on('ready', () => {
  console.log('=== 读取订单数据 ===');
  
  conn.exec('cat /www/huishou/server/data/orders.json', (err, stream) => {
    if (err) { console.log('ERR:', err); conn.end(); return; }
    let data = '';
    stream.on('data', (d) => data += d.toString());
    stream.on('close', () => {
      try {
        let orders = JSON.parse(data);
        
        orders.forEach(o => {
          if (o.createTime && o.createTime.includes('T')) {
            const date = new Date(o.createTime);
            o.createTime = `${date.getFullYear()}-${String(date.getMonth() + 1).padStart(2, '0')}-${String(date.getDate()).padStart(2, '0')} ${String(date.getHours()).padStart(2, '0')}:${String(date.getMinutes()).padStart(2, '0')}`;
          }
        });
        
        const fixedData = JSON.stringify(orders, null, 2);
        
        console.log('\n=== 写入修复后的数据 ===');
        conn.exec(`cat > /www/huishou/server/data/orders.json << 'EOF'\n${fixedData}\nEOF`, (err2, stream2) => {
          if (err2) { console.log('ERR2:', err2); conn.end(); return; }
          stream2.on('close', () => {
            console.log('\n=== 验证修复结果 ===');
            conn.exec('cat /www/huishou/server/data/orders.json | head -100', (err3, stream3) => {
              if (err3) { console.log('ERR3:', err3); conn.end(); return; }
              let result = '';
              stream3.on('data', (d) => result += d.toString());
              stream3.on('close', () => {
                console.log('验证结果:', result);
                
                console.log('\n=== 重启后端容器 ===');
                conn.exec('cd /www/huishou && docker-compose restart backend', (err4, stream4) => {
                  if (err4) { console.log('ERR4:', err4); conn.end(); return; }
                  stream4.on('close', () => {
                    setTimeout(() => {
                      console.log('\n=== 测试订单列表API ===');
                      conn.exec('curl -s http://127.0.0.1:4000/api/orders', (err5, stream5) => {
                        if (err5) { console.log('ERR5:', err5); conn.end(); return; }
                        let apiResult = '';
                        stream5.on('data', (d) => apiResult += d.toString());
                        stream5.on('close', () => {
                          try {
                            const result = JSON.parse(apiResult);
                            console.log('订单数量:', result.data.length);
                            if (result.data.length > 0) {
                              console.log('第一条订单:', JSON.stringify(result.data[0], null, 2));
                            }
                          } catch (e) {
                            console.log('解析错误:', e);
                          }
                          conn.end();
                        });
                      });
                    }, 5000);
                  });
                });
              });
            });
          });
        });
      } catch (e) {
        console.log('解析错误:', e);
        conn.end();
      }
    });
  });
});

conn.connect({ host: 'hs.yifenbao.cn', port: 22, username: 'root', password: 'Torch1112' });