static function DeleteType()
{
global $zdbh;
global $controller;
$numrecords = 0;
$type = $controller->GetControllerRequest('FORM', 'inType');
$sql = "SELECT COUNT(*) FROM x_dns WHERE dn_type_vc = :type AND dn_deleted_ts IS NULL";
$numrows = $zdbh->prepare($sql);
$numrows->bindParam(':type', $type);
if ($numrows->execute()) {
if ($numrows->fetchColumn() != 0) {
$type = $controller->GetControllerRequest('FORM', 'inType');
$sql = $zdbh->prepare("SELECT * FROM x_dns WHERE dn_type_vc = :type AND dn_deleted_ts IS NULL");
$sql->bindParam(':type', $type);
$sql->execute();
while ($row = $sql->fetch()) {
$time = time();
$type = $controller->GetControllerRequest('FORM', 'inType');
$delete_record = $zdbh->prepare("UPDATE x_dns SET dn_deleted_ts=:time WHERE dn_id_pk = :dn_id_pk AND dn_type_vc = :type");
$delete_record->bindParam(':time', $time);
$delete_record->bindParam(':dn_id_pk', $row['dn_id_pk']);
$delete_record->bindParam(':type', $type);
$delete_record->execute();
$numrecords++;
}
self::$deletedtype = $numrecords;
self::$type = $controller->GetControllerRequest('FORM', 'inType');
}
}
}
