public function addScheduleDetail(ScheduleDetail $l) { $this->collScheduleDetails[] = $l; $l->setSchedule($this); }
public function executeSaveCopy() { $accal_tujuan = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal1')); $accal_asal = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal2')); $params = array(); foreach (explode('&', $this->getRequestParameter('ekskul_list_ser')) as $p) { $p = explode('=', $p); $params[rawurldecode($p[0])][] = rawurldecode($p[1]); } if (array_key_exists('ekskuls', $params)) { foreach ($params['ekskuls'] as $ekskul_id) { $sc = SchedulePeer::retrieveByPK($ekskul_id); $cw = new Criteria(); $cw->add(ScheduleDetailPeer::SCHEDULE_ID, $sc->getId()); $sc_details = ScheduleDetailPeer::doSelect($cw); $cd = new Criteria(); $cd->add(ScheduleTutorPeer::SCHEDULE_ID, $sc->getId()); $sc_tutors = ScheduleTutorPeer::doSelect($cd); $schedule = new Schedule(); $schedule->setGradeComponentId($sc->getGradeComponentId()); $schedule->setAcademicCalendarId($accal_tujuan->getId()); $schedule->setType(2); $schedule->setEmployeeId($sc->getEmployeeId()); $schedule->save(); foreach ($sc_details as $sc_detail) { $schedule_detail = new ScheduleDetail(); $schedule_detail->setSchedule($schedule); $schedule_detail->setLocationId($sc_detail->getLocationId()); $schedule_detail->setClassSessionId($sc_detail->getClassSessionId()); $schedule_detail->setDay($sc_detail->getDay()); $schedule_detail->save(); $cb = new Criteria(); $cb->add(StudentRaportPeer::GRADE_COMPONENT_ID, $sc->getGradeComponentId()); $cb->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $sc->getAcademicCalendarId()); $cb->add(StudentRaportPeer::SCHEDULE_DETAIL_ID, $sc_detail->getId()); $cb->add(StudentRaportPeer::SCHEDULE_ID, $sc->getId()); $stu_raports = StudentRaportPeer::doSelect($cb); foreach ($stu_raports as $stu_raport) { $sr = new StudentRaport(); $sr->setStudentId($stu_raport->getStudentId()); $sr->setAcademicCalendarId($accal_tujuan->getId()); $sr->setGradeComponentId($sc->getGradeComponentId()); $sr->setClassGroupId($sc->getClassGroupId()); $sr->setSchedule($schedule); $sr->setScheduleDetail($schedule_detail); $sr->save(); } } foreach ($sc_tutors as $sc_tutor) { $schedule_tutor = new ScheduleTutor(); $schedule_tutor->setSchedule($schedule); $schedule_tutor->setEmployeeId($sc_tutor->getEmployeeId()); $schedule_tutor->save(); } } } return $this->redirect('extracurricular/list'); }
public function actionJsoncalendar_add() { if (Yii::$app->request->isAjax) { $request = Yii::$app->request; $model = new Scheduleheader(); $profile = Yii::$app->getUserOpt->Profile_user(); $usercreate = $profile->username; $end = $request->post('tgl2'); $start = $request->post('tgl1'); $scdl_group = $request->post('scdl_group'); $user_id = $request->post('user_id'); $note = $request->post('note'); $model->TGL1 = $start; $model->TGL2 = $end; $model->CREATE_BY = $usercreate; $model->CREATE_AT = date("Y-m-d H:i:s"); $model->NOTE = $note; $model->SCDL_GROUP = $scdl_group; $model->USER_ID = $user_id; $carisdl = ScheduleDetail::find()->where(['TGL' => $model->TGL1, 'SCDL_GROUP' => $scdl_group])->one(); // print_r($carisdl); // die(); // if exist data customers if ($carisdl) { echo 2; } else { if ($model->save()) { // foreach date :author wawan for ($date = strtotime($start); $date < strtotime($end); $date = strtotime("+1 day", $date)) { $tgl = date("Y-m-d", $date); $Customers = Customers::find()->where(['SCDL_GROUP' => $scdl_group])->asArray()->all(); foreach ($Customers as $key => $value) { # code... $connection = Yii::$app->db_esm; $connection->createCommand()->batchInsert('c0002scdl_detail', ['TGL', 'CUST_ID', 'SCDL_GROUP', 'USER_ID'], [[$tgl, $value['CUST_KD'], $scdl_group, $user_id]])->execute(); } } } } } return true; }