} else { if ($debug) { echo "VOY A RECUPERAR EL ID DE UNA NUEVA INICIATIVA REGISTRADA: " . $ini_name_registered . "<br>"; } $ini_id = getIdFromIniciative($ini_name_registered); if ($debug) { echo "ID de iniciativa ya registrada (" . $ini_name_registered . "): " . $ini_id . "<br>"; } } //Meta Datos $delivery_date_time = time(); $ev_c_date = date("j/n/Y", $delivery_date_time); /** * Configurar alerta correo electrónico */ $texToMailAlert = "MIME_VERSION: 1.0\r\n"; $texToMailAlert .= "Content-type: text/html; charset=UTF-8\r\n"; $texToMailAlert .= "From: Formulario Actividades Civic"; $mail_to = "*****@*****.**"; $mail_subject = "Nueva actividad en " . $ini_city; $mail_body = "<b> Iniciativa: " . $ini_name_registered . $ini_name . "<br> Nueva actividad: " . $act_name . "<br> descripción: <br> " . $act_descri . "<br> desde: " . $act_start . "<br> en: " . $map_addres . "<br> lat: " . $map_lat . ", lon: " . $map_lon . "<br> creada por: " . $ini_name . $ini_name_registered . "<br> con web: " . $act_web . "<br>" . $act_topic . "<br>" . $act_form . "<br>" . $act_atten . "<br>" . "<br> Si es una iniciativa nueva: " . "<br> nombre iniciativa: " . $ini_name . "<br> descripción iniciativa: " . $ini_descri . "<br> web iniciativa: " . $ini_web . "<br> mail iniciativa: " . $ini_mail . "<br> telef iniciativa: " . $ini_tef . "<br> dirección iniciativa: " . $ini_addres . "<br> lat: " . $ini_lat . ", lon: " . $ini_lon . "</b>"; //enviar mail (función de php) mail($mail_to, $mail_subject, $mail_body, $texToMailAlert); /************************************************************************************************* * METER ACTIVIDADES EN CARTO DB *************************************************************************************************/ $sqlRegisterActivity = "INSERT INTO " . $act_table_name . "(" . $cartodb_act_field_the_geom . "," . $cartodb_act_field_act_name . "," . $cartodb_act_field_act_descri . "," . $cartodb_act_field_act_web . "," . $cartodb_act_field_act_topic . "," . $cartodb_act_field_act_otopic . "," . $cartodb_act_field_act_form . "," . $cartodb_act_field_act_oform . "," . $cartodb_act_field_act_atten . "," . $cartodb_act_field_act_oatten . "," . $cartodb_act_field_act_start . "," . $cartodb_act_field_act_city . "," . $cartodb_act_field_map_addres . "," . $cartodb_act_field_map_lat . "," . $cartodb_act_field_map_lon . "," . $cartodb_act_field_ini_id . ") VALUES (" . "ST_SetSRID(ST_Point(" . $map_lon . "," . $map_lat . "), 4326)" . "," . "'" . $act_name . "'" . "," . "'" . $act_descri . "'" . "," . "'" . $act_web . "'" . "," . "'" . $act_topic . "'" . "," . "'" . $act_otopic . "'" . "," . "'" . $act_form . "'" . "," . "'" . $act_oform . "'" . "," . "'" . $act_atten . "'" . "," . "'" . $act_oatten . "'" . "," . "'" . $act_start . "'" . "," . "'" . $act_city . "'" . "," . "'" . $map_addres . "'" . "," . "'" . $map_lat . "'" . "," . "'" . $map_lon . "'" . "," . "'" . $ini_id . "'" . ")"; $result = executeQueryToCartoDB($sqlRegisterActivity); if ($debug) { echo "Form input result: " . $result . "<br>"; }
function getIniciatives() { global $debug; global $cartodb_ini_field_ini_name; global $ini_table_name; global $ciudad_activa; $sql = "SELECT * FROM " . $ini_table_name . " WHERE city like '" . $ciudad_activa . "' ORDER BY " . $cartodb_ini_field_ini_name . " ASC"; $result = executeQueryToCartoDB($sql); if ($debug) { echo "<br>getNameIniciatives() query RESULT: " . $result . "<br>"; } return $result; }