/**
* 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;
}
}
