upgrade2.9-2.9a.sql

java开源项目源代码

BEGIN;
INSERT INTO `Help` VALUES (3, 130, 'Enter the suppliers name and postal address, terms of payment', '');
INSERT INTO `Help` VALUES (4, 160, 'The main menu is split into sections depending on the user\'s module selection from the tabs accross the top of the menu. The screen actually is different for different users depending on the modules that the system administrator has elected to let you see. Some or all of:\r\n<LI> Orders </LI>\r\n<LI> Receivables </LI>\r\n<LI> Payables </LI>\r\n<LI> Purchasing </LI>\r\n<LI> Inventory </LI>\r\n<LI> Manufacturing </LI>\r\n<LI> Set Up </LI>\r\n<P>Selecting any of these tabs then shows the options available grouped between transactions in the first box, then inquiries or reports in the middle box, then maintenance in the bottom section. Clicking on the text of any option on the main menu proceeds to perform that action.\r\n<P><B>Using the Short Cut Menu</B>\r\n<P>Most actions involving customers will require selection of a customer first, similarly for suppliers and inventory the supplier or item must be selected first. Having selected the customer/supplier/item the selection screens show a sub menu relavent to the selected customer/supplier/item for most transactions and inquiries this is the more direct method of actioning. The traditional menu is available to aid the transition to this method of navigation.\r\n', '');
INSERT INTO `Help` VALUES (5, 93, 'Enter either a portion of the suppliers name or a portion of the suppliers code then hit the search now button.\r\nThe suppliers with the entered text in their name or code will show. Clicking on the button in the code column selects a supplier. Once a supplier has been selected then all the options relevant to the supplier show with links split into three columns - inquiries, transactions, maintenance:\r\n<LI>Supplier Account Inquiry</LI>\r\n<LI>Show this suppliers outstanding purchase orders</LI>\r\n<LI>Show all the suppliers purchase orders</LI>\r\n<LI>Show Shipments set up from the Supplier</LI>\r\n\r\nUnder Transactions Links there are links to enter a suppliers invoice, a debit (credit) note, a payment to the supplier or reverse goods received from a supplier.\r\n\r\nUnder Maintenance Links - the details of the supplier can be amended, new contacts together with email addresses can be maintained and new shipments initiated.\r\n', 'S');
INSERT INTO `Help` VALUES (8, 133, '<font size="+2"><b>Setting Up Users</b></font>\r\n<br><br>\r\nHaving logged in as the demonstration user. A new user should be defined whom has administrative privileges and the demonstration user should be deleted. From the menu click on the Setup tab and the select Set Up User Accounts, the users defined are displayed and User names must be 5 characters or more and the password entered must be 5 characters or more too. The password cannot also be the user name or contain the user name. It is not necessary to enter the full name telephone and other details. The access level selected is important as this determines the pages that the user can access. In any business where the employees are not also the owners it is advisable to split the functions between staff so that no user can complete an entire transaction. There are occasions in smaller businesses where this is impractical. However, the system has great flexibility to allow the user access to be finely defined. See the security schema section. \r\n<br><br>\r\nAs well as allowing the access to be restricted there is some flexibility about the links that are made available to a user. In the user account screen the system administrator can define which tabs of the main menu are activiated and available to the user.\r\n<br><br>\r\nThere is also the facility to set up customers with their own logon. This restricts them to inquiries on their account including invoice re-prints and to entering new sales order. Customer logins do not allow any modification to the pricing. To do this the access level must be set to customer logon and the settings for customer logon in config.php must not be modified - ie $PageSecurity = 1 allowed only. In addition, the customer code and branch code applicable to the person logging on must be entered.\r\n<br><br>\r\n<font size="+3"><b>Security Schema</b></font>\r\n<br><br>\r\nThe user name and password combination entered at logon enables the system to identify the permissions appropriate to the user. It is possible to determine and restrict which pages a user should be able to access. Each user is allocated to an Access Level or Security Group. \r\n<br><br>\r\nThe Security group must be defined in config.php in two ways. \r\n<br><br>\r\n<ul>\r\n<li>The Security Group Headings are defined in an array called SecurityHeadings.\r\n<li>The Security Group page access codes applicable to the group must be defined in the SecurityGroups array - in the same order as the SecurityHeadings array. Ie the first security heading refers to the first array stored in the SecurityGroups array.\r\n</ul>\r\nEach script is defined as having a specific PageSecurity level. At the time of writing this is a number between 1 and 15 - if more levels of security are necessary then this can be expanded. The current PageSecurity settings applicable for each page are set out in the table below.\r\n<br><br>\r\nIf the PageSecurity setting of the page is a number contained in the SecurityGroup array as determined from the users access level then the user will be allowed access to the page. The user access level is an integer that represents the index number of the array element of the SecurityGroups array defined in config.php.\r\n<br><br>\r\nAccess authority is checked in header.inc script for all pages (or PDF_Starter.inc for PDF pages). The variable $_SESSION["AccessLevel"] is retrieved from the database when the user logs in. This variable refers to the index of the SecurityGroups array or arrays. The array of numbers that is referenced by this index defines the pages a user can see. Any page that has a $PageSecurity equal to any value in this array is deemed to be an authorised page.\r\n<br><br>\r\nIf you wish to add more security groups then you must add a new Security Heading to the $SecurityHeadings array and a new array of PageSecurity numbers to the $SecurityGroups array. This mechanism allows the system administrator to closely and accurately control who can access what.\r\n<br><br>\r\nBy changing the numbers in each array the security access can be tailored for all users referring to the array being modified. When setting the numbers in the array, reference to the index of PageSecurity values below will be necessary. Of course the value of the default settings can easily be modified.\r\n<br><br>\r\nThe default settings in config.php are as follows:\r\n<br><br>\r\nIndex Group\r\n<br><br>\r\n0 Inquiries Only\r\n<br>\r\n1 Manufacturing/Inventory Admin\r\n<br>\r\n2 Purchasing officer\r\n<br>\r\n3 AP Clerk\r\n<br>\r\n4 AR Clerk\r\n<br>\r\n5 Accountant\r\n<br>\r\n6 Customer logon \r\n<br>\r\n7 System Administrator\r\n<br><br>\r\nto achieve this the following array for $SecurityHeadings is defined - the index number starting from 0 is incremented for each entry:\r\n<br><br>\r\n$SecurityHeadings = array(\r\n<br>\r\n"Inquiries/Order Entry",\r\n<br>\r\n"Manufac/Inventory Admin",\r\n<br>\r\n"Purchasing Officer",\r\n<br>\r\n"AP Clerk",\r\n<br>\r\n"AR Clerk",\r\n<br>\r\n"Accountant",\r\n<br>\r\n"Customer Log On Only",\r\n<br>\r\n"System Administrator"\r\n<br>\r\n);\r\n<br><br>\r\nthe corresponding array of SecurityGroup arrays is defined in config.php also. The first array (1,2) refers to the page security numbers that a user with "Inquiries/Order Entry" access would be authorised to view.\r\n<br><br>\r\n$SecurityGroups = array(\r\n<br>\r\narray(1,2),\r\n<br>\r\narray(1,2,11),\r\n<br>\r\narray(1,2,4),\r\n<br>\r\narray(1,2,5),\r\n<br>\r\narray(1,2,3),\r\n<br>\r\narray(1,2,3,4,5,6,7,8,9,10,11),\r\n<br>\r\narray(1),\r\n<br>\r\narray(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)\r\n<br>\r\n);\r\n<br><br>\r\nThe system continues to evolve and the information set out below may be different in the current version. By default, each page has the variable $PageSecurity defined as follows:\r\n<br><br>\r\n<table border="2">\r\n<th>Script File Name\r\n<th>PageSecurity value \r\n<tr>\r\n<td>\r\nindex.php\r\n</td>\r\n<td>\r\n1\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomerInquiry.php\r\n</td>\r\n<td>\r\n1\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nDeliveryDetails.php\r\n</td>\r\n<td>\r\n1\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectOrderItems.php\r\n</td>\r\n<td>\r\n1\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nAccountGroups.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLAccounts.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLJournal.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBankAccounts.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCOGSGLPostings.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCompanyPreferences.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPaymentTerms.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesGLPostings.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryCostUpdate.php\r\n</td>\r\n<td>\r\n10\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrices_Customer.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrices.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryAdjustments.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventorys.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryTransfers.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nFreightCosts.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGoodsReceived.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nLocations.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryCategories.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nTaxAuthorities.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nWWW_Users.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_CreateCompany.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_DeleteCreditNote.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_DeleteInvoice.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_DeleteSalesTransActions.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_index.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_MakeInventoryLocns.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_RePostGLFromPeriod.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_ReverseSuppPaymentRun.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_UpdateChartDetailsBFwd.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_UploadForm.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nZ_UploadResult.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesTypes.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nShippers.php\r\n</td>\r\n<td>\r\n15\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nAgedDebtors.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nAgedSuppliers.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nConfirmDispatch_Invoice.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomerTransInquiry.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nFTP_RadioBeacon.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryPlanning.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryValuation.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nOrderDetails.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPeriodsInquiry.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPO_PDFPurchOrder.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPO_SelectPurchOrder.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrintCustOrder.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrintCustStatements.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrintCustTrans_A4_Portrait.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPrintCustTrans.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesAnalReptCols.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesAnalRepts.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesAnalysis_UserDefined.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectCompletedOrder.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectCustomer.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectProduct.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectSalesOrder.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectSupplier.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nShiptsList.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryMovements.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryStatus.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryUsage.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSupplierInquiry.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBOMInquiry.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBOMListing.php\r\n</td>\r\n<td>\r\n2\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCredit_Invoice.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomerAllocations.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomerBranches.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomerReceipt.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCustomers.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPDFBankingSummary.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectCreditItems.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nAreas.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nCreditStatus.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSalesPeople.php\r\n</td>\r\n<td>\r\n3\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPO_Header.php\r\n</td>\r\n<td>\r\n4\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPO_Items.php\r\n</td>\r\n<td>\r\n4\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPurchData.php\r\n</td>\r\n<td>\r\n4\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nInventoryReorderLevel.php\r\n</td>\r\n<td>\r\n4\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nPayments.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppCreditGRNs.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppInvGRNs.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSupplierAllocations.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSupplierContacts.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSupplierCredit.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSupplierInvoice.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppliers.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppPaymentRun.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppShiptChgs.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSuppTransGLAnalysis.php\r\n</td>\r\n<td>\r\n5\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBankMatching.php\r\n</td>\r\n<td>\r\n7\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBankReconciliation.php\r\n</td>\r\n<td>\r\n7\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLAccountInquiry.php\r\n</td>\r\n<td>\r\n8\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLCodesInquiry.php\r\n</td>\r\n<td>\r\n8\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLTransInquiry.php\r\n</td>\r\n<td>\r\n8\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nGLTrialBalance.php\r\n</td>\r\n<td>\r\n8\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nSelectGLAccount.php\r\n</td>\r\n<td>\r\n8\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nBOMs.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\nWorkCentres.php\r\n</td>\r\n<td>\r\n11\r\n</td>\r\n</tr>\r\n</table>', 'S');