function eme_create_payments_table($charset, $collate)
{
global $wpdb;
$db_version = get_option('eme_version');
$table_name = $wpdb->prefix . PAYMENTS_TBNAME;
if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
$sql = "CREATE TABLE " . $table_name . " (\n id int(11) NOT NULL auto_increment,\n creation_date_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', \n booking_ids text NOT NULL,\n random_id tinytext NOT NULL,\n UNIQUE KEY (id)\n ) {$charset} {$collate};";
maybe_create_table($table_name, $sql);
} else {
maybe_add_column($table_name, 'random_id', "alter table {$table_name} add random_id tinytext NOT NULL;");
if ($db_version < 80) {
$payment_ids = $wpdb->get_col("SELECT id FROM {$table_name}");
foreach ($payment_ids as $payment_id) {
$random_id = eme_payment_random_id();
$sql = $wpdb->prepare("UPDATE {$table_name} SET random_id = %s WHERE id = %d", $random_id, $payment_id);
$wpdb->query($sql);
}
}
}
}
function eme_create_payment($booking_ids)
{
global $wpdb;
$payments_table = $wpdb->prefix . PAYMENTS_TBNAME;
$bookings_table = $wpdb->prefix . BOOKINGS_TBNAME;
// some safety
if (!$booking_ids) {
return false;
}
$payment_id = false;
$payment = array();
$payment['booking_ids'] = $booking_ids;
$payment['random_id'] = eme_payment_random_id();
$payment['creation_date_gmt'] = current_time('mysql', true);
if ($wpdb->insert($payments_table, $payment)) {
$payment_id = $wpdb->insert_id;
$booking_ids_arr = explode(",", $booking_ids);
foreach ($booking_ids_arr as $booking_id) {
$where = array();
$fields = array();
$where['booking_id'] = $booking_id;
$fields['transfer_nbr_be97'] = eme_transfer_nbr_be97($payment_id);
$wpdb->update($bookings_table, $fields, $where);
}
}
#return $payment_id;
}
