import openpyxl
import random
class excel:
 def __init__(self,filename,sheetname):#讀某個單元格的值
  self.file = openpyxl.load_workbook(filename)
  self.sheet = self.file[sheetname]
  self.name=filename

 def write(self, sheet, data,num):#將數(shù)據(jù)以列表形式寫入
  sheet = self.file[sheet]
  for i in range(1, len(data) + 1):
   sheet.cell(num,i).value = data[i-1]
  self.file.save(self.name)

def formatx(indata):
 if indata=='shitou' or indata=='shi tou' or indata=='st':
  indata = '石頭'
 elif indata=='bu' or indata=='b u':
  indata = '布'
 elif indata=='jiandao' or indata=='jd':
  indata='剪刀'
 elif indata=='石頭' or indata=='布' or indata=='剪刀':
  pass
 return indata

def getscore(name):
 wb = openpyxl.load_workbook('first.xlsx')
 sheet = wb[name]
 maxrow = sheet.max_row
 maxcol = sheet.max_column
 score = sheet.cell(maxrow, maxcol).value
 if score=='積分':
  score = 5
  print("歡迎來到游戲")
 else:print("歡迎回來游戲")
 return score

def login(name):
 wb = openpyxl.load_workbook('first.xlsx')
 names = wb.sheetnames
 if name not in names:
  wb.create_sheet(name)
  sheet = wb[name]
  sheet.cell(1,1).value='電腦'
  sheet.cell(1, 2).value = '玩家'
  sheet.cell(1, 3).value = '結(jié)果'
  sheet.cell(1, 4).value = '積分'
  wb.save('first.xlsx')

if __name__=="__main__":
 name = input('請輸入您的名字：')
 login(name)
 score = getscore(name)
 print("積分{}".format(score))
 if score<=0:
  print('請充值：')
  money = int(input('請輸入充值金額'))
  score += money*2
 opt = excel('first.xlsx', name)
 for num in range(1,6):
  compute = random.choice(['石頭','剪刀','布'])
  player = input('請輸入猜拳的內(nèi)容：')
  player=formatx(player)
  if player==compute:
   result = [compute,player,'平局',score]
   print('電腦出拳：{}，玩家出拳：{}，游戲結(jié)果：{}'.format(compute,player,result[2],score))
   opt.write(name, result,num+1)
  elif (player=='石頭' and compute=='剪刀') or (player=='剪刀' and compute=='布') or player=='布' and compute=='石頭':
   score+=1
   result = [compute, player, '玩家勝利',score]
   print('電腦出拳：{}，玩家出拳：{}，游戲結(jié)果：{}'.format(compute, player, result[2],score))
   opt.write(name, result,num+1)
  else:
   score-=1
   result = [compute, player, '玩家失敗',score]
   print('電腦出拳：{}，玩家出拳：{}，游戲結(jié)果：{}'.format(compute, player, result[2],score))
   opt.write(name, result,num+1)
  if score<=0:
   break
  print('游戲剩余次數(shù)：{}'.format(5-num))
 print("游戲結(jié)束")