← Back to branch summary

~vcs-imports/helix/helix

« back to all changes in this revision

Viewing changes to trunk/modules/Commerce/Generated/Objects/Lookups/PaymentmethodTable.php

  • Committer: damianobrien
  • Date: 2015-06-12 05:13:06 UTC
  • Revision ID: svn-v4:05b9009a-c606-4cef-bdc0-1359a4facf5f::417

Show diffs side-by-side

added added

removed removed

Lines of Context:
trunk/modules/Commerce/Generated/Objects/Lookups/PaymentmethodTable.php
76
76
                $object = new Paymentmethod();
77
77
                $object->_snapshot = $date;
78
78
                $db = Database::getInstance();
79
 
                $db->changeDatabase($db->getDatabase() . "_log");
 
79
                $database = $db->getDatabase();
 
80
                $db->changeDatabase($database . "_log");
80
81
 
81
82
                if (isset($id)) {
82
83
                        $condition = "{$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re}={$db->queryValue($id)}";
90
91
                                "WHERE {$condition}"
91
92
                        ));
92
93
 
 
94
                        $query .= "ORDER BY {$db->le}paymentmethod{$db->re}.log_sequence desc limit 1";
93
95
                        $db->query($query);
94
96
 
95
97
                        if ($db->getRecord() && $db->getNumRows()===1) {
108
110
                        }
109
111
                }
110
112
                
 
113
                $db->changeDatabase($database);
111
114
                return $object;
112
115
        }
113
116
 
225
228
 
226
229
        protected function log() {
227
230
                if (isset($this->_snapshot)) {return false;}
 
231
                parent::log();
228
232
                $db = Database::getInstance();
229
233
                $database = $db->getDatabase();
 
234
                $record = Paymentmethod::select($db->encapsulate("paymentmethod") . ".mdate as fdate,null as tdate,{$db->encapsulate("paymentmethod")}.*",null,$db->encapsulate("paymentmethod").".id={$this->id}")->first();
230
235
                $log = "{$database}_log";
231
 
                $db->changeDatabase($log);
 
236
                $dbLog = Database::getInstance(null,null,null,null,$log);
 
237
                foreach($record as $k=>$v){
 
238
                    if(!is_int($v)){
 
239
                        $record[$k] = $dbLog->queryValue($v);
 
240
                    }
 
241
                }
 
242
                $insertColumns = $dbLog->le.implode("{$dbLog->le},{$dbLog->re}",array_keys($record)).$dbLog->re;
 
243
                $insertValues = implode(",",$record);
232
244
                $query = implode(NL, array(
233
 
                        "INSERT INTO {$db->le}{$log}{$db->re}.{$db->le}paymentmethod{$db->re} (",
234
 
                        "SELECT",
235
 
                        "       NULL,",
236
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}mdate{$db->re},",
237
 
                        "       NULL,",
238
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re},",
239
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}name{$db->re},",
240
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}description{$db->re},",
241
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}updated_by_id{$db->re},",
242
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}mdate{$db->re},",
243
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}cdate{$db->re},",
244
 
                        "       {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}deleted{$db->re}",
245
 
                        "FROM {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}",
246
 
                        "WHERE {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re}={$db->queryValue($this->id)}",
 
245
                        "INSERT INTO {$dbLog->le}paymentmethod{$dbLog->re} (",
 
246
                        $insertColumns,
 
247
                        ") VALUES (",
 
248
                        $insertValues,
247
249
                        ")"
248
250
                ));
249
 
                $status = $db->query($query);
250
 
 
251
 
                $logSequence = $db->getInsertedId();
252
 
 
253
 
                $query = implode(NL, array(
254
 
                        "SELECT {$db->le}log_sequence{$db->re}",
255
 
                        "FROM {$db->le}paymentmethod{$db->re}",
256
 
                        "WHERE {$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re}={$db->queryValue($this->id)}",
257
 
                        "       AND {$db->le}log_sequence{$db->re}<'{$logSequence}'",
258
 
                        "ORDER BY {$db->le}log_sequence{$db->re} DESC",
259
 
                        "LIMIT 0,1"
260
 
                ));
261
 
                $db->query($query);
262
 
 
263
 
                if ($db->getRecord()) {
264
 
                        $updateSequence = (int)$db->record["log_sequence"];
 
251
                $status = $dbLog->query($query);
 
252
 
 
253
                $logSequence = $dbLog->getInsertedId();
 
254
 
 
255
                if ($logSequence){
265
256
                        $query = implode(NL, array(
266
 
                                "UPDATE {$db->le}{$log}{$db->re}.{$db->le}paymentmethod{$db->re}",
267
 
                                "INNER JOIN {$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re} ON {$db->le}{$log}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re}={$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}id{$db->re}",
268
 
                                "       AND {$db->le}{$log}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}log_sequence{$db->re}={$db->queryValue($updateSequence)}",
269
 
                                "SET {$db->le}{$log}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}tdate{$db->re}={$db->le}{$database}{$db->re}.{$db->le}paymentmethod{$db->re}.{$db->le}mdate{$db->re}"
 
257
                                "SELECT {$dbLog->le}log_sequence{$dbLog->re}",
 
258
                                "FROM {$dbLog->le}paymentmethod{$dbLog->re}",
 
259
                                "WHERE {$dbLog->le}paymentmethod{$dbLog->re}.{$dbLog->le}id{$dbLog->re}={$this->id}",
 
260
                                "       AND {$dbLog->le}log_sequence{$dbLog->re}<{$logSequence}",
 
261
                                "ORDER BY {$dbLog->le}log_sequence{$dbLog->re} DESC",
 
262
                                $dbLog::limitOffsetString(1,0)
270
263
                        ));
271
 
                        $db->query($query);
 
264
                        $dbLog->query($query);
 
265
 
 
266
                        if ($dbLog->getRecord()) {
 
267
                                $updateSequence = (int)$dbLog->record["log_sequence"];
 
268
                                $query = implode(NL, array(
 
269
                                        "UPDATE {$dbLog->le}paymentmethod{$dbLog->re}",
 
270
                                        "SET {$dbLog->le}tdate{$dbLog->re}={$record["mdate"]}",
 
271
                                        "where log_sequence={$updateSequence}"
 
272
                                ));
 
273
                                $dbLog->query($query);
 
274
                        }
272
275
                }
273
276
                $db->changeDatabase($database);
274
277
                return $status;