Opiniones de NoCocinoMas.es

0) { $_POST['fecIni'] = date('Y-m-d',strtotime('now -365 DAY')); $_POST['fecFin'] = date('Y-m-d',strtotime('now +1 DAY')); $_POST['procesar'] = 'S'; $_POST['products_id'] = $_GET['products_id']; $_POST['valoracion']='-1'; $_POST['soloComentarios']=false; $_POST['quitarDukan']=false; $_POST['cantidad']='-1'; } $status_array = array(); $texto_query = "SELECT distinct pl.name products_name,po.products_id,valoracion,po.cantidad,comentario,fec_ult_act,po.orders_id,lote " . "FROM ps_products_opinion po join ps_product_lang pl on (po.products_id=pl.id_product) ". "left JOIN ps_trazabilidad ot on (ot.id_order=po.orders_id and ot.id_product=po.products_id) " . /* "left JOIN ps_osc_products_fabricado pf on (pf.products_id=ot.products_id and pf.fecha=ot.fechaLote and pf.cantidad>5) ". "left JOIN ps_osc_empleados e on (pf.quien=e.idEmpleado) " .*/ "where po.fec_ult_act between '" . $_POST['fecIni'] . "' and '" . $_POST['fecFin'] . "' "; //echo $texto_query; if ($_POST['procesar']=='S' and $_POST['valoracion']<>'-1') { $texto_query .= "and valoracion=".$_POST['valoracion']." and valoracion<>'' "; } if ($_POST['procesar']=='S' and $_POST['soloComentarios']) { $texto_query .= "and length(comentario)>1 "; } if ($_POST['procesar']=='S' and $_POST['quitarDukan']) { $texto_query .= "and name not like '%DUKAN%' "; } if ($_POST['procesar']=='S' and $_POST['cantidad']<>'-1') { $texto_query .= "and po.cantidad=".$_POST['cantidad']." and po.cantidad<>'' "; } if ($_POST['procesar']=='S' and $_POST['products_id']<>'-1') { $texto_query .= "and po.products_id=".$_POST['products_id']." "; } if ($_POST['procesar']=='S' and $_POST['palabras']<>'') { $texto_query .= "and po.comentario like '%".$_POST['palabras']."%' "; } //if ($_POST['procesar']=='S' and ($_POST['valoracion']<>'-1' or $_POST['cantidad']<>'-1')) { if ($_GET['products_id']) { $texto_query .= " order by lote desc"; } else { $texto_query .= " order by po.fec_ult_act desc "; } $texto_query .= " limit 5000"; //exit($texto_query); $status_query = tep_db_query($texto_query); //echo $texto_query; $valoracion_array[] = array('id'=>'-1','text'=>'Todas'); $valoracion_array[] = array('id'=>'0','text'=>'No me gusto'); $valoracion_array[] = array('id'=>'1','text'=>'Me gusto'); $valoracion_array[] = array('id'=>'2','text'=>'Muy rico'); $cantidad_array[] = array('id'=>'-1','text'=>'Todas'); $cantidad_array[] = array('id'=>'0','text'=>'Poca cantidad'); $cantidad_array[] = array('id'=>'1','text'=>'Bien de Cantidad'); $soloComentarios_array[] = array('id'=>'0','text'=>'No'); $soloComentarios_array[] = array('id'=>'1','text'=>'Si'); $tipoInforme_array[] = array('id'=>'0','text'=>'Por Meses'); $tipoInforme_array[] = array('id'=>'1','text'=>'Por Trimestres'); $products_array = array(); $products_query = tep_db_query("select id_product products_id,name products_name from ps_product_lang order by name"); $products_array[] = array('id' => '-1', 'text' => '0 Todos los Platos'); while ($products_values = tep_db_fetch_array($products_query)) { $products_array[] = array('id' => $products_values['products_id'], 'text' => $products_values['products_name']); } ?> Opiniones de NoCocinoMas.es

Total de productos

Proceso Realizado Correctamente

"") { ?>

Nombre	Valoracion	Cantidad	Lote	Comentario	Fecha Comentario	N. Pedido
	No me gusto'; } ?>	Poca Cantidad'; } ?>

0) { echo 'Nota Media:'.round($nota/$opiniones,3).' (2:Nota Maxima 1:Normal 0:No gusto)
Basado en '.$opiniones.' opiniones
'; echo ''.round(100*$opinionesNegativas/$opiniones,3).'% de las opiniones son Negativas'; } ?>