当前位置: 首页>>代码示例>>PHP>>正文


PHP Course::count方法代码示例

本文整理汇总了PHP中app\Course::count方法的典型用法代码示例。如果您正苦于以下问题:PHP Course::count方法的具体用法?PHP Course::count怎么用?PHP Course::count使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在app\Course的用法示例。


在下文中一共展示了Course::count方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: index

 /**
  * Show the application dashboard.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $_schedule_masters = Master::orderBy('id', 'desc')->lists('name', 'id');
     $master_id = array_keys(head($_schedule_masters))[0];
     $data_pie = DB::select('SELECT da.code, count(sc.id) total_class
                     FROM (
                         SELECT isc.*
                         FROM schedules isc
                         GROUP BY isc.section_key
                     ) sc
                     INNER JOIN semesters se ON sc.semester_id = se.id
                     INNER JOIN plans pl ON se.plan_id = pl.id
                     INNER JOIN curriculums cu ON pl.curriculum_id = cu.id
                     INNER JOIN courses co ON pl.course_id = co.id
                     INNER JOIN departments da ON co.department_id = da.id
                     WHERE sc.master_id = ' . $master_id . '
                     GROUP BY da.id');
     $data_query = DB::select('SELECT count(sc.id) total
                     FROM (
                         SELECT isc.*
                         FROM schedules isc
                         GROUP BY isc.room_id
                     ) sc
                     WHERE sc.master_id = ' . $master_id);
     $data_room = [];
     if ($data_query) {
         $data_room['used'] = $data_query[0]->total;
         $data_room['total'] = \App\Room::count();
     }
     $data_query = DB::select('SELECT count(sc.id) total
                     FROM (
                         SELECT isc.*
                         FROM schedules isc
                         WHERE not faculty_id is null
                         GROUP BY isc.faculty_id
                     ) sc
                     WHERE sc.master_id = ' . $master_id);
     $data_faculty = [];
     if ($data_query) {
         $data_faculty['used'] = $data_query[0]->total;
         $data_faculty['total'] = \App\Faculty::count();
     }
     $data_query = DB::select('SELECT count(sc.id) total
                     FROM (
                         SELECT isc.*
                         FROM schedules isc
                         INNER JOIN semesters se ON isc.semester_id = se.id
                         INNER JOIN plans pl ON se.plan_id = pl.id
                         INNER JOIN curriculums cu ON pl.curriculum_id = cu.id
                         INNER JOIN courses co ON pl.course_id = co.id
                         GROUP BY co.id
                     ) sc
                     WHERE sc.master_id = ' . $master_id);
     $data_course = [];
     if ($data_query) {
         $data_course['used'] = $data_query[0]->total;
         $data_course['total'] = \App\Course::count();
     }
     $data_query = DB::select('SELECT count(sc.id) total
                     FROM (
                         SELECT isc.*
                         FROM schedules isc
                         WHERE faculty_id is null
                         OR room_id is null
                         GROUP BY isc.key
                     ) sc
                     WHERE sc.master_id = ' . $master_id);
     $data_unallocated = [];
     if ($data_query) {
         $data_unallocated['used'] = $data_query[0]->total;
         $data_query = DB::select('SELECT count(sc.id) total
                         FROM (
                             SELECT isc.*
                             FROM schedules isc
                             GROUP BY isc.key
                         ) sc
                         WHERE sc.master_id = ' . $master_id);
         $data_unallocated['total'] = $data_query[0]->total;
     }
     return view('dashboard.index', compact('data_pie', 'data_room', 'data_faculty', 'data_course', 'data_unallocated'));
 }
开发者ID:zheralfin,项目名称:oras,代码行数:86,代码来源:DashboardController.php


注:本文中的app\Course::count方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。