Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Issue with Custom Intermediate Table Models

I migth be overcomplicating things, but this is the eloquent relationships I'm trying to do: I need to develop a booking app, in which a person can book one or more rooms and each booked room can have one or more services. So I decided to make a many-to-many relationship between Booking and Room models, (so far this is working as expected). Also in order to link the services to

_castle21's avatar
_castle21's avatar shez1983Laravel
1

Multiplication between 2 tables to bring up new field

I have 2 table, for room booking logic. Calendar id room_type_id date rate 1,1,2017-12-20,20.00 1,1,2017-12-21,20.00 1,1,2017-12-22,20.00 1,1,2017-12-23,20.00 1,2,2017-12-20,10.00 1,2,2017-12-21,10.00 1,2,2017-12-22,10.00 1,2,2017-12-23,10.00 Calculation id room_type_id adult child multiply 1,1,2,0,2 - Room id : 1 - 2 adult 0 child 1,1,2,1,2.5 - Room id : 1 - 2 adult 1 child 1

mrtydn's avatar
mrtydn's avatar mrtydnLaravel
0

How do i pass form data after redirecting to view

So im making a booking system website (a simple one) using laravel 5.5. Here's how it goes. A user access a profile with a form booking inside the profile -> user submitting booking enquiry -> user will get notified by emails with all the booking form data submitted previously I have successfully achieved in passing all the data to the email but i have trouble passing all

Yomamen's avatar
Yomamen's avatar bobbybouwm...Laravel
1

How to send mail from a custom form ?

Hey guys, i'm currently trying to do a personal project where people can book a talent by filling in form and the form data will pass on to email's content and send it to the talent's email. How do i pass the data to the email ? This is what i currently have (i've already setup Mailtrap) bookingEnquiryMail Controller public function bookingEnquiryMail(Request $request, User $us

Yomamen's avatar
Yomamen's avatar tisuchiLaravel
6

Problems with search Form

Hello Community, I created a really nice Application with the help of Laravel, but there are a few things that I couldn't solve. I hope you can help me. Here is a simplificated Screenshot of my DB-Schema: https://imgur.com/ItUeDgN The relations are following: Customer: public function inquiries() { return $this->hasMany(Inquiry::class); } Inquiry: public function bookin

mathishuettl's avatar
mathishuettl's avatar tisuchiEloquent
3

Data Modelling and Business Rules

Hi guys, I have a question, which for some of the more experienced guys out there, might seem a bit mundane but - I'm a third-year software engineering student and would certainly love to hear your thoughts on the matter. We do a ton of data modelling, have done since way back in first year, and it's obviously pivotal to get right when designing applications - especially in MVC

cjconnor24's avatar
cjconnor24's avatar cjconnor24General
7

Steps to display data from an external database

Hello there! I'm just another Laravel beginner who is looking for a suitable CMS/Framework for his workprojects. I'm trying to wrap my head around the MVC workflow, but I'm currently struggling. I've been following Laravel tutorials from Lynda, especially the one with building a hotel room booking system, if anyone is familiar with that one. However, that tutorial focuses on a

Matrix166's avatar
Matrix166's avatar MorganRows...Laravel
1

Roles vs. Multi-auth in Laravel 5.5

Hello, I am writing an appointment booking application in Laravel 5.5. I have two kinds of users: Patients and Practitioners that will each be assigned to an Appointment (one Practitioner and one Patient per Appointment). I want to have one login form for both patients and practitioners, with a hidden URL /admin that redirects to the admin login page (I'm looking at Voyager for

aicxe's avatar
aicxe's avatar aicxeLaravel
2

V-model with transnational data

I have a system where a customer can make a reservation for a trip. On that reservation they can choose a package. Below is an example of my tables for these two objects. Reservations Table id | customer_id | price | no_of_people | package_id | package_name | package_price 1 | 550 | 15000 | 2 | 1 | Lodging |

kreierson's avatar
kreierson's avatar kreiersonVue
1

Where clause on two relationships

Hello, I got a Database like this: Customers: id, name Inquiries: id customer_id Bookings: id inquiry_id Now i want to search all customers who made a booking, but i don't know how... can you help me?

mathishuettl's avatar
mathishuettl's avatar mathishuet...Eloquent
8

PHPmyAdmin problem

Hi, I have created a project and its hosted on localhost on my machine. I have three pages Booking, Admin and Ebook that all have connections to the DB. These were working fine, as in the links opened the blades as expected. I havent been near the project in a couple of weeks and now when I click on any of the links it brings me to the PhpMYAdmin dashboard and I cant find or un

PolMac's avatar
PolMac's avatar jlrdwLaravel
1

How do I generate an ID with minimum length of 6?

e.g 1 = 000001 10 = 000010 100 = 000100 1000 = 001000 is it advisable to do this when storing to db as booking id?

jericopulvera's avatar
jericopulvera's avatar martinbeanLaravel
5

Method addEagerConstraints does not exist.

I have a Booking model that has some attributes linked to it. I do an eager load for the attributes property in my BookingsController: Eager load in BookingsController class BookingsController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Database\Eloquent\Collection */ public function index() { //

stylianospanagakos's avatar
stylianospanagakos's avatar stylianosp...Laravel
0

Custom Validation Rule does not work on every 2nd attempt

Validator::extend('available', function ($attribute, $value, $parameters, $validator) { $property = Property::find(request('id')); if ( ! $property) { return true; } foreach ($property->blockedDates()->get() as $booking) { if ( Carbon::parse(request()->dates['from']) &

jericopulvera's avatar
jericopulvera's avatar Dry7Laravel
1

Updating multiple tables

Hi, I have created, with help from on here I have created a DB that is populating from a form on the website. The tables I have are; Customers Products Orders The customers table is populating as I want and is working fine. I have a product table with 4 products and each one has its own ProdID. What I would like to do is to populate the orders table with a custID and product na

PolMac's avatar
PolMac's avatar aricciLaravel
5

Passing Data to DB

I have a Customers Table in the DB and I have a form to pass the data but I am getting an error message when I try to save from the form (2/2) QueryException SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value (SQL: insert into `customers` (`updated_at`, `created_at`) values (2017-08-15 21:05:01, 2017-08-15 21:05:01)) in Connection.php (line 647) at

PolMac's avatar
PolMac's avatar CronixLaravel
4

HI guys I need help solving these problem of mine regarding dates

I wonder if any of you encounter these problem. // I have this array of date range for saturday to saturday only booking $satsatDates = array:2 [▼ 0 => array:3 [▼ "from" => "2017-07-01" "to" => "2017-09-02" "satsat" => true ] 1 => array:3 [▼ "from" => "2018-06-30"

jericopulvera's avatar
jericopulvera's avatar topvillasLaravel
1

Passing DB to Blade template

Hi guys, I am working on an application and as part of that app, when the user logins in (admin), it brings you to a admin page that will display the DB. When I pass in the credentials, the route works as the url changes to the correct blade but I get a "undefined variable" error and that variable is a table in the DB (customer), any ideas? Im pretty sure the code is

PolMac's avatar
PolMac's avatar PolMacLaravel
8

Mongo groupby is not working with same date different time in laravel raw method

Below code is to fetch data from mongodb and plot sum of amounts and dates in graph with in daterange (sum(prepayment_amount) and sum(total_prepayment_amount) group by checkin_from date). Sum of amounts is in y axis and date is in x axis. From this code I am getting the sum of amounts and date but the problem is, see date and time 2017-10-05T19:07:17Z & 2017-10-05T00:00:00Z

sarathiscookie's avatar
sarathiscookie's avatar raushLaravel
1

How to write mongo group by and sum aggregate functions in laravel eloquent raw method?

I wrote some code to fetch data within date range using laravel eloquent raw method. But I don't know how to write mongodb groupby and sum in laravel eloquent raw method. Please help me to take sum(prepayment_amount) and sum(total_prepayment_amount) group by checkin_from date. The expecting result is given below. Thanks DashbardController.php $cabinName = $request-

sarathiscookie's avatar
sarathiscookie's avatar jamesramsd...Laravel
1

Vue Component doesn't render on certain Google Chrome browsers (i.e. Chrome 60)

I have developed a booking engine for a Client of mine and it works as intended on my Windows laptop using Google Chrome, my iMac and MacBook using Google Chrome, on mobile devices using the Chrome browser, but for some reason it does not render when I use it on my Chromebook. Please visit the booking engine at http://hotel.petopia.sg/book and let me know what you think the roo

ashwinmram's avatar
ashwinmram's avatar ashwinmramVue
11

rollback database record

Hi Laracasters , I want to know if there an ability , to rollback last database record when another insertion query isnot done . I am building payment module for booking room. my logic as follows : 1- update payment table for this user if ( 1 success ) 2- update room record as reserved if ( 2 success ) 3- get credit from user with third part (Auth.NET) if ( 3 success ) return &

Martha's avatar
Martha's avatar topvillasEloquent
1

I wanna hear your thoughts regarding Test Driven Development

Hello everyone! I'm interested in Test Driven Development and I wanna know what are you thoughts about this. These are my questions: When should I TDD and when should I not? Is TDD life changing for you? I'm currently building a booking website and I have 2 months to finish it will TDD help me work faster? Thank You!!!

jericopulvera's avatar
jericopulvera's avatar CronixGeneral
1

Best place for handling

Hi all, In my current L5.3 application, I need to set a booking fee based on the value of the price field. If the price is > 3500 then the booking fee will be 550, otherwise 330. An admin can change the booking fee manually, normal users don't have access to edit the booking fee field. An admin can set the booking fee manually, and a user can still edit the booking afterwar

yohannca's avatar
yohannca's avatar yohanncaGeneral
1

design question - book halls per hour/date

Hi All, I am doing a project in which a user can add his own halls and manage booking for general users. so you have owner and normal user in which he become owner if he adds his own hall. i am stuck how can i implement a process of managing a schedule .. i mean how user provision free/busy, approve requests .. set prices per hour. etc.. Also how user can see available dates..

Alzaabi98's avatar
Alzaabi98's avatar Alzaabi98General
4

help with fullcalendar

Hi all, I'm trying to use fullcalendar js in my app and I have some problems, maybe somebody can help me. I installed the maddhatter/laravel-fullcalendar package, I followed the github page and I configured the providers and the aliases and I can successfully render in my dashboard a div with the calendar. Now the problem started, I have to add the events into the calendar. Ass

vinschi's avatar
vinschi's avatar vinschiGeneral
0

How to take matching data for searching using laravel and mongo?

I have two collections bookings and users. In bookings collection I have a field *user. It is related to users._id. I have a booking listing page. In this listing page data from bookings and users are showing. I have a text box to search invoice_number, payment_type, txid and usrEmail. I have written query to search invoice_number, payment_type, txid and it is working but I am

sarathiscookie's avatar
sarathiscookie's avatar bipinLaravel
1

Many to Many Pivot table column names

Hopefully a fairly simple issue and I'm just missing the bleeding obvious. I have 2 models Clients and Bookings that are Many to Many related via the client_booking pivot table. My Clients model relationship to bookings is set up as follows: public function bookings() { return $this->belongsToMany('Modules\Courses\Entities\Booking', 'courses__booking_client');

Blackpig's avatar
Blackpig's avatar BlackpigEloquent
1

How to load huge data in html table using laravel and data table

I have a bookings data. At-present it has 10000 rows. How can list data using laravel and datatable with out taking too much loading time. At-present I had tried to list booking but initial loading took 20seconds. Currently fetching all data from database using ajax request. Please check my code and correct me. I am referring "https://github.com/yajra/laravel-datatables&qu

sarathiscookie's avatar
sarathiscookie's avatar phpMickLaravel
8

Select Multiple Input

Hi guys, I need a small help. I have a booking form where I can choose more than one accessory. My input is defined in this way: <div class="col-md-12"> <div class="form-group"> <label class="control-label" for="accessories">Choose your Accessories</label> <select name="accessory_id"

vinschi's avatar
vinschi's avatar CronixTips
5

Problem with migrations and relationship

Hi all, I have this problem: in my app I have a booking model with these relationships: public function user() { return $this->belongsTo(User::class); } public function vespa() { return $this->hasOne(Vespa::class); } public function accessories() { return $this->hasMany(Accessory::class); } In Vespa model I have: public function booking() { return $this

vinschi's avatar
vinschi's avatar tykusGeneral
11

[Database] - Need a suggestion for an SQL query

I am working on Bus Seat Booking System. This is the table where I am storing the reserved seats data. SELECT `id`, `SeatNumber`, `UserID`, `PlateNumber` FROM `seating` //id is Primary Key //UserID foreign key //PlateNumber foreign key I want an SQL Query that picks up results such that User cannot see his own reserved seats User cannot see other passenger seats User cannot s

Haider's avatar
Haider's avatar HaiderEloquent
4

count data in table

table booking id 1 2 3 4 staff_id 4 4 5 5 first i select all data from staff table then every staff against data get from booking table and count all bookings but not give me correct record count....count record is only 2 and realy record in table is 4 you see it in above table plzzz any one guide me how can get correct count from this

nomanshah's avatar
nomanshah's avatar nomanshahLaravel
3

create invoice and send it as an email attachment

Hi I am using Laravel framework for my booking project. I must say I am new to Laravel. I have a html output of the invoice. I need to create a pdf and email it as attachment. I looked up on google how to do this job in the best way couldn't figure out how to do it. Should I use plugin? I would appreciate if you can point me to the right direction and explain what is the best w

Bonboni's avatar
Bonboni's avatar topvillasLaravel
1

[Problem] jQuery click event with represent wrong values from Eloquent

I'm pretty much new to jQuery and I'm still testing the water. So with that I whipped out an example of when a user clicks a button tag, a jQuery UI dialog will prompt out with two button (Ok and Cancel). Now this ui-dialog will be generated with different values from Eloquent, this value will then be stored in the 'OK' button located inside of the ui-dialog, however there's a

Zurik.Ludg's avatar
Zurik.Ludg's avatar shaktiJavaScript
5

belongsToMany with Eloquent model as pivot table

Hi, I'll give an example (not real use case, I made it simplier) to explain my problem. I have 3 tables and 3 models: User Model - Id - Name - Country Room Model - Id - Capacity - Level Booking Model - Id - User_id - Room_id - Arrival_date - Departure_date - etc For the relations : One User hasMany Booking One Room hasMany Booking One Booking belongsTo a User One Booking bel

Mushr00m's avatar
Mushr00m's avatar bunnyproEloquent
2

Using Amazon S3 or storing user uploaded files on your server

I have been looking at amazon S3 today trying to figure out the advantages/disadvantages and use cases for when it is a good choice to use it. I have a web app where many users can have many uploaded files in the following places for example: Portfolio, Review images, booking notes with attached images. A very rough estimation of 50 users could have as many as 3k images with th

ralphmorris's avatar
ralphmorris's avatar bashyServers
12

What to test in a RESTful API

Hey, I'm trying to wrap my head around TDD but struggling to understand the basic concepts. When writing tests for API, I write the tests for the endpoints (e.g. POST /booking), or I'm writing for the logic (user can book a ticket) ? Should I test every endpoint for things like 'it requires auth', 'it returns the correct fields'? Or the basic concept is to test the correct logi

pyr0hu's avatar
pyr0hu's avatar NospoonTesting
2

Elequent checking for duplications

Hi. Im trying to sync reservations from a table in the database into an events/posts table. What it needs to be able to do is create a post in the post table, then use the post id in the events table, but get the information from the reservation table. The code below works but if i run it twice it will duplicate the data. How do i do it so it looks for the reservation id from t

skoobi's avatar
skoobi's avatar skoobiEloquent
0

Get id of inserted row and use for the next query?

Im currently pushing myself to do little projects for myself that are well out of my depth but learning a heck of a lot quickly. But there are a few things i have no idea about or if its even possible... What i'm trying to do is sync a table with another (ish). What it does is to Grab all the Reservations and create a Event from those reservations in an event calendar (Wordpres

skoobi's avatar
skoobi's avatar skoobiEloquent
2

Advice on moving complex legacy WordPress app to Laravel

We have to major code bases in our company, one new one written in Laravel, which we love to work on. And our main legacy money-maker written as a set of WordPress plugins. This legacy app runs our SaaS retreat booking platform using wordpress multisite. What I'd like to do is gradually refactor our legacy WP app into using the Laravel framework. Yes it will be a massive amount

dwenaus's avatar
dwenaus's avatar jekinneyGeneral
1

Help with images not showing up on emails (Mailgun)

Hi, I need to send emails for a casting app for commercials ( booking talents) but sometimes the images don't appear on the email and become attachments instead. I tried using sendpulse and now I switched to Mailgun but the problem still occurs. I believe this only happens when sending to hosted email servers? It works fine on Gmail and testing on Mailtrap. "message"

consigliere's avatar
consigliere's avatar consiglier...General
3

Issue with Child filtering vue 2.x

Hi there, I'm currently stuck with a computed vue filter and I cannot find the issue :( Basically I have an data object filled with rows. Each row contains an title and multiple items. Each Item contains a booking_status from 1 to 4. Now I have a filter where I can set an array with the values 1 to 4. When the filter array contains 1 and 2 I only want to see the items with the

graveeel's avatar
graveeel's avatar graveeelVue
1

Testing json API post input array

I'm working on a JSON API but I have to send an input array, can't figure out how to test the post method. I want to create an order that has one or more addresses, so I use an array to store them. I tried it in post man and works fine (the name of field in postman was "addresses[0][address]") This is the code I have on the controller to validate the request. protecte

eliomartinezb's avatar
eliomartinezb's avatar eliomartin...Testing
0

How to Join Multiple Tables with Eloquent Relationships

Hello, I have Six tables in a sequence and I want to join them with Eloquent relationships. While I am trying to do this Laravel throws an exception as Laravel accepts only one intermediate table in its relationships. Is there any possibility to join more than three tables. Here is my scenario. Tables: Countries Table: id, name States Table: id, name, country_id Cities Table:

surendrasahi's avatar
surendrasahi's avatar tylernatha...Eloquent
9

Conditional array validation in Laravel 5.4

I'm writing a small app that submits booking requests for a fundraising event. The form submits an array of players, which is then validated. Each player may or may not have an email address. There is an option for each of the players to be subscribed to the organisation's mailing list. How do I go about validating the mailing-list selection (select box values: Yes, No) so that

mrockett's avatar
mrockett's avatar mrockettGeneral
8

Search multiple tables with multiple keywords from multiple inputs

Hi guys, I have two tables in db, "deals" and "deals_meta" connected between them with a foreign key. In the "deals" table i have general information about a deal like, title, description, category etc., and in the "deals_meta" i have other specific details like, location, number of bedrooms, price, booking date and so on. I have a form w

RobertChiribuc's avatar
RobertChiribuc's avatar RobertChir...Eloquent
0

Database Design for an appointment system

I am working on this small application where experts provide personal consultations to end users. For each expert, there are time slots(9AM-9PM) of 1 hour each. Slots are available for the entire week including Sunday. I am struggling to find a better way to tackle this problem of designing the database for this application. So currently i have the following tables(Relevant to

iampawan31's avatar
iampawan31's avatar extjacTips
5

Check if all dynamic radio buttons are checked before submit

i am not much sure how can i check if all my dynamic radio button that came from DB are checked before i submit my form. I am working on a Booking Project, and the clue is about food package and subpackage. Based on the package the client choose, than he will check like a radio button which dish does he want before submitting and going to booking view. If not all the product ar

user224564's avatar
user224564's avatar user224564Laravel
0

Carbon, How to format to compare datetime?

I am working on a booking app, I get a start and end (datetime) from a user and check if this period (start & end) intersect with the database columns (start & end) so I need to compare Input['start'] and Input['end'] with the database, so I used Carbon::create($inputstart)->between($start ,$end)); but it alwayes gives errores "Unexpected data" & "

VitaTamry's avatar
VitaTamry's avatar jlrdwLaravel
1