array( 'db' => 'id', 'dt' => 6 ,'field' => 'id','formatter' => function ( $d, $row) {
            
			$val = SSP::get_prequistions_details($d);
			
            if($val[0]['po_generate_type'] == 'Auotmatic'){$cn = '<span class="label label-danger">'.$val[0]['ref_no'].' </span>';}
			elseif($val[0]['po_generate_type'] == 'Manual'){$cn = '<span class="label label-success">'.$val[0]['ref_no'].' </span>';}
			else{$cn = '<span class="label label-warning">'.$val[0]['ref_no'].' </span>';}
			if(!empty($val[0]['ref_no'])) return $cn; 
			
    } ),
    array( 'db' => 'id', 'dt' => 7,'field' => 'id' ,'formatter' => function ( $d, $row) {
		
            global $base_url;
            
            $cn = '<div class="btn-group">';
            $val = SSP::get_prequistions_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.'PurchaseRequisitions/edit/'.$d.'" data-original-title="Edit">
<i class="fa fa-pencil"></i></a>';
                }
				
				 if($_GET['delete']==1){
                    $cn .= '<a class="btn btn-xs btn-danger" title="" data-toggle="tooltip" href="'.$base_url.'PurchaseRequisitions/delete/'.$d.'" data-original-title="Delete">
<i class="fa fa-times"></i></a>';
                }
                if($val[0]['is_manager_approved']==1)
                {
                $cn .= '<a class="btn btn-xs btn-default" title="" data-toggle="tooltip" href="'.$base_url.'PurchaseRequisitions/pdf/'.$d.'" data-original-title="Report">
<i class="gi gi-print"></i></a>';