zazk

var http = require("http"),
    url = require("url"),
    path = require("path"),
    dir = require('node-dir'),
    swig  = require('swig'),
    fs = require("fs"),

    SERVER = "server",
    BUILD = "build",

zazk

-- Create Sequence
CREATE SEQUENCE USU_seq;
-- Create Trigger to manage fake autoincrement
CREATE OR REPLACE TRIGGER usu_bir  
BEFORE INSERT ON geo_usuarios 
FOR EACH ROW

BEGIN
  -- select next index from our sequence
  SELECT usu_seq.NEXTVAL

zazk

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>pe.gob.mimp</groupId>
    <artifactId>gis</artifactId>
    <packaging>war</packaging>
    <version>1.0.0-SNAPSHOT</version>
    <name>MIMP GIS 1.0.0-SNAPSHOT</name>

zazk

CREATE OR REPLACE
procedure  DROP_ALL_SCHEMA_OBJECTS AS
PRAGMA AUTONOMOUS_TRANSACTION;
cursor c_get_objects is
  select object_type,'"'||object_name||'"'||decode(object_type,'TABLE' ,' cascade constraints',null) obj_name
  FROM USER_OBJECTS
  where object_type in ('TABLE','VIEW','PACKAGE','SEQUENCE','SYNONYM', 'MATERIALIZED VIEW', 'TYPE')
  order by object_type;
BEGIN
  begin

zazk

SELECT SUBSTR (SYS_CONNECT_BY_PATH (id_reporte , ','), 2) csv
      FROM (SELECT id_reporte , ROW_NUMBER () OVER (ORDER BY id_reporte ) rn,
                   COUNT (*) OVER () cnt
              FROM geo_reporte_servicios WHERE ANO='2014' AND COD_CA='CEM001' AND UBIGEO='030101' AND COD_SERV='SER001')
     WHERE rn = cnt
START WITH rn = 1
CONNECT BY rn = PRIOR rn + 1

--RESULT
-- 2163,2165,2167,2169,2171,2173,2175,2177,2179,2181,2183,2185

zazk

package pe.gob.mimp.gis.dao.impl;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import pe.gob.mimp.gis.dao.ExcelReaderDao;
import pe.gob.mimp.gis.entity.ExcelReader;
import java.util.HashMap;

zazk

UPDATE geo_reporte_servicios SET COD_ENTIDAD = 'ENT001',COD_LINEA = 'LIN001',COD_SERV = 'SER002',COD_CA = 'CAI001',NUM_BEN_EJEC1 = '',NUM_BEN_EJEC1_H = 111,NUM_BEN_EJEC1_M = '',NUM_BEN_EJEC2 = '',NUM_BEN_EJEC2_H = '',NUM_BEN_EJEC2_M = '',NUM_BEN_EJEC3 = '',NUM_BEN_EJEC4 = '',NUM_BEN_EJEC5 = '',NUM_BEN_EJEC6 = '',NUM_BEN_EJEC6_H = '',NUM_BEN_EJEC6_M = '',NUM_GRUP_EDAD0 = '',NUM_GRUP_EDAD0_H = '',NUM_GRUP_EDAD0_M = '',NUM_GRUP_EDAD1 = '',NUM_GRUP_EDAD1_H = '',NUM_GRUP_EDAD1_M = '',NUM_GRUP_EDAD2 = '',NUM_GRUP_EDAD2_H = '',NUM_GRUP_EDAD2_M = '',NUM_GRUP_EDAD3 = '',NUM_GRUP_EDAD3_H = '',NUM_GRUP_EDAD3_M = '',NUM_GRUP_EDAD4 = '',NUM_GRUP_EDAD4_H = 2,NUM_GRUP_EDAD4_M = '',NUM_GRUP_EDAD5 = '',NUM_GRUP_EDAD5_H = 20,NUM_GRUP_EDAD5_M = '',NUM_GRUP_EDAD6 = '',NUM_GRUP_EDAD6_H = 42,NUM_GRUP_EDAD6_M = '',NUM_GRUP_EDAD7 = '',NUM_GRUP_EDAD7_H = 34,NUM_GRUP_EDAD7_M = '',NUM_GRUP_EDAD8 = '',NUM_GRUP_EDAD8_H = 13,NUM_GRUP_EDAD8_M = '',NUM_INDICADOR1 = 3071,NUM_INDICADOR2 = '',NUM_INDICADOR3 = '',NUM_INDICADOR4 = '',NUM_INDICAD

zazk

// Función cuando carga la página - OPCIONAL
$(function(){

// Animacion -------------------------------------------------
     // Para todos los enlaces - Modificar el selector css que necesite
     $('a[href*=#]').click(function() {
     
     // Validar los "/" 
     if (location.pathname.replace(/^\//,'') == this.pathname.replace(/^\//,'')
         && location.hostname == this.hostname) {

zazk

var gulp = require('gulp'),
  sass = require('gulp-sass'),
  browserify = require('gulp-browserify'),
  concat = require('gulp-concat'),
  embedlr = require('gulp-embedlr'),
  refresh = require('gulp-livereload'),
  lrserver = require('tiny-lr')(),
  express = require('express'),
  livereload = require('connect-livereload')
  livereloadport = 35729,

zazk

//
//  UIColor+HexString.h
//  Class to convert hex string to UIColor
//  Support #RGB # ARGB #RRGGBB #AARRGGBB
//  Usage: [UIColor colorWithHexString:@"#f5e6a1"];
//  Created by Zhu Yuzhou on 1/20/13.
//

#import <UIKit/UIKit.h>