function deleteProductVariantsEntries()
{
global $toC_Json, $osC_Database, $osC_Language;
$error = false;
$feedback = array();
$check_products_array = array();
$batch = explode(',', $_REQUEST['batch']);
$Qentries = $osC_Database->query('select products_variants_values_id, products_variants_values_name from :table_products_variants_values where products_variants_values_id in (":products_variants_values_id") and language_id = :language_id order by products_variants_values_name');
$Qentries->bindTable(':table_products_variants_values', TABLE_PRODUCTS_VARIANTS_VALUES);
$Qentries->bindRaw(':products_variants_values_id', implode('", "', array_unique(array_filter(array_slice($batch, 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric'))));
$Qentries->bindInt(':language_id', $osC_Language->getID());
$Qentries->execute();
while ($Qentries->next()) {
$Qproducts = $osC_Database->query('select count(*) as total_products from :table_products_variants_entries where products_variants_values_id = :products_variants_values_id');
$Qproducts->bindTable(':table_products_variants_entries', TABLE_PRODUCTS_VARIANTS_ENTRIES);
$Qproducts->bindInt(':products_variants_values_id', $Qentries->valueInt('products_variants_values_id'));
$Qproducts->execute();
if ($Qproducts->valueInt('total_products') > 0) {
$check_products_array[] = $Qentries->value('products_variants_values_name');
}
}
if (!empty($check_products_array)) {
$error = true;
$feedback[] = $osC_Language->get('batch_delete_error_group_entries_in_use') . '<p>' . implode(', ', $check_products_array) . '</p>';
}
if ($error === false) {
foreach ($batch as $id) {
if (!osC_ProductVariants_Admin::deleteEntry($id, $_REQUEST['products_variants_groups_id'])) {
$error = true;
break;
}
}
if ($error === false) {
$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;
}
}
}
