<?php header("Content-type: text/xml"); //$start = (isset($_POST['start'])) ? $_POST['start'] : "0" ; $dir = isset($_POST['sortorder']) ? $_POST['sortorder'] : "DESC"; $sort = isset($_POST['sortname']) ? $_POST['sortname'] : "id"; $rp = isset($_POST['rp']) ? $_POST['rp'] : "25"; $page = isset($_POST['page']) ? $_POST['page'] : "1"; //$sql = "SELECT * FROM ".TB_PREFIX."invoices LIMIT $start, $limit"; $inventory = new inventory(); $inventory->sort = $sort; $inventory_all = $inventory->select_all('', $dir, $rp, $page); $sth_count_rows = $inventory->select_all('count', $dir, $rp, $page); $xml = ""; $count = $sth_count_rows; $xml .= "<rows>"; $xml .= "<page>{$page}</page>"; $xml .= "<total>{$count}</total>"; foreach ($inventory_all as $row) { $xml .= "<row id='" . $row['id'] . "'>"; $xml .= "<cell><![CDATA[\n\t\t<a class='index_table' title='{$LANG['view']} " . $row['name'] . "' href='index.php?module=inventory&view=view&id={$row['id']}'><img src='images/common/view.png' height='16' border='-5px' padding='-4px' valign='bottom' /></a>\n\t\t<a class='index_table' title='{$LANG['edit']} " . $row['name'] . "' href='index.php?module=inventory&view=edit&id={$row['id']}'><img src='images/common/edit.png' height='16' border='-5px' padding='-4px' valign='bottom' /></a>\n\t\t]]></cell>"; $xml .= "<cell><![CDATA[" . $row['date'] . "]]></cell>"; $xml .= "<cell><![CDATA[" . $row['description'] . "]]></cell>"; $xml .= "<cell><![CDATA[" . siLocal::number($row['quantity']) . "]]></cell>"; $xml .= "<cell><![CDATA[" . siLocal::number($row['cost']) . "]]></cell>"; $xml .= "<cell><![CDATA[" . siLocal::number($row['total_cost']) . "]]></cell>"; $xml .= "</row>"; } $xml .= "</rows>"; echo $xml; ?>