$WatchActionItems[] = $Row;
}
$WatchSaleItems = array();
$SaleItemsWhere = "";
if (!$nsUser->ADMIN) {
$SaleItemsWhere = " AND SI.COMPANY_ID=" . $CurrentCompany->ID;
}
$Query = "\n\t\tSELECT\n\t\t\tSI.*\n\t\t\tFROM " . PFX . "_tracker_watch W\n\t\t\tINNER JOIN " . PFX . "_tracker_sale_item SI\n\t\t\t\tON SI.ID=W.SALE_ITEM_ID\n\t\tWHERE W.USER_ID=" . $nsUser->UserId() . " {$SaleItemsWhere}\n\t";
$Sql = new Query($Query);
$Sql->ReadSkinConfig();
while ($Row = $Sql->Row()) {
$Row->_STYLE = $Sql->_STYLE;
$Query = "\n\t\t\tSELECT\n\t\t\tUNIX_TIMESTAMP(DATE_ADD(S_LOG.STAMP, INTERVAL '" . $nsUser->TZ . "' HOUR))\n\t\t\tFROM " . PFX . "_tracker_" . $Row->COMPANY_ID . "_stat_log S_LOG\n\t\t\tINNER JOIN " . PFX . "_tracker_" . $Row->COMPANY_ID . "_stat_sale S_SALE\n\t\t\t\t ON S_SALE.LOG_ID=S_LOG.ID\n\t\t\tINNER JOIN " . PFX . "_tracker_sale_set SS\n\t\t\t\tON SS.SALE_ID=S_SALE.ID\n\t\t\tINNER JOIN " . PFX . "_tracker_sale_item SI\n\t\t\t\tON SI.ID=SS.ITEM_ID\n\t\t\tWHERE SI.ID=" . $Row->ID . " {$SaleItemsWhere}\n\t\t\tORDER BY S_LOG.STAMP DESC\n\t\t\tLIMIT 1\n\t\t";
$Row->LAST_STAMP = $Db->ReturnValue($Query);
if ($Row->LAST_STAMP) {
$Row->DATE_DIFF_NAME = LastStamp($Row->LAST_STAMP);
}
$Row->DATE_DIFF = $DATE_DIFF;
$WatchSaleItems[] = $Row;
}
include $nsTemplate->Inc("admin.my_tracker");
}
$NoAdd = true;
/////////////////////////////////////
if ($Mode == "visitors") {
$ProgPath[1]['Name'] = $Lang['Visitors'];
$ProgPath[1]['Url'] = $nsProduct->SelfAction("Mode={$Mode}");
$VisitorsWhere = "";
if (!$nsUser->ADMIN) {
$VisitorsWhere = "WHERE CV.COMPANY_ID=" . $CurrentCompany->ID;
}
$Row->NewRef = true;
}
if ($PrevDays != $Row->DAYS) {
$Row->NewDay = true;
}
if (!isset($VPath[$Row->VISITOR_ID])) {
$Row->NewVis = true;
}
$Row->Time = date("H:i:s", $Row->STAMP);
$Row->Date = date("d.m", $Row->STAMP);
$Row->Year = date("Y", $Row->STAMP);
if (date("Y-m-d", $Row->STAMP) == date("Y-m-d", $Row->FIRST_STAMP)) {
$Row->FIRST_STAMP = false;
}
if ($Row->FIRST_STAMP) {
$Row->FIRST_STAMP_NAME = LastStamp($Row->FIRST_STAMP);
}
if ($Row->CUSTOM_ORDER_ID) {
$Row->ORDER_ID = $Row->CUSTOM_ORDER_ID;
}
if ($Row->NewVis && !$Filter && !$VisId) {
$Row->TotalTime = ValidVar($VisTime[$Row->VISITOR_ID]);
if ($Row->TotalTime > 0) {
$Row->TotalTime = round($Row->TotalTime / 60);
if ($Row->TotalTime >= 60) {
$Row->Hours = round($Row->TotalTime / 60);
$Row->Minutes = round($Row->TotalTime % 60);
} else {
$Row->Minutes = $Row->TotalTime;
}
}
