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; }