$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;
}
}
