def pul_id_prt_no(pul_id):
sql_exp = f'SELECT prt_no ' \
f'FROM purchase_order_line ' \
f'WHERE pul_id = {pul_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
prt_no = scalar_data(result_set)
return prt_no
def puh_no_puh_reference(puh_no):
sql_exp = f"SELECT puh_reference " \
f"FROM purchase_order_header " \
f"WHERE puh_no = {puh_no}"
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
puh_reference = scalar_data(result_set)
return puh_reference
def plq_id_cli_no(plq_id):
sql_exp = f'SELECT cli_no FROM planning_lot_quantity ' \
f'JOIN order_line USING(orl_id) ' \
f'JOIN order_header USING(ord_id) ' \
f'JOIN client USING(cli_id) ' \
f'WHERE plq_id = {plq_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
cli_no = scalar_data(result_set)
return cli_no
def cli_id_cli_name1(cli_id):
sql_exp = f'SELECT cli_name1 FROM client WHERE cli_id = {cli_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
cli_name1 = scalar_data(result_set)
return cli_name1
def orl_id_ord_no(orl_id):
sql_exp = f'SELECT ord_no FROM order_line WHERE orl_id = {orl_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
ord_no = scalar_data(result_set)
return ord_no
def puh_no_usr_no(puh_no):
sql_exp = f'SELECT usr_no FROM purchase_order_header WHERE puh_no = {puh_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
usr_no = scalar_data(result_set)
return usr_no
def puh_no_sup_name1(puh_no):
sql_exp = f'SELECT sup_name1 FROM purchase_order_header JOIN supplier USING(sup_id) WHERE puh_no = {puh_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
sup_name1 = scalar_data(result_set)
return sup_name1
def plq_id_plq_qty_per(plq_id):
sql_exp = f'SELECT (plq_qty_per)::INT FROM planning_lot_quantity WHERE plq_id = {plq_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
plq_qty_per = scalar_data(result_set)
return plq_qty_per
def transaction_ptn_desc(ptn_id):
sql_exp = f'SELECT ptn_desc FROM part_transaction WHERE ptn_id = {ptn_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
ptn_desc = scalar_data(result_set)
return ptn_desc
def get_sup_name1(sup_id):
sql_exp = f"SELECT sup_name1 FROM supplier WHERE sup_id = {sup_id}"
log(sql_exp)
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
return scalar_data(result_set)
def ord_no_cli_no(ord_no):
sql_exp = f'SELECT cli_no FROM order_header JOIN client USING(cli_id) WHERE ord_no = {ord_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
cli_no = scalar_data(result_set)
return cli_no
def orl_id_prt_desc(orl_id):
sql_exp = f'SELECT trim(prt_desc) FROM order_line WHERE orl_id = {orl_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
prt_desc = scalar_data(result_set)
return prt_desc
def orl_id_orl_qty_ready(orl_id):
sql_exp = f'SELECT (orl_qty_ready)::INT FROM order_line WHERE orl_id = {orl_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
orl_qty_ready = scalar_data(result_set)
return orl_qty_ready
def orl_id_plq_note(orl_id):
sql_exp = f'SELECT trim(plq_note) FROM planning_lot_quantity WHERE orl_id = {orl_id}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
plq_note = scalar_data(result_set)
return plq_note
def invoice_ord_no(inv_no):
sql_exp = f'SELECT ord_no FROM invoicing WHERE inv_no = {inv_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
ord_no = scalar_data(result_set)
return ord_no
def ord_no_cli_id(ord_no):
sql_exp = f'SELECT cli_id FROM order_header WHERE ord_no = {ord_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
cli_id = scalar_data(result_set)
return cli_id
def empty_query_test():
sql_exp = r"SELECT prt_no FROM part WHERE prt_no = 'F191S'"
log(sql_exp)
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
plimp_lines = scalar_data(result_set)
return plimp_lines
def planning_lot_prt_no(plq_lot_no):
sql_exp = f'SELECT prt_no FROM planning_lot_quantity WHERE plq_lot_no = {plq_lot_no}'
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
prt_no = scalar_data(result_set)
return prt_no
def get_company_report_dir():
sql_exp = 'SELECT cie_report_path FROM company_config'
log(sql_exp)
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
company_report_dir = scalar_data(result_set)
return company_report_dir
def orl_id_prt_no(config, orl_id):
sql_exp = f'SELECT prt_no FROM order_line WHERE orl_id = {orl_id}'
result_set = sql_query(sql_exp, config.sigm_db_cursor)
prt_no = scalar_data(result_set)
return prt_no
def prt_no_prt_desc(prt_no):
sql_exp = f'SELECT trim(prt_desc2) FROM part WHERE prt_no = \'{prt_no}\''
result_set = sql_query(sql_exp, c.config.sigm_db_cursor)
prt_desc1 = scalar_data(result_set)
return prt_desc1
