public static function deleteStatus() { $result = array(); $deleted = lC_Orders_status_Admin::delete($_GET['osid']); if ($deleted) { $result['rpcStatus'] = RPC_STATUS_SUCCESS; } echo json_encode($result); }
public static function batchDelete($batch) { global $lC_Language, $lC_Database; $lC_Language->loadIniFile('orders_status.php'); $result = array(); $Qstatuses = $lC_Database->query('select orders_status_id, orders_status_name, orders_status_type from :table_orders_status where orders_status_id in (":orders_status_id") and language_id = :language_id order by orders_status_name'); $Qstatuses->bindTable(':table_orders_status', TABLE_ORDERS_STATUS); $Qstatuses->bindRaw(':orders_status_id', implode('", "', array_unique(array_filter(array_slice($batch, 0, MAX_DISPLAY_SEARCH_RESULTS), 'is_numeric')))); $Qstatuses->bindInt(':language_id', $lC_Language->getID()); $Qstatuses->execute(); $names_string = ''; while ($Qstatuses->next()) { if ($Qstatuses->value('orders_status_id') == DEFAULT_ORDERS_STATUS_ID) { $names_string .= $Qstatuses->value('orders_status_name') . ' (' . $lC_Language->get('default') . ') ,'; } $Qorders = $lC_Database->query('select count(*) as total from :table_orders where orders_status = :orders_status'); $Qorders->bindTable(':table_orders', TABLE_ORDERS); $Qorders->bindInt(':orders_status', $Qstatuses->valueInt('orders_status_id')); $Qorders->execute(); if ($Qorders->valueInt('total') > 0) { $names_string .= $Qstatuses->value('orders_status_name') . ' (' . $Qorders->valueInt('total') . ' ' . $lC_Language->get('orders') . ') ,'; } $Qorders->freeResult(); $Qhistory = $lC_Database->query('select count(*) as total from :table_orders_status_history where orders_status_id = :orders_status_id group by orders_id'); $Qhistory->bindTable(':table_orders_status_history', TABLE_ORDERS_STATUS_HISTORY); $Qhistory->bindInt(':orders_status_id', $Qstatuses->valueInt('orders_status_id')); $Qhistory->execute(); if ($Qhistory->valueInt('total') > 0) { $names_string .= $Qstatuses->value('orders_status_name') . ' (' . $Qhistory->valueInt('total') . ' ' . $lC_Language->get('orders_history') . ') ,'; } $Qhistory->freeResult(); if ($Qstatuses->value('orders_status_id') != DEFAULT_ORDERS_STATUS_ID && $Qorders->valueInt('total') == 0 && $Qhistory->valueInt('total') == 0) { lC_Orders_status_Admin::delete($Qstatuses->value('orders_status_id')); } } if (!empty($names_string)) { $names_string = substr($names_string, 0, -2); } $result['namesString'] = $names_string; $Qstatuses->freeResult(); return $result; }