public function ReferenciaTablaColumn($tablename, $column_name)
{
$config = XTConfig::singleton();
$esquema = $config->get('XTDBNAME');
$this->TraerDatos(array('referenced_table_name', 'referenced_column_name'), array('information_schema.KEY_COLUMN_USAGE'), array("table_schema='{$esquema}'", "table_name='{$tablename}'", "referenced_table_name is not null", "column_name='{$column_name}'"), array(), array(), array());
return $this->getData();
}
public static function Enviar($asunto, $mensaje, $destinatario, $nombredestinatario, $archivo = array())
{
$config = XTConfig::singleton();
$mail = new PHPMailer();
if ($config->get(XTSITE_SMTP)) {
$mail->IsSMTP();
}
if ($config->get(XTSITE_SMTP_AUTH)) {
$mail->SMTPAuth = true;
}
$mail->SMTPSecure = $config->get(XTSITE_SMTP_SECURE);
$mail->Host = $config->get(XTSITE_SMTP_SERVER);
$mail->Port = $config->get(XTSITE_SMTP_PORT);
$mail->Username = $config->get(XTSITE_SMTP_USER);
$mail->Password = $config->get(XTSITE_SMTP_PASSWORD);
$mail->From = $config->get(XTSITE_SMTP_FROM);
$mail->FromName = $config->get(XTSITE_SMTP_FROMNAME);
$mail->Subject = "{$asunto}";
$mail->MsgHTML("{$mensaje}");
$mail->AddAddress("{$destinatario}", "{$nombredestinatario}");
$mail->IsHTML(true);
if (count($archivo) > 0) {
foreach ($archivo as $miarchivo) {
if (file_exists($miarchivo)) {
$mail->AddAttachment($miarchivo);
}
}
}
$transret = $mail->Send();
if ($transret != true) {
//echo $mail->ErrorInfo;
}
return $transret;
}
static function RichText($Nombre, $parametros = array())
{
$config = XTConfig::singleton();
$user_media_path = $parametros['media_path'];
if ($user_media_path == "") {
$XTMEDIA_PATH = $config->get("XTMEDIA_PATH");
$XTMEDIA_PATH_ABSOLUTE = $config->get("XTMEDIA_PATH_ABSOLUTE");
} else {
$XTMEDIA_PATH = $config->get("XTSITE_PATH") . $user_media_path;
$XTMEDIA_PATH_ABSOLUTE = $config->get("XTSITE_PATH_ABSOLUTE") . $user_media_path;
//echo "$XTMEDIA_PATH -> $XTMEDIA_PATH_ABSOLUTE";
}
$XTMEDIA_PATH = base64_encode($XTMEDIA_PATH);
$XTMEDIA_PATH_ABSOLUTE = base64_encode($XTMEDIA_PATH_ABSOLUTE);
$Datos = !isset($parametros["valor"]) ? "" : $parametros["valor"];
echo "<textarea cols=\"80\" id=\"{$Nombre}\" name=\"{$Nombre}\" rows=\"10\">{$Datos}</textarea>";
?>
<script type="text/javascript">
$( document ).ready( function() {
CKEDITOR.config.customConfig = '<?php
echo $config->get("XTSITE_PATH") . "plugins/ckeditor/custom_config.js";
?>
';
var c_editor = $( '#<?php
echo $Nombre;
?>
' ).ckeditor({
height: 400,
filebrowserBrowseUrl: '<?php
echo DefFilebrowserBrowseUrl;
?>
?u=<?php
echo $XTMEDIA_PATH;
?>
&p=<?php
echo $XTMEDIA_PATH_ABSOLUTE;
?>
'
});
} );
</script>
<?php
}
public function gbarra_getImagen($titulo = " ", $width = "500", $height = "350")
{
$config = XTConfig::singleton();
$data = $this->barra_data;
$nombreimagen = uniqid() . "barraimagen.png";
$file = $config->get("XTSITE_PATH_ABSOLUTE") . "tmp/pie/" . $nombreimagen;
$file_url = $config->get("XTSITE_PATH") . "tmp/pie/" . $nombreimagen;
$graph = new PHPGraphLib($width, $height, $file);
$graph->addData($data);
//$graph->setBarColor('255,255,204');
$graph->setGradient('255,255,204', '254,254,154');
if ($titulo != "") {
$graph->setTitle($titulo);
}
$graph->setLineColor('maroon');
$graph->setDataPointColor('maroon');
$graph->setXValuesHorizontal(true);
$graph->setLine(true);
$graph->setDataPoints(true);
$graph->setDataValues(true);
$graph->createGraph();
print "<img src=\"{$file_url}\">";
}
public static function singleton()
{
if (!isset(self::$instance)) {
$c = __CLASS__;
self::$instance = new $c();
}
return self::$instance;
}
<?php
/** * @version 1.0.0
* @package XTFRAMEWORK
* @author JaVuu
* @copyright Copyright (C) 2011 por EcuaLatino. Todos los derechos reservados.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, mire LICENSE.php
*/
defined("_XTEXEC") or die("Area restingida");
$config = XTConfig::singleton();
define("XTSITE_PATH_ABSOLUTE", $config->get("XTSITE_PATH_ABSOLUTE"));
function CrearArchivo($file, $datos = '')
{
$cabecera = "<?php\n";
$ar = fopen($file, "w");
fputs($ar, $cabecera . $datos);
echo "<b>Creado:</b> {$file}<br>";
}
function CrearArchivoJS($file, $datos = '')
{
$cabecera = "";
$ar = fopen($file, "w");
fputs($ar, $cabecera . $datos);
echo "<b>Creado:</b> {$file}<br>";
}
function quitartokens($table_name)
{
$tokens = split(";", AJX_TOKENS);
foreach ($tokens as $tok) {
$table_name = str_replace($tok, "", $table_name);
}
static function Paginacion($total_registros, $parametros = array())
{
$config = XTConfig::singleton();
$xtcom = XTUtils::Request("xtcom");
$app = XTUtils::Request("app");
$accion = XTUtils::Request("accion");
$pagina = $parametros["pagina"];
$params = $parametros["params"];
$sFileName = $parametros["url"];
$sFileName = $sFileName == "" ? "index.php" : $sFileName;
$pagina = $pagina == "" ? XTUtils::Request("xtpagcon") : $pagina;
$tam_paginacion = $parametros["tam_paginacion"];
$params = "&{$params}";
$pagina = $pagina == "" ? "1" : $pagina;
if ($tam_paginacion == "") {
$registros = XTRECORD_x_PAGES;
} else {
$registros = $tam_paginacion;
}
$total_paginas = ceil($total_registros / $registros);
$sFileName = "{$sFileName}?app={$app}&xtcom={$xtcom}&accion={$accion}";
echo "<table class='paging-table' style='width:100%'>";
echo "<tfoot>\n";
echo "<tr>";
echo ' <th valign="middle" >';
if ($total_registros) {
echo "<div style='float:left'> Total Registros: {$total_registros}</div><div style='float:right'>";
if ($pagina - 1 > 0) {
echo "<a style=\"color:#2c4d79;text-decoration :none\" href='" . $sFileName . "&xtpagcon=" . ($pagina - 1) . $params . "'>Anterior</a> ";
}
if ($total_paginas < 10) {
for ($i = 1; $i <= $total_paginas; $i++) {
if ($pagina == $i) {
echo "<strong style=\"font-size:14px\">" . $pagina . "</strong> ";
} else {
echo "<a style=\"color:#2c4d79\" href='" . $sFileName . "&xtpagcon=" . $i . $params . "'>{$i}</a> ";
}
}
}
if ($pagina + 1 <= $total_paginas) {
echo " <a style=\"color:#2c4d79;text-decoration :none\" href='" . $sFileName . "&xtpagcon=" . ($pagina + 1) . $params . "'>Siguiente</a>";
}
echo "</div>";
}
echo "</th>";
echo "</tr>";
echo "<tfoot>\n";
echo "</table>";
}
