Score/TLHCore.py at master · EarlySpringCommitee/Score · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
# coding=utf-8
import requests
from pyquery import PyQuery as pq
import pandas as pd
isnan = lambda x:x!=x
valid = lambda x:x if not isnan(x) else ''

def get(account=None, password=None, mode='i'):
    if not(account and password):
        raise ValueError('Account or password Error!')
    s = requests.Session()
    s.encoding = 'big5'

    login = s.post("http://register.tlhc.ylc.edu.tw/hcode/login.asp", data={
        'txtID': account,
        'txtPWD': password,
        'login_r7_c5.x': 0,
        'login_r7_c5.y': 0,
        'Chk': 'Y'}) # Login
    login.encoding = 'big5'

    # 驗證帳號正確
    loginSuccess=s.get("http://register.tlhc.ylc.edu.tw/hcode/STDINFO.asp")
    loginSuccess.encoding = 'big5'
    if "抱歉,您無權限使用本程式!" in loginSuccess.text:
        raise ValueError('Account or password Error!')

    def get_score(): # 學期成績
        get_score_data = s.get("http://register.tlhc.ylc.edu.tw/hcode/STD_SCORE.asp")
        get_score_data.encoding = 'big5'
        score_datas = pd.read_html(get_score_data.text)[3]
        sum_datas = pd.read_html(get_score_data.text)[5]
        score = {}
        subjects = [i for i in score_datas[0][2:18]]
        sum_titles = [i for i in sum_datas[0][1:-1]]
        for i in range(1,11):
            parsed_scores = [i if not isnan(i) else '' for i in score_datas[i] ][2:18]
            exam = score_datas[i][1]
            if isnan(exam):
                continue
            score[exam] = dict(zip(subjects, [[i]+['','','',''] for i in parsed_scores]))
        for i in range(1,8):
            sum_data = [i if not isnan(i) else '' for i in sum_datas[i][:-1]]
            if not sum_data[0] in score:
                continue
            score[sum_data[0]].update(dict(zip(sum_titles, sum_data[1:])))
        """
        資料格式: {'第1次平時成績':
                    {'◎ 國文Ⅴ':[ 成績 , 平均 , 排名 , 類組排, 校排],
                    '◎ 英文Ⅴ': ['78', '', '', '',''],
                    ....,
                    '總分': ''....},
                ....}
        }}
        """
        return score

    def get_info():
        get_infos = s.get('http://register.tlhc.ylc.edu.tw/hcode/STDINFO.asp')
        get_infos.encoding = 'big5'
        infos = pd.read_html(get_infos.text)[1]
        infos = {
            'studentId': valid(infos[1][1]),
            'name': valid(infos[3][1]),
            'class': valid(infos[1][7])
        }
        return infos

    mode_selector = {
        's': get_score, # 學期成績
        'c': None, # 學分資訊
        'y': None, # 學年成績
        'S': None, # 歷年學期成績
        'Y': None, # 歷年學年成績
        'r': None, # 重修科目
        'g': None, # 擔任幹部
        'C': None, # 社團
        'p': None, # 學期獎懲
        'P': None, # 歷年獎懲
        'n': None, # 學期缺曠
        "N": None, # 歷年缺曠
        'i': get_info
    }
    data = {}
    for i in mode:
        try:
            data[i] = mode_selector[i]()
        except KeyError:
            data[i] = {}
    return data