<?php
AddColumn('userid', 'stockrequest', 'VARCHAR( 20 )', 'NOT NULL', '', 'dispatchid', $db);
NewMenuItem('stock', 'Transactions', _('Amend an internal stock request'), '/InternalStockRequest.php?Edit=Yes', 11, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewMenuItem('Utilities', 'Transactions', _('Import GL Transactions from a csv file'), '/Z_ImportGLTransactions.php', 11, $db);
NewScript('/Z_ImportGLTransactions.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
CreateTable('pricematrix', "CREATE TABLE IF NOT EXISTS `pricematrix` (\n `salestype` char(2) NOT NULL DEFAULT '',\n `stockid` varchar(20) NOT NULL DEFAULT '',\n `quantitybreak` int(11) NOT NULL DEFAULT '1',\n `price` double NOT NULL DEFAULT '0',\n PRIMARY KEY (`salestype`,`stockid`,`quantitybreak`),\n KEY `DiscountCategory` (`stockid`),\n KEY `SalesType` (`salestype`)\n)", $db);
NewScript('PriceMatrix.php', 11, $db);
NewMenuItem('system', 'Reports', _('Mantain prices by quantity break and sales types'), '/PriceMatrix.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewScript('ModuleEditor.php', 15, $db);
NewMenuItem('system', 'Transactions', _('Update Module Order'), '/ModuleEditor.php', '22', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewScript('Z_ImportDebtors.php', 15, $db);
NewScript('Z_ImportSuppliers.php', 15, $db);
NewMenuItem('Utilities', 'Transactions', _('Import Debtors'), '/Z_ImportDebtors.php', 13, $db);
NewMenuItem('Utilities', 'Transactions', _('Import Suppliers'), '/Z_ImportSuppliers.php', 14, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
NewMenuItem('Utilities', 'Reports', _('Show Local Currency Total Debtor Balances'), '/Z_CurrencyDebtorsBalances.php', 1, $db);
NewMenuItem('Utilities', 'Reports', _('Show Local Currency Total Suppliers Balances'), '/Z_CurrencySuppliersBalances.php', 2, $db);
NewMenuItem('Utilities', 'Reports', _('Show General Transactions That Do Not Balance'), '/Z_CheckGLTransBalance.php', 3, $db);
NewMenuItem('Utilities', 'Reports', _('List of items without picture'), '/Z_ItemsWithoutPicture.php', 4, $db);
NewMenuItem('Utilities', 'Maintenance', _('Maintain Language Files'), '/Z_poAdmin.php', 1, $db);
NewMenuItem('Utilities', 'Maintenance', _('Make New Company'), '/Z_MakeNewCompany.php', 2, $db);
NewMenuItem('Utilities', 'Maintenance', _('Data Export Options'), '/Z_DataExport.php', 3, $db);
NewMenuItem('Utilities', 'Maintenance', _('Import Stock Items from .csv'), '/Z_ImportStocks.php', 4, $db);
NewMenuItem('Utilities', 'Maintenance', _('Import Fixed Assets from .csv file'), '/Z_ImportFixedAssets.php', 5, $db);
NewMenuItem('Utilities', 'Maintenance', _('Create new company template SQL file and submit to KwaMoja'), '/Z_CreateCompanyTemplateFile.php', 6, $db);
NewMenuItem('Utilities', 'Maintenance', _('Re-calculate brought forward amounts in GL'), '/Z_UpdateChartDetailsBFwd.php', 7, $db);
NewMenuItem('Utilities', 'Maintenance', _('Re-Post all GL transactions from a specified period'), '/Z_RePostGLFromPeriod.php', 8, $db);
NewMenuItem('Utilities', 'Maintenance', _('Purge all old prices'), '/Z_DeleteOldPrices.php', 9, $db);
NewMenuItem('Utilities', 'Transactions', _('Import GL Transactions from a csv file'), '/Z_ImportGLTransactions.php', 11, $db);
NewMenuItem('stock', 'Maintenance', _('Brands Maintenance'), '/Manufacturers.php', 11, $db);
NewMenuItem('GL', 'Transactions', _('Import Bank Transactions'), '/ImportBankTrans.php', 5, $db);
NewMenuItem('FA', 'Reports', _('My Maintenance Schedule'), '/MaintenanceUserSchedule.php', 2, $db);
NewMenuItem('FA', 'Reports', _('Maintenance Reminder Emails'), '/MaintenanceReminders.php', 3, $db);
NewMenuItem('FA', 'Maintenance', _('Maintenance Tasks'), '/MaintenanceTasks.php', 3, $db);
NewMenuItem('system', 'Transactions', _('Web-Store Configuration'), '/ShopParameters.php', 21, $db);
NewMenuItem('system', 'Transactions', _('Update Module Order'), '/ModuleEditor.php', '22', $db);
NewMenuItem('Utilities', 'Transactions', _('Update sales analysis with latest customer data'), '/Z_UpdateSalesAnalysisWithLatestCustomerData.php', 12, $db);
NewMenuItem('PO', 'Transactions', _('Create a PO based on the preferred supplier'), '/PurchaseByPrefSupplier.php', 9, $db);
NewMenuItem('orders', 'Maintenance', _('Import Sales Prices From CSV File'), '/ImportSalesPriceList.php', 4, $db);
NewMenuItem('stock', 'Transactions', _('Amend an internal stock request'), '/InternalStockRequest.php?Edit=Yes', 11, $db);
NewMenuItem('Utilities', 'Transactions', _('Import Debtors'), '/Z_ImportDebtors.php', 13, $db);
NewMenuItem('Utilities', 'Transactions', _('Import Suppliers'), '/Z_ImportSuppliers.php', 14, $db);
NewMenuItem('system', 'Maintenance', _('Bank Account Authorised Users'), '/BankAccountUsers.php', 13, $db);
NewMenuItem('system', 'Reports', _('Mantain prices by quantity break and sales types'), '/PriceMatrix.php', 15, $db);
NewMenuItem('GL', 'Transactions', _('Process Regular Payments'), '/RegularPaymentsProcess.php', 7, $db);
<?php
NewScript('PurchaseByPrefSupplier.php', 4, $db);
NewMenuItem('PO', 'Transactions', _('Create a PO based on the preferred supplier'), '/PurchaseByPrefSupplier.php', 9, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
CreateTable('bankaccountusers', "CREATE TABLE IF NOT EXISTS `bankaccountusers` (\n `accountcode` varchar(20) NOT NULL DEFAULT '',\n `userid` varchar(20) NOT NULL DEFAULT '',\n PRIMARY KEY (accountcode,userid)\n)", $db);
$sql = "INSERT INTO bankaccountusers (SELECT bankaccounts.accountcode, www_users.userid FROM bankaccounts, www_users)";
$result = DB_query($sql, $db);
NewScript('BankAccountUsers.php', 15, $db);
NewMenuItem('system', 'Maintenance', _('Bank Account Authorised Users'), '/BankAccountUsers.php', 13, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
NewMenuItem('system', 'Maintenance', _('MRP Demand Types'), '/MRPDemandTypes.php', 6, $db);
NewMenuItem('system', 'Maintenance', _('Maintain Internal Departments'), '/Departments.php', 7, $db);
NewMenuItem('system', 'Maintenance', _('Maintain Internal Stock Categories to User Roles'), '/InternalStockCategoriesByRole.php', 8, $db);
NewMenuItem('system', 'Maintenance', _('Report a problem with KwaMoja'), '/ReportBug.php', 9, $db);
NewMenuItem('system', 'Maintenance', _('Upload a KwaMoja plugin file'), '/PluginUpload.php', 10, $db);
NewMenuItem('system', 'Maintenance', _('Install a KwaMoja plugin'), '/PluginInstall.php', 11, $db);
NewMenuItem('system', 'Maintenance', _('Remove a KwaMoja plugin'), '/PluginUnInstall.php', 12, $db);
NewMenuItem('Utilities', 'Transactions', _('Change A Customer Code'), '/Z_ChangeCustomerCode.php', 1, $db);
NewMenuItem('Utilities', 'Transactions', _('Change A Customer Branch Code'), '/Z_ChangeBranchCode.php', 2, $db);
NewMenuItem('Utilities', 'Transactions', _('Change A Supplier Code'), '/Z_ChangeSupplierCode.php', 3, $db);
NewMenuItem('Utilities', 'Transactions', _('Change A Location Code'), '/Z_ChangeLocationCode.php', 4, $db);
NewMenuItem('Utilities', 'Transactions', _('Change An Inventory Item Code'), '/Z_ChangeStockCode.php', 5, $db);
NewMenuItem('Utilities', 'Transactions', _('Change A General Ledger Code'), '/Z_ChangeGLAccountCode.php', 6, $db);
NewMenuItem('Utilities', 'Transactions', _('Update costs for all BOM items, from the bottom up'), '/Z_BottomUpCosts.php', 7, $db);
NewMenuItem('Utilities', 'Transactions', _('Re-apply costs to Sales Analysis'), '/Z_ReApplyCostToSA.php', 8, $db);
NewMenuItem('Utilities', 'Transactions', _('Delete sales transactions'), '/Z_DeleteSalesTransActions.php', 9, $db);
NewMenuItem('Utilities', 'Transactions', _('Reverse all supplier payments on a specified date'), '/Z_ReverseSuppPaymentRun.php', 10, $db);
NewMenuItem('Utilities', 'Reports', _('Show Local Currency Total Debtor Balances'), '/Z_CurrencyDebtorsBalances.php', 1, $db);
NewMenuItem('Utilities', 'Reports', _('Show Local Currency Total Suppliers Balances'), '/Z_CurrencySuppliersBalances.php', 2, $db);
NewMenuItem('Utilities', 'Reports', _('Show General Transactions That Do Not Balance'), '/Z_CheckGLTransBalance.php', 3, $db);
NewMenuItem('Utilities', 'Reports', _('List of items without picture'), '/Z_ItemsWithoutPicture.php', 4, $db);
NewMenuItem('Utilities', 'Maintenance', _('Maintain Language Files'), '/Z_poAdmin.php', 1, $db);
NewMenuItem('Utilities', 'Maintenance', _('Make New Company'), '/Z_MakeNewCompany.php', 2, $db);
NewMenuItem('Utilities', 'Maintenance', _('Data Export Options'), '/Z_DataExport.php', 3, $db);
NewMenuItem('Utilities', 'Maintenance', _('Import Stock Items from .csv'), '/Z_ImportStocks.php', 4, $db);
NewMenuItem('Utilities', 'Maintenance', _('Import Fixed Assets from .csv file'), '/Z_ImportFixedAssets.php', 5, $db);
NewMenuItem('Utilities', 'Maintenance', _('Create new company template SQL file and submit to KwaMoja'), '/Z_CreateCompanyTemplateFile.php', 6, $db);
NewMenuItem('Utilities', 'Maintenance', _('Re-calculate brought forward amounts in GL'), '/Z_UpdateChartDetailsBFwd.php', 7, $db);
NewMenuItem('Utilities', 'Maintenance', _('Re-Post all GL transactions from a specified period'), '/Z_RePostGLFromPeriod.php', 8, $db);
NewMenuItem('Utilities', 'Maintenance', _('Purge all old prices'), '/Z_DeleteOldPrices.php', 9, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewScript('ImportSalesPriceList.php', 15, $db);
NewMenuItem('orders', 'Maintenance', _('Import Sales Prices From CSV File'), '/ImportSalesPriceList.php', 4, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewScript('Z_UpdateSalesAnalysisWithLatestCustomerData.php', 15, $db);
NewScript('Dashboard.php', 0, $db);
NewMenuItem('Utilities', 'Transactions', _('Update sales analysis with latest customer data'), '/Z_UpdateSalesAnalysisWithLatestCustomerData.php', 12, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
NewMenuItem('stock', 'Maintenance', _('Brands Maintenance'), '/Manufacturers.php', 11, $db);
NewMenuItem('GL', 'Transactions', _('Import Bank Transactions'), '/ImportBankTrans.php', 5, $db);
NewMenuItem('FA', 'Reports', _('My Maintenance Schedule'), '/MaintenanceUserSchedule.php', 2, $db);
NewMenuItem('FA', 'Reports', _('Maintenance Reminder Emails'), '/MaintenanceReminders.php', 3, $db);
NewMenuItem('FA', 'Maintenance', _('Maintenance Tasks'), '/MaintenanceTasks.php', 3, $db);
NewMenuItem('system', 'Transactions', _('Web-Store Configuration'), '/ShopParameters.php', 21, $db);
NewScript('MaintenanceTasks.php', 1, $db);
NewScript('MaintenanceUserSchedule.php', 1, $db);
NewScript('MaintenanceReminders.php', 1, $db);
NewScript('ImportBankTransAnalysis.php', 11, $db);
NewScript('ImportBankTrans.php', 11, $db);
NewScript('Manufacturers.php', 15, $db);
NewScript('SalesCategoryDescriptions.php', 15, $db);
NewScript('ShopParameters.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);