/**
  * Article::saveupdatePeriod
  * 
  * Save period as new or update existing one
  * 
  * @access public 
  * @since 2004-12-13
  * @author Christian Ehret <*****@*****.**> 
  */
 function saveupdatePeriod()
 {
     global $gDatabase, $request, $tbl_period, $tbl_bararticle, $errorhandler;
     $periodid = $request->GetVar('frm_theperiodid', 'post');
     $active = false;
     $auto_commit = false;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     if ($request->GetVar('frm_periodact', 'post') == 'true') {
         $active = true;
         $query = sprintf("UPDATE {$tbl_period} SET \n\t\t\t\t\t\t\t active = %s,\n\t\t\t\t\t\t\t updated_date = NOW(), \n\t\t\t\t\t\t\t fk_updated_user_id = %s ", MetabaseGetBooleanFieldValue($gDatabase, false), $request->GetVar('uid', 'session'));
         $result = MetabaseQuery($gDatabase, $query);
         if (!$result) {
             $success = MetabaseRollbackTransaction($gDatabase);
             $errorhandler->display('SQL', 'Article::saveupdatePeriod()', $query);
         }
     }
     // update
     if ($periodid !== '-1') {
         $query = sprintf("UPDATE {$tbl_period} SET \n\t\t\t                 period = %s, \n\t\t\t\t\t\t\t active = %s,\n\t\t\t\t\t\t\t updated_date = NOW(), \n\t\t\t\t\t\t\t fk_updated_user_id = %s \n\t\t\t\t\t\t\t WHERE pk_period_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_perioddesc', 'post')), MetabaseGetBooleanFieldValue($gDatabase, $active), $request->GetVar('uid', 'session'), $periodid);
     } else {
         // new
         $name = "zvs_pk_period_id";
         $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$periodid);
         $query = sprintf("INSERT INTO {$tbl_period}\n\t\t\t                  (pk_period_id, period, active, inserted_date, fk_inserted_user_id, updated_date, fk_updated_user_id)\n\t\t\t\t\t\t\t  VALUES (%s, %s, %s, NOW(), %s, NULL, NULL )", $periodid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_perioddesc', 'post')), MetabaseGetBooleanFieldValue($gDatabase, $active), $request->GetVar('uid', 'session'));
     }
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Article::saveupdatePeriod()', $query);
     } else {
         if ($request->GetVar('frm_cpyperiod', 'post') != -1) {
             $query = "SELECT fk_bararticlecat_id, description, price, hotkey\n\t\t\t\t\t  FROM {$tbl_bararticle} \n\t\t\t\t\t  WHERE ISNULL(deleted_date) AND\n\t\t\t\t\t  fk_period_id = " . $request->GetVar('frm_cpyperiod', 'post');
             $result = MetabaseQuery($gDatabase, $query);
             if (!$result) {
                 $success = MetabaseRollbackTransaction($gDatabase);
                 $errorhandler->display('SQL', 'Article::saveupdatePeriod()', $query);
             }
             for ($row = 0; ($eor = MetabaseEndOfResult($gDatabase, $result)) == 0; ++$row) {
                 $name = "zvs_pk_bararticle_id";
                 $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$bararticleid);
                 $query = sprintf("INSERT INTO {$tbl_bararticle} \n\t\t\t\t\t         (pk_bararticle_id, fk_period_id, fk_bararticlecat_id,\n\t\t\t\t\t\t\t description, price, hotkey, inserted_date, \n\t\t\t\t\t\t\t fk_inserted_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, NOW(), %s) ", $bararticleid, $periodid, MetabaseFetchResult($gDatabase, $result, $row, 0), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gDatabase, $result, $row, 1)), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gDatabase, $result, $row, 2)), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gDatabase, $result, $row, 3)), $request->GetVar('uid', 'session'));
                 $result2 = MetabaseQuery($gDatabase, $query);
                 if (!$result2) {
                     $success = MetabaseRollbackTransaction($gDatabase);
                     $errorhandler->display('SQL', 'Article::saveupdatePeriod()', $query);
                 }
             }
         }
         $success = MetabaseCommitTransaction($gDatabase);
         // end transaction
         $auto_commit = true;
         $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     }
     return $periodid;
 }
 /**
  * Guest::shareaddress()
  * 
  * share address
  * 
  * @param string $shareid address id and type of source
  * @param number $guestid address id
  * @param string $type type of aim
  * @access public 
  * @since 2005-08-20
  * @author Christian Ehret <*****@*****.**> 
  */
 function shareaddress($shareid, $guestid, $type)
 {
     global $gDatabase, $tbl_guest_address, $tbl_address, $errorhandler;
     $sharetype = substr($shareid, 0, 1);
     $shareid = substr($shareid, 2);
     $type = ucfirst(substr($type, 0, 1));
     $auto_commit = false;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     $query = sprintf("SELECT pk_fk_address_id FROM {$tbl_guest_address}\n\t\t                  WHERE pk_fk_guest_id = %s\n\t\t\t\t\t\t  AND address_type = %s ", $guestid, MetabaseGetTextFieldValue($gDatabase, $type));
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Guest::shareaddress()', $query);
     }
     $oldaddressid = MetabaseFetchResult($gDatabase, $result, 0, 0);
     $query = sprintf("SELECT pk_fk_address_id FROM {$tbl_guest_address}\n\t\t                  WHERE pk_fk_guest_id = %s\n\t\t\t\t\t\t  AND address_type = %s ", $shareid, MetabaseGetTextFieldValue($gDatabase, $sharetype));
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Guest::shareaddress()', $query);
     }
     $newaddressid = MetabaseFetchResult($gDatabase, $result, 0, 0);
     if ($oldaddressid) {
         $query = sprintf("UPDATE {$tbl_guest_address} ga \n\t\t                  SET pk_fk_address_id = %s \n\t\t\t\t\t\t  WHERE pk_fk_guest_id = %s \n\t\t\t\t\t\t  AND address_type = %s", $newaddressid, $guestid, MetabaseGetTextFieldValue($gDatabase, $type));
     } else {
         $query = sprintf("INSERT INTO {$tbl_guest_address} \n\t\t\t\t\t\t  (pk_fk_guest_id, pk_fk_address_id, address_type) \n\t\t\t\t\t\t  VALUES (%s, %s, %s)", $guestid, $newaddressid, MetabaseGetTextFieldValue($gDatabase, $type));
     }
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Guest::shareaddress()', $query);
     }
     if ($oldaddressid) {
         // check if address is used more than this time
         $query = "SELECT count( * ) FROM {$tbl_guest_address} \n\t\t\t          WHERE pk_fk_address_id = {$oldaddressid}";
         $result = MetabaseQuery($gDatabase, $query);
         if (!$result) {
             $success = MetabaseRollbackTransaction($gDatabase);
             $errorhandler->display('SQL', 'Guest::shareaddress()', $query);
         } else {
             $count = MetabaseFetchResult($gDatabase, $result, 0, 0);
         }
         if ($count == 0) {
             $query = sprintf("DELETE FROM {$tbl_address} \n\t\t\t\t\t\t  WHERE pk_address_id = %s", $oldaddressid, MetabaseGetTextFieldValue($gDatabase, $type));
             $result = MetabaseQuery($gDatabase, $query);
             if (!$result) {
                 $success = MetabaseRollbackTransaction($gDatabase);
                 $errorhandler->display('SQL', 'Guest::shareaddress()', $query);
             }
         }
     }
     $success = MetabaseCommitTransaction($gDatabase);
     // end transaction
     $auto_commit = true;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
 }
Exemple #3
0
        if (!$result) {
            $success = MetabaseRollbackTransaction($gDatabase);
            $errorhandler->display('SQL', 'database', $query);
        }
        $success = splitSqlFile($queries, $sql);
        for ($i = 0; $i < count($queries); ++$i) {
            if (substr($queries[$i], 0, 3) == "USE") {
                $query = "USE {$schema}";
            } else {
                $query = $queries[$i];
            }
            $result = MetabaseQuery($gDatabase, $query);
            if (!$result) {
                $success = MetabaseRollbackTransaction($gDatabase);
                $errorhandler->display('SQL', 'database', $query);
            }
        }
        $query = "SET FOREIGN_KEY_CHECKS = 0";
        $result = MetabaseQuery($gDatabase, $query);
        if (!$result) {
            $success = MetabaseRollbackTransaction($gDatabase);
            $errorhandler->display('SQL', 'database', $query);
        }
        $success = MetabaseCommitTransaction($gDatabase);
        // end transaction
        $auto_commit = true;
        $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
        $smarty->assign('tpl_ready', 'true');
    }
}
$smarty->display('database.tpl');
Exemple #4
0
 $data["access_date"] = MetabaseToday();
 $data["access_time"] = MetabaseTime();
 $data["approved"] = MetabaseNow();
 if (!InsertTestValues($database, $prepared_query, $data) || !MetabaseRollbackTransaction($database) || !($result = MetabaseQuery($database, "SELECT * FROM users"))) {
     $success = 0;
 } else {
     if (!MetabaseEndOfResult($database, $result)) {
         $pass = 0;
         echo "FAILED!{$eol}";
         $failed++;
         echo "Test {$test}: transaction rollback did not revert the row that was inserted{$eol}";
     }
     MetabaseFreeResult($database, $result);
 }
 if ($success && $pass) {
     if (!InsertTestValues($database, $prepared_query, $data) || !MetabaseCommitTransaction($database) || !($result = MetabaseQuery($database, "SELECT * FROM users"))) {
         $success = 0;
     } else {
         if (MetabaseEndOfResult($database, $result)) {
             $pass = 0;
             echo "FAILED!{$eol}";
             $failed++;
             echo "Test {$test}: transaction commit did not make permanent the row that was inserted{$eol}";
         }
         MetabaseFreeResult($database, $result);
     }
 }
 if ($success && $pass) {
     if (!($result = MetabaseQuery($database, "DELETE FROM users"))) {
         $success = 0;
     }
 /**
  * price::save()
  * 
  * save prices for a season
  * 
  * @access public 
  * @since 2004-01-01
  * @author Christian Ehret <*****@*****.**> 
  */
 function save()
 {
     global $gDatabase, $request, $tbl_price, $tbl_price2, $errorhandler, $rcat, $bcat;
     // turn on Transaction Control
     $auto_commit = false;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     $seasonids = array();
     $seasonids = $request->getVar('frm_seasonid', 'post');
     $bcats = $bcat->Get();
     $rcats = $rcat->get('N');
     $rcats2 = $rcat->get('A');
     for ($i = 0; $i < count($seasonids); $i++) {
         // delete all old entries for the season for price normal
         $query = sprintf("DELETE FROM {$tbl_price} WHERE fk_season_id = %s", $seasonids[$i]);
         $result = MetabaseQuery($gDatabase, $query);
         if (!$result) {
             $success = MetabaseRollbackTransaction($gDatabase);
             $errorhandler->display('SQL', 'Price::save()', $query);
         }
         // delete all old entries for the season for price advanced
         $query = sprintf("DELETE FROM {$tbl_price2} WHERE fk_season_id = %s", $seasonids[$i]);
         $result = MetabaseQuery($gDatabase, $query);
         if (!$result) {
             $success = MetabaseRollbackTransaction($gDatabase);
             $errorhandler->display('SQL', 'Price::save()', $query);
         }
         // insert new values
         for ($j = 0; $j < count($bcats); $j++) {
             for ($k = 0; $k < count($rcats); $k++) {
                 $frmperson = "frm_price_adult_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmperson_short = "frm_price_adult_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren = "frm_price_child_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren_short = "frm_price_child_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren2 = "frm_price_child2_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren2_short = "frm_price_child2_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren3 = "frm_price_child3_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmchildren3_short = "frm_price_child3_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmabsolute = "frm_price_pausch_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmabsolute_short = "frm_price_pausch_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $frmtype = "frm_type_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats[$k][catid];
                 $priceperson = 0.0;
                 $pricepersonshort = 0.0;
                 $pricechildren = 0.0;
                 $pricechildrenshort = 0.0;
                 $pricechildren2 = 0.0;
                 $pricechildren2short = 0.0;
                 $pricechildren3 = 0.0;
                 $pricechildren3short = 0.0;
                 if ($request->GetVar($frmperson, 'post') !== "") {
                     $priceperson = $request->GetVar($frmperson, 'post');
                 }
                 if ($request->GetVar($frmperson_short, 'post') !== "") {
                     $pricepersonshort = $request->GetVar($frmperson_short, 'post');
                 }
                 if ($request->GetVar($frmchildren, 'post') !== "") {
                     $pricechildren = $request->GetVar($frmchildren, 'post');
                 }
                 if ($request->GetVar($frmchildren_short, 'post') !== "") {
                     $pricechildrenshort = $request->GetVar($frmchildren_short, 'post');
                 }
                 if ($request->GetVar($frmchildren2, 'post') !== "") {
                     $pricechildren2 = $request->GetVar($frmchildren2, 'post');
                 }
                 if ($request->GetVar($frmchildren2_short, 'post') !== "") {
                     $pricechildren2short = $request->GetVar($frmchildren2_short, 'post');
                 }
                 if ($request->GetVar($frmchildren3, 'post') !== "") {
                     $pricechildren3 = $request->GetVar($frmchildren3, 'post');
                 }
                 if ($request->GetVar($frmchildren3_short, 'post') !== "") {
                     $pricechildren3short = $request->GetVar($frmchildren3_short, 'post');
                 }
                 $name = "zvs_pk_price_id";
                 $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$priceid);
                 $query = sprintf("INSERT INTO {$tbl_price}\n\t\t\t\t\t\t\t\t  (pk_price_id, fk_roomcat_id, fk_bookingcat_id,\n\t\t\t\t\t\t\t\t   fk_season_id, price_person, price_children, \n\t\t\t\t\t\t\t\t   price_type, inserted_date, fk_inserted_user_id, \n\t\t\t\t\t\t\t\t   price_person_short, price_children_short,\n\t\t\t\t\t\t\t\t   price_children2, price_children2_short, price_children3, price_children3_short) \n\t\t\t\t\t\t\t\t   VALUES\n\t\t\t\t\t\t\t\t   (%s, %s, %s, %s, %s, %s, %s, NOW(), %s, %s, %s, %s, %s, %s, %s) ", $priceid, $rcats[$k][catid], $bcats[$j][bcatid], $seasonids[$i], $priceperson, $pricechildren, MetabaseGetTextFieldValue($gDatabase, 'PP'), $request->GetVar('uid', 'session'), $pricepersonshort, $pricechildrenshort, $pricechildren2, $pricechildren2short, $pricechildren3, $pricechildren3short);
                 $result = MetabaseQuery($gDatabase, $query);
                 if (!$result) {
                     $success = MetabaseRollbackTransaction($gDatabase);
                     $errorhandler->display('SQL', 'Price::save()', $query);
                 }
             }
             for ($k = 0; $k < count($rcats2); $k++) {
                 $frmprice = "frm_price_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats2[$k][catid];
                 $frmprice_short = "frm_price_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats2[$k][catid];
                 $frmperson = "frm_person_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats2[$k][catid];
                 $frmadditional = "frm_additional_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats2[$k][catid];
                 $frmadditional_short = "frm_additional_short_" . $seasonids[$i] . "_" . $bcats[$j][bcatid] . "_" . $rcats2[$k][catid];
                 $price = 0.0;
                 $priceshort = 0.0;
                 $additional = 0.0;
                 $additionalshort = 0.0;
                 if ($request->GetVar($frmprice, 'post') !== "") {
                     $price = $request->GetVar($frmprice, 'post');
                 }
                 if ($request->GetVar($frmprice_short, 'post') !== "") {
                     $priceshort = $request->GetVar($frmprice_short, 'post');
                 }
                 if ($request->GetVar($frmadditional, 'post') !== "") {
                     $additional = $request->GetVar($frmadditional, 'post');
                 }
                 if ($request->GetVar($frmadditional_short, 'post') !== "") {
                     $additionalshort = $request->GetVar($frmadditional_short, 'post');
                 }
                 $name = "zvs_pk_price2_id";
                 $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$priceid);
                 $query = sprintf("INSERT INTO {$tbl_price2}\n\t\t\t\t\t\t\t\t  (pk_price2_id, fk_roomcat_id, fk_bookingcat_id,\n\t\t\t\t\t\t\t\t   fk_season_id, price, price_short, \n\t\t\t\t\t\t\t\t   persons_included, price_additional, price_short_additional,\n\t\t\t\t\t\t\t\t   inserted_date, fk_inserted_user_id) \n\t\t\t\t\t\t\t\t   VALUES\n\t\t\t\t\t\t\t\t   (%s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s) ", $priceid, $rcats2[$k][catid], $bcats[$j][bcatid], $seasonids[$i], $price, $priceshort, MetabaseGetTextFieldValue($gDatabase, $request->GetVar($frmperson, 'post')), $additional, $additionalshort, $request->GetVar('uid', 'session'));
                 $result = MetabaseQuery($gDatabase, $query);
                 if (!$result) {
                     $success = MetabaseRollbackTransaction($gDatabase);
                     $errorhandler->display('SQL', 'Price::save()', $query);
                 }
             }
         }
     }
     $success = MetabaseCommitTransaction($gDatabase);
     // end transaction
     $auto_commit = true;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
 }
 /**
  * price::deletedraft()
  * 
  * delete draft receipt
  * 
  * @param number $draftreceiptid draft receipt id
  * @param boolean $transc transaction control
  * @access public 
  * @since 2004-04-18
  * @author Christian Ehret <*****@*****.**> 
  */
 function deletedraft($draftreceiptid, $transc)
 {
     global $gDatabase, $tbl_draftreceipt, $tbl_draftreceipt_booking, $tbl_draftreceipt_item, $errorhandler, $request;
     if ($transc) {
         $auto_commit = false;
         $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     }
     $query = "DELETE FROM {$tbl_draftreceipt_item} WHERE fk_draftreceipt_id = " . $draftreceiptid;
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Receipt::deletedraft()', $query);
     }
     $query = "DELETE FROM {$tbl_draftreceipt_booking} WHERE pk_fk_draftreceipt_id = " . $draftreceiptid;
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Receipt::deletedraft()', $query);
     }
     $query = "DELETE FROM {$tbl_draftreceipt} WHERE pk_draftreceipt_id = " . $draftreceiptid;
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Receipt::deletedraft()', $query);
     } else {
         if ($transc) {
             $success = MetabaseCommitTransaction($gDatabase);
             // end transaction
             $auto_commit = true;
             $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
         }
     }
 }
Exemple #7
0
             if ($success && $pass) {
                 $passed++;
                 echo "OK.{$eol}";
             }
         }
     } else {
         echo "Transactions are not supported.{$eol}";
     }
 }
 if (isset($tests["nestedtransactions"]) && $success) {
     if (MetabaseSupport($database, "Transactions")) {
         $test = "transactions";
         echo "Testing nested transactions... ";
         flush();
         $pass = 1;
         if (!MetabaseAutoCommitTransactions($database, 0) || !MetabaseAutoCommitTransactions($database, 0) || !MetabaseCommitTransaction($database) || !MetabaseAutoCommitTransactions($database, 1) || !MetabaseRollbackTransaction($database) || !MetabaseAutoCommitTransactions($database, 1)) {
             $success = 0;
         }
         if ($success && $pass) {
             $passed++;
             echo "OK.{$eol}";
         }
     } else {
         echo "Transactions are not supported.{$eol}";
     }
 }
 if (MetabaseSupport($database, "PatternBuild") && isset($tests["patterns"]) && $success) {
     $test = "patterns";
     echo "Testing queries with pattern matching conditions... ";
     $values = array(1 => "%end", 2 => "begin%end", 3 => "begin%", 4 => "beginend", 5 => "_end", 6 => "begin_end", 7 => "begin_", 8 => "beginend", 9 => " _@%\\ ]['?*");
     flush();
 /**
  * Booking::deloldreservation()
  * 
  * This function marks an old reservation as deleted
  * 
  * @param number $bookingid booking id
  * @access public 
  * @since 2004-02-07
  * @author Christian Ehret <*****@*****.**> 
  */
 function deloldreservation($bookingid)
 {
     global $tbl_booking, $tbl_booking_detail, $gDatabase, $request, $errorhandler;
     // transaction control
     $auto_commit = false;
     $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
     $query = sprintf("UPDATE {$tbl_booking} \n\t\t                  SET deleted_date = NOW(), \n\t\t\t\t\t\t  fk_deleted_user_id = %s \n\t\t\t\t\t\t  WHERE pk_booking_id = %s ", 1, MetabaseGetTextFieldValue($gDatabase, $bookingid));
     $result = MetabaseQuery($gDatabase, $query);
     if (!$result) {
         $success = MetabaseRollbackTransaction($gDatabase);
         $errorhandler->display('SQL', 'Booking::deloldreservation()', $query);
     } else {
         $query = sprintf("UPDATE {$tbl_booking_detail} \n\t\t\t\t\t\t\t   SET deleted_date = NOW(), \n\t\t\t\t\t\t\t   fk_deleted_user_id = %s \n\t\t\t\t\t\t\t   WHERE fk_booking_id = %s ", 1, MetabaseGetTextFieldValue($gDatabase, $bookingid));
         $result = MetabaseQuery($gDatabase, $query);
         if (!$result) {
             $success = MetabaseRollbackTransaction($gDatabase);
             $errorhandler->display('SQL', 'Booking::deloldreservation()', $query);
         } else {
             $success = MetabaseCommitTransaction($gDatabase);
             // end transaction
             $auto_commit = true;
             $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit);
         }
     }
 }