def gethsnopdata( request ): print( "qx/views/gethsnopdata() %s %s" % ( request.scheme, request.method ) ) if request.method == "GET": REQUEST = request.GET else: REQUEST = request.POST # op_number = request.POST.get( "op_num" ) op_number = REQUEST.get( "op_num" ) op_err_str = "" op_info_list = get_op_info( op_number ) if len( op_info_list ) == 0: op_err_str = "Geen OP gevonden voor OP-nummer %s" % op_number op_isvalid = False else: op_isvalid = True print( "op_isvalid: ", op_isvalid ) for op_info_dict in op_info_list: print( "op_info_dict:", op_info_dict ) marriages = {} missing_data = {} hsnmanage = { "statustekst" : "" } partners = {} mails = {} deaths = {} if op_isvalid: marriages = get_marriages( op_number ) print( "marriages: ", marriages ) missing_data = get_missing( op_number ) print( "missing data: ", missing_data ) hsnmanage = get_hsnmanage( op_number ) print( "hsnmanage: ", hsnmanage ) partners = get_partners( op_number ) print( "partners: ", partners ) mails = get_mails( op_number ) print( "mails: ", mails ) deaths = get_deaths( op_number ) print( "deaths: ", deaths ) # sometimes the death location is not [yet] present in the HsnBeheer table, # but we [sometimes] can display it from the Ovlknd table if hsnmanage.get( "ovlplaats" ) == "": for death in deaths: if death.get( "table_name" ) == "Ovlknd": hsnmanage[ "ovlplaats" ] = death.get( "death_location" ) OP = \ { "op_num" : op_number, "op_err_str" : op_err_str, "op_info_list" : op_info_list, "hsnmanage" : hsnmanage, "marriages" : marriages, "missing_data" : missing_data, "partners" : partners, "mails" : mails, "deaths" : deaths } dictionary = \ { "op_isvalid" : op_isvalid, "OP" : OP } """ # scheme_authority, sub_site = get_server_info( request ) template = "index.html" dictionary = \ { # 'SUB_SITE' : sub_site, # 'STATIC_PREFIX' : scheme_authority, 'STATIC_PREFIX' : '', # 'STATIC_URL' : settings.STATIC_URL, # 'STATIC_URL' : '127.0.0.1', 'STATIC_URL' : '/', } context = RequestContext( request ) # json_data = json.dumps( dictionary ) # content_type = "application/json; charset=UTF-8" # return HttpResponse( json_data, content_type ) # return render_to_response( template, dictionary, context ) # return render( json_data, content_type, context ) """ return JsonResponse( dictionary )
def print_mailbev(): if debug: print( "mail/print/print_mailbev(" ) # notice, no cups.py, but just a .cups.so #print( os.path.abspath( cups.__file__ ) ) # .../python2710/lib/python2.7/site-packages/cups.so ids = [] try: from qx.views import none2empty ret_status = "OK" msg = "" # mail_qs = Mail.objects.using( "mail" ).filter( status = 0, type = "BEV" ).order_by( "provnr", "archiefnaam", "id" ) # "provnr" not in Mail table # mail_qs = Mail.objects.using( "mail" ).filter( status = 0, type = "BEV" ).order_by( "archiefnaam", "id" ) # "archiefnaam" not in Mail table mail_qs = Mail.objects.using( "mail" ).filter( status = 0, type = "BEV" ).order_by( "gemnr", "id" ) if mail_qs is None: msg = "Mail does not contain entries with status = 0" if debug: print( msg ) else: nmails_bev = mail_qs.count() if debug: print( "Number of mails with status = 0:", nmails_bev ) for mail in mail_qs: if debug: print( mail ) id = str( mail.id ) ids.append( id ) opsex = none2empty( get_opsex( mail.idnr ) ) mailtype = none2empty( get_mailtype( mail.idnr ) ) if debug: print( "opsex:", opsex, ", mailtype:", mailtype ) archive = none2empty( get_archive( mail.gemnr ) ) if debug: print( "archive:", archive ) info_list = none2empty( get_op_info( mail.idnr ) ) if debug: print( "info_list:", info_list ) pathname_psfile = get_pathname_psfile( mail.gemnr, id ) OP = { "info_list" : info_list, "mailtype" : mailtype, "idnr" : str( mail.idnr ), "kind" : none2empty( mail.aard ), "gemnr" : mail.gemnr, "archive" : archive, "datum" : none2empty( mail.datum ), "periode" : none2empty( mail.periode ), "naamgem" : none2empty( mail.naamgem ), "opmerk" : none2empty( mail.opmerk ), "opsex" : opsex, "opident" : none2empty( mail.opident ), "oppartner" : none2empty( mail.oppartner ), "opvader" : none2empty( mail.opvader ), "opmoeder" : none2empty( mail.opmoeder ), "infoouders" : none2empty( mail.infoouders ), "infopartner" : none2empty( mail.infopartner ), "inforeis" : none2empty( mail.inforeis ) } create_ps_letter( pathname_psfile, OP ) try: MAIL_SENT_TO_PRINTER = settings.MAIL_SENT_TO_PRINTER except: MAIL_SENT_TO_PRINTER = MAIL_SENT_TO_PRINTER_DEFAULT if MAIL_SENT_TO_PRINTER: ret_status, msg = print_ps_letter( id, pathname_psfile ) try: MAIL_UPDATE_TABLE = settings.MAIL_UPDATE_TABLE except: MAIL_UPDATE_TABLE = MAIL_UPDATE_TABLE_DEFAULT if ret_status == "OK" and MAIL_UPDATE_TABLE: update_status_date( id ) # break # test: create/print only 1 letter except: ret_status = "ERROR" print( "print_mailbev()" ) type, value, tb = exc_info() msg = "Mail.objects.filter failed: %s" % value print( "%s\n" % msg ) return ret_status, msg, ids