Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void Databaza::nacitajDataDoTabulky()
- {
- Book* uchadzaciBook = xlCreateXMLBook();
- Book* mieraBook = xlCreateXMLBook();
- ArrayList<string> nazvyOkresov;
- SortedSequenceTable<string, Okres*>* tabulkaOkresov = new SortedSequenceTable<string, Okres*>();
- if (uchadzaciBook)
- {
- uchadzaciBook->load(L"Data/uchadzaciOZamestnanie.xlsx");
- mieraBook->load(L"Data/mieraNezamestnanosti.xlsx");
- Sheet* uchadzaci = uchadzaciBook->getSheet(0);
- Sheet* nezamestnanost = mieraBook->getSheet(0);
- if (uchadzaci && nezamestnanost)
- {
- for (int j = 2; j < 81; j++)
- {
- const WCHAR* wc = uchadzaci->readStr(j, 0);
- _bstr_t b(wc);
- const char* c = b;
- nazvyOkresov.add(c);
- }
- for (int i = 0; i < 3; i++)
- {
- int rok = uchadzaci->readNum(0, (4 * i) + 1);
- tabulkaOkresov->clear();
- for (int j = 2; j < 81; j++)
- {
- int zp = uchadzaci->readNum(j, (4 * i) + 1);
- int absolventi = uchadzaci->readNum(j, (4 * i) + 2);
- int mladistvi = uchadzaci->readNum(j, (4 * i) + 3);
- int dlhodoboEvidovani = uchadzaci->readNum(j, (4 * i) + 4);
- double muzi = nezamestnanost->readNum((3 * j) - 4 ,(3 * i) + 1);
- double zeny = nezamestnanost->readNum((3 * j) - 4, (3 * i) + 1);
- double spolu = nezamestnanost->readNum((3 * j) - 4, (3 * i) + 1);
- Ukazovatel* mieraNezamest = new Ukazovatel(muzi, zeny, spolu);
- muzi = nezamestnanost->readNum((3 * j) - 3, (3 * i) + 1);
- zeny = nezamestnanost->readNum((3 * j) - 3, (3 * i) + 1);
- spolu = nezamestnanost->readNum((3 * j) - 3, (3 * i) + 1);
- Ukazovatel* ekonomAktivObyv = new Ukazovatel(muzi, zeny, spolu);
- muzi = nezamestnanost->readNum((3 * j) - 2, (3 * i) + 1);
- zeny = nezamestnanost->readNum((3 * j) - 2, (3 * i) + 1);
- spolu = nezamestnanost->readNum((3 * j) - 2, (3 * i) + 1);
- Ukazovatel* dispoPocet = new Ukazovatel(muzi, zeny, spolu);
- Okres *o = new Okres(zp, absolventi, mladistvi, dlhodoboEvidovani, mieraNezamest, ekonomAktivObyv, dispoPocet);
- tabulkaOkresov->insert(nazvyOkresov[j-2], o);
- }
- //pre potreby insertu do SortedSequenceTable sa vytvori array s velkostou 80 - aby som zabranil enlarge
- tabulkaPreVyhladanie->insert(rok, tabulkaOkresov);
- tabulkaPreTriedenie->insert(rok, dynamic_cast<UnsortedSequenceTable<string, Okres*> *>(tabulkaOkresov));
- }
- for (string s : nazvyOkresov)
- {
- cout << s << endl;
- }
- }
- else
- cout << "Zlyhalo načitavanie súborov\n";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement