<?

require_once('../include/orm.php');
require_once('../include/globals.php');
require_once('../include/util.php'); 


$_import_dbimport_db_connected = $Link == ''; 
if($_import_dbimport_db_connected) $Link = connectDb();
define('DBCONNECTED', 1);


debugstartpage();


if( isset($_x) ) {
//if( $_x != '' ) {
    $_x = $_x == '' ? array() : StringTokenize($_x, ",");
    $_result = array();
    $_result['version'] = array('actual' => 22);
    $_result['visibility'] = array();
    $_initialvars = arrayExclude(get_defined_vars(), array("_*", "form_*", "s_*", "GLOBALS", "Link", "thisname"));
}


require('../include/base.events.php');


// isbasewindow: 


// PHP Vars 
while( ($__action == "" or $__action == "executedonopen") and isset($_GET['_x']) and empty($_x) ) {
    $__row0 = array();
    
	$__row0['__form1__1'] =  $_id ;
	$__row0['__form1__2'] =  $id == '0' ? 'Nueva ' : '' ;


	$__row0['__tabla__1'] =   $tabla  ;

	$__row0['__where__1'] =   $where  ;


    $_result['morevars'] = $__row0;
    break;
}


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) { 
    require_once('../include/fpdfreport.php');
    $_pdf = new PDF((isset($_orientation) ? $_orientation : 'P'),'pt', (isset($_size) ? $_size : 'A4' ));
    $_pdf->initialPage = ($_page != '' ? $_page : 1);
    //$_pdf->SetAutoPageBreak(true);
    $_pdf->title = "";
    $_pdf->SetTopMargin(50);
    $_pdf->AliasNbPages();
    $_pdf->AddPage();
}


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
    $_pdf->title = "Subida de registros a tabla";
    //$_pdf->drawText("Subida de registros a tabla",'Arial','',14);
    
}


// aca iba session get, uofr y load/saveobject
  

while( has($_x, 'form1_init') ) { 
    $_result['form1'] = $form1->toarray(false);
    break;
}
while( has($_x, 'form1') ) { 

  
    //if( $errors == "" )
    //  validateform1();
    if( $errors == "" ) {

    
        if( $errors == "" ) {
            $query = "select * from $tabla"; 
if( $where != "" ) 
    $query .= " where " . $where; 
$query .= " order by id desc limit 1000"; 
 
 
$cols = array(); 
$array = sqltoarray($Link, $query); 
foreach($array as $row) { 
    foreach($row as $name => $value) { 
        if( $value != "" and $value != "NULL" and $value != '0000-00-00') { 
            if( searchInArray($name, $cols) == -1 ) 
                $cols[] = $name; 
        } 
    } 
} 
 
$twhere = ($where == '' ? " 1 = 1 " : $where) . " order by id desc limit 30"; 
//if( $twhere != "" ) $twhere = "(" . $twhere . ") and "; 
//$twhere .= " order by RAND() LIMIT 100"; 
 
//message(arrayToString($cols)); 
if( $return != '' ) { 
    redirect("$return?t=$tabla&f=" . arrayToString($cols) . "&tit=Subir registros a tabla $tabla&ret=fin.php&mode=insert&where=" . urlencode($twhere));  // w=ancho1,ancho2,...& 
//sqltotablearray 
} else { 
    redirect("../import/importer.php?t=$tabla&f=" . arrayToString($cols) . "&tit=Subir registros a tabla $tabla&ret=fin.php&mode=insert&where=" . urlencode($twhere));  // w=ancho1,ancho2,...& 
//sqltotablearray 
} 

// Si puso header location para ir a otra pagina cierra el script
if( !isset($_x) and $__exiting ) { 
   disconnectDb($Link); exit(0);
} 

        }
      
    
        if( $_redirect != "" ) redirect($_redirect);
        sessionset('form_dbimport_form1' . $_id, $form1);
        
        if( $_result['redirect'] == '' )
            redirect("?id=$id");
    }
    break;
}
while( has($_x, 'form1__delete') ) { 
  
  
    //if( $errors == "" )
    //  validateform1();
    if( $errors == "" ) {

      
        if( $_redirect != "" ) redirect($_redirect);
        sessionset('form_dbimport_form1' . $_id, null);
        if( $_result['redirect'] == '' ) {
            $_result['redirect'] = "?message=Subida de registros a tabla eliminada";
        }
    }
    break;
}
while( has($_x, 'form1_unload') ) {  // Not used

    break;
}


if( has($_x, 'section1') ) {
    
}


//$form1  -> ['changes']
if( isormObject($form1) ) $form1->makeglobals();


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) { 
    $_pdf->Output();
}

?><? 


if( !isset($_x) ) { 
?>


<? if( isset($_export) ) { ?>
<?
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=.xls");
//echo('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">');
//echo('<html xmlns="http://www.w3.org/1999/xhtml">');
echo('<meta http-equiv="Content-type" content="text/html;charset=utf-8" />');
?><? } else { ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html lang="en" >
    <head>    <? require('../include/base.head.php');   ?>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">	<meta http-equiv="X-UA-Compatible" content="IE=edge">	<meta name="viewport" content="width=device-width, initial-scale=1">	<link rel="shortcut icon" href="favicon.ico" />

    
    <link href="../import/style.1527286207.css" rel="stylesheet" type="text/css">    

    
    <!-- isbasewindow  -->
    
        
    <script type="text/javascript" src="../include/util.1744242079.js"></script>        
        
    
    </head>    <body         data-version="22"
        class=" <? if( isset($_popup) ) { ?> popup<? } ?>" 
        
        <? if( isset($_popup) ) { ?> class="popup" <? } ?>
        
        >        
        <form id='form' name='form' method='POST' >        
        <input id="_rowid" type="hidden" name="_rowid" value="">        <input id="_rowidname" type="hidden" name="_rowidname" value="">                
                
        <? require('../include/base.bodytop.php');   ?>

        <style>            
<? if( (has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2')) and (isset($_orientation) or isset($_size)) ) {  ?>
/* A4 Landscape*/@page {    size: A4 portrait;
}<? } ?>
            
        </style>
<? }  // Export
?>
        <div id='form1' class="panel panel-primary relative form 
         
        
        form-" 
    >    <input id="_id" type=hidden name="_id" value="">
    
    
	<div class="panel-heading 	">		<h5 class="panel-title" 		    
		    data-editable="title">Subida de registros a tabla
		    
		    </h5>		
	</div>	
			<div class="panel-subtitle">		<div class="heading-elements">    		    	     <div class="btn-group  navbar-btn pull-right" style="margin-left: 0">            
            
             </div>    	</div>	</div>	

	<div class="panel-body editmode-only withfieldsets 
	">	    <div class='row'><fieldset id='section1'     class="    
    
    "    style="    width: ;
    "    >
    <div>        <div class='row'>
<div     id="tabla"     class=" col30-sm-6
        
        input        
           
        "    data-name="tabla"     data-type="text"    >    
	<div class="form-group" >
	 <!--  <label data-editable="label">Tabla</label>  -->
	 
	 <label data-editable="label">Tabla</label>
     
	    	    
                		<input     		    id="field__tabla"
    		    type="text"
    		    
    		    data-type="text"    		    
    		    
    		    class="form-control     "
                name="field__tabla" 
                value=""
                
                
                data-width="6sm"    	            	        data-deps=""
    	                        
                
            >            
                                    
                        
	</div></div>

<div     id="where"     class=" col30-sm-14
        
        input        
           
        "    data-name="where"     data-type="text"    >    
	<div class="form-group" >
	 <!--  <label data-editable="label">Where</label>  -->
	 
	 <label data-editable="label">Where</label>
     
	    	    
                		<input     		    id="field__where"
    		    type="text"
    		    
    		    data-type="text"    		    
    		    
    		    class="form-control     "
                name="field__where" 
                value=""
                
                
                data-width="14sm"    	            	        data-deps=""
    	                        
                
            >            
                                    
                        
	</div></div>
</div>    </div></fieldset><!-- Antes el fieldset estaba encerrado en un <div >   --></div>	</div>	
	<div class="panel-footer editmode-only">    	<div class=" text-right">
    	    <button type="button" class="btn btn-primary stepy-finish btn-save  pull-right" 
        	    onclick="submitbs(this, 'form1', '');">
    	        Continuar
    	        <i class="icon-arrow-right14  position-right "></i>
    	    </button>    	        	</div>	</div>	
</div><div id='resultado' class="    table    "
    data-name="resultado"     data-type="table"     >
        <!-- cansearch:  -->
    
    
            <table id="resultado_table"         class="table  
        
        
     "
        style="; width:100%;
        "                data-features=""
    
    
        >    
        <thead>                
        </thead>        
        <tbody>        
             
            
	</tbody>	
	    
</table>    
    
    
</div>
<? if( !isset($_export) ) { ?>

        <? require('../include/base.bodybottom.php'); ?>
        
        
        </form>        
                
            
        <!-- begin mainfile include JSs -->        
        <!-- end mainfile include JSs -->    
    </body>
        
<? } ?>

<? if( !isset($_export) ) { ?>
</html><? } ?>


<script type="text/javascript">
// To render template init.js
// window.init.js 

tabla = new Field('field__tabla', 'field__tabla', 'text', {
    
    
});
where = new Field('field__where', 'field__where', 'text', {
    
    
});


$(function() {
    

    <? if( (isset($messages) and $messages != "") or (isset($message) and $message != "") ) { ?>
    message('