function update_row($rowId)
{
$exp = new ExpertoVentas();
$ids = explode("|", $rowId);
$elements = count($ids);
if ($elements > 1) {
$idCliente = $ids[0];
$idReparto = $ids[1];
$exp->updateSaldoDeudor($_POST[$rowId . "_c10"], $idCliente, $idReparto);
} else {
$exp->updateNumeroFactura($_POST[$rowId . "_c2"], $rowId);
}
return "update";
}
$result = mysql_query($sql);
if (mysql_num_rows($result)) {
if ($row = mysql_fetch_array($result)) {
echo returnVectorJSON($row);
} else {
$row = array("monto_deudor" => 0);
echo returnVectorJSON($row);
}
} else {
$row = array("monto_deudor" => 0);
echo returnVectorJSON($row);
}
exit;
}
if ($oData["behavior"] == "load") {
$expVta = new ExpertoVentas();
$id_reparto = $oData["id_reparto"];
$id_cliente = $oData["id_cliente"];
$rdo = $expVta->getSaldoDeudor($id_reparto, $id_cliente);
$saldo = $rdo;
$expReparto = new ExpertoRepartos();
$reparto = $expReparto->getDataReparto($id_reparto);
$expCte = new ExpertoClientes();
$cliente = $expCte->getById($id_cliente);
}
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="<?php
echo $style_form;
<?php
include_once 'ExpertoRepartos.php';
include_once '../ventas/ExpertoVentas.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
$filtros = $oData["filtros"];
$data = "";
if ($oData["id_reparto"]) {
$id_reparto = $oData["id_reparto"];
$expReparto = new ExpertoRepartos();
$reparto = $expReparto->getDataReparto($id_reparto);
$expVta = new ExpertoVentas();
$data = $expVta->getListFichaReparto($id_reparto);
}
?>
<html>
<head>
<script language="javascript" src="<?php
echo $lib_js;
?>
mainFormba.js"></script>
<link rel="stylesheet" type="text/css" href="<?php
echo $style_form;
?>
styleForm.css">
<script language="javascript" src="<?php
echo $jquery;
?>
jquery.js"></script>
function update_row($rowId)
{
$exp = new ExpertoVentas();
$exp->updateNumeroFactura($_POST[$rowId . "_c3"], $rowId);
return "update";
}
<?php
include_once 'ExpertoVentas.php';
include_once '../emails/ExpertoEmails.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
$expVta = new ExpertoVentas();
$expEmail = new ExpertoEmails();
$tipo_ventas = $expVta->getTipoDeVentas();
$anios = $expVta->getAniosVenta();
$emails = $expEmail->getCuentasEmails();
$emails_to = $expEmail->getCuentasEmailsTo();
//var_dump($emails_to);
//exit;
$filtros = $oData["filtros"];
?>
<html>
<head>
<!-- FORMS -->
<script type="text/javascript" src="<?php
echo $lib_js;
?>
mainFormba.js"></script>
<link rel="stylesheet" type="text/css" href="<?php
echo $style_form;
?>
styleForm.css">
<!-- BÁSICO DHTMLX -->
<link rel="stylesheet" type="text/css" href="<?php
echo $dhtmlx;
?>
<?php
include_once '../../_framework.php';
require 'ExpertoVentas.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
$desde = "2012-09-01";
$hasta = "2012-09-30";
$exp = new ExpertoVentas();
$data = $exp->getVeltasOldSystem($desde, $hasta);
?>
<html>
<head>
<!-- FORMS -->
<script language="javascript" src="<?php
echo $lib_js;
?>
mainFormba.js"></script>
<link rel="stylesheet" type="text/css" href="<?php
echo $style_form;
?>
styleForm.css">
<!-- BÁSICO DHTMLX -->
<link rel="stylesheet" type="text/css" href="<?php
echo $dhtmlx;
?>
dhtmlxGrid/codebase/dhtmlxgrid.css">
<link rel="stylesheet" type="text/css" href="<?php
echo $dhtmlx;
?>
exit;
}
if ($oData['factb'] == 'true') {
$expVta = new ExpertoVentas();
$text = $expVta->getTextForPrintVentasDeReparto_B($id);
$expPrint->imprimir(reemplazarCaracteresEspecialesPorAscii($text));
exit;
}
if ($oData['facta'] == 'true') {
$expVta = new ExpertoVentas();
$text = $expVta->getTextForPrintVentasDeReparto_A($id);
$expPrint->imprimir(reemplazarCaracteresEspecialesPorAscii($text));
exit;
}
if ($oData['ficha'] == 'true') {
$expVta = new ExpertoVentas();
$text = $expVta->getTextForPrintFichaDeReparto($id);
$expPrint->imprimir(reemplazarCaracteresEspecialesPorAscii($text));
exit;
}
break;
}
?>
<html>
<head>
<!-- FORMS -->
<script type="text/javascript" src="<?php
echo $lib_js;
?>
mainFormba.js"></script>
<link rel="stylesheet" type="text/css" href="<?php
for ($i = 0; $i < count($filters); $i++) {
$fieldAnValue = explode("=", $filters[$i]);
$value[$i] = $fieldAnValue[1];
}
$filterBy .= "mygrid.getFilterElement(1).value = '" . $value[1] . "';";
$filterBy .= "mygrid.getFilterElement(2).value = '" . $value[2] . "';";
$filterBy .= "mygrid.getFilterElement(3).value = '" . $value[3] . "';";
$filterBy .= "mygrid.getFilterElement(4).value = '" . $value[4] . "';";
$filterBy .= "mygrid.getFilterElement(5).value = '" . $value[5] . "';";
$filterBy .= "mygrid.getFilterElement(11).value = '" . $value[11] . "';";
$filterBy .= "mygrid.getFilterElement(12).value = '" . $value[12] . "';";
$filterBy .= "mygrid.filterByAll();";
}
if ($oData["id_reparto"]) {
$id_reparto = $oData["id_reparto"];
$exp = new ExpertoVentas();
$data = $exp->getAllVentasByReparto($id_reparto);
$expReparto = new ExpertoRepartos();
$reparto = $expReparto->getDataReparto($id_reparto);
}
?>
<html>
<head>
<!-- FORMS -->
<script language="javascript" src="<?php
echo $lib_js;
?>
mainFormba.js"></script>
<link rel="stylesheet" type="text/css" href="<?php
echo $style_form;
}
exit;
break;
case 'toExcel':
$exp->toExcel($oData["filtros"]);
exit;
break;
case 'enviarVentas':
$rdo = $exp->enviarVentas($oData);
if (!$rdo) {
pushError("El mail no ha podido ser enviado...");
} else {
pushInfo("Mail enviado!!!");
}
echo $msge;
exit;
break;
}
$exp = new ExpertoVentas();
if ($oData["source"] == "ventasListAll") {
$desde = $oData["fecha_inicio"];
$hasta = $oData["fecha_fin"];
$data = $exp->getAllVentas($desde, $hasta);
} else {
if ($oData["id_reparto"]) {
$id_reparto = $oData["id_reparto"];
$data = $exp->getAllVentasByReparto($id_reparto);
}
}
echo "<script> var data = \"{$data}\";\n\t\tparent.mygrid.clearAll();\n\t\tparent.mygrid.parse(data, 'xml');\n\t\tparent.mygrid.filterByAll();\n\t\t{$msge}\n</script>";
exit;
$rs_saldo_deudor = $exp->getDataSaldoDeudor($cabecera["id_reparto"], $cabecera["id_cliente"]);
$row_saldo_deudor = getRow($rs_saldo_deudor);
$detalle = $exp->getDetalleVenta($oData["id_venta"]);
$OR_REPARTO = "OR id_reparto = " . $cabecera["id_reparto"];
if ($cabecera["id_reparto"] != 1) {
$expRepartos = new ExpertoRepartos();
$dataRepartos = $expRepartos->getById($cabecera["id_reparto"]);
if ($dataRepartos["id_reparto_estado"] == 2) {
$disabled = "disabled";
}
}
break;
case 'save':
break;
case 'new':
$exp = new ExpertoVentas();
switch ($oData["id_tipo_venta"]) {
case 1:
$vta = $exp->getNroFacturaByTipo("nro_factura_a");
break;
case 2:
$vta = $exp->getNroFacturaByTipo("nro_factura_b");
break;
default:
$vta['valor_parametro'] = "";
$oData["id_tipo_venta"] = 3;
break;
}
break;
}
if ($oData["tipo_de_facturacion"] == "rapida") {
<?php
include_once 'ExpertoVentas.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
$exp = new ExpertoVentas();
switch ($oData["behavior"]) {
case "reloadListAll":
$fecha_fin = $oData["fecha_fin"];
$fecha_inicio = $oData["fecha_inicio"];
$data = $exp->getVeltasOldSystem($fecha_inicio, $fecha_fin);
echo "<script> var data = \"{$data}\";\r\n parent.mygrid.clearAll();\r\n parent.mygrid.parse(data, 'xml');\r\n parent.mygrid.filterByAll();\r\n </script>";
exit;
break;
}
exit;
<?php
require 'ExpertoVentas.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
$exp = new ExpertoVentas();
$desde = date("Y-m-d", strtotime("-1 week"));
$hasta = date("Y-m-d");
$filterBy = "";
if ($oData["filtros"]) {
$filters = explode("||", $oData["filtros"]);
for ($i = 0; $i < count($filters); $i++) {
$fieldAnValue = explode("=", $filters[$i]);
$value[$i] = $fieldAnValue[1];
}
$filterBy .= "mygrid.getFilterElement(1).value = '" . $value[1] . "';";
$filterBy .= "mygrid.getFilterElement(2).value = '" . $value[2] . "';";
$filterBy .= "mygrid.getFilterElement(3).value = '" . $value[3] . "';";
$filterBy .= "mygrid.getFilterElement(4).value = '" . $value[4] . "';";
$filterBy .= "mygrid.getFilterElement(5).value = '" . $value[5] . "';";
$filterBy .= "mygrid.getFilterElement(6).value = '" . $value[6] . "';";
$filterBy .= "mygrid.getFilterElement(12).value = '" . $value[12] . "';";
$filterBy .= "mygrid.getFilterElement(13).value = '" . $value[13] . "';";
$filterBy .= "mygrid.filterByAll();";
$desde = $value[14];
$hasta = $value[15];
}
$data = $exp->getAllVentas($desde, $hasta);
?>
<html>
<head>
<?php
require '../../config.php';
require 'ExpertoVentas.php';
$oData = $oRequestData = $_POST ? $_POST : $_GET;
if (!$oData['detalle'] || !$oData['cabecera']) {
echo false;
exit;
}
$exp = new ExpertoVentas();
$rdo = $exp->save($oData);
if ($rdo) {
if ($oData["id_venta"]) {
pushInfo("Cambios aplicados exitosamente");
?>
<script>
parent.go("volver");
</script>
<?php
} else {
?>
<script>
var url = "getNroFactura.php?id_tipo_venta=" + parent.document.getElementById("id_tipo_venta").value;
var loader = parent.dhtmlxAjax.getSync(url);
var response =loader.xmlDoc.responseText;
parent.$("#nro_factura").html(response);
parent.showMsgeExito( "<div style='font-family:verdana'>Éxito!!!</div>" );
parent.clear();
</script>
