Index: trunk/kernel/units/visits/visits_event_handler.php
===================================================================
diff -u -N -r2402 -r2407
--- trunk/kernel/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2402)
+++ trunk/kernel/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2407)
@@ -20,7 +20,19 @@
$this->Application->SetVar('visits_id', $object->GetID() );
}
}
+
+ /**
+ * Search
+ *
+ * @param kEvent $event
+ */
+ function OnSearch(&$event){
+ parent::OnSearch($event);
+
+
+ }
+
}
Index: trunk/kernel/admin_templates/visits/visits_list.tpl
===================================================================
diff -u -N -r2406 -r2407
--- trunk/kernel/admin_templates/visits/visits_list.tpl (.../visits_list.tpl) (revision 2406)
+++ trunk/kernel/admin_templates/visits/visits_list.tpl (.../visits_list.tpl) (revision 2407)
@@ -55,8 +55,10 @@
+
+
-
+
">
: |
@@ -87,8 +89,6 @@
-
-
Index: trunk/core/units/visits/visits_event_handler.php
===================================================================
diff -u -N -r2402 -r2407
--- trunk/core/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2402)
+++ trunk/core/units/visits/visits_event_handler.php (.../visits_event_handler.php) (revision 2407)
@@ -20,7 +20,19 @@
$this->Application->SetVar('visits_id', $object->GetID() );
}
}
+
+ /**
+ * Search
+ *
+ * @param kEvent $event
+ */
+ function OnSearch(&$event){
+ parent::OnSearch($event);
+
+
+ }
+
}
Index: trunk/core/units/visits/visits_config.php
===================================================================
diff -u -N -r2406 -r2407
--- trunk/core/units/visits/visits_config.php (.../visits_config.php) (revision 2406)
+++ trunk/core/units/visits/visits_config.php (.../visits_config.php) (revision 2407)
@@ -28,20 +28,27 @@
'UserName' => 'IF( ISNULL(u.Login), IF (%1$s.PortalUserId = -1, \'root\', IF (%1$s.PortalUserId = -2, \'Guest\', \'n/a\')), u.Login)',
'AffiliateUser' => 'IF( LENGTH(au.Login),au.Login,\'!la_None!\')',
'AffiliatePortalUserId' => 'af.PortalUserId',
+ 'OrderTotalAmount' => '(ord.SubTotal+ord.ShippingCost+ord.VAT-ord.CouponDiscount)',
+ 'OrderAffiliateCommission' => 'ord.AffiliateCommission',
),
),
'ListSQLs' => Array( ''=>' SELECT %1$s.* %2$s
FROM %1$s
LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId
LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
- LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId'),
+ LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId
+ LEFT JOIN '.TABLE_PREFIX.'Orders ord ON %1$s.VisitId = ord.VisitId
+ '),
+
'ItemSQLs' => Array( ''=>' SELECT %1$s.* %2$s
FROM %1$s
LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId
LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
- LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId'),
+ LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId
+ LEFT JOIN '.TABLE_PREFIX.'Orders ord ON %1$s.VisitId = ord.VisitId
+ '),
'ListSortings' => Array(
'' => Array(
@@ -62,6 +69,8 @@
'UserName' => Array('type'=>'string'),
'AffiliateUser' => Array('type'=>'string'),
'AffiliatePortalUserId' => Array('type'=>'int'),
+ 'OrderTotalAmount' => Array('type' => 'float', 'formatter'=>'kFormatter', 'format'=>'%01.2f', 'not_null' => '1','default' => '0.00'),
+ 'OrderAffiliateCommission' => Array('type' => 'numeric', 'formatter'=>'kFormatter','format'=>'%.02f', 'not_null' => '1','default' => '0.0000'),
),
'Grids' => Array(
@@ -73,6 +82,8 @@
'Referer' => Array( 'title'=>'la_col_Referer', 'data_block' => 'grid_referer_td' ),
'UserName' => Array('title' => 'la_col_Username', 'data_block' => 'grid_userlink_td', 'user_field' => 'PortalUserId'),
'AffiliateUser' => Array( 'title' => 'la_col_AffiliateUser', 'data_block' => 'grid_userlink_td', 'user_field' => 'AffiliatePortalUserId'),
+ 'OrderTotalAmount' => Array( 'title' => 'la_col_OrderTotal'),
+ 'OrderAffiliateCommission' => Array( 'title' => 'la_col_Commission'),
),
),
),
Index: trunk/kernel/units/visits/visits_config.php
===================================================================
diff -u -N -r2406 -r2407
--- trunk/kernel/units/visits/visits_config.php (.../visits_config.php) (revision 2406)
+++ trunk/kernel/units/visits/visits_config.php (.../visits_config.php) (revision 2407)
@@ -28,20 +28,27 @@
'UserName' => 'IF( ISNULL(u.Login), IF (%1$s.PortalUserId = -1, \'root\', IF (%1$s.PortalUserId = -2, \'Guest\', \'n/a\')), u.Login)',
'AffiliateUser' => 'IF( LENGTH(au.Login),au.Login,\'!la_None!\')',
'AffiliatePortalUserId' => 'af.PortalUserId',
+ 'OrderTotalAmount' => '(ord.SubTotal+ord.ShippingCost+ord.VAT-ord.CouponDiscount)',
+ 'OrderAffiliateCommission' => 'ord.AffiliateCommission',
),
),
'ListSQLs' => Array( ''=>' SELECT %1$s.* %2$s
FROM %1$s
LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId
LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
- LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId'),
+ LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId
+ LEFT JOIN '.TABLE_PREFIX.'Orders ord ON %1$s.VisitId = ord.VisitId
+ '),
+
'ItemSQLs' => Array( ''=>' SELECT %1$s.* %2$s
FROM %1$s
LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId
LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
- LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId'),
+ LEFT JOIN '.TABLE_PREFIX.'PortalUser au ON af.PortalUserId = au.PortalUserId
+ LEFT JOIN '.TABLE_PREFIX.'Orders ord ON %1$s.VisitId = ord.VisitId
+ '),
'ListSortings' => Array(
'' => Array(
@@ -62,6 +69,8 @@
'UserName' => Array('type'=>'string'),
'AffiliateUser' => Array('type'=>'string'),
'AffiliatePortalUserId' => Array('type'=>'int'),
+ 'OrderTotalAmount' => Array('type' => 'float', 'formatter'=>'kFormatter', 'format'=>'%01.2f', 'not_null' => '1','default' => '0.00'),
+ 'OrderAffiliateCommission' => Array('type' => 'numeric', 'formatter'=>'kFormatter','format'=>'%.02f', 'not_null' => '1','default' => '0.0000'),
),
'Grids' => Array(
@@ -73,6 +82,8 @@
'Referer' => Array( 'title'=>'la_col_Referer', 'data_block' => 'grid_referer_td' ),
'UserName' => Array('title' => 'la_col_Username', 'data_block' => 'grid_userlink_td', 'user_field' => 'PortalUserId'),
'AffiliateUser' => Array( 'title' => 'la_col_AffiliateUser', 'data_block' => 'grid_userlink_td', 'user_field' => 'AffiliatePortalUserId'),
+ 'OrderTotalAmount' => Array( 'title' => 'la_col_OrderTotal'),
+ 'OrderAffiliateCommission' => Array( 'title' => 'la_col_Commission'),
),
),
),
Index: trunk/kernel/units/visits/visits_tag_processor.php
===================================================================
diff -u -N -r2392 -r2407
--- trunk/kernel/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2392)
+++ trunk/kernel/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2407)
@@ -21,6 +21,16 @@
return 'javascript:OpenUserEdit('.$resource_id.');';
}
}
+ /*
+ function GetDate($params){
+ $get_search_from = $this->Application->GetVar('search_date_from');
+ $from_date = $get_search_from?$get_search_from:$this->Application->RecallVar($this->Prefix.'_search_date_from');
+ $get_search_to = $this->Application->GetVar('search_date_to');
+ $to_date = $get_search_to?$get_search_to:$this->Application->RecallVar($this->Prefix.'_search_date_to');
+ if ($params['date_type'] == 'from') return $from_date;
+ if ($params['date_type'] == 'to') return $to_date;
+ }
+ */
}
?>
\ No newline at end of file
Index: trunk/core/units/visits/visits_tag_processor.php
===================================================================
diff -u -N -r2392 -r2407
--- trunk/core/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2392)
+++ trunk/core/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2407)
@@ -21,6 +21,16 @@
return 'javascript:OpenUserEdit('.$resource_id.');';
}
}
+ /*
+ function GetDate($params){
+ $get_search_from = $this->Application->GetVar('search_date_from');
+ $from_date = $get_search_from?$get_search_from:$this->Application->RecallVar($this->Prefix.'_search_date_from');
+ $get_search_to = $this->Application->GetVar('search_date_to');
+ $to_date = $get_search_to?$get_search_to:$this->Application->RecallVar($this->Prefix.'_search_date_to');
+ if ($params['date_type'] == 'from') return $from_date;
+ if ($params['date_type'] == 'to') return $to_date;
+ }
+ */
}
?>
\ No newline at end of file
Index: trunk/core/admin_templates/logs/visits/visits_list.tpl
===================================================================
diff -u -N -r2406 -r2407
--- trunk/core/admin_templates/logs/visits/visits_list.tpl (.../visits_list.tpl) (revision 2406)
+++ trunk/core/admin_templates/logs/visits/visits_list.tpl (.../visits_list.tpl) (revision 2407)
@@ -55,8 +55,10 @@
+
+
-
+
">
: |
@@ -87,8 +89,6 @@
-
-