auction_listing_admin.php to have FCK editor

March 31, 2009

I just wondering on the one of my installed Automated Auction Process

there is a file called auction_listing_admin.php

You can see on the admin>auction listing

A text box for Description:

It was very ugly. I would like to have a FCK EDITOR FOR WYSIWG EDITING

which is FCK HTML Editor 2.7 Install, in fact, i installed on the osc already

But I would like to have FCK_HTML Editor on the Description that makes elegant and user friendly to use

Please help

<?php

/*

$Id: auction_listings_admin.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

if (tep_not_null($action)) {

switch ($action) {

case 'setflag':

if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) {

if (isset($HTTP_GET_VARS['pID'])) {

tep_set_product_status($HTTP_GET_VARS['pID'], $HTTP_GET_VARS['flag']);

}

tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&pID=' . $HTTP_GET_VARS['pID']));

break;

case 'delete_product_confirm':

if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['product_categories']) && is_array($HTTP_POST_VARS['product_categories'])) {

$product_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);

$product_categories = $HTTP_POST_VARS['product_categories'];

for ($i=0, $n=sizeof($product_categories); $i<$n; $i++) {

tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "' and categories_id = '" . (int)$product_categories[$i] . "'");

}

$product_categories_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'");

$product_categories = tep_db_fetch_array($product_categories_query);

if ($product_categories['total'] == '0') {

tep_remove_product($product_id);

}

tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath));

break;

case 'insert_product':

case 'update_product':

if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) {

$action = 'new_product';

} else {

if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']);

$products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']);

$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';

$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),

'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),

'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),

'products_date_available' => $products_date_available,

'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']),

'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),

'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']));

if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) {

$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']);

}

if (isset($HTTP_POST_VARS['remove_image_2']) && tep_not_null($HTTP_POST_VARS['remove_image_2']) && ($HTTP_POST_VARS['remove_image_2'] == 'true')) {

$HTTP_POST_VARS['products_image_2'] = Null;

$sql_data_array['products_image_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_2']);

} elseif (isset($HTTP_POST_VARS['products_image_2']) && tep_not_null($HTTP_POST_VARS['products_image_2']) && ($HTTP_POST_VARS['products_image_2'] != 'none')) {

$sql_data_array['products_image_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_2']);

}

if (isset($HTTP_POST_VARS['remove_image_3']) && tep_not_null($HTTP_POST_VARS['remove_image_3']) && ($HTTP_POST_VARS['remove_image_3'] == 'true')) {

$HTTP_POST_VARS['products_image_3'] = Null;

$sql_data_array['products_image_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_3']);

} elseif (isset($HTTP_POST_VARS['products_image_3']) && tep_not_null($HTTP_POST_VARS['products_image_3']) && ($HTTP_POST_VARS['products_image_3'] != 'none')) {

$sql_data_array['products_image_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_3']);

}

if (isset($HTTP_POST_VARS['remove_image_4']) && tep_not_null($HTTP_POST_VARS['remove_image_4']) && ($HTTP_POST_VARS['remove_image_4'] == 'true')) {

$HTTP_POST_VARS['products_image_4'] = Null;

$sql_data_array['products_image_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_4']);

} elseif (isset($HTTP_POST_VARS['products_image_4']) && tep_not_null($HTTP_POST_VARS['products_image_4']) && ($HTTP_POST_VARS['products_image_4'] != 'none')) {

$sql_data_array['products_image_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_4']);

}

if (isset($HTTP_POST_VARS['remove_image_5']) && tep_not_null($HTTP_POST_VARS['remove_image_5']) && ($HTTP_POST_VARS['remove_image_5'] == 'true')) {

$HTTP_POST_VARS['products_image_5'] = Null;

$sql_data_array['products_image_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_5']);

} elseif (isset($HTTP_POST_VARS['auction_products_image_5']) && tep_not_null($HTTP_POST_VARS['products_image_5']) && ($HTTP_POST_VARS['products_image_5'] != 'none')) {

$sql_data_array['products_image_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_5']);

}

if (isset($HTTP_POST_VARS['remove_image_6']) && tep_not_null($HTTP_POST_VARS['remove_image_6']) && ($HTTP_POST_VARS['remove_image_6'] == 'true')) {

$HTTP_POST_VARS['products_image_6'] = Null;

$sql_data_array['products_image_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_6']);

} elseif (isset($HTTP_POST_VARS['products_image_6']) && tep_not_null($HTTP_POST_VARS['products_image_6']) && ($HTTP_POST_VARS['products_image_6'] != 'none')) {

$sql_data_array['products_image_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_6']);

}

if ($action == 'insert_product') {

$insert_sql_data = array('products_date_added' => 'now()');

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

tep_db_perform(TABLE_PRODUCTS, $sql_data_array);

$products_id = tep_db_insert_id();

tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')");

} elseif ($action == 'update_product') {

$update_sql_data = array('products_last_modified' => 'now()');

$sql_data_array = array_merge($sql_data_array, $update_sql_data);

tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");

}

$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name']),

'products_title' => tep_db_prepare_input($HTTP_POST_VARS['products_title']),

'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description']),

'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url']));

if ($action == 'insert_product') {

$insert_sql_data = array('products_id' => $products_id);

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);

} elseif ($action == 'update_product') {

tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");

}

tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products_id));

}

break;

case 'new_product_preview':

// copy image only if modified

$products_image = new upload('products_image');

$products_image->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image->parse() && $products_image->save()) {

$products_image_name = $products_image->filename;

} else {

$products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : '');

}

$products_image_2 = new upload('products_image_2');

$products_image_2->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image_2->parse() && $products_image_2->save()) {

$products_image_name_2 = $products_image_2->filename;

} else {

$products_image_name_2 = (isset($HTTP_POST_VARS['products_previous_image_2']) ? $HTTP_POST_VARS['products_previous_image_2'] : '');

}

$products_image_3 = new upload('products_image_3');

$products_image_3->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image_3->parse() && $products_image_3->save()) {

$products_image_name_3 = $products_image_3->filename;

} else {

$products_image_name_3 = (isset($HTTP_POST_VARS['products_previous_image_3']) ? $HTTP_POST_VARS['products_previous_image_3'] : '');

}

$products_image_4 = new upload('products_image_4');

$products_image_4->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image_4->parse() && $products_image_4->save()) {

$products_image_name_4 = $products_image_4->filename;

} else {

$products_image_name_4 = (isset($HTTP_POST_VARS['products_previous_image_4']) ? $HTTP_POST_VARS['products_previous_image_4'] : '');

}

$products_image_5 = new upload('products_image_5');

$products_image_5->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image_5->parse() && $products_image_5->save()) {

$products_image_name_5 = $products_image_5->filename;

} else {

$products_image_name_5 = (isset($HTTP_POST_VARS['products_previous_image_5']) ? $HTTP_POST_VARS['products_previous_image_5'] : '');

}

$products_image_6 = new upload('products_image_6');

$products_image_6->set_destination(DIR_FS_CATALOG_IMAGES);

if ($products_image_6->parse() && $products_image_6->save()) {

$products_image_name_6 = $products_image_6->filename;

} else {

$products_image_name_6 = (isset($HTTP_POST_VARS['products_previous_image_6']) ? $HTTP_POST_VARS['products_previous_image_6'] : '');

}

break;

}

// check if the catalog image directory exists

if (is_dir(DIR_FS_CATALOG_IMAGES)) {

if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error');

} else {

$messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error');

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?php

if ($action == 'generate_code') {

$generate_code_query = tep_db_query("select products_id, products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");

$generate_code_product = tep_db_fetch_array($generate_code_query);

$form_action = (isset($HTTP_GET_VARS['pID']));

echo tep_draw_form($form_action, FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action="#"' . $form_action, 'post', 'enctype="multipart/form-data"');

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

<tr>

<td>

type="text/JavaScript">

if(navigator.appName == "Microsoft Internet Explorer")

{

document.write("<object type='text/x-scriptlet' data='<?php echo tep_catalog_href_link('auction_product_info.php') . '?cPath=9999&products_id=' . $HTTP_GET_VARS['pID']; ?>' width='100%' height='1300'></object>")

}

else

{

document.write("<object type='text/html' data='<?php echo tep_catalog_href_link('auction_product_info.php') . '?cPath=9999&products_id=' . $HTTP_GET_VARS['pID']; ?>' width='100%' height='1300'></object>")

}

</script>

</td>

</tr>

</table></textarea>

</td>

</tr>

<tr>

</tr>

<tr>

<td><?php echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

</tr>

<tr>

</tr>

</table></form>

<?php

} elseif ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_title' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'products_image_2' => '',

'products_image_3' => '',

'products_image_4' => '',

'products_image_5' => '',

'products_image_6' => '',

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '');

$pInfo = new objectInfo($parameters);

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

// $product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

$pInfo->objectInfo($product);

} elseif (tep_not_null($HTTP_POST_VARS)) {

$pInfo->objectInfo($HTTP_POST_VARS);

$products_name = $HTTP_POST_VARS['products_name'];

$products_title = $HTTP_POST_VARS['products_title'];

$products_description = $HTTP_POST_VARS['products_description'];

$products_url = $HTTP_POST_VARS['products_url'];

}

$tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));

$tax_class_query = tep_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");

while ($tax_class = tep_db_fetch_array($tax_class_query)) {

$tax_class_array[] = array('id' => $tax_class['tax_class_id'],

'text' => $tax_class['tax_class_title']);

}

$languages = tep_get_languages();

if (!isset($pInfo->products_status)) $pInfo->products_status = '1';

switch ($pInfo->products_status) {

case '0': $in_status = false; $out_status = true; break;

case '1':

default: $in_status = true; $out_status = false;

}

?>

var dateAvailable = new ctlSpiffyCalendarBox("dateAvailable", "new_product", "products_date_available","btnDate1","<?php echo $pInfo->products_date_available; ?>",scBTNMODE_CUSTOMBLUE);

//--></script>

var tax_rates = new Array();

<?php

for ($i=0, $n=sizeof($tax_class_array); $i<$n; $i++) {

if ($tax_class_array[$i]['id'] > 0) {

echo 'tax_rates["' . $tax_class_array[$i]['id'] . '"] = ' . tep_get_tax_rate_value($tax_class_array[$i]['id']) . ';' . "\n";

}

?>

function doRound(x, places) {

return Math.round(x * Math.pow(10, places)) / Math.pow(10, places);

}

function getTaxRate() {

var selected_value = document.forms["new_product"].products_tax_class_id.selectedIndex;

var parameterVal = document.forms["new_product"].products_tax_class_id[selected_value].value;

if ( (parameterVal > 0) && (tax_rates[parameterVal] > 0) ) {

return tax_rates[parameterVal];

} else {

return 0;

}

function updateGross() {

var taxRate = getTaxRate();

var grossValue = document.forms["new_product"].products_price.value;

if (taxRate > 0) {

grossValue = grossValue * ((taxRate / 100) + 1);

}

document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4);

}

function updateNet() {

var taxRate = getTaxRate();

var netValue = document.forms["new_product"].products_price_gross.value;

if (taxRate > 0) {

netValue = netValue / ((taxRate / 100) + 1);

}

document.forms["new_product"].products_price.value = doRound(netValue, 4);

}

//--></script>

<?php echo tep_draw_form('new_product', FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=new_product_preview', 'post', 'enctype="multipart/form-data"'); ?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' '; ?><script language="javascript">dateAvailable.writeControl(); dateAvailable.dateFormat="yyyy-MM-dd";</script></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_name', $pInfo->products_name, 'size="50"'); ?></td>

</tr>

<tr>

<td class="main"><?php echo TEXT_PRODUCTS_TITLE; ?><br><small>(Very Important!)</small></td>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_title', $pInfo->products_title, 'size="50"'); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_pull_down_menu('products_tax_class_id', $tax_class_array, $pInfo->products_tax_class_id); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_textarea_field('products_description', 'soft', '70', '15', $pInfo->products_description); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', $pInfo->products_quantity); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image . tep_draw_hidden_field('products_previous_image', $pInfo->products_image); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_2') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_2 . tep_draw_hidden_field('products_previous_image_2', $pInfo->products_image_2); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_3') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_3 . tep_draw_hidden_field('products_previous_image_3', $pInfo->products_image_3); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_4') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_4 . tep_draw_hidden_field('products_previous_image_4', $pInfo->products_image_4); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_5') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_5 . tep_draw_hidden_field('products_previous_image_5', $pInfo->products_image_5); ?></td>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_6') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_6 . tep_draw_hidden_field('products_previous_image_6', $pInfo->products_image_6); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo TEXT_PRODUCTS_URL . '<br><small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?></td>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_url', $pInfo->products_url); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<td class="main" align="right"><?php echo tep_draw_hidden_field('products_date_added', (tep_not_null($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . tep_image_submit('button_preview.gif', IMAGE_PREVIEW) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>

</tr>

</table></form>

<?php

} elseif ($action == 'new_product_preview') {

if (tep_not_null($HTTP_POST_VARS)) {

$pInfo = new objectInfo($HTTP_POST_VARS);

$products_name = $HTTP_POST_VARS['products_name'];

$products_title = $HTTP_POST_VARS['products_title'];

$products_description = $HTTP_POST_VARS['products_description'];

$products_url = $HTTP_POST_VARS['products_url'];

} else {

$product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");

$product = tep_db_fetch_array($product_query);

$pInfo = new objectInfo($product);

$products_image_name = $pInfo->products_image;

$products_image_name_2 = $pInfo->products_image_2;

$products_image_name_3 = $pInfo->products_image_3;

$products_image_name_4 = $pInfo->products_image_4;

$products_image_name_5 = $pInfo->products_image_5;

$products_image_name_6 = $pInfo->products_image_6;

}

if ($HTTP_POST_VARS['remove_image_2'] == 'true') {

$products_image_name_2 = Null;

}

if ($HTTP_POST_VARS['remove_image_3'] == 'true') {

$products_image_name_3 = Null;

}

if ($HTTP_POST_VARS['remove_image_4'] == 'true') {

$products_image_name_4 = Null;

}

if ($HTTP_POST_VARS['remove_image_5'] == 'true') {

$products_image_name_5 = Null;

}

if ($HTTP_POST_VARS['remove_image_6'] == 'true') {

$products_image_name_6 = Null;

}

$form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product';

echo tep_draw_form($form_action, FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');

?>

<tr>

<tr>

<td class="pageHeading"><?php echo $pInfo->products_name; ?></td>

</tr>

<tr>

<td class="pageHeading"><?php echo $pInfo->products_title; ?></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo $pInfo->products_description; ?></td>

</tr>

<?php

if ($pInfo->products_url) {

?>

<tr>

</tr>

<tr>

<td class="main"><?php echo sprintf(TEXT_PRODUCT_MORE_INFORMATION, $pInfo->products_url); ?></td>

</tr>

<?php

}

?>

<tr>

</tr>

<tr>

<td class="main" align="center"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"') ?></td>

</tr>

<tr>

<?php

if (tep_not_null($products_image_name_2)) {

echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_2, $pInfo->products_name_2, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"');

}

?>

</td>

</tr>

<tr>

<?php

if (tep_not_null($products_image_name_3)) {

echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_3, $pInfo->products_name_3, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"');

}

?>

</td>

</tr>

<tr>

<?php

if (tep_not_null($products_image_name_4)) {

echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_4, $pInfo->products_name_4, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"');

}

?>

</td>

</tr>

<tr>

<?php

if (tep_not_null($products_image_name_5)) {

echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_5, $pInfo->products_name_5, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"');

}

?>

</td>

</tr>

<tr>

<?php

if (tep_not_null($products_image_name_6)) {

echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_6, $pInfo->products_name_6, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"');

}

?>

</td>

</tr>

<tr>

</tr>

<?php

if ($pInfo->products_date_available > date('Y-m-d')) {

?>

<tr>

<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, tep_date_long($pInfo->products_date_available)); ?></td>

</tr>

<?php

} else {

?>

<tr>

<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, tep_date_long($pInfo->products_date_added)); ?></td>

</tr>

<?php

}

?>

<tr>

</tr>

<?php

if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) {

if (isset($HTTP_GET_VARS['origin'])) {

$pos_params = strpos($HTTP_GET_VARS['origin'], '?', 0);

if ($pos_params != false) {

$back_url = substr($HTTP_GET_VARS['origin'], 0, $pos_params);

$back_url_params = substr($HTTP_GET_VARS['origin'], $pos_params + 1);

} else {

$back_url = $HTTP_GET_VARS['origin'];

$back_url_params = '';

}

} else {

$back_url = FILENAME_AUCTION_LISTINGS_ADMIN;

$back_url_params = 'cPath=' . $cPath . '&pID=' . $pInfo->products_id;

}

?>

<tr>

<td align="right"><?php echo '<a href="' . tep_href_link($back_url, $back_url_params, 'NONSSL') . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

</tr>

<?php

} else {

?>

<tr>

<?php

/* Re-Post all POST'ed variables */

reset($HTTP_POST_VARS);

while (list($key, $value) = each($HTTP_POST_VARS)) {

if (!is_array($HTTP_POST_VARS[$key])) {

echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value)));

}

echo tep_draw_hidden_field('products_name', htmlspecialchars(stripslashes($products_name)));

echo tep_draw_hidden_field('products_title', htmlspecialchars(stripslashes($products_title)));

echo tep_draw_hidden_field('products_description', htmlspecialchars(stripslashes($products_description)));

echo tep_draw_hidden_field('products_url', htmlspecialchars(stripslashes($products_url)));

echo tep_draw_hidden_field('products_image', stripslashes($products_image_name));

echo tep_draw_hidden_field('products_image_2', stripslashes($products_image_name_2));

echo tep_draw_hidden_field('products_image_3', stripslashes($products_image_name_3));

echo tep_draw_hidden_field('products_image_4', stripslashes($products_image_name_4));

echo tep_draw_hidden_field('products_image_5', stripslashes($products_image_name_5));

echo tep_draw_hidden_field('products_image_6', stripslashes($products_image_name_6));

echo tep_image_submit('button_back.gif', IMAGE_BACK, 'name="edit"') . ' ';

if (isset($HTTP_GET_VARS['pID'])) {

echo tep_image_submit('button_update.gif', IMAGE_UPDATE);

} else {

echo tep_image_submit('button_insert.gif', IMAGE_INSERT);

}

echo ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>';

?></td>

</tr>

</table></form>

<?php

}

} else {

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<tr>

</tr>

<?php

$products_count = 0;

$current_category_id = '9999';

$cPath = '9999';

$products_query = tep_db_query("select p.products_id, pd.products_name, pd.products_title, pd.products_viewed, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status 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)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");

while ($products = tep_db_fetch_array($products_query)) {

$products_count++;

$rows++;

if ( (!isset($HTTP_GET_VARS['pID']) && !isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['pID']) && ($HTTP_GET_VARS['pID'] == $products['products_id']))) && !isset($pInfo) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {

// find out the rating average from customer reviews

$reviews_query = tep_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . (int)$products['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

$pInfo_array = array_merge($products, $reviews);

$pInfo = new objectInfo($pInfo_array);

}

if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id) ) {

echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '\'">' . "\n";

} else {

echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '\'">' . "\n";

}

?>

<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $products['products_name']; ?></td>

<?php

if ($products['products_status'] == '1') {

echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'action=setflag&flag=0&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';

} else {

echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'action=setflag&flag=1&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);

}

?></td>

<td class="dataTableContent" align="right"><?php if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

</tr>

<?php

}

$cPath_back = '';

if (sizeof($cPath_array) > 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 = (tep_not_null($cPath_back)) ? 'cPath=' . $cPath_back . '&' : '';

?>

</table></td>

<?php

$heading = array();

$contents = array();

switch ($action) {

case 'delete_product':

$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PRODUCT . '</b>');

$contents = array('form' => tep_draw_form('products', FILENAME_AUCTION_LISTINGS_ADMIN, 'action=delete_product_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));

$contents[] = array('text' => TEXT_DELETE_PRODUCT_INTRO);

$contents[] = array('text' => '<br><b>' . $pInfo->products_name . '</b>');

$product_categories_string = '';

$product_categories = tep_generate_category_path($pInfo->products_id, 'product');

for ($i = 0, $n = sizeof($product_categories); $i < $n; $i++) {

$category_path = '';

for ($j = 0, $k = sizeof($product_categories[$i]); $j < $k; $j++) {

$category_path .= $product_categories[$i][$j]['text'] . ' > ';

}

$category_path = substr($category_path, 0, -16);

$product_categories_string .= tep_draw_checkbox_field('product_categories[]', $product_categories[$i][sizeof($product_categories[$i])-1]['id'], true) . ' ' . $category_path . '<br>';

}

$product_categories_string = substr($product_categories_string, 0, -4);

$contents[] = array('text' => '<br>' . $product_categories_string);

$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

break;

default:

if ($rows > 0) {

if (isset($pInfo) && is_object($pInfo)) { // product info box contents

$heading[] = array('text' => '<b>' . tep_get_products_name($pInfo->products_id, $languages_id) . '</b>');

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>');

$contents[] = array('text' => '<br><a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=generate_code') . '">' . TEXT_GENERATE_CODE . '</a>');

$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_TITLE . ' ' . $pInfo->products_title);

$contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($pInfo->products_date_added));

if (tep_not_null($pInfo->products_last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($pInfo->products_last_modified));

if (date('Y-m-d') < $pInfo->products_date_available) $contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . tep_date_short($pInfo->products_date_available));

$contents[] = array('text' => '<br>' . tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image);

$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_WEIGHT_INFO . ' ' . $pInfo->products_weight . ' lbs');

$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity);

$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_VIEWED_INFO . ' ' . $pInfo->products_viewed . ' times');

$contents[] = array('text' => '<br>' . TEXT_PRODUCTS . ' ' . $products_count);

}

} else { // create category/product info

$heading[] = array('text' => '<b>' . TEXT_NO_PRODUCTS . '</b>');

$contents[] = array('align' => 'center', 'text' => '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>');

}

break;

}

if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {

echo ' <td width="25%" valign="top">' . "\n";

$box = new box;

echo $box->infoBox($heading, $contents);

echo ' </td>' . "\n";

}

?>

</tr>

</table></td>

</tr>

</table>

<?php

}

?>

</td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

auction_listing_admin.php to have FCK editor

Recommended Posts

Guest

Link to comment

Share on other sites

Join the conversation

Browse

Activity