public function ukazAction()
{
//ulozeni posledniho URL katalogu pro pripadny navrat
$_SESSION['crumb'] = array();
$_SESSION['url']['detail'] = $_SERVER['REQUEST_URI'];
$pars = $this->_getAllParams();
//parametry katalogu pro pouziti ve zpracovani
$_SESSION['detail']['pars'] = $pars;
$this->view->strom = stromek(0, $this->_getAllParams());
//nalezeni posledni kategorie rozpadu
$i = 1;
$max_kat = 0;
while (isset($pars['u' . (string) $i])) {
$max_kat = $pars['u' . (string) $i];
$i++;
}
$vysl = readData('detail_zbozi', array('kc' => textToDB($pars['kc']), 'cenik' => $_SESSION['uzivatel']['cenik'], 'firma_sleva' => $_SESSION['uzivatel']['firma_sleva'], 'ahoj' => 'ahoj'));
//print_r($_SESSION['vracene_xml']);
//detail zbozi
foreach ($vysl->z->row as $r) {
$this->view->zbozi = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'baleni' => (string) $r->baleni, 'text' => $r->xtext, 'dodavatel' => (string) $r->dodavatel, 'kc' => (string) $r->kc, 'carovy_kod' => (string) $r->carovy_kod, 'carovy_kod_vlastni' => (string) $r->carovy_kod_vlastni, 'skladem' => (double) $r->skladem, 'sleva' => (double) $r->sleva, 'mez_1' => (double) $r->mez_1, 'mez_2' => (double) $r->mez_2, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
//souvisejici zbozi
$this->view->souv = array();
foreach ($vysl->s->row as $r) {
$this->view->souv[] = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'vshop_id' => (string) $r->vshop_id, 'baleni' => (string) $r->baleni, 'skladem' => (int) $r->skladem, 'text' => $r->xtext, 'sleva' => (double) $r->sleva, 'akce' => (int) $r->akce, 'sezona' => (int) $r->sezona, 'novinka' => (int) $r->novinka, 'doprodej' => (int) $r->doprodej, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
foreach ($vysl->sr->row as $r) {
$this->view->souv[] = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'vshop_id' => (string) $r->vshop_id, 'baleni' => (string) $r->baleni, 'skladem' => (int) $r->skladem, 'text' => $r->xtext, 'sleva' => (double) $r->sleva, 'akce' => (int) $r->akce, 'sezona' => (int) $r->sezona, 'novinka' => (int) $r->novinka, 'doprodej' => (int) $r->doprodej, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
//souvisejici zbozi
$this->view->alter = array();
foreach ($vysl->a->row as $r) {
$this->view->alter[] = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'vshop_id' => (string) $r->vshop_id, 'baleni' => (string) $r->baleni, 'skladem' => (int) $r->skladem, 'text' => $r->xtext, 'sleva' => (double) $r->sleva, 'akce' => (int) $r->akce, 'sezona' => (int) $r->sezona, 'novinka' => (int) $r->novinka, 'doprodej' => (int) $r->doprodej, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
foreach ($vysl->ar->row as $r) {
$this->view->alter[] = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'vshop_id' => (string) $r->vshop_id, 'baleni' => (string) $r->baleni, 'skladem' => (int) $r->skladem, 'text' => $r->xtext, 'sleva' => (double) $r->sleva, 'akce' => (int) $r->akce, 'sezona' => (int) $r->sezona, 'novinka' => (int) $r->novinka, 'doprodej' => (int) $r->doprodej, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
//print_r($_SESSION['vracene_xml']);
$this->view->script_files = array('/js/katalog_100822_1.js', '/fancybox/jquery-1.3.2.min.js', '/fancybox/custom.js', '/fancybox/jquery.easing.1.3.js', '/fancybox/jquery.fancybox-1.2.1.pack.js');
$this->view->css_files = array('/fancybox/jquery.fancybox.css');
//echo $vysl->p->row->pocet;
//print_r($this->view->pager['url']);
}
public function indexAction()
{
//ulozeni posledniho URL katalogu pro pripadny navrat
$_SESSION['crumb'] = array();
$_SESSION['url']['katalog'] = $_SERVER['REQUEST_URI'];
$pars = $this->_getAllParams();
if (!isset($pars['vyrobce'])) {
$pars['vyrobce'] = '';
}
if (!isset($pars['jenskladem'])) {
$pars['jenskladem'] = '0';
}
if (!isset($pars['jenmfp'])) {
$pars['jenmfp'] = '0';
}
//parametry katalogu pro pouziti ve zpracovani
$_SESSION['katalog']['pars'] = $pars;
$_SESSION['katalog']['rozpad'] = array();
$i = 1;
$nalezeno = true;
$this->view->detail_url = '/katalog/detail/ukaz';
while ($nalezeno) {
if (isset($pars['u' . (string) $i])) {
$nalezeno = true;
$this->view->detail_url .= '/' . 'u' . (string) $i . '/' . $pars['u' . (string) $i];
$_SESSION['katalog']['rozpad']['u' . (string) $i] = $pars['u' . (string) $i];
} else {
$nalezeno = false;
}
$i++;
}
//nalezeni posledni kategorie rozpadu
$i = 1;
$max_kat = 0;
while (isset($pars['u' . (string) $i])) {
$max_kat = $pars['u' . (string) $i];
$i++;
}
//podklady pro strankovani
$this->view->pager = array();
if (!isset($pars['strana'])) {
$strana = 1;
} else {
$strana = $pars['strana'];
}
if (isset($pars['nastranu']) && is_numeric($pars['nastranu'])) {
$_SESSION['katalog']['per_page'] = (int) $pars['nastranu'];
//die('pico');
}
/* else if (!isset($_SESSION['katalog']['pre_page'])) {
$_SESSION['katalog']['pre_page'] = 12;
}*/
$this->view->pager['strana'] = $strana;
//razeni
if (!isset($pars['razeni'])) {
$razeni = 'nazev';
$pars['razeni'] = 'nazev';
} else {
$razeni = $pars['razeni'];
}
if (!isset($pars['smer'])) {
$smer = 'asc';
} else {
$smer = $pars['smer'];
}
if (!isset($pars['akce'])) {
$pars['akce'] = 0;
}
if (!isset($pars['novy'])) {
$pars['novy'] = 0;
}
if (!isset($pars['sleva'])) {
$pars['sleva'] = 0;
}
if (!isset($pars['sezona'])) {
$pars['sezona'] = 0;
}
if (!isset($pars['hledani'])) {
if (isset($_GET['hledej']) && trim($_GET['hledej']) != '') {
$pars['hledani'] = trim($_GET['hledej']);
} else {
$pars['hledani'] = '';
}
}
$_SESSION['katalog']['akce'] = $pars['akce'];
$_SESSION['katalog']['novy'] = $pars['novy'];
$_SESSION['katalog']['sleva'] = $pars['sleva'];
$_SESSION['katalog']['sezona'] = $pars['sezona'];
$_SESSION['katalog']['hledani'] = $pars['hledani'];
switch ($razeni) {
case 'nazev':
$radit_dle = 'k.Popis';
break;
case 'cena':
$radit_dle = 'c.Cena';
break;
case 'kod':
$radit_dle = 'k.Produkt';
break;
default:
$radit_dle = 'k.Popis';
}
if (strtolower($smer) == 'desc') {
$radit_dle .= ' desc';
} else {
$radit_dle .= ' asc';
}
//je potreba urcit cenik
$vysl = readData('zbozi_kategorie', array('kategorie' => textToDB($max_kat), 'strana' => textToDB($this->view->pager['strana']), 'nastranu' => $_SESSION['katalog']['per_page'], 'cenik' => $_SESSION['uzivatel']['cenik'], 'razeni' => $radit_dle, 'vyrobce' => textToDB($pars['vyrobce']), 'jenskladem' => textToDB($pars['jenskladem']), 'jenmfp' => textToDB($pars['jenmfp']), 'akce' => $pars['akce'], 'novy' => $pars['novy'], 'sleva' => $pars['sleva'], 'sezona' => $pars['sezona'], 'hledani' => $pars['hledani'], 'firma_sleva' => $_SESSION['uzivatel']['firma_sleva']));
//print_r($_SESSION['vracene_xml']);
$this->view->strom = stromek(0, $this->_getAllParams());
$this->view->script_files = array('/js/katalog_100822_1.js');
$this->view->zbozi = array();
foreach ($vysl->z->row as $r) {
$this->view->zbozi[] = array('produkt' => (string) $r->produkt, 'popis' => (string) $r->popis, 'sdph' => (double) $r->sdph, 'cena' => (double) $r->cena, 'vshop_id' => (string) $r->vshop_id, 'baleni' => (string) $r->baleni, 'skladem' => (int) $r->skladem, 'text' => $r->xtext, 'sleva' => (double) $r->sleva, 'akce' => (int) $r->akce, 'sezona' => (int) $r->sezona, 'novinka' => (int) $r->novinka, 'doprodej' => (int) $r->doprodej, 'min_mnozstvi' => (int) $r->min_mnozstvi, 'nasobky' => (int) $r->nasobky);
}
//seznam dodavatelu
$this->view->dodavatele = array();
/*foreach($vysl->d->row as $r) {
$this->view->dodavatele[] = (string) $r->dodavatel;
}*/
$this->view->pager['pocet_polozek'] = (double) $vysl->p->row->pocet;
$this->view->pager['pocet_stran'] = ceil((double) $vysl->p->row->pocet / $_SESSION['katalog']['per_page']);
//sestaveni odkazu bez stranky a bez razeni
$this->view->pager['url'] = '/' . $pars['module'] . '/' . $pars['controller'] . '/' . $pars['action'];
$this->view->razeni_url = '/' . $pars['module'] . '/' . $pars['controller'] . '/' . $pars['action'];
foreach ($pars as $k => $h) {
if ($k != 'strana' && $k != 'module' && $k != 'controller' && $k != 'action') {
$this->view->pager['url'] .= '/' . $k . '/' . $h;
}
if ($k != 'razeni' && $k != 'smer' && $k != 'strana' && $k != 'module' && $k != 'controller' && $k != 'action' && $k != 'nastranu' && $k != 'vyrobce' && $k != 'jenskladem' && $k != 'jenmfp') {
$this->view->razeni_url .= '/' . $k . '/' . $h;
}
}
if ($strana > 1) {
$this->view->pager['prvni'] = $this->view->pager['url'] . '/strana/1';
$this->view->pager['predchozi'] = $this->view->pager['url'] . '/strana/' . ($strana - 1);
} else {
$this->view->pager['prvni'] = '';
$this->view->pager['predchozi'] = '';
}
if ($strana < $this->view->pager['pocet_stran']) {
$this->view->pager['posledni'] = $this->view->pager['url'] . '/strana/' . $this->view->pager['pocet_stran'];
$this->view->pager['nasledujici'] = $this->view->pager['url'] . '/strana/' . ($strana + 1);
} else {
$this->view->pager['posledni'] = '';
$this->view->pager['nasledujici'] = '';
}
$this->view->header_script = "\n\tcesta_razeni = '" . $_SERVER['SERVER_NAME'] . '/' . $this->view->razeni_url . "';\n ";
$this->view->radit_dle = $pars['razeni'];
if (isset($pars['smer'])) {
if (strtolower($pars['smer']) == 'desc') {
$this->view->header_script .= "stavajici_razeni = 'desc';";
} else {
$this->view->header_script .= "stavajici_razeni = 'asc';";
}
} else {
$this->view->header_script .= "stavajici_razeni = 'asc';";
}
//echo $vysl->p->row->pocet;
//print_r($this->view->pager['url']);
}
public function zpracujeditaciAction()
{
//overim, jestli firma neexistuje
$data = array();
foreach ($_POST as $k => $h) {
$data[$k] = textToDB($h);
}
#print_r($data);
#die();
//ted nactu puvodni udaje:
$vysl = readData('uzivatel_info', array('firma' => $_SESSION['uzivatel']['firma'], 'osoba' => $_SESSION['uzivatel']['jmeno']));
$puv = array('nazev_firmy' => trim((string) $vysl->f->row->nazev_firmy), 'ulice' => trim((string) $vysl->f->row->ulice), 'psc' => trim((string) $vysl->f->row->psc), 'mesto' => trim((string) $vysl->f->row->mesto), 'stat' => trim((string) $vysl->f->row->stat), 'telefon' => trim((string) $vysl->f->row->telefon), 'ico' => trim((string) $vysl->f->row->ico), 'dic' => trim((string) $vysl->f->row->dic), 'ujmeno' => trim((string) $vysl->f->row->ujmeno), 'osoba' => trim((string) $vysl->f->row->osoba), 'email' => trim((string) $vysl->f->row->u_e_mail), 'doruceni_nazev_firmy' => trim((string) $vysl->f->row->dodani_nazev_firmy), 'doruceni_ulice' => trim((string) $vysl->f->row->dodani_ulice), 'doruceni_psc' => trim((string) $vysl->f->row->dodani_psc), 'doruceni_mesto' => trim((string) $vysl->f->row->dodani_mesto));
$pars = array('skupina_oprav' => WEB_SKUPINA);
$pars['xfirma'] = $_SESSION['uzivatel']['firma'];
if (trim($_POST['firma']) == '') {
$pars['nazev_firmy'] = textToDB(trim($_POST['jmeno']));
} else {
$pars['nazev_firmy'] = textToDB(trim($_POST['firma']));
}
$pars['ujmeno'] = $_SESSION['uzivatel']['login'];
$pars['ulice'] = textToDB(trim($_POST['ulice']));
$pars['mesto'] = textToDB(trim($_POST['mesto']));
$pars['psc'] = textToDB(trim($_POST['psc']));
$pars['adresa'] = $pars['ulice'] . ' ' . $pars['psc'] . ' ' . $pars['mesto'];
switch (trim($_POST['stat'])) {
case 'sk':
$pars['stat'] = 'Slovenská republika';
break;
default:
$pars['stat'] = 'Česká republika';
break;
}
$pars['telefon'] = textToDB(trim($_POST['telefon']));
$pars['email'] = textToDB(trim($_POST['email']));
$pars['ic'] = textToDB(trim($_POST['ic']));
$pars['dic'] = textToDB(trim($_POST['dic']));
$pars['osoba'] = textToDB(trim($_POST['jmeno']));
$pars['heslo'] = textToDB(trim($_POST['heslo']));
if (trim($_POST['firma2']) == '') {
$pars['dodani_nazev_firmy'] = textToDB(trim($_POST['jmeno2']));
} else {
$pars['dodani_nazev_firmy'] = textToDB(trim($_POST['firma2']));
}
$pars['dodani_ulice'] = textToDB(trim($_POST['ulice2']));
$pars['dodani_mesto'] = textToDB(trim($_POST['mesto2']));
$pars['dodani_psc'] = textToDB(trim($_POST['psc2']));
$pars['dodani_adresa'] = $pars['dodani_ulice'] . ' ' . $pars['dodani_psc'] . ' ' . $pars['dodani_mesto'];
#print_r($pars);die();
$vysl = readData('edituj_firmu', $pars);
#a jeste musim opravit udaje v session
$_SESSION['uzivatel']['nazev_firmy'] = $pars['nazev_firmy'];
$_SESSION['uzivatel']['jmeno'] = $pars['osoba'];
$_SESSION['uzivatel']['e_mail'] = $pars['email'];
#echo "<pre>\nPars:\n";print_r($pars);
#echo "\nzalozeno firem: " . (string) $vysl->f->row->pocet_firem;
#echo "\nzalozeno uzivatelu: " . (string) $vysl->f->row->pocet_uzivatelu;
#odeslani mailu se zpravou o zmene
$zprava = 'Došlo ke změně údajů partnera.' . "\r\n\r\n";
$zprava .= "Původní údaje:\r\n";
$zprava .= "==============\r\n";
foreach ($puv as $k => $h) {
$zprava .= "{$k}: {$h}\r\n";
}
$zprava .= "\r\nNové údaje:\r\n";
$zprava .= "===========\r\n";
foreach ($pars as $k => $h) {
$zprava .= "{$k}: {$h}\r\n";
}
@mailuj(EMAIL_OBCHODNIK, 'MFP Shop - zmena udaju zakaznika', iconv('UTF-8', 'iso-8859-2//TRANSLIT', $zprava), 'iso-8859-2');
unset($pars);
unset($puv);
if (isset($_POST['fromobj']) && trim(strtolower($_POST['fromobj'])) == 'ano') {
$this->_Redirect('/obchod/kosik/doruceni');
} else {
$this->_Redirect('/');
}
#echo "\n\n<pre>POST:\n";print_r($_POST);
#die();
}
