Guest User

Untitled

a guest
Jul 16th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.25 KB | None | 0 0
  1. if($service == 'gentel') {
  2.  
  3. // locally:
  4.  
  5. $dir = storage_path('app/cdr/gentel');
  6.  
  7. $files = scandir($dir);
  8.  
  9. foreach($files as $file) {
  10.  
  11. if($file != '.' && $file != '..') {
  12.  
  13. $control = \DB::table('telco_cdr_gentel_calls')->select('id')->where('origin', $file)->count();
  14.  
  15. if($control == 0) {
  16.  
  17. $data = file_get_contents(storage_path('app/cdr/gentel/' . $file));
  18.  
  19. $lines = explode("\n", $data);
  20.  
  21. foreach($lines as $line) {
  22.  
  23. $values = explode(';', $line);
  24.  
  25. if(isset($values[3]) && is_numeric($values[3])) {
  26.  
  27. TelcoCdrGentelCall::create([
  28.  
  29. 'origin' => $file,
  30. 'NoFacture' => $values[0],
  31. 'IdCdr' => $values[1],
  32. 'NoClient' => $values[2],
  33. 'DateHeureAppel' => $values[3],
  34. 'DureeEnS' => $values[4],
  35. 'NumeroAppele' => $values[5],
  36. 'NoLigneAppelante' => $values[6],
  37. 'TypeCom' => utf8_encode($values[7]),
  38. 'VolumeDonneesEnKo' => $values[8],
  39. 'Destination' => utf8_encode($values[9]),
  40. 'TypeAppel' => utf8_encode($values[10]),
  41. 'UnitesAppel' => $values[11],
  42. 'UnitesDecomptees' => $values[12],
  43. 'coutEtablissementHt' => $values[13],
  44. 'coutValoriseHt' => $values[14],
  45. 'PrefixeForce' => $values[15],
  46.  
  47. ]);
  48.  
  49. print 'insert call: ok' . PHP_EOL;
  50.  
  51. }
  52. }
  53. }
  54. else {
  55.  
  56. print 'This file has already been imported' . PHP_EOL;
  57.  
  58. }
  59. }
  60. }
  61. }
Add Comment
Please, Sign In to add comment