def gobernacionquery(request):
col = "-gobernacion"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultagobernacionform = ConsultaGobernacionForm(request.GET)
if 'region' in request.GET and 'provincia' in request.GET:
if request.GET['region'] and request.GET['provincia']:
gobernaciones = Gobernacion.objects.filter(region=request.GET['region'],
provincia=request.GET['provincia']).order_by(col)
elif request.GET['region']:
gobernaciones = Gobernacion.objects.filter(region=
request.GET['region'],).order_by(col)
else:
gobernaciones = Gobernacion.objects.all().order_by(col)
else:
gobernaciones = Gobernacion.objects.all().order_by(col)
tblgobernaciones = GobernacionTable(gobernaciones.order_by(col))
config.configure(tblgobernaciones)
tblgobernaciones.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('dependencia/gobernacion_consulta.html',
{'consultagobernacionform':consultagobernacionform,
'tabla':tblgobernaciones,
'mensaje':(request.GET['m'] if 'm' in request.GET else '')},
context_instance=RequestContext(request),)
def forum_query(request):
col = "-name"
query = Forum.objects.all()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ForumConsultaForm(request.GET)
if "name" in request.GET:
query = Forum.objects.filter(
name__icontains=request.GET['name']).order_by(col)
if "category" in request.GET:
if request.GET['category']:
query = query.filter(category__id=request.GET['category'])
tabla = ForumTablee(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response(
'extras/foro_consulta.html',
{
'formulario': formulario,
'tabla': tabla,
'mensaje': (request.GET['m'] if 'm' in request.GET else '')
},
context_instance=RequestContext(request),
)
def ariquery(request):
col = "-organismo"
query = None
dependencia=''
filtro = list()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ConsultaAriForm(request.GET)
#if request.user.get_profile().nivel.codigo == 2:
# if 'organismo' in request.GET:
# if request.GET['organismo']:
# filtro.append(u"actareunionintersectorial.organismo_id =%s"%request.GET['organismo'])
# if 'dependencia' in request.GET:
# if request.GET['dependencia']:
# filtro.append(u"actareunionintersectorial.dependencia =%s"%request.GET['dependencia'])
# dependencia=request.GET['dependencia']
#else:
#filtro.append(u"actareunionintersectorial.organismo_id =%s"%request.user.get_profile().organismo.codigo)
#filtro.append(u"actareunionintersectorial.dependencia =%s"%request.user.get_profile().dependencia)
#filtro.append(u"idusuario_creac="+str(request.user.get_profile().numero))
filtro.append(u"idusuario_creac=usuario.numero")
query = ActaReunionIntersectorial.objects.extra(tables=['usuario',],where=filtro,select={'usuario':'usuario.usuario','dependencia':"case actareunionintersectorial.organismo_id when 1 then (select ministerio from ministerio where nummin=actareunionintersectorial.dependencia) when 2 then (select odp from odp where numodp=actareunionintersectorial.dependencia) when 3 then (select gobernacion from gobernacion where numgob=actareunionintersectorial.dependencia) end"}).filter(nombreari__icontains=request.GET['nombreari'] if 'nombreari' in request.GET else '')
#if 'nombreari' in request.GET:
# query.filter(nombreari__icontains=request.GET['nombreari'])
tabla = AriTable(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('extras/ari_consulta.html', {'formulario':formulario,'tabla':tabla,'dependencia':dependencia,}, context_instance=RequestContext(request),)
def tema_query(request):
col = "-name"
query = Topic.objects.all()
idforum = ''
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = TopicConsultaForm(request.GET)
if "name" in request.GET:
query = query.filter(name__icontains=request.GET['name']).order_by(col)
if "forum" in request.GET:
if request.GET['forum']:
query = query.filter(forum__id=request.GET['forum'])
idforum = request.GET['forum']
if "categoria" in request.GET:
if request.GET['categoria']:
query = query.filter(forum__category__id=request.GET['categoria'])
tabla = TopicTablee(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response(
'extras/tema_consulta.html',
{
'formulario': formulario,
'tabla': tabla,
'mensaje': (request.GET['m'] if 'm' in request.GET else ''),
'idforum': idforum
},
context_instance=RequestContext(request),
)
def documentos_query(request):
col = "-organismo"
query = None
dependencia=''
usuario = ''
filtro = list()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ConsultaDocumentoForm(request.GET)
if 'organismo' in request.GET:
if request.GET['organismo']:
filtro.append(u"documentos.organismo_id =%s"%request.GET['organismo'])
if 'dependencia' in request.GET:
if request.GET['dependencia']:
filtro.append(u"documentos.dependencia =%s"%request.GET['dependencia'])
dependencia=request.GET['dependencia']
if 'idusuario_creac' in request.GET:
if request.GET['idusuario_creac']:
filtro.append(u"idusuario_creac_id =%s"%request.GET['idusuario_creac'])
usuario=request.GET['idusuario_creac']
if 'categoria' in request.GET:
if request.GET['categoria']:
filtro.append(u"categoria ='%s'"%request.GET['categoria'])
if 'tipo' in request.GET:
if request.GET['tipo']:
filtro.append(u"tipo ='%s'"%request.GET['tipo'])
query = Documento.objects.extra(where=filtro,select={'dependencia':"case documentos.organismo_id when 1 then (select ministerio from ministerio where nummin=documentos.dependencia) when 2 then (select odp from odp where numodp=documentos.dependencia) when 3 then (select gobernacion from gobernacion where numgob=documentos.dependencia) end"})
#.filter(nombreari__icontains=request.GET['nombreari'] if 'nombreari' in request.GET else '')
tabla = DocumentoTable(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('extras/documento_consulta.html', {'formulario': formulario,'tabla':tabla,'dependencia':dependencia,'usuario':usuario}, context_instance=RequestContext(request),)
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 10})
results = self.table_class(self.object_list)
order_by = self.form.cleaned_data.get('order_by')
if order_by in ('last_modified','licence'):
order_by = '-'+order_by
results.order_by = order_by
config.configure(results)
return results
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 10})
results = self.table_class(self.object_list)
order_by = self.form.cleaned_data.get('order_by')
if order_by in ('last_modified', 'licence'):
order_by = '-' + order_by
results.order_by = order_by
config.configure(results)
return results
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 5})
results = ProjectTable(self.object_list)
#order_by = self.form.cleaned_data.get('order_by')
order_by = self.request.GET.get('order_by','num_items')
if order_by in ('num_items',):
order_by = '-'+order_by
results.order_by = order_by
config.configure(results)
return results
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 5})
results = ProjectTable(self.object_list)
#order_by = self.form.cleaned_data.get('order_by')
order_by = self.request.GET.get('order_by','num_items')
if order_by in ('num_items',):
order_by = '-'+order_by
results.order_by = order_by
config.configure(results)
return results
def ministerioquery(request):
col = "-ministerio"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultaministerioform = ConsultaMinisterioForm(request.GET)
if 'ministerio' in request.GET:
ministerios = Ministerio.objects.filter(ministerio__icontains=request.GET['ministerio']).order_by(col)
else:
ministerios = Ministerio.objects.all().order_by(col)
tblministerios = MinisterioTable(ministerios.order_by(col))
config.configure(tblministerios)
tblministerios.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('dependencia/ministerio_consulta.html', {'consultaministerioform':consultaministerioform,'tabla':tblministerios,'usuario':request.session['nombres'],'fecha':request.session['login_date']}, context_instance=RequestContext(request),)
def categoria_query(request):
col = "-name"
query = None
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = CategoryConsultaForm(request.GET)
if "name" in request.GET:
query = Category.objects.filter(name__icontains=request.GET['name']).order_by(col)
if query is None:
query = Category.objects.all()
tabla = CategoryTable(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('extras/categoria_consulta.html', {'formulario':formulario,'tabla':tabla,'mensaje':(request.GET['m'] if 'm' in request.GET else '')}, context_instance=RequestContext(request),)
def regionquery(request):
col = "-region"
regiones = None
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultaregionform = ConsultaRegionForm(request.GET)
if "region" in request.GET:
regiones = Region.objects.filter(region__icontains=request.GET['region']).order_by(col)
if regiones is None:
regiones = Region.objects.all()
tblregiones = RegionTable(regiones.order_by(col))
config.configure(tblregiones)
tblregiones.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('ubigeo/region_consulta.html', {'consultaregionform':consultaregionform,'tblregiones':tblregiones,'usuario':request.session['nombres'],'fecha':request.session['login_date']}, context_instance=RequestContext(request),)
def make_table(self):
project = self.get_project()
folder = self.get_folder()
items = folder.items.all() if folder else project.items.filter(folder=None)
config = RequestConfig(self.request, paginate={'per_page': 100})
results = BrowseProjectTable(items,order_by_field='order_by')
order_by = self.request.GET.get('order_by','name')
if order_by in ('last_modified', 'licence'):
order_by = '-'+order_by
results.order_by = order_by
config.configure(results)
return results
def query_caso_exito(request):
col = "-organismo"
query = None
dependencia=''
query = CasoExito.objects.all()
#print query[0].organismo_id
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ConsultaCeForm(request.GET)
if 'organismo' in request.GET:
if request.GET['organismo']:
query = query.filter(organismo=request.GET['organismo'])
if 'dependencia' in request.GET:
if request.GET['dependencia']:
dependencia=request.GET['dependencia']
query = query.filter(dependencia=request.GET['dependencia'])
if 'fechaini' in request.GET: #and 'fechafin' in request.GET:
start_date = None
#end_date = None
try:
start_date = ((request.GET['fechaini']) and
datetime.strptime(request.GET['fechaini'],"%d/%m/%Y") or None)
# end_date = ((request.GET['fechafin']) and
# datetime.strptime(request.GET['fechafin'],"%d/%m/%Y") or None)
except:
pass
if start_date:
query = query.filter(fecha__gte=start_date)
# if start_date and end_date:
# query = query.filter(fecha__range=(start_date, end_date))
# elif start_date:
# query = query.filter(fecha__gte=start_date)
# elif end_date:
# query = query.filter(fecha__lte=end_date)
query = query.extra(select={'dependencia':"""case tbl_caso_exito.organismo_id when 1
then (select ministerio from ministerio where nummin=tbl_caso_exito.dependencia)
when 2 then (select odp from odp where numodp=tbl_caso_exito.dependencia)
when 3 then (select gobernacion from gobernacion
where numgob=tbl_caso_exito.dependencia) end"""})
tabla = CeTable(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('prensa/ce_consulta.html',
{'formulario':formulario,'tabla':tabla,'dependencia':dependencia,},
context_instance=RequestContext(request),)
def documentos_query(request):
col = "-organismo"
query = None
dependencia=''
usuario = ''
filtro = list()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
#formulario = ConsultaDocumentoForm(request.GET)
tabla = ReporteTable(Reporte.objects.all())
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('home/consultar_reporte.html',
{#'formulario': formulario,
'tabla':tabla,
'dependencia':dependencia,
'usuario':usuario}, context_instance=RequestContext(request),)
def odpquery(request):
col = "-odp"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultaodpform = ConsultaOdpForm(request.GET)
if 'nummin' in request.GET and 'odp' in request.GET:
if (request.GET['nummin'] and request.GET['odp']) or request.GET['nummin']:
odps = Odp.objects.filter(odp__icontains=request.GET['odp'],nummin=request.GET['nummin']).order_by(col)
elif request.GET['odp']:
odps = Odp.objects.filter(odp__icontains=request.GET['odp']).order_by(col)
else:
odps = Odp.objects.all()
else:
odps = Odp.objects.all()
tblodps = OdpTable(odps.order_by(col))
config.configure(tblodps)
tblodps.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('dependencia/odp_consulta.html', {'consultaodpform':consultaodpform,'tabla':tblodps,'usuario':request.session['nombres'],'fecha':request.session['login_date']}, context_instance=RequestContext(request),)
def provinciaquery(request):
col = "-provincia"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultaprovinciaform = ConsultaProvinciaForm(request.GET)
if 'region' in request.GET and 'provincia' in request.GET:
if (request.GET['region'] and request.GET['provincia']) or request.GET['region']:
provincias = Provincia.objects.filter(provincia__icontains=request.GET['provincia'], region=request.GET['region']).order_by(col)
elif request.GET['provincia']:
provincias = Provincia.objects.filter(provincia__icontains=request.GET['provincia'],).order_by(col)
else:
provincias = Provincia.objects.all().order_by(col)
else:
provincias = Provincia.objects.all().order_by(col)
tblprovincias = ProvinciaTable(provincias.order_by(col))
config.configure(tblprovincias)
tblprovincias.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('ubigeo/provincia_consulta.html', {'consultaprovinciaform':consultaprovinciaform,'tabla':tblprovincias,'usuario':request.session['nombres'],'fecha':request.session['login_date']}, context_instance=RequestContext(request),)
def pgcs_apor_query(request):
col = "-organismo"
query = None
dependencia = ""
filtro = list()
if "2-sort" in request.GET:
col = request.GET["2-sort"]
config = RequestConfig(request)
formulario = ConsultaPgcsForm(request.GET)
if "organismo" in request.GET:
if request.GET["organismo"]:
filtro.append(u"pgcs.organismo_id =%s" % request.GET["organismo"])
if "dependencia" in request.GET:
if request.GET["dependencia"]:
filtro.append(u"pgcs.dependencia =%s" % request.GET["dependencia"])
dependencia = request.GET["dependencia"]
filtro.append(u"idusuario_creac=usuario.numero")
filtro.append(u"tipopgcs_id=2")
query = Pgcs.objects.extra(
tables=["usuario"],
where=filtro,
select={
"usuario": "usuario.usuario",
"dependencia": "case pgcs.organismo_id when 1 then (select ministerio from ministerio where nummin=pgcs.dependencia) when 2 then (select odp from odp where numodp=pgcs.dependencia) when 3 then (select gobernacion from gobernacion where numgob=pgcs.dependencia) end",
},
)
tabla = PgcsTable(query.order_by(col))
config.configure(tabla)
tabla.paginate(page=request.GET.get("page", 1), per_page=6)
return render_to_response(
"comunicacion/pgcs_consulta.html",
{
"formulario": formulario,
"tabla": tabla,
"usuario": request.session["nombres"],
"fecha": request.session["login_date"],
"dependencia": dependencia,
"aporte": "aporte",
},
context_instance=RequestContext(request),
)
def export(request):
config = RequestConfig(request)
cuts_export = ExportCuts(
Cut.objects.filter(pupil__can_read=request.user).exclude(
Q(private=True) & ~Q(updated_by=request.user)),
prefix='cuts')
events_export = ExportEvents(
Event.objects.filter(pupil__can_read=request.user), prefix='events')
config.configure(cuts_export)
config.configure(events_export)
export_format = request.GET.get('_export', None)
model = request.GET.get('model', None)
if TableExport.is_valid_format(export_format):
if model == 'update':
exporter = TableExport(export_format, cuts_export)
return exporter.response('updates.{}'.format(export_format))
elif model == 'event':
exporter = TableExport(export_format, events_export)
return exporter.response('events.{}'.format(export_format))
return render(request, 'export/export.html', {})
def digquery(request):
col = "-organismo"
query = None
dependencia=''
filtro = list()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ConsultaDIGForm(request.GET)
if request.user.get_profile().nivel.codigo == 2:
if 'organismo' in request.GET:
if request.GET['organismo']:
filtro.append(u"documentointeresgeneral.organismo_id =%s"%request.GET['organismo'])
if 'dependencia' in request.GET:
if request.GET['dependencia']:
filtro.append(u"documentointeresgeneral.dependencia =%s"%request.GET['dependencia'])
dependencia=request.GET['dependencia']
else:
filtro.append(u"documentointeresgeneral.organismo_id =%s"%request.user.get_profile().organismo.codigo)
filtro.append(u"documentointeresgeneral.dependencia =%s"%request.user.get_profile().dependencia)
filtro.append(u"idusuario_creac="+str(request.user.get_profile().numero))
filtro.append(u"idusuario_creac=usuario.numero")
filtro.append(u"documentointeresgeneral.organismo_id=organismo.codigo")
try:
query = DocumentoInteresGeneral.objects.extra(tables=['usuario','organismo'],where=filtro,select={'organismo':'organismo.nombre','usuario':'usuario.usuario','dependencia':"case documentointeresgeneral.organismo_id when 1 then (select ministerio from ministerio where nummin=documentointeresgeneral.dependencia) when 2 then (select odp from odp where numodp=documentointeresgeneral.dependencia) when 3 then (select gobernacion from gobernacion where numgob=documentointeresgeneral.dependencia) end",'tipomis1':"SUBSTRING_INDEX(archmis1, '.', -1)",'tipomis2':"SUBSTRING_INDEX(archmis2, '.', -1)",'tipomis3':"SUBSTRING_INDEX(archmis3, '.', -1)",'tipoaca1':"SUBSTRING_INDEX(archaca1, '.', -1)",'tipoaca2':"SUBSTRING_INDEX(archaca2, '.', -1)",'tipoaca3':"SUBSTRING_INDEX(archaca3, '.', -1)",'tipobue1':"SUBSTRING_INDEX(archbue1, '.', -1)",'tipobue2':"SUBSTRING_INDEX(archbue2, '.', -1)",'tipobue3':"SUBSTRING_INDEX(archbue3, '.', -1)"}).order_by(col).values('organismo','dependencia','fec_creac','usuario','dependencia','archmis1','archmis2','archmis3','archaca1','archaca2','archaca3','archbue1','archbue2','archbue3','tipomis1','tipomis2','tipomis3','tipoaca1','tipoaca2','tipoaca3','tipobue1','tipobue2','tipobue3')
data = list()
dmg = dict()
for mg in query:
for ar in ('mis','aca','bue'):
for a in range(1,4):
if mg['arch'+ar+str(a)]:
dmg = {'organismo':mg['organismo'],'dependencia':mg['dependencia'],'fec_creac':mg['fec_creac'],'usuario':mg['usuario'],'Descargar':mg['arch'+ar+str(a)],'TipoArchivo':mg['tipo'+ar+str(a)],'Tipo':ar.upper()}
data.append(dmg)
tabla = DIGTable(data)
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('extras/dig_consulta.html', {'formulario':formulario,'tabla':tabla,'dependencia':dependencia,}, context_instance=RequestContext(request),)
except:
raise Http404
def mgquery(request):
col = "-organismo"
query = None
dependencia=''
filtro = list()
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
formulario = ConsultaMGForm(request.GET)
if request.user.get_profile().nivel.codigo == 2:
if 'organismo' in request.GET:
if request.GET['organismo']:
filtro.append(u"materialgrafico.organismo_id =%s"%request.GET['organismo'])
if 'dependencia' in request.GET:
if request.GET['dependencia']:
filtro.append(u"materialgrafico.dependencia =%s"%request.GET['dependencia'])
dependencia=request.GET['dependencia']
else:
filtro.append(u"materialgrafico.organismo_id =%s"%request.user.get_profile().organismo.codigo)
filtro.append(u"materialgrafico.dependencia =%s"%request.user.get_profile().dependencia)
filtro.append(u"idusuario_creac="+str(request.user.get_profile().numero))
filtro.append(u"idusuario_creac=usuario.numero")
filtro.append(u"materialgrafico.organismo_id=organismo.codigo")
try:
query = MaterialGrafico.objects.extra(tables=['usuario','organismo'],where=filtro,select={'organismo':'organismo.nombre','usuario':'usuario.usuario','dependencia':"case materialgrafico.organismo_id when 1 then (select ministerio from ministerio where nummin=materialgrafico.dependencia) when 2 then (select odp from odp where numodp=materialgrafico.dependencia) when 3 then (select gobernacion from gobernacion where numgob=materialgrafico.dependencia) end",'tipo1':"SUBSTRING_INDEX(arcmg1, '.', -1)",'tipo2':"SUBSTRING_INDEX(arcmg2, '.', -1)",'tipo3':"SUBSTRING_INDEX(arcmg3, '.', -1)",'tipo4':"SUBSTRING_INDEX(arcmg4, '.', -1)",'tipo5':"SUBSTRING_INDEX(arcmg5, '.', -1)",'tipo6':"SUBSTRING_INDEX(arcmg6, '.', -1)",'tipo7':"SUBSTRING_INDEX(arcmg7, '.', -1)",'tipo8':"SUBSTRING_INDEX(arcmg8, '.', -1)"}).order_by(col).values('organismo','dependencia','fec_creac','usuario','dependencia','arcmg1','arcmg2','arcmg3','arcmg4','arcmg5','arcmg6','arcmg7','arcmg8','tipo1','tipo2','tipo3','tipo4','tipo5','tipo6','tipo7','tipo8')
data = list()
dmg = dict()
for mg in query:
for a in range(1,9):
if mg['arcmg'+str(a)]:
dmg = {'organismo':mg['organismo'],'dependencia':mg['dependencia'],'fec_creac':mg['fec_creac'],'usuario':mg['usuario'],'Descargar':mg['arcmg'+str(a)],'Tipo':mg['tipo'+str(a)]}
data.append(dmg)
tabla = MGTable(data)
config.configure(tabla)
tabla.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('extras/mg_consulta.html', {'formulario':formulario,'tabla':tabla,'dependencia':dependencia,}, context_instance=RequestContext(request),)
except:
raise Http404
def eventoquery(request):
form = EventoConsultaForm(request.GET)
usuario = request.user.get_profile()
query = Evento.objects.all()
if 'fechaini' in request.GET:
start_date = None
try:
start_date = ((request.GET['fechaini']) and
datetime.strptime(request.GET['fechaini'],"%d/%m/%Y") or None)
except:
pass
if start_date:
query = query.filter(fec_inicio=start_date)
#if start_date and end_date:
# query = query.filter(fec_inicio__gte=start_date, fec_termin__lte= end_date)
#elif start_date:
# query = query.filter(fec_inicio__gte=start_date)
#elif end_date:
# query = query.filter(fec_termin__lte=end_date)
if request.GET.get('titulo'):
query = query.filter(titulo__icontains=request.GET.get('titulo'))
if request.GET.get('organismo') and request.GET.get('dependencia'):
query = query.filter(organismo__codigo = request.GET.get('organismo'), dependencia = request.GET.get('dependencia'))
if request.GET.get('organismo'):
query = query.filter(organismo__codigo = request.GET.get('organismo'))
if request.GET.get('region') and request.GET.get('provincia') and request.GET.get('distrito'):
query = query.filter(region = request.GET.get('region'), provincia = request.GET.get('provincia'), distrito = request.GET.get('distrito'))
elif request.GET.get('region') and request.GET.get('provincia'):
query = query.filter(region = request.GET.get('region'), provincia = request.GET.get('provincia'))
elif request.GET.get('region'):
query = query.filter(region = request.GET.get('region'))
#query = query.filter(organismo__codigo = usuario.organismo_id,
# dependencia=usuario.dependencia)
table_eventos = EventoTable(query)
config = RequestConfig(request,paginate={"per_page": 10})
config.configure(table_eventos)
return render_to_response('calendar/consulta_actividad.html',
{'form':form,'table_eventos':table_eventos},context_instance=RequestContext(request))
def userquery(request, nivel):
col = "-nombres"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultausuarioform = ConsultaUsuarioForm(request.GET)
filtro = list()
usuarios = None
dependencia=0
if ('nombres' in request.GET and 'organismo' in request.GET and 'estado' in request.GET and 'apellidos' in request.GET) or 'dependencia' in request.GET:
if request.GET['nombres']:
usuarios = Usuario.objects.filter(nombres__icontains=request.GET['nombres'])
if request.GET['organismo']:
filtro.append(u"organismo_id =%s"%request.GET['organismo'])
if request.GET['estado']:
filtro.append(u"estado_id =%s"%request.GET['estado'])
if request.GET['apellidos']:
if usuarios:
usuarios = usuarios.filter(apellidos__icontains=request.GET['apellidos'])
else:
usuarios = Usuario.objects.filter(apellidos__icontains=request.GET['apellidos'])
if 'dependencia' in request.GET:
if request.GET['dependencia']:
filtro.append(u"dependencia =%s"%request.GET['dependencia'])
dependencia=request.GET['dependencia']
else:
usuarios = Usuario.objects.all()
filtro.append(u'numero >0')
filtro.append(u'nivel_id = '+nivel)
if usuarios is None:
usuarios = Usuario.objects.extra(where=filtro)
else:
usuarios = usuarios.extra(where=filtro)
usuarios = usuarios.extra(select={'dependencia':"case organismo_id when 1 then (select ministerio from ministerio where nummin=dependencia) when 2 then (select odp from odp where numodp=dependencia) when 3 then (select gobernacion from gobernacion where numgob=dependencia) end"})
tblusuarios = UsuarioTable(usuarios.order_by(col))
config.configure(tblusuarios)
tblusuarios.paginate(page=request.GET.get('page', 1), per_page=6)
return render_to_response('usuario/usuario_consulta.html', {'consultausuarioform':consultausuarioform,'tabla':tblusuarios,'dependencia':dependencia,'nivel':nivel,'mensaje':(request.GET['m'] if 'm' in request.GET else '')}, context_instance=RequestContext(request),)
def distritoquery(request):
col = "-distrito"
if "2-sort" in request.GET:
col = request.GET['2-sort']
config = RequestConfig(request)
consultadistritoform = ConsultaDistritoForm(request.GET)
if 'region' in request.GET and 'provincia' in request.GET and 'distrito' in request.GET:
print 'paso uno'
print request.GET['region']
print request.GET['provincia']
if request.GET['region'] and request.GET['provincia'] and request.GET['distrito']:
distritos = Distrito.objects.filter(distrito__icontains=request.GET['distrito'], provincia__numpro=request.GET['provincia'], region=request.GET['region']).order_by(col)
elif request.GET['region'] and request.GET['provincia']:
distritos = Distrito.objects.filter(provincia__numpro=request.GET['provincia'], region__numreg=request.GET['region']).order_by(col)
elif request.GET['region'] and request.GET['distrito']:
distritos = Distrito.objects.filter(distrito__icontains=request.GET['distrito'], region__numreg=request.GET['region']).order_by(col)
elif request.GET['region']:
distritos = Distrito.objects.filter(region__numreg=request.GET['region']).order_by(col)
elif request.GET['distrito']:
distritos = Distrito.objects.filter(distrito__icontains=request.GET['distrito']).order_by(col)
else:
distritos = Distrito.objects.all().order_by(col)
else:
distritos = Distrito.objects.all().order_by(col)
lista = list()
for d in distritos:
provincia = Provincia.objects.get(numpro=d.provincia_id, region=d.region)
dic = {'numdis': d.numdis, 'region': d.region, 'provincia': provincia, 'distrito': d.distrito, 'estado': d.estado }
lista.append(dic)
distritos = lista
tbldistritos = DistritoTable(distritos)
config.configure(tbldistritos)
tbldistritos.paginate(page=request.GET.get('page',1), per_page=6)
return render_to_response('ubigeo/distrito_consulta.html', {'consultadistritoform':consultadistritoform,'tabla':tbldistritos,'mensaje':(request.GET['m'] if 'm' in request.GET else '')}, context_instance=RequestContext(request),)
def meter_financial_values_table(request, meter):
s = get_object_or_404(Meter, meter_id=meter)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(MeterFinancialValueTable(s.financial_values()))
return HttpResponse(table.as_html(request))
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 10})
results = self.table_class(self.object_list)
config.configure(results)
return results
def meter_financial_value_items_table(request, meter_value_id):
s = get_object_or_404(MeterFinancialValue, meter_value_id=meter_value_id)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(MeterFinancialValueItemTable(s.meterfinancialvalueitem_set))
return HttpResponse(table.as_html(request))
def site_transactions_table(request, site):
check_entity_permission_or_not_allowed(site, request.user)
s = get_object_or_404(SiteView, entity_id=site)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(FinancialTransactionTable(s.transactions()))
return HttpResponse(table.as_html(request))
def product_list(request):
#f = ProductFilter(request.GET, queryset=Product.objects.all())
config = RequestConfig(request)
f = ProductTable(Product.objects.all(), prefix="1-")
config.configure(f)
return render(request, 'project/query.html', {'table': f})
def meter_transactions_table(request, meter):
s = get_object_or_404(Meter, meter_id=meter)
check_entity_permission_or_not_allowed(s.site_id, request.user)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(FinancialTransactionTable(s.transactions()))
return HttpResponse(table.as_html(request))
def showApplications(request):
config = RequestConfig(request)
# This more involved process is necessary to properly disclose sales that resulted in take backs.
soldProps = []
sp = Property.objects.filter(status__istartswith='Sold')
for s in sp:
soldProps.append({
'address':
s.streetAddress,
'parcel':
s.parcel,
'sale_date':
datetime.datetime.strptime(s.status[5:], '%m/%d/%Y').date(),
'buyer':
s.applicant,
'amount':
s.price,
})
tb = take_back.objects.all()
for t in tb:
soldProps.append({
'address': t.Property.streetAddress,
'parcel': t.Property.parcel,
'sale_date': t.original_sale_date,
'buyer': t.owner,
'amount': t.original_sale_price,
})
def takeDate(elem):
return elem['sale_date']
soldProps.sort(key=takeDate)
approvedProperties = Property.objects.all().filter(
status__istartswith='Sale').order_by('status', 'applicant')
next_rc_meeting = Meeting.objects.filter(
Q(meeting_type=Meeting.REVIEW_COMMITTEE)
& Q(meeting_date__gte=datetime.date.today())).order_by(
'meeting_date').first()
if next_rc_meeting is not None:
meeting_date = next_rc_meeting.meeting_date
reviewPendingProperties = Property.objects.filter(
application__meeting__meeting=next_rc_meeting).distinct().order_by(
'zipcode__name', 'streetAddress')
else:
meeting_date = 'future'
reviewPendingProperties = Property.objects.none().order_by(
'zipcode__name', 'streetAddress')
#soldFilter = ApplicationStatusFilters(
# request.GET, queryset=soldProperties, prefix="sold-")
approvedFilter = ApplicationStatusFilters(request.GET,
queryset=approvedProperties,
prefix="approved-")
reviewPendingFilter = ApplicationStatusFilters(
request.GET,
queryset=reviewPendingProperties,
prefix="review_pending-")
#soldTable = SoldPropertyStatusTable(soldFilter.qs, prefix="sold-")
soldTable = SoldPropertyStatusTable2(soldProps, prefix="sold-")
approvedTable = PropertyStatusTable(approvedFilter.qs, prefix="approved-")
reviewPendingTable = reviewPendingStatusTable(reviewPendingFilter.qs,
prefix="review_pending-")
config.configure(reviewPendingTable)
config.configure(soldTable)
config.configure(approvedTable)
export_format = request.GET.get('_export_format', None)
if export_format is not None:
if request.GET.get('sold_export', None):
exporter = TableExport(export_format, soldTable)
if request.GET.get('approved_export', None):
exporter = TableExport(export_format, approvedTable)
if request.GET.get('pending_export', None):
exporter = TableExport(export_format, reviewPendingTable)
if exporter is not None:
return exporter.response('table.{}'.format(export_format, ))
return render(
request,
'app_status_template.html',
{
'meeting':
meeting_date,
'reviewPendingTable':
reviewPendingTable,
'reviewPendingExport':
'{}?{}'.format(reverse("application_status"),
'pending_export=True&_export_format=csv'),
'soldTable':
soldTable,
'soldExport':
'{}?{}'.format(reverse("application_status"),
'sold_export=True&_export_format=csv'),
'approvedTable':
approvedTable,
'approvedExport':
'{}?{}'.format(reverse("application_status"),
'approved_export=True&_export_format=csv'),
'title':
'applications & sale activity',
# 'soldFilter': soldFilter,
'approvedFilter':
approvedFilter,
'reviewPendingFilter':
reviewPendingFilter,
})
def meter_transactions_table(request, meter):
s = get_object_or_404(Meter, meter_id=meter)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(FinancialTransactionTable(s.transactions()))
return HttpResponse(table.as_html(request))
def site_transactions_table(request, site):
s = get_object_or_404(SiteView, entity_id=site)
rc = RequestConfig(request, paginate={"per_page": 10})
table = rc.configure(FinancialTransactionTable(s.transactions()))
return HttpResponse(table.as_html(request))
def make_table(self):
config = RequestConfig(self.request, paginate={'per_page': 10})
results = self.table_class(self.object_list)
config.configure(results)
return results
