forum.lissyara.su

Код: Выделить всё

timeofcall	forwarded	internally	co	way	number	duration	cost
2011-03-31 17:04:20	NULL	 3205 7002 I   37529*******      	129	0.000

Код: Выделить всё

SELECT * FROM calls
WHERE timeofcall like '2011-03-31 %' AND way='A'

Код: Выделить всё

SELECT * FROM calls
WHERE timeofcall like '2011-03-31 %' AND way='I'

Код: Выделить всё

SELECT * FROM calls
WHERE timeofcall like '2011-03-31 %' AND way='A'  and number = any(SELECT dictinct number FROM calls WHERE timeofcall like '2011-03-31 %' AND (way='A' or way='I'))

Код: Выделить всё

<?php

$PhoneNumbers = array();

$result = mysql_query("SELECT * FROM calls WHERE timeofcall like '2011-03-31 %' AND way IN('A', 'I') ORDER BY timeofcall");
while($row = mysql_fetch_assoc($result))
{
    $PhoneNumbers[$row['number']]['time'] = $row['timeofcall'];
    $PhoneNumbers[$row['number']]['missed'] = (($row['way'] == 'I')?false:true);
}

while(list($number, $info) = each($PhoneNumbers))
{
    if ($info['missed'] === true)
    {
         // В $info['time'] был пропущенный звонок с $number
         // и после этого с этого номера больше не звонили.
    }
}

?>

Код: Выделить всё

select * from calls where timeofcall like '2011-03-31 %' AND way='A' and number not in (select number from calls where timeofcall like '2011-03-31 %' AND way='I');

Код: Выделить всё

and way='I'

Код: Выделить всё

 and ( way='I' OR way='A')

Код: Выделить всё

SELECT calls.timeofcall,calls.number,calls.duration,calls.way,extlines.name,intphones.name,calls.co,calls.internally,phonebook.description from calls LEFT JOIN extlines ON calls.co = extlines.line LEFT JOIN intphones ON calls.internally = intphones.intnumber LEFT JOIN phonebook ON calls.number LIKE phonebook.number OR calls.number LIKE phonebook.number where (calls.timeofcall between '2011-04-01 00:00:00' AND '2011-04-30 23:59:59' AND calls.way='A' AND calls.number not in (SELECT calls.number from calls where calls.timeofcall between '2011-04-01 00:00:00' AND '2011-04-30 23:59:59' AND calls.way='I'))