?> <html> <head> <title>Products List</title> <link rel="stylesheet" type="text/css" href="../templates/default.css" /> </head> <body> <div id="area-result"> <div><?php echo $title; ?> </div> <div class="display-area ui-corner-all" style="margin-top:10px; display: block; width: 1000px;"> <?php echo drawOutlinePlan($pids); echo '<div style="page-break-after:always;"></div>'; $query = "SELECT p.products_id, p.products_model, p.products_image, p.products_price, p.products_price_old, p.stars, cat.categories_id, cd.categories_name FROM products p"; $query .= " LEFT JOIN products_to_categories cat ON cat.products_id=p.products_id"; $query .= " LEFT JOIN categories_description cd ON cd.categories_id=cat.categories_id AND cd.language_id='1'"; $query .= " WHERE p.products_id IN (" . $pids . ") ORDER BY cat.categories_id"; $result = tep_db_query($query); while ($row = tep_db_fetch_array($result)) { $cat[$row['categories_name']][] = array("id" => $row['products_id'], "image" => $row['products_image'], "price" => $row['products_price'], "price_old" => $row['products_price_old'], "model" => $row['products_model'], "stars" => $row['stars']); } foreach ($cat as $key => $value) { echo '<div style="clear:both;"></div>'; $total_prods = 0; $total_disc = 0; $content = '<div style="margin:0 auto 20px auto;">'; foreach ($value as $list) {
$h['e'] = $row['info']; $h['a'] = $row['updated_by']; $histories[] = $h; } $content .= utf8_encode(tep_draw_table('main_center', $histories)); $content .= '</div>'; //#prostyle-tab4 } $content .= '<div id="prostyle-tab5">'; $prod_querys = tep_db_query("SELECT shp.products_id FROM styles_has_products shp\n LEFT JOIN products p ON p.products_id=shp.products_id\n LEFT JOIN products_description pd ON pd.products_id=shp.products_id AND pd.language_id='1'\n WHERE shp.styles_id={$styles_id}\n ORDER BY shp.date_added DESC"); $prods_ids = array(); while ($row = tep_db_fetch_array($prod_querys)) { $prods_ids[] = $row['products_id']; } $prod_ids = implode(",", $prods_ids); $content .= drawOutlinePlan($prod_ids); $content .= '</div>'; //#prostyle-tab5 } $content .= '</div>'; if (isset($obj_pa) && is_object($obj_pa)) { $javascript .= $obj_pa->getAttachmentsAsObject()->drawAttachmentJSAction(''); } $javascript .= ' $("#product-style").tabs(); $("#style-desc-tabs").tabs(); $("#style-desc-tabs").tabs("select", 1); $("input[name=back]").click(function() { top.window.closePopup(); }); ' . ($reloadlist ? 'top.window.reloadList();' : '') . '