$_SESSION['cart']->remove($_POST['products_id'][$i]); } else { if (DECIMAL_CART_QUANTITY == '1') { $_POST['cart_quantity'][$i] = str_replace(',', '.', $_POST['cart_quantity'][$i]); } $products_order_min = oos_get_products_quantity_order_min($_POST['products_id'][$i]); $products_order_units = oos_get_products_quantity_order_units($_POST['products_id'][$i]); if ($_POST['cart_quantity'][$i] >= $products_order_min) { if ($_POST['cart_quantity'][$i] % $products_order_units == 0) { $attributes = $_POST['id'][$_POST['products_id'][$i]] ? $_POST['id'][$_POST['products_id'][$i]] : ''; $_SESSION['cart']->add_cart($_POST['products_id'][$i], $_POST['cart_quantity'][$i], $attributes, false, $_POST['to_wl_id'][$i]); } else { $_SESSION['error_cart_msg'] = trim($_SESSION['error_cart_msg']) . '<br />' . trim(oos_image(OOS_IMAGES . 'pixel_trans.gif', '', '11', '10') . $aLang['error_products_quantity_order_min_text'] . ' ' . oos_get_products_name($_POST['products_id'][$i]) . ' - ' . $aLang['error_products_units_invalid'] . ' ' . $_POST['cart_quantity'][$i] . ' - ' . $aLang['products_order_qty_unit_text_cart'] . ' ' . $products_order_units); } } else { $_SESSION['error_cart_msg'] = trim($_SESSION['error_cart_msg']) . '<br />' . trim(oos_image(OOS_IMAGES . 'pixel_trans.gif', '', '11', '10') . $aLang['error_products_quantity_order_min_text'] . ' ' . oos_get_products_name($_POST['products_id'][$i]) . ' - ' . $aLang['error_products_quantity_invalid'] . ' ' . $_POST['cart_quantity'][$i] . ' - ' . $aLang['products_order_qty_min_text_cart'] . ' ' . $products_order_min); } } } $_SESSION['navigation']->remove_last_page(); MyOOS_CoreApi::redirect(oos_href_link($goto_file, oos_get_all_get_parameters($parameters), 'NONSSL')); break; case 'add_product': // customer adds a product from the products page if (isset($_POST['products_id']) && is_numeric($_POST['products_id'])) { if (isset($_POST['edit_product'])) { $_SESSION['cart']->remove($_POST['edit_product']); } $real_ids = $_POST['id']; // File_upload if (isset($_POST['number_of_uploads']) && is_numeric($_POST['number_of_uploads']) && $_POST['number_of_uploads'] > 0) {
$sql = "SELECT p.products_id, p.products_image FROM $orders_productstable opa, $orders_productstable opb, $orderstable o, $productstable p WHERE opa.products_id = '" . intval($nProductsId) . "' AND opa.orders_id = opb.orders_id AND opb.products_id != '" . intval($nProductsId) . "' AND opb.products_id = p.products_id AND opb.orders_id = o.orders_id AND p.products_status >= '1' AND (p.products_access = '0' OR p.products_access = '" . intval($nGroupID) . "') GROUP BY p.products_id ORDER BY o.date_purchased DESC"; $orders_result = $dbconn->SelectLimit($sql, MAX_DISPLAY_ALSO_PURCHASED); $num_products_ordered = $orders_result->RecordCount(); if ($num_products_ordered >= MIN_DISPLAY_ALSO_PURCHASED) { while ($orders = $orders_result->fields) { $aPurchased[] = array('products_name' => oos_get_products_name($orders['products_id']), 'products_id' => $orders['products_id'], 'products_image' => $orders['products_image']); // Move that ADOdb pointer! $orders_result->MoveNext(); } } }
$products_name = $products_name_result->fields; $reviewstable = $oostable['reviews']; $reviews_average_result = $dbconn->Execute("SELECT (avg(reviews_rating) / 5 * 100) as average_rating FROM {$reviewstable} WHERE products_id = '" . $reviews['products_id'] . "'"); $reviews_average = $reviews_average_result->fields; $review_info = array_merge($reviews_text, $reviews_average, $products_name); $rInfo_array = array_merge($reviews, $review_info, $products_image); $rInfo = new objectInfo($rInfo_array); } if (isset($rInfo) && is_object($rInfo) && $reviews['reviews_id'] == $rInfo->reviews_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=preview') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id'] . '&action=preview') . '">' . oos_image(OOS_IMAGES . 'icons/preview.gif', ICON_PREVIEW) . '</a> ' . oos_get_products_name($reviews['products_id']); ?> </td> <td class="dataTableContent" align="right"><?php echo oos_image(OOS_HTTP_SERVER . OOS_SHOP . OOS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif'); ?> </td> <td class="dataTableContent" align="right"><?php echo oos_date_short($reviews['date_added']); ?> </td> <td class="dataTableContent" align="right"><?php if (isset($rInfo) && is_object($rInfo) && $reviews['reviews_id'] == $rInfo->reviews_id) { echo oos_image(OOS_IMAGES . 'icon_arrow_right.gif'); } else { echo '<a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id']) . '">' . oos_image(OOS_IMAGES . 'icon_information.gif', IMAGE_ICON_INFO) . '</a>';
$product = $product_result->fields; $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $products_subimage1_name = $pInfo->products_subimage1; $products_subimage2_name = $pInfo->products_subimage2; $products_subimage3_name = $pInfo->products_subimage3; $products_subimage4_name = $pInfo->products_subimage4; $products_subimage5_name = $pInfo->products_subimage5; $products_subimage6_name = $pInfo->products_subimage6; } $form_action = $_GET['pID'] ? 'update_product' : 'insert_product'; echo oos_draw_form($form_action, $aFilename['products'], 'categories=' . $categories . '&pID=' . $_GET['pID'] . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"'); $languages = oos_get_languages(); for ($i = 0, $n = count($languages); $i < $n; $i++) { if (isset($_GET['read']) && $_GET['read'] == 'only') { $pInfo->products_name = oos_get_products_name($pInfo->products_id, $languages[$i]['id']); $pInfo->products_description = oos_get_products_description($pInfo->products_id, $languages[$i]['id']); $pInfo->products_description_meta = oos_get_products_description_meta($pInfo->products_id, $languages[$i]['id']); $pInfo->products_keywords_meta = oos_get_products_keywords_meta($pInfo->products_id, $languages[$i]['id']); $pInfo->products_url = oos_get_products_url($pInfo->products_id, $languages[$i]['id']); } else { $pInfo->products_name = oos_db_prepare_input($products_name[$languages[$i]['id']]); $pInfo->products_description = oos_db_prepare_input($_POST['products_description_' . $languages[$i]['id']]); $pInfo->products_description_meta = oos_db_prepare_input($_POST['products_description_meta_' . $languages[$i]['id']]); $pInfo->products_keywords_meta = oos_db_prepare_input($_POST['products_keywords_meta_' . $languages[$i]['id']]); $pInfo->products_url = oos_db_prepare_input($products_url[$languages[$i]['id']]); } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr>
} if (!$_GET['search']) { echo '<a href="' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&action=new_category') . '">' . oos_image_swap_button('newcategorie', 'new_category_off.gif', IMAGE_NEW_CATEGORY) . '</a> <a href="' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&action=new_product') . '">' . oos_image_swap_button('newprodukt', 'new_product_off.gif', IMAGE_NEW_PRODUCT) . '</a>'; } ?> </td> </tr> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'slave_products': $heading[] = array('text' => '<b>' . oos_get_products_name($pInfo->products_id, $_SESSION['language_id']) . '</b>'); $contents = array('form' => oos_draw_form('new_slave_product', $aFilename['categories'], 'action=new_slave_product&categories=' . $categories . '&pID=' . $pInfo->products_id, 'post', 'enctype="multipart/form-data"')); $contents[] = array('text' => '<br />' . TEXT_ADD_SLAVE_PRODUCT . '<br />' . oos_draw_input_field('slave_product_id', '', 'size="10"')); $contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('save', 'save_off.gif', IMAGE_SAVE) . ' <a href="' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $pInfo->products_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>'); $contents[] = array('text' => '<br />' . TEXT_CURRENT_SLAVE_PRODUCTS); $slave_table_result = $dbconn->Execute("SELECT p2m.master_id, p2m.slave_id FROM " . $oostable['products_to_master'] . " p2m WHERE master_id = '" . $pInfo->products_id . "'"); while ($slave_table = $slave_table_result->fields) { $slave_products_result = $dbconn->Execute("SELECT p.products_id, p.products_slave_visible, pd.products_name FROM " . $oostable['products'] . " p , " . $oostable['products_description'] . " pd WHERE p.products_id = pd.products_id AND p.products_id = '" . $slave_table['slave_id'] . "' AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name LIMIT 1"); $slave_products = $slave_products_result->fields; if ($slave_products['products_slave_visible'] == 1) { $contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=0&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">' . oos_image(OOS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_RED_LIGHT) . '</a>'); } else { $contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=1&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">' . oos_image(OOS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_GREEN_LIGHT) . '</a>'); } // Move that ADOdb pointer! $slave_table_result->MoveNext();
<td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td> <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_SORT_ORDER_VALUE; ?> </td> <td class="dataTableHeadingContent" align="right"> <?php echo TABLE_HEADING_OPT_PRICE; ?> </td> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_OPT_PRICE_PREFIX; ?> </td> <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <tr> <td colspan="8"><?php echo oos_black_line(); ?></td> </tr> <?php $next_id = 1; $rows = 0; $attributes = $dbconn->Execute($attributes); while ($attributes_values = $attributes->fields) { $products_name_only = oos_get_products_name($attributes_values['products_id']); $options_name = oos_options_name($attributes_values['options_id']); $values_name = oos_values_name($attributes_values['options_values_id']); $rows++; ?> <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>"> <?php if (($action == 'update_attribute') && ($_GET['attribute_id'] == $attributes_values['products_attributes_id'])) { ?> <td class="smallText"> <?php echo $attributes_values['products_attributes_id']; ?><input type="hidden" name="attribute_id" value="<?php echo $attributes_values['products_attributes_id']; ?>"> </td> <td class="smallText"> <select name="products_id"> <?php $productstable = $oostable['products']; $products_descriptiontable = $oostable['products_description']; $products = $dbconn->Execute("SELECT p.products_id, pd.products_name FROM $productstable p, $products_descriptiontable pd WHERE pd.products_id = p.products_id AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name"); while($products_values = $products->fields) {
---------------------------------------------------------------------- Released under the GNU General Public License ---------------------------------------------------------------------- */ /** ensure this file is being included by a parent file */ defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.'); if (!$oEvent->installed_plugin('notify')) { return false; } $notifications_block = '0'; if (isset($_GET['products_id'])) { if (!isset($nProductsId)) { $nProductsId = oos_get_product_id($_GET['products_id']); } $notifications_block = '1'; if (!isset($block_get_parameters)) { $block_get_parameters = oos_get_all_get_parameters(array('action')); $block_get_parameters = oos_remove_trailing($block_get_parameters); $oSmarty->assign('get_params', $block_get_parameters); } if (isset($_SESSION['customer_id'])) { $products_notificationstable = $oostable['products_notifications']; $query = "SELECT COUNT(*) AS total\n FROM {$products_notificationstable}\n WHERE products_id = '" . intval($nProductsId) . "'\n AND customers_id = '" . intval($_SESSION['customer_id']) . "'"; $check = $dbconn->Execute($query); $notification_exists = $check->fields['total'] > 0 ? true : false; } else { $notification_exists = false; } $products_name = oos_get_products_name($nProductsId); $oSmarty->assign(array('notification_exists' => $notification_exists, 'products_name' => $products_name, 'block_heading_notifications' => $block_heading)); } $oSmarty->assign('notifications_block', $notifications_block);
Copyright (c) 2003 osCommerce ---------------------------------------------------------------------- Released under the GNU General Public License ---------------------------------------------------------------------- */ /** ensure this file is being included by a parent file */ defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.'); if ($oEvent->installed_plugin('customer_must_login')) { return false; } $whats_new_block = '0'; $productstable = $oostable['products']; $query = "SELECT products_id, products_image, products_tax_class_id, products_units_id, products_price,\n products_base_price, products_base_unit, products_discount_allowed\n FROM {$productstable}\n WHERE products_status >= '1'\n AND (products_access = '0' OR products_access = '" . intval($nGroupID) . "')\n ORDER BY products_date_added DESC"; if ($random_product = oos_random_select($query, MAX_RANDOM_SELECT_NEW)) { $whats_new_block = '1'; $random_product['products_name'] = oos_get_products_name($random_product['products_id']); $whats_new_product_price = ''; $whats_new_product_special_price = ''; $whats_new_max_product_discount = 0; $whats_new_product_discount_price = ''; $whats_new_base_product_price = ''; $whats_new_base_product_special_price = ''; $whats_new_special_price = ''; if ($_SESSION['member']->group['show_price'] == 1) { $whats_new_special_price = oos_get_products_special_price($random_product['products_id']); $whats_new_product_price = $oCurrencies->display_price($random_product['products_price'], oos_get_tax_rate($random_product['products_tax_class_id'])); if (oos_is_not_null($whats_new_product_price)) { $whats_new_product_special_price = $oCurrencies->display_price($whats_new_special_price, oos_get_tax_rate($random_product['products_tax_class_id'])); } else { $whats_new_max_product_discount = min($random_product['products_discount_allowed'], $_SESSION['member']->group['discount']); if ($whats_new_max_product_discount != 0) {