diff options
| -rw-r--r-- | bidding_data.py | 124 | ||||
| -rwxr-xr-x | bidding_data.sh | 4 | ||||
| -rw-r--r-- | javas/bidding.js | 43 |
3 files changed, 171 insertions, 0 deletions
diff --git a/bidding_data.py b/bidding_data.py new file mode 100644 index 0000000..99ea2ef --- /dev/null +++ b/bidding_data.py @@ -0,0 +1,124 @@ +import csv, sys, json, glob, re +from os import path +from bs4 import BeautifulSoup as bs4 + +bidding_data = [] + +with file(sys.argv[1]) as bidding_file: + bidding_csv = csv.reader(bidding_file) + for line in bidding_csv: + bidding_data.append(line) + +sitting_data = [] + +with file(sys.argv[2]) as sitting_file: + sitting_csv = csv.reader(sitting_file) + for line in sitting_csv: + sitting_data.append(line) + +round_lineups = {} + +for sitting in sitting_data[1:]: + round_no = int(sitting[2]) + table_no = sitting[0] + '_' + sitting[1] + if not round_lineups.has_key(round_no): + round_lineups[round_no] = {} + round_lineups[round_no][table_no] = sorted([int(sitting[3]), int(sitting[4])]) + +bids = {} + +for bid in bidding_data[1:]: + board_no = int(bid[4]) + round_no = int(bid[3]) + table_no = bid[1] + '_' + bid[2] + bid_counter = int(bid[5]) + bid_erased = int(bid[10]) + if not bids.has_key(board_no): + bids[board_no] = {} + if not bids[board_no].has_key(table_no): + bids[board_no][table_no] = {} + if not bids[board_no][table_no].has_key(round_no): + bids[board_no][table_no][round_no] = {} + if bid_erased == 1: + if bids[board_no][table_no][round_no].has_key(bid_counter): + if bids[board_no][table_no][round_no][bid_counter]['direction'] == bid[6]: + bids[board_no][table_no][round_no].pop(bid_counter, None) + else: + bids[board_no][table_no][round_no][bid_counter] = {'direction': bid[6], 'bid': bid[7] } + +tournament_path_prefix = sys.argv[3] + '.html' + +output_path = path.dirname(tournament_path_prefix) +tournament_prefix = path.splitext(path.realpath(tournament_path_prefix))[0] + +directions = ['W', 'N', 'E', 'S'] + +def format_bidding(bidding): + html_output = '<table>' + html_output = html_output + '<tr>' + for dir in directions: + html_output = html_output + '<th>' + dir + '</th>' + html_output = html_output + '</tr>' + for bid_round in bidding: + html_output = html_output + '<tr>' + for bid in bid_round: + html_output = html_output + '<td>' + bid + '</td>' + html_output = html_output + '</tr>' + html_output = html_output + '</table>' + return html_output + +for board_no, board_data in bids.items(): + for table_no, table_data in board_data.items(): + for round_no, round_data in table_data.items(): + bidding = sorted(round_data) + dealer = round_data[bidding[0]]['direction'] + bidding_table = [[], [], [], []] + for bid_index in bidding: + bid = round_data[bid_index] + bidding_table[directions.index(bid['direction'])].append(bid['bid']) + last_bidder = bid['direction'] + for pos in range(0, directions.index(dealer)): + bidding_table[pos].insert(0, '') + for pos in range(directions.index(last_bidder), len(directions)): + bidding_table[pos].append('') + bidding_table = map(list, zip(*bidding_table)) + # TODO: file_number, a nie deal_number + bidding_file_path = tournament_prefix + '_bidding_' + str(board_no) + '_' + '_'.join(map(str, round_lineups[round_no][table_no])) + '.txt' + with file(bidding_file_path, 'w') as bidding_file: + bidding_file.write(format_bidding(bidding_table)) + +tournament_files_match = re.compile(tournament_prefix + '([0-9]{3})\.html') +tournament_files = [f for f in glob.glob(tournament_prefix + '*.html') if re.search(tournament_files_match, f)] + +deal_numbers = {} + +for tournament_file in tournament_files: + file_number = re.match(tournament_files_match, tournament_file).group(1) + with file(tournament_file, 'r+') as board_html: + board_content = bs4(board_html, from_encoding='utf-8') + header_scripts = board_content.select('head script') + jquery_scripts = [script for script in header_scripts if script['src'] == 'javas/jquery.js'] + if not len(jquery_scripts): + board_content.head.append(bs4('<script src="javas/jquery.js" type="text/javascript"></script>').script) + bidding_scripts = [script for script in header_scripts if script['src'] == 'javas/bidding.js'] + if not len(bidding_scripts): + board_content.head.append(bs4('<script src="javas/bidding.js" type="text/javascript"></script>').script) + board_number = board_content.select('h4')[0].contents[0].strip().replace('ROZDANIE ', '') + deal_numbers[file_number] = board_number + board_html.seek(0) + board_html.write(board_content.prettify('utf-8')) + board_text_path = path.splitext(tournament_file)[0] + '.txt' + with file(board_text_path, 'r+') as board_text: + board_text_content = bs4(board_text, from_encoding='iso-8859-2') + for row in board_text_content.select('tr'): + cells = row.select('td') + if len(cells) == 11: + pair_numbers = sorted([int(cells[1].contents[0]), int(cells[2].contents[0])]) + bidding_link = bs4('<a href="#" class="biddingLink">[lic]</a>') + # TODO: file_number, a nie deal_number + bidding_link.a['data-bidding-link'] = path.basename(tournament_prefix) + '_bidding_' + str(deal_numbers[file_number]) + '_' + '_'.join(map(str, pair_numbers)) + '.txt' + for link in cells[3].select('a.biddingLink'): + link.extract() + cells[3].append(bidding_link) + board_text.seek(0) + board_text.write(board_text_content.body.table.prettify('iso-8859-2')) diff --git a/bidding_data.sh b/bidding_data.sh new file mode 100755 index 0000000..916a315 --- /dev/null +++ b/bidding_data.sh @@ -0,0 +1,4 @@ +#!/bin/bash +mdb-export "$1" BiddingData > "$1.csv" +mdb-export "$1" RoundData > "$1.sitting.csv" +python bidding_data.py "$1.csv" "$1.sitting.csv" "$2" diff --git a/javas/bidding.js b/javas/bidding.js new file mode 100644 index 0000000..5165aa8 --- /dev/null +++ b/javas/bidding.js @@ -0,0 +1,43 @@ +var display_bidding = function(element, bidding) { + var popup = $('<div id="bidding_popup"></div>'); + popup.css({ + 'position': 'absolute', + 'width': '250px', + 'left': element.position().left + element.width(), + 'top': element.position().top + }); + popup.html(bidding); + element.after(popup); +} + +var load_bidding = function() { + $('#bidding_popup').remove(); + var elem = $(this); + $.ajax( + { + url: elem.attr('data-bidding-link'), + complete: function(xhr, status) { + if (status == 'success') { + display_bidding(elem, xhr.responseText); + } + else { + display_bidding(elem, 'Brak danych'); + } + } + } + ); + return false; +}; + +var bind_bidding_links = function() { + $('a.biddingLink').each(function() { + $(this).unbind('click').click(load_bidding); + }); + $(document).click(function() { + $('#bidding_popup').remove(); + }); +}; + +$(document).ready(function() { + setInterval(bind_bidding_links, 1000); +}); |