mardi 20 août 2019

Show data as cross tab with php in laravel framework

Hello there hope you well be doing good.I am facing an issue from round about 20 days. I have searched a lot but could not found any solution.Please help me i am be very thankful to you.Please have a look at this link i have explained every think which i have to be build.

https://webmasters.stackexchange.com/questions/124278/display-data-as-cross-tab-in-laravel

I have this join in my laravel controller

enter code here
    $degreesPdfs  = DB::table('student_tbs')
->join('roll_no_tbs','roll_no_tbs.regno','=','student_tbs.regno')
->join('roll_no_com_dets','roll_no_com_dets.rollno','=','roll_no_tbs.rollno')

->join('college_tbs','college_tbs.college_id','student_tbs.department_id')
->leftjoin('subject_tbs','subject_tbs.code','=','roll_no_com_dets.subcode')
->leftjoin('dbo_web_part','dbo_web_part.part','=','roll_no_tbs.part')
->select('student_tbs.student_id','student_tbs.regno','student_tbs.stdName','student_tbs.stdfName','student_tbs.department_id','student_tbs.degree_id','roll_no_tbs.rollno','roll_no_com_dets.subcode','roll_no_com_dets.obt40','subject_tbs.Na','subject_tbs.semester_id','subject_tbs.hours','college_tbs.name','dbo_web_part.P_name','dbo_web_part.OneRTwo')
->where(['student_tbs.department_id' => $degAdmin_department,'student_tbs.degree_id' => $degree])
->distinct(['roll_no_com_dets.subcode','student_tbs.regno'])
//->groupBy('dbo_web_part.OneRTwo')
->orderBy('roll_no_com_dets.rollno')
->get();

Thank you



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire