API tools faq
paste
Advertisement
slovacus

application.ini de clasificados

slovacus
Apr 4th, 2012
333
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.07 KB | None | 0 0
raw download clone embed print report
  1. ; params.ini config file
  2. ; cross-environment and application-specific config params.
  3. ; for environment-specific, zend framework related use appplication.ini
  4.  
  5. ; NOTA: Se consideró usar, mientras sea posible, consultas directa desde la app
  6. ; clasificados hacia las bases de datos de las demás aplicaciones con el fin de
  7. ; mantener independencia cuando se requiera modificar/aumentar/eliminar items
  8. ; de los listados.
  9. ; Por un tema de seguridad se consideró usar archivos de configuración en lugar
  10. ; de base de datos para poder almacenar la configuración del portal. Por lo cual
  11. ; no se dispone de un panel de administración.
  12.  
  13. [sites]
  14.  
  15. aptitus.url = 'http://aptitus.pe'
  16. aptitus.nombre = aptitus
  17. aptitus.queryStringBusqueda = '/buscar/query/%s'
  18. aptitus.baseLinkUrl = '/buscar/areas/%s?ref=ecc'
  19. aptitus.ubigeoBaseLinkUrl = '%s'
  20.  
  21. ;aptitus.baseLinksSql = "SELECT 'Marketing' as nombre, 'marketing' as routeparam, 856 as n UNION SELECT 'Ingenieria', 'ingenieria', 731 UNION SELECT 'Operaciones', 'operaciones', 952 UNION SELECT 'Otros', 'otros', 1485 {%ubigeo%};"
  22. aptitus.baseLinksSql = "SELECT a.nombre, count(aw.id_area) as n, concat('/buscar/ubicacion/',replace(u.search_name,' ', '-'),'/areas/',a.slug) as link FROM area a JOIN anuncio_web aw ON a.id=aw.id_area JOIN ubigeo u ON u.id=aw.id_ubigeo WHERE a.id IN (1,2,4,3,5,12,8,10,11,13,14,19,16,9,17,18,21,23,24,25) AND aw.online=1 {%ubigeo%} GROUP BY aw.id_area ORDER BY a.nombre;"
  23. aptitus.ubigeoLinkSql ="SELECT concat('/buscar/ubicacion/',replace(u.search_name,' ', '-')) AS routeparam from ubigeo u where u.nombre is not null {%ubigeo%};"
  24.  
  25. ;aptitus.ubicacion.home = " AND u.padre = 3926 "
  26. aptitus.ubicacion.lima = " AND u.padre = 3927 "
  27. aptitus.ubicacion.miraflores = " AND u.id = 3949 "
  28. aptitus.ubicacion.san-isidro = " AND u.id = 3958 "
  29. aptitus.ubicacion.santiago-de-surco = " AND u.id = 3967 "
  30. aptitus.ubicacion.san-borja = " AND u.id = 3957 "
  31. aptitus.ubicacion.san-miguel = " AND u.id = 3963 "
  32. aptitus.ubicacion.la-molina = " AND u.id = 3941 "
  33. aptitus.ubicacion.cercado-de-lima = " AND u.id = 3928 "
  34. aptitus.ubicacion.otros-distritos-de-lima = " AND u.padre in (3927) and u.id not in (3927,3949,3958,3967,3957,3963,3941,3928) "
  35.  
  36. aptitus.ubicacion.callao = " AND u.id = 3285 "
  37.  
  38. aptitus.ubicacion.arequipa = " AND u.id = 2900 "
  39. aptitus.ubicacion.chiclayo = " AND u.id = 3885 "
  40. aptitus.ubicacion.piura = " AND u.id = 4236 "
  41. aptitus.ubicacion.trujillo = " AND u.id = 3789 "
  42.  
  43. aptitus.ubicacion.otras-ciudades = " AND u.padre not in (3927,3285,3789,2900,3885,4236) "
  44.  
  45.  
  46. ;aptitus.totalPublicadosSql = 'SELECT 7321 {%ubigeo%} ;'
  47. ;aptitus.extralink.0.nombre = 'Alta Gerencia 1'
  48. ;aptitus.extralink.0.link = '/buscar/nivel/alta-gerencia1'
  49. ;aptitus.extralink.0.countsql = 'SELECT 123 {%ubigeo%} ;'
  50. ;aptitus.extralink.1.nombre = 'Alta Gerencia 2'
  51. ;aptitus.extralink.1.link = '/buscar/nivel/alta-gerencia2'
  52. ;aptitus.extralink.1.countsql = 'SELECT 234 {%ubigeo%} ;'
  53. ;aptitus.extralink.2.nombre = 'Alta Gerencia 3'
  54. ;aptitus.extralink.2.link = '/buscar/nivel/alta-gerencia3'
  55. ;aptitus.extralink.2.countsql = 'SELECT 345 {%ubigeo%} ;'
  56.  
  57. urbania.url = 'http://urbania.pe'
  58. urbania.nombre = urbania
  59. urbania.queryStringBusqueda = '/alquiler/busqueda/%s'
  60. urbania.baseLinkUrl = '%s'
  61. urbania.ubigeoBaseLinkUrl = '/alquiler/inmuebles-en-%s-en-lima-1'
  62. ;urbania.baseLinksSql = "SELECT 'Casas' as nombre, 'casas' as routeparam, 654 as n UNION SELECT 'Departamentos', 'departamentos', 321 UNION SELECT 'Habitaciones', 'habitaciones', 634 UNION SELECT 'Locales', 'locales', 346 UNION SELECT 'Oficinas', 'oficinas', 11 UNION SELECT 'Terrenos', 'terrenos', 745 {%ubigeo%};"
  63. ;urbania.baseLinksSql = "SELECT (case when (i.parent=6) then concat('Habitaciones en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=4) then concat('Locales Comerciales en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=14) then concat('Oficinas en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=1) then concat('Terrenos en ',if(i.type=1,'Venta','Alquiler')) else concat('Departamentos y Casas en ',if(i.type=1,'Venta','Alquiler')) end ) as nombre, count(i.id) as n, concat(if(i.type=1,'/venta/','/alquiler/'), (case when (i.parent=6) then 'habitaciones' when (i.parent=4) then 'locales' when (i.parent=14) then 'oficinas' when (i.parent=1) then 'terrenos' else 'casas-departamentos' end ), '-en-',replace(ly.alias,' ', '-'),'-en-',replace(sd.alias,' ', '-'),'-1') as routeparam FROM tb_properties_products AS i INNER JOIN tb_properties_profiles AS pf ON i.extra10 = pf.id inner join tb_properties_locality as ly on ly.id = i.lid inner join tb_properties_state as sd on sd.id = ly.parent LEFT JOIN tb_detalle_paquete AS dp ON dp.tb_properties_products_id = i.id WHERE (i.extra39 = 0) AND (i.published = 1 OR i.published = 4) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.type in (1,2)) AND (i.parent in (1,3,4,5,6,14)) {%ubigeo%} group by nombre UNION SELECT 'Casas de Playa' as nombre, count(i.id) as n, '/alquiler/inmuebles-de-playa' as routeparam FROM `tb_properties_products` AS `i` INNER JOIN `tb_properties_playa` AS `pl` ON i.uid = pl.id INNER JOIN `tb_properties_profiles` AS `pf` ON i.extra10 = pf.id LEFT JOIN `tb_detalle_paquete` AS `dp` ON dp.tb_properties_products_id = i.id WHERE (i.uid > 0) AND (i.extra39 = 0) AND (i.published = 1 OR i.published = 4) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.type = 2) AND (i.parent = 3 OR i.parent = 5 OR i.parent = 6 OR i.parent = 4 OR i.parent = 14 OR i.parent = 1) UNION SELECT 'Proyectos Inmobiliarios' as nombre, count(distinct p.id) as n, concat('/venta/inmuebles-de-estreno-en-',replace(ly.alias,' ', '-'),'-en-',replace(sd.alias,' ', '-'),'-2') as routeparam FROM `tb_properties_projects` AS `p` inner join `tb_properties_products` AS `i` ON p.id = i.extra39 INNER JOIN `tb_properties_project_type` AS `tp` ON tp.tb_properties_proyects_id = p.id INNER JOIN `tb_properties_profiles` AS `pf` ON p.tb_properties_profile_id = pf.id inner join tb_properties_locality as ly on ly.id = p.locality_id inner join tb_properties_state as sd on sd.id = ly.parent INNER JOIN `tb_ente` AS `e` ON pf.iddocumento = e.id WHERE (p.published = 1) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.parent = 3 OR i.parent = 5 OR i.parent = 14) {%ubigeo%} GROUP BY nombre"
  64. urbania.baseLinksSql = "SELECT (case when (i.parent=6) then concat('Habitaciones en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=4) then concat('Locales Comerciales en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=14) then concat('Oficinas en ',if(i.type=1,'Venta','Alquiler')) when (i.parent=1) then concat('Terrenos en ',if(i.type=1,'Venta','Alquiler')) else concat('Departamentos y Casas en ',if(i.type=1,'Venta','Alquiler')) end ) as nombre, count(i.id) as n, concat(if(i.type=1,concat('|','/venta/'),concat('|','/alquiler/')), (case when (i.parent=6) then concat('|','habitaciones' )when (i.parent=4) then concat('|','locales') when (i.parent=14) then concat('|','oficinas' )when (i.parent=1) then concat('|','terrenos' )else concat('|','casas-departamentos') end ), concat('|','-en-'),concat('|',replace(ly.alias,' ', '-')),'-en-',replace(sd.alias,' ', '-'),'-1') as routeparam FROM tb_properties_products AS i INNER JOIN tb_properties_profiles AS pf ON i.extra10 = pf.id inner join tb_properties_locality as ly on ly.id = i.lid inner join tb_properties_state as sd on sd.id = ly.parent LEFT JOIN tb_detalle_paquete AS dp ON dp.tb_properties_products_id = i.id WHERE (i.extra39 = 0) AND (i.published = 1 OR i.published = 4) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.type in (1,2)) AND (i.parent in (1,3,4,5,6,14)) {%ubigeo%} group by nombre UNION SELECT 'Casas de Playa' as nombre, count(i.id) as n, concat('|','/alquiler' ,'|' ,'/inmuebles' ,'|','-de-playa') as routeparam FROM `tb_properties_products` AS `i` INNER JOIN `tb_properties_playa` AS `pl` ON i.uid = pl.id INNER JOIN `tb_properties_profiles` AS `pf` ON i.extra10 = pf.id LEFT JOIN `tb_detalle_paquete` AS `dp` ON dp.tb_properties_products_id = i.id WHERE (i.uid > 0) AND (i.extra39 = 0) AND (i.published = 1 OR i.published = 4) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.type = 2) AND (i.parent = 3 OR i.parent = 5 OR i.parent = 6 OR i.parent = 4 OR i.parent = 14 OR i.parent = 1) UNION SELECT 'Proyectos Inmobiliarios' as nombre, count(distinct p.id) as n, concat('|','/venta','|', '/inmuebles-de-estreno-en-',concat('|',replace(ly.alias,' ', '-')),'-en-',replace(sd.alias,' ', '-'),'-2') as routeparam FROM `tb_properties_projects` AS `p` inner join `tb_properties_products` AS `i` ON p.id = i.extra39 INNER JOIN `tb_properties_project_type` AS `tp` ON tp.tb_properties_proyects_id = p.id INNER JOIN `tb_properties_profiles` AS `pf` ON p.tb_properties_profile_id = pf.id inner join tb_properties_locality as ly on ly.id = p.locality_id inner join tb_properties_state as sd on sd.id = ly.parent INNER JOIN `tb_ente` AS `e` ON pf.iddocumento = e.id WHERE (p.published = 1) AND (pf.status = 0) AND (pf.iddocumento > 0) AND (i.parent = 3 OR i.parent = 5 OR i.parent = 14) {%ubigeo%} GROUP BY nombre;"
  65. urbania.ubigeoLinkSql ="SELECT replace(ly.alias,' ', '-') AS routeparam from tb_properties_locality ly where ly.name is not null {%ubigeo%};"
  66.  
  67. urbania.ubicacion.home = "-- (ubigeo) "
  68. urbania.ubicacion.lima = " AND (ly.parent = 1) "
  69. urbania.ubicacion.miraflores = " AND (ly.id = 19) "
  70. urbania.ubicacion.san-isidro = " AND (ly.id = 28) "
  71. urbania.ubicacion.san-borja = " AND (ly.id = 46) "
  72. urbania.ubicacion.san-miguel = " AND (ly.id = 47) "
  73. urbania.ubicacion.santiago-de-surco = " AND (ly.id = 2) "
  74. urbania.ubicacion.la-molina = " AND (ly.id = 14) "
  75. urbania.ubicacion.cercado-de-lima = " AND (ly.id = 1) "
  76. urbania.ubicacion.otros-distritos-de-lima = " AND ly.id not in (1,19,28,46,47,2,14) "
  77. urbania.ubicacion.callao = " AND (ly.parent = 41) "
  78. urbania.ubicacion.arequipa = " AND (ly.parent = 74) "
  79. urbania.ubicacion.chiclayo = " AND (ly.parent = 114) "
  80. urbania.ubicacion.piura = " AND (ly.parent = 91) "
  81. urbania.ubicacion.trujillo = " AND (ly.parent = 108) "
  82. urbania.ubicacion.otras-ciudades = " AND ly.parent not in (1,2,18,25,16,26) "
  83. ;urbania.totalPublicadosSql = 'SELECT 8323 {%ubigeo%} ;'
  84. ;urbania.extralink.0.nombre = 'Todo Alquiler'
  85. ;urbania.extralink.0.link = '/alquiler/inmuebles'
  86. ;urbania.extralink.0.countsql = 'SELECT 555 {%ubigeo%} ;'
  87. ;urbania.extralink.1.nombre = 'Casas de Playas'
  88. ;urbania.extralink.1.link = '/casas-de-playa'
  89. ;urbania.extralink.1.countsql = 'SELECT 67 {%ubigeo%} ;'
  90. ;urbania.extralink.2.nombre = 'Proyectos'
  91. ;urbania.extralink.2.link = '/venta/de-estreno'
  92. ;urbania.extralink.2.countsql = 'SELECT 28 {%ubigeo%} ;'
  93.  
  94. neoauto.url = 'http://neoauto.pe'
  95. neoauto.nombre = neoauto
  96. neoauto.queryStringBusqueda = '/venta/?texto=%s'
  97. neoauto.baseLinkUrl = '/venta/%s'
  98. neoauto.ubigeoBaseLinkUrl = '/venta/%s'
  99. ;neoauto.baseLinksSql = "SELECT 'Toyota' as nombre, 'toyota' as routeparam, 654 as n UNION SELECT 'Nissan', 'nissan', 321 UNION SELECT 'Volkswagen', 'volkswagen', 634 UNION SELECT 'Hyundai', 'hyundai', 346 UNION SELECT 'Honda', 'honda', 11 UNION SELECT 'Suzuki', 'susuki', 745 UNION SELECT 'Volvo', 'volvo', 52 {%ubigeo%};"
  100. ;neoauto.baseLinksSql = "SELECT t.name AS nombre, COUNT(a.id) AS n, concat(t.slug_search,'-en-',u.slug_search) AS routeparam FROM neoauto_cartype t INNER JOIN neoauto_carmodel m ON m.type_id = t.id INNER JOIN neoauto_car c ON c.model_id=m.id INNER JOIN neoauto_carad a ON a.car_id = c.id INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND t.id IN (5,6,7,8,9,10,11) {%ubigeo%} GROUP BY (t.name) UNION ALL SELECT b.name AS nombre , COUNT(a.id) AS n , concat(b.slug_search,'-en-',u.slug_search) AS routeparam FROM neoauto_carbrand b INNER JOIN neoauto_carmodel m ON m.brand_id = b.id INNER JOIN neoauto_car c ON c.model_id=m.id INNER JOIN neoauto_carad a ON a.car_id = c.id INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND b.id IN (403,309,189,287,433,36,240,181) {%ubigeo%} GROUP BY (b.name)"
  101. neoauto.baseLinksSql = "SELECT t.name AS nombre, COUNT(a.id) AS n,
  102. concat('|',t.slug_search,'|','-en-','|',u.slug_search) AS routeparam
  103. FROM neoauto_cartype t INNER JOIN neoauto_carmodel m ON m.type_id = t.id INNER JOIN neoauto_car c
  104. ON c.model_id=m.id
  105. INNER JOIN neoauto_carad a ON a.car_id = c.id
  106. INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND
  107. t.id IN (5,6,7,8,9,10,11) {%ubigeo%}
  108. GROUP BY (t.name)
  109. UNION ALL SELECT
  110. b.name AS nombre , COUNT(a.id) AS n , concat('|',b.slug_search,'|','-en-','|',u.slug_search) AS routeparam
  111. FROM neoauto_carbrand b
  112. INNER JOIN neoauto_carmodel m ON m.brand_id = b.id
  113. INNER JOIN neoauto_car c ON c.model_id=m.id
  114. INNER JOIN neoauto_carad a ON a.car_id = c.id
  115. INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND
  116. b.id IN (403,309,189,287,433,36,240,181) {%ubigeo%}
  117. GROUP BY (b.name);"
  118. neoauto.ubigeoLinkSql ="select concat('-en-',u.slug_search) AS routeparam from locations_location as u where u.slug_search is not null {%ubigeo%} "
  119. neoauto.baseUbigeoLinksSql ="SELECT u.slug_search AS routeparam
  120. FROM neoauto_cartype t INNER JOIN neoauto_carmodel m ON m.type_id = t.id INNER JOIN neoauto_car c
  121. ON c.model_id=m.id
  122. INNER JOIN neoauto_carad a ON a.car_id = c.id
  123. INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND
  124. t.id IN (5,6,7,8,9,10,11)
  125. {%ubigeo%}
  126. GROUP BY (u.slug_search)
  127. UNION ALL SELECT
  128. u.slug_search AS routeparam
  129. FROM neoauto_carbrand b
  130. INNER JOIN neoauto_carmodel m ON m.brand_id = b.id
  131. INNER JOIN neoauto_car c ON c.model_id=m.id
  132. INNER JOIN neoauto_carad a ON a.car_id = c.id
  133. INNER JOIN locations_location u ON u.id = a.location_id WHERE a.STATUS = 3 AND
  134. b.id IN (403,309,189,287,433,36,240,181)
  135. {%ubigeo%}
  136. GROUP BY (u.slug_search) "
  137. neoauto.ubicacion.home = "-- (ubigeo)"
  138. neoauto.ubicacion.lima = " AND u.parent_id = 3927 AND u.id in (3949,3958,3967,3957,3963,3941,3928) "
  139. neoauto.ubicacion.miraflores = " AND u.id = 3949"
  140. neoauto.ubicacion.san-isidro = " AND u.id = 3958"
  141. neoauto.ubicacion.santiago-de-surco = " AND u.id = 3967"
  142. neoauto.ubicacion.san-borja = " AND u.id = 3957"
  143. neoauto.ubicacion.san-miguel = " AND u.id = 3963"
  144. neoauto.ubicacion.la-molina = " AND u.id = 3941"
  145. neoauto.ubicacion.cercado-de-lima = " AND u.id = 3928"
  146. neoauto.ubicacion.otros-distritos-de-lima = " AND u.parent_id in (3927) AND u.id not in (3926,3949,3958,39673957,3963,3941,3928) "
  147. neoauto.ubicacion.callao = " AND u.id = 3285"
  148. neoauto.ubicacion.arequipa = " AND u.id = 2901"
  149. neoauto.ubicacion.chiclayo = " AND u.id = 3885"
  150. neoauto.ubicacion.piura = " AND u.id = 4237"
  151. neoauto.ubicacion.trujillo = " AND u.id = 3789"
  152. neoauto.ubicacion.otras-ciudades = " AND u.id not in (3926) and u.parent_id not in (3927,3285,2901,3885,4237,3789) "
  153. ;neoauto.totalPublicadosSql = 'SELECT 8323 {%ubigeo%} ;'
  154. ;neoauto.totalPublicadosSql = 'SELECT 8323 ;'
  155. neoauto.extralink.0.nombre = 'Venta Usados'
  156. neoauto.extralink.0.link = '/venta/usados'
  157. ;neoauto.extralink.0.countsql = 'SELECT 5525 {%ubigeo%} ;'
  158. neoauto.extralink.1.nombre = 'Venta Nuevos'
  159. neoauto.extralink.1.link = '/venta/nuevos'
  160. ;neoauto.extralink.1.countsql = 'SELECT 2676 {%ubigeo%} ;'
  161.  
  162. guiagps.url = 'http://guiagps.pe'
  163. guiagps.nombre = guiagps
  164. guiagps.queryStringBusqueda = '/restaurantes/busqueda?abuscar=%s'
  165. guiagps.baseLinkUrl = '/restaurantes/%s'
  166. guiagps.ubigeoBaseLinkUrl = '/restaurantes/%s'
  167. guiagps.baseLinksSql = "SELECT cast(v.STR_VALOR as char character set utf8) as nombre,
  168. COUNT(distinct ce.txt_rznsoc_nombre) as n,
  169. CAST(
  170. CONCAT(v.STR_VALOR,'|',u.TXT_NOMBRE_DEPARTAMENTO,'|',
  171. u.TXT_NOMBRE_PROVINCIA,'|',
  172. IF(2>0,u.TXT_NOMBRE_DISTRITO,''),'?',
  173. '|', u.ID_DEPARTAMENTO ,
  174. '|',u.ID_PROVINCIA,
  175. '|',f.ID_VALOR,
  176. '|', IF(2>0,u.ID_DISTRITO,'')
  177. )AS CHAR CHARACTER SET utf8) AS routeparam
  178. FROM cnf_valor v
  179. INNER JOIN fic_rest_param f ON v.ID_VALOR = f.ID_VALOR
  180. INNER JOIN fic_ficha_ente fi ON f.ID_FICHA = fi.ID_FICHA
  181. INNER JOIN cnf_ente as ce ON ce.id_ente = fi.id_ente
  182. INNER JOIN fic_rest_ficha res ON f.ID_FICHA = res.ID_FICHA AND f.ID_REST_FICHA = res.ID_REST_FICHA
  183. INNER JOIN fic_ubigeo u ON res.ID_UBIGEO_DE = u.ID_DEPARTAMENTO AND res.ID_UBIGEO_PR = u.ID_PROVINCIA
  184. AND res.ID_UBIGEO_DI = u.ID_DISTRITO
  185. WHERE v.ID_PARAMETRO='22' AND f.ID_VALOR IN (19, 277, 280, 288, 291, 295, 297, 315, 1017, 1021)
  186. AND fi.ID_ESTADO='6' AND fi.ID_FICHA_EDITADA=0
  187. {%ubigeo%}
  188. AND fi.ID_TIPO_SITE='2'
  189. GROUP BY f.ID_VALOR"
  190. guiagps.ubigeoLinkSql ="select CAST(
  191. CONCAT('|',
  192. u.TXT_NOMBRE_DEPARTAMENTO,'|',
  193. u.TXT_NOMBRE_PROVINCIA ,'|',
  194. '?', '|',
  195. 'cmbDepartamento=','|',u.ID_DEPARTAMENTO ,'|' ,
  196. '&cmbProvincia=', '|' ,u.ID_PROVINCIA, '|',
  197. '&cmbDistrito[]=', '|', IF(u.ID_DISTRITO >0,u.ID_DISTRITO,'')
  198. ) AS CHAR CHARACTER SET utf8) as routeparam
  199. from fic_ubigeo as u WHERE u.txt_nombre_departamento is not null
  200. {%ubigeo%} limit 1"
  201. guiagps.ubicacion.home = "-- (ubigeo)"
  202. guiagps.ubicacion.lima = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' "
  203. guiagps.ubicacion.miraflores = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =22, u.ID_PROVINCIA = '1' )) "
  204. guiagps.ubicacion.san-isidro = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =31, u.ID_PROVINCIA = '1' )) "
  205. guiagps.ubicacion.san-borja = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =30, u.ID_PROVINCIA = '1' )) "
  206. guiagps.ubicacion.san-miguel = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =36, u.ID_PROVINCIA = '1' )) "
  207. guiagps.ubicacion.la-molina = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =14, u.ID_PROVINCIA = '1' )) "
  208. guiagps.ubicacion.santiago-de-surco =" AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =40, u.ID_PROVINCIA = '1' )) "
  209. guiagps.ubicacion.cercado-de-lima = " AND u.ID_DEPARTAMENTO='15' AND u.ID_PROVINCIA='1' AND (IF(IFNULL(2, 0)>0, u.ID_DISTRITO =1, u.ID_PROVINCIA = '1' )) "
  210. guiagps.ubicacion.otros-distritos-de-lima = " AND u.ID_DEPARTAMENTO='15'
  211. AND u.ID_PROVINCIA='1'
  212. AND u.ID_DISTRITO NOT IN (1,22,31,30,36,14,40) "
  213. guiagps.ubicacion.callao = " AND u.ID_DEPARTAMENTO='7' AND u.ID_PROVINCIA='1' "
  214. guiagps.ubicacion.arequipa = " AND u.ID_DEPARTAMENTO='4' AND u.ID_PROVINCIA='1' "
  215. guiagps.ubicacion.trujillo = " AND u.ID_DEPARTAMENTO='13' AND u.ID_PROVINCIA='1' "
  216. guiagps.ubicacion.chiclayo = " AND u.ID_DEPARTAMENTO='14' AND u.ID_PROVINCIA='1' "
  217. guiagps.ubicacion.piura = " AND u.ID_DEPARTAMENTO='20' AND u.ID_PROVINCIA='1' "
  218. guiagps.ubicacion.otras-ciudades = " AND u.ID_DEPARTAMENTO NOT IN (7,4,13,14,20,15)"
  219. ;guiagps.totalPublicadosSql = 'SELECT 8323 ;'
  220. ;guiagps.extralink.0.nombre = 'Promociones'
  221. ;guiagps.extralink.0.link = '/restaurantes/ofertas_promociones'
  222. ;guiagps.extralink.0.countsql = 'SELECT 5 ;'
  223. ;guiagps.extralink.1.nombre = 'Mapa de Restaurantes'
  224. ;guiagps.extralink.1.link = '/restaurantes/mapa_restaurantes'
  225.  
  226.  
  227. kotear.url = 'http://kotear.pe'
  228. kotear.nombre = kotear
  229. kotear.queryStringBusqueda = '/busqueda/?q=%s'
  230. kotear.ubigeoBaseLinkUrl = '/busqueda/?q&categs=%s'
  231. kotear.baseLinkUrl = '/busqueda/?q&categs=/%s'
  232. ;kotear.baseLinksSql = "SELECT 'Animales y Mascotas' as nombre, '217-animales-y-mascotas' as routeparam, 220 as n UNION SELECT 'Antigüedades, Artesanías', '219-antigüedades-arte-y-artesanias', 423 UNION SELECT 'Celulares, Telefonía y Faxes', '237-celulares-telefonia-y-faxes', 3731 UNION SELECT 'Coleccionables y Hobbies', '243-coleccionables-y-hobbies', 2892 {%ubigeo%};"
  233. kotear.baseLinksSql = "SELECT agr.L1_NOM AS nombre, COUNT(agr.L1) AS n, CONVERT(VARCHAR(6),agr.L1) + '?&ub='+CONVERT(VARCHAR(6),avi.ID_UBIGEO) +'&ubic[]='+CONVERT(VARCHAR(6),avi.ID_UBIGEO) AS routeparam FROM KO_AVISO_CATEGORIA acat INNER JOIN KO_AVISO avi ON avi.ID_AVISO=acat.ID_AVISO AND avi.EST=1 INNER JOIN KO_AGRUPADOR agr ON agr.L1 IN (231,221,237,243,235,208,228,234,226,233,232,244,230,1909, 229,1621,219,247,1381,241,217,3489) AND (acat.ID_CATEGORIA=agr.ID_CATEGORIA) AND avi.FLAG_MODERACION=0 AND FLAG_MODERACION_ADMIN=0 AND FEC_FIN>GETDATE() {%ubigeo%} GROUP BY agr.L1_NOM,agr.L1 , avi.ID_UBIGEO"
  234. kotear.ubigeoLinkSql ="-- {%ubigeo%} "
  235. kotear.ubicacion.home = "-- (ubigeo)"
  236. kotear.ubicacion.lima = " AND avi.ID_UBIGEO = 15 "
  237. kotear.ubicacion.miraflores = " AND avi.ID_UBIGEO = 15 "
  238. kotear.ubicacion.san-isidro = " AND avi.ID_UBIGEO = 15 "
  239. kotear.ubicacion.san-borja = " AND avi.ID_UBIGEO = 15 "
  240. kotear.ubicacion.san-miguel = " AND avi.ID_UBIGEO = 15 "
  241. kotear.ubicacion.la-molina = " AND avi.ID_UBIGEO = 15 "
  242. kotear.ubicacion.santiago-de-surco = " AND avi.ID_UBIGEO = 15 "
  243. kotear.ubicacion.cercado-de-lima = " AND avi.ID_UBIGEO = 15 "
  244. kotear.ubicacion.otros-distritos-de-lima = " AND avi.ID_UBIGEO = 15 "
  245. kotear.ubicacion.callao = " AND avi.ID_UBIGEO = 7 "
  246. kotear.ubicacion.arequipa = " AND avi.ID_UBIGEO = 4 "
  247. kotear.ubicacion.trujillo = " AND avi.ID_UBIGEO = 13 "
  248. kotear.ubicacion.chiclayo = " AND avi.ID_UBIGEO = 14 "
  249. kotear.ubicacion.piura = " AND avi.ID_UBIGEO = 20 "
  250. kotear.ubicacion.otras-ciudades = " AND avi.ID_UBIGEO NOT IN (20,14,13,4,7,15) "
  251. ;kotear.totalPublicadosSql = 'SELECT 8323 -- {%ubigeo%} ;'
  252. ;kotear.extralink.0.nombre = 'Promociones'
  253. ;kotear.extralink.0.link = '/restaurantes/ofertas_promociones'
  254. ;kotear.extralink.0.countsql = 'SELECT 5 -- {%ubigeo%} ;'
  255. ;kotear.extralink.1.nombre = 'Mapa de Restaurantes'
  256. ;kotear.extralink.1.link = '/restaurantes/mapa_restaurantes'
  257.  
  258. [ubicaciones]
  259.  
  260. lima.nombre = "Lima" ; opcional (Si no se define nombre, aplica un ucwords al indice)
  261. lima.slug = 'lima' ; opcional (Si no se define slug, se toma el indice como slug)
  262. lima.nodos.miraflores[] =
  263. lima.nodos.san-isidro[] =
  264. lima.nodos.santiago-de-surco.nombre = "Santiago de Surco"
  265. lima.nodos.san-borja[] =
  266. lima.nodos.san-miguel[] =
  267. lima.nodos.la-molina[] =
  268. lima.nodos.cercado-de-lima.nombre = "Cercado de Lima"
  269. lima.nodos.otros-distritos-de-lima.nombre = "Otros Distritos de Lima"
  270. callao[] =
  271. arequipa[] =
  272. arequipa[] =
  273. chiclayo[] =
  274. piura[] =
  275. trujillo[] =
  276. otras-ciudades[] =
  277.  
  278. [default]
  279. site = none
  280. ubicacion = lima
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!