import sys
from argparse import ArgumentParser
from configparser import ConfigParser
from subprocess import call
import pandas


def run(cmd):
    print(' '.join(cmd))
    ok = call(cmd)
    if ok != 0:
        sys.exit()


help_file = 'File Excel'

pars = ArgumentParser()
pars.add_argument('--file', help=help_file)
option = pars.parse_args(sys.argv[1:])

bin_inquiry = '/home/h2h/pbb/env/bin/pbb_inquiry'
conf_files = ['/home/h2h/pbb/query.ini', '/home/h2h/pbb/oracle.ini']

xf = pandas.ExcelFile(option.file)
sheet = xf.sheet_names[0]
d = xf.parse(sheet)
for row in d.values:
    invoice_id = row[0]
    if isinstance(invoice_id, str):
        invoice_id = invoice_id.replace('.', '').replace('-', '').\
                replace(' ', '')
        for conf_file in conf_files:
            cmd = [
                    bin_inquiry, conf_file, '--invoice-id=' + invoice_id,
                    '--reversal']
            run(cmd)