EstacionController.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace app\controllers;
  3. use app\components\data\Respuesta;
  4. use app\components\rest\JsonController;
  5. use yii\db\Query;
  6. use yii\filters\AccessControl;
  7. class EstacionController extends JsonController {
  8. public function behaviors() {
  9. return [
  10. 'access' => [
  11. 'class' => AccessControl::className(),
  12. 'only' => ['por-pc'],
  13. 'rules' => [
  14. [
  15. 'actions' => ['por-pc'],
  16. 'allow' => true,
  17. 'roles' => ['@'],
  18. ],
  19. ],
  20. ],
  21. ];
  22. }
  23. public function actionPorPc() {
  24. $req = \Yii::$app->getRequest();
  25. $pc = trim($req->get("pc", ""));
  26. if($pc === "") {
  27. return (new Respuesta())
  28. ->esError()
  29. ->mensaje("Debe enviar el PC");
  30. }
  31. $query = (new Query())
  32. ->distinct()
  33. ->select([
  34. "estacion as [[clave]]",
  35. "ciudad as [[idCiudad]]",
  36. "ciudad || '-' || estacion as [[key]]",
  37. ])
  38. ->from("Descarga")
  39. ->andWhere(["pc" => $pc]);
  40. return (new Respuesta($query, -1));
  41. }
  42. }