public static function statSceneDay($date) { U::W(__METHOD__ . " BEGIN"); $tableName = MSceneDay::tableName(); $ghs = MGh::find()->all(); foreach ($ghs as $gh) { foreach ($gh->staffs as $staff) { if ($staff->scene_id != 0) { $score = MAccessLog::getScoreByRange($gh->gh_id, $staff->scene_id, $date, $date); if ($score != 0) { Yii::$app->db->createCommand("INSERT INTO {$tableName} (gh_id,create_date,scene_id,score) VALUES (:gh_id,:create_date,:scene_id,:score)", [':gh_id' => $gh->gh_id, ':create_date' => $date, ':scene_id' => $staff->scene_id, ':score' => $score])->execute(); } } } // for the fan without anyboby's recommend $staff = new MStaff(); $staff->scene_id = 0; $score = MAccessLog::getScoreByRange($gh->gh_id, $staff->scene_id, $date, $date); if ($score != 0) { Yii::$app->db->createCommand("INSERT INTO {$tableName} (gh_id,create_date,scene_id,score) VALUES (:gh_id,:create_date,:scene_id,:score)", [':gh_id' => $gh->gh_id, ':create_date' => $date, ':scene_id' => $staff->scene_id, ':score' => $score])->execute(); } } U::W(__METHOD__ . " END"); return; /* $tableName = MAccessLog::tableName(); $n = Yii::$app->db->createCommand("DELETE FROM $tableName WHERE create_time < DATE_SUB(NOW(), INTERVAL 90 day)")->execute(); U::W("DELETE $tableName, $n"); $tableName = MAccessLogAll::tableName(); $n = Yii::$app->db->createCommand("DELETE FROM $tableName WHERE create_time < DATE_SUB(NOW(), INTERVAL 180 day)")->execute(); U::W("DELETE $tableName, $n"); */ }