Odyssey
2018092500_addEsCustomContent.php
1 <?php
2 /**
3  * Notes:
4  * 1. Anything complicated needs to be done with SQL.
5  * 2. Always have a check to know if the migration needs to occur (up or down).
6  * 3. Use up() and down(), not change(), because of the SQL
7  */
8 use Phinx\Migration\AbstractMigration;
9 
10 class addEsCustomContent extends AbstractMigration {
11  public function up() {
12 
13  $table = "cucmsdocs";
14  if ($this->hasTable($table)) {
15 
16  $index = 67;
17  $esText = "eStatements";
18  $doctype = 4;
19  $pdfdefDesc = "Definition of the PDF";
20  $cfgDesc = "Client specific STATEMENTs configuration file.";
21  $extraDesc = "Additional functions to run on load.";
22  $readmeDesc = "Readme.";
23  $disclaimerDesc = "Disclaimer.";
24 
25  $vendor = "AMI";
26  $sort = 1;
27  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
28  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
29  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
30  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
31  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
32  $this->query($sql);
33 
34  $vendor = "AMIS";
35  $sort = 1;
36  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
37  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
38  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
39  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
40  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
41  $this->query($sql);
42 
43  $vendor = "CompuSource";
44  $sort = 1;
45  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
46  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
47  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
48  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
49  (" . $index++ . ", 'stmntloadextra.pi', 'Custom STATEMENTs extra routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
50  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
51  $this->query($sql);
52 
53  $vendor = "CORELATION_PDF";
54  $sort = 1;
55  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
56  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
57  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
58  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
59  $this->query($sql);
60 
61 
62  $vendor = "CORELATION_XML";
63  $sort = 1;
64  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
65  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
66  (" . $index++ . ", 'readme', '$readmeDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
67  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
68  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
69  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
70  $this->query($sql);
71 
72  // TODO: Also include statement_logo.jpg and statement_logo2.jpg
73  $vendor = "CRUISE";
74  $sort = 1;
75  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
76  values (" . $index++ . ", 'disclaimer', '$disclaimerDesc', $doctype, '$vendor', 'Extra', " . $sort++ . "),
77  (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
78  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
79  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
80  (" . $index++ . ", 'stmntloadextra.pi', 'Custom STATEMENTs extra routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
81  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
82  $this->query($sql);
83 
84  $vendor = "CRUISE_PDF";
85  $sort = 1;
86  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
87  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
88  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
89  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', '$doctype', '$vendor', '$esText', " . $sort++ . ")";
90  $this->query($sql);
91 
92 
93  $vendor = "CU-CENTRIC_PDF";
94  $sort = 1;
95  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
96  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
97  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
98  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
99  $this->query($sql);
100 
101  $vendor = "CUC";
102  $sort = 1;
103  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
104  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
105  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
106  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
107  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
108  $this->query($sql);
109 
110  $vendor = "CUPRODIGY";
111  $sort = 1;
112  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
113  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . ")";
114  $this->query($sql);
115 
116  // TODO: images
117  $vendor = "CUSA";
118  $sort = 1;
119  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
120  values (" . $index++ . ", 'disclaimer', '$disclaimerDesc', $doctype, '$vendor', 'Extra', " . $sort++ . "),
121  (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
122  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
123  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
124  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
125  $this->query($sql);
126 
127  $vendor = "CUSA-PDF";
128  $sort = 1;
129  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
130  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
131  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
132  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
133  $this->query($sql);
134 
135  $vendor = "EPL";
136  $sort = 1;
137  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
138  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
139  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
140  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
141  (" . $index++ . ", 'stmntloadextra.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
142  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
143  $this->query($sql);
144 
145  $vendor = "ESP_PDF";
146  $sort = 1;
147  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
148  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
149  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
150  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
151  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
152  $this->query($sql);
153 
154  $vendor = "FedComp";
155  $sort = 1;
156  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
157  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
158  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
159  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
160  $this->query($sql);
161 
162  $vendor = "FIDELITY";
163  $sort = 1;
164  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
165  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
166  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
167  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
168  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
169  $this->query($sql);
170 
171  $vendor = "FISERV_PORTICO";
172  $sort = 1;
173  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
174  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
175  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
176  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
177  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
178  $this->query($sql);
179 
180  $vendor = "Galaxy";
181  $sort = 1;
182  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
183  values (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
184  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
185  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
186  $this->query($sql);
187 
188  $vendor = "INFOWARE";
189  $sort = 1;
190  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
191  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
192  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
193  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
194  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
195  $this->query($sql);
196 
197  $vendor = "ONCU";
198  $sort = 1;
199  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
200  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
201  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
202  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
203  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
204  $this->query($sql);
205 
206  $vendor = "ShareTec";
207  $sort = 1;
208  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
209  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
210  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
211  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
212  $this->query($sql);
213 
214  $vendor = "SYMITAR";
215  $sort = 1;
216  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
217  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
218  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
219  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
220  (" . $index++ . ", 'stmntloadextra.pi', 'Custom STATEMENTs extra routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
221  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
222  $this->query($sql);
223 
224  $vendor = "SYMITAR_CUSTOM";
225  $sort = 1;
226  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
227  values (" . $index++ . ", 'pdfFBG.pl', 'Additional Processing.', $doctype, '$vendor', '$esText', " . $sort++ . "),
228  (" . $index++ . ", 'stmntFBG.pl', 'Additional Processing.', $doctype, '$vendor', '$esText', " . $sort++ . "),
229  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
230  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
231  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
232  $this->query($sql);
233 
234  $vendor = "TOTAL1";
235  $sort = 1;
236  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
237  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
238  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
239  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
240  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
241  $this->query($sql);
242 
243  $vendor = "ULTRADATA";
244  $sort = 1;
245  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
246  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
247  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
248  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
249  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
250  $this->query($sql);
251 
252  $vendor = "XPSystems";
253  $sort = 1;
254  $sql = "insert into $table (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
255  values (" . $index++ . ", 'pdfdefs', '$pdfdefDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
256  (" . $index++ . ", 'stmntload.cfg', '$cfgDesc', $doctype, '$vendor', '$esText', " . $sort++ . "),
257  (" . $index++ . ", 'stmntload.pi', 'Custom STATEMENTs include routines for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . "),
258  (" . $index++ . ", 'stmntloadprefltr.pl', 'Custom STATEMENTs prefiltering program for $vendor core applications.', $doctype, '$vendor', '$esText', " . $sort++ . ")";
259  $this->query($sql);
260  }
261  }
262 }