File size: 2,721 Bytes
6747401
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>CSV File Upload</title>
    <link rel="stylesheet" href="{{ url_for('static', filename='styles.css') }}">
</head>
<body>
    <div class="container">
        <h1>Vendor Master De-Duplication Tool</h1>
        <form id="uploadForm" enctype="multipart/form-data">
            <input type="file" name="file" id="csvFile" accept=".xlsx">
        </form>
        <div class="options-wrapper">
            <div id="checkbox-heading">Select the options based on which duplication check will be performed and submit</div>
            <div class="options-container">
                <div class="option">
                    <input type="checkbox" name="option" value="Tax" id="option1" checked>
                    <label for="option1">Tax</label>
                </div>
                <div class="option">
                    <input type="checkbox" name="option" value="Bank" id="option2" checked>
                    <label for="option2">Bank</label>
                </div>
                <div class="option">
                    <input type="checkbox" name="option" value="Address" id="option3" checked>
                    <label for="option3">Address</label>
                </div>
                <div class="option">
                    <input type="checkbox" name="option" value="Name" id="option4" checked>
                    <label for="option4">Name</label>
                </div>
                <div class="option">
                    <input type="checkbox" name="option" value="PostCode" id="option5" checked>
                    <label for="option5">PostCode</label>
                </div>
                <div class="option">
                    <input type="checkbox" name="option" value="AccGrp" id="option6" checked>
                    <label for="option6">AccGrp</label>
                </div>
            </div>
        </div>
        <button type="button" id="submitBtn">Submit</button>
        <div id="processingMsg" class="hidden">
            <div class="spinner"></div>
        </div>
        <div id="progressBar"></div>
        <div id="downloadBtn" class="hidden">
            <a id="downloadLink" href="{{ url_for('download_file', filename='output.xlsx') }}">
                <button>Download Processed XLSX</button>
            </a>
        </div>
        <div id="explanation-note">
            Note: The last column titled 'explanation' in output file contains the analysis for potential duplicates with the following row.
        </div>
    </div>
    <script src="{{ url_for('static', filename='script.js') }}"></script>
</body>
</html>