/** * Booking::book() * * This functions make a booking * * @return integer bookingid * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function book() { global $request, $errorhandler, $gDatabase, $tbl_booking, $tbl_booking_detail, $tbl_booking_detail_guest; // transaction control $auto_commit = false; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); // get booking reference id $query = "SELECT date_format( sysdate( ) , '%y%m%d' ) sysdate, \n\t\t \t\t\t(count( b.pk_booking_id ) + 1 ) booking_no \n\t\t \t\t\tFROM {$tbl_booking} b \n\t\t \t\t\tWHERE date_format( b.inserted_date, '%Y%m%d' ) = date_format( sysdate( ) , '%Y%m%d' ) "; $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Booking::book()', $query); } else { $sysdate = MetabaseFetchResult($gDatabase, $result, 0, 0); $bookingno = substr(MetabaseFetchResult($gDatabase, $result, 0, 1) + 10000, 1); $hotel_code = $request->GetVar('hotel_code', 'session'); $reference_id = $hotel_code . "-" . $sysdate . "-" . $bookingno; } $name = "zvs_pk_booking_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$bookid); $strreservationuntil = ""; if ($request->GetVar('frm_reservationduration', 'post') != "") { $reservationuntil = explode(".", $request->GetVar('frm_reservationduration', 'post')); $strreservationuntil = $reservationuntil[2] . "-" . $reservationuntil[1] . "-" . $reservationuntil[0]; } $query = sprintf("INSERT INTO {$tbl_booking} \n\t\t\t\t\t\t(pk_booking_id, fk_bookingcat_id, fk_guest_id, \n\t\t\t\t\t\t start_date, end_date, inserted_date, \n\t\t\t\t\t\t fk_inserted_user_id, persons, children,\n\t\t\t\t\t\t booking_type, reservation_until, additional_info, booking_reference_id,\n\t\t\t\t\t\t children2, children3, children0) \n\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, NOW(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s )", $bookid, $request->GetVar('frm_cat', 'post'), $request->GetVar('frm_guestid', 'post'), MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $request->GetVar('frm_startdate', 'post'))), MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $request->GetVar('frm_enddate', 'post'))), $request->GetVar('uid', 'session'), $request->GetVar('frm_persons', 'post'), $request->GetVar('frm_children', 'post'), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_bookingtype', 'post')), MetabaseGetTextFieldValue($gDatabase, $strreservationuntil), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), MetabaseGetTextFieldValue($gDatabase, $reference_id), $request->GetVar('frm_children2', 'post'), $request->GetVar('frm_children3', 'post'), $request->GetVar('frm_children0', 'post')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Booking::book()', $query); } else { $name = "zvs_pk_booking_detail_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$bookdetailid); $query = sprintf("INSERT INTO {$tbl_booking_detail} \n\t\t\t\t\t\t\t (pk_booking_detail_id, fk_booking_id, fk_room_id, \n\t\t\t\t\t\t\t start_date, end_date, inserted_date, \n\t\t\t\t\t\t\t fk_inserted_user_id, persons, children, \n\t\t\t\t\t\t\t additional_info, children2, children3, children0)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, NOW(), %s, %s, %s, %s, %s, %s, %s )", $bookdetailid, $bookid, $request->GetVar('frm_room', 'post'), MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $request->GetVar('frm_startdate', 'post'))), MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $request->GetVar('frm_enddate', 'post'))), $request->GetVar('uid', 'session'), $request->GetVar('frm_persons', 'post'), $request->GetVar('frm_children', 'post'), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), $request->GetVar('frm_children2', 'post'), $request->GetVar('frm_children3', 'post'), $request->GetVar('frm_children0', 'post')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Booking::book()', $query); } else { $query = sprintf("INSERT INTO {$tbl_booking_detail_guest} \n\t\t\t\t\t\t\t\t(pk_fk_booking_detail_id, pk_fk_guest_id) \n\t\t\t\t\t\t\t\tVALUES (%s, %s) ", $bookdetailid, $request->GetVar('frm_guestid', 'post')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Booking::book()', $query); } else { $success = MetabaseCommitTransaction($gDatabase); // end transaction $auto_commit = true; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); } } } return $bookid; }
/** * 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; }
/** * Barguestcat::saveupdate() * * Save Barguestcategory as new or update existing one * * @access public * @since 2006-02-17 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_barguestcat, $errorhandler; $barguestcatid = $request->GetVar('frm_barguestcatid', 'post'); // update if ($barguestcatid !== '0') { $query = sprintf("UPDATE {$tbl_barguestcat} SET \n\t\t\t barguestcat = %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_barguestcat_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_barguestcat', 'post')), $request->GetVar('uid', 'session'), $barguestcatid); } else { // new $name = "zvs_pk_barguestcat_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$barguestcatid); $query = sprintf("INSERT INTO {$tbl_barguestcat}\n\t\t\t (pk_barguestcat_id, barguestcat, inserted_date, fk_inserted_user_id, updated_date, fk_updated_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, NOW(), %s, NOW(), %s )", $barguestcatid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_barguestcat', 'post')), $request->GetVar('uid', 'session'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Barguestcat::saveupdate()', $query); } }
/** * season::saveupdate() * * save or update a season * * @return number season id * @access public * @since 2003-12-31 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_season, $errorhandler; $seasonid = $request->GetVar('frm_seasonid', 'post'); $startdate = explode(".", $request->GetVar('frm_start', 'post')); $strstartdate = $startdate[2] . "-" . $startdate[1] . "-" . $startdate[0]; $enddate = explode(".", $request->GetVar('frm_end', 'post')); $strenddate = $enddate[2] . "-" . $enddate[1] . "-" . $enddate[0]; // update if ($seasonid !== '0') { $query = sprintf("UPDATE {$tbl_season} SET \n\t\t\t name = %s, \n\t\t\t\t\t\t\t start_date = %s,\n\t\t\t\t\t\t\t end_date = %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_season_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $strstartdate), MetabaseGetTextFieldValue($gDatabase, $strenddate), $request->GetVar('uid', 'session'), $seasonid); } else { // new $name = "zvs_pk_season_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$seasonid); $query = sprintf("INSERT INTO {$tbl_season} \n\t\t\t (pk_season_id, name, start_date, end_date, inserted_date, fk_inserted_user_id )\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, NOW(), %s )", $seasonid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $strstartdate), MetabaseGetTextFieldValue($gDatabase, $strenddate), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Season::saveupdate()', $query); } else { return $seasonid; } }
/** * Guest::quickinsert() * * insert only firstname and lastname from a new guest into the db * * @param string $firstname firstname * @param string $lastname lastname * @return array userdata * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function quickinsert($firstname, $lastname) { global $tbl_guest, $tbl_address, $tbl_guest_address, $gDatabase, $errorhandler, $request; // transaction control $auto_commit = false; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); $name = "zvs_pk_guest_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$guestid); $query = sprintf("INSERT INTO {$tbl_guest} \n\t\t\t\t\t\t(pk_guest_id, firstname, lastname, \n\t\t\t\t\t\tinserted_date, fk_inserted_user_id, fk_salutation_id, \n\t\t\t\t\t\tfk_language_id ) \n\t\t\t\t\t\tVALUES (%s, %s, %s, " . "NOW(), %s, %s, %s )", $guestid, MetabaseGetTextFieldValue($gDatabase, $firstname), MetabaseGetTextFieldValue($gDatabase, $lastname), $request->GetVar('uid', 'session'), 1, 1); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Guest::quickinsert()', $query); $success = MetabaseRollbackTransaction($gDatabase); } else { $name = "zvs_pk_address_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$addressid); $query = sprintf("INSERT INTO {$tbl_address} " . "(pk_address_id, " . "fk_country_id, inserted_date, " . "fk_inserted_user_id ) " . "VALUES (%s, %s, NOW(), %s) ", $addressid, MetabaseGetTextFieldValue($gDatabase, '--'), $request->GetVar('uid', 'session')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Guest::quickinsert()', $query); $success = MetabaseRollbackTransaction($gDatabase); } else { $query = sprintf("INSERT INTO {$tbl_guest_address} " . "(pk_fk_guest_id, pk_fk_address_id) " . "VALUES (%s, %s) ", $guestid, $addressid); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Guest::quickinsert()', $query); $success = MetabaseRollbackTransaction($gDatabase); } else { $success = MetabaseCommitTransaction($gDatabase); // end transaction $auto_commit = true; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); $guest[0] = array('guestid' => $guestid, 'firstname' => $firstname, 'lastname' => $lastname, 'city' => ' ', 'country' => ' ', 'country_name' => ' ', 'color' => 1); return $guest; } } } }
} else { echo "Selecting rows ranges is not supported.{$eol}"; } } if (isset($tests["sequences"]) && $success) { if (MetabaseSupport($database, "Sequences")) { $test = "sequences"; echo "Testing sequences... "; flush(); $pass = 1; for ($start_value = 1; $success && $pass && $start_value < 4; $start_value++) { $sequence_name = "test_sequence_{$start_value}"; MetabaseDropSequence($database, $sequence_name); if ($success = MetabaseCreateSequence($database, $sequence_name, $start_value)) { for ($sequence_value = $start_value; $sequence_value < $start_value + 4; $sequence_value++) { if (!($success = MetabaseGetSequenceNextValue($database, $sequence_name, $value))) { break; } if ($value != $sequence_value) { $pass = 0; echo "FAILED!{$eol}"; $failed++; echo "Test {$test}: the returned sequence value is {$value} and not {$sequence_value} as expected with sequence start value with {$start_value}{$eol}"; break; } } if (!$success) { $error = MetabaseError($database); } if (!MetabaseDropSequence($database, $sequence_name)) { if (!$success) {
/** * Employee::saveupdate() * * Save employee as new or update existing one * * @access public * @since 2004-10-03 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase2, $request, $tbl_employee, $errorhandler; $userid = $request->GetVar('frm_userid', 'post'); $salery = $request->GetVar('frm_salary', 'post'); if (!is_numeric($salery)) { $salery = '0.00'; } // update if ($userid !== '0') { if ($request->GetVar('response', 'post') == 'd41d8cd98f00b204e9800998ecf8427e') { $query = sprintf("UPDATE {$tbl_employee} SET \n\t\t\t\t\t\t\t fk_hotel_id = %s,\n\t\t\t lastname = %s, \n\t\t\t\t\t\t\t firstname = %s,\n\t\t\t\t\t\t\t login = %s,\n\t\t\t\t\t\t\t locked = %s,\n\t\t\t\t\t\t\t salary = %s,\n\t\t\t\t\t\t\t fk_language_id = %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_employee_id = %s ", $request->GetVar('hotelid', 'session'), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_last', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_first', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_login', 'post')), MetabaseGetBooleanFieldValue($gDatabase2, false), $salery, 1, $request->GetVar('uid', 'session'), $userid); } else { $query = sprintf("UPDATE {$tbl_employee} SET \n\t\t\t\t\t\t\t fk_hotel_id = %s,\n\t\t\t lastname = %s, \n\t\t\t\t\t\t\t firstname = %s,\n\t\t\t\t\t\t\t login = %s,\n\t\t\t\t\t\t\t password = %s,\n\t\t\t\t\t\t\t locked = %s,\n\t\t\t\t\t\t\t salary = %s,\n\t\t\t\t\t\t\t fk_language_id = %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_employee_id = %s ", $request->GetVar('hotelid', 'session'), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_last', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_first', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_login', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('response', 'post')), MetabaseGetBooleanFieldValue($gDatabase2, false), $salery, 1, $request->GetVar('uid', 'session'), $userid); } } else { // new $name = "zvs_pk_employee_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase2, $name, &$employee_id); $query = sprintf("INSERT INTO {$tbl_employee}\n\t\t\t (pk_employee_id, fk_hotel_id, lastname, firstname, login, password, locked, salary, fk_language_id, inserted_date, fk_inserted_user_id, updated_date, fk_updated_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s, NOW(), %s )", $employee_id, $request->GetVar('hotelid', 'session'), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_last', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_first', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_login', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('response', 'post')), MetabaseGetBooleanFieldValue($gDatabase2, false), $salery, 1, $request->GetVar('uid', 'session'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase2, $query); if (!$result) { $errorhandler->display('SQL', 'Employee::saveupdate()', $query); } }
/** * Guest::importZVSGuest() * * Import ZVS User * * @access public * @since 2004-12-14 * @author Christian Ehret <*****@*****.**> */ function importZVSGuest() { global $gDatabase, $tbl_bookingcat, $tbl_barguest, $tbl_zvs_bookingcat, $tbl_zvs_guest, $tbl_zvs_booking, $tbl_zvs_booking_detail, $gZVSDatabase, $tbl_user, $errorhandler, $request; $guests = array(); $query = "SELECT pk_guest_id, firstname, lastname, fk_bookingcat_id " . sprintf("FROM {$tbl_zvs_booking}, {$tbl_zvs_guest}, {$tbl_zvs_booking_detail} \n\t\t\t\t\t\t WHERE checked_in = %s \n\t\t\t\t\t\t AND checked_out = %s\n\t\t\t\t\t\t AND pk_guest_id = fk_guest_id \n\t\t\t\t\t\t AND pk_booking_id = fk_booking_id \n\t\t\t\t\t\t AND ISNULL({$tbl_zvs_booking}.deleted_date) \n\t\t\t\t\t\t ORDER BY lastname", MetabaseGetBooleanFieldValue($gZVSDatabase, true), MetabaseGetBooleanFieldValue($gZVSDatabase, false)); $zvsresult = MetabaseQuery($gZVSDatabase, $query); if (!$zvsresult) { $errorhandler->display('SQL', 'Guest::importZVSGuest()', $query); } else { for ($row = 0; ($eor = MetabaseEndOfResult($gZVSDatabase, $zvsresult)) == 0; ++$row) { $query = "SELECT pk_bookingcat_id \n\t\t\t\t FROM {$tbl_bookingcat}\n\t\t\t\t\t\t WHERE fk_zvsbookingcat_id = " . MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 3); $catresult = MetabaseQuery($gDatabase, $query); if (!$catresult) { $errorhandler->display('SQL', 'Guest::importZVSGuest()', $query); } else { $query = "SELECT pk_barguest_id \n\t\t\t\t FROM {$tbl_barguest}\n\t\t\t\t\t\t WHERE fk_zvsguest_id = " . MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 0); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Guest::importZVSGuest()', $query); } if (MetabaseNumberOfRows($gDatabase, $result) == 1) { $query = sprintf("UPDATE {$tbl_barguest} \n\t\t\t\t\t\t\t\t\t\t SET firstname = %s, \n\t\t\t\t\t\t\t\t\t\t lastname = %s,\n\t\t\t\t\t\t\t\t\t\t fk_bookingcat_id = %s,\n\t\t\t\t\t\t\t\t\t\t deleted_date = NULL,\n\t\t\t\t\t\t\t\t\t\t fk_deleted_user_id = NULL\n\t\t\t\t\t\t\t\t\t\t WHERE pk_barguest_id = %s", MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 1)), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 2)), MetabaseFetchResult($gDatabase, $catresult, 0, 0), MetabaseFetchResult($gDatabase, $result, 0, 0)); } else { $name = "zvs_pk_barguest_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$barguestid); $query = sprintf("INSERT INTO {$tbl_barguest}\n\t\t\t\t\t\t\t\t\t\t (pk_barguest_id, fk_zvsguest_id, fk_bookingcat_id, firstname, lastname, inserted_date, fk_inserted_user_id)\n\t\t\t\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, NOW(), %s)", $barguestid, MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 0), MetabaseFetchResult($gDatabase, $catresult, 0, 0), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 1)), MetabaseGetTextFieldValue($gDatabase, MetabaseFetchResult($gZVSDatabase, $zvsresult, $row, 2)), 1); } $result2 = MetabaseQuery($gDatabase, $query); if (!$result2) { $errorhandler->display('SQL', 'Guest::importZVSGuest()', $query); } } } } }
/** * 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); }
/** * Category::saveupdate() * * Save category as new or update existing * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_guestcat, $errorhandler; $catid = $request->GetVar('frm_catid', 'post'); // update if ($catid !== '0') { $query = sprintf("UPDATE {$tbl_guestcat} SET " . "guestcat = %s, " . "description = %s, " . "updated_date = NOW(), " . "fk_updated_user_id = %s " . "WHERE pk_guestcat_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_cat', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), $request->GetVar('uid', 'session'), $catid); } else { // new $name = "zvs_pk_guestcat_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$catid); $query = sprintf("INSERT INTO {$tbl_guestcat}" . "(pk_guestcat_id, guestcat, description, inserted_date, fk_inserted_user_id )" . "VALUES (%s, %s, %s, NOW(), %s)", $catid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_cat', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'GuestCategory::saveupdate()', $query); } }
/** * account::book() * * book * * @param integer $guestid guest id * @param integer $bookingid booking id * @param datetime $dateofpayment date of payment * @param text $description description * @param number $amount amount * @param integer $paycatid paycat id * @param integer $receiptid receipt it (-1 if no receipt) * @access public * @since 2004-03-10 * @author Christian Ehret <*****@*****.**> */ function book($guestid, $bookingid, $dateofpayment, $description, $amount, $paycatid, $receiptid, $on_receipt) { global $gDatabase, $tbl_account, $tbl_booking, $errorhandler, $request; $name = "zvs_pk_account_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$accountid); if (($on_receipt === true || $on_receipt == 'true') && $receiptid != -1) { $on_receipt = true; } else { $on_receipt = false; } list($day, $month, $year) = split('[.]', $dateofpayment); $dateofpayment = mktime(0, 0, 0, $month, $day, $year); if ($receiptid == -1) { $query = sprintf("INSERT INTO {$tbl_account}\n\t\t\t\t\t\t\t (pk_account_id, fk_guest_id, fk_booking_id, date_payment, description, amount,\n\t\t\t\t\t\t\t inserted_date, fk_inserted_user_id, fk_paycat_id, on_receipt)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, NOW(), %s, %s, %s )", $accountid, $guestid, $bookingid, MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $dateofpayment)), MetabaseGetTextFieldValue($gDatabase, $description), $amount, $request->GetVar('uid', 'session'), $paycatid, MetabaseGetBooleanFieldValue($gDatabase, $on_receipt)); } else { $query = sprintf("INSERT INTO {$tbl_account}\n\t\t\t\t\t\t\t (pk_account_id, fk_guest_id, fk_booking_id, date_payment, description, amount, \n\t\t\t\t\t\t\t fk_receipt_id, allocated,\n\t\t\t\t\t\t\t inserted_date, fk_inserted_user_id, fk_paycat_id, on_receipt)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s, %s, %s )", $accountid, $guestid, $bookingid, MetabaseGetTextFieldValue($gDatabase, date("Y-m-d", $dateofpayment)), MetabaseGetTextFieldValue($gDatabase, $description), $amount, $receiptid, MetabaseGetBooleanFieldValue($gDatabase, true), $request->GetVar('uid', 'session'), $paycatid, MetabaseGetBooleanFieldValue($gDatabase, $on_receipt)); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Account::book()', $query); } else { $this->setStatus($receiptid, $bookingid); /* $receiptsum = $this->getReceiptSum($receiptid); $receiptsum = $receiptsum['sum']; $query = "SELECT booking_type FROM $tbl_booking WHERE pk_booking_id = $bookingid"; $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Account::book()', $query); } else { if (MetabaseFetchResult($gDatabase, $result, 0, 0) == 'R') { if ($receiptsum <= 0 && $receiptid != -1) { $type = 'P'; } else { $type = 'B'; } $query = sprintf("UPDATE $tbl_booking SET booking_type = %s WHERE pk_booking_id = %s", MetabaseGetTextFieldValue($gDatabase, $type), $bookingid ); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Account::book()', $query); } } elseif (MetabaseFetchResult($gDatabase, $result, 0, 0) == 'B') { if ($receiptsum <= 0 && $receiptid != -1) { $query = sprintf("UPDATE $tbl_booking SET booking_type = %s WHERE pk_booking_id = %s", MetabaseGetTextFieldValue($gDatabase, 'P'), $bookingid ); print $query; $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Account::book()', $query); } } } } */ } }
/** * room::saveupdate() * * save a new room or update an existing one * * @return number room id * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_room, $errorhandler; $roomid = $request->GetVar('frm_roomid', 'post'); // update if ($roomid !== '0') { $query = sprintf("UPDATE {$tbl_room} SET " . "room = %s, " . "capacity = %s, " . "description = %s, " . "fk_roomcat_id = %s, " . "updated_date = NOW(), " . "fk_updated_user_id = %s " . "WHERE pk_room_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_persons', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_info', 'post')), $request->GetVar('frm_roomcat', 'post'), $request->GetVar('uid', 'session'), $roomid); } else { // new $name = "zvs_pk_room_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$roomid); $query = sprintf("INSERT INTO {$tbl_room}" . "(pk_room_id, room, capacity, description, " . "fk_roomcat_id, inserted_date, fk_inserted_user_id )" . "VALUES (%s, %s, %s, %s, %s, NOW(), %s )", $roomid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_persons', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_info', 'post')), $request->GetVar('frm_roomcat', 'post'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'room::saveupdate()', $query); } else { return $roomid; } }
/** * Timetracker::saveupdate() * * save a new timespan or update an existing one * * @return number timetracker id * @access public * @since 2004-10-13 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_timetracker, $errorhandler; $timetrackerid = $request->GetVar('frm_timetrackerid', 'post'); $start = $request->GetVar('frm_thestart', 'post'); $start = explode(".", $start); $start = $start[2] . "-" . $start[1] . "-" . $start[0] . " " . $request->GetVar('frm_starttime', 'post'); $end = $request->GetVar('frm_theend', 'post'); $end = explode(".", $end); $end = $end[2] . "-" . $end[1] . "-" . $end[0] . " " . $request->GetVar('frm_endtime', 'post'); // update if ($timetrackerid !== '0') { $query = sprintf("UPDATE {$tbl_timetracker} SET \n\t\t\t\t\t\t\t start_date = %s, \n\t\t\t\t\t\t\t end_date = %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_timetracker_id = %s ", MetabaseGetTextFieldValue($gDatabase, $start), MetabaseGetTextFieldValue($gDatabase, $end), $request->GetVar('frm_employee', 'post'), $timetrackerid); } else { // new $name = "zvs_pk_timetracker_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$timetrackerid); $query = sprintf("INSERT INTO {$tbl_timetracker}\n\t\t\t\t\t\t\t (pk_timetracker_id, fk_employee_id, start_date, end_date, inserted_date, fk_inserted_user_id )\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, NOW(), %s )", $timetrackerid, $request->GetVar('frm_employee', 'post'), MetabaseGetTextFieldValue($gDatabase, $start), MetabaseGetTextFieldValue($gDatabase, $end), $request->GetVar('frm_employee', 'post')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Timetracker::saveupdate()', $query); } else { return $timetrackerid; } }
/** * price::savedraft() * * save draft receipt * * @return $draftreceiptid draft receipt id * @access public * @since 2004-04-18 * @author Christian Ehret <*****@*****.**> */ function savedraft() { global $gDatabase, $tbl_draftreceipt, $tbl_draftreceipt_booking, $tbl_draftreceipt_item, $tbl_account, $errorhandler, $request; $auto_commit = false; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); $receipt = array(); $doneitems = array(); $commissionids = array(); $commissionids = $request->GetVar('frm_commissionid', 'post'); $receipt = $this->recalculate($request->GetVar('frm_bookid', 'post'), $request->GetVar('length_short_stay', 'session'), $request->GetVar('frm_guestid', 'post')); $receiptdate = explode(".", $receipt[data][receipt_date]); $strreceiptdate = $receiptdate[2] . "-" . $receiptdate[1] . "-" . $receiptdate[0]; if ($request->GetVar('frm_bookids', 'post') !== $request->undefined) { $bookids = $request->GetVar('frm_bookids', 'post'); } else { $bookids = array($request->GetVar('frm_bookid', 'post')); } for ($i = 0; $i < count($receipt[data][start_date]); $i++) { $start = explode(".", $receipt[data][start_date][$i]); $strstart[$i] = $start[2] . "-" . $start[1] . "-" . $start[0]; $end = explode(".", $receipt[data][end_date][$i]); $strend[$i] = $end[2] . "-" . $end[1] . "-" . $end[0]; } if ($receipt[data][draftreceiptid] != -1 && $receipt[data][draftreceiptid] != "") { $draftreceiptid = $receipt[data][draftreceiptid]; $query = sprintf("UPDATE {$tbl_draftreceipt} SET\n\t\t\t\t\t\t\t fk_guest_id = %s,\n\t\t\t\t\t\t\t address = %s,\n\t\t\t\t\t\t \t receipt_date = %s, \n\t\t\t\t\t\t\t sum_netto = %s, \n\t\t\t\t\t\t\t sum_brutto = %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_draftreceipt_id = %s", $receipt[data][guestid], MetabaseGetTextFieldValue($gDatabase, $receipt[data][address]), MetabaseGetTextFieldValue($gDatabase, $strreceiptdate), $receipt[data][price_netto_total], $receipt[data][price_total], $request->GetVar('uid', 'session'), $draftreceiptid); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } else { for ($i = 0; $i < count($bookids); $i++) { $query = sprintf("UPDATE {$tbl_draftreceipt_booking}\n\t\t\t\t\t\t\t\t SET start_date = %s, end_date = %s\n\t\t\t\t\t\t\t\t WHERE pk_fk_draftreceipt_id = %s AND pk_fk_booking_id = %s", MetabaseGetTextFieldValue($gDatabase, $strstart[$i]), MetabaseGetTextFieldValue($gDatabase, $strend[$i]), $draftreceiptid, $bookids[$i]); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } // get all items which are in the system $query = "SELECT pk_draftreceipt_item_id FROM {$tbl_draftreceipt_item} WHERE fk_draftreceipt_id = " . $receipt[data][draftreceiptid]; $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } else { $olditems = array(); for ($row = 0; ($eor = MetabaseEndOfResult($gDatabase, $result)) == 0; ++$row) { $olditems[$row] = MetabaseFetchResult($gDatabase, $result, $row, 0); } for ($i = 0; $i < count($receipt[items]); ++$i) { // is a new one if ($receipt[items][$i][itemid] == -1 || !in_array($receipt[items][$i][itemid], $olditems)) { $name = "zvs_pk_draftreceipt_item_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$draftreceiptitemid); $query = sprintf("INSERT INTO {$tbl_draftreceipt_item}\n\t\t\t\t\t\t\t (pk_draftreceipt_item_id, fk_draftreceipt_id, article, amount,\n\t\t\t\t\t\t\t price_netto, price_brutto, mwst, \n\t\t\t\t\t\t\t inserted_date, fk_inserted_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, %s, NOW(), %s )", $draftreceiptitemid, $draftreceiptid, MetabaseGetTextFieldValue($gDatabase, $receipt[items][$i][article]), $receipt[items][$i][number], $receipt[items][$i][netto_single], $receipt[items][$i][brutto_single], $receipt[items][$i][mwst], $request->GetVar('uid', 'session')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } else { array_push($doneitems, $receipt[items][$i][itemid]); $query = sprintf("UPDATE {$tbl_draftreceipt_item} SET\n\t\t\t\t\t\t\t\t\t article = %s, \n\t\t\t\t\t\t\t\t\t amount = %s,\n\t\t\t\t\t\t\t \t\t price_netto = %s, \n\t\t\t\t\t\t\t\t\t price_brutto = %s, \n\t\t\t\t\t\t\t\t\t mwst = %s, \n\t\t\t\t\t\t\t \t\t updated_date = NOW(), \n\t\t\t\t\t\t\t\t\t fk_updated_user_id = %s\n\t\t\t\t\t\t\t\t\t WHERE pk_draftreceipt_item_id = %s", MetabaseGetTextFieldValue($gDatabase, $receipt[items][$i][article]), $receipt[items][$i][number], $receipt[items][$i][netto_single], $receipt[items][$i][brutto_single], $receipt[items][$i][mwst], $request->GetVar('uid', 'session'), $receipt[items][$i][itemid]); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } } // set deleted items delted $deleteitems = array_values(array_diff($olditems, $doneitems)); for ($i = 0; $i < count($deleteitems); $i++) { $query = sprintf("UPDATE {$tbl_draftreceipt_item} SET\n\t\t\t\t\t\t\t\t\t\tdeleted_date = NOW(),\n\t\t\t\t\t\t\t\t\t\tfk_deleted_user_id = %s\n\t\t\t\t\t\t\t\t\t\tWHERE pk_draftreceipt_item_id = %s ", $request->GetVar('uid', 'session'), $deleteitems[$i]); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } } } } else { $name = "zvs_pk_draftreceipt_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$draftreceiptid); $query = sprintf("INSERT INTO {$tbl_draftreceipt}\n\t\t\t\t\t\t (pk_draftreceipt_id, fk_guest_id, address,\n\t\t\t\t\t\t receipt_date, sum_netto, sum_brutto, \n\t\t\t\t\t\t inserted_date, fk_inserted_user_id)\n\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, NOW(), %s )", $draftreceiptid, $receipt[data][guestid], MetabaseGetTextFieldValue($gDatabase, $receipt[data][address]), MetabaseGetTextFieldValue($gDatabase, $strreceiptdate), $receipt[data][price_netto_total], $receipt[data][price_total], $request->GetVar('uid', 'session')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } else { for ($i = 0; $i < count($bookids); $i++) { $query = sprintf("INSERT INTO {$tbl_draftreceipt_booking}\n\t\t\t\t\t\t\t\t (pk_fk_draftreceipt_id, pk_fk_booking_id, start_date, end_date)\n\t\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s)", $draftreceiptid, $bookids[$i], MetabaseGetTextFieldValue($gDatabase, $strstart[$i]), MetabaseGetTextFieldValue($gDatabase, $strend[$i])); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } $sum = $receipt[data][price_total]; for ($k = 0; $k <= count($commissionids); ++$k) { if ($commissionids[$k] != "") { $query = sprintf("SELECT amount FROM {$tbl_account}\n\t\t\t\t\t\t\t\t\t WHERE pk_account_id = %s", $commissionids[$k]); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } elseif (MetabaseNumberOfRows($gDatabase, $result) > 0) { $sum += MetabaseFetchResult($gDatabase, $result, 0, 0) * -1; } } } for ($i = 0; $i < count($receipt[items]); ++$i) { $name = "zvs_pk_draftreceipt_item_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$draftreceiptitemid); $query = sprintf("INSERT INTO {$tbl_draftreceipt_item}\n\t\t\t\t\t\t\t (pk_draftreceipt_item_id, fk_draftreceipt_id, article, amount,\n\t\t\t\t\t\t\t price_netto, price_brutto, mwst, \n\t\t\t\t\t\t\t inserted_date, fk_inserted_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, %s, NOW(), %s )", $draftreceiptitemid, $draftreceiptid, MetabaseGetTextFieldValue($gDatabase, $receipt[items][$i][article]), $receipt[items][$i][number], $receipt[items][$i][netto_single], $receipt[items][$i][brutto_single], $receipt[items][$i][mwst], $request->GetVar('uid', 'session')); $result = MetabaseQuery($gDatabase, $query); if (!$result) { $success = MetabaseRollbackTransaction($gDatabase); $errorhandler->display('SQL', 'Receipt::savedraft()', $query); } } } } $success = MetabaseCommitTransaction($gDatabase); // end transaction $auto_commit = true; $success = MetabaseAutoCommitTransactions($gDatabase, $auto_commit); return $draftreceiptid; }
/** * User::saveupdate() * * Save user as new or update existing one * * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase2, $request, $tbl_user, $errorhandler; $userid = $request->GetVar('frm_userid', 'post'); // update if ($userid !== '0') { $query = sprintf("UPDATE {$tbl_user} SET \n\t\t\t\t\t\t\t fk_hotel_id = %s,\n\t\t\t\t\t\t\t fk_group_id = %s,\n\t\t\t lastname = %s, \n\t\t\t\t\t\t\t firstname = %s,\n\t\t\t\t\t\t\t login = %s,\n\t\t\t\t\t\t\t password = %s,\n\t\t\t\t\t\t\t locked = %s,\n\t\t\t\t\t\t\t fk_language_id = %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_user_id = %s ", $request->GetVar('hotelid', 'session'), $request->GetVar('frm_group', 'post'), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_last', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_first', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_login', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('response', 'post')), MetabaseGetBooleanFieldValue($gDatabase2, false), 1, $request->GetVar('uid', 'session'), $userid); } else { // new $name = "zvs_pk_user_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase2, $name, &$userid); $query = sprintf("INSERT INTO {$tbl_user}\n\t\t\t (pk_user_id, fk_hotel_id, fk_group_id, lastname, firstname, login, password, locked, fk_language_id, inserted_date, fk_inserted_user_id, updated_date, fk_updated_user_id)\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s, NOW(), %s )", $userid, $request->GetVar('hotelid', 'session'), $request->GetVar('frm_group', 'post'), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_last', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_first', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('frm_login', 'post')), MetabaseGetTextFieldValue($gDatabase2, $request->GetVar('response', 'post')), MetabaseGetBooleanFieldValue($gDatabase2, false), 1, $request->GetVar('uid', 'session'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase2, $query); if (!$result) { $errorhandler->display('SQL', 'User::saveupdate()', $query); } }
/** * bcat::saveupdate() * * save or update a booking category * * @return number booking category id * @access public * @since 2003-07-24 * @author Christian Ehret <*****@*****.**> */ function saveupdate() { global $gDatabase, $request, $tbl_bookingcat, $errorhandler; $bcatid = $request->GetVar('frm_bcatid', 'post'); // update if ($bcatid !== '0') { $query = sprintf("UPDATE {$tbl_bookingcat} SET \n\t\t\t\t\t\t\t bookingcat = %s, \n\t\t\t\t\t\t\t color = %s, \n\t\t\t\t\t\t\t description = %s, \n\t\t\t\t\t\t\t days = %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_bookingcat_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_color', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), $request->GetVar('frm_days', 'post'), $request->GetVar('uid', 'session'), $bcatid); } else { // new $name = "zvs_pk_bookingcat_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$bcatid); $query = sprintf("INSERT INTO {$tbl_bookingcat}\n\t\t\t\t\t\t\t (pk_bookingcat_id, bookingcat, color, description, days, inserted_date, fk_inserted_user_id )\n\t\t\t\t\t\t\t VALUES (%s, %s, %s, %s, %s, NOW(), %s )", $bcatid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_color', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_description', 'post')), $request->GetVar('frm_days', 'post'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'BookingCategory::saveupdate()', $query); } else { return $bcatid; } }
function DumpSequence($sequence_name, $output, $eol, $dump_definition) { $sequence_definition = $this->database_definition["SEQUENCES"][$sequence_name]; if ($dump_definition) { $start = $sequence_definition["start"]; } else { if (MetabaseSupport($this->database, "GetSequenceCurrentValue")) { if (!MetabaseGetSequenceCurrentValue($this->database, $sequence_name, $start)) { return 0; } $start++; } else { if (!MetabaseGetSequenceNextValue($this->database, $sequence_name, $start)) { return 0; } $this->warnings[] = "database does not support getting current sequence value, the sequence value was incremented"; } } $output("{$eol} <sequence>{$eol} <name>{$sequence_name}</name>{$eol} <start>{$start}</start>{$eol}"); if (isset($sequence_definition["on"])) { $output(" <on>{$eol} <table>" . $sequence_definition["on"]["table"] . "</table>{$eol} <field>" . $sequence_definition["on"]["field"] . "</field>{$eol} </on>{$eol}"); } $output(" </sequence>{$eol}"); return 1; }
/** * article::saveupdate() * * save or update an article * * @param number $articleid article id * @return number article id * @access public * @since 2004-03-07 * @author Christian Ehret <*****@*****.**> */ function saveupdate($articleid) { global $gDatabase, $request, $tbl_article, $errorhandler; // update if ($articleid !== '0') { $query = sprintf("UPDATE {$tbl_article} SET \n\t\t\t\t\t\t\t article = %s, \n\t\t\t\t\t\t\t price_netto = %s, \n\t\t\t\t\t\t\t price_brutto = %s,\n\t\t\t\t\t\t\t mwst = %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_article_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), round($request->GetVar('frm_brutto', 'post') * 100 / (100 + $request->GetVar('frm_mwst', 'post')), 2), $request->GetVar('frm_brutto', 'post'), $request->GetVar('frm_mwst', 'post'), $request->GetVar('uid', 'session'), $articleid); } else { // new $name = "zvs_pk_article_id"; $sequence = MetabaseGetSequenceNextValue($gDatabase, $name, &$articleid); $query = sprintf("INSERT INTO {$tbl_article}\n\t\t\t\t\t\t\t(pk_article_id, article, price_netto, price_brutto, mwst, inserted_date, fk_inserted_user_id )\n\t\t\t\t\t\t\tVALUES (%s, %s, %s, %s, %s, NOW(), %s )", $articleid, MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_name', 'post')), round($request->GetVar('frm_brutto', 'post') * 100 / (100 + $request->GetVar('frm_mwst', 'post')), 2), $request->GetVar('frm_brutto', 'post'), $request->GetVar('frm_mwst', 'post'), $request->GetVar('uid', 'session')); } $result = MetabaseQuery($gDatabase, $query); if (!$result) { $errorhandler->display('SQL', 'Article::saveupdate()', $query); } else { return $articlid; } }