Inheritance diagram for update_20120706115700:
Protected Attributes | |
| $timestamp = '20120706115700' | |
| $description | |
| $author = 'Andy Theuninck (WFC)' | |
| $queries | |
 Protected Attributes inherited from UpdateObj | |
| $timestamp = 'YYYYMMDDHHMMSS' | |
| $description = 'Describe what your update does' | |
| $author = 'Say who you are' | |
| $queries | |
Additional Inherited Members | |
| Public Member Functions inherited from UpdateObj | |
| HtmlInfo () | |
| HtmlQueries () | |
| ApplyUpdates () | |
| CheckStatus () | |
| SetStatus ($st) | |
Member Data Documentation
|
protected |
Initial value:
= 'This update revises
TenderTapeGeneric using grouping. This makes cash total
correct.'
|
protected |
Initial value:
= array(
'op' => array(),
'trans' => array(
"ALTER VIEW TenderTapeGeneric AS
select
max(tdate) as tdate,
emp_no,
register_no,
trans_no,
CASE WHEN trans_subtype = 'CP' AND upc LIKE '%MAD%' THEN ''
WHEN trans_subtype IN ('EF','EC','TA') THEN 'EF'
ELSE trans_subtype
END AS tender_code,
-1 * sum(total) as tender
from dlog
WHERE datediff(curdate(),tdate)=0
and trans_subtype not in ('0','')
GROUP BY emp_no, register_no, trans_no,
tender_code",
),
'archive' => array()
)
The documentation for this class was generated from the following file:
- fannie/install/updates/20120706115700.php
