public function registrar()
{
$proteccion = new Proteccion();
$nombre = $proteccion->html($_POST['nombre']);
$apellido = $proteccion->html($_POST['apellido']);
$sexo = $proteccion->html($_POST['sexo']);
$fecha_nacimiento = $proteccion->html($_POST['fecha_nacimiento']);
$direccion = $proteccion->html($_POST['direccion']);
$email = $proteccion->html($_POST['email']);
$dni = $proteccion->html($_POST['dni']);
$pass = $proteccion->html($_POST['password']);
$persona = new Usuario($email, $pass);
$existe = $persona->existe();
if ($existe) {
$tp = new TemplatePower("templates/registro.html");
$tp->prepare();
$tp->gotoBlock("_ROOT");
$tp->newblock("no_registro");
$tp->assign("usuario", $email);
$webapp = $tp->getOutputContent();
} else {
$persona->setDatosUsuario($nombre, $apellido, $sexo, $fecha_nacimiento, $direccion, $dni);
$persona->insertar();
$_SESSION['user'] = $email;
$tp = new TemplatePower("templates/index.html");
$tp->prepare();
$tp->gotoBlock("_ROOT");
$tp->newBlock("sesion");
$tp->assign("usuario", $_SESSION['user']);
$webapp = $tp->getOutputContent();
}
echo $webapp;
}
public function consultarReserva()
{
$proteccion = new Proteccion();
$cod_reserva = $proteccion->html($_POST['cod_reserva']);
$reserva = new Reserva();
$result = $reserva->BuscarReserva($cod_reserva);
foreach ($result['result'] as $r) {
$cod_reserva = $r['cod_reserva'];
}
$nom_hotel = $r['nom_hotel'];
$nombre = $r['nombre'];
$apellido = $r['apellido'];
$email = $r['email'];
$fec_llegada = $r['fec_llegada'];
$fec_salida = $r['fec_salida'];
$fec_reserva = $r['fec_reserva'];
$piso = $r['piso'];
$ubicacion = $r['ubicacion'];
$tp = new TemplatePower("templates/reserva.html");
$tp->prepare();
$tp->gotoBlock("_ROOT");
$tp->newBlock("generarreserva");
$tp->assign("cod_reserva", $cod_reserva);
$tp->assign("nom_hotel", $nom_hotel);
$tp->assign("nombre", $nombre);
$tp->assign("apellido", $apellido);
$tp->assign("email", $email);
$tp->assign("fec_llegada", $fec_llegada);
$tp->assign("fec_salida", $fec_salida);
$tp->assign("fec_reserva", $fec_reserva);
$tp->assign("piso", $piso);
$tp->assign("ubicacion", $ubicacion);
echo $tp->getOutputContent();
}
function hotel($idHotel)
{
$mhotels = new MHotels();
$result = $mhotels->buscar_id($idHotel);
foreach ($result['result'] as $r) {
$nombreHotel = $r['nom_hotel'];
$prov = $r['provincia'];
$local = $r['localidad'];
$calle = $r['calle'];
$ncalle = $r['nro_calle'];
$tel = $r['telefono'];
$precio = $r['precio_persona'];
$cant_imagenes = $r['cant_imagenes'];
$descripcion = $r['descripcion'];
}
$tp = new TemplatePower("templates/hotel.html");
$tp->prepare();
$tp->gotoBlock("_ROOT");
$tp->assign("nombre", $nombreHotel);
for ($i = 1; $i <= $cant_imagenes; $i++) {
$tp->newBlock("imagenes");
$tp->assign("nombre", $nombreHotel);
$tp->assign("numero", $i);
}
$tp->gotoBlock("_ROOT");
$tp->assign("descripcion", $descripcion);
$tp->assign("prov", $prov);
$tp->assign("local", $local);
$tp->assign("calle", $calle);
$tp->assign("ncalle", $ncalle);
$tp->assign("tel", $tel);
$tp->assign("precio", $precio);
if (isset($_SESSION['user'])) {
$tp->newBlock("reservar");
$tp->assign("idHotel", $idHotel);
}
if (!isset($_SESSION['user'])) {
$tp->newBlock("iniciarSesion");
}
echo $tp->getOutputContent();
}
function savePluginFile($tplName, $fileName, $fields)
{
$pluginTpl = PATH_GULLIVER_HOME . 'bin' . PATH_SEP . 'tasks' . PATH_SEP . 'templates' . PATH_SEP . $tplName . '.tpl';
$template = new TemplatePower($pluginTpl);
$template->prepare();
if (is_array($fields)) {
foreach ($fields as $block => $data) {
$template->gotoBlock("_ROOT");
if (is_array($data)) {
foreach ($data as $rowId => $row) {
$template->newBlock($block);
foreach ($row as $key => $val) {
$template->assign($key, $val);
}
}
} else {
$template->assign($block, $data);
}
}
}
$content = $template->getOutputContent();
$iSize = file_put_contents($fileName, $content);
return $iSize;
}
$oTemplatePower->assign('USR_UID', $aUser['USR_UID']);
$oTemplatePower->assign('USR_FULLNAME', $aData['USR_FIRSTNAME'] . ' ' . $aData['USR_LASTNAME'] . ' (' . $aData['USR_USERNAME'] . ')');
}
}
}
$aAux1 = $oTasks->getUsersOfTask($aRow['TAS_UID'], 1);
foreach ($aAux1 as $aUser) {
if (!in_array($aUser['USR_UID'], $aUsers)) {
$aUsers[] = $aUser['USR_UID'];
$aData = $oUser->load($aUser['USR_UID']);
$oTemplatePower->newBlock('users');
$oTemplatePower->assign('USR_UID', $aUser['USR_UID']);
$oTemplatePower->assign('USR_FULLNAME', $aData['USR_FIRSTNAME'] . ' ' . $aData['USR_LASTNAME'] . ' (' . $aData['USR_USERNAME'] . ')');
}
}
$oTemplatePower->gotoBlock('cases');
$oTemplatePower->assign('ID_STATUS', G::LoadTranslation('ID_TO_DO'));
$oTemplatePower->assign('ID_NO_REASSIGN', G::LoadTranslation('ID_NO_REASSIGN'));
$oDataset->next();
}
$oDataset = ApplicationPeer::doSelectRS($oCriteriaDraft);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$oDataset->next();
while ($aRow = $oDataset->getRow()) {
$c++;
$oTemplatePower->newBlock('cases');
$aKeys = array_keys($aRow);
foreach ($aKeys as $sKey) {
$oTemplatePower->assign($sKey, $aRow[$sKey]);
}
$aUsers = array($_GET['USR_UID']);
}
if (is_array($value)) {
foreach ($value as $key1 => $value1) {
if (is_array($value1)) {
foreach ($value1 as $key2 => $value2) {
if (isset($form) && isset($form->fields[$key]->fields[$key2])) {
$label = $form->fields[$key]->fields[$key2]->label . ' (' . $key . '[' . $key1 . '][' . $key2 . '])';
} else {
$label = $key . '[' . $key1 . ']' . '[' . $key2 . ']';
}
$tpl->newBlock("FIELDLOG");
$tpl->assign("fieldName", $label);
$tpl->assign("previous", isset($historyData[$tableNameA][$key][$key1][$key2]) ? $historyData[$tableNameA][$key][$key1][$key2] : "");
$tpl->assign("actual", $value2);
$count++;
}
}
}
}
}
$tpl->gotoBlock("DYNLOG");
$tpl->assign("dynChanges", G::LoadTranslation("ID_FIELDS_CHANGED_NUMBER") . " (" . $count . ")");
$tpl->assign("count", $count + 1);
}
if (!isset($changedValues)) {
$tpl->newBlock("NORESULTS");
$tpl->assign("noResults", G::LoadTranslation("ID_NO_RECORDS_FOUND"));
}
$_SESSION['HISTORY_DATA'] = $historyData;
$tpl->gotoBlock("_ROOT");
$tpl->printToScreen();
//Name: index.php
//Function: code for converting the chart data and seeding the html
//Last Modified: 10-02-2016
//By: Arno Inen
//General Modification: debugging
//Requires:
//-TemplatePower
//-Canvas.js
//Includes/requires
include_once 'class.TemplatePower.inc.php';
//Call template engine
$template_url = "./templates/";
$template = new TemplatePower($template_url . "chart.html");
$template->prepare();
//Functions
////Main Code
$json = file_get_contents('http://www.mixtup.nl/dev/techradar/data.json');
$data_array = json_decode($json);
$counter = 0;
//var_dump($data_array);
$totalObjects = count($data_array);
while ($counter < $totalObjects - 1) {
$template->newBlock("data_row");
$template->assign("date", $data_array[$counter]->{'x'});
$template->assign("ycoord", $data_array[$counter]->{'y'});
$counter++;
}
$template->gotoBlock("_ROOT");
$template->assign("finaldate", $data_array[$counter]->{'x'});
$template->assign("finalycoord", $data_array[$counter]->{'y'});
$template->printToScreen();
include_once 'propietarios.php';
$tplIndex->newBlock("menu_principal_link");
break;
case 'recuperar_clave':
include_once 'recuperar_clave.php';
break;
case 'casos':
include_once 'casos.php';
$tplIndex->newBlock("menu_principal_link");
break;
case 'nuevo_usuario':
include_once 'nuevo_usuario.php';
$tplIndex->newBlock("menu_principal_link");
break;
default:
if ($_SESSION['logueado'] == 1) {
include_once 'principal.php';
$class_inferior = "center";
} else {
include_once 'login.php';
}
break;
}
$tplIndex->gotoBlock(TP_ROOTBLOCK);
$tplIndex->assign("menu_inferior_class", $class_inferior);
if ($_SESSION['logueado'] == 1) {
$tplIndex->newBlock("log_out");
}
}
//imprimimos por pantalla
$tplIndex->printToScreen();
public function bajau($email)
{
global $db;
$tp = new TemplatePower("templates/BajaUsuario.html");
$tp->prepare();
$tp->gotoBlock("_ROOT");
$sql = "delete from usuario where(email='{$email}')";
$db->ejecutar($sql);
$tp->newBlock("mensaje");
echo $tp->getOutputContent();
}
function searchText($searchText)
{
global $_SESSION;
global $RBAC;
$curAuthSource = $_SESSION['CURRENT_AUTH_SOURCE'];
$dbc = new DBConnection(DB_HOST, DB_RBAC_USER, DB_RBAC_PASS, DB_RBAC_NAME);
$tpl = new TemplatePower(PATH_TPL . 'authListUsers.html');
$tpl->prepare();
$tpl->assign("STYLE_CSS", defined('STYLE_CSS') ? STYLE_CSS : 'simple');
$tpl->assign("title", 'Search Results');
//authentication source
G::LoadClassRBAC('authentication');
$obj = new authenticationSource();
$obj->SetTo($dbc);
$data = $obj->searchUsers($curAuthSource, $searchText);
if ($data['codError'] == 0 && isset($data['rows']) && !is_array($data['rows'])) {
$tpl->newBlock("empty-rows");
$tpl->assign("title", 'Search Results');
$tpl->assign("empty-rows-text", 'no records found');
$tpl->printToScreen();
die;
}
if ($data['codError'] != 0) {
$tpl->newBlock("error");
$tpl->assign("title", 'Log Error');
$tpl->assign("text", "<font color='Red'>" . $data['rows'] . "</font>");
$tpl->printToScreen();
die;
}
//build the options to create...an user, list the applications and their roles..
$ses = new DBSession($dbc);
$ses2 = new DBSession($dbc);
$dset = $ses->execute("SELECT * from APPLICATION where APP_CODE != 'RBAC' ");
$appRow = $dset->Read();
$checkboxs = "<br><input type='checkbox' @@disabled name='C-@@Y' id='C-@@Y' onclick='emptyDropdowns( \"@@X\");' ><input type='hidden' name='H-@@Y' id='H-@@Y' value='@@X' ><input type='hidden' name='E-@@Y' id='E-@@Y' value='' >";
$inputs = "<div id='D-@@Y'>@@validuser</div><input type='text' name='T-@@Y' id='T-@@Y' value=\"@@Z\" onchange='verifyUserName ( this, \"@@Y\" );' size='14' maxlength='16'> ";
$options = "<table cellpadding='0' cellspacing='0'><tr>";
$options .= "";
while (is_array($appRow)) {
$appid = $appRow['UID'];
$selectId = 'S-@@Y-' . $appid;
$dset2 = $ses2->execute('SELECT * from ROLE where ROL_APPLICATION = ' . $appid);
$rolRow = $dset2->Read();
$selectEnabled = false;
if (is_array($rolRow)) {
$options .= '<td>' . $appRow['APP_CODE'] . '<br>';
$options .= "<select name='{$selectId}' id='{$selectId}' @@disabled onchange='flipCheckbox( \"@@Y\");' >\n";
$options .= "<option value='0'>select a Role</option>";
$selectEnabled = true;
}
while (is_array($rolRow)) {
$options .= "<option value='" . $rolRow['UID'] . "'>" . $rolRow['ROL_CODE'] . "</option>";
$rolRow = $dset2->Read();
}
if ($selectEnabled) {
$options .= "</select>\n<td>";
}
$appRow = $dset->Read();
}
$options .= '</tr></table>';
$i = 0;
if (isset($data['rows'])) {
foreach ($data['rows'] as $row) {
$tpl->newBlock("users");
if (++$i % 2 == 0) {
$tpl->assign("class", 'Row2');
} else {
$tpl->assign("class", 'Row1');
}
$tpl->assign("index", $i);
$tpl->assign("dn", $row['dn']);
$tpl->assign("name", $row['attr']['givenName']);
$tpl->assign("lastname", $row['attr']['sn']);
$tpl->assign("fullname", $row['attr']['cn']);
$tpl->assign("email", $row['attr']['mail']);
$tpl->assign("uid", $row['attr']['uid']);
//verificar uid
$userid = $row['attr']['uid'];
$res = $RBAC->UserNameRepetido(0, $userid);
$input = str_replace('@@Z', $userid, str_replace('@@X', $row['dn'], str_replace('@@Y', $i, $inputs)));
$input = str_replace('@@validuser', $res == 0 ? "<font color='green'>valid user</font>" : "<font color='red'>user already used</font>", $input);
$checkbox = str_replace('@@X', $row['dn'], str_replace('@@Y', $i, $checkboxs));
$checkbox = str_replace('@@disabled', $res != 0 ? 'disabled' : '', $checkbox);
$option = str_replace('@@X', $row['dn'], str_replace('@@Y', $i, $options));
// $option = str_replace ( '@@disabled', ( $res <> 0 ? 'disabled' : ''), $option );
$tpl->assign("checkbox", $checkbox);
$tpl->assign("input", $input);
$tpl->assign("options", $option);
}
}
$tpl->gotoBlock("_ROOT");
$tpl->newBlock("start-users");
$tpl->assign("dummy", 'dummy');
$tpl->gotoBlock("_ROOT");
$tpl->newBlock("end-users");
$tpl->assign("dummy", 'dummy');
$tpl->printToScreen();
}
$displayMode = 'display:none';
}
$aParametersFun = $methodParameters;
$triggerWizardTemplate = PATH_TPL . 'triggers' . PATH_SEP . 'triggers_EditWizard.html';
$template = new TemplatePower($triggerWizardTemplate);
$template->prepare();
$tds = '';
$nrows = 2;
$template->assign('LIBRARY_NAME', $libraryName);
$template->assign('LIBRARY_DESCRIPTION', $libraryDescription);
$template->assign('LIBRARY_ICON', $libraryIcon);
$template->assign('LIBRARY_CLASS', $libraryClassName);
if ($methodLink != "") {
$template->newBlock('methodLink');
$template->assign('LIBRARY_METHOD_LINK', $methodLink);
$template->gotoBlock('_ROOT');
}
$template->assign('PMFUNTION', $sNameFun);
$template->assign('PMFUNTION_LABEL', $methodLabel);
$template->assign('PMFUNTION_DESCRIPTION', $methodDescription);
$template->assign('TITLE', G::LoadTranslation('ID_TITLE'));
$template->assign('TITLE_CONTENT', $_GET['TRI_TITLE']);
$template->assign('TRI_UID', $_GET['TRI_UID']);
$template->assign('STEP_UID', $_GET['STEP_UID']);
$template->assign('ST_TYPE', $_GET['ST_TYPE']);
$template->assign('SOURCE_LINK', G::LoadTranslation('ID_TRIGGER_SOURCE_LINK'));
$template->assign('DESCRIPTION', G::LoadTranslation('ID_DESCRIPTION'));
$template->assign('DESCRIPTION_CONTENT', $_GET['TRI_DESCRIPTION']);
$template->assign('DETAILS_LABEL', G::LoadTranslation('ID_DETAILS'));
$template->assign('RETURN_TITLE', G::LoadTranslation('ID_TRIGGER_RETURN_TITLE'));
if ($bReturnValue) {
$tplAlmacen->assign('nombre', $dato['nombre']);
$tplAlmacen->assign('tel', $dato['telefono']);
$tplAlmacen->assign('dir', $dato['direccion']);
$tplAlmacen->assign('mail', $dato['mail']);
$tplAlmacen->assign('id_prov', $dato['id_prov']);
}
}
} elseif ($_GET['action'] == 'edit_prod') {
//editar un campo de un producto concreto
//obtenemos el id del elemento que queremos editar y realizamos la consulta que nos mostrará los datos existentes
$id = $_GET['id'];
$query = "SELECT id_prod, referencia, almacen.nombre, cant_min, cant_pedir, proveedores.nombre AS proveedor, precio \r\n FROM almacen, proveedores \r\n WHERE id_prod='{$id}' \r\n AND almacen.id_prov=proveedores.id_prov";
$rec = mysql_query($query);
$dato = mysql_fetch_array($rec);
//creamos el bloque de edición y cargamos los datos
$tplAlmacen->gotoBlock(TP_ROOTBLOCK);
$tplAlmacen->newBlock('edit_prod');
$tplAlmacen->assign('prod_ref', $dato['referencia']);
$tplAlmacen->assign('prod_nombre', $dato['nombre']);
$tplAlmacen->assign('prod_cant_min', $dato['cant_min']);
$tplAlmacen->assign('prod_cant_pedir', $dato['cant_pedir']);
$tplAlmacen->assign('prod_prov', $dato['proveedor']);
$tplAlmacen->assign('prod_precio', $dato['precio']);
$tplAlmacen->assign('prod_id', $dato['id_prod']);
} elseif ($_GET['action'] == 'edit_prov') {
$id = $_GET['id'];
$query = "SELECT id_prov, nombre, telefono, mail, direccion\r\n FROM proveedores \r\n WHERE id_prov='{$id}'";
$rec = mysql_query($query);
$dato = mysql_fetch_array($rec);
$tplAlmacen->gotoBlock(TP_ROOTBLOCK);
$tplAlmacen->newBlock('edit_prov');
/**
* DEPRECATED createPropelClasses()
*
* Don't use this method, it was left only for backward compatibility
* for some external plugins that still is using it
*/
public function createPropelClasses($sTableName, $sClassName, $aFields, $sAddTabUid, $connection = 'workflow')
{
try {
/* $aUID = array('FLD_NAME' => 'PM_UNIQUE_ID',
'FLD_TYPE' => 'INT',
'FLD_KEY' => 'on',
'FLD_SIZE' => '11',
'FLD_NULL' => '',
'FLD_AUTO_INCREMENT' => 'on');
array_unshift($aFields, $aUID); */
$aTypes = array(
'VARCHAR' => 'string',
'TEXT' => 'string',
'DATE' => 'int',
'INT' => 'int',
'FLOAT' => 'double'
);
$aCreoleTypes = array(
'VARCHAR' => 'VARCHAR',
'TEXT' => 'LONGVARCHAR',
'DATE' => 'TIMESTAMP',
'INT' => 'INTEGER',
'FLOAT' => 'DOUBLE'
);
if ($sClassName == '') {
$sClassName = $this->getPHPName($sTableName);
}
$sPath = PATH_DB . SYS_SYS . PATH_SEP . 'classes' . PATH_SEP;
if (!file_exists($sPath)) {
G::mk_dir($sPath);
}
if (!file_exists($sPath . 'map')) {
G::mk_dir($sPath . 'map');
}
if (!file_exists($sPath . 'om')) {
G::mk_dir($sPath . 'om');
}
$aData = array();
$aData['pathClasses'] = substr(PATH_DB, 0, -1);
$aData['tableName'] = $sTableName;
$aData['className'] = $sClassName;
$aData['connection'] = $connection;
$aData['GUID'] = $sAddTabUid;
$aData['firstColumn'] = isset($aFields[0])
? strtoupper($aFields[0]['FLD_NAME'])
: ($aFields[1]['FLD_NAME']);
$aData['totalColumns'] = count($aFields);
$aData['useIdGenerator'] = 'false';
$oTP1 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'Table.tpl');
$oTP1->prepare();
$oTP1->assignGlobal($aData);
file_put_contents($sPath . $sClassName . '.php', $oTP1->getOutputContent());
$oTP2 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'TablePeer.tpl');
$oTP2->prepare();
$oTP2->assignGlobal($aData);
file_put_contents($sPath . $sClassName . 'Peer.php', $oTP2->getOutputContent());
$aColumns = array();
$aPKs = array();
$aNotPKs = array();
$i = 0;
foreach ($aFields as $iKey => $aField) {
$aField['FLD_NAME'] = strtoupper($aField['FLD_NAME']);
if ($aField['FLD_TYPE'] == 'DATE') {
$aField['FLD_NULL'] = '';
}
$aColumn = array(
'name' => $aField['FLD_NAME'],
'phpName' => $this->getPHPName($aField['FLD_NAME']),
'type' => $aTypes[$aField['FLD_TYPE']],
'creoleType' => $aCreoleTypes[$aField['FLD_TYPE']],
'notNull' => ($aField['FLD_NULL'] == 'on' ? 'true' : 'false'),
'size' => (($aField['FLD_TYPE'] == 'VARCHAR')
|| ($aField['FLD_TYPE'] == 'INT')
|| ($aField['FLD_TYPE'] == 'FLOAT') ? $aField['FLD_SIZE'] : 'null'),
'var' => strtolower($aField['FLD_NAME']),
'attribute' => (($aField['FLD_TYPE'] == 'VARCHAR')
|| ($aField['FLD_TYPE'] == 'TEXT')
|| ($aField['FLD_TYPE'] == 'DATE')
? '$' . strtolower($aField['FLD_NAME']) . " = ''"
: '$' . strtolower($aField['FLD_NAME']) . ' = 0'),
'index' => $i,
);
if ($aField['FLD_TYPE'] == 'DATE') {
$aColumn['getFunction'] = '/**
* Get the [optionally formatted] [' . $aColumn['var'] . '] column value.
*
* @param string $format The date/time format string (either date()-style or strftime()-style).
* If format is NULL, then the integer unix timestamp will be returned.
* @return mixed Formatted date/time value as string or integer unix timestamp (if format is NULL).
* @throws PropelException - if unable to convert the date/time to timestamp.
*/
public function get' . $aColumn['phpName'] . '($format = "Y-m-d")
{
if ($this->' . $aColumn['var'] . ' === null || $this->' . $aColumn['var'] . ' === "") {
return null;
} elseif (!is_int($this->' . $aColumn['var'] . ')) {
// a non-timestamp value was set externally, so we convert it
if (($this->' . $aColumn['var'] . ' == "0000-00-00 00:00:00")
|| ($this->' . $aColumn['var'] . ' == "0000-00-00") || !$this->' . $aColumn['var'] . ') {
$ts = "0";
}
else {
$ts = strtotime($this->' . $aColumn['var'] . ');
}
if ($ts === -1 || $ts === false) { // in PHP 5.1 return value changes to FALSE
throw new PropelException("Unable to parse value of [' . $aColumn['var'] . '] as date/time value: "
. var_export($this->' . $aColumn['var'] . ', true));
}
} else {
$ts = $this->' . $aColumn['var'] . ';
}
if ($format === null) {
return $ts;
} elseif (strpos($format, "%") !== false) {
return strftime($format, $ts);
} else {
return date($format, $ts);
}
}';
} else {
$aColumn['getFunction'] = '/**
* Get the [' . $aColumn['var'] . '] column value.
*
* @return string
*/
public function get' . $aColumn['phpName'] . '()
{
return $this->' . $aColumn['var'] . ';
}';
}
switch ($aField['FLD_TYPE']) {
case 'VARCHAR':
case 'TEXT':
$aColumn['setFunction'] = '// Since the native PHP type for this column is string,
// we will cast the input to a string (if it is not).
if ($v !== null && !is_string($v)) {
$v = (string) $v;
}
if ($this->' . $aColumn['var'] . ' !== $v) {
$this->' . $aColumn['var'] . ' = $v;
$this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . ';
}';
break;
case 'DATE':
$aColumn['setFunction'] = 'if ($v !== null && !is_int($v)) {
// if($v == \'\')
// $ts = null;
// else
$ts = strtotime($v);
if ($ts === -1 || $ts === false) { // in PHP 5.1 return value changes to FALSE
//throw new PropelException("Unable to parse date/time value for [' . $aColumn['var'] . '] from input: "
// . var_export($v, true));
}
} else {
$ts = $v;
}
if ($this->' . $aColumn['var'] . ' !== $ts) {
$this->' . $aColumn['var'] . ' = $ts;
$this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . ';
}';
break;
case 'INT':
$aColumn['setFunction'] = '// Since the native PHP type for this column is integer,
// we will cast the input value to an int (if it is not).
if ($v !== null && !is_int($v) && is_numeric($v)) {
$v = (int) $v;
}
if ($this->' . $aColumn['var'] . ' !== $v || $v === 1) {
$this->' . $aColumn['var'] . ' = $v;
$this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . ';
}';
break;
case 'FLOAT':
$aColumn['setFunction'] = 'if ($this->' . $aColumn['var'] . ' !== $v || $v === 0) {
$this->' . $aColumn['var'] . ' = $v;
$this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . ';
}';
break;
}
$aColumns[] = $aColumn;
if ($aField['FLD_KEY'] == 1 || $aField['FLD_KEY'] === 'on') {
$aPKs[] = $aColumn;
} else {
$aNotPKs[] = $aColumn;
}
if ($aField['FLD_AUTO_INCREMENT'] == 1 || $aField['FLD_AUTO_INCREMENT'] === 'on') {
$aData['useIdGenerator'] = 'true';
}
$i++;
}
$oTP3 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'map'
. PATH_SEP . 'TableMapBuilder.tpl');
$oTP3->prepare();
$oTP3->assignGlobal($aData);
foreach ($aPKs as $iIndex => $aColumn) {
$oTP3->newBlock('primaryKeys');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP3->assign($sKey, $aColumn[$sKey]);
}
}
$oTP3->gotoBlock('_ROOT');
foreach ($aNotPKs as $iIndex => $aColumn) {
$oTP3->newBlock('columnsWhitoutKeys');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP3->assign($sKey, $aColumn[$sKey]);
}
}
file_put_contents($sPath . PATH_SEP . 'map' . PATH_SEP . $sClassName
. 'MapBuilder.php', $oTP3->getOutputContent());
$oTP4 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'om' . PATH_SEP . 'BaseTable.tpl');
$oTP4->prepare();
switch (count($aPKs)) {
case 0:
$aData['getPrimaryKeyFunction'] = 'return null;';
$aData['setPrimaryKeyFunction'] = '';
break;
case 1:
$aData['getPrimaryKeyFunction'] = 'return $this->get' . $aPKs[0]['phpName'] . '();';
$aData['setPrimaryKeyFunction'] = '$this->set' . $aPKs[0]['phpName'] . '($key);';
break;
default:
$aData['getPrimaryKeyFunction'] = '$pks = array();' . "\n";
$aData['setPrimaryKeyFunction'] = '';
foreach ($aPKs as $iIndex => $aColumn) {
$aData['getPrimaryKeyFunction'] .= '$pks[' . $iIndex . '] = $this->get'
. $aColumn['phpName'] . '();' . "\n";
$aData['setPrimaryKeyFunction'] .= '$this->set' . $aColumn['phpName']
. '($keys[' . $iIndex . ']);' . "\n";
}
$aData['getPrimaryKeyFunction'] .= 'return $pks;' . "\n";
break;
}
$oTP4->assignGlobal($aData);
foreach ($aColumns as $iIndex => $aColumn) {
$oTP4->newBlock('allColumns1');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns2');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns3');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns4');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns5');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns6');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns7');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns8');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
$oTP4->newBlock('allColumns9');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
}
$oTP4->gotoBlock('_ROOT');
foreach ($aPKs as $iIndex => $aColumn) {
$oTP4->newBlock('primaryKeys1');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
}
$oTP4->gotoBlock('_ROOT');
foreach ($aPKs as $iIndex => $aColumn) {
$oTP4->newBlock('primaryKeys2');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
}
$oTP4->gotoBlock('_ROOT');
foreach ($aNotPKs as $iIndex => $aColumn) {
$oTP4->newBlock('columnsWhitoutKeys');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP4->assign($sKey, $aColumn[$sKey]);
}
}
file_put_contents($sPath . PATH_SEP . 'om' . PATH_SEP . 'Base'
. $sClassName . '.php', $oTP4->getOutputContent());
$oTP5 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'om' . PATH_SEP . 'BaseTablePeer.tpl');
$oTP5->prepare();
$sKeys = '';
foreach ($aPKs as $iIndex => $aColumn) {
$sKeys .= '$' . $aColumn['var'] . ', ';
}
$sKeys = substr($sKeys, 0, -2);
//$sKeys = '$pm_unique_id';
if ($sKeys != '') {
$aData['sKeys'] = $sKeys;
} else {
$aData['sKeys'] = '$DUMMY';
}
$oTP5->assignGlobal($aData);
foreach ($aColumns as $iIndex => $aColumn) {
$oTP5->newBlock('allColumns1');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns2');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns3');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns4');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns5');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns6');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns7');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns8');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns9');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
$oTP5->newBlock('allColumns10');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
}
$oTP5->gotoBlock('_ROOT');
foreach ($aPKs as $iIndex => $aColumn) {
$oTP5->newBlock('primaryKeys1');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
}
foreach ($aPKs as $iIndex => $aColumn) {
$oTP5->newBlock('primaryKeys2');
$aKeys = array_keys($aColumn);
foreach ($aKeys as $sKey) {
$oTP5->assign($sKey, $aColumn[$sKey]);
}
}
file_put_contents($sPath . PATH_SEP . 'om' . PATH_SEP . 'Base'
. $sClassName . 'Peer.php', $oTP5->getOutputContent());
} catch (Exception $oError) {
throw($oError);
}
}
$producto = new Productos($conn);
$pedidos = new Pedido($conn);
if ($acc == 'add') {
$productos = $producto->ConsultaProductos();
foreach ($productos as $value) {
$tpl->newBlock('productos');
if ($value['activo'] == 1) {
$tpl->assign('nom_producto', $value['nombre']);
$tpl->assign('id_producto', $value['id']);
$tpl->assign('simbolo', $value['simbolo'] . ':' . $value['descripcion'] . ':' . $value['item']);
} else {
$tpl->assign('nom_producto', $value['nombre']);
$tpl->assign('id_producto', $value['id']);
$tpl->assign('dis', 'disabled');
}
$tpl->gotoBlock('_ROOT');
}
$tpl->assign('titulo', "Registro de Información");
$tpl->assign('activo', "checked");
$tpl->printToScreen();
}
if ($acc == 'edit') {
$producto2 = new Productos($conn);
$tpl->assign('titulo', "Editar Información");
$id = $_GET['id'];
$tpl->assign('id', $id);
$pedidos->setId($id);
$producto = $pedidos->consultaPedidoById();
$productos = $producto2->ConsultaProductos();
foreach ($productos as $value) {
$tpl->newBlock('productos');
//seleccionamos el listado de veterinarios para generar el listado a la hora de añadir una cita
$query = "SELECT usuario, nombre FROM usuarios";
$result = mysql_query($query);
while ($tArray = mysql_fetch_assoc($result)) {
$tplAgenda->newBlock("add_veterinario_option");
$tplAgenda->assign("vet_id", $tArray["usuario"]);
$tplAgenda->assign("vet_nombre", $tArray['nombre']);
}
$query = 'SELECT * FROM citas, pacientes
LEFT JOIN
propietarios
ON pacientes.dni_propietario=propietarios.dni
WHERE mascota=pacientes.id_pac
ORDER BY citas.fecha DESC';
$result = mysql_query($query);
$tplAgenda->gotoBlock(TP_ROOTBLOCK);
$tplAgenda->newBlock('lista');
if (mysql_error()) {
echo mysql_error();
} else {
while ($row = mysql_fetch_assoc($result)) {
//mostramos la fecha en formato dd-mm-yyyy y la hora en hh:mm
$fecha = new DateTime($row['fecha'] . " " . $row['hora']);
if ($row["estado"] == 'pendiente') {
$tplAgenda->newBlock('citas_pendientes_row');
$tplAgenda->assign('historia', $row['historia']);
$tplAgenda->assign('nombre', $row['nombre_pac']);
$tplAgenda->assign('especie', $row['especie']);
$tplAgenda->assign('propietario', $row['nombre']);
$tplAgenda->assign('telefono', $row['telefono']);
$tplAgenda->assign('fecha', $fecha->format("d-m-Y"));
function create_file_from_tpl($tplName, $newFilename, $fields = NULL)
{
global $pathHome;
global $projectName;
$httpdTpl = PATH_GULLIVER_HOME . 'bin' . PATH_SEP . 'tasks' . PATH_SEP . 'templates' . PATH_SEP . $tplName . '.tpl';
if (substr($newFilename, 0, 1) == PATH_SEP) {
$httpFilename = $newFilename;
} else {
$httpFilename = $pathHome . PATH_SEP . $newFilename;
}
$template = new TemplatePower($httpdTpl);
$template->prepare();
$template->assignGlobal('pathHome', $pathHome);
$template->assignGlobal('projectName', $projectName);
$template->assignGlobal('rbacProjectName', strtoupper($projectName));
$template->assignGlobal('siglaProjectName', substr(strtoupper($projectName), 0, 3));
$template->assignGlobal('propel.output.dir', '{propel.output.dir}');
if (is_array($fields)) {
foreach ($fields as $block => $data) {
$template->gotoBlock("_ROOT");
if (is_array($data)) {
foreach ($data as $rowId => $row) {
$template->newBlock($block);
foreach ($row as $key => $val) {
if (is_array($val)) {
// $template->newBlock( $key );
foreach ($val as $key2 => $val2) {
if (is_array($val2)) {
$template->newBlock($key);
foreach ($val2 as $key3 => $val3) {
$template->assign($key3, $val3);
}
}
}
} else {
$template->assign($key, $val);
}
}
}
} else {
$template->assign($block, $data);
}
}
}
$content = $template->getOutputContent();
$iSize = file_put_contents($httpFilename, $content);
printf("saved %s bytes in file %s \n", pakeColor::colorize($iSize, 'INFO'), pakeColor::colorize($tplName, 'INFO'));
}
function ShowMessagesPage($CurrentUser)
{
global $xgp_root, $phpEx, $game_config, $dpath, $lang, $messfields, $_POST, $_GET;
includeLang('INGAME');
if ($_POST) {
switch ($_POST["action"]) {
case "delete":
if ($_POST["id"]) {
$MessId = intval($_POST["id"]);
doquery("DELETE FROM {{table}} WHERE `message_id` = '" . $MessId . "' AND message_owner = '" . $CurrentUser["id"] . "'", 'messages', '');
}
exit;
break;
case "deleteall":
$MessCat = intval($_POST["messcat"]);
if ($MessCat != "100") {
$sql = "`message_type` = " . $MessCat . " AND ";
}
doquery("DELETE FROM {{table}} WHERE {$sql} message_owner = " . $CurrentUser["id"], 'messages');
exit;
break;
}
}
// ADD SMILIES ARRAY
//makeSmiliesArray();
include_once $xgp_root . 'includes/classes/class.TemplatePower.inc.' . $phpEx;
$tp = new TemplatePower($xgp_root . TEMPLATE_DIR . "messages_new.tpl");
$tp->prepare();
$OwnerID = $_GET['id'];
$MessCategory = isset($_GET['messcat']) ? $_GET['messcat'] : '100';
$MessPageMode = isset($_GET['mode']) ? $_GET['mode'] : 'show';
$UsrMess = doquery("SELECT * FROM {{table}} WHERE `message_owner` = '" . $CurrentUser['id'] . "' ORDER BY `message_time` DESC;", 'messages');
$UnRead = $CurrentUser;
$MessageType = array(100, 0, 1, 2, 3, 4, 5, 15, 99);
$TitleColor = array(0 => '#FFFF00', 1 => '#FFFF00', 2 => '#FFFF00', 3 => '#FFFF00', 4 => '#FFFF00', 5 => '#FFFF00', 15 => '#FFFF00', 99 => '#FFFF00', 100 => '#FFFF00');
$BackGndColor = array(0 => '#663366', 1 => '#663366', 2 => '#663366', 3 => '#663366', 4 => '#663366', 5 => '#663366', 15 => '#663366', 99 => '#663366', 100 => '#663366');
foreach ($MessageType as $MessType) {
$TotalMess[$MessType] = 0;
}
while ($CurMess = mysql_fetch_array($UsrMess)) {
$MessType = $CurMess['message_type'];
$TotalMess[$MessType] += 1;
$TotalMess[100] += 1;
}
foreach ($MessageType as $k => $id) {
$tp->newBlock("message_type");
$replace[type] = $id;
$replace[unread] = $WaitingMess[$id];
$replace[total] = $TotalMess[$id];
$replace[name] = $lang['mg_type'][$id];
foreach ($replace as $k => $v) {
$tp->assign($k, $v);
}
}
switch ($MessPageMode) {
case 'write':
if ($_REQUEST['subject']) {
$subject = $_REQUEST['subject'];
}
if (!is_numeric($OwnerID)) {
header("location:game.php?page=messages");
}
$OwnerRecord = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $OwnerID . "';", 'users', true);
if (!$OwnerRecord) {
header("location:game.php?page=messages");
}
$OwnerHome = doquery("SELECT * FROM {{table}} WHERE `id_planet` = '" . $OwnerRecord["id_planet"] . "';", 'galaxy', true);
if (!$OwnerHome) {
header("location:game.php?page=messages");
}
if ($_POST) {
$error = 0;
$errorlist = "";
if (!$_POST["subject"] & !$_POST["text"]) {
$errorlist .= $lang['mg_no_text_subject'];
$error++;
} elseif (!$_POST["subject"]) {
$errorlist .= $lang['mg_no_subject'];
$error++;
} elseif (!$_POST["text"]) {
$errorlist .= $lang['mg_no_text'];
$error++;
}
if ($error != 0) {
message($errorlist);
} else {
$_POST['text'] = str_replace("'", ''', $_POST['text']);
// $_POST['text'] = str_replace('rn', '<br />', $_POST['text']);
$Owner = $OwnerID;
$Sender = $CurrentUser['id'];
$From = $CurrentUser['username'] . " [" . $CurrentUser['galaxy'] . ":" . $CurrentUser['system'] . ":" . $CurrentUser['planet'] . "]";
$Subject = $_POST['subject'];
$Message = preg_replace("/([^\\s]{80}?)/", "\\1<br />", trim(nl2br(strip_tags($_POST['text'], '<br>'))));
SendSimpleMessage($Owner, $Sender, '', 1, $From, $Subject, $Message);
$subject = "";
$text = "";
message($lang['mg_msg_sended'], "game.php?page=messages", "2");
}
}
$parse['id'] = $OwnerID;
$parse['to'] = $OwnerRecord['username'] . " [" . $OwnerHome['galaxy'] . ":" . $OwnerHome['system'] . ":" . $OwnerHome['planet'] . "]";
$parse['subject'] = !isset($subject) ? $lang['mg_sin_subject'] : $subject;
$parse['text'] = $text;
$tp->newBlock("new_message");
$tp->assign("new_message", parsetemplate(gettemplate('messages_pm_form'), $parse));
break;
default:
case 'show':
if ($CurrentUser["new_message"] != 0) {
doquery("UPDATE {{table}} SET `new_message` ='0' WHERE `id` = '" . $CurrentUser['id'] . "' ", "users", '');
}
if ($MessCategory == 100) {
$UsrMess = doquery("SELECT SQL_CACHE * FROM {{table}} WHERE `message_owner` = " . $CurrentUser['id'] . " ORDER BY `message_time` DESC;", 'messages', '');
} else {
$UsrMess = doquery("SELECT SQL_CACHE * FROM {{table}} WHERE `message_owner` = " . $CurrentUser['id'] . " AND `message_type` = " . intval($MessCategory) . " ORDER BY `message_time` DESC;", 'messages', '');
}
while ($CurMess = @mysql_fetch_array($UsrMess)) {
unset($replace);
$tp->newBlock("message");
$replace[id] = $CurMess['message_id'];
$replace[mdate] = date("m-d H:i:s O", $CurMess['message_time']);
$replace[from] = stripslashes($CurMess['message_from']);
$replace[subject] = stripslashes($CurMess['message_subject']);
//$replace[message] = makeMessageSmilies(nl2br( stripslashes( $CurMess['message_text'] ) ));
$replace[message] = nl2br(stripslashes($CurMess['message_text']));
foreach ($replace as $k => $v) {
$tp->assign($k, $v);
}
if ($CurMess['message_type'] == 1 or $CurMess['message_type'] == 2) {
unset($replace);
$tp->newBlock("answer");
$replace[id] = $CurMess['message_sender'];
$replace[subject] = $lang['mg_answer_prefix'] . htmlspecialchars($CurMess['message_subject']);
foreach ($replace as $k => $v) {
$tp->assign($k, $v);
}
}
}
break;
}
$tp->gotoBlock("_ROOT");
$tp->assignGlobal("PHPSELF", $_SERVER['PHP_SELF']);
foreach ($lang as $name => $trans) {
$tp->assignGlobal("lang_" . $name, $trans);
}
$page .= $tp->getOutputContent();
display($page);
}
<?php
session_start();
include "inc.includes.php";
$db = new BaseDatos($config['dbhost'], $config['dbuser'], $config['dbpass'], $config['db']);
$tpl = new TemplatePower("templates/index.html");
$tpl->prepare();
$tpl->gotoBlock("_ROOT");
//isset determina si una variable esta definida o es null
//$_REQUEST tiene el contenido de get y post
if (!isset($_REQUEST["action"]) || $_REQUEST["action"] == "") {
$tpl->newBlock("contenido");
$mhotels = new MHotels();
$result = $mhotels->allhoteles();
if ($result['found']) {
foreach ($result['result'] as $r) {
$tpl->newblock("hotels");
$tpl->assign("idHotel", $r['id_hotel']);
$tpl->assign("name", $r['nom_hotel']);
$tpl->assign("prov", $r['provincia']);
$tpl->assign("local", $r['localidad']);
$tpl->assign("calle", $r['calle']);
$tpl->assign("ncalle", $r['nro_calle']);
$tpl->assign("tel", $r['telefono']);
$tpl->assign("precio", $r['precio_persona']);
}
} else {
$tpl->newblock("no_hotels");
}
$webapp = $tpl->getOutputContent();
} else {
$tplPropietarios->newBlock("mascota_lista");
} else {
$tplPropietarios->newBlock("mascota_no");
}
}
$tplPropietarios->newBlock('resultado_mascotas');
$tplPropietarios->assign('id_prop', $result['id_prop']);
$tplPropietarios->assign('historia', $result['historia']);
$tplPropietarios->assign('nombre_pac', $result['nombre_pac']);
$tplPropietarios->assign('especie', $result['especie']);
$tplPropietarios->assign('raza', $result['raza']);
$tplPropietarios->assign('sexo', $result['sexo']);
$tplPropietarios->assign('edad', $result['edad']);
$tplPropietarios->assign('id_pac', $result['id_pac']);
}
$tplPropietarios->gotoBlock('mascotas');
} else {
$tplPropietarios->newBlock('add_prop_button');
$tplPropietarios->newBlock('add');
$tplPropietarios->newBlock('lista');
//mostramos todos los propietarios registrados en el sistema
$query = "SELECT * FROM propietarios ORDER BY id_prop";
$rec = mysql_query($query);
if (mysql_error()) {
echo mysql_error();
} else {
while ($result = mysql_fetch_array($rec)) {
$tplPropietarios->newBlock('fila');
$tplPropietarios->assign('nombre', $result['nombre']);
$tplPropietarios->assign('dni', $result['dni']);
$tplPropietarios->assign('telefono', $result['telefono']);
