function cw_accounting_get_record($record_id) { global $tables; $rec = cw_query_first("select * from {$tables['accounting_records']} where accounting_record_id='{$record_id}'"); cw_accounting_assign_info($rec); return $rec; }
} if ($data['saldo'] == 1) { $where[] = "{$tables['accounting_records']}.total < 0"; } elseif ($data['saldo'] == 2) { $where[] = "{$tables['accounting_records']}.total >= 0"; } if ($data['customer_id']) { $where[] = "{$tables['accounting_records']}.customer_id='{$data['customer_id']}'"; } if ($data['group']) { $fields[] = "{$tables['accounting_categories']}.category as descr"; $fields[] = "sum({$tables['accounting_records']}.total) as total"; $groupbys[] = "{$tables['accounting_categories']}.accounting_category_id"; } $orderbys[] = "{$tables['accounting_records']}.date asc"; $search_query_count = cw_db_generate_query('count(*)', $from_tbls, $query_joins, $where, $groupbys, $having, array(), 0); $search_query = cw_db_generate_query($fields, $from_tbls, $query_joins, $where, $groupbys, $having, $orderbys); $_res = db_query($search_query_count); $total_items = db_num_rows($_res); db_free_result($_res); $navigation = cw_core_get_navigation($target, $total_items, $page); if ($total_items > 0) { $search_query .= " LIMIT {$navigation['first_page']}, {$navigation['objects_per_page']}"; $records = cw_query($search_query); if (is_array($records)) { foreach ($records as $k => $v) { cw_accounting_assign_info($records[$k]); } } $smarty->assign('records', $records); }