$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_XSELL_GROUP . '</b>'); $contents = array('form' => xtc_draw_form('status', FILENAME_XSELL_GROUPS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->products_xsell_grp_name_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br /><b>' . $oInfo->orders_status_name . '</b>'); if ($remove_status) { $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="btn btn-default" onclick="this.blur();" value="' . BUTTON_DELETE . '"/> <a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_XSELL_GROUPS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->products_xsell_grp_name_id) . '">' . BUTTON_CANCEL . '</a>'); } break; default: if (is_object($oInfo)) { $heading[] = array('text' => '<b>' . $oInfo->groupname . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_XSELL_GROUPS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->products_xsell_grp_name_id . '&action=edit') . '#edit-box">' . BUTTON_EDIT . '</a> <a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_XSELL_GROUPS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->products_xsell_grp_name_id . '&action=delete') . '#edit-box">' . BUTTON_DELETE . '</a>'); $cross_sell_inputs_string = ''; $languages = xtc_get_languages(); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $cross_sell_inputs_string .= '<br />' . xtc_image(DIR_WS_LANGUAGES . $languages[$i]['directory'] . '/admin/images/' . $languages[$i]['image']) . ' ' . xtc_get_cross_sell_name($oInfo->products_xsell_grp_name_id, $languages[$i]['id']); } $contents[] = array('text' => $cross_sell_inputs_string); } break; } if (xtc_not_null($heading) && xtc_not_null($contents)) { echo ' <div class="col-md-3 col-sm-12 col-xs-12 pull-right edit-box-class">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </div>' . "\n"; ?> <script> //responsive_table $('#responsive_table').addClass('col-md-9'); </script>
/** * Get Cross sells * * @return array */ function getCrossSells() { global $xtPrice; $cs_groups = "SELECT products_xsell_grp_name_id\n FROM " . TABLE_PRODUCTS_XSELL . "\n WHERE products_id = '" . $this->pID . "'\n GROUP BY products_xsell_grp_name_id"; $cs_groups = xtDBquery($cs_groups); $cross_sell_data = array(); if (xtc_db_num_rows($cs_groups, true) > 0) { while ($cross_sells = xtc_db_fetch_array($cs_groups, true)) { $fsk_lock = ''; if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') { $fsk_lock = ' AND p.products_fsk18!=1'; } $group_check = ""; if (GROUP_CHECK == 'true') { $group_check = " AND p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 "; } $cross_query = "SELECT " . $this->default_select . ",\n xp.sort_order\n FROM " . TABLE_PRODUCTS_XSELL . " xp,\n " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd\n WHERE xp.products_id = " . $this->pID . "\n AND xp.xsell_id = p.products_id " . $fsk_lock . $group_check . "\n AND p.products_id = pd.products_id\n AND xp.products_xsell_grp_name_id='" . $cross_sells['products_xsell_grp_name_id'] . "'\n AND pd.language_id = " . (int) $_SESSION['languages_id'] . "\n AND trim(pd.products_name) != ''\n AND p.products_status = 1\n ORDER BY xp.sort_order asc"; $cross_query = xtDBquery($cross_query); if (xtc_db_num_rows($cross_query, true) > 0) { $cross_sell_data[$cross_sells['products_xsell_grp_name_id']] = array('GROUP' => xtc_get_cross_sell_name($cross_sells['products_xsell_grp_name_id']), 'PRODUCTS' => array()); } while ($xsell = xtc_db_fetch_array($cross_query, true)) { $cross_sell_data[$cross_sells['products_xsell_grp_name_id']]['PRODUCTS'][] = $this->buildDataArray($xsell); } } return $cross_sell_data; } }