中興大學搶課程式.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "private_outputs": true,
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3.9.2 64-bit",
      "metadata": {
        "interpreter": {
          "hash": "e71fd9b7ad380b446644c192e2747bc2a2a72af82ccd9ee8b75c7eb12b73cd20"
        }
      }
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/NCHUIT/.github/blob/main/%E4%B8%AD%E8%88%88%E5%A4%A7%E5%AD%B8%E6%90%B6%E8%AA%B2%E7%A8%8B%E5%BC%8F.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aCrdRtSqfzht"
      },
      "source": [
        "# 中興大學 1092 學期搶課程式"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "o8DMXw2dw2hO"
      },
      "source": [
        "## 前言\n",
        "選課網頁每學期都有機會維護更新網站機制，因此不能保證年年可行。\n",
        "\n",
        "**請不要使用手機**，Colab 會莫名其妙把程式碼挖空。\n",
        "\n",
        "執行請點填寫區段左上角的三角形。\n",
        "\n",
        "要執行需要登入Google，<a href='https://research.google.com/colaboratory/intl/zh-TW/faq.html'>Colab</a> 是 Google 的，不必擔心 Google 帳號會被盜。\n",
        "\n",
        "若在意密碼洩漏問題，**這個共用筆記不會儲存任何執行結果**，或可以複製程式碼到新的colab筆記本執行，每個填寫區段的右上角的 \"…\" 有顯示程式碼的開關。\n",
        " \n",
        "在程式執行期間加選，若無法正常操作，代表間隔太短，**你需要在間隔內完成操作**。\n",
        "\n",
        "開發者免責聲明：此頁面之程式僅供學習用途，請勿用於商業用途，為避免程式出錯。程式執行期間還請手動選課，勿完全依賴本程式。\n",
        "\n",
        "若有問題可聯繫: [VJ](https://m.me/twjmy) | <twjmy@msn.com>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "D3IptT5pzJnr"
      },
      "source": [
        "# 登入 <sub>(密碼若知道伺服器密碼(固定)就填伺服器密碼，會加速執行。)</sub>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4cboZCmJ2Ocf",
        "cellView": "form"
      },
      "source": [
        "# @title 登入-資料填寫&執行\n",
        "from IPython.display import clear_output, display, HTML\n",
        "# #@title 登入-資料填寫&執行\n",
        "from requests import Session, post\n",
        "from bs4 import BeautifulSoup as bs\n",
        "from json import loads\n",
        "from random import random\n",
        "from getpass import getpass\n",
        "from datetime import datetime, timedelta\n",
        "from time import sleep\n",
        "from urllib3 import disable_warnings, exceptions\n",
        "disable_warnings(exceptions.InsecureRequestWarning)\n",
        "\n",
        "# @markdown 學號\n",
        "uid = '4111000111' #@param {type:\"string\"}\n",
        "# @markdown 密碼 (或<b>伺服器密碼</b>)\n",
        "pwd = '99990101' #@param {type:\"string\"}\n",
        "# @markdown  <a href=\"https://notify-bot.line.me/my/\">LINE Notify 通知權杖(點我註冊)</a>，<b>如果不需要通知請留空</b>\n",
        "token = '3ne7tkE1QtscrSpR8HTo7PG3b82OEBUu0YBBAxk1xlO' #@param {type:\"string\"}\n",
        "\n",
        "## 變數初始化\n",
        "plsql = 'https://onepiece.nchu.edu.tw/cofsys/plsql/'\n",
        "headers = { 'User-Agent': '' }\n",
        "\n",
        "## 函數初始化\n",
        "def wait(secends = 3, message=''):\n",
        "    if (message): print(message, end = '')\n",
        "    else: print(secends, '秒後重試', end = '')\n",
        "    if (secends):\n",
        "        for time_count in range(secends):\n",
        "            sleep(1)\n",
        "            print('.', end = '')\n",
        "    sleep(random())\n",
        "    print('.')\n",
        "    clear_output(True)\n",
        "\n",
        "def lineNotify(message:str, notificationDisabled=False):\n",
        "    if(len(message)>1000): message = message[:1000]\n",
        "    x = post( url = 'https://notify-api.line.me/api/notify',\n",
        "        headers = { 'Authorization': 'Bearer '+token }, verify=False,\n",
        "        data = { 'message': '['+str(datetime.today()+timedelta(hours=8))+'] '+message ,\n",
        "                 'notificationDisabled':notificationDisabled })\n",
        "    if(x.status_code == 200): result = '成功發送 LINE Notify 通知: \"'+message+'\"'\n",
        "    else: result = loads(x.text)['message']\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "\n",
        "# 登入(預置或存取伺服器cookie)\n",
        "rs = Session()\n",
        "if (not uid): uid = input('請輸入學號: ')\n",
        "if (not pwd): pwd = getpass('請輸入密碼: ')\n",
        "rs.cookies.set('cookie_psstud', uid)\n",
        "rs.cookies.set('cookie_pwd', pwd)\n",
        "r=rs.get( plsql+'stud_frameset',headers=headers,verify=False )\n",
        "if (r.text.rfind('名稱或密碼錯誤') != -1):\n",
        "    rs=Session()\n",
        "    rs.post( plsql+'ACAD_PASSCHK',headers=headers,verify=False,data={'v_emp':uid,'v_pwd':pwd} )\n",
        "r=rs.get( plsql+'stud_frameset',headers=headers,verify=False )\n",
        "\n",
        "count = 0\n",
        "while (r.text.rfind('名稱或密碼錯誤') != -1):\n",
        "    r,rs=None,Session()\n",
        "    count += 1\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] 登入失敗第', count,'次，帳號或密碼錯誤，請重新輸入...')\n",
        "    uid,pwd = input('學號: '), getpass('登入密碼: ')\n",
        "    rs.post( plsql+'ACAD_PASSCHK',headers=headers,verify=False,data={'v_emp':uid,'v_pwd':pwd} )\n",
        "    r=rs.get( plsql+'stud_frameset',headers=headers,verify=False )\n",
        "\n",
        "r=rs.get( plsql+'studframe_left', headers=headers,verify=False )\n",
        "welcomeMsg=bs(r.text, 'lxml').find('font', {'size': '3'}).text.replace('\\n',' ')\n",
        "\n",
        "if (token): lineNotify('登入成功 '+welcomeMsg+' 伺服器密碼:'+rs.cookies.get('cookie_pwd'))\n",
        "else: print('['+str(datetime.today()+timedelta(hours=8))+'] 登入成功', welcomeMsg, ' 伺服器密碼:', rs.cookies.get('cookie_pwd'))\n",
        "\n",
        "# 畢業審查查詢\n",
        "# r=rs.get( 'https://onepiece.nchu.edu.tw/cofsys/plsql/grad_stud_summary',headers=headers,verify=False )\n",
        "# display(HTML(r.text))\n",
        "\n",
        "print()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "K6TG_2aDuHkD"
      },
      "source": [
        "# 1092 學期加退選於 110/02/22 10:00 開始 <sub>(02/24 10:00 清除候補)</sub>\n",
        "\n",
        "於開始時搶課請確保現有通識課程(含候補)小於 4 門，欲搶之課程也請確保與現有通識課程(含候補)相加後不大於 4 門。"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nqm0ZkmAmKHU",
        "cellView": "form"
      },
      "source": [
        "# @title 課號加選-資料填寫&執行\n",
        "\n",
        "# @markdown 選課號碼 (注意:非<a href='#scrollTo=rf31bcNpE1MU'>課程代號</a>)<br><small><small><small><small>採直接加選系統，可以填入<b>任意課程選課號碼(最多10門)</b>，請確保號碼正確，多個請用空格隔開，格式如:<br>4705 3803 1750 3494</small></small></small></small>\n",
        "class_nbr = '0001 1002 2003 3004' #@param {type:\"string\"}\n",
        "# @markdown 換課 <small><small><small><small>(衝堂或名稱相同的同時課程可選時自動退選)</small></small></small></small>\n",
        "change = True #@param {type:\"boolean\"}\n",
        "# @markdown 載入失敗(未開放)時重試\n",
        "load_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 加選失敗時重試 <small><small><small><small>(除課程滿額外不設此限)</small></small></small></small>\n",
        "add_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 重試間隔(單位：秒)，最後一秒會隨機取0~1之間。\n",
        "delay = 2 #@param {type:\"slider\", min:0, max:60, step:1}\n",
        "\n",
        "try: rs\n",
        "except NameError:\n",
        "    print('執行中斷：請先執行登入區塊')\n",
        "    exit()\n",
        "\n",
        "try: class_nbr = class_nbr.split(' ')\n",
        "except: class_nbr = input(\"請以空格隔開輸入要加選的課程代號: \").split(' ')\n",
        "\n",
        "if len(class_nbr)>10:\n",
        "    class_nbr = class_nbr[:10]\n",
        "    if token: lineNotify('欲加選課程大於10門，取前10門')\n",
        "    else: print('['+str(datetime.today()+timedelta(hours=8))+'] 欲加選課程大於10門，取前10門')\n",
        "\n",
        "data = class_nbr.copy()\n",
        "while len(data)<10: data.append('')\n",
        "data = { 'v_want': data }\n",
        "\n",
        "if token: lineNotify('''設定:\n",
        "'''+'選課號碼: '+' '.join(class_nbr)+'''\n",
        "'''+'換課: '+('是' if change else '否')+'''\n",
        "'''+'載入失敗時重試: '+('是' if load_retry else '否')+'''\n",
        "'''+'加選失敗時重試: '+('是' if add_retry else '否')+'''\n",
        "'''+'重試間隔: '+str(delay)+''' 秒\n",
        "開始直接加選...''')\n",
        "else: print('['+str(datetime.today()+timedelta(hours=8))+'''] 設定:\n",
        "'''+'選課號碼: '+' '.join(class_nbr)+'''\n",
        "'''+'換課: '+('是' if change else '否')+'''\n",
        "'''+'載入失敗(未開放)時重試: '+('是' if load_retry else '否')+'''\n",
        "'''+'加選失敗時重試: '+('是' if add_retry else '否')+'''\n",
        "'''+'重試間隔: '+str(delay)+''' 秒\n",
        "開始直接加選...''')\n",
        "print()\n",
        "\n",
        "## 課號加選-填寫，看開不開放，同時向伺服器拿'cookie_key'(若有)\n",
        "r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\n",
        "load_count = 1\n",
        "while (load_retry and r.text.rfind('本時段不開放此功能') != -1):\n",
        "    r=None\n",
        "    if load_count%(1800/(delay+1))==0: lineNotify('載入失敗第 '+str(load_count)+' 次，本時段不開放此功能。繼續重試...',True)\n",
        "    else: print('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第 ', load_count,' 次，本時段不開放此功能。',end='')\n",
        "    load_count += 1\n",
        "    wait(delay)\n",
        "\n",
        "    now = datetime.today()+timedelta(hours=8)\n",
        "    start = now.replace(hour=7, minute=58, second=59, microsecond=499999)\n",
        "    end = now.replace(hour=9, minute=59, second=0, microsecond=0)\n",
        "    while start<datetime.today()+timedelta(hours=8)<end:\n",
        "        if not (datetime.today()+timedelta(hours=8) -now).seconds % 600: #每 10 分鐘發通知\n",
        "            if token: lineNotify('等待系統維護，程式仍在執行中', True)\n",
        "            else: print('['+str(datetime.today()+timedelta(hours=8))+'] 等待系統維護，程式仍在執行中')\n",
        "        if not (datetime.today()+timedelta(hours=8) -now).seconds % 30: print('.',end='')\n",
        "        sleep(1)\n",
        "\n",
        "    r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\n",
        "# 課號加選-確認\n",
        "print('['+str(datetime.today()+timedelta(hours=8))+'] 檢驗課號正確性...')\n",
        "r=rs.post(plsql+'enro_direct2_chk',headers=headers,verify=False,data=data)\n",
        "display(HTML(r.text))\n",
        "\n",
        "# with open(r'選課\\response\\輸入課號加選\\2.課號加選-確認-110-2-23.html', encoding=\"utf-8\") as f: a=f.read()\n",
        "\n",
        "table_chk = bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "while not table_chk:\n",
        "    load_retry += 1\n",
        "    r=rs.post(plsql+'enro_direct2_chk',headers=headers,verify=False,data=data)\n",
        "    table_chk = bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "v_tick = []\n",
        "skip_msg, skip = '無此選課號碼: ', 0\n",
        "for each_class_nbr in class_nbr:\n",
        "    tag = table_chk.find('td', string=each_class_nbr)\n",
        "    if tag:\n",
        "        value = tag.find_previous_sibling('td').find('input')\n",
        "        if value: v_tick.append(value['value'])\n",
        "        else:\n",
        "            skip += 1\n",
        "            skip_msg += each_class_nbr+' '\n",
        "            class_nbr.remove(each_class_nbr)\n",
        "print()\n",
        "\n",
        "skip_msg += '，已略過。'\n",
        "if skip:\n",
        "    if token: lineNotify(skip_msg)\n",
        "    else: print('['+str(datetime.today()+timedelta(hours=8))+'] '+skip_msg)\n",
        "    print()\n",
        "\n",
        "add_result = '加選結果 '\n",
        "cookie_key=False\n",
        "if rs.cookies.get('cookie_key'):\n",
        "    cookie_key=True\n",
        "    add_result += str(rs.cookies.get('cookie_key'))\n",
        "add_result += '''...\n",
        "'''\n",
        "\n",
        "## 課號加選-完成\n",
        "data = { 'p_stud_no': uid, 'v_tick': v_tick }\n",
        "r=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "display(HTML(r.text))\n",
        "\n",
        "#with open(r'選課\\response\\輸入課號加選\\3.課號加選-結果-110-2-23.html', encoding=\"utf-8\") as f: a=f.read()\n",
        "\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "while not table:\n",
        "    load_retry += 1\n",
        "    r=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "    table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "v_del=[]\n",
        "retry, chang = False, False\n",
        "if table and table_chk:\n",
        "    ths_chk = table_chk.find_all('th')\n",
        "    ths = table.find_all('th')\n",
        "    rths = ths_chk[1:3]+ths_chk[7:]\n",
        "    if ths[7]: rths.append(ths[7])\n",
        "    add_result += '-'.join([th.text for th in rths])+'''\n",
        "'''\n",
        "    for tr_chk, tr in zip(table_chk.find_all('tr'),table.find_all('tr')):\n",
        "        tds_chk = tr_chk.find_all('td')\n",
        "        for i in [2, 7]:\n",
        "            if i>=len(tds_chk): break\n",
        "            tds_chk[i].string = tds_chk[i].decode_contents()\n",
        "            bi_chk = tds_chk[i].string.rfind('<br/>')\n",
        "            if bi_chk: tds_chk[i].string = tds_chk[i].string[:bi_chk]\n",
        "        tds = tr.find_all('td')\n",
        "        if tds[0].form: break\n",
        "        tds_chk = table_chk.find('td', string=tds[0].text).find_parent('tr').find_all('td')\n",
        "        nbr = str(tds[7].text)[10:14]\n",
        "        if nbr.isdigit() and int(tds_chk[8].text)>int(tds_chk[9].text): v_del.append(nbr)\n",
        "        chang = chang or nbr.isdigit()\n",
        "        retry = retry or chang or tds[7].text.find('課程已額滿') != -1\n",
        "        rtds = tds_chk[1:3]+tds_chk[7:]\n",
        "        if tds_chk[2].text=='無此選課號': rtds = tds_chk[1:3]\n",
        "        if tds[7]: rtds.append(tds[7])\n",
        "        add_result += '-'.join([rtd.text for rtd in rtds])+'''\n",
        "'''\n",
        "\n",
        "change = change and chang\n",
        "if change and v_del:\n",
        "    drop_result = '退選課程: '+' '.join(v_del)+''' ...\n",
        "'''\n",
        "    r = rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "    table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "    while not table:\n",
        "        load_retry += 1\n",
        "        r = rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "        table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "    v_del = [table.find('font',string=v).find_parent('td').find_previous_sibling('td').input['value'] for v in v_del]\n",
        "    data = { 'v_del': v_del }\n",
        "    rs.post(plsql+'enro_del2_check',headers=headers,verify=False,data=data)\n",
        "    r = rs.post(plsql+'enro_del3_drop',headers=headers,verify=False,data=data)\n",
        "    table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "    while not table:\n",
        "        load_retry += 1\n",
        "        rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "        rs.post(plsql+'enro_del2_check',headers=headers,verify=False,data=data)\n",
        "        r = rs.post(plsql+'enro_del3_drop',headers=headers,verify=False,data=data)\n",
        "        table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "    ths = table.find_all('th')\n",
        "    rths = [ths[0],ths[1],ths[5],ths[6]]\n",
        "    drop_result += '-'.join([th.text for th in rths])+'''\n",
        "'''\n",
        "    tr_count = 0\n",
        "    tds = table.find_all('td')\n",
        "    for td in tds[1::7]+tds[5::7]:\n",
        "        td.font.string = td.font.decode_contents()\n",
        "        bi = td.font.string.rfind('<br/>')\n",
        "        if bi: td.font.string = td.font.string[:bi]\n",
        "    n = int(len(tds)//7)\n",
        "    for i in range(n):\n",
        "        drop_result += '-'.join([td.text for td in [tds[0+7*i],tds[1+7*i],tds[5+7*i],tds[6+7*i]]])+'''\n",
        "'''\n",
        "    data = { 'p_stud_no': uid, 'v_tick': v_tick }\n",
        "    rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "    if token: lineNotify(drop_result[:-1])\n",
        "    else: print('['+str(datetime.today()+timedelta(hours=8))+'] '+drop_result[:-1])\n",
        "\n",
        "count = 1\n",
        "add_retry = add_retry and retry\n",
        "while add_retry:\n",
        "    add_retry = False\n",
        "    r=None\n",
        "    add_result = welcomeMsg+'總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+' 次，'+add_result\n",
        "    if token and (count==1 or count%(1800/(delay+1))==0): lineNotify(add_result+'繼續重試...',True)\n",
        "    else: print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result+'繼續重試...')\n",
        "    wait(delay)\n",
        "\n",
        "    # 課號加選-填寫，看開不開放，同時向伺服器拿'cookie_key'(若有)\n",
        "    r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\n",
        "    while (load_retry and r.text.rfind('本時段不開放此功能') != -1):\n",
        "        r=None\n",
        "        if load_count%(1800/(delay+1))==0: lineNotify(add_result+'載入失敗第 '+str(load_count)+' 次，本時段不開放此功能。繼續重試...',True)\n",
        "        else: print('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第 ', load_count,' 次，本時段不開放此功能。',end='')\n",
        "        load_count += 1\n",
        "        wait(delay)\n",
        "\n",
        "        now = datetime.today()+timedelta(hours=8)\n",
        "        start = now.replace(hour=7, minute=58, second=59, microsecond=499999)\n",
        "        end = now.replace(hour=9, minute=59, second=0, microsecond=0)\n",
        "        while start<datetime.today()+timedelta(hours=8)<end:\n",
        "            if not (datetime.today()+timedelta(hours=8) -now).seconds % 600: #每 10 分鐘發通知\n",
        "                if token: lineNotify('等待系統維護，程式仍在執行中', True)\n",
        "                else: print('['+str(datetime.today()+timedelta(hours=8))+'] 等待系統維護，程式仍在執行中')\n",
        "            if not (datetime.today()+timedelta(hours=8) -now).seconds % 30: print('.',end='')\n",
        "            sleep(1)\n",
        "\n",
        "        r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\n",
        "    # 課號加選-確認-確認人數\n",
        "    v_want = class_nbr.copy()\n",
        "    while len(v_want)<10: v_want.append('')\n",
        "    data = { 'v_want': v_want }\n",
        "    r=rs.post(plsql+'enro_direct2_chk',headers=headers,verify=False,data=data)\n",
        "    display(HTML(r.text))\n",
        "\n",
        "    table_chk = bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "    while not table_chk:\n",
        "        load_retry += 1\n",
        "        r=rs.post(plsql+'enro_direct2_chk',headers=headers,verify=False,data=data)\n",
        "        table_chk = bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "    add_result = '加選結果 '\n",
        "    if cookie_key:\n",
        "        r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "        add_result += str(rs.cookies.get('cookie_key'))\n",
        "    add_result += '''...\n",
        "'''\n",
        "\n",
        "    ## 課號加選-完成\n",
        "    data = { 'p_stud_no': uid, 'v_tick': v_tick }\n",
        "    r=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "    display(HTML(r.text))\n",
        "\n",
        "    table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "    while not table:\n",
        "        load_retry += 1\n",
        "        r=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "        display(HTML(r.text))\n",
        "        table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "    v_del=[]\n",
        "    retry = False\n",
        "    if table and table_chk:\n",
        "        ths_chk = table_chk.find_all('th')\n",
        "        ths = table.find_all('th')\n",
        "        rths = ths_chk[1:3]+ths_chk[7:]\n",
        "        if ths[7]: rths.append(ths[7])\n",
        "        add_result += '-'.join([th.text for th in rths])+'''\n",
        "'''\n",
        "        for tr_chk, tr in zip(table_chk.find_all('tr'),table.find_all('tr')):\n",
        "            tds_chk = tr_chk.find_all('td')\n",
        "            for i in [2, 7]:\n",
        "                if i>=len(tds_chk): break\n",
        "                tds_chk[i].string = tds_chk[i].decode_contents()\n",
        "                bi_chk = tds_chk[i].string.rfind('<br/>')\n",
        "                if bi_chk: tds_chk[i].string = tds_chk[i].string[:bi_chk]\n",
        "            tds = tr.find_all('td')\n",
        "            if tds[0].form: break\n",
        "            tds_chk = table_chk.find('td', string=tds[0].text).find_parent('tr').find_all('td')\n",
        "            nbr = str(tds[7].text)[10:14]\n",
        "            if nbr.isdigit() and int(tds_chk[8].text)>int(tds_chk[9].text): v_del.append(nbr)\n",
        "            change = change or nbr.isdigit()\n",
        "            add_retry = add_retry or change or tds[7].text.find('課程已額滿') != -1\n",
        "            rtds = tds_chk[1:3]+tds_chk[7:]\n",
        "            if tds[7]: rtds.append(tds[7])\n",
        "            add_result += '-'.join([rtd.text for rtd in rtds])+'''\n",
        "'''\n",
        "\n",
        "    change = change and chang\n",
        "    if change and v_del:\n",
        "        drop_result = '退選課程: '+' '.join(v_del)+''' ...\n",
        "'''\n",
        "        r = rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "        table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "        while not table:\n",
        "            load_retry += 1\n",
        "            r = rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "            table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "        v_del = [table.find('font',string=v).find_parent('td').find_previous_sibling('td').input['value'] for v in v_del]\n",
        "        data = { 'v_del': v_del }\n",
        "        rs.post(plsql+'enro_del2_check',headers=headers,verify=False,data=data)\n",
        "        r = rs.post(plsql+'enro_del3_drop',headers=headers,verify=False,data=data)\n",
        "        table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "        while not table:\n",
        "            load_retry += 1\n",
        "            rs.get(plsql+'enro_del1_list',headers=headers,verify=False)\n",
        "            rs.post(plsql+'enro_del2_check',headers=headers,verify=False,data=data)\n",
        "            r = rs.post(plsql+'enro_del3_drop',headers=headers,verify=False,data=data)\n",
        "            table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\n",
        "        ths = table.find_all('th')\n",
        "        rths = [ths[0],ths[1],ths[5],ths[6]]\n",
        "        drop_result += '-'.join([th.text for th in rths])+'''\n",
        "'''\n",
        "        tr_count = 0\n",
        "        tds = table.find_all('td')\n",
        "        for td in tds[1::7]+tds[5::7]:\n",
        "            td.font.string = td.font.decode_contents()\n",
        "            bi = td.font.string.rfind('<br/>')\n",
        "            if bi: td.font.string = td.font.string[:bi]\n",
        "        n = int(len(tds)//7)\n",
        "        for i in range(n):\n",
        "            drop_result += '-'.join([td.text for td in [tds[0+7*i],tds[1+7*i],tds[5+7*i],tds[6+7*i]]])+'''\n",
        "'''\n",
        "        data = { 'p_stud_no': uid, 'v_tick': v_tick }\n",
        "        rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "        if token: lineNotify(drop_result[:-1])\n",
        "        else: print('['+str(datetime.today()+timedelta(hours=8))+'] '+drop_result[:-1])\n",
        "    count += 1\n",
        "print()\n",
        "\n",
        "## 到學生選課主畫面看目前選課狀態\n",
        "result = '''目前選課狀態...\n",
        "'''\n",
        "r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "display(HTML(r.text))\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "while not table:\n",
        "    load_retry += 1\n",
        "    r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "    table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "    ths = table.find_all('th')\n",
        "    rths = [ths[0],ths[1],ths[5],ths[8]]\n",
        "    result += '-'.join([th.text for th in rths])+'''\n",
        "'''\n",
        "    tr_count = 0\n",
        "    tds = table.find_all('td')\n",
        "    for td in tds[1::9]+tds[5::9]:\n",
        "        td.font.string = td.font.decode_contents()\n",
        "        bi = td.font.string.rfind('</a>') if td.font.string.rfind('</a>')>-1 else td.font.string.rfind('<br/>')\n",
        "        if bi>-1: td.font.string = td.font.string[:bi]\n",
        "        if td.font.string.rfind('target=\"_blank\">')>-1:\n",
        "            ai = td.font.string.rfind('target=\"_blank\">')+16\n",
        "            td.font.string = td.font.string[ai:]\n",
        "    n = int(len(tds)//9)\n",
        "    for i in range(n):\n",
        "        result += '-'.join([td.text for td in [tds[0+9*i],tds[1+9*i],tds[5+9*i],tds[8+9*i]]])+'''\n",
        "'''\n",
        "\n",
        "add_result = welcomeMsg+'總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+' 次，'+add_result\n",
        "if token:\n",
        "    lineNotify(result[:-1])\n",
        "    print()\n",
        "    lineNotify(add_result[:-1])\n",
        "else:\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "    print()\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "y-sA3pMfdAAA"
      },
      "source": [
        "#1092 學期體育加選於 110/02/03 10:00 開始 <sub>(二年級)</sub>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mAkuFyaqdAAF",
        "cellView": "form"
      },
      "source": [
        "# @title 體育加選-資料填寫&執行\n",
        "\n",
        "# @markdown 選課號碼 (注意:非<a href='#scrollTo=rf31bcNpE1MU'>課程代號</a>)<br><small><small><small><small>採體育加選系統，限填入<b>體育選課號碼</b>，請確保號碼正確，多個請用空格隔開，格式如:<br>0628 2027 0004</small></small></small></small>\n",
        "class_nbr = '0056 0065 9998' #@param {type:\"string\"}\n",
        "# @markdown 載入失敗(未開放)時重試\n",
        "load_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 加選失敗時重試 <small><small><small><small>(本學期已選修超過4門通識課程、該類課程每學期只可加選一門、日夜互選不適用於網路選課、名稱相同、該課程已選、衝堂、選課時間有誤(錯誤訊息) 不設此限)</small></small></small></small>\n",
        "add_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 重試間隔(單位：秒)，最後一秒會隨機取0~1之間。\n",
        "delay = 2 #@param {type:\"slider\", min:0, max:5, step:1}\n",
        "\n",
        "try: rs\n",
        "except NameError:\n",
        "\tprint('執行中斷：請先執行登入區塊')\n",
        "\texit()\n",
        "\n",
        "try: class_nbr = class_nbr.split(' ')\n",
        "except: class_nbr = input(\"請以空格隔開輸入要加選的體育課程選課號碼: \").split(' ')\n",
        "\n",
        "if token: lineNotify('開始體育加選...')\n",
        "else: print('['+str(datetime.today()+timedelta(hours=8))+'] 開始體育加選...')\n",
        "print()\n",
        "\n",
        "## 體育軍訓選課-勾選清單，看開不開放，同時向伺服器拿每個課程的'v_tick'\n",
        "r=rs.get(plsql+'enro_sport_list?v_action=sport',headers=headers,verify=False)\n",
        "if (r.text.rfind('目前無法選課') != -1): print('目前無法選課。')\n",
        "\n",
        "load_count = 1\n",
        "while (load_retry and r.text.rfind('目前無法選課') != -1):\n",
        "\tr=None\n",
        "\tload_count += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第', load_count,'次，目前無法選課。',end='')\n",
        "\twait(delay)\n",
        "\n",
        "\tr=rs.get(plsql+'enro_sport_list?v_action=sport',headers=headers,verify=False)\n",
        "\tclear_output(True)\n",
        "\n",
        "x=bs(r.text, 'lxml')\n",
        "v_tick = []\n",
        "skip = 0\n",
        "for each_class_nbr in class_nbr:\n",
        "    tag = x.find('font', string=each_class_nbr)\n",
        "    if tag: v_tick.append(tag.find_parent('td').find_previous_sibling('td').find('input')['value'])\n",
        "    else:\n",
        "        skip += 1\n",
        "        if token: lineNotify('無此選課號碼: '+each_class_nbr+'，已略過。')\n",
        "        else: print('['+str(datetime.today()+timedelta(hours=8))+'] 無此選課號碼: '+each_class_nbr+'，已略過。')\n",
        "data = { 'p_stud_no': uid, 'v_tick': v_tick }\n",
        "if skip: print()\n",
        "\n",
        "print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "cookie_key=False\n",
        "if (rs.cookies.get('cookie_key')):\n",
        "\tcookie_key=True\n",
        "\tprint(rs.cookies.get('cookie_key'), end=' ')\n",
        "print('...')\n",
        "\n",
        "## 體育軍訓選課-完成\n",
        "r=rs.post(plsql+'enro_nomo3_dml',headers=headers,verify=False,data=data)\n",
        "table=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "if table:\n",
        "\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tindex = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tindex += 1\n",
        "\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\tif add_retry: add_retry = (\n",
        "\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t)\n",
        "\t\t\tprint(td.text)\n",
        "\t\telse: print(td.text, end = '-')\n",
        "\t\tif index==(len(v_class_nbr)-skip)*len(table.findAll('th')): break\n",
        "\n",
        "count = 1\n",
        "while add_retry:\n",
        "\tadd_retry = False\n",
        "\tr=None\n",
        "\tcount += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 加選失敗第', count,'次。',end='')\n",
        "\twait(delay)\n",
        "\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "\tif (cookie_key):\n",
        "\t\tr=rs.get(plsql+'enro_sport_list?v_action=sport',headers=headers,verify=False)\n",
        "\t\tprint(rs.cookies.get('cookie_key'), end=' ')\n",
        "\tprint('...')\n",
        "\n",
        "\tr=rs.post(plsql+'enro_nomo3_dml',headers=headers,verify=False,data=data)\n",
        "\ttable=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "\tif table:\n",
        "\t\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\t\tindex = 0\n",
        "\t\tfor td in table.findAll('td'):\n",
        "\t\t\tindex += 1\n",
        "\t\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\t\tadd_retry = add_retry or (\n",
        "\t\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t\t)\n",
        "\t\t\t\tprint(td.text)\n",
        "\t\t\telse: print(td.text, end = '-')\n",
        "\t\t\tif index==(len(v_class_nbr)-skip)*len(table.findAll('th')): break\n",
        "print()\n",
        "\n",
        "# 加選結果訊息\n",
        "add_result = '總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+''' 次，加選結果:\n",
        "'''\n",
        "if table:\n",
        "    add_result += '-'.join([th.text for th in table.findAll('th')])+'''\n",
        "'''\n",
        "    index = 0\n",
        "    print((len(v_class_nbr)-skip)*len(table.findAll('th')))\n",
        "    for td in table.findAll('td'):\n",
        "        index += 1\n",
        "        if index==(len(v_class_nbr)-skip)*len(table.findAll('th')):\n",
        "            add_result += str (index)+td.text\n",
        "            break\n",
        "        if index%len(table.findAll('th'))==0: add_result += str (index)+td.text+'''\n",
        "'''\n",
        "        else: add_result += str (index)+td.text+'-'\n",
        "\n",
        "## 到學生選課主畫面看目前選課狀態\n",
        "result = '''目前選課狀態...\n",
        "'''\n",
        "r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "\tresult += ('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tcount = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tcount += 1\n",
        "\t\tif count==len(table.findAll('td')): result += td.text\n",
        "\t\telif count%len(table.findAll('th'))==0: result += td.text+'''\n",
        "'''\n",
        "\t\telse: result += td.text+'-'\n",
        "if token:\n",
        "    lineNotify(result)\n",
        "    print()\n",
        "    lineNotify(add_result)\n",
        "else:\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "    print()\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w4pe1cNitmVI"
      },
      "source": [
        "#1092 學期通識加選於 110/01/22 10:00 開始"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kXJQ8YCAj3ce",
        "cellView": "form"
      },
      "source": [
        "# @title 通識加選-資料填寫&執行\n",
        " \n",
        "# @markdown <a href='#scrollTo=rf31bcNpE1MU'>課程代號(點我看說明)</a><br><small><small><small><small>通識加選系統，限填入<font color=\"red\">通識課程代號</font>，請確保代號正確，多個請用空格隔開，格式如:<br>0327 7942 0420</small></small></small></small>\n",
        "v_class_nbr = '2507 5224 3290' #@param {type:\"string\"}\n",
        "# @markdown 載入失敗(未開放)時重試\n",
        "load_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 加選失敗時重試 <small><small><small><small>(本學期已選修超過4門通識課程、該類課程每學期只可加選一門、日夜互選不適用於網路選課、名稱相同、該課程已選、衝堂、選課時間有誤(錯誤訊息) 不設此限)</small></small></small></small>\n",
        "add_retry = False #@param {type:\"boolean\"}\n",
        "# @markdown 重試間隔，規格同上\n",
        "delay = 2 #@param {type:\"slider\", min:0, max:5, step:1}\n",
        " \n",
        "try: rs\n",
        "except NameError:\n",
        "    print('執行中斷：請先執行登入區塊')\n",
        "    exit()\n",
        " \n",
        "try: v_class_nbr = v_class_nbr.split(' ')\n",
        "except: v_class_nbr = input(\"請以空格隔開輸入要加選的通識課程代號: \").split(' ')\n",
        "\n",
        "data = { 'v_click': v_class_nbr }\n",
        " \n",
        "if token: lineNotify('開始通識加選...')\n",
        "else: print('開始通識加選...')\n",
        "print()\n",
        "\n",
        "## 通識加選-選擇清單，看開不開放，順便向伺服器拿'cookie_key'\n",
        "r=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "if r.text.rfind('本時段不開放此功能') != -1: print('本時段不開放此功能。')\n",
        " \n",
        "load_count = 1\n",
        "while (load_retry and r.text.rfind('本時段不開放此功能') != -1):\n",
        "\tr=None\n",
        "\tload_count += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第', load_count,'次，本時段不開放加選。',end='')\n",
        "\n",
        "\twait(delay)\n",
        "\tr=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "\tclear_output(True)\n",
        "\n",
        "print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "cookie_key=False\n",
        "if rs.cookies.get('cookie_key'):\n",
        "    cookie_key=True\n",
        "    print(rs.cookies.get('cookie_key'), end=' ')\n",
        "print('...')\n",
        "\n",
        "## 通識加選-確認\n",
        "r=rs.post(plsql+'gned_add4_dml',headers=headers,verify=False,data=data)\n",
        "table=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "if table:\n",
        "\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tindex = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tindex += 1\n",
        "\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\tif add_retry: add_retry = (\n",
        "\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t)\n",
        "\t\t\tprint(td.text)\n",
        "\t\telse: print(td.text, end = '-')\n",
        "\t\tif index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        " \n",
        "count = 1\n",
        "while add_retry:\n",
        "\tadd_retry = False\n",
        "    r=None\n",
        "    count += 1\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] 加選失敗第', count,'次。',end='')\n",
        "    wait(delay)\n",
        " \n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "    if cookie_key:\n",
        "        r=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "        print(rs.cookies.get('cookie_key'), end=' ')\n",
        "    print('...')\n",
        " \n",
        "    r=rs.post(plsql+'gned_add4_dml',headers=headers,verify=False,data=data)\n",
        "    table=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "    if table:\n",
        "        print('-'.join([th.text for th in table.findAll('th')]))\n",
        "        index = 0\n",
        "        for td in table.findAll('td'):\n",
        "            index += 1\n",
        "            if index%len(table.findAll('th'))==0:\n",
        "                add_retry = add_retry or (\n",
        "                    td.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "                    td.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "                    td.text.find('選課時間有誤') == -1 and\n",
        "                    td.text.find('該課程已選') == -1 and\n",
        "                    td.text.find('名稱相同') == -1 and\n",
        "                    td.text.find('衝堂') == -1\n",
        "                )\n",
        "                print(td.text)\n",
        "            else: print(td.text, end = '-')\n",
        "            if index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        "print()\n",
        "\n",
        "# 加選結果訊息\n",
        "add_result = '總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+''' 次，加選結果:\n",
        "'''\n",
        "if table:\n",
        "    add_result += '-'.join([th.text for th in table.findAll('th')])+'''\n",
        "'''\n",
        "    index = 0\n",
        "    for td in table.findAll('td'):\n",
        "        index += 1\n",
        "        if index==len(v_class_nbr)*len(table.findAll('th')):\n",
        "            add_result += td.text\n",
        "            break\n",
        "        if index%len(table.findAll('th'))==0: add_result += td.text+'''\n",
        "'''\n",
        "        else: add_result += td.text+'-'\n",
        "\n",
        "## 到學生選課主畫面看目前選課狀態\n",
        "result = '''目前選課狀態...\n",
        "'''\n",
        "r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "\tresult += ('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tcount = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tcount += 1\n",
        "\t\tif count==len(table.findAll('td')): result += td.text\n",
        "\t\telif count%len(table.findAll('th'))==0: result += td.text+'''\n",
        "'''\n",
        "\t\telse: result += td.text+'-'\n",
        "if token:\n",
        "    lineNotify(result)\n",
        "    print()\n",
        "    lineNotify(add_result)\n",
        "else:\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "    print()\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rf31bcNpE1MU"
      },
      "source": [
        "# 課程代號\n",
        "**課程代號**請於**課綱**網頁的網址尾端截取 \"v_class_nbr=****\" (四碼) 如下所示：\n",
        "![image.png](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwcAAAAsCAYAAAAw28QnAAAZlUlEQVR4Ae1dzY4cx5H2g+xxD+KQQ5rkkBINCnoEGj7Zu3um+AQkT8YCJG3v+mIKkH22fbakqxd7XS3om3SnH0CAD/MEZWRGRmb8ZVb1T3XPND8Cg+6uyoyfL76MjKiqbv7owcOfTPgDBuAAOAAOgAPgADgADoAD4AA48COQACQAB8ABcAAcAAfAAXAAHAAHwIHEATQHuHOCO0fgADgADoAD4AA4AA6AA+BA5gCaAxAByQAcAAfAAXAAHAAHwAFwABzIHEBzACIgGYAD4AA4AA6AA+AAOAAOgAOZAzs3B3fvPZzOb9+bbt66M53dvD3duHk+3TjDHzAAB8ABcAAcAAfAAXAAHAAHrhsHtmoO7l98khuC6+Ys7MUCBQfAAXAAHAAHwAFwABwAB/oc2Kg5uH/xcWkKbuHuAO6OgAPgADgADoAD4AA4AA6AAyfGgcXNQWoM8mNDRwTgozM0Jeh0+50usAE24AA4AA6AA+AAOAAO7MaBRc3BvfsfTzfObqMzPGJjBKLvRnTgB/zAAXAAHAAHwAFw4B//8q/TKf2twenZ5oAaA5BpDfAhE7wCB8ABcAAcAAfAAXDgcBxIjcGp4L2WL8Pm4OLBJ0d/lOhUAgg/DrfwgTWwBgfAAXAAHAAHwIGIA2sV1JGutY+t5Uu3Obh48Cj/POnajkE+Fi84AA6AA+AAOAAOgAPgwCE4sFZBfQjbrY61fOk2B3fuXpzMbRcLJj4jAYED4AA4AA6AA+AAOPDhcWCtgvoYXFrLl7A5SI8THcNJ6PzwFilijpiDA+AAOAAOgAPgwKE4sFZBfSj7pZ61fAmbg/M799Ec7PmXiX717nKapsvp3a9PNQH8ZkouXr77zRXnDtk5vf/mittJPHn8+Zvpd29fTk/2zMeaXD59Nr16+8X0u/T3+tn0eC09M3K38/Oz6enrL6ZXn3+2Uix/Nj1/+8X0/KejNUtjpA1PXhQ8d8LV684YbRGjbedVjszE7iqPI169mZ5+Oorhgc799CWtM+bFi5+txNsD+XMwXqR1PsqBlAdyDsvY9uJNa6qN68i0cRrmAKt7Ll8cLjbXf937HLivXLOkoKbcIXN5xCsff+JXNPZ8snuD3Vvs+cbV/h69xJdtcHPNQfquwTaCenMePHw0/dd//3b661//Z/ryy99P6XNv7CkfR3NwuKQ45tGem4Ov/z5N09+nr1bZKCnxyMJz7NumGPvCdr/yl9qzrZ/bzltq14LNKRcSXGSU4sMWfWmMPTbLF697281+23nH4cLS2CwbRxt8vFEf1D/HgQ5XZnmxzO+ub4qvO8pa29Ysv+DUvUDicQxjXi6CyFxKhRiv3YJFxsfwJR+LLkKUwlA27GWsLfq68VgRw+u/7n0O3BeOcwU1cUhzg47Z5m+pjTtypfA34tWcL9ti5pqDff50aWoEvvvuu+nbb/8/NwjpNX3+UBuEbYN0PeZ9oHcO1mwOoo1qn5vJ2vKX2rq1HcduDkrCL4V/LjZkobDU/3Cc33S23ey3nXc98s51KHA7Nmbe6wJkdcyPoTPkdwcTMZaLMbp6GuMUc1uvyxtn9jPrDo5/+ll49zRc27lgM41EVxfrPNxrjM3h9O/OZZ8Dd5dJ/s8V1I8/je5GB3w5W2hjZ92FvBJrgP0djZvzhWVs+uqag30+UvTLX/7n9P3336s7BelzOr6poRh/1Rc1moN9czQnhI2vOG/Ak62L8g10BInO4rS9n5Ss5dVAK3u3zzOJXxUH0caxC05e97ab/bbzdsNuF98/jLk5Lt0r4ith0ClSrlqsJWf7OA3Wv/RzcNX1hhw3ylXROLX+OV7WJlrH6+Uo1utfJYZXLb7L7PE5cNk8j4Wdt21B7TANOeD1d/e4JfNH/D07z/+Zm/VvH59dc3Dz/Md7K9y//P0fpr989bWS96c//XlKf/swvsn4Zno/mX/umXJRvP76b1P6BkD958aW4OarwnXUNF3+bfqVTCDiqvFXxgD77D09VhQ9flIecxFq3n/tyXXjzPoYyJqzV9qe3nft7383wvrZbF2Ob5ZhsUz2lLg0mREO6dhSzOy45Fc5VmNuPwudGZ8eFjYeFMDLd/+bv3vhuMI2O79JjvN5kBByouHnlqPnYctc+byi3pwo6crz6X0dY+bzcdIbX8FzV+c6MtqaLTg7P8XmamT4716IsZLbZh7br3TnzV48T5qu+Odj8krgeHPKeIg7Bfaz0pftK7j3Gj6FhdftNiYpU/DB+tvmEV4y7vo2dTkf2eewSfEzPIrmybio982/bF+1v+Gvj9vb+Um/98c+vkUyNGf7eOhxPn4iN0hfFnHJzhVcKHG3cWP9kQ98zr/2YmKOF7xZZ8VErB3ihlhjxs/KHXOcZXrbLAbLPnf9V+vFyMrnCpfkexm39H50ToyNbRAxLGMpRzYO8xohTPx4hVG4xoxfwqY0l+xqeUxiX2Oq5ngeyDlsD/nBcv26mDvPcvyr4FOJX81HLn+QrZlnhmP++3FtbLVN5GZrx7bNQZYt5S7iD9kW4cz8qGtJxYpiH8ex8WJbXywm9rNrDs5u3d5L4f6Lf/uP6Y9//PP0f99+O/38F/9e/+Qxa8xWn0tBrIvxUripQoyKwMvL9K1ZUeSXglTPP5/8dwRKESnnluL6/XvzRdzAprg5KHbWQpUL9mlSxWIgLxfSYt4iey3xstzLKUEi9VEDYJuPHqY8bjm+uzUHCzHjZkpgpBqsenzb5qAszsIB+Z2DYaztl9JLDOwX1V0SyrEriV0mp1wgteTNm4VKNpyEbfKNNqPg2JMXcpMVTYTkk0ySIxlyzln5gpbz54vp1YuX0yt1VZULweYrF4cq6S7QTRjJDVxusvJ423BcbiqYKpyz7vEXuyPdLFtvAl63Pp/4lzCReJxPdCVUF9I07+X0/HVwXDWXBWPLkxQzi2vgf9Kj8DCxZj/ptWyYr9+0ppT58Pbl9Dx9qVvYkX14K2OTuKM/U6Gn+UnzNEaEx5vplZJXfFdcbBuwtr0dj+yiY6mwMvZVPLyueL1zjDUWPVvYfxmDZIv83LtSTpgkjmis6hp7/SaMx/MXb/QPGZQ1oHRWvxtuXR+CsYSntSvgpJwr+SnfyzHpveW1PZ8/+3hV+4vsWuCqnJX8LTwvP5rQ9YW5v5h/xSajT64Jiqn8kYk0x+Do4lXkirWXeVU/z52fizHNf5X4JH0tOKpczo/svHipx/JFCTlfjNUyYnu2K6gpljIvLWouR/wz/Ki8qjz0+4Ads50vMS5StmsObtycnyQFRO/TY0M//PDD7N/ujxdRoWgL+2yTK/pLERh8edQVq3lucMXYXtmOivYSVFsg2s/Jxqy3FqkNd23PwEcm0FJ7eTy/9uy3frKtsjFiGfV1Bl+Bu/av+b3kzsEyzAq2kb3Ft/ZrRftvDkI/EtaXl/mOlWzEMi+cnXFC6BcQBcNREnKbQLwxjnWUjUElZdIt58n3UX5oxyI/iw6z6dEcGt+Sf9loxK8VzeoeYJTnqoIuso/89RtviUHBORcLdUMt59JaCTfBdN765nV3ddY1mOQU/IRuKkh0Y8Ax0Hj5uTzOFlEk0xQayg7hc3ic/FMbrcBHFQ55vsUnlq/94aZP29nFY1GhKPRuxCWeVzC2a6inu3c8wHRRTLI8jUeKcRcT5pO1lws0t04DDmWdfBU6fm1rmnFqr12/htjI9RPYVPAj2b0mjmyYxabe9QouDGSOCPk9zvSOB3Fu8fJxrOuVY+ri1nClsQabOTvmznfsbXYVfY430YWikiMiH5wdg7GVq417qaBuDV0Qt8APvz/wHtrkkkwTF2erjAHh0eN/5l7kv7DvYM3BRzdu7XznIP060ZLmII1rpJGALXyfi1u+cu3n6EJyrghscuKCLcknGbUZyfqDJiIFzhTYvjmgol8WihUL6ddIRyHIYnsFobKurmzjZ7kKX/22cvLn5fhu3xwsxKzYG2LLj/fUpmzO7k58GQMZKz5meVKaq4RfxEmLa7wZzhdH40QSJKFgc+1vhGV9BXO4sOWrhbMyCk6xn2azqpiSfl38eZ/mdOfzvWTrfJMFhswv87GgjYQ2DcaF17f2QeIqNxWve2i7wMnKj3GWerl4GWBvscmf9VV69m/Zaw9DOu6aBi5SRdMT6bG+2s9pTnSMZHnMIx18LMtZzKUIb8mpGHsbS9Ydvi6JSR4jeUY29DGJ7apNaOD/RjYL3oY+jeJlOalkmVhG2JRj/Ts87acnffFWcFH+F+7KwjfAO8Knj7/kCL/vxYTPi5gq+/R5xlvbU3zozps7H+tgXZU30Tp2WJEuj33SYTEYjfU2bVZQF13qLquXST7yWM6p7YKQ3Qfk+JGP8bmmfzNf2rwWk/jYKncODtUc9IticlaftwWvAMQUeLmAE98BcG+5sDTzNNj6ir9rDvgKthPOB6go1T4Im0UiXGyvmJNt7dpvsMq2zhTJQUFc8TB6tm4OFmJGjVnPXtsM2M8C42x3T04ZZ3xjn7WPiQtFThpf7xREzQ4lF5cQ8tUHkXBsLPm2dJR0y9i8CcjzORl7mXkcXw2T47OcsjmI41GRNJaRsOv42T1OeOtNNJYx0u0wkDg6PMhXl9TdJiY4I+XxBia/z5HO5/nySn7kh9cd4Zz5Vq5M9a6EdeclW9RVLbLDF+Zss+YKxaJcNesWEz1svH+0dui44z9jKXgnxyvfRXGm+SI4FNrbsyn2YTMukYw8J9QdNS2b2ZPwmI1Jh7t9jkTcTL70uTLykWIW49k7F8Uwj3XrVchVvC7H7TpJccjHfLPEFzwSr9z6rzhH8wouJcYhR5zdPYyFPyqvLONFN6YWh5TrJSfVeb3mM+5z55Wt1oeBr46bYz81z8ZjLbcWF9TV1wCHrp9mbRQZEY+YZz7fcW6e17vYl669Nkb02TUH+/jOwUk0B9wAjADtFIZERF34xc3BTOF5Vr77UIvJOIi5EF1ir/Wla/9Vbg7mMbsKzYH8sne2h2MoG638vt2xGm54OcGME0W4EYmYu/Nuk9L8aoWG1qs360Gyr5toKiC1DPuYSkveC+TVjWzB2NzkNN0OA4GPtynacEzil/M777NO5b+REcbW63abfd24dJGS9VWMSsEoPjes7QZk7JL+jLiSz8V3SZQuKa/c6vcbJvntN0trG42zvNLc5GJZ4+NwrHZ5zPv2l6vKrlkpa6iHV+94ssEWEXmstn1kjzrXi0lHZh8Twn0+Hi13WP4puyrWbfzceRvTOj5cN0Xu6Jy0IeFh10ZnXVW9g8Yojynz6XtTLfe0+YbjS22tdi/jqYtpx69+vHiN9b7zMnc+inGPT3wBQvJ97Ge2u66/8diGPdm0qKDmNWT5UeMQ+UfHNPYj2/rn+nHRehf5ssBmi5FrDvbxa0UHbQ7Es+zWOV00m4JXgmWKZH3VVwdC6cjzOsWqLAK5yJe2lqvg8aMvTadrKqTd5f1ie+1c43fzzWC1yFYzR+oyerr2zumZO886h+PIzlW/c5DtaM1hjmFt3kh/irs+nmJuC6DGA1c4sK/idZxMgqSck1+0eQm97ll4U8R0io3GpSSLEmArMAZ+jjBwd0cCnwQeZIPWPcTI4REkbjdGYtV5H2z+suDRmxzL8Lr1hhM9o0tzrY9Sl46L3ZAHcZn1ezDXxSTZ6f2L4tXs1fJ7Ptnj9nOSl4+FG37PJo6JfrU4N1sZ17m1peWl+Y0LS7jt5ysborXUWa99THp26HhIvQ6XrLPcYeI7kua15QbvUxRD0kfxCud2/JR2pvfJVj2fZLqGQXG47zvLJ5ut7OabxLvFvJ1nOfHrwG9hp9TBvkZ+uXgJGWleH3+yd+689qHHJ14zvjnQ8WGMrJzR2i0xFZxLBbW622jzATdStflgvcteNfYDvgR7A+Fl/evrPVhzsI//5+BQzQH/+ox9ZjuD6wrE5cUrXfXVv+CjCV4ClYte80tFZWHZAtgX+aVI5SvKZkFWfcWP0EeeU+yYazSqTDXPXLnO5yxWS2y1cwSZTXPgsaCxdHyE+xI7kqwyrhbk1pZpas1B/8vLOYb8OBBjZl+NbxLjNP/y3Tf5p01lbLgpSOflcWoAegVFSTA2iUl7SkLzV2M58RrZswVfwi1ObLyhPDW/KiP9b++NjG5CFPrEoyFVjvNvSQI1urs+l3HqCr/fcDbfyDvY14bp2fQ8fHTB61624ZSNUPCENu/o8QiDDRenYi5jn/1W2Ig1VTjInHgsOdl97/0jXXTcFwTa1lgXx7AVGFHhonGUfvRskmPE+424JOZ1MWGuvJyeDNfIQllRPDtFcx8TwnQuHsyT9BrHZrnNUlZ6H8WQx8S6NFd4rHvNGDeuzOmS82O9zcd8PhWjwVrKcmp8N+ScXGtRjhTc0jHtYUL6u3YmeV2eF3/nzgubeD/xfGI9Mh4D25zOzXCcK6jn4iu54N8Xu0Vj0eNwV0/lR+OU10Pn5nzpzZs77u4c7ON/SD5cc8A/OWoLdLpqKwtALhjDIjso8OLCMBWdopguRXn6loAs8qIiNyyIS+Gv7aSfM5V2RvLyoyqi+J23txTM8u5F4DcRhsZKG+hRHV1UE6aMRzCHk4LTE8QnxLKMkw3UQsy4wfM+0E+3KsyDBowxn2RzUGz0MnX8edFlGfkXihijstCTnHxc33XqJgrGMScMe4s3Jf2WUHlTUg1CmecSskuwaWM3DUSZq+TVDSN4XCgXB2MZYz/LJuY21mijoLHSr3n7WX7DLMUr2fQ8/WSeKoDNhtPDIsfH20I88BsF84NjFW/MRjcXSaLYoA1HYs2+6aKExvlYkX45v90VkphG89MxzQmyV85jP+NX75/Ey8spvvGGm7mrG56KpyiayHYd63xM4Njs69nU26AZby0/5hLJIHsM5ry+82vB0fx0aLOxZwsV0bMx6XC4j0mP1yYewocchxDfvu0j/6IY1vFBbovGp2MKmxCHvk9VX/WT4uTXrjxe3jNn69yEQ8HV/qSnGjPCS+pp42T+szElXCT3ir8y1yZcjL0qnnPnZ+0vfotfmKvY5jUt11LxMdknbSqxU8e6dyIbNlXP7H8cRnp9DvKyHn/+bHqifGZMpR9pXsCFYP+tNjosvG4ee7Dm4OLBo+nG2W7/18Hhfsq0AMYFI3+X1xTrBOImxSvJbQUiC9bFXHuuvBSxPEwWlIU4JMsUifmcnWsL8I6PsmBWOqoRkyps+Wr6ts1B1sENBuuQeGyIr41Z8qcca41W0Bzsgln2vfggGqvMD9GcZO/S+XxM+Bg1B/WRMcIkahxUIyLtVzGk5KE2sBJXTgL0ysmHb9PLZF+4Ugqndts0GJNkh8lJJOSUlFWxXORnu4odMmlXe0cy5vxsmwdtZuyn2SCEDTqJj3Q3+1shSfIz7g4PbavdbHVcSLaV2/tCY54bFihso9adxkf6rb7kh9rM5TzeVHNck992Ayu6LX9SjB02loe6UI+w0ce8f3SejuuYJrs83yw/0hw61vyyn3s4St3za5BjRK9RDDxeNJbs6azHsn7Yr03tqBjV+MYxYfmJm4xzPhYW9G096vj5ePB5yz8+vu0r2dti6uUQZ2q+C/0o66JiE8nznK4yyzzGi2yIxtvYStuMzrLOtEzNLe+rPh9yT/LIYBGNt/GS/Mj+mxw/d35sc49PvB9JjFqOsHZ7zNrYsX7Cb1xQy5iJ/adyp60rh0UaY/Bq9li+SF+DuJrYNTl67NgXPbYnIzru7hw8ePiT6fz23d1+YvTsfHr69NmU7iD0/tL5yKBrdSwXi1HBv31ArpX/tRiEv7vGbX4DvGIYDwvbvq3zfg42j7X55gpg6QdtGH5TkmM2ez+PxWbyduUg5u8R7yGX9qhn7TUB+de/TkEMXQzXKqiPkUPX8iVsDu5ffOLAPIbTV14nmgPwZC+Jd/+F59prx15tWqZviZ9XsznYfyG/BAsUkct4dQVxQnOAvWEve8MV5PYJ+LVWQX2MfLWWL2FzkO4e3LlzH4t7bhGgOQBH5jhyiue3vGuwLHFezeZgme3LN/L9NxvLde/bFyuPfItvx8tHWey8q/TZPsZgHy+ZfeRn382BeyTM4LvwEYSrhDFsidYsXTSwfGuf+4+iHB3Pa8TRtQrqY8RgLV+6zcH9i0fTzVt3UPyNijs0B+DHiB8ndq4Vffa52miT2/bYKTcH5Fve6FHMnXbu2HdzcGK55BhFFHRum5NPb95aBfUxOLaWL93mIN09SI8Xnd3c7cvJxwALOk9vMSOmiCk4AA6AA+AAOAAO7MqBtQrqXe3aZv5avgybg9wg3P/4tK/w4IoM4gsOgAPgADgADoAD4MAHwYG1Cuptivtd56zly2xzQHcQPsYdBCSNDyJp7LpQMR9XtcABcAAcAAfAgavLgVRQn9LfGlxb1BykBuHiwSfTrfPdf+J0DScg8+ouQsQGsQEHwAFwABwAB8ABcOD6cGBxc0ANwqPpx3cvprObx3TwVr6C/dHZrQl/wAAcAAfAAXAAHAAHwAFwABzYHwc2ag5Sg8B3Ec7v3MNjJnjUCBwAB8ABcAAcAAfAAXAAHDghDmzVHHCTkF7v3ns4nd++l3/2NP+y0VHvKhzzjgZ045YhOAAOgAPgADgADoAD4MD15sDOzYFsFPCe7qwAB+AADoAD4AA4AA6AA+AAOHAdOYDmoDwqdR2DB5uRdMABcAAcAAfAAXAAHAAH9skBNAdoDvL3SPZJKshCkgIHwAFwABwAB8ABcOB6cgDNAZoDNAfgADgADoAD4AA4AA6AA+BA5sA/AVp8W1gTv8+oAAAAAElFTkSuQmCC)\n",
        "\n",
        "課綱頁面網址請至[課程查詢](https://onepiece.nchu.edu.tw/cofsys/plsql/crseqry_all)找到想選的課程後，點擊該課程的選課號碼後進入的便是課綱頁面。\n",
        "\n",
        "![image.png](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAW0AAAA2CAYAAAAMP8iiAAAOZElEQVR4Ae2drXcbyRLF9V8EPrjwwUDDhYYPBi5cuH+CoGFgoGFgYKCgYeBCQUHDfueW+rZvl7qlUSw58sn1OT7T0x/VVb/6mNFIslfFPyZgAiZgAu+GwOrdaGpFTcAETMAEiou2g8AETMAE3hEBF+135CyragImYAIu2o4BEzABE3hHBFy035GzrKoJmIAJuGg7BkzABEzgHRGQov1cNg935Y8Pn8rX3cCC56fy+dNd+fPhaTDoLhMwARMwgbcgsC/az7uy2+3K9utfZbValU+P/8b57llV2JWvn1Zl9eGf8r3r1zlum4AJmIAJXJNAFO3NehXFGgW7+11vSqkF/aWofyh/f9vui/oOxd4V/JoOsmwTMAETUALdnTYKc/f7XMq0oLPA3z+WrUp02wRMwARM4GoE9kV7tylfHh7KQ/f7pWx2pex+fC/fv9ffz5/2j08+S9/Ttvhe+2r+sWATMAET6Ajsi/b2sdzzzrkd78tjvoXerKNo46nJOT/bb3+X+7v7eKxyzjrPNQETMAET6Ansi3bfNz/7yaLdHrH89a2MPpgy39AjJmACJmACSuBN7rTL7kf5+uWxPLliK3u3TcAETOBsAiefaZenz+Xu7m7/+/E/8XjkPx/r+d2dH3mcjdwLTMAETODnCeyL9vO2PPHNxnZ8Klu8w+ii/fN0vdIETMAELkzgbR6PXFhpizMBEzCB35VAV7T/+bb/nPaPL/dltbrcp0d+V7i22wRMwAQuTaAr2vwo3/bx8kX72d+cvLTvLM8ETOA3JNAV7T//2n/B5p///feid9o/Pn+MNzA/+o9N/YYhZpNNwAQuSaAr2u1TIX982BftzehLN+nvk6zW5dR3bVy0L+kyyzIBE/idCXRFm49Hdpsv5eHhS9n8O/p6e/66+7fy7wKCfjyyAJKnmIAJmMAJAvuifWKSh03ABEzABG6DgIv2bfjBWpiACZjAIgIu2osweZIJmIAJ3AYBF+3b8IO1MAETMIFFBFy0F2HyJBMwARO4DQIu2rfhB2thAiZgAosIuGgvwuRJJmACJnAbBFy0b8MP1sIETMAEFhFw0V6EyZNMwARugsBmXcrqvnT/TXy9KmW1KuX+scTAfT3ntwVvQvHLKXHlor0thQABtf0K9HDCemzR4315+UeVG1m/KgUOwfhI5ljapBc6Zn1E102yIQJDRG0f+yCKc1nf9GNQcW2yB/P07wGc4qJy0X7cTFhXXQ7+4Sf1mB0H+uU9D84nfuQWmRX7R8fw7UAeEvRUMuY5TOoDfRPzpke1Hb4OP0z8qf5qa6Vxjr1wPvQLmSnmst5dDC7104AlVP2VrODjoS/JAsek93Zb835dyrFca8wkt3McZP9hfJYnXa1hPEC3ia+GdklsvKJ5ftHWID6pWC2I63Upj+v9lXB9PyiSyTE0iHsFSDiwOoCB1pwuY1yrRzoXTgqZ4khAh06UjfFICgZOdQrXdgmDTeo4WWiiRrva1uRSMdWZe3GMejI4csGXfVuQVT14TkYiMppHWeTJC88P9qr2tMQRO6Z9KQaUY1NjwKmNSSP7WPVDOxiJX2NpPad+5Biykm5dgZV9c3NoQ55Uz7kPYpoX4FxUMPUgjkTecL8UnzI9mm/OahIbXV7VOeRAX5B79hFtisKafcVBvUAxjia6UL5eMCBbdaS/mP/qK4032f5SzfOKNpSBIUx8FqqpNggYBOFjLdrrUlDAj93ZKijIbUGaAGPvcBILghbipBD1ZeFlgdZpTOZwBmXiziclszqu2x9r7kvZyJ137Puaon0kAA8SNOnZAq/6jLYuYcG5S49LgrRjdcRXOTHDjjq/kyE+aj5JMYK1iBPVj34eJVvYWzmyULTkVBhMeu0btA98NJgTXdyzvlpaP+5fNSFvGKvUo+XDQFbMSWzV392SG2AFf2oNgW+6uOV5skntnMUE5dCPsL3FwcR/bbwDtT8Z7oP8nOSd2jUQ95qu84o2d2IgnFQMBqFoS7GOgBQnMBgpm0fu0ZIWoGUd5mWnc20+UtaoaKszkPwHSVGdolfSLF/PuReDRo+tuGDBIGnyBULXoq0BCL07eUz87V6bWQBSvxELtYNt5dPpIxeU2V6dDL2gVdtPxg8F4DhJtAMOuqa2oV+nu5wf+DVxjPiU+SrnYG3aW4tLGupOaUP4RgoB4wF+xxzwOohPkRT7iV8wNOqTJQfNt2A1iqkuFia+hrKMX+YC2R0YkvyI8RanE/lt/EDYnr/mW+M6qA/H5AxEn9v1BkV7FPBSfJvxE9UBALDoLCYN+mKtyKcjD0TBSXXPlhg6qTqRycE9cEQfdGh9onvWCYEXfYO9oKs6XbdvbQ20rLPsO7q6M8GbnqqzJnKWq2NNkZfGKCmyz44FabBTHmKHjr3smHjL3fKIX9Zv5CvVD+2Ik5xsNQY6fqKr6nfQrrK6tcp/1BbuqrPqNpM34gCdRsWwk5Hs0X2ZH1dnJTdb0Bc5o8dO38pN7VWdR/ma1wfP6rBmW/U1Lroq79jaIVv4cOL77iJ0EDCv6rhy0RbdZkUrFwBZ0gq13tF087XI6cIz2+EQSSIsbw7m1T0F/GyLpUV7FAT3KOwoKnhZLImeAyAYYBw6MwATC9V/puuSfuipSYM1nQ8SqyaTRVC4KhvOoy3qY461I2UJE/DBmpF+bV1tKAu0tTAe7Fv3yjY3mZKk2S9tjuwLPU/Nw/RgQ1Z1D+oGG1l8wGumG2zDK9v8iBHyI94oPysq52/BKnRJvgSj5kvG9My/p8YDaM2l+soTXbBN84p8xfxps+k2nfEyoAxfevsWdZn5sp/dnV25aEuAK6y4qk8SkcEJNWEYjYqgTtA7mXznvbNvwUnVg/uOAqrbRwI/64TAy326lrZQq1z8eNUOXaDX5EIBHfHewM0W7co0CsgJnzU+YisDmmNR9KrMSDRp52Tq1laZXV/SJyeu+h/7jtaGPnTi7Fh1jAuwxMxwOi+4fIYt54gZ6BRvyq2PPB7hmvpcnPEc+9WxrHdn2xuyivhNd9jQTdnT9zgO86bqO1vD9coB9gYDiZ+RP9o8GcQ+1GO2J/mO1ouoqBGci0fHcl3RabP2lYu2bHtwhwBwkqhdwcK6Cjbgy7yu0DFQz7Ra1OoesdApGFfwUYhFB11/rB3rjiQs9tA9OwbVNgYfjlpgGgcG4GC+rtXgPaZzHtNg5Vjbu3YoK87BMYL7iP2dvbpw1NZ4qIUXPEb6jZazD7rOWOgFl692lPnMTsrWY9NrQYzG3PoqCz5rn5rAG5ILi7bGaPhH4pV2qS2q66x9LVawl0U6HyMfGNMD/9JOFDuwYvGb2aD9zX9VPn2sedK1JXabPwc6YY8mO7V1f21jPvbq8l8nzNvXLdoMlg5EVTaASWDNEpgBGB/LS3dJWe5PAGhoAJGPJ7LcfM6kz/YhgOiMvIbnXEt72R8XsAUJToVb4ZQA51h3PENmt66eIFibjspfAloDVmVM16qcQRHNDCMx1U5pazJh724t3/xM+3X20I7KqX1yY3AjMLNTbY626IfziBPukyfXfaET4hd+ZRwiR9AHG0/daY84RD7QrkHF/lWsRnHB4h06C7/OLuknxpGsoX+1mIqckW9GflY9ZnvyAjJaT30vcLxu0T6qIMAtKNoAEI6swgIYE4ABz/OjGx4ZrE7MBZVOYHHmOSVFf7UBeul4FFUWC7WTi+XY5EgwwW7oMwuATj7uwitPXNzi0QmOTPZBYZTtX92c6dj5arRL9V/jXueovNYWNnwVhjrUxvPayqPVXsZK9Yn6iqqBGy+moVNa0xWDFJeUwfVZPlhoHLf5owa5LC3ayobyal/oPMmPxu4Xsco5E/HCnJHjYm6wneya4wlEYkV4bfkxS7moNS4vS7tXdCNf6hpti4hLNS9ctCsMhRwG1DdP0G532JNA0QRmsYQ8tqPQ46NPgoBjulaGTzYZLFjPNvZEIdSfGJMC3IptfcnERGV/fGYbXyw6kbAxn59/r/KDlRRtyKB86JTvtIOrPPMk63bXNghite017fBxYgV5ZJmLXT7PflN5rV1jS9diyzZeDWjnKb7Yj2OwSo+bmv1Lkr5NTo26VuNfZ1AH7UM7fFu/nt1daNMb0ngPI+7E8XVt+YHcvCdzgrwG7nlh95asBn4MHTVP6hzo3OXObK0UeNrbjpKv4NT6xf9kRUYjP6ke2qYbdI22OX7B43lFOxvdABBMhdoCiPBxlICDHCZOk1GBtgSWBOC+hHpBAO1i0PSZ3JWM9qSzaUMU1Woz7GAxxlrY0LgkYUxEzqFc2Is+yMWxsUnrccpAwlrsg/OYTx8M1lyqizpeUh6Z4qgXq7xH5oLztrbGJVjwExWcr4w7mT9btCvnmY+5R+iXYix04h2fPB4ZxTtjhfLi4s38Q2fVAwwYL2H/gOMvY1WVh17qW5wHP4nZ1keDZS1sPGC0xH8in2L1Bg1cVC/MUT3QbjEm8cY1o/Xc5wLH84r2uRtGQCFAAYnPFxmwta/dACbYkVSTYBwBQ9+phBnpr87AeOgsjhjtxWRQHSEHTosErEbFOO2tBZhrsZc6H88scZfFz1szAHTOQYCKQbovu9H3s1woY3akbPLpdKtJwbFFx8SJ9mMftqkLC27I1RiRi9ww5pIPsn9CvsThyVigzrKGOh47trzAJBaQKiM4apuChGnjkebRJ50vuL7arjnS2NZc5CtDLsE44/VirCi8xn+zJRVGTCN/nSPL26MQjHcxMSrm3cLxCfkhrjLDXCeGEqo/sJ7chvNe13ndov063bzaBEzABEwgEXDRTkB8agImYAK3TMBF+5a9Y91MwARMIBFw0U5AfGoCJmACt0zARfuWvWPdTMAETCARcNFOQHxqAiZgArdMwEX7lr1j3UzABEwgEXDRTkB8agImYAK3TMBF+5a9Y91MwARMIBH4P9IMegDDipo4AAAAAElFTkSuQmCC)\n",
        "\n",
        "![image.png](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFgAAAEeCAYAAAAO49LxAAAWsElEQVR4Ae2boY8jO/LH+78IOWnIT1o4ZKWBgdGiwNGiwLANjLTSsJUahu3oLQlsPRSwIMsCG+aRp8CwF7I/5cgpJ51OdSrbZZfd7qQnk8rMzquVRu502+Xyx1+Xy51sAfpPlEAhal2NgwIWFoECVsDCBITNq4IVsDABYfNBwds1rPe8twPs9/v474DPM/f35gFvbK4P2zUsFjVEZhu1LnNjv1lBvXumrcMW6moFmyNmDvsNLOfLo3V4cwv4sILpuwKK3j3MNw7WroJhUUDB/8oaIHd/WEFzbAeoy1soiluYrUOXu2oY2+T26TprL9iIrvZrqCZ96GHbmzEsO88mCmUHm3oJ1eMERnc33q874zA9X8GyeoTpeAj9dz1fZ1htIzfaPngFHzZzGN0g5AHM1gcPclghuh1UwwIKBji6nwDZLmcwm81gNh4Yh3qDifk8r/dgAd/C/dTWGQ9wEgcwxvqzKdzfFlAk9nLO7zdLeBwP4MZMyg0MJhWQNnL103uNib65g+F4BtVqY1dcXXqYJLLeuz6MJnNYrLeQX7NpL5DkwdsK7vsl1Ng6p1QGmDo1ZQKkLhPlO2XipNiBDWG+seFnOcW6U1iacLSBOU5kYs+6fYBtvYD5ZAR3KAQPdg71bg+b6hGqTWf5Oj/6MKt3kI1wDvDocQXr7T5fp8mzcccoGOPXasX+0FEHuD9dhGdt99e7zjPaUI6Df2zCyOutCS89eDcYw6yqYYdCOGygGt+5lfIIuPi6/KOJNgs018ABRk09558B3FAcU6oJBYc9bNdLqKoa9g78cL6JNsBoXLslTPp96Ed/j4Ch2A6sD9OFndDHEapxBI9mghcw7bcpGId5gAPraLeawdCo+QaGs7CZbhcTGIzmcEzQ7RM9BAP9koBJwcuZ3YDuHjewX4waMejmvoItrGF2R0s0lNFMnwR8ToggHR1gV89h0scNpwf90SOsaIfdb9iGNwobNjVlpQXcg3dMBDb0xIAxRESrm1Z6x1XrNzmALcxxw+lNYIUq2VQwmT5CtVxBvd7ClgcqVPR2C9tdSOOYsNgwmpftygmTlY/BALvFmMVfzBruoN+/cxsdtUc1rzJZTeyL9cPBdI/sSo4BR6GLh7PsPhH3gZ88YIpvY5/nUL5LGw8uOQd0MzcpXAgTCd4jCj7s1pEi4hDh1NKijkNdQn84hqnJODDrKGHEVtPNcAYrE5hx0ythtmrf9LoCni5JRCkHPmaXZRUF2OyKQO8c4O0cBjg7g0dYI0Rsm0lTWmezKCHaC1oB06SR03uIs4hwf89XDPnrywPsVo8wMmGigJvBBOb8lLFfwdSAv4OyzkMmwJTN4KHK+mIVfFhNTIgMoc9BzCk3YsVZ1BZwY9neLwDzAnuSS2duD/tTCvYgkotc6seXHb/ODATVv3gcw8Clae8GU6jqLez2W1ib2IiHBlT2BO79oQAhc7VZnxpj9n1bwPS8E2A6J6QK3lUWcFi2jzDCjqYLqOf2IOCT/9v7sDSn93BbFHB7P7UHitkM8BDh/7Up+LBzIDAUVE5lFDvvYFqxDSUNE0+ZnN47m8GM7mHQsyfUBW2Ezkkbb8OBxxyMTOiZAw5lO+9DUfRh7g9sRxTsB55cEGB/ezuHflFAf76C5SRNs45/nizZCBwMPPlgqvYOB5mEkUM9hduiBz3zzJa9yepIPr2DlVHnDOYuxbO7u0vtzGHFKfVw8HZwqb8bYujzozQX0YYWPwKAPSzH6DM/ep8BGCgGuw42jzhr8buDw66GqhzBsFyxlzZbWIyHMJ5VUJtNJfGQcmV+zOaADzWUGCMHc5ibk1wJlTtE3Hc44+9WJQxu3JHeL08X+1z87fUxt2aTHrlIAF3GFD3DdHsFU5z4/hy8gKmfTOhKm/PPPotAoxOjJnQc10jF4hie9edBBdulec9g3wMU0OuPYRE88afA6H2FB7yF6h5z2DvzEsgqCeGE+7mYiU7vsd+heylzQ3ku7eC0uewB34XYA0gBNrPgQ8brNczwncftzBx+0qeoenx5dMvfUh0FTD6kWYRP0/DNFx43e3Bz4xL4ydy8RXpcrO2RNPXCfN7DZjmD8az2S9LczsZLBLD3/ZBSA2BUjlM2f6uHYDcLKAlskea5NDgCTI7uYDUb2hy514cJV4ALhUU2JLnzQLKS/QuvnIJbswgHGPPLu6KAnsketrCY0FsqjEPxaSc+/rK4PGXxsyUGr9Yz089dGSYkAoxscOX0CuiNlyEk7RZw37uBYbkIq2i3gLE7heViPGE+bCoY393AiAFez/A1agGjRRKY8Si/GNlXn6NF6N+qxr5RzAEmdadZBB009pjAp+9SD1tYL+b2PSg7TrYBHvNtOorBe5eRLAFf8q2X4Z0B+t0AbCBvOrx6JKUVcHM3hMmSxyjC21JinMaw1uRrXh7N7/vRO2xr5ZxNzoeIFkf09rMJhE3u2abUQI6AAs5RueA9BXxBmDlTCjhH5YL3FPAFYeZMKeAclQveiwD/9ftPeC1/NMbX4k/qR1f/FPCZolLAZ4JLldr2WQEr4OPxvqtC2hQmfb+rfxqDz1S6Aj4TXFflK2AFrDH4RQ8dXZdg1yV96Xpd/dNN7sxQooDPBNdV6QpYAesm9zo3uS8PUHz84X37/pF+24blB/j625/w9T2/9wDfEzX/8ekDFAW7/9s3++tS/wNA3r6Az1+aYnizIeL7pw8WhoOMgAef/oS/DKQA2EAx9xhIAu2AenC+7U9mB6H+gM/F3wyw3YRw4AjzJzxNwam6UakP8F0BuyXqlEc/BEcFegWTOn+3EL06/f3mMvcZQ2KX7FOZs/VmQ4SBgnGYKXjw6YePuwSd4GBpQogDbeNviLFxeNEQAX85hRbvv8EfdO1ge0V2US2voyGCLW+3nONla8OCV2q2jrXRruCgaq5+vI77snbebIiwmxplBrlNqwkqB6hV7VzNXOXJ9RsFbNMmUphXrAsV/vMTFRxnIs0JinJmB/qNAqZQ4fLTT8cPCDQR/GBiQgSL335SEJybGGp3TPlvGrCNozYPtkvdAvewCJQBSZPCYnAWsIvjHx9ggJvmpwewG2ncnkLLxQGbQbEjKnXUVuKyCwqIl7ZxnCDQ8TSx3T4AshVObUZxH3/AH19+wB88Vpp0jvvxE9oU7O8bv5jtxC8ab7t/8YR0fB+MeSae34voPcBfZgC04XDDob6FjFCs4uKB2La5yWsbgI2XH+DzR+dPRqUEIVeavmhSKUdmeXU4cuN4kpXBJq/Nv7TPjoAdPKcIimk0WDyypobNZ6xvAJDq3AaC985SsLUTVkZ6VM5tUEW01P0E+43RHlK8Ta9gNybzuSmiCwJ2qZBbKujg4P03+O5g+7jHZjdWCToXFOwnosVxet51AFT/2mVX/44omJaHO4ZGschBP7E8jcK9gj/A1y+06xN0rji+af0k//Mrg03mtcFSf+QgfW4r2wG7Jfz5S6xgNEQK9csqN2DX3ijcXR/blVMHuw4gbXetz139awVsIaLSEsBRHLbP2sNEErsM6KDU0EczhncdwLWApv109a8VcFjeDDDBZaEhD8ltahRWSMFs96ZkPpTxZHQdQDrwa33u6l8eMF/epGCCw+CawUR1k2zDtAmKjVMgCjUxWALUdQBU/9plV/+ygK0qCYxTMMIiRSYx16ZrGVBG8Q/w1XwHxje0/DWP6V0HcG2w1F9X/7KAyUh0Nm/AZfHXhQ4OKH5vy5VNE0cKjl+IU99dB0D1r1129S8PmMfM9w/wGb+lbQCmNO5Pf+KJAPN4zexhVvL9C7YJG1tuBbQNwK4uvgKSleNWTfpNsu2PrUYKeeY051JRdi/sDfFBhfxu84+eU5kFHIcId1pqib0RVA/NbXI0OXQk9c8DXHIkLdsGYHwjX3IwaWI9rLBifB9uwoPvbDX6NDSZuMT3Nv98H65+FnBaKQoV3vH8zJq2jYE74Lxt5pqne20D6Ab4OJzmO5S8sknFYSKCMNr8S9l1A5zMXmpE4nPbAPIh4sQEJuEtpKAE7KUV/IoA5yfTAjZKi5a/vc9XRv4NmSo42hSbkB3g9BsOitVcINkYrQq2gFk2QvERy8Gnb+EnTpGCKQRQyZSKYcPUxU1QATMFxzCsmlmISE+eUQaD9R7gM/5gMAOYT1p83dw02/aIdHX9cpscZTTxzs4Bk1rbS7PJRYDb69pN9e8EOI2hGGdZWEB4uKlF6RyPwb+7vD4CjBPkvob6+M38DOvzR/ttDP6a82/4tb1VnIdooMex1D9L4OIStidHOg3SFwHhm+SvZpIwrrv3KJnNUjxE2KVDTsZlnBb9BJvYZ05UmcFTDOsyAFrq1hdcxjZURApuHHoyCsav6P3PWB1Uo2Sn6pcDnMamMMCwQ0sDtksaNy0L2k4kKdgs8QwgmkivaB8yHuz3jfiZ1O6ueZsuAsD6Z29yQTV8g7gGYNuH3eURJn6mkr2ZY7G6saKSlUNxmwO048OVmV95bxgwn9CXu74S4Dj2Uu5oFOOTeLkQwRV37WtxwGZALD1qDFABmxh+dgwOgPMx6hqbXGNSk9gq+fw6CmYbCYUHLDVEhL3hWQpuZhLXyCKC85IKPWX7KgqmRD84YwGH97IufPiTVnc4XQcQ+u5u+xJtuvr3DAUztVLs45uebnLP2+RseEg2OA6VoGMpqeDfvsF/iwL+i/+dlvfp+oWigP9k/q9xo27a9sRnYQVb9Ta+yjcg0+PzJQH/gP8UBcD7b/BPD+BP+Pf79B6FC1s/C9+3/wn//PQBcCKak+FsFw/wL1YfJ4f+nZqo80JEApK/neLHUn7/Kb+sbBvAvz4iBBosDd6CIUAx/J9g2kQTQvDtf3pB9cPHHx5yU+1uUpP3EbKAk9k8NYvnPG8M4MtDRmEMFvOJK9KDdwoNExS3pTZNwKTwD/Bv9kv+hn+sfz7e8xTcYowbfu51OoBYvQ6Og84hpoAMuDYFs3EcA4zfRJvQxFSc+tc23l8EcHOAbQNK718GsAs1PjxJx2A28+mALvU5UojLFFJ1YnbC1YvXaZ1LAbYKD2Ei8u8Ij19DwU+Iv2aCM+D9RLBlzsVwPETYTIhP4BsEHNTDwZy6vpSCabXQCvl7AM4olQAQeAXcEr8ihbSFCHOf8mK7EUoBftsxOJMmGYVeEXCaJkYCaBEJ+vhrbHK/N9OkADg+yT1JwS478RugP4zwEyPm3M008c0Bxm9IGi91sgp2MCJYfBIopMQnOYrZuTIND1iH/uXq83u/jILR6XSZ8oGIXecm9q0Cxv+5ZN6cFeelbE+eBAohmdz5TSr4yYCObD7PtaWABeHi5NC/UxP1S8XgU4O55nMFrAo+niZ1Vcg1Vcv76uqfhogzla6AzwTHVXrsWgErYI3BzR9yCKuCL8muS5C3ueZ1V/90kztTNAr4THBdV4ECfo2AaVa0vByBKAZfzqxaIgIKmEgIlQpYCCyZVcBEQqhUwEJgyawCJhJCpQIWAktmFTCRECoVsBBYMquAiYRQqYCFwJJZBUwkhEoFLASWzCpgIiFUKmAhsGRWARMJoVIBC4ElswqYSAiVClgILJlVwERCqFTAQmDJrAImEkKlAhYCS2YVMJEQKhWwEFgyq4CJhFCpgIXAklkFTCSESgUsBJbMKmAiIVQqYCGwZFYBEwmhUgELgSWzCphICJUKWAgsmVXAREKoVMBCYMmsAiYSQqUCFgJLZhUwkRAqFbAQWDKrgImEUKmAhcCSWQVMJIRKBSwElswqYCIhVCpgIbBkVgETCaFSAQuBJbMKmEgIlQpYCCyZVcBEQqhUwEJgyawCJhJCpQIWAktmFTCRECoVsBBYMquAiYRQqYCFwJJZBUwkhEoFLASWzCpgIiFUKmAhsGRWARMJoVIBC4ElswqYSAiVClgILJlVwERCqFTAQmDJrAImEkKlAhYCS2YVMJEQKhWwEFgyq4CJhFCpgIXAklkFTCSESgUsBJbMKmAiIVQqYCGwZFYBEwmhUgELgSWzCphICJUKWAgsmVXAREKoVMBCYMmsAiYSQqUCFgJLZhUwkRAqFbAQWDKrgImEUKmAhcCSWQVMJIRKBSwElswqYCIhVCpgIbBkVgETCaFSAQuBJbMKmEgIlQpYCCyZVcBEQqhUwEJgyawCJhJC5asA/P//+D/4Ff+6zIkCfsbkKuBnwOuyohTw1QDvoBoWMKx2jnkNZVFAgX9dZkG6The1vMY6KZe6JMg1lMMKEPerBZw6/9KfcxN8yicEroBPUXLPjwE2ICkkFCXUzKYCZjCOXR4D7NvVJRSlxburhq87BnunX8nFacC40Q2B9jkEjKxVwR0n8CTgumRZBIAquCNYqnYcMKZlcexVBRO5juUxwF6tZqOzoP29jvZFqx1zXrTjJxjv5mPIf8l0hxiMwTuWPzU+XjaXDdbHlMZttL55J+d3AMMCoMC/0jeNLkp6PgST5EcPTd+uvatHG5Kvh5sS2SgAhpV/kn0ZFZ66K4rDmE1Q2taolL2BsMIOaavkAfrm1Jm/YUfoOyYHiqKT8wiPJqYum5CrYQCyqwCKFPIOoGTAuFt0XZX5icHnp0WQF2IHBVP3iQGW81ENXtalnRCv2F0FQ3d85PUwVp1y3gBLVIvAvQJReQlQBE4Tgv3hpPADAPfBXNdx/fT5KR/tOFF0hc+F0cZJwLQb2g5rKJ3XBDB1xHxGmG5XNR2XJRQGbpwrAtYr65OAuTqpP34vp+joHg8vyURwexQe/MTRwxMK9iKi+qdDRFBrDNhZaFEj2bc7qI3bjc7BQa6Dok+pg4cH6oMD5LDpeTZMAADWRZA5iNjWtEviL94/5SP1m5YtCg67YQ4wQaMyNoptS/OHSzKtg595HMYFccr5SwJGX9vg+3E4xfNJOOWjb5tc5AG7pWudsUc+347HXn5NFeoSyjqsAAO4wpBhwfK4iE3w+Snnc4CNEl1czinYKLwlHGC/UQwn31mJ7Z+cRbD2dJkFjKqll8exgtPMIYmpZNWEgbYQgZXidqcA5wDyezxckAu5e/QMS2zPFcqf4TWqXAhwPHgOOF3u1pEwGcHJRMFs+7YhglI+G4pOATZLmmcR6RLOZBE51Qf/AMoj6sZ6OEF8Ak75yG3z66aCkw2MACMYUjU3QJlAdK+hYASehAiz01qVd3GeL+mcOlGRFH5OxVhsT3Vjv90nnDA+oZfc5Hh4wO7wM25KqUMEHrPL9EWHDQEtIQInkOWKaKcLYDyanXuSMxPCTmjpWDBBphTNlAlc5NDJx8xsNRXMKrXBxSo8XDRz4maIIFs2H7ad0Ko413nmqvjlKR/9+FA8Jue3Z4Y8YKcyDAnYsDHjWdXyMTYBh6fNcHHK+dD25a6O+mjCHe0rdoekVdoAbGaCH2lpSbs0i3LYbDz24w+A6Zbd3DAOM0fcw6POk4EXLo/5aMbWUOExBV95MMecv7Irrd0d89GGh6Zw0FhDwa09CD445rxgt08yfdxH95LHx99gWgEHFkevjgPGpmFvMWHUhYxXCzg3oNd2Lz8jsZoV8DN+v0aAd1XVeNfs0zaq9JLla1NmV3+IWXsq+4p/OtV1kC9ZjwNOT7tWweXrzSJeElzXvgNgGyJCro/5vn1V8CpiMDn6FksFLDyrClgBCxMQNq8KVsDCBITNq4IVsDABYfOqYAUsTEDYvCpYAQsTEDavClbAwgSEzauCFbAwAWHzqmAFLExA2LwqWAELExA2rwpWwMIEhM2rghWwMAFh86pgBSxMQNi8KlgBCxMQNq8KFgb8P9Ofz0CUmTOfAAAAAElFTkSuQmCC)"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "background_save": true
        },
        "cellView": "form",
        "id": "oOE9fVHy_QQk"
      },
      "source": [
        "# @title 課號加選-資料填寫&執行\n",
        "\n",
        "# @markdown <a href='#scrollTo=rf31bcNpE1MU'>課程代號(點我看說明)</a>，採直接加選系統，可以填入<b>任意課程代號</b>，請確保代號正確，多個請用空格隔開，格式如:<br>4705 3803 1750 3494\n",
        "v_class_nbr = '1800 2507 5224' #@param {type:\"string\"}\n",
        "# @markdown 載入失敗(未開放)時重試\n",
        "load_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 加選失敗時重試\n",
        "add_retry = True #@param {type:\"boolean\"}\n",
        "# @markdown 重試間隔(單位：秒)，最後一秒會隨機取0~1之間。\n",
        "delay = 2 #@param {type:\"slider\", min:0, max:5, step:1}\n",
        "\n",
        "try: rs\n",
        "except NameError:\n",
        "\tprint('執行中斷：請先執行登入區塊')\n",
        "\texit()\n",
        "\n",
        "try: v_class_nbr = v_class_nbr.split(' ')\n",
        "except: v_class_nbr = input(\"請以空格隔開輸入要加選的課程代號: \").split(' ')\n",
        "\n",
        "data = { 'p_stud_no': uid, 'v_tick': v_class_nbr }\n",
        "\n",
        "if token: lineNotify('開始直接加選...')\n",
        "else: print('開始直接加選...')\n",
        "print()\n",
        "\n",
        "## 課號加選-填寫，看開不開放，同時向伺服器拿'cookie_key'(若有)\n",
        "r=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "if r.text.rfind('本時段不開放此功能') != -1: print('本時段不開放此功能。')\n",
        "\n",
        "load_count = 1\n",
        "while (load_retry and r.text.rfind('本時段不開放此功能') != -1):\n",
        "\tr=None\n",
        "\tload_count += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第 ', load_count,' 次，本時段不開放此功能。',end='')\n",
        "\twait(delay)\n",
        "\n",
        "\tr=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\tclear_output(True)\n",
        "\n",
        "print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "cookie_key=False\n",
        "if rs.cookies.get('cookie_key'):\n",
        "\tcookie_key=True\n",
        "\tprint(rs.cookies.get('cookie_key'), end=' ')\n",
        "print('...')\n",
        "\n",
        "## 課號加選-完成\n",
        "r=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tindex = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tindex += 1\n",
        "\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\tif add_retry: add_retry = (\n",
        "\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t)\n",
        "\t\t\tprint(td.text)\n",
        "\t\telse: print(td.text, end = '-')\n",
        "\t\tif index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        "\n",
        "count = 1\n",
        "while add_retry:\n",
        "\tadd_retry = False\n",
        "\tr=None\n",
        "\tcount += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 加選失敗第 ', count,' 次。',end='')\n",
        "\twait(delay)\n",
        "\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "\tif cookie_key:\n",
        "\t\tr=rs.get(plsql+'enro_direct1_list',headers=headers,verify=False)\n",
        "\t\tprint(rs.cookies.get('cookie_key'), end=' ')\n",
        "\tprint('...')\n",
        "\n",
        "\tr=rs.post(plsql+'enro_direct3_dml',headers=headers,verify=False,data=data)\n",
        "\ttable=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "\tif table:\n",
        "\t\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\t\tindex = 0\n",
        "\t\tfor td in table.findAll('td'):\n",
        "\t\t\tindex += 1\n",
        "\t\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\t\tadd_retry = add_retry or (\n",
        "\t\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t\t)\n",
        "\t\t\t\tprint(td.text)\n",
        "\t\t\telse: print(td.text, end = '-')\n",
        "\t\t\tif index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        "print()\n",
        "\n",
        "# 加選結果訊息\n",
        "add_result = '總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+''' 次，加選結果:\n",
        "'''\n",
        "if table:\n",
        "    add_result += '-'.join([th.text for th in table.findAll('th')])+'''\n",
        "'''\n",
        "    index = 0\n",
        "    for td in table.findAll('td'):\n",
        "        index += 1\n",
        "        if index==len(v_class_nbr)*len(table.findAll('th')):\n",
        "            add_result += td.text\n",
        "            break\n",
        "        if index%len(table.findAll('th'))==0: add_result += td.text+'''\n",
        "'''\n",
        "        else: add_result += td.text+'-'\n",
        "\n",
        "## 到學生選課主畫面看目前選課狀態\n",
        "result = '''目前選課狀態...\n",
        "'''\n",
        "r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "\tresult += ('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tcount = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tcount += 1\n",
        "\t\tif count==len(table.findAll('td')): result += td.text\n",
        "\t\telif count%len(table.findAll('th'))==0: result += td.text+'''\n",
        "'''\n",
        "\t\telse: result += td.text+'-'\n",
        "if token:\n",
        "    lineNotify(result)\n",
        "    print()\n",
        "    lineNotify(add_result)\n",
        "else:\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "    print()\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "cellView": "form",
        "id": "fEELvAYk_JEZ"
      },
      "source": [
        "#@title 通識加選-資料填寫&執行\n",
        " \n",
        "#@markdown <a href='#scrollTo=rf31bcNpE1MU'>課程代號(點我看說明)</a>，採通識加選系統，限填入<b>通識課程代號</b>，請確保代號正確，多個請用空格隔開，格式如:<br>0628 2027 0004\n",
        "v_class_nbr = '2507 5224 3290' #@param {type:\"string\"}\n",
        "#@markdown 載入失敗(未開放)時重試\n",
        "load_retry = True #@param {type:\"boolean\"}\n",
        "#@markdown 加選失敗時重試\n",
        "add_retry = False #@param {type:\"boolean\"}\n",
        "#@markdown 重試間隔，規格同上\n",
        "delay = 2 #@param {type:\"slider\", min:0, max:5, step:1}\n",
        " \n",
        "try: rs\n",
        "except NameError:\n",
        "    print('執行中斷：請先執行登入區塊')\n",
        "    exit()\n",
        " \n",
        "try: v_class_nbr = v_class_nbr.split(' ')\n",
        "except: v_class_nbr = input(\"請以空格隔開輸入要加選的通識課程代號: \").split(' ')\n",
        "\n",
        "data = { 'v_click': v_class_nbr }\n",
        " \n",
        "if token: lineNotify('開始通識加選...')\n",
        "else: print('開始通識加選...')\n",
        "print()\n",
        "\n",
        "## 通識加選-選擇清單，看開不開放，順便向伺服器拿'cookie_key'\n",
        "r=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "if r.text.rfind('本時段不開放此功能') != -1: print('本時段不開放此功能。')\n",
        " \n",
        "load_count = 1\n",
        "while (load_retry and r.text.rfind('本時段不開放此功能') != -1):\n",
        "\tr=None\n",
        "\tload_count += 1\n",
        "\tprint('['+str(datetime.today()+timedelta(hours=8))+'] 載入失敗第', load_count,'次，本時段不開放加選。',end='')\n",
        "\n",
        "\twait(delay)\n",
        "\tr=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "\tclear_output(True)\n",
        "\n",
        "print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "cookie_key=False\n",
        "if rs.cookies.get('cookie_key'):\n",
        "    cookie_key=True\n",
        "    print(rs.cookies.get('cookie_key'), end=' ')\n",
        "print('...')\n",
        "\n",
        "## 通識加選-確認\n",
        "r=rs.post(plsql+'gned_add4_dml',headers=headers,verify=False,data=data)\n",
        "table=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "if table:\n",
        "\tprint('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tindex = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tindex += 1\n",
        "\t\tif index%len(table.findAll('th'))==0:\n",
        "\t\t\tif add_retry: add_retry = (\n",
        "\t\t\t\ttd.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "\t\t\t\ttd.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "\t\t\t\ttd.text.find('選課時間有誤') == -1 and\n",
        "\t\t\t\ttd.text.find('該課程已選') == -1 and\n",
        "\t\t\t\ttd.text.find('名稱相同') == -1 and\n",
        "\t\t\t\ttd.text.find('衝堂') == -1\n",
        "\t\t\t)\n",
        "\t\t\tprint(td.text)\n",
        "\t\telse: print(td.text, end = '-')\n",
        "\t\tif index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        " \n",
        "count = 1\n",
        "while (add_retry and (r.text.rfind('失敗') != -1 or r.text.rfind('選課時間有誤') != -1)):\n",
        "    r=None\n",
        "    count += 1\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] 加選失敗第', count,'次。',end='')\n",
        "    wait(delay)\n",
        " \n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] ',uid,'加選結果', end=' ')\n",
        "    if cookie_key:\n",
        "        r=rs.get(plsql+'gned_add2_list',headers=headers,verify=False)\n",
        "        print(rs.cookies.get('cookie_key'), end=' ')\n",
        "    print('...')\n",
        " \n",
        "    r=rs.post(plsql+'gned_add4_dml',headers=headers,verify=False,data=data)\n",
        "    table=bs(r.text, 'lxml').find('table', {'width': '780'})\n",
        "    if table:\n",
        "        print('-'.join([th.text for th in table.findAll('th')]))\n",
        "        index = 0\n",
        "        for td in table.findAll('td'):\n",
        "            index += 1\n",
        "            if index%len(table.findAll('th'))==0:\n",
        "                add_retry = add_retry or (\n",
        "                    td.text.find('該類課程每學期只可加選一門') == -1 and\n",
        "                    td.text.find('本學期已選修超過4門通識課程') == -1 and\n",
        "                    td.text.find('選課時間有誤') == -1 and\n",
        "                    td.text.find('該課程已選') == -1 and\n",
        "                    td.text.find('名稱相同') == -1 and\n",
        "                    td.text.find('衝堂') == -1\n",
        "                )\n",
        "                print(td.text)\n",
        "            else: print(td.text, end = '-')\n",
        "            if index==len(v_class_nbr)*len(table.findAll('th')): break\n",
        "print()\n",
        "\n",
        "# 加選結果訊息\n",
        "add_result = '總計載入 '+str(load_count)+' 次，送出加選 '+str(count)+''' 次，加選結果:\n",
        "'''\n",
        "if table:\n",
        "    add_result += '-'.join([th.text for th in table.findAll('th')])+'''\n",
        "'''\n",
        "    index = 0\n",
        "    for td in table.findAll('td'):\n",
        "        index += 1\n",
        "        if index==len(v_class_nbr)*len(table.findAll('th')):\n",
        "            add_result += td.text\n",
        "            break\n",
        "        if index%len(table.findAll('th'))==0: add_result += td.text+'''\n",
        "'''\n",
        "        else: add_result += td.text+'-'\n",
        "\n",
        "## 到學生選課主畫面看目前選課狀態\n",
        "result = '''目前選課狀態...\n",
        "'''\n",
        "r=rs.post(plsql+'enro_main',headers=headers,verify=False)\n",
        "table=bs(r.text, 'lxml').find('table', {'cellpadding': '2'})\n",
        "if table:\n",
        "\tresult += ('-'.join([th.text for th in table.findAll('th')]))\n",
        "\tcount = 0\n",
        "\tfor td in table.findAll('td'):\n",
        "\t\tcount += 1\n",
        "\t\tif count==len(table.findAll('td')): result += td.text\n",
        "\t\telif count%len(table.findAll('th'))==0: result += td.text+'''\n",
        "'''\n",
        "\t\telse: result += td.text+'-'\n",
        "if token:\n",
        "    lineNotify(result)\n",
        "    print()\n",
        "    lineNotify(add_result)\n",
        "else:\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+result)\n",
        "    print()\n",
        "    print('['+str(datetime.today()+timedelta(hours=8))+'] '+add_result)"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}