function component_update($id, $close = false) { $product_estimate = new ProductEstimate(); $components_estimate = new ComponentEstimate(); $product = new Products(); $query = ' SELECT id FROM ' . $components_estimate->table_name . ' WHERE component_id="' . $id . '" AND deleted=0 '; $result = $this->db->query($query, true, ""); if ($result != false) { while ($data = $this->db->fetchByAssoc($result)) { $components_estimate->mark_deleted($data['id']); } } $query = ' UPDATE ' . $product->table_name . ' SET status="draft" WHERE id="' . $this->parent_id . '" AND deleted=0 '; $this->db->query($query, true, ""); $query = ' UPDATE ' . $product_estimate->table_name . ' SET status="outdated" WHERE id="' . $this->parent_id . '" AND deleted=0 '; $this->db->query($query, true, ""); }
function estimate_update($id, $close = false) { $estimate_estimate = new EstimateCalc(); $components_estimate = new ComponentEstimate(); $component = new EstimateComponents(); if (close == true) { $query = ' UPDATE ' . $estimate_estimate->table_name . ' SET status="closed" WHERE estimate_id="' . $id . '" AND deleted=0 '; $this->db->query($query, true, ""); } else { $query = ' SELECT id FROM ' . $estimate_estimate->table_name . ' WHERE estimate_id="' . $id . '" AND deleted=0 '; $result = $this->db->query($query, true, ""); if ($result != false) { while ($data = $this->db->fetchByAssoc($result)) { $estimate_estimate->mark_deleted($data['id']); } } } $query = ' SELECT id FROM ' . $component->table_name . ' WHERE parent_id="' . $id . '" AND deleted=0 '; $result = $this->db->query($query, true, ""); if ($result != false) { if (close == true) { $query = ' UPDATE ' . $component->table_name . ' SET status="closed" WHERE parent_id="' . $id . '" AND deleted=0 '; $this->db->query($query, true, ""); } while ($data = $this->db->fetchByAssoc($result)) { if (close == true) { $query = ' UPDATE ' . $components_estimate->table_name . ' SET status="closed" WHERE component_id="' . $data['id'] . '" AND deleted=0 '; $this->db->query($query, true, ""); } else { $component->mark_deleted($data['id']); $query = ' SELECT id FROM ' . $components_estimate->table_name . ' WHERE component_id="' . $data['id'] . '" AND deleted=0 '; $result_components_estimate = $this->db->query($query, true, ""); if ($result_components_estimate != false) { while ($data = $this->db->fetchByAssoc($result)) { $components_estimate->mark_deleted($data['id']); } } } } } }
* Portions created by SugarCRM are Copyright (C) 2004-2006 SugarCRM, Inc.; * All Rights Reserved. * Contributor(s): ______________________________________. */ require_once 'modules/ComponentEstimate/ComponentEstimate.php'; $sugarbean = new ComponentEstimate(); // 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 record: {$record}"); $sugarbean->delete_estimate($record); $sugarbean->mark_deleted($record); } // handle the return location variables $return_module = empty($_REQUEST['return_module']) ? 'ComponentEstimate' : $_REQUEST['return_module']; $return_action = empty($_REQUEST['return_action']) ? 'index' : $_REQUEST['return_action']; $return_id = empty($_REQUEST['return_id']) ? '' : $_REQUEST['return_id']; $return_location = "index.php?module={$return_module}&action={$return_action}"; // append the return_id if given if (!empty($return_id)) { $return_location .= "&record={$return_id}"; } // now that the delete has been performed, return to given location header("Location: {$return_location}");