| Signatur | string bill__get_positions( string $sid, int $bill_id [, ajax_search_query|positionsRequest $request [, positionsFlags $flags]] ) |
| Parameter |
|
| Returns | string Array of articles (array of arrays) |
| Description | Get bill's positions, zuletzt geändert am __TICKET_NAME_RSFK-160__ Get a bill's positions and calculate prices Returns an array of arrays. The article array contains all fields of X_fakt_pos plus 'gesamt', 'gesamt_brutto' for each article. the parameter array $request has to be used to specify request and search query attributes: pageno:int paging method 1: page number for paging n_per_page:int paging method 1: number of items per page (max 100 per request) start:int paging method 2: first position index to display (starts at idx 0) limit:int paging method 2: number of positions to display (max 100 per request) sortColArray:array of arrays field:string column name for sorting order:string DESC: descendant, ASC: ascendant sortColName:string column name for sorting sortOrder:string DESC: descendant, ASC: ascendant searchText:string search string searchColumns:array columns to perform search on, for example: array( 'column1', 'column2' ) join_filter_by_or:int if set to 1, multiple filter arrays will be joined by OR, otherwise by AND filter:array of arrays this parameter can be used to restrict the request and search query - it has following sub-parameters / structure: field:string column name to set filter to data:array this parameter contains values which build up the filter - it has following sub-parameters / structure: type:string type of the 'value' parameter - possible values: date | list | boolean | string | numeric comparison:string comparison operator - possible values: eq | lt | gt | ne value:mixed depends on what you specified for 'type' parameter - can be a value of one of the following types: date string in mysql date format 'YYYY-MM-DD' | array | boolean | string | int example: array( array( 'field'=>'desired column name', 'data'=>array( 'type'=>'list', 'comparison'=>'eq', 'value'=>array( 'val1', 'val2', ... ) ) ), array( 'field'=>'another column name', 'data'=>array( 'type'=>'string', 'comparison'=>'ne', 'value'=>'val3' ) ) ) further parameters may be passed: int get_positions_fast: if set to 1 less information is (no lager status, no artikel details concerning dimensions int get_positions_deliver_status: if set to 1 the field "delivered_amount" is returned int get_extended_serialno_info: if set to 1, extended serialno information is returned HINT: get_positions_fast=1 and get_extended_serialno_info=1 is an invalid combination the parameter array $flags has three optional values no_lager: disable returning the lager information sperrlager: also return lager information about sperrlager no_stock: disable returning the stock status |