args = parser.parse_args()
board_slug = args.board
mongo_host = args.mhost
mongo_port = args.mport
mongo_db = args.db
odir = args.odir
ofile = args.out
report = args.report
report_title = "{rp}-Status-Report".format(rp=report.capitalize())
if not ofile:
ofile = "{}-{}.csv".format(report_title,
datetime.now().strftime("%d-%b-%Y"))
logger.info("Generating : {}".format(ofile))
if report == "trade":
board_slug = "gpm-trades-2020"
cr = TradeCardReader(board_slug, mongo_host, mongo_port, mongo_db)
if report == "compliance":
board_slug = "compliance-work"
cr = ComplianceCardReader(board_slug, mongo_host, mongo_port, mongo_db)
cr.load_cards()
cr.load_raw_trades()
cr.transform_raw_trades()
cr.load_trades()
cr.export_trades(ofile)
class TradeCardReader(WekanCardReader):
def __init__(self, board_slug, mh, mp, mdb):
self.trades = []
self.locations = {}
self.logger = GPMLogger("card_reader").get_logger()
self.pattern = re.compile("(?P<client>\d+)\s-\s(?P<otype>.*)")
self.raw_trades = []
self.trades = []
self.xform_trades = []
self.csv_card_mapping = {
"Trade Date": "A Trade Date",
"Delivery Date": "B Delivery Date",
"Client Number": "Client",
"Document No": "M Document No.",
"Location": "E Location",
"Transaction Type": "C Transaction Type",
"Metal": "L Metal",
"Order Type": "D Order Type",
"Order Detail": "H Bars Composition",
"Premium (%)": "G Transaction Premium (%)",
"Referral": "I Referral",
"Pricing Method": "F Pricing Option",
"Remarks+": "J Remarks",
"Labels": "labelIds",
"Things To Do": "Things To Do",
"Operations Team Action": "Operations Team Action",
"BD/CR Action Needed": "BD/CR Action Needed",
"Completed Trades": "Completed Trades",
}
self.trade_obj = {k: "" for k in self.csv_card_mapping.keys()}
WekanCardReader.__init__(self, board_slug, mh, mp, mdb)
def get_trade_object(self):
trade = {k: "" for k in self.csv_card_mapping.keys()}
return trade
def load_raw_trades(self):
cards = self.db["cards"].find({"boardId": self.board_id, "archived": False})
for card in cards:
try:
raw_trade = deepcopy(self.raw_object)
match_result = self.pattern.match(card["title"])
if match_result:
raw_trade["id"] = card["_id"]
for field in card["customFields"]:
try:
raw_trade[field["_id"]] = field["value"]
except KeyError as ke:
raw_trade[field["_id"]] = ""
try:
raw_trade["labelIds"] = card["labelIds"]
except KeyError as ke:
raw_trade["labelIds"] = []
matched_dict = match_result.groupdict()
raw_trade["Client"] = matched_dict["client"]
self.raw_trades.append(raw_trade)
except KeyError as ke:
self.logger.debug(ex)
except Exception as ex:
self.logger.debug(ex)
no_of_raw_trade = len(self.raw_trades)
self.logger.info("Total {} raw trades found".format(no_of_raw_trade))
def transform_raw_trade(self, trade):
"""
level 0 : Value of the key is actual valie
level 1 : Value of the key maps to other dictrionary. One more lookup
Assign values to fields based on if its level 0/1 custom field
"""
xtrade = deepcopy(trade)
l1cfkeys = list(self.l1_customfields.keys())
for fid, fval in trade.items():
try:
if fid in l1cfkeys:
xtrade[self.customfields[fid]] = self.l1_customfields[fid][fval]
else:
xtrade[self.customfields[fid]] = fval
except KeyError as ke:
# self.logger.debug(ke)
pass
except Exception as ex:
self.logger.debug(ex)
for blk, blv in self.mapped_moved_cards[xtrade["id"]].items():
xtrade[self.board_lists[blk]] = blv.strftime("%d/%m/%Y")
return xtrade
def transform_raw_trades(self):
self.xform_trades = [
self.transform_raw_trade(trade) for trade in self.raw_trades
]
def load_trades(self):
cards = self.db["cards"].find({"boardId": self.board_id})
trades = []
for raw_trade in self.xform_trades:
try:
trade = deepcopy(self.trade_obj)
for (csv_field, card_field) in self.csv_card_mapping.items():
try:
trade[csv_field] = raw_trade[card_field]
except KeyError as ke:
trade[csv_field] = ""
pass
trade["Trade Date"] = (
trade["Trade Date"].strftime("%d/%m/%Y")
if trade["Trade Date"]
else ""
)
trade["Delivery Date"] = (
trade["Delivery Date"].strftime("%d/%m/%Y")
if trade["Delivery Date"]
else ""
)
card_labels = [self.labels[lid] for lid in raw_trade["labelIds"]]
csv_labels = " | "
csv_labels = csv_labels.join(card_labels)
trade["Labels"] = csv_labels
# Replace level 2 mapping
trades.append(trade)
except KeyError as ke:
self.logger.debug(ex)
except Exception as ex:
self.logger.debug(ex)
no_of_qurated_trade = len(trades)
self.logger.info("Total {} qurated trades found".format(no_of_qurated_trade))
self.trades = trades
def export_trades(self, ofile):
keys = self.csv_card_mapping.keys()
with open(ofile, "w") as trades_csv:
trades_csv_writer = csv.DictWriter(trades_csv, keys)
trades_csv_writer.writeheader()
trades_csv_writer.writerows(self.trades)
self.logger.info("Trade Status exported to file {fn}".format(fn=ofile))
class WekanCardReader:
def __init__(self, board_slug, mh, mp, mdb):
self.mongo_host = mh
self.mongo_port = mp
self.db_name = mdb
self.client = MongoClient(self.mongo_host, self.mongo_port)
self.db = self.client[self.db_name]
self.customfields = {}
self.l1_customfields = {}
board_id = self.db["boards"].find_one({"slug": board_slug})["_id"]
self.board_id = board_id
self.lists = None
self.labels = None
self.raw_object = None
self.logger = GPMLogger(board_slug).get_logger()
def load_custom_fields(self):
"""
Get Level 1 custom fields
"""
customfields = self.db.customFields
all_fields = list(
customfields.find({"boardIds": self.board_id}, {
"_id": 1,
"name": 1,
"type": 1
}))
self.customfields = {
field["_id"]: field["name"]
for field in all_fields
}
for cfield in all_fields:
if cfield["type"] == "dropdown":
l1cf = self.db.customFields.find_one({"_id": cfield["_id"]})
l1cfri = l1cf["settings"]["dropdownItems"]
l1cfmi = self.__map_id_val(l1cfri, "name")
self.l1_customfields[cfield["_id"]] = l1cfmi
def __map_id_val(self, data, value_key):
mapped_data = {}
for field in data:
try:
mapped_data[field["_id"]] = field[value_key]
except KeyError as ke:
self.logger.debug("FAILED - {msg}".format(msg=ke))
return mapped_data
def __load_dropdown_items(self, field_name):
field_items = {}
customfields = self.db.customFields
dropdown_items = customfields.find_one({"name": field_name},
{"settings.dropdownItems": 1})
field_items = dropdown_items["settings"]["dropdownItems"]
return field_items
def load_labels(self):
"""
Load Labels for a Board
"""
field_name = "Labels"
no_of_items = -1
try:
board = self.db.boards.find_one({"_id": self.board_id})
raw_items = board["labels"]
self.labels = self.__map_id_val(raw_items, "name")
no_of_items = len(self.labels)
if no_of_items > 0:
self.logger.success(
"Loading {fn} : SUCCESS - {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.info(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_lists(self):
"""
Load Lists in the board
"""
field_name = "Board Lists"
no_of_items = -1
try:
raw_items = self.db.lists.find({"boardId": self.board_id})
self.board_lists = self.__map_id_val(raw_items, "title")
no_of_items = len(self.board_lists)
if no_of_items > 0:
self.logger.success(
"Loading {fn} : SUCCESS - {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.success(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_card_activities(self):
query_field = {
"$and": [
{
"boardId": self.board_id
},
{
"activityType": {
"$in": ["createCard", "moveCard"]
}
},
{
"listId": {
"$in": list(self.board_lists.keys())
}
},
]
}
filter_fields = {
"listId": 1,
"listName": 1,
"cardId": 1,
"modifiedAt": 1,
"createdAt": 1,
}
moved_cards = self.db["activities"].find(query_field, filter_fields)
# Map Card movement to titles
self.mapped_moved_cards = {}
for card in moved_cards:
try:
self.mapped_moved_cards[card["cardId"]][
card["listId"]] = card["modifiedAt"]
except KeyError as ke:
if card["cardId"] == ke.args[0]:
self.mapped_moved_cards[card["cardId"]] = {}
self.mapped_moved_cards[card["cardId"]][
card["listId"]] = card["modifiedAt"]
else:
pass
"""
try:
self.mapped_moved_cards[card["cardId"]][
self.board_lists[card["listId"]]
] = card["modifiedAt"]
except KeyError as ke:
self.mapped_moved_cards[card["cardId"]] = {}
self.mapped_moved_cards[card["cardId"]][
self.board_lists[card["listId"]]
] = card["modifiedAt"]
"""
def load_cards(self):
self.load_custom_fields()
self.load_lists()
self.load_labels()
self.load_card_activities()
self.__build_raw_object()
def __build_raw_object(self):
raw_object = {}
for field_id in self.customfields.keys():
raw_object[field_id] = ""
# for field_id in self.l1_customfields.keys():
# raw_object[field_id] = ""
for field_id in self.board_lists.keys():
raw_object[field_id] = ""
self.raw_object = raw_object
class ComplianceCardReader(WekanCardReader):
def __init__(self, board_slug, mh, mp, mdb):
self.trades = []
self.locations = {}
self.logger = GPMLogger("compliance_reader").get_logger()
self.pattern = re.compile("(?P<client>\d+)\s(?P<detail>.*)")
self.raw_trades = []
self.trades = []
self.xform_trades = []
self.csv_card_mapping = {
"Title": "title",
"Created": "createdAt",
"Labels": "labelIds",
"For Review": "For Review",
"For Client Contact": "For Client Contact",
"For Compliance Officer Clearing":
"For Compliance Officer Clearing",
"Compliance Officer Cleared": "Compliance Officer Cleared",
}
self.trade_obj = {k: "" for k in self.csv_card_mapping.keys()}
WekanCardReader.__init__(self, board_slug, mh, mp, mdb)
def get_trade_object(self):
trade = {k: "" for k in self.csv_card_mapping.keys()}
return trade
def load_raw_trades(self):
cards = self.db["cards"].find({
"boardId": self.board_id,
"archived": False
})
for card in cards:
try:
raw_trade = deepcopy(self.raw_object)
match_result = self.pattern.match(card["title"])
if match_result:
raw_trade["id"] = card["_id"]
for field in card["customFields"]:
try:
raw_trade[field["_id"]] = field["value"]
except KeyError as ke:
raw_trade[field["_id"]] = ""
try:
raw_trade["labelIds"] = card["labelIds"]
except KeyError as ke:
raw_trade["labelIds"] = []
raw_trade["createdAt"] = card["createdAt"]
raw_trade["title"] = card["title"]
matched_dict = match_result.groupdict()
# raw_trade["Client"] = matched_dict["clieint"]
# raw_trade["Detail"] = matched_dict["detail"]
self.raw_trades.append(raw_trade)
except KeyError as ke:
self.logger.debug(ke)
except Exception as ex:
self.logger.debug(ex)
no_of_raw_trade = len(self.raw_trades)
self.logger.info(
"Total {} raw compliance records found".format(no_of_raw_trade))
def transform_raw_trade(self, trade):
"""
level 0 : Value of the key is actual valie
level 1 : Value of the key maps to other dictrionary. One more lookup
Assign values to fields based on if its level 0/1 custom field
"""
xtrade = deepcopy(trade)
l1cfkeys = list(self.l1_customfields.keys())
for fid, fval in trade.items():
if self.l1_customfields:
try:
if fid in l1cfkeys:
xtrade[self.customfields[fid]] = self.l1_customfields[
fid][fval]
else:
xtrade[self.customfields[fid]] = fval
except KeyError as ke:
# self.logger.debug(ke)
pass
except Exception as ex:
self.logger.debug(ex)
xtrade["createdAt"] = trade["createdAt"].strftime("%d/%m/%Y")
try:
for blk, blv in self.mapped_moved_cards[xtrade["id"]].items():
try:
xtrade[self.board_lists[blk]] = blv.strftime("%d/%m/%Y")
except KeyError as ke:
pass
except KeyError as ke:
pass
return xtrade
def transform_raw_trades(self):
self.xform_trades = [
self.transform_raw_trade(trade) for trade in self.raw_trades
]
def load_trades(self):
cards = self.db["cards"].find({"boardId": self.board_id})
trades = []
for raw_trade in self.xform_trades:
try:
trade = self.get_trade_object()
for (csv_field, card_field) in self.csv_card_mapping.items():
try:
trade[csv_field] = raw_trade[card_field]
except KeyError as ke:
trade[csv_field] = ""
pass
card_labels = [
self.labels[lid] for lid in raw_trade["labelIds"]
]
csv_labels = " | "
csv_labels = csv_labels.join(card_labels)
trade["Labels"] = csv_labels
# Replace level 2 mapping
trades.append(trade)
except KeyError as ke:
self.logger.debug(ex)
except Exception as ex:
self.logger.debug(ex)
no_of_qurated_trade = len(trades)
self.logger.info(
"Total {} compliance cards qurated".format(no_of_qurated_trade))
self.trades = trades
def export_trades(self, ofile):
keys = self.csv_card_mapping.keys()
with open(ofile, "w") as trades_csv:
trades_csv_writer = csv.DictWriter(trades_csv, keys)
trades_csv_writer.writeheader()
trades_csv_writer.writerows(self.trades)
self.logger.info(
"Compliance Status exported to file {fn}".format(fn=ofile))
class TradeCardReader:
def __init__(self, board_slug, mh, mp, mdb):
self.logger = GPMLogger("card_reader").get_logger()
self.mongo_host = mh
self.mongo_port = mp
self.db_name = mdb
self.client = MongoClient(self.mongo_host, self.mongo_port)
self.db = self.client[self.db_name]
self.customfields = {}
self.trades = []
self.locations = {}
board_id = self.db["boards"].find_one({"slug": board_slug})["_id"]
self.board_id = board_id
self.pattern = re.compile("(?P<client>\d+)\s-\s(?P<otype>.*)")
self.csv_card_mapping = {
"Trade Date": "A Trade Date",
"Delivery Date": "B Delivery Date",
"Client Number": "Client",
"Document No": "M Document No.",
"Location": "E Location",
"Transaction Type": "C Transaction Type",
"Metal": "L Metal",
"Order Type": "D Order Type",
"Order Detail": "H Bars Composition",
"Premium (%)": "G Transaction Premium (%)",
"Referral": "I Referral",
"Pricing Method": "F Pricing Option",
"Remarks+": "J Remarks",
"Labels": "labelIds",
"Things To Do": "Things To Do",
"Operations Team Action": "Operations Team Action",
"BD/CR Action Needed": "BD/CR Action Needed",
"Completed Trades": "Completed Trades",
}
self.trade_obj = {k: "" for k in self.csv_card_mapping.keys()}
def load_level1_custom_fields(self):
"""
Get Level 1 custom fields
"""
customfields = self.db.customFields
all_fields = list(customfields.find({}, {"_id": 1, "name": 1}))
self.customfields = {
field["_id"]: field["name"]
for field in all_fields
}
def __map_id_val(self, data, value_key):
mapped_data = {}
mapped_data = {field["_id"]: field[value_key] for field in data}
return mapped_data
def __load_dropdown_items(self, field_name):
field_items = {}
customfields = self.db.customFields
dropdown_items = customfields.find_one({"name": field_name},
{"settings.dropdownItems": 1})
field_items = dropdown_items["settings"]["dropdownItems"]
return field_items
def load_locations(self):
"""
Load Locations
"""
field_name = "Location"
no_of_items = -1
try:
customfields = self.db.customFields
location_items = customfields.find_one(
{"name": "E Location"}, {"settings.dropdownItems": 1})
raw_locations = location_items["settings"]["dropdownItems"]
self.locations = self.__map_id_val(raw_locations, "name")
no_of_items = len(self.locations)
if no_of_items > 0:
self.logger.success(
"Loading {fn} : SUCCESS - {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.info(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_transaction_type(self):
"""
Load Transaction Type
"""
field_name = "Transcation Type"
no_of_items = -1
try:
raw_items = self.__load_dropdown_items("C Transaction Type")
self.txn_types = self.__map_id_val(raw_items, "name")
no_of_items = len(self.txn_types)
if no_of_items > 0:
self.logger.success("Loading {fn} : {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.success(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_order_type(self):
"""
Load Order Type
"""
field_name = "Order Type"
no_of_items = -1
try:
raw_items = self.__load_dropdown_items("D Order Type")
self.order_types = self.__map_id_val(raw_items, "name")
no_of_items = len(self.order_types)
if no_of_items > 0:
self.logger.success("Loading {fn} : {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.info("Loading {fn} : No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_pricing_options(self):
"""
Load Pricing Options
"""
field_name = "Pricing Option"
no_of_items = -1
try:
raw_items = self.__load_dropdown_items("F Pricing Option")
self.pricing_options = self.__map_id_val(raw_items, "name")
no_of_items = len(self.pricing_options)
if no_of_items > 0:
self.logger.success("Loading {fn} : {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.success(
"Loading {fn} : No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_metal_types(self):
"""
Load Metal type
"""
field_name = "Metal"
no_of_items = -1
try:
raw_items = self.__load_dropdown_items("L Metal")
self.metal_types = self.__map_id_val(raw_items, "name")
no_of_items = len(self.metal_types)
if no_of_items > 0:
self.logger.success("Loading {fn} : {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.success(
"Loading {fn} : No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_labels(self):
"""
Load Labels for a Board
"""
field_name = "Labels"
no_of_items = -1
try:
board = self.db.boards.find_one({"_id": self.board_id})
raw_items = board["labels"]
self.labels = self.__map_id_val(raw_items, "name")
no_of_items = len(self.labels)
if no_of_items > 0:
self.logger.success(
"Loading {fn} : SUCCESS - {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.info(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def load_lists(self):
"""
Load Lists in the board
"""
field_name = "Board Lists"
no_of_items = -1
try:
raw_items = self.db.lists.find({"boardId": self.board_id})
self.board_lists = self.__map_id_val(raw_items, "title")
no_of_items = len(self.board_lists)
if no_of_items > 0:
self.logger.success(
"Loading {fn} : SUCCESS - {cnt} {fn} loaded".format(
fn=field_name, cnt=no_of_items))
elif no_of_items == 0:
self.logger.success(
"Loading {fn} : SUCCESS - No {fn}. {cnt} {fn}".format(
fn=field_name, cnt=no_of_items))
else:
self.logger.info(
"Loading {fn} : FAILED - Could not load {fn}".format(
fn=field_name))
except KeyError as ke:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ke))
except Exception as ex:
self.logger.debug("Loading {fn} : FAILED - {msg}".format(
fn=field_name, msg=ex))
return no_of_items
def get_moved_cards(self):
query_field = {
"$and": [
{
"boardId": self.board_id
},
{
"activityType": {
"$in": ["createCard", "moveCard"]
}
},
{
"listId": {
"$in": list(self.board_lists.keys())
}
},
]
}
filter_fields = {
"listId": 1,
"listName": 1,
"cardId": 1,
"modifiedAt": 1,
"createdAt": 1,
}
moved_cards = self.db["activities"].find(query_field, filter_fields)
# Map Card movement to titles
self.mapped_moved_cards = {}
for card in moved_cards:
try:
self.mapped_moved_cards[card["cardId"]][self.board_lists[
card["listId"]]] = card["modifiedAt"]
except KeyError as ke:
self.mapped_moved_cards[card["cardId"]] = {}
self.mapped_moved_cards[card["cardId"]][self.board_lists[
card["listId"]]] = card["modifiedAt"]
def get_trade_object(self):
trade = {
"Trade Date": "",
"Delivery Date": "",
"Client Number": "",
"Document No": "",
"Location": "",
"Transaction Type": "",
"Metal": "",
"Order Type": "",
"Order Detail": "",
"Premium (%)": "",
"Referral": "",
"Pricing Method": "",
"Remarks+": "",
"Labels": "",
"Things To Do": "",
"Operations Team Action": "",
"BD/CR Action Needed": "",
"Completed Trades": "",
}
return trade
def get_trades_for_board(self):
cards = self.db["cards"].find({
"boardId": self.board_id,
"archived": False
})
raw_trades = []
for card in cards:
try:
raw_trade = {}
match_result = self.pattern.match(card["title"])
if match_result:
raw_trade["id"] = card["_id"]
for field in card["customFields"]:
try:
raw_trade[self.customfields[
field["_id"]]] = field["value"]
except KeyError as ke:
raw_trade[self.customfields[field["_id"]]] = ""
try:
raw_trade["labelIds"] = card["labelIds"]
except KeyError as ke:
raw_trade["labelIds"] = []
matched_dict = match_result.groupdict()
raw_trade["Client"] = matched_dict["client"]
raw_trade["Things To Do"] = ""
raw_trade["Operations Team Action"] = ""
raw_trade["BD/CR Action Needed"] = ""
raw_trade["Completed Trades"] = ""
raw_trades.append(raw_trade)
except KeyError as ke:
# print ("KeyError ", ke)
pass
except Exception as ex:
# print ("Error ", ex)
pass
no_of_raw_trade = len(raw_trades)
self.logger.info("Total {} raw trades found".format(no_of_raw_trade))
trades = []
for raw_trade in raw_trades:
try:
trade = self.get_trade_object()
for (csv_field, card_field) in self.csv_card_mapping.items():
try:
trade[csv_field] = raw_trade[card_field]
except KeyError as ke:
pass
# Replace level 2 mapping
trade["Location"] = (self.locations[trade["Location"]]
if trade["Location"] else "")
trade["Transaction Type"] = (
self.txn_types[trade["Transaction Type"]]
if trade["Transaction Type"] else "")
trade["Order Type"] = (self.order_types[trade["Order Type"]]
if trade["Order Type"] else "")
trade["Pricing Method"] = (
self.pricing_options[trade["Pricing Method"]]
if trade["Pricing Method"] else "")
trade["Metal"] = (self.metal_types[trade["Metal"]]
if trade["Metal"] else "")
try:
card_move_lists = self.mapped_moved_cards[raw_trade["id"]]
except KeyError as ke:
print(ke)
try:
trade["Things To Do"] = card_move_lists[
"Things To Do"].strftime("%d/%m/%Y")
except KeyError as ke:
trade["Things To Do"] = ""
try:
trade["Operations Team Action"] = card_move_lists[
"Operations Team Action"].strftime("%d/%m/%Y")
except KeyError as ke:
trade["Operations Team Action"] = ""
try:
trade["BD/CR Action Needed"] = card_move_lists[
"BD/CR Action Needed"].strftime("%d/%m/%Y")
except KeyError as ke:
trade["BD/CR Action Needed"] = ""
try:
trade["Completed Trades"] = card_move_lists[
"Completed Trades"].strftime("%d/%m/%Y")
except KeyError as ke:
trade["Completed Trades"] = ""
# Formatting
trade["Trade Date"] = (trade["Trade Date"].strftime("%d/%m/%Y")
if trade["Trade Date"] else "")
trade["Delivery Date"] = (
trade["Delivery Date"].strftime("%d/%m/%Y")
if trade["Delivery Date"] else "")
card_labels = [self.labels[lid] for lid in trade["Labels"]]
card_labels = [self.labels[lid] for lid in trade["Labels"]]
csv_labels = " | "
csv_labels = csv_labels.join(card_labels)
trade["Labels"] = csv_labels
trades.append(trade)
except KeyError as ke:
pass
except Exception as ex:
pass
no_of_qurated_trade = len(trades)
self.logger.info(
"Total {} qurated trades found".format(no_of_qurated_trade))
self.trades = trades
def export_trades(self, ofile):
keys = self.trades[0].keys()
with open(ofile, "w") as trades_csv:
trades_csv_writer = csv.DictWriter(trades_csv, keys)
trades_csv_writer.writeheader()
trades_csv_writer.writerows(self.trades)
self.logger.info("Trade Status exported to file {fn}".format(fn=ofile))