<td class="{sorter: 'idoDate'}"><?php
echo $row['fecha'];
?>
</td>
<td title="<?php
echo $row['nombre'];
?>
" class="may" ><?php
echo recortar_texto($row['nombre'], 35, " ", " [+]");
?>
</td>
<td title="<?php
echo $row['titulo'];
?>
" class="may" ><?php
echo recortar_texto($row['titulo'], 35, " ", " [+]");
?>
</td>
<td style="text-align: right; padding-right: 10px;">
<?php
$sqlc = "SELECT precio, cantidad\n\t\t\t\t\tFROM kng_conceptos\n\t\t\t\t\tWHERE proforma = '" . $row['faid'] . "'\n\t\t\t\t\t";
$resc = mysql_query($sqlc);
$tutti = 0;
while ($rowc = mysql_fetch_array($resc)) {
$tutti += $rowc['precio'] * $rowc['cantidad'];
}
echo number_format($tutti, 2, ',', '.') . ' €';
?>
</td>
<td><?php
echo ivafecha($row['fecha']) . '%';
function productList($category = '')
{
require_once '../../Model/ProductClass.php';
global $viewLogin;
if (!$viewLogin) {
header('Location: ../Front/controller.php?f=index');
}
global $navegadorAdmin;
global $connection;
$navegador = $navegadorAdmin;
$titulo = 'Titulo';
$description = 'description';
$palabrasClaves = 'palabrasClaves';
$send = '';
if (isset($_GET['s'])) {
$send = $_GET['s'];
}
if ($category == '') {
$sql = 'SELECT * FROM `product` WHERE name LIKE \'%' . $send . '%\'';
// }elseif($_GET['s'] == ''){
} else {
$sql = 'SELECT * FROM `product` WHERE `idCategory` = \'' . $category . '\' AND name LIKE \'%' . $send . '%\'';
}
$requete = $connection->commitSelect($sql);
foreach ($requete as $key => $value) {
$product = new ProductClass($connection);
$product->fetch($value['idRow']);
if (!isset($product->imgs[0]['name'])) {
$img = 'not-found.png';
} else {
$img = $product->imgs[0]['name'];
}
$listProducts[] = array('name' => $product->name, 'description' => recortar_texto($product->description), 'longDescription' => recortar_texto($product->longDescription), 'price' => $product->price, 'category' => $product->category, 'img' => $img, 'id' => $product->id);
}
// cargarlo de categorias
$options = array(array('value' => '1', 'string' => 'Book'), array('value' => '2', 'string' => 'Music'));
require_once '../../View/Back/productList.php';
}
