def numeros_search_view(request):
"""
Search numeros
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
settings = request.registry.settings
search_limit = int(settings['search_limit'])
params = request.params
matDiff = False
if 'matDiff' in params:
matDiff = True if params['matDiff'] == 'true' else False
# Set conditions
conditions = Utils.get_search_conditions(VNumeros, params)
# filter by conditions
query = request.dbsession.query(VNumeros).order_by(
VNumeros.cadastre, VNumeros.numero.desc()).filter(*conditions)
query = query.filter(VNumeros.type_numero_id <= 4)
# if option matDiff selected
if matDiff:
query = query.filter(
and_(VNumeros.diff_entree.isnot(None),
VNumeros.diff_sortie.is_(None)))
query = query.limit(search_limit).all()
return Utils.serialize_many(query)
def affaires_search_view(request):
"""
Search affaires
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
settings = request.registry.settings
search_limit = int(settings['search_limit'])
params_affaires = {}
client = None
client_in_params = False
for key in request.params.keys():
if "client" in key:
client = request.params[key]
client_in_params = True
params_affaires["client_commande_id"] = request.params[key]
params_affaires["client_envoi_id"] = request.params[key]
else:
params_affaires[key] = request.params[key]
# Chercher les affaires par les clients de facture
affaires_id_by_clients_facture = []
if client_in_params:
query_facture = request.dbsession.query(Facture).filter(or_(
Facture.client_id == client,
Facture.client_co_id == client,
)).all()
# Récupérer la liste des id des affaires retenues
for facture in query_facture:
affaires_id_by_clients_facture.append(int(facture.affaire_id))
# Chercher les affaires par les conditions (sauf client_facture)
conditions = Utils.get_search_conditions(VAffaire, params_affaires)
query = request.dbsession.query(VAffaire)
if client_in_params:
query = query.filter(and_(
*conditions,
VAffaire.id.in_(affaires_id_by_clients_facture)
))
else:
query = query.filter(*conditions)
query = query.limit(search_limit).all()
return Utils.serialize_many(query)
def operateurs_search_view(request):
"""
Search operateurs
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
settings = request.registry.settings
search_limit = int(settings['search_limit'])
conditions = Utils.get_search_conditions(Operateur, request.params)
# Check date_sortie is null
conditions = [] if not conditions or len(conditions) == 0 else conditions
conditions.append(Operateur.sortie == None)
query = request.dbsession.query(Operateur).order_by(Operateur.nom, Operateur.prenom).filter(
*conditions).limit(search_limit).all()
return Utils.serialize_many(query)
def affaires_search_view(request):
"""
Search affaires
"""
# Check connected
if not Utils.check_connected(request):
raise exc.HTTPForbidden()
settings = request.registry.settings
search_limit = int(settings['search_limit'])
params_affaires = {}
client_id = None
date_from = None
date_to = None
limitNbResults = True
for key in request.params.keys():
if "client" in key:
client_id = request.params[key]
elif "date_from" in key:
date_from = datetime.strptime(request.params[key], '%Y-%m-%d')
elif "date_to" in key:
date_to = datetime.strptime(request.params[key], '%Y-%m-%d')
elif "limitNbResults" in key:
if request.params[key] == "true":
limitNbResults = True
else:
limitNbResults = False
else:
params_affaires[key] = request.params[key]
# Chercher les affaires par les clients de facture
affaires_id_by_clients_facture = []
if client_id is not None:
query_facture = request.dbsession.query(Facture).filter(Facture.client_id == client_id).all()
# Récupérer la liste des id des affaires retenues
for facture in query_facture:
affaires_id_by_clients_facture.append(int(facture.affaire_id))
# Chercher les affaires par les conditions (sauf client_facture)
conditions = Utils.get_search_conditions(VAffaire, params_affaires)
query = request.dbsession.query(VAffaire).filter(*conditions)
if client_id is not None:
query = query.filter(or_(
VAffaire.client_commande_id == client_id,
VAffaire.client_envoi_id == client_id,
VAffaire.id.in_(affaires_id_by_clients_facture)
))
# filtrer les affaires par critères temporels
if not date_from is None:
query = query.filter(VAffaire.date_ouverture >= date_from)
if not date_to is None:
query = query.filter(VAffaire.date_ouverture <= date_to)
if limitNbResults:
query = query.limit(search_limit)
query = query.all()
results = Utils.serialize_many(query)
for i, result in enumerate(results):
clients_facture = request.dbsession.query(
Client.entreprise,
Client.titre,
Client.prenom,
Client.nom
).filter(
Facture.affaire_id == result['id']
).filter(
Facture.client_id == Client.id
).all()
results[i]["client_facture"] = [{'entreprise': x[0], 'titre': x[1], 'nom': x[2], 'prenom': x[3]} for x in clients_facture]
return results