Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['aktualizace_kosiku'])){
- $existuje_duplikat = $db_nk -> querySingle('SELECT COUNT(web_b_id)
- FROM db_web_b
- WHERE web_b_duplikat=? AND web_b_klient=? AND web_b_product=?
- ', 1, $uzivatel, $_POST['kosik_id']);
- $existuje_sleva = $db_nk -> querySingle('SELECT COUNT(web_b_id)
- FROM db_web_b
- WHERE web_b_sleva_plus!=? AND web_b_klient=? AND web_b_product=?
- ', 0, $uzivatel, $_POST['kosik_id']);
- if(!empty($existuje_duplikat)){ // existuje duplikat
- $db_nk -> query('UPDATE db_web_b
- SET web_b_mnozstvi=?, web_b_cena_celkem=?
- WHERE web_b_product=? AND web_b_klient=?
- ', $_POST['i_mnozstvi'], ($_POST['i_mnozstvi'] * $_POST['cena_id']), $_POST['kosik_id'], $uzivatel);
- } else {//neexistuje duplikat
- if (empty($existuje_sleva)) { //nenexistuje sleva
- $db_nk -> query('UPDATE db_web_b
- SET web_b_mnozstvi=?, web_b_cena_celkem=?
- WHERE web_b_product=? AND web_b_klient=?
- ', $_POST['i_mnozstvi'], ($_POST['i_mnozstvi'] * $_POST['cena_id']), $_POST['kosik_id'], $uzivatel);
- }else {//existuje sleva
- if($_POST['i_mnozstvi'] > 1){
- $produkt = $db_nk -> queryOne('SELECT *
- FROM db_web_p
- WHERE web_p_id=?
- ', $_POST['kosik_id']);
- $sleva = $db_nk -> querySingle('SELECT slevy_procent
- FROM db_slevy
- WHERE slevy_produkt=?
- ', $_POST['kosik_id']);
- $db_nk -> query('DELETE FROM db_web_b
- WHERE web_b_klient=? AND web_b_duplikat=?
- ', $uzivatel, 1);
- $db_nk -> query('UPDATE db_web_b
- SET web_b_sleva_plus=?
- WHERE web_b_klient=?
- ', 0, $uzivatel);
- $db_nk -> query('UPDATE db_web_b
- SET web_b_sleva_plus=?, web_b_mnozstvi=?, web_b_cena=?, web_b_cena_celkem=?, web_b_duplikat=?
- WHERE web_b_product=? AND web_b_klient=?
- ', $sleva, 1, $_POST['cena_id'], $_POST['cena_id'], 1, $_POST['kosik_id'], $uzivatel);
- $db_nk -> query('INSERT INTO db_web_b (web_b_klient, web_b_nazev, web_b_code, web_b_product, web_b_mnozstvi, web_b_cena,
- web_b_cena_celkem, web_b_img)
- VALUES (?, ?, ?, ?, ?, ?, ?, ?)
- ', $uzivatel, $produkt['web_p_nazev'], $produkt['web_p_kod_zbozi'], $produkt['web_p_id'],
- ($_POST['i_mnozstvi'] - 1), $produkt['web_p_cena'], ($produkt['web_p_cena'] * ($_POST['i_mnozstvi'] - 1)),
- $produkt['web_p_img_det_1']);
- }
- }
- }
- header('Location: '.$_SERVER['REQUEST_URI']);
- exit();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement