public nobgit read

NobMail

Based on mailcow: dockerized

Languages

Repository composition by tracked source files.

PHP

PHP 49% JavaScript 35% HTML 9% CSS 4% Shell 2% Python 1% Lua 0% Perl 0% Ruby 0% SCSS 0%

Create file Wiki Documentation

Clone

https://nobgit.com/orgs/nobgit/nobmail.git

ssh://[email protected]:2222/orgs/nobgit/nobmail.git

Trace

data/web/inc/lib/ssp.class.php

Trace helps you understand code history line by line. See who changed each line, when it changed, and which commit introduced it.

Author Date Commit Line Code

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 1

<?php

Open commit View diff

1 <?php

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 2

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 3

/*

Open commit View diff

3 /*

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 4

 * Helper functions for building a DataTables server-side processing SQL query

Open commit View diff

4 * Helper functions for building a DataTables server-side processing SQL query

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 5

Open commit View diff

5 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 6

 * The static functions in this class are just helper functions to help build

Open commit View diff

6 * The static functions in this class are just helper functions to help build

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 7

 * the SQL used in the DataTables demo server-side processing scripts. These

Open commit View diff

7 * the SQL used in the DataTables demo server-side processing scripts. These

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 8

 * functions obviously do not represent all that can be done with server-side

Open commit View diff

8 * functions obviously do not represent all that can be done with server-side

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 9

 * processing, they are intentionally simple to show how it works. More complex

Open commit View diff

9 * processing, they are intentionally simple to show how it works. More complex

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 10

 * server-side processing operations will likely require a custom script.

Open commit View diff

10 * server-side processing operations will likely require a custom script.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 11

Open commit View diff

11 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 12

 * See https://datatables.net/usage/server-side for full details on the server-

Open commit View diff

12 * See https://datatables.net/usage/server-side for full details on the server-

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 13

 * side processing requirements of DataTables.

Open commit View diff

13 * side processing requirements of DataTables.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 14

Open commit View diff

14 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 15

 * @license MIT - https://datatables.net/license_mit

Open commit View diff

15 * @license MIT - https://datatables.net/license_mit

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 16

*/

Open commit View diff

16 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 17

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 18

class SSP {

Open commit View diff

18 class SSP {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 19

/**

Open commit View diff

19 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 20

	 * Create the data output array for the DataTables rows

Open commit View diff

20 * Create the data output array for the DataTables rows

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 21

Open commit View diff

21 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 22

	 *  @param  array $columns Column information array

Open commit View diff

22 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 23

	 *  @param  array $data    Data from the SQL get

Open commit View diff

23 * @param array $data Data from the SQL get

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 24

	 *  @return array          Formatted data in a row based format

Open commit View diff

24 * @return array Formatted data in a row based format

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 25

*/

Open commit View diff

25 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 26

	static function data_output ( $columns, $data )

Open commit View diff

26 static function data_output ( $columns, $data )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 27

Open commit View diff

27 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 28

		$out = array();

Open commit View diff

28 $out = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 29

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 30

		for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {

Open commit View diff

30 for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 31

			$row = array();

Open commit View diff

31 $row = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 32

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 33

			for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) {

Open commit View diff

33 for ( $j=0, $jen=count($columns) ; $j<$jen ; $j++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 34

				$column = $columns[$j];

Open commit View diff

34 $column = $columns[$j];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 35

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 36

				// Is there a formatter?

Open commit View diff

36 // Is there a formatter?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 37

				if ( isset( $column['formatter'] ) ) {

Open commit View diff

37 if ( isset( $column['formatter'] ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 38

                    if(empty($column['db'])){

Open commit View diff

38 if(empty($column['db'])){

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 39

                        $row[ $column['dt'] ] = $column['formatter']( $data[$i] );

Open commit View diff

39 $row[ $column['dt'] ] = $column['formatter']( $data[$i] );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 40

Open commit View diff

40 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 41

                    else{

Open commit View diff

41 else{

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 42

                        $row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );

Open commit View diff

42 $row[ $column['dt'] ] = $column['formatter']( $data[$i][ $column['db'] ], $data[$i] );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 43

Open commit View diff

43 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 44

Open commit View diff

44 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 45

				else {

Open commit View diff

45 else {

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 46

                    if(!empty($column['db']) && (!isset($column['dummy']) || $column['dummy'] !== true)){

Open commit View diff

46 if(!empty($column['db']) && (!isset($column['dummy']) || $column['dummy'] !== true)){

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 47

                        $row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];

Open commit View diff

47 $row[ $column['dt'] ] = $data[$i][ $columns[$j]['db'] ];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 48

Open commit View diff

48 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 49

                    else{

Open commit View diff

49 else{

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 50

                        $row[ $column['dt'] ] = "";

Open commit View diff

50 $row[ $column['dt'] ] = "";

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 51

Open commit View diff

51 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 52

Open commit View diff

52 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 53

Open commit View diff

53 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 54

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 55

			$out[] = $row;

Open commit View diff

55 $out[] = $row;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 56

Open commit View diff

56 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 57

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 58

		return $out;

Open commit View diff

58 return $out;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 59

Open commit View diff

59 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 60

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 61

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 62

/**

Open commit View diff

62 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 63

	 * Database connection

Open commit View diff

63 * Database connection

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 64

Open commit View diff

64 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 65

	 * Obtain an PHP PDO connection from a connection details array

Open commit View diff

65 * Obtain an PHP PDO connection from a connection details array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 66

Open commit View diff

66 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 67

	 *  @param  array $conn SQL connection details. The array should have

Open commit View diff

67 * @param array $conn SQL connection details. The array should have

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 68

	 *    the following properties

Open commit View diff

68 * the following properties

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 69

	 *     * host - host name

Open commit View diff

69 * * host - host name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 70

	 *     * db   - database name

Open commit View diff

70 * * db - database name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 71

	 *     * user - user name

Open commit View diff

71 * * user - user name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 72

	 *     * pass - user password

Open commit View diff

72 * * pass - user password

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 73

	 *     * Optional: `'charset' => 'utf8'` - you might need this depending on your PHP / MySQL config

Open commit View diff

73 * * Optional: `'charset' => 'utf8'` - you might need this depending on your PHP / MySQL config

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 74

	 *  @return resource PDO connection

Open commit View diff

74 * @return resource PDO connection

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 75

*/

Open commit View diff

75 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 76

	static function db ( $conn )

Open commit View diff

76 static function db ( $conn )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 77

Open commit View diff

77 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 78

		if ( is_array( $conn ) ) {

Open commit View diff

78 if ( is_array( $conn ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 79

			return self::sql_connect( $conn );

Open commit View diff

79 return self::sql_connect( $conn );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 80

Open commit View diff

80 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 81

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 82

		return $conn;

Open commit View diff

82 return $conn;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 83

Open commit View diff

83 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 84

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 85

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 86

/**

Open commit View diff

86 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 87

	 * Paging

Open commit View diff

87 * Paging

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 88

Open commit View diff

88 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 89

	 * Construct the LIMIT clause for server-side processing SQL query

Open commit View diff

89 * Construct the LIMIT clause for server-side processing SQL query

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 90

Open commit View diff

90 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 91

	 *  @param  array $request Data sent to server by DataTables

Open commit View diff

91 * @param array $request Data sent to server by DataTables

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 92

	 *  @param  array $columns Column information array

Open commit View diff

92 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 93

	 *  @return string SQL limit clause

Open commit View diff

93 * @return string SQL limit clause

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 94

*/

Open commit View diff

94 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 95

	static function limit ( $request, $columns )

Open commit View diff

95 static function limit ( $request, $columns )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 96

Open commit View diff

96 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 97

		$limit = '';

Open commit View diff

97 $limit = '';

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 98

Open commit View diff

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 99

		if ( isset($request['start']) && $request['length'] != -1 ) {

Open commit View diff

99 if ( isset($request['start']) && $request['length'] != -1 ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 100

			$limit = "LIMIT ".intval($request['start']).", ".intval($request['length']);

Open commit View diff

100 $limit = "LIMIT ".intval($request['start']).", ".intval($request['length']);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 101

Open commit View diff

101 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 102

Open commit View diff

102

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 103

		return $limit;

Open commit View diff

103 return $limit;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 104

Open commit View diff

104 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 105

Open commit View diff

105

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 106

Open commit View diff

106

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 107

/**

Open commit View diff

107 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 108

	 * Ordering

Open commit View diff

108 * Ordering

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 109

Open commit View diff

109 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 110

	 * Construct the ORDER BY clause for server-side processing SQL query

Open commit View diff

110 * Construct the ORDER BY clause for server-side processing SQL query

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 111

Open commit View diff

111 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 112

	 *  @param  array $request Data sent to server by DataTables

Open commit View diff

112 * @param array $request Data sent to server by DataTables

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 113

	 *  @param  array $columns Column information array

Open commit View diff

113 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 114

	 *  @return string SQL order by clause

Open commit View diff

114 * @return string SQL order by clause

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 115

*/

Open commit View diff

115 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 116

	static function order ( $tableAS, $request, $columns )

Open commit View diff

116 static function order ( $tableAS, $request, $columns )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 117

Open commit View diff

117 {

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 118

    	$select = '';

Open commit View diff

118 $select = '';

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 119

		$order = '';

Open commit View diff

119 $order = '';

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 120

Open commit View diff

120

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 121

		if ( isset($request['order']) && count($request['order']) ) {

Open commit View diff

121 if ( isset($request['order']) && count($request['order']) ) {

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 122

    		$selects = [];

Open commit View diff

122 $selects = [];

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 123

			$orderBy = [];

Open commit View diff

123 $orderBy = [];

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 124

			$dtColumns = self::pluck( $columns, 'dt' );

Open commit View diff

124 $dtColumns = self::pluck( $columns, 'dt' );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 125

Open commit View diff

125

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 126

			for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) {

Open commit View diff

126 for ( $i=0, $ien=count($request['order']) ; $i<$ien ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 127

				// Convert the column index into the column data property

Open commit View diff

127 // Convert the column index into the column data property

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 128

				$columnIdx = intval($request['order'][$i]['column']);

Open commit View diff

128 $columnIdx = intval($request['order'][$i]['column']);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 129

				$requestColumn = $request['columns'][$columnIdx];

Open commit View diff

129 $requestColumn = $request['columns'][$columnIdx];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 130

Open commit View diff

130

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 131

				$columnIdx = array_search( $columnIdx, $dtColumns );

Open commit View diff

131 $columnIdx = array_search( $columnIdx, $dtColumns );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 132

				$column = $columns[ $columnIdx ];

Open commit View diff

132 $column = $columns[ $columnIdx ];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 133

Open commit View diff

133

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 134

				if ( $requestColumn['orderable'] == 'true' ) {

Open commit View diff

134 if ( $requestColumn['orderable'] == 'true' ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 135

					$dir = $request['order'][$i]['dir'] === 'asc' ?

Open commit View diff

135 $dir = $request['order'][$i]['dir'] === 'asc' ?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 136

						'ASC' :

Open commit View diff

136 'ASC' :

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 137

						'DESC';

Open commit View diff

137 'DESC';

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 138

Open commit View diff

138

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 139

                    if(isset($column['order_subquery'])) {

Open commit View diff

139 if(isset($column['order_subquery'])) {

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 140

        				$selects[] = '('.$column['order_subquery'].') AS `'.$column['db'].'_count`';

Open commit View diff

140 $selects[] = '('.$column['order_subquery'].') AS `'.$column['db'].'_count`';

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 141

        				$orderBy[] = '`'.$column['db'].'_count` '.$dir;

Open commit View diff

141 $orderBy[] = '`'.$column['db'].'_count` '.$dir;

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 142

    				} else {

Open commit View diff

142 } else {

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 143

					    $orderBy[] = '`'.$tableAS.'`.`'.$column['db'].'` '.$dir;

Open commit View diff

143 $orderBy[] = '`'.$tableAS.'`.`'.$column['db'].'` '.$dir;

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 144

Open commit View diff

144 }

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 145

Open commit View diff

145 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 146

Open commit View diff

146 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 147

Open commit View diff

147

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 148

            if ( count( $selects ) ) {

Open commit View diff

148 if ( count( $selects ) ) {

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 149

                $select = ', '.implode(', ', $selects);

Open commit View diff

149 $select = ', '.implode(', ', $selects);

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 150

Open commit View diff

150 }

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 151

Open commit View diff

151

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 152

			if ( count( $orderBy ) ) {

Open commit View diff

152 if ( count( $orderBy ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 153

				$order = 'ORDER BY '.implode(', ', $orderBy);

Open commit View diff

153 $order = 'ORDER BY '.implode(', ', $orderBy);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 154

Open commit View diff

154 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 155

Open commit View diff

155 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 156

Open commit View diff

156

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 157

		return [$select, $order];

Open commit View diff

157 return [$select, $order];

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 158

Open commit View diff

158 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 159

Open commit View diff

159

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 160

Open commit View diff

160

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 161

/**

Open commit View diff

161 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 162

	 * Searching / Filtering

Open commit View diff

162 * Searching / Filtering

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 163

Open commit View diff

163 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 164

	 * Construct the WHERE clause for server-side processing SQL query.

Open commit View diff

164 * Construct the WHERE clause for server-side processing SQL query.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 165

Open commit View diff

165 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 166

	 * NOTE this does not match the built-in DataTables filtering which does it

Open commit View diff

166 * NOTE this does not match the built-in DataTables filtering which does it

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 167

	 * word by word on any field. It's possible to do here performance on large

Open commit View diff

167 * word by word on any field. It's possible to do here performance on large

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 168

	 * databases would be very poor

Open commit View diff

168 * databases would be very poor

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 169

Open commit View diff

169 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 170

	 *  @param  array $request Data sent to server by DataTables

Open commit View diff

170 * @param array $request Data sent to server by DataTables

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 171

	 *  @param  array $columns Column information array

Open commit View diff

171 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 172

	 *  @param  array $bindings Array of values for PDO bindings, used in the

Open commit View diff

172 * @param array $bindings Array of values for PDO bindings, used in the

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 173

	 *    sql_exec() function

Open commit View diff

173 * sql_exec() function

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 174

	 *  @return string SQL where clause

Open commit View diff

174 * @return string SQL where clause

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 175

*/

Open commit View diff

175 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 176

	static function filter ( $tablesAS, $request, $columns, &$bindings )

Open commit View diff

176 static function filter ( $tablesAS, $request, $columns, &$bindings )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 177

Open commit View diff

177 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 178

		$globalSearch = array();

Open commit View diff

178 $globalSearch = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 179

		$columnSearch = array();

Open commit View diff

179 $columnSearch = array();

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 180

		$joins = array();

Open commit View diff

180 $joins = array();

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 181

		$dtColumns = self::pluck( $columns, 'dt' );

Open commit View diff

181 $dtColumns = self::pluck( $columns, 'dt' );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 182

Open commit View diff

182

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 183

		if ( isset($request['search']) && $request['search']['value'] != '' ) {

Open commit View diff

183 if ( isset($request['search']) && $request['search']['value'] != '' ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 184

			$str = $request['search']['value'];

Open commit View diff

184 $str = $request['search']['value'];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 185

Open commit View diff

185

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 186

			for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {

Open commit View diff

186 for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 187

				$requestColumn = $request['columns'][$i];

Open commit View diff

187 $requestColumn = $request['columns'][$i];

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 188

				$columnIdx = array_search( $i, $dtColumns );

Open commit View diff

188 $columnIdx = array_search( $i, $dtColumns );

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 189

				$column = $columns[ $columnIdx ];

Open commit View diff

189 $column = $columns[ $columnIdx ];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 190

Open commit View diff

190

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 191

				if ( $requestColumn['searchable'] == 'true' ) {

Open commit View diff

191 if ( $requestColumn['searchable'] == 'true' ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 192

					if(!empty($column['db'])){

Open commit View diff

192 if(!empty($column['db'])){

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 193

    					$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );

Open commit View diff

193 $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 194

Open commit View diff

194

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 195

    					if(isset($column['search']['join'])) {

Open commit View diff

195 if(isset($column['search']['join'])) {

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 196

            				$joins[] = $column['search']['join'];

Open commit View diff

196 $joins[] = $column['search']['join'];

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 197

            				$globalSearch[] = $column['search']['where_column'].' LIKE '.$binding;

Open commit View diff

197 $globalSearch[] = $column['search']['where_column'].' LIKE '.$binding;

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 198

        				} else {

Open commit View diff

198 } else {

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 199

						    $globalSearch[] = "`".$tablesAS."`.`".$column['db']."` LIKE ".$binding;

Open commit View diff

199 $globalSearch[] = "`".$tablesAS."`.`".$column['db']."` LIKE ".$binding;

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 200

Open commit View diff

200 }

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 201

Open commit View diff

201 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 202

Open commit View diff

202 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 203

Open commit View diff

203 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 204

Open commit View diff

204 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 205

Open commit View diff

205

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 206

		// Individual column filtering

Open commit View diff

206 // Individual column filtering

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 207

		if ( isset( $request['columns'] ) ) {

Open commit View diff

207 if ( isset( $request['columns'] ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 208

			for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {

Open commit View diff

208 for ( $i=0, $ien=count($request['columns']) ; $i<$ien ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 209

				$requestColumn = $request['columns'][$i];

Open commit View diff

209 $requestColumn = $request['columns'][$i];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 210

				$columnIdx = array_search( $requestColumn['data'], $dtColumns );

Open commit View diff

210 $columnIdx = array_search( $requestColumn['data'], $dtColumns );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 211

				$column = $columns[ $columnIdx ];

Open commit View diff

211 $column = $columns[ $columnIdx ];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 212

Open commit View diff

212

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 213

				$str = $requestColumn['search']['value'];

Open commit View diff

213 $str = $requestColumn['search']['value'];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 214

Open commit View diff

214

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 215

				if ( $requestColumn['searchable'] == 'true' &&

Open commit View diff

215 if ( $requestColumn['searchable'] == 'true' &&

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 216

				 $str != '' ) {

Open commit View diff

216 $str != '' ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 217

					if(!empty($column['db'])){

Open commit View diff

217 if(!empty($column['db'])){

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 218

						$binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );

Open commit View diff

218 $binding = self::bind( $bindings, '%'.$str.'%', PDO::PARAM_STR );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 219

						$columnSearch[] = "`".$tablesAS."`.`".$column['db']."` LIKE ".$binding;

Open commit View diff

219 $columnSearch[] = "`".$tablesAS."`.`".$column['db']."` LIKE ".$binding;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 220

Open commit View diff

220 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 221

Open commit View diff

221 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 222

Open commit View diff

222 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 223

Open commit View diff

223 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 224

Open commit View diff

224

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 225

		// Combine the filters into a single string

Open commit View diff

225 // Combine the filters into a single string

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 226

		$where = '';

Open commit View diff

226 $where = '';

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 227

Open commit View diff

227

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 228

		if ( count( $globalSearch ) ) {

Open commit View diff

228 if ( count( $globalSearch ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 229

			$where = '('.implode(' OR ', $globalSearch).')';

Open commit View diff

229 $where = '('.implode(' OR ', $globalSearch).')';

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 230

Open commit View diff

230 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 231

Open commit View diff

231

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 232

		if ( count( $columnSearch ) ) {

Open commit View diff

232 if ( count( $columnSearch ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 233

			$where = $where === '' ?

Open commit View diff

233 $where = $where === '' ?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 234

				implode(' AND ', $columnSearch) :

Open commit View diff

234 implode(' AND ', $columnSearch) :

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 235

				$where .' AND '. implode(' AND ', $columnSearch);

Open commit View diff

235 $where .' AND '. implode(' AND ', $columnSearch);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 236

Open commit View diff

236 }

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 237

Open commit View diff

237

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 238

		$join = '';

Open commit View diff

238 $join = '';

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 239

		if( count($joins) ) {

Open commit View diff

239 if( count($joins) ) {

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 240

    		$join = implode(' ', $joins);

Open commit View diff

240 $join = implode(' ', $joins);

same change ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 241

Open commit View diff

241 }

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 242

Open commit View diff

242

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 243

		if ( $where !== '' ) {

Open commit View diff

243 if ( $where !== '' ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 244

			$where = 'WHERE '.$where;

Open commit View diff

244 $where = 'WHERE '.$where;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 245

Open commit View diff

245 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 246

Open commit View diff

246

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 247

		return [$join, $where];

Open commit View diff

247 return [$join, $where];

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 248

Open commit View diff

248 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 249

Open commit View diff

249

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 250

Open commit View diff

250

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 251

/**

Open commit View diff

251 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 252

	 * Perform the SQL queries needed for an server-side processing requested,

Open commit View diff

252 * Perform the SQL queries needed for an server-side processing requested,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 253

	 * utilising the helper functions of this class, limit(), order() and

Open commit View diff

253 * utilising the helper functions of this class, limit(), order() and

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 254

	 * filter() among others. The returned array is ready to be encoded as JSON

Open commit View diff

254 * filter() among others. The returned array is ready to be encoded as JSON

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 255

	 * in response to an SSP request, or can be modified if needed before

Open commit View diff

255 * in response to an SSP request, or can be modified if needed before

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 256

	 * sending back to the client.

Open commit View diff

256 * sending back to the client.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 257

Open commit View diff

257 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 258

	 *  @param  array $request Data sent to server by DataTables

Open commit View diff

258 * @param array $request Data sent to server by DataTables

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 259

	 *  @param  array|PDO $conn PDO connection resource or connection parameters array

Open commit View diff

259 * @param array|PDO $conn PDO connection resource or connection parameters array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 260

	 *  @param  string $table SQL table to query

Open commit View diff

260 * @param string $table SQL table to query

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 261

	 *  @param  string $primaryKey Primary key of the table

Open commit View diff

261 * @param string $primaryKey Primary key of the table

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 262

	 *  @param  array $columns Column information array

Open commit View diff

262 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 263

	 *  @return array          Server-side processing response array

Open commit View diff

263 * @return array Server-side processing response array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 264

*/

Open commit View diff

264 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 265

	static function simple ( $request, $conn, $table, $primaryKey, $columns )

Open commit View diff

265 static function simple ( $request, $conn, $table, $primaryKey, $columns )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 266

Open commit View diff

266 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 267

		$bindings = array();

Open commit View diff

267 $bindings = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 268

		$db = self::db( $conn );

Open commit View diff

268 $db = self::db( $conn );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 269

Open commit View diff

269

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 270

		// Allow for a JSON string to be passed in

Open commit View diff

270 // Allow for a JSON string to be passed in

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 271

		if (isset($request['json'])) {

Open commit View diff

271 if (isset($request['json'])) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 272

			$request = json_decode($request['json'], true);

Open commit View diff

272 $request = json_decode($request['json'], true);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 273

Open commit View diff

273 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 274

Open commit View diff

274

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 275

    // table AS

Open commit View diff

275 // table AS

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 276

    $tablesAS = null;

Open commit View diff

276 $tablesAS = null;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 277

    if(is_array($table)) {

Open commit View diff

277 if(is_array($table)) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 278

      $tablesAS = $table[1];

Open commit View diff

278 $tablesAS = $table[1];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 279

      $table = $table[0];

Open commit View diff

279 $table = $table[0];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 280

Open commit View diff

280 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 281

Open commit View diff

281

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 282

		// Build the SQL query string from the request

Open commit View diff

282 // Build the SQL query string from the request

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 283

		list($select, $order) = self::order( $tablesAS, $request, $columns );

Open commit View diff

283 list($select, $order) = self::order( $tablesAS, $request, $columns );

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 284

		$limit = self::limit( $request, $columns );

Open commit View diff

284 $limit = self::limit( $request, $columns );

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 285

		list($join, $where) = self::filter( $tablesAS, $request, $columns, $bindings );

Open commit View diff

285 list($join, $where) = self::filter( $tablesAS, $request, $columns, $bindings );

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 286

Open commit View diff

286

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 287

		// Main query to actually get the data

Open commit View diff

287 // Main query to actually get the data

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 288

		$data = self::sql_exec( $db, $bindings,

Open commit View diff

288 $data = self::sql_exec( $db, $bindings,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 289

			"SELECT `$tablesAS`.`".implode("`, `$tablesAS`.`", self::pluck($columns, 'db'))."`

Open commit View diff

289 "SELECT `$tablesAS`.`".implode("`, `$tablesAS`.`", self::pluck($columns, 'db'))."`

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 290

			 $select

Open commit View diff

290 $select

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 291

			 FROM `$table` AS `$tablesAS`

Open commit View diff

291 FROM `$table` AS `$tablesAS`

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 292

			 $join

Open commit View diff

292 $join

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 293

			 $where

Open commit View diff

293 $where

FreddleSpl0it over 2 years ago cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 294

			 GROUP BY `{$tablesAS}`.`{$primaryKey}`

Open commit View diff

294 GROUP BY `{$tablesAS}`.`{$primaryKey}`

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 295

			 $order

Open commit View diff

295 $order

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 296

			 $limit"

Open commit View diff

296 $limit"

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 297

);

Open commit View diff

297 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 298

Open commit View diff

298

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 299

		// Data set length after filtering

Open commit View diff

299 // Data set length after filtering

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 300

		$resFilterLength = self::sql_exec( $db, $bindings,

Open commit View diff

300 $resFilterLength = self::sql_exec( $db, $bindings,

FreddleSpl0it over 2 years ago cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 301

			"SELECT COUNT(DISTINCT `{$tablesAS}`.`{$primaryKey}`)

Open commit View diff

301 "SELECT COUNT(DISTINCT `{$tablesAS}`.`{$primaryKey}`)

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 302

			 FROM   `$table` AS `$tablesAS`

Open commit View diff

302 FROM `$table` AS `$tablesAS`

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 303

			 $join

Open commit View diff

303 $join

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 304

			 $where"

Open commit View diff

304 $where"

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 305

);

Open commit View diff

305 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 306

		$recordsFiltered = $resFilterLength[0][0];

Open commit View diff

306 $recordsFiltered = $resFilterLength[0][0];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 307

Open commit View diff

307

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 308

		// Total data set length

Open commit View diff

308 // Total data set length

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 309

		$resTotalLength = self::sql_exec( $db,

Open commit View diff

309 $resTotalLength = self::sql_exec( $db,

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 310

			"SELECT COUNT(`{$tablesAS}`.`{$primaryKey}`)

Open commit View diff

310 "SELECT COUNT(`{$tablesAS}`.`{$primaryKey}`)

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 311

			 FROM   `$table` AS `$tablesAS`"

Open commit View diff

311 FROM `$table` AS `$tablesAS`"

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 312

);

Open commit View diff

312 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 313

		$recordsTotal = $resTotalLength[0][0];

Open commit View diff

313 $recordsTotal = $resTotalLength[0][0];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 314

Open commit View diff

314

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 315

/*

Open commit View diff

315 /*

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 316

		 * Output

Open commit View diff

316 * Output

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 317

*/

Open commit View diff

317 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 318

		return array(

Open commit View diff

318 return array(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 319

			"draw"            => isset ( $request['draw'] ) ?

Open commit View diff

319 "draw" => isset ( $request['draw'] ) ?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 320

				intval( $request['draw'] ) :

Open commit View diff

320 intval( $request['draw'] ) :

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 321

0,

Open commit View diff

321 0,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 322

			"recordsTotal"    => intval( $recordsTotal ),

Open commit View diff

322 "recordsTotal" => intval( $recordsTotal ),

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 323

			"recordsFiltered" => intval( $recordsFiltered ),

Open commit View diff

323 "recordsFiltered" => intval( $recordsFiltered ),

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 324

			"data"            => self::data_output( $columns, $data )

Open commit View diff

324 "data" => self::data_output( $columns, $data )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 325

);

Open commit View diff

325 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 326

Open commit View diff

326 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 327

Open commit View diff

327

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 328

Open commit View diff

328

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 329

/**

Open commit View diff

329 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 330

	 * The difference between this method and the `simple` one, is that you can

Open commit View diff

330 * The difference between this method and the `simple` one, is that you can

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 331

	 * apply additional `where` conditions to the SQL queries. These can be in

Open commit View diff

331 * apply additional `where` conditions to the SQL queries. These can be in

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 332

	 * one of two forms:

Open commit View diff

332 * one of two forms:

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 333

Open commit View diff

333 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 334

	 * * 'Result condition' - This is applied to the result set, but not the

Open commit View diff

334 * * 'Result condition' - This is applied to the result set, but not the

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 335

	 *   overall paging information query - i.e. it will not effect the number

Open commit View diff

335 * overall paging information query - i.e. it will not effect the number

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 336

	 *   of records that a user sees they can have access to. This should be

Open commit View diff

336 * of records that a user sees they can have access to. This should be

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 337

	 *   used when you want apply a filtering condition that the user has sent.

Open commit View diff

337 * used when you want apply a filtering condition that the user has sent.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 338

	 * * 'All condition' - This is applied to all queries that are made and

Open commit View diff

338 * * 'All condition' - This is applied to all queries that are made and

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 339

	 *   reduces the number of records that the user can access. This should be

Open commit View diff

339 * reduces the number of records that the user can access. This should be

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 340

	 *   used in conditions where you don't want the user to ever have access to

Open commit View diff

340 * used in conditions where you don't want the user to ever have access to

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 341

	 *   particular records (for example, restricting by a login id).

Open commit View diff

341 * particular records (for example, restricting by a login id).

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 342

Open commit View diff

342 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 343

	 * In both cases the extra condition can be added as a simple string, or if

Open commit View diff

343 * In both cases the extra condition can be added as a simple string, or if

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 344

	 * you are using external values, as an assoc. array with `condition` and

Open commit View diff

344 * you are using external values, as an assoc. array with `condition` and

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 345

	 * `bindings` parameters. The `condition` is a string with the SQL WHERE

Open commit View diff

345 * `bindings` parameters. The `condition` is a string with the SQL WHERE

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 346

	 * condition and `bindings` is an assoc. array of the binding names and

Open commit View diff

346 * condition and `bindings` is an assoc. array of the binding names and

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 347

	 * values.

Open commit View diff

347 * values.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 348

Open commit View diff

348 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 349

	 *  @param  array $request Data sent to server by DataTables

Open commit View diff

349 * @param array $request Data sent to server by DataTables

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 350

	 *  @param  array|PDO $conn PDO connection resource or connection parameters array

Open commit View diff

350 * @param array|PDO $conn PDO connection resource or connection parameters array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 351

	 *  @param  string|array $table SQL table to query, if array second key is AS

Open commit View diff

351 * @param string|array $table SQL table to query, if array second key is AS

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 352

	 *  @param  string $primaryKey Primary key of the table

Open commit View diff

352 * @param string $primaryKey Primary key of the table

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 353

	 *  @param  array $columns Column information array

Open commit View diff

353 * @param array $columns Column information array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 354

   *  @param  string $join JOIN sql string

Open commit View diff

354 * @param string $join JOIN sql string

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 355

	 *  @param  string|array $whereResult WHERE condition to apply to the result set

Open commit View diff

355 * @param string|array $whereResult WHERE condition to apply to the result set

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 356

	 *  @return array          Server-side processing response array

Open commit View diff

356 * @return array Server-side processing response array

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 357

*/

Open commit View diff

357 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 358

	static function complex (

Open commit View diff

358 static function complex (

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 359

		$request,

Open commit View diff

359 $request,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 360

		$conn,

Open commit View diff

360 $conn,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 361

		$table,

Open commit View diff

361 $table,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 362

		$primaryKey,

Open commit View diff

362 $primaryKey,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 363

		$columns,

Open commit View diff

363 $columns,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 364

    $join=null,

Open commit View diff

364 $join=null,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 365

		$whereResult=null

Open commit View diff

365 $whereResult=null

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 366

) {

Open commit View diff

366 ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 367

		$bindings = array();

Open commit View diff

367 $bindings = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 368

		$db = self::db( $conn );

Open commit View diff

368 $db = self::db( $conn );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 369

Open commit View diff

369

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 370

    // table AS

Open commit View diff

370 // table AS

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 371

    $tablesAS = null;

Open commit View diff

371 $tablesAS = null;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 372

    if(is_array($table)) {

Open commit View diff

372 if(is_array($table)) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 373

      $tablesAS = $table[1];

Open commit View diff

373 $tablesAS = $table[1];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 374

      $table = $table[0];

Open commit View diff

374 $table = $table[0];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 375

Open commit View diff

375 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 376

Open commit View diff

376

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 377

		// Build the SQL query string from the request

Open commit View diff

377 // Build the SQL query string from the request

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 378

		list($select, $order) = self::order( $tablesAS, $request, $columns );

Open commit View diff

378 list($select, $order) = self::order( $tablesAS, $request, $columns );

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 379

		$limit = self::limit( $request, $columns );

Open commit View diff

379 $limit = self::limit( $request, $columns );

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 380

		list($join_filter, $where) = self::filter( $tablesAS, $request, $columns, $bindings );

Open commit View diff

380 list($join_filter, $where) = self::filter( $tablesAS, $request, $columns, $bindings );

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 381

Open commit View diff

381

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 382

		// whereResult can be a simple string, or an assoc. array with a

Open commit View diff

382 // whereResult can be a simple string, or an assoc. array with a

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 383

		// condition and bindings

Open commit View diff

383 // condition and bindings

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 384

		if ( $whereResult ) {

Open commit View diff

384 if ( $whereResult ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 385

			$str = $whereResult;

Open commit View diff

385 $str = $whereResult;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 386

Open commit View diff

386

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 387

			if ( is_array($whereResult) ) {

Open commit View diff

387 if ( is_array($whereResult) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 388

				$str = $whereResult['condition'];

Open commit View diff

388 $str = $whereResult['condition'];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 389

Open commit View diff

389

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 390

				if ( isset($whereResult['bindings']) ) {

Open commit View diff

390 if ( isset($whereResult['bindings']) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 391

					self::add_bindings($bindings, $whereResult);

Open commit View diff

391 self::add_bindings($bindings, $whereResult);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 392

Open commit View diff

392 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 393

Open commit View diff

393 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 394

Open commit View diff

394

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 395

			$where = $where ?

Open commit View diff

395 $where = $where ?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 396

				$where .' AND '.$str :

Open commit View diff

396 $where .' AND '.$str :

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 397

				'WHERE '.$str;

Open commit View diff

397 'WHERE '.$str;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 398

Open commit View diff

398 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 399

Open commit View diff

399

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 400

		// Main query to actually get the data

Open commit View diff

400 // Main query to actually get the data

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 401

		$data = self::sql_exec( $db, $bindings,

Open commit View diff

401 $data = self::sql_exec( $db, $bindings,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 402

			"SELECT  `$tablesAS`.`".implode("`, `$tablesAS`.`", self::pluck($columns, 'db'))."`

Open commit View diff

402 "SELECT `$tablesAS`.`".implode("`, `$tablesAS`.`", self::pluck($columns, 'db'))."`

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 403

			 $select

Open commit View diff

403 $select

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 404

			 FROM `$table` AS `$tablesAS`

Open commit View diff

404 FROM `$table` AS `$tablesAS`

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 405

			 $join

Open commit View diff

405 $join

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 406

			 $join_filter

Open commit View diff

406 $join_filter

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 407

			 $where

Open commit View diff

407 $where

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 408

			 GROUP BY `{$tablesAS}`.`{$primaryKey}`

Open commit View diff

408 GROUP BY `{$tablesAS}`.`{$primaryKey}`

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 409

			 $order

Open commit View diff

409 $order

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 410

			 $limit"

Open commit View diff

410 $limit"

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 411

);

Open commit View diff

411 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 412

Open commit View diff

412

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 413

		// Data set length after filtering

Open commit View diff

413 // Data set length after filtering

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 414

		$resFilterLength = self::sql_exec( $db, $bindings,

Open commit View diff

414 $resFilterLength = self::sql_exec( $db, $bindings,

FreddleSpl0it over 2 years ago cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 415

			"SELECT COUNT(DISTINCT `{$tablesAS}`.`{$primaryKey}`)

Open commit View diff

415 "SELECT COUNT(DISTINCT `{$tablesAS}`.`{$primaryKey}`)

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 416

			 FROM   `$table` AS `$tablesAS`

Open commit View diff

416 FROM `$table` AS `$tablesAS`

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 417

			 $join

Open commit View diff

417 $join

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 418

			 $join_filter

Open commit View diff

418 $join_filter

FreddleSpl0it over 2 years ago cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 419

			 $where"

Open commit View diff

419 $where"

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 420

);

Open commit View diff

420 );

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 421

		$recordsFiltered = (isset($resFilterLength[0])) ? $resFilterLength[0][0] : 0;

Open commit View diff

421 $recordsFiltered = (isset($resFilterLength[0])) ? $resFilterLength[0][0] : 0;

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 422

Open commit View diff

422

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 423

		// Total data set length

Open commit View diff

423 // Total data set length

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 424

		$resTotalLength = self::sql_exec( $db, $bindings,

Open commit View diff

424 $resTotalLength = self::sql_exec( $db, $bindings,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 425

			"SELECT COUNT(`{$tablesAS}`.`{$primaryKey}`)

Open commit View diff

425 "SELECT COUNT(`{$tablesAS}`.`{$primaryKey}`)

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 426

			 FROM   `$table` AS `$tablesAS`

Open commit View diff

426 FROM `$table` AS `$tablesAS`

FreddleSpl0it over 2 years ago cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 427

			 $join

Open commit View diff

427 $join

same change cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 428

			 $join_filter

Open commit View diff

428 $join_filter

same change cc3adbe

[Web] fix datatables ssp queries

Full commit hash: cc3adbe78c815e07ef68cc7f2e355b7dc9d03d2c
Author: FreddleSpl0it <[email protected]>
Date: over 2 years ago
Selected line: 429

			 $where"

Open commit View diff

429 $where"

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 430

);

Open commit View diff

430 );

Kristian Feldsam over 2 years ago ac4f131

Domains and Mailboxes datatable - server side processing - filtering by tags

Full commit hash: ac4f131fa8f1629b1c831478d020f5f1b6be4261
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 431

		$recordsTotal = (isset($resTotalLength[0])) ? $resTotalLength[0][0] : 0;

Open commit View diff

431 $recordsTotal = (isset($resTotalLength[0])) ? $resTotalLength[0][0] : 0;

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 432

Open commit View diff

432

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 433

/*

Open commit View diff

433 /*

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 434

		 * Output

Open commit View diff

434 * Output

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 435

*/

Open commit View diff

435 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 436

		return array(

Open commit View diff

436 return array(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 437

			"draw"            => isset ( $request['draw'] ) ?

Open commit View diff

437 "draw" => isset ( $request['draw'] ) ?

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 438

				intval( $request['draw'] ) :

Open commit View diff

438 intval( $request['draw'] ) :

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 439

0,

Open commit View diff

439 0,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 440

			"recordsTotal"    => intval( $recordsTotal ),

Open commit View diff

440 "recordsTotal" => intval( $recordsTotal ),

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 441

			"recordsFiltered" => intval( $recordsFiltered ),

Open commit View diff

441 "recordsFiltered" => intval( $recordsFiltered ),

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 442

			"data"            => self::data_output( $columns, $data )

Open commit View diff

442 "data" => self::data_output( $columns, $data )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 443

);

Open commit View diff

443 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 444

Open commit View diff

444 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 445

Open commit View diff

445

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 446

Open commit View diff

446

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 447

/**

Open commit View diff

447 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 448

	 * Connect to the database

Open commit View diff

448 * Connect to the database

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 449

Open commit View diff

449 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 450

	 * @param  array $sql_details SQL server connection details array, with the

Open commit View diff

450 * @param array $sql_details SQL server connection details array, with the

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 451

	 *   properties:

Open commit View diff

451 * properties:

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 452

	 *     * host - host name

Open commit View diff

452 * * host - host name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 453

	 *     * db   - database name

Open commit View diff

453 * * db - database name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 454

	 *     * user - user name

Open commit View diff

454 * * user - user name

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 455

	 *     * pass - user password

Open commit View diff

455 * * pass - user password

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 456

	 * @return resource Database connection handle

Open commit View diff

456 * @return resource Database connection handle

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 457

*/

Open commit View diff

457 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 458

	static function sql_connect ( $sql_details )

Open commit View diff

458 static function sql_connect ( $sql_details )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 459

Open commit View diff

459 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 460

		try {

Open commit View diff

460 try {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 461

			$db = @new PDO(

Open commit View diff

461 $db = @new PDO(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 462

				"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",

Open commit View diff

462 "mysql:host={$sql_details['host']};dbname={$sql_details['db']}",

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 463

				$sql_details['user'],

Open commit View diff

463 $sql_details['user'],

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 464

				$sql_details['pass'],

Open commit View diff

464 $sql_details['pass'],

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 465

				array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )

Open commit View diff

465 array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 466

);

Open commit View diff

466 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 467

Open commit View diff

467 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 468

		catch (PDOException $e) {

Open commit View diff

468 catch (PDOException $e) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 469

			self::fatal(

Open commit View diff

469 self::fatal(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 470

				"An error occurred while connecting to the database. ".

Open commit View diff

470 "An error occurred while connecting to the database. ".

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 471

				"The error reported by the server was: ".$e->getMessage()

Open commit View diff

471 "The error reported by the server was: ".$e->getMessage()

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 472

);

Open commit View diff

472 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 473

Open commit View diff

473 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 474

Open commit View diff

474

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 475

		return $db;

Open commit View diff

475 return $db;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 476

Open commit View diff

476 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 477

Open commit View diff

477

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 478

Open commit View diff

478

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 479

/**

Open commit View diff

479 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 480

	 * Execute an SQL query on the database

Open commit View diff

480 * Execute an SQL query on the database

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 481

Open commit View diff

481 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 482

	 * @param  resource $db  Database handler

Open commit View diff

482 * @param resource $db Database handler

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 483

	 * @param  array    $bindings Array of PDO binding values from bind() to be

Open commit View diff

483 * @param array $bindings Array of PDO binding values from bind() to be

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 484

	 *   used for safely escaping strings. Note that this can be given as the

Open commit View diff

484 * used for safely escaping strings. Note that this can be given as the

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 485

	 *   SQL query string if no bindings are required.

Open commit View diff

485 * SQL query string if no bindings are required.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 486

	 * @param  string   $sql SQL query to execute.

Open commit View diff

486 * @param string $sql SQL query to execute.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 487

	 * @return array         Result from the query (all rows)

Open commit View diff

487 * @return array Result from the query (all rows)

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 488

*/

Open commit View diff

488 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 489

	static function sql_exec ( $db, $bindings, $sql=null )

Open commit View diff

489 static function sql_exec ( $db, $bindings, $sql=null )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 490

Open commit View diff

490 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 491

		// Argument shifting

Open commit View diff

491 // Argument shifting

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 492

		if ( $sql === null ) {

Open commit View diff

492 if ( $sql === null ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 493

			$sql = $bindings;

Open commit View diff

493 $sql = $bindings;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 494

Open commit View diff

494 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 495

Open commit View diff

495

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 496

		$stmt = $db->prepare( $sql );

Open commit View diff

496 $stmt = $db->prepare( $sql );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 497

Open commit View diff

497

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 498

		// Bind parameters

Open commit View diff

498 // Bind parameters

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 499

		if ( is_array( $bindings ) ) {

Open commit View diff

499 if ( is_array( $bindings ) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 500

			for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) {

Open commit View diff

500 for ( $i=0, $ien=count($bindings) ; $i<$ien ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 501

				$binding = $bindings[$i];

Open commit View diff

501 $binding = $bindings[$i];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 502

				$stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] );

Open commit View diff

502 $stmt->bindValue( $binding['key'], $binding['val'], $binding['type'] );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 503

Open commit View diff

503 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 504

Open commit View diff

504 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 505

Open commit View diff

505

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 506

		// Execute

Open commit View diff

506 // Execute

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 507

		try {

Open commit View diff

507 try {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 508

			$stmt->execute();

Open commit View diff

508 $stmt->execute();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 509

Open commit View diff

509 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 510

		catch (PDOException $e) {

Open commit View diff

510 catch (PDOException $e) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 511

			self::fatal( "An SQL error occurred: ".$e->getMessage() );

Open commit View diff

511 self::fatal( "An SQL error occurred: ".$e->getMessage() );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 512

Open commit View diff

512 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 513

Open commit View diff

513

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 514

		// Return all

Open commit View diff

514 // Return all

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 515

		return $stmt->fetchAll( PDO::FETCH_BOTH );

Open commit View diff

515 return $stmt->fetchAll( PDO::FETCH_BOTH );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 516

Open commit View diff

516 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 517

Open commit View diff

517

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 518

Open commit View diff

518

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 519

	/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Open commit View diff

519 /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 520

	 * Internal methods

Open commit View diff

520 * Internal methods

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 521

*/

Open commit View diff

521 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 522

Open commit View diff

522

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 523

/**

Open commit View diff

523 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 524

	 * Throw a fatal error.

Open commit View diff

524 * Throw a fatal error.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 525

Open commit View diff

525 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 526

	 * This writes out an error message in a JSON string which DataTables will

Open commit View diff

526 * This writes out an error message in a JSON string which DataTables will

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 527

	 * see and show to the user in the browser.

Open commit View diff

527 * see and show to the user in the browser.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 528

Open commit View diff

528 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 529

	 * @param  string $msg Message to send to the client

Open commit View diff

529 * @param string $msg Message to send to the client

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 530

*/

Open commit View diff

530 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 531

	static function fatal ( $msg )

Open commit View diff

531 static function fatal ( $msg )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 532

Open commit View diff

532 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 533

		echo json_encode( array(

Open commit View diff

533 echo json_encode( array(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 534

			"error" => $msg

Open commit View diff

534 "error" => $msg

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 535

		) );

Open commit View diff

535 ) );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 536

Open commit View diff

536

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 537

		exit(0);

Open commit View diff

537 exit(0);

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 538

Open commit View diff

538 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 539

Open commit View diff

539

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 540

/**

Open commit View diff

540 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 541

	 * Create a PDO binding key which can be used for escaping variables safely

Open commit View diff

541 * Create a PDO binding key which can be used for escaping variables safely

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 542

	 * when executing a query with sql_exec()

Open commit View diff

542 * when executing a query with sql_exec()

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 543

Open commit View diff

543 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 544

	 * @param  array &$a    Array of bindings

Open commit View diff

544 * @param array &$a Array of bindings

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 545

	 * @param  *      $val  Value to bind

Open commit View diff

545 * @param * $val Value to bind

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 546

	 * @param  int    $type PDO field type

Open commit View diff

546 * @param int $type PDO field type

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 547

	 * @return string       Bound key to be used in the SQL where this parameter

Open commit View diff

547 * @return string Bound key to be used in the SQL where this parameter

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 548

	 *   would be used.

Open commit View diff

548 * would be used.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 549

*/

Open commit View diff

549 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 550

	static function bind ( &$a, $val, $type )

Open commit View diff

550 static function bind ( &$a, $val, $type )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 551

Open commit View diff

551 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 552

		$key = ':binding_'.count( $a );

Open commit View diff

552 $key = ':binding_'.count( $a );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 553

Open commit View diff

553

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 554

		$a[] = array(

Open commit View diff

554 $a[] = array(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 555

			'key' => $key,

Open commit View diff

555 'key' => $key,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 556

			'val' => $val,

Open commit View diff

556 'val' => $val,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 557

			'type' => $type

Open commit View diff

557 'type' => $type

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 558

);

Open commit View diff

558 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 559

Open commit View diff

559

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 560

		return $key;

Open commit View diff

560 return $key;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 561

Open commit View diff

561 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 562

Open commit View diff

562

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 563

	static function add_bindings(&$bindings, $vals)

Open commit View diff

563 static function add_bindings(&$bindings, $vals)

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 564

Open commit View diff

564 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 565

		foreach($vals['bindings'] as $key => $value) {

Open commit View diff

565 foreach($vals['bindings'] as $key => $value) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 566

			$bindings[] = array(

Open commit View diff

566 $bindings[] = array(

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 567

				'key' => $key,

Open commit View diff

567 'key' => $key,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 568

				'val' => $value,

Open commit View diff

568 'val' => $value,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 569

				'type' => PDO::PARAM_STR

Open commit View diff

569 'type' => PDO::PARAM_STR

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 570

);

Open commit View diff

570 );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 571

Open commit View diff

571 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 572

Open commit View diff

572 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 573

Open commit View diff

573

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 574

Open commit View diff

574

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 575

/**

Open commit View diff

575 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 576

	 * Pull a particular property from each assoc. array in a numeric array,

Open commit View diff

576 * Pull a particular property from each assoc. array in a numeric array,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 577

	 * returning and array of the property values from each item.

Open commit View diff

577 * returning and array of the property values from each item.

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 578

Open commit View diff

578 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 579

	 *  @param  array  $a    Array to get data from

Open commit View diff

579 * @param array $a Array to get data from

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 580

	 *  @param  string $prop Property to read

Open commit View diff

580 * @param string $prop Property to read

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 581

	 *  @return array        Array of property values

Open commit View diff

581 * @return array Array of property values

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 582

*/

Open commit View diff

582 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 583

	static function pluck ( $a, $prop )

Open commit View diff

583 static function pluck ( $a, $prop )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 584

Open commit View diff

584 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 585

		$out = array();

Open commit View diff

585 $out = array();

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 586

Open commit View diff

586

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 587

		for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) {

Open commit View diff

587 for ( $i=0, $len=count($a) ; $i<$len ; $i++ ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 588

 			if ( empty($a[$i][$prop]) && $a[$i][$prop] !== 0 ) {

Open commit View diff

588 if ( empty($a[$i][$prop]) && $a[$i][$prop] !== 0 ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 589

				continue;

Open commit View diff

589 continue;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 590

Open commit View diff

590 }

Kristian Feldsam over 2 years ago 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 591

			if ( $prop == 'db' && isset($a[$i]['dummy']) && $a[$i]['dummy'] === true ) {

Open commit View diff

591 if ( $prop == 'db' && isset($a[$i]['dummy']) && $a[$i]['dummy'] === true ) {

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 592

    			continue;

Open commit View diff

592 continue;

same change 4dad000

Domains datatable - server side processing ordering

Full commit hash: 4dad0002cd72a6464f6193bd51092293a897078b
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 593

Open commit View diff

593 }

Kristian Feldsam over 2 years ago 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 594

Open commit View diff

594

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 595

			//removing the $out array index confuses the filter method in doing proper binding,

Open commit View diff

595 //removing the $out array index confuses the filter method in doing proper binding,

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 596

			//adding it ensures that the array data are mapped correctly

Open commit View diff

596 //adding it ensures that the array data are mapped correctly

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 597

			$out[$i] = $a[$i][$prop];

Open commit View diff

597 $out[$i] = $a[$i][$prop];

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 598

Open commit View diff

598 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 599

Open commit View diff

599

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 600

		return $out;

Open commit View diff

600 return $out;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 601

Open commit View diff

601 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 602

Open commit View diff

602

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 603

Open commit View diff

603

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 604

/**

Open commit View diff

604 /**

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 605

	 * Return a string from an array or a string

Open commit View diff

605 * Return a string from an array or a string

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 606

Open commit View diff

606 *

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 607

	 * @param  array|string $a Array to join

Open commit View diff

607 * @param array|string $a Array to join

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 608

	 * @param  string $join Glue for the concatenation

Open commit View diff

608 * @param string $join Glue for the concatenation

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 609

	 * @return string Joined string

Open commit View diff

609 * @return string Joined string

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 610

*/

Open commit View diff

610 */

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 611

	static function _flatten ( $a, $join = ' AND ' )

Open commit View diff

611 static function _flatten ( $a, $join = ' AND ' )

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 612

Open commit View diff

612 {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 613

		if ( ! $a ) {

Open commit View diff

613 if ( ! $a ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 614

			return '';

Open commit View diff

614 return '';

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 615

Open commit View diff

615 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 616

		else if ( $a && is_array($a) ) {

Open commit View diff

616 else if ( $a && is_array($a) ) {

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 617

			return implode( $join, $a );

Open commit View diff

617 return implode( $join, $a );

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 618

Open commit View diff

618 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 619

		return $a;

Open commit View diff

619 return $a;

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 620

Open commit View diff

620 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 621

Open commit View diff

621 }

same change 3e194c7

Domains datatable - server side processing

Full commit hash: 3e194c79060b84d04ce0b2c577ea4b68c7d8d732
Author: Kristian Feldsam <[email protected]>
Date: over 2 years ago
Selected line: 622

Open commit View diff

622