function nzshpcrt_getproductform($prodid)
{
global $wpdb, $nzshpcrt_imagesize_info, $current_user;
/*
* makes the product form
* has functions inside a function
*/
//$sql = "SELECT * FROM `wp_product_list` WHERE `id`=$prodid LIMIT 1";
$sql = "SELECT wp_product_list.*, wp_product_files.width, wp_product_files.height, wp_product_files.mimetype FROM wp_product_list, wp_product_files WHERE wp_product_files.id=wp_product_list.file AND wp_product_list.id={$prodid} LIMIT 1";
$product_data = $wpdb->get_results($sql, ARRAY_A);
$product = $product_data[0];
/*
* for security reason add to url for hires images sid - last 6 simbols of idhash
*
*/
$sql = "SELECT `idhash` FROM `wp_product_files` WHERE `id`=" . $product['file'];
$idhash_data = $wpdb->get_results($sql, ARRAY_A);
if ($idhash_data != null) {
$idhash = "&sid=" . substr($idhash_data[0]['idhash'], -6);
}
$output = "<table>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Автор: ";
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= brandslist($product['brand']);
$approved = 0;
//pokazh($product,"product: ");
//pokazh($current_user);
if ($product['approved'] == '1') {
$approved = " checked='checked'";
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<input type='checkbox' name='approved'" . $approved . "/> Утверждено.";
} else {
if (isset($current_user->wp_capabilities['editor']) && $current_user->wp_capabilities['editor'] == 1) {
$output .= "<input type='checkbox' name='approved'" . $approved . "/> Утвержено.";
}
}
$output .= "<div style='color:#669900'>Картинка находится в <b>хранилище банка</b></div>";
} elseif ($product['approved'] == '0') {
$approved = "";
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<input type='checkbox' name='approved'" . $approved . "/> Утверждено.";
}
$output .= "<div style='color:#9900CC'>Картинка может находиться в <b>Рабочем столе</b></div>";
} else {
$approved = "";
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<input type='checkbox' name='approved'" . $approved . "/> Утверждено.";
}
$output .= "<div style='color:#FF6600'>Картинка находится в <b>прихожей банка</b> в ожидании приёма</div>";
}
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Название рисунка: ";
$output .= "</td>\n\r";
$output .= "<td>";
$output .= "<input id='productnameedit' type='text' style='width:300px;' name='title' value='" . stripslashes($product['name']) . "' /> # <a href='" . SITEURL . "/?page_id=29&cartoonid=" . $product['id'] . "' target=_blank>" . $product['id'] . "</a>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Краткое описание: ";
$output .= "</td>\n\r";
$output .= "<td>";
$output .= "<textarea id='productdescredit' name='description' cols='50' rows='4' >" . stripslashes($product['description']) . "</textarea>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Ключевые слова,<br />разделённые запятыми:<br>";
$output .= "<a href='" . SITEURL . "/ales/wordassociations/words.php?id=" . $product['id'] . "' target=_blank>добавить<br>ассоциаций</a>";
$output .= "</td>\n\r";
$output .= "<td>";
$output .= "<textarea id='tagsedit' name='additional_description' cols='50' rows='4' >" . stripslashes($product['additional_description']) . "</textarea>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$visible = "";
if ($product['visible'] == '1') {
$visible = " checked='checked'";
}
$output .= "<tr>\n\r";
$output .= "</tr>\n\r";
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Видно всем:";
$output .= "</td>\n\r";
$output .= "<td>";
$output .= "<input type='checkbox' name='visible'" . $visible . "/> <span style='color:#999;'>Если выключить — не будет видно покупателям</span>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
}
$colored = "";
if ($product['color'] == '1') {
$colored = " checked='checked' ";
}
$temadnya = "";
$istemadnya_sql = "SELECT * FROM `wp_item_category_associations` where `category_id` = '777' and `product_id` = " . $product['id'];
//pokazh ($istemadnya_sql);
$istemadnya = $wpdb->get_results($istemadnya_sql);
if ($istemadnya != null) {
$temadnya = " checked='checked' ";
}
//pokazh($istemadnya,"istemadnya: ");
$not_for_sale = "";
if ($product['not_for_sale'] == '1') {
$not_for_sale = " checked='checked' ";
}
$license1checked = "";
if ($product['l1_price'] != '0') {
$license1checked = " checked='checked' ";
}
$license2checked = "";
if ($product['l2_price'] != '0') {
$license2checked = " checked='checked' ";
}
$license3checked = "";
if ($product['l3_price'] != '0') {
$license3checked = " checked='checked' ";
}
$output .= "<tr>\n\r";
$output .= "<td class='ralt'>";
$output .= "Цветной рисунок:";
$output .= "</td>\n\r";
$output .= "<td style='background-color:#FFFF33;'>";
$output .= "<input type='checkbox' name='colored'" . $colored . "/> <span style='color:#999;'>Отключите для ч/б рисунков</span>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Не для продажи:";
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= "<input type='checkbox' name='not_for_sale'" . $not_for_sale . "/> <span style='color:#999;'>Не продаётся, если включено</span>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td>";
$basepath = str_replace("/wp-admin", "", getcwd());
if (file_exists($basepath . "/wp-content/plugins/wp-shopping-cart/product_images/" . $product['image'])) {
$image_location = "product_images/" . $product['image'];
} else {
$image_location = "images/" . $product['image'];
}
$preview_location = "product_images/" . $product['image'];
$icon_location = "images/" . $product['image'];
$m_image_link = SITEURL . "/wp-content/plugins/wp-shopping-cart/" . $preview_location;
$output .= "<a href='" . $m_image_link . "' target=_blank><img id='previewimage' src='" . SITEURL . "/wp-content/plugins/wp-shopping-cart/{$icon_location}' alt='" . TXT_WPSC_PREVIEW . "' title='" . TXT_WPSC_PREVIEW . "' /></a>";
$output .= "Ш х В: " . $product['width'] . "x" . $product['height'] . "<br>" . $product['mimetype'];
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= categorylist($product['id']);
/*
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator']==1)
{
$output .= categorylist($product['id']);
}
else
{
$output .= "После утверждения рисунка модераторами Категория может быть изменена администратором";
$output .= "<div style='display:none;'>".categorylist($product['id'])."</div>";
}
*/
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='ralt'>";
$output .= "Тема дня::";
$output .= "</td>\n\r";
$output .= "<td class='lalt'>";
$output .= "<input type='checkbox' name='temadnya'" . $temadnya . "/> <span style='color:#999;'>считаю актуальной темой</span>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
//if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator']==1){
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Доступны лицензии:";
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= " Огр: <input id='license1' type='checkbox' name='license1'" . $license1checked . "> Станд: <input id='license2' type='checkbox' name='license2'" . $license2checked . "> Расш: <input id='license3' type='checkbox' name='license3'" . $license3checked . "><br />";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
//}
$output .= "<tr>\n\r";
$output .= "<td colspan='2'>";
if (isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<a href='admin.php?page=wp-shopping-cart/display-items.php&deleteid=" . $product['id'] . "' onclick='return conf();'><img src='../img/trash.gif' title='удалить'></a>";
}
$output .= "<a href='admin.php?page=wp-shopping-cart/display-items.php&updateimage=" . $product['id'] . "' ><img src='" . SITEURL . "/img/reload.gif' title='Обновить иконку и слайд с водяными знаками'></a>";
$output .= " <a href='index.php?admin_preview=true&product_id=" . $product['id'] . $idhash . "' style='float: left;' ><img src='http://th.cartoonbank.ru/download.gif' title='Скачать оригинальный файл' /></a>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
// download original image
if ($product['file'] > 0) {
if (is_numeric($product['file']) && $product['file'] > 0) {
$file_data = $wpdb->get_results("SELECT * FROM `wp_product_files` WHERE `id`='" . $product['file'] . "' LIMIT 1", ARRAY_A);
if ($file_data != null && $file_data[0]['mimetype'] == 'audio/mpeg' && function_exists('listen_button')) {
$output .= " " . listen_button($file_data[0]['idhash']);
}
}
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "<tr>\n\r";
$output .= "<td class='r'>";
$output .= "Заменить файл:";
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= "<input type='file' name='file' value='' /> <div style='color:#999;'>Это тот файл, ссылка на который<br />будет отправлена заказчику</div>";
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
}
$output .= "<tr>\n\r";
$output .= "<td>\n\r";
$output .= "</td>\n\r";
$output .= "<td>\n\r";
$output .= "<input type='hidden' name='prodid' value='" . $product['id'] . "' />";
$output .= "<input type='hidden' name='submit_action' value='edit' />";
$output .= "<br /><input type=\"button\" class='edit_button' style='padding:6px; background-color:#84DF88;' name='sendit' value='Сохранить изменения' onclick=\"checkthefieldsEditForm();\"/>";
if ($product['approved'] != '1' && isset($current_user->wp_capabilities['editor']) && $current_user->wp_capabilities['editor'] == 1) {
$output .= "<br /><br /><br /><br /><a class='button' href='admin.php?page=wp-shopping-cart/display-items.php&deleteid=" . $product['id'] . "' onclick=\"return conf();\" ><img src='" . SITEURL . "/img/trash.gif'> стереть изображение!</a>";
}
if ($product['approved'] == '1' && isset($current_user->wp_capabilities['administrator']) && $current_user->wp_capabilities['administrator'] == 1) {
$output .= "<br /><br /><br /><br /><a class='button' href='admin.php?page=wp-shopping-cart/display-items.php&deleteid=" . $product['id'] . "' onclick=\"return conf();\" ><img src='" . SITEURL . "/img/trash.gif'> стереть изображение</a>";
}
$output .= "</td>\n\r";
$output .= "</tr>\n\r";
$output .= "</table>\n\r";
// TODO: Remove before upload to the server! temp! local debug only!
if ($_SERVER['SERVER_NAME'] == 'localhost') {
$output = Utf8ToWin($output);
}
return $output;
}
echo " <div id='formcontent'>\n\r";
echo " </div>\n\r";
echo "</form>";
echo " </div>";
?>
<div id='additem'>
<form id='editproductform' method='POST' enctype='multipart/form-data'>
<table class='additem'>
<tr>
<td class="r">
Artist:
</td>
<td>
<?php
echo brandslist();
?>
<!-- <input id='approved' type="checkbox" name="approved"> Утверждено. -->
</td>
</tr>
<tr class='tdfirstcol'>
<td class='r'>
Select the file on your local drive:
</td>
<td>
<input id='fileupload' type='file' name='file' value='' />
</td>
</tr>
<tr>
<td class='r'>
Title:
