Laravel Logo

Build Status Total Downloads Latest Stable Version License

## About Laravel Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as: - [Simple, fast routing engine](https://laravel.com/docs/routing). - [Powerful dependency injection container](https://laravel.com/docs/container). - Multiple back-ends for [session](https://laravel.com/docs/session) and [cache](https://laravel.com/docs/cache) storage. - Expressive, intuitive [database ORM](https://laravel.com/docs/eloquent). - Database agnostic [schema migrations](https://laravel.com/docs/migrations). - [Robust background job processing](https://laravel.com/docs/queues). - [Real-time event broadcasting](https://laravel.com/docs/broadcasting). Laravel is accessible, powerful, and provides tools required for large, robust applications. ## Learning Laravel Laravel has the most extensive and thorough [documentation](https://laravel.com/docs) and video tutorial library of all modern web application frameworks, making it a breeze to get started with the framework. You may also try the [Laravel Bootcamp](https://bootcamp.laravel.com), where you will be guided through building a modern Laravel application from scratch. If you don't feel like reading, [Laracasts](https://laracasts.com) can help. Laracasts contains thousands of video tutorials on a range of topics including Laravel, modern PHP, unit testing, and JavaScript. Boost your skills by digging into our comprehensive video library. ## Laravel Sponsors We would like to extend our thanks to the following sponsors for funding Laravel development. If you are interested in becoming a sponsor, please visit the [Laravel Partners program](https://partners.laravel.com). ### Premium Partners - **[Vehikl](https://vehikl.com/)** - **[Tighten Co.](https://tighten.co)** - **[WebReinvent](https://webreinvent.com/)** - **[Kirschbaum Development Group](https://kirschbaumdevelopment.com)** - **[64 Robots](https://64robots.com)** - **[Curotec](https://www.curotec.com/services/technologies/laravel/)** - **[Cyber-Duck](https://cyber-duck.co.uk)** - **[DevSquad](https://devsquad.com/hire-laravel-developers)** - **[Jump24](https://jump24.co.uk)** - **[Redberry](https://redberry.international/laravel/)** - **[Active Logic](https://activelogic.com)** - **[byte5](https://byte5.de)** - **[OP.GG](https://op.gg)** ## Contributing Thank you for considering contributing to the Laravel framework! The contribution guide can be found in the [Laravel documentation](https://laravel.com/docs/contributions). ## Code of Conduct In order to ensure that the Laravel community is welcoming to all, please review and abide by the [Code of Conduct](https://laravel.com/docs/contributions#code-of-conduct). ## Security Vulnerabilities If you discover a security vulnerability within Laravel, please send an e-mail to Taylor Otwell via [taylor@laravel.com](mailto:taylor@laravel.com). All security vulnerabilities will be promptly addressed. ## License The Laravel framework is open-sourced software licensed under the [MIT license](https://opensource.org/licenses/MIT). # pathshalaa_api ## changed column type query 03-oct-24 ALTER TABLE `stu_testseries_analysis` CHANGE `total_time` `total_time` FLOAT(10) UNSIGNED NULL DEFAULT '0.00'; ## added column device_token_id query 08-oct-24 ALTER TABLE `users` ADD `device_token_id` VARCHAR(400) NULL DEFAULT '0' AFTER `linkedin`; ## added new table firm_detail 14-oct-24 CREATE TABLE firm_detail ( id INT AUTO_INCREMENT PRIMARY KEY, firm_name VARCHAR(300) NULL, phone VARCHAR(100) NULL, email VARCHAR(200) NULL, logo VARCHAR(250) NULL, address TEXT NULL, location TEXT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); ## added this packeges 14-oct-24 composer require barryvdh/laravel-dompdf composer require dompdf/dompdf composer require mpdf/mpdf ## added column is_correct_answer in stu_testseries_analysis table 15-oct-24 ALTER TABLE `stu_testseries_analysis` ADD `is_correct_answer` INT NOT NULL DEFAULT '0' COMMENT '1==correct,0==incorrect' AFTER `subj_ans`; ## installed packages in project 18-oct-24 composer require barryvdh/laravel-dompdf composer require mpdf/mpdf composer require kreait/firebase-php ## added new table Topics 30-oct-24 CREATE TABLE topics ( id INT AUTO_INCREMENT PRIMARY KEY, -- Separate auto-incrementing ID topic_name VARCHAR(255) NOT NULL UNIQUE, -- Unique topic name description TEXT, -- Description of the topic added_by INT DEFAULT 0, -- User ID of the person who added the topic created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Creation timestamp updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP -- Update timestamp ); ## added new table TopicSubscriptions 30-oct-24 CREATE TABLE topicsubscriptions ( id INT AUTO_INCREMENT PRIMARY KEY, -- Separate auto-incrementing ID user_id INT NOT NULL, -- User ID of the subscriber topic_id INT NOT NULL, -- Topic ID of the subscribed topic subscribed BOOLEAN DEFAULT TRUE, -- Subscription status created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Creation timestamp updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Update timestamp UNIQUE (user_id, topic_id) -- Unique constraint on user_id and topic_id ); ## added new coulmn topic_id,image in notifications 30-oct-24 ALTER TABLE `notifications` ADD `topic_id` INT NOT NULL DEFAULT '0' COMMENT '0==Not topic' AFTER `id`; ALTER TABLE `notifications` ADD `image` VARCHAR(400) NULL DEFAULT NULL AFTER `message`; ## added new table dashboard_sections 09-nov-24 CREATE TABLE `dashboard_sections` ( `id` INT NOT NULL AUTO_INCREMENT, `section_name` VARCHAR(255) NOT NULL, `position` INT NOT NULL, `enable` BOOLEAN NOT NULL DEFAULT TRUE, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ); ## added new table app_top_category_by_class 11-nov-24 CREATE TABLE app_top_category_by_class ( id INT AUTO_INCREMENT PRIMARY KEY, class_id INT NOT NULL, class_name VARCHAR(255) NOT NULL, class_branch VARCHAR(255) DEFAULT 'common', top_category VARCHAR(255) NOT NULL, status TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); ## added new coulmn type in sliders 20-nov-24 ALTER TABLE `sliders` ADD `type` VARCHAR(100) NULL DEFAULT NULL COMMENT 'testseries,web' AFTER `end_date`; ## added new coulmn bundle_id,type,enrollment_id in testresult 20-nov-24 ALTER TABLE `testresult` ADD `bundle_id` INT NOT NULL DEFAULT '0' COMMENT '0=testseries,else bundle' AFTER `testseries_id`, ADD `type` VARCHAR(100) NOT NULL DEFAULT 'testseries' COMMENT 'testseries,bundle' AFTER `bundle_id`; ALTER TABLE `testresult` ADD `enrollment_id` INT NOT NULL DEFAULT '0' AFTER `user_id`; ## this fields are added previous not added in file ## added new coulmn bundle_id,type,enrollment_id in testresult 20-nov-24 ALTER TABLE users ADD COLUMN device_token_id VARCHAR(400) NULL; ## added new coulmn is_provide_scholarship in schools 20-nov-24 ALTER TABLE `schools` ADD `is_provide_scholarship` INT NOT NULL DEFAULT '1' AFTER `status`; ## added default null set 20-nov-24 ALTER TABLE `users` CHANGE `email` `email` varchar(255) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `name`, CHANGE `mobile_no` `mobile_no` varchar(255) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `email`, CHANGE `username` `username` varchar(255) COLLATE 'utf8mb4_unicode_ci' NULL AFTER `mobile_no`; ## added defcoulmn in testseries total_questions 23-nov-24 ALTER TABLE `testseries` ADD `total_questions` INT NOT NULL DEFAULT '0' COMMENT 'total questions over testseries' AFTER `total_time`; ## added dcoulmn in notifications type,link 25-nov-24 ALTER TABLE `notifications` ADD `type` VARCHAR(100) NULL DEFAULT NULL COMMENT 'testseries,web' AFTER `image`, ADD `link` VARCHAR(350) NULL DEFAULT NULL AFTER `type`; ## insert seeder data in dashboard_sections dashbaord data 25-nov-24 INSERT INTO `dashboard_sections` (`section_name`, `position`, `enable`, `created_at`, `updated_at`) VALUES ('BannerSlider', 1, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'), ('Top Category', 2, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'), ('Top Test Series', 3, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'), ('DashboardCounter', 4, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'), ('Popular Instructors', 5, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'), ('Test Series (All, trending, Featured)', 6, 1, '2024-11-09 07:09:10', '2024-11-09 07:09:10'); ## insert seeder data in app_top_category_by_class 25-nov-24 INSERT INTO `app_top_category_by_class` (`class_id`, `class_name`, `class_branch`, `top_category`, `status`, `created_at`, `updated_at`) VALUES ( 75, '6', 'common', '2364,2354,2324,82,113,1858,1857', 1, '2024-11-11 07:35:46', '2024-11-11 11:05:09'), ( 76, '7', 'common', '2365,2355,2324,82,113,1858,1857', 1, '2024-11-11 07:35:46', '2024-11-11 11:05:09'), ( 77, '8', 'common', '2366,2356,2324,82,113,1858,1857', 1, '2024-11-11 07:35:46', '2024-11-11 11:05:09'), ( 78, '9', 'common', '2367,2357,2324,82,113,1858,1857', 1, '2024-11-11 07:35:46', '2024-11-11 11:05:09'), ( 79, '10', 'common', '2368,2358,2324,82,113,1858,1857', 1, '2024-11-11 07:35:46', '2024-11-11 11:05:09'), ( 80, '11', 'arts', '384,638,645,1578,1582,1749,1856', 1, '2024-11-11 07:35:46', '2024-11-11 11:12:05'), ( 80, '11', 'science', '384,638,645,1578,1582,1749,1856', 1, '2024-11-11 07:35:46', '2024-11-11 11:12:05'), ( 80, '11', 'commerce', '384,638,645,1578,1582,1749,1856', 1, '2024-11-11 07:35:46', '2024-11-11 11:12:05'), ( 90, '12', 'arts', '1577,1518,1489,1910,1062,1749,2032', 1, '2024-11-11 07:35:46', '2024-11-11 11:11:43'), ( 90, '12', 'science', '1577,1518,1489,1910,1062,1749,2032', 1, '2024-11-11 07:35:46', '2024-11-11 11:11:43'), ( 90, '12', 'commerce', '1577,1518,1489,1910,1062,1749,2032', 1, '2024-11-11 07:35:46', '2024-11-11 11:11:43'); ## insert seeder data in topics 25-nov-24 INSERT INTO `topics` (`topic_name`, `description`, `added_by`, `created_at`, `updated_at`) VALUES ( 'Mathematics', 'Comprehensive test series covering topics from arithmetic to geometry.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Science', 'In-depth test series focusing on Physics, Chemistry, and Biology concepts.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'English Language', 'Grammar, comprehension and vocabulary test series for improving language skills.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'History', 'Test series on ancient to modern history, covering important events and figures.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Geography', 'Test series focused on physical and human geography, including maps and global issues.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Computer Science', 'Basic programming and computer concepts tailored for students.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Social Studies', 'Understanding societal structures and functions through various test exercises.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Environmental Studies', 'Study of ecosystems, pollution, and conservation through targeted tests.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'General Knowledge', 'Test series designed to enhance awareness of current events and notable facts.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56'), ( 'Critical Thinking', 'Exercises aimed at developing problem-solving skills and logical reasoning.', 1, '2024-10-30 04:56:56', '2024-10-30 04:56:56') ## insert seeder data in sliders 25-nov-24 INSERT INTO `sliders` ( `name`, `status`, `created_at`, `updated_at`, `description`, `end_date`, `type`, `link`, `start_date`) VALUES ( '489c8e506e.jpg', 1, '2024-11-08 20:24:05', '2024-11-20 06:04:13', NULL, '2025-02-05 00:00:00', 'web', 'https://achievam.com', '2024-11-08 00:00:00'), ( 'e9edc0b3b6.jpg', 1, '2024-11-08 20:24:47', '2024-11-20 06:04:50', NULL, '2025-01-29 00:00:00', 'testseries', '567', '2024-11-08 00:00:00'), ( '602cc76f46.jpg', 1, '2024-11-08 20:21:31', '2024-11-20 06:04:13', NULL, '2025-01-15 00:00:00', 'web', 'https://achievam.com', '2024-11-08 00:00:00'), ( '56a97062ad.jpg', 1, '2024-11-08 20:24:51', '2024-11-20 06:04:50', NULL, '2025-02-28 00:00:00', 'testseries', '567', '2024-11-08 00:00:00'); ## run this query after login admin this will set counting of questions 26-nov-24 https://stag.pathshalaa.in/panel/admin_update_total_questions ## Publish results for students who have not submitted results and whose schedule end date is over 5-Dec-24 */2 * * * * php /path/to/your/project/artisan schedule:run >> /dev/null 2>&1 ## added defcoulmn in firm_detail master_otp,otp_limit 6-Dec-24 ALTER TABLE `firm_detail` ADD `master_otp` INT NOT NULL AFTER `location`; ALTER TABLE `firm_detail` ADD `otp_limit` INT NOT NULL DEFAULT '0' AFTER `master_otp`; ## added new column result_publish_date,is_publish in testseries 18-Dec-24 ALTER TABLE `testseries` ADD `result_publish_date` DATETIME NULL DEFAULT NULL AFTER `sch_date_time_to`, ADD `is_publish` INT NOT NULL DEFAULT '0' AFTER `result_publish_date`;