Alex
From UG
(Difference between revisions)
(→17:39, 9 April 2012 (EDT)) |
(→Code Reviews) |
||
| Line 4: | Line 4: | ||
== Code Reviews == | == Code Reviews == | ||
| + | |||
| + | === Acc === | ||
| + | |||
| + | * tblCurrency | ||
| + | * | ||
| + | |||
| + | ==== tbl Currency ==== | ||
| + | |||
| + | <pre> | ||
| + | |||
| + | -- Table "tblCurrency" DDL | ||
| + | |||
| + | CREATE TABLE `tblCurrency` ( | ||
| + | `Id` int(10) NOT NULL AUTO_INCREMENT, | ||
| + | `Name` varchar(50) NOT NULL, | ||
| + | `Abbreviation` varchar(3) NOT NULL, | ||
| + | `IsMain` tinyint(1) NOT NULL DEFAULT '0', | ||
| + | PRIMARY KEY (`Id`) | ||
| + | ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 9216 kB'; | ||
| + | |||
| + | DELIMITER ;; | ||
| + | CREATE TRIGGER `tblCurrency_after_ins_tr` AFTER INSERT ON `tblCurrency` FOR EACH ROW BEGIN | ||
| + | INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId) | ||
| + | SELECT NEW.Id, `tblCurrency`.Id, `tblOffice`.Id | ||
| + | FROM tblCurrency, tblOffice | ||
| + | WHERE NOT `tblCurrency`.Id=NEW.Id; | ||
| + | INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId) | ||
| + | SELECT `tblCurrency`.Id, NEW.Id, `tblOffice`.Id | ||
| + | FROM tblCurrency, tblOffice | ||
| + | WHERE NOT `tblCurrency`.Id=NEW.Id; | ||
| + | END;; | ||
| + | DELIMITER ; | ||
| + | |||
| + | </pre> | ||
== SVN updates == | == SVN updates == | ||
Revision as of 21:47, 9 April 2012
Contents |
Code Reviews
Acc
- tblCurrency
tbl Currency
-- Table "tblCurrency" DDL
CREATE TABLE `tblCurrency` (
`Id` int(10) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,
`Abbreviation` varchar(3) NOT NULL,
`IsMain` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 9216 kB';
DELIMITER ;;
CREATE TRIGGER `tblCurrency_after_ins_tr` AFTER INSERT ON `tblCurrency` FOR EACH ROW BEGIN
INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
SELECT NEW.Id, `tblCurrency`.Id, `tblOffice`.Id
FROM tblCurrency, tblOffice
WHERE NOT `tblCurrency`.Id=NEW.Id;
INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
SELECT `tblCurrency`.Id, NEW.Id, `tblOffice`.Id
FROM tblCurrency, tblOffice
WHERE NOT `tblCurrency`.Id=NEW.Id;
END;;
DELIMITER ;
SVN updates
17:39, 9 April 2012 (EDT)
Update C:\2012\CTtags2.24.0\java\CyberTrax\sql\2012-03-30.sql C:\2012\CTtags2.24.0\java\CyberTrax\sql\ViewsProcedures.sql C:\2012\CTtags2.24.0\java\CyberTrax\sql\2012.03.30.sql C:\2012\CTtags2.24.0\java\CyberTrax\sql\2012.04.05.sql C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\ShipmentAccountingProcessor.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\security\SecurityService.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\reports\invoices\InvoicesForm.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\reports\profitLoss\ProfitLossForm.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\reports\profitLoss\ProfitLossResultWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\common\reports\shipmentsBillingRequired\ShipmentsBillingRequiredForm.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\utils\ftp\FtpConnection.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\sql\shipmentinvoices.properties C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\control\services\ShipmentInvoicesService.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\control\services\GrossMarginSplitService.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\control\services\PurchaseInvoicesService.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\model\account\PurchaseInvoice.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\data\model\shipments\ShipmentInvoice.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\profitSharing\GmsOffice.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\profitSharing\GmsShipmentInfo.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\profitSharing\GmsShipmentSplitLogItem.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\admin\grossMarginSplit\GrossMarginSplitSettingsWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\admin\grossMarginSplit\GrossMarginSplitProperties.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\admin\grossMarginSplit\RecalculateGrossMarginWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\elco\cybertrax\internal\admin\clientcompanies\ClientCompanyWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\CybertraxMainWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\admin\shipments\IndividualShipmentOceanWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\admin\masters\MasterOceanWindow.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\CTServlet.java C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\data\sql\shipments\generic.properties C:\2012\CTtags2.24.0\java\CyberTrax\src\com\sibers\cybertrax\data\control\dao\impl\GenericShipmentDAO.java C:\2012\CTtags2.24.0\java\CyberTrax\internal\MainMenu.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\reports\profitLoss\ProfitLossResultComponent.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\reports\profitLoss\ProfitLossResult.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\ops\shipment\shipmentView\ShipmentProfitLossTab.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\ops\ShipmentProfitLossTab.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\ops\master\MasterProfitLossTab.zul C:\2012\CTtags2.24.0\java\CyberTrax\internal\ops\master\ocean\MasterOcean.zul At revision: 4682
