';
echo $tr;
//if(QUICKUPDATES_DISPLAY_ID == 'true')
// we always display the id!
echo '';
// added for external links paulm
if (defined('QUICKUPDATES_DISPLAY_ID_INFO')){
// handler page needed for products type
$handler_page = '';
//$handler_page = ?
echo sprintf(QUICKUPDATES_DISPLAY_ID_INFO, $products->fields['products_id'], $handler_page, zen_image(DIR_WS_IMAGES . 'icon_info.gif', QUICKUPDATES_DISPLAY_ID_INFO_ALT));
}
echo $products->fields['products_id'];
echo ' | ' . "\n";
if(QUICKUPDATES_DISPLAY_THUMBNAIL == 'true'){
echo '' .
zen_draw_hidden_field('quick_updates_new[products_image][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_image']), 'id="SelectImageName_' . $products->fields['products_id'] . '"') .
zen_draw_hidden_field('quick_updates_old[products_image][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_image'])) .
'' .
zen_image(DIR_WS_CATALOG_IMAGES . $products->fields['products_image'], TEXT_SELECT_IMAGE, QUICKUPDATES_DISPLAY_THUMBNAIL_WIDTH, QUICKUPDATES_DISPLAY_THUMBNAIL_HEIGHT, 'id="SelectImageName_' . $products->fields['products_id'] . '_img"') . ''
. ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_MODEL == 'true') {
echo '';
echo zen_draw_input_field('quick_updates_new[products_model][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_model']), 'size="12"') . zen_draw_hidden_field('quick_updates_old[products_model][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_model']));
// added for external links paulm
if (defined('QUICKUPDATES_MODIFY_MODEL_INFO')){
echo sprintf(QUICKUPDATES_MODIFY_MODEL_INFO, $products->fields['products_id'], stripslashes($products->fields['products_model']), zen_image(DIR_WS_IMAGES . 'icon_info.gif', stripslashes($products->fields['products_model'])));
}
echo ' | ' . "\n";
}
// added for QUICKUPDATES_NEW_COLUMN_1
if(QUICKUPDATES_MODIFY_NEW_COLUMN_1 == 'true'){
echo '';
$parameters = 'size="6"';
echo zen_draw_input_field('quick_updates_new[' . QUICKUPDATES_NEW_COLUMN_1 . '][' . $products->fields['products_id'] . ']', stripslashes($products->fields[QUICKUPDATES_NEW_COLUMN_1]), $parameters) . zen_draw_hidden_field('quick_updates_old[' . QUICKUPDATES_NEW_COLUMN_1 . '][' . $products->fields['products_id'] . ']', stripslashes($products->fields[QUICKUPDATES_NEW_COLUMN_1]));
// added for external links paulm
if (defined('QUICKUPDATES_QUICKUPDATES_NEW_COLUMN_1_INFO')){
echo sprintf(QUICKUPDATES_QUICKUPDATES_NEW_COLUMN_1_INFO, $products->fields['products_id'], stripslashes($products->fields[QUICKUPDATES_NEW_COLUMN_1]), zen_image(DIR_WS_IMAGES . 'icon_info.gif', stripslashes($products->fields[QUICKUPDATES_NEW_COLUMN_1])));
}
echo ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_NAME == 'true'){
// added div wrapper to allow advanced :hover styling
echo '' . zen_draw_input_field('quick_updates_new[products_name][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_name']), 'size="16"') . zen_draw_hidden_field('quick_updates_old[products_name][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_name'])) . ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_DESCRIPTION == 'true'||QUICKUPDATES_MODIFY_DESCRIPTION_POPUP == 'true') {
echo '';
// no need to display description when popup edit is enabled (?)
if(QUICKUPDATES_MODIFY_DESCRIPTION_POPUP == 'true') echo ' ';
echo zen_draw_textarea_field('quick_updates_new[products_description][' . $products->fields['products_id'] . ']', 'soft', 200, 2, stripslashes($products->fields['products_description']), 'id="description_' . $products->fields['products_id'] . '"') . zen_draw_hidden_field('quick_updates_old[products_description][' . $products->fields['products_id'] . '] ', stripslashes($products->fields['products_description']));
if(QUICKUPDATES_MODIFY_DESCRIPTION_POPUP == 'true') echo ' ';
//echo " | \n";
if(QUICKUPDATES_MODIFY_DESCRIPTION_POPUP == 'true') {
//echo ''
echo '' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', TEXT_HTML_EDIT_DESC) . '';
}
echo " | \n";
}
if(QUICKUPDATES_MODIFY_MANUFACTURER == 'true') {
echo '' . zen_draw_pull_down_menu('quick_updates_new[manufacturers_id][' . $products->fields['products_id'] . ']', $manufacturers_array, $products->fields['manufacturers_id'], 'style="width: 6em;"') . zen_draw_hidden_field('quick_updates_old[manufacturers_id][' . $products->fields['products_id'] . ']', $products->fields['manufacturers_id']) . ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_STATUS == 'true') {
echo '' . zen_draw_checkbox_field('quick_updates_new[products_status][' . $products->fields['products_id'] . ']', 1, false, $products->fields['products_status'], '') . zen_draw_hidden_field('quick_updates_old[products_status][' . $products->fields['products_id'] . ']', $products->fields['products_status']) .
' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_SORT_ORDER == 'true') {
echo '' . zen_draw_input_field('quick_updates_new[products_sort_order][' . $products->fields['products_id'] . ']', $products->fields['products_sort_order'], 'size="3"') . zen_draw_hidden_field('quick_updates_old[products_sort_order][' . $products->fields['products_id'] . ']', $products->fields['products_sort_order']) .
' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_QUANTITY == 'true') {
echo '' . zen_draw_input_field('quick_updates_new[products_quantity][' . $products->fields['products_id'] . ']', $products->fields['products_quantity'], 'size="3"') . zen_draw_hidden_field('quick_updates_old[products_quantity][' . $products->fields['products_id'] . ']', $products->fields['products_quantity']) . ' | ' . "\n";
}
// added for products_purchase_price and margin
if(QUICKUPDATES_MODIFY_PURCHASE_AND_MARGIN == 'true'){
$parameters = 'size="6" onKeyUp="updateMargin(' . $products->fields['products_id'] . ');"';
echo '' . zen_draw_input_field('quick_updates_new[products_purchase_price][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_purchase_price']), $parameters) . zen_draw_hidden_field('quick_updates_old[products_purchase_price][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_purchase_price'])) . ' | ' . "\n";
}
// added for products_purchase_price and margin
if(QUICKUPDATES_MODIFY_PURCHASE_AND_MARGIN == 'true'){
//if ($products->fields['products_margin'] == 0 ) $zeroWarning= ' *'; else $zeroWarning = '';
$parameters = 'size="6"';
echo '' . zen_draw_input_field('quick_updates_new[products_margin][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_margin']), $parameters) . zen_draw_hidden_field('quick_updates_old[products_margin][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_margin'])) . ' | ' . "\n";
}
// added for p.products_price_w
if(QUICKUPDATES_MODIFY_WHOLESALE_PRICE == 'true'){
$parameters = 'size="' . QUICKUPDATES_MODIFY_WHOLESALE_PRICE_INPUT_SIZE . '"';
echo '' . zen_draw_input_field('quick_updates_new[products_price_w][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_price_w'])) . zen_draw_hidden_field('quick_updates_old[products_price_w][' . $products->fields['products_id'] . ']', stripslashes($products->fields['products_price_w']), $parameters) . ' | ' . "\n";
}
//// get the specials products list
$specials_array = array();
$specials = $db->Execute("select p.products_id, s.products_id, s.specials_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = p.products_id");
while (!$specials->EOF) {
$specials_array[] = $specials->fields['products_id'];
$specials->MoveNext();
}
//// check specials
$parameters = 'size="6"';
if(QUICKUPDATES_DISPLAY_TVA_PRICES == 'true'){
// updateMargin on products_price(was only on products_purchase_price before)
$parameters .= ' onKeyUp="updateGross(' . $products->fields['products_id'] . '); updateMargin(' . $products->fields['products_id'] . ');"';
}
if (in_array($products->fields['products_id'], $specials_array)){
$spec = $db->Execute("select s.products_id, s.specials_id from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s where s.products_id = " . (int)$products->fields['products_id'] . "");
$flag_special = true;
echo '';
}else{
$flag_special = false;
echo ' | ';
}
echo zen_draw_input_field('quick_updates_new[products_price][' . $products->fields['products_id'] . ']', $price, $parameters);
if ($flag_markup){
echo zen_draw_checkbox_field('markup_checked[' . $products->fields['products_id'] . ']', '1', (!($flag_special)&&($_POST['marge'])));
//echo zen_draw_hidden_field('markup[' . $products->fields['products_id'] . ']', '1');
} else {
// this has become obsolete since we changed prices to update by default when markup is not set
//echo zen_draw_hidden_field('update_price[' . $products->fields['products_id'] . ']', 'yes');
}
if($flag_special){
echo ' '. zen_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) . '';
}
if(QUICKUPDATES_DISPLAY_TVA_PRICES == 'true'){
$parameters = 'size="6"';
$parameters .= ' onKeyUp="updateNet(' . $products->fields['products_id'] . '); updateMargin(' . $products->fields['products_id'] . ');"';
// $taxprice needs the $currencies->currencies[DEFAULT_CURRENCY]['decimal_places'] to be set (done at top of file)
// an alternative might be to use $price (i.s.o. $taxprice) and update it with updatGross('$products->fields['products_id']') for each product ?)
$tax_price = zen_add_tax($price, $tax_rate->fields['tax_rate']);
$tax_price = sprintf("%01.2f", round($tax_price, 4));
echo ' | ' . "\n";
echo '' . zen_draw_input_field('quick_updates_new[products_taxprice][' . $products->fields['products_id'] . ']', $tax_price, $parameters);
//echo zen_draw_hidden_field('update_taxprice['.$products->fields['products_id'].']','yes');
echo zen_draw_hidden_field('quick_updates_old[products_tax_value]['.$products->fields['products_id'].']', $tax_rate->fields['tax_rate']);
}
echo zen_draw_hidden_field('quick_updates_old[products_price][' . $products->fields['products_id'] . ']', $products->fields['products_price']);
echo '' . zen_image(DIR_WS_IMAGES . 'icon_products_price_manager.gif', QUICKUPDATES_PPM_LINK_ALT) . '';
echo ' | ' . "\n";
if(QUICKUPDATES_MODIFY_WEIGHT == 'true') {
echo '' . zen_draw_input_field('quick_updates_new[products_weight][' . $products->fields['products_id'] . ']', $products->fields['products_weight'], 'size="4"') . zen_draw_hidden_field('quick_updates_old[products_weight][' . $products->fields['products_id'] . ']', $products->fields['products_weight']) . ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_TAX == 'true') {
echo '' . zen_draw_pull_down_menu('quick_updates_new[products_tax_class_id][' . $products->fields['products_id'] . ']', $tax_class_array, $products->fields['products_tax_class_id'], 'style="width: 5em;"') . zen_draw_hidden_field('quick_updates_old[products_tax_class_id][' . $products->fields['products_id'] . ']', $products->fields['products_tax_class_id']) . ' | ' . "\n";
}
if(QUICKUPDATES_MODIFY_CATEGORY == 'true') {
//products_to_categories.php?products_filter=198
$zen_get_master_categories_pulldown = zen_get_master_categories_pulldown($products->fields['products_id']);
/*
if(!in_array($products->fields['categories_id'], $zen_get_master_categories_pulldown)){
//exit('error');
}
*/
$multilinked = false;
if(count($zen_get_master_categories_pulldown) > 2){
$multilinked = true;
}
$invalidcat = false;
if(($multilinked == false)&&($products->fields['master_categories_id'] != $products->fields['categories_id'])){
$invalidcat = true;
}
$prod2cat_link = '(' . $products->fields['categories_id'] . '/' . $products->fields['master_categories_id']. ')';
//
echo '';
if($_SESSION['quick_updates']['categories_switch'] == 'master_cats'){
// show/edit the master cats products table
echo zen_draw_pull_down_menu('quick_updates_new[master_categories_id][' . $products->fields['products_id'] . ']', zen_get_master_categories_pulldown($products->fields['products_id']), $products->fields['master_categories_id']);
}else{
// show/edit the linked cats products_to_categories table
if($invalidcat == true){
echo TEXT_QU_CHECK_CAT_INVALID;
}elseif($multilinked == true){
echo TEXT_QU_CHECK_CAT_MULTILINKS;
}else{
echo zen_draw_pull_down_menu('quick_updates_new[categories_id][' . $products->fields['products_id'] . ']', $quick_updates_category_tree, $products->fields['categories_id'], '');
echo zen_draw_hidden_field('quick_updates_old[categories_id][' . $products->fields['products_id'] . ']', $products->fields['categories_id']);
}
}
// we need the old master_categories_id value in both cases
echo zen_draw_hidden_field('quick_updates_old[master_categories_id][' . $products->fields['products_id'] . ']', $products->fields['master_categories_id']);
echo $prod2cat_link;
echo ' | ' . "\n";
} // eof QUICKUPDATES_MODIFY_CATEGORY
//// links to preview or full edit
$type_handler = $zc_products->get_admin_handler($products->fields['products_type']);
if(QUICKUPDATES_DISPLAY_PREVIEW == 'true')
echo '' . zen_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . ' | ' . "\n";
if(QUICKUPDATES_DISPLAY_EDIT == 'true')
echo '' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . ' | ' . "\n";
echo '
';
// bof export viewed products paulm
// (= preparation to post to external script + quick copy function)
$export_products[$products->fields['products_id']]['products_model'] = $products->fields['products_model'];
if(defined('QUICKUPDATES_NEW_COLUMN_1')){
$export_products[$products->fields['products_id']][QUICKUPDATES_NEW_COLUMN_1] = $products->fields[QUICKUPDATES_NEW_COLUMN_1];
}
// eof export viewed products paulm
$prev_products_id = $products->fields['products_id'];
} // eof if($prev_products_id != $products->fields['products_id']){
$products->MoveNext();
}
// eof walk products object
?>