$where2 = ' where is_deleted = 0'; } $columns = array( array( 'db' => 'id', 'dt' => 0 ,'field' => 'id'), array( 'db' => 'salesorderno', 'dt' => 1 ,'field' => 'salesorderno'), array( 'db' => 'reg_date', 'dt' => 2 ,'field' => 'reg_date'), array( 'db' => 'phone', 'dt' =>3 ,'field' => 'phone'), array( 'db' => 'email', 'dt' => 4 ,'field' => 'email'), array( 'db' => 'ref_no', 'dt' => 5 ,'field' => 'ref_no'), array( 'db' => 'id', 'dt' => 6 ,'formatter' => function ( $d, $row) { global $base_url; $cn = '<div class="btn-group">'; $val = SSP::get_proformas_details($d); if(!$val[0]['is_deleted']) { if($_GET['edit']==1){ $cn .= '<a class="btn btn-xs btn-default" title="" data-toggle="tooltip" href="'.$base_url.'Proformas/edit/'.$d.'" data-original-title="Edit"> <i class="fa fa-pencil"></i></a>'; } if($val[0]['is_approved']==1){ $cn .= '<a class="btn btn-xs btn-default" data-original-title="Report" href="'.$base_url.'Proformas/pdf/'.$d.'" data-toggle="tooltip" title="Download"><i class="gi gi-print"></i></a>'; } } else {