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;
}
public static function batchDelete()
{
$result = lC_Orders_status_Admin::batchDelete($_GET['batch']);
if (isset($result['namesString']) && $result['namesString'] != null) {
} else {
$result['rpcStatus'] = RPC_STATUS_SUCCESS;
}
echo json_encode($result);
}
