private function addPaidEmployment() { if (!$this->ticket_id) { return true; } $this->_ticketModel = SeasonTicket::findOne(['id' => $this->ticket_id]); if (!$this->_ticketModel) { return true; } $this->_currentDate = Carbon::createFromFormat('d.m.Y', $this->startdate); $this->_endDate = self::getEmploymentEndDate($this->_currentDate, $this->_ticketModel->limit_format, $this->_ticketModel->limit_value); $timeTableGroups = Timetable::find()->asArray()->where(['group_id' => $this->groups])->all(); $cond = 'date >= :startdate AND pay.user_id = :user_id'; $params = [':user_id' => $this->user_id, ':startdate' => $this->_currentDate->toDateString()]; $existEmployments = PaidEmployment::find()->select(['date', 'timetable_id', 'group_id' => 'timetable.group_id'])->asArray()->joinWith(['pay', 'timetable'])->where($cond, $params)->andWhere(['timetable.group_id' => $this->groups])->all(); $existLastEmployment = PaidEmployment::find()->select(['date', 'timetable_id', 'group_id' => 'timetable.group_id'])->asArray()->joinWith(['pay', 'timetable'])->where($cond, $params)->andWhere(['timetable.group_id' => $this->groups])->orderBy('date DESC')->one(); $this->addInsertArrayTimeLimit($timeTableGroups, $existEmployments, $this->_currentDate, $this->_endDate); if ($existLastEmployment) { $lastEmploymentDate = Carbon::createFromFormat('Y-m-d', $existLastEmployment['date'])->addDay(); $this->_endDate = self::getEmploymentEndDate($lastEmploymentDate, $this->_ticketModel->limit_format, $this->_ticketModel->limit_value); } if ($this->_ticketModel->amount > 0) { $this->addInsertArrayAmountLimit($timeTableGroups, $existEmployments, $this->_currentDate, $this->_endDate); } if (!empty($this->_insertArray)) { $command = Yii::$app->db->createCommand()->batchInsert('{{%paid_employment}}', ['date', 'pay_id', 'timetable_id'], $this->_insertArray); return is_int($command->execute()); } else { return true; } }
/** * Finds the SeasonTicket model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return SeasonTicket the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = SeasonTicket::findOne($id)) !== null) { return $model; } else { throw new HttpException(404); } }