Alex
From UG
(Difference between revisions)
(→W 18 Apr) |
(→Weekly Reports) |
||
| Line 66: | Line 66: | ||
==== W 18 Apr ==== | ==== W 18 Apr ==== | ||
| - | * GM Split | + | * '''GM Split''' - 1h |
** SIT, etc | ** SIT, etc | ||
| - | * Estim GM - 5h | + | * '''Estim GM''' - 5h |
** completely rewriting SOW: more clear/ simple approach, etc | ** completely rewriting SOW: more clear/ simple approach, etc | ||
| - | * Mobile App - 0h | + | * '''Mobile App''' - 0h |
| - | * Meetings/Misc - 2h | + | * '''Meetings/Misc''' - 2h |
** ihelp - helping AG to cover for Denise, etc | ** ihelp - helping AG to cover for Denise, etc | ||
** weekly Perry's meeting | ** weekly Perry's meeting | ||
** meeting w/ Marc | ** meeting w/ Marc | ||
** discussing code management w/ Perry | ** discussing code management w/ Perry | ||
| + | |||
| + | '''TOTAL''': 8 hours | ||
Revision as of 21:21, 18 April 2012
Contents |
Current Work
- 0002237: [SmartPhone App] ............. <proj parent>
- 0002515: [Estim P&L / Accruals] .......<parent>
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 ;
+--------------+-------------+------+-----+---------+----------------+ | 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
w16
Mon 16 Apr
Tue 17 Apr
W 18 Apr
- GM Split - 1h
- SIT, etc
- Estim GM - 5h
- completely rewriting SOW: more clear/ simple approach, etc
- Mobile App - 0h
- Meetings/Misc - 2h
- ihelp - helping AG to cover for Denise, etc
- weekly Perry's meeting
- meeting w/ Marc
- discussing code management w/ Perry
TOTAL: 8 hours
