/* Create ACL audit data and write to csv file. */ CACF_CreateAclAuditDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumUserNamesByGuid, &$altiumFoldersByGuid, &$altiumItemsByGuid, &$altiumItemRevsByGuid, &$altiumAclUserPermissions, &$altiumAclDataByObjectGuid); /* Analyze all Vault folder user parameters and store for later use. */ CACF_AnalyzeVaultFolderUserParameters(&$db, &$CACFconstants, &$altiumUserParmNames, &$altiumFolderUserParmValuesByGuid); /* Analyze all Vault item user parameters and store for later use. */ CACF_AnalyzeVaultItemUserParameters(&$db, &$CACFconstants, &$altiumUserParmNames, &$altiumItemUserParmValuesByGuid); /* Create model audit data and write to csv file. */ CACF_CreateModelAuditDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumUserNamesByGuid, &$altiumFoldersByGuid, &$altiumAclDataByObjectGuid, &$altiumItemRevsByGuid); /* Create model where-used data and write to csv file. */ CACF_CreateModelWhereUsedDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumItemRevsByGuid); /* Create PCB audit data and write to csv file. */ CACF_CreatePcbAuditDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumUserNamesByGuid, &$altiumFoldersByGuid, &$altiumAclDataByObjectGuid, &$altiumItemRevsByGuid); /* Create component audit data. */ CACF_CreateComponentAuditData(&$db, &$CACFconstants, &$altiumUserNamesByGuid, &$altiumFoldersByGuid, &$altiumAclDataByObjectGuid, &$altiumItemRevsByGuid, &$altiumItemSysParmValuesByGuid, &$altiumObsoleteCompsByGuid); /* Write component audit data to csv file. */ CACF_WriteComponentAuditDataToCsv(&$CACFconstants, &$auditComponentsByType, &$auditComponentsByTypeUnmatched, &$altiumUserParmNames, &$altiumItemUserParmValuesByGuid, &$altiumItemSysParmValuesByGuid, &$altiumObsoleteCompsByGuid, &$altiumUserParmNamesByCompType, &$altiumParmsByCompType); /* Create all per-component-type audit data and output to csv files. */ CACF_CreateAllComponentTypeAuditDataAndWriteToCsv(&$CACFconstants, &$altiumParmsByComponentLines, &$altiumUserParmNamesByCompType, &$altiumParmsByCompType, &$altiumItemSysParmValuesByGuid, &$altiumItemUserParmValuesByGuid, &$altiumObsoleteCompsByGuid); /* Create per-component audit data and output to csv files. */ CACF_CreatePerComponentAuditDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumParmsByComponentLines); /* Create folder audit data and output to csv file. */ CACF_CreateFolderAuditDataAndWriteToCsv(&$db, &$CACFconstants, &$altiumUserNamesByGuid, &$altiumFoldersByGuid, &$altiumFolderUserParmValuesByGuid, &$altiumUserParmNames, &$altiumAclDataByObjectGuid); /* Create change-log data and write to csv file. */ CACF_CreateChangeLogAuditDataAndWriteToCsv(&$db, $CACFconstants, &$altiumUserNamesByGuid); /** Wrap things up. **/ /** Report script done and peak memory usage. **/ echo date('H:i:s') . " Script is ending successfully.\n"; echo date('H:i:s') . " Peak memory usage: " . memory_get_peak_usage(true) / 1024 / 1024 . " MiB.\n"; } /* endif */ ?>
function UCTCF_CreateExcelComponentAuditData(&$CACFconstants, &$auditComponentsByType, &$auditComponentsByTypeUnmatched, &$UCTCFconstants, &$altiumUserParmNames, &$altiumUserParmNamesByCompType, &$altiumObsoleteCompsByGuid, &$excelUserParmsByItemHrid, &$excelSysParmsByItemHrid) { /* Flag that we want to write this audit file with the "_Excel" suffix. */ $CACFconstants["auditComponentsByTypeFileName"] = $CACFconstants["auditComponentsByTypeFileNameExcel"]; /* Pretend to write Excel component audit data to csv file. */ /* This is the only run using Excel derived data. Output is $altiumParmsByCompType. */ CACF_WriteComponentAuditDataToCsv($CACFconstants, $auditComponentsByType, $auditComponentsByTypeUnmatched, $altiumUserParmNames, $excelUserParmsByItemHrid, $excelSysParmsByItemHrid, $altiumObsoleteCompsByGuid, $altiumUserParmNamesByCompTypeFOO, $altiumParmsByCompType); /* Create all Excel per-component-type audit data and output to csv files. */ CACF_CreateAllComponentTypeAuditDataAndWriteToCsv($CACFconstants, $altiumParmsByComponentLines, $altiumUserParmNamesByCompType, $altiumParmsByCompType, $excelSysParmsByItemHrid, $excelUserParmsByItemHrid, $altiumObsoleteCompsByGuid); //print_r(PHPExcel_Calculation::getInstance()->debugLog); }