Beispiel #1
0
 /**
  * @param $attribute
  * @param $params
  * Kiem tra gio xin trong don co phep khong
  */
 public function hoursAllow($attribute, $params)
 {
     //Neu manager or hrm ko ok thi ko can kiem tra nua.
     //        if($this->manager_ok != 1 || $this->hrm_ok != 1)
     //            return true;
     $reason = ReasonApplication::findOne($this->reason);
     //thoi gian cho phep cua kieu nghi phep do tinh trong 1 lan nghi phep
     if (isset($reason->time_allow) && $reason->type == 1 && $this->hours_off > $reason->time_allow) {
         $this->addError($attribute, "The maximum time to leave is " . $reason->time_allow . "h");
     }
     //thoi gian cho phep cua kieu nghi phep do tinh trong 1 nam nghi phep
     //nghi trong truong hop khong co giay to
     if (isset($reason->time_allow) && $reason->type == 12) {
         $hours = Yii::$app->db->createCommand("SELECT SUM(hours_off) AS hours FROM `application` WHERE (`user_id`=" . $this->user_id . ") AND (`manager_ok`=1) AND (`hrm_ok`=1) AND (`reason`=3) AND year(from_date) = " . date('Y', strtotime($this->from_date)))->queryOne();
         if ($hours['hours'] == '') {
             $hours['hours'] = 0;
         }
         if ($reason->time_allow < (int) $hours['hours'] + $this->hours_off) {
             $this->addError($attribute, "The maximum time to leave is " . $reason->time_allow . "h. You leave " . $hours['hours'] . "h.");
         }
     }
     //thoi gian nghi phep hang nam.
     if ($this->reason == 13) {
         $hours = Yii::$app->db->createCommand("SELECT SUM(hours_off) AS hours FROM `application` WHERE (`user_id`=" . $this->user_id . ") AND (`manager_ok`=1) AND (`hrm_ok`=1) AND (`reason`=13) AND year(from_date) = " . date('Y', strtotime($this->from_date)))->queryOne();
         $userYear = UserDate::findOne(['user_id' => $this->user_id, 'year' => date('Y', strtotime($this->from_date))]);
         if ($hours['hours'] == '') {
             $hours['hours'] = 0;
         }
         if ($userYear === null) {
             $this->addError($attribute, "You don't set time leave in " . date('Y', strtotime($this->from_date)) . ". Please contact to human resource manager");
             return;
         }
         if ($hours['hours'] + $this->hours_off > $userYear->entitlement) {
             $this->addError($attribute, "The maximum time to leave is " . $userYear->entitlement . "h in " . $userYear->year . " . You leave " . $hours['hours'] . "h.");
         }
     }
     //Nghi bu tru vao thoi gian lam them.
     //11: nghi bu cho gio lam them
     //12: lam them gio
     //14: chuyen gio lam them thanh tien
     if ($this->reason == 11 || $this->reason == 14) {
         $timeover = Yii::$app->db->createCommand("SELECT SUM(hours_off) AS hours FROM `application` WHERE (`user_id`=" . $this->user_id . ") AND (`manager_ok`=1) AND (`hrm_ok`=1) AND (`reason`=12)")->queryOne();
         $timeLeave = Yii::$app->db->createCommand("SELECT SUM(hours_off) AS hours FROM `application` WHERE (`user_id`=" . $this->user_id . ") AND (`manager_ok`=1) AND (`hrm_ok`=1) AND (`reason`=11)")->queryOne();
         $timeMoney = Yii::$app->db->createCommand("SELECT SUM(hours_off) AS hours FROM `application` WHERE (`user_id`=" . $this->user_id . ") AND (`manager_ok`=1) AND (`hrm_ok`=1) AND (`reason`=14)")->queryOne();
         if ($timeover['hours'] == '') {
             $timeover['hours'] = 0;
         }
         if ($timeLeave['hours'] == '') {
             $timeLeave['hours'] = 0;
         }
         if ($timeMoney['hours'] == '') {
             $timeMoney['hours'] = 0;
         }
         if ($timeover['hours'] - $timeLeave['hours'] - $timeMoney['hours'] - $this->hours_off < 0) {
             $this->addError($attribute, "The overtime remaining is " . ($timeover['hours'] - $timeLeave['hours'] - $timeMoney['hours']) . "h. ");
         }
     }
 }
Beispiel #2
0
 public function searchUser($params, $user_id)
 {
     $query = UserDate::find();
     $query->select('user_info.*, year, entitlement, entitlement - (SELECT SUM(hours_off) AS hours FROM `application` WHERE user_id = ' . $user_id . ' AND manager_ok = 1 AND hrm_ok = 1 AND reason = 13 AND YEAR(from_date) = user_date.`year`) AS balance');
     $query->joinWith(['user']);
     $query->where(['user_date.user_id' => $user_id]);
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'year' => $this->year, 'entitlement' => $this->entitlement, 'balance' => $this->balance]);
     return $dataProvider;
 }
Beispiel #3
0
 public function getApplications()
 {
     return $this->hasMany(UserDate::className(), ['id' => 'reason']);
 }
Beispiel #4
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getUserDates()
 {
     return $this->hasMany(UserDate::className(), ['user_id' => 'user_id']);
 }
 public function actionCreateForStaff($id)
 {
     $model = new UserDate();
     $model->user_id = $id;
     $model->year = date('Y');
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['userinfo/index']);
     } else {
         return $this->render('create', ['model' => $model]);
     }
 }