suiyi
<?php
namespace app\controllers;
use Yii;
use app\models\Device;
use app\models\DeviceSearch;
use app\models\DeviceData;
use app\models\DeviceStatus;
use app\models\DeviceStatusSearch;
use yii\data\ActiveDataProvider;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;
/**
* DeviceController implements the CRUD actions for Device model.
*/
class DeviceController extends Controller
{
/**
* @inheritdoc
*/
private $locationArray=[
'北京市'=>'北京市',
'天津市'=>'天津市',
'上海市'=>'上海市',
'重庆市'=>'重庆市',
'黑龙江省'=>'黑龙江省',
'吉林省'=>'吉林省',
'辽宁省'=>'辽宁省',
'河北省'=>'河北省',
'河南省'=>'河南省',
'山东省'=>'山东省',
'江苏省'=>'江苏省',
'山西省'=>'山西省',
'陕西省'=>'陕西省',
'甘肃省'=>'甘肃省',
'四川省'=>'四川省',
'青海省'=>'青海省',
'湖南省'=>'湖南省',
'湖北省'=>'湖北省',
'江西省'=>'江西省',
'安徽省'=>'安徽省',
'浙江省'=>'浙江省',
'福建省'=>'福建省',
'广东省'=>'广东省',
'广西省'=>'广西省',
'贵州省'=>'贵州省',
'云南省'=>'云南省',
'海南省'=>'海南省',
'内蒙古自治区'=>'内蒙古自治区',
'新疆维吾尔自治区'=>'新疆维吾尔自治区',
'宁夏回族自治区'=>'宁夏回族自治区',
'西藏自治区'=>'西藏自治区',
'广西壮族自治区'=>'广西壮族自治区',
];
public function behaviors()
{
return [
'verbs' => [
'class' => VerbFilter::className(),
'actions' => [
'delete' => ['POST'],
],
],
];
}
/**
* Lists all Device models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new DeviceSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
'locationArray' => $this->locationArray,
]);
}
public function actionStatus(){
$searchModel = new DeviceStatusSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('status', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
'locationArray' => $this->locationArray,
]);
}
public function actionUpdatebattery($id){
$model= $this->findModel($id);
if($model){
$model->updateBattery();
}
}
public function actionSendsms($id){
$model= $this->findModel($id);
if($model){
$channelId ='4216275338380855882'; // '3499875588344819295';
$message = $model->phone;
// 设置消息类型为 透传消息
$opts = array (
'msg_type' => 0 ,
);
//Yii::$app->push->pushMsgToSingleDevice($channelId,$message,$opts);
//$push= new \daidai118\baidupusher\PushSDK(\Yii::$app->params['default_apiKey'], \Yii::$app->params['default_secretkey']);
//$push->pushMsgToSingleDevice($channelId,$message,$opts);
require_once(dirname(__FILE__).'/../library/baidupush/sdk.php');
$sdk = new \PushSDK();
$rs = $sdk -> pushMsgToSingleDevice($channelId, $message, $opts);
if($rs === false){
echo json_encode(['message'=>'错误：'. $sdk->getLastErrorCode(). $sdk->getLastErrorMsg()]);
}else{
echo json_encode(['message'=>'已发送短信到'.$model->phone. "\n调试信息：". print_r($rs, true)]);
}
}
}
/**
* Displays a single Device model.
* @param integer $id
* @return mixed
*/
public function actionView()
{
if(isset($_REQUEST['id']) ){
$model= $this->findModel($_REQUEST['id']);
}else{
$device_id= $_REQUEST['device_id'];
$model= Device::find()->where(['device_id'=>$device_id])->one();
if( ! $model){
//create a new device
$model= new Device();
$model->device_id= $device_id;
$model->phone= '0';
$model->location= 'N';
$model->create_time= date('Y-m-d H:i:s');
$model->station_name= "N";
$model->update_time= time();
$model->save();
}
}
$dataProvider = new ActiveDataProvider([
'query' => \app\models\DeviceLog::find()->where(['device_id'=>$model->device_id])->orderBy(['create_time'=>SORT_DESC]),
'pagination' => [
'pageSize' => 20,
],
]);
//$device_data= DeviceData::find()->where(['device_id'=>$model->device_id])->orderBy(['id'=>SORT_DESC])->one();
$device_status= DeviceStatus::find()->where(['device_id'=>$model->device_id])->orderBy(['create_time'=>SORT_ASC])->one();
if( isset($_REQUEST['action']) ){
if( $_REQUEST['action'] == 'action_export'){
header("Content-type:text/csv; charset=utf-8");
$filename="zijiu-{$model->device_id}-".date('Y-m-d').".csv";
header("Content-Disposition:attachment;filename=$filename");
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
$query= $dataProvider->query;
$labels=false;
foreach ($query->each() as $p) {
if( ! $labels ){
//output header
$labels= $p->attributeLabels();
foreach($labels as $v){
echo $v.',';
}
echo "\n";
}
foreach($labels as $k=>$v){
echo $p[$k].',';
}
echo "\n";
}
}
}else{
return $this->render('view', [
'model' => $model,
'dataProvider' => $dataProvider,
//'device_data'=>$device_data,
'device_status'=>$device_status,
'locationArray' => $this->locationArray,
// 'battery_bad'=>$battery_bad,
// 'battery_bad_count'=>$battery_bad_count,
]);
}
}
/**
* Creates a new Device model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Device();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', [
'model' => $model,
'locationArray' => $this->locationArray,
]);
}
}
/**
* Updates an existing Device model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('update', [
'model' => $model,
'locationArray' => $this->locationArray,
]);
}
}
/**
* Finds the Device model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Device the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Device::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
}
1、Gradle配置IDEA正常识别JPA Metamodel Generator动态生成的代码
2、sprint boot 手动快速创建web应用(2)
3、AS3中Object与Dictionary的区别
4、uoj #58 【WC2013】糖果公园
5、【2017.11.29 周三 转载之李航博士的文章：李航图灵访谈】