Changeset 494 for trunk/admin/FullInstall.php

Timestamp:

Mar 1, 2013, 10:44:18 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Přepočítávání stavu placení zákazníků.

File:

• trunk/admin/FullInstall.php (modified) (1 diff)

trunk/admin/FullInstall.php

@@ -2336 +2336 @@
 (40, 'Produkty', 27, 'Product', ''),
 (41, 'Sklady', 27, 'Stock', '');");
+  $Manager->Execute("INSERT INTO `ServiceCategory` (`Id`, `Name`) VALUES
+(1, 'Internet'),
+(2, 'VoIP'),
+(3, 'Spotřeba + nájem'),
+(4, 'IPTV'),
+(5, 'IP kamery'),
+(6, 'Meteostanice'),
+(7, 'Web hosting'),
+(8, 'VPS hosting');");
+  $Manager->Execute("INSERT INTO `Service` (`Id`, `Name`, `Category`, `Price`, `CustomerCount`, `ReplaceId`, `Public`, `InternetSpeedMin`, `InternetSpeedMax`, `UploadAsymmetry`, `Memory`, `MemorySwap`, `Storage`, `CPUCount`) VALUES
+(1, 'Internet 4M', 1, 190, 23, NULL, 1, 4096, 204, 1, 0, 0, 0, 0),
+(2, 'Internet 8M', 1, 260, 23, NULL, 1, 8192, 408, 1, 0, 0, 0, 0),
+(3, 'Internet 16M', 1, 360, 50, NULL, 1, 16384, 816, 1, 0, 0, 0, 0),
+(4, 'Internet 32M', 1, 520, 6, NULL, 1, 32768, 1638, 1, 0, 0, 0, 0),
+(5, 'Internet 64M', 1, 750, 0, NULL, 1, 65536, 8196, 1, 0, 0, 0, 0),
+(6, 'Internet Instituce', 2, 1000, 1, NULL, 1, 65536, 8192, 1, 0, 0, 0, 0),
+(7, 'Zdarma', 3, 0, 12, NULL, 1, 128, 128, 1, 0, 0, 0, 0),
+(8, 'Hosting 4GB', 2, 500, 2, NULL, 1, 64000, 4000, 1, 0, 0, 0, 0),
+(9, 'Hosting 2GB', 2, 300, 0, NULL, 1, 40000, 2000, 1, 0, 0, 0, 0),
+(10, 'Hosting 1GB', 2, 170, 1, NULL, 1, 30000, 2000, 1, 0, 0, 0, 0),
+(11, 'Hosting 512M', 2, 100, 0, NULL, 1, 20000, 1500, 1, 0, 0, 0, 0),
+(12, 'Hosting 8GB', 2, 900, 1, NULL, 1, 60000, 4000, 1, 0, 0, 0, 0),
+(13, 'Hosting 16G', 2, 1500, 0, NULL, 1, 60000, 4000, 1, 0, 0, 0, 0),
+(14, 'Hosting 6GB', 2, 700, 0, NULL, 1, 64000, 4000, 1, 0, 0, 0, 0);");
+  $Manager->Execute("INSERT INTO `ServiceCustomerRel` (`Id`, `Service`, `Customer`, `Period`) VALUES
+(1, 1, 1, 0), (2, 1, 1, 1);");
+  $Manager->Execute("INSERT INTO `File` (`Id` ,`Name` ,`Size` ,`Directory`) VALUES (NULL , 'invoice_1.pdf', '123', NULL);");
+  $Manager->Execute("INSERT INTO `FinanceInvoice` (`Id` ,`BillCode` ,`Subject` ,`TimeCreation` ,`TimeDue` ,`TimePayment` ,`Value` ,`File` ,`Text` ,`PeriodTo` ,`PeriodFrom`) ".
+    "VALUES (1 , 'VF123/2013', '1', NOW( ) , '0000-00-00 00:00:00', NULL , '300', '1', 'Měsíční paušál', '2013-01-01', '2013-01-31');");
+  $Manager->Execute("INSERT INTO `FinanceInvoiceItem` (`Id` ,`FinanceInvoice` ,`Description` ,`Price` ,`VAT` ,`Quantity`) ".
+     "VALUES (1 , '1', 'Internet 16M', '300', '21', '1');");
+  $Manager->Execute("INSERT INTO `FinanceYear` (`Id`, `Year`, `DateStart`, `DateEnd`) VALUES
+(1, 2007, '2007-12-01', '2007-12-31'),
+(2, 2008, '2008-01-01', '2008-12-31'),
+(3, 2009, '2009-01-01', '2009-12-31'),
+(4, 2010, '2010-01-01', '2010-12-31'),
+(6, 2011, '2011-01-01', '2011-12-31'),
+(7, 2012, '2012-01-01', '2012-12-31'),
+(8, 2013, '2013-01-01', '2013-12-31');");
+  $Manager->Execute("INSERT INTO `FinanceCharge` (`Period`, `Internet`, `InternetSpeed`, `InternetSpeedReserve`, `AdministrationPerUser`, `kWh`, `BaseSpeedElement`, `BaseTariffPrice`, `TopTariffPrice`) VALUES
+(1, 10000, 100000, 10000, 50, 6, 1024, 50, 138),
+(0, 10000, 100000, 10000, 50, 6, 1024, 50, 138);");
 }