Example #1
0
require_once "../../includes/settings.php";
require_once "../../includes/dbase.php";
require_once "../../includes/template.php";
if (isset($_REQUEST['leadid'])) {
    $leadid = $_REQUEST['leadid'];
} else {
    exit;
}
if (isset($_REQUEST['cname'])) {
    $cname = $_REQUEST['cname'];
} else {
    exit;
}
$db = new dbconnection();
$db->dbconnect();
$db->query = "\n  select * from " . TABLE_HISTORY . " a\n  inner join " . TABLE_USERS . " b on (a.agent=b.userid)\n  where leadid={$leadid} order by tagdate desc\n  ";
$db->execute();
$history = array();
$rowcount = $db->rowcount();
if ($rowcount > 0) {
    for ($x = 0; $x < $rowcount; $x++) {
        $row = $db->fetchrow($x);
        $history[$x] = $row;
    }
}
$body = new Template();
$body->set_template("../../templates/agent/callhistory.html");
$body->add_key('cname', $cname);
$body->template_loop('history', $history);
echo $body->create();