view release on metacpan or  search on metacpan

ex/jrnllist.xml  view on Meta::CPAN

<perldata>
  <hashref>
    <item key="database" >
      <hashref>
        <item key="dbtype" >Pg</item>
        <item key="dbname" >test</item>
        <item key="host" >localhost</item>
        <item key="password" />
        <item key="username" />
      </hashref>
    </item>
    <item key="search" >
      <hashref>
        <item key="!Fields" >number, gl_acctname.name, dim2, entrydate,
        entereddr as debit, enteredcr as credit, 
        entereddr - enteredcr AS total, text,
        gl_batch.batchnr || '/' || journalnr AS id</item>
        <item key="!Table" >gl_journal, gl_acctgrid, gl_chartofaccount, gl_acctname</item>
        <item key="!TabJoin" >gl_acctname JOIN gl_chartofaccount USING (ac_id)
        JOIN gl_acctgrid ON (coa_id = dim1)
        JOIN gl_journal USING (ag_id)
        JOIN gl_batch USING (batch_id)</item>
        <item key="$where" >number BETWEEN ? AND ?
        AND entrydate BETWEEN ? AND ?</item>
        <item key="$order" >number, dim2, entrydate</item>
        <item key="$values" >
          <arrayref>
            <item key="0" >10000</item>
            <item key="1" >19999</item>
            <item key="2" >2003-1-1</item>
            <item key="3" >2003-3-1</item>
          </arrayref>
        </item>
      </hashref>
    </item>
    <item key="report" >
      <hashref>
        <item key="locale" >da_DK</item>
        <item key="papersize" >A4</item>
      </hashref>
    </item>
    <item key="breaks" >
      <hashref>
        <item key="_total" >
          <hashref>
            <item key="format" >%.2f</item>
            <item key="order" >2</item>
            <item key="text" />
            <item key="total" >
              <arrayref>
                <item key="0" >debit</item>
                <item key="1" >credit</item>
                <item key="2" >total</item>
              </arrayref>
            </item>
            <item key="xpos" >5</item>
          </hashref>
        </item>
        <item key="number" >
          <hashref>
            <item key="font" >
              <hashref>
                <item key="face" >Helvetica-Bold</item>
                <item key="size" >10</item>
              </hashref>
            </item>
            <item key="format" >%.2f</item>
            <item key="order" >1</item>
            <item key="text" >Konto $number: $name </item>
            <item key="total" >
              <arrayref>
                <item key="0" >debit</item>
                <item key="1" >credit</item>
                <item key="2" >total</item>
              </arrayref>
            </item>
            <item key="xpos" >5</item>
          </hashref>
        </item>
        <item key="produktgruppe" >
          <hashref>
            <item key="font" >
              <hashref>
                <item key="face" >Helvetica-Bold</item>
                <item key="size" >10</item>
              </hashref>
            </item>
            <item key="format" >%.2f</item>
            <item key="order" >0</item>
            <item key="text" >Produktgruppe $dim2</item>
            <item key="total" >
              <arrayref>
                <item key="0" >debit</item>
                <item key="1" >credit</item>
                <item key="2" >total</item>
              </arrayref>
            </item>
            <item key="xpos" >5</item>