migrations/Version20230105114520.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use App\BaseBundle\SystemConfiguration;
  8. use App\CMSBundle\Entity\DynamicPage;
  9. use App\CMSBundle\Entity\SiteSetting;
  10. use App\CMSBundle\Enum\SiteSettingTypeEnum;
  11. use App\ContentBundle\Entity\Post;
  12. use App\OnlinePaymentBundle\Enum\PaymentMethodEnum;
  13. use App\SeoBundle\Entity\Seo;
  14. use Doctrine\DBAL\Schema\Schema;
  15. use Doctrine\Migrations\AbstractMigration;
  16. use PN\SeoBundle\Entity\SeoBaseRoute;
  17. use PN\SeoBundle\Entity\SeoPage;
  18. use Symfony\Component\DependencyInjection\ContainerAwareInterface;
  19. use Symfony\Component\DependencyInjection\ContainerAwareTrait;
  21. /**
  22. * Auto-generated Migration: Please modify to your needs!
  23. */
  24. final class Version20230105114520 extends AbstractMigration implements ContainerAwareInterface
  25. {
  26. use ContainerAwareTrait;
  28. public function getDescription(): string
  29. {
  30. return 'Initial Values for E-Commerce';
  31. }
  33. public function up(Schema $schema): void
  34. {
  35. //LANGUAGE ARABIC
  36. if (SystemConfiguration::ENABLE_ARABIC_LANG) {
  37. $this->addSql("INSERT INTO `language` (`id`, `locale`, `title`, `flag_asset`) VALUES (1, 'ar', 'Arabic', 'admin/images/flags/eg.png')");
  38. }
  41. //PAYMENT METHODS
  42. $this->addSql("INSERT INTO `payment_method` (`title`, `note`, `type`, `active`, `fees`, `deleted`, `deleted_by`, `created`, `creator`, `modified`, `modified_by`) VALUES ('Cash on delivery', NULL, :type, '1', '0', NULL, NULL, NOW(), 'System', NOW(), 'System')",
  43. ["type" => PaymentMethodEnum::CASH_ON_DELIVERY->value]
  44. );
  46. $this->addSql("INSERT INTO `payment_method` (`title`, `note`, `type`, `active`, `fees`, `deleted`, `deleted_by`, `created`, `creator`, `modified`, `modified_by`) VALUES ('Credit Card', NULL, :type, '1', '0', NULL, NULL, NOW(), 'System', NOW(), 'System')",
  47. ["type" => PaymentMethodEnum::CREDIT_CARD->value]
  48. );
  50. // CURRENCIES
  51. $this->addSql("INSERT INTO `currency` (`id`, `code`, `symbol`, `title`, `default`, `deleted`, `deleted_by`, `created`, `creator`, `modified`, `modified_by`) VALUES (1, 'EGP', 'EGP', 'Egyptian Pound', '1', NULL, NULL, NOW(), 'System', NOW(), 'System')");
  52. $this->addSql("INSERT INTO `exchange_rate` (`source_currency_id`, `target_currency_id`, `ratio`, `created`, `creator`, `modified`, `modified_by`) VALUES ( 1, 1, 1, NOW(), 'System', NOW(), 'System');");
  54. //IMAGE TYPE
  55. $this->addSql("INSERT INTO `image_type` (`id`, `name`) VALUES (1, 'Main Image')");
  56. $this->addSql("INSERT INTO `image_type` (`id`, `name`) VALUES (2, 'Gallery')");
  57. $this->addSql("INSERT INTO `image_type` (`id`, `name`) VALUES (3, 'Cover Photo')");
  59. // IMAGE SETTINGS
  60. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (1, 'Product', 'product_edit', 'product/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  61. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1000, 1000, NULL, NULL, 0, 1, 1, 1);");
  62. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (0, 1000, 1000, NULL, NULL, 0, 1, 2, 1);");
  64. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (2, 'Blog', 'blog_edit', 'blog/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  65. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1000, 1000, NULL, NULL, 0, 1, 1, 2);");
  66. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1400, 500, NULL, NULL, 0, 1, 3, 2);");
  68. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (3, 'DynamicPage', 'dynamic_page_edit', 'dynamic-page/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  70. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (4, 'Category', 'category_edit', 'category/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  71. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1920, 300, NULL, NULL, 0, 1, 3, 4);");
  73. if (SystemConfiguration::ENABLE_COLLECTION) {
  74. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (5, 'Collection', 'collection_edit', 'collection/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  75. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1000, 1000, NULL, NULL, 0, 1, 1, 5);");
  76. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1920, 300, NULL, NULL, 0, 1, 3, 5);");
  77. }
  78. if (SystemConfiguration::ENABLE_OCCASION) {
  79. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (6, 'Occasion', 'occasion_edit', 'occasion/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  80. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1920, 300, NULL, NULL, 0, 1, 3, 6);");
  81. }
  83. $this->addSql("INSERT INTO image_setting (id, entity_name, back_route, upload_path, auto_resize, quality, gallery, created, creator, modified, modified_by) VALUES (7, 'Project', 'project_edit', 'project/', 1, 1, 0, NOW(), 'System', NOW(), 'System');");
  84. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (1, 1000, 1000, NULL, NULL, 0, 1, 1, 7);");
  85. $this->addSql("INSERT INTO image_setting_has_type (radio_button, width, height, thumb_width, thumb_height, validate_width_and_height, validate_size, image_type_id, image_setting_id) VALUES (0, 1000, 1000, NULL, NULL, 0, 1, 2, 7);");
  87. // DYNAMIC CONTENT
  88. $this->addSql("INSERT INTO `dynamic_content` (`id`, `title`) VALUES (1, 'General Info')");
  89. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (1, 1, 'Email', 'info@ecommerce.com', 1, NULL, NULL, NULL);");
  90. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (2, 1, 'Address', 'Address, ALexandria', 2, NULL, NULL, NULL);");
  91. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (3, 1, 'Facebook Page Link', 'http://facebook.com', 3, NULL, NULL, NULL);");
  92. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (4, 1, 'Instagram Page Link', 'http://Instagram.com', 3, NULL, NULL, NULL);");
  93. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (5, 1, 'Twitter Page Link', 'http://Twitter.com', 3, NULL, NULL, NULL);");
  94. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (6, 1, 'Linkedin Page Link', 'http://Linkedin.com', 3, NULL, NULL, NULL);");
  95. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (7, 1, 'Youtube Channel Link', 'http://Youtube.com', 3, NULL, NULL, NULL);");
  96. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (8, 1, 'Header Image', NULL, 4, '1920px * 350px', 1920, 350);");
  97. $this->addSql("INSERT INTO `dynamic_content_attribute` (`id`, `dynamic_content_id`, `title`, `value`, `type`, `hint`, `image_width`, `image_height`) VALUES (9, 1, 'Login page image aside', NULL, 4, '780px * 1000px', 780, 1000)");
  100. //SITE SETTINGS
  101. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Head Tags', :type, '0', '', 'System', NOW(), NOW(), 'System')",
  102. ["constant_name" => SiteSetting::WEBSITE_HEAD_TAGS, "type" => SiteSettingTypeEnum::HTML_TAG->value]
  103. );
  104. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Google Tag Manager Id', :type, '0', '', 'System', NOW(), NOW(), 'System')",
  105. ["constant_name" => SiteSetting::GOOGLE_TAG_MANAGER_ID, "type" => SiteSettingTypeEnum::TEXT->value]
  106. );
  107. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Facebook Chat Page Id', :type, '0', '', 'System', NOW(), NOW(), 'System')",
  108. ["constant_name" => SiteSetting::FACEBOOK_CHAT_PAGE_ID, "type" => SiteSettingTypeEnum::TEXT->value]
  109. );
  110. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Facebook Pixel Id', :type, '0', '', 'System', NOW(), NOW(), 'System')",
  111. ["constant_name" => SiteSetting::FACEBOOK_PIXEL_ID, "type" => SiteSettingTypeEnum::TEXT->value]
  112. );
  113. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Primary Color', :type, '1', '#79BBC3', 'System', NOW(), NOW(), 'System')",
  114. ["constant_name" => "website-primary-color", "type" => SiteSettingTypeEnum::COLOR_CODE->value]
  115. );
  116. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Header Color', :type, '1', '#79BBC3', 'System', NOW(), NOW(), 'System')",
  117. ["constant_name" => "website-header-color", "type" => SiteSettingTypeEnum::COLOR_CODE->value]
  118. );
  119. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Header Text Color', :type, '1', '#3f3f3f', 'System', NOW(), NOW(), 'System')",
  120. ["constant_name" => "website-header-text-color", "type" => SiteSettingTypeEnum::COLOR_CODE->value]
  121. );
  122. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Footer Color', :type, '1', '#79BBC3', 'System', NOW(), NOW(), 'System')",
  123. ["constant_name" => "website-footer-color", "type" => SiteSettingTypeEnum::COLOR_CODE->value]
  124. );
  125. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Footer Text Color', :type, '1', '#686868', 'System', NOW(), NOW(), 'System')",
  126. ["constant_name" => "website-footer-text-color", "type" => SiteSettingTypeEnum::COLOR_CODE->value]
  127. );
  128. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Logo', :type, '1', null, 'System', NOW(), NOW(), 'System')",
  129. ["constant_name" => "website-logo", "type" => SiteSettingTypeEnum::SVG_CODE->value]
  130. );
  131. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Mailchimp List ID', :type, '1', '', 'System', NOW(), NOW(), 'System')",
  132. ["constant_name" => "mailchimp-list-id", "type" => SiteSettingTypeEnum::TEXT->value]
  133. );
  134. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Mailchimp API Key', :type, '1', '', 'System', NOW(), NOW(), 'System')",
  135. ["constant_name" => "mailchimp-api-key", "type" => SiteSettingTypeEnum::TEXT->value]
  136. );
  137. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Contact us map coordinate', :type, '1', '30.0690556, 31.219615', 'System', NOW(), NOW(), 'System')",
  138. ["constant_name" => "contact-us-map-coordinate", "type" => SiteSettingTypeEnum::TEXT->value]
  139. );
  140. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Google map API Key', :type, '1', 'AIzaSyD6Xwank3PinQcm0dxXUTAzvn15cdD9Y84', 'System', NOW(), NOW(), 'System')",
  141. ["constant_name" => "google-map-api-key", "type" => SiteSettingTypeEnum::TEXT->value]
  142. );
  143. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Website Title', :type, '1', 'E-Commerce', 'System', NOW(), NOW(), 'System')",
  144. ["constant_name" => "website-title", "type" => SiteSettingTypeEnum::TEXT->value]
  145. );
  146. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Send Emails from', :type, '1', 'no-reply@e-commerce.com', 'System', NOW(), NOW(), 'System')",
  147. ["constant_name" => "email-from", "type" => SiteSettingTypeEnum::EMAIL->value]
  148. );
  150. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Admin Email', :type, '0', 'info@e-commerce.com', 'System', NOW(), NOW(), 'System')",
  151. ["constant_name" => "admin-email", "type" => SiteSettingTypeEnum::EMAIL->value]
  152. );
  154. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Facebook Conversion API - Access token', :type, '0', NULL, 'System', NOW(), NOW(), 'System')",
  155. ["constant_name" => "facebook-conversion-api-access-token", "type" => SiteSettingTypeEnum::TEXT->value]
  156. );
  157. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Facebook Conversion API - Pixel ID', :type, '0', NULL, 'System', NOW(), NOW(), 'System')",
  158. ["constant_name" => "facebook-conversion-api-pixel-id", "type" => SiteSettingTypeEnum::TEXT->value]
  159. );
  160. $this->addSql("INSERT INTO site_setting (`constant_name`, `title`, `type`, `manage_by_super_admin_only`, `value`, `creator`, `created`, `modified`, `modified_by`) VALUES (:constant_name, 'Facebook Conversion API - Test Event Code', :type, '1', NULL, 'System', NOW(), NOW(), 'System')",
  161. ["constant_name" => "facebook-conversion-api-test-event-code", "type" => SiteSettingTypeEnum::TEXT->value]
  162. );
  163. }
  165. public function postUp(Schema $schema): void
  166. {
  167. //SEO BASE ROUTES
  168. $this->newSeoBaseRoute(SeoPage::class, "seo_page");
  169. $this->newSeoBaseRoute(DynamicPage::class, "page");
  171. // SEO
  172. $this->newSeo('Home Page', 'Home Page', 'home-page', 'home-page');
  173. $this->newSeo('On Sale', 'On Sale', 'sale', 'sale');
  174. $this->newSeo('Products', 'Products', 'products', 'products');
  175. $this->newSeo('Categories List Page', 'Categories', 'categories', 'categories');
  176. if (SystemConfiguration::ENABLE_COLLECTION) {
  177. $this->newSeo('Collections List Page', 'Collections', 'collections', 'collections');
  178. }
  179. if (SystemConfiguration::ENABLE_OCCASION) {
  180. $this->newSeo('Occasions List Page', 'Occasions', 'occasions', 'occasions');
  181. }
  182. $this->newSeo('Blogs List Page', 'Blogs', 'blogs', 'blogs');
  183. $this->newSeo('FAQs Page', 'FAQs', 'faq', 'faq');
  184. $this->newSeo('Projects List Page', 'Projects', 'projects', 'project');
  185. $this->newSeo('Contact Us Page', 'Contact Us', 'contact-us', 'contact-us');
  187. $this->createDynamicPage("Terms and Conditions", "Terms and Conditions", "terms-and-conditions");
  188. }
  190. private function newSeoBaseRoute(string $entityName, $baseRoute): void
  191. {
  192. $em = $this->container->get('doctrine.orm.entity_manager');
  194. $seoBaseRoute = new SeoBaseRoute();
  195. $seoBaseRoute->setEntityName($entityName);
  196. $seoBaseRoute->setBaseRoute($baseRoute);
  197. $seoBaseRoute->setCreated(new \DateTime());
  198. $seoBaseRoute->setCreator("System");
  199. $seoBaseRoute->setModified(new \DateTime());
  200. $seoBaseRoute->setModifiedBy("System");
  202. $em->persist($seoBaseRoute);
  203. $em->flush();
  204. }
  206. private function newSeo($seoPageTitle, $seoTitle, $seoPageType, $seoSlug): void
  207. {
  208. //getting entity manager
  209. $em = $this->container->get('doctrine.orm.entity_manager');
  211. $seoPage = new SeoPage();
  212. $seoPage->setTitle($seoPageTitle);
  213. $seoPage->setType($seoPageType);
  214. $seoPage->setCreated(new \DateTime());
  215. $seoPage->setCreator('System');
  216. $seoPage->setModified(new \DateTime());
  217. $seoPage->setModifiedBy('System');
  219. $seo = new Seo();
  220. $seo->setSeoBaseRoute($em->getRepository(SeoBaseRoute::class)->findByEntity($seoPage));
  221. $seo->setTitle($seoTitle);
  222. $seo->setSlug($seoSlug);
  223. $seo->setState(1);
  224. $seo->setLastModified(new \DateTime());
  226. $seoPage->setSeo($seo);
  228. $em->persist($seoPage);
  229. $em->persist($seo);
  231. $em->flush();
  232. }
  234. private function createDynamicPage($dynamicPageTitle, $seoTitle, $seoSlug): void
  235. {
  236. //getting entity manager
  237. $em = $this->container->get('doctrine.orm.entity_manager');
  239. //setting seo pages values
  240. $dynamicPage = new DynamicPage();
  241. $dynamicPage->setTitle($dynamicPageTitle);
  242. $dynamicPage->setCreated(new \DateTime());
  243. $dynamicPage->setCreator('System');
  244. $dynamicPage->setModified(new \DateTime());
  245. $dynamicPage->setModifiedBy('System');
  247. $post = new Post();
  248. $post->setContent(["description"=>"", "brief"=>""]);
  249. $dynamicPage->setPost($post);
  251. $seo = new Seo();
  252. $seo->setSeoBaseRoute($em->getRepository(SeoBaseRoute::class)->findByEntity($dynamicPage));
  253. $seo->setTitle($seoTitle);
  254. $seo->setSlug($seoSlug);
  255. $seo->setState(1);
  256. $seo->setLastModified(new \DateTime());
  258. $dynamicPage->setSeo($seo);
  260. $em->persist($dynamicPage);
  261. $em->flush();
  262. }
  264. public function down(Schema $schema): void
  265. {
  266. // this down() migration is auto-generated, please modify it to your needs
  268. }
  269. }