后台获取数据关联表-数据结构-嵌套页面
来源:互联网 发布:网络暴力有哪方面影响 编辑:程序博客网 时间:2024/06/05 07:20
后台获取数据关联知识点
关联关系图
watchRecordModel 课程观看记录表: 课程观看记录Model:
courseModel 课程表 课程Model
课程——期——章节关联表 期——章节Model:
课时表 课时Model:
以下是获取后台的code
/**
* 获取个人进度详情信息(Vip)
*
*/
public function getVipCourses(){
$page = post('page',1);
// trace_log(111);exit;
$userId = $this->formatParam();
if(!empty($userId)){
$courseIds = WatchRecordModel::where('user_id',$userId)->distinct()->lists('course_id');
// trace_log($courseIds);exit;
if(!empty($courseIds)){
$courses = Course::where('type_id',2)->where('status',2)->whereIn('id',$courseIds)
->with('period.units.lessons.watchrecord')
->get()
->toArray();
// trace_log($courses);exit;
return $courses;
}
}
return '0';
}
数据结构:仅供参考
[2016-10-27 15:42:56] production.INFO: Array
(
[0] => Array
(
[id] => 60
[name] => 设计师超值VIP课程6
[level_id] => 1
[type_id] => 2
[category_id] => 3
[is_direct_broadcast] => 0
[introduction] => <p>设计师超值VIP课程4</p>
[description] =>
[package_detail] => <p>11</p>
[course_special_topic] => <p>11</p>
[price] => 0.00
[discount_price] => 0.00
[status] => 2
[sequence] => 0
[keywords] => 设计
[creator_id] => 1
[base_number] => 0
[created_at] => 2016-09-29 17:27:57
[updated_at] => 2016-10-11 09:32:50
[period] => Array
(
[0] => Array
(
[id] => 67
[name] => 课程进度期
[type] => 1
[parent_id] => 0
[sequence] => 1
[course_id] => 60
[created_at] => 2016-10-12 09:35:44
[updated_at] => 2016-10-12 09:35:44
[status] => 1
[units] => Array
(
[0] => Array
(
[id] => 68
[name] => 课程进度章节
[type] => 2
[parent_id] => 67
[sequence] => 1
[course_id] => 60
[created_at] => 2016-10-12 09:35:49
[updated_at] => 2016-10-12 09:35:49
[status] => 1
[lessons] => Array
(
[0] => Array
(
[id] => 48
[course_id] => 60
[course_unit_id] => 68
[title] => 课程进度课时
[status] => 1
[start_time] => 2016-10-13 00:00:00
[end_time] => 2016-10-21 00:00:00
[class_period] => 0
[created_at] => 2016-10-12 09:36:00
[updated_at] => 2016-10-12 09:36:00
[sequence] => 1
[watchrecord] => Array
(
[0] => Array
(
[id] => 1
[user_id] => 1
[lesson_id] => 48
[course_id] => 60
[address] => 120.52.24.68
[browser] => 1
[client] => 1
[end_time] => 2016-10-12 00:00:00
[schedule] => 30
[watch_time] => 2
[exception_record] => 异常记录
[created_at] => 2016-10-08 00:00:00
[updated_at] =>
)
[1] => Array
(
[id] => 2
[user_id] => 1
[lesson_id] => 48
[course_id] => 60
[address] => 120.52.24.68
[browser] => 2
[client] => 2
[end_time] => 2016-10-12 00:00:00
[schedule] => 60
[watch_time] => 2
[exception_record] =>
[created_at] => 2016-10-08 00:00:00
[updated_at] =>
)
)
)
)
)
)
)
[1] => Array
(
[id] => 69
[name] => 2017
[type] => 1
[parent_id] => 0
[sequence] => 2
[course_id] => 60
[created_at] => 2016-10-27 10:13:01
[updated_at] => 2016-10-27 10:13:01
[status] => 0
[units] => Array
(
)
)
)
)
[1] => Array
(
[id] => 62
[name] => 课程vip_cjl
[level_id] => 1
[type_id] => 2
[category_id] => 3
[is_direct_broadcast] => 0
[introduction] => 1
[description] =>
[package_detail] =>
[course_special_topic] =>
[price] => 0.00
[discount_price] => 0.00
[status] => 2
[sequence] => 0
[keywords] =>
[creator_id] => 0
[base_number] => 0
[created_at] =>
[updated_at] =>
[period] => Array
(
[0] => Array
(
[id] => 72
[name] => 课程vip——cjl
[type] => 1
[parent_id] => 0
[sequence] => 1
[course_id] => 62
[created_at] =>
[updated_at] =>
[status] => 0
[units] => Array
(
[0] => Array
(
[id] => 73
[name] => 课程vip——章节
[type] => 2
[parent_id] => 72
[sequence] => 1
[course_id] => 62
[created_at] =>
[updated_at] =>
[status] => 0
[lessons] => Array
(
[0] => Array
(
[id] => 50
[course_id] => 62
[course_unit_id] => 73
[title] => 课程进度vip
[status] => 1
[start_time] =>
[end_time] =>
[class_period] => 0
[created_at] =>
[updated_at] =>
[sequence] => 1
[watchrecord] => Array
(
[0] => Array
(
[id] => 4
[user_id] => 1
[lesson_id] => 50
[course_id] => 62
[address] => 120.52.24.68
[browser] => 1
[client] => 2
[end_time] => 2016-10-12 00:00:00
[schedule] => 30
[watch_time] => 2
[exception_record] =>
[created_at] => 2016-10-08 00:00:00
[updated_at] =>
)
)
)
)
)
)
)
)
)
)
关于嵌套页面的code,在我这篇blog有记载:http://blog.csdn.net/chajinglong/article/details/52598761 中的第五部分。
0 0
- 后台获取数据关联表-数据结构-嵌套页面
- jsp页面获取后台数据
- 后台数据结构与前台数据获取
- FusionCharts动态获取后台json数据 页面显示
- 使用echart从后台获取数据动态显示到页面
- js处理后台登录页面嵌套问题
- Struts2获取后台数据
- 获取后台服务器数据
- JS获取后台数据
- Jbox 父页面 获取 子页面 form 数据 并提交到后台
- ajax获取后台数据,页面Json数据按照json格式化输出
- vue 后台数据获取与组件渲染、页面刷新数据消失的问题小结
- easyUI 获取Json 嵌套数据
- DataList嵌套DataList 子DataList访问父DataList数据(1. 页面绑定后台代码实现 纯代码)
- 关于ajax后台获取数据 ,echarts表呈现数据
- 简单界面+JAVA后台+数据库实现页面对数据库的两张关联表操作
- SpringMVC:页面传值到后台,后台获取页面传值
- Jquery 使用Ajax获取后台返回的Json数据后,页面处理
- 派生类的构造函数和析构函数(C++面向对象)
- Android Studio插件整理
- Centos修改镜像为国内的阿里云源或者163源等国内源
- JAVA数据类型
- arm 控制寄存器
- 后台获取数据关联表-数据结构-嵌套页面
- description方法
- Centos查看端口占用情况和开启端口命令
- Docker Guideline Docker 上手操作
- lua中遍历table的几种方式比较
- Java ConcurrentModificationException异常原因和解决方法
- 关于PHP实现迭代器和迭代
- 反转链表
- 文件加载jar冲突