$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
{
