Class PM_Selection

Inherits

CI_CommonPII, CI_MFGEmployee_Val, PM_Constant, SY_Selection

Known SubClasses

PM_DailyMaterialsUsageReg_ui, PM_DispatchSheetPrinting_ui, PM_IndentedTemplateReport_ui, PM_IndentedWhereUsedReport_ui, PM_MaterialShortageReport_ui, PM_OnDemandCostLedger_ui, PM_OnDemandMissingCost_ui, PM_OnDemandVarianceReport_ui, PM_OpenWorkTicketReport_ui, PM_OperationTicketPrinting_ui, PM_PeriodicLaborReport_ui, PM_PickingSheetPrinting_ui, PM_PurgeWorkTicketHistory_UI, PM_ToolingRequirementReport_ui, PM_TransactionHistory_ui, PM_WIPReconciliationReport_UI, PM_WorkTicketHistoryReport_ui, PM_WorkTicketInqLDSearch_ui, PM_WorkTicketMemoPrinting_ui, PM_WorkTicketPrinting_ui, PM_WorkTicketStepMemoPrint_ui

Properties

No Properties

Methods

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

Get begin, end and index to optimize selection of records from a table

ParameterDescription
where$ [input, string] where clause of selection criteria for table
begin$ [output, string] begin value to use for select
end$ [output, string] end value to use for select
whereInd$ [output, string] index to use for select
chan [input, numeric] file handle to table to select from
Returns [boolean] Always returns success
FUNCTION LOCAL ParseEmployeeWhereClause(employeeWhere$, lastNameWhere$)  
FUNCTION LOCAL ParseEmployeeWhereClause(employeeWhere$, lastNameWhere$, namePrefix$)  
FUNCTION LOCAL ParseEmployeeWhereClause(employeeWhere$, lastNameWhere$, namePrefix$, emplPrefix$)  

Removes potential LastName column component from PM_Employee main select where clause, returns a PM_Employee LastName column where clause.

ParameterDescription
employeeWhere$ [input, string] PM_Employee main select where clause that may include LastName column from base SY_Selection
lastNameWhere$ [output, string] where clause for PM_Employee LastName column
namePrefix$ {optional} [input, string] prefix to be included in the lastNameWhere$ where clause returned.
emplPrefix$ {optional} [input, string] prefix used to generate employeeWhere$
Returns [boolean] retSUCCESS or retFAILURE
FUNCTION LOCAL ResolveSelectToken(row$, value$, values$, rowTag$)  

Resolve Select Token override for worked department number

ParameterDescription
row$ [input, string] row number being used.
value$ [input, string] value of the token.
values$ [input, string] all values used for the given row, defined in the grid presets in NOMADS
rowTag$ [output, string] tag for the row to be created by the function.
Returns [boolean]
ValueDescription
retSUCCESS(1) If token parsed and resolved successfully
retFAILURE(0) If token was not parsed and resolved successfully
FUNCTION LOCAL ValidateDepartmentSecurity(empFH, employeeWhereClause$)  

Validates Department Security

ParameterDescription
empFH [input, numeric] PM_Employee file handle
employeeWhereClause$ [input, string] PM_Employee whereClause$
Returns [boolean] retSUCCESS or retFAILURE

Properties inherited from: CI_CommonPII

AllowSensitiveAccess

Properties inherited from: PM_Constant

actClassEMPLOYEE$, actClassGENERAL$, actClassMACHINE$, actClassOUTSIDESVC$, capTimeNO$, capTimeNOEDIT$, capTimeYES$, earnTypeALLOCTIPS$, earnTypeEXCLUDETIPCALC$, earnTypeEXEMPTTIPS$, earnTypeFRINGE$, earnTypeMISC$, earnTypeOVERTIME$, earnTypeREGULAR$, earnTypeTAXABLETIPS$, earnTypeTIMEOFF1$, earnTypeTIMEOFF2$, earnTypeTIMEOFF3$, cAllEarningsTypes$, earnMethodADDAMOUNT$, earnMethodFIXED$, earnMethodSTANDARD$, cAllEarnMethods$, lttLABOR$, lttCREW$, lttMISC$, lttINOUT$, lttCOST$, dpcSTANDARD$, dpcAVERAGE$, dpcLAST$, overheadTypeAMOUNT$, overheadTypePERCENT$, prtPickNONE$, prtPickBYWHSE$, prtPickBYTICK$, tcmCodeACTUAL$, tcmCodeBUDGET$, tcmCodeSTANDARD$, tcmCodeLOWER$, tcmDescACTUAL$, tcmDescBUDGET$, tcmDescSTANDARD$, tcmDescLOWER$, trnLABOR$, trnMATERIALS$, trnCLOSE$, trnCOMPLETION$, trcSTATUS$, trcLABOR$, trcINVENTORY$, trcDIRECTCHARGE$, trcINVOICE$, trcCLOSE$, trcSCRAP$, udiSTRING$, udiNUMBER$, udiYESNO$, udiCODE$, udiDATE$, mftCodeSALESORDER$, mftCodeSALESORDERLINE$, mftCodeWORKTICKET$, mftCodeINVENTORY$, mftDescSALESORDER$, mftDescSALESORDERLINE$, mftDescWORKTICKET$, mftDescINVENTORY$, wtsOPEN$, wtsQUOTE$, wtsRELEASED$, wtsCLOSED$, wtsDELETED$, lbrIssMethodAUTOISSUE$, lbrIssMethodBACKFLUSH$, lbrIssMethodMANUAL$, matIssMethodAUTOISSUE$, matIssMethodBACKFLUSH$, matIssMethodMANUAL$, prtWORKTICKET$, prtOPERATIONTICKET$, prtCOMPLETEMISSINGCOST$, prtCOMPLETEVARFROMSTD$, prtCLOSEMISSINGCOST$, prtCLOSEVARFROMSTD$, prtCLOSECOSTLEDGER$, prtPICKSHEET$, drtBACKOUT$, drtADDIN$, drsNEW$, drsUPDATED$, drsCOMPLETED$, schFIXED$, schACTSPERHOUR$, schHOURSPERACT$, scaleNOSCALING$, scalePRODUCTIONRUN$, scalePARENTSPERTEMPLATE$, scaleTEMPLATESPERPARENT$, stepZERO$, dfltClosureWorkCenter$

Properties inherited from: SY_Selection

cDefaultOperand$, cMaintenanceOption, cSkipPromote, Category1Desc$, Category2Desc$, Category3Desc$, Category4Desc$, HasDates

Methods inherited from: CI_CommonPII

GetDecryptedCols(), CheckEncryptedCols(), ClearEncryptedCols(), DecryptRec(), EncryptRec(), GetEncryptedCols(), InitEncryptInfo(), MaskColumnValue$(), ResetEncryptedCols()

Methods inherited from: CI_MFGEmployee_val

ClassValidateMFG_Employee()

Methods inherited from: PM_Constant

BuildAlternateIOL$(), BuildMemoryFile(), ConvertCalendarToJulian(), ConvertJulianToCalendar$(), FormatTime$(), HHMMToMinutes(), HHMMToNum(), LoadCustomLabelConstants(), NumToHHMM$(), TimeToHHMM()

Methods inherited from: SY_Selection

BuildSelectDefaults(), ChangeOperand(), ChangeValue1(), ChangeValue2(), ClassOnFocusGrid(), ClassOnFocusGridSetKey(), CreateSelectWhere(), GetWhereClause(), LoadGrid(), LoadRow(), OnExitGrid(), PostLoadGrid(), ReadSelectDefault(), ResetALL(), ReturnReportSelection(), ReturnSetupGrid(), ReturnSetupTable(), RowMods(), SaveRow(), SetOperand(), SetRowState(), AddRecPrefix$(), PERFORM BuildClause(), FindMultiSepChar(), FixDepartment(), FixDivision(), PERFORM FormatValue(), GetBeginEnd(), GetBeginEndCol(), PERFORM GetSelection(), IsUDFReportSelection(), PERFORM JoinClause(), PfxWhereClause(), PostLoad(), PromoteCacheMode(), RefreshSelectionGrid(), PERFORM ResetValue1(), PERFORM ResetValue2(), SaveRowWrite(), SearchOutsideQuotes(), SelectionResetRow(), SetAutoComplete(), SetupForDateSelections(), SubstituteOutsideQuotes(), PERFORM SYSResolveSelectToken()