PageRenderTime 61ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

/admin/includes/modules/product/collect_info_metatags.php

https://github.com/bitweaver/commerce
PHP | 169 lines | 136 code | 6 blank | 27 comment | 15 complexity | e67d44a5c27c8919915f332da4c55592 MD5 | raw file
    

  1. <?php
    2. 

  2. //
    3. 

  3. // +----------------------------------------------------------------------+
    4. 

  4. // |zen-cart Open Source E-commerce                                       |
    5. 

  5. // +----------------------------------------------------------------------+
    6. 

  6. // | Copyright (c) 2004 The zen-cart developers                           |
    7. 

  7. // |                                                                      |
    8. 

  8. // | http://www.zen-cart.com/index.php                                    |
    9. 

  9. // |                                                                      |
    10. 

  10. // | Portions Copyright (c) 2003 osCommerce                               |
    11. 

  11. // +----------------------------------------------------------------------+
    12. 

  12. // | This source file is subject to version 2.0 of the GPL license,       |
    13. 

  13. // | that is bundled with this package in the file LICENSE, and is        |
    14. 

  14. // | available through the world-wide-web at the following url:           |
    15. 

  15. // | http://www.zen-cart.com/license/2_0.txt.                             |
    16. 

  16. // | If you did not receive a copy of the zen-cart license and are unable |
    17. 

  17. // | to obtain it through the world-wide-web, please send a note to       |
    18. 

  18. // | license@zen-cart.com so we can mail you a copy immediately.          |
    19. 

  19. // +----------------------------------------------------------------------+
    20. 

  20. //  $Id$
    21. 

  21. //
    22. 

  22. 

  23.     $parameters = array(
    24. 

  24.                        'products_name' => '',
    25. 

  25.                        'products_model' => '',
    26. 

  26.                        'metatags_title_status' => '',
    27. 

  27.                        'metatags_products_name_status' => '',
    28. 

  28.                        'metatags_model_status' => '',
    29. 

  29.                        'products_id' => '',
    30. 

  30.                        'metatags_price_status' => '',
    31. 

  31.                        'metatags_title_tagline_status' => '',
    32. 

  32.                        'metatags_title' => '',
    33. 

  33.                        'metatags_keywords' => '',
    34. 

  34.                        'metatags_description' => ''
    35. 

  35.                        );
    36. 

  36. 

  37.     $pInfo = new objectInfo($parameters);
    38. 

  38. 

  39.     if (isset($_GET['products_id']) && empty($_POST)) {
    40. 

  40. // check if new meta tags or existing
    41. 

  41.     $check_meta_tags_description = $gBitDb->Execute("select `products_id` from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " where `products_id` ='" . (int)$_GET['products_id'] . "'");
    42. 

  42.     if ($check_meta_tags_description->RecordCount() <= 0) {
    43. 

  43.       $product = $gBitDb->Execute("select pd.`products_name`, p.`products_model`, p.`lowest_purchase_price`,
    44. 

  44.                                       p.`metatags_title_status`, p.`metatags_products_name_status`, p.`metatags_model_status`,
    45. 

  45.                                       p.`products_id`, p.`metatags_price_status`, p.`metatags_title_tagline_status`
    46. 

  46.                               from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
    47. 

  47.                               where p.`products_id` = '" . (int)$_GET['products_id'] . "'
    48. 

  48.                               and p.`products_id` = pd.`products_id`
    49. 

  49.                               and pd.`language_id` = '" . (int)$_SESSION['languages_id'] . "'");
    50. 

  50.     } else {
    51. 

  51.       $product = $gBitDb->Execute("select pd.`products_name`, p.`products_model`, p.`lowest_purchase_price`,
    52. 

  52.                                       p.`metatags_title_status`, p.`metatags_products_name_status`, p.`metatags_model_status`,
    53. 

  53.                                       p.`products_id`, p.`metatags_price_status`, p.`metatags_title_tagline_status`,
    54. 

  54.                                       mtpd.`metatags_title`, mtpd.`metatags_keywords`, mtpd.`metatags_description`
    55. 

  55.                               from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd
    56. 

  56.                               where p.`products_id` = '" . (int)$_GET['products_id'] . "'
    57. 

  57.                               and p.`products_id` = pd.`products_id`
    58. 

  58.                               and pd.`language_id` = '" . (int)$_SESSION['languages_id'] . "'
    59. 

  59.                               and p.`products_id` = mtpd.`products_id`
    60. 

  60.                               and mtpd.`language_id` = '" . (int)$_SESSION['languages_id'] . "'");
    61. 

  61.     }
    62. 

  62. 

  63.       $pInfo->objectInfo($product->fields);
    64. 

  64.     } elseif (zen_not_null($_POST)) {
    65. 

  65.       $pInfo->objectInfo($_POST);
    66. 

  66.       $metatags_title = $_POST['metatags_title'];
    67. 

  67.       $metatags_keywords = $_POST['metatags_keywords'];
    68. 

  68.       $metatags_description = $_POST['metatags_description'];
    69. 

  69.     }
    70. 

  70. 

  71.     $languages = zen_get_languages();
    72. 

  72. 

  73. // metatags_products_name_status shows
    74. 

  74.     if (empty($pInfo->metatags_keywords) and empty($pInfo->metatags_description)) $pInfo->metatags_products_name_status = zen_get_show_product_switch($_GET['products_id'], 'metatags_products_name_status');
    75. 

  75.     switch ($pInfo->metatags_products_name_status) {
    76. 

  76.       case '0': $is_metatags_products_name_status = false; $not_metatags_products_name_status = true; break;
    77. 

  77.       case '1': $is_metatags_products_name_status = true;  $not_metatags_products_name_status = false; break;
    78. 

  78.       default:  $is_metatags_products_name_status = true;  $not_metatags_products_name_status = false;
    79. 

  79.     }
    80. 

  80. // metatags_title_status shows
    81. 

  81.     if (empty($pInfo->metatags_keywords) and empty($pInfo->metatags_description)) $pInfo->metatags_title_status = zen_get_show_product_switch($_GET['products_id'], 'metatags_title_status');
    82. 

  82.     switch ($pInfo->metatags_title_status) {
    83. 

  83.       case '0': $is_metatags_title_status = false; $not_metatags_title_status = true; break;
    84. 

  84.       case '1': $is_metatags_title_status = true;  $not_metatags_title_status = false; break;
    85. 

  85.       default:  $is_metatags_title_status = true;  $not_metatags_title_status = false;
    86. 

  86.     }
    87. 

  87. // metatags_model_status shows
    88. 

  88.     if (empty($pInfo->metatags_keywords) and empty($pInfo->metatags_description)) $pInfo->metatags_model_status = zen_get_show_product_switch($_GET['products_id'], 'metatags_model_status');
    89. 

  89.     switch ($pInfo->metatags_model_status) {
    90. 

  90.       case '0': $is_metatags_model_status = false; $not_metatags_model_status = true; break;
    91. 

  91.       case '1': $is_metatags_model_status = true;  $not_metatags_model_status = false; break;
    92. 

  92.       default:  $is_metatags_model_status = true;  $not_metatags_model_status = false;
    93. 

  93.     }
    94. 

  94. // metatags_price_status shows
    95. 

  95.     if (empty($pInfo->metatags_keywords) and empty($pInfo->metatags_description)) $pInfo->metatags_price_status = zen_get_show_product_switch($_GET['products_id'], 'metatags_price_status');
    96. 

  96.     switch ($pInfo->metatags_price_status) {
    97. 

  97.       case '0': $is_metatags_price_status = false; $not_metatags_price_status = true; break;
    98. 

  98.       case '1': $is_metatags_price_status = true;  $not_metatags_price_status = false; break;
    99. 

  99.       default:  $is_metatags_price_status = true;  $not_metatags_price_status = false;
    100. 

  100.     }
    101. 

  101. // metatags_title_tagline_status shows TITLE and TAGLINE in metatags_header.php
    102. 

  102.     if (empty($pInfo->metatags_keywords) and empty($pInfo->metatags_description)) $pInfo->metatags_title_tagline_status = zen_get_show_product_switch($_GET['products_id'], 'metatags_title_tagline_status');
    103. 

  103.     switch ($pInfo->metatags_title_tagline_status) {
    104. 

  104.       case '0': $is_metatags_title_tagline_status = false; $not_metatags_title_tagline_status = true; break;
    105. 

  105.       case '1': $is_metatags_title_tagline_status = true;  $not_metatags_title_tagline_status = false; break;
    106. 

  106.       default:  $is_metatags_title_tagline_status = true;  $not_metatags_title_tagline_status = false;
    107. 

  107.     }
    108. 

  108. ?>
    109. 

  109.     <?php
    110. 

  110. //  echo $type_admin_handler;
    111. 

  111. echo zen_draw_form_admin('new_product_meta_tags', $type_admin_handler , 'cPath=' . $cPath . (isset($_GET['product_type']) ? '&product_type=' . $_GET['product_type'] : '') . (isset($_GET['products_id']) ? '&products_id=' . $_GET['products_id'] : '') . '&action=new_product_preview_meta_tags' . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'post', 'enctype="multipart/form-data"'); ?>
    112. 

  112. 			<h2><?php echo TEXT_META_TAG_TITLE_INCLUDES; ?></h2>
    113. 

  113.           <table border="1" cellspacing="0" cellpadding="2">
    114. 

  114.             <tr>
    115. 

  115.               <td class="main" align="center">
    116. 

  116.                 <?php echo TEXT_PRODUCTS_METATAGS_PRODUCTS_NAME_STATUS . '<br />' . zen_draw_radio_field('metatags_products_name_status', '1', $is_metatags_products_name_status) . '&nbsp;' . TEXT_YES . '&nbsp;' . zen_draw_radio_field('metatags_products_name_status', '0', $not_metatags_products_name_status) . '&nbsp;' . TEXT_NO; ?>
    117. 

  117.               </td>
    118. 

  118.               <td class="main" align="center">
    119. 

  119.                 <?php echo TEXT_PRODUCTS_METATAGS_TITLE_STATUS . '<br />' . zen_draw_radio_field('metatags_title_status', '1', $is_metatags_title_status) . '&nbsp;' . TEXT_YES . '&nbsp;' . zen_draw_radio_field('metatags_title_status', '0', $not_metatags_title_status) . '&nbsp;' . TEXT_NO; ?>
    120. 

  120.               </td>
    121. 

  121.               <td class="main" align="center">
    122. 

  122.                 <?php echo TEXT_PRODUCTS_METATAGS_MODEL_STATUS . '<br />' . zen_draw_radio_field('metatags_model_status', '1', $is_metatags_model_status) . '&nbsp;' . TEXT_YES . '&nbsp;' . zen_draw_radio_field('metatags_model_status', '0', $not_metatags_model_status) . '&nbsp;' . TEXT_NO; ?>
    123. 

  123.               </td>
    124. 

  124.               <td class="main" align="center">
    125. 

  125.                 <?php echo TEXT_PRODUCTS_METATAGS_PRICE_STATUS . '<br />' . zen_draw_radio_field('metatags_price_status', '1', $is_metatags_price_status) . '&nbsp;' . TEXT_YES . '&nbsp;' . zen_draw_radio_field('metatags_price_status', '0', $not_metatags_price_status) . '&nbsp;' . TEXT_NO; ?>
    126. 

  126.               </td>
    127. 

  127.               <td class="main" align="center">
    128. 

  128.                 <?php echo TEXT_PRODUCTS_METATAGS_TITLE_TAGLINE_STATUS . '<br />' . zen_draw_radio_field('metatags_title_tagline_status', '1', $is_metatags_title_tagline_status) . '&nbsp;' . TEXT_YES . '&nbsp;' . zen_draw_radio_field('metatags_title_tagline_status', '0', $not_metatags_title_tagline_status) . '&nbsp;' . TEXT_NO; ?>
    129. 

  129.               </td>
    130. 

  130.             </tr>
    131. 

  131.           </table>
    132. 

  132. <?php
    133. 

  133.     for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
    134. 

  134. ?>
    135. 

  135.         <table >
    136. 

  136.           <tr>
    137. 

  137.             <td class="main" colspan="2">
    138. 

  138.               <?php echo zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . '<strong>' . TEXT_PRODUCTS_NAME . '</strong>' . '&nbsp;' . zen_get_products_name($_GET['products_id'], $languages[$i]['id']) . '&nbsp;&nbsp;&nbsp;<strong>' . TEXT_PRODUCTS_MODEL . '</strong>&nbsp;' . $pInfo->products_model . '&nbsp;&nbsp;&nbsp;<strong>' . TEXT_PRODUCTS_PRICE_INFO . '</strong>&nbsp;' . $currencies->format($pInfo->lowest_purchase_price); ?>
    139. 

  139.             </td>
    140. 

  140.           </tr>
    141. 

  141.           <tr>
    142. 

  142.             <td class="main"valign="top"><?php echo TEXT_META_TAGS_TITLE; ?>&nbsp;</td>
    143. 

  143.             <td class="main">
    144. 

  144.               <?php echo zen_draw_input_field('metatags_title[' . $languages[$i]['id'] . ']', (isset($metatags_title[$languages[$i]['id']]) ? stripslashes($metatags_title[$languages[$i]['id']]) : zen_get_metatags_title($pInfo->products_id, $languages[$i]['id'])), zen_set_field_length(TABLE_META_TAGS_PRODUCTS_DESCRIPTION, 'metatags_title', '', true)); //,'id="'.'metatags_title' . $languages[$i]['id'] . '"');?>
    145. 

  145.             </td>
    146. 

  146.           </tr>
    147. 

  147.           <tr>
    148. 

  148.             <td class="main"valign="top"><?php echo TEXT_META_TAGS_KEYWORDS; ?>&nbsp;</td>
    149. 

  149.             <td class="main">
    150. 

  150.               <?php echo zen_draw_textarea_field('metatags_keywords[' . $languages[$i]['id'] . ']', 'soft', '100%', '10', (isset($metatags_keywords[$languages[$i]['id']])) ? stripslashes($metatags_keywords[$languages[$i]['id']]) : zen_get_metatags_keywords($pInfo->products_id, $languages[$i]['id'])); //,'id="'.'metatags_keywords' . $languages[$i]['id'] . '"'); ?>
    151. 

  151.             </td>
    152. 

  152.           </tr>
    153. 

  153.           <tr>
    154. 

  154.             <td class="main"valign="top"><?php echo TEXT_META_TAGS_DESCRIPTION; ?>&nbsp;</td>
    155. 

  155.             <td class="main">
    156. 

  156.               <?php echo zen_draw_textarea_field('metatags_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '10', (isset($metatags_description[$languages[$i]['id']])) ? stripslashes($metatags_description[$languages[$i]['id']]) : zen_get_metatags_description($pInfo->products_id, $languages[$i]['id'])); //,'id="'.'metatags_description' . $languages[$i]['id'] . '"'); ?>
    157. 

  157.             </td>
    158. 

  158.           </tr>
    159. 

  159.         </table>
    160. 

  160. <?php
    161. 

  161.     }
    162. 

  162. ?>
    163. 

  163.       <tr>
    164. 

  164.         <td class="main" align="left"><?php echo TEXT_INFO_META_TAGS_USAGE; ?></td>
    165. 

  165.       </tr>
    166. 

  166.       <tr>
    167. 

  167.         <td class="main" align="right"><?php echo zen_draw_hidden_field('products_model', $pInfo->products_model) . zen_draw_hidden_field('lowest_purchase_price', $pInfo->lowest_purchase_price) . zen_image_submit('button_preview.gif', IMAGE_PREVIEW) . '&nbsp;&nbsp;<a href="' . zen_href_link_admin(FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($_GET['products_id']) ? '&products_id=' . $_GET['products_id'] : '') . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
    168. 

  168.       </tr>
    169. 

  169.     </table></form>
    170. 

  170.