Пример #1
0
         $handle = fopen($TempDBRemoves, "w");
         fwrite($handle, $Removes);
     }
 }
 zip_close($ZipFile);
 foreach ($Scripts as $Script) {
     $ZipFile = zip_open('plugins/' . $_POST['Available']);
     while ($FileName = zip_read($ZipFile)) {
         $Entry = zip_entry_name($FileName);
         if ($Entry == $Script->name) {
             $Code = zip_entry_read($FileName, 1048576);
             $TempName = tempnam('', 'SC');
             $handle = fopen($TempName, "w");
             fwrite($handle, $Code);
             rename($TempName, $Script->name);
             NewScript($Script->name, $Script->pagesecurity, $db);
             prnMsg($Script->name . ' ' . _('has been successfully added to KwaMoja'), 'success');
         }
     }
     zip_close($ZipFile);
 }
 $Zip = new ZipArchive();
 $Zip->open('plugins/' . $_POST['Available'], ZipArchive::OVERWRITE);
 $Zip->addFile($TempSummary, 'summary.xml');
 $Zip->addFile($TempMenus, $MenuLinks);
 $Zip->addFile($TempDB, $DBUpdates);
 $Zip->addFile($TempDBRemoves, $DBRemoves);
 foreach ($Scripts as $Script) {
     $Zip->addFile($Script->name);
 }
 $Zip->close();
Пример #2
0
<?php

NewScript('ModuleEditor.php', 15, $db);
NewMenuItem('system', 'Transactions', _('Update Module Order'), '/ModuleEditor.php', '22', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #3
0
<?php

NewScript('JobCards.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #4
0
<?php

InsertRecord('mailgroups', array('id', 'groupname'), array(2, 'SalesAnalysisReportRecipients'), array('id', 'groupname'), array(2, 'SalesAnalysisReportRecipients'), $db);
NewScript('MailSalesReport_csv.php', '15', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #5
0
<?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);
Пример #6
0
<?php

CreateTable('abcmethods', "CREATE TABLE `abcmethods` (\n\t`methodid` TINYINT NOT NULL DEFAULT 0,\n\t`methodname` VARCHAR(40) NOT NULL DEFAULT '',\n\tPRIMARY KEY (`methodid`)\n)", $db);
InsertRecord('abcmethods', array('methodid', 'methodname'), array(0, 'Consumption Value Ranking'), array('methodid', 'methodname'), array(0, 'Consumption Value Ranking'), $db);
CreateTable('abcgroups', "CREATE TABLE `abcgroups`(\n\t`groupid` INT(11) NOT NULL DEFAULT 0,\n\t`groupname` VARCHAR(40) NOT NULL DEFAULT '',\n\t`methodid` TINYINT NOT NULL DEFAULT 0,\n\t`apercentage` TINYINT NOT NULL DEFAULT 0,\n\t`bpercentage` TINYINT NOT NULL DEFAULT 0,\n\t`cpercentage` TINYINT NOT NULL DEFAULT 0,\n\t`zerousage` CHAR(1) NOT NULL DEFAULT 'D',\n\t`months` TINYINT NOT NULL DEFAULT 12,\n\tPRIMARY KEY (`groupid`),\n\tCONSTRAINT `abctgroups_ibfk_1` FOREIGN KEY (`methodid`) REFERENCES `abcmethods` (`methodid`)\n)", $db);
CreateTable('abcstock', "CREATE TABLE `abcstock` (\n\t`groupid` INT(11) NOT NULL DEFAULT 0,\n\t`stockid` VARCHAR(20) NOT NULL DEFAULT '',\n\t`abccategory` CHAR(1) NOT NULL DEFAULT 'C',\n\tPRIMARY KEY (`groupid`, `stockid`),\n\tCONSTRAINT `abcstock_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `abcgroups` (`groupid`),\n\tCONSTRAINT `abcstock_ibfk_2` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`)\n)", $db);
NewScript('ABCRankingMethods.php', 15, $db);
NewScript('ABCRankingGroups.php', 15, $db);
NewScript('ABCRunAnalysis.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #7
0
<?php

NewScript('SecurityTokens.php', 15, $db);
NewScript('SalesByTypePeriodInquiry.php', 2, $db);
NewScript('SalesCategoryPeriodInquiry.php', 2, $db);
NewScript('SalesTopItemsInquiry.php', 2, $db);
ChangeConfigValue('VersionNumber', '4.04', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #8
0
<?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);
Пример #9
0
<?php

NewScript('POClearBackOrders.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #10
0
AddColumn('opencashdrawer', 'paymentmethods', 'TINYINT', 'NOT NULL', '0', 'usepreprintedstationery', $db);
DropConstraint('bankaccounts', 'bankaccounts_ibfk_1', $db);
DropConstraint('banktrans', 'banktrans_ibfk_2', $db);
ChangeColumnType('accountcode', 'bankaccounts', 'varchar(20)', 'NOT NULL', '0', $db);
ChangeColumnType('bankact', 'banktrans', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('banktrans', 'banktrans_ibfk_2', 'bankact', 'bankaccounts', 'accountcode', $db);
DropConstraint('chartdetails', 'chartdetails_ibfk_1', $db);
DropPrimaryKey('chartdetails', array('accountcode', 'period'), $db);
ChangeColumnType('accountcode', 'chartdetails', 'varchar(20)', 'NOT NULL', '0', $db);
AddPrimaryKey('chartdetails', array('accountcode', 'period'), $db);
DropConstraint('gltrans', 'gltrans_ibfk_1', $db);
ChangeColumnType('account', 'gltrans', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('gltrans', 'gltrans_ibfk_1', 'account', 'chartmaster', 'accountcode', $db);
DropConstraint('pcexpenses', 'pcexpenses_ibfk_1', $db);
ChangeColumnType('glaccount', 'pcexpenses', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('pcexpenses', 'pcexpenses_ibfk_1', 'glaccount', 'chartmaster', 'accountcode', $db);
DropConstraint('pctabs', 'pctabs_ibfk_5', $db);
ChangeColumnType('glaccountassignment', 'pctabs', 'varchar(20)', 'NOT NULL', '0', $db);
ChangeColumnType('glaccountpcash', 'pctabs', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('pctabs', 'pctabs_ibfk_5', 'glaccountassignment', 'chartmaster', 'accountcode', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_1', $db);
ChangeColumnType('taxglcode', 'taxauthorities', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('taxauthorities', 'taxauthorities_ibfk_1', 'taxglcode', 'chartmaster', 'accountcode', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_2', $db);
ChangeColumnType('purchtaxglaccount', 'taxauthorities', 'varchar(20)', 'NOT NULL', '0', $db);
AddConstraint('taxauthorities', 'taxauthorities_ibfk_2', 'purchtaxglaccount', 'chartmaster', 'accountcode', $db);
AddConstraint('bankaccounts', 'bankaccounts_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
AddConstraint('chartdetails', 'chartdetails_ibfk_1', 'accountcode', 'chartmaster', 'accountcode', $db);
NewScript('NoSalesItems.php', '2', $db);
ChangeConfigValue('VersionNumber', '4.08', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #11
0
<?php

NewScript('ImportSalesPriceList.php', 15, $db);
NewMenuItem('orders', 'Maintenance', _('Import Sales Prices From CSV File'), '/ImportSalesPriceList.php', 4, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #12
0
<?php

CreateTable('tenders', "CREATE TABLE `tenders` (\n  `tenderid` int(11) NOT NULL DEFAULT '0',\n  `location` varchar(5) NOT NULL DEFAULT '',\n  `address1` varchar(40) NOT NULL DEFAULT '',\n  `address2` varchar(40) NOT NULL DEFAULT '',\n  `address3` varchar(40) NOT NULL DEFAULT '',\n  `address4` varchar(40) NOT NULL DEFAULT '',\n  `address5` varchar(20) NOT NULL DEFAULT '',\n  `address6` varchar(15) NOT NULL DEFAULT '',\n  `telephone` varchar(25) NOT NULL DEFAULT '',\n  `closed` int(2) NOT NULL DEFAULT '0',\n  `requiredbydate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  PRIMARY KEY (`tenderid`)\n)", $db);
CreateTable('tenderitems', "CREATE TABLE `tenderitems` (\n  `tenderid` int(11) NOT NULL DEFAULT '0',\n  `stockid` varchar(20) NOT NULL DEFAULT '',\n  `quantity` varchar(40) NOT NULL DEFAULT '',\n  `units` varchar(20) NOT NULL DEFAULT 'each',\n  PRIMARY KEY (`tenderid`,`stockid`)\n)", $db);
CreateTable('tendersuppliers', "CREATE TABLE `tendersuppliers` (\n  `tenderid` int(11) NOT NULL DEFAULT '0',\n  `supplierid` varchar(10) NOT NULL DEFAULT '',\n  `email` varchar(40) NOT NULL DEFAULT '',\n  `responded` int(2) NOT NULL DEFAULT '0',\n  PRIMARY KEY (`tenderid`,`supplierid`)\n)", $db);
NewScript('SupplierTenderCreate.php', '4', $db);
AddColumn('cancreatetender', 'www_users', 'TINYINT(1)', 'NOT NULL', '0', 'fullaccess', $db);
NewConfigValue('StandardCostDecimalPlaces', '2', $db);
ChangeConfigValue('VersionNumber', '4.07', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #13
0
<?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);
Пример #14
0
ChangeConfigValue('VersionNumber', '3.12.31', $db);
NewConfigValue('AutoAuthorisePO', '1', $db);
ChangeConfigValue('VersionNumber', '4.03', $db);
AddColumn('poplaced', 'salesorders', 'TINYINT', 'NOT NULL', '0', 'quotedate', $db);
AddIndex(array('poplaced'), 'salesorders', 'poplaced', $db);
ChangeConfigValue('VersionNumber', '4.03.1', $db);
ChangeConfigValue('VersionNumber', '4.03.2', $db);
AddColumn('cashsalebranch', 'locations', 'VARCHAR(10)', 'NOT NULL', "Default ''", 'managed', $db);
ChangeColumnType('cashsalecustomer', 'locations', 'VARCHAR(10)', 'NOT NULL', '', $db);
ChangeConfigValue('VersionNumber', '4.03.3', $db);
NewScript('Z_ChangeSupplierCode.php', '15', $db);
ChangeConfigValue('VersionNumber', '4.03.5', $db);
NewScript('ReprintGRN.php', '11', $db);
ChangeConfigValue('VersionNumber', '4.03.6', $db);
AddColumn('usepreprintedstationery', 'paymentmethods', 'TINYINT', 'NOT NULL', '0', 'receipttype', $db);
RemoveScript('PDFStockTransListing.php', $db);
NewScript('PDFPeriodStockTransListing.php', '3', $db);
ChangeConfigValue('VersionNumber', '4.03.7', $db);
DropColumn('itemno', 'purchorderdetails', $db);
DropColumn('subtotal_amount', 'purchorderdetails', $db);
DropColumn('package', 'purchorderdetails', $db);
DropColumn('pcunit', 'purchorderdetails', $db);
DropColumn('kgs', 'purchorderdetails', $db);
DropColumn('cuft', 'purchorderdetails', $db);
DropColumn('total_quantity', 'purchorderdetails', $db);
DropColumn('netweight', 'purchorderdetails', $db);
DropColumn('total_amount', 'purchorderdetails', $db);
DropColumn('uom', 'purchorderdetails', $db);
ChangeConfigValue('VersionNumber', '4.03.8', $db);
ChangeColumnType('stockcheckdate', 'stockcheckfreeze', 'DATE', 'NOT NULL', '0000-00-00', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #15
0
<?php

CreateTable('supplierdiscounts', "CREATE TABLE IF NOT EXISTS `supplierdiscounts` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `supplierno` varchar(10) NOT NULL,\n  `stockid` varchar(20) NOT NULL,\n  `discountnarrative` varchar(20) NOT NULL,\n  `discountpercent` double NOT NULL,\n  `discountamount` double NOT NULL,\n  `effectivefrom` date NOT NULL,\n  `effectiveto` date NOT NULL,\n  PRIMARY KEY (`id`),\n  KEY `supplierno` (`supplierno`),\n  KEY `effectivefrom` (`effectivefrom`),\n  KEY `effectiveto` (`effectiveto`),\n  KEY `stockid` (`stockid`)\n)", $db);
CreateTable('sellthroughsupport', "CREATE TABLE IF NOT EXISTS `sellthroughsupport` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `supplierno` varchar(10) NOT NULL,\n  `debtorno` varchar(10) NOT NULL DEFAULT '',\n  `categoryid` char(6) NOT NULL DEFAULT '',\n  `stockid` varchar(20) NOT NULL DEFAULT '',\n  `narrative` varchar(20) NOT NULL DEFAULT '',\n  `rebatepercent` double NOT NULL DEFAULT '0',\n  `rebateamount` double NOT NULL DEFAULT '0',\n  `effectivefrom` date NOT NULL,\n  `effectiveto` date NOT NULL,\n  PRIMARY KEY (`id`),\n  KEY `supplierno` (`supplierno`),\n  KEY `debtorno` (`debtorno`),\n  KEY `effectivefrom` (`effectivefrom`),\n  KEY `effectiveto` (`effectiveto`),\n  KEY `stockid` (`stockid`),\n  KEY `categoryid` (`categoryid`)\n)", $db);
NewScript('SellThroughSupport.php', '9', $db);
NewScript('PDFSellThroughSupportClaim.php', '9', $db);
NewScript('ReportBug.php', '15', $db);
NewScript('UploadPriceList.php', '15', $db);
AddColumn('bin', 'locstock', 'VARCHAR(10)', 'NOT NULL', '', 'reorderlevel', $db);
ChangeConfigValue('VersionNumber', '4.10.1', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #16
0
<?php

NewScript('MonthlyBankTransactions.php', '8', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #17
0
<?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);
UpdateDBNo(basename(__FILE__, '.php'));
Пример #18
0
<?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);
Пример #19
0
<?php

NewConfigValue('ExchangeRateFeed', 'ECB', $db);
AddColumn('salesperson', 'salesorders', 'VARCHAR(4)', 'NOT NULL', '', 'poplaced', $db);
ChangeColumnType('salesmancode', 'salesman', 'VARCHAR(4)', 'NOT NULL', '', $db);
DropColumn('commissionrate', 'salesorderdetails', $db);
DropColumn('commissionearned', 'salesorderdetails', $db);
NewScript('CounterReturns.php', '5', $db);
ChangeColumnType('initiator', 'purchorders', 'VARCHAR(20)', 'NOT NULL', '', $db);
CreateTable('jobcards', "CREATE TABLE `jobcards` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `debtorno` varchar(255) DEFAULT NULL,\n  `description` varchar(500) DEFAULT NULL,\n  `task1` varchar(500) DEFAULT NULL,\n  `task2` varchar(500) DEFAULT NULL,\n  `task3` varchar(500) DEFAULT NULL,\n  `task4` varchar(500) DEFAULT NULL,\n  `task5` varchar(500) DEFAULT NULL,\n  `task6` varchar(500) DEFAULT NULL,\n  `createdate` date DEFAULT NULL,\n  `completedate` date DEFAULT NULL,\n  `invoice` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n)", $db);
InsertRecord('securitytokens', array('tokenid', 'tokenname'), array('1000', 'User can view and alter sales prices'), array('tokenid', 'tokenname'), array('1000', 'User can view and alter sales prices'), $db);
InsertRecord('securitytokens', array('tokenid', 'tokenname'), array('1001', 'User can bypass purchasing security and go straight from order to invoice'), array('tokenid', 'tokenname'), array('1001', 'User can bypass purchasing security and go straight from order to invoice'), $db);
UpdateField('securitytokens', 'tokenname', 'Unknown', 'tokenid=12', $db);
AddColumn('fontsize', 'www_users', 'TINYINT(2)', 'NOT NULL', '0', 'department', $db);
NewScript('CustomerPurchases.php', '5', $db);
NewScript('GoodsReceivedButNotInvoiced.php', '15', $db);
NewScript('ItemsWithoutPicture.php', '15', $db);
UpdateField('scripts', 'pagesecurity', '2', "script='GoodsReceivedButNotInvoiced.php'", $db);
DeleteRecords('scripts', "script='Z_ItemsWithoutPicture.php'", $db);
UpdateField('scripts', 'script', 'Z_ItemsWithoutPicture.php', "script='ItemsWithoutPicture.php'", $db);
ChangeColumnType('description', 'taxauthorities', 'VARCHAR(40)', 'NOT NULL', '', $db);
NewScript('MaterialsNotUsed.php', '4', $db);
ChangeConfigValue('VersionNumber', '4.10', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #20
0
CreateTable('internalstockcatrole', "CREATE TABLE IF NOT EXISTS `internalstockcatrole` (\n  `categoryid` varchar(6) NOT NULL,\n  `secroleid` int(11) NOT NULL,\n  KEY `internalstockcatrole_ibfk_1` (`categoryid`),\n  KEY `internalstockcatrole_ibfk_2` (`secroleid`)\n)", $db);
NewScript('InternalStockCategoriesByRole.php', '15', $db);
AddColumn('internalrequest', 'locations', 'TINYINT(1)', 'NOT NULL', '1', 'cashsalebranch', $db);
ChangeColumnType('shipdate', 'loctransfers', 'DATETIME', 'NOT NULL', "0000-00-00 00:00:00", $db);
ChangeColumnType('recdate', 'loctransfers', 'DATETIME', 'NOT NULL', "0000-00-00 00:00:00", $db);
NewScript('GLJournalInquiry.php', '15', $db);
NewScript('PDFGLJournal.php', '15', $db);
AddColumn('department', 'www_users', 'INT(11)', 'NOT NULL', '0', 'pdflanguage', $db);
NewConfigValue('WorkingDaysWeek', '5', $db);
ChangeColumnType('address6', 'suppliers', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('braddress6', 'custbranch', 'VARCHAR(40)', 'NOT NULL', '', $db);
ChangeColumnType('address6', 'debtorsmaster', 'VARCHAR(40)', 'NOT NULL', '', $db);
AddConstraint('stockcatproperties', 'categoryid', 'categoryid', 'stockcategory', 'categoryid', $db);
AddConstraint('stockitemproperties', 'stockid', 'stockid', 'stockmaster', 'stockid', $db);
AddConstraint('stockitemproperties', 'stkcatpropid', 'stkcatpropid', 'stockcatproperties', 'stkcatpropid', $db);
AddConstraint('stockmovestaxes', 'stkmoveno', 'stkmoveno', 'stockmoves', 'stkmoveno', $db);
AddIndex(array('loccode'), 'stockrequest', 'loccode', $db);
AddConstraint('stockrequest', 'loccode', 'loccode', 'locations', 'loccode', $db);
AddIndex(array('departmentid'), 'stockrequest', 'departmentid', $db);
AddConstraint('stockrequest', 'departmentid', 'departmentid', 'departments', 'departmentid', $db);
AddPrimaryKey('stockrequestitems', array('dispatchitemsid', 'dispatchid'), $db);
AddIndex(array('dispatchid'), 'stockrequestitems', 'dispatchid', $db);
AddIndex(array('stockid'), 'stockrequestitems', 'stockid', $db);
AddConstraint('stockrequestitems', 'dispatchid', 'dispatchid', 'stockrequest', 'dispatchid', $db);
AddConstraint('stockrequestitems', 'stockrequestitems_ibfk_2', 'stockid', 'stockmaster', 'stockid', $db);
AddPrimaryKey('internalstockcatrole', array('categoryid', 'secroleid'), $db);
AddConstraint('internalstockcatrole', 'internalstockcatrole_ibfk_1', 'categoryid', 'stockcategory', 'categoryid', $db);
AddConstraint('internalstockcatrole', 'secroleid', 'secroleid', 'securityroles', 'secroleid', $db);
NewScript('PDFQuotationPortrait.php', '2', $db);
ChangeConfigValue('VersionNumber', '4.09', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #21
0
<?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);
Пример #22
0
<?php

CreateTable('mailgroups', "CREATE TABLE `mailgroups` (\n\tid int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n\tgroupname varchar(100) NOT NULL,\n\tunique (groupname))", $db);
CreateTable('mailgroupdetails', "CREATE TABLE `mailgroupdetails` (\n\tgroupname varchar(100) NOT NULL,\n\tuserid varchar(20) NOT NULL,\n\tCONSTRAINT FOREIGN KEY (`groupname`) REFERENCES `mailgroups` (`groupname`),\n\tCONSTRAINT FOREIGN KEY (`userid`) REFERENCES `www_users`(`userid`),\n\tINDEX(`groupname`))", $db);
NewScript('MailingGroupMaintenance.php', '15', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #23
0
NewScript('Z_ImportStocks.php', 15, $db);
NewScript('Z_ImportSuppliers.php', 15, $db);
NewScript('Z_index.php', 15, $db);
NewScript('Z_ItemsWithoutPicture.php', 15, $db);
NewScript('Z_MakeNewCompany.php', 15, $db);
NewScript('Z_MakeStockLocns.php', 15, $db);
NewScript('Z_poAddLanguage.php', 15, $db);
NewScript('Z_poAdmin.php', 15, $db);
NewScript('Z_poEditLangHeader.php', 15, $db);
NewScript('Z_poEditLangModule.php', 15, $db);
NewScript('Z_poEditLangRemaining.php', 15, $db);
NewScript('Z_poRebuildDefault.php', 15, $db);
NewScript('Z_PriceChanges.php', 15, $db);
NewScript('Z_ReApplyCostToSA.php', 15, $db);
NewScript('Z_RePostGLFromPeriod.php', 15, $db);
NewScript('Z_ReverseSuppPaymentRun.php', 15, $db);
NewScript('Z_SalesIntegrityCheck.php', 15, $db);
NewScript('Z_UpdateChartDetailsBFwd.php', 15, $db);
NewScript('Z_UpdateSalesAnalysisWithLatestCustomerData.php', 15, $db);
NewScript('Z_Upgrade3.10.php', 15, $db);
NewScript('Z_Upgrade_3.01-3.02.php', 15, $db);
NewScript('Z_Upgrade_3.04-3.05.php', 15, $db);
NewScript('Z_Upgrade_3.05-3.06.php', 15, $db);
NewScript('Z_Upgrade_3.07-3.08.php', 15, $db);
NewScript('Z_Upgrade_3.08-3.09.php', 15, $db);
NewScript('Z_Upgrade_3.09-3.10.php', 15, $db);
NewScript('Z_Upgrade_3.10-3.11.php', 15, $db);
NewScript('Z_Upgrade_3.11-4.00.php', 15, $db);
NewScript('Z_UploadForm.php', 15, $db);
NewScript('Z_UploadResult.php', 15, $db);
Пример #24
0
<?php

NewScript('PluginUpload.php', '15', $db);
NewScript('PluginInstall.php', '15', $db);
NewScript('PluginUnInstall.php', '15', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #25
0
<?php

NewScript('Z_ChangeGLAccountCode.php', '15', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #26
0
<?php

NewScript('StockClone.php', 15, $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
Пример #27
0
<?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);