public static function getHandlerInformation() { global $db; DbIoHandler::loadHandlerMessageFile('Products'); $manufacturers_options = array(); $manufacturers_info = $db->Execute("SELECT manufacturers_id as `id`, manufacturers_name as `text` FROM " . TABLE_MANUFACTURERS . " ORDER BY manufacturers_name ASC"); while (!$manufacturers_info->EOF) { $manufacturers_options[] = $manufacturers_info->fields; $manufacturers_info->MoveNext(); } unset($manufacturers_info); $status_options = array(array('id' => 'all', 'text' => DBIO_PRODUCTS_TEXT_STATUS_ALL), array('id' => '1', 'text' => DBIO_PRODUCTS_TEXT_STATUS_ENABLED), array('id' => '0', 'text' => DBIO_PRODUCTS_TEXT_STATUS_DISABLED)); $categories_options = zen_get_category_tree(); unset($categories_options[0]); $my_config = array('version' => '1.0.0', 'handler_version' => '1.0.0', 'include_header' => true, 'export_only' => false, 'description' => DBIO_PRODUCTS_DESCRIPTION, 'export_filters' => array('products_filters' => array('type' => 'array', 'label' => DBIO_PRODUCTS_FILTERS_LABEL, 'fields' => array('products_status' => array('type' => 'dropdown', 'dropdown_options' => $status_options, 'label' => DBIO_PRODUCTS_STATUS_LABEL))))); if (count($manufacturers_options) > 0) { $my_config['export_filters']['products_filters']['fields']['products_manufacturers'] = array('type' => 'dropdown_multiple', 'dropdown_options' => $manufacturers_options, 'label' => DBIO_PRODUCTS_MANUFACTURERS_LABEL); } $my_config['export_filters']['products_filters']['fields']['products_categories'] = array('type' => 'dropdown_multiple', 'dropdown_options' => array_values($categories_options), 'label' => DBIO_PRODUCTS_CATEGORIES_LABEL); return $my_config; }
</tr> <tr> <td class="main"><?php echo TEXT_SALEMAKER_DATE_END; ?> </td> <td class="main"><script language="javascript">EndDate.writeControl(); EndDate.dateFormat="<?php echo DATE_FORMAT_SPIFFYCAL; ?> ";</script></td> </tr> </table> </tr> <tr><table width="750" border="0" cellspacing="2" cellpadding="2"> <?php $categories_array = zen_get_category_tree('0', ' ', '0'); $n = sizeof($categories_array); for ($i = 0; $i < $n; $i++) { $parents = $db->Execute("select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . $categories_array[$i]['id'] . "' "); $categories_array[$i]['parent_id'] = $parents->fields['parent_id']; $categories_array[$i]['categories_id'] = $categories_array[$i]['id']; $categories_array[$i]['path'] = $categories_array[$i]['categories_id']; $categories_array[$i]['indent'] = 0; $parent = $categories_array[$i]['parent_id']; while ($parent != 0) { $categories_array[$i]['indent']++; for ($j = 0; $j < $n; $j++) { if ($categories_array[$j]['categories_id'] == $parent) { $categories_array[$i]['path'] = $parent . '_' . $categories_array[$i]['path']; $parent = $categories_array[$j]['parent_id']; break;
$products->MoveNext(); } ?> <td class="smallText" valign="top"><?php echo HEADER_CATEGORY_NAME; ?> </td> <td class="smallText" align="left"></td><form name="restrict_product" method="post" action="<?php echo zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'info=' . $cInfo->restrict_id, 'NONSSL'); ?> "> <?php echo zen_hide_session_id(); ?> <td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('cPath_prod', zen_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); ?> </td></form> <?php if (sizeof($products_array) > 0) { ?> <form name="restrict_category" method="post" action="<?php echo zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=add_product&info=' . $cInfo->restrict_id . '&build_cat=' . $current_category_id, 'NONSSL'); ?> "><?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?> <td class="smallText" valign="top"><?php echo HEADER_PRODUCT_NAME; ?> </td>
<?php // // +----------------------------------------------------------------------+ // |zen-cart Open Source E-commerce | // +----------------------------------------------------------------------+ // | Copyright (c) 2003 The zen-cart developers | // | | // | http://www.zen-cart.com/index.php | // | | // | Portions Copyright (c) 2003 osCommerce | // +----------------------------------------------------------------------+ // | This source file is subject to version 2.0 of the GPL license, | // | that is bundled with this package in the file LICENSE, and is | // | available through the world-wide-web at the following url: | // | http://www.zen-cart.com/license/2_0.txt. | // | If you did not receive a copy of the zen-cart license and are unable | // | to obtain it through the world-wide-web, please send a note to | // | license@zen-cart.com so we can mail you a copy immediately. | // +----------------------------------------------------------------------+ // $Id: sidebox_move_product.php 290 2004-09-15 19:48:26Z wilt $ // $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_PRODUCT . '</b>'); $contents = array('form' => zen_draw_form('products', $type_admin_handler, 'action=move_product_confirm&cPath=' . $cPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . zen_draw_hidden_field('products_id', $pInfo->products_id)); $contents[] = array('text' => sprintf(TEXT_MOVE_PRODUCTS_INTRO, $pInfo->products_name)); $contents[] = array('text' => '<br />' . TEXT_INFO_CURRENT_CATEGORIES . '<br /><b>' . zen_output_generated_category_path($pInfo->products_id, 'product') . '</b>'); $contents[] = array('text' => '<br />' . sprintf(TEXT_MOVE, $pInfo->products_name) . '<br />' . zen_draw_pull_down_menu('move_to_category_id', zen_get_category_tree(), $current_category_id)); $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
</td> </tr> <tr> <td> <?php echo zen_draw_form('bulk_add_tare_groups', FILENAME_TARE_GROUPS_BULK); echo zen_draw_hidden_field('bulk_add_tare_groups', 'true'); ?> <table> <tr> <td><?php echo 'Category: '; ?> </td> <td><?php echo zen_draw_pull_down_menu('category', zen_get_category_tree()); ?> </td> </tr> <tr> <td><?php echo TEXT_PRODUCT_TARE_GROUPS . ': '; ?> </td> <td><?php echo zen_draw_pull_down_menu('products_tare_group', $tare_group_array); ?> </td> </tr> <tr> <td colspan="2">
case 'copy_to': $copy_attributes_delete_first = '0'; $copy_attributes_duplicates_skipped = '0'; $copy_attributes_duplicates_overwrite = '0'; $copy_attributes_include_downloads = '1'; $copy_attributes_include_filename = '1'; $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_COPY_TO . '</b>'); // WebMakers.com Added: Split Page if (empty($pInfo->products_id)) { $pInfo->products_id = $pID; } $contents = array('form' => zen_draw_form('copy_to', FILENAME_CATEGORIES, 'action=copy_to_confirm&cPath=' . $cPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . zen_draw_hidden_field('products_id', $pInfo->products_id)); $contents[] = array('text' => TEXT_INFO_COPY_TO_INTRO); $contents[] = array('text' => '<br />' . TEXT_INFO_CURRENT_PRODUCT . '<br /><b>' . $pInfo->products_name . ' ID#' . $pInfo->products_id . '</b>'); $contents[] = array('text' => '<br />' . TEXT_INFO_CURRENT_CATEGORIES . '<br /><b>' . zen_output_generated_category_path($pInfo->products_id, 'product') . '</b>'); $contents[] = array('text' => '<br />' . TEXT_CATEGORIES . '<br />' . zen_draw_pull_down_menu('categories_id', zen_get_category_tree(), $current_category_id)); $contents[] = array('text' => '<br />' . TEXT_HOW_TO_COPY . '<br />' . zen_draw_radio_field('copy_as', 'link', true) . ' ' . TEXT_COPY_AS_LINK . '<br />' . zen_draw_radio_field('copy_as', 'duplicate') . ' ' . TEXT_COPY_AS_DUPLICATE); // only ask about attributes if they exist if (zen_has_product_attributes($pInfo->products_id, 'false')) { $contents[] = array('text' => '<br />' . zen_image(DIR_WS_IMAGES . 'pixel_black.gif', '', '100%', '3')); $contents[] = array('text' => '<br />' . TEXT_COPY_ATTRIBUTES_ONLY); $contents[] = array('text' => '<br />' . TEXT_COPY_ATTRIBUTES . '<br />' . zen_draw_radio_field('copy_attributes', 'copy_attributes_yes', true) . ' ' . TEXT_COPY_ATTRIBUTES_YES . '<br />' . zen_draw_radio_field('copy_attributes', 'copy_attributes_no') . ' ' . TEXT_COPY_ATTRIBUTES_NO); // future $contents[] = array('align' => 'center', 'text' => '<br />' . ATTRIBUTES_NAMES_HELPER . '<br />' . zen_draw_separator('pixel_trans.gif', '1', '10')); $contents[] = array('text' => '<br />' . zen_image(DIR_WS_IMAGES . 'pixel_black.gif', '', '100%', '3')); } $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_copy.gif', IMAGE_COPY) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; // attribute features // attribute features case 'attribute_features': $copy_attributes_delete_first = '0';
<td align="center" class="main"><a href="<?php echo zen_href_link($curr_page, "products_filter=" . $previous . '¤t_category_id=' . $current_category_id); ?> "><?php echo zen_image_button('button_prev.gif', BUTTON_PREVIOUS_ALT); ?> </a> </td> <?php } ?> <td align="left" class="main"><?php echo zen_draw_form('new_category', $curr_page, '', 'get'); ?> <?php echo zen_draw_pull_down_menu('current_category_id', zen_get_category_tree('', '', '0', '', '', true), $current_category_id, 'onChange="this.form.submit();"'); echo zen_draw_hidden_field('products_filter', $_GET['products_filter']); echo zen_hide_session_id(); echo zen_draw_hidden_field('action', 'new_cat'); ?> </form></td> <?php if ($counter > 0) { ?> <td align="center" class="main"> <a href="<?php echo zen_href_link($curr_page, "products_filter=" . $next_item . '¤t_category_id=' . $current_category_id); ?> "><?php echo zen_image_button('button_next.gif', BUTTON_NEXT_ALT); ?>
case 'delete': $heading[] = array('text' => '<strong>' . TEXT_HEADING_DELETE_MEDIA_COLLECTION . '</strong>'); $contents = array('form' => zen_draw_form('collections', FILENAME_MEDIA_MANAGER, 'page=' . $_GET['page'] . '&mID=' . $mInfo->media_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_DELETE_INTRO); $contents[] = array('text' => '<br><strong>' . $mInfo->media_name . '</strong>'); if ($mInfo->products_count > 0) { $contents[] = array('text' => '<br>' . zen_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS); $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $mInfo->products_count)); } $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . zen_href_link(FILENAME_MEDIA_MANAGER, 'page=' . $_GET['page'] . '&mID=' . $mInfo->media_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; case 'products': $new_product_query = $db->Execute("select ptc.*, pd.products_name from " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on ptc.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "' where ptc.categories_id='" . $current_category_id . "' order by pd.products_name"); $heading[] = array('text' => '<strong>' . TEXT_HEADING_ASSIGN_MEDIA_COLLECTION . '</strong>'); $contents[] = array('text' => TEXT_PRODUCTS_INTRO . '<br /><br />'); $contents[] = array('text' => zen_draw_form('new_category', FILENAME_MEDIA_MANAGER, '', 'get') . ' ' . zen_draw_pull_down_menu('current_category_id', zen_get_category_tree('', '', '0'), '', 'onChange="this.form.submit();"') . zen_hide_session_id() . zen_draw_hidden_field('products_filter', $_GET['products_filter']) . zen_draw_hidden_field('action', 'new_cat') . zen_draw_hidden_field('mID', $mInfo->media_id) . zen_draw_hidden_field('page', $_GET['page']) . ' </form>'); $product_array = $zc_products->get_products_in_category($current_category_id, false); if ($product_array) { $contents[] = array('text' => zen_draw_form('new_product', FILENAME_MEDIA_MANAGER, '', 'get') . ' ' . zen_draw_pull_down_menu('current_product_id', $product_array) . ' ' . '<input type="submit" name="add_product" value="Add">' . zen_draw_hidden_field('current_category_id', $current_category_id) . zen_draw_hidden_field('action', 'add_product') . zen_draw_hidden_field('page', $_GET['page']) . zen_draw_hidden_field('mID', $mInfo->media_id) . ' </form>'); } else { $contents[] = array('text' => ' ' . TEXT_NO_PRODUCTS); } $products_linked_query = "select * from " . TABLE_MEDIA_TO_PRODUCTS . "\n where media_id = '" . $mInfo->media_id . "'"; $products_linked = $db->Execute($products_linked_query); while (!$products_linked->EOF) { $contents[] = array('text' => '<a href="' . zen_href_link(FILENAME_MEDIA_MANAGER, 'action=remove_product&mID=' . $mInfo->media_id . '&page=' . $_GET['page'] . '&product_id=' . $products_linked->fields['product_id']) . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a> ' . $zc_products->products_name($products_linked->fields['product_id']) . '<br />'); $products_linked->MoveNext(); } $contents[] = array('align' => 'center', 'text' => '<br /><a href="' . zen_href_link(FILENAME_MEDIA_MANAGER, 'page=' . $_GET['page'] . '&mID=' . $mInfo->media_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default:
$products->MoveNext(); } echo '</select><br />' . "\n"; } ?> <?php if ($categories->RecordCount() > 0) { echo '<label for="categories">' . LABEL_CATEGORIES . '</label>' . "\n"; $categories_size = $categories->RecordCount() > 10 ? 10 : $categories->RecordCount(); /* echo '<select name="categories[]" multiple="multiple" size="' . $categories_size . '">' . "\n"; while (!$categories->EOF) { echo '<option value="' . $categories->fields['categories_id'] . '">' . $categories->fields['categories_name'] . '</option>' . "\n"; $categories->MoveNext(); }*/ echo zen_draw_pull_down_menu('categories[]', zen_get_category_tree('', '', '0', '', '', true, false, array(TAGS_MASTER_CATEGORY_ID)), '', 'multiple="multiple" size="' . $categories_size . '"'); echo '</select><br />' . "\n"; } ?> <label for="discount_amount"><?php echo LABEL_DISCOUNT_AMOUNT; ?> </label> <?php echo zen_draw_input_field('discount_amount', '', 'size=10 id="discount_amount"'); ?> <label id="discountType"><?php echo LABEL_DISCOUNT_TYPE; ?> </label>
echo zen_draw_hidden_field('basemodulepath', $modulePath, 'id="basemodulepath" '); $model = array(); $model[] = array('id' => '', 'text' => TEXT_PLEASE_SELECT); if ($_REQUEST['cPath1'] != "") { $model = array_merge($model, $dropdownArray); } if (isset($_REQUEST['select_model'])) { $value = $_REQUEST['select_model']; } echo '<span class="pf_selectbox_name">' . TEXT_MODEL . '</span>' . zen_draw_pull_down_menu('select_model', $model, $value, 'id="select_model" class="pf_selectbox_text"'); echo "</li>\n"; echo "<li>"; echo "<noscript>"; if ($_REQUEST['select_model'] != "") { $value = $_REQUEST['select_model']; $dropdownArray = zen_get_category_tree($value); } echo zen_my_image_submit(PF_NOSCRIPT_SUBMIT, 'Go'); echo "</noscript>"; echo "</li>\n"; echo "<li>"; $year = array(); $year[] = array('id' => '', 'text' => TEXT_PLEASE_SELECT); if ($_REQUEST['select_model'] != "") { $year = array_merge($year, $dropdownArray); } if (isset($_REQUEST['cPath'])) { $value = $_REQUEST['cPath']; } if ($_REQUEST['select_model'] != "") { echo '<span class="pf_selectbox_name">' . TEXT_YEAR . '</span>' . zen_draw_pull_down_menu('cPath', $year, $value, 'id="select_year" class="pf_selectbox_text"');
function zen_get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false, $category_has_products = false, $limit = false) { global $gBitDb; if ($limit) { $limit_count = 1; } else { $limit_count = 100; } if (!is_array($category_tree_array)) { $category_tree_array = array(); } if (sizeof($category_tree_array) < 1 && $exclude != '0') { $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP); } if ($include_itself) { $category = $gBitDb->Execute("SELECT cd.`categories_name`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_CATEGORIES_DESCRIPTION . " cd\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE cd.`language_id` = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand cd.`categories_id` = '" . (int) $parent_id . "'"); $category_tree_array[] = array('id' => $parent_id, 'text' => $category->fields['categories_name']); } $categories = $gBitDb->Execute("SELECT c.`categories_id`, cd.`categories_name`, c.`parent_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE c.`categories_id` = cd.`categories_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand cd.`language_id` = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand c.`parent_id` = '" . (int) $parent_id . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY c.`sort_order`, cd.`categories_name`"); while (!$categories->EOF) { if ($category_has_products == true and zen_products_in_category_count($categories->fields['categories_id'], '', false, true) >= 1) { $mark = '*'; } else { $mark = ' '; } if ($exclude != $categories->fields['categories_id']) { $category_tree_array[] = array('id' => $categories->fields['categories_id'], 'text' => $spacing . $categories->fields['categories_name'] . $mark); } $category_tree_array = zen_get_category_tree($categories->fields['categories_id'], $spacing . ' ', $exclude, $category_tree_array, '', $category_has_products); $categories->MoveNext(); } return $category_tree_array; }
$delete_product = FALSE; while (!$products_types->EOF) { if ($products_types->fields['type_handler'] . '.php' == $filename) { $delete_product = TRUE; break; } $products_types->MoveNext(); } if ($delete_product && $_GET['action'] == 'delete_product_confirm' && $_POST['products_id'] > 0) { $products_id = zen_db_prepare_input($_POST['products_id']); $query = 'delete from ' . TABLE_CUSTOMERS_VIEWED_PRODUCTS . ' where products_id="' . $products_id . '"'; $db->Execute($query); } else { if ($filename == FILENAME_CATEGORIES . '.php' && $_GET['action'] == 'delete_category_confirm' && $_POST['categories_id'] > 0) { $categories_id = zen_db_prepare_input($_POST['categories_id']); $categories = zen_get_category_tree($categories_id, '', '0', '', true); zen_set_time_limit(600); for ($i = 0, $n = sizeof($categories); $i < $n; $i++) { $sql = "select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $categories[$i]['id'] . "'"; $category_products = $db->Execute($sql); while (!$category_products->EOF) { $query = 'delete from ' . TABLE_CUSTOMERS_VIEWED_PRODUCTS . ' where products_id="' . $category_products->fields['products_id'] . '"'; $db->Execute($query); $category_products->MoveNext(); } } } else { if ($filename == FILENAME_CUSTOMERS . '.php' && $_GET['action'] == 'deleteconfirm' && $_GET['cID'] > 0) { $customers_id = zen_db_prepare_input($_GET['cID']); $query = 'delete from ' . TABLE_CUSTOMERS_VIEWED_PRODUCTS . ' where customers_id="' . (int) $customers_id . '"'; $db->Execute($query);
} else { ?> <?php echo zen_draw_form('quantity_discounts', FILENAME_QUANTITIY_DISCOUNTS, '', 'post'); ?> <table cellspacing="0" cellpadding="5" id="table_info"> <tr> <th> Categories Qty Discounts </th> </tr> <tr> <td> <?php echo zen_draw_pull_down_menu('cat_id', zen_get_category_tree(), isset($category_id) ? $category_id : '', ' onchange="this.form.submit();"'); ?> <br/><br/>Or Input Categoriy Id <br/><br/> <?php echo zen_draw_input_field('cat_id_input', ''); ?> </td> </tr> </table> <?php echo '</form>'; } ?> </td>
$csv_format_id = $_SESSION['product_csv']['csv_format_id']; } if (array_key_exists('ignore_first_line', $_SESSION['product_csv'])) { $ignore_first_line = $_SESSION['product_csv']['ignore_first_line']; } unset($_SESSION['product_csv']); } $body = '<tr><th>' . zen_draw_form('import', FILENAME_ADDON_MODULES_ADMIN, 'module=product_csv&action=import', 'post', 'enctype="multipart/form-data"') . PRODUCT_CSV_IMPORT_TITLE . '</th></tr><tr><td>' . PRODUCT_CSV_IMPORT_MESSAGE . '<table border="0" width="100%" cellspacing="0" cellpadding="0" class="tableLayout3"><tr><th width="40%"> <label for="format">' . PRODUCT_CSV_FORMAT . ': </label></th><td>' . zen_draw_pull_down_menu('csv_format_id', $formats, '', 'id="format"') . '</td></tr> <tr><th width="40%"><label for="ignore">' . PRODUCT_CSV_IGNORE_FIRST_LINE . ': </label>' . zen_draw_checkbox_field('ignore_first_line', 'ignore', false, '', 'id="ignore"') . zen_draw_hidden_field('MAX_FILE_SIZE', return_bytes(ini_get(upload_max_filesize))) . '</th><td>' . zen_draw_file_field('file') . ' <input type="submit" name="upfile" value="' . PRODUCT_CSV_IMPORT_BUTTON . '" disabled="disabled" id="upfile"/><br/> </form></td></tr></table></tr><tr><th>' . zen_draw_form('export', FILENAME_ADDON_MODULES_ADMIN, 'module=product_csv&action=export', 'post') . PRODUCT_CSV_EXPORT_TITLE . '</th></tr><tr><td><table border="0" width="100%" cellspacing="0" cellpadding="0" class="tableLayout3"> <tr> <th width="40%"><label for="format">' . PRODUCT_CSV_FORMAT . ': </label></th><td>' . zen_draw_pull_down_menu('csv_format_id', $formats, '', 'id="format"') . '</td> </tr> <tr> <th width="40%"><label for="category">' . PRODUCT_CSV_EXPORT_CATEGORY . ': </label></th><td>' . zen_draw_pull_down_menu('category_id', zen_get_category_tree(), '', 'id="category"') . '</td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="downfile" value="' . PRODUCT_CSV_EXPORT_BUTTON . '"/></td> </form> </tr> </table> </td></tr>'; } $zco_notifier->notify('NOTIFY_PRODUCT_CSV_FINISH_BODY_GENERATE'); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?> >
$catcount++; for ($i = 1; $i < $catcount; $i++) { $texttempcat2 = $categoriesarr[$i][text]; $idtempcat2 = $categoriesarr[$i][id]; $categoriesarr[$i][id] = $idtempcat1; $categoriesarr[$i][text] = $texttempcat1; $texttempcat1 = $texttempcat2; $idtempcat1 = $idtempcat2; } $categoriesarr[0][text] = "Choose Category"; $categoriesarr[0][id] = 0.5; $categoryselectoutput = zen_draw_pull_down_menu('add_product_categories_id', $categoriesarr, $current_category_id, 'onChange="this.form.submit();"'); $categoryselectoutput = str_replace('<option value="0" SELECTED>', '<option value="0">', $categoryselectoutput); $categoryselectoutput = str_replace('<option value=".5">', '<option value=".5" SELECTED>', $categoryselectoutput); } else { $categoryselectoutput = zen_draw_pull_down_menu('add_product_categories_id', zen_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); } echo "<tr class='dataTableRow'>" . zen_draw_form('add_prdct', FILENAME_ORDER_EDIT, zen_get_all_get_params(array('action', 'oID')) . 'oID=' . $oID . '&action=add_prdct', 'post', '', true); // echo "<tr class=\"dataTableRow\"><form action='$PHP_SELF?oID=$oID&action=$action' method='POST'>\n"; echo "<td class='dataTableContent' align='right'><strong>" . ADDPRODUCT_TEXT_STEP1 . "</strong></td><td class='dataTableContent' valign='top'>"; echo ' ' . $categoryselectoutput; echo "<input type='hidden' name='step' value='2'>"; echo "</td>\n"; echo "</form></tr>\n"; echo "<tr><td colspan='3'> </td></tr>\n"; // Step 2: Choose Product if ($step > 1 && $add_product_categories_id != 0.5) { echo "<tr class='dataTableRow'>" . zen_draw_form('add_prdct', FILENAME_ORDER_EDIT, zen_get_all_get_params(array('action', 'oID')) . 'oID=' . $oID . '&action=add_prdct', 'post', '', true); // echo "<tr class=\"dataTableRow\"><form action='$PHP_SELF?oID=$oID&action=$action' method='post'>\n"; echo "<td class='dataTableContent' align='right'><strong>" . ADDPRODUCT_TEXT_STEP2 . "</strong></td><td class='dataTableContent' valign='top'><select name=\"add_product_products_id\" onChange=\"this.form.submit();\">"; $ProductOptions = "<option value='0'>" . ADDPRODUCT_TEXT_SELECT_PRODUCT . "\n";
function zen_get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false, $category_has_products = false, $limit = false) { global $db; if ($limit) { $limit_count = " limit 1"; } else { $limit_count = ''; } if (!is_array($category_tree_array)) { $category_tree_array = array(); } if (sizeof($category_tree_array) < 1 && $exclude != '0') { $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP); } if ($include_itself) { $category = $db->Execute("select cd.categories_name\n from " . TABLE_CATEGORIES_DESCRIPTION . " cd\n where cd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and cd.categories_id = '" . (int) $parent_id . "'"); $category_tree_array[] = array('id' => $parent_id, 'text' => $category->fields['categories_name']); } $categories = $db->Execute("select c.categories_id, cd.categories_name, c.parent_id\n from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd\n where c.categories_id = cd.categories_id\n and cd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n and c.parent_id = '" . (int) $parent_id . "'\n order by c.sort_order, cd.categories_name"); while (!$categories->EOF) { if ($category_has_products == true and zen_products_in_category_count($categories->fields['categories_id'], '', false, true) >= 1) { $mark = '*'; } else { $mark = ' '; } if ($exclude != $categories->fields['categories_id']) { $category_tree_array[] = array('id' => $categories->fields['categories_id'], 'text' => $spacing . $categories->fields['categories_name'] . $mark); } $category_tree_array = zen_get_category_tree($categories->fields['categories_id'], $spacing . ' ', $exclude, $category_tree_array, '', $category_has_products); $categories->MoveNext(); } return $category_tree_array; }
<?php global $gBitSmarty; $gBitSmarty->assign('currentCategoryId', $current_category_id); $gBitSmarty->assign('catMenu', zen_draw_pull_down_menu('cPath', zen_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"')); $catListHash = $_REQUEST; if (isset($_GET['search'])) { $prodListHash['search'] = $_GET['search']; $catListHash['search'] = $_GET['search']; } else { $catListHash['parent_id'] = $current_category_id; } $catCount = 0; if ($catList = CommerceCategory::getList($catListHash)) { $catCount = count($catList); if ($gCommerceSystem->isConfigActive('SHOW_COUNTS_ADMIN')) { foreach (array_keys($catList) as $catId) { $catList[$catId]['total_products'] = zen_get_products_to_categories($catId, true); $catList[$catId]['total_products_on'] = zen_get_products_to_categories($catId, false); } } $gBitSmarty->assign('catList', $catList); $gBitSmarty->assign('catListHash', $catListHash); } $gBitSmarty->assign('catCount', $catCount); $product = new CommerceProduct(); $offset = new splitPageResults($_GET['page'], MAX_DISPLAY_RESULTS_CATEGORIES, $products_query_raw, $products_query_numrows); $prodListHash = $_REQUEST; $prodListHash['all_status'] = 1; $prodListHash['category_id'] = $current_category_id; if ($prodList = $product->getList($prodListHash)) {
if (isset($_GET['search']) && zen_not_null($_GET['search'])) { $keywords = zen_db_input(zen_db_prepare_input($_GET['search'])); echo '<br />' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords; } echo '</form>'; ?> </td> </tr> <tr> <td class="smallText" align="right"> <?php if ($_SESSION['display_categories_dropdown'] == 0) { echo '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'set_display_categories_dropdown=1&cID=' . $categories->fields['categories_id'] . '&cPath=' . $cPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image(DIR_WS_ICONS . 'cross.gif', IMAGE_ICON_STATUS_OFF) . '</a> '; echo zen_draw_form('goto', FILENAME_CATEGORIES, '', 'get'); echo zen_hide_session_id(); echo HEADING_TITLE_GOTO . ' ' . zen_draw_pull_down_menu('cPath', zen_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"'); echo '</form>'; } else { echo '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'set_display_categories_dropdown=0&cID=' . $categories->fields['categories_id'] . '&cPath=' . $cPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image(DIR_WS_ICONS . 'tick.gif', IMAGE_ICON_STATUS_ON) . '</a> '; echo HEADING_TITLE_GOTO; } ?> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr>
if ($ep_uses_mysqli) { $manufacturers_query = mysqli_query($db->link, "SELECT manufacturers_id, manufacturers_name FROM " . TABLE_MANUFACTURERS . " ORDER BY manufacturers_name"); while ($manufacturers = mysqli_fetch_array($manufacturers_query)) { $manufacturers_array[] = array("id" => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']); } } else { $manufacturers_query = mysql_query("SELECT manufacturers_id, manufacturers_name FROM " . TABLE_MANUFACTURERS . " ORDER BY manufacturers_name"); while ($manufacturers = mysql_fetch_array($manufacturers_query)) { $manufacturers_array[] = array("id" => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']); } } $status_array = array(array("id" => '1', 'text' => "Status"), array("id" => '1', 'text' => "active"), array("id" => '0', 'text' => "inactive"), array("id" => '3', 'text' => "all")); $export_type_array = array(array("id" => '0', 'text' => "Download Type"), array("id" => '0', 'text' => "Complete Products"), array("id" => '1', 'text' => "Model/Price/Qty"), array("id" => '2', 'text' => "Model/Price/Breaks")); echo "<b>Filterable Exports:</b><br>"; echo zen_draw_pull_down_menu('ep_export_type', $export_type_array) . ' '; echo ' ' . zen_draw_pull_down_menu('ep_category_filter', array_merge(array(0 => array("id" => '', 'text' => "Categories")), zen_get_category_tree())) . ' '; echo ' ' . zen_draw_pull_down_menu('ep_manufacturer_filter', $manufacturers_array) . ' '; echo ' ' . zen_draw_pull_down_menu('ep_status_filter', $status_array) . ' '; echo zen_draw_input_field('export', 'Export', ' style="padding: 0px"', false, 'submit'); ?> <br /><br> </div> <b>Product & Pricing Export/Import Options:</b><br /> <!-- Download file links --> <a href="easypopulate_4.php?export=full"><b>Complete Products</b> (with Metatags)</a><br /> <a href="easypopulate_4.php?export=priceqty"><b>Model/Price/Qty</b> (with Specials)</a><br /> <a href="easypopulate_4.php?export=pricebreaks"><b>Model/Price/Breaks</b></a><br /> <a href="easypopulate_4.php?export=featured"><b>Featured Products</b></a><br />
$sql = "select ptc.*\n from " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd\n on ptc.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n where ptc.categories_id='" . $current_category_id . "'\n order by pd.products_name"; $new_product_query = $db->Execute($sql); $products_filter = $new_product_query->fields['products_id']; zen_redirect(zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, 'products_filter=' . $products_filter . '¤t_category_id=' . $current_category_id)); } // set categories and products if not set if ($products_filter == '' and $current_category_id != '') { $sql = "select ptc.*\n from " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd\n on ptc.products_id = pd.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n where ptc.categories_id='" . $current_category_id . "'\n order by pd.products_name"; $new_product_query = $db->Execute($sql); $products_filter = $new_product_query->fields['products_id']; if ($products_filter != '') { zen_redirect(zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, 'products_filter=' . $products_filter . '¤t_category_id=' . $current_category_id)); } } else { if ($products_filter == '' and $current_category_id == '') { $reset_categories_id = zen_get_category_tree('', '', '0', '', '', true); $current_category_id = $reset_categories_id[0]['id']; $sql = "select ptc.*\n from " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd\n on ptc.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n where ptc.categories_id='" . $current_category_id . "'\n order by pd.products_name"; $new_product_query = $db->Execute($sql); $products_filter = $new_product_query->fields['products_id']; $_GET['products_filter'] = $products_filter; } } require DIR_WS_MODULES . FILENAME_PREV_NEXT; if (zen_not_null($action)) { $_SESSION['page_info'] = ''; if (isset($_GET['option_page'])) { $_SESSION['page_info'] .= 'option_page=' . $_GET['option_page'] . '&'; } if (isset($_GET['value_page'])) { $_SESSION['page_info'] .= 'value_page=' . $_GET['value_page'] . '&';
bit_redirect($_SERVER['SCRIPT_NAME'] . '?cid=' . $gCoupon->mCouponId); break; case 'Add': $gCoupon->storeRestriction($_REQUEST); bit_redirect($_SERVER['SCRIPT_NAME'] . '?cid=' . $gCoupon->mCouponId); break; case 'remove': if (!empty($_GET['info'])) { $gBitDb->query("delete from " . TABLE_COUPON_RESTRICT . " where restrict_id = ?", array($_GET['info'])); } bit_redirect($_SERVER['SCRIPT_NAME'] . '?cid=' . $gCoupon->mCouponId); break; } } if (isset($_POST['cPath_prod'])) { $current_category_id = $_POST['cPath_prod']; } else { $_POST['cPath_prod'] = NULL; } $productsList = $gBitDb->getAssoc("select p.`products_id`, pd.`products_name` from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.`products_id` = pd.`products_id` and pd.`language_id` = ? and p.`products_id` = p2c.`products_id` and p2c.`categories_id` = ? order by pd.`products_name`", array($_SESSION['languages_id'], $_POST['cPath_prod'])); $gBitSmarty->assign_by_ref('productsList', $productsList); $gBitSmarty->assign_by_ref('gCoupon', $gCoupon); require_once BITCOMMERCE_PKG_PATH . 'classes/CommerceProductManager.php'; $productManager = new CommerceProductManager(); $gBitSmarty->assign('optionsList', $productManager->getOptionsList()); $categoryTree = zen_get_category_tree(); $gBitSmarty->assign('categorySelect', zen_draw_pull_down_menu('category_id', $categoryTree, $current_category_id)); $gBitSmarty->assign('productCategorySelect', zen_draw_pull_down_menu('cPath_prod', $categoryTree, $current_category_id, 'onChange="this.form.submit();"')); $gBitSmarty->assign('productTypes', $productManager->getProductTypes()); $gBitSmarty->assign_by_ref('feedback', $feedback); $gBitSystem->display('bitpackage:bitcommerce/admin_coupon_restrict.tpl', HEADING_TITLE, array('display_mode' => 'admin'));
while (!$classes->EOF) { $tax_class_array[] = array('id' => $classes->fields['tax_class_id'], 'text' => $classes->fields['tax_class_title']); $classes->MoveNext(); } // eof get tx classes // bof get manufacturers $manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER)); //$manufacturers_array = array(array('id' => '0', 'text' => TEXT_ALL_MANUFACTURERS)); $manufacturers = $db->Execute("select manufacturers_id, manufacturers_name\n from " . TABLE_MANUFACTURERS . "\n order by manufacturers_name"); while (!$manufacturers->EOF) { $manufacturers_array[] = array('id' => $manufacturers->fields['manufacturers_id'], 'text' => $manufacturers->fields['manufacturers_name']); $manufacturers->MoveNext(); } // eof get manufacturers // bof get category_tree $quick_updates_category_tree = zen_get_category_tree(); // eof get category_tree // bof Update database switch ($_GET['action']) { case 'update': // bof prepare al new data for database input if (sizeof($_POST['quick_updates_new']) > 0) { foreach ($_POST['quick_updates_new'] as $key => $value) { // $value is an array here (contains values like ['products_model'][$products_id] = '1' for example) $_POST['quick_updates_new'][$key] = zen_db_prepare_input($value); } } // eof prepare al new data for database input $quick_updates_count = array(); if ($_POST['quick_updates_new']['products_model']) { foreach ($_POST['quick_updates_new']['products_model'] as $products_id => $new_value) {
function delete_category($categories_id) { global $db, $zc_products; // future cat specific deletion $delete_linked = 'true'; if ($_POST['delete_linked'] == 'delete_linked_no') { $delete_linked = 'false'; } else { $delete_linked = 'true'; } // delete category and products $categories_id = zen_db_prepare_input($categories_id); // create list of any subcategories in the selected category, $categories = zen_get_category_tree($categories_id, '', '0', '', true); zen_set_time_limit(600); // loop through this cat and subcats for delete-processing. for ($i = 0, $n = sizeof($categories); $i < $n; $i++) { $sql = "select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $categories[$i]['id'] . "'"; $category_products = $db->Execute($sql); while (!$category_products->EOF) { // determine product-type-specific override script for this product $product_type = zen_get_products_type($category_products->fields['products_id']); // now loop thru the delete_product_confirm script for each product in the current category if (file_exists(DIR_WS_MODULES . $zc_products->get_handler($product_type) . '/delete_product_confirm.php')) { require DIR_WS_MODULES . $zc_products->get_handler($product_type) . '/delete_product_confirm.php'; } else { require DIR_WS_MODULES . 'delete_product_confirm.php'; } // THIS LINE COMMENTED BECAUSE IT'S DONE ALREADY DURING DELETE_PRODUCT_CONFIRM.PHP: //zen_remove_product($category_products->fields['products_id'], $delete_linked); $category_products->MoveNext(); } zen_remove_category($categories[$i]['id']); } // end for loop }