Custom Planning Style Reports. Custom planning style reports are typically embedded within an add <\/em>or edit <\/em>screen. This user custom exit allows these reports to be run outside of these screens. The base code triggers the request to run the report from an internal flag and this cannot be accessed outside the add<\/em> and edit<\/em> pages. A UDF field is used to pass this information and to act as a filter.<\/p>\n \t\t\t\tFixed Name = UC_PLAN_RUN \t\t\t\t“Execute UC Plan Report” (UC_PLAN_RUN) = Y Purpose Applies To Custom Planning Style Reports. Custom planning style reports are typically embedded within an add or edit screen. This user custom exit allows these reports to be run outside of these screens. The base code triggers the request to run the report from an internal flag and this cannot be accessed outside the…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24510,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24605","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n\n\tSignature<\/h3>\n
\r\n
public boolean ucSearchPlanningReport( \r\n HttpServletRequest request, \r\n HttpServletResponse response, \r\n Connection dbconn, \r\n SesameSession session) \r\n throws Exception <\/code>\r\n<\/pre>\n\n\tNotes<\/h3>\n
\n\tExample<\/h3>\n
\n
\n
\n\t\t\t\tTitle to display = Execute UC Plan Report
\n\t\t\t\tDisplay Type = Text Field
\n\t\t\t\tFilter Criteria = Yes<\/li>\n<\/ul>\n<\/li>\n\n
\n\t\t\t\t <\/li>\n
\n\t\t\t\t <\/li>\n<\/ul>\n<\/li>\nucSearchPlanningReport <\/code>as follows:<\/p>\n\r\n\r\n\r\n
Report report = (Report)session.getAttribute(PlanningController.SES_PLAN_MASTER_REPORT);\r\nString title = report.getTitle();\r\nString relGroupId = report.getHierarchyId();\r\nif (\"2\".equals(relGroupId)) { \r\n FilterGroup filterGroup = report.getFilterGroup(); \r\n Filter f = filterGroup.getFilter(\"UC_PLAN_RUN\");\r\n \r\n \/\/ do not run unless the runUC flag has been set. \r\n if(f==null || (f!=null && !\"Y\".equals(f.getFilterCriteria().get(0)))) return; \r\n\r\n \/\/ check to see if the \r\n f = filterGroup.getFilter(\"REPORT_START_DATE\"); \r\n if(f==null) return; \r\n String reportStartDate= (String)f.getFilterCriteria().get(0); \r\n f = filterGroup.getFilter(\"REPORT_END_DATE\"); \r\n if(f==null) return; \r\n String reportEndDate = (String)f.getFilterCriteria().get(0); \r\n\r\n \/\/ set start date in session so that the report begins 7 days before the delivery date. \r\n try { \r\n if (TextManager.isStringVisible(reportStartDate)) {\r\n Calendar dateCal = Convert.getCalendarDayFromString(session, reportStartDate);\r\n dateCal.add(Calendar.DATE,-7);\r\n Date startDt = dateCal.getTime(); \r\n session.setAttribute(PlanningController.SES_START_DT, startDt);\r\n }\r\n} catch (Exception subE) {\r\n Z.logtrace(subE, Log.ERROR); \r\n} \r\n\/\/ exit if the report start and end dates are not set. \r\nif( TextManager.isStringInvisible(reportStartDate) \r\n || TextManager.isStringInvisible(reportEndDate)) return; \r\n\/\/ remove these fields from the report because we do not want them used \r\n\/\/ to filter the results. \r\nfilterGroup.removeFilter(\"REPORT_START_DATE\"); \r\nfilterGroup.removeFilter(\"REPORT_END_DATE\"); \r\nfilterGroup.removeFilter(\"UC_PLAN_RUN\"); \r\n\r\n\/\/ set the sort order based on Product Name. \r\nSortOrder so = new SortOrder(); \r\nSortOrderField sof = new SortOrderField(); \r\nsof.setConnection(dbconn); \r\nsof.setDDName(\"PRODUCT_NAME_UDF\"); \r\nsof.setOrderRank(0); \r\nsof.setSortDirection(\"ASC\"); \r\nso.addField(sof); \r\nreport.addSortOrder(so); \r\n\r\n\/\/ the Report Start Date and the Report End Date are required by UserJavaScript. \r\n\/\/ Place these values in session, so that they are placed on the planning report. \r\nString ucParams = \"={p_from_date_delivery : \\\"\"+deliveryDate+\"\\\",\r\n p_to_date_pickup : \\\"\"+collectionDate+\"\\\"};\"; \r\nsession.setAttribute(\"UC_RUN_PLANNING_CUSTOM\",ucParams); \r\n} <\/code><\/pre>\n<\/li>\n\r\nExecute custom JavaScript based on the contents of the ucParams above.\r\n\r\n
\/** * ucPlanningReportPostLoad *\/ \r\nfunction ucPlanningReportPostLoad(colMove, pageMove) {\r\n var runUC = false; \r\n runUC = (typeof(ucParams) != 'undefined' \r\n && typeof(ucParams.p_from_date_delivery) != 'undefined');\r\n try {\r\n if ( runUC) { \r\n \/\/ do stuff \r\n alert(\" Calling from ucPlanningReportPost Load\"); \r\n \/\/ changing background colors based on a custom ajax call \r\n } catch (err) {\r\n \/\/ ignore the error for now... \r\n alert('ucPlanningReportPostLoad:'+ err); \r\n }<\/code><\/pre>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"