<?

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


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


debugstartpage();


//$_inmenuconfig/Emprendimientos = 'yes';


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


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


$_morecolumns = "";
if( !isset($_id) and $id != '' ) $_id = rand(1, 100000000);
$plano = sessionget('form_planoalta_plano' . $_id);
//logToFile('plano: ' . print_r($plano, true));
if( empty($_x) or in('onopen', $_x) ) {
    if( $id != "" and $id != "0" ) {
        $plano = loadObject($Link, "planos.plano", $id); 
    } else {
        $plano = newObject($Link, "planos.plano");
        //fillobjectfromrequest($plano);
    }
}
if( isormObject($plano) )
    updateObjectFromRequest($Link, $plano);
//makeglobals($plano, array('id', 'plano'));
if( isset($_x) )
    $_initialvars = arrayExclude(get_defined_vars(), array("_*", "form_*", "s_*", "GLOBALS", "Link", "thisname"));
//$_initialvars['plano'] = objectToStructure($plano);
if( isormObject($plano) )
    $_initialvars = array_merge($_initialvars, objectToStructure($plano));
if( isormObject($plano) ) $plano->makeglobals();
//logToFile('plano after uofr: ' . print_r($plano, true));


// isbasewindow: 


// PHP Vars 
while( ($__action == "" or $__action == "executedonopen") and isset($_GET['_x']) and empty($_x) ) {
    $__row0 = array();
    
	$__row0['__plano__1'] =  ($id == "" ) ? 'listmode' : 'editmode' ;
	$__row0['__plano__2'] =  $_id ;
	$__row0['__plano__3'] =  $id == '0' ? 'Nuevo ' : '' ;
	$__row0['__plano__4'] =  "Plano  $proyecto" ;
	$__row0['__plano__5'] =  $id > 0 ? ('#' . $id) : '' ;
	$__row0['__plano__6'] =  "Plano  $proyecto" ;
	$__row0['__plano__7'] =  buildUrlQueryFromGet(array('id' => '0', 'message' => '_delete_', 'errors' => '_delete_')) ;
	$__row0['__plano__8'] =  "Plano  $proyecto" ;
	$__row0['__plano__9'] =  buildUrlQueryFromGet(array('id' => '_delete_', 'message' => '_delete_', 'errors' => '_delete_')) ;
	$__row0['__plano__10'] =  buildUrlQueryFromGet(array('id' => '_delete_', 'message' => '_delete_', 'errors' => '_delete_')) ;

	$__row0['__emprendimiento__1'] =  $plano->emprendimiento ;

	$__row0['__nombre__1'] =   $plano->nombre  ;

	$__row0['__torre__1'] =   $plano->torre  ;

	$__row0['__piso__1'] =   $plano->piso  ;

	$__row0['__tipologia__1'] =   $plano->tipologia  ;

	$__row0['__vista__1'] =   $plano->vista  ;

	$__row0['__variante__1'] =   $plano->variante  ;

	$__row0['__dormitorios__1'] =   $plano->dormitorios  ;

	$__row0['__notas__1'] =  encodehtml($plano->notas) ;


	$__row0['__archivo__1'] =  "../files/$_filesfolder/planos/" ;
	$__row0['__archivo__2'] =  date('Y_m') ;
	$__row0['__archivo__3'] =  randomname() ;
	$__row0['__archivo__4'] =  str_replace(enters(), '|', $plano->archivo) ;


	$__row0['__datos__1'] =  encodehtml($plano->datos) ;

    $_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 = "Planos";
    $_pdf->SetTopMargin(50);
    $_pdf->AliasNbPages();
    $_pdf->AddPage();
}


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
    $_pdf->title = "Plano  $proyecto";
    //$_pdf->drawText("Plano  $proyecto",'Arial','',14);
    
}


    if( has($_x, 'plano_list') ) {
        if( $_reorder != '' ) {
            $_changes = split('/', $_reorder);
            foreach($_changes as $_change) {
                $_change0 = split('-', $_change);
                $_id = $_change0[0];
                $_position = $_change0[1];
                $_table = 'planos';
                sqlexec($Link, "update $_table set position = $_position where id = $_id");
            }
        }
        //logToFile('[plano_list] ' . print_r($_REQUEST, true) );
        
        
        $q = $search['value'];
        $_order = "order by " . ($order[0]['column'] + 1) . " " . $order[0]['dir'];
        if( $order[0]['column'] == ''  ) $_order =  $orderby ;
        if( $start == '' ) $start = 0;
        if( $length == '' ) $length = 50; else if( $length == '-1' ) $length = 10000;
        
        $_additionalfilter = substr(getaccess(getSelfWindow(), 'buscar'), 14);
        if( trim($_additionalfilter) == '' ) $_additionalfilter = '1 = 1';
        if( hasfeature('planos.plano', 'procesos') )
            $_morecolumns = ", status";
        if( isset($my) and $my == 'mine' ) {
            if( isset($status) )
                $_order = " and (select count(*) from emresp where form = 'planos.plano' and objeto = planos.id and usuario = '$s_idusuario' and estado = '$status') > 0 " . $_order;
            else
                $_order = " and (select count(*) from emresp where form = 'planos.plano' and objeto = planos.id and usuario = '$s_idusuario') > 0 " . $_order;
        }
            
        if( isset($status) ) 
            $_result['data'] = sqltotablearray($Link, "select SQL_CALC_FOUND_ROWS planos.id, planos.emprendimiento, planos.nombre, planos.tipo $_morecolumns  from planos where ($_additionalfilter) and (planos.status = '" . mysql_escape($status) . "')   and (planos.emprendimiento like '%" . mysql_escape($emprendimiento_filter) . "%') $_order limit $start, $length");
        else
            $_result['data'] = sqltotablearray($Link, "select SQL_CALC_FOUND_ROWS planos.id, planos.emprendimiento, planos.nombre, planos.tipo $_morecolumns  from planos where ($_additionalfilter)  and (planos.emprendimiento like '%" . mysql_escape($emprendimiento_filter) . "%') $_order limit $start, $length");
        $_result['draw'] = 0;
        $_result['recordsTotal'] = sqlget($Link, "select found_rows()");
        $_result['recordsFiltered'] = $_result['recordsTotal']; //sizeof($_result['data']);
        //$_result['recordsFiltered'] = 50;
        print(json_encode($_result));
        disconnectDb($Link);
        exit(0);
    }
    
    
// aca iba session get, uofr y load/saveobject
  

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

  
    //if( $errors == "" )
    //  validateplano();
    if( $errors == "" ) {
    
        //logToFile("BEFORE SAVE: " . objectToHtml($plano));
        saveObject($Link, $plano);
        if( hasfeature('planos.plano', 'procesos') ) {
            require_once('../include/easyflexa.php');
            if( $id == 0 ) setresponsables($plano); 
            controlstatus($plano);
        }
        $id = $plano->id;
        //logToFile(objectToText($plano));

    
        if( $errors == "" ) {
            closepopup(1);  

// 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_planoalta_plano' . $_id, $plano);
        
        if( $_result['redirect'] == '' )
            redirect("?id=$id");
    }
    break;
}
while( has($_x, 'plano__delete') ) { 
  
  
    //if( $errors == "" )
    //  validateplano();
    if( $errors == "" ) {
    
        //logToFile("BEFORE SAVE: " . objectToHtml($plano));
        deleteObject($Link, $plano);
        //logToFile(objectToText($plano));

      
        if( $_redirect != "" ) redirect($_redirect);
        sessionset('form_planoalta_plano' . $_id, null);
        if( $_result['redirect'] == '' ) {
            $_result['redirect'] = "?message=Plano  $proyecto eliminado";
        }
    }
    break;
}
while( has($_x, 'plano_unload') ) {  // Not used
    
    sessionclear('form_planoalta_plano' . $_id);  

    break;
}


if( ($id == '' or $id == '0') and !isset($_x) and !isset($_GET['emprendimiento']) ) {
    $plano->emprendimiento = $proyecto;
}


if( has($_x, 'tipo_select') ) {
    
    
    /**
     * Vista,Planta,Tipologia,Render
Vista,Planta,Tipologia,Render

     */
    $_result['tipo_select'] = [["Vista","Vista"],["Planta","Planta"],["Tipologia","Tipologia"],["Render","Render"]];
    
}


if( has($_x, 'destino_select') ) {
    
    
    /**
     * Comercial,Legal,Arquitectura 
Comercial,Legal,Arquitectura

     */
    $_result['destino_select'] = [["Comercial","Comercial"],["Legal","Legal"],["Arquitectura","Arquitectura"]];
    
}


if( has($_x, 'tamano_select') ) {
    
    
    /**
     * Ajustar al ancho,Ajustar al alto,No ajustar
Ajustar al ancho,Ajustar al alto,No ajustar

     */
    $_result['tamano_select'] = [["Ajustar al ancho","Ajustar al ancho"],["Ajustar al alto","Ajustar al alto"],["No ajustar","No ajustar"]];
    
}


if( $id == '' and 1 == 0 and !isset($_x) ) {
    $plano->tamano = "Ajustar al ancho";
}


if( has($_x, 'dibujar_select') ) {
    
    
    /**
     * rectangulos,poligonos,externo
rectangulos,poligonos,externo

     */
    $_result['dibujar_select'] = [["rectangulos","rectangulos"],["poligonos","poligonos"],["externo","externo"]];
    
}


while( has($_x,'botoneliminar') ) { 
    /** CODIGO ORIGINAL ONCLICK
    $onclick
    **/
    
    
sqlexec($Link, "delete from planos where id = '" . mysql_escape($id) . "'");
closepopup(1);  

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

    
    break;
}


if( has($_x, 'preferencias') ) {
    
}
if( $preferencias__row != '' ) {
    $plano->preferencias->_selected = $preferencias__row;
}


sessionset('form_planoalta_plano' . $_id, $plano);


//$plano  -> ['changes']
if( isormObject($plano) ) $plano->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=planos.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" />	<title>Planos</title>

    
    <link href="../planos/style.css" rel="stylesheet" type="text/css">    <link href="../include/bootstrap.carousel.1535315667.css" rel="stylesheet" type="text/css">

    
    <!-- isbasewindow  -->
    
        
    <script type="text/javascript" src="../include/util.1744242079.js"></script>        
        
    
    </head>    <body         data-version="75"
        data-name="planos"        data-menu="config/Emprendimientos"        data-target="php"
        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='plano' class="panel panel-primary relative form 
         
         
        listmode        
        form-" 
    >    <input id="_id" type=hidden name="_id" value="">
    
    
	<div class="panel-heading 	">		<h5 class="panel-title" 		    
		    <? if( $id == '' ) { ?> data-toplural="yes" <? } ?>
		    
		    data-editable="title">Plano  		    
		    		    
		    </h5>		
    		<div class="heading-elements">		    
		    		
<button id='botoneliminar' 
    style="        width: ;
    "    type="button"    data-confirm="Está seguro de eliminar este plano? Se eliminaran todos los cuadrados dibujados en él."    
    class="btn btn-default
        
         
         ladda-button
        
        
    "    data-style="expand-left"    data-popup="tooltip" title="Eliminar plano"     
        onclick="            var me = this;            
            bootboxconfirm('Está seguro de eliminar este plano? Se eliminaran todos los cuadrados dibujados en él.', 'Confirmar', function() {            
            
            
                submitbs(me, 'botoneliminar', '' , false ); 
            
                event.stopPropagation();            
            });            "
        
>
    
    <i class="icon-trash"></i>
    
    
        <span  ></span>
    
    
</button>
             
                <? if( $id != '0' ) { ?>
                    <button id="buttonnew" type="button" class="btn btn-default ladda-button" data-popup="tooltip" title="Nuevo Plano  " data-placement="bottom" data-style="expand-left" data-href="?