return SSP::get_branch_name($d); } , 'field' => 'branch_id'), array( 'db' => 'inv.customername', 'dt' => 3 , 'field' => 'customername'), array( 'db' => 'inv.regaddress', 'dt' => 4 , 'field' => 'regaddress'), array( 'db' => 'inv.regaddress', 'dt' => 5 , 'field' => 'regaddress'), array( 'db' => 'inv.contactpersonname', 'dt' => 6 , 'field' => 'contactpersonname'), array( 'db' => 'inv.phone', 'dt' => 7 , 'field' => 'phone'), array( 'db' => 'inv.email', 'dt' => 8 , 'field' => 'email' ), array( 'db' => '', 'dt' => 9 , 'field' => '' ), array( 'db' => 'inv.salesorder_id', 'dt' => 10 , 'field' => 'salesorder_id' ), array( 'db' => 'inv.deliveryorder_id', 'dt' => 11 , 'field' => 'deliveryorder_id'), array( 'db' => 'inv.quotation_id', 'dt' => 12 , 'field' => 'quotation_id'), array( 'db' => 'inv.ref_no', 'dt' => 13 , 'field' => 'ref_no'), array( 'db' => 'inv.quotation_id', 'dt' => 14, 'formatter' => function( $d, $row ) { return SSP::get_quo_inv_device_total($d); } , 'field' => 'quotation_id'), array( 'db' => 'inv.invoiceno', 'dt' => 12 ,'formatter' => function ( $d, $row) { global $base_url; $cn = '<div class="btn-group">'; $val = SSP::get_invoice_details($d); if(!$val[0]['is_approved']) { $cn .= '<a class="btn btn-xs btn-default" title="" data-toggle="tooltip" href="'.$base_url.'Invoices/view/'.$d.'" data-original-title="View"> <i class="fa fa-file-text"></i></a>'; $cn .= '<a class="btn btn-xs btn-default" title="" data-toggle="tooltip" href="'.$base_url.'Invoices/pdf/'.$d.'" data-original-title="Report"> <i class="gi gi-print"></i></a>';