本文整理汇总了PHP中zen_update_products_price_sorter函数的典型用法代码示例。如果您正苦于以下问题:PHP zen_update_products_price_sorter函数的具体用法?PHP zen_update_products_price_sorter怎么用?PHP zen_update_products_price_sorter使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了zen_update_products_price_sorter函数的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: zen_start_specials
function zen_start_specials()
{
global $db;
$date_range = time();
$zc_specials_date = date('Ymd', $date_range);
// turn on special if active
$specials_query = "select specials_id, products_id\r\n from " . TABLE_SPECIALS . "\r\n where status = '0'\r\n and (((specials_date_available <= " . $zc_specials_date . " and specials_date_available != '0001-01-01') and (expires_date > " . $zc_specials_date . "))\r\n or ((specials_date_available <= " . $zc_specials_date . " and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01'))\r\n or (specials_date_available = '0001-01-01' and expires_date > " . $zc_specials_date . "))\r\n ";
$specials = $db->Execute($specials_query);
if ($specials->RecordCount() > 0) {
while (!$specials->EOF) {
zen_set_specials_status($specials->fields['specials_id'], '1');
zen_update_products_price_sorter($specials->fields['products_id']);
$specials->MoveNext();
}
}
// turn off special if not active yet
$specials_query = "select specials_id, products_id\r\n from " . TABLE_SPECIALS . "\r\n where status = '1'\r\n and (" . $zc_specials_date . " < specials_date_available and specials_date_available != '0001-01-01')\r\n ";
$specials = $db->Execute($specials_query);
if ($specials->RecordCount() > 0) {
while (!$specials->EOF) {
zen_set_specials_status($specials->fields['specials_id'], '0');
zen_update_products_price_sorter($specials->fields['products_id']);
$specials->MoveNext();
}
}
}
开发者ID:ygeneration666,项目名称:ec,代码行数:26,代码来源:specials.php
示例2: foreach
// changed INSERT INTO to UPDATE to prevent conflicts
$db->Execute("UPDATE " . TABLE_PRODUCTS_TO_CATEGORIES . " SET categories_id='" . (int) $new_value . "', products_id=" . (int) $products_id . " WHERE products_id=" . (int) $products_id . " AND categories_id=" . (int) $_POST['quick_updates_old']['categories_id'][$products_id]);
}
}
}
if ($_POST['quick_updates_new']['master_categories_id']) {
foreach ($_POST['quick_updates_new']['master_categories_id'] as $products_id => $new_value) {
if ($_POST['quick_updates_new']['master_categories_id'][$products_id] != $_POST['quick_updates_old']['master_categories_id'][$products_id]) {
if (zen_childs_in_category_count($new_value)) {
$messageStack->add(TEXT_CATEGORY_WITH_CHILDS . ' ' . zen_get_category_name($new_value, (int) $_SESSION["languages_id"]) . ' [' . $new_value . ']', 'error');
continue;
}
// add invalid warning here?? (if the new master_cat is not linked)
$quick_updates_count['master_categories_id'][$products_id] = $products_id;
$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET master_categories_id='" . (int) $new_value . "', products_last_modified=now() WHERE products_id=" . (int) $products_id);
zen_update_products_price_sorter((int) $products_id);
// needed?
}
}
}
// added for products_purchase_price and margin
if ($_POST['quick_updates_new']['products_purchase_price']) {
foreach ($_POST['quick_updates_new']['products_purchase_price'] as $products_id => $new_value) {
if ($_POST['quick_updates_new']['products_purchase_price'][$products_id] != $_POST['quick_updates_old']['products_purchase_price'][$products_id]) {
$quick_updates_count['products_purchase_price'][$products_id] = $products_id;
$db->Execute("UPDATE " . TABLE_PRODUCTS . " SET products_purchase_price='" . $new_value . "', products_last_modified=now() WHERE products_id =" . (int) $products_id);
}
}
}
// added for products_purchase_price and margin
if ($_POST['quick_updates_new']['products_margin']) {
开发者ID:happyxlq,项目名称:zencart_svn,代码行数:31,代码来源:quick_updates.php
示例3: zen_delete_products_attributes
}
break;
// @@TODO where is move_product_confirm
// @@TODO where is insert_product
// @@TODO where is update_product
// attribute features
// @@TODO where is move_product_confirm
// @@TODO where is insert_product
// @@TODO where is update_product
// attribute features
case 'delete_attributes':
zen_delete_products_attributes($_GET['products_id']);
$messageStack->add_session(SUCCESS_ATTRIBUTES_DELETED . ' ID#' . $_GET['products_id'], 'success');
$action = '';
// reset products_price_sorter for searches etc.
zen_update_products_price_sorter($_GET['products_id']);
zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
break;
case 'update_attributes_sort_order':
zen_update_attributes_products_option_values_sort_order($_GET['products_id']);
$messageStack->add_session(SUCCESS_ATTRIBUTES_UPDATE . ' ID#' . $_GET['products_id'], 'success');
$action = '';
zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
break;
// attributes copy to product
// attributes copy to product
case 'update_attributes_copy_to_product':
$copy_attributes_delete_first = $_POST['copy_attributes'] == 'copy_attributes_delete' ? '1' : '0';
$copy_attributes_duplicates_skipped = $_POST['copy_attributes'] == 'copy_attributes_ignore' ? '1' : '0';
$copy_attributes_duplicates_overwrite = $_POST['copy_attributes'] == 'copy_attributes_update' ? '1' : '0';
zen_copy_products_attributes($_POST['products_id'], $_POST['products_update_id']);
开发者ID:andychang88,项目名称:daddy-store.com,代码行数:31,代码来源:categories.php
示例4: zen_redirect
zen_redirect(zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, 'products_filter=' . $products_filter . '¤t_category_id=' . $_POST['current_category_id']));
break;
case 'delete_option_name_values':
$delete_attributes_options_id = $db->Execute("select * from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $_POST['products_filter'] . "' and options_id='" . $_POST['products_options_id_all'] . "'");
while (!$delete_attributes_options_id->EOF) {
// remove any attached downloads
$remove_downloads = $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id= '" . $delete_attributes_options_id->fields['products_attributes_id'] . "'");
// remove all option values
$delete_attributes_options_id_values = $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $_POST['products_filter'] . "' and options_id='" . $_POST['products_options_id_all'] . "'");
$delete_attributes_options_id->MoveNext();
}
$action = '';
$products_filter = $_POST['products_filter'];
$messageStack->add_session(SUCCESS_ATTRIBUTES_DELETED_OPTION_NAME_VALUES . ' ID#' . zen_options_name($_POST['products_options_id_all']), 'success');
// reset products_price_sorter for searches etc.
zen_update_products_price_sorter($products_filter);
zen_redirect(zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, 'products_filter=' . $products_filter . '¤t_category_id=' . $_POST['current_category_id']));
break;
// attributes copy to product
// attributes copy to product
case 'update_attributes_copy_to_product':
$copy_attributes_delete_first = $_POST['copy_attributes'] == 'copy_attributes_delete' ? '1' : '0';
$copy_attributes_duplicates_skipped = $_POST['copy_attributes'] == 'copy_attributes_ignore' ? '1' : '0';
$copy_attributes_duplicates_overwrite = $_POST['copy_attributes'] == 'copy_attributes_update' ? '1' : '0';
zen_copy_products_attributes($_POST['products_filter'], $_POST['products_update_id']);
$_GET['action'] = '';
$products_filter = $_POST['products_update_id'];
zen_redirect(zen_href_link(FILENAME_ATTRIBUTES_CONTROLLER, 'products_filter=' . $products_filter . '¤t_category_id=' . $_POST['current_category_id']));
break;
// attributes copy to category
// attributes copy to category
开发者ID:quangn92,项目名称:visualyou,代码行数:31,代码来源:attributes_controller.php
示例5: quick_copy_product
function quick_copy_product($products_id, $categories_id = '')
{
global $db;
if (!(isset($products_id) && isset($categories_id))) {
return FALSE;
}
// ??
$products_id = (int) $products_id;
// copy from this product (to a new product)
//$categories_id = zen_db_prepare_input($categories_id); // copy to this catagory
//if(!($products_id > 0)) return false;
if (!zen_products_id_valid($products_id)) {
exit('Fatal error: attempt to copy invalid product by quick_copy (products_id = ' . $products_id . ')');
}
// Copy attributes to duplicate product
$products_id_from = $products_id;
// bof duplicate
$old_products_id = (int) $products_id;
$product = $db->Execute("select products_type, products_quantity, products_model, products_image,\r\n products_price, products_virtual, products_date_available, products_weight,\r\n products_tax_class_id, manufacturers_id,\r\n products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute,\r\n product_is_free, product_is_call, products_quantity_mixed,\r\n product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order,\r\n products_price_sorter, master_categories_id\r\n from " . TABLE_PRODUCTS . "\r\n where products_id = '" . (int) $products_id . "'");
// bof replace product data by nimport product data (+ add purchase price)
// eof replace product data by nimport product data
$tmp_value = zen_db_input($product->fields['products_quantity']);
$products_quantity = !zen_not_null($tmp_value) || $tmp_value == '' || $tmp_value == 0 ? 0 : $tmp_value;
$tmp_value = zen_db_input($product->fields['products_price']);
$products_price = !zen_not_null($tmp_value) || $tmp_value == '' || $tmp_value == 0 ? 0 : $tmp_value;
$tmp_value = zen_db_input($product->fields['products_weight']);
$products_weight = !zen_not_null($tmp_value) || $tmp_value == '' || $tmp_value == 0 ? 0 : $tmp_value;
// check if categorie has products!?
if (!$categories_id >= 0) {
$categories_id = $product->fields['master_categories_id'];
}
$db->Execute("insert into " . TABLE_PRODUCTS . "\r\n (products_type, products_quantity, products_model, products_image,\r\n products_price, products_virtual, products_date_added, products_date_available,\r\n products_weight, products_status, products_tax_class_id,\r\n manufacturers_id,\r\n products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute,\r\n product_is_free, product_is_call, products_quantity_mixed,\r\n product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order,\r\n products_price_sorter, master_categories_id\r\n )\r\n values ('" . zen_db_input($product->fields['products_type']) . "',\r\n '" . $products_quantity . "',\r\n '" . zen_db_input($product->fields['products_model']) . "',\r\n '" . zen_db_input($product->fields['products_image']) . "',\r\n '" . $products_price . "',\r\n '" . zen_db_input($product->fields['products_virtual']) . "',\r\n now(),\r\n '" . zen_db_input($product->fields['products_date_available']) . "',\r\n '" . $products_weight . "', '0',\r\n '" . (int) $product->fields['products_tax_class_id'] . "',\r\n '" . (int) $product->fields['manufacturers_id'] . "',\r\n '" . zen_db_input($product->fields['products_quantity_order_min']) . "',\r\n '" . zen_db_input($product->fields['products_quantity_order_units']) . "',\r\n '" . zen_db_input($product->fields['products_priced_by_attribute']) . "',\r\n '" . (int) $product->fields['product_is_free'] . "',\r\n '" . (int) $product->fields['product_is_call'] . "',\r\n '" . (int) $product->fields['products_quantity_mixed'] . "',\r\n '" . zen_db_input($product->fields['product_is_always_free_shipping']) . "',\r\n '" . zen_db_input($product->fields['products_qty_box_status']) . "',\r\n '" . zen_db_input($product->fields['products_quantity_order_max']) . "',\r\n '" . zen_db_input($product->fields['products_sort_order']) . "',\r\n '" . zen_db_input($product->fields['products_price_sorter']) . "',\r\n '" . (int) $categories_id . "')");
$dup_products_id = $db->Insert_ID();
$description = $db->Execute("select language_id, products_name, products_description, products_url\r\n from " . TABLE_PRODUCTS_DESCRIPTION . "\r\n where products_id = '" . (int) $products_id . "'");
while (!$description->EOF) {
$db->Execute("insert into " . TABLE_PRODUCTS_DESCRIPTION . "\r\n (products_id, language_id, products_name, products_description, products_url, products_viewed)\r\n values ('" . (int) $dup_products_id . "',\r\n '" . (int) $description->fields['language_id'] . "',\r\n '" . zen_db_input($description->fields['products_name']) . "',\r\n '" . zen_db_input($description->fields['products_description']) . "',\r\n '" . zen_db_input($description->fields['products_url']) . "', '0')");
$description->MoveNext();
}
$db->Execute("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . "\r\n (products_id, categories_id)\r\n values ('" . (int) $dup_products_id . "', '" . (int) $categories_id . "')");
$products_id = $dup_products_id;
$description->MoveNext();
// FIX HERE
/////////////////////////////////////////////////////////////////////////////////////////////
// Copy attributes to duplicate product
$products_id_to = $dup_products_id;
$products_id = $dup_products_id;
/*
if ( $_POST['copy_attributes']=='copy_attributes_yes' and $_POST['copy_as'] == 'duplicate' ) {
// $products_id_to= $copy_to_products_id;
// $copy_attributes_delete_first='1';
// $copy_attributes_duplicates_skipped='1';
// $copy_attributes_duplicates_overwrite='0';
if (DOWNLOAD_ENABLED == 'true') {
$copy_attributes_include_downloads='1';
$copy_attributes_include_filename='1';
} else {
$copy_attributes_include_downloads='0';
$copy_attributes_include_filename='0';
}
zen_copy_products_attributes($products_id_from, $products_id_to);
}
*/
// EOF: Attributes Copy on non-linked
/////////////////////////////////////////////////////////////////////
// copy product discounts to duplicate
zen_copy_discounts_to_product($old_products_id, (int) $dup_products_id);
// eof duplicate
// reset products_price_sorter for searches etc.
zen_update_products_price_sorter($products_id);
//zen_redirect(zen_href_link(FILENAME_QUICK_COPY, 'cPath=' . $categories_id . '&pID=' . $products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
// succes
$copy['products_id'] = (int) $dup_products_id;
$copy['master_categories_id'] = (int) $categories_id;
return $copy;
}
开发者ID:dalinhuang,项目名称:cameras,代码行数:77,代码来源:quick_copy.php
示例6: zen_copy_products_attributes
/////////////////////////////////////////////////////////////////////////////////////////////
// Copy attributes to duplicate product
// moved above $products_id_from=zen_db_input($products_id);
$products_id_to = $dup_products_id;
$products_id = $dup_products_id;
if ($_POST['copy_attributes'] == 'copy_attributes_yes' and $_POST['copy_as'] == 'duplicate') {
// $products_id_to= $copy_to_products_id;
// $products_id_from = $pID;
// $copy_attributes_delete_first='1';
// $copy_attributes_duplicates_skipped='1';
// $copy_attributes_duplicates_overwrite='0';
if (DOWNLOAD_ENABLED == 'true') {
$copy_attributes_include_downloads = '1';
$copy_attributes_include_filename = '1';
} else {
$copy_attributes_include_downloads = '0';
$copy_attributes_include_filename = '0';
}
zen_copy_products_attributes($products_id_from, $products_id_to);
}
// EOF: Attributes Copy on non-linked
/////////////////////////////////////////////////////////////////////
// copy product discounts to duplicate
if ($_POST['copy_discounts'] == 'copy_discounts_yes') {
zen_copy_discounts_to_product($old_products_id, (int) $dup_products_id);
}
}
// reset products_price_sorter for searches etc.
zen_update_products_price_sorter($products_id);
}
zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
开发者ID:ZenMagick,项目名称:zc-base,代码行数:31,代码来源:copy_to_confirm.php
示例7: zen_update_salemaker_product_prices
function zen_update_salemaker_product_prices($salemaker_id)
{
global $db;
$zv_categories = $db->Execute("select sale_categories_selected from " . TABLE_SALEMAKER_SALES . " where sale_id = '" . $salemaker_id . "'");
$za_salemaker_categories = zen_parse_salemaker_categories($zv_categories->fields['sale_categories_selected']);
$n = sizeof($za_salemaker_categories);
for ($i = 0; $i < $n; $i++) {
$update_products_price = $db->Execute("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $za_salemaker_categories[$i] . "'");
while (!$update_products_price->EOF) {
zen_update_products_price_sorter($update_products_price->fields['products_id']);
$update_products_price->MoveNext();
}
}
}
开发者ID:severnaya99,项目名称:Sg-2010,代码行数:14,代码来源:functions_prices.php
示例8: while
while (!$all_products_attributes->EOF) {
$count++;
$product_id_updated .= ' - ' . $all_products_attributes->fields['products_id'] . ':' . $all_products_attributes->fields['products_attributes_id'];
zen_update_attributes_products_option_values_sort_order($all_products_attributes->fields['products_id']);
$all_products_attributes->MoveNext();
}
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_SORT_ALL, 'success');
$action = '';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
case 'update_all_products_price_sorter':
// reset products_price_sorter for searches etc.
$sql = "select products_id from " . TABLE_PRODUCTS;
$update_prices = $db->Execute($sql);
while (!$update_prices->EOF) {
zen_update_products_price_sorter($update_prices->fields['products_id']);
$update_prices->MoveNext();
}
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_PRODUCTS_PRICE_SORTER, 'success');
$action = '';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
case 'update_all_products_viewed':
// reset products_viewed to 0
$sql = "update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed= '0'";
$update_viewed = $db->Execute($sql);
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_PRODUCTS_VIEWED, 'success');
$action = '';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
case 'update_all_products_ordered':
开发者ID:dalinhuang,项目名称:cameras,代码行数:31,代码来源:store_manager.php
示例9: importRecordPostProcess
protected function importRecordPostProcess($products_id)
{
$this->debugMessage('Products::importRecordPostProcess: ' . $this->data_key_sql . "\n" . print_r($this->key_fields, true), self::DBIO_INFORMATIONAL);
if ($products_id !== false && $this->operation != 'check') {
zen_update_products_price_sorter($products_id);
}
}
开发者ID:lat9,项目名称:dbio,代码行数:7,代码来源:DbIoProductsHandler.php
示例10: ep_update_prices
function ep_update_prices()
{
global $db;
// reset products_price_sorter for searches etc.
$sql = "select products_id from " . TABLE_PRODUCTS;
$update_prices = $db->Execute($sql);
while (!$update_prices->EOF) {
zen_update_products_price_sorter($update_prices->fields['products_id']);
$update_prices->MoveNext();
}
}
开发者ID:R-Future,项目名称:zencart,代码行数:11,代码来源:easypopulate_functions.php
示例11: save_product
//.........这里部分代码省略.........
$sql_data_array = array('products_type' => $product['products_type'], 'products_quantity' => $product['products_quantity'], 'products_model' => $product['products_model'], 'products_image' => $products_image_name, 'products_price' => $product['products_price'], 'products_virtual' => $product['products_virtual'], 'products_date_available' => $product['products_date_available'] == "" ? 'null' : $product['products_date_available'], 'products_weight' => $product['products_weight'], 'products_status' => $product['products_status'], 'products_tax_class_id' => $product['products_tax_class_id'], 'manufacturers_id' => $product['manufacturers_id'], 'products_quantity_order_min' => $product['products_quantity_order_min'], 'products_quantity_order_units' => $product['products_quantity_order_units'], 'products_priced_by_attribute' => $product['products_priced_by_attribute'], 'product_is_free' => $product['product_is_free'], 'product_is_call' => $product['product_is_call'], 'products_quantity_mixed' => $product['products_quantity_mixed'], 'product_is_always_free_shipping' => $product['product_is_always_free_shipping'], 'products_qty_box_status' => $product['products_qty_box_status'], 'products_quantity_order_max' => $product['products_quantity_order_max'], 'products_sort_order' => $product['products_sort_order'], 'products_discount_type' => $product['products_discount_type'], 'products_discount_type_from' => $product['products_discount_type_from'], 'products_price_sorter' => $product['products_price'], 'master_categories_id' => (int) $product['categories'], 'products_mixed_discount_quantity' => $product['products_mixed_discount_quantity'], 'metatags_title_status' => $product['metatags_title_status'], 'metatags_products_name_status' => $product['metatags_products_name_status'], 'metatags_model_status' => $product['metatags_model_status'], 'metatags_price_status' => $product['metatags_price_status'], 'metatags_title_tagline_status' => $product['metatags_title_tagline_status']);
$product_save = $product;
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_BEFORE_SAVE_PRODUCTS');
if ($insert_products) {
$sql_data_array['products_date_added'] = 'now()';
zen_db_perform(TABLE_PRODUCTS, $sql_data_array);
$products_id = zen_db_insert_id();
} else {
$sql_data_array['products_last_modified'] = 'now()';
zen_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id=" . (int) $products_id);
}
// products_to_categories
// いったんすべてのカテゴリを削除後、追加する
$db->Execute("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id=" . (int) $products_id);
$array = explode(",", $product['categories_id']);
foreach ($array as $v) {
if ($v > 0) {
$sql_data_array = array('products_id' => $products_id, 'categories_id' => $v);
zen_db_perform(TABLE_PRODUCTS_TO_CATEGORIES, $sql_data_array);
}
}
// products_description
foreach ($product['products_description_products_name'] as $k => $v) {
$sql_data_array = array('products_id' => $products_id, 'language_id' => $k, 'products_name' => $product['products_description_products_name'][$k], 'products_description' => $product['products_description_products_description'][$k], 'products_url' => $product['products_description_products_url'][$k]);
$language_id = $k;
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_BEFORE_SAVE_PRODUCTS_DESCRIPTION');
if ($insert_products) {
zen_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);
} else {
zen_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id=" . (int) $products_id . " and language_id=" . $k);
}
}
// meta_tags_products_description
if (is_array($product['meta_tags_products_description_metatags_title'])) {
foreach ($product['meta_tags_products_description_metatags_title'] as $k => $v) {
$sql_data_array = array('products_id' => $products_id, 'language_id' => $k, 'metatags_title' => $product['meta_tags_products_description_metatags_title'][$k], 'metatags_keywords' => $product['meta_tags_products_description_metatags_keywords'][$k], 'metatags_description' => $product['meta_tags_products_description_metatags_description'][$k]);
$language_id = $k;
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_BEFORE_SAVE_META_TAGS_PRODUCTS_DESCRIPTION');
$query = "select * from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " where products_id=" . (int) $products_id . " and language_id=" . $k;
$check = $db->Execute($query);
if ($check->EOF) {
zen_db_perform(TABLE_META_TAGS_PRODUCTS_DESCRIPTION, $sql_data_array);
} else {
zen_db_perform(TABLE_META_TAGS_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id=" . (int) $products_id . " and language_id=" . $k);
}
}
}
// featured
if (isset($product['featured_status'])) {
if ($product['featured_expires_date'] == "") {
$product['featured_expires_date'] = '0001-01-01';
}
if ($product['featured_featured_date_available'] == "") {
$product['featured_featured_date_available'] = '0001-01-01';
}
if ($product['featured_status'] == 1) {
$sql_data_array = array('products_id' => $products_id, 'expires_date' => $product['featured_expires_date'], 'status' => $product['featured_status'], 'featured_date_available' => $product['featured_featured_date_available']);
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_BEFORE_SAVE_FEATURED');
if ($product['featured_featured_id'] == 0) {
$sql_data_array['featured_date_added'] = 'now()';
zen_db_perform(TABLE_FEATURED, $sql_data_array);
$product['featured_featured_id'] = zen_db_insert_id();
} else {
$sql_data_array['featured_last_modified'] = 'now()';
zen_db_perform(TABLE_FEATURED, $sql_data_array, "update", "featured_id=" . $product['featured_featured_id']);
}
} else {
$db->Execute("delete from " . TABLE_FEATURED . " where products_id=" . (int) $products_id);
}
}
// specials
if (isset($product['specials_price_status'])) {
if ($product['specials_expires_date'] == "") {
$product['specials_expires_date'] = '0001-01-01';
}
if ($product['specials_specials_date_available'] == "") {
$product['specials_specials_date_available'] = '0001-01-01';
}
if ($product['specials_price_status'] == 0 || $product['specials_price_status'] == 1) {
$sql_data_array = array('products_id' => $products_id, 'specials_new_products_price' => $product['specials_specials_new_products_price'], 'expires_date' => $product['specials_expires_date'], 'status' => $product['specials_price_status'], 'specials_date_available' => $product['specials_specials_date_available']);
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_BEFORE_SAVE_SPECIALS');
if ($product['specials_specials_id'] == 0) {
$sql_data_array['specials_date_added'] = 'now()';
zen_db_perform(TABLE_SPECIALS, $sql_data_array);
$product['specials_specials_id'] = zen_db_insert_id();
} else {
$sql_data_array['specials_last_modified'] = 'now()';
zen_db_perform(TABLE_SPECIALS, $sql_data_array, "update", "specials_id=" . $product['specials_specials_id']);
}
} else {
$db->Execute("delete from " . TABLE_SPECIALS . " where products_id=" . (int) $products_id);
}
}
zen_update_products_price_sorter($products_id);
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_FINISH_SAVE');
if ($insert_products) {
$zco_notifier->notify('NOTIFY_EASY_ADMIN_PRODUCTS_FINISH_INSERT');
}
return $products_id;
}
开发者ID:homework-bazaar,项目名称:zencart-sugu,代码行数:101,代码来源:easy_admin_products_model.php
注:本文中的zen_update_products_price_sorter函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论