$where2 = ' where sals.is_deleted = 0 AND sals.is_trackcompleted = 0'; } $columns = array( array( 'db' => 'sals.id', 'dt' => 0 , 'field' => 'id'), array( 'db' => 'sals.due_date', 'dt' => 1 , 'field' => 'due_date', 'formatter' => function( $d, $row ) { return date( 'j-M-Y', strtotime($d)); }), array( 'db' => 'sals.id' , 'field' => 'id' , 'dt' => 2,'formatter' => function( $d, $row ) { return SSP::find_deliveryorder_nos($d); } ), array( 'db' => 'sals.id' , 'field' => 'id' , 'dt' => 3,'formatter' => function( $d, $row ) { return SSP::find_deliveryorder_no($d); } ), array( 'db' => 'sals.id' , 'field' => 'id' , 'dt' => 4,'formatter' => function( $d, $row ) { return SSP::find_deliveryorder_date($d); } ), array( 'db' => 'sals.id' , 'field' => 'id' , 'dt' => 5,'formatter' => function( $d, $row ) { return SSP::find_invoice_no($d);