idea ide updates
[scannr.git] / generateConvos.php
blob:a/generateConvos.php -> blob:b/generateConvos.php
--- a/generateConvos.php
+++ b/generateConvos.php
@@ -1,33 +1,34 @@
 <?php
 include('common.inc.php');
-  $sth = $conn->prepare( 'select * from recordings limit 100;');
+$sth = $conn->prepare('select * from recordings limit 100;');
 
-    $sth->execute( );
+$sth->execute();
 $recordings = $sth->fetchAll();
 $convos = Array();
 $convo = Array();
 foreach ($recordings as $i => $recording) {
 
-	if (count($convo) > 0) {
-		echo "<br> ".strcasecmp($convos[count($convos)-1][0]['call_timestamp'],$recording['call_timestamp']);
-		if (abs(strcasecmp($convos[count($convos)-1][0]['call_timestamp'],$recording['call_timestamp'])) > 2) {
-			echo " ".$convos[count($convos)-1][0]['call_timestamp']." ".$recording['call_timestamp'];
-		}
-		if (strcasecmp($convos[count($convos)-1][0]['tgid'], $recording['tgid']) != 0 ) {
-		$convos[] = $convo;
-		$convo = Array();
-		}
-	} ;
-	//print_r($recording);
-	$convo[] = $recording;
-	//print_r($convo);
-	//echo "<br>\n";
+    if (count($convo) > 0) {
+        echo "<br> " . strcasecmp($convos[count($convos) - 1][0]['call_timestamp'], $recording['call_timestamp']);
+        if (abs(strcasecmp($convos[count($convos) - 1][0]['call_timestamp'], $recording['call_timestamp'])) > 2) {
+            echo " " . $convos[count($convos) - 1][0]['call_timestamp'] . " " . $recording['call_timestamp'];
+        }
+        if (strcasecmp($convos[count($convos) - 1][0]['tgid'], $recording['tgid']) != 0) {
+            $convos[] = $convo;
+            $convo = Array();
+        }
+    }
+    ;
+    //print_r($recording);
+    $convo[] = $recording;
+    //print_r($convo);
+    //echo "<br>\n";
 }
 foreach ($convos as $i => $convo) {
-	foreach($convo as $recording) {
-		echo $recording['filename']." , ";
-	}
-	echo "<br><hr>\n";
+    foreach ($convo as $recording) {
+        echo $recording['filename'] . " , ";
+    }
+    echo "<br><hr>\n";
 }
 ?>