$sql .= " AND ({$date_sql})";
$display["dfilter"] = true;
}
//
//Paging
//
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY UNIX_TIMESTAMP(dtcreated) DESC";
$paging->ApplyFilter($_POST["filter_q"], array("description"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("client/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("client/inc/paging.tpl");
//
// Rows
//
foreach ((array)$db->GetAll($paging->SQL) as $k=>$row)
{
$display["rows"][$k] = $row;
$display["rows"][$k]["userinfo"] = $db->GetRow("SELECT * FROM users WHERE id='{$row['userid']}'");
$display["rows"][$k]["gatename"] = ucfirst($row["gate"]);
}
$display["dt"] = (!$_POST["dt"]) ? date("m/d/Y") : $_POST["dt"];
$display["dt2"] = (!$_POST["dt2"]) ? date("m/d/Y") : $_POST["dt2"];
{
$date = strtotime($req_dt);
$sql .= " AND TO_DAYS(dtadded) = TO_DAYS(FROM_UNIXTIME('{$date}'))";
$paging->AddURLFilter("dt", $req_dt);
$display["dt"] = $req_dt;
}
else
$display["dt"] = date("m/d/Y");
//Paging
$paging->SetSQLQuery($sql);
$paging->AdditionalSQL = "ORDER BY dtadded DESC";
$paging->ApplyFilter($_POST["filter_q"], array("object"));
$paging->ApplySQLPaging();
$paging->ParseHTML();
$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl");
$display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl");
// Rows
$rows = $db->Execute($paging->SQL);
$added = array();
while ($row = $rows->FetchRow())
{
$row["type"] = ucfirst(strtolower($row["type"]));
$row["operation"] = ucfirst(strtolower($row["operation"]));
$display["rows"][] = $row;
}
}
{
$c = DBContact::GetInstance()->LoadByCLID($clid['clid']);
$contact_fields = $c->GetFieldList();
$rows[] = array
(
'clid' => $c->CLID,
'title' => $c->GetTitle()
);
}
catch (Exception $e)
{}
}
$display['rows'] = $rows;
$display['paging'] = $paging->GetPagerHTML("client/inc/paging.tpl");
$display['filter'] = $paging->GetFilterHTML('client/inc/contact_table_filter.tpl');
$display['type'] = $req_type;
$display['TLD'] = $req_TLD;
$display['groupname'] = $req_groupname;
$display['contact_name'] = $contact_name;
$smarty->assign($display);
print $smarty->fetch("client/inc/contact_list.tpl");
exit();
break;
}
$retval = array("result" => $res, "data" => $data);
