<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="5.4.6" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41546.6611873611" ReportOptions.Description.Text="" ReportOptions.LastChange="42401.1702737963" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;procedure DialogPage1OnActivate(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  &#13;&#10;&#13;&#10;    &#13;&#10;  date1.date:=now-30 ;&#13;&#10;  date2.date:=now ;&#13;&#10;&#13;&#10;                                                               &#13;&#10;                                              &#13;&#10;    &#13;&#10;    &#13;&#10;end;&#13;&#10;&#13;&#10;&#13;&#10;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="qry_rp" DataSetName="rp"/>
    <item DataSet="qry_stock" DataSetName="stock"/>
  </Datasets>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxUniDACQuery Name="qry_rp" UserName="rp" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT T.USER_ID,SUM(PO) as PO, SUM(ITEM_PO) as ITEM_PO,&#13;&#10;SUM(IVO) as IVO, SUM(IVO_ITEM) as IVO_ITEM,SUM(DIS) as DIS,SUM(DIS_ITEM) as DIS_ITEM,SUM(ACC) as ACC,SUM(ACC_ITEM) as ACC_ITEM&#13;&#10;FROM(    &#13;&#10;select c.USER_ID, COUNT(DISTINCT m.REF_NO) as PO, COUNT(c.WORKING_CODE) as ITEM_PO,&#13;&#10;0 as IVO, 0 as IVO_ITEM,0 as DIS,0 as DIS_ITEM,0 as ACC,0 as ACC_ITEM&#13;&#10;from MS_PO_C c (NOLOCK)&#13;&#10;left join MS_PO m (NOLOCK) on (c.PO_NO=m.PO_NO)&#13;&#10;where c.PO_DATE BETWEEN :d1  and :d2&#13;&#10;group by c.USER_ID&#13;&#10;UNION&#13;&#10;select c.USER_ID, 0 as PO, 0 as ITEM_PO,&#13;&#10;COUNT(DISTINCT m.RECEIVE_NO) as IVO, COUNT(c.WORKING_CODE) as IVO_ITEM,0 as DIS,0 as DIS_ITEM,0 as ACC,0 as ACC_ITEM&#13;&#10;from MS_IVO_C c (NOLOCK)&#13;&#10;left join MS_IVO m (NOLOCK) on (c.INVOICE_NO = m.INVOICE_NO)&#13;&#10;where m.RECEIVE_DATE BETWEEN :d1  and :d2&#13;&#10;group by c.USER_ID&#13;&#10;UNION&#13;&#10;select c.USER_ID, 0 as PO, 0 as ITEM_PO,&#13;&#10;0 as IVO, 0 as IVO_ITEM,COUNT(DISTINCT c.SUB_PO_NO) as DIS,COUNT(c.WORKING_CODE) as DIS_ITEM,0 as ACC,0 as ACC_ITEM&#13;&#10;from SM_PO_C c (NOLOCK)&#13;&#10;left join SM_PO m (NOLOCK) on (c.SUB_PO_NO = m.SUB_PO_NO)&#13;&#10;where m.SUB_PO_DATE BETWEEN :d1  and :d2&#13;&#10;group by c.USER_ID&#13;&#10;UNION&#13;&#10;select a.USER_ID, 0 as PO, 0 as ITEM_PO,&#13;&#10;0 as IVO, 0 as IVO_ITEM,0 as DIS,0 as DIS_ITEM,&#13;&#10;COUNT(DISTINCT a.REQ_NO) as ACC,COUNT(a.WORKING_CODE) as ACC_ITEM&#13;&#10;from ACCR_DISP a (NOLOCK)&#13;&#10;where   a.REQ_DATE BETWEEN :d1  and :d2         &#13;&#10;group by a.USER_ID) as T&#13;&#10;GROUP BY T.USER_ID                " SpecificOptions.Text="" PropData="05704C65667402000470546F7002000A506172616D657465727301010C51000000204E616D653D226431222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C51000000204E616D653D226432222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E64617465292200010C51000000204E616D653D226431222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C51000000204E616D653D226432222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E64617465292200010C51000000204E616D653D226431222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C51000000204E616D653D226432222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E64617465292200010C51000000204E616D653D226431222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465312E64617465292200010C51000000204E616D653D226432222044617461547970653D226674537472696E67222045787072657373696F6E3D22466F726D61744461746554696D652827595959596D6D6464272C64617465322E6461746529220000"/>
    <TfrxUniDACQuery Name="qry_stock" UserName="stock" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="select * from DEPT_ID (NOLOCK) where (HIDE='' or HIDE is null)     &#13;&#10;and INV_TYPE='99'  " SpecificOptions.Text="" PropData="05704C65667402000470546F7002580A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="30.23624" Left="0" Top="291.02381" Width="718.1107">
      <TfrxMemoView Name="Memo1" Left="647.5201" Top="2" Width="68.03154" Height="22.67718" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Page#]"/>
    </TfrxPageFooter>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="31.7953" Left="0" Top="200.31509" Width="718.1107" ColumnWidth="0" ColumnGap="0" DataSet="qry_rp" DataSetName="rp" RowCount="0" Stretched="True">
      <TfrxMemoView Name="rpDEPT_NAME" ShiftMode="smWhenOverlapped" Left="2" Top="1.55906" Width="151.1812" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="[Line#]. [rp.&#34;USER_ID&#34;]"/>
      <TfrxMemoView Name="Memo16" Left="156.28355" Top="1" Width="64.25201" Height="26.45671" DataField="PO" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;PO&#34;]"/>
      <TfrxMemoView Name="rpITEM_PO" Left="227.33086" Top="1" Width="75.5906" Height="26.45671" DataField="ITEM_PO" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;ITEM_PO&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="312.24428" Top="1" Width="52.91342" Height="26.45671" DataField="IVO" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;IVO&#34;]"/>
      <TfrxMemoView Name="rpIVO_ITEM" Left="365.39394" Top="1" Width="75.5906" Height="26.45671" DataField="IVO_ITEM" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;IVO_ITEM&#34;]"/>
      <TfrxMemoView Name="rpDIS_ITEM" Left="443.98454" Top="0.77953" Width="56.69295" Height="26.45671" DataField="DIS_ITEM" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;DIS_ITEM&#34;]"/>
      <TfrxMemoView Name="rpDIS_ITEM1" Left="501.67749" Top="1" Width="68.03154" Height="26.45671" DataField="DIS_ITEM" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;DIS_ITEM&#34;]"/>
      <TfrxMemoView Name="Memo18" Left="571.48856" Top="1" Width="56.69295" Height="26.45671" DataField="ACC" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;ACC&#34;]"/>
      <TfrxMemoView Name="rpACC_ITEM" Left="630.40198" Top="1" Width="75.5906" Height="26.45671" DataField="ACC_ITEM" DataSet="qry_rp" DataSetName="rp" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[rp.&#34;ACC_ITEM&#34;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="120.94496" Left="0" Top="18.89765" Width="718.1107">
      <TfrxMemoView Name="Memo2" Left="2" Top="2" Width="714.33117" Height="52.91342" AllowHTMLTags="True" Font.Charset="1" Font.Color="0" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="&#60;b&#62;สรุปภาระงาน&#60;/b&#62;&#13;&#10;ตั้งแต่วันที่ [formatdatetime('dd/mm/YYYY',date1.date)] ถึงวันที่  [formatdatetime('dd/mm/YYYY',date2.date)] "/>
      <TfrxLineView Name="Line1" Left="2.77953" Top="59.47248" Width="714.33117" Height="0" Color="0" Frame.Color="12632256" Diagonal="True"/>
      <TfrxLineView Name="Line2" Left="0" Top="116.72449" Width="718.1107" Height="0" Color="0" Frame.Color="12632256" Diagonal="True"/>
      <TfrxMemoView Name="Memo3" ShiftMode="smWhenOverlapped" Left="44.91342" Top="73.47248" Width="79.37013" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รหัสผู้ใช้งาน"/>
      <TfrxMemoView Name="Memo4" ShiftMode="smWhenOverlapped" Left="231.99227" Top="63.47248" Width="37.7953" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="สั่งซื้อ"/>
      <TfrxMemoView Name="Memo5" ShiftMode="smWhenOverlapped" Left="372.953" Top="60.47248" Width="26.45671" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รับ"/>
      <TfrxMemoView Name="Memo6" ShiftMode="smWhenOverlapped" Left="490.77984" Top="60.47248" Width="64.25201" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ขอเบิก/โอน"/>
      <TfrxMemoView Name="Memo7" ShiftMode="smWhenOverlapped" Left="633.06339" Top="60.47248" Width="41.57483" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ค้างจ่าย"/>
      <TfrxLineView Name="Line3" Left="198.7718" Top="88.70872" Width="517.79561" Height="0" Color="0" Frame.Color="12632256" Diagonal="True"/>
      <TfrxMemoView Name="Memo8" ShiftMode="smWhenOverlapped" Left="199.55133" Top="90.70872" Width="22.67718" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ใบ"/>
      <TfrxMemoView Name="Memo9" ShiftMode="smWhenOverlapped" Left="263.46475" Top="90.70872" Width="41.57483" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รายการ"/>
      <TfrxMemoView Name="Memo10" ShiftMode="smWhenOverlapped" Left="344.49629" Top="90.70872" Width="22.67718" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ใบ"/>
      <TfrxMemoView Name="Memo11" ShiftMode="smWhenOverlapped" Left="398.40971" Top="90.70872" Width="41.57483" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รายการ"/>
      <TfrxMemoView Name="Memo12" ShiftMode="smWhenOverlapped" Left="477.44125" Top="90.70872" Width="22.67718" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ใบ"/>
      <TfrxMemoView Name="Memo13" ShiftMode="smWhenOverlapped" Left="529.1342" Top="90.70872" Width="41.57483" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รายการ"/>
      <TfrxMemoView Name="Memo14" ShiftMode="smWhenOverlapped" Left="605.94527" Top="90.70872" Width="22.67718" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="ใบ"/>
      <TfrxMemoView Name="Memo15" ShiftMode="smWhenOverlapped" Left="665.19728" Top="90.70872" Width="41.57483" Height="26.45671" StretchMode="smActualHeight" DataSet="qry_rp" DataSetName="rp" Font.Charset="1" Font.Color="-16777208" Font.Height="-19" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" Text="รายการ"/>
    </TfrxPageHeader>
  </TfrxReportPage>
  <TfrxDialogPage Name="DialogPage1" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="0" Caption="ÊÃػÀÒÃЧҹ" Height="236" ClientHeight="198" Left="371" Top="208" Width="453" ClientWidth="437" OnActivate="DialogPage1OnActivate">
    <TfrxDateEditControl Name="date1" Left="109" Top="52" Width="97" Height="25" ShowHint="True" Color="-16777211" Date="41559.6971358681" Time="41559.6971358681" WeekNumbers="False"/>
    <TfrxDateEditControl Name="date2" Left="277" Top="52" Width="101" Height="25" ShowHint="True" Color="-16777211" Date="41559.6971358681" Time="41559.6971358681" WeekNumbers="False"/>
    <TfrxBitBtnControl Name="" Left="180" Top="115" Width="87" Height="33" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Glyph.PropData="04446174610AE2010000DE010000424DDE01000000000000760000002800000024000000120000000100040000000000680100000000000000000000100000000000000000000000000080000080000000808000800000008000800080800000C0C0C000808080000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF003333333333333333333333333333333333330000333333333333333333333333F3333333333300003333344333333333333333388F3333333333000033334224333333333333338338F3333333330000333422224333333333333833338F3333333300003342222224333333333383333338F3333333000034222A22224333333338F338F3338F33333300003222A3A2224333333338F3838F338F33333300003A2A333A222433333338F83338F338F33333000033A33333A222433333338333338F338F33330000333333333A222433333333333338F338F33300003333333333A222433333333333338F338F33000033333333333A222433333333333338F338F30000333333333333A222433333333333338F338F00003333333333333A224333333333333338F38F000033333333333333A223333333333333338F830000333333333333333A3333333333333333383300003333333333333333333333333333333333330000" Kind="bkOK" Caption="OK" ModalResult="1" NumGlyphs="2"/>
    <TfrxLabelControl Name="Label1" Left="41" Top="50" Width="57" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="µÑé§áµèÇѹ·Õè" Color="16768462"/>
    <TfrxLabelControl Name="Label2" Left="225" Top="50" Width="41" Height="29" Font.Charset="0" Font.Color="-16777208" Font.Height="-21" Font.Name="AngsanaUPC" Font.Style="0" ParentFont="False" ShowHint="True" Caption="¶֧Çѹ·Õè" Color="16768462"/>
  </TfrxDialogPage>
</TfrxReport>
