<?
chdir("../");
require_once('global.php');
require_once(DIR . '/includes/functions_user.php');
$myuname=$vbulletin->userinfo['username'];
include "includes/config.php";
chdir("rekap");
$ref="";
if (isset($_GET['id']))
  $id=$_GET['id'];
else{
if (isset($_SERVER['HTTP_REFERER'])){
 $ref=$_SERVER['HTTP_REFERER'];
 if (strstr($ref,"showthread.php?")!=""){
   $xthread=explode(".php?",$ref);
   $ythread=explode("-",$xthread[1]);
   $id=$ythread[0];
 }
}
}
if ($id=="")
  die();

$dtz=date_default_timezone_get();
date_default_timezone_set ("asia/jakarta");
$sdate=date('Y-m-d H:i:s');
date_default_timezone_set ($dtz);
$adate=date('Y-m-d H:i:s');
$timestamp1 = strtotime($sdate);
$timestamp2 = strtotime($adate);
$sel=abs($timestamp2 - $timestamp1)/(60*60);

$txt=file_get_contents("{$id}.txt");
$x=explode("\n",$txt);
$arr=explode("|",$x[0]);
$t=$arr[0];
$m=$arr[1];
$endt=$arr[2];
$closet=$arr[3];
$hadiah="";
if (isset($arr[4])){
  $hadiah=$arr[4];
  if ($hadiah!="hadiah")
	$hadiah="";
}
$max=0;
if (isset($arr[5]))
  $max=$arr[5];
$closetime=date('d M Y, H:i',strtotime($closet));
$xcloset=strtotime("-{$sel} hours +1 minutes",strtotime($closet));
$arritem=null;
$arrdata="";
for ($i=1;$i<sizeof($x);$i++){
  $arrdata.=$x[$i]."\n";
  $myitem=explode("=",$x[$i]);
  $xkode=explode("|",$myitem[1]);
  $kode=$xkode[0];
  $status="0";
  if (sizeof($xkode)>1){  
    $status=$xkode[1];
  }  
  $arritem[strtolower($kode)]=$myitem[0];
  $arritem["{$i}-status"]=$status;
  $arritem[$myitem[0]]=strtoupper($kode);
}
 $dbserver=$config['MasterServer']['servername'];
 $dbuser=$config['MasterServer']['username'];
 $dbpwd=$config['MasterServer']['password'];
 $dbname=$config['Database']['dbname'];
 $prefix=$config['Database']['tableprefix'];
 $dbconn=mysql_connect($dbserver,$dbuser,$dbpwd);
 if (!$dbconn) {
  die('Could not connect: ' . mysql_error());
 }
 mysql_set_charset("utf8");
 mysql_select_db($dbname) or die( "Unable to select database");
 $sql = "SELECT a.dateline,a.pagetext from `{$prefix}post` a left join {$prefix}thread b on a.threadid=b.threadid WHERE a.threadid=$id and a.pagetext like '%#bid %' and a.pagetext not like '%[QUOTE%'  and a.dateline<=$xcloset and a.visible=1 order by a.dateline desc limit 1";
 $myquery=mysql_query($sql);
 $totrec=mysql_num_rows($myquery);
 if ($totrec>0){
   $row=mysql_fetch_array($myquery);
   $dateline=$row['dateline'];
//   $dateline=strtotime("+4 hours",$dateline);
   $xpagetext=$row['pagetext'];
   $pagetext=str_replace("[","<",$xpagetext);
   $pagetext=str_replace("]",">",$pagetext);
   $oldtime=date('YmdHi',$dateline);
   $sisa=0;
   if (substr($oldtime,strlen($oldtime)-1,1)<=5){
     $oldt=substr($oldtime,strlen($oldtime)-1,1);
     $sisa=10-$oldt;
   }else{
     $oldt=substr($oldtime,strlen($oldtime)-1,1);
     $sisa=15-$oldt;
   }
   $mycloset=strtotime("+{$sisa}minutes",$dateline);
   $close1=date('YmdHi',$mycloset);
   $close2=date('YmdHi',$xcloset);
   if ($close1>$close2){
    $xcloset=$mycloset;
    $ycloset=date('YmdHi',strtotime("+{$sel} hours",$xcloset));
    $xhadiah="";
    if ($hadiah!=""){
      $xhadiah="|".$hadiah;
    }
    $wtxt="$t|$m|$endt|$ycloset$xhadiah\n$arrdata";
    $myfile = fopen("{$id}.txt", "w") or die("Unable to open file!");
    fwrite($myfile, $wtxt);
    fclose($myfile);
   }
 }
if (isset($_GET['d'])){
 $d=$_GET['d'];
 $id=$_GET['id'];
 $sql = "SELECT a.dateline,a.username,a.pagetext,b.title from `{$prefix}post` a left join {$prefix}thread b on a.threadid=b.threadid WHERE a.threadid=$id  and a.pagetext like '%#bid %' and a.dateline<=$xcloset and a.visible=1 order by a.dateline desc";
 $myquery=mysql_query($sql);
 $i=0;
 $tmpusername=$tmpprevbid="0";
 while ($row=mysql_fetch_array($myquery)){
   $title=$row['title'];
   $xpagetext=$row['pagetext'];
   $pagetext=str_replace("[","<",$xpagetext);
   $pagetext=str_replace("]",">",$pagetext);
   if (strstr(strtolower($pagetext),"<quote")!=""){
     $x=explode("/quote>",strtolower($pagetext));
     $pagetext=$x[1];
   } 
   $pagetext=strip_tags($pagetext,"");
   $username=$row['username'];
   $datetime=$row['dateline'];
   //$dateline=strtotime("+4 hours",$dateline);
   if (strstr(strtolower($pagetext),"#bid")!=""){
    $xpage=explode("#bid ",strtolower($pagetext));
    $tmpnoitem="";
    for ($j=1;$j<sizeof($xpage);$j++){
      $ypage=explode("=",trim($xpage[$j]));
      $noitem=$arritem[strtolower(trim($ypage[0]))];
      $totalbid=trim($ypage[1]);
      $xtotalbid=explode(" ",$totalbid);
      $xtotalbid=explode("\n",$xtotalbid[0]);
      $totalbid=trim($xtotalbid[0]);
      if (strstr(",".$tmpnoitem,",".$noitem.",")=="" || $tmpusername!=$username){
       if ($noitem==$d){
        if (is_numeric($noitem) && is_numeric($totalbid) && (substr($totalbid,strlen($totalbid)-2,2)=="00" || substr($totalbid,strlen($totalbid)-2,2)=="50") && $totalbid>=$m && ($totalbid<=$max || $max==0)){
         if (($tmpprevbid>$totalbid) || $i==0){
          $datetime=date('d/m/Y H:i',strtotime("+{$sel} hours",$datetime));
          $item[$noitem]['bid'][$i]=$totalbid;
          $item[$noitem]['username'][$i]=trim($username);
          $item[$noitem]['datetime'][$i]=$datetime;
          $tmpnoitem.=$noitem.",";
          $tmpprevbid=$totalbid;    
          $tmpusername=$username;
          $tmpdatetime=$datetime;
          $i++; 
         }else{
          $datetime=date('d/m/Y H:i',strtotime("+{$sel} hours",$datetime));
          $item[$noitem]['bid'][$i-1]=$totalbid;
          $item[$noitem]['username'][$i-1]=$username;
          $item[$noitem]['datetime'][$i-1]=$datetime;
          $tmpprevbid=$totalbid;    
          $tmpusername=$username;
         }
        }
       }
      }
    }
    $tmpusername=$username;
    $tmprevbid=$totalbid;
   }
 }
$info=$arritem[$d];
$output="<table width=400 cellpadding=2 cellspacing=1 border=0 bgcolor=\"#000000\">
 <tr bgcolor=\"#dddddd\"><td width=\"37%\" align=\"center\">Date/Time</td><td width=\"25%\" align=\"center\">History $info</td><td width=\"38%\" align=\"center\">User Name</td></tr>";
 $i=0;
 $tot=sizeof($item[$d]['bid']);
 for ($i=0;$i<$tot;$i++){
   $datetime=$item[$d]['datetime'][$i];
   $username=$item[$d]['username'][$i];
   $usernamenext=$item[$d]['username'][$i+1];
   if ($usernamenext!=$username){
    $bid=$item[$d]['bid'][$i]; 
    $bidno=number_format($bid,0);
    $output.="<tr bgcolor=\"#ffffff\"><td align=\"center\">$datetime</td><td align=\"center\">$bidno</td><td align=\"center\">$username</td></tr>"; 
   }
 }
 $output.="</table>";
}else{
if (isset($id)){
 mysql_select_db($dbname) or die( "Unable to select database");
 $sql = "SELECT a.username,b.title,a.pagetext from `{$prefix}post` a left join {$prefix}thread b on a.threadid=b.threadid WHERE a.threadid=$id  and a.pagetext like '%#bid %' and a.dateline<$xcloset and a.visible=1 order by a.dateline asc";
 $myquery=mysql_query($sql);
 $i=0;
 $tmpusername="";
while ($row=mysql_fetch_array($myquery)){
   $title=$row['title'];
   $xpagetext=$row['pagetext'];
   $username=$row['username'];
   $pagetext=str_replace("[","<",$xpagetext);
   $pagetext=str_replace("]",">",$pagetext);
   if (strstr(strtolower($pagetext),"<quote")!=""){
     $x=explode("/quote>",strtolower($pagetext));
     $pagetext=$x[1];
   } 
   $pagetext=strip_tags($pagetext,"");
   if (strstr(strtolower($pagetext),"#bid")!=""){
    $xpage=explode("#bid ",strtolower($pagetext));
    $tmpnoitem="";
    for ($j=1;$j<sizeof($xpage);$j++){
      $ypage=explode("=",trim($xpage[$j]));
      $noitem=$arritem[trim(strtolower($ypage[0]))];
      $totalbid=trim($ypage[1]);
      $totalbid=explode(" ",$totalbid);
      $totalbid=explode("\n",$totalbid[0]);
      $totalbid=trim($totalbid[0]);
      if (strstr(",".$tmpnoitem,",".$noitem.",")=="" || $tmpusername!=$username){
//       if ($totalbid>=$m && ($totalbit<=$max || $max==0) && $tmpusername!=$username."-".$noitem){
	if ($totalbid>=$m && ($totalbit<=$max || $max==0)){
        if (is_numeric($noitem) && is_numeric($totalbid) && (substr($totalbid,strlen($totalbid)-2,2)=="00" || substr($totalbid,strlen($totalbid)-2,2)=="50")){
         $item[$noitem]['bid'][$i]=$totalbid;
         $item[$noitem]['username'][$i]=trim($username);
         $tmpnoitem.=$noitem.",";
         $i++; 
        }
         $tmpusername=$username."-".$noitem;
       }
      }
    }
   }
 }
$mytitle="";$space="";
if ($ref==""){
  $mytitle= "<b><font size=4 family=\"verdana\">$title</font></b><br/><br/>";
  $space="<br/><br/>";
}
$output="$space<table width=730 class=\"bordertable\" cellpadding=0 cellspacing=0 border=0>
<tr>
<td colspan=2 align=\"center\">
<font size=4 family=\"verdana\"><b>KOI's Auto Rekap</b></font><br/>
$mytitle<br/>
</td>
</tr>
<tr>
<td valign=\"top\" width=380>
<center><b>REKAP (Klik Angka Untuk Melihat History Bid)</b></center><br/>
<table width=350 cellpadding=2 cellspacing=1 border=0 bgcolor=\"#000000\">
  <tr bgcolor=\"#dddddd\"><td width=\"25%\" align=\"center\">Item No</td><td width=\"30%\" align=\"center\">Highest Bid</td><td width=\"45%\" align=\"center\">User Name</td></tr>";
 $i=0;
 $isrc="";
 $totalhigh=0;
 for ($i=1;$i<=$t;$i++){
  $highestnumber=$username="";
  $status="";
  if (isset($item[$i]['bid'])){
   $highestbid=max($item[$i]['bid']);
   $totalhigh=$totalhigh+$highestbid;
   $maxid = array_keys($item[$i]['bid'], max($item[$i]['bid']));
   $username=$item[$i]['username'][$maxid[0]];
   $status=$arritem["{$i}-status"];
   $highestnumber=number_format($highestbid,0);
  }
  if ($i==1){
    $isrc="/rekap/?d=$i&id=$id";
  } 
  $statusval=$status;
  if ($statusval==1)
    $status=" <img src=\"images/iconijo.jpg\" border=0 width=15 height=10/>";
  elseif ($statusval==2)
    $status=" <img src=\"images/iconkirim.png\" border=0 width=15 height=10/>";
  elseif ($statusval==3)
    $status=" <img src=\"images/iconcancel.jpg\" border=0 width=15 height=10/>";
  else
    $status="";
  if (strtolower($myuname)=="griffin" || strtolower($myuname)=="yudihp" || strtolower($myuname)=="kc-bersama"){
    $updateitemval="<a href=\"javascript:\" onclick=\"updateitem($i,'{$arritem[$i]}',$statusval);\">$username$status</a>";
  }else{
    $updateitemval="$username$status";
  }
  $output.= "<tr bgcolor=\"#ffffff\"><td align=\"center\">{$arritem[$i]}</td><td align=\"center\"><a href=\"/rekap/?d=$i&id=$id\" target=\"target\">$highestnumber</a></td><td align=\"center\">$updateitemval</td></tr>"; 
 }
 $total="";
 $totalhigh=$totalhigh."000";  
 $txthadiah="";
 if ($hadiah=="hadiah"){
   $totalgrand=number_format(($totalhigh*8)/100,0,",",".");
   $totalgrandreserve=number_format(($totalhigh*6)/100,0,",",".");
   $totalrankone=number_format(($totalhigh*3)/100,0,",",".");
   $txthadiah="<div class=\"hadiah\"><h2>Total Hadiah</h2>
   <table width=100% cellpadding=2 cellspacing=2><tr><td align=\"center\"><b>Grand Champion</b></td><td align=\"center\"><b>Reserve Grand Champion</b></td><td align=\"center\"><b>Juara 1</b></td></tr>
   <tr><td align=\"center\">Rp $totalgrand</td><td align=\"center\">Rp $totalgrandreserve</td><td align=\"center\">Rp $totalrankone</td></tr>
   </table>	
   </div>";
 }
 $totalhigh=number_format($totalhigh,0,",",".");
 $total="$txthadiah<div class=\"info\"><span>End Time: $closetime WSK</span><span><b>Total Bid: Rp $totalhigh</b></span></div>";
 $output.= "</table><br/><br/></td><td width=450 valign=\"top\" height=100% style=\"position:relative;\"><center><b>HISTORY</b></center><Br/>$total<iframe src=\"$isrc\" name=\"target\" width=450 height=142 scrollbars=\"auto\" frameborder=0></td></tr></table><br/><br/><br/><br/>";
}
}
 mysql_close();
?>
<head>
<title>AUTO REKAP BID SYSTEM</title>
</head>
<style>
body{
 font-size:12px;font-family:verdana;margin-top:0px;margin-left:0px;
}
.hadiah {
    position: absolute;
    bottom: 130px;
    text-align:center;
    width: 90%;
    right: 20px;
    border: 1px solid #ccc;
    padding-bottom: 15px;
}
.hadiah h2{
    font-size:16px;
}
.info {
    position: absolute;
    bottom: 30px;
    width: 90%;
    text-align: center;
    font-size: 16px;
    right: 20px;
    border: 1px solid #ccc;
}
.info span{
    display:block;
    line-height:40px;
}
table tr td{
 font-size:12px;font-family:verdana;
}
input{
 font-size:12px;font-family:verdana;
}
table.bordertable {
    border: 1px solid #bbb;
    padding: 30px 5px 0px 30px;
}
a{
  color:#0000EE;text-decoration:none;font-weight:bold;
}
a:hover{
  color:#0000EE;text-decoration:underline;
}
.mypop {
    position: absolute;
    top: 50%;
    left: 25%;
    background-color: #f1f1f1;
    padding: 15px;
    border: 1px solid #ccc;
}
</style>
<body>
<script>
function closepop(){
  document.getElementById('pop').innerHTML='';
}
function doupdate(id){
  var status=document.getElementById('status').value;
  var xhttp = new XMLHttpRequest();
  xhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
       location.reload();
    }
  };
  xhttp.open("GET", "doupdate.php?status="+status+"&tid=&id="+id, true);
  xhttp.send();
}
</script>
<div id="pop"></div>
<script>
function updateitem(id,item,sel){
  var sel1='',sel2='',sel3='',sel4='';
  if (sel==0)
    sel1=' selected';
  else if (sel==1)
    sel2=' selected';
  else if (sel==2)
    sel3=' selected';
  else if (sel==3)
    sel4=' selected';
  var mypop="<div class=\"mypop\"><table width=200 cellpadding=3 cellspacing=2><tr><td>Item:</td><td>"+item+"</td></tr><tr><td>Status :</td><td><select id=\"status\"><option value=\"\""+sel1+">N/A</option><option value=\"1\""+sel2+">Paid</option><option value=\"2\""+sel3+">Paid & Delivered</option><option value=\"3\""+sel4+">Cancel</option></select></td></tr><tr><td colspan=2 align=\"center\"><button onclick=\"doupdate("+id+");\">Update</button> <button onclick=\"closepop();\">Cancel</button></td></tr></table></div>";
  document.getElementById('pop').innerHTML=mypop;
}
</script>
<center>
</center>
</body></html>