' $System.Access Form
' $Command.Form.AccessFile $BS
' If $System.IsPost
'  If $Mode or ( $Mode = 0 )
<!--#include file="PartsChangeCondition.html"-->
'   $Search = 1
'   $System.ContentType
'  Else
'   $System.Redirect $Server/documents.csv?page=FormExportFile&wid=$WID&bs=$BS&vid=$VID&ct=1&oencoding=$xoencoding
'   $Command.Form.SetPersonalExport
'   Exit
'  EndIf
' EndIf
' $AppliName = $WorkSpace.Forms.$BS.Name
<!--#include file="LibraryCommon.html"-->
<!--#include file="LibraryForm.html"-->
' Call cmHtmlHead
' If $Env.IsMSIE
' Call cmLoadJavaScript "member_ie"
' Else
' Call cmLoadJavaScript "member_nn"
' EndIf
<!--#include file="PartsFormCondition.html"-->
' $System.SetParameter CaptionTitle "履歴データの書き出し"
' Call cmHead $CaptionTitle
</head>
<body>
' $System.SetParameter BackURL "$Server?page=FormFile&wid=$WID&bs=$BS&vid=$VID"
' Call cmHeader $CaptionTitle "$Server?page=FormIndex&wid=$WID&bs=$BS&vid=$VID" $AppliName $BackURL "ファイル入出力"
' $System.CloseDatabase "mw"
' Set $FormProfile = $Command.Form.GetFormTop $BS
' Set $FormIndex = $Command.Form.GetFormIndex $BS
<form name="FormExport" method="post" action="$Server?">
<input type="hidden" name="CSRFTicket" value="$System.MakeCSRFKey">
<input type="hidden" name="Page" value="FormExport">
<input type="hidden" name="WID" value="$WID">
<input type="hidden" name="BS" value="$BS">
<input type="hidden" name="VID" value="$VID">
<input type="hidden" name="Mode" value="">
<input type="hidden" name="Remove" value="">
''
' $DateTimeType = $FormProfile.DateTime.Type
' If ( $DateTimeType = 2 ) or ( $DateTimeType = 3 )
'  $DateTimeLabel = "日付, 時刻"
' Else
'  $DateTimeLabel = "日付"
' EndIf
''
' If $CC
<input type="hidden" name="CC" value="$CC">
' Else
'  Set $Export = $Command.Form.GetPersonalExport $BS
'  If $Export
'   $ItemName = $Export.ItemName
'   $Span = $Export.Span
'   $SetDate = $Export.SetDate
'   $EndDate = $Export.EndDate
'   $Search = $Export.Search
'   $OR = $Export.OR
'   $Fuzzy = $Export.Fuzzy
'   Set $Conditions = $Export.Conditions
'   For Each $Item in $Export.Items
'    If $Item.Item
'     $System.AddParameter IIDs $Item.Item
'    Else
'     $ItemID = $Item.IID
'     If $FormProfile.Items.$ItemID
'      $System.AddParameter IIDs $ItemID
'     EndIf
'    EndIf
'   Next
'  Else
'   $ItemName = 1
'   $Span = 3
'   If ( $DateTimeType = 2 ) or ( $DateTimeType = 3 )
'    $System.AddParameter IIDs "DateAndTime"
'   Else
'    $System.AddParameter IIDs "DateTime"
'   EndIf
'   $System.AddParameter IIDs "CTime"
'   $System.AddParameter IIDs "Creator"
'   $System.AddParameter IIDs "Code"
'   $System.AddParameter IIDs "Subject"
'   $System.AddParameter IIDs "Customers"
'   For Each $Item in $FormProfile.Items
'    $System.AddParameter IIDs $Item.ID
'   Next
'   $System.AddParameter IIDs "Comment"
'   $System.AddParameter IIDs "FileName"
'  EndIf
'  If $Conditions.Count
<input type="hidden" name="CC" value="$Conditions.Count">
'  Else
<input type="hidden" name="CC" value="1">
'  EndIf
' EndIf
<p>$AppliNameデータをCSVファイルに書き出します。</p>
<p><img src="$IMG_PATH/pin.png"> 出力対象</p>
<blockquote>
<table border="0" cellspacing="0" cellpadding="4">
<tr><td valign="top" nowrap>期間</td>
<td nowrap>
' Call formRadio "Span" "本日" $Span.Checked_1 1 "today"
' Call formRadio "Span" "過去1週間" $Span.Checked_2 2 "week"
' Call formRadio "Span" "過去1ヶ月" $Span.Checked_3 3 "month"
' Call formRadio "Span" "過去3ヶ月" $Span.Checked_7 7 "three"
' Call formRadio "Span" "過去6ヶ月" $Span.Checked_8 8 "six"
' Call formRadio "Span" "過去1年" $Span.Checked_4 4 "year"
' Call formRadio "Span" "全て" $Span.Checked_5 5 "everytime"
<br>
' Call formRadio "Span" "期間指定" $Span.Checked_6 6 "date"
(
' Call formDateSpan "SetDate" "EndDate" "FormExport" 0 $SetDate $EndDate "Span[7].checked=true;"
)
</td></tr>
</table>
</blockquote>
<p><img src="$IMG_PATH/pin.png"> 出力条件</p>
<blockquote>
<p>
' Call formRadio "Search" "$AppliNameを全て出力する" $Search.RChecked 0 "SearchAll"
</p><p>
' Call formRadio "Search" "$AppliNameを絞り込んで出力する" $Search.Checked 1 "SearchFilter"
</p>
<table border="0" cellspacing="0" cellpadding="2">
<tr><td width="20"><br></td><td colspan="3">
<!--#include file="LibrarySearchCondition.html"-->
' Call searchCondition "Search[1].checked=true;"
</td></tr>
' If $CC
'  $Num = $CC - 1
'  For $i = 0 to $Num
'   $IID = $System.GetParameter IID$i
'   $Text = $System.GetParameter Text$i
'   $Expr = $System.GetParameter Expr$i
'   $Value = $System.GetParameter Value$i
'   Call QueryConditionRow $FormProfile $i $IID $Text $Expr $Value $Num "FormExport" "PreSubmit( this.form, 'Items', 'IIDs' );"
'  Next
' Elif $Conditions
'  $CC = 0
'  If $Conditions.Count
'   $Num = $Conditions.Count - 1
'  Else
'   $Num = 0
'  EndIf
'  For Each $Cond in $Conditions
'   Call QueryConditionRow $formProfile $CC $Cond.IID $Cond.Text $Cond.Expr $Cond.Value $Num "FormExport" "PreSubmit( this.form, 'Items', 'IIDs' );"
'   Inc $CC
'  Next
' EndIf
' If ! $CC
'  Call QueryConditionRow $FormProfile 0 $IID $Text $Expr $Value 0 "FormExport" "PreSubmit( this.form, 'Items', 'IIDs' );"
' EndIf
<tr><td><br></td><td colspan="3">
' Call cmButton "条件を追加する" "Mode.value='add';PreSubmit( this.form, 'Items', 'IIDs' );this.form.submit();"
</td></tr>
</table>
</blockquote>
<p><img src="$IMG_PATH/pin.png"> 出力項目</p>
<blockquote>
<table border="0" cellspacing="0" cellpadding="2">
<tr><td align="middle">
' Call cmImageButton "Top( this.form, 'IIDs' ); return false;" "order_top20.png"
<br><br>
' Call cmImageButton "Up( this.form, 'IIDs' ); return false;" "order_up20.png"
<br><br>
' Call cmImageButton "Down( this.form, 'IIDs' ); return false;" "order_down20.png"
<br><br>
' Call cmImageButton "Bottom( this.form, 'IIDs' ); return false;" "order_bottom20.png"
</td>
<td nowrap rowspan="4">
<select name="IIDs" multiple size="15">
' For Each $IID in $IIDs
'  If $IID = "DateAndTime"
<option value="$IID">日時</option>
'  Elif $IID = "DateTime"
<option value="$IID">$DateTimeLabel</option>
'  Elif $IID = "CTime"
<option value="$IID">作成日時</option>
'  Elif $IID = "Creator"
<option value="$IID">作成者</option>
'  Elif $IID = "Code"
<option value="$IID">番号</option>
'  Elif $IID = "Subject"
<option value="$IID">件名</option>
'  Elif $IID = "Customers"
<option value="$IID">顧客</option>
'  Elif $IID = "Customer1"
<option value="$IID">顧客1 (コード, 会社名, 名前)</option>
'  Elif $IID = "Customer2"
<option value="$IID">顧客2 (コード, 会社名, 名前)</option>
'  Elif $IID = "Customer3"
<option value="$IID">顧客3 (コード, 会社名, 名前)</option>
'  Elif $IID = "FileName"
'   If $FormProfile.File.Size != 0
<option value="$IID">添付ファイル名</option>
'   EndIf
'  Elif $IID = "Comment"
<option value="$IID">コメント</option>
'  Else
'   Set $Item = $FormProfile.Items.$IID
'   If $Item
<option value="$IID">$Item.Name</option>
'   EndIf
'  EndIf
' Next
<option>　　　　　　　　　　　　　　　　　　　　</option>
</select>
</td>
<td nowrap valign="middle">
' Call cmButton "<< 追加" "AddMember( this.form, 'Items', 'IIDs' );"
<br><br>
' Call cmButton "削除 >>" "RemoveMember( this.form, 'IIDs' );"
</td>
<td nowrap>
<select name="Items" multiple size="15">
' If ( $DateTimeType = 2 ) or ( $DateTimeType = 3 )
<option value="DateAndTime">日時</option>
' EndIf
<option value="DateTime">$DateTimeLabel</option>
<option value="CTime">作成日時</option>
<option value="Creator">作成者</option>
<option value="Code">番号</option>
<option value="Subject">件名</option>
<option value="Customers">顧客</option>
<option value="Customer1">顧客1 (コード, 会社名, 名前)</option>
<option value="Customer2">顧客2 (コード, 会社名, 名前)</option>
<option value="Customer3">顧客3 (コード, 会社名, 名前)</option>
' For Each $Item in $FormProfile.Items
<option value="$Item.ID">$Item.Name</option>
' Next
' If $FormProfile.File.Size != 0
<option value="FileName">添付ファイル名</option>
' EndIf
<option value="Comment">コメント</option>
<option>　　　　　　　　　　　　　　　　　　　　</option>
</select>
</td></tr>
</table>
</blockquote>
<p><img src="$IMG_PATH/pin.png"> その他の設定</p>
<blockquote>
<table border="0" cellspacing="0" cellpadding="4">
<tr><td colspan="2">
' Call formCheckBox "ItemName" "先頭行に項目名を書き出す" $ItemName 1 "ItemName"
</td></tr>
<tr><td valign="top" nowrap>文字コード</td>
<td nowrap>
' Call formOEncoding "xoencoding"
</td></tr>
</table>
</blockquote>
<p class="formCommit">
' Call cmButton "書き出す" "PreSubmit( this.form, 'Items', 'IIDs' );this.form.submit();"
' Call cmButton "キャンセルする" "location.href='$BackURL.JSEscape';"
</p>
' If $Storages.Count and ( ! $VID )
<div class="desc">このファイル出力は、現在のデータを対象としています。</div>
<!--#include file="LibraryBackNavigation.html"-->
<div class="desc">
'  Call backNavigation "&wid=$WID&bs=$BS"
</div>
' EndIf
</form>
' Call cmFooter $BackURL "ファイル入出力へ"
</body>
</html>