Пример #1
0
 public function testManipulatingArray()
 {
     $array = array(70, 80, 90, 100, 105);
     $Cadence = new Running();
     $Cadence->manipulateArray($array);
     $this->assertEquals(array(140, 160, 180, 200, 210), $array);
 }
Пример #2
0
 public function storeRunning()
 {
     $durasi = Input::get('running_duration');
     $dtStart = date("Y-m-d H:i:s", time());
     $dtEnd = date("Y-m-d H:i:s", time() + $durasi * 60);
     /*
     		
     			*
     		FROM
     			tb_modul
     		INNER JOIN tb_quiz USING (modul_id)
     		WHERE
     			tb_modul.modul_id = 8
     		ORDER BY
     			tb_quiz.quiz_urutan ASC
     */
     $dS = date("Y-m-d H:i:s", time());
     $ambilQuiz = DB::table('tb_modul')->join('tb_quiz', 'tb_modul.modul_id', '=', 'tb_quiz.modul_id')->where('tb_modul.modul_id', '=', Input::get('modul_id'))->select('tb_quiz.quiz_id', 'tb_quiz.quiz_durasi')->get();
     /*
     SELECT
     	*
     FROM
     	tb_user
     INNER JOIN tb_praktikan USING (user_id)
     INNER JOIN tb_detail_jadwal_praktikan USING (praktikan_nim)
     INNER JOIN tb_jadwal using(jadwal_id)
     where tb_jadwal.jadwal_id = 1
     */
     $ambilUser = DB::table('tb_user')->join('tb_praktikan', 'tb_praktikan.user_id', '=', 'tb_user.user_id')->join('tb_detail_jadwal_praktikan', 'tb_detail_jadwal_praktikan.praktikan_nim', '=', 'tb_praktikan.praktikan_nim')->join('tb_jadwal', 'tb_jadwal.jadwal_id', '=', 'tb_detail_jadwal_praktikan.jadwal_id')->get();
     $run = new Running();
     $run->running_start = $dtStart;
     $run->running_end = $dtEnd;
     $run->running_duration = Input::get('running_duration');
     $run->jadwal_id = Input::get('jadwal_id');
     $run->modul_id = Input::get('modul_id');
     $run->user_id = $this->cekUser();
     $run->save();
     $ambilIdLastRunning = DB::table('tb_running')->orderBy('running_id', 'desc')->select('running_id')->first();
     $dS = date("Y-m-d H:i:s");
     foreach ($ambilUser as $au) {
         foreach ($ambilQuiz as $aq) {
             $dE = date($dS, time() + $aq->quiz_durasi * 60);
             $kunci_quiz = new KunciQuiz();
             $kunci_quiz->user_id = $this->cekUser();
             $kunci_quiz->quiz_id = $aq->quiz_id;
             $kunci_quiz->kunci_quiz_start = $dS;
             $kunci_quiz->kunci_quiz_end = $dE;
             $kunci_quiz->kunci_quiz_status = 0;
             $kunci_quiz->user_id = $au->user_id;
             $kunci_quiz->running_id = $ambilIdLastRunning->running_id;
             $kunci_quiz->save();
             $dS = $dE;
         }
     }
     $praktikum = Input::get('praktikum_id');
     return Redirect::to('praktikum/pra/' . $praktikum);
 }