function deleteProductVariant()
{
global $toC_Json, $osC_Database, $osC_Language;
$error = false;
$feedback = array();
$Qproducts = $osC_Database->query('select count(*) as total_products from :table_products_variants_entries where products_variants_groups_id = :products_variants_groups_id');
$Qproducts->bindTable(':table_products_variants_entries', TABLE_PRODUCTS_VARIANTS_ENTRIES);
$Qproducts->bindInt(':products_variants_groups_id', $_REQUEST['products_variants_groups_id']);
$Qproducts->execute();
if ($Qproducts->value('total_products') > 0) {
$error = true;
$feedback[] = sprintf($osC_Language->get('delete_error_variant_group_in_use'), $Qproducts->value('total_products'));
}
if ($error === false) {
if (osC_ProductVariants_Admin::delete($_REQUEST['products_variants_groups_id'])) {
$response = array('success' => true, 'feedback' => $osC_Language->get('ms_success_action_performed'));
} else {
$response = array('success' => false, 'feedback' => $osC_Language->get('ms_error_action_not_performed'));
}
} else {
$response = array('success' => false, 'feedback' => $osC_Language->get('ms_error_action_not_performed') . '<br />' . implode('<br />', $feedback));
}
echo $toC_Json->encode($response);
}
function __construct()
{
global $osC_Language, $osC_MessageStack;
$this->_page_title = $osC_Language->get('heading_title');
if (!isset($_GET['action'])) {
$_GET['action'] = '';
}
if (!isset($_GET['page']) || isset($_GET['page']) && !is_numeric($_GET['page'])) {
$_GET['page'] = 1;
}
if (!empty($_GET[$this->_module]) && is_numeric($_GET[$this->_module])) {
$this->_page_contents = 'entries.php';
$this->_page_title .= ': ' . osC_ProductVariants_Admin::getData($_GET[$this->_module], null, 'title');
}
if (!empty($_GET['action'])) {
switch ($_GET['action']) {
case 'save':
if (isset($_GET['paID']) && is_numeric($_GET['paID'])) {
$this->_page_contents = 'edit.php';
} else {
$this->_page_contents = 'new.php';
}
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$data = array('name' => $_POST['group_name'], 'module' => $_POST['module'], 'sort_order' => $_POST['sort_order']);
if (osC_ProductVariants_Admin::save(isset($_GET['paID']) && is_numeric($_GET['paID']) ? $_GET['paID'] : null, $data)) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '&page=' . $_GET['page']));
}
break;
case 'delete':
$this->_page_contents = 'delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
if (osC_ProductVariants_Admin::delete($_GET['paID'])) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '&page=' . $_GET['page']));
}
break;
case 'batchDelete':
if (isset($_POST['batch']) && is_array($_POST['batch']) && !empty($_POST['batch'])) {
$this->_page_contents = 'batch_delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$error = false;
foreach ($_POST['batch'] as $id) {
if (!osC_ProductVariants_Admin::delete($id)) {
$error = true;
break;
}
}
if ($error === false) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '&page=' . $_GET['page']));
}
}
break;
case 'saveEntry':
if (isset($_GET['paeID']) && is_numeric($_GET['paeID'])) {
$this->_page_contents = 'entries_edit.php';
} else {
$this->_page_contents = 'entries_new.php';
}
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$data = array('group_id' => $_GET[$this->_module], 'name' => $_POST['entry_name'], 'sort_order' => $_POST['sort_order']);
if (osC_ProductVariants_Admin::saveEntry(isset($_GET['paeID']) && is_numeric($_GET['paeID']) ? $_GET['paeID'] : null, $data)) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '=' . $_GET[$this->_module] . '&page=' . $_GET['page']));
}
break;
case 'deleteEntry':
$this->_page_contents = 'entries_delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
if (osC_ProductVariants_Admin::deleteEntry($_GET['paeID'], $_GET[$this->_module])) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '=' . $_GET[$this->_module] . '&page=' . $_GET['page']));
}
break;
case 'batchDeleteEntries':
if (isset($_POST['batch']) && is_array($_POST['batch']) && !empty($_POST['batch'])) {
$this->_page_contents = 'entries_batch_delete.php';
if (isset($_POST['subaction']) && $_POST['subaction'] == 'confirm') {
$error = false;
foreach ($_POST['batch'] as $id) {
if (!osC_ProductVariants_Admin::deleteEntry($id, $_GET[$this->_module])) {
$error = true;
break;
}
}
if ($error === false) {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_success_action_performed'), 'success');
} else {
$osC_MessageStack->add($this->_module, $osC_Language->get('ms_error_action_not_performed'), 'error');
}
osc_redirect_admin(osc_href_link_admin(FILENAME_DEFAULT, $this->_module . '=' . $_GET[$this->_module] . '&page=' . $_GET['page']));
}
}
break;
}
}
}