#!/usr/bin/env python
"""
new_achat_regle.py dbhost dbname dbuser dbpwd fournisseur no_facture description montant_ht montant_ttc
"""
#import globals
try:
	import psycopg
except:
	import psycopg2 as psycopg
import sys
				
if __name__ == '__main__':
	if len(sys.argv) != 10:
		print __doc__
		sys.exit(2)
	(foo, dbhost, dbname, dbuser, dbpwd, fournisseur, no_facture, description, montant_ht, montant_ttc) = sys.argv
	con = psycopg.connect("dbname=%s user=%s password=%s host=%s" % (dbname, dbuser, dbpwd, dbhost))
	#con.autocommit()	
	curs = con.cursor()
	curs.execute("select no_facture from achat where no_facture='%s'" % no_facture)
	if curs.rowcount != 0:
		sys.exit(1)
	curs.execute("BEGIN")
	
	curs.execute(
		"INSERT INTO achat (codecrea,ref_statut,ref_devise,ref_view_mes_societes,ref_view_fournisseur,description,no_facture,montant_ht,montant,reception) (select 'insert_achat_pg.sh',1,617,47,view_fournisseur.uid,'%s','%s',%s,%s,now() from view_fournisseur where view_fournisseur.nom='%s')" \
		% (description,no_facture,montant_ht,montant_ttc,fournisseur)
		)
	curs.execute("INSERT into reglement (codecrea,ref_statut,ref_devise,montant,numero_cheque) values ('insert_achat_pg.sh',1,617,%s,'%s')" % (montant_ttc, no_facture))
	curs.execute("INSERT into reglement_achat (codecrea,ref_statut,montant,ref_reglement,ref_achat) (select 'insert_achat_pg.sh',1,%s,reglement.uid,achat.uid from reglement,achat where reglement.numero_cheque='%s' and reglement.ref_statut=1 and achat.no_facture='%s' and achat.ref_statut=1)" % (montant_ttc,no_facture,no_facture))
	curs.execute("END")