{ $where1 = ' AND is_deleted = 1'; $where2 = ' where is_deleted = 1'; } else { $where1 = ' AND is_deleted = 0'; $where2 = ' where is_deleted = 0'; } $columns = array( array( 'db' => 'prequistionno', 'dt' => 0 ,'field' => 'prequistionno'), array( 'db' => 'reg_date', 'dt' => 1 ,'field' => 'reg_date'), array( 'db' => 'branch_id', 'dt' => 2,'field' => 'branch_id','formatter' => function( $d, $row ) { return SSP::get_branchname($d); } ), array( 'db' => 'customername', 'dt' =>3 ,'field' => 'customername'), array( 'db' => 'phone', 'dt' => 4 ,'field' => 'phone'), array( 'db' => 'email', 'dt' => 5 ,'field' => 'email'), 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) {