def table_json(request):
    if request.POST :
        evs = json.loads(request.POST.get('evs', None))
        magazinu = request.GET.get('magazinul')
        nume = []
        persoane_query = Persoana.objects.filter(magazin=magazinu,functia=1) | Persoana.objects.filter(magazin=magazinu,functia=3) | Persoana.objects.filter(magazin=magazinu,functia=2)
        for persoana in persoane_query:
            table_json = {}
            nume_s = persoana.nume
            prenume = persoana.prenume
            marca = str(persoana.marca)
            nume_i = nume_s + " " + prenume + " (" + marca + ")"
            table_json["nume"] = nume_i
            table_json["zile_angajare"] = 0
            table_json["zile_libere_pontate"] = 0
            table_json["zile_fara_contract"] = 0
            table_json['zile_lucrate'] = 0
            table_json['zile_delegatii'] = 0
            table_json['nr_tichete'] = 0
            table_json['ore_suplimentare'] = 0
            table_json['ore_weekend'] = 0
            table_json['ore_noapte'] = 0
            table_json['ore_sarbatori_legale'] = 0
            table_json['zile_co'] = 0
            table_json['zile_cm'] = 0
            table_json['zile_absente_nemotivate'] = 0
            table_json['zile_cfp'] = 0
            table_json['zile_CD'] = 0
            table_json['zile_CIC'] = 0
            table_json['zile_CICH'] = 0
            table_json['zile_evenimente'] = 0
            table_json['zile_libere_platite'] = 0
            nume.append(table_json)
        for ev in evs:
            id_event = ev["id"]
            event = Pontaj_final.objects.get(id=id_event)
            per = Persoana.objects.get(id=event.persoana.id)
            # print(event.persoana.id)
            nume_s = per.nume
            prenume = per.prenume
            marca = str(per.marca)
            nume_i = nume_s + " " + prenume + " (" + marca + ")"
            for i in range(0,len(nume)-1):
                if nume_i == nume[i]["nume"]:
                    ore_suplimentare = event.ore_suplimentare
                    total_ore = 0
                    ore_suplimentare = event.ore_suplimentare
                    total_ore += ore_suplimentare
                    if event.tip_pontare == "X":
                        delta = (event.data_sfr - event.data_inc).days
                    else:
                        delta = 0
                    if event.data_inc.month == event.data_sfr.month and event.data_inc.year == event.data_sfr.year:
                        if event.tip_pontare == "CIC":
                            nr_zile_cic = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_CIC"] += nr_zile_cic
                        elif event.tip_pontare == "CICH":
                            nr_zile_cich = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_CICH"] += nr_zile_cich
                        elif event.tip_pontare == "CFP":
                            nr_zile_cfp = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_cfp"] += nr_zile_cfp
                        elif event.tip_pontare == "CM":
                            nr_zile_cm = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_cm"] += nr_zile_cm
                        elif event.tip_pontare == "ZL":
                            nr_zile_libere_platit = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_libere_platite"] += nr_zile_libere_platit
                        elif event.tip_pontare == "E":
                            nr_zile_libere = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_evenimente"] += nr_zile_libere
                        elif event.tip_pontare == "N":
                            nr_zile_nemotivate = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_absente_nemotivate"] += nr_zile_nemotivate
                        elif event.tip_pontare == "CO":
                            nr_zile_co = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_co"] += nr_zile_co
                        elif event.tip_pontare == "X":
                            nr_zile_fcontract = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_fara_contract"] += nr_zile_fcontract
                        elif event.tip_pontare == "L":
                            nr_zile_libere_pontate = (event.data_sfr - event.data_inc).days
                            nume[i]["zile_libere_pontate"] += nr_zile_libere_pontate
                        elif int(event.tip_pontare) is not None:
                            nume[i]["zile_lucrate"] += 1
                            nume[i]["nr_tichete"] +=1
                    else:
                        if event.tip_pontare == "CIC":
                            prima_zi = event.data_sfr.replace(day=1)
                            nr_zile_cic = (event.data_sfr - prima_zi).days + 1
                            nume[i]["zile_CIC"] += nr_zile_cic
                        elif event.tip_pontare == "CICH":
                            prima_zi = event.data_sfr.replace(day=1)
                            nr_zile_cich = (event.data_sfr - prima_zi).days + 1
                            nume[i]["zile_CIC"] += nr_zile_cich
                        elif event.tip_pontare == "CFP":
                            prima_zi = event.data_sfr.replace(day=1)
                            nr_zile_cfp = (event.data_sfr - prima_zi).days + 1
                            nume[i]["zile_cfp"] += nr_zile_cfp
                    nume[i]["ore_suplimentare"] += ore_suplimentare

                    # print(total_ore)
        print(nume)
    return render(request, 'pep/foaia_colectiva.html',{"events": nume})