Login or Register to use this function";
$redirect_url = "m_earning.php";
include("checksec.php");
$template->set_filenames(array("body" => "m_earning.html"));
include_once ("class/orders.class.php");
$orders = new Orders();
//Phan trang
$paid = isset($_REQUEST["paid"])?$_REQUEST["paid"]:"";
$sortcriteria = isset($_REQUEST["sortcriteria"])?$_REQUEST["sortcriteria"]:1;
$n = $orders->GetTotalOrderOfMem($_SESSION["suserid"],$paid);
$maxpage = floor($n/$pagesize) == ceil($n/$pagesize)?floor($n/$pagesize)-1:floor($n/$pagesize);
if ($maxpage>0)
{
$minp = ($page>=$pagerange)?$page-$pagerange:0;
$maxp = $maxpage>$minp+$pagerange*2?$minp+$pagerange*2:$maxpage;
if ($minp>0)
$page_list = "« Previous - ";
$page_list .= "Page ";
for ($i=$minp; $i<=$maxp; $i++)
{
$j = $i+1;
$page_list .= ($i==$page)?"$j ":"".$j." ";
}
if ($maxpage>$maxp)
{
$maxp ++;
$page_list .= "- Next » ";
}
}
$page = isset($_REQUEST["page"])?$_REQUEST["page"]:0;
switch ($sortcriteria)
{
case 1:
$orderby = "`o_id` DESC";
break;
case 2:
$orderby = "`o_id` ASC";
break;
case 3:
$orderby = "`buyer_name` DESC";
break;
case 4:
$orderby = "`buyer_name` ASC";
break;
case 5:
$orderby = "`photo_title` DESC";
break;
case 6:
$orderby = "`photo_title` ASC";
break;
case 7:
$orderby = "`price` DESC";
break;
case 8:
$orderby = "`price` ASC";
break;
}
$result = $orders->GetOrdersOfMem($page*$pagesize, $pagesize, $_SESSION["suserid"], $paid, $orderby);
if (mysql_num_rows($result)>0)
{
$stt = $page*$pagesize;
while ($row = mysql_fetch_array($result))
{
$template->assign_block_vars("order_list",array(
"STT" => ++$stt,
"PHOTO_SID" => $row["photo"],
"PHOTO_TITLE" => $row["photo_title"],
"BUYER" => $row["buyer"],
"BUYER_NAME" => $row["buyer_name"],
"DATE" => $row["date"],
'PRICE' => $row['price'],
'LAST_PRICE' => $row['last_price'],
'DISCOUNT' => trim($row['discount']) != "FREE DOWNLOAD"?"":$row['discount'],
'ADMIN_PAID' => $row['admin_paid'],
'PAID2DESIGNER' => $row["paid2designer"]
));
}
}else
$page_list = "No order found.
";
$static = mysql_fetch_array($orders->StaticByUser($_SESSION["suserid"]));
include_once ("class/members.class.php");
$mem = new Members();
$mem_info = mysql_fetch_array($mem->GetBySId($_SESSION["suserid"]));
$template->assign_vars(array(
"TOTAL_DOWNLOADS" => $static["total_downloads"],
"FREE_DOWNLOADS" => $orders->SumFreeDownByUser($_SESSION["suserid"]),
"TOTAL_EARNING" => $static["total_earning"],
"PAID_EARNING" => $orders->SumPaidByUser($_SESSION["suserid"]),
"PAID0" => $paid=="UNPAID"?" selected='selected'":"",
"PAID1" => $paid=="PAID"?" selected='selected'":"",
"PAID2" => $paid=="FREE"?" selected='selected'":"",
"SORTCRITERIA1" => $orderby==1?" selected='selected'":"",
"SORTCRITERIA2" => $orderby==2?" selected='selected'":"",
"SORTCRITERIA3" => $orderby==3?" selected='selected'":"",
"SORTCRITERIA4" => $orderby==4?" selected='selected'":"",
"SORTCRITERIA5" => $orderby==5?" selected='selected'":"",
"SORTCRITERIA6" => $orderby==6?" selected='selected'":"",
"SORTCRITERIA7" => $orderby==7?" selected='selected'":"",
"SORTCRITERIA8" => $orderby==8?" selected='selected'":"",
"PAGE_LIST" => $page_list
));
$template->pparse("body");
include("footer.php");
?>