$products_name_query = vam_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $reviews['products_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'"); $products_name = vam_db_fetch_array($products_name_query); $reviews_average_query = vam_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . $reviews['products_id'] . "'"); $reviews_average = vam_db_fetch_array($reviews_average_query); $review_info = vam_array_merge($reviews_text, $reviews_average, $products_name); $rInfo_array = vam_array_merge($reviews, $review_info, $products_image); $rInfo = new objectInfo($rInfo_array); } if (is_object($rInfo) && $reviews['reviews_id'] == $rInfo->reviews_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=preview') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id'] . '&action=preview') . '">' . vam_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . vam_get_products_name($reviews['products_id']); ?> </td> <td class="dataTableContent" align="right"><?php echo vam_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/stars_' . $reviews['reviews_rating'] . '.gif'); ?> </td> <td class="dataTableContent" align="right"><?php echo vam_date_short($reviews['date_added']); ?> </td> <td class="dataTableContent" align="center"> <?php if ($reviews['marked'] == 1) { echo '<img src="images/icon_status_green.gif" border="0" alt="Enabled" title="Enabled" width="10" height="10"/>'; echo '<a class="disable" href="javascript:void(0);" data_id="' . $reviews['reviews_id'] . '"><img src="images/icon_status_red_light.gif" border="0" alt="Disable" title="Disable" width="10" height="10"/><a>';
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=edit_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a>'); //Insert new Element Actions $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INSERT_ELEMENT . '</div>'); if (!$_GET['search']) { $contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/categories.png', '', '12', '12') . ' ' . BUTTON_NEW_CATEGORIES . '</span></a></td></tr><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/products.png', '', '12', '12') . ' ' . BUTTON_NEW_PRODUCTS . '</span></a></td></tr></table>'); } //Informations $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INFORMATIONS . '</div>'); $contents[] = array('text' => '<div style="padding-left: 50px;">' . TEXT_DATE_ADDED . ' ' . vam_date_short($cInfo->date_added) . '</div>'); if (vam_not_null($cInfo->last_modified)) { $contents[] = array('text' => '<div style="padding-left: 50px;">' . TEXT_LAST_MODIFIED . ' ' . vam_date_short($cInfo->last_modified) . '</div>'); } $contents[] = array('align' => 'center', 'text' => '<div style="padding: 10px;">' . vam_info_image_c($cInfo->categories_image, $cInfo->categories_name, 100, 100) . '</div><div style="padding-bottom: 10px;">' . $cInfo->categories_image . '</div>'); } elseif (is_object($pInfo)) { // product info box contents $heading[] = array('align' => 'center', 'text' => '<b>' . vam_get_products_name($pInfo->products_id, $_SESSION['languages_id']) . '</b>'); //Multi Element Actions $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%;">' . TEXT_MARKED_ELEMENTS . '</div>'); $contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center">' . '<span class="button"><button type="submit" value="' . BUTTON_DELETE . '" name="multi_delete">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</button></span>' . '</td></tr><tr><td>' . '<span class="button"><button type="submit" value="' . BUTTON_MOVE . '" name="multi_move">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/move.png', '', '12', '12') . ' ' . BUTTON_MOVE . '</button></span>' . '</td></tr><tr><td align="center">' . '<span class="button"><button type="submit" value="' . BUTTON_COPY . '" name="multi_copy">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/copy.png', '', '12', '12') . ' ' . BUTTON_COPY . '</button></span>' . '</td></tr></table>'); $contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><span class="button"><button type="submit" name="multi_status_on" value="' . BUTTON_STATUS_ON . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_STATUS_ON . '</button></span></td></tr><tr><td align="center"><span class="button"><button type="submit" name="multi_status_off" value="' . BUTTON_STATUS_OFF . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_STATUS_OFF . '</button></span></td></tr></table>'); $contents[] = array('text' => '</form>'); //Single Product Actions $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_ACTIVE_ELEMENT . '</div>'); $contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a></td></tr><tr><td align="center"><form action="' . FILENAME_NEW_ATTRIBUTES . '" name="edit_attributes" method="post"><input type="hidden" name="action" value="edit"><input type="hidden" name="current_product_id" value="' . $pInfo->products_id . '"><input type="hidden" name="cpath" value="' . $cPath . '"><span class="button"><button type="submit" value="' . BUTTON_EDIT_ATTRIBUTES . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/add.png', '', '12', '12') . ' ' . BUTTON_EDIT_ATTRIBUTES . '</button></span></form></td></tr><tr><td align="center" style="text-align: center;"><form action="' . FILENAME_CATEGORIES . '" name="edit_crossselling" method="GET"><input type="hidden" name="action" value="edit_crossselling"><input type="hidden" name="current_product_id" value="' . $pInfo->products_id . '"><input type="hidden" name="cpath" value="' . $cPath . '"><span class="button"><button type="submit" value="' . BUTTON_EDIT_CROSS_SELLING . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/add.png', '', '12', '12') . ' ' . BUTTON_EDIT_CROSS_SELLING . '</button></span></form></td></tr></table>'); //Insert new Element Actions $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INSERT_ELEMENT . '</div>'); if (!$_GET['search']) { $contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/categories.png', '', '12', '12') . ' ' . BUTTON_NEW_CATEGORIES . '</span></a></td></tr><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/products.png', '', '12', '12') . ' ' . BUTTON_NEW_PRODUCTS . '</span></a></td></tr></table>'); } //Informations $contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INFORMATIONS . '</div>');
<td class="dataTableHeadingContent" width="40%"><?php echo PIN_HEADING_PRODUCT; ?></td> <td class="dataTableHeadingContent" width="40%"><?php echo PIN_HEADING_NUMBEROF; ?></td> <td class="dataTableHeadingContent" width="20%"><?php echo PIN_HEADING_ACTION; ?></td> </tr> <?php $query_str = "SELECT pp.products_id, p.products_quantity AS pcount, count(*) AS all_pin FROM ".TABLE_PRODUCTS_PINS." pp, " . TABLE_PRODUCTS . " p where pp.products_id = p.products_id GROUP BY pp.products_id"; //echo($query_str); $pins_query=vam_db_query($query_str); $odd_even = 1; while($pin_res=vam_db_fetch_array($pins_query)) { $row_class = ( ($odd_even % 2) == 0 ) ? 'dataTableRowSelected' : 'dataTableRow'; ?> <tr class="<?php echo $row_class?>"> <td class="dataTableContent"> <?php echo vam_get_products_name($pin_res['products_id']);?></td> <td class="dataTableContent"><?php echo $pin_res['pcount'].' / ' . $pin_res['all_pin']?></td> <td class="dataTableContent"><a href="<?php echo vam_href_link(FILENAME_PIN_LOADER, 'action=edit&products_id='.$pin_res['products_id'], 'SSL');?>"><?php echo PIN_ACTION_EDIT?></a></td> </tr> <? $odd_even++; } /* $pins_query=vam_db_query("SELECT products_id, COUNT(*) AS pcount FROM ".TABLE_PRODUCTS_PINS." GROUP BY products_id"); while($pin_res=vam_db_fetch_array($pins_query)) { echo '<tr class="dataTableRow"><td class="dataTableContent">'.vam_get_products_name($pin_res['products_id']).'</td><td class="dataTableContent">'.$pin_res['pcount'].'</td></tr>'; } */ ?> </table>
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?> <div id="tab<?php echo $i; ?> "> <table border="0"> <tr> <td valign="top" class="main"><?php echo TEXT_PRODUCTS_NAME; ?> </td> <td valign="top" class="main"><?php echo vam_draw_input_field('products_name[' . $languages[$i]['id'] . ']', $products_name[$languages[$i]['id']] ? stripslashes($products_name[$languages[$i]['id']]) : vam_get_products_name($pInfo->products_id, $languages[$i]['id']), 'size=60'); ?> </td> </tr> <tr> <td valign="top" class="main"><?php echo TEXT_PRODUCTS_URL; ?> </td> <td valign="top" class="main"><?php echo vam_draw_input_field('products_url[' . $languages[$i]['id'] . ']', $products_url[$languages[$i]['id']] ? stripslashes($products_url[$languages[$i]['id']]) : vam_get_products_url($pInfo->products_id, $languages[$i]['id']), 'size=60') . ' <small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?> </td> </tr> <tr> <td valign="top" class="main"><?php