90);
$_result['visibility'] = array();
$_initialvars = arrayExclude(get_defined_vars(), array("_*", "form_*", "s_*", "GLOBALS", "Link", "thisname"));
}
require('../include/base.events.php');
// isbasewindow:
// On Open
while( ($__action == "" or $__action == "executedonopen") and (empty($_x) or in('onopen', $_x)) ) {
$__action = "executedonopen";
$delegarmasivo->responsable = $s_idusuario;
$tabla = array();
$tabla = explode(".", $form);
$modulo = $tabla[0];
$formulario = $tabla[1];
debug("Modulo: " . $modulo);
debug("Formulario: " . $formulario);
$__tempresult = sqlexec($Link, "select dbtable from ddform where module= '" . mysql_escape($modulo) . "' and name = '" . mysql_escape($formulario) . "'");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$tablaform = $__temprow[0];
}
$columnas = array();
$__tempresult = sqlexec($Link, "select group_concat( upper(dbcol) SEPARATOR \",\") from ddfield where list like 'onlist%' and form = '" . mysql_escape($formulario) . "' order by type limit 5");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$columnasunificadas = $__temprow[0];
}
$columnas = explode(",", $columnasunificadas);
$columna0 = $columnas[0];
$columna1 = $columnas[1];
$columna2 = $columnas[2];
$columna3 = $columnas[3];
$columna4 = $columnas[4];
debug("columna0:" . $columna0);
debug("columna1:" . $columna1);
debug("columna2:" . $columna2);
debug("columna3:" . $columna3);
debug("columna4:" . $columna4);
/*
if( $resp != '' ) {
debug("entro a delegar");
$__tempresult = sqlexec($Link, "select nombre from cmcont where id = '" . mysql_escape($resp) . "'");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$nombreresp = $__temprow[0];
}
debug("nombre responsable",$nombreresp);
$__tempresult = sqlexec($Link, "select title from ddform where concat(module, '.', name) = '" . mysql_escape($form) . "'");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$tituloform = $__temprow[0];
}
sqlexec($Link, "update emresp set usuario = '" . mysql_escape($resp) . "' where objeto = '" . mysql_escape($id) . "' and estado = '" . mysql_escape($estado) . "' and form = '" . mysql_escape($form) . "'");
$obj = object($form, $id);
debug("id objeto",$id,"estado", $estado, "form", $form);
$ip = $_SERVER['REMOTE_ADDR'] ;
$mensaje = "Delegó " . $obj . " $estado a $nombreresp";
sqlexec($Link, "insert into cmactiv(tipo, usuario, component, idobjeto, texto, notas, responsable) values('D', '" . mysql_escape($s_idusuario) . "', '" . mysql_escape($form) . "', '" . mysql_escape($id) . "', '" . mysql_escape($mensaje) . "', '" . mysql_escape($ip) . "','" . mysql_escape($resp) . "')");
$nuevo_id_cmactiv = mysql_insert_id($Link);
debug("id cmactiv recien insertado",$nuevo_id_cmactiv);
$__tempresult = sqlexec($Link, "select nombre from cmcont where id = '" . mysql_escape($s_idusuario) . "'");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$nombreusuariocreoalerta = $__temprow[0];
}
sqlexec($Link, "insert into alertas(usuario, tipo, titulo, detalles, link, idobj) select '" . mysql_escape($resp) . "','Delegación','Delegado " . mysql_escape($tituloform) . "','" . mysql_escape($mensaje) . "','../compras/comprobante.php?id=" . mysql_escape($id) . "&_popup', '" . mysql_escape($id) . "' from cmcont where (id = (select responsable from cmactiv where id = '" . mysql_escape($nuevo_id_cmactiv) . "') or id in (select relacionado from cmrel where contacto = (select proyecto from cmactiv where id = '" . mysql_escape($nuevo_id_cmactiv) . "'))) and tipo = 'Usuario' and id != '" . mysql_escape($s_idusuario) . "'");
closepopup(1);
}
*/
// Si puso header location para ir a otra pagina cierra el script
if( !isset($_x) and $__exiting ) {
disconnectDb($Link); exit(0);
}
break;
}
// PHP Vars
while( ($__action == "" or $__action == "executedonopen") and isset($_GET['_x']) and empty($_x) ) {
$__row0 = array();
$__row0['__cambiarenlote__1'] = $_id ;
$__row0['__cambiarenlote__2'] = $id == '0' ? 'Nuevo ' : '' ;
$__row0['__unnamed4__1'] = $unnamed4 ;
$_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 = "Cambiar estado en lote";
//$_pdf->drawText("Cambiar estado en lote",'Arial','',14);
}
// aca iba session get, uofr y load/saveobject
while( has($_x, 'cambiarenlote_init') ) {
$_result['cambiarenlote'] = $cambiarenlote->toarray(false);
break;
}
while( has($_x, 'cambiarenlote') ) {
//if( $errors == "" )
// validatecambiarenlote();
if( $errors == "" ) {
if( $_redirect != "" ) redirect($_redirect);
sessionset('form_cambiaestadomasivo_cambiarenlote' . $_id, $cambiarenlote);
if( $_result['redirect'] == '' )
redirect("?id=$id");
}
break;
}
while( has($_x, 'cambiarenlote__delete') ) {
//if( $errors == "" )
// validatecambiarenlote();
if( $errors == "" ) {
if( $_redirect != "" ) redirect($_redirect);
sessionset('form_cambiaestadomasivo_cambiarenlote' . $_id, null);
if( $_result['redirect'] == '' ) {
$_result['redirect'] = "?message=Cambiar estado en lote eliminado";
}
}
break;
}
while( has($_x, 'cambiarenlote_unload') ) { // Not used
break;
}
if( has($_x, 'unnamed2') ) {
}
if( has($_x, 'estado_select') ) {
list($_result['estado_select'], $_result['estado_columns'], $_result['estado_types']) = sqltoarraydd($Link, "select descripcion, descripcion from estados where form = '" . mysql_escape($form) . "' order by orden, id ");
}
while( has($_x,'unnamed1') ) {
/** CODIGO ORIGINAL ONCLICK
$onclick
**/
$tabla = array();
$tabla = explode(".", $form);
$modulo = $tabla[0];
$formulario = $tabla[1];
debug("Modulo: " . $modulo);
debug("Formulario: " . $formulario);
$__tempresult = sqlexec($Link, "select dbtable from ddform where module= '" . mysql_escape($modulo) . "' and name = '" . mysql_escape($formulario) . "'");
while( $__temprow = mysql_fetch_array($__tempresult)) {
$tablaform = $__temprow[0];
}
sqlexec($Link, "update $tablaform set status = '$estado' where id in ($selected)");
$ip = $_SERVER['REMOTE_ADDR'] ;
sqlexec($Link, "insert into cmactiv(tipo, usuario, component, idobjeto, texto, notas) select 'W', '" . mysql_escape($s_idusuario) . "', '" . mysql_escape($form) . "', id, 'Cambió estado a " . mysql_escape($estado) . "', '" . mysql_escape($ip) . "' from " . mysql_escape($tablaform) . " where id in (" . mysql_escape_array_numeric($selected) . ")");
messages('Se ha cambiado el estado a los registros seleccionados');
//$message = "Se ha cambiado la responsabilidad a $cantidaregistros registros";
//edirect("?form=$form&estado=$estado&delegara=$delegara");
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, 'unnamed3') ) {
}
if( has($_x, 'registros') ) {
$_result['registros_table'] = array();
foreach(sqltoarray($Link, "select
id,
status
from
" . mysql_escape($tablaform) . "
where
id in (" . mysql_escape_array_numeric($selected) . ")
") as $__row0) {
makeglobals($__row0);
$_result['registros_table'][] = $__row0;
}
}
if( has($_x, 'registros_html') ) {
if( $from == "" ) $from = 0;
$_sql = "select
id,
status
from
" . mysql_escape($tablaform) . "
where
id in (" . mysql_escape_array_numeric($selected) . ")
limit " . mysql_escape($start) . ", " . mysql_escape($length) . " ";
$_sqlcount = "select count(*) as _count,
id,
status
from
" . mysql_escape($tablaform) . "
where
id in (" . mysql_escape_array_numeric($selected) . ")";
$_registros_rows = sqltoarray($Link, $_sql);
$_registros_total = sqlget($Link, $_sqlcount);
foreach($_registros_rows as $_registros_rownumber => $_registros) {
makeglobals($_registros);
?>
data-href=""
>
$_registros_val) {
if( $_registros_name == 'class' or $_registros_name == 'link' ) continue;
?>
|
|
$_registros) {
$_row = array();
makeglobals($_registros);
$_row = array_values($_registros);
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'registros_filterbak') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count,
id,
status
from
" . mysql_escape($tablaform) . "
where
id in (" . mysql_escape_array_numeric($selected) . ") group by $_group";
$_sql = sqladdorderbyifnotpresent( $_sql, "1 asc");
$_registros_rows = sqltoarray($Link, $_sql);
$_registros_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_registros_total;
$_result['recordsFiltered'] = $_registros_total;
$_result['registros_total'] = $_registros_total;
foreach($_registros_rows as $_registros_rownumber => $_registros) {
$_row = array();
makeglobals($_registros);
$_row['_count'] = $_count;
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'registros_filter') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count,
id,
status
from
" . mysql_escape($tablaform) . "
where
id in (" . mysql_escape_array_numeric($selected) . ") group by $_group";
//$_sql = sqladdorderbyifnotpresent( $_sql, "1 desc");
//$_sql = sqladdorderby( $_sql, "_count desc");
$_sql .= " order by _count desc";
$_registros_rows = sqltoarray($Link, $_sql, array($_group - 1 => 'id', 0 => 'badge'));
$_registros_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_registros_total;
$_result['recordsFiltered'] = $_registros_total;
$_result['registros_total'] = $_registros_total;
$_result['data'] = $_registros_rows;
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'registros_select') ) {
refresh("registros");
}
//$cambiarenlote -> ['changes']
if( isormObject($cambiarenlote) ) $cambiarenlote->makeglobals();
if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
$_pdf->Output();
}
?>
');
//echo('');
echo('');
?>
class="popup"
>