echo '<script>window.location="index.php?m=login"</script>'; } $idCliente = $userAdmin->user_info['ID_CLIENTE']; $cadenaMail = ''; $cadenaMailMaster = ''; $master = explode("|", $_POST['cadena']); $id_master = 0; $id_mail = 0; $variables = explode(",", $_POST['cadena']); $variables2 = explode("AND", $variables[3]); $insert = ''; $values = ''; $idObjectMap = explode("=", $master[3]); $unidadesVariables = explode(",", $master[2]); $sql_master = "INSERT INTO ALERT_XP_MASTER\n\t\t\t\t (COD_CLIENT,\n\t\t\t\t NAME_ALERT,\n\t\t\t\t ACTIVE,\n\t\t\t\t VIGENTE,\n\t\t\t\t ALARM_EXPRESION,\n\t\t\t\t TYPE_EXPRESION,\n\t\t\t\t HORARIO_FLAG_LUNES,\n\t\t\t\t HORARIO_FLAG_MARTES,\n\t\t\t\t HORARIO_FLAG_MIERCOLES,\n\t\t\t\t HORARIO_FLAG_JUEVES,\n\t\t\t\t HORARIO_FLAG_VIERNES,\n\t\t\t\t HORARIO_FLAG_SABADO,\n\t\t\t\t HORARIO_FLAG_DOMINGO,\n\t\t\t\t HORARIO_HORA_INICIO,\n\t\t\t\t HORARIO_HORA_FIN,\n\t\t\t\t COD_USER_CREATE,\n\t\t\t\t NICKNAME_USER_CREATE,\n\t\t\t\t FECHA_CREATE)\n\t\t\t\t VALUES (" . $idCliente . "," . stripslashes($master[0]) . ",'" . date('Y-m-d H:m:s') . "')"; $qry_master = $db3->sqlQuery($sql_master); if ($qry_master) { $sql_v = "SELECT LAST_INSERT_ID() AS INDX FROM ALERT_XP_MASTER"; $query_v = $db3->sqlQuery($sql_v); $row_v = $db3->sqlFetchArray($query_v); $id_master = $row_v['INDX']; $cadenaMail = $idCliente . ',"' . $master[1] . '"'; $sql_mail = "INSERT INTO ALERT_XP_EMAIL\n\t\t\t\t (COD_CLIENT,CORREO_ELECTRONICO)\n\t \t\t\t VALUES (" . $cadenaMail . ")"; $qry_mail = $db3->sqlQuery($sql_mail); if ($qry_mail) { $sql_w = "SELECT LAST_INSERT_ID() AS INDX2 FROM ALERT_XP_EMAIL"; $query_w = $db3->sqlQuery($sql_w); $row_w = $db3->sqlFetchArray($query_w); $id_mail = $row_w['INDX2']; /********************************************************/ $con1 = '';
* @copyright Air Logistics & GPS S.A. de C.V. * @author danielArazoSaladino * @modificado 19-09-2014 **/ $db = new sql($config_bd['host'], $config_bd['port'], $config_bd['bname'], $config_bd['user'], $config_bd['pass']); $db3 = new sql($config_bd3['host'], $config_bd3['port'], $config_bd3['bname'], $config_bd3['user'], $config_bd3['pass']); if (!$userAdmin->u_logged()) { echo '<script>window.location="index.php?m=login"</script>'; } $tpl->set_filenames(array('mExpresiones' => 'tExpresiones')); $idCliente = $userAdmin->user_info['ID_CLIENTE']; $idUsuario = $userAdmin->user_info['ID_USUARIO']; $nombreUsuario = $userAdmin->user_info['NOMBRE_COMPLETO']; //******************************* Eventos $sql_eventos = "SELECT COD_EVENT,DESCRIPTION FROM ADM_EVENTOS WHERE ID_CLIENTE =" . $idCliente; $qry_eventos = $db->sqlQuery($sql_eventos); $cnt = $db->sqlEnumRows($qry_eventos); if ($cnt > 0) { while ($row_evento = $db->sqlFetchArray($qry_eventos)) { $tpl->assign_block_vars('eventos', array('CLV_EVENTO' => $row_evento['COD_EVENT'], 'DESCRIPCION' => $Functions->codif($row_evento['DESCRIPTION']))); } } //******************************* Prioridad $sql_prioridad = "SELECT * FROM DSP2_PRIORIDAD"; $qry_prioridad = $db->sqlQuery($sql_prioridad); $cnt2 = $db->sqlEnumRows($qry_prioridad); if ($cnt2 > 0) { while ($row_prioridad = $db->sqlFetchArray($qry_prioridad)) { $tpl->assign_block_vars('prioridades', array('CLV_PRIORIDAD' => $row_prioridad['ID_PRIORIDAD'], 'DESCRIPCION' => $Functions->codif($row_prioridad['DESCRIPCION']))); } }
$db = new sql($config_bd['host'], $config_bd['port'], $config_bd['bname'], $config_bd['user'], $config_bd['pass']); $db3 = new sql($config_bd3['host'], $config_bd3['port'], $config_bd3['bname'], $config_bd3['user'], $config_bd3['pass']); if (!$userAdmin->u_logged()) { echo '<script>window.location="index.php?m=login"</script>'; } $idCliente = $userAdmin->user_info['ID_CLIENTE']; $idUsuario = $userAdmin->user_info['ID_USUARIO']; $select = ''; //******************************* tipos $opcion = ''; if ($_POST['tip_g'] === 'G') { $opcion = 'Elegir PDI'; } if ($_POST['tip_g'] === 'C') { $opcion = 'Elegir Geocerca'; } if ($_POST['tip_g'] === 'R') { $opcion = 'Elegir Ruta'; } $sql_tipo = "SELECT ID_OBJECT_MAP,DESCRIPCION FROM \tADM_GEOREFERENCIAS WHERE TIPO = '" . $_POST['tip_g'] . "' AND ID_CLIENTE =" . $idCliente; $qry_tipo = $db->sqlQuery($sql_tipo); $cnt = $db->sqlEnumRows($qry_tipo); if ($cnt > 0) { $select = '<select style=" width:100px;" id="TiposPDIGCRSI" onChange="cambiaPDIcod(this.value);">'; $select .= '<option value="-1">' . $opcion . '</option>'; while ($row_tipo = $db->sqlFetchArray($qry_tipo)) { $select .= '<option value="' . $row_tipo['ID_OBJECT_MAP'] . '">' . $row_tipo['DESCRIPCION'] . '</option>'; } $select .= '</select>'; } echo $select;