add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error'); else if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error'); ?> > <?php echo TITLE; ?>
''.BOX_REWARD_POINTS.''); if(isset($_GET['pID'])) { $reward_point_record=GetRewardPointRecord(SCOPE_PRODUCT,$_GET['pID']); $header=TEXT_PRODUCT_REWARD_POINTS_HEADER; $ident=zen_get_products_name($_GET['pID'],$_SESSION['languages_id']); $prompt=TEXT_PRODUCT_REWARD_POINT_PROMPT; $passvar="&pID=".$_GET['pID']; } else if(isset($_GET['cID'])) { $reward_point_record=GetRewardPointRecord(SCOPE_CATEGORY,$_GET['cID']); $header=TEXT_CATEGORY_REWARD_POINTS_HEADER; $ident=zen_get_category_name($_GET['cID'],$_SESSION['languages_id']); $prompt=TEXT_CATEGORY_REWARD_POINT_PROMPT; $passvar="&cID=".$_GET['cID']; } else { $reward_point_record=GetRewardPointRecord(SCOPE_GLOBAL); $header=TEXT_GLOBAL_REWARD_POINTS_HEADER; $ident=""; $prompt=TEXT_GLOBAL_REWARD_POINT_PROMPT; $passvar=""; } $contents=array('form' => zen_draw_form('set_reward_points', FILENAME_ADMIN_REWARD_POINTS, 'cPath='.$cPath.$passvar.'&action=set_reward_points','post', 'enctype="multipart/form-data"')); $contents[]=array('text' => ''.$header.'
'); $contents[]=array('align' => 'center', 'text' => '
'.$ident.'

'); $contents[]=array('text' => $prompt.' '.zen_draw_input_field('reward_point_ratio',$reward_point_record->fields[FIELD_POINT_RATIO],zen_set_field_length(TABLE_REWARD_MASTER,FIELD_POINT_RATIO)).'

'); $contents[]=array('align' => 'center', 'text' => ($reward_point_record->fields?zen_image_submit('button_update.gif', IMAGE_UPDATE):zen_image_submit('button_save.gif', IMAGE_SAVE))); $contents[]=array('text' => ''); // check for which buttons to show for categories and products $check_categories = zen_has_category_subcategories($current_category_id); $check_products = zen_products_in_category_count($current_category_id, false, false, 1); $zc_skip_products = false; $zc_skip_categories = false; if($check_products == 0) { $zc_skip_products = false; $zc_skip_categories = false; } if ($check_categories == true) { $zc_skip_products = true; $zc_skip_categories = false; } if ($check_products > 0) { $zc_skip_products = false; $zc_skip_categories = true; } if ($zc_skip_products == true) $categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME),array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME)); else // toggle switch for display sort order $categories_products_sort_order_array=array(array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME),array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME),array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL),); echo TEXT_CATEGORIES_PRODUCTS_SORT_ORDER_INFO . zen_draw_form('set_categories_products_sort_order_form', FILENAME_ADMIN_REWARD_POINTS, '', 'get') . '  ' . zen_draw_pull_down_menu('reset_categories_products_sort_order', $categories_products_sort_order_array, $reset_categories_products_sort_order, 'onChange="this.form.submit();"') . zen_hide_session_id() . zen_draw_hidden_field('cID', $cPath) . zen_draw_hidden_field('cPath', $cPath) . zen_draw_hidden_field('pID', $_GET['pID']) . zen_draw_hidden_field('page', $_GET['page']) . zen_draw_hidden_field('action', 'set_categories_products_sort_order'); echo '     '; echo zen_draw_form('search', FILENAME_ADMIN_REWARD_POINTS,'','get'); echo HEADING_TITLE_SEARCH_DETAIL.' '.zen_draw_input_field('search',zen_db_input(zen_db_prepare_input($_GET['search']))).zen_hide_session_id(); echo '     '; echo zen_draw_form('goto',FILENAME_ADMIN_REWARD_POINTS,'','get').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 ''; ?>
0) for($i=0, $n=sizeof($cPath_array)-1; $i<$n; $i++) if (empty($cPath_back)) $cPath_back.= $cPath_array[$i]; else $cPath_back.='_'.$cPath_array[$i]; $cPath_back = (zen_not_null($cPath_back)) ? 'cPath=' . $cPath_back . '&' : ''; echo (sizeof($cPath_array)>0?''.zen_image_button('button_back.gif', IMAGE_BACK).'':" "); ?> fields[FIELD_POINT_RATIO],zen_set_field_length(TABLE_REWARD_MASTER,FIELD_POINT_RATIO)); echo ''; ?>
Execute("SELECT c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd where c.categories_id = cd.categories_id and cd.language_id = '".(int)$_SESSION['languages_id']."' ". $search." ". $order_by); while (!$categories->EOF) { $categories_count++; $rows++; // Get parent_id for subcategories if search if(isset($_GET['search'])) $cPath = $categories->fields['parent_id']; if((!isset($_GET['cID']) && !isset($_GET['pID']) || (isset($_GET['cID']) && ($_GET['cID'] == $categories->fields['categories_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) $cInfo = new objectInfo($categories->fields); // if (isset($cInfo) && is_object($cInfo) && ($categories->fields['categories_id']==$cInfo->categories_id)) // echo '' . "\n"; // else echo '' . "\n"; // if ($action == '') // { $result=GetRewardPointRecord(SCOPE_CATEGORY,$categories->fields['categories_id']); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; // } // action == '' echo ''; $categories->MoveNext(); } switch ($_SESSION['categories_products_sort_order']) { case (0): $order_by="order by p.products_sort_order, pd.products_name"; break; case (1): $order_by="order by pd.products_name"; break; case (2); $order_by="order by p.products_model"; break; case (3); $order_by="order by p.products_quantity, pd.products_name"; break; case (4); $order_by="order by p.products_quantity DESC, pd.products_name"; break; case (5); $order_by="order by p.products_price_sorter, pd.products_name"; break; case (6); $order_by="order by p.products_price_sorter DESC, pd.products_name"; break; } $products_count = 0; if(isset($_GET['search'])) $search="AND p.master_categories_id = p2c.categories_id AND (pd.products_name like ".$safe_search_string." OR pd.products_description LIKE ".$safe_search_string." OR p.products_model LIKE " .$safe_search_string.")"; else $search="AND p2c.categories_id=".(int)$current_category_id; // fix duplicates and force search to use master_categories_id $products=$db->Execute("SELECT p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id, p.products_model, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_quantity_order_max, p.products_sort_order, p.master_categories_id FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c WHERE p.products_id = pd.products_id AND pd.language_id = '".(int)$_SESSION['languages_id']."' AND p.products_id = p2c.products_id ". $search." ". $order_by); while(!$products->EOF) { $products_count++; $rows++; // Get categories_id for product if search if (isset($_GET['search'])) $cPath = $products->fields['categories_id']; // if(isset($pInfo) && is_object($pInfo) && ($products->fields['products_id'] == $pInfo->products_id)) // echo ''."\n"; // else echo '' . "\n"; $result=GetRewardPointRecord(SCOPE_PRODUCT,$products->fields['products_id']); echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $products->MoveNext(); } ?>
 
'.$categories->fields['categories_id'].''.zen_image(DIR_WS_ICONS.'folder.gif', ICON_FOLDER,'','','ALIGN=').' '.$categories->fields['categories_name'].' '.$result->fields[FIELD_POINT_RATIO].''.$result->fields[FIELD_REWARD_BONUS_POINTS].''; echo ''.zen_image(DIR_WS_IMAGES.'icon_edit.gif',ICON_EDIT_REWARD_POINTS).''; echo ''.zen_image(DIR_WS_IMAGES.'icon_delete.gif',ICON_DELETE_REWARD_POINTS).''; echo zen_image(DIR_WS_IMAGES.'icon_arrow_right.gif'); echo '
'.$products->fields['products_id'].''.zen_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW).' '.$products->fields['products_name'].''.$products->fields['products_model'].''.$result->fields[FIELD_POINT_RATIO].''.$result->fields[FIELD_REWARD_BONUS_POINTS].''; echo ''.zen_image(DIR_WS_IMAGES.'icon_edit.gif',ICON_EDIT_REWARD_POINTS).''; echo ''.zen_image(DIR_WS_IMAGES.'icon_delete.gif',ICON_DELETE_REWARD_POINTS).''; echo '
infoBox($heading, $contents); ?>