Tôi đã viết API lấy thời khóa biểu trường như thế nào?

Chủ Nhật, 08/03/2020

Tram Ho

Helu các bạn! Mình học theo tín chỉ cho nên lịch học không phải tuần nào cùng giống
nhau nên hôm nào cũng phải vào trang trường xem lịch (hơi mất chút thời gian và giao
diện không trực quan). Một cách nữa là viết lại thời khóa biểu (Mất nhiều thời gian mà có thể sai sót).
Các cách này không phù hợp với một thằng lười như mình và mình muốn dùng nhiều lần… Dựng API lấy thời khóa biểu
sau đó có thể viết chatbot nhắc lịch hay web/mobile xem lịch tùy ý nữa… Hừm .. Bắt đầu thôi.

Bước 0: Ý tưởng thực hiện

Input: tài khoản, mật khẩu sử dụng trên trang trường.
Lấy file thời khóa biểu.
Phân tích file thời khóa biểu => dữ liệu (JSON).

Bước 1: Phân tích request

Password encrypted trước khi gửi lên!!

Password truyền lên đã mã hóa md5, có một số data khác

Chọn request login > Copy as cURL (bash). Mở Postman Chọn Import >
Paste raw text > Ấn nút import Ta được:

Gửi POST thử xem sao !

Vậy là lấy được cookie rồi ^^
Đến với phần lấy file, mình sẽ phân tích request lấy file như request trên và đây là kết quả:

Headers

Phần Headers

Phần response – file excel là đây chứ đâu ^^

Bước 2: Tiến hành code

Mình sử dụng express của NodeJS

Cấu trúc project

File login

Nhiệm vụ là lấy cookie


<span class="token keyword">let</span> <span class="token function-variable function">optionsGetCookies</span> <span class="token operator">=</span> <span class="token punctuation">(</span>username<span class="token punctuation">,</span>password<span class="token punctuation">,</span>form<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    form<span class="token punctuation">[</span><span class="token string">'__EVENTTARGET'</span><span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string">''</span><span class="token punctuation">;</span>
    form<span class="token punctuation">[</span><span class="token string">'txtUserName'</span><span class="token punctuation">]</span> <span class="token operator">=</span> username<span class="token punctuation">;</span>
    form<span class="token punctuation">[</span><span class="token string">'txtPassword'</span><span class="token punctuation">]</span> <span class="token operator">=</span> password<span class="token punctuation">;</span>
    form<span class="token punctuation">[</span><span class="token string">'btnSubmit'</span><span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string">'Đăng nhập'</span><span class="token punctuation">;</span>
    <span class="token keyword">return</span> <span class="token punctuation">{</span>
        method <span class="token punctuation">:</span> <span class="token string">'POST'</span><span class="token punctuation">,</span>
        uri <span class="token punctuation">:</span> urlLogin<span class="token punctuation">,</span>
        simple<span class="token punctuation">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
        timeout<span class="token punctuation">:</span> <span class="token number">20000</span><span class="token punctuation">,</span>
        followRedirect<span class="token punctuation">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        resolveWithFullResponse<span class="token punctuation">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        form<span class="token punctuation">:</span>form<span class="token punctuation">,</span>
        headers<span class="token punctuation">:</span> <span class="token punctuation">{</span>
            <span class="token string">'Connection'</span> <span class="token punctuation">:</span> <span class="token string">'keep-alive'</span><span class="token punctuation">,</span>
            <span class="token string">'Cache-Control'</span> <span class="token punctuation">:</span> <span class="token string">'max-age=0'</span><span class="token punctuation">,</span>
            <span class="token string">'Origin'</span> <span class="token punctuation">:</span> urlOrigin<span class="token punctuation">,</span>
            <span class="token string">'Upgrade-Insecure-Requests'</span><span class="token punctuation">:</span><span class="token string">'1'</span><span class="token punctuation">,</span>
            <span class="token string">'Content-Type'</span> <span class="token punctuation">:</span> <span class="token string">'application/x-www-form-urlencoded'</span><span class="token punctuation">,</span>
            <span class="token string">'User-Agent'</span> <span class="token punctuation">:</span> <span class="token string">'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.18 Safari/537.36 Edg/75.0.139.4'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept'</span> <span class="token punctuation">:</span> <span class="token string">'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3'</span><span class="token punctuation">,</span>
            <span class="token string">'Referer'</span> <span class="token punctuation">:</span> urlLogin<span class="token punctuation">,</span>
            <span class="token string">'Accept-Encoding'</span> <span class="token punctuation">:</span> <span class="token string">'gzip, deflate'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept-Language'</span> <span class="token punctuation">:</span> <span class="token string">'en-US,en;q=0.9'</span><span class="token punctuation">,</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>    
<span class="token punctuation">}</span>
module<span class="token punctuation">.</span><span class="token function-variable function">exports</span> <span class="token operator">=</span> <span class="token punctuation">(</span>username<span class="token punctuation">,</span>password<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">Promise</span><span class="token punctuation">(</span><span class="token punctuation">(</span>resolve<span class="token punctuation">,</span>reject<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
        <span class="token function">getElements</span><span class="token punctuation">(</span>urlLogin<span class="token punctuation">,</span><span class="token keyword">null</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token punctuation">(</span>result<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            <span class="token keyword">let</span> elements <span class="token operator">=</span> result<span class="token punctuation">.</span>elements<span class="token punctuation">;</span>
            <span class="token function">requestPromise</span><span class="token punctuation">(</span><span class="token function">optionsGetCookies</span><span class="token punctuation">(</span>username<span class="token punctuation">,</span>password<span class="token punctuation">,</span>elements<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token punctuation">(</span>_result<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
               <span class="token keyword">return</span> <span class="token function">resolve</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getCookies'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span> cookies<span class="token punctuation">:</span>_result<span class="token punctuation">.</span>headers<span class="token punctuation">[</span><span class="token string">'set-cookie'</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>_error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">return</span> <span class="token function">reject</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getCookies'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> error<span class="token punctuation">:</span>_error<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            <span class="token keyword">return</span> <span class="token function">reject</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getElements'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> error<span class="token punctuation">:</span>error<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

let optionsGetCookies = (username,password,form) =>{

form['__EVENTTARGET'] = '';

form['txtUserName'] = username;

form['txtPassword'] = password;

form['btnSubmit'] = 'Đăng nhập';

return {

method : 'POST',

uri : urlLogin,

simple: false,

timeout: 20000,

followRedirect: true,

resolveWithFullResponse: true,

form:form,

headers: {

'Connection' : 'keep-alive',

'Cache-Control' : 'max-age=0',

'Origin' : urlOrigin,

'Upgrade-Insecure-Requests':'1',

'Content-Type' : 'application/x-www-form-urlencoded',

'User-Agent' : 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.18 Safari/537.36 Edg/75.0.139.4',

'Accept' : 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3',

'Referer' : urlLogin,

'Accept-Encoding' : 'gzip, deflate',

'Accept-Language' : 'en-US,en;q=0.9',

}

module.exports = (username,password) =>{

return new Promise((resolve,reject)=>{

getElements(urlLogin,null).then((result)=>{

let elements = result.elements;

requestPromise(optionsGetCookies(username,password,elements)).then((_result)=>{

return resolve({task:'getCookies',success:true, cookies:_result.headers['set-cookie']});

}).catch((_error)=>{

return reject({task:'getCookies',success: false, error:_error});

})

}).catch((error)=>{

return reject({task:'getElements',success: false, error:error});

})

});

}

File get elements

Mục đích là lấy các element trong body.
Sử dụng cheerio

<span class="token keyword">let</span> <span class="token function-variable function">optionsGetElement</span> <span class="token operator">=</span> <span class="token punctuation">(</span>uri<span class="token punctuation">,</span>cookies<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token punctuation">{</span>
        method <span class="token punctuation">:</span> <span class="token string">'GET'</span><span class="token punctuation">,</span>
        uri <span class="token punctuation">:</span> uri<span class="token punctuation">,</span>
        followRedirect<span class="token punctuation">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        headers<span class="token punctuation">:</span> <span class="token punctuation">{</span>
            <span class="token string">'Connection'</span> <span class="token punctuation">:</span> <span class="token string">'keep-alive'</span><span class="token punctuation">,</span>
            <span class="token string">'Cache-Control'</span> <span class="token punctuation">:</span> <span class="token string">'max-age=0'</span><span class="token punctuation">,</span>
            <span class="token string">'Origin'</span> <span class="token punctuation">:</span> urlOrigin<span class="token punctuation">,</span>
            <span class="token string">'Upgrade-Insecure-Requests'</span><span class="token punctuation">:</span><span class="token string">'1'</span><span class="token punctuation">,</span>
            <span class="token string">'Content-Type'</span> <span class="token punctuation">:</span> <span class="token string">'application/x-www-form-urlencoded'</span><span class="token punctuation">,</span>
            <span class="token string">'User-Agent'</span> <span class="token punctuation">:</span> <span class="token string">'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.18 Safari/537.36 Edg/75.0.139.4'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept'</span> <span class="token punctuation">:</span> <span class="token string">'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3'</span><span class="token punctuation">,</span>
            <span class="token string">'Referer'</span> <span class="token punctuation">:</span> urlLogin<span class="token punctuation">,</span>
            <span class="token string">'Accept-Encoding'</span> <span class="token punctuation">:</span> <span class="token string">'gzip, deflate'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept-Language'</span> <span class="token punctuation">:</span> <span class="token string">'en-US,en;q=0.9'</span><span class="token punctuation">,</span>
            <span class="token string">'cookie'</span> <span class="token punctuation">:</span> <span class="token function">formatCookieListToString</span><span class="token punctuation">(</span>cookies<span class="token punctuation">)</span><span class="token punctuation">,</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>    
<span class="token punctuation">}</span>
module<span class="token punctuation">.</span><span class="token function-variable function">exports</span> <span class="token operator">=</span> <span class="token punctuation">(</span>uri<span class="token punctuation">,</span>cookies<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">Promise</span><span class="token punctuation">(</span><span class="token punctuation">(</span>resolve<span class="token punctuation">,</span>reject<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
        <span class="token function">requestPromise</span><span class="token punctuation">(</span><span class="token function">optionsGetElement</span><span class="token punctuation">(</span>uri<span class="token punctuation">,</span>cookies<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token punctuation">(</span>response<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            <span class="token keyword">let</span> $ <span class="token operator">=</span> cheerio<span class="token punctuation">.</span><span class="token function">load</span><span class="token punctuation">(</span>response<span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token keyword">let</span> hiddenInputList <span class="token operator">=</span> <span class="token function">$</span><span class="token punctuation">(</span><span class="token string">'input[type="hidden"]'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>

            
            <span class="token keyword">let</span> elements <span class="token operator">=</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">;</span>
            <span class="token keyword">if</span> <span class="token punctuation">(</span>cookies <span class="token operator">!=</span> <span class="token keyword">null</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> options <span class="token operator">=</span> <span class="token function">$</span><span class="token punctuation">(</span><span class="token string">'option[selected="selected"]'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                elements<span class="token punctuation">[</span><span class="token string">'PageHeader1$drpNgonNgu'</span><span class="token punctuation">]</span> <span class="token operator">=</span> options<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value<span class="token punctuation">;</span>
                elements<span class="token punctuation">[</span><span class="token string">'drpSemester'</span><span class="token punctuation">]</span> <span class="token operator">=</span> options<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value<span class="token punctuation">;</span>
                elements<span class="token punctuation">[</span><span class="token string">'drpTerm'</span><span class="token punctuation">]</span> <span class="token operator">=</span> options<span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value<span class="token punctuation">;</span>
                elements<span class="token punctuation">[</span><span class="token string">'drpType'</span><span class="token punctuation">]</span> <span class="token operator">=</span> options<span class="token punctuation">[</span><span class="token number">3</span><span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value<span class="token punctuation">;</span>
                elements<span class="token punctuation">[</span><span class="token string">'btnView'</span><span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string">'Xuất file Excel'</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
            
            <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i<span class="token operator">=</span><span class="token number">0</span><span class="token punctuation">;</span>i<span class="token operator">&lt;</span>hiddenInputList<span class="token punctuation">.</span>length<span class="token punctuation">;</span>i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                <span class="token keyword">if</span> <span class="token punctuation">(</span>hiddenInputList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value <span class="token operator">==</span> undefined<span class="token punctuation">)</span><span class="token punctuation">{</span>
                    elements<span class="token punctuation">[</span>hiddenInputList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>name<span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token string">''</span><span class="token punctuation">;</span>
                <span class="token punctuation">}</span><span class="token keyword">else</span><span class="token punctuation">{</span>
                    elements<span class="token punctuation">[</span>hiddenInputList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>name<span class="token punctuation">]</span> <span class="token operator">=</span> hiddenInputList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span>attribs<span class="token punctuation">.</span>value<span class="token punctuation">;</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">return</span> <span class="token function">resolve</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getElements'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span>elements<span class="token punctuation">:</span>elements<span class="token punctuation">}</span><span class="token punctuation">)</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            <span class="token keyword">return</span> <span class="token function">reject</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getElements'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">false</span><span class="token punctuation">,</span>error<span class="token punctuation">:</span>error<span class="token punctuation">}</span><span class="token punctuation">)</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span> 
<span class="token punctuation">}</span>

let optionsGetElement = (uri,cookies) =>{

return {

method : 'GET',

uri : uri,

followRedirect: true,

headers: {

'Connection' : 'keep-alive',

'Cache-Control' : 'max-age=0',

'Origin' : urlOrigin,

'Upgrade-Insecure-Requests':'1',

'Content-Type' : 'application/x-www-form-urlencoded',

'Referer' : urlLogin,

'Accept-Encoding' : 'gzip, deflate',

'Accept-Language' : 'en-US,en;q=0.9',

'cookie' : formatCookieListToString(cookies),

}

module.exports = (uri,cookies) =>{

requestPromise(optionsGetElement(uri,cookies)).then((response)=>{

let $ = cheerio.load(response);

let hiddenInputList = $('input[type="hidden"]');

let elements = {};

if (cookies != null){

let options = $('option[selected="selected"]');

elements['PageHeader1$drpNgonNgu'] = options[0].attribs.value;

elements['drpSemester'] = options[1].attribs.value;

elements['drpTerm'] = options[2].attribs.value;

elements['drpType'] = options[3].attribs.value;

elements['btnView'] = 'Xuất file Excel';

}

for (let i=0;i<hiddenInputList.length;i++){

if (hiddenInputList[i].attribs.value == undefined){

elements[hiddenInputList[i].attribs.name] = '';

}else{

elements[hiddenInputList[i].attribs.name] = hiddenInputList[i].attribs.value;

}

}).catch((error)=>{

return reject({task:'getElements',success:false,error:error})

})

});

}

Lấy file excel thời khóa biểu

<span class="token keyword">let</span> <span class="token function-variable function">optionsGetFile</span> <span class="token operator">=</span> <span class="token punctuation">(</span>cookies<span class="token punctuation">,</span>form<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token punctuation">{</span>
        resolveWithFullResponse<span class="token punctuation">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        method <span class="token punctuation">:</span> <span class="token string">'POST'</span><span class="token punctuation">,</span>
        encoding<span class="token punctuation">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
        uri <span class="token punctuation">:</span> urlStudentTimeTable<span class="token punctuation">,</span>
        headers<span class="token punctuation">:</span> <span class="token punctuation">{</span>
            <span class="token string">'Connection'</span> <span class="token punctuation">:</span> <span class="token string">'keep-alive'</span><span class="token punctuation">,</span>
            <span class="token string">'Cache-Control'</span> <span class="token punctuation">:</span> <span class="token string">'max-age=0'</span><span class="token punctuation">,</span>
            <span class="token string">'Origin'</span> <span class="token punctuation">:</span> urlOrigin<span class="token punctuation">,</span>
            <span class="token string">'Upgrade-Insecure-Requests'</span> <span class="token punctuation">:</span> <span class="token string">'1'</span><span class="token punctuation">,</span>
            <span class="token string">'Content-Type'</span> <span class="token punctuation">:</span> <span class="token string">'application/x-www-form-urlencoded'</span><span class="token punctuation">,</span>
            <span class="token string">'User-Agent'</span> <span class="token punctuation">:</span> <span class="token string">'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept'</span> <span class="token punctuation">:</span> <span class="token string">'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3'</span><span class="token punctuation">,</span>
            <span class="token string">'Referer'</span> <span class="token punctuation">:</span> urlStudentTimeTable<span class="token punctuation">,</span>
            <span class="token string">'Accept-Encoding'</span> <span class="token punctuation">:</span> <span class="token string">'gzip, deflate'</span><span class="token punctuation">,</span>
            <span class="token string">'Accept-Language'</span> <span class="token punctuation">:</span> <span class="token string">'en-US,en;q=0.9,vi;q=0.8'</span><span class="token punctuation">,</span>
            <span class="token string">'cookie'</span> <span class="token punctuation">:</span> <span class="token function">formatCookieListToString</span><span class="token punctuation">(</span>cookies<span class="token punctuation">)</span><span class="token punctuation">,</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        form<span class="token punctuation">:</span>form
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>

module<span class="token punctuation">.</span>exports <span class="token operator">=</span> <span class="token keyword">async</span><span class="token punctuation">(</span>username<span class="token punctuation">,</span>password<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">Promise</span><span class="token punctuation">(</span><span class="token keyword">async</span><span class="token punctuation">(</span>resolve<span class="token punctuation">,</span>reject<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
        <span class="token keyword">await</span> <span class="token function">getCookies</span><span class="token punctuation">(</span>username<span class="token punctuation">,</span>password<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token keyword">async</span><span class="token punctuation">(</span>result<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            <span class="token keyword">let</span> cookies <span class="token operator">=</span> result<span class="token punctuation">.</span>cookies<span class="token punctuation">;</span>
            <span class="token keyword">await</span> <span class="token function">getElements</span><span class="token punctuation">(</span>urlStudentTimeTable<span class="token punctuation">,</span>cookies<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token keyword">async</span><span class="token punctuation">(</span>_result<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">await</span> <span class="token function">requestPromise</span><span class="token punctuation">(</span><span class="token function">optionsGetFile</span><span class="token punctuation">(</span>cookies<span class="token punctuation">,</span>_result<span class="token punctuation">.</span>elements<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">then</span><span class="token punctuation">(</span><span class="token keyword">async</span><span class="token punctuation">(</span>__result<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                    <span class="token keyword">let</span> file <span class="token operator">=</span>  <span class="token keyword">await</span> fs<span class="token punctuation">.</span><span class="token function">createWriteStream</span><span class="token punctuation">(</span>path<span class="token punctuation">.</span><span class="token function">resolve</span><span class="token punctuation">(</span><span class="token template-string"><span class="token string">`</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>__dirname<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/files`</span></span><span class="token punctuation">,</span>`$<span class="token punctuation">{</span>username<span class="token punctuation">}</span><span class="token punctuation">.</span>xls`<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">await</span> file<span class="token punctuation">.</span><span class="token function">write</span><span class="token punctuation">(</span>__result<span class="token punctuation">.</span>body<span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">await</span> file<span class="token punctuation">.</span><span class="token function">end</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">return</span> <span class="token function">resolve</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'getFile'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span>filename<span class="token punctuation">:</span>`$<span class="token punctuation">{</span>username<span class="token punctuation">}</span><span class="token punctuation">.</span>xls`<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>__error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                    console<span class="token punctuation">.</span><span class="token function">log</span><span class="token punctuation">(</span>__error<span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token punctuation">}</span><span class="token punctuation">)</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>_error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                console<span class="token punctuation">.</span><span class="token function">log</span><span class="token punctuation">(</span>_error<span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token keyword">catch</span><span class="token punctuation">(</span><span class="token punctuation">(</span>error<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
            console<span class="token punctuation">.</span><span class="token function">log</span><span class="token punctuation">(</span>error<span class="token punctuation">)</span><span class="token punctuation">;</span>
        <span class="token punctuation">}</span><span class="token punctuation">)</span>
        <span class="token keyword">return</span> <span class="token function">reject</span><span class="token punctuation">(</span><span class="token string">'error'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>   
<span class="token punctuation">}</span>

let optionsGetFile = (cookies,form) =>{

return {

resolveWithFullResponse: true,

method : 'POST',

encoding: null,

uri : urlStudentTimeTable,

headers: {

'Connection' : 'keep-alive',

'Cache-Control' : 'max-age=0',

'Origin' : urlOrigin,

'Upgrade-Insecure-Requests' : '1',

'Content-Type' : 'application/x-www-form-urlencoded',

'User-Agent' : 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36',

'Referer' : urlStudentTimeTable,

'Accept-Encoding' : 'gzip, deflate',

'Accept-Language' : 'en-US,en;q=0.9,vi;q=0.8',

},

form:form

}

module.exports = async(username,password) =>{

return new Promise(async(resolve,reject)=>{

await getCookies(username,password).then(async(result)=>{

let cookies = result.cookies;

await getElements(urlStudentTimeTable,cookies).then(async(_result)=>{

await requestPromise(optionsGetFile(cookies,_result.elements)).then(async(__result)=>{

let file = await fs.createWriteStream(path.resolve(`${__dirname}/files`,`${username}.xls`));

await file.write(__result.body);

await file.end();

return resolve({task:'getFile',success:true,filename:`${username}.xls`});

}).catch((__error)=>{

console.log(__error);

})

console.log(_error);

})

}).catch((error)=>{

console.log(error);

})

return reject('error');

});

}

Trích xuất dữ liệu từ file

Phân tích file và tiến hành code.

Sử dụng xlsx.

module<span class="token punctuation">.</span><span class="token function-variable function">exports</span> <span class="token operator">=</span> <span class="token punctuation">(</span>file<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
    <span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">Promise</span><span class="token punctuation">(</span><span class="token punctuation">(</span>resolve<span class="token punctuation">,</span>reject<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
        <span class="token keyword">try</span><span class="token punctuation">{</span>
            <span class="token keyword">let</span> schedule <span class="token operator">=</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
            <span class="token keyword">let</span> <span class="token function-variable function">getAddressCell</span> <span class="token operator">=</span> <span class="token punctuation">(</span>str<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> r <span class="token operator">=</span> <span class="token regex">/d+/</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> row <span class="token operator">=</span> <span class="token function">parseInt</span><span class="token punctuation">(</span>str<span class="token punctuation">.</span><span class="token function">match</span><span class="token punctuation">(</span>r<span class="token punctuation">)</span><span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> col <span class="token operator">=</span> str<span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span>row<span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword">return</span> <span class="token punctuation">{</span>row<span class="token punctuation">:</span>row<span class="token punctuation">,</span>col<span class="token punctuation">:</span>col<span class="token punctuation">}</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">formatDateYMD</span><span class="token operator">=</span> <span class="token punctuation">(</span>str<span class="token punctuation">)</span><span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                str <span class="token operator">=</span> str<span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"/"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> day <span class="token operator">=</span> str<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> month <span class="token operator">=</span> str<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> year <span class="token operator">=</span> str<span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">Date</span><span class="token punctuation">(</span><span class="token template-string"><span class="token string">`</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>year<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>month<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>day<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">`</span></span><span class="token punctuation">)</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">formatDay</span> <span class="token operator">=</span> <span class="token punctuation">(</span>day<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">return</span> day <span class="token operator">-</span><span class="token number">1</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">findDatewithDay</span> <span class="token operator">=</span> <span class="token punctuation">(</span>start_date<span class="token punctuation">,</span>end_date<span class="token punctuation">,</span>day<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> dateList <span class="token operator">=</span><span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span> start_date<span class="token punctuation">;</span> i <span class="token operator">&lt;</span> end_date<span class="token punctuation">;</span> i<span class="token operator">+=</span><span class="token number">60</span><span class="token operator">*</span><span class="token number">60</span><span class="token operator">*</span><span class="token number">24</span><span class="token operator">*</span><span class="token number">1000</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">let</span> date_check <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">Date</span><span class="token punctuation">(</span>i<span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">if</span><span class="token punctuation">(</span><span class="token function">formatDay</span><span class="token punctuation">(</span>day<span class="token punctuation">)</span> <span class="token operator">==</span> date_check<span class="token punctuation">.</span><span class="token function">getDay</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                        dateList<span class="token punctuation">.</span><span class="token function">push</span><span class="token punctuation">(</span>date_check<span class="token punctuation">.</span><span class="token function">getTime</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> 
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
                <span class="token keyword">return</span> dateList<span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">findIndexDate</span> <span class="token operator">=</span> <span class="token punctuation">(</span>date<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> index <span class="token operator">=</span> <span class="token operator">-</span><span class="token number">1</span><span class="token punctuation">;</span>
                <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span> <span class="token number">0</span><span class="token punctuation">;</span> i <span class="token operator">&lt;</span> schedule<span class="token punctuation">.</span>length<span class="token punctuation">;</span>i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">if</span> <span class="token punctuation">(</span>schedule<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span>date<span class="token operator">==</span>date<span class="token punctuation">)</span><span class="token punctuation">{</span>
                        <span class="token keyword">return</span> i<span class="token punctuation">;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
                <span class="token keyword">return</span> index<span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">addToSchedule</span> <span class="token operator">=</span> <span class="token punctuation">(</span>start_date<span class="token punctuation">,</span>end_date<span class="token punctuation">,</span>day<span class="token punctuation">,</span>lesson<span class="token punctuation">,</span>subject_name<span class="token punctuation">,</span>address<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> dateList <span class="token operator">=</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token comment">// console.log(start_date,end_date,day,lesson,subject_name,address);</span>
                dateList <span class="token operator">=</span> <span class="token function">findDatewithDay</span><span class="token punctuation">(</span>start_date<span class="token punctuation">,</span>end_date<span class="token punctuation">,</span>day<span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span> <span class="token number">0</span><span class="token punctuation">;</span> i <span class="token operator">&lt;</span> dateList<span class="token punctuation">.</span>length<span class="token punctuation">;</span> i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">var</span> found <span class="token operator">=</span> <span class="token function">findIndexDate</span><span class="token punctuation">(</span>dateList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">if</span> <span class="token punctuation">(</span>found <span class="token operator">==</span> <span class="token operator">-</span><span class="token number">1</span> <span class="token punctuation">)</span><span class="token punctuation">{</span>
                        <span class="token keyword">let</span> lessons <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">Array</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        lessons<span class="token punctuation">.</span><span class="token function">push</span><span class="token punctuation">(</span><span class="token punctuation">{</span>lesson<span class="token punctuation">:</span>lesson<span class="token punctuation">,</span>subject_name<span class="token punctuation">:</span>subject_name<span class="token punctuation">,</span>address<span class="token punctuation">:</span>address<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        schedule<span class="token punctuation">.</span><span class="token function">push</span><span class="token punctuation">(</span><span class="token punctuation">{</span>date<span class="token punctuation">:</span>dateList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">,</span>lessons<span class="token punctuation">:</span>lessons<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token punctuation">}</span><span class="token keyword">else</span><span class="token punctuation">{</span>
                        schedule<span class="token punctuation">[</span>found<span class="token punctuation">]</span><span class="token punctuation">.</span>lessons<span class="token punctuation">.</span><span class="token function">push</span><span class="token punctuation">(</span><span class="token punctuation">{</span>lesson<span class="token punctuation">:</span>lesson<span class="token punctuation">,</span>subject_name<span class="token punctuation">:</span>subject_name<span class="token punctuation">,</span>address<span class="token punctuation">:</span>address<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">lessonArray</span> <span class="token operator">=</span> <span class="token punctuation">(</span>lesson<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                <span class="token keyword">let</span> lesson_array_new <span class="token operator">=</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">let</span> lesson_array <span class="token operator">=</span> <span class="token punctuation">[</span><span class="token string">'1,2,3'</span><span class="token punctuation">,</span><span class="token string">'4,5,6'</span><span class="token punctuation">,</span><span class="token string">'7,8,9'</span><span class="token punctuation">,</span><span class="token string">'10,11,12'</span><span class="token punctuation">,</span><span class="token string">'13,14,15,16'</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span> <span class="token number">0</span> <span class="token punctuation">;</span> i <span class="token operator">&lt;</span> lesson_array<span class="token punctuation">.</span>length <span class="token punctuation">;</span> i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">if</span> <span class="token punctuation">(</span>lesson<span class="token punctuation">.</span><span class="token function">indexOf</span><span class="token punctuation">(</span>lesson_array<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">)</span> <span class="token operator">!=</span> <span class="token operator">-</span><span class="token number">1</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                        lesson_array_new<span class="token punctuation">.</span><span class="token function">push</span><span class="token punctuation">(</span>lesson_array<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
                <span class="token keyword">return</span> lesson_array_new<span class="token punctuation">;</span>
            <span class="token punctuation">}</span>
            <span class="token keyword">let</span> <span class="token function-variable function">getInfoDetail</span> <span class="token operator">=</span> <span class="token punctuation">(</span>start_date<span class="token punctuation">,</span>end_date<span class="token punctuation">,</span>subject_name<span class="token punctuation">,</span>str<span class="token punctuation">)</span> <span class="token operator">=&gt;</span><span class="token punctuation">{</span>
                str <span class="token operator">=</span> str<span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"n"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i<span class="token operator">=</span><span class="token number">0</span><span class="token punctuation">;</span>i <span class="token operator">&lt;</span> str<span class="token punctuation">.</span>length<span class="token punctuation">;</span> i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">if</span> <span class="token punctuation">(</span>str<span class="token punctuation">[</span>i<span class="token punctuation">]</span> <span class="token operator">!=</span> <span class="token string">''</span> <span class="token operator">&amp;&amp;</span> str<span class="token punctuation">[</span>i<span class="token punctuation">]</span> <span class="token operator">!=</span> <span class="token keyword">null</span> <span class="token operator">&amp;&amp;</span> str<span class="token punctuation">[</span>i<span class="token punctuation">]</span> <span class="token operator">!=</span> undefined<span class="token punctuation">)</span><span class="token punctuation">{</span>
                        <span class="token comment">//console.log("===&gt;",str_start_date,str_end_date,str[i]);</span>
                        <span class="token keyword">let</span> str_info <span class="token operator">=</span> str<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"tại"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> address <span class="token operator">=</span> str_info<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> day_and_lesson <span class="token operator">=</span> str_info<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"tiết"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> lesson <span class="token operator">=</span> day_and_lesson<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">" "</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">" "</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> day <span class="token operator">=</span> day_and_lesson<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">" "</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">"Thứ"</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> lesson_array <span class="token operator">=</span> <span class="token function">lessonArray</span><span class="token punctuation">(</span>lesson<span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span> <span class="token number">0</span><span class="token punctuation">;</span> i <span class="token operator">&lt;</span> lesson_array<span class="token punctuation">.</span>length<span class="token punctuation">;</span>i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                            <span class="token comment">// console.log(start_date,end_date,day,lesson_array[i],subject_name,address);</span>
                            <span class="token function">addToSchedule</span><span class="token punctuation">(</span>start_date<span class="token punctuation">,</span>end_date<span class="token punctuation">,</span>day<span class="token punctuation">,</span>lesson_array<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">,</span>subject_name<span class="token punctuation">,</span>address<span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span> 
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span>     
            <span class="token keyword">var</span> workbook <span class="token operator">=</span> <span class="token constant">XLSX</span><span class="token punctuation">.</span><span class="token function">readFile</span><span class="token punctuation">(</span>path<span class="token punctuation">.</span><span class="token function">resolve</span><span class="token punctuation">(</span><span class="token template-string"><span class="token string">`</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>__dirname<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/files`</span></span><span class="token punctuation">,</span>file<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token keyword">var</span> worksheet <span class="token operator">=</span> workbook<span class="token punctuation">.</span>Sheets<span class="token punctuation">[</span>workbook<span class="token punctuation">.</span>SheetNames<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">]</span><span class="token punctuation">;</span>

            <span class="token keyword">let</span>  name <span class="token operator">=</span> worksheet<span class="token punctuation">[</span><span class="token string">"C6"</span><span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
            <span class="token keyword">let</span>  student_id <span class="token operator">=</span> worksheet<span class="token punctuation">[</span><span class="token string">"F6"</span><span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
            <span class="token keyword">let</span>  class_name <span class="token operator">=</span> worksheet<span class="token punctuation">[</span><span class="token string">"C7"</span><span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
            <span class="token keyword">let</span>  major <span class="token operator">=</span> worksheet<span class="token punctuation">[</span><span class="token string">"F8"</span><span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
            <span class="token keyword">for</span> <span class="token punctuation">(</span>z <span class="token keyword">in</span> worksheet<span class="token punctuation">)</span> <span class="token punctuation">{</span>
                <span class="token keyword">if</span><span class="token punctuation">(</span>z<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span> <span class="token operator">===</span> <span class="token string">'!'</span><span class="token punctuation">)</span> <span class="token keyword">continue</span><span class="token punctuation">;</span>
                    <span class="token comment">//console.log(getAddressCell(z),z,worksheet[z]["v"]);</span>
                <span class="token keyword">if</span> <span class="token punctuation">(</span>worksheet<span class="token punctuation">[</span>z<span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">toString</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">indexOf</span><span class="token punctuation">(</span><span class="token string">"Từ"</span><span class="token punctuation">)</span><span class="token operator">&gt;=</span><span class="token number">0</span> <span class="token operator">&amp;&amp;</span> worksheet<span class="token punctuation">[</span>z<span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">toString</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">indexOf</span><span class="token punctuation">(</span><span class="token string">"đến"</span><span class="token punctuation">)</span><span class="token operator">&gt;=</span><span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                    <span class="token keyword">let</span> address_cell <span class="token operator">=</span> <span class="token function">getAddressCell</span><span class="token punctuation">(</span>z<span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">let</span> subject_name <span class="token operator">=</span> worksheet<span class="token punctuation">[</span><span class="token template-string"><span class="token string">`F</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>address_cell<span class="token punctuation">.</span>row<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">`</span></span><span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"-"</span><span class="token punctuation">)</span><span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                    <span class="token keyword">let</span> sessionList <span class="token operator">=</span> worksheet<span class="token punctuation">[</span>z<span class="token punctuation">]</span><span class="token punctuation">[</span><span class="token string">"v"</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">toString</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"Từ"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                    <span class="token keyword">for</span> <span class="token punctuation">(</span><span class="token keyword">let</span> i <span class="token operator">=</span><span class="token number">0</span><span class="token punctuation">;</span>i<span class="token operator">&lt;</span>sessionList<span class="token punctuation">.</span>length<span class="token punctuation">;</span>i<span class="token operator">++</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
                        <span class="token keyword">let</span> str <span class="token operator">=</span> sessionList<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">"n"</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">":"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> str_datetime <span class="token operator">=</span> str<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token function">replace</span><span class="token punctuation">(</span><span class="token string">" "</span><span class="token punctuation">,</span><span class="token string">""</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">split</span><span class="token punctuation">(</span><span class="token string">"đến"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> str_start_date <span class="token operator">=</span> str_datetime<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                        <span class="token keyword">let</span> str_end_date <span class="token operator">=</span> str_datetime<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
                        <span class="token keyword">if</span> <span class="token punctuation">(</span>str_start_date <span class="token operator">!=</span> undefined <span class="token operator">&amp;&amp;</span> str_end_date <span class="token operator">!=</span> undefined<span class="token punctuation">)</span><span class="token punctuation">{</span>
                            <span class="token function">getInfoDetail</span><span class="token punctuation">(</span><span class="token function">formatDateYMD</span><span class="token punctuation">(</span>str_start_date<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">getTime</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">,</span><span class="token function">formatDateYMD</span><span class="token punctuation">(</span>str_end_date<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">getTime</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">,</span>subject_name<span class="token punctuation">,</span>str<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
                        <span class="token punctuation">}</span>
                    <span class="token punctuation">}</span>          
                <span class="token punctuation">}</span> 
            <span class="token punctuation">}</span>
            fs<span class="token punctuation">.</span><span class="token function">unlink</span><span class="token punctuation">(</span>path<span class="token punctuation">.</span><span class="token function">resolve</span><span class="token punctuation">(</span><span class="token template-string"><span class="token string">`</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>__dirname<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/files`</span></span><span class="token punctuation">,</span>file<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token keyword">function</span> <span class="token punctuation">(</span>err<span class="token punctuation">)</span> <span class="token punctuation">{</span>
                <span class="token keyword">if</span> <span class="token punctuation">(</span>err<span class="token punctuation">)</span> <span class="token keyword">throw</span> err<span class="token punctuation">;</span>
                <span class="token comment">// if no error, file has been deleted successfully</span>
                console<span class="token punctuation">.</span><span class="token function">log</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'readFile'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span>message<span class="token punctuation">:</span><span class="token template-string"><span class="token string">`File </span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>file<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string"> deleted!`</span></span><span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span> 
            <span class="token keyword">return</span> <span class="token function">resolve</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'readFile'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span>student_id <span class="token punctuation">:</span>student_id<span class="token punctuation">,</span>name<span class="token punctuation">:</span>name<span class="token punctuation">,</span>class_name<span class="token punctuation">:</span>class_name<span class="token punctuation">,</span>major<span class="token punctuation">:</span>major<span class="token punctuation">,</span>schedule<span class="token punctuation">:</span>schedule<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
        <span class="token punctuation">}</span><span class="token keyword">catch</span><span class="token punctuation">(</span>e<span class="token punctuation">)</span><span class="token punctuation">{</span>
            fs<span class="token punctuation">.</span><span class="token function">unlink</span><span class="token punctuation">(</span>path<span class="token punctuation">.</span><span class="token function">resolve</span><span class="token punctuation">(</span><span class="token template-string"><span class="token string">`</span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>__dirname<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string">/files`</span></span><span class="token punctuation">,</span>file<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token keyword">function</span> <span class="token punctuation">(</span>err<span class="token punctuation">)</span> <span class="token punctuation">{</span>
                <span class="token keyword">if</span> <span class="token punctuation">(</span>err<span class="token punctuation">)</span> <span class="token keyword">throw</span> err<span class="token punctuation">;</span>
                <span class="token comment">// if no error, file has been deleted successfully</span>
                console<span class="token punctuation">.</span><span class="token function">log</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'readFile'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">true</span><span class="token punctuation">,</span>message<span class="token punctuation">:</span><span class="token template-string"><span class="token string">`File </span><span class="token interpolation"><span class="token interpolation-punctuation punctuation">${</span>file<span class="token interpolation-punctuation punctuation">}</span></span><span class="token string"> deleted!`</span></span><span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
            <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span> 
            <span class="token keyword">return</span> <span class="token function">reject</span><span class="token punctuation">(</span><span class="token punctuation">{</span>task<span class="token punctuation">:</span><span class="token string">'readFile'</span><span class="token punctuation">,</span>success<span class="token punctuation">:</span><span class="token boolean">false</span><span class="token punctuation">,</span>error<span class="token punctuation">:</span>e<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

module.exports = (file) =>{

try{

let schedule = [];

let getAddressCell = (str) =>{

let r = /d+/;

let row = parseInt(str.match(r)[0]);

let col = str.replace(row,"");

return {row:row,col:col}

}

let formatDateYMD= (str)=>{

str = str.split("/");

let day = str[0];

let month = str[1];

let year = str[2];

return new Date(`${year}/${month}/${day}`)

}

let formatDay = (day) =>{

return day -1;

}

let findDatewithDay = (start_date,end_date,day) =>{

let dateList =[];

for (let i = start_date; i < end_date; i+=60*60*24*1000){

let date_check = new Date(i);

if(formatDay(day) == date_check.getDay()){

dateList.push(date_check.getTime());

}

return dateList;

}

let findIndexDate = (date) =>{

let index = -1;

for (let i = 0; i < schedule.length;i++){

if (schedule[i].date==date){

return i;

}

return index;

}

let addToSchedule = (start_date,end_date,day,lesson,subject_name,address) =>{

let dateList = [];

// console.log(start_date,end_date,day,lesson,subject_name,address);

dateList = findDatewithDay(start_date,end_date,day);

for (let i = 0; i < dateList.length; i++){

var found = findIndexDate(dateList[i]);

if (found == -1 ){

let lessons = new Array();

lessons.push({lesson:lesson,subject_name:subject_name,address:address});

schedule.push({date:dateList[i],lessons:lessons});

}else{

schedule[found].lessons.push({lesson:lesson,subject_name:subject_name,address:address});

}

let lessonArray = (lesson) =>{

let lesson_array_new = [];

let lesson_array = ['1,2,3','4,5,6','7,8,9','10,11,12','13,14,15,16'];

for (let i = 0 ; i < lesson_array.length ; i++){

if (lesson.indexOf(lesson_array[i]) != -1){

lesson_array_new.push(lesson_array[i]);

}

return lesson_array_new;

}

let getInfoDetail = (start_date,end_date,subject_name,str) =>{

str = str.split("n");

for (let i=0;i < str.length; i++){

if (str[i] != '' && str[i] != null && str[i] != undefined){

//console.log("===>",str_start_date,str_end_date,str[i]);

let str_info = str[i].split("tại");

let address = str_info[1];

let day_and_lesson = str_info[0].split("tiết");

let lesson = day_and_lesson[1].replace(" ","").replace(" ","");

let day = day_and_lesson[0].replace(" ","").replace("Thứ","");

let lesson_array = lessonArray(lesson);

for (let i = 0; i < lesson_array.length;i++){

// console.log(start_date,end_date,day,lesson_array[i],subject_name,address);

addToSchedule(start_date,end_date,day,lesson_array[i],subject_name,address);

}

var workbook = XLSX.readFile(path.resolve(`${__dirname}/files`,file));

var worksheet = workbook.Sheets[workbook.SheetNames[0]];

let name = worksheet["C6"]["v"];

let student_id = worksheet["F6"]["v"];

let class_name = worksheet["C7"]["v"];

let major = worksheet["F8"]["v"];

for (z in worksheet) {

if(z[0] === '!') continue;

//console.log(getAddressCell(z),z,worksheet[z]["v"]);

if (worksheet[z]["v"].toString().indexOf("Từ")>=0 && worksheet[z]["v"].toString().indexOf("đến")>=0){

let address_cell = getAddressCell(z);

let subject_name = worksheet[`F${address_cell.row}`]["v"].split("-")[0];

let sessionList = worksheet[z]["v"].toString().split("Từ");

for (let i =0;i<sessionList.length;i++){

let str = sessionList[i].replace("n","").split(":");

let str_datetime = str[0].replace(" ","").split("đến");

let str_start_date = str_datetime[0];

let str_end_date = str_datetime[1];

if (str_start_date != undefined && str_end_date != undefined){

getInfoDetail(formatDateYMD(str_start_date).getTime(),formatDateYMD(str_end_date).getTime(),subject_name,str[1]);

}

fs.unlink(path.resolve(`${__dirname}/files`,file), function (err) {

if (err) throw err;

// if no error, file has been deleted successfully

console.log({task:'readFile',success:true,message:`File ${file} deleted!`});

});

return resolve({task:'readFile',success:true,student_id :student_id,name:name,class_name:class_name,major:major,schedule:schedule});

}catch(e){

// if no error, file has been deleted successfully

});

return reject({task:'readFile',success:false,error:e});

}

});

}

Kết quả

<span class="token punctuation">{</span><span class="token property">"task"</span><span class="token operator">:</span><span class="token string">"readFile"</span><span class="token punctuation">,</span><span class="token property">"success"</span><span class="token operator">:</span><span class="token boolean">true</span><span class="token punctuation">,</span><span class="token property">"student_id"</span><span class="token operator">:</span><span class="token string">"xxxxx"</span><span class="token punctuation">,</span><span class="token property">"name"</span><span class="token operator">:</span><span class="token string">"xxxxx"</span><span class="token punctuation">,</span><span class="token property">"class_name"</span><span class="token operator">:</span><span class="token string">"xxx"</span><span class="token punctuation">,</span><span class="token property">"major"</span><span class="token operator">:</span><span class="token string">"Công nghệ thông tin"</span><span class="token punctuation">,</span><span class="token property">"schedule"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1578355200000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1578960000000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Kiến trúc máy tính"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1580688000000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1581292800000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1581897600000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1582502400000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1583107200000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1583712000000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1584316800000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"7,8,9"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Nguyên lý hệ điều hành"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span><span class="token property">"date"</span><span class="token operator">:</span><span class="token number">1584057600000</span><span class="token punctuation">,</span><span class="token property">"lessons"</span><span class="token operator">:</span><span class="token punctuation">[</span><span class="token punctuation">{</span><span class="token property">"lesson"</span><span class="token operator">:</span><span class="token string">"10,11,12"</span><span class="token punctuation">,</span><span class="token property">"subject_name"</span><span class="token operator">:</span><span class="token string">"Hệ thống thông tin di động"</span><span class="token punctuation">,</span><span class="token property">"address"</span><span class="token operator">:</span><span class="token string">" 301_TA2 TA2"</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">}</span>

{"task":"readFile","success":true,"student_id":"xxxxx","name":"xxxxx","class_name":"xxx","major":"Công nghệ thông tin","schedule":[{"date":1578355200000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"}]},{"date":1578960000000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Kiến trúc máy tính","address":" 301_TA2 TA2"}]},{"date":1580688000000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1581292800000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1581897600000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1582502400000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1583107200000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1583712000000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1584316800000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"},{"lesson":"7,8,9","subject_name":"Nguyên lý hệ điều hành","address":" 301_TA2 TA2"}]},{"date":1584057600000,"lessons":[{"lesson":"10,11,12","subject_name":"Hệ thống thông tin di động","address":" 301_TA2 TA2"}]}]}

Sản phẩm

API được sử dụng trong app viết bởi anh trong CLB của mình.
Ứng dụng xem lịch học
Ảnh

Link bài viết https://traiit.github.io/javascript/nodejs/2020/03/07/Toi-da-viet-API-lay-thoi-khoa-bieu-truong-nhu-the-nao.html

traiIT, Xin cảm ơn các bạn

Chia sẻ bài viết ngay

Nguồn bài viết : Viblo