Alex

From UG

Revision as of 18:25, 16 April 2012 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 21:12, 18 April 2012 (edit) (undo) Alex (Talk | contribs) (→17:39, 9 April 2012 (EDT)) Newer edit →
Line 58:		Line 58:
	== SVN updates ==		== SVN updates ==
-	== 17:39, 9 April 2012 (EDT) ==	+	== Weekly Reports ==
-		+
-	<pre>	+
-	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	+
-	</pre>	+

---

Revision as of 21:12, 18 April 2012

Contents 1 Current Work 2 Code Reviews 2.1 Acc 2.1.1 tbl Currency 3 SVN updates 4 Weekly Reports

Current Work

• 0002237: [SmartPhone App] ............. <proj parent>
• 0002515: [Estim P&L / Accruals] .......<parent>

Code Reviews

• repos

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 ;

+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| Id           | int(10)     | NO   | PRI | NULL    | auto_increment |
| Name         | varchar(50) | NO   |     | NULL    |                |
| Abbreviation | varchar(3)  | NO   |     | NULL    |                |
| IsMain       | tinyint(1)  | NO   |     | 0       |                |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set

SVN updates

Weekly Reports