global $timedate; global $app_strings; global $app_list_strings; global $current_language; global $current_user; global $sugar_version, $sugar_config; // Unimplemented until jscalendar language files are fixed // global $current_language; // global $default_language; // global $cal_codes; $focus = new EstimateComponents(); $format = new Paperformat(); $pressformat = new Pressformat(); $childformat = new Childformat(); if (!empty($_REQUEST['record'])) { $focus->retrieve($_REQUEST['record']); } echo "\n<p>\n"; if ($focus->parent_bean == 'ClientRequest') { $mod_strings['LBL_MODULE_NAME'] = $mod_strings['LBL_CLIENTREQUEST_MODULE_NAME']; } if ($focus->parent_bean == 'Estimates') { $mod_strings['LBL_MODULE_NAME'] = $mod_strings['LBL_ESTIMATES_MODULE_NAME']; } echo get_module_title($mod_strings['LBL_MODULE_NAME'], $mod_strings['LBL_MODULE_NAME'] . ": " . $focus->name, true); echo "\n</p>\n"; global $theme; $theme_path = "themes/" . $theme . "/"; $image_path = $theme_path . "images/"; require_once $theme_path . 'layout_utils.php'; $GLOBALS['log']->info("EstimateComponents detail view");
$bodyHtml .= $pdf->genCells($mod_strings["LBL_COLORS_B"], false, false, true); $bodyHtml .= $pdf->CompRows($list); $bodyHtml .= "</table>"; $bodyHtml .= "<newpage>"; //Get the components' ids $list = null; $query = "SELECT id FROM `estimates_components` WHERE parent_id='" . $focus->id . "' AND deleted=0 AND parent_bean = 'ClientRequest'"; //$query = "SELECT id FROM `estimates_components` WHERE deleted=0 AND parent_bean = 'ClientRequest'"; $result = $focus->db->query($query, true, "Error filling layout fields: "); while ($row = $focus->db->fetchByAssoc($result)) { $list[] = $row['id']; } //Initializing of EstimateComponents object needs to be done for every record for ($i = 0; $i < count($list); $i++) { $RqComps = new EstimateComponents(); $RqComps->retrieve($list[$i]); //get the $mod_strings from EstimateComponents module $mod_strings = return_module_language($current_language, "EstimateComponents"); //shortcut variables $format = $RqComps->fsize_h . "x" . $RqComps->fsize_w; $runFormat = $RqComps->run_size_x . "x" . $RqComps->run_size_y; $bleed = $RqComps->bleed_size_x . "x" . $RqComps->bleed_size_y; $baseFormat = $RqComps->base_x . "x" . $RqComps->base_y; $compsHtml .= "<br />"; $compsHtml .= $pdf->sectionHeading($mod_strings["LBL_COMPONENTS_PDF_TITLE"], $RqComps->name, $RqComps->number); $compsHtml .= $pdf->createHeading($mod_strings["LBL_GENERAL"]); $compsHtml .= $pdf->createTr(false, $mod_strings["LBL_NUMBER"], $RqComps->number, $mod_strings["LBL_QUANTITY"], $RqComps->quantity); $compsHtml .= $pdf->createTr(false, $mod_strings["LBL_VOLUME"], $RqComps->volume); $compsHtml .= $pdf->createTr(true, $mod_strings["LBL_DESCRIPTION"], $RqComps->description, null, null, true); $compsHtml .= $pdf->createHeading($mod_strings["LBL_COMPONENT_FORMATS"]); $compsHtml .= $pdf->createTr(false, $mod_strings["LBL_FORMAT"], $format, $mod_strings["LBL_RUN_FORMAT"], $runFormat);
* requirements. * * The Original Code is: SugarCRM Open Source * The Initial Developer of the Original Code is SugarCRM, Inc. * Portions created by SugarCRM are Copyright (C) 2004-2006 SugarCRM, Inc.; * All Rights Reserved. * Contributor(s): ______________________________________. */ require_once 'modules/EstimateComponents/EstimateComponents.php'; $sugarbean = new EstimateComponents(); // 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->mark_deleted($record); } // handle the return location variables $return_module = empty($_REQUEST['return_module']) ? 'EstimateComponents' : $_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}";
$bodyHtml .= $pdf->genCells($mod_strings["LBL_COMP_PAPER"], false, false, false, "25%"); $bodyHtml .= $pdf->genCells($mod_strings["LBL_COMP_FSIZE_H"]); $bodyHtml .= $pdf->genCells($mod_strings["LBL_COMP_FSIZE_W"], false, false, true); $bodyHtml .= $pdf->CompRows($list); $bodyHtml .= "</table>"; $bodyHtml .= "<newpage>"; $list = null; $query = "SELECT id FROM `estimates_components` WHERE parent_id='" . $focus->id . "' AND deleted=0"; $result = $focus->db->query($query, true, "Error filling layout fields: "); while ($row = $focus->db->fetchByAssoc($result)) { $list[] = $row['id']; } //Initializing of EstimateComponents object, needs to be done for every record for ($i = 0; $i < count($list); $i++) { $estComps = new EstimateComponents(); $estComps->retrieve($list[$i]); //get the $mod_strings from EstimateComponents module $comp_mod_strings = return_module_language($current_language, "EstimateComponents"); $description = nl2br(url2html($estComps->description)); $type = $app_list_strings['type_options'][$estComps->type]; $color = $estComps->color_side_a . "x" . $estComps->color_side_b; $fsize = $estComps->fsize_h . "x" . $estComps->fsize_w; $base = $estComps->base_x . "x" . $estComps->base_y; $bleed_size = $estComps->bleed_size_x . "x" . $estComps->bleed_size_y; $child = $estComps->child_x . "x" . $estComps->child_y; $run_size = $estComps->run_size_x . "x" . $estComps->run_size_y; $pressformat = $estComps->pressformat_x . "x" . $estComps->pressformat_y; $colorSideA = $comp_mod_strings["LBL_COLOR_SIDE_A"] . "(" . $estComps->color_side_a . ")"; $colorSideB = $comp_mod_strings["LBL_COLOR_SIDE_B"] . "(" . $estComps->color_side_b . ")"; $ink_rows = $estComps->getInkRows(); $inks_side_a = array();
function build_component_estimates_list($id) { $fields = array("id", "price"); $query_fields = " id, price "; $where = " parent_id = '{$id}' "; $component_list = $this->getComponentListData($fields, $query_fields, 'estimates_components', $where); $components_to_estimate = array(); for ($i = 0; $i < count($component_list); $i++) { $component = new EstimateComponents(); $component->retrieve($component_list[$i]['id']); $query = " SELECT id, status FROM componentestimatecalc WHERE deleted=0 and component_id='{$component->id}' "; $result = $this->db->query($query, true, "Error filling layout fields: "); $data = $this->db->fetchByAssoc($result); if ($data == null) { $temp = array(); $temp['id'] = $component->id; $temp['name'] = $component->name; $temp['price'] = $component->price; $temp['outdated'] = false; $components_to_estimate[] = $temp; } if ($data['status'] == "outdated") { $temp = array(); $temp['id'] = $component->id; $temp['name'] = $component->name; $temp['estimate_id'] = $component->parent_id; $temp['estimate_name'] = $component->parent_name; $temp['price'] = $component->price; $temp['estimate_id'] = $data['id']; $temp['outdated'] = true; $components_to_estimate[] = $temp; } } return $components_to_estimate; }
* The Initial Developer of the Original Code is SugarCRM, Inc. * Portions created by SugarCRM are Copyright (C) 2004-2006 SugarCRM, Inc.; * All Rights Reserved. * Contributor(s): ______________________________________. */ require_once 'modules/ComponentEstimateCalc/ComponentEstimateCalc.php'; require_once 'modules/EstimateComponents/EstimateComponents.php'; require_once 'include/formbase.php'; global $app_list_strings; $sugarbean = new ComponentEstimateCalc(); $sugarbean = populateFromPost('', $sugarbean); $sugarbean->status = "uptodate"; if (isset($_REQUEST['email_id'])) { $sugarbean->email_id = $_REQUEST['email_id']; } if (!$sugarbean->ACLAccess('Save')) { ACLController::displayNoAccess(true); sugar_cleanup(true); } $sugarbean->save($GLOBALS['check_notify']); $component = new EstimateComponents(); $component->retrieve($sugarbean->component_id); //// Status Update if (isset($_REQUEST['stat_action']) && !empty($_REQUEST['stat_action']) && !is_null($_REQUEST['stat_action'])) { $component->status_update('', $component->id, $_REQUEST['stat_action'], ''); } else { $component->status_update('', $component->id, '', ''); } ///////////////// $return_id = $sugarbean->id; handleRedirect($return_id, 'ComponentEstimateCalc');