function Tablas($Arg)
{
global $vConex, $enlace;
if ($Arg == "SubirTablas") {
$btn = "<div class='botIconS'><i class='icon-arrow-left'></i></div>]" . $enlace . "?accionCT=tablas]cuerpo}";
$btn = Botones($btn, 'botones1', '');
$titulo = "<span>Subir Tablas </span><p>CONECTATE A UNA BASE DE DATOS</p><div class='bicel'></div>";
$btn_titulo = tituloBtnPn($titulo, $btn, "80px", "TituloA");
$uRLForm = "Siguiente]" . $enlace . "?Tablas=SubirTablas-DBase]PanelInferior]F]}";
$tSelectD = array('Nombre' => 'SELECT Nombre, Nombre FROM sys_base_datos ');
$form = c_form("", $vConex, "select_bdatos", "CuadroA", "", $uRLForm, $CodDet, $tSelectD);
$s = "<div id = 'PanelInferior' style='float:left;width:50%;' >" . $form . "</div>";
WE($btn_titulo . $s);
}
if ($Arg == "SubirTablas-DBase") {
$Base_Datos = post("Nombre");
$ConexionBExt = conexSis_Emp($Base_Datos);
$result = mysql_list_tables($Base_Datos);
$s = "<form method='post' name='Form_sys_form1' id='Form_sys_form1' class='CuadroA' action='javascript:void(null);' enctype='multipart/form-data'>";
while ($row = mysql_fetch_row($result)) {
$s .= "<div style='width:100%;float:left;'>";
$s .= "<span>" . $row[0] . "</span>";
$s .= "<input type='checkbox' name='ky[]' value='" . $row[0] . "' >";
$s .= "</div>";
}
$s .= "<div class='Botonera'>";
$viewdata = array();
$viewdata['sUrl'] = $enlace . "?Tablas=Process-Tabla&Nombre=" . $Base_Datos;
$viewdata['formid'] = "Form_sys_form1";
$viewdata['sDivCon'] = "cuerpo";
$viewdata['sIdCierra'] = "";
$s .= "<button onclick=enviaFormS('" . json_encode($viewdata) . "'); class='" . $atributoBoton[5] . "' >";
$s .= "Actualizar";
$s .= "</button>";
$s .= "</div>";
$s .= "</form>";
WE($s);
}
if ($Arg == "Process-Tabla") {
$Base_Datos = get("Nombre");
$Tablas = post("ky");
$ConexionBExt = conexSis_Emp($Base_Datos);
for ($j = 0; $j < count($Tablas); $j++) {
$_sql = 'SELECT * FROM ' . $Tablas[$j];
$consulta = mysql_query($_sql, $ConexionBExt);
$resultado = $consulta or die(mysql_error());
$datos = array();
for ($i = 0; $i < mysql_num_fields($consulta); ++$i) {
$campo = mysql_field_name($consulta, $i);
$type = mysql_field_type($consulta, $i);
$size = mysql_field_len($consulta, $i);
if ($type == 'string') {
$type = 'varchar';
}
$datos[$i] = array('Campo' => $campo, 'Tipo' => $type, 'Tamano' => $size);
$conta++;
}
$sql = 'SELECT Codigo,Descripcion FROM sys_tabla WHERE Codigo = "' . $Tablas[$j] . '" ';
$rg = fetch($sql);
$codigo = $rg["Codigo"];
if ($codigo == "") {
$sql = 'INSERT INTO sys_tabla(Codigo,Descripcion,Estado) VALUES ("' . $Tablas[$j] . '","' . $Tablas[$j] . '","Activo")';
W(xSQL($sql, $vConex) . "<br>");
for ($k = 0; $k < $conta; ++$k) {
$cod_sys_tabla_det = numerador("sys_tabla_det", 1, "");
$_sql2 = 'INSERT INTO sys_tabla_det (Codigo,Descripcion,TipoCampo,sys_tabla,Size) VALUES (' . $cod_sys_tabla_det . ',"' . $datos[$k]['Campo'] . '","' . $datos[$k]['Tipo'] . '","' . $Tablas[$j] . '","' . $datos[$k]['Tamano'] . '")';
xSQL($_sql2, $vConex);
}
W("La tabla " . $codigo . " Fue Insertada <br>");
} else {
W("La tabla " . $codigo . " ya existe <br>");
}
}
}
if ($Arg == "SubirTablas-DBase") {
$btn = "<div class='botIconS'><i class='icon-arrow-left'></i></div>]" . $enlace . "?accionCT=tablas]cuerpo}";
$btn = Botones($btn, 'botones1', '');
$titulo = "<span>Importar Tablas </span><p>CONECTATE A UNA BASE DE DATOS</p><div class='bicel'></div>";
$btn_titulo = tituloBtnPn($titulo, $btn, "80px", "TituloA");
$uRLForm = "Siguiente]" . $enlace . "?Tablas=Importar-Seleccion-Tab]cuerpo]F]}";
$tSelectD = array('Nombre' => 'SELECT Nombre, Nombre FROM sys_base_datos ');
$form = c_form("", $vConex, "select_bdatos", "CuadroA", "", $uRLForm, $CodDet, $tSelectD);
$s = "<div id = 'PanelInferior' style='float:left;width:50%;' >" . $form . "</div>";
WE($btn_titulo . $s);
}
if ($Arg == "Importar-Seleccion") {
$btn = "<div class='botIconS'><i class='icon-arrow-left'></i></div>]" . $enlace . "?accionCT=tablas]cuerpo}";
$btn = Botones($btn, 'botones1', '');
$titulo = "<span>Importar Tablas </span><p>CONECTATE A UNA BASE DE DATOS</p><div class='bicel'></div>";
$btn_titulo = tituloBtnPn($titulo, $btn, "80px", "TituloA");
$uRLForm = "Siguiente]" . $enlace . "?Tablas=Importar-Seleccion-Tab]cuerpo]F]}";
$uRLForm .= "Importar Archivo]" . $enlace . "?Tablas=Importar-Archivo-Tab]cuerpo]F]}";
$tSelectD = array('Nombre' => 'SELECT Nombre, Nombre FROM sys_base_datos ');
$form = c_form("", $vConex, "select_bdatos", "CuadroA", "", $uRLForm, $CodDet, $tSelectD);
$s = "<div id = 'PanelInferior' style='float:left;width:50%;' >" . $form . "</div>";
WE($btn_titulo . $s);
}
if ($Arg == "Importar-Seleccion-Tab") {
$Base_Datos = post("Nombre");
$ConexionBExt = conexSis_Emp($Base_Datos);
$btn = "<div class='botIconS'><i class='icon-arrow-left'></i></div>]" . $enlace . "?Tablas=Importar-Seleccion&Base_Datos=" . $Base_Datos . "]cuerpo}";
$btn .= "Importar]" . $enlace . "?Tablas=Importar-Seleccion-UPTab&Base_Datos=" . $Base_Datos . "]cuerpo]CHECK}";
$btn .= "Importar con datos]" . $enlace . "?Tablas=Importar-Cdata&Base_Datos=" . $Base_Datos . "]cuerpo]CHECK}";
$btn = Botones($btn, 'botones1', 'sys_tabla');
$titulo = "<span>Importar Tablas </span><p>BD " . $Base_Datos . "</p><div class='bicel'></div>";
$btn_titulo = tituloBtnPn($titulo, $btn, "380px", "TituloA");
$sql = 'SELECT
Codigo AS Tabla
,Codigo AS CodigoAjax
,DATE_FORMAT(FechaRegistro,"%d %M %Y") AS FechaCreacion
FROM sys_tabla ORDER BY FechaRegistro DESC ';
$clase = 'reporteA';
$enlaceCod = 'codigoForm';
$url = $enlace . "?Tablas=Importar-Seleccion-UPTab&Base_Datos=" . $Base_Datos . "";
$panel = 'cuerpo';
$reporte = ListR2("", $sql, $ConexionBExt, $clase, '', $url, $enlaceCod, $panel, 'sys_tabla', 'checks', '');
$reporte = "<div id = 'cuerpo' style='float:left;width:50%;' >" . $reporte . "</div>";
WE($btn_titulo . $reporte);
}
if ($Arg == "Importar-Seleccion-UPTab") {
$Base_Datos = get("Base_Datos");
$campos = post("ky");
for ($j = 0; $j < count($campos); $j++) {
$sql = 'SELECT Codigo FROM sys_tabla WHERE Codigo = "' . $campos[$j] . '" ';
$rg = fetch($sql);
$tabla = $rg["Codigo"];
if (empty($tabla)) {
$ConexionBExt = conexSis_Emp($Base_Datos);
$sql = 'CREATE TABLE owlgroup_owl.' . $campos[$j] . ' LIKE ' . $Base_Datos . '.' . $campos[$j] . ' ';
$rg = fetch($sql);
$ConexionBExt = conexSis_Emp($Base_Datos);
$condiciones[0] = " Codigo = '" . $campos[$j] . "' ";
$vSQLA = GeneraScriptGen($ConexionBExt, "sys_tabla", $condiciones, "", "");
$vConexR = conexSis_Emp("owlgroup_owl");
xSQL($vSQLA, $vConexR);
$ConexionBExt = conexSis_Emp($Base_Datos);
$sql = 'SELECT * FROM sys_tabla_det WHERE sys_tabla = "' . $campos[$j] . '" ';
$consulta = Matris_Datos($sql, $ConexionBExt);
$cont = 0;
while ($reg = mysql_fetch_array($consulta)) {
$vConexB = conexSis_Emp("owlgroup_owl");
$Codigo_Correlativo = numeradorB("sys_tabla_det", 10, '', $vConexB);
$ConexionBExt = conexSis_Emp($Base_Datos);
$condiciones[0] = " Codigo='" . $reg["Codigo"] . "' ";
$vSQLC = GeneraScriptGen($ConexionBExt, "sys_tabla_det", $condiciones, $Codigo_Correlativo, "");
echo '<pre>';
print_r($vSQLC);
echo '</pre>';
$vConexR = conexSis_Emp("owlgroup_owl");
xSQL($vSQLC, $vConexR);
}
} else {
ModTabla($Base_Datos, $tabla);
}
}
WE("");
}
if ($Arg == "Importar-Cdata") {
$Base_Datos = get("Base_Datos");
$campos = post("ky");
for ($j = 0; $j < count($campos); $j++) {
$sql = 'SELECT Codigo FROM sys_tabla WHERE Codigo = "' . $campos[$j] . '" ';
$rg = fetch($sql);
$tabla = $rg["Codigo"];
if (empty($tabla)) {
WE("La Tabla no está creada");
} else {
$sql = 'DELETE FROM ' . $campos[$j] . '';
xSQL($sql, $vConex);
$ConexionBExt = conexSis_Emp($Base_Datos);
$sql = 'INSERT INTO owlgroup_owl.' . $campos[$j] . ' SELECT * FROM ' . $Base_Datos . '.' . $campos[$j] . ' ';
xSQL($sql, $ConexionBExt);
WE("Datos Migrados");
}
}
WE("");
}
}
function upload($usuario, $empresa, $conexion)
{
$path = (string) $_POST['path'];
$filedata = (string) $_POST['filedata'];
$formId = (string) $_POST['formId'];
$campo = (string) $_POST['campo'];
$return = array('success' => false, 'msg' => 'No se pudo subir el archivo.');
if ($_FILES['error'] == UPLOAD_ERR_OK) {
$filedata = unserialize(base64_decode($filedata));
$filesize = $_FILES['file']['size'];
$maxfile = $filedata['maxfile'] * 1048576;
if ($filesize <= $maxfile) {
$codigo = (int) numerador('archivoTemporal', 0, '');
$return = uploadfile($codigo, $_FILES, $path, $filedata['tipos']);
if ($return['success']) {
deleteFileTemporal($formId, $conexion);
insertFileTemporal($codigo, $return, $formId, $campo, $usuario, $empresa, $conexion);
}
} else {
$return['msg'] = 'El archivo no puede superar los ' . $filedata['maxfile'] . ' Mb';
}
}
return $return;
}
function upload($usuario, $empresa, $conexion)
{
if (get('VUP')) {
//VUP : Valida Upload
$filedata = (string) $_GET['filedata'];
$filedata = unserialize(base64_decode($filedata));
$return = array('filedata' => $filedata);
return $return;
}
$path = (string) post("path");
$filedata = (string) post("filedata");
$formId = (string) post("formId");
$campo = (string) post("campo");
$return = array('success' => false, 'msg' => 'No se pudo subir el archivo.');
if ($_FILES['error'] == UPLOAD_ERR_OK) {
$filedata = unserialize(base64_decode($filedata));
$filesize = $_FILES["file"]["size"];
$maxfile = $filedata["maxfile"] * 1024 * 1024;
if ($filesize <= $maxfile) {
$codigo = (int) numerador('archivoTemporal', 0, '');
$return = uploadfile($codigo, $_FILES, $path, $filedata["tipos"]);
if ($return['success']) {
//deleteFileTemporal($formId, $conexion);
insertFileTemporal($codigo, $return, $formId, $campo, $usuario, $empresa, $conexion);
}
} else {
$return['msg'] = "El archivo no puede superar los {$filedata["maxfile"]} Mb";
}
}
// return "daniel";
return $return;
}
function actualizaTabla($parm)
{
global $vConex, $enlace;
mysql_select_db("defsei_ecommerce") or die("Imposible seleccionar base de datos");
$result = mysql_list_tables("defsei_ecommerce");
if (!$result) {
echo "DB Error, No se pueden listar las tablas";
echo 'MySQL Error: ' . mysql_error();
}
while ($row = mysql_fetch_row($result)) {
if ($row[0] == "elevaluacionalumno") {
$conta = 0;
$sql = 'SELECT Codigo,Descripcion FROM sys_tabla WHERE Codigo = "' . $row[0] . '" ';
$rg = rGT($vConex, $sql);
$codigo = $rg["Codigo"];
$_sql = 'SELECT * FROM ' . $row[0];
$consulta = mysql_query($_sql, $vConex);
$resultado = $consulta or die(mysql_error());
$datos = array();
for ($i = 0; $i < mysql_num_fields($consulta); ++$i) {
$campo = mysql_field_name($consulta, $i);
$type = mysql_field_type($consulta, $i);
$size = mysql_field_len($consulta, $i);
if ($type == 'string') {
$type = 'varchar';
}
$datos[$i] = array('Campo' => $campo, 'Tipo' => $type, 'Tamano' => $size);
$conta++;
}
if ($codigo == "") {
$sql = 'INSERT INTO sys_tabla(Codigo,Descripcion,Estado) VALUES ("' . $row[0] . '","' . $row[0] . '","Activo")';
W(xSQL($sql, $vConex) . "<br>");
for ($j = 0; $j < $conta; ++$j) {
$cod_sys_tabla_det = numerador("sys_tabla_det", 1, "");
$_sql2 = 'INSERT INTO sys_tabla_det (Codigo,Descripcion,TipoCampo,sys_tabla,Size) VALUES (' . $cod_sys_tabla_det . ',"' . $datos[$j]['Campo'] . '","' . $datos[$j]['Tipo'] . '","' . $row[0] . '","' . $datos[$j]['Tamano'] . '")';
xSQL($_sql2, $vConex);
}
} else {
W($codigo . "<br>");
}
}
}
mysql_free_result($result);
vistaCT("tablas");
}
public function put()
{
$config = $this->uploadService->getConfig();
// $config = new UploadService_Config();
$configConstraints = $config->getConstraints();
// $configConstraints = new UploadService_Config_Constraints();
$response = ["success" => false, "message" => null, "file" => ["name" => null, "uri" => null, "isVideo" => false]];
$path = file::cleanPath($config->getPath());
//prepare file
$file = $_FILES["file"];
$fileError = $file["error"];
$fileName = $file["name"];
$fileSize = $file["size"];
$fileTempName = $file["tmp_name"];
$fileType = $file["type"];
$fileName = file::cleanName($fileName);
//get numerator
$numerator = (int) numerador('archivoTemporal', 0, '');
$newFileName = "{$numerator}-{$fileName}";
//destinies
$basePath = $_SERVER['DOCUMENT_ROOT'];
$S3destiny = "{$path}/{$newFileName}";
$destiny = "{$basePath}/{$S3destiny}";
if ($fileError === UPLOAD_ERR_OK) {
$videoControl = file::isVideo($fileName) && $config->getVideoPlatform();
if ($videoControl) {
//video control
$response["success"] = move_uploaded_file($fileTempName, $destiny);
} else {
set_time_limit(600);
//destiny file
switch ($config->getToserver()) {
case UploadService::TO_S3:
$S3 = new S3(AWS_ACCES_KEY, AWS_SECRET_KEY);
$response["success"] = $S3->putObjectFile($fileTempName, "owlgroup", $S3destiny, S3::ACL_PUBLIC_READ);
break;
case UploadService::TO_SERVER:
$destinyFolder = str_replace("/{$newFileName}", '', $destiny);
!file_exists($destinyFolder) && !is_dir($destinyFolder) && creaCarpeta($destinyFolder);
$response["success"] = move_uploaded_file($fileTempName, $destiny);
break;
case UploadService::TO_BOTH:
$S3 = new S3(AWS_ACCES_KEY, AWS_SECRET_KEY);
$destinyFolder = str_replace("/{$newFileName}", '', $destiny);
!file_exists($destinyFolder) && !is_dir($destinyFolder) && creaCarpeta($destinyFolder);
$response["success"] = $S3->putObjectFile($fileTempName, "owlgroup", $S3destiny, S3::ACL_PUBLIC_READ) && move_uploaded_file($fileTempName, $destiny);
break;
}
}
if ($response["success"]) {
$response["file"]["name"] = $newFileName;
//Insert register to file temporal table
$formId = post("form");
$field = post("field");
$userId = $_SESSION["Persona"]["string"];
$enterpriseUser = $_SESSION["enterprise_user"];
addTempFile($numerator, $path, $newFileName, $fileName, $fileType, $formId, $userId, $enterpriseUser, $field);
if ($videoControl) {
//video control
switch ($config->getVideoPlatform()) {
case UploadService::VIDEO_PLATFORM_OWL:
//NOTHING HERE
break;
case UploadService::VIDEO_PLATFORM_YOUTUBE:
set_time_limit(18000);
$systemGoogleClient = get_system_google_client();
if ($systemGoogleClient) {
$client = $systemGoogleClient->client;
//Define an object that will be used to make all API requests.
$youtube = new Google_Service_YouTube($client);
try {
$fileSize = filesize($destiny);
$videoSnippet = new Google_Service_YouTube_VideoSnippet();
$videoSnippet->setTitle($fileName);
$videoSnippet->setDescription("This video was upload in " . date("Y-m-d H:i:s"));
$videoStatus = new Google_Service_YouTube_VideoStatus();
$videoStatus->setPrivacyStatus("unlisted");
//public | private | unlisted
$video = new Google_Service_YouTube_Video();
$video->setSnippet($videoSnippet);
$video->setStatus($videoStatus);
$chunkSizeBytes = 1 * 1024 * 1024;
//1 megabyte
$client->setDefer(true);
//snippet,contentDetails,fileDetails,player,processingDetails,recordingDetails,statistics,status,suggestions,topicDetails
$httpRequest = $youtube->videos->insert("status,snippet", $video);
$mediaFileUpload = new Google_Http_MediaFileUpload($client, $httpRequest, 'video/*', null, true, $chunkSizeBytes);
$mediaFileUpload->setFileSize($fileSize);
$status = false;
//open flow resource video file in binary mode
$handle = fopen($destiny, "rb");
while (!$status && !feof($handle)) {
$chunk = fread($handle, $chunkSizeBytes);
$status = $mediaFileUpload->nextChunk($chunk);
}
//close flow reource
fclose($handle);
$client->setDefer(false);
$videoInserted = $status;
//Google_Service_YouTube_Video class;
$response["file"]["name"] = $videoInserted->getId();
} catch (Google_Service_Exception $e) {
$response["success"] = false;
$response["message"] = htmlspecialchars("A service error occurred: {$e->getMessage()}");
} catch (Google_Exception $e) {
$response["success"] = false;
$response["message"] = htmlspecialchars("An client error occurred: {$e->getMessage()}");
}
} else {
$response["success"] = false;
$response["message"] = "Ha ocurrido un error al establecer un medio para Google Services";
}
//delete file because it's not necesary save in the server when the file is a video
unlink($destiny);
break;
}
} else {
if (file::isImage($fileName)) {
switch ($config->getToserver()) {
case UploadService::TO_S3:
case UploadService::TO_BOTH:
$response["file"]["uri"] = CONS_IPArchivos . "/{$S3destiny}";
break;
case UploadService::TO_SERVER:
$response["file"]["uri"] = getDomain() . "/{$S3destiny}";
break;
}
}
}
} else {
$response["message"] = "Destiny directory don't exists or isn't writable, type to server is {$config->getToserver()}";
}
} else {
$response["message"] = "Happened a error whit code {$fileError}";
}
return $response;
}
