Issues (1092)

Setup/Tables/Transactionstatus.php (1 issue)

Labels
Severity
1
<?php
2
3
/**
4
 * PAYONE Magento 2 Connector is free software: you can redistribute it and/or modify
5
 * it under the terms of the GNU Lesser General Public License as published by
6
 * the Free Software Foundation, either version 3 of the License, or
7
 * (at your option) any later version.
8
 *
9
 * PAYONE Magento 2 Connector is distributed in the hope that it will be useful,
10
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12
 * GNU Lesser General Public License for more details.
13
 *
14
 * You should have received a copy of the GNU Lesser General Public License
15
 * along with PAYONE Magento 2 Connector. If not, see <http://www.gnu.org/licenses/>.
16
 *
17
 * PHP version 5
18
 *
19
 * @category  Payone
20
 * @package   Payone_Magento2_Plugin
21
 * @author    FATCHIP GmbH <[email protected]>
22
 * @copyright 2003 - 2016 Payone GmbH
23
 * @license   <http://www.gnu.org/licenses/> GNU Lesser General Public License
24
 * @link      http://www.payone.de
25
 */
26
27
namespace Payone\Core\Setup\Tables;
28
29
use Magento\Framework\DB\Ddl\Table;
0 ignored issues
show
The type Magento\Framework\DB\Ddl\Table was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
30
31
/**
32
 * Class defining the data needed to create the payone_protocol_api table
33
 */
34
class Transactionstatus
35
{
36
    const TABLE_PROTOCOL_TRANSACTIONSTATUS = 'payone_protocol_transactionstatus';
37
38
    /**
39
     * Table data needed to create the new table payone_protocol_transactionstatus
40
     *
41
     * @var array
42
     */
43
    protected static $aTableData = [
44
        'title' => self::TABLE_PROTOCOL_TRANSACTIONSTATUS,
45
        'columns' => [
46
            'id' => [
47
                'type' => Table::TYPE_INTEGER,
48
                'length' => null,
49
                'option' => ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true]
50
            ],
51
            'timestamp' => [
52
                'type' => Table::TYPE_TIMESTAMP,
53
                'length' => null,
54
                'option' => ['nullable' => false, 'default' => Table::TIMESTAMP_INIT]
55
            ],
56
            'order_id' => [
57
                'type' => Table::TYPE_TEXT,
58
                'length' => 50,
59
                'option' => ['unsigned' => true, 'nullable' => false]
60
            ],
61
            'store_id' => [
62
                'type' => Table::TYPE_SMALLINT,
63
                'length' => null,
64
                'option' => ['unsigned' => true, 'nullable' => false]
65
            ],
66
            'reference' => ['type' => Table::TYPE_TEXT, 'length' => 20, 'option' => []],
67
            'txid' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
68
            'txaction' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
69
            'sequencenumber' => [
70
                'type' => Table::TYPE_SMALLINT,
71
                'length' => null,
72
                'option' => ['unsigned' => true, 'nullable' => false]
73
            ],
74
            'clearingtype' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
75
            'txtime' => [
76
                'type' => Table::TYPE_TIMESTAMP,
77
                'length' => null,
78
                'option' => ['nullable' => false]
79
            ],
80
            'price' => [
81
                'type' => Table::TYPE_DECIMAL,
82
                'length' => '20,4',
83
                'option' => ['default' => '0']
84
            ],
85
            'balance' => [
86
                'type' => Table::TYPE_DECIMAL,
87
                'length' => '20,4',
88
                'option' => ['default' => '0']
89
            ],
90
            'receivable' => [
91
                'type' => Table::TYPE_DECIMAL,
92
                'length' => '20,4',
93
                'option' => ['default' => '0']
94
            ],
95
            'currency' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
96
            'aid' => [
97
                'type' => Table::TYPE_SMALLINT,
98
                'length' => null,
99
                'option' => ['unsigned' => true, 'nullable' => false]
100
            ],
101
            'portalid' => [
102
                'type' => Table::TYPE_SMALLINT,
103
                'length' => null,
104
                'option' => ['unsigned' => true, 'nullable' => false]
105
            ],
106
            'key' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
107
            'mode' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
108
            'userid' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
109
            'customerid' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
110
            'company' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
111
            'firstname' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
112
            'lastname' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
113
            'street' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
114
            'zip' => ['type' => Table::TYPE_TEXT, 'length' => 16, 'option' => []],
115
            'city' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
116
            'email' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
117
            'country' => ['type' => Table::TYPE_TEXT, 'length' => 8, 'option' => []],
118
            'shipping_company' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
119
            'shipping_firstname' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
120
            'shipping_lastname' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
121
            'shipping_street' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
122
            'shipping_zip' => ['type' => Table::TYPE_TEXT, 'length' => 16, 'option' => []],
123
            'shipping_city' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
124
            'shipping_country' => ['type' => Table::TYPE_TEXT, 'length' => 8, 'option' => []],
125
            'param' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
126
            'accessname' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
127
            'accesscode' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
128
            'bankcountry' => ['type' => Table::TYPE_TEXT, 'length' => 8, 'option' => []],
129
            'bankaccount' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
130
            'bankcode' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
131
            'bankaccountholder' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
132
            'cardexpiredate' => ['type' => Table::TYPE_TEXT, 'length' => 8, 'option' => []],
133
            'cardtype' => ['type' => Table::TYPE_TEXT, 'length' => 8, 'option' => []],
134
            'cardpan' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
135
            'clearing_bankaccountholder' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
136
            'clearing_bankaccount' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
137
            'clearing_bankcode' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
138
            'clearing_bankname' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
139
            'clearing_bankbic' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
140
            'clearing_bankiban' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
141
            'clearing_bankcountry' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
142
            'clearing_bankcity' => ['type' => Table::TYPE_TEXT, 'length' => 64, 'option' => []],
143
            'clearing_legalnote' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
144
            'clearing_duedate' => ['type' => Table::TYPE_TEXT, 'length' => 32, 'option' => []],
145
            'clearing_reference' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
146
            'clearing_instructionnote' => ['type' => Table::TYPE_TEXT, 'length' => 255, 'option' => []],
147
            'raw_status' => ['type' => Table::TYPE_TEXT, 'length' => null, 'option' => []],
148
        ],
149
        'comment' => 'Log every TransactionStatus from Payone',
150
        'indexes' => ['order_id', 'store_id']
151
    ];
152
153
    /**
154
     * Return the table data needed to create this table
155
     *
156
     * @return array
157
     */
158
    public static function getData()
159
    {
160
        return self::$aTableData;
161
    }
162
}
163