$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);
