/* 12:56:09 gmspider gmspider */ UPDATE `obchodny_partner` SET `nazov` = 'DEMO' WHERE `id` = '57';
/* 13:01:59 gmspider gmspider */ UPDATE `osoba` SET `nazov` = 'Peter Hanák', `titul_pred_menom` = NULL, `meno` = 'Peter', `priezvisko` = 'Ha' WHERE `id` = '89';
/* 13:03:02 gmspider gmspider */ UPDATE `osoba` SET `priezvisko` = 'Hanák', `email` = 'hanak@demo.sk', `visibility_type` = '1', `passwd` = '28959968da111e03ed6a4d50854aeea9408274fb', `passwd_clear` = NULL, `posielat_notifikacie` = NULL WHERE `id` = '89';
/* 13:03:44 gmspider gmspider */ UPDATE `osoba` SET `nazov` = 'Jana Ostupníková', `titul_pred_menom` = NULL, `meno` = 'Jana', `priezvisko` = 'Ostupníková', `email` = 'ostupnikova@demo.sk', `visibility_type` = '1', `passwd` = '28959968da111e03ed6a4d50854aeea9408274fb', `passwd_clear` = NULL, `posielat_notifikacie` = NULL WHERE `id` = '90';
/* 13:04:35 gmspider gmspider */ UPDATE `osoba` SET `email` = 'petran@demo.sk', `passwd` = '28959968da111e03ed6a4d50854aeea9408274fb', `posielat_notifikacie` = NULL WHERE `id` = '355';
/* 13:05:33 gmspider gmspider */ UPDATE osoba SET visibility_type = 3 WHERE obchodny_partner_id = 57 AND id NOT IN (89,90,355);
/* 13:16:13 gmspider gmspider */ INSERT INTO `osoba_funkcia_osoby` (`osoba_id`, `funkcia_osoby_id`) VALUES ('89', '1');
/* 13:16:18 gmspider gmspider */ INSERT INTO `osoba_funkcia_osoby` (`osoba_id`, `funkcia_osoby_id`) VALUES ('89', '3');
/* 13:16:26 gmspider gmspider */ INSERT INTO `osoba_funkcia_osoby` (`osoba_id`, `funkcia_osoby_id`) VALUES ('90', '2');
/* 13:16:32 gmspider gmspider */ INSERT INTO `osoba_funkcia_osoby` (`osoba_id`, `funkcia_osoby_id`) VALUES ('90', '4');
/* 13:21:14 gmspider gmspider */ INSERT IGNORE INTO `osoba_modul` (`osoba_id`, `modul_id`) VALUES ('355', '1');
/* 13:21:16 gmspider gmspider */ INSERT IGNORE INTO `osoba_modul` (`osoba_id`, `modul_id`) VALUES ('355', '2');
/* 13:21:14 gmspider gmspider */ INSERT IGNORE INTO `osoba_modul` (`osoba_id`, `modul_id`) VALUES ('355', '3');
/* 13:21:16 gmspider gmspider */ INSERT IGNORE INTO `osoba_modul` (`osoba_id`, `modul_id`) VALUES ('355', '4');

INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 10);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 11);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 12);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 13);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 14);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 15);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 16);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 18);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 20);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 22);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (89, 23);

INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 10);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 11);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 12);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 13);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 14);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 15);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 16);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 18);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 20);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 22);
INSERT IGNORE INTO `osoba_sluzba` (`osoba_id`, `sluzba_id`) VALUES (355, 23);

UPDATE osoba SET passwd = "e176dd5484dc0b8dd5f3e7ace14903daf21f0cdbfa0741ccc7b91fbb88c19388" WHERE id IN (89,90,355);
UPDATE zmluva SET stav_zmluvy_id = 2, visibility_type = 1 WHERE id = 1783;
/* 13:41:07 gmspider gmspider */ UPDATE `polozka_zmluvy` SET `nazov` = 'Všetky služby', visibility_type = 1 WHERE `id` = '2579';

INSERT IGNORE INTO polozka_zmluvy_sluzba (polozka_zmluvy_id, sluzba_id) SELECT 2579, id FROM sluzba WHERE visibility_type = 1;

/* spustit v php
   http://tomaspekar/gmspider/admin/priradenie_sluzieb_obchodnemu_partnerovi_test_action.php?obchodny_partner_id=57
   http://apps.csweb.sk/gmspider.sk/admin/priradenie_sluzieb_obchodnemu_partnerovi_test_action.php?obchodny_partner_id=57
 */