array( 'db' => 'sales.reg_date', 'dt' => 1 ,'field' => 'reg_date'),
array( 'db' => 'sales.due_date', 'dt' => 2 ,'field' => 'due_date'),
array( 'db' => 'sales.branch_id', 'dt' => 3, 'formatter' => function( $d, $row ) {
return SSP::get_branch_name($d);
},'field' => 'branch_id'),
array( 'db' => 'cus.customername', 'dt' => 4 ,'field' => 'customername'),
array( 'db' => 'sales.attn', 'dt' => 5, 'formatter' => function( $d, $row ) {
return SSP::get_attn_name($d);
},'field' => 'attn'),
array( 'db' => 'sales.phone', 'dt' => 6 ,'field' => 'phone'),
array( 'db' => 'sales.email', 'dt' => 7 ,'field' => 'email'),
array( 'db' => 'sales.quotationno', 'dt' => 8 ,'field' => 'quotationno'),
array( 'db' => 'sales.ref_no', 'dt' => 9 ,'field' => 'ref_no'),
array( 'db' => 'sales.quotation_id', 'dt' => 10, 'formatter' => function( $d, $row ) {
return SSP::get_salesperson_name($d);
},'field' => 'quotation_id'),
array( 'db' => 'sales.id', 'dt' => 11 ,'formatter' => function ( $d, $row) {
global $base_url;
$cn = '<div class="btn-group" style="white-space: nowrap; width: 100px;">';
$val = SSP::get_sales_details($d);
if(!$val[0]['is_deleted'])
{
if($_GET['edit']==1){
$cn .= '<a class="btn btn-xs btn-default" title="Edit" data-toggle="tooltip" href="'.$base_url.'Salesorders/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="Delete" data-toggle="tooltip" href="'.$base_url.'Salesorders/delete/'.$d.'" data-original-title="Delete">
