<?php 
//*****************************************************************************
//* 
//* プログラム名：営業日報
//* プログラムID：RPT002.php
//* 機能        ：営業日報検索画面
//* 作成者      ：
//* 
//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
$strDBinc="include/dbcon.inc";
include($strDBinc);

$strSQLtori="";
$objRectori="null";
$strSQL="";
$objRec="null";

$strSyain="";
$objRecSyain="null";

if (empty($serch_Flg)){
	$serch_Flg=0;
}
if (empty($intPage)){
	$intPage=0;
}


//取引先情報取得
$strSQLtori="SELECT seq,tori_name FROM torihiki_TBL Where del_flg=true ";
$objRectori = pg_exec($strSQLtori);
if($objRectori==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
//取引先グループ情報取得
$strSQLtori_group="SELECT  group_seq,group_name FROM torihiki_group_tbl Order by disp_rank ";
$objRectori_group = pg_exec($strSQLtori_group);
if($objRectori_group==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//訪問者情報取得
$strSQLSyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl  Where del_flg=true Order by disp_rank";
$objRecSyain = pg_exec($strSQLSyain);
if($objRecSyain==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

if (empty($intPage)){
	$intPage=0;
}

if ($serch_Flg!=0){
	//日付検索
	if ($start_y !="00" && $start_m != "00" && $start_d !="00" && $end_y != "00" && $end_m != "00" && $end_d != "00" ){
		$strDateJoken=" and (date between '" . $start_y ."/" . $start_m ."/". $start_d ."' and '" . $end_y ."/" . $end_m ."/". $end_d . "')";
	}

	//グループ
	if($chk_tori==0 && $Customer_group !=""){
		//取引先情報取得
		$strSQLtori="SELECT tori_name,tori_group FROM torihiki_tbl  Where tori_group=".$Customer_group;
		$objRectori = pg_exec($strSQLtori);
		if($objRectori==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		
		if (0 < pg_numrows($objRectori)){
			for ($inttori=0; $inttori < pg_numrows($objRectori); $inttori++){
				$objtori = pg_fetch_object($objRectori, $inttori);
				if($inttori==0){
					$strGroupJoken=" and (tori_name='".$objtori->tori_name."'";
				}else{
					$strGroupJoken=$strGroupJoken." or tori_name='".$objtori->tori_name."'";
				}
			}
			$strGroupJoken=$strGroupJoken.")";
		}else{
			$strGroupJoken=" and (tori_name='".$objtori->tori_name."')";
		}
	}
	//取引先
	if($chk_tori==1 && $Customer !=""){
		$strtoriJoken=" and (tori_name like '%".$Customer."%')";
	}

	//取引入力
	if($chk_tori==2 && $Visit_input !=""){
		$strInputJoken=" and (tori_name like '%".$Visit_input."%')";
	}

	//訪問者選択
	if($Caller != ""){
		$strCallerJoken=" and (syain_list like '%/".$Caller."/%')";
	}
	
	//日付条件
	if($strDateJoken !=""){
		$strJoken=$strDateJoken;
	}

	//取引先選択条件
	if($strJoken != "" && $strtoriJoken != ""){
		$strJoken= $strJoken." ".$strtoriJoken;
	}elseif($strJoken=="" && $strtoriJoken != ""){
		$strJoken=$strtoriJoken;
	}

	//取引先入力
	if($strJoken != "" && $strInputJoken != ""){
		$strJoken= $strJoken." ".$strInputJoken;
	}elseif($strJoken=="" && $strInputJoken != ""){
		$strJoken=$strInputJoken;
	}

	//取引先グループ条件
	if($strJoken != "" && $strGroupJoken != ""){
		$strJoken= $strJoken."  ".$strGroupJoken;
	}elseif($strJoken=="" && $strGroupJoken != ""){
		$strJoken=$strGroupJoken;
	}

	//訪問者条件
	if($strJoken != "" && $strCallerJoken != ""){
		$strJoken= $strJoken." ".$strCallerJoken;
	}elseif($strJoken=="" && $strCallerJoken != ""){
		$strJoken=$strCallerJoken;
	}

	//営業日報情報取得
	$strSQL="SELECT read_flg,eigyo_memo_tbl.seq,date,time,time_e,tori_code,tori_name,charge,eigyo_memo_tbl.syain_cd,syain_list,visit_purpose,memo,subject,bikou " .
				"FROM eigyo_memo_tbl,peigyou_tbl Where (peigyou_tbl.syain_cd='$PHP_SYAIN_CD' and eigyo_memo_tbl.seq = peigyou_tbl.seq ) ".$strJoken.
				" Order by read_flg,date DESC,time DESC,eigyo_memo_tbl.seq DESC ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
}

//開始年
$sel_start_y = "<OPTION value='00' ";
if ($start_y == "00"){ 
	$sel_start_y .= "selected";
}

$sel_start_y .= ">--</OPTION>";
for ($i=Date("Y")-5;$i<=Date("Y")+1;$i++) {
	$sel_start_y .= "<OPTION value='".$i."' "; 
	if ($start_y == $i){
		$sel_start_y .= "selected";
	}
	$sel_start_y .= ">".$i."年</OPTION>";		
}
//開始月
$sel_start_m = "<OPTION value='00' ";
if ($start_m == "00"){
	$sel_start_m .= "selected";
}
$sel_start_m .= ">--</OPTION>";
for ($i=1;$i<=12;$i++) {
	$sel_start_m .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($start_m == sprintf('%02d', $i)){
		$sel_start_m .= "selected";
	}
	$sel_start_m .= ">".$i."月</OPTION>";
}
//開始日
$sel_start_d = "<OPTION value='00' ";
if ($start_d == "00"){
	$sel_start_d .= "selected";
}
$sel_start_d .= ">--</OPTION>";
for ($i=1;$i<=31;$i++) {
	$sel_start_d .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($start_d == sprintf('%02d', $i)){
		$sel_start_d .= "selected";
	}
	$sel_start_d .= ">".$i."日</OPTION>";
}
//終了年
$sel_end_y = "<OPTION value='00' ";
if ($end_y == "00"){ 
	$sel_end_y .= "selected";
}
$sel_end_y .= ">--</OPTION>";
for ($i=Date("Y")-5;$i<=Date("Y")+1;$i++) {
	$sel_end_y .= "<OPTION value='".$i."' "; 
	if ($end_y == $i){
		$sel_end_y .= "selected";
	}
	$sel_end_y .= ">".$i."年</OPTION>";		
}
//終了月
$sel_end_m = "<OPTION value='00' ";
if ($end_m == "00"){
	$sel_end_m .= "selected";
}
$sel_end_m .= ">--</OPTION>";
for ($i=1;$i<=12;$i++) {
	$sel_end_m .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($end_m == sprintf('%02d', $i)){
		$sel_end_m .= "selected";
	}
	$sel_end_m .= ">".$i."月</OPTION>";
}
//終了日
$sel_end_d = "<OPTION value='00' ";
if ($end_d == "00"){
	$sel_end_d .= "selected";
}
$sel_end_d .= ">--</OPTION>";
for ($i=1;$i<=31;$i++) {
	$sel_end_d .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($end_d == sprintf('%02d', $i)){
		$sel_end_d .= "selected";
	}
	$sel_end_d .= ">".$i."日</OPTION>";
}

if ($chk_tori==0){
	$chk_tori_chk[0] = "checked"; 
}elseif ($chk_tori==1){
	$chk_tori_chk[1] = "checked"; 
}elseif ($chk_tori==2){
	$chk_tori_chk[2] = "checked"; 
}

for ($intCnt = 0; $intCnt < pg_numrows($objRectori_group); $intCnt++) {
	$objtori_group = pg_fetch_object($objRectori_group, $intCnt);
	$sel_group_name .= "<OPTION value='".($objtori_group->group_seq)."'" ;
	if($Customer_group==$objtori_group->group_seq && $chk_tori==0){ 
		$sel_group_name .= " selected"; 
	} 
	$sel_group_name .= "><span class='Normalfont'>".($objtori_group->group_name)."</span></OPTION>";
}

for ($intCnt = 0; $intCnt < pg_numrows($objRectori); $intCnt++) {
	$objtorihiki = pg_fetch_object($objRectori, $intCnt);
	$sel_tori_name .= "<OPTION value='".($objtorihiki->tori_name)."' ";
	if($Customer==$objtorihiki->tori_name && $chk_tori==1){ 
		$sel_tori_name .= "selected";
	}
	$sel_tori_name .= "><span class='Normalfont'>".($objtorihiki->tori_name)."</span></OPTION>";
}
if ($chk_tori ==2){
	$Visit_input_value = $Visit_input;
}
for ($intCnt = 0; $intCnt < pg_numrows($objRecSyain); $intCnt++) {
	$objSyain = pg_fetch_object($objRecSyain, $intCnt);
	$sel_name_kj .= "<OPTION value='".($objSyain->syain_cd)."' ";
	if($Caller==$objSyain->syain_cd){
		$sel_name_kj .= "selected";
	} 
	$sel_name_kj .= "><span class='Normalfont'>".($objSyain->name_kj_sei.$objSyain->name_kj_mei)."</span></OPTION>";
}


$o_smarty->assign('sel_start_y',$sel_start_y);
$o_smarty->assign('sel_start_m',$sel_start_m);
$o_smarty->assign('sel_start_d',$sel_start_d);
$o_smarty->assign('sel_end_y',$sel_end_y);
$o_smarty->assign('sel_end_m',$sel_end_m);
$o_smarty->assign('sel_end_d',$sel_end_d);

$o_smarty->assign('sel_group_name',$sel_group_name);
$o_smarty->assign('chk_tori_chk',$chk_tori_chk);
$o_smarty->assign('sel_tori_name',$sel_tori_name);
$o_smarty->assign('Visit_input_value',$Visit_input_value);
$o_smarty->assign('sel_name_kj',$sel_name_kj);

$o_smarty->display('RPT002.tpl');
?>