File "delete.php"

Full path: /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/api/assessment_settings/delete.php
File size: 1.55 KiB (1584 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
require_once '../../config/config.php';
require_once '../helper/audit_log.php';
header('Content-Type: application/json');
try { 
    $raw=file_get_contents('php://input'); $input=json_decode($raw,true);
    $id=0; if(is_array($input)&&isset($input['id'])){ $id=(int)$input['id']; } elseif(isset($_POST['id'])){ $id=(int)$_POST['id']; }
    if($id<=0){ echo json_encode(['status'=>'error','message'=>'Invalid ID.']); exit; }
    $before=null; try{ $b=$pdo->prepare('SELECT * FROM subject_assessment_settings WHERE setting_id=?'); $b->execute([$id]); $before=$b->fetch(PDO::FETCH_ASSOC);}catch(Throwable $e){}
    if(!$before){ http_response_code(404); echo json_encode(['status'=>'error','message'=>'Assessment setting not found.']); exit; }

    try{ $stmt=$pdo->prepare('DELETE FROM subject_assessment_settings WHERE setting_id=?'); $stmt->execute([$id]); }
    catch(PDOException $e){ $info=$e->errorInfo??null; if(is_array($info)&&isset($info[1])&&(int)$info[1]===1451){ http_response_code(409); echo json_encode(['status'=>'error','message'=>'Cannot delete: assessment setting is referenced by other records.']); exit; } throw $e; }

    write_audit_log($pdo, ['module'=>'Grading System','action'=>'delete','entity_table'=>'subject_assessment_settings','entity_id'=>$id,'before_data'=>$before,'message'=>'Assessment setting deleted']); echo json_encode(['status'=>'success','message'=>'Assessment setting deleted successfully.']); 
} catch (Throwable $e){ http_response_code(500); echo json_encode(['status'=>'error','message'=>'Request failed. Please try again.']); }
?>