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']);