public static function deleteProduct()
{
$result = array();
$deleted = lC_Products_Admin::delete($_GET['pid'], $_GET['categories']);
if ($deleted) {
$result['rpcStatus'] = RPC_STATUS_SUCCESS;
}
echo json_encode($result);
}
public static function batchDelete($batch)
{
foreach ($batch as $id) {
lC_Products_Admin::delete($id);
}
return true;
}
public static function delete($id, $delete_image = false, $delete_products = false)
{
global $lC_Database;
if ($delete_image === true) {
$Qimage = $lC_Database->query('select manufacturers_image from :table_manufacturers where manufacturers_id = :manufacturers_id');
$Qimage->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qimage->bindInt(':manufacturers_id', $id);
$Qimage->execute();
if ($Qimage->numberOfRows() && !lc_empty($Qimage->value('manufacturers_image'))) {
if (file_exists(realpath('../' . DIR_WS_IMAGES . 'manufacturers/' . $Qimage->value('manufacturers_image')))) {
@unlink(realpath('../' . DIR_WS_IMAGES . 'manufacturers/' . $Qimage->value('manufacturers_image')));
}
}
}
$Qm = $lC_Database->query('delete from :table_manufacturers where manufacturers_id = :manufacturers_id');
$Qm->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qm->bindInt(':manufacturers_id', $id);
$Qm->setLogging($_SESSION['module'], $id);
$Qm->execute();
$Qmi = $lC_Database->query('delete from :table_manufacturers_info where manufacturers_id = :manufacturers_id');
$Qmi->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmi->bindInt(':manufacturers_id', $id);
$Qmi->setLogging($_SESSION['module'], $id);
$Qmi->execute();
if ($delete_products === true) {
$Qproducts = $lC_Database->query('select products_id from :table_products where manufacturers_id = :manufacturers_id');
$Qproducts->bindTable(':table_products', TABLE_PRODUCTS);
$Qproducts->bindInt(':manufacturers_id', $id);
$Qproducts->execute();
while ($Qproducts->next()) {
lC_Products_Admin::delete($Qproducts->valueInt('products_id'));
}
} else {
$Qupdate = $lC_Database->query('update :table_products set manufacturers_id = null where manufacturers_id = :manufacturers_id');
$Qupdate->bindTable(':table_products', TABLE_PRODUCTS);
$Qupdate->bindInt(':manufacturers_id', $id);
$Qupdate->setLogging($_SESSION['module'], $id);
$Qupdate->execute();
}
lC_Cache::clear('manufacturers');
return true;
}
