Signatur | string bill__get_comments( string $sid, int $billId, ajax_search_query $request ) |
Parameter |
|
Returns | string array(ok=>TRUE/FALSE, comments=>array) |
Description | Get bill comments 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 bill index to display (starts at idx 0) limit:int paging method 2: number of bills 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' ) ) ) keep in mind to specify every single parameter. for parameters you don't want to use, strings should be given an empty value ('') and integers should be set to null |