Sedang Disiapkan

I need a larval coder

We are trying to return results in a reports to structure, where only reporting users that share a common value (from two separate data tables) are displayed.

We are using larvel. In the controller we are defining "Reporting Users" as users (from a common users table), who are active, report to another "user_id", who both share the exact same "scorecard_type_id" from ( $dbPrefix.'access_permissions' and $dbPrefix.'scored_in'). We have tried using an inner-join, but with errors. This is for a linux server, running MySQL, and PHP, under a larvel stack.

Image of Scored_in table (column ids used: "userid" and "score_card_type_id):

Image of Access_Permissions table (column ids used: "id" and "score_card_type_id"):

For the Users Table: the Id that we are referencing is "id"

There are three data tables that are used in this scenario, a common users table, a prefix database table for scored_in (this table defines the score_card_type_id users are scored in), and a prefix database table for access_permissions (this is the table that defines the score_card_type_id a user can score other users in)

Where we are currently: You can see here Teacher 1 can see Student 2, and Student 3, but they should not be able to see that student 2 and Student three, in Teacher 2 or Teacher 3 classes, because Teacher 1 does not teach Student 2 or Student 3. What we want:

We want to the user (Teacher 1) to only see Students that report to Teacher 1, and are scored_in the score_card_type_id(s) Teacher 1 has in access_permissions score_card_type_id(s)

function getAllReportingUsers($userId, &$allUsers) {

$dbPrefix = $this->getDBPrefix(null);

$user_profiles = user_profile::join('users', '[login to view URL]', '=', 'user_profile.user_id')

->where('users.is_active', '=', 1)

->where('user_profile.reports_to', '=', $userId)

// Shit!

//->select(DB::raw('distinct('.$dbPrefix.'scored_in.score_card_type_id)'))

//->where($dbPrefix.'scored_in.score_card_type_id', '=', $dbPrefix.'access_permission.score_card_type_id')

->get();

foreach ($user_profiles as $reportUserId){

$userReportTo_id = $reportUserId->user_id;

if($userReportTo_id == $userId)

{

array_push($allUsers, $userReportTo_id);

return false;

}

if($userReportTo_id>0){

array_push($allUsers, $userReportTo_id);

$this->getAllReportingUsers($userReportTo_id, $allUsers);

}else{

return false;

}

We would like the result to be the viewing user is only able to see reporting users whose "scorecard_type_id" from the "scored_in" data table = the viewing users "scorecard_type_id" from the access_permissions data table.

We also want to add a column in ScoreCardType, that will make some of the rows "global" along with a permission that allows some users to see the global scorecards with only the users that report to them.

Kemahiran: PHP, MySQL, Linux, Kejuruteraan Perisian, Java

Tentang Majikan:
( 2 ulasan ) Flower Mound, United States

ID Projek: #20822838

32 pekerja bebas membida secara purata $34/jam untuk pekerjaan ini

winmaclin

Hi, By reviewing attached 3 screen-shots & job description, we are expert PHP LARAVEL CODERS with extensive experience in MYSQL BACK-END development. So, we can definitely help you to code & resolve errors as per yo Lagi

$25 USD / jam
(983 Ulasan)
9.6
arhamsoftltd

Good Day, Hi, I have a strong command in Laravel and working as a Web developer from last 15 years and I have reviewed the whole details I am confident to fix your all issues. I want you to come to the inbox and disc Lagi

$35 USD / jam
(170 Ulasan)
9.1
dreamci

Hello there Full Stack Expert development team is ready to serve you. Please check my profile and message me for more details. Thanks

$40 USD / jam
(188 Ulasan)
8.4
linuxfreak1985

Hi, I have gone through your post and understand your requirements and can develop this website on Laravel, This Website will be responsive to all devices and I assure quality work and timely support. Some of the eye Lagi

$37 USD / jam
(1190 Ulasan)
8.7
atech0

As per the given brief, you are looking for a Laravel developer with experience in Angular.JS. I am glad to tell you that I'm the right candidate for this job as I am an organized, a dedicated professional developer wi Lagi

$37 USD / jam
(160 Ulasan)
8.3
mituld

Hello there I have more than 5 years of development experience and a great team, we can complete your project with clean code and best practices To be able to give clients what exactly they want, Please check my p Lagi

$25 USD / jam
(462 Ulasan)
8.2
eclipsetechno

Hi, I can understand the queries better if I get to know the complete DB structure. If I see the codes from the middle, without knowing the relationship, architecture and objective, I wouldn't be able to help. Looki Lagi

$25 USD / jam
(35 Ulasan)
7.7
Wangxianming

Hi As you can see from my Freelancer profile, I enjoy working with clients that take good quality and design seriously. I'd love to chat with you over online chatting to discuss the job more detail. I look forward t Lagi

$37 USD / jam
(24 Ulasan)
7.2
phpdeveloper100

Ready to work as best laravel developer Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-cart - X-Cart Lagi

$36 USD / jam
(75 Ulasan)
7.3
pofilippov

Hello. I can do your task. Could we discuss the project in more detail. About me: My programming experience is 9 years. I did projects both in the development team and alone. I am pleased to perform work of any comp Lagi

$34 USD / jam
(39 Ulasan)
6.8
iblinfotech

Hello There With over 7+ years of experience, We consider our-self very well versed having required technical skills to help you with your laravel project needs. We've done many laravel project in our past work with p Lagi

$30 USD / jam
(36 Ulasan)
6.8
limillion819

Hi there. I got really excited with your project and I can say that really matches to my skills. Along as my worth experience of Laravel, I can help with all the issues and support you 100% bringing fully satisfactory Lagi

$50 USD / jam
(34 Ulasan)
6.9
harrysart

⭐Dear Client.⭐ I have read your description with great interest. I have experiences with many project. Also i am able to finish the task in time. Please check my portfolio if you want to know my skill and experience. Lagi

$25 USD / jam
(134 Ulasan)
6.7
grigorywazin

Hello. How are you doing? I've just read your project description and I will do your project with high quality. I am a senior developer who developed a lot of websites with Laravel. Laravel is the best PHP Framework so Lagi

$37 USD / jam
(39 Ulasan)
6.6
alexdanilovua

Hi. I am very interesting in your job. As you can see my profile, I have expertise in front-end such as JavaScript/Ajax, Angular, Vue, HTML5/CSS3, jQuery, Bootstrap, Scss/less,ReactJS, React Native, Ionic,MongoDB and s Lagi

$37 USD / jam
(36 Ulasan)
6.1
symaticssolution

Hi There, I have a great expertise in designing and developing LARAVEL web applications from scratch and I am ready to sign NDA before starting your project. We are excited to show our past developed LARAVEL web appli Lagi

$25 USD / jam
(69 Ulasan)
6.9
trustworthyDev

Detail-oriented WEB Developer with 8 years of experience developing a responsive website on both front and back end. I believe you can use my skills and experiences for your great project, under checking your requirem Lagi

$37 USD / jam
(16 Ulasan)
6.1
MaZheng225

Hello, I've read your post carefully. I am a senior web developer with rich experiences of Laravel. Also I have excellent skills for finding and fixing bugs from existing websites. Please contact me to share more detai Lagi

$30 USD / jam
(26 Ulasan)
5.8
SecureForYou

Hi,sir. Thanks for taking your valuable time for reviewing my proposal.I'm a senior developer with over 10 years of experience. I think I can be a candidate for your project. If you can give me your project, I'll do my Lagi

$41 USD / jam
(6 Ulasan)
5.3
unboltsoft

We are a Ukrainian software development company that employs several passionate engineers. Our main focus is scientific software, but we also do web and mobile development. In the last few years we have completed man Lagi

$25 USD / jam
(2 Ulasan)
5.3