<?
//error_reporting(E_ALL); 
error_reporting(E_ERROR); 
ini_set('memory_limit','100M');
ini_set('display_errors', 1);
$base = '/usr/local/apache/htdocs/report/';
$base_new = '/usr/local/apache/htdocs/report/';

require($base.'db_conn.php');

//$host = "edu.l9global.com";
//$db_id = "root";
//$db_pw = "time2013";
//$db_name="snade";
//$connect = mysql_connect($host, $db_id, $db_passwd) or die (mysql_error());
//   mysql_select_db("snade", $connect) or die (mysql_error());
//echo $connect."\n";
//exit;


require($base_new.'reports/proc/MagReport.class.php');
require($base_new.'reports/proc/MagDate.class.php');

$MagDate = new MagDateClass();
$MagRObject = new MagReportClass($connect);

if ($argc < 3) {
	echo "usage : proc_report.php date=[2017-01-01] opt=[d, w, m]\n";
	echo "        date=pre : 전날 날짜로 처리한다.\n";
	exit;
}
if ($argv[2] != "d" && $argv[2] != "w" && $argv[2] != "m" ) {
	echo "option = d(day), w(week), m(month)\nretry..\n";
	exit;
} 
$opt = $argv[2];

// 입력된 날짜 전날을 기준으로 해서 하고,
// week, month는 입력한 날짜 기준으로 그 전 주, 그 전 달로 계산해서 작업한다.

$curdate = array();
if ($argv[1] == "pre") {
	if ($opt=="d") {
		$curdate['sdate'] = date("Y-m-d",strtotime("-1 day"));
		$curdate['edate'] = $curdate['sdate'];
	}
	else if ($opt == "w") { 
		$curdate = $MagDate->GetDatePrevWeek("");
	}
	else {  // month
		$curdate = $MagDate->GetDatePrevMonth("");
	}
}
else {
	if ($opt == "d") {
		$curdate['sdate'] = $argv[1];	
		$curdate['edate'] = $curdate['sdate'];
	}
	else if ($opt == "w") {
		$curdate = $MagDate->GetDateCurWeek($argv[1]);
	}
	else { // month
		$curdate = $MagDate->GetDateCurMonth($argv[1]);
	}
}


if ($opt == "d") {
	//전체 정보 일자별..
	echo "processing Total Info ".$curdate['sdate']."\n";
	$MagRObject->InsertDBTotalInfoDay($curdate['sdate']);
	//전체 정보 일자별 서버별
	echo "processing Total Server Info ".$curdate['sdate']."\n";
	$MagRObject->InsertDBTotalInfoDayServer($curdate['sdate']);

	echo "processing transaction hour Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
	$MagRObject->InsertDBTotalInfoHour($curdate['sdate']);
}
else {
	echo "processing Total Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
	$MagRObject->InsertDBTotalInfoWM($curdate, $opt);
	echo "processing Total Server Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
	$MagRObject->InsertDBTotalInfoServerWM($curdate, $opt);
}

echo "processing Total App Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBAppInfoServer($curdate, $opt);
echo "processing Total Referer Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBRefererInfoServer($curdate, $opt);
echo "processing Total Country Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBCountryInfo($curdate, $opt);
echo "processing Total Region Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBRegionInfo($curdate, $opt);
echo "processing Total ISP Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBISPInfo($curdate, $opt);
echo "processing Total OS Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBOSInfo($curdate, $opt);
echo "processing Total Browser Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBBrowserInfo($curdate, $opt);
echo "processing Total Cleint Info ".$curdate['sdate']."~".$curdate['edate']." : $opt\n";
$MagRObject->InsertDBUserInfo($curdate, $opt);
$MagRObject->InsertDBMobileInfo($curdate, $opt);

unset($MagDate);
unset($MagRObject);

?>