[smoothoperator] r4183 committed - Order by calldate

[smootho...@googlecode.com]

Revision: 4183
Author: ma...@venturevoip.com
Date: Wed Apr 10 11:55:47 2013
Log: Order by calldate
http://code.google.com/p/smoothoperator/source/detail?r=4183

Modified:
/SmoothOperatorCRM/add_hung_up.php

=======================================
--- /SmoothOperatorCRM/add_hung_up.php Wed Apr 10 11:54:09 2013
+++ /SmoothOperatorCRM/add_hung_up.php Wed Apr 10 11:55:47 2013
@@ -42,7 +42,7 @@
$hung_up[$job_id] = $best_match_id;

// Now we have the matches (or closest) so we can start finding records
- $sql = 'select userfield, uniqueid, billsec, calldate from cdr where
userfield is not null and userfield != "" and userfield2 != "adjusted" and
billsec < 50 and disposition = "ANSWERED"';
+ $sql = 'select userfield, uniqueid, billsec, calldate from cdr where
userfield is not null and userfield != "" and userfield2 != "adjusted" and
billsec < 50 and disposition = "ANSWERED" order by calldate desc';
$result = mysqli_query($connection, $sql);
while ($row = mysqli_fetch_assoc($result)) {
$split = explode("-",$row['userfield']);