ext_CTRL_Famille_outils.py

# coding: utf8

# exposes:
#     classes: CTRL_ANNEE, UpdateQuestionnaire
#     functions: Ajouter, GetQuestionnaireValeurs
#     constants: FAMILLE, INDIVIDU
from collections import OrderedDict

import wx

from Dlg import DLG_Famille
from Utils import UTILS_Adaptations
from Utils.UTILS_Traduction import _
import Chemins

from ext_Extensions_automatiques import message, addModule, hasModule, getQuery, DB

VERSION = "_v2.1.0"
FAMILLE = 0
INDIVIDU = 1


list_outils = OrderedDict([
    (u"facture", [
        (u"Régler une facture", "Images/16x16/Codebarre.png", "self.MenuReglerFacture")
    ]),
    (u"relevé prestations", [
        (u"Editer un relevé des prestations", "Images/16x16/Euro.png", "self.MenuImprimerReleve")
    ]),
    (u"attestation de présence", [
        (u"Générer une attestation de présence",
            "Images/16x16/Generation.png", "self.MenuGenererAttestation"),
        (u"Liste des attestations de présences générées",
            "Images/16x16/Facture.png", "self.MenuListeAttestations")
    ]),
    (u"devis", [
        (u"Générer un devis", "Images/16x16/Generation.png", "self.MenuGenererDevis"),
        (u"Liste des devis générés", "Images/16x16/Facture.png", "self.MenuListeDevis"),
    ]),
    (u"lettres de rappel", [
        (u"Générer une lettre de rappel",
            "Images/16x16/Generation.png", "self.MenuGenererRappel"),
        (u"Liste des lettres de rappel générées",
            "Images/16x16/Facture.png", "self.MenuListeRappels"),
    ]),
    (u"règlements", [
        (u"Liste des reçus de règlements édités",
            "Images/16x16/Note.png", "self.MenuListeRecus"),
        (u"Répartition de la ventilation par règlement",
            "Images/16x16/Repartition.png", "self.MenuRepartitionVentilation"),
    ]),
    (u"étiquettes", [
        (u"Edition d'étiquettes et de badges",
            "Images/16x16/Etiquette2.png", "self.MenuEditionEtiquettes"),
    ]),
    (u"log", [
        (u"Historique", "Images/16x16/Historique.png", "self.MenuHistorique"),
        (u"Chronologie", "Images/16x16/Timeline.png", "self.MenuChronologie"),
    ]),
    (u"export", [
        (u"Exporter les données de la famille au format XML",
            "Images/16x16/Document_export.png", "self.MenuExporter"),
    ]),
    (u"mail", [
        (u"Envoyer un Email avec l'éditeur d'Emails de Noethys",
            "Images/16x16/Editeur_email.png", "self.MenuEnvoyerMail"),
        (u"Envoyer un Email avec le client de messagerie par défaut",
            "Images/16x16/Editeur_email.png", "self.MenuEnvoyerMail"),
    ])
])


def Extension():
    if not hasModule(__name__ + VERSION):
        message(u"L'extension est correctement installée, "
            u"merci de redémarrer Noethys pour l'activer.")
        return
    message(u"Extension installée et activée.", __name__ + VERSION)


def Initialisation():
    DLG_Famille.Dialog.OnBoutonOutils = OnBoutonOutils
    addModule(__name__ + VERSION)


def OnBoutonOutils(self, event):
    # Création du menu contextuel
    menuPop = UTILS_Adaptations.Menu()

    first = True
    for groupName, group in list_outils.iteritems():
        if first:
            first = False
        else:
            menuPop.AppendSeparator()

        for text, image, handler in group:
            ID = wx.Window.NewControlId()
            item = wx.MenuItem(menuPop, ID, _(text))
            bmp = wx.Bitmap(Chemins.GetStaticPath(image), wx.BITMAP_TYPE_PNG)
            item.SetBitmap(bmp)
            menuPop.AppendItem(item)
            self.Bind(wx.EVT_MENU, eval(handler), id=ID)

    self.PopupMenu(menuPop)
    menuPop.Destroy()


def Ajouter(group, params):
    global list_outils
    if group not in list_outils:
        list_outils[group] = []
    list_outils[group].append(params)


def GetQuestionnaireValeurs(IDfamille):
    query = """
    SELECT
        `questionnaire_questions`.`IDquestion` AS `question`,
        `questionnaire_reponses`.`IDreponse`,
        IFNULL(
            `questionnaire_choix`.`label`, IFNULL(
                `questionnaire_reponses`.`reponse`, `questionnaire_questions`.`defaut`
        )) AS `reponse`
    FROM
        `questionnaire_questions`
        LEFT OUTER JOIN `questionnaire_reponses` ON(
            `questionnaire_questions`.`IDquestion`=`questionnaire_reponses`.`IDquestion` AND
            `questionnaire_reponses`.`IDfamille`={IDfamille}
        )
        LEFT JOIN `questionnaire_choix` ON (
            `questionnaire_questions`.`IDquestion`=`questionnaire_choix`.`IDquestion` AND
            (
                `questionnaire_reponses`.`reponse`=`questionnaire_choix`.`IDchoix` OR
                (
                    `questionnaire_reponses`.`reponse` IS NULL AND
                    `questionnaire_questions`.`defaut`=`questionnaire_choix`.`IDchoix`
                )
            )
        )
    WHERE
        (
            `questionnaire_reponses`.`IDfamille`={IDfamille} OR
            (
                `questionnaire_reponses`.`IDfamille` IS NULL AND
                `questionnaire_reponses`.`IDindividu` IS NULL
            )
        )
    ORDER BY `questionnaire_questions`.`IDquestion`;
    """.format(IDfamille=IDfamille)
    response = getQuery(query)

    reponsesQuestionnaire = {}
    for IDquestion, IDreponse, reponse in response:
        reponsesQuestionnaire[IDquestion] = {
            "IDreponse": IDreponse if IDreponse else u"NULL",
            "reponse": reponse,
        }

    return reponsesQuestionnaire


def isString(value):
    return unicode(value) == value


class UpdateQuestionnaire(DB):
    def __init__(self):
        super(UpdateQuestionnaire, self).__init__()
        self.values = []

    def AddValue(self, IDquestion, IDdestinataire, reponse, type=FAMILLE, IDligne=None):
        if IDligne is None:
            IDreponseSQL = self.GetResponse("""
                SELECT `IDreponse`
                FROM `questionnaire_reponses`
                WHERE `IDquestion`={IDquestion} AND {propCol}={IDdestinataire}
            """.format(
                IDquestion=IDquestion,
                propCol="IDfamille" if type == FAMILLE else "IDindividu",
                IDdestinataire=IDdestinataire
            ))
            IDreponse = IDreponseSQL[0][0] if IDreponseSQL else "NULL"
        else:
            IDreponse = IDligne

        resp = u'"' + reponse + '"' if isString(reponse) else reponse

        self.values.append("({}, {}, {}, {}, {})".format(
            IDreponse,
            IDquestion,
            IDdestinataire if type == INDIVIDU else "NULL",
            IDdestinataire if type == FAMILLE else "NULL",
            resp
        ))

    def Execute(self):
        response, success = self.GetQuery("""
            INSERT INTO `questionnaire_reponses`
            (`IDreponse`, `IDquestion`, `IDindividu`, `IDfamille`, `reponse`)
            VALUES {values}
            ON DUPLICATE KEY UPDATE
                `reponse`=VALUES(`reponse`);
        """.format(values=",".join(self.values)))
        if success:
            self.values = []
        return response, success


class CTRL_ANNEE(wx.Choice):
    def __init__(self, parent, db=None, label=u"Sélectionnez l'année scolaire."):
        super(CTRL_ANNEE, self).__init__(parent, -1, choices=[])
        self.parent = parent
        if db is not None and not isinstance(db, UpdateQuestionnaire):
            raise TypeError(u"db must be instance of UpdateQuestionnaire " + str(db) + " given")
        self.db = db
        self.SetToolTip(wx.ToolTip(label))
        self.MAJ()

    def MAJ(self):
        listeItems = self.GetListeDonnees()
        if len(listeItems) == 0:
            self.Enable(False)
        self.SetItems(listeItems)

    def GetAnnee(self):
        index = self.GetSelection()
        if index == -1:
            return None
        return self.dictDonnees[index]

    def GetListeDonnees(self):
        req = """SELECT IDactivite, nom, date_debut, date_fin FROM activites ORDER BY nom;"""
        if self.db is None:
            listeDonnees = getQuery(req)
        else:
            listeDonnees = self.db.GetResponse(req)
        self.dictDonnees = {}
        listeNoms = []
        index = 0
        for activite in listeDonnees:
            IDactivite, nom, date_debut, date_fin = activite
            listeNoms.append(activite[1])
            self.dictDonnees[index] = activite
            index += 1
        return listeNoms

    def SetID(self, ID=0):
        if ID is None:
            return
        for index, values in self.dictDonnees.items():
            if values[0] == ID:
                self.SetSelection(index)

    def GetID(self):
        index = self.GetSelection()
        if index == -1:
            return None
        if index == 0:
            return None
        return self.dictDonnees[index][0]