Exemple #1
0
def lst_tco_parametres(request,tco_id):
   section = 'tco'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_parametres_lst.html');
   
   lst_tco_parametres = Parametre.objects.filter(tco=tco_id)
   cfg = template_config(request)
   
   cfg.current_url = '/tco/'
   cfg.section = section

   variables = RequestContext(  request,
     {
        'lst_tco_parametres' : lst_tco_parametres,
        'cfg': cfg,
        'tco_id':tco_id
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output)  
Exemple #2
0
def view_changepassword(request):
   section = 'profil'
    
   response = before_execute_view(request)
   if not response == True:
        return response
    
   template = get_template('pages/profil/changepassword.html');
   cfg = template_config(request)
   cfg.section = section
   
   success = 0
   
   if request.method == 'POST':
        user = User.objects.get(pk=request.user.id)
        success = 1
        password =  request.REQUEST['password']
        user.set_password(password)
        user.save()
   
   variables = RequestContext( request,
     {
        'cfg': cfg,
        'success': success
     }                  
   )
   
   output = template.render(variables);
   return HttpResponse(output)
Exemple #3
0
def lst_tco(request):
    
   section = 'tco'
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
    
   template = get_template('pages/tco/tco_lst.html');
   
   sql = "SELECT * FROM "+table_tco+" WHERE parent_tco_id = -1 ORDER BY niveau "
   lst_tco = list(Tco.objects.raw(sql))
   tree_lst_tco = lst_tco_build_list(lst_tco)
   
   cfg = template_config(request)
   
   cfg.current_url = '/tco/'
   cfg.section = section
   
   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'lst_tco' : lst_tco,
        'cfg': cfg,
        'list':list,
        'tree_lst_tco':tree_lst_tco
     }                  
                    
   )
   
   output = template.render(variables);
   
   return HttpResponse(output)  
Exemple #4
0
def main(request):
   section = 'accueil'
    
   response = before_execute_view(request)
   if not response == True:
        return response
    
   #user = User.objects.create_user('test_user', '*****@*****.**', '123456')
    
    #user = User.objects.filter(username='******')
    #user.is_superuser = True
   #user.save()
    
    
    
   #user = User.objects.get(username__exact='pgrimard')
   #user.is_superuser = True
   #user.save() 
   
   template = get_template('pages/default.html');
   cfg = template_config(request)
   cfg.section = section
   
   variables = RequestContext( request,
     {
        'cfg': cfg
     }                  
   )
   
   output = template.render(variables);
   return HttpResponse(output)
Exemple #5
0
def edit_scenario(request,scenario_id):
   section = 'scenario'
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/scenario_edit.html');
   
   scenario = Scenario.objects.get(pk=scenario_id)
   
   scenarioType = scenario.scenarioType
   
   cfg = template_config(request)
   
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_profil_url )
       
        form = ScenarioForm(request.POST)
        if form.is_valid():
            
            scenarioType = request.REQUEST['scenarioType']
            
            success = 1
            nom = form.cleaned_data['nom']
            description = form.cleaned_data['description']
            nombreOccurence = form.cleaned_data['nombreOccurence']
            documentation = form.cleaned_data['documentation']
            
            scenario.nom = nom
            scenario.nombreOccurence = nombreOccurence
            scenario.description = description
            scenario.documentation = documentation 
            scenario.scenarioType = scenarioType
            scenario.save()
            
        else:
            success = 0
   else:
        form = ScenarioForm(instance=scenario)

   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success,
        'scenarioType': scenarioType        
     }               
   )
   
   output = template.render(variables)
   return HttpResponse(output)   
Exemple #6
0
def edit_tco(request,idTco):
   section = 'tco'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_edit.html');
   
   tco = Tco.objects.get(pk=idTco)
   
   cfg = template_config(request)
   
   cfg.current_url = '/tco/'
   cfg.section = section
   success = 0
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco/')
       
        form = TcoForm(request.POST)
        if form.is_valid():
            success = 1
            titre = form.cleaned_data['titre']
            niveau = form.cleaned_data['niveau']
            description = form.cleaned_data['description']
            parent_tco_id = form.cleaned_data['parent_tco_id']
            documentation = form.cleaned_data['documentation']
            
            tco = Tco()
            tco.id = idTco
            tco.niveau = niveau
            tco.titre = titre
            tco.description = description
            tco.documentation = documentation
            tco.parent_tco_id = parent_tco_id
            
            tco.save()
            
        else:
            success = 0
   else:
        form = TcoForm(instance=tco)

   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success        
     }               
           
                    
   )
   
   
   output = template.render(variables)
   return HttpResponse(output)   
Exemple #7
0
def view_rights(request):
   section = 'profil'
    
   response = before_execute_view(request)
   if not response == True:
        return response
    
   template = get_template('pages/profil/rights.html');
   cfg = template_config(request)
   
   user_id = request.user.id
   user = User.objects.get(pk=user_id)
   perms= list(PermissionAdmin.objects.filter(user=user))
   
   if (len(perms) == 1):
        perm = perms[0]
   else:
        perm = PermissionAdmin()
   
   success = 0
   
   base_url = site_config('base_url')
   cfg.section = section
   data = { 
            'username': user.username ,
            'password' : user.password,
            'email': user.email ,
            'superuser': checkbox_good_value(user.is_superuser),
            'tco_right_read' : checkbox_good_value(perm.tco_right_read),
            'tco_right_write' : checkbox_good_value(perm.tco_right_write),
            'param_right_read' : checkbox_good_value(perm.param_right_read),
            'param_right_write' : checkbox_good_value(perm.param_right_write),
            'profil_right_read' : checkbox_good_value(perm.profil_right_read),
            'profil_right_write' : checkbox_good_value(perm.profil_right_write),
            'scenario_right_read' :checkbox_good_value(perm.scenario_right_read),
            'scenario_right_write' : checkbox_good_value(perm.scenario_right_write),
            'mesure_right_read' : checkbox_good_value(perm.mesure_right_read),
            'mesure_right_write' : checkbox_good_value(perm.mesure_right_write),
            'rapport_right_read' : checkbox_good_value(perm.rapport_right_read),
            
            }
   form = UserForm( initial=data )
   
   variables = RequestContext( request,
     {
        'cfg': cfg,
        'form' : form,
        'success' : success,
        'perm' : perm
     })
   
   output = template.render(variables);
   return HttpResponse(output) 
   
Exemple #8
0
def tco_parametres_edit(request,tco_id,parametre_id):
   section = 'parameter'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_parametres_edit.html');
   parametre = Parametre.objects.get(pk=parametre_id)
   cfg = template_config(request)
   
   cfg.current_url = '/tco/'
   cfg.section = 'tco'
   success = 0
   
   parametreType = parametre.parametreType
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco/' + tco_id + '/parameters')
        form = ParametreForm(request.POST)
        if form.is_valid():
            
            parametreType = request.REQUEST['parametreType']
            
            parametre = form.save(commit=False)
            parametre.tco = Tco.objects.get(pk=tco_id)
            parametre.id = parametre_id
            parametre.parametreType = parametreType
            parametre.save()
            
            success = 1
        else:
            success = 0
   else:
        form = ParametreForm(instance=parametre)

   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success,
        'tco_id': tco_id,
        'parametreType':parametreType      
     }               
           
                    
   )
   
   
   output = template.render(variables)
   return HttpResponse(output)    
Exemple #9
0
def add_profil(request,profil_id):
   section = 'profil'
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/profil_add.html');
   
   cfg = template_config(request)
   
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_profil_url )
        
        form = ProfilForm(request.POST)
        #form = UserCreationForm(request.POST)
        if form.is_valid():
            success = 1
            nom = form.cleaned_data['nomProfil']
            description = form.cleaned_data['description']
            nombreOccurence = form.cleaned_data['nombreOccurence']
            documentation = form.cleaned_data['documentation']
            
            profil = Profil()
            profil.nomProfil = nom
            profil.nombreOccurence = nombreOccurence
            profil.description = description
            profil.documentation = documentation 
            profil.save()
            
        else:
            success = 0
   else:
       form = ProfilForm()

   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success        
     }               
   )
   
   output = template.render(variables)
   return HttpResponse(output)
Exemple #10
0
def mesures_delete(request,profil_id,scenario_id,mesures_id):
   section = 'scenario'
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/mesures_delete.html');
   cfg = template_config(request)
   cfg.current_url = '/profil_scenario/'
   section = ''
   cfg.section = section
   success = 0
   
   base_url = site_config('base_url')
   debug = ''
   
   if request.method == 'POST':
       if request.POST.get('action') == 'Annuler':
            base_url_mesure = base_url + 'profil_scenario/' + scenario_id + '/scenario/' + scenario_id + '/mesures'
            return HttpResponseRedirect( base_url_mesure )
        
       deleteForm = DeleteForm( request.POST )
       
       if request.POST.get('action','') == 'delete':
           mesure = Mesure.objects.get(pk=mesures_id)
           mesure.delete()
           
           success = 1
       
   else:
        deleteForm = DeleteForm( { 'action':'delete','scenario_id': scenario_id }  )
   
   
   cfg.mesure_id = mesures_id
   cfg.scenario_id = scenario_id
   cfg.profil_id = profil_id    
   variables = RequestContext(request, 
     {
        'form' : deleteForm,
        'cfg': cfg,
        'scenario_id': scenario_id,
        'request':request,
        'profil_id' : profil_id
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output)  
   
Exemple #11
0
def tco_move_under(request,tco_id):
   section = 'tco'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_moveunder.html')
   cfg = template_config(request)
   cfg.current_url = '/tco/'
   section = ''
   cfg.section = 'tco'
   success = 0
   
   if request.method == 'POST':
       if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco/')
        
       moveForm = TcoFormMoveUnder( request.POST )
       
       if moveForm.is_valid():
            try:
                tco_id = moveForm.cleaned_data['tco_id']
                parent_tco_id = moveForm.cleaned_data['parent_tco_id']
                
                tco = Tco.objects.get(pk=tco_id)
                tco.parent_tco_id = parent_tco_id
                
                tco.save()
                success = 1
                
            except Tco.DoesNotExist:
                success = 0
   else:
        moveForm = TcoFormMoveUnder( { 'tco_id': tco_id, 'parent_tco_id' : -1 }  )
       
   variables = RequestContext(request, 
     {
        'username' : 'patrice',
        'form' : moveForm,
        'cfg': cfg,
        'tco_id': tco_id,
        'request':request,
        'success': success
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output) 
Exemple #12
0
def lst_mesures(request,profil_id,scenario_id):
   section = 'mesure' 
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/mesures_lst.html');
   cfg = template_config(request)
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   debug = ''
   
   lst_mesures = list(Mesure.objects.filter(scenario=scenario_id))
   
   cfg.scenario_id = scenario_id
   cfg.profil_id = profil_id
   #cfg.tco_id = tco_id
   
   lst_mesures_tmp = list(Mesure.objects.filter(scenario=scenario_id))
   
   #lst_mesures = [len(lst_mesures_tmp)]
   #for m in lst_mesures_tmp:
   #    lst_mesures[m.tco.id] = m
       
   
   sql = "SELECT * FROM "+table_tco+" WHERE parent_tco_id = -1 ORDER BY niveau "
   lst_tco = list(Tco.objects.raw(sql))
   tree_lst_tco = lst_tco_build_list(lst_tco,lst_mesures_tmp)
   
   cfg.lst_mesures = lst_mesures
   cfg.tree_lst_tco = tree_lst_tco
   
   variables = RequestContext( request, 
     {
        'cfg': cfg,
        'scenario_id' : scenario_id,
        'profil_id' : profil_id,
        'tco_id' : profil_id,
        'lst_mesures' : lst_mesures
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output) 
Exemple #13
0
def tco_parametres_delete(request,tco_id,parametre_id):
   section = 'parameter'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_parametres_delete.html')
   cfg = template_config(request)
   cfg.current_url = '/tco/'
   section = ''
   cfg.section = 'tco'
   success = 0
   
   if request.method == 'POST':
       if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco/' + tco_id + '/parameters')
        
       
       if request.POST.get('action','') == 'delete':
            try:
                parametre = Parametre.objects.get(pk=parametre_id)
                parametre.delete()
                success = 1
            except Parametre.DoesNotExist:
                success = 0
            
       deleteForm = DeleteForm( request.POST )
            
   else:
        deleteForm = DeleteForm( { 'action':'delete','tco_id': tco_id }  )
       
   variables = RequestContext(request, 
     {
        'username' : 'patrice',
        'form' : deleteForm,
        'lst_tco' : lst_tco,
        'cfg': cfg,
        'tco_id': tco_id,
        'parametre_id':parametre_id,
        'request':request,
        'success':success
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output) 
Exemple #14
0
def invalid_right(request):
   #user = User.objects.get(username__exact='pgrimard')
   #user.is_superuser = True
   #user.save() 
   
   template = get_template('pages/invalid_right.html');
   cfg = template_config(request)
   cfg.section = 'a'
   
   variables = RequestContext( request,
     {
        'cfg': cfg
     }                  
   )
   
   output = template.render(variables);
   return HttpResponse(output)
Exemple #15
0
def delete_scenario(request,scenario_id,section):
   section = 'scenario'
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/scenario_delete.html');
   cfg = template_config(request)
   cfg.current_url = '/profil_scenario/'
   section = ''
   cfg.section = section
   success = 0
   
   base_url = site_config('base_url')
   debug = ''
   
   if request.method == 'POST':
       if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_profil_url )
        
       deleteForm = DeleteForm( request.POST )
       
       if request.POST.get('action','') == 'delete':
           scenario = Scenario.objects.get(pk=scenario_id)
           scenario.delete()
           
           success = 1
       
   else:
        deleteForm = DeleteForm( { 'action':'delete','scenario_id': scenario_id }  )
       
   variables = RequestContext(request, 
     {
        'form' : deleteForm,
        'cfg': cfg,
        'scenario_id': scenario_id,
        'request':request,
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output)      
Exemple #16
0
def lst_profil(request,section):
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
    
   template = get_template('pages/profil_scenario/profil_lst.html');
   
   sql = "SELECT * FROM "+table_profil+"  ORDER BY nomProfil "
   lst_profil = list(Profil.objects.raw(sql))
   
   index = 0
   for i in lst_profil:
        profil_id = lst_profil[index].id
        sql = "SELECT * FROM "+table_scenario+" WHERE profil_id = "+str(profil_id)+" ORDER BY nom "
        lst_childs = list(Scenario.objects.raw(sql))
        
        if lst_childs.count == 0:
            lst_profil[index].childs = []
        else:
            lst_profil[index].childs = lst_childs
        
        index = index + 1
   
   
   
   cfg = template_config(request)
   
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   
   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'cfg': cfg,
        'list':list,
        'lst_profil': lst_profil
     }                  
                    
   )
   
   output = template.render(variables);
   
   return HttpResponse(output)  
Exemple #17
0
def main(request):
   section = 'rapports'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
   
   template = get_template('pages/rapports/default.html');
   cfg = template_config(request)
   cfg.section = section
   
   variables = RequestContext( request,
     {
        'cfg': cfg
     }                  
   )
   
   output = template.render(variables);
   return HttpResponse(output)
Exemple #18
0
def ajax_tco_lst(request):
   section = 'tco' 
    
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/ajax_mesures_tco_lst.html');
   cfg = template_config(request)
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   debug = ''
   
   sql = "SELECT * FROM "+table_tco+" WHERE parent_tco_id = -1 ORDER BY niveau "
   lst_tco = list(Tco.objects.raw(sql))
   tree_lst_tco = lst_tco_build_list(lst_tco)
   
   cfg.tree = tree_lst_tco
   cfg.scenario_id = 0
   cfg.profil_id = 0
   
   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'lst_tco' : lst_tco,
        'cfg': cfg,
        'list':list,
         'scenario_id' : 0,
         'profil_id' : 0,
        'tree_lst_tco':tree_lst_tco
     }                  
                    
   )
   
   output = template.render(variables)
   return HttpResponse(output)
Exemple #19
0
def view_login(request):
    template = get_template('registration/login.html');
    
    cfg = template_config(request)

    cfg.section = 'a'
    
    variables = RequestContext( request,
     {
        'success':'true',
        'cfg' : cfg
      }                  
    )
    
    if request.method == 'POST':
        username = request.POST['username']
        password = request.POST['password']
        user = authenticate(username=username, password=password)
        if user is not None:
            if user.is_active:
                login(request,user)
                base_url = site_config('base_url')
                return HttpResponseRedirect( base_url )
                # Redirect to a success page.
            #else:
            #   return HttpResponse('inactif')
        else:
            variables = RequestContext( request,
             {
                'success':'false',
                'cfg' : cfg
             }                  
            )

   
    output = template.render(variables)
        
    return HttpResponse(output)
Exemple #20
0
def add_tco(request,parent_tco_id):
   section = 'tco'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_add.html');
   
   cfg = template_config(request)
   
   cfg.current_url = '/tco/'
   cfg.section = 'tco'
   success = 0
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco')
        
        form = TcoForm(request.POST)
        #form = UserCreationForm(request.POST)
        if form.is_valid():
            success = 1
            titre = form.cleaned_data['titre']
            niveau = form.cleaned_data['niveau']
            description = form.cleaned_data['description']
            parent_tco_id = form.cleaned_data['parent_tco_id']
            documentation = form.cleaned_data['documentation']
            
            tco = Tco(0,parent_tco_id,niveau,titre,description,documentation)
            tco.niveau = niveau
            tco.titre = titre
            tco.description = description
            tco.documentation = documentation 
            tco.parent_tco_id = parent_tco_id 
            
            tco.save()
            
        else:
            success = 0
   else:
       niveau = 'g'
       if parent_tco_id > -1:
           lst_childs = list( Tco.objects.filter(parent_tco_id=parent_tco_id) )
           niveau = len(lst_childs)
       form = TcoForm(initial={'parent_tco_id':parent_tco_id,'niveau':niveau})

   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success        
     }               
           
                    
   )
   
   
   output = template.render(variables)
   return HttpResponse(output)
Exemple #21
0
def mesures_edit_from_tco(request,profil_id,scenario_id,tco_id):
   section = 'profil'
    
    
   errorMsg = ''
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/mesures_edit.html');
   
   cfg = template_config(request)
   
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   
   mesure = Mesure()
       
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            base_url_mesure = base_url + 'profil_scenario/' + scenario_id + '/scenario/' + scenario_id + '/mesures'
            
            return HttpResponseRedirect( base_url_mesure )
        
        form = MesureForm(request.POST)
        if form.is_valid():
            success = 1
            
            p_mesure = form.save(commit=False)
            p_mesure.tco = Tco.objects.get(pk=tco_id)
            
            p_mesure.annee1 = checkIfFloatValue(p_mesure.annee1)
            p_mesure.annee2 = checkIfFloatValue(p_mesure.annee2)
            p_mesure.annee3 = checkIfFloatValue(p_mesure.annee3)
            p_mesure.annee4 = checkIfFloatValue(p_mesure.annee4)
            p_mesure.annee5 = checkIfFloatValue(p_mesure.annee5)
            p_mesure.annee6 = checkIfFloatValue(p_mesure.annee6)
            p_mesure.annee7 = checkIfFloatValue(p_mesure.annee7)
            p_mesure.annee8 = checkIfFloatValue(p_mesure.annee8)
            p_mesure.annee9 = checkIfFloatValue(p_mesure.annee9)
            p_mesure.annee10 = checkIfFloatValue(p_mesure.annee10)
            p_mesure.annee11 = checkIfFloatValue(p_mesure.annee11)
            p_mesure.annee12 = checkIfFloatValue(p_mesure.annee12)
            p_mesure.annee13 = checkIfFloatValue(p_mesure.annee13)
            p_mesure.annee14 = checkIfFloatValue(p_mesure.annee14)
            p_mesure.annee15 = checkIfFloatValue(p_mesure.annee15)
            p_mesure.annee16 = checkIfFloatValue(p_mesure.annee16)
            p_mesure.annee17 = checkIfFloatValue(p_mesure.annee17)
            p_mesure.annee18 = checkIfFloatValue(p_mesure.annee18)
            p_mesure.annee19 = checkIfFloatValue(p_mesure.annee19)
            p_mesure.annee20 = checkIfFloatValue(p_mesure.annee20)
            
            total = p_mesure.annee1 + p_mesure.annee2 + p_mesure.annee3 + p_mesure.annee4 + p_mesure.annee5
            total = total +  p_mesure.annee6 + p_mesure.annee7 + p_mesure.annee8 + p_mesure.annee9 + p_mesure.annee10
            total = total +  p_mesure.annee11 + p_mesure.annee12 + p_mesure.annee13 + p_mesure.annee14 + p_mesure.annee15
            total = total +  p_mesure.annee16 + p_mesure.annee17 + p_mesure.annee18 + p_mesure.annee19 + p_mesure.annee20
            
            p_mesure.total = total
            
            if success == 1:
                try:
                    p_mesure.scenario = Scenario.objects.get(pk=scenario_id)
                except Scenario.DoesNotExist:
                    success = 0
                    errorMsg = "Le Scénario inscrit n'existe pas."
                    
            if success == 1:
                p_mesure.save();
            
        else:
            success = 0
   else:
       form = MesureForm(instance=mesure)
       
       
   cfg.tco_id = tco_id
   cfg.scenario_id = scenario_id
   cfg.profil_id = profil_id
   
   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success,
         'errorMsg':errorMsg,
        'scenario_id' : scenario_id,       
        'profil_id' : profil_id        
     }               
   )
   
   output = template.render(variables)
   return HttpResponse(output)
Exemple #22
0
def delete_tco(request,tco_id):
   section = 'tco'
   
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/tco/tco_delete.html');
   cfg = template_config(request)
   cfg.current_url = '/tco/'
   section = ''
   cfg.section = 'tco'
   success = 0
   
   debug = ''
   
   if request.method == 'POST':
       if request.POST.get('action') == 'Annuler':
            return HttpResponseRedirect( base_url + 'tco')
        
       deleteForm = DeleteForm( request.POST )
       
       if request.POST.get('action','') == 'delete':
           tco_id = request.POST.get('tco_id','')
           tco = Tco.objects.get(pk=tco_id)
           
           #sql = "SELECT * FROM "+table_tco+" WHERE parent_tco_id = "+str(tco.parent_tco_id)+" ORDER BY niveau"
           #lst_brothers = list(Tco.objects.raw(sql))
           #if len(lst_brothers) > 1:
           #    found = False
           #    lst_id = []
           #    
           #    for tco_brother in lst_brothers:
           #        if found == True:
           #            lst_id.append(str(tco_brother.id)+',')
           #        
           #        if tco_brother.id == tco.id:
           #            found = True
               
           #    if len(lst_id) > 0:
           #        cursor = connection.cursor()
                   
           #        sql = "UPDATE "+table_tco+" SET niveau = niveau -1 WHERE parent_tco_id = "+str(tco.parent_tco_id)+" AND niveau > " + str(tco.niveau)
                    # Data modifying operation - commit required
           #        cursor.execute(sql)
           #        transaction.commit_unless_managed()
               
           tco.delete()
           
           success = 1
       
   else:
        deleteForm = DeleteForm( { 'action':'delete','tco_id': tco_id }  )
       
   variables = RequestContext(request, 
     {
        'username' : 'patrice',
        'form' : deleteForm,
        'lst_tco' : lst_tco,
        'cfg': cfg,
        'tco_id': tco_id,
        'request':request,
        'debug':debug
     }                  
                    
   )
   
   output = template.render(variables);
   return HttpResponse(output)          
Exemple #23
0
def mesures_edit_old(request,profil_id,scenario_id,mesures_id):
   section = 'profil'
    
    
   errorMsg = ''
   response = before_execute_view(request,section)
   if not response == True:
        return response
    
   template = get_template('pages/profil_scenario/mesures_edit.html');
   
   cfg = template_config(request)
   
   cfg.current_url = '/profil_scenario/'
   cfg.section = 'scenario_profil'
   success = 0
   
   base_url = site_config('base_url')
   
   parametre_id = 0
   
   if request.method == 'POST':
        if request.POST.get('action') == 'Annuler':
            base_url_mesure = base_url + 'profil_scenario/' + scenario_id + '/scenario/' + scenario_id + '/mesures'
            
            return HttpResponseRedirect( base_url_mesure )
        
        form = MesureForm(request.POST)
        if form.is_valid():
            success = 1
            parametre_id = request.REQUEST['parametre']
            
            if not re.search(r"^[0-9]+$",parametre_id):
                success = 0
                errorMsg = "Le parametre doit etre numerique."
            
            p_mesure = form.save(commit=False)
            
            p_mesure.id = mesures_id
            
            if success == 1:
                try :
                    p_mesure.parametre = Parametre.objects.get(pk=parametre_id)
                except Parametre.DoesNotExist:
                    success = 0
                    errorMsg = "Le parametre inscrit n'existe pas."
            if success == 1:
                try:
                    p_mesure.scenario = Scenario.objects.get(pk=scenario_id)
                except Scenario.DoesNotExist:
                    success = 0
                    errorMsg = "Le Scénario inscrit n'existe pas."
                    
            if success == 1:
                p_mesure.save();
            
        else:
            success = 0
   else:
       mesure = Mesure.objects.get(pk=mesures_id)
       form = MesureForm(instance=mesure)
       parametre_id = mesure.parametre.id
       
       
   cfg.mesure_id = mesures_id
   cfg.scenario_id = scenario_id
   cfg.profil_id = profil_id
   
   variables = RequestContext( request, 
     {
        'username' : 'patrice',
        'form' : form,
        'cfg': cfg,
        'success' : success,
         'errorMsg':errorMsg,
        'parametre_id':parametre_id,
        'scenario_id' : scenario_id,       
        'profil_id' : profil_id        
     }               
   )
   
   output = template.render(variables)
   return HttpResponse(output)