function getListOfBuyClicks($dt)
{
global $mycatid;
$str = "";
$lnk = dbConnect('localhost', 'root', 'lyntik');
$query = "SELECT b.fdate as fdate,b.ip as cip,b.goodid as gid,b.name as sname,b.source as src,b.price as price FROM buylog b WHERE b.date='{$dt}' AND b.mycat_id={$mycatid} ORDER BY b.ip,b.fdate";
$res = exec_query($query);
$ip = "0.0.0.0";
$i = 0;
$str .= "<div class=\"all_clicks\">";
$str .= "<div class=\"click_row_title\">\n <div class=\"left click_date title\">Дата</div>\n <div class=\"left click_id title\">ID товара</div>\n <div class=\"left click_name title\">Наименование</div>\n <div class=\"left click_id title\">Цена</div>\n <div class=\"left click_name title\">Источник</div>\n " . closeFloat() . "\n </div>";
if (mysql_num_rows($res) == 0) {
$str .= "<div>За выбранную дату нажатий не было</div>";
} else {
while ($rows = fetch_array($res)) {
if ($ip != $rows['cip']) {
$ip = $rows['cip'];
if ($i != 0) {
$str .= "</div>";
}
$str .= "<div class=\"ipclicks\">";
$str .= "<div class=\"client_ip\">Клики с адреса:<b>" . $rows['cip'] . "</b></div>";
}
$str .= "<div class=\"click_row\">\n <div class=\"left click_date\">" . $rows['fdate'] . "</div>\n <div class=\"left click_id\">" . $rows['gid'] . "</div>\n <div class=\"left click_name\">" . $rows['sname'] . "</div>\n <div class=\"left click_id\">" . $rows['price'] . "</div>\n <div class=\"left click_name\">" . $rows['src'] . "</div>\n " . closeFloat() . "\n </div>";
}
$str .= "</div>";
}
$str .= "</div></div>";
mysql_free_result($res);
dbDisconnect($lnk);
return $str;
}
function main_form()
{
$str = "<div>\n <div class=\"menuitem left\"><a href=\"admin.php?mode=openord\">Открытые заявки</a></div>\n <div class=\"menuitem left\"><a href=\"admin.php?mode=allord\">Все заявки</a></div>\n <div class=\"menuitem left\"><a href=\"admin.php?mode=social\">Социал</a></div>\n <div class=\"menuitem left\"><a href=\"admin.php?mode=sql\">SQL</a></div>\n <div class=\"menuitem left\"><a href=\"admin.php?mode=links\">Links</a></div>\n " . closeFloat() . "\n </div>";
return $str;
}
