コード例 #1
0
 public static function recover($sid, $tid)
 {
     $tokenRecuperable = DB::Table('tokens_' . $sid)->where('tid', $tid)->first();
     $attRecargables = LlamadasController::getAttRecargables($sid);
     $selectSQL = '';
     $updatedValues = array();
     $updatedValues['completed'] = 'N';
     if (sizeof($attRecargables) != 0) {
         $firstElement = true;
         foreach ($attRecargables as $key => $value) {
             if (!$firstElement) {
                 $selectSQL .= ',';
             } else {
                 $firstElement = false;
             }
             $selectSQL .= '`' . $value . '` as ' . $key;
         }
         $sqlUltimosDatosRegistrados = " select " . $selectSQL . " from ( select token,max(id) as maxid from survey_" . $sid . " group by token) as maxTable " . " inner join survey_" . $sid . " as sv on maxTable.token=sv.token and maxTable.maxId = sv.id " . " where maxTable.token='" . $tokenRecuperable->token . "'";
         $rsUpdatedValues = DB::select($sqlUltimosDatosRegistrados)[0];
         var_dump($rsUpdatedValues);
         foreach ($attRecargables as $key => $value) {
             $updatedValues[$key] = $rsUpdatedValues->{$key};
         }
     }
     //Actualizo el token recibido
     DB::table('tokens_' . $sid)->where('tid', $tid)->update($updatedValues);
 }
コード例 #2
0
 public function recover(Request $request, $sid)
 {
     $desde = $request->input('desde');
     $hasta = $request->input('hasta');
     if ($desde < 0) {
         $desde = 1;
     }
     $nLlamadasTot = DB::table('tokens_' . $sid)->count();
     if ($hasta > $nLlamadasTot) {
         $hasta = $nLlamadasTot;
     }
     if ($desde > $hasta) {
         return Redirect::to('survey/' . $sid . '/dispatch')->with('status', 'El limite inferior no puede ser mayor que el limite superior.');
     }
     log::info('[' . $sid . '] Recueperamos las llamadas de el token ' . $desde . ' hasta el ' . $hasta);
     $rellamadaColumn = $sid . 'X' . SettingsController::getAnwswerGroup($sid) . 'X' . SettingsController::getRellamadaAnswer($sid);
     $sqlTokensRecuperables = " select tid,token from tokens_" . $sid . " where token in " . " ( " . " \tselect maxTable.token " . " \tfrom ( select token,max(id) as maxid from survey_" . $sid . " group by token) as maxTable " . " \tinner join survey_" . $sid . " as sv on maxTable.token=sv.token and maxTable.maxId = sv.id " . " \twhere `" . $rellamadaColumn . "`='A1' " . "  ) and tokens_" . $sid . ".completed<>'N'" . " and tid between " . $desde . " and " . $hasta;
     $tokensRecuperables = DB::select($sqlTokensRecuperables);
     foreach ($tokensRecuperables as $tokenRecuperable) {
         //Recuperamos cada llamada
         LlamadasController::recover($sid, $tokenRecuperable->tid);
     }
     return Redirect::to('survey/' . $sid)->with('status', 'Proceso de recuperacion de llamadas, realizado correctamente');
 }