query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $dataArray = Array(); while($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) { $dataArray[] = $row; } return $dataArray; } // dati // return data array / false function modelliData($id) { global $db_object; $query = "SELECT * FROM modelli WHERE id = $id"; $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } return $result->fetchRow(DB_FETCHMODE_OBJECT); } // nuovo // return true / false function modelliNew() { global $db_object; global $pathSito; global $pathModelli; // find a new peso $query = "SELECT MAX(peso) AS maxPeso FROM modelli"; $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $newPeso = $row->maxPeso + 1; // find a new id $query = "SELECT id FROM modelli ORDER BY id DESC LIMIT 1"; $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $newId = $row->id + 1; $idStr = str_pad($newId, 4, '0', STR_PAD_LEFT); $pathImg = $pathSito.$pathModelli."img_".$idStr.".jpg"; set_time_limit(300) ; // upload image if($_REQUEST['foto']['tmp_name'] && $_REQUEST['foto']['tmp_name'] != 'none'){ @copy($_REQUEST['foto']['tmp_name'], $pathImg) // copio il file nella cartella or die("Impossibile caricare il file ".$_REQUEST['foto']['name']."!
\n\rRipeti l’operazione."); while(!is_uploaded_file($_REQUEST['foto']['tmp_name'])) { //aspetto } } if($_REQUEST['accessorio'] == 'no') { $query = "INSERT INTO modelli ( id, idC, titolo_it, titolo_en, titolo_fr, titolo_es, dex_it, dex_en, dex_fr, dex_es, dexExt_it, dexExt_en, dexExt_fr, dexExt_es, dexList_it, dexList_en, dexList_fr, dexList_es, price, packing, peso, accessorio )VALUES ( ".$newId.", ".$_REQUEST['idC'].", '".addslashes($_REQUEST['titolo_it'])."', '".addslashes($_REQUEST['titolo_en'])."', '".addslashes($_REQUEST['titolo_fr'])."', '".addslashes($_REQUEST['titolo_es'])."', '".addslashes($_REQUEST['dex_it'])."', '".addslashes($_REQUEST['dex_en'])."', '".addslashes($_REQUEST['dex_fr'])."', '".addslashes($_REQUEST['dex_es'])."', '".addslashes($_REQUEST['dexExt_it'])."', '".addslashes($_REQUEST['dexExt_en'])."', '".addslashes($_REQUEST['dexExt_fr'])."', '".addslashes($_REQUEST['dexExt_es'])."', '".addslashes($_REQUEST['dexList_it'])."', '".addslashes($_REQUEST['dexList_en'])."', '".addslashes($_REQUEST['dexList_fr'])."', '".addslashes($_REQUEST['dexList_es'])."', '".$_REQUEST['price']."', '".$_REQUEST['packing']."', ".$newPeso.", '".$_REQUEST['accessorio']."' )"; } else { $query = "INSERT INTO modelli ( id, idC, titolo_it, titolo_en, titolo_fr, titolo_es, dex_it, dex_en, dex_fr, dex_es, dexList_it, dexList_en, dexList_fr, dexList_es, price, packing, peso, accessorio )VALUES ( ".$newId.", ".$_REQUEST['idC'].", '".addslashes($_REQUEST['titolo_it'])."', '".addslashes($_REQUEST['titolo_en'])."', '".addslashes($_REQUEST['titolo_fr'])."', '".addslashes($_REQUEST['titolo_es'])."', '".addslashes($_REQUEST['dex_it'])."', '".addslashes($_REQUEST['dex_en'])."', '".addslashes($_REQUEST['dex_fr'])."', '".addslashes($_REQUEST['dex_es'])."', '".addslashes($_REQUEST['dex_it'])."', '".addslashes($_REQUEST['dex_en'])."', '".addslashes($_REQUEST['dex_fr'])."', '".addslashes($_REQUEST['dex_es'])."', '".$_REQUEST['price']."', '".$_REQUEST['packing']."', ".$newPeso.", '".$_REQUEST['accessorio']."' )"; } $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; return false; } return true; } // edit // return true / false function modelliEdit() { global $db_object; global $pathSito; global $pathModelli; $idStr = str_pad($_REQUEST['id'], 4, '0', STR_PAD_LEFT); $pathImg = $pathSito.$pathModelli."img_".$idStr.".jpg"; set_time_limit(300) ; // upload image if($_REQUEST['foto']['tmp_name'] && $_REQUEST['foto']['tmp_name'] != 'none'){ @copy($_REQUEST['foto']['tmp_name'], $pathImg) // copio il file nella cartella or die("Impossibile caricare il file ".$_REQUEST['foto']['name']."!
\n\rRipeti l’operazione."); while(!is_uploaded_file($_REQUEST['foto']['tmp_name'])) { //aspetto } } if($_REQUEST['accessorio'] == 'no') { $query = "UPDATE modelli SET idC = '".$_REQUEST['idC']."', titolo_it = '".addslashes($_REQUEST['titolo_it'])."', titolo_en = '".addslashes($_REQUEST['titolo_en'])."', titolo_fr = '".addslashes($_REQUEST['titolo_fr'])."', titolo_es = '".addslashes($_REQUEST['titolo_es'])."', dex_it = '".addslashes($_REQUEST['dex_it'])."', dex_en = '".addslashes($_REQUEST['dex_en'])."', dex_fr = '".addslashes($_REQUEST['dex_fr'])."', dex_es = '".addslashes($_REQUEST['dex_es'])."', dexList_it = '".addslashes($_REQUEST['dex_it'])."', dexList_en = '".addslashes($_REQUEST['dex_en'])."', dexList_fr = '".addslashes($_REQUEST['dex_fr'])."', dexList_es = '".addslashes($_REQUEST['dex_es'])."', dexList_en = '".addslashes($_REQUEST['dexList_en'])."', dexList_fr = '".addslashes($_REQUEST['dexList_fr'])."', dexList_es = '".addslashes($_REQUEST['dexList_es'])."', price = '".$_REQUEST['price']."', packing = '".$_REQUEST['packing']."' WHERE id = '".$_REQUEST['id']."'"; } else { $query = "UPDATE modelli SET idC = '".$_REQUEST['idC']."', titolo_it = '".addslashes($_REQUEST['titolo_it'])."', titolo_en = '".addslashes($_REQUEST['titolo_en'])."', titolo_fr = '".addslashes($_REQUEST['titolo_fr'])."', titolo_es = '".addslashes($_REQUEST['titolo_es'])."', dex_it = '".addslashes($_REQUEST['dex_it'])."', dex_en = '".addslashes($_REQUEST['dex_en'])."', dex_fr = '".addslashes($_REQUEST['dex_fr'])."', dex_es = '".addslashes($_REQUEST['dex_es'])."', dexList_it = '".addslashes($_REQUEST['dex_it'])."', dexList_en = '".addslashes($_REQUEST['dex_en'])."', dexList_fr = '".addslashes($_REQUEST['dex_fr'])."', dexList_es = '".addslashes($_REQUEST['dex_es'])."', price = '".$_REQUEST['price']."', packing = '".$_REQUEST['packing']."' WHERE id = '".$_REQUEST['id']."'"; } $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; return false; } return true; } // elimina // return true / false function modelliDelete($id) { global $db_object; global $pathSito; global $pathModelli; $idStr = str_pad($id, 4, '0', STR_PAD_LEFT); $pathImg = $pathSito.$pathModelli."img_".$idStr.".jpg"; @unlink($pathImg); //cancello l'immagine $query = "DELETE FROM modelli WHERE id = '$id'"; $result = $db_object->query($query); if(DB::IsError($result)) { die($result->getMessage()); return false; } return true; } // modelli copy (duplica un prodotto) // return true / false function modelliCopy($id) { global $db_object; global $pathSito; global $pathModelli; // find a new id $query = "SELECT id FROM modelli ORDER BY id DESC LIMIT 1"; $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); echo $query; return false; } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $newId = $row->id + 1; // find a new peso $query = "SELECT MAX(peso) AS maxPeso FROM modelli"; $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); echo $query; return false; } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $newPeso = $row->maxPeso + 1; $idStr = str_pad($newId, 4, '0', STR_PAD_LEFT); $newPathFoto = $pathSito.$pathModelli."img_".$idStr.".jpg"; // ricavo dati del prod da copiare $origProdData = modelliData($id); $idStr = str_pad($id, 4, '0', STR_PAD_LEFT); $origPathFoto = $pathSito.$pathModelli."img_".$idStr.".jpg"; if(file_exists($origPathFoto)) { @copy($origPathFoto, $newPathFoto) // copio il file nella cartella or die("Impossibile copiare il file!
\n\rRipeti l’operazione."); } $query = "INSERT INTO modelli ( id, peso, idC, titolo_it, titolo_en, titolo_fr, titolo_es, dex_it, dex_en, dex_fr, dex_es, dexExt_it, dexExt_en, dexExt_fr, dexExt_es, dexList_it, dexList_en, dexList_fr, dexList_es, price, packing, visibile )VALUES ( ".$newId.", ".$newPeso.", ".$origProdData->idC.", '".addslashes($origProdData->titolo_it)." *COPIA*', '".addslashes($origProdData->titolo_en)."', '".addslashes($origProdData->titolo_fr)."', '".addslashes($origProdData->titolo_es)."', '".addslashes($origProdData->dex_it)."', '".addslashes($origProdData->dex_en)."', '".addslashes($origProdData->dex_fr)."', '".addslashes($origProdData->dex_es)."', '".addslashes($origProdData->dexExt_it)."', '".addslashes($origProdData->dexExt_en)."', '".addslashes($origProdData->dexExt_fr)."', '".addslashes($origProdData->dexExt_es)."', '".addslashes($origProdData->dexList_it)."', '".addslashes($origProdData->dexList_en)."', '".addslashes($origProdData->dexList_fr)."', '".addslashes($origProdData->dexList_es)."', ".$origProdData->price.", ".$origProdData->packing.", '".$origProdData->visibile."' )"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; return false; } return true; } // Ordina una modello // ritorna true / false function modelliSort($id, $move) { global $db_object; // cerco peso $data = modelliData($id); $peso = $data->peso; $idC = $data->idC; if($move == "up"){ $query = "SELECT MAX(peso) AS prev_peso FROM modelli WHERE peso < $peso AND idC = $idC"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $prev_peso = $row->prev_peso; $query = "UPDATE modelli SET peso = $peso WHERE peso = $prev_peso"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } $query = "UPDATE modelli SET peso = $prev_peso WHERE id = $id"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } } if($move == "down"){ $query = "SELECT MIN(peso) AS next_peso FROM modelli WHERE peso > $peso AND idC = $idC"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } $row = $result->fetchRow(DB_FETCHMODE_OBJECT); $next_peso = $row->next_peso; $query = "UPDATE modelli SET peso = $peso WHERE peso = $next_peso"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } $query = "UPDATE modelli SET peso = $next_peso WHERE id = $id"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } } return true; } // pubblica in homepage una modello // ritorna true / false function modelliPubblicahome($id, $status) { global $db_object; $query = "UPDATE modelli SET prima_pagina = 'no'"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } if($status == "on"){ $query = "UPDATE modelli SET prima_pagina = 'si' WHERE id = $id"; $result = $db_object->query($query); if(DB::IsError($result)) { echo $query; die($result->getMessage()); } } return true; } // modelli visible (rende visibile una modello) // return true / false function modelliVisible($id) { global $db_object; $query = "UPDATE modelli SET "; $query .= "visibile = 'si' "; $query .= "WHERE "; $query .= "id = "; $query .= "'".$id."'"; $result = $db_object->query($query); if(DB::IsError($result)) { return false; } else { return true; } } // modelli invisible (rende invisibile una modello) // return true / false function modelliInvisible($id) { global $db_object; $query = "UPDATE modelli SET "; $query .= "visibile = 'no' "; $query .= "WHERE "; $query .= "id = "; $query .= "'".$id."'"; $result = $db_object->query($query); if(DB::IsError($result)) { return false; } else { return true; } } /************************* * FUNZIONI PER IL FRONT * *************************/ // elenco modelli dato idC // return data array / false function modelliListFront($lang, $idC = false) { global $db_object; $maxChar = 140; if(!$idC) { $query = "SELECT id, titolo_$lang AS titolo, accessorio, IF(LENGTH(dex_$lang)>$maxChar, CONCAT(LEFT(dex_$lang, $maxChar),'...'), dex_$lang) AS dex FROM modelli WHERE visibile = 'si' ORDER BY peso"; } else { $query = "SELECT id, titolo_$lang AS titolo, accessorio, IF(LENGTH(dex_$lang)>$maxChar, CONCAT(LEFT(dex_$lang, $maxChar),'...'), dex_$lang) AS dex FROM modelli WHERE visibile = 'si' AND idC = $idC ORDER BY peso"; } $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $dataArray = Array(); while($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) { $dataArray[] = $row; } return $dataArray; } // elenco modelli per listino dato idC // return data array / false function modelliPricelist($lang, $idC = false) { global $db_object; if(!$idC) { $query = "SELECT id, titolo_$lang AS titolo, dexList_$lang AS dex, accessorio, packing, price FROM modelli WHERE visibile = 'si' ORDER BY peso"; } else { $query = "SELECT id, titolo_$lang AS titolo, dexList_$lang AS dex, accessorio, packing, price FROM modelli WHERE visibile = 'si' AND idC = $idC ORDER BY peso"; } $result = $db_object->query($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $dataArray = Array(); while($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) { $dataArray[] = $row; } return $dataArray; } // elenco modelli search idC // return data array / false function modelliSearchList($lang, $keywords, $and_or="or", $kwd_only=false) { global $db_object; $maxChar = 140; $keywords = strtolower($keywords); $keywords = trim($keywords); $keywords_array = split("( +)", $keywords); $keywords_array = array_unique($keywords_array); if ($and_or == 'or') { $and_or_op = ' || '; } elseif ($and_or == 'and') { $and_or_op = ' AND '; } if ($kwd_only == true) { $kwd_op = ""; } else { $kwd_op = '%'; } $like_str_1 = ""; $col = 'titolo_'.$lang; for($i=0; $iquery($query); if(DB::IsError($result)) { //die($result->getMessage()); return false; } $dataArray = Array(); while($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) { $dataArray[] = $row; } //echo $query; return $dataArray; } // dati del modello pubblicato in home // return data array / false function modelliHomepageData($lang) { global $db_object; $maxChar = 180; $query = "SELECT DISTINCT id, titolo_$lang AS titolo, accessorio, IF(LENGTH(dex_$lang)>$maxChar, CONCAT(LEFT(dex_$lang, $maxChar),'...'), dex_$lang) AS dex FROM modelli WHERE prima_pagina = 'si'"; $result = $db_object->query($query); if(DB::IsError($result)) { //echo $query; die($result->getMessage()); return false; } return $result->fetchRow(DB_FETCHMODE_OBJECT); } ?> Bakery oven equipment and supplies - Convection oven
bakery machines italy bakery machines france bakery machines spain

Bakery oven equipment and supplies

Model: Convection ovens serie CONVE

electric or gas convection...

zoom

electric or gas convection oven with mechanical or digital controls. inernal and external construction in stainless steel of the highest quality, equipped with a rounded chamber to facilitate cleaning, door in tempered crystal with sealing gasket in siliconized rubber, electric heating with burner in stainless steel. the oven is also equipped with two fans that rotate in both directions; baking is optimized thanks to the perfect heating system and the possibility of inserting steam as needed. the capacity is for either 5, 10 or 16 trays measuring 40x60 or 45x65 depending on the model. version with programmable computer (80 programs) on request. Line BRio inoX comprises convection ovens with and without humidifier. ideals for
the baking of all the types of brioches, pizzette, cakes and dept freeze or precooked bread. they are therefore indispensable for bar, snack-bar, paninoteche, pizzerie, and self-service.



Model: Convection ovens serie BRIO

The line of ovens BRio...

zoom

The line of ovens BRio completes the range of pastry and bakery ovens
• Convection electrical or gas ovens, for 3/4/5/6/10/16 trays, further enhanced by size 400x600 mm
• Made entirely in AISI 304 stainless steel.
• motor with two-way running direction and double speed.
• Digital controls and programmable board (on request).
• Three-layer, hardened glass door, with glass chamber.