package CMS;

import java.io.*;
import java.sql.*;
import java.text.DecimalFormat;

import javax.servlet.*;
import javax.servlet.http.*;

import com.cgrip.codaweb.deve.*;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Iterator;
import java.util.TreeSet;
import CMS.PjUnion;

public class NewsEntrysv extends HttpServlet
{
	//**********************************************************************
	//  データベース初期化
	//**********************************************************************
	public void init(ServletConfig config) throws ServletException
	{
		CodawLib Cwlib = new CodawLib();
		PjUnion Pjuni = new PjUnion();
		Cwlib.init(config);
		super.init(config);
	}
	//**********************************************************************
	//  doGet HTTP出力処理
	//**********************************************************************
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		//==============================
		//  共通ルーチン初期設定
		//==============================
		CodawLib Cwlib = new CodawLib();
		PjUnion Pjuni = new PjUnion();
		NewsEntryDim vDim = new NewsEntryDim();
		PrintWriter out = null;
		Connection conn = null;
		
		//SessionオブジェクトよりHPHEAD読み込み
		HttpSession session = request.getSession(true);
		
		
		//***** 初期処理 *****
		//Pjuni.Set_Enviroment(request,response,getServletContext().getInitParameter(Pjuni.DbName)); //ログイン用
		if(Cwlib.getSessionString("","Env_EncodeType",session).length()<=0)
		{
			Pjuni.Set_Enviroment(request,response,Cwlib); //ログイン用
			Cwlib.Err_Session(request,response);
			return;
		}
		//Cwlib.Get_Enviroment(request,response);
		Pjuni.Pj_Enviroment(request,response,Cwlib);
		
		try
		{
			//==============================
			//  出力ストリーム取得
			//==============================
			//Cwlib.encodetype = "Shift_JIS"; //携帯端末用
			out = Cwlib.Pwriter(request,response,Cwlib.Env_ZipGet);
			
			//==============================
			//  データベース接続
			//==============================
			conn = Cwlib.dbOpen(request, response, getServletInfo());
			if(conn instanceof Connection)
			{
				//++++++++++++++++++++++++++++++++++++++++++++++++++
				//  ここからビジネスロジックの記述を行う
				//++++++++++++++++++++++++++++++++++++++++++++++++++
				vDim.txt_linkSubmit = Cwlib.getLinkUrl(response,"NewsEntrysv","");
				vDim.txt_link001 	= "/" + Cwlib.Env_PackageName + "/insurance.css";
				vDim.txt_link002	= Cwlib.getLinkUrl(response,"Contentssv","");
				vDim.txt_link003 	= "javascript:bp_submitmode('NewsEntry','INSERT')";
				vDim.txt_link005 	= Cwlib.getLinkUrl(response,"NewsEntrysv","&opennow=yes");				
				vDim.txt_link006 	= Cwlib.getLinkUrl(response,"NewsEntrysv","&endnow=yes");
				vDim.onchange       = "javascript:bp_submitmode('NewsEntry','ONCHANGE')";
				
				//ユーザー権限とユーザーIDが無い人は弾きます
				Pjuni.se_S_userid  = Cwlib.getSessionString("",Pjuni.S_userid,session);//アカウントＩＤ
				vDim.sse_user=Pjuni.se_S_userid;
				if(Pjuni.se_S_userid.equals(""))
				{   
					response.sendRedirect(Cwlib.getLinkUrl(response,"indexsv",""));   
				}
				
				vDim.editflag = Cwlib.postDataGet(request,"edit_list","");
				vDim.insupt ="insertupdate";
				
				
				if(vDim.editflag.length()>0)
				{
					editCMSDB(out,Cwlib,Pjuni,conn,vDim,request,response);
					session_set(vDim, Cwlib, session);
				}
				else
				{
					
				}
				
				session_get(vDim, Cwlib, session);
				session_remove(vDim, Cwlib, session);
				
				Cwlib.dateTimes();
				//新規作成時は今日の日時を入れる    
				GregorianCalendar gen_month = new GregorianCalendar(Integer.parseInt(Cwlib.Cld_yy),Integer.parseInt(Cwlib.Cld_mm)-1,1);
				vDim.input01_number_of_days = Integer.toString(gen_month.getActualMaximum(Calendar.DATE));
				
				//++++++++++++++++++++++++++++++++++++++++++++++++++
				//  ここまでビジネスロジックの記述を行う
				//++++++++++++++++++++++++++++++++++++++++++++++++++
				writeHtm(out,Cwlib,Pjuni,conn,vDim);
			}
		}
		finally
		{
			//==============================
			//  データベース接続終了
			//==============================
			Cwlib.dbClose(request,response,conn,getServletInfo());
			
			//==============================
			//  出力ストリームを閉じる
			//==============================
			Cwlib.PwriterClose(request,response,out,getServletInfo());
		}
		
	}
	
	
	
	
	//***********************************************************************
	//  サブルーチン Loop_area
	//***********************************************************************
	private void Loop_area(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		Pjuni.get_area_master(out, Cwlib, conn, null);
		
		vDim.area_master  = Pjuni.area_master;
		vDim.areaname = Pjuni.area_name;
		
		for (int i = 0; i<vDim.areaname.size(); i++) 
		{
			vDim.areamaster =(String)vDim.area_master.get(i);
			vDim.area_name =(String)vDim.areaname.get(i);
			if(vDim.areamaster.equals(vDim.txt_area))
			{
				vDim.areamaster_selected ="selected";
				
			}
			else
				vDim.areamaster_selected ="";
			
			writeHtm_Loop_area(out,Cwlib,Pjuni,conn,vDim);
			
		}
		
	}
	
	//***********************************************************************
	//  サブルーチン Loop_category1
	//***********************************************************************
	private void Loop_category1(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		Pjuni.get_cat1_value("001",out, Cwlib, conn, null);
		
		vDim.cat_master            =  Pjuni.cat1_cd1;
		vDim.category1_value_list  =  Pjuni.cat1_value;
		for (int i = 0; i< vDim.category1_value_list.size(); i++) 
		{
			vDim.txt_cat_master =(String)vDim.cat_master.get(i);
			vDim.txt_cat1_value =(String)vDim.category1_value_list.get(i);
			if(vDim.txt_cat_master.equals(vDim.txt_category1value))
			{
				vDim.catmaster_selected ="selected";
				
			}
			else
				vDim.catmaster_selected ="";
			
			writeHtm_Loop_category1(out,Cwlib,Pjuni,conn,vDim);
		}
	}
	
	//***********************************************************************
	//  サブルーチン Loop_category2
	//***********************************************************************
	private void Loop_category2(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		Pjuni.get_cat2_value("001",vDim.txt_category1value, out, Cwlib, conn, null);
		
		vDim.cat_master            =  Pjuni.cat2_cd2;
		vDim.category2_value_list  =  Pjuni.cat2_value;
		
		for (int i = 0; i< vDim.category2_value_list.size(); i++) 
		{
			vDim.txt_cat_master =(String)vDim.cat_master.get(i);
			vDim.txt_cat2_value =(String)vDim.category2_value_list.get(i);
			if(vDim.txt_cat_master.equals(vDim.txt_category2value))
			{
				vDim.catmaster_selected ="selected";
				
			}
			else
				vDim.catmaster_selected ="";
			
			writeHtm_Loop_category2(out,Cwlib,Pjuni,conn,vDim);
		}
	}
	
	//***********************************************************************
	//  サブルーチン Loop_Priority
	//***********************************************************************
	
	private void  Loop_Priority(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		
		System.out.println("vDim.txt_priority============================>"+vDim.txt_priority);
		for(int i=1;i<=5;i++)
		{
			
			vDim.inp_priority = Integer.toString(i);
			
			if(vDim.txt_priority.equals(vDim.inp_priority))					
				vDim.priority_selected ="selected";			
			else
				vDim.priority_selected ="";
				
				writeHtm_Loop_Priority(out,Cwlib,Pjuni,conn,vDim);
			
		}
	}
	
	
	
	//--ここからhtmファイル自動生成---
	//***********************************************************************
	//  HTML文書を生成
	//***********************************************************************
	private void writeHtm(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<html>");
		out.println("<head>");
		out.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=Shift_JIS\">");
		out.println("<script language=\"JavaScript\" src=\"/CMS/cwlib.js\"></script>");    
		out.println("<title>ニュースCMS新規登録</title>");
		out.println("<link href=\""+vDim.txt_link001+"\" rel=\"stylesheet\" type=\"text/css\">");
		out.println("<script type=\"text/JavaScript\">");
		out.println("<!--");
		out.println("function setfocus() { ");
		out.println("document.pass.textfield2.focus();");
		out.println("}");
		out.println("document.onkeydown = KeyEvent;");
		out.println("self.focus();");
		out.println("var st_name = navigator.appName;");
		out.println("function KeyEvent(e){");
		out.println("  if(st_name == \"Microsoft Internet Explorer\")");
		out.println("  {");
		out.println("    pressKey=event.keyCode;");
		out.println("    if(pressKey == '13')");
		out.println("    {");
		out.println("      bp_doIt('NewsEntry');");
		out.println("    }");
		out.println("  }");
		out.println("  else if(st_name == \"Netscape\")");
		out.println("  {");
		out.println("    pressKey=e.which;");
		out.println("    if(pressKey == '13' || pressKey == '0')");
		out.println("    {");
		out.println("      bp_doIt('NewsEntry');");
		out.println("    }");
		out.println("  }");
		out.println("}");
		out.println("function MM_preloadImages() { //v3.0");
		out.println("  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();");
		out.println("    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)");
		out.println("    if (a[i].indexOf(\"#\")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}");
		out.println("}");
		out.println("function MM_swapImgRestore() { //v3.0");
		out.println("  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;");
		out.println("}");
		out.println("function MM_findObj(n, d) { //v4.01");
		out.println("  var p,i,x;  if(!d) d=document; if((p=n.indexOf(\"?\"))>0&&parent.frames.length) {");
		out.println("    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}");
		out.println("  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];");
		out.println("  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);");
		out.println("  if(!x && d.getElementById) x=d.getElementById(n); return x;");
		out.println("}");
		out.println("");
		out.println("function MM_swapImage() { //v3.0");
		out.println("  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)");
		out.println("   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}");
		out.println("}");
		
		out.println("function sendRequest(dbmaster)");
		out.println("{");
		out.println("        document.NewsEntry.action ='http://localhost'+dbmaster");		
		out.println("        document.NewsEntry.submit();");
		out.println("}");
		
		out.println("function sub()");
		out.println("{ ");		
		out.println("       document.getElementById('NewsEntry').submit();");	
		out.println("}      ");
		
		out.println("//-->");
		out.println("</script>");
		out.println("");
		out.println("");
		out.println("</head>");
		out.println("<body bgcolor=\""+Cwlib.Env_Color[1]+"\" text=\""+Cwlib.Env_Color[2]+"\" background=\""+Cwlib.Env_ImgPass+"MstWall01.jpg\" onLoad=\"MM_preloadImages('"+Cwlib.Env_ImgPass+"sbtn05d.gif','#945190973977');MM_preloadImages('"+Cwlib.Env_ImgPass+"MstToukoud.gif','"+Cwlib.Env_ImgPass+"btn_chk_u.gif','"+Cwlib.Env_ImgPass+"MstTorokud.gif')\">");   
		out.println("<form id=\"NewsEntry\" name=\"NewsEntry\" method=\"post\" action=\""+vDim.txt_linkSubmit+"\"  >");
		out.println(" <input type=\"hidden\" name=\"editMode\" value=\"no\" >");
		out.println(" <br> <br> <br> <br> <br> ");
		out.println("<table  border=\"1\"  align=\"center\">");
		out.println("<tr><td>");
		out.println(" <table   border=\"0\"  >");
		out.println(" <tr><td>      ");
		out.println("            <tr height=\"8%\"> ");
		out.println("              <td  align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\" ><b class=\"font14w_bold\">■　ニュースCMS新規登録　■</b></td>");
		out.println("        </tr>    ");
		out.println("            <tr ><td>");
		out.println("          <table>                        ");
		out.println("              <tr >");
		out.println("                    <td ><a href=\""+vDim.txt_link002+"\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Image1','','"+Cwlib.Env_ImgPass+"MstModorud.gif',1)\"><img src=\""+Cwlib.Env_ImgPass+"MstModoruu.gif\" alt=\"戻る\" border=\"0\" name=\"Image1\"></a>&nbsp&nbsp&nbsp&nbsp</td>");
		//out.println("                   <td ><a href=\"#\"     onclick=\"javascript:sendRequest('" +Cwlib.Env_ServletPath+ "NewsEntrysv?Insupd="+vDim.insupt+ "')\" ><img src=\""+Cwlib.Env_ImgPass+"MstTorokuu.gif\" alt=\"登録\" border=\"0\" name=\"Image2\"></a></td>");
		out.println("                   <td ><a href=\""+vDim.txt_link003+"\" > <img src=\""+Cwlib.Env_ImgPass+"MstTorokuu.gif\" alt=\"登録\" border=\"0\" name=\"Image2\"></a></td>");
		out.println("             </tr>");
		out.println("           </table>     ");
		out.println("         <table width=\"100%\" height=\"8\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
		out.println("              <tr>");
		out.println("                <td><hr width=\"100%\"></td>");
		out.println("              </tr>");
		out.println("                </table>            ");
		out.println("            </td></tr>");
		out.println("");
		out.println("       <tr ><td>");
		out.println("       <table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" width=\"140%\">    ");
		out.println("");
		out.println("");
		out.println(" <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">エリア</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"area\"  size=\"1\" style=\"width:270\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"--\">--</option>");
		Loop_area(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select>");
		out.println("                </td>");
		out.println("   </tr> ");
		out.println("");
		out.println("");
		out.println(" <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">カテゴリー</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"category1\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\" >");
		out.println("                 <option value=\"--\">-------------</option>");
		Loop_category1(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select>");
		out.println("                    <select name=\"category2\" size=\"1\" style=\"width:180\">");
		out.println("                 <option value=\"--\">--</option>");
		Loop_category2(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select>");
		out.println("                </td>");
		out.println("   </tr> ");
		out.println("");
		out.println("");
		out.println("");
		out.println("");
		out.println("");
		out.println("    ");
		out.println("                            <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">記事日付</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"articledate_year\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_articleyear(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select> 年");
		out.println("                ");
		out.println("                <select name=\"articledate_month\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_articlemonth(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select> 月");
		out.println("                    <select name=\"articledate_day\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_articledate(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select> 日");
		out.println("                <select name=\"articledate_hours\" size=\"1\" class=\"font12b_w150\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_articlehours(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select> 時");
		out.println("                    <select name=\"articledate_minutes\" size=\"1\" class=\"font12b_w150\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_articleminutes(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select>分 <a href=\"#\" onclick=\"javascript:sendRequest('" +Cwlib.Env_ServletPath+ "NewsEntrysv?articlenow=yes')\" ><font color=\""+Cwlib.Env_Color[6]+"\"><u><b> >>now </b></u></font></a>  ");
		out.println("                </td>    ");
		out.println("                            </tr>");
		out.println("");
		out.println("");
		out.println("   <tr>");
		out.println("               <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">タイトル</td>                        ");
		out.println("           <td valign=\"middle\" nowrap>  ");    
		out.println("        <input type=\"textbox\" name=\"title\"  value=\""+vDim.txt_title+"\" maxlength=\"23\" size=\"52\">(23文字)");
		out.println("        </td>");
		out.println("       </tr>");
		out.println("");
		out.println("");
		out.println("");
		out.println("           <tr>");
		out.println("               <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">本文</td>                        ");
		out.println("           <td valign=\"middle\" nowrap>  ");
		out.println("        <textarea cols=\"61\" rows=\"4\" name=\"newstext\" maxlength=\"124\">"+vDim.txt_newstext+"</textarea>(124文字)");
		out.println("        </td>");
		out.println("       </tr>");
		out.println("");
		out.println("   <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">優先順位</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"priority\" size=\"1\" class=\"font12b_w150\">");
		out.println("                <option value=\"0\">無し</option>");
		Loop_Priority(out,Cwlib,Pjuni,conn,vDim);
		out.println("                    </select>");
		out.println("                </td>");
		out.println("   </tr> ");
		out.println("");
		out.println("    ");
		out.println("                       ");
		out.println("                            <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">公開開始日付</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"public_stdate_year\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">----</option>");
		Loop_openend_year(out,Cwlib,Pjuni,conn,vDim,"open");
		out.println("                    </select> 年");
		out.println("                ");
		out.println("                <select name=\"public_stdate_month\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_month(out,Cwlib,Pjuni,conn,vDim,"open");
		out.println("                    </select> 月");
		out.println("                    <select name=\"public_stdate_day\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		if(!vDim.open_number_of_days.equals("")&&!vDim.open_number_of_days.equals("--"))
		{
			Loop_openend_date(out,Cwlib,Pjuni,conn,vDim,"open");
		}
		out.println("                    </select> 日");
		out.println("                <select name=\"public_stdate_hours\" size=\"1\" class=\"font12b_w150\" >");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_hours(out,Cwlib,Pjuni,conn,vDim,"open");
		out.println("                    </select> 時");
		out.println("                    <select name=\"public_stdate_minutes\" size=\"1\" class=\"font12b_w150\" >");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_minutes(out,Cwlib,Pjuni,conn,vDim,"open");
		out.println("                    </select>分   <a href=\"#\" onclick=\"javascript:sendRequest('" +Cwlib.Env_ServletPath+ "NewsEntrysv?opennow=yes')\" ><font color=\""+Cwlib.Env_Color[6]+"\"><u><b> >>now </b></u></font></a>    ");		
		out.println("                </td>    ");
		out.println("                            </tr>");
		out.println("");
		out.println("");
		out.println("                            <tr>");
		out.println("                              <td   width=\"80\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\">公開終了日付</td>                              ");
		out.println("                <td valign=\"middle\" nowrap>  ");
		out.println("                    <select name=\"public_endate_year\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("               <option value=\"\">----</option>");
		Loop_openend_year(out,Cwlib,Pjuni,conn,vDim,"end");
		out.println("                    </select> 年");
		out.println("                ");
		out.println("                <select name=\"public_endate_month\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_month(out,Cwlib,Pjuni,conn,vDim,"end");
		out.println("                    </select> 月");
		out.println("                    <select name=\"public_endate_day\" size=\"1\" class=\"font12b_w150\" onChange=\""+vDim.onchange +"\">");
		out.println("                 <option value=\"\">--</option>");
		if(!vDim.end_number_of_days.equals("")&&!vDim.end_number_of_days.equals("--"))
		{
			Loop_openend_date(out,Cwlib,Pjuni,conn,vDim,"end");
		}
		out.println("                    </select> 日");
		out.println("                <select name=\"public_endate_hours\" size=\"1\" class=\"font12b_w150\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_hours(out,Cwlib,Pjuni,conn,vDim,"end");
		out.println("                    </select> 時");
		out.println("                    <select name=\"public_endate_minutes\" size=\"1\" class=\"font12b_w150\">");
		out.println("                 <option value=\"\">--</option>");
		Loop_openend_minutes(out,Cwlib,Pjuni,conn,vDim,"end");
		out.println("                    </select>分  <a href=\"#\" onclick=\"javascript:sendRequest('" +Cwlib.Env_ServletPath+ "NewsEntrysv?endnow=yes')\" ><font color=\""+Cwlib.Env_Color[6]+"\"><u><b> >>now </b></u></font></a>    ");
		
		out.println("                </td>    ");
		out.println("                            </tr>");
		out.println("");
		out.println("  <tr>");
		out.println("      <td  width=\"100\" align=\"center\" nowrap bgcolor=\""+Cwlib.Env_Color[8]+"\" class=\"body12w-nomal\"rowspan=\"2\">画像</td>");
		out.println("      <td ><input type=\"file\" name=\"img\" value="+vDim.txt_img+" enctype=\"multipart/form-data\"></td>");
		out.println("    </tr>");		
		out.println("    <tr>");
		out.println("      <td >画像削除<input type=\"checkbox\" name=\"chkimg\" value=\""+vDim.txt_imgchk+"\"></td>");
		out.println("    </tr>");
		out.println("");
		out.println(" ");
		out.println("");
		out.println("     </td></tr>     ");
		out.println("   </table>            ");
		out.println("           </td></tr>            ");
		out.println(" </table>        ");
		out.println(" </td></tr>     ");
		out.println("   </table>    ");
		out.println("<input type=\"hidden\" name=\"submitMode\">");
		out.println("<input type=\"hidden\" name=\"db_master\" value="+vDim.txt_dbmaster+" >");
		out.println("<input type=\"hidden\" name=\"user_id\" value="+vDim.sse_user+" >");
		out.println("</form>");
		out.println("</body>");
		out.println("</html>");
	}
	
	
	//***********************************************************************
	//ドロップダウンループ(LOOP)
	//***********************************************************************
	private void writeHtm_Loop_Selpriority(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim)
	{
		out.println("<option value=\""+vDim.txt_value_drop+"\""+vDim.drop_select+">"+vDim.txt_inp_drop+"</option>");
	}
	
	
	//***********************************************************************
	//  HTML文書を生成 (LOOP)
	//***********************************************************************
	private void writeHtm_Loop_area(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		out.println("<option value="+vDim.areamaster+" "+vDim.areamaster_selected+">"+vDim.area_name+"</option>");			 
	}
	
	private void writeHtm_Loop_category1(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{	
		out.println("<option value="+vDim.txt_cat_master+" "+vDim.catmaster_selected+">"+vDim.txt_cat1_value+"</option>");
	}
	
	private void writeHtm_Loop_category2(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		out.println("<option value="+vDim.txt_cat_master+" "+vDim.catmaster_selected+" >"+vDim.txt_cat2_value+"</option>");		
	}
	
	private void writeHtm_Loop_Priority(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		out.println("<option value="+vDim.inp_priority+" "+vDim.priority_selected+" >"+vDim.inp_priority+"</option>");		
	}
	
//	--ここまでhtmファイル自動生成---
	
	//**********************************************************************
	//  doPost データベース書き込み処理
	//**********************************************************************
	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{  
		
		//==============================
		//  共通ルーチン初期設定
		//==============================
		CodawLib Cwlib = new CodawLib();
		PjUnion Pjuni = new PjUnion();
		NewsEntryDim vDim = new NewsEntryDim();
		PrintWriter out = null;
		Connection conn = null;    
		//SessionオブジェクトよりHPHEAD読み込み
		HttpSession session = request.getSession(true);
		//***** 初期処理 *****
		if(Cwlib.getSessionString("","Env_EncodeType",session).length()<=0)
		{
			Pjuni.Set_Enviroment(request,response,Cwlib); //ログイン用
			Cwlib.Err_Session(request,response);
			return;
		}
		Pjuni.Pj_Enviroment(request,response,Cwlib);
		try
		{
			//==============================
			//  出力ストリーム取得
			//==============================
			out = Cwlib.Pwriter(request,response,Cwlib.Env_ZipPost);
			//==============================
			//  データベース接続
			//==============================
			//Cwlib.encodetype = "Shift_JIS"; //携帯端末用
			conn = Cwlib.dbOpen(request, response, getServletInfo());
			if(conn instanceof Connection)
			{
				//++++++++++++++++++++++++++++++++++++++++++++++++++
				//  ここからビジネスロジックの記述を行う
				//++++++++++++++++++++++++++++++++++++++++++++++++++
		        Cwlib.files.setParseMultipart(request,"");
		        vDim.sse_user = Cwlib.files.getMultipartString("userid","");

		        vDim.txt_linkSubmit = Cwlib.getLinkUrl(response,"NewsEntrysv","");
				vDim.Process      	= Cwlib.postDataGet(request,"submitMode","");
		    	PostDataGet(request,Cwlib,vDim);
				session_set(vDim,Cwlib,session);
				
				if(!vDim.Process.trim().equals("INSERT"))
				{
					response.sendRedirect(vDim.txt_linkSubmit);
					return; 
				}
				else if(vDim.Process.trim().equals("INSERT"))
				{
			        vDim.errcheck =err_chk(session,out,Cwlib,Pjuni,conn,vDim,request,response);
			        if(vDim.errcheck==true)
			        {
			        	System.out.println("vDim.errcheck==true"+vDim.errcheck);
			        	//Cwlib.dspMsg.Dsp_Msg(request, response,out, "ニュースCMS新規登録",vDim.txt_error,"onclick=\"history.back()\"");
			        	//out.flush();
			            //out.close();
			            return;
			        }
						
					try
					{
						String max_db_master  = "0000000000";
						
						vDim.SQLbuf = "SELECT MAX(\"db_master\") AS MAX_db_master\n"+
						"FROM \"CMS_DB\"\n";
						
						Statement stmt = conn.createStatement();
						ResultSet rs = stmt.executeQuery(vDim.SQLbuf);     
						
						if(rs.next())
						{
							max_db_master  = Cwlib.getDBstring("0000000000",rs.getString("MAX_db_MASTER"));
						}
						rs.close();
						stmt.close();      	
						
						vDim.editflag = Cwlib.postDataGet(request,"db_master","");  
						Cwlib.dateTimes();                                          
						vDim.SQLbuf =   "SELECT * \n"+
										"FROM \"CMS_DB\"\n"+
										"WHERE \"db_master\" = '"+vDim.editflag+"'\n"+
										"FOR UPDATE";
						
						stmt = conn.createStatement();
						rs = stmt.executeQuery(vDim.SQLbuf);
						if(rs.next())
						{	
							vDim.cmsnews.Clear_CMS_DB(conn);            	
							vDim.cmsnews.db_master  = Cwlib.postDataGet(request,"db_master","");           							
							vDim.cmsnews.mid_key   = Cwlib.postDataGet(request,"midkey","");            	
							vDim.cmsnews.contents_no = "001";//Cwlib.postDataGet(request,"contents_no","");
							vDim.cmsnews.cat1_cd = Cwlib.postDataGet(request,"category1","");
							vDim.cmsnews.cat2_cd = Cwlib.postDataGet(request,"category2","");
							vDim.cmsnews.area_master = Cwlib.postDataGet(request,"area","");                
							vDim.cmsnews.priority =Cwlib.postDataGet(request,"priority","");
							vDim.cmsnews.opendt = Cwlib.postDataGet(request,"public_stdate_year","")+"/"+Cwlib.postDataGet(request,"public_stdate_month","")+"/"+Cwlib.postDataGet(request,"public_stdate_day","");
							vDim.cmsnews.opentm = Cwlib.postDataGet(request,"public_stdate_hours","")+":"+Cwlib.postDataGet(request,"public_stdate_minutes","");
							vDim.cmsnews.openweek = Cwlib.postDataGet(request,"openweek","");
							vDim.cmsnews.enddt = Cwlib.postDataGet(request,"public_endate_year","")+"/"+Cwlib.postDataGet(request,"public_endate_month","")+"/"+Cwlib.postDataGet(request,"public_endate_day","");
							vDim.cmsnews.endtm 	 = Cwlib.postDataGet(request,"public_endate_hours","")+":"+Cwlib.postDataGet(request,"public_endate_minutes","");
							vDim.cmsnews.endweek = Cwlib.postDataGet(request,"endweek","");
							vDim.cmsnews.input01 = Cwlib.postDataGet(request,"articledate_year","")+"/"+Cwlib.postDataGet(request,"articledate_month","")+"/"+Cwlib.postDataGet(request,"articledate_day","")+"/"+Cwlib.postDataGet(request,"articledate_hours","")+":"+Cwlib.postDataGet(request,"articledate_minutes","");
							vDim.cmsnews.input02 = Cwlib.getStringZenkaku("",Cwlib.postDataGet(request,"title","")).trim();
							vDim.cmsnews.input03 = Cwlib.getStringZenkaku("",Cwlib.postDataGet(request,"newstext","")).trim();
							vDim.cmsnews.input04 = Cwlib.postDataGet(request,"input04","");
							vDim.cmsnews.input05 = Cwlib.postDataGet(request,"input05","");
							vDim.cmsnews.input06 = Cwlib.postDataGet(request,"input06","");
							vDim.cmsnews.input07 = Cwlib.postDataGet(request,"input07","");
							vDim.cmsnews.input08 = Cwlib.postDataGet(request,"input08","");
							vDim.cmsnews.input09 = Cwlib.postDataGet(request,"input09","");
							vDim.cmsnews.input10 = Cwlib.postDataGet(request,"input10","");
							vDim.cmsnews.input11 = Cwlib.postDataGet(request,"input11","");
							vDim.cmsnews.input12 = Cwlib.postDataGet(request,"input12","");
							vDim.cmsnews.input13 = Cwlib.postDataGet(request,"input13","");
							vDim.cmsnews.input14 = Cwlib.postDataGet(request,"input14","");     
							vDim.cmsnews.input15 = Cwlib.postDataGet(request,"input15","");
							vDim.cmsnews.input16 = Cwlib.postDataGet(request,"input16","");
							vDim.cmsnews.input17 = Cwlib.postDataGet(request,"input17","");
							vDim.cmsnews.input18 = Cwlib.postDataGet(request,"input18","");
							vDim.cmsnews.input19 = Cwlib.postDataGet(request,"input19","");
							vDim.cmsnews.input20 = Cwlib.postDataGet(request,"input20","");
							vDim.cmsnews.input21 = Cwlib.postDataGet(request,"input21",""); 
							vDim.cmsnews.input22 = Cwlib.postDataGet(request,"input22","");
							vDim.cmsnews.input23 = Cwlib.postDataGet(request,"input23","");    
							vDim.cmsnews.input24 = Cwlib.postDataGet(request,"input24","");
							vDim.cmsnews.input25 = Cwlib.postDataGet(request,"input25","");     
							vDim.cmsnews.del_flg = "0";
							vDim.cmsnews.renewdt = Cwlib.Cld_days;
							vDim.cmsnews.renewtm = Cwlib.Cld_times;
							vDim.cmsnews.img = Cwlib.postDataGet(request,"img","");
							vDim.cmsnews.status_flg="1";
							vDim.cmsnews.user_id = 	vDim.sse_user;           
							vDim.cmsnews.Upd_CMS_DB(getServletInfo(),Cwlib,conn);
							rs.close();
							stmt.close();
							conn.commit();
							session_remove(vDim, Cwlib, session);
							Cwlib.dspMsg.Dsp_Msg(request,response,out,"登録完了","ニュースCMS更新は成功的に完了しました。","href=\""+vDim.txt_linkSubmit+"\"");
			                out.flush();
			                out.close();
						}
						else
						{
							vDim.cmsnews.Clear_CMS_DB(conn);            	
							vDim.cmsnews.db_master  = new DecimalFormat("0000000000").format(Integer.parseInt(max_db_master)+1);           							
							vDim.cmsnews.mid_key   = Cwlib.postDataGet(request,"midkey","");            	
							vDim.cmsnews.contents_no = "001";//Cwlib.postDataGet(request,"contents_no","");
							vDim.cmsnews.cat1_cd = Cwlib.postDataGet(request,"category1","");
							vDim.cmsnews.cat2_cd = Cwlib.postDataGet(request,"category2","");
							vDim.cmsnews.area_master = Cwlib.postDataGet(request,"area","");                
							vDim.cmsnews.priority =Cwlib.postDataGet(request,"priority","");
							vDim.cmsnews.opendt = Cwlib.postDataGet(request,"public_stdate_year","")+"/"+Cwlib.postDataGet(request,"public_stdate_month","")+"/"+Cwlib.postDataGet(request,"public_stdate_day","");
							vDim.cmsnews.opentm = Cwlib.postDataGet(request,"public_stdate_hours","")+":"+Cwlib.postDataGet(request,"public_stdate_minutes","");
							vDim.cmsnews.openweek = Cwlib.postDataGet(request,"openweek","");
							vDim.cmsnews.enddt = Cwlib.postDataGet(request,"public_endate_year","")+"/"+Cwlib.postDataGet(request,"public_endate_month","")+"/"+Cwlib.postDataGet(request,"public_endate_day","");			            
							vDim.cmsnews.endtm = Cwlib.postDataGet(request,"public_endate_hours","")+":"+Cwlib.postDataGet(request,"public_endate_minutes","");
							vDim.cmsnews.endweek = Cwlib.postDataGet(request,"endweek","");
							vDim.cmsnews.input01 = Cwlib.postDataGet(request,"articledate_year","")+"/"+Cwlib.postDataGet(request,"articledate_month","")+"/"+Cwlib.postDataGet(request,"articledate_day","")+"/"+Cwlib.postDataGet(request,"articledate_hours","")+":"+Cwlib.postDataGet(request,"articledate_minutes","");
							vDim.cmsnews.input02 = Cwlib.getStringZenkaku("",Cwlib.postDataGet(request,"title","")).trim();
							vDim.cmsnews.input03 = Cwlib.getStringZenkaku("",Cwlib.postDataGet(request,"newstext","")).trim();
							vDim.cmsnews.input04 = Cwlib.postDataGet(request,"input04","");
							vDim.cmsnews.input05 = Cwlib.postDataGet(request,"input05","");
							vDim.cmsnews.input06 = Cwlib.postDataGet(request,"input06","");
							vDim.cmsnews.input07 = Cwlib.postDataGet(request,"input07","");
							vDim.cmsnews.input08 = Cwlib.postDataGet(request,"input08","");
							vDim.cmsnews.input09 = Cwlib.postDataGet(request,"input09","");
							vDim.cmsnews.input10 = Cwlib.postDataGet(request,"input10","");
							vDim.cmsnews.input11 = Cwlib.postDataGet(request,"input11","");
							vDim.cmsnews.input12 = Cwlib.postDataGet(request,"input12","");
							vDim.cmsnews.input13 = Cwlib.postDataGet(request,"input13","");
							vDim.cmsnews.input14 = Cwlib.postDataGet(request,"input14","");     
							vDim.cmsnews.input15 = Cwlib.postDataGet(request,"input15","");
							vDim.cmsnews.input16 = Cwlib.postDataGet(request,"input16","");
							vDim.cmsnews.input17 = Cwlib.postDataGet(request,"input17","");
							vDim.cmsnews.input18 = Cwlib.postDataGet(request,"input18","");
							vDim.cmsnews.input19 = Cwlib.postDataGet(request,"input19","");
							vDim.cmsnews.input20 = Cwlib.postDataGet(request,"input20","");
							vDim.cmsnews.input21 = Cwlib.postDataGet(request,"input21",""); 
							vDim.cmsnews.input22 = Cwlib.postDataGet(request,"input22","");
							vDim.cmsnews.input23 = Cwlib.postDataGet(request,"input23","");    
							vDim.cmsnews.input24 = Cwlib.postDataGet(request,"input24","");
							vDim.cmsnews.input25 = Cwlib.postDataGet(request,"input25","");     
							vDim.cmsnews.del_flg = "0";
							vDim.cmsnews.wrtdt = Cwlib.Cld_days;
							vDim.cmsnews.wrttm = Cwlib.Cld_times;
							vDim.cmsnews.renewdt = Cwlib.Cld_days;
							vDim.cmsnews.renewtm = Cwlib.Cld_times;
							vDim.cmsnews.img = Cwlib.postDataGet(request,"img","");
							vDim.cmsnews.status_flg="1";
							vDim.cmsnews.user_id = vDim.sse_user; 
							
							vDim.cmsnews.Ins_CMS_DB(getServletInfo(),Cwlib,conn);
							rs.close();
							stmt.close();
							conn.commit();
							session_remove(vDim, Cwlib, session);
							Cwlib.dspMsg.Dsp_Msg(request,response,out,"登録完了","ニュースCMS新規登録を登録しました","href=\""+vDim.txt_linkSubmit+"\"");
			                out.flush();
			                out.close();
			                
					     }	
					
				}
				catch(SQLException e)
				{
					e.printStackTrace();
					System.out.println(e);
					Cwlib.dbError(getServletInfo(),e,vDim.SQLbuf);
					try
					{
						conn.rollback();
					}
					catch (SQLException ex) 
					{
						Cwlib.dbError(getServletInfo(),ex,vDim.SQLbuf);
					}
					Cwlib.dspMsg.Dsp_Msg(request,response,out,"登録エラー","ニュースCMS新規登録を登録できませんでした。<br>管理者にお問い合わせください。","onclick=\"history.back()\"");
					out.flush();
					out.close();   
					return;
				}
			 }// if..............
				
			}
		}
		//++++++++++++++++++++++++++++++++++++++++++++++++++
		//  ここまでビジネスロジックの記述を行う
		//++++++++++++++++++++++++++++++++++++++++++++++++++
		
		finally
		{
			//==============================
			//  データベース接続終了
			//==============================
			Cwlib.dbClose(request,response,conn,getServletInfo());
			
			//==============================
			//  出力ストリームを閉じる
			//==============================
			Cwlib.PwriterClose(request,response,out,getServletInfo());
			
		}
		
	}
	
	//**********************************************************************
	//  Servlet 情報の取得
	//**********************************************************************
	
	public String getServletInfo()
	{
		return "Named info: CMS.NewsEntrysv";
	}
	
	//++++++++++++++++++++++++++++++++++++++++++++++++++
	//  ここから自作関数の記述を行う
	//++++++++++++++++++++++++++++++++++++++++++++++++++
	
	
	
	
	public void Loop_articleyear(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		
		String hikaku_yyyy = "";
		
		
		if(vDim.txt_articleyear1.length()>0 || vDim.txt_inp_articledt_yyyy.trim().length()>0)			
			hikaku_yyyy = vDim.txt_inp_articledt_yyyy;
		else
			hikaku_yyyy = Cwlib.Cld_yy;
		
		//hikaku_yyyy = "";
		
		vDim.txt_inp_drop   = Cwlib.calendar.Cld_yy;
		vDim.txt_value_drop = Cwlib.calendar.Cld_yy;
		
		for(int i=0; i<10 ;i++)
		{	
			if(!hikaku_yyyy.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_yyyy))
				{					
					vDim.drop_select = "selected";
				}
			}
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.txt_inp_drop = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop = Integer.toString(Integer.parseInt(vDim.txt_value_drop)+1);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";
		
	}
	
	public void Loop_articlemonth(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		String hikaku_mm = "";			
		if(vDim.txt_articlemonth1.length()>0 || vDim.txt_inp_articledt_mm.trim().length()>0)
			hikaku_mm = vDim.txt_inp_articledt_mm;
		
		else
			hikaku_mm = Cwlib.Cld_mm;
		
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=0; i<12 ;i++)
		{
			vDim.txt_inp_drop   = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_value_drop)+1);
			if(!hikaku_mm.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_mm))
				{					
					vDim.drop_select = "selected";
				}
			}			
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";
		
		
	}
	public void Loop_articledate(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		
		String hikaku_dd = "";
		String max_day   = "";   	
		
		
		if(vDim.txt_articleday1.length()>0||vDim.txt_inp_articledt_dd.trim().length()>0)
			hikaku_dd = vDim.txt_inp_articledt_dd;
		else
			hikaku_dd = Cwlib.Cld_dd;
		
		max_day   = vDim.input01_number_of_days;
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=1; i<=Integer.parseInt(max_day) ;i++)
		{	
			vDim.txt_inp_drop   = new DecimalFormat("00").format(i);
			vDim.txt_value_drop = new DecimalFormat("00").format(i);
			if(!hikaku_dd.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_dd))
				{					
					vDim.drop_select = "selected";
				}
			}
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";
		
	}
	public void Loop_articlehours(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		
		String hikaku_hh = "";
		if(vDim.txt_articlehours1.length()>0 || vDim.txt_inp_articledt_hours.length()>0)
			hikaku_hh = vDim.txt_inp_articledt_hours;
		else
			hikaku_hh =  Cwlib.Cld_hh;
		
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=0; i<24 ;i++)
		{	
			if(!hikaku_hh.equals(""))
			{
				if(new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)).equals(hikaku_hh))
				{					
					vDim.drop_select = "selected";
				}
			}
			vDim.txt_inp_drop   = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop));
			vDim.txt_value_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_value_drop));
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
			
			vDim.txt_inp_drop   = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop   = Integer.toString(Integer.parseInt(vDim.txt_value_drop)+1);
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";
		
	}
	public void Loop_articleminutes(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim) throws IOException
	{
		
		String hikaku_hmm = "";
		if(vDim.txt_articlemin1.length()>0 ||vDim.txt_inp_articledt_minutes.trim().length()>0)
			hikaku_hmm = vDim.txt_inp_articledt_minutes;
		else
			hikaku_hmm =  Cwlib.Cld_mn;
		
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=0; i<60 ;i++)
		{	
			if(!hikaku_hmm.equals(""))
			{
				if(new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)).equals(hikaku_hmm))
				{					
					vDim.drop_select = "selected";
				}
			}
			vDim.txt_inp_drop   = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop));
			vDim.txt_value_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_value_drop));
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
			
			vDim.txt_inp_drop   = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop = Integer.toString(Integer.parseInt(vDim.txt_value_drop)+1);
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";
		
	}
	
	public void Loop_openend_year(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,String open_end) throws IOException
	{
		String hikaku_yyyy = "";             
		vDim.txt_value_drop = vDim.txt_inp_drop = "2020";
		if(open_end.equals("open"))
		{
			if(vDim.txt_openyear1.length()>0)
				hikaku_yyyy = vDim.txt_openyear1;
			else
				hikaku_yyyy = vDim.open_se_yyyy;
		}
		else
		{
			
			if(vDim.txt_endyear1.length()>0)
				hikaku_yyyy = vDim.txt_endyear1;
			else
				hikaku_yyyy = vDim.end_se_yyyy;
		}
		
		
		for(int i=0; i<13 ;i++)
		{	
			if(!hikaku_yyyy.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_yyyy))
				{					
					vDim.drop_select = "selected";
				}
			}
			if(open_end.equals("end") && vDim.open_se_yyyy.length()>0)
			{
				if(Integer.parseInt(vDim.open_se_yyyy)>=Integer.parseInt(vDim.txt_value_drop))
				{
					i=13;
				}
			}
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.txt_value_drop = vDim.txt_inp_drop = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)-1);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";	
	}
	
	public void Loop_openend_month(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,String open_end) throws IOException
	{
		String hikaku_mm = "";
		vDim.txt_value_drop = vDim.txt_inp_drop = "0";
		
		if(open_end.equals("open"))
		{
			
			if(vDim.txt_openmonth1.length()>0)
				hikaku_mm =vDim.txt_openmonth1;
			else
				hikaku_mm = vDim.open_se_mm;
		}
		else
		{
			
			if(vDim.txt_openmonth1.length()>0)
				hikaku_mm = vDim.txt_openmonth1;
			else
				hikaku_mm = vDim.end_se_mm;
		}     
		
		for(int i=0; i<12 ;i++)
		{	
			vDim.txt_value_drop = vDim.txt_inp_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)+1);
			if(!hikaku_mm.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_mm))
				{					
					vDim.drop_select = "selected";
				}
			}		
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";		
	}
	
	public void Loop_openend_date(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,String open_end) throws IOException
	{
		String hikaku_dd = "";
		String max_day   = "";
		if(open_end.equals("open"))
		{
			
			if(vDim.txt_openday1.length()>0)
				hikaku_dd =vDim.txt_openday1;
			else
				hikaku_dd = vDim.open_se_dd;
			
			max_day   = vDim.open_number_of_days;
			
		}
		else
		{
			
			if(vDim.txt_endday1.length()>0)
				hikaku_dd =vDim.txt_endday1;
			else
				hikaku_dd = vDim.end_se_dd;
			
			max_day   = vDim.end_number_of_days;
		}
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=1; i<=Integer.parseInt(max_day) ;i++)
		{	
			vDim.txt_inp_drop   = new DecimalFormat("00").format(i);
			vDim.txt_value_drop = new DecimalFormat("00").format(i);
			if(!hikaku_dd.equals(""))
			{
				if(vDim.txt_inp_drop.equals(hikaku_dd))
				{					
					vDim.drop_select = "selected";
				}
			}
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";		
	}
	public void Loop_openend_hours(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,String open_end) throws IOException
	{
		String hikaku_hh = "";
		
		if(open_end.equals("open"))
		{
			hikaku_hh = vDim.open_se_hh;
		}
		else
		{
			hikaku_hh = vDim.end_se_hh;
		}
		
		vDim.txt_inp_drop   = "0";		
		vDim.txt_value_drop = "0";
		for(int i=0; i<24 ;i++)
		{	
			if(!hikaku_hh.equals(""))
			{
				if(new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)).equals(hikaku_hh))
				{					
					vDim.drop_select = "selected";
				}
			}
			vDim.txt_inp_drop   = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop));
			vDim.txt_value_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_value_drop));
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
			
			vDim.txt_inp_drop   = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop   = Integer.toString(Integer.parseInt(vDim.txt_value_drop)+1);
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";	
	}
	
	public void Loop_openend_minutes(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,String open_end) throws IOException
	{
		String hikaku_hmm = "";
		
		
		if(open_end.equals("open"))
		{
			hikaku_hmm = vDim.open_se_hmm;
		}
		else
		{
			hikaku_hmm = vDim.end_se_hmm;
		}
		
		vDim.txt_inp_drop   = "0";
		vDim.txt_value_drop = "0";
		for(int i=0; i<60 ;i++)
		{	
			if(!hikaku_hmm.equals(""))
			{
				if(new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop)).equals(hikaku_hmm))
				{					
					vDim.drop_select = "selected";
				}
			}
			vDim.txt_inp_drop   = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_inp_drop));
			vDim.txt_value_drop = new DecimalFormat("00").format(Integer.parseInt(vDim.txt_value_drop));
			writeHtm_Loop_Selpriority(out,Cwlib,Pjuni,conn,vDim);
			vDim.drop_select = "";
			
			vDim.txt_inp_drop   = Integer.toString(Integer.parseInt(vDim.txt_inp_drop)+1);
			vDim.txt_value_drop = Integer.toString(Integer.parseInt(vDim.txt_value_drop)+1);
		}
		vDim.txt_inp_drop   = "";
		vDim.txt_value_drop = "";
		vDim.drop_select    = "";	
	}
	
	
	//Edit CMS method
	public void editCMSDB(PrintWriter out,CodawLib Cwlib,PjUnion Pjuni,Connection conn,NewsEntryDim vDim,HttpServletRequest request, HttpServletResponse response) throws IOException
	{
		vDim.SQLbuf= "select * from \"CMS_DB\" where \"db_master\"="+vDim.editflag+"  ";
		try
		{
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(vDim.SQLbuf);     
			if(rs.next())
			{
				vDim.txt_dbmaster        = Cwlib.getDBstring("", rs.getString("db_master"));
				vDim.txt_area_master1    = Cwlib.getDBstring("", rs.getString("area_master"));
				vDim.txt_cat1_cd1        = Cwlib.getDBstring("",rs.getString("cat1_cd"));  
				System.out.println("the value of the cat1cd"+vDim.txt_cat1_cd1);
				vDim.txt_cat2_cd1        = Cwlib.getDBstring("",rs.getString("cat2_cd"));
				System.out.println("the value of the cat2cd"+vDim.txt_cat2_cd1);
				vDim.txt_category1value1 = Pjuni.get_category1Name(vDim.txt_cat1_cd, response, out, Cwlib, conn, null);
				System.out.println("the value of the cat1cd"+vDim.txt_category1value1);
				vDim.txt_category2value1 = Pjuni.get_category2Name(vDim.txt_cat2_cd, response, out, Cwlib, conn, null);
				System.out.println("the value of the cat1cd"+vDim.txt_category2value1);
				vDim.txt_articleyear1    = Cwlib.getDBstring("",rs.getString("input01")).substring(0,4);
				vDim.txt_articlemonth1   = Cwlib.getDBstring("",rs.getString("input01")).substring(5,7);
				vDim.txt_articleday1     = Cwlib.getDBstring("",rs.getString("input01")).substring(8,10);
				vDim.txt_articlehours1   = Cwlib.getDBstring("",rs.getString("input01")).substring(11,13);
				vDim.txt_articlemin1     = Cwlib.getDBstring("",rs.getString("input01")).substring(14,16);
				
				
				vDim.txt_input011        = Cwlib.getDBstring("",rs.getString("input02"));
				vDim.txt_input022        = Cwlib.getDBstring("",rs.getString("input03"));
				
				vDim.txt_openyear1       = Cwlib.getDBstring("",rs.getString("opendt")).substring(0,4);
				vDim.txt_openmonth1      = Cwlib.getDBstring("",rs.getString("opendt")).substring(5,7);
				vDim.txt_openday1        = Cwlib.getDBstring("",rs.getString("opendt")).substring(8,10);
				vDim.txt_openhours1      = Cwlib.getDBstring("",rs.getString("opentm")).substring(0,2);
				vDim.txt_openmin1        = Cwlib.getDBstring("",rs.getString("opentm")).substring(3,5);
				
				vDim.txt_endyear1        = Cwlib.getDBstring("",rs.getString("enddt")).substring(0,4);
				vDim.txt_endmonth1       = Cwlib.getDBstring("",rs.getString("enddt")).substring(5,7);
				vDim.txt_endday1         = Cwlib.getDBstring("",rs.getString("enddt")).substring(8,10);
				vDim.txt_endhours1       = Cwlib.getDBstring("",rs.getString("endtm")).substring(0,2);
				vDim.txt_endmin1         = Cwlib.getDBstring("",rs.getString("endtm")).substring(3,5);
				vDim.txt_priority1       = Cwlib.getDBstring("",rs.getString("priority"));
				vDim.txt_img1            = Cwlib.getDBstring("",rs.getString("img"));
				
				vDim.txt_inp_opendt_yyyy = vDim.txt_openyear1;
				vDim.txt_inp_opendt_mm   = vDim.txt_openmonth1;
				vDim.txt_inp_opendt_dd   = vDim.txt_openday1;
				vDim.txt_inp_opendt_hh    =vDim.txt_openhours1;
				vDim.txt_inp_opendt_minutes=vDim.txt_openmin1;
				
				vDim.txt_inp_enddt_yyyy  = vDim.txt_endyear1;
				vDim.txt_inp_enddt_mm    = vDim.txt_endmonth1;
				vDim.txt_inp_enddt_dd    = vDim.txt_endday1;   
				vDim.txt_inp_enddt_hh    =vDim.txt_endhours1;
				vDim.txt_inp_enddt_minutes=vDim.txt_endmin1;
				
				vDim.txt_inp_articledt_yyyy 	=vDim.txt_articleyear1;
				vDim.txt_inp_articledt_mm   	=vDim.txt_articlemonth1;
				vDim.txt_inp_articledt_dd   	=vDim.txt_articleday1;
				vDim.txt_inp_articledt_hours	=vDim.txt_articlehours1;
				vDim.txt_inp_articledt_minutes	=vDim.txt_articlemin1;
				vDim.txt_area_master     = vDim.txt_area_master1;
				vDim.txt_category1value  = vDim.txt_cat1_cd1;
				vDim.txt_category2value  = vDim.txt_cat2_cd1;
				vDim.txt_title           = vDim.txt_input011;
				vDim.txt_newstext        = vDim.txt_input011;
				vDim.txt_priority        = vDim.txt_priority1;
				vDim.txt_img             = vDim.txt_img1;
			}
			rs.close();
			stmt.close();      	
		}
		catch(SQLException e)
		{
			e.printStackTrace();
			System.out.println(e);
			Cwlib.dbError(getServletInfo(),e,vDim.SQLbuf);
			out.flush();
			out.close();
			
		}
	}
	
//	***********************************************************************
//	サブルーチン PostDataGet
//	***********************************************************************
	public void PostDataGet(HttpServletRequest request,CodawLib Cwlib,NewsEntryDim vDim)
	{   
		vDim.txt_inp_articledt_yyyy    = Cwlib.postDataGet(request,"articledate_year","");	 
		vDim.txt_inp_articledt_mm      = Cwlib.postDataGet(request,"articledate_month","");
		vDim.txt_inp_articledt_dd      = Cwlib.postDataGet(request,"articledate_day","");
		vDim.txt_inp_articledt_minutes = Cwlib.postDataGet(request,"articledate_minutes","");  
		vDim.txt_inp_articledt_hours   = Cwlib.postDataGet(request,"articledate_hours","");
		
		vDim.article_now               = Cwlib.postDataGet(request,"articlenow","");
		
		if(vDim.article_now.length()>0 )
		{
			Cwlib.dateTimes();
			vDim.txt_inp_articledt_minutes 	= Cwlib.Cld_mn;
			vDim.txt_inp_articledt_hours    = Cwlib.Cld_hh;
		}
		
		//更新日時開始〜
		vDim.txt_inp_opendt_yyyy 	   = Cwlib.postDataGet(request,"public_stdate_year","");
		vDim.txt_inp_opendt_mm  	   = Cwlib.postDataGet(request,"public_stdate_month","");
		vDim.txt_inp_opendt_dd   	   = Cwlib.postDataGet(request,"public_stdate_day",""); 
		vDim.txt_inp_opendt_hh  	   = Cwlib.postDataGet(request,"public_stdate_hours","");
		vDim.txt_inp_opendt_minutes    = Cwlib.postDataGet(request,"public_stdate_minutes","");	  
		//更新日時終了〜
		vDim.txt_inp_enddt_yyyy 	   = Cwlib.postDataGet(request,"public_endate_year","");
		vDim.txt_inp_enddt_mm   	   = Cwlib.postDataGet(request,"public_endate_month","");
		vDim.txt_inp_enddt_dd   	   = Cwlib.postDataGet(request,"public_endate_day","");
		vDim.txt_inp_enddt_hh    	   = Cwlib.postDataGet(request,"public_endate_hours","");
		vDim.txt_inp_enddt_minutes     = Cwlib.postDataGet(request,"public_endate_minutes","");
		
		vDim.txt_area_master       		= Cwlib.postDataGet(request,"area","");
		vDim.txt_category1value   	 	= Cwlib.postDataGet(request, "category1","");
		vDim.txt_category2value    		= Cwlib.postDataGet(request, "category2","");
		vDim.txt_title             		= Cwlib.postDataGet(request, "title","");
		vDim.txt_newstext          		= Cwlib.postDataGet(request, "newstext","");
		vDim.txt_priority          		= Cwlib.postDataGet(request, "priority","");
		vDim.txt_img               		= Cwlib.postDataGet(request, "img","");
		vDim.open_now                  	= Cwlib.postDataGet(request,"opennow","");
		vDim.end_now                   	= Cwlib.postDataGet(request,"endnow","");
		
		if(vDim.open_now.length()>0 )
		{
			Cwlib.dateTimes();
			vDim.txt_inp_opendt_hh  	   = Cwlib.Cld_hh;
			vDim.txt_inp_opendt_minutes    = Cwlib.Cld_mn;
		}
		else if(vDim.end_now.length()>0)
		{
			Cwlib.dateTimes();
			vDim.txt_inp_enddt_hh    	   = Cwlib.Cld_hh; 
			vDim.txt_inp_enddt_minutes     = Cwlib.Cld_mn;
		}
	}
	
	
//	***********************************************************************
//	サブルーチン session_postdata_set
//	***********************************************************************
	public void session_set(NewsEntryDim vDim,CodawLib Cwlib,HttpSession session)
	{		
		session.setAttribute("session_flg1","true");
		
		session.setAttribute("articleyear",vDim.txt_inp_articledt_yyyy);
		session.setAttribute("articlemonth",vDim.txt_inp_articledt_mm);
		session.setAttribute("articledate",vDim.txt_inp_articledt_dd);
		session.setAttribute("articlehours",vDim.txt_inp_articledt_hours);
		session.setAttribute("articleminutes",vDim.txt_inp_articledt_minutes);
		
		session.setAttribute("open_yyyy_select1",vDim.txt_inp_opendt_yyyy);
		session.setAttribute("open_mm_select1",vDim.txt_inp_opendt_mm);
		session.setAttribute("open_dd_select1",vDim.txt_inp_opendt_dd);
		
		session.setAttribute("end_yyyy_select1",vDim.txt_inp_enddt_yyyy);
		session.setAttribute("end_mm_select1",vDim.txt_inp_enddt_mm);
		session.setAttribute("end_dd_select1",vDim.txt_inp_enddt_dd);
		
		session.setAttribute("open_hh",vDim.txt_inp_opendt_hh);
		session.setAttribute("open_mm",vDim.txt_inp_opendt_minutes);
		
		session.setAttribute("end_hh",vDim.txt_inp_enddt_hh);
		session.setAttribute("end_mm",vDim.txt_inp_enddt_minutes);
		
		session.setAttribute("se_inp_status",vDim.txt_inp_status_flg);
		
		session.setAttribute("areamasterselect1",vDim.txt_area_master);
		session.setAttribute("cat1",vDim.txt_category1value);
		session.setAttribute("cat2",vDim.txt_category2value);
		session.setAttribute("title",vDim.txt_title);
		session.setAttribute("newstext",vDim.txt_newstext);
		session.setAttribute("priority",vDim.txt_priority);
		session.setAttribute("img",vDim.txt_img);
		session.setAttribute("db_master",vDim.txt_dbmaster);
		
	}
	
	
//	***********************************************************************
//	サブルーチン session_get
//	***********************************************************************
	public void session_get(NewsEntryDim vDim,CodawLib Cwlib,HttpSession session)
	{		
		Cwlib.getSessionString("","session_flg1", session);
		
		vDim.txt_inp_articledt_yyyy         = Cwlib.getSessionString("","articleyear",session);
		vDim.txt_inp_articledt_mm          	= Cwlib.getSessionString("","articlemonth",session);
		vDim.txt_inp_articledt_dd         			= Cwlib.getSessionString("","articledate",session);
		vDim.txt_inp_articledt_hours          			= Cwlib.getSessionString("","articlehours",session);
		vDim.txt_inp_articledt_minutes         			= Cwlib.getSessionString("","articleminutes",session);
		
		vDim.open_se_yyyy         			= Cwlib.getSessionString("","open_yyyy_select1",session);		  
		vDim.open_se_mm            			= Cwlib.getSessionString("","open_mm_select1",session);		  
		vDim.open_se_dd           			= Cwlib.getSessionString("","open_dd_select1",session);	
		
		vDim.end_se_yyyy  		   			= Cwlib.getSessionString("","end_yyyy_select1",session);
		vDim.end_se_mm   		   			= Cwlib.getSessionString("","end_mm_select1",session);
		vDim.end_se_dd  		  			= Cwlib.getSessionString("","end_dd_select1",session); 
		
		vDim.txt_area       	  			= Cwlib.getSessionString("","areamasterselect1",session);
		vDim.txt_category1value    			= Cwlib.getSessionString("","cat1",session);
		vDim.txt_category2value    			= Cwlib.getSessionString("","cat2",session);
		vDim.txt_title             			= Cwlib.getSessionString("","title",session); 
		vDim.txt_newstext          			= Cwlib.getSessionString("","newstext",session);
		vDim.txt_priority      				= Cwlib.getSessionString("","priority",session);
		vDim.txt_img               			= Cwlib.getSessionString("","img",session);
		
		vDim.open_se_hh            			= Cwlib.getSessionString("","open_hh",session);
		vDim.end_se_hh             			= Cwlib.getSessionString("","end_hh",session);
		
		vDim.open_se_hmm           			= Cwlib.getSessionString("","open_mm",session);
		vDim.end_se_hmm            			= Cwlib.getSessionString("","end_mm",session);
		
		if(!vDim.open_se_yyyy.equals("")&&!vDim.open_se_mm.equals(""))		  
		{
			GregorianCalendar gen_month = new GregorianCalendar(Integer.parseInt(vDim.open_se_yyyy),Integer.parseInt(vDim.open_se_mm)-1,1);
			vDim.open_number_of_days = Integer.toString(gen_month.getActualMaximum(Calendar.DATE));
			if(Cwlib.chkNum(vDim.open_se_dd)&&!vDim.open_se_dd.equals(""))
			{
				if(Integer.parseInt(vDim.open_number_of_days) <= Integer.parseInt(vDim.open_se_dd))
				{
					vDim.open_se_dd = vDim.open_number_of_days;
					//vDim.area_se_areamaster = Cwlib.getSessionString("","areamasterselect1",session);
				}
			}
		}
		//月のみ選んだ時
		else if(vDim.open_se_yyyy.trim().length()==0&&Cwlib.chkNum(vDim.open_se_mm)&&vDim.open_se_mm.trim().length()>0)
		{
			GregorianCalendar gen_month = new GregorianCalendar(-1,Integer.parseInt(vDim.open_se_mm)-1,1);
			vDim.open_number_of_days = Integer.toString(gen_month.getActualMaximum(Calendar.DATE));
			//vDim.area_se_areamaster = Cwlib.getSessionString("","areamasterselect1",session);
		}	  
		
		//月と年を選んだ場合		  
		if(!vDim.end_se_yyyy.equals("")&&!vDim.end_se_mm.equals(""))
		{
			GregorianCalendar gen_month = new GregorianCalendar(Integer.parseInt(vDim.end_se_yyyy),Integer.parseInt(vDim.end_se_mm)-1,1);
			vDim.end_number_of_days = Integer.toString(gen_month.getActualMaximum(Calendar.DATE));
			if(Cwlib.chkNum(vDim.end_se_dd)&&!vDim.end_se_dd.equals(""))
			{
				if(Integer.parseInt(vDim.end_number_of_days) <= Integer.parseInt(vDim.end_se_dd))
				{
					vDim.end_se_dd = vDim.end_number_of_days;
					// vDim.area_se_areamaster = Cwlib.getSessionString("","areamasterselect1",session);
				}
			}
		}
		//月のみ選んだ時
		else if(vDim.end_se_yyyy.trim().length()==0&&Cwlib.chkNum(vDim.end_se_mm)&&vDim.end_se_mm.trim().length()>0)
		{
			GregorianCalendar gen_month = new GregorianCalendar(-1,Integer.parseInt(vDim.end_se_mm)-1,1);
			vDim.end_number_of_days = Integer.toString(gen_month.getActualMaximum(Calendar.DATE));
			// vDim.area_se_areamaster = Cwlib.getSessionString("","areamasterselect1",session);
		}
		//ステータスのセット
		
	}
	
	
	
//	***********************************************************************
	//  サブルーチン session_remove
	//***********************************************************************
	public void session_remove(NewsEntryDim vDim,CodawLib Cwlib,HttpSession session)
	{	
		session.removeAttribute("master_key");//承認用
		session.removeAttribute("session_flg1");
		
		
		session.removeAttribute("articleyear");
		session.removeAttribute("articlemonth");
		session.removeAttribute("articledate");    
		session.removeAttribute("articlehours");
		session.removeAttribute("articleminutes");
		
		
		session.removeAttribute("open_yyyy_select1");
		session.removeAttribute("open_mm_select1");
		session.removeAttribute("open_dd_select1");    
		session.removeAttribute("end_yyyy_select1");
		session.removeAttribute("end_mm_select1");
		session.removeAttribute("end_dd_select1"); 
		
		session.removeAttribute("open_hh");
		session.removeAttribute("open_mm");
		session.removeAttribute("end_hh");
		session.removeAttribute("end_mm");	
		
		session.removeAttribute("areamasterselect1");
		session.removeAttribute("se_inp_status");
		session.removeAttribute("se_inp_status");
		session.removeAttribute("areamasterselect1");
		session.removeAttribute("cat1");
		session.removeAttribute("cat2");
		session.removeAttribute("title");
		session.removeAttribute("newstext");
		session.removeAttribute("priority");
		session.removeAttribute("img");
		session.removeAttribute("db_master");
	}
	
	
	//Error Check
	
	private boolean err_chk(HttpSession session, PrintWriter out,	CodawLib Cwlib, PjUnion Pjuni, Connection conn, NewsEntryDim vDim,HttpServletRequest request,HttpServletResponse response) throws IOException 
	{
		System.out.println("inside of the err_chk");
		//boolean chkuser_id=Pjuni.check_userID(vDim.txt_input01, response, out, Cwlib, conn, null);		
	
		
		
		if(vDim.txt_area_master.trim().length()==0) 
		{			
			vDim.txt_error += "<font color=\"blue\"><b> エリアを選択してください。</b></font><br>";
		}
		
		if(vDim.txt_category1value.trim().length()==0) 
		{			
			vDim.txt_error += "<font color=\"blue\"><b> カテゴリー1 を入力してください。</b></font><br>";
		}
		
		if(vDim.txt_category2value.trim().length()==0) 
		{			
			vDim.txt_error += "<font color=\"blue\"><b> カテゴリー2 を入力してください。</b></font><br>";
		}
		
		if(vDim.txt_inp_articledt_yyyy.trim().length()==0||vDim.txt_inp_articledt_mm.trim().length()==0||vDim.txt_inp_articledt_dd.trim().length()==0||vDim.txt_inp_articledt_minutes.trim().length()==0||vDim.txt_inp_articledt_hours.trim().length()==0)
		{
			vDim.txt_error += "<font color=\"blue\"><b> 記事日付を正しく選択してください。</b></font><br>";				
		}
		
		if(vDim.txt_title.trim().length()==0)
		{
			vDim.txt_error += "<font color=\"blue\"><b>タイトルを入力してください。</b></font><br>";
		}
		
		if(vDim.txt_newstext.trim().equals(""))
		{
			vDim.txt_error += "<font color=\"blue\"><b>本文を入力してください。</b></font><br>";
		}
		if(vDim.txt_newstext.trim().length()>124)
		{
			vDim.txt_error += "<font color=\"blue\"><b>コメントは124文字以下で入力してください。</b></font><br>";
		}
		
		//This Public opening date
		if(vDim.txt_inp_opendt_yyyy.trim().length()==0||vDim.txt_inp_opendt_mm.trim().length()==0||vDim.txt_inp_opendt_dd.trim().length()==0||vDim.txt_inp_opendt_hh.trim().length()==0||vDim.txt_inp_opendt_minutes.trim().length()==0)
		{
			vDim.txt_error += "公開開始日付を正しく選択してください。<br>";				
		}
		//this is for public end date
		if(vDim.txt_inp_enddt_yyyy.trim().length()==0||vDim.txt_inp_enddt_mm.trim().length()==0||vDim.txt_inp_enddt_dd.trim().length()==0||vDim.txt_inp_enddt_hh.trim().length()==0||vDim.txt_inp_enddt_minutes.trim().length()==0)
		{
			vDim.txt_error += "公開開始日付を正しく選択してください。<br>";				
		}
		
		
		if (vDim.txt_error.length() > 0) 
		{
			try 
			{
				Cwlib.dspMsg.Dsp_Msg(request, response, out, "ユーザー登録",vDim.txt_error,"onclick=\"history.back()\"");
				
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			} 
			return true;
    	}
		else 
		{
			return false;
		}
	}	
	
	//++++++++++++++++++++++++++++++++++++++++++++++++++
	//  ここまで自作関数の記述を行う
	//++++++++++++++++++++++++++++++++++++++++++++++++++
	
}