} else {
if (strtolower($_REQUEST['ordenar']) == 'down') {
$buscar = "> {$sugarbean->ordered}";
$seleccionar = "MIN(ordered)";
}
}
// Si sabemos que item buscamos
if ($buscar) {
// Obtenemos el ID del item superior o inferior
$sql = " SELECT i.id id " . " FROM reg_items i " . " WHERE i.deleted=0 " . " AND i.invoice_id = '{$_REQUEST['factid']}' " . " AND i.ordered = " . " ( SELECT {$seleccionar} FROM reg_items i2 " . " WHERE f2.invoice_id='{$_REQUEST['factid']}' AND i2.ordered {$buscar} AND i2.deleted = 0 )";
$result = $sugarbean->db->query($sql);
$row = $sugarbean->db->fetchByAssoc($result);
$item_id = $row['id'];
// Si encontramos el item superior o inferior, intercambiamos sus valores.
if ($item_id) {
$otro = new reg_items();
$otro->retrieve($item_id);
$temp = $otro->ordered;
$otro->ordered = $sugarbean->ordered;
$otro->save();
$sugarbean->ordered = $temp;
$sugarbean->save();
}
}
}
// handle the return location variables
if (!empty($_REQUEST['return_url'])) {
$_REQUEST['return_url'] = urldecode($_REQUEST['return_url']);
}
$GLOBALS['log']->debug("deleted Item: bean: {$bean_name}, ");
if (empty($_REQUEST['refresh_page'])) {
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
require_once 'include/utils.php';
require_once 'include/formbase.php';
require_once 'modules/reg_items/reg_items.php';
if (file_exists('modules/reg_invoices/reg_invoices.php')) {
require_once 'modules/reg_invoices/reg_invoices.php';
}
$sugarbean = new reg_items();
// perform the delete if given a record to delete
if (empty($_REQUEST['record'])) {
$GLOBALS['log']->info('delete called without a record id specified');
} else {
$record = $_REQUEST['record'];
$sugarbean->retrieve($record);
if (!$sugarbean->ACLAccess('Delete')) {
ACLController::displayNoAccess(true);
sugar_cleanup(true);
}
$GLOBALS['log']->info("deleting Item: {$record}");
// Antes de borrar, obtenemos el ID de la factura
$sql = " select invoice_id from invoice_items where deleted=0 and id = '{$record}' ";
$result = $sugarbean->db->query($sql);
$row = $sugarbean->db->fetchByAssoc($result);
$invoice_id = $row['invoice_id'];
// Borramos el Item
$sugarbean->mark_deleted($record);
// Actualizamos la factura asociada.
