$con=mysqli_connect("localhost", "highstan_aluloft", "oxXH{J;DOPm5", "highstan_aluloft_price");
$result = mysqli_query($con,"SELECT * FROM postavke");
$row = mysqli_fetch_array($result);
$naslovXV=$row["naslov"];
$opisXV=$row["opis"];
$kljucneXV=$row["kljucne"];
$adresaXV=$row["adresa"];
$gradXV=$row["grad"];
$zemljaXV=$row["zemlja"];
$telefonXV=$row["telefon"];
$telefon2XV=$row["telefon2"];
$emailXV=$row["email"];
$domenaXV=$row["domena"];
$kursEUR="1.9558";
$valuta="£";
$koef_masa=30; // po m2
$fire_krilo=1000;
?>
$result = mysqli_query($con,"SELECT * FROM cijene");
$row = mysqli_fetch_array($result);
$steel_price=$row["steel"];
$koeficijent=$row["provizija"];
$delivery=$row["delivery"];
$pdv=$row["pdv"];
$sliding_door1=$row["sliding_door"];
$sliding_door_d=$row["sliding_door_d"];
$hinged_door_price=$row["hinged_door_price"];
$pivot_door_price=$row["pivot_door_price"];
?>
$result = mysqli_query($con,"SELECT * FROM tekstovi where id='1'");
$row = mysqli_fetch_array($result);
$tekst_naslov1=$row["naslov"];
$tekst_opis1=$row["tekst"];
?>
$result = mysqli_query($con,"SELECT * FROM tekstovi where id='2'");
$row = mysqli_fetch_array($result);
$instalacija_opis=$row["tekst"];
?>
$sirina="1000";
$visina="2100";
$krilo_1="400";
$pomocno="800";
$krilo_2="400";
$krilo_3="400";
$model=$_GET["model"];
$boja_in=1;
$boja_out=1;
$boja_okvir_in=1;
$boja_okvir_out=1;
$zastita="0";
$rozeta="999";
$status="";
$kontstrukcija="1";
$dekor_in="0";
$dekor_out="0";
$tip="1";
$staklo="1";
$staklo_panel="1";
$hinges="1";
$boja_out2=1;
$dekor_out2=0;
$brava=0;
$locking="0";
$locking2="0";
$viewers="0";
$unlocking="0";
$letterbox="1";
$letterbox="0";
$cilindar="0";
$pogled="1";
$rukohvat_in="1";
$handle_color="37";
$cill="0";
$corner="0";
$adc="0";
$addon_left="0";
$addon_right="0";
$addon_top="0";
$addon_bottom="0";
$pozicija_rukohvat="70";
$dupla="";
$background="";
$pozicija_rukohvat_x="15";
$rukohvat="1";
$lett_x="60";
$lett_y="36";
$lett_y="36";
$foto_in="";
$designsldelight="0";
$proizvod="1";
$naruceno="0";
$cijena="0";
$repeat_left="1";
$repeat_right="1";
$glavno_krilo="";
$sirina_pomocno="0";
$rukohvat_pomocno="0";
$led_hand="0";
$last_url="";
$sql = "SELECT count(*) from konfigurator where sesija='$sesija' and naruceno='0'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$count_kf=$row["count(*)"];
$sql6 = "SELECT * from vat_log where sesija='$sesija'";
$result6 = mysqli_query ($con,$sql6);
$row6 = mysqli_fetch_array($result6);
$vat_log=$row6["vat"];
if($vat_log==""){
mysqli_query($con,"INSERT INTO `vat_log` VALUES (0,'".$sesija."','".$pdv."')") ;
}
$konfig_id=$_GET["konfig_id"];
$podjela_vert=0;
$podjela_hor=0;
$dupla="0";
$prod_id_nav="0";
$model_d=1;
$system_option=1;
$slide_model=1;
$prikaz="2D";
$left_design="1";
$right_design="1";
$top_design="1";
$zid=24;
$povrsina=0;
$t_w=0;
$t_h=0;
$kolicina=1;
$scena="On";
$kotiranje=0;
if($count_kf==0 && $konfig_id==""){
mysqli_query($con,"INSERT INTO `konfigurator` VALUES (0,'".$sesija."','".$proizvod."','".$system_option."','".$sirina."','".$visina."','".$model_d."','".$kontstrukcija."','".$staklo."','".$staklo_panel."','".$tip."','".$boja_in."','".$boja_out."','".$rukohvat."','".$pomocno."','".$krilo_1."','".$krilo_2."','".$krilo_3."','".$status."','".$hinges."','".$pogled."','".$glavno_krilo."','".$sirina_pomocno."','".$dupla."','".$foto_out."','".$foto_in."','".$podjela_vert."','".$podjela_hor."','".$naruceno."','".$cijena."','".$prod_id_nav."','".$slide_model."','".$prikaz."','".$left_design."','".$right_design."','".$top_design."','".$zid."','".$scena."','".$repeat_left."','".$repeat_right."','".$povrsina."','".$t_w."','".$t_h."','".$kolicina."','".$kotiranje."','".$pdv."')") ;
}
?>
echo $naslovXV; ?>
$sql = "SELECT * from konfig_edit where sesija='$sesija'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$konf_edit_log=$row["konfig_id"];
?>
$add_title="ADD TO CART";
$sql = "SELECT * from konfigurator where sesija='$sesija' and naruceno='0' order by id desc limit 1";
if($konf_edit_log!=""){$sql = "SELECT * from konfigurator where id='$konf_edit_log'"; $add_title="UPDATE CART"; }
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$id_log=$row["id"];
$model_log=$row["model"];
$konstrukcija_log=$row["konstrukcija"];
$boja_out_log=$row["boja_out"];
$boja_in_log=$row["boja_in"];
$tip_log=$row["tip"];
$staklo_log=$row["staklo"];
$pogled_log=$row["pogled"];
$proizvod_log=$row["proizvod"];
$system_option_log=$row["system_option"];
$zid_log=$row["zid"];
$sirina_log=$row["sirina"];
$visina_log=$row["visina"];
$kotiranje_log=$row["kotiranje"];
$repeat_left_log=$row["repeat_left"];
$repeat_right_log=$row["repeat_right"];
$designsldelight_log=$row["designsldelight"];
$prod_id_nav_log=$row["prod_id"];
$pomocno_top_log=$row["pomocno_top"];
$pomocno_left_log=$row["pomocno_left"];
$pomocno_rig_log=$row["pomocno_rig"];
$dekor_out_log=$row["dekor_out"];
$dekor_out2_log=$row["dekor_out2"];
$hand_out_log=$row["rukohvat"];
$rukohvat_in_log=$row["rukohvat_in"];
$zastita_log=$row["zastita"];
$hinges_log=$row["hinges"];
$letterbox_log=$row["letterbox"];
$locking_log=$row["locking"];
$locking2_log=$row["locking2"];
$brava_log=$row["brava"];
$viewers_log=$row["viewers"];
$cilindar_log=$row["cilindar"];
$rozeta_log=$row["rozeta"];
$slide_model_log=$row["slide_model"];
$prikaz_log=$row["prikaz"];
$left_design_log=$row["left_design"];
$right_design_log=$row["right_design"];
$top_design_log=$row["top_design"];
$boja_okvir_in_log=$row["boja_okvir_in"];
$boja_okvir_out=$row["boja_okvir_out"];
$konstrukcija_log=$row["konstrukcija"];
$boja_out2_log=$row["boja_out2"];
$vert_log=$row["podjela_vert"];
$hor_log=$row["podjela_hor"];
$scena_log=$row["scena"];
$povrsina_sum_log=$row["povrsina"];
if($pogled_log=="1"){$set_pogled="2";}
if($pogled_log=="2"){$set_pogled="1";}
if($prikaz_log=="2D"){$set_prikaz="3D";}
if($prikaz_log=="3D"){$set_prikaz="2D";}
if($scena_log=="On"){$set_scena="Off";}
if($scena_log=="Off"){$set_scena="On";}
if($kotiranje_log=="0"){$kotiranje_set="1";}
if($kotiranje_log=="1"){$kotiranje_set="0";}
$price=0;
$foto_out=$row["foto_out"];
$povrsina_krila=$sirina_log*$visina_log/1000000;
$povrsina_total=$povrsina_krila;
$povrsina_total=number_format((float)$povrsina_total, 2, '.', '');
if($stat_add=="add"){$kotiranje_log=1; $prikaz_log="2D"; $scena_log="Off"; }
?>
$sql = "SELECT * from ralkarta where id='$boja_out_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$boja_out_sifra=$row["sifra"];
$sifra_linear=$row["sifra_linear"];
$boja_doplata=$row["doplata"];
$boja_foto=$row["foto"];
$boja_border=$row["border"];
?>
$sql = "SELECT count(*) from oprema_log where konfig_id='$id_log' and description like 'handle_slave_door'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$hand_SD=$row["count(*)"];
?>
$sql = "SELECT * from handles where id='$hand_out_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$hand_dizajn=$row["dizajn"];
?>
$sql = "SELECT * from hinges where id='$hinges_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$hinges_naziv=$row["naziv"];
?>
$sql = "SELECT * from zid where id='$zid_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$zid_boja_sifra=$row["boja"];
$zid_boja_foto=$row["foto"];
$font_color=$row["font_color"];
$cart_img=$row["icons"];
$logo_img=$row["logo_color"];
$login_img="login_white.png";
$logout_img="logout_white.png";
if($prikaz_log=="3D"){$font_color="#000000";}
if($prikaz_log=="3D"){$cart_img="cart_black.png"; $login_img="login_black.png"; $logout_img="logout_black.png"; }
if($prikaz_log=="3D"){$logo_img="logo.png"; }
if($scena_log=="Off"){$font_color="#000000";}
if($scena_log=="Off"){$cart_img="cart_black.png"; $login_img="login_black.png"; $logout_img="logout_black.png"; }
if($scena_log=="Off"){$logo_img="logo.png"; }
?>
$sql = "SELECT * from system_options where id='$system_option_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$door_typ=$row["door_typ"];
$door_typ_log=$row["door_typ"];
$proizvod_css=$row["css_design"];
$proizvod_css_scr=$row["css_design_scr"];
$animacija_left=$row["animacija_left"];
$animacija_right=$row["animacija_right"];
$system_otvaranje=$row["otvaranje"];
$sirina_min=$row["sirina_min"];
$sirina_max=$row["sirina_max"];
$visina_min=$row["visina_min"];
$visina_max=$row["visina_max"];
$doorset=$row["doorset"];
$max_door_povrsina=$row["max_povrsina"];
if($konstrukcija_log=="3"){$animacija_open=$animacija_left;}
if($konstrukcija_log=="4"){$animacija_open=$animacija_right;}
$frame_size=7;
$frame_size2=14;
$frame_sizeX=10;
$frame_sizeGlass=20;
$frame_sizeGlassX=7;
if($door_typ=="Fire"){
$frame_size=10;
$frame_size2=16;
$frame_sizeX=14;
$frame_sizeGlass=30;
$frame_sizeGlassX=12;
}
$sirina_krilo_m=$sirina_log/1000;
$visina_krilo_m=$visina_log/1000;
?>
$sql = "SELECT * from tipovi where id='$tip_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$krilo_left_log=$row["krilo_left"];
$krilo_top_log=$row["krilo_top"];
$krilo_right_log=$row["krilo_rig"];
$zaobljeno_log=$row["zaobljeno"];
$sirina_total=$sirina_log;
$visina_total=$visina_log;
$pomocno_left_log_total=$pomocno_left_log*$repeat_left_log;
$pomocno_right_log_total=$pomocno_rig_log*$repeat_right_log;
if($krilo_left_log=="1"){$sirina_total=$sirina_total+$pomocno_left_log_total;}
if($krilo_right_log=="1"){$sirina_total=$sirina_total+$pomocno_right_log_total;}
if($krilo_top_log=="1"){$visina_total=$visina_total+$pomocno_top_log;}
$povrsina_sum=$sirina_total*$visina_total/1000000;
$povrsina_sum=number_format((float)$povrsina_sum, 2, '.', '');
mysqli_query($con,"UPDATE `konfigurator` set povrsina='$povrsina_sum', total_width='$sirina_total', total_height='$visina_total' where id='$id_log'");
?>
$sql = "SELECT * from construct where id='$konstrukcija_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$hinge_side_log=$row["hinge_side"];
?>
$sqlKO = "SELECT count(*) from konfig_log where sesija='$sesija' and naruceno='DA'";
$resultKO = mysqli_query ($con,$sqlKO);
$rowKO = mysqli_fetch_array($resultKO);
$countKorpa=$rowKO["count(*)"];
?>
$sql = "SELECT * from proizvodi where id='$proizvod_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$fiks_panel=$row["fiks"];
$slide_door_log=$row["slide_door"];
$product_dvokrilna=$row["dvokrilna"];
$product_arched=$row["arched"];
?>
$sql = "SELECT * from proizvodi where proizvod='$proizvod_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$max_sirina=$row["max_sirina"];
$max_visina=$row["max_visina"];
?>
$sql = "SELECT * from nav_position";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$nav1_poz=$row["nav1"];
$nav2_poz=$row["nav2"];
?>
$sql = "SELECT * from dekori where id='$dekor_out_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$dekor_out_img=$row["foto"];
?>
$sql = "SELECT * from dekori where id='$dekor_out2_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$dekor_out2_img=$row["foto"];
?>
$sql = "SELECT * from modeli where id='$model_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$model_naziv=$row["naziv"];
$model_cijena=$row["cijena"];
$sec_mat=$row["sec_mat"];
$door_aplikacija=$row["aplikacija"];
$door_dekor=$row["door_dekor"];
$design_panel=$row["design_panel"];
$door_editable=$row["editable"];
$klizna=$row["klizna"];
$rukohvat_precke=$row["rukohvat"];
$dizajn_css=$row["dizajn_css"];
$model_doplata=$row["doplata"];
$width_min=$row["width_min"];
$width_max=$row["width_max"];
$height_min=$row["height_min"];
$height_max=$row["height_max"];
?>
$sql = "SELECT * from stakla where id='$staklo_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$staklo_img=$row["foto_ispis"];
$staklo_cijena=$row["cijena"];
if($model_doplata=="1"){$staklo_cijena=$row["cijena2"];}
?>
$sql = "SELECT * from sidelights where id='$left_design_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$dizajn_css_left=$row["design_left"];
$model_doplata_left=$row["doplata"];
?>
$sql = "SELECT * from sidelights where id='$right_design_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$dizajn_css_right=$row["design_right"];
$model_doplata_right=$row["doplata"];
?>
$sql = "SELECT * from modeli_top where id='$top_design_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$dizajn_css_top=$row["dizajn_css"];
?>
$sql = "SELECT * from model_cijene where model_id='$model_log'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$model_cijena=$row["cijena"];
?>
$price=$model_cijena;
?>
$sql = "SELECT * from app_nav_log where sesija='$sesija'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$nav_id=$row["nav_id"];
$nav_tab=$row["nav_tab"];
?>
$sql = "SELECT count(*),sum(cijena) from konfigurator where sesija='$sesija' and naruceno='1'";
$result = mysqli_query ($con,$sql);
$row = mysqli_fetch_array($result);
$count_korpa=$row["count(*)"];
$sum_korpa=$row["sum(cijena)"];
$sum_korpa = number_format($sum_korpa, 2, '.', '');
?>
echo $valuta; ?> echo $sum_korpa; ?>
echo $count_korpa; ?>
if($user==""){ echo '
';} ?>
if($user!=""){ echo '
DASHBOARD ';} ?>
include 'desktop_nav.php'; ?>
include $proizvod_css; include 'door.php'; include $hand_dizajn; ?>
echo $animacija_open; ?>
include 'desktop_nav_sec.php'; ?>
include 'price.php'; ?>
echo '
'; ?>
PRICE
echo $valuta; ?> echo $price_total; ?>
WALL COLOUR
$sql2 = "SELECT * from zid";
$result2 = mysqli_query ($con,$sql2);
while($row2 = mysqli_fetch_array($result2)){
$idcol=$row2["id"];
$zid_sifra=$row2["boja"];
echo '
';
}
?>
To view this screen in your room, please upload a photo
include 'nav.php'; ?>
if($stat_add=="add"){
mysqli_query($con,"UPDATE `konfigurator` set naruceno='1', cijena='$price_total' where id='$id_log'");
mysqli_query($con,"DELETE FROM konfig_edit WHERE konfig_id='$id_log'") ;
echo '
';
}
?>