Find Jobs
Hire Freelancers

[QuickProject]: Fix laravel +AdminLTE bootstrap mysql sintax errors and send results to view

$10-30 USD

Completed
Posted almost 5 years ago

$10-30 USD

Paid on delivery
Hi, i have a laravel 5.8 + AdminLTE bootstrap project. I have managed to read values from dropdowns and a date picker to build a query. I only need 4 things from you: - This query results have to be inserted into a temporary table (without using raw sql) and displayed in a new view. - Below is the code i have so far so you can have a better idea of what to do. It's giving me errors and i keep testing without luck so you only have to review it and fix the errors. - The date picker isn't working and you have to fix the current bootstrap plugin that i'm using or choose any other that you want, as long as you still tell me how you made it work. (please if you are reading this contact me with codeword: lucino) - Give me a few minutes so you can answer my question about the changes you made to the controller and views. If you can do this, I'll give you access to my server so you can work in there. //This is the code: public function TrendSelector2(Request $request) { //catching all dropdown values $subSectorSelect = $request->input('subSectorSelect'); $ColumnType = $request->input('ColumnType'); //you have to catch $selectedrisklevel as well $selectedrisklevel = $request->input('riskSelect'); //And to catch the value from the date picker //translating columntype value to trend in order to use it for the query later if ($ColumnType == "Arriba") { $ColumnType = 'X'; } elseif ($ColumnType == "Abajo") { $ColumnType = '0'; } else { echo "Selecciona la tendencia deseada"; } //This is the query $Completequerytry1 = DB::table('Companies') ->join('Sectors', '[login to view URL]', '=', '[login to view URL]') ->join('Company_PriceRS', '[login to view URL]', '=', '[login to view URL]') ->join('SubSectorsBPIsData', '[login to view URL]', '=', '[login to view URL]') ->select('[login to view URL]', '[login to view URL]', '[login to view URL]', '[login to view URL]', '[login to view URL]','[login to view URL]') ->where('[login to view URL]', '=', 'strong') ->where('[login to view URL]', '=', $ColumnType) ->where('[login to view URL]', '=', '2017-05-08') //catch the value from the date picker in order to select a day ->limit(10) ->get()->toArray(); //Now i need to create a temporary table where to insert the results from the query Schema::create('temp_trades', function ($table) { $table->string('SectorName', 150); $table->string('Symbol', 30); $table->string('strenght', 30); $table->bigInteger('parentid'); //check lenght $table->string('Risklevel', 50); $table->string('ColumnType', 1); $table->timestamps(); $table->temporary(); // temp table }); //trying to insert into the temporary table $to_fill = []; foreach($Completequerytry1 as $record) { $to_fill[] = (array)$record; } DB::table('temp_trades')->insert($to_fill); $tempdatatable = DB::table('temp_trades')->get(); Schema::drop('temp_message'); //dropping the temp table return view('besttradesresultstable', array('$tempdatatable' => $tempdatatable)); //returning the view with a new table } } Thanks in advance.
Project ID: 20107431

About the project

19 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
HI sir i am interested to fix your datepicker issue with mysql once contact me i will start your project immediately once we will discuss about project if you are not satisfied with my skills once visit in my profile where you can see my clients feedback for my work thanks.
$15 USD in 1 day
5.0 (203 reviews)
6.6
6.6
19 freelancers are bidding on average $34 USD for this job
User Avatar
Dear employer. I have read your project description. Surely I can help you. As you can see from my profile, I have a wealth of experience of Laravel. I will do my best to satisfy you, I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. Thank you for this opportunity.
$40 USD in 1 day
4.7 (84 reviews)
6.9
6.9
User Avatar
lucino Hello As I can see from job posting, you are in need of a Laravel expert who can help you with your Laravel developer project. Well, I am highly interested in applying for this. I have been working on Laravel projects for 4 years now. Thanks & Regards shweta
$30 USD in 2 days
4.8 (124 reviews)
5.7
5.7
User Avatar
Hello! I am very interested in your post project. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can achieve the results that you are asking for. I would love to work on your project. I can complete your project on time and within your budget.” looking forward to working with you. if i have a chance to work with you, it will be my pleasure. best regards
$20 USD in 7 days
4.7 (47 reviews)
5.9
5.9
User Avatar
How do you do? I am a creditist. I'm very happy to have a chance of bidding your project. I have read carefully the descriptions and understood clearly what you want. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. Now I'm waiting your answer with mind that I desire you to select me. best regards
$20 USD in 1 day
4.8 (30 reviews)
5.4
5.4
User Avatar
Hi, High talented Mathematician, Mobile and Web expert is here! I have read your proposal very carefully and I have come to learn that this job is very suitable for me. I have 10+ years of experience for Mobile App Development, Xamarin, Kotlin, Android Java, Swift, ionic, react native, web-based app skills. I am also a professional React, Angular, NodeJs, WordPress, ASP, Django, Flask, Wordpress, PHP(Codeigniter, Laravel developer. I have developed several dozens of websites and mobile apps such as Dating, OCR, WhatsApp, Uber app, e-commerce, banking, UNESCO census. I understood what you want and want to like to discuss in more detail for your project. I sincerely hope to work with you. If you hire me and give me a chance to prove my abilities, I will give you the best results with my professional skills and will do my best to finish the project successfully. I am sure I can help you. Please see my profile. I will send my previous dating app. I am looking forward to your soon reply. Best regards.
$25 USD in 1 day
5.0 (10 reviews)
5.2
5.2
User Avatar
Hello Sir! Greetings! I have 5 years of experience as a PHP full stack developer. Please open chat for further discussion. Regards, ANIL
$25 USD in 10 days
4.9 (5 reviews)
4.6
4.6
User Avatar
Dear client, how have you been? I've read your project description carefully. Presenting this proposal with 100% confident. How about discuss in chat? Waiting for your reply. Best regards.
$25 USD in 7 days
4.6 (26 reviews)
4.8
4.8
User Avatar
I have the ability to create back-end code that will add utility to everything the front-end designer creates. I'm passionate about the impact of my skills I have in the real world, and firmly believe that I can create innovative solutions to business processes and problems which will ultimately lead to a better user experience. With my previous experience in using an array of programming languages and my expertise at delivering high quality and user rich solutions on time, I see myself as a good fit for your role. I possess a proven and verifiable track record in building and managing mass-market ecommerce sites. In short, I can bring to your company my ability to take finished front-end code and gives it working functionality. I possess an in-depth understanding of both front end and back end technologies, and am very good at defining what success looks like. Furthermore I am proficient in Microsoft and Web Technologies such as PHP, C#, ASP.Net, SQL Server, Visual Studio, HTML and CSS. Kindly reply me if you are interested in my services. Thank you
$20 USD in 7 days
4.5 (7 reviews)
4.3
4.3
User Avatar
hello you job posting caught my eyes and i got interested in your project. i have already experience about it. i am managing Larvel project. please contact me if you would like to schedule an interview or have a question about my skill. regards...
$30 USD in 7 days
5.0 (13 reviews)
4.1
4.1
User Avatar
lucino Greetings I am a web developer and have experience in the same from the last 5 years. I have developed many websites and clients have given good reviews about them. I have experience in PHP, Laravel and have read the project description and have understood the requirements. I can do the 4 things that you want and can do with ease. I have understood the code. Looking forward to hearing from you Best Regards Divdeep Singh
$25 USD in 3 days
5.0 (22 reviews)
4.0
4.0
User Avatar
Dear sir. MVC framework expert here. I am a professional Laravel developer with over 5 years of experience in web development. I have rich experience with CodeIgniter,wordpress,Laravel and Angular.js,React.js,Vue.js and PHP, HTML5, CSS, MySQL , MongoDB ,Oracle ,SVN and Git and etc. I eager to provide excellent results for my clients and I have never had any kind of incidents with the clients. Also My primary goal is to make my clients 100% happy. I can start working right now and I can work fulltime for you!!! I believe that if we cooperate with each other, we will have a good result. Please contact with me so that we can discuss more. Thanks…
$20 USD in 3 days
4.6 (14 reviews)
3.7
3.7

About the client

Flag of SPAIN
San Salvador, Spain
5.0
10
Payment method verified
Member since Jun 15, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.