25);
$_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";
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['__empleados__1'] = $estado ;
$__row0['__empleados__2'] = $empleados_total ;
$_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, 'empleados') ) {
$_result['empleados_table'] = array();
foreach(sqltoarray($Link, "select
id as idemp,
nombre,
apellido
from
cmcont
where
tipo = 'Usuario'
and perfil != 'Inmobiliaria'
and id not in (select usuario from emresp where form = '" . mysql_escape($form) . "' and estado = '" . mysql_escape($estado) . "' and objeto = '" . mysql_escape($id) . "')
order by
apellido,
nombre
") as $__row0) {
makeglobals($__row0);
$_result['empleados_table'][] = $__row0;
}
}
if( has($_x, 'empleados_html') ) {
if( $from == "" ) $from = 0;
$_sql = "select
id as idemp,
nombre,
apellido
from
cmcont
where
tipo = 'Usuario'
and perfil != 'Inmobiliaria'
and id not in (select usuario from emresp where form = '" . mysql_escape($form) . "' and estado = '" . mysql_escape($estado) . "' and objeto = '" . mysql_escape($id) . "')
order by
apellido,
nombre
limit " . mysql_escape($start) . ", " . mysql_escape($length) . " ";
$_sqlcount = "select count(*) as _count,
id as idemp,
nombre,
apellido
from
cmcont
where
tipo = 'Usuario'
and perfil != 'Inmobiliaria'
and id not in (select usuario from emresp where form = '" . mysql_escape($form) . "' and estado = '" . mysql_escape($estado) . "' and objeto = '" . mysql_escape($id) . "')
order by
apellido,
nombre";
$_empleados_rows = sqltoarray($Link, $_sql);
$_empleados_total = sqlget($Link, $_sqlcount);
foreach($_empleados_rows as $_empleados_rownumber => $_empleados) {
makeglobals($_empleados);
?>
data-href=""
data-href="?id=&estado=&form=&resp=" data-target=""
>
$_empleados_val) {
if( $_empleados_name == 'class' or $_empleados_name == 'link' ) continue;
?>
|
|
$_empleados) {
$_row = array();
makeglobals($_empleados);
$_row = array_values($_empleados);
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'empleados_filterbak') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count,
id as idemp,
nombre,
apellido
from
cmcont
where
tipo = 'Usuario'
and perfil != 'Inmobiliaria'
and id not in (select usuario from emresp where form = '" . mysql_escape($form) . "' and estado = '" . mysql_escape($estado) . "' and objeto = '" . mysql_escape($id) . "')
order by
apellido,
nombre group by $_group";
$_sql = sqladdorderbyifnotpresent( $_sql, "1 asc");
$_empleados_rows = sqltoarray($Link, $_sql);
$_empleados_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_empleados_total;
$_result['recordsFiltered'] = $_empleados_total;
$_result['empleados_total'] = $_empleados_total;
foreach($_empleados_rows as $_empleados_rownumber => $_empleados) {
$_row = array();
makeglobals($_empleados);
$_row['_count'] = $_count;
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'empleados_filter') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count,
id as idemp,
nombre,
apellido
from
cmcont
where
tipo = 'Usuario'
and perfil != 'Inmobiliaria'
and id not in (select usuario from emresp where form = '" . mysql_escape($form) . "' and estado = '" . mysql_escape($estado) . "' and objeto = '" . mysql_escape($id) . "')
order by
apellido,
nombre group by $_group";
//$_sql = sqladdorderbyifnotpresent( $_sql, "1 desc");
//$_sql = sqladdorderby( $_sql, "_count desc");
$_sql .= " order by _count desc";
$_empleados_rows = sqltoarray($Link, $_sql, array($_group - 1 => 'id', 0 => 'badge'));
$_empleados_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_empleados_total;
$_result['recordsFiltered'] = $_empleados_total;
$_result['empleados_total'] = $_empleados_total;
$_result['data'] = $_empleados_rows;
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'empleados_select') ) {
refresh("empleados");
}
if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
$_pdf->Output();
}
?>
');
//echo('');
echo('');
?>
class="popup"
>