PL_CommonUtility

Class PL_CommonUtility

Inherits

CI_CommonPII, PL_Constant, SY_Constant, SY_OpenObject, SY_Password

Properties

LOCAL cFileSeqLength=3

LOCAL cPDFSuffix$=".PDF"

LOCAL cPlaceHolder$="_"

LOCAL cInvalidChars$=QUO+"*\/:<>?|;"

LOCAL cReplacementChar$="#"

PROPERTY ActualCompanyALL

PROPERTY AlwaysGetListsFromFile

PROPERTY CurrentCompany$

PROPERTY DocumentRec$

PROPERTY DocumentIol$

PROPERTY FormPrintUIDropBoxLoad$ * Read Only *

PROPERTY FormPrintUIDropBoxTranslate$ * Read Only *

PROPERTY FormPrintUISelection$

PROPERTY LogAssociatedPDFDirectory$

PROPERTY LogAssociatedPDFFilename$

PROPERTY OnlyKeepLastCopy$ * Read Only *

PROPERTY PaperlessType$

PROPERTY PDFAppend

PROPERTY PDFLogFile$ * Read Only *

PROPERTY PDFMaintFile$ * Read Only *

PROPERTY PDFOwnerPassword$

PROPERTY PDFPeriodEndDate$

PROPERTY PDFUserPassword$

PROPERTY PeriodEndPDFPrompt$

PROPERTY PeriodEndPasswordSkip

PROPERTY PL_Enabled * Read Only *

PROPERTY PL_FormElectronicDeliveryEnabled * Read Only *

PROPERTY ReportPDFPrompt$

PROPERTY UI=coPLCommonUI

PROPERTY cLogFileChn

Methods

FUNCTION AppendPDFFiles(in.FileA$, in.FileAPassword$, in.FileB$, in.FileBPassword$)

FUNCTION CheckPaperlessTypeFormStatus(in.PaperlessType$)

FUNCTION CheckPaperlessTypeFormStatus(in.PaperlessType$, in.ModuleOnly$)

FUNCTION CheckPDFStatus(in.FullFileName$)

FUNCTION CheckSecurity(in.Taskname$)

FUNCTION CheckSecurity(in.TaskName$, in.Module$)

FUNCTION CheckSecurity(in.TaskName$, in.Module$, skipSecurity)

FUNCTION CheckSecurity(in.TaskName$, in.Module$, in.CompanyKey$)

FUNCTION CheckSecurityModule(in.Module$, in.Company$)

FUNCTION ElectronicDelivery(in.documentArray${ALL})

FUNCTION ElectronicDelivery(in.documentArray${ALL}, in.FromFormPrinting, in.EmailEngine, in.FaxEngine, out.Selection$, out.ElectronicDeliveryOptions$)

FUNCTION ElectronicDelivery(in.documentArray${ALL}, in.FromFormPrinting, in.EmailEngine, in.FaxEngine, out.Selection$, out.ElectronicDeliveryOptions$, in.NoUI)

FUNCTION ElectronicDelivery(in.document$)

FUNCTION ElectronicDelivery(in.document$, in.FromFormPrinting, in.EmailEngine, in.FaxEngine, out.Selection$, out.ElectronicDeliveryOptions$)

FUNCTION ElectronicDelivery(in.document$, in.FromFormPrinting, in.EmailEngine, in.FaxEngine, out.Selection$, out.ElectronicDeliveryOptions$, in.NoUI)

FUNCTION FormDeliveryOptions(in.Key1$, in.Key2$, out.Rec$, out.Iol$)

FUNCTION FormDeliveryOptionsDetail(in.Key1$, in.Key2$, in.Email$, in.Fax$, in.FaxRecipientName$, in.Document$, out.EmailAddresses$, out.FaxNumbers$, out.FaxRecipientNames$)

FUNCTION FormDeliveryOptionsDetail(in.Key1$, in.Key2$, in.Email$, in.Fax$, in.FaxRecipientName$, in.Document$, out.EmailAddresses$, out.FaxNumbers$, out.FaxRecipientNames$, out.EmailCCAddresses$, out.EmailBCCAddresses$)

FUNCTION GeneratePDFFileName(in.Document$, in.ModuleCode$, in.JournalNo$, in.BatchFlag$, in.BatchNo$, in.PDFDeletePostProcess, out.PDFDirectory$, out.PDFFilename$)

FUNCTION GeneratePDFFileName(in.Document$, in.ModuleCode$, in.JournalNo$, in.BatchFlag$, in.BatchNo$, in.PDFDeletePostProcess, out.PDFDirectory$, out.PDFFilename$, in.PostingDate$)

FUNCTION GenerateRandomPassword$(in.MinLength, in.MaxLength)

FUNCTION GenerateRandomPassword$(in.MinLength, in.MaxLength, in.MixedCase)

FUNCTION GetDefaultArgs(out.CompanyKey$, out.ModuleCode$, out.Document$)

FUNCTION GetFormType(in.taskID$, inout.formType$)

FUNCTION GetPaddedKey$(in.keyValues$)

FUNCTION GetPaddedKey$(in.keyValues$, in.index)

FUNCTION GetPaddedKey$(in.keyValues$, in.index$)

FUNCTION GetPaperlessTypeByName$(in.Name$)

FUNCTION GetPaperlessTypeByName$(in.Name$, setPaperlessType)

FUNCTION GetPaperlessTypeByTask$(in.taskID$)

FUNCTION GetPaperlessTypeByTask$(in.taskID$, setPaperlessType)

FUNCTION GetPDFCompanyList(out.CompanyList${ALL})

FUNCTION GetPDFConverterInfo(name$, driver$, printer$, version$)

Function to return values needed to make use of the Amyuni PDF Converter

Parameter	Description
name$	[output, string] Returned value of Name
driver$	[output, string] Returned value of Driver
printer$	[output, string] Returned value of Printer
version$	[output, string] Returned value of Version

Value	Description
retTRUE	(1) - method returns success

FUNCTION GetPDFModuleList(in.CompanyCode$, out.ModuleList${ALL})

FUNCTION GetPDFModuleList(in.CompanyCode$, out.ModuleList${ALL}, in.SkipSecurity)

FUNCTION GetPDFModuleList(in.CompanyCode$, out.ModuleList${ALL}, in.SkipSecurity, in.ModuleOnly$)

FUNCTION GetPDFOptions(out.IOList$, out.Record$)

FUNCTION GetPDFOptions(out.IOList$, out.Record$, in.company$)

FUNCTION GetPDFOptions(out.IOList$, out.Record$, in.company$, in.module$)

FUNCTION GetPDFOptions(out.IOList$, out.Record$, in.company$, in.module$, in.Document$)

FUNCTION GetPDFOptions(out.IOList$, out.Record$, in.company$, in.module$, in.Document$, out.Key$)

FUNCTION GetPDFParameter(out.Value$, in.Column$)

FUNCTION GetPDFParameter(out.Value$, in.Column$, in.company$)

FUNCTION GetPDFParameter(out.Value$, in.Column$, in.company$, in.module$)

FUNCTION GetPDFParameter(out.Value$, in.Column$, in.company$, in.module$, in.Document$)

FUNCTION GetPDFProgramList(in.CompanyCode$, in.ModuleCode$, out.ProgramList${ALL})

FUNCTION GetPDFProgramList(in.CompanyCode$, in.ModuleCode$, out.ProgramList${ALL}, includeModule)

FUNCTION GetPDFProgramList(in.CompanyCode$, in.ModuleCode$, out.ProgramList${ALL}, includeModule, in.SkipSecurity)

FUNCTION GetProgramDescription$(in.Document$)

FUNCTION GetProgramDescription$(in.Document$, noModule)

FUNCTION GetProgramDescription$(in.Document$, noModule, in.Module$)

FUNCTION GetProgramNameFromTaskMemoryFile$(in.TaskName$)

FUNCTION IsEnabled()

FUNCTION IsSetup(module$, company$)

FUNCTION ParseFileName$(in.FullFileName$)

FUNCTION PreparePDFForFaxing(in.FileName$, in.Password$, out.FileName$)

FUNCTION PromptForAssociatedDocument(out.FileName$)

FUNCTION PromptForAssociatedDocument(out.FileName$, in.Defaultpath$)

FUNCTION PromptForPassword(out.password$)

FUNCTION PromptForPDF$(in.Document$)

FUNCTION PurgePDFLog(in.PaperlessType$, in.FormKey$, in.WhereClause$, in.PurgeAssociatedPDF)

FUNCTION PurgePDFLog(in.PaperlessType$, in.FormKey$, in.WhereClause$, in.PurgeAssociatedPDF, in.MultiCompany)

FUNCTION PurgePDFLog(in.PaperlessType$, in.FormKey$, in.WhereClause$, in.PurgeAssociatedPDF, in.MultiCompany, in.ReportKey$, in.Company$)

FUNCTION ReportPDFPrompt(out.prompt$, in.EmainEngine, in.FaxEngine)

FUNCTION SetPaperlessType(in.type$)

FUNCTION SetPaperlessType(in.type$, in.CompanyCode$)

FUNCTION SetupPDFFormPrinting(in.company$, in.module$, in.Document$, out.PDFIolistSrc$, out.PDFIolistDst$)

FUNCTION UpdatePDFLog(in.Key$, in.partialRecord$, in.partialIOL$)

FUNCTION ViewPDF(in.FullFileName$)

FUNCTION WritePDFLog()

FUNCTION WritePDFLog(out.Key$)

FUNCTION WritePDFLog(out.Key$, in.SkipWrite, out.Record$, out.iolist$)

Properties inherited from: CI_CommonPII

AllowSensitiveAccess

Properties inherited from: PL_Constant

cDefaultMessage$, isALL$, isALLFILE$, isALLCOMPANY$, isALLMODULES$, isALLDOCUMENTS$, isBlank$, isRandom$, isSocialSecurity$, logJOURNALSANDREGISTERS$, logCUSTOMER$, logVENDOR$, logEMPLOYEE$, logREPORT$, logPERIODEND$, logFORMS$, frmINVOICES$, frmSTATEMENTS$, frmORDERS$, frmCHECKSTUBS$, frmDIRECTDEPOSITSTUBS$, frmCUSTOMERRMAS$, frmRMARECEIVERS$, frmRETURNORDERS$, frmCustomerEmailHeader$, frmCustomerFaxHeader$, frmVendorEmailHeader$, frmVendorFaxHeader$, defaultPasswordMinLen, defaultPasswordMaxLen, tstPDFFile$, array.CompanyKey, array.CompanyCode, array.CompanyName, array.ModuleCode, array.ModuleName, array.ProgramName, array.ProgramDesc, emailDocumentType$, faxDocumentType$, covNONE, covLOCAL, covSERVER, covDEFAULT$, recipientTypeTO$, recipientTypeCC$, recipientTypeBCC$, attachFULLDESCRIPTION$, attachDOCUMENTNO$

Properties inherited from: SY_Constant

retFAILURE, retSUCCESS, retNEW, retWARNING, retCANCEL, retYES, retNO, msgYES$, msgNO$, msgCANCEL$, msgOK$, msgRETRY$, msgABORT$, msgIGNORE$, msgNOTONFILE$, msgTIMEOUT$, msgDISABLE, msgACTIVE, msgLinkHELP$, msgLinkMSG$, isFALSE, isTRUE, isYES$, isNO$, isBUSY$, edtNONE, edtEXISTS, edtNEW, ctlDISABLE, ctlENABLE, ctlSHOW, ctlHIDE, ctlLOCK, ctlUNLOCK, ctlLOCKORDISABLE, ctlUNLOCKORENABLE, popHIDE, popDISABLE, popSHOW, popSHOWCHECKED, grdMODEVIEW, grdMODEMAINT, grdMODEADD, filCREATE, filLOCK, filCREATELOCK, filGLOBAL, filCREATEGLOBAL, filLOCKGLOBAL, filCREATELOCKGLOBAL, filCHANNEL, filRAW, filPURGE, filLOAD, filINPUT, filNOOBJECT, filPVX, filREFRESH, filPVX4$, filPVX5$, pthCOMPANY$, pthOTHERCOMPANY$, pthPRCOMPANY$, pthOTHERPRCOMPANY$, pthSYSTEM$, pthUSER$, pthSOA$, pthHOME$, pthROOT$, pthDICTIONARY$, pthTEXTOUT$, pthLOCK$, pthLOCKSYS$, pthPREFIX$, pthARCHIVE$, pthLOGFILES$, folderCOMMONPROGRAMFILES, folderCOMMONAPPLICATIONDATA, errOBJECT, errSYSTEMLOCK, errCONTINUE, errEMBEDDEDIO, errSYSLOCK, extSQLCREATETABLE$, extSQLALLOWNULLDATES$, dbALL$, dbNONE$, dateTOSTRINGFORMAT$, dateLONGMASK$, dateSHORTFMT, dateLONGFMT, dateYEARFIRST, dateMONTHFIRST, dateDAYFIRST, timeMINUTESMASK$, timeMINUTES24MASK$, timeSECONDSMASK$, timeSECONDS24MASK$, idxPRIMARY$, idxBATCH$, idxDISPLAY$, dirFIRST, dirLAST, dirNEXT, dirPREVIOUS, typALPHANUM, typZEROFILL, typCHARNUM, typMASTERNUM, typALPHANUMNF, typMASTERNUMC, typALPHA$, typNUMBERS$, typALPHANUM$, typALPHANUMNF$, typCHARNUM$, typMASTERNUM$, typMASTERNUMCLEN, modTASKOTFDISALLOW$, logALLACTIVITY$, logACTIVITY$, logERROR$, logACTNEWCUSTOMER$, logACTDATASYNC$, logACTDATAIMPORT$, logACTOPTIONCHANGED$, logACTPROGRAMLAUNCH$, logDFDM$, logSECURITY$, logTASKSCHEDULER$, logWEBERROR$, logVISUALINTEGRATOR$, logEntryIDLength, chkOFF$, chkON$, chkGRAYED$, secVIEWONLY, secCREATEONLY, secMODIFYONLY, secCREATEMODIFY, secDELETEONLY, secCREATEDELETE, secMODIFYDELETE, secFULLACCESS, secDEFAULTUSER$, secDEFAULTROLE$, regHKEY_CLASSES_ROOT, regHKEY_CURRENT_USER, regHKEY_LOCAL_MACHINE, regHKEY_USERS, regHKEY_CURRENT_CONFIG, regODBC_PATH$, regMAS_PATH$, E3_MYHANDLE, E3_TASK, E3_QUIT, E3_COCHANGE, E3_DATECHANGE, E3_USERCHANGE, E3_SRVRPATH, E3_HELPFILE, E3_TECHSUPPORT, E3_QUERYTOQUIT, E3_SUPERVISOR, E3_CUSTOMIZE, E3_SWITCHMODULE, E3_DISABLEWIN, E3_CURSOR, E3_USERID, E3_PRIVATETASK, E3_CHAT, E3_BROADCAST, E3_RELOAD, E3_PASSTHROUGH, E3_EXECUTE, E3_EXPCOCHANGE, E3_EXPTASK, E3_EXPLAUNCH, E3_SILENT, E3_DIRECT, E3_NODELIST, E3_OCXITEM, E3_MODULEID, E3_CUSTFAV, E3_HOMEPAGE, E3_MINIMIZE, E3_UNDOCKED, E3_DOCKED, E3_PUBLICTASK, E3_LAUNCHURL, E3_BTNCHANGE, E3_STDBTNRELOAD, E3_MYBUSINESS, E3_REGLOADED, E3_LOADED, E3_V4TASK, E3_PUBMODIFY, E3_TASKRELOAD, E3_SETAUTOHIDE, E3_COCHANGE2, E3_TASK_NC, E3_V4TASK_NC, E3_TASK_ALTC, E3_V4TASK_ALTC, E3_PASSWORD, E3_LAUNCHVIEW, E3_LAUNCHBIETASK, E3_CLEANUPBIE, E3_STARTVIEW, E3_BIE_ADMIN, E3_HELPPATH, E3_CUSTOMERID, E3_MASVERSION, E3_LAUNCHEMBEDDED, E3_LAUNCHERMENU, E3_APP_POINTSIZE, E3_LAUNCHERVERSION, E3_DISABLE, E3_ENABLE, E3_SHOW, E3_HIDE, E3_REFRESH, E3_LIBMASTER, WM_COPY, wtsINITIALPROGRAM, wtsAPPLICATIONNAME, wtsWORKINGDIRECTORY, wtsOEMID, wtsSESSIONID, wtsUSERNAME, wtsWINSTATIONNAME, wtsDOMAINNAME, wtsCONNECTSTATE, wtsCLIENTBUILDNUMBER, wtsCLIENTNAME, wtsCLIENTDIRECTORY, wtsCLIENTPRODUCTID, wtsCLIENTHARDWAREID, wtsCLIENTADDRESS, wtsCLIENTDISPLAY, wtsCLIENTPROTOCOLTYPE, thmNORMAL, thmMETAL, thmOLIVE, rptREPORTTYPESTD, rptREPORTTYPELABEL, rptREPORTTYPEMULTCOL, rptISTRUE, rptISFALSE, rptISDEFAULT, rptPORTRAIT, rptLANDSCAPE, rptASCENDING, rptDESCENDING, rptRIGHTALIGN, rptLEFTALIGN, rptHORCENTERALIGN, rptLSSINGLELINE, rptSTSUM, rptSTAVERAGE, rptSTCOUNT, rptDFLTHSPACING, rptDFLTVSPACING, rptDFLTFONTSIZE, rptDFLTLEFT, rptDFLTTOP, rptTWIPSPERCHARW, rptTWIPSPERCHARH, rptSVTREPORTTITLE, rptEDTDISKFILE, rptGCANYVALUE, rptGCDAILY, rptCRDATEFIELD, rptCRDATETIMEFIELD, crEFTCrystalReport, crEFTRichText, crEFTWordForWindows, crEFTExcel, crEFTPortableDocFormat, crEFTHTML32, crEFTHTML40, crEFTExcelRecord, crEFTText, crEFTCharacterSeparatedValues, crEFTTabSeparatedText, crEFTEditableRTF, crEFTXml, crEFTRPTR, crEFTExcelWorkbook, cContextKeyLen1, cContextKeyLen2, cContextKeyLen3, adCmdText, adCmdStoredProc, adClipString, adExecuteNoRecords, adVarChar, adInteger, adParamInput, adParamOutput, adParamInputOutput, adParamReturnValue, adTextNoRecords, adOpenForwardOnly, adOpenStatic, adLockReadOnly, adUseServer, adUseClient, dbTMP$, dbTEMPDB$, dbSYSDB$, dbPVXDDF, dbPVXDB, dbMYSQL, dbADO, dbSQL, LastErrorMsg$, LastErrorNum$, SageCloudAppDesc$, IolNomads$

Properties inherited from: SY_OpenObject

cLockInfoNOKEY$

Properties inherited from: SY_Password

AESCipher$, AES256Cipher$

Methods inherited from: CI_CommonPII

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

Methods inherited from: PL_Constant

DirectoryCheck(), GetDefaultCompanyParameter(), GetEDeliveryDropBoxDesc$(), LocationPathCheck(), ClassChangeDirectoryBrowse(), ClassOnFocusDirectoryBrowse(), ClassPushDirectoryBrowseBTN(), GetUNCNamedDrive(), InitializeArrays(), ParseTagField()

Methods inherited from: SY_Constant

GetNOMADSIolist$(), MaskString(), RawString(), ClassValidateEMailAddress(), dateTODAY$(), Element$(), fmtMODCODE$(), fmtMODPREFIX$(), PERFORM FunctionBreak(), GetExceptionMsg$(), GetFileName(), GetJobTitles(), GetPrinterProps(), GetRecordCount(), isALPHA(), isDATE(), isNUMERIC(), MsgPath$(), ParseString(), ParseTagField(), Position(), QUO$(), ValidateFormatType()

Methods inherited from: SY_OpenObject

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

Methods inherited from: SY_Password

ConfirmAESKey(), ConfirmPassword(), EncryptAESData(), EncryptAESKey(), EncryptAESPassword(), EncryptPassword(), GetAESDataTest$(), PasswordAcceptable(), ValidateAESData(), ValidateAESPassword(), ValidatePassword(), VerifyAESDataEncryption(), DecryptAESData(), DecryptAESKey(), DecryptAESPassword(), DecryptAltAESData(), DecryptPassword(), EncryptAltAESData(), GetKEK$(), InitAESKey(), InitializeAES(), InitializeAltAES(), ValidateAltAESData(), VerifyAltAESDataEncryption()