NaN);
$_result['visibility'] = array();
$_initialvars = arrayExclude(get_defined_vars(), array("_*", "form_*", "s_*", "GLOBALS", "Link", "thisname"));
}
require('../main/base.events.php');
// isbasewindow:
// PHP Vars
while( ($__action == "" or $__action == "executedonopen") and isset($_GET['_x']) and empty($_x) ) {
$__row0 = array();
$_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, 'casatuaventas') ) {
$_result['casatuaventas_table'] = array();
foreach(sqltoarray($Link, "select *
from jglcasatua.casatua_ventas as v
where
v.empresa = '" . mysql_escape($empresa) . "'
and v.asiento is null
") as $__row0) {
makeglobals($__row0);
$_result['casatuaventas_table'][] = $__row0;
}
}
if( has($_x, 'casatuaventas_html') ) {
if( $from == "" ) $from = 0;
$_sql = "select *
from jglcasatua.casatua_ventas as v
where
v.empresa = '" . mysql_escape($empresa) . "'
and v.asiento is null
limit " . mysql_escape($start) . ", " . mysql_escape($length) . " ";
$_sqlcount = "select count(*) as _count, *
from jglcasatua.casatua_ventas as v
where
v.empresa = '" . mysql_escape($empresa) . "'
and v.asiento is null";
$_casatuaventas_rows = sqltoarray($Link, $_sql);
$_casatuaventas_total = sqlget($Link, $_sqlcount);
foreach($_casatuaventas_rows as $_casatuaventas_rownumber => $_casatuaventas) {
makeglobals($_casatuaventas);
?>
data-href=""
>
$_casatuaventas_val) {
if( $_casatuaventas_name == 'class' or $_casatuaventas_name == 'link' ) continue;
?>
|
|
$_casatuaventas) {
$_row = array();
makeglobals($_casatuaventas);
$_row = array_values($_casatuaventas);
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuaventas_filterbak') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count, *
from jglcasatua.casatua_ventas as v
where
v.empresa = '" . mysql_escape($empresa) . "'
and v.asiento is null group by $_group";
$_sql = sqladdorderbyifnotpresent( $_sql, "1 asc");
$_casatuaventas_rows = sqltoarray($Link, $_sql);
$_casatuaventas_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_casatuaventas_total;
$_result['recordsFiltered'] = $_casatuaventas_total;
$_result['casatuaventas_total'] = $_casatuaventas_total;
foreach($_casatuaventas_rows as $_casatuaventas_rownumber => $_casatuaventas) {
$_row = array();
makeglobals($_casatuaventas);
$_row['_count'] = $_count;
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuaventas_filter') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count, *
from jglcasatua.casatua_ventas as v
where
v.empresa = '" . mysql_escape($empresa) . "'
and v.asiento is null group by $_group";
//$_sql = sqladdorderbyifnotpresent( $_sql, "1 desc");
//$_sql = sqladdorderby( $_sql, "_count desc");
$_sql .= " order by _count desc";
$_casatuaventas_rows = sqltoarray($Link, $_sql, array($_group - 1 => 'id', 0 => 'badge'));
$_casatuaventas_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_casatuaventas_total;
$_result['recordsFiltered'] = $_casatuaventas_total;
$_result['casatuaventas_total'] = $_casatuaventas_total;
$_result['data'] = $_casatuaventas_rows;
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuaventas_select') ) {
refresh("casatuaventas");
}
if( has($_x, 'casatuadiario') ) {
$_result['casatuadiario_table'] = array();
foreach(sqltoarray($Link, "select *
from jglcasatua.casatua_diario3 as d
where
d.empresa = '" . mysql_escape($empresa) . "'
and d.opergest like 'VT %'
and asiento not in (select asiento from jglcasatua.casatua_ventas where empresa = '" . mysql_escape($empresa) . "' and asiento is not null)
") as $__row0) {
makeglobals($__row0);
$_result['casatuadiario_table'][] = $__row0;
}
}
if( has($_x, 'casatuadiario_html') ) {
if( $from == "" ) $from = 0;
$_sql = "select *
from jglcasatua.casatua_diario3 as d
where
d.empresa = '" . mysql_escape($empresa) . "'
and d.opergest like 'VT %'
and asiento not in (select asiento from jglcasatua.casatua_ventas where empresa = '" . mysql_escape($empresa) . "' and asiento is not null)
limit " . mysql_escape($start) . ", " . mysql_escape($length) . " ";
$_sqlcount = "select count(*) as _count, *
from jglcasatua.casatua_diario3 as d
where
d.empresa = '" . mysql_escape($empresa) . "'
and d.opergest like 'VT %'
and asiento not in (select asiento from jglcasatua.casatua_ventas where empresa = '" . mysql_escape($empresa) . "' and asiento is not null)";
$_casatuadiario_rows = sqltoarray($Link, $_sql);
$_casatuadiario_total = sqlget($Link, $_sqlcount);
foreach($_casatuadiario_rows as $_casatuadiario_rownumber => $_casatuadiario) {
makeglobals($_casatuadiario);
?>
data-href=""
>
$_casatuadiario_val) {
if( $_casatuadiario_name == 'class' or $_casatuadiario_name == 'link' ) continue;
?>
|
|
$_casatuadiario) {
$_row = array();
makeglobals($_casatuadiario);
$_row = array_values($_casatuadiario);
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuadiario_filterbak') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count, *
from jglcasatua.casatua_diario3 as d
where
d.empresa = '" . mysql_escape($empresa) . "'
and d.opergest like 'VT %'
and asiento not in (select asiento from jglcasatua.casatua_ventas where empresa = '" . mysql_escape($empresa) . "' and asiento is not null) group by $_group";
$_sql = sqladdorderbyifnotpresent( $_sql, "1 asc");
$_casatuadiario_rows = sqltoarray($Link, $_sql);
$_casatuadiario_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_casatuadiario_total;
$_result['recordsFiltered'] = $_casatuadiario_total;
$_result['casatuadiario_total'] = $_casatuadiario_total;
foreach($_casatuadiario_rows as $_casatuadiario_rownumber => $_casatuadiario) {
$_row = array();
makeglobals($_casatuadiario);
$_row['_count'] = $_count;
$_result['data'][] = $_row;
}
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuadiario_filter') ) {
$_sql = "select SQL_CALC_FOUND_ROWS count(*) as _count, *
from jglcasatua.casatua_diario3 as d
where
d.empresa = '" . mysql_escape($empresa) . "'
and d.opergest like 'VT %'
and asiento not in (select asiento from jglcasatua.casatua_ventas where empresa = '" . mysql_escape($empresa) . "' and asiento is not null) group by $_group";
//$_sql = sqladdorderbyifnotpresent( $_sql, "1 desc");
//$_sql = sqladdorderby( $_sql, "_count desc");
$_sql .= " order by _count desc";
$_casatuadiario_rows = sqltoarray($Link, $_sql, array($_group - 1 => 'id', 0 => 'badge'));
$_casatuadiario_total = sqlget($Link, "SELECT FOUND_ROWS()");
$_result['data'] = array();
$_result['draw'] = 0;
$_result['recordsTotal'] = $_casatuadiario_total;
$_result['recordsFiltered'] = $_casatuadiario_total;
$_result['casatuadiario_total'] = $_casatuadiario_total;
$_result['data'] = $_casatuadiario_rows;
print(json_encode($_result));
disconnectDb($Link);
exit(0);
}
if( has($_x, 'casatuadiario_select') ) {
refresh("casatuadiario");
}
if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
$_pdf->Output();
}
?>
');
//echo('');
echo('');
?>
class="popup"
>