$db = JFactory::getDBo();
try{
    // 開啟事務
    $db->transactionStart();
     
    // 提交
    $db->transactionCommit();
    $res = new StdClass();
    $res->err = (object) ['code' => 0, 'msg' => '發(fā)送成功'];
    $res->data = [];
    echo json_encode($res);
}catch(Exception $e){
    // 回滾
    $db->transactionRollback();
    $res = new StdClass();
    $res->err = (object) ['code' => 1, 'msg' => $e->getMessage()];
    $res->data = [];
    echo json_encode($res);
}