");
$rem = 'SELECT
b.LOGIN FROM_USERS_LOGIN,
c.LOGIN TO_USERS_LOGIN,
d.FIO FIO,
d.JOBTITLE,
a.DT_REMINDER,
a.REMINDER
FROM
REMINDER as a,
USERS as b,
USERS as c,
PERSON as d
WHERE
a.STATUS=0 AND
a.FROM_USERS_ID = b.ID AND
a.TO_USERS_ID = c.ID AND
a.PERSON_ID = d.ID AND
d.ORGANIZATION_ID = '.$row["ID"];
$reminder = ibase_query($dbh, $rem);
//echo "| От | К | Контактное лицо | Дата,время | Текст напоминания | ";
echo "";
while($row2 = ibase_fetch_assoc($reminder))
{ echo ("| ".
$row2["FROM_USERS_LOGIN"]." | ".
$row2["TO_USERS_LOGIN"]." | ".
$row2["FIO"]."
".$row2["JOBTITLE"]." | ".
$row2["DT_REMINDER"]." | ");
ibase_blob_echo($row2["REMINDER"]);
echo (" | ");
}
ibase_free_result($reminder);
echo (" ");
}
echo "
";
ibase_free_result($sth);
ibase_free_result($count);
ibase_close($dbh);
}
if ($po=="2")
{
// Клиентские пирамиды
if ($manager=="all"){
$stmt = 'SELECT
ACTIVITY, COUNT(*)
from
ORGANIZATION
group by
ACTIVITY';
$cnt = 'SELECT COUNT(*)
from
ORGANIZATION';
}
else {
$stmt = 'SELECT
ACTIVITY, COUNT(*)
from
ORGANIZATION
WHERE USERS_ID=\''.$manager.'\'
group by
ACTIVITY';
$cnt = 'SELECT COUNT(*)
from
ORGANIZATION
WHERE USERS_ID=\''.$manager.'\'';
}
$sth = ibase_query($dbh, $stmt);
$count = ibase_query($dbh, $cnt);
while ($chislo = ibase_fetch_assoc($count))
{
$n = "$chislo[COUNT]";
print "Всего организаций: $n
";
}
while($row = ibase_fetch_assoc($sth))
{
$a[]=$row["COUNT"];
}
$p1=($a[0]*100)/$n;
$p2=($a[1]*100)/$n;
$p3=($a[2]*100)/$n;
$p4=($a[3]*100)/$n;
print "
";
print "
";
print "
";
print "
";
ibase_free_result($sth);
ibase_free_result($count);
ibase_close($dbh);
}
if ($po=="3")
//К ним не звонили:
{
echo "К ним не звонили";
}
if ($po=="4")
//Новые организации
{
echo "Новые организации";
}
?>
|