Example #1
0
 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;
         }
     }
 }