php composer.phar require kartik-v/yii2-date-range "*"
5、
"kartik-v/yii2-date-range": "*"
1 php
2
3 /* @var $this \yii\web\View */
4 /* @var $content string */
5
6 use backend\assets\AppAsset;
7 use yii\helpers\Html;
8 use yii\bootstrap\Nav;
9 use yii\bootstrap\NavBar;
10 use yii\widgets\Breadcrumbs;
11 use common\widgets\Alert;
12
13 //引入时间插件
14 use kartik\daterange\DateRangePicker;
15 ?>
16
17
18
19
20
21
22
23
24
25
26
27
时间: | 31 php 32 echo DateRangePicker::widget([ 33 'model'=>$model, //model,和attribute是必须有的属性 34 'attribute'=>'createtime', //此处是你数据库,存储时间字段的名字 35 'convertFormat'=>true, 36 'pluginOptions'=>[ 37 'timePicker'=>true, 38 'timePickerIncrement'=>30, 39 'format'=>'Y-m-d h:i A' 40 ] 41 ]); ?> 42 |
47
48
9.控制器使用
1 //判断是否有时间搜索提交
2 if(isset($_POST['User']['createtime'])){
3 //重新给$activity_id赋值
4 $activity_id = $_POST['activity_id'];
5 $time = $_POST['User']['createtime'];
6 //var_dump($_POST['User']['createtime']);
7
8 //string '2016-03-09 - 2016-04-07' (length=23)
9 //截取字符串
10 $createtime = explode(' - ',$time);
11
12 //获取到格式化好的时间,将其转换为时间戳
13 $start_time = strtotime($createtime[0]);
14 $end_time = strtotime($createtime[1]);
15 //select * from table where 时间字段 between '2010-7-12 11:18:54' and '2010-7-12 11:22:20'
16 $info = Yii::$app->db->createCommand("select * from item_z_user where createtime between $start_time and $end_time")->queryAll();
17 //var_dump($info);
18 //die;
19 }