$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);