yii2使用随记

1.时间范围判断


$machines = Machine::find()
->select("id,name")
->andFilterWhere(["between", "timestamp", $start_date, $end_date])
->asArray()
->all();


2.时间戳与日期转换


$timestamp = strtotime($datetime);
$datetime = date("Y-m-d H:i:s", $timestamp);


3.使用sql语句


$db = Yii::$app->db;
$sql = "...";
$result = $db->createCommand($sql)->bindValues(array(
":driver_id" => $driver->id,...
))->queryOne();


4.分页


（1）nextpage由服务端返回第几页




if (!isset($nextpage) || empty($nextpage)) {
$nextpage = 0;
}


if ($nextpage < 0) {
return;
}




$page = 5;




$machines = Machine::find()
->offset($nextpage * $page)
->limit($page)
->all();




$total_count = ...




if (本次查询个数 + $nextpage * $page < $total_count) {
echo json_encode($this->success(array("machines" => $result, "nextpage" => $nextpage + 1)));


} else {
echo json_encode($this->success(array("machines" => $result, "nextpage" => "")));
}
（2）nextpage由服务端返回自定义时间戳，用于订单按日期排序并统计


5.排序
->orderBy(["farmer_comment_timestamp" => SORT_DESC])


6.isset，empty，is_null验证数据


7.输入的数据校验


8.不能为空判断
->andWhere("farmer_comment != :farmer_comment", [":farmer_comment" => ""])


9.图片url
$url = Yii::$app->urlManager->getHostInfo() . Yii::$app->urlManager->getBaseUrl() . "/" . $farmer["avatar"];


10.参数判断
if (!isset($farmer_id) || empty($farmer_id)) {
echo json_encode($this->fail("", 0, "农民编号不能为空"));
return;
}
11.编码
header("Content-type:json/application;charset=utf-8");


12.字符串截取
$region_id1 = substr($region_id, 0, 2);


13.数字截取
$region_id1 * pow(10, 10)


14.字段求和
$machine_order->getField()->sum("client_area");


15.调用存储过程
$temp = Yii::$app->db->createCommand("call region_count_proc(:machine_order_id,:driver_id)")
->bindValues([":machine_order_id" => $machine_order_id, ":driver_id" => $machine_order->driver_id])
->queryOne();


16.时间范围判断
$dates = Schedule::find()
->select(["date", "status"])
->where(["machine_id" => $machine_id])
->andWhere("date >= :start_date", [":start_date" => $start_date])
->andWhere("date <= :end_date", [":end_date" => $end_date])
->orderBy("date")
->all();


17.多表查询后条件
$works = $machine
->getWorks()
->select("id,farmer_id,farmer_comment,farmer_star,farmer_comment_timestamp")
->where(["status" => Work::STATUS_FINISH])
->andWhere("farmer_comment != :farmer_comment", [":farmer_comment" => ""])
->offset(0)
->limit(2)
->orderBy(["farmer_comment_timestamp" => SORT_DESC])
->asArray()
->all();


18.根据两点间的经纬度计算距离
/**
     * @desc 根据两点间的经纬度计算距离
     * @param float $lat 纬度值
     * @param float $lng 经度值
     */
    function getDistance($lat1, $lng1, $lat2, $lng2)
    {
        $earthRadius = 6367000; //approximate radius of earth in meters


        /*
        Convert these degrees to radians
        to work with the formula
        */


        $lat1 = ($lat1 * pi()) / 180;
        $lng1 = ($lng1 * pi()) / 180;


        $lat2 = ($lat2 * pi()) / 180;
        $lng2 = ($lng2 * pi()) / 180;


        /*
        Using the
        Haversine formula


        http://en.wikipedia.org/wiki/Haversine_formula


        calculate the distance
        */


        $calcLongitude = $lng2 - $lng1;
        $calcLatitude = $lat2 - $lat1;
        $stepOne = pow(sin($calcLatitude / 2), 2) + cos($lat1) * cos($lat2) * pow(sin($calcLongitude / 2), 2);
        $stepTwo = 2 * asin(min(1, sqrt($stepOne)));
        $calculatedDistance = $earthRadius * $stepTwo;


        return round($calculatedDistance);
    }


19.默认路由 
"defaultRoute" => "admin"


20.默认动作
public $defaultAction = "index"




21.百度推送 
本地使用php5.6没问题，服务端使用php5.4报错SDK params invalid, check the param
跟踪源代码发现问题。
php5.4中pushMsgToSingleDevice($channel_id , $message, $opts);channel_id必须是字符串
调用第三方包的时候php中注意数据类型




22.通过model向数据库中保存数据时，注意数据类型，因为model的属性都是有类型，类型不对数据不能保存成功
$field->obstacle_type = strval($obstacle_type_ids);

23.implode，explode第二个参数是字符串不能为数字

24.array转string


implode(array,"字符串分割符")


25.string转array


explode("字符串分割符",string)