migrations/Version20220822070538.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20220822070538 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql('ALTER TABLE price_map ADD is_visible_in_web_constructor TINYINT(1) NOT NULL');
  23. //        /**
  24. //         * white-matte-plastic
  25. //         */
  26. //        $this->addSql("
  27. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  28. //                            SELECT
  29. //                                   'price_map.pop-white-matte-plastic',
  30. //                                   price_map.pouch_options,
  31. //                                   price_map.sustainable,
  32. //                                   UUID(),
  33. //                                   technology.id,
  34. //                                   varnish.id,
  35. //                                   material.id,
  36. //                                   price_map.structure_thickness,
  37. //                                   1
  38. //                            FROM price_map
  39. //                            INNER JOIN technology
  40. //                                ON technology.code = 'technologies.screen_printing'
  41. //                            INNER JOIN varnish
  42. //                                ON varnish.code = 'finishing.holography'
  43. //                            INNER JOIN material
  44. //                                ON material.code = 'material.white_matte_plastic'
  45. //                            WHERE price_map.code = 'price_map.white-matte-plastic'
  46. //                                    ");
  47. //        $this->addSql("
  48. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  49. //                            SELECT
  50. //                                   'unit.pcs',
  51. //                                   pop_web.id,
  52. //                                   price_list.grams,
  53. //                                   price_list.height,
  54. //                                   price_list.width,
  55. //                                   price_list.depth,
  56. //                                   price_list.min_quantity,
  57. //                                   price_list.max_quantity,
  58. //                                   price_list.price_per_unit,
  59. //                                   package_size.id,
  60. //                                   UUID()
  61. //                            FROM price_list
  62. //                            INNER JOIN price_map AS printella
  63. //                                  ON printella.code = 'price_map.white-matte-plastic'
  64. //                            INNER JOIN price_map AS pop_web
  65. //                                  ON pop_web.code = 'price_map.pop-white-matte-plastic'
  66. //                            INNER JOIN package_size
  67. //                                  ON package_size.grams = price_list.grams
  68. //                            WHERE price_list.price_map_id = printella.id
  69. //                                    ");
  70. //
  71. //        /**
  72. //         * white-kraft-paper
  73. //         */
  74. //        $this->addSql("
  75. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  76. //                            SELECT
  77. //                                   'price_map.pop-white-kraft-paper',
  78. //                                   price_map.pouch_options,
  79. //                                   price_map.sustainable,
  80. //                                   UUID(),
  81. //                                   technology.id,
  82. //                                   varnish.id,
  83. //                                   material.id,
  84. //                                   price_map.structure_thickness,
  85. //                                   1
  86. //                            FROM price_map
  87. //                            INNER JOIN technology
  88. //                                ON technology.code = 'technologies.screen_printing'
  89. //                            INNER JOIN varnish
  90. //                                ON varnish.code = 'finishing.holography'
  91. //                            INNER JOIN material
  92. //                                ON material.code = 'material.white_kraft_paper'
  93. //                            WHERE price_map.code = 'price_map.white-kraft-paper'
  94. //                                    ");
  95. //        $this->addSql("
  96. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  97. //                            SELECT
  98. //                                   'unit.pcs',
  99. //                                   pop_web.id,
  100. //                                   price_list.grams,
  101. //                                   price_list.height,
  102. //                                   price_list.width,
  103. //                                   price_list.depth,
  104. //                                   price_list.min_quantity,
  105. //                                   price_list.max_quantity,
  106. //                                   price_list.price_per_unit,
  107. //                                   package_size.id,
  108. //                                   UUID()
  109. //                            FROM price_list
  110. //                            INNER JOIN price_map AS printela
  111. //                                  ON printela.code = 'price_map.white-kraft-paper'
  112. //                            INNER JOIN price_map AS pop_web
  113. //                                  ON pop_web.code = 'price_map.pop-white-kraft-paper'
  114. //                            INNER JOIN package_size
  115. //                                  ON package_size.grams = price_list.grams
  116. //                            WHERE price_list.price_map_id = printela.id
  117. //                                    ");
  118. //
  119. //        /**
  120. //         * transparent-plastic
  121. //         */
  122. //        $this->addSql("
  123. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  124. //                            SELECT
  125. //                                   'price_map.pop-transparent-plastic',
  126. //                                   price_map.pouch_options,
  127. //                                   price_map.sustainable,
  128. //                                   UUID(),
  129. //                                   technology.id,
  130. //                                   varnish.id,
  131. //                                   material.id,
  132. //                                   price_map.structure_thickness,
  133. //                                   1
  134. //                            FROM price_map
  135. //                            INNER JOIN technology
  136. //                                ON technology.code = 'technologies.screen_printing'
  137. //                            INNER JOIN varnish
  138. //                                ON varnish.code = 'finishing.holography'
  139. //                            INNER JOIN material
  140. //                                ON material.code = 'material.transparent_plastic'
  141. //                            WHERE price_map.code = 'price_map.transparent-plastic'
  142. //                                    ");
  143. //        $this->addSql("
  144. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  145. //                            SELECT
  146. //                                   'unit.pcs',
  147. //                                   pop_web.id,
  148. //                                   price_list.grams,
  149. //                                   price_list.height,
  150. //                                   price_list.width,
  151. //                                   price_list.depth,
  152. //                                   price_list.min_quantity,
  153. //                                   price_list.max_quantity,
  154. //                                   price_list.price_per_unit,
  155. //                                   package_size.id,
  156. //                                   UUID()
  157. //                            FROM price_list
  158. //                            INNER JOIN price_map AS printela
  159. //                                  ON printela.code = 'price_map.transparent-plastic'
  160. //                            INNER JOIN price_map AS pop_web
  161. //                                  ON pop_web.code = 'price_map.pop-transparent-plastic'
  162. //                            INNER JOIN package_size
  163. //                                  ON package_size.grams = price_list.grams
  164. //                            WHERE price_list.price_map_id = printela.id
  165. //                                    ");
  166. //
  167. //        /**
  168. //         * Recyclable PE pouch
  169. //         */
  170. //        $this->addSql("
  171. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  172. //                            SELECT
  173. //                                   'price_map.pop-recyclable-pe-pouch',
  174. //                                   price_map.pouch_options,
  175. //                                   price_map.sustainable,
  176. //                                   UUID(),
  177. //                                   technology.id,
  178. //                                   varnish.id,
  179. //                                   material.id,
  180. //                                   price_map.structure_thickness,
  181. //                                   1
  182. //                            FROM price_map
  183. //                            INNER JOIN technology
  184. //                                ON technology.code = 'technologies.screen_printing'
  185. //                            INNER JOIN varnish
  186. //                                ON varnish.code = 'finishing.holography'
  187. //                            INNER JOIN material
  188. //                                ON material.code = 'material.recyclable_pe_pouch'
  189. //                            WHERE price_map.code = 'price_map.recyclable-pe-pouch'
  190. //                                    ");
  191. //        $this->addSql("
  192. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  193. //                            SELECT
  194. //                                   'unit.pcs',
  195. //                                   pop_web.id,
  196. //                                   price_list.grams,
  197. //                                   price_list.height,
  198. //                                   price_list.width,
  199. //                                   price_list.depth,
  200. //                                   price_list.min_quantity,
  201. //                                   price_list.max_quantity,
  202. //                                   price_list.price_per_unit,
  203. //                                   package_size.id,
  204. //                                   UUID()
  205. //                            FROM price_list
  206. //                            INNER JOIN price_map AS printela
  207. //                                  ON printela.code = 'price_map.recyclable-pe-pouch'
  208. //                            INNER JOIN price_map AS pop_web
  209. //                                  ON pop_web.code = 'price_map.pop-recyclable-pe-pouch'
  210. //                            INNER JOIN package_size
  211. //                                  ON package_size.grams = price_list.grams
  212. //                            WHERE price_list.price_map_id = printela.id
  213. //                                    ");
  214. //
  215. //        /**
  216. //         * metallic-gloss-plastic
  217. //         */
  218. //        $this->addSql("
  219. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  220. //                            SELECT
  221. //                                   'price_map.pop-metallic-gloss-plastic',
  222. //                                   price_map.pouch_options,
  223. //                                   price_map.sustainable,
  224. //                                   UUID(),
  225. //                                   technology.id,
  226. //                                   varnish.id,
  227. //                                   material.id,
  228. //                                   price_map.structure_thickness,
  229. //                                   1
  230. //                            FROM price_map
  231. //                            INNER JOIN technology
  232. //                                ON technology.code = 'technologies.screen_printing'
  233. //                            INNER JOIN varnish
  234. //                                ON varnish.code = 'finishing.holography'
  235. //                            INNER JOIN material
  236. //                                ON material.code = 'material.metallic_gloss_plastic'
  237. //                            WHERE price_map.code = 'price_map.metallic-gloss-plastic'
  238. //                                    ");
  239. //        $this->addSql("
  240. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  241. //                            SELECT
  242. //                                   'unit.pcs',
  243. //                                   pop_web.id,
  244. //                                   price_list.grams,
  245. //                                   price_list.height,
  246. //                                   price_list.width,
  247. //                                   price_list.depth,
  248. //                                   price_list.min_quantity,
  249. //                                   price_list.max_quantity,
  250. //                                   price_list.price_per_unit,
  251. //                                   package_size.id,
  252. //                                   UUID()
  253. //                            FROM price_list
  254. //                            INNER JOIN price_map AS printela
  255. //                                  ON printela.code = 'price_map.metallic-gloss-plastic'
  256. //                            INNER JOIN price_map AS pop_web
  257. //                                  ON pop_web.code = 'price_map.pop-metallic-gloss-plastic'
  258. //                            INNER JOIN package_size
  259. //                                  ON package_size.grams = price_list.grams
  260. //                            WHERE price_list.price_map_id = printela.id
  261. //                                    ");
  262. //
  263. //        /**
  264. //         * metallic-matte-plastic
  265. //         */
  266. //        $this->addSql("
  267. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  268. //                            SELECT
  269. //                                   'price_map.pop-metallic-matte-plastic',
  270. //                                   price_map.pouch_options,
  271. //                                   price_map.sustainable,
  272. //                                   UUID(),
  273. //                                   technology.id,
  274. //                                   varnish.id,
  275. //                                   material.id,
  276. //                                   price_map.structure_thickness,
  277. //                                   1
  278. //                            FROM price_map
  279. //                            INNER JOIN technology
  280. //                                ON technology.code = 'technologies.screen_printing'
  281. //                            INNER JOIN varnish
  282. //                                ON varnish.code = 'finishing.holography'
  283. //                            INNER JOIN material
  284. //                                ON material.code = 'material.metallic_matte_plastic'
  285. //                            WHERE price_map.code = 'price_map.metallic-matte-plastic'
  286. //                                    ");
  287. //        $this->addSql("
  288. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  289. //                            SELECT
  290. //                                   'unit.pcs',
  291. //                                   pop_web.id,
  292. //                                   price_list.grams,
  293. //                                   price_list.height,
  294. //                                   price_list.width,
  295. //                                   price_list.depth,
  296. //                                   price_list.min_quantity,
  297. //                                   price_list.max_quantity,
  298. //                                   price_list.price_per_unit,
  299. //                                   package_size.id,
  300. //                                   UUID()
  301. //                            FROM price_list
  302. //                            INNER JOIN price_map AS printela
  303. //                                  ON printela.code = 'price_map.metallic-matte-plastic'
  304. //                            INNER JOIN price_map AS pop_web
  305. //                                  ON pop_web.code = 'price_map.pop-metallic-matte-plastic'
  306. //                            INNER JOIN package_size
  307. //                                  ON package_size.grams = price_list.grams
  308. //                            WHERE price_list.price_map_id = printela.id
  309. //                                    ");
  310. //
  311. //        /**
  312. //         * white-gloss-plastic
  313. //         */
  314. //        $this->addSql("
  315. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  316. //                            SELECT
  317. //                                   'price_map.pop-white-gloss-plastic',
  318. //                                   price_map.pouch_options,
  319. //                                   price_map.sustainable,
  320. //                                   UUID(),
  321. //                                   technology.id,
  322. //                                   varnish.id,
  323. //                                   material.id,
  324. //                                   price_map.structure_thickness,
  325. //                                   1
  326. //                            FROM price_map
  327. //                            INNER JOIN technology
  328. //                                ON technology.code = 'technologies.screen_printing'
  329. //                            INNER JOIN varnish
  330. //                                ON varnish.code = 'finishing.holography'
  331. //                            INNER JOIN material
  332. //                                ON material.code = 'material.white_gloss_plastic'
  333. //                            WHERE price_map.code = 'price_map.white-gloss-plastic'
  334. //                                    ");
  335. //        $this->addSql("
  336. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  337. //                            SELECT
  338. //                                   'unit.pcs',
  339. //                                   pop_web.id,
  340. //                                   price_list.grams,
  341. //                                   price_list.height,
  342. //                                   price_list.width,
  343. //                                   price_list.depth,
  344. //                                   price_list.min_quantity,
  345. //                                   price_list.max_quantity,
  346. //                                   price_list.price_per_unit,
  347. //                                   package_size.id,
  348. //                                   UUID()
  349. //                            FROM price_list
  350. //                            INNER JOIN price_map AS printela
  351. //                                  ON printela.code = 'price_map.white-gloss-plastic'
  352. //                            INNER JOIN price_map AS pop_web
  353. //                                  ON pop_web.code = 'price_map.pop-white-gloss-plastic'
  354. //                            INNER JOIN package_size
  355. //                                  ON package_size.grams = price_list.grams
  356. //                            WHERE price_list.price_map_id = printela.id
  357. //                                    ");
  358. //
  359. //        /**
  360. //         * brown-kraft-paper
  361. //         */
  362. //        $this->addSql("
  363. //                        INSERT INTO price_map(code, pouch_options, sustainable, uuid, technology_id, varnish_id, material_id, structure_thickness, is_visible_in_web_constructor)
  364. //                            SELECT
  365. //                                   'price_map.pop-brown-kraft-paper',
  366. //                                   price_map.pouch_options,
  367. //                                   price_map.sustainable,
  368. //                                   UUID(),
  369. //                                   technology.id,
  370. //                                   varnish.id,
  371. //                                   material.id,
  372. //                                   price_map.structure_thickness,
  373. //                                   1
  374. //                            FROM price_map
  375. //                            INNER JOIN technology
  376. //                                ON technology.code = 'technologies.screen_printing'
  377. //                            INNER JOIN varnish
  378. //                                ON varnish.code = 'finishing.holography'
  379. //                            INNER JOIN material
  380. //                                ON material.code = 'material.brown_kraft_paper'
  381. //                            WHERE price_map.code = 'price_map.brown-kraft-paper'
  382. //                                    ");
  383. //        $this->addSql("
  384. //                        INSERT INTO price_list(units, price_map_id, grams, height, width, depth, min_quantity, max_quantity, price_per_unit, package_size_id, uuid)
  385. //                            SELECT
  386. //                                   'unit.pcs',
  387. //                                   pop_web.id,
  388. //                                   price_list.grams,
  389. //                                   price_list.height,
  390. //                                   price_list.width,
  391. //                                   price_list.depth,
  392. //                                   price_list.min_quantity,
  393. //                                   price_list.max_quantity,
  394. //                                   price_list.price_per_unit,
  395. //                                   package_size.id,
  396. //                                   UUID()
  397. //                            FROM price_list
  398. //                            INNER JOIN price_map AS printela
  399. //                                  ON printela.code = 'price_map.brown-kraft-paper'
  400. //                            INNER JOIN price_map AS pop_web
  401. //                                  ON pop_web.code = 'price_map.pop-brown-kraft-paper'
  402. //                            INNER JOIN package_size
  403. //                                  ON package_size.grams = price_list.grams
  404. //                            WHERE price_list.price_map_id = printela.id
  405. //                                    ");
  406.     }
  408.     public function down(Schema $schema): void
  409.     {
  410.         $this->addSql('ALTER TABLE price_map DROP is_visible_in_web_constructor');
  411.     }
  412. }