getList(array('userid'=>$details), array('limit'=>false));
$orders = $orders_list['data'];
if (!empty($orders)) {
foreach ($orders as $order) {
?>
Str('Pasūtījums nr.')?>
Str('Datums')?>
Str('Preču skaits')?>
Str('Kopējā summa')?>
EUR
Str('Preces')?>
getArray("SELECT d.*, g.title FROM goods_orders_data d LEFT JOIN goods g ON g.id=d.product_id WHERE d.orderid = ".$order['orderid']);
if (!empty($goods)){
?>
ID
Str('Preces nosaukums')?>
Str('Pirkšanas cena')?>
Str('Skaits')?>
Str('Summa')?>
EUR
EUR
getSearchString($search);
$where = $field." LIKE '%".$search_str."%' ";
}
$rowsPerPage = 40;
$row_c = $DB->GetRowCount("goods_users",$where);
$pagingQuery = $DB->GetPagingQuery ($rowsPerPage,$row_c,$page);
$users = $DB -> getArray("SELECT * FROM goods_users WHERE 1=1 ".($where?"AND ".$where:"")." ORDER BY id DESC");
?>