The below query is to get the candidate’s details from the table which has 50k rows. Including jobs, regions, and employment types. A candidate has basic details with employment type, jobs, regions are in another table with foreign key relation.
Table: vacancies id int unsigned Auto Increment code varchar(191) NULL start_time timestamp NULL end_time timestamp NULL business_unit_id int unsigned job_id int unsigned on_date date break int NULL shift_id int unsigned total_numbers int Table: vacancy_details id int unsigned Auto Increment vacancy_id int unsigned day_id int unsigned shift_id int unsigned rate_type enum(‘flat_rate’,’hourly_rate’) [hourly_rate] start_time timestamp NULL end_time … Read more
I have a problem with migrating my table.
i am new in laravel.Actually i want to filter some data on state and typeofsupply column. like if state=”south australia” and typeofsupply=”Inverter & Storage” then show me these rows who exist on both value.and if i filter like state=”south australia” and typeofsupply=Nul.then these rows will be display who exist state of south australia and typeofsupply should be any of list(All type of supply)
I’m trying to simplify this part of code where I call a loop DB query to a single DB query that i run a loop over the results afterwards.
I want to make data based on 2 groups. namely the month group in that year and the group id then calculated based on the existing product id of the product in
I’m using the below code to pull some results from the database with Laravel 5.
I duplicated a project with a vagrant box which installs Debian, Nginx, PhpMyAdmin, .. With the new project the Laravel’s php artisan migrate is not working anymore and I get the error:
Consider me as laravel beginner
Can anybody help me to solve this problem?
