SY_Selection

Class SY_Selection

Inherits

GL_AccountFormatter, SY_CommonUI, SY_GridHandler, SY_OpenObject

Known SubClasses

AP_ARClearingSelect_UI, AP_Form1099eFileandReport_ui, AP_GenerateACHCommon_UI, AP_InvoiceHistory_ui, AP_InvoicePaymentSelect_UI, AP_PaymentHistory_ui, AP_RepetitiveInvoiceSelect_ui, AP_Selection, AP_VendorCheckSearch_ui, AP_VendorInvoiceSearch_ui, AP_VendorPurchaseOrderSearch_ui, AP_VendorTransSearch_ui, AR_CustomerInvoiceSearch_ui, AR_CustomerSalesOrderSearch_ui, AR_CustomerTransactionSearch_ui, AR_InvoiceHistoryInquiry_ui, AR_PriceLevelByCustCopyList_rpt, AR_PriceLevelByCustCopy_ui, AR_Selection, BC_Selection, BM_CostedMaterialsReport_ui, BM_Selection, BR_CheckClearing_ui, BR_DepClearing_ui, BR_Selection, BR_WizardCommonUI, CI_CommodityCodeApply_ui, CI_CommonCostRollup_Ui, CI_PurgeItemHistory_UI, CM_UDTMaintSelect_UI, CU_Selection, GL_AccountSearch_ui, GL_AllocationListing_rpt, GL_RecurringJournal_rpt, GL_Selection, IM_AutoCostPriceChange_ui, IM_BalanceInvQtyCost_Utl, IM_BalanceLotSerTrans_Utl, IM_BalInvQtyCostFL_Utl, IM_ChangeLotSerialExpDates_ui, IM_ItemInquiryPOSearch_ui, IM_ItemInquirySOSearch_ui, IM_ItemInquiryWOSearch_ui, IM_ItemInquiryWTSearch_ui, IM_ItemTransSearch_ui, IM_ProductLineApply_ui, IM_SalesPromotion_UI, IM_Selection, IM_StandardCostAdjustSelect_ui, IP_Selection, JC_CostCodeApply_ui, JC_JobBillingSelection_ui, JC_JobCloseOutReport_ui, JC_JobEstimatePriceUpdate_ui, JC_JobHistorySearch_ui, JC_Selection, JC_SubcontractorAnalysisRpt_ui, MD_EISViewMasterReport_rpt, MD_EISViewMasterReport_UI, MD_MenuReport_rpt, MD_MenuReport_UI, MD_TaskReport_rpt, MD_TaskReport_UI, PL_CustomerEDeliveryInquiry_ui, PL_VendorEDeliveryInquiry_ui, PL_ViewerSearch_ui, PM_DailyMaterialsUsageReg_upd, PM_Selection, PM_WorkCenterApply_ui, PM_WorkTicketInqDCSearch_ui, PM_WorkTicketInqIMSearch_ui, PM_WorkTicketInqINVSearch_ui, PM_WorkTicketInqPOSearch_ui, PM_WorkTicketInqSTSearch_ui, PM_WorkTicketLabelPrinting_ui, PO_PurchaseOrderHistoryInq_ui, PO_PURGEOBSOLETEPO_UI, PO_ReceiptHistory_ui, PO_Selection, RA_GenerateTransactions_UI, RA_Inquiry_ui, RA_Selection, SO_CustomerLastPurchase_ui, SO_PURGEOBSOLETESALESORDERS_UI, SO_SalesOrderHistoryInquiry_ui, SO_Selection, SO_ShippingHistoryInquiry_ui, SY_DeleteChange, SY_LinkMaintenanceSearch_ui, SY_MemoHandler_UI, SY_MemoManager_UI, SY_Report, SY_ReportUI, SY_RoleReport_UI

Properties

LOCAL cDefaultOperand$="A"

LOCAL cMaintenanceOption=1

LOCAL cSkipPromote

PROPERTY Category1Desc$ * Read Only *

PROPERTY Category2Desc$ * Read Only *

PROPERTY Category3Desc$ * Read Only *

PROPERTY Category4Desc$ * Read Only *

PROPERTY HasDates * Read Only *

[boolean] Indicates if selection grid has date rows

Methods

FUNCTION BuildSelectDefaults(whereIN$, selectOUT$)

FUNCTION ChangeOperand(gridctl)

FUNCTION ChangeValue1(gridctl)

FUNCTION ChangeValue2(gridctl)

FUNCTION ClassOnFocusGrid(gridctl)

FUNCTION ClassOnFocusGridSetKey(gridctl)

FUNCTION CreateSelectWhere(token$, column$, operand$, value1$, value2$, keyref$, whereclause$, tag$)

FUNCTION GetWhereClause(table$, whereClause$)

FUNCTION GetWhereClause(table$, whereClause$, recPrefix$)

FUNCTION GetWhereClause(table$, whereClause$, recPrefix$, columnName$)

FUNCTION LoadGrid(gridCtl)

FUNCTION LoadRow(gridCtl, gridRow)

FUNCTION OnExitGrid(gridCtl)

FUNCTION PostLoadGrid(gridCtl)

FUNCTION ReadSelectDefault()

FUNCTION ResetALL(gridCtl)

FUNCTION ReturnReportSelection(selectionField$, returnValue$)

FUNCTION ReturnReportSelection(selectionField$, returnValue$, index)

FUNCTION ReturnSetupGrid(gridCtl, whereClause$)

FUNCTION ReturnSetupTable(tableFH, whereClause$)

FUNCTION RowMods(gridCtl, RowNo)

FUNCTION SaveRow(gridCtl, Row)

FUNCTION SetOperand(gridCtl)

FUNCTION SetRowState(in.Option, in.Row)

FUNCTION SetRowState(in.Option, in.Row$)

FUNCTION LOCAL AddRecPrefix$(whereClause$, recPrefix$)

Function will replace ~ in where clause specified with record prefix, will not change values in literals

Parameter	Description
[input/output,	string] The where clause.
[input,	string] record prefix to add to where clause.

Returns

[boolean] returns retSUCCESS

FUNCTION LOCAL PERFORM BuildClause()

FUNCTION LOCAL FindMultiSepChar(testString$, multSepChar$)

Function will determine if last character of string is a separator character.

Parameter	Description
[input/output,	string] Input-string to check for separator, Output-String without the last separator
[input/output,	string] Input-default sep character, Output-Default input or separator character found.

Returns

[boolean] returns retSUCCESS if separator found, retFAILURE if no ending separator

FUNCTION LOCAL FixDepartment(selecTag$, keyRef$, lineTag$)

FUNCTION LOCAL FixDivision(selecTag$, keyRef$, lineTag$)

FUNCTION LOCAL PERFORM FormatValue(tmpValue$)

FUNCTION LOCAL GetBeginEnd(where$, begin$, end$, whereInd$, chan)

FUNCTION LOCAL GetBeginEndCol(where$, colBegin$, colEnd$, col$, lengthToPad, whereStripped)

FUNCTION LOCAL PERFORM GetSelection()

FUNCTION LOCAL IsUDFReportSelection(udfName$, colInfo)

Function will return whether or not the UDF is to be included as part of the report selection criteria.

Parameter	Description
udfName$	[input, string] Name of the UDF field to test to see if it should be part of the report selection
colInfo	[input, objHandle] Handle to the dictionary object, will test the Notes section of the field definition to see the udf passed in should be part of the report selection

Returns

[boolean]

Value	Description
TRUE	if field is to be included in the report selection
FALSE	if field is to be exculded in the report selection

FUNCTION LOCAL PERFORM JoinClause()

FUNCTION LOCAL PfxWhereClause(where$, whrChan, newPfx$, newWhere$)

FUNCTION LOCAL PostLoad()

FUNCTION LOCAL PromoteCacheMode()

FUNCTION LOCAL RefreshSelectionGrid()

Refresh selection grid to default selections

Returns

[numeric] returns retSUCCESS, retWARNING, or retFAILURE

FUNCTION LOCAL PERFORM ResetValue1()

FUNCTION LOCAL PERFORM ResetValue2()

FUNCTION LOCAL SaveRowWrite(values$, selectIolist$, tRowKey$)

FUNCTION LOCAL SearchOutsideQuotes(search$, Source$)

FUNCTION LOCAL SearchOutsideQuotes(search$, Source$, found$)

FUNCTION LOCAL SelectionResetRow(gridCtl, Row)

Reset the selection information for the specified row; the operand will be set to 'All' and the two values will be cleared and updated to the associated memory file

Parameter	Description
[input,	controlID] The control ID for the selection grid
[input,	number] The row to be reset

Returns

[boolean]. retSUCCESS

FUNCTION LOCAL SetAutoComplete(gridCtl)

Function will set CellAutoCtl property in cells with auto-complete

Parameter	Description
gridCtl	[input, numeric] ctl value of grid control

Returns

[boolean] returns retSUCCESS

FUNCTION LOCAL SetupForDateSelections()

FUNCTION LOCAL SubstituteOutsideQuotes(subSource$, old$, new$)

FUNCTION LOCAL PERFORM SYSResolveSelectToken()

Properties inherited from: SY_CommonUI

CustomizerPreview, ViewOnly, ScriptsDefined, DocDateWarnDisplayed, DocDateWarnForceOff

Properties inherited from: SY_GridHandler

cAutoCompCellTypes$, cCentreCellTypes$, cEnterLikeTab$, cGridDefaultRowHeight, cLookupCellTypes$, cSearchDialogueCreated, cGridRowHeightPlus, cWdxGridLoadLimit, cExcelInstalled, cAllUsers$, cAllComps$, cAllWrks$, cOpenedNOMADSGridTable, cLocalGridVariablesSet, GridIOL$

Properties inherited from: SY_OpenObject

cLockInfoNOKEY$

Methods inherited from: GL_AccountFormatter

ExtractMainAccount(), FormatGLAccount(), ValidateGLAccountStructure()

Methods inherited from: SY_CommonUI

CallScript(), ClassFormatterDate$(), ClassFormatterTime$(), ClassFormatterUdfYesNo$(), ClassOnfocusDate(), ClassPushCreditRptPush(), ClassPushDeliveryOptionsPush(), ClassPushEmailPush(), ClassPushExecute(), ClassPushExplorerView(), ClassPushHyperlinkPush(), ClassPushMapPush(), ClassPushPkgTrackingPush(), ClassPushURLPush(), ClassValidateDate$(), ClassValidateDocumentDate(), ClassValidateUdfYesNo$(), DropBoxLoad(), FormatNumericTime(), GetControlProperty(), GetDateMasked(), GetDateRaw(), GetFolderName$(), GetPanelName$(), GetScreenName$(), GetValue(), HandleScriptUI(), InvokeChange(), InvokeLookup(), ListBoxLoad(), Process(), SetControlProperty(), SetDocDateWarnOff(), AppendTitleBar(), BT_ListBoxExportToExcel(), BT_SageU(), CheckForScripts(), ClassChangeTelephoneNoUI(), ClassPushDirectoryButton(), DrillDown(), GetListboxIol$(), GetScriptUIGroup$(), InitScriptEngine(), NomadsProcess(), ParseTagField(), PrefixVarsInList$(), RemoveVarsFromList(), SetControlState(), SetKeyState(), ShowDocumentDateWarning(), ShowSageUniversity(), Status()

Methods inherited from: SY_GridHandler

AddColumn(), ClassChangeGrid(), ClassInitializeGrid(), ClassOnFocusGrid(), ClearGrid(), DisableGrid(), DropColumn(), DropRow(), EnableGrid(), ExportToExcel(), FindColumnHeader(), FreezeColumn(), GetALEColumnInfo(), GetColumnAttributes(), GetGridIndex(), GetGridIOLIST$(), GotoCell(), GotoColumn(), GotoRow(), HideColumn(), InitializeRow(), InsertRow(), IsColumnHideAble(), IsColumnInGrid(), IsColumnMoveAble(), LoadGrid(), LoadRow(), LockGrid(), OnExitWithGrid(), ParseQuickString(), RefreshGridBindings(), RemoveGridFocus(), SaveGridSettings(), SaveRow(), SetColumnAttributes(), SetColumnAttributesHeadersMain(), SetColumnAttributesHeadersSec(), SetGridPresets(), SetupGrid(), ShowColumn(), ShowColumns(), ShowRow(), AddGroups(), AdjustNomadsInfo(), BT_RowDel(), BT_RowDown(), BT_RowIns(), BT_RowSearch(), BT_RowUp(), ChangeML_GotoLine(), ClearNomadsInfo(), CloneNomadsInfo(), CloseSearchWindow(), DoColumnChange(), DoSave(), PERFORM DoSearch(), FindNextCell(), FormatDate$(), FormatRow(), GetRowLockState(), GetWdwForCtl(), HasRowChanged(), IsColumnHidden(), IsCtlGrid(), OpenSearchWindow(), PERFORM PaintCell(), ParseIOList$(), ParseRowTag$(), PopulateGridBindings(), PutTick(), RemoveGridCustomization(), RemoveNomadsInfo(), ResetSecInitPropLists(), PERFORM ResolveFormatters(), ResolveGroups(), RestoreGridAutoComplete(), RestoreNomadsInfo(), ReturnToField(), SetButtonState(), SetButtonStateFirstRow(), SetButtonStateInsertRow(), SetButtonStateLastRow(), SetButtonStateNoRow(), SetButtonStateOtherRow(), SetColumnGroupState(), SetColumnState(), SetGridAutoComplete(), PERFORM SetGridHeaders(), PERFORM SetGridIOLISTS(), SetGridSecurity(), SetGridSize(), SetLocalGridVariables(), SetPopupStatus(), SetRowLockState(), SetRowState(), SetupNomadsInfo(), ShowSearchResult(), TestAutoCompleteObj()

Methods inherited from: SY_OpenObject

CheckWhoHasLock(), CreateLockInfo(), RemoveLockInfo(), OpenTable(), OpenTempFile()