Example #1
0
 public function testGetStatus()
 {
     $this->specify("Status must be correct", function ($duration, $possession, $complete, $expected) {
         $model = new Trip();
         $model['duration'] = $duration;
         $model['numberPossession'] = $possession;
         $model['complete'] = $complete;
         expect($model->getStatus())->equals($expected);
     }, ['examples' => [['duration' => ['to' => new MongoDate(strtotime('08.03.2015'))], 'possession' => ['to' => new MongoDate(strtotime('07.03.2015'))], 'complete' => true, 'expected' => Trip::STATUS_COMPLETE], ['duration' => ['to' => new MongoDate(strtotime('08.03.2015'))], 'possession' => ['to' => new MongoDate(strtotime('11.03.2015'))], 'complete' => true, 'expected' => Trip::STATUS_COMPLETE], ['duration' => ['to' => new MongoDate(strtotime('08.03.2015'))], 'possession' => ['to' => new MongoDate(strtotime('12.03.2015'))], 'complete' => true, 'expected' => Trip::STATUS_EXPIRED], ['duration' => ['to' => new MongoDate()], 'possession' => ['to' => null], 'complete' => false, 'expected' => Trip::STATUS_INCOMPLETE], ['duration' => ['to' => new MongoDate(time() - Trip::TIME_TO_RETURN_NUMBER - 1)], 'possession' => ['to' => null], 'complete' => false, 'expected' => Trip::STATUS_EXPIRED]]]);
 }
Example #2
0
 public function search(array $params)
 {
     $query = Trip::find();
     $query->with('number', 'employee');
     $query->orderBy(['numberPossession.from' => SORT_DESC]);
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => false]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     if (!empty($this->mobileNumber)) {
         $numberIds = array_map(function ($item) {
             return $item['_id'];
         }, Number::find()->select(['_id'])->asArray()->where(['like', 'number', $this->mobileNumber])->all());
         $query->andWhere(['in', 'numberId', $numberIds]);
     }
     if (!empty($this->employeeName)) {
         $employeeIds = array_map(function ($item) {
             return (int) $item['id'];
         }, Employee::findByName($this->employeeName, true)->select('id')->asArray()->all());
         $query->andWhere(['in', 'employeeId', $employeeIds]);
     }
     if ($this->complete === self::INCOMPLETE) {
         $query->andWhere(['complete' => false]);
     }
     if ($this->rentNumberFrom !== $this->rentNumberTo) {
         $query->andWhere(['numberPossession.from' => ['$gt' => new MongoDate(strtotime($this->rentNumberFrom)), '$lte' => new MongoDate(strtotime($this->rentNumberTo))]]);
     }
     $query->andFilterWhere(['like', 'destination', $this->destination]);
     return $dataProvider;
 }
Example #3
0
 /**
  * @param $id
  * @return Trip
  * @throws NotFoundHttpException
  */
 private function findModel($id)
 {
     if (($model = Trip::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('Запрашиваемая страница не найдена.');
     }
 }
 public function actionTrip()
 {
     $this->stdout("Загружаю командировки\n", Console::FG_BLUE, Console::BOLD);
     $query = (new Query())->from($this->tripTableName);
     $this->stdout("Источник: таблица '{$this->tripTableName}' " . $query->count() . " записей.\nЦелевая коллекция: '" . Trip::collectionName() . "'\n");
     $this->cleanCollection(Trip::collectionName());
     $successCounter = 0;
     foreach ($query->all() as $item) {
         $trip = new Trip();
         $number = (new Query())->select(['number'])->from($this->numberTableName)->where(['id' => $item['mobile_id']])->one();
         $trip['numberId'] = Number::findOne(['number' => $number['number']])->getPrimaryKey();
         $trip['employeeId'] = (int) $item['employee_id'];
         $trip['duration'] = ['from' => new MongoDate(strtotime("+1 day", (int) $item['rent_date'])), 'to' => new MongoDate((int) $item['return_date'])];
         $trip['numberPossession'] = ['from' => new MongoDate((int) $item['rent_date']), 'to' => new MongoDate(strtotime($item['actual_return_date']))];
         if ($trip['numberPossession']['to'] !== null) {
             $trip['complete'] = true;
         }
         $trip['destination'] = $item['destination'];
         if ($trip->save(false)) {
             $successCounter++;
         }
     }
     $this->stdout("Успешно загружено {$successCounter} записей\n", Console::BOLD, Console::FG_GREEN);
     $this->stdout("\n");
     return Controller::EXIT_CODE_NORMAL;
 }